27require
'../../main.inc.php';
28require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/entrepot.class.php';
31$langs->load(
"stocks");
33$sref =
GETPOST(
"sref",
'alpha');
34$snom =
GETPOST(
"snom",
'alpha');
35$sall = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
38$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
39$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
41if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
45$offset = $limit * $page;
64$sql =
"SELECT e.rowid, e.ref, e.statut, e.lieu, e.address, e.zip, e.town, e.fk_pays,";
65$sql .=
" SUM(ps.pmp * ps.reel) as estimatedvalue, SUM(p.price * ps.reel) as sellvalue";
66$sql .=
" FROM ".MAIN_DB_PREFIX.
"entrepot as e";
67$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product_stock as ps ON e.rowid = ps.fk_entrepot";
68$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON ps.fk_product = p.rowid";
69$sql .=
" WHERE e.entity IN (".getEntity(
'stock').
")";
74 $sql .=
" AND (e.ref LIKE '%".$db->escape($sall).
"%'";
75 $sql .=
" OR e.description LIKE '%".$db->escape($sall).
"%'";
76 $sql .=
" OR e.lieu LIKE '%".$db->escape($sall).
"%'";
77 $sql .=
" OR e.address LIKE '%".$db->escape($sall).
"%'";
78 $sql .=
" OR e.town LIKE '%".$db->escape($sall).
"%')";
80$sql .=
" GROUP BY e.rowid, e.ref, e.statut, e.lieu, e.address, e.zip, e.town, e.fk_pays";
81$sql .= $db->order($sortfield, $sortorder);
82$sql .= $db->plimit($limit + 1, $offset);
84$result = $db->query($sql);
86 $num = $db->num_rows($result);
90 $help_url =
'EN:Module_Stocks_En|FR:Module_Stock|ES:Módulo_Stocks';
91 llxHeader(
"", $langs->trans(
"EnhancedValueOfWarehouses"), $help_url,
'', 0, 0,
'',
'',
'',
'mod-product page-stock_valo');
93 print_barre_liste($langs->trans(
"EnhancedValueOfWarehouses"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
95 print
'<table class="noborder centpercent">';
96 print
"<tr class=\"liste_titre\">";
99 print_liste_field_titre(
"EstimatedStockValue", $_SERVER[
"PHP_SELF"],
"e.valo_pmp",
'',
'',
'', $sortfield, $sortorder,
'right ');
100 print_liste_field_titre(
"EstimatedStockValueSell", $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'right ');
101 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"e.statut",
'',
'',
'', $sortfield, $sortorder,
'right ');
106 $total = $totalsell = 0;
108 while ($i < min($num, $limit)) {
109 $objp = $db->fetch_object($result);
110 print
'<tr class="oddeven">';
111 print
'<td><a href="card.php?id='.$objp->rowid.
'">'.
img_object($langs->trans(
"ShowWarehouse"),
'stock').
' '.$objp->ref.
'</a></td>';
112 print
'<td>'.$objp->lieu.
'</td>';
114 print
'<td class="right">';
115 if (
price2num($objp->estimatedvalue,
'MT')) {
122 print
'<td class="right">';
126 print $langs->trans(
"Variable");
130 print
'<td class="right">'.$entrepot->LibStatut($objp->statut, 5).
'</td>';
132 $total +=
price2num($objp->estimatedvalue,
'MU');
133 $totalsell +=
price2num($objp->sellvalue,
'MU');
138 print
'<tr class="liste_total">';
139 print
'<td colspan="2" class="right">'.$langs->trans(
"Total").
'</td>';
140 print
'<td class="right">'.price(
price2num($total,
'MT'), 1, $langs, 0, 0, -1, $conf->currency).
'</td>';
141 print
'<td class="right">'.price(
price2num($totalsell,
'MT'), 1, $langs, 0, 0, -1, $conf->currency).
'</td>';
142 print
'<td class="right"> </td>';
152 $file =
'entrepot-'.$year.
'.png';
153 if (file_exists($conf->stock->dir_temp.
'/'.$file)) {
154 $url = DOL_URL_ROOT.
'/viewimage.php?modulepart=graph_stock&file='.$file;
155 print
'<img src="'.$url.
'">';
158 $file =
'entrepot-'.($year - 1).
'.png';
159 if (file_exists($conf->stock->dir_temp.
'/'.$file)) {
160 $url = DOL_URL_ROOT.
'/viewimage.php?modulepart=graph_stock&file='.$file;
161 print
'<br><img src="'.$url.
'">';
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Class to manage warehouses.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (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...
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.
dol_now($mode='auto')
Return date for now.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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 dolibarr global constant string value.
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.