Piou-piou /
Ruined-World
| @@ 135-161 (lines=27) @@ | ||
| 132 | /** |
|
| 133 | * fonction qui permet de récupérer tous les messages dans la boite des messages envoyes |
|
| 134 | */ |
|
| 135 | private function getMessagesEnvoyes() { |
|
| 136 | $dbc = App::getDb(); |
|
| 137 | ||
| 138 | $query = $dbc->select() |
|
| 139 | ->from("_messagerie_boite_reception") |
|
| 140 | ->from("_messagerie_message") |
|
| 141 | ->from("identite") |
|
| 142 | ->where("_messagerie_message.ID_expediteur", "=", 1, "AND") |
|
| 143 | ->where("_messagerie_boite_reception.ID_message", "=", "_messagerie_message.ID_message", "AND", true) |
|
| 144 | ->where("_messagerie_boite_reception.ID_identite", "=", "identite.ID_identite", "", true) |
|
| 145 | ->get(); |
|
| 146 | ||
| 147 | if ((is_array($query)) && (count($query) > 0)) { |
|
| 148 | foreach ($query as $obj) { |
|
| 149 | $arr = [ |
|
| 150 | "id_message" => $obj->ID_message, |
|
| 151 | "objet" => $obj->objet, |
|
| 152 | "date_message" => $obj->date, |
|
| 153 | "id_expediteur" => $obj->ID_expediteur, |
|
| 154 | "pseudo_receveur" => $obj->pseudo, |
|
| 155 | "url" => $obj->url |
|
| 156 | ]; |
|
| 157 | ||
| 158 | $this->values[] = $arr; |
|
| 159 | } |
|
| 160 | } |
|
| 161 | } |
|
| 162 | ||
| 163 | /** |
|
| 164 | * fonction qui récupère tous les messages supprimés |
|
| @@ 208-235 (lines=28) @@ | ||
| 205 | * @param $url_message |
|
| 206 | * fonction qui récupère un message suivant une url |
|
| 207 | */ |
|
| 208 | public function getUnMessage($url_message) { |
|
| 209 | $dbc = App::getDb(); |
|
| 210 | ||
| 211 | $query = $dbc->select() |
|
| 212 | ->from("_messagerie_message") |
|
| 213 | ->from("_messagerie_boite_reception") |
|
| 214 | ->from("identite") |
|
| 215 | ->where("_messagerie_message.url", "=", $url_message, "AND") |
|
| 216 | ->where("_messagerie_message.ID_expediteur", "=", "identite.ID_identite", "AND", true) |
|
| 217 | ->where("_messagerie_boite_reception.ID_message", "=", "_messagerie_message.ID_message", "", true) |
|
| 218 | ->get(); |
|
| 219 | ||
| 220 | if ((is_array($query)) && (count($query) > 0)) { |
|
| 221 | foreach ($query as $obj) { |
|
| 222 | $this->values = [ |
|
| 223 | "id_message" => $obj->ID_message, |
|
| 224 | "objet" => $obj->objet, |
|
| 225 | "date_message" => $obj->date, |
|
| 226 | "id_expediteur" => $obj->ID_expediteur, |
|
| 227 | "pseudo_expediteur" => $obj->pseudo, |
|
| 228 | "url" => $obj->url |
|
| 229 | ]; |
|
| 230 | } |
|
| 231 | } |
|
| 232 | else { |
|
| 233 | return false; |
|
| 234 | } |
|
| 235 | } |
|
| 236 | //-------------------------- END GETTER ----------------------------------------------------------------------------// |
|
| 237 | ||
| 238 | ||
