. */ /** * @brief load Notes in results list * * @file * @author * @date $date$ * @version $Revision$ * @ingroup apps */ require_once('core/class/class_core_tools.php'); $Core_Tools = new core_tools; $Core_Tools->load_lang(); $Core_Tools->test_user(); $return = ''; if (isset($_REQUEST['identifier'])) { $status = 0; $return .= ''; $return .= '
'; $return .= ''; $db = new dbquery(); $db->connect(); $query = "select "; $query .= "DISTINCT(notes.id), "; $query .= "user_id, "; $query .= "date_note, "; $query .= "note_text "; $query .= "from "; $query .= "notes "; $query .= "left join "; $query .= "note_entities "; $query .= "on "; $query .= "notes.id = note_entities.note_id "; $query .= "where "; // $query .= "tablename = 'res_letterbox' "; // $query .= "AND "; $query .= "coll_id = '".$_SESSION['collection_id_choice']."' "; $query .= "AND "; $query .= "identifier = " . $_REQUEST['identifier'] . " "; $query .= "AND "; $query .= "( "; $query .= "( "; $query .= "item_id IN ("; foreach($_SESSION['user']['entities'] as $entitiestmpnote) { $query .= "'" . $entitiestmpnote['ENTITY_ID'] . "', "; } if ($_SESSION['user']['UserId'] == 'superadmin') { $query .= " null "; } else { $query = substr($query, 0, -2); } $query .= ") "; $query .= "OR "; $query .= "item_id IS NULL "; $query .= ") "; $query .= "OR "; $query .= "user_id = '" . $_SESSION['user']['UserId'] . "' "; $query .= ") "; $query .= " order by date_note desc"; $db->query($query); $fetch = ''; while ($return_db = $db->fetch_object()) { // get lastname and firstname for user_id $db2 = new dbquery; $db2->connect(); $db2->query("SELECT lastname, firstname FROM users WHERE user_id ='" . $return_db->user_id . "'"); while ($user_db = $db2->fetch_object()) { $lastname = $user_db->lastname; $firstname = $user_db->firstname; } $return .= ''; $return .= ''; $return .= ''; } $return .= '
'; // $return .= '
'; $return .= '
'; $return .= ucfirst(_BY) . ' : '; $return .= $firstname . ' ' . $lastname; $return .= ', '; $return .= $Core_Tools->format_date_db($return_db->date_note); $return .= '
'; // $return .= '
'; $return .= '
'; $note_text = str_replace(array("\r", "\n"), array("
", "
"), $return_db->note_text); $return .= str_replace('

', '
', $note_text); $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 ();