doc_generic_invoice_odt.modules.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2010-2012  Laurent Destailleur <ely@users.sourceforge.net>
 * Copyright (C) 2012   Regis Houssin   <regis.houssin@inodbox.com>
 * Copyright (C) 2014   Marcos García   <marcosgdf@gmail.com>
 * Copyright (C) 2016   Charlie Benke   <charlie@patas-monkey.com>
 * Copyright (C) 2018-2024  Frédéric France   <frederic.france@free.fr>
 *
 * 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/>.
 * or see https://www.gnu.org/
 */
 
require_once DOL_DOCUMENT_ROOT.'/core/modules/facture/modules_facture.php';
require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/doc.lib.php';
 
 
class doc_generic_invoice_odt extends ModelePDFFactures
{
  public $version = 'dolibarr';
 
 
  public function __construct($db)
  {
    global $langs, $mysoc;
 
    // Load translation files required by the page
    $langs->loadLangs(array("main", "companies"));
 
    $this->db = $db;
    $this->name = "ODT/ODS templates";
    $this->description = $langs->trans("DocumentModelOdt");
    $this->scandir = 'FACTURE_ADDON_PDF_ODT_PATH'; // Name of constant that is used to save list of directories to scan
 
    // Page size for A4 format
    $this->type = 'odt';
    $this->page_largeur = 0;
    $this->page_hauteur = 0;
    $this->format = array($this->page_largeur, $this->page_hauteur);
    $this->marge_gauche = 0;
    $this->marge_droite = 0;
    $this->marge_haute = 0;
    $this->marge_basse = 0;
 
    $this->option_logo = 1; // Display logo
    $this->option_tva = 0; // Manage the vat option FACTURE_TVAOPTION
    $this->option_modereg = 1; // Display payment mode
    $this->option_condreg = 1; // Display payment terms
    $this->option_multilang = 1; // Available in several languages
    $this->option_escompte = 0; // Displays if there has been a discount
    $this->option_credit_note = 0; // Support credit notes
    $this->option_freetext = 1; // Support add of a personalised text
    $this->option_draft_watermark = 0; // Support add of a watermark on drafts
 
    // Recupere emetteur
    $this->emetteur = $mysoc;
    if (!$this->emetteur->country_code) {
      $this->emetteur->country_code = substr($langs->defaultlang, -2); // Par default, si n'etait pas defini
    }
  }
 
 
  public function info($langs)
  {
    global $conf, $langs;
 
    // Load translation files required by the page
    $langs->loadLangs(array("errors", "companies"));
 
    $form = new Form($this->db);
 
    $texte = $this->description.".<br>\n";
    $texte .= '<form action="'.$_SERVER["PHP_SELF"].'" method="POST" enctype="multipart/form-data">';
    $texte .= '<input type="hidden" name="token" value="'.newToken().'">';
    $texte .= '<input type="hidden" name="page_y" value="">';
    $texte .= '<input type="hidden" name="action" value="setModuleOptions">';
    $texte .= '<input type="hidden" name="param1" value="FACTURE_ADDON_PDF_ODT_PATH">';
    $texte .= '<table class="nobordernopadding" width="100%">';
 
    // List of directories area
    $texte .= '<tr><td valign="middle">';
    $texttitle = $langs->trans("ListOfDirectories");
    $listofdir = explode(',', preg_replace('/[\r\n]+/', ',', trim($conf->global->FACTURE_ADDON_PDF_ODT_PATH)));
    $listoffiles = array();
    foreach ($listofdir as $key => $tmpdir) {
      $tmpdir = trim($tmpdir);
      $tmpdir = preg_replace('/DOL_DATA_ROOT/', DOL_DATA_ROOT, $tmpdir);
      if (!$tmpdir) {
        unset($listofdir[$key]);
        continue;
      }
      if (!is_dir($tmpdir)) {
        $texttitle .= img_warning($langs->trans("ErrorDirNotFound", $tmpdir), 0);
      } else {
        $tmpfiles = dol_dir_list($tmpdir, 'files', 0, '\.(ods|odt)');
        if (count($tmpfiles)) {
          $listoffiles = array_merge($listoffiles, $tmpfiles);
        }
      }
    }
    $texthelp = $langs->trans("ListOfDirectoriesForModelGenODT");
    $texthelp .= '<br><br><span class="opacitymedium">'.$langs->trans("ExampleOfDirectoriesForModelGen").'</span>';
    // Add list of substitution keys
    $texthelp .= '<br>'.$langs->trans("FollowingSubstitutionKeysCanBeUsed").'<br>';
    $texthelp .= $langs->transnoentitiesnoconv("FullListOnOnlineDocumentation"); // This contains an url, we don't modify it
 
    $texte .= $form->textwithpicto($texttitle, $texthelp, 1, 'help', '', 1, 3, $this->name);
    $texte .= '<div><div style="display: inline-block; min-width: 100px; vertical-align: middle;">';
    $texte .= '<textarea class="flat" cols="60" name="value1">';
    $texte .= getDolGlobalString('FACTURE_ADDON_PDF_ODT_PATH');
    $texte .= '</textarea>';
    $texte .= '</div><div style="display: inline-block; vertical-align: middle;">';
    $texte .= '<input type="submit" class="button button-edit reposition smallpaddingimp" name="modify" value="'.dol_escape_htmltag($langs->trans("Modify")).'">';
    $texte .= '<br></div></div>';
 
    // Scan directories
    $nbofiles = count($listoffiles);
    if (getDolGlobalString('FACTURE_ADDON_PDF_ODT_PATH')) {
      $texte .= $langs->trans("NumberOfModelFilesFound").': <b>';
      //$texte.=$nbofiles?'<a id="a_'.get_class($this).'" href="#">':'';
      $texte .= count($listoffiles);
      //$texte.=$nbofiles?'</a>':'';
      $texte .= '</b>';
    }
    if ($nbofiles) {
      $texte .= '<div id="div_'.get_class($this).'" class="hiddenx">';
      // Show list of found files
      foreach ($listoffiles as $file) {
        $texte .= '- '.$file['name'].' <a href="'.DOL_URL_ROOT.'/document.php?modulepart=doctemplates&file=invoices/'.urlencode(basename($file['name'])).'">'.img_picto('', 'listlight').'</a>';
        $texte .= ' &nbsp; <a class="reposition" href="'.$_SERVER["PHP_SELF"].'?modulepart=doctemplates&keyforuploaddir=FACTURE_ADDON_PDF_ODT_PATH&action=deletefile&token='.newToken().'&file='.urlencode(basename($file['name'])).'">'.img_picto('', 'delete').'</a>';
        $texte .= '<br>';
      }
      $texte .= '</div>';
    }
    // Add input to upload a new template file.
    $texte .= '<div>'.$langs->trans("UploadNewTemplate");
    $maxfilesizearray = getMaxFileSizeArray();
    $maxmin = $maxfilesizearray['maxmin'];
    if ($maxmin > 0) {
      $texte .= '<input type="hidden" name="MAX_FILE_SIZE" value="'.($maxmin * 1024).'">';  // MAX_FILE_SIZE must precede the field type=file
    }
    $texte .= ' <input type="file" name="uploadfile">';
    $texte .= '<input type="hidden" value="FACTURE_ADDON_PDF_ODT_PATH" name="keyforuploaddir">';
    $texte .= '<input type="submit" class="button smallpaddingimp reposition" value="'.dol_escape_htmltag($langs->trans("Upload")).'" name="upload">';
    $texte .= '</div>';
    $texte .= '</td>';
 
    $texte .= '</tr>';
 
    $texte .= '</table>';
    $texte .= '</form>';
 
    return $texte;
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function write_file($object, $outputlangs, $srctemplatepath, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
  {
    // phpcs:enable
    global $user, $langs, $conf, $mysoc, $hookmanager;
 
    if (empty($srctemplatepath)) {
      dol_syslog("doc_generic_odt::write_file parameter srctemplatepath empty", LOG_WARNING);
      return -1;
    }
 
    // Add odtgeneration hook
    if (!is_object($hookmanager)) {
      include_once DOL_DOCUMENT_ROOT.'/core/class/hookmanager.class.php';
      $hookmanager = new HookManager($this->db);
    }
    $hookmanager->initHooks(array('odtgeneration'));
    global $action;
 
    if (!is_object($outputlangs)) {
      $outputlangs = $langs;
    }
    $sav_charset_output = $outputlangs->charset_output;
    $outputlangs->charset_output = 'UTF-8';
 
    // Load translation files required by the page
    $outputlangs->loadLangs(array("main", "dict", "companies", "bills"));
 
    if ($conf->facture->dir_output) {
      // If $object is id instead of object
      if (!is_object($object)) {
        $id = $object;
        $object = new Facture($this->db);
        $result = $object->fetch($id);
        if ($result < 0) {
          dol_print_error($this->db, $object->error);
          return -1;
        }
      }
 
      $object->fetch_thirdparty();
 
      $dir = empty($conf->facture->multidir_output[$object->entity]) ? $conf->facture->dir_output : $conf->facture->multidir_output[$object->entity];
      $objectref = dol_sanitizeFileName($object->ref);
      if (!preg_match('/specimen/i', $objectref)) {
        $dir .= "/".$objectref;
      }
      $file = $dir."/".$objectref.".odt";
 
      if (!file_exists($dir)) {
        if (dol_mkdir($dir) < 0) {
          $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
          return -1;
        }
      }
 
      if (file_exists($dir)) {
        //print "srctemplatepath=".$srctemplatepath;  // Src filename
        $newfile = basename($srctemplatepath);
        $newfiletmp = preg_replace('/\.od[ts]/i', '', $newfile);
        $newfiletmp = preg_replace('/template_/i', '', $newfiletmp);
        $newfiletmp = preg_replace('/modele_/i', '', $newfiletmp);
 
        $newfiletmp = $objectref . '_' . $newfiletmp;
 
        // Get extension (ods or odt)
        $newfileformat = substr($newfile, strrpos($newfile, '.') + 1);
        if (getDolGlobalString('MAIN_DOC_USE_TIMING')) {
          $format = getDolGlobalString('MAIN_DOC_USE_TIMING');
          if ($format == '1') {
            $format = '%Y%m%d%H%M%S';
          }
          $filename = $newfiletmp . '-' . dol_print_date(dol_now(), $format) . '.' . $newfileformat;
        } else {
          $filename = $newfiletmp . '.' . $newfileformat;
        }
        $file = $dir . '/' . $filename;
        //$file=$dir.'/'.$newfiletmp.'.'.dol_print_date(dol_now(),'%Y%m%d%H%M%S').'.odt';
        //print "newdir=".$dir;
        //print "newfile=".$newfile;
        //print "file=".$file;
        //print "conf->societe->dir_temp=".$conf->societe->dir_temp;
 
        dol_mkdir($conf->facture->dir_temp);
        if (!is_writable($conf->facture->dir_temp)) {
          $this->error = $langs->transnoentities("ErrorFailedToWriteInTempDirectory", $conf->facture->dir_temp);
          dol_syslog('Error in write_file: ' . $this->error, LOG_ERR);
          return -1;
        }
 
        // If BILLING contact defined on invoice, we use it
        $usecontact = false;
        $arrayidcontact = $object->getIdContact('external', 'BILLING');
        if (count($arrayidcontact) > 0) {
          $usecontact = true;
          $result = $object->fetch_contact($arrayidcontact[0]);
        }
 
        // Recipient name
        $contactobject = null;
        if (!empty($usecontact)) {
          // We can use the company of contact instead of thirdparty company
          if ($object->contact->socid != $object->thirdparty->id && (!isset($conf->global->MAIN_USE_COMPANY_NAME_OF_CONTACT) || getDolGlobalString('MAIN_USE_COMPANY_NAME_OF_CONTACT'))) {
            $object->contact->fetch_thirdparty();
            $socobject = $object->contact->thirdparty;
            $contactobject = $object->contact;
          } else {
            $socobject = $object->thirdparty;
            // if we have a BILLING contact and we don't use it as thirdparty recipient we store the contact object for later use
            $contactobject = $object->contact;
          }
        } else {
          $socobject = $object->thirdparty;
        }
 
        // Fetch info for linked propal
        $object->fetchObjectLinked('', '', '', '');
        //print_r($object->linkedObjects['propal']); exit;
 
        $propal_object = null;
        if (!empty($object->linkedObjects['propal'])) {
          $array_propal_object = $object->linkedObjects['propal'];
          if (isset($array_propal_object) && is_array($array_propal_object) && count($array_propal_object) > 0) {
            $tmparrayofvalue = array_values($array_propal_object);
            $propal_object = $tmparrayofvalue[0];
          }
        }
 
        // and determine category of operation
        $categoryOfOperation = 0;
        $nbProduct = 0;
        $nbService = 0;
        foreach ($object->lines as $line) {
          // determine category of operation
          if ($categoryOfOperation < 2) {
            $lineProductType = $line->product_type;
            if ($lineProductType == Product::TYPE_PRODUCT) {
              $nbProduct++;
            } elseif ($lineProductType == Product::TYPE_SERVICE) {
              $nbService++;
            }
            if ($nbProduct > 0 && $nbService > 0) {
              // mixed products and services
              $categoryOfOperation = 2;
            }
          }
        }
 
        // determine category of operation
        if ($categoryOfOperation <= 0) {
          // only services
          if ($nbProduct == 0 && $nbService > 0) {
            $categoryOfOperation = 1;
          }
        }
 
        // Make substitution
        $substitutionarray = array(
          '__FROM_NAME__' => $this->emetteur->name,
          '__FROM_EMAIL__' => $this->emetteur->email,
          '__TOTAL_TTC__' => $object->total_ttc,
          '__TOTAL_HT__' => $object->total_ht,
          '__TOTAL_VAT__' => $object->total_tva
        );
        complete_substitutions_array($substitutionarray, $langs, $object);
        // Call the ODTSubstitution hook
        $parameters = array('file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$substitutionarray);
        $reshook = $hookmanager->executeHooks('ODTSubstitution', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
 
        // Line of free text
        $newfreetext = '';
        $paramfreetext = 'INVOICE_FREE_TEXT';
        if (!empty($conf->global->$paramfreetext)) {
          $newfreetext = make_substitutions(getDolGlobalString($paramfreetext), $substitutionarray);
        }
 
        // Open and load template
        require_once ODTPHP_PATH.'odf.php';
        try {
          $odfHandler = new Odf(
            $srctemplatepath,
            array(
              'PATH_TO_TMP'   => $conf->facture->dir_temp,
              'ZIP_PROXY'     => 'PclZipProxy', // PhpZipProxy or PclZipProxy. Got "bad compression method" error when using PhpZipProxy.
              'DELIMITER_LEFT'  => '{',
              'DELIMITER_RIGHT' => '}'
            )
          );
        } catch (Exception $e) {
          $this->error = $e->getMessage();
          dol_syslog($e->getMessage(), LOG_INFO);
          return -1;
        }
        // After construction $odfHandler->contentXml contains content and
        // [!-- BEGIN row.lines --]*[!-- END row.lines --] has been replaced by
        // [!-- BEGIN lines --]*[!-- END lines --]
        //print html_entity_decode($odfHandler->__toString());
        //print exit;
 
 
        // Make substitutions into odt of freetext
        try {
          $odfHandler->setVars('free_text', $newfreetext, true, 'UTF-8');
        } catch (OdfException $e) {
          dol_syslog($e->getMessage(), LOG_INFO);
        }
 
        // Define substitution array
        $substitutionarray = getCommonSubstitutionArray($outputlangs, 0, null, $object);  // Set tags __...__
        $array_object_from_properties = $this->get_substitutionarray_each_var_object($object, $outputlangs);
        $array_objet = $this->get_substitutionarray_object($object, $outputlangs);      // Set tags object_...
        $array_user = $this->get_substitutionarray_user($user, $outputlangs);       // Set tags myuser_...
        $array_soc = $this->get_substitutionarray_mysoc($mysoc, $outputlangs);
        $array_thirdparty = $this->get_substitutionarray_thirdparty($socobject, $outputlangs);
        $array_propal = is_object($propal_object) ? $this->get_substitutionarray_object($propal_object, $outputlangs, 'propal') : array();
        $array_other = $this->get_substitutionarray_other($outputlangs);
        // retrieve contact information for use in object as contact_xxx tags
        $array_thirdparty_contact = array();
        if ($usecontact && is_object($contactobject)) {
          $array_thirdparty_contact = $this->get_substitutionarray_contact($contactobject, $outputlangs, 'contact');
        }
 
        $tmparray = array_merge($substitutionarray, $array_object_from_properties, $array_user, $array_soc, $array_thirdparty, $array_objet, $array_propal, $array_other, $array_thirdparty_contact);
        complete_substitutions_array($tmparray, $outputlangs, $object);
 
        // Complete also with substitution from keys directly found into template
        // TODO Search all tags {object_...:xxxx} into template then loop on this found tags to analyze them and the the corresponding
        // property of object and use the xxxx to know how to format it.
        // Before that, we hard code this substitution as if we have found them into the template.
 
        $tmparray['object_PREVIOUS_MONTH'] = dol_print_date(dol_time_plus_duree($object->date, -1, 'm'), '%m');
        $tmparray['object_MONTH'] = dol_print_date($object->date, '%m');
        $tmparray['object_NEXT_MONTH'] = dol_print_date(dol_time_plus_duree($object->date, 1, 'm'), '%m');
        $tmparray['object_PREVIOUS_MONTH_TEXT'] = dol_print_date(dol_time_plus_duree($object->date, -1, 'm'), '%B');
        $tmparray['object_MONTH_TEXT'] = dol_print_date($object->date, '%B');
        $tmparray['object_NEXT_MONTH_TEXT'] = dol_print_date(dol_time_plus_duree($object->date, 1, 'm'), '%B');
        $tmparray['object_PREVIOUS_YEAR'] = dol_print_date(dol_time_plus_duree($object->date, -1, 'y'), '%Y');
        $tmparray['object_YEAR'] = dol_print_date($object->date, '%Y');
        $tmparray['object_NEXT_YEAR'] = dol_print_date(dol_time_plus_duree($object->date, 1, 'y'), '%Y');
        $tmparray['object_productorservice_operation'] = $outputlangs->transnoentities("MentionCategoryOfOperations" . $categoryOfOperation);
 
 
        // Call the ODTSubstitution hook
        $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
        $reshook = $hookmanager->executeHooks('ODTSubstitution', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
 
        foreach ($tmparray as $key => $value) {
          try {
            if (preg_match('/logo$/', $key)) { // Image
              //var_dump($value);exit;
              if (file_exists($value)) {
                $odfHandler->setImage($key, $value);
              } else {
                $odfHandler->setVars($key, 'ErrorFileNotFound', true, 'UTF-8');
              }
            } else {
              // Text
              $odfHandler->setVars($key, $value, true, 'UTF-8');
            }
          } catch (OdfException $e) {
            dol_syslog($e->getMessage(), LOG_INFO);
          }
        }
        // Replace tags of lines
        $foundtagforlines = 1;
        try {
          $listlines = $odfHandler->setSegment('lines');
        } catch (OdfExceptionSegmentNotFound $e) {
          // We may arrive here if tags for lines not present into template
          $foundtagforlines = 0;
          dol_syslog($e->getMessage(), LOG_INFO);
        }
        if ($foundtagforlines) {
          $linenumber = 0;
          foreach ($object->lines as $line) {
            $linenumber++;
            $tmparray = $this->get_substitutionarray_lines($line, $outputlangs, $linenumber);
            complete_substitutions_array($tmparray, $outputlangs, $object, $line, "completesubstitutionarray_lines");
            // Call the ODTSubstitutionLine hook
            $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray, 'line'=>$line);
            $reshook = $hookmanager->executeHooks('ODTSubstitutionLine', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
            foreach ($tmparray as $key => $val) {
              try {
                $listlines->setVars($key, $val, true, 'UTF-8');
              } catch (SegmentException $e) {
                dol_syslog($e->getMessage(), LOG_INFO);
              }
            }
            $listlines->merge();
          }
          try {
            $odfHandler->mergeSegment($listlines);
          } catch (OdfException $e) {
            $this->error = $e->getMessage();
            dol_syslog($this->error, LOG_WARNING);
            return -1;
          }
        }
 
        // Replace labels translated
        $tmparray = $outputlangs->get_translations_for_substitutions();
        foreach ($tmparray as $key => $value) {
          try {
            $odfHandler->setVars($key, $value, true, 'UTF-8');
          } catch (OdfException $e) {
            dol_syslog($e->getMessage(), LOG_INFO);
          }
        }
 
        // Call the beforeODTSave hook
        $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
        $reshook = $hookmanager->executeHooks('beforeODTSave', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
 
        // Write new file
        if (getDolGlobalString('MAIN_ODT_AS_PDF')) {
          try {
            $odfHandler->exportAsAttachedPDF($file);
          } catch (Exception $e) {
            $this->error = $e->getMessage();
            dol_syslog($e->getMessage(), LOG_INFO);
            return -1;
          }
        } else {
          try {
            $odfHandler->saveToDisk($file);
          } catch (Exception $e) {
            $this->error = $e->getMessage();
            dol_syslog($e->getMessage(), LOG_INFO);
            return -1;
          }
        }
        $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
        $reshook = $hookmanager->executeHooks('afterODTCreation', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
 
        dolChmod($file);
 
        $odfHandler = null; // Destroy object
 
        $this->result = array('fullpath'=>$file);
 
        return 1; // Success
      } else {
        $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
        return -1;
      }
    }
 
    return -1;
  }
}