26require_once DOL_DOCUMENT_ROOT .
'/expedition/class/expedition.class.php';
27require_once DOL_DOCUMENT_ROOT .
'/product/class/product.class.php';
28require_once DOL_DOCUMENT_ROOT .
'/product/stock/class/entrepot.class.php';
49 foreach (
$object->lines as $line) {
50 if ((
int) $line->fk_expedition !== (
int)
$object->id) {
53 if ((
int) $line->id === $sourceLineId) {
56 if ((
int) $line->id === $lineId) {
57 $dispatchLine = $line;
61 if ($sourceLine ===
null || $sourceLine->fk_parent > 0 || (
int) $sourceLine->fk_product !== $productId) {
64 if ($lineId > 0 && ($dispatchLine ===
null || (
int) $dispatchLine->fk_product !== $productId
65 || ($lineId !== $sourceLineId && (
int) $dispatchLine->fk_parent !== $sourceLineId))) {
84 if ($line->fk_product > 0) {
86 if ($tmpprod->fetch($line->fk_product) > 0) {
87 $datapriceofproduct = $tmpprod->getSellPrice(
$mysoc, $buyer);
88 $line->subprice = $datapriceofproduct[
'pu_ht'];
89 $line->tva_tx = $datapriceofproduct[
'tva_tx'];
90 $line->product_type = $tmpprod->type;
93 if (empty($line->desc)) {
94 $line->desc = $line->description;
107 global $db, $langs,
$conf, $user;
110 $langs->loadLangs(array(
"sendings"));
115 $head[$h][0] = DOL_URL_ROOT .
"/expedition/card.php?id=" .
$object->id;
116 $head[$h][1] = $langs->trans(
"SendingCard");
117 $head[$h][2] =
'shipping';
121 $head[$h][0] = DOL_URL_ROOT .
"/expedition/dispatch.php?id=" .
$object->id;
122 $head[$h][1] = $langs->trans(
"ShipmentDistribution");
123 $head[$h][2] =
'dispatch';
127 if (
getDolGlobalInt(
'MAIN_SUBMODULE_DELIVERY') && $user->hasRight(
'expedition',
'delivery',
'lire')) {
130 if (isset(
$object->linkedObjectsIds[
'delivery']) && is_array(
$object->linkedObjectsIds[
'delivery']) && count(
$object->linkedObjectsIds[
'delivery']) > 0) {
132 $tmp = reset(
$object->linkedObjectsIds[
'delivery']);
134 $head[$h][0] = DOL_URL_ROOT .
"/delivery/card.php?id=" . ((int) $tmp);
135 $head[$h][1] = $langs->trans(
"DeliveryCard");
136 $head[$h][2] =
'delivery';
145 $objectsrc->fetch(
$object->origin_id);
147 $nbContact = count($objectsrc->liste_contact(-1,
'internal')) + count($objectsrc->liste_contact(-1,
'external'));
148 $head[$h][0] = DOL_URL_ROOT .
"/expedition/contact.php?id=" . ((int)
$object->id);
149 $head[$h][1] = $langs->trans(
"ContactsAddresses");
150 if ($nbContact > 0) {
151 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbContact .
'</span>';
153 $head[$h][2] =
'contact';
158 require_once DOL_DOCUMENT_ROOT .
'/core/lib/files.lib.php';
159 require_once DOL_DOCUMENT_ROOT .
'/core/class/link.class.php';
161 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
163 $head[$h][0] = DOL_URL_ROOT .
'/expedition/document.php?id=' .
$object->id;
164 $head[$h][1] = $langs->trans(
'Documents');
165 if (($nbFiles + $nbLinks) > 0) {
166 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . ($nbFiles + $nbLinks) .
'</span>';
168 $head[$h][2] =
'documents';
173 if (!empty(
$object->note_private)) {
176 if (!empty(
$object->note_public)) {
179 $head[$h][0] = DOL_URL_ROOT .
"/expedition/note.php?id=" .
$object->id;
180 $head[$h][1] = $langs->trans(
"Notes");
182 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbNote .
'</span>';
184 $head[$h][2] =
'note';
188 $head[$h][0] = DOL_URL_ROOT .
'/expedition/agenda.php?id=' .
$object->id;
189 $head[$h][1] = $langs->trans(
"Events");
190 if (
isModEnabled(
'agenda') && ($user->hasRight(
'agenda',
'myactions',
'read') || $user->hasRight(
'agenda',
'allactions',
'read'))) {
193 require_once DOL_DOCUMENT_ROOT .
'/core/lib/memory.lib.php';
194 $cachekey =
'count_events_expedition_' .
$object->id;
196 if (!is_null($dataretrieved)) {
197 $nbEvent = $dataretrieved;
199 $sql =
"SELECT COUNT(id) as nb";
200 $sql .=
" FROM " . MAIN_DB_PREFIX .
"actioncomm";
201 $sql .=
" WHERE fk_element = " . ((int)
$object->id);
202 $sql .=
" AND elementtype = 'shipping'";
203 $resql = $db->query($sql);
205 $obj = $db->fetch_object($resql);
208 dol_syslog(
'Failed to count actioncomm ' . $db->lasterror(), LOG_ERR);
214 $head[$h][1] .= $langs->trans(
"Agenda");
216 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbEvent .
'</span>';
219 $head[$h][2] =
'agenda';
242 global $langs, $db,
$conf, $user;
245 $langs->loadLangs(array(
"sendings"));
250 if (
getDolGlobalInt(
'MAIN_SUBMODULE_EXPEDITION') && $user->hasRight(
'expedition',
'lire')) {
251 $head[$h][0] = DOL_URL_ROOT .
"/expedition/card.php?id=" .
$object->origin_id;
252 $head[$h][1] = $langs->trans(
"SendingCard");
253 $head[$h][2] =
'shipping';
257 $head[$h][0] = DOL_URL_ROOT .
"/delivery/card.php?id=" .
$object->id;
258 $head[$h][1] = $langs->trans(
"DeliveryCard");
259 $head[$h][2] =
'delivery';
274 $tmpobject->fetch(
$object->origin_id);
280 $objectsrc = $tmpobject;
281 if ($tmpobject->origin_type ==
'commande' && $tmpobject->origin_id > 0) {
283 $objectsrc->fetch($tmpobject->origin_id);
285 $nbContact = count($objectsrc->liste_contact(-1,
'internal')) + count($objectsrc->liste_contact(-1,
'external'));
286 $head[$h][0] = DOL_URL_ROOT .
"/expedition/contact.php?id=" . $tmpobject->id;
287 $head[$h][1] = $langs->trans(
"ContactsAddresses");
288 if ($nbContact > 0) {
289 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbContact .
'</span>';
291 $head[$h][2] =
'contact';
296 require_once DOL_DOCUMENT_ROOT .
'/core/lib/files.lib.php';
297 require_once DOL_DOCUMENT_ROOT .
'/core/class/link.class.php';
299 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
300 $nbLinks =
Link::count($db, $tmpobject->element, $tmpobject->id);
301 $head[$h][0] = DOL_URL_ROOT .
'/expedition/document.php?id=' . $tmpobject->id;
302 $head[$h][1] = $langs->trans(
'Documents');
303 if (($nbFiles + $nbLinks) > 0) {
304 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . ($nbFiles + $nbLinks) .
'</span>';
306 $head[$h][2] =
'documents';
311 if (!empty($tmpobject->note_private)) {
314 if (!empty($tmpobject->note_public)) {
317 $head[$h][0] = DOL_URL_ROOT .
"/expedition/note.php?id=" . $tmpobject->id;
318 $head[$h][1] = $langs->trans(
"Notes");
320 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbNote .
'</span>';
322 $head[$h][2] =
'note';
326 $head[$h][0] = DOL_URL_ROOT .
'/expedition/agenda.php?id=' . $tmpobject->id;
327 $head[$h][1] = $langs->trans(
"Events");
328 if (
isModEnabled(
'agenda') && ($user->hasRight(
'agenda',
'myactions',
'read') || $user->hasRight(
'agenda',
'allactions',
'read'))) {
331 require_once DOL_DOCUMENT_ROOT .
'/core/lib/memory.lib.php';
332 $cachekey =
'count_events_expedition_' . $tmpobject->id;
334 if (!is_null($dataretrieved)) {
335 $nbEvent = $dataretrieved;
337 $sql =
"SELECT COUNT(id) as nb";
338 $sql .=
" FROM " . MAIN_DB_PREFIX .
"actioncomm";
339 $sql .=
" WHERE fk_element = " . ((int) $tmpobject->id);
340 $sql .=
" AND elementtype = 'shipping'";
341 $resql = $db->query($sql);
343 $obj = $db->fetch_object($resql);
346 dol_syslog(
'Failed to count actioncomm ' . $db->lasterror(), LOG_ERR);
352 $head[$h][1] .= $langs->trans(
"Agenda");
354 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbEvent .
'</span>';
357 $head[$h][2] =
'agenda';
379function show_list_sending_receive($origin, $origin_id, $filter =
'')
381 global $db,
$conf, $langs;
384 $product_static =
new Product($db);
386 $warehousestatic =
new Entrepot($db);
388 $sql =
"SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, obj.special_code,";
389 $sql .=
" ed.rowid as edrowid, ed.qty as qty_shipped, ed.fk_expedition as expedition_id, ed.fk_elementdet, ed.fk_entrepot as warehouse_id,";
390 $sql .=
" e.rowid as sendingid, e.ref as exp_ref, e.date_creation, e.date_delivery, e.date_expedition, e.billed, e.fk_statut as status, e.signed_status,";
391 $sql .=
' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.tobatch as product_tobatch,';
392 $sql .=
' p.description as product_desc';
393 $sql .=
" FROM " . MAIN_DB_PREFIX .
"expeditiondet as ed,";
394 $sql .=
" " . MAIN_DB_PREFIX .
"expedition as e,";
395 $sql .=
" " . MAIN_DB_PREFIX . $db->sanitize($origin) .
"det as obj";
396 $sql .=
" LEFT JOIN " . MAIN_DB_PREFIX .
"product as p ON obj.fk_product = p.rowid";
398 $sql .=
" WHERE e.entity IN (" .
getEntity(
'expedition') .
")";
399 $sql .=
" AND obj.fk_" . $db->sanitize($origin) .
" = " . ((int) $origin_id);
400 $sql .=
" AND obj.rowid = ed.fk_elementdet";
402 $sql .=
" AND obj.special_code <> " . SUBTOTALS_SPECIAL_CODE;
404 $sql .=
" AND ed.fk_expedition = e.rowid";
408 $sql .=
" ORDER BY obj.rowid, obj.fk_product";
410 dol_syslog(
"show_list_sending_receive", LOG_DEBUG);
411 $resql = $db->query($sql);
413 $num = $db->num_rows($resql);
423 print
'<div class="div-table-responsive-no-min">';
424 print
'<table class="liste centpercent">';
425 print
'<tr class="liste_titre">';
427 print
'<td>' . $langs->trans(
"SendingSheet") .
'</td>';
428 print
'<td>' . $langs->trans(
"Description") .
'</td>';
429 print
'<td class="center">' . $langs->trans(
"DateCreation") .
'</td>';
430 print
'<td class="center">' . $langs->trans(
"DateDeliveryPlanned") .
'</td>';
431 print
'<td class="center">' . $langs->trans(
"QtyPreparedOrShipped") .
'</td>';
433 print
'<td>' . $langs->trans(
"Warehouse") .
'</td>';
442 print
'<td>' . $langs->trans(
"DeliveryOrder") .
'</td>';
444 print
'<td class="right">' . $langs->trans(
"DeliveryDate") .
'</td>';
449 $objp = $db->fetch_object($resql);
451 $expedition->id = $objp->expedition_id;
452 $expedition->ref = $objp->exp_ref;
453 $expedition->billed = $objp->billed;
454 $expedition->statut = $objp->status;
455 $expedition->status = $objp->status;
456 $expedition->signed_status = $objp->signed_status;
458 print
'<tr class="oddeven">';
461 print
'<td class="tdoverflowmax125">';
462 print $expedition->getNomUrl(1);
467 if ($objp->fk_product > 0) {
471 '@phan-var-force CommonObject $object';
476 $prod->id = $objp->fk_product;
477 $prod->getMultiLangs();
479 $outputlangs = $langs;
481 if (
GETPOST(
'lang_id',
'aZ09')) {
482 $newlang =
GETPOST(
'lang_id',
'aZ09');
484 if (empty($newlang)) {
485 $newlang =
$object->thirdparty->default_lang;
487 if (!empty($newlang)) {
489 $outputlangs->setDefaultLang($newlang);
492 $label = (!empty($prod->multilangs[$outputlangs->defaultlang][
"label"])) ? $prod->multilangs[$outputlangs->defaultlang][
"label"] : $objp->product_label;
494 $label = (!empty($objp->label) ? $objp->label : $objp->product_label);
500 $product_static->type = $objp->fk_product_type;
501 $product_static->id = $objp->fk_product;
502 $product_static->ref = $objp->ref;
503 $product_static->status_batch = $objp->product_tobatch;
505 $text = $product_static->getNomUrl(1);
506 $text .=
' - ' . $label;
508 print $form->textwithtooltip($text, $description, 3, 0,
'', (
string) $i);
515 print(!empty($objp->description) ? ((empty($objp->product) || $objp->description != $objp->product) ?
'<br>' .
dol_htmlentitiesbr($objp->description) :
'') :
'');
521 if ($objp->fk_product_type == 1) {
522 $text = img_object($langs->trans(
'Service'),
'service');
524 $text = img_object($langs->trans(
'Product'),
'product');
527 if (!empty($objp->label)) {
528 $text .=
' <strong>' . $objp->label .
'</strong>';
529 print $form->textwithtooltip($text, $objp->description, 3, 0,
'', (
string) $i);
531 print $text .
' ' . nl2br($objp->description);
542 print
'<td class="nowrap center">' .
dol_print_date($db->jdate($objp->date_creation),
'day') .
'</td>';
545 print
'<td class="nowrap center">' .
dol_print_date($db->jdate($objp->date_delivery),
'day') .
'</td>';
548 print
'<td class="center">' . $objp->qty_shipped .
'</td>';
552 print
'<td class="tdoverflowmax125">';
553 if ($objp->warehouse_id > 0) {
554 $warehousestatic->fetch($objp->warehouse_id);
555 print $warehousestatic->getNomUrl(1);
594 include_once DOL_DOCUMENT_ROOT .
'/delivery/class/delivery.class.php';
595 $expedition->fetchObjectLinked($expedition->id, $expedition->element,
null,
'delivery');
599 if (!empty($expedition->linkedObjects[
'delivery'])) {
600 $receiving = reset($expedition->linkedObjects[
'delivery']);
603 if (!empty($receiving)) {
605 '@phan-var-force Delivery $receiving';
613 print $receiving->getNomUrl(1);
623 print
'<td class="right">';
628 print
'<td> </td>';
629 print
'<td> </td>';
641 dol_print_error($db);
if(! $sortfield) if(! $sortorder) $object
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage customers orders.
Class to manage warehouses.
const STATUS_DRAFT
Draft status.
static count($dbs, $objecttype, $objectid)
Return nb of links.
Class to manage products or services.
Class to manage translations.
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_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
print_date_range($date_start, $date_end, $format='', $outputlangs=null)
Format output for start and end date.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
complete_head_from_modules($conf, $langs, $object, &$head, &$h, $type, $mode='add', $filterorigmodule='')
Complete or removed entries into a head array (used to build tabs).
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
dol_setcache($memoryid, $data, $expire=0, $filecache=0, $replace=0)
Save data into a memory area shared by all users, all sessions on server.
dol_getcache($memoryid, $filecache=0)
Read a memory area shared by all users, all sessions on server.
shippingSetStandaloneLineSellPrice($line, $buyer)
Complete a line of a standalone shipment (SHIPMENT_STANDALONE, no source order) before it is copied i...
delivery_prepare_head($object)
Prepare array with list of tabs.
shipping_prepare_head($object)
Prepare array with list of tabs.
shippingGetStandaloneDispatchSourceLine($object, $sourceLineId, $lineId, $productId)
Resolve a standalone dispatch group from the loaded shipment lines.