37require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
38require_once DOL_DOCUMENT_ROOT.
"/core/class/commonobjectline.class.php";
39require_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
40require_once DOL_DOCUMENT_ROOT.
'/margin/lib/margins.lib.php';
50 public $element =
'contrat';
55 public $table_element =
'contrat';
60 public $table_element_line =
'contratdet';
65 public $fk_element =
'fk_contrat';
70 public $picto =
'contract';
76 public $restrictiononfksoc = 1;
135 public $fk_user_author;
142 public $user_author_id;
149 public $user_creation;
154 public $user_cloture;
159 public $date_creation;
164 public $date_modification;
169 public $date_validation;
174 public $date_contrat;
180 public $signed_status = 0;
182 public $commercial_signature_id;
183 public $fk_commercial_signature;
184 public $commercial_suivi_id;
185 public $fk_commercial_suivi;
193 public $extraparams = array();
198 public $lines = array();
200 public $nbofservices;
201 public $nbofserviceswait;
202 public $nbofservicesopened;
203 public $nbofservicesexpired;
204 public $nbofservicesclosed;
212 protected $lines_id_index_mapper = array();
243 public $fields = array(
244 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
245 'ref' => array(
'type' =>
'varchar(50)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => -1,
'showoncombobox' => 1,
'position' => 15,
'searchall' => 1),
246 'ref_ext' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref ext',
'enabled' => 1,
'visible' => 0,
'position' => 20),
247 'ref_customer' => array(
'type' =>
'varchar(50)',
'label' =>
'RefCustomer',
'enabled' => 1,
'visible' => -1,
'position' => 25,
'searchall' => 1),
248 'ref_supplier' => array(
'type' =>
'varchar(50)',
'label' =>
'RefSupplier',
'enabled' => 1,
'visible' => -1,
'position' => 26,
'searchall' => 1),
249 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 30,
'index' => 1),
250 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 35),
251 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 40),
252 'date_contrat' => array(
'type' =>
'datetime',
'label' =>
'Date contrat',
'enabled' => 1,
'visible' => -1,
'position' => 45),
253 'signed_status' => array(
'type' =>
'smallint(6)',
'label' =>
'SignedStatus',
'enabled' => 1,
'visible' => -1,
'position' => 50,
'arrayofkeyval' => array(0 =>
'NoSignature', 1 =>
'SignedSender', 2 =>
'SignedReceiver', 9 =>
'SignedAll')),
254 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 70),
255 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 75),
256 'fk_commercial_signature' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'SaleRepresentative Signature',
'enabled' => 1,
'visible' => -1,
'position' => 80),
257 'fk_commercial_suivi' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'SaleRepresentative follower',
'enabled' => 1,
'visible' => -1,
'position' => 85),
258 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 90),
259 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 105,
'searchall' => 1),
260 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 110,
'searchall' => 1),
261 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'Model pdf',
'enabled' => 1,
'visible' => 0,
'position' => 115),
262 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 120),
263 'extraparams' => array(
'type' =>
'varchar(255)',
'label' =>
'Extraparams',
'enabled' => 1,
'visible' => -1,
'position' => 125),
264 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 135),
265 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'Last main doc',
'enabled' => 1,
'visible' => -1,
'position' => 140),
266 'statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Statut',
'enabled' => 1,
'visible' => -1,
'position' => 500,
'notnull' => 1,
'arrayofkeyval' => array(0 =>
'Draft', 1 =>
'Validated', 2 =>
'Closed'))
270 const STATUS_DRAFT = 0;
271 const STATUS_VALIDATED = 1;
272 const STATUS_CLOSED = 2;
277 const STATUS_NO_SIGNATURE = 0;
282 const STATUS_SIGNED_SENDER = 1;
287 const STATUS_SIGNED_RECEIVER = 2;
292 const STATUS_SIGNED_ALL = 9;
304 $this->ismultientitymanaged = 1;
305 $this->isextrafieldmanaged = 1;
316 global $db, $langs, $conf;
317 $langs->load(
"contracts");
326 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
328 foreach ($dirmodels as $reldir) {
332 $mybool = ((bool) @include_once $dir.$file) || $mybool;
340 $obj =
new $classname();
341 '@phan-var-force CommonNumRefGenerator $obj';
342 $numref = $obj->getNextValue($soc, $this);
347 $this->error = $obj->error;
352 $langs->load(
"errors");
353 print $langs->trans(
"Error").
" ".$langs->trans(
"ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv(
"Contract"));
369 public function active_line($user, $line_id, $date_start, $date_end =
'', $comment =
'')
372 $result = $this->lines[$this->lines_id_index_mapper[$line_id]]->active_line($user, $date_start, $date_end, $comment);
374 $this->error = $this->lines[$this->lines_id_index_mapper[$line_id]]->error;
375 $this->errors = $this->lines[$this->lines_id_index_mapper[$line_id]]->errors;
391 public function close_line($user, $line_id, $date_end, $comment =
'')
394 $result = $this->lines[$this->lines_id_index_mapper[$line_id]]->close_line($user, $date_end, $comment);
396 $this->error = $this->lines[$this->lines_id_index_mapper[$line_id]]->error;
397 $this->errors = $this->lines[$this->lines_id_index_mapper[$line_id]]->errors;
414 public function activateAll($user, $date_start =
'', $notrigger = 0, $comment =
'', $date_end =
'')
416 if (empty($date_start)) {
427 foreach ($this->lines as $contratline) {
429 if ($contratline->statut != ContratLigne::STATUS_OPEN) {
430 $contratline->context = $this->context;
432 $result = $contratline->active_line($user, $date_start, !empty($date_end) ? $date_end : -1, $comment);
435 $this->error = $contratline->error;
436 $this->errors = $contratline->errors;
442 if (!$error && $this->
statut == 0) {
443 $result = $this->
validate($user,
'', $notrigger);
453 $this->db->rollback();
478 foreach ($this->lines as $contratline) {
480 if ($contratline->statut != ContratLigne::STATUS_CLOSED) {
481 $contratline->date_end_real = $now;
482 $contratline->date_cloture = $now;
483 $contratline->user_closing_id = $user->id;
484 $contratline->statut = ContratLigne::STATUS_CLOSED;
485 $result = $contratline->close_line($user, $now, $comment, $notrigger);
488 $this->error = $contratline->error;
489 $this->errors = $contratline->errors;
495 if (!$error && $this->
statut == 0) {
496 $result = $this->
validate($user,
'', $notrigger);
506 $this->db->rollback();
519 public function validate(
User $user, $force_number =
'', $notrigger = 0)
521 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
527 dol_syslog(get_class($this).
'::validate user='.$user->id.
', force_number='.$force_number);
535 if (!
getDolGlobalString(
'CONTRACT_DISABLE_AUTOSET_AS_CLIENT_ON_CONTRACT_VALIDATION') && $this->thirdparty->fournisseur == 0) {
536 $result = $this->thirdparty->setAsCustomer();
541 $num = $force_number;
542 } elseif (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref))) {
550 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contrat SET ref = '".$this->db->escape($num).
"', statut = 1";
552 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND statut = 0";
554 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
555 $resql = $this->db->query($sql);
559 $this->error = $this->db->lasterror();
563 if (!$error && !$notrigger) {
565 $result = $this->
call_trigger(
'CONTRACT_VALIDATE', $user);
573 $this->oldref = $this->ref;
576 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
578 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'contract/".$this->db->escape($this->newref).
"'";
579 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'contract/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
580 $resql = $this->db->query($sql);
583 $this->error = $this->db->lasterror();
585 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'contract/".$this->db->escape($this->newref).
"'";
586 $sql .=
" WHERE filepath = 'contract/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
587 $resql = $this->db->query($sql);
590 $this->error = $this->db->lasterror();
596 $dirsource = $conf->contract->dir_output.
'/'.$oldref;
597 $dirdest = $conf->contract->dir_output.
'/'.$newref;
598 if (!$error && file_exists($dirsource)) {
599 dol_syslog(get_class($this).
"::validate rename dir ".$dirsource.
" into ".$dirdest);
601 if (@rename($dirsource, $dirdest)) {
604 $listoffiles =
dol_dir_list($conf->contract->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
605 foreach ($listoffiles as $fileentry) {
606 $dirsource = $fileentry[
'name'];
607 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
608 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
609 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
610 @rename($dirsource, $dirdest);
620 $this->
status = self::STATUS_VALIDATED;
621 $this->
statut = self::STATUS_VALIDATED;
622 $this->date_validation = $now;
632 $this->db->rollback();
644 public function reopen($user, $notrigger = 0)
646 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
651 dol_syslog(get_class($this).
'::reopen user='.$user->id);
657 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contrat SET statut = 0";
659 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND statut = 1";
661 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
662 $resql = $this->db->query($sql);
666 $this->error = $this->db->lasterror();
670 if (!$error && !$notrigger) {
672 $result = $this->
call_trigger(
'CONTRACT_REOPEN', $user);
681 $this->
statut = self::STATUS_DRAFT;
682 $this->
status = self::STATUS_DRAFT;
683 $this->date_validation = $now;
690 $this->db->rollback();
706 public function fetch($id, $ref =
'', $ref_customer =
'', $ref_supplier =
'', $noextrafields = 0, $nolines = 0)
708 $sql =
"SELECT rowid, statut as status, ref, fk_soc as thirdpartyid,";
709 $sql .=
" ref_supplier, ref_customer,";
712 $sql .=
" date_contrat as datecontrat,";
713 $sql .=
" fk_user_author,";
714 $sql .=
" fk_projet as fk_project,";
715 $sql .=
" fk_commercial_signature, fk_commercial_suivi,";
716 $sql .=
" note_private, note_public, model_pdf, last_main_doc, extraparams";
717 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat";
719 $sql .=
" WHERE entity IN (".getEntity(
'contract').
")";
721 $sql .=
" WHERE rowid = ".(int) $id;
724 $sql .=
" AND ref_customer = '".$this->db->escape($ref_customer).
"'";
727 $sql .=
" AND ref_supplier = '".$this->db->escape($ref_supplier).
"'";
730 $sql .=
" AND ref = '".$this->db->escape($ref).
"'";
733 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
734 $resql = $this->db->query($sql);
736 $num = $this->db->num_rows($resql);
738 $this->error =
'Fetch found several records.';
743 $obj = $this->db->fetch_object($resql);
745 $this->
id = $obj->rowid;
746 $this->
ref = (!isset($obj->ref) || !$obj->ref) ? $obj->rowid : $obj->ref;
747 $this->ref_customer = $obj->ref_customer;
748 $this->ref_supplier = $obj->ref_supplier;
749 $this->ref_ext = $obj->ref_ext;
750 $this->entity = $obj->entity;
751 $this->
statut = $obj->status;
752 $this->
status = $obj->status;
754 $this->date_contrat = $this->db->jdate($obj->datecontrat);
755 $this->date_creation = $this->db->jdate($obj->datecontrat);
757 $this->user_author_id = $obj->fk_user_author;
759 $this->commercial_signature_id = $obj->fk_commercial_signature;
760 $this->commercial_suivi_id = $obj->fk_commercial_suivi;
762 $this->note_private = $obj->note_private;
763 $this->note_public = $obj->note_public;
764 $this->model_pdf = $obj->model_pdf;
766 $this->fk_projet = $obj->fk_project;
767 $this->fk_project = $obj->fk_project;
769 $this->socid = $obj->thirdpartyid;
770 $this->fk_soc = $obj->thirdpartyid;
771 $this->last_main_doc = $obj->last_main_doc;
772 $this->extraparams = (isset($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) :
null);
774 $this->db->free($resql);
778 if (empty($noextrafields)) {
781 $this->error = $this->db->lasterror();
787 if (empty($nolines)) {
788 if ($result >= 0 && !empty($this->table_element_line)) {
791 $this->error = $this->db->lasterror();
799 dol_syslog(get_class($this).
"::fetch Contract failed");
800 $this->error =
"Fetch contract failed";
804 dol_syslog(get_class($this).
"::fetch Contract not found");
805 $this->error =
"Contract not found";
809 dol_syslog(get_class($this).
"::fetch Error searching contract");
810 $this->error = $this->db->error();
825 public function fetch_lines($only_services = 0, $loadalsotranslation = 0, $noextrafields = 0)
828 $this->nbofservices = 0;
829 $this->nbofserviceswait = 0;
830 $this->nbofservicesopened = 0;
831 $this->nbofservicesexpired = 0;
832 $this->nbofservicesclosed = 0;
840 $this->lines = array();
844 $sql =
"SELECT p.label as product_label, p.description as product_desc, p.ref as product_ref, p.fk_product_type as product_type,";
845 $sql .=
" d.rowid, d.fk_contrat, d.statut as status, d.description, d.price_ht, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.remise_percent, d.subprice, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht,";
846 $sql .=
" d.total_ht,";
847 $sql .=
" d.total_tva,";
848 $sql .=
" d.total_localtax1,";
849 $sql .=
" d.total_localtax2,";
850 $sql .=
" d.total_ttc,";
851 $sql .=
" d.info_bits, d.fk_product,";
852 $sql .=
" d.date_ouverture_prevue as date_start,";
853 $sql .=
" d.date_ouverture as date_start_real,";
854 $sql .=
" d.date_fin_validite as date_end,";
855 $sql .=
" d.date_cloture as date_end_real,";
856 $sql .=
" d.fk_user_author,";
857 $sql .=
" d.fk_user_ouverture,";
858 $sql .=
" d.fk_user_cloture,";
859 $sql .=
" d.fk_unit,";
860 $sql .=
" d.product_type as type,";
862 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet as d LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON d.fk_product = p.rowid";
863 $sql .=
" WHERE d.fk_contrat = ".((int) $this->
id);
864 if ($only_services == 1) {
865 $sql .=
" AND d.product_type = 1";
867 $sql .=
" ORDER by d.rang ASC";
869 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
870 $result = $this->db->query($sql);
872 $num = $this->db->num_rows($result);
876 $objp = $this->db->fetch_object($result);
880 $line->id = $objp->rowid;
881 $line->ref = $objp->rowid;
882 $line->fk_contrat = $objp->fk_contrat;
883 $line->desc = $objp->description;
884 $line->qty = $objp->qty;
885 $line->vat_src_code = $objp->vat_src_code;
886 $line->tva_tx = $objp->tva_tx;
887 $line->localtax1_tx = $objp->localtax1_tx;
888 $line->localtax2_tx = $objp->localtax2_tx;
889 $line->localtax1_type = $objp->localtax1_type;
890 $line->localtax2_type = $objp->localtax2_type;
891 $line->subprice = $objp->subprice;
892 $line->statut = $objp->status;
893 $line->status = $objp->status;
894 $line->remise_percent = $objp->remise_percent;
895 $line->price_ht = $objp->price_ht;
896 $line->price = $objp->price_ht;
897 $line->total_ht = $objp->total_ht;
898 $line->total_tva = $objp->total_tva;
899 $line->total_localtax1 = $objp->total_localtax1;
900 $line->total_localtax2 = $objp->total_localtax2;
901 $line->total_ttc = $objp->total_ttc;
902 $line->fk_product = (($objp->fk_product > 0) ? $objp->fk_product : 0);
903 $line->info_bits = $objp->info_bits;
904 $line->type = $objp->type;
906 $line->fk_fournprice = $objp->fk_fournprice;
907 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $objp->fk_fournprice, $objp->pa_ht);
908 $line->pa_ht = $marginInfos[0];
910 $line->fk_user_author = $objp->fk_user_author;
911 $line->fk_user_ouverture = $objp->fk_user_ouverture;
912 $line->fk_user_cloture = $objp->fk_user_cloture;
913 $line->fk_unit = $objp->fk_unit;
915 $line->ref = $objp->product_ref;
916 $line->product_ref = $objp->product_ref;
917 $line->product_type = $objp->product_type;
918 $line->product_desc = $objp->product_desc;
919 $line->product_label = $objp->product_label;
921 $line->description = $objp->description;
923 $line->date_start = $this->db->jdate($objp->date_start);
924 $line->date_start_real = $this->db->jdate($objp->date_start_real);
925 $line->date_end = $this->db->jdate($objp->date_end);
926 $line->date_end_real = $this->db->jdate($objp->date_end_real);
937 $line->rang = $objp->rang;
941 if (empty($noextrafields)) {
942 $line->fetch_optionals();
946 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && !empty($objp->fk_product) && !empty($loadalsotranslation)) {
947 $tmpproduct =
new Product($this->db);
948 $tmpproduct->fetch($objp->fk_product);
949 $tmpproduct->getMultiLangs();
951 $line->multilangs = $tmpproduct->multilangs;
954 $this->lines[$pos] = $line;
956 $this->lines_id_index_mapper[$line->id] = $pos;
961 if ($line->statut == ContratLigne::STATUS_INITIAL) {
962 $this->nbofserviceswait++;
964 if ($line->statut == ContratLigne::STATUS_OPEN && (empty($line->date_end) || $line->date_end >= $now)) {
965 $this->nbofservicesopened++;
967 if ($line->statut == ContratLigne::STATUS_OPEN && (!empty($line->date_end) && $line->date_end < $now)) {
968 $this->nbofservicesexpired++;
970 if ($line->statut == ContratLigne::STATUS_CLOSED) {
971 $this->nbofservicesclosed++;
974 $total_ttc += $objp->total_ttc;
975 $total_vat += $objp->total_tva;
976 $total_ht += $objp->total_ht;
981 $this->db->free($result);
983 dol_syslog(get_class($this).
"::Fetch Error when reading lines of contracts linked to products");
988 $this->nbofservices = count($this->lines);
989 $this->total_ttc = (float)
price2num($total_ttc);
990 $this->total_tva = (float)
price2num($total_vat);
991 $this->total_ht = (float)
price2num($total_ht);
1004 global $conf, $langs, $mysoc;
1008 if ($this->commercial_signature_id <= 0) {
1009 $langs->load(
"commercial");
1010 $this->error .= $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"SalesRepresentativeSignature"));
1013 if ($this->commercial_suivi_id <= 0) {
1014 $langs->load(
"commercial");
1015 $this->error .= ($this->error ?
"<br>" :
'');
1016 $this->error .= $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"SalesRepresentativeFollowUp"));
1029 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"contrat (datec, fk_soc, fk_user_author, date_contrat,";
1030 $sql .=
" fk_commercial_signature, fk_commercial_suivi, fk_projet,";
1031 $sql .=
" ref, entity, note_private, note_public, ref_customer, ref_supplier, ref_ext)";
1032 $sql .=
" VALUES ('".$this->db->idate($now).
"', ".((int) $this->socid).
", ".((int) $user->id);
1033 $sql .=
", ".(dol_strlen($this->date_contrat) != 0 ?
"'".$this->db->idate($this->date_contrat).
"'" :
"NULL");
1034 $sql .=
",".($this->commercial_signature_id > 0 ? ((int) $this->commercial_signature_id) :
"NULL");
1035 $sql .=
",".($this->commercial_suivi_id > 0 ? ((int) $this->commercial_suivi_id) :
"NULL");
1036 $sql .=
",".($this->fk_project > 0 ? ((int) $this->fk_project) :
"NULL");
1037 $sql .=
", ".(dol_strlen($this->
ref) <= 0 ?
"null" :
"'".$this->db->escape($this->
ref).
"'");
1038 $sql .=
", ".((int) $conf->entity);
1039 $sql .=
", ".(!empty($this->note_private) ? (
"'".$this->db->escape($this->note_private).
"'") :
"NULL");
1040 $sql .=
", ".(!empty($this->note_public) ? (
"'".$this->db->escape($this->note_public).
"'") :
"NULL");
1041 $sql .=
", ".(!empty($this->ref_customer) ? (
"'".$this->db->escape($this->ref_customer).
"'") :
"NULL");
1042 $sql .=
", ".(!empty($this->ref_supplier) ? (
"'".$this->db->escape($this->ref_supplier).
"'") :
"NULL");
1043 $sql .=
", ".(!empty($this->ref_ext) ? (
"'".$this->db->escape($this->ref_ext).
"'") :
"NULL");
1045 $resql = $this->db->query($sql);
1050 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"contrat");
1053 $module = (
getDolGlobalString(
'CONTRACT_ADDON') ? $conf->global->CONTRACT_ADDON :
'mod_contract_serpis');
1054 if (substr($module, 0, 13) ==
'mod_contract_' && substr($module, -3) ==
'php') {
1055 $module = substr($module, 0,
dol_strlen($module) - 4);
1059 $modCodeContract =
new $module();
1060 '@phan-var-force CommonNumRefGenerator $modCodeContrat';
1062 if (!empty($modCodeContract->code_auto)) {
1064 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"contrat SET ref='(PROV".$this->
id.
")' WHERE rowid=".((int) $this->
id);
1065 if ($this->db->query($sql)) {
1067 $this->
ref =
"(PROV".$this->id.
")";
1082 $result = $this->
add_contact($this->commercial_signature_id,
'SALESREPSIGN',
'internal');
1090 $result = $this->
add_contact($this->commercial_suivi_id,
'SALESREPFOLL',
'internal');
1097 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1098 $this->linked_objects = $this->linkedObjectsIds;
1102 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1103 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1104 if (is_array($tmp_origin_id)) {
1105 foreach ($tmp_origin_id as $origin_id) {
1108 $this->error = $this->db->lasterror();
1113 $origin_id = $tmp_origin_id;
1116 $this->error = $this->db->lasterror();
1123 if (!$error && $this->
id &&
getDolGlobalString(
'MAIN_PROPAGATE_CONTACTS_FROM_ORIGIN') && !empty($this->origin) && !empty($this->origin_id)) {
1124 $originforcontact = $this->origin;
1125 $originidforcontact = $this->origin_id;
1126 if ($originforcontact ==
'shipping') {
1127 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
1129 $exp->fetch($this->origin_id);
1130 $exp->fetchObjectLinked();
1131 if (count($exp->linkedObjectsIds[
'commande']) > 0) {
1132 foreach ($exp->linkedObjectsIds[
'commande'] as $key => $value) {
1133 $originforcontact =
'commande';
1134 $originidforcontact = $value;
1140 $sqlcontact =
"SELECT ctc.code, ctc.source, ec.fk_socpeople FROM ".MAIN_DB_PREFIX.
"element_contact as ec, ".MAIN_DB_PREFIX.
"c_type_contact as ctc";
1141 $sqlcontact .=
" WHERE element_id = ".((int) $originidforcontact).
" AND ec.fk_c_type_contact = ctc.rowid AND ctc.element = '".$this->db->escape($originforcontact).
"'";
1143 $resqlcontact = $this->db->query($sqlcontact);
1144 if ($resqlcontact) {
1145 while ($objcontact = $this->db->fetch_object($resqlcontact)) {
1146 if ($objcontact->source ==
'internal' && in_array($objcontact->code, array(
'SALESREPSIGN',
'SALESREPFOLL'))) {
1150 $this->
add_contact($objcontact->fk_socpeople, $objcontact->code, $objcontact->source);
1160 $result = $this->
call_trigger(
'CONTRACT_CREATE', $user);
1167 $this->db->commit();
1170 dol_syslog(get_class($this).
"::create - 30 - ".$this->error, LOG_ERR);
1171 $this->db->rollback();
1175 $this->error =
"Failed to add contract";
1176 dol_syslog(get_class($this).
"::create - 20 - ".$this->error, LOG_ERR);
1177 $this->db->rollback();
1181 $this->error = $langs->trans(
"UnknownError").
": ".$this->db->error();
1182 dol_syslog(get_class($this).
"::create - 10 - ".$this->error, LOG_ERR);
1184 $this->db->rollback();
1196 public function delete($user)
1200 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1207 $result = $this->
call_trigger(
'CONTRACT_DELETE', $user);
1217 dol_syslog(get_class($this).
"::delete error", LOG_ERR);
1233 $main = MAIN_DB_PREFIX.
'contratdet';
1234 $ef = $main.
"_extrafields";
1235 $sql =
"DELETE FROM ".$ef.
" WHERE fk_object IN (SELECT rowid FROM ".$main.
" WHERE fk_contrat = ".((int) $this->
id).
")";
1237 dol_syslog(get_class($this).
"::delete contratdet_extrafields", LOG_DEBUG);
1238 $resql = $this->db->query($sql);
1240 $this->error = $this->db->error();
1247 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"contratdet";
1248 $sql .=
" WHERE fk_contrat=".((int) $this->
id);
1250 dol_syslog(get_class($this).
"::delete contratdet", LOG_DEBUG);
1251 $resql = $this->db->query($sql);
1253 $this->error = $this->db->error();
1260 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
"ecm_files WHERE src_object_type = '".$this->db->escape($this->table_element.(empty($this->module) ?
"" :
"@".$this->module)).
"' AND src_object_id = ".((int) $this->
id);
1261 $resql = $this->db->query($sql);
1263 $this->error = $this->db->lasterror();
1264 $this->errors[] = $this->error;
1271 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"contrat";
1272 $sql .=
" WHERE rowid=".((int) $this->
id);
1274 dol_syslog(get_class($this).
"::delete contrat", LOG_DEBUG);
1275 $resql = $this->db->query($sql);
1277 $this->error = $this->db->error();
1287 dol_syslog(get_class($this).
"::delete error -3 ".$this->error, LOG_ERR);
1294 if ($conf->contrat->dir_output) {
1295 $dir = $conf->contrat->multidir_output[$this->entity].
"/".$ref;
1296 if (file_exists($dir)) {
1299 $this->error =
'ErrorFailToDeleteDir';
1307 $this->db->commit();
1310 $this->error = $this->db->lasterror();
1311 $this->db->rollback();
1323 public function update($user, $notrigger = 0)
1329 if (empty($this->fk_commercial_signature) && $this->commercial_signature_id > 0) {
1330 $this->fk_commercial_signature = $this->commercial_signature_id;
1332 if (empty($this->fk_commercial_suivi) && $this->commercial_suivi_id > 0) {
1333 $this->fk_commercial_suivi = $this->commercial_suivi_id;
1335 if (empty($this->socid) && $this->fk_soc > 0) {
1336 $this->socid = (int) $this->fk_soc;
1338 if (empty($this->fk_project) && $this->projet > 0) {
1339 $this->fk_project = (int) $this->projet;
1342 if (isset($this->
ref)) {
1343 $this->
ref = trim($this->
ref);
1345 if (isset($this->ref_customer)) {
1346 $this->ref_customer = trim($this->ref_customer);
1348 if (isset($this->ref_supplier)) {
1349 $this->ref_supplier = trim($this->ref_supplier);
1351 if (isset($this->ref_ext)) {
1352 $this->ref_ext = trim($this->ref_ext);
1354 if (isset($this->entity)) {
1355 $this->entity = (int) $this->entity;
1357 if (isset($this->
statut)) {
1360 if (isset($this->
status)) {
1363 if (isset($this->socid)) {
1364 $this->socid = (int) $this->socid;
1366 if (isset($this->fk_commercial_signature)) {
1367 $this->fk_commercial_signature = trim($this->fk_commercial_signature);
1369 if (isset($this->fk_commercial_suivi)) {
1370 $this->fk_commercial_suivi = trim($this->fk_commercial_suivi);
1372 if (isset($this->note_private)) {
1373 $this->note_private = trim($this->note_private);
1375 if (isset($this->note_public)) {
1376 $this->note_public = trim($this->note_public);
1378 if (isset($this->import_key)) {
1379 $this->import_key = trim($this->import_key);
1386 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contrat SET";
1387 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1388 $sql .=
" ref_customer=".(isset($this->ref_customer) ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null").
",";
1389 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1390 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1391 $sql .=
" entity=".$conf->entity.
",";
1392 $sql .=
" date_contrat=".(dol_strlen($this->date_contrat) != 0 ?
"'".$this->db->idate($this->date_contrat).
"'" :
'null').
",";
1394 $sql .=
" fk_soc=".($this->socid > 0 ? $this->socid :
"null").
",";
1395 $sql .=
" fk_projet=".($this->fk_project > 0 ? $this->fk_project :
"null").
",";
1396 $sql .=
" fk_commercial_signature=".(isset($this->fk_commercial_signature) ? $this->fk_commercial_signature :
"null").
",";
1397 $sql .=
" fk_commercial_suivi=".(isset($this->fk_commercial_suivi) ? $this->fk_commercial_suivi :
"null").
",";
1398 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1399 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1400 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1402 $sql .=
" WHERE rowid=".((int) $this->
id);
1406 $resql = $this->db->query($sql);
1409 $this->errors[] =
"Error ".$this->db->lasterror();
1419 if (!$error && !$notrigger) {
1421 $result = $this->
call_trigger(
'CONTRACT_MODIFY', $user);
1430 foreach ($this->errors as $errmsg) {
1431 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1432 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1434 $this->db->rollback();
1437 $this->db->commit();
1466 public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1, $txlocaltax2, $fk_product, $remise_percent, $date_start, $date_end, $price_base_type =
'HT', $pu_ttc = 0.0, $info_bits = 0, $fk_fournprice =
null, $pa_ht = 0, $array_options = array(), $fk_unit =
null, $rang = 0)
1468 global $user, $langs, $conf, $mysoc;
1471 dol_syslog(get_class($this).
"::addline $desc, $pu_ht, $qty, $txtva, $txlocaltax1, $txlocaltax2, $fk_product, $remise_percent, $date_start, $date_end, $price_base_type, $pu_ttc, $info_bits, $rang");
1474 if ($fk_product <= 0 && empty($desc)) {
1475 $this->error =
"ErrorDescRequiredForFreeProductLines";
1479 if ($this->
statut >= 0) {
1488 if (preg_match(
'/\((.*)\)/', (
string) $txtva, $reg)) {
1489 $vat_src_code = $reg[1];
1490 $txtva = preg_replace(
'/\s*\(.*\)/',
'', (
string) $txtva);
1496 $remise_percent =
price2num($remise_percent);
1501 if (empty($info_bits)) {
1504 if (empty($pu_ht) || !is_numeric($pu_ht)) {
1507 if (empty($pu_ttc)) {
1510 if (empty($txtva) || !is_numeric($txtva)) {
1513 if (empty($txlocaltax1) || !is_numeric($txlocaltax1)) {
1516 if (empty($txlocaltax2) || !is_numeric($txlocaltax2)) {
1520 if ($price_base_type ==
'HT') {
1527 if (empty($remise_percent)) {
1528 $remise_percent = 0;
1534 if ($date_start && $date_end && $date_start > $date_end) {
1535 $langs->load(
"errors");
1536 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1542 $localtaxes_type =
getLocalTaxesFromRate($txtva.($vat_src_code ?
' ('.$vat_src_code.
')' :
''), 0, $this->societe, $mysoc);
1549 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, 1, $mysoc, $localtaxes_type);
1550 $total_ht = $tabprice[0];
1551 $total_tva = $tabprice[1];
1552 $total_ttc = $tabprice[2];
1553 $total_localtax1 = $tabprice[9];
1554 $total_localtax2 = $tabprice[10];
1556 $localtax1_type = $localtaxes_type[0];
1557 $localtax2_type = $localtaxes_type[2];
1564 $remise = round(($pu_ht * $remise_percent / 100), 2);
1565 $price = $pu_ht - $remise;
1568 if (empty($pa_ht)) {
1575 $result = $this->
defineBuyPrice($pu_ht, $remise_percent, $fk_product);
1584 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"contratdet";
1585 $sql .=
" (fk_contrat, label, description, fk_product, qty, tva_tx, vat_src_code,";
1586 $sql .=
" localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice,";
1587 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc,";
1588 $sql .=
" info_bits,";
1589 $sql .=
" price_ht, remise, fk_product_fournisseur_price, buy_price_ht";
1590 if ($date_start > 0) {
1591 $sql .=
",date_ouverture_prevue";
1593 if ($date_end > 0) {
1594 $sql .=
",date_fin_validite";
1596 $sql .=
", fk_unit";
1598 $sql .=
") VALUES (";
1599 $sql .= $this->
id.
", '', '".$this->db->escape($desc).
"',";
1600 $sql .= ($fk_product > 0 ? $fk_product :
"null").
",";
1601 $sql .=
" ".((float) $qty).
",";
1602 $sql .=
" ".((float) $txtva).
",";
1603 $sql .=
" ".($vat_src_code ?
"'".$this->db->escape($vat_src_code).
"'" :
"null").
",";
1604 $sql .=
" ".((float) $txlocaltax1).
",";
1605 $sql .=
" ".((float) $txlocaltax2).
",";
1606 $sql .=
" '".$this->db->escape($localtax1_type).
"',";
1607 $sql .=
" '".$this->db->escape($localtax2_type).
"',";
1608 $sql .=
" ".price2num($remise_percent).
",";
1609 $sql .=
" ".price2num($pu_ht).
",";
1611 $sql .=
" ".((int) $info_bits).
",";
1612 $sql .=
" ".price2num($price).
",".
price2num($remise).
",";
1613 if (isset($fk_fournprice)) {
1614 $sql .=
' '.((int) $fk_fournprice).
',';
1618 if (isset($pa_ht)) {
1619 $sql .=
' '.price2num($pa_ht);
1623 if ($date_start > 0) {
1624 $sql .=
",'".$this->db->idate($date_start).
"'";
1626 if ($date_end > 0) {
1627 $sql .=
",'".$this->db->idate($date_end).
"'";
1629 $sql .=
", ".($fk_unit ?
"'".$this->db->escape($fk_unit).
"'" :
"null");
1630 $sql .=
", ".(!empty($rang) ? (int) $rang :
"0");
1633 $resql = $this->db->query($sql);
1635 $contractlineid = $this->db->last_insert_id(MAIN_DB_PREFIX.
"contratdet");
1639 $contractline->array_options = $array_options;
1640 $contractline->id = $contractlineid;
1641 $result = $contractline->insertExtraFields();
1643 $this->errors = array_merge($this->errors, $contractline->errors);
1644 $this->error = $contractline->error;
1649 if (empty($error)) {
1651 $result = $this->
call_trigger(
'LINECONTRACT_INSERT', $user);
1659 $this->db->rollback();
1662 $this->db->commit();
1663 return $contractlineid;
1666 $this->db->rollback();
1667 $this->error = $this->db->error().
" sql=".$sql;
1671 dol_syslog(get_class($this).
"::addline ErrorTryToAddLineOnValidatedContract", LOG_ERR);
1700 public function updateline($rowid, $desc, $pu, $qty, $remise_percent, $date_start, $date_end, $tvatx, $localtax1tx = 0.0, $localtax2tx = 0.0, $date_start_real =
'', $date_end_real =
'', $price_base_type =
'HT', $info_bits = 0, $fk_fournprice =
null, $pa_ht = 0, $array_options = array(), $fk_unit =
null, $rang = 0)
1702 global $user, $conf, $langs, $mysoc;
1707 $qty = trim((
string) $qty);
1708 $desc = trim($desc);
1709 $desc = trim($desc);
1715 if (empty($fk_fournprice)) {
1725 $remise = round(($pu * $remise_percent / 100), 2);
1726 $price = $pu - $remise;
1728 $remise_percent = 0;
1731 if ($date_start && $date_end && $date_start > $date_end) {
1732 $langs->load(
"errors");
1733 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1737 dol_syslog(get_class($this).
"::updateline $rowid, $desc, $pu, $qty, $remise_percent, $date_start, $date_end, $date_start_real, $date_end_real, $tvatx, $localtax1tx, $localtax2tx, $price_base_type, $info_bits, $rang");
1747 $tvatx = preg_replace(
'/\s*\(.*\)/',
'', $tvatx);
1749 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $tvatx, $localtax1tx, $localtax2tx, 0, $price_base_type, $info_bits, 1, $mysoc, $localtaxes_type);
1750 $total_ht = $tabprice[0];
1751 $total_tva = $tabprice[1];
1752 $total_ttc = $tabprice[2];
1753 $total_localtax1 = $tabprice[9];
1754 $total_localtax2 = $tabprice[10];
1756 $localtax1_type = (empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0]);
1757 $localtax2_type = (empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2]);
1764 $remise = round(($pu * $remise_percent / 100), 2);
1765 $price = $pu - $remise;
1768 if (empty($pa_ht)) {
1782 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet set description = '".$this->db->escape($desc).
"'";
1783 $sql .=
",price_ht = ".((float)
price2num($price));
1784 $sql .=
",subprice = ".((float)
price2num($subprice));
1785 $sql .=
",remise = ".((float)
price2num($remise));
1786 $sql .=
",remise_percent = ".((float)
price2num($remise_percent));
1787 $sql .=
",qty = ".((float) $qty);
1788 $sql .=
",tva_tx = ".((float)
price2num($tvatx));
1789 $sql .=
",localtax1_tx = ".((float)
price2num($localtax1tx));
1790 $sql .=
",localtax2_tx = ".((float)
price2num($localtax2tx));
1791 $sql .=
",localtax1_type='".$this->db->escape($localtax1_type).
"'";
1792 $sql .=
",localtax2_type='".$this->db->escape($localtax2_type).
"'";
1793 $sql .=
", total_ht = ".((float)
price2num($total_ht));
1794 $sql .=
", total_tva = ".((float)
price2num($total_tva));
1795 $sql .=
", total_localtax1 = ".((float)
price2num($total_localtax1));
1796 $sql .=
", total_localtax2 = ".((float)
price2num($total_localtax2));
1797 $sql .=
", total_ttc = ".((float)
price2num($total_ttc));
1798 $sql .=
", fk_product_fournisseur_price=".($fk_fournprice > 0 ? $fk_fournprice :
"null");
1799 $sql .=
", buy_price_ht = ".((float)
price2num($pa_ht));
1800 if ($date_start > 0) {
1801 $sql .=
",date_ouverture_prevue = '".$this->db->idate($date_start).
"'";
1803 $sql .=
",date_ouverture_prevue = null";
1805 if ($date_end > 0) {
1806 $sql .=
",date_fin_validite = '".$this->db->idate($date_end).
"'";
1808 $sql .=
",date_fin_validite = null";
1810 if ($date_start_real > 0) {
1811 $sql .=
",date_ouverture = '".$this->db->idate($date_start_real).
"'";
1813 $sql .=
",date_ouverture = null";
1815 if ($date_end_real > 0) {
1816 $sql .=
",date_cloture = '".$this->db->idate($date_end_real).
"'";
1818 $sql .=
",date_cloture = null";
1820 $sql .=
", fk_unit = ".($fk_unit > 0 ? ((int) $fk_unit) :
"null");
1821 $sql .=
", rang = ".(!empty($rang) ? ((int) $rang) :
"0");
1822 $sql .=
" WHERE rowid = ".((int) $rowid);
1824 dol_syslog(get_class($this).
"::updateline", LOG_DEBUG);
1825 $result = $this->db->query($sql);
1827 if (is_array($array_options) && count($array_options) > 0) {
1829 $contractline->fetch($rowid);
1832 foreach ($array_options as $key => $value) {
1833 $contractline->array_options[$key] = $array_options[$key];
1836 $result = $contractline->insertExtraFields();
1838 $this->errors[] = $contractline->error;
1843 if (empty($error)) {
1845 $result = $this->
call_trigger(
'LINECONTRACT_MODIFY', $user);
1847 $this->db->rollback();
1852 $this->db->commit();
1855 $this->db->rollback();
1859 $this->db->rollback();
1860 $this->error = $this->db->error();
1861 dol_syslog(get_class($this).
"::updateline Erreur -1");
1877 if ($this->
statut >= 0) {
1879 $result = $this->
call_trigger(
'LINECONTRACT_DELETE', $user);
1887 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$this->table_element_line;
1888 $sql .=
" WHERE rowid = ".((int) $idline);
1890 dol_syslog(get_class($this).
"::deleteline", LOG_DEBUG);
1891 $resql = $this->db->query($sql);
1893 $this->error =
"Error ".$this->db->lasterror();
1900 $contractline->id = $idline;
1901 $result = $contractline->deleteExtraFields();
1904 $this->error =
"Error ".get_class($this).
"::deleteline deleteExtraFields error -4 ".$contractline->error;
1908 if (empty($error)) {
1909 $this->db->commit();
1912 dol_syslog(get_class($this).
"::deleteline ERROR:".$this->error, LOG_ERR);
1913 $this->db->rollback();
1917 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
1934 dol_syslog(__METHOD__.
" is deprecated", LOG_WARNING);
1937 if ($this->
statut == 0) {
1978 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
1980 $langs->load(
"contracts");
1981 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'ContractStatusDraft');
1982 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'ContractStatusValidated');
1983 $this->labelStatus[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv(
'ContractStatusClosed');
1984 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'ContractStatusDraft');
1985 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'ContractStatusValidated');
1986 $this->labelStatusShort[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv(
'ContractStatusClosed');
1989 $statusType =
'status'.$status;
1990 if ($status == self::STATUS_VALIDATED) {
1991 $statusType =
'status6';
1994 if ($mode == 4 || $mode == 6 || $mode == 7) {
1997 $text =
'<span class="hideonsmartphone">';
1998 $text .= ($this->nbofserviceswait + $this->nbofservicesopened + $this->nbofservicesexpired + $this->nbofservicesclosed);
1999 $text .=
' '.$langs->trans(
"Services");
2000 $text .=
': ';
2003 $text .= ($mode == 7 ?
'<span class="nowraponall">' :
'');
2004 $text .= ($mode != 7 || $this->nbofserviceswait > 0) ? ($this->nbofserviceswait.ContratLigne::LibStatut(0, 3, -1,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesopened || $this->nbofservicesexpired || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2005 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2006 $text .= ($mode != 7 || $this->nbofservicesopened > 0) ? ($this->nbofservicesopened.ContratLigne::LibStatut(4, 3, 0,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesexpired || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2007 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2008 $text .= ($mode != 7 || $this->nbofservicesexpired > 0) ? ($this->nbofservicesexpired.ContratLigne::LibStatut(4, 3, 1,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2009 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2010 $text .= ($mode != 7 || $this->nbofservicesclosed > 0) ? ($this->nbofservicesclosed.ContratLigne::LibStatut(5, 3, -1,
'class="marginleft2"')) :
'';
2011 $text .= ($mode == 7 ?
'</span>' :
'');
2014 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
2026 global $conf, $langs, $user;
2028 $langs->load(
'contracts');
2031 $nofetch = !empty($params[
'nofetch']);
2034 return [
'optimize' => $langs->trans(
"ShowContract")];
2036 if ($user->hasRight(
'contrat',
'lire')) {
2037 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Contract").
'</u>';
2042 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.($this->
ref ? $this->
ref : $this->id);
2044 $langs->load(
'companies');
2045 if (empty($this->thirdparty)) {
2048 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
2050 $datas[
'refcustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '. $this->ref_customer;
2052 $langs->load(
'project');
2053 if (is_null($this->project) || (is_object($this->project) && $this->project->isEmpty())) {
2055 if ($res > 0 && $this->project instanceof
Project) {
2056 $datas[
'project'] =
'<br><b>'.$langs->trans(
'Project').
':</b> '.$this->project->getNomUrl(1,
'', 0, 1);
2060 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
2061 if (!empty($this->total_ht)) {
2062 $datas[
'amountht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
2064 if (!empty($this->total_tva)) {
2065 $datas[
'vatamount'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
2067 if (!empty($this->total_ttc)) {
2068 $datas[
'amounttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
2083 public function getNomUrl($withpicto = 0, $maxlength = 0, $notooltip = 0, $save_lastsearch_value = -1)
2085 global $conf, $langs, $user, $hookmanager;
2089 $url = DOL_URL_ROOT.
'/contrat/card.php?id='.$this->id;
2094 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2095 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2096 $add_save_lastsearch_values = 1;
2098 if ($add_save_lastsearch_values) {
2099 $url .=
'&save_lastsearch_values=1';
2104 'objecttype' => $this->element,
2107 $classfortooltip =
'classfortooltip';
2110 $classfortooltip =
'classforajaxtooltip';
2111 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2118 if (empty($notooltip) && $user->hasRight(
'contrat',
'lire')) {
2120 $label = $langs->trans(
"ShowContract");
2121 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
2123 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
2124 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2126 $linkstart =
'<a href="'.$url.
'"';
2127 $linkstart .= $linkclose.
'>';
2130 $result .= $linkstart;
2132 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
2134 if ($withpicto != 2) {
2135 $result .= ($this->
ref ? $this->
ref : $this->id);
2137 $result .= $linkend;
2140 $hookmanager->initHooks(array(
'contractdao'));
2141 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2142 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2144 $result = $hookmanager->resPrint;
2146 $result .= $hookmanager->resPrint;
2160 $sql =
"SELECT c.rowid, c.ref, c.datec,";
2161 $sql .=
" c.tms as date_modification,";
2162 $sql .=
" fk_user_author";
2163 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2164 $sql .=
" WHERE c.rowid = ".((int) $id);
2166 $result = $this->db->query($sql);
2168 if ($this->db->num_rows($result)) {
2169 $obj = $this->db->fetch_object($result);
2171 $this->
id = $obj->rowid;
2172 $this->
ref = (!$obj->ref) ? $obj->rowid : $obj->ref;
2174 $this->user_creation_id = $obj->fk_user_author;
2175 $this->date_creation = $this->db->jdate($obj->datec);
2176 $this->date_modification = $this->db->jdate($obj->date_modification);
2179 $this->db->free($result);
2197 $sql =
"SELECT cd.rowid";
2198 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet as cd";
2199 $sql .=
" WHERE fk_contrat =".((int) $this->
id);
2201 $sql .=
" AND statut = ".((int) $status);
2204 dol_syslog(get_class($this).
"::array_detail()", LOG_DEBUG);
2205 $resql = $this->db->query($sql);
2207 $num = $this->db->num_rows($resql);
2210 $obj = $this->db->fetch_object($resql);
2211 $tab[$i] = $obj->rowid;
2216 $this->error = $this->db->error();
2230 public function getListOfContracts($option =
'all', $status = [], $product_categories = [], $line_status = [])
2234 $sql =
"SELECT c.rowid";
2235 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2236 if (!empty($product_categories)) {
2237 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"contratdet as cd ON cd.fk_contrat = c.rowid";
2238 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"categorie_product as cp ON cp.fk_product = cd.fk_product AND cp.fk_categorie IN (".$this->db->sanitize(implode(
', ', $product_categories)).
")";
2240 $sql .=
" WHERE c.fk_soc =".((int) $this->socid);
2241 $sql .= ($option ==
'others') ?
" AND c.rowid <> ".((
int) $this->id) :
"";
2242 $sql .= (!empty($status)) ?
" AND c.statut IN (".$this->db->sanitize(implode(
', ', $status)).
")" :
"";
2243 $sql .= (!empty($line_status)) ?
" AND cd.statut IN (".$this->db->sanitize(implode(
', ', $line_status)).
")" :
"";
2244 $sql .=
" GROUP BY c.rowid";
2246 dol_syslog(get_class($this).
"::getOtherContracts()", LOG_DEBUG);
2247 $resql = $this->db->query($sql);
2249 $num = $this->db->num_rows($resql);
2252 $obj = $this->db->fetch_object($resql);
2253 $contrat =
new Contrat($this->db);
2254 $contrat->fetch($obj->rowid);
2255 $tab[$contrat->id] = $contrat;
2260 $this->error = $this->db->lasterror();
2277 global $conf, $langs;
2279 $this->from =
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2280 $this->from .=
", ".MAIN_DB_PREFIX.
"contratdet as cd";
2281 $this->from .=
", ".MAIN_DB_PREFIX.
"societe as s";
2282 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2283 $this->from .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
2286 if ($mode ==
'inactive') {
2287 $sql =
"SELECT cd.rowid, cd.date_ouverture_prevue as datefin";
2288 $sql .= $this->from;
2289 $sql .=
" WHERE c.statut = 1";
2290 $sql .=
" AND c.rowid = cd.fk_contrat";
2291 $sql .=
" AND cd.statut = 0";
2292 } elseif ($mode ==
'expired') {
2293 $sql =
"SELECT cd.rowid, cd.date_fin_validite as datefin";
2294 $sql .= $this->from;
2295 $sql .=
" WHERE c.statut = 1";
2296 $sql .=
" AND c.rowid = cd.fk_contrat";
2297 $sql .=
" AND cd.statut = 4";
2298 $sql .=
" AND cd.date_fin_validite < '".$this->db->idate(
dol_now()).
"'";
2299 } elseif ($mode ==
'active') {
2300 $sql =
"SELECT cd.rowid, cd.date_fin_validite as datefin";
2301 $sql .= $this->from;
2302 $sql .=
" WHERE c.statut = 1";
2303 $sql .=
" AND c.rowid = cd.fk_contrat";
2304 $sql .=
" AND cd.statut = 4";
2308 $sql .=
" AND c.fk_soc = s.rowid";
2309 $sql .=
" AND c.entity = ".((int) $conf->entity);
2311 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
2313 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2314 $sql .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
2317 $resql = $this->db->query($sql);
2319 $langs->load(
"contracts");
2322 if ($mode ==
'inactive') {
2323 $warning_delay = $conf->contrat->services->inactifs->warning_delay;
2324 $label = $langs->trans(
"BoardNotActivatedServices");
2325 $labelShort = $langs->trans(
"BoardNotActivatedServicesShort");
2326 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=0&sortfield=cd.date_fin_validite&sortorder=asc';
2327 } elseif ($mode ==
'expired') {
2328 $warning_delay = $conf->contrat->services->expires->warning_delay;
2329 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=4&filter=expired&sortfield=cd.date_fin_validite&sortorder=asc';
2330 $label = $langs->trans(
"BoardExpiredServices");
2331 $labelShort = $langs->trans(
"BoardExpiredServicesShort");
2333 $warning_delay = $conf->contrat->services->expires->warning_delay;
2334 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=4&sortfield=cd.date_fin_validite&sortorder=asc';
2337 $label = $langs->trans(
"BoardRunningServices");
2338 $labelShort = $langs->trans(
"BoardRunningServicesShort");
2342 $response->warning_delay = $warning_delay / 60 / 60 / 24;
2343 $response->label = $label;
2344 $response->labelShort = $labelShort;
2345 $response->url = $url;
2348 while ($obj = $this->db->fetch_object($resql)) {
2349 $response->nbtodo++;
2351 if ($obj->datefin && $this->db->jdate($obj->datefin) < ($now - $warning_delay)) {
2352 $response->nbtodolate++;
2359 $this->error = $this->db->error();
2371 global $conf, $user;
2373 $this->nb = array();
2376 $sql =
"SELECT count(c.rowid) as nb";
2377 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2378 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON c.fk_soc = s.rowid";
2379 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2380 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2381 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2384 $sql .=
" ".$clause.
" c.entity = ".$conf->entity;
2386 $resql = $this->db->query($sql);
2388 while ($obj = $this->db->fetch_object($resql)) {
2389 $this->nb[
"contracts"] = $obj->nb;
2391 $this->db->free($resql);
2395 $this->error = $this->db->error();
2433 global $user, $langs, $conf;
2438 $sql =
"SELECT rowid";
2439 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
2440 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
2441 $sql .=
" AND tosell = 1";
2442 $sql .= $this->db->plimit(100);
2444 $resql = $this->db->query($sql);
2446 $num_prods = $this->db->num_rows($resql);
2448 while ($i < $num_prods) {
2450 $row = $this->db->fetch_row($resql);
2451 $prodids[$i] = $row[0];
2457 $this->specimen = 1;
2459 $this->
ref =
'SPECIMEN';
2460 $this->ref_customer =
'SPECIMENCUST';
2461 $this->ref_supplier =
'SPECIMENSUPP';
2464 $this->date_creation = (
dol_now() - 3600 * 24 * 7);
2465 $this->date_contrat =
dol_now();
2466 $this->commercial_signature_id = 1;
2467 $this->commercial_suivi_id = 1;
2468 $this->note_private =
'This is a comment (private)';
2469 $this->note_public =
'This is a comment (public)';
2470 $this->fk_project = 0;
2474 while ($xnbp < $nbp) {
2477 $line->subprice = 100;
2478 $line->tva_tx = 19.6;
2479 $line->remise_percent = 10;
2480 $line->total_ht = 90;
2481 $line->total_ttc = 107.64;
2482 $line->total_tva = 17.64;
2483 $line->date_start =
dol_now() - 500000;
2484 $line->date_start_real =
dol_now() - 200000;
2485 $line->date_end =
dol_now() + 500000;
2486 $line->date_end_real =
dol_now() - 100000;
2487 if ($num_prods > 0) {
2488 $prodid = mt_rand(1, $num_prods);
2489 $line->fk_product = $prodids[$prodid];
2491 $this->lines[$xnbp] = $line;
2517 $ticket =
new Ticket($this->db);
2518 $nbTicket = $ticket->fetchAll($user,
'ASC',
't.datec',
'', 0,
'', array(
't.fk_contract' => $this->
id));
2520 return ($nbTicket < 0 ? $nbTicket : $ticket->lines);
2535 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2537 global $conf, $langs;
2542 if (!empty($this->model_pdf)) {
2543 $modele = $this->model_pdf;
2549 if (empty($modele)) {
2552 $langs->load(
"contracts");
2553 $outputlangs->load(
"products");
2555 $modelpath =
"core/modules/contract/doc/";
2556 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2604 global $db, $langs, $conf, $hookmanager, $extrafields;
2610 $this->
fetch($this->
id);
2613 $clonedObj = clone $this;
2614 $clonedObj->socid = $socid;
2618 $objsoc =
new Societe($this->db);
2620 $objsoc->fetch($clonedObj->socid);
2623 $clonedObj->statut = 0;
2625 if (is_array($clonedObj->array_options) && count($clonedObj->array_options) > 0) {
2626 $extrafields->fetch_name_optionals_label($this->table_element);
2627 foreach ($clonedObj->array_options as $key => $option) {
2628 $shortkey = preg_replace(
'/options_/',
'', $key);
2630 if (!empty($extrafields->attributes[$this->element][
'unique'][$shortkey])) {
2632 unset($clonedObj->array_options[$key]);
2638 $this->error =
'ErrorSetupNotComplete';
2644 require_once DOL_DOCUMENT_ROOT.
"/core/modules/contract/" .
getDolGlobalString(
'CONTRACT_ADDON').
'.php';
2646 $modContract =
new $obj();
2647 '@phan-var-force CommonNumRefGenerator $modContrat';
2648 $clonedObj->ref = $modContract->getNextValue($objsoc, $clonedObj);
2651 foreach ($this->lines as $line) {
2652 $line->fetch_optionals($line->id);
2656 $clonedObj->context[
'createfromclone'] =
'createfromclone';
2657 $result = $clonedObj->create($user);
2660 $this->error = $clonedObj->error;
2661 $this->errors[] = $clonedObj->error;
2664 if ($this->socid == $clonedObj->socid) {
2665 if ($clonedObj->copy_linked_contact($this,
'external') < 0) {
2672 foreach ($this->lines as $line) {
2673 $result = $clonedObj->addline($line->description, $line->subprice, $line->qty, $line->tva_tx, $line->localtax1_tx, $line->localtax2_tx, $line->fk_product, $line->remise_percent, $line->date_start, $line->date_cloture,
'HT', 0, $line->info_bits, $line->fk_fournprice, $line->pa_ht, $line->array_options, $line->fk_unit, $line->rang);
2676 $this->error = $clonedObj->error;
2677 $this->errors[] = $clonedObj->error;
2684 if (is_object($hookmanager)) {
2685 $parameters = array(
2687 'clonedObj' => $clonedObj
2690 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $clonedObj, $action);
2698 unset($clonedObj->context[
'createfromclone']);
2702 $this->db->commit();
2703 return $clonedObj->id;
2705 $this->db->rollback();
2722 global $langs, $user;
2724 $langs->load(
"agenda");
2734 $contractlineprocessed = array();
2735 $contractignored = array();
2736 $contracterror = array();
2740 $sql =
'SELECT c.rowid, c.ref_customer, cd.rowid as lid, cd.date_fin_validite, p.duration';
2741 $sql .=
' FROM '.MAIN_DB_PREFIX.
'contrat as c, '.MAIN_DB_PREFIX.
'contratdet as cd';
2742 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON p.rowid = cd.fk_product';
2743 $sql .=
' WHERE cd.fk_contrat = c.rowid';
2744 $sql .=
" AND date_format(cd.date_fin_validite, '%Y-%m-%d') <= date_format('".$this->db->idate($enddatetoscan).
"', '%Y-%m-%d')";
2745 $sql .=
" AND cd.statut = 4";
2746 if ($thirdparty_id > 0) {
2747 $sql .=
" AND c.fk_soc = ".((int) $thirdparty_id);
2751 $resql = $this->db->query($sql);
2753 $num = $this->db->num_rows($resql);
2755 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
2759 $obj = $this->db->fetch_object($resql);
2761 if (!empty($contractlineprocessed[$obj->lid]) || !empty($contractignored[$obj->rowid]) || !empty($contracterror[$obj->rowid])) {
2772 $this->errors[] =
'Failed to load contract with id='.$obj->rowid;
2776 dol_syslog(
"* Process contract line in doRenewalContracts for contract id=".
$object->id.
" ref=".
$object->ref.
" ref_customer=".
$object->ref_customer.
" contract line id=".$obj->lid);
2779 $expirationdate = $this->db->jdate($obj->date_fin_validite);
2780 $duration_value = preg_replace(
'/[^0-9]/',
'', $obj->duration);
2781 $duration_unit = preg_replace(
'/\d/',
'', $obj->duration);
2786 $object->fetchObjectLinked(
null,
'',
null,
'',
'OR', 1,
'sourcetype', 1);
2789 if (isset(
$object->linkedObjects[
'facture']) && is_array(
$object->linkedObjects[
'facture']) && count(
$object->linkedObjects[
'facture']) > 0) {
2791 usort(
$object->linkedObjects[
'facture'], array(
'Contrat',
'contractCmpDate'));
2794 $someinvoicenotpaid = 0;
2795 foreach (
$object->linkedObjects[
'facture'] as $idinvoice => $invoice) {
2800 if (empty($invoice->paye)) {
2801 $someinvoicenotpaid++;
2804 if ($someinvoicenotpaid) {
2805 $this->output .=
'Contract '.$object->ref.
' is qualified for renewal but there is '.$someinvoicenotpaid.
' invoice(s) unpayed so we cancel renewal'.
"\n";
2811 if ($expirationdate && $expirationdate < $enddatetoscan) {
2812 dol_syslog(
"Define the newdate of end of services from expirationdate=".$expirationdate);
2813 $newdate = $expirationdate;
2815 while ($newdate < $enddatetoscan && $protecti < 1000) {
2820 if ($protecti < 1000) {
2826 $errorforlocaltransaction = 0;
2828 $label =
'Renewal of contrat '.$object->ref.
' line '.$obj->lid;
2829 $comment =
'Renew date of contract '.$object->ref.
' line '.$obj->lid.
' by doAutoRenewContracts';
2831 $sqlupdate =
'UPDATE '.MAIN_DB_PREFIX.
"contratdet SET date_fin_validite = '".$this->db->idate($newdate).
"'";
2832 $sqlupdate .=
' WHERE rowid = '.((int) $obj->lid);
2833 $resqlupdate = $this->db->query($sqlupdate);
2835 $contractlineprocessed[$obj->lid] =
$object->ref;
2837 $actioncode =
'RENEW_CONTRACT';
2842 $actioncomm->type_code =
'AC_OTH_AUTO';
2843 $actioncomm->code =
'AC_'.$actioncode;
2844 $actioncomm->label = $label;
2845 $actioncomm->datep = $now;
2846 $actioncomm->datef = $now;
2847 $actioncomm->percentage = -1;
2848 $actioncomm->socid =
$object->socid;
2849 $actioncomm->authorid = $user->id;
2850 $actioncomm->userownerid = $user->id;
2851 $actioncomm->fk_element =
$object->id;
2852 $actioncomm->elementtype =
'contract';
2853 $actioncomm->note_private = $comment;
2855 $ret = $actioncomm->create($user);
2860 $errorforlocaltransaction++;
2861 $this->error = $this->db->lasterror();
2864 if (! $errorforlocaltransaction) {
2865 $this->db->commit();
2867 $this->db->rollback();
2871 $this->error =
"Bad value for newdate in doAutoRenewContracts - expirationdate=".$expirationdate.
" enddatetoscan=".$enddatetoscan.
" duration_value=".$duration_value.
" duration_unit=".$duration_value;
2880 $this->error = $this->db->lasterror();
2883 $this->output .= count($contractlineprocessed).
' contract line(s) with end date before '.
dol_print_date($enddatetoscan,
'day').
' were renewed'.(count($contractlineprocessed) > 0 ?
' : '.implode(
',', $contractlineprocessed) :
'');
2885 return ($error ? 1 : 0);
2897 if ($a->date == $b->date) {
2898 return strcmp((
string) $a->id, (
string) $b->id);
2900 return ($a->date < $b->date) ? -1 : 1;
2914 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2916 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2917 $return .=
'<div class="info-box info-box-sm">';
2918 $return .=
'<span class="info-box-icon bg-infobox-action">';
2920 $return .=
'</span>';
2921 $return .=
'<div class="info-box-content">';
2922 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
2923 if ($selected >= 0) {
2924 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2926 if (!empty($arraydata[
'thirdparty'])) {
2927 $tmpthirdparty = $arraydata[
'thirdparty'];
2928 $return .=
'<br><div class="info-box-label inline-block valignmiddle">'.$tmpthirdparty->getNomUrl(1).
'</div>';
2930 if (property_exists($this,
'date_contrat')) {
2931 $return .=
'<br><span class="opacitymedium valignmiddle">'.$langs->trans(
"DateContract").
' : </span><span class="info-box-label valignmiddle">'.
dol_print_date($this->date_contrat,
'day').
'</span>';
2933 if (method_exists($this,
'getLibStatut')) {
2934 $return .=
'<br><div class="info-box-status valignmiddle">'.$this->getLibStatut(7).
'</div>';
2936 $return .=
'</div>';
2937 $return .=
'</div>';
2938 $return .=
'</div>';
2969 public $element =
'contratdet';
2974 public $table_element =
'contratdet';
2990 public $element_for_permission =
'contrat';
3030 public $description;
3032 public $product_type;
3033 public $product_ref;
3034 public $product_label;
3036 public $date_commande;
3039 public $date_start_real;
3041 public $date_end_real;
3044 public $vat_src_code;
3045 public $localtax1_tx;
3046 public $localtax2_tx;
3047 public $localtax1_type;
3048 public $localtax2_type;
3050 public $remise_percent;
3056 public $fk_remise_except;
3078 public $total_localtax1;
3079 public $total_localtax2;
3085 public $fk_fournprice;
3097 public $fk_user_author;
3102 public $fk_user_ouverture;
3107 public $fk_user_cloture;
3112 public $commentaire;
3121 const STATUS_INITIAL = 0;
3122 const STATUS_OPEN = 4;
3123 const STATUS_CLOSED = 5;
3130 public $fields = array(
3131 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
3132 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 30,
'index' => 1),
3133 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 35),
3134 'qty' => array(
'type' =>
'integer',
'label' =>
'Quantity',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 35,
'isameasure' => 1),
3135 'total_ht' => array(
'type' =>
'integer',
'label' =>
'AmountHT',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 36,
'isameasure' => 1),
3136 'total_tva' => array(
'type' =>
'integer',
'label' =>
'AmountVAT',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 37,
'isameasure' => 1),
3137 'total_ttc' => array(
'type' =>
'integer',
'label' =>
'AmountTTC',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 38,
'isameasure' => 1),
3140 'fk_contrat' => array(
'type' =>
'integer:Contrat:contrat/class/contrat.class.php',
'label' =>
'Contract',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 70),
3141 'fk_product' => array(
'type' =>
'integer:Product:product/class/product.class.php:1',
'label' =>
'Product',
'enabled' => 1,
'visible' => -1,
'position' => 75),
3143 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 105),
3144 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 110),
3148 'fk_user_ouverture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserStartingService',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 135),
3149 'fk_user_cloture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserClosingService',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 135),
3150 'statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Statut',
'enabled' => 1,
'visible' => -1,
'position' => 500,
'arrayofkeyval' => array(0 =>
'Draft', 4 =>
'Open', 5 =>
'Closed')),
3151 'rang' => array(
'type' =>
'integer',
'label' =>
'Rank',
'enabled' => 1,
'visible' => 0,
'position' => 500,
'default' =>
'0')
3175 return $this->
LibStatut($this->
statut, $mode, ((!empty($this->date_end)) ? ($this->date_end <
dol_now() ? 1 : 0) : -1));
3189 public static function LibStatut($status, $mode, $expired = -1, $moreatt =
'', $morelabel =
'')
3193 $langs->load(
"contracts");
3195 if ($status == self::STATUS_INITIAL) {
3196 $labelStatus = $langs->transnoentities(
"ServiceStatusInitial");
3197 $labelStatusShort = $langs->transnoentities(
"ServiceStatusInitial");
3198 } elseif ($status == self::STATUS_OPEN && $expired == -1) {
3199 $labelStatus = $langs->transnoentities(
"ServiceStatusRunning");
3200 $labelStatusShort = $langs->transnoentities(
"ServiceStatusRunning");
3201 } elseif ($status == self::STATUS_OPEN && $expired == 0) {
3202 $labelStatus = $langs->transnoentities(
"ServiceStatusNotLate");
3203 $labelStatusShort = $langs->transnoentities(
"ServiceStatusNotLateShort");
3204 } elseif ($status == self::STATUS_OPEN && $expired == 1) {
3205 $labelStatus = $langs->transnoentities(
"ServiceStatusLate");
3206 $labelStatusShort = $langs->transnoentities(
"ServiceStatusLateShort");
3207 } elseif ($status == self::STATUS_CLOSED) {
3208 $labelStatus = $langs->transnoentities(
"ServiceStatusClosed");
3209 $labelStatusShort = $langs->transnoentities(
"ServiceStatusClosed");
3212 $statusType =
'status'.$status;
3213 if ($status == self::STATUS_OPEN && $expired == 1) {
3214 $statusType =
'status1';
3216 if ($status == self::STATUS_CLOSED) {
3217 $statusType =
'status6';
3222 if (preg_match(
'/class="(.*)"/', $moreatt, $reg)) {
3223 $params = array(
'badgeParams' => array(
'css' => $reg[1]));
3225 return dolGetStatus($labelStatus.($morelabel ?
' '.$morelabel :
''), $labelStatusShort.($morelabel ?
' '.$morelabel :
''),
'', $statusType, $mode,
'', $params);
3236 global $conf, $langs, $user;
3239 $datas[
'label'] = $langs->trans(
"ShowContractOfService").
': '.$this->label;
3240 if (empty($datas[
'label'])) {
3241 $datas[
'label'] = $this->description;
3259 $label = $langs->trans(
"ShowContractOfService").
': '.$this->label;
3260 if (empty($label)) {
3261 $label = $this->description;
3263 $classfortooltip =
'classfortooltip';
3267 'id' => $this->fk_contrat,
3268 'objecttype' => $this->element,
3270 $classfortooltip =
'classforajaxtooltip';
3271 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
3275 $link =
'<a href="'.DOL_URL_ROOT.
'/contrat/card.php?id='.$this->fk_contrat.
'"';
3276 $link .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
3277 $link .= $dataparams.
' class="'.$classfortooltip.
'">';
3281 if ($this->
type == 0) {
3286 $result .= ($link.img_object($label, $picto, $dataparams.
' class="'.$classfortooltip.
'"').$linkend);
3288 if ($withpicto && $withpicto != 2) {
3291 if ($withpicto != 2) {
3292 $result .= $link.($this->product_ref ? $this->product_ref.
' ' :
'').($this->label ? $this->label : $this->description).$linkend;
3307 if (empty($id) && empty($ref)) {
3312 $sql .=
" t.rowid,";
3314 $sql .=
" t.fk_contrat,";
3315 $sql .=
" t.fk_product,";
3316 $sql .=
" t.statut,";
3317 $sql .=
" t.label,";
3318 $sql .=
" p.ref as product_ref,";
3319 $sql .=
" p.label as product_label,";
3320 $sql .=
" p.description as product_desc,";
3321 $sql .=
" p.fk_product_type as product_type,";
3322 $sql .=
" t.description,";
3323 $sql .=
" t.date_commande,";
3324 $sql .=
" t.date_ouverture_prevue as date_start,";
3325 $sql .=
" t.date_ouverture as date_start_real,";
3326 $sql .=
" t.date_fin_validite as date_end,";
3327 $sql .=
" t.date_cloture as date_end_real,";
3328 $sql .=
" t.tva_tx,";
3329 $sql .=
" t.vat_src_code,";
3330 $sql .=
" t.localtax1_tx,";
3331 $sql .=
" t.localtax2_tx,";
3332 $sql .=
" t.localtax1_type,";
3333 $sql .=
" t.localtax2_type,";
3335 $sql .=
" t.remise_percent,";
3336 $sql .=
" t.remise,";
3337 $sql .=
" t.fk_remise_except,";
3338 $sql .=
" t.subprice,";
3339 $sql .=
" t.price_ht,";
3340 $sql .=
" t.total_ht,";
3341 $sql .=
" t.total_tva,";
3342 $sql .=
" t.total_localtax1,";
3343 $sql .=
" t.total_localtax2,";
3344 $sql .=
" t.total_ttc,";
3345 $sql .=
" t.fk_product_fournisseur_price as fk_fournprice,";
3346 $sql .=
" t.buy_price_ht as pa_ht,";
3347 $sql .=
" t.info_bits,";
3348 $sql .=
" t.fk_user_author,";
3349 $sql .=
" t.fk_user_ouverture,";
3350 $sql .=
" t.fk_user_cloture,";
3351 $sql .=
" t.commentaire,";
3352 $sql .=
" t.fk_unit,";
3354 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet as t LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON p.rowid = t.fk_product";
3356 $sql .=
" WHERE t.rowid = ".((int) $id);
3359 $sql .=
" WHERE t.rowid = '".$this->db->escape($ref).
"'";
3362 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
3363 $resql = $this->db->query($sql);
3365 if ($this->db->num_rows($resql)) {
3366 $obj = $this->db->fetch_object($resql);
3368 $this->
id = $obj->rowid;
3369 $this->
ref = $obj->rowid;
3371 $this->tms = $this->db->jdate($obj->tms);
3372 $this->fk_contrat = $obj->fk_contrat;
3373 $this->fk_product = $obj->fk_product;
3374 $this->
statut = $obj->statut;
3375 $this->product_ref = $obj->product_ref;
3376 $this->product_label = $obj->product_label;
3377 $this->product_type = $obj->product_type;
3378 $this->label = $obj->label;
3380 $this->date_commande = $this->db->jdate($obj->date_commande);
3382 $this->date_start = $this->db->jdate($obj->date_start);
3383 $this->date_start_real = $this->db->jdate($obj->date_start_real);
3384 $this->date_end = $this->db->jdate($obj->date_end);
3385 $this->date_end_real = $this->db->jdate($obj->date_end_real);
3392 $this->tva_tx = $obj->tva_tx;
3393 $this->vat_src_code = $obj->vat_src_code;
3394 $this->localtax1_tx = $obj->localtax1_tx;
3395 $this->localtax2_tx = $obj->localtax2_tx;
3396 $this->localtax1_type = $obj->localtax1_type;
3397 $this->localtax2_type = $obj->localtax2_type;
3398 $this->qty = $obj->qty;
3399 $this->remise_percent = $obj->remise_percent;
3400 $this->fk_remise_except = $obj->fk_remise_except;
3401 $this->subprice = $obj->subprice;
3402 $this->price_ht = $obj->price_ht;
3403 $this->total_ht = $obj->total_ht;
3404 $this->total_tva = $obj->total_tva;
3405 $this->total_localtax1 = $obj->total_localtax1;
3406 $this->total_localtax2 = $obj->total_localtax2;
3407 $this->total_ttc = $obj->total_ttc;
3408 $this->info_bits = $obj->info_bits;
3409 $this->fk_user_author = $obj->fk_user_author;
3410 $this->fk_user_ouverture = $obj->fk_user_ouverture;
3411 $this->fk_user_cloture = $obj->fk_user_cloture;
3412 $this->commentaire = $obj->commentaire;
3413 $this->fk_fournprice = $obj->fk_fournprice;
3415 $marginInfos =
getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->fk_fournprice, $obj->pa_ht);
3416 $this->pa_ht = $marginInfos[0];
3417 $this->fk_unit = $obj->fk_unit;
3419 $this->rang = $obj->rang;
3424 $this->db->free($resql);
3428 $this->error =
"Error ".$this->db->lasterror();
3441 public function update($user, $notrigger = 0)
3448 $this->fk_contrat = (int) $this->fk_contrat;
3449 $this->fk_product = (int) $this->fk_product;
3451 $this->label = trim($this->label);
3453 $this->vat_src_code = trim($this->vat_src_code);
3454 $this->tva_tx = trim((
string) $this->tva_tx);
3455 $this->localtax1_tx = trim($this->localtax1_tx);
3456 $this->localtax2_tx = trim($this->localtax2_tx);
3457 $this->qty = (float) $this->qty;
3458 $this->remise_percent = trim((
string) $this->remise_percent);
3459 $this->fk_remise_except = (int) $this->fk_remise_except;
3460 $this->subprice = (float)
price2num($this->subprice);
3461 $this->price_ht = (float)
price2num($this->price_ht);
3462 $this->info_bits = (int) $this->info_bits;
3463 $this->fk_user_author = (int) $this->fk_user_author;
3464 $this->fk_user_ouverture = (int) $this->fk_user_ouverture;
3465 $this->fk_user_cloture = (int) $this->fk_user_cloture;
3466 $this->commentaire = trim($this->commentaire);
3467 $this->rang = (int) $this->rang;
3469 if (empty($this->price_ht)) {
3470 $this->price_ht = 0;
3472 if (empty($this->total_ht)) {
3473 $this->total_ht = 0;
3475 if (empty($this->total_tva)) {
3476 $this->total_tva = 0;
3478 if (empty($this->total_ttc)) {
3479 $this->total_ttc = 0;
3481 if (empty($this->localtax1_tx)) {
3482 $this->localtax1_tx = 0;
3484 if (empty($this->localtax2_tx)) {
3485 $this->localtax2_tx = 0;
3487 if (empty($this->remise_percent)) {
3488 $this->remise_percent = 0;
3497 $tabprice =
calcul_price_total($this->qty, $this->price_ht, $this->remise_percent, $this->tva_tx, $this->localtax1_tx, $this->localtax2_tx, 0,
'HT', 0, 1, $mysoc, $localtaxes_type);
3498 $this->total_ht = $tabprice[0];
3499 $this->total_tva = $tabprice[1];
3500 $this->total_ttc = $tabprice[2];
3501 $this->total_localtax1 = $tabprice[9];
3502 $this->total_localtax2 = $tabprice[10];
3504 if (empty($this->pa_ht)) {
3509 if ($this->pa_ht == 0) {
3510 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3514 $this->pa_ht = $result;
3519 if (empty($this->oldcopy)) {
3520 dol_syslog(
"this->oldcopy should have been set by the caller of update (here properties were already modified)", LOG_WARNING);
3527 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET";
3528 $sql .=
" fk_contrat = ".((int) $this->fk_contrat).
",";
3529 $sql .=
" fk_product = ".($this->fk_product ? ((int) $this->fk_product) :
'null').
",";
3530 $sql .=
" statut = ".((int) $this->
statut).
",";
3531 $sql .=
" label = '".$this->db->escape($this->label).
"',";
3532 $sql .=
" description = '".$this->db->escape($this->
description).
"',";
3533 $sql .=
" date_commande = ".($this->date_commande !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
"null").
",";
3534 $sql .=
" date_ouverture_prevue = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3535 $sql .=
" date_ouverture = ".($this->date_start_real !=
'' ?
"'".$this->db->idate($this->date_start_real).
"'" :
"null").
",";
3536 $sql .=
" date_fin_validite = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3537 $sql .=
" date_cloture = ".($this->date_end_real !=
'' ?
"'".$this->db->idate($this->date_end_real).
"'" :
"null").
",";
3538 $sql .=
" vat_src_code = '".$this->db->escape($this->vat_src_code).
"',";
3539 $sql .=
" tva_tx = ".price2num($this->tva_tx).
",";
3540 $sql .=
" localtax1_tx = ".price2num($this->localtax1_tx).
",";
3541 $sql .=
" localtax2_tx = ".price2num($this->localtax2_tx).
",";
3542 $sql .=
" qty = ".price2num($this->qty).
",";
3543 $sql .=
" remise_percent = ".price2num($this->remise_percent).
",";
3544 $sql .=
" remise = ".($this->remise ?
price2num($this->remise) :
"null").
",";
3545 $sql .=
" fk_remise_except = ".($this->fk_remise_except > 0 ? $this->fk_remise_except :
"null").
",";
3546 $sql .=
" subprice = ".($this->subprice !=
'' ? $this->subprice :
"null").
",";
3547 $sql .=
" price_ht = ".($this->price_ht !=
'' ? $this->price_ht :
"null").
",";
3548 $sql .=
" total_ht = ".$this->total_ht.
",";
3549 $sql .=
" total_tva = ".$this->total_tva.
",";
3550 $sql .=
" total_localtax1 = ".$this->total_localtax1.
",";
3551 $sql .=
" total_localtax2 = ".$this->total_localtax2.
",";
3552 $sql .=
" total_ttc = ".$this->total_ttc.
",";
3553 $sql .=
" fk_product_fournisseur_price = ".(!empty($this->fk_fournprice) ? $this->fk_fournprice :
"NULL").
",";
3554 $sql .=
" buy_price_ht = '".price2num($this->pa_ht).
"',";
3555 $sql .=
" info_bits = '".$this->db->escape($this->info_bits).
"',";
3556 $sql .=
" fk_user_author = ".($this->fk_user_author >= 0 ? $this->fk_user_author :
"NULL").
",";
3557 $sql .=
" fk_user_ouverture = ".($this->fk_user_ouverture > 0 ? $this->fk_user_ouverture :
"NULL").
",";
3558 $sql .=
" fk_user_cloture = ".($this->fk_user_cloture > 0 ? $this->fk_user_cloture :
"NULL").
",";
3559 $sql .=
" commentaire = '".$this->db->escape($this->commentaire).
"',";
3560 $sql .=
" fk_unit = ".(!$this->fk_unit ?
'NULL' : $this->fk_unit).
",";
3561 $sql .=
" rang = ".(empty($this->rang) ?
'0' : (int) $this->rang);
3562 $sql .=
" WHERE rowid = ".((int) $this->
id);
3564 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3565 $resql = $this->db->query($sql);
3567 $this->error =
"Error ".$this->db->lasterror();
3580 dol_syslog(get_class($this).
"::update CONTRACT_SYNC_PLANNED_DATE_OF_SERVICES is on so we update date for all lines", LOG_DEBUG);
3582 if ($this->date_start != $this->oldcopy->date_start) {
3583 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'contratdet SET';
3584 $sql .=
" date_ouverture_prevue = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
3585 $sql .=
" WHERE fk_contrat = ".((int) $this->fk_contrat);
3587 $resql = $this->db->query($sql);
3590 $this->error =
"Error ".$this->db->lasterror();
3593 if ($this->date_end != $this->oldcopy->date_end) {
3594 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'contratdet SET';
3595 $sql .=
" date_fin_validite = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
3596 $sql .=
" WHERE fk_contrat = ".((int) $this->fk_contrat);
3598 $resql = $this->db->query($sql);
3601 $this->error =
"Error ".$this->db->lasterror();
3606 if (!$error && !$notrigger) {
3608 $result = $this->
call_trigger(
'LINECONTRACT_MODIFY', $user);
3611 $this->db->rollback();
3617 $this->db->commit();
3620 $this->db->rollback();
3621 $this->errors[] = $this->error;
3640 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET";
3641 $sql .=
" total_ht=".price2num($this->total_ht,
'MT');
3642 $sql .=
",total_tva=".price2num($this->total_tva,
'MT');
3643 $sql .=
",total_localtax1=".price2num($this->total_localtax1,
'MT');
3644 $sql .=
",total_localtax2=".price2num($this->total_localtax2,
'MT');
3645 $sql .=
",total_ttc=".price2num($this->total_ttc,
'MT');
3646 $sql .=
" WHERE rowid = ".((int) $this->
id);
3648 dol_syslog(get_class($this).
"::update_total", LOG_DEBUG);
3650 $resql = $this->db->query($sql);
3652 $this->db->commit();
3655 $this->error = $this->db->error();
3656 $this->db->rollback();
3675 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"contratdet";
3676 $sql .=
" (fk_contrat, label, description, fk_product, qty, vat_src_code, tva_tx,";
3677 $sql .=
" localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice,";
3678 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc,";
3679 $sql .=
" info_bits,";
3681 $sql .=
" price_ht, remise, fk_product_fournisseur_price, buy_price_ht";
3682 if ($this->date_start > 0) {
3683 $sql .=
",date_ouverture_prevue";
3685 if ($this->date_end > 0) {
3686 $sql .=
",date_fin_validite";
3688 $sql .=
") VALUES ($this->fk_contrat, '', '".$this->db->escape($this->
description).
"',";
3689 $sql .= ($this->fk_product > 0 ? $this->fk_product :
"null").
",";
3690 $sql .=
" '".$this->db->escape($this->qty).
"',";
3691 $sql .=
" '".$this->db->escape($this->vat_src_code).
"',";
3692 $sql .=
" '".$this->db->escape($this->tva_tx).
"',";
3693 $sql .=
" '".$this->db->escape($this->localtax1_tx).
"',";
3694 $sql .=
" '".$this->db->escape($this->localtax2_tx).
"',";
3695 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3696 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3697 $sql .=
" ".price2num($this->remise_percent).
",".
price2num($this->subprice).
",";
3698 $sql .=
" ".price2num($this->total_ht).
",".
price2num($this->total_tva).
",".
price2num($this->total_localtax1).
",".
price2num($this->total_localtax2).
",".
price2num($this->total_ttc).
",";
3699 $sql .=
" '".$this->db->escape($this->info_bits).
"',";
3700 $sql .=
" ".(empty($this->rang) ?
'0' : (int) $this->rang).
",";
3701 $sql .=
" ".price2num($this->price_ht).
",".
price2num($this->remise).
",";
3702 if ($this->fk_fournprice > 0) {
3703 $sql .=
' '.((int) $this->fk_fournprice).
',';
3707 if ($this->pa_ht > 0) {
3708 $sql .=
' '.((float)
price2num($this->pa_ht));
3712 if ($this->date_start > 0) {
3713 $sql .=
",'".$this->db->idate($this->date_start).
"'";
3715 if ($this->date_end > 0) {
3716 $sql .=
",'".$this->db->idate($this->date_end).
"'";
3720 dol_syslog(get_class($this).
"::insert", LOG_DEBUG);
3722 $resql = $this->db->query($sql);
3724 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'contratdet');
3730 $this->db->rollback();
3737 $result = $this->
call_trigger(
'LINECONTRACT_INSERT', $user);
3739 $this->db->rollback();
3745 $this->db->commit();
3748 $this->db->rollback();
3749 $this->error = $this->db->error().
" sql=".$sql;
3764 public function active_line($user, $date, $date_end =
'', $comment =
'')
3771 $this->
statut = ContratLigne::STATUS_OPEN;
3772 $this->date_start_real = $date;
3773 $this->date_end = $date_end;
3774 $this->fk_user_ouverture = $user->id;
3775 $this->date_end_real =
null;
3776 $this->commentaire = $comment;
3778 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET statut = ".((int) $this->
statut).
",";
3779 $sql .=
" date_ouverture = ".(dol_strlen($this->date_start_real) != 0 ?
"'".$this->db->idate($this->date_start_real).
"'" :
"null").
",";
3780 if ($date_end >= 0) {
3781 $sql .=
" date_fin_validite = ".(dol_strlen($this->date_end) != 0 ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3783 $sql .=
" fk_user_ouverture = ".((int) $this->fk_user_ouverture).
",";
3784 $sql .=
" date_cloture = null,";
3785 $sql .=
" commentaire = '".$this->db->escape($comment).
"'";
3786 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND (statut = ".ContratLigne::STATUS_INITIAL.
" OR statut = ".ContratLigne::STATUS_CLOSED.
")";
3788 dol_syslog(get_class($this).
"::active_line", LOG_DEBUG);
3789 $resql = $this->db->query($sql);
3792 $result = $this->
call_trigger(
'LINECONTRACT_ACTIVATE', $user);
3799 $this->db->commit();
3802 $this->db->rollback();
3806 $this->error = $this->db->lasterror();
3807 $this->db->rollback();
3822 public function close_line($user, $date_end_real, $comment =
'', $notrigger = 0)
3825 $this->date_cloture = $date_end_real;
3826 $this->date_end_real = $date_end_real;
3827 $this->user_closing_id = $user->id;
3828 $this->commentaire = $comment;
3836 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET statut = ".((int) ContratLigne::STATUS_CLOSED).
",";
3837 $sql .=
" date_cloture = '".$this->db->idate($date_end_real).
"',";
3838 $sql .=
" fk_user_cloture = ".((int) $user->id).
",";
3839 $sql .=
" commentaire = '".$this->db->escape($comment).
"'";
3840 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND statut = ".((int) ContratLigne::STATUS_OPEN);
3842 $resql = $this->db->query($sql);
3846 $result = $this->
call_trigger(
'LINECONTRACT_CLOSE', $user);
3849 $this->db->rollback();
3855 $this->db->commit();
3858 $this->error = $this->db->lasterror();
3859 $this->db->rollback();
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Class to manage agenda events (actions)
Parent class of all other business classes (invoices, contracts, proposals, orders,...
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...
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
defineBuyPrice($unitPrice=0.0, $discountPercent=0.0, $fk_product=0)
Get buy price to use for margin calculation.
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.
getIdContact($source, $code, $status=0)
Return id of contacts for a source and a contact code.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
fetch_project()
Load the project with id $this->fk_project into this->project.
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.
setSignedStatusCommon($user, $status, $notrigger=0, $triggercode='')
Set to a signed status.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product 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.
call_trigger($triggerName, $user)
Call trigger based on this instance.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage contracts.
static contractCmpDate($a, $b)
Used to sort lines by date.
createFromClone(User $user, $socid=0, $notrigger=0)
Load an object from its id and create a new one in database.
fetch($id, $ref='', $ref_customer='', $ref_supplier='', $noextrafields=0, $nolines=0)
Load a contract from database.
loadStateBoard()
Load the indicators this->nb for state board.
update_statut($user)
Update statut of contract according to services.
updateline($rowid, $desc, $pu, $qty, $remise_percent, $date_start, $date_end, $tvatx, $localtax1tx=0.0, $localtax2tx=0.0, $date_start_real='', $date_end_real='', $price_base_type='HT', $info_bits=0, $fk_fournprice=null, $pa_ht=0, $array_options=array(), $fk_unit=null, $rang=0)
Mets a jour une ligne de contrat.
getTicketsArray()
Create an array of associated tickets.
setSignedStatus(User $user, int $status=0, int $notrigger=0, $triggercode='')
Set signed status.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
active_line($user, $line_id, $date_start, $date_end='', $comment='')
Activate a contract line.
getTooltipContentArray($params)
getTooltipContentArray
getLinesArray()
Create an array of order lines.
validate(User $user, $force_number='', $notrigger=0)
Validate a contract.
getIdBillingContact()
Return id des contacts clients de facturation.
initAsSpecimen()
Initialise an instance with random values.
create($user)
Create a contract into database.
close_line($user, $line_id, $date_end, $comment='')
Close a contract line.
reopen($user, $notrigger=0)
Unvalidate a contract.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
deleteLine($idline, User $user)
Delete a contract line.
array_detail($status=-1)
Return list of line rowid.
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1, $txlocaltax2, $fk_product, $remise_percent, $date_start, $date_end, $price_base_type='HT', $pu_ttc=0.0, $info_bits=0, $fk_fournprice=null, $pa_ht=0, $array_options=array(), $fk_unit=null, $rang=0)
Ajoute une ligne de contrat en base.
update($user, $notrigger=0)
Update object into database.
closeAll(User $user, $notrigger=0, $comment='')
Close all lines of a contract.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
getListOfContracts($option='all', $status=[], $product_categories=[], $line_status=[])
Return list of other contracts for the same company than current contract.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
LibStatut($status, $mode)
Return the label of a given contrat status.
activateAll($user, $date_start='', $notrigger=0, $comment='', $date_end='')
Open all lines of a contract.
__construct($db)
Constructor.
doAutoRenewContracts($thirdparty_id=0, $delayindaysshort=0)
Action executed by scheduler CAN BE A CRON TASK Loop on each contract lines and update the end of dat...
getNomUrl($withpicto=0, $maxlength=0, $notooltip=0, $save_lastsearch_value=-1)
Return clicable name (with picto eventually)
info($id)
Charge les information d'ordre info dans l'objet contrat.
getLibStatut($mode)
Return label of a contract status.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
fetch_lines($only_services=0, $loadalsotranslation=0, $noextrafields=0)
Load lines array into this->lines.
getIdServiceContact()
Return id des contacts clients de prestation.
getNextNumRef($soc)
Return next contract ref.
Class to manage lines of contracts.
active_line($user, $date, $date_end='', $comment='')
Activate a contract line.
getLibStatut($mode)
Return label of this contract line status.
insert($notrigger=0)
Inserts a contrat line into database.
fetch($id, $ref='')
Load object in memory from database.
close_line($user, $date_end_real, $comment='', $notrigger=0)
Close a contract line.
static LibStatut($status, $mode, $expired=-1, $moreatt='', $morelabel='')
Return label of a contract line status.
update($user, $notrigger=0)
Update database for contract line.
update_total()
Update in database the fields total_xxx of lines Used by migration process.
__construct($db)
Constructor.
getTooltipContentArray($params)
getTooltipContentArray
getNomUrl($withpicto=0, $maxlength=0)
Return clicable name (with picto eventually) for ContratLigne.
Class to manage Dolibarr database access.
Class to manage shipments.
const STATUS_DRAFT
Draft status.
Class to manage products or services.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
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_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=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.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
if(!function_exists( 'dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
dol_clone($object, $native=0)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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.
getMarginInfos($pv_ht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $pa_ht)
Return an array with margins information of a line.
Class to generate the form for creating a new ticket.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller='', $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
publicphonebutton2 phonegreen basiclayout basiclayout TotalHT VATCode TotalVAT TotalLT1 TotalLT2 TotalTTC TotalHT clearboth nowraponall TAKEPOS_SHOW_SUBPRICE right right right takeposterminal SELECT e e e e e statut