/** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete($id) { if (Yii::app()->request->isPostRequest) { // we only allow deletion via POST request $this->loadModel($id)->delete(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if (!isset($_GET['ajax'])) { $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin')); } } else { if (!Yii::app()->request->isPostRequest) { $stud_tran = StudentTransaction::model()->findAll(array('condition' => 'student_transaction_course_id=' . $id)); if (!empty($stud_tran)) { throw new CHttpException(400, 'You can not delete this record because it is used in another table.'); } else { $this->loadModel($id)->delete(); CourseUnitTable::model()->deleteAll("course_unit_master_id = :courseId", array(':courseId' => $id)); UnitDetailTable::model()->deleteAll("unit_detail_course_id = :courseId", array(':courseId' => $id)); $this->redirect(array('admin')); } } else { throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.'); } } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = CourseUnitTable::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function actionCourseDetails() { $courseData = StudentTransaction::model()->findByPk($_REQUEST['id'])->student_transaction_course_id; if ($courseData != 0) { $courseDetails = CourseMaster::model()->findByPk($courseData); $courseUnits = CourseUnitTable::model()->findAll('course_unit_master_id=' . $courseDetails->course_master_id); $this->render('courseDetails', array('courseDetails' => $courseDetails, 'courseUnits' => $courseUnits)); } else { $noCourse = "No course assign"; $this->render('courseDetails', array('noCourse' => $noCourse)); } }