public function actionAttendance($classTimeId) { try { $sql = "SELECT * FROM st_class_time,st_course WHERE st_class_time.classTimeId = " . $classTimeId . " AND st_class_time.courseId=st_course.courseId"; $course = Yii::app()->db->createCommand($sql)->queryAll(); $sql = "SELECT * FROM st_student,st_student_course WHERE st_student_course.courseId = '" . $course[0]['courseId'] . "' AND st_student_course.stuId = st_student.stuId"; //分页获取 if (XUtils::method() == 'POST') { $data = $_POST; $class = StClassTime::model()->findByPk($classTimeId); if ($class->flag == 1) { $delete = "DELETE FROM st_absent WHERE st_absent.classTimeId = " . $classTimeId; $result = Yii::app()->db->createCommand($sql)->execute(); } foreach ($data as $key => $value) { if ($value == 'on') { $model = new StAbsent(); $model->stuId = $key; $model->classTimeId = $classTimeId; $model->state = "旷课"; $model->reason = "--"; $model->save(); // echo var_dump($model); } } StClassTime::model()->updateByPk($classTimeId, array('flag' => '1')); // XUtils::message('success', '考勤成功', $this->createUrl('teacherLogin/todayClass')); } $result = Yii::app()->db->createCommand($sql)->queryAll(); $count = count($result); $pages = new CPagination($count); $pages->pageSize = PAGESIZE; $pdata = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $pdata->bindValue(':offset', $pages->currentPage * $pages->pageSize); $pdata->bindValue(':limit', $pages->pageSize); $data = $pdata->queryAll(); $data = json_decode(CJSON::encode($data), TRUE); // echo var_dump($data); is_array($data) ? null : ($data = array()); // 防止空数组 $this->render('attendance', array('data' => $data, 'pages' => $pages, 'courseName' => $course[0]['courseName'])); } catch (Exception $e) { var_dump($e); } }
public function actionAbsentDelete($stuAbsentId) { $data = StAbsent::model()->deleteByPk($stuAbsentId); echo "<script language=\"JavaScript\">alert(\"删除成功\");</script>"; header("Location:index.php?r=student/adminLogin/absentFindAll"); }