public function actionAccess($applyId)
{
$model = parent::_dataLoad(new StAdmin(), $this->_admini['userId']);
$teacherId = $model->id;
// echo var_dump($model);
try {
$sql = "SELECT * FROM st_course,st_class_time,st_apply WHERE st_class_time.classTimeId = st_apply.classTimeId AND st_course.courseId=st_class_time.courseId AND st_apply.applyId='{$applyId}'";
if (XUtils::method() == 'POST') {
if ($_POST['approve'] == "同意") {
$state = 1;
}
if ($_POST['approve'] == "不同意") {
$state = 2;
}
$count = StApply::model()->updateByPk($applyId, array('state' => $state));
if ($count > 0) {
XUtils::message('success', '审批成功', $this->createUrl('exeTeacherLogin/applyQuery'));
} else {
XUtils::message('fail', '修改失败', $this->createUrl('exeTeacherLogin/access'));
}
}
$data = Yii::app()->db->createCommand($sql)->queryAll();
$data = json_decode(CJSON::encode($data), TRUE);
is_array($data) ? null : ($data = array());
// 防止空数组
// echo var_dump($data);
$this->render('access', array('data' => $data));
} catch (Exception $e) {
echo var_dump($e);
}
}
public function actionApply($classTimeId)
{
$model = parent::_dataLoad(new StAdmin(), $this->_admini['userId']);
$stuId = $model->id;
// echo var_dump($model);
try {
$sql = "SELECT * FROM st_course,st_class_time WHERE st_class_time.classTimeId ='{$classTimeId}' AND st_course.courseId=st_class_time.courseId";
if (XUtils::method() == 'POST') {
// 提交按钮
$data = StApply::model()->findAllByAttributes(array('stuId' => $stuId, 'classTimeId' => $classTimeId));
// echo empty($data);
if (empty($data)) {
$model = new StApply();
$model->stuId = $stuId;
$model->classTimeId = $classTimeId;
$model->reason = $_POST['reason'];
$model->state = 0;
if ($model->save() > 0) {
XUtils::message('success', '提交成功', $this->createUrl('studentLogin/courseQuery'));
} else {
XUtils::message('fail', '申请失败', $this->createUrl('studentLogin/apply'));
}
} else {
XUtils::message('fail', '申请已存在', $this->createUrl('studentLogin/courseQuery'));
}
}
// echo var_dump($sql);
//分页获取
$data = Yii::app()->db->createCommand($sql)->queryAll();
$data = json_decode(CJSON::encode($data), TRUE);
is_array($data) ? null : ($data = array());
// 防止空数组
// echo var_dump($data);
$this->render('apply', array('data' => $data[0], 'stuId' => $stuId));
} catch (Exception $e) {
echo var_dump($e);
}
}
