Go to the documentation of this file.
26 require
'../main.inc.php';
27 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
28 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
30 $action =
GETPOST(
'action',
'aZ09');
33 if ($user->socid > 0) {
35 $socid = $user->socid;
38 if (!$user->rights->facture->lire) {
43 $langs->load(
"companies");
47 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
48 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
49 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
51 if (empty($page) || $page == -1) {
54 $offset = $limit * $page;
55 $pageprev = $page - 1;
56 $pagenext = $page + 1;
71 $thirdpartystatic =
new Societe($db);
73 if ($action ==
'note') {
74 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"societe SET note='".$db->escape($note).
"' WHERE rowid=".((int) $socid);
75 $result = $db->query($sql);
78 if ($mode ==
'search') {
81 if ($db->num_rows(
$resql) == 1) {
82 $obj = $db->fetch_object(
$resql);
95 $sql =
"SELECT s.rowid, s.nom as name, s.client, s.town, s.datec, s.datea";
96 $sql .=
", st.libelle as stcomm, s.prefix_comm, s.code_client, s.code_compta ";
97 if (empty($user->rights->societe->client->voir) && !$socid) {
98 $sql .=
", sc.fk_soc, sc.fk_user ";
100 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"c_stcomm as st";
101 if (empty($user->rights->societe->client->voir) && !$socid) {
102 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
104 $sql .=
" WHERE s.fk_stcomm = st.id AND s.client in (1, 3)";
105 $sql .=
" AND s.entity IN (".getEntity(
'societe').
")";
106 if (empty($user->rights->societe->client->voir) && !$socid) {
107 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
110 $sql .=
" AND s.fk_stcomm=".((int) $stcomm);
115 if (
GETPOST(
"search_compta")) {
118 if (
GETPOST(
"search_code_client")) {
122 $sql .=
" AND s.rowid = ".((int) $socid);
124 $sql .=
" ORDER BY $sortfield $sortorder";
125 $sql .= $db->plimit($conf->liste_limit + 1, $offset);
128 $resql = $db->query($sql);
130 $num = $db->num_rows(
$resql);
133 $langs->load(
'commercial');
135 print_barre_liste($langs->trans(
"ListOfCustomers"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
137 print
'<form method="GET" action="'.$_SERVER[
"PHP_SELF"].
'">';
139 print
'<table class="liste centpercent">';
140 print
'<tr class="liste_titre">';
142 print_liste_field_titre(
"Company", $_SERVER[
"PHP_SELF"],
"s.nom",
"",
"",
'valign="center"', $sortfield, $sortorder);
143 print_liste_field_titre(
"Town", $_SERVER[
"PHP_SELF"],
"s.town",
"",
"",
'valign="center"', $sortfield, $sortorder);
144 print_liste_field_titre(
"CustomerCode", $_SERVER[
"PHP_SELF"],
"s.code_client",
"",
"",
'', $sortfield, $sortorder,
'left ');
145 print_liste_field_titre(
"AccountancyCode", $_SERVER[
"PHP_SELF"],
"s.code_compta",
"",
"",
'', $sortfield, $sortorder,
'left ');
146 print_liste_field_titre(
"DateCreation", $_SERVER[
"PHP_SELF"],
"datec", $addu,
"",
'', $sortfield, $sortorder,
'right ');
150 print
'<tr class="liste_titre">';
152 print
'<td class="liste_titre left">';
153 print
'<input class="flat" type="text" name="search_nom" value="'.$_GET[
"search_nom"].
'"></td>';
155 print
'<td class="liste_titre"> </td>';
157 print
'<td class="liste_titre left">';
158 print
'<input class="flat" type="text" size="10" name="search_code_client" value="'.$_GET[
"search_code_client"].
'">';
161 print
'<td class="liste_titre left">';
162 print
'<input class="flat" type="text" size="10" name="search_compta" value="'.$_GET[
"search_compta"].
'">';
165 print
'<td colspan="2" class="liste_titre right">';
166 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")).
'">';
170 while ($i < min($num, $conf->liste_limit)) {
171 $obj = $db->fetch_object(
$resql);
173 print
'<tr class="oddeven">';
175 $thirdpartystatic->id = $obj->rowid;
176 $thirdpartystatic->name = $obj->name;
177 $thirdpartystatic->client = $obj->client;
178 print $thirdpartystatic->getNomUrl(1,
'compta');
180 print
'<td>'.$obj->town.
' </td>';
181 print
'<td class="left">'.$obj->code_client.
' </td>';
182 print
'<td class="left">'.$obj->code_compta.
' </td>';
183 print
'<td class="right">'.dol_print_date($db->jdate($obj->datec)).
'</td>';
Class to manage third parties objects (customers, suppliers, prospects...)
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0)
Returns text escaped for inclusion in HTML alt or title tags, or into values of HTML input fields.
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='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
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...
if(isModEnabled('facture') &&!empty($user->rights->facture->lire)) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->rights->fournisseur->facture->lire)||(isModEnabled('supplier_invoice') && $user->rights->supplier_invoice->lire)) if(isModEnabled('don') &&!empty($user->rights->don->lire)) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $resql
Social contributions to pay.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program Calling this function terminate execution ...
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.