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":"没有置顶动态"}'; } }
public function getPageMomentWithOrder($page, $number) { if ($this->decideGetMomentContinue($page, $number)) { $front = ($page - 1) * $number; $sql = " SELECT moments.id,moments.XH_ID,moments.Content,moments.Mdate FROM moments RIGHT JOIN moment_top ON moments.id=moment_top.moment_id"; $Dbfactory = DbFactory::getinstance(); $Moments1 = $Dbfactory->findBySql($sql); $counttop = MomentTop::find()->count(); $num = $number - $counttop; $idcount = ""; foreach ($Moments1 as $key => $value) { $idcount .= $value['id'] . ','; } if ($page == 1) { $idcount = rtrim($idcount, ","); $sql2 = "SELECT id,XH_ID,Content,Mdate FROM moments ORDER BY Mdate DESC ,TIME DESC LIMIT {$num}"; if (empty($idcount)) { $sql2 = "SELECT id,XH_ID,Content,Mdate FROM moments ORDER BY Mdate DESC ,TIME DESC LIMIT {$num}"; } else { $sql2 = "SELECT id,XH_ID,Content,Mdate FROM moments WHERE id NOT IN ({$idcount}) ORDER BY Mdate DESC ,TIME DESC LIMIT {$num}"; } $Moments2 = Yii::$app->db->createCommand($sql2)->queryAll(); $Moments = array_merge($Moments1, $Moments2); } else { $num = $front - $counttop; $idcount = rtrim($idcount, ","); if (empty($idcount)) { $sql2 = "SELECT id,XH_ID,Content,Mdate FROM moments ORDER BY Mdate DESC ,TIME DESC LIMIT {$num},{$number}"; } else { $sql2 = "SELECT id,XH_ID,Content,Mdate FROM moments WHERE id NOT IN ({$idcount}) ORDER BY Mdate DESC ,TIME DESC LIMIT {$num},{$number}"; } $Moments = Yii::$app->db->createCommand($sql2)->queryAll(); // $Moments=array_merge($Moments1,$Moments2); } $user = new UserTb(); foreach ($Moments as $key => $value) { $XH = $value['XH_ID']; $username = $user->getName($XH); $Moments[$key]['username'] = $username; } $istop = MomentTop::find()->all(); foreach ($Moments as $key => $value) { foreach ($istop as $key1 => $value1) { if ($value1['moment_id'] == $value['id']) { $Moments[$key]['status'] = $value1['status']; } } } return $Moments; } else { return false; } }
public function AdminAllItems($page, $number) { if ($this->decideGetMomentContinue($page, $number)) { $front = ($page - 1) * $number; $sql = 'SELECT Item_Id,XH_ID,Item_Name,Item_Intro,Date,status FROM items ORDER BY Date DESC LIMIT ' . $front . ',' . $number; $Dbfactory = DbFactory::getinstance(); $items = $Dbfactory->findBySql($sql); $user = new UserTb(); foreach ($items as $key => $value) { $XH = $value['XH_ID']; $username = $user->getName($XH); $items[$key]['username'] = $username; } return $items; } else { return false; } }
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 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) . '}'; }