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)); }
</tr> <?php foreach ($var1 as $list) { if ($m % 2 == 0) { $class = "odd"; } else { $class = "even"; } $stud_data = StudentTransaction::model()->findByPk($list['fees_student_id']); print '<tr class=' . $class . '><td>' . $i . '</td>'; print '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_enroll_no . '</td>'; print '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_roll_no . '</td>'; print '<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>'; print '<td>' . Branch::model()->findByPk($stud_data->student_transaction_branch_id)->branch_name . '</td>'; print '<td>' . AcademicTerm::model()->findByPk($list['fees_academic_term_id'])->academic_term_name . '</td>'; print '<td>' . AcademicTermPeriod::model()->findByPk($list['fees_academic_period_id'])->academic_term_period . '</td>'; print '<td>' . Division::model()->findByPk($stud_data->student_transaction_division_id)->division_name . '</td>'; print '<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"; print '<td>' . $type . '</td>'; print '<td>-</td>'; print '<td>-</td>'; print '<td>' . $rec_no . '</td>'; print '<td>' . $amunt . '</td>'; } else { $cheque_id = $list['fees_payment_cash_cheque_id'];
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);
?> <?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>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'];
"> <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>
<?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>
'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'); ?>
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new FeesPaymentTransaction(); $FeesMasterDetails = new FeesMaster(); $total = 0; $result = $_REQUEST['id']; $fees_stru = Yii::app()->db->createCommand()->select('fees.fees_master_id , fees.fees_master_name , fees.fees_branch_id , stud.student_transaction_branch_id , stud.student_transaction_organization_id , fees.fees_organization_id , stud.student_transaction_quota_id , fees.fees_quota_id ,stud.student_academic_term_period_tran_id , fees.fees_academic_term_id, fees.fees_academic_term_name_id, fees.fees_master_total')->from('student_transaction stud')->join('fees_master fees', 'stud.student_transaction_branch_id = fees.fees_branch_id AND stud.student_academic_term_period_tran_id = fees.fees_academic_term_id AND stud.student_academic_term_name_id = fees.fees_academic_term_name_id AND stud.student_transaction_quota_id = fees.fees_quota_id')->where('stud.student_transaction_id=:id', array(':id' => $result))->queryRow(); $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' => $fees_stru['fees_master_id'], ':student_id' => $result)); //print_r($student_fees); exit; foreach ($student_fees as $fees_data) { $total += $fees_data->fees_details_amount; } if (!$fees_stru) { $ourscript = "alert('No fees available for this critaria.. Please create fees with this branch, academic year and semester of student. \t');"; Yii::app()->clientScript->registerScript('helloscript', $ourscript, CClientScript::POS_READY); $this->redirect(array('error', 'status' => 'nofees')); } else { $model->fees_payment_master_id = $fees_stru['fees_master_id']; $org = Organization::model()->findByPk($fees_stru['fees_organization_id']); $quota = Quota::model()->findByPk($fees_stru['fees_quota_id']); $branch = Branch::model()->findByPk($fees_stru['fees_branch_id']); $acmd = AcademicTermPeriod::model()->findByPk($fees_stru['fees_academic_term_id']); $acmd_name = AcademicTerm::model()->findByPk($fees_stru['fees_academic_term_name_id']); $FeesMasterDetails->fees_master_name = $fees_stru['fees_master_name']; $FeesMasterDetails->fees_organization_id = $org->organization_name; $FeesMasterDetails->fees_quota_id = $quota->quota_name; $FeesMasterDetails->fees_branch_id = $branch->branch_name; $FeesMasterDetails->fees_academic_term_id = $acmd->academic_term_period; $FeesMasterDetails->fees_academic_term_name_id = $acmd_name->academic_term_name; $FeesMasterDetails->fees_master_total = $total; $model->fees_payment_master_id = $fees_stru['fees_master_id']; $cash_model = new FeesPaymentTransaction('cashsearch'); $cash_model->unsetAttributes(); // clear any default values if (isset($_GET['FeesPaymentTransaction'])) { $cash_model->attributes = $_GET['FeesPaymentTransaction']; } $cheque_model = new FeesPaymentTransaction('chequesearch'); $cheque_model->unsetAttributes(); // clear any default values if (isset($_GET['FeesPaymentTransaction'])) { $cheque_model->attributes = $_GET['FeesPaymentTransaction']; } $this->render('create', array('model' => $model, 'FeesMasterDetails' => $FeesMasterDetails, 'cash_model' => $cash_model, 'cheque_model' => $cheque_model)); } }
<?php $acd = Yii::app()->db->createCommand()->select('*')->from('academic_term')->where('current_sem=1')->queryAll(); $acdterm = CHtml::listData($acd, 'academic_term_id', 'academic_term_name'); $period = array(); if ($acdterm) { $pe_data = AcademicTermPeriod::model()->findByPk($acd[0]['academic_term_period_id']); $period[$pe_data->academic_terms_period_id] = $pe_data->academic_term_period; } ?> <div class="row-right"> <?php echo $form->labelEx($model, 'student_academic_term_period_tran_id'); ?> <?php echo $form->dropDownList($model, 'student_academic_term_period_tran_id', CHtml::listData(AcademicTermPeriod::model()->findAll(), 'academic_terms_period_id', 'academic_term_period'), array('prompt' => 'Select Year')); ?> <span class="status"> </span> <?php echo $form->error($model, 'student_academic_term_period_tran_id'); ?> </div> </div> <div class="row"> <div class="row-left"> <?php echo $form->labelEx($model, 'student_academic_term_name_id'); ?> <?php echo $form->dropDownList($model, 'student_academic_term_name_id', $acdterm, array('prompt' => 'Select Semester')); ?>
<?php $i = 1; $m = 1; $k = 0; $var = 0; $out = 0; $payable = 0; $payable1 = 0; $term_id = 0; $ch_num = ""; $temp = 0; foreach ($fees as $f) { $flag = 0; $columns = array(); $columns['id'] = $m; $columns['acdm_period'] = AcademicTermPeriod::model()->findByPk($f->fees_academic_period_id)->academic_term_period; $columns['sem'] = AcademicTerm::model()->findByPk($f->fees_academic_term_id)->academic_term_name; $columns['method'] = FeesPaymentMethod::model()->findByPk($f->fees_payment_method_id)->fees_payment_method_name; if ($f->fees_payment_method_id == 1) { if ($m == 1) { $term_id = $f->fees_academic_term_id; } if ($term_id == $f->fees_academic_term_id) { $var += FeesPaymentCash::model()->findByPk($f->fees_payment_cash_cheque_id)->fees_payment_cash_amount; $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;
?> </div> <div class="portlet box blue"> <div class="portlet-title"> Semesters </div> <?php echo CHtml::link('Add New +', array('academicTerm/create'), array('class' => 'btn green')); ?> <?php $dataProvider = $model->search(); 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); ?> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'academic-term-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'afterAjaxUpdate' => 'reInstallDatepicker', 'selectionChanged' => "function(id){\n\t\twindow.location='" . Yii::app()->urlManager->createUrl('academicTerm/view', array('id' => '')) . "' + \$.fn.yiiGridView.getSelection(id);\n\t}", 'columns' => array(array('header' => 'No.', 'class' => 'IndexColumn'), 'academic_term_name', array('name' => 'academic_term_start_date', 'value' => '($data->academic_term_start_date == 0000-00-00) ? "Not Set" : date_format(new DateTime($data->academic_term_start_date), "d-m-Y")', 'filter' => $this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'attribute' => 'academic_term_start_date', 'options' => array('dateFormat' => 'dd-mm-yy', 'changeYear' => 'true', 'changeMonth' => 'true', 'showAnim' => 'slide', 'yearRange' => '1900:' . (date('Y') + 1), 'buttonImage' => Yii::app()->request->baseUrl . '/images/calendar.png'), 'htmlOptions' => array('id' => 'academic_term_start_date')), true)), array('name' => 'academic_term_end_date', 'value' => '($data->academic_term_end_date == 0000-00-00) ? "Not Set" : date_format(new DateTime($data->academic_term_end_date), "d-m-Y")', 'filter' => $this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'attribute' => 'academic_term_end_date', 'options' => array('dateFormat' => 'dd-mm-yy', 'changeYear' => 'true', 'changeMonth' => 'true', 'showAnim' => 'slide', 'yearRange' => '1900:' . (date('Y') + 1), 'buttonImage' => Yii::app()->request->baseUrl . '/images/calendar.png'), 'htmlOptions' => array('id' => 'academic_term_end_date')), true)), array('name' => 'academic_term_period_id', 'value' => 'AcademicTermPeriod::model()->findByPk($data->academic_term_period_id)->academic_term_period', 'filter' => CHtml::listData(AcademicTermPeriod::model()->findAll(), 'academic_terms_period_id', 'academic_term_period')), array('class' => 'JToggleColumn', 'name' => 'current_sem', 'filter' => array('1' => 'Yes', '0' => 'No'), 'action' => 'toggle', 'checkedButtonLabel' => Yii::app()->baseUrl . '/images/checked.png', 'uncheckedButtonLabel' => Yii::app()->baseUrl . '/images/unchecked.png', 'labeltype' => 'image', 'htmlOptions' => array('style' => 'text-align:center;min-width:60px;'))), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => ''))); ?> </div> <?php Yii::app()->clientScript->registerScript('for-date-picker', "\nfunction reInstallDatepicker(id, data){\n \$('#academic_term_start_date').datepicker({'dateFormat':'dd-mm-yy'});\n\t \$('#academic_term_end_date').datepicker({'dateFormat':'dd-mm-yy'});\n}\n"); ?>
<?php $this->breadcrumbs = array('Miscellaneous Fees Payment' => array('madmin'), 'Manage'); $this->menu = array(); Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('student-transaction-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n"); ?> <h1>Select Student</h1> <!--<p> You may optionally enter a comparison operator (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b> or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done. </p>--> <?php $dataProvider = $model->search(); $pageSize = Yii::app()->params['pageSize']; $dataProvider->getPagination()->setPageSize($pageSize); ?> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'student-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'columns' => array(array('header' => 'SN.', '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_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_transaction_branch_id', 'value' => 'Branch::model()->findByPk($data->student_transaction_branch_id)->branch_name', 'filter' => CHtml::listData(Branch::model()->findAll(array('condition' => 'branch_organization_id=' . Yii::app()->user->getState('org_id'))), 'branch_id', 'branch_name')), array('name' => 'student_transaction_quota_id', 'value' => 'Quota::model()->findByPk($data->student_transaction_quota_id)->quota_name', 'filter' => CHtml::listData(Quota::model()->findAll(array('condition' => 'quota_organization_id=' . Yii::app()->user->getState('org_id'))), 'quota_id', 'quota_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(array('condition' => 'academic_terms_period_organization_id=' . Yii::app()->user->getState('org_id'))), 'academic_terms_period_id', 'academic_term_period')), array('name' => 'student_academic_term_name_id', 'value' => 'AcademicTerm::model()->findByPk($data->student_academic_term_name_id)->academic_term_name', 'filter' => CHtml::listData(AcademicTerm::model()->findAll(array('condition' => ' academic_term_organization_id=' . Yii::app()->user->getState('org_id'))), 'academic_term_id', 'academic_term_name')), array('class' => 'MyCButtonColumn', 'template' => '{Add Fees}', 'buttons' => array('Add Fees' => array('label' => 'Pay Miscellaneous Fees', 'url' => 'Yii::app()->createUrl("miscellaneousFeesPaymentTransaction/create", array("id"=>$data->student_transaction_id))', 'imageUrl' => Yii::app()->baseUrl . '/images/add.jpeg', 'options' => array('class' => 'fees'))))), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
<?php //$p=(float)(96.3); //$a=(float)(3.7); $acdm_name = AcademicTerm::model()->findByPk($_REQUEST['sem_name_id'])->academic_term_name; $branch = Branch::model()->findByPk($_REQUEST['branch_id'])->branch_name; $acdm_period = AcademicTermPeriod::model()->findByPk($_REQUEST['sem_id'])->academic_term_period; echo '</br><h3 style="color:#3E576F">Attendence Chart of ' . $branch . '-Sem:' . $acdm_name . '(' . $acdm_period . ')</h3>'; if ($present != 0) { echo "<div id='piechart'>"; echo "<div id=\"container\" style=\"min-width: 400px; height: 400px; margin: 0 auto\"></div>"; $this->Widget('ext.highcharts.HighchartsWidget', array('options' => array('chart' => array('renderTo' => 'container', 'plotBackgroundColor' => '#D5DEE5', 'plotBorderWidth' => null, 'plotShadow' => false), 'title' => array('text' => ''), 'tooltip' => array('formatter' => 'js:function() { return "<b>"+ this.point.name +"</b>: "+ this.percentage +" %"; }'), 'plotOptions' => array('pie' => array('allowPointSelect' => true, 'cursor' => 'pointer', 'dataLabels' => array('enabled' => false, 'color' => '#000000', 'connectorColor' => '#000000', 'formatter' => 'js:function() { return "<b>"+ this.point.name +"</b>:"+this.percentage +" %"; }'))), 'series' => array(array('type' => 'pie', 'name' => 'Browser share', 'data' => array(array('Present Student', round($present, 1)), array('name' => 'Absent Student', 'y' => round($absent, 1), 'sliced' => true, 'selected' => false)))), 'exporting' => array('enabled' => false)))); /* } else { echo '<h1 align=center style=margin-top:50px;>No chart availble</h1>'; } */ ?> </div> <div id="piecharttable"> <table align=left style="width:300px;" class="table_data"> <th colspan="11" style="font-size: 18px; color: rgb(255, 255, 255);"> Attendence Table<br/> </th> <tr class="table_header"> <th>SI No.</th><th>Subject Name</th><th>Attendance %</th> </tr>
$this->breadcrumbs = array('Report', 'Student Document Search'); ?> <?php echo CHtml::link('GO BACK', Yii::app()->createUrl('report/StudentDocumentsearch')); ?> </br></br> <table border="2px" id="twoColThinTable"> <?php if ($acdm_period != 0) { ?> <tr class="row"> <td class="col1">Academic Year</td> <td class="col2"><?php echo AcademicTermPeriod::model()->findByPk($acdm_period)->academic_term_period; ?> </td> </tr> <?php } if ($sem != 0) { ?> <tr class="row"> <td class="col1">Semester </td> <td class="col2"><?php echo AcademicTerm::model()->findByPk($sem)->academic_term_name; ?> </td> </tr> <?php
<?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>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;
<?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))));
?> <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>
/** * 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; }
), 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',
?> <?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;
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 $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>
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
$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>";
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);
<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>
$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;
$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;