← All changes | back/dynamics/user/UserAutomationConditions.php +331 -0 10.2.0 → 11.1.0 View file →

		@@ -1,0 +1,331 @@
	1	+<?php
	2	+
	3	+use AcyMailing\Helpers\AutomationHelper;
	4	+use AcyMailing\Types\OperatorInType;
	5	+use AcyMailing\Types\OperatorType;
	6	+
	7	+trait UserAutomationConditions
	8	+{
	9	+ protected function initAutomationConditions(): void
	10	+ {
	11	+ $this->automationConditions = [
	12	+ 'user' => [
	13	+ 'acy_group' => acym_translation('ACYM_GROUP'),
	14	+ 'acy_cmsfield' => acym_translation('ACYM_ACCOUNT_USER_FIELD'),
	15	+ ],
	16	+ 'classic' => [
	17	+ 'acy_totaluser' => acym_translation('ACYM_NUMBER_OF_SUBSCRIBERS'),
	18	+ ],
	19	+ 'both' => [
	20	+ 'acy_toss' => acym_translation('ACYM_TOSS'),
	21	+ ],
	22	+ ];
	23	+ }
	24	+
	25	+ public function displayConditionOptions_acy_group(string $fieldName): void
	26	+ {
	27	+ $allGroups = acym_getGroups();
	28	+ $groups = ['' => acym_translation('ACYM_NO_GROUP')];
	29	+ foreach ($allGroups as $group) {
	30	+ $groups[$group->id] = $group->text;
	31	+ }
	32	+ $operatorIn = new OperatorInType();
	33	+ ?>
	34	+ <div class="intext_select_automation cell">
	35	+ <?php $operatorIn->display($fieldName.'[in]', '', 'acym__select', true); ?>
	36	+ </div>
	37	+ <div class="intext_select_automation cell">
	38	+ <?php acym_select(
	39	+ $groups,
	40	+ $fieldName.'[group]',
	41	+ null,
	42	+ ['class' => 'acym__select'],
	43	+ 'value',
	44	+ 'text',
	45	+ null,
	46	+ false,
	47	+ true
	48	+ ); ?>
	49	+ </div>
	50	+ <?php if (ACYM_CMS === 'joomla') { ?>
	51	+ <div class="cell grid-x medium-3">
	52	+ <?php acym_switch([
	53	+ 'name' => $fieldName.'[subgroup]',
	54	+ 'value' => 1,
	55	+ 'label' => acym_translation('ACYM_INCLUDE_SUB_GROUPS'),
	56	+ // One switch per row of the form, the JS replaces the placeholder to keep the ids unique
	57	+ 'idPrefix' => '__numand__',
	58	+ ]); ?>
	59	+ </div>
	60	+ <?php }
	61	+ }
	62	+
	63	+ private function getCmsFieldsForConditions(): array
	64	+ {
	65	+ $cmsFields = [];
	66	+ foreach (acym_getColumns('users', false) as $key => $column) {
	67	+ $cmsFields[$column] = $column;
	68	+ }
	69	+
	70	+ // Handle custom fields
	71	+ if (ACYM_CMS == 'joomla' && ACYM_J37) {
	72	+ $query = 'SELECT id, title
	73	+ FROM #__fields
	74	+ WHERE context = "com_users.user"
	75	+ AND state = 1
	76	+ AND type IN ("calendar", "checkboxes", "color", "integer", "list", "radio", "sql", "text", "url")
	77	+ ORDER BY title ASC';
	78	+ $customFields = acym_loadObjectList($query);
	79	+ foreach ($customFields as $oneCF) {
	80	+ $cmsFields['cf_'.$oneCF->id] = $oneCF->title;
	81	+ }
	82	+ }
	83	+ $excluded = ['password', 'params', 'activation', 'lastResetTime', 'resetCount', 'optKey', 'otep', 'requireReset', 'user_pass', 'user_activation_key'];
	84	+ foreach ($excluded as $oneExcluded) {
	85	+ unset($cmsFields[$oneExcluded]);
	86	+ }
	87	+
	88	+ return $cmsFields;
	89	+ }
	90	+
	91	+ public function displayConditionOptions_acy_cmsfield(string $fieldName): void
	92	+ {
	93	+ $operator = new OperatorType();
	94	+ ?>
	95	+ <div class="intext_select_automation cell">
	96	+ <?php acym_select(
	97	+ $this->getCmsFieldsForConditions(),
	98	+ $fieldName.'[field]',
	99	+ null,
	100	+ ['class' => 'acym__select'],
	101	+ 'value',
	102	+ 'text',
	103	+ null,
	104	+ false,
	105	+ true
	106	+ ); ?>
	107	+ </div>
	108	+ <div class="intext_select_automation cell">
	109	+ <?php $operator->display($fieldName.'[operator]', '', 'acym__select', true); ?>
	110	+ </div>
	111	+ <input class="intext_input_automation cell" type="text" name="<?php echo esc_attr($fieldName.'[value]'); ?>">
	112	+ <?php
	113	+ }
	114	+
	115	+ public function displayConditionOptions_acy_totaluser(string $fieldName): void
	116	+ {
	117	+ ?>
	118	+ <div class="cell shrink acym__automation__inner__text"><?php echo esc_html(acym_translation('ACYM_THERE_IS')); ?></div>
	119	+ <div class="intext_select_automation cell">
	120	+ <?php acym_select(
	121	+ [
	122	+ '=' => acym_translation('ACYM_EXACTLY'),
	123	+ '>' => acym_translation('ACYM_MORE_THAN'),
	124	+ '<' => acym_translation('ACYM_LESS_THAN'),
	125	+ ],
	126	+ $fieldName.'[operator]',
	127	+ null,
	128	+ ['class' => 'intext_select_automation acym__select'],
	129	+ 'value',
	130	+ 'text',
	131	+ null,
	132	+ false,
	133	+ true
	134	+ ); ?>
	135	+ </div>
	136	+ <input type="number" min="0" class="intext_input_automation cell" name="<?php echo esc_attr($fieldName.'[number]'); ?>">
	137	+ <div class="cell shrink acym__automation__inner__text"><?php echo esc_html(acym_translation('ACYM_ACYMAILING_USERS')); ?></div>
	138	+ <?php
	139	+ }
	140	+
	141	+ public function displayConditionOptions_acy_toss(string $fieldName): void
	142	+ {
	143	+ ?>
	144	+ <input type="hidden" name="<?php echo esc_attr($fieldName.'[toss]'); ?>" value="true">
	145	+ <div class="acym__automation__inner__text"><?php echo esc_html(acym_translation('ACYM_TOSS_DESC')); ?></div>
	146	+ <?php
	147	+ }
	148	+
	149	+ public function onAcymProcessCondition_acy_toss(&$query, $option, $num, &$conditionNotValid)
	150	+ {
	151	+ if (!acym_rand(0, 1)) $conditionNotValid++;
	152	+ }
	153	+
	154	+ public function onAcymProcessCondition_acy_totaluser(&$query, $option, $num, &$conditionNotValid)
	155	+ {
	156	+ $numberUsers = $query->count();
	157	+ $res = false;
	158	+
	159	+ switch ($option['operator']) {
	160	+ case '=':
	161	+ $res = $numberUsers == $option['number'];
	162	+ break;
	163	+ case '>':
	164	+ $res = $numberUsers > $option['number'];
	165	+ break;
	166	+ case '<':
	167	+ $res = $numberUsers < $option['number'];
	168	+ break;
	169	+ }
	170	+
	171	+ if (!$res) $conditionNotValid++;
	172	+ }
	173	+
	174	+ public function onAcymProcessCondition_acy_group(&$query, $options, $num, &$conditionNotValid)
	175	+ {
	176	+ $affectedRows = $this->processAcyGroup($query, $options, $num);
	177	+ if (empty($affectedRows)) $conditionNotValid++;
	178	+ }
	179	+
	180	+ private function processAcyGroup(&$query, $options, $num)
	181	+ {
	182	+ if (empty($options['group'])) {
	183	+ if (ACYM_CMS === 'joomla') {
	184	+ $operator = (empty($options['in']) || $options['in'] === 'in') ? 'IS NULL' : 'IS NOT NULL AND cmsuser'.$num.'.user_id != 0';
	185	+ $query->leftjoin['cmsuser'.$num] = '#__user_usergroup_map AS cmsuser'.$num.'
	186	+ ON cmsuser'.$num.'.user_id = user.cms_id ';
	187	+ } else {
	188	+ $operator = (empty($options['in']) || $options['in'] === 'in') ? 'IS NOT NULL AND cmsuser'.$num.'.user_id != 0' : 'IS NULL AND user.cms_id != 0';
	189	+ $query->leftjoin['cmsuser'.$num] = '#__usermeta AS cmsuser'.$num.'
	190	+ ON cmsuser'.$num.'.user_id = user.cms_id
	191	+ AND cmsuser'.$num.'.meta_key = "#__capabilities"
	192	+ AND cmsuser'.$num.'.meta_value = "a:0:{}"';
	193	+ }
	194	+ } else {
	195	+ $operator = (empty($options['in']) || $options['in'] === 'in') ? 'IS NOT NULL AND cmsuser'.$num.'.user_id != 0' : 'IS NULL';
	196	+
	197	+ if (ACYM_CMS === 'joomla') {
	198	+ if (empty($options['subgroup'])) {
	199	+ $value = ' = '.intval($options['group']);
	200	+ } else {
	201	+ $lftrgt = acym_loadObject('SELECT lft, rgt FROM #__usergroups WHERE id = '.intval($options['group']));
	202	+ $allSubGroups = acym_loadResultArray('SELECT id FROM #__usergroups WHERE lft > '.intval($lftrgt->lft).' AND rgt < '.intval($lftrgt->rgt));
	203	+ array_unshift($allSubGroups, intval($options['group']));
	204	+ $value = ' IN ('.implode(', ', $allSubGroups).')';
	205	+ }
	206	+
	207	+ $query->leftjoin['cmsuser'.$num] = '#__user_usergroup_map AS cmsuser'.$num.'
	208	+ ON cmsuser'.$num.'.user_id = user.cms_id
	209	+ AND cmsuser'.$num.'.group_id'.$value;
	210	+ } else {
	211	+ $query->leftjoin['cmsuser'.$num] = '#__usermeta AS cmsuser'.$num.'
	212	+ ON cmsuser'.$num.'.user_id = user.cms_id
	213	+ AND cmsuser'.$num.'.meta_key = "#__capabilities"
	214	+ AND cmsuser'.$num.'.meta_value LIKE '.acym_escapeDB('%'.strlen($options['group']).':"'.acym_secureDBColumn($options['group']).'"%');
	215	+ }
	216	+ }
	217	+
	218	+ $query->where[] = 'cmsuser'.$num.'.user_id '.$operator;
	219	+
	220	+ return $query->count();
	221	+ }
	222	+
	223	+ public function onAcymProcessCondition_acy_cmsfield(&$query, $options, $num, &$conditionNotValid)
	224	+ {
	225	+ $affectedRows = $this->processAcyCMSField($query, $options, $num);
	226	+ if (empty($affectedRows)) $conditionNotValid++;
	227	+ }
	228	+
	229	+ private function processAcyCMSField(&$query, $options, $num)
	230	+ {
	231	+ if (empty($options['field'])) {
	232	+ return;
	233	+ }
	234	+
	235	+ // Handle custom fields
	236	+ if (strpos($options['field'], 'cf_') !== false) {
	237	+ $cfId = substr($options['field'], 3);
	238	+ $query->leftjoin['cmsuserfields'.$num] = '#__fields_values AS cmsuserfields'.$num.' ON cmsuserfields'.$num.'.item_id = user.cms_id AND cmsuserfields'.$num.'.field_id = '.intval(
	239	+ $cfId
	240	+ );
	241	+ $query->where[] = $query->convertQuery('cmsuserfields'.$num, 'value', $options['operator'], $options['value']);
	242	+ } else {
	243	+ // Handle normal fields
	244	+ $type = '';
	245	+ $query->leftjoin['cmsuser'.$num] = '#__users AS cmsuser'.$num.' ON cmsuser'.$num.'.id = user.cms_id';
	246	+
	247	+ if (in_array($options['field'], ['registerDate', 'lastvisitDate', 'user_registered'])) {
	248	+ $type = AutomationHelper::TYPE_DATETIME;
	249	+ $options['value'] = acym_replaceDate($options['value']);
	250	+
	251	+ if (!is_numeric($options['value']) && strtotime($options['value']) !== false) {
	252	+ $options['value'] = strtotime($options['value']);
	253	+ }
	254	+ if (is_numeric($options['value'])) {
	255	+ $options['value'] = gmdate('Y-m-d H:i:s', $options['value']);
	256	+ }
	257	+ }
	258	+
	259	+ $query->where[] = $query->convertQuery(
	260	+ 'cmsuser'.$num,
	261	+ $options['field'],
	262	+ $options['operator'],
	263	+ $options['value'],
	264	+ $type
	265	+ );
	266	+ }
	267	+
	268	+ return $query->count();
	269	+ }
	270	+
	271	+ public function onAcymDeclareSummary_conditions(&$automation)
	272	+ {
	273	+ $this->summaryGroup($automation);
	274	+
	275	+ if (!empty($automation['acy_cmsfield'])) {
	276	+ $automation = acym_translationSprintf(
	277	+ 'ACYM_CONDITION_ACY_CMS_FIELD_SUMMARY',
	278	+ $automation['acy_cmsfield']['field'],
	279	+ $automation['acy_cmsfield']['operator'],
	280	+ $automation['acy_cmsfield']['value']
	281	+ );
	282	+ }
	283	+
	284	+ if (!empty($automation['acy_totaluser'])) {
	285	+ $operators = ['=' => acym_translation('ACYM_EXACTLY'), '>' => acym_translation('ACYM_MORE_THAN'), '<' => acym_translation('ACYM_LESS_THAN')];
	286	+ $automation = acym_translation('ACYM_THERE_IS').' '.acym_strtolower(
	287	+ $operators[$automation['acy_totaluser']['operator']]
	288	+ ).' '.$automation['acy_totaluser']['number'].' '.acym_translation('ACYM_ACYMAILING_USERS').' ';
	289	+ }
	290	+
	291	+ if (!empty($automation['acy_toss'])) {
	292	+ $automation = acym_translation('ACYM_TOSS_DESC');
	293	+ }
	294	+ }
	295	+
	296	+ private function summaryGroup(&$automation)
	297	+ {
	298	+ if (empty($automation['acy_group'])) return;
	299	+
	300	+ if ('joomla' === ACYM_CMS) {
	301	+ $allGroups = acym_getGroups();
	302	+ $groups = [];
	303	+ foreach ($allGroups as $group) {
	304	+ if ($automation['acy_group']['group'] == $group->id) {
	305	+ $automation['acy_group']['group'] = $group->text;
	306	+ }
	307	+ $groups[$group->id] = $group->text;
	308	+ }
	309	+ } else {
	310	+ $groupKey = 'ACYM_'.strtoupper($automation['acy_group']['group']);
	311	+ if (acym_translationExists($groupKey)) {
	312	+ $automation['acy_group']['group'] = $groupKey;
	313	+ }
	314	+ }
	315	+
	316	+ if (empty($automation['acy_group']['group'])) {
	317	+ $automation['acy_group']['group'] = acym_translation('ACYM_NO_GROUP');
	318	+ }
	319	+
	320	+ $finalText = acym_translationSprintf(
	321	+ 'ACYM_FILTER_ACY_GROUP_SUMMARY',
	322	+ acym_translation($automation['acy_group']['in'] == 'in' ? 'ACYM_IN' : 'ACYM_NOT_IN'),
	323	+ acym_translation($automation['acy_group']['group'])
	324	+ );
	325	+ if ('joomla' === ACYM_CMS) {
	326	+ $finalText .= $automation['acy_group']['subgroup'] == 1 ? ' '.acym_translation('ACYM_FILTER_ACY_GROUP_SUBGROUP_SUMMARY') : '';
	327	+ }
	328	+
	329	+ $automation = $finalText;
	330	+ }
	331	+}