load_lang();
$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 .= 'Par: ';
$return .= $firstname . ' ' . $lastname;
$return .= ', ';
$return .= $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 .= ' ';
$return .= ' | ';
} else {
$status = 1;
$return .= '';
$return .= ' ';
$return .= 'Erreur lors du chargement des notes';
$return .= ' ';
$return .= ' | ';
}
echo "{status : " . $status . ", toShow : '" . addslashes($return) . "'}";
exit ();