<td align="center"> <?php echo Yii::t('transport', 'Action'); ?> </td> </tr> <tr> <?php $criteria = new CDbCriteria(); $criteria->order = 'id DESC'; $total = Transportation::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(Yii::app()->params['listPerPage']); $pages->applyLimit($criteria); // the trick is here! $route = Transportation::model()->findAll($criteria); $page_size = Yii::app()->params['listPerPage']; ?> <?php //$route=Transportation::model()->findAll(); if ($route) { foreach ($route as $route1) { $student = Students::model()->findByAttributes(array('id' => $route1->student_id)); $stop = StopDetails::model()->findByAttributes(array('id' => $route1->stop_id)); $route = RouteDetails::model()->findByAttributes(array('id' => $stop->route_id)); ?> <td align="center"> <?php echo $student->last_name . ' ' . $student->first_name;
font-weight:bold; text-align:center; } .tableinnerlist th{ border-right:1px #b9c7d0 solid; border-bottom:1px #b9c7d0 solid; padding:4px 10px; font-size:12px; font-weight:bold; text-align:center; } </style> <?php $list = Transportation::model()->findByAttributes(array('student_id' => $studentid, 'is_paid' => 1)); $posts = Students::model()->findByAttributes(array('id' => $studentid)); $stop = StopDetails::model()->findByAttributes(array('id' => $list->stop_id)); $route = RouteDetails::model()->findByAttributes(array('id' => $stop->route_id)); $batch = Batches::model()->findByAttributes(array('id' => $posts->batch_id)); $course = Courses::model()->findByAttributes(array('id' => $batch->course_id)); $currency = Configurations::model()->findByPk(5); ?> <table width="600" border="1" bgcolor="#f9feff"> <tr> <td> <div style="padding:10px 20px;"> <table width="600" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="150"> <?php
/** * 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 = Transportation::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Registration(); $model_1 = new Room(); //$err_msg = ''; $err_flag = 0; $err_msg = Yii::t('hostel', 'Please fix the following errors.') . '<br/>'; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Registration'])) { $roles = Rights::getAssignedRoles(Yii::app()->user->Id); // check for single role foreach ($roles as $role) { if (sizeof($roles) == 1 and $role->name == 'student') { $request = new Roomrequest(); $model->student_id = $_POST['Registration']['student_id']; $model->food_preference = $_POST['Registration']['food_preference']; $model->status = 'C'; $request->student_id = $_POST['Registration']['student_id']; $request->status = 'C'; $request->save(); $model->save(); $this->redirect(array('/hostel/registration/create')); } else { if ($_POST['hostel'] == NULL) { $err_flag = 1; $err_msg = $err_msg . '- ' . Yii::t('hostel', 'Hostel cannot be blank') . '<br/>'; } if ($_POST['floor'] == NULL) { $err_flag = 1; $err_msg = $err_msg . '- ' . Yii::t('hostel', 'Floor cannot be blank') . '<br/>'; } if ($_POST['student_id'] == NULL) { $err_flag = 1; $err_msg = $err_msg . '- ' . Yii::t('hostel', 'Student cannot be blank') . '<br/>'; } if ($_POST['Registration']['food_preference'] == NULL) { $err_flag = 1; $err_msg = $err_msg . '- ' . Yii::t('hostel', 'Food Preference cannot be blank') . '<br/>'; } if ($err_flag == 0) { $allot_erre = Allotment::model()->findByAttributes(array('student_id' => $_POST['student_id'], 'status' => 'S')); $hostel_reg = Registration::model()->findByAttributes(array('student_id' => $_POST['student_id'], 'status' => 'S')); $model->attributes = $_POST['Registration']; $model->student_id = $_POST['student_id']; if ($allot_erre != NULL and $hostel_reg != NULL) { $this->redirect(array('error', 'student_id' => $_POST['student_id'])); } $trans = Transportation::model()->findByAttributes(array('student_id' => $_POST['student_id'])); if ($trans->student_id != NULL) { if ($trans->student_id == $_POST['student_id']) { $this->redirect(array('warning', 'registration' => $_POST['Registration'], 'student_id' => $_POST['student_id'], 'floor_id' => $_POST['floor'], 'hostel' => $_POST['hostel'])); } } $register = Registration::model()->findByAttributes(array('student_id' => $_POST['student_id'])); //var_dump($register->attributes);exit; if ($register != NULL) { $request = Roomrequest::model()->findByAttributes(array('student_id' => $register->student_id, 'status' => 'C')); if ($request != NULL) { $request->status = 'S'; $request->save(); } $register->status = 'S'; $register->save(); } else { $model->food_preference = $_POST['Registration']['food_preference']; $model->student_id = $_POST['student_id']; $model->status = 'S'; } if ($model->save()) { //$bed_info=Allotment::model()->findAll('status=:x AND student_id=:y',array(':x'=>'C',':y'=>NULL)); $bed_info = Allotment::model()->findByAttributes(array('student_id' => NULL, 'status' => 'C')); //var_dump($bed_info->attributes);exit; if ($bed_info == NULL) { $this->redirect(array('/hostel/allotment/roominfo/')); } else { $this->redirect(array('/hostel/room/roomlist', 'id' => $model->student_id, 'floor_id' => $_POST['floor'])); } } } else { Yii::app()->user->setFlash('errorMessage', $err_msg); } } } } $this->render('create', array('model' => $model)); }