| 1 |
<?php |
| 2 |
|
| 3 |
use AcyMailing\Core\AcymPlugin; |
| 4 |
use AcyMailing\Classes\FieldClass; |
| 5 |
|
| 6 |
require_once __DIR__.DIRECTORY_SEPARATOR.'BirthdayAutomationTriggers.php'; |
| 7 |
require_once __DIR__.DIRECTORY_SEPARATOR.'BirthdayCampaignType.php'; |
| 8 |
require_once __DIR__.DIRECTORY_SEPARATOR.'BirthdayFollowup.php'; |
| 9 |
|
| 10 |
class plgAcymBirthday extends AcymPlugin |
| 11 |
{ |
| 12 |
use BirthdayAutomationTriggers; |
| 13 |
use BirthdayCampaignType; |
| 14 |
use BirthdayFollowup; |
| 15 |
|
| 16 |
public function onAcymProcessFilter_birthday(&$query, $options, $num = null) |
| 17 |
{ |
| 18 |
if ($options['plugin'] !== get_class($this)) return; |
| 19 |
|
| 20 |
$dateToCheck = $this->processDateToCheck($options); |
| 21 |
|
| 22 |
$fieldClass = new FieldClass(); |
| 23 |
$birthdayField = $fieldClass->getOneById((int)$options['field']); |
| 24 |
if (empty($birthdayField)) { |
| 25 |
$query->where[] = '0 = 1'; |
| 26 |
|
| 27 |
return; |
| 28 |
} |
| 29 |
|
| 30 |
$query->join['birthday_field'.$num] = '#__acym_user_has_field AS uf'.$num.' ON uf'.$num.'.user_id = user.id'; |
| 31 |
$query->where[] = 'uf'.$num.'.field_id = '.intval($birthdayField->id); |
| 32 |
$query->where[] = 'uf'.$num.'.value LIKE '.acym_escapeDB('%'.date_format($dateToCheck, '-m-d')); |
| 33 |
} |
| 34 |
|
| 35 |
public function getBirthdayField(&$availableFields) |
| 36 |
{ |
| 37 |
$fieldClass = new FieldClass(); |
| 38 |
$dateFields = $fieldClass->getFieldsByType(['date']); |
| 39 |
foreach ($dateFields as $oneField) { |
| 40 |
$availableFields[$oneField->id] = acym_translation($oneField->name); |
| 41 |
} |
| 42 |
} |
| 43 |
|
| 44 |
public function getJsonBirthdayField() |
| 45 |
{ |
| 46 |
$availableFields = []; |
| 47 |
$this->getBirthdayField($availableFields); |
| 48 |
echo json_encode(['fields' => $availableFields]); |
| 49 |
exit; |
| 50 |
} |
| 51 |
} |
| 52 |
|
