30require
'../../main.inc.php';
38require_once DOL_DOCUMENT_ROOT.
'/core/modules/mailings/modules_mailings.php';
39require_once DOL_DOCUMENT_ROOT.
'/comm/mailing/class/mailing.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmailing.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/core/lib/emailing.lib.php';
42require_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
44require_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
47$langs->loadLangs(array(
"mails",
"admin",
"companies"));
49$action =
GETPOST(
'action',
'aZ09');
50$toselect =
GETPOST(
'toselect',
'array:int');
51$contextpage =
GETPOST(
'contextpage',
'aZ');
52$massaction =
GETPOST(
'massaction',
'alpha');
57$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
58$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
60if (empty($page) || $page == -1) {
63$offset = $limit * $page;
67 $sortfield =
"mc.statut,email";
70 $sortorder =
"DESC,ASC";
75$search_lastname =
GETPOST(
"search_lastname",
'alphanohtml');
76$search_firstname =
GETPOST(
"search_firstname",
'alphanohtml');
77$search_email =
GETPOST(
"search_email",
'alphanohtml');
78$search_other =
GETPOST(
"search_other",
'alphanohtml');
79$search_dest_status =
GETPOST(
'search_dest_status',
'int');
88$hookmanager->initHooks(array(
'ciblescard',
'globalcard'));
94$listofmethods = array();
96$listofmethods[
'mail'] =
'PHP mail function';
98$listofmethods[
'smtps'] =
'SMTP/SMTPS socket library';
99if (version_compare(phpversion(),
'7.0',
'>=')) {
100 $listofmethods[
'swiftmailer'] =
'Swift Mailer socket library';
103$arrayfields = array();
106if (!$user->hasRight(
'mailing',
'lire') || (!
getDolGlobalString(
'EXTERNAL_USERS_ARE_AUTHORIZED') && $user->socid > 0)) {
109if (empty($action) && empty(
$object->id)) {
113$permissiontoread = $user->hasRight(
'mailing',
'lire');
114$permissiontocreate = $user->hasRight(
'mailing',
'creer');
115$permissiontovalidatesend = $user->hasRight(
'mailing',
'valider');
116$permissiontodelete = $user->hasRight(
'mailing',
'supprimer');
122if (
GETPOST(
'cancel',
'alpha')) {
126if (!
GETPOST(
'confirmmassaction',
'alpha')) {
130if ($action ==
'add' && $permissiontocreate) {
135 foreach ($modulesdir as $dir) {
138 dol_syslog(
"Scan directory ".$dir.
" for modules");
141 $file = $dir.
"/".
$module.
".modules.php";
142 $classname =
"mailing_".$module;
144 if (file_exists($file)) {
148 dol_syslog(
"Call add_to_target() on class ".$classname.
" evenunsubscribe=".
$object->evenunsubscribe);
151 if (class_exists($classname)) {
152 $obj =
new $classname($db);
153 '@phan-var-force MailingTargets $obj';
154 $obj->evenunsubscribe =
$object->evenunsubscribe;
156 $result = $obj->add_to_target($id);
158 $sqlmessage = $obj->sql;
167 if (
$object->status == $object::STATUS_SENTCOMPLETELY) {
168 $object->setStatut($object::STATUS_SENTPARTIALY);
171 setEventMessages($langs->trans(
"XTargetsAdded", $result),
null,
'mesgs');
175 setEventMessages($langs->trans(
"WarningNoEMailsAdded"),
null,
'warnings');
177 if ($result < 0 && is_object($obj)) {
178 setEventMessages($langs->trans(
"Error").($obj->error ?
' '.$obj->error :
''), null,
'errors');
182if (
GETPOSTINT(
'clearlist') && $permissiontocreate) {
185 $obj->clear_target($id);
192if (
GETPOSTINT(
'exportcsv') && $permissiontoread) {
193 $completefilename =
'targets_emailing'.$object->id.
'_'.
dol_print_date(
dol_now(),
'dayhourlog').
'.csv';
194 header(
'Content-Type: text/csv');
195 header(
'Content-Disposition: attachment;filename='.$completefilename);
198 $sql =
"SELECT mc.rowid, mc.lastname, mc.firstname, mc.email, mc.other, mc.statut as status, mc.date_envoi, mc.tms,";
199 $sql .=
" mc.source_id, mc.source_type, mc.error_text";
200 $sql .=
" FROM ".MAIN_DB_PREFIX.
"mailing_cibles as mc";
201 $sql .=
" WHERE mc.fk_mailing = ".((int)
$object->id);
202 $sql .= $db->order($sortfield, $sortorder);
204 $resql = $db->query($sql);
206 $num = $db->num_rows($resql);
209 while ($obj = $db->fetch_object($resql)) {
210 print $obj->rowid.$sep;
211 print
'"'.$obj->lastname.
'"'.$sep;
212 print
'"'.$obj->firstname.
'"'.$sep;
213 print $obj->email.$sep;
214 print $obj->other.$sep;
215 print $obj->tms.$sep;
216 print $obj->source_type.$sep;
217 print $obj->source_id.$sep;
218 print $obj->date_envoi.$sep;
219 print $obj->status.$sep;
220 print
'"'.$obj->error_text.
'"'.$sep;
226 dol_print_error($db);
231if ($action ==
'delete' && $permissiontocreate) {
233 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"mailing_cibles WHERE rowid = ".((int) $rowid);
234 $sql .=
" AND fk_mailing = ".((int)
$object->id);
235 $resql = $db->query($sql);
239 $obj->update_nb($id);
241 setEventMessages($langs->trans(
"RecordDeleted"),
null,
'mesgs');
243 header(
"Location: list.php");
247 dol_print_error($db);
251if ($action ==
"confirm_reset_target" && $permissiontocreate) {
256 foreach ($toselect as $toselectid) {
257 $result =
$object->resetTargetErrorStatus($user, $toselectid);
262 } elseif ($result > 0) {
270 setEventMessages($langs->trans(
"RecordsModified", $nbok),
null,
'mesgs');
279if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
280 $search_lastname =
'';
281 $search_firstname =
'';
284 $search_dest_status =
'';
289if (($action ==
'settitle' || $action ==
'setemail_from' || $action ==
'setemail_replyto' || $action ==
'setemail_errorsto' || $action ==
'setevenunsubscribe') && $permissiontocreate) {
293 if ($action ==
'settitle') {
295 } elseif ($action ==
'setemail_from') {
296 $object->email_from = trim(
GETPOST(
'email_from',
'alphawithlgt'));
297 } elseif ($action ==
'setemail_replyto') {
298 $object->email_replyto = trim(
GETPOST(
'email_replyto',
'alphawithlgt'));
299 } elseif ($action ==
'setemail_errorsto') {
300 $object->email_errorsto = trim(
GETPOST(
'email_errorsto',
'alphawithlgt'));
301 } elseif ($action ==
'setevenunsubscribe') {
304 if ($action ==
'settitle' && empty(
$object->title)) {
305 $mesg = $langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"MailTitle"));
307 if ($action ==
'setemail_from' && empty(
$object->email_from)) {
308 $mesg = $langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"MailFrom"));
312 $result =
$object->update($user);
314 header(
"Location: ".$_SERVER[
'PHP_SELF'].
"?id=".
$object->id);
320 setEventMessages($mesg, $mesgs,
'errors');
329$form =
new Form($db);
332$help_url =
'EN:Module_EMailing|FR:Module_Mailing|ES:Módulo_Mailing';
333llxHeader(
'', $langs->trans(
"Mailing"), $help_url);
335$arrayofselected = is_array($toselect) ? $toselect : array();
345 $linkback =
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/list.php?restore_lastsearch_values=1">'.$langs->trans(
"BackToList").
'</a>';
347 $morehtmlref =
'<div class="refidno">';
349 $morehtmlref .= $form->editfieldkey(
"",
'title',
$object->title, $object, 0,
'string',
'', 0, 1);
350 $morehtmlref .= $form->editfieldval(
"",
'title',
$object->title, $object, 0,
'string',
'',
null,
null,
'', 1);
351 $morehtmlref .=
'</div>';
353 $morehtmlstatus =
'';
355 if (
$object->status == $object::STATUS_SENTPARTIALY ||
$object->status == $object::STATUS_SENTCOMPLETELY) {
356 $nbtry =
$object->countNbOfTargets(
'alreadysent');
357 $nbko =
$object->countNbOfTargets(
'alreadysentko');
358 $nbok = ($nbtry - $nbko);
360 $morehtmlstatus .=
' ('.$nbtry.
'/'.
$object->nbemail;
362 $morehtmlstatus .=
' - '.$nbko.
' '.$langs->trans(
"Error");
364 $morehtmlstatus .=
') ';
367 dol_banner_tab($object,
'id', $linkback, 1,
'rowid',
'ref', $morehtmlref,
'', 0,
'', $morehtmlstatus);
369 print
'<div class="fichecenter">';
370 print
'<div class="fichehalfleft">';
371 print
'<div class="underbanner clearboth"></div>';
373 print
'<table class="border centpercent tableforfield">'.
"\n";
376 print
'<tr><td class="titlefield">';
377 print $langs->trans(
"MailFrom").
'</td><td>';
379 foreach ($emailarray as $email => $name) {
380 if ($name && $name != $email) {
384 $langs->load(
"errors");
385 print img_warning($langs->trans(
"ErrorBadEMail", $email));
395 if (
$object->messtype !=
'sms') {
396 print
'<tr><td>'.$langs->trans(
"MailErrorsTo").
'</td><td>';
398 foreach ($emailarray as $email => $name) {
399 if ($name != $email) {
403 $langs->load(
"errors");
404 print img_warning($langs->trans(
"ErrorBadEMail", $email));
406 $langs->load(
"errors");
407 print img_warning($langs->trans(
"ErrorBadMXDomain", $email));
417 if (
$object->messtype !=
'sms') {
419 print $form->editfieldkey(
"MailReply",
'email_replyto',
$object->email_replyto, $object, (
int) ($user->hasRight(
'mailing',
'creer') &&
$object->status < $object::STATUS_SENTCOMPLETELY),
'string');
421 print $form->editfieldval(
"MailReply",
'email_replyto',
$object->email_replyto, $object, $user->hasRight(
'mailing',
'creer') &&
$object->status < $object::STATUS_SENTCOMPLETELY,
'string');
423 if ($action !=
'editemail_replyto') {
425 $langs->load(
"errors");
426 print img_warning($langs->trans(
"ErrorBadEMail", $email));
428 $langs->load(
"errors");
429 print img_warning($langs->trans(
"ErrorBadMXDomain", $email));
439 print
'<div class="fichehalfright">';
440 print
'<div class="underbanner clearboth"></div>';
442 print
'<table class="border centpercent tableforfield">';
446 print $langs->trans(
"TotalNbOfDistinctRecipients");
449 if (is_numeric($nbemail)) {
453 $htmltooltip .= $langs->trans(
'LimitSendingEmailing',
getDolGlobalString(
'MAILING_LIMIT_SENDBYWEB'));
455 $htmltooltip .= $langs->trans(
'SendingFromWebInterfaceIsNotAllowed');
458 if (empty($nbemail)) {
459 $nbemail .=
' '.img_warning($langs->trans(
'ToAddRecipientsChooseHere'));
462 print $form->textwithpicto($nbemail, $htmltooltip, 1,
'info');
470 print $langs->trans(
"MAIN_MAIL_SENDMODE");
472 if (
$object->messtype !=
'sms') {
478 $text = $listofmethods[
'mail'];
483 print
' <span class="opacitymedium">('.getDolGlobalString(
'MAIN_MAIL_SMTP_SERVER_EMAILING',
getDolGlobalString(
'MAIN_MAIL_SMTP_SERVER')).
')</span>';
486 print
' <span class="opacitymedium">('.getDolGlobalString(
'MAIN_MAIL_SMTP_SERVER').
')</span>';
490 print
' <span class="opacitymedium">('.getDolGlobalString(
'MAIN_MAIL_SMTP_SERVER').
')</span>';
495 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_view.tpl.php';
501 print
'<div class="clearboth"></div>';
507 $allowaddtarget = (
$object->status == $object::STATUS_DRAFT);
508 if (
GETPOST(
'allowaddtarget')) {
511 if (!$allowaddtarget) {
512 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'New'),
'',
'fa fa-plus-circle', $_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&allowaddtarget=1',
'', $user->hasRight(
'mailing',
'creer'));
516 if ($allowaddtarget && $user->hasRight(
'mailing',
'creer')) {
517 print
'<div class="info">';
518 print $langs->trans(
"ToAddRecipientsChooseHere").
'...';
522 print
'<div class="div-table-responsive">';
523 print
'<div class="tagtable centpercentwithout1imp liste_titre_bydiv borderbottom" id="tablelines">';
525 print
'<div class="tagtr liste_titre">';
526 print
'<div class="tagtd"></div>';
527 print
'<div class="tagtd">'.$langs->trans(
"RecipientSelectionModules");
528 print ($user->admin ?
info_admin($langs->trans(
"YouCanAddYourOwnPredefindedListHere"), 1) :
'');
530 print
'<div class="tagtd center maxwidth150">';
531 if (
$object->messtype !=
'sms') {
532 print $langs->trans(
"NbOfUniqueEMails");
534 print $langs->trans(
"NbOfUniquePhones");
537 print
'<div class="tagtd left"><div class="inline-block">'.$langs->trans(
"Filters").
'</div>';
538 if (
$object->messtype !=
'sms') {
539 print
' <div class="inline-block valignmiddle">';
540 print
'<span id="evenunsubscribe_text_'.$object->id.
'" class="linkobject" style="cursor: pointer;">'.$langs->trans(
"EvenUnsubscribe").
'</span> ';
541 print
ajax_object_onoff($object,
'evenunsubscribe',
'evenunsubscribe',
'EvenUnsubscribe:switch_on:warning',
'EvenUnsubscribe', array(),
'small valignmiddle reposition',
'', 1,
'allowaddtarget=1');
557 print
'<div class="tagtd"> </div>';
562 foreach ($modulesdir as $dir) {
563 $modulenames = array();
567 dol_syslog(
"Scan directory ".$dir.
" for modules");
568 $handle = @opendir($dir);
569 if (is_resource($handle)) {
570 while (($file = readdir($handle)) !==
false) {
573 if (preg_match(
"/(.*)\.modules\.php$/i", $file, $reg)) {
574 if ($reg[1] ==
'example') {
577 $modulenames[] = $reg[1];
588 foreach ($modulenames as $modulename) {
590 $file = $dir.$modulename.
".modules.php";
591 $classname =
"mailing_".$modulename;
594 if (!class_exists($classname)) {
595 dol_syslog(
"Emailing target selector class ".$classname.
" not found", LOG_WARNING);
599 $obj =
new $classname($db);
600 '@phan-var-force MailingTargets $obj';
603 $qualified = (is_null($obj->enabled) ? 1 : (int)
dol_eval((
string) $obj->enabled, 1));
606 foreach ($obj->require_module as $key) {
607 if (empty(
$conf->$key->enabled) || (empty($user->admin) && $obj->require_admin)) {
616 if ($allowaddtarget) {
617 print
'<form class="oddeven trforbreakperms trforbreaknobg impair tagtr" name="'.$modulename.
'" action="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&module='.$modulename.
'" method="POST" enctype="multipart/form-data">';
618 print
'<input type="hidden" name="token" value="'.newToken().
'">';
619 print
'<input type="hidden" name="action" value="add">';
620 print
'<input type="hidden" name="page_y" value="'.newToken().
'">';
623 print
'<div class="oddeven trforbreakperms trforbreaknobg impair tagtr">';
626 print
'<div class="tagtd paddingleftlarge marginleftonly paddingrightlarge marginrightonly valignmiddle center">';
627 if (empty($obj->picto)) {
628 $obj->picto =
'generic';
630 print img_object($langs->trans(
"EmailingTargetSelector").
': '.get_class($obj), $obj->picto,
'class="valignmiddle width25 size15x"');
632 print
'<div class="tagtd valignmiddle">';
633 print $obj->getDesc();
639 $obj->evenunsubscribe =
$object->evenunsubscribe;
641 $nbofrecipient = $obj->getNbOfRecipients(
'');
646 print
'<div class="tagtd center valignmiddle">';
647 if ($nbofrecipient ===
'' || $nbofrecipient >= 0) {
648 if ($nbofrecipient !==
'') {
649 print
'<span class="badge badge-info">'.$nbofrecipient.
'</span>';
652 print $langs->trans(
"Error").
' '.img_error($obj->error);
656 print
'<div class="tagtd left valignmiddle">';
657 if ($allowaddtarget) {
660 $filter = $obj->formFilter();
667 print $langs->trans(
"None");
672 print
'<div class="tagtd right valignmiddle">';
673 if ($allowaddtarget) {
674 print
'<input type="submit" class="button button-add small reposition" name="button_'.$modulename.
'" value="'.$langs->trans(
"Add").
'">';
676 print
'<input type="submit" class="button small disabled" disabled="disabled" name="button_'.$modulename.
'" value="'.$langs->trans(
"Add").
'">';
682 if ($allowaddtarget) {
691 $parameters = array();
692 $hookmanager->executeHooks(
'formObjectOptions', $parameters, $object, $action);
693 print $hookmanager->resPrint;
700 if ($sqlmessage && $user->admin) {
701 print
info_admin($langs->trans(
"SQLUsedForExport").
':<br> '.$sqlmessage, 0, 0,
'1',
'',
'TechnicalInformation');
711 $sql =
"SELECT mc.rowid, mc.lastname, mc.firstname, mc.email, mc.other, mc.statut as status, mc.date_envoi, mc.tms,";
712 $sql .=
" mc.source_url, mc.source_id, mc.source_type, mc.error_text,";
713 $sql .=
" COUNT(mu.rowid) as nb, MAX(CASE WHEN mu.unsubscribegroup = '' AND mu.entity = ".((int)
$conf->entity).
" THEN 1 ELSE 0 END) as global_opt_out";
714 $sql .=
" FROM ".MAIN_DB_PREFIX.
"mailing_cibles as mc";
715 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"mailing_unsubscribe as mu ON mu.email = mc.email";
716 $sql .=
" WHERE mc.fk_mailing=".((int)
$object->id);
717 $asearchcriteriahasbeenset = 0;
718 if ($search_lastname) {
720 $asearchcriteriahasbeenset++;
722 if ($search_firstname) {
724 $asearchcriteriahasbeenset++;
728 $asearchcriteriahasbeenset++;
732 $asearchcriteriahasbeenset++;
734 if ($search_dest_status !=
'' && (
int) $search_dest_status >= -1) {
735 $sql .=
" AND mc.statut = ".((int) $search_dest_status);
736 $asearchcriteriahasbeenset++;
738 $sql .=
' GROUP BY mc.rowid, mc.lastname, mc.firstname, mc.email, mc.other, mc.statut, mc.date_envoi, mc.tms, mc.source_url, mc.source_id, mc.source_type, mc.error_text';
739 $sql .= $db->order($sortfield, $sortorder);
743 $nbtotalofrecords =
'';
745 $result = $db->query($sql);
746 $nbtotalofrecords = $db->num_rows($result);
747 if (($page * $limit) > (int) $nbtotalofrecords) {
753 if (empty($asearchcriteriahasbeenset)) {
754 if ($nbtotalofrecords !=
$object->nbemail) {
755 dol_syslog(
"We found a difference in nb of record in target table and the property ->nbemail, we fix ->nbemail");
757 $resultrefresh =
$object->refreshNbOfTargets();
758 if ($resultrefresh < 0) {
766 $sql .= $db->plimit($limit + 1, $offset);
768 $resql = $db->query($sql);
770 $num = $db->num_rows($resql);
772 $param =
"&id=".$object->id;
774 if ($limit > 0 && $limit !=
$conf->liste_limit) {
775 $param .=
'&limit='.((int) $limit);
777 if ($search_lastname) {
778 $param .=
"&search_lastname=".urlencode($search_lastname);
780 if ($search_firstname) {
781 $param .=
"&search_firstname=".urlencode($search_firstname);
784 $param .=
"&search_email=".urlencode($search_email);
787 $param .=
"&search_other=".urlencode($search_other);
790 print
'<form method="POST" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
791 print
'<input type="hidden" name="token" value="'.newToken().
'">';
792 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
793 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
794 print
'<input type="hidden" name="page" value="'.$page.
'">';
795 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
796 print
'<input type="hidden" name="page_y" value="">';
798 $morehtmlcenter =
'';
799 $arrayofmassactions = array();
800 if ($permissiontocreate) {
801 $arrayofmassactions[
'reset_target'] = img_picto(
'',
'refresh',
'class="pictofixedwidth"').$langs->trans(
"ResetMailingTargetMassaction");
803 $massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
804 $morehtmlcenter .= $massactionbutton .
'<br>';
806 if (
$object->status == $object::STATUS_DRAFT) {
807 $morehtmlcenter =
'<span class="opacitymedium hideonsmartphone">'.$langs->trans(
"ToClearAllRecipientsClickHere").
'</span> <a href="'.$_SERVER[
"PHP_SELF"].
'?clearlist=1&id='.
$object->id.
'" class="button reposition smallpaddingimp">'.$langs->trans(
"TargetsReset").
'</a>';
810 $morehtmlrightbeforearrow =
'<a class="reposition marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?action=exportcsv&token='.
newToken().
'&exportcsv=1&id='.
$object->id.
'">'.img_picto(
'',
'download',
'class="pictofixedwidth"').$langs->trans(
"Download").
'</a> ';
814 print
"\n<!-- List of selected targets -->\n";
815 print
'<form method="POST" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
816 print
'<input type="hidden" name="token" value="'.newToken().
'">';
817 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
818 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
819 print
'<input type="hidden" name="page" value="'.$page.
'">';
820 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
821 print
'<input type="hidden" name="limit" value="'.$limit.
'">';
822 print
'<input type="hidden" name="page_y" value="">';
825 print_barre_liste($langs->trans(
"MailSelectedRecipients"), $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $morehtmlcenter, $num, $nbtotalofrecords,
'generic', 0, $newcardbutton,
'', $limit, 0, 0, 1, $morehtmlrightbeforearrow);
827 if ($massaction ==
'reset_target') {
829 print $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".
$object->id, $langs->trans(
"ConfirmResetMailingTargetMassaction"), $langs->trans(
"ConfirmResetMailingTargetMassactionQuestion"),
"confirm_reset_target",
null,
'', 0, 0, 500, 1);
832 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
833 $htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column ?
'left' :
'');
834 $selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
835 $selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
837 print
'<div class="div-table-responsive">';
838 print
'<table class="noborder centpercent">';
841 print
'<tr class="liste_titre_filter">';
844 if (
$conf->main_checkbox_left_column) {
845 print
'<td class="liste_titre maxwidthsearch">';
846 $searchpicto = $form->showFilterButtons(
'left');
851 print
'<td class="liste_titre">';
852 print
'<input class="flat maxwidth75" type="text" name="search_email" value="'.dol_escape_htmltag($search_email).
'">';
855 print
'<td class="liste_titre">';
856 print
'<input class="flat maxwidth50" type="text" name="search_lastname" value="'.dol_escape_htmltag($search_lastname).
'">';
859 print
'<td class="liste_titre">';
860 print
'<input class="flat maxwidth50" type="text" name="search_firstname" value="'.dol_escape_htmltag($search_firstname).
'">';
863 print
'<td class="liste_titre">';
864 print
'<input class="flat maxwidth100" type="text" name="search_other" value="'.dol_escape_htmltag($search_other).
'">';
867 print
'<td class="liste_titre">';
872 print
'<td class="liste_titre">';
877 print
'<td class="liste_titre">';
882 print
'<td class="liste_titre center parentonrightofpage">';
883 print $formmailing->selectDestinariesStatus($search_dest_status,
'search_dest_status', 1,
'width100 onrightofpage');
887 if (!
$conf->main_checkbox_left_column) {
888 print
'<td class="liste_titre maxwidthsearch">';
889 $searchpicto = $form->showFilterButtons();
897 $param .=
"&page=".urlencode((
string) ($page));
900 print
'<tr class="liste_titre">';
902 if (
$conf->main_checkbox_left_column) {
903 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
904 $totalarray[
'nbfield']++;
907 print_liste_field_titre(
"No_Email", $_SERVER[
"PHP_SELF"],
"global_opt_out",
'', $param,
"", $sortfield, $sortorder);
908 print_liste_field_titre(
"Lastname", $_SERVER[
"PHP_SELF"],
"mc.lastname",
'', $param,
"", $sortfield, $sortorder);
909 print_liste_field_titre(
"Firstname", $_SERVER[
"PHP_SELF"],
"mc.firstname",
'', $param,
"", $sortfield, $sortorder);
910 print_liste_field_titre(
"OtherInformations", $_SERVER[
"PHP_SELF"],
'',
"", $param,
"", $sortfield, $sortorder);
911 print_liste_field_titre(
"Source", $_SERVER[
"PHP_SELF"],
'',
"", $param,
'', $sortfield, $sortorder,
'center ');
913 print_liste_field_titre(
"DateLastModification", $_SERVER[
"PHP_SELF"],
"mc.tms",
'', $param,
'', $sortfield, $sortorder,
'center ');
915 print_liste_field_titre(
"DateSending", $_SERVER[
"PHP_SELF"],
"mc.date_envoi",
'', $param,
'', $sortfield, $sortorder,
'center ');
916 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"mc.statut",
'', $param,
'', $sortfield, $sortorder,
'center ');
918 if (!
$conf->main_checkbox_left_column) {
919 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
920 $totalarray[
'nbfield']++;
927 include_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
928 include_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
929 include_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
930 include_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
931 include_once DOL_DOCUMENT_ROOT.
'/eventorganization/class/conferenceorboothattendee.class.php';
933 $objectstaticmember =
new Adherent($db);
934 $objectstaticuser =
new User($db);
935 $objectstaticcompany =
new Societe($db);
936 $objectstaticcontact =
new Contact($db);
939 while ($i < min($num, $limit)) {
940 $obj = $db->fetch_object($resql);
942 print
'<tr class="oddeven">';
945 if (
$conf->main_checkbox_left_column) {
946 print
'<td class="center nowraponall">';
947 print
'<!-- ID mailing_cibles = '.$obj->rowid.
' -->';
948 if ($massactionbutton || $massaction) {
950 if (in_array($obj->rowid, $arrayofselected)) {
953 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
955 if ($obj->status == $object::STATUS_DRAFT) {
956 if ($user->hasRight(
'mailing',
'creer')) {
957 print
'<a class="reposition marginleftonly" href="'.$_SERVER[
'PHP_SELF'].
'?action=delete&token='.
newToken().
'&rowid='.((int) $obj->rowid).$param.
'">'.img_delete($langs->trans(
"RemoveRecipient")).
'</a>';
967 print
'<td class="tdoverflowmax150">';
968 print img_picto($obj->email,
'email',
'class="paddingright"');
970 print img_warning($langs->trans(
"EmailOptedOut"),
'warning',
'pictofixedwidth');
972 print dolPrintHTML($obj->email);
975 print
'<td class="center">'.yn($obj->global_opt_out).
'</td>';
977 print
'<td class="tdoverflowmax150" title="'.dolPrintHTMLForAttribute($obj->lastname).
'">'.dolPrintHTML($obj->lastname).
'</td>';
979 print
'<td class="tdoverflowmax150" title="'.dolPrintHTMLForAttribute($obj->firstname).
'">'.dolPrintHTML($obj->firstname).
'</td>';
981 print
'<td class="tdoverflowmax300" title="'.dolPrintHTMLForAttribute($obj->other).
'"><span class="small">'.dolPrintHTML($obj->other).
'</small></td>';
983 print
'<td class="center tdoverflowmax150">';
984 if (empty($obj->source_id) || empty($obj->source_type)) {
985 print empty($obj->source_url) ?
'' : $obj->source_url;
987 if ($obj->source_type ==
'member') {
988 $objectstaticmember->fetch($obj->source_id);
989 print $objectstaticmember->getNomUrl(1);
990 } elseif ($obj->source_type ==
'user') {
991 $objectstaticuser->fetch($obj->source_id);
992 print $objectstaticuser->getNomUrl(1);
993 } elseif ($obj->source_type ==
'thirdparty') {
994 $objectstaticcompany->fetch($obj->source_id);
995 print $objectstaticcompany->getNomUrl(1);
996 } elseif ($obj->source_type ==
'contact') {
997 $objectstaticcontact->fetch($obj->source_id);
998 print $objectstaticcontact->getNomUrl(1);
999 } elseif ($obj->source_type ==
'eventorganizationattendee') {
1000 $objectstaticeventorganization->fetch($obj->source_id);
1001 print $objectstaticeventorganization->getNomUrl(1);
1003 print $obj->source_url;
1009 print
'<td class="center nowraponall">';
1010 print
dol_print_date($db->jdate($obj->tms),
'dayhour',
'tzuserrel');
1014 print
'<td class="center nowraponall">';
1015 if ($obj->status != $object::STATUS_DRAFT) {
1017 print
dol_print_date($db->jdate($obj->date_envoi),
'dayhour',
'tzuserrel');
1022 print
'<td class="nowrap center">';
1023 if ($obj->status == $object::STATUS_DRAFT) {
1024 print $object::libStatutDest((
int) $obj->status, 2,
'');
1026 print $object::libStatutDest((
int) $obj->status, 2, $obj->error_text);
1031 if (!
$conf->main_checkbox_left_column) {
1032 print
'<td class="center nowraponall">';
1033 print
'<!-- ID mailing_cibles = '.$obj->rowid.
' -->';
1034 if ($obj->status == $object::STATUS_DRAFT) {
1035 if ($user->hasRight(
'mailing',
'creer')) {
1036 print
'<a class="reposition marginleftonly" href="'.$_SERVER[
'PHP_SELF'].
'?action=delete&token='.
newToken().
'&rowid='.((int) $obj->rowid).$param.
'">'.img_delete($langs->trans(
"RemoveRecipient")).
'</a>';
1050 if (
$object->status < $object::STATUS_SENTPARTIALY) {
1051 print
'<tr><td colspan="9">';
1052 print
'<span class="opacitymedium">'.$langs->trans(
"NoTargetYet").
'</span>';
1055 print
'<tr><td colspan="9">';
1056 print
'<span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span>';
1060 print
"</table><br>";
1067 dol_print_error($db);
1070 print
"\n<!-- End list of selected targets -->\n";
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
ajax_object_onoff($object, $code, $field, $text_on, $text_off, $input=array(), $morecss='', $htmlname='', $forcenojs=0, $moreparam='', $readonly=0)
On/off button to change a property status of an object This uses the ajax service objectonoff....
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage members of a foundation.
static getValidAddress($address, $format, $encode=0, $maxnumberofemail=0)
Return a formatted address string for SMTP protocol.
static getArrayAddress($address)
Return a formatted array of address string for SMTP protocol.
Class for ConferenceOrBoothAttendee.
Class to manage emailings module.
Parent class of emailing target selectors modules.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
if(! $sortfield) if(! $sortorder) $module
emailing_prepare_head(Mailing $object)
Prepare array with list of tabs.
dolGetModulesDirs($subdir='')
Return list of directories that contain modules.
isValidMailDomain($mail)
Return true if email has a domain name that can be resolved to MX type.
dol_now($mode='gmt')
Return date for now.
dol_print_email($email, $contactid=0, $socid=0, $addlink=0, $max=0, $showinvalid=2, $withpicto=0, $morecss='paddingrightonly')
Show EMail link formatted for HTML output.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dol_substr($string, $start, $length=null, $stringencoding='', $trunconbytes=0)
Make a substring.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isValidEmail($address, $acceptsupervisorkey=0, $acceptuserkey=0)
Return true if email syntax is ok.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
get_exdir($num, $level, $alpha, $withoutslash, $object, $modulepart='')
Return a path to have a the directory according to object where files are stored.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
info_admin($text, $infoonimgalt=0, $nodiv=0, $admin='1', $morecss='hideonsmartphone', $textfordropdown='', $picto='', $textonpictotooltip='', $cssfordropdown='info_admin')
Show information in HTML for admin users or standard users.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.