public function beforesave() { $student_id = $_REQUEST['student_id']; $criteria = new CDbCriteria(); $stud_trans = StudentTransaction::model()->findByPk($student_id); $criteria->condition = 'fees_student_id =' . $student_id . ' AND fees_academic_period_id=' . $stud_trans['student_academic_term_period_tran_id'] . ' AND fees_academic_term_id=' . $stud_trans['student_academic_term_name_id']; $listofid = FeesPaymentTransaction::model()->findAll($criteria); $total_fees_amount = 0; $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_organization_id = fees.fees_organization_id AND stud.student_transaction_quota_id = fees.fees_quota_id')->where('stud.student_transaction_id=:id', array(':id' => $student_id))->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' => $student_id)); foreach ($student_fees as $fees_data) { $total_fees_amount += $fees_data->fees_details_amount; } $cash_total = 0; $cheque_total = 0; $total = 0; if ($listofid != null) { foreach ($listofid as $list) { if ($list->fees_payment_method_id == 1) { $cash_total = $cash_total + FeesPaymentCash::model()->findByPk($list->fees_payment_cash_cheque_id)->fees_payment_cash_amount; } else { $amount = FeesPaymentCheque::model()->findByAttributes(array('fees_payment_cheque_status' => 0, 'fees_payment_cheque_id' => $list->fees_payment_cash_cheque_id)); $cheque_total = $cheque_total + $amount['fees_payment_cheque_amount']; } } echo "<div class='total-amount'><h4>Total Paid Fees : <b>" . ($total = $cash_total + $cheque_total . '</b></h4></div>'); //$total_fees_amount = FeesMaster::model()->findByPk($list->fees_payment_master_id)->fees_master_total; if ($this->isNewRecord) { $grand_total = $total + $this->fees_payment_cash_amount; } else { $update_total = FeesPaymentCash::model()->findByPk($_REQUEST['id'])->fees_payment_cash_amount; $grand_total = $total - $update_total + $this->fees_payment_cash_amount; } if ($total_fees_amount < $grand_total) { $this->addError('fees_payment_cash_amount', 'You can not take an advance fees for student.'); return false; } else { return true; } } else { if ($this->fees_payment_cash_amount > $total_fees_amount) { $this->addError('fees_payment_cash_amount', 'You can not take an advance fees for student.'); return false; } else { return true; } } }
<span class="output"><?php echo $acd_term->academic_term_period; ?> </span></div> </div> <div class="tablepart1"> <table> <tr> <th width="5%">Sr No.</th> <th>Particulars</th> <th>Amount(Rs.)</th> </tr> <?php $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' => $data['fees_payment_master_id'], ':student_id' => $data['fees_student_id'])); $i = 1; $total_fees_amount = 0; foreach ($student_fees as $list) { ?> <tr id="purticular"> <td class="sr-number"><?php echo $i; ?> <td id="purticular"> <?php if (!empty($list)) { echo FeesDetailsMaster::model()->findByPk($list->student_fees_master_details_id)->fees_details_master_name; ?> </td> <td><?php
/** * 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 = StudentFeesMaster::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function actionMis_report() { $model = new FeesPaymentTransaction(); $current_aca_term = AcademicTerm::model()->findAll(array('condition' => 'current_sem=1')); if ($current_aca_term) { $aca_data = array(); foreach ($current_aca_term as $aca) { $aca_data[] = $aca['academic_term_id']; $current_aca_term = $aca->academic_term_period_id; } $acam_data = implode(",", $aca_data); //$current_aca_term = $current_aca_term->academic_term_period_id; $fees_data = Yii::app()->db->createCommand()->selectDistinct('fees_master_id, fees_branch_id, fees_academic_term_id,fees_quota_id, fees_academic_term_name_id')->from('fees_master')->where('fees_academic_term_name_id in(' . $acam_data . ') order by fees_branch_id,fees_academic_term_name_id')->queryAll(); //print count($fees_data); exit; if (!empty($fees_data)) { foreach ($fees_data as $list) { $ravi_paid = 0; $ravi_total = 0; $my_total = 0; $receive_amount = 0; if (!empty($list)) { $sql = "SELECT COUNT(*) FROM student_transaction where student_transaction_quota_id=" . $list['fees_quota_id'] . " and student_transaction_branch_id = " . $list['fees_branch_id'] . " AND student_academic_term_period_tran_id = " . $list['fees_academic_term_id'] . " AND student_academic_term_name_id = " . $list['fees_academic_term_name_id']; $numStud[] = Yii::app()->db->createCommand($sql)->queryScalar(); $ravi_total = Yii::app()->db->createCommand($sql)->queryScalar(); $paid_stud = Yii::app()->db->createCommand()->selectDistinct('fees.fees_student_id, stud.student_transaction_id,stud.student_transaction_student_id,stud.student_transaction_quota_id')->from('fees_payment_transaction fees')->join('student_transaction stud', 'fees.fees_student_id = stud.student_transaction_id')->where('stud.student_transaction_branch_id = :branch_id AND stud.student_transaction_quota_id=:quota AND stud.student_academic_term_period_tran_id = :acm_id AND fees.fees_academic_term_id = :acm_name_id', array(':branch_id' => $list['fees_branch_id'], ':acm_id' => $list['fees_academic_term_id'], ':acm_name_id' => $list['fees_academic_term_name_id'], ':quota' => $list['fees_quota_id']))->queryAll(); $paid_stud_count[] = count($paid_stud); $ravi_paid = count($paid_stud); $cash_amount = 0; $cheque_amount = 0; foreach ($paid_stud as $stud_id) { $amount_data = FeesPaymentTransaction::model()->findAll('fees_student_id=' . $stud_id['student_transaction_id'] . ' and fees_academic_term_id=' . $list['fees_academic_term_name_id']); foreach ($amount_data as $cash_cheque_list) { if ($cash_cheque_list['fees_payment_method_id'] == 1) { $cash_amount += FeesPaymentCash::model()->findByPk($cash_cheque_list['fees_payment_cash_cheque_id'])->fees_payment_cash_amount; } else { $amount = FeesPaymentCheque::model()->findByAttributes(array('fees_payment_cheque_status' => 0, 'fees_payment_cheque_id' => $cash_cheque_list->fees_payment_cash_cheque_id)); $cheque_amount = $cheque_amount + $amount['fees_payment_cheque_amount']; } } } $total_receive_amount[] = $cash_amount + $cheque_amount; $unpaid_stud = Yii::app()->db->createCommand()->selectDistinct('stud.student_transaction_id,stud.student_transaction_student_id,stud.student_transaction_quota_id')->from('student_transaction stud')->where('stud.student_transaction_id NOT IN (SELECT fees_student_id FROM fees_payment_transaction) AND stud.student_transaction_branch_id = :branch_id AND stud.student_academic_term_period_tran_id = :acm_id AND stud.student_academic_term_name_id = :acm_name_id', array(':branch_id' => $list['fees_branch_id'], ':acm_id' => $list['fees_academic_term_id'], ':acm_name_id' => $list['fees_academic_term_name_id']))->queryAll(); $unpaid_stud_count[] = $ravi_total - $ravi_paid; //$unpaid_stud_count[] = count($unpaid_stud); $total_amount_data = FeesMaster::model()->findAll('fees_branch_id =' . $list['fees_branch_id'] . ' AND fees_academic_term_id =' . $list['fees_academic_term_id'] . ' AND fees_academic_term_name_id =' . $list['fees_academic_term_name_id']); $fees_stru = Yii::app()->db->createCommand()->select('fees.fees_master_id , stud.student_transaction_student_id, stud.student_academic_term_period_tran_id, stud.student_academic_term_name_id')->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_academic_term_period_tran_id = :term_p_id AND stud.student_academic_term_name_id = :term_name_id AND fees.fees_master_id = :fees_id', array(':fees_id' => $list['fees_master_id'], ':term_p_id' => $list['fees_academic_term_id'], ':term_name_id' => $list['fees_academic_term_name_id']))->queryAll(); //print_r($fees_stru); exit; $total = 0; foreach ($fees_stru as $fees_data1) { $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_data1['fees_master_id'], ':student_id' => $fees_data1['student_transaction_student_id'])); foreach ($student_fees as $fees_data1) { $total += $fees_data1->fees_details_amount; } } //print $total; exit; $total_amount[] = $total; } } if (isset($_REQUEST['MISexport'])) { Yii::import('application.extensions.tcpdf.*'); require_once 'tcpdf/tcpdf.php'; require_once 'tcpdf/config/lang/eng.php'; $html = $this->renderPartial('report_view_pdf', array('numStud' => $numStud, 'fees_data' => $fees_data, 'paid_stud_count' => $paid_stud_count, 'unpaid_stud_count' => $unpaid_stud_count, 'total_amount' => $total_amount, 'total_receive_amount' => $total_receive_amount), true); ob_clean(); $pdf = new TCPDF(); $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor(Yii::app()->name); $pdf->SetTitle('MIS Report'); $pdf->SetSubject('MIS Report'); $pdf->SetKeywords('example, text, report'); $pdf->SetHeaderData('', 0, "Fees Summary", ''); //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".Yii::app()->name, ""); $pdf->setHeaderFont(array('helvetica', '', 8)); $pdf->setFooterFont(array('helvetica', '', 6)); $pdf->SetMargins(15, 18, 15); $pdf->SetHeaderMargin(5); $pdf->SetFooterMargin(10); $pdf->SetAutoPageBreak(TRUE, 15); $pdf->SetFont('dejavusans', '', 7); $resolution = array(150, 150); $pdf->AddPage('P', $resolution); $pdf->writeHTML($html, true, false, true, false, ''); $pdf->LastPage(); $pdf->Output("MIS.pdf", "I"); } if (isset($_REQUEST['MISexportexcel'])) { Yii::app()->request->sendFile(date('YmdHis') . '.xlsx', $this->renderPartial('report_view_pdf', array('numStud' => $numStud, 'fees_data' => $fees_data, 'paid_stud_count' => $paid_stud_count, 'unpaid_stud_count' => $unpaid_stud_count, 'total_amount' => $total_amount, 'total_receive_amount' => $total_receive_amount), true)); } $this->render('create_report', array('numStud' => $numStud, 'fees_data' => $fees_data, 'paid_stud_count' => $paid_stud_count, 'unpaid_stud_count' => $unpaid_stud_count, 'total_amount' => $total_amount, 'total_receive_amount' => $total_receive_amount)); } else { $this->render('error_msg', array()); } } else { echo "<font color=\"red\"><center>Data Not Available</center></font>"; } }
?> </span></div> </div> <div class="tablepart1"> <table> <tr> <th width="5%">Sr No.</th> <th>Particulars</th> <th>Amount(Rs.)</th> </tr> <?php $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_payment->fees_payment_master_id, ':student_id' => $model->student_transaction_id)); $i = 1; $total_fees_amount = 0; foreach ($student_fees as $list) { ?> <tr id="purticular"> <td class="sr-number"><?php echo $i; ?> <td id="purticular"> <?php if (!empty($list)) { echo FeesDetailsMaster::model()->findByPk($list->student_fees_master_details_id)->fees_details_master_name; ?> </td> <td><?php
public function actionAssignFeesStudent() { $student_fees_master = new StudentFeesMaster(); $org_id = Yii::app()->user->getState('org_id'); $acdm_terms = AcademicTerm::model()->findAll('current_sem=1 and academic_term_organization_id=' . Yii::app()->user->getState('org_id')); $data = array(); foreach ($acdm_terms as $list) { $data[] = $list['academic_term_id']; } $result = implode(",", $data); $data = FeesMaster::model()->findAll('fees_academic_term_name_id in (' . $result . ')'); foreach ($data as $list) { $student_data = StudentTransaction::model()->findAll('student_transaction_quota_id = :quota_id AND student_academic_term_period_tran_id = :acdm_term_p AND student_academic_term_name_id = :acmd_term AND student_transaction_branch_id = :branch_id', array(':quota_id' => $list->fees_quota_id, ':acdm_term_p' => $list->fees_academic_term_id, ':acmd_term' => $list->fees_academic_term_name_id, ':branch_id' => $list->fees_branch_id)); $fees_data = FeesMasterTransaction::model()->findAll('fees_master_id = ' . $list->fees_master_id); foreach ($fees_data as $f) { foreach ($student_data as $st) { $fees_details_data = FeesDetailsTable::model()->findByPk($f->fees_desc_id); $stud_fees_data = StudentFeesMaster::model()->findByAttributes(array('student_fees_master_student_transaction_id' => $st->student_transaction_id, 'fees_master_table_id' => $list->fees_master_id, 'student_fees_master_details_id' => $fees_details_data->fees_details_name)); if ($stud_fees_data) { StudentFeesMaster::model()->updateAll(array('fees_details_amount' => $fees_details_data->fees_details_amount), 'student_fees_master_id=' . $stud_fees_data['student_fees_master_id']); } else { $student_fees_master->setIsNewRecord(true); $student_fees_master->student_fees_master_id = null; $student_fees_master->student_fees_master_student_transaction_id = $st->student_transaction_id; // $fees_details_data = FeesDetailsTable::model()->findByPk($f->fees_desc_id); $student_fees_master->fees_master_table_id = $list->fees_master_id; $student_fees_master->student_fees_master_details_id = $fees_details_data->fees_details_name; $student_fees_master->fees_details_amount = $fees_details_data->fees_details_amount; $student_fees_master->student_fees_master_org_id = $org_id; $student_fees_master->student_fees_master_created_by = Yii::app()->user->id; $student_fees_master->student_fees_master_creation_date = new CDbExpression('NOW()'); $student_fees_master->save(); } } } } $this->redirect(array('/studentFeesMaster/admin')); }