public static function findById($id) { $user = UserTb::find()->where(array('XH_ID' => $id))->asArray()->one(); if ($user) { return new static($user); } return null; }
public function actionGettopmoment() { $moments = new Moments(); $usertb = new UserTb(); $result = $moments->getAllTopMoment(); $msg = ''; $name = ''; foreach ($result as $value) { $name = $usertb->getName($value['XH_ID']); $msg .= '<div class=\\"moment_Sty\\"><div class=\\"moment_Owner\\"><p class=\\"centerMomentName\\">' . $name . '</p></div><div class=\\"moment_Content\\"><p class=\\"centerMomentName\\">' . $value['Content'] . '</p></div><div class=\\"moment_Date\\"><p class=\\"centerMomentName\\">' . $value['Mdate'] . '</p></div></div>'; } if ($msg) { echo '{"success" :true , "msg":"' . $msg . '"}'; } else { echo '{"success" :false , "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; } }
public function actionGetitems() { $msg = ''; $item = new Items(); $itemPerson = new Itempersons(); $rightNowUserId = Yii::$app->user->identity->XH_ID; $usertb = new UserTb(); $status = $usertb->getAuthority($rightNowUserId); $name = $usertb->getName($rightNowUserId); $result = $item->searchAllItems(2); $result2 = $item->searchOtherItems(2); if ($result2 || $result) { foreach ($result as $value) { $msg .= '<div onclick=\\"detailShow(' . $value['Item_Id'] . ')\\" id=\\"' . $value['Item_Id'] . '\\" class=\\"item_show\\" style=\\"background-image: url(images/itemImg.jpeg);\\"><h3 class=\\"item_showtit\\">' . $value['Item_Name'] . '</h3></div>'; } foreach ($result2 as $value) { $msg .= '<div onclick=\\"detailShow(' . $value['Item_Id'] . ')\\" id=\\"' . $value['Item_Id'] . '\\" class=\\"item_show\\" style=\\"background-image: url(images/itemImg.jpeg);\\"><h3 class=\\"item_showtit\\">' . $value['Item_Name'] . '</h3></div>'; } echo '{"success":true,"msg": "' . $msg . '","msg1":"' . $status . '","name":"' . $name . '"}'; } else { echo '{"success":false,"msg1":"' . $status . '","name":"' . $name . '"}'; } }
/** * 统计总的页数(搜索) */ public function userallpage_s($numbers, $content) { $result = UserTb::find()->where("XH_ID like '%{$content}%' or Name like '%{$content}%'")->count(); return ceil($result / $numbers); }
/** * @return \yii\db\ActiveQuery */ public function getXH() { return $this->hasOne(UserTb::className(), ['XH_ID' => 'XH_ID']); }
public function actionSearchorder() { $nowuser = \Yii::$app->user->identity->XH_ID; $usertb = new UserTb(); $name = $usertb->getName($nowuser); $request = Yii::$app->request; $session = Yii::$app->session; $whichweek = $request->get('whichweek_user'); $weekday = $request->get('weekday_user'); $session['whichweek_2'] = $whichweek; $session['weekday_2'] = $weekday; $anpaitable = new Zhibantable(); $year_xq = $anpaitable->xuenianxueqi(); $content = $anpaitable->findanpaidata_2($session['whichweek_2'], $session['weekday_2'], $year_xq, $nowuser); echo '{"success":true,"name":"' . $name . '","anpai":' . json_encode($content, JSON_UNESCAPED_UNICODE) . '}'; }