dolibarr  16.0.5
doc_generic_mo_odt.modules.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2010-2012 Laurent Destailleur <eldy@users.sourceforge.net>
3  * Copyright (C) 2012 Juanjo Menent <jmenent@2byte.es>
4  * Copyright (C) 2014 Marcos García <marcosgdf@gmail.com>
5  * Copyright (C) 2016 Charlie Benke <charlie@patas-monkey.com>
6  * Copyright (C) 2018-2021 Philippe Grand <philippe.grand@atoo-net.com>
7  * Copyright (C) 2018 Frédéric France <frederic.france@netlogic.fr>
8  *
9  * This program is free software; you can redistribute it and/or modify
10  * it under the terms of the GNU General Public License as published by
11  * the Free Software Foundation; either version 3 of the License, or
12  * (at your option) any later version.
13  *
14  * This program is distributed in the hope that it will be useful,
15  * but WITHOUT ANY WARRANTY; without even the implied warranty of
16  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17  * GNU General Public License for more details.
18  *
19  * You should have received a copy of the GNU General Public License
20  * along with this program. If not, see <https://www.gnu.org/licenses/>.
21  * or see https://www.gnu.org/
22  */
23 
30 require_once DOL_DOCUMENT_ROOT.'/core/modules/mrp/modules_mo.php';
31 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
32 require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
33 require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
34 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
35 require_once DOL_DOCUMENT_ROOT.'/core/lib/doc.lib.php';
36 
37 
42 {
47  public $emetteur;
48 
53  public $phpmin = array(5, 6);
54 
58  public $version = 'dolibarr';
59 
60 
66  public function __construct($db)
67  {
68  global $conf, $langs, $mysoc;
69 
70  // Load translation files required by the page
71  $langs->loadLangs(array("main", "companies"));
72 
73  $this->db = $db;
74  $this->name = "ODT templates";
75  $this->description = $langs->trans("DocumentModelOdt");
76  $this->scandir = 'MRP_MO_ADDON_PDF_ODT_PATH'; // Name of constant that is used to save list of directories to scan
77 
78  // Page size for A4 format
79  $this->type = 'odt';
80  $this->page_largeur = 0;
81  $this->page_hauteur = 0;
82  $this->format = array($this->page_largeur, $this->page_hauteur);
83  $this->marge_gauche = 0;
84  $this->marge_droite = 0;
85  $this->marge_haute = 0;
86  $this->marge_basse = 0;
87 
88  $this->option_logo = 1; // Display logo
89  $this->option_tva = 0; // Manage the vat option
90  $this->option_modereg = 0; // Display payment mode
91  $this->option_condreg = 0; // Display payment terms
92  $this->option_multilang = 1; // Available in several languages
93  $this->option_escompte = 0; // Displays if there has been a discount
94  $this->option_credit_note = 0; // Support credit notes
95  $this->option_freetext = 1; // Support add of a personalised text
96  $this->option_draft_watermark = 0; // Support add of a watermark on drafts
97 
98  // Get source company
99  $this->emetteur = $mysoc;
100  if (!$this->emetteur->country_code) {
101  $this->emetteur->country_code = substr($langs->defaultlang, -2); // By default if not defined
102  }
103  }
104 
105 
112  public function info($langs)
113  {
114  global $conf, $langs;
115 
116  // Load translation files required by the page
117  $langs->loadLangs(array("errors", "companies"));
118 
119  $form = new Form($this->db);
120 
121  $texte = $this->description.".<br>\n";
122  $texte .= '<form action="'.$_SERVER["PHP_SELF"].'" method="POST">';
123  $texte .= '<input type="hidden" name="token" value="'.newToken().'">';
124  $texte .= '<input type="hidden" name="page_y" value="">';
125  $texte .= '<input type="hidden" name="action" value="setModuleOptions">';
126  $texte .= '<input type="hidden" name="param1" value="MRP_MO_ADDON_PDF_ODT_PATH">';
127  $texte .= '<table class="nobordernopadding" width="100%">';
128 
129  // List of directories area
130  $texte .= '<tr><td>';
131  $texttitle = $langs->trans("ListOfDirectories");
132  $listofdir = explode(',', preg_replace('/[\r\n]+/', ',', trim($conf->global->MRP_MO_ADDON_PDF_ODT_PATH)));
133  $listoffiles = array();
134  foreach ($listofdir as $key => $tmpdir) {
135  $tmpdir = trim($tmpdir);
136  $tmpdir = preg_replace('/DOL_DATA_ROOT/', DOL_DATA_ROOT, $tmpdir);
137  if (!$tmpdir) {
138  unset($listofdir[$key]);
139  continue;
140  }
141  if (!is_dir($tmpdir)) {
142  $texttitle .= img_warning($langs->trans("ErrorDirNotFound", $tmpdir), 0);
143  } else {
144  $tmpfiles = dol_dir_list($tmpdir, 'files', 0, '\.(ods|odt)');
145  if (count($tmpfiles)) {
146  $listoffiles = array_merge($listoffiles, $tmpfiles);
147  }
148  }
149  }
150  $texthelp = $langs->trans("ListOfDirectoriesForModelGenODT");
151  // Add list of substitution keys
152  $texthelp .= '<br>'.$langs->trans("FollowingSubstitutionKeysCanBeUsed").'<br>';
153  $texthelp .= $langs->transnoentitiesnoconv("FullListOnOnlineDocumentation"); // This contains an url, we don't modify it
154 
155  $texte .= $form->textwithpicto($texttitle, $texthelp, 1, 'help', '', 1);
156  $texte .= '<div><div style="display: inline-block; min-width: 100px; vertical-align: middle;">';
157  $texte .= '<textarea class="flat" cols="60" name="value1">';
158  $texte .= $conf->global->MRP_MO_ADDON_PDF_ODT_PATH;
159  $texte .= '</textarea>';
160  $texte .= '</div><div style="display: inline-block; vertical-align: middle;">';
161  $texte .= '<input type="submit" class="button small reposition" name="modify" value="'.$langs->trans("Modify").'">';
162  $texte .= '<br></div></div>';
163 
164  // Scan directories
165  $nbofiles = count($listoffiles);
166  if (!empty($conf->global->MRP_MO_ADDON_PDF_ODT_PATH)) {
167  $texte .= $langs->trans("NumberOfModelFilesFound").': <b>';
168  //$texte.=$nbofiles?'<a id="a_'.get_class($this).'" href="#">':'';
169  $texte .= count($listoffiles);
170  //$texte.=$nbofiles?'</a>':'';
171  $texte .= '</b>';
172  }
173 
174  if ($nbofiles) {
175  $texte .= '<div id="div_'.get_class($this).'" class="hiddenx">';
176  // Show list of found files
177  foreach ($listoffiles as $file) {
178  $texte .= '- '.$file['name'].' <a href="'.DOL_URL_ROOT.'/document.php?modulepart=doctemplates&file=mrps/'.urlencode(basename($file['name'])).'">'.img_picto('', 'listlight').'</a><br>';
179  }
180  $texte .= '</div>';
181  }
182 
183  $texte .= '</td>';
184 
185  $texte .= '<td rowspan="2" class="tdtop hideonsmartphone">';
186  $texte .= '<span class="opacitymedium">';
187  $texte .= $langs->trans("ExampleOfDirectoriesForModelGen");
188  $texte .= '</span>';
189  $texte .= '</td>';
190  $texte .= '</tr>';
191 
192  $texte .= '</table>';
193  $texte .= '</form>';
194 
195  return $texte;
196  }
197 
198  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
210  public function write_file($object, $outputlangs, $srctemplatepath, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
211  {
212  // phpcs:enable
213  global $user, $langs, $conf, $mysoc, $hookmanager;
214 
215  if (empty($srctemplatepath)) {
216  dol_syslog("doc_generic_odt::write_file parameter srctemplatepath empty", LOG_WARNING);
217  return -1;
218  }
219 
220  // Add odtgeneration hook
221  if (!is_object($hookmanager)) {
222  include_once DOL_DOCUMENT_ROOT.'/core/class/hookmanager.class.php';
223  $hookmanager = new HookManager($this->db);
224  }
225  $hookmanager->initHooks(array('odtgeneration'));
226  global $action;
227 
228  if (!is_object($outputlangs)) {
229  $outputlangs = $langs;
230  }
231  $sav_charset_output = $outputlangs->charset_output;
232  $outputlangs->charset_output = 'UTF-8';
233 
234  $outputlangs->loadLangs(array("main", "dict", "companies", "bills"));
235 
236  if ($conf->mrp->dir_output) {
237  // If $object is id instead of object
238  if (!is_object($object)) {
239  $id = $object;
240  $object = new MO($this->db);
241  $result = $object->fetch($id);
242  if ($result < 0) {
243  dol_print_error($this->db, $object->error);
244  return -1;
245  }
246  }
247 
248  $object->fetch_thirdparty();
249 
250  $dir = $conf->mrp->multidir_output[isset($object->entity) ? $object->entity : 1];
251  $objectref = dol_sanitizeFileName($object->ref);
252  if (!preg_match('/specimen/i', $objectref)) {
253  $dir .= "/".$objectref;
254  }
255  $file = $dir."/".$objectref.".odt";
256 
257  if (!file_exists($dir)) {
258  if (dol_mkdir($dir) < 0) {
259  $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
260  return -1;
261  }
262  }
263 
264  if (file_exists($dir)) {
265  //print "srctemplatepath=".$srctemplatepath; // Src filename
266  $newfile = basename($srctemplatepath);
267  $newfiletmp = preg_replace('/\.od(t|s)/i', '', $newfile);
268  $newfiletmp = preg_replace('/template_/i', '', $newfiletmp);
269  $newfiletmp = preg_replace('/modele_/i', '', $newfiletmp);
270  $newfiletmp = $objectref.'_'.$newfiletmp;
271  //$file=$dir.'/'.$newfiletmp.'.'.dol_print_date(dol_now(),'%Y%m%d%H%M%S').'.odt';
272  // Get extension (ods or odt)
273  $newfileformat = substr($newfile, strrpos($newfile, '.') + 1);
274  if (!empty($conf->global->MAIN_DOC_USE_TIMING)) {
275  $format = $conf->global->MAIN_DOC_USE_TIMING;
276  if ($format == '1') {
277  $format = '%Y%m%d%H%M%S';
278  }
279  $filename = $newfiletmp.'-'.dol_print_date(dol_now(), $format).'.'.$newfileformat;
280  } else {
281  $filename = $newfiletmp.'.'.$newfileformat;
282  }
283  $file = $dir.'/'.$filename;
284  //print "newdir=".$dir;
285  //print "newfile=".$newfile;
286  //print "file=".$file;
287  //print "conf->societe->dir_temp=".$conf->societe->dir_temp;
288 
289  dol_mkdir($conf->mrp->dir_temp);
290  if (!is_writable($conf->mrp->dir_temp)) {
291  $this->error = "Failed to write in temp directory ".$conf->mrp->dir_temp;
292  dol_syslog('Error in write_file: '.$this->error, LOG_ERR);
293  return -1;
294  }
295 
296  // If CUSTOMER contact defined on order, we use it
297  $usecontact = false;
298  $arrayidcontact = $object->getIdContact('external', 'CUSTOMER');
299  if (count($arrayidcontact) > 0) {
300  $usecontact = true;
301  $result = $object->fetch_contact($arrayidcontact[0]);
302  }
303 
304  // Recipient name
305  $contactobject = null;
306  if (!empty($usecontact)) {
307  // We can use the company of contact instead of thirdparty company
308  if ($object->contact->socid != $object->thirdparty->id && (!isset($conf->global->MAIN_USE_COMPANY_NAME_OF_CONTACT) || !empty($conf->global->MAIN_USE_COMPANY_NAME_OF_CONTACT))) {
309  $object->contact->fetch_thirdparty();
310  $socobject = $object->contact->thirdparty;
311  $contactobject = $object->contact;
312  } else {
313  $socobject = $object->thirdparty;
314  // if we have a CUSTOMER contact and we dont use it as thirdparty recipient we store the contact object for later use
315  $contactobject = $object->contact;
316  }
317  } else {
318  $socobject = $object->thirdparty;
319  }
320 
321  // Make substitution
322  $substitutionarray = array(
323  '__QTY_TO_PRODUCE__' => $object->qty,
324  );
325  complete_substitutions_array($substitutionarray, $langs, $object);
326  // Call the ODTSubstitution hook
327  $parameters = array('file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$substitutionarray);
328  $reshook = $hookmanager->executeHooks('ODTSubstitution', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
329 
330  // Line of free text
331  $newfreetext = '';
332  $paramfreetext = 'MRP_MO_FREE_TEXT';
333  if (!empty($conf->global->$paramfreetext)) {
334  $newfreetext = make_substitutions($conf->global->$paramfreetext, $substitutionarray);
335  }
336 
337  // Open and load template
338  require_once ODTPHP_PATH.'odf.php';
339  try {
340  $odfHandler = new odf(
341  $srctemplatepath,
342  array(
343  'PATH_TO_TMP' => $conf->mrp->dir_temp,
344  'ZIP_PROXY' => 'PclZipProxy', // PhpZipProxy or PclZipProxy. Got "bad compression method" error when using PhpZipProxy.
345  'DELIMITER_LEFT' => '{',
346  'DELIMITER_RIGHT' => '}'
347  )
348  );
349  } catch (Exception $e) {
350  $this->error = $e->getMessage();
351  dol_syslog($e->getMessage(), LOG_INFO);
352  return -1;
353  }
354 
355  // After construction $odfHandler->contentXml contains content and
356  // [!-- BEGIN row.lines --]*[!-- END row.lines --] has been replaced by
357  // [!-- BEGIN lines --]*[!-- END lines --]
358  //print html_entity_decode($odfHandler->__toString());
359  //print exit;
360  /*
361 
362 
363  // Make substitutions into odt of freetext
364  try {
365  $odfHandler->setVars('free_text', $newfreetext, true, 'UTF-8');
366  } catch (OdfException $e) {
367  dol_syslog($e->getMessage(), LOG_INFO);
368  }
369 
370  // Define substitution array
371  $substitutionarray = getCommonSubstitutionArray($outputlangs, 0, null, $object);
372  $array_object_from_properties = $this->get_substitutionarray_each_var_object($object, $outputlangs);
373  $array_objet = $this->get_substitutionarray_object($object, $outputlangs);
374  $array_user = $this->get_substitutionarray_user($user, $outputlangs);
375  $array_soc = $this->get_substitutionarray_mysoc($mysoc, $outputlangs);
376  $array_thirdparty = $this->get_substitutionarray_thirdparty($socobject, $outputlangs);
377  $array_other = $this->get_substitutionarray_other($outputlangs);
378  // retrieve contact information for use in object as contact_xxx tags
379  $array_thirdparty_contact = array();
380  if ($usecontact && is_object($contactobject)) {
381  $array_thirdparty_contact = $this->get_substitutionarray_contact($contactobject, $outputlangs, 'contact');
382  }
383 
384  $tmparray = array_merge($substitutionarray, $array_object_from_properties, $array_user, $array_soc, $array_thirdparty, $array_objet, $array_other, $array_thirdparty_contact);
385  complete_substitutions_array($tmparray, $outputlangs, $object);
386 
387  // Call the ODTSubstitution hook
388  $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
389  $reshook = $hookmanager->executeHooks('ODTSubstitution', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
390 
391  foreach ($tmparray as $key => $value) {
392  try {
393  if (preg_match('/logo$/', $key)) {
394  // Image
395  if (file_exists($value)) {
396  $odfHandler->setImage($key, $value);
397  } else {
398  $odfHandler->setVars($key, 'ErrorFileNotFound', true, 'UTF-8');
399  }
400  } else {
401  // Text
402  $odfHandler->setVars($key, $value, true, 'UTF-8');
403  }
404  } catch (OdfException $e) {
405  dol_syslog($e->getMessage(), LOG_INFO);
406  }
407  }
408 
409  // Replace tags of lines
410  try {
411  $foundtagforlines = 1;
412  try {
413  $listlines = $odfHandler->setSegment('lines');
414  } catch (OdfException $e) {
415  // We may arrive here if tags for lines not present into template
416  $foundtagforlines = 0;
417  dol_syslog($e->getMessage(), LOG_INFO);
418  }
419 
420  if ($foundtagforlines) {
421  $linenumber = 0;
422  foreach ($object->lines as $line) {
423  $linenumber++;
424  $tmparray = $this->get_substitutionarray_lines($line, $outputlangs, $linenumber);
425  complete_substitutions_array($tmparray, $outputlangs, $object, $line, "completesubstitutionarray_lines");
426  // Call the ODTSubstitutionLine hook
427  $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray, 'line'=>$line);
428  $reshook = $hookmanager->executeHooks('ODTSubstitutionLine', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
429  foreach ($tmparray as $key => $val) {
430  try {
431  $listlines->setVars($key, $val, true, 'UTF-8');
432  } catch (OdfException $e) {
433  dol_syslog($e->getMessage(), LOG_INFO);
434  } catch (SegmentException $e) {
435  dol_syslog($e->getMessage(), LOG_INFO);
436  }
437  }
438  $listlines->merge();
439  }
440  $odfHandler->mergeSegment($listlines);
441  }
442  } catch (OdfException $e) {
443  $this->error = $e->getMessage();
444  dol_syslog($this->error, LOG_WARNING);
445  return -1;
446  }
447 
448  // Replace labels translated
449  $tmparray = $outputlangs->get_translations_for_substitutions();
450  foreach ($tmparray as $key => $value) {
451  try {
452  $odfHandler->setVars($key, $value, true, 'UTF-8');
453  } catch (OdfException $e) {
454  dol_syslog($e->getMessage(), LOG_INFO);
455  }
456  }
457 
458  // Call the beforeODTSave hook
459 
460  $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
461  $reshook = $hookmanager->executeHooks('beforeODTSave', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
462  */
463  // Write new file
464  if (!empty($conf->global->MAIN_ODT_AS_PDF)) {
465  try {
466  $odfHandler->exportAsAttachedPDF($file);
467  } catch (Exception $e) {
468  $this->error = $e->getMessage();
469  dol_syslog('Error in exportAsAttachedPDF: '.$e->getMessage(), LOG_INFO);
470  return -1;
471  }
472  } else {
473  try {
474  $odfHandler->saveToDisk($file);
475  } catch (Exception $e) {
476  $this->error = $e->getMessage();
477  dol_syslog('Error in saveToDisk: '.$e->getMessage(), LOG_INFO);
478  return -1;
479  }
480  }
481 
482  $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
483  $reshook = $hookmanager->executeHooks('afterODTCreation', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
484 
485  if (!empty($conf->global->MAIN_UMASK)) {
486  @chmod($file, octdec($conf->global->MAIN_UMASK));
487  }
488 
489  $odfHandler = null; // Destroy object
490 
491  $this->result = array('fullpath'=>$file);
492 
493  return 1; // Success
494  } else {
495  $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
496  return -1;
497  }
498  }
499 
500  return -1;
501  }
502 }
make_substitutions
make_substitutions($text, $substitutionarray, $outputlangs=null, $converttextinhtmlifnecessary=0)
Make substitution into a text string, replacing keys with vals from $substitutionarray (oldval=>newva...
Definition: functions.lib.php:7839
db
$conf db
API class for accounts.
Definition: inc.php:41
dol_sanitizeFileName
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
Definition: functions.lib.php:1226
description
print *****$script_file(".$version.") pid cd cd cd description as description
Definition: email_expire_services_to_customers.php:83
dol_print_error
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
Definition: functions.lib.php:4844
img_warning
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
Definition: functions.lib.php:4521
$form
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:142
dol_dir_list
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0)
Scan a directory and return a list of files/directories.
Definition: files.lib.php:60
name
$conf db name
Definition: repair.php:122
doc_generic_mo_odt\info
info($langs)
Return description of a module.
Definition: doc_generic_mo_odt.modules.php:112
dol_print_date
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
Definition: functions.lib.php:2514
img_picto
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
Definition: functions.lib.php:3880
Exception
doc_generic_mo_odt
Class to build documents using ODF templates generator.
Definition: doc_generic_mo_odt.modules.php:41
doc_generic_mo_odt\write_file
write_file($object, $outputlangs, $srctemplatepath, $hidedetails=0, $hidedesc=0, $hideref=0)
Function to build a document on disk using the generic odt module.
Definition: doc_generic_mo_odt.modules.php:210
dol_syslog
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
Definition: functions.lib.php:1603
ModelePDFMo
Parent class for mos models.
Definition: modules_mo.php:39
Form
Class to manage generation of HTML components Only common components must be here.
Definition: html.form.class.php:52
dol_now
dol_now($mode='auto')
Return date for now.
Definition: functions.lib.php:2845
doc_generic_mo_odt\__construct
__construct($db)
Constructor.
Definition: doc_generic_mo_odt.modules.php:66
dol_mkdir
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
Definition: functions.lib.php:6603
type
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition: repair.php:119
HookManager
Class to manage hooks.
Definition: hookmanager.class.php:30
complete_substitutions_array
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...
Definition: functions.lib.php:7961