/** * 获取动态 */ public function actionGetmomentdata() { $rightNowUserId = Yii::$app->user->identity->XH_ID; $rightNowUserName = Yii::$app->user->identity->Name; $moments = new Moments(); $content = $moments->getPageMomentWithOrder(1, 6); $allPage = $moments->getAllPage(6); // $content = Moments::find()->asArray()->join('LEFT JOIN','user_tb','moments.XH_ID=user_tb.XH_ID')->orderBy('Mdate DESC,Time DESC')->all(); // $content = Moments::find()->asArray()->orderBy('Mdate DESC,Time DESC')->all(); $istop = MomentTop::find()->all(); if (!empty($content)) { foreach ($content as $key => $value) { foreach ($istop as $key1 => $value1) { if ($value1['moment_id'] == $value['id']) { $content[$key]['status'] = $value1['status']; } } $name = UserTb::findOne($value['XH_ID']); $content[$key]['username'] = $name['Name']; } } $content = '{"moments":' . json_encode($content, JSON_UNESCAPED_UNICODE) . ',"allPage":"' . $allPage . '","userIdNow":"' . $rightNowUserId . '","userName":"******"}'; echo $content; }
/** * 更改用户权限 */ public function actionChangeuserstatus() { //判断信息是否填写完全 if (empty($_POST["status"]) || !isset($_POST["status"])) { echo '{"success":false,"msg":"请选择"}'; return; } $aimuser = UserTb::findOne($_POST['id']); $aimuser->status = $_POST["status"]; $aimuser->save(false); // $a=$aimarticle->status; echo '{"success":true,"msg":"更改成功!"}'; }
/** * 分页(搜索) * @param $input * @param $page * @param $number * @return array|string */ public function getPageMomentWithOrder_2($input, $page, $number) { $front = ($page - 1) * $number; if ($page == 1) { // $sql="SELECT tabbledesc.id,tabbledesc.XH_ID,Content,Mdate FROM (SELECT * FROM moments ORDER BY Mdate DESC,Time desc)AS tabbledesc LEFT JOIN moment_top ON tabbledesc.id=moment_top.moment_id WHERE tabbledesc.Content like '%$input%' OR tabbledesc.XH_ID like '%$input%' LIMIT $number"; $sql = "SELECT id,XH_ID,Content,Mdate from moments WHERE Content like '%{$input}%' OR XH_ID like '%{$input}%' ORDER BY Mdate DESC ,TIME DESC LIMIT {$number}"; } else { $sql = "SELECT id,XH_ID,Content,Mdate from moments WHERE Content like '%{$input}%' OR XH_ID like '%{$input}%' ORDER BY Mdate DESC ,TIME DESC LIMIT {$front},{$number}"; // $count=Yii::$app->db->createCommand($sql1)->queryAll(); // $idcount=""; // foreach($count as $key=>$value){ // $idcount.=$value['id'].','; // } // $idcount=rtrim($idcount, ","); //// print_r($idcount); //// exit(); // $sql="SELECT id,XH_ID,Content,Mdate FROM Moments WHERE id NOT IN($idcount) AND (Content like '%$input%' OR XH_ID LIKE '%$input%') ORDER BY Mdate DESC,Time DESC LIMIT $number;"; } $result = yii::$app->db->createCommand($sql)->queryAll(); if (!empty($result)) { $istop = MomentTop::find()->all(); foreach ($result as $key => $value) { foreach ($istop as $key1 => $value1) { if ($value1['moment_id'] == $value['id']) { $result[$key]['status'] = $value1['status']; } } // $value['username']=UserTb::findOne($value['XH_ID'])->Name; $result[$key]['username'] = UserTb::findOne($value['XH_ID'])->Name; } $allPage = $this->getAllPage_s(6, $input); $result = '{"success":true,"moments":' . json_encode($result, JSON_UNESCAPED_UNICODE) . ',"allPage_s":"' . $allPage . '"}'; return $result; } else { $result = '{"success":false,"msg":"没有找到相关动态","allPage_s":"1"}'; return $result; } }