public function actionRecpt_list()
{
$this->layout = 'receipt_layout';
$misc_fees_payment = MiscellaneousFeesPaymentCheque::model()->findByPk($_REQUEST['id']);
$model = StudentTransaction::model()->findByPk($misc_fees_payment->miscellaneous_fees_payment_cheque_student_id);
$stud_id = $model->student_transaction_student_id;
$stud_model = StudentInfo::model()->findByPk($model->student_transaction_student_id);
$acd_term = AcademicTermPeriod::model()->findByPk($model->student_academic_term_period_tran_id);
$branch = Branch::model()->findByPk($model->student_transaction_branch_id);
//print_r($_REQUEST['id']);
//print "<br/>model".$misc_fees_payment->miscellaneous_fees_payment_cash_student_id;
//print "<br/>reciept_no".$misc_fees_payment->miscellaneous_fees_payment_cash_receipt_id;
//print "<br/>stud_id".$model->student_transaction_student_id;
//print "<br/>curent date".date('d/m/y');
//print "<br/>stud_model".$stud_model->student_first_name.''.$stud_model->student_middle_name.''.$stud_model->student_last_name;
//print "<br/>dbdate".$misc_fees_payment->miscellaneous_fees_payment_cash_creation_date;
//print "<br/>branch_name".$branch->branch_name;
//print "<br/>academic_term".$acd_term->academic_terms_period_name;
//print "</br>roll no".$stud_model->student_roll_no;
//exit;
$this->render('recpt_list', array('model' => $model, 'stud_model' => $stud_model, 'acd_term' => $acd_term, 'branch' => $branch, 'misc_fees_payment' => $misc_fees_payment));
}
<?php
$this->breadcrumbs = array('Semester' => array('admin'), $model->academic_term_name);
$this->menu = array(array('label' => '', 'url' => array('create'), 'linkOptions' => array('class' => 'Create', 'title' => 'Add')), array('label' => '', 'url' => array('update', 'id' => $model->academic_term_id), 'linkOptions' => array('class' => 'Edit', 'title' => 'Edit')), array('label' => '', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->academic_term_id), 'confirm' => 'Are you sure you want to delete this item?', 'class' => 'Delete', 'title' => 'Delete')), array('label' => '', 'url' => array('admin'), 'linkOptions' => array('class' => 'Manage', 'title' => 'Manage')));
?>
<h1>View Semester <?php
//echo $model->academic_term_id;
?>
</h1>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('academic_term_name', array('name' => 'academic_term_start_date', 'type' => 'raw', 'value' => $model->academic_term_start_date == 00 - 00 - 00 ? 'Not Set' : date_format(new DateTime($model->academic_term_start_date), 'd-m-Y')), array('name' => 'academic_term_end_date', 'type' => 'raw', 'value' => $model->academic_term_end_date == 00 - 00 - 00 ? 'Not Set' : date_format(new DateTime($model->academic_term_end_date), 'd-m-Y')), array('name' => 'academic_term_period_id', 'value' => AcademicTermPeriod::model()->findByPk($model->academic_term_period_id)->academic_term_period), array('name' => 'current_sem', 'value' => $model->current_sem == 1 ? "YES" : "NO"), array('name' => 'Organization', 'value' => Organization::model()->findByPk($model->academic_term_organization_id)->organization_name, 'filter' => false))));
background: #f1f6ff;
}
table tr:nth-child(odd) { /*(odd) or (2n 1)*/
background: white;
}
th{text-align:left;font-weight:normal;color:#990a10;width:110px;border:0.4px solid #74b9f0;height:24px;}
.title{color:seagreen;}
td{border:0.4px solid #74b9f0;height:24px;}
.label{text-align:left;font-weight:normal;color:#990a10;width:110px;height:24px;}
</style>
<?php
$StudentInfo = StudentInfo::model()->findByPk($student_transaction[0]->student_transaction_student_id);
$AcademicTermPeriod = AcademicTermPeriod::model()->findByPk($student_transaction[0]->academic_term_period_id);
$AcademicTerm = AcademicTerm::model()->findByPk($student_transaction[0]->academic_term_id);
if($student_transaction[0]->student_transaction_nationality_id != null)
$Nationality = Nationality::model()->findByPk($student_transaction[0]->student_transaction_nationality_id);
else
$Nationality = new Nationality;
$Batch = Batch::model()->findByPk($student_transaction[0]->student_transaction_batch_id);
$Course = Course::model()->findByPk($student_transaction[0]->course_id);
if($student_transaction[0]->student_transaction_languages_known_id != null)
$LanguagesKnown = LanguagesKnown::model()->findByPk($student_transaction[0]->student_transaction_languages_known_id);
if($student_transaction[0]->student_transaction_student_address_id != null)
$StudentAddress = StudentAddress::model()->findByPk($student_transaction[0]->student_transaction_student_address_id);
else
$StudentAddress = new StudentAddress;
if($student_transaction[0]->student_transaction_parent_id != null || $student_transaction[0]->student_transaction_parent_id != 0)
$parent = ParentLogin::model()->findByPk($student_transaction[0]->student_transaction_parent_id);
if (!empty($branch1)) {
if (!empty($div)) {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1, 'student_transaction_division_id' => $div));
} else {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1));
}
} else {
$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
}
if (empty($stud_trans)) {
continue;
}
$stud_model = StudentInfo::model()->findByAttributes(array('student_id' => $stud_trans['student_transaction_student_id']));
$sem_name = AcademicTerm::model()->findByPk($data['fees_academic_term_id']);
$branch = Branch::model()->findByPk($stud_trans['student_transaction_branch_id']);
$acd_term = AcademicTermPeriod::model()->findByPk($data['fees_academic_period_id']);
$field1 = '-';
$field2 = '-';
$field3 = '-';
$field4 = '-';
$field5 = 'CASH';
if ($data['fees_payment_method_id'] == 1) {
$cash_amt = FeesPaymentCash::model()->findByPk($data['fees_payment_cash_cheque_id']);
$amount = $cash_amt->fees_payment_cash_amount;
} else {
$cash_amt = FeesPaymentCheque::model()->findByPk($data['fees_payment_cash_cheque_id']);
$amount = $cash_amt->fees_payment_cheque_amount;
$field1 = $cash_amt->fees_payment_cheque_number;
$date = date_create($cash_amt->fees_payment_cheque_date);
$field2 = date_format($date, 'd-m-Y');
$bank_name = BankMaster::model()->findByPk($cash_amt->fees_payment_cheque_bank);
if(!empty($if_detain))
{?>
<tr class="<?php echo $class;?>">
<td><?php echo ++$i;?></td>
<td><?php echo AcademicTermPeriod::model()->findByPk($if_detain['academic_term_period_id'])->academic_term_period; ?></td>
<td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_detain['sem'])->academic_term_name; ?></td>
<td>Detain</td>
</tr>
<?php $m++; $st="Rejoin/Regular";
}
$if_stud_arch = StudentArchiveTable::model()->findByAttributes(array('student_archive_stud_tran_id'=>$stud_trans[0]['student_transaction_id'],'student_archive_ac_t_n_id'=>$data['academic_term_id']));
if($if_stud_arch)
{?>
<tr class="<?php echo $class;?>">
<td><?php echo ++$i;?></td>
<td><?php echo AcademicTermPeriod::model()->findByPk($if_stud_arch['student_archive_ac_t_p_id'])->academic_term_period; ?></td>
<td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_stud_arch['student_archive_ac_t_n_id'])->academic_term_name; ?></td>
<td><?php echo $st;?></td>
</tr>
<?php $m++; }
}
?>
</table>
<?php } ?>
<?php
echo $form->label($model, 'fees_branch_id'); ?> <?php echo $form->textField($model, 'fees_branch_id'); ?> </div> --> <div class="row"> <?php echo $form->label($model, 'fees_academic_term_id'); ?> <?php //echo $form->textField($model,'fees_academic_term_id'); ?> <?php echo $form->dropDownList($model, 'fees_academic_term_id', AcademicTermPeriod::items()); ?> </div> <!-- <div class="row"> <?php echo $form->label($model, 'fees_quota_id'); ?> <?php echo $form->textField($model, 'fees_quota_id'); ?> </div> --> <div class="row buttons"> <?php
">
<td>
<?php
echo $k;
?>
</td>
<td>
<?php
echo Branch::model()->findByPk($i['fees_branch_id'])->branch_name;
?>
</td>
<td>
<?php
echo AcademicTermPeriod::model()->findByPk($i['fees_academic_term_id'])->academic_term_period;
?>
</td>
<td>
<?php
echo AcademicTerm::model()->findByPk($i['fees_academic_term_name_id'])->academic_term_name;
?>
</td>
<td>
<?php
echo Quota::model()->findByPk($i['fees_quota_id'])->quota_name;
?>
</td>
<td>
),
array('name' => 'student_first_name',
'value' => '$data->Rel_Stud_Info->student_first_name',
),
array('name' => 'student_middle_name',
'value' => '$data->Rel_Stud_Info->student_middle_name',
),
array('name' => 'student_last_name',
'value' => '$data->Rel_Stud_Info->student_last_name',
),
array('name'=>'student_archive_ac_t_p_id',
'value'=>'AcademicTermPeriod::model()->findByPk($data->student_archive_ac_t_p_id)->academic_term_period',
'filter' =>CHtml::listData(AcademicTermPeriod::model()->findAll(), 'academic_terms_period_id','academic_term_period'),
),
array('name'=>'student_archive_ac_t_n_id',
'value'=>'AcademicTerm::model()->findByPk($data-> student_archive_ac_t_n_id)->academic_term_name',
'filter' =>CHtml::listData(AcademicTerm::model()->findAll(), 'academic_term_id','academic_term_name','academicTermPeriod.academic_term_period'),
),
array('name' => 'status_name',
'value' => '$data->Rel_Status->status_name',
),
array('name'=>'student_archive_branch_id',
'value'=>'Branch::model()->findByPk($data->student_archive_branch_id)->branch_name',
<h1>Reset Student Password</h1>
<div class="portlet box blue">
<div class="portlet-title"> Student List
</div>
<?php
//echo CHtml::link('Advanced Search','#',array('class'=>'search-button'));
$dataProvider = $model->resetloginstudentsearch();
if (Yii::app()->user->getState("pageSize", @$_GET["pageSize"])) {
$pageSize = Yii::app()->user->getState("pageSize", @$_GET["pageSize"]);
} else {
$pageSize = Yii::app()->params['pageSize'];
}
$dataProvider->getPagination()->setPageSize($pageSize);
?>
<div class="block-error">
<?php
echo Yii::app()->user->getFlash('resetstudpassword');
?>
</div>
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'student-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'columns' => array(array('header' => 'SI No', 'class' => 'IndexColumn'), array('name' => 'student_enroll_no', 'value' => '$data->Rel_Stud_Info->student_enroll_no'), array('name' => 'student_first_name', 'value' => '$data->Rel_Stud_Info->student_first_name'), array('name' => 'student_last_name', 'value' => '$data->Rel_Stud_Info->student_last_name'), array('name' => 'student_academic_term_period_tran_id', 'value' => 'AcademicTermPeriod::model()->findByPk($data->student_academic_term_period_tran_id)->academic_term_period', 'filter' => CHtml::listData(AcademicTermPeriod::model()->findAll(), 'academic_terms_period_id', 'academic_term_period')), array('name' => 'student_transaction_course_id', 'value' => 'CourseMaster::model()->findByPk($data->student_transaction_course_id)->course_name', 'filter' => CHtml::listData(CourseMaster::model()->findAll(), 'course_master_id', 'course_name')), array('name' => 'student_transaction_user_id', 'value' => 'User::model()->findByPk($data->student_transaction_user_id)->user_organization_email_id', 'filter' => CHtml::listData(User::model()->findAll(array('condition' => ' user_type="student"')), 'user_id', 'user_organization_email_id')), array('class' => 'CButtonColumn', 'template' => '{Reset Password}', 'buttons' => array('Reset Password' => array('label' => 'Reset Password', 'url' => 'Yii::app()->createUrl("user/update_stud_password", array("id"=>$data->student_transaction_user_id))', 'imageUrl' => Yii::app()->baseUrl . '/images/Reset Password.png', 'options' => array('id' => 'update-student-status'))))), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
?>
</div>
$total = 0;
$student_fees = StudentFeesMaster::model()->findAll('fees_master_table_id = :fees_master_id AND student_fees_master_student_transaction_id = :student_id', array(':fees_master_id' => $f->fees_payment_master_id, ':student_id' => $f->fees_student_id));
//print_r($student_fees); exit;
foreach ($student_fees as $fees_data) {
$total += $fees_data->fees_details_amount;
}
$payable = $total;
//$payable = FeesMaster::model()->findByPk($f->fees_payment_master_id)->fees_master_total;
$payable1 = $payable;
//$out = $payable - $var;
}
$out = $payable - $var;
$ch_num = FeesPaymentCheque::model()->findByPk($f->fees_payment_cash_cheque_id)->fees_payment_cheque_number;
echo "<tr class=" . $class . ">";
echo "<td>" . $i . "</td>";
echo "<td>" . AcademicTermPeriod::model()->findByPk($f->fees_academic_period_id)->academic_term_period . "</td>";
echo "<td>" . AcademicTerm::model()->findByPk($f->fees_academic_term_id)->academic_term_name . "</td>";
echo "<td>" . FeesPaymentMethod::model()->findByPk($f->fees_payment_method_id)->fees_payment_method_name . "</td>";
//echo "<td>".FeesMaster::model()->findByPk($f->fees_payment_master_id)->fees_master_total."</td>";
echo "<td>" . $payable1 . "</td>";
$chqmodel = FeesPaymentCheque::model()->findByPk($f->fees_payment_cash_cheque_id);
echo "<td>" . $chqmodel->fees_payment_cheque_amount . "</td>";
//$var += FeesPaymentCheque::model()->findByPk($f->fees_payment_cash_cheque_id)->fees_payment_cheque_amount;
$bank_model = BankMaster::model()->findByPk($chqmodel->fees_payment_cheque_bank);
$bank_name = $bank_model->bank_short_name;
$bank_branch = $bank_model->bank_short_name;
$date = $f->fees_received_date;
$new_date = date("d-m-Y", strtotime($date));
echo "<td>" . $new_date . "</td>";
echo "<td>" . $bank_name . "</td>";
echo "<td>" . $bank_branch . "</td>";
<?php
$this->breadcrumbs = array('Semester' => array('admin'), $model->academic_term_name);
?>
<h1>View Semester <?php
//echo $model->academic_term_id;
?>
</h1>
<div class="operation">
<?php
echo CHtml::link('Back', array('admin'), array('class' => 'btnback'));
echo CHtml::link('Edit', array('update', 'id' => $model->academic_term_id), array('class' => 'btnupdate'));
echo CHtml::link('Delete', array('delete', 'id' => $model->academic_term_id), array('class' => 'btndelete', 'onclick' => "return confirm('Are you sure want to delete?');"));
?>
</div>
<div class="portlet box blue">
<i class="icon-reorder"></i>
<div class="portlet-title">View Details
</div>
<?php
$this->widget('application.extensions.DetailView4Col', array('data' => $model, 'attributes' => array('academic_term_name', array('name' => 'academic_term_start_date', 'type' => 'raw', 'value' => $model->academic_term_start_date == 00 - 00 - 00 ? 'Not Set' : date_format(new DateTime($model->academic_term_start_date), 'd-m-Y')), array('name' => 'academic_term_end_date', 'type' => 'raw', 'value' => $model->academic_term_end_date == 00 - 00 - 00 ? 'Not Set' : date_format(new DateTime($model->academic_term_end_date), 'd-m-Y')), array('name' => 'academic_term_period_id', 'value' => AcademicTermPeriod::model()->findByPk($model->academic_term_period_id)->academic_term_period), array('name' => 'current_sem', 'value' => $model->current_sem == 1 ? "YES" : "NO")), 'htmlOptions' => array('class' => 'custom-view')));
?>
</div>
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'fees_branch_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'fees_academic_term_id');
?>
<?php
//echo $form->dropDownList($model,'fees_academic_term_id',AcademicTermPeriod::items(), array('empty' => '----------Select--------'));
?>
<?php
echo $form->dropDownList($model, 'fees_academic_term_id', AcademicTermPeriod::items(), array('prompt' => 'Select Year', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('dependent/getFeesmasterItemName'), 'update' => '#FeesMaster_fees_academic_term_name_id')));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'fees_academic_term_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'fees_academic_term_name_id');
?>
<?php
//echo $form->dropDownList($model,'fees_academic_term_name_id',array());
?>
<?php
?>
<?php
/*$_SESSION['branch_id']=$_REQUEST['branch_id'];
$_SESSION['acm_id']=$_REQUEST['acm_id'];
$_SESSION['acm_name_id']=$_REQUEST['acm_name_id'];*/
//echo CHtml::link('Export to pdf',array('paid','paidExport'=>'paidpdf','branch_id'=>$_REQUEST['branch_id'],'acm_id'=>$_REQUEST['acm_id'],'acm_name_id'=>$_REQUEST['acm_name_id']));
if ($data) {
?>
<table class="table_data">
<th colspan="11" style="font-size: 18px; color: rgb(255, 255, 255);">
Paid/Partialy Paid Student<br/>
<?php
echo "Branch : " . Branch::model()->findByPk($_REQUEST['branch_id'])->branch_name . "(" . Quota::model()->findByPk($_REQUEST['quota'])->quota_name . ")<br/>";
echo "Semester: " . AcademicTerm::model()->findByPk($_REQUEST['acm_name_id'])->academic_term_name . "(" . AcademicTermPeriod::model()->findByPk($_REQUEST['acm_id'])->academic_term_period . ")";
?>
</th>
<tr class="table_header">
<th>SI.No.</th>
<th>Enroll No.</th>
<th>Roll No.</th>
<th>Name</th>
<th>Payable Amount</th>
<th>Paid Amount</th>
<th>Outstanding</th>
</tr>
<?php
$i = 0;
$m = 1;
$grandpayable = 0;
/**
* 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 = AcademicTermPeriod::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
echo $form->error($model, 'shift_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'sem_id');
?>
<?php
//echo $form->textField($model,'sem_id');
?>
<?php
//echo $form->dropDownList($model,'sem_id', CHtml::listData(AcademicTermPeriod::model()->findAll(), 'academic_terms_period_id', 'academic_terms_period_name'));
?>
<?php
echo $form->dropDownList($model, 'sem_id', AcademicTermPeriod::items(), array('empty' => '-----------Select---------', 'tabindex' => 2));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'sem_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'branch_id');
?>
<?php
//echo $form->textField($model,'branch_id');
?>
<?php
<?php
echo StudentInfo::model()->findByPk($v['student_transaction_student_id'])->student_first_name;
?>
</td>
<td>
<?php
echo StudentInfo::model()->findByPk($v['student_transaction_student_id'])->student_last_name;
?>
</td>
<td>
<?php
echo AcademicTermPeriod::model()->findByPk($v['student_academic_term_period_tran_id'])->academic_term_period;
?>
</td>
<td>
<?php
if (isset($v['student_academic_term_name_id'])) {
echo "Sem-" . AcademicTerm::model()->findByPk($v['student_academic_term_name_id'])->academic_term_name;
} else {
echo "N/A";
}
?>
</td>
<td>
$this->menu = array();
?>
<h1>Generating Student Postal Label</h1>
<div class="form">
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'studentinfo-form', 'enableAjaxValidation' => true));
?>
<p class="note"><span class="required"></span> </p>
<div class="row">
<?php
echo CHtml::label('Term Period', '');
?>
<?php
echo CHtml::dropDownList('acdm_period', null, AcademicTermPeriod::items(), array('prompt' => '---------------Select-------------', 'tabindex' => 1, 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('dependent/getIdAcademicterm'), 'update' => '#acdm_name')));
?>
</div>
<div class="row">
<?php
echo CHtml::label('Term Name', '');
?>
<?php
echo CHtml::dropDownList('acdm_name', null, array('empty' => '---------------Select-------------'), array('tabindex' => 2));
?>
</div>
<div class="row">
<?php
echo CHtml::label('Branch', '');
?>
<?php
private static function loadItems()
{
self::$_items = array();
$models = self::model()->findAll();
foreach ($models as $model) {
self::$_items[$model->academic_terms_period_id] = $model->academic_term_period;
}
}
</div>
-->
<div class="row">
<div>
<?php
echo $form->labelEx($model, 'sem_id');
?>
<?php
//echo $form->dropDownList($model,'student_academic_term_period_tran_id',AcademicTermPeriod::items(), array('empty' => '-----------Select---------','tabindex'=>17));
?>
<?php
echo $form->dropDownList($model, 'sem_id', AcademicTermPeriod::items(), array('prompt' => '---------------Select-------------', 'tabindex' => 2, 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('Attendence/getItemName'), 'update' => '#Attendence_sem_name_id')));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'sem_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'sem_name_id');
?>
<?php
//echo $form->dropDownList($model,'student_academic_term_name_id',array());
?>
<?php
if (isset($model->sem_name_id)) {
$this->menu=array(
array('label'=>'List StudentFeesMaster', 'url'=>array('index')),
array('label'=>'Create StudentFeesMaster', 'url'=>array('create')),
array('label'=>'View StudentFeesMaster', 'url'=>array('view', 'id'=>$model->student_fees_master_id)),
array('label'=>'Manage StudentFeesMaster', 'url'=>array('admin')),
);*/
?>
<h1>Edit Student Fees <?php
//echo $model->student_fees_master_id;
?>
</h1></br>
<?php
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $model->student_fees_master_student_transaction_id));
$stud_tran_info = StudentTransaction::model()->findByPk($model->student_fees_master_student_transaction_id);
$academic_period = AcademicTermPeriod::model()->findByPk($stud_tran_info->student_academic_term_period_tran_id)->academic_term_period;
$semester = AcademicTerm::model()->findByPk($stud_tran_info->student_academic_term_name_id)->academic_term_name;
?>
<table border="2px" id="twoColThinTable">
<tr class="row">
<td class="col1">Name </td>
<td class="col2"><?php
echo $stud_info->student_first_name . ' ' . $stud_info->student_middle_name . ' ' . $stud_info->student_last_name;
?>
</td>
</tr>
<tr class="row">
<td class="col1">Enrollment No. </td>
<td class="col2"><?php
echo $stud_info->student_enroll_no;
array(
'name'=>'academic_term_start_date',
'type'=>'raw',
'value'=>$model->academic_term_start_date,
),
array(
'name'=>'academic_term_end_date',
'type'=>'raw',
'value'=>$model->academic_term_end_date,
),
array(
'name'=>'course_id',
'type'=>'raw',
'value'=>($model->course_id==0) ? "Not Set" : $model->Rel_course->course_name,
),
// 'academic_term_period_id',
array('name'=>'academic_term_period_id',
'value'=>AcademicTermPeriod::model()->findByPk($model->academic_term_period_id)->academic_term_period,
),
array(
'name'=>'current_sem',
'value'=>($model->current_sem == 1) ? "YES" : "NO",
),
),
//'htmlOptions'=> array('class'=>'report-table'),
)); ?>
</div>
</div>
</div>
<?php
$org_data = Organization::model()->findByPk(Yii::app()->user->getState('org_id'));
$semester_array = range(0, $org_data['no_of_semester'], 1);
$semester_array[0] = 'Select Semester';
//echo $form->errorSummary($model);
?>
<div class="row">
<?php
echo $form->labelEx($model, 'academic_term_period_id');
?>
<?php
//echo $form->textField($model,'academic_term_period_id');
?>
<?php
echo $form->dropDownList($model, 'academic_term_period_id', CHtml::listData(AcademicTermPeriod::model()->findAll(array('condition' => 'academic_terms_period_organization_id=' . Yii::app()->user->getState('org_id'))), 'academic_terms_period_id', 'academic_term_period'), array('empty' => 'Select Year'));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'academic_term_period_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'academic_term_name');
?>
<?php
//echo $form->textField($model,'academic_term_name',array('size'=>40,'maxlength'=>30));
echo $form->dropDownList($model, 'academic_term_name', $semester_array);
?>
<span class="status"> </span><?php
<th>Cheque No</th>
<th>Receipt No</th>
<th>Amount</th>
</tr>
<?php
foreach ($var as $list) {
$stud_data = StudentTransaction::model()->findByPk($list['fees_student_id']);
echo '<tr><td>' . $i . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_enroll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_roll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_first_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_middle_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_last_name . '</td>';
echo '<td>' . Branch::model()->findByPk($stud_data->student_transaction_branch_id)->branch_name . '</td>';
echo '<td>' . AcademicTerm::model()->findByPk($stud_data->student_academic_term_name_id)->academic_term_name . '</td>';
echo '<td>' . AcademicTermPeriod::model()->findByPk($stud_data->student_academic_term_period_tran_id)->academic_term_period . '</td>';
echo '<td>' . Division::model()->findByPk($stud_data->student_transaction_division_id)->division_name . '</td>';
echo '<td>' . $list['fees_received_date'] . '</td>';
$rec_no = FeesReceipt::model()->findByPk($list['fees_receipt_id'])->fees_receipt_number;
if ($list['fees_payment_method_id'] == '1') {
$cash_id = $list['fees_payment_cash_cheque_id'];
$amunt = FeesPaymentCash::model()->findByPk($cash_id)->fees_payment_cash_amount;
$final_total += $amunt;
$type = "Cash";
echo '<td>' . $type . '</td>';
echo '<td>-</td>';
echo '<td>-</td>';
echo '<td>' . $rec_no . '</td>';
echo '<td>' . $amunt . '</td>';
} else {
$cheque_id = $list['fees_payment_cash_cheque_id'];
echo $form->labelEx($model, 'student_archive_branch_id');
?>
<?php
echo $form->dropDownList($model, 'student_archive_branch_id', CHtml::listData(Branch::model()->findAll(array('condition' => 'branch_organization_id=' . Yii::app()->user->getState('org_id'))), 'branch_id', 'branch_name'), array('empty' => 'Select Branch', 'tabindex' => 1));
?>
<?php
echo $form->error($model, 'student_archive_branch_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'student_archive_ac_t_p_id');
?>
<?php
echo $form->dropDownList($model, 'student_archive_ac_t_p_id', AcademicTermPeriod::items(), array('prompt' => 'Select Year', 'tabindex' => 2, 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('dependent/getStudentArchiveAcademicTerm'), 'update' => '#StudentArchiveTable_student_archive_ac_t_n_id')));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'student_archive_ac_t_p_id');
?>
</div>
<div class="row">
<?php
echo $form->label($model, 'student_archive_ac_t_n_id');
?>
<?php
echo $form->dropDownList($model, 'student_archive_ac_t_n_id', array());
?>
</div>
?>
<?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)
{
echo '<th >'.AcademicTermPeriod::model()->findByPk($y)->academic_term_period.'</th>';
}
echo "<th colspan=2> Total Paid Fees </th>";
$m=0;
foreach($student as $s)
{
$paidAmt=$paid_amt=$paid_amount=0;
if(($m%2) == 0)
{
$class = "odd";
}
else
{
$class = "even";
<th>Paid Amount</th>
<th>OutStanding Amount</th>
</tr>
<?php
$i=1;
$course_fees=$course->course_fees;
$totalcollection=count($student_data)*$course_fees;
$total_paid=0;
$total_out=0;
foreach($student_data as $stu_details)
{
echo '<tr align="center">';
echo '<td>'.$i.'</td>';
echo '<td>'.$stu_details['student_roll_no'].'</td>';
echo '<td>'.$stu_details['student_first_name']." ".$stu_details['student_middle_name']." ".$stu_details['student_last_name'].'</td>';
echo '<td>'.AcademicTermPeriod::model()->findByPk($stu_details['academic_term_period_id'])->academic_term_period.'</td>';
echo '<td>'.Course::model()->findByPk($stu_details['course_id'])->course_name.'</td>';
echo '<td>'.AcademicTerm::model()->findByPk($stu_details['academic_term_id'])->academic_term_name.'</td>';
echo '<td>'.Batch::model()->findByPk($stu_details['student_transaction_batch_id'])->batch_name.'</td>';
echo '<td>'.$course_fees.'</td>';
$paidfees_tmp = Yii::app()->db->createCommand()
->select('sum(fees_payment_amount) as paidfees')
->from('fees_payment_transaction')
->where('fees_payment_student_id = '.$stu_details['student_transaction_id'])
->queryRow();
$paidfees = array_filter($paidfees_tmp);
if(!empty($paidfees))
$stu_paidfees = $paidfees['paidfees'];
else
$stu_paidfees = 0;
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'student_transaction_category_id');
?>
</div>-->
</div>
<div class="row">
<div class="row-left">
<?php
echo $form->labelEx($model, 'student_academic_term_period_tran_id');
?>
<?php
echo $form->dropDownList($model, 'student_academic_term_period_tran_id', AcademicTermPeriod::items(), array('prompt' => '-----------Select-----------', 'tabindex' => 9, 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('dependent/getStudItemName'), 'update' => '#StudentTransaction_student_academic_term_name_id')));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'student_academic_term_period_tran_id');
?>
</div>
<div class="row-right">
<?php
echo $form->labelEx($model, 'student_academic_term_name_id');
?>
<?php
$term = "Sem-" . $model->academic_term_name;
if (isset($model->student_academic_term_name_id)) {
echo $form->dropDownList($model, 'student_academic_term_name_id', CHtml::listData(AcademicTerm::model()->findAll(array('condition' => 'academic_term_period_id=' . $model->student_academic_term_period_tran_id)), 'academic_term_id', 'academic_term_name'));
} else {
'id'=>'attendence-division',
'enableAjaxValidation'=>true,
'clientOptions'=>array('validateOnSubmit'=>true),
)); ?>
<?php $org_id=Yii::app()->user->getState('org_id');
$acd = Yii::app()->db->createCommand()
->select('*')
->from('academic_term')
->where('current_sem=1 ')
->queryAll();
$acdterm=CHtml::listData($acd,'academic_term_id','academic_term_name');
//echo $acdterm;
$period=array();
if(!empty($acdterm)){
$pe_data = AcademicTermPeriod::model()->findByPk($acd[0]['academic_term_period_id']);
$period[$pe_data->academic_terms_period_id] = $pe_data->academic_term_period;
}?>
<p class="note">Fields with <span class="required">*</span> are required.</p>
<div class="row">
<?php echo $form->labelEx($model,'sem_id'); ?>
<?php echo $form->dropDownList($model,'sem_id',$period,array('tabindex'=>1,'prompt' => 'Select Year')); ?>
<span class="status"> </span>
<?php echo $form->error($model,'sem_id'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'sem_name_id'); ?>
<?php echo $form->dropDownList($model,'sem_name_id',$acdterm,array('tabindex'=>2,'empty' => 'Select Semester')); ?>
<span class="status"> </span>
<?php echo $form->error($model,'sem_name_id'); ?>
$ct = "<b>".City::model()->findByPk($address->student_address_c_city)->city_name."</b>";
if($address->student_address_c_state != 0)
$stat = "<b>".State::model()->findByPk($address->student_address_c_state)->state_name."</b>";
$padd = "<b>".$address->student_address_p_line1.",".$address->student_address_p_line2."</b>";
if($address->student_address_p_city != 0)
$pct = "<b>".City::model()->findByPk($address->student_address_p_city)->city_name."</b>";
if($address->student_address_p_state != 0)
$pstat = "<b>".State::model()->findByPk($address->student_address_p_state)->state_name."</b>";
}
$ac_pid = $trans->student_academic_term_period_tran_id;
$arch = StudentArchiveTable::model()->find(array('condition'=>'student_archive_stud_tran_id='.$trans->student_transaction_id, 'order'=>'student_archive_ac_t_p_id desc'));
if($arch)
$ac_pid = $arch->student_archive_ac_t_p_id;
$year = AcademicTermPeriod::model()->findByPk($ac_pid)->academic_term_period;
$ref_no = "";
if(Yii::app()->controller->action->id=="certiview")
{
$certi= StudentCertificateDetailsTable::model()->find(array('condition'=>' student_certificate_details_table_student_id='.$trans->student_transaction_id.' and student_certificate_type_id='.$certificate_type,'order'=>'student_certificate_details_table_id desc'));
$ref_no = $certi->certificate_reference_number;
}
else{
$certi = StudentCertificateDetailsTable::model()->find(array('order'=>'student_certificate_details_table_id desc'));
$autonum = 0;
if(!empty($certi) && $certi->certificate_reference_number!=""){
$arr = explode('/',$certi->certificate_reference_number);
$autonum = $arr[3];
}
$autonum +=1;
$ref_no = $year."/".$branch_model->branch_code."/".date('Y').'/'.$autonum;
?>
<tr>
<td>
<?php echo $k; ?>
</td>
<td>
<?php echo "Sem-".$v['academic_term_name']; ?>
</td>
<td>
<?php echo ($v['academic_term_start_date'] == 0000-00-00) ? "Not Set" : date_format(new DateTime($v['academic_term_start_date']), "d-m-Y");?>
</td>
<td>
<?php echo ($v['academic_term_end_date'] == 0000-00-00) ? "Not Set" : date_format(new DateTime($v['academic_term_end_date']), "d-m-Y");?>
</td>
<td>
<?php echo AcademicTermPeriod::model()->findByPk($v['academic_term_period_id'])->academic_term_period;?>
</td>
<td>
<?php echo ($v['current_sem'] == 1) ? "True" : "False";?>
</td>
</tr>
<?php $k++;?>
<?php }// end if
}// end for loop?>
</table>
