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');
?>
