card.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2004   Rodolphe Quiedeville  <rodolphe@quiedeville.org>
 * Copyright (C) 2005-2019  Laurent Destailleur   <eldy@uers.sourceforge.net>
 * Copyright (C) 2005-2016  Regis Houssin     <regis.houssin@inodbox.com>
 * Copyright (C) 2021   Waël Almoman            <info@almoman.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
if (!defined('NOSTYLECHECK')) {
  define('NOSTYLECHECK', '1');
}
 
// Load Dolibarr environment
require '../../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/emailing.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
require_once DOL_DOCUMENT_ROOT.'/comm/mailing/class/mailing.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php';
 
// Load translation files required by the page
$langs->load("mails");
 
$id = (GETPOST('mailid', 'int') ? GETPOST('mailid', 'int') : GETPOST('id', 'int'));
 
$action = GETPOST('action', 'aZ09');
$confirm = GETPOST('confirm', 'alpha');
$cancel = GETPOST('cancel', 'aZ09');
$urlfrom = GETPOST('urlfrom');
 
// Initialize technical objects
$object = new Mailing($db);
$extrafields = new ExtraFields($db);
 
$result = $object->fetch($id);
 
// Fetch optionals attributes and labels
$extrafields->fetch_name_optionals_label($object->table_element);
 
// Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
$hookmanager->initHooks(array('mailingcard', 'globalcard'));
 
// Array of possible substitutions (See also file mailing-send.php that should manage same substitutions)
$object->substitutionarray = FormMail::getAvailableSubstitKey('emailing');
 
 
// Set $object->substitutionarrayfortest
$signature = ((!empty($user->signature) && empty($conf->global->MAIN_MAIL_DO_NOT_USE_SIGN)) ? $user->signature : '');
 
$targetobject = null; // Not defined with mass emailing
 
$parameters = array('mode'=>'emailing');
$substitutionarray = FormMail::getAvailableSubstitKey('emailing', $targetobject);
 
$object->substitutionarrayfortest = $substitutionarray;
 
// List of sending methods
$listofmethods = array();
$listofmethods['mail'] = 'PHP mail function';
$listofmethods['smtps'] = 'SMTP/SMTPS socket library';
 
// Security check
if (empty($user->rights->mailing->lire) || (empty($conf->global->EXTERNAL_USERS_ARE_AUTHORIZED) && $user->socid > 0)) {
  accessforbidden();
}
 
$upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
 
/*
 * Actions
 */
 
$parameters = array();
$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
if ($reshook < 0) {
  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
}
 
