<th> Practical Percentage </th> </tr> <?php foreach($studentqualification as $m=>$v) { ?> <tr> <td> <?php echo ++$k; ?> </td> <td> <?php echo Qualification::model()->findByPk($v['student_academic_record_trans_qualification_id'])->qualification_name; ?> </td> <td> <?php echo Eduboard::model()->findByPk($v['student_academic_record_trans_eduboard_id'])->eduboard_name; ?> </td> <td> <?php echo $v['student_academic_record_trans_record_trans_year_id']; ?> </td> <td> <?php echo $v['theory_mark_max']; ?> </td> <td> <?php echo $v['theory_mark_obtained']; ?> </td> <td> <?php echo $v['theory_percentage']; ?> </td> <td>
private static function loadItems() { self::$_items = array(); $models = self::model()->findAll(); foreach ($models as $model) { self::$_items[$model->eduboard_id] = $model->eduboard_name; } }
/** * 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 = Eduboard::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
?> <tr> <td> <?php echo ++$k; ?> </td> <td> <?php echo Qualification::model()->findByPk($v['employee_academic_record_trans_qualification_id'])->qualification_name; ?> </td> <td> <?php echo Eduboard::model()->findByPk($v['employee_academic_record_trans_eduboard_id'])->eduboard_name; ?> </td> <td> <?php echo Year::model()->findByPk($v['employee_academic_record_trans_year_id'])->year; ?> </td> <td> <?php echo $v['theory_mark_obtained']; ?> </td> <td> <?php echo $v['theory_mark_max'];
else $query = 'qualification_id not in(select employee_academic_record_trans_qualification_id from employee_academic_record_trans where employee_academic_record_trans_user_id='.$id.') '; $remaining_course = Yii::app()->db->createCommand() ->select('qualification_id,qualification_name') ->from('qualification') ->where($query) ->queryAll(); ?> <div class="row"> <?php echo $form->labelEx($model,'employee_academic_record_trans_qualification_id'); ?> <?php echo $form->dropDownList($model,'employee_academic_record_trans_qualification_id',CHtml::listData($remaining_course,'qualification_id','qualification_name'),array('empty' => 'Select Course','tabindex'=>1));?><span class="status"> </span> <?php echo $form->error($model,'employee_academic_record_trans_qualification_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'employee_academic_record_trans_eduboard_id'); ?> <?php echo $form->dropDownList($model,'employee_academic_record_trans_eduboard_id',Eduboard::items(), array('empty' => 'Select Eduboard','tabindex'=>2)); ?><span class="status"> </span> <?php echo $form->error($model,'employee_academic_record_trans_eduboard_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'employee_academic_record_trans_year_id'); ?> <?php echo $form->dropDownList($model,'employee_academic_record_trans_year_id',$acd_years, array('empty' => 'Select Year','selected'=>'selected','tabindex'=>3)); ?><span class="status"> </span> <?php echo $form->error($model,'employee_academic_record_trans_year_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'theory_mark_max'); ?> <?php echo $form->textField($model,'theory_mark_max',array('tabindex'=>4,'size'=>3));?><span class="status"> </span> <?php echo $form->error($model,'theory_mark_max'); ?> </div>
?> <?php echo $form->dropDownList($model, 'student_academic_record_trans_qualification_id', CHtml::listData($remaining_course, 'qualification_id', 'qualification_name'), array('empty' => 'Select Course', 'tabindex' => 1)); ?> <span class="status"> </span> <?php echo $form->error($model, 'student_academic_record_trans_qualification_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'student_academic_record_trans_eduboard_id'); ?> <?php echo $form->dropDownList($model, 'student_academic_record_trans_eduboard_id', Eduboard::items(), array('empty' => 'Select Eduboard', 'tabindex' => 2)); ?> <span class="status"> </span> <?php echo $form->error($model, 'student_academic_record_trans_eduboard_id'); ?> </div> <div class="row"> <?php $y = date('Y'); $py = $y - 50; $arr = array_combine(range($py, $y, 1), range($py, $y, 1)); ?> <?php echo $form->labelEx($model, 'student_academic_record_trans_record_trans_year_id'); ?>
/** * Generate array for dropdown list to use in child form. * @return array $_items */ public static function items() { self::$_items = CHtml::listData(self::model()->findAll(), 'eduboard_id', 'eduboard_name'); return self::$_items; }