← All changes | back/Classes/RuleClass.php +68 -0 10.1.0 → 11.1.0 View file →

		@@ -1,0 +1,68 @@
	1	+<?php
	2	+
	3	+namespace AcyMailing\Classes;
	4	+
	5	+use AcyMailing\Core\AcymClass;
	6	+
	7	+class RuleClass extends AcymClass
	8	+{
	9	+ public const FINAL_RULE_ID = 17;
	10	+
	11	+ public function __construct()
	12	+ {
	13	+ parent::__construct();
	14	+
	15	+ $this->table = 'rule';
	16	+ $this->pkey = 'id';
	17	+ }
	18	+
	19	+ public function getAll(?string $key = null): array
	20	+ {
	21	+ $rules = acym_loadObjectList('SELECT * FROM `#__acym_rule` ORDER BY `ordering` ASC');
	22	+
	23	+ foreach ($rules as $i => $rule) {
	24	+ $rules[$i] = $this->prepareRule($rule);
	25	+ }
	26	+
	27	+ return $rules;
	28	+ }
	29	+
	30	+ public function getOneById(int $id): ?object
	31	+ {
	32	+ $rule = acym_loadObject('SELECT * FROM `#__acym_rule` WHERE `id` = '.intval($id));
	33	+
	34	+ return empty($rule) ? null : $this->prepareRule($rule);
	35	+ }
	36	+
	37	+ private function prepareRule(object $rule): object
	38	+ {
	39	+ //We have a rule from the database, let's prepare it to be displayed nicely
	40	+ $columns = ['executed_on', 'action_message', 'action_user'];
	41	+ foreach ($columns as $oneColumn) {
	42	+ if (!empty($rule->$oneColumn)) {
	43	+ $rule->$oneColumn = json_decode($rule->$oneColumn, true);
	44	+ }
	45	+ }
	46	+
	47	+ return $rule;
	48	+ }
	49	+
	50	+ public function save(object $element): ?int
	51	+ {
	52	+ if (empty($element)) {
	53	+ return null;
	54	+ }
	55	+
	56	+ return parent::save($element);
	57	+ }
	58	+
	59	+ public function getOrderingNumber(): int
	60	+ {
	61	+ return (int)acym_loadResult('SELECT COUNT(`id`) FROM #__acym_rule');
	62	+ }
	63	+
	64	+ public function cleanTable(): void
	65	+ {
	66	+ acym_query('TRUNCATE TABLE `#__acym_rule`');
	67	+ }
	68	+}