39require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
40require_once DOL_DOCUMENT_ROOT.
"/expedition/class/expeditionligne.class.php";
41require_once DOL_DOCUMENT_ROOT.
'/core/class/commonincoterm.class.php';
42if (isModEnabled(
"propal")) {
43 require_once DOL_DOCUMENT_ROOT.
'/comm/propal/class/propal.class.php';
45if (isModEnabled(
'order')) {
46 require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expeditionlinebatch.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/core/class/commonsignedobject.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/subtotals/class/commonsubtotal.class.php';
60 use CommonSignedObject;
66 public $element =
"shipping";
71 public $fk_element =
"fk_expedition";
76 public $table_element =
"expedition";
81 public $table_element_line =
"expeditiondet";
86 public $picto =
'dolly';
92 public $fields = array();
97 public $user_author_id;
102 public $fk_user_author;
107 public $fk_user_valid;
124 public $ref_customer;
134 public $tracking_number;
139 public $tracking_url;
152 public $weight_units;
168 public $height_units;
185 public $livraison_id;
190 public $multicurrency_subprice;
220 public $date_delivery;
234 public $date_expedition;
240 public $date_shipping;
269 public $lines = array();
275 public $fk_multicurrency;
280 public $multicurrency_code;
284 public $multicurrency_tx;
288 public $multicurrency_total_ht;
292 public $multicurrency_total_tva;
296 public $multicurrency_total_ttc;
343 $this->ismultientitymanaged = 1;
344 $this->isextrafieldmanaged = 1;
347 $this->labelStatus = array();
348 $this->labelStatus[-1] =
'StatusSendingCanceled';
349 $this->labelStatus[0] =
'StatusSendingDraft';
350 $this->labelStatus[1] =
'StatusSendingValidated';
351 $this->labelStatus[2] =
'StatusSendingProcessed';
354 $this->labelStatusShort = array();
355 $this->labelStatusShort[-1] =
'StatusSendingCanceledShort';
356 $this->labelStatusShort[0] =
'StatusSendingDraftShort';
357 $this->labelStatusShort[1] =
'StatusSendingValidatedShort';
358 $this->labelStatusShort[2] =
'StatusSendingProcessedShort';
369 global $langs,
$conf;
370 $langs->load(
"sendings");
379 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
381 foreach ($dirmodels as $reldir) {
385 $mybool = ((bool) @include_once $dir.$file) || $mybool;
393 $obj =
new $classname();
394 '@phan-var-force ModelNumRefExpedition $obj';
395 $numref = $obj->getNextValue($soc, $this);
400 dol_print_error($this->db, get_class($this).
"::getNextNumRef ".$obj->error);
404 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_EXPEDITION_ADDON_NUMBER_NotDefined");
416 public function create($user, $notrigger = 0)
420 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
425 if (empty($this->fk_project)) {
426 $this->fk_project = 0;
428 if (empty($this->date_creation)) {
429 $this->date_creation = $now;
431 if (empty($this->date_shipping) && !empty($this->date_expedition)) {
432 $this->date_shipping = $this->date_expedition;
440 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"expedition (";
443 $sql .=
", ref_customer";
445 $sql .=
", date_creation";
446 $sql .=
", fk_user_author";
447 $sql .=
", date_expedition";
448 $sql .=
", date_delivery";
450 $sql .=
", fk_projet";
451 $sql .=
", fk_address";
452 $sql .=
", fk_shipping_method";
453 $sql .=
", tracking_number";
458 $sql .=
", weight_units";
459 $sql .=
", size_units";
460 $sql .=
", note_private";
461 $sql .=
", note_public";
462 $sql .=
", model_pdf";
463 $sql .=
", fk_incoterms, location_incoterms";
464 $sql .=
", signed_status";
465 $sql .=
") VALUES (";
467 $sql .=
", ".((int) $this->entity);
468 $sql .=
", ".($this->ref_customer ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null");
469 $sql .=
", ".($this->ref_ext ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
470 $sql .=
", '".$this->db->idate($this->date_creation).
"'";
471 $sql .=
", ".((int) $user->id);
472 $sql .=
", ".($this->date_shipping > 0 ?
"'".$this->db->idate($this->date_shipping).
"'" :
"null");
473 $sql .=
", ".($this->date_delivery > 0 ?
"'".$this->db->idate($this->date_delivery).
"'" :
"null");
474 $sql .=
", ".($this->socid > 0 ? ((int) $this->socid) :
"null");
475 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
476 $sql .=
", ".($this->fk_delivery_address > 0 ? $this->fk_delivery_address :
"null");
477 $sql .=
", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
"null");
478 $sql .=
", '".$this->db->escape($this->tracking_number).
"'";
479 $sql .=
", ".(is_numeric($this->weight) ? $this->weight :
'NULL');
480 $sql .=
", ".(is_numeric($this->sizeS) ? $this->sizeS :
'NULL');
481 $sql .=
", ".(is_numeric($this->sizeW) ? $this->sizeW :
'NULL');
482 $sql .=
", ".(is_numeric($this->sizeH) ? $this->sizeH :
'NULL');
483 $sql .=
", ".($this->weight_units !=
'' ? (int) $this->weight_units :
'NULL');
484 $sql .=
", ".($this->size_units !=
'' ? (int) $this->size_units :
'NULL');
485 $sql .=
", ".(!empty($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
486 $sql .=
", ".(!empty($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
487 $sql .=
", ".(!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null");
488 $sql .=
", ".(int) $this->fk_incoterms;
489 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
490 $sql .=
", ".($this->signed_status);
493 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
494 $resql = $this->db->query($sql);
496 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"expedition");
498 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
499 $sql .=
" SET ref = '(PROV".$this->id.
")'";
500 $sql .=
" WHERE rowid = ".((int) $this->
id);
502 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
503 if ($this->db->query($sql)) {
505 $num = count($this->lines);
506 $kits_list = array();
508 for ($i = 0; $i < $num; $i++) {
510 $objectsrc->fetch($this->lines[$i]->origin_line_id);
511 if ($this->lines[$i]->product_type ==
"9" && $objectsrc->special_code == SUBTOTALS_SPECIAL_CODE) {
512 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) {
519 $line = $this->lines[$i];
520 if ($line->fk_product > 0) {
526 if (!isset($kits_list[$line->fk_elementdet])) {
527 if (!is_object($line->product)) {
528 $line_product =
new Product($this->db);
529 $result = $line_product->fetch($line->fk_product,
'',
'',
'', 1, 1, 1);
534 $line_product = $line->product;
538 $line_product->get_sousproduits_arbo();
539 $prods_arbo = $line_product->get_arbo_each_prod($line->qty);
540 if (count($prods_arbo) > 0) {
541 $kits_list[$line->fk_elementdet] = array(
542 'arbo' => $prods_arbo,
543 'total_qty' => $line->qty,
547 $kits_list[$line->fk_elementdet][
'total_qty'] += $line->qty;
553 $kits_id_cached = array();
554 $sub_kits_id_cached = array();
555 $sub_parents_cached = array();
556 for ($i = 0; $i < $num; $i++) {
557 $line = $this->lines[$i];
560 if (!isset($kits_id_cached[$line->fk_elementdet])) {
561 if (!isset($line->detail_batch) || (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE'))) {
562 $qty = isset($kits_list[$line->fk_elementdet]) ? $kits_list[$line->fk_elementdet][
'total_qty'] : $line->qty;
563 $warehouse_id = (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) ? 0 : $line->entrepot_id;
564 $line_id = $this->
create_line($warehouse_id, $line->origin_line_id, $qty, $line->rang, $line->array_options, 0, $line->fk_product);
568 if (isset($kits_list[$line->fk_elementdet])) $kits_id_cached[$line->fk_elementdet] = $line_id;
575 $line_id = $kits_id_cached[$line->fk_elementdet];
579 if (isset($kits_list[$line->fk_elementdet]) && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) {
580 $prods_arbo = $kits_list[$line->fk_elementdet][
'arbo'];
583 $parent_line_id = $line_id;
585 $product_child_id = 0;
586 foreach ($prods_arbo as $index => $product_child_arr) {
601 $product_child_level = (int) $product_child_arr[
'level'];
602 $product_child_incdec = !empty($product_child_arr[
'incdec']);
605 if ($product_child_level != $level_last) {
606 $parent_line_id = $line_id;
607 $parent_product_id = $product_child_id;
608 if (isset($sub_parents_cached[$line->fk_elementdet][$parent_product_id])) {
609 $parent_line_id = $sub_parents_cached[$line->fk_elementdet][$parent_product_id];
611 $sub_parents_cached[$line->fk_elementdet][$parent_product_id] = $parent_line_id;
617 $next_level = $product_child_level;
618 $next_index = $index + 1;
619 if (isset($prods_arbo[$next_index])) {
620 $next_level = (int) $prods_arbo[$next_index][
'level'];
622 if ($next_level > $product_child_level) {
627 $product_child_id = (int) $product_child_arr[
'id'];
628 $product_child_qty = (float) $product_child_arr[
'nb_total'];
629 $warehouse_id = $line->entrepot_id;
630 if ($is_kit || !$product_child_incdec) {
631 if (!$product_child_incdec) {
632 $product_child_qty = 0;
638 if (!isset($sub_kits_id_cached[$line->fk_elementdet][$product_child_id]) || $warehouse_id > 0) {
639 $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);
647 if (empty($warehouse_id)) {
648 $sub_kits_id_cached[$line->fk_elementdet][$product_child_id] = $line_id;
652 $level_last = $product_child_level;
658 if (!$error && $this->
id && $this->origin_id) {
665 if (!$error && $this->
id &&
getDolGlobalInt(
'SHIPPING_USE_ITS_OWN_CONTACTS') &&
getDolGlobalString(
'MAIN_PROPAGATE_CONTACTS_FROM_ORIGIN') && !empty($this->origin_type) && !empty($this->origin_id)) {
666 $originforcontact = $this->origin_type;
667 $originidforcontact = $this->origin_id;
669 $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";
670 $sqlcontact .=
" WHERE element_id = ".((int) $originidforcontact).
" AND ec.fk_c_type_contact = ctc.rowid AND ctc.element = '".$this->db->escape($originforcontact).
"'";
672 $resqlcontact = $this->db->query($sqlcontact);
674 while ($objcontact = $this->db->fetch_object($resqlcontact)) {
675 $this->
add_contact($objcontact->fk_socpeople, $objcontact->code, $objcontact->source);
690 if (!$error && !$notrigger) {
692 $result = $this->
call_trigger(
'SHIPPING_CREATE', $user);
702 foreach ($this->errors as $errmsg) {
703 dol_syslog(get_class($this).
"::create ".$errmsg, LOG_ERR);
704 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
706 $this->db->rollback();
711 $this->db->rollback();
716 $this->error = $this->db->lasterror().
" - sql=$sql";
717 $this->db->rollback();
722 $this->error = $this->db->error().
" - sql=$sql";
723 $this->db->rollback();
741 public function create_line($entrepot_id, $origin_line_id, $qty, $rang = 0, $array_options = [], $parent_line_id = 0, $product_id = 0)
747 $expeditionline->fk_expedition = $this->id;
748 $expeditionline->entrepot_id = $entrepot_id;
749 $expeditionline->fk_elementdet = $origin_line_id;
750 $expeditionline->element_type = $this->origin;
751 $expeditionline->fk_parent = $parent_line_id;
752 $expeditionline->fk_product = $product_id;
753 $expeditionline->qty = $qty;
754 $expeditionline->rang = $rang;
755 $expeditionline->array_options = $array_options;
757 if (!($expeditionline->fk_product > 0)) {
759 $order_line->fetch($expeditionline->fk_elementdet);
760 $expeditionline->fk_product = $order_line->fk_product;
763 if (($lineId = $expeditionline->insert($user)) < 0) {
783 $stockLocationQty = array();
785 $tab = $line_ext->detail_batch;
787 foreach ($tab as $detbatch) {
788 if (!empty($detbatch->fk_warehouse)) {
789 if (empty($stockLocationQty[$detbatch->fk_warehouse])) {
790 $stockLocationQty[$detbatch->fk_warehouse] = 0;
792 $stockLocationQty[$detbatch->fk_warehouse] += $detbatch->qty;
796 foreach ($stockLocationQty as $stockLocation => $qty) {
797 $line_id = $this->
create_line($stockLocation, $line_ext->origin_line_id, $qty, $line_ext->rang, $array_options);
802 foreach ($tab as $detbatch) {
803 if ($detbatch->fk_warehouse == $stockLocation) {
804 if (!($detbatch->create($line_id) > 0)) {
805 $this->errors = $detbatch->errors;
829 public function fetch($id, $ref =
'', $ref_ext =
'', $notused =
'')
834 if (empty($id) && empty($ref) && empty($ref_ext)) {
838 $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";
839 $sql .=
", e.date_valid, e.fk_user_valid";
840 $sql .=
", e.weight, e.weight_units, e.size, e.size_units, e.width, e.height";
841 $sql .=
", e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery";
842 $sql .=
", e.fk_shipping_method, e.tracking_number";
843 $sql .=
", e.note_private, e.note_public";
844 $sql .=
', e.fk_incoterms, e.location_incoterms';
845 $sql .=
', e.signed_status';
846 $sql .=
', i.libelle as label_incoterms';
847 $sql .=
', s.libelle as shipping_method';
848 $sql .=
", el.fk_source as origin_id, el.sourcetype as origin_type";
849 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expedition as e";
850 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON el.fk_target = e.rowid AND el.targettype = '".$this->db->escape($this->element).
"'";
851 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON e.fk_incoterms = i.rowid';
852 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_shipment_mode as s ON e.fk_shipping_method = s.rowid';
853 $sql .=
" WHERE e.entity IN (".getEntity(
'expedition').
")";
855 $sql .=
" AND e.rowid = ".((int) $id);
858 $sql .=
" AND e.ref='".$this->db->escape($ref).
"'";
861 $sql .=
" AND e.ref_ext='".$this->db->escape($ref_ext).
"'";
864 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
865 $result = $this->db->query($sql);
867 if ($this->db->num_rows($result)) {
868 $obj = $this->db->fetch_object($result);
870 $this->
id = $obj->rowid;
871 $this->entity = $obj->entity;
872 $this->
ref = $obj->ref;
873 $this->socid = $obj->socid;
874 $this->ref_customer = $obj->ref_customer;
875 $this->ref_ext = $obj->ref_ext;
876 $this->
status = $obj->fk_statut;
877 $this->statut = $this->status;
878 $this->signed_status = $obj->signed_status;
879 $this->user_author_id = $obj->fk_user_author;
880 $this->fk_user_author = $obj->fk_user_author;
881 $this->fk_user_valid = $obj->fk_user_valid;
882 $this->date_creation = $this->db->jdate($obj->date_creation);
883 $this->date_valid = $this->db->jdate($obj->date_valid);
884 $this->date = $this->db->jdate($obj->date_expedition);
885 $this->date_expedition = $this->db->jdate($obj->date_expedition);
886 $this->date_shipping = $this->db->jdate($obj->date_expedition);
887 $this->date_delivery = $this->db->jdate($obj->date_delivery);
888 $this->fk_delivery_address = $obj->fk_address;
889 $this->model_pdf = $obj->model_pdf;
890 $this->shipping_method_id = $obj->fk_shipping_method;
891 $this->shipping_method = $obj->shipping_method;
892 $this->tracking_number = $obj->tracking_number;
893 $this->origin = ($obj->origin_type ? $obj->origin_type :
'commande');
894 $this->origin_type = ($obj->origin_type ? $obj->origin_type :
'commande');
895 $this->origin_id = $obj->origin_id;
896 $this->billed = $obj->billed;
897 $this->fk_project = $obj->fk_project;
898 $this->signed_status = $obj->signed_status;
899 $this->trueWeight = $obj->weight;
900 $this->weight_units = $obj->weight_units;
902 $this->trueWidth = $obj->width;
903 $this->width_units = $obj->size_units;
904 $this->trueHeight = $obj->height;
905 $this->height_units = $obj->size_units;
906 $this->trueDepth = $obj->size;
907 $this->depth_units = $obj->size_units;
909 $this->note_public = $obj->note_public;
910 $this->note_private = $obj->note_private;
913 $this->trueSize = $obj->size.
"x".$obj->width.
"x".$obj->height;
914 $this->size_units = $obj->size_units;
917 $this->fk_incoterms = $obj->fk_incoterms;
918 $this->location_incoterms = $obj->location_incoterms;
919 $this->label_incoterms = $obj->label_incoterms;
921 $this->db->free($result);
933 if (isModEnabled(
'multicurrency')) {
934 if (!empty($this->multicurrency_code)) {
935 $this->multicurrency_code = $this->thirdparty->multicurrency_code;
937 if (
getDolGlobalString(
'MULTICURRENCY_USE_ORIGIN_TX') && !empty($this->thirdparty->multicurrency_tx)) {
938 $this->multicurrency_tx = $this->thirdparty->multicurrency_tx;
952 dol_syslog(get_class($this).
'::Fetch no expedition found', LOG_ERR);
953 $this->error =
'Shipment with id '.$id.
' not found';
957 $this->error = $this->db->error();
969 public function valid($user, $notrigger = 0)
973 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
979 dol_syslog(get_class($this).
"::valid not in draft status", LOG_WARNING);
983 if (!((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expedition',
'creer'))
984 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expedition',
'shipping_advance',
'validate')))) {
985 $this->error =
'Permission denied';
986 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
996 $soc->fetch($this->socid);
999 $result = $soc->setAsCustomer();
1002 if (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref))) {
1004 } elseif (!empty($this->
ref)) {
1005 $numref = $this->ref;
1007 $numref =
"EXP".$this->id;
1014 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition SET";
1015 $sql .=
" ref='".$this->db->escape($numref).
"'";
1016 $sql .=
", fk_statut = 1";
1017 $sql .=
", date_valid = '".$this->db->idate($now).
"'";
1018 $sql .=
", fk_user_valid = ".((int) $user->id);
1019 $sql .=
" WHERE rowid = ".((int) $this->
id);
1021 dol_syslog(get_class($this).
"::valid update expedition", LOG_DEBUG);
1022 $resql = $this->db->query($sql);
1024 $this->error = $this->db->lasterror();
1029 if (!$error && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT')) {
1038 $triggerKey =
'SHIPPING_';
1039 if ($this->origin ==
'commande') {
1040 $triggerKey.=
'ORDER_SHIPMENTONPROCESS';
1042 $triggerKey.= strtoupper($this->origin).
'_SHIPMENTONPROCESS';
1052 if (!$error && !$notrigger) {
1054 $result = $this->
call_trigger(
'SHIPPING_VALIDATE', $user);
1062 $this->oldref = $this->ref;
1065 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
1067 $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).
"'";
1068 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'expedition/sending/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
1069 $resql = $this->db->query($sql);
1072 $this->error = $this->db->lasterror();
1074 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'expedition/sending/".$this->db->escape($this->newref).
"'";
1075 $sql .=
" WHERE filepath = 'expedition/sending/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
1076 $resql = $this->db->query($sql);
1079 $this->error = $this->db->lasterror();
1085 $dirsource =
$conf->expedition->dir_output.
'/sending/'.$oldref;
1086 $dirdest =
$conf->expedition->dir_output.
'/sending/'.$newref;
1087 if (!$error && file_exists($dirsource)) {
1088 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
1090 if (@rename($dirsource, $dirdest)) {
1093 $listoffiles =
dol_dir_list(
$conf->expedition->dir_output.
'/sending/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
1094 foreach ($listoffiles as $fileentry) {
1095 $dirsource = $fileentry[
'name'];
1096 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
1097 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1098 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1099 @rename($dirsource, $dirdest);
1108 $this->
ref = $numref;
1114 $this->db->commit();
1117 $this->db->rollback();
1136 if ($this->
status == self::STATUS_VALIDATED || $this->
status == self::STATUS_CLOSED) {
1138 include_once DOL_DOCUMENT_ROOT.
'/delivery/class/delivery.class.php';
1139 $delivery =
new Delivery($this->db);
1140 $result = $delivery->create_from_sending($user, $this->
id);
1144 $this->error = $delivery->error;
1169 public function addline($entrepot_id, $id, $qty, $array_options = [], $fk_product = 0, $fk_parent = 0)
1171 global
$conf, $langs;
1173 $num = count($this->lines);
1176 $line->entrepot_id = $entrepot_id;
1177 $line->origin_line_id = $id;
1178 $line->fk_elementdet = $id;
1179 $line->element_type =
'order';
1180 $line->fk_parent = $fk_parent;
1181 $line->fk_product = $fk_product;
1185 $orderline->fetch($id);
1188 $line->rang = $orderline->rang;
1189 $line->product_type = $orderline->product_type;
1190 if (!($line->fk_product > 0)) {
1191 $line->fk_product = $orderline->fk_product;
1194 if (isModEnabled(
'stock') && !empty($orderline->fk_product)) {
1195 $product =
new Product($this->db);
1196 $product->fetch($orderline->fk_product);
1199 $langs->load(
"errors");
1200 $this->error = $langs->trans(
"ErrorWarehouseRequiredIntoShipmentLine");
1205 $productChildrenNb = 0;
1207 $productChildrenNb = $product->hasFatherOrChild(1);
1209 if ($productChildrenNb > 0) {
1210 $product_stock =
null;
1211 $product->loadStockForVirtualProduct(
'warehouseopen', $line->qty);
1212 if ($entrepot_id > 0) {
1213 if (isset($product->stock_warehouse[$entrepot_id])) {
1214 $product_stock = $product->stock_warehouse[$entrepot_id]->real;
1217 foreach ($product->stock_warehouse as $componentStockWarehouse) {
1218 if ($product_stock ===
null) {
1219 $product_stock = $componentStockWarehouse->real;
1221 $product_stock = min($product_stock, $componentStockWarehouse->real);
1225 if ($product_stock ===
null) {
1230 if ($entrepot_id > 0) {
1231 $product->load_stock(
'warehouseopen');
1232 $product_stock = $product->stock_warehouse[$entrepot_id]->real;
1234 $product_stock = $product->stock_reel;
1238 $product_type = $product->type;
1240 $isavirtualproduct = ($productChildrenNb > 0);
1243 if ($product->stockable_product == Product::ENABLED_STOCK && $product_stock < $qty) {
1244 $langs->load(
"errors");
1245 $this->error = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnShipment', $product->ref);
1246 $this->errorhidden =
'ErrorStockIsNotEnoughToAddProductOnShipment';
1248 $this->db->rollback();
1258 if (isModEnabled(
'productbatch') && !empty($line->fk_product) && !empty($orderline->product_tobatch)) {
1259 $this->error =
'ADDLINE_WAS_CALLED_INSTEAD_OF_ADDLINEBATCH '.$orderline->id.
' '.$line->fk_product;
1264 if (!
getDolGlobalString(
'MAIN_EXTRAFIELDS_DISABLED') && is_array($array_options) && count($array_options) > 0) {
1265 $line->array_options = $array_options;
1268 $this->lines[$num] = $line;
1282 public function addline_batch($dbatch, $array_options = [], $origin_line =
null)
1285 global
$conf, $langs;
1287 $num = count($this->lines);
1289 if ($dbatch[
'qty'] > 0 || ($dbatch[
'qty'] == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS'))) {
1292 foreach ($dbatch[
'detail'] as $key => $value) {
1293 if ($value[
'q'] > 0 || ($value[
'q'] == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS'))) {
1299 $ret = $linebatch->fetchFromStock($value[
'id_batch']);
1304 $linebatch->qty = $value[
'q'];
1305 if ($linebatch->qty == 0 &&
getDolGlobalString(
'SHIPMENT_GETS_ALL_ORDER_PRODUCTS')) {
1306 $linebatch->batch =
null;
1308 $tab[] = $linebatch;
1311 require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
1313 $prod_batch->fetch($value[
'id_batch']);
1315 if ($prod_batch->qty < $linebatch->qty) {
1316 $langs->load(
"errors");
1317 $this->errors[] = $langs->trans(
'ErrorStockIsNotEnoughToAddProductOnShipment', $prod_batch->fk_product);
1318 dol_syslog(get_class($this).
"::addline_batch error=Product ".$prod_batch->batch.
": ".$this->errorsToString(), LOG_ERR);
1319 $this->db->rollback();
1327 if (is_object($linebatch)) {
1328 $line->entrepot_id = $linebatch->fk_warehouse;
1330 $line->origin_line_id = $dbatch[
'ix_l'];
1331 $line->fk_elementdet = $dbatch[
'ix_l'];
1332 $line->qty = $dbatch[
'qty'];
1333 $line->detail_batch = $tab;
1334 if (!($line->rang > 0)) {
1335 $line->rang = $origin_line->rang;
1337 if (!($line->fk_product > 0)) {
1338 $line->fk_product = $origin_line->fk_product;
1342 if (!
getDolGlobalString(
'MAIN_EXTRAFIELDS_DISABLED') && is_array($array_options) && count($array_options) > 0) {
1343 $line->array_options = $array_options;
1347 $this->lines[$num] = $line;
1360 public function update($user =
null, $notrigger = 0)
1367 if (isset($this->
ref)) {
1368 $this->
ref = trim($this->
ref);
1370 if (isset($this->entity)) {
1371 $this->entity = (int) $this->entity;
1373 if (isset($this->ref_customer)) {
1374 $this->ref_customer = trim($this->ref_customer);
1376 if (isset($this->socid)) {
1377 $this->socid = (int) $this->socid;
1379 if (isset($this->fk_user_author)) {
1380 $this->fk_user_author = (int) $this->fk_user_author;
1382 if (isset($this->fk_user_valid)) {
1384 $this->fk_user_valid = (int) $this->fk_user_valid;
1386 if (isset($this->fk_delivery_address)) {
1387 $this->fk_delivery_address = (int) $this->fk_delivery_address;
1389 if (isset($this->shipping_method_id)) {
1390 $this->shipping_method_id = (int) $this->shipping_method_id;
1392 if (isset($this->tracking_number)) {
1393 $this->tracking_number = trim($this->tracking_number);
1395 if (isset($this->statut)) {
1396 $this->statut = (int) $this->statut;
1398 if (isset($this->
status)) {
1401 if (isset($this->trueDepth)) {
1402 $this->trueDepth = trim($this->trueDepth);
1404 if (isset($this->trueWidth)) {
1405 $this->trueWidth = trim($this->trueWidth);
1407 if (isset($this->trueHeight)) {
1408 $this->trueHeight = trim($this->trueHeight);
1410 if (isset($this->size_units)) {
1411 $this->size_units = trim($this->size_units);
1413 if (isset($this->weight_units)) {
1414 $this->weight_units = (int) $this->weight_units;
1416 if (isset($this->trueWeight)) {
1417 $this->weight = trim((
string) $this->trueWeight);
1419 if (isset($this->note_private)) {
1420 $this->note_private = trim($this->note_private);
1422 if (isset($this->note_public)) {
1423 $this->note_public = trim($this->note_public);
1425 if (isset($this->model_pdf)) {
1426 $this->model_pdf = trim($this->model_pdf);
1428 if (!empty($this->date_expedition)) {
1429 $this->date_shipping = $this->date_expedition;
1436 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition SET";
1437 $sql .=
" ref = ".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1438 $sql .=
" ref_ext = ".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1439 $sql .=
" ref_customer = ".(isset($this->ref_customer) ?
"'".$this->db->escape($this->ref_customer).
"'" :
"null").
",";
1440 $sql .=
" fk_soc = ".(isset($this->socid) ? $this->socid :
"null").
",";
1441 $sql .=
" date_creation = ".(dol_strlen($this->date_creation) != 0 ?
"'".$this->db->idate($this->date_creation).
"'" :
'null').
",";
1442 $sql .=
" fk_user_author = ".(isset($this->fk_user_author) ? $this->fk_user_author :
"null").
",";
1443 $sql .=
" date_valid = ".(dol_strlen($this->date_valid) != 0 ?
"'".$this->db->idate($this->date_valid).
"'" :
'null').
",";
1444 $sql .=
" fk_user_valid = ".(isset($this->fk_user_valid) ? $this->fk_user_valid :
"null").
",";
1445 $sql .=
" date_expedition = ".(dol_strlen($this->date_shipping) != 0 ?
"'".$this->db->idate($this->date_shipping).
"'" :
'null').
",";
1446 $sql .=
" date_delivery = ".(dol_strlen($this->date_delivery) != 0 ?
"'".$this->db->idate($this->date_delivery).
"'" :
'null').
",";
1447 $sql .=
" fk_address = ".(isset($this->fk_delivery_address) ? $this->fk_delivery_address :
"null").
",";
1448 $sql .=
" fk_shipping_method = ".((isset($this->shipping_method_id) && $this->shipping_method_id > 0) ? $this->shipping_method_id :
"null").
",";
1449 $sql .=
" tracking_number = ".(isset($this->tracking_number) ?
"'".$this->db->escape($this->tracking_number).
"'" :
"null").
",";
1450 $sql .=
" fk_statut = ".(isset($this->
status) ? $this->
status :
"null").
",";
1451 $sql .=
" fk_projet = ".(isset($this->fk_project) ? $this->fk_project :
"null").
",";
1452 $sql .=
" height = ".(($this->trueHeight !=
'') ? $this->trueHeight :
"null").
",";
1453 $sql .=
" width = ".(($this->trueWidth !=
'') ? $this->trueWidth :
"null").
",";
1454 $sql .=
" size_units = ".(isset($this->size_units) ? $this->size_units :
"null").
",";
1455 $sql .=
" size = ".(($this->trueDepth !=
'') ? $this->trueDepth :
"null").
",";
1456 $sql .=
" weight_units = ".(isset($this->weight_units) ? $this->weight_units :
"null").
",";
1457 $sql .=
" weight = ".(($this->trueWeight !=
'') ? $this->trueWeight :
"null").
",";
1458 $sql .=
" note_private = ".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1459 $sql .=
" note_public = ".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1460 $sql .=
" model_pdf = ".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1461 $sql .=
" entity = ".((int)
$conf->entity);
1462 $sql .=
" WHERE rowid = ".((int) $this->
id);
1466 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1467 $resql = $this->db->query($sql);
1470 $this->errors[] =
"Error ".$this->db->lasterror();
1481 if (!$error && !$notrigger) {
1483 $result = $this->
call_trigger(
'SHIPPING_MODIFY', $user);
1492 foreach ($this->errors as $errmsg) {
1493 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1494 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1496 $this->db->rollback();
1499 $this->db->commit();
1512 public function cancel($notrigger = 0, $also_update_stock =
false)
1514 global
$conf, $langs, $user;
1516 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1525 if (isset($this->linkedObjectsIds[
'delivery']) && count($this->linkedObjectsIds[
'delivery']) > 0) {
1526 $this->error =
'ErrorThereIsSomeDeliveries';
1530 if (!$error && !$notrigger) {
1532 $result = $this->
call_trigger(
'SHIPPING_CANCEL', $user);
1540 $can_update_stock = isModEnabled(
'stock') &&
1542 (
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE') && $this->
status == self::STATUS_CLOSED && $also_update_stock));
1544 require_once DOL_DOCUMENT_ROOT.
"/product/stock/class/mouvementstock.class.php";
1546 $langs->load(
"agenda");
1550 $sql .=
" ed.fk_product";
1551 $sql .=
", ed.qty, ed.fk_entrepot, ed.rowid as expeditiondet_id";
1552 $sql .=
", SUM(".$this->db->ifsql(
"pa.rowid IS NOT NULL",
"1",
"0").
") as iskit";
1553 $sql .=
", ".$this->db->ifsql(
"pai.incdec IS NULL",
"1",
"pai.incdec").
" as incdec";
1554 $sql .=
" FROM ".$this->db->prefix().
"expeditiondet as ed";
1555 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pa ON pa.fk_product_pere = ed.fk_product";
1556 $sql .=
" LEFT JOIN ".$this->db->prefix().
"expeditiondet as edp ON edp.rowid = ed.fk_parent";
1557 $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";
1558 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
1559 $sql .=
" GROUP BY ed.fk_product, ed.qty, ed.fk_entrepot, ed.rowid, pai.incdec";
1560 $sql .= $this->db->order(
"ed.rowid",
"DESC");
1562 dol_syslog(get_class($this).
"::delete select details", LOG_DEBUG);
1563 $resql = $this->db->query($sql);
1565 $cpt = $this->db->num_rows($resql);
1569 for ($i = 0; $i < $cpt; $i++) {
1570 dol_syslog(get_class($this).
"::delete movement index ".$i);
1571 $obj = $this->db->fetch_object($resql);
1572 $line_id = (int) $obj->expeditiondet_id;
1574 if ($can_update_stock && (empty($obj->iskit) ||
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) && !empty($obj->incdec)) {
1577 $mouvS->origin =
'';
1580 if (isModEnabled(
'productbatch')) {
1581 $lotArray = $shipmentlinebatch->fetchAll($obj->expeditiondet_id);
1582 if (!is_array($lotArray)) {
1584 $this->errors[] =
"Error ".$this->db->lasterror();
1588 if (empty($lotArray)) {
1592 $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));
1595 $this->errors = array_merge($this->errors, $mouvS->errors);
1601 foreach ($lotArray as $lot) {
1602 if (empty($lot->qty)) {
1605 $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));
1608 $this->errors = array_merge($this->errors, $mouvS->errors);
1621 $res = $shipment_line->fetch($line_id);
1623 $result = $shipment_line->delete($user);
1626 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1630 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1640 $this->errors[] =
"Error ".$this->db->lasterror();
1653 $sql =
"SELECT rowid FROM ".$this->db->prefix().
"expedition";
1654 $sql .=
" WHERE rowid = ".((int) $this->
id);
1656 if ($this->db->query($sql)) {
1657 if (!empty($this->origin) && $this->origin_id > 0) {
1660 '@phan-var-force Facture|Commande $origin_object';
1672 $this->db->commit();
1676 if (!empty(
$conf->expedition->dir_output)) {
1677 $dir =
$conf->expedition->dir_output.
'/sending/'.$ref;
1678 $file = $dir.
'/'.$ref.
'.pdf';
1679 if (file_exists($file)) {
1684 if (file_exists($dir)) {
1686 $this->error = $langs->trans(
"ErrorCanNotDeleteDir", $dir);
1694 $this->db->rollback();
1698 $this->error = $this->db->lasterror().
" - sql=$sql";
1699 $this->db->rollback();
1703 $this->db->rollback();
1707 $this->db->rollback();
1721 public function delete($user =
null, $notrigger = 0, $also_update_stock =
false)
1723 global
$conf, $langs;
1729 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1738 if (isset($this->linkedObjectsIds[
'delivery']) && count($this->linkedObjectsIds[
'delivery']) > 0) {
1739 $this->error =
'ErrorThereIsSomeDeliveries';
1743 if (!$error && !$notrigger) {
1745 $result = $this->
call_trigger(
'SHIPPING_DELETE', $user);
1753 $can_update_stock = isModEnabled(
'stock') &&
1755 (
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE') && $this->
status == self::STATUS_CLOSED && $also_update_stock));
1757 require_once DOL_DOCUMENT_ROOT.
"/product/stock/class/mouvementstock.class.php";
1759 $langs->load(
"agenda");
1766 $sql .=
" ed.fk_product";
1767 $sql .=
", ed.qty, ed.fk_entrepot, ed.rowid as expeditiondet_id";
1768 $sql .=
", SUM(".$this->db->ifsql(
"pa.rowid IS NOT NULL",
"1",
"0").
") as iskit";
1769 $sql .=
", ".$this->db->ifsql(
"pai.incdec IS NULL",
"1",
"pai.incdec").
" as incdec";
1770 $sql .=
" FROM ".$this->db->prefix().
"expeditiondet as ed";
1771 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_association as pa ON pa.fk_product_pere = ed.fk_product";
1772 $sql .=
" LEFT JOIN ".$this->db->prefix().
"expeditiondet as edp ON edp.rowid = ed.fk_parent";
1773 $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";
1774 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
1775 $sql .=
" GROUP BY ed.fk_product, ed.qty, ed.fk_entrepot, ed.rowid, pai.incdec";
1776 $sql .= $this->db->order(
"ed.rowid",
"DESC");
1778 dol_syslog(get_class($this).
"::delete select details", LOG_DEBUG);
1779 $resql = $this->db->query($sql);
1781 $cpt = $this->db->num_rows($resql);
1782 for ($i = 0; $i < $cpt; $i++) {
1783 dol_syslog(get_class($this).
"::delete movement index ".$i);
1784 $obj = $this->db->fetch_object($resql);
1785 $line_id = (int) $obj->expeditiondet_id;
1787 if ($can_update_stock && (empty($obj->iskit) ||
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) && !empty($obj->incdec)) {
1790 $mouvS->origin =
'';
1792 $lotArray = $shipmentlinebatch->fetchAll($line_id);
1793 if (!is_array($lotArray)) {
1795 $this->errors[] =
"Error ".$this->db->lasterror();
1797 if (empty($lotArray)) {
1801 $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));
1804 $this->errors = array_merge($this->errors, $mouvS->errors);
1810 foreach ($lotArray as $lot) {
1811 if (empty($lot->qty)) {
1814 $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));
1817 $this->errors = array_merge($this->errors, $mouvS->errors);
1830 $res = $shipment_line->fetch($line_id);
1832 $result = $shipment_line->delete($user);
1835 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1839 $this->errors[] =
"Error ".$shipment_line->errorsToString();
1849 $this->errors[] =
"Error ".$this->db->lasterror();
1874 $sql =
"DELETE FROM ".$this->db->prefix().
"expedition";
1875 $sql .=
" WHERE rowid = ".((int) $this->
id);
1877 if ($this->db->query($sql)) {
1878 if (!empty($this->origin) && $this->origin_id > 0) {
1881 '@phan-var-force Facture|Commande $origin_object';
1893 $this->db->commit();
1901 if (!empty(
$conf->expedition->dir_output) && !empty($ref)) {
1902 $dir =
$conf->expedition->dir_output.
'/sending/'.$ref;
1903 $file = $dir.
'/'.$ref.
'.pdf';
1904 if (file_exists($file)) {
1909 if (file_exists($dir)) {
1911 $this->error = $langs->trans(
"ErrorCanNotDeleteDir", $dir);
1919 $this->db->rollback();
1923 $this->error = $this->db->lasterror().
" - sql=$sql";
1924 $this->db->rollback();
1928 $this->db->rollback();
1932 $this->db->rollback();
1948 $this->lines = array();
1953 $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";
1954 $sql .=
", cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva";
1955 $sql .=
", cd.fk_remise_except, cd.fk_product_fournisseur_price as fk_fournprice";
1956 $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";
1957 $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";
1958 $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";
1959 $sql .=
", p.ref as product_ref, p.label as product_label, p.fk_product_type, p.barcode as product_barcode";
1960 $sql .=
", p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units";
1961 $sql .=
", p.surface, p.surface_units, p.volume, p.volume_units, p.tosell as product_tosell, p.tobuy as product_tobuy";
1962 $sql .=
", p.tobatch as product_tobatch, p.stockable_product";
1963 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expeditiondet as ed, ".MAIN_DB_PREFIX.
"commandedet as cd";
1964 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON p.rowid = cd.fk_product";
1965 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
1966 $sql .=
" AND ed.fk_elementdet = cd.rowid";
1967 $sql .=
" ORDER BY cd.rang, ed.fk_elementdet";
1969 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
1970 $resql = $this->db->query($sql);
1972 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1974 $num = $this->db->num_rows($resql);
1980 $this->total_ht = 0;
1981 $this->total_tva = 0;
1982 $this->total_ttc = 0;
1983 $this->total_localtax1 = 0;
1984 $this->total_localtax2 = 0;
1986 $this->multicurrency_total_ht = 0;
1987 $this->multicurrency_total_tva = 0;
1988 $this->multicurrency_total_ttc = 0;
1994 $obj = $this->db->fetch_object($resql);
1996 if ($originline > 0 && $originline == $obj->fk_elementdet) {
1998 $line->entrepot_id = 0;
1999 $line->qty_shipped += $obj->qty_shipped;
2002 $line->entrepot_id = $obj->fk_entrepot;
2003 $line->qty_shipped = $obj->qty_shipped;
2007 $detail_entrepot->entrepot_id = $obj->fk_entrepot;
2008 $detail_entrepot->qty_shipped = $obj->qty_shipped;
2009 $detail_entrepot->line_id = $obj->line_id;
2010 $line->details_entrepot[] = $detail_entrepot;
2012 $line->line_id = $obj->line_id;
2013 $line->rowid = $obj->line_id;
2014 $line->id = $obj->line_id;
2016 $line->fk_origin =
'orderline';
2018 $line->fk_element = $obj->fk_element;
2019 $line->origin_id = $obj->fk_element;
2020 $line->fk_elementdet = $obj->fk_elementdet;
2021 $line->origin_line_id = $obj->fk_elementdet;
2022 $line->element_type = $obj->element_type;
2024 $line->fk_expedition = $this->id;
2026 $line->stockable_product = $obj->stockable_product;
2027 $line->product_type = $obj->product_type;
2028 $line->fk_product = $obj->fk_product;
2029 $line->fk_product_type = $obj->fk_product_type;
2030 $line->ref = $obj->product_ref;
2031 $line->product_ref = $obj->product_ref;
2032 $line->product_label = $obj->product_label;
2033 $line->libelle = $obj->product_label;
2034 $line->product_barcode = $obj->product_barcode;
2035 $line->product_tosell = $obj->product_tosell;
2036 $line->product_tobuy = $obj->product_tobuy;
2037 $line->product_tobatch = $obj->product_tobatch;
2038 $line->fk_fournprice = $obj->fk_fournprice;
2039 $line->label = $obj->custom_label;
2040 $line->description = $obj->description;
2041 $line->qty_asked = $obj->qty_asked;
2042 $line->rang = $obj->rang;
2043 $line->weight = $obj->weight;
2044 $line->weight_units = $obj->weight_units;
2045 $line->length = $obj->length;
2046 $line->length_units = $obj->length_units;
2047 $line->width = $obj->width;
2048 $line->width_units = $obj->width_units;
2049 $line->height = $obj->height;
2050 $line->height_units = $obj->height_units;
2051 $line->surface = $obj->surface;
2052 $line->surface_units = $obj->surface_units;
2053 $line->volume = $obj->volume;
2054 $line->volume_units = $obj->volume_units;
2055 $line->stockable_product = $obj->stockable_product;
2056 $line->fk_unit = $obj->fk_unit;
2058 $line->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2060 $line->pa_ht = $obj->pa_ht;
2063 $localtax_array = array(0 => $obj->localtax1_type, 1 => $obj->localtax1_tx, 2 => $obj->localtax2_type, 3 => $obj->localtax2_tx);
2064 $localtax1_tx =
get_localtax($obj->tva_tx, 1, $this->thirdparty);
2065 $localtax2_tx =
get_localtax($obj->tva_tx, 2, $this->thirdparty);
2068 $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);
2069 $line->desc = $obj->description;
2070 $line->qty = $line->qty_shipped;
2071 $line->total_ht = (float) $tabprice[0];
2072 $line->total_localtax1 = (float) $tabprice[9];
2073 $line->total_localtax2 = (float) $tabprice[10];
2074 $line->total_ttc = (float) $tabprice[2];
2075 $line->total_tva = (float) $tabprice[1];
2076 $line->vat_src_code = $obj->vat_src_code;
2077 $line->tva_tx = $obj->tva_tx;
2078 $line->localtax1_tx = $obj->localtax1_tx;
2079 $line->localtax2_tx = $obj->localtax2_tx;
2080 $line->info_bits = $obj->info_bits;
2081 $line->price = $obj->price;
2082 $line->subprice = $obj->subprice;
2083 $line->fk_remise_except = $obj->fk_remise_except;
2084 $line->remise_percent = $obj->remise_percent;
2086 $this->total_ht += $tabprice[0];
2087 $this->total_tva += $tabprice[1];
2088 $this->total_ttc += $tabprice[2];
2089 $this->total_localtax1 += $tabprice[9];
2090 $this->total_localtax2 += $tabprice[10];
2092 $line->date_start = $this->db->jdate($obj->date_start);
2093 $line->date_end = $this->db->jdate($obj->date_end);
2095 $line->special_code = $obj->special_code;
2098 $this->fk_multicurrency = $obj->fk_multicurrency;
2099 $this->multicurrency_code = $obj->multicurrency_code;
2100 $line->multicurrency_subprice = $obj->multicurrency_subprice;
2101 $line->multicurrency_total_ht = $obj->multicurrency_total_ht;
2102 $line->multicurrency_total_tva = $obj->multicurrency_total_tva;
2103 $line->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2105 $this->multicurrency_total_ht += $obj->multicurrency_total_ht;
2106 $this->multicurrency_total_tva += $obj->multicurrency_total_tva;
2107 $this->multicurrency_total_ttc += $obj->multicurrency_total_ttc;
2109 if ($originline != $obj->fk_elementdet) {
2110 $line->detail_batch = array();
2114 if (isModEnabled(
'productbatch') && $obj->line_id > 0 && $obj->product_tobatch > 0) {
2115 $newdetailbatch = $shipmentlinebatch->fetchAll($obj->line_id, $obj->fk_product);
2117 if (is_array($newdetailbatch)) {
2118 if ($originline != $obj->fk_elementdet) {
2119 $line->detail_batch = $newdetailbatch;
2121 $line->detail_batch = array_merge($line->detail_batch, $newdetailbatch);
2128 $detail_children = array();
2129 $line_child_list = array();
2130 $res = $line->findAllChild($line->id, $line_child_list, 1);
2132 foreach ($line_child_list as $child_line) {
2133 foreach ($child_line as $child_obj) {
2134 $child_product_id = (int) $child_obj->fk_product;
2135 $child_warehouse_id = (int) $child_obj->fk_warehouse;
2137 if ($child_warehouse_id > 0) {
2139 if (!isset($detail_children[$child_product_id])) {
2140 $detail_children[$child_product_id] = array();
2142 if (!isset($detail_children[$child_product_id][$child_warehouse_id])) {
2143 $detail_children[$child_product_id][$child_warehouse_id] = 0;
2145 $detail_children[$child_product_id][$child_warehouse_id] += $child_obj->qty;
2150 $line->detail_children = $detail_children;
2153 $line->fetch_optionals();
2155 if ($originline != $obj->fk_elementdet) {
2156 $this->lines[$lineindex] = $line;
2159 $line->total_ht += $tabprice[0];
2160 $line->total_localtax1 += $tabprice[9];
2161 $line->total_localtax2 += $tabprice[10];
2162 $line->total_ttc += $tabprice[2];
2163 $line->total_tva += $tabprice[1];
2167 $originline = $obj->fk_elementdet;
2169 $this->db->free($resql);
2172 $this->error = $this->db->error();
2188 if ($this->
status == self::STATUS_DRAFT) {
2194 $line->fetch($lineid);
2196 if ($this->
id > 0 && (
int) $line->fk_expedition !== (
int) $this->id) {
2197 $this->db->rollback();
2198 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
2202 if ($line->delete($user) > 0) {
2205 $this->db->commit();
2208 $this->db->rollback();
2212 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
2226 global
$conf, $langs;
2228 $langs->load(
'sendings');
2230 $nofetch = !empty($params[
'nofetch']);
2233 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Shipment").
'</u>';
2234 if (isset($this->
status)) {
2235 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
2237 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2238 $datas[
'refcustomer'] =
'<br><b>'.$langs->trans(
'RefCustomer').
':</b> '.($this->ref_customer ? $this->ref_customer : $this->ref_client);
2240 $langs->load(
'companies');
2241 if (empty($this->thirdparty)) {
2244 $datas[
'customer'] =
'<br><b>'.$langs->trans(
'Customer').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
2261 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $notooltip = 0, $save_lastsearch_value = -1)
2263 global $langs, $hookmanager;
2268 'objecttype' => $this->element,
2269 'option' => $option,
2272 $classfortooltip =
'classfortooltip';
2275 $classfortooltip =
'classforajaxtooltip';
2276 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2282 $url = DOL_URL_ROOT.
'/expedition/card.php?id='.$this->id;
2288 if ($option !==
'nolink') {
2290 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2291 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2292 $add_save_lastsearch_values = 1;
2294 if ($add_save_lastsearch_values) {
2295 $url .=
'&save_lastsearch_values=1';
2300 if (empty($notooltip)) {
2302 $label = $langs->trans(
"Shipment");
2303 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2305 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2306 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2309 $linkstart =
'<a href="'.$url.
'"';
2310 $linkstart .= $linkclose.
'>';
2313 $result .= $linkstart;
2315 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'"'), 0, 0, $notooltip ? 0 : 1);
2317 if ($withpicto != 2) {
2318 $result .= $this->ref;
2320 $result .= $linkend;
2322 $hookmanager->initHooks(array($this->element .
'dao'));
2323 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2324 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2326 $result = $hookmanager->resPrint;
2328 $result .= $hookmanager->resPrint;
2357 $labelStatus = $langs->transnoentitiesnoconv($this->labelStatus[$status]);
2358 $labelStatusShort = $langs->transnoentitiesnoconv($this->labelStatusShort[$status]);
2360 $statusType =
'status'.$status;
2361 if ($status == self::STATUS_VALIDATED) {
2362 $statusType =
'status4';
2364 if ($status == self::STATUS_CLOSED) {
2365 $statusType =
'status6';
2367 if ($status == self::STATUS_CANCELED) {
2368 $statusType =
'status9';
2372 $status_label = $this->signed_status ? $labelStatus . $signed_label : $labelStatus;
2373 $status_label_short = $this->signed_status ? $labelStatusShort . $signed_label : $labelStatusShort;
2375 return dolGetStatus($status_label, $status_label_short,
'', $statusType, $mode);
2387 global $langs,
$conf;
2389 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2391 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2392 $return .=
'<div class="info-box info-box-sm">';
2393 $return .=
'<div class="info-box-icon bg-infobox-action">';
2395 $return .=
'</div>';
2396 $return .=
'<div class="info-box-content">';
2397 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
2398 if ($selected >= 0) {
2399 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2401 if (property_exists($this,
'thirdparty') && is_object($this->thirdparty)) {
2402 $return .=
'<br><div class="info-box-ref tdoverflowmax150">'.$this->thirdparty->getNomUrl(1).
'</div>';
2404 if (property_exists($this,
'total_ht')) {
2405 $return .=
'<div class="info-box-ref amount">'.price($this->total_ht, 0, $langs, 0, -1, -1,
$conf->currency).
' '.$langs->trans(
'HT').
'</div>';
2407 if (method_exists($this,
'getLibStatut')) {
2408 $return .=
'<div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
2410 $return .=
'</div>';
2411 $return .=
'</div>';
2412 $return .=
'</div>';
2430 dol_syslog(get_class($this).
"::initAsSpecimen");
2433 $order->initAsSpecimen();
2437 $this->
ref =
'SPECIMEN';
2438 $this->specimen = 1;
2440 $this->livraison_id = 0;
2442 $this->date_creation = $now;
2443 $this->date_valid = $now;
2444 $this->date_delivery = $now + 24 * 3600;
2445 $this->date_expedition = $now + 24 * 3600;
2447 $this->entrepot_id = 0;
2448 $this->fk_delivery_address = 0;
2451 $this->commande_id = 0;
2452 $this->commande = $order;
2454 $this->origin_id = 1;
2455 $this->origin_type =
'commande';
2457 $this->note_private =
'Private note';
2458 $this->note_public =
'Public note';
2462 while ($xnbp < $nbp) {
2464 $line->product_desc = $langs->trans(
"Description").
" ".$xnbp;
2465 $line->product_label = $langs->trans(
"Description").
" ".$xnbp;
2467 $line->qty_asked = 5;
2468 $line->qty_shipped = 4;
2469 $line->fk_product = $this->commande->lines[$xnbp]->fk_product;
2471 $line->weight = 1.123456;
2472 $line->weight_units = 0;
2474 $line->volume = 2.34567;
2475 $line->volume_unit = 0;
2477 $this->lines[] = $line;
2508 if ($user->hasRight(
'expedition',
'creer')) {
2509 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
2510 $sql .=
" SET date_delivery = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2511 $sql .=
" WHERE rowid = ".((int) $this->
id);
2513 dol_syslog(get_class($this).
"::setDeliveryDate", LOG_DEBUG);
2514 $resql = $this->db->query($sql);
2516 $this->date_delivery = $delivery_date;
2519 $this->error = $this->db->error();
2536 if ($user->hasRight(
'expedition',
'creer')) {
2537 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"expedition";
2538 $sql .=
" SET date_expedition = ".($shipping_date ?
"'".$this->db->idate($shipping_date).
"'" :
'null');
2539 $sql .=
" WHERE rowid = ".((int) $this->
id);
2541 dol_syslog(get_class($this).
"::setShippingDate", LOG_DEBUG);
2542 $resql = $this->db->query($sql);
2544 $this->date_shipping = $shipping_date;
2547 $this->error = $this->db->error();
2565 $this->meths = array();
2567 $sql =
"SELECT em.rowid, em.code, em.libelle as label";
2568 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2569 $sql .=
" WHERE em.active = 1";
2570 $sql .=
" ORDER BY em.libelle ASC";
2572 $resql = $this->db->query($sql);
2574 while ($obj = $this->db->fetch_object($resql)) {
2575 $label = $langs->trans(
'SendingMethod'.$obj->code);
2576 $this->meths[$obj->rowid] = ($label !=
'SendingMethod'.$obj->code ? $label : $obj->label);
2593 $this->listmeths = array();
2596 $sql =
"SELECT em.rowid, em.code, em.libelle as label, em.description, em.tracking, em.active";
2597 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2599 $sql .=
" WHERE em.rowid=".((int) $id);
2602 $resql = $this->db->query($sql);
2604 while ($obj = $this->db->fetch_object($resql)) {
2605 $this->listmeths[$i][
'rowid'] = $obj->rowid;
2606 $this->listmeths[$i][
'code'] = $obj->code;
2607 $label = $langs->trans(
'SendingMethod'.$obj->code);
2608 $this->listmeths[$i][
'libelle'] = ($label !=
'SendingMethod'.$obj->code ? $label : $obj->label);
2609 $this->listmeths[$i][
'description'] = $obj->description;
2610 $this->listmeths[$i][
'tracking'] = $obj->tracking;
2611 $this->listmeths[$i][
'active'] = $obj->active;
2625 if (!empty($this->shipping_method_id)) {
2626 $sql =
"SELECT em.code, em.tracking";
2627 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_shipment_mode as em";
2628 $sql .=
" WHERE em.rowid = ".((int) $this->shipping_method_id);
2630 $resql = $this->db->query($sql);
2632 if ($obj = $this->db->fetch_object($resql)) {
2633 $tracking = $obj->tracking;
2638 if (!empty($tracking) && !empty($value)) {
2639 $url = str_replace(
'{TRACKID}', $value, $tracking);
2640 $this->tracking_url = sprintf(
'<a target="_blank" rel="noopener noreferrer" href="%s">%s</a>', $url, ($value ? $value :
'url'));
2642 $this->tracking_url = $value;
2653 global $langs, $user;
2658 if ($this->
status == self::STATUS_CLOSED) {
2665 if (empty($this->date_shipping)) {
2666 $sql .=
", date_expedition = '".$this->db->escape($this->db->idate(
dol_now())).
"'";
2668 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut > 0";
2669 $sql .=
" AND fk_statut <> ".self::STATUS_CLOSED;
2671 $resql = $this->db->query($sql);
2672 if ($resql && $this->db->affected_rows($resql) <= 0) {
2675 $this->db->rollback();
2676 dol_syslog(get_class($this).
"::setClosed shipment ".$this->
id.
" is not validated, nothing done", LOG_WARNING);
2681 if ($this->origin ==
'commande' && $this->origin_id > 0) {
2683 $order->fetch($this->origin_id);
2685 $order->loadExpeditions(self::STATUS_CLOSED);
2687 $shipments_match_order = 1;
2688 foreach ($order->lines as $line) {
2689 $lineid = $line->id;
2691 if (($line->product_type == 0 ||
getDolGlobalString(
'STOCK_SUPPORTS_SERVICES')) && $order->expeditions[$lineid] != $qty) {
2692 $shipments_match_order = 0;
2693 $text =
'Qty for order line id '.$lineid.
' is '.$qty.
'. However in the shipments with status Expedition::STATUS_CLOSED='.self::STATUS_CLOSED.
' we have qty = '.$order->expeditions[$lineid].
', so we can t close order';
2698 if ($shipments_match_order) {
2699 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');
2701 $order->cloture($user, 0, 0);
2709 if (!$error && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE')) {
2718 $result = $this->
call_trigger(
'SHIPPING_CLOSED', $user);
2729 $this->db->commit();
2735 $this->db->rollback();
2754 require_once DOL_DOCUMENT_ROOT .
'/product/stock/class/mouvementstock.class.php';
2756 $langs->load(
"agenda");
2760 $sql .=
" ed.rowid as edid, ed.fk_product, ed.qty, ed.fk_entrepot";
2761 $sql .=
", cd.rowid as cdid";
2762 $sql .=
", cd.subprice";
2763 $sql .=
", edb.rowid as edbrowid, edb.eatby, edb.sellby, edb.batch, edb.qty as edbqty, edb.fk_origin_stock";
2765 $sql .=
" FROM " . $this->db->prefix() .
"expeditiondet as ed";
2766 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"commandedet as cd ON cd.rowid = ed.fk_elementdet";
2767 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"expeditiondet_batch as edb on edb.fk_expeditiondet = ed.rowid";
2768 $sql .=
" INNER JOIN " . $this->db->prefix() .
"expedition as e ON ed.fk_expedition = e.rowid";
2769 $sql .=
" WHERE ed.fk_expedition = " . ((int) $this->
id);
2772 dol_syslog(get_class($this) .
"::valid select details", LOG_DEBUG);
2773 $resql = $this->db->query($sql);
2775 $cpt = $this->db->num_rows($resql);
2776 for ($i = 0; $i < $cpt; $i++) {
2777 $obj = $this->db->fetch_object($resql);
2778 if (empty($obj->edbrowid)) {
2781 $qty = $obj->edbqty;
2783 if ($qty <= 0 || ($qty < 0 && !
getDolGlobalInt(
'SHIPMENT_ALLOW_NEGATIVE_QTY'))) {
2786 dol_syslog(get_class($this) .
"::valid movement index " . $i .
" ed.rowid=" . $obj->edid .
" edb.rowid=" . $obj->edbrowid);
2789 $mouvS->origin = &$this;
2790 $mouvS->setOrigin($this->element, $this->
id, $obj->cdid, $obj->edid);
2792 if (empty($obj->edbrowid)) {
2796 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, $qty, $obj->subprice, $langs->trans($labelmovement, $obj->ref));
2798 $this->error = $mouvS->error;
2799 $this->errors = $mouvS->errors;
2807 $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);
2809 $this->error = $mouvS->error;
2810 $this->errors = $mouvS->errors;
2818 $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)";
2819 $resqldelete = $this->db->query($sqldelete);
2823 $this->error = $this->db->lasterror();
2824 $this->errors[] = $this->db->lasterror();
2847 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'expedition SET billed = 1';
2848 $sql .=
" WHERE rowid = ".((int) $this->
id).
' AND fk_statut > 0';
2850 $resql = $this->db->query($sql);
2855 $result = $this->
call_trigger(
'SHIPPING_BILLED', $user);
2862 $this->errors[] = $this->db->lasterror;
2865 if (empty($error)) {
2866 $this->db->commit();
2869 $this->db->rollback();
2884 if ($this->
status <= self::STATUS_DRAFT) {
2888 return $this->
setStatusCommon($user, self::STATUS_DRAFT, $notrigger,
'SHIPMENT_UNVALIDATE');
2898 global $langs, $user;
2903 if ($this->
status == self::STATUS_VALIDATED) {
2909 $oldbilled = $this->billed;
2911 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'expedition SET fk_statut = 1';
2914 $resql = $this->db->query($sql);
2915 if ($resql && $this->db->affected_rows($resql) <= 0) {
2917 $this->db->rollback();
2918 $langs->load(
"sendings");
2919 $this->error = $langs->trans(
"StatusOfRefMustBe", $this->
ref, $langs->transnoentitiesnoconv(
"StatusSendingProcessedShort"));
2920 $this->errors[] = $this->error;
2929 if (isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE')) {
2930 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
2932 $langs->load(
"agenda");
2936 $sql =
"SELECT cd.fk_product, cd.subprice,";
2937 $sql .=
" ed.rowid, ed.qty, ed.fk_entrepot,";
2938 $sql .=
" edb.rowid as edbrowid, edb.eatby, edb.sellby, edb.batch, edb.qty as edbqty, edb.fk_origin_stock";
2939 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commandedet as cd,";
2940 $sql .=
" ".MAIN_DB_PREFIX.
"expeditiondet as ed";
2941 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"expeditiondet_batch as edb on edb.fk_expeditiondet = ed.rowid";
2942 $sql .=
" WHERE ed.fk_expedition = ".((int) $this->
id);
2943 $sql .=
" AND cd.rowid = ed.fk_elementdet";
2945 dol_syslog(get_class($this).
"::valid select details", LOG_DEBUG);
2946 $resql = $this->db->query($sql);
2948 $cpt = $this->db->num_rows($resql);
2949 for ($i = 0; $i < $cpt; $i++) {
2950 $obj = $this->db->fetch_object($resql);
2951 if (empty($obj->edbrowid)) {
2954 $qty = $obj->edbqty;
2959 dol_syslog(get_class($this).
"::reopen expedition movement index ".$i.
" ed.rowid=".$obj->rowid.
" edb.rowid=".$obj->edbrowid);
2963 $mouvS->origin = &$this;
2964 $mouvS->setOrigin($this->element, $this->
id);
2966 if (empty($obj->edbrowid)) {
2970 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, -$qty, $obj->subprice, $langs->trans(
"ShipmentUnClassifyCloseddInDolibarr", $this->ref));
2972 $this->error = $mouvS->error;
2973 $this->errors = $mouvS->errors;
2981 $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, -$qty, $obj->subprice, $langs->trans(
"ShipmentUnClassifyCloseddInDolibarr", $this->ref),
'',
'',
'', $obj->batch, $obj->fk_origin_stock);
2983 $this->error = $mouvS->error;
2984 $this->errors = $mouvS->errors;
2991 $this->error = $this->db->lasterror();
2998 $result = $this->
call_trigger(
'SHIPPING_REOPEN', $user);
3005 $this->errors[] = $this->db->lasterror();
3009 $this->db->commit();
3014 $this->billed = $oldbilled;
3015 $this->db->rollback();
3031 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3033 $outputlangs->load(
"products");
3038 if (!empty($this->model_pdf)) {
3039 $modele = $this->model_pdf;
3045 $modelpath =
"core/modules/expedition/doc/";
3049 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...
deleteEcmFiles($mode=0)
Delete related files of object in database.
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
setStatut($status, $elementId=null, $elementType='', $trigkey='', $fieldstatus='fk_statut')
Set status of an object.
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.
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.
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.
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
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.
getNextNumRef($soc)
Return next expedition ref.
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.
cancel($notrigger=0, $also_update_stock=false)
Cancel 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.
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.
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.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
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_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.
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.
$conf db user
Active Directory does not allow anonymous connections.