dolibarr 19.0.3
doc_generic_odt.modules.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2010-2011 Laurent Destailleur <ely@users.sourceforge.net>
3 * Copyright (C) 2016 Charlie Benke <charlie@patas-monkey.com>
4 * Copyright (C) 2018-2019 Frédéric France <frederic.france@netlogic.fr>
5 *
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <https://www.gnu.org/licenses/>.
18 * or see https://www.gnu.org/
19 */
20
27require_once DOL_DOCUMENT_ROOT.'/core/modules/societe/modules_societe.class.php';
28require_once DOL_DOCUMENT_ROOT.'/societe/class/societe.class.php';
29require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
30require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
31require_once DOL_DOCUMENT_ROOT.'/core/lib/doc.lib.php';
32
33
38{
42 public $version = 'dolibarr';
43
44
50 public function __construct($db)
51 {
52 global $langs, $mysoc;
53
54 // Load translation files required by the page
55 $langs->loadLangs(array("main", "companies"));
56
57 $this->db = $db;
58 $this->name = "ODT templates";
59 $this->description = $langs->trans("DocumentModelOdt");
60 $this->scandir = 'COMPANY_ADDON_PDF_ODT_PATH'; // Name of constant that is used to save list of directories to scan
61
62 // Page size for A4 format
63 $this->type = 'odt';
64 $this->page_largeur = 0;
65 $this->page_hauteur = 0;
66 $this->format = array($this->page_largeur, $this->page_hauteur);
67 $this->marge_gauche = 0;
68 $this->marge_droite = 0;
69 $this->marge_haute = 0;
70 $this->marge_basse = 0;
71
72 $this->option_logo = 1; // Display logo
73
74 // Retrieves transmitter
75 $this->emetteur = $mysoc;
76 if (!$this->emetteur->country_code) {
77 $this->emetteur->country_code = substr($langs->defaultlang, -2); // By default, if was not defined
78 }
79 }
80
81
88 public function info($langs)
89 {
90 global $conf, $langs;
91
92 // Load traductions files required by page
93 $langs->loadLangs(array("companies", "errors"));
94
95 $form = new Form($this->db);
96
97 $texte = $this->description.".<br>\n";
98 $texte .= '<!-- form for option of ODT templates -->';
99 $texte .= '<form action="'.$_SERVER["PHP_SELF"].'" method="POST" enctype="multipart/form-data">';
100 $texte .= '<input type="hidden" name="token" value="'.newToken().'">';
101 $texte .= '<input type="hidden" name="page_y" value="">';
102 $texte .= '<input type="hidden" name="action" value="setModuleOptions">';
103 $texte .= '<input type="hidden" name="param1" value="COMPANY_ADDON_PDF_ODT_PATH">';
104 $texte .= '<table class="nobordernopadding centpercent">';
105
106 // List of directories area
107 $texte .= '<tr><td>';
108 $texttitle = $langs->trans("ListOfDirectories");
109 $listofdir = explode(',', preg_replace('/[\r\n]+/', ',', trim($conf->global->COMPANY_ADDON_PDF_ODT_PATH)));
110 $listoffiles = array();
111 foreach ($listofdir as $key => $tmpdir) {
112 $tmpdir = trim($tmpdir);
113 $tmpdir = preg_replace('/DOL_DATA_ROOT/', DOL_DATA_ROOT, $tmpdir);
114 if (!$tmpdir) {
115 unset($listofdir[$key]);
116 continue;
117 }
118 if (!is_dir($tmpdir)) {
119 $texttitle .= img_warning($langs->trans("ErrorDirNotFound", $tmpdir), 0);
120 } else {
121 $tmpfiles = dol_dir_list($tmpdir, 'files', 0, '\.od(s|t)$', '', 'name', SORT_ASC, 0, true); // Disable hook for the moment
122 if (count($tmpfiles)) {
123 $listoffiles = array_merge($listoffiles, $tmpfiles);
124 }
125 }
126 }
127 $texthelp = $langs->trans("ListOfDirectoriesForModelGenODT");
128 $texthelp .= '<br><br><span class="opacitymedium">'.$langs->trans("ExampleOfDirectoriesForModelGen").'</span>';
129 // Add list of substitution keys
130 $texthelp .= '<br>'.$langs->trans("FollowingSubstitutionKeysCanBeUsed").'<br>';
131 $texthelp .= $langs->transnoentitiesnoconv("FullListOnOnlineDocumentation"); // This contains an url, we don't modify it
132
133 $texte .= $form->textwithpicto($texttitle, $texthelp, 1, 'help', '', 1, 3, $this->name);
134 $texte .= '<table><tr><td>';
135 $texte .= '<textarea class="flat" cols="60" name="value1">';
136 $texte .= getDolGlobalString('COMPANY_ADDON_PDF_ODT_PATH');
137 $texte .= '</textarea>';
138 $texte .= '</td>';
139 $texte .= '<td class="center">&nbsp; ';
140 $texte .= '<input type="submit" class="button button-edit reposition smallpaddingimp" name="modify" value="'.dol_escape_htmltag($langs->trans("Modify")).'">';
141 $texte .= '</td>';
142 $texte .= '</tr>';
143 $texte .= '</table>';
144
145 // Scan directories
146 $nbofiles = count($listoffiles);
147 if (getDolGlobalString('COMPANY_ADDON_PDF_ODT_PATH')) {
148 $texte .= $langs->trans("NumberOfModelFilesFound").': <b>';
149 //$texte.=$nbofiles?'<a id="a_'.get_class($this).'" href="#">':'';
150 $texte .= $nbofiles;
151 //$texte.=$nbofiles?'</a>':'';
152 $texte .= '</b>';
153 }
154
155 if ($nbofiles) {
156 $texte .= '<div id="div_'.get_class($this).'" class="hiddenx">';
157 // Show list of found files
158 foreach ($listoffiles as $file) {
159 $texte .= '- '.$file['name'].' &nbsp; <a class="reposition" href="'.DOL_URL_ROOT.'/document.php?modulepart=doctemplates&file=thirdparties/'.urlencode(basename($file['name'])).'">'.img_picto('', 'listlight').'</a>';
160 $texte .= ' &nbsp; <a class="reposition" href="'.$_SERVER["PHP_SELF"].'?modulepart=doctemplates&keyforuploaddir=COMPANY_ADDON_PDF_ODT_PATH&action=deletefile&token='.newToken().'&file='.urlencode(basename($file['name'])).'">'.img_picto('', 'delete').'</a>';
161 $texte .= '<br>';
162 }
163 $texte .= '</div>';
164 }
165 // Add input to upload a new template file.
166 $texte .= '<div>'.$langs->trans("UploadNewTemplate");
167 $maxfilesizearray = getMaxFileSizeArray();
168 $maxmin = $maxfilesizearray['maxmin'];
169 if ($maxmin > 0) {
170 $texte .= '<input type="hidden" name="MAX_FILE_SIZE" value="'.($maxmin * 1024).'">'; // MAX_FILE_SIZE must precede the field type=file
171 }
172 $texte .= ' <input type="file" name="uploadfile">';
173 $texte .= '<input type="hidden" value="COMPANY_ADDON_PDF_ODT_PATH" name="keyforuploaddir">';
174 $texte .= '<input type="submit" class="button smallpaddingimp reposition" value="'.dol_escape_htmltag($langs->trans("Upload")).'" name="upload">';
175 $texte .= '</div>';
176 $texte .= '</td>';
177
178 $texte .= '</tr>';
179
180 $texte .= '</table>';
181 $texte .= '</form>';
182
183 return $texte;
184 }
185
186 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
198 public function write_file($object, $outputlangs, $srctemplatepath, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
199 {
200 // phpcs:enable
201 global $user, $langs, $conf, $mysoc, $hookmanager;
202 global $action;
203
204 if (empty($srctemplatepath)) {
205 dol_syslog("doc_generic_odt::write_file parameter srctemplatepath empty", LOG_WARNING);
206 return -1;
207 }
208
209 // Add odtgeneration hook
210 if (!is_object($hookmanager)) {
211 include_once DOL_DOCUMENT_ROOT.'/core/class/hookmanager.class.php';
212 $hookmanager = new HookManager($this->db);
213 }
214 $hookmanager->initHooks(array('odtgeneration'));
215
216 if (!is_object($outputlangs)) {
217 $outputlangs = $langs;
218 }
219 $sav_charset_output = $outputlangs->charset_output;
220 $outputlangs->charset_output = 'UTF-8';
221
222 // Load translation files required by the page
223 $outputlangs->loadLangs(array("main", "dict", "companies", "projects"));
224
225 if ($conf->societe->multidir_output[$object->entity]) {
226 $dir = $conf->societe->multidir_output[$object->entity];
227 $objectref = dol_sanitizeFileName($object->id);
228 if (!preg_match('/specimen/i', $objectref)) {
229 $dir .= "/".$objectref;
230 }
231
232 if (!file_exists($dir)) {
233 if (dol_mkdir($dir) < 0) {
234 $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
235 return -1;
236 }
237 }
238
239 if (file_exists($dir)) {
240 //print "srctemplatepath=".$srctemplatepath; // Src filename
241 $newfile = basename($srctemplatepath);
242 $newfiletmp = preg_replace('/\.od(s|t)/i', '', $newfile);
243 $newfiletmp = preg_replace('/template_/i', '', $newfiletmp);
244 $newfiletmp = preg_replace('/modele_/i', '', $newfiletmp);
245 // Get extension (ods or odt)
246 $newfileformat = substr($newfile, strrpos($newfile, '.') + 1);
247 if (getDolGlobalString('MAIN_DOC_USE_OBJECT_THIRDPARTY_NAME')) {
248 $newfiletmp = dol_sanitizeFileName(dol_string_nospecial($object->name)) . '-' . $newfiletmp;
249 $newfiletmp = preg_replace('/__+/', '_', $newfiletmp); // Replace repeated _ into one _ (to avoid string with substitution syntax)
250 }
251 if (getDolGlobalString('MAIN_DOC_USE_TIMING')) {
252 $format = getDolGlobalString('MAIN_DOC_USE_TIMING');
253 if ($format == '1') {
254 $format = '%Y%m%d%H%M%S';
255 }
256 $filename = $newfiletmp . '-' . dol_print_date(dol_now(), $format) . '.' . $newfileformat;
257 } else {
258 $filename = $newfiletmp . '.' . $newfileformat;
259 }
260 $file = $dir . '/' . $filename;
261 $object->builddoc_filename = $filename; // For triggers
262 //print "newfileformat=".$newfileformat;
263 //print "newdir=".$dir;
264 //print "newfile=".$newfile;
265 //print "file=".$file;
266 //print "conf->societe->dir_temp=".$conf->societe->dir_temp;
267 //exit;
268
269 dol_mkdir($conf->societe->multidir_temp[$object->entity]);
270 if (!is_writable($conf->societe->multidir_temp[$object->entity])) {
271 $this->error = $langs->transnoentities("ErrorFailedToWriteInTempDirectory", $conf->societe->multidir_temp[$object->entity]);
272 dol_syslog('Error in write_file: ' . $this->error, LOG_ERR);
273 return -1;
274 }
275
276 // Open and load template
277 require_once ODTPHP_PATH.'odf.php';
278 try {
279 $odfHandler = new Odf(
280 $srctemplatepath,
281 array(
282 'PATH_TO_TMP' => $conf->societe->multidir_temp[$object->entity],
283 'ZIP_PROXY' => 'PclZipProxy', // PhpZipProxy or PclZipProxy. Got "bad compression method" error when using PhpZipProxy.
284 'DELIMITER_LEFT' => '{',
285 'DELIMITER_RIGHT' => '}'
286 )
287 );
288 } catch (Exception $e) {
289 $this->error = $e->getMessage();
290 dol_syslog($e->getMessage(), LOG_INFO);
291 return -1;
292 }
293 //print $odfHandler->__toString()."\n";
294
295 // Replace tags of lines for contacts
296 $contact_arrray = array();
297
298 $sql = "SELECT p.rowid";
299 $sql .= " FROM ".MAIN_DB_PREFIX."socpeople as p";
300 $sql .= " WHERE p.fk_soc = ".((int) $object->id);
301
302 $result = $this->db->query($sql);
303 $num = $this->db->num_rows($result);
304
305 if ($num) {
306 require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
307
308 $i = 0;
309 $contactstatic = new Contact($this->db);
310
311 while ($i < $num) {
312 $obj = $this->db->fetch_object($result);
313
314 $contact_arrray[$i] = $obj->rowid;
315 $i++;
316 }
317 }
318 if ((is_array($contact_arrray) && count($contact_arrray) > 0)) {
319 try {
320 $listlines = $odfHandler->setSegment('companycontacts');
321
322 foreach ($contact_arrray as $array_key => $contact_id) {
323 $res_contact = $contactstatic->fetch($contact_id);
324 if ((int) $res_contact > 0) {
325 $tmparray = $this->get_substitutionarray_contact($contactstatic, $outputlangs, 'contact');
326 foreach ($tmparray as $key => $val) {
327 try {
328 $listlines->setVars($key, $val, true, 'UTF-8');
329 } catch (OdfException $e) {
330 dol_syslog($e->getMessage(), LOG_INFO);
331 } catch (SegmentException $e) {
332 dol_syslog($e->getMessage(), LOG_INFO);
333 }
334 }
335 $listlines->merge();
336 } else {
337 $this->error = $contactstatic->error;
338 dol_syslog($this->error, LOG_WARNING);
339 }
340 }
341 $odfHandler->mergeSegment($listlines);
342 } catch (OdfException $e) {
343 $this->error = $e->getMessage();
344 dol_syslog($this->error, LOG_WARNING);
345 //return -1;
346 }
347 }
348
349 // Make substitutions into odt
350 $array_user = $this->get_substitutionarray_user($user, $outputlangs);
351 $array_soc = $this->get_substitutionarray_mysoc($mysoc, $outputlangs);
352 $array_thirdparty = $this->get_substitutionarray_thirdparty($object, $outputlangs);
353 $array_other = $this->get_substitutionarray_other($outputlangs);
354
355 $tmparray = array_merge($array_user, $array_soc, $array_thirdparty, $array_other);
356
357 complete_substitutions_array($tmparray, $outputlangs, $object);
358
359 // Call the ODTSubstitution hook
360 $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
361 $reshook = $hookmanager->executeHooks('ODTSubstitution', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
362
363 // Replace variables into document
364 foreach ($tmparray as $key => $value) {
365 try {
366 if (preg_match('/logo$/', $key)) { // Image
367 if (file_exists($value)) {
368 $odfHandler->setImage($key, $value);
369 } else {
370 $odfHandler->setVars($key, 'ErrorFileNotFound', true, 'UTF-8');
371 }
372 } else { // Text
373 $odfHandler->setVars($key, $value, true, 'UTF-8');
374 }
375 } catch (OdfException $e) {
376 // setVars failed, probably because key not found
377 dol_syslog($e->getMessage(), LOG_INFO);
378 }
379 }
380
381 // Replace labels translated
382 $tmparray = $outputlangs->get_translations_for_substitutions();
383 foreach ($tmparray as $key => $value) {
384 try {
385 $odfHandler->setVars($key, $value, true, 'UTF-8');
386 } catch (OdfException $e) {
387 dol_syslog($e->getMessage(), LOG_INFO);
388 }
389 }
390
391 // Call the beforeODTSave hook
392 $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
393 $reshook = $hookmanager->executeHooks('beforeODTSave', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
394
395 // Write new file
396 if (getDolGlobalString('MAIN_ODT_AS_PDF')) {
397 try {
398 $odfHandler->exportAsAttachedPDF($file);
399 } catch (Exception $e) {
400 $this->error = $e->getMessage();
401 dol_syslog($e->getMessage(), LOG_INFO);
402 return -1;
403 }
404 } else {
405 try {
406 $odfHandler->creator = $user->getFullName($outputlangs);
407 $odfHandler->title = $object->builddoc_filename;
408 $odfHandler->subject = $object->builddoc_filename;
409
410 if (getDolGlobalString('ODT_ADD_DOLIBARR_ID')) {
411 $odfHandler->userdefined['dol_id'] = $object->id;
412 $odfHandler->userdefined['dol_element'] = $object->element;
413 }
414
415 $odfHandler->saveToDisk($file);
416 } catch (Exception $e) {
417 $this->error = $e->getMessage();
418 dol_syslog($e->getMessage(), LOG_INFO);
419 return -1;
420 }
421 }
422 $parameters = array('odfHandler'=>&$odfHandler, 'file'=>$file, 'object'=>$object, 'outputlangs'=>$outputlangs, 'substitutionarray'=>&$tmparray);
423 $reshook = $hookmanager->executeHooks('afterODTCreation', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
424
425 dolChmod($file);
426
427 $odfHandler = null; // Destroy object
428
429 $this->result = array('fullpath'=>$file);
430
431 return 1; // Success
432 } else {
433 $this->error = $langs->transnoentities("ErrorCanNotCreateDir", $dir);
434 return -1;
435 }
436 }
437
438 $this->error = 'UnknownError';
439 return -1;
440 }
441}
get_substitutionarray_mysoc($mysoc, $outputlangs)
Define array with couple substitution key => substitution value.
get_substitutionarray_contact($object, $outputlangs, $array_key='object')
Define array with couple substitution key => substitution value.
get_substitutionarray_other($outputlangs)
Define array with couple substitution key => substitution value.
get_substitutionarray_thirdparty($object, $outputlangs, $array_key='company')
Define array with couple substitution key => substitution value For example {company_name}...
get_substitutionarray_user($user, $outputlangs)
Define array with couple substitution key => substitution value.
Class to manage generation of HTML components Only common components must be here.
Class to manage hooks.
Parent class for third parties models of doc generators.
Class to build documents using ODF templates generator.
__construct($db)
Constructor.
write_file($object, $outputlangs, $srctemplatepath, $hidedetails=0, $hidedesc=0, $hideref=0)
Function to build a document on disk using the generic odt module.
info($langs)
Return description of a module.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition files.lib.php:62
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
dol_string_nospecial($str, $newstr='_', $badcharstoreplace='', $badcharstoremove='', $keepspaces=0)
Clean a string from all punctuation characters to use it as a ref or login.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dolChmod($filepath, $newmask='')
Change mod of a file.
dol_now($mode='auto')
Return date for now.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
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...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition repair.php:121
$conf db name
Only used if Module[ID]Name translation string is not found.
Definition repair.php:124
getMaxFileSizeArray()
Return the max allowed for file upload.
Contact()
Old copy.
Definition index.php:572