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';
34$action =
GETPOST(
'action',
'aZ09');
37if ($user->socid > 0) {
39 $socid = $user->socid;
42if (!$user->hasRight(
'facture',
'creer')) {
47$langs->loadLangs(array(
"companies",
"orders"));
50$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
51$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
53if (empty($page) || $page == -1) {
56$offset = $limit * $page;
71llxHeader(
'',
'',
'',
'', 0, 0,
'',
'',
'',
'mod-commande page-customer');
73$thirdpartystatic =
new Societe($db);
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').
")";
90if (
GETPOST(
"search_code_client")) {
94 $sql .=
" AND s.nom like '".$db->escape($begin).
"'";
98if (!$user->hasRight(
'societe',
'client',
'voir')) {
99 $search_sale = $user->id;
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).
")";
111 $sql .=
" AND c.fk_soc = ".((int) $socid);
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);
118$nbtotalofrecords =
'';
120 $result = $db->query($sql);
121 $nbtotalofrecords = $db->num_rows($result);
123 if (($page * $limit) > $nbtotalofrecords) {
129$sql .= $db->plimit($limit + 1, $offset);
132$resql = $db->query($sql);
134 $num = $db->num_rows($resql);
137 print_barre_liste($langs->trans(
"MenuOrdersToBill"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
139 print
'<form method="GET" action="'.$_SERVER[
"PHP_SELF"].
'">';
141 print
'<table class="liste centpercent">';
142 print
'<tr class="liste_titre">';
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);
152 print
'<tr class="liste_titre">';
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>';
157 print
'<td class="liste_titre"> </td>';
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")).
'">';
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")).
'">';
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")).
'">';
173 while ($i < min($num, $limit)) {
174 $obj = $db->fetch_object($resql);
176 print
'<tr class="oddeven">';
180 $link = $linkend =
'';
181 $link =
'<a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$obj->rowid.
'">';
184 $result .= ($link.img_object($langs->trans(
"ShowCompany").
': '.$name,
'company').$linkend);
185 $result .= $link.(dol_trunc($name, $maxlen)).$linkend;
189 print
'<td>'.$obj->town.
' </td>';
190 print
'<td class="left">'.$obj->code_client.
' </td>';
191 print
'<td class="left">'.$obj->code_compta.
' </td>';
192 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()
Empty header.
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.