<?php
/* Copyright (C) 2017 	Laurent Destailleur <eldy@stocks.sourceforge.net>
 *
 * 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/
 */

/**
 *	\file       htdocs/core/modules/stock/doc/pdf_wolcim.modules.php
 *	\ingroup    societe
 *	\brief      File of class to build PDF documents for stocks/services
 */

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 to build documents using ODF templates generator
 */
class pdf_wolcim extends ModelePDFStock
{
	/**
	 * @var DoliDb Database handler
	 */
	public $db;

	/**
	 * @var string model name
	 */
	public $name;

	/**
	 * @var string model description (short text)
	 */
	public $description;

	/**
	 * @var string document type
	 */
	public $type;

	/**
	 * @var array Minimum version of PHP required by module.
	 * e.g.: PHP ≥ 5.6 = array(5, 6)
	 */
	public $phpmin = array(5, 6);

	/**
	 * Dolibarr version of the loaded document
	 * @var string
	 */
	public $version = 'dolibarr';

	/**
	 * @var int page_largeur
	 */
	public $page_largeur;

	/**
	 * @var int page_hauteur
	 */
	public $page_hauteur;

	/**
	 * @var array format
	 */
	public $format;

	/**
	 * @var int marge_gauche
	 */
	public $marge_gauche;

	/**
	 * @var int marge_droite
	 */
	public $marge_droite;

	/**
	 * @var int marge_haute
	 */
	public $marge_haute;

	/**
	 * @var int marge_basse
	 */
	public $marge_basse;

	/**
	 * Issuer
	 * @var Societe
	 */
	public $emetteur;


	/**
	 *	Constructor
	 *
	 *  @param		DoliDB		$db      Database handler
	 */
	public function __construct($db)
	{
		global $conf, $langs, $mysoc;

		// Load traductions files required by page
		$langs->loadLangs(array("main", "companies"));

		$this->db = $db;
		$this->name = "wolcim";
		$this->description = $langs->trans("DocumentModelwolcimPDF");

		// 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 = isset($conf->global->MAIN_PDF_MARGIN_LEFT) ? $conf->global->MAIN_PDF_MARGIN_LEFT : 10;
		$this->marge_droite = isset($conf->global->MAIN_PDF_MARGIN_RIGHT) ? $conf->global->MAIN_PDF_MARGIN_RIGHT : 10;
		$this->marge_haute = isset($conf->global->MAIN_PDF_MARGIN_TOP) ? $conf->global->MAIN_PDF_MARGIN_TOP : 10;
		$this->marge_basse = isset($conf->global->MAIN_PDF_MARGIN_BOTTOM) ? $conf->global->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 = 26;
		$this->posxdesc = $this->marge_gauche + 1;
		$this->posxlabel = $this->posxdesc + $this->wref;
		$this->posxtva = 70;
		$this->posxqty = 95;
		$this->posxup = 112;
		$this->posxunit = 135;
		$this->posxdiscount = 155;
		$this->postotalht = 178;

		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->tva = array();
		$this->localtax1 = array();
		$this->localtax2 = array();
		$this->atleastoneratenotnull = 0;
		$this->atleastonediscount = 0;
	}


	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 *	Function to build a document on disk using the generic odt module.
	 *
	 *	@param		Entrepot	$object				Object source to build document
	 *	@param		Translate	$outputlangs		Lang output object
	 * 	@param		string		$srctemplatepath	Full path of source filename for generator using a template file
	 *  @param		int			$hidedetails		Do not show line details
	 *  @param		int			$hidedesc			Do not show desc
	 *  @param		int			$hideref			Do not show ref
	 *	@return		int         					1 if OK, <=0 if KO
	 */
	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"));

