40require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
41require_once DOL_DOCUMENT_ROOT.
"/expedition/class/expeditionligne.class.php";
42require_once DOL_DOCUMENT_ROOT.
'/core/class/commonincoterm.class.php';
44 require_once DOL_DOCUMENT_ROOT.
'/comm/propal/class/propal.class.php';
47 require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expeditionlinebatch.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/core/class/commonsignedobject.class.php';
51require_once DOL_DOCUMENT_ROOT.
'/subtotals/class/commonsubtotal.class.php';
61 use CommonSignedObject;
67 public $element =
"shipping";
72 public $fk_element =
"fk_expedition";
77 public $table_element =
"expedition";
82 public $table_element_line =
"expeditiondet";
87 public $class_element_line =
'ExpeditionLigne';
92 public $picto =
'dolly';
98 public $fields = array();
104 public $user_author_id;
110 public $fk_user_author;
116 public $fk_user_valid;
133 public $ref_customer;
143 public $tracking_number;
148 public $tracking_url;
161 public $weight_units;
177 public $height_units;
194 public $livraison_id;
199 public $multicurrency_subprice;
229 public $date_delivery;
243 public $date_expedition;
249 public $date_shipping;
278 public $lines = array();
284 public $fk_multicurrency;
289 public $multicurrency_code;
293 public $multicurrency_tx;
297 public $multicurrency_total_ht;
301 public $multicurrency_total_tva;
305 public $multicurrency_total_ttc;
352 $this->ismultientitymanaged = 1;
353 $this->isextrafieldmanaged = 1;
356 $this->labelStatus = array();
357 $this->labelStatus[-1] =
'StatusSendingCanceled';
358 $this->labelStatus[0] =
'StatusSendingDraft';
359 $this->labelStatus[1] =
'StatusSendingValidated';
360 $this->labelStatus[2] =
'StatusSendingProcessed';
363 $this->labelStatusShort = array();
364 $this->labelStatusShort[-1] =
'StatusSendingCanceledShort';
365 $this->labelStatusShort[0] =
'StatusSendingDraftShort';
366 $this->labelStatusShort[1] =
'StatusSendingValidatedShort';
367 $this->labelStatusShort[2] =
'StatusSendingProcessedShort';
376 public function getNextNumRef($soc)
378 global $langs, $conf;
379 $langs->load(
"sendings");
388 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
390 foreach ($dirmodels as $reldir) {
394 $mybool = ((bool) @include_once $dir.$file) || $mybool;
402 $obj =
new $classname();
403 '@phan-var-force ModelNumRefExpedition $obj';
405 $numref = $obj->getNextValue($soc, $this);
410 dol_print_error($this->db, get_class($this).
"::getNextNumRef ".$obj->error);
414 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_EXPEDITION_ADDON_NUMBER_NotDefined");
426 public function create($user, $notrigger = 0)
430 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
435 if (empty($this->fk_project)) {
436 $this->fk_project = 0;
438 if (empty($this->date_creation)) {
439 $this->date_creation = $now;
441 if (empty($this->date_shipping) && !empty($this->date_expedition)) {
442 $this->date_shipping = $this->date_expedition;
450 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"expedition (";
453 $sql .=
", ref_customer";
455 $sql .=
", date_creation";
456 $sql .=
", fk_user_author";
457 $sql .=
", date_expedition";
458 $sql .=
", date_delivery";
460 $sql .=
", fk_projet";
461 $sql .=
", fk_address";
462 $sql .=
", fk_shipping_method";
463 $sql .=
", tracking_number";
468 $sql .=
", weight_units";
469 $sql .=
", size_units";
470 $sql .=
", note_private";
471 $sql .=
", note_public";
472 $sql .=
", model_pdf";
473 $sql .=
", fk_incoterms, location_incoterms";
474 $sql .=
", signed_status";
475 $sql .=
") VALUES (";
477 $sql .=
", ".((int) $this->entity);
478 $sql .=
", ".($this->ref_customer ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null");
479 $sql .=
", ".($this->ref_ext ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
480 $sql .=
", '".$this->db->idate($this->date_creation).
"'";
481 $sql .=
", ".((int) $user->id);
482 $sql .=
", ".($this->date_shipping > 0 ?
"'".$this->db->idate($this->date_shipping).
"'" :
"null");
483 $sql .=
", ".($this->date_delivery > 0 ?
"'".$this->db->idate($this->date_delivery).
"'" :
"null");
484 $sql .=
", ".($this->socid > 0 ? ((int) $this->socid) :
"null");
485 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
486 $sql .=
", ".($this->fk_delivery_address > 0 ? ((int) $this->fk_delivery_address) :
"null");
487 $sql .=
", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
"null");
488 $sql .=
", '".$this->db->escape($this->tracking_number).
"'";
489 $sql .=
", ".(is_numeric($this->weight) ? (float) $this->weight :
'NULL');
490 $sql .=
", ".(is_numeric($this->sizeS) ? (float) $this->sizeS :
'NULL');
491 $sql .=
", ".(is_numeric($this->sizeW) ? (float) $this->sizeW :
'NULL');
492 $sql .=
", ".(is_numeric($this->sizeH) ? (float) $this->sizeH :
'NULL');
493 $sql .=
", ".($this->weight_units !=
'' ? (int) $this->weight_units :
'NULL');
494 $sql .=
", ".($this->size_units !=
'' ? (int) $this->size_units :
'NULL');
495 $sql .=
", ".(!empty($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
496 $sql .=
", ".(!empty($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
497 $sql .=
", ".(!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null");
498 $sql .=
", ".((int) $this->fk_incoterms);
499 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
500 $sql .=
", ".((int) $this->signed_status);
503 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
504 $resql = $this->db->query($sql);
506 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"expedition");
509 $initialref =
'(PROV'.$this->id.
')';
510 if (!empty($this->
ref)) {
511 $initialref = $this->ref;
514 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
515 $sql .=
" SET ref = '".$this->db->escape($initialref).
"'";
516 $sql .=
" WHERE rowid = ".((int) $this->
id);
518 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
519 if ($this->db->query($sql)) {
520 $this->
ref = $initialref;
522 $num = count($this->lines);
523 $kits_list = array();
525 for ($i = 0; $i < $num; $i++) {
527 $objectsrc->fetch($this->lines[$i]->origin_line_id);
528 if ($this->lines[$i]->product_type ==
"9" && $objectsrc->special_code == SUBTOTALS_SPECIAL_CODE) {
529 if ($this->
create_line($this->lines[$i]->entrepot_id, $this->lines[$i]->origin_line_id, $this->lines[$i]->qty, $this->lines[$i]->rang, $this->lines[$i]->array_options) <= 0) {
536 $line = $this->lines[$i];
537 if ($line->fk_product > 0) {
543 if (!isset($kits_list[$line->fk_elementdet])) {
544 if (!is_object($line->product)) {
545 $line_product =
new Product($this->db);
546 $result = $line_product->fetch($line->fk_product,
'',
'',
'', 1, 1, 1);
551 $line_product = $line->product;
555 $line_product->get_sousproduits_arbo();
556 $prods_arbo = $line_product->get_arbo_each_prod($line->qty);
557 if (count($prods_arbo) > 0) {
558 $kits_list[$line->fk_elementdet] = array(
559 'arbo' => $prods_arbo,
560 'total_qty' => $line->qty,
564 $kits_list[$line->fk_elementdet][
'total_qty'] += $line->qty;
570 $kits_id_cached = array();
571 $sub_kits_id_cached = array();
572 $sub_parents_cached = array();
573 for ($i = 0; $i < $num; $i++) {
574 $line = $this->lines[$i];
577 if (!isset($kits_id_cached[$line->fk_elementdet])) {
578 if (!isset($line->detail_batch) || (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE'))) {
579 $qty = isset($kits_list[$line->fk_elementdet]) ? $kits_list[$line->fk_elementdet][
'total_qty'] : $line->qty;
580 $warehouse_id = (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) ? 0 : $line->entrepot_id;
581 $line_id = $this->
create_line($warehouse_id, $line->origin_line_id, $qty, $line->rang, $line->array_options, 0, $line->fk_product);
585 if (isset($kits_list[$line->fk_elementdet])) {
586 $kits_id_cached[$line->fk_elementdet] = $line_id;
594 $line_id = $kits_id_cached[$line->fk_elementdet];
598 if (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) {
599 $prods_arbo = $kits_list[$line->fk_elementdet][
'arbo'];
602 $parent_line_id = $line_id;
604 $product_child_id = 0;
605 foreach ($prods_arbo as $index => $product_child_arr) {
620 $product_child_level = (int) $product_child_arr[
'level'];
621 $product_child_incdec = !empty($product_child_arr[
'incdec']);
624 if ($product_child_level != $level_last) {
625 $parent_line_id = $line_id;
626 $parent_product_id = $product_child_id;
627 if (isset($sub_parents_cached[$line->fk_elementdet][$parent_product_id])) {
628 $parent_line_id = $sub_parents_cached[$line->fk_elementdet][$parent_product_id];
630 $sub_parents_cached[$line->fk_elementdet][$parent_product_id] = $parent_line_id;
636 $next_level = $product_child_level;
637 $next_index = $index + 1;
638 if (isset($prods_arbo[$next_index])) {
639 $next_level = (int) $prods_arbo[$next_index][
'level'];
641 if ($next_level > $product_child_level) {
646 $product_child_id = (int) $product_child_arr[
'id'];
647 $product_child_qty = (float) $product_child_arr[
'nb_total'];
648 $warehouse_id = $line->entrepot_id;
649 if ($is_kit || !$product_child_incdec) {
650 if (!$product_child_incdec) {
651 $product_child_qty = 0;
657 if (!isset($sub_kits_id_cached[$line->fk_elementdet][$product_child_id]) || $warehouse_id > 0) {
658 $line_id = $this->
create_line($warehouse_id, ($parent_line_id ? 0 : $line->origin_line_id), $product_child_qty, $line->rang, $line->array_options, $parent_line_id, $product_child_id);
666 if (empty($warehouse_id)) {
667 $sub_kits_id_cached[$line->fk_elementdet][$product_child_id] = $line_id;
671 $level_last = $product_child_level;
677 if (!$error && $this->
id && $this->origin_id) {
684 if (!$error && $this->
id &&
getDolGlobalInt(
'SHIPPING_USE_ITS_OWN_CONTACTS') &&
getDolGlobalString(
'MAIN_PROPAGATE_CONTACTS_FROM_ORIGIN') && !empty($this->origin_type) && !empty($this->origin_id)) {
685 $originforcontact = $this->origin_type;
686 $originidforcontact = $this->origin_id;
688 $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";
689 $sqlcontact .=
" WHERE element_id = ".((int) $originidforcontact).
" AND ec.fk_c_type_contact = ctc.rowid AND ctc.element = '".$this->db->escape($originforcontact).
"'";
691 $resqlcontact = $this->db->query($sqlcontact);
693 while ($objcontact = $this->db->fetch_object($resqlcontact)) {
694 $this->
add_contact($objcontact->fk_socpeople, $objcontact->code, $objcontact->source);
709 if (!$error && !$notrigger) {
711 $result = $this->call_trigger(
'SHIPPING_CREATE', $user);
721 foreach ($this->errors as $errmsg) {
722 dol_syslog(get_class($this).
"::create ".$errmsg, LOG_ERR);
723 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
725 $this->db->rollback();
730 $this->db->rollback();
735 $this->error = $this->db->lasterror().
" - sql=$sql";
736 $this->db->rollback();
741 $this->error = $this->db->error().
" - sql=$sql";
742 $this->db->rollback();
760 public function create_line($entrepot_id, $origin_line_id, $qty, $rang = 0, $array_options = [], $parent_line_id = 0, $product_id = 0)
766 $expeditionline->fk_expedition = $this->id;
767 $expeditionline->entrepot_id = $entrepot_id;
768 $expeditionline->fk_elementdet = $origin_line_id;
769 $expeditionline->element_type = $this->origin;
770 $expeditionline->fk_parent = $parent_line_id;
771 $expeditionline->fk_product = $product_id;
772 $expeditionline->qty = $qty;
773 $expeditionline->rang = $rang;
774 $expeditionline->array_options = $array_options;
776 if (!($expeditionline->fk_product > 0)) {
778 $order_line->fetch($expeditionline->fk_elementdet);
779 $expeditionline->fk_product = $order_line->fk_product;
782 if (($lineId = $expeditionline->insert($user)) < 0) {
802 $stockLocationQty = array();
804 $tab = $line_ext->detail_batch;
806 foreach ($tab as $detbatch) {
807 if (!empty($detbatch->fk_warehouse)) {
808 if (empty($stockLocationQty[$detbatch->fk_warehouse])) {
809 $stockLocationQty[$detbatch->fk_warehouse] = 0;
811 $stockLocationQty[$detbatch->fk_warehouse] += $detbatch->qty;
815 foreach ($stockLocationQty as $stockLocation => $qty) {
816 $line_id = $this->
create_line($stockLocation, $line_ext->origin_line_id, $qty, $line_ext->rang, $array_options);
821 foreach ($tab as $detbatch) {
822 if ($detbatch->fk_warehouse == $stockLocation) {
823 if (!($detbatch->create($line_id) > 0)) {
824 $this->errors = $detbatch->errors;
848 public function fetch($id, $ref =
'', $ref_ext =
'', $notused =
'')
853 if (empty($id) && empty($ref) && empty($ref_ext)) {
857 $sql =
"SELECT e.rowid, e.entity, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.fk_user_author, e.fk_statut, e.signed_status, e.fk_projet as fk_project, e.billed";
858 $sql .=
", e.date_valid, e.fk_user_valid";
859 $sql .=
", e.weight, e.weight_units, e.size, e.size_units, e.width, e.height";
860 $sql .=
", e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery";
861 $sql .=
", e.fk_shipping_method, e.tracking_number";
862 $sql .=
", e.note_private, e.note_public";
863 $sql .=
', e.fk_incoterms, e.location_incoterms';
864 $sql .=
', e.signed_status';
865 $sql .=
', i.libelle as label_incoterms';
866 $sql .=
', s.libelle as shipping_method';
867 $sql .=
", el.fk_source as origin_id, el.sourcetype as origin_type";
868 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expedition as e";
869 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON el.fk_target = e.rowid AND el.targettype = '".$this->db->escape($this->element).
"'";
870 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON e.fk_incoterms = i.rowid';
871 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_shipment_mode as s ON e.fk_shipping_method = s.rowid';
872 $sql .=
" WHERE e.entity IN (".getEntity(
'expedition').
")";
874 $sql .=
" AND e.rowid = ".((int) $id);
877 $sql .=
" AND e.ref='".$this->db->escape($ref).
"'";
880 $sql .=
" AND e.ref_ext='".$this->db->escape($ref_ext).
"'";
883 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
884 $result = $this->db->query($sql);
886 if ($this->db->num_rows($result)) {
887 $obj = $this->db->fetch_object($result);
889 $this->
id = (int) $obj->rowid;
890 $this->entity = $obj->entity;
891 $this->
ref = $obj->ref;
892 $this->socid = $obj->socid;
893 $this->ref_customer = $obj->ref_customer;
894 $this->ref_ext = $obj->ref_ext;
895 $this->
status = $obj->fk_statut;
896 $this->statut = $this->status;
897 $this->signed_status = $obj->signed_status;
898 $this->user_author_id = $obj->fk_user_author;
899 $this->fk_user_author = $obj->fk_user_author;
900 $this->user_creation_id = $obj->fk_user_author;
901 $this->fk_user_valid = $obj->fk_user_valid;
902 $this->date_creation = $this->db->jdate($obj->date_creation);
903 $this->date_valid = $this->db->jdate($obj->date_valid);
904 $this->
date = $this->db->jdate($obj->date_expedition);
905 $this->date_expedition = $this->db->jdate($obj->date_expedition);
906 $this->date_shipping = $this->db->jdate($obj->date_expedition);
907 $this->date_delivery = $this->db->jdate($obj->date_delivery);
908 $this->fk_delivery_address = $obj->fk_address;
909 $this->model_pdf = $obj->model_pdf;
910 $this->shipping_method_id = $obj->fk_shipping_method;
911 $this->shipping_method = $obj->shipping_method;
912 $this->tracking_number = $obj->tracking_number;
913 $this->origin = ($obj->origin_type ? $obj->origin_type :
'commande');
914 $this->origin_type = ($obj->origin_type ? $obj->origin_type :
'commande');
915 $this->origin_id = $obj->origin_id;
916 $this->billed = $obj->billed;
917 $this->fk_project = $obj->fk_project;
918 $this->signed_status = $obj->signed_status;
919 $this->trueWeight = $obj->weight;
920 $this->weight_units = $obj->weight_units;
922 $this->trueWidth = $obj->width;
923 $this->width_units = $obj->size_units;
924 $this->trueHeight = $obj->height;
925 $this->height_units = $obj->size_units;
926 $this->trueDepth = $obj->size;
927 $this->depth_units = $obj->size_units;
929 $this->note_public = $obj->note_public;
930 $this->note_private = $obj->note_private;
933 $this->trueSize = $obj->size.
"x".$obj->width.
"x".$obj->height;
934 $this->size_units = $obj->size_units;
937 $this->fk_incoterms = $obj->fk_incoterms;
938 $this->location_incoterms = $obj->location_incoterms;
939 $this->label_incoterms = $obj->label_incoterms;
941 $this->db->free($result);
954 if (!empty($this->multicurrency_code)) {
955 $this->multicurrency_code = $this->thirdparty->multicurrency_code;
957 if (
getDolGlobalString(
'MULTICURRENCY_USE_ORIGIN_TX') && !empty($this->thirdparty->multicurrency_tx)) {
958 $this->multicurrency_tx = $this->thirdparty->multicurrency_tx;
965 if (empty($obj->origin_id)) {
976 dol_syslog(get_class($this).
'::Fetch no expedition found', LOG_ERR);
977 $this->error =
'Shipment with id '.$id.
' not found';
981 $this->error = $this->db->error();
993 public function valid($user, $notrigger = 0)
997 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1003 dol_syslog(get_class($this).
"::valid not in draft status", LOG_WARNING);
1007 if (!isset($this->socid)) {
1008 dol_syslog(get_class($this).
"::can't valid socid not set", LOG_WARNING);
1012 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expedition',
'creer'))
1013 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expedition',
'shipping_advance',
'validate')))) {
1014 $this->error =
'Permission denied';
1015 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
1024 $soc =
new Societe($this->db);
1025 $soc->fetch($this->socid);
1028 $result = $soc->setAsCustomer();
1031 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1032 $numref = $this->getNextNumRef($soc);
1033 } elseif (!empty($this->
ref)) {
1034 $numref = (string) $this->
ref;
1036 $numref =
"EXP".$this->id;
1043 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition SET";
1044 $sql .=
" ref = '".$this->db->escape($numref).
"'";
1045 $sql .=
", fk_statut = 1";
1046 $sql .=
", date_valid = '".$this->db->idate($now).
"'";
1047 $sql .=
", fk_user_valid = ".((int) $user->id);
1048 $sql .=
" WHERE rowid = ".((int) $this->
id);
1050 dol_syslog(get_class($this).
"::valid update expedition", LOG_DEBUG);
1051 $resql = $this->db->query($sql);
1053 $this->error = $this->db->lasterror();
1067 $triggerKey =
'SHIPPING_';
1068 if ($this->origin ==
'commande') {
1069 $triggerKey.=
'ORDER_SHIPMENTONPROCESS';
1071 $triggerKey.= strtoupper($this->origin).
'_SHIPMENTONPROCESS';
1081 if (!$error && !$notrigger) {
1083 $result = $this->call_trigger(
'SHIPPING_VALIDATE', $user);
1091 $this->oldref = $this->ref;
1094 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
1096 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'expedition/sending/".$this->db->escape($this->newref).
"'";
1097 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'expedition/sending/".$this->db->escape($this->
ref).
"' and entity = ".((int) $conf->entity);
1098 $resql = $this->db->query($sql);
1101 $this->error = $this->db->lasterror();
1103 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'expedition/sending/".$this->db->escape($this->newref).
"'";
1104 $sql .=
" WHERE filepath = 'expedition/sending/".$this->db->escape($this->
ref).
"' and entity = ".((int) $conf->entity);
1105 $resql = $this->db->query($sql);
1108 $this->error = $this->db->lasterror();
1114 $dirsource = $conf->expedition->dir_output.
'/sending/'.$oldref;
1115 $dirdest = $conf->expedition->dir_output.
'/sending/'.$newref;
1116 if (!$error && file_exists($dirsource)) {
1117 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
1119 if (@rename($dirsource, $dirdest)) {
1122 $listoffiles =
dol_dir_list($conf->expedition->dir_output.
'/sending/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
1123 foreach ($listoffiles as $fileentry) {
1124 $dirsource = $fileentry[
'name'];
1125 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
1126 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1127 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1128 @rename($dirsource, $dirdest);
1137 $this->
ref = $numref;
1143 $this->db->commit();
1146 $this->db->rollback();
1163 if ($this->
status == self::STATUS_VALIDATED || $this->
status == self::STATUS_CLOSED) {
1165 include_once DOL_DOCUMENT_ROOT.
'/delivery/class/delivery.class.php';
1166 $delivery =
new Delivery($this->db);
1167 $result = $delivery->create_from_sending($user, $this->
id);
1192 public function addline($entrepot_id, $id, $qty, $array_options = [], $fk_product = 0, $fk_parent = 0)
1196 $num = count($this->lines);
1199 $line->entrepot_id = $entrepot_id;
1200 $line->origin_line_id = $id;
1201 $line->fk_elementdet = $id;
1202 $line->element_type =
'order';
1203 $line->fk_parent = $fk_parent;
1204 $line->fk_product = $fk_product;
1208 $orderline->fetch($id);
1211 $line->rang = $orderline->rang;
1212 $line->product_type = $orderline->product_type;
1213 if (!($line->fk_product > 0)) {
1214 $line->fk_product = $orderline->fk_product;
1217 if (
isModEnabled(
'stock') && !empty($orderline->fk_product)) {
1218 $product =
new Product($this->db);
1219 $product->fetch($orderline->fk_product);
1222 $langs->load(
"errors");
1223 $this->error = $langs->trans(
"ErrorWarehouseRequiredIntoShipmentLine");
1228 $productChildrenNb = 0;
1230 $productChildrenNb = $product->hasFatherOrChild(1);
1232 if ($productChildrenNb > 0) {
1233 $product_stock =
null;
1234 $product->loadStockForVirtualProduct(
'warehouseopen', $line->qty);
1235 if ($entrepot_id > 0) {
1236 if (isset($product->stock_warehouse[$entrepot_id])) {
1237 $product_stock = $product->stock_warehouse[$entrepot_id]->real;
1240 foreach ($product->stock_warehouse as $componentStockWarehouse) {
1241 if ($product_stock ===
null) {
1242 $product_stock = $componentStockWarehouse->real;
1244 $product_stock = min($product_stock, $componentStockWarehouse->real);
1248 if ($product_stock ===
null) {
1253 if ($entrepot_id > 0) {
1254 $product->load_stock(
'warehouseopen');
1255 $product_stock = $product->stock_warehouse[$entrepot_id]->real;
1257 $product_stock = $product->stock_reel;
1261 $product_type = $product->type;
1263 $isavirtualproduct = ($productChildrenNb > 0);
1268 || ($isavirtualproduct && !
getDolGlobalInt(
'STOCK_EXCLUDE_VIRTUAL_PRODUCTS'))
1271 if ($product->stockable_product == Product::ENABLED_STOCK && $product_stock < $qty) {
1272 $langs->load(
"errors");
1273 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnShipment', $product->ref);
1274 $this->errorhidden =
'ErrorStockIsNotEnoughToAddProductOnShipment';
1285 if (
isModEnabled(
'productbatch') && !empty($line->fk_product) && !empty($orderline->product_tobatch)) {
1286 $this->error =
'ADDLINE_WAS_CALLED_INSTEAD_OF_ADDLINEBATCH '.$orderline->id.
' '.$line->fk_product;
1291 if (!
getDolGlobalString(
'MAIN_EXTRAFIELDS_DISABLED') && is_array($array_options) && count($array_options) > 0) {
1292 $line->array_options = $array_options;
1295 $this->lines[$num] = $line;
1313 public function addlinefree($qty, $element_type, $fk_product, $fk_unit, $rang, $description, $fk_parent, $array_options = [])
1315 global
$mysoc, $langs, $user;
1317 if ($this->
status == self::STATUS_DRAFT) {
1328 if ($ranktouse == -1) {
1329 $rangmax = $this->
line_max($fk_parent);
1330 $ranktouse = $rangmax + 1;
1335 $this->line->fk_expedition = $this->id;
1336 $this->line->element_type = $element_type;
1337 $this->line->fk_product = $fk_product;
1338 $this->line->description = $description;
1339 $this->line->desc = $description;
1340 $this->line->fk_parent = $fk_parent;
1341 $this->line->qty = (float) $qty;
1342 $this->line->fk_unit = $fk_unit;
1343 $this->line->rang = $ranktouse;
1345 if (is_array($array_options) && count($array_options) > 0) {
1346 $this->line->array_options = $array_options;
1349 $result = $this->line->insert($user);
1351 if (!isset($this->context[
'createfromclone'])) {
1352 if (!empty($fk_parent)) {
1354 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) {
1355 $linecount = count($this->lines);
1356 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
1360 $this->lines[] = $this->line;
1363 $this->db->commit();
1364 return $this->line->id;
1366 $this->error = $this->line->error;
1367 dol_syslog(get_class($this).
"::addlinefree error=".$this->error, LOG_ERR);
1368 $this->db->rollback();
1372 dol_syslog(get_class($this).
"::addlinefree status of shipment must be Draft to allow use of ->addlinefree()", LOG_ERR);
1392 public function updatelinefree($rowid, $qty, $element_type, $fk_product, $fk_unit, $rang, $description, $fk_parent, $notrigger, $array_options = array())
1394 global
$mysoc, $langs, $user;
1396 if ($this->
status == self::STATUS_DRAFT) {
1406 $qty = (float) $qty;
1407 $description = trim($description);
1412 $line->fetch($rowid);
1413 $line->fetch_optionals();
1415 if (!empty($line->fk_product)) {
1416 $product =
new Product($this->db);
1417 $result = $product->fetch($line->fk_product);
1418 $product_type = $product->type;
1421 $staticline = clone $line;
1423 $line->oldline = $staticline;
1424 $this->line = $line;
1425 $this->line->context = $this->context;
1426 $this->line->rang = $rang;
1427 $this->line->fk_expedition = $this->id;
1428 $this->line->element_type = $element_type;
1429 $this->line->fk_product = $fk_product;
1430 $this->line->qty = $qty;
1431 $this->line->fk_unit = $fk_unit;
1432 $this->line->fk_parent = $fk_parent;
1433 $this->line->description = $description;
1435 if (is_array($array_options) && count($array_options) > 0) {
1437 foreach ($array_options as $key => $value) {
1438 $this->line->array_options[$key] = $array_options[$key];
1442 $result = $this->line->update($user, $notrigger);
1445 if (!empty($fk_parent)) {
1449 $this->db->commit();
1452 $this->error = $this->line->error;
1454 $this->db->rollback();
1458 $this->error = get_class($this).
"::updatelinefree Shipment status makes operation forbidden";
1459 $this->errors = array(
'ShipmentStatusMakeOperationForbidden');
1473 public function addline_batch($dbatch, $array_options = [], $origin_line =
null)
1478 $num = count($this->lines);
1480 if ($dbatch[
'qty'] > 0 || ($dbatch[
'qty'] == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS'))) {
1483 foreach ($dbatch[
'detail'] as $key => $value) {
1484 if ($value[
'q'] > 0 || ($value[
'q'] == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS'))) {
1490 $ret = $linebatch->fetchFromStock($value[
'id_batch']);
1495 $linebatch->qty = $value[
'q'];
1496 if ($linebatch->qty == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS')) {
1497 $linebatch->batch =
null;
1499 $tab[] = $linebatch;
1502 require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
1504 $prod_batch->fetch($value[
'id_batch']);
1506 if ($prod_batch->qty < $linebatch->qty) {
1507 $langs->load(
"errors");
1508 $this->errors[] = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnShipment', $prod_batch->fk_product);
1509 dol_syslog(get_class($this).
"::addline_batch error=Product ".$prod_batch->batch.
": ".$this->errorsToString(), LOG_ERR);
1515 if (is_object($linebatch)) {
1516 $line->entrepot_id = $linebatch->fk_warehouse;
1518 $line->origin_line_id = $dbatch[
'ix_l'];
1519 $line->fk_elementdet = $dbatch[
'ix_l'];
1520 $line->qty = $dbatch[
'qty'];
1521 $line->detail_batch = $tab;
1522 if (!($line->rang > 0)) {
1523 $line->rang = $origin_line->rang;
1525 if (!($line->fk_product > 0)) {
1526 $line->fk_product = $origin_line->fk_product;
1530 if (!
getDolGlobalString(
'MAIN_EXTRAFIELDS_DISABLED') && is_array($array_options) && count($array_options) > 0) {
1531 $line->array_options = $array_options;
1535 $this->lines[$num] = $line;
1548 public function update($user =
null, $notrigger = 0)
1555 if (isset($this->
ref)) {
1556 $this->
ref = trim($this->
ref);
1558 if (isset($this->entity)) {
1559 $this->entity = (int) $this->entity;
1561 if (isset($this->ref_customer)) {
1562 $this->ref_customer = trim($this->ref_customer);
1564 if (isset($this->socid)) {
1565 $this->socid = (int) $this->socid;
1567 if (isset($this->fk_user_author)) {
1568 $this->fk_user_author = (int) $this->fk_user_author;
1570 if (isset($this->fk_user_valid)) {
1571 $this->fk_user_valid = (int) $this->fk_user_valid;
1573 if (isset($this->fk_delivery_address)) {
1574 $this->fk_delivery_address = (int) $this->fk_delivery_address;
1576 if (isset($this->shipping_method_id)) {
1577 $this->shipping_method_id = (int) $this->shipping_method_id;
1579 if (isset($this->tracking_number)) {
1580 $this->tracking_number = trim($this->tracking_number);
1582 if (isset($this->statut)) {
1583 $this->statut = (int) $this->statut;
1585 if (isset($this->
status)) {
1588 if (isset($this->trueDepth)) {
1589 $this->trueDepth = trim($this->trueDepth);
1591 if (isset($this->trueWidth)) {
1592 $this->trueWidth = trim($this->trueWidth);
1594 if (isset($this->trueHeight)) {
1595 $this->trueHeight = trim($this->trueHeight);
1597 if (isset($this->size_units)) {
1598 $this->size_units = trim($this->size_units);
1600 if (isset($this->weight_units)) {
1601 $this->weight_units = (int) $this->weight_units;
1603 if (isset($this->trueWeight)) {
1604 $this->weight = trim((
string) $this->trueWeight);
1606 if (isset($this->note_private)) {
1607 $this->note_private = trim($this->note_private);
1609 if (isset($this->note_public)) {
1610 $this->note_public = trim($this->note_public);
1612 if (isset($this->model_pdf)) {
1613 $this->model_pdf = trim($this->model_pdf);
1615 if (!empty($this->date_expedition)) {
1616 $this->date_shipping = $this->date_expedition;
1623 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition SET";
1624 $sql .=
" ref = ".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1625 $sql .=
" ref_ext = ".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1626 $sql .=
" ref_customer = ".(isset($this->ref_customer) ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null").
",";
1627 $sql .=
" fk_soc = ".(isset($this->socid) ? ((int) $this->socid) :
"null").
",";
1628 $sql .=
" date_creation = ".(dol_strlen($this->date_creation) != 0 ?
"'".$this->db->idate($this->date_creation).
"'" :
'null').
",";
1629 $sql .=
" fk_user_author = ".(isset($this->fk_user_author) ? ((int) $this->fk_user_author) :
"null").
",";
1630 $sql .=
" date_valid = ".(dol_strlen($this->date_valid) != 0 ?
"'".$this->db->idate($this->date_valid).
"'" :
'null').
",";
1631 $sql .=
" fk_user_valid = ".(isset($this->fk_user_valid) ? ((int) $this->fk_user_valid) :
"null").
",";
1632 $sql .=
" date_expedition = ".(dol_strlen($this->date_shipping) != 0 ?
"'".$this->db->idate($this->date_shipping).
"'" :
'null').
",";
1633 $sql .=
" date_delivery = ".(dol_strlen($this->date_delivery) != 0 ?
"'".$this->db->idate($this->date_delivery).
"'" :
'null').
",";
1634 $sql .=
" fk_address = ".(isset($this->fk_delivery_address) ? ((int) $this->fk_delivery_address) :
"null").
",";
1635 $sql .=
" fk_shipping_method = ".((isset($this->shipping_method_id) && $this->shipping_method_id > 0) ? ((
int) $this->shipping_method_id) :
"null").
",";
1636 $sql .=
" tracking_number = ".(isset($this->tracking_number) ?
"'".$this->db->escape($this->tracking_number).
"'" :
"null").
",";
1637 $sql .=
" fk_statut = ".(isset($this->
status) ? ((int) $this->
status) :
"null").
",";
1638 $sql .=
" fk_projet = ".(isset($this->fk_project) ? ((int) $this->fk_project) :
"null").
",";
1639 $sql .=
" height = ".(($this->trueHeight !=
'') ? ((
float) $this->trueHeight) :
"null").
",";
1640 $sql .=
" width = ".(($this->trueWidth !=
'') ? ((
float) $this->trueWidth) :
"null").
",";
1641 $sql .=
" size_units = ".(isset($this->size_units) ? ((int) $this->size_units) :
"null").
",";
1642 $sql .=
" size = ".(($this->trueDepth !=
'') ? ((
float) $this->trueDepth) :
"null").
",";
1643 $sql .=
" weight_units = ".(isset($this->weight_units) ? ((int) $this->weight_units) :
"null").
",";
1644 $sql .=
" weight = ".(($this->trueWeight !=
'') ? ((
float) $this->trueWeight) :
"null").
",";
1645 $sql .=
" note_private = ".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1646 $sql .=
" note_public = ".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1647 $sql .=
" model_pdf = ".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1648 $sql .=
" entity = ".((int) $conf->entity);
1649 $sql .=
" WHERE rowid = ".((int) $this->
id);
1653 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1654 $resql = $this->db->query($sql);
1657 $this->errors[] =
"Error ".$this->db->lasterror();
1668 if (!$error && !$notrigger) {
1670 $result = $this->call_trigger(
'SHIPPING_MODIFY', $user);
1679 foreach ($this->errors as $errmsg) {
1680 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1681 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1683 $this->db->rollback();
1686 $this->db->commit();
1700 public function cancel($user, $notrigger = 0, $also_update_stock =
false)
1702 global $conf, $langs, $user;
1704 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1713 if (isset($this->linkedObjectsIds[
'delivery']) && count($this->linkedObjectsIds[
'delivery']) > 0) {
1714 $this->error =
'ErrorThereIsSomeDeliveries';
1718 if (!$error && !$notrigger) {
1720 $result = $this->call_trigger(
'SHIPPING_CANCEL', $user);
1730 (
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE') && $this->
status == self::STATUS_CLOSED && $also_update_stock));
1732 require_once DOL_DOCUMENT_ROOT.
"/product/stock/class/mouvementstock.class.php";
1734 $langs->load(
"agenda");
1738 $sql .=
" ed.fk_product";
1739 $sql .=
", ed.qty, ed.fk_entrepot, ed.rowid as expeditiondet_id";
1740 $sql .=
", SUM(".$this->db->ifsql(
"pa.rowid IS NOT NULL",
"1",
"0").
") as iskit";
1741 $sql .=
", ".$this->db->ifsql(
"pai.incdec IS NULL",
"1",
"pai.incdec").
" as incdec";
1742 $sql .=
" FROM ".$this->db->prefix().
"expeditiondet as ed";
1743 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pa ON pa.fk_product_pere = ed.fk_product";
1744 $sql .=
" LEFT JOIN ".$this->db->prefix().
"expeditiondet as edp ON edp.rowid = ed.fk_parent";
1745 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pai ON pai.fk_product_pere = edp.fk_product AND pai.fk_product_fils = ed.fk_product";
1746 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
1747 $sql .=
" GROUP BY ed.fk_product, ed.qty, ed.fk_entrepot, ed.rowid, pai.incdec";
1748 $sql .= $this->db->order(
"ed.rowid",
"DESC");
1750 dol_syslog(get_class($this).
"::delete select details", LOG_DEBUG);
1751 $resql = $this->db->query($sql);
1753 $cpt = $this->db->num_rows($resql);
1757 for ($i = 0; $i < $cpt; $i++) {
1758 dol_syslog(get_class($this).
"::delete movement index ".$i);
1759 $obj = $this->db->fetch_object($resql);
1760 $line_id = (int) $obj->expeditiondet_id;
1762 if ($can_update_stock && (empty($obj->iskit) ||
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) && !empty($obj->incdec)) {
1765 $mouvS->origin =
'';
1769 $lotArray = $shipmentlinebatch->fetchAll($obj->expeditiondet_id);
1770 if (!is_array($lotArray)) {
1772 $this->errors[] =
"Error ".$this->db->lasterror();
1776 if (empty($lotArray)) {
1780 $result = $mouvS->reception($user, $obj->fk_product, $obj->fk_entrepot, $obj->qty, 0, $langs->trans(
"ShipmentCanceledInDolibarr", $this->ref),
'',
'',
'',
'', 0,
'', 0, (empty($obj->iskit) ? 1 : 0));
1783 $this->errors = array_merge($this->errors, $mouvS->errors);
1789 foreach ($lotArray as $lot) {
1790 if (empty($lot->qty)) {
1793 $result = $mouvS->reception($user, $obj->fk_product, $obj->fk_entrepot, $lot->qty, 0, $langs->trans(
"ShipmentCanceledInDolibarr", $this->ref),
'',
'', (
string) $lot->batch,
'', 0,
'', 0, (empty($obj->iskit) ? 1 : 0));
1796 $this->errors = array_merge($this->errors, $mouvS->errors);
1809 $res = $shipment_line->fetch($line_id);
1811 $result = $shipment_line->delete($user);
1814 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1818 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1828 $this->errors[] =
"Error ".$this->db->lasterror();
1841 $sql =
"SELECT rowid FROM ".$this->db->prefix().
"expedition";
1842 $sql .=
" WHERE rowid = ".((int) $this->
id);
1844 if ($this->db->query($sql)) {
1845 if (!empty($this->origin) && $this->origin_id > 0) {
1848 '@phan-var-force Facture|Commande $origin_object';
1859 $this->db->commit();
1863 if (!empty($conf->expedition->dir_output)) {
1864 $dir = $conf->expedition->dir_output.
'/sending/'.$ref;
1865 $file = $dir.
'/'.$ref.
'.pdf';
1866 if (file_exists($file)) {
1871 if (file_exists($dir)) {
1873 $this->error = $langs->trans(
"ErrorCanNotDeleteDir", $dir);
1881 $this->error = $this->db->lasterror().
" - sql=$sql";
1882 $this->db->rollback();
1886 $this->db->rollback();
1890 $this->db->rollback();
1904 public function delete($user =
null, $notrigger = 0, $also_update_stock =
false)
1906 global $conf, $langs;
1912 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1921 if (isset($this->linkedObjectsIds[
'delivery']) && count($this->linkedObjectsIds[
'delivery']) > 0) {
1922 $this->error =
'ErrorThereIsSomeDeliveries';
1926 if (!$error && !$notrigger) {
1928 $result = $this->call_trigger(
'SHIPPING_DELETE', $user);
1938 (
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE') && $this->
status == self::STATUS_CLOSED && $also_update_stock));
1940 require_once DOL_DOCUMENT_ROOT.
"/product/stock/class/mouvementstock.class.php";
1942 $langs->load(
"agenda");
1949 $sql .=
" ed.fk_product";
1950 $sql .=
", ed.qty, ed.fk_entrepot, ed.rowid as expeditiondet_id";
1951 $sql .=
", SUM(".$this->db->ifsql(
"pa.rowid IS NOT NULL",
"1",
"0").
") as iskit";
1952 $sql .=
", ".$this->db->ifsql(
"pai.incdec IS NULL",
"1",
"pai.incdec").
" as incdec";
1953 $sql .=
" FROM ".$this->db->prefix().
"expeditiondet as ed";
1954 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pa ON pa.fk_product_pere = ed.fk_product";
1955 $sql .=
" LEFT JOIN ".$this->db->prefix().
"expeditiondet as edp ON edp.rowid = ed.fk_parent";
1956 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pai ON pai.fk_product_pere = edp.fk_product AND pai.fk_product_fils = ed.fk_product";
1957 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
1958 $sql .=
" GROUP BY ed.fk_product, ed.qty, ed.fk_entrepot, ed.rowid, pai.incdec";
1959 $sql .= $this->db->order(
"ed.rowid",
"DESC");
1961 dol_syslog(get_class($this).
"::delete select details", LOG_DEBUG);
1962 $resql = $this->db->query($sql);
1964 $cpt = $this->db->num_rows($resql);
1965 for ($i = 0; $i < $cpt; $i++) {
1966 dol_syslog(get_class($this).
"::delete movement index ".$i);
1967 $obj = $this->db->fetch_object($resql);
1968 $line_id = (int) $obj->expeditiondet_id;
1970 if ($can_update_stock && (empty($obj->iskit) ||
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) && !empty($obj->incdec)) {
1973 $mouvS->origin =
'';
1975 $lotArray = $shipmentlinebatch->fetchAll($line_id);
1976 if (!is_array($lotArray)) {
1978 $this->errors[] =
"Error ".$this->db->lasterror();
1980 if (empty($lotArray)) {
1984 $result = $mouvS->reception($user, $obj->fk_product, $obj->fk_entrepot, $obj->qty, 0, $langs->trans(
"ShipmentDeletedInDolibarr", $this->ref),
'',
'',
'',
'', 0,
'', 0, (empty($obj->iskit) ? 1 : 0));
1987 $this->errors = array_merge($this->errors, $mouvS->errors);
1993 foreach ($lotArray as $lot) {
1994 if (empty($lot->qty)) {
1997 $result = $mouvS->reception($user, $obj->fk_product, $obj->fk_entrepot, $lot->qty, 0, $langs->trans(
"ShipmentDeletedInDolibarr", $this->ref),
'',
'', (
string) $lot->batch,
'', 0,
'', 0, (empty($obj->iskit) ? 1 : 0));
2000 $this->errors = array_merge($this->errors, $mouvS->errors);
2013 $res = $shipment_line->fetch($line_id);
2015 $result = $shipment_line->delete($user);
2018 $this->errors[] =
"Error ".$shipment_line->errorsToString();
2022 $this->errors[] =
"Error ".$shipment_line->errorsToString();
2032 $this->errors[] =
"Error ".$this->db->lasterror();
2057 $sql =
"DELETE FROM ".$this->db->prefix().
"expedition";
2058 $sql .=
" WHERE rowid = ".((int) $this->
id);
2060 if ($this->db->query($sql)) {
2061 if (!empty($this->origin) && $this->origin_id > 0) {
2064 '@phan-var-force Facture|Commande $origin_object';
2074 $this->db->commit();
2082 if (!empty($conf->expedition->dir_output) && !empty($ref)) {
2083 $dir = $conf->expedition->dir_output .
'/sending/' . $ref;
2084 $file = $dir .
'/' . $ref .
'.pdf';
2085 if (file_exists($file)) {
2090 if (file_exists($dir)) {
2092 $this->error = $langs->trans(
"ErrorCanNotDeleteDir", $dir);
2100 $this->error = $this->db->lasterror().
" - sql=$sql";
2101 $this->db->rollback();
2105 $this->db->rollback();
2109 $this->db->rollback();
2125 $this->lines = array();
2130 $sql =
"SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.product_type, cd.fk_unit";
2131 $sql .=
", cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva";
2132 $sql .=
", cd.fk_remise_except, cd.fk_product_fournisseur_price as fk_fournprice";
2133 $sql .=
", cd.vat_src_code, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.info_bits, cd.price, cd.subprice, cd.remise_percent,cd.buy_price_ht as pa_ht";
2134 $sql .=
", cd.fk_multicurrency, cd.multicurrency_code, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc, cd.rang, cd.date_start, cd.date_end, cd.special_code";
2135 $sql .=
", ed.rowid as line_id, ed.qty as qty_shipped, ed.fk_element, ed.fk_elementdet, ed.element_type, ed.fk_entrepot, ed.extraparams";
2136 $sql .=
", p.ref as product_ref, p.label as product_label, p.fk_product_type, p.barcode as product_barcode";
2137 $sql .=
", p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units";
2138 $sql .=
", p.surface, p.surface_units, p.volume, p.volume_units, p.tosell as product_tosell, p.tobuy as product_tobuy";
2139 $sql .=
", p.tobatch as product_tobatch, p.stockable_product";
2140 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expeditiondet as ed, ".MAIN_DB_PREFIX.
"commandedet as cd";
2141 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON p.rowid = cd.fk_product";
2142 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
2143 $sql .=
" AND ed.fk_elementdet = cd.rowid";
2144 $sql .=
" ORDER BY cd.rang, ed.fk_elementdet";
2146 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
2147 $resql = $this->db->query($sql);
2149 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2151 $num = $this->db->num_rows($resql);
2157 $this->total_ht = 0;
2158 $this->total_tva = 0;
2159 $this->total_ttc = 0;
2160 $this->total_localtax1 = 0;
2161 $this->total_localtax2 = 0;
2163 $this->multicurrency_total_ht = 0;
2164 $this->multicurrency_total_tva = 0;
2165 $this->multicurrency_total_ttc = 0;
2171 $obj = $this->db->fetch_object($resql);
2173 if ($originline > 0 && $originline == $obj->fk_elementdet) {
2175 $line->entrepot_id = 0;
2176 $line->qty_shipped += $obj->qty_shipped;
2179 $line->entrepot_id = $obj->fk_entrepot;
2180 $line->qty_shipped = $obj->qty_shipped;
2184 $detail_entrepot->entrepot_id = $obj->fk_entrepot;
2185 $detail_entrepot->qty_shipped = $obj->qty_shipped;
2186 $detail_entrepot->line_id = $obj->line_id;
2187 $line->details_entrepot[] = $detail_entrepot;
2189 $line->line_id = $obj->line_id;
2190 $line->rowid = $obj->line_id;
2191 $line->id = $obj->line_id;
2193 $line->fk_origin =
'orderline';
2195 $line->fk_element = $obj->fk_element;
2196 $line->origin_id = $obj->fk_element;
2197 $line->fk_elementdet = $obj->fk_elementdet;
2198 $line->origin_line_id = $obj->fk_elementdet;
2199 $line->element_type = $obj->element_type;
2201 $line->fk_expedition = $this->id;
2203 $line->stockable_product = $obj->stockable_product;
2204 $line->product_type = $obj->product_type;
2205 $line->fk_product = $obj->fk_product;
2206 $line->fk_product_type = $obj->fk_product_type;
2207 $line->ref = $obj->product_ref;
2208 $line->product_ref = $obj->product_ref;
2209 $line->product_label = $obj->product_label;
2210 $line->libelle = $obj->product_label;
2211 $line->product_barcode = $obj->product_barcode;
2212 $line->product_tosell = $obj->product_tosell;
2213 $line->product_tobuy = $obj->product_tobuy;
2214 $line->product_tobatch = $obj->product_tobatch;
2215 $line->fk_fournprice = $obj->fk_fournprice;
2216 $line->label = $obj->custom_label;
2217 $line->description = $obj->description;
2218 $line->qty_asked = $obj->qty_asked;
2219 $line->rang = $obj->rang;
2220 $line->weight = $obj->weight;
2221 $line->weight_units = $obj->weight_units;
2222 $line->length = $obj->length;
2223 $line->length_units = $obj->length_units;
2224 $line->width = $obj->width;
2225 $line->width_units = $obj->width_units;
2226 $line->height = $obj->height;
2227 $line->height_units = $obj->height_units;
2228 $line->surface = $obj->surface;
2229 $line->surface_units = $obj->surface_units;
2230 $line->volume = $obj->volume;
2231 $line->volume_units = $obj->volume_units;
2232 $line->stockable_product = $obj->stockable_product;
2233 $line->fk_unit = $obj->fk_unit;
2235 $line->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2237 $line->pa_ht = $obj->pa_ht;
2240 $localtax_array = array(0 => $obj->localtax1_type, 1 => $obj->localtax1_tx, 2 => $obj->localtax2_type, 3 => $obj->localtax2_tx);
2241 $localtax1_tx =
get_localtax($obj->tva_tx, 1, $this->thirdparty);
2242 $localtax2_tx =
get_localtax($obj->tva_tx, 2, $this->thirdparty);
2245 $tabprice =
calcul_price_total($obj->qty_shipped, $obj->subprice, $obj->remise_percent, $obj->tva_tx, $localtax1_tx, $localtax2_tx, 0,
'HT', $obj->info_bits, $obj->fk_product_type,
$mysoc, $localtax_array);
2246 $line->desc = $obj->description;
2247 $line->qty = $line->qty_shipped;
2248 $line->total_ht = (float) $tabprice[0];
2249 $line->total_localtax1 = (float) $tabprice[9];
2250 $line->total_localtax2 = (float) $tabprice[10];
2251 $line->total_ttc = (float) $tabprice[2];
2252 $line->total_tva = (float) $tabprice[1];
2253 $line->vat_src_code = $obj->vat_src_code;
2254 $line->tva_tx = $obj->tva_tx;
2255 $line->localtax1_tx = $obj->localtax1_tx;
2256 $line->localtax2_tx = $obj->localtax2_tx;
2257 $line->info_bits = $obj->info_bits;
2258 $line->price = $obj->price;
2259 $line->subprice = $obj->subprice;
2260 $line->fk_remise_except = $obj->fk_remise_except;
2261 $line->remise_percent = $obj->remise_percent;
2263 $this->total_ht += $tabprice[0];
2264 $this->total_tva += $tabprice[1];
2265 $this->total_ttc += $tabprice[2];
2266 $this->total_localtax1 += $tabprice[9];
2267 $this->total_localtax2 += $tabprice[10];
2269 $line->date_start = $this->db->jdate($obj->date_start);
2270 $line->date_end = $this->db->jdate($obj->date_end);
2272 $line->special_code = $obj->special_code;
2275 $this->fk_multicurrency = $obj->fk_multicurrency;
2276 $this->multicurrency_code = $obj->multicurrency_code;
2277 $line->multicurrency_subprice = $obj->multicurrency_subprice;
2278 $line->multicurrency_total_ht = $obj->multicurrency_total_ht;
2279 $line->multicurrency_total_tva = $obj->multicurrency_total_tva;
2280 $line->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2282 $this->multicurrency_total_ht += $obj->multicurrency_total_ht;
2283 $this->multicurrency_total_tva += $obj->multicurrency_total_tva;
2284 $this->multicurrency_total_ttc += $obj->multicurrency_total_ttc;
2286 if ($originline != $obj->fk_elementdet) {
2287 $line->detail_batch = array();
2291 if (
isModEnabled(
'productbatch') && $obj->line_id > 0 && $obj->product_tobatch > 0) {
2292 $newdetailbatch = $shipmentlinebatch->fetchAll($obj->line_id, $obj->fk_product);
2294 if (is_array($newdetailbatch)) {
2295 if ($originline != $obj->fk_elementdet) {
2296 $line->detail_batch = $newdetailbatch;
2298 $line->detail_batch = array_merge($line->detail_batch, $newdetailbatch);
2305 $detail_children = array();
2306 $line_child_list = array();
2307 $res = $line->findAllChild($line->id, $line_child_list, 1);
2309 foreach ($line_child_list as $child_line) {
2310 foreach ($child_line as $child_obj) {
2311 $child_product_id = (int) $child_obj->fk_product;
2312 $child_warehouse_id = (int) $child_obj->fk_warehouse;
2314 if ($child_warehouse_id > 0) {
2316 if (!isset($detail_children[$child_product_id])) {
2317 $detail_children[$child_product_id] = array();
2319 if (!isset($detail_children[$child_product_id][$child_warehouse_id])) {
2320 $detail_children[$child_product_id][$child_warehouse_id] = 0;
2322 $detail_children[$child_product_id][$child_warehouse_id] += $child_obj->qty;
2327 $line->detail_children = $detail_children;
2330 $line->fetch_optionals();
2332 if ($originline != $obj->fk_elementdet) {
2333 $this->lines[$lineindex] = $line;
2336 $line->total_ht += $tabprice[0];
2337 $line->total_localtax1 += $tabprice[9];
2338 $line->total_localtax2 += $tabprice[10];
2339 $line->total_ttc += $tabprice[2];
2340 $line->total_tva += $tabprice[1];
2344 $originline = $obj->fk_elementdet;
2346 $this->db->free($resql);
2349 $this->error = $this->db->error();
2366 $this->lines = array();
2368 $sql =
'SELECT ed.rowid, ed.fk_expedition, ed.fk_entrepot, ed.fk_product, ed.fk_unit, ed.description, ed.fk_elementdet, ed.fk_element, ed.element_type, ed.qty, ed.rang';
2369 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element_line.
' as ed';
2370 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON (p.rowid = ed.fk_product)';
2371 $sql .=
' WHERE ed.fk_expedition = '.((int) $this->
id);
2372 $sql .=
' ORDER BY ed.rang, ed.rowid';
2374 dol_syslog(get_class($this).
"::fetch_lines_free", LOG_DEBUG);
2375 $result = $this->db->query($sql);
2377 $num = $this->db->num_rows($result);
2381 $objp = $this->db->fetch_object($result);
2385 $line->rowid = $objp->rowid;
2386 $line->id = $objp->rowid;
2387 $line->fk_expedition = $this->id;
2388 $line->description = $objp->description;
2389 $line->qty = $objp->qty;
2390 $line->fk_entrepot = $objp->fk_entrepot;
2391 $line->fk_product = $objp->fk_product;
2392 $line->rang = $objp->rang;
2393 $line->fk_element = $objp->fk_element;
2394 $line->fk_unit = $objp->fk_unit;
2395 $line->fk_elementdet = $objp->fk_elementdet;
2396 $line->fk_element_type = $objp->element_type;
2397 $line->fetch_optionals();
2399 $this->lines[$i] = $line;
2404 $this->db->free($result);
2408 $this->error = $this->db->error();
2434 if ($this->
status == self::STATUS_DRAFT) {
2440 $line->fetch($lineid);
2442 if ($this->
id > 0 && (
int) $line->fk_expedition !== (
int) $this->id) {
2443 $this->db->rollback();
2444 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
2448 if ($line->delete($user) > 0) {
2451 $this->db->commit();
2454 $this->db->rollback();
2458 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
2472 global $conf, $langs;
2474 $langs->load(
'sendings');
2476 $nofetch = !empty($params[
'nofetch']);
2479 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Shipment").
'</u>';
2480 if (isset($this->
status)) {
2481 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
2483 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2484 $datas[
'refcustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '.($this->ref_customer ? $this->ref_customer : $this->ref_client);
2486 $langs->load(
'companies');
2487 if (empty($this->thirdparty)) {
2490 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
2507 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $notooltip = 0, $save_lastsearch_value = -1)
2509 global $langs, $hookmanager;
2514 'objecttype' => $this->element,
2515 'option' => $option,
2518 $classfortooltip =
'classfortooltip';
2521 $classfortooltip =
'classforajaxtooltip';
2522 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2528 $url = DOL_URL_ROOT.
'/expedition/card.php?id='.$this->id;
2534 if ($option !==
'nolink') {
2536 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2537 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2538 $add_save_lastsearch_values = 1;
2540 if ($add_save_lastsearch_values) {
2541 $url .=
'&save_lastsearch_values=1';
2546 if (empty($notooltip)) {
2548 $label = $langs->trans(
"Shipment");
2549 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2551 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2552 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2555 $linkstart =
'<a href="'.$url.
'"';
2556 $linkstart .= $linkclose.
'>';
2559 $result .= $linkstart;
2561 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'"'), 0, 0, $notooltip ? 0 : 1);
2563 if ($withpicto != 2) {
2564 $result .= $this->ref;
2566 $result .= $linkend;
2568 $hookmanager->initHooks(array($this->element .
'dao'));
2569 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2570 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2572 $result = $hookmanager->resPrint;
2574 $result .= $hookmanager->resPrint;
2603 $labelStatus = $langs->transnoentitiesnoconv($this->labelStatus[$status]);
2604 $labelStatusShort = $langs->transnoentitiesnoconv($this->labelStatusShort[$status]);
2606 $statusType =
'status'.$status;
2607 if ($status == self::STATUS_VALIDATED) {
2608 $statusType =
'status4';
2610 if ($status == self::STATUS_CLOSED) {
2611 $statusType =
'status6';
2613 if ($status == self::STATUS_CANCELED) {
2614 $statusType =
'status9';
2618 $status_label = $this->signed_status ? $labelStatus . $signed_label : $labelStatus;
2619 $status_label_short = $this->signed_status ? $labelStatusShort . $signed_label : $labelStatusShort;
2621 return dolGetStatus($status_label, $status_label_short,
'', $statusType, $mode);
2633 global $langs, $conf;
2635 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2637 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2638 $return .=
'<div class="info-box info-box-sm">';
2639 $return .=
'<div class="info-box-icon bg-infobox-action">';
2641 $return .=
'</div>';
2642 $return .=
'<div class="info-box-content">';
2643 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->
getNomUrl() .
'</span>';
2644 if ($selected >= 0) {
2645 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2647 $return .=
'<br><div class="info-box-ref tdoverflowmax150">'.$this->thirdparty->getNomUrl(1).
'</div>';
2648 $return .=
'<div class="info-box-ref amount">'.price($this->total_ht, 0, $langs, 0, -1, -1,
getDolCurrency()).
' '.$langs->trans(
'HT').
'</div>';
2649 $return .=
'<div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
2650 $return .=
'</div>';
2651 $return .=
'</div>';
2652 $return .=
'</div>';
2670 dol_syslog(get_class($this).
"::initAsSpecimen");
2673 $order->initAsSpecimen();
2677 $this->
ref =
'SPECIMEN';
2678 $this->specimen = 1;
2680 $this->livraison_id = 0;
2682 $this->date_creation = $now;
2683 $this->date_valid = $now;
2684 $this->date_delivery = $now + 24 * 3600;
2685 $this->date_expedition = $now + 24 * 3600;
2687 $this->entrepot_id = 0;
2688 $this->fk_delivery_address = 0;
2691 $this->commande_id = 0;
2692 $this->commande = $order;
2694 $this->origin_id = 1;
2695 $this->origin_type =
'commande';
2697 $this->note_private =
'Private note';
2698 $this->note_public =
'Public note';
2702 while ($xnbp < $nbp) {
2704 $line->product_desc = $langs->trans(
"Description").
" ".$xnbp;
2705 $line->product_label = $langs->trans(
"Description").
" ".$xnbp;
2707 $line->qty_asked = 5;
2708 $line->qty_shipped = 4;
2709 $line->fk_product = $this->commande->lines[$xnbp]->fk_product;
2711 $line->weight = 1.123456;
2712 $line->weight_units = 0;
2714 $line->volume = 2.34567;
2715 $line->volume_unit = 0;
2717 $this->lines[] = $line;
2748 if ($user->hasRight(
'expedition',
'creer')) {
2749 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
2750 $sql .=
" SET date_delivery = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2751 $sql .=
" WHERE rowid = ".((int) $this->
id);
2753 dol_syslog(get_class($this).
"::setDeliveryDate", LOG_DEBUG);
2754 $resql = $this->db->query($sql);
2756 $this->date_delivery = $delivery_date;
2759 $this->error = $this->db->error();
2776 if ($user->hasRight(
'expedition',
'creer')) {
2777 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
2778 $sql .=
" SET date_expedition = ".($shipping_date ?
"'".$this->db->idate($shipping_date).
"'" :
'null');
2779 $sql .=
" WHERE rowid = ".((int) $this->
id);
2781 dol_syslog(get_class($this).
"::setShippingDate", LOG_DEBUG);
2782 $resql = $this->db->query($sql);
2784 $this->date_shipping = $shipping_date;
2787 $this->error = $this->db->error();
2807 $sql =
"SELECT em.rowid, em.code, em.libelle as label";
2808 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2809 $sql .=
" WHERE em.active = 1";
2810 $sql .=
" ORDER BY em.libelle ASC";
2812 $resql = $this->db->query($sql);
2814 while ($obj = $this->db->fetch_object($resql)) {
2815 $label = $langs->trans(
'SendingMethod'.$obj->code);
2816 $this->meths[(int) $obj->rowid] = ($label !=
'SendingMethod'.$obj->code ? $label : $obj->label);
2833 $this->listmeths = [];
2836 $sql =
"SELECT em.rowid, em.code, em.libelle as label, em.description, em.tracking, em.active";
2837 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2839 $sql .=
" WHERE em.rowid=".((int) $id);
2842 $resql = $this->db->query($sql);
2844 while ($obj = $this->db->fetch_object($resql)) {
2845 $label = $langs->trans(
'SendingMethod'.$obj->code);
2846 $this->listmeths[$i] = [
2847 'rowid' => (int) $obj->rowid,
2848 'code' => $obj->code,
2849 'libelle' => ($label !=
'SendingMethod'.$obj->code ? $label : $obj->label),
2850 'description' => $obj->description,
2851 'tracking' => $obj->tracking,
2852 'active' => (
int) $obj->active,
2868 if (!empty($this->shipping_method_id)) {
2869 $sql =
"SELECT em.code, em.tracking";
2870 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2871 $sql .=
" WHERE em.rowid = ".((int) $this->shipping_method_id);
2873 $resql = $this->db->query($sql);
2875 if ($obj = $this->db->fetch_object($resql)) {
2876 $tracking = (string) $obj->tracking;
2881 if (!empty($tracking) && !empty($value)) {
2882 $url = str_replace(
'{TRACKID}', $value, $tracking);
2883 $this->tracking_url = sprintf(
'<a target="_blank" rel="noopener noreferrer" href="%s">%s</a>', $url, $value);
2885 $this->tracking_url = $value;
2896 global $langs, $user;
2901 if ($this->
status == self::STATUS_CLOSED) {
2908 if (empty($this->date_shipping)) {
2909 $sql .=
", date_expedition = '".$this->db->escape($this->db->idate(
dol_now())).
"'";
2911 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut > 0";
2912 $sql .=
" AND fk_statut <> ".self::STATUS_CLOSED;
2914 $resql = $this->db->query($sql);
2915 if ($resql && $this->db->affected_rows($resql) <= 0) {
2918 $this->db->rollback();
2919 dol_syslog(get_class($this).
"::setClosed shipment ".$this->
id.
" is not validated, nothing done", LOG_WARNING);
2924 if ($this->origin_type ==
'commande' && $this->origin_id > 0) {
2926 $order->fetch($this->origin_id);
2928 $order->loadExpeditions(self::STATUS_CLOSED);
2930 $shipments_match_order = 1;
2931 foreach ($order->lines as $line) {
2932 $lineid = $line->id;
2934 $expQty = isset($order->expeditions[$lineid]) ? $order->expeditions[$lineid] : 0;
2935 if (($line->product_type == 0 ||
getDolGlobalString(
'STOCK_SUPPORTS_SERVICES')) && $expQty != $qty) {
2936 $shipments_match_order = 0;
2937 $text =
'Qty for order line id '.$lineid.
' is '.$qty.
'. However in the shipments with status Expedition::STATUS_CLOSED='.self::STATUS_CLOSED.
' we have qty = '.$expQty.
', so we can t close order';
2942 if ($shipments_match_order) {
2943 dol_syslog(
"Qty for the ".count($order->lines).
" lines of the origin order is same than qty for lines in the shipment we close (shipments_match_order is true), with new status Expedition::STATUS_CLOSED=".self::STATUS_CLOSED.
', so we close order');
2945 $order->cloture($user, 0, 0);
2963 $result = $this->call_trigger(
'SHIPPING_CLOSED', $user);
2974 $this->db->commit();
2980 $this->db->rollback();
2999 require_once DOL_DOCUMENT_ROOT .
'/product/stock/class/mouvementstock.class.php';
3001 $langs->load(
"agenda");
3005 $sql .=
" ed.rowid as edid, ed.fk_product, ed.qty, ed.fk_entrepot";
3006 $sql .=
", cd.rowid as cdid";
3007 $sql .=
", cd.subprice";
3008 $sql .=
", edb.rowid as edbrowid, edb.eatby, edb.sellby, edb.batch, edb.qty as edbqty, edb.fk_origin_stock";
3010 $sql .=
" FROM " . $this->db->prefix() .
"expeditiondet as ed";
3011 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"commandedet as cd ON cd.rowid = ed.fk_elementdet";
3012 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"expeditiondet_batch as edb on edb.fk_expeditiondet = ed.rowid";
3013 $sql .=
" INNER JOIN " . $this->db->prefix() .
"expedition as e ON ed.fk_expedition = e.rowid";
3014 $sql .=
" WHERE ed.fk_expedition = " . ((int) $this->
id);
3017 dol_syslog(get_class($this) .
"::valid select details", LOG_DEBUG);
3018 $resql = $this->db->query($sql);
3020 $cpt = $this->db->num_rows($resql);
3021 for ($i = 0; $i < $cpt; $i++) {
3022 $obj = $this->db->fetch_object($resql);
3023 if (empty($obj->edbrowid)) {
3026 $qty = $obj->edbqty;
3028 if ($qty <= 0 || ($qty < 0 && !
getDolGlobalInt(
'SHIPMENT_ALLOW_NEGATIVE_QTY'))) {
3031 dol_syslog(get_class($this) .
"::valid movement index " . $i .
" ed.rowid=" . $obj->edid .
" edb.rowid=" . $obj->edbrowid);
3034 $mouvS->origin = &$this;
3035 $mouvS->setOrigin($this->element, $this->
id, $obj->cdid, $obj->edid);
3037 if (empty($obj->edbrowid)) {
3041 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, $qty, $obj->subprice, $langs->trans($labelmovement, $obj->ref));
3051 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, $qty, $obj->subprice, $langs->trans($labelmovement, $obj->ref),
'', $this->db->jdate($obj->eatby), $this->db->jdate($obj->sellby), $obj->batch, $obj->fk_origin_stock);
3061 $sqldelete =
"DELETE FROM ".$this->db->prefix().
"product_stock WHERE reel = 0 AND rowid NOT IN (SELECT fk_product_stock FROM ".$this->db->prefix().
"product_batch as pb)";
3062 $resqldelete = $this->db->query($sqldelete);
3066 $this->error = $this->db->lasterror();
3067 $this->errors[] = $this->db->lasterror();
3090 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'expedition SET billed = 1';
3091 $sql .=
" WHERE rowid = ".((int) $this->
id).
' AND fk_statut > 0';
3093 $resql = $this->db->query($sql);
3098 $result = $this->call_trigger(
'SHIPPING_BILLED', $user);
3105 $this->errors[] = $this->db->lasterror;
3108 if (empty($error)) {
3109 $this->db->commit();
3112 $this->db->rollback();
3127 if ($this->
status <= self::STATUS_DRAFT) {
3131 return $this->
setStatusCommon($user, self::STATUS_DRAFT, $notrigger,
'SHIPMENT_UNVALIDATE');
3141 global $langs, $user;
3146 if ($this->
status == self::STATUS_VALIDATED) {
3152 $oldbilled = $this->billed;
3154 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'expedition SET fk_statut = 1';
3157 $resql = $this->db->query($sql);
3158 if ($resql && $this->db->affected_rows($resql) <= 0) {
3160 $this->db->rollback();
3161 $langs->load(
"sendings");
3162 $this->error = $langs->trans(
"StatusOfRefMustBe", $this->
ref, $langs->transnoentitiesnoconv(
"StatusSendingProcessedShort"));
3163 $this->errors[] = $this->error;
3173 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
3175 $langs->load(
"agenda");
3180 $sql =
"SELECT ed.fk_product, cd.subprice,";
3181 $sql .=
" ed.rowid, ed.qty, ed.fk_entrepot,";
3182 $sql .=
" edb.rowid as edbrowid, edb.eatby, edb.sellby, edb.batch, edb.qty as edbqty, edb.fk_origin_stock";
3183 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expeditiondet as ed";
3184 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commandedet as cd ON cd.rowid = ed.fk_elementdet";
3185 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"expeditiondet_batch as edb on edb.fk_expeditiondet = ed.rowid";
3186 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
3188 dol_syslog(get_class($this).
"::valid select details", LOG_DEBUG);
3189 $resql = $this->db->query($sql);
3191 $cpt = $this->db->num_rows($resql);
3192 for ($i = 0; $i < $cpt; $i++) {
3193 $obj = $this->db->fetch_object($resql);
3194 if (empty($obj->edbrowid)) {
3197 $qty = $obj->edbqty;
3202 dol_syslog(get_class($this).
"::reopen expedition movement index ".$i.
" ed.rowid=".$obj->rowid.
" edb.rowid=".$obj->edbrowid);
3206 $mouvS->origin = &$this;
3207 $mouvS->setOrigin($this->element, $this->
id);
3209 if (empty($obj->edbrowid)) {
3213 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, -$qty, $obj->subprice, $langs->trans(
"ShipmentUnClassifyCloseddInDolibarr", $this->ref));
3223 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, -$qty, $obj->subprice, $langs->trans(
"ShipmentUnClassifyCloseddInDolibarr", $this->ref),
'',
'',
'', $obj->batch, $obj->fk_origin_stock);
3232 $this->error = $this->db->lasterror();
3239 $result = $this->call_trigger(
'SHIPPING_REOPEN', $user);
3246 $this->errors[] = $this->db->lasterror();
3250 $this->db->commit();
3255 $this->billed = $oldbilled;
3256 $this->db->rollback();
3272 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3274 $outputlangs->load(
"products");
3279 if (!empty($this->model_pdf)) {
3280 $modele = $this->model_pdf;
3286 $modelpath =
"core/modules/expedition/doc/";
3290 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
Class to manage customers orders.
const STATUS_SHIPMENTONPROCESS
Shipment on process.
const STATUS_VALIDATED
Validated status.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
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.
setStatut($status, $elementId=null, $elementType='', $trigkey='', $fieldstatus='')
Set status of an object.
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
updateRangOfLine($rowid, $rang)
Update position of line (rang)
deleteExtraFields()
Delete all extra fields values for the current object.
setStatusCommon($user, $status, $notrigger=0, $triggercode='')
Set to a status.
fetchObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $clause='OR', $alsosametype=1, $orderby='sourcetype', $loadalsoobjects=1)
Fetch array of objects linked to current object (object of enabled modules only).
errorsToString()
Method to output saved errors.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
fetch_origin()
Read linked origin object.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
delete_linked_contact($source='', $code='')
Delete all links between an object $this and all its contacts in llx_element_contact.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Class to manage receptions.
Class to manage Dolibarr database access.
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $notooltip=0, $save_lastsearch_value=-1)
Return clickable link of object (with eventually picto)
addline_batch($dbatch, $array_options=[], $origin_line=null)
Add a shipment line with batch record.
create_delivery($user)
Create a delivery receipt from a shipment.
setDraft($user, $notrigger=0)
Set draft status.
const STATUS_SHIPMENT_IN_PROGRESS
Expedition in progress -> package exit the warehouse and is now in the truck or into the hand of the ...
getUrlTrackingStatus($value='')
Forge an set tracking url.
setClosed()
Classify the shipping as closed (this records also the stock movement)
__construct($db)
Constructor.
create_line($entrepot_id, $origin_line_id, $qty, $rang=0, $array_options=[], $parent_line_id=0, $product_id=0)
Create a expedition line.
addline($entrepot_id, $id, $qty, $array_options=[], $fk_product=0, $fk_parent=0)
Add an expedition line.
create($user, $notrigger=0)
Create expedition en base.
LibStatut($status, $mode)
Return label of a status.
setBilled()
Classify the shipping as invoiced (used for example by trigger when WORKFLOW_SHIPPING_CLASSIFY_BILLED...
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
getTooltipContentArray($params)
getTooltipContentArray
addlinefree($qty, $element_type, $fk_product, $fk_unit, $rang, $description, $fk_parent, $array_options=[])
Add a simple expedition line.
setDeliveryDate($user, $delivery_date)
Set the planned delivery date.
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
setShippingDate($user, $shipping_date)
Set the shipping date.
const STATUS_DRAFT
Draft status.
const STATUS_CANCELED
Canceled status.
getLibStatut($mode=0)
Return status label.
set_date_livraison($user, $delivery_date)
Set delivery date.
initAsSpecimen()
Initialise an instance with random values.
updatelinefree($rowid, $qty, $element_type, $fk_product, $fk_unit, $rang, $description, $fk_parent, $notrigger, $array_options=array())
Update a simple expedition line.
const STATUS_CLOSED
Closed status -> parcel was received by customer / end of process prev status : validated or shipment...
const STATUS_VALIDATED
Validated status -> parcel is ready to be sent prev status : draft next status : closed or shipment_i...
create_line_batch($line_ext, $array_options=[])
Create the detail of the expedition line.
manageStockMvtOnEvt($user, $labelmovement='ShipmentClassifyClosedInDolibarr')
Manage Stock MVt onb Close or valid Shipment.
valid($user, $notrigger=0)
Validate object and update stock if option enabled.
update($user=null, $notrigger=0)
Update database.
fetch_lines_free()
Load lines of simple shipment.
fetch_delivery_methods()
Fetch deliveries method and return an array.
fetch($id, $ref='', $ref_ext='', $notused='')
Get object and lines from database.
reOpen()
Classify the shipping as validated/opened.
deleteLine($user, $lineid)
Delete detail line.
getLinesArray()
Create an array of shipment lines.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
list_delivery_methods($id=0)
Fetch all deliveries method and return an array.
Class to manage lines of shipment.
CRUD class for batch number management within shipment.
Class to manage stock movements.
Class to manage order lines.
Class to manage products or services.
const TYPE_SERVICE
Service.
Manage record for batch number management.
Class to manage third parties objects (customers, suppliers, prospects...)
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...
getLibSignedStatus(int $mode=0)
Returns the label for signed status.
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_now($mode='gmt')
Return date for now.
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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getDolCurrency()
Return the main currency ('EUR', 'USD', ...)
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...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
if(getDolGlobalString( 'TAKEPOS_SHOW_CUSTOMER')) print $langs trans('Date')." left Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date
$conf db user
Active Directory does not allow anonymous connections.