| 1 |
<?php |
| 2 |
|
| 3 |
use AcyMailing\Types\OperatorInType; |
| 4 |
use AcyMailing\Types\OperatorType; |
| 5 |
|
| 6 |
trait UserAutomationFilters |
| 7 |
{ |
| 8 |
public function onAcymDeclareFilters(&$filters) |
| 9 |
{ |
| 10 |
$allGroups = acym_getGroups(); |
| 11 |
$groups = ['' => acym_translation('ACYM_NO_GROUP')]; |
| 12 |
foreach ($allGroups as $group) { |
| 13 |
$groups[$group->id] = $group->text; |
| 14 |
} |
| 15 |
$operatorIn = new OperatorInType(); |
| 16 |
|
| 17 |
$filters['acy_group'] = new stdClass(); |
| 18 |
$filters['acy_group']->name = acym_translation('ACYM_GROUP'); |
| 19 |
$filters['acy_group']->option = '<div class="intext_select_automation cell">'; |
| 20 |
$filters['acy_group']->option .= $operatorIn->display('acym_action[filters][__numor__][__numand__][acy_group][in]'); |
| 21 |
$filters['acy_group']->option .= '</div>'; |
| 22 |
$filters['acy_group']->option .= '<div class="intext_select_automation cell">'; |
| 23 |
$filters['acy_group']->option .= acym_select( |
| 24 |
$groups, |
| 25 |
'acym_action[filters][__numor__][__numand__][acy_group][group]', |
| 26 |
null, |
| 27 |
['class' => 'acym__select'] |
| 28 |
); |
| 29 |
$filters['acy_group']->option .= '</div>'; |
| 30 |
|
| 31 |
if (ACYM_CMS == 'joomla') { |
| 32 |
$filters['acy_group']->option .= '<div class="cell grid-x medium-3">'; |
| 33 |
$filters['acy_group']->option .= acym_switch('acym_action[filters][__numor__][__numand__][acy_group][subgroup]', 1, acym_translation('ACYM_INCLUDE_SUB_GROUPS')); |
| 34 |
$filters['acy_group']->option .= '</div>'; |
| 35 |
} |
| 36 |
|
| 37 |
|
| 38 |
$cmsFields = []; |
| 39 |
foreach (acym_getColumns('users', false) as $key => $column) { |
| 40 |
$cmsFields[$column] = $column; |
| 41 |
} |
| 42 |
|
| 43 |
if (ACYM_CMS == 'joomla' && ACYM_J37) { |
| 44 |
$query = 'SELECT id, title |
| 45 |
FROM #__fields |
| 46 |
WHERE context = "com_users.user" |
| 47 |
AND state = 1 |
| 48 |
AND type IN ("calendar", "checkboxes", "color", "integer", "list", "radio", "sql", "text", "url") |
| 49 |
ORDER BY title ASC'; |
| 50 |
$customFields = acym_loadObjectList($query); |
| 51 |
foreach ($customFields as $oneCF) { |
| 52 |
$cmsFields['cf_'.$oneCF->id] = $oneCF->title; |
| 53 |
} |
| 54 |
} |
| 55 |
$excluded = ['password', 'params', 'activation', 'lastResetTime', 'resetCount', 'optKey', 'otep', 'requireReset', 'user_pass', 'user_activation_key']; |
| 56 |
foreach ($excluded as $oneExcluded) { |
| 57 |
unset($cmsFields[$oneExcluded]); |
| 58 |
} |
| 59 |
|
| 60 |
$operator = new OperatorType(); |
| 61 |
|
| 62 |
$filters['acy_cmsfield'] = new stdClass(); |
| 63 |
$filters['acy_cmsfield']->name = acym_translation('ACYM_ACCOUNT_USER_FIELD'); |
| 64 |
$filters['acy_cmsfield']->option = '<div class="intext_select_automation cell">'; |
| 65 |
$filters['acy_cmsfield']->option .= acym_select( |
| 66 |
$cmsFields, |
| 67 |
'acym_action[filters][__numor__][__numand__][acy_cmsfield][field]', |
| 68 |
null, |
| 69 |
['class' => 'acym__select'] |
| 70 |
); |
| 71 |
$filters['acy_cmsfield']->option .= '</div>'; |
| 72 |
$filters['acy_cmsfield']->option .= '<div class="intext_select_automation cell">'; |
| 73 |
$filters['acy_cmsfield']->option .= $operator->display('acym_action[filters][__numor__][__numand__][acy_cmsfield][operator]'); |
| 74 |
$filters['acy_cmsfield']->option .= '</div>'; |
| 75 |
$filters['acy_cmsfield']->option .= '<input class="intext_input_automation cell" type="text" name="acym_action[filters][__numor__][__numand__][acy_cmsfield][value]">'; |
| 76 |
} |
| 77 |
|
| 78 |
public function onAcymProcessFilter_acy_group(&$query, $options, $num) |
| 79 |
{ |
| 80 |
$this->_processAcyGroup($query, $options, $num); |
| 81 |
} |
| 82 |
|
| 83 |
public function onAcymProcessFilterCount_acy_group(&$query, $options, $num) |
| 84 |
{ |
| 85 |
$this->onAcymProcessFilter_acy_group($query, $options, $num); |
| 86 |
|
| 87 |
return acym_translationSprintf('ACYM_SELECTED_USERS', $query->count()); |
| 88 |
} |
| 89 |
|
| 90 |
public function onAcymProcessFilter_acy_cmsfield(&$query, $options, $num) |
| 91 |
{ |
| 92 |
$this->_processAcyCMSField($query, $options, $num); |
| 93 |
} |
| 94 |
|
| 95 |
public function onAcymProcessFilterCount_acy_cmsfield(&$query, $options, $num) |
| 96 |
{ |
| 97 |
$this->onAcymProcessFilter_acy_cmsfield($query, $options, $num); |
| 98 |
|
| 99 |
return acym_translationSprintf('ACYM_SELECTED_USERS', $query->count()); |
| 100 |
} |
| 101 |
|
| 102 |
public function onAcymDeclareSummary_filters(&$automation) |
| 103 |
{ |
| 104 |
$this->_summaryGroup($automation); |
| 105 |
|
| 106 |
if (!empty($automation['acy_cmsfield'])) { |
| 107 |
$automation = acym_translationSprintf( |
| 108 |
'ACYM_FILTER_ACY_CMS_FIELD_SUMMARY', |
| 109 |
$automation['acy_cmsfield']['field'], |
| 110 |
$automation['acy_cmsfield']['operator'], |
| 111 |
$automation['acy_cmsfield']['value'] |
| 112 |
); |
| 113 |
} |
| 114 |
} |
| 115 |
|
| 116 |
public function onAcymProcessFilter_birthday(&$query, $options, $num = null) |
| 117 |
{ |
| 118 |
if ($options['plugin'] !== get_class($this) || ACYM_CMS !== 'joomla' || !ACYM_J37) return; |
| 119 |
|
| 120 |
$dateToCheck = $this->processDateToCheck($options); |
| 121 |
|
| 122 |
$query->join['j_fields'.$num] = '#__fields_values AS jf'.$num.' ON jf'.$num.'.item_id = user.cms_id AND jf'.$num.'.field_id = '.intval($options['field']); |
| 123 |
$query->where[] = 'user.cms_id != 0 '; |
| 124 |
$query->where[] = 'jf'.$num.'.value LIKE '.acym_escapeDB('%'.date_format($dateToCheck, '-m-d').'%'); |
| 125 |
} |
| 126 |
} |
| 127 |
|
