echo $form->labelEx($model, 'company_name');
?>
</td>
<td width="60%">
<?php
echo $form->dropDownList($model, 'company_name', CHtml::listData(Registration::model()->findAll('1 ORDER BY company_name'), 'company_id', 'company_name'), array('prompt' => 'Please Choose', 'name' => 'General_company_name', 'id' => 'General_company_name'));
?>
</td></tr>
<tr><td>
<?php
echo $form->labelEx($model, 'year');
?>
</td>
<td>
<?php
echo $form->dropDownList($model, 'year', CHtml::listData(Year::model()->findAll(), 'year', 'year'), array('name' => 'year', 'prompt' => 'Please Choose'));
?>
<?php
echo $form->error($model, 'year');
?>
</td>
</tr>
</table>
<table border="0" width="980" id="CreateGeneralLedgerTable">
</table>
<input type="submit" id="GenerateGeneralLedger" name="GenerateGeneralLedger" class="btn btn-warning" value="Generate" />
<?php
$this->endWidget();
{
?>
<div class="portlet box yellow" style="width:100%;margin-top:20px;">
<i class="icon-reorder"></i>
<div class="portlet-title"><span class="box-title">Batchwise Student History Report</span>
<div class="operation">
<?php echo CHtml::link('Excel', array('BranchwiseAllStudentsFeesDetailInfoReport','excel'=>'excel','Year[year]'=>$year, 'FeesPaymentTransaction[fees_student_branch_id]'=>$branch), array('class'=>'btnblue'));?>
</div>
</div>
<div class="portlet-body" >
<?php
$org = Organization::model()->findAll();
$org_data=$org[0];
$branch_model=Branch::model()->findByPk($branch);
$yr=Year::model()->findByPk($year);
?>
<?php echo '<table class="report-table" border=2 > ';
echo "<tr align=center> <th colspan = 60 style=text-align:left;> ".CHtml::image(Yii::app()->controller->createUrl('/site/loadImage', array('id'=>$org_data->organization_id)),'No Image',array('width'=>80,'height'=>55,'style'=>'float:left;margin-left:200px;')) ."
<big> <b>".$org_data->organization_name ."</big><br>". $org_data->address_line1." ".$org_data->address_line2."</br>" . City::model()->findBypk($org_data->city)->city_name.", ".State::model()->findBypk($org_data->state)->state_name.", ".Country::model()->findBypk($org_data->country)->name."." ." </th> <br> </tr>";
echo "<tr><th colspan=60><h3> Batch-".$yr->year." Branch of ".$branch_model->branch_name." All Students Fees Collection Report</h3></th> </tr>";
echo "<tr class='table_header'>";
echo "<th > SI<br> No.</th>";
echo "<th> Enrollement<br> No. </th>";
echo "<th colspan=2 > Student Full Name</th>";
foreach($startYear as $y)
{
/**
* 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 = Year::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
?>
</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'];
?>
</td>
<td>
<?php
echo $v['theory_percentage'];
public function findQpaper()
{
$_qpaper = Year::model()->findAll(array('order' => 'yid DESC', 'limit' => 1));
$qpaper = $_qpaper[0]->yid;
$qpaper = (int) $qpaper + 1;
return $qpaper;
}
?>
</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 Year::model()->findByPk($v['student_academic_record_trans_record_trans_year_id'])->year;
?>
</td>
<td>
<?php
echo $v['theory_mark_obtained'];
?>
</td>
<td>
<?php
echo $v['theory_mark_max'];
?>
</td>
<td>
<?php
echo $v['theory_percentage'];
public function actionStudentperformance()
{
$model=$this->loadModel($_REQUEST['id']);
$user = User::model()->findByPk($model->student_transaction_user_id);
$info = StudentInfo::model()->findByPk($model->student_transaction_student_id);
$address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id);
$photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id);
$lang = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id);
$stud_qua = new StudentAcademicRecordTrans;
$stud_feed = new FeedbackDetailsTable;
$studentcertificate=new StudentCertificateDetailsTable;
$studentdocstrans=new StudentDocsTrans;
$stud_qua=new StudentAcademicRecordTrans;
$stud_feed=new FeedbackDetailsTable('mysearch');
$parent = '';
$yearModel=new Year;
$year=Year::model()->findByPk($model->student_transaction_batch_year);
if(isset(Yii::app()->modules['parents']))
$parent = new ParentLogin;
$stud_feed->unsetAttributes(); // clear any default values
if(isset($_GET['FeedbackDetailsTable']))
$stud_feed->attributes=$_GET['FeedbackDetailsTable'];
$this->render('update',array(
'model'=>$model,'info'=>$info,'photo'=>$photo,'address'=>$address,'user'=>$user,'lang'=>$lang,'studentdocstrans'=>$studentdocstrans, 'stud_qua'=>$stud_qua,'stud_feed'=>$stud_feed,'flag'=>0,'studentcertificate'=>$studentcertificate,'parent'=>$parent,'yearModel'=>$yearModel,'year'=>$year
));
}
