pdf_standard.modules.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2017   Laurent Destailleur <eldy@stocks.sourceforge.net>
 * Copyright (C) 2022   Ferran Marcet <fmarcet@2byte.es>
 * Copyright (C) 2022   Nicolas Silobre <nsilobre@ns-info90.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/stock/modules_stock.php';
require_once DOL_DOCUMENT_ROOT.'/product/stock/class/entrepot.class.php';
require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.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/pdf.lib.php';
 
 
class pdf_standard extends ModelePDFStock
{
  public $db;
 
  public $name;
 
  public $description;
 
  public $type;
 
  public $phpmin = array(7, 0);
 
  public $version = 'dolibarr';
 
  public $emetteur;
 
  public $wref;
  public $posxdesc;
  public $posxlabel;
  public $posxtva;
  public $posxqty;
  public $posxup;
  public $posxunit;
  public $posxdiscount;
  public $postotalht;
 
  public $tabTitleHeight;
 
 
  public function __construct($db)
  {
    global $conf, $langs, $mysoc;
 
    // Load traductions files required by page
    $langs->loadLangs(array("main", "companies"));
 
    $this->db = $db;
    $this->name = "standard";
    $this->description = $langs->trans("DocumentModelStandardPDF");
 
    // Page size for A4 format
    $this->type = 'pdf';
    $formatarray = pdf_getFormat();
    $this->page_largeur = $formatarray['width'];
    $this->page_hauteur = $formatarray['height'];
    $this->format = array($this->page_largeur, $this->page_hauteur);
    $this->marge_gauche = getDolGlobalInt('MAIN_PDF_MARGIN_LEFT', 10);
    $this->marge_droite = getDolGlobalInt('MAIN_PDF_MARGIN_RIGHT', 10);
    $this->marge_haute = getDolGlobalInt('MAIN_PDF_MARGIN_TOP', 10);
    $this->marge_basse = getDolGlobalInt('MAIN_PDF_MARGIN_BOTTOM', 10);
 
    $this->option_logo = 1; // Display logo
    $this->option_codestockservice = 0; // Display product-service code
    $this->option_multilang = 1; // Available in several languages
    $this->option_freetext = 0; // Support add of a personalised text
 
    // Get source company
    $this->emetteur = $mysoc;
    if (!$this->emetteur->country_code) {
      $this->emetteur->country_code = substr($langs->defaultlang, -2); // By default if not defined
    }
 
    // Define position of columns
    $this->wref = 35;
    $this->posxdesc = $this->marge_gauche + 1;
    $this->posxlabel = $this->posxdesc + $this->wref;
    $this->posxtva = 80;
    $this->posxqty = 95;
    $this->posxup = 115;
    $this->posxunit = 135;
    $this->posxdiscount = 155;
    $this->postotalht = 175;
 
    if (!empty($conf->global->MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT) || !empty($conf->global->MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT_COLUMN)) {
      $this->posxtva = $this->posxup;
    }
    $this->posxpicture = $this->posxtva - (empty($conf->global->MAIN_DOCUMENTS_WITH_PICTURE_WIDTH) ? 20 : $conf->global->MAIN_DOCUMENTS_WITH_PICTURE_WIDTH); // width of images
    if ($this->page_largeur < 210) { // To work with US executive format
      $this->posxpicture -= 20;
      $this->posxtva -= 20;
      $this->posxup -= 20;
      $this->posxqty -= 20;
      $this->posxunit -= 20;
      $this->posxdiscount -= 20;
      $this->postotalht -= 20;
    }
 
    $this->tabTitleHeight = 11;
  }
 
 
  // 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, $db, $hookmanager;
 
    if (!is_object($outputlangs)) {
      $outputlangs = $langs;
    }
    // For backward compatibility with FPDF, force output charset to ISO, because FPDF expect text to be encoded in ISO
    if (!empty($conf->global->MAIN_USE_FPDF)) {
      $outputlangs->charset_output = 'ISO-8859-1';
    }
 
    // Load traductions files required by page
    $outputlangs->loadLangs(array("main", "dict", "companies", "bills", "stocks", "orders", "deliveries"));
 
