32require
'../main.inc.php';
33require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
34require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
35require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
36require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
39$langs->loadLangs(array(
'products',
'stocks'));
41$action =
GETPOST(
'action',
'aZ09');
42$sref =
GETPOST(
"sref",
'alpha');
43$snom =
GETPOST(
"snom",
'alpha');
44$sall = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
46$search_barcode =
GETPOST(
"search_barcode",
'alpha');
47$search_toolowstock =
GETPOST(
'search_toolowstock');
52$search_stock_physique =
GETPOST(
'search_stock_physique',
'alpha');
54$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
55$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
57if (empty($page) || $page < 0) {
67if (empty($page) || $page == -1) {
70$offset = $limit * $page;
73$search_sale =
GETPOST(
"search_sale");
74if (GETPOSTISSET(
'catid')) {
84 require_once DOL_DOCUMENT_ROOT.
'/core/class/canvas.class.php';
85 $objcanvas =
new Canvas($db, $action);
86 $objcanvas->getCanvas(
'product',
'list', $canvas);
90$virtualdiffersfromphysical = 0;
96 || isModEnabled(
'mrp')) {
97 $virtualdiffersfromphysical = 1;
101$hookmanager->initHooks(array(
'productreassortlist'));
104 $socid = $user->socid;
106$result =
restrictedArea($user,
'produit|service', 0,
'product&product');
116if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
124 $search_toolowstock =
'';
127 $search_stock_physique =
'';
136$helpurl =
'EN:Module_Stocks_En|FR:Module_Stock|ES:Módulo_Stocks';
138$form =
new Form($db);
140if (!empty($objp->stock_physique) && $objp->stock_physique < 0) {
141 print
'<span class="warning">';
144$sql =
'SELECT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity,';
145$sql .=
' p.fk_product_type, p.tms as datem,';
146$sql .=
' p.duration, p.tosell as statut, p.tobuy, p.seuil_stock_alerte, p.desiredstock,';
147if (
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
148 $sql .=
' p.stock as stock_physique';
150 $sql .=
' SUM(s.reel) as stock_physique';
153 $sql .=
', u.short_label as unit_short';
156$parameters = array();
157$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object);
158$sql .= $hookmanager->resPrint;
159$sql .=
' FROM '.MAIN_DB_PREFIX.
'product as p';
160if (!
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
161 $sql .=
' LEFT JOIN ' . MAIN_DB_PREFIX .
'product_stock as s ON p.rowid = s.fk_product';
164 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_units as u on p.fk_unit = u.rowid';
167$parameters = array();
168$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object);
169$sql .= $hookmanager->resPrint;
170$sql .=
" WHERE p.entity IN (".getEntity(
'product').
")";
171if (!empty($search_categ) && $search_categ !=
'-1') {
173 if ($search_categ == -2) {
174 $sql .=
" NOT EXISTS ";
179 $sql .=
" SELECT cp.fk_categorie, cp.fk_product";
180 $sql .=
" FROM " . MAIN_DB_PREFIX .
"categorie_product as cp";
181 $sql .=
" WHERE cp.fk_product = p.rowid";
182 if ($search_categ > 0) {
183 $sql .=
" AND cp.fk_categorie = " . ((int) $search_categ);
187if (!
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
189 $sql .=
" AND EXISTS (SELECT e.rowid FROM " . MAIN_DB_PREFIX .
"entrepot as e WHERE e.rowid = s.fk_entrepot AND e.entity IN (" .
getEntity(
'stock') .
"))";
195 FROM " . MAIN_DB_PREFIX .
"entrepot as e
196 WHERE e.rowid = s.fk_entrepot AND e.entity IN (" .
getEntity(
'stock') .
"))
198 SELECT SUM(cd1.qty) as qty
199 FROM " . MAIN_DB_PREFIX .
"commande_fournisseurdet as cd1
200 LEFT JOIN " . MAIN_DB_PREFIX .
"commande_fournisseur as c1
201 ON c1.rowid = cd1.fk_commande
202 WHERE c1.entity IN (1) AND cd1.fk_product = p.rowid AND c1.fk_statut in (3,4) AND cd1.qty <> 0
205 SELECT SUM(cd2.qty) as qty
206 FROM " . MAIN_DB_PREFIX .
"commandedet as cd2
207 LEFT JOIN " . MAIN_DB_PREFIX .
"commande as c2 ON c2.rowid = cd2.fk_commande
208 WHERE c2.entity IN (1) AND cd2.fk_product = p.rowid AND c2.fk_statut in (1,2) AND cd2.qty <> 0
211 SELECT SUM(ed3.qty) as qty
212 FROM " . MAIN_DB_PREFIX .
"expeditiondet as ed3
213 LEFT JOIN " . MAIN_DB_PREFIX .
"expedition as e3 ON e3.rowid = ed3.fk_expedition
214 LEFT JOIN " . MAIN_DB_PREFIX .
"commandedet as cd3 ON ed3.fk_elementdet = cd3.rowid
215 LEFT JOIN " . MAIN_DB_PREFIX .
"commande as c3 ON c3.rowid = cd3.fk_commande
216 WHERE e3.entity IN (1) AND cd3.fk_product = p.rowid AND c3.fk_statut IN (1,2) AND e3.fk_statut IN (1,2) AND ed3.qty <> 0
219 SELECT SUM(mp4.qty) as qty
220 FROM " . MAIN_DB_PREFIX .
"mrp_production as mp4
221 LEFT JOIN " . MAIN_DB_PREFIX .
"mrp_mo as m4 ON m4.rowid = mp4.fk_mo AND m4.entity IN (1) AND m4.status IN (1,2)
222 WHERE mp4.fk_product = p.rowid AND mp4.qty <> 0
228 $sql .=
natural_search(array(
'p.ref',
'p.label',
'p.description',
'p.note'), $sall);
233 $sql .=
" AND p.fk_product_type = '1'";
235 $sql .=
" AND p.fk_product_type <> '1'";
241if ($search_barcode) {
247if (!empty($tosell)) {
248 $sql .=
" AND p.tosell = ".((int) $tosell);
251 $sql .=
" AND p.tobuy = ".((int) $tobuy);
253if (!empty($canvas)) {
254 $sql .=
" AND p.canvas = '".$db->escape($canvas).
"'";
257 $sql .=
" AND p.rowid = pf.fk_product AND pf.fk_soc = ".((int) $fourn_id);
259if (
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
260 if ($search_toolowstock) {
261 $sql .=
" AND p.stock < p.seuil_stock_alerte";
263 if ($search_stock_physique !=
'') {
268$parameters = array();
269$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
270$sql .= $hookmanager->resPrint;
271if (!
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
272 $sql .=
" GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.entity,";
273 $sql .=
" p.fk_product_type, p.tms, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock";
277$parameters = array();
278$reshook = $hookmanager->executeHooks(
'printFieldListGroupBy', $parameters, $object);
279$sql .= $hookmanager->resPrint;
282if (!
getDolGlobalString(
'PRODUCT_STOCK_LIST_SHOW_WITH_PRECALCULATED_DENORMALIZED_PHYSICAL_STOCK')) {
283 if ($search_toolowstock) {
284 $sql_having .=
" HAVING SUM(" . $db->ifsql(
's.reel IS NULL',
'0',
's.reel') .
") < p.seuil_stock_alerte";
286 if ($search_stock_physique !=
'') {
288 $natural_search_physique =
natural_search(
'SUM(' . $db->ifsql(
's.reel IS NULL',
'0',
's.reel') .
')', $search_stock_physique, 1, 1);
289 $natural_search_physique =
" " . substr($natural_search_physique, 1, -1);
290 if (!empty($sql_having)) {
291 $sql_having .=
" AND";
293 $sql_having .=
" HAVING";
295 $sql_having .= $natural_search_physique;
300$parameters = array();
301$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object);
302if (!empty($hookmanager->resPrint)) {
303 if (!empty($sql_having)) {
304 $sql_having .=
" AND";
306 $sql_having .=
" HAVING";
308 $sql_having .= $hookmanager->resPrint;
311if (!empty($sql_having)) {
314$sql .= $db->order($sortfield, $sortorder);
317$nbtotalofrecords =
'';
319 $result = $db->query($sql);
320 $nbtotalofrecords = $db->num_rows($result);
321 if (($page * $limit) > $nbtotalofrecords) {
327$sql .= $db->plimit($limit + 1, $offset);
329$resql = $db->query($sql);
331 $num = $db->num_rows($resql);
335 if ($num == 1 &&
GETPOST(
'autojumpifoneonly') && ($sall || $snom || $sref)) {
336 $objp = $db->fetch_object($resql);
337 header(
"Location: card.php?id=$objp->rowid");
343 $texte = $langs->trans(
"Services");
345 $texte = $langs->trans(
"Products");
348 $texte = $langs->trans(
"ProductsAndServices");
350 $texte .=
' ('.$langs->trans(
"MenuStocks").
')';
353 if ($limit > 0 && $limit != $conf->liste_limit) {
354 $param .=
'&limit='.((int) $limit);
357 $param .=
"&sall=".urlencode($sall);
360 $param .=
"&tosell=".urlencode($tosell);
363 $param .=
"&tobuy=".urlencode($tobuy);
366 $param .=
"&type=".urlencode((
string) ($type));
369 $param .=
"&fourn_id=".urlencode((
string) ($fourn_id));
372 $param .=
"&snom=".urlencode($snom);
375 $param .=
"&sref=".urlencode($sref);
378 $param .=
"&search_sale=".urlencode($search_sale);
380 if ($search_categ > 0) {
381 $param .=
"&search_categ=".urlencode((
string) ($search_categ));
383 if ($search_toolowstock) {
384 $param .=
"&search_toolowstock=".urlencode($search_toolowstock);
387 $param .=
"&sbarcode=".urlencode((
string) ($sbarcode));
389 if ($search_stock_physique) {
390 $param .=
'&search_stock_physique=' . urlencode($search_stock_physique);
393 llxHeader(
"", $texte, $helpurl,
'', 0, 0,
'',
'',
'',
'mod-product page-reassort');
395 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="post" name="formulaire">';
396 print
'<input type="hidden" name="token" value="'.newToken().
'">';
397 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
398 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
399 print
'<input type="hidden" name="page" value="'.$page.
'">';
400 print
'<input type="hidden" name="type" value="'.$type.
'">';
402 print_barre_liste($texte, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder,
'', $num, $nbtotalofrecords,
'product', 0,
'',
'', $limit);
404 if ($search_categ > 0) {
405 print
"<div id='ways'>";
407 $c->fetch($search_categ);
408 $ways = $c->print_all_ways(
' > ',
'product/reassort.php');
409 print
" > ".$ways[0].
"<br>\n";
415 if (isModEnabled(
'category')) {
416 $moreforfilter .=
'<div class="divsearchfield">';
417 $moreforfilter .=
img_picto($langs->trans(
'Categories'),
'category',
'class="pictofixedwidth"');
418 $moreforfilter .= $htmlother->select_categories(Categorie::TYPE_PRODUCT, $search_categ,
'search_categ', 1);
419 $moreforfilter .=
'</div>';
422 $moreforfilter .=
'<div class="divsearchfield">';
423 $moreforfilter .=
'<label for="search_toolowstock">'.$langs->trans(
"StockTooLow").
' </label><input type="checkbox" id="search_toolowstock" name="search_toolowstock" value="1"'.($search_toolowstock ?
' checked' :
'').
'>';
424 $moreforfilter .=
'</div>';
426 if (!empty($moreforfilter)) {
427 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
428 print $moreforfilter;
429 $parameters = array();
430 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
431 print $hookmanager->resPrint;
436 $formProduct->loadWarehouses();
437 $warehouses_list = $formProduct->cache_warehouses;
438 $nb_warehouse = count($warehouses_list);
439 $colspan_warehouse = 1;
441 $colspan_warehouse = $nb_warehouse > 1 ? $nb_warehouse + 1 : 1;
444 print
'<div class="div-table-responsive">';
445 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">';
448 print
'<tr class="liste_titre_filter">';
451 print
'<td class="liste_titre maxwidthsearch">';
452 $searchpicto = $form->showFilterAndCheckAddButtons(0);
456 print
'<td class="liste_titre">';
457 print
'<input class="flat" type="text" name="sref" size="6" value="'.$sref.
'">';
459 print
'<td class="liste_titre">';
460 print
'<input class="flat" type="text" name="snom" size="8" value="'.$snom.
'">';
463 if (isModEnabled(
"service") && $type == 1) {
464 print
'<td class="liste_titre">';
469 print
'<td class="liste_titre"> </td>';
470 print
'<td class="liste_titre right"> </td>';
472 print
'<td class="liste_titre right">';
473 print
'<input class="flat" type="text" size="5" name="search_stock_physique" value="'.dol_escape_htmltag($search_stock_physique).
'">';
475 if ($virtualdiffersfromphysical) {
476 print
'<td class="liste_titre"> </td>';
478 print
'<td class="liste_titre"> </td>';
479 print
'<td class="liste_titre" colspan="'.$colspan_warehouse.
'"> </td>';
480 print
'<td class="liste_titre"></td>';
481 $parameters = array();
482 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
483 print $hookmanager->resPrint;
485 print
'<td class="liste_titre maxwidthsearch">';
486 $searchpicto = $form->showFilterAndCheckAddButtons(0);
493 print
'<tr class="liste_titre">';
500 if (isModEnabled(
"service") && $type == 1) {
501 print_liste_field_titre(
"Duration", $_SERVER[
"PHP_SELF"],
"p.duration",
'', $param,
"", $sortfield, $sortorder,
'center ');
503 print_liste_field_titre(
"StockLimit", $_SERVER[
"PHP_SELF"],
"p.seuil_stock_alerte",
'', $param,
"", $sortfield, $sortorder,
'right ');
504 print_liste_field_titre(
"DesiredStock", $_SERVER[
"PHP_SELF"],
"p.desiredstock",
'', $param,
"", $sortfield, $sortorder,
'right ');
505 print_liste_field_titre(
"PhysicalStock", $_SERVER[
"PHP_SELF"],
"stock_physique",
'', $param,
"", $sortfield, $sortorder,
'right ');
508 if ($nb_warehouse > 1) {
509 foreach ($warehouses_list as &$wh) {
514 if ($virtualdiffersfromphysical) {
515 print_liste_field_titre(
"VirtualStock", $_SERVER[
"PHP_SELF"],
"",
'', $param,
"", $sortfield, $sortorder,
'right ',
'VirtualStockDesc');
519 print_liste_field_titre(
"Unit", $_SERVER[
"PHP_SELF"],
"unit_short",
'', $param,
'align="right"', $sortfield, $sortorder);
522 print_liste_field_titre(
"ProductStatusOnSell", $_SERVER[
"PHP_SELF"],
"p.tosell",
'', $param,
"", $sortfield, $sortorder,
'right ');
523 print_liste_field_titre(
"ProductStatusOnBuy", $_SERVER[
"PHP_SELF"],
"p.tobuy",
'', $param,
"", $sortfield, $sortorder,
'right ');
525 $parameters = array(
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder);
526 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
527 print $hookmanager->resPrint;
534 while ($i < min($num, $limit)) {
535 $objp = $db->fetch_object($resql);
538 $product->fetch($objp->rowid);
539 $product->load_stock();
546 print
'<td class="nowrap">';
547 print $product->getNomUrl(1,
'', 16);
550 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($product->label).
'">'.
dol_escape_htmltag($product->label).
'</td>';
552 if (isModEnabled(
"service") && $type == 1) {
553 print
'<td class="center">';
554 if (preg_match(
'/([0-9]+)y/i', $objp->duration, $regs)) {
555 print $regs[1].
' '.$langs->trans(
"DurationYear");
556 } elseif (preg_match(
'/([0-9]+)m/i', $objp->duration, $regs)) {
557 print $regs[1].
' '.$langs->trans(
"DurationMonth");
558 } elseif (preg_match(
'/([0-9]+)d/i', $objp->duration, $regs)) {
559 print $regs[1].
' '.$langs->trans(
"DurationDay");
561 print $objp->duration;
566 print
'<td class="right">';
567 print $objp->seuil_stock_alerte;
569 print
'<td class="right">';
570 print $objp->desiredstock;
573 print
'<td class="right">';
574 if ($objp->seuil_stock_alerte !=
'' && ($objp->stock_physique < $objp->seuil_stock_alerte)) {
575 print
img_warning($langs->trans(
"StockLowerThanLimit", $objp->seuil_stock_alerte)).
' ';
577 if ($objp->stock_physique < 0) {
578 print
'<span class="warning">';
580 print
price(
price2num($objp->stock_physique,
'MS'), 0, $langs, 1, 0);
581 if ($objp->stock_physique < 0) {
588 if ($nb_warehouse > 1) {
589 foreach ($warehouses_list as &$wh) {
590 print
'<td class="right">';
591 print
price(empty($product->stock_warehouse[$wh[
'id']]->real) ? 0 :
price2num($product->stock_warehouse[$wh[
'id']]->real,
'MS'), 0, $langs, 1, 0);
598 if ($virtualdiffersfromphysical) {
599 print
'<td class="right">';
600 if ($objp->seuil_stock_alerte !=
'' && ($product->stock_theorique < (
float) $objp->seuil_stock_alerte)) {
601 print
img_warning($langs->trans(
"StockLowerThanLimit", $objp->seuil_stock_alerte)).
' ';
603 if ($objp->stock_physique < 0) {
604 print
'<span class="warning">';
606 print
price(
price2num($product->stock_theorique,
'MS'), 0, $langs, 1, 0);
607 if ($objp->stock_physique < 0) {
614 print
'<td class="left">'.dol_escape_htmltag($objp->unit_short).
'</td>';
616 print
'<td class="center nowraponall">';
617 print
img_picto($langs->trans(
"StockMovement"),
'movement',
'class="pictofixedwidth"');
618 print
'<a href="'.DOL_URL_ROOT.
'/product/stock/movement_list.php?idproduct='.$product->id.
'">'.$langs->trans(
"Movements").
'</a>';
620 print
'<td class="right nowrap">'.$product->LibStatut($objp->statut, 5, 0).
'</td>';
621 print
'<td class="right nowrap">'.$product->LibStatut($objp->tobuy, 5, 1).
'</td>';
623 $parameters = array(
'obj' => $objp);
624 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $product);
625 print $hookmanager->resPrint;
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
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.
Class to manage categories.
Class to manage products or services.
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.