<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;
}
