dolibarr 21.0.0-alpha
customer.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2007 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2009 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2012 Andreu Bisquerra Gaya <jove@bisquerra.com>
6 * Copyright (C) 2012 David Rodriguez Martinez <davidrm146@gmail.com>
7 * Copyright (C) 2012 Juanjo Menent <jmenent@2byte.es>
8 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 */
23
30// Load Dolibarr environment
31require '../main.inc.php';
32require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
33require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
34
35$action = GETPOST('action', 'aZ09');
36
37// Secrutiy check
38if ($user->socid > 0) {
39 $action = '';
40 $socid = $user->socid;
41}
42
43if (!$user->hasRight('facture', 'creer')) {
45}
46
47// Load translation files required by the page
48$langs->loadLangs(array("companies", "orders"));
49
50$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
51$sortfield = GETPOST('sortfield', 'aZ09comma');
52$sortorder = GETPOST('sortorder', 'aZ09comma');
53$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT('page');
54if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
55 // If $page is not defined, or '' or -1 or if we click on clear filters
56 $page = 0;
57}
58$offset = $limit * $page;
59$pageprev = $page - 1;
60$pagenext = $page + 1;
61if (!$sortorder) {
62 $sortorder = "ASC";
63}
64if (!$sortfield) {
65 $sortfield = "nom";
66}
67
68
69/*
70 * View
71 */
72
73llxHeader('', '', '', '', 0, 0, '', '', '', 'mod-commande page-customer');
74
75$thirdpartystatic = new Societe($db);
76
77/*
78 * Mode List
79 */
80
81$sql = "SELECT s.rowid, s.nom as name, s.client, s.town, s.datec, s.datea,";
82$sql .= " st.libelle as stcomm, s.prefix_comm, s.code_client, s.code_compta as code_compta_client";
83$sql .= " FROM ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."c_stcomm as st, ".MAIN_DB_PREFIX."commande as c";
84$sql .= " WHERE s.fk_stcomm = st.id AND c.fk_soc = s.rowid";
85$sql .= " AND s.entity IN (".getEntity('societe').")";
86if (GETPOST("search_nom")) {
87 $sql .= natural_search("s.nom", GETPOST("search_nom"));
88}
89if (GETPOST("search_compta")) {
90 $sql .= natural_search("s.code_compta", GETPOST("search_compta"));
91}
92if (GETPOST("search_code_client")) {
93 $sql .= natural_search("s.code_client", GETPOST("search_code_client"));
94}
95if (dol_strlen($begin)) {
96 $sql .= " AND s.nom like '".$db->escape($begin)."'";
97}
98// If the internal user must only see his customers, force searching by him
99$search_sale = 0;
100if (!$user->hasRight('societe', 'client', 'voir')) {
101 $search_sale = $user->id;
102}
103// Search on sale representative
104if ($search_sale && $search_sale != '-1') {
105 if ($search_sale == -2) {
106 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc)";
107 } elseif ($search_sale > 0) {
108 $sql .= " AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $search_sale).")";
109 }
110}
111// Search on socid
112if ($socid) {
113 $sql .= " AND c.fk_soc = ".((int) $socid);
114}
115$sql .= " AND c.fk_statut in (1, 2) AND c.facture = 0";
116$sql .= " GROUP BY s.nom";
117$sql .= $db->order($sortfield, $sortorder);
118
119// Count total nb of records
120$nbtotalofrecords = '';
121if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
122 $result = $db->query($sql);
123 $nbtotalofrecords = $db->num_rows($result);
124
125 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
126 $page = 0;
127 $offset = 0;
128 }
129}
130
131$sql .= $db->plimit($limit + 1, $offset);
132//print $sql;
133
134$resql = $db->query($sql);
135if ($resql) {
136 $num = $db->num_rows($resql);
137 $i = 0;
138
139 print_barre_liste($langs->trans("MenuOrdersToBill"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num);
140
141 print '<form method="GET" action="'.$_SERVER["PHP_SELF"].'">';
142
143 print '<table class="liste centpercent">';
144 print '<tr class="liste_titre">';
145
146 print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", "", 'valign="center"', $sortfield, $sortorder);
147 print_liste_field_titre("Town", $_SERVER["PHP_SELF"], "s.town", "", "", 'valign="center"', $sortfield, $sortorder);
148 print_liste_field_titre("CustomerCode", $_SERVER["PHP_SELF"], "s.code_client", "", "", 'align="left"', $sortfield, $sortorder);
149 print_liste_field_titre("AccountancyCode", $_SERVER["PHP_SELF"], "s.code_compta", "", "", 'align="left"', $sortfield, $sortorder);
150 print_liste_field_titre("DateCreation", $_SERVER["PHP_SELF"], "datec", $addu, "", 'class="right"', $sortfield, $sortorder);
151 print "</tr>\n";
152
153 // Fields title search
154 print '<tr class="liste_titre">';
155
156 print '<td align="left" class="liste_titre">';
157 print '<input class="flat" type="text" name="search_nom" value="'.dol_escape_htmltag(GETPOST("search_nom")).'"></td>';
158
159 print '<td class="liste_titre">&nbsp;</td>';
160
161 print '<td align="left" class="liste_titre">';
162 print '<input class="flat" type="text" size="10" name="search_code_client" value="'.dol_escape_htmltag(GETPOST("search_code_client")).'">';
163 print '</td>';
164
165 print '<td align="left" class="liste_titre">';
166 print '<input class="flat" type="text" size="10" name="search_compta" value="'.dol_escape_htmltag(GETPOST("search_compta")).'">';
167 print '</td>';
168
169 print '<td colspan="2" class="liste_titre right">';
170 print '<input type="image" class="liste_titre" src="'.img_picto($langs->trans("Search"), 'search.png', '', 0, 1).'" name="button_search" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'">';
171 print '</td>';
172
173 print "</tr>\n";
174
175 while ($i < min($num, $limit)) {
176 $obj = $db->fetch_object($resql);
177
178 print '<tr class="oddeven">';
179 print '<td>';
180
181 $result = '';
182 $link = $linkend = '';
183 $link = '<a href="'.DOL_URL_ROOT.'/commande/list.php?socid='.$obj->rowid.'">';
184 $linkend = '</a>';
185 $name = $obj->name;
186 $result .= ($link.img_object($langs->trans("ShowCompany").': '.$name, 'company').$linkend);
187 $result .= $link.(dol_trunc($name, $maxlen)).$linkend;
188
189 print $result;
190 print '</td>';
191 print '<td>'.dolPrintLabel($obj->town).'</td>';
192 print '<td class="left">'.dolPrintLabel($obj->code_client).'</td>';
193 print '<td class="left">'.dolPrintLabel($obj->code_compta_client).'</td>';
194 print '<td class="right">'.dol_print_date($db->jdate($obj->datec)).'</td>';
195 print "</tr>\n";
196 $i++;
197 }
198 print "</table>";
199
200 print '</form>';
201
202 $db->free($resql);
203} else {
204 dol_print_error($db);
205}
206
207// End of page
208llxFooter();
209$db->close();
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 third parties objects (customers, suppliers, prospects...)
llxFooter()
Footer empty.
Definition document.php:107
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.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
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...
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...
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.