mailing.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2005      Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2005-2016 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2024-2025  Frédéric France             <frederic.france@free.fr>
 * Copyright (C) 2024   MDW             <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2025       Jon Bendtsen            <jon.bendtsen.github@jonb.dk>
 *
 * 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/>.
 */
 
require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
require_once DOL_DOCUMENT_ROOT.'/comm/mailing/class/mailing_targets.class.php';
 
class Mailing extends CommonObject
{
  public $element = 'mailing';
 
  public $table_element = 'mailing';
 
  public $picto = 'mail-bulk';
 
  public $messtype = 'email';
 
  public $title;
 
  public $sujet;
 
  public $body;
 
  public $evenunsubscribe;
 
  public $note_public;
 
  public $note_private;
 
  public $nbemail;
 
  public $bgcolor;
 
  public $bgimage;
 
  public $statut; // Status 0=Draft, 1=Validated, 2=Sent partially, 3=Sent completely
 
  public $status; // Status 0=Draft, 1=Validated, 2=Sent partially, 3=Sent completely
 
  public $email_from;
 
  public $sendto;
 
  public $email_replyto;
 
  public $email_errorsto;
 
  public $joined_file1;
 
  public $joined_file2;
 
  public $joined_file3;
 
  public $joined_file4;
 
  public $date_envoi;
 
  public $extraparams = array();
 
  public $statut_dest = array();
 
  public $substitutionarray;
 
  public $substitutionarrayfortest;
 
  public $targets = array();
 
  public $fk_project;
 
  public $fields = array(
    'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'index' => 1, 'position' => 1, 'comment' => 'Id'),
    'fk_project' => array('type' => 'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)', 'label' => 'Fk project', 'enabled' => "isModEnabled('project')", 'visible' => -1, 'position' => 10),
  );
 
  const STATUS_DRAFT = 0;
  const STATUS_VALIDATED = 1;
  const STATUS_SENTPARTIALY = 2;
  const STATUS_SENTCOMPLETELY = 3;
 
 
  public function __construct($db)
  {
    $this->db = $db;
 
    // List of language codes for status
    $this->labelStatus[0] = 'MailingStatusDraft';
    $this->labelStatus[1] = 'MailingStatusValidated';
    $this->labelStatus[2] = 'MailingStatusSentPartialy';
    $this->labelStatus[3] = 'MailingStatusSentCompletely';
 
    $this->statut_dest[0] = 'MailingStatusNotSent';
    $this->statut_dest[1] = 'MailingStatusSent';
    $this->statut_dest[2] = 'MailingStatusRead';
    $this->statut_dest[3] = 'MailingStatusReadAndUnsubscribe'; // Read but ask to not be contacted anymore
    $this->statut_dest[-1] = 'MailingStatusError';
  }
 
