/** * 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); }
public function dialognewAction() { $DialogMapper = new DialogMapper(); $ilchdate = new IlchDate(); $user_one = $this->getUser()->getId(); $user_two = $this->getRequest()->getParam('id'); if ($user_one != $user_two) { $c_exist = $DialogMapper->getDialogCheck($user_one, $user_two); if ($c_exist == 0) { $model = new DialogModel(); $model->setUserOne($user_one); $model->setUserTwo($user_two); $model->setTime($ilchdate->toDb()); $DialogMapper->save($model); $c_id = $DialogMapper->getDialogId($user_one); $this->redirect(array('action' => 'dialogview', 'id' => $c_id->getCId())); } $c_id = $DialogMapper->getDialogId($user_one); $this->redirect(array('action' => 'dialogview', 'id' => $c_id->getCId())); } }