dolibarr  16.0.5
commande.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  *
7  * This program is free software; you can redistribute it and/or modify
8  * it under the terms of the GNU General Public License as published by
9  * the Free Software Foundation; either version 3 of the License, or
10  * (at your option) any later version.
11  *
12  * This program is distributed in the hope that it will be useful,
13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15  * GNU General Public License for more details.
16  *
17  * You should have received a copy of the GNU General Public License
18  * along with this program. If not, see <https://www.gnu.org/licenses/>.
19  */
20 
27 require '../../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
29 require_once DOL_DOCUMENT_ROOT.'/commande/class/commande.class.php';
30 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
31 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
32 
33 // Load translation files required by the page
34 $langs->loadLangs(array('orders', 'products', 'companies'));
35 
36 $id = GETPOST('id', 'int');
37 $ref = GETPOST('ref', 'alpha');
38 
39 // Security check
40 $fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
41 $fieldtype = (!empty($ref) ? 'ref' : 'rowid');
42 $socid = '';
43 if (!empty($user->socid)) {
44  $socid = $user->socid;
45 }
46 
47 // Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
48 $hookmanager->initHooks(array('productstatsorder'));
49 
50 // Load variable for pagination
51 $limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;
52 $sortfield = GETPOST('sortfield', 'aZ09comma');
53 $sortorder = GETPOST('sortorder', 'aZ09comma');
54 $page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
55 if (empty($page) || $page == -1) {
56  $page = 0;
57 } // If $page is not defined, or '' or -1
58 $offset = $limit * $page;
59 $pageprev = $page - 1;
60 $pagenext = $page + 1;
61 if (!$sortorder) {
62  $sortorder = "DESC";
63 }
64 if (!$sortfield) {
65  $sortfield = "c.date_commande";
66 }
67 $search_month = GETPOST('search_month', 'int');
68 $search_year = GETPOST('search_year', 'int');
69 
70 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
71  $search_month = '';
72  $search_year = '';
73 }
74 
75 $result = restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
76 
77 
78 /*
79  * View
80  */
81 
82 $orderstatic = new Commande($db);
83 $societestatic = new Societe($db);
84 
85 $form = new Form($db);
86 $formother = new FormOther($db);
87 
88 if ($id > 0 || !empty($ref)) {
89  $product = new Product($db);
90  $result = $product->fetch($id, $ref);
91 
92  $object = $product;
93 
94  $parameters = array('id'=>$id);
95  $reshook = $hookmanager->executeHooks('doActions', $parameters, $product, $action); // Note that $action and $object may have been modified by some hooks
96  if ($reshook < 0) {
97  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
98  }
99 
100  llxHeader("", "", $langs->trans("CardProduct".$product->type));
101 
102  if ($result > 0) {
103  $head = product_prepare_head($product);
104  $titre = $langs->trans("CardProduct".$product->type);
105  $picto = ($product->type == Product::TYPE_SERVICE ? 'service' : 'product');
106  print dol_get_fiche_head($head, 'referers', $titre, -1, $picto);
107 
108  $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $product, $action); // Note that $action and $object may have been modified by hook
109  print $hookmanager->resPrint;
110  if ($reshook < 0) {
111  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
112  }
113 
114  $linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
115 
116  $shownav = 1;
117  if ($user->socid && !in_array('product', explode(',', $conf->global->MAIN_MODULES_FOR_EXTERNAL))) {
118  $shownav = 0;
119  }
120 
121  dol_banner_tab($object, 'ref', $linkback, $shownav, 'ref');
122 
123  print '<div class="fichecenter">';
124 
125  print '<div class="underbanner clearboth"></div>';
126  print '<table class="border tableforfield" width="100%">';
127 
128  $nboflines = show_stats_for_company($product, $socid);
129 
130  print "</table>";
131 
132  print '</div>';
133  print '<div style="clear:both"></div>';
134 
135  print dol_get_fiche_end();
136 
137 
138  if ($user->rights->commande->lire) {
139  $sql = "SELECT DISTINCT s.nom as name, s.rowid as socid, s.code_client, c.rowid, d.total_ht as total_ht, c.ref,";
140  $sql .= " c.ref_client,";
141  $sql .= " c.date_commande, c.fk_statut as statut, c.facture, c.rowid as commandeid, d.rowid, d.qty";
142  if (empty($user->rights->societe->client->voir) && !$socid) {
143  $sql .= ", sc.fk_soc, sc.fk_user ";
144  }
145  $sql .= " FROM ".MAIN_DB_PREFIX."societe as s";
146  $sql .= ", ".MAIN_DB_PREFIX."commande as c";
147  $sql .= ", ".MAIN_DB_PREFIX."commandedet as d";
148  if (empty($user->rights->societe->client->voir) && !$socid) {
149  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
150  }
151  $sql .= " WHERE c.fk_soc = s.rowid";
152  $sql .= " AND c.entity IN (".getEntity('commande').")";
153  $sql .= " AND d.fk_commande = c.rowid";
154  $sql .= " AND d.fk_product = ".((int) $product->id);
155  if (!empty($search_month)) {
156  $sql .= ' AND MONTH(c.date_commande) IN ('.$db->sanitize($search_month).')';
157  }
158  if (!empty($search_year)) {
159  $sql .= ' AND YEAR(c.date_commande) IN ('.$db->sanitize($search_year).')';
160  }
161  if (empty($user->rights->societe->client->voir) && !$socid) {
162  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
163  }
164  if ($socid) {
165  $sql .= " AND c.fk_soc = ".((int) $socid);
166  }
167  $sql .= $db->order($sortfield, $sortorder);
168 
169  //Calcul total qty and amount for global if full scan list
170  $total_ht = 0;
171  $total_qty = 0;
172 
173  // Count total nb of records
174  $totalofrecords = '';
175  if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
176  $result = $db->query($sql);
177  $totalofrecords = $db->num_rows($result);
178  }
179 
180  $sql .= $db->plimit($limit + 1, $offset);
181 
182  $result = $db->query($sql);
183  if ($result) {
184  $num = $db->num_rows($result);
185 
186  $option .= '&id='.$product->id;
187 
188  if ($limit > 0 && $limit != $conf->liste_limit) {
189  $option .= '&limit='.urlencode($limit);
190  }
191  if (!empty($search_month)) {
192  $option .= '&search_month='.urlencode($search_month);
193  }
194  if (!empty($search_year)) {
195  $option .= '&search_year='.urlencode($search_year);
196  }
197 
198  print '<form method="post" action="'.$_SERVER ['PHP_SELF'].'?id='.$product->id.'" name="search_form">'."\n";
199  print '<input type="hidden" name="token" value="'.newToken().'">';
200  if (!empty($sortfield)) {
201  print '<input type="hidden" name="sortfield" value="'.$sortfield.'"/>';
202  }
203  if (!empty($sortorder)) {
204  print '<input type="hidden" name="sortorder" value="'.$sortorder.'"/>';
205  }
206 
207  print_barre_liste($langs->trans("CustomersOrders"), $page, $_SERVER["PHP_SELF"], $option, $sortfield, $sortorder, '', $num, $totalofrecords, '', 0, '', '', $limit, 0, 0, 1);
208 
209  if (!empty($page)) {
210  $option .= '&page='.urlencode($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("OrderDate").') - ';
216  print $langs->trans('Month').':<input class="flat" type="text" size="4" name="search_month" value="'.$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', '', '', 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', '', '', 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"], "c.rowid", "", $option, '', $sortfield, $sortorder);
230  print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", $option, '', $sortfield, $sortorder);
231  print_liste_field_titre("CustomerCode", $_SERVER["PHP_SELF"], "s.code_client", "", $option, '', $sortfield, $sortorder);
232  print_liste_field_titre("OrderDate", $_SERVER["PHP_SELF"], "c.date_commande", "", $option, 'align="center"', $sortfield, $sortorder);
233  print_liste_field_titre("Qty", $_SERVER["PHP_SELF"], "d.qty", "", $option, 'align="center"', $sortfield, $sortorder);
234  print_liste_field_titre("AmountHT", $_SERVER["PHP_SELF"], "c.total_ht", "", $option, 'align="right"', $sortfield, $sortorder);
235  print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "c.fk_statut", "", $option, 'align="right"', $sortfield, $sortorder);
236  print "</tr>\n";
237 
238  if ($num > 0) {
239  while ($i < min($num, $limit)) {
240  $objp = $db->fetch_object($result);
241 
242  $total_ht += $objp->total_ht;
243  $total_qty += $objp->qty;
244 
245  $orderstatic->id = $objp->commandeid;
246  $orderstatic->ref = $objp->ref;
247  $orderstatic->ref_client = $objp->ref_client;
248  $societestatic->fetch($objp->socid);
249 
250  print '<tr class="oddeven">';
251  print '<td>';
252  print $orderstatic->getNomUrl(1);
253  print "</td>\n";
254  print '<td>'.$societestatic->getNomUrl(1).'</td>';
255  print "<td>".$objp->code_client."</td>\n";
256  print '<td class="center">';
257  print dol_print_date($db->jdate($objp->date_commande), 'dayhour')."</td>";
258  print '<td class="center">'.$objp->qty."</td>\n";
259  print '<td align="right">'.price($objp->total_ht)."</td>\n";
260  print '<td align="right">'.$orderstatic->LibStatut($objp->statut, $objp->facture, 5).'</td>';
261  print "</tr>\n";
262  $i++;
263  }
264  }
265  print '<tr class="liste_total">';
266  if ($num < $limit) {
267  print '<td class="left">'.$langs->trans("Total").'</td>';
268  } else {
269  print '<td class="left">'.$langs->trans("Totalforthispage").'</td>';
270  }
271  print '<td colspan="3"></td>';
272  print '<td class="center">'.$total_qty.'</td>';
273  print '<td align="right">'.price($total_ht).'</td>';
274  print '<td></td>';
275  print "</table>";
276  print "</div>";
277  print '</form>';
278  } else {
279  dol_print_error($db);
280  }
281  $db->free($result);
282  }
283  }
284 } else {
285  dol_print_error();
286 }
287 
288 // End of page
289 llxFooter();
290 $db->close();
Societe
Class to manage third parties objects (customers, suppliers, prospects...)
Definition: societe.class.php:48
dol_escape_htmltag
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0)
Returns text escaped for inclusion in HTML alt or title tags, or into values of HTML input fields.
Definition: functions.lib.php:1468
restrictedArea
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.
Definition: security.lib.php:234
llxFooter
llxFooter()
Empty footer.
Definition: wrapper.php:73
GETPOST
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
Definition: functions.lib.php:484
dol_print_error
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
Definition: functions.lib.php:4844
product_prepare_head
product_prepare_head($object)
Prepare array with list of tabs.
Definition: product.lib.php:35
$form
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:142
FormOther
Classe permettant la generation de composants html autre Only common components are here.
Definition: html.formother.class.php:39
dol_banner_tab
dol_banner_tab($object, $paramid, $morehtml='', $shownav=1, $fieldid='rowid', $fieldref='ref', $morehtmlref='', $moreparam='', $nodbprefix=0, $morehtmlleft='', $morehtmlstatus='', $onlybanner=0, $morehtmlright='')
Show tab footer of a card.
Definition: functions.lib.php:2046
dol_print_date
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
Definition: functions.lib.php:2514
Commande
Class to manage customers orders.
Definition: commande.class.php:46
print_barre_liste
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.
Definition: functions.lib.php:5257
dol_get_fiche_head
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='')
Show tabs of a record.
Definition: functions.lib.php:1822
dol_get_fiche_end
dol_get_fiche_end($notab=0)
Return tab footer of a card.
Definition: functions.lib.php:2018
GETPOSTISSET
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
Definition: functions.lib.php:386
print_liste_field_titre
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
Definition: functions.lib.php:5026
Product
Class to manage products or services.
Definition: product.class.php:46
Form
Class to manage generation of HTML components Only common components must be here.
Definition: html.form.class.php:52
show_stats_for_company
show_stats_for_company($product, $socid)
Show stats for company.
Definition: product.lib.php:361
Product\TYPE_SERVICE
const TYPE_SERVICE
Service.
Definition: product.class.php:504
setEventMessages
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='')
Set event messages in dol_events session object.
Definition: functions.lib.php:8137
llxHeader
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Definition: wrapper.php:59