    if ($conf->stock->dir_output) {
      // Definition of $dir and $file
      if ($object->specimen) {
        $dir = $conf->stock->dir_output;
        $file = $dir."/SPECIMEN.pdf";
      } else {
        $objectref = dol_sanitizeFileName($object->ref);
        $dir = $conf->stock->dir_output."/".$objectref;
        $file = $dir."/".$objectref.".pdf";
      }
 
      $stockFournisseur = new ProductFournisseur($this->db);
      $supplierprices = $stockFournisseur->list_product_fournisseur_price($object->id);
      $object->supplierprices = $supplierprices;
 
      $productstatic = new Product($this->db);
 
      if (!file_exists($dir)) {
        if (dol_mkdir($dir) < 0) {
          $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
          return -1;
        }
      }
 
      if (file_exists($dir)) {
        // Add pdfgeneration hook
        if (!is_object($hookmanager)) {
          include_once DOL_DOCUMENT_ROOT.'/core/class/hookmanager.class.php';
          $hookmanager = new HookManager($this->db);
        }
        $hookmanager->initHooks(array('pdfgeneration'));
        $parameters = array('file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs);
        global $action;
        $reshook = $hookmanager->executeHooks('beforePDFCreation', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
 
        // Create pdf instance
        $pdf = pdf_getInstance($this->format);
        $default_font_size = pdf_getPDFFontSize($outputlangs); // Must be after pdf_getInstance
        $pdf->SetAutoPageBreak(1, 0);
 
        $heightforinfotot = 40; // Height reserved to output the info and total part
        $heightforfreetext = (isset($conf->global->MAIN_PDF_FREETEXT_HEIGHT) ? $conf->global->MAIN_PDF_FREETEXT_HEIGHT : 5); // Height reserved to output the free text on last page
        $heightforfooter = $this->marge_basse + 8; // Height reserved to output the footer (value include bottom margin)
        if (!empty($conf->global->MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS)) {
          $heightforfooter += 6;
        }
 
        if (class_exists('TCPDF')) {
          $pdf->setPrintHeader(false);
          $pdf->setPrintFooter(false);
        }
        $pdf->SetFont(pdf_getPDFFont($outputlangs));
        // Set path to the background PDF File
        if (empty($conf->global->MAIN_DISABLE_FPDI) && !empty($conf->global->MAIN_ADD_PDF_BACKGROUND)) {
          $pagecount = $pdf->setSourceFile($conf->mycompany->dir_output.'/'.$conf->global->MAIN_ADD_PDF_BACKGROUND);
          $tplidx = $pdf->importPage(1);
        }
 
        $pdf->Open();
        $pagenb = 0;
        $pdf->SetDrawColor(128, 128, 128);
 
        $pdf->SetTitle($outputlangs->convToOutputCharset($object->ref));
        $pdf->SetSubject($outputlangs->transnoentities("Stock"));
        $pdf->SetCreator("Dolibarr ".DOL_VERSION);
        $pdf->SetAuthor($outputlangs->convToOutputCharset($user->getFullName($outputlangs)));
        $pdf->SetKeyWords($outputlangs->convToOutputCharset($object->ref)." ".$outputlangs->transnoentities("Stock")." ".$outputlangs->convToOutputCharset($object->label));
        if (getDolGlobalString('MAIN_DISABLE_PDF_COMPRESSION')) {
          $pdf->SetCompression(false);
        }
 
        $pdf->SetMargins($this->marge_gauche, $this->marge_haute, $this->marge_droite); // Left, Top, Right
 
 
        // New page
        $pdf->AddPage();
        if (!empty($tplidx)) {
          $pdf->useTemplate($tplidx);
        }
        $pagenb++;
        $top_shift = $this->_pagehead($pdf, $object, 1, $outputlangs);
        $pdf->SetFont('', '', $default_font_size - 1);
        $pdf->MultiCell(0, 3, ''); // Set interline to 3
        $pdf->SetTextColor(0, 0, 0);
 
        $tab_top = 65 + $top_shift;
        $tab_top_newpage = (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD') ? 42 + $top_shift : 10);
 
        $tab_height = $this->page_hauteur - $tab_top - $heightforfooter - $heightforfreetext;
 
 
        // Show list of product in warehouse                                          */
 
        $totalunit = 0;
        $totalvalue = $totalvaluesell = 0;
 
        $sortfield = 'p.ref';
        $sortorder = 'ASC';
 
        $sql = "SELECT p.rowid as rowid, p.ref, p.label as produit, p.tobatch, p.fk_product_type as type, p.pmp as ppmp, p.price, p.price_ttc, p.entity,";
        $sql .= " ps.reel as value";
        $sql .= " FROM ".MAIN_DB_PREFIX."product_stock as ps, ".MAIN_DB_PREFIX."product as p";
        $sql .= " WHERE ps.fk_product = p.rowid";
        $sql .= " AND ps.reel <> 0"; // We do not show if stock is 0 (no product in this warehouse)
        $sql .= " AND ps.fk_entrepot = ".((int) $object->id);
        $sql .= $this->db->order($sortfield, $sortorder);
 
        //dol_syslog('List products', LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
          $num = $this->db->num_rows($resql);
          $i = 0;
          $nblines = $num;
 
          $nexY = $tab_top + $this->tabTitleHeight;
 
          for ($i = 0; $i < $nblines; $i++) {
            $curY = $nexY;
 
            $objp = $this->db->fetch_object($resql);
 
            // Multilangs
            if (getDolGlobalInt('MAIN_MULTILANGS')) { // si l'option est active
              $sql = "SELECT label";
              $sql .= " FROM ".MAIN_DB_PREFIX."product_lang";
              $sql .= " WHERE fk_product = ".((int) $objp->rowid);
              $sql .= " AND lang = '".$this->db->escape($langs->getDefaultLang())."'";
              $sql .= " LIMIT 1";
 
              $result = $this->db->query($sql);
              if ($result) {
                $objtp = $this->db->fetch_object($result);
                if ($objtp->label != '') {
                  $objp->produit = $objtp->label;
                }
              }
            }
 
            $pdf->SetFont('', '', $default_font_size - 1); // Into loop to work with multipage
            $pdf->SetTextColor(0, 0, 0);
 
            $pdf->setTopMargin($tab_top_newpage);
            $pdf->setPageOrientation('', 1, $heightforfooter + $heightforfreetext + $heightforinfotot); // The only function to edit the bottom margin of current page to set it.
            $pageposbefore = $pdf->getPage();
 
            // Description of product line
            $curX = $this->posxdesc - 1;
 
            $showpricebeforepagebreak = 1;
 
            $pdf->startTransaction();
            $pdf->writeHTMLCell($this->wref, 3, $curX, $curY, $outputlangs->convToOutputCharset($objp->ref), 0, 1, false, true, 'J', true);
            //pdf_writelinedesc($pdf, $object, $i, $outputlangs, $this->posxtva - $curX, 3, $curX, $curY, $hideref, $hidedesc);
            $pageposafter = $pdf->getPage();
            if ($pageposafter > $pageposbefore) { // There is a pagebreak
              $pdf->rollbackTransaction(true);
              $pageposafter = $pageposbefore;
              //print $pageposafter.'-'.$pageposbefore;exit;
              $pdf->setPageOrientation('', 1, $heightforfooter); // The only function to edit the bottom margin of current page to set it.
              $pdf->writeHTMLCell($this->wref, 4, $curX, $curY, $outputlangs->convToOutputCharset($objp->ref), 0, 1, false, true, 'J', true);
              //pdf_writelinedesc($pdf, $object, $i, $outputlangs, $this->posxtva - $curX, 4, $curX, $curY, $hideref, $hidedesc);
              $pageposafter = $pdf->getPage();
              $posyafter = $pdf->GetY();
              if ($posyafter > ($this->page_hauteur - ($heightforfooter + $heightforfreetext + $heightforinfotot))) { // There is no space left for total+free text
                if ($i == ($nblines - 1)) { // No more lines, and no space left to show total, so we create a new page
                  $pdf->AddPage('', '', true);
                  if (!empty($tplidx)) {
                    $pdf->useTemplate($tplidx);
                  }
                  if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
                    $this->_pagehead($pdf, $object, 0, $outputlangs);
                  }
                  $pdf->setPage($pageposafter + 1);
                }
              } else {
                // We found a page break
 
                // Allows data in the first page if description is long enough to break in multiples pages
                if (!empty($conf->global->MAIN_PDF_DATA_ON_FIRST_PAGE)) {
                  $showpricebeforepagebreak = 1;
                } else {
                  $showpricebeforepagebreak = 0;
                }
              }
            } else // No pagebreak
            {
              $pdf->commitTransaction();
            }
            $posYAfterDescription = $pdf->GetY();
 
            $nexY = $pdf->GetY();
            $pageposafter = $pdf->getPage();
 
            $pdf->setPage($pageposbefore);
            $pdf->setTopMargin($this->marge_haute);
            $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it.
 
            // We suppose that a too long description is moved completely on next page
            if ($pageposafter > $pageposbefore && empty($showpricebeforepagebreak)) {
              $pdf->setPage($pageposafter);
              $curY = $tab_top_newpage;
            }
 
            $pdf->SetFont('', '', $default_font_size - 1); // On repositionne la police par defaut
 
            $productstatic->id = $objp->rowid;
            $productstatic->ref = $objp->ref;
            $productstatic->label = $objp->produit;
            $productstatic->type = $objp->type;
            $productstatic->entity = $objp->entity;
            $productstatic->status_batch = $objp->tobatch;
 
            // Ref.
            //$pdf->SetXY($this->posxdesc, $curY);
            //$pdf->MultiCell($this->wref, 3, $productstatic->ref, 0, 'L');
 
            // Label
            $pdf->SetXY($this->posxlabel + 0.8, $curY);
            $pdf->MultiCell($this->posxqty - $this->posxlabel - 0.8, 3, dol_trunc($productstatic->label, 24), 0, 'L');
 
            // Quantity
            $valtoshow = price2num($objp->value, 'MS');
            $towrite = (empty($valtoshow) ? '0' : $valtoshow);
 
            $pdf->SetXY($this->posxqty, $curY);
            $pdf->MultiCell($this->posxup - $this->posxqty - 0.8, 3, $towrite, 0, 'R');
 
            // AWP
            $totalunit += $objp->value;
 
            $pdf->SetXY($this->posxup, $curY);
            $pdf->MultiCell($this->posxunit - $this->posxup - 0.8, 3, price(price2num($objp->ppmp, 'MU'), 0, $outputlangs), 0, 'R');
 
            // Total PMP
            $pdf->SetXY($this->posxunit, $curY);
            $pdf->MultiCell($this->posxdiscount - $this->posxunit - 0.8, 3, price(price2num($objp->ppmp * $objp->value, 'MT'), 0, $outputlangs), 0, 'R');
            $totalvalue += price2num($objp->ppmp * $objp->value, 'MT');
 
            // Price sell min
            if (empty($conf->global->PRODUIT_MULTIPRICES)) {
              $pricemin = $objp->price;
              $pdf->SetXY($this->posxdiscount, $curY);
              $pdf->MultiCell($this->postotalht - $this->posxdiscount, 3, price(price2num($pricemin, 'MU'), 0, $outputlangs), 0, 'R', 0);
 
              // Total sell min
              $pdf->SetXY($this->postotalht, $curY);
              $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 3, price(price2num($pricemin * $objp->value, 'MT'), 0, $outputlangs), 0, 'R', 0);
            }
            $totalvaluesell += price2num($pricemin * $objp->value, 'MT');
 
            // Add line
            if (!empty($conf->global->MAIN_PDF_DASH_BETWEEN_LINES) && $i < ($nblines - 1)) {
              $pdf->setPage($pageposafter);
              $pdf->SetLineStyle(array('dash'=>'1,1', 'color'=>array(80, 80, 80)));
              //$pdf->SetDrawColor(190,190,200);
              $pdf->line($this->marge_gauche, $nexY + 1, $this->page_largeur - $this->marge_droite, $nexY + 1);
              $pdf->SetLineStyle(array('dash'=>0));
            }
 
            $nexY += 2; // Add space between lines
 
            // Detect if some page were added automatically and output _tableau for past pages
            while ($pagenb < $pageposafter) {
              $pdf->setPage($pagenb);
              if ($pagenb == 1) {
                $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforfooter, 0, $outputlangs, 0, 1, $object->multicurrency_code);
              } else {
                $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforfooter, 0, $outputlangs, 1, 1, $object->multicurrency_code);
              }
              $this->_pagefoot($pdf, $object, $outputlangs, 1);
              $pagenb++;
              $pdf->setPage($pagenb);
              $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it.
              if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
                $this->_pagehead($pdf, $object, 0, $outputlangs);
              }
              if (!empty($tplidx)) {
                $pdf->useTemplate($tplidx);
              }
            }
            if (isset($object->lines[$i + 1]->pagebreak) && $object->lines[$i + 1]->pagebreak) {
              if ($pagenb == 1) {
                $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforfooter, 0, $outputlangs, 0, 1, $object->multicurrency_code);
              } else {
                $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforfooter, 0, $outputlangs, 1, 1, $object->multicurrency_code);
              }
              $this->_pagefoot($pdf, $object, $outputlangs, 1);
              // New page
              $pdf->AddPage();
              if (!empty($tplidx)) {
                $pdf->useTemplate($tplidx);
              }
              $pagenb++;
              if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
                $this->_pagehead($pdf, $object, 0, $outputlangs);
              }
            }
          }
 
          $this->db->free($resql);
 
          //$nexY = $pdf->GetY();
          $nexY += 2;
          $curY = $nexY;
 
          if ($nblines > 0) {
            $pdf->SetLineStyle(array('dash'=>'0', 'color'=>array(200, 200, 200)));
            $pdf->line($this->marge_gauche, $curY - 1, $this->page_largeur - $this->marge_droite, $curY - 1);
            $pdf->SetLineStyle(array('dash'=>0));
 
            $pdf->SetFont('', 'B', $default_font_size - 1);
            $pdf->SetTextColor(0, 0, 0);
 
            // Ref.
            $pdf->SetXY($this->posxdesc, $curY);
            $pdf->MultiCell($this->wref, 3, $langs->trans("Total"), 0, 'L');
 
            // Quantity
            $valtoshow = price2num($totalunit, 'MS');
            $towrite = empty($valtoshow) ? '0' : $valtoshow;
 
            $pdf->SetXY($this->posxqty, $curY);
            $pdf->MultiCell($this->posxup - $this->posxqty - 0.8, 3, $towrite, 0, 'R');
 
            // Total PMP
            $pdf->SetXY($this->posxunit, $curY);
            $pdf->MultiCell($this->posxdiscount - $this->posxunit - 0.8, 3, price(price2num($totalvalue, 'MT'), 0, $outputlangs), 0, 'R');
 
            // Price sell min
            if (empty($conf->global->PRODUIT_MULTIPRICES)) {
              // Total sell min
              $pdf->SetXY($this->postotalht, $curY);
              $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 3, price(price2num($totalvaluesell, 'MT'), 0, $outputlangs), 0, 'R', 0);
            }
          }
        } else {
          dol_print_error($this->db);
        }
 
        // Displays notes
        $notetoshow = empty($object->note_public) ? '' : $object->note_public;
 
        if ($notetoshow) {
          $substitutionarray = pdf_getSubstitutionArray($outputlangs, null, $object);
          complete_substitutions_array($substitutionarray, $outputlangs, $object);
          $notetoshow = make_substitutions($notetoshow, $substitutionarray, $outputlangs);
          $notetoshow = convertBackOfficeMediasLinksToPublicLinks($notetoshow);
 
          $tab_top = 88;
 
          $pdf->SetFont('', '', $default_font_size - 1);
          $pdf->writeHTMLCell(190, 3, $this->posxdesc - 1, $tab_top, dol_htmlentitiesbr($notetoshow), 0, 1);
          $nexY = $pdf->GetY();
          $height_note = $nexY - $tab_top;
 
          // Rect takes a length in 3rd parameter
          $pdf->SetDrawColor(192, 192, 192);
          $pdf->Rect($this->marge_gauche, $tab_top - 1, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $height_note + 1);
 
          $tab_height = $tab_height - $height_note;
          $tab_top = $nexY + 6;
        } else {
          $height_note = 0;
        }
 
        /*$iniY = $tab_top + 7;
        $curY = $tab_top + 7;
        $nexY = $tab_top + 7;
 
        $tab_top = $tab_top_newpage + 25 + $top_shift;*/
 
        // Show square
        if ($pagenb == 1) {
          $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforinfotot - $heightforfreetext - $heightforfooter, 0, $outputlangs, 0, 0, $object->multicurrency_code);
          $bottomlasttab = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter + 1;
        } else {
          $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforinfotot - $heightforfreetext - $heightforfooter, 0, $outputlangs, 1, 0, $object->multicurrency_code);
          $bottomlasttab = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter + 1;
        }
 
        $bottomlasttab = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter + 1;
 
        // Affiche zone infos
        //$posy=$this->_tableau_info($pdf, $object, $bottomlasttab, $outputlangs);
 
        // Affiche zone totaux
        //$posy=$this->_tableau_tot($pdf, $object, $deja_regle, $bottomlasttab, $outputlangs);
 
        // Pied de page
        $this->_pagefoot($pdf, $object, $outputlangs);
        if (method_exists($pdf, 'AliasNbPages')) {
          $pdf->AliasNbPages();
        }
 
        $pdf->Close();
 
        $pdf->Output($file, 'F');
 
        // Add pdfgeneration hook
        $hookmanager->initHooks(array('pdfgeneration'));
        $parameters = array('file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs);
        global $action;
        $reshook = $hookmanager->executeHooks('afterPDFCreation', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
        if ($reshook < 0) {
          $this->error = $hookmanager->error;
          $this->errors = $hookmanager->errors;
        }
 
        dolChmod($file);
 
        $this->result = array('fullpath'=>$file);
 
        return 1; // No error
      } else {
        $this->error = $langs->trans("ErrorCanNotCreateDir", $dir);
        return 0;
      }
    } else {
      $this->error = $langs->trans("ErrorConstantNotDefined", "PRODUCT_OUTPUTDIR");
      return 0;
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  protected function _tableau(&$pdf, $tab_top, $tab_height, $nexY, $outputlangs, $hidetop = 0, $hidebottom = 0, $currency = '')
  {
    global $conf;
 
    // Force to disable hidetop and hidebottom
    $hidebottom = 0;
    if ($hidetop) {
      $hidetop = -1;
    }
 
    $currency = !empty($currency) ? $currency : $conf->currency;
    $default_font_size = pdf_getPDFFontSize($outputlangs);
 
    // Amount in (at tab_top - 1)
    $pdf->SetTextColor(0, 0, 0);
    $pdf->SetFont('', '', $default_font_size - 2);
 
    if (empty($hidetop)) {
      $titre = $outputlangs->transnoentities("AmountInCurrency", $outputlangs->transnoentitiesnoconv("Currency".$currency));
      $pdf->SetXY($this->page_largeur - $this->marge_droite - ($pdf->GetStringWidth($titre) + 3), $tab_top - 4);
      $pdf->MultiCell(($pdf->GetStringWidth($titre) + 3), 2, $titre);
 
      //$conf->global->MAIN_PDF_TITLE_BACKGROUND_COLOR='230,230,230';
      if (!empty($conf->global->MAIN_PDF_TITLE_BACKGROUND_COLOR)) {
        $pdf->Rect($this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_droite - $this->marge_gauche, 5, 'F', null, explode(',', $conf->global->MAIN_PDF_TITLE_BACKGROUND_COLOR));
      }
    }
 
    $pdf->SetDrawColor(128, 128, 128);
 
    $pdf->SetFont('', 'B', $default_font_size - 3);
 
    // Output Rect
    $this->printRect($pdf, $this->marge_gauche, $tab_top, $this->page_largeur-$this->marge_gauche-$this->marge_droite, $tab_height, $hidetop, $hidebottom); // Rect takes a length in 3rd parameter and 4th parameter
 
    $pdf->SetLineStyle(array('dash'=>'0', 'color'=>array(200, 200, 200)));
    $pdf->SetDrawColor(200, 200, 200);
    $pdf->line($this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_droite, $tab_top);
    $pdf->SetLineStyle(array('dash'=>0));
    $pdf->SetDrawColor(128, 128, 128);
    $pdf->SetTextColor(0, 0, 0);
 
 
    if (empty($hidetop)) {
      $pdf->line($this->marge_gauche, $tab_top+11, $this->page_largeur-$this->marge_droite, $tab_top+11); // line takes a position y in 2nd parameter and 4th parameter
      $pdf->SetXY($this->posxdesc - 1, $tab_top + 1);
      $pdf->MultiCell($this->wref, 3, $outputlangs->transnoentities("Ref"), '', 'L');
    }
 
    $pdf->line($this->posxlabel-1, $tab_top, $this->posxlabel-1, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->posxlabel - 1, $tab_top + 1);
      $pdf->MultiCell($this->posxqty - $this->posxlabel - 1, 2, $outputlangs->transnoentities("Label"), '', 'C');
    }
 
    $pdf->line($this->posxqty-1, $tab_top, $this->posxqty-1, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->posxqty - 1, $tab_top + 1);
      $pdf->MultiCell($this->posxup - $this->posxqty - 1, 2, $outputlangs->transnoentities("Units"), '', 'C');
    }
 
    $pdf->line($this->posxup-1, $tab_top, $this->posxup-1, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->posxup - 1, $tab_top + 1);
      $pdf->MultiCell($this->posxunit - $this->posxup - 1, 2, $outputlangs->transnoentities("AverageUnitPricePMPShort"), '', 'C');
    }
 
    $pdf->line($this->posxunit - 1, $tab_top, $this->posxunit - 1, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->posxunit - 1, $tab_top + 1);
      $pdf->MultiCell($this->posxdiscount - $this->posxunit - 1, 2, $outputlangs->transnoentities("EstimatedStockValueShort"), '', 'C');
    }
 
    $pdf->line($this->posxdiscount-1, $tab_top, $this->posxdiscount-1, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->posxdiscount - 1, $tab_top + 1);
      $pdf->MultiCell($this->postotalht - $this->posxdiscount + 1, 2, $outputlangs->transnoentities("SellPriceMin"), '', 'C');
    }
 
    $pdf->line($this->postotalht, $tab_top, $this->postotalht, $tab_top + $tab_height);
    if (empty($hidetop)) {
      $pdf->SetXY($this->postotalht - 1, $tab_top + 1);
      $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 2, $outputlangs->transnoentities("EstimatedStockValueSellShort"), '', 'C');
    }
 
    if (empty($hidetop)) {
      $pdf->SetDrawColor(200, 200, 200);
      $pdf->SetLineStyle(array('dash' => '0', 'color' => array(200, 200, 200)));
      $pdf->line($this->marge_gauche, $tab_top + $this->tabTitleHeight, $this->page_largeur - $this->marge_droite, $tab_top + $this->tabTitleHeight);
      $pdf->SetLineStyle(array('dash' => 0));
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  protected function _pagehead(&$pdf, $object, $showaddress, $outputlangs, $titlekey = "")
  {
    global $conf, $langs, $db, $hookmanager;
 
    // Load traductions files required by page
    $outputlangs->loadLangs(array("main", "propal", "companies", "bills", "orders", "stocks"));
 
    $default_font_size = pdf_getPDFFontSize($outputlangs);
 
    if ($object->type == 1) {
      $titlekey = 'ServiceSheet';
    } else {
      $titlekey = 'StockSheet';
    }
 
    pdf_pagehead($pdf, $outputlangs, $this->page_hauteur);
 
    // Show Draft Watermark
    if ($object->statut == 0 && (!empty($conf->global->STOCK_DRAFT_WATERMARK))) {
      pdf_watermark($pdf, $outputlangs, $this->page_hauteur, $this->page_largeur, 'mm', $conf->global->STOCK_DRAFT_WATERMARK);
    }
 
    $pdf->SetTextColor(0, 0, 60);
    $pdf->SetFont('', 'B', $default_font_size + 3);
 
    $posy = $this->marge_haute;
    $posx = $this->page_largeur - $this->marge_droite - 100;
 
    $pdf->SetXY($this->marge_gauche, $posy);
 
    // Logo
    $height = 0;
    $logo = $conf->mycompany->dir_output.'/logos/'.$this->emetteur->logo;
    if ($this->emetteur->logo) {
      if (is_readable($logo)) {
        $height = pdf_getHeightForLogo($logo);
        $pdf->Image($logo, $this->marge_gauche, $posy, 0, $height); // width=0 (auto)
      } else {
        $pdf->SetTextColor(200, 0, 0);
        $pdf->SetFont('', 'B', $default_font_size - 2);
        $pdf->MultiCell(100, 3, $outputlangs->transnoentities("ErrorLogoFileNotFound", $logo), 0, 'L');
        $pdf->MultiCell(100, 3, $outputlangs->transnoentities("ErrorGoToGlobalSetup"), 0, 'L');
      }
    } else {
      $text = $this->emetteur->name;
      $pdf->MultiCell(100, 4, $outputlangs->convToOutputCharset($text), 0, 'L');
    }
 
    $yafterleft = $pdf->GetY() + $height;
 
    $pdf->SetFont('', 'B', $default_font_size + 3);
    $pdf->SetXY($posx, $posy);
    $pdf->SetTextColor(0, 0, 60);
 
    $pdf->MultiCell(100, 4, $outputlangs->transnoentities("Warehouse").' '.$outputlangs->convToOutputCharset($object->label), '', 'R');
 
    $posy += 6;
    $pdf->SetFont('', '', $default_font_size - 1);
    $pdf->SetXY($posx, $posy);
    $pdf->SetTextColor(0, 0, 60);
    if (!empty($object->lieu)) {
      $pdf->MultiCell(100, 3, $outputlangs->transnoentities("Label").' : '.$object->lieu, '', 'R');
    }
 
 
    $posy += 4;
    $pdf->SetXY($posx, $posy);
    $pdf->SetTextColor(0, 0, 60);
 
    // Parent entrepot
    $e = new Entrepot($this->db);
    $hasparent = (!empty($object->fk_parent) && $e->fetch($object->fk_parent) > 0);
 
    if ($hasparent) {
      $pdf->MultiCell(100, 3, $outputlangs->transnoentities("ParentWarehouse").' :', '', 'R');
 
      $posy += 4;
      $pdf->SetXY($posx - 50, $posy);
      $pdf->MultiCell(150, 3, $e->label, '', 'R');
    }
 
    $yafterright = $pdf->GetY();
 
    // Description
    $nbpage = $pdf->getPage();
    if ($nbpage == 1) {
      $nexY = max($yafterleft, $yafterright);
      $nexY += 5;
      $pdf->SetXY($posx, $posy);
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("Description").' : </b>'.nl2br($object->description), 0, 1);
      $nexY = $pdf->GetY();
 
      $calcproductsunique = $object->nb_different_products();
      $calcproducts = $object->nb_products();
 
      // Total nb of different products
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("NumberOfDifferentProducts").' : </b>'.(empty($calcproductsunique['nb']) ? '0' : $calcproductsunique['nb']), 0, 1);
      $nexY = $pdf->GetY();
 
      // Nb of products
      $valtoshow = price2num($calcproducts['nb'], 'MS');
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("NumberOfProducts").' : </b>'.(empty($valtoshow) ? '0' : $valtoshow), 0, 1);
      $nexY = $pdf->GetY();
 
      // Value
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("EstimatedStockValueShort").' : </b>'.price((empty($calcproducts['value']) ? '0' : price2num($calcproducts['value'], 'MT')), 0, $langs, 0, -1, -1, $conf->currency), 0, 1);
      $nexY = $pdf->GetY();
 
      // Value
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("Date").' : </b>'.dol_print_date(dol_now(), 'dayhour'), 0, 1);
      $nexY = $pdf->GetY();
 
      // Last movement
      $sql = "SELECT max(m.datem) as datem";
      $sql .= " FROM ".MAIN_DB_PREFIX."stock_mouvement as m";
      $sql .= " WHERE m.fk_entrepot = ".((int) $object->id);
      $resqlbis = $this->db->query($sql);
      if ($resqlbis) {
        $obj = $this->db->fetch_object($resqlbis);
        $lastmovementdate = $this->db->jdate($obj->datem);
      } else {
        dol_print_error($this->db);
      }
 
      if ($lastmovementdate) {
        $toWrite = dol_print_date($lastmovementdate, 'dayhour').' ';
      } else {
        $toWrite = $outputlangs->transnoentities("None");
      }
 
      $pdf->writeHTMLCell(190, 2, $this->marge_gauche, $nexY, '<b>'.$outputlangs->transnoentities("LastMovement").' : </b>'.$toWrite, 0, 1);
    }
    $nexY = $pdf->GetY();
 
    $posy += 2;
 
    $top_shift = 0;
    // Show list of linked objects
    $current_y = $pdf->getY();
    $posy = pdf_writeLinkedObjects($pdf, $object, $outputlangs, $posx, $posy, 100, 3, 'R', $default_font_size);
    if ($current_y < $pdf->getY()) {
      $top_shift = $pdf->getY() - $current_y;
    }
 
    $pdf->SetTextColor(0, 0, 0);
 
    return $top_shift;
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  protected function _pagefoot(&$pdf, $object, $outputlangs, $hidefreetext = 0)
  {
    $showdetails = getDolGlobalInt('MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS', 0);
    return pdf_pagefoot($pdf, $outputlangs, 'PRODUCT_FREE_TEXT', $this->emetteur, $this->marge_basse, $this->marge_gauche, $this->page_hauteur, $object, $showdetails, $hidefreetext);
  }
}