dolibarr  20.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  *
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
30 require '../main.inc.php';
31 require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
32 require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
33 
34 $action = GETPOST('action', 'aZ09');
35 
36 // Secrutiy check
37 if ($user->socid > 0) {
38  $action = '';
39  $socid = $user->socid;
40 }
41 
42 if (!$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");
53 if (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;
59 if (!$sortorder) {
60  $sortorder = "ASC";
61 }
62 if (!$sortfield) {
63  $sortfield = "nom";
64 }
65 
66 
67 /*
68  * View
69  */
70 
71 llxHeader();
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').")";
84 if (GETPOST("search_nom")) {
85  $sql .= natural_search("s.nom", GETPOST("search_nom"));
86 }
87 if (GETPOST("search_compta")) {
88  $sql .= natural_search("s.code_compta", GETPOST("search_compta"));
89 }
90 if (GETPOST("search_code_client")) {
91  $sql .= natural_search("s.code_client", GETPOST("search_code_client"));
92 }
93 if (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;
98 if (!$user->hasRight('societe', 'client', 'voir')) {
99  $search_sale = $user->id;
100 }
101 // Search on sale representative
102 if ($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
110 if ($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 = '';
119 if (!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);
133 if ($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
206 llxFooter();
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:56
llxFooter()
Empty footer.
Definition: wrapper.php:70
Class to manage third parties objects (customers, suppliers, prospects...)
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:744
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.
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.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
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.