39require_once DOL_DOCUMENT_ROOT.
'/core/class/commonorder.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/commande/class/orderline.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/margin/lib/margins.lib.php';
43require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/subtotals/class/commonsubtotal.class.php';
58 public $element =
'commande';
63 public $table_element =
'commande';
68 public $table_element_line =
'commandedet';
73 public $class_element_line =
'OrderLine';
78 public $fk_element =
'fk_commande';
83 public $picto =
'order';
89 public $restrictiononfksoc = 1;
109 public $ref_customer;
137 public $date_lim_reglement;
141 public $cond_reglement_code;
146 public $cond_reglement_doc;
151 public $cond_reglement_label;
158 public $deposit_percent;
168 public $mode_reglement;
173 public $mode_reglement_id;
178 public $mode_reglement_code;
184 public $availability_id;
190 public $availability_code;
196 public $availability;
201 public $demand_reason_id;
206 public $demand_reason_code;
218 public $date_commande;
223 public $delivery_date;
228 public $fk_remise_except;
234 public $remise_percent;
245 public $signed_status = 0;
250 public $warehouse_id;
255 public $extraparams = array();
257 public $linked_objects = array();
262 public $user_author_id;
272 public $lines = array();
278 public $module_source;
292 public $online_payment_url;
325 public $fields = array(
326 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
327 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 20,
'index' => 1),
328 'ref' => array(
'type' =>
'varchar(30)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'showoncombobox' => 1,
'position' => 25),
329 'ref_ext' => array(
'type' =>
'varchar(255)',
'label' =>
'RefExt',
'enabled' => 1,
'visible' => 0,
'position' => 26),
330 'ref_client' => array(
'type' =>
'varchar(255)',
'label' =>
'RefCustomer',
'enabled' => 1,
'visible' => -1,
'position' => 28),
331 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 20),
332 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 25),
333 'date_commande' => array(
'type' =>
'date',
'label' =>
'Date',
'enabled' => 1,
'visible' => 1,
'position' => 60,
'csslist' =>
'nowraponall'),
334 'date_valid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'position' => 62,
'csslist' =>
'nowraponall'),
335 'date_cloture' => array(
'type' =>
'datetime',
'label' =>
'DateClosing',
'enabled' => 1,
'visible' => -1,
'position' => 65,
'csslist' =>
'nowraponall'),
336 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => -1,
'position' => 85),
337 'fk_user_cloture' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserClosing',
'enabled' => 1,
'visible' => -1,
'position' => 90),
338 'source' => array(
'type' =>
'smallint(6)',
'label' =>
'Source',
'enabled' => 1,
'visible' => -1,
'position' => 95),
339 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'VAT',
'enabled' => 1,
'visible' => -1,
'position' => 125,
'isameasure' => 1),
340 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'LocalTax1',
'enabled' => 1,
'visible' => -1,
'position' => 130,
'isameasure' => 1),
341 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'LocalTax2',
'enabled' => 1,
'visible' => -1,
'position' => 135,
'isameasure' => 1),
342 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalHT',
'enabled' => 1,
'visible' => -1,
'position' => 140,
'isameasure' => 1),
343 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalTTC',
'enabled' => 1,
'visible' => -1,
'position' => 145,
'isameasure' => 1),
344 'signed_status' => array(
'type' =>
'smallint(6)',
'label' =>
'SignedStatus',
'enabled' => 1,
'visible' => -1,
'position' => 146,
'arrayofkeyval' => array(0 =>
'NoSignature', 1 =>
'SignedSender', 2 =>
'SignedReceiver', 9 =>
'SignedAll')),
345 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 150),
346 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 155),
347 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'PDFTemplate',
'enabled' => 1,
'visible' => 0,
'position' => 160),
348 'fk_account' => array(
'type' =>
'integer',
'label' =>
'BankAccount',
'enabled' =>
'isModEnabled("bank")',
'visible' => -1,
'position' => 170),
349 'fk_currency' => array(
'type' =>
'varchar(3)',
'label' =>
'MulticurrencyID',
'enabled' => 1,
'visible' => -1,
'position' => 175),
350 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentTerm',
'enabled' => 1,
'visible' => -1,
'position' => 180),
351 'deposit_percent' => array(
'type' =>
'varchar(63)',
'label' =>
'DepositPercent',
'enabled' => 1,
'visible' => -1,
'position' => 181),
352 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentMode',
'enabled' => 1,
'visible' => -1,
'position' => 185),
353 'date_livraison' => array(
'type' =>
'date',
'label' =>
'DateDeliveryPlanned',
'enabled' => 1,
'visible' => -1,
'position' => 190,
'csslist' =>
'nowraponall'),
354 'fk_shipping_method' => array(
'type' =>
'integer',
'label' =>
'ShippingMethod',
'enabled' => 1,
'visible' => -1,
'position' => 195),
355 'fk_warehouse' => array(
'type' =>
'integer:Entrepot:product/stock/class/entrepot.class.php',
'label' =>
'DefaultWarehouse',
'enabled' =>
'isModEnabled("stock")',
'visible' => -1,
'position' => 200,
'nodepth' => 1),
356 'fk_availability' => array(
'type' =>
'integer',
'label' =>
'Availability',
'enabled' => 1,
'visible' => -1,
'position' => 205),
357 'fk_input_reason' => array(
'type' =>
'integer',
'label' =>
'InputReason',
'enabled' => 1,
'visible' => -1,
'position' => 210),
359 'extraparams' => array(
'type' =>
'varchar(255)',
'label' =>
'Extraparams',
'enabled' => 1,
'visible' => -1,
'position' => 225),
360 'fk_incoterms' => array(
'type' =>
'integer',
'label' =>
'IncotermCode',
'enabled' =>
'$conf->incoterm->enabled',
'visible' => -1,
'position' => 230),
361 'location_incoterms' => array(
'type' =>
'varchar(255)',
'label' =>
'IncotermLabel',
'enabled' =>
'$conf->incoterm->enabled',
'visible' => -1,
'position' => 235),
362 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'Fk multicurrency',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 240),
363 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'MulticurrencyCurrency',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 245),
364 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyRate',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 250,
'isameasure' => 1),
365 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountHT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 255,
'isameasure' => 1),
366 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountVAT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 260,
'isameasure' => 1),
367 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountTTC',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 265,
'isameasure' => 1),
368 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'LastMainDoc',
'enabled' => 1,
'visible' => -1,
'position' => 270),
369 'module_source' => array(
'type' =>
'varchar(32)',
'label' =>
'POSModule',
'enabled' => 1,
'visible' => -1,
'position' => 275),
370 'pos_source' => array(
'type' =>
'varchar(32)',
'label' =>
'POSTerminal',
'enabled' => 1,
'visible' => -1,
'position' => 280),
371 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -1,
'position' => 300),
372 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 302),
373 'date_creation' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -2,
'position' => 304,
'csslist' =>
'nowraponall'),
374 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 306),
375 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 400),
376 'fk_statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Status',
'enabled' => 1,
'visible' => -1,
'position' => 500),
416 const STATUS_NO_SIGNATURE = 0;
421 const STATUS_SIGNED_SENDER = 1;
426 const STATUS_SIGNED_RECEIVER = 2;
431 const STATUS_SIGNED_ALL = 9;
443 $this->ismultientitymanaged = 1;
444 $this->isextrafieldmanaged = 1;
446 $this->fields[
'ref_ext'][
'visible'] =
getDolGlobalInt(
'MAIN_LIST_SHOW_REF_EXT');
456 public function getNextNumRef($soc)
458 global $langs,
$conf;
459 $langs->load(
"order");
468 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
469 foreach ($dirmodels as $reldir) {
473 $mybool = ((bool) @include_once $dir.$file) || $mybool;
481 $obj =
new $classname();
483 '@phan-var-force ModeleNumRefCommandes $obj';
485 $numref = $obj->getNextValue($soc, $this);
490 $this->error = $obj->error;
495 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_COMMANDE_ADDON_NotDefined");
509 public function valid($user, $idwarehouse = 0, $notrigger = 0)
511 global
$conf, $langs;
513 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
518 if ($this->
status == self::STATUS_VALIDATED) {
519 dol_syslog(get_class($this).
"::valid action abandoned: already validated", LOG_WARNING);
523 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
524 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'validate')))) {
525 $this->error =
'NotEnoughPermissions';
526 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
536 $soc->fetch($this->socid);
539 $result = $soc->setAsCustomer();
542 if (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref))) {
543 $num = $this->getNextNumRef($soc);
550 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
551 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
552 $sql .=
" fk_statut = ".self::STATUS_VALIDATED.
",";
553 $sql .=
" date_valid = '".$this->db->idate($now).
"',";
554 $sql .=
" fk_user_valid = ".($user->id > 0 ? (int) $user->id :
"null").
",";
555 $sql .=
" fk_user_modif = ".((int) $user->id);
556 $sql .=
" WHERE rowid = ".((int) $this->
id);
558 dol_syslog(get_class($this).
"::valid", LOG_DEBUG);
559 $resql = $this->db->query($sql);
562 $this->error = $this->db->lasterror();
568 if ($result >= 0 && isModEnabled(
'stock') &&
getDolGlobalInt(
'STOCK_CALCULATE_ON_VALIDATE_ORDER') == 1) {
569 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
570 $langs->load(
"agenda");
573 $cpt = count($this->lines);
574 for ($i = 0; $i < $cpt; $i++) {
575 if ($this->lines[$i]->fk_product > 0) {
577 $mouvP->origin = &$this;
578 $mouvP->setOrigin($this->element, $this->
id);
580 $result = $mouvP->livraison($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $this->lines[$i]->subprice, $langs->trans(
"OrderValidatedInDolibarr", $num));
583 $this->error = $mouvP->error;
593 if (!$error && !$notrigger) {
603 $this->oldref = $this->ref;
606 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
608 $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).
"'";
609 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
610 $resql = $this->db->query($sql);
613 $this->error = $this->db->lasterror();
615 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'commande/".$this->db->escape($this->newref).
"'";
616 $sql .=
" WHERE filepath = 'commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
617 $resql = $this->db->query($sql);
620 $this->error = $this->db->lasterror();
626 $dirsource =
$conf->commande->multidir_output[$this->entity].
'/'.$oldref;
627 $dirdest =
$conf->commande->multidir_output[$this->entity].
'/'.$newref;
628 if (!$error && file_exists($dirsource)) {
629 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
631 if (@rename($dirsource, $dirdest)) {
634 $listoffiles =
dol_dir_list(
$conf->commande->multidir_output[$this->entity].
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
635 foreach ($listoffiles as $fileentry) {
636 $dirsource = $fileentry[
'name'];
637 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
638 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
639 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
640 @rename($dirsource, $dirdest);
658 $this->db->rollback();
683 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
684 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'validate')))) {
685 $this->error =
'Permission denied';
693 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
694 $sql .=
" SET fk_statut = ".((int) self::STATUS_DRAFT).
",";
695 $sql .=
" fk_user_modif = ".((int) $user->id);
696 $sql .=
" WHERE rowid = ".((int) $this->
id);
698 if ($this->db->query($sql)) {
700 $this->oldcopy = clone $this;
704 if (isModEnabled(
'stock') &&
getDolGlobalInt(
'STOCK_CALCULATE_ON_VALIDATE_ORDER') == 1) {
707 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
708 $langs->load(
"agenda");
710 $num = count($this->lines);
711 for ($i = 0; $i < $num; $i++) {
712 if ($this->lines[$i]->fk_product > 0) {
714 $mouvP->origin = &$this;
715 $mouvP->setOrigin($this->element, $this->
id);
717 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, 0, $langs->trans(
"OrderBackToDraftInDolibarr", $this->ref));
720 $this->error = $mouvP->error;
729 $result = $this->
call_trigger(
'ORDER_UNVALIDATE', $user);
741 $this->db->rollback();
745 $this->error = $this->db->error();
746 $this->db->rollback();
765 if ($this->
status != self::STATUS_CANCELED && $this->
status != self::STATUS_CLOSED) {
766 dol_syslog(get_class($this).
"::set_reopen order has not status closed", LOG_WARNING);
772 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
773 $sql .=
' SET fk_statut='.self::STATUS_VALIDATED.
', facture=0,';
774 $sql .=
" fk_user_modif = ".((int) $user->id);
775 $sql .=
" WHERE rowid = ".((int) $this->
id);
777 dol_syslog(get_class($this).
"::set_reopen", LOG_DEBUG);
778 $resql = $this->db->query($sql);
788 $this->error = $this->db->lasterror();
800 foreach ($this->errors as $errmsg) {
801 dol_syslog(get_class($this).
"::set_reopen ".$errmsg, LOG_ERR);
802 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
804 $this->db->rollback();
817 public function cloture($user, $notrigger = 0, $checkpermission = 1)
821 $usercanclose = (!$checkpermission
822 || (!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'creer'))
823 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'commande',
'order_advance',
'close')));
826 if ($this->
status == self::STATUS_CLOSED) {
833 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
834 $sql .=
' SET fk_statut = '.self::STATUS_CLOSED.
',';
835 $sql .=
' fk_user_cloture = '.((int) $user->id).
',';
836 $sql .=
" date_cloture = '".$this->db->idate($now).
"',";
837 $sql .=
" fk_user_modif = ".((int) $user->id);
840 if ($this->db->query($sql)) {
857 $this->db->rollback();
861 $this->error = $this->db->lasterror();
863 $this->db->rollback();
883 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
884 return parent::setCategoriesCommon($categories, Categorie::TYPE_ORDER);
894 public function cancel($idwarehouse = -1)
896 global $user, $langs;
902 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
903 $sql .=
" SET fk_statut = ".self::STATUS_CANCELED.
",";
904 $sql .=
" fk_user_modif = ".((int) $user->id);
905 $sql .=
" WHERE rowid = ".((int) $this->
id);
906 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
908 dol_syslog(get_class($this).
"::cancel", LOG_DEBUG);
909 if ($this->db->query($sql)) {
911 if (isModEnabled(
'stock') &&
getDolGlobalInt(
'STOCK_CALCULATE_ON_VALIDATE_ORDER') == 1) {
912 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
913 $langs->load(
"agenda");
915 $num = count($this->lines);
916 for ($i = 0; $i < $num; $i++) {
917 if ($this->lines[$i]->fk_product > 0) {
919 $mouvP->setOrigin($this->element, $this->
id);
921 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, 0, $langs->trans(
"OrderCanceledInDolibarr", $this->ref));
924 $this->error = $mouvP->error;
946 foreach ($this->errors as $errmsg) {
947 dol_syslog(get_class($this).
"::cancel ".$errmsg, LOG_ERR);
948 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
950 $this->db->rollback();
954 $this->error = $this->db->error();
955 $this->db->rollback();
968 public function create($user, $notrigger = 0)
970 global
$conf, $langs, $mysoc;
976 $date = ($this->date_commande ? $this->date_commande : $this->date);
977 $delivery_date = $this->delivery_date;
980 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
985 if (empty($this->fk_multicurrency)) {
986 $this->multicurrency_code =
$conf->currency;
987 $this->fk_multicurrency = 0;
988 $this->multicurrency_tx = 1;
993 dol_syslog(get_class($this).
"::create user=".$user->id);
996 if (!empty($this->
ref)) {
999 $this->error =
'ErrorRefAlreadyExists';
1000 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
1001 $this->db->rollback();
1006 $soc =
new Societe($this->db);
1007 $result = $soc->fetch($this->socid);
1009 $this->error =
"Failed to fetch company";
1010 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
1014 $this->error = $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Source"));
1015 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
1023 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.$this->table_element.
" (";
1024 $sql .=
" ref, fk_soc, date_creation, fk_user_author, fk_projet, date_commande, source, note_private, note_public, ref_ext, ref_client";
1025 $sql .=
", model_pdf, fk_cond_reglement, deposit_percent, fk_mode_reglement, fk_account, fk_availability, fk_input_reason, date_livraison, fk_delivery_address";
1026 $sql .=
", fk_shipping_method";
1027 $sql .=
", fk_warehouse";
1028 $sql .=
", fk_incoterms, location_incoterms";
1029 $sql .=
", entity, module_source, pos_source";
1030 $sql .=
", fk_multicurrency";
1031 $sql .=
", multicurrency_code";
1032 $sql .=
", multicurrency_tx";
1034 $sql .=
" VALUES ('(PROV)', ".((int) $this->socid).
", '".$this->db->idate($now).
"', ".((int) $user->id);
1035 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1036 $sql .=
", '".$this->db->idate($date).
"'";
1037 $sql .=
", ".($this->source >= 0 && $this->source !=
'' ? $this->db->escape((
string) $this->source) :
'null');
1038 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1039 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1040 $sql .=
", ".($this->ref_ext ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
1041 $sql .=
", ".($this->ref_client ?
"'".$this->db->escape($this->ref_client).
"'" :
"null");
1042 $sql .=
", '".$this->db->escape($this->model_pdf).
"'";
1043 $sql .=
", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
"null");
1044 $sql .=
", ".(!empty($this->deposit_percent) ?
"'".$this->db->escape((
string) $this->deposit_percent).
"'" :
"null");
1045 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"null");
1046 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
1047 $sql .=
", ".($this->availability_id > 0 ? ((int) $this->availability_id) :
"null");
1048 $sql .=
", ".($this->demand_reason_id > 0 ? ((int) $this->demand_reason_id) :
"null");
1049 $sql .=
", ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1050 $sql .=
", ".($this->fk_delivery_address > 0 ? ((int) $this->fk_delivery_address) :
'NULL');
1051 $sql .=
", ".(!empty($this->shipping_method_id) && $this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
'NULL');
1052 $sql .=
", ".(!empty($this->warehouse_id) && $this->warehouse_id > 0 ? ((int) $this->warehouse_id) :
'NULL');
1053 $sql .=
", ".(int) $this->fk_incoterms;
1054 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
1055 $sql .=
", ".(int) $this->entity;
1056 $sql .=
", ".($this->module_source ?
"'".$this->db->escape($this->module_source).
"'" :
"null");
1057 $sql .=
", ".((!is_null($this->pos_source) && $this->pos_source !=
'') ?
"'".$this->db->escape($this->pos_source).
"'" :
"null");
1058 $sql .=
", ".(int) $this->fk_multicurrency;
1059 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1060 $sql .=
", ".(float) $this->multicurrency_tx;
1063 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1064 $resql = $this->db->query($sql);
1066 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'commande');
1069 $fk_parent_line = 0;
1070 $num = count($this->lines);
1075 for ($i = 0; $i < $num; $i++) {
1076 $line = $this->lines[$i];
1080 if (!is_object($line)) {
1082 foreach ($line as $key => $val) {
1083 $lineobj->$key = $val;
1086 $this->lines[$i] = $line;
1090 if (($line->product_type != 9 && empty($line->fk_parent_line)) || $line->product_type == 9) {
1091 $fk_parent_line = 0;
1095 $vatrate = $line->tva_tx;
1096 if ($line->vat_src_code && !preg_match(
'/\(.*\)/', (
string) $vatrate)) {
1097 $vatrate .=
' ('.$line->vat_src_code.
')';
1101 $originid = $line->origin_id;
1102 $origintype = empty($line->origin_type) ? $line->origin : $line->origin_type;
1104 $originid = $line->id;
1105 $origintype = $this->element;
1109 if (empty($line->ref_ext)) {
1110 $line->ref_ext =
'';
1118 $line->localtax1_tx,
1119 $line->localtax2_tx,
1121 $line->remise_percent,
1123 $line->fk_remise_except,
1128 $line->product_type,
1130 $line->special_code,
1132 $line->fk_fournprice,
1135 $line->array_options,
1137 (
string) $origintype,
1145 if ($result != self::STOCK_NOT_ENOUGH_FOR_ORDER) {
1146 $this->error = $this->db->lasterror();
1147 $this->errors[] = $this->error;
1150 $this->db->rollback();
1154 if ($result > 0 && $line->product_type == 9) {
1155 $fk_parent_line = $result;
1162 $initialref =
'(PROV'.$this->id.
')';
1163 if (!empty($this->
ref)) {
1164 $initialref = $this->ref;
1167 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
" SET ref='".$this->db->escape($initialref).
"' WHERE rowid=".((int) $this->
id);
1168 if ($this->db->query($sql)) {
1169 $this->
ref = $initialref;
1171 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1172 $this->linked_objects = $this->linkedObjectsIds;
1176 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1177 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1178 if (is_array($tmp_origin_id)) {
1179 foreach ($tmp_origin_id as $origin_id) {
1182 $this->error = $this->db->lasterror();
1187 $origin_id = $tmp_origin_id;
1190 $this->error = $this->db->lasterror();
1197 if (!$error && $this->
id &&
getDolGlobalString(
'MAIN_PROPAGATE_CONTACTS_FROM_ORIGIN') && !empty($this->origin) && !empty($this->origin_id)) {
1198 $originforcontact = empty($this->origin_type) ? $this->origin : $this->origin_type;
1199 $originidforcontact = $this->origin_id;
1200 if ($originforcontact ==
'shipping') {
1201 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
1203 $exp->fetch($this->origin_id);
1204 $exp->fetchObjectLinked();
1205 if (count($exp->linkedObjectsIds[
'commande']) > 0) {
1206 foreach ($exp->linkedObjectsIds[
'commande'] as $key => $value) {
1207 $originforcontact =
'commande';
1208 if (is_object($value)) {
1209 $originidforcontact = $value->id;
1211 $originidforcontact = $value;
1218 $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";
1219 $sqlcontact .=
" WHERE element_id = ".((int) $originidforcontact).
" AND ec.fk_c_type_contact = ctc.rowid AND ctc.element = '".$this->db->escape($originforcontact).
"'";
1221 $resqlcontact = $this->db->query($sqlcontact);
1222 if ($resqlcontact) {
1223 while ($objcontact = $this->db->fetch_object($resqlcontact)) {
1225 $this->
add_contact($objcontact->fk_socpeople, $objcontact->code, $objcontact->source);
1239 if (!$error && !$notrigger) {
1249 $this->db->commit();
1252 $this->db->rollback();
1256 $this->error = $this->db->lasterror();
1257 $this->db->rollback();
1264 $this->error = $this->db->lasterror();
1265 $this->db->rollback();
1280 global $user, $hookmanager;
1287 foreach ($this->lines as $line) {
1288 $line->fetch_optionals();
1292 $objFrom = clone $this;
1295 if (!empty($socid) && $socid != $this->socid) {
1296 $objsoc =
new Societe($this->db);
1298 if ($objsoc->fetch($socid) > 0) {
1299 $this->socid = $objsoc->id;
1300 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1301 $this->deposit_percent = (!empty($objsoc->deposit_percent) ? $objsoc->deposit_percent : 0);
1302 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1303 $this->fk_project = 0;
1304 $this->fk_delivery_address = 0;
1316 $this->user_author_id = $user->id;
1317 $this->user_validation_id = 0;
1319 $this->date_commande =
dol_now();
1320 $this->date_creation =
'';
1321 $this->date_validation =
'';
1323 $this->ref_client =
'';
1324 $this->ref_customer =
'';
1328 $num = count($this->lines);
1329 for ($i = 0; $i < $num; $i++) {
1330 $this->lines[$i]->ref_ext =
'';
1334 $this->context[
'createfromclone'] =
'createfromclone';
1335 $result = $this->
create($user);
1349 if ($this->socid == $objFrom->socid) {
1358 if (is_object($hookmanager)) {
1359 $parameters = array(
'objFrom' => $objFrom);
1361 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1369 unset($this->context[
'createfromclone']);
1373 $this->db->commit();
1376 $this->db->rollback();
1391 global
$conf, $hookmanager;
1393 require_once DOL_DOCUMENT_ROOT .
'/multicurrency/class/multicurrency.class.php';
1394 require_once DOL_DOCUMENT_ROOT .
'/core/class/extrafields.class.php';
1398 $this->date_commande =
dol_now();
1403 for ($i = 0; $i < $num; $i++) {
1406 $line->libelle =
$object->lines[$i]->libelle;
1407 $line->label =
$object->lines[$i]->label;
1408 $line->desc =
$object->lines[$i]->desc;
1409 $line->price =
$object->lines[$i]->price;
1410 $line->subprice =
$object->lines[$i]->subprice;
1411 $line->vat_src_code =
$object->lines[$i]->vat_src_code;
1412 $line->tva_tx =
$object->lines[$i]->tva_tx;
1413 $line->localtax1_tx =
$object->lines[$i]->localtax1_tx;
1414 $line->localtax2_tx =
$object->lines[$i]->localtax2_tx;
1415 $line->qty =
$object->lines[$i]->qty;
1416 $line->fk_remise_except =
$object->lines[$i]->fk_remise_except;
1417 $line->remise_percent =
$object->lines[$i]->remise_percent;
1418 $line->fk_product =
$object->lines[$i]->fk_product;
1419 $line->info_bits =
$object->lines[$i]->info_bits;
1420 $line->product_type =
$object->lines[$i]->product_type;
1421 $line->rang =
$object->lines[$i]->rang;
1422 $line->special_code =
$object->lines[$i]->special_code;
1423 $line->fk_parent_line =
$object->lines[$i]->fk_parent_line;
1424 $line->fk_unit =
$object->lines[$i]->fk_unit;
1426 $line->date_start =
$object->lines[$i]->date_start;
1427 $line->date_end =
$object->lines[$i]->date_end;
1429 $line->fk_fournprice =
$object->lines[$i]->fk_fournprice;
1431 $line->pa_ht = $marginInfos[0];
1432 $line->marge_tx = $marginInfos[1];
1433 $line->marque_tx = $marginInfos[2];
1435 $line->origin =
$object->element;
1436 $line->origin_id =
$object->lines[$i]->id;
1439 $object->lines[$i]->fetch_optionals();
1440 foreach (
$object->lines[$i]->array_options as $options_key => $value) {
1441 $line->array_options[$options_key] = $value;
1444 $this->lines[$i] = $line;
1447 $this->entity =
$object->entity;
1448 $this->socid =
$object->socid;
1449 $this->fk_project =
$object->fk_project;
1450 $this->cond_reglement_id =
$object->cond_reglement_id;
1451 $this->deposit_percent =
$object->deposit_percent;
1452 $this->mode_reglement_id =
$object->mode_reglement_id;
1453 $this->fk_account =
$object->fk_account;
1454 $this->availability_id =
$object->availability_id;
1455 $this->demand_reason_id =
$object->demand_reason_id;
1456 $this->delivery_date =
$object->delivery_date;
1457 $this->shipping_method_id =
$object->shipping_method_id;
1458 $this->warehouse_id =
$object->warehouse_id;
1459 $this->fk_delivery_address =
$object->fk_delivery_address;
1460 $this->contact_id =
$object->contact_id;
1461 $this->ref_client =
$object->ref_client;
1462 $this->ref_customer =
$object->ref_client;
1465 $this->note_private =
$object->note_private;
1466 $this->note_public =
$object->note_public;
1469 $this->origin =
$object->element;
1470 $this->origin_id =
$object->id;
1473 if (isModEnabled(
'multicurrency')) {
1474 if (!empty(
$object->multicurrency_code)) {
1475 $this->multicurrency_code =
$object->multicurrency_code;
1478 $this->multicurrency_tx =
$object->multicurrency_tx;
1481 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1483 $this->fk_multicurrency = $tmparray[0];
1484 $this->multicurrency_tx = $tmparray[1];
1488 if (empty($this->fk_multicurrency)) {
1489 $this->multicurrency_code =
$conf->currency;
1490 $this->fk_multicurrency = 0;
1491 $this->multicurrency_tx = 1;
1499 $element_extrafields = $e->fetch_name_optionals_label($this->table_element);
1501 foreach (
$object->array_options as $options_key => $value) {
1502 if (array_key_exists(str_replace(
'options_',
'', $options_key), $element_extrafields)) {
1503 $this->array_options[$options_key] = $value;
1507 $this->linked_objects[$this->origin] = $this->origin_id;
1508 if (isset(
$object->other_linked_objects) && is_array(
$object->other_linked_objects) && !empty(
$object->other_linked_objects)) {
1509 $this->linked_objects = array_merge($this->linked_objects,
$object->other_linked_objects);
1512 $ret = $this->
create($user);
1516 $hookmanager->initHooks(array(
'orderdao'));
1518 $parameters = array(
'objFrom' =>
$object);
1520 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1530 $this->
valid($user);
1582 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)
1584 global $mysoc, $langs, $user;
1586 $logtext =
"::addline commandeid=$this->id, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, fk_product=$fk_product, remise_percent=$remise_percent";
1587 $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";
1588 $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";
1589 dol_syslog(get_class($this).$logtext, LOG_DEBUG);
1591 if ($this->
status == self::STATUS_DRAFT) {
1592 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1596 if (empty($remise_percent)) {
1597 $remise_percent = 0;
1602 if (empty($info_bits)) {
1608 if (empty($txtva)) {
1611 if (empty($txlocaltax1)) {
1614 if (empty($txlocaltax2)) {
1617 if (empty($fk_parent_line) || $fk_parent_line < 0) {
1618 $fk_parent_line = 0;
1620 if (empty($this->fk_multicurrency)) {
1621 $this->fk_multicurrency = 0;
1623 if (empty($ref_ext)) {
1627 $remise_percent = (float)
price2num($remise_percent);
1630 $pu_ht_devise =
price2num($pu_ht_devise);
1633 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
1638 if ($price_base_type ==
'HT') {
1643 $label = trim($label);
1644 $desc = trim($desc);
1651 if ($date_start && $date_end && $date_start > $date_end) {
1652 $langs->load(
"errors");
1653 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1659 $product_type = $type;
1660 if (!empty($fk_product) && $fk_product > 0) {
1661 $product =
new Product($this->db);
1662 $result = $product->fetch($fk_product);
1663 $product_type = $product->type;
1667 $productChildrenNb = 0;
1669 $productChildrenNb = $product->hasFatherOrChild(1);
1671 if ($productChildrenNb > 0) {
1673 $product_stock =
null;
1674 $product->loadStockForVirtualProduct(
'warehouseopen', $qty);
1675 foreach ($product->stock_warehouse as $componentStockWarehouse) {
1676 if ($product_stock ===
null) {
1677 $product_stock = $componentStockWarehouse->real;
1679 $product_stock = min($product_stock, $componentStockWarehouse->real);
1682 if ($product_stock ===
null) {
1686 $product_stock = $product->stock_reel;
1689 if ($product_stock < $qty) {
1690 $langs->load(
"errors");
1691 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnOrder', $product->ref);
1692 $this->errors[] = $this->error;
1693 dol_syslog(get_class($this).
"::addline error=Product ".$product->ref.
": ".$this->error, LOG_ERR);
1694 $this->db->rollback();
1707 $tmpproduct =
new Product($this->db);
1708 $result = $tmpproduct->fetch($fk_product);
1709 $qtysign = ((float) $qty < 0 ? -1 : 1);
1710 if (abs((
float) $qty) < (float) $tmpproduct->packaging) {
1711 $qty = $qtysign * (float) $tmpproduct->packaging;
1712 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'mesgs');
1714 if (!empty($tmpproduct->packaging) && (
float)
price2num(abs((
float) $qty) - round(abs((
float) $qty) / (
float) $tmpproduct->packaging) * (
float) $tmpproduct->packaging,
'MS') != 0) {
1715 $coeff = intval(abs($qty) / $tmpproduct->packaging) + 1;
1716 $qty =
price2num($qtysign * (
float) $tmpproduct->packaging * $coeff,
'MS');
1717 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'mesgs');
1725 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1726 $vat_src_code = $reg[1];
1727 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
1730 $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);
1740 $total_ht = $tabprice[0];
1741 $total_tva = $tabprice[1];
1742 $total_ttc = $tabprice[2];
1743 $total_localtax1 = $tabprice[9];
1744 $total_localtax2 = $tabprice[10];
1745 $pu_ht = $tabprice[3];
1748 $multicurrency_total_ht = $tabprice[16];
1749 $multicurrency_total_tva = $tabprice[17];
1750 $multicurrency_total_ttc = $tabprice[18];
1751 $pu_ht_devise = $tabprice[19];
1756 if ($ranktouse == -1) {
1757 $rangmax = $this->
line_max($fk_parent_line);
1758 $ranktouse = $rangmax + 1;
1765 if ($remise_percent > 0) {
1766 $remise = round(((
float) $pu * $remise_percent / 100), 2);
1767 $price = (float) $pu - $remise;
1773 $this->line->context = $this->context;
1775 $this->line->fk_commande = $this->id;
1776 $this->line->label = $label;
1777 $this->line->desc = $desc;
1778 $this->line->qty = (float) $qty;
1779 $this->line->ref_ext = $ref_ext;
1781 $this->line->vat_src_code = $vat_src_code;
1782 $this->line->tva_tx = $txtva;
1783 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
1784 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
1785 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
1786 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
1787 $this->line->fk_product = $fk_product;
1788 $this->line->product_type = $product_type;
1789 $this->line->fk_remise_except = $fk_remise_except;
1790 $this->line->remise_percent = $remise_percent;
1791 $this->line->subprice = (float) $pu_ht;
1792 $this->line->rang = $ranktouse;
1793 $this->line->info_bits = $info_bits;
1794 $this->line->total_ht = (float) $total_ht;
1795 $this->line->total_tva = (float) $total_tva;
1796 $this->line->total_localtax1 = (float) $total_localtax1;
1797 $this->line->total_localtax2 = (float) $total_localtax2;
1798 $this->line->total_ttc = (float) $total_ttc;
1799 $this->line->special_code = $special_code;
1800 if (empty($qty) && empty($special_code)) {
1801 $this->line->special_code = 3;
1803 $this->line->origin = $origin;
1804 $this->line->origin_id = $origin_id;
1805 $this->line->fk_parent_line = $fk_parent_line;
1806 $this->line->fk_unit = $fk_unit;
1808 $this->line->date_start = $date_start;
1809 $this->line->date_end = $date_end;
1811 $this->line->fk_fournprice = $fk_fournprice;
1812 $this->line->pa_ht = $pa_ht;
1815 $this->line->fk_multicurrency = $this->fk_multicurrency;
1816 $this->line->multicurrency_code = $this->multicurrency_code;
1817 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
1818 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
1819 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
1820 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
1823 $this->line->price = $price;
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();
1869 $this->error = $this->line->error;
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 =
'')
1898 global
$conf, $mysoc;
1904 if ($idproduct > 0) {
1905 $prod =
new Product($this->db);
1906 $prod->fetch($idproduct);
1910 if (empty($tva_tx)) {
1915 $localtax1_tx =
get_localtax($tva_tx, 1, $this->thirdparty, $mysoc, $tva_npr);
1916 $localtax2_tx =
get_localtax($tva_tx, 2, $this->thirdparty, $mysoc, $tva_npr);
1920 $price = $prod->multiprices[$this->thirdparty->price_level];
1922 $price = $prod->price;
1927 $line->context = $this->context;
1929 $line->fk_product = $idproduct;
1930 $line->desc = $prod->description;
1932 $line->subprice = $price;
1933 $line->remise_percent = $remise_percent;
1934 $line->vat_src_code = $vat_src_code;
1935 $line->tva_tx = $tva_tx;
1936 $line->localtax1_tx = $localtax1_tx;
1937 $line->localtax2_tx = $localtax2_tx;
1939 $line->product_ref = $prod->ref;
1940 $line->product_label = $prod->label;
1941 $line->product_desc = $prod->description;
1942 $line->fk_unit = $prod->fk_unit;
1946 $line->date_start = $date_start;
1949 $line->date_end = $date_end;
1952 $this->lines[] = $line;
1984 public function fetch($id, $ref =
'', $ref_ext =
'', $notused =
'')
1987 if (empty($id) && empty($ref) && empty($ref_ext)) {
1991 $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';
1992 $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';
1993 $sql .=
', c.fk_account';
1994 $sql .=
', c.date_commande, c.date_valid, c.tms';
1995 $sql .=
', c.date_livraison as delivery_date';
1996 $sql .=
', c.fk_shipping_method';
1997 $sql .=
', c.fk_warehouse';
1998 $sql .=
', c.fk_projet as fk_project, c.source, c.facture as billed';
1999 $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';
2000 $sql .=
', c.fk_incoterms, c.location_incoterms';
2001 $sql .=
", c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc";
2002 $sql .=
", c.module_source, c.pos_source";
2003 $sql .=
", i.libelle as label_incoterms";
2004 $sql .=
', p.code as mode_reglement_code, p.libelle as mode_reglement_libelle';
2005 $sql .=
', cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc';
2006 $sql .=
', ca.code as availability_code, ca.label as availability_label';
2007 $sql .=
', dr.code as demand_reason_code';
2008 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as c';
2009 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as cr ON c.fk_cond_reglement = cr.rowid';
2010 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as p ON c.fk_mode_reglement = p.id';
2011 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_availability as ca ON c.fk_availability = ca.rowid';
2012 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_input_reason as dr ON c.fk_input_reason = dr.rowid';
2013 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON c.fk_incoterms = i.rowid';
2016 $sql .=
" WHERE c.rowid = ".((int) $id);
2018 $sql .=
" WHERE c.entity IN (".getEntity(
'commande').
")";
2022 $sql .=
" AND c.ref = '".$this->db->escape($ref).
"'";
2025 $sql .=
" AND c.ref_ext = '".$this->db->escape($ref_ext).
"'";
2028 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
2029 $result = $this->db->query($sql);
2031 $obj = $this->db->fetch_object($result);
2033 $this->
id = $obj->rowid;
2034 $this->entity = $obj->entity;
2036 $this->
ref = $obj->ref;
2037 $this->ref_client = $obj->ref_client;
2038 $this->ref_customer = $obj->ref_client;
2039 $this->ref_ext = $obj->ref_ext;
2041 $this->socid = $obj->fk_soc;
2042 $this->thirdparty =
null;
2044 $this->fk_project = $obj->fk_project;
2045 $this->project =
null;
2047 $this->statut = $obj->status;
2048 $this->
status = $obj->status;
2050 $this->user_author_id = $obj->fk_user_author;
2051 $this->user_creation_id = $obj->fk_user_author;
2052 $this->user_validation_id = $obj->fk_user_valid;
2053 $this->user_modification_id = $obj->fk_user_modif;
2054 $this->total_ht = $obj->total_ht;
2055 $this->total_tva = $obj->total_tva;
2056 $this->total_localtax1 = $obj->total_localtax1;
2057 $this->total_localtax2 = $obj->total_localtax2;
2058 $this->total_ttc = $obj->total_ttc;
2059 $this->date = $this->db->jdate($obj->date_commande);
2060 $this->date_commande = $this->db->jdate($obj->date_commande);
2061 $this->date_creation = $this->db->jdate($obj->date_creation);
2062 $this->date_validation = $this->db->jdate($obj->date_valid);
2063 $this->date_modification = $this->db->jdate($obj->tms);
2064 $this->source = $obj->source;
2065 $this->billed = $obj->billed;
2066 $this->note = $obj->note_private;
2067 $this->note_private = $obj->note_private;
2068 $this->note_public = $obj->note_public;
2069 $this->model_pdf = $obj->model_pdf;
2070 $this->last_main_doc = $obj->last_main_doc;
2071 $this->mode_reglement_id = $obj->fk_mode_reglement;
2072 $this->mode_reglement_code = $obj->mode_reglement_code;
2073 $this->mode_reglement = $obj->mode_reglement_libelle;
2074 $this->cond_reglement_id = $obj->fk_cond_reglement;
2075 $this->cond_reglement_code = $obj->cond_reglement_code;
2076 $this->cond_reglement = $obj->cond_reglement_libelle;
2077 $this->cond_reglement_label = $obj->cond_reglement_libelle;
2078 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
2079 $this->deposit_percent = $obj->deposit_percent;
2080 $this->fk_account = $obj->fk_account;
2081 $this->availability_id = $obj->fk_availability;
2082 $this->availability_code = $obj->availability_code;
2084 $this->demand_reason_id = $obj->fk_input_reason;
2085 $this->demand_reason_code = $obj->demand_reason_code;
2086 $this->delivery_date = $this->db->jdate($obj->delivery_date);
2087 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method :
null;
2088 $this->warehouse_id = ($obj->fk_warehouse > 0) ? $obj->fk_warehouse :
null;
2089 $this->fk_delivery_address = $obj->fk_delivery_address;
2090 $this->module_source = $obj->module_source;
2091 $this->pos_source = $obj->pos_source;
2094 $this->fk_incoterms = $obj->fk_incoterms;
2095 $this->location_incoterms = $obj->location_incoterms;
2096 $this->label_incoterms = $obj->label_incoterms;
2099 $this->fk_multicurrency = $obj->fk_multicurrency;
2100 $this->multicurrency_code = $obj->multicurrency_code;
2101 $this->multicurrency_tx = $obj->multicurrency_tx;
2102 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
2103 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
2104 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2106 $this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2108 $this->lines = array();
2114 $this->db->free($result);
2123 $this->error =
'Order with id '.$id.
' not found sql='.$sql;
2127 $this->error = $this->db->error();
2145 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2146 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
2151 $result = $remise->fetch($idremise);
2154 if ($remise->fk_facture) {
2155 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
2156 $this->db->rollback();
2162 $line->fk_commande = $this->id;
2163 $line->fk_remise_except = $remise->id;
2164 $line->desc = $remise->description;
2165 $line->vat_src_code = $remise->vat_src_code;
2166 $line->tva_tx = $remise->tva_tx;
2167 $line->subprice = -(float) $remise->amount_ht;
2168 $line->price = -(float) $remise->amount_ht;
2169 $line->fk_product = 0;
2171 $line->remise_percent = 0;
2173 $line->info_bits = 2;
2175 $line->total_ht = -(float) $remise->amount_ht;
2176 $line->total_tva = -(float) $remise->amount_tva;
2177 $line->total_ttc = -(float) $remise->amount_ttc;
2179 $result = $line->insert();
2183 $this->db->commit();
2186 $this->db->rollback();
2190 $this->error = $line->error;
2191 $this->errors = $line->errors;
2192 $this->db->rollback();
2196 $this->db->rollback();
2210 public function fetch_lines($only_product = 0, $loadalsotranslation = 0)
2213 $this->lines = array();
2215 $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,';
2216 $sql .=
' l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code,';
2217 $sql .=
' l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end,';
2218 $sql .=
' l.fk_unit, l.extraparams,';
2219 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc,';
2220 $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,';
2221 $sql .=
' p.weight, p.weight_units, p.volume, p.volume_units, p.packaging';
2222 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element_line.
' as l';
2223 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON (p.rowid = l.fk_product)';
2224 $sql .=
' WHERE l.fk_commande = '.((int) $this->
id);
2225 if ($only_product) {
2226 $sql .=
' AND p.fk_product_type = 0';
2228 $sql .=
' ORDER BY l.rang, l.rowid';
2230 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
2231 $result = $this->db->query($sql);
2233 $num = $this->db->num_rows($result);
2237 $objp = $this->db->fetch_object($result);
2241 $line->rowid = $objp->rowid;
2242 $line->id = $objp->rowid;
2243 $line->fk_commande = $objp->fk_commande;
2244 $line->commande_id = $objp->fk_commande;
2245 $line->label = $objp->custom_label;
2246 $line->desc = $objp->description;
2247 $line->description = $objp->description;
2248 $line->product_type = $objp->product_type;
2249 $line->qty = $objp->qty;
2250 $line->ref_ext = $objp->ref_ext;
2252 $line->vat_src_code = $objp->vat_src_code;
2253 $line->tva_tx = $objp->tva_tx;
2254 $line->localtax1_tx = $objp->localtax1_tx;
2255 $line->localtax2_tx = $objp->localtax2_tx;
2256 $line->localtax1_type = $objp->localtax1_type;
2257 $line->localtax2_type = $objp->localtax2_type;
2258 $line->total_ht = $objp->total_ht;
2259 $line->total_ttc = $objp->total_ttc;
2260 $line->total_tva = $objp->total_tva;
2261 $line->total_localtax1 = $objp->total_localtax1;
2262 $line->total_localtax2 = $objp->total_localtax2;
2263 $line->subprice = $objp->subprice;
2264 $line->fk_remise_except = $objp->fk_remise_except;
2265 $line->remise_percent = $objp->remise_percent;
2266 $line->price = $objp->price;
2267 $line->fk_product = $objp->fk_product;
2268 $line->fk_fournprice = $objp->fk_fournprice;
2269 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
2270 $line->pa_ht = $marginInfos[0];
2271 $line->marge_tx = $marginInfos[1];
2272 $line->marque_tx = $marginInfos[2];
2273 $line->rang = $objp->rang;
2274 $line->info_bits = $objp->info_bits;
2275 $line->special_code = $objp->special_code;
2276 $line->fk_parent_line = $objp->fk_parent_line;
2278 $line->ref = $objp->product_ref;
2279 $line->libelle = $objp->product_label;
2281 $line->product_ref = $objp->product_ref;
2282 $line->product_label = $objp->product_label;
2283 $line->product_tosell = $objp->product_tosell;
2284 $line->product_tobuy = $objp->product_tobuy;
2285 $line->product_desc = $objp->product_desc;
2286 $line->product_tobatch = $objp->product_tobatch;
2287 $line->product_barcode = $objp->product_barcode;
2289 $line->fk_product_type = $objp->fk_product_type;
2290 $line->fk_unit = $objp->fk_unit;
2292 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
2294 $line->weight = $objp->weight;
2295 $line->weight_units = $objp->weight_units;
2296 $line->volume = $objp->volume;
2297 $line->volume_units = $objp->volume_units;
2298 $line->packaging = $objp->packaging;
2300 $line->date_start = $this->db->jdate($objp->date_start);
2301 $line->date_end = $this->db->jdate($objp->date_end);
2304 $line->fk_multicurrency = $objp->fk_multicurrency;
2305 $line->multicurrency_code = $objp->multicurrency_code;
2306 $line->multicurrency_subprice = $objp->multicurrency_subprice;
2307 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
2308 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
2309 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
2311 $line->fetch_optionals();
2314 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && !empty($objp->fk_product) && !empty($loadalsotranslation)) {
2315 $tmpproduct =
new Product($this->db);
2316 $tmpproduct->fetch($objp->fk_product);
2317 $tmpproduct->getMultiLangs();
2319 $line->multilangs = $tmpproduct->multilangs;
2322 $this->lines[$i] = $line;
2327 $this->db->free($result);
2331 $this->error = $this->db->error();
2345 foreach ($this->lines as $line) {
2346 if ($line->product_type == 0) {
2361 foreach ($this->lines as $line) {
2362 if ($line->product_type == 1) {
2378 $sql =
'SELECT COUNT(DISTINCT ed.fk_expedition) as nb';
2379 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expeditiondet as ed,';
2380 $sql .=
' '.MAIN_DB_PREFIX.$this->table_element_line.
' as cd';
2382 $sql .=
' ed.fk_elementdet = cd.rowid';
2383 $sql .=
' AND cd.fk_commande = '.((int) $this->
id);
2386 dol_syslog(get_class($this).
"::getNbOfShipments", LOG_DEBUG);
2387 $resql = $this->db->query($sql);
2389 $obj = $this->db->fetch_object($resql);
2394 $this->db->free($resql);
2397 $this->error = $this->db->lasterror();
2412 $this->expeditions = array();
2414 $sql =
'SELECT cd.rowid, cd.fk_product,';
2415 $sql .=
' sum(ed.qty) as qty';
2416 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expeditiondet as ed,';
2417 if ($filtre_statut >= 0) {
2418 $sql .=
' '.MAIN_DB_PREFIX.
'expedition as e,';
2420 $sql .=
' '.MAIN_DB_PREFIX.$this->table_element_line.
' as cd';
2422 if ($filtre_statut >= 0) {
2423 $sql .=
' ed.fk_expedition = e.rowid AND';
2425 $sql .=
' ed.fk_elementdet = cd.rowid';
2426 $sql .=
' AND cd.fk_commande = '.((int) $this->
id);
2427 if ($fk_product > 0) {
2428 $sql .=
' AND cd.fk_product = '.((int) $fk_product);
2430 if ($filtre_statut >= 0) {
2431 $sql .=
' AND e.fk_statut >= '.((int) $filtre_statut);
2433 $sql .=
' GROUP BY cd.rowid, cd.fk_product';
2436 dol_syslog(get_class($this).
"::loadExpeditions", LOG_DEBUG);
2437 $resql = $this->db->query($sql);
2439 $num = $this->db->num_rows($resql);
2442 $obj = $this->db->fetch_object($resql);
2443 $this->expeditions[$obj->rowid] = $obj->qty;
2446 $this->db->free($resql);
2449 $this->error = $this->db->lasterror();
2461 $sql =
'SELECT count(*)';
2462 $sql .=
' FROM '.MAIN_DB_PREFIX.
'expedition as e';
2463 $sql .=
', '.MAIN_DB_PREFIX.
'element_element as el';
2464 $sql .=
' WHERE el.fk_source = '.((int) $this->
id);
2465 $sql .=
" AND el.sourcetype = 'commande'";
2466 $sql .=
" AND el.fk_target = e.rowid";
2467 $sql .=
" AND el.targettype = 'shipping'";
2469 $resql = $this->db->query($sql);
2471 $row = $this->db->fetch_row($resql);
2490 if ($this->
status == self::STATUS_DRAFT) {
2496 $line->context = $this->context;
2499 $line->fetch($lineid);
2504 if ($id > 0 && (
int) $line->fk_commande !== (
int) $id) {
2505 $this->db->rollback();
2506 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
2511 $staticline = clone $line;
2512 $line->oldline = $staticline;
2514 if ($line->delete($user) > 0) {
2518 $this->db->commit();
2521 $this->db->rollback();
2522 $this->error = $this->db->lasterror();
2526 $this->db->rollback();
2527 $this->error = $line->error;
2531 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
2550 dol_syslog(get_class($this).
"::set_remise is deprecated, use setDiscount instead", LOG_NOTICE);
2552 return $this->
setDiscount($user, $remise, $notrigger);
2565 $remise = trim((
string) $remise) ? trim((
string) $remise) : 0;
2567 if ($user->hasRight(
'commande',
'creer')) {
2574 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2575 $sql .=
' SET remise_percent = '.((float) $remise);
2576 $sql .=
' WHERE rowid = '.((int) $this->
id).
' AND fk_statut = '.((int) self::STATUS_DRAFT);
2579 $resql = $this->db->query($sql);
2581 $this->errors[] = $this->db->error();
2586 $this->oldcopy = clone $this;
2587 $this->remise_percent = $remise;
2591 if (!$notrigger && empty($error)) {
2601 $this->db->commit();
2604 foreach ($this->errors as $errmsg) {
2605 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2606 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2608 $this->db->rollback();
2629 if ($user->hasRight(
'commande',
'creer')) {
2634 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2635 $sql .=
" SET date_commande = ".($date ?
"'".$this->db->idate($date).
"'" :
'null');
2636 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut = ".((int) self::STATUS_DRAFT);
2639 $resql = $this->db->query($sql);
2641 $this->errors[] = $this->db->error();
2646 $this->oldcopy = clone $this;
2647 $this->date = $date;
2650 if (!$notrigger && empty($error)) {
2660 $this->db->commit();
2663 foreach ($this->errors as $errmsg) {
2664 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2665 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2667 $this->db->rollback();
2701 if ($user->hasRight(
'commande',
'creer')) {
2706 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2707 $sql .=
" SET date_livraison = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2708 $sql .=
" WHERE rowid = ".((int) $this->
id);
2711 $resql = $this->db->query($sql);
2713 $this->errors[] = $this->db->error();
2718 $this->oldcopy = clone $this;
2719 $this->delivery_date = $delivery_date;
2722 if (!$notrigger && empty($error)) {
2732 $this->db->commit();
2735 foreach ($this->errors as $errmsg) {
2736 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2737 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2739 $this->db->rollback();
2761 public function liste_array($shortlist = 0, $draft = 0, $excluser =
null, $socid = 0, $limit = 0, $offset = 0, $sortfield =
'c.date_commande', $sortorder =
'DESC')
2768 $sql =
"SELECT s.rowid, s.nom as name, s.client,";
2769 $sql .=
" c.rowid as cid, c.ref";
2770 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2771 $sql .=
", sc.fk_soc, sc.fk_user";
2773 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.$this->table_element.
" as c";
2774 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2775 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
2777 $sql .=
" WHERE c.entity IN (".getEntity(
'commande').
")";
2778 $sql .=
" AND c.fk_soc = s.rowid";
2779 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2780 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
2783 $sql .=
" AND s.rowid = ".((int) $socid);
2786 $sql .=
" AND c.fk_statut = ".self::STATUS_DRAFT;
2788 if (is_object($excluser)) {
2789 $sql .=
" AND c.fk_user_author <> ".((int) $excluser->id);
2791 $sql .= $this->db->order($sortfield, $sortorder);
2792 $sql .= $this->db->plimit($limit, $offset);
2794 $result = $this->db->query($sql);
2796 $numc = $this->db->num_rows($result);
2799 while ($i < $numc) {
2800 $obj = $this->db->fetch_object($result);
2802 if ($shortlist == 1) {
2803 $ga[$obj->cid] = $obj->ref;
2804 } elseif ($shortlist == 2) {
2805 $ga[$obj->cid] = $obj->ref.
' ('.$obj->name.
')';
2807 $ga[$i][
'id'] = $obj->cid;
2808 $ga[$i][
'ref'] = $obj->ref;
2809 $ga[$i][
'name'] = $obj->name;
2832 dol_syslog(
'Commande::availability('.$availability_id.
')');
2833 if ($this->
status >= self::STATUS_DRAFT) {
2838 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2839 $sql .=
' SET fk_availability = '.((int) $availability_id);
2840 $sql .=
' WHERE rowid='.((int) $this->
id);
2843 $resql = $this->db->query($sql);
2845 $this->errors[] = $this->db->error();
2850 $this->oldcopy = clone $this;
2851 $this->availability_id = $availability_id;
2854 if (!$notrigger && empty($error)) {
2864 $this->db->commit();
2867 foreach ($this->errors as $errmsg) {
2868 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2869 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2871 $this->db->rollback();
2875 $error_str =
'Command status do not meet requirement '.$this->status;
2877 $this->error = $error_str;
2878 $this->errors[] = $this->error;
2896 dol_syslog(
'Commande::demand_reason('.$demand_reason_id.
')');
2897 if ($this->
status >= self::STATUS_DRAFT) {
2902 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
2903 $sql .=
' SET fk_input_reason = '.((int) $demand_reason_id);
2904 $sql .=
' WHERE rowid='.((int) $this->
id);
2907 $resql = $this->db->query($sql);
2909 $this->errors[] = $this->db->error();
2914 $this->oldcopy = clone $this;
2915 $this->demand_reason_id = $demand_reason_id;
2918 if (!$notrigger && empty($error)) {
2928 $this->db->commit();
2931 foreach ($this->errors as $errmsg) {
2932 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2933 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2935 $this->db->rollback();
2939 $error_str =
'order status do not meet requirement '.$this->status;
2941 $this->error = $error_str;
2942 $this->errors[] = $this->error;
2959 if ($user->hasRight(
'commande',
'creer')) {
2964 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET';
2965 $sql .=
' ref_client = '.(empty($ref_client) ?
'NULL' :
"'".$this->db->escape($ref_client).
"'");
2966 $sql .=
' WHERE rowid = '.((int) $this->
id);
2968 dol_syslog(__METHOD__.
' this->id='.$this->id.
', ref_client='.$ref_client, LOG_DEBUG);
2969 $resql = $this->db->query($sql);
2971 $this->errors[] = $this->db->error();
2976 $this->oldcopy = clone $this;
2977 $this->ref_client = $ref_client;
2978 $this->ref_customer = $ref_client;
2981 if (!$notrigger && empty($error)) {
2990 $this->db->commit();
2993 foreach ($this->errors as $errmsg) {
2994 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2995 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2997 $this->db->rollback();
3016 if ($this->billed) {
3022 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET facture = 1';
3025 dol_syslog(get_class($this).
"::classifyBilled", LOG_DEBUG);
3026 if ($this->db->query($sql)) {
3028 $this->oldcopy = clone $this;
3032 if (!$notrigger && empty($error)) {
3034 $result = $this->
call_trigger(
'ORDER_CLASSIFY_BILLED', $user);
3042 $this->db->commit();
3045 foreach ($this->errors as $errmsg) {
3046 dol_syslog(get_class($this).
"::classifyBilled ".$errmsg, LOG_ERR);
3047 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3049 $this->db->rollback();
3053 $this->error = $this->db->error();
3054 $this->db->rollback();
3072 $sql =
'UPDATE '.MAIN_DB_PREFIX.$this->table_element.
' SET facture = 0';
3075 dol_syslog(get_class($this).
"::classifyUnBilled", LOG_DEBUG);
3076 if ($this->db->query($sql)) {
3078 $this->oldcopy = clone $this;
3082 if (!$notrigger && empty($error)) {
3084 $result = $this->
call_trigger(
'ORDER_CLASSIFY_UNBILLED', $user);
3094 $this->db->commit();
3097 foreach ($this->errors as $errmsg) {
3098 dol_syslog(get_class($this).
"::classifyUnBilled ".$errmsg, LOG_ERR);
3099 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3101 $this->db->rollback();
3105 $this->error = $this->db->error();
3106 $this->db->rollback();
3142 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)
3144 global $mysoc, $langs, $user;
3146 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");
3147 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
3154 if (empty($info_bits)) {
3157 if (empty($txtva)) {
3160 if (empty($txlocaltax1)) {
3163 if (empty($txlocaltax2)) {
3166 if (empty($remise_percent)) {
3167 $remise_percent = 0;
3169 if (empty($qty) && empty($special_code)) {
3172 if (!empty($qty) && $special_code == 3) {
3175 if (empty($ref_ext)) {
3179 if ($date_start && $date_end && $date_start > $date_end) {
3180 $langs->load(
"errors");
3181 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
3185 $remise_percent = (float)
price2num($remise_percent);
3189 $pu_ht_devise =
price2num($pu_ht_devise);
3190 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
3193 $txlocaltax1 = (float)
price2num($txlocaltax1);
3194 $txlocaltax2 = (float)
price2num($txlocaltax2);
3208 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
3209 $vat_src_code = $reg[1];
3210 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
3217 if ($tmpline->fetch($rowid) > 0) {
3218 $qtysign = ((float) $qty < 0 ? -1 : 1);
3219 if (abs((
float) $qty) < (float) $tmpline->packaging) {
3220 $qty = $qtysign * (float) $tmpline->packaging;
3222 if (!empty($tmpline->packaging)
3223 && is_numeric($tmpline->packaging)
3224 && (
float) $tmpline->packaging > 0
3225 && (
float)
price2num(abs((
float) $qty) - round(abs((
float) $qty) / (
float) $tmpline->packaging) * (
float) $tmpline->packaging,
'MS') != 0) {
3226 $coeff = intval(abs((
float) $qty) / $tmpline->packaging) + 1;
3227 $qty =
price2num($qtysign * (
float) $tmpline->packaging * $coeff,
'MS');
3228 setEventMessage($langs->trans(
'QtyRecalculatedWithPackaging'),
'mesgs');
3234 $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);
3236 $total_ht = $tabprice[0];
3237 $total_tva = $tabprice[1];
3238 $total_ttc = $tabprice[2];
3239 $total_localtax1 = $tabprice[9];
3240 $total_localtax2 = $tabprice[10];
3241 $pu_ht = $tabprice[3];
3242 $pu_tva = $tabprice[4];
3243 $pu_ttc = $tabprice[5];
3246 $multicurrency_total_ht = $tabprice[16];
3247 $multicurrency_total_tva = $tabprice[17];
3248 $multicurrency_total_ttc = $tabprice[18];
3249 $pu_ht_devise = $tabprice[19];
3253 if ($price_base_type ==
'TTC') {
3254 $subprice = $pu_ttc;
3259 if ($remise_percent > 0) {
3260 $remise = round(((
float) $pu * $remise_percent / 100), 2);
3261 $price = ((float) $pu - $remise);
3266 $line->fetch($rowid);
3267 $line->fetch_optionals();
3269 if (!empty($line->fk_product)) {
3270 $product =
new Product($this->db);
3271 $result = $product->fetch($line->fk_product);
3272 $product_type = $product->type;
3276 $productChildrenNb = 0;
3278 $productChildrenNb = $product->hasFatherOrChild(1);
3280 if ($productChildrenNb > 0) {
3282 $product_stock =
null;
3283 $product->loadStockForVirtualProduct(
'warehouseopen', $qty);
3284 foreach ($product->stock_warehouse as $componentStockWarehouse) {
3285 if ($product_stock ===
null) {
3286 $product_stock = $componentStockWarehouse->real;
3288 $product_stock = min($product_stock, $componentStockWarehouse->real);
3291 if ($product_stock ===
null) {
3295 $product_stock = $product->stock_reel;
3298 if ($product_stock < $qty) {
3299 $langs->load(
"errors");
3300 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnOrder', $product->ref);
3301 $this->errors[] = $this->error;
3303 dol_syslog(get_class($this).
"::addline error=Product ".$product->ref.
": ".$this->error, LOG_ERR);
3305 $this->db->rollback();
3311 $staticline = clone $line;
3313 $line->oldline = $staticline;
3314 $this->line = $line;
3315 $this->line->context = $this->context;
3316 $this->line->rang = $rang;
3319 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
3320 $rangmax = $this->
line_max($fk_parent_line);
3321 $this->line->rang = $rangmax + 1;
3324 $this->line->id = $rowid;
3325 $this->line->label = $label;
3326 $this->line->desc = $desc;
3327 $this->line->qty = $qty;
3328 $this->line->ref_ext = $ref_ext;
3330 $this->line->vat_src_code = $vat_src_code;
3331 $this->line->tva_tx = $txtva;
3332 $this->line->localtax1_tx = $txlocaltax1;
3333 $this->line->localtax2_tx = $txlocaltax2;
3334 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
3335 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
3336 $this->line->remise_percent = $remise_percent;
3337 $this->line->subprice = (float) $pu_ht;
3338 $this->line->info_bits = $info_bits;
3339 $this->line->special_code = $special_code;
3340 $this->line->total_ht = (float) $total_ht;
3341 $this->line->total_tva = (float) $total_tva;
3342 $this->line->total_localtax1 = (float) $total_localtax1;
3343 $this->line->total_localtax2 = (float) $total_localtax2;
3344 $this->line->total_ttc = (float) $total_ttc;
3345 $this->line->date_start = $date_start;
3346 $this->line->date_end = $date_end;
3347 $this->line->product_type = $type;
3348 $this->line->fk_parent_line = $fk_parent_line;
3349 $this->line->skip_update_total = $skip_update_total;
3350 $this->line->fk_unit = $fk_unit;
3352 $this->line->fk_fournprice = $fk_fournprice;
3353 $this->line->pa_ht = $pa_ht;
3356 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
3357 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
3358 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
3359 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
3362 $this->line->price = $price;
3364 if (is_array($array_options) && count($array_options) > 0) {
3366 foreach ($array_options as $key => $value) {
3367 $this->line->array_options[$key] = $array_options[$key];
3371 $result = $this->line->update($user, $notrigger);
3374 if (!empty($fk_parent_line)) {
3381 $this->db->commit();
3384 $this->error = $this->line->error;
3386 $this->db->rollback();
3390 $this->error = get_class($this).
"::updateline Order status makes operation forbidden";
3391 $this->errors = array(
'OrderStatusMakeOperationForbidden');
3408 if (isset($this->
ref)) {
3409 $this->
ref = trim($this->
ref);
3411 if (isset($this->ref_client)) {
3412 $this->ref_client = trim($this->ref_client);
3414 if (isset($this->ref_customer)) {
3415 $this->ref_customer = trim($this->ref_customer);
3417 if (isset($this->note) || isset($this->note_private)) {
3418 $this->note_private = (isset($this->note_private) ? trim($this->note_private) : trim($this->note));
3420 if (isset($this->note_public)) {
3421 $this->note_public = trim($this->note_public);
3423 if (isset($this->model_pdf)) {
3424 $this->model_pdf = trim($this->model_pdf);
3426 if (isset($this->import_key)) {
3427 $this->import_key = trim($this->import_key);
3429 $delivery_date = $this->delivery_date;
3435 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
3437 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
3438 $sql .=
" ref_client=".(isset($this->ref_client) ?
"'".$this->db->escape($this->ref_client).
"'" :
"null").
",";
3439 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
3440 $sql .=
" fk_soc=".(isset($this->socid) ? $this->socid :
"null").
",";
3441 $sql .=
" date_commande=".(strval($this->date_commande) !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
'null').
",";
3442 $sql .=
" date_valid=".(strval($this->date_validation) !=
'' ?
"'".$this->db->idate($this->date_validation).
"'" :
'null').
",";
3443 $sql .=
" total_tva=".(isset($this->total_tva) ? $this->total_tva :
"null").
",";
3444 $sql .=
" localtax1=".(isset($this->total_localtax1) ? $this->total_localtax1 :
"null").
",";
3445 $sql .=
" localtax2=".(isset($this->total_localtax2) ? $this->total_localtax2 :
"null").
",";
3446 $sql .=
" total_ht=".(isset($this->total_ht) ? $this->total_ht :
"null").
",";
3447 $sql .=
" total_ttc=".(isset($this->total_ttc) ? $this->total_ttc :
"null").
",";
3448 $sql .=
" fk_statut=".(isset($this->
status) ? $this->
status :
"null").
",";
3449 $sql .=
" fk_user_modif=".(isset($user->id) ? $user->id :
"null").
",";
3450 $sql .=
" fk_user_valid=".((isset($this->user_validation_id) && $this->user_validation_id > 0) ? $this->user_validation_id :
"null").
",";
3451 $sql .=
" fk_projet=".(isset($this->fk_project) ? $this->fk_project :
"null").
",";
3452 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? $this->cond_reglement_id :
"null").
",";
3453 $sql .=
" deposit_percent=".(!empty($this->deposit_percent) ? strval($this->deposit_percent) :
"null").
",";
3454 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? $this->mode_reglement_id :
"null").
",";
3455 $sql .=
" date_livraison=".(strval($this->delivery_date) !=
'' ?
"'".$this->db->idate($this->delivery_date).
"'" :
'null').
",";
3456 $sql .=
" fk_shipping_method=".(isset($this->shipping_method_id) ? $this->shipping_method_id :
"null").
",";
3457 $sql .=
" fk_account=".($this->fk_account > 0 ? $this->fk_account :
"null").
",";
3458 $sql .=
" fk_input_reason=".($this->demand_reason_id > 0 ? $this->demand_reason_id :
"null").
",";
3459 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
3460 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
3461 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
3462 $sql .=
" fk_warehouse=".($this->warehouse_id > 0 ? $this->warehouse_id :
"null").
",";
3463 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null").
",";
3464 $sql .=
" module_source = ".(isset($this->module_source) ?
"'".$this->db->escape($this->module_source).
"'" :
"null").
",";
3465 $sql .=
" pos_source = ".(isset($this->pos_source) ?
"'".$this->db->escape($this->pos_source).
"'" :
"null");
3466 $sql .=
" WHERE rowid=".((int) $this->
id);
3470 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3471 $resql = $this->db->query($sql);
3474 $this->errors[] =
"Error ".$this->db->lasterror();
3484 if (!$error && !$notrigger) {
3495 foreach ($this->errors as $errmsg) {
3496 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
3497 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
3499 $this->db->rollback();
3502 $this->db->commit();
3514 public function delete($user, $notrigger = 0)
3516 global
$conf, $langs;
3517 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
3521 dol_syslog(get_class($this).
"::delete ".$this->
id, LOG_DEBUG);
3536 $this->errors[] = $langs->trans(
'SomeShipmentExists');
3542 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_order";
3543 $sql .=
" WHERE fk_order = ".((int) $this->
id);
3545 $result = $this->db->query($sql);
3548 $this->errors[] = $this->db->lasterror();
3553 if (!$error && !empty($this->table_element_line)) {
3554 $tabletodelete = $this->table_element_line;
3555 $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).
")";
3556 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$tabletodelete.
" WHERE ".$this->fk_element.
" = ".((int) $this->
id);
3557 if (!$this->db->query($sqlef) || !$this->db->query($sql)) {
3559 $this->error = $this->db->lasterror();
3560 $this->errors[] = $this->error;
3561 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3586 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3592 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$this->table_element.
" WHERE rowid = ".((int) $this->
id);
3593 $res = $this->db->query($sql);
3596 $this->error = $this->db->lasterror();
3597 $this->errors[] = $this->error;
3598 dol_syslog(get_class($this).
"::delete error ".$this->error, LOG_ERR);
3614 if ($conf->commande->multidir_output[$this->entity] && !empty($this->
ref)) {
3615 $dir =
$conf->commande->multidir_output[$this->entity].
"/".$ref;
3616 $file = $dir.
"/".$ref.
".pdf";
3617 if (file_exists($file)) {
3621 $this->error =
'ErrorFailToDeleteFile';
3622 $this->errors[] = $this->error;
3623 $this->db->rollback();
3627 if (file_exists($dir)) {
3630 $this->error =
'ErrorFailToDeleteDir';
3631 $this->errors[] = $this->error;
3632 $this->db->rollback();
3640 dol_syslog(get_class($this).
"::delete ".$this->
id.
" by ".$user->id, LOG_DEBUG);
3641 $this->db->commit();
3644 $this->db->rollback();
3661 global
$conf, $langs;
3665 $sql =
"SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht";
3666 $sql .=
" FROM ".MAIN_DB_PREFIX.$this->table_element.
" as c";
3667 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
3668 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON c.fk_soc = sc.fk_soc";
3669 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3672 $sql .= $clause.
" c.entity IN (".
getEntity(
'commande').
")";
3674 if ($mode ==
'toship') {
3676 $sql .=
" AND c.fk_statut IN (" . self::STATUS_VALIDATED .
"," . self::STATUS_SHIPMENTONPROCESS .
")";
3678 if ($mode ==
'tobill') {
3680 $sql .=
" AND c.fk_statut IN (" . self::STATUS_VALIDATED .
"," . self::STATUS_SHIPMENTONPROCESS .
", " . self::STATUS_CLOSED .
") AND c.facture = 0";
3682 if ($mode ==
'shippedtobill') {
3684 $sql .=
" AND c.fk_statut IN (" . self::STATUS_CLOSED .
") AND c.facture = 0";
3687 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
3690 $resql = $this->db->query($sql);
3693 $label = $labelShort = $url =
'';
3694 if ($mode ==
'toship') {
3695 $delay_warning =
$conf->commande->client->warning_delay / 60 / 60 / 24;
3696 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=-2&mainmenu=commercial&leftmenu=orders';
3697 $label = $langs->transnoentitiesnoconv(
"OrdersToProcess");
3698 $labelShort = $langs->transnoentitiesnoconv(
"Opened");
3700 if ($mode ==
'tobill') {
3701 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=-3&search_billed=0&mainmenu=commercial&leftmenu=orders';
3702 $label = $langs->trans(
"OrdersToBill");
3703 $labelShort = $langs->trans(
"ToBill");
3705 if ($mode ==
'shippedtobill') {
3706 $url = DOL_URL_ROOT.
'/commande/list.php?search_status=3&search_billed=0&mainmenu=commercial&leftmenu=orders';
3707 $label = $langs->trans(
"OrdersToBill");
3708 $labelShort = $langs->trans(
"StatusOrderDelivered").
' '.$langs->trans(
"and").
' '.$langs->trans(
"ToBill");
3713 $response->warning_delay = $delay_warning;
3714 $response->label = $label;
3715 $response->labelShort = $labelShort;
3716 $response->url = $url;
3717 $response->url_late = DOL_URL_ROOT.
'/commande/list.php?search_option=late&mainmenu=commercial&leftmenu=orders';
3720 $generic_commande =
new Commande($this->db);
3722 while ($obj = $this->db->fetch_object($resql)) {
3723 $response->nbtodo++;
3724 $response->total += $obj->total_ht;
3726 $generic_commande->status = $obj->fk_statut;
3727 $generic_commande->date = $this->db->jdate($obj->date_commande);
3728 $generic_commande->delivery_date = $this->db->jdate($obj->delivery_date);
3730 if ($mode ==
'toship' && $generic_commande->hasDelay()) {
3731 $response->nbtodolate++;
3737 $this->error = $this->db->error();
3751 $label = $langs->trans(
'OrderSource'.$this->source);
3753 if ($label ==
'OrderSource') {
3780 public function LibStatut($status, $billed, $mode, $donotshowbilled = 0)
3783 global $langs, $hookmanager;
3786 if (empty($donotshowbilled)) {
3787 $billedtext .= ($billed ?
' - '.$langs->transnoentitiesnoconv(
"Billed") :
'');
3789 $billedtextlong = ($billed ?
' - '.$langs->transnoentitiesnoconv(
"Billed") :
'');
3793 if ($status == self::STATUS_CANCELED) {
3794 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderCanceled');
3795 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderCanceledShort');
3796 $statusType =
'status9';
3797 } elseif ($status == self::STATUS_DRAFT) {
3798 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderDraft');
3799 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderDraftShort');
3800 $statusType =
'status0';
3801 } elseif ($status == self::STATUS_VALIDATED) {
3802 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderValidated').$billedtextlong;
3803 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderValidatedShort').$billedtext;
3804 $statusType =
'status1';
3805 } elseif ($status == self::STATUS_SHIPMENTONPROCESS) {
3806 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderSent').$billedtextlong;
3807 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderSentShort').$billedtext;
3808 $labelTooltip = $langs->transnoentitiesnoconv(
"StatusOrderSent");
3809 if (!empty($this->delivery_date)) {
3810 $labelTooltip .=
' - '.$langs->transnoentitiesnoconv(
"DateDeliveryPlanned").dol_print_date($this->delivery_date,
'day').$billedtext;
3812 $statusType =
'status4';
3813 } elseif ($status == self::STATUS_CLOSED) {
3814 $labelStatus = $langs->transnoentitiesnoconv(
'StatusOrderDelivered').$billedtextlong;
3815 $labelStatusShort = $langs->transnoentitiesnoconv(
'StatusOrderDeliveredShort').$billedtext;
3816 $statusType =
'status6';
3818 $labelStatus = $langs->transnoentitiesnoconv(
'Unknown');
3819 $labelStatusShort =
'';
3824 $parameters = array(
3825 'status' => $status,
3827 'billed' => $billed,
3828 'donotshowbilled' => $donotshowbilled
3831 $reshook = $hookmanager->executeHooks(
'LibStatut', $parameters, $this);
3834 return $hookmanager->resPrint;
3837 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode,
'', array(
'tooltip' => $labelTooltip));
3849 global
$conf, $langs, $user;
3851 $langs->load(
'orders');
3853 $nofetch = !empty($params[
'nofetch']);
3856 return [
'optimize' => $langs->trans(
"Order")];
3859 if ($user->hasRight(
'commande',
'lire')) {
3860 $datas[
'picto'] =
img_picto(
'', $this->picto,
'', 0, 0, 0,
'',
'paddingrightonly').
'<u>'.$langs->trans(
"Order").
'</u>';
3861 if (isset($this->
status)) {
3862 $datas[
'status'] =
' '.$this->getLibStatut(5);
3864 $datas[
'Ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
3866 $langs->load(
'companies');
3867 if (empty($this->thirdparty)) {
3870 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
3872 $datas[
'RefCustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '.(empty($this->ref_customer) ? (empty($this->ref_client) ?
'' : $this->ref_client) : $this->ref_customer);
3874 $langs->load(
'project');
3875 if (is_null($this->project) || (is_object($this->project) && $this->project->isEmpty())) {
3877 if ($res > 0 && $this->project instanceof
Project) {
3878 $datas[
'project'] =
'<br><b>'.$langs->trans(
'Project').
':</b> '.$this->project->getNomUrl(1,
'', 0,
'1');
3882 if (!empty($this->total_ht)) {
3883 $datas[
'AmountHT'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1,
$conf->currency);
3885 if (!empty($this->total_tva)) {
3886 $datas[
'VAT'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1,
$conf->currency);
3888 if (!empty($this->total_ttc)) {
3889 $datas[
'AmountTTC'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1,
$conf->currency);
3891 if (!empty($this->date)) {
3892 $datas[
'Date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->date,
'day');
3894 if (!empty($this->delivery_date)) {
3895 $datas[
'DeliveryDate'] =
'<br><b>'.$langs->trans(
'DeliveryDate').
':</b> '.
dol_print_date($this->delivery_date,
'dayhour');
3915 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0, $target =
'')
3917 global
$conf, $langs, $user, $hookmanager;
3919 if (!empty(
$conf->dol_no_mouse_hover)) {
3925 if (isModEnabled(
"shipping") && ($option ==
'1' || $option ==
'2')) {
3926 $url = DOL_URL_ROOT.
'/expedition/shipment.php?id='.$this->id;
3928 $url = DOL_URL_ROOT.
'/commande/card.php?id='.$this->id;
3931 if (!$user->hasRight(
'commande',
'lire')) {
3935 if ($option !==
'nolink') {
3937 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
3938 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
3939 $add_save_lastsearch_values = 1;
3941 if ($add_save_lastsearch_values) {
3942 $url .=
'&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);
4076 global
$conf, $langs;
4078 dol_syslog(get_class($this).
"::initAsSpecimen");
4083 $sql =
"SELECT rowid";
4084 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
4085 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
4086 $sql .= $this->db->plimit(100);
4088 $resql = $this->db->query($sql);
4090 $num_prods = $this->db->num_rows($resql);
4092 while ($i < $num_prods) {
4094 $row = $this->db->fetch_row($resql);
4095 $prodids[$i] = $row[0];
4101 $this->
ref =
'SPECIMEN';
4102 $this->specimen = 1;
4103 $this->entity =
$conf->entity;
4105 $this->date = time();
4106 $this->date_lim_reglement = $this->date + 3600 * 24 * 30;
4107 $this->cond_reglement_code =
'RECEP';
4108 $this->mode_reglement_code =
'CHQ';
4109 $this->availability_code =
'DSP';
4110 $this->demand_reason_code =
'SRC_00';
4112 $this->note_public =
'This is a comment (public)';
4113 $this->note_private =
'This is a comment (private)';
4115 $this->multicurrency_tx = 1;
4116 $this->multicurrency_code =
$conf->currency;
4118 $this->
status = $this::STATUS_DRAFT;
4124 while ($xnbp < $nbp) {
4127 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
4129 $line->subprice = 100;
4133 $line->total_ht = 50;
4134 $line->total_ttc = 60;
4135 $line->total_tva = 10;
4136 $line->remise_percent = 50;
4138 $line->total_ht = 100;
4139 $line->total_ttc = 120;
4140 $line->total_tva = 20;
4141 $line->remise_percent = 0;
4143 if ($num_prods > 0) {
4144 $prodid = mt_rand(1, $num_prods);
4145 $line->fk_product = $prodids[$prodid];
4146 $line->product_ref =
'SPECIMEN';
4149 $this->lines[$xnbp] = $line;
4151 $this->total_ht += $line->total_ht;
4152 $this->total_tva += $line->total_tva;
4153 $this->total_ttc += $line->total_ttc;
4171 $this->nb = array();
4174 $sql =
"SELECT count(co.rowid) as nb";
4175 $sql .=
" FROM ".MAIN_DB_PREFIX.$this->table_element.
" as co";
4176 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON co.fk_soc = s.rowid";
4177 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
4178 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
4179 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
4182 $sql .=
" ".$clause.
" co.entity IN (".
getEntity(
'commande').
")";
4184 $resql = $this->db->query($sql);
4186 while ($obj = $this->db->fetch_object($resql)) {
4187 $this->nb[
"orders"] = $obj->nb;
4189 $this->db->free($resql);
4193 $this->error = $this->db->error();
4219 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
4223 $langs->load(
"orders");
4224 $outputlangs->load(
"products");
4227 $modele =
'einstein';
4229 if (!empty($this->model_pdf)) {
4230 $modele = $this->model_pdf;
4236 $modelpath =
"core/modules/commande/doc/";
4238 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
4291 return max($this->date, $this->delivery_date) < ($now -
$conf->commande->client->warning_delay);
4301 global
$conf, $langs;
4303 if (empty($this->delivery_date)) {
4304 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date,
'day');
4306 $text = $text = $langs->trans(
"DeliveryDate").
' '.
dol_print_date($this->delivery_date,
'day');
4308 $text .=
' '.($conf->commande->client->warning_delay > 0 ?
'+' :
'-').
' '.round(abs(
$conf->commande->client->warning_delay) / 3600 / 24, 1).
' '.$langs->trans(
"days").
' < '.$langs->trans(
"Today");
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $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.
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.
initAsSpecimen()
Initialise an instance with random values.
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.
cancel($idwarehouse=-1)
Cancel an order If stock is decremented on order validation, we must reincrement it.
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.
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.
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
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)
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.
call_trigger($triggerName, $user)
Call trigger based on this instance.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
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.
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.
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)
setEventMessage($mesgs, $style='mesgs', $noduplicate=0, $attop=0)
Set event message in dol_events session object.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
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, 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.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
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.