/** * Get the dialog message * @param int $c_id the user * @return null|\Modules\User\Models\Dialog */ public function getDialogMessage($c_id) { $sql = 'SELECT R.cr_id,R.time,R.reply,U.id,U.name,U.avatar FROM [prefix]_users U, [prefix]_users_dialog_reply R WHERE R.user_id_fk=U.id AND R.c_id_fk=' . $c_id . ' ORDER BY R.cr_id DESC LIMIT 20'; $mailArray = $this->db()->queryArray($sql); if (empty($mailArray)) { return null; } $mails = array(); foreach ($mailArray as $mail) { $mailModel = new DialogModel(); $mailModel->setId($mail['id']); $mailModel->setCrId($mail['cr_id']); $mailModel->setName($mail['name']); $mailModel->setText($mail['reply']); $mailModel->setTime($mail['time']); if (file_exists($mail['avatar'])) { $mailModel->setAvatar($mail['avatar']); } else { $mailModel->setAvatar('static/img/noavatar.jpg'); } $mails[] = $mailModel; } return array_reverse($mails); }