28require
'../main.inc.php';
38$langs->load(
"companies");
48if ($user->socid > 0) {
50 $socid = $user->socid;
54$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
55$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
57if (empty($page) || $page == -1) {
60$offset = $limit * $page;
67 $sortfield =
"p.name";
76$sql =
"SELECT s.rowid as socid, s.nom as name, st.libelle as stcomm, p.rowid as cidp, p.lastname, p.firstname, p.email, p.phone";
77if (!$user->hasRight(
"societe",
"client",
"voir") && !$socid) {
78 $sql .=
", sc.fk_soc, sc.fk_user ";
80$sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"socpeople as p, ".MAIN_DB_PREFIX.
"c_stcomm as st";
81if (!$user->hasRight(
"societe",
"client",
"voir") && !$socid) {
82 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
84$sql .=
" WHERE s.fk_stcomm = st.id";
85$sql .=
" AND s.fournisseur = 1";
86$sql .=
" AND s.rowid = p.fk_soc";
87$sql .=
" AND s.entity IN (".getEntity(
'societe').
")";
88if (!$user->hasRight(
"societe",
"client",
"voir") && !$socid) {
89 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
93 $sql .=
" AND s.fk_stcomm=$stcomm";
97 $sql .=
" AND p.name LIKE '$begin%'";
101 $sql .=
" AND p.name LIKE '%".strtolower($contactname).
"%'";
102 $sortfield =
"p.name";
107 $sql .=
" AND s.rowid = ".((int) $socid);
110$sql .=
" ORDER BY $sortfield $sortorder ";
111$sql .= $db->plimit($limit, $offset);
113$result = $db->query($sql);
115 $num = $db->num_rows($result);
117 $title = (
getDolGlobalString(
'SOCIETE_ADDRESSES_MANAGEMENT') ? $langs->trans(
"ListOfContacts") : $langs->trans(
"ListOfContactsAddresses"));
118 print_barre_liste($title.
" (".$langs->trans(
"Suppliers").
")", $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
"", $num);
120 print
'<table class="liste centpercent">';
121 print
'<tr class="liste_titre">';
123 print_liste_field_titre(
"Firstname", $_SERVER[
"PHP_SELF"],
"p.firstname", $begin,
"",
"", $sortfield, $sortorder);
130 while ($i < min($num, $limit)) {
131 $obj = $db->fetch_object($result);
133 print
'<tr class="oddeven">';
135 print
'<td><a href="'.DOL_URL_ROOT.
'/contact/card.php?id='.$obj->cidp.
'">'.
img_object($langs->trans(
"ShowContact"),
"contact").
' '.$obj->lastname.
'</a></td>';
136 print
'<td>'.$obj->firstname.
'</td>';
137 print
'<td><a href="'.DOL_URL_ROOT.
'/fourn/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.$obj->name.
'</a></td>';
138 print
'<td>'.$obj->email.
'</td>';
139 print
'<td>'.$obj->phone.
'</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.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
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.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
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...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...