. */ require_once('core/class/class_core_tools.php'); $Core_Tools = new core_tools; $Core_Tools->load_lang(); $return = ''; if (isset($_REQUEST['res_id'])) { $status = 0; $return .= ''; $return .= '
'; $return .= ''; $db = new Database(); $query = "SELECT c.is_corporate_person, c.is_private, c.contact_firstname, c.contact_lastname, c.firstname, c.lastname, c.society, c.society_short, c.contact_purpose_label, c.address_num, c.address_street, c.address_complement, c.address_town, c.address_postal_code, c.address_country, cres.mode "; $query .= "FROM view_contacts c, contacts_res cres "; $query .= "WHERE cres.coll_id = 'letterbox_coll' AND cres.res_id = ? AND cast (c.contact_id as varchar) = cres.contact_id AND c.ca_id = cres.address_id ORDER BY cres.mode ASC"; $arrayPDO = array($_REQUEST['res_id']); $stmt = $db->query($query, $arrayPDO); $fetch = ''; while ($res = $stmt->fetchObject()) { $return .= ''; $return .= ''; $return .= ''; } $query = "SELECT u.firstname, u.lastname, u.user_id, cres.mode "; $query .= "FROM users u, contacts_res cres "; $query .= "WHERE cres.coll_id = 'letterbox_coll' AND cres.res_id = ? AND cast (u.user_id as varchar) = cres.contact_id"; $arrayPDO = array($_REQUEST['res_id']); $stmt = $db->query($query, $arrayPDO); $fetch = ''; while ($res = $stmt->fetchObject()) { $return .= ''; $return .= ''; $return .= ''; } $return .= '
'; $return .= '
'; if($res->mode == 'third'){ $return .= ''._THIRD_DEST.' - '; }else{ $return .= ''._CONTACT.' - '; } if ($res->is_corporate_person == 'Y') { $return .= functions::xssafe($res->society) . ' ' ; if (!empty ($res->society_short)) { $return .= '('.functions::xssafe($res->society_short).') '; } } else { $return .= functions::xssafe($res->contact_lastname) . ' ' . functions::xssafe($res->contact_firstname) . ' '; if (!empty ($res->society)) { $return .= '(' . functions::xssafe($res->society) . ') '; } } if ($res->is_private == 'Y') { $return .= '('._CONFIDENTIAL_ADDRESS.')'; } else { $return .= "- " . functions::xssafe($res->contact_purpose_label)." : "; if (!empty($res->lastname) || !empty($res->firstname)) { $return .= functions::xssafe($res->lastname) . ' ' . functions::xssafe($res->firstname); } if (!empty($res->address_num) || !empty($res->address_street) || !empty($res->address_town) || !empty($res->address_postal_code)) { $return .= ', ' . functions::xssafe($res->address_num) . ' ' . functions::xssafe($res->address_street) . ' ' . functions::xssafe($res->address_postal_code) . ' ' . functions::xssafe(strtoupper($res->address_town)); } } $return .= '
'; $return .= '
'; $return .= '
'; if($res->mode == 'third'){ $return .= ''._THIRD_DEST.' (interne) - '; }else{ $return .= ''._CONTACT.' (interne) - '; } $return .= functions::xssafe($res->firstname) . ' ' . functions::xssafe($res->lastname); $return .= '
'; //$return .= '
'; $return .= '
'; $return .= '
'; $return .= '
'; $return .= ''; } else { $status = 1; $return .= ''; $return .= '

'; $return .= 'Erreur lors du chargement des notes'; $return .= '

'; $return .= ''; } echo "{status : " . $status . ", toShow : '" . addslashes($return) . "'}"; exit ();