36require
'../../main.inc.php';
37require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/entrepot.class.php';
38require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
39require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/productlot.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
42require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/productstockentrepot.class.php';
45 require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
48 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formprojet.class.php';
49 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
53 require_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductAttribute.class.php';
54 require_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductAttributeValue.class.php';
55 require_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination.class.php';
56 require_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination2ValuePair.class.php';
68$langs->loadlangs(array(
'products',
'suppliers',
'orders',
'bills',
'stocks',
'sendings',
'margins'));
70 $langs->load(
"productbatch");
73$backtopage =
GETPOST(
'backtopage',
'alpha');
74$action =
GETPOST(
'action',
'aZ09');
75$cancel =
GETPOST(
'cancel',
'alpha');
79$stocklimit = (
GETPOST(
'seuil_stock_alerte') !==
'') ?
GETPOSTFLOAT(
'seuil_stock_alerte') :
null;
81$cancel =
GETPOST(
'cancel',
'alpha');
86$batchnumber =
GETPOST(
'batch_number',
'alphanohtml');
87if (!empty($batchnumber)) {
88 $batchnumber = trim($batchnumber);
90$cost_price =
GETPOST(
'cost_price',
'alpha');
95$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
96$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
98if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
102$offset = $limit * $page;
103$pageprev = $page - 1;
104$pagenext = $page + 1;
109 $socid = $user->socid;
116$extrafields->fetch_name_optionals_label(
$object->table_element);
118if ($id > 0 || !empty($ref)) {
119 $result =
$object->fetch($id, $ref);
122if (empty($id) && !empty(
$object->id)) {
126$modulepart =
'product';
131if (!empty($canvas)) {
132 require_once DOL_DOCUMENT_ROOT.
'/core/class/canvas.class.php';
133 $objcanvas =
new Canvas($db, $action);
134 $objcanvas->getCanvas(
'stockproduct',
'card', $canvas);
138$hookmanager->initHooks(array(
'stockproductcard',
'globalcard'));
144$usercancreadprice =
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') ? $user->hasRight(
'product',
'product_advance',
'read_prices') : $user->hasRight(
'product',
'lire');
145$usercancreadsupplierprice =
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') ? $user->hasRight(
'product',
'product_advance',
'read_supplier_prices') : $user->hasRight(
'product',
'lire');
146$usercanupdatestock = $user->hasRight(
'stock',
'mouvement',
'creer');
149 $label = $langs->trans(
'Service');
150 $usercancreadprice =
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') ? $user->hasRight(
'service',
'service_advance',
'read_prices') : $user->hasRight(
'service',
'lire');
151 $usercancreadsupplierprice =
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') ? $user->hasRight(
'service',
'service_advance',
'read_supplier_prices') : $user->hasRight(
'service',
'lire');
155 if (
$object->type == $object::TYPE_PRODUCT) {
158 if (
$object->type == $object::TYPE_SERVICE) {
162 restrictedArea($user,
'produit|service', $id,
'product&product',
'',
'', $fieldid);
174$parameters = array(
'id' => $id,
'ref' => $ref,
'objcanvas' => $objcanvas);
175$reshook = $hookmanager->executeHooks(
'doActions', $parameters,
$object, $action);
177 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
180if ($action ==
'setcost_price' && $usercancreate) {
186 setEventMessages($langs->trans(
"RecordSaved"),
null,
'mesgs');
195if ($action ==
'addlimitstockwarehouse' && $usercancreate) {
196 $seuil_stock_alerte =
GETPOSTFLOAT(
'seuil_stock_alerte');
200 if ($seuil_stock_alerte ==
'') {
201 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"StockLimit")),
null,
'errors');
204 if ($desiredstock ==
'' || is_array($desiredstock)) {
205 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"DesiredStock")),
null,
'errors');
209 $desiredstock = (float) $desiredstock;
214 if ($pse->fetch(0, $id,
GETPOSTINT(
'fk_entrepot')) > 0) {
216 $pse->seuil_stock_alerte = $seuil_stock_alerte;
217 $pse->desiredstock = $desiredstock;
218 if ($pse->update($user) > 0) {
219 setEventMessages($langs->trans(
'ProductStockWarehouseUpdated'),
null,
'mesgs');
223 $pse->fk_entrepot =
GETPOSTINT(
'fk_entrepot');
224 $pse->fk_product =
$id;
225 $pse->seuil_stock_alerte =
GETPOSTFLOAT(
'seuil_stock_alerte');
227 if ($pse->create($user) > 0) {
228 setEventMessages($langs->trans(
'ProductStockWarehouseCreated'),
null,
'mesgs');
233 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
237if ($action ==
'delete_productstockwarehouse' && $usercancreate) {
240 $pse->fetch(
GETPOSTINT(
'fk_productstockwarehouse'));
241 if ($pse->delete($user) > 0) {
242 setEventMessages($langs->trans(
'ProductStockWarehouseDeleted'),
null,
'mesgs');
249if ($action ==
'setseuil_stock_alerte' && $usercancreate) {
252 $object->seuil_stock_alerte = $stocklimit;
263if ($action ==
'setdesiredstock' && $usercancreate) {
266 $object->desiredstock = $desiredstock;
276if ($action ==
"correct_stock" && !$cancel && $usercanupdatestock) {
278 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Warehouse")),
null,
'errors');
280 $action =
'correction';
283 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"NumberOfUnit")),
null,
'errors');
285 $action =
'correction';
292 if (
$object->hasbatch() && !$batchnumber) {
293 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"batch_number")),
null,
'errors');
295 $action =
'correction';
302 if (is_numeric($nbpiece) && $nbpiece != 0 && $id) {
303 $origin_element =
'';
307 $origin_element =
'project';
316 $disablestockchangeforsubproduct = 0;
317 if (
GETPOST(
'disablesubproductstockchange')) {
318 $disablestockchangeforsubproduct = 1;
322 $result =
$object->correct_stock_batch(
327 GETPOST(
"label",
'alphanohtml'),
332 GETPOST(
'inventorycode',
'alphanohtml'),
335 $disablestockchangeforsubproduct
338 $result =
$object->correct_stock(
343 GETPOST(
"label",
'alphanohtml'),
345 GETPOST(
'inventorycode',
'alphanohtml'),
348 $disablestockchangeforsubproduct
354 header(
"Location: ".$backtopage);
357 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".
$object->id);
362 $action =
'correction';
369if ($action ==
"transfert_stock" && !$cancel && $usercanupdatestock) {
371 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Warehouse")),
null,
'errors');
373 $action =
'transfer';
376 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"NumberOfUnit")),
null,
'errors');
378 $action =
'transfer';
381 setEventMessages($langs->trans(
"ErrorSrcAndTargetWarehouseMustDiffers"),
null,
'errors');
383 $action =
'transfer';
389 if (
$object->hasbatch() && !$batchnumber) {
390 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"batch_number")),
null,
'errors');
392 $action =
'transfer';
408 $object->load_stock(
'novirtual');
415 $pricedest = $pricesrc;
425 $result = $pdluo->fetch($pdluoid);
426 if ($result > 0 && $pdluo->id > 0 && $pdluo->fk_product ==
$object->id) {
429 $batch = $pdluo->batch;
430 $eatby = $pdluo->eatby;
431 $sellby = $pdluo->sellby;
433 setEventMessages($pdluo->error ? $pdluo->error : $langs->trans(
'ErrorRecordNotFound'), $pdluo->errors,
'errors');
438 $batch = $batchnumber;
447 $result1 =
$object->correct_stock_batch(
452 GETPOST(
"label",
'alphanohtml'),
457 GETPOST(
'inventorycode',
'alphanohtml')
465 $result2 =
$object->correct_stock_batch(
470 GETPOST(
"label",
'alphanohtml'),
475 GETPOST(
'inventorycode',
'alphanohtml')
484 $result1 =
$object->correct_stock(
489 GETPOST(
"label",
'alphanohtml'),
491 GETPOST(
'inventorycode',
'alphanohtml')
499 $result2 =
$object->correct_stock(
504 GETPOST(
"label",
'alphanohtml'),
506 GETPOST(
'inventorycode',
'alphanohtml')
515 if (!$error && $result1 >= 0 && $result2 >= 0) {
519 header(
"Location: ".$backtopage);
522 header(
"Location: product.php?id=".
$object->id);
528 $action =
'transfer';
538$form =
new Form($db);
548if ($id > 0 || $ref) {
550 $result =
$object->fetch($id, $ref);
552 $iskit =
$object->hasFatherOrChild(1);
554 $variants =
$object->hasVariants();
558 $title = $langs->trans(
'ProductServiceCard');
562 $title = $langs->trans(
'Product').
" ".$shortlabel.
" - ".$langs->trans(
'Stock');
563 $helpurl =
'EN:Module_Products|FR:Module_Produits|ES:Módulo_Productos';
566 $title = $langs->trans(
'Service').
" ".$shortlabel.
" - ".$langs->trans(
'Stock');
567 $helpurl =
'EN:Module_Services_En|FR:Module_Services|ES:Módulo_Servicios';
570 llxHeader(
'', $title, $helpurl,
'', 0, 0,
'',
'',
'',
'mod-product page-card_stock_product');
572 if (!empty(
$conf->use_javascript_ajax)) {
574 <script
type=
"text/javascript">
575 $(document).ready(
function() {
576 $(
".collapse_batch").click(
function() {
577 console.log(
"We click on collapse_batch");
578 var id_entrepot = $(
this).attr(
'id').replace(
'ent',
'');
580 if($(
this).text().indexOf(
'+') > 0) {
581 $(
".batch_warehouse" + id_entrepot).show();
583 jQuery(
"#show_all").hide();
584 jQuery(
"#hide_all").show();
587 $(
".batch_warehouse" + id_entrepot).hide();
594 $(
"#show_all").click(
function() {
595 console.log(
"We click on show_all");
596 $(
"[class^=batch_warehouse]").show();
597 $(
"[class^=collapse_batch]").html(
'(-)');
598 jQuery(
"#show_all").hide();
599 jQuery(
"#hide_all").show();
603 $(
"#hide_all").click(
function() {
604 console.log(
"We click on hide_all");
605 $(
"[class^=batch_warehouse]").hide();
606 $(
"[class^=collapse_batch]").html(
'(+)');
607 jQuery(
"#hide_all").hide();
608 jQuery(
"#show_all").show();
619 $titre = $langs->trans(
"CardProduct".
$object->type);
626 $linkback =
'<a href="'.DOL_URL_ROOT.
'/product/list.php?restore_lastsearch_values=1&type='.
$object->type.
'">'.$langs->trans(
"BackToList").
'</a>';
627 $object->next_prev_filter =
"(te.fk_product_type:=:".((int)
$object->type).
")";
630 if ($user->socid && !in_array(
'stock', explode(
',',
getDolGlobalString(
'MAIN_MODULES_FOR_EXTERNAL')))) {
634 dol_banner_tab(
$object,
'ref', $linkback, $shownav,
'ref');
637 print
'<div class="fichecenter">';
639 print
'<div class="fichehalfleft">';
640 print
'<div class="underbanner clearboth"></div>';
642 print
'<table class="border tableforfield centpercent">';
646 $typeformat =
'select;0:'.$langs->trans(
"Product").
',1:'.$langs->trans(
"Service");
647 print
'<tr><td class="titlefieldmiddle">';
648 print (!
getDolGlobalString(
'PRODUCT_DENY_CHANGE_PRODUCT_TYPE')) ? $form->editfieldkey(
"Type",
'fk_product_type', (
string)
$object->type,
$object, 0, $typeformat) : $langs->trans(
'Type');
650 print $form->editfieldval(
"Type",
'fk_product_type',
$object->type,
$object, 0, $typeformat);
656 print
'<tr><td>' . $form->textwithpicto($langs->trans(
"StockableProduct"), $langs->trans(
'StockableProductDescription')) .
'</td>';
659 print
'<input type="checkbox" readonly disabled> <span class="opacitymedium">' . $langs->trans(
"NotSupportedOnKits").
'</span>';
661 print
'<input type="checkbox" readonly disabled '.($object->stockable_product == 1 ?
'checked' :
'').
'>';
665 if (
$object->isStockManaged() && !$iskit) {
667 $warehouse->fetch(
$object->fk_default_warehouse);
669 print
'<tr><td>'.$langs->trans(
"DefaultWarehouse").
'</td><td>';
670 print(!empty($warehouse->id) ? $warehouse->getNomUrl(1) :
'');
676 print
'<tr><td class="titlefieldmiddle">'.$langs->trans(
"ManageLotSerial").
'</td><td>';
677 print
$object->getLibStatut(0, 2);
683 $textdesc = $langs->trans(
"CostPriceDescription");
684 $textdesc .=
"<br>".$langs->trans(
"CostPriceUsage");
685 $text = $form->textwithpicto($langs->trans(
"CostPrice"), $textdesc, 1,
'help',
'');
686 if (!$usercancreadsupplierprice) {
687 print $form->editfieldkey($text,
'cost_price',
'',
$object, 0,
'amount:6');
689 print $form->editfieldval($text,
'cost_price',
'',
$object, 0,
'amount:6');
691 print $form->editfieldkey($text,
'cost_price', (
string)
$object->cost_price,
$object, (
int) $usercancreate,
'amount:6');
693 print $form->editfieldval($text,
'cost_price',
$object->cost_price,
$object, $usercancreate,
'amount:6');
700 print
'<tr><td class="titlefieldmiddle">';
701 print $form->textwithpicto($langs->trans(
"AverageUnitPricePMPShort"), $langs->trans(
"AverageUnitPricePMPDesc"));
704 if (
$object->pmp > 0 && $usercancreadsupplierprice) {
711 print
'<tr><td>'.$langs->trans(
"BuyingPriceMin").
'</td>';
714 if ($product_fourn->find_min_price_product_fournisseur(
$object->id) > 0) {
715 if ($product_fourn->product_fourn_price_id > 0 && $usercancreadsupplierprice) {
716 print $product_fourn->display_price_product_fournisseur();
718 print $langs->trans(
"NotDefined");
725 print
'<tr><td>'.$langs->trans(
"SellingPrice").
'</td><td>';
726 if ($usercancreadprice) {
727 if (
$object->price_base_type ==
'TTC') {
736 print
'<tr><td>'.$langs->trans(
"MinPrice").
'</td><td>';
737 if ($usercancreadprice) {
738 if (
$object->price_base_type ==
'TTC') {
747 print
'<tr><td>'.$langs->trans(
"SellingPrice").
'</td><td>';
748 print
'<span class="opacitymedium">'.$langs->trans(
"Variable").
'</span>';
752 print
'<tr><td>'.$langs->trans(
"MinPrice").
'</td><td>';
753 print
'<span class="opacitymedium">'.$langs->trans(
"Variable").
'</span>';
758 $parameters = array();
759 $reshook = $hookmanager->executeHooks(
'formObjectOptions', $parameters,
$object, $action);
760 print $hookmanager->resPrint;
765 print
'<div class="fichehalfright"><div class="underbanner clearboth"></div>';
767 if (!$iskit ||
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) {
768 print
'<table class="border tableforfield centpercent">';
771 print
'<tr><td>'.$form->editfieldkey($form->textwithpicto($langs->trans(
"StockLimit"), $langs->trans(
"StockLimitDesc"), 1),
'seuil_stock_alerte', (
string)
$object->seuil_stock_alerte,
$object, $user->hasRight(
'produit',
'creer')).
'</td><td>';
772 print $form->editfieldval(
"StockLimit",
'seuil_stock_alerte',
$object->seuil_stock_alerte,
$object, $user->hasRight(
'produit',
'creer'),
'string');
776 print
'<tr><td>'.$form->editfieldkey($form->textwithpicto($langs->trans(
"DesiredStock"), $langs->trans(
"DesiredStockDesc"), 1),
'desiredstock', (
string)
$object->desiredstock,
$object, $user->hasRight(
'produit',
'creer'));
778 print $form->editfieldval(
"DesiredStock",
'desiredstock',
$object->desiredstock,
$object, $user->hasRight(
'produit',
'creer'),
'string');
782 $text_stock_options = $langs->trans(
"RealStockDesc").
'<br>';
783 $text_stock_options .= $langs->trans(
"RealStockWillAutomaticallyWhen").
'<br>';
784 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT') ||
getDolGlobalString(
'STOCK_CALCULATE_ON_SHIPMENT_CLOSE') ?
'- '.$langs->trans(
"DeStockOnShipment").
'<br>' :
'');
785 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_VALIDATE_ORDER') ?
'- '.$langs->trans(
"DeStockOnValidateOrder").
'<br>' :
'');
786 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_BILL') ?
'- '.$langs->trans(
"DeStockOnBill").
'<br>' :
'');
787 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_BILL') ?
'- '.$langs->trans(
"ReStockOnBill").
'<br>' :
'');
788 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER') ?
'- '.$langs->trans(
"ReStockOnValidateOrder").
'<br>' :
'');
789 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER') ?
'- '.$langs->trans(
"ReStockOnDispatchOrder").
'<br>' :
'');
790 $text_stock_options .= (
getDolGlobalString(
'STOCK_CALCULATE_ON_RECEPTION') ||
getDolGlobalString(
'STOCK_CALCULATE_ON_RECEPTION_CLOSE') ?
'- '.$langs->trans(
"StockOnReception").
'<br>' :
'');
791 $parameters = array();
792 $reshook = $hookmanager->executeHooks(
'physicalStockTextStockOptions', $parameters,
$object, $action);
794 $text_stock_options = $hookmanager->resPrint;
795 } elseif ($reshook == 0) {
796 $text_stock_options .= $hookmanager->resPrint;
798 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
802 print $form->textwithpicto($langs->trans(
"PhysicalStock"), $text_stock_options, 1);
804 print
'<td>'.price2num(
$object->stock_reel,
'MS');
806 print
' '.img_warning($langs->trans(
"StockLowerThanLimit",
$object->seuil_stock_alerte));
809 print
' <a href="'.DOL_URL_ROOT.
'/product/stock/stockatdate.php?productid='.
$object->id.
'">'.$langs->trans(
"StockAtDate").
'</a>';
816 $helpondiff =
'<strong>'.$langs->trans(
"StockDiffPhysicTeoric").
':</strong><br>';
820 $helpondiff .=
'<br>';
824 $helpondiff .= $langs->trans(
"ProductQtyInCustomersOrdersRunning").
': '.
$object->stats_commande[
'qty'];
825 $result =
$object->load_stats_commande(0,
'0', 1);
827 dol_print_error($db,
$object->error);
829 $helpondiff .=
' <span class="opacitymedium">('.$langs->trans(
"ProductQtyInDraft").
': '.
$object->stats_commande[
'qty'].
')</span>';
834 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
835 $filterShipmentStatus =
'';
842 $helpondiff .=
'<br>';
846 $result =
$object->load_stats_sending(0,
'2', 1, $filterShipmentStatus);
847 $helpondiff .= $langs->trans(
"ProductQtyInShipmentAlreadySent").
': '.
$object->stats_expedition[
'qty'];
853 $helpondiff .=
'<br>';
857 $result =
$object->load_stats_commande_fournisseur(0,
'3,4', 1);
858 $helpondiff .= $langs->trans(
"ProductQtyInSuppliersOrdersRunning").
': '.
$object->stats_commande_fournisseur[
'qty'];
859 $result =
$object->load_stats_commande_fournisseur(0,
'0,1,2', 1);
861 dol_print_error($db,
$object->error);
863 $helpondiff .=
' <span class="opacitymedium">('.$langs->trans(
"ProductQtyInDraftOrWaitingApproved").
': '.
$object->stats_commande_fournisseur[
'qty'].
')</span>';
869 $helpondiff .=
'<br>';
873 $helpondiff .= $langs->trans(
"ProductQtyInSuppliersShipmentAlreadyRecevied").
': '.
$object->stats_reception[
'qty'];
879 $helpondiff .=
'<br>';
883 $helpondiff .= $langs->trans(
"ProductQtyToConsumeByMO").
': '.
$object->stats_mrptoconsume[
'qty'].
'<br>';
884 $helpondiff .= $langs->trans(
"ProductQtyToProduceByMO").
': '.
$object->stats_mrptoproduce[
'qty'];
886 $parameters = array(
'found' => &$found,
'id' =>
$object->id,
'includedraftpoforvirtual' =>
null);
887 $reshook = $hookmanager->executeHooks(
'virtualStockHelpOnDiff', $parameters,
$object, $action);
889 $helpondiff = $hookmanager->resPrint;
890 } elseif ($reshook == 0) {
891 $helpondiff .= $hookmanager->resPrint;
893 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
899 print $form->textwithpicto($langs->trans(
"VirtualStock"), $langs->trans(
"VirtualStockDesc"));
903 print $form->textwithpicto((empty($stocktheo) ? 0 : $stocktheo), $helpondiff);
905 print
' '.img_warning($langs->trans(
"StockLowerThanLimit",
$object->seuil_stock_alerte));
907 print
' <a href="'.DOL_URL_ROOT.
'/product/stock/stockatdate.php?mode=future&productid='.
$object->id.
'">'.$langs->trans(
"VirtualStockAtDate").
'</a>';
912 if ($user->hasRight(
'stock',
'mouvement',
'lire')) {
913 $sql =
"SELECT max(m.datem) as datem";
914 $sql .=
" FROM ".MAIN_DB_PREFIX.
"stock_mouvement as m";
915 $sql .=
" WHERE m.fk_product = ".((int)
$object->id);
916 $lastmovementdate = 0;
917 $resqlbis = $db->query($sql);
919 $obj = $db->fetch_object($resqlbis);
920 $lastmovementdate = $db->jdate($obj->datem);
922 dol_print_error($db);
924 print
'<tr><td class="tdtop">'.$langs->trans(
"LastMovement").
'</td><td>';
925 if ($lastmovementdate) {
927 print
' ';
928 print img_picto($langs->trans(
"StockMovement"),
'movement',
'class="pictofixedwidth"');
929 print
'<a href="'.DOL_URL_ROOT.
'/product/stock/movement_list.php?idproduct='.
$object->id.
'">'.$langs->trans(
"FullList").
'</a>';
931 print img_picto($langs->trans(
"StockMovement"),
'movement',
'class="pictofixedwidth"');
932 print
'<a href="'.DOL_URL_ROOT.
'/product/stock/movement_list.php?idproduct='.
$object->id.
'">'.$langs->trans(
"None").
'</a>';
943 print
'<div class="clearboth"></div>';
950 if ($action ==
"correction") {
951 include DOL_DOCUMENT_ROOT.
'/product/stock/tpl/stockcorrection.tpl.php';
956 if ($action ==
"transfer") {
957 include DOL_DOCUMENT_ROOT.
'/product/stock/tpl/stocktransfer.tpl.php';
965$showstockdetails = 1;
966if ($variants && !
getDolGlobalString(
'VARIANT_ALLOW_STOCK_MOVEMENT_ON_VARIANT_PARENT')) {
967 $showstockdetails = 0;
969if ($iskit && !
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE')) {
970 $showstockdetails = 0;
977$parameters = array();
979$reshook = $hookmanager->executeHooks(
'addMoreActionsButtons', $parameters,
$object, $action);
980if (empty($reshook)) {
981 if (empty($action) &&
$object->id) {
982 if ($showstockdetails) {
983 print
'<div class="tabsAction">'.
"\n";
985 if ($user->hasRight(
'stock',
'mouvement',
'creer')) {
986 if (!$variants ||
getDolGlobalString(
'VARIANT_ALLOW_STOCK_MOVEMENT_ON_VARIANT_PARENT')) {
987 print
'<a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=transfer&token='.
newToken().
'">'.$langs->trans(
"TransferStock").
'</a>';
989 print
'<a class="butActionRefused classfortooltip" href="#" title="'.$langs->trans(
"ActionAvailableOnVariantProductOnly").
'">'.$langs->trans(
"TransferStock").
'</a>';
992 print
'<a class="butActionRefused classfortooltip" href="#" title="'.$langs->trans(
"NotEnoughPermissions").
'">'.$langs->trans(
"TransferStock").
'</a>';
995 if ($user->hasRight(
'stock',
'mouvement',
'creer')) {
996 if (!$variants ||
getDolGlobalString(
'VARIANT_ALLOW_STOCK_MOVEMENT_ON_VARIANT_PARENT')) {
997 print
'<a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=correction&token='.
newToken().
'">'.$langs->trans(
"CorrectStock").
'</a>';
999 print
'<a class="butActionRefused classfortooltip" href="#" title="'.$langs->trans(
"ActionAvailableOnVariantProductOnly").
'">'.$langs->trans(
"CorrectStock").
'</a>';
1002 print
'<a class="butActionRefused classfortooltip" href="#" title="'.$langs->trans(
"NotEnoughPermissions").
'">'.$langs->trans(
"CorrectStock").
'</a>';
1011if ($showstockdetails) {
1016 print
'<div class="div-table-responsive">';
1017 print
'<table class="noborder centpercent">';
1019 print
'<tr class="liste_titre">';
1020 print
'<td colspan="4">'.$langs->trans(
"Warehouse").
'</td>';
1021 print
'<td class="right">'.$langs->trans(
"NumberOfUnit").
'</td>';
1022 print
'<td class="right">'.$form->textwithpicto($langs->trans(
"AverageUnitPricePMPShort"), $langs->trans(
"AverageUnitPricePMPDesc")).
'</td>';
1023 print
'<td class="right">'.$langs->trans(
"EstimatedStockValueShort").
'</td>';
1024 print
'<td class="right">'.$langs->trans(
"SellPriceMin").
'</td>';
1025 print
'<td class="right">'.$langs->trans(
"EstimatedStockValueSellShort").
'</td>';
1032 print
'<tr class="liste_titre"><td class="minwidth200">';
1033 if (!empty(
$conf->use_javascript_ajax)) {
1034 print
'<a id="show_all" href="#" class="hideobject">'.img_picto(
'',
'folder-open',
'class="paddingright"').$langs->trans(
"ShowAllLots").
'</a>';
1036 print
'<a id="hide_all" href="#">'.img_picto(
'',
'folder',
'class="paddingright"').$langs->trans(
"HideLots").
'</a>';
1040 print
'<td class="right">'.$langs->trans(
"batch_number").
'</td>';
1043 print
'<td class="center width100">'.$langs->trans(
"SellByDate").
'</td>';
1047 print
'<td class="center width100">'.$langs->trans(
"EatByDate").
'</td>';
1049 print
'<td colspan="'.$colspan.
'"></td>';
1059 $sql =
"SELECT e.rowid, e.ref, e.lieu, e.fk_parent, e.statut as status, ps.reel, ps.rowid as product_stock_id, p.pmp";
1060 $sql .=
" FROM ".MAIN_DB_PREFIX.
"entrepot as e,";
1061 $sql .=
" ".MAIN_DB_PREFIX.
"product_stock as ps";
1062 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON p.rowid = ps.fk_product";
1063 $sql .=
" WHERE ps.reel != 0";
1064 $sql .=
" AND ps.fk_entrepot = e.rowid";
1065 $sql .=
" AND e.entity IN (".getEntity(
'stock').
")";
1066 $sql .=
" AND ps.fk_product = ".((int)
$object->id);
1067 $sql .=
" ORDER BY e.ref";
1069 $entrepotstatic =
new Entrepot($db);
1074 $totalvalue = $totalvaluesell = 0;
1077 $resql = $db->query($sql);
1079 $num = $db->num_rows($resql);
1080 $total = $totalwithpmp;
1084 $obj = $db->fetch_object($resql);
1086 $entrepotstatic->id = $obj->rowid;
1087 $entrepotstatic->ref = $obj->ref;
1088 $entrepotstatic->label = $obj->ref;
1089 $entrepotstatic->lieu = $obj->lieu;
1090 $entrepotstatic->fk_parent = $obj->fk_parent;
1091 $entrepotstatic->statut = $obj->status;
1092 $entrepotstatic->status = $obj->status;
1094 $stock_real =
price2num($obj->reel,
'MS');
1095 print
'<tr class="oddeven">';
1098 print
'<td colspan="4">';
1099 print $entrepotstatic->getNomUrl(1);
1101 print
'<a class="collapse_batch marginleftonly" id="ent' . $entrepotstatic->id .
'" href="#">';
1107 print
'<td class="right">'.$stock_real.($stock_real < 0 ?
' '.img_warning() :
'').
'</td>';
1113 if ($usercancreadsupplierprice) {
1114 print
'<td class="right amount nowraponall">'.(price2num(
$object->pmp) ?
price(
price2num(
$object->pmp * $obj->reel,
'MT')) :
'').
'</td>';
1116 print
'<td class="right amount nowraponall"></td>';
1120 $minsellprice =
null;
1121 $maxsellprice =
null;
1122 print
'<td class="right nowraponall">';
1124 foreach (
$object->multiprices as $priceforlevel) {
1125 if (is_numeric($priceforlevel)) {
1126 if (is_null($maxsellprice) || $priceforlevel > $maxsellprice) {
1127 $maxsellprice = $priceforlevel;
1129 if (is_null($minsellprice) || $priceforlevel < $minsellprice) {
1130 $minsellprice = $priceforlevel;
1134 print
'<span class="valignmiddle">';
1135 if ($usercancreadprice) {
1136 if ($minsellprice != $maxsellprice) {
1143 print $form->textwithpicto(
'', $langs->trans(
"Variable"));
1144 } elseif ($usercancreadprice) {
1150 print
'<td class="right amount nowraponall">';
1152 print
'<span class="valignmiddle">';
1153 if ($usercancreadprice) {
1154 if ($minsellprice != $maxsellprice) {
1161 print $form->textwithpicto(
'', $langs->trans(
"Variable"));
1163 if ($usercancreadprice) {
1171 $total += $obj->reel;
1173 $totalwithpmp += $obj->reel;
1175 $totalvalue += (
$object->pmp * $obj->reel);
1176 $totalvaluesell += (
$object->price * $obj->reel);
1181 dol_print_error($db);
1183 foreach ($details as $pdluo) {
1184 $product_lot_static->id = $pdluo->lotid;
1185 $product_lot_static->batch = $pdluo->batch;
1186 $product_lot_static->eatby = $pdluo->eatby;
1187 $product_lot_static->sellby = $pdluo->sellby;
1189 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $pdluo->id) {
1191 print
'<td colspan="9">';
1192 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
1193 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1194 print
'<input type="hidden" name="pdluoid" value="'.$pdluo->id.
'"><input type="hidden" name="action" value="updateline"><input type="hidden" name="id" value="'.
$id.
'"><table class="noborder centpercent"><tr><td width="10%"></td>';
1195 print
'<td class="right" width="10%"><input type="text" name="batch_number" value="'.$pdluo->batch.
'"></td>';
1197 print
'<td class="center" width="10%">';
1198 print $form->selectDate($pdluo->sellby,
'sellby', 0, 0, 1,
'', 1, 0);
1202 print
'<td class="center" width="10%">';
1203 print $form->selectDate($pdluo->eatby,
'eatby', 0, 0, 1,
'', 1, 0);
1206 print
'<td class="right" colspan="3">'.$pdluo->qty.($pdluo->qty < 0 ?
' '.img_warning() :
'').
'</td>';
1207 print
'<td colspan="4"><input type="submit" class="button button-save" id="savelinebutton marginbottomonly" name="save" value="'.$langs->trans(
"Save").
'">';
1208 print
'<input type="submit" class="button button-cancel" id="cancellinebutton" name="Cancel" value="'.$langs->trans(
"Cancel").
'"></td></tr>';
1216 print
"\n".
'<tr style="display:'.(!
getDolGlobalString(
'STOCK_SHOW_ALL_BATCH_BY_DEFAULT') ?
'none' :
'visible').
';" class="batch_warehouse'.$entrepotstatic->id.
'"><td class="left">';
1218 print
'<td class="right nowraponall">';
1219 if ($product_lot_static->id > 0) {
1220 print $product_lot_static->getNomUrl(1);
1222 print $product_lot_static->getNomUrl(1,
'nolink');
1228 print
'<td class="center">'.dol_print_date($pdluo->sellby,
'day').
'</td>';
1232 print
'<td class="center">'.dol_print_date($pdluo->eatby,
'day').
'</td>';
1234 print
'<td class="right" colspan="'.$colspan.
'">'.$pdluo->qty.($pdluo->qty < 0 ?
' '.img_warning() : (($pdluo->qty > 1 &&
$object->status_batch == 2) ?
' '.img_warning($langs->trans(
'IlligalQtyForSerialNumbers')) :
'')).
'</td>';
1235 print
'<td colspan="4"></td>';
1236 print
'<td class="center tdoverflowmax125" title="'.dol_escape_htmltag($langs->trans(
"TransferStock")).
'">';
1237 if ($entrepotstatic->status != $entrepotstatic::STATUS_CLOSED) {
1238 print
'<a href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&id_entrepot='.$entrepotstatic->id.
'&action=transfer&pdluoid='.$pdluo->id.
'&token='.
newToken().
'">';
1239 print img_picto($langs->trans(
"TransferStock"),
'add',
'class="hideonsmartphone paddingright" style="color: #a69944"');
1240 print $langs->trans(
"TransferStock");
1248 print
'<td class="center tdoverflowmax125" title="'.dol_escape_htmltag($langs->trans(
"CorrectStock")).
'">';
1249 if ($entrepotstatic->status != $entrepotstatic::STATUS_CLOSED) {
1250 print
'<a href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&id_entrepot='.$entrepotstatic->id.
'&action=correction&pdluoid='.$pdluo->id.
'&token='.
newToken().
'">';
1251 print img_picto($langs->trans(
"CorrectStock"),
'add',
'class="hideonsmartphone paddingright" style="color: #a69944"');
1252 print $langs->trans(
"CorrectStock");
1267 dol_print_error($db);
1271 print
'<tr class="liste_total"><td class="right liste_total" colspan="4">'.$langs->trans(
"Total").
':</td>';
1272 print
'<td class="liste_total right">'.price2num($total,
'MS').
'</td>';
1273 print
'<td class="liste_total right">';
1274 if ($usercancreadsupplierprice) {
1275 print($totalwithpmp ?
price(
price2num($totalvalue / $totalwithpmp,
'MU')) :
' ');
1279 print
'<td class="liste_total right">';
1280 if ($usercancreadsupplierprice) {
1281 print $totalvalue ?
price(
price2num($totalvalue,
'MT'), 1) :
' ';
1284 print
'<td class="liste_total right">';
1287 print
'<span class="valignmiddle">';
1289 print $form->textwithpicto(
'', $langs->trans(
"Variable"));
1290 } elseif ($usercancreadprice) {
1291 print
price($totalvaluesell / $total, 1);
1298 print
'<td class="liste_total right amount">';
1300 print
'<span class="valignmiddle">';
1304 print $form->textwithpicto(
'', $langs->trans(
"Variable"));
1321 if ($user->hasRight(
'produit',
'creer')) {
1322 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
1323 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1324 print
'<input type="hidden" name="action" value="addlimitstockwarehouse">';
1325 print
'<input type="hidden" name="id" value="'.$id.
'">';
1327 print
'<table class="noborder centpercent">';
1328 if ($user->hasRight(
'produit',
'creer')) {
1329 print
'<tr class="liste_titre"><td>'.$formproduct->selectWarehouses(
'',
'fk_entrepot').
'</td>';
1330 print
'<td class="right"><input name="seuil_stock_alerte" type="text" placeholder="'.$langs->trans(
"StockLimit").
'" /></td>';
1331 print
'<td class="right"><input name="desiredstock" type="text" placeholder="'.$langs->trans(
"DesiredStock").
'" /></td>';
1332 print
'<td class="right"><input type="submit" value="'.$langs->trans(
"Save").
'" class="button button-save" /></td>';
1335 print
'<tr class="liste_titre"><td>'.$langs->trans(
"Warehouse").
'</td>';
1336 print
'<td class="right">'.$langs->trans(
"StockLimit").
'</td>';
1337 print
'<td class="right">'.$langs->trans(
"DesiredStock").
'</td>';
1342 $lines = $pse->fetchAll($id);
1344 $visibleWarehouseEntities = explode(
',',
getEntity(
'stock'));
1346 if (!empty($lines)) {
1348 foreach ($lines as $line) {
1350 $ent->fetch($line[
'fk_entrepot']);
1352 if (!
isModEnabled(
"multicompany") || in_array($ent->entity, $visibleWarehouseEntities)) {
1354 print
'<tr class="oddeven"><td>'.$ent->getNomUrl(3).
'</td>';
1355 print
'<td class="right">'.$line[
'seuil_stock_alerte'].
'</td>';
1356 print
'<td class="right">'.$line[
'desiredstock'].
'</td>';
1357 if ($user->hasRight(
'produit',
'creer')) {
1358 print
'<td class="right"><a href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$id.
'&fk_productstockwarehouse='.$line[
'id'].
'&action=delete_productstockwarehouse&token='.
newToken().
'">'.img_delete().
'</a></td>';
1367 if ($user->hasRight(
'produit',
'creer')) {
1375 include_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination.class.php';
1376 include_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination2ValuePair.class.php';
1377 $prodstatic =
new Product($db);
1380 $productCombinations = $prodcomb->fetchAllByFkProductParent(
$object->id);
1382 print
'<form method="POST" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
1383 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1384 print
'<input type="hidden" name="action" value="massaction">';
1385 print
'<input type="hidden" name="id" value="'.$id.
'">';
1386 print
'<input type="hidden" name="backtopage" value="'.$backtopage.
'">';
1389 $title = $langs->trans(
"ProductCombinations");
1391 print_barre_liste($title, 0, $_SERVER[
"PHP_SELF"],
'', $sortfield, $sortorder,
'', 0);
1393 print
'<div class="div-table-responsive">'; ?>
1394 <
table class=
"liste">
1395 <tr
class=
"liste_titre">
1396 <td
class=
"liste_titre"><?php echo $langs->trans(
'Product') ?></td>
1397 <td
class=
"liste_titre"><?php echo $langs->trans(
'Combination') ?></td>
1398 <td
class=
"liste_titre center"><?php echo $langs->trans(
'OnSell') ?></td>
1399 <td
class=
"liste_titre center"><?php echo $langs->trans(
'OnBuy') ?></td>
1400 <td
class=
"liste_titre right"><?php echo $langs->trans(
'Stock') ?></td>
1401 <td
class=
"liste_titre"></td>
1405 if (count($productCombinations)) {
1407 foreach ($productCombinations as $currcomb) {
1408 $prodstatic->fetch($currcomb->fk_product_child);
1409 $prodstatic->load_stock();
1410 $stock_total += $prodstatic->stock_reel; ?>
1411 <tr
class=
"oddeven">
1412 <td><?php echo $prodstatic->getNomUrl(1) ?></td>
1416 $productCombination2ValuePairs = $comb2val->fetchByFkCombination($currcomb->id);
1417 $iMax = count($productCombination2ValuePairs);
1419 for ($i = 0; $i < $iMax; $i++) {
1422 if ($i !== ($iMax - 1)) {
1427 <td style=
"text-align: center;"><?php echo $prodstatic->getLibStatut(2, 0) ?></td>
1428 <td style=
"text-align: center;"><?php echo $prodstatic->getLibStatut(2, 1) ?></td>
1429 <td
class=
"right"><?php echo $prodstatic->stock_reel ?></td>
1431 <a
class=
"paddingleft paddingright editfielda" href=
"<?php echo dol_buildpath('/product/stock/product.php?id='.$currcomb->fk_product_child, 2) ?>"><?php echo img_edit() ?></a>
1439 print
'<tr class="liste_total">';
1440 print
'<td colspan="4" class="left">'.$langs->trans(
"Total").
'</td>';
1441 print
'<td class="right">'.$stock_total.
'</td>';
1445 print
'<tr><td colspan="8"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
$propal type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
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 warehouses.
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...
Class ProductCombination2ValuePair Used to represent the relation between a variant and its attribute...
Class ProductCombination Used to represent the relation between a product and one of its variants.
Class to manage predefined suppliers products.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
const TYPE_SERVICE
Service.
Class ProductStockEntrepot.
Manage record for batch number management.
static findAll($dbs, $fk_product_stock, $with_qty=0, $fk_product=0)
Return all batch detail records for a given product and warehouse.
Class with list of lots and properties.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTFLOAT($paramname, $rounding='', $option=2)
Return the value of a $_GET or $_POST supervariable, converted into float.
dol_htmlentities($string, $flags=ENT_QUOTES|ENT_SUBSTITUTE, $encoding='UTF-8', $double_encode=false)
Replace htmlentities functions.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
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).
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '...' if string larger than length.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_htmloutput_events($disabledoutputofmessages=0)
Print formatted messages to output (Used to show messages on html output).
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
product_prepare_head($object)
Prepare array with list of tabs.
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.
treeview li table
No Email.