getAllColumnsUserAndCustomField();
unset($fields['automation']);
$customFields = $fieldClass->getAllFieldsForUser();
$customFieldValues = [];
foreach ($customFields as $field) {
if (in_array($field->type, ['single_dropdown', 'radio', 'checkbox', 'multiple_dropdown']) && !empty($field->value)) {
$values = [];
$field->value = json_decode($field->value, true);
foreach ($field->value as $value) {
$valueTmp = new stdClass();
$valueTmp->text = $value['title'];
$valueTmp->value = $value['value'];
if ($value['disabled'] == 'y') $valueTmp->disable = true;
$values[$value['value']] = $valueTmp;
}
$customFieldValues[$field->id] = '';
$customFieldValues[$field->id] .= acym_select(
$values,
'[conditions][__numor__][__numand__][acy_field][value]',
null,
[
'class' => 'acym__select acym__automation__conditions__fields__select',
'data-condition-field' => intval($field->id),
]
);
$customFieldValues[$field->id] .= '
';
} elseif ('date' === $field->type) {
ob_start();
acym_tooltip(
[
'hoveredText' => '',
'textShownInTooltip' => acym_translation('ACYM_DATE_FORMAT_FILTER'),
'classContainer' => 'intext_select_automation cell',
]
);
$customFieldValues[$field->id] = ob_get_clean();
}
}
$conditions['user']['acy_field'] = new stdClass();
$conditions['user']['acy_field']->name = acym_translation('ACYM_ACYMAILING_FIELD');
$conditions['user']['acy_field']->option = '';
$conditions['user']['acy_field']->option .= acym_select(
$fields,
'acym_condition[conditions][__numor__][__numand__][acy_field][field]',
null,
['class' => 'acym__select acym__automation__conditions__fields__dropdown']
);
$conditions['user']['acy_field']->option .= '
';
$conditions['user']['acy_field']->option .= '';
$operator = new OperatorType();
$conditions['user']['acy_field']->option .= $operator->display(
'acym_condition[conditions][__numor__][__numand__][acy_field][operator]',
'',
'acym__automation__conditions__operator__dropdown'
);
$conditions['user']['acy_field']->option .= '
';
$conditions['user']['acy_field']->option .= '';
$conditions['user']['acy_field']->option .= implode(' ', $customFieldValues);
}
public function onAcymDeclareConditionsScenario(array &$conditions): void
{
$this->onAcymDeclareConditions($conditions);
}
public function onAcymProcessCondition_acy_field(&$query, &$options, $num, &$conditionNotValid)
{
$affectedRows = $this->processAcyField($query, $options, $num);
if (empty($affectedRows)) $conditionNotValid++;
}
public function onAcymDeclareSummary_conditions(&$automation)
{
$this->onAcymDeclareSummary_conditionsFilters($automation, 'ACYM_CONDITION_ACY_FIELD_SUMMARY');
}
private function processAcyField(&$query, &$options, $num)
{
$usersColumns = acym_getColumns('user');
if (!in_array($options['field'], $usersColumns)) {
$fieldClass = new FieldClass();
$field = $fieldClass->getOneById($options['field']);
$fieldType = empty($field->type) ? '' : $field->type;
$query->leftjoin['userfield'.$num] = ' #__acym_user_has_field as userfield'.$num.' ON userfield'.$num.'.user_id = user.id AND userfield'.$num.'.field_id = '.intval(
$options['field']
);
$query->where[] = $query->convertQuery(
'userfield'.$num,
'value',
$options['operator'],
$options['value'],
'phone' === $fieldType ? AutomationHelper::TYPE_PHONE : ''
);
} else {
if (in_array($options['field'], ['creation_date', 'confirmation_date', 'last_sent_date', 'last_open_date', 'last_click_date', 'deactivation_date'])) {
$options['value'] = acym_replaceDate($options['value']);
if (!is_numeric($options['value'])) {
$options['value'] = strtotime($options['value']);
}
$options['value'] = acym_date($options['value'], 'Y-m-d H:i:s');
}
$query->where[] = $query->convertQuery('user', $options['field'], $options['operator'], $options['value']);
}
return $query->count();
}
private function onAcymDeclareSummary_conditionsFilters(&$automation, $key)
{
if (!empty($automation['acy_field'])) {
$usersColumns = acym_getColumns('user');
if (!in_array($automation['acy_field']['field'], $usersColumns)) {
$fieldClass = new FieldClass();
$field = $fieldClass->getOneById($automation['acy_field']['field']);
$automation['acy_field']['field'] = $field->name;
}
$automation = acym_translationSprintf(
$key,
$automation['acy_field']['field'],
$automation['acy_field']['operator'],
$automation['acy_field']['value']
);
} elseif (!empty($automation['random'])) {
$automation = acym_translationSprintf(
'ACYM_RANDOMLY_SELECT_X_SUBSCRIBERS',
$automation['random']['number']
);
}
}
}