/** * Последнее сообщение от собеседника */ 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; }