automationTriggers['user']['on_birthday'] = acym_translation('ACYM_ON_USER_BIRTHDAY');
}
public function displayTriggerOptions_on_birthday(string $fieldName, array $defaultValues): void
{
$dataSources = [];
acym_trigger('onAcymDeclareDataSourcesBirthdayTrigger', [&$dataSources]);
$this->dataSources = $dataSources;
$sourceOptions = [];
foreach ($this->dataSources as $key => $oneSource) {
$sourceOptions[] = acym_selectOption($key, $oneSource['source_name']);
}
$defaultSource = empty($defaultValues['on_birthday']['source']) ? 'acymailing' : $defaultValues['on_birthday']['source'];
$defaultField = empty($defaultValues['on_birthday']['field']) ? '' : $defaultValues['on_birthday']['field'];
$defaultDayBefore = empty($defaultValues['on_birthday']['day_before']) ? '0' : $defaultValues['on_birthday']['day_before'];
$defaultBeforeHour = empty($defaultValues['on_birthday']['hour']) ? '12' : $defaultValues['on_birthday']['hour'];
$defaultBeforeMinutes = empty($defaultValues['on_birthday']['minutes']) ? '00' : $defaultValues['on_birthday']['minutes'];
$hasFields = !empty($this->dataSources[$defaultSource]['fields']);
$noFieldsErrorMessage = empty($this->dataSources[$defaultSource]['no_fields_error_message'])
? ''
: $this->dataSources[$defaultSource]['no_fields_error_message'];
?>
:
'intext_select acym__select'],
'value',
'text',
null,
false,
true
); ?>
:
getFieldsForTable('acymailing'),
$fieldName.'[field]',
$defaultField,
['data-class' => 'intext_select acym__select'],
'value',
'text',
null,
false,
true
); ?>
displayBirthdayDelaySentence($fieldName, $defaultDayBefore, $defaultBeforeHour, $defaultBeforeMinutes); ?>
';
$hourSelect = acym_select(
$hours,
$fieldName.'[hour]',
$hour,
['data-class' => 'intext_select acym__select']
);
$minuteSelect = acym_select(
$minutesOptions,
$fieldName.'[minutes]',
$minutes,
['data-class' => 'intext_select acym__select']
);
// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- The three fields are built and escaped just above, and the translation itself holds HTML entities on purpose.
echo acym_translationSprintf('ACYM_TRIGGER_EVENT_BEFORE_BIRTHDAY', $dayBeforeInput, $hourSelect, $minuteSelect);
}
public function onAcymExecuteTrigger(&$step, &$execute, &$data)
{
if (!empty($step->next_execution) && $step->next_execution > $data['time']) {
return;
}
$triggers = $step->triggers;
if (empty($triggers['on_birthday'])) return;
//Values from trigger
$sourceName = $triggers['on_birthday']['source'];
$fieldId = $triggers['on_birthday']['field'];
$dayBefore = $triggers['on_birthday']['day_before'];
$hour = $triggers['on_birthday']['hour'];
$minutes = $triggers['on_birthday']['minutes'];
$dateNowWithTimeZone = acym_date('now', 'Y-m-d h:i:s');
$now = new DateTime($dateNowWithTimeZone);
$triggerDate = new DateTime($dateNowWithTimeZone);
$triggerDate->setTime($hour, $minutes);
if (!empty($now->date) && !empty($triggerDate->date) && $now->date < $triggerDate->date) {
$step->next_execution = acym_getTime('today '.$hour.':'.$minutes);
return;
} else {
$step->next_execution = acym_getTime('tomorrow '.$hour.':'.$minutes);
}
$dataSources = [];
acym_trigger('onAcymDeclareDataSourcesBirthdayTrigger', [&$dataSources]);
$this->dataSources = $dataSources;
$format = '';
$query = '';
if (empty($this->dataSources[$sourceName]['fields'])) return;
foreach ($this->dataSources[$sourceName]['fields'] as $oneField) {
if ($oneField['id'] === $fieldId) {
$format = $oneField['format'];
$query = $oneField['query'];
}
}
if (empty($format) || empty($query)) return;
$users = acym_loadObjectList($query);
if (empty($users)) return;
foreach ($users as $oneUser) {
if (empty($oneUser->date)) continue;
$userBirthday = DateTime::createFromFormat($format, $oneUser->date);
if (empty($userBirthday)) continue;
$userBirthday->sub(new DateInterval('P'.$dayBefore.'D'));
if ($now->format('m-d') === $userBirthday->format('m-d')) {
$execute = true;
$data['userIds'][] = $oneUser->user_id;
}
}
}
protected function getFieldsForTable($dataSource): array
{
if (empty($this->dataSources[$dataSource]['fields'])) return [];
$fieldsOption = [];
foreach ($this->dataSources[$dataSource]['fields'] as $oneField) {
$fieldsOption[] = acym_selectOption($oneField['id'], $oneField['name']);
}
return $fieldsOption;
}
public function onAcymDeclareSummary_triggers(object $automation): void
{
if (empty($automation->triggers['on_birthday']['source'])) {
return;
}
$dataSources = [];
acym_trigger('onAcymDeclareDataSourcesBirthdayTrigger', [&$dataSources]);
if (
empty($dataSources[$automation->triggers['on_birthday']['source']]['fields'])
&& !empty($dataSources[$automation->triggers['on_birthday']['source']]['no_fields_error_message'])
) {
$automation->triggers['on_birthday'] = acym_translation($dataSources[$automation->triggers['on_birthday']['source']]['no_fields_error_message']);
return;
}
$fieldToDisplay = [];
foreach ($dataSources[$automation->triggers['on_birthday']['source']]['fields'] as $field) {
if ($field['id'] != $automation->triggers['on_birthday']['field']) continue;
$fieldToDisplay = $field;
}
$date = empty($automation->triggers['on_birthday']['day_before'])
? acym_translation('ACYM_ON_USER_BIRTHDAY')
: acym_translationSprintf(
'ACYM_X_DAYS_BEFORE_BIRTHDAY',
$automation->triggers['on_birthday']['day_before']
);
$time = acym_translationSprintf('ACYM_AT_DATE_TIME', $automation->triggers['on_birthday']['hour'], $automation->triggers['on_birthday']['minutes']);
$end = acym_translationSprintf('ACYM_FOR_THE_X_FIELD_X', $dataSources[$automation->triggers['on_birthday']['source']]['source_name'], $fieldToDisplay['name']);
$automation->triggers['on_birthday'] = $date.' '.$time.' '.$end;
}
}