1#@!#!123s

: / home / schoolcampuserp / kmcs.in / erp / application / controllers / admin /
Filename : Transaction.php
back
<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Transaction extends Admin_Controller {

    function __construct() {
        parent::__construct();
        $this->sch_setting_detail = $this->setting_model->getSetting();
        $this->load->model('feesessiongroup_model');
        $this->load->model('miscellaneous_model');
    }

    function searchtransaction() {

        $this->session->set_userdata('top_menu', 'Reports');
        $this->session->set_userdata('sub_menu', 'Reports/finance');

        $data['title'] = 'Search Expense';
        $data['searchlist'] = $this->customlib->get_searchtype();
        $data['search_type'] = $search_type = '';


        $search = $this->input->post('search_type');


        if (isset($_POST['search_type']) && $_POST['search_type'] != '') {

            $dates = $this->customlib->get_betweendate($_POST['search_type']);
            $data['search_type'] = $_POST['search_type'];
        } else {

            $dates = $this->customlib->get_betweendate('this_year');
            $data['search_type'] = $search_type = 'this_year';
        }

        $dateformat = $this->customlib->getSchoolDateFormat();

        $date_from = $dates['from_date'];
        $date_to = $dates['to_date'];

        $data['collection_title'] = $this->lang->line('collection') . " " . $this->lang->line('report') . " " . $this->lang->line('from') . " " . date($this->customlib->getSchoolDateFormat(), strtotime($date_from)) . " To " . date($this->customlib->getSchoolDateFormat(), strtotime($date_to));
        $data['income_title'] = $this->lang->line('income') . " " . $this->lang->line('report') . " " . $this->lang->line('from') . " " . date($this->customlib->getSchoolDateFormat(), strtotime($date_from)) . " To " . date($this->customlib->getSchoolDateFormat(), strtotime($date_to));
        $data['expense_title'] = $this->lang->line('expense') . " " . $this->lang->line('report') . " " . $this->lang->line('from') . " " . date($this->customlib->getSchoolDateFormat(), strtotime($date_from)) . " To " . date($this->customlib->getSchoolDateFormat(), strtotime($date_to));
        $data['payroll_title'] = $this->lang->line('payroll') . " " . $this->lang->line('report') . " " . $this->lang->line('from') . " " . date($this->customlib->getSchoolDateFormat(), strtotime($date_from)) . " To " . date($this->customlib->getSchoolDateFormat(), strtotime($date_to));
        $date_from = date('Y-m-d', strtotime($date_from));
        $date_to = date('Y-m-d', strtotime($date_to));
        $expenseList = $this->expense_model->search("", $date_from, $date_to);

        $result = $this->payroll_model->getbetweenpayrollReport($date_from, $date_to);

        $incomeList = $this->income_model->search("", $date_from, $date_to);
        $feeList = $this->studentfeemaster_model->getFeeBetweenDate($date_from, $date_to);
        $data['expenseList'] = $expenseList;
        $data['incomeList'] = $incomeList;
        $data['feeList'] = $feeList;
        $data['payrollList'] = $result;



        $this->load->view('layout/header', $data);
        $this->load->view('admin/transaction/searchtransaction', $data);
        $this->load->view('layout/footer', $data);
    }

    function studentacademicreport() {

        if (!$this->rbac->hasPrivilege('balance_fees_report', 'can_view')) {
            access_denied();
        }

        $this->session->set_userdata('top_menu', 'Reports');
        $this->session->set_userdata('sub_menu', 'Reports/finance');
        $this->session->set_userdata('subsub_menu', 'Reports/finance/studentacademicreport');
        $data['title'] = 'student fee';
        $data['title'] = 'student fee';
        $class = $this->class_model->get();
       $feemasterList = $this->feesessiongroup_model->getFeesByGroup();
        // $data['feegroupList'] = $feegroup;
        $miscellaneous = $this->miscellaneous_model->get();
        // $data['miscellaneous'] = $miscellaneous;
        // print_r($feegroupList);
// echo "<br><br>";
// print_r($miscellaneous);
// Initialize an empty array to store the names
$fees_head = [];

// Loop through each sub-array and add the 'name' to the $fees_head array
foreach ($feemasterList as $feegroup) {
    if($feegroup->group_name!="TUITION FEE"){
    $fees_head[] = $feegroup->group_name;
    }
}
$fees_head[]="Transport Fee";
$fees_head[]="Hostel Fee";
foreach ($miscellaneous as $item) {
    $fees_head[] = $item["miscellaneous_title"];
}
$data['fees_head'] = $fees_head;
        $data['sch_setting'] = $this->sch_setting_detail;
        $data['adm_auto_insert'] = $this->sch_setting_detail->adm_auto_insert;
        $data['classlist'] = $class;
        $data['searchlist'] = $this->customlib->get_searchtype();
        if (isset($_POST['search_type']) && $_POST['search_type'] != '') {
            $dates               = $this->customlib->get_betweendate($_POST['search_type']);
            $data['search_type'] = $_POST['search_type'];
        } else {
            $dates               = $this->customlib->get_betweendate('session');
            $data['search_type'] = '';
        }
        $class_id = $this->input->post('class_id');
        $section_id = $this->input->post('section_id');
        $fees_head_value = $this->input->post('fees_head_name');
        $feetype = $this->input->post('feetype');
        $feetype_arr = $this->input->post('feetype_arr');
        
        
       
       $from_date = $this->input->post('from_date');
       $to_date = $this->input->post('to_date');
       
         $start_date          = date('Y-m-d', strtotime($from_date));
        $end_date            = date('Y-m-d', strtotime($to_date));
     
        if ($this->input->post('from_date') && $this->input->post('to_date')) {
    
            $data['start_date'] = date('Y-m-d', strtotime($from_date));
            $data['end_date'] = date('Y-m-d', strtotime($to_date));
        } else {
               
            $data['start_date'] = $dates['from_date'];
            $data['end_date'] = $dates['to_date'];
        }
        
       $this->form_validation->set_rules('from_date', $this->lang->line('from') . " " . $this->lang->line('date'), 'trim|required|xss_clean');
    $this->form_validation->set_rules('to_date', $this->lang->line('to') . " " . $this->lang->line('date'), 'trim|required|xss_clean');
    
       // $this->form_validation->set_rules('search_type', $this->lang->line('search') . " " . $this->lang->line('type'), 'trim|required|xss_clean');

        $data['section_list'] = $this->section_model->getClassBySection($this->input->post('class_id'));
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|xss_clean'); //|required
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|xss_clean'); //|required
        $this->form_validation->set_rules('fees_head_name', "Fees Head", 'trim|xss_clean'); //|required



        if ($this->form_validation->run() == false) {
            $data['student_due_fee'] = array();
            $data['resultarray'] = array();

            $data['class_id'] = "";
            $data['section_id'] = "";
            //$data['fees_head_value'] = "";
            $data['feetype'] = "";
            $data['feetype_arr'] = array();
        }
        else {
                         
            $student_Array = array(); 

            $section = array();

            $classlist = $this->student_model->getAllClassSection($class_id, $section_id);
// print_r($classlist);
// die();
            foreach ($classlist as $key => $value) {
                $classid = $value['class_id'];
                $sectionid = $value['section_id'];

                $studentlist = $this->student_model->reportClassSection($classid, $sectionid);
// print_r($studentlist);
// die();
                $student_Array = array();
                if (!empty($studentlist)) {
                    foreach ($studentlist as $key => $eachstudent) {
                        $obj = new stdClass();
                        $obj->id = $eachstudent['id'];
                        $obj->name = $this->customlib->getFullName($eachstudent['firstname'],$eachstudent['middlename'],$eachstudent['lastname'],$this->sch_setting_detail->middlename,$this->sch_setting_detail->lastname);
                        $obj->class = $eachstudent['class'];
                        $obj->section = $eachstudent['section'];
                        $obj->admission_no = $eachstudent['admission_no'];
                        $obj->roll_no = $eachstudent['roll_no'];
                        $obj->mobileno = $eachstudent['mobileno'];
                        $obj->father_name = $eachstudent['father_name'];
                        $obj->fee_name="";
                        $student_session_id = $eachstudent['student_session_id'];
                        $student_total_fees = $this->studentfeemaster_model->getStudentFees($student_session_id,$start_date, $end_date);
// print_r($student_total_fees);
// exit();
                        if (!empty($student_total_fees)) {
                            $totalfee = 0;
                            $deposit = 0;
                            $discount = 0;
                            $balance = 0;
                            $fine = 0;
                            $total_pay_fine=0;
                            $total_discount=0;
                            $total_fine=0;
                            $total_deposit=0;
                            $total_balance=0;
                            //$fee_name="";
                            foreach ($student_total_fees as $student_total_fees_key => $student_total_fees_value) {
                                
//echo $student_total_fees_value->student_session_id."<br>";
    $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees(intval($student_total_fees_value->student_session_id));
    $miscellaneousfees_2    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_total_fees_value->student_session_id));   //$New_student_session_id[0]

    $newArray    = $this->studentfeemaster_model->getdate_transport_fee(intval($student_total_fees_value->student_session_id));//$routefees
    // print_r($newArray);
    // die();
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet(intval($student_total_fees_value->student_session_id));
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee(intval($student_total_fees_value->student_session_id));// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet(intval($student_total_fees_value->student_session_id));
    
    $student_feediscount      = $this->feediscount_model->getStudentFeesDiscount(intval($student_total_fees_value->student_session_id));
    // print_r($student_feediscount); //amount
    // exit();
    //   print_r($miscellaneousfees);
    //   exit();
     $MFfare=0;
foreach ($miscellaneousfees as $mf_key => $mf_value) {
    //echo $mf_key."=>".$mf_value."<br>";
    //echo $mf_value['concatenated_miscellaneous_months']."<br>";
    $cmm=explode("=",$mf_value['concatenated_miscellaneous_months']);
    $cmf=explode("=",$mf_value['concatenated_miscellaneous_fees']);
    
     $MFfare=$mf_value['MFfare'];
}
//echo $MFfare."<br>";
                                if (!empty($student_total_fees_value->fees)) {
                                   // $months_count=1;
                                   $result=1;//(count($student_total_fees_value->fees)>=3)?!empty($miscellaneousfees):1;
                                   if($result){
                                       //echo $fees_head_value.'=='.var_export(empty($fees_head_value), true)."<br>";
           
                                       if(empty($fees_head_value)){
                                    foreach ($student_total_fees_value->fees as $each_fee_key => $each_fee_value) {
                                        //print_r($each_fee_value);
                                        // $totalfee = $totalfee + $each_fee_value->amount;
                                        $due_date = $each_fee_value->due_date;
                                        $curr_date = date("Y-m-d");
                                        $pay_deposit=0;
                                            $pay_fine=0;
                                            $pay_discount=0;
                                            $amount_detail = json_decode($each_fee_value->amount_detail);

                                        if (!empty($amount_detail)) { //is_object($amount_detail) 
                                            
                                            foreach ($amount_detail as $amount_detail_key => $amount_detail_value) {
                                                
                                                $deposit = $deposit + $amount_detail_value->amount;
                                                $fine = $fine + $amount_detail_value->amount_fine;
                                                $discount = intval($discount) + intval($amount_detail_value->amount_discount);
                                                
                                                 $pay_deposit = $pay_deposit + $amount_detail_value->amount;
                                                $pay_fine = $pay_fine + $amount_detail_value->amount_fine;
                                                $pay_discount = intval($pay_discount) + intval($amount_detail_value->amount_discount);
                                                
                                            }
                                            //  if($pay_fine>0){
                                            //     $each_fee_value->fine_amount=$pay_fine;
                                            // }
                                            
                                        }
                                        if($each_fee_value->name=="Balance Master"){ 
     if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        if($pay_fine>0)   {
        $total_pay_fine+=$pay_fine;
        }
    $totalfee = $totalfee + $each_fee_value->amount;
    $total_discount+=$pay_discount;
    if(strtotime($due_date)>strtotime($curr_date)){
                                $total_fine += 0;
                            }
                            else {
                                  $total_fine+=$each_fee_value->fine_amount;
                            }
    
     }
    
}elseif($each_fee_value->thf==1){//count($student_total_fees_value->fees)>=3
    
    $f_months=0;
        if(!empty($cmm)){
        for($i=0;$i<count($cmm);$i++){
            
            $new_cmm=explode(",",$cmm[$i]);
            if(in_array(explode(' ', $each_fee_value->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            }
        }
        }
         if(!empty($newArray)){
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $each_fee_value->code)[0], $newArray[$i])){
                 $f_months+=$route_fees[$i]['fare'];
             }
         }
        }
        if(!empty($newArray_hostel)){
         for($i=0;$i<count($newArray_hostel);$i++){
             if(in_array(explode(' ', $each_fee_value->code)[0], $newArray_hostel[$i])){
                 $f_months+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
        }
        //$totalfee = $totalfee + $f_months;
        $each_fee_value->amount=$f_months; 
        
        
    //if($fee_paid+$fee_discount+$fee_fine==($each_fee_value->amount+$each_fee_value->fine_amount)){
    //$each_fee_value->fine_amount $pay_fine
    //24029
       
      if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         
         //echo intval($student_total_fees_value->student_session_id).'=='.$pay_deposit."<br>";
        //         if($pay_deposit>0)   {                         
        //   $deposit=$pay_deposit;
        //         }
        
       
            if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        
         $student_feediscount_new=0;
        foreach ($student_feediscount as $item) {
     
     $student_feediscount_new=$student_feediscount_new+$item['amount'];
}
         

        //$months_count=$months_count+1;
        // if(empty($amount_detail)){
        // $pay_discount=$student_feediscount_new;
        // }
        if(empty($amount_detail)){ //$pay_discount==0 || 
        $total_discount+=$student_feediscount_new;
        }else{
            $total_discount+=$pay_discount;
        }
         
        
        
    //     if (empty($each_fee_value->amount_detail) &&  ($each_fee_value->due_date != "0000-00-00" && $each_fee_value->due_date != null) && (strtotime($each_fee_value->due_date) < strtotime(date('Y-m-d')))) {

       
    //   $totalfee = $totalfee + intval($each_fee_value->amount);//+$each_fee_value->fine_amount;
        
    //      }
    //     else
        if(!empty($each_fee_value->amount_detail) &&  ($each_fee_value->due_date != "0000-00-00" && $each_fee_value->due_date != null) && (strtotime($each_fee_value->due_date) < strtotime(date('Y-m-d')))) {
$each_fee_value->fine_amount=$pay_fine;
$total_pay_fine+=$pay_fine;
            //$totalfee = $totalfee +intval($each_fee_value->amount);//+$pay_fine;
         }
        //  else{
        //      $totalfee = $totalfee + intval($each_fee_value->amount);
        //  }
         //$total_balance=$totalfee-($pay_deposit+$pay_fine+$pay_discount);
         $totalfee = $totalfee + intval($each_fee_value->amount);
           if(strtotime($due_date)>strtotime($curr_date)){
                                $total_fine += 0;
                            }
                            else {
                                  $total_fine+=$each_fee_value->fine_amount;
                            }
    
//          if($each_fee_value->student_session_id==43){
//           echo $each_fee_value->amount.'=='.$f_months.'=='.(($each_fee_value->amount) - ($pay_deposit+$pay_discount)).'=='.explode(' ', $each_fee_value->code)[0].'=='.$totalfee."==".($pay_deposit+$pay_discount)."<br>";
// }
         
        //  if($each_fee_value->student_session_id==43){
        //      echo explode(' ', $each_fee_value->code)[0].'==>'.$each_fee_value->amount.'=='.$each_fee_value->fine_amount.'==>'.($pay_deposit+$pay_fine+$pay_discount).'<br>';
        //  echo explode(' ', $each_fee_value->code)[0].'==>'.$totalfee.'=='.$total_fine.'==>'.($pay_deposit+$pay_fine+$pay_discount).'<br>';
         
             
        //  }
    }

}
else{
    // $total_amount          = $total_amount + $fee_value->amount;
    //  $feetype_balance       = ($fee_value->amount) - ($fee_paid + $fee_discount);
     if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        if($pay_fine>0)   {
        $total_pay_fine+=$pay_fine;
        }
    $totalfee = $totalfee + $each_fee_value->amount;
    $total_discount+=$pay_discount;
  if(strtotime($due_date)>strtotime($curr_date)){
                                $total_fine += 0;
                            }
                            else {
                                  $total_fine+=$each_fee_value->fine_amount;
                            }
    
}
}


                                        
                                        
                                       // echo explode(' ', $each_fee_value->code)[0].'=='.(($each_fee_value->amount+$each_fee_value->fine_amount) - ($pay_deposit+$pay_fine+$pay_discount))."<br>";//."<br>";
                                        if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){//+$each_fee_value->fine_amount  $pay_fine
                                if(!empty($obj->fee_name)){
                                    $obj->fee_name.=" , ".explode(' ', $each_fee_value->code)[0];
                                }else{
                                    $obj->fee_name=explode(' ', $each_fee_value->code)[0];
                                }
                            }
                                    }
                                       }else{
                                           
                                           foreach ($student_total_fees_value->fees as $each_fee_key => $each_fee_value) {
                                        //print_r($each_fee_value);
                                        // $totalfee = $totalfee + $each_fee_value->amount;
                                        $pay_deposit=0;
                                            $pay_fine=0;
                                            $pay_discount=0;
                                            $fee_str='';
                                            $amount_detail = json_decode($each_fee_value->amount_detail);

                                        if (!empty($amount_detail)) { //is_object($amount_detail) 
                                            
                                            foreach ($amount_detail as $amount_detail_key => $amount_detail_value) {
                                                // Check if the nested value is also an object or array
            //print_r($amount_detail_value)."<br><br>";
                                                
                                                foreach ($amount_detail_value as $innerKey => $innerValue) {
                                                    if (is_object($innerValue) || is_array($innerValue)) {
                                                    // echo $innerKey."<br>";
                                                    // print_r($innerValue)."<br><br>";
                                                    //if($fees_head_value==$innerKey){
                                                  //  echo in_array($innerKey, $fees_head_value)."<br>";
                                                        if(in_array($innerKey, $fees_head_value)){
                                                            if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','.$innerKey;
                                                                
                                                            }else{
                                                                $fee_str=$innerKey;
                                                                
                                                            }
                                                            
                                                        //foreach ($innerValue as $innerKey_new => $innerValue_new) {
                                                            //echo $innerKey_new.'=='.$innerValue_new."<br>";
                                                            //echo $innerValue_new;
                                                            $deposit = $deposit + $innerValue->amount;//$innerValue_new;
                                                            $pay_deposit = $pay_deposit + $innerValue->amount;//$innerValue_new;
                                                        //}
                                                    }
                                                }
            }
                                                //$deposit = $deposit + $amount_detail_value->amount;
                                                //$fine = $fine + $amount_detail_value->amount_fine;
                                                //$discount = intval($discount) + intval($amount_detail_value->amount_discount);
                                                
                                                 //$pay_deposit = $pay_deposit + $amount_detail_value->amount;
                                               // $pay_fine = $pay_fine + $amount_detail_value->amount_fine;
                                                //$pay_discount = intval($pay_discount) + intval($amount_detail_value->amount_discount);
                                                
                                            }
                                            //exit();
                                            //  if($pay_fine>0){
                                            //     $each_fee_value->fine_amount=$pay_fine;
                                            // }
                                            
                                        }
                                        if($each_fee_value->name=="Balance Master"){
                                            // if($fees_head_value==$each_fee_value->name){
                                            if(in_array($each_fee_value->name, (array)$fees_head_value)){
                                                if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','.$each_fee_value->name;
                                                                
                                                            }else{
                                                                $fee_str=$each_fee_value->name;
                                                                
                                                            }
     if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        // if($pay_fine>0)   {
        // $total_pay_fine+=$pay_fine;
        // }
    $totalfee = $totalfee + $each_fee_value->amount;
    // $total_discount+=$pay_discount;
    // $total_fine+=$each_fee_value->fine_amount;
     }
                                            }
    
}
elseif($each_fee_value->thf==1){//count($student_total_fees_value->fees)>=3
    if(!empty($miscellaneousfees_2)){
foreach ($miscellaneousfees_2 as $index => $object) {
    // print_r($object);
    // echo "<br>";
    //foreach ($feearray as $fee_key => $fee_value) {
        // if($fee_value->fee_group_count>=3 && !empty($miscellaneousfees)){
            $fv_name=explode(" ",$each_fee_value->code);
        //print_r($fv_name);
        $monthMapping =[ 1 => 'JAN', 2 => 'FEB', 3 => 'MARCH', 4 => 'APRIL', 5 => 'MAY',6 => 'JUNE',7 => 'JULY',8 => 'AUG',9 => 'SEP',10 => 'OCT',11 => 'NOV',12 => 'DEC'];
        //$months_count = array_search($fv_name[0], $monthMapping);
//$object->miscellaneous_months

  $cmm=explode("=",$object->concatenated_miscellaneous_months);//,//miscellaneous_months
  $miscellaneous_title=explode("=",$object->concatenated_main_miscellaneous_titles);//concatenated_miscellaneous_titles
  $miscellaneous_fees=explode("=",$object->concatenated_miscellaneous_fees);
  //concatenated_miscellaneous_fees
   //print_r($cmm);
   
//   echo "<br>".$months_count."<br>";
    //$cmf=explode("=",$object->miscellaneous_months);
     //$f_months=0;
     //$temp=0;
     //echo count($cmm)."<br>";
        for($i=0;$i<count($cmm);$i++){
            //$jtemp=0;
            $new_cmm=explode(",",$cmm[$i]);
            // echo "<br>$fv_name[0]<br>";
            // print_r($new_cmm);
            
           // echo $months_count.'=>'.$new_cmm.'=>'.in_array($months_count,$new_cmm)."<br>";
            if(in_array($fv_name[0],$new_cmm)){//&& $feeList->thf==1
                //$f_months=1;//$f_months+$cmf[$i];
                $miscellaneous_title_variable = "miscellaneous_title_" . ($i + 1);//$index
    $MFfare_variable = "MFfare_" . ($i + 1);//$index
    //$MFfare_variable_count = "array_" . $miscellaneous_title[$i].'_'.$i;//$object->miscellaneous_title;//count($cmm);
    
     //${$MFfare_variable_count.$object->miscellaneous_title};
    //  if(isset(${$MFfare_variable_count})){
    //  ${$MFfare_variable_count}= ${$MFfare_variable_count}+1;
    //  }else{
    //      ${$MFfare_variable_count}=${$MFfare_variable_count}+1;
    //  }
  
    // Assign values to variables
    ${$miscellaneous_title_variable} = $miscellaneous_title[$i];//$object->miscellaneous_title;
   ${$MFfare_variable} =$miscellaneous_fees[$i] ;//*  ${$MFfare_variable_count};
    //echo ${$MFfare_variable_count}."<br>";
                
            }
        }
        }
   
    
}

    $f_months=0;
        if(!empty($cmm)){
            
        for($i=0;$i<count($cmm);$i++){
            
            
             $miscellaneous_title_variable = "miscellaneous_title_" . ($i + 1);
$MFfare_variable = "MFfare_" . ($i + 1);//$index
    // if($eachstudent['admission_no']==123456){
    //  echo $fees_head_value.'=='.${$miscellaneous_title_variable}."<br>";
    //  }
 if(${$MFfare_variable}>0){
     
             //if($fees_head_value==${$miscellaneous_title_variable}){
                 if(in_array(${$miscellaneous_title_variable}, (array)$fees_head_value)){
                     if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','.${$miscellaneous_title_variable};
                                                                
                                                            }else{
                                                                $fee_str=${$miscellaneous_title_variable};
                                                                
                                                            }
                 $new_cmm=explode(",",$cmm[$i]);
            if(in_array(explode(' ', $each_fee_value->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            }
             }
}
        }
        }
         if(!empty($newArray)){
            // if($fees_head_value=="Transport Fee"){
            if(in_array("Transport Fee", (array)$fees_head_value)){
                  if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','."Transport Fee" ;
                                                                
                                                            }else{
                                                                $fee_str="Transport Fee";
                                                                
                                                            }
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $each_fee_value->code)[0], $newArray[$i])){
                 $f_months+=$route_fees[$i]['fare'];
                 $new_t_f+=$route_fees[$i]['fare'];
             }
         }
         }
        }
        if(!empty($newArray_hostel)){
            // if($fees_head_value=="Hostel Fee"){
            if(in_array("Hostel Fee", (array)$fees_head_value)){
                  if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','."Hostel Fee";
                                                                
                                                            }else{
                                                                $fee_str="Hostel Fee";
                                                                
                                                            }
         for($i=0;$i<count($newArray_hostel);$i++){
             if(in_array(explode(' ', $each_fee_value->code)[0], $newArray_hostel[$i])){
                 $f_months+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
            }
        }
        $totalfee = $totalfee + $f_months;
        
        $each_fee_value->amount=$f_months; 
        
        
    //if($fee_paid+$fee_discount+$fee_fine==($each_fee_value->amount+$each_fee_value->fine_amount)){
    //$each_fee_value->fine_amount $pay_fine
    //24029
    //   if($eachstudent['admission_no']==123456){
    //         echo (($each_fee_value->amount) - ($pay_deposit+$pay_discount))."<br>";
    //     }
      if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         
         //echo intval($student_total_fees_value->student_session_id).'=='.$pay_deposit."<br>";
        //         if($pay_deposit>0)   {                         
        //   $deposit=$pay_deposit;
        //         }
        
       
            if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        
//          $student_feediscount_new=0;
//         foreach ($student_feediscount as $item) {
     
//      $student_feediscount_new=$student_feediscount_new+$item['amount'];
// }
         

        //$months_count=$months_count+1;
        // if(empty($amount_detail)){
        // $pay_discount=$student_feediscount_new;
        // }
        if(empty($amount_detail)){ //$pay_discount==0 || 
        //$total_discount+=$student_feediscount_new;
        }else{
            //$total_discount+=$pay_discount;
        }
         
        
        
    //     if (empty($each_fee_value->amount_detail) &&  ($each_fee_value->due_date != "0000-00-00" && $each_fee_value->due_date != null) && (strtotime($each_fee_value->due_date) < strtotime(date('Y-m-d')))) {

       
    //   $totalfee = $totalfee + intval($each_fee_value->amount);//+$each_fee_value->fine_amount;
        
    //      }
    //     else
        if(!empty($each_fee_value->amount_detail) &&  ($each_fee_value->due_date != "0000-00-00" && $each_fee_value->due_date != null) && (strtotime($each_fee_value->due_date) < strtotime(date('Y-m-d')))) {
// $each_fee_value->fine_amount=$pay_fine;
// $total_pay_fine+=$pay_fine;
            //$totalfee = $totalfee +intval($each_fee_value->amount);//+$pay_fine;
         }
        //  else{
        //      $totalfee = $totalfee + intval($each_fee_value->amount);
        //  }
         //$total_balance=$totalfee-($pay_deposit+$pay_fine+$pay_discount);
         //$totalfee = $totalfee + intval($each_fee_value->amount);
        // $total_fine+=$each_fee_value->fine_amount;
//          if($each_fee_value->student_session_id==43){
//           echo $each_fee_value->amount.'=='.$f_months.'=='.(($each_fee_value->amount) - ($pay_deposit+$pay_discount)).'=='.explode(' ', $each_fee_value->code)[0].'=='.$totalfee."==".($pay_deposit+$pay_discount)."<br>";
// }
         
        //  if($each_fee_value->student_session_id==43){
        //      echo explode(' ', $each_fee_value->code)[0].'==>'.$each_fee_value->amount.'=='.$each_fee_value->fine_amount.'==>'.($pay_deposit+$pay_fine+$pay_discount).'<br>';
        //  echo explode(' ', $each_fee_value->code)[0].'==>'.$totalfee.'=='.$total_fine.'==>'.($pay_deposit+$pay_fine+$pay_discount).'<br>';
         
             
        //  }
    }
    else{
         $total_deposit+=$pay_deposit;
    }

}
else{
    //  if($fees_head_value==$each_fee_value->name){
    if(in_array($each_fee_value->name, (array)$fees_head_value)){
          if(!empty($fee_str)){
                                                                //!empty($fee_str)
                                                                $fee_str=$fee_str.','.$each_fee_value->name;
                                                                
                                                            }else{
                                                                $fee_str=$each_fee_value->name;
                                                                
                                                            }
    // $total_amount          = $total_amount + $fee_value->amount;
    //  $feetype_balance       = ($fee_value->amount) - ($fee_paid + $fee_discount);
     if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){
         if($pay_deposit>0)   {
        $total_deposit+=$pay_deposit;
        }
        // if($pay_fine>0)   {
        // $total_pay_fine+=$pay_fine;
        // }
    $totalfee = $totalfee + $each_fee_value->amount;
   // $total_discount+=$pay_discount;
//$total_fine+=$each_fee_value->fine_amount;
}
}
}


                                        
                                        
                                       // echo explode(' ', $each_fee_value->code)[0].'=='.(($each_fee_value->amount+$each_fee_value->fine_amount) - ($pay_deposit+$pay_fine+$pay_discount))."<br>";//."<br>";
                                        if((($each_fee_value->amount) - ($pay_deposit+$pay_discount))!=0){//+$each_fee_value->fine_amount  $pay_fine
                                // if(!empty($obj->fee_name)){
                                //     $obj->fee_name.=" , ".explode(' ', $each_fee_value->code)[0];
                                // }else{
                                //     $obj->fee_name=explode(' ', $each_fee_value->code)[0];
                                // }
                            $obj->fee_name=$fee_str;//$fees_head_value;
                            }else{
                                $obj->fee_name=$fee_str;
                            }
                                    }
                                     
                                           
                                       }
                                   }
                                }
                            }
                            // if($eachstudent['admission_no']==123456){//24029
                            //     echo "24029 TotalFee ==> ".$totalfee ."-Dis ".$pay_discount+(($total_discount>=0)?$total_discount:0).' TF==>'.$total_fine.' TD==>'.$total_deposit." total_deposit==> ".$total_deposit."<br>";
                            // }


                            $obj->totalfee = $totalfee;
                            $obj->payment_mode = "N/A";
                            $obj->deposit = $total_deposit;//$deposit;
                            $obj->fine = $total_fine;//$fine;
                            $obj->discount = $total_discount;//$pay_discount +(($total_discount>=0)?$total_discount:0);//$discount//$total_discount;//$discount;
                            $obj->balance = ($totalfee+$total_fine) - ($total_discount+$total_pay_fine+$total_deposit); //$pay_discount+(($total_discount>=0)?$total_discount:0)  //$deposit//($deposit + $discount);
                            //echo intval($student_total_fees_value->student_session_id).'=='.$totalfee .'-'.($pay_discount+(($total_discount>=0)?$total_discount:0)+$total_fine+$total_deposit)."<br>";
                        } 
                        else {

                            $obj->totalfee = 0;
                            $obj->payment_mode = 0;
                            $obj->deposit = 0;
                            $obj->fine = $total_fine;//0;
                            $obj->balance = ($total_discount+$total_fine);//0;
                            $obj->discount = $total_discount;//0;
                        }

                        if ($obj->balance > 0) {
                            //echo $obj->balance."<br><br>";
                            $student_Array[] = $obj;
                        }
                    }
                }

                $classlistdata[$value['class_id']][] = array('class_name' => $value['class'], 'section' => $value['section_id'], 'section_name' => $value['section'], 'result' => $student_Array);
        //   print_r($classlistdata);
        //   echo "<br><br>";
            }

            //  print_r($student_Array);
            //  die();

            $data['student_due_fee'] = $student_Array;
            $data['resultarray'] = $classlistdata;

            $data['class_id'] = $class_id;
            $data['section_id'] = $section_id;
            $data['fees_head_value'] = $fees_head_value;
            $data['feetype'] = $feetype;
            $data['feetype_arr'] = $feetype_arr;
        }

        $this->load->view('layout/header', $data);
        $this->load->view('admin/transaction/studentAcademicReport', $data);
        $this->load->view('layout/footer', $data);
    }

}

?>