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