dolibarr  20.0.0-alpha
pdf_standard.modules.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2015 Laurent Destailleur <eldy@users.sourceforge.net>
3  * Copyright (C) 2015 Alexandre Spangaro <aspangaro@open-dsi.fr>
4  * Copyright (C) 2016-2023 Philippe Grand <philippe.grand@atoo-net.com>
5  * Copyright (C) 2018-2020 Frédéric France <frederic.france@netlogic.fr>
6  * Copyright (C) 2018 Francis Appels <francis.appels@z-application.com>
7  * Copyright (C) 2019 Markus Welters <markus@welters.de>
8  * Copyright (C) 2019 Rafael Ingenleuf <ingenleuf@welters.de>
9  * Copyright (C) 2020 Marc Guenneugues <marc.guenneugues@simicar.fr>
10  * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
11  *
12  * This program is free software; you can redistribute it and/or modify
13  * it under the terms of the GNU General Public License as published by
14  * the Free Software Foundation; either version 3 of the License, or
15  * (at your option) any later version.
16  *
17  * This program is distributed in the hope that it will be useful,
18  * but WITHOUT ANY WARRANTY; without even the implied warranty of
19  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20  * GNU General Public License for more details.
21  *
22  * You should have received a copy of the GNU General Public License
23  * along with this program. If not, see <https://www.gnu.org/licenses/>.
24  * or see https://www.gnu.org/
25  */
26 
33 require_once DOL_DOCUMENT_ROOT.'/core/modules/expensereport/modules_expensereport.php';
34 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
35 require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
36 require_once DOL_DOCUMENT_ROOT.'/core/lib/pdf.lib.php';
37 require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
38 require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
39 require_once DOL_DOCUMENT_ROOT.'/core/lib/bank.lib.php';
40 require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
41 require_once DOL_DOCUMENT_ROOT.'/user/class/userbankaccount.class.php';
42 
47 {
51  public $db;
52 
56  public $name;
57 
61  public $description;
62 
66  public $update_main_doc_field;
67 
71  public $type;
72 
77  public $version = 'dolibarr';
78 
79  public $posxpiece;
80  public $posxcomment;
81  public $posxtva;
82  public $posxup;
83  public $posxqty;
84  public $posxtype;
85 
89  public $posxdate;
90  public $posxprojet;
91  public $postotalht;
92  public $postotalttc;
93 
94 
100  public function __construct($db)
101  {
102  global $conf, $langs, $mysoc, $user;
103 
104  // Translations
105  $langs->loadLangs(array("main", "trips", "projects"));
106 
107  $this->db = $db;
108  $this->name = "";
109  $this->description = $langs->trans('PDFStandardExpenseReports');
110  $this->update_main_doc_field = 1; // Save the name of generated file as the main doc when generating a doc with this template
111 
112  // Page size for A4 format
113  $this->type = 'pdf';
114  $formatarray = pdf_getFormat();
115  $this->page_largeur = $formatarray['width'];
116  $this->page_hauteur = $formatarray['height'];
117  $this->format = array($this->page_largeur, $this->page_hauteur);
118  $this->marge_gauche = getDolGlobalInt('MAIN_PDF_MARGIN_LEFT', 10);
119  $this->marge_droite = getDolGlobalInt('MAIN_PDF_MARGIN_RIGHT', 10);
120  $this->marge_haute = getDolGlobalInt('MAIN_PDF_MARGIN_TOP', 10);
121  $this->marge_basse = getDolGlobalInt('MAIN_PDF_MARGIN_BOTTOM', 10);
122 
123  $this->option_logo = 1; // Display logo
124  $this->option_tva = 1; // Manage the vat option FACTURE_TVAOPTION
125  $this->option_modereg = 1; // Display payment mode
126  $this->option_condreg = 1; // Display payment terms
127  $this->option_multilang = 1; // Available in several languages
128  $this->option_escompte = 0; // Displays if there has been a discount
129  $this->option_credit_note = 0; // Support credit notes
130  $this->option_freetext = 1; // Support add of a personalised text
131  $this->option_draft_watermark = 1; // Support add of a watermark on drafts
132 
133  // Get source company
134  $this->emetteur = $mysoc;
135 
136  if (empty($this->emetteur->country_code)) {
137  $this->emetteur->country_code = substr($langs->defaultlang, -2); // By default, if was not defined
138  }
139 
140  // Define position of columns
141  $this->posxpiece = $this->marge_gauche + 1;
142  $this->posxcomment = $this->marge_gauche + 10;
143  //$this->posxdate=88;
144  //$this->posxtype=107;
145  //$this->posxprojet=120;
146  $this->posxtva = 112;
147  $this->posxup = 127;
148  $this->posxqty = 150;
149  $this->postotalht = 160;
150  $this->postotalttc = 180;
151  // if (!isModEnabled('project')) {
152  // $this->posxtva-=20;
153  // $this->posxup-=20;
154  // $this->posxqty-=20;
155  // $this->postotalttc-=20;
156  // }
157  if ($this->page_largeur < 210) { // To work with US executive format
158  $this->posxdate -= 20;
159  $this->posxtype -= 20;
160  $this->posxprojet -= 20;
161  $this->posxtva -= 20;
162  $this->posxup -= 20;
163  $this->posxqty -= 20;
164  $this->postotalttc -= 20;
165  }
166 
167  $this->tva = array();
168  $this->tva_array = array();
169  $this->localtax1 = array();
170  $this->localtax2 = array();
171  $this->atleastoneratenotnull = 0;
172  $this->atleastonediscount = 0;
173  }
174 
175 
176  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
188  public function write_file($object, $outputlangs, $srctemplatepath = '', $hidedetails = 0, $hidedesc = 0, $hideref = 0)
189  {
190  // phpcs:enable
191  global $user, $langs, $conf, $mysoc, $db, $hookmanager;
192 
193  if (!is_object($outputlangs)) {
194  $outputlangs = $langs;
195  }
196  // For backward compatibility with FPDF, force output charset to ISO, because FPDF expect text to be encoded in ISO
197  if (getDolGlobalString('MAIN_USE_FPDF')) {
198  $outputlangs->charset_output = 'ISO-8859-1';
199  }
200 
201  // Load traductions files required by page
202  $outputlangs->loadLangs(array("main", "trips", "projects", "dict", "bills", "banks"));
203 
204  $nblines = count($object->lines);
205 
206  if ($conf->expensereport->dir_output) {
207  // Definition of $dir and $file
208  if ($object->specimen) {
209  $dir = $conf->expensereport->dir_output;
210  $file = $dir."/SPECIMEN.pdf";
211  } else {
212  $objectref = dol_sanitizeFileName($object->ref);
213  $dir = $conf->expensereport->dir_output."/".$objectref;
214  $file = $dir."/".$objectref.".pdf";
215  }
216 
217  if (!file_exists($dir)) {
218  if (dol_mkdir($dir) < 0) {
219  $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
220  return 0;
221  }
222  }
223 
224  if (file_exists($dir)) {
225  // Add pdfgeneration hook
226  if (!is_object($hookmanager)) {
227  include_once DOL_DOCUMENT_ROOT.'/core/class/hookmanager.class.php';
228  $hookmanager = new HookManager($this->db);
229  }
230  $hookmanager->initHooks(array('pdfgeneration'));
231  $parameters = array('file' => $file, 'object' => $object, 'outputlangs' => $outputlangs);
232  global $action;
233  $reshook = $hookmanager->executeHooks('beforePDFCreation', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
234 
235  // Create pdf instance
236  $pdf = pdf_getInstance($this->format);
237  $default_font_size = pdf_getPDFFontSize($outputlangs); // Must be after pdf_getInstance
238  $heightforinfotot = 40; // Height reserved to output the info and total part
239  $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
240  $heightforfooter = $this->marge_basse + 12; // Height reserved to output the footer (value include bottom margin)
241  if (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS')) {
242  $heightforfooter += 6;
243  }
244 
245  $pdf->SetAutoPageBreak(1, 0);
246 
247  if (class_exists('TCPDF')) {
248  $pdf->setPrintHeader(false);
249  $pdf->setPrintFooter(false);
250  }
251  $pdf->SetFont(pdf_getPDFFont($outputlangs));
252  // Set path to the background PDF File
253  if (getDolGlobalString('MAIN_ADD_PDF_BACKGROUND')) {
254  $pagecount = $pdf->setSourceFile($conf->mycompany->dir_output.'/' . getDolGlobalString('MAIN_ADD_PDF_BACKGROUND'));
255  $tplidx = $pdf->importPage(1);
256  }
257 
258  $pdf->Open();
259  $pagenb = 0;
260  $pdf->SetDrawColor(128, 128, 128);
261 
262  $pdf->SetTitle($outputlangs->convToOutputCharset($object->ref));
263  $pdf->SetSubject($outputlangs->transnoentities("Trips"));
264  $pdf->SetCreator("Dolibarr ".DOL_VERSION);
265  $pdf->SetAuthor($outputlangs->convToOutputCharset($user->getFullName($outputlangs)));
266  $pdf->SetKeyWords($outputlangs->convToOutputCharset($object->ref)." ".$outputlangs->transnoentities("Trips"));
267  if (getDolGlobalString('MAIN_DISABLE_PDF_COMPRESSION')) {
268  $pdf->SetCompression(false);
269  }
270 
271  // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
272  $pdf->SetMargins($this->marge_gauche, $this->marge_haute, $this->marge_droite); // Left, Top, Right
273 
274  // New page
275  $pdf->AddPage();
276  if (!empty($tplidx)) {
277  $pdf->useTemplate($tplidx);
278  }
279  $pagenb++;
280  $this->_pagehead($pdf, $object, 1, $outputlangs);
281  $pdf->SetFont('', '', $default_font_size - 1);
282  $pdf->MultiCell(0, 3, ''); // Set interline to 3
283  $pdf->SetTextColor(0, 0, 0);
284 
285  $tab_top = 95;
286  $tab_top_newpage = (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD') ? 65 : 10);
287 
288  $tab_height = $this->page_hauteur - $tab_top - $heightforfooter - $heightforfreetext;
289 
290  // Show notes
291  $notetoshow = empty($object->note_public) ? '' : $object->note_public;
292  if (getDolGlobalString('MAIN_ADD_SALE_REP_SIGNATURE_IN_NOTE')) {
293  // Get first sale rep
294  if (is_object($object->thirdparty)) {
295  $salereparray = $object->thirdparty->getSalesRepresentatives($user);
296  $salerepobj = new User($this->db);
297  $salerepobj->fetch($salereparray[0]['id']);
298  if (!empty($salerepobj->signature)) {
299  $notetoshow = dol_concatdesc($notetoshow, $salerepobj->signature);
300  }
301  }
302  }
303  if ($notetoshow) {
304  $substitutionarray = pdf_getSubstitutionArray($outputlangs, null, $object);
305  complete_substitutions_array($substitutionarray, $outputlangs, $object);
306  $notetoshow = make_substitutions($notetoshow, $substitutionarray, $outputlangs);
307  $notetoshow = convertBackOfficeMediasLinksToPublicLinks($notetoshow);
308 
309  $tab_top = 95; // @phan-suppress-current-line PhanPluginRedundantAssignment
310 
311  $pdf->SetFont('', '', $default_font_size - 1);
312  $pdf->writeHTMLCell(190, 3, $this->posxpiece - 1, $tab_top, dol_htmlentitiesbr($notetoshow), 0, 1);
313  $nexY = $pdf->GetY();
314  $height_note = $nexY - $tab_top;
315 
316  // Rect takes a length in 3rd parameter
317  $pdf->SetDrawColor(192, 192, 192);
318  $pdf->Rect($this->marge_gauche, $tab_top - 1, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $height_note + 1);
319 
320  $tab_height = $tab_height - $height_note;
321  $tab_top = $nexY + 6;
322  } else {
323  $height_note = 0;
324  }
325 
326  $iniY = $tab_top + 7;
327  $nexY = $tab_top + 7;
328 
329  $showpricebeforepagebreak = 1;
330  $pdf->setTopMargin($tab_top_newpage);
331  // Loop on each lines
332  $i = 0;
333  while ($i < $nblines) {
334  $pdf->SetFont('', '', $default_font_size - 2); // Into loop to work with multipage
335  $pdf->SetTextColor(0, 0, 0);
336 
337  $pdf->setTopMargin($tab_top_newpage);
338  if (empty($showpricebeforepagebreak) && ($i !== ($nblines - 1))) {
339  $pdf->setPageOrientation('', 1, $heightforfooter); // The only function to edit the bottom margin of current page to set it.
340  } else {
341  $pdf->setPageOrientation('', 1, $heightforfooter + $heightforfreetext + $heightforinfotot); // The only function to edit the bottom margin of current page to set it.
342  }
343 
344  $pageposbefore = $pdf->getPage();
345  $curY = $nexY;
346  $pdf->startTransaction();
347  $this->printLine($pdf, $object, $i, $curY, $default_font_size, $outputlangs, $hidedetails);
348  $pageposafter = $pdf->getPage();
349  if ($pageposafter > $pageposbefore) {
350  // There is a pagebreak
351  $pdf->rollbackTransaction(true);
352 
353  $pageposafter = $pageposbefore;
354  //print $pageposafter.'-'.$pageposbefore;exit;
355  if (empty($showpricebeforepagebreak)) {
356  $pdf->AddPage('', '', true);
357  if (!empty($tplidx)) {
358  $pdf->useTemplate($tplidx);
359  }
360  if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
361  $this->_pagehead($pdf, $object, 0, $outputlangs);
362  }
363  $pdf->setPage($pageposafter + 1);
364  $showpricebeforepagebreak = 1;
365  $nexY = $tab_top_newpage;
366  $nexY += ($pdf->getFontSize() * 1.3); // Add space between lines
367  $pdf->SetFont('', '', $default_font_size - 2); // Into loop to work with multipage
368  $pdf->SetTextColor(0, 0, 0);
369 
370  $pdf->setTopMargin($tab_top_newpage);
371  continue;
372  } else {
373  $pdf->setPageOrientation('', 1, $heightforfooter);
374  $showpricebeforepagebreak = 0;
375  }
376 
377  $this->printLine($pdf, $object, $i, $curY, $default_font_size, $outputlangs, $hidedetails);
378  $pageposafter = $pdf->getPage();
379  $posyafter = $pdf->GetY();
380  //var_dump($posyafter); var_dump(($this->page_hauteur - ($heightforfooter+$heightforfreetext+$heightforinfotot))); exit;
381  if ($posyafter > ($this->page_hauteur - ($heightforfooter + $heightforfreetext + $heightforinfotot))) {
382  // There is no space left for total+free text
383  if ($i == ($nblines - 1)) {
384  // No more lines, and no space left to show total, so we create a new page
385  $pdf->AddPage('', '', true);
386  if (!empty($tplidx)) {
387  $pdf->useTemplate($tplidx);
388  }
389  if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
390  $this->_pagehead($pdf, $object, 0, $outputlangs);
391  }
392  $pdf->setPage($pageposafter + 1);
393  }
394  } else {
395  // We found a page break
396  // Allows data in the first page if description is long enough to break in multiples pages
397  if (getDolGlobalString('MAIN_PDF_DATA_ON_FIRST_PAGE')) {
398  $showpricebeforepagebreak = 1;
399  } else {
400  $showpricebeforepagebreak = 0;
401  }
402  }
403  } else { // No pagebreak
404  $pdf->commitTransaction();
405  }
406  $i++;
407  //nexY
408  $nexY = $pdf->GetY();
409  $pageposafter = $pdf->getPage();
410  $pdf->setPage($pageposbefore);
411  $pdf->setTopMargin($this->marge_haute);
412  $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it.
413 
414  //$nblineFollowComment = 1;
415  // Search number of lines coming to know if there is enough room
416  // if ($i < ($nblines - 1)) // If it's not last line
417  // {
418  // //Fetch current description to know on which line the next one should be placed
419  // $follow_comment = $object->lines[$i]->comments;
420  // $follow_type = $object->lines[$i]->type_fees_code;
421 
422  // //on compte le nombre de ligne afin de verifier la place disponible (largeur de ligne 52 caracteres)
423  // $nbLineCommentNeed = dol_nboflines_bis($follow_comment,52,$outputlangs->charset_output);
424  // $nbLineTypeNeed = dol_nboflines_bis($follow_type,4,$outputlangs->charset_output);
425 
426  // $nblineFollowComment = max($nbLineCommentNeed, $nbLineTypeNeed);
427  // }
428 
429  //$nexY+=$nblineFollowComment*($pdf->getFontSize()*1.3); // Add space between lines
430  $nexY += ($pdf->getFontSize() * 1.3); // Add space between lines
431 
432  // Detect if some page were added automatically and output _tableau for past pages
433  while ($pagenb < $pageposafter) {
434  $pdf->setPage($pagenb);
435  $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it.
436  if ($pagenb == 1) {
437  $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforfooter, 0, $outputlangs, 0, 1);
438  } else {
439  $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforfooter, 0, $outputlangs, 1, 1);
440  }
441  $this->_pagefoot($pdf, $object, $outputlangs, 1);
442  $pagenb++;
443  $pdf->setPage($pagenb);
444  $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it.
445  if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
446  $this->_pagehead($pdf, $object, 0, $outputlangs);
447  }
448  if (!empty($tplidx)) {
449  $pdf->useTemplate($tplidx);
450  }
451  }
452  if (isset($object->lines[$i + 1]->pagebreak) && $object->lines[$i + 1]->pagebreak) {
453  if ($pagenb == 1) {
454  $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforfooter, 0, $outputlangs, 0, 1);
455  } else {
456  $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforfooter, 0, $outputlangs, 1, 1);
457  }
458  $this->_pagefoot($pdf, $object, $outputlangs, 1);
459  // New page
460  $pdf->AddPage();
461  if (!empty($tplidx)) {
462  $pdf->useTemplate($tplidx);
463  }
464  $pagenb++;
465  if (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD')) {
466  $this->_pagehead($pdf, $object, 0, $outputlangs);
467  }
468  }
469  }
470 
471  // Show square
472  if ($pagenb == 1) {
473  $this->_tableau($pdf, $tab_top, $this->page_hauteur - $tab_top - $heightforinfotot - $heightforfreetext - $heightforfooter, 0, $outputlangs, 0, 0);
474  $bottomlasttab = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter + 1;
475  } else {
476  $this->_tableau($pdf, $tab_top_newpage, $this->page_hauteur - $tab_top_newpage - $heightforinfotot - $heightforfreetext - $heightforfooter, 0, $outputlangs, 1, 0);
477  $bottomlasttab = $this->page_hauteur - $heightforinfotot - $heightforfreetext - $heightforfooter + 1;
478  }
479 
480  $pdf->SetFont('', '', 10);
481 
482  // Show total area box
483  $posy = $bottomlasttab + 5;
484  $posy_start_of_totals = $posy;
485  $pdf->SetXY(130, $posy);
486  $pdf->MultiCell(70, 5, $outputlangs->transnoentities("TotalHT"), 1, 'L');
487  $pdf->SetXY(180, $posy);
488  $pdf->MultiCell($this->page_largeur - $this->marge_gauche - 180, 5, price($object->total_ht), 1, 'R');
489  $pdf->SetFillColor(248, 248, 248);
490 
491  if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT')) {
492  // TODO Show vat amount per tax level
493  $posy += 5;
494  $pdf->SetXY(130, $posy);
495  $pdf->SetTextColor(0, 0, 60);
496  $pdf->MultiCell(70, 5, $outputlangs->transnoentities("TotalVAT"), 1, 'L');
497  $pdf->SetXY(180, $posy);
498  $pdf->MultiCell($this->page_largeur - $this->marge_gauche - 180, 5, price($object->total_tva), 1, 'R');
499  }
500 
501  $posy += 5;
502  $pdf->SetXY(130, $posy);
503  $pdf->SetFont('', 'B', 10);
504  $pdf->SetTextColor(0, 0, 60);
505  $pdf->MultiCell(70, 5, $outputlangs->transnoentities("TotalTTC"), 1, 'L');
506  $pdf->SetXY(180, $posy);
507  $pdf->MultiCell($this->page_largeur - $this->marge_gauche - 180, 5, price($object->total_ttc), 1, 'R');
508 
509  // show payments zone
510  $sumPayments = $object->getSumPayments();
511  if ($sumPayments > 0 && !getDolGlobalString('PDF_EXPENSEREPORT_NO_PAYMENT_DETAILS')) {
512  $posy = $this->tablePayments($pdf, $object, $posy_start_of_totals, $outputlangs);
513  }
514 
515  // Page footer
516  $this->_pagefoot($pdf, $object, $outputlangs);
517  if (method_exists($pdf, 'AliasNbPages')) {
518  $pdf->AliasNbPages();
519  }
520 
521  $pdf->Close();
522 
523  $pdf->Output($file, 'F');
524 
525  // Add pdfgeneration hook
526  $hookmanager->initHooks(array('pdfgeneration'));
527  $parameters = array('file' => $file, 'object' => $object, 'outputlangs' => $outputlangs);
528  global $action;
529  $reshook = $hookmanager->executeHooks('afterPDFCreation', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
530  if ($reshook < 0) {
531  $this->error = $hookmanager->error;
532  $this->errors = $hookmanager->errors;
533  }
534 
535  dolChmod($file);
536 
537  $this->result = array('fullpath' => $file);
538 
539  return 1; // No error
540  } else {
541  $this->error = $langs->trans("ErrorCanNotCreateDir", $dir);
542  return 0;
543  }
544  } else {
545  $this->error = $langs->trans("ErrorConstantNotDefined", "EXPENSEREPORT_OUTPUTDIR");
546  return 0;
547  }
548  }
549 
560  protected function printLine(&$pdf, $object, $linenumber, $curY, $default_font_size, $outputlangs, $hidedetails = 0)
561  {
562  global $conf;
563  $pdf->SetFont('', '', $default_font_size - 1);
564  $pdf->SetTextColor(0, 0, 0);
565 
566  // Accountancy piece
567  $pdf->SetXY($this->posxpiece, $curY);
568  $pdf->writeHTMLCell($this->posxcomment - $this->posxpiece - 0.8, 4, $this->posxpiece - 1, $curY, $linenumber + 1, 0, 1);
569 
570  // Date
571  //$pdf->SetXY($this->posxdate -1, $curY);
572  //$pdf->MultiCell($this->posxtype-$this->posxdate-0.8, 4, dol_print_date($object->lines[$linenumber]->date,"day",false,$outputlangs), 0, 'C');
573 
574  // Type
575  $pdf->SetXY($this->posxtype - 1, $curY);
576  $nextColumnPosX = $this->posxup;
577  if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT')) {
578  $nextColumnPosX = $this->posxtva;
579  }
580  if (isModEnabled('project')) {
581  $nextColumnPosX = $this->posxprojet;
582  }
583 
584  $expensereporttypecode = $object->lines[$linenumber]->type_fees_code;
585  $expensereporttypecodetoshow = ($outputlangs->trans(($expensereporttypecode)) == $expensereporttypecode ? $object->lines[$linenumber]->type_fees_libelle : $outputlangs->trans($expensereporttypecode));
586 
587 
588  if ($expensereporttypecodetoshow == $expensereporttypecode) {
589  $expensereporttypecodetoshow = preg_replace('/^(EX_|TF_)/', '', $expensereporttypecodetoshow);
590  }
591  //$expensereporttypecodetoshow = dol_trunc($expensereporttypecodetoshow, 9);
592 
593  //$pdf->MultiCell($nextColumnPosX-$this->posxtype-0.8, 4, $expensereporttypecodetoshow, 0, 'C');
594 
595  // Project
596  //if (isModEnabled('project'))
597  //{
598  // $pdf->SetFont('','', $default_font_size - 1);
599  // $pdf->SetXY($this->posxprojet, $curY);
600  // $pdf->MultiCell($this->posxtva-$this->posxprojet-0.8, 4, $object->lines[$linenumber]->projet_ref, 0, 'C');
601  //}
602 
603  // VAT Rate
604  if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT')) {
605  $vat_rate = pdf_getlinevatrate($object, $linenumber, $outputlangs, $hidedetails);
606  $pdf->SetXY($this->posxtva, $curY);
607  $pdf->MultiCell($this->posxup - $this->posxtva - 0.8, 4, $vat_rate, 0, 'R');
608  }
609 
610  // Unit price
611  $pdf->SetXY($this->posxup, $curY);
612  $pdf->MultiCell($this->posxqty - $this->posxup - 0.8, 4, price($object->lines[$linenumber]->value_unit), 0, 'R');
613 
614  // Quantity
615  $pdf->SetXY($this->posxqty, $curY);
616  $pdf->MultiCell($this->postotalht - $this->posxqty - 0.8, 4, $object->lines[$linenumber]->qty, 0, 'R');
617 
618  // Total without taxes
619  $pdf->SetXY($this->postotalht, $curY);
620  $pdf->MultiCell($this->postotalttc - $this->postotalht - 0.8, 4, price($object->lines[$linenumber]->total_ht), 0, 'R');
621 
622  // Total with all taxes
623  $pdf->SetXY($this->postotalttc - 1, $curY);
624  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalttc + 1, 4, price($object->lines[$linenumber]->total_ttc), 0, 'R');
625 
626  // Comments
627  $pdf->SetXY($this->posxcomment, $curY);
628  $comment = $outputlangs->trans("Date").':'.dol_print_date($object->lines[$linenumber]->date, "day", false, $outputlangs).' ';
629  $comment .= $outputlangs->trans("Type").':'.$expensereporttypecodetoshow.'<br>';
630  if (!empty($object->lines[$linenumber]->projet_ref)) {
631  $comment .= $outputlangs->trans("Project").':'.$object->lines[$linenumber]->projet_ref.'<br>';
632  }
633  $comment .= $object->lines[$linenumber]->comments;
634  $pdf->writeHTMLCell($this->posxtva - $this->posxcomment - 0.8, 4, $this->posxcomment - 1, $curY, $comment, 0, 1);
635  }
636 
637  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
647  protected function _pagehead(&$pdf, $object, $showaddress, $outputlangs)
648  {
649  // global $conf, $langs, $hookmanager;
650  global $user, $langs, $conf, $mysoc, $db, $hookmanager;
651 
652  // Load traductions files required by page
653  $outputlangs->loadLangs(array("main", "trips", "companies"));
654 
655  $default_font_size = pdf_getPDFFontSize($outputlangs);
656 
657  /*
658  // ajout du fondu vert en bas de page à droite
659  $image_fondue = $conf->mycompany->dir_output.'/fondu_vert_.jpg';
660  $pdf->Image($image_fondue,20,107,200,190);
661 
662  pdf_pagehead($pdf,$outputlangs,$this->page_hauteur);
663  */
664 
665  // Draft watermark
666  if ($object->fk_statut == 0 && getDolGlobalString('EXPENSEREPORT_DRAFT_WATERMARK')) {
667  pdf_watermark($pdf, $outputlangs, $this->page_hauteur, $this->page_largeur, 'mm', $conf->global->EXPENSEREPORT_DRAFT_WATERMARK);
668  }
669 
670  $pdf->SetTextColor(0, 0, 60);
671  $pdf->SetFont('', 'B', $default_font_size + 3);
672 
673  $posy = $this->marge_haute;
674  $posx = $this->page_largeur - $this->marge_droite - 100;
675 
676  $pdf->SetXY($this->marge_gauche, $posy);
677 
678  // Logo
679  $logo = $conf->mycompany->dir_output.'/logos/'.$this->emetteur->logo;
680  if ($this->emetteur->logo) {
681  if (is_readable($logo)) {
682  $height = pdf_getHeightForLogo($logo);
683  $pdf->Image($logo, $this->marge_gauche, $posy, 0, $height); // width=0 (auto)
684  } else {
685  $pdf->SetTextColor(200, 0, 0);
686  $pdf->SetFont('', 'B', $default_font_size - 2);
687  $pdf->MultiCell(100, 3, $outputlangs->transnoentities("ErrorLogoFileNotFound", $logo), 0, 'L');
688  $pdf->MultiCell(100, 3, $outputlangs->transnoentities("ErrorGoToGlobalSetup"), 0, 'L');
689  }
690  } else {
691  $text = $this->emetteur->name;
692  $pdf->MultiCell(100, 4, $outputlangs->convToOutputCharset($text), 0, 'L');
693  }
694 
695  $pdf->SetFont('', 'B', $default_font_size + 4);
696  $pdf->SetXY($posx, $posy);
697  $pdf->SetTextColor(0, 0, 60);
698  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $posx, 6, $langs->trans("ExpenseReport"), 0, 'R');
699 
700  $pdf->SetFont('', '', $default_font_size - 1);
701 
702  // Ref complete
703  $posy += 8;
704  $pdf->SetXY($posx, $posy);
705  $pdf->SetTextColor(0, 0, 60);
706  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $posx, 3, $outputlangs->transnoentities("Ref")." : ".$object->ref, '', 'R');
707 
708  // Date start period
709  $posy += 5;
710  $pdf->SetXY($posx, $posy);
711  $pdf->SetTextColor(0, 0, 60);
712  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $posx, 3, $outputlangs->transnoentities("DateStart")." : ".($object->date_debut > 0 ? dol_print_date($object->date_debut, "day", false, $outputlangs) : ''), '', 'R');
713 
714  // Date end period
715  $posy += 5;
716  $pdf->SetXY($posx, $posy);
717  $pdf->SetTextColor(0, 0, 60);
718  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $posx, 3, $outputlangs->transnoentities("DateEnd")." : ".($object->date_fin > 0 ? dol_print_date($object->date_fin, "day", false, $outputlangs) : ''), '', 'R');
719 
720  // Status Expense Report
721  $posy += 6;
722  $pdf->SetXY($posx, $posy);
723  $pdf->SetFont('', 'B', $default_font_size + 2);
724  $pdf->SetTextColor(111, 81, 124);
725  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $posx, 3, $outputlangs->transnoentities($object->labelStatusShort[$object->status]), '', 'R');
726 
727  if ($showaddress) {
728  // Sender properties
729  $carac_emetteur = '';
730  $carac_emetteur .= ($carac_emetteur ? "\n" : '').$outputlangs->convToOutputCharset($this->emetteur->address);
731  $carac_emetteur .= ($carac_emetteur ? "\n" : '').$outputlangs->convToOutputCharset($this->emetteur->zip).' '.$outputlangs->convToOutputCharset($this->emetteur->town);
732  $carac_emetteur .= "\n";
733  if ($this->emetteur->phone) {
734  $carac_emetteur .= ($carac_emetteur ? "\n" : '').$outputlangs->transnoentities("Phone")." : ".$outputlangs->convToOutputCharset($this->emetteur->phone);
735  }
736  if ($this->emetteur->fax) {
737  $carac_emetteur .= ($carac_emetteur ? ($this->emetteur->tel ? " - " : "\n") : '').$outputlangs->transnoentities("Fax")." : ".$outputlangs->convToOutputCharset($this->emetteur->fax);
738  }
739  if ($this->emetteur->email) {
740  $carac_emetteur .= ($carac_emetteur ? "\n" : '').$outputlangs->transnoentities("Email")." : ".$outputlangs->convToOutputCharset($this->emetteur->email);
741  }
742  if ($this->emetteur->url) {
743  $carac_emetteur .= ($carac_emetteur ? "\n" : '').$outputlangs->transnoentities("Web")." : ".$outputlangs->convToOutputCharset($this->emetteur->url);
744  }
745 
746  // Receiver Properties
747  $receiver = new User($this->db);
748  $receiver->fetch($object->fk_user_author);
749  $receiver_account = new UserBankAccount($this->db);
750  $receiver_account->fetch(0, '', $object->fk_user_author);
751  $expense_receiver = '';
752  $expense_receiver .= ($expense_receiver ? "\n" : '').$outputlangs->convToOutputCharset($receiver->address);
753  $expense_receiver .= ($expense_receiver ? "\n" : '').$outputlangs->convToOutputCharset($receiver->zip).' '.$outputlangs->convToOutputCharset($receiver->town);
754  $expense_receiver .= "\n";
755  if ($receiver->email) {
756  $expense_receiver .= ($expense_receiver ? "\n" : '').$outputlangs->transnoentities("Email")." : ".$outputlangs->convToOutputCharset($receiver->email);
757  }
758  if ($receiver_account->iban) {
759  $expense_receiver .= ($expense_receiver ? "\n" : '').$outputlangs->transnoentities("IBAN")." : ".$outputlangs->convToOutputCharset($receiver_account->iban);
760  }
761 
762  // Show sender
763  $posy = 50;
764  $posx = $this->marge_gauche;
765  $hautcadre = 40;
766  if (getDolGlobalString('MAIN_INVERT_SENDER_RECIPIENT')) {
767  $posx = 118;
768  }
769 
770  // Show sender frame
771  $pdf->SetTextColor(0, 0, 0);
772  $pdf->SetFont('', 'B', $default_font_size - 2);
773  $pdf->SetXY($posx, $posy - 5);
774  $pdf->MultiCell(80, 5, $outputlangs->transnoentities("TripSociete"), '', 'L');
775  $pdf->SetXY($posx, $posy);
776  $pdf->SetFillColor(224, 224, 224);
777  $pdf->MultiCell(82, $hautcadre, "", 0, 'R', 1);
778  $pdf->SetTextColor(0, 0, 60);
779 
780  // Show sender information
781  if (!getDolGlobalString('MAIN_INVERT_SENDER_RECIPIENT')) {
782  $pdf->SetXY($posx + 2, $posy + 3);
783  $pdf->SetFont('', 'B', $default_font_size);
784  $pdf->MultiCell(80, 4, $outputlangs->convToOutputCharset($this->emetteur->name), 0, 'L');
785  $pdf->SetXY($posx + 2, $posy + 8);
786  $pdf->SetFont('', '', $default_font_size - 1);
787  $pdf->MultiCell(80, 4, $carac_emetteur, 0, 'L');
788  } else {
789  $pdf->SetXY($posx + 2, $posy + 3);
790  $pdf->SetFont('', 'B', $default_font_size);
791  $pdf->MultiCell(80, 4, $outputlangs->convToOutputCharset(dolGetFirstLastname($receiver->firstname, $receiver->lastname)), 0, 'L');
792  $pdf->SetXY($posx + 2, $posy + 8);
793  $pdf->SetFont('', '', $default_font_size - 1);
794  $pdf->MultiCell(80, 4, $expense_receiver, 0, 'L');
795  }
796 
797  // Show recipient
798  $posy = 50; // @phan-suppress-current-line PhanPluginRedundantAssignment
799  $posx = 100;
800  if (getDolGlobalString('MAIN_INVERT_SENDER_RECIPIENT')) {
801  $posx = $this->marge_gauche;
802  }
803 
804  // Show recipient frame
805  $pdf->SetTextColor(0, 0, 0);
806  $pdf->SetFont('', 'B', 8);
807  $pdf->SetXY($posx, $posy - 5);
808  $pdf->MultiCell(80, 5, $outputlangs->transnoentities("TripNDF")." :", 0, 'L');
809  $pdf->rect($posx, $posy, $this->page_largeur - $this->marge_gauche - $posx, $hautcadre);
810 
811  // Information for expense report (dates and users workflow)
812  if ($object->fk_user_author > 0) {
813  $userfee = new User($this->db);
814  $userfee->fetch($object->fk_user_author);
815  $posy += 3;
816  $pdf->SetXY($posx + 2, $posy);
817  $pdf->SetFont('', '', 10);
818  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("AUTHOR")." : ".dolGetFirstLastname($userfee->firstname, $userfee->lastname), 0, 'L');
819  $posy = $pdf->GetY() + 1;
820  $pdf->SetXY($posx + 2, $posy);
821  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("DateCreation")." : ".dol_print_date($object->date_create, "day", false, $outputlangs), 0, 'L');
822  }
823 
824  if ($object->fk_statut == 99) {
825  if ($object->fk_user_refuse > 0) {
826  $userfee = new User($this->db);
827  $userfee->fetch($object->fk_user_refuse);
828  $posy += 6;
829  $pdf->SetXY($posx + 2, $posy);
830  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("REFUSEUR")." : ".dolGetFirstLastname($userfee->firstname, $userfee->lastname), 0, 'L');
831  $posy += 5;
832  $pdf->SetXY($posx + 2, $posy);
833  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("MOTIF_REFUS")." : ".$outputlangs->convToOutputCharset($object->detail_refuse), 0, 'L');
834  $posy += 5;
835  $pdf->SetXY($posx + 2, $posy);
836  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("DATE_REFUS")." : ".dol_print_date($object->date_refuse, "day", false, $outputlangs), 0, 'L');
837  }
838  } elseif ($object->fk_statut == 4) {
839  if ($object->fk_user_cancel > 0) {
840  $userfee = new User($this->db);
841  $userfee->fetch($object->fk_user_cancel);
842  $posy += 6;
843  $pdf->SetXY($posx + 2, $posy);
844  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("CANCEL_USER")." : ".dolGetFirstLastname($userfee->firstname, $userfee->lastname), 0, 'L');
845  $posy += 5;
846  $pdf->SetXY($posx + 2, $posy);
847  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("MOTIF_CANCEL")." : ".$outputlangs->convToOutputCharset($object->detail_cancel), 0, 'L');
848  $posy += 5;
849  $pdf->SetXY($posx + 2, $posy);
850  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("DATE_CANCEL")." : ".dol_print_date($object->date_cancel, "day", false, $outputlangs), 0, 'L');
851  }
852  } else {
853  if ($object->fk_user_approve > 0) {
854  $userfee = new User($this->db);
855  $userfee->fetch($object->fk_user_approve);
856  $posy += 6;
857  $pdf->SetXY($posx + 2, $posy);
858  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("VALIDOR")." : ".dolGetFirstLastname($userfee->firstname, $userfee->lastname), 0, 'L');
859  $posy += 5;
860  $pdf->SetXY($posx + 2, $posy);
861  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("DateApprove")." : ".dol_print_date($object->date_approve, "day", false, $outputlangs), 0, 'L');
862  }
863  }
864 
865  if ($object->fk_statut == 6) {
866  if ($object->fk_user_paid > 0) {
867  $userfee = new User($this->db);
868  $userfee->fetch($object->fk_user_paid);
869  $posy += 6;
870  $pdf->SetXY($posx + 2, $posy);
871  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("AUTHORPAIEMENT")." : ".dolGetFirstLastname($userfee->firstname, $userfee->lastname), 0, 'L');
872  $posy += 5;
873  $pdf->SetXY($posx + 2, $posy);
874  $pdf->MultiCell(96, 4, $outputlangs->transnoentities("DATE_PAIEMENT")." : ".dol_print_date($object->date_paiement, "day", false, $outputlangs), 0, 'L');
875  }
876  }
877  }
878 
879  return 0;
880  }
881 
882  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
896  protected function _tableau(&$pdf, $tab_top, $tab_height, $nexY, $outputlangs, $hidetop = 0, $hidebottom = 0, $currency = '')
897  {
898  global $conf;
899 
900  // Force to disable hidetop and hidebottom
901  $hidebottom = 0;
902  if ($hidetop) {
903  $hidetop = -1;
904  }
905 
906  $currency = !empty($currency) ? $currency : $conf->currency;
907  $default_font_size = pdf_getPDFFontSize($outputlangs);
908 
909  // Amount in (at tab_top - 1)
910  $pdf->SetTextColor(0, 0, 0);
911  $pdf->SetFont('', '', $default_font_size - 2);
912  $titre = $outputlangs->transnoentities("AmountInCurrency", $outputlangs->transnoentitiesnoconv("Currency".$currency));
913  $pdf->SetXY($this->page_largeur - $this->marge_droite - ($pdf->GetStringWidth($titre) + 4), $tab_top - 4);
914  $pdf->MultiCell(($pdf->GetStringWidth($titre) + 3), 2, $titre);
915 
916  $pdf->SetDrawColor(128, 128, 128);
917 
918  // Rect takes a length in 3rd parameter
919  $pdf->Rect($this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height);
920  // line prend une position y en 3eme param
921  if (empty($hidetop)) {
922  $pdf->line($this->marge_gauche, $tab_top + 5, $this->page_largeur - $this->marge_droite, $tab_top + 5);
923  }
924 
925  $pdf->SetFont('', '', 8);
926 
927  // Accountancy piece
928  if (empty($hidetop)) {
929  $pdf->SetXY($this->posxpiece - 1, $tab_top + 1);
930  $pdf->MultiCell($this->posxcomment - $this->posxpiece - 0.8, 1, '', '', 'R');
931  }
932 
933  // Comments
934  $pdf->line($this->posxcomment - 1, $tab_top, $this->posxcomment - 1, $tab_top + $tab_height);
935  if (empty($hidetop)) {
936  $pdf->SetXY($this->posxcomment - 1, $tab_top + 1);
937  $pdf->MultiCell($this->posxdate - $this->posxcomment - 0.8, 1, $outputlangs->transnoentities("Description"), '', 'L');
938  }
939 
940  // Date
941  //$pdf->line($this->posxdate-1, $tab_top, $this->posxdate-1, $tab_top + $tab_height);
942  //if (empty($hidetop))
943  //{
944  // $pdf->SetXY($this->posxdate-1, $tab_top+1);
945  // $pdf->MultiCell($this->posxtype-$this->posxdate-1,2, $outputlangs->transnoentities("Date"),'','C');
946  //}
947 
948  // Type
949  //$pdf->line($this->posxtype-1, $tab_top, $this->posxtype-1, $tab_top + $tab_height);
950  //if (empty($hidetop))
951  //{
952  // $pdf->SetXY($this->posxtype-1, $tab_top+1);
953  // $pdf->MultiCell($this->posxprojet-$this->posxtype - 1, 2, $outputlangs->transnoentities("Type"), '', 'C');
954  //}
955 
956  //if (isModEnabled('project'))
957  //{
958  // // Project
959  // $pdf->line($this->posxprojet - 1, $tab_top, $this->posxprojet - 1, $tab_top + $tab_height);
960  // if (empty($hidetop)) {
961  // $pdf->SetXY($this->posxprojet - 1, $tab_top + 1);
962  // $pdf->MultiCell($this->posxtva - $this->posxprojet - 1, 2, $outputlangs->transnoentities("Project"), '', 'C');
963  // }
964  //}
965 
966  // VAT
967  if (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_WITHOUT_VAT')) {
968  $pdf->line($this->posxtva - 1, $tab_top, $this->posxtva - 1, $tab_top + $tab_height);
969  if (empty($hidetop)) {
970  $pdf->SetXY($this->posxtva - 0.8, $tab_top + 1);
971  $pdf->MultiCell($this->posxup - $this->posxtva - 1, 2, $outputlangs->transnoentities("VAT"), '', 'C');
972  }
973  }
974 
975  // Unit price
976  $pdf->line($this->posxup - 1, $tab_top, $this->posxup - 1, $tab_top + $tab_height);
977  if (empty($hidetop)) {
978  $pdf->SetXY($this->posxup - 0.8, $tab_top + 1);
979  $pdf->MultiCell($this->posxqty - $this->posxup - 1, 2, $outputlangs->transnoentities("PriceUTTC"), '', 'C');
980  }
981 
982  // Quantity
983  $pdf->line($this->posxqty - 1, $tab_top, $this->posxqty - 1, $tab_top + $tab_height);
984  if (empty($hidetop)) {
985  $pdf->SetXY($this->posxqty - 0.8, $tab_top + 1);
986  $pdf->MultiCell($this->postotalht - $this->posxqty - 1, 2, $outputlangs->transnoentities("Qty"), '', 'C');
987  }
988 
989  // Total without taxes
990  $pdf->line($this->postotalht - 1, $tab_top, $this->postotalht - 1, $tab_top + $tab_height);
991  if (empty($hidetop)) {
992  $pdf->SetXY($this->postotalht - 0.8, $tab_top + 1);
993  $pdf->MultiCell($this->postotalttc - $this->postotalht + 1, 2, $outputlangs->transnoentities("TotalHT"), '', 'C');
994  }
995 
996  // Total with all taxes
997  $pdf->line($this->postotalttc, $tab_top, $this->postotalttc, $tab_top + $tab_height);
998  if (empty($hidetop)) {
999  $pdf->SetXY($this->postotalttc - 0.8, $tab_top + 1);
1000  $pdf->MultiCell($this->page_largeur - $this->marge_droite - $this->postotalttc + 1, 2, $outputlangs->transnoentities("TotalTTC"), '', 'R');
1001  }
1002 
1003  $pdf->SetTextColor(0, 0, 0);
1004  }
1005 
1015  protected function tablePayments(&$pdf, $object, $posy, $outputlangs)
1016  {
1017  global $conf;
1018 
1019  $sign = 1;
1020  $tab3_posx = $this->marge_gauche;
1021  $tab3_top = $posy;
1022  $tab3_width = 88;
1023  $tab3_height = 5;
1024 
1025  $default_font_size = pdf_getPDFFontSize($outputlangs);
1026 
1027  $title = $outputlangs->transnoentities("PaymentsAlreadyDone");
1028  $pdf->SetFont('', '', $default_font_size - 2);
1029  $pdf->SetXY($tab3_posx, $tab3_top - 4);
1030  $pdf->SetTextColor(0, 0, 0);
1031  $pdf->MultiCell(60, 3, $title, 0, 'L', 0);
1032 
1033  $pdf->line($tab3_posx, $tab3_top, $tab3_posx + $tab3_width + 2, $tab3_top); // Top border line of table title
1034 
1035  $pdf->SetXY($tab3_posx, $tab3_top + 1);
1036  $pdf->MultiCell(20, 3, $outputlangs->transnoentities("Date"), 0, 'L', 0);
1037  $pdf->SetXY($tab3_posx + 19, $tab3_top + 1); // Old value 17
1038  $pdf->MultiCell(15, 3, $outputlangs->transnoentities("Amount"), 0, 'C', 0);
1039  $pdf->SetXY($tab3_posx + 35, $tab3_top + 1);
1040  $pdf->MultiCell(30, 3, $outputlangs->transnoentities("Type"), 0, 'L', 0);
1041  if (isModEnabled("bank")) {
1042  $pdf->SetXY($tab3_posx + 65, $tab3_top + 1);
1043  $pdf->MultiCell(25, 3, $outputlangs->transnoentities("BankAccount"), 0, 'L', 0);
1044  }
1045  $pdf->line($tab3_posx, $tab3_top + $tab3_height, $tab3_posx + $tab3_width + 2, $tab3_top + $tab3_height); // Bottom border line of table title
1046 
1047  $y = 0;
1048 
1049  // Loop on each payment
1050  // TODO create method on expensereport class to get payments
1051  // Payments already done (from payment on this expensereport)
1052  $sql = "SELECT p.rowid, p.num_payment, p.datep as dp, p.amount, p.fk_bank,";
1053  $sql .= "c.code as p_code, c.libelle as payment_type,";
1054  $sql .= "ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal";
1055  $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as e, ".MAIN_DB_PREFIX."payment_expensereport as p";
1056  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as c ON p.fk_typepayment = c.id";
1057  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank as b ON p.fk_bank = b.rowid';
1058  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON b.fk_account = ba.rowid';
1059  $sql .= " WHERE e.rowid = ".((int) $object->id);
1060  $sql .= " AND p.fk_expensereport = e.rowid";
1061  $sql .= ' AND e.entity IN ('.getEntity('expensereport').')';
1062  $sql .= " ORDER BY dp";
1063 
1064  $resql = $this->db->query($sql);
1065  if ($resql) {
1066  $num = $this->db->num_rows($resql);
1067  $totalpaid = 0;
1068  $i = 0;
1069  while ($i < $num) {
1070  $y += $tab3_height;
1071  $row = $this->db->fetch_object($resql);
1072 
1073  $pdf->SetXY($tab3_posx, $tab3_top + $y + 1);
1074  $pdf->MultiCell(20, 3, dol_print_date($this->db->jdate($row->dp), 'day', false, $outputlangs, true), 0, 'L', 0);
1075  $pdf->SetXY($tab3_posx + 17, $tab3_top + $y + 1);
1076  $pdf->MultiCell(15, 3, price($sign * $row->amount, 0, $outputlangs), 0, 'R', 0);
1077  $pdf->SetXY($tab3_posx + 35, $tab3_top + $y + 1);
1078  $oper = $outputlangs->transnoentitiesnoconv("PaymentTypeShort".$row->p_code);
1079 
1080  $pdf->MultiCell(40, 3, $oper, 0, 'L', 0);
1081  if (isModEnabled("bank")) {
1082  $pdf->SetXY($tab3_posx + 65, $tab3_top + $y + 1);
1083  $pdf->MultiCell(30, 3, $row->baref, 0, 'L', 0);
1084  }
1085 
1086  $pdf->line($tab3_posx, $tab3_top + $y + $tab3_height, $tab3_posx + $tab3_width + 2, $tab3_top + $y + $tab3_height); // Bottom line border of table
1087  $totalpaid += $row->amount;
1088  $i++;
1089  }
1090  if ($num > 0 && $object->paid == 0) {
1091  $y += $tab3_height;
1092 
1093  $pdf->SetXY($tab3_posx + 17, $tab3_top + $y);
1094  $pdf->MultiCell(15, 3, price($totalpaid), 0, 'R', 0);
1095  $pdf->SetXY($tab3_posx + 35, $tab3_top + $y);
1096  $pdf->MultiCell(30, 4, $outputlangs->transnoentitiesnoconv("AlreadyPaid"), 0, 'L', 0);
1097  $y += $tab3_height - 2;
1098  $pdf->SetXY($tab3_posx + 17, $tab3_top + $y);
1099  $pdf->MultiCell(15, 3, price($object->total_ttc), 0, 'R', 0);
1100  $pdf->SetXY($tab3_posx + 35, $tab3_top + $y);
1101  $pdf->MultiCell(30, 4, $outputlangs->transnoentitiesnoconv("AmountExpected"), 0, 'L', 0);
1102  $y += $tab3_height - 2;
1103  $remaintopay = $object->total_ttc - $totalpaid;
1104  $pdf->SetXY($tab3_posx + 17, $tab3_top + $y);
1105  $pdf->MultiCell(15, 3, price($remaintopay), 0, 'R', 0);
1106  $pdf->SetXY($tab3_posx + 35, $tab3_top + $y);
1107  $pdf->MultiCell(30, 4, $outputlangs->transnoentitiesnoconv("RemainderToPay"), 0, 'L', 0);
1108  }
1109  } else {
1110  $this->error = $this->db->lasterror();
1111  return -1;
1112  }
1113  return -1;
1114  }
1115 
1116  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
1126  protected function _pagefoot(&$pdf, $object, $outputlangs, $hidefreetext = 0)
1127  {
1128  $showdetails = getDolGlobalInt('MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS', 0);
1129  return pdf_pagefoot($pdf, $outputlangs, 'EXPENSEREPORT_FREE_TEXT', $this->emetteur, $this->marge_basse, $this->marge_gauche, $this->page_hauteur, $object, $showdetails, $hidefreetext);
1130  }
1131 }
if($user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition: card.php:58
Class to manage hooks.
Parent class for trips and expenses templates.
Class to manage bank accounts description of users.
Class to manage Dolibarr users.
Definition: user.class.php:50
Class to generate expense report based on standard model.
__construct($db)
Constructor.
_tableau(&$pdf, $tab_top, $tab_height, $nexY, $outputlangs, $hidetop=0, $hidebottom=0, $currency='')
Show table for lines.
printLine(&$pdf, $object, $linenumber, $curY, $default_font_size, $outputlangs, $hidedetails=0)
tablePayments(&$pdf, $object, $posy, $outputlangs)
Show payments table.
_pagehead(&$pdf, $object, $showaddress, $outputlangs)
Show top header of page.
_pagefoot(&$pdf, $object, $outputlangs, $hidefreetext=0)
Show footer of page.
write_file($object, $outputlangs, $srctemplatepath='', $hidedetails=0, $hidedesc=0, $hideref=0)
Function to build pdf onto disk.
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
Definition: index.php:744
print *****$script_file(".$version.") pid cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
if(!function_exists('dolEscapeXML')) convertBackOfficeMediasLinksToPublicLinks($notetoshow)
Convert links to local wrapper to medias files into a string into a public external URL readable on i...
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dolChmod($filepath, $newmask='')
Change mod of a file.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
complete_substitutions_array(&$substitutionarray, $outputlangs, $object=null, $parameters=null, $callfunc="completesubstitutionarray")
Complete the $substitutionarray with more entries coming from external module that had set the "subst...
make_substitutions($text, $substitutionarray, $outputlangs=null, $converttextinhtmlifnecessary=0)
Make substitution into a text string, replacing keys with vals from $substitutionarray (oldval=>newva...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
pdf_getPDFFontSize($outputlangs)
Return font size to use for PDF generation.
Definition: pdf.lib.php:290
pdf_getFormat(Translate $outputlangs=null, $mode='setup')
Return array with format properties of default PDF format.
Definition: pdf.lib.php:86
pdf_getHeightForLogo($logo, $url=false)
Return height to use for Logo onto PDF.
Definition: pdf.lib.php:315
pdf_pagefoot(&$pdf, $outputlangs, $paramfreetext, $fromcompany, $marge_basse, $marge_gauche, $page_hauteur, $object, $showdetails=0, $hidefreetext=0, $page_largeur=0, $watermark='')
Show footer of page for PDF generation.
Definition: pdf.lib.php:1014
pdf_getlinevatrate($object, $i, $outputlangs, $hidedetails=0)
Return line vat rate.
Definition: pdf.lib.php:1915
pdf_getPDFFont($outputlangs)
Return font name to use for PDF generation.
Definition: pdf.lib.php:267
pdf_getSubstitutionArray($outputlangs, $exclude=null, $object=null, $onlykey=0, $include=null)
Return array of possible substitutions for PDF content (without external module substitutions).
Definition: pdf.lib.php:763
pdf_getInstance($format='', $metric='mm', $pagetype='P')
Return a PDF instance object.
Definition: pdf.lib.php:128
pdf_watermark(&$pdf, $outputlangs, $h, $w, $unit, $text)
Add a draft watermark on PDF files.
Definition: pdf.lib.php:783
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition: repair.php:122
$conf db name
Only used if Module[ID]Name translation string is not found.
Definition: repair.php:125