Go to the documentation of this file.
26 require
'../../main.inc.php';
27 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/entrepot.class.php';
30 $langs->load(
"stocks");
35 $sref =
GETPOST(
"sref",
'alpha');
36 $snom =
GETPOST(
"snom",
'alpha');
37 $sall = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
39 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
40 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
47 $page = $_GET[
"page"];
51 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
52 $offset = $limit * $page;
54 $year = strftime(
"%Y", time());
61 $sql =
"SELECT e.rowid, e.ref, e.statut, e.lieu, e.address, e.zip, e.town, e.fk_pays,";
62 $sql .=
" SUM(ps.pmp * ps.reel) as estimatedvalue, SUM(p.price * ps.reel) as sellvalue";
63 $sql .=
" FROM ".MAIN_DB_PREFIX.
"entrepot as e";
64 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product_stock as ps ON e.rowid = ps.fk_entrepot";
65 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON ps.fk_product = p.rowid";
66 $sql .=
" WHERE e.entity IN (".getEntity(
'stock').
")";
71 $sql .=
" AND (e.ref LIKE '%".$db->escape($sall).
"%'";
72 $sql .=
" OR e.description LIKE '%".$db->escape($sall).
"%'";
73 $sql .=
" OR e.lieu LIKE '%".$db->escape($sall).
"%'";
74 $sql .=
" OR e.address LIKE '%".$db->escape($sall).
"%'";
75 $sql .=
" OR e.town LIKE '%".$db->escape($sall).
"%')";
77 $sql .=
" GROUP BY e.rowid, e.ref, e.statut, e.lieu, e.address, e.zip, e.town, e.fk_pays";
78 $sql .= $db->order($sortfield, $sortorder);
79 $sql .= $db->plimit($limit + 1, $offset);
81 $result = $db->query($sql);
83 $num = $db->num_rows($result);
87 $help_url =
'EN:Module_Stocks_En|FR:Module_Stock|ES:Módulo_Stocks';
90 print_barre_liste($langs->trans(
"EnhancedValueOfWarehouses"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
92 print
'<table class="noborder centpercent">';
93 print
"<tr class=\"liste_titre\">";
96 print_liste_field_titre(
"EstimatedStockValue", $_SERVER[
"PHP_SELF"],
"e.valo_pmp",
'',
'',
'', $sortfield, $sortorder,
'right ');
97 print_liste_field_titre(
"EstimatedStockValueSell", $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'right ');
98 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"e.statut",
'',
'',
'', $sortfield, $sortorder,
'right ');
103 $total = $totalsell = 0;
105 while ($i < min($num, $limit)) {
106 $objp = $db->fetch_object($result);
107 print
'<tr class="oddeven">';
108 print
'<td><a href="card.php?id='.$objp->rowid.
'">'.
img_object($langs->trans(
"ShowWarehouse"),
'stock').
' '.$objp->ref.
'</a></td>';
109 print
'<td>'.$objp->lieu.
'</td>';
111 print
'<td class="right">';
112 if (
price2num($objp->estimatedvalue,
'MT')) {
119 print
'<td class="right">';
120 if (empty($conf->global->PRODUIT_MULTIPRICES)) {
123 print $langs->trans(
"Variable");
127 print
'<td class="right">'.$entrepot->LibStatut($objp->statut, 5).
'</td>';
129 $total +=
price2num($objp->estimatedvalue,
'MU');
130 $totalsell +=
price2num($objp->sellvalue,
'MU');
135 print
'<tr class="liste_total">';
136 print
'<td colspan="2" class="right">'.$langs->trans(
"Total").
'</td>';
137 print
'<td class="right">'.price(
price2num($total,
'MT'), 1, $langs, 0, 0, -1, $conf->currency).
'</td>';
138 print
'<td class="right">'.price(
price2num($totalsell,
'MT'), 1, $langs, 0, 0, -1, $conf->currency).
'</td>';
139 print
'<td class="right"> </td>';
149 $file =
'entrepot-'.$year.
'.png';
150 if (file_exists($conf->stock->dir_temp.
'/'.$file)) {
151 $url = DOL_URL_ROOT.
'/viewimage.php?modulepart=graph_stock&file='.$file;
152 print
'<img src="'.$url.
'">';
155 $file =
'entrepot-'.($year - 1).
'.png';
156 if (file_exists($conf->stock->dir_temp.
'/'.$file)) {
157 $url = DOL_URL_ROOT.
'/viewimage.php?modulepart=graph_stock&file='.$file;
158 print
'<br><img src="'.$url.
'">';
restrictedArea($user, $features, $objectid=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.
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='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
if(GETPOST('button_removefilter_x', 'alpha')||GETPOST('button_removefilter.x', 'alpha')||GETPOST('button_removefilter', 'alpha')) if(GETPOST('button_search_x', 'alpha')||GETPOST('button_search.x', 'alpha')||GETPOST('button_search', 'alpha')) if($action=="save" &&empty($cancel)) $help_url
View.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
print_barre_liste($titre, $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.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
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...
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
Class to manage warehouses.
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.
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.