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>