. * * @brief List of structures for autocompletion * * @file * @author * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); require_once("apps".DIRECTORY_SEPARATOR."maarch_entreprise".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_contacts_v2.php"); $contact = new contacts_v2(); $db = new Database(); $query = "SELECT ca.id, ca.lastname as tag, ca.firstname, ca.contact_purpose_id, cp.label FROM ".$_SESSION['tablename']['contact_addresses']." ca LEFT JOIN contact_purposes cp on ca.contact_purpose_id = cp.id WHERE (lower(lastname) like lower(?) or lower(firstname) like lower(?) or lower(address_town) like lower(?) or lower(label) like lower(?))"; $arrayPDO = array('%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%'); if(isset($_GET['id']) && $_GET['id'] <> ''){ $query .= ' and ca.id <> ? and contact_id = ?'; $arrayPDO = array_merge($arrayPDO, array($_GET['id'], $_SESSION['contact']['current_contact_id'])); } else if (isset($_REQUEST['idContact']) && $_REQUEST['idContact'] <> ''){ $query .= ' and contact_id = ?'; $arrayPDO = array_merge($arrayPDO, array($_REQUEST['idContact'])); } else if (isset($_REQUEST['reaffectAddress']) && $_REQUEST['reaffectAddress'] <> ''){ $query .= ' and contact_id = ? and ca.id <> ?'; $arrayPDO = array_merge($arrayPDO, array($_REQUEST['reaffectAddress'], $_SESSION['contact']['current_address_id'])); } $query .= " order by lastname"; $stmt = $db->query($query, $arrayPDO); $listArray = array(); while($line = $stmt->fetchObject()) { $listArray[$line->id] = $contact->get_label_contact($line->contact_purpose_id, $_SESSION['tablename']['contact_purposes']); if ($line->tag <> "" || $line->firstname) { $listArray[$line->id] .= " :"; if ($line->tag <> "") { $listArray[$line->id] .= " " . $line->tag; } if ($line->firstname <> "") { $listArray[$line->id] .= " " . $line->firstname; } } } $query = "SELECT ca.id, c.lastname as tag, c.firstname, ca.contact_purpose_id, cp.label FROM ".$_SESSION['tablename']['contact_addresses']." ca LEFT JOIN contact_purposes cp on ca.contact_purpose_id = cp.id LEFT JOIN contacts_v2 c on c.contact_id = ca.contact_id WHERE (lower(c.lastname) like lower(?) or lower(c.firstname) like lower(?) or lower(address_town) like lower(?) or lower(label) like lower(?))"; $arrayPDO = array('%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%', '%'.$_REQUEST['what'].'%'); $query .= " order by c.lastname"; $stmt = $db->query($query, $arrayPDO); while($line = $stmt->fetchObject()) { $listArray[$line->id] = $contact->get_label_contact($line->contact_purpose_id, $_SESSION['tablename']['contact_purposes']); if ($line->tag <> "" || $line->firstname) { $listArray[$line->id] .= " :"; if ($line->tag <> "") { $listArray[$line->id] .= " " . $line->tag; } if ($line->firstname <> "") { $listArray[$line->id] .= " " . $line->firstname; } } } echo "";