. */ /** * * * @file * @author * @date $date$ * @version $Revision$ * @ingroup apps */ $db = new Database(); $query = "SELECT contact_id, society, firstname, lastname, is_corporate_person FROM contacts_v2 WHERE enabled = 'Y'"; $arrayPDO = array(); if ($_REQUEST['type_id'] <> "all") { $query .= " AND contact_type = ? "; $arrayPDO = array($_REQUEST['type_id']); } $query .= " ORDER BY is_corporate_person desc, society, lastname"; $stmt = $db->query($query, $arrayPDO); $contact_selected = array(); while($res = $stmt->fetchObject()){ $contact = ""; if ($res->is_corporate_person == "Y") { $contact = $res->society; } else if ($res->is_corporate_person == "N") { $contact = $res->lastname .' '. $res->firstname; } array_push($contact_selected, array('id' => $res->contact_id, 'name' => $contact )); } $frmStr = ''; $countsContact = count($contact_selected); if ($countsContact == 0) { $frmStr .= 'Aucun contact'; } else { if ($_REQUEST['mode'] != "view") { $frmStr .= 'Choisissez un contact'; } else if($_REQUEST['mode'] == "view"){ $frmStr .= 'Voir les contacts'; } } for ($cptsContacts = 0;$cptsContacts< $countsContact;$cptsContacts++) { $frmStr .= ''; } echo $frmStr; exit;