public function insertanpaimanual($stname, $xh, $whichweek, $weekday, $zhibantime)
{
$year_xq = $this->xuenianxueqi();
//判断该学生这班是否有空
$content = self::getemptyst($whichweek, $weekday, $zhibantime);
$num = 0;
foreach ($content as $key => $value) {
if (in_array($xh, $value)) {
$num = 1;
} else {
continue;
}
}
//如果课程不冲突
if ($num == 1) {
$newzhiban = new Zhibantable();
$newzhiban->stname = $stname;
$newzhiban->stid = $xh;
$newzhiban->date_zhoushu = $whichweek;
$newzhiban->date_weekday = $weekday;
$newzhiban->date_turn = $zhibantime;
$newzhiban->year_xq = $year_xq;
//判断该学生是否已经这一天这一班有安排了
$sql1 = "select * from zhibantable WHERE stname='{$stname}' AND stid='{$xh}' AND date_zhoushu='{$whichweek}' AND date_weekday='{$weekday}' AND date_turn='{$zhibantime}'AND year_xq='{$year_xq}'";
//判断这一天这一班是否满了
$sql2 = "select COUNT(*) from zhibantable WHERE date_zhoushu='{$whichweek}' AND date_weekday='{$weekday}' AND date_turn='{$zhibantime}'AND year_xq='{$year_xq}'";
if (Yii::$app->db->createCommand($sql1)->queryOne()) {
$result = '{"success":false,"msg":"该学生已经安排过此日期的排班了"}';
} else {
if (Yii::$app->db->createCommand($sql2)->queryScalar() >= 2) {
$result = '{"success":false,"msg":"这一班已经安排满了"}';
} else {
$newzhiban->save(false);
$result = '{"success":true,"msg":"安排值班成功"}';
}
}
return $result;
} else {
$newzhiban = new Zhibantable();
$newzhiban->stname = $stname;
$newzhiban->stid = $xh;
$newzhiban->date_zhoushu = $whichweek;
$newzhiban->date_weekday = $weekday;
$newzhiban->date_turn = $zhibantime;
$newzhiban->year_xq = $year_xq;
$newzhiban->conflict_class = "有课程冲突";
//判断该学生是否已经这一天这一班有安排了
$sql1 = "select * from zhibantable WHERE stname='{$stname}' AND stid='{$xh}' AND date_zhoushu='{$whichweek}' AND date_weekday='{$weekday}' AND date_turn='{$zhibantime}'AND year_xq='{$year_xq}'";
//判断这一天这一班是否满了
$sql2 = "select COUNT(*) from zhibantable WHERE date_zhoushu='{$whichweek}' AND date_weekday='{$weekday}' AND date_turn='{$zhibantime}'AND year_xq='{$year_xq}'";
if (Yii::$app->db->createCommand($sql1)->queryOne()) {
$result = '{"success":false,"msg":"该学生已经安排过此日期的排班了"}';
} else {
if (Yii::$app->db->createCommand($sql2)->queryScalar() >= 2) {
$result = '{"success":false,"msg":"这一班已经安排满了"}';
} else {
$newzhiban->save(false);
$result = '{"success":true,"msg":"安排值班成功(有课程冲突)"}';
}
}
return $result;
}
}
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) . '}';
}