dolibarr 20.0.0
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
30require '../main.inc.php';
31require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
32require_once DOL_DOCUMENT_ROOT.'/core/class/notify.class.php';
33require_once DOL_DOCUMENT_ROOT.'/societe/class/client.class.php';
34require_once DOL_DOCUMENT_ROOT.'/commande/class/commande.class.php';
35require_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
42if (!$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');
54if ($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
76llxHeader('', $langs->trans("Orders"), $help_url, '', 0, 0, '', '', '', 'mod-commande page-index');
77
78
79print load_fiche_titre($langs->trans("OrdersArea"), '', 'order');
80
81
82print '<div class="fichecenter"><div class="fichethirdleft">';
83
84$tmp = getCustomerOrderPieChart($socid);
85if ($tmp) {
86 print $tmp;
87 print '<br>';
88}
89
90
91/*
92 * Draft orders
93 */
94if (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
153print '</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";
167if (!$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";
173if ($socid) {
174 $sql .= " AND c.fk_soc = ".((int) $socid);
175}
176if (!$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);
183if ($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 */
246if (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 */
335if (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
421print '</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
427llxFooter();
428$db->close();
llxHeader
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Definition wrapper.php:55
llxFooter
llxFooter()
Empty footer.
Definition wrapper.php:69
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
finishSimpleTable
finishSimpleTable($addLineBreak=false)
Add the correct HTML close tags for "startSimpleTable(...)" (use after the last table line)
Definition functions.lib.php:13094
load_fiche_titre
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
Definition functions.lib.php:6183
GETPOSTINT
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
Definition functions.lib.php:1078
getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
Definition functions.lib.php:230
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:3215
dol_sanitizeFileName
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
Definition functions.lib.php:1547
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:5809
getDolGlobalString
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
Definition functions.lib.php:215
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:13046
getCustomerOrderPieChart
getCustomerOrderPieChart($socid=0)
Return a HTML table that contains a pie chart of sales orders.
Definition order.lib.php:227
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 Thu Sep 5 2024 01:00:27 for dolibarr by Doxygen 1.11.0