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-2009 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2014 Florian Henry <florian.henry@open-concept.pro>
6 * Copyright (C) 2024 Jean-Rémi Taponier <jean-remi@netlogic.fr>
7 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
8 *
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 3 of the License, or
12 * (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program. If not, see <https://www.gnu.org/licenses/>.
21 */
22
29// Load Dolibarr environment
30require '../../main.inc.php';
31require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
32require_once DOL_DOCUMENT_ROOT.'/reception/class/reception.class.php';
33require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
34require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
35
36// Load translation files required by the page
37$langs->loadLangs(array('orders', 'receptions', 'products', 'companies'));
38
39$id = GETPOSTINT('id');
40$ref = GETPOST('ref', 'alpha');
41
42// Security check
43$fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
44$fieldtype = (!empty($ref) ? 'ref' : 'rowid');
45$socid = '';
46if (!empty($user->socid)) {
47 $socid = $user->socid;
48}
49
50// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
51$hookmanager->initHooks(array('productstatsreception'));
52
53// Load variable for pagination
54$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
55$sortfield = GETPOST('sortfield', 'aZ09comma');
56$sortorder = GETPOST('sortorder', 'aZ09comma');
57$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
58if (empty($page) || $page == -1) {
59 $page = 0;
60} // If $page is not defined, or '' or -1
61$offset = $limit * $page;
62$pageprev = $page - 1;
63$pagenext = $page + 1;
64if (!$sortorder) {
65 $sortorder = "DESC";
66}
67if (!$sortfield) {
68 $sortfield = "r.date_creation";
69}
70$search_month = GETPOSTINT('search_month');
71$search_year = GETPOSTINT('search_year');
72
73if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
74 $search_month = '';
75 $search_year = '';
76}
77
78$result = restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
79
80
81/*
82 * View
83 */
84
85$receptionstatic = new Reception($db);
86$societestatic = new Societe($db);
87
88$form = new Form($db);
89$formother = new FormOther($db);
90
91if ($id > 0 || !empty($ref)) {
92 $product = new Product($db);
93 $result = $product->fetch($id, $ref);
94
95 $object = $product;
96
97 $parameters = array('id' => $id);
98 $reshook = $hookmanager->executeHooks('doActions', $parameters, $product, $action); // Note that $action and $object may have been modified by some hooks
99 if ($reshook < 0) {
100 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
101 }
102
103 llxHeader('', '', $langs->trans("CardProduct".$product->type), '', 0, 0, '', '', '', '', 'mod-product page-stats_reception');
104
105 if ($result > 0) {
106 $head = product_prepare_head($product);
107 $titre = $langs->trans("CardProduct".$product->type);
108 $picto = ($product->type == Product::TYPE_SERVICE ? 'service' : 'product');
109 print dol_get_fiche_head($head, 'referers', $titre, -1, $picto);
110
111 $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $product, $action); // Note that $action and $object may have been modified by hook
112 print $hookmanager->resPrint;
113 if ($reshook < 0) {
114 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
115 }
116
117 $linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
118
119 $shownav = 1;
120 if ($user->socid && !in_array('product', explode(',', getDolGlobalString('MAIN_MODULES_FOR_EXTERNAL')))) {
121 $shownav = 0;
122 }
123
124 dol_banner_tab($object, 'ref', $linkback, $shownav, 'ref');
125
126 print '<div class="fichecenter">';
127
128 print '<div class="underbanner clearboth"></div>';
129 print '<table class="border tableforfield" width="100%">';
130
131 $nboflines = show_stats_for_company($product, $socid);
132
133 print "</table>";
134
135 print '</div>';
136 print '<div class="clearboth"></div>';
137
138 print dol_get_fiche_end();
139
140
141 if ($user->hasRight('reception', 'lire')) {
142 $sql = "SELECT DISTINCT s.nom as name, s.rowid as socid, s.code_fournisseur, r.ref, r.ref_supplier";
143 $sql .= ", r.date_creation, r.date_delivery, r.fk_statut as statut, r.rowid as receptionid, cfd.rowid";
144 $sql .= ", cfd.qty, cfdet.subprice * (100 - cfdet.remise_percent) / 100 * cfd.qty AS total_ht";
145 if (empty($user->rights->societe->client->voir) && !$socid) {
146 $sql .= ", sc.fk_soc, sc.fk_user ";
147 }
148 $sql .= " FROM ".MAIN_DB_PREFIX."societe as s";
149 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."reception as r ON r.fk_soc = s.rowid";
150 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."receptiondet_batch as cfd ON cfd.fk_reception = r.rowid AND element_type = 'supplier_order'";
151 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."commande_fournisseurdet as cfdet ON cfdet.rowid = cfd.fk_elementdet";
152 if (empty($user->rights->societe->client->voir) && !$socid) {
153 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
154 }
155 $sql .= " WHERE r.entity IN (".getEntity('reception').")";
156 $sql .= " AND cfd.fk_product = ".((int) $product->id);
157 if (!empty($search_month)) {
158 $sql .= ' AND MONTH(r.date_creation) IN ('.$db->sanitize($search_month).')';
159 }
160 if (!empty($search_year)) {
161 $sql .= ' AND YEAR(r.date_creation) IN ('.$db->sanitize($search_year).')';
162 }
163 if ($socid) {
164 $sql .= " AND r.fk_soc = ".((int) $socid);
165 }
166 $sql .= $db->order($sortfield, $sortorder);
167
168 //Calcul total qty and amount for global if full scan list
169 $total_ht = 0;
170 $total_qty = 0;
171
172 // Count total nb of records
173 $totalofrecords = '';
174 if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
175 $result = $db->query($sql);
176 $totalofrecords = $db->num_rows($result);
177 }
178
179 $sql .= $db->plimit($limit + 1, $offset);
180
181 $result = $db->query($sql);
182 if ($result) {
183 $num = $db->num_rows($result);
184
185 $option = '&id='.$product->id;
186
187 if ($limit > 0 && $limit != $conf->liste_limit) {
188 $option .= '&limit='.((int) $limit);
189 }
190 if (!empty($search_month)) {
191 $option .= '&search_month='.urlencode((string) ($search_month));
192 }
193 if (!empty($search_year)) {
194 $option .= '&search_year='.urlencode((string) ($search_year));
195 }
196
197 print '<form method="post" action="'.$_SERVER ['PHP_SELF'].'?id='.$product->id.'" name="search_form">'."\n";
198 print '<input type="hidden" name="token" value="'.newToken().'">';
199 if (!empty($sortfield)) {
200 print '<input type="hidden" name="sortfield" value="'.$sortfield.'"/>';
201 }
202 if (!empty($sortorder)) {
203 print '<input type="hidden" name="sortorder" value="'.$sortorder.'"/>';
204 }
205
206 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
207 print_barre_liste($langs->trans("Receptions"), $page, $_SERVER["PHP_SELF"], $option, $sortfield, $sortorder, '', $num, $totalofrecords, '', 0, '', '', $limit, 0, 0, 1);
208
209 if (!empty($page)) {
210 $option .= '&page='.urlencode((string) ($page));
211 }
212
213 print '<div class="liste_titre liste_titre_bydiv centpercent">';
214 print '<div class="divsearchfield">';
215 print $langs->trans('Period').' ('.$langs->trans("DateCreation").') - ';
216 print $langs->trans('Month').':<input class="flat" type="text" size="4" name="search_month" value="'.($search_month > 0 ? $search_month : '').'"> ';
217 print $langs->trans('Year').':'.$formother->selectyear($search_year ? $search_year : - 1, 'search_year', 1, 20, 5);
218 print '<div style="vertical-align: middle; display: inline-block">';
219 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")).'">';
220 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")).'">';
221 print '</div>';
222 print '</div>';
223 print '</div>';
224
225 $i = 0;
226 print '<div class="div-table-responsive">';
227 print '<table class="tagtable liste listwithfilterbefore" width="100%">';
228 print '<tr class="liste_titre">';
229 print_liste_field_titre("Ref", $_SERVER["PHP_SELF"], "r.rowid", "", $option, '', $sortfield, $sortorder);
230 print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", $option, '', $sortfield, $sortorder);
231 print_liste_field_titre("SupplierCode", $_SERVER["PHP_SELF"], "s.code_fournisseur", "", $option, '', $sortfield, $sortorder);
232 print_liste_field_titre("DateCreation", $_SERVER["PHP_SELF"], "r.date_creation", "", $option, 'align="center"', $sortfield, $sortorder);
233 print_liste_field_titre('DateDeliveryPlanned', $_SERVER['PHP_SELF'], 'r.date_delivery', '', $option, 'align="center"', $sortfield, $sortorder);
234 print_liste_field_titre("Qty", $_SERVER["PHP_SELF"], "cfd.qty", "", $option, 'align="center"', $sortfield, $sortorder);
235 print_liste_field_titre("AmountHT", $_SERVER["PHP_SELF"], "total_ht", "", $option, 'align="right"', $sortfield, $sortorder);
236 print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "r.fk_statut", "", $option, 'align="right"', $sortfield, $sortorder);
237 print "</tr>\n";
238
239 if ($num > 0) {
240 while ($i < min($num, $limit)) {
241 $objp = $db->fetch_object($result);
242
243 $objp->total_ht = price2num($objp->total_ht, 'MT');
244 $total_ht += $objp->total_ht;
245 $total_qty += $objp->qty;
246
247 $receptionstatic->id = $objp->receptionid;
248 $receptionstatic->ref = $objp->ref;
249 $receptionstatic->ref_supplier = $objp->ref_supplier;
250 $societestatic->fetch($objp->socid);
251
252 print '<tr class="oddeven">';
253 print '<td>';
254 print $receptionstatic->getNomUrl(1);
255 print "</td>\n";
256 print '<td>'.$societestatic->getNomUrl(1).'</td>';
257 print "<td>".$objp->code_fournisseur."</td>\n";
258 print '<td class="center">';
259 print dol_print_date($db->jdate($objp->date_creation), 'dayhour')."</td>";
260 // delivery planned date
261 print '<td class="center">';
262 print dol_print_date($db->jdate($objp->date_delivery), 'dayhour');
263 print '</td>';
264 print '<td class="center">'.$objp->qty."</td>\n";
265 print '<td align="right">'.price($objp->total_ht)."</td>\n";
266 print '<td align="right">'.$receptionstatic->LibStatut($objp->statut, 4).'</td>';
267 print "</tr>\n";
268 $i++;
269 }
270 }
271 print '<tr class="liste_total">';
272 if ($num < $limit && empty($offset)) {
273 print '<td>'.$langs->trans("Total").'</td>';
274 } else {
275 print '<td>'.$form->textwithpicto($langs->trans("Total"), $langs->trans("Totalforthispage")).'</td>';
276 }
277 print '<td colspan="3"></td>';
278 print '<td></td>';
279 print '<td class="center">'.$total_qty.'</td>';
280 print '<td align="right">'.price($total_ht).'</td>';
281 print '<td></td>';
282 print "</table>";
283 print "</div>";
284 print '</form>';
285 } else {
286 dol_print_error($db);
287 }
288 $db->free($result);
289 }
290 }
291} else {
293}
294
295// End of page
296llxFooter();
297$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.
const TYPE_SERVICE
Service.
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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
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...
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...
product_prepare_head($object)
Prepare array with list of tabs.
show_stats_for_company($product, $socid)
Show stats for a product.
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.