37 require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
38 require_once DOL_DOCUMENT_ROOT.
"/core/class/commonobjectline.class.php";
39 require_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
40 require_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);
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)
1198 global $conf, $langs;
1199 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1206 $result = $this->
call_trigger(
'CONTRACT_DELETE', $user);
1216 dol_syslog(get_class($this).
"::delete error", LOG_ERR);
1236 $sql =
"SELECT cdl.rowid as cdlrowid ";
1237 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet_log as cdl, ".MAIN_DB_PREFIX.
"contratdet as cd";
1238 $sql .=
" WHERE cdl.fk_contratdet=cd.rowid AND cd.fk_contrat=".((int) $this->
id);
1240 dol_syslog(get_class($this).
"::delete contratdet_log", LOG_DEBUG);
1241 $resql = $this->db->query(
$sql);
1243 $this->error = $this->db->error();
1246 $numressql = $this->db->num_rows($resql);
1247 if (!$error && $numressql) {
1248 $tab_resql = array();
1249 for ($i = 0; $i < $numressql; $i++) {
1250 $objresql = $this->db->fetch_object($resql);
1251 $tab_resql[] = $objresql->cdlrowid;
1253 $this->db->free($resql);
1255 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"contratdet_log ";
1256 $sql .=
" WHERE ".MAIN_DB_PREFIX.
"contratdet_log.rowid IN (".$this->db->sanitize(implode(
",", $tab_resql)).
")";
1258 dol_syslog(get_class($this).
"::delete contratdet_log", LOG_DEBUG);
1259 $resql = $this->db->query(
$sql);
1261 $this->error = $this->db->error();
1270 $main = MAIN_DB_PREFIX.
'contratdet';
1271 $ef = $main.
"_extrafields";
1272 $sql =
"DELETE FROM ".$ef.
" WHERE fk_object IN (SELECT rowid FROM ".$main.
" WHERE fk_contrat = ".((int) $this->
id).
")";
1274 dol_syslog(get_class($this).
"::delete contratdet_extrafields", LOG_DEBUG);
1275 $resql = $this->db->query(
$sql);
1277 $this->error = $this->db->error();
1284 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"contratdet";
1285 $sql .=
" WHERE fk_contrat=".((int) $this->
id);
1287 dol_syslog(get_class($this).
"::delete contratdet", LOG_DEBUG);
1288 $resql = $this->db->query(
$sql);
1290 $this->error = $this->db->error();
1297 $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);
1298 $resql = $this->db->query(
$sql);
1300 $this->error = $this->db->lasterror();
1301 $this->errors[] = $this->error;
1308 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"contrat";
1309 $sql .=
" WHERE rowid=".((int) $this->
id);
1311 dol_syslog(get_class($this).
"::delete contrat", LOG_DEBUG);
1312 $resql = $this->db->query(
$sql);
1314 $this->error = $this->db->error();
1324 dol_syslog(get_class($this).
"::delete error -3 ".$this->error, LOG_ERR);
1331 if ($conf->contrat->dir_output) {
1332 $dir = $conf->contrat->multidir_output[$this->entity].
"/".$ref;
1333 if (file_exists($dir)) {
1336 $this->error =
'ErrorFailToDeleteDir';
1344 $this->db->commit();
1347 $this->error = $this->db->lasterror();
1348 $this->db->rollback();
1360 public function update($user, $notrigger = 0)
1366 if (empty($this->fk_commercial_signature) && $this->commercial_signature_id > 0) {
1367 $this->fk_commercial_signature = $this->commercial_signature_id;
1369 if (empty($this->fk_commercial_suivi) && $this->commercial_suivi_id > 0) {
1370 $this->fk_commercial_suivi = $this->commercial_suivi_id;
1372 if (empty($this->socid) && $this->fk_soc > 0) {
1373 $this->socid = (int) $this->fk_soc;
1375 if (empty($this->fk_project) && $this->projet > 0) {
1376 $this->fk_project = (int) $this->projet;
1379 if (isset($this->
ref)) {
1380 $this->
ref = trim($this->
ref);
1382 if (isset($this->ref_customer)) {
1383 $this->ref_customer = trim($this->ref_customer);
1385 if (isset($this->ref_supplier)) {
1386 $this->ref_supplier = trim($this->ref_supplier);
1388 if (isset($this->ref_ext)) {
1389 $this->ref_ext = trim($this->ref_ext);
1391 if (isset($this->entity)) {
1392 $this->entity = (int) $this->entity;
1394 if (isset($this->statut)) {
1395 $this->statut = (int) $this->statut;
1397 if (isset($this->
status)) {
1400 if (isset($this->socid)) {
1401 $this->socid = (int) $this->socid;
1403 if (isset($this->fk_commercial_signature)) {
1404 $this->fk_commercial_signature = trim($this->fk_commercial_signature);
1406 if (isset($this->fk_commercial_suivi)) {
1407 $this->fk_commercial_suivi = trim($this->fk_commercial_suivi);
1409 if (isset($this->note_private)) {
1410 $this->note_private = trim($this->note_private);
1412 if (isset($this->note_public)) {
1413 $this->note_public = trim($this->note_public);
1415 if (isset($this->import_key)) {
1416 $this->import_key = trim($this->import_key);
1423 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contrat SET";
1424 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1425 $sql .=
" ref_customer=".(isset($this->ref_customer) ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null").
",";
1426 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1427 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1428 $sql .=
" entity=".$conf->entity.
",";
1429 $sql .=
" date_contrat=".(dol_strlen($this->date_contrat) != 0 ?
"'".$this->db->idate($this->date_contrat).
"'" :
'null').
",";
1430 $sql .=
" statut=".(isset($this->statut) ? $this->statut : (isset($this->
status) ? $this->
status :
"null")).
",";
1431 $sql .=
" fk_soc=".($this->socid > 0 ? $this->socid :
"null").
",";
1432 $sql .=
" fk_projet=".($this->fk_project > 0 ? $this->fk_project :
"null").
",";
1433 $sql .=
" fk_commercial_signature=".(isset($this->fk_commercial_signature) ? $this->fk_commercial_signature :
"null").
",";
1434 $sql .=
" fk_commercial_suivi=".(isset($this->fk_commercial_suivi) ? $this->fk_commercial_suivi :
"null").
",";
1435 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1436 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1437 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1439 $sql .=
" WHERE rowid=".((int) $this->
id);
1443 $resql = $this->db->query(
$sql);
1446 $this->errors[] =
"Error ".$this->db->lasterror();
1456 if (!$error && !$notrigger) {
1458 $result = $this->
call_trigger(
'CONTRACT_MODIFY', $user);
1467 foreach ($this->errors as $errmsg) {
1468 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1469 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1471 $this->db->rollback();
1474 $this->db->commit();
1503 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)
1505 global $user, $langs, $conf, $mysoc;
1508 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");
1511 if ($fk_product <= 0 && empty($desc)) {
1512 $this->error =
"ErrorDescRequiredForFreeProductLines";
1516 if ($this->statut >= 0) {
1525 if (preg_match(
'/\((.*)\)/', (
string) $txtva, $reg)) {
1526 $vat_src_code = $reg[1];
1527 $txtva = preg_replace(
'/\s*\(.*\)/',
'', (
string) $txtva);
1533 $remise_percent =
price2num($remise_percent);
1538 if (empty($info_bits)) {
1541 if (empty($pu_ht) || !is_numeric($pu_ht)) {
1544 if (empty($pu_ttc)) {
1547 if (empty($txtva) || !is_numeric($txtva)) {
1550 if (empty($txlocaltax1) || !is_numeric($txlocaltax1)) {
1553 if (empty($txlocaltax2) || !is_numeric($txlocaltax2)) {
1557 if ($price_base_type ==
'HT') {
1564 if (empty($remise_percent)) {
1565 $remise_percent = 0;
1571 if ($date_start && $date_end && $date_start > $date_end) {
1572 $langs->load(
"errors");
1573 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1579 $localtaxes_type =
getLocalTaxesFromRate($txtva.($vat_src_code ?
' ('.$vat_src_code.
')' :
''), 0, $this->societe, $mysoc);
1586 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, 1, $mysoc, $localtaxes_type);
1587 $total_ht = $tabprice[0];
1588 $total_tva = $tabprice[1];
1589 $total_ttc = $tabprice[2];
1590 $total_localtax1 = $tabprice[9];
1591 $total_localtax2 = $tabprice[10];
1593 $localtax1_type = $localtaxes_type[0];
1594 $localtax2_type = $localtaxes_type[2];
1601 $remise = round(($pu_ht * $remise_percent / 100), 2);
1602 $price = $pu_ht - $remise;
1605 if (empty($pa_ht)) {
1612 $result = $this->
defineBuyPrice($pu_ht, $remise_percent, $fk_product);
1621 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"contratdet";
1622 $sql .=
" (fk_contrat, label, description, fk_product, qty, tva_tx, vat_src_code,";
1623 $sql .=
" localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice,";
1624 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc,";
1625 $sql .=
" info_bits,";
1626 $sql .=
" price_ht, remise, fk_product_fournisseur_price, buy_price_ht";
1627 if ($date_start > 0) {
1628 $sql .=
",date_ouverture_prevue";
1630 if ($date_end > 0) {
1631 $sql .=
",date_fin_validite";
1633 $sql .=
", fk_unit";
1635 $sql .=
") VALUES (";
1636 $sql .= $this->
id.
", '', '".$this->db->escape($desc).
"',";
1637 $sql .= ($fk_product > 0 ? $fk_product :
"null").
",";
1638 $sql .=
" ".((float) $qty).
",";
1639 $sql .=
" ".((float) $txtva).
",";
1640 $sql .=
" ".($vat_src_code ?
"'".$this->db->escape($vat_src_code).
"'" :
"null").
",";
1641 $sql .=
" ".((float) $txlocaltax1).
",";
1642 $sql .=
" ".((float) $txlocaltax2).
",";
1643 $sql .=
" '".$this->db->escape($localtax1_type).
"',";
1644 $sql .=
" '".$this->db->escape($localtax2_type).
"',";
1645 $sql .=
" ".price2num($remise_percent).
",";
1646 $sql .=
" ".price2num($pu_ht).
",";
1648 $sql .=
" ".((int) $info_bits).
",";
1650 if (isset($fk_fournprice)) {
1651 $sql .=
' '.((int) $fk_fournprice).
',';
1655 if (isset($pa_ht)) {
1656 $sql .=
' '.price2num($pa_ht);
1660 if ($date_start > 0) {
1661 $sql .=
",'".$this->db->idate($date_start).
"'";
1663 if ($date_end > 0) {
1664 $sql .=
",'".$this->db->idate($date_end).
"'";
1666 $sql .=
", ".($fk_unit ?
"'".$this->db->escape($fk_unit).
"'" :
"null");
1667 $sql .=
", ".(!empty($rang) ? (int) $rang :
"0");
1670 $resql = $this->db->query(
$sql);
1672 $contractlineid = $this->db->last_insert_id(MAIN_DB_PREFIX.
"contratdet");
1676 $contractline->array_options = $array_options;
1677 $contractline->id = $contractlineid;
1678 $result = $contractline->insertExtraFields();
1680 $this->errors[] = $contractline->error;
1685 if (empty($error)) {
1687 $result = $this->
call_trigger(
'LINECONTRACT_INSERT', $user);
1695 $this->db->rollback();
1698 $this->db->commit();
1699 return $contractlineid;
1702 $this->db->rollback();
1703 $this->error = $this->db->error().
" sql=".
$sql;
1707 dol_syslog(get_class($this).
"::addline ErrorTryToAddLineOnValidatedContract", LOG_ERR);
1736 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)
1738 global $user, $conf, $langs, $mysoc;
1743 $qty = trim((
string) $qty);
1744 $desc = trim($desc);
1745 $desc = trim($desc);
1751 if (empty($fk_fournprice)) {
1761 $remise = round(($pu * $remise_percent / 100), 2);
1762 $price = $pu - $remise;
1764 $remise_percent = 0;
1767 if ($date_start && $date_end && $date_start > $date_end) {
1768 $langs->load(
"errors");
1769 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1773 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");
1783 $tvatx = preg_replace(
'/\s*\(.*\)/',
'', $tvatx);
1785 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $tvatx, $localtax1tx, $localtax2tx, 0, $price_base_type, $info_bits, 1, $mysoc, $localtaxes_type);
1786 $total_ht = $tabprice[0];
1787 $total_tva = $tabprice[1];
1788 $total_ttc = $tabprice[2];
1789 $total_localtax1 = $tabprice[9];
1790 $total_localtax2 = $tabprice[10];
1792 $localtax1_type = (empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0]);
1793 $localtax2_type = (empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2]);
1800 $remise = round(($pu * $remise_percent / 100), 2);
1801 $price = $pu - $remise;
1804 if (empty($pa_ht)) {
1818 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet set description = '".$this->db->escape($desc).
"'";
1822 $sql .=
",remise_percent = ".((float)
price2num($remise_percent));
1823 $sql .=
",qty = ".((float) $qty);
1825 $sql .=
",localtax1_tx = ".((float)
price2num($localtax1tx));
1826 $sql .=
",localtax2_tx = ".((float)
price2num($localtax2tx));
1827 $sql .=
",localtax1_type='".$this->db->escape($localtax1_type).
"'";
1828 $sql .=
",localtax2_type='".$this->db->escape($localtax2_type).
"'";
1831 $sql .=
", total_localtax1 = ".((float)
price2num($total_localtax1));
1832 $sql .=
", total_localtax2 = ".((float)
price2num($total_localtax2));
1834 $sql .=
", fk_product_fournisseur_price=".($fk_fournprice > 0 ? $fk_fournprice :
"null");
1836 if ($date_start > 0) {
1837 $sql .=
",date_ouverture_prevue = '".$this->db->idate($date_start).
"'";
1839 $sql .=
",date_ouverture_prevue = null";
1841 if ($date_end > 0) {
1842 $sql .=
",date_fin_validite = '".$this->db->idate($date_end).
"'";
1844 $sql .=
",date_fin_validite = null";
1846 if ($date_start_real > 0) {
1847 $sql .=
",date_ouverture = '".$this->db->idate($date_start_real).
"'";
1849 $sql .=
",date_ouverture = null";
1851 if ($date_end_real > 0) {
1852 $sql .=
",date_cloture = '".$this->db->idate($date_end_real).
"'";
1854 $sql .=
",date_cloture = null";
1856 $sql .=
", fk_unit = ".($fk_unit > 0 ? ((int) $fk_unit) :
"null");
1857 $sql .=
", rang = ".(!empty($rang) ? ((int) $rang) :
"0");
1858 $sql .=
" WHERE rowid = ".((int) $rowid);
1860 dol_syslog(get_class($this).
"::updateline", LOG_DEBUG);
1861 $result = $this->db->query(
$sql);
1863 if (is_array($array_options) && count($array_options) > 0) {
1865 $contractline->fetch($rowid);
1868 foreach ($array_options as $key => $value) {
1869 $contractline->array_options[$key] = $array_options[$key];
1872 $result = $contractline->insertExtraFields();
1874 $this->errors[] = $contractline->error;
1879 if (empty($error)) {
1881 $result = $this->
call_trigger(
'LINECONTRACT_MODIFY', $user);
1883 $this->db->rollback();
1888 $this->db->commit();
1891 $this->db->rollback();
1895 $this->db->rollback();
1896 $this->error = $this->db->error();
1897 dol_syslog(get_class($this).
"::updateline Erreur -1");
1913 if ($this->statut >= 0) {
1915 $result = $this->
call_trigger(
'LINECONTRACT_DELETE', $user);
1923 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$this->table_element_line;
1924 $sql .=
" WHERE rowid = ".((int) $idline);
1926 dol_syslog(get_class($this).
"::deleteline", LOG_DEBUG);
1927 $resql = $this->db->query(
$sql);
1929 $this->error =
"Error ".$this->db->lasterror();
1936 $contractline->id = $idline;
1937 $result = $contractline->deleteExtraFields();
1940 $this->error =
"Error ".get_class($this).
"::deleteline deleteExtraFields error -4 ".$contractline->error;
1944 if (empty($error)) {
1945 $this->db->commit();
1948 dol_syslog(get_class($this).
"::deleteline ERROR:".$this->error, LOG_ERR);
1949 $this->db->rollback();
1953 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
1970 dol_syslog(__METHOD__.
" is deprecated", LOG_WARNING);
1973 if ($this->statut == 0) {
1998 return $this->
LibStatut($this->statut, $mode);
2014 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2016 $langs->load(
"contracts");
2017 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'ContractStatusDraft');
2018 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'ContractStatusValidated');
2019 $this->labelStatus[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv(
'ContractStatusClosed');
2020 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'ContractStatusDraft');
2021 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'ContractStatusValidated');
2022 $this->labelStatusShort[self::STATUS_CLOSED] = $langs->transnoentitiesnoconv(
'ContractStatusClosed');
2025 $statusType =
'status'.$status;
2026 if ($status == self::STATUS_VALIDATED) {
2027 $statusType =
'status6';
2030 if ($mode == 4 || $mode == 6 || $mode == 7) {
2033 $text =
'<span class="hideonsmartphone">';
2034 $text .= ($this->nbofserviceswait + $this->nbofservicesopened + $this->nbofservicesexpired + $this->nbofservicesclosed);
2035 $text .=
' '.$langs->trans(
"Services");
2036 $text .=
': ';
2039 $text .= ($mode == 7 ?
'<span class="nowraponall">' :
'');
2040 $text .= ($mode != 7 || $this->nbofserviceswait > 0) ? ($this->nbofserviceswait.ContratLigne::LibStatut(0, 3, -1,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesopened || $this->nbofservicesexpired || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2041 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2042 $text .= ($mode != 7 || $this->nbofservicesopened > 0) ? ($this->nbofservicesopened.ContratLigne::LibStatut(4, 3, 0,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesexpired || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2043 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2044 $text .= ($mode != 7 || $this->nbofservicesexpired > 0) ? ($this->nbofservicesexpired.ContratLigne::LibStatut(4, 3, 1,
'class="marginleft2"')).(($mode != 7 || $this->nbofservicesclosed) ?
' ' :
'') :
'';
2045 $text .= ($mode == 7 ?
'</span><span class="nowraponall">' :
'');
2046 $text .= ($mode != 7 || $this->nbofservicesclosed > 0) ? ($this->nbofservicesclosed.ContratLigne::LibStatut(5, 3, -1,
'class="marginleft2"')) :
'';
2047 $text .= ($mode == 7 ?
'</span>' :
'');
2050 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
2062 global $conf, $langs, $user;
2064 $langs->load(
'contracts');
2067 $nofetch = !empty($params[
'nofetch']);
2070 return [
'optimize' => $langs->trans(
"ShowContract")];
2072 if ($user->hasRight(
'contrat',
'lire')) {
2073 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Contract").
'</u>';
2078 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.($this->
ref ? $this->
ref : $this->id);
2080 $langs->load(
'companies');
2081 if (empty($this->thirdparty)) {
2084 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
2086 $datas[
'refcustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '. $this->ref_customer;
2088 $langs->load(
'project');
2089 if (empty($this->project) && $this->project instanceof
Project) {
2092 $datas[
'project'] =
'<br><b>'.$langs->trans(
'Project').
':</b> '.$this->project->getNomUrl(1,
'', 0, 1);
2096 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
2097 if (!empty($this->total_ht)) {
2098 $datas[
'amountht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
2100 if (!empty($this->total_tva)) {
2101 $datas[
'vatamount'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
2103 if (!empty($this->total_ttc)) {
2104 $datas[
'amounttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
2119 public function getNomUrl($withpicto = 0, $maxlength = 0, $notooltip = 0, $save_lastsearch_value = -1)
2121 global $conf, $langs, $user, $hookmanager;
2125 $url = DOL_URL_ROOT.
'/contrat/card.php?id='.$this->id;
2130 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2131 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2132 $add_save_lastsearch_values = 1;
2134 if ($add_save_lastsearch_values) {
2135 $url .=
'&save_lastsearch_values=1';
2140 'objecttype' => $this->element,
2143 $classfortooltip =
'classfortooltip';
2146 $classfortooltip =
'classforajaxtooltip';
2147 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2154 if (empty($notooltip) && $user->hasRight(
'contrat',
'lire')) {
2156 $label = $langs->trans(
"ShowContract");
2157 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
2159 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
2160 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2162 $linkstart =
'<a href="'.$url.
'"';
2163 $linkstart .= $linkclose.
'>';
2166 $result .= $linkstart;
2168 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
2170 if ($withpicto != 2) {
2171 $result .= ($this->
ref ? $this->
ref : $this->id);
2173 $result .= $linkend;
2176 $hookmanager->initHooks(array(
'contractdao'));
2177 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2178 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2180 $result = $hookmanager->resPrint;
2182 $result .= $hookmanager->resPrint;
2196 $sql =
"SELECT c.rowid, c.ref, c.datec,";
2197 $sql .=
" c.tms as date_modification,";
2198 $sql .=
" fk_user_author";
2199 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2200 $sql .=
" WHERE c.rowid = ".((int) $id);
2202 $result = $this->db->query(
$sql);
2204 if ($this->db->num_rows($result)) {
2205 $obj = $this->db->fetch_object($result);
2207 $this->
id = $obj->rowid;
2208 $this->
ref = (!$obj->ref) ? $obj->rowid : $obj->ref;
2210 $this->user_creation_id = $obj->fk_user_author;
2211 $this->date_creation = $this->db->jdate($obj->datec);
2212 $this->date_modification = $this->db->jdate($obj->date_modification);
2215 $this->db->free($result);
2233 $sql =
"SELECT cd.rowid";
2234 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet as cd";
2235 $sql .=
" WHERE fk_contrat =".((int) $this->
id);
2237 $sql .=
" AND statut = ".((int) $status);
2240 dol_syslog(get_class($this).
"::array_detail()", LOG_DEBUG);
2241 $resql = $this->db->query(
$sql);
2243 $num = $this->db->num_rows($resql);
2246 $obj = $this->db->fetch_object($resql);
2247 $tab[$i] = $obj->rowid;
2252 $this->error = $this->db->error();
2266 public function getListOfContracts($option =
'all', $status = [], $product_categories = [], $line_status = [])
2270 $sql =
"SELECT c.rowid";
2271 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2272 if (!empty($product_categories)) {
2273 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"contratdet as cd ON cd.fk_contrat = c.rowid";
2274 $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)).
")";
2276 $sql .=
" WHERE c.fk_soc =".((int) $this->socid);
2277 $sql .= ($option ==
'others') ?
" AND c.rowid <> ".((
int) $this->id) :
"";
2278 $sql .= (!empty($status)) ?
" AND c.statut IN (".$this->db->sanitize(implode(
', ', $status)).
")" :
"";
2279 $sql .= (!empty($line_status)) ?
" AND cd.statut IN (".$this->db->sanitize(implode(
', ', $line_status)).
")" :
"";
2280 $sql .=
" GROUP BY c.rowid";
2282 dol_syslog(get_class($this).
"::getOtherContracts()", LOG_DEBUG);
2283 $resql = $this->db->query(
$sql);
2285 $num = $this->db->num_rows($resql);
2288 $obj = $this->db->fetch_object($resql);
2289 $contrat =
new Contrat($this->db);
2290 $contrat->fetch($obj->rowid);
2291 $tab[$contrat->id] = $contrat;
2296 $this->error = $this->db->lasterror();
2313 global $conf, $langs;
2315 $this->from =
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2316 $this->from .=
", ".MAIN_DB_PREFIX.
"contratdet as cd";
2317 $this->from .=
", ".MAIN_DB_PREFIX.
"societe as s";
2318 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2319 $this->from .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
2322 if ($mode ==
'inactive') {
2323 $sql =
"SELECT cd.rowid, cd.date_ouverture_prevue as datefin";
2324 $sql .= $this->from;
2325 $sql .=
" WHERE c.statut = 1";
2326 $sql .=
" AND c.rowid = cd.fk_contrat";
2327 $sql .=
" AND cd.statut = 0";
2328 } elseif ($mode ==
'expired') {
2329 $sql =
"SELECT cd.rowid, cd.date_fin_validite as datefin";
2330 $sql .= $this->from;
2331 $sql .=
" WHERE c.statut = 1";
2332 $sql .=
" AND c.rowid = cd.fk_contrat";
2333 $sql .=
" AND cd.statut = 4";
2334 $sql .=
" AND cd.date_fin_validite < '".$this->db->idate(
dol_now()).
"'";
2335 } elseif ($mode ==
'active') {
2336 $sql =
"SELECT cd.rowid, cd.date_fin_validite as datefin";
2337 $sql .= $this->from;
2338 $sql .=
" WHERE c.statut = 1";
2339 $sql .=
" AND c.rowid = cd.fk_contrat";
2340 $sql .=
" AND cd.statut = 4";
2344 $sql .=
" AND c.fk_soc = s.rowid";
2345 $sql .=
" AND c.entity = ".((int) $conf->entity);
2347 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
2349 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2350 $sql .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
2353 $resql = $this->db->query(
$sql);
2355 $langs->load(
"contracts");
2358 if ($mode ==
'inactive') {
2359 $warning_delay = $conf->contrat->services->inactifs->warning_delay;
2360 $label = $langs->trans(
"BoardNotActivatedServices");
2361 $labelShort = $langs->trans(
"BoardNotActivatedServicesShort");
2362 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=0&sortfield=cd.date_fin_validite&sortorder=asc';
2363 } elseif ($mode ==
'expired') {
2364 $warning_delay = $conf->contrat->services->expires->warning_delay;
2365 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=4&filter=expired&sortfield=cd.date_fin_validite&sortorder=asc';
2366 $label = $langs->trans(
"BoardExpiredServices");
2367 $labelShort = $langs->trans(
"BoardExpiredServicesShort");
2369 $warning_delay = $conf->contrat->services->expires->warning_delay;
2370 $url = DOL_URL_ROOT.
'/contrat/services_list.php?mainmenu=commercial&leftmenu=contracts&search_status=4&sortfield=cd.date_fin_validite&sortorder=asc';
2373 $label = $langs->trans(
"BoardRunningServices");
2374 $labelShort = $langs->trans(
"BoardRunningServicesShort");
2378 $response->warning_delay = $warning_delay / 60 / 60 / 24;
2379 $response->label = $label;
2380 $response->labelShort = $labelShort;
2381 $response->url = $url;
2384 while ($obj = $this->db->fetch_object($resql)) {
2385 $response->nbtodo++;
2387 if ($obj->datefin && $this->db->jdate($obj->datefin) < ($now - $warning_delay)) {
2388 $response->nbtodolate++;
2395 $this->error = $this->db->error();
2407 global $conf, $user;
2409 $this->nb = array();
2412 $sql =
"SELECT count(c.rowid) as nb";
2413 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contrat as c";
2414 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON c.fk_soc = s.rowid";
2415 if (!$user->hasRight(
'societe',
'client',
'voir')) {
2416 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2417 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2420 $sql .=
" ".$clause.
" c.entity = ".$conf->entity;
2422 $resql = $this->db->query(
$sql);
2424 while ($obj = $this->db->fetch_object($resql)) {
2425 $this->nb[
"contracts"] = $obj->nb;
2427 $this->db->free($resql);
2431 $this->error = $this->db->error();
2469 global $user, $langs, $conf;
2474 $sql =
"SELECT rowid";
2475 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
2476 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
2477 $sql .=
" AND tosell = 1";
2478 $sql .= $this->db->plimit(100);
2480 $resql = $this->db->query(
$sql);
2482 $num_prods = $this->db->num_rows($resql);
2484 while ($i < $num_prods) {
2486 $row = $this->db->fetch_row($resql);
2487 $prodids[$i] = $row[0];
2493 $this->specimen = 1;
2495 $this->
ref =
'SPECIMEN';
2496 $this->ref_customer =
'SPECIMENCUST';
2497 $this->ref_supplier =
'SPECIMENSUPP';
2500 $this->date_creation = (
dol_now() - 3600 * 24 * 7);
2501 $this->date_contrat =
dol_now();
2502 $this->commercial_signature_id = 1;
2503 $this->commercial_suivi_id = 1;
2504 $this->note_private =
'This is a comment (private)';
2505 $this->note_public =
'This is a comment (public)';
2506 $this->fk_project = 0;
2510 while ($xnbp < $nbp) {
2513 $line->subprice = 100;
2514 $line->tva_tx = 19.6;
2515 $line->remise_percent = 10;
2516 $line->total_ht = 90;
2517 $line->total_ttc = 107.64;
2518 $line->total_tva = 17.64;
2519 $line->date_start =
dol_now() - 500000;
2520 $line->date_start_real =
dol_now() - 200000;
2521 $line->date_end =
dol_now() + 500000;
2522 $line->date_end_real =
dol_now() - 100000;
2523 if ($num_prods > 0) {
2524 $prodid = mt_rand(1, $num_prods);
2525 $line->fk_product = $prodids[$prodid];
2527 $this->lines[$xnbp] = $line;
2553 $ticket =
new Ticket($this->db);
2554 $nbTicket = $ticket->fetchAll($user,
'ASC',
't.datec',
'', 0,
'', array(
't.fk_contract' => $this->
id));
2556 return ($nbTicket < 0 ? $nbTicket : $ticket->lines);
2571 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2573 global $conf, $langs;
2578 if (!empty($this->model_pdf)) {
2579 $modele = $this->model_pdf;
2585 if (empty($modele)) {
2588 $langs->load(
"contracts");
2589 $outputlangs->load(
"products");
2591 $modelpath =
"core/modules/contract/doc/";
2592 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2640 global $db, $langs, $conf, $hookmanager, $extrafields;
2646 $this->
fetch($this->
id);
2649 $clonedObj = clone $this;
2650 $clonedObj->socid = $socid;
2654 $objsoc =
new Societe($this->db);
2656 $objsoc->fetch($clonedObj->socid);
2659 $clonedObj->statut = 0;
2661 if (is_array($clonedObj->array_options) && count($clonedObj->array_options) > 0) {
2662 $extrafields->fetch_name_optionals_label($this->table_element);
2663 foreach ($clonedObj->array_options as $key => $option) {
2664 $shortkey = preg_replace(
'/options_/',
'', $key);
2666 if (!empty($extrafields->attributes[$this->element][
'unique'][$shortkey])) {
2668 unset($clonedObj->array_options[$key]);
2674 $this->error =
'ErrorSetupNotComplete';
2680 require_once DOL_DOCUMENT_ROOT.
"/core/modules/contract/" .
getDolGlobalString(
'CONTRACT_ADDON').
'.php';
2682 $modContract =
new $obj();
2683 '@phan-var-force CommonNumRefGenerator $modContrat';
2684 $clonedObj->ref = $modContract->getNextValue($objsoc, $clonedObj);
2687 foreach ($this->lines as $line) {
2688 $line->fetch_optionals($line->id);
2692 $clonedObj->context[
'createfromclone'] =
'createfromclone';
2693 $result = $clonedObj->create($user);
2696 $this->error = $clonedObj->error;
2697 $this->errors[] = $clonedObj->error;
2700 if ($this->socid == $clonedObj->socid) {
2701 if ($clonedObj->copy_linked_contact($this,
'external') < 0) {
2708 foreach ($this->lines as $line) {
2709 $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);
2712 $this->error = $clonedObj->error;
2713 $this->errors[] = $clonedObj->error;
2720 if (is_object($hookmanager)) {
2721 $parameters = array(
2723 'clonedObj' => $clonedObj
2726 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $clonedObj, $action);
2734 unset($clonedObj->context[
'createfromclone']);
2738 $this->db->commit();
2739 return $clonedObj->id;
2741 $this->db->rollback();
2758 global $langs, $user;
2760 $langs->load(
"agenda");
2770 $contractlineprocessed = array();
2771 $contractignored = array();
2772 $contracterror = array();
2776 $sql =
'SELECT c.rowid, c.ref_customer, cd.rowid as lid, cd.date_fin_validite, p.duration';
2777 $sql .=
' FROM '.MAIN_DB_PREFIX.
'contrat as c, '.MAIN_DB_PREFIX.
'contratdet as cd';
2778 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON p.rowid = cd.fk_product';
2779 $sql .=
' WHERE cd.fk_contrat = c.rowid';
2780 $sql .=
" AND date_format(cd.date_fin_validite, '%Y-%m-%d') <= date_format('".$this->db->idate($enddatetoscan).
"', '%Y-%m-%d')";
2781 $sql .=
" AND cd.statut = 4";
2782 if ($thirdparty_id > 0) {
2783 $sql .=
" AND c.fk_soc = ".((int) $thirdparty_id);
2787 $resql = $this->db->query(
$sql);
2789 $num = $this->db->num_rows($resql);
2791 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
2795 $obj = $this->db->fetch_object($resql);
2797 if (!empty($contractlineprocessed[$obj->lid]) || !empty($contractignored[$obj->rowid]) || !empty($contracterror[$obj->rowid])) {
2808 $this->errors[] =
'Failed to load contract with id='.$obj->rowid;
2812 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);
2815 $expirationdate = $this->db->jdate($obj->date_fin_validite);
2816 $duration_value = preg_replace(
'/[^0-9]/',
'', $obj->duration);
2817 $duration_unit = preg_replace(
'/\d/',
'', $obj->duration);
2822 $object->fetchObjectLinked(
null,
'',
null,
'',
'OR', 1,
'sourcetype', 1);
2825 if (isset(
$object->linkedObjects[
'facture']) && is_array(
$object->linkedObjects[
'facture']) && count(
$object->linkedObjects[
'facture']) > 0) {
2827 usort(
$object->linkedObjects[
'facture'], array(
'Contrat',
'contractCmpDate'));
2830 $someinvoicenotpaid = 0;
2831 foreach (
$object->linkedObjects[
'facture'] as $idinvoice => $invoice) {
2836 if (empty($invoice->paye)) {
2837 $someinvoicenotpaid++;
2840 if ($someinvoicenotpaid) {
2841 $this->output .=
'Contract '.$object->ref.
' is qualified for renewal but there is '.$someinvoicenotpaid.
' invoice(s) unpayed so we cancel renewal'.
"\n";
2847 if ($expirationdate && $expirationdate < $enddatetoscan) {
2848 dol_syslog(
"Define the newdate of end of services from expirationdate=".$expirationdate);
2849 $newdate = $expirationdate;
2851 while ($newdate < $enddatetoscan && $protecti < 1000) {
2856 if ($protecti < 1000) {
2862 $errorforlocaltransaction = 0;
2864 $label =
'Renewal of contrat '.$object->ref.
' line '.$obj->lid;
2865 $comment =
'Renew date of contract '.$object->ref.
' line '.$obj->lid.
' by doAutoRenewContracts';
2867 $sqlupdate =
'UPDATE '.MAIN_DB_PREFIX.
"contratdet SET date_fin_validite = '".$this->db->idate($newdate).
"'";
2868 $sqlupdate .=
' WHERE rowid = '.((int) $obj->lid);
2869 $resqlupdate = $this->db->query($sqlupdate);
2871 $contractlineprocessed[$obj->lid] =
$object->ref;
2873 $actioncode =
'RENEW_CONTRACT';
2878 $actioncomm->type_code =
'AC_OTH_AUTO';
2879 $actioncomm->code =
'AC_'.$actioncode;
2880 $actioncomm->label = $label;
2881 $actioncomm->datep = $now;
2882 $actioncomm->datef = $now;
2883 $actioncomm->percentage = -1;
2884 $actioncomm->socid =
$object->socid;
2885 $actioncomm->authorid = $user->id;
2886 $actioncomm->userownerid = $user->id;
2887 $actioncomm->fk_element =
$object->id;
2888 $actioncomm->elementtype =
'contract';
2889 $actioncomm->note_private = $comment;
2891 $ret = $actioncomm->create($user);
2896 $errorforlocaltransaction++;
2897 $this->error = $this->db->lasterror();
2900 if (! $errorforlocaltransaction) {
2901 $this->db->commit();
2903 $this->db->rollback();
2907 $this->error =
"Bad value for newdate in doAutoRenewContracts - expirationdate=".$expirationdate.
" enddatetoscan=".$enddatetoscan.
" duration_value=".$duration_value.
" duration_unit=".$duration_value;
2916 $this->error = $this->db->lasterror();
2919 $this->output .= count($contractlineprocessed).
' contract line(s) with end date before '.
dol_print_date($enddatetoscan,
'day').
' were renewed'.(count($contractlineprocessed) > 0 ?
' : '.implode(
',', $contractlineprocessed) :
'');
2921 return ($error ? 1 : 0);
2933 if ($a->date == $b->date) {
2934 return strcmp((
string) $a->id, (
string) $b->id);
2936 return ($a->date < $b->date) ? -1 : 1;
2950 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2952 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2953 $return .=
'<div class="info-box info-box-sm">';
2954 $return .=
'<span class="info-box-icon bg-infobox-action">';
2956 $return .=
'</span>';
2957 $return .=
'<div class="info-box-content">';
2958 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
2959 if ($selected >= 0) {
2960 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2962 if (!empty($arraydata[
'thirdparty'])) {
2963 $tmpthirdparty = $arraydata[
'thirdparty'];
2964 $return .=
'<br><div class="info-box-label inline-block valignmiddle">'.$tmpthirdparty->getNomUrl(1).
'</div>';
2966 if (property_exists($this,
'date_contrat')) {
2967 $return .=
'<br><span class="opacitymedium valignmiddle">'.$langs->trans(
"DateContract").
' : </span><span class="info-box-label valignmiddle">'.
dol_print_date($this->date_contrat,
'day').
'</span>';
2969 if (method_exists($this,
'getLibStatut')) {
2970 $return .=
'<br><div class="info-box-status valignmiddle">'.$this->getLibStatut(7).
'</div>';
2972 $return .=
'</div>';
2973 $return .=
'</div>';
2974 $return .=
'</div>';
3005 public $element =
'contratdet';
3010 public $table_element =
'contratdet';
3016 public $element_for_permission =
'contrat';
3056 public $description;
3058 public $product_type;
3059 public $product_ref;
3060 public $product_label;
3062 public $date_commande;
3065 public $date_start_real;
3067 public $date_end_real;
3070 public $vat_src_code;
3071 public $localtax1_tx;
3072 public $localtax2_tx;
3073 public $localtax1_type;
3074 public $localtax2_type;
3076 public $remise_percent;
3082 public $fk_remise_except;
3097 public $total_localtax1;
3098 public $total_localtax2;
3104 public $fk_fournprice;
3116 public $fk_user_author;
3121 public $fk_user_ouverture;
3126 public $fk_user_cloture;
3131 public $commentaire;
3140 const STATUS_INITIAL = 0;
3141 const STATUS_OPEN = 4;
3142 const STATUS_CLOSED = 5;
3149 public $fields = array(
3150 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
3151 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 30,
'index' => 1),
3152 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 35),
3153 'qty' => array(
'type' =>
'integer',
'label' =>
'Quantity',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 35,
'isameasure' => 1),
3154 'total_ht' => array(
'type' =>
'integer',
'label' =>
'AmountHT',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 36,
'isameasure' => 1),
3155 'total_tva' => array(
'type' =>
'integer',
'label' =>
'AmountVAT',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 37,
'isameasure' => 1),
3156 'total_ttc' => array(
'type' =>
'integer',
'label' =>
'AmountTTC',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 38,
'isameasure' => 1),
3159 'fk_contrat' => array(
'type' =>
'integer:Contrat:contrat/class/contrat.class.php',
'label' =>
'Contract',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 70),
3160 'fk_product' => array(
'type' =>
'integer:Product:product/class/product.class.php:1',
'label' =>
'Product',
'enabled' => 1,
'visible' => -1,
'position' => 75),
3162 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 105),
3163 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 110),
3167 'fk_user_ouverture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserStartingService',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 135),
3168 'fk_user_cloture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserClosingService',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 135),
3169 'statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Statut',
'enabled' => 1,
'visible' => -1,
'position' => 500,
'arrayofkeyval' => array(0 =>
'Draft', 4 =>
'Open', 5 =>
'Closed')),
3170 'rang' => array(
'type' =>
'integer',
'label' =>
'Rank',
'enabled' => 1,
'visible' => 0,
'position' => 500,
'default' =>
'0')
3194 return $this->
LibStatut($this->statut, $mode, ((!empty($this->date_end)) ? ($this->date_end <
dol_now() ? 1 : 0) : -1));
3208 public static function LibStatut($status, $mode, $expired = -1, $moreatt =
'', $morelabel =
'')
3212 $langs->load(
"contracts");
3214 if ($status == self::STATUS_INITIAL) {
3215 $labelStatus = $langs->transnoentities(
"ServiceStatusInitial");
3216 $labelStatusShort = $langs->transnoentities(
"ServiceStatusInitial");
3217 } elseif ($status == self::STATUS_OPEN && $expired == -1) {
3218 $labelStatus = $langs->transnoentities(
"ServiceStatusRunning");
3219 $labelStatusShort = $langs->transnoentities(
"ServiceStatusRunning");
3220 } elseif ($status == self::STATUS_OPEN && $expired == 0) {
3221 $labelStatus = $langs->transnoentities(
"ServiceStatusNotLate");
3222 $labelStatusShort = $langs->transnoentities(
"ServiceStatusNotLateShort");
3223 } elseif ($status == self::STATUS_OPEN && $expired == 1) {
3224 $labelStatus = $langs->transnoentities(
"ServiceStatusLate");
3225 $labelStatusShort = $langs->transnoentities(
"ServiceStatusLateShort");
3226 } elseif ($status == self::STATUS_CLOSED) {
3227 $labelStatus = $langs->transnoentities(
"ServiceStatusClosed");
3228 $labelStatusShort = $langs->transnoentities(
"ServiceStatusClosed");
3231 $statusType =
'status'.$status;
3232 if ($status == self::STATUS_OPEN && $expired == 1) {
3233 $statusType =
'status1';
3235 if ($status == self::STATUS_CLOSED) {
3236 $statusType =
'status6';
3241 if (preg_match(
'/class="(.*)"/', $moreatt, $reg)) {
3242 $params = array(
'badgeParams' => array(
'css' => $reg[1]));
3244 return dolGetStatus($labelStatus.($morelabel ?
' '.$morelabel :
''), $labelStatusShort.($morelabel ?
' '.$morelabel :
''),
'', $statusType, $mode,
'', $params);
3255 global $conf, $langs, $user;
3258 $datas[
'label'] = $langs->trans(
"ShowContractOfService").
': '.$this->label;
3259 if (empty($datas[
'label'])) {
3260 $datas[
'label'] = $this->description;
3278 $label = $langs->trans(
"ShowContractOfService").
': '.$this->label;
3279 if (empty($label)) {
3280 $label = $this->description;
3282 $classfortooltip =
'classfortooltip';
3286 'id' => $this->fk_contrat,
3287 'objecttype' => $this->element,
3289 $classfortooltip =
'classforajaxtooltip';
3290 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
3294 $link =
'<a href="'.DOL_URL_ROOT.
'/contrat/card.php?id='.$this->fk_contrat.
'"';
3295 $link .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
3296 $link .= $dataparams.
' class="'.$classfortooltip.
'">';
3300 if ($this->
type == 0) {
3305 $result .= ($link.img_object($label, $picto, $dataparams.
' class="'.$classfortooltip.
'"').$linkend);
3307 if ($withpicto && $withpicto != 2) {
3310 if ($withpicto != 2) {
3311 $result .= $link.($this->product_ref ? $this->product_ref.
' ' :
'').($this->label ? $this->label : $this->
description).$linkend;
3326 if (empty($id) && empty($ref)) {
3331 $sql .=
" t.rowid,";
3333 $sql .=
" t.fk_contrat,";
3334 $sql .=
" t.fk_product,";
3335 $sql .=
" t.statut,";
3336 $sql .=
" t.label,";
3337 $sql .=
" p.ref as product_ref,";
3338 $sql .=
" p.label as product_label,";
3339 $sql .=
" p.description as product_desc,";
3340 $sql .=
" p.fk_product_type as product_type,";
3341 $sql .=
" t.description,";
3342 $sql .=
" t.date_commande,";
3343 $sql .=
" t.date_ouverture_prevue as date_start,";
3344 $sql .=
" t.date_ouverture as date_start_real,";
3345 $sql .=
" t.date_fin_validite as date_end,";
3346 $sql .=
" t.date_cloture as date_end_real,";
3347 $sql .=
" t.tva_tx,";
3348 $sql .=
" t.vat_src_code,";
3349 $sql .=
" t.localtax1_tx,";
3350 $sql .=
" t.localtax2_tx,";
3351 $sql .=
" t.localtax1_type,";
3352 $sql .=
" t.localtax2_type,";
3354 $sql .=
" t.remise_percent,";
3355 $sql .=
" t.remise,";
3356 $sql .=
" t.fk_remise_except,";
3357 $sql .=
" t.subprice,";
3358 $sql .=
" t.price_ht,";
3359 $sql .=
" t.total_ht,";
3360 $sql .=
" t.total_tva,";
3361 $sql .=
" t.total_localtax1,";
3362 $sql .=
" t.total_localtax2,";
3363 $sql .=
" t.total_ttc,";
3364 $sql .=
" t.fk_product_fournisseur_price as fk_fournprice,";
3365 $sql .=
" t.buy_price_ht as pa_ht,";
3366 $sql .=
" t.info_bits,";
3367 $sql .=
" t.fk_user_author,";
3368 $sql .=
" t.fk_user_ouverture,";
3369 $sql .=
" t.fk_user_cloture,";
3370 $sql .=
" t.commentaire,";
3371 $sql .=
" t.fk_unit,";
3373 $sql .=
" FROM ".MAIN_DB_PREFIX.
"contratdet as t LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON p.rowid = t.fk_product";
3375 $sql .=
" WHERE t.rowid = ".((int) $id);
3378 $sql .=
" WHERE t.rowid = '".$this->db->escape($ref).
"'";
3381 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
3382 $resql = $this->db->query(
$sql);
3384 if ($this->db->num_rows($resql)) {
3385 $obj = $this->db->fetch_object($resql);
3387 $this->
id = $obj->rowid;
3388 $this->
ref = $obj->rowid;
3390 $this->tms = $this->db->jdate($obj->tms);
3391 $this->fk_contrat = $obj->fk_contrat;
3392 $this->fk_product = $obj->fk_product;
3393 $this->statut = $obj->statut;
3394 $this->product_ref = $obj->product_ref;
3395 $this->product_label = $obj->product_label;
3396 $this->product_type = $obj->product_type;
3397 $this->label = $obj->label;
3399 $this->date_commande = $this->db->jdate($obj->date_commande);
3401 $this->date_start = $this->db->jdate($obj->date_start);
3402 $this->date_start_real = $this->db->jdate($obj->date_start_real);
3403 $this->date_end = $this->db->jdate($obj->date_end);
3404 $this->date_end_real = $this->db->jdate($obj->date_end_real);
3411 $this->tva_tx = $obj->tva_tx;
3412 $this->vat_src_code = $obj->vat_src_code;
3413 $this->localtax1_tx = $obj->localtax1_tx;
3414 $this->localtax2_tx = $obj->localtax2_tx;
3415 $this->localtax1_type = $obj->localtax1_type;
3416 $this->localtax2_type = $obj->localtax2_type;
3417 $this->qty = $obj->qty;
3418 $this->remise_percent = $obj->remise_percent;
3419 $this->fk_remise_except = $obj->fk_remise_except;
3420 $this->subprice = $obj->subprice;
3421 $this->price_ht = $obj->price_ht;
3422 $this->total_ht = $obj->total_ht;
3423 $this->total_tva = $obj->total_tva;
3424 $this->total_localtax1 = $obj->total_localtax1;
3425 $this->total_localtax2 = $obj->total_localtax2;
3426 $this->total_ttc = $obj->total_ttc;
3427 $this->info_bits = $obj->info_bits;
3428 $this->fk_user_author = $obj->fk_user_author;
3429 $this->fk_user_ouverture = $obj->fk_user_ouverture;
3430 $this->fk_user_cloture = $obj->fk_user_cloture;
3431 $this->commentaire = $obj->commentaire;
3432 $this->fk_fournprice = $obj->fk_fournprice;
3434 $marginInfos =
getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->fk_fournprice, $obj->pa_ht);
3435 $this->pa_ht = $marginInfos[0];
3436 $this->fk_unit = $obj->fk_unit;
3438 $this->rang = $obj->rang;
3443 $this->db->free($resql);
3447 $this->error =
"Error ".$this->db->lasterror();
3460 public function update($user, $notrigger = 0)
3467 $this->fk_contrat = (int) $this->fk_contrat;
3468 $this->fk_product = (int) $this->fk_product;
3469 $this->statut = (int) $this->statut;
3470 $this->label = trim($this->label);
3472 $this->vat_src_code = trim($this->vat_src_code);
3473 $this->tva_tx = trim((
string) $this->tva_tx);
3474 $this->localtax1_tx = trim($this->localtax1_tx);
3475 $this->localtax2_tx = trim($this->localtax2_tx);
3476 $this->qty = trim((
string) $this->qty);
3477 $this->remise_percent = trim((
string) $this->remise_percent);
3478 $this->fk_remise_except = (int) $this->fk_remise_except;
3479 $this->subprice =
price2num($this->subprice);
3480 $this->price_ht =
price2num($this->price_ht);
3481 $this->info_bits = (int) $this->info_bits;
3482 $this->fk_user_author = (int) $this->fk_user_author;
3483 $this->fk_user_ouverture = (int) $this->fk_user_ouverture;
3484 $this->fk_user_cloture = (int) $this->fk_user_cloture;
3485 $this->commentaire = trim($this->commentaire);
3486 $this->rang = (int) $this->rang;
3488 if (empty($this->price_ht)) {
3489 $this->price_ht = 0;
3491 if (empty($this->total_ht)) {
3492 $this->total_ht = 0;
3494 if (empty($this->total_tva)) {
3495 $this->total_tva = 0;
3497 if (empty($this->total_ttc)) {
3498 $this->total_ttc = 0;
3500 if (empty($this->localtax1_tx)) {
3501 $this->localtax1_tx = 0;
3503 if (empty($this->localtax2_tx)) {
3504 $this->localtax2_tx = 0;
3506 if (empty($this->remise_percent)) {
3507 $this->remise_percent = 0;
3516 $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);
3517 $this->total_ht = $tabprice[0];
3518 $this->total_tva = $tabprice[1];
3519 $this->total_ttc = $tabprice[2];
3520 $this->total_localtax1 = $tabprice[9];
3521 $this->total_localtax2 = $tabprice[10];
3523 if (empty($this->pa_ht)) {
3528 if ($this->pa_ht == 0) {
3529 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3533 $this->pa_ht = $result;
3538 if (empty($this->oldcopy)) {
3539 dol_syslog(
"this->oldcopy should have been set by the caller of update (here properties were already modified)", LOG_WARNING);
3546 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET";
3547 $sql .=
" fk_contrat = ".((int) $this->fk_contrat).
",";
3548 $sql .=
" fk_product = ".($this->fk_product ? ((int) $this->fk_product) :
'null').
",";
3549 $sql .=
" statut = ".((int) $this->statut).
",";
3550 $sql .=
" label = '".$this->db->escape($this->label).
"',";
3551 $sql .=
" description = '".$this->db->escape($this->
description).
"',";
3552 $sql .=
" date_commande = ".($this->date_commande !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
"null").
",";
3553 $sql .=
" date_ouverture_prevue = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3554 $sql .=
" date_ouverture = ".($this->date_start_real !=
'' ?
"'".$this->db->idate($this->date_start_real).
"'" :
"null").
",";
3555 $sql .=
" date_fin_validite = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3556 $sql .=
" date_cloture = ".($this->date_end_real !=
'' ?
"'".$this->db->idate($this->date_end_real).
"'" :
"null").
",";
3557 $sql .=
" vat_src_code = '".$this->db->escape($this->vat_src_code).
"',";
3558 $sql .=
" tva_tx = ".price2num($this->tva_tx).
",";
3559 $sql .=
" localtax1_tx = ".price2num($this->localtax1_tx).
",";
3560 $sql .=
" localtax2_tx = ".price2num($this->localtax2_tx).
",";
3561 $sql .=
" qty = ".price2num($this->qty).
",";
3562 $sql .=
" remise_percent = ".price2num($this->remise_percent).
",";
3563 $sql .=
" remise = ".($this->remise ?
price2num($this->remise) :
"null").
",";
3564 $sql .=
" fk_remise_except = ".($this->fk_remise_except > 0 ? $this->fk_remise_except :
"null").
",";
3565 $sql .=
" subprice = ".($this->subprice !=
'' ? $this->subprice :
"null").
",";
3566 $sql .=
" price_ht = ".($this->price_ht !=
'' ? $this->price_ht :
"null").
",";
3567 $sql .=
" total_ht = ".$this->total_ht.
",";
3568 $sql .=
" total_tva = ".$this->total_tva.
",";
3569 $sql .=
" total_localtax1 = ".$this->total_localtax1.
",";
3570 $sql .=
" total_localtax2 = ".$this->total_localtax2.
",";
3571 $sql .=
" total_ttc = ".$this->total_ttc.
",";
3572 $sql .=
" fk_product_fournisseur_price = ".(!empty($this->fk_fournprice) ? $this->fk_fournprice :
"NULL").
",";
3573 $sql .=
" buy_price_ht = '".price2num($this->pa_ht).
"',";
3574 $sql .=
" info_bits = '".$this->db->escape($this->info_bits).
"',";
3575 $sql .=
" fk_user_author = ".($this->fk_user_author >= 0 ? $this->fk_user_author :
"NULL").
",";
3576 $sql .=
" fk_user_ouverture = ".($this->fk_user_ouverture > 0 ? $this->fk_user_ouverture :
"NULL").
",";
3577 $sql .=
" fk_user_cloture = ".($this->fk_user_cloture > 0 ? $this->fk_user_cloture :
"NULL").
",";
3578 $sql .=
" commentaire = '".$this->db->escape($this->commentaire).
"',";
3579 $sql .=
" fk_unit = ".(!$this->fk_unit ?
'NULL' : $this->fk_unit).
",";
3580 $sql .=
" rang = ".(empty($this->rang) ?
'0' : (int) $this->rang);
3581 $sql .=
" WHERE rowid = ".((int) $this->
id);
3583 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3584 $resql = $this->db->query(
$sql);
3586 $this->error =
"Error ".$this->db->lasterror();
3599 dol_syslog(get_class($this).
"::update CONTRACT_SYNC_PLANNED_DATE_OF_SERVICES is on so we update date for all lines", LOG_DEBUG);
3601 if ($this->date_start != $this->oldcopy->date_start) {
3602 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'contratdet SET';
3603 $sql .=
" date_ouverture_prevue = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
3604 $sql .=
" WHERE fk_contrat = ".((int) $this->fk_contrat);
3606 $resql = $this->db->query(
$sql);
3609 $this->error =
"Error ".$this->db->lasterror();
3612 if ($this->date_end != $this->oldcopy->date_end) {
3613 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'contratdet SET';
3614 $sql .=
" date_fin_validite = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
3615 $sql .=
" WHERE fk_contrat = ".((int) $this->fk_contrat);
3617 $resql = $this->db->query(
$sql);
3620 $this->error =
"Error ".$this->db->lasterror();
3625 if (!$error && !$notrigger) {
3627 $result = $this->
call_trigger(
'LINECONTRACT_MODIFY', $user);
3630 $this->db->rollback();
3636 $this->db->commit();
3639 $this->db->rollback();
3640 $this->errors[] = $this->error;
3659 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET";
3660 $sql .=
" total_ht=".price2num($this->total_ht,
'MT');
3661 $sql .=
",total_tva=".price2num($this->total_tva,
'MT');
3662 $sql .=
",total_localtax1=".price2num($this->total_localtax1,
'MT');
3663 $sql .=
",total_localtax2=".price2num($this->total_localtax2,
'MT');
3664 $sql .=
",total_ttc=".price2num($this->total_ttc,
'MT');
3665 $sql .=
" WHERE rowid = ".((int) $this->
id);
3667 dol_syslog(get_class($this).
"::update_total", LOG_DEBUG);
3669 $resql = $this->db->query(
$sql);
3671 $this->db->commit();
3674 $this->error = $this->db->error();
3675 $this->db->rollback();
3694 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"contratdet";
3695 $sql .=
" (fk_contrat, label, description, fk_product, qty, vat_src_code, tva_tx,";
3696 $sql .=
" localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice,";
3697 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc,";
3698 $sql .=
" info_bits,";
3700 $sql .=
" price_ht, remise, fk_product_fournisseur_price, buy_price_ht";
3701 if ($this->date_start > 0) {
3702 $sql .=
",date_ouverture_prevue";
3704 if ($this->date_end > 0) {
3705 $sql .=
",date_fin_validite";
3707 $sql .=
") VALUES ($this->fk_contrat, '', '".$this->db->escape($this->
description).
"',";
3708 $sql .= ($this->fk_product > 0 ? $this->fk_product :
"null").
",";
3709 $sql .=
" '".$this->db->escape($this->qty).
"',";
3710 $sql .=
" '".$this->db->escape($this->vat_src_code).
"',";
3711 $sql .=
" '".$this->db->escape($this->tva_tx).
"',";
3712 $sql .=
" '".$this->db->escape($this->localtax1_tx).
"',";
3713 $sql .=
" '".$this->db->escape($this->localtax2_tx).
"',";
3714 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3715 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3716 $sql .=
" ".price2num($this->remise_percent).
",".
price2num($this->subprice).
",";
3718 $sql .=
" '".$this->db->escape($this->info_bits).
"',";
3719 $sql .=
" ".(empty($this->rang) ?
'0' : (int) $this->rang).
",";
3720 $sql .=
" ".price2num($this->price_ht).
",".
price2num($this->remise).
",";
3721 if ($this->fk_fournprice > 0) {
3722 $sql .=
' '.((int) $this->fk_fournprice).
',';
3726 if ($this->pa_ht > 0) {
3731 if ($this->date_start > 0) {
3732 $sql .=
",'".$this->db->idate($this->date_start).
"'";
3734 if ($this->date_end > 0) {
3735 $sql .=
",'".$this->db->idate($this->date_end).
"'";
3739 dol_syslog(get_class($this).
"::insert", LOG_DEBUG);
3741 $resql = $this->db->query(
$sql);
3743 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'contratdet');
3749 $this->db->rollback();
3756 $result = $this->
call_trigger(
'LINECONTRACT_INSERT', $user);
3758 $this->db->rollback();
3764 $this->db->commit();
3767 $this->db->rollback();
3768 $this->error = $this->db->error().
" sql=".
$sql;
3783 public function active_line($user, $date, $date_end =
'', $comment =
'')
3790 $this->statut = ContratLigne::STATUS_OPEN;
3791 $this->date_start_real = $date;
3792 $this->date_end = $date_end;
3793 $this->fk_user_ouverture = $user->id;
3794 $this->date_end_real =
null;
3795 $this->commentaire = $comment;
3797 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET statut = ".((int) $this->statut).
",";
3798 $sql .=
" date_ouverture = ".(dol_strlen($this->date_start_real) != 0 ?
"'".$this->db->idate($this->date_start_real).
"'" :
"null").
",";
3799 if ($date_end >= 0) {
3800 $sql .=
" date_fin_validite = ".(dol_strlen($this->date_end) != 0 ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3802 $sql .=
" fk_user_ouverture = ".((int) $this->fk_user_ouverture).
",";
3803 $sql .=
" date_cloture = null,";
3804 $sql .=
" commentaire = '".$this->db->escape($comment).
"'";
3805 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND (statut = ".ContratLigne::STATUS_INITIAL.
" OR statut = ".ContratLigne::STATUS_CLOSED.
")";
3807 dol_syslog(get_class($this).
"::active_line", LOG_DEBUG);
3808 $resql = $this->db->query(
$sql);
3811 $result = $this->
call_trigger(
'LINECONTRACT_ACTIVATE', $user);
3818 $this->db->commit();
3821 $this->db->rollback();
3825 $this->error = $this->db->lasterror();
3826 $this->db->rollback();
3841 public function close_line($user, $date_end_real, $comment =
'', $notrigger = 0)
3844 $this->date_cloture = $date_end_real;
3845 $this->date_end_real = $date_end_real;
3846 $this->user_closing_id = $user->id;
3847 $this->commentaire = $comment;
3855 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"contratdet SET statut = ".((int) ContratLigne::STATUS_CLOSED).
",";
3856 $sql .=
" date_cloture = '".$this->db->idate($date_end_real).
"',";
3857 $sql .=
" fk_user_cloture = ".((int) $user->id).
",";
3858 $sql .=
" commentaire = '".$this->db->escape($comment).
"'";
3859 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND statut = ".((int) ContratLigne::STATUS_OPEN);
3861 $resql = $this->db->query(
$sql);
3865 $result = $this->
call_trigger(
'LINECONTRACT_CLOSE', $user);
3868 $this->db->rollback();
3874 $this->db->commit();
3877 $this->error = $this->db->lasterror();
3878 $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.
info($id)
Charge les information d'ordre info dans l'objet contrat.
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)
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.
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
print *****$script_file(".$version.") pid 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.
if(!function_exists('dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
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).
dol_clone($object, $native=0)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
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.
div float
Buy price without taxes.
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