| 1 |
<?php |
| 2 |
|
| 3 |
namespace AcyMailing\Classes; |
| 4 |
|
| 5 |
use AcyMailing\Helpers\PaginationHelper; |
| 6 |
use AcyMailing\Core\AcymClass; |
| 7 |
|
| 8 |
class ScenarioHistoryLineClass extends AcymClass |
| 9 |
{ |
| 10 |
public function __construct() |
| 11 |
{ |
| 12 |
parent::__construct(); |
| 13 |
|
| 14 |
$this->table = 'scenario_history_line'; |
| 15 |
$this->pkey = 'id'; |
| 16 |
} |
| 17 |
|
| 18 |
public function save($element) |
| 19 |
{ |
| 20 |
if (isset($element->params) && is_array($element->params)) { |
| 21 |
$element->params = json_encode($element->params); |
| 22 |
} |
| 23 |
|
| 24 |
return parent::save($element); |
| 25 |
} |
| 26 |
|
| 27 |
private function formatHistoryLine($historyLine) |
| 28 |
{ |
| 29 |
if (!empty($historyLine->params)) { |
| 30 |
$historyLine->params = json_decode($historyLine->params); |
| 31 |
} |
| 32 |
|
| 33 |
return $historyLine; |
| 34 |
} |
| 35 |
|
| 36 |
public function getAllByProcessId(int $processId): array |
| 37 |
{ |
| 38 |
return array_map([$this, 'formatHistoryLine'], acym_loadObjectList('SELECT * FROM #__acym_scenario_history_line WHERE scenario_process_id = '.$processId, 'id')); |
| 39 |
} |
| 40 |
|
| 41 |
public function getMatchingElements(array $settings = []): array |
| 42 |
{ |
| 43 |
$results = []; |
| 44 |
|
| 45 |
$query = 'SELECT history_line.*, `user`.email, `user`.id AS user_id FROM #__acym_scenario_history_line AS history_line'; |
| 46 |
$queryCount = 'SELECT COUNT(history_line.id) FROM #__acym_scenario_history_line AS history_line'; |
| 47 |
$filters = []; |
| 48 |
|
| 49 |
$joins = [ |
| 50 |
'JOIN #__acym_scenario_process AS scenario_process ON history_line.scenario_process_id = scenario_process.id', |
| 51 |
'JOIN #__acym_user AS `user` ON scenario_process.user_id = `user`.id', |
| 52 |
]; |
| 53 |
|
| 54 |
if (!empty($joins)) { |
| 55 |
$query .= ' '.implode(' ', $joins); |
| 56 |
$queryCount .= ' '.implode(' ', $joins); |
| 57 |
} |
| 58 |
|
| 59 |
if (!empty($settings['stepId'])) { |
| 60 |
$filters[] = 'history_line.scenario_step_id = '.acym_escapeDB($settings['stepId']); |
| 61 |
|
| 62 |
$results['totalOverall'] = acym_loadResult('SELECT COUNT(*) FROM #__acym_scenario_history_line WHERE scenario_step_id = '.acym_escapeDB($settings['stepId'])); |
| 63 |
} |
| 64 |
|
| 65 |
if (!empty($settings['search'])) { |
| 66 |
$searchValue = acym_escapeDB('%'.$settings['search'].'%'); |
| 67 |
$filters[] = 'user.name LIKE '.$searchValue.' OR user.email LIKE '.$searchValue; |
| 68 |
} |
| 69 |
|
| 70 |
if (!empty($filters)) { |
| 71 |
$query .= ' WHERE ('.implode(') AND (', $filters).')'; |
| 72 |
$queryCount .= ' WHERE ('.implode(') AND (', $filters).')'; |
| 73 |
} |
| 74 |
|
| 75 |
if (empty($settings['offset']) || $settings['offset'] < 0) { |
| 76 |
$settings['offset'] = 0; |
| 77 |
} |
| 78 |
|
| 79 |
if (empty($settings['elementsPerPage']) || $settings['elementsPerPage'] < 1) { |
| 80 |
$pagination = new PaginationHelper(); |
| 81 |
$settings['elementsPerPage'] = $pagination->getListLimit(); |
| 82 |
} |
| 83 |
|
| 84 |
$results['elements'] = acym_loadObjectList($query, 'id', $settings['offset'], $settings['elementsPerPage']); |
| 85 |
$results['total'] = acym_loadResult($queryCount); |
| 86 |
|
| 87 |
return $results; |
| 88 |
} |
| 89 |
} |
| 90 |
|