if (empty($reshook)) {
  $error = 0;
 
  $backurlforlist = DOL_URL_ROOT.'/comm/mailing/list.php';
 
  if (empty($backtopage) || ($cancel && empty($id))) {
    if (empty($backtopage) || ($cancel && strpos($backtopage, '__ID__'))) {
      if (empty($id) && (($action != 'add' && $action != 'create') || $cancel)) {
        $backtopage = $backurlforlist;
      } else {
        $backtopage = DOL_URL_ROOT.'/comm/mailing/card.php?id='.((!empty($id) && $id > 0) ? $id : '__ID__');
      }
    }
  }
 
  if ($cancel) {
    /*var_dump($cancel);var_dump($backtopage);var_dump($backtopageforcancel);exit;*/
    if (!empty($backtopageforcancel)) {
      header("Location: ".$backtopageforcancel);
      exit;
    } elseif (!empty($backtopage)) {
      header("Location: ".$backtopage);
      exit;
    }
    $action = '';
  }
 
  // Action clone object
  if ($action == 'confirm_clone' && $confirm == 'yes') {
    if (!GETPOST("clone_content", 'alpha') && !GETPOST("clone_receivers", 'alpha')) {
      setEventMessages($langs->trans("NoCloneOptionsSpecified"), null, 'errors');
    } else {
      $result = $object->createFromClone($user, $object->id, GETPOST("clone_content", 'alpha'), GETPOST("clone_receivers", 'alpha'));
      if ($result > 0) {
        header("Location: ".$_SERVER['PHP_SELF'].'?id='.$result);
        exit;
      } else {
        setEventMessages($object->error, $object->errors, 'errors');
      }
    }
    $action = '';
  }
 
  // Action send emailing for everybody
  if ($action == 'sendallconfirmed' && $confirm == 'yes') {
    if (empty($conf->global->MAILING_LIMIT_SENDBYWEB)) {
      // As security measure, we don't allow send from the GUI
      setEventMessages($langs->trans("MailingNeedCommand"), null, 'warnings');
      setEventMessages('<textarea cols="70" rows="'.ROWS_2.'" wrap="soft">php ./scripts/emailings/mailing-send.php '.$object->id.'</textarea>', null, 'warnings');
      setEventMessages($langs->trans("MailingNeedCommand2"), null, 'warnings');
      $action = '';
    } elseif ($conf->global->MAILING_LIMIT_SENDBYWEB < 0) {
      setEventMessages($langs->trans("NotEnoughPermissions"), null, 'warnings');
      $action = '';
    } else {
      if ($object->statut == 0) {
        dol_print_error('', 'ErrorMailIsNotValidated');
        exit;
      }
 
      $id       = $object->id;
      $subject  = $object->sujet;
      $message  = $object->body;
      $from     = $object->email_from;
      $replyto = $object->email_replyto;
      $errorsto = $object->email_errorsto;
      // Is the message in html
      $msgishtml = -1; // Unknown by default
      if (preg_match('/[\s\t]*<html>/i', $message)) {
        $msgishtml = 1;
      }
 
      // Warning, we must not use begin-commit transaction here
      // because we want to save update for each mail sent.
 
      $nbok = 0; $nbko = 0;
 
      // We choose mails not already sent for this mailing (statut=0)
      // or sent in error (statut=-1)
      $sql = "SELECT mc.rowid, mc.fk_mailing, mc.lastname, mc.firstname, mc.email, mc.other, mc.source_url, mc.source_id, mc.source_type, mc.tag";
      $sql .= " FROM ".MAIN_DB_PREFIX."mailing_cibles as mc";
      $sql .= " WHERE mc.statut < 1 AND mc.fk_mailing = ".((int) $object->id);
      $sql .= " ORDER BY mc.statut DESC"; // first status 0, then status -1
 
      dol_syslog("card.php: select targets", LOG_DEBUG);
      $resql = $db->query($sql);
      if ($resql) {
        $num = $db->num_rows($resql); // Number of possible recipients
 
        if ($num) {
          dol_syslog("comm/mailing/card.php: nb of targets = ".$num, LOG_DEBUG);
 
          $now = dol_now();
 
          // Positioning date of start sending
          $sql = "UPDATE ".MAIN_DB_PREFIX."mailing SET date_envoi='".$db->idate($now)."' WHERE rowid=".((int) $object->id);
          $resql2 = $db->query($sql);
          if (!$resql2) {
            dol_print_error($db);
          }
 
          $thirdpartystatic = new Societe($db);
          // Loop on each email and send it
          $iforemailloop = 0;
 
          while ($iforemailloop < $num && $iforemailloop < $conf->global->MAILING_LIMIT_SENDBYWEB) {
            // Here code is common with same loop ino mailing-send.php
            $res = 1;
            $now = dol_now();
 
            $obj = $db->fetch_object($resql);
 
            // sendto en RFC2822
            $sendto = str_replace(',', ' ', dolGetFirstLastname($obj->firstname, $obj->lastname))." <".$obj->email.">";
 
            // Make substitutions on topic and body. From (AA=YY;BB=CC;...) we keep YY, CC, ...
            $other = explode(';', $obj->other);
            $tmpfield = explode('=', $other[0], 2); $other1 = (isset($tmpfield[1]) ? $tmpfield[1] : $tmpfield[0]);
            $tmpfield = explode('=', $other[1], 2); $other2 = (isset($tmpfield[1]) ? $tmpfield[1] : $tmpfield[0]);
            $tmpfield = explode('=', $other[2], 2); $other3 = (isset($tmpfield[1]) ? $tmpfield[1] : $tmpfield[0]);
            $tmpfield = explode('=', $other[3], 2); $other4 = (isset($tmpfield[1]) ? $tmpfield[1] : $tmpfield[0]);
            $tmpfield = explode('=', $other[4], 2); $other5 = (isset($tmpfield[1]) ? $tmpfield[1] : $tmpfield[0]);
 
            $signature = ((!empty($user->signature) && empty($conf->global->MAIN_MAIL_DO_NOT_USE_SIGN)) ? $user->signature : '');
 
            $targetobject = null; // Not defined with mass emailing
            $parameters = array('mode'=>'emailing');
            $substitutionarray = getCommonSubstitutionArray($langs, 0, array('object', 'objectamount'), $targetobject); // Note: On mass emailing, this is null because be don't know object
 
            // Array of possible substitutions (See also file mailing-send.php that should manage same substitutions)
            $substitutionarray['__ID__'] = $obj->source_id;
            if ($obj->source_type == "thirdparty") {
              $result = $thirdpartystatic->fetch($obj->source_id);
 
              if ($result > 0) {
                $substitutionarray['__THIRDPARTY_CUSTOMER_CODE__'] = $thirdpartystatic->code_client;
              } else {
                $substitutionarray['__THIRDPARTY_CUSTOMER_CODE__'] = '';
              }
            }
            $substitutionarray['__EMAIL__'] = $obj->email;
            $substitutionarray['__LASTNAME__'] = $obj->lastname;
            $substitutionarray['__FIRSTNAME__'] = $obj->firstname;
            $substitutionarray['__MAILTOEMAIL__'] = '<a href="mailto:'.$obj->email.'">'.$obj->email.'</a>';
            $substitutionarray['__OTHER1__'] = $other1;
            $substitutionarray['__OTHER2__'] = $other2;
            $substitutionarray['__OTHER3__'] = $other3;
            $substitutionarray['__OTHER4__'] = $other4;
            $substitutionarray['__OTHER5__'] = $other5;
            $substitutionarray['__USER_SIGNATURE__'] = $signature; // Signature is empty when ran from command line or taken from user in parameter)
            $substitutionarray['__SENDEREMAIL_SIGNATURE__'] = $signature; // Signature is empty when ran from command line or taken from user in parameter)
            $substitutionarray['__CHECK_READ__'] = '<img src="'.DOL_MAIN_URL_ROOT.'/public/emailing/mailing-read.php?tag='.urlencode($obj->tag).'&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->email).'&mtid='.$obj->rowid.'" width="1" height="1" style="width:1px;height:1px" border="0"/>';
            $substitutionarray['__UNSUBSCRIBE__'] = '<a href="'.DOL_MAIN_URL_ROOT.'/public/emailing/mailing-unsubscribe.php?tag='.urlencode($obj->tag).'&unsuscrib=1&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->email).'&mtid='.$obj->rowid.'" target="_blank" rel="noopener noreferrer">'.$langs->trans("MailUnsubcribe").'</a>';
            $substitutionarray['__UNSUBSCRIBE_URL__'] = DOL_MAIN_URL_ROOT.'/public/emailing/mailing-unsubscribe.php?tag='.urlencode($obj->tag).'&unsuscrib=1&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->email).'&mtid='.$obj->rowid;
 
            $onlinepaymentenabled = 0;
            if (isModEnabled('paypal')) {
              $onlinepaymentenabled++;
            }
            if (isModEnabled('paybox')) {
              $onlinepaymentenabled++;
            }
            if (isModEnabled('stripe')) {
              $onlinepaymentenabled++;
            }
            if ($onlinepaymentenabled && !empty($conf->global->PAYMENT_SECURITY_TOKEN)) {
              require_once DOL_DOCUMENT_ROOT.'/core/lib/payments.lib.php';
              $substitutionarray['__ONLINEPAYMENTLINK_MEMBER__'] = getHtmlOnlinePaymentLink('member', $obj->source_id);
              $substitutionarray['__ONLINEPAYMENTLINK_DONATION__'] = getHtmlOnlinePaymentLink('donation', $obj->source_id);
              $substitutionarray['__ONLINEPAYMENTLINK_ORDER__'] = getHtmlOnlinePaymentLink('order', $obj->source_id);
              $substitutionarray['__ONLINEPAYMENTLINK_INVOICE__'] = getHtmlOnlinePaymentLink('invoice', $obj->source_id);
              $substitutionarray['__ONLINEPAYMENTLINK_CONTRACTLINE__'] = getHtmlOnlinePaymentLink('contractline', $obj->source_id);
 
              $substitutionarray['__SECUREKEYPAYMENT__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
              if (empty($conf->global->PAYMENT_SECURITY_TOKEN_UNIQUE)) {
                $substitutionarray['__SECUREKEYPAYMENT_MEMBER__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
                $substitutionarray['__SECUREKEYPAYMENT_DONATION__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
                $substitutionarray['__SECUREKEYPAYMENT_ORDER__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
                $substitutionarray['__SECUREKEYPAYMENT_INVOICE__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
                $substitutionarray['__SECUREKEYPAYMENT_CONTRACTLINE__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN, 2);
              } else {
                $substitutionarray['__SECUREKEYPAYMENT_MEMBER__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN.'member'.$obj->source_id, 2);
                $substitutionarray['__SECUREKEYPAYMENT_DONATION__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN.'donation'.$obj->source_id, 2);
                $substitutionarray['__SECUREKEYPAYMENT_ORDER__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN.'order'.$obj->source_id, 2);
                $substitutionarray['__SECUREKEYPAYMENT_INVOICE__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN.'invoice'.$obj->source_id, 2);
                $substitutionarray['__SECUREKEYPAYMENT_CONTRACTLINE__'] = dol_hash($conf->global->PAYMENT_SECURITY_TOKEN.'contractline'.$obj->source_id, 2);
              }
            }
            if (!empty($conf->global->MEMBER_ENABLE_PUBLIC)) {
              $substitutionarray['__PUBLICLINK_NEWMEMBERFORM__'] = '<a target="_blank" rel="noopener noreferrer" href="'.DOL_MAIN_URL_ROOT.'/public/members/new.php'.((isModEnabled('multicompany')) ? '?entity='.$conf->entity : '').'">'.$langs->trans('BlankSubscriptionForm'). '</a>';
            }
            /* For backward compatibility, deprecated */
            if (isModEnabled('paypal') && !empty($conf->global->PAYPAL_SECURITY_TOKEN)) {
              $substitutionarray['__SECUREKEYPAYPAL__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN, 2);
 
              if (empty($conf->global->PAYPAL_SECURITY_TOKEN_UNIQUE)) {
                $substitutionarray['__SECUREKEYPAYPAL_MEMBER__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN, 2);
              } else {
                $substitutionarray['__SECUREKEYPAYPAL_MEMBER__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN.'membersubscription'.$obj->source_id, 2);
              }
 
              if (empty($conf->global->PAYPAL_SECURITY_TOKEN_UNIQUE)) {
                $substitutionarray['__SECUREKEYPAYPAL_ORDER__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN, 2);
              } else {
                $substitutionarray['__SECUREKEYPAYPAL_ORDER__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN.'order'.$obj->source_id, 2);
              }
 
              if (empty($conf->global->PAYPAL_SECURITY_TOKEN_UNIQUE)) {
                $substitutionarray['__SECUREKEYPAYPAL_INVOICE__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN, 2);
              } else {
                $substitutionarray['__SECUREKEYPAYPAL_INVOICE__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN.'invoice'.$obj->source_id, 2);
              }
 
              if (empty($conf->global->PAYPAL_SECURITY_TOKEN_UNIQUE)) {
                $substitutionarray['__SECUREKEYPAYPAL_CONTRACTLINE__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN, 2);
              } else {
                $substitutionarray['__SECUREKEYPAYPAL_CONTRACTLINE__'] = dol_hash($conf->global->PAYPAL_SECURITY_TOKEN.'contractline'.$obj->source_id, 2);
              }
            }
            //$substitutionisok=true;
 
            complete_substitutions_array($substitutionarray, $langs);
            $newsubject = make_substitutions($subject, $substitutionarray);
            $newmessage = make_substitutions($message, $substitutionarray, null, 0);
 
            $moreinheader = '';
            if (preg_match('/__UNSUBSCRIBE__/', $message)) {
              $moreinheader = "List-Unsubscribe: <__UNSUBSCRIBE_URL__>\n";
              $moreinheader = make_substitutions($moreinheader, $substitutionarray);
            }
 
            $arr_file = array();
            $arr_mime = array();
            $arr_name = array();
            $arr_css  = array();
 
            $listofpaths = dol_dir_list($upload_dir, 'all', 0, '', '', 'name', SORT_ASC, 0);
            if (count($listofpaths)) {
              foreach ($listofpaths as $key => $val) {
                $arr_file[] = $listofpaths[$key]['fullname'];
                $arr_mime[] = dol_mimetype($listofpaths[$key]['name']);
                $arr_name[] = $listofpaths[$key]['name'];
              }
            }
 
            // Mail making
            $trackid = 'emailing-'.$obj->fk_mailing.'-'.$obj->rowid;
            $upload_dir_tmp = $upload_dir;
            $mail = new CMailFile($newsubject, $sendto, $from, $newmessage, $arr_file, $arr_mime, $arr_name, '', '', 0, $msgishtml, $errorsto, $arr_css, $trackid, $moreinheader, 'emailing', '', $upload_dir_tmp);
 
            if ($mail->error) {
              $res = 0;
            }
            /*if (! $substitutionisok)
            {
              $mail->error='Some substitution failed';
              $res=0;
            }*/
 
            // Send mail
            if ($res) {
              $res = $mail->sendfile();
            }
 
            if ($res) {
              // Mail successful
              $nbok++;
 
              dol_syslog("comm/mailing/card.php: ok for #".$iforemailloop.($mail->error ? ' - '.$mail->error : ''), LOG_DEBUG);
 
              $sql = "UPDATE ".MAIN_DB_PREFIX."mailing_cibles";
              $sql .= " SET statut=1, date_envoi = '".$db->idate($now)."' WHERE rowid=".((int) $obj->rowid);
              $resql2 = $db->query($sql);
              if (!$resql2) {
                dol_print_error($db);
              } else {
                //if check read is use then update prospect contact status
                if (strpos($message, '__CHECK_READ__') !== false) {
                  //Update status communication of thirdparty prospect
                  $sql = "UPDATE ".MAIN_DB_PREFIX."societe SET fk_stcomm=2 WHERE rowid IN (SELECT source_id FROM ".MAIN_DB_PREFIX."mailing_cibles WHERE rowid=".((int) $obj->rowid).")";
                  dol_syslog("card.php: set prospect thirdparty status", LOG_DEBUG);
                  $resql2 = $db->query($sql);
                  if (!$resql2) {
                    dol_print_error($db);
                  }
 
                  //Update status communication of contact prospect
                  $sql = "UPDATE ".MAIN_DB_PREFIX."societe SET fk_stcomm=2 WHERE rowid IN (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."socpeople AS sc INNER JOIN ".MAIN_DB_PREFIX."mailing_cibles AS mc ON mc.rowid=".((int) $obj->rowid)." AND mc.source_type = 'contact' AND mc.source_id = sc.rowid)";
                  dol_syslog("card.php: set prospect contact status", LOG_DEBUG);
 
                  $resql2 = $db->query($sql);
                  if (!$resql2) {
                    dol_print_error($db);
                  }
                }
              }
 
              if (!empty($conf->global->MAILING_DELAY)) {
                dol_syslog("Wait a delay of MAILING_DELAY=".((float) $conf->global->MAILING_DELAY));
                usleep((float) $conf->global->MAILING_DELAY * 1000000);
              }
 
              //test if CHECK READ change statut prospect contact
            } else {
              // Mail failed
              $nbko++;
 
              dol_syslog("comm/mailing/card.php: error for #".$iforemailloop.($mail->error ? ' - '.$mail->error : ''), LOG_WARNING);
 
              $sql = "UPDATE ".MAIN_DB_PREFIX."mailing_cibles";
              $sql .= " SET statut=-1, error_text='".$db->escape($mail->error)."', date_envoi='".$db->idate($now)."' WHERE rowid=".((int) $obj->rowid);
              $resql2 = $db->query($sql);
              if (!$resql2) {
                dol_print_error($db);
              }
            }
 
            $iforemailloop++;
          }
        } else {
          setEventMessages($langs->transnoentitiesnoconv("NoMoreRecipientToSendTo"), null, 'mesgs');
        }
 
        // Loop finished, set global statut of mail
        if ($nbko > 0) {
          $statut = 2; // Status 'sent partially' (because at least one error)
          if ($nbok > 0) {
            setEventMessages($langs->transnoentitiesnoconv("EMailSentToNRecipients", $nbok), null, 'mesgs');
          } else {
            setEventMessages($langs->transnoentitiesnoconv("EMailSentToNRecipients", $nbok), null, 'mesgs');
          }
        } else {
          if ($nbok >= $num) {
            $statut = 3; // Send to everybody
            setEventMessages($langs->transnoentitiesnoconv("EMailSentToNRecipients", $nbok), null, 'mesgs');
          } else {
            $statut = 2; // Status 'sent partially' (because not send to everybody)
            setEventMessages($langs->transnoentitiesnoconv("EMailSentToNRecipients", $nbok), null, 'mesgs');
          }
        }
 
        $sql = "UPDATE ".MAIN_DB_PREFIX."mailing SET statut=".((int) $statut)." WHERE rowid = ".((int) $object->id);
        dol_syslog("comm/mailing/card.php: update global status", LOG_DEBUG);
        $resql2 = $db->query($sql);
        if (!$resql2) {
          dol_print_error($db);
        }
      } else {
        dol_syslog($db->error());
        dol_print_error($db);
      }
      $object->fetch($id);
      $action = '';
    }
  }
 
  // Action send test emailing
  if ($action == 'send' && ! $cancel) {
    $error = 0;
 
    $upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
    $object->sendto = GETPOST("sendto", 'alphawithlgt');
    if (!$object->sendto) {
      setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("MailTo")), null, 'errors');
      $error++;
    }
 
    if (!$error) {
      // Is the message in html
      $msgishtml = -1; // Unknow by default
      if (preg_match('/[\s\t]*<html>/i', $object->body)) {
        $msgishtml = 1;
      }
 
      // other are set at begin of page
      $object->substitutionarrayfortest['__EMAIL__'] = $object->sendto;
      $object->substitutionarrayfortest['__MAILTOEMAIL__'] = '<a href="mailto:'.$object->sendto.'">'.$object->sendto.'</a>';
      $object->substitutionarrayfortest['__CHECK_READ__'] = '<img src="'.DOL_MAIN_URL_ROOT.'/public/emailing/mailing-read.php?tag=undefinedintestmode&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->sendto).'&mtid=0" width="1" height="1" style="width:1px;height:1px" border="0"/>';
      $object->substitutionarrayfortest['__UNSUBSCRIBE__'] = '<a href="'.DOL_MAIN_URL_ROOT.'/public/emailing/mailing-unsubscribe.php?tag=undefinedintestmode&unsuscrib=1&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->sendto).'&mtid=0" target="_blank" rel="noopener noreferrer">'.$langs->trans("MailUnsubcribe").'</a>';
      $object->substitutionarrayfortest['__UNSUBSCRIBE_URL__'] = DOL_MAIN_URL_ROOT.'/public/emailing/mailing-unsubscribe.php?tag=undefinedintestmode&unsuscrib=1&securitykey='.urlencode($conf->global->MAILING_EMAIL_UNSUBSCRIBE_KEY).'&email='.urlencode($obj->sendto).'&mtid=0';
 
      // Subject and message substitutions
      complete_substitutions_array($object->substitutionarrayfortest, $langs);
      $tmpsujet = make_substitutions($object->sujet, $object->substitutionarrayfortest);
      $tmpbody = make_substitutions($object->body, $object->substitutionarrayfortest);
 
      $arr_file = array();
      $arr_mime = array();
      $arr_name = array();
      $arr_css  = array();
 
      // Add CSS
      if (!empty($object->bgcolor)) {
        $arr_css['bgcolor'] = (preg_match('/^#/', $object->bgcolor) ? '' : '#').$object->bgcolor;
      }
      if (!empty($object->bgimage)) {
        $arr_css['bgimage'] = $object->bgimage;
      }
 
      // Attached files
      $listofpaths = dol_dir_list($upload_dir, 'all', 0, '', '', 'name', SORT_ASC, 0);
      if (count($listofpaths)) {
        foreach ($listofpaths as $key => $val) {
          $arr_file[] = $listofpaths[$key]['fullname'];
          $arr_mime[] = dol_mimetype($listofpaths[$key]['name']);
          $arr_name[] = $listofpaths[$key]['name'];
        }
      }
 
      $trackid = 'emailing-test';
      $upload_dir_tmp = $upload_dir;
      $mailfile = new CMailFile($tmpsujet, $object->sendto, $object->email_from, $tmpbody, $arr_file, $arr_mime, $arr_name, '', '', 0, $msgishtml, $object->email_errorsto, $arr_css, $trackid, '', 'emailing', '', $upload_dir_tmp);
 
      $result = $mailfile->sendfile();
      if ($result) {
        setEventMessages($langs->trans("MailSuccessfulySent", $mailfile->getValidAddress($object->email_from, 2), $mailfile->getValidAddress($object->sendto, 2)), null, 'mesgs');
        $action = '';
      } else {
        setEventMessages($langs->trans("ResultKo").'<br>'.$mailfile->error.' '.$result, null, 'errors');
        $action = 'test';
      }
    }
  }
 
  // Action add emailing
  if ($action == 'add') {
    $mesgs = array();
 
    $object->email_from     = (string) GETPOST("from", 'alphawithlgt'); // Must allow 'name <email>'
    $object->email_replyto  = (string) GETPOST("replyto", 'alphawithlgt'); // Must allow 'name <email>'
    $object->email_errorsto = (string) GETPOST("errorsto", 'alphawithlgt'); // Must allow 'name <email>'
    $object->title          = (string) GETPOST("title");
    $object->sujet          = (string) GETPOST("sujet");
    $object->body           = (string) GETPOST("bodyemail", 'restricthtml');
    $object->bgcolor        = (string) GETPOST("bgcolor");
    $object->bgimage        = (string) GETPOST("bgimage");
 
    if (!$object->title) {
      $mesgs[] = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailTitle"));
    }
    if (!$object->sujet) {
      $mesgs[] = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailTopic"));
    }
    if (!$object->body) {
      $mesgs[] = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailMessage"));
    }
 
    if (!count($mesgs)) {
      if ($object->create($user) >= 0) {
        header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
        exit;
      }
      $mesgs[] = $object->error;
      $mesgs = array_merge($mesgs, $object->errors);
    }
 
    setEventMessages('', $mesgs, 'errors');
    $action = "create";
  }
 
  // Action update description of emailing
  if ($action == 'settitle' || $action == 'setemail_from' || $action == 'setreplyto' || $action == 'setemail_errorsto') {
    $upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
    if ($action == 'settitle') {
      $object->title = trim(GETPOST('title', 'alpha'));
    } elseif ($action == 'setemail_from') {
      $object->email_from = trim(GETPOST('email_from', 'alphawithlgt')); // Must allow 'name <email>'
    } elseif ($action == 'setemail_replyto') {
      $object->email_replyto = trim(GETPOST('email_replyto', 'alphawithlgt')); // Must allow 'name <email>'
    } elseif ($action == 'setemail_errorsto') {
      $object->email_errorsto = trim(GETPOST('email_errorsto', 'alphawithlgt')); // Must allow 'name <email>'
    } elseif ($action == 'settitle' && empty($object->title)) {
      $mesg = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailTitle"));
    } elseif ($action == 'setfrom' && empty($object->email_from)) {
      $mesg = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailFrom"));
    }
 
    if (!$mesg) {
      if ($object->update($user) >= 0) {
        header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
        exit;
      }
      $mesg = $object->error;
    }
 
    setEventMessages($mesg, $mesgs, 'errors');
    $action = "";
  }
 
  /*
   * Action of adding a file in email form
   */
  if (GETPOST('addfile')) {
    $upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
    require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
 
    // Set tmp user directory
    dol_add_file_process($upload_dir, 0, 0, 'addedfile', '', null, '', 0);
 
    $action = "edit";
  }
 
  // Action of file remove
  if (GETPOST("removedfile")) {
    $upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
    require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
 
    dol_remove_file_process(GETPOST('removedfile'), 0, 0); // We really delete file linked to mailing
 
    $action = "edit";
  }
 
  // Action of emailing update
  if ($action == 'update' && !GETPOST("removedfile") && !$cancel) {
    require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
 
    $isupload = 0;
 
    if (!$isupload) {
      $mesgs = array();
      $object->sujet          = (string) GETPOST("sujet");
      $object->body           = (string) GETPOST("bodyemail", 'restricthtml');
      $object->bgcolor        = (string) GETPOST("bgcolor");
      $object->bgimage        = (string) GETPOST("bgimage");
 
      if (!$object->sujet) {
        $mesgs[] = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailTopic"));
      }
      if (!$object->body) {
        $mesgs[] = $langs->trans("ErrorFieldRequired", $langs->transnoentities("MailMessage"));
      }
 
      if (!count($mesgs)) {
        if ($object->update($user) >= 0) {
          header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
          exit;
        }
        $mesgs[] = $object->error;
        $mesgs = array_merge($mesgs, $object->errors);
      }
 
      setEventMessages('', $mesgs, 'errors');
      $action = "edit";
    } else {
      $action = "edit";
    }
  }
 
  // Action of validation confirmation
  if ($action == 'confirm_valid' && $confirm == 'yes') {
    if ($object->id > 0) {
      $object->valid($user);
      setEventMessages($langs->trans("MailingSuccessfullyValidated"), null, 'mesgs');
      header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
      exit;
    } else {
      dol_print_error($db);
    }
  }
 
  // Action of validation confirmation
  if ($action == 'confirm_settodraft' && $confirm == 'yes') {
    if ($object->id > 0) {
      $result = $object->setStatut(0);
      if ($result > 0) {
        //setEventMessages($langs->trans("MailingSuccessfullyValidated"), null, 'mesgs');
        header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
        exit;
      } else {
        setEventMessages($object->error, $object->errors, 'errors');
      }
    } else {
      dol_print_error($db);
    }
  }
 
  // Resend
  if ($action == 'confirm_reset' && $confirm == 'yes') {
    if ($object->id > 0) {
      $db->begin();
 
      $result = $object->valid($user);
      if ($result > 0) {
        $result = $object->reset_targets_status($user);
      }
 
      if ($result > 0) {
        $db->commit();
        header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
        exit;
      } else {
        setEventMessages($object->error, $object->errors, 'errors');
        $db->rollback();
      }
    } else {
      dol_print_error($db);
    }
  }
 
  // Action of delete confirmation
  if ($action == 'confirm_delete' && $confirm == 'yes') {
    if ($object->delete($object->id)) {
      $url = (!empty($urlfrom) ? $urlfrom : 'list.php');
      header("Location: ".$url);
      exit;
    }
  }
 
  if ($cancel) {
    $action = '';
  }
}
 
 
/*
 * View
 */
 
$form = new Form($db);
$htmlother = new FormOther($db);
 
$help_url = 'EN:Module_EMailing|FR:Module_Mailing|ES:M&oacute;dulo_Mailing';
llxHeader(
  '',
  $langs->trans("Mailing"),
  $help_url,
  '',
  0,
  0,
  array(
    '/includes/ace/src/ace.js',
    '/includes/ace/src/ext-statusbar.js',
    '/includes/ace/src/ext-language_tools.js',
    //'/includes/ace/src/ext-chromevox.js'
  ),
  array()
);
 
if ($action == 'create') {
  // EMailing in creation mode
  print '<form name="new_mailing" action="'.$_SERVER['PHP_SELF'].'" method="POST">'."\n";
  print '<input type="hidden" name="token" value="'.newToken().'">';
  print '<input type="hidden" name="action" value="add">';
 
  $htmltext = '<i>'.$langs->trans("FollowingConstantsWillBeSubstituted").':<br>';
  foreach ($object->substitutionarray as $key => $val) {
    $htmltext .= $key.' = '.$langs->trans($val).'<br>';
  }
  $htmltext .= '</i>';
 
 
  $availablelink = $form->textwithpicto($langs->trans("AvailableVariables"), $htmltext, 1, 'help', '', 0, 2, 'availvar');
  //print '<a href="javascript:document_preview(\''.DOL_URL_ROOT.'/admin/modulehelp.php?id='.$objMod->numero.'\',\'text/html\',\''.dol_escape_js($langs->trans("Module")).'\')">'.img_picto($langs->trans("ClickToShowDescription"), $imginfo).'</a>';
 
 
  // Print mail form
  print load_fiche_titre($langs->trans("NewMailing"), $availablelink, 'object_email');
 
  print dol_get_fiche_head(array(), '', '', -3);
 
  print '<table class="border centpercent">';
 
  print '<tr><td class="fieldrequired titlefieldcreate">'.$langs->trans("MailTitle").'</td><td><input class="flat minwidth300" name="title" value="'.dol_escape_htmltag(GETPOST('title')).'" autofocus="autofocus"></td></tr>';
 
  print '<tr><td class="fieldrequired">'.$langs->trans("MailFrom").'</td><td><input class="flat minwidth200" name="from" value="'.getDolGlobalString('MAILING_EMAIL_FROM').'"></td></tr>';
 
  print '<tr><td>'.$langs->trans("MailErrorsTo").'</td><td><input class="flat minwidth200" name="errorsto" value="'.getDolGlobalString('MAILING_EMAIL_ERRORSTO', getDolGlobalString('MAIN_MAIL_ERRORS_TO')).'"></td></tr>';
 
  // Other attributes
  $parameters = array();
  $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
  print $hookmanager->resPrint;
  if (empty($reshook)) {
    print $object->showOptionals($extrafields, 'create');
  }
 
  print '</table>';
  print '<br><br>';
 
  print '<table class="border centpercent">';
  print '<tr><td class="fieldrequired titlefieldcreate">'.$langs->trans("MailTopic").'</td><td><input class="flat minwidth200 quatrevingtpercent" name="sujet" value="'.dol_escape_htmltag(GETPOST('sujet', 'alphanohtml')).'"></td></tr>';
  print '<tr><td>'.$langs->trans("BackgroundColorByDefault").'</td><td colspan="3">';
  print $htmlother->selectColor(GETPOST('bgcolor'), 'bgcolor', '', 0);
  print '</td></tr>';
 
  print '</table>';
 
  print '<div style="padding-top: 10px">';
  // wysiwyg editor
  require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
  $doleditor = new DolEditor('bodyemail', GETPOST('bodyemail', 'restricthtmlallowunvalid'), '', 600, 'dolibarr_mailings', '', true, true, getDolGlobalInt('FCKEDITOR_ENABLE_MAILING'), 20, '90%');
  $doleditor->Create();
  print '</div>';
 
  print dol_get_fiche_end();
 
  print $form->buttonsSaveCancel("CreateMailing", 'Cancel');
 
  print '</form>';
} else {
  if ($object->id > 0) {
    $upload_dir = $conf->mailing->dir_output."/".get_exdir($object->id, 2, 0, 1, $object, 'mailing');
 
    $head = emailing_prepare_head($object);
 
    if ($action == 'settodraft') {
      // Confirmation back to draft
      print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id, $langs->trans("SetToDraft"), $langs->trans("ConfirmUnvalidateEmailing"), "confirm_settodraft", '', '', 1);
    } elseif ($action == 'valid') {
      // Confirmation of mailing validation
      print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id, $langs->trans("ValidMailing"), $langs->trans("ConfirmValidMailing"), "confirm_valid", '', '', 1);
    } elseif ($action == 'reset') {
      // Confirm reset
      print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id, $langs->trans("ResetMailing"), $langs->trans("ConfirmResetMailing", $object->ref), "confirm_reset", '', '', 2);
    } elseif ($action == 'delete') {
      // Confirm delete
      print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id.(!empty($urlfrom) ? '&urlfrom='.urlencode($urlfrom) : ''), $langs->trans("DeleteAMailing"), $langs->trans("ConfirmDeleteMailing"), "confirm_delete", '', '', 1);
    }
 
    if ($action != 'edit' && $action != 'edithtml') {
      print dol_get_fiche_head($head, 'card', $langs->trans("Mailing"), -1, 'email');
 
      /*
       * View mode mailing
       */
      if ($action == 'sendall') {
        // Define message to recommand from command line
        $sendingmode = $conf->global->EMAILING_MAIL_SENDMODE;
        if (empty($sendingmode)) {
          $sendingmode = $conf->global->MAIN_MAIL_SENDMODE;
        }
        if (empty($sendingmode)) {
          $sendingmode = 'mail'; // If not defined, we use php mail function
        }
 
        // MAILING_NO_USING_PHPMAIL may be defined or not.
        // MAILING_LIMIT_SENDBYWEB is always defined to something != 0 (-1=forbidden).
        // MAILING_LIMIT_SENDBYCLI may be defined ot not (-1=forbidden, 0 or undefined=no limit).
        // MAILING_LIMIT_SENDBYDAY may be defined ot not (0 or undefined=no limit).
        if (!empty($conf->global->MAILING_NO_USING_PHPMAIL) && $sendingmode == 'mail') {
          // EMailing feature may be a spam problem, so when you host several users/instance, having this option may force each user to use their own SMTP agent.
          // You ensure that every user is using its own SMTP server when using the mass emailing module.
          $linktoadminemailbefore = '<a href="'.DOL_URL_ROOT.'/admin/mails_emailing.php">';
          $linktoadminemailend = '</a>';
          setEventMessages($langs->trans("MailSendSetupIs", $listofmethods[$sendingmode]), null, 'warnings');
          $messagetoshow = $langs->trans("MailSendSetupIs2", '{s1}', '{s2}', '{s3}', '{s4}');
          $messagetoshow = str_replace('{s1}', $linktoadminemailbefore, $messagetoshow);
          $messagetoshow = str_replace('{s2}', $linktoadminemailend, $messagetoshow);
          $messagetoshow = str_replace('{s3}', $langs->transnoentitiesnoconv("MAIN_MAIL_SENDMODE"), $messagetoshow);
          $messagetoshow = str_replace('{s4}', $listofmethods['smtps'], $messagetoshow);
          setEventMessages($messagetoshow, null, 'warnings');
 
          if (!empty($conf->global->MAILING_SMTP_SETUP_EMAILS_FOR_QUESTIONS)) {
            setEventMessages($langs->trans("MailSendSetupIs3", $conf->global->MAILING_SMTP_SETUP_EMAILS_FOR_QUESTIONS), null, 'warnings');
          }
          $_GET["action"] = '';
        } elseif ($conf->global->MAILING_LIMIT_SENDBYWEB < 0) {
          if (!empty($conf->global->MAILING_LIMIT_WARNING_PHPMAIL) && $sendingmode == 'mail') {
            setEventMessages($langs->transnoentitiesnoconv($conf->global->MAILING_LIMIT_WARNING_PHPMAIL), null, 'warnings');
          }
          if (!empty($conf->global->MAILING_LIMIT_WARNING_NOPHPMAIL) && $sendingmode != 'mail') {
            setEventMessages($langs->transnoentitiesnoconv($conf->global->MAILING_LIMIT_WARNING_NOPHPMAIL), null, 'warnings');
          }
 
          // The feature is forbidden from GUI, we show just message to use from command line.
          setEventMessages($langs->trans("MailingNeedCommand"), null, 'warnings');
          setEventMessages('<textarea cols="60" rows="'.ROWS_1.'" wrap="soft">php ./scripts/emailings/mailing-send.php '.$object->id.'</textarea>', null, 'warnings');
          if ($conf->file->mailing_limit_sendbyweb != '-1') {  // MAILING_LIMIT_SENDBYWEB was set to -1 in database, but it is allowed ot increase it.
            setEventMessages($langs->trans("MailingNeedCommand2"), null, 'warnings'); // You can send online with constant...
          }
          $_GET["action"] = '';
        } else {
          if (!empty($conf->global->MAILING_LIMIT_WARNING_PHPMAIL) && $sendingmode == 'mail') {
            setEventMessages($langs->transnoentitiesnoconv($conf->global->MAILING_LIMIT_WARNING_PHPMAIL), null, 'warnings');
          }
          if (!empty($conf->global->MAILING_LIMIT_WARNING_NOPHPMAIL) && $sendingmode != 'mail') {
            setEventMessages($langs->transnoentitiesnoconv($conf->global->MAILING_LIMIT_WARNING_NOPHPMAIL), null, 'warnings');
          }
 
          $text = '';
 
          if (isset($conf->global->MAILING_LIMIT_SENDBYDAY) && $conf->global->MAILING_LIMIT_SENDBYDAY >= 0) {
            $text .= $langs->trans('WarningLimitSendByDay', $conf->global->MAILING_LIMIT_SENDBYDAY);
            $text .= '<br><br>';
          }
          $text .= $langs->trans('ConfirmSendingEmailing').'<br>';
          $text .= $langs->trans('LimitSendingEmailing', $conf->global->MAILING_LIMIT_SENDBYWEB);
 
          if (!isset($conf->global->MAILING_LIMIT_SENDBYCLI) || $conf->global->MAILING_LIMIT_SENDBYCLI >= 0) {
            $text .= '<br><br>';
            $text .= $langs->trans("MailingNeedCommand");
            $text .= '<br><textarea class="quatrevingtpercent" rows="'.ROWS_2.'" wrap="soft" disabled>php ./scripts/emailings/mailing-send.php '.$object->id.' '.$user->login.'</textarea>';
          }
 
          print $form->formconfirm($_SERVER['PHP_SELF'].'?id='.$object->id, $langs->trans('SendMailing'), $text, 'sendallconfirmed', '', '', 1, 380, 660, 0, $langs->trans("Confirm"), $langs->trans("Cancel"));
        }
      }
 
      $linkback = '<a href="'.DOL_URL_ROOT.'/comm/mailing/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
 
      $morehtmlright = '';
      $nbtry = $nbok = 0;
      if ($object->statut == 2 || $object->statut == 3) {
        $nbtry = $object->countNbOfTargets('alreadysent');
        $nbko  = $object->countNbOfTargets('alreadysentko');
 
        $morehtmlright .= ' ('.$nbtry.'/'.$object->nbemail;
        if ($nbko) {
          $morehtmlright .= ' - '.$nbko.' '.$langs->trans("Error");
        }
        $morehtmlright .= ') &nbsp; ';
      }
 
      dol_banner_tab($object, 'id', $linkback, 1, 'rowid', 'ref', '', '', 0, '', $morehtmlright);
 
      print '<div class="fichecenter">';
      print '<div class="underbanner clearboth"></div>';
 
      print '<table class="border centpercent tableforfield">';
 
      // Description
      print '<tr><td class="titlefield">';
      print $form->editfieldkey("MailTitle", 'title', $object->title, $object, $user->hasRight('mailing', 'creer'), 'string');
      print '</td><td>';
      print $form->editfieldval("MailTitle", 'title', $object->title, $object, $user->hasRight('mailing', 'creer'), 'string');
      print '</td></tr>';
 
      // From
      print '<tr><td>';
      print $form->editfieldkey("MailFrom", 'email_from', $object->email_from, $object, $user->hasRight('mailing', 'creer') && $object->statut < 3, 'string');
      print '</td><td>';
      print $form->editfieldval("MailFrom", 'email_from', $object->email_from, $object, $user->hasRight('mailing', 'creer') && $object->statut < 3, 'string');
      $email = CMailFile::getValidAddress($object->email_from, 2);
      if ($email && !isValidEmail($email)) {
        $langs->load("errors");
        print img_warning($langs->trans("ErrorBadEMail", $email));
      } elseif ($email && !isValidMailDomain($email)) {
        $langs->load("errors");
        print img_warning($langs->trans("ErrorBadMXDomain", $email));
      }
 
      print '</td></tr>';
 
      // Errors to
      print '<tr><td>';
      print $form->editfieldkey("MailErrorsTo", 'email_errorsto', $object->email_errorsto, $object, $user->hasRight('mailing', 'creer') && $object->statut < 3, 'string');
      print '</td><td>';
      print $form->editfieldval("MailErrorsTo", 'email_errorsto', $object->email_errorsto, $object, $user->hasRight('mailing', 'creer') && $object->statut < 3, 'string');
      $email = CMailFile::getValidAddress($object->email_errorsto, 2);
      if ($email && !isValidEmail($email)) {
        $langs->load("errors");
        print img_warning($langs->trans("ErrorBadEMail", $email));
      } elseif ($email && !isValidMailDomain($email)) {
        $langs->load("errors");
        print img_warning($langs->trans("ErrorBadMXDomain", $email));
      }
      print '</td></tr>';
 
      // Number of distinct emails
      print '<tr><td>';
      print $langs->trans("TotalNbOfDistinctRecipients");
      print '</td><td colspan="3">';
      $nbemail = ($object->nbemail ? $object->nbemail : 0);
      if (is_numeric($nbemail)) {
        $text = '';
        if ((!empty($conf->global->MAILING_LIMIT_SENDBYWEB) && $conf->global->MAILING_LIMIT_SENDBYWEB < $nbemail) && ($object->statut == 1 || ($object->statut == 2 && $nbtry < $nbemail))) {
          if ($conf->global->MAILING_LIMIT_SENDBYWEB > 0) {
            $text .= $langs->trans('LimitSendingEmailing', $conf->global->MAILING_LIMIT_SENDBYWEB);
          } else {
            $text .= $langs->trans('SendingFromWebInterfaceIsNotAllowed');
          }
        }
        if (empty($nbemail)) {
          $nbemail .= ' '.img_warning('').' <span class="warning">'.$langs->trans("NoTargetYet").'</span>';
        }
        if ($text) {
          print $form->textwithpicto($nbemail, $text, 1, 'warning');
        } else {
          print $nbemail;
        }
      }
      print '</td></tr>';
 
      // Other attributes
      include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php';
 
      print '</table>';
 
      print "</div>";
 
      print dol_get_fiche_end();
 
 
      // Clone confirmation
      if ($action == 'clone') {
        // Create an array for form
        $formquestion = array(
          'text' => $langs->trans("ConfirmClone"),
        array('type' => 'checkbox', 'name' => 'clone_content', 'label' => $langs->trans("CloneContent"), 'value' => 1),
        array('type' => 'checkbox', 'name' => 'clone_receivers', 'label' => $langs->trans("CloneReceivers"), 'value' => 0)
        );
        // Incomplete payment. On demande si motif = escompte ou autre
        print $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('ToClone'), $langs->trans('ConfirmCloneEMailing', $object->ref), 'confirm_clone', $formquestion, 'yes', 2, 240);
      }
 
      /*
       * Actions Buttons
       */
 
      if (GETPOST('cancel', 'alpha') || $confirm == 'no' || $action == '' || in_array($action, array('settodraft', 'valid', 'delete', 'sendall', 'clone', 'test'))) {
        print "\n\n<div class=\"tabsAction\">\n";
 
        if (($object->statut == 1) && ($user->hasRight('mailing', 'valider') || $object->user_validation == $user->id)) {
          print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=settodraft&token='.newToken().'&id='.$object->id.'">'.$langs->trans("SetToDraft").'</a>';
        }
 
        if (($object->statut == 0 || $object->statut == 1 || $object->statut == 2) && $user->hasRight('mailing', 'creer')) {
          if (isModEnabled('fckeditor') && !empty($conf->global->FCKEDITOR_ENABLE_MAILING)) {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=edit&token='.newToken().'&id='.$object->id.'">'.$langs->trans("EditWithEditor").'</a>';
          } else {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=edit&token='.newToken().'&id='.$object->id.'">'.$langs->trans("EditWithTextEditor").'</a>';
          }
 
          if (!empty($conf->use_javascript_ajax)) {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=edithtml&token='.newToken().'&id='.$object->id.'">'.$langs->trans("EditHTMLSource").'</a>';
          }
        }
 
        //print '<a class="butAction" href="card.php?action=test&amp;id='.$object->id.'">'.$langs->trans("PreviewMailing").'</a>';
 
        if (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !$user->rights->mailing->mailing_advance->send) {
          print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NotEnoughPermissions")).'">'.$langs->trans("TestMailing").'</a>';
        } else {
          print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=test&token='.newToken().'&id='.$object->id.'">'.$langs->trans("TestMailing").'</a>';
        }
 
        if ($object->statut == 0) {
          if ($object->nbemail <= 0) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NoTargetYet")).'">'.$langs->trans("ValidMailing").'</a>';
          } elseif (empty($user->rights->mailing->valider)) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NotEnoughPermissions")).'">'.$langs->trans("ValidMailing").'</a>';
          } else {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=valid&amp;id='.$object->id.'">'.$langs->trans("ValidMailing").'</a>';
          }
        }
 
        if (($object->statut == 1 || $object->statut == 2) && $object->nbemail > 0 && $user->hasRight('mailing', 'valider')) {
          if ($conf->global->MAILING_LIMIT_SENDBYWEB < 0) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("SendingFromWebInterfaceIsNotAllowed")).'">'.$langs->trans("SendMailing").'</a>';
          } elseif (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !$user->rights->mailing->mailing_advance->send) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NotEnoughPermissions")).'">'.$langs->trans("SendMailing").'</a>';
          } else {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=sendall&amp;id='.$object->id.'">'.$langs->trans("SendMailing").'</a>';
          }
        }
 
        if ($user->hasRight('mailing', 'creer')) {
          print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=clone&amp;object=emailing&amp;id='.$object->id.'">'.$langs->trans("ToClone").'</a>';
        }
 
        if (($object->statut == 2 || $object->statut == 3) && $user->hasRight('mailing', 'valider')) {
          if (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !$user->rights->mailing->mailing_advance->send) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NotEnoughPermissions")).'">'.$langs->trans("ResetMailing").'</a>';
          } else {
            print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?action=reset&amp;id='.$object->id.'">'.$langs->trans("ResetMailing").'</a>';
          }
        }
 
        if (($object->statut <= 1 && $user->hasRight('mailing', 'creer')) || $user->hasRight('mailing', 'supprimer')) {
          if ($object->statut > 0 && (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !$user->rights->mailing->mailing_advance->delete)) {
            print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->transnoentitiesnoconv("NotEnoughPermissions")).'">'.$langs->trans("DeleteMailing").'</a>';
          } else {
            print '<a class="butActionDelete" href="'.$_SERVER['PHP_SELF'].'?action=delete&token='.newToken().'&id='.$object->id.(!empty($urlfrom) ? '&urlfrom='.$urlfrom : '').'">'.$langs->trans("DeleteMailing").'</a>';
          }
        }
 
        print '</div>';
      }
 
      // Display of the TEST form
      if ($action == 'test') {
        print '<div id="formmailbeforetitle" name="formmailbeforetitle"></div>';
        print load_fiche_titre($langs->trans("TestMailing"));
 
        print dol_get_fiche_head(null, '', '', -1);
 
        // Create mail form object
        include_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
        $formmail = new FormMail($db);
        $formmail->fromname = $object->email_from;
        $formmail->frommail = $object->email_from;
        $formmail->withsubstit = 1;
        $formmail->withfrom = 0;
        $formmail->withto = $user->email ? $user->email : 1;
        $formmail->withtocc = 0;
        $formmail->withtoccc = $conf->global->MAIN_EMAIL_USECCC;
        $formmail->withtopic = 0;
        $formmail->withtopicreadonly = 1;
        $formmail->withfile = 0;
        $formmail->withbody = 0;
        $formmail->withbodyreadonly = 1;
        $formmail->withcancel = 1;
        $formmail->withdeliveryreceipt = 0;
        // Table of substitutions
        $formmail->substit = $object->substitutionarrayfortest;
        // Table of post's complementary params
        $formmail->param["action"] = "send";
        $formmail->param["models"] = 'none';
        $formmail->param["mailid"] = $object->id;
        $formmail->param["returnurl"] = $_SERVER['PHP_SELF']."?id=".$object->id;
 
        print $formmail->get_form();
 
        print '<br>';
 
        print dol_get_fiche_end();
 
        dol_set_focus('#sendto');
      }
 
 
      $htmltext = '<i>'.$langs->trans("FollowingConstantsWillBeSubstituted").':<br><br><span class="small">';
      foreach ($object->substitutionarray as $key => $val) {
        $htmltext .= $key.' = '.$langs->trans($val).'<br>';
      }
      $htmltext .= '</span></i>';
 
      // Print mail content
      print load_fiche_titre($langs->trans("EMail"), $form->textwithpicto('<span class="opacitymedium hideonsmartphone">'.$langs->trans("AvailableVariables").'</span>', $htmltext, 1, 'helpclickable', '', 0, 3, 'emailsubstitionhelp'), 'generic');
 
      print dol_get_fiche_head('', '', '', -1);
 
      print '<table class="bordernooddeven tableforfield centpercent">';
 
      // Subject
      print '<tr><td class="titlefield">'.$langs->trans("MailTopic").'</td><td colspan="3">'.$object->sujet.'</td></tr>';
 
      // Joined files
      print '<tr><td>'.$langs->trans("MailFile").'</td><td colspan="3">';
      // List of files
      $listofpaths = dol_dir_list($upload_dir, 'all', 0, '', '', 'name', SORT_ASC, 0);
      if (count($listofpaths)) {
        foreach ($listofpaths as $key => $val) {
          print img_mime($listofpaths[$key]['name']).' '.$listofpaths[$key]['name'];
          print '<br>';
        }
      } else {
        print '<span class="opacitymedium">'.$langs->trans("NoAttachedFiles").'</span><br>';
      }
      print '</td></tr>';
 
      // Background color
      /*print '<tr><td width="15%">'.$langs->trans("BackgroundColorByDefault").'</td><td colspan="3">';
      print $htmlother->selectColor($object->bgcolor,'bgcolor','',0);
      print '</td></tr>';*/
 
      print '</table>';
 
      // Message
      print '<div style="padding-top: 10px; background: '.($object->bgcolor ? (preg_match('/^#/', $object->bgcolor) ? '' : '#').$object->bgcolor : 'white').'">';
      if (empty($object->bgcolor) || strtolower($object->bgcolor) == 'ffffff') {  // CKEditor does not apply the color of the div into its content area
        $readonly = 1;
        // wysiwyg editor
        require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
        $doleditor = new DolEditor('bodyemail', $object->body, '', 600, 'dolibarr_mailings', '', false, true, empty($conf->global->FCKEDITOR_ENABLE_MAILING) ? 0 : 1, 20, '90%', $readonly);
        $doleditor->Create();
      } else {
        print dol_htmlentitiesbr($object->body);
      }
      print '</div>';
 
      print dol_get_fiche_end();
    } else {
      /*
       * Edition mode mailing (CKeditor or HTML source)
       */
 
      print dol_get_fiche_head($head, 'card', $langs->trans("Mailing"), -1, 'email');
 
      $linkback = '<a href="'.DOL_URL_ROOT.'/comm/mailing/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
 
      $morehtmlright = '';
      if ($object->statut == 2) {
        $morehtmlright .= ' ('.$object->countNbOfTargets('alreadysent').'/'.$object->nbemail.') ';
      }
 
      dol_banner_tab($object, 'id', $linkback, 1, 'rowid', 'ref', '', '', 0, '', $morehtmlright);
 
      print '<div class="fichecenter">';
      print '<div class="underbanner clearboth"></div>';
 
      print '<table class="border centpercent">';
 
      /*
      print '<tr><td class="titlefield">'.$langs->trans("Ref").'</td>';
      print '<td colspan="3">';
      print $form->showrefnav($object,'id', $linkback);
      print '</td></tr>';
      */
 
      // Topic
      print '<tr><td class="titlefield">'.$langs->trans("MailTitle").'</td><td colspan="3">'.$object->title.'</td></tr>';
      // From
      print '<tr><td class="titlefield">'.$langs->trans("MailFrom").'</td><td colspan="3">'.dol_print_email($object->email_from, 0, 0, 0, 0, 1).'</td></tr>';
      // To
      print '<tr><td>'.$langs->trans("MailErrorsTo").'</td><td colspan="3">'.dol_print_email($object->email_errorsto, 0, 0, 0, 0, 1).'</td></tr>';
 
      // Number of distinct emails
      print '<tr><td>';
      print $langs->trans("TotalNbOfDistinctRecipients");
      print '</td><td colspan="3">';
      $nbemail = ($object->nbemail ? $object->nbemail : 0);
      if (is_numeric($nbemail)) {
        $text = '';
        if ((!empty($conf->global->MAILING_LIMIT_SENDBYWEB) && $conf->global->MAILING_LIMIT_SENDBYWEB < $nbemail) && ($object->statut == 1 || $object->statut == 2)) {
          if ($conf->global->MAILING_LIMIT_SENDBYWEB > 0) {
            $text .= $langs->trans('LimitSendingEmailing', $conf->global->MAILING_LIMIT_SENDBYWEB);
          } else {
            $text .= $langs->trans('SendingFromWebInterfaceIsNotAllowed');
          }
        }
        if (empty($nbemail)) {
          $nbemail .= ' '.img_warning('').' <span class="warning">'.$langs->trans("NoTargetYet").'</span>';
        }
        if ($text) {
          print $form->textwithpicto($nbemail, $text, 1, 'warning');
        } else {
          print $nbemail;
        }
      }
      print '</td></tr>';
 
      // Other attributes
      $parameters = array();
      $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
      print $hookmanager->resPrint;
      if (empty($reshook)) {
        print $object->showOptionals($extrafields, 'edit', $parameters);
      }
 
      print '</table>';
      print '</div>';
 
      print dol_get_fiche_end();
 
 
 
      print "<br>\n";
 
      print '<form name="edit_mailing" action="card.php" method="post" enctype="multipart/form-data">'."\n";
      print '<input type="hidden" name="token" value="'.newToken().'">';
      print '<input type="hidden" name="action" value="update">';
      print '<input type="hidden" name="id" value="'.$object->id.'">';
 
      $htmltext = '<i>'.$langs->trans("FollowingConstantsWillBeSubstituted").':<br>';
      foreach ($object->substitutionarray as $key => $val) {
        $htmltext .= $key.' = '.$langs->trans($val).'<br>';
      }
      $htmltext .= '</i>';
 
      // Print mail content
      print load_fiche_titre($langs->trans("EMail"), $form->textwithpicto($langs->trans("AvailableVariables"), $htmltext, 1, 'help', '', 0, 2, 'emailsubstitionhelp'), 'generic');
 
      print dol_get_fiche_head(null, '', '', -1);
 
      print '<table class="bordernooddeven" width="100%">';
 
      // Subject
      print '<tr><td class="fieldrequired titlefield">'.$langs->trans("MailTopic").'</td><td colspan="3"><input class="flat quatrevingtpercent" type="text" name="sujet" value="'.$object->sujet.'"></td></tr>';
 
      $trackid = ''; // TODO To avoid conflicts with 2 mass emailing, we should set a trackid here, even if we use another one into email header.
      dol_init_file_process($upload_dir, $trackid);
 
      // Joined files
      $addfileaction = 'addfile';
      print '<tr><td>'.$langs->trans("MailFile").'</td>';
      print '<td colspan="3">';
      // List of files
      $listofpaths = dol_dir_list($upload_dir, 'all', 0, '', '', 'name', SORT_ASC, 0);
 
      // TODO Trick to have param removedfile containing nb of image to delete. But this does not works without javascript
      $out .= '<input type="hidden" class="removedfilehidden" name="removedfile" value="">'."\n";
      $out .= '<script type="text/javascript">';
      $out .= 'jQuery(document).ready(function () {';
      $out .= '    jQuery(".removedfile").click(function() {';
      $out .= '        jQuery(".removedfilehidden").val(jQuery(this).val());';
      $out .= '    });';
      $out .= '})';
      $out .= '</script>'."\n";
      if (count($listofpaths)) {
        foreach ($listofpaths as $key => $val) {
          $out .= '<div id="attachfile_'.$key.'">';
          $out .= img_mime($listofpaths[$key]['name']).' '.$listofpaths[$key]['name'];
          $out .= ' <input type="image" style="border: 0px;" src="'.img_picto($langs->trans("Search"), 'delete.png', '', '', 1).'" value="'.($key + 1).'" class="removedfile" id="removedfile_'.$key.'" name="removedfile_'.$key.'" />';
          $out .= '<br></div>';
        }
      } else {
        //$out .= '<span class="opacitymedium">'.$langs->trans("NoAttachedFiles").'</span><br>';
      }
 
      // Add link to add file
      $maxfilesizearray = getMaxFileSizeArray();
      $maxmin = $maxfilesizearray['maxmin'];
      if ($maxmin > 0) {
        $out .= '<input type="hidden" name="MAX_FILE_SIZE" value="'.($maxmin * 1024).'">';  // MAX_FILE_SIZE must precede the field type=file
      }
      $out .= '<input type="file" class="flat" id="addedfile" name="addedfile" value="'.$langs->trans("Upload").'" />';
      $out .= ' ';
      $out .= '<input type="submit" class="button smallpaddingimp" id="'.$addfileaction.'" name="'.$addfileaction.'" value="'.$langs->trans("MailingAddFile").'" />';
      print $out;
      print '</td></tr>';
 
      // Background color
      print '<tr><td>'.$langs->trans("BackgroundColorByDefault").'</td><td colspan="3">';
      print $htmlother->selectColor($object->bgcolor, 'bgcolor', '', 0);
      print '</td></tr>';
 
      print '</table>';
 
      // Message
      print '<div style="padding-top: 10px">';
 
      if ($action == 'edit') {
        // wysiwyg editor
        require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
        $doleditor = new DolEditor('bodyemail', $object->body, '', 600, 'dolibarr_mailings', '', true, true, getDolGlobalInt('FCKEDITOR_ENABLE_MAILING'), 20, '90%');
        $doleditor->Create();
      }
      if ($action == 'edithtml') {
        // HTML source editor
        require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
        $doleditor = new DolEditor('bodyemail', $object->body, '', 600, 'dolibarr_mailings', '', true, true, 'ace', 20, '90%');
        $doleditor->Create(0, '', false, 'HTML Source', 'php');
      }
 
      print '</div>';
 
 
      print dol_get_fiche_end();
 
      print '<div class="center">';
      print '<input type="submit" class="button buttonforacesave button-save" value="'.$langs->trans("Save").'" name="save">';
      print '&nbsp; &nbsp; &nbsp;';
      print '<input type="submit" class="button button-cancel" value="'.$langs->trans("Cancel").'" name="cancel">';
      print '</div>';
 
      print '</form>';
      print '<br>';
    }
  } else {
    dol_print_error($db, $object->error);
  }
}
 
// End of page
llxFooter();
$db->close();