public function actionDeleteSeminar() { $response = array(); if (isset($_POST['s_id']) && isset($_POST['student_id'])) { /*get ID student seminars save*/ $criteria = new CDbCriteria(); $criteria->addCondition('student_id = ' . $_POST['student_id'] . ''); $criteria->addCondition('seminar_id = ' . $_POST['s_id'] . ''); $studentSeminar = RsStudentSeminar::model()->find($criteria); if ($studentSeminar->attended == 0) { RsStudentSeminar::model()->deleteAll('id = :id', array('id' => $studentSeminar->id)); } else { $studentSeminar->apply_code = NULL; $studentSeminar->save(); /*set response*/ $response['save'] = "ok"; } echo json_encode($response); } }
public function actionConfirmAttended() { $action = $_POST['action']; $st_id = $_POST['st_id']; $s_id = $_POST['s_id']; $student = RsStudentSeminar::model()->find('student_id=:st_id AND seminar_id=:s_id', array(':st_id' => $st_id, ':s_id' => $s_id)); switch ($action) { case 1: $student->attended = 1; if ($student->save()) { Yii::app()->user->setFlash('success', Yii::t("backend", Yii::t("admin", "seminar.confirm.attention.success"))); } else { Yii::app()->user->setFlash('success', Yii::t("backend", Yii::t("admin", "seminar.confirm.attention.fail"))); } break; case 2: $student = new RsStudentSeminar(); $student->student_id = $st_id; $student->seminar_id = $s_id; $student->attended = 1; if ($student->save()) { Yii::app()->user->setFlash('success', Yii::t("backend", Yii::t("admin", "seminar.todayRegister.success"))); } else { Yii::app()->user->setFlash('error', Yii::t("backend", Yii::t("admin", "seminar.todayRegister.fail"))); } break; case 3: // change attention status to 0 $student->attended = 0; if ($student->save()) { Yii::app()->user->setFlash('success', Yii::t("backend", Yii::t("admin", "seminar.remove.attention.success"))); } else { Yii::app()->user->setFlash('error', Yii::t("backend", Yii::t("admin", "seminar.remove.attention.fail"))); } break; default: # code... break; } // if ($student->update() OR $student->save()) { // Yii::app()->user->setFlash('success',Yii::t("backend", "出席登録は完了しました。")); // } else { // Yii::app()->user->setFlash('success',Yii::t("backend", "出席登録は失敗しました。")); // } }
public function actionEditStatusStudentList() { $data = array(); $st_crit = new CDbCriteria(); // criteria to query student infomation $st_id = $_POST['st_id']; $st_crit->params[':st_id'] = $st_id; $st_crit->condition = 'id=:st_id'; $student = RsStudent::model()->find($st_crit); //student infomation $criteria = new CDbCriteria(); // criteria to query seminar list $criteria->together = true; $criteria->with = array('seminar' => array('select' => 'seminar.*', 'together' => true)); $criteria->condition = 'student_id=:st_id'; $criteria->params[':st_id'] = $st_id; $criteria->addCondition('attended = 1 OR apply_code IS NOT NULL'); $count = RsStudentSeminar::model()->count($criteria); $pages = new CPagination($count); if (isset($_POST['page']) && (int) $_POST['page'] >= 0) { $pages->currentPage = (int) $_POST['page'] - 1; } $pages->pageSize = 10; $pages->applyLimit($criteria); $criteria->order = 'start_date DESC, from_time ASC, to_time ASC'; $seminars = RsStudentSeminar::model()->findAll($criteria); $data['pages'] = $pages; $data['student'] = $student; $data['seminars'] = $seminars; echo $this->renderPartial('_editStatusStudentList', $data, true); }