예제 #1
0
 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);
 }