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';
35$action =
GETPOST(
'action',
'aZ09');
38if ($user->socid > 0) {
40 $socid = $user->socid;
43if (!$user->hasRight(
'facture',
'creer')) {
48$langs->loadLangs(array(
"companies",
"orders"));
51$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
52$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
54if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
58$offset = $limit * $page;
73llxHeader(
'',
'',
'',
'', 0, 0,
'',
'',
'',
'mod-commande page-customer');
75$thirdpartystatic =
new Societe($db);
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').
")";
92if (
GETPOST(
"search_code_client")) {
96 $sql .=
" AND s.nom like '".$db->escape($begin).
"'";
100if (!$user->hasRight(
'societe',
'client',
'voir')) {
101 $search_sale = $user->id;
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).
")";
113 $sql .=
" AND c.fk_soc = ".((int) $socid);
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);
120$nbtotalofrecords =
'';
122 $result = $db->query($sql);
123 $nbtotalofrecords = $db->num_rows($result);
125 if (($page * $limit) > $nbtotalofrecords) {
131$sql .= $db->plimit($limit + 1, $offset);
134$resql = $db->query($sql);
136 $num = $db->num_rows($resql);
139 print_barre_liste($langs->trans(
"MenuOrdersToBill"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
141 print
'<form method="GET" action="'.$_SERVER[
"PHP_SELF"].
'">';
143 print
'<table class="liste centpercent">';
144 print
'<tr class="liste_titre">';
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);
154 print
'<tr class="liste_titre">';
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>';
159 print
'<td class="liste_titre"> </td>';
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")).
'">';
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")).
'">';
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")).
'">';
175 while ($i < min($num, $limit)) {
176 $obj = $db->fetch_object($resql);
178 print
'<tr class="oddeven">';
182 $link = $linkend =
'';
183 $link =
'<a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$obj->rowid.
'">';
186 $result .= ($link.img_object($langs->trans(
"ShowCompany").
': '.$name,
'company').$linkend);
187 $result .= $link.(dol_trunc($name, $maxlen)).$linkend;
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>';
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.
Class to manage third parties objects (customers, suppliers, prospects...)
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.