PHP app\modules\chat\models ChatMessage::findBySql Examples

Example #1

File: ChatUser.php Project: Sheriyev/G5-CRM

 /**
  * Последнее сообщение от собеседника
  */
 public function getLastMessage()
 {
     $rec = \Yii::$app->user->identity->id;
     $sql = "SELECT * FROM chat_message WHERE((sender_id = " . $this->id . " AND recipient_id=" . $rec . " ) OR (sender_id = " . $rec . " AND recipient_id=" . $this->id . " )) ORDER BY id DESC";
     //        $message = ChatMessage::find()->where(['sender_id'=>$this->id,'recipient_id'=>\Yii::$app->user->identity->id])->orderBy('id DESC')->one();
     $message = ChatMessage::findBySql($sql)->one();
     return $message;
 }