Ejemplo n.º 1
0
 public static function getChats($message_hash, $data)
 {
     if ($data == '') {
         Conversation::updateConversation($message_hash);
     }
     $result = DB::Select("SELECT target_user_id as recipient_id,source_user_id as sender_id,(SELECT CONCAT(firstname,' ', lastname) \n                FROM accounts_dbx WHERE account_id = mradi_messages.source_user_id)  AS sender,CONCAT(firstname,' ', lastname) as recipient,\n                `time_sent`,`mradi_messages`.`message`,(case when time_read is not null then 1 else 0 end)as time_read FROM `mradi_messages` \n                LEFT JOIN `accounts_dbx` ON `accounts_dbx`.`account_id` = `mradi_messages`.`target_user_id`\n                WHERE message_hash = ? AND `mradi_messages`.`status` IN (0,1) order by time_sent asc", array($message_hash));
     return $result;
 }