WHERE rol_id IN (' . implode(',', $arrayRoles) . ')
AND rol_cat_id = cat_id
AND cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
AND mem_rol_id = rol_id
AND mem_begin <= \'' . DATE_NOW . '\'
AND mem_end > \'' . DATE_NOW . '\'
AND mem_usr_id = usr_id
AND usr_valid = 1
AND email.usd_usr_id = email.usd_usr_id
ORDER BY last_name, first_name';
$resultUsers = $gDb->query($sql);
while ($row = $gDb->fetch_array($resultUsers)) {
if ($ecardSendResult == true) {
// create and send ecard
$ecardHtmlData = $funcClass->parseEcardTemplate($imageUrl, $_POST['ecard_message'], $ecardDataToParse, $row['first_name'] . ' ' . $row['last_name'], $row['email']);
$ecardSendResult = $funcClass->sendEcard($senderName, $senderEmail, $ecardHtmlData, $row['first_name'] . ' ' . $row['last_name'], $row['email'], $imageServerPath);
}
}
}
if (count($arrayUsers) > 0) {
foreach ($arrayUsers as $userId) {
if ($ecardSendResult == true) {
$user = new User($gDb, $gProfileFields, $userId);
// create and send ecard
$ecardHtmlData = $funcClass->parseEcardTemplate($imageUrl, $_POST['ecard_message'], $ecardDataToParse, $user->getValue('FIRST_NAME') . ' ' . $user->getValue('LAST_NAME'), $user->getValue('EMAIL'));
$ecardSendResult = $funcClass->sendEcard($senderName, $senderEmail, $ecardHtmlData, $user->getValue('FIRST_NAME') . ' ' . $user->getValue('LAST_NAME'), $user->getValue('EMAIL'), $imageServerPath);
}
}
}
// show result
if ($ecardSendResult == true) {
