dolibarr  20.0.0-beta
index.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2003-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3  * Copyright (C) 2004-2011 Laurent Destailleur <eldy@users.sourceforge.net>
4  * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
5  * Copyright (C) 2019 Nicolas ZABOURI <info@inovea-conseil.com>
6  * Copyright (C) 2019 Frédéric France <frederic.france@netlogic.fr>
7  *
8  * This program is free software; you can redistribute it and/or modify
9  * it under the terms of the GNU General Public License as published by
10  * the Free Software Foundation; either version 3 of the License, or
11  * (at your option) any later version.
12  *
13  * This program is distributed in the hope that it will be useful,
14  * but WITHOUT ANY WARRANTY; without even the implied warranty of
15  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16  * GNU General Public License for more details.
17  *
18  * You should have received a copy of the GNU General Public License
19  * along with this program. If not, see <https://www.gnu.org/licenses/>.
20  */
21 
29 // Load Dolibarr environment
30 require '../main.inc.php';
31 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
32 require_once DOL_DOCUMENT_ROOT.'/core/class/notify.class.php';
33 require_once DOL_DOCUMENT_ROOT.'/societe/class/client.class.php';
34 require_once DOL_DOCUMENT_ROOT.'/commande/class/commande.class.php';
35 require_once DOL_DOCUMENT_ROOT.'/core/lib/order.lib.php';
36 
37 
38 // Load translation files required by the page
39 $langs->loadLangs(array('orders', 'bills'));
40 
41 
42 if (!$user->hasRight('commande', 'lire')) {
43  accessforbidden();
44 }
45 
46 $hookmanager = new HookManager($db);
47 
48 // Initialize technical object to manage hooks. Note that conf->hooks_modules contains array
49 $hookmanager->initHooks(array('ordersindex'));
50 
51 
52 // Security check
53 $socid = GETPOSTINT('socid');
54 if ($user->socid > 0) {
55  $action = '';
56  $socid = $user->socid;
57 }
58 
59 // Maximum elements of the tables
60 $max = getDolGlobalInt('MAIN_SIZE_SHORTLIST_LIMIT', 5);
61 $maxDraftCount = !getDolGlobalString('MAIN_MAXLIST_OVERLOAD') ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD;
62 $maxLatestEditCount = 5;
63 $maxOpenCount = !getDolGlobalString('MAIN_MAXLIST_OVERLOAD') ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD;
64 
65 
66 /*
67  * View
68  */
69 
70 $commandestatic = new Commande($db);
71 $companystatic = new Societe($db);
72 $form = new Form($db);
73 $formfile = new FormFile($db);
74 $help_url = "EN:Module_Customers_Orders|FR:Module_Commandes_Clients|ES:Módulo_Pedidos_de_clientes";
75 
76 llxHeader("", $langs->trans("Orders"), $help_url);
77 
78 
79 print load_fiche_titre($langs->trans("OrdersArea"), '', 'order');
80 
81 
82 print '<div class="fichecenter"><div class="fichethirdleft">';
83 
84 $tmp = getCustomerOrderPieChart($socid);
85 if ($tmp) {
86  print $tmp;
87  print '<br>';
88 }
89 
90 
91 /*
92  * Draft orders
93  */
94 if (isModEnabled('order')) {
95  $sql = "SELECT c.rowid, c.ref, s.nom as name, s.rowid as socid";
96  $sql .= ", s.client";
97  $sql .= ", s.code_client";
98  $sql .= ", s.canvas";
99  $sql .= " FROM ".MAIN_DB_PREFIX."commande as c";
100  $sql .= ", ".MAIN_DB_PREFIX."societe as s";
101  if (!$user->hasRight('societe', 'client', 'voir')) {
102  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
103  }
104  $sql .= " WHERE c.fk_soc = s.rowid";
105  $sql .= " AND c.entity IN (".getEntity('commande').")";
106  $sql .= " AND c.fk_statut = 0";
107  if ($socid) {
108  $sql .= " AND c.fk_soc = ".((int) $socid);
109  }
110  if (!$user->hasRight('societe', 'client', 'voir')) {
111  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
112  }
113 
114  $resql = $db->query($sql);
115  if ($resql) {
116  print '<div class="div-table-responsive-no-min">';
117  print '<table class="noborder centpercent">';
118  print '<tr class="liste_titre">';
119  print '<th colspan="2">'.$langs->trans("DraftOrders").'</th></tr>';
120  $langs->load("orders");
121  $num = $db->num_rows($resql);
122  if ($num) {
123  $i = 0;
124  while ($i < $num) {
125  $obj = $db->fetch_object($resql);
126 
127  $commandestatic->id = $obj->rowid;
128  $commandestatic->ref = $obj->ref;
129 
130  $companystatic->id = $obj->socid;
131  $companystatic->name = $obj->name;
132  $companystatic->client = $obj->client;
133  $companystatic->code_client = $obj->code_client;
134  $companystatic->canvas = $obj->canvas;
135 
136  print '<tr class="oddeven">';
137  print '<td class="nowrap">';
138  print $commandestatic->getNomUrl(1);
139  print "</td>";
140  print '<td class="nowrap">';
141  print $companystatic->getNomUrl(1, 'company', 16);
142  print '</td></tr>';
143  $i++;
144  }
145  } else {
146  print '<tr class="oddeven"><td colspan="3">'.$langs->trans("NoOrder").'</td></tr>';
147  }
148  print "</table></div><br>";
149  }
150 }
151 
152 
153 print '</div><div class="fichetwothirdright">';
154 
155 
156 /*
157  * Latest modified orders
158  */
159 
160 $sql = "SELECT c.rowid, c.entity, c.ref, c.fk_statut as status, c.facture, c.date_cloture as datec, c.tms as datem,";
161 $sql .= " s.nom as name, s.rowid as socid";
162 $sql .= ", s.client";
163 $sql .= ", s.code_client";
164 $sql .= ", s.canvas";
165 $sql .= " FROM ".MAIN_DB_PREFIX."commande as c,";
166 $sql .= " ".MAIN_DB_PREFIX."societe as s";
167 if (!$user->hasRight('societe', 'client', 'voir')) {
168  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
169 }
170 $sql .= " WHERE c.fk_soc = s.rowid";
171 $sql .= " AND c.entity IN (".getEntity('commande').")";
172 //$sql.= " AND c.fk_statut > 2";
173 if ($socid) {
174  $sql .= " AND c.fk_soc = ".((int) $socid);
175 }
176 if (!$user->hasRight('societe', 'client', 'voir')) {
177  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
178 }
179 $sql .= " ORDER BY c.tms DESC";
180 $sql .= $db->plimit($max, 0);
181 
182 $resql = $db->query($sql);
183 if ($resql) {
184  $num = $db->num_rows($resql);
185 
186  startSimpleTable($langs->trans("LastModifiedOrders", $max), "commande/list.php", "sortfield=c.tms&sortorder=DESC", 2, -1, 'order');
187 
188  if ($num) {
189  $i = 0;
190  while ($i < $num) {
191  $obj = $db->fetch_object($resql);
192 
193  print '<tr class="oddeven">';
194  print '<td width="20%" class="nowrap">';
195 
196  $commandestatic->id = $obj->rowid;
197  $commandestatic->ref = $obj->ref;
198 
199  $companystatic->id = $obj->socid;
200  $companystatic->name = $obj->name;
201  $companystatic->client = $obj->client;
202  $companystatic->code_client = $obj->code_client;
203  $companystatic->canvas = $obj->canvas;
204 
205  print '<table class="nobordernopadding"><tr class="nocellnopadd">';
206  print '<td width="96" class="nobordernopadding nowrap">';
207  print $commandestatic->getNomUrl(1);
208  print '</td>';
209 
210  print '<td width="16" class="nobordernopadding nowrap">';
211  print '&nbsp;';
212  print '</td>';
213 
214  print '<td width="16" class="nobordernopadding hideonsmartphone right">';
215  $filename = dol_sanitizeFileName($obj->ref);
216  $filedir = $conf->commande->multidir_output[$obj->entity].'/'.dol_sanitizeFileName($obj->ref);
217  $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->rowid;
218  print $formfile->getDocumentsLink($commandestatic->element, $filename, $filedir);
219  print '</td></tr></table>';
220 
221  print '</td>';
222 
223  print '<td class="nowrap">';
224  print $companystatic->getNomUrl(1, 'company', 16);
225  print '</td>';
226 
227  $datem = $db->jdate($obj->datem);
228  print '<td class="center" title="'.dol_escape_htmltag($langs->trans("DateModification").': '.dol_print_date($datem, 'dayhour', 'tzuserrel')).'">';
229  print dol_print_date($datem, 'day', 'tzuserrel');
230  print '</td>';
231 
232  print '<td class="right">'.$commandestatic->LibStatut($obj->status, $obj->facture, 3).'</td>';
233  print '</tr>';
234  $i++;
235  }
236  }
237  finishSimpleTable(true);
238 } else {
239  dol_print_error($db);
240 }
241 
242 
243 /*
244  * Orders to process
245  */
246 if (isModEnabled('order')) {
247  $sql = "SELECT c.rowid, c.entity, c.ref, c.fk_statut as status, c.facture, c.date_commande as date, s.nom as name, s.rowid as socid";
248  $sql .= ", s.client";
249  $sql .= ", s.code_client";
250  $sql .= ", s.canvas";
251  $sql .= " FROM ".MAIN_DB_PREFIX."commande as c";
252  $sql .= ", ".MAIN_DB_PREFIX."societe as s";
253  if (!$user->hasRight('societe', 'client', 'voir')) {
254  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
255  }
256  $sql .= " WHERE c.fk_soc = s.rowid";
257  $sql .= " AND c.entity IN (".getEntity('commande').")";
258  $sql .= " AND c.fk_statut = ".Commande::STATUS_VALIDATED;
259  if ($socid) {
260  $sql .= " AND c.fk_soc = ".((int) $socid);
261  }
262  if (!$user->hasRight('societe', 'client', 'voir')) {
263  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
264  }
265  $sql .= " ORDER BY c.rowid DESC";
266 
267  $resql = $db->query($sql);
268  if ($resql) {
269  $num = $db->num_rows($resql);
270 
271  print '<div class="div-table-responsive-no-min">';
272  print '<table class="noborder centpercent">';
273  print '<tr class="liste_titre">';
274  print '<th colspan="4">'.$langs->trans("OrdersToProcess").' <a href="'.DOL_URL_ROOT.'/commande/list.php?search_status='.Commande::STATUS_VALIDATED.'"><span class="badge">'.$num.'</span></a></th></tr>';
275 
276  if ($num) {
277  $i = 0;
278  while ($i < $num && $i < $max) {
279  $obj = $db->fetch_object($resql);
280  print '<tr class="oddeven">';
281  print '<td class="nowrap" width="20%">';
282 
283  $commandestatic->id = $obj->rowid;
284  $commandestatic->ref = $obj->ref;
285 
286  $companystatic->id = $obj->socid;
287  $companystatic->name = $obj->name;
288  $companystatic->client = $obj->client;
289  $companystatic->code_client = $obj->code_client;
290  $companystatic->canvas = $obj->canvas;
291 
292  print '<table class="nobordernopadding"><tr class="nocellnopadd">';
293  print '<td width="96" class="nobordernopadding nowrap">';
294  print $commandestatic->getNomUrl(1);
295  print '</td>';
296 
297  print '<td width="16" class="nobordernopadding nowrap">';
298  print '&nbsp;';
299  print '</td>';
300 
301  print '<td width="16" class="nobordernopadding hideonsmartphone right">';
302  $filename = dol_sanitizeFileName($obj->ref);
303  $filedir = $conf->commande->multidir_output[$obj->entity].'/'.dol_sanitizeFileName($obj->ref);
304  $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->rowid;
305  print $formfile->getDocumentsLink($commandestatic->element, $filename, $filedir);
306  print '</td></tr></table>';
307 
308  print '</td>';
309 
310  print '<td class="nowrap">';
311  print $companystatic->getNomUrl(1, 'company', 24);
312  print '</td>';
313 
314  print '<td class="right">'.dol_print_date($db->jdate($obj->date), 'day').'</td>'."\n";
315 
316  print '<td class="right">'.$commandestatic->LibStatut($obj->status, $obj->facture, 3).'</td>';
317 
318  print '</tr>';
319  $i++;
320  }
321  if ($i < $num) {
322  print '<tr><td><span class="opacitymedium">'.$langs->trans("More").'...</span></td><td></td><td></td><td></td></tr>';
323  }
324  }
325 
326  print "</table></div><br>";
327  } else {
328  dol_print_error($db);
329  }
330 }
331 
332 /*
333  * Orders that are in process
334  */
335 if (isModEnabled('order')) {
336  $sql = "SELECT c.rowid, c.entity, c.ref, c.fk_statut as status, c.facture, c.date_commande as date, s.nom as name, s.rowid as socid";
337  $sql .= ", s.client";
338  $sql .= ", s.code_client";
339  $sql .= ", s.canvas";
340  $sql .= " FROM ".MAIN_DB_PREFIX."commande as c";
341  $sql .= ", ".MAIN_DB_PREFIX."societe as s";
342  if (!$user->hasRight('societe', 'client', 'voir')) {
343  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
344  }
345  $sql .= " WHERE c.fk_soc = s.rowid";
346  $sql .= " AND c.entity IN (".getEntity('commande').")";
347  $sql .= " AND c.fk_statut = ".((int) Commande::STATUS_ACCEPTED);
348  if ($socid) {
349  $sql .= " AND c.fk_soc = ".((int) $socid);
350  }
351  if (!$user->hasRight('societe', 'client', 'voir')) {
352  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
353  }
354  $sql .= " ORDER BY c.rowid DESC";
355 
356  $resql = $db->query($sql);
357  if ($resql) {
358  $num = $db->num_rows($resql);
359 
360  print '<div class="div-table-responsive-no-min">';
361  print '<table class="noborder centpercent">';
362  print '<tr class="liste_titre">';
363  print '<th colspan="4">'.$langs->trans("OnProcessOrders").' <a href="'.DOL_URL_ROOT.'/commande/list.php?search_status='.Commande::STATUS_ACCEPTED.'"><span class="badge">'.$num.'</span></a></th></tr>';
364 
365  if ($num) {
366  $i = 0;
367  while ($i < $num && $i < $max) {
368  $obj = $db->fetch_object($resql);
369  print '<tr class="oddeven">';
370  print '<td width="20%" class="nowrap">';
371 
372  $commandestatic->id = $obj->rowid;
373  $commandestatic->ref = $obj->ref;
374 
375  $companystatic->id = $obj->socid;
376  $companystatic->name = $obj->name;
377  $companystatic->client = $obj->client;
378  $companystatic->code_client = $obj->code_client;
379  $companystatic->canvas = $obj->canvas;
380 
381  print '<table class="nobordernopadding"><tr class="nocellnopadd">';
382  print '<td width="96" class="nobordernopadding nowrap">';
383  print $commandestatic->getNomUrl(1);
384  print '</td>';
385 
386  print '<td width="16" class="nobordernopadding nowrap">';
387  print '&nbsp;';
388  print '</td>';
389 
390  print '<td width="16" class="nobordernopadding hideonsmartphone right">';
391  $filename = dol_sanitizeFileName($obj->ref);
392  $filedir = $conf->commande->multidir_output[$obj->entity].'/'.dol_sanitizeFileName($obj->ref);
393  $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->rowid;
394  print $formfile->getDocumentsLink($commandestatic->element, $filename, $filedir);
395  print '</td></tr></table>';
396 
397  print '</td>';
398 
399  print '<td>';
400  print $companystatic->getNomUrl(1, 'company');
401  print '</td>';
402 
403  print '<td class="right">'.dol_print_date($db->jdate($obj->date), 'day').'</td>'."\n";
404 
405  print '<td class="right">'.$commandestatic->LibStatut($obj->status, $obj->facture, 3).'</td>';
406 
407  print '</tr>';
408  $i++;
409  }
410  if ($i < $num) {
411  print '<tr><td><span class="opacitymedium">'.$langs->trans("More").'...</span></td><td></td><td></td><td></td></tr>';
412  }
413  }
414  print "</table></div><br>";
415  } else {
416  dol_print_error($db);
417  }
418 }
419 
420 
421 print '</div></div>';
422 
423 $parameters = array('user' => $user);
424 $reshook = $hookmanager->executeHooks('dashboardOrders', $parameters, $object); // Note that $action and $object may have been modified by hook
425 
426 // End of page
427 llxFooter();
428 $db->close();
$object
if($user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition: card.php:58
Commande
Class to manage customers orders.
Definition: commande.class.php:50
Commande\STATUS_VALIDATED
const STATUS_VALIDATED
Validated status.
Definition: commande.class.php:361
FormFile
Class to offer components to list and upload files.
Definition: html.formfile.class.php:38
Form
Class to manage generation of HTML components Only common components must be here.
Definition: html.form.class.php:56
HookManager
Class to manage hooks.
Definition: hookmanager.class.php:32
Societe
Class to manage third parties objects (customers, suppliers, prospects...)
Definition: societe.class.php:55
$sql
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
Definition: index.php:745
finishSimpleTable
finishSimpleTable($addLineBreak=false)
Add the correct HTML close tags for "startSimpleTable(...)" (use after the last table line)
Definition: functions.lib.php:12985
load_fiche_titre
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
Definition: functions.lib.php:6137
GETPOSTINT
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
Definition: functions.lib.php:1068
getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
Definition: functions.lib.php:223
dol_print_date
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).
Definition: functions.lib.php:3182
dol_sanitizeFileName
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
Definition: functions.lib.php:1537
dol_print_error
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
Definition: functions.lib.php:5766
getDolGlobalString
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
Definition: functions.lib.php:208
isModEnabled
isModEnabled($module)
Is Dolibarr module enabled.
Definition: functions.lib.php:305
startSimpleTable
startSimpleTable($header, $link="", $arguments="", $emptyColumns=0, $number=-1, $pictofulllist='')
Start a table with headers and a optional clickable number (don't forget to use "finishSimpleTable()"...
Definition: functions.lib.php:12937
getCustomerOrderPieChart
getCustomerOrderPieChart($socid=0)
Return a HTML table that contains a pie chart of sales orders.
Definition: order.lib.php:227
llxFooter
llxFooter()
Footer empty.
Definition: index.php:72
llxHeader
if(!defined('NOTOKENRENEWAL')) if(!defined('NOLOGIN')) if(!defined('NOCSRFCHECK')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) if(!defined('NOIPCHECK')) if(!defined('NOBROWSERNOTIF')) llxHeader()
Header empty.
Definition: index.php:64
accessforbidden
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.
Definition: security.lib.php:1204
Generated on Sat Jun 1 2024 01:00:29 for dolibarr by Doxygen 1.9.1