← All changes | back/Classes/ScenarioProcessClass.php +0 -93 10.2.2 → 11.1.1 View file →

		@@ -1,93 +1,0 @@
1		-<?php
2		-
3		-namespace AcyMailing\Classes;
4		-
5		-use AcyMailing\Helpers\PaginationHelper;
6		-use AcyMailing\Core\AcymClass;
7		-
8		-class ScenarioProcessClass extends AcymClass
9		-{
10		- public function __construct()
11		- {
12		- parent::__construct();
13		-
14		- $this->table = 'scenario_process';
15		- $this->pkey = 'id';
16		- }
17		-
18		- public function getOneByScenarioIdUserId(int $scenarioId, int $userId)
19		- {
20		- $query = 'SELECT * FROM #__acym_scenario_process WHERE scenario_id = '.$scenarioId.' AND user_id = '.$userId;
21		-
22		- return acym_loadResult($query);
23		- }
24		-
25		- public function endProcess(int $scenarioProcessId)
26		- {
27		- $scenarioProcess = new \stdClass();
28		- $scenarioProcess->id = $scenarioProcessId;
29		- $scenarioProcess->end_at = acym_date('now', 'Y-m-d H:i:s', false);
30		-
31		- $this->save($scenarioProcess);
32		- }
33		-
34		- public function getNumberOfTriggerByScenarioId(int $scenarioId)
35		- {
36		- $numberOfTrigger = acym_loadResult('SELECT COUNT(*) FROM #__acym_scenario_process WHERE scenario_id = '.$scenarioId);
37		-
38		- if (empty($numberOfTrigger)) {
39		- return 0;
40		- }
41		-
42		- return $numberOfTrigger;
43		- }
44		-
45		-
46		- public function getMatchingElements(array $settings = []): array
47		- {
48		- $results = [];
49		-
50		- $query = 'SELECT DISTINCT scenario_process.*, user.email FROM #__acym_scenario_process AS `scenario_process`';
51		- $queryCount = 'SELECT COUNT(DISTINCT scenario_process.id) AS total FROM #__acym_scenario_process AS scenario_process';
52		- $filters = [];
53		-
54		- $joins = [
55		- 'JOIN #__acym_user AS user ON user.id = scenario_process.user_id',
56		- ];
57		-
58		- if (!empty($joins)) {
59		- $query .= ' '.implode(' ', $joins);
60		- $queryCount .= ' '.implode(' ', $joins);
61		- }
62		-
63		- if (!empty($settings['scenarioId'])) {
64		- $filters[] = 'scenario_process.scenario_id = '.intval($settings['scenarioId']);
65		-
66		- $results['totalOverall'] = acym_loadResult('SELECT COUNT(*) FROM #__acym_scenario_process WHERE scenario_id = '.intval($settings['scenarioId']));
67		- }
68		-
69		- if (!empty($settings['search'])) {
70		- $searchValue = acym_escapeDB('%'.$settings['search'].'%');
71		- $filters[] = 'user.name LIKE '.$searchValue.' OR user.email LIKE '.$searchValue;
72		- }
73		-
74		- if (!empty($filters)) {
75		- $query .= ' WHERE ('.implode(') AND (', $filters).')';
76		- $queryCount .= ' WHERE ('.implode(') AND (', $filters).')';
77		- }
78		-
79		- if (empty($settings['offset']) || $settings['offset'] < 0) {
80		- $settings['offset'] = 0;
81		- }
82		-
83		- if (empty($settings['elementsPerPage']) || $settings['elementsPerPage'] < 1) {
84		- $pagination = new PaginationHelper();
85		- $settings['elementsPerPage'] = $pagination->getListLimit();
86		- }
87		-
88		- $results['elements'] = acym_loadObjectList($query, 'id', $settings['offset'], $settings['elementsPerPage']);
89		- $results['total'] = acym_loadObject($queryCount);
90		-
91		- return $results;
92		- }
93		-}