pdf_canelle.modules.php

Go to the documentation of this file.

<?php
 
/* Copyright (C) 2010-2011  Juanjo Menent        <jmenent@2byte.es>
 * Copyright (C) 2010-2014  Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2015       Marcos García        <marcosgdf@gmail.com>
 * Copyright (C) 2018-2025  Frédéric France      <frederic.france@free.fr>
 * Copyright (C) 2024-2025  MDW          <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024     Nick Fragoulis
 * Copyright (C) 2025       Joachim Küter        <git-jk@bloxera.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/>.
 * or see https://www.gnu.org/
 */
 
require_once DOL_DOCUMENT_ROOT.'/core/modules/supplier_invoice/modules_facturefournisseur.php';
require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.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/pdf.lib.php';
 
 
class pdf_canelle extends ModelePDFSuppliersInvoices
{
  public $db;
 
  public $name;
 
  public $description;
 
  public $update_main_doc_field;
 
  public $type;
 
  public $version = 'dolibarr';
 
 
  public function __construct($db)
  {
    global $conf, $langs, $mysoc;
 
    // Translations
    $langs->loadLangs(array("main", "bills"));
 
    $this->db = $db;
    $this->name = "canelle";
    $this->description = $langs->trans('SuppliersInvoiceModel');
    $this->update_main_doc_field = 1; // Save the name of generated file as the main doc when generating a doc with this template
 
    // Page dimensions
    $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->corner_radius = getDolGlobalInt('MAIN_PDF_FRAME_CORNER_RADIUS', 0);
    $this->option_logo = 1; // Display logo
    $this->option_tva = 1; // 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
 
    // Define column position
    $this->posxdesc = $this->marge_gauche + 1;
 
    if (getDolGlobalInt('PRODUCT_USE_UNITS')) {
      $this->posxtva = 99;
      $this->posxup = 114;
      $this->posxqty = 130;
      $this->posxunit = 147;
    } else {
      $this->posxtva = 106;
      $this->posxup = 122;
      $this->posxqty = 145;
      $this->posxunit = 162;
    }
    $this->posxdiscount = 162;
    $this->postotalht = 174;
 
    /* if (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT') || getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT_COLUMN')) {
      $this->posxtva = $this->posxup;
    } */
    $this->posxpicture = $this->posxtva - (getDolGlobalInt('MAIN_DOCUMENTS_WITH_PICTURE_WIDTH', 20)); // 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->tva = array();
    $this->tva_array = array();
    $this->localtax1 = array();
    $this->localtax2 = array();
    $this->atleastoneratenotnull = 0;
    $this->atleastonediscount = 0;
  }
 
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function write_file($object, $outputlangs = null, $srctemplatepath = '', $hidedetails = 0, $hidedesc = 0, $hideref = 0)
  {
    // phpcs:enable
    global $user, $langs, $conf, $mysoc, $hookmanager, $nblines;
 
    // Get source company
    if (!is_object($object->thirdparty)) {
      $object->fetch_thirdparty();
    }
    if (!is_object($object->thirdparty)) {
      $object->thirdparty = $mysoc; // If fetch_thirdparty fails, object has no socid (specimen)
    }
 
    $this->emetteur = $object->thirdparty;
    if (!$this->emetteur->country_code) {
      $this->emetteur->country_code = substr($langs->defaultlang, -2); // By default, if was not defined
    }
 
    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 (getDolGlobalString('MAIN_USE_FPDF')) {
      $outputlangs->charset_output = 'ISO-8859-1';
    }
 
    // Load translation files required by the page
    $outputlangs->loadLangs(array("main", "dict", "companies", "bills", "products"));
 
    $nblines = count($object->lines);
 
    if ($conf->fournisseur->facture->dir_output) {
      $deja_regle = $object->getSommePaiement((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? 1 : 0);
      $amount_credit_notes_included = $object->getSumCreditNotesUsed((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? 1 : 0);
      $amount_deposits_included = $object->getSumDepositsUsed((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? 1 : 0);
 
      // Definition of $dir and $file
      if ($object->specimen) {
        $dir = $conf->fournisseur->facture->dir_output;
        $file = $dir."/SPECIMEN.pdf";
      } else {
        $objectref = dol_sanitizeFileName($object->ref);
        $objectrefsupplier = dol_sanitizeFileName($object->ref_supplier);
        $dir = $conf->fournisseur->facture->dir_output.'/'.get_exdir($object->id, 2, 0, 0, $object, 'invoice_supplier').$objectref;
        $file = $dir."/".$objectref.".pdf";
        if (getDolGlobalString('SUPPLIER_REF_IN_NAME')) {
          $file = $dir."/".$objectref.($objectrefsupplier ? "_".$objectrefsupplier : "").".pdf";
        }
      }
 
      if (!file_exists($dir)) {
        if (dol_mkdir($dir) < 0) {
          $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
          return 0;
        }
      }
 
      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
 
        // Set nblines with the new facture lines content after hook
        $nblines = count($object->lines);
        $nbpayments = count($object->getListOfPayments());
 
        // Create pdf instance
        $pdf = pdf_getInstance($this->format);
        $default_font_size = pdf_getPDFFontSize($outputlangs); // Must be after pdf_getInstance
        $pdf->setAutoPageBreak(true, 0);
 
        $heightforinfotot = 50 + (4 * $nbpayments); // Height reserved to output the info and total part and payment part
        if ($heightforinfotot > 220) {
          $heightforinfotot = 220;
        }
        $heightforfreetext = getDolGlobalInt('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 (getDolGlobalString('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 (getDolGlobalString('MAIN_ADD_PDF_BACKGROUND')) {
          $logodir = $conf->mycompany->dir_output;
          if (!empty($conf->mycompany->multidir_output[$object->entity ?? $conf->entity])) {
            $logodir = $conf->mycompany->multidir_output[$object->entity ?? $conf->entity];
          }
          $pagecount = $pdf->setSourceFile($logodir .'/' . getDolGlobalString('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("PdfInvoiceTitle"));
        $pdf->SetCreator("Dolibarr ".DOL_VERSION);
        $pdf->SetAuthor($outputlangs->convToOutputCharset($user->getAnonymisableFullName($outputlangs)));
        $pdf->SetKeyWords($outputlangs->convToOutputCharset($object->ref)." ".$outputlangs->transnoentities("PdfInvoiceTitle")." ".$outputlangs->convToOutputCharset($object->thirdparty->name));
        if (getDolGlobalString('MAIN_DISABLE_PDF_COMPRESSION')) {
          $pdf->SetCompression(false);
        }
 
        // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
        $pdf->SetMargins($this->marge_gauche, $this->marge_haute, $this->marge_droite); // Left, Top, Right
 
        // Set $this->atleastonediscount if you have at least one discount
        for ($i = 0; $i < $nblines; $i++) {
          if ($object->lines[$i]->remise_percent) {
            $this->atleastonediscount++;
          }
        }
        if (empty($this->atleastonediscount)) {
          $delta = ($this->postotalht - $this->posxdiscount);
          $this->posxpicture += $delta;
          $this->posxtva += $delta;
          $this->posxup += $delta;
          $this->posxqty += $delta;
          $this->posxunit += $delta;
          $this->posxdiscount += $delta;
          // post of fields after are not modified, stay at same position
        }
 
        // 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 = 90 + $top_shift;
        $tab_top_newpage = (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD') ? 42 + $top_shift : 10);
 
        // Incoterm
        if (isModEnabled('incoterm')) {
          $desc_incoterms = $object->getIncotermsForPDF();
          if ($desc_incoterms) {
            $tab_top -= 2;
 
            $pdf->SetFont('', '', $default_font_size - 1);
            $pdf->writeHTMLCell(190, 3, $this->posxdesc - 1, $tab_top - 1, dol_htmlentitiesbr($desc_incoterms), 0, 1);
            $nexY = $pdf->GetY();
            $height_incoterms = $nexY - $tab_top;
 
            // Rect takes a length in 3rd parameter
            $pdf->SetDrawColor(192, 192, 192);
            $pdf->RoundedRect($this->marge_gauche, $tab_top - 1, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $height_incoterms + 3, $this->corner_radius, '1234', 'D');
 
            $tab_top = $nexY + 6;
          }
        }
 
        // Displays notes
        $notetoshow = empty($object->note_public) ? '' : $object->note_public;
 
        // Extrafields in note
        if (getDolGlobalString('INVOICE_ADD_EXTRAFIELD_IN_NOTE')) {
          $extranote = $this->getExtrafieldsInHtml($object, $outputlangs);
          if (!empty($extranote)) {
            $notetoshow = dol_concatdesc($notetoshow, $extranote);
          }
        }
 
        if ($notetoshow) {
          $tab_top -= 2;
 
          $substitutionarray = pdf_getSubstitutionArray($outputlangs, null, $object);
          complete_substitutions_array($substitutionarray, $outputlangs, $object);
          $notetoshow = make_substitutions($notetoshow, $substitutionarray, $outputlangs);
          $notetoshow = convertBackOfficeMediasLinksToPublicLinks($notetoshow);
 
          $pdf->SetFont('', '', $default_font_size - 1);
          $pdf->writeHTMLCell(190, 3, $this->posxdesc - 1, $tab_top - 1, 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->RoundedRect($this->marge_gauche, $tab_top - 1, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $height_note + 2, $this->corner_radius, '1234', 'D');
 
          $tab_top = $nexY + 6;
        }
 
        $iniY = $tab_top + 7;
        $curY = $tab_top + 7;
        $nexY = $tab_top + 7;
        $pdf_sub_options = [
          'titleshowuponpdf' => 1,
          'titleshowtotalexludingvatonpdf' => 1,
        ];
 
        // Loop on each lines
        for ($i = 0; $i < $nblines; $i++) {
          $sub_options = $object->lines[$i]->extraparams["subtotal"] ?? array();
 
          if ($object->lines[$i]->special_code == SUBTOTALS_SPECIAL_CODE) {
            $level = $object->lines[$i]->qty;
            if ($sub_options) {
              if (isset($sub_options['titleshowuponpdf'])) {
                $pdf_sub_options['titleshowuponpdf'] = isset($pdf_sub_options['titleshowuponpdf']) && $pdf_sub_options['titleshowuponpdf'] < $level ? $pdf_sub_options['titleshowuponpdf'] : $level;
              } elseif (isset($pdf_sub_options['titleshowuponpdf']) && abs($level) <= $pdf_sub_options['titleshowuponpdf']) {
                unset($pdf_sub_options['titleshowuponpdf']);
              }
              if (isset($sub_options['titleshowtotalexludingvatonpdf'])) {
                $pdf_sub_options['titleshowtotalexludingvatonpdf'] = isset($pdf_sub_options['titleshowtotalexludingvatonpdf']) && $pdf_sub_options['titleshowtotalexludingvatonpdf'] < $level ? $pdf_sub_options['titleshowtotalexludingvatonpdf'] : $level;
              } elseif (isset($pdf_sub_options['titleshowtotalexludingvatonpdf']) && abs($level) <= $pdf_sub_options['titleshowtotalexludingvatonpdf']) {
                unset($pdf_sub_options['titleshowtotalexludingvatonpdf']);
              }
            } else {
              if (isset($pdf_sub_options['titleshowuponpdf']) && abs($level) <= $pdf_sub_options['titleshowuponpdf']) {
                unset($pdf_sub_options['titleshowuponpdf']);
              }
              if (isset($pdf_sub_options['titleshowtotalexludingvatonpdf']) && abs($level) <= $pdf_sub_options['titleshowtotalexludingvatonpdf']) {
                unset($pdf_sub_options['titleshowtotalexludingvatonpdf']);
              }
            }
          }
          $curY = $nexY;
          $pdf->SetFont('', '', $default_font_size - 1); // Into loop to work with multipage
          $pdf->SetTextColor(0, 0, 0);
 
          // Define size of image if we need it
          //$imglinesize = array();
          //if (!empty($realpatharray[$i])) {
          //  $imglinesize = pdf_getSizeForImage($realpatharray[$i]);
          //}
 
          $pdf->setTopMargin($tab_top_newpage);
          $pdf->setPageOrientation('', true, $heightforfooter + $heightforfreetext + $heightforinfotot); // The only function to edit the bottom margin of current page to set it.
          $pageposbefore = $pdf->getPage();
 
          $showpricebeforepagebreak = 1;
          $posYAfterImage = 0;
 
          // Description of product line
          $curX = $this->posxdesc - 1;
 
          $pdf->startTransaction();
          pdf_writelinedesc($pdf, $object, $i, $outputlangs, $this->posxtva - $curX, 3, $curX, $curY, $hideref, $hidedesc, 1);
          $pageposafter = $pdf->getPage();
          if ($pageposafter > $pageposbefore) { // There is a pagebreak
            $pdf->rollbackTransaction(true);
            $pageposafter = $pageposbefore;
            //print $pageposafter.'-'.$pageposbefore;exit;
            $pdf->setPageOrientation('', true, $heightforfooter); // The only function to edit the bottom margin of current page to set it.
            pdf_writelinedesc($pdf, $object, $i, $outputlangs, $this->posxtva - $curX, 4, $curX, $curY, $hideref, $hidedesc, 1);
            $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 (getDolGlobalString('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('', true, 0); // The only function to edit the bottom margin of current page to set it.
 
          // We suppose that a too long description or photo were moved completely on next page
          if ($pageposafter > $pageposbefore && empty($showpricebeforepagebreak)) {
            $pdf->setPage($pageposafter);
            $curY = $tab_top_newpage;
          }
 
          $pdf->SetFont('', '', $default_font_size - 1); // We reposition the default font
 
          // VAT Rate
          if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT')) {
            $vat_rate = pdf_getlinevatrate($object, $i, $outputlangs, $hidedetails);
            $pdf->SetXY($this->posxtva, $curY);
            $pdf->MultiCell($this->posxup - $this->posxtva - 1, 3, $vat_rate, 0, 'R');
          }
 
          // Unit price before discount
          $up_excl_tax = pdf_getlineupexcltax($object, $i, $outputlangs, $hidedetails);
          $pdf->SetXY($this->posxup, $curY);
          $pdf->MultiCell($this->posxqty - $this->posxup - 0.8, 3, $up_excl_tax, 0, 'R', false);
 
          // Quantity
          $qty = pdf_getlineqty($object, $i, $outputlangs, $hidedetails);
          $pdf->SetXY($this->posxqty, $curY);
          $pdf->MultiCell($this->posxunit - $this->posxqty - 0.8, 4, $qty, 0, 'R'); // Enough for 6 chars
 
          // Unit
          if (getDolGlobalInt('PRODUCT_USE_UNITS')) {
            $unit = pdf_getlineunit($object, $i, $outputlangs, $hidedetails);
            $pdf->SetXY($this->posxunit, $curY);
            $pdf->MultiCell($this->posxdiscount - $this->posxunit - 0.8, 4, $unit, 0, 'L');
          }
 
          // Discount on line
          if ($object->lines[$i]->remise_percent) {
            $pdf->SetXY($this->posxdiscount - 2, $curY);
            $remise_percent = pdf_getlineremisepercent($object, $i, $outputlangs, $hidedetails);
            $pdf->MultiCell($this->postotalht - $this->posxdiscount - 1, 3, $remise_percent, 0, 'R');
          }
 
          // Total HT line
          $total_excl_tax = pdf_getlinetotalexcltax($object, $i, $outputlangs, $hidedetails);
          $pdf->SetXY($this->postotalht, $curY);
          $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 3, $total_excl_tax, 0, 'R', false);
 
          // Collection of totals by VAT value in $this->tva["taux"]=total_tva
          if (isModEnabled("multicurrency") && $object->multicurrency_tx != 1) {
            $tvaligne = $object->lines[$i]->multicurrency_total_tva;
          } else {
            $tvaligne = $object->lines[$i]->total_tva;
          }
 
          $localtax1ligne = $object->lines[$i]->total_localtax1;
          $localtax2ligne = $object->lines[$i]->total_localtax2;
 
          // TODO remise_percent is an obsolete field for object parent
          /*if (!empty($object->remise_percent)) {
            $tvaligne -= ($tvaligne * $object->remise_percent) / 100;
          }*/
 
          $vatrate = (string) $object->lines[$i]->tva_tx;
          $localtax1rate = (string) $object->lines[$i]->localtax1_tx;
          $localtax2rate = (string) $object->lines[$i]->localtax2_tx;
 
          if (($object->lines[$i]->info_bits & 0x01) == 0x01) {
            $vatrate .= '*';
          }
          if (empty($this->tva[$vatrate])) {
            $this->tva[$vatrate] = 0;
          }
          if (empty($this->localtax1[$localtax1rate])) {
            $this->localtax1[$localtax1rate] = 0;
          }
          if (empty($this->localtax2[$localtax2rate])) {
            $this->localtax2[$localtax2rate] = 0;
          }
          $this->tva[$vatrate] += $tvaligne;
          $this->localtax1[$localtax1rate] += $localtax1ligne;
          $this->localtax2[$localtax2rate] += $localtax2ligne;
 
          if ($posYAfterImage > $posYAfterDescription) {
            $nexY = $posYAfterImage;
          }
 
          // Add line
          if (getDolGlobalString('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('', true, 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 (isset($object->lines[$i + 1]->pagebreak) && $object->lines[$i + 1]->pagebreak) {  // @phan-suppress-current-line PhanUndeclaredProperty  // @phan-suppress-current-line PhanUndeclaredProperty
            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);
            }
          }
        }
 
        // 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;
        }
 
        // Display total area
        $posy = $this->_tableau_tot($pdf, $object, $deja_regle, $bottomlasttab, $outputlangs);
 
        $amount_credit_notes_included = 0;
        $amount_deposits_included = 0;
 
        // Display Payments area
        if (($deja_regle || $amount_credit_notes_included || $amount_deposits_included) && !getDolGlobalString('SUPPLIER_INVOICE_NO_PAYMENT_DETAILS')) {
          $posy = $this->_tableau_versements($pdf, $object, $posy, $outputlangs, $heightforfooter);
        }
 
        // Pagefoot
        $this->_pagefoot($pdf, $object, $outputlangs);
        if (method_exists($pdf, 'AliasNbPages')) {
          $pdf->AliasNbPages();  // @phan-suppress-current-line PhanUndeclaredMethod
        }
 
        $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
        $this->warnings = $hookmanager->warnings;
        if ($reshook < 0) {
          $this->error = $hookmanager->error;
          $this->errors = $hookmanager->errors;
          dolChmod($file);
          return -1;
        }
 
        dolChmod($file);
 
        $this->result = array('fullpath' => $file);
 
        return 1; // No error
      } else {
        $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
        return 0;
      }
    } else {
      $this->error = $langs->transnoentities("ErrorConstantNotDefined", "SUPPLIER_OUTPUTDIR");
      return 0;
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  protected function _tableau_tot(&$pdf, $object, $deja_regle, $posy, $outputlangs)
  {
    // phpcs:enable
    global $conf, $mysoc, $hookmanager;
 
    $sign = 1;
    if ($object->type == 2 && getDolGlobalString('INVOICE_POSITIVE_CREDIT_NOTE')) {
      $sign = -1;
    }
 
    $default_font_size = pdf_getPDFFontSize($outputlangs);
 
    $tab2_top = $posy;
    $tab2_hl = 4;
    $pdf->SetFont('', '', $default_font_size - 1);
 
    // Total table
    $col1x = 120;
    $col2x = 170;
    if ($this->page_largeur < 210) { // To work with US executive format
      $col2x -= 20;
    }
    $largcol2 = ($this->page_largeur - $this->marge_droite - $col2x);
 
    $useborder = 0;
    $index = 0;
 
    // Total HT
    $pdf->SetFillColor(255, 255, 255);
    $pdf->SetXY($col1x, $tab2_top);
    $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transnoentities("TotalHT"), 0, 'L', true);
 
    $total_ht = ((isModEnabled("multicurrency") && isset($object->multicurrency_tx) && $object->multicurrency_tx != 1) ? $object->multicurrency_total_ht : $object->total_ht);
    $pdf->SetXY($col2x, $tab2_top);
    $pdf->MultiCell($largcol2, $tab2_hl, price($sign * ($total_ht + (!empty($object->remise) ? $object->remise : 0)), 0, $outputlangs), 0, 'R', true);
 
    // Show VAT by rates and total
    $pdf->SetFillColor(248, 248, 248);
 
    $total_ttc = (isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? $object->multicurrency_total_ttc : $object->total_ttc;
 
    $this->atleastoneratenotnull = 0;
    foreach ($this->tva as $tvakey => $tvaval) {
      if ($tvakey > 0) {    // We do not display rate 0
        $this->atleastoneratenotnull++;
 
        $index++;
        $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
 
        $tvacompl = '';
 
        if (preg_match('/\*/', $tvakey)) {
          $tvakey = str_replace('*', '', $tvakey);
          $tvacompl = " (".$outputlangs->transnoentities("NonPercuRecuperable").")";
        }
 
        $totalvat = $outputlangs->transcountrynoentities("TotalVAT", $mysoc->country_code).' ';
        $totalvat .= vatrate($tvakey, true).$tvacompl;
        $pdf->MultiCell($col2x - $col1x, $tab2_hl, $totalvat, 0, 'L', true);
 
        $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($largcol2, $tab2_hl, price($tvaval, 0, $outputlangs), 0, 'R', true);
      }
    }
    if (!$this->atleastoneratenotnull) { // If no vat at all
      $index++;
      $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transcountrynoentities("TotalVAT", $mysoc->country_code), 0, 'L', true);
      $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($largcol2, $tab2_hl, price($object->total_tva, 0, $outputlangs), 0, 'R', true);
 
      // Total LocalTax1
      if (getDolGlobalString('FACTURE_LOCAL_TAX1_OPTION') == 'localtax1on' && $object->total_localtax1 > 0) {
        $index++;
        $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transcountrynoentities("TotalLT1", $mysoc->country_code), 0, 'L', true);
        $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($largcol2, $tab2_hl, price($object->total_localtax1, 0, $outputlangs), 0, 'R', true);
      }
 
      // Total LocalTax2
      if (getDolGlobalString('FACTURE_LOCAL_TAX2_OPTION') == 'localtax2on' && $object->total_localtax2 > 0) {
        $index++;
        $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transcountrynoentities("TotalLT2", $mysoc->country_code), 0, 'L', true);
        $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($largcol2, $tab2_hl, price($object->total_localtax2, 0, $outputlangs), 0, 'R', true);
      }
    } else {
      //if (getDolGlobalString('FACTURE_LOCAL_TAX1_OPTION') && getDolGlobalString('FACTURE_LOCAL_TAX1_OPTION') == 'localtax1on')
      //{
      //Local tax 1
      foreach ($this->localtax1 as $tvakey => $tvaval) {
        if ($tvakey != 0) {    // On affiche pas taux 0
          //$this->atleastoneratenotnull++;
 
          $index++;
          $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
 
          $tvacompl = '';
          if (preg_match('/\*/', (string) $tvakey)) {
            $tvakey = str_replace('*', '', (string) $tvakey);
            $tvacompl = " (".$outputlangs->transnoentities("NonPercuRecuperable").")";
          }
          $totalvat = $outputlangs->transcountrynoentities("TotalLT1", $mysoc->country_code).' ';
          $totalvat .= vatrate((string) abs((float) $tvakey), true).$tvacompl;
          $pdf->MultiCell($col2x - $col1x, $tab2_hl, $totalvat, 0, 'L', true);
 
          $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
          $pdf->MultiCell($largcol2, $tab2_hl, price((string) $tvaval, 0, $outputlangs), 0, 'R', true);
        }
      }
      //}
 
      //if (getDolGlobalString('FACTURE_LOCAL_TAX2_OPTION') && getDolGlobalString('FACTURE_LOCAL_TAX2_OPTION') == 'localtax2on')
      //{
      //Local tax 2
      foreach ($this->localtax2 as $tvakey => $tvaval) {
        if ($tvakey != 0) {    // On affiche pas taux 0
          //$this->atleastoneratenotnull++;
 
          $index++;
          $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
 
          $tvacompl = '';
          if (preg_match('/\*/', (string) $tvakey)) {
            $tvakey = str_replace('*', '', (string) $tvakey);
            $tvacompl = " (".$outputlangs->transnoentities("NonPercuRecuperable").")";
          }
          $totalvat = $outputlangs->transcountrynoentities("TotalLT2", $mysoc->country_code).' ';
          $totalvat .= vatrate((string) abs((float) $tvakey), true).$tvacompl;
          $pdf->MultiCell($col2x - $col1x, $tab2_hl, $totalvat, 0, 'L', true);
 
          $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
          $pdf->MultiCell($largcol2, $tab2_hl, price((string) $tvaval, 0, $outputlangs), 0, 'R', true);
        }
      }
      //}
    }
 
    // Total TTC
    $index++;
    $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
    $pdf->SetTextColor(0, 0, 60);
    $pdf->SetFillColor(224, 224, 224);
    $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transnoentities("TotalTTC"), $useborder, 'L', true);
 
    $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
    $pdf->MultiCell($largcol2, $tab2_hl, price($sign * $total_ttc, 0, $outputlangs), $useborder, 'R', true);
 
    $pdf->SetTextColor(0, 0, 0);
    $creditnoteamount = $object->getSumCreditNotesUsed((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? 1 : 0); // Warning, this also include excess received
    $depositsamount = $object->getSumDepositsUsed((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? 1 : 0);
    //print "x".$creditnoteamount."-".$depositsamount;exit;
    $resteapayer = price2num($total_ttc - $deja_regle - $creditnoteamount - $depositsamount, 'MT');
    if (!empty($object->paid)) {
      $resteapayer = 0;
    }
 
    if (($deja_regle > 0 || $creditnoteamount > 0 || $depositsamount > 0) && !getDolGlobalString('INVOICE_NO_PAYMENT_DETAILS')) {
      // Already paid + Deposits
      $index++;
      $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transnoentities("Paid"), 0, 'L', false);
      $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($largcol2, $tab2_hl, price($deja_regle + $depositsamount, 0, $outputlangs), 0, 'R', false);
 
      // Credit note
      if ($creditnoteamount) {
        $labeltouse = ($outputlangs->transnoentities("CreditNotesOrExcessReceived") != "CreditNotesOrExcessReceived") ? $outputlangs->transnoentities("CreditNotesOrExcessReceived") : $outputlangs->transnoentities("CreditNotes");
        $index++;
        $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($col2x - $col1x, $tab2_hl, $labeltouse, 0, 'L', false);
        $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($largcol2, $tab2_hl, price($creditnoteamount, 0, $outputlangs), 0, 'R', false);
      }
 
      // Escompte
      if ($object->close_code == FactureFournisseur::CLOSECODE_DISCOUNTVAT) {
        $index++;
        $pdf->SetFillColor(255, 255, 255);
 
        $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transnoentities("EscompteOfferedShort"), $useborder, 'L', true);
        $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
        $pdf->MultiCell($largcol2, $tab2_hl, price($total_ttc - $deja_regle - $creditnoteamount - $depositsamount, 0, $outputlangs), $useborder, 'R', true);
 
        $resteapayer = 0;
      }
 
      $index++;
      $pdf->SetTextColor(0, 0, 60);
      $pdf->SetFillColor(224, 224, 224);
      $pdf->SetXY($col1x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($col2x - $col1x, $tab2_hl, $outputlangs->transnoentities("RemainderToPay"), $useborder, 'L', true);
 
      $pdf->SetXY($col2x, $tab2_top + $tab2_hl * $index);
      $pdf->MultiCell($largcol2, $tab2_hl, price($resteapayer, 0, $outputlangs), $useborder, 'R', true);
      $pdf->SetFont('', '', $default_font_size - 1);
      $pdf->SetTextColor(0, 0, 0);
    }
 
    $parameters = array('pdf' => &$pdf, 'object' => &$object, 'outputlangs' => $outputlangs, 'index' => &$index, 'posy' => $posy);
 
    $reshook = $hookmanager->executeHooks('afterPDFTotalTable', $parameters, $this); // Note that $action and $object may have been modified by some hooks
    if ($reshook < 0) {
      $this->error = $hookmanager->error;
      $this->errors = $hookmanager->errors;
    }
 
    $index++;
    return ($tab2_top + ($tab2_hl * $index));
  }
 
  // 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 (getDolGlobalString('MAIN_PDF_TITLE_BACKGROUND_COLOR')) {
        $pdf->RoundedRect($this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_droite - $this->marge_gauche, 5, $this->corner_radius, '1001', 'F', array(), explode(',', getDolGlobalString('MAIN_PDF_TITLE_BACKGROUND_COLOR')));
      }
    }
 
    $pdf->SetDrawColor(128, 128, 128);
    $pdf->SetFont('', '', $default_font_size - 1);
 
    // Output Rect
    $this->printRoundedRect($pdf, $this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height, $this->corner_radius, $hidetop, $hidebottom, 'D'); // Rect takes a length in 3rd parameter and 4th parameter
 
    if (empty($hidetop)) {
      $pdf->line($this->marge_gauche, $tab_top + 5, $this->page_largeur - $this->marge_droite, $tab_top + 5); // line takes a position y in 2nd parameter and 4th parameter
 
      $pdf->SetXY($this->posxdesc - 1, $tab_top + 1);
      $pdf->MultiCell(108, 2, $outputlangs->transnoentities("Designation"), '', 'L');
    }
 
    if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT') && !getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT_COLUMN')) {
      $pdf->line($this->posxtva - 1, $tab_top, $this->posxtva - 1, $tab_top + $tab_height);
      if (empty($hidetop)) {
        $pdf->SetXY($this->posxtva - 3, $tab_top + 1);
        $pdf->MultiCell($this->posxup - $this->posxtva + 3, 2, $outputlangs->transnoentities("VAT"), '', '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->posxqty - $this->posxup - 1, 2, $outputlangs->transnoentities("PriceUHT"), '', '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->posxunit - $this->posxqty - 1, 2, $outputlangs->transnoentities("Qty"), '', 'C');
    }
 
    if (getDolGlobalInt('PRODUCT_USE_UNITS')) {
      $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("Unit"),
          '',
          'C'
        );
      }
    }
 
    if ($this->atleastonediscount) {
      $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("ReductionShort"), '', '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(30, 2, $outputlangs->transnoentities("TotalHTShort"), '', 'C');
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  protected function _tableau_versements(&$pdf, $object, $posy, $outputlangs, $heightforfooter = 0)
  {
    // phpcs:enable
    global $conf;
 
    $sign = 1;
    if ($object->type == 2 && getDolGlobalString('INVOICE_POSITIVE_CREDIT_NOTE')) {
      $sign = -1;
    }
 
    $tab3_posx = 120;
    $tab3_top = $posy + 8;
    $tab3_width = 80;
    $tab3_height = 4;
    if ($this->page_largeur < 210) { // To work with US executive format
      $tab3_posx -= 20;
    }
 
    $default_font_size = pdf_getPDFFontSize($outputlangs);
 
    $pdf->SetFont('', '', $default_font_size - 3);
    $pdf->SetXY($tab3_posx, $tab3_top - 4);
    $pdf->MultiCell(60, 3, $outputlangs->transnoentities("PaymentsAlreadyDone"), 0, 'L', false);
 
    $pdf->line($tab3_posx, $tab3_top, $tab3_posx + $tab3_width, $tab3_top);
 
    $pdf->SetFont('', '', $default_font_size - 4);
    $pdf->SetXY($tab3_posx, $tab3_top);
    $pdf->MultiCell(20, 3, $outputlangs->transnoentities("Payment"), 0, 'L', false);
    $pdf->SetXY($tab3_posx + 21, $tab3_top);
    $pdf->MultiCell(20, 3, $outputlangs->transnoentities("Amount"), 0, 'L', false);
    $pdf->SetXY($tab3_posx + 40, $tab3_top);
    $pdf->MultiCell(20, 3, $outputlangs->transnoentities("Type"), 0, 'L', false);
    $pdf->SetXY($tab3_posx + 58, $tab3_top);
    $pdf->MultiCell(20, 3, $outputlangs->transnoentities("Num"), 0, 'L', false);
 
    $pdf->line($tab3_posx, $tab3_top - 1 + $tab3_height, $tab3_posx + $tab3_width, $tab3_top - 1 + $tab3_height);
 
    $y = 0;
 
    $pdf->SetFont('', '', $default_font_size - 4);
 
    // Loop on each deposits and credit notes included
    //
 
    // Loop on each payment
    $sql = "SELECT p.datep as date, p.fk_paiement as type, p.num_paiement as num_payment, pf.amount as amount, pf.multicurrency_amount,";
    $sql .= " cp.code";
    $sql .= " FROM ".MAIN_DB_PREFIX."paiementfourn_facturefourn as pf, ".MAIN_DB_PREFIX."paiementfourn as p";
    $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as cp ON p.fk_paiement = cp.id";
    $sql .= " WHERE pf.fk_paiementfourn = p.rowid and pf.fk_facturefourn = ".((int) $object->id);
    $sql .= " ORDER BY p.datep";
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      $i = 0;
      while ($i < $num) {
        $y += 3;
        $row = $this->db->fetch_object($resql);
 
        $pdf->SetXY($tab3_posx, $tab3_top + $y);
        $pdf->MultiCell(20, 3, dol_print_date($this->db->jdate($row->date), 'day', false, $outputlangs, true), 0, 'L', false);
        $pdf->SetXY($tab3_posx + 21, $tab3_top + $y);
        $pdf->MultiCell(20, 3, price($sign * ((isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? $row->multicurrency_amount : $row->amount)), 0, 'L', false);
        $pdf->SetXY($tab3_posx + 40, $tab3_top + $y);
        $oper = $outputlangs->transnoentitiesnoconv("PaymentTypeShort".$row->code);
 
        $pdf->MultiCell(20, 3, $oper, 0, 'L', false);
        $pdf->SetXY($tab3_posx + 58, $tab3_top + $y);
        $pdf->MultiCell(30, 3, $row->num_payment, 0, 'L', false);
 
        $pdf->line($tab3_posx, $tab3_top + $y + 3, $tab3_posx + $tab3_width, $tab3_top + $y + 3);
 
        $i++;
      }
    } else {
      $this->error = $this->db->lasterror();
      return -1;
    }
    return -1;
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
  protected function _pagehead(&$pdf, $object, $showaddress, $outputlangs)
  {
    global $langs, $conf, $mysoc;
 
    // Load translation files required by the page
    $outputlangs->loadLangs(array("main", "orders", "companies", "bills"));
 
    $default_font_size = pdf_getPDFFontSize($outputlangs);
 
    // Do not add the BACKGROUND as this is for suppliers
    //pdf_pagehead($pdf,$outputlangs,$this->page_hauteur);
 
    $pdf->SetTextColor(0, 0, 60);
    $pdf->SetFont('', 'B', $default_font_size + 3);
 
    $w = 100;
 
    $posy = $this->marge_haute;
    $posx = $this->page_largeur - $this->marge_droite - 100;
 
    $pdf->SetXY($this->marge_gauche, $posy);
 
    // Logo
    /*
    $logo=$conf->mycompany->dir_output.'/logos/'.$mysoc->logo;
    if ($mysoc->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("ErrorGoToModuleSetup"), 0, 'L');
      }
    }
    else
    {*/
    $text = $this->emetteur->name;
    $pdf->MultiCell(100, 4, $outputlangs->convToOutputCharset($text), 0, 'L');
    //}
 
    $pdf->SetFont('', 'B', $default_font_size + 3);
    $pdf->SetXY($posx, $posy);
    $pdf->SetTextColor(0, 0, 60);
    $title = $outputlangs->transnoentities("PdfInvoiceTitle");
    if ($object->type == 1) {
      $title = $outputlangs->transnoentities("InvoiceReplacement");
    }
    if ($object->type == 2) {
      $title = $outputlangs->transnoentities("InvoiceAvoir");
    }
    if ($object->type == 3) {
      $title = $outputlangs->transnoentities("InvoiceDeposit");
    }
    $pdf->MultiCell($w, 3, $title." ".$outputlangs->convToOutputCharset($object->ref), '', 'R');
    $posy += 1;
 
    if ($object->ref_supplier) {
      $posy += 4;
      $pdf->SetFont('', 'B', $default_font_size);
      $pdf->SetXY($posx, $posy);
      $pdf->SetTextColor(0, 0, 60);
      $pdf->MultiCell($w, 4, $outputlangs->transnoentities("RefSupplier")." : ".$object->ref_supplier, '', 'R');
      $posy += 1;
    }
 
    $pdf->SetFont('', '', $default_font_size - 1);
 
    if (getDolGlobalString('PDF_SHOW_PROJECT_TITLE')) {
      $object->fetchProject();
      if (!empty($object->project->ref)) {
        $posy += 3;
        $pdf->SetXY($posx, $posy);
        $pdf->SetTextColor(0, 0, 60);
        $pdf->MultiCell($w, 3, $outputlangs->transnoentities("Project")." : ".(empty($object->project->title) ? '' : $object->project->title), '', 'R');
      }
    }
 
    if (getDolGlobalString('PDF_SHOW_PROJECT')) {
      $object->fetchProject();
      if (!empty($object->project->ref)) {
        $outputlangs->load("projects");
        $posy += 4;
        $pdf->SetXY($posx, $posy);
        $langs->load("projects");
        $pdf->SetTextColor(0, 0, 60);
        $pdf->MultiCell($w, 3, $outputlangs->transnoentities("Project")." : ".(empty($object->project->ref) ? '' : $object->project->ref), '', 'R');
      }
    }
 
    if ($object->date) {
      $posy += 4;
      $pdf->SetXY($posx, $posy);
      $pdf->SetTextColor(0, 0, 60);
      $pdf->MultiCell($w, 4, $outputlangs->transnoentities("Date")." : ".dol_print_date($object->date, "day", false, $outputlangs, true), '', 'R');
    } else {
      $posy += 4;
      $pdf->SetXY($posx, $posy);
      $pdf->SetTextColor(255, 0, 0);
      $pdf->MultiCell($w, 4, strtolower($outputlangs->transnoentities("OrderToProcess")), '', 'R');
    }
 
    if ($object->thirdparty->code_fournisseur) {
      $posy += 4;
      $pdf->SetXY($posx, $posy);
      $pdf->SetTextColor(0, 0, 60);
      $pdf->MultiCell($w, 3, $outputlangs->transnoentities("SupplierCode")." : ".$outputlangs->transnoentities((string) $object->thirdparty->code_fournisseur), '', 'R');
    }
 
    $posy += 1;
    $pdf->SetTextColor(0, 0, 60);
 
    $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;
    }
 
    if ($showaddress) {
      // Sender properties
      $carac_emetteur = '';
      // Add internal contact of object if defined
      $arrayidcontact = $object->getIdContact('internal', 'SALESREPFOLL');
      if (count($arrayidcontact) > 0) {
        $object->fetch_user($arrayidcontact[0]);
        $labelbeforecontactname = ($outputlangs->transnoentities("FromContactName") != 'FromContactName' ? $outputlangs->transnoentities("FromContactName") : $outputlangs->transnoentities("Name"));
        $carac_emetteur .= ($carac_emetteur ? "\n" : '').$labelbeforecontactname.": ".$outputlangs->convToOutputCharset($object->user->getFullName($outputlangs));
        $carac_emetteur .= (getDolGlobalInt('PDF_SHOW_PHONE_AFTER_USER_CONTACT') || getDolGlobalInt('PDF_SHOW_EMAIL_AFTER_USER_CONTACT')) ? ' (' : '';
        $carac_emetteur .= (getDolGlobalInt('PDF_SHOW_PHONE_AFTER_USER_CONTACT') && !empty($object->user->office_phone)) ? $object->user->office_phone : '';
        $carac_emetteur .= (getDolGlobalInt('PDF_SHOW_PHONE_AFTER_USER_CONTACT') && getDolGlobalInt('PDF_SHOW_EMAIL_AFTER_USER_CONTACT')) ? ', ' : '';
        $carac_emetteur .= (getDolGlobalInt('PDF_SHOW_EMAIL_AFTER_USER_CONTACT') && !empty($object->user->email)) ? $object->user->email : '';
        $carac_emetteur .= (getDolGlobalInt('PDF_SHOW_PHONE_AFTER_USER_CONTACT') || getDolGlobalInt('PDF_SHOW_EMAIL_AFTER_USER_CONTACT')) ? ')' : '';
        $carac_emetteur .= "\n";
      }
 
      $carac_emetteur .= pdf_build_address($outputlangs, $this->emetteur, $object->thirdparty, '', 0, 'source', $object);
 
      // Show sender
      $posy = 42 + $top_shift;
      $posx = $this->marge_gauche;
      if (getDolGlobalString('MAIN_INVERT_SENDER_RECIPIENT')) {
        $posx = $this->page_largeur - $this->marge_droite - 80;
      }
      $hautcadre = 40;
 
      // Show sender frame
      $pdf->SetTextColor(0, 0, 0);
      $pdf->SetFont('', '', $default_font_size - 2);
      $pdf->SetXY($posx, $posy - 5);
      $pdf->MultiCell(80, 5, $outputlangs->transnoentities("BillFrom"), 0, 'L');
      $pdf->SetXY($posx, $posy);
      $pdf->SetFillColor(230, 230, 230);
      $pdf->RoundedRect($posx, $posy, 82, $hautcadre, $this->corner_radius, '1234', 'F');
      $pdf->SetTextColor(0, 0, 60);
 
      // Show sender name
      $pdf->SetXY($posx + 2, $posy + 3);
      $pdf->SetFont('', 'B', $default_font_size);
      $pdf->MultiCell(80, 4, $outputlangs->convToOutputCharset($this->emetteur->name), 0, 'L');
      $posy = $pdf->getY();
 
      // Show sender information
      $pdf->SetXY($posx + 2, $posy);
      $pdf->SetFont('', '', $default_font_size - 1);
      $pdf->MultiCell(80, 4, $carac_emetteur, 0, 'L');
 
 
 
      // If BILLING contact defined on invoice, we use it
      $usecontact = false;
      $arrayidcontact = $object->getIdContact('internal', 'BILLING');
      if (count($arrayidcontact) > 0) {
        $usecontact = true;
        $result = $object->fetch_contact($arrayidcontact[0]);
      }
 
      // Recipient name
      if ($usecontact && ($object->contact->socid != $object->thirdparty->id && (!isset($conf->global->MAIN_USE_COMPANY_NAME_OF_CONTACT) || getDolGlobalString('MAIN_USE_COMPANY_NAME_OF_CONTACT')))) {
        $thirdparty = $object->contact;
      } else {
        $thirdparty = $mysoc;
      }
 
      $carac_client_name = pdfBuildThirdpartyName($thirdparty, $outputlangs);
 
      $carac_client = pdf_build_address($outputlangs, $this->emetteur, $mysoc, ((!empty($object->contact)) ? $object->contact : null), ($usecontact ? 1 : 0), 'target', $object);
 
      // Show recipient
      $widthrecbox = 100;
      if ($this->page_largeur < 210) {
        $widthrecbox = 84; // To work with US executive format
      }
      $posy = 42 + $top_shift;
      $posx = $this->page_largeur - $this->marge_droite - $widthrecbox;
      if (getDolGlobalString('MAIN_INVERT_SENDER_RECIPIENT')) {
        $posx = $this->marge_gauche;
      }
 
      // Show recipient frame
      $pdf->SetTextColor(0, 0, 0);
      $pdf->SetFont('', '', $default_font_size - 2);
      $pdf->SetXY($posx + 2, $posy - 5);
      $pdf->MultiCell($widthrecbox, 5, $outputlangs->transnoentities("BillTo"), 0, 'L');
      $pdf->RoundedRect($posx, $posy, $widthrecbox, $hautcadre, $this->corner_radius, '1234', 'D');
 
      // Show recipient name
      $pdf->SetXY($posx + 2, $posy + 3);
      $pdf->SetFont('', 'B', $default_font_size);
      $pdf->MultiCell($widthrecbox, 4, $carac_client_name, 0, 'L');
 
      $posy = $pdf->getY();
 
      // Show recipient information
      $pdf->SetFont('', '', $default_font_size - 1);
      $pdf->SetXY($posx + 2, $posy);
      $pdf->MultiCell($widthrecbox, 4, $carac_client, 0, 'L');
    }
 
    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, 'SUPPLIER_INVOICE_FREE_TEXT', $this->emetteur, $this->marge_basse, $this->marge_gauche, $this->page_hauteur, $object, $showdetails, $hidefreetext);
  }
}