dolibarr 25.0.0-alpha
fichinter.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2002-2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2014 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2011-2020 Juanjo Menent <jmenent@2byte.es>
6 * Copyright (C) 2015 Marcos García <marcosgdf@gmail.com>
7 * Copyright (C) 2015-2026 Charlene Benke <charlene@patas-monkey.com>
8 * Copyright (C) 2018 Nicolas ZABOURI <info@inovea-conseil.com>
9 * Copyright (C) 2018-2026 Frédéric France <frederic.france@free.fr>
10 * Copyright (C) 2023-2026 William Mead <william@m34d.com>
11 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
12 *
13 * This program is free software; you can redistribute it and/or modify
14 * it under the terms of the GNU General Public License as published by
15 * the Free Software Foundation; either version 3 of the License, or
16 * (at your option) any later version.
17 *
18 * This program is distributed in the hope that it will be useful,
19 * but WITHOUT ANY WARRANTY; without even the implied warranty of
20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 * GNU General Public License for more details.
22 *
23 * You should have received a copy of the GNU General Public License
24 * along with this program. If not, see <https://www.gnu.org/licenses/>.
25 */
26
32require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
33require_once DOL_DOCUMENT_ROOT.'/fichinter/class/fichinterligne.class.php';
34require_once DOL_DOCUMENT_ROOT.'/core/class/commonsignedobject.class.php';
35require_once DOL_DOCUMENT_ROOT.'/subtotals/class/commonsubtotal.class.php';
36
37
44{
45 use CommonSignedObject;
46 use CommonSubtotal;
47
52 public $TRIGGER_PREFIX = 'FICHINTER';
53
54 public $fields = array(
55 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 10),
56 'fk_soc' => array('type' => 'integer:Societe:societe/class/societe.class.php', 'label' => 'ThirdParty', 'enabled' => 'isModEnabled("societe")', 'visible' => -1, 'notnull' => 1, 'position' => 15),
57 'fk_projet' => array('type' => 'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)', 'label' => 'Project', 'enabled' => 'isModEnabled("project")', 'visible' => -1, 'position' => 20),
58 'fk_contrat' => array('type' => 'integer:Contrat:contrat/class/contrat.class.php', 'label' => 'Contract', 'enabled' => 'isModEnabled("contract")', 'visible' => -1, 'position' => 25),
59 'ref' => array('type' => 'varchar(30)', 'label' => 'Ref', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'showoncombobox' => 1, 'position' => 30),
60 'ref_ext' => array('type' => 'varchar(255)', 'label' => 'RefExt', 'enabled' => 1, 'visible' => 0, 'position' => 35),
61 'ref_client' => array('type' => 'varchar(255)', 'label' => 'RefCustomer', 'enabled' => 1, 'visible' => -1, 'position' => 36),
62 'entity' => array('type' => 'integer', 'label' => 'Entity', 'default' => '1', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 40, 'index' => 1),
63 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 45),
64 'datec' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'visible' => -1, 'position' => 50),
65 'date_valid' => array('type' => 'datetime', 'label' => 'DateValidation', 'enabled' => 1, 'visible' => -1, 'position' => 55),
66 'datei' => array('type' => 'date', 'label' => 'Datei', 'enabled' => 1, 'visible' => -1, 'position' => 60),
67 'fk_user_author' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'visible' => -1, 'position' => 65),
68 'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'visible' => -2, 'notnull' => -1, 'position' => 70),
69 'fk_user_valid' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'enabled' => 1, 'visible' => -1, 'position' => 75),
70 'dateo' => array('type' => 'date', 'label' => 'Dateo', 'enabled' => 1, 'visible' => -1, 'position' => 85),
71 'datee' => array('type' => 'date', 'label' => 'Datee', 'enabled' => 1, 'visible' => -1, 'position' => 90),
72 'datet' => array('type' => 'date', 'label' => 'Datet', 'enabled' => 1, 'visible' => -1, 'position' => 95),
73 'duree' => array('type' => 'integer', 'label' => 'Duree', 'enabled' => 1, 'visible' => -1, 'position' => 100),
74 'signed_status' => array('type' => 'smallint(6)', 'label' => 'SignedStatus', 'enabled' => 1, 'visible' => -1, 'position' => 101, 'arrayofkeyval' => array(0 => 'NoSignature', 1 => 'SignedSender', 2 => 'SignedReceiver', 3 => 'SignedReceiverOnline', 9 => 'SignedAll')),
75 'description' => array('type' => 'html', 'label' => 'Description', 'enabled' => 1, 'visible' => -1, 'position' => 105, 'showoncombobox' => 2),
76 'note_private' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'visible' => 0, 'position' => 110),
77 'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 115),
78 'model_pdf' => array('type' => 'varchar(255)', 'label' => 'PDFTemplate', 'enabled' => 1, 'visible' => 0, 'position' => 120),
79 'last_main_doc' => array('type' => 'varchar(255)', 'label' => 'LastMainDoc', 'enabled' => 1, 'visible' => -1, 'position' => 125),
80 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -2, 'position' => 130),
81 'extraparams' => array('type' => 'varchar(255)', 'label' => 'Extraparams', 'enabled' => 1, 'visible' => -1, 'position' => 135),
82 'fk_statut' => array('type' => 'integer', 'label' => 'Status', 'enabled' => 1, 'visible' => -1, 'position' => 500),
83 );
84
88 public $element = 'fichinter';
89
93 public $fk_element = 'fk_fichinter';
94
98 public $table_element = 'fichinter';
99
103 public $table_element_line = 'fichinterdet';
104
108 public $class_element_line = 'FichinterLigne';
109
113 public $picto = 'intervention';
114
118 protected $table_ref_field = 'ref';
119
123 public $socid;
124
128 public $author;
129
133 public $datec;
134
138 public $datev;
142 public $dateo;
146 public $datee;
147
151 public $datet;
152
158 public $datem;
159
163 public $duration;
164
169 public $statut = 0; // 0=draft, 1=validated, 2=invoiced, 3=Terminate
170
174 public $status = 0; // 0=draft, 1=validated, 2=invoiced, 3=Terminate
175
179 public $description;
180
184 public $fk_contrat = 0;
185
189 public $fk_project;
190
195 public $ref_client;
196
200 public $extraparams = array();
201
205 public $lines = array();
206
210 const STATUS_DRAFT = 0;
211
216
220 const STATUS_BILLED = 2;
221
225 const STATUS_CLOSED = 3;
226
231
237 public $date_delivery;
238
243 public $delivery_date_receipt;
244
249 public $user_author_id;
250
251
257 public function __construct($db)
258 {
259 $this->db = $db;
260 }
261
267 public function loadStateBoard()
268 {
269 global $user;
270
271 $this->nb = array();
272 $clause = "WHERE";
273
274 $sql = "SELECT count(fi.rowid) as nb";
275 $sql .= " FROM ".MAIN_DB_PREFIX."fichinter as fi";
276 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON fi.fk_soc = s.rowid";
277 if (!$user->hasRight('societe', 'client', 'voir')) {
278 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc";
279 $sql .= " WHERE sc.fk_user = ".((int) $user->id);
280 $clause = "AND";
281 }
282 $sql .= " ".$clause." fi.entity IN (".getEntity('intervention').")";
283
284 $resql = $this->db->query($sql);
285 if ($resql) {
286 while ($obj = $this->db->fetch_object($resql)) {
287 $this->nb["interventions"] = $obj->nb;
288 }
289 $this->db->free($resql);
290 return 1;
291 } else {
292 dol_print_error($this->db);
293 $this->error = $this->db->error();
294 return -1;
295 }
296 }
297
305 public function create($user, $notrigger = 0)
306 {
307 $error = 0;
308
309 dol_syslog(get_class($this)."::create ref=".$this->ref);
310
311 // Check parameters
312 if (!empty($this->ref)) { // We check that ref is not already used
313 $result = self::isExistingObject($this->element, 0, $this->ref); // Check ref is not yet used
314 if ($result > 0) {
315 $this->error = 'ErrorRefAlreadyExists';
316 dol_syslog(get_class($this)."::create ".$this->error, LOG_WARNING);
317 $this->db->rollback();
318 return -1;
319 }
320 }
321 if (!is_numeric($this->duration)) {
322 $this->duration = 0;
323 }
324 if (!empty($this->ref_client)) {
325 $this->ref_client = trim($this->ref_client);
326 }
327
328 if ($this->socid <= 0) {
329 $this->error = 'ErrorFicheinterCompanyDoesNotExist';
330 dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
331 return -1;
332 }
333 $this->entity = setEntity($this);
334
335 $soc = new Societe($this->db);
336 $result = $soc->fetch($this->socid);
337
338 $now = dol_now();
339
340 $this->db->begin();
341
342 $sql = "INSERT INTO ".MAIN_DB_PREFIX."fichinter (";
343 $sql .= "fk_soc";
344 $sql .= ", datec";
345 $sql .= ", ref";
346 $sql .= ", ref_client";
347 $sql .= ", entity";
348 $sql .= ", fk_user_author";
349 $sql .= ", fk_user_modif";
350 $sql .= ", description";
351 $sql .= ", model_pdf";
352 $sql .= ", fk_projet";
353 $sql .= ", fk_contrat";
354 $sql .= ", fk_statut";
355 $sql .= ", signed_status";
356 $sql .= ", note_private";
357 $sql .= ", note_public";
358 $sql .= ") ";
359 $sql .= " VALUES (";
360 $sql .= ((int) $this->socid);
361 $sql .= ", '".$this->db->idate($now)."'";
362 $sql .= ", '".$this->db->escape($this->ref)."'";
363 $sql .= ", ".($this->ref_client ? "'".$this->db->escape($this->ref_client)."'" : "null");
364 $sql .= ", ".((int) $this->entity);
365 $sql .= ", ".((int) $user->id);
366 $sql .= ", ".((int) $user->id);
367 $sql .= ", ".($this->description ? "'".$this->db->escape($this->description)."'" : "null");
368 $sql .= ", '".$this->db->escape($this->model_pdf)."'";
369 $sql .= ", ".((int) $this->fk_project > 0 ? ((int) $this->fk_project) : 0);
370 $sql .= ", ".((int) $this->fk_contrat > 0 ? ((int) $this->fk_contrat) : 0);
371 $sql .= ", ".((int) $this->status);
372 $sql .= ", ".((int) $this->signed_status);
373 $sql .= ", ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : "null");
374 $sql .= ", ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : "null");
375 $sql .= ")";
376
377 dol_syslog(get_class($this)."::create", LOG_DEBUG);
378 $result = $this->db->query($sql);
379 if ($result) {
380 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."fichinter");
381
382 if ($this->id) {
383 $this->ref = '(PROV'.$this->id.')';
384 $sql = 'UPDATE '.MAIN_DB_PREFIX."fichinter SET ref='".$this->db->escape($this->ref)."' WHERE rowid=".((int) $this->id);
385
386 dol_syslog(get_class($this)."::create", LOG_DEBUG);
387 $resql = $this->db->query($sql);
388 if (!$resql) {
389 $error++;
390 }
391 }
392
393 if (!$error) {
394 $result = $this->insertExtraFields();
395 if ($result < 0) {
396 $error++;
397 }
398 }
399
400 // Add linked object
401 if (!$error && $this->origin && $this->origin_id) {
402 $ret = $this->add_object_linked();
403 if (!$ret) {
404 dol_print_error($this->db);
405 }
406 }
407
408
409 if (!$error && !$notrigger) {
410 // Call trigger
411 $result = $this->call_trigger('FICHINTER_CREATE', $user);
412 if ($result < 0) {
413 $error++;
414 }
415 // End call triggers
416 }
417
418 if (!$error) {
419 $this->db->commit();
420 return $this->id;
421 } else {
422 $this->db->rollback();
423 $this->error = implode(',', $this->errors);
424 dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
425 return -1;
426 }
427 } else {
428 $this->error = $this->db->error();
429 $this->db->rollback();
430 return -1;
431 }
432 }
433
441 public function update($user, $notrigger = 0)
442 {
443 global $conf;
444
445 if (!is_numeric($this->duration)) {
446 $this->duration = 0;
447 }
448 if (!dol_strlen((string) $this->fk_project)) {
449 $this->fk_project = 0;
450 }
451 if (!empty($this->ref_client)) {
452 $this->ref_client = trim($this->ref_client);
453 }
454
455 $error = 0;
456
457 $this->db->begin();
458
459 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter SET ";
460 $sql .= "description = '".$this->db->escape($this->description)."'";
461 $sql .= ", duree = ".((int) $this->duration);
462 $sql .= ", ref_client = ".($this->ref_client ? "'".$this->db->escape($this->ref_client)."'" : "null");
463 if ((int) $this->fk_project > 0) {
464 $sql .= ", fk_projet = ".((int) $this->fk_project);
465 }
466 if (isset($this->datec)) {
467 $sql .= ", datec = ".($this->datec ? "'".$this->db->idate($this->datec)."'" : "null");
468 }
469 if (isset($this->datev)) {
470 $sql .= ", date_valid = ".($this->datev ? "'".$this->db->idate($this->datev)."'" : "null");
471 }
472 if (isset($this->datet)) {
473 $sql .= ", datet = ".($this->datet ? "'".$this->db->idate($this->datet)."'" : "null");
474 }
475 $sql .= ", note_private = ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : "null");
476 $sql .= ", note_public = ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : "null");
477 $sql .= ", fk_user_modif = ".((int) $user->id);
478 $sql .= " WHERE rowid = ".((int) $this->id);
479
480 dol_syslog(get_class($this)."::update", LOG_DEBUG);
481 if ($this->db->query($sql)) {
482 $result = $this->insertExtraFields();
483 if ($result < 0) {
484 $error++;
485 }
486
487 if (!$error && !$notrigger) {
488 // Call trigger
489 $result = $this->call_trigger('FICHINTER_MODIFY', $user);
490 if ($result < 0) {
491 $error++;
492 $this->db->rollback();
493 return -1;
494 }
495 // End call triggers
496 }
497
498 $this->db->commit();
499 return 1;
500 } else {
501 $this->error = $this->db->error();
502 $this->db->rollback();
503 return -1;
504 }
505 }
506
515 public function fetch($rowid, $ref = '', $ref_ext = '')
516 {
517 $sql = "SELECT f.rowid, f.ref, f.ref_client, f.description, f.fk_soc, f.fk_statut as status, f.signed_status,";
518 $sql .= " f.datec, f.dateo, f.datee, f.datet,";
519 $sql .= " f.date_valid as datev,";
520 $sql .= " f.tms as datem,";
521 $sql .= " f.fk_user_author, f.fk_user_modif,";
522 $sql .= " f.duree, f.fk_projet as fk_project, f.note_public, f.note_private, f.model_pdf, f.last_main_doc, f.extraparams, fk_contrat, f.entity as entity";
523 $sql .= " FROM ".MAIN_DB_PREFIX."fichinter as f";
524 $sql .= " WHERE f.entity IN (".getEntity('intervention').")";
525 if ($ref) {
526 $sql .= " AND f.ref = '".$this->db->escape($ref)."'";
527 } elseif ($ref_ext) {
528 $sql .= " AND f.ref_ext = '".$this->db->escape($ref_ext)."'";
529 } else {
530 $sql .= " AND f.rowid = ".((int) $rowid);
531 }
532
533 $resql = $this->db->query($sql);
534 if ($resql) {
535 if ($this->db->num_rows($resql)) {
536 $obj = $this->db->fetch_object($resql);
537
538 $this->id = $obj->rowid;
539 $this->ref = $obj->ref;
540 $this->ref_client = $obj->ref_client;
541 $this->description = $obj->description;
542 $this->socid = $obj->fk_soc;
543 $this->status = $obj->status;
544 $this->statut = $obj->status; // deprecated
545 $this->signed_status = $obj->signed_status;
546 $this->duration = $obj->duree;
547 $this->datec = $this->db->jdate($obj->datec);
548 $this->dateo = $this->db->jdate($obj->dateo);
549 $this->datee = $this->db->jdate($obj->datee);
550 $this->datet = $this->db->jdate($obj->datet);
551 $this->datev = $this->db->jdate($obj->datev);
552 $this->datem = $this->db->jdate($obj->datem);
553 $this->fk_project = $obj->fk_project;
554 $this->note_public = $obj->note_public;
555 $this->note_private = $obj->note_private;
556 $this->model_pdf = $obj->model_pdf;
557 $this->fk_contrat = $obj->fk_contrat;
558 $this->entity = $obj->entity;
559
560 $this->user_author_id = $this->user_creation_id = $obj->fk_user_author;
561 $this->user_modification_id = $obj->fk_user_modif;
562
563 $this->extraparams = is_null($obj->extraparams) ? [] : (array) json_decode($obj->extraparams, true);
564
565 $this->last_main_doc = $obj->last_main_doc;
566
567 // Retrieve extrafields
568 $this->fetch_optionals();
569
570 /*
571 * Lines
572 */
573 $result = $this->fetch_lines();
574 if ($result < 0) {
575 return -3;
576 }
577 $this->db->free($resql);
578 return 1;
579 }
580
581 return 0;
582 } else {
583 $this->error = $this->db->lasterror();
584 return -1;
585 }
586 }
587
594 public function setDraft($user)
595 {
596 $error = 0;
597
598 // Protection
599 if ($this->status <= self::STATUS_DRAFT) {
600 return 0;
601 }
602
603 dol_syslog(get_class($this)."::setDraft", LOG_DEBUG);
604
605 $this->oldcopy = dol_clone($this, 2);
606
607 $this->db->begin();
608
609 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter";
610 $sql .= " SET fk_statut = ".self::STATUS_DRAFT;
611 $sql .= " WHERE rowid = ".((int) $this->id);
612
613 $resql = $this->db->query($sql);
614 if ($resql) {
615 // Call trigger
616 $result = $this->call_trigger('FICHINTER_UNVALIDATE', $user);
617 if ($result < 0) {
618 $error++;
619 }
620
621 if (!$error) {
622 $this->status = self::STATUS_DRAFT;
623 $this->statut = self::STATUS_DRAFT; // deprecated
624 $this->db->commit();
625 return 1;
626 } else {
627 $this->db->rollback();
628 return -1;
629 }
630 } else {
631 $this->db->rollback();
632 $this->error = $this->db->lasterror();
633 return -1;
634 }
635 }
636
644 public function setValid($user, $notrigger = 0)
645 {
646 global $conf;
647 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
648
649 $error = 0;
650
651 if ($this->status != self::STATUS_VALIDATED) {
652 $this->db->begin();
653
654 $now = dol_now();
655
656 // Define new ref
657 if ((preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref))) { // empty should not happened, but when it occurs, the test save life
658 if (empty($this->thirdparty)) { // Not loaded when validated by the API or on closing a ticket
659 $this->fetch_thirdparty();
660 }
661 $num = $this->getNextNumRef($this->thirdparty);
662 } else {
663 $num = (string) $this->ref;
664 }
665 $this->newref = dol_sanitizeFileName($num);
666
667 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter";
668 $sql .= " SET fk_statut = 1";
669 $sql .= ", ref = '".$this->db->escape($num)."'";
670 $sql .= ", date_valid = '".$this->db->idate($now)."'";
671 $sql .= ", fk_user_valid = ".($user->id > 0 ? (int) $user->id : "null");
672 $sql .= " WHERE rowid = ".((int) $this->id);
673 $sql .= " AND entity IN (".getEntity('intervention').")";
674
675 $sql .= " AND fk_statut = 0";
676
677 dol_syslog(get_class($this)."::setValid", LOG_DEBUG);
678 $resql = $this->db->query($sql);
679 if (!$resql) {
680 dol_print_error($this->db);
681 $error++;
682 }
683
684 if (!$error && !$notrigger) {
685 // Call trigger
686 $result = $this->call_trigger('FICHINTER_VALIDATE', $user);
687 if ($result < 0) {
688 $error++;
689 }
690 // End call triggers
691 }
692
693 if (!$error) {
694 $this->oldref = $this->ref;
695
696 // Rename directory if dir was a temporary ref
697 if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
698 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
699
700 // Now we rename also files into index
701 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filename = CONCAT('".$this->db->escape($this->newref)."', SUBSTR(filename, ".(strlen($this->ref) + 1).")), filepath = 'ficheinter/".$this->db->escape($this->newref)."'";
702 $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'ficheinter/".$this->db->escape($this->ref)."' and entity = ".((int) $this->entity);
703 $resql = $this->db->query($sql);
704 if (!$resql) {
705 $error++;
706 $this->error = $this->db->lasterror();
707 }
708 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'ficheinter/".$this->db->escape($this->newref)."'";
709 $sql .= " WHERE filepath = 'ficheinter/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
710 $resql = $this->db->query($sql);
711 if (!$resql) {
712 $error++;
713 $this->error = $this->db->lasterror();
714 }
715
716 // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
717 $oldref = dol_sanitizeFileName($this->ref);
718 $newref = dol_sanitizeFileName($num);
719 $dirsource = $conf->ficheinter->dir_output.'/'.$oldref;
720 $dirdest = $conf->ficheinter->dir_output.'/'.$newref;
721 if (!$error && file_exists($dirsource)) {
722 dol_syslog(get_class($this)."::setValid rename dir ".$dirsource." into ".$dirdest);
723
724 if (@rename($dirsource, $dirdest)) {
725 dol_syslog("Rename ok");
726 // Rename docs starting with $oldref with $newref
727 $listoffiles = dol_dir_list($conf->ficheinter->dir_output.'/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
728 foreach ($listoffiles as $fileentry) {
729 $dirsource = $fileentry['name'];
730 $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
731 $dirsource = $fileentry['path'].'/'.$dirsource;
732 $dirdest = $fileentry['path'].'/'.$dirdest;
733 @rename($dirsource, $dirdest);
734 }
735 }
736 }
737 }
738 }
739
740 // Set new ref and define current status
741 if (!$error) {
742 $this->ref = $num;
744 $this->statut = self::STATUS_VALIDATED; // deprecated
745 $this->date_validation = $now;
746 $this->db->commit();
747 return 1;
748 } else {
749 $this->db->rollback();
750 dol_syslog(get_class($this)."::setValid ".$this->error, LOG_ERR);
751 return -1;
752 }
753 }
754
755 return 0;
756 }
757
765 public function setCanceled($user, $notrigger = 0)
766 {
767 $error = 0;
768
769 if ($this->status == self::STATUS_CANCELED) {
770 return 0;
771 }
772
773 $this->db->begin();
774
775 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter";
776 $sql .= " SET fk_statut = ".self::STATUS_CANCELED.",";
777 $sql .= " fk_user_modif = ".((int) $user->id);
778 $sql .= " WHERE rowid = ".((int) $this->id);
779 $sql .= " AND fk_statut = ".self::STATUS_VALIDATED;
780 $sql .= " AND entity IN (".getEntity('intervention').")";
781
782 dol_syslog(get_class($this)."::setCanceled", LOG_DEBUG);
783 if ($this->db->query($sql)) {
784 if (!$notrigger) {
785 // Call trigger
786 $result = $this->call_trigger('FICHINTER_CANCEL', $user);
787 if ($result < 0) {
788 $error++;
789 }
790 // End call triggers
791 }
792
793 if (!$error) {
795 $this->statut = self::STATUS_CANCELED; // deprecated
796 $this->db->commit();
797 return 1;
798 } else {
799 foreach ($this->errors as $errmsg) {
800 dol_syslog(get_class($this)."::setCanceled ".$errmsg, LOG_ERR);
801 $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
802 }
803 $this->db->rollback();
804 return -1 * $error;
805 }
806 } else {
807 $this->error = $this->db->error();
808 $this->db->rollback();
809 return -1;
810 }
811 }
812
813
822 public function setReopen($user, $notrigger = 0)
823 {
824 // phpcs:enable
825 $error = 0;
826
827 if ($this->statut != self::STATUS_CANCELED && $this->statut != self::STATUS_CLOSED) {
828 dol_syslog(get_class($this)."::setReopen intervention has not status closed or canceled", LOG_WARNING);
829 return 0;
830 }
831
832 $this->db->begin();
833
834 $sql = 'UPDATE '.MAIN_DB_PREFIX.'fichinter';
835 $sql .= ' SET fk_statut='.self::STATUS_VALIDATED;
836 $sql .= ", fk_user_modif = ".((int) $user->id);
837 $sql .= " WHERE rowid = ".((int) $this->id);
838
839 dol_syslog(get_class($this)."::setReopen", LOG_DEBUG);
840 $resql = $this->db->query($sql);
841 if ($resql) {
842 if (!$notrigger) {
843 // Call trigger
844 $result = $this->call_trigger('FICHINTER_REOPEN', $user);
845 if ($result < 0) {
846 $error++;
847 }
848 // End call triggers
849 }
850 } else {
851 $error++;
852 $this->error = $this->db->lasterror();
853 dol_print_error($this->db);
854 }
855
856 if (!$error) {
858 $this->statut = self::STATUS_VALIDATED; // deprecated
859 $this->billed = 0;
860
861 $this->db->commit();
862 return 1;
863 } else {
864 foreach ($this->errors as $errmsg) {
865 dol_syslog(get_class($this)."::setReopen ".$errmsg, LOG_ERR);
866 $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
867 }
868 $this->db->rollback();
869 return -1 * $error;
870 }
871 }
872
880 public function setClose($user, $notrigger = 0)
881 {
882 global $conf;
883
884 $error = 0;
885
886 if ($this->status == self::STATUS_CLOSED) {
887 return 0;
888 } else {
889 $this->db->begin();
890
891 $now = dol_now();
892
893 $sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element;
894 $sql .= ' SET fk_statut = ' . self::STATUS_CLOSED . ',';
895 $sql .= " datet = '" . $this->db->idate($now) . "',";
896 $sql .= " fk_user_modif = " . ((int) $user->id);
897 $sql .= " WHERE rowid = " . ((int) $this->id);
898 $sql .= " AND fk_statut > " . self::STATUS_DRAFT;
899 $sql .= " AND entity IN (".getEntity('intervention').")";
900
901 if ($this->db->query($sql)) {
902 if (!$notrigger) {
903 // Call trigger
904 $result = $this->call_trigger('FICHINTER_CLOSE', $user);
905 if ($result < 0) {
906 $error++;
907 }
908 // End call triggers
909 }
910
911 if (!$error) {
913 $this->statut = self::STATUS_CLOSED; // deprecated
914 $this->db->commit();
915 return 1;
916 } else {
917 $this->db->rollback();
918 return -1;
919 }
920 } else {
921 $this->error = $this->db->lasterror();
922 $this->db->rollback();
923 return -1;
924 }
925 }
926 }
927
933 public function getAmount()
934 {
935 $amount = 0;
936
937 $this->author = new User($this->db);
938 $this->author->fetch($this->user_creation_id);
939
940 $thm = $this->author->thm;
941
942 foreach ($this->lines as $line) {
943 $amount += ($line->duration / 60 / 60 * (float) $thm);
944 }
945
946 return (float) price2num($amount, 'MT');
947 }
948
949
961 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
962 {
963 global $conf;
964
965 $outputlangs->load("interventions");
966
967 if (!dol_strlen($modele)) {
968 $modele = 'soleil';
969
970 if (!empty($this->model_pdf)) {
971 $modele = $this->model_pdf;
972 } elseif (getDolGlobalString('FICHEINTER_ADDON_PDF')) {
973 $modele = getDolGlobalString('FICHEINTER_ADDON_PDF');
974 }
975 }
976
977 $modelpath = "core/modules/fichinter/doc/";
978
979 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
980 }
981
988 public function getLibStatut($mode = 0)
989 {
990 return $this->LibStatut((isset($this->statut) ? $this->statut : $this->status), $mode);
991 }
992
993 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1001 public function LibStatut($status, $mode = 0)
1002 {
1003 // phpcs:enable
1004 global $langs;
1005 // Init/load array of translation of status
1006 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
1007 $langs->load("interventions");
1008 $langs->load("propal");
1009
1010 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
1011 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('Validated');
1012 $this->labelStatus[self::STATUS_BILLED] = $langs->transnoentitiesnoconv('StatusInterInvoiced');
1013 $this->labelStatus[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv('Done');
1014 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
1015 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
1016 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('Validated');
1017 $this->labelStatusShort[self::STATUS_BILLED] = $langs->transnoentitiesnoconv('StatusInterInvoiced');
1018 $this->labelStatusShort[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv('Done');
1019 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
1020 }
1021
1022 $statuscode = 'status'.$status;
1023 if ($status == self::STATUS_BILLED || $status == self::STATUS_CLOSED) {
1024 $statuscode = 'status6';
1025 }
1026
1027 $signed_label = ' (' . $this->getLibSignedStatus() . ')';
1028 $status_label = $this->signed_status ? $this->labelStatus[$status] . $signed_label : $this->labelStatus[$status];
1029 $status_label_short = $this->signed_status ? $this->labelStatusShort[$status] . $signed_label : $this->labelStatusShort[$status];
1030
1031 return dolGetStatus($status_label, $status_label_short, '', $statuscode, $mode);
1032 }
1033
1040 public function getTooltipContentArray($params)
1041 {
1042 global $langs;
1043
1044 $langs->load('interventions');
1045
1046 $datas = [];
1047 $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("ShowIntervention").'</u>';
1048 $datas['picto'] .= ' '.$this->getLibStatut(5);
1049 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
1050
1051 return $datas;
1052 }
1053
1064 public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $save_lastsearch_value = -1, $morecss = '')
1065 {
1066 global $conf, $langs, $hookmanager;
1067
1068 if (!empty($conf->dol_no_mouse_hover)) {
1069 $notooltip = 1; // Force disable tooltips
1070 }
1071
1072 $result = '';
1073 $params = [
1074 'id' => $this->id,
1075 'objecttype' => $this->element,
1076 'option' => $option,
1077 ];
1078 $classfortooltip = 'classfortooltip';
1079 $dataparams = '';
1080 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
1081 $classfortooltip = 'classforajaxtooltip';
1082 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
1083 $label = '';
1084 } else {
1085 $label = implode($this->getTooltipContentArray($params));
1086 }
1087
1088 $url = DOL_URL_ROOT.'/fichinter/card.php?id='.$this->id;
1089
1090 if ($option !== 'nolink') {
1091 // Add param to save lastsearch_values or not
1092 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1093 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
1094 $add_save_lastsearch_values = 1;
1095 }
1096 if ($add_save_lastsearch_values) {
1097 $url .= '&save_lastsearch_values=1';
1098 }
1099 }
1100
1101 $linkclose = '';
1102 if (empty($notooltip)) {
1103 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
1104 $label = $langs->trans("ShowIntervention");
1105 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
1106 }
1107 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
1108 $linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
1109 } else {
1110 $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
1111 }
1112
1113 if ($option == 'nolink') {
1114 $linkstart = '<span';
1115 } else {
1116 $linkstart = '<a href="'.$url.'"';
1117 }
1118 $linkstart .= $linkclose.'>';
1119 if ($option == 'nolink') {
1120 $linkend = '</span>';
1121 } else {
1122 $linkend = '</a>';
1123 }
1124
1125 $result .= $linkstart;
1126 if ($withpicto) {
1127 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'"'), 0, 0, $notooltip ? 0 : 1);
1128 }
1129
1130 if ($withpicto != 2) {
1131 $result .= $this->ref;
1132 }
1133
1134 $result .= $linkend;
1135
1136 global $action;
1137 $hookmanager->initHooks(array('interventiondao'));
1138 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
1139 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1140 if ($reshook > 0) {
1141 $result = $hookmanager->resPrint;
1142 } else {
1143 $result .= $hookmanager->resPrint;
1144 }
1145
1146 return $result;
1147 }
1148
1149
1157 public function getNextNumRef($soc)
1158 {
1159 global $conf, $db, $langs;
1160 $langs->load("interventions");
1161
1162 if (getDolGlobalString('FICHEINTER_ADDON')) {
1163 $mybool = false;
1164
1165 $file = "mod_" . getDolGlobalString('FICHEINTER_ADDON').".php";
1166 $classname = "mod_" . getDolGlobalString('FICHEINTER_ADDON');
1167
1168 // Include file with class
1169 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
1170
1171 foreach ($dirmodels as $reldir) {
1172 $dir = dol_buildpath($reldir."core/modules/fichinter/");
1173
1174 // Load file with numbering class (if found)
1175 $mybool = ((bool) @include_once $dir.$file) || $mybool;
1176 }
1177
1178 if (!$mybool) {
1179 dol_print_error(null, "Failed to include file ".$file);
1180 return '';
1181 }
1182
1183 $obj = new $classname();
1184 '@phan-var-force ModeleNumRefFicheinter $obj';
1185 $numref = "";
1186 $numref = $obj->getNextValue($soc, $this);
1187
1188 if ($numref != "") {
1189 return $numref;
1190 } else {
1191 dol_print_error($db, "Fichinter::getNextNumRef ".$obj->error);
1192 return "";
1193 }
1194 } else {
1195 $langs->load("errors");
1196 print $langs->trans("Error")." ".$langs->trans("Error_FICHEINTER_ADDON_NotDefined");
1197 return "";
1198 }
1199 }
1200
1207 public function info($id)
1208 {
1209 $sql = "SELECT f.rowid,";
1210 $sql .= " f.datec,";
1211 $sql .= " f.tms as date_modification,";
1212 $sql .= " f.date_valid as datev,";
1213 $sql .= " f.fk_user_author,";
1214 $sql .= " f.fk_user_modif as fk_user_modification,";
1215 $sql .= " f.fk_user_valid";
1216 $sql .= " FROM ".MAIN_DB_PREFIX."fichinter as f";
1217 $sql .= " WHERE f.rowid = ".((int) $id);
1218
1219 $resql = $this->db->query($sql);
1220 if ($resql) {
1221 if ($this->db->num_rows($resql)) {
1222 $obj = $this->db->fetch_object($resql);
1223
1224 $this->id = $obj->rowid;
1225
1226 $this->date_creation = $this->db->jdate($obj->datec);
1227 $this->date_modification = $this->db->jdate($obj->date_modification);
1228 $this->date_validation = $this->db->jdate($obj->datev);
1229
1230 $this->user_creation_id = $obj->fk_user_author;
1231 $this->user_validation_id = $obj->fk_user_valid;
1232 $this->user_modification_id = $obj->fk_user_modification;
1233 }
1234 $this->db->free($resql);
1235 } else {
1236 dol_print_error($this->db);
1237 }
1238 }
1239
1247 public function delete(User $user, $notrigger = 0)
1248 {
1249 global $conf, $langs;
1250 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1251
1252 $error = 0;
1253
1254 $this->db->begin();
1255
1256 if (!$notrigger) {
1257 // Call trigger
1258 $result = $this->call_trigger('FICHINTER_DELETE', $user);
1259 if ($result < 0) {
1260 $error++;
1261 $this->db->rollback();
1262 return -1;
1263 }
1264 // End call triggers
1265 }
1266
1267 // Delete linked object
1268 $res = $this->deleteObjectLinked();
1269 if ($res < 0) {
1270 $error++;
1271 }
1272
1273 // Delete linked contacts
1274 if (!$error) {
1275 $res = $this->delete_linked_contact();
1276 if ($res < 0) {
1277 $this->error = 'ErrorFailToDeleteLinkedContact';
1278 $error++;
1279 }
1280 }
1281
1282 if (!$error) {
1283 $main = MAIN_DB_PREFIX.'fichinterdet';
1284 $ef = $main."_extrafields";
1285 $sql = "DELETE FROM ".$this->db->sanitize($ef)." WHERE fk_object IN (SELECT rowid FROM ".$this->db->sanitize($main)." WHERE fk_fichinter = ".((int) $this->id).")";
1286
1287 $resql = $this->db->query($sql);
1288 if (!$resql) {
1289 $error++;
1290 }
1291 }
1292
1293 if (!$error) {
1294 $sql = "DELETE FROM ".MAIN_DB_PREFIX."fichinterdet";
1295 $sql .= " WHERE fk_fichinter = ".((int) $this->id);
1296
1297 $resql = $this->db->query($sql);
1298 if (!$resql) {
1299 $error++;
1300 }
1301 }
1302
1303 if (!$error) {
1304 // Remove extrafields
1305 $res = $this->deleteExtraFields();
1306 if ($res < 0) {
1307 $error++;
1308 }
1309 }
1310
1311 if (!$error) {
1312 // Delete object
1313 $sql = "DELETE FROM ".MAIN_DB_PREFIX."fichinter";
1314 $sql .= " WHERE rowid = ".((int) $this->id);
1315
1316 dol_syslog("Fichinter::delete", LOG_DEBUG);
1317 $resql = $this->db->query($sql);
1318 if (!$resql) {
1319 $error++;
1320 }
1321 }
1322
1323 if (!$error) {
1324 // Delete record into ECM index (Note that delete is also done when deleting files with the dol_delete_dir_recursive
1325 $this->deleteEcmFiles(0); // Deleting files physically is done later with the dol_delete_dir_recursive
1326 $this->deleteEcmFiles(1); // Deleting files physically is done later with the dol_delete_dir_recursive
1327
1328 // Remove directory with files
1329 $fichinterref = dol_sanitizeFileName($this->ref);
1330 if ($conf->ficheinter->dir_output && !empty($fichinterref)) {
1331 $dir = $conf->ficheinter->dir_output."/".$fichinterref;
1332 $file = $conf->ficheinter->dir_output."/".$fichinterref."/".$fichinterref.".pdf";
1333 if (file_exists($file)) {
1334 dol_delete_preview($this);
1335
1336 if (!dol_delete_file($file, 0, 0, 0, $this)) { // For triggers
1337 $langs->load("errors");
1338 $this->error = $langs->trans("ErrorFailToDeleteFile", $file);
1339 return 0;
1340 }
1341 }
1342 if (file_exists($dir)) {
1343 if (!dol_delete_dir_recursive($dir)) {
1344 $langs->load("errors");
1345 $this->error = $langs->trans("ErrorFailToDeleteDir", $dir);
1346 return 0;
1347 }
1348 }
1349 }
1350 }
1351
1352 if (!$error) {
1353 $this->db->commit();
1354 return 1;
1355 } else {
1356 $this->db->rollback();
1357 return -1;
1358 }
1359 }
1360
1361 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1369 public function set_date_delivery($user, $delivery_date_receipt)
1370 {
1371 // phpcs:enable
1372 if ($user->hasRight('ficheinter', 'creer')) {
1373 $this->db->begin();
1374
1375 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter";
1376 $sql .= " SET datei = '".$this->db->idate($delivery_date_receipt)."'";
1377 $sql .= " WHERE rowid = ".((int) $this->id);
1378 $sql .= " AND fk_statut = 0";
1379
1380 if ($this->db->query($sql)) {
1381 $this->date_delivery = $delivery_date_receipt;
1382 $this->delivery_date_receipt = $delivery_date_receipt;
1383
1384 $result = $this->call_trigger($this->TRIGGER_PREFIX . '_MODIFY', $user);
1385 if ($result < 0) {
1386 $this->db->rollback();
1387 return -1;
1388 }
1389
1390 $this->db->commit();
1391 return 1;
1392 } else {
1393 $this->error = $this->db->error();
1394 dol_syslog("Fichinter::set_date_delivery Erreur SQL");
1395 $this->db->rollback();
1396 return -1;
1397 }
1398 }
1399
1400 return 0;
1401 }
1402
1403 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1411 public function set_description($user, $description)
1412 {
1413 // phpcs:enable
1414 if ($user->hasRight('ficheinter', 'creer')) {
1415 $this->db->begin();
1416
1417 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter ";
1418 $sql .= " SET description = '".$this->db->escape($description)."',";
1419 $sql .= " fk_user_modif = ".((int) $user->id);
1420 $sql .= " WHERE rowid = ".((int) $this->id);
1421
1422 if ($this->db->query($sql)) {
1423 $this->description = $description;
1424
1425 $result = $this->call_trigger($this->TRIGGER_PREFIX . '_MODIFY', $user);
1426 if ($result < 0) {
1427 $this->db->rollback();
1428 return -1;
1429 }
1430
1431 $this->db->commit();
1432 return 1;
1433 } else {
1434 $this->error = $this->db->error();
1435 dol_syslog("Fichinter::set_description Erreur SQL");
1436 $this->db->rollback();
1437 return -1;
1438 }
1439 }
1440
1441 return 0;
1442 }
1443
1444
1445 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1453 public function set_contrat($user, $contractid)
1454 {
1455 // phpcs:enable
1456 if ($user->hasRight('ficheinter', 'creer')) {
1457 $this->db->begin();
1458
1459 $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter ";
1460 $sql .= " SET fk_contrat = ".((int) $contractid);
1461 $sql .= " WHERE rowid = ".((int) $this->id);
1462
1463 if ($this->db->query($sql)) {
1464 $this->fk_contrat = $contractid;
1465
1466 $result = $this->call_trigger($this->TRIGGER_PREFIX . '_MODIFY', $user);
1467 if ($result < 0) {
1468 $this->db->rollback();
1469 return -1;
1470 }
1471
1472 $this->db->commit();
1473 return 1;
1474 } else {
1475 $this->error = $this->db->error();
1476 $this->db->rollback();
1477 return -1;
1478 }
1479 }
1480
1481 return -2;
1482 }
1483
1484
1485
1495 public function createFromClone(User $user, $socid = 0, $clone_contacts = false, $clone_notes = false)
1496 {
1497 global $hookmanager, $langs;
1498 $langs->load("errors");
1499
1500 $error = 0;
1501
1502 $this->db->begin();
1503
1504 // get extrafields so they will be clone
1505 foreach ($this->lines as $line) {
1506 $line->fetch_optionals();
1507 }
1508
1509 // Load source object
1510 $objFrom = clone $this;
1511
1512 // Change socid if needed
1513 if (!empty($socid) && $socid != $this->socid) {
1514 $objsoc = new Societe($this->db);
1515
1516 if ($objsoc->fetch($socid) > 0) {
1517 $this->socid = $objsoc->id;
1518 //$this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1519 //$this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1520 $this->fk_project = 0;
1521 $this->fk_delivery_address = 0;
1522 }
1523
1524 // TODO Change product price if multi-prices
1525 }
1526
1527 $this->id = 0;
1528 $this->ref = '';
1529 $this->status = self::STATUS_DRAFT;
1530 $this->statut = self::STATUS_DRAFT; // deprecated
1531
1532 // Clear fields
1533 $this->user_author_id = $user->id;
1534 $this->user_validation_id = 0;
1535 $this->date_creation = '';
1536 $this->date_validation = '';
1537 $this->signed_status = 0;
1538
1539 $this->ref_client = '';
1540
1541 if (!$clone_notes) {
1542 $this->note_private = '';
1543 $this->note_public = '';
1544 }
1545
1546 // Create clone
1547 $this->context['createfromclone'] = 'createfromclone';
1548 $result = $this->create($user);
1549 if ($result < 0) {
1550 $error++;
1551 }
1552
1553 if (!$error) {
1554 // Add lines because it is not included into create function
1555 foreach ($this->lines as $line) {
1556 $this->addline($user, $this->id, $line->desc, $line->datei, $line->duration, $line->array_options);
1557 }
1558
1559 // Hook of thirdparty module
1560 if (is_object($hookmanager)) {
1561 $parameters = array('objFrom' => $objFrom);
1562 $action = '';
1563 $reshook = $hookmanager->executeHooks('createFrom', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1564 if ($reshook < 0) {
1565 $this->setErrorsFromObject($hookmanager);
1566 $error++;
1567 }
1568 }
1569 }
1570
1571 //Duplicate contact
1572 if ($clone_contacts) {
1573 foreach (array('internal', 'external') as $source) {
1574 $tab = $objFrom->liste_contact(-1, $source);
1575 if (is_array($tab) && count($tab) > 0) {
1576 foreach ($tab as $contacttoadd) {
1577 $retAddContact = $this->add_contact(
1578 $contacttoadd['id'],
1579 $contacttoadd['code'],
1580 $contacttoadd['source']
1581 );
1582 if ($this->error == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
1583 $this->error .= $langs->trans("ErrorThisContactIsAlreadyDefinedAsThisType");
1584 $error++;
1585 } elseif ($retAddContact < 0) {
1586 $error++;
1587 }
1588 }
1589 } elseif ($tab < 0) {
1590 $this->error .= $objFrom->error;
1591 $error++;
1592 }
1593 }
1594 }
1595
1596 unset($this->context['createfromclone']);
1597
1598 // End
1599 if (!$error) {
1600 $this->db->commit();
1601 return $this->id;
1602 } else {
1603 $this->db->rollback();
1604 return -1;
1605 }
1606 }
1607
1608
1623 public function addline($user, $fichinterid, $desc, $date_intervention, $duration, $array_options = [], $type = 0, $rang = -1, $special_code = 0)
1624 {
1625 dol_syslog(get_class($this)."::addline $fichinterid, $desc, $date_intervention, $duration, $type, $rang, $special_code");
1626
1627 if ($this->status == self::STATUS_DRAFT) {
1628 $this->db->begin();
1629
1630 // Insert line
1631 $line = new FichinterLigne($this->db);
1632
1633 $line->fk_fichinter = $fichinterid;
1634 $line->desc = $desc;
1635 $line->date = $date_intervention;
1636 $line->datei = $date_intervention; // For backward compatibility
1637 $line->duration = $duration;
1638 $line->product_type = $type;
1639 $line->rang = $rang;
1640 $line->special_code = $special_code;
1641
1642
1643 if (is_array($array_options) && count($array_options) > 0) {
1644 $line->array_options = $array_options;
1645 }
1646
1647 $result = $line->insert($user);
1648
1649 if ($result >= 0) {
1650 $this->db->commit();
1651 return $line->id;
1652 } else {
1653 $this->error = $this->db->error();
1654 $this->db->rollback();
1655 return -1;
1656 }
1657 }
1658
1659 return 0;
1660 }
1661
1662
1670 public function initAsSpecimen()
1671 {
1672 global $langs;
1673
1674 $now = dol_now();
1675
1676 // Initialise parameters
1677 $this->id = 0;
1678 $this->ref = 'SPECIMEN';
1679 $this->ref_client = 'SPECIMEN CLIENT';
1680 $this->specimen = 1;
1681 $this->socid = 1;
1682 $this->datec = $now;
1683 $this->note_private = 'Private note';
1684 $this->note_public = 'SPECIMEN';
1685 $this->duration = 0;
1686 $this->user_creation_id = 1;
1687 $nbp = 25;
1688 $xnbp = 0;
1689 while ($xnbp < $nbp) {
1690 $line = new FichinterLigne($this->db);
1691 $line->desc = $langs->trans("Description")." ".$xnbp;
1692 $line->date = ($now - 3600 * (1 + $xnbp));
1693 $line->datei = ($now - 3600 * (1 + $xnbp)); // For backward compatibility
1694 $line->duration = 600;
1695 $line->fk_fichinter = 0;
1696 $this->lines[$xnbp] = $line;
1697 $xnbp++;
1698
1699 $this->duration += $line->duration;
1700 }
1701
1702 return 1;
1703 }
1704
1705 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1711 public function fetch_lines()
1712 {
1713 // phpcs:enable
1714 $this->lines = array();
1715
1716 $sql = "SELECT rowid, fk_fichinter, description, duree, date, rang, extraparams, special_code";
1717 $sql .= " FROM ".MAIN_DB_PREFIX."fichinterdet";
1718 $sql .= " WHERE fk_fichinter = ".((int) $this->id);
1719 $sql .= " ORDER BY rang ASC, date ASC";
1720
1721 dol_syslog(get_class($this)."::fetch_lines", LOG_DEBUG);
1722
1723 $resql = $this->db->query($sql);
1724 if ($resql) {
1725 $num = $this->db->num_rows($resql);
1726 $i = 0;
1727 while ($i < $num) {
1728 $objp = $this->db->fetch_object($resql);
1729
1730 $line = new FichinterLigne($this->db);
1731 $line->id = $objp->rowid;
1732 $line->fk_fichinter = $objp->fk_fichinter;
1733 $line->desc = $objp->description;
1734 $line->duration = $objp->duree;
1735 $line->special_code = (int) ($objp->special_code ?? 0);
1736 if ($line->special_code == SUBTOTALS_SPECIAL_CODE) {
1737 // Subtotals module lines store their depth (not a real duration) in duree — do not convert to hours
1738 $line->qty = (int) $objp->duree;
1739 } else {
1740 //For invoicing we calculing hours
1741 $line->qty = round($objp->duree / 3600, 2);
1742 }
1743 $line->date = $this->db->jdate($objp->date);
1744 $line->datei = $this->db->jdate($objp->date); // For backward compatibility
1745 $line->rang = $objp->rang;
1746 $line->product_type = 1;
1747 $line->fetch_optionals();
1748
1749 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
1750
1751 $this->lines[$i] = $line;
1752 $i++;
1753 }
1754 $this->db->free($resql);
1755
1756 return 1;
1757 } else {
1758 $this->error = $this->db->error();
1759 return -1;
1760 }
1761 }
1762
1771 public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
1772 {
1773 $tables = array(
1774 'fichinter'
1775 );
1776
1777 return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
1778 }
1779
1790 public function setCategories($categories)
1791 {
1792 require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
1793 return parent::setCategoriesCommon($categories, Categorie::TYPE_FICHINTER);
1794 }
1795
1804 public function setRefClient($user, $ref_client, $notrigger = 0)
1805 {
1806 // phpcs:enable
1807 if ($user->hasRight('ficheinter', 'creer')) {
1808 $error = 0;
1809
1810 $this->db->begin();
1811
1812 $this->oldcopy = dol_clone($this, 2);
1813
1814 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element." SET ref_client = ".(empty($ref_client) ? 'NULL' : "'".$this->db->escape($ref_client)."'");
1815 $sql .= " WHERE rowid = ".((int) $this->id);
1816
1817 dol_syslog(__METHOD__.' $this->id='.$this->id.', ref_client='.$ref_client, LOG_DEBUG);
1818 $resql = $this->db->query($sql);
1819 if (!$resql) {
1820 $this->errors[] = $this->db->error();
1821 $error++;
1822 }
1823
1824 if (!$error) {
1825 $this->ref_client = $ref_client;
1826 }
1827
1828 if (!$notrigger && empty($error)) {
1829 // Call trigger
1830 $result = $this->call_trigger('FICHINTER_MODIFY', $user);
1831 if ($result < 0) {
1832 $error++;
1833 }
1834 // End call triggers
1835 }
1836
1837 if (!$error) {
1838 $this->db->commit();
1839 return 1;
1840 } else {
1841 foreach ($this->errors as $errmsg) {
1842 dol_syslog(__METHOD__.' Error: '.$errmsg, LOG_ERR);
1843 $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
1844 }
1845 $this->db->rollback();
1846 return -1 * $error;
1847 }
1848 } else {
1849 return -1;
1850 }
1851 }
1852
1860 public function getKanbanView($option = '', $arraydata = null)
1861 {
1862 global $langs;
1863
1864 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
1865
1866 $return = '<div class="box-flex-item box-flex-grow-zero">';
1867 $return .= '<div class="info-box info-box-sm">';
1868 $return .= '<span class="info-box-icon bg-infobox-action">';
1869 $return .= img_picto('', $this->picto);
1870 $return .= '</span>';
1871 $return .= '<div class="info-box-content">';
1872 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->getNomUrl() . '</span>';
1873 if ($selected >= 0) {
1874 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
1875 }
1876 if (!empty($arraydata['thirdparty'])) {
1877 $tmpthirdparty = $arraydata['thirdparty'];
1878 '@phan-var-force Societe $tmpthirdparty';
1880 $return .= '<br><span class="info-box-label">'.$tmpthirdparty->getNomUrl(1).'</span>';
1881 }
1882 if (!empty($this->duration)) {
1883 $return .= '<br><span class="info-box-label ">'.$langs->trans("Duration").' : '.convertSecondToTime($this->duration, 'allhourmin').'</span>';
1884 }
1885 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
1886 $return .= '</div>';
1887 $return .= '</div>';
1888 $return .= '</div>';
1889 return $return;
1890 }
1891}
$object ref
Definition info.php:90
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
deleteEcmFiles($mode=0)
Delete related files of object in database.
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
delete_linked_contact($source='', $code='')
Delete all links between an object $this and all its contacts in llx_element_contact.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Class to manage Dolibarr database access.
const STATUS_BILLED
Billed.
initAsSpecimen()
Initialise an instance with random values.
createFromClone(User $user, $socid=0, $clone_contacts=false, $clone_notes=false)
Load an object from its id and create a new one in database.
getLibStatut($mode=0)
Returns the label status.
update($user, $notrigger=0)
Update an intervention.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
setClose($user, $notrigger=0)
Close intervention.
const STATUS_DRAFT
Draft status.
create($user, $notrigger=0)
Create an intervention into data base.
setCategories($categories)
Sets object to given categories.
set_description($user, $description)
Define the label of the intervention.
getTooltipContentArray($params)
getTooltipContentArray
const STATUS_CANCELED
Canceled status.
set_date_delivery($user, $delivery_date_receipt)
Defines a delivery date of the receipt of intervention.
const STATUS_VALIDATED
Validated status.
fetch($rowid, $ref='', $ref_ext='')
Fetch a intervention.
setReopen($user, $notrigger=0)
Tag the intervention as validated (opened) Function used when the intervention is reopened after bein...
const STATUS_CLOSED
Closed.
setDraft($user)
Set status to draft.
getNextNumRef($soc)
Returns the next non used reference of intervention depending on the module numbering assets within F...
getAmount()
Returns amount based on user thm.
addline($user, $fichinterid, $desc, $date_intervention, $duration, $array_options=[], $type=0, $rang=-1, $special_code=0)
Adding a line of intervention into data base.
setRefClient($user, $ref_client, $notrigger=0)
Set customer reference number.
set_contrat($user, $contractid)
Link intervention to a contract.
LibStatut($status, $mode=0)
Returns the label of a status.
setValid($user, $notrigger=0)
Validate a intervention.
loadStateBoard()
Load indicators into this->nb for board.
getNomUrl($withpicto=0, $option='', $notooltip=0, $save_lastsearch_value=-1, $morecss='')
Return clickable name (with picto eventually)
__construct($db)
Constructor.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
info($id)
Load information on object.
setCanceled($user, $notrigger=0)
Cancel an intervention.
fetch_lines()
Load array lines ->lines.
Class to manage intervention lines.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Definition index.php:169
getLibSignedStatus(int $mode=0)
Returns the label for signed status.
convertSecondToTime($iSecond, $format='all', $lengthOfDay=86400, $lengthOfWeek=7)
Return, in clear text, value of a number of seconds in days, hours and minutes.
Definition date.lib.php:263
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_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_dir_list($utf8_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:66
dol_delete_preview($object)
Delete all preview files linked to object instance.
dol_now($mode='gmt')
Return date for now.
setEntity($currentobject)
Set entity id to use when to create an object.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dol_strlen($string, $stringencoding='UTF-8', $binarycount=0)
Make a strlen call.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_clone($srcobject, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.