  public function create($user, $notrigger = 0)
  {
    global $conf, $langs;
 
    // Check properties
    if (preg_match('/^InvalidHTMLStringCantBeCleaned/', $this->body)) {
      $this->error = 'InvalidHTMLStringCantBeCleaned';
      return -1;
    }
 
    $this->title = trim($this->title);
    $this->email_from = trim($this->email_from);
    if (empty($this->messtype)) {
      $this->messtype = 'email';
    }
    if (!$this->email_from) {
      if ($this->messtype !== 'sms') {
        $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("MailFrom"));
      } else {
        $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("PhoneFrom"));
      }
      return -1;
    }
 
    $error = 0;
    $now = dol_now();
 
    $this->db->begin();
 
    $sql = "INSERT INTO ".MAIN_DB_PREFIX."mailing";
    $sql .= " (messtype, date_creat, fk_user_creat, entity)";
    $sql .= " VALUES ('".$this->db->escape($this->messtype)."', '".$this->db->idate($now)."', ".((int) $user->id).", ".((int) $conf->entity).")";
 
    if (!$this->title) {
      $this->title = $langs->trans("NoTitle");
    }
 
    dol_syslog(__METHOD__, LOG_DEBUG);
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."mailing");
 
      $result = $this->update($user, 1);
      if ($result < 0) {
        $error++;
      }
 
      if (!$error && !$notrigger) {
        // Call trigger
        $result = $this->call_trigger('MAILING_CREATE', $user);
        if ($result < 0) {
          $error++;
        }
        // End call triggers
      }
 
      if (!$error) {
        $this->db->commit();
        return $this->id;
      } else {
        $this->db->rollback();
        dol_syslog(__METHOD__ . ' ' . $this->error, LOG_ERR);
        return -2;
      }
    } else {
      $this->error = $this->db->lasterror();
      $this->db->rollback();
      return -1;
    }
  }
 
  public function update($user, $notrigger = 0)
  {
    global $langs;
 
    // Check properties
    if (preg_match('/^InvalidHTMLStringCantBeCleaned/', $this->body)) {
      $this->error = 'InvalidHTMLStringCantBeCleaned';
      return -1;
    }
 
    if (empty($this->messtype)) {
      $this->messtype = 'email';
    }
 
    $error = 0;
    $this->db->begin();
 
    $sql = "UPDATE ".MAIN_DB_PREFIX."mailing";
    $sql .= " SET titre = '".$this->db->escape($this->title)."'";
    $sql .= ", messtype = '".$this->db->escape($this->messtype)."'";
    $sql .= ", sujet = '".$this->db->escape($this->sujet)."'";
    $sql .= ", body = '".$this->db->escape($this->body)."'";
    $sql .= ", email_from = '".$this->db->escape($this->email_from)."'";
    $sql .= ", email_replyto = '".$this->db->escape($this->email_replyto)."'";
    $sql .= ", email_errorsto = '".$this->db->escape($this->email_errorsto)."'";
    $sql .= ", bgcolor = '".($this->bgcolor ? $this->db->escape($this->bgcolor) : null)."'";
    $sql .= ", bgimage = '".($this->bgimage ? $this->db->escape($this->bgimage) : null)."'";
    $sql .= ", evenunsubscribe = ".((int) $this->evenunsubscribe);
    $sql .= ", note_public = '".$this->db->escape($this->note_public)."'";
    $sql .= ", note_private = '".$this->db->escape($this->note_private)."'";
    $sql .= ", fk_project = '".((int) $this->fk_project)."'";
    $sql .= " WHERE rowid = ".(int) $this->id;
 
    dol_syslog(__METHOD__, LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      if (!$error && !$notrigger) {
        // Call trigger
        $result = $this->call_trigger('MAILING_MODIFY', $user);
        if ($result < 0) {
          $error++;
        }
        // End call triggers
      }
 
      if (!$error) {
        dol_syslog(__METHOD__ . ' success');
        $this->db->commit();
        return 1;
      } else {
        $this->db->rollback();
        dol_syslog(__METHOD__ . ' ' . $this->error, LOG_ERR);
        return -2;
      }
    } else {
      if ($this->db->lasterrno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
        $this->error = $langs->trans("ErrorTitleAlreadyExists", $this->title);
      } else {
        $this->error = $this->db->lasterror();
      }
      $this->db->rollback();
      return -1;
    }
  }
 
  public function fetch($rowid, $ref = '')
  {
    $sql = "SELECT m.rowid, m.messtype, m.titre as title, m.entity, m.sujet, m.body, m.bgcolor, m.bgimage, m.evenunsubscribe";
    $sql .= ", m.note_public, m.note_private";
    $sql .= ", m.email_from, m.email_replyto, m.email_errorsto";
    $sql .= ", m.statut as status, m.nbemail";
    $sql .= ", m.fk_user_creat, m.fk_user_valid";
    $sql .= ", m.tms as date_modification";
    $sql .= ", m.date_creat";
    $sql .= ", m.date_valid";
    $sql .= ", m.date_envoi";
    $sql .= ", m.extraparams";
    $sql .= ", m.tag";
    $sql .= ", m.name_from";
    $sql .= ", m.fk_user_modif";
    $sql .= ", m.fk_user_appro";
    $sql .= ", m.date_appro";
    $sql .= ", m.cible";
    $sql .= ", m.joined_file1";
    $sql .= ", m.joined_file2";
    $sql .= ", m.joined_file3";
    $sql .= ", m.joined_file4";
    $sql .= ", m.fk_project";
    $sql .= " FROM ".MAIN_DB_PREFIX."mailing as m";
    $sql .= " WHERE entity IN (".getEntity('mailing').")";
    if ($ref) {
      $sql .= " AND m.titre = '".$this->db->escape($ref)."'";
    } else {
      $sql .= " AND m.rowid = ".(int) $rowid;
    }
 
    dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
    $result = $this->db->query($sql);
    if ($result) {
      if ($this->db->num_rows($result)) {
        $obj = $this->db->fetch_object($result);
 
        $this->id = $obj->rowid;
        $this->entity = $obj->entity;
        $this->ref = $obj->rowid;
        $this->title = $obj->title;
        $this->messtype = $obj->messtype;
 
        $this->statut = $obj->status; // deprecated
        $this->status = $obj->status;
 
        $this->nbemail = $obj->nbemail;
 
        $this->sujet = $obj->sujet;
        if (getDolGlobalString('FCKEDITOR_ENABLE_MAILING') && dol_textishtml(dol_html_entity_decode($obj->body, ENT_COMPAT | ENT_HTML5))) {
          $this->body = dol_html_entity_decode($obj->body, ENT_COMPAT | ENT_HTML5);
        } else {
          $this->body = $obj->body;
        }
 
        $this->bgcolor = $obj->bgcolor;
        $this->bgimage = $obj->bgimage;
        $this->evenunsubscribe = $obj->evenunsubscribe;
        $this->note_public = $obj->note_public;
        $this->note_private = $obj->note_private;
 
        $this->email_from = $obj->email_from;
        $this->email_replyto = $obj->email_replyto;
        $this->email_errorsto = $obj->email_errorsto;
 
        $this->user_creation_id = $obj->fk_user_creat;
        $this->user_validation_id = $obj->fk_user_valid;
 
        $this->date_creation = $this->db->jdate($obj->date_creat);
        $this->date_validation = $this->db->jdate($obj->date_valid);
        $this->date_envoi = $this->db->jdate($obj->date_envoi);
        $this->date_modification = $this->db->jdate($obj->date_modification); // tms
 
        $this->extraparams = (array) json_decode($obj->extraparams, true);
 
        $this->tag = $obj->tag;
        $this->name_from = $obj->name_from;
        $this->fk_user_modif = $obj->fk_user_modif;
        $this->fk_user_appro = $obj->fk_user_appro;
        $this->date_appro = $obj->date_appro;
        $this->cible = $obj->cible;
        $this->joined_file1 = $obj->joined_file1;
        $this->joined_file2 = $obj->joined_file2;
        $this->joined_file3 = $obj->joined_file3;
        $this->joined_file4 = $obj->joined_file4;
        $this->fk_project = $obj->fk_project;
 
        if ($this->messtype == 'sms') {
          $this->picto = 'phone';
        }
 
        return 1;
      } else {
        dol_syslog(get_class($this)."::fetch Erreur -1");
        return -1;
      }
    } else {
      dol_syslog(get_class($this)."::fetch Erreur -2");
      return -2;
    }
  }
 
  public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, $filter = '', $filtermode = 'AND')
  {
    dol_syslog(__METHOD__, LOG_DEBUG);
 
    $records = array();
 
    $sql = 'SELECT ';
    $sql .= $this->getFieldList('t');
    $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element.' as t';
    if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
      $sql .= ' WHERE t.entity IN ('.getEntity($this->element).')';
    } else {
      $sql .= ' WHERE 1 = 1';
    }
 
    // Manage filter
    if (is_array($filter)) {  // deprecated, use $filter = USF syntax
      dol_syslog("You are using a deprecated use of fetchAll. filter parameter must be an USF string now.", LOG_WARNING);
      $sqlwhere = array();
      if (count($filter) > 0) {
        foreach ($filter as $key => $value) {
          if ($key == 't.rowid' || $key == 't.fk_soc' || $key == 't.fk_project') {
            $sqlwhere[] = $this->db->sanitize($key).' = '.((int) $value);
          } elseif (!empty($this->fields[$key]) && in_array($this->fields[$key]['type'], array('date', 'datetime', 'timestamp'))) {
            $sqlwhere[] = $this->db->sanitize($key)." = '".$this->db->idate((int) $value)."'";
          } elseif ($key == 'customsql') {
            $sqlwhere[] = $value;
          } elseif (strpos($value, '%') === false) {
            $sqlwhere[] = $this->db->sanitize($key).' IN ('.$this->db->sanitize($this->db->escape($value)).')';
          } else {
            $sqlwhere[] = $this->db->sanitize($key)." LIKE '%".$this->db->escape($value)."%'";
          }
        }
      }
      if (count($sqlwhere) > 0) {
        $sql .= ' AND ('.implode(' '.$this->db->escape($filtermode).' ', $sqlwhere).')';
      }
 
      $filter = '';
    }
 
    // Manage filter
    $errormessage = '';
    $sql .= forgeSQLFromUniversalSearchCriteria($filter, $errormessage);
    if ($errormessage) {
      $this->errors[] = $errormessage;
      dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
      return -1;
    }
 
    if (!empty($sortfield)) {
      $sql .= $this->db->order($sortfield, $sortorder);
    }
    if (!empty($limit)) {
      $sql .= $this->db->plimit($limit, $offset);
    }
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      $i = 0;
      while ($i < ($limit ? min($limit, $num) : $num)) {
        $obj = $this->db->fetch_object($resql);
 
        $record = new self($this->db);
        $record->setVarsFromFetchObj($obj);
 
        $records[$record->id] = $record;
 
        $i++;
      }
      $this->db->free($resql);
 
      return $records;
    } else {
      $this->errors[] = 'Error '.$this->db->lasterror();
      dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
 
      return -1;
    }
  }
 
  public function createFromClone(User $user, $fromid, $option1, $option2, $notrigger = 0)
  {
    global $langs;
 
    $error = 0;
 
    $object = new Mailing($this->db);
 
    $this->db->begin();
 
    // Load source object
    $object->fetch($fromid);
    $object->id = 0;
    $object->status = 0;
    $object->statut = 0;
 
    // Clear fields
    $object->title = $langs->trans("CopyOf").' '.$object->title.' '.dol_print_date(dol_now());
 
    // If no option copy content
    if (empty($option1)) {
      // Clear values
      $object->nbemail            = 0;
      $object->sujet              = '';
      $object->body               = '';
      $object->bgcolor            = '';
      $object->bgimage            = '';
      $object->evenunsubscribe    = 0;
      $object->note_public        = '';
      $object->note_private       = '';
 
      //$object->email_from         = '';   // We do not reset from email because it is a mandatory value
      $object->email_replyto      = '';
      $object->email_errorsto     = '';
 
      $object->user_creation_id = $user->id;
      $object->user_validation_id = null;
 
      $object->date_envoi         = null;
    }
 
    // Create clone
    $object->context['createfromclone'] = 'createfromclone';
    $result = $object->create($user, $notrigger);
 
    // Other options
    if ($result < 0) {
      $this->setErrorsFromObject($object);
      $error++;
    }
 
    if (!$error) {
      // Clone recipient targets
      if (!empty($option2)) {
        require_once DOL_DOCUMENT_ROOT.'/core/modules/mailings/modules_mailings.php';
 
        $mailing_target = new MailingTargets($this->db);
 
        $target_array = array();
 
        $sql = "SELECT fk_contact,";
        $sql .= " lastname,";
        $sql .= " firstname,";
        $sql .= " email,";
        $sql .= " other,";
        $sql .= " source_url,";
        $sql .= " source_id ,";
        $sql .= " source_type";
        $sql .= " FROM ".MAIN_DB_PREFIX."mailing_cibles";
        $sql .= " WHERE fk_mailing = ".((int) $fromid);
 
        $result = $this->db->query($sql);
        if ($result) {
          if ($this->db->num_rows($result)) {
            while ($obj = $this->db->fetch_object($result)) {
              $target_array[] = array(
                'fk_contact' => $obj->fk_contact,
                'lastname' => $obj->lastname,
                'firstname' => $obj->firstname,
                'email' => $obj->email,
                'other' => $obj->other,
                'source_url' => $obj->source_url,
                'source_id' => $obj->source_id,
                'source_type' => $obj->source_type
              );
            }
          }
        } else {
          $this->error = $this->db->lasterror();
          return -1;
        }
 
        $mailing_target->addTargetsToDatabase($object->id, $target_array);
      }
    }
 
    unset($object->context['createfromclone']);
 
    // End
    if (!$error) {
      $this->db->commit();
      return $object->id;
    } else {
      $this->db->rollback();
      return -1;
    }
  }
 
  public function valid($user)
  {
    $now = dol_now();
 
    $sql = "UPDATE ".MAIN_DB_PREFIX."mailing ";
    $sql .= " SET statut = 1, date_valid = '".$this->db->idate($now)."', fk_user_valid=".$user->id;
    $sql .= " WHERE rowid = ".((int) $this->id);
 
    dol_syslog("Mailing::valid", LOG_DEBUG);
    if ($this->db->query($sql)) {
      return 1;
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
  }
 
  public function setDraft($user)
  {
    $now = dol_now();
 
    $sql = "UPDATE ".MAIN_DB_PREFIX."mailing ";
    $sql .= " SET statut = 0, tms = '".$this->db->idate($now)."', fk_user_modif=".$user->id;
    $sql .= " WHERE rowid = ".((int) $this->id);
 
    dol_syslog("Mailing::valid", LOG_DEBUG);
    if ($this->db->query($sql)) {
      return 1;
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
  }
 
  public function delete($user, $notrigger = 0)
  {
    $error = 0;
 
    $this->db->begin();
 
    if (!$notrigger) {
      $result = $this->call_trigger('MAILING_DELETE', $user);
      if ($result < 0) {
        $error++;
      }
    }
 
    if (!$error) {
      $sql = "DELETE FROM " . MAIN_DB_PREFIX . "mailing";
      $sql .= " WHERE rowid = " . ((int) $this->id);
 
      dol_syslog(__METHOD__, LOG_DEBUG);
      $resql = $this->db->query($sql);
      if ($resql) {
        $res = $this->delete_targets();
        if ($res <= 0) {
          $error++;
        }
 
        if (!$error) {
          dol_syslog(__METHOD__ . ' success');
          $this->db->commit();
          return 1;
        } else {
          $this->db->rollback();
          dol_syslog(__METHOD__ . ' ' . $this->error, LOG_ERR);
          return -2;
        }
      } else {
        $this->db->rollback();
        $this->error = $this->db->lasterror();
        return -1;
      }
    } else {
      $this->db->rollback();
      return -1;
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function delete_targets()
  {
    // phpcs:enable
    $sql = "DELETE FROM ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
 
    dol_syslog("Mailing::delete_targets", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $this->refreshNbOfTargets();
 
      return 1;
    } else {
      $this->error = $this->db->lasterror();
      return 0;
    }
  }
 
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function reset_targets_status($user)
  {
    // phpcs:enable
    $sql = "UPDATE ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " SET statut = 0";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
 
    dol_syslog("Mailing::reset_targets_status", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      return 1;
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
  }
 
  public function resetTargetErrorStatus($user, $id)
  {
    // phpcs:enable
    global $langs;
 
    $sql = "SELECT email, statut FROM ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
    $sql .= " AND rowid = ".((int) $id);
    $resql = $this->db->query($sql);
    if ($resql) {
      $nb = $this->db->num_rows($resql);
      $obj = $this->db->fetch_object($resql);
      if ($obj->statut != -1) {
        $langs->load("errors");
        $this->error = $langs->trans('ErrorIsNotInError', $obj->email);
        return 0;
      }
    } else {
      $this->error = $this->db->lasterror();
    }
 
    $sql = "UPDATE ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " SET statut = 0";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
    $sql .= " AND rowid = ".((int) $id);
    $sql .= " AND statut = -1";
 
    dol_syslog("Mailing::reset_targets_status", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      return 1;
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
  }
 
  public function countNbOfTargets($mode)
  {
    $sql = "SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
    if ($mode == 'alreadysent') {
      $sql .= " AND statut <> 0";
    } elseif ($mode == 'alreadysentok') {
      $sql .= " AND statut > 0";
    } elseif ($mode == 'alreadysentko') {
      $sql .= " AND statut = -1";
    } elseif ($mode == 'all') {
      // just want to return all possible recipients
    } else {
      $this->error = 'BadValueForParameterMode';
      return -2;
    }
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $obj = $this->db->fetch_object($resql);
      if ($obj) {
        return $obj->nb;
      }
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
    return 0;
  }
 
  public function refreshNbOfTargets()
  {
    $sql = "SELECT COUNT(rowid) as nb";
    $sql .= " FROM ".MAIN_DB_PREFIX."mailing_cibles";
    $sql .= " WHERE fk_mailing = ".((int) $this->id);
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $obj = $this->db->fetch_object($resql);
      if ($obj) {
        $nbforupdate = $obj->nb;
 
        $sql = 'UPDATE '.MAIN_DB_PREFIX.'mailing SET nbemail = '.((int) $nbforupdate);
        $sql .= ' WHERE rowid = '.((int) $this->id);
 
        $resqlupdate = $this->db->query($sql);
        if (! $resqlupdate) {
          $this->error = $this->db->lasterror();
          return -1;
        } else {
          $this->nbemail = (int) $nbforupdate;
        }
      }
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
 
    return 1;
  }
 
  public function getTooltipContentArray($params)
  {
    global $langs;
 
    //$nofetch = !empty($params['nofetch']);
    $langs->load('mails');
 
    $datas = array();
    $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("ShowEMailing").'</u>';
    if (isset($this->status)) {
      $datas['picto'] .= ' '.$this->getLibStatut(5);
    }
    $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
    if (isset($this->title)) {
      $datas['title'] = '<br><b>'.$langs->trans('MailTitle').':</b> '.$this->title;
    }
    if (isset($this->sujet)) {
      $datas['subject'] = '<br><b>'.$langs->trans('MailTopic').':</b> '.$this->sujet;
    }
 
    return $datas;
  }
 
  public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $morecss = '', $save_lastsearch_value = -1)
  {
    global $conf, $langs, $hookmanager;
 
    if (!empty($conf->dol_no_mouse_hover)) {
      $notooltip = 1; // Force disable tooltips
    }
 
    $result = '';
    $params = [
      'id' => $this->id,
      'objecttype' => $this->element,
      'option' => $option,
      'nofetch' => 1,
    ];
    $classfortooltip = 'classfortooltip';
    $dataparams = '';
    if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
      $classfortooltip = 'classforajaxtooltip';
      $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
      $label = '';
    } else {
      $label = implode($this->getTooltipContentArray($params));
    }
 
    $url = DOL_URL_ROOT.'/comm/mailing/card.php?id='.$this->id;
 
    if ($option != 'nolink') {
      // Add param to save lastsearch_values or not
      $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
      if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
        $add_save_lastsearch_values = 1;
      }
      if ($add_save_lastsearch_values) {
        $url .= '&save_lastsearch_values=1';
      }
    }
 
    $linkclose = '';
    if (empty($notooltip)) {
      if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
        $label = $langs->trans("ShowEMailing");
        $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
      }
      $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
      $linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
    } else {
      $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
    }
 
    $linkstart = '<a href="'.$url.'"';
    $linkstart .= $linkclose.'>';
    $linkend = '</a>';
 
    $result .= $linkstart;
    if ($withpicto) {
      $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), (($withpicto != 2) ? 'class="paddingright"' : ''), 0, 0, $notooltip ? 0 : 1);
    }
    if ($withpicto != 2) {
      $result .= $this->ref;
    }
    $result .= $linkend;
    //if ($withpicto != 2) $result.=(($addlabel && $this->label) ? $sep . dol_trunc($this->label, ($addlabel > 1 ? $addlabel : 0)) : '');
 
    global $action;
    $hookmanager->initHooks(array('emailingdao'));
    $parameters = array('id' => $this->id, 'getnomurl' => &$result);
    $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
    if ($reshook > 0) {
      $result = $hookmanager->resPrint;
    } else {
      $result .= $hookmanager->resPrint;
    }
 
    return $result;
  }
 
  public function getLibStatut($mode = 0)
  {
    return $this->LibStatut($this->status, $mode);
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function LibStatut($status, $mode = 0)
  {
    // phpcs:enable
    global $langs;
    $langs->load("mailing");
 
    $labelStatus = $langs->transnoentitiesnoconv($this->labelStatus[$status]);
    $labelStatusShort = $langs->transnoentitiesnoconv($this->labelStatus[$status]);
 
    $statusType = 'status'.$status;
    if ($status == 2) {
      $statusType = 'status3';
    }
    if ($status == 3) {
      $statusType = 'status6';
    }
 
    return dolGetStatus($labelStatus, $labelStatusShort, '', $statusType, $mode);
  }
 
 
  public static function libStatutDest($status, $mode = 0, $desc = '')
  {
    global $langs;
    $langs->load("mails");
 
    $labelStatus = array();
    $labelStatusShort = array();
 
    $labelStatus[-1] = $langs->transnoentitiesnoconv('MailingStatusError');
    $labelStatus[0] = $langs->transnoentitiesnoconv('MailingStatusNotSent');
    $labelStatus[1] = $langs->transnoentitiesnoconv('MailingStatusSent');
    $labelStatus[2] = $langs->transnoentitiesnoconv('MailingStatusRead');
    $labelStatus[3] = $langs->transnoentitiesnoconv('MailingStatusNotContact');
    $labelStatusShort[-1] = $langs->transnoentitiesnoconv('MailingStatusError');
    $labelStatusShort[0] = $langs->transnoentitiesnoconv('MailingStatusNotSent');
    $labelStatusShort[1] = $langs->transnoentitiesnoconv('MailingStatusSent');
    $labelStatusShort[2] = $langs->transnoentitiesnoconv('MailingStatusRead');
    $labelStatusShort[3] = $langs->transnoentitiesnoconv('MailingStatusNotContact');
 
    $statusType = 'status'.$status;
    if ($status == -1) {
      $statusType = 'status8';
    }
    if ($status == 1) {
      $statusType = 'status6';
    }
    if ($status == 2) {
      $statusType = 'status4';
    }
 
    $param = array();
    if ($status == -1) {
      $param = array('badgeParams' => array('attr' => array('title' => $desc)));
    }
 
    return dolGetStatus($labelStatus[$status], $labelStatusShort[$status], '', $statusType, $mode, '', $param);
  }
}