public function actionChekmsg() { $usr_id = Yii::$app->user->identity->id; $model = new Message(); $data = Yii::$app->request->post(); if (empty($data['lastmsg'])) { $sql = 'SELECT * FROM `message` WHERE `from`=' . $usr_id . ' and `to`=' . $data['frid'] . ' or `to`=' . $usr_id . ' and `from`=' . $data['frid'] . ''; Message::updateAll(['status' => 1], '`from`=' . $data['frid'] . ' and `to`=' . $usr_id . ''); } else { $sql = 'SELECT * FROM `message` WHERE `message_id`>' . $data['lastmsg'] . ' and `from`=' . $usr_id . ' and `to`=' . $data['frid'] . ' or `message_id`>' . $data['lastmsg'] . ' and `to`=' . $usr_id . ' and `from`=' . $data['frid'] . ''; Message::updateAll(['status' => 1], '`from`=' . $data['frid'] . ' and `to`=' . $usr_id . ''); } $msg = $model->findBySql($sql)->asArray()->all(); return json_encode($msg); }