acymailing / back / dynamics / subscriber / SubscriberAutomationConditions.php

SubscriberAutomationConditions.php in AcyMailing – An Ultimate Newsletter Plugin and Marketing Automation Solution for WordPress 11.0.2, at back/dynamics/subscriber/SubscriberAutomationConditions.php

160 lines 7.1 KB

Raw Download Zip

1	<?php
2
3	use AcyMailing\Classes\UserClass;
4	use AcyMailing\Classes\FieldClass;
5	use AcyMailing\Helpers\AutomationHelper;
6	use AcyMailing\Types\OperatorType;
7
8	trait SubscriberAutomationConditions
9	{
10	public function onAcymDeclareConditions(array &$conditions): void
11	{
12	$userClass = new UserClass();
13	$fieldClass = new FieldClass();
14	$fields = $userClass->getAllColumnsUserAndCustomField();
15	unset($fields['automation']);
16
17	$customFields = $fieldClass->getAllFieldsForUser();
18	$customFieldValues = [];
19	foreach ($customFields as $field) {
20	if (in_array($field->type, ['single_dropdown', 'radio', 'checkbox', 'multiple_dropdown']) && !empty($field->value)) {
21	$values = [];
22	$field->value = json_decode($field->value, true);
23	foreach ($field->value as $value) {
24	$valueTmp = new stdClass();
25	$valueTmp->text = $value['title'];
26	$valueTmp->value = $value['value'];
27	if ($value['disabled'] == 'y') $valueTmp->disable = true;
28	$values[$value['value']] = $valueTmp;
29	}
30	$customFieldValues[$field->id] = '<div class="acym__automation__one-field intext_select_automation cell" style="display: none">';
31	$customFieldValues[$field->id] .= acym_select(
32	$values,
33	'[conditions][__numor__][__numand__][acy_field][value]',
34	null,
35	[
36	'class' => 'acym__select acym__automation__conditions__fields__select',
37	'data-condition-field' => intval($field->id),
38	]
39	);
40	$customFieldValues[$field->id] .= '</div>';
41	} elseif ('date' === $field->type) {
42	ob_start();
43	acym_tooltip(
44	[
45	'hoveredText' => '<input class="acym__automation__one-field acym__automation__conditions__fields__select intext_input_automation cell"
46	type="text"
47	name="[conditions][__numor__][__numand__][acy_field][value]"
48	style="display: none"
49	data-condition-field="'.intval($field->id).'">',
50	'textShownInTooltip' => acym_translation('ACYM_DATE_FORMAT_FILTER'),
51	'classContainer' => 'intext_select_automation cell',
52	]
53	);
54	$customFieldValues[$field->id] = ob_get_clean();
55	}
56	}
57
58	$conditions['user']['acy_field'] = new stdClass();
59	$conditions['user']['acy_field']->name = acym_translation('ACYM_ACYMAILING_FIELD');
60
61	$conditions['user']['acy_field']->option = '<div class="intext_select_automation cell">';
62	$conditions['user']['acy_field']->option .= acym_select(
63	$fields,
64	'acym_condition[conditions][__numor__][__numand__][acy_field][field]',
65	null,
66	['class' => 'acym__select acym__automation__conditions__fields__dropdown']
67	);
68	$conditions['user']['acy_field']->option .= '</div>';
69
70	$conditions['user']['acy_field']->option .= '<div class="intext_select_automation cell">';
71	$operator = new OperatorType();
72	$conditions['user']['acy_field']->option .= $operator->display(
73	'acym_condition[conditions][__numor__][__numand__][acy_field][operator]',
74	'',
75	'acym__automation__conditions__operator__dropdown'
76	);
77	$conditions['user']['acy_field']->option .= '</div>';
78
79	$conditions['user']['acy_field']->option .= '<input class="acym__automation__one-field intext_input_automation cell acym__automation__condition__regular-field"
80	type="text"
81	name="acym_condition[conditions][__numor__][__numand__][acy_field][value]">';
82	$conditions['user']['acy_field']->option .= implode(' ', $customFieldValues);
83	}
84
85	public function onAcymDeclareConditionsScenario(array &$conditions): void
86	{
87	$this->onAcymDeclareConditions($conditions);
88	}
89
90	public function onAcymProcessCondition_acy_field(&$query, &$options, $num, &$conditionNotValid)
91	{
92	$affectedRows = $this->processAcyField($query, $options, $num);
93	if (empty($affectedRows)) $conditionNotValid++;
94	}
95
96	public function onAcymDeclareSummary_conditions(&$automation)
97	{
98	$this->onAcymDeclareSummary_conditionsFilters($automation, 'ACYM_CONDITION_ACY_FIELD_SUMMARY');
99	}
100
101	private function processAcyField(&$query, &$options, $num)
102	{
103	$usersColumns = acym_getColumns('user');
104
105	if (!in_array($options['field'], $usersColumns)) {
106	$fieldClass = new FieldClass();
107	$field = $fieldClass->getOneById($options['field']);
108
109	$fieldType = empty($field->type) ? '' : $field->type;
110
111	$query->leftjoin['userfield'.$num] = ' #__acym_user_has_field as userfield'.$num.' ON userfield'.$num.'.user_id = user.id AND userfield'.$num.'.field_id = '.intval(
112	$options['field']
113	);
114	$query->where[] = $query->convertQuery(
115	'userfield'.$num,
116	'value',
117	$options['operator'],
118	$options['value'],
119	'phone' === $fieldType ? AutomationHelper::TYPE_PHONE : ''
120	);
121	} else {
122	if (in_array($options['field'], ['creation_date', 'confirmation_date', 'last_sent_date', 'last_open_date', 'last_click_date', 'deactivation_date'])) {
123	$options['value'] = acym_replaceDate($options['value']);
124	if (!is_numeric($options['value'])) {
125	$options['value'] = strtotime($options['value']);
126	}
127	$options['value'] = acym_date($options['value'], 'Y-m-d H:i:s');
128	}
129	$query->where[] = $query->convertQuery('user', $options['field'], $options['operator'], $options['value']);
130	}
131
132	return $query->count();
133	}
134
135	private function onAcymDeclareSummary_conditionsFilters(&$automation, $key)
136	{
137	if (!empty($automation['acy_field'])) {
138	$usersColumns = acym_getColumns('user');
139
140	if (!in_array($automation['acy_field']['field'], $usersColumns)) {
141	$fieldClass = new FieldClass();
142	$field = $fieldClass->getOneById($automation['acy_field']['field']);
143	$automation['acy_field']['field'] = $field->name;
144	}
145
146	$automation = acym_translationSprintf(
147	$key,
148	$automation['acy_field']['field'],
149	$automation['acy_field']['operator'],
150	$automation['acy_field']['value']
151	);
152	} elseif (!empty($automation['random'])) {
153	$automation = acym_translationSprintf(
154	'ACYM_RANDOMLY_SELECT_X_SUBSCRIBERS',
155	$automation['random']['number']
156	);
157	}
158	}
159	}
160