dolibarr 21.0.0-beta
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
44// Load translation files required by the page
45$langs->loadLangs(array('orders', 'receptions', 'products', 'companies'));
46
47$id = GETPOSTINT('id');
48$ref = GETPOST('ref', 'alpha');
49
50// Security check
51$fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
52$fieldtype = (!empty($ref) ? 'ref' : 'rowid');
53$socid = '';
54if (!empty($user->socid)) {
55 $socid = $user->socid;
56}
57
58// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
59$hookmanager->initHooks(array('productstatsreception'));
60
61// Load variable for pagination
62$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
63$sortfield = GETPOST('sortfield', 'aZ09comma');
64$sortorder = GETPOST('sortorder', 'aZ09comma');
65$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
66if (empty($page) || $page == -1) {
67 $page = 0;
68} // If $page is not defined, or '' or -1
69$offset = $limit * $page;
70$pageprev = $page - 1;
71$pagenext = $page + 1;
72if (!$sortorder) {
73 $sortorder = "DESC";
74}
75if (!$sortfield) {
76 $sortfield = "r.date_creation";
77}
78$search_month = GETPOSTINT('search_month');
79$search_year = GETPOSTINT('search_year');
80
81if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
82 $search_month = '';
83 $search_year = '';
84}
85
86$result = restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
87
88
89/*
90 * View
91 */
92
93$receptionstatic = new Reception($db);
94$societestatic = new Societe($db);
95
96$form = new Form($db);
97$formother = new FormOther($db);
98
99if ($id > 0 || !empty($ref)) {
100 $product = new Product($db);
101 $result = $product->fetch($id, $ref);
102
103 $object = $product;
104
105 $parameters = array('id' => $id);
106 $reshook = $hookmanager->executeHooks('doActions', $parameters, $product, $action); // Note that $action and $object may have been modified by some hooks
107 if ($reshook < 0) {
108 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
109 }
110
111 llxHeader('', '', $langs->trans("CardProduct".$product->type), '', 0, 0, '', '', '', '', 'mod-product page-stats_reception');
112
113 if ($result > 0) {
114 $head = product_prepare_head($product);
115 $titre = $langs->trans("CardProduct".$product->type);
116 $picto = ($product->type == Product::TYPE_SERVICE ? 'service' : 'product');
117 print dol_get_fiche_head($head, 'referers', $titre, -1, $picto);
118
119 $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $product, $action); // Note that $action and $object may have been modified by hook
120 print $hookmanager->resPrint;
121 if ($reshook < 0) {
122 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
123 }
124
125 $linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
126
127 $shownav = 1;
128 if ($user->socid && !in_array('product', explode(',', getDolGlobalString('MAIN_MODULES_FOR_EXTERNAL')))) {
129 $shownav = 0;
130 }
131
132 dol_banner_tab($object, 'ref', $linkback, $shownav, 'ref');
133
134 print '<div class="fichecenter">';
135
136 print '<div class="underbanner clearboth"></div>';
137 print '<table class="border tableforfield" width="100%">';
138
139 $nboflines = show_stats_for_company($product, $socid);
140
141 print "</table>";
142
143 print '</div>';
144 print '<div class="clearboth"></div>';
145
146 print dol_get_fiche_end();
147
148
149 if ($user->hasRight('reception', 'lire')) {
150 $sql = "SELECT DISTINCT s.nom as name, s.rowid as socid, s.code_fournisseur, r.ref, r.ref_supplier";
151 $sql .= ", r.date_creation, r.date_delivery, r.fk_statut as statut, r.rowid as receptionid, cfd.rowid";
152 $sql .= ", cfd.qty, cfdet.subprice * (100 - cfdet.remise_percent) / 100 * cfd.qty AS total_ht";
153 if (empty($user->rights->societe->client->voir) && !$socid) {
154 $sql .= ", sc.fk_soc, sc.fk_user ";
155 }
156 $sql .= " FROM ".MAIN_DB_PREFIX."societe as s";
157 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."reception as r ON r.fk_soc = s.rowid";
158 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."receptiondet_batch as cfd ON cfd.fk_reception = r.rowid AND element_type = 'supplier_order'";
159 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."commande_fournisseurdet as cfdet ON cfdet.rowid = cfd.fk_elementdet";
160 if (empty($user->rights->societe->client->voir) && !$socid) {
161 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
162 }
163 $sql .= " WHERE r.entity IN (".getEntity('reception').")";
164 $sql .= " AND cfd.fk_product = ".((int) $product->id);
165 if (!empty($search_month)) {
166 $sql .= ' AND MONTH(r.date_creation) IN ('.$db->sanitize($search_month).')';
167 }
168 if (!empty($search_year)) {
169 $sql .= ' AND YEAR(r.date_creation) IN ('.$db->sanitize($search_year).')';
170 }
171 if ($socid) {
172 $sql .= " AND r.fk_soc = ".((int) $socid);
173 }
174 $sql .= $db->order($sortfield, $sortorder);
175
176 //Calcul total qty and amount for global if full scan list
177 $total_ht = 0;
178 $total_qty = 0;
179
180 // Count total nb of records
181 $totalofrecords = '';
182 if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
183 $result = $db->query($sql);
184 $totalofrecords = $db->num_rows($result);
185 }
186
187 $sql .= $db->plimit($limit + 1, $offset);
188
189 $result = $db->query($sql);
190 if ($result) {
191 $num = $db->num_rows($result);
192
193 $option = '&id='.$product->id;
194
195 if ($limit > 0 && $limit != $conf->liste_limit) {
196 $option .= '&limit='.((int) $limit);
197 }
198 if (!empty($search_month)) {
199 $option .= '&search_month='.urlencode((string) ($search_month));
200 }
201 if (!empty($search_year)) {
202 $option .= '&search_year='.urlencode((string) ($search_year));
203 }
204
205 print '<form method="post" action="'.$_SERVER ['PHP_SELF'].'?id='.$product->id.'" name="search_form">'."\n";
206 print '<input type="hidden" name="token" value="'.newToken().'">';
207 if (!empty($sortfield)) {
208 print '<input type="hidden" name="sortfield" value="'.$sortfield.'"/>';
209 }
210 if (!empty($sortorder)) {
211 print '<input type="hidden" name="sortorder" value="'.$sortorder.'"/>';
212 }
213
214 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
215 print_barre_liste($langs->trans("Receptions"), $page, $_SERVER["PHP_SELF"], $option, $sortfield, $sortorder, '', $num, $totalofrecords, '', 0, '', '', $limit, 0, 0, 1);
216
217 if (!empty($page)) {
218 $option .= '&page='.urlencode((string) ($page));
219 }
220
221 print '<div class="liste_titre liste_titre_bydiv centpercent">';
222 print '<div class="divsearchfield">';
223 print $langs->trans('Period').' ('.$langs->trans("DateCreation").') - ';
224 print $langs->trans('Month').':<input class="flat" type="text" size="4" name="search_month" value="'.($search_month > 0 ? $search_month : '').'"> ';
225 print $langs->trans('Year').':'.$formother->selectyear($search_year ? $search_year : - 1, 'search_year', 1, 20, 5);
226 print '<div style="vertical-align: middle; display: inline-block">';
227 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")).'">';
228 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")).'">';
229 print '</div>';
230 print '</div>';
231 print '</div>';
232
233 $i = 0;
234 print '<div class="div-table-responsive">';
235 print '<table class="tagtable liste listwithfilterbefore" width="100%">';
236 print '<tr class="liste_titre">';
237 print_liste_field_titre("Ref", $_SERVER["PHP_SELF"], "r.rowid", "", $option, '', $sortfield, $sortorder);
238 print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", $option, '', $sortfield, $sortorder);
239 print_liste_field_titre("SupplierCode", $_SERVER["PHP_SELF"], "s.code_fournisseur", "", $option, '', $sortfield, $sortorder);
240 print_liste_field_titre("DateCreation", $_SERVER["PHP_SELF"], "r.date_creation", "", $option, 'align="center"', $sortfield, $sortorder);
241 print_liste_field_titre('DateDeliveryPlanned', $_SERVER['PHP_SELF'], 'r.date_delivery', '', $option, 'align="center"', $sortfield, $sortorder);
242 print_liste_field_titre("Qty", $_SERVER["PHP_SELF"], "cfd.qty", "", $option, 'align="center"', $sortfield, $sortorder);
243 print_liste_field_titre("AmountHT", $_SERVER["PHP_SELF"], "total_ht", "", $option, 'align="right"', $sortfield, $sortorder);
244 print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "r.fk_statut", "", $option, 'align="right"', $sortfield, $sortorder);
245 print "</tr>\n";
246
247 if ($num > 0) {
248 while ($i < min($num, $limit)) {
249 $objp = $db->fetch_object($result);
250
251 $objp->total_ht = price2num($objp->total_ht, 'MT');
252 $total_ht += $objp->total_ht;
253 $total_qty += $objp->qty;
254
255 $receptionstatic->id = $objp->receptionid;
256 $receptionstatic->ref = $objp->ref;
257 $receptionstatic->ref_supplier = $objp->ref_supplier;
258 $societestatic->fetch($objp->socid);
259
260 print '<tr class="oddeven">';
261 print '<td>';
262 print $receptionstatic->getNomUrl(1);
263 print "</td>\n";
264 print '<td>'.$societestatic->getNomUrl(1).'</td>';
265 print "<td>".$objp->code_fournisseur."</td>\n";
266 print '<td class="center">';
267 print dol_print_date($db->jdate($objp->date_creation), 'dayhour')."</td>";
268 // delivery planned date
269 print '<td class="center">';
270 print dol_print_date($db->jdate($objp->date_delivery), 'dayhour');
271 print '</td>';
272 print '<td class="center">'.$objp->qty."</td>\n";
273 print '<td align="right">'.price($objp->total_ht)."</td>\n";
274 print '<td align="right">'.$receptionstatic->LibStatut($objp->statut, 4).'</td>';
275 print "</tr>\n";
276 $i++;
277 }
278 }
279 print '<tr class="liste_total">';
280 if ($num < $limit && empty($offset)) {
281 print '<td>'.$langs->trans("Total").'</td>';
282 } else {
283 print '<td>'.$form->textwithpicto($langs->trans("Total"), $langs->trans("Totalforthispage")).'</td>';
284 }
285 print '<td colspan="3"></td>';
286 print '<td></td>';
287 print '<td class="center">'.$total_qty.'</td>';
288 print '<td align="right">'.price($total_ht).'</td>';
289 print '<td></td>';
290 print "</table>";
291 print "</div>";
292 print '</form>';
293 } else {
294 dol_print_error($db);
295 }
296 $db->free($result);
297 }
298 }
299} else {
301}
302
303// End of page
304llxFooter();
305$db->close();
$id
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:66
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:71
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.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
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.
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...
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
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.