		$nblines = $object->lines ? count($object->lines) : 0;

		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
				$default_font_size = 9;
				$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 (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 (!empty($conf->global->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 = 60 + $top_shift;
				$tab_top_newpage = (empty($conf->global->MAIN_PDF_DONOTREPEAT_HEAD) ? 62 + $top_shift : 10);
				$tab_top_newpage = 15;
				$tab_height = 130;


				/* ************************************************************************** */
				/*                                                                            */
				/* 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;

					$this->tabTitleHeight = 0;
					$nexY = $tab_top + $this->tabTitleHeight;

					for ($i = 0; $i < $nblines; $i++) {
						$curY = $nexY;

						$objp = $this->db->fetch_object($resql);

						// Multilangs
						if (!empty($conf->global->MAIN_MULTILANGS)) { // si l'option est active
							$sql = "SELECT label";
							$sql .= " FROM ".MAIN_DB_PREFIX."product_lang";
							$sql .= " WHERE fk_product=".$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_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_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 (empty($conf->global->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;

						$pdf->SetLineStyle(array('dash'=>0, 'color'=>array(80, 80, 80)));

						$pdf->line($this->posxdesc-1, $curY, $this->posxdesc - 1, $curY+6);	// line takes a position y in 2nd parameter and 4th parameter

						// Ref.
						$pdf->line($this->posxlabel-1, $curY, $this->posxlabel-1, $curY+6);
						$pdf->SetXY($this->posxdesc, $curY+1);
						$pdf->MultiCell($this->wref, 3, $productstatic->ref, 0, 'L');

						// Label
						$pdf->line($this->posxqty+6, $curY, $this->posxqty+6, $curY+6);
						$pdf->SetXY($this->posxlabel + 0.8, $curY+1);
						$pdf->MultiCell($this->posxqty - $this->posxlabel - 0.8, 3, dol_trunc($objp->produit, 24), 0, 'L');

						// Quantity
						$valtoshow = price2num($objp->value, 'MS');
						$towrite = (empty($valtoshow) ? '0' : $valtoshow);


						$pdf->SetXY($this->posxqty, $curY+1);
						$pdf->line($this->posxup-1, $curY, $this->posxup-1, $curY+6);
						$pdf->MultiCell($this->posxup - $this->posxqty - 0.8, 3, $towrite, 0, 'R');

						// AWP
						$totalunit += $objp->value;


						$pdf->SetXY($this->posxup, $curY+1);
						$pdf->line($this->posxunit - 1, $curY, $this->posxunit - 1, $curY+6);
						$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+1);
						$pdf->line($this->posxdiscount-1, $curY, $this->posxdiscount-1, $curY+6);
						$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->line($this->postotalht, $curY, $this->postotalht, $curY+6);
							$pdf->SetXY($this->posxdiscount, $curY+1);
							$pdf->MultiCell($this->postotalht - $this->posxdiscount, 3, price(price2num($pricemin, 'MU'), 0, $outputlangs), 0, 'R', 0);

							// Total sell min
							$pdf->line($this->postotalht, $curY, $this->postotalht, $curY+6);
							$pdf->SetXY($this->postotalht, $curY+1);
							$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');
						$pdf->line($this->page_largeur - $this->marge_droite, $curY , $this->page_largeur - $this->marge_droite, $curY+6);

						// Add line
						if ($i < ($nblines-1)) {
							$pdf->setPage($pageposafter);
							$pdf->SetLineStyle(array('dash'=>'1,1', 'color'=>array(80, 80, 80)));
							$pdf->line($this->marge_gauche, $nexY+2, $this->page_largeur - $this->marge_droite, $nexY+2);
							//$pdf->SetDrawColor(190,190,200);
							$pdf->SetLineStyle(array('dash'=>0, 'color'=>array(80, 80, 80)));
						}
						if ($i == ($nblines-1)) {
							$pdf->line($this->marge_gauche, $curY+6, $this->page_largeur - $this->marge_droite, $curY+6);
						}

						$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, 0, $this->page_hauteur - $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 (empty($conf->global->MAIN_PDF_DONOTREPEAT_HEAD)) {
								// $this->_pagehead($pdf, $object, 0, $outputlangs);
							}
						}
						if (isset($object->lines[$i + 1]->pagebreak) && $object->lines[$i + 1]->pagebreak) {
							if ($pagenb == 1) {
								$this->_tableau($pdf, $tab_top-3, $this->page_hauteur - $tab_top - $heightforfooter, 0, $outputlangs, 0, 1, $object->multicurrency_code);
							} else {
								$this->_tableau($pdf, 0, $this->page_hauteur - $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 (empty($conf->global->MAIN_PDF_DONOTREPEAT_HEAD)) {
								// $this->_pagehead($pdf, $object, 0, $outputlangs);
							}
						}
					}

					$this->db->free($resql);

					/**
					 * Footer table
					 */
					// $nexY = $pdf->GetY();
					// $nexY += 4;
					$curY = $nexY;

					if ($nblines > 0) {



						$ht = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter;
						$pdf->line($this->posxlabel-1, $nexY, $this->posxlabel-1, $nexY+8);

						$pdf->SetLineStyle(array('dash'=>'0', 'color'=>array(80, 80, 80)));
						$pdf->SetFont('', 'B', $default_font_size - 1);
						$pdf->SetTextColor(0, 0, 120);

						// Ref.
						$pdf->line($this->posxdesc-1, $nexY, $this->posxdesc - 1, $nexY+8);	// line takes a position y in 2nd parameter and 4th parameter
						$pdf->Rect($this->posxdesc-1, $nexY, $this->wref, 8, 'F', $this->border_style, array(255, 217, 102));
						$pdf->SetXY($this->posxdesc, $nexY);
						$pdf->MultiCell($this->wref, 3, $langs->trans("Total"), 0, 'L');

						// Label 
						$pdf->Rect($this->posxlabel - 1, $nexY, $this->posxqty - $this->posxlabel, 8, 'F', $this->border_style, array(255, 217, 102));

						// Quantity
						$pdf->line($this->posxqty+6, $nexY, $this->posxqty+6, $nexY+8);
						$valtoshow = price2num($totalunit, 'MS');
						$towrite = empty($valtoshow) ? '0' : $valtoshow;

						$pdf->Rect($this->posxqty-1, $nexY, $this->posxup - $this->posxqty, 8, 'F', $this->border_style, array(255, 217, 102));
						$pdf->SetXY($this->posxqty, $nexY);
						$pdf->MultiCell($this->posxup - $this->posxqty - 0.8, 3, $towrite, 0, 'R');

						// Prix unitaire
						$pdf->line($this->posxup-1, $nexY, $this->posxup-1, $nexY+8);
						$pdf->Rect($this->posxup - 1, $nexY, $this->posxunit - $this->posxup +1, 8, 'F', $this->border_style, array(255, 217, 102));

						// Total PMP
						$pdf->line($this->posxunit - 1, $nexY, $this->posxunit - 1, $nexY+8);
						$pdf->Rect($this->posxunit-1, $nexY, $this->posxdiscount - $this->posxunit, 8, 'F', $this->border_style, array(255, 217, 102));
						$pdf->SetXY($this->posxunit, $nexY);
						$pdf->MultiCell($this->posxdiscount - $this->posxunit - 0.8, 3, price(price2num($totalvalue, 'MT'), 0, $outputlangs), 0, 'R');

						$pdf->line($this->posxdiscount-1, $nexY, $this->posxdiscount-1, $nexY+8);
						$pdf->Rect($this->posxdiscount - 1, $nexY, $this->postotalht - $this->posxdiscount + 1, 8, 'F', $this->border_style, array(255, 217, 102));

						// Price sell min
						$pdf->line($this->postotalht, $nexY, $this->postotalht, $nexY+8);
						$pdf->Rect($this->postotalht - 1, $nexY, $this->page_largeur - $this->marge_droite - $this->postotalht +1, 8, 'F', $this->border_style, array(255, 217, 102));
						if (empty($conf->global->PRODUIT_MULTIPRICES)) {
							// Total sell min
							$pdf->SetXY($this->postotalht, $nexY);
							$pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 3, price(price2num($totalvaluesell, 'MT'), 0, $outputlangs), 0, 'R', 0);
						}
						$pdf->line($this->page_largeur - $this->marge_droite, $nexY , $this->page_largeur - $this->marge_droite, $nexY+8);








					}
				} 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_newpage=15;
				$tab_top = $tab_top_newpage + $top_shift;

				// 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;
				}

