/** * 获取动态 */ 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; }
/** * 分页(搜索) * @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; } }
public function actionAdminupdatemoment_2() { //判断信息是否填写完全 if (empty($_POST["momentid"]) || !isset($_POST["momentid"]) || (empty($_POST["status"]) || !isset($_POST["status"]))) { echo '{"success":false,"msg":"选项错误"}'; return; } if ($_POST['status'] == "1") { if (MomentTop::find()->count() >= 5) { echo '{"success":false,"msg":"置顶上限已满!!"}'; exit; } $newtop = new MomentTop(); $newtop->moment_id = $_POST['momentid']; $newtop->status = 1; $newtop->save(); } else { if ($_POST['status'] == "2") { $deltop = MomentTop::find()->where(['moment_id' => $_POST["momentid"]])->one(); $deltop->delete(); } else { echo '{"success":false,"msg":"出现错误!"}'; } } echo '{"success":true,"msg":"添加成功!"}'; }