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) . '}';
}
