dolibarr 20.0.0
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 *
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.'/contact/class/contact.class.php';
32require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
33
34$action = GETPOST('action', 'aZ09');
35
36// Secrutiy check
37if ($user->socid > 0) {
38 $action = '';
39 $socid = $user->socid;
40}
41
42if (!$user->hasRight('facture', 'creer')) {
44}
45
46// Load translation files required by the page
47$langs->loadLangs(array("companies", "orders"));
48
49$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
50$sortfield = GETPOST('sortfield', 'aZ09comma');
51$sortorder = GETPOST('sortorder', 'aZ09comma');
52$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
53if (empty($page) || $page == -1) {
54 $page = 0;
55} // If $page is not defined, or '' or -1
56$offset = $limit * $page;
57$pageprev = $page - 1;
58$pagenext = $page + 1;
59if (!$sortorder) {
60 $sortorder = "ASC";
61}
62if (!$sortfield) {
63 $sortfield = "nom";
64}
65
66
67/*
68 * View
69 */
70
71llxHeader('', '', '', '', 0, 0, '', '', '', 'mod-commande page-customer');
72
73$thirdpartystatic = new Societe($db);
74
75/*
76 * Mode List
77 */
78
79$sql = "SELECT s.rowid, s.nom as name, s.client, s.town, s.datec, s.datea";
80$sql .= ", st.libelle as stcomm, s.prefix_comm, s.code_client, s.code_compta";
81$sql .= " FROM ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."c_stcomm as st, ".MAIN_DB_PREFIX."commande as c";
82$sql .= " WHERE s.fk_stcomm = st.id AND c.fk_soc = s.rowid";
83$sql .= " AND s.entity IN (".getEntity('societe').")";
84if (GETPOST("search_nom")) {
85 $sql .= natural_search("s.nom", GETPOST("search_nom"));
86}
87if (GETPOST("search_compta")) {
88 $sql .= natural_search("s.code_compta", GETPOST("search_compta"));
89}
90if (GETPOST("search_code_client")) {
91 $sql .= natural_search("s.code_client", GETPOST("search_code_client"));
92}
93if (dol_strlen($begin)) {
94 $sql .= " AND s.nom like '".$db->escape($begin)."'";
95}
96// If the internal user must only see his customers, force searching by him
97$search_sale = 0;
98if (!$user->hasRight('societe', 'client', 'voir')) {
99 $search_sale = $user->id;
100}
101// Search on sale representative
102if ($search_sale && $search_sale != '-1') {
103 if ($search_sale == -2) {
104 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc)";
105 } elseif ($search_sale > 0) {
106 $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).")";
107 }
108}
109// Search on socid
110if ($socid) {
111 $sql .= " AND c.fk_soc = ".((int) $socid);
112}
113$sql .= " AND c.fk_statut in (1, 2) AND c.facture = 0";
114$sql .= " GROUP BY s.nom";
115$sql .= $db->order($sortfield, $sortorder);
116
117// Count total nb of records
118$nbtotalofrecords = '';
119if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
120 $result = $db->query($sql);
121 $nbtotalofrecords = $db->num_rows($result);
122
123 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
124 $page = 0;
125 $offset = 0;
126 }
127}
128
129$sql .= $db->plimit($limit + 1, $offset);
130//print $sql;
131
132$resql = $db->query($sql);
133if ($resql) {
134 $num = $db->num_rows($resql);
135 $i = 0;
136
137 print_barre_liste($langs->trans("MenuOrdersToBill"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num);
138
139 print '<form method="GET" action="'.$_SERVER["PHP_SELF"].'">';
140
141 print '<table class="liste centpercent">';
142 print '<tr class="liste_titre">';
143
144 print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", "", 'valign="center"', $sortfield, $sortorder);
145 print_liste_field_titre("Town", $_SERVER["PHP_SELF"], "s.town", "", "", 'valign="center"', $sortfield, $sortorder);
146 print_liste_field_titre("CustomerCode", $_SERVER["PHP_SELF"], "s.code_client", "", "", 'align="left"', $sortfield, $sortorder);
147 print_liste_field_titre("AccountancyCode", $_SERVER["PHP_SELF"], "s.code_compta", "", "", 'align="left"', $sortfield, $sortorder);
148 print_liste_field_titre("DateCreation", $_SERVER["PHP_SELF"], "datec", $addu, "", 'class="right"', $sortfield, $sortorder);
149 print "</tr>\n";
150
151 // Fields title search
152 print '<tr class="liste_titre">';
153
154 print '<td align="left" class="liste_titre">';
155 print '<input class="flat" type="text" name="search_nom" value="'.dol_escape_htmltag(GETPOST("search_nom")).'"></td>';
156
157 print '<td class="liste_titre">&nbsp;</td>';
158
159 print '<td align="left" class="liste_titre">';
160 print '<input class="flat" type="text" size="10" name="search_code_client" value="'.dol_escape_htmltag(GETPOST("search_code_client")).'">';
161 print '</td>';
162
163 print '<td align="left" class="liste_titre">';
164 print '<input class="flat" type="text" size="10" name="search_compta" value="'.dol_escape_htmltag(GETPOST("search_compta")).'">';
165 print '</td>';
166
167 print '<td colspan="2" class="liste_titre right">';
168 print '<input type="image" class="liste_titre" src="'.img_picto($langs->trans("Search"), 'search.png', '', '', 1).'" name="button_search" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'">';
169 print '</td>';
170
171 print "</tr>\n";
172
173 while ($i < min($num, $limit)) {
174 $obj = $db->fetch_object($resql);
175
176 print '<tr class="oddeven">';
177 print '<td>';
178
179 $result = '';
180 $link = $linkend = '';
181 $link = '<a href="'.DOL_URL_ROOT.'/commande/list.php?socid='.$obj->rowid.'">';
182 $linkend = '</a>';
183 $name = $obj->name;
184 $result .= ($link.img_object($langs->trans("ShowCompany").': '.$name, 'company').$linkend);
185 $result .= $link.(dol_trunc($name, $maxlen)).$linkend;
186
187 print $result;
188 print '</td>';
189 print '<td>'.$obj->town.'&nbsp;</td>';
190 print '<td class="left">'.$obj->code_client.'&nbsp;</td>';
191 print '<td class="left">'.$obj->code_compta.'&nbsp;</td>';
192 print '<td class="right">'.dol_print_date($db->jdate($obj->datec)).'</td>';
193 print "</tr>\n";
194 $i++;
195 }
196 print "</table>";
197
198 print '</form>';
199
200 $db->free($resql);
201} else {
202 dol_print_error($db);
203}
204
205// End of page
206llxFooter();
207$db->close();
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()
Empty footer.
Definition wrapper.php:69
Class to manage third parties objects (customers, suppliers, prospects...)
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.
print_barre_liste($title, $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.
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.