/**
* 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);
}