				if (!empty($conf->global->MAIN_UMASK)) {
					@chmod($file, octdec($conf->global->MAIN_UMASK));
				}

				$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
	/**
	 *   Show table for lines
	 *
	 *   @param     TCPDF		$pdf     		Object PDF
	 *   @param     string		$tab_top		Top position of table
	 *   @param     string		$tab_height		Height of table (rectangle)
	 *   @param     int			$nexY			Y (not used)
	 *   @param     Translate	$outputlangs	Langs object
	 *   @param     int			$hidetop		1=Hide top bar of array and title, 0=Hide nothing, -1=Hide only title
	 *   @param     int			$hidebottom		Hide bottom bar of array
	 *   @param     string		$currency		Currency code
	 *   @return    void
	 */
	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);
		$tab_top -= 8;
		// 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, 8, 'F', null, array(146, 208, 80));
		// 	}
		// }

		$pdf->SetDrawColor(200, 200, 200);
		$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(80, 80, 80)));
		$pdf->SetDrawColor(200, 200, 200);
		$pdf->line($this->marge_gauche, $tab_top+2, $this->page_largeur - $this->marge_droite, $tab_top+2);
		$pdf->SetTextColor(0, 0, 120);

		$pdf->line($this->posxdesc-1, $tab_top, $this->posxdesc - 1, $tab_top + 8);	// line takes a position y in 2nd parameter and 4th parameter
		if (empty($hidetop)) {
			$pdf->Rect($this->posxdesc - 1, $tab_top, $this->wref, 8, 'F', $this->border_style, array(146, 208, 80));
			$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 + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->posxlabel - 1, $tab_top, $this->posxqty - $this->posxlabel, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->posxlabel - 1, $tab_top + 1);
			$pdf->MultiCell($this->posxqty - $this->posxlabel - 1, 2, $outputlangs->transnoentities("Label"), '', 'L');
		}

		$pdf->line($this->posxqty+6, $tab_top, $this->posxqty+6, $tab_top + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->posxqty - 1, $tab_top, $this->posxup - $this->posxqty, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->posxqty - 1, $tab_top + 1);
			$pdf->MultiCell($this->posxup - $this->posxqty - 1, 2, $outputlangs->transnoentities("Units"), '', 'R');
		}

		$pdf->line($this->posxup-1, $tab_top, $this->posxup-1, $tab_top + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->posxup - 1, $tab_top, $this->posxunit - $this->posxup, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->posxup - 1, $tab_top + 1);
			$pdf->MultiCell($this->posxunit - $this->posxup - 1, 2, $outputlangs->transnoentities("AverageUnitPricePMPShort"), '', 'R');
		}

		$pdf->line($this->posxunit - 1, $tab_top, $this->posxunit - 1, $tab_top + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->posxunit - 1, $tab_top, $this->posxdiscount - $this->posxunit, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->posxunit - 1, $tab_top + 1);
			$pdf->MultiCell($this->posxdiscount - $this->posxunit - 1, 2, $outputlangs->transnoentities("EstimatedStockValueShort"), '', 'R');
		}

		$pdf->line($this->posxdiscount-1, $tab_top, $this->posxdiscount-1, $tab_top + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->posxdiscount - 1, $tab_top, $this->postotalht - $this->posxdiscount + 1, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->posxdiscount - 1, $tab_top + 1);
			$pdf->MultiCell($this->postotalht - $this->posxdiscount + 1, 2, $outputlangs->transnoentities("SellPriceMin"), '', 'R');
		}

		$pdf->line($this->postotalht, $tab_top, $this->postotalht, $tab_top + 8);
		if (empty($hidetop)) {
			$pdf->Rect($this->postotalht - 1, $tab_top, $this->page_largeur - $this->marge_droite - $this->postotalht +1, 8, 'F', $this->border_style, array(146, 208, 80));
			$pdf->SetXY($this->postotalht - 1, $tab_top + 1);
			$pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalht, 2, $outputlangs->transnoentities("EstimatedStockValueSellShort"), '', 'R');
		
		}

		$pdf->line($this->page_largeur - $this->marge_droite, $tab_top , $this->page_largeur - $this->marge_droite, $tab_top + 8);
		$pdf->SetDrawColor(200, 200, 200);
		$pdf->SetLineStyle(array('dash'=>'0', 'color'=>array(80, 80, 80)));
		// $pdf->SetLineStyle(array('dash'=>0));
	}

	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
	/**
	 *  Show top header of page.
	 *
	 *  @param	TCPDF		$pdf     		Object PDF
	 *  @param  Object		$object     	Object to show
	 *  @param  int	    	$showaddress    0=no, 1=yes
	 *  @param  Translate	$outputlangs	Object lang for output
	 *  @param	string		$titlekey		Translation key to show as title of document
	 *  @return	int                         Return topshift value
	 */
	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->COMMANDE_DRAFT_WATERMARK))) {
			pdf_watermark($pdf, $outputlangs, $this->page_hauteur, $this->page_largeur, 'mm', $conf->global->COMMANDE_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
		$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, 40, 40); // 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');
		}
		
		$lastmovmntY = $pdf->GetY() + 36;

		$pdf->SetFont('', 'B', $default_font_size + 3);
		$pdf->SetXY($posx, $posy);
		$pdf->SetTextColor(0, 0, 60);
		$title = $outputlangs->transnoentities("Warehouse");
		$pdf->MultiCell(100, 3, $title, '', 'R');

		$pdf->SetFont('', 'B', $default_font_size);

		$posy += 5;
		$pdf->SetXY($posx, $posy);
		$pdf->SetTextColor(0, 0, 60);

		$pdf->MultiCell(100, 4, $outputlangs->transnoentities("Ref")." : ".$outputlangs->convToOutputCharset($object->label), '', 'R');

		$posy += 5;
		$pdf->SetFont('', '', $default_font_size - 1);
		$pdf->SetXY($posx, $posy);
		$pdf->SetTextColor(0, 0, 60);
		$pdf->MultiCell(100, 3, $outputlangs->transnoentities("LocationSummary").' :', '', 'R');

		$posy += 4;
		$pdf->SetXY($posx - 50, $posy);
		$pdf->MultiCell(150, 3, $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');
		}

		// Description
		$nexY = $pdf->GetY();
		// $nexY += 5;
		// $pdf->SetXY($posx, $posy);
		// $pdf->writeHTMLCell(190, 2, $this->marge_gauche+60, $nexY-10, '<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+54, $lastmovmntY-8, '<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+54, $lastmovmntY-4, '<b>'.$outputlangs->transnoentities("NumberOfProducts").' : </b>'.(empty($valtoshow) ? '0' : $valtoshow), 0, 1);
		$nexY = $pdf->GetY();

		// Value
		$pdf->writeHTMLCell(190, 2, $this->marge_gauche+54, $lastmovmntY, '<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();


		// 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(200, 2, 0, $lastmovmntY, '<b>'.$outputlangs->transnoentities("LastMovement").' : </b>'.$toWrite, 0, 1, false, true, 'R');
		$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
	/**
	 *   	Show footer of page. Need this->emetteur object
	 *
	 *   	@param	TCPDF		$pdf     			PDF
	 * 		@param	Object		$object				Object to show
	 *      @param	Translate	$outputlangs		Object lang for output
	 *      @param	int			$hidefreetext		1=Hide free text
	 *      @return	int								Return height of bottom margin including footer text
	 */
	protected function _pagefoot(&$pdf, $object, $outputlangs, $hidefreetext = 0)
	{
		global $conf;
		$showdetails = empty($conf->global->MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS) ? 0 : $conf->global->MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS;
		return pdf_pagefoot($pdf, $outputlangs, 'PRODUCT_FREE_TEXT', $this->emetteur, $this->marge_basse, $this->marge_gauche, $this->page_hauteur, $object, $showdetails, $hidefreetext);
	}
}
