dolibarr 21.0.0-alpha
reception.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003-2007 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2014 Juanjo Menent <jmenent@2byte.es>
6 * Copyright (C) 2014 Florian Henry <florian.henry@open-concept.pro>
7 * Copyright (C) 2023 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
8 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 */
23
30// Load Dolibarr environment
31require '../../../main.inc.php';
32require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
33require_once DOL_DOCUMENT_ROOT.'/reception/class/reception.class.php';
34require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
35require_once DOL_DOCUMENT_ROOT.'/product/stock/class/productlot.class.php';
36require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
37
38// Load translation files required by the page
39$langs->loadLangs(array('companies', 'bills', 'products', 'supplier_proposal', 'productbatch'));
40
41$id = GETPOSTINT('id');
42$ref = GETPOST('ref', 'alpha');
43$batch = GETPOST('batch', 'alpha');
44$objectid = GETPOSTINT('productid');
45
46// Security check
47$fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
48$fieldtype = (!empty($ref) ? 'ref' : 'rowid');
49$socid = '';
50if (!empty($user->socid)) {
51 $socid = $user->socid;
52}
53
54// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
55$hookmanager->initHooks(array('batchproductstatsreception'));
56
57$showmessage = GETPOST('showmessage');
58
59// Load variable for pagination
60$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
61$sortfield = GETPOST('sortfield', 'aZ09comma');
62$sortorder = GETPOST('sortorder', 'aZ09comma');
63$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
64if (empty($page) || $page == -1) {
65 $page = 0;
66} // If $page is not defined, or '' or -1
67$offset = $limit * $page;
68$pageprev = $page - 1;
69$pagenext = $page + 1;
70if (!$sortorder) {
71 $sortorder = "DESC";
72}
73if (!$sortfield) {
74 $sortfield = "recep.date_creation";
75}
76
77$search_month = GETPOSTINT('search_month');
78$search_year = GETPOSTINT('search_year');
79
80if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
81 $search_month = '';
82 $search_year = '';
83}
84
85if (!$user->hasRight('produit', 'lire')) {
87}
88
89
90/*
91 * View
92 */
93
94$receptionstatic = new Reception($db);
95$societestatic = new Societe($db);
96
97$form = new Form($db);
98$formother = new FormOther($db);
99
100if ($id > 0 || !empty($ref)) {
101 $object = new Productlot($db);
102 if ($ref) {
103 $tmp = explode('_', $ref);
104 $objectid = $tmp[0];
105 $batch = $tmp[1];
106 }
107 $result = $object->fetch($id, $objectid, $batch);
108
109 $parameters = array('id' => $id);
110 $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
111 if ($reshook < 0) {
112 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
113 }
114
115 $title = $langs->trans('ProductServiceCard');
116 $helpurl = '';
117 $shortlabel = dol_trunc($object->batch, 16);
118 $title = $langs->trans('Batch')." ".$shortlabel." - ".$langs->trans('Referers');
119
120 llxHeader('', $title, $helpurl, '', 0, 0, '', '', '', 'mod-product page-stock-stats_reception');
121
122 if ($result > 0) {
124 $titre = $langs->trans("CardProduct".$object->type);
125 $picto = 'lot';
126 print dol_get_fiche_head($head, 'referers', $langs->trans("Batch"), -1, $object->picto);
127
128 $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
129 print $hookmanager->resPrint;
130 if ($reshook < 0) {
131 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
132 }
133
134 $linkback = '<a href="'.DOL_URL_ROOT.'/product/stock/productlot_list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
135
136 $shownav = 1;
137 if ($user->socid && !in_array('product', explode(',', getDolGlobalString('MAIN_MODULES_FOR_EXTERNAL')))) {
138 $shownav = 0;
139 }
140
141 dol_banner_tab($object, 'id', $linkback, $shownav, 'rowid', 'batch', $morehtmlref);
142
143 print '<div class="fichecenter">';
144
145 print '<div class="underbanner clearboth"></div>';
146 print '<table class="border centpercent tableforfield" width="100%">';
147
148
149 // Product
150 print '<tr><td class="titlefield">'.$langs->trans("Product").'</td><td>';
151 $producttmp = new Product($db);
152 $producttmp->fetch($object->fk_product);
153 print $producttmp->getNomUrl(1, 'stock')." - ".$producttmp->label;
154 print '</td></tr>';
155 print "</table>";
156
157 echo '<br>';
158
159 // // Sell by
160 // if (empty($conf->global->PRODUCT_DISABLE_SELLBY)) {
161 // print '<tr><td>';
162 // print $form->editfieldkey($langs->trans('SellByDate'), 'sellby', $object->sellby, $object, $user->rights->stock->creer, 'datepicker');
163 // print '</td><td>';
164 // print $form->editfieldval($langs->trans('SellByDate'), 'sellby', $object->sellby, $object, $user->rights->stock->creer, 'datepicker');
165 // print '</td>';
166 // print '</tr>';
167 // }
168 //
169 // // Eat by
170 // if (empty($conf->global->PRODUCT_DISABLE_EATBY)) {
171 // print '<tr><td>';
172 // print $form->editfieldkey($langs->trans('EatByDate'), 'eatby', $object->eatby, $object, $user->rights->stock->creer, 'datepicker');
173 // print '</td><td>';
174 // print $form->editfieldval($langs->trans('EatByDate'), 'eatby', $object->eatby, $object, $user->rights->stock->creer, 'datepicker');
175 // print '</td>';
176 // print '</tr>';
177 // }
178 //
179 // if (!empty($conf->global->PRODUCT_LOT_ENABLE_TRACEABILITY)) {
180 // print '<tr><td>'.$form->editfieldkey($langs->trans('ManufacturingDate'), 'manufacturing_date', $object->manufacturing_date, $object, $user->rights->stock->creer).'</td>';
181 // print '<td>'.$form->editfieldval($langs->trans('ManufacturingDate'), 'manufacturing_date', $object->manufacturing_date, $object, $user->rights->stock->creer, 'datepicker').'</td>';
182 // print '</tr>';
183 // // print '<tr><td>'.$form->editfieldkey($langs->trans('FirstUseDate'), 'commissionning_date', $object->commissionning_date, $object, $user->rights->stock->creer).'</td>';
184 // // print '<td>'.$form->editfieldval($langs->trans('FirstUseDate'), 'commissionning_date', $object->commissionning_date, $object, $user->rights->stock->creer, 'datepicker').'</td>';
185 // // print '</tr>';
186 // print '<tr><td>'.$form->editfieldkey($langs->trans('DestructionDate'), 'scrapping_date', $object->scrapping_date, $object, $user->rights->stock->creer).'</td>';
187 // print '<td>'.$form->editfieldval($langs->trans('DestructionDate'), 'scrapping_date', $object->scrapping_date, $object, $user->rights->stock->creer, 'datepicker').'</td>';
188 // print '</tr>';
189 // }
190 //
191 // // Quality control
192 // if (!empty($conf->global->PRODUCT_LOT_ENABLE_QUALITY_CONTROL)) {
193 // print '<tr><td>'.$form->editfieldkey($langs->trans('EndOfLife'), 'eol_date', $object->eol_date, $object, $user->rights->stock->creer).'</td>';
194 // print '<td>'.$form->editfieldval($langs->trans('EndOfLife'), 'eol_date', $object->eol_date, $object, $user->rights->stock->creer, 'datepicker').'</td>';
195 // print '</tr>';
196 // print '<tr><td>'.$form->editfieldkey($langs->trans('QCFrequency'), 'qc_frequency', $object->qc_frequency, $object, $user->rights->stock->creer).'</td>';
197 // print '<td>'.$form->editfieldval($langs->trans('QCFrequency'), 'qc_frequency', $object->qc_frequency, $object, $user->rights->stock->creer, 'numeric').'</td>';
198 // print '</tr>';
199 // }
200 //
201 // // Other attributes
202 // include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php';
203
204 print '<table class="border centpercent tableforfield" width="100%">';
205
206 $nboflines = show_stats_for_batch($object, $socid);
207
208 print "</table>";
209
210 print '</div>';
211 print '<div class="clearboth"></div>';
212
213 print dol_get_fiche_end();
214
215 if ($showmessage && $nboflines > 1) {
216 print '<span class="opacitymedium">'.$langs->trans("ClinkOnALinkOfColumn", $langs->transnoentitiesnoconv("Referers")).'</span>';
217 } elseif ($user->hasRight('reception', 'lire')) {
218 $sql = "SELECT DISTINCT s.nom as name, s.rowid as socid, s.code_fournisseur,";
219 $sql .= " recep.ref, recep.date_creation, recep.fk_statut as statut, recep.rowid as facid,";
220 $sql .= " d.qty";
221 // $sql.= ", d.total_ht as total_ht"; // We must keep the d.rowid here to not loose record because of the distinct used to ignore duplicate line when link on societe_commerciaux is used
222 if (!$user->hasRight('societe', 'client', 'voir')) {
223 $sql .= ", sc.fk_soc, sc.fk_user ";
224 }
225 $sql .= " FROM ".MAIN_DB_PREFIX."societe as s";
226 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."reception as recep ON (recep.fk_soc = s.rowid)";
227 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."receptiondet_batch as d ON (d.fk_reception = recep.rowid)";
228 if (!$user->hasRight('societe', 'client', 'voir')) {
229 $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
230 }
231 $sql .= " WHERE recep.entity IN (".getEntity('product').")";
232 $sql .= " AND d.batch = '".($db->escape($object->batch))."'";
233 if (!empty($search_month)) {
234 $sql .= ' AND MONTH(recep.date_creation) IN ('.$db->sanitize($search_month).')';
235 }
236 if (!empty($search_year)) {
237 $sql .= ' AND YEAR(recep.date_creation) IN ('.$db->sanitize($search_year).')';
238 }
239 if (!$user->hasRight('societe', 'client', 'voir')) {
240 $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
241 }
242 if ($socid) {
243 $sql .= " AND recep.fk_soc = ".((int) $socid);
244 }
245 $sql .= $db->order($sortfield, $sortorder);
246
247 // Calcul total qty and amount for global if full scan list
248 $total_ht = 0;
249 $total_qty = 0;
250
251 // Count total nb of records
252 $totalofrecords = '';
253 if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
254 $result = $db->query($sql);
255 $totalofrecords = $db->num_rows($result);
256 }
257
258 $sql .= $db->plimit($limit + 1, $offset);
259
260 $result = $db->query($sql);
261 if ($result) {
262 $num = $db->num_rows($result);
263
264 $option .= '&id='.$object->id;
265
266 if ($limit > 0 && $limit != $conf->liste_limit) {
267 $option .= '&limit='.((int) $limit);
268 }
269 if (!empty($search_month)) {
270 $option .= '&search_month='.urlencode((string) ($search_month));
271 }
272 if (!empty($search_year)) {
273 $option .= '&search_year='.urlencode((string) ($search_year));
274 }
275
276 print '<form method="post" action="'.$_SERVER ['PHP_SELF'].'?id='.$object->id.'" name="search_form">'."\n";
277 print '<input type="hidden" name="token" value="'.newToken().'">';
278 if (!empty($sortfield)) {
279 print '<input type="hidden" name="sortfield" value="'.$sortfield.'"/>';
280 }
281 if (!empty($sortorder)) {
282 print '<input type="hidden" name="sortorder" value="'.$sortorder.'"/>';
283 }
284
285 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
286 print_barre_liste($langs->trans("Receptions"), $page, $_SERVER["PHP_SELF"], $option, $sortfield, $sortorder, '', $num, $totalofrecords, '', 0, '', '', $limit, 0, 0, 1);
287
288 if (!empty($page)) {
289 $option .= '&page='.urlencode((string) ($page));
290 }
291
292 print '<div class="liste_titre liste_titre_bydiv centpercent">';
293 print '<div class="divsearchfield">';
294 print $langs->trans('Period').' ('.$langs->trans("DateCreation").') - ';
295 print $langs->trans('Month').':<input class="flat" type="text" size="4" name="search_month" value="'.$search_month.'"> ';
296 print $langs->trans('Year').':'.$formother->selectyear($search_year ? $search_year : - 1, 'search_year', 1, 20, 5);
297 print '<div style="vertical-align: middle; display: inline-block">';
298 print '<input type="image" class="liste_titre" name="button_search" src="'.img_picto($langs->trans("Search"), 'search.png', '', 0, 1).'" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'">';
299 print '<input type="image" class="liste_titre" name="button_removefilter" src="'.img_picto($langs->trans("Search"), 'searchclear.png', '', 0, 1).'" value="'.dol_escape_htmltag($langs->trans("RemoveFilter")).'" title="'.dol_escape_htmltag($langs->trans("RemoveFilter")).'">';
300 print '</div>';
301 print '</div>';
302 print '</div>';
303
304 $i = 0;
305 print '<div class="div-table-responsive">';
306 print '<table class="tagtable liste listwithfilterbefore" width="100%">';
307 print '<tr class="liste_titre">';
308 print_liste_field_titre("Ref", $_SERVER["PHP_SELF"], "s.rowid", "", $option, '', $sortfield, $sortorder);
309 print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", $option, '', $sortfield, $sortorder);
310 print_liste_field_titre("SupplierCode", $_SERVER["PHP_SELF"], "s.code_fournisseur", "", $option, '', $sortfield, $sortorder);
311 print_liste_field_titre("DateCreation", $_SERVER["PHP_SELF"], "recep.date_creation", "", $option, 'align="center"', $sortfield, $sortorder);
312 print_liste_field_titre("Qty", $_SERVER["PHP_SELF"], "d.qty", "", $option, 'align="center"', $sortfield, $sortorder);
313 // print_liste_field_titre("AmountHT", $_SERVER["PHP_SELF"], "d.total_ht", "", $option, 'align="right"', $sortfield, $sortorder);
314 print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "recep.fk_statut", "", $option, 'align="right"', $sortfield, $sortorder);
315 print "</tr>\n";
316
317 if ($num > 0) {
318 while ($i < min($num, $limit)) {
319 $objp = $db->fetch_object($result);
320
321 $total_ht += $objp->total_ht;
322 $total_qty += $objp->qty;
323
324 $receptionstatic->id = $objp->facid;
325 $receptionstatic->ref = $objp->ref;
326 $societestatic->fetch($objp->socid);
327 // $paiement = $receptionstatic->getSommePaiement();
328
329 print '<tr class="oddeven">';
330 print '<td>';
331 print $receptionstatic->getNomUrl(1);
332 print "</td>\n";
333 print '<td>'.$societestatic->getNomUrl(1).'</td>';
334 print "<td>".$objp->code_fournisseur."</td>\n";
335 print '<td class="center">';
336 print dol_print_date($db->jdate($objp->date_creation), 'dayhour')."</td>";
337 print '<td class="center">'.$objp->qty."</td>\n";
338 // print '<td align="right">'.price($objp->total_ht)."</td>\n";
339 print '<td align="right">'.$receptionstatic->LibStatut($objp->statut, 5).'</td>';
340 print "</tr>\n";
341 $i++;
342 }
343 }
344 print '<tr class="liste_total">';
345 if ($num < $limit) {
346 print '<td class="left">'.$langs->trans("Total").'</td>';
347 } else {
348 print '<td class="left">'.$langs->trans("Totalforthispage").'</td>';
349 }
350 print '<td colspan="2"></td>';
351 print '<td></td>';
352 print '<td class="center">'.$total_qty.'</td>';
353 print '<td></td>';
354 print "</table>";
355 print '</div>';
356 print '</form>';
357 } else {
358 dol_print_error($db);
359 }
360 $db->free($result);
361 }
362 }
363} else {
365}
366
367// End of page
368llxFooter();
369$db->close();
$id
Definition account.php:39
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:58
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.
Definition wrapper.php:70
Class to manage generation of HTML components Only common components must be here.
Class permettant la generation de composants html autre Only common components are here.
Class to manage products or services.
Class with list of lots and properties.
Class to manage receptions.
Class to manage third parties objects (customers, suppliers, prospects...)
llxFooter()
Footer empty.
Definition document.php:107
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0)
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
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...
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.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
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...
show_stats_for_batch($batch, $socid)
Show stats for product batch.
productlot_prepare_head($object)
Prepare array with list of tabs.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.