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