40require_once DOL_DOCUMENT_ROOT.
'/core/class/commonorder.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/commande/class/orderline.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/margin/lib/margins.lib.php';
44require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/subtotals/class/commonsubtotal.class.php';
59 public $element =
'commande';
65 public $TRIGGER_PREFIX =
'ORDER';
70 public $table_element =
'commande';
75 public $table_element_line =
'commandedet';
80 public $class_element_line =
'OrderLine';
85 public $fk_element =
'fk_commande';
90 public $picto =
'order';
96 public $restrictiononfksoc = 1;
116 public $ref_customer;
144 public $date_lim_reglement;
148 public $cond_reglement_code;
153 public $cond_reglement_doc;
158 public $cond_reglement_label;
164 public $deposit_percent;
174 public $mode_reglement;
179 public $mode_reglement_id;
184 public $mode_reglement_code;
190 public $availability_id;
196 public $availability_code;
202 public $availability;
207 public $demand_reason_id;
212 public $demand_reason_code;
224 public $date_commande;
229 public $delivery_date;
234 public $fk_remise_except;
240 public $remise_percent;
251 public $signed_status = 0;
256 public $warehouse_id;
261 public $extraparams = array();
266 public $user_author_id;
276 public $lines = array();
282 public $module_source;
296 public $online_payment_url;
329 public $fields = array(
330 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
331 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 20,
'index' => 1),
332 'ref' => array(
'type' =>
'varchar(30)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'showoncombobox' => 1,
'position' => 25),
333 'ref_ext' => array(
'type' =>
'varchar(255)',
'label' =>
'RefExt',
'enabled' => 1,
'visible' => 0,
'position' => 26),
334 'ref_client' => array(
'type' =>
'varchar(255)',
'label' =>
'RefCustomer',
'enabled' => 1,
'visible' => -1,
'position' => 28),
335 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 20),
336 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 25),
337 'date_commande' => array(
'type' =>
'date',
'label' =>
'Date',
'enabled' => 1,
'visible' => 1,
'position' => 60,
'csslist' =>
'nowraponall'),
338 'date_valid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'position' => 62,
'csslist' =>
'nowraponall'),
339 'date_cloture' => array(
'type' =>
'datetime',
'label' =>
'DateClosing',
'enabled' => 1,
'visible' => -1,
'position' => 65,
'csslist' =>
'nowraponall'),
340 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => -1,
'position' => 85),
341 'fk_user_cloture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserClosing',
'enabled' => 1,
'visible' => -1,
'position' => 90),
342 'source' => array(
'type' =>
'smallint(6)',
'label' =>
'Source',
'enabled' => 1,
'visible' => -1,
'position' => 95),
343 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'VAT',
'enabled' => 1,
'visible' => -1,
'position' => 125,
'isameasure' => 1),
344 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'LocalTax1',
'enabled' => 1,
'visible' => -1,
'position' => 130,
'isameasure' => 1),
345 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'LocalTax2',
'enabled' => 1,
'visible' => -1,
'position' => 135,
'isameasure' => 1),
346 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalHT',
'enabled' => 1,
'visible' => -1,
'position' => 140,
'isameasure' => 1),
347 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalTTC',
'enabled' => 1,
'visible' => -1,
'position' => 145,
'isameasure' => 1),
348 'signed_status' => array(
'type' =>
'smallint(6)',
'label' =>
'SignedStatus',
'enabled' => 1,
'visible' => -1,
'position' => 146,
'arrayofkeyval' => array(0 =>
'NoSignature', 1 =>
'SignedSender', 2 =>
'SignedReceiver', 9 =>
'SignedAll')),
349 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 150),
350 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 155),
351 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'PDFTemplate',
'enabled' => 1,
'visible' => 0,
'position' => 160),
352 'fk_account' => array(
'type' =>
'integer',
'label' =>
'BankAccount',
'enabled' =>
'isModEnabled("bank")',
'visible' => -1,
'position' => 170),
353 'fk_currency' => array(
'type' =>
'varchar(3)',
'label' =>
'MulticurrencyID',
'enabled' => 1,
'visible' => -1,
'position' => 175),
354 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentTerm',
'enabled' => 1,
'visible' => -1,
'position' => 180),
355 'deposit_percent' => array(
'type' =>
'varchar(63)',
'label' =>
'DepositPercent',
'enabled' => 1,
'visible' => -1,
'position' => 181),
356 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentMode',
'enabled' => 1,
'visible' => -1,
'position' => 185),
357 'date_livraison' => array(
'type' =>
'date',
'label' =>
'DateDeliveryPlanned',
'enabled' => 1,
'visible' => -1,
'position' => 190,
'csslist' =>
'nowraponall'),
358 'fk_shipping_method' => array(
'type' =>
'integer',
'label' =>
'ShippingMethod',
'enabled' => 1,
'visible' => -1,
'position' => 195),
359 'fk_warehouse' => array(
'type' =>
'integer:Entrepot:product/stock/class/entrepot.class.php',
'label' =>
'DefaultWarehouse',
'enabled' =>
'isModEnabled("stock")',
'visible' => -1,
'position' => 200,
'nodepth' => 1),
360 'fk_availability' => array(
'type' =>
'integer',
'label' =>
'Availability',
'enabled' => 1,
'visible' => -1,
'position' => 205),
361 'fk_input_reason' => array(
'type' =>
'integer',
'label' =>
'InputReason',
'enabled' => 1,
'visible' => -1,
'position' => 210),
363 'extraparams' => array(
'type' =>
'varchar(255)',
'label' =>
'Extraparams',
'enabled' => 1,
'visible' => -1,
'position' => 225),
364 'fk_incoterms' => array(
'type' =>
'integer',
'label' =>
'IncotermCode',
'enabled' =>
'isModEnabled("incoterm")',
'visible' => -1,
'position' => 230),
365 'location_incoterms' => array(
'type' =>
'varchar(255)',
'label' =>
'IncotermLabel',
'enabled' =>
'isModEnabled("incoterm")',
'visible' => -1,
'position' => 235),
366 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'Fk multicurrency',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 240),
367 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'MulticurrencyCurrency',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 245),
368 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyRate',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 250,
'isameasure' => 1),
369 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountHT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 255,
'isameasure' => 1),
370 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountVAT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 260,
'isameasure' => 1),
371 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountTTC',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 265,
'isameasure' => 1),
372 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'LastMainDoc',
'enabled' => 1,
'visible' => -1,
'position' => 270),
373 'module_source' => array(
'type' =>
'varchar(32)',
'label' =>
'POSModule',
'enabled' => 1,
'visible' => -1,
'position' => 275),
374 'pos_source' => array(
'type' =>
'varchar(32)',
'label' =>
'POSTerminal',
'enabled' => 1,
'visible' => -1,
'position' => 280),
375 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -1,
'position' => 300),
376 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 302),
377 'date_creation' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -2,
'position' => 304,
'csslist' =>
'nowraponall'),
378 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 306),
379 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 400),
380 'fk_statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Status',
'enabled' => 1,
'visible' => -1,
'position' => 500),
420 const STATUS_NO_SIGNATURE = 0;
425 const STATUS_SIGNED_SENDER = 1;
430 const STATUS_SIGNED_RECEIVER = 2;
435 const STATUS_SIGNED_ALL = 9;
447 $this->ismultientitymanaged = 1;
448 $this->isextrafieldmanaged = 1;
450 $this->fields[
'ref_ext'][
'visible'] =
getDolGlobalInt(
'MAIN_LIST_SHOW_REF_EXT');
460 public function getNextNumRef($soc)
462 global $langs, $conf;
463 $langs->load(
"order");
472 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
473 foreach ($dirmodels as $reldir) {
477 $mybool = ((bool) @include_once $dir.$file) || $mybool;
485 $obj =
new $classname();
487 '@phan-var-force ModeleNumRefCommandes $obj';
489 $numref = $obj->getNextValue($soc, $this);
494 $this->error = $obj->error;
499 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_COMMANDE_ADDON_NotDefined");
513 public function valid($user, $idwarehouse = 0, $notrigger = 0)
515 global $conf, $langs;
517 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
522 if ($this->
status == self::STATUS_VALIDATED) {
523 dol_syslog(get_class($this).
"::valid action abandoned: already validated", LOG_WARNING);
527 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
528 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'validate')))) {
529 $this->error =
'NotEnoughPermissions';
530 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
533 if (empty($this->socid)) {
534 $this->error =
'ErrorWrongParameters';
538 dol_syslog(get_class($this).
"::valid checkActiveProductInLines ".$this->error, LOG_INFO);
547 $soc->fetch($this->socid);
550 $result = $soc->setAsCustomer();
553 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
554 $num = $this->getNextNumRef($soc);
556 $num = (string) $this->
ref;
561 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
562 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
563 $sql .=
" fk_statut = ".self::STATUS_VALIDATED.
",";
564 $sql .=
" date_valid = '".$this->db->idate($now).
"',";
565 $sql .=
" fk_user_valid = ".($user->id > 0 ? (int) $user->id :
"null").
",";
566 $sql .=
" fk_user_modif = ".((int) $user->id);
567 $sql .=
" WHERE rowid = ".((int) $this->
id);
569 dol_syslog(get_class($this).
"::valid", LOG_DEBUG);
570 $resql = $this->db->query($sql);
573 $this->error = $this->db->lasterror();
580 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
581 $langs->load(
"agenda");
584 $cpt = count($this->lines);
585 for ($i = 0; $i < $cpt; $i++) {
586 if ($this->lines[$i]->fk_product > 0) {
588 $mouvP->origin = &$this;
589 $mouvP->setOrigin($this->element, $this->
id);
591 $result = $mouvP->livraison($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $this->lines[$i]->subprice, $langs->trans(
"OrderValidatedInDolibarr", $num));
604 if (!$error && !$notrigger) {
606 $result = $this->call_trigger(
'ORDER_VALIDATE', $user);
614 $this->oldref = $this->ref;
617 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
619 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'commande/".$this->db->escape($this->newref).
"'";
620 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
621 $resql = $this->db->query($sql);
624 $this->error = $this->db->lasterror();
626 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'commande/".$this->db->escape($this->newref).
"'";
627 $sql .=
" WHERE filepath = 'commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
628 $resql = $this->db->query($sql);
631 $this->error = $this->db->lasterror();
637 $dirsource = $conf->commande->multidir_output[$this->entity].
'/'.$oldref;
638 $dirdest = $conf->commande->multidir_output[$this->entity].
'/'.$newref;
639 if (!$error && file_exists($dirsource)) {
640 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
642 if (@rename($dirsource, $dirdest)) {
645 $listoffiles =
dol_dir_list($conf->commande->multidir_output[$this->entity].
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
646 foreach ($listoffiles as $fileentry) {
647 $dirsource = $fileentry[
'name'];
648 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
649 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
650 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
651 @rename($dirsource, $dirdest);
669 $this->db->rollback();
694 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
695 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'validate')))) {
696 $this->error =
'Permission denied';
704 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
705 $sql .=
" SET fk_statut = ".((int) self::STATUS_DRAFT).
",";
706 $sql .=
" fk_user_modif = ".((int) $user->id);
707 $sql .=
" WHERE rowid = ".((int) $this->
id);
709 if ($this->db->query($sql)) {
710 $this->oldcopy = clone $this;
716 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
717 $langs->load(
"agenda");
719 $num = count($this->lines);
720 for ($i = 0; $i < $num; $i++) {
721 if ($this->lines[$i]->fk_product > 0) {
723 $mouvP->origin = &$this;
724 $mouvP->setOrigin($this->element, $this->
id);
726 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, 0, $langs->transnoentitiesnoconv(
"OrderBackToDraftInDolibarr", $this->ref));
738 $result = $this->call_trigger(
'ORDER_UNVALIDATE', $user);
750 $this->db->rollback();
754 $this->error = $this->db->error();
755 $this->db->rollback();
774 if ($this->
status != self::STATUS_CANCELED && $this->
status != self::STATUS_CLOSED) {
775 dol_syslog(get_class($this).
"::set_reopen order has not status closed", LOG_WARNING);
781 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
782 $sql .=
' SET fk_statut='.self::STATUS_VALIDATED.
', facture=0,';
783 $sql .=
" fk_user_modif = ".((int) $user->id);
784 $sql .=
" WHERE rowid = ".((int) $this->
id);
786 dol_syslog(get_class($this).
"::set_reopen", LOG_DEBUG);
787 $resql = $this->db->query($sql);
790 $result = $this->call_trigger(
'ORDER_REOPEN', $user);
797 $this->error = $this->db->lasterror();
809 foreach ($this->errors as $errmsg) {
810 dol_syslog(get_class($this).
"::set_reopen ".$errmsg, LOG_ERR);
811 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
813 $this->db->rollback();
826 public function cloture($user, $notrigger = 0, $checkpermission = 1)
830 $usercanclose = (!$checkpermission
831 || (!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
832 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'close')));
835 if ($this->
status == self::STATUS_CLOSED) {
842 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
843 $sql .=
' SET fk_statut = '.self::STATUS_CLOSED.
',';
844 $sql .=
' fk_user_cloture = '.((int) $user->id).
',';
845 $sql .=
" date_cloture = '".$this->db->idate($now).
"',";
846 $sql .=
" fk_user_modif = ".((int) $user->id);
849 if ($this->db->query($sql)) {
852 $result = $this->call_trigger(
'ORDER_CLOSE', $user);
866 $this->db->rollback();
870 $this->error = $this->db->lasterror();
872 $this->db->rollback();
892 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
893 return parent::setCategoriesCommon($categories, Categorie::TYPE_ORDER);
904 public function cancel($user, $idwarehouse = -1)
906 global $user, $langs;
912 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
913 $sql .=
" SET fk_statut = ".self::STATUS_CANCELED.
",";
914 $sql .=
" fk_user_modif = ".((int) $user->id);
915 $sql .=
" WHERE rowid = ".((int) $this->
id);
916 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
918 dol_syslog(get_class($this).
"::cancel", LOG_DEBUG);
919 if ($this->db->query($sql)) {
922 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
923 $langs->load(
"agenda");
925 $num = count($this->lines);
926 for ($i = 0; $i < $num; $i++) {
927 if ($this->lines[$i]->fk_product > 0) {
929 $mouvP->setOrigin($this->element, $this->
id);
931 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, 0, $langs->trans(
"OrderCanceledInDolibarr", $this->ref));
943 $result = $this->call_trigger(
'ORDER_CANCEL', $user);
956 foreach ($this->errors as $errmsg) {
957 dol_syslog(get_class($this).
"::cancel ".$errmsg, LOG_ERR);
958 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
960 $this->db->rollback();
964 $this->error = $this->db->error();
965 $this->db->rollback();
978 public function create($user, $notrigger = 0)
980 global $conf, $langs,
$mysoc;
985 if (empty($this->socid)) {
986 $this->error =
'ErrorWrongParameters';
991 $date = ($this->date_commande ? $this->date_commande : $this->date);
992 $this->import_key = trim((
string) $this->import_key);
993 $delivery_date = $this->delivery_date;
996 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1001 if (empty($this->fk_multicurrency)) {
1002 $this->multicurrency_code = $conf->currency;
1003 $this->fk_multicurrency = 0;
1004 $this->multicurrency_tx = 1;
1009 dol_syslog(get_class($this).
"::create user=".$user->id);
1012 if (!empty($this->
ref)) {
1015 $this->error =
'ErrorRefAlreadyExists';
1016 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
1017 $this->db->rollback();
1022 $soc =
new Societe($this->db);
1023 $result = $soc->fetch($this->socid);
1025 $this->error =
"Failed to fetch company";
1026 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
1030 $this->error = $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Source"));
1031 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
1035 $this->date_creation =
dol_now();
1039 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.$this->table_element.
" (";
1040 $sql .=
" ref, fk_soc, date_creation, fk_user_author, fk_projet, date_commande, source, note_private, note_public, ref_ext, ref_client";
1041 $sql .=
", model_pdf, fk_cond_reglement, deposit_percent, fk_mode_reglement, fk_account, fk_availability, fk_input_reason, date_livraison, fk_delivery_address";
1042 $sql .=
", fk_shipping_method";
1043 $sql .=
", fk_warehouse";
1044 $sql .=
", fk_incoterms, location_incoterms";
1045 $sql .=
", entity, module_source, pos_source";
1046 $sql .=
", fk_multicurrency";
1047 $sql .=
", multicurrency_code";
1048 $sql .=
", multicurrency_tx";
1049 $sql .=
", import_key";
1051 $sql .=
" VALUES ('(PROV)', ".((int) $this->socid).
", '".$this->db->idate($this->date_creation).
"', ".($user->id > 0 ? ((int) $user->id) :
"null");
1052 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1053 $sql .=
", '".$this->db->idate($date).
"'";
1054 $sql .=
", ".($this->source >= 0 && $this->source !=
'' ? $this->db->escape((
string) $this->source) :
'null');
1055 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1056 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1057 $sql .=
", ".($this->ref_ext ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
1058 $sql .=
", ".($this->ref_client ?
"'".$this->db->escape($this->ref_client).
"'" :
"null");
1059 $sql .=
", '".$this->db->escape($this->model_pdf).
"'";
1060 $sql .=
", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
"null");
1061 $sql .=
", ".(!empty($this->deposit_percent) ?
"'".$this->db->escape($this->deposit_percent).
"'" :
"null");
1062 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"null");
1063 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
1064 $sql .=
", ".($this->availability_id > 0 ? ((int) $this->availability_id) :
"null");
1065 $sql .=
", ".($this->demand_reason_id > 0 ? ((int) $this->demand_reason_id) :
"null");
1066 $sql .=
", ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1067 $sql .=
", ".($this->fk_delivery_address > 0 ? ((int) $this->fk_delivery_address) :
'NULL');
1068 $sql .=
", ".(!empty($this->shipping_method_id) && $this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
'NULL');
1069 $sql .=
", ".(!empty($this->warehouse_id) && $this->warehouse_id > 0 ? ((int) $this->warehouse_id) :
'NULL');
1070 $sql .=
", ".(int) $this->fk_incoterms;
1071 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
1072 $sql .=
", ".(int) $this->entity;
1073 $sql .=
", ".($this->module_source ?
"'".$this->db->escape($this->module_source).
"'" :
"null");
1074 $sql .=
", ".((!is_null($this->pos_source) && $this->pos_source !=
'') ?
"'".$this->db->escape($this->pos_source).
"'" :
"null");
1075 $sql .=
", ".(int) $this->fk_multicurrency;
1076 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1077 $sql .=
", ".(float) $this->multicurrency_tx;
1078 $sql .=
", '".$this->db->escape($this->import_key).
"'";
1081 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1082 $resql = $this->db->query($sql);
1084 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'commande');
1087 $fk_parent_line = 0;
1088 $num = count($this->lines);
1093 for ($i = 0; $i < $num; $i++) {
1094 $line = $this->lines[$i];
1098 if (!is_object($line)) {
1100 foreach ($line as $key => $val) {
1101 $lineobj->$key = $val;
1104 $this->lines[$i] = $line;
1108 if (($line->product_type != 9 && empty($line->fk_parent_line)) || $line->product_type == 9) {
1109 $fk_parent_line = 0;
1113 $vatrate = $line->tva_tx;
1114 if ($line->vat_src_code && !preg_match(
'/\(.*\)/', (
string) $vatrate)) {
1115 $vatrate .=
' ('.$line->vat_src_code.
')';
1119 $originid = $line->origin_id;
1120 $origintype = empty($line->origin_type) ? $line->origin : $line->origin_type;
1122 $originid = $line->id;
1123 $origintype = $this->element;
1127 if (empty($line->ref_ext)) {
1128 $line->ref_ext =
'';
1136 $line->localtax1_tx,
1137 $line->localtax2_tx,
1139 $line->remise_percent,
1141 $line->fk_remise_except,
1146 $line->product_type,
1148 $line->special_code,
1150 $line->fk_fournprice,
1153 $line->array_options,
1155 (
string) $origintype,
1163 if ($result != self::STOCK_NOT_ENOUGH_FOR_ORDER) {
1164 $this->error = $this->db->lasterror();
1165 $this->errors[] = $this->error;
1168 $this->db->rollback();
1172 if ($result > 0 && $line->product_type == 9) {
1173 $fk_parent_line = $result;
1180 $initialref =
'(PROV'.$this->id.
')';
1181 if (!empty($this->
ref)) {
1182 $initialref = $this->ref;
1185 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
" SET ref='".$this->db->escape($initialref).
"' WHERE rowid=".((int) $this->
id);
1186 if ($this->db->query($sql)) {
1187 $this->
ref = $initialref;
1189 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1190 $this->linked_objects = $this->linkedObjectsIds;
1194 if (!empty($this->linked_objects) && is_array($this->linked_objects)) {
1195 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1196 if (is_array($tmp_origin_id)) {
1197 foreach ($tmp_origin_id as $origin_id) {
1200 $this->error = $this->db->lasterror();
1205 $origin_id = $tmp_origin_id;
1208 $this->error = $this->db->lasterror();
1215 if (!$error &&
getDolGlobalString(
'MAIN_PROPAGATE_CONTACTS_FROM_ORIGIN') && !empty($this->origin) && !empty($this->origin_id)) {
1216 $originforcontact = empty($this->origin_type) ? $this->origin : $this->origin_type;
1217 $originidforcontact = $this->origin_id;
1218 if ($originforcontact ==
'shipping') {
1219 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
1221 $exp->fetch($this->origin_id);
1222 $exp->fetchObjectLinked();
1223 if (count($exp->linkedObjectsIds[
'commande']) > 0) {
1224 foreach ($exp->linkedObjectsIds[
'commande'] as $key => $value) {
1225 $originforcontact =
'commande';
1226 if (is_object($value)) {
1227 $originidforcontact = $value->id;
1229 $originidforcontact = $value;
1236 $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";
1237 $sqlcontact .=
" WHERE element_id = ".((int) $originidforcontact).
" AND ec.fk_c_type_contact = ctc.rowid AND ctc.element = '".$this->db->escape($originforcontact).
"'";
1239 $resqlcontact = $this->db->query($sqlcontact);
1240 if ($resqlcontact) {
1241 while ($objcontact = $this->db->fetch_object($resqlcontact)) {
1243 $this->
add_contact($objcontact->fk_socpeople, $objcontact->code, $objcontact->source);
1257 if (!$error && !$notrigger) {
1259 $result = $this->call_trigger(
'ORDER_CREATE', $user);
1267 $this->db->commit();
1270 $this->db->rollback();
1274 $this->error = $this->db->lasterror();
1275 $this->db->rollback();
1282 $this->error = $this->db->lasterror();
1283 $this->db->rollback();
1298 global $user, $hookmanager;
1305 foreach ($this->lines as $line) {
1306 $line->fetch_optionals();
1310 $objFrom = clone $this;
1313 if (!empty($socid) && $socid != $this->socid) {
1314 $objsoc =
new Societe($this->db);
1316 if ($objsoc->fetch($socid) > 0) {
1317 $this->socid = $objsoc->id;
1318 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1319 $this->deposit_percent = (!empty($objsoc->deposit_percent) ? $objsoc->deposit_percent :
'0');
1320 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1321 $this->fk_project = 0;
1322 $this->fk_delivery_address = 0;
1334 $this->user_author_id = $user->id;
1335 $this->user_validation_id = 0;
1337 $this->date_commande =
dol_now();
1338 $this->date_creation =
'';
1339 $this->date_validation =
'';
1341 $this->ref_client =
'';
1342 $this->ref_customer =
'';
1346 $num = count($this->lines);
1347 for ($i = 0; $i < $num; $i++) {
1348 $this->lines[$i]->ref_ext =
'';
1352 $this->context[
'createfromclone'] =
'createfromclone';
1353 $result = $this->
create($user);
1367 if ($this->socid == $objFrom->socid) {
1376 if (is_object($hookmanager)) {
1377 $parameters = array(
'objFrom' => $objFrom);
1379 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1387 unset($this->context[
'createfromclone']);
1391 $this->db->commit();
1394 $this->db->rollback();
1409 global $conf, $hookmanager;
1411 require_once DOL_DOCUMENT_ROOT .
'/multicurrency/class/multicurrency.class.php';
1412 require_once DOL_DOCUMENT_ROOT .
'/core/class/extrafields.class.php';
1416 $this->date_commande =
dol_now();
1421 for ($i = 0; $i < $num; $i++) {
1424 $line->libelle =
$object->lines[$i]->libelle;
1425 $line->label =
$object->lines[$i]->label;
1426 $line->desc =
$object->lines[$i]->desc;
1427 $line->price =
$object->lines[$i]->price;
1428 $line->subprice =
$object->lines[$i]->subprice;
1429 $line->vat_src_code =
$object->lines[$i]->vat_src_code;
1430 $line->tva_tx =
$object->lines[$i]->tva_tx;
1431 $line->localtax1_tx =
$object->lines[$i]->localtax1_tx;
1432 $line->localtax2_tx =
$object->lines[$i]->localtax2_tx;
1433 $line->qty =
$object->lines[$i]->qty;
1434 $line->fk_remise_except =
$object->lines[$i]->fk_remise_except;
1435 $line->remise_percent =
$object->lines[$i]->remise_percent;
1436 $line->fk_product =
$object->lines[$i]->fk_product;
1437 $line->info_bits =
$object->lines[$i]->info_bits;
1438 $line->product_type =
$object->lines[$i]->product_type;
1439 $line->rang =
$object->lines[$i]->rang;
1440 $line->special_code =
$object->lines[$i]->special_code;
1441 $line->fk_parent_line =
$object->lines[$i]->fk_parent_line;
1442 $line->fk_unit =
$object->lines[$i]->fk_unit;
1444 $line->date_start =
$object->lines[$i]->date_start;
1445 $line->date_end =
$object->lines[$i]->date_end;
1447 $line->fk_fournprice =
$object->lines[$i]->fk_fournprice;
1449 $line->pa_ht = $marginInfos[0];
1450 $line->marge_tx = $marginInfos[1];
1451 $line->marque_tx = $marginInfos[2];
1453 $line->origin =
$object->element;
1454 $line->origin_id =
$object->lines[$i]->id;
1457 $object->lines[$i]->fetch_optionals();
1458 foreach (
$object->lines[$i]->array_options as $options_key => $value) {
1459 $line->array_options[$options_key] = $value;
1462 $this->lines[$i] = $line;
1465 $this->entity =
$object->entity;
1466 $this->socid =
$object->socid;
1467 $this->fk_project =
$object->fk_project;
1468 $this->cond_reglement_id =
$object->cond_reglement_id;
1469 $this->deposit_percent =
$object->deposit_percent;
1470 $this->mode_reglement_id =
$object->mode_reglement_id;
1471 $this->fk_account =
$object->fk_account;
1472 $this->availability_id =
$object->availability_id;
1473 $this->demand_reason_id =
$object->demand_reason_id;
1474 $this->delivery_date =
$object->delivery_date;
1475 $this->shipping_method_id =
$object->shipping_method_id;
1476 $this->warehouse_id =
$object->warehouse_id;
1477 $this->fk_delivery_address =
$object->fk_delivery_address;
1478 $this->contact_id =
$object->contact_id;
1479 $this->ref_client =
$object->ref_client;
1480 $this->ref_customer =
$object->ref_client;
1483 $this->note_private =
$object->note_private;
1484 $this->note_public =
$object->note_public;
1487 $this->origin =
$object->element;
1488 $this->origin_id =
$object->id;
1492 if (!empty(
$object->multicurrency_code)) {
1493 $this->multicurrency_code =
$object->multicurrency_code;
1496 $this->multicurrency_tx =
$object->multicurrency_tx;
1499 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1501 $this->fk_multicurrency = $tmparray[0];
1502 $this->multicurrency_tx = $tmparray[1];
1506 if (empty($this->fk_multicurrency)) {
1507 $this->multicurrency_code = $conf->currency;
1508 $this->fk_multicurrency = 0;
1509 $this->multicurrency_tx = 1;
1517 $element_extrafields = $e->fetch_name_optionals_label($this->table_element);
1519 foreach (
$object->array_options as $options_key => $value) {
1520 if (array_key_exists(str_replace(
'options_',
'', $options_key), $element_extrafields)) {
1521 $this->array_options[$options_key] = $value;
1525 $this->linked_objects[$this->origin] = $this->origin_id;
1526 if (isset(
$object->other_linked_objects) && is_array(
$object->other_linked_objects) && !empty(
$object->other_linked_objects)) {
1527 $this->linked_objects = array_merge($this->linked_objects,
$object->other_linked_objects);
1530 $ret = $this->
create($user);
1534 $hookmanager->initHooks(array(
'orderdao'));
1536 $parameters = array(
'objFrom' =>
$object);
1538 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1548 $this->
valid($user);
1600 public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $fk_product = 0, $remise_percent = 0, $info_bits = 0, $fk_remise_except = 0, $price_base_type =
'HT', $pu_ttc = 0, $date_start =
'', $date_end =
'', $type = 0, $rang = -1, $special_code = 0, $fk_parent_line = 0, $fk_fournprice =
null, $pa_ht = 0, $label =
'', $array_options = array(), $fk_unit =
null, $origin =
'', $origin_id = 0, $pu_ht_devise = 0, $ref_ext =
'', $noupdateafterinsertline = 0)
1602 global
$mysoc, $langs, $user;
1604 $logtext =
"::addline commandeid=$this->id, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, fk_product=$fk_product, remise_percent=$remise_percent";
1605 $logtext .=
", info_bits=$info_bits, fk_remise_except=$fk_remise_except, price_base_type=$price_base_type, pu_ttc=$pu_ttc, date_start=$date_start";
1606 $logtext .=
", date_end=$date_end, type=$type special_code=$special_code, fk_unit=$fk_unit, origin=$origin, origin_id=$origin_id, pu_ht_devise=$pu_ht_devise, ref_ext=$ref_ext rang=$rang";
1607 dol_syslog(get_class($this).$logtext, LOG_DEBUG);
1609 if ($this->
status == self::STATUS_DRAFT) {
1610 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1614 if (empty($remise_percent)) {
1615 $remise_percent = 0;
1620 if (empty($info_bits)) {
1626 if (empty($txtva)) {
1629 if (empty($txlocaltax1)) {
1632 if (empty($txlocaltax2)) {
1635 if (empty($fk_parent_line) || $fk_parent_line < 0) {
1636 $fk_parent_line = 0;
1638 if (empty($this->fk_multicurrency)) {
1639 $this->fk_multicurrency = 0;
1641 if (empty($ref_ext)) {
1645 $remise_percent = (float)
price2num($remise_percent);
1648 $pu_ht_devise =
price2num($pu_ht_devise);
1651 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
1656 if ($price_base_type ==
'HT') {
1661 $label = trim($label);
1662 $desc = trim($desc);
1669 if ($date_start && $date_end && $date_start > $date_end) {
1670 $langs->load(
"errors");
1671 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1677 $product_type = $type;
1678 if (!empty($fk_product) && $fk_product > 0) {
1679 $product =
new Product($this->db);
1680 $result = $product->fetch($fk_product);
1681 $product_type = $product->type;
1683 if (
getDolGlobalString(
'STOCK_MUST_BE_ENOUGH_FOR_ORDER') && $product->isStockManaged()) {
1685 $productChildrenNb = 0;
1687 $productChildrenNb = $product->hasFatherOrChild(1);
1689 if ($productChildrenNb > 0) {
1691 $product_stock =
null;
1692 $product->loadStockForVirtualProduct(
'warehouseopen', $qty);
1693 foreach ($product->stock_warehouse as $componentStockWarehouse) {
1694 if ($product_stock ===
null) {
1695 $product_stock = $componentStockWarehouse->real;
1697 $product_stock = min($product_stock, $componentStockWarehouse->real);
1700 if ($product_stock ===
null) {
1704 $product_stock = $product->stock_reel;
1707 if ($product_stock < $qty) {
1708 $langs->load(
"errors");
1709 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnOrder', $product->ref);
1710 $this->errors[] = $this->error;
1711 dol_syslog(get_class($this).
"::addline error=Product ".$product->ref.
": ".$this->error, LOG_ERR);
1712 $this->db->rollback();
1725 $tmpproduct =
new Product($this->db);
1726 $result = $tmpproduct->fetch($fk_product);
1728 if ($newqty != $qty) {
1730 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'warnings');
1737 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1738 $vat_src_code = $reg[1];
1739 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
1742 $tabprice =
calcul_price_total($qty, (
float) $pu, $remise_percent, $txtva, (
float) $txlocaltax1, (
float) $txlocaltax2, 0, $price_base_type, $info_bits, $product_type,
$mysoc, $localtaxes_type, 100, $this->multicurrency_tx, (
float) $pu_ht_devise);
1752 $total_ht = $tabprice[0];
1753 $total_tva = $tabprice[1];
1754 $total_ttc = $tabprice[2];
1755 $total_localtax1 = $tabprice[9];
1756 $total_localtax2 = $tabprice[10];
1757 $pu_ht = $tabprice[3];
1760 $multicurrency_total_ht = $tabprice[16];
1761 $multicurrency_total_tva = $tabprice[17];
1762 $multicurrency_total_ttc = $tabprice[18];
1763 $pu_ht_devise = $tabprice[19];
1768 if (empty($ranktouse) || $ranktouse == -1) {
1769 $rangmax = $this->
line_max($fk_parent_line);
1770 $ranktouse = $rangmax + 1;
1776 $this->line->context = $this->context;
1778 $this->line->fk_commande = $this->id;
1779 $this->line->label = $label;
1780 $this->line->desc = $desc;
1781 $this->line->qty = (float) $qty;
1782 $this->line->ref_ext = $ref_ext;
1784 $this->line->vat_src_code = $vat_src_code;
1785 $this->line->tva_tx = $txtva;
1786 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
1787 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
1788 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
1789 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
1790 $this->line->fk_product = $fk_product;
1791 $this->line->product_type = $product_type;
1792 $this->line->fk_remise_except = $fk_remise_except;
1793 $this->line->remise_percent = $remise_percent;
1794 $this->line->subprice = (float) $pu_ht;
1795 $this->line->rang = $ranktouse;
1796 $this->line->info_bits = $info_bits;
1797 $this->line->total_ht = (float) $total_ht;
1798 $this->line->total_tva = (float) $total_tva;
1799 $this->line->total_localtax1 = (float) $total_localtax1;
1800 $this->line->total_localtax2 = (float) $total_localtax2;
1801 $this->line->total_ttc = (float) $total_ttc;
1802 $this->line->special_code = $special_code;
1803 if (empty($qty) && empty($special_code)) {
1804 $this->line->special_code = 3;
1806 $this->line->origin = $origin;
1807 $this->line->origin_id = $origin_id;
1808 $this->line->fk_parent_line = $fk_parent_line;
1809 $this->line->fk_unit = $fk_unit;
1811 $this->line->date_start = $date_start;
1812 $this->line->date_end = $date_end;
1814 $this->line->fk_fournprice = $fk_fournprice;
1815 $this->line->pa_ht = $pa_ht;
1818 $this->line->fk_multicurrency = $this->fk_multicurrency;
1819 $this->line->multicurrency_code = $this->multicurrency_code;
1820 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
1821 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
1822 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
1823 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
1825 if (is_array($array_options) && count($array_options) > 0) {
1826 $this->line->array_options = $array_options;
1829 $result = $this->line->insert($user);
1832 if (empty($noupdateafterinsertline)) {
1837 if (!isset($this->context[
'createfromclone'])) {
1838 if (!empty($fk_parent_line)) {
1841 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) {
1843 foreach ($this->lines as $tmpline) {
1844 if ($tmpline->rang >= $ranktouse) {
1845 if (!empty($tmpline->id)) {
1852 $this->lines[] = $this->line;
1854 foreach ($this->lines as $line) {
1855 if ($line->id == $origin_id) {
1856 $this->line->extraparams = $line->extraparams;
1857 $this->line->setExtraParameters();
1862 $this->db->commit();
1863 return $this->line->id;
1865 $this->db->rollback();
1870 dol_syslog(get_class($this).
"::addline error=".$this->error, LOG_ERR);
1871 $this->db->rollback();
1875 dol_syslog(get_class($this).
"::addline status of order must be Draft to allow use of ->addline()", LOG_ERR);
1895 public function add_product($idproduct, $qty, $remise_percent = 0.0, $date_start =
'', $date_end =
'')
1904 if ($idproduct > 0) {
1905 $prod =
new Product($this->db);
1906 $prod->fetch($idproduct);
1910 if (empty($tva_tx)) {
1920 $price = $prod->multiprices[$this->thirdparty->price_level];
1921 $price_ttc = $prod->multiprices_ttc[$this->thirdparty->price_level];
1923 $price = $prod->price;
1924 $price_ttc = $prod->price_ttc;
1929 $line->context = $this->context;
1931 $line->fk_product = $idproduct;
1932 $line->desc = $prod->description;
1934 $line->subprice = $price;
1935 $line->subprice_ttc = $price_ttc;
1936 $line->remise_percent = $remise_percent;
1937 $line->vat_src_code = $vat_src_code;
1938 $line->tva_tx = $tva_tx;
1939 $line->localtax1_tx = $localtax1_tx;
1940 $line->localtax2_tx = $localtax2_tx;
1942 $line->product_ref = $prod->ref;
1943 $line->product_label = $prod->label;
1944 $line->product_desc = $prod->description;
1945 $line->fk_unit = $prod->fk_unit;
1949 $line->date_start = $date_start;
1952 $line->date_end = $date_end;
1955 $this->lines[] = $line;
1987 public function fetch($id, $ref =
'', $ref_ext =
'', $notused =
'')
1990 if (empty($id) && empty($ref) && empty($ref_ext)) {
1994 $sql =
'SELECT c.rowid, c.entity, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_user_valid, c.fk_user_modif, c.fk_statut as status';
1995 $sql .=
', c.amount_ht, c.total_ht, c.total_ttc, c.total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.deposit_percent, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason';
1996 $sql .=
', c.fk_account';
1997 $sql .=
', c.date_commande, c.date_valid, c.tms';
1998 $sql .=
', c.date_livraison as delivery_date';
1999 $sql .=
', c.fk_shipping_method';
2000 $sql .=
', c.fk_warehouse';
2001 $sql .=
', c.fk_projet as fk_project, c.source, c.facture as billed';
2002 $sql .=
', c.note_private, c.note_public, c.ref_client, c.ref_ext, c.model_pdf, c.last_main_doc, c.fk_delivery_address, c.extraparams';
2003 $sql .=
', c.fk_incoterms, c.location_incoterms';
2004 $sql .=
", c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc";
2005 $sql .=
", c.module_source, c.pos_source";
2006 $sql .=
", i.libelle as label_incoterms";
2007 $sql .=
', p.code as mode_reglement_code, p.libelle as mode_reglement_libelle';
2008 $sql .=
', cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc';
2009 $sql .=
', ca.code as availability_code, ca.label as availability_label';
2010 $sql .=
', dr.code as demand_reason_code';
2011 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as c';
2012 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as cr ON c.fk_cond_reglement = cr.rowid';
2013 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as p ON c.fk_mode_reglement = p.id';
2014 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_availability as ca ON c.fk_availability = ca.rowid';
2015 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_input_reason as dr ON c.fk_input_reason = dr.rowid';
2016 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON c.fk_incoterms = i.rowid';
2019 $sql .=
" WHERE c.rowid = ".((int) $id);
2021 $sql .=
" WHERE c.entity IN (".getEntity(
'commande').
")";
2025 $sql .=
" AND c.ref = '".$this->db->escape($ref).
"'";
2028 $sql .=
" AND c.ref_ext = '".$this->db->escape($ref_ext).
"'";
2031 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
2032 $result = $this->db->query($sql);
2034 $obj = $this->db->fetch_object($result);
2036 $this->
id = $obj->rowid;
2037 $this->entity = $obj->entity;
2039 $this->
ref = $obj->ref;
2040 $this->ref_client = $obj->ref_client;
2041 $this->ref_customer = $obj->ref_client;
2042 $this->ref_ext = $obj->ref_ext;
2044 $this->socid = $obj->fk_soc;
2045 $this->thirdparty =
null;
2047 $this->fk_project = $obj->fk_project;
2048 $this->project =
null;
2050 $this->statut = $obj->status;
2051 $this->
status = $obj->status;
2053 $this->user_author_id = $obj->fk_user_author;
2054 $this->user_creation_id = $obj->fk_user_author;
2055 $this->user_validation_id = $obj->fk_user_valid;
2056 $this->user_modification_id = $obj->fk_user_modif;
2057 $this->total_ht = $obj->total_ht;
2058 $this->total_tva = $obj->total_tva;
2059 $this->total_localtax1 = $obj->total_localtax1;
2060 $this->total_localtax2 = $obj->total_localtax2;
2061 $this->total_ttc = $obj->total_ttc;
2062 $this->
date = $this->db->jdate($obj->date_commande);
2063 $this->date_commande = $this->db->jdate($obj->date_commande);
2064 $this->date_creation = $this->db->jdate($obj->date_creation);
2065 $this->date_validation = $this->db->jdate($obj->date_valid);
2066 $this->date_modification = $this->db->jdate($obj->tms);
2067 $this->source = $obj->source;
2068 $this->billed = $obj->billed;
2069 $this->note = $obj->note_private;
2070 $this->note_private = $obj->note_private;
2071 $this->note_public = $obj->note_public;
2072 $this->model_pdf = $obj->model_pdf;
2073 $this->last_main_doc = $obj->last_main_doc;
2074 $this->mode_reglement_id = $obj->fk_mode_reglement;
2075 $this->mode_reglement_code = $obj->mode_reglement_code;
2076 $this->mode_reglement = $obj->mode_reglement_libelle;
2077 $this->cond_reglement_id = $obj->fk_cond_reglement;
2078 $this->cond_reglement_code = $obj->cond_reglement_code;
2079 $this->cond_reglement = $obj->cond_reglement_libelle;
2080 $this->cond_reglement_label = $obj->cond_reglement_libelle;
2081 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
2082 $this->deposit_percent = $obj->deposit_percent;
2083 $this->fk_account = $obj->fk_account;
2084 $this->availability_id = $obj->fk_availability;
2085 $this->availability_code = $obj->availability_code;
2087 $this->demand_reason_id = $obj->fk_input_reason;
2088 $this->demand_reason_code = $obj->demand_reason_code;
2089 $this->delivery_date = $this->db->jdate($obj->delivery_date);
2090 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method :
null;
2091 $this->warehouse_id = ($obj->fk_warehouse > 0) ? $obj->fk_warehouse :
null;
2092 $this->fk_delivery_address = $obj->fk_delivery_address;
2093 $this->module_source = $obj->module_source;
2094 $this->pos_source = $obj->pos_source;
2097 $this->fk_incoterms = $obj->fk_incoterms;
2098 $this->location_incoterms = $obj->location_incoterms;
2099 $this->label_incoterms = $obj->label_incoterms;
2102 $this->fk_multicurrency = $obj->fk_multicurrency;
2103 $this->multicurrency_code = $obj->multicurrency_code;
2104 $this->multicurrency_tx = $obj->multicurrency_tx;
2105 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
2106 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
2107 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2109 $this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2111 $this->lines = array();
2117 $this->db->free($result);
2126 $this->error =
'Order with id '.$id.
' not found sql='.$sql;
2130 $this->error = $this->db->error();
2148 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2149 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
2154 $result = $remise->fetch($idremise);
2157 if ($remise->fk_facture) {
2158 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
2159 $this->db->rollback();
2165 $line->fk_commande = $this->id;
2166 $line->fk_remise_except = $remise->id;
2167 $line->desc = $remise->description;
2168 $line->vat_src_code = $remise->vat_src_code;
2169 $line->tva_tx = $remise->tva_tx;
2170 $line->subprice = -(float) $remise->amount_ht;
2171 $line->price = -(float) $remise->amount_ht;
2172 $line->fk_product = 0;
2174 $line->remise_percent = 0;
2176 $line->info_bits = 2;
2178 $line->total_ht = -(float) $remise->amount_ht;
2179 $line->total_tva = -(float) $remise->amount_tva;
2180 $line->total_ttc = -(float) $remise->amount_ttc;
2182 $result = $line->insert();
2186 $this->db->commit();
2189 $this->db->rollback();
2194 $this->db->rollback();
2198 $this->db->rollback();
2212 public function fetch_lines($only_product = 0, $loadalsotranslation = 0)
2215 $this->lines = array();
2217 $sql =
'SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.ref_ext,';
2218 $sql .=
' l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.fk_remise_except, l.remise_percent, l.subprice, l.subprice_ttc, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code,';
2219 $sql .=
' l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end,';
2220 $sql .=
' l.fk_unit, l.extraparams,';
2221 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_subprice_ttc, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc,';
2222 $sql .=
' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tosell as product_tosell, p.tobuy as product_tobuy, p.tobatch as product_tobatch, p.barcode as product_barcode,';
2223 $sql .=
' p.customcode, p.fk_country as country_id, c.code as country_code,';
2224 $sql .=
' p.weight, p.weight_units, p.volume, p.volume_units, p.packaging';
2225 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element_line.
' as l';
2226 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON (p.rowid = l.fk_product)';
2227 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_country as c ON c.rowid = p.fk_country';
2228 $sql .=
' WHERE l.fk_commande = '.((int) $this->
id);
2229 if ($only_product) {
2230 $sql .=
' AND p.fk_product_type = 0';
2232 $sql .=
' ORDER BY l.rang, l.rowid';
2234 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
2235 $result = $this->db->query($sql);
2237 $num = $this->db->num_rows($result);
2241 $objp = $this->db->fetch_object($result);
2245 $line->rowid = $objp->rowid;
2246 $line->id = $objp->rowid;
2247 $line->fk_commande = $objp->fk_commande;
2248 $line->commande_id = $objp->fk_commande;
2249 $line->label = $objp->custom_label;
2250 $line->desc = $objp->description;
2251 $line->description = $objp->description;
2252 $line->product_type = $objp->product_type;
2253 $line->qty = $objp->qty;
2254 $line->ref_ext = $objp->ref_ext;
2256 $line->vat_src_code = $objp->vat_src_code;
2257 $line->tva_tx = $objp->tva_tx;
2258 $line->localtax1_tx = $objp->localtax1_tx;
2259 $line->localtax2_tx = $objp->localtax2_tx;
2260 $line->localtax1_type = $objp->localtax1_type;
2261 $line->localtax2_type = $objp->localtax2_type;
2262 $line->total_ht = $objp->total_ht;
2263 $line->total_ttc = $objp->total_ttc;
2264 $line->total_tva = $objp->total_tva;
2265 $line->total_localtax1 = $objp->total_localtax1;
2266 $line->total_localtax2 = $objp->total_localtax2;
2267 $line->subprice = (float) $objp->subprice;
2268 $line->subprice_ttc = (float) $objp->subprice_ttc;
2269 $line->fk_remise_except = $objp->fk_remise_except;
2270 $line->remise_percent = $objp->remise_percent;
2271 $line->price = $objp->price;
2272 $line->fk_product = $objp->fk_product;
2273 $line->fk_fournprice = $objp->fk_fournprice;
2274 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
2275 $line->pa_ht = $marginInfos[0];
2276 $line->marge_tx = $marginInfos[1];
2277 $line->marque_tx = $marginInfos[2];
2278 $line->rang = $objp->rang;
2279 $line->info_bits = $objp->info_bits;
2280 $line->special_code = $objp->special_code;
2281 $line->fk_parent_line = $objp->fk_parent_line;
2283 $line->ref = $objp->product_ref;
2284 $line->libelle = $objp->product_label;
2286 $line->product_ref = $objp->product_ref;
2287 $line->product_label = $objp->product_label;
2288 $line->product_tosell = $objp->product_tosell;
2289 $line->product_tobuy = $objp->product_tobuy;
2290 $line->product_desc = $objp->product_desc;
2291 $line->product_tobatch = $objp->product_tobatch;
2292 $line->product_barcode = $objp->product_barcode;
2293 $line->product_custom_code = $objp->customcode;
2294 $line->product_custom_country_id = $objp->country_id;
2295 $line->product_custom_country_code = $objp->country_code;
2297 $line->fk_product_type = $objp->fk_product_type;
2298 $line->fk_unit = $objp->fk_unit;
2300 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
2302 $line->weight = $objp->weight;
2303 $line->weight_units = $objp->weight_units;
2304 $line->volume = $objp->volume;
2305 $line->volume_units = $objp->volume_units;
2306 $line->packaging = $objp->packaging;
2308 $line->date_start = $this->db->jdate($objp->date_start);
2309 $line->date_end = $this->db->jdate($objp->date_end);
2312 $line->fk_multicurrency = $objp->fk_multicurrency;
2313 $line->multicurrency_code = $objp->multicurrency_code;
2314 $line->multicurrency_subprice = $objp->multicurrency_subprice;
2315 $line->multicurrency_subprice_ttc = $objp->multicurrency_subprice_ttc;
2316 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
2317 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
2318 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
2320 $line->fetch_optionals();
2323 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && !empty($objp->fk_product) && !empty($loadalsotranslation)) {
2324 $tmpproduct =
new Product($this->db);
2325 $tmpproduct->fetch($objp->fk_product);
2326 $tmpproduct->getMultiLangs();
2328 $line->multilangs = $tmpproduct->multilangs;
2331 $this->lines[$i] = $line;
2336 $this->db->free($result);
2340 $this->error = $this->db->error();
2354 foreach ($this->lines as $line) {
2355 if ($line->product_type == 0) {
2370 foreach ($this->lines as $line) {
2371 if ($line->product_type == 1) {
2387 $sql =
'SELECT COUNT(DISTINCT ed.fk_expedition) as nb';
2388 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expeditiondet as ed,';
2389 $sql .=
' '.MAIN_DB_PREFIX.$this->table_element_line.
' as cd';
2391 $sql .=
' ed.fk_elementdet = cd.rowid';
2392 $sql .=
' AND cd.fk_commande = '.((int) $this->
id);
2395 dol_syslog(get_class($this).
"::getNbOfShipments", LOG_DEBUG);
2396 $resql = $this->db->query($sql);
2398 $obj = $this->db->fetch_object($resql);
2400 $nb = (int) $obj->nb;
2403 $this->db->free($resql);
2406 $this->error = $this->db->lasterror();
2421 $this->expeditions = array();
2423 $sql =
'SELECT cd.rowid, cd.fk_product,';
2424 $sql .=
' sum(ed.qty) as qty';
2425 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expeditiondet as ed,';
2426 if ($filtre_statut >= 0) {
2427 $sql .=
' '.MAIN_DB_PREFIX.
'expedition as e,';
2429 $sql .=
' '.MAIN_DB_PREFIX.$this->table_element_line.
' as cd';
2431 if ($filtre_statut >= 0) {
2432 $sql .=
' ed.fk_expedition = e.rowid AND';
2434 $sql .=
' ed.fk_elementdet = cd.rowid';
2435 $sql .=
' AND cd.fk_commande = '.((int) $this->
id);
2436 if ($fk_product > 0) {
2437 $sql .=
' AND cd.fk_product = '.((int) $fk_product);
2439 if ($filtre_statut >= 0) {
2440 $sql .=
' AND e.fk_statut >= '.((int) $filtre_statut);
2442 $sql .=
' GROUP BY cd.rowid, cd.fk_product';
2445 dol_syslog(get_class($this).
"::loadExpeditions", LOG_DEBUG);
2446 $resql = $this->db->query($sql);
2448 $num = $this->db->num_rows($resql);
2451 $obj = $this->db->fetch_object($resql);
2452 $this->expeditions[$obj->rowid] = $obj->qty;
2455 $this->db->free($resql);
2458 $this->error = $this->db->lasterror();
2470 $sql =
'SELECT count(*)';
2471 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expedition as e';
2472 $sql .=
', '.MAIN_DB_PREFIX.
'element_element as el';
2473 $sql .=
' WHERE el.fk_source = '.((int) $this->
id);
2474 $sql .=
" AND el.sourcetype = 'commande'";
2475 $sql .=
" AND el.fk_target = e.rowid";
2476 $sql .=
" AND el.targettype = 'shipping'";
2478 $resql = $this->db->query($sql);
2480 $row = $this->db->fetch_row($resql);
2499 if ($this->
status == self::STATUS_DRAFT) {
2505 $line->context = $this->context;
2508 $line->fetch($lineid);
2513 if ($id > 0 && (
int) $line->fk_commande !== (
int) $id) {
2514 $this->db->rollback();
2515 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
2520 $staticline = clone $line;
2521 $line->oldline = $staticline;
2523 if ($line->delete($user) > 0) {
2527 $this->db->commit();
2530 $this->db->rollback();
2531 $this->error = $this->db->lasterror();
2535 $this->db->rollback();
2540 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
2559 dol_syslog(get_class($this).
"::set_remise is deprecated, use setDiscount instead", LOG_NOTICE);
2561 return $this->
setDiscount($user, $remise, $notrigger);
2574 $remise = trim((
string) $remise) ? trim((
string) $remise) : 0;
2576 if ($user->hasRight(
'commande',
'creer')) {
2583 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2584 $sql .=
' SET remise_percent = '.((float) $remise);
2585 $sql .=
' WHERE rowid = '.((int) $this->
id).
' AND fk_statut = '.((int) self::STATUS_DRAFT);
2588 $resql = $this->db->query($sql);
2590 $this->errors[] = $this->db->error();
2595 $this->oldcopy = clone $this;
2596 $this->remise_percent = $remise;
2600 if (!$notrigger && empty($error)) {
2602 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2610 $this->db->commit();
2613 foreach ($this->errors as $errmsg) {
2614 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2615 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2617 $this->db->rollback();
2638 if ($user->hasRight(
'commande',
'creer')) {
2643 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2644 $sql .=
" SET date_commande = ".($date ?
"'".$this->db->idate($date).
"'" :
'null');
2645 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut = ".((int) self::STATUS_DRAFT);
2648 $resql = $this->db->query($sql);
2650 $this->errors[] = $this->db->error();
2655 $this->oldcopy = clone $this;
2656 $this->
date = $date;
2659 if (!$notrigger && empty($error)) {
2661 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2669 $this->db->commit();
2672 foreach ($this->errors as $errmsg) {
2673 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2674 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2676 $this->db->rollback();
2710 if ($user->hasRight(
'commande',
'creer')) {
2715 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2716 $sql .=
" SET date_livraison = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2717 $sql .=
" WHERE rowid = ".((int) $this->
id);
2720 $resql = $this->db->query($sql);
2722 $this->errors[] = $this->db->error();
2727 $this->oldcopy = clone $this;
2728 $this->delivery_date = $delivery_date;
2731 if (!$notrigger && empty($error)) {
2733 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2741 $this->db->commit();
2744 foreach ($this->errors as $errmsg) {
2745 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2746 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2748 $this->db->rollback();
2770 public function liste_array($shortlist = 0, $draft = 0, $excluser =
null, $socid = 0, $limit = 0, $offset = 0, $sortfield =
'c.date_commande', $sortorder =
'DESC')
2777 $sql =
"SELECT s.rowid, s.nom as name, s.client,";
2778 $sql .=
" c.rowid as cid, c.ref";
2779 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2780 $sql .=
", sc.fk_soc, sc.fk_user";
2782 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.$this->table_element.
" as c";
2783 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2784 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
2786 $sql .=
" WHERE c.entity IN (".getEntity(
'commande').
")";
2787 $sql .=
" AND c.fk_soc = s.rowid";
2788 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2789 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
2792 $sql .=
" AND s.rowid = ".((int) $socid);
2795 $sql .=
" AND c.fk_statut = ".self::STATUS_DRAFT;
2797 if (is_object($excluser)) {
2798 $sql .=
" AND c.fk_user_author <> ".((int) $excluser->id);
2800 $sql .= $this->db->order($sortfield, $sortorder);
2801 $sql .= $this->db->plimit($limit, $offset);
2803 $result = $this->db->query($sql);
2805 $numc = $this->db->num_rows($result);
2808 while ($i < $numc) {
2809 $obj = $this->db->fetch_object($result);
2811 if ($shortlist == 1) {
2812 $ga[$obj->cid] = $obj->ref;
2813 } elseif ($shortlist == 2) {
2814 $ga[$obj->cid] = $obj->ref.
' ('.$obj->name.
')';
2816 $ga[$i][
'id'] = $obj->cid;
2817 $ga[$i][
'ref'] = $obj->ref;
2818 $ga[$i][
'name'] = $obj->name;
2841 dol_syslog(
'Commande::availability('.$availability_id.
')');
2842 if ($this->
status >= self::STATUS_DRAFT) {
2847 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2848 $sql .=
' SET fk_availability = '.((int) $availability_id);
2849 $sql .=
' WHERE rowid='.((int) $this->
id);
2852 $resql = $this->db->query($sql);
2854 $this->errors[] = $this->db->error();
2859 $this->oldcopy = clone $this;
2860 $this->availability_id = $availability_id;
2863 if (!$notrigger && empty($error)) {
2865 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2873 $this->db->commit();
2876 foreach ($this->errors as $errmsg) {
2877 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2878 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2880 $this->db->rollback();
2884 $error_str =
'Command status do not meet requirement '.$this->status;
2886 $this->error = $error_str;
2887 $this->errors[] = $this->error;
2905 dol_syslog(
'Commande::demand_reason('.$demand_reason_id.
')');
2906 if ($this->
status >= self::STATUS_DRAFT) {
2911 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2912 $sql .=
' SET fk_input_reason = '.((int) $demand_reason_id);
2913 $sql .=
' WHERE rowid='.((int) $this->
id);
2916 $resql = $this->db->query($sql);
2918 $this->errors[] = $this->db->error();
2923 $this->oldcopy = clone $this;
2924 $this->demand_reason_id = $demand_reason_id;
2927 if (!$notrigger && empty($error)) {
2929 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2937 $this->db->commit();
2940 foreach ($this->errors as $errmsg) {
2941 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2942 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2944 $this->db->rollback();
2948 $error_str =
'order status do not meet requirement '.$this->status;
2950 $this->error = $error_str;
2951 $this->errors[] = $this->error;
2968 if ($user->hasRight(
'commande',
'creer')) {
2973 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET';
2974 $sql .=
' ref_client = '.(empty($ref_client) ?
'NULL' :
"'".$this->db->escape($ref_client).
"'");
2975 $sql .=
' WHERE rowid = '.((int) $this->
id);
2977 dol_syslog(__METHOD__.
' this->id='.$this->id.
', ref_client='.$ref_client, LOG_DEBUG);
2978 $resql = $this->db->query($sql);
2980 $this->errors[] = $this->db->error();
2985 $this->oldcopy = clone $this;
2986 $this->ref_client = $ref_client;
2987 $this->ref_customer = $ref_client;
2990 if (!$notrigger && empty($error)) {
2992 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
2999 $this->db->commit();
3002 foreach ($this->errors as $errmsg) {
3003 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
3004 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3006 $this->db->rollback();
3025 if ($this->billed) {
3031 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET facture = 1';
3034 dol_syslog(get_class($this).
"::classifyBilled", LOG_DEBUG);
3035 if ($this->db->query($sql)) {
3036 $this->oldcopy = clone $this;
3039 if (!$notrigger && empty($error)) {
3041 $result = $this->call_trigger(
'ORDER_CLASSIFY_BILLED', $user);
3049 $this->db->commit();
3052 foreach ($this->errors as $errmsg) {
3053 dol_syslog(get_class($this).
"::classifyBilled ".$errmsg, LOG_ERR);
3054 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3056 $this->db->rollback();
3060 $this->error = $this->db->error();
3061 $this->db->rollback();
3079 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET facture = 0';
3082 dol_syslog(get_class($this).
"::classifyUnBilled", LOG_DEBUG);
3083 if ($this->db->query($sql)) {
3084 $this->oldcopy = clone $this;
3087 if (!$notrigger && empty($error)) {
3089 $result = $this->call_trigger(
'ORDER_CLASSIFY_UNBILLED', $user);
3099 $this->db->commit();
3102 foreach ($this->errors as $errmsg) {
3103 dol_syslog(get_class($this).
"::classifyUnBilled ".$errmsg, LOG_ERR);
3104 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3106 $this->db->rollback();
3110 $this->error = $this->db->error();
3111 $this->db->rollback();
3147 public function updateline($rowid, $desc, $pu, $qty, $remise_percent, $txtva, $txlocaltax1 = 0.0, $txlocaltax2 = 0.0, $price_base_type =
'HT', $info_bits = 0, $date_start =
'', $date_end =
'', $type = 0, $fk_parent_line = 0, $skip_update_total = 0, $fk_fournprice =
null, $pa_ht = 0, $label =
'', $special_code = 0, $array_options = array(), $fk_unit =
null, $pu_ht_devise = 0, $notrigger = 0, $ref_ext =
'', $rang = 0)
3149 global
$mysoc, $langs, $user;
3152 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
3156 dol_syslog(get_class($this).
"::updateline id=$rowid, desc=$desc, pu=$pu, qty=$qty, remise_percent=$remise_percent, txtva=$txtva, txlocaltax1=$txlocaltax1, txlocaltax2=$txlocaltax2, price_base_type=$price_base_type, info_bits=$info_bits, date_start=$date_start, date_end=$date_end, type=$type, fk_parent_line=$fk_parent_line, pa_ht=$pa_ht, special_code=$special_code, ref_ext=$ref_ext");
3157 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
3164 if (empty($info_bits)) {
3167 if (empty($txtva)) {
3170 if (empty($txlocaltax1)) {
3173 if (empty($txlocaltax2)) {
3176 if (empty($remise_percent)) {
3177 $remise_percent = 0;
3179 if (empty($qty) && empty($special_code)) {
3182 if (!empty($qty) && $special_code == 3) {
3185 if (empty($ref_ext)) {
3189 if ($date_start && $date_end && $date_start > $date_end) {
3190 $langs->load(
"errors");
3191 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
3195 $remise_percent = (float)
price2num($remise_percent);
3199 $pu_ht_devise =
price2num($pu_ht_devise);
3200 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
3203 $txlocaltax1 = (float)
price2num($txlocaltax1);
3204 $txlocaltax2 = (float)
price2num($txlocaltax2);
3218 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
3219 $vat_src_code = $reg[1];
3220 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
3227 if ($tmpline->fetch($rowid) > 0) {
3229 if ($newqty != $qty) {
3231 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'warnings');
3236 $tabprice =
calcul_price_total($qty, (
float) $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type,
$mysoc, $localtaxes_type, 100, $this->multicurrency_tx, (
float) $pu_ht_devise);
3238 $total_ht = $tabprice[0];
3239 $total_tva = $tabprice[1];
3240 $total_ttc = $tabprice[2];
3241 $total_localtax1 = $tabprice[9];
3242 $total_localtax2 = $tabprice[10];
3243 $pu_ht = $tabprice[3];
3244 $pu_tva = $tabprice[4];
3245 $pu_ttc = $tabprice[5];
3248 $multicurrency_total_ht = $tabprice[16];
3249 $multicurrency_total_tva = $tabprice[17];
3250 $multicurrency_total_ttc = $tabprice[18];
3251 $pu_ht_devise = $tabprice[19];
3255 $line->fetch($rowid);
3256 $line->fetch_optionals();
3258 if (!empty($line->fk_product)) {
3259 $product =
new Product($this->db);
3260 $result = $product->fetch($line->fk_product);
3261 $product_type = $product->type;
3263 if (
getDolGlobalString(
'STOCK_MUST_BE_ENOUGH_FOR_ORDER') && $product->isStockManaged()) {
3265 $productChildrenNb = 0;
3267 $productChildrenNb = $product->hasFatherOrChild(1);
3269 if ($productChildrenNb > 0) {
3271 $product_stock =
null;
3272 $product->loadStockForVirtualProduct(
'warehouseopen', $qty);
3273 foreach ($product->stock_warehouse as $componentStockWarehouse) {
3274 if ($product_stock ===
null) {
3275 $product_stock = $componentStockWarehouse->real;
3277 $product_stock = min($product_stock, $componentStockWarehouse->real);
3280 if ($product_stock ===
null) {
3284 $product_stock = $product->stock_reel;
3287 if ($product_stock < $qty) {
3288 $langs->load(
"errors");
3289 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnOrder', (
string) $product->ref);
3290 $this->errors[] = $this->error;
3292 dol_syslog(get_class($this).
"::addline error=Product ".$product->ref.
": ".$this->error, LOG_ERR);
3294 $this->db->rollback();
3300 $staticline = clone $line;
3302 $line->oldline = $staticline;
3303 $this->line = $line;
3304 $this->line->context = $this->context;
3305 $this->line->rang = $rang;
3308 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
3309 $rangmax = $this->
line_max($fk_parent_line);
3310 $this->line->rang = $rangmax + 1;
3314 $this->line->id = $rowid;
3315 $this->line->label = $label;
3316 $this->line->desc = $desc;
3317 $this->line->qty = $qty;
3318 $this->line->ref_ext = $ref_ext;
3320 $this->line->vat_src_code = $vat_src_code;
3321 $this->line->tva_tx = $txtva;
3322 $this->line->localtax1_tx = $txlocaltax1;
3323 $this->line->localtax2_tx = $txlocaltax2;
3324 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
3325 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
3326 $this->line->remise_percent = $remise_percent;
3327 $this->line->subprice = (float) $pu_ht;
3328 $this->line->info_bits = $info_bits;
3329 $this->line->special_code = $special_code;
3330 $this->line->total_ht = (float) $total_ht;
3331 $this->line->total_tva = (float) $total_tva;
3332 $this->line->total_localtax1 = (float) $total_localtax1;
3333 $this->line->total_localtax2 = (float) $total_localtax2;
3334 $this->line->total_ttc = (float) $total_ttc;
3335 $this->line->date_start = $date_start;
3336 $this->line->date_end = $date_end;
3337 $this->line->product_type = $type;
3338 $this->line->fk_parent_line = $fk_parent_line;
3339 $this->line->skip_update_total = $skip_update_total;
3340 $this->line->fk_unit = $fk_unit;
3342 $this->line->fk_fournprice = $fk_fournprice;
3343 $this->line->pa_ht = $pa_ht;
3346 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
3347 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
3348 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
3349 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
3351 if (is_array($array_options) && count($array_options) > 0) {
3353 foreach ($array_options as $key => $value) {
3354 $this->line->array_options[$key] = $array_options[$key];
3358 $result = $this->line->update($user, $notrigger);
3361 if (!empty($fk_parent_line)) {
3368 $this->db->commit();
3373 $this->db->rollback();
3377 $this->error = get_class($this).
"::updateline Order status makes operation forbidden";
3378 $this->errors = array(
'OrderStatusMakeOperationForbidden');
3395 if (isset($this->
ref)) {
3396 $this->
ref = trim($this->
ref);
3398 if (isset($this->ref_client)) {
3399 $this->ref_client = trim($this->ref_client);
3401 if (isset($this->ref_customer)) {
3402 $this->ref_customer = trim($this->ref_customer);
3404 if (isset($this->note) || isset($this->note_private)) {
3405 $this->note_private = (isset($this->note_private) ? trim($this->note_private) : trim($this->note));
3407 if (isset($this->note_public)) {
3408 $this->note_public = trim($this->note_public);
3410 if (isset($this->model_pdf)) {
3411 $this->model_pdf = trim($this->model_pdf);
3413 if (isset($this->import_key)) {
3414 $this->import_key = trim($this->import_key);
3416 $delivery_date = $this->delivery_date;
3422 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
3424 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
3425 $sql .=
" ref_client=".(isset($this->ref_client) ?
"'".$this->db->escape($this->ref_client).
"'" :
"null").
",";
3426 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
3427 $sql .=
" fk_soc=".(isset($this->socid) ? $this->socid :
"null").
",";
3428 $sql .=
" date_commande=".(strval($this->date_commande) !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
'null').
",";
3429 $sql .=
" date_valid=".(strval($this->date_validation) !=
'' ?
"'".$this->db->idate($this->date_validation).
"'" :
'null').
",";
3430 $sql .=
" total_tva=".(isset($this->total_tva) ? (float) $this->total_tva :
"null").
",";
3431 $sql .=
" localtax1=".(isset($this->total_localtax1) ? (float) $this->total_localtax1 :
"null").
",";
3432 $sql .=
" localtax2=".(isset($this->total_localtax2) ? (float) $this->total_localtax2 :
"null").
",";
3433 $sql .=
" total_ht=".(isset($this->total_ht) ? (float) $this->total_ht :
"null").
",";
3434 $sql .=
" total_ttc=".(isset($this->total_ttc) ? (float) $this->total_ttc :
"null").
",";
3435 $sql .=
" fk_statut=".(isset($this->
status) ? (int) $this->
status :
"null").
",";
3436 $sql .=
" fk_user_modif=".(isset($user->id) ? (int) $user->id :
"null").
",";
3437 $sql .=
" fk_user_valid=".((isset($this->user_validation_id) && $this->user_validation_id > 0) ? (
int) $this->user_validation_id :
"null").
",";
3438 $sql .=
" fk_projet=".(isset($this->fk_project) ? (int) $this->fk_project :
"null").
",";
3439 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? (int) $this->cond_reglement_id :
"null").
",";
3440 $sql .=
" deposit_percent=".(!empty($this->deposit_percent) ?
"'".$this->db->escape($this->deposit_percent).
"'" :
"null").
",";
3441 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? $this->mode_reglement_id :
"null").
",";
3442 $sql .=
" date_livraison=".(strval($this->delivery_date) !=
'' ?
"'".$this->db->idate($this->delivery_date).
"'" :
'null').
",";
3443 $sql .=
" fk_shipping_method=".(isset($this->shipping_method_id) ? (int) $this->shipping_method_id :
"null").
",";
3444 $sql .=
" fk_account=".($this->fk_account > 0 ? (int) $this->fk_account :
"null").
",";
3445 $sql .=
" fk_input_reason=".($this->demand_reason_id > 0 ? (int) $this->demand_reason_id :
"null").
",";
3446 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
3447 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
3448 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
3449 $sql .=
" fk_warehouse=".($this->warehouse_id > 0 ? (int) $this->warehouse_id :
"null").
",";
3450 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null").
",";
3451 $sql .=
" module_source = ".(isset($this->module_source) ?
"'".$this->db->escape($this->module_source).
"'" :
"null").
",";
3452 $sql .=
" pos_source = ".(isset($this->pos_source) ?
"'".$this->db->escape($this->pos_source).
"'" :
"null");
3453 $sql .=
" WHERE rowid=".((int) $this->
id);
3457 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3458 $resql = $this->db->query($sql);
3461 $this->errors[] =
"Error ".$this->db->lasterror();
3471 if (!$error && !$notrigger) {
3473 $result = $this->call_trigger(
'ORDER_MODIFY', $user);
3482 foreach ($this->errors as $errmsg) {
3483 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
3484 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3486 $this->db->rollback();
3489 $this->db->commit();
3501 public function delete($user, $notrigger = 0)
3503 global $conf, $langs;
3504 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
3508 dol_syslog(get_class($this).
"::delete ".$this->
id, LOG_DEBUG);
3514 $result = $this->call_trigger(
'ORDER_DELETE', $user);
3523 $this->errors[] = $langs->trans(
'SomeShipmentExists');
3529 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_order";
3530 $sql .=
" WHERE fk_order = ".((int) $this->
id);
3532 $result = $this->db->query($sql);
3535 $this->errors[] = $this->db->lasterror();
3540 if (!$error && !empty($this->table_element_line)) {
3541 $tabletodelete = $this->table_element_line;
3542 $sqlef =
"DELETE FROM ".MAIN_DB_PREFIX.$tabletodelete.
"_extrafields WHERE fk_object IN (SELECT rowid FROM ".MAIN_DB_PREFIX.$tabletodelete.
" WHERE ".$this->fk_element.
" = ".((int) $this->
id).
")";
3543 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$tabletodelete.
" WHERE ".$this->fk_element.
" = ".((int) $this->
id);
3544 if (!$this->db->query($sqlef) || !$this->db->query($sql)) {
3546 $this->error = $this->db->lasterror();
3547 $this->errors[] = $this->error;
3548 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3573 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3579 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$this->table_element.
" WHERE rowid = ".((int) $this->
id);
3580 $res = $this->db->query($sql);
3583 $this->error = $this->db->lasterror();
3584 $this->errors[] = $this->error;
3585 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3601 if ($conf->commande->multidir_output[$this->entity] && !empty($this->
ref)) {
3602 $dir = $conf->commande->multidir_output[$this->entity].
"/".$ref;
3603 $file = $dir.
"/".$ref.
".pdf";
3604 if (file_exists($file)) {
3608 $this->error =
'ErrorFailToDeleteFile';
3609 $this->errors[] = $this->error;
3610 $this->db->rollback();
3614 if (file_exists($dir)) {
3617 $this->error =
'ErrorFailToDeleteDir';
3618 $this->errors[] = $this->error;
3619 $this->db->rollback();
3627 dol_syslog(get_class($this).
"::delete ".$this->
id.
" by ".$user->id, LOG_DEBUG);
3628 $this->db->commit();
3631 $this->db->rollback();
3648 global $conf, $langs, $hookmanager;
3652 $sql =
"SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht";
3653 $sql .=
" FROM ".MAIN_DB_PREFIX.$this->table_element.
" as c";
3654 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
3655 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON c.fk_soc = sc.fk_soc";
3656 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3659 $sql .= $clause.
" c.entity IN (".
getEntity(
'commande').
")";
3661 if ($mode ==
'toship') {
3663 $sql .=
" AND c.fk_statut IN (" . self::STATUS_VALIDATED .
"," . self::STATUS_SHIPMENTONPROCESS .
")";
3665 if ($mode ==
'tobill') {
3667 $sql .=
" AND c.fk_statut IN (" . self::STATUS_VALIDATED .
"," . self::STATUS_SHIPMENTONPROCESS .
", " . self::STATUS_CLOSED .
") AND c.facture = 0";
3669 if ($mode ==
'shippedtobill') {
3671 $sql .=
" AND c.fk_statut IN (" . self::STATUS_CLOSED .
") AND c.facture = 0";
3674 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
3677 $parameters = array(
'socid' => $user->socid);
3678 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
3679 $sql .= $hookmanager->resPrint;
3680 $resql = $this->db->query($sql);
3683 $label = $labelShort = $url =
'';
3684 if ($mode ==
'toship') {
3685 $delay_warning = $conf->commande->client->warning_delay / 60 / 60 / 24;
3686 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=-2&mainmenu=commercial&leftmenu=orders';
3687 $label = $langs->transnoentitiesnoconv(
"OrdersToProcess");
3688 $labelShort = $langs->transnoentitiesnoconv(
"Opened");
3690 if ($mode ==
'tobill') {
3691 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=-3&search_billed=0&mainmenu=commercial&leftmenu=orders';
3692 $label = $langs->trans(
"OrdersToBill");
3693 $labelShort = $langs->trans(
"ToBill");
3695 if ($mode ==
'shippedtobill') {
3696 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=3&search_billed=0&mainmenu=commercial&leftmenu=orders';
3697 $label = $langs->trans(
"OrdersToBill");
3698 $labelShort = $langs->trans(
"StatusOrderDelivered").
' '.$langs->trans(
"and").
' '.$langs->trans(
"ToBill");
3703 $response->warning_delay = $delay_warning;
3704 $response->label = $label;
3705 $response->labelShort = $labelShort;
3706 $response->url = $url;
3707 $response->url_late = DOL_URL_ROOT.
'/commande/list.php?search_option=late&mainmenu=commercial&leftmenu=orders';
3710 $generic_commande =
new Commande($this->db);
3712 while ($obj = $this->db->fetch_object($resql)) {
3713 $response->nbtodo++;
3714 $response->total += $obj->total_ht;
3716 $generic_commande->status = $obj->fk_statut;
3717 $generic_commande->date = $this->db->jdate($obj->date_commande);
3718 $generic_commande->delivery_date = $this->db->jdate($obj->delivery_date);
3720 if ($mode ==
'toship' && $generic_commande->hasDelay()) {
3721 $response->nbtodolate++;
3727 $this->error = $this->db->error();
3741 $label = $langs->trans(
'OrderSource'.$this->source);
3743 if ($label ==
'OrderSource') {
3770 public function LibStatut($status, $billed, $mode, $donotshowbilled = 0)
3773 global $langs, $hookmanager;
3776 if (empty($donotshowbilled)) {
3777 $billedtext .= ($billed ?
' - '.$langs->transnoentitiesnoconv(
"Billed") :
'');
3779 $billedtextlong = ($billed ?
' - '.$langs->transnoentitiesnoconv(
"Billed") :
'');
3783 $paramsBadge = array(
'badgeParams' => array(
'attr' => array(
3784 'data-status-element' => $this->element,
3785 'data-billed' => (
int) $billed,
3786 'data-status' => (
int) $status
3789 if ($status == self::STATUS_CANCELED) {
3790 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderCanceled');
3791 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderCanceledShort');
3792 $statusType =
'status9';
3793 } elseif ($status == self::STATUS_DRAFT) {
3794 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderDraft');
3795 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderDraftShort');
3796 $statusType =
'status0';
3797 } elseif ($status == self::STATUS_VALIDATED) {
3798 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderValidated').$billedtextlong;
3799 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderValidatedShort').$billedtext;
3800 $statusType =
'status1';
3801 } elseif ($status == self::STATUS_SHIPMENTONPROCESS) {
3802 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderSent').$billedtextlong;
3803 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderSentShort').$billedtext;
3804 $labelTooltip = $langs->transnoentitiesnoconv(
"StatusOrderSent");
3805 if (!empty($this->delivery_date)) {
3806 $labelTooltip .=
' - '.$langs->transnoentitiesnoconv(
"DateDeliveryPlanned").dol_print_date($this->delivery_date,
'day').$billedtext;
3808 $statusType =
'status4';
3809 } elseif ($status == self::STATUS_CLOSED) {
3810 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderDelivered').$billedtextlong;
3811 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderDeliveredShort').$billedtext;
3812 $statusType =
'status6';
3814 $labelStatus = $langs->transnoentitiesnoconv(
'Unknown');
3815 $labelStatusShort =
'';
3820 $paramsBadge[
'tooltip'] = $labelTooltip;
3822 $parameters = array(
3823 'status' => $status,
3825 'billed' => $billed,
3826 'donotshowbilled' => $donotshowbilled,
3827 'paramsBadge' => & $paramsBadge
3830 $reshook = $hookmanager->executeHooks(
'LibStatut', $parameters, $this);
3833 return $hookmanager->resPrint;
3836 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode,
'', $paramsBadge);
3848 global $conf, $langs, $user;
3850 $langs->load(
'orders');
3852 $nofetch = !empty($params[
'nofetch']);
3855 return [
'optimize' => $langs->trans(
"Order")];
3858 if ($user->hasRight(
'commande',
'lire')) {
3859 $datas[
'picto'] =
img_picto(
'', $this->picto,
'', 0, 0, 0,
'',
'paddingrightonly').
'<u>'.$langs->trans(
"Order").
'</u>';
3860 if (isset($this->
status)) {
3861 $datas[
'status'] =
' '.$this->getLibStatut(5);
3863 $datas[
'Ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
3865 $langs->load(
'companies');
3866 if (empty($this->thirdparty)) {
3869 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
3871 $datas[
'RefCustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '.(empty($this->ref_customer) ? (empty($this->ref_client) ?
'' : $this->ref_client) : $this->ref_customer);
3873 $langs->load(
'project');
3874 if (is_null($this->project) || (is_object($this->project) && $this->project->isEmpty())) {
3876 if ($res > 0 && $this->project instanceof
Project) {
3877 $datas[
'project'] =
'<br><b>'.$langs->trans(
'Project').
':</b> '.$this->project->getNomUrl(1,
'', 0,
'1');
3881 if (!empty($this->total_ht)) {
3882 $datas[
'AmountHT'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
3884 if (!empty($this->total_tva)) {
3885 $datas[
'VAT'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
3887 if (!empty($this->total_ttc)) {
3888 $datas[
'AmountTTC'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
3890 if (!empty($this->
date)) {
3891 $datas[
'Date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->
date,
'day');
3893 if (!empty($this->delivery_date)) {
3894 $datas[
'DeliveryDate'] =
'<br><b>'.$langs->trans(
'DeliveryDate').
':</b> '.
dol_print_date($this->delivery_date,
'dayhour');
3914 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0, $target =
'')
3916 global $conf, $langs, $user, $hookmanager;
3918 if (!empty($conf->dol_no_mouse_hover)) {
3924 if (
isModEnabled(
"shipping") && ($option ==
'1' || $option ==
'2')) {
3925 $baseurl = DOL_URL_ROOT .
'/expedition/shipment.php';
3927 $baseurl = DOL_URL_ROOT .
'/commande/card.php';
3929 $query = [
'id' => $this->id];
3930 if (!$user->hasRight(
'commande',
'lire')) {
3934 if ($option !==
'nolink') {
3936 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
3937 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
3938 $add_save_lastsearch_values = 1;
3940 if ($add_save_lastsearch_values) {
3941 $query = array_merge($query, [
'save_lastsearch_values' => 1]);
3951 'objecttype' => $this->element,
3952 'option' => $option,
3955 $classfortooltip =
'classfortooltip';
3958 $classfortooltip =
'classforajaxtooltip';
3959 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
3966 if (empty($notooltip) && $user->hasRight(
'commande',
'lire')) {
3968 $label = $langs->trans(
"Order");
3969 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
3971 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
3972 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
3974 $target_value = array(
'_self',
'_blank',
'_parent',
'_top');
3975 if (in_array($target, $target_value)) {
3976 $linkclose .=
' target="'.dol_escape_htmltag($target).
'"';
3980 $linkstart =
'<a href="'.$url.
'"';
3981 $linkstart .= $linkclose.
'>';
3984 if ($option ===
'nolink') {
3989 $result .= $linkstart;
3991 $result .=
img_object(($notooltip ?
'' : $label), $this->picto, (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
3993 if ($withpicto != 2) {
3994 $result .= $this->ref;
3996 $result .= $linkend;
3998 if ($addlinktonotes) {
3999 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
4002 $result .=
' <span class="note inline-block">';
4003 $result .=
'<a href="'.DOL_URL_ROOT.
'/commande/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
4008 $result .=
'</span>';
4013 $hookmanager->initHooks(array($this->element .
'dao'));
4014 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
4015 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
4017 $result = $hookmanager->resPrint;
4019 $result .= $hookmanager->resPrint;
4033 $sql =
'SELECT c.rowid, date_creation as datec, tms as datem,';
4034 $sql .=
' date_valid as datev,';
4035 $sql .=
' date_cloture as datecloture,';
4036 $sql .=
' fk_user_author, fk_user_valid, fk_user_cloture';
4037 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as c';
4038 $sql .=
' WHERE c.rowid = '.((int) $id);
4039 $result = $this->db->query($sql);
4041 if ($this->db->num_rows($result)) {
4042 $obj = $this->db->fetch_object($result);
4043 $this->
id = $obj->rowid;
4044 if ($obj->fk_user_author) {
4045 $this->user_creation_id = $obj->fk_user_author;
4047 if ($obj->fk_user_valid) {
4048 $this->user_validation_id = $obj->fk_user_valid;
4050 if ($obj->fk_user_cloture) {
4051 $this->user_closing_id = $obj->fk_user_cloture;
4054 $this->date_creation = $this->db->jdate($obj->datec);
4055 $this->date_modification = $this->db->jdate($obj->datem);
4056 $this->date_validation = $this->db->jdate($obj->datev);
4057 $this->date_cloture = $this->db->jdate($obj->datecloture);
4060 $this->db->free($result);
4077 global $conf, $langs;
4079 dol_syslog(get_class($this).
"::initAsSpecimen");
4084 $sql =
"SELECT rowid";
4085 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
4086 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
4087 if (array_key_exists(
'tosell', $param)) {
4088 $sql .=
" AND tosell = ".((int) $param[
'tosell']);
4090 $sql .= $this->db->plimit(100);
4092 $resql = $this->db->query($sql);
4094 $num_prods = $this->db->num_rows($resql);
4096 while ($i < $num_prods) {
4098 $row = $this->db->fetch_row($resql);
4099 $prodids[$i] = $row[0];
4105 $this->
ref =
'SPECIMEN';
4106 $this->specimen = 1;
4107 $this->entity = $conf->entity;
4109 $this->
date = time();
4110 $this->date_lim_reglement = $this->
date + 3600 * 24 * 30;
4111 $this->cond_reglement_code =
'RECEP';
4112 $this->mode_reglement_code =
'CHQ';
4113 $this->availability_code =
'DSP';
4114 $this->demand_reason_code =
'SRC_00';
4116 $this->note_public =
'This is a comment (public)';
4117 $this->note_private =
'This is a comment (private)';
4119 $this->multicurrency_tx = 1;
4120 $this->multicurrency_code = $conf->currency;
4122 $this->
status = $this::STATUS_DRAFT;
4128 while ($xnbp < $nbp) {
4131 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
4133 $line->subprice = 100;
4137 $line->total_ht = 50;
4138 $line->total_ttc = 60;
4139 $line->total_tva = 10;
4140 $line->remise_percent = 50;
4142 $line->total_ht = 100;
4143 $line->total_ttc = 120;
4144 $line->total_tva = 20;
4145 $line->remise_percent = 0;
4147 if ($num_prods > 0) {
4148 $prodid = mt_rand(1, $num_prods);
4149 $line->fk_product = $prodids[$prodid];
4150 $line->product_ref =
'SPECIMEN';
4153 $this->lines[$xnbp] = $line;
4155 $this->total_ht += $line->total_ht;
4156 $this->total_tva += $line->total_tva;
4157 $this->total_ttc += $line->total_ttc;
4173 global $user, $hookmanager;
4175 $this->nb = array();
4178 $sql =
"SELECT count(c.rowid) as nb";
4179 $sql .=
" FROM ".MAIN_DB_PREFIX.$this->table_element.
" as c";
4180 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON c.fk_soc = s.rowid";
4181 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
4182 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
4183 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
4186 $sql .=
" ".$clause.
" c.entity IN (".
getEntity(
'commande').
")";
4188 $parameters = array();
4189 $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
4190 $sql .= $hookmanager->resPrint;
4191 $resql = $this->db->query($sql);
4193 while ($obj = $this->db->fetch_object($resql)) {
4194 $this->nb[
"orders"] = $obj->nb;
4196 $this->db->free($resql);
4200 $this->error = $this->db->error();
4226 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
4230 $langs->load(
"orders");
4231 $outputlangs->load(
"products");
4234 $modele =
'einstein';
4236 if (!empty($this->model_pdf)) {
4237 $modele = $this->model_pdf;
4243 $modelpath =
"core/modules/commande/doc/";
4245 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
4298 return max($this->
date, $this->delivery_date) < ($now - $conf->commande->client->warning_delay);
4308 global $conf, $langs;
4310 if (empty($this->delivery_date)) {
4313 $text = $text = $langs->trans(
"DeliveryDate").
' '.
dol_print_date($this->delivery_date,
'day');
4315 $text .=
' '.($conf->commande->client->warning_delay > 0 ?
'+' :
'-').
' '.round(abs($conf->commande->client->warning_delay) / 3600 / 24, 1).
' '.$langs->trans(
"days").
' < '.$langs->trans(
"Today");
if(! $sortfield) if(! $sortorder) $object
Class to manage customers orders.
getNbOfServicesLines()
Return number of line with type service.
getNbOfShipments()
Count number of shipments for this order.
createFromProposal($object, User $user)
Load an object from a proposal and create a new order into database.
setDraft($user, $idwarehouse=-1)
Set draft status.
setDeliveryDate($user, $delivery_date, $notrigger=0)
Set the planned delivery date.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
getLinesArray()
Create an array of order lines.
showDelay()
Show the customer delayed info.
set_date($user, $date, $notrigger=0)
Set the order date.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
loadStateBoard()
Load the indicators this->nb for the state board.
fetch_lines($only_product=0, $loadalsotranslation=0)
Load array lines.
createFromClone(User $user, $socid=0)
Load an object from its id and create a new one in database.
const STATUS_SHIPMENTONPROCESS
Shipment on process.
LibStatut($status, $billed, $mode, $donotshowbilled=0)
Return label of status.
getLibStatut($mode)
Return status label of Order.
hasDelay()
Is the sales order delayed?
const STATUS_CLOSED
Closed (Sent, billed or not)
valid($user, $idwarehouse=0, $notrigger=0)
Validate order.
getLabelSource()
Return source label of order.
set_remise($user, $remise, $notrigger=0)
Applique une remise relative.
initAsSpecimen($param=array())
Initialise an instance with random values.
const STATUS_CANCELED
Canceled status.
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0, $target='')
Return clickable link of object (with eventually picto)
loadExpeditions($filtre_statut=-1, $fk_product=0)
Load array this->expeditions of lines of shipments with nb of products sent for each order line Note:...
__construct($db)
Constructor.
availability($availability_id, $notrigger=0)
Update delivery delay.
set_reopen($user)
Tag the order as validated (opened) Function used when order is reopend after being closed.
set_ref_client($user, $ref_client, $notrigger=0)
Set customer ref.
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1=0, $txlocaltax2=0, $fk_product=0, $remise_percent=0, $info_bits=0, $fk_remise_except=0, $price_base_type='HT', $pu_ttc=0, $date_start='', $date_end='', $type=0, $rang=-1, $special_code=0, $fk_parent_line=0, $fk_fournprice=null, $pa_ht=0, $label='', $array_options=array(), $fk_unit=null, $origin='', $origin_id=0, $pu_ht_devise=0, $ref_ext='', $noupdateafterinsertline=0)
Add an order line into database (linked to product/service or not)
getTooltipContentArray($params)
getTooltipContentArray
create($user, $notrigger=0)
Create sale order Note that this->ref can be set or empty.
demand_reason($demand_reason_id, $notrigger=0)
Update order demand_reason.
const STATUS_DRAFT
Draft status.
const STOCK_NOT_ENOUGH_FOR_ORDER
ERR Not enough stock.
insert_discount($idremise)
Add a discount line into a sale order (as a sale order line) using an existing absolute discount (Con...
getNbOfProductsLines()
Return number of line with type product.
update(User $user, $notrigger=0)
Update database.
classifyUnBilled(User $user, $notrigger=0)
Classify the order as not invoiced.
setDiscount($user, $remise, $notrigger=0)
Set a percentage discount.
setCategories($categories)
Sets object to given categories.
const STATUS_ACCEPTED
For backward compatibility.
updateline($rowid, $desc, $pu, $qty, $remise_percent, $txtva, $txlocaltax1=0.0, $txlocaltax2=0.0, $price_base_type='HT', $info_bits=0, $date_start='', $date_end='', $type=0, $fk_parent_line=0, $skip_update_total=0, $fk_fournprice=null, $pa_ht=0, $label='', $special_code=0, $array_options=array(), $fk_unit=null, $pu_ht_devise=0, $notrigger=0, $ref_ext='', $rang=0)
Update a line in database.
classifyBilled(User $user, $notrigger=0)
Classify the order as invoiced.
info($id)
Charge les information d'ordre info dans l'objet commande.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
const STATUS_VALIDATED
Validated status.
deleteLine($user=null, $lineid=0, $id=0)
Delete an order line.
countNbOfShipments()
Returns an array with expeditions lines number.
liste_array($shortlist=0, $draft=0, $excluser=null, $socid=0, $limit=0, $offset=0, $sortfield='c.date_commande', $sortorder='DESC')
Return list of orders (eventuelly filtered on a user) into an array.
fetch($id, $ref='', $ref_ext='', $notused='')
Get object from database.
cloture($user, $notrigger=0, $checkpermission=1)
Close order.
set_date_livraison($user, $delivery_date, $notrigger=0)
Set delivery date.
add_product($idproduct, $qty, $remise_percent=0.0, $date_start='', $date_end='')
Add line into array $this->client must be loaded.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
setSignedStatus(User $user, int $status=0, int $notrigger=0, $triggercode='')
Set signed status.
cancel($user, $idwarehouse=-1)
Cancel an order If stock is decremented on order validation, we must reincrement it.
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...
line_order($renum=false, $rowidorder='ASC', $fk_parent_line=true)
Save a new position (field rang) for details lines.
deleteEcmFiles($mode=0)
Delete related files of object in database.
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
roundQtyToPackaging($qty, $packaging)
Round a quantity up to the next multiple of a packaging quantity (options PRODUCT_USE_CUSTOMER_PACKAG...
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetchProject()
Load the project with id $this->fk_project into this->project.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
updateRangOfLine($rowid, $rang)
Update position of line (rang)
checkActiveProductInLines($status='onsale')
Check if all products have the right status (on sale, on buy) called during validation of propal,...
deleteExtraFields()
Delete all extra fields values for the current object.
copy_linked_contact($objFrom, $source='internal')
Copy contact from one element to current.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
delete_linked_contact($source='', $code='')
Delete all links between an object $this and all its contacts in llx_element_contact.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Superclass for orders classes.
Class to manage absolute discounts.
Class to manage Dolibarr database access.
Class to manage stock movements.
static getIdAndTxFromCode($dbs, $code, $date_document=0)
Get id and rate of currency from code.
static getIdFromCode($dbs, $code)
Get id of currency from code.
Class to manage order lines.
Class to manage products or services.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
setSignedStatusCommon(User $user, int $status, int $notrigger=0, string $triggercode='')
Set signed status & call trigger with context message.
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
dol_delete_preview($object)
Delete all preview files linked to object instance.
dol_now($mode='gmt')
Return date for now.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
setEntity($currentobject)
Set entity id to use when to create an object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dolBuildUrl($url, $params=[], $addtoken=false)
Return path of url.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
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.
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.
get_default_npr(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that returns whether VAT must be recoverable collected VAT (e.g.: VAT NPR in France)
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_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalBool($key, $default=false)
Return a Dolibarr global constant boolean value.
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 a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
getMarginInfos($pv_ht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $pa_ht)
Return an array with margins information of a line.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
if(getDolGlobalString( 'TAKEPOS_SHOW_CUSTOMER')) print $langs trans('Date')." left Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date