1#@!#!123s

: / home / schoolcampuserp / ssvschool.in / application / controllers /
Filename : Studentfee.php
back
<?php

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

class Studentfee extends Admin_Controller
{

    public function __construct()
    {
        parent::__construct();
        //$this->load->library('cache');
            // Load the profiler library
            $this->load->library('profiler');
            $this->load->model('studentfee_model');
             $this->load->model('student_model');
              $this->load->model('feesessiongroup_model');
        $this->load->model('miscellaneous_model');
        $this->load->library('smsgateway');
        $this->load->library('mailsmsconf');
        $this->search_type        = $this->config->item('search_type');
        $this->sch_setting_detail = $this->setting_model->getSetting();
    }

    public function index()
    {
        if (!$this->rbac->hasPrivilege('collect_fees', 'can_view')) {
            access_denied();
        }

        $this->session->set_userdata('top_menu', $this->lang->line('fees_collection'));
        $this->session->set_userdata('sub_menu', 'studentfee/index');
        $data['sch_setting'] = $this->sch_setting_detail;
        $data['title']       = 'student fees';
        $class               = $this->class_model->get();
        $data['classlist']   = $class;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/studentfeeSearch', $data);
        $this->load->view('layout/footer', $data);
    }

    public function collection_report()
    {
        if (!$this->rbac->hasPrivilege('collect_fees', 'can_view')) {
            access_denied();
        }
 
        $data['collect_by'] = $this->studentfeemaster_model->get_feesreceived_by();
        
        $data['searchlist'] = $this->customlib->get_searchtype();
        
        $data['group_by']   = $this->customlib->get_groupby();
        
        $feetype = $this->feetype_model->get();
        
        $data['feetypeList'] = $feetype;
        
        $feemasterList = $this->feesessiongroup_model->getFeesByGroup();
        // $data['feegroupList'] = $feegroup;
        $miscellaneous = $this->miscellaneous_model->get();
// Initialize an empty array to store the names
$fees_head = [];
//$fees_code = [];
$feetype = $this->feetype_model->get();
        $data['feetypeList'] = $feetype;

// Loop through each sub-array and add the 'name' to the $fees_head array
foreach ($feemasterList as $feegroup) {
    //print_r($feegroup->feetypes);
                                                
    if($feegroup->group_name!="TUITION FEE"){
    $fees_head[] = $feegroup->group_name;
    }
    // foreach ($feegroup->feetypes as $feetype_key => $feetype_value) {
    //                                                 //echo $feetype_value->code."<br>";
    //                                                 $fees_code[] = $feetype_value->code;
    //                                             }
     
}
$fees_head[]="Transport Fee";
$fees_head[]="Hostel Fee";
foreach ($miscellaneous as $item) {
    $fees_head[] = $item["miscellaneous_title"];
}
$data['fees_head'] = $fees_head;

        
        $this->session->set_userdata('top_menu', 'Reports');
        $this->session->set_userdata('sub_menu', 'Reports/finance');
        $this->session->set_userdata('subsub_menu', 'Reports/finance/collection_report');
            $subtotal=false;
        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'] = '';
        }

        if (isset($_POST['collect_by']) && $_POST['collect_by'] != '') {
            
            $data['received_by'] = $received_by = $_POST['collect_by'];
           
        } else {
            $data['received_by'] = $received_by = '';
        }

         if (isset($_POST['include_fee_head'])){
            $data['include_fee_head'] = $_POST['include_fee_head'];
            


        } else {
           $data['include_fee_head']="no";
        }
        
        if (isset($_POST['feetype_id']) && $_POST['feetype_id'] != '') {
            $feetype_id = $_POST['feetype_id'];
           
        } else {
           $feetype_id="";
        }

        if (isset($_POST['group']) && $_POST['group'] != '') {
            $data['group_byid'] = $group = $_POST['group'];
            $subtotal=true;
        } else {
            $data['group_byid'] = $group = '';
        }

        $collect_by          = array();
        $collection          = array();
        $start_date          = date('Y-m-d', strtotime($dates['from_date']));
        $end_date            = date('Y-m-d', strtotime($dates['to_date']));
        

        $this->form_validation->set_rules('search_type', $this->lang->line('search') . " " . $this->lang->line('type'), 'trim|required|xss_clean');


        if ($this->form_validation->run() == false) {
            $data['results'] = array();
        } 
        else {
            $data['results'] = $this->studentfeemaster_model->getFeeCollectionReport($start_date, $end_date,$feetype_id, $received_by, $group);
 
            if ($group != '') {

                if ($group == 'class') {

                    $group_by = 'class_id';
                } elseif ($group == 'collection') {

                    $group_by = 'received_by';
                } elseif ($group == 'mode') {

                    $group_by = 'payment_mode';
                }

                foreach ($data['results'] as $key => &$value) {
                    
    $Fee_receipt_no=$this->studentfeemaster_model->getStudentFee_Receipt_No($value['id'].'/'.$value['inv_no']);
//echo $Fee_receipt_no."<br>";
 $value['fee_receipt_no']=$Fee_receipt_no;
if($data['include_fee_head'] == 'yes'){

$value['fee_receipt_no_data'] = $this->studentfeemaster_model->getFeeByInvoice($value['id'], $value['inv_no'],'',1);//$feeList;//mergeStudentData($feeList);
 }
 
                    $collection[$value[$group_by]][] = $value;
                }
            } else {

                $s = 0;
                foreach ($data['results'] as $key => &$value) {
                    //print_r($value);
                 // echo  $value['id'].'/'.$value['inv_no']."<br>"; //ok
                //echo    $value->id.'/'.$value->inv_no."<br>";
                    //echo "<br>";
//SELECT * FROM `fee_receipt_no` WHERE payment_id LIKE '%966/1%'
$Fee_receipt_no=$this->studentfeemaster_model->getStudentFee_Receipt_No($value['id'].'/'.$value['inv_no']);
//echo $Fee_receipt_no."<br>";
 $value['fee_receipt_no']=$Fee_receipt_no;
 if($data['include_fee_head'] == "yes"){

$value['fee_receipt_no_data'] = $this->studentfeemaster_model->getFeeByInvoice($value['id'], $value['inv_no'],'',1);//$feeList;//mergeStudentData($feeList);
 }
 
                    $collection[$s++] = array($value);
                }
            }

            $data['results'] = $collection;
        }
        $data['subtotal']=$subtotal;
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/collection_report', $data);
        $this->load->view('layout/footer', $data);
    }
 
    public function pdf()
    {
        $this->load->helper('pdf_helper');
    }

    public function search()
    {
        $search_type = $this->input->post('search_type');
        if ($search_type == "class_search") {
            $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|xss_clean');//required|
        } elseif ($search_type == "keyword_search") {
            $this->form_validation->set_rules('search_text', 'keyword --r', 'trim|xss_clean');//required|
            $data = array('search_text' => 'dummy');

			$this->form_validation->set_data($data);
        }
        if ($this->form_validation->run() == false) {
            $error = array();
            if ($search_type == "class_search") {
                $error['class_id'] = form_error('class_id');
            } elseif ($search_type == "keyword_search") {
                $error['search_text'] = form_error('search_text');
            }

           // $array = array('status' => 0, 'error' => $error);
            $params      = array('search_type' => $search_type, 'search_text' => $search_text);
            $array       = array('status' => 1, 'error' => $error, 'params' => $params);
           
            echo json_encode($array);
        } else {
            $search_type = $this->input->post('search_type');
            $search_text = $this->input->post('search_text');
            $class_id    = $this->input->post('class_id');
            $section_id  = $this->input->post('section_id');
            $params      = array('class_id' => $class_id, 'section_id' => $section_id, 'search_type' => $search_type, 'search_text' => $search_text);
            $array       = array('status' => 1, 'error' => '', 'params' => $params);
            echo json_encode($array);
        }
    }
    public function ajaxSearch()
    {
        $class       = $this->input->post('class_id');
        $section     = $this->input->post('section_id');
        $search_text = $this->input->post('search_text');
        $search_type = $this->input->post('search_type');
        if ($search_type == "class_search") {
            $students = $this->student_model->getDatatableByClassSection($class, $section);
            //$students2 = $this->student_model->getDatatableByClassSection2($class, $section);
        } elseif ($search_type == "keyword_search") {
            $students = $this->student_model->getDatatableByFullTextSearch($search_text);
        }

        $students = json_decode($students);
        $dt_data  = array();
        if (!empty($students->data)) {
            foreach ($students->data as $student_key => $student) {
                $row   = array();
                $row[] = $student->class;
                $row[] = $student->section;
                $row[] = $student->admission_no;
                $row[] = $student->firstname . ' ' . $student->middlename . ' ' . $student->lastname;
                $row[] = $student->father_name;
                $row[] = $student->mother_name;
                $row[] = intval($student->roll_no);//$this->customlib->dateformat($student->dob);
                $row[] = $student->guardian_phone;
                //$row[] = "<a href=" . site_url('studentfee/addfee/' . $student->student_session_id) . "  class='btn btn-info btn-xs'>" . $this->lang->line('collect_fees') . "</a>";
                
                $row[] = "<a href='" . site_url('studentfee/addfee/' . $student->student_session_id) . "' target='_blank' class='btn btn-info btn-xs'>" . $this->lang->line('collect_fees') . "</a>";


                $dt_data[] = $row;
            }
//print_r($dt_data);
// Extract the roll numbers into a separate array for sorting
$rollNumbers = array_column($dt_data, 6);

// Sort the main array based on roll numbers
array_multisort($rollNumbers, SORT_ASC, $dt_data);
        }
        $json_data = array(
            "draw"            => intval($students->draw),
            "recordsTotal"    => intval($students->recordsTotal),
            "recordsFiltered" => intval($students->recordsFiltered),
            "data"            => $dt_data,
        );
        echo json_encode($json_data);
        //echo "<br>".$students2;

    }
    
    public function feesearch()
    {
        

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

        $this->session->set_userdata('top_menu', 'Fees Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/feesearch');
        $data['title']       = 'student fees';
        $class               = $this->class_model->get();
        $data['classlist']   = $class;
        $data['sch_setting'] = $this->sch_setting_detail;
        $feesessiongroup     = $this->feesessiongroup_model->getFeesByGroup();
        

        $data['feesessiongrouplist'] = $feesessiongroup;
        // $feesessiongroup2     = $this->feesessiongroup_model->getFeesByGroup2();

        // $data['feesessiongrouplist2'] = $feesessiongroup2;
        //$data['fees_group']          = "";
         $data['fees_group'] = array();
        if (isset($_POST['feegroup_id']) && $_POST['feegroup_id'] != '') {
            $data['fees_group'] = $_POST['feegroup_id'];
        }

        //$this->form_validation->set_rules('feegroup_id', $this->lang->line('fee_group'), 'trim|required|xss_clean');

       // if ($this->form_validation->run() == false) {
        if(empty($data['fees_group'])){
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentSearchFee', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $data['student_due_fee'] = array();
            $arrafeegroup_id=array();
           // $demo=array();
            // $abc=array();
            // $abc2=array();
             $arrafeegroup_id=$_POST['feegroup_id'];
             //$student_due_fee=array();
// foreach ($arrafeegroup_id as $arrafeegroup_ids) {
//             $feegroup_id             = $arrafeegroup_ids;//$this->input->post('feegroup_id');
//             $feegroup                = explode("-", $feegroup_id);
//             $feegroup_id             = $feegroup[0];
//             $fee_groups_feetype_id   = $feegroup[1];
//             $abc[]=$fee_groups_feetype_id;
//             $abc2[]=$feegroup_id;
//         }
        //$stringabc = "('" . implode("', '", $abc) . "')";
//echo $stringabc;
//$stringabc2 = "('" . implode("', '", $abc2) . "')";
//echo $stringabc2;
$i=0;
        foreach ($arrafeegroup_id as $arrafeegroup_ids) {
           $feegroup_id             = $arrafeegroup_ids;//$this->input->post('feegroup_id');
            $feegroup                = explode("-", $feegroup_id);
            $feegroup_id             = $feegroup[0];
            $fee_groups_feetype_id   = $feegroup[1];
            $class_id                = $this->input->post('class_id');
            $section_id              = $this->input->post('section_id');
            $student_due_fee[$i]         = $this->studentfee_model->getDueStudentFees($feegroup_id, $fee_groups_feetype_id, $class_id, $section_id);
           //print_r($student_due_fee[$i]);
        //   continue;
           //$student_due_fee2         = $this->studentfee_model->getDueStudentFees2($feegroup_id, $fee_groups_feetype_id, $class_id, $section_id);
            // $data['sdf1'] = $student_due_fee;
            // $data['sdf2'] = $student_due_fee2;
            //  $demo[]         = $this->studentfee_model->getDueStudentFees($feegroup_id, $fee_groups_feetype_id, $class_id, $section_id);
            //   if (!empty($demo[count($demo)-1] )) {
            //     foreach ($demo[count($demo)-1]  as $student_due_fee_key => $student_due_fee_value) {
            //         $amt_due                                                  = $student_due_fee_value['amount'];
            //         $demo[count($demo)-1][$student_due_fee_key]['amount_discount'] = 0;
            //         $demo[count($demo)-1][$student_due_fee_key]['amount_fine']     = 0;
            //         $a                                                        = json_decode($student_due_fee_value['amount_detail']);
            //         if (!empty($a)) {
            //             $amount          = 0;
            //             $amount_discount = 0;
            //             $amount_fine     = 0;

            //             foreach ($a as $a_key => $a_value) {
            //                 $amount          = $amount + $a_value->amount;
            //                 $amount_discount = $amount_discount + $a_value->amount_discount;
            //                 $amount_fine     = $amount_fine + $a_value->amount_fine;
            //             }
            //             if ($amt_due <= $amount) {
            //                 unset($student_due_fee[$student_due_fee_key]);
            //             } else {

            //                 $demo[count($demo)-1][$student_due_fee_key]['amount_detail']   = $amount;
            //                 $demo[count($demo)-1][$student_due_fee_key]['amount_discount'] = $amount_discount;
            //                 $demo[count($demo)-1][$student_due_fee_key]['amount_fine']     = $amount_fine;
            //             }
            //         }
            //     }
            // }
            //$a2=array();
            if (!empty($student_due_fee[$i])) {
                //return
            //   return print_r($student_due_fee[$i]); echo "<br>new<br>";
                foreach ($student_due_fee[$i] as $student_due_fee_key => $student_due_fee_value) {
                    // if($student_due_fee_value['admission_no']==24029){
                    //     print_r($student_due_fee_value);
                    // }
                    //print_r($student_due_fee_value);
                    //student_session_id
                    //echo $student_due_fee_value['code']."<br>";
                    //echo $student_due_fee_value['student_session_id']."<br>";
                    // print_r($this->studentfeemaster_model->getStudentMiscellaneousFees($student_due_fee_value['student_session_id']));
                    // exit();
    //                   $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($id);
    //     // $newArray    = $this->studentfeemaster_model->getdate_transport_fee($id);//$routefees
    //      $newArray    = $this->studentfeemaster_model->getdate_transport_fee($id);//$routefees
    //      $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($id);
    //   // $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($id);// $hostelfees
    //   $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($id);// $hostelfees
    //     $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($id);
                    
                    $student_due_fee[$i][$student_due_fee_key]['miscellaneousfees']    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student_due_fee_value['student_session_id']);
                    $student_due_fee[$i][$student_due_fee_key]['newArray']    = $this->studentfeemaster_model->getdate_transport_fee($student_due_fee_value['student_session_id']);
                    $student_due_fee[$i][$student_due_fee_key]['route_fees']    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student_due_fee_value['student_session_id']);
                    $student_due_fee[$i][$student_due_fee_key]['newArray_hostel']    = $this->studentfeemaster_model->getdate_hostel_fee($student_due_fee_value['student_session_id']);
                    $student_due_fee[$i][$student_due_fee_key]['hostel_fees']    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student_due_fee_value['student_session_id']);
                    //$student_due_fee[$i][$student_due_fee_key]['student_feediscount']
                    $student_feediscount= $this->feediscount_model->getStudentFeesDiscount($student_due_fee_value['student_session_id']);
$student_feediscount_amount=0;
                                                                if(!empty($student_feediscount)){
                                                                    foreach ($student_feediscount as $item) {
                                                                       // print_r($item);
    // echo "ID: " . $item['id'] . "<br>";
    // echo "Student Session ID: " . $item['student_session_id'] . "<br>";
    // echo "Status: " . $item['status'] . "<br>";
    // // ... Continue for other fields
    // echo "Amount: " . $item['amount'] . "<br>";
    // echo "<hr>"; // Separator for each item
     $student_feediscount_amount=$student_feediscount_amount+$item['amount'];
}
$student_due_fee[$i][$student_due_fee_key]['student_feediscount_amount']=$student_feediscount_amount;
}
//$student_due_fee[$i][$student_due_fee_key]['student_feediscount_amount']=$student_feediscount_amount;
//$student_due_fee_value['student_feediscount_amount']=$student_feediscount_amount;

//             $MFfare=0;
// foreach ($miscellaneousfees[$i] as $mf_key => $mf_value) {
//     //echo $mf_key."=>".$mf_value."<br>";
//      $MFfare=$mf_value['MFfare'];
// }

//echo $MFfare."<br>new<br>";
                    //echo $student_due_fee_value['fine_amount']."<br>new<br>";
                    //$student_due_fee_value['amount']+
                   // $student_due_fee[$i][$student_due_fee_key][amount]=5000;
                   // $amt_due                                                  = $student_due_fee_value['fare']+$student_due_fee_value['cost_per_bed']+$MFfare;//$student_due_fee_value['amount'];
                    $student_due_fee[$i][$student_due_fee_key]['amount_discount'] = 0;
                    $student_due_fee[$i][$student_due_fee_key]['amount_fine']     = 0;
                    //$student_due_fee[$i][$student_due_fee_key]['miscellaneousfees']     = $MFfare;
                    $a                                                        = json_decode($student_due_fee_value['amount_detail']);
                    //$a2[]                                                        = json_decode($student_due_fee_value['amount_detail']);
                   
                //   if($student_due_fee_value['student_session_id']==43){ print_r($a); }
                
                 //due_date
                 $lpd=$student_due_fee_value['due_date'];
                 $student_due_fee[$i][$student_due_fee_key]['due_date'] = $lpd;
                    if (!empty($a)) {
                        $amount          = 0;
                        $amount_discount = 0;
                        $amount_fine     = 0;
$temp=0;
                        
                        
                        foreach ($a as $a_key => $a_value) {
                            // print_r($a_value);
                            // echo "<br><br>new<br><br>";
                            $array_code = explode(" ", $student_due_fee_value['code']);
                           if(in_array("MONTH",$array_code)){
                               //$a_value->amount+
                               
                            $amount          = $amount +  $a_value->amount;//$student_due_fee_value['amount'];//$a_value->fare+$a_value->cost_per_bed+$MFfare;//$student_due_fee_value['amount']+$student_due_fee_value['fare']+$student_due_fee_value['cost_per_bed']
                           }else{
                                //$amount          = $amount + $a_value->amount;
                               
                                     //$amount          = $amount +$MFfare;
                                     $amount          = $amount + $a_value->amount;//$student_due_fee_value['amount'];
                                
                           }
                           if($amount==1){
                               $amount=0;
                           }
                            $amount_discount = intval($amount_discount) + intval($a_value->amount_discount);
                           
                                $amount_fine     = $amount_fine + $a_value->amount_fine;//+$student_due_fee_value['fine_amount'];
                            //$lpd=$a_value->date;
                            
                            //echo $amount."<br><br>new<br><br>";
                            
                            
                        }
                        // if ($amt_due <= $amount) {
                        //     unset($student_due_fee[$student_due_fee_key]);
                        // } else {
                             
                            $student_due_fee[$i][$student_due_fee_key]['amount_detail']   = $amount;
                            $student_due_fee[$i][$student_due_fee_key]['amount_discount'] = $amount_discount;
                            $student_due_fee[$i][$student_due_fee_key]['amount_fine']     = $amount_fine;
                            // //due_date
                            // $student_due_fee[$i][$student_due_fee_key]['due_date'] = $lpd;
                        //}
                    }else{
                        //$amount_fine     = $amount_fine + $student_due_fee_value['fine_amount'];
                        //  $array_code = explode(" ", $student_due_fee_value['code']);
                        //   if(in_array("MONTH",$array_code)){
                        // $student_due_fee[$i][$student_due_fee_key]['amount_discount'] = $student_feediscount_amount;
                        //   }
                         $student_due_fee[$i][$student_due_fee_key]['fine_amount']     = $student_due_fee_value['fine_amount'];
                    }
                    
                    //$array_code = explode(" ", $student_due_fee_value['code']);
                           if($array_code[1]=="MONTH"){//in_array("MONTH",$array_code)
                    //       if($student_due_fee_value['student_session_id']==43){
                    //   // print_r($array_code);
                    //   echo $array_code[0].'=='.$student_due_fee[$i][$student_due_fee_key]['amount_detail'].'=='.$student_due_fee[$i][$student_due_fee_key]['amount_discount'].'=='.$student_feediscount_amount."<br>";
                    // }
                    if($student_due_fee[$i][$student_due_fee_key]['amount_detail']<=0){
                        $student_due_fee[$i][$student_due_fee_key]['amount_discount'] = $student_feediscount_amount;
                          
                    }
                           }
                }
            }
            $i=$i+1;
        }
        //}
        
            //$miscellaneousfees[$i]
            $data['student_due_fee'] = $student_due_fee;
            //$data['miscellaneousfees'] = $miscellaneousfees;
            //$data['temp'] = $temp;
             //$data['student_due_fee2'] = $student_due_fee2;
             //$data['arrafeegroup_id'] = $arrafeegroup_id;
             //$data['a2'] = $a2;
            // $data['abc'] = $abc;
            // $data['abc2'] = $abc2;
            //$data['demo'] = $demo;
           // print_r($student_due_fee);
            //print_r($arrafeegroup_id);
            $this->load->view('layout/header', $data);

            $this->load->view('studentfee/studentSearchFee', $data);
            $this->load->view('layout/footer', $data);
            
        }
    }

    public function reportbyname()
    {
        if (!$this->rbac->hasPrivilege('fees_statement', '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/reportbyname');
        $data['title']       = 'student fees';
        $data['title']       = 'student fees';
        $class               = $this->class_model->get();
        $data['classlist']   = $class;
        $data['sch_setting'] = $this->sch_setting_detail;

        if ($this->input->server('REQUEST_METHOD') == "GET") {

            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByName', $data);
            $this->load->view('layout/footer', $data);
        } else {           
            {

                $data['student_due_fee'] = array();
                $class_id                = $this->input->post('class_id');
                $section_id              = $this->input->post('section_id');
                $student_id              = $this->input->post('student_id');               
                $student_due_fee              = $this->studentfeemaster_model->getStudentFeesByClassSectionStudent($class_id,$section_id,$student_id); 
                
foreach ($student_due_fee as $student_key => $student) {
    // Retrieve miscellaneous fees for the current student
    $miscellaneousfees = $this->studentfeemaster_model->getStudentMiscellaneousFees($student['student_session_id']);
     //$newArray    = $this->studentfeemaster_model->getdate_transport_hostel($student['student_session_id']);//$routefees
     $newArray    = $this->studentfeemaster_model->getdate_transport_fee($student['student_session_id']);//$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student['student_session_id']);
        //$newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel($student['student_session_id']);// $hostelfees
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($student['student_session_id']);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student['student_session_id']);

  

    // Update the current student's array with miscellaneous fees
    $student_due_fee[$student_key]['miscellaneousfees'] = $miscellaneousfees;
     $student_due_fee[$student_key]['newArray'] = $newArray;
      $student_due_fee[$student_key]['route_fees'] = $route_fees;
       $student_due_fee[$student_key]['newArray_hostel'] = $newArray_hostel;
        $student_due_fee[$student_key]['hostel_fees'] = $hostel_fees;
}

                $data['student_due_fee']      = $student_due_fee;
                $data['class_id']             = $class_id;
                $data['section_id']           = $section_id;
                $data['student_id']           = $student_id;
                $category                     = $this->category_model->get();
                $data['categorylist']         = $category;
                $this->load->view('layout/header', $data);
                $this->load->view('studentfee/reportByName', $data);
                $this->load->view('layout/footer', $data);
            }
        }
    }

    public function reportbyclass()
    {
        $data['title']     = 'student fees';
        $data['title']     = 'student fees';
        $class             = $this->class_model->get();
        $data['classlist'] = $class;
        if ($this->input->server('REQUEST_METHOD') == "GET") {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByClass', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $student_fees_array      = array();
            $class_id                = $this->input->post('class_id');
            $section_id              = $this->input->post('section_id');
            $student_result          = $this->student_model->searchByClassSection($class_id, $section_id);
            $data['student_due_fee'] = array();
            if (!empty($student_result)) {
                foreach ($student_result as $key => $student) {
                    $student_array                      = array();
                    $student_array['student_detail']    = $student;
                    $student_session_id                 = $student['student_session_id'];
                    $student_id                         = $student['id'];
                    $student_due_fee                    = $this->studentfee_model->getDueFeeBystudentSection($class_id, $section_id, $student_session_id);
                    $student_array['fee_detail']        = $student_due_fee;
                    $student_fees_array[$student['id']] = $student_array;
                }
            }
            $data['class_id']           = $class_id;
            $data['section_id']         = $section_id;
            $data['student_fees_array'] = $student_fees_array;
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByClass', $data);
            $this->load->view('layout/footer', $data);
        }
    }

    public function view($id)
    {
        if (!$this->rbac->hasPrivilege('collect_fees', 'can_view')) {
            access_denied();
        }
        $data['title']      = 'studentfee List';
        $studentfee         = $this->studentfee_model->get($id);
        $data['studentfee'] = $studentfee;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/studentfeeShow', $data);
        $this->load->view('layout/footer', $data);
    }

    public function deleteFee()
    {

        if (!$this->rbac->hasPrivilege('collect_fees', 'can_delete')) {
            access_denied();
        }
        $invoice_id  = $this->input->post('main_invoice');
        $sub_invoice = $this->input->post('sub_invoice');
        $student_id = $this->input->post('student_id');
        $fee_receipt_no = $this->input->post('fee_receipt_no');
        //fee_receipt_no
        if(!empty($invoice_id)){
            $this->studentfee_model->addDeletedFee($invoice_id,$sub_invoice, $student_id, $fee_receipt_no);
        }
        if (!empty($invoice_id)) {
            $this->studentfee_model->remove($invoice_id, $sub_invoice);
        }
        if(!empty($fee_receipt_no)){
            $id_new=$invoice_id.'/'.$sub_invoice;
            $this->db->select('id');
            $this->db->from('fee_receipt_no');
            $this->db->like('payment_id', '%' . $id_new . '%', '!', false); // Using '!' as the escape character

            $query = $this->db->get();
            if ($query->num_rows() > 0) {
    
        $result = $query->row();
        if($result->id==$fee_receipt_no){
            $this->db->select('payment_id');
            $this->db->from('fee_receipt_no');
            $this->db->where('id', $fee_receipt_no);
            
    
            $query = $this->db->get();
            if ($query->num_rows() > 0) {
                $result = $query->row();
                $arra_paymet_id = explode('-', $result->payment_id);
            
                $key_to_remove = array_search($id_new, $arra_paymet_id);
            
            if ($key_to_remove !== false) {
                unset($arra_paymet_id[$key_to_remove]);
            }
            if (count($arra_paymet_id) > 0) {
                $updated_payment_id = implode('-', $arra_paymet_id);
                $this->db->where('fee_receipt_no.id', $fee_receipt_no);
                $this->db->update('fee_receipt_no', array('payment_id' => $updated_payment_id));
            
            } else {
                $this->db->where('fee_receipt_no.id', $fee_receipt_no);
                $this->db->delete('fee_receipt_no');
            }
            
            }
               }
            }
           $array = array('status' => 'success', 'result' => 'success');
           echo json_encode($array);
        }

    }

    public function deleteStudentDiscount()
    {

        $discount_id = $this->input->post('discount_id');
        if (!empty($discount_id)) {
            $data = array('id' => $discount_id, 'status' => 'assigned', 'payment_id' => "");
            $this->feediscount_model->updateStudentDiscount($data);
        }
        $array = array('status' => 'success', 'result' => 'success');
        echo json_encode($array);
    }

public function getcollectfee()
    {
        // clear_logs();
        $setting_result      = $this->setting_model->get();
        $data['settinglist'] = $setting_result;
        $record              = $this->input->post('data');
        $record_array        = json_decode($record);
        
        $fees_array = array();
        foreach ($record_array as $key => $value) {
            $fee_groups_feetype_id = $value->fee_groups_feetype_id;
            $fee_master_id         = $value->fee_master_id;
            $fee_session_group_id  = $value->fee_session_group_id;
            $student_session_id    = $value->student_session_id;
            $fee_group_count       = $value->fee_group_count;
            //thf
            $thf       = $value->thf;
            $feeList               = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($fee_session_group_id, $fee_master_id, $fee_groups_feetype_id);
            $discount_not_applied   = $this->getNotAppliedDiscount($student_session_id); 
           
           $feeList->fee_group_count = $fee_group_count;
           $feeList->thf = $thf;

            $fees_array[]          = $feeList;
            // $fees_array[] = "fee_group_count" ."=>". $fee_group_count;
            $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student_session_id);
            $miscellaneousfees_2    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_session_id));   //$New_student_session_id[0]

           // $newArray    = $this->studentfeemaster_model->getdate_transport_hostel($student_session_id);//$routefees
           $newArray    = $this->studentfeemaster_model->getdate_transport_fee($student_session_id);//$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student_session_id);
        //$newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel($student_session_id);// $hostelfees
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($student_session_id);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student_session_id);

        }
        $data['miscellaneousfees'] = $miscellaneousfees;
        $data['miscellaneousfees_2'] = $miscellaneousfees_2;
        $data['newArray'] = $newArray;
        $data['route_fees'] = $route_fees;
        $data['newArray_hostel'] = $newArray_hostel;
        $data['hostel_fees'] = $hostel_fees;
        $data['feearray'] = $fees_array;
        $data['discount_not_applied']=$discount_not_applied;
        
        // log_debug("studentfee/getcollectfee:Data",$data);
                
        $result           = array(
            'view' => $this->load->view('studentfee/getcollectfee', $data, true),
        );

        $this->output->set_output(json_encode($result));
    }

    public function addfee($id)
    {

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

        
        $data['sch_setting']  = $this->sch_setting_detail;
        $data['title']        = 'Student Detail';
        $student              = $this->student_model->getByStudentSession($id);
        //  print_r($student);
        // exit();
        // $student2              = $this->student_model->getByStudentSession2($id);
        $data['student']      = $student;
        // $data['student2']      = $student2;
        
        $student_due_fee      = $this->studentfeemaster_model->getStudentFees($id);
        

        
         //print_r($student_due_fee);
        //  print_r($student_due_fee);
        // exit();
        $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($id);
        //  print_r($miscellaneousfees);
        // exit();
        // $newArray    = $this->studentfeemaster_model->getdate_transport_fee($id);//$routefees
         $newArray    = $this->studentfeemaster_model->getdate_transport_fee($id);//$routefees
         //print_r($newArray);
         $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($id);
       // $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($id);// $hostelfees
       $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($id);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($id);
        //print_r($miscellaneousfees);
        $student_feediscount      = $this->feediscount_model->getStudentFeesDiscount($id);
        //print_r($student_feediscount);
        // $student_due_fee2      = $this->studentfeemaster_model->getStudentFees2($id);
        $student_discount_fee = $this->feediscount_model->getStudentFeesDiscount($id);
        // $student_discount_fee2 = $this->feediscount_model->getStudentFeesDiscount2($id);
        $data['miscellaneousfees'] = $miscellaneousfees;
        $data['newArray'] = $newArray;
        $data['route_fees'] = $route_fees;
        $data['hostel_fees'] = $hostel_fees;
        $data['newArray_hostel'] = $newArray_hostel;
        $data['student_discount_fee'] = $student_discount_fee;
        // $data['student_discount_fee2'] = $student_discount_fee2;
        
        //yuvi
        $data['student_due_fee']      = $student_due_fee;
        
        $data['student_feediscount_fee']      = $student_feediscount;
        // $data['student_due_fee2']      = $student_due_fee2;
        $category                     = $this->category_model->get();
        $data['categorylist']         = $category;
        $class_section                = $this->student_model->getClassSection($student["class_id"]);
        $data["class_section"]        = $class_section;
        $session                      = $this->setting_model->getCurrentSession();
        $studentlistbysection         = $this->student_model->getStudentClassSection($student["class_id"], $session);
        //$studentlistbysection2         = $this->student_model->getStudentClassSection2($student["class_id"], $session);
       // $data["studentlistbysection2"] = $studentlistbysection2;
        $data["studentlistbysection"] = $studentlistbysection;

        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/studentAddfee', $data);
        $this->load->view('layout/footer', $data);
    }

    public function deleteTransportFee()
    {
        $id = $this->input->post('feeid');
        $this->studenttransportfee_model->remove($id);
        $array = array('status' => 'success', 'result' => 'success');
        echo json_encode($array);
    }

    public function delete($id)
    {
        $data['title'] = 'studentfee List';
        $this->studentfee_model->remove($id);
        redirect('studentfee/index');
    }

    public function create()
    {
        if (!$this->rbac->hasPrivilege('collect_fees', 'can_view')) {
            access_denied();
        }
        $data['title'] = 'Add studentfee';
        $this->form_validation->set_rules('category', $this->lang->line('category'), 'trim|required|xss_clean');
        if ($this->form_validation->run() == false) {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeCreate', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $data = array(
                'category' => $this->input->post('category'),
            );
            $this->studentfee_model->add($data);
            $this->session->set_flashdata('msg', '<div studentfee="alert alert-success text-center">' . $this->lang->line('success_message') . '</div>');
            redirect('studentfee/index');
        }
    }

    public function edit($id)
    {
        if (!$this->rbac->hasPrivilege('collect_fees', 'can_edit')) {
            access_denied();
        }
        $data['title']      = 'Edit studentfees';
        $data['id']         = $id;
        $studentfee         = $this->studentfee_model->get($id);
        $data['studentfee'] = $studentfee;
        $this->form_validation->set_rules('category', $this->lang->line('category'), 'trim|required|xss_clean');
        if ($this->form_validation->run() == false) {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeEdit', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $data = array(
                'id'       => $id,
                'category' => $this->input->post('category'),
            );
            $this->studentfee_model->add($data);
            $this->session->set_flashdata('msg', '<div studentfee="alert alert-success text-center">' . $this->lang->line('update_message') . '</div>');
            redirect('studentfee/index');
        }
    }

    public function addstudentfee()
    {

        $this->form_validation->set_rules('student_fees_master_id', $this->lang->line('fee_master'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('fee_groups_feetype_id', $this->lang->line('student'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount', $this->lang->line('amount'), 'required|trim|xss_clean|numeric|callback_check_deposit');//callback_check_deposit
        $this->form_validation->set_rules('amount_discount', $this->lang->line('discount'), 'required|numeric|trim|xss_clean');
        $this->form_validation->set_rules('amount_fine', $this->lang->line('fine'), 'required|trim|numeric|xss_clean');
        $this->form_validation->set_rules('payment_mode', $this->lang->line('payment_mode'), 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'amount'                 => form_error('amount'),
                'student_fees_master_id' => form_error('student_fees_master_id'),
                'fee_groups_feetype_id'  => form_error('fee_groups_feetype_id'),
                'amount_discount'        => form_error('amount_discount'),
                'amount_fine'            => form_error('amount_fine'),
                'payment_mode'           => form_error('payment_mode'),
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            //fee_value_amount+fee_value_fine==$this->input->post('amount')+$this->input->post('amount_discount')+$this->input->post('amount_fine')
            $staff_record = $this->staff_model->get($this->customlib->getStaffID());

            $collected_by             = $this->customlib->getAdminSessionUserName() . "(" . $staff_record['employee_id'] . ")";
            $student_fees_discount_id = $this->input->post('student_fees_discount_id');
            //$student_session_id = $this->input->post('student_session_id');
            $json_array               = array(
                'amount'          => $this->input->post('amount'),
                'date'            => date('Y-m-d', intval($this->customlib->datetostrtotime($this->input->post('date')))),
                'amount_discount' => $this->input->post('amount_discount'),
                'amount_fine'     => $this->input->post('amount_fine'),
                'description'     => $this->input->post('description'),
                'collected_by'    => $collected_by,
                'payment_mode'    => $this->input->post('payment_mode'),
                'received_by'     => $staff_record['id'],
            );
            $data = array(
                'student_fees_master_id' => $this->input->post('student_fees_master_id'),
                'fee_groups_feetype_id'  => $this->input->post('fee_groups_feetype_id'),
                'amount_detail'          => $json_array,
               
            );

            $action             = $this->input->post('action');
            $send_to            = $this->input->post('guardian_phone');
            $email              = $this->input->post('guardian_email');
            $parent_app_key     = $this->input->post('parent_app_key');
            $student_session_id = $this->input->post('student_session_id');
            $thf                = $this->input->post('thf');
            $inserted_id        = $this->studentfeemaster_model->fee_deposit($data, $send_to, $student_fees_discount_id,$student_session_id,$thf);
             //print_r($inserted_id);
            $mailsms_array      = $this->feegrouptype_model->getFeeGroupByID($this->input->post('fee_groups_feetype_id'));
            $print_record       = array();
            if ($action == "print") {
                $receipt_data           = json_decode($inserted_id);
                $data['sch_setting']    = $this->sch_setting_detail;
                $fee_record             = $this->studentfeemaster_model->getFeeByInvoice($receipt_data->invoice_id, $receipt_data->sub_invoice_id);
                $student                = $this->studentsession_model->searchStudentsBySession($student_session_id);
                $data['student']        = $student;
                $data['sub_invoice_id'] = $receipt_data->sub_invoice_id;
                $data['feeList']        = $fee_record;
                $print_record           = $this->load->view('print/printFeesByName', $data, true);
            }
            $mailsms_array->invoice        = $inserted_id;
            $mailsms_array->contact_no     = $send_to;
            $mailsms_array->email          = $email;
            $mailsms_array->parent_app_key = $parent_app_key;

            $this->mailsmsconf->mailsms('fee_submission', $mailsms_array);

            $array = array('status' => 'success', 'error' => '', 'print' => $print_record);
            echo json_encode($array);
            //echo json_encode($this->mailsmsconf->mailsms('fee_submission', $mailsms_array));
        }
    }

    public function printFeesByName()
    {
        $data                   = array('payment' => "0");
        $record                 = $this->input->post('data');
        $invoice_id             = $this->input->post('main_invoice');
        $sub_invoice_id         = $this->input->post('sub_invoice');
        $student_session_id     = $this->input->post('student_session_id');
        $setting_result         = $this->setting_model->get();
        $data['settinglist']    = $setting_result;
        $student                = $this->studentsession_model->searchStudentsBySession($student_session_id);
        $fee_record             = $this->studentfeemaster_model->getFeeByInvoice($invoice_id, $sub_invoice_id);
        $data['student']        = $student;
        $data['sub_invoice_id'] = $sub_invoice_id;
        $data['feeList']        = $fee_record;
        $data['sch_setting']    = $this->sch_setting_detail;
        $this->load->view('print/printFeesByName', $data);
    }

    public function printFeesByGroup()
    {
        $fee_groups_feetype_id = $this->input->post('fee_groups_feetype_id');
        $fee_master_id         = $this->input->post('fee_master_id');
        $fee_session_group_id  = $this->input->post('fee_session_group_id');
        $fee_group_count  = $this->input->post('fee_group_count');
        //fee_group_count
        $student_session_id  = $this->input->post('student_session_id');
        //student_session_id
        $setting_result        = $this->setting_model->get();
        $data['settinglist']   = $setting_result;
        $data['feeList']       = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($fee_session_group_id, $fee_master_id, $fee_groups_feetype_id);//,$student_session_id
        $data['sch_setting']   = $this->sch_setting_detail;
        $data['fee_group_count']=$fee_group_count;
        $miscellaneousfees    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees($student_session_id);   
$data['miscellaneousfees'] = $miscellaneousfees;
        $this->load->view('print/printFeesByGroup', $data);
    }

    public function printFeesByGroupArray()
    {
        // if($add==null){
        //if($add){
        $data['sch_setting'] = $this->sch_setting_detail;
        $record              = $this->input->post('data');
        $record_array       = json_decode($record);
      
       //print_r($record_array);
        $fees_array          = array();
        
        foreach ($record_array[0] as $key => $value) {
            $fee_session_group_id  = $value;
        }
        foreach ($record_array[1] as $key => $value) {
            $fee_master_id         = $value;
        }
       
        
        foreach ($record_array[2] as $key => $value) {
            $fee_groups_feetype_id = $value;
        }
         foreach ($record_array[3] as $key => $value) {
            $fee_group_count = $value;
        }
        //thf
        foreach ($record_array[4] as $key => $value) {
            $thf = $value;
        }
        
        //student_session_id
         foreach ($record_array[5] as $key => $value) {
            $student_session_id = $value;
        }
        $lv=0;
        foreach ($record_array[6] as $key => $value) {
            if($key=="loop_value"){
                $loop_value            = $value;
               // $loop_value_n="";
                $lv=1;
            }else{
            $loop_value_n          = $value;
            //$loop_value="";
             $lv=0;
        }
        }
        // if($lv==0){
        // foreach ($record_array[6] as $key => $value) {
        //     $loop_value            = $value;
        // }
      
        // }
         //fee_receipt_no
         foreach ($record_array[7] as $key => $value) {
            $fee_receipt_no = $value;
        }
        $array_fee_groups_feetype_id = explode(',', $fee_groups_feetype_id);
         //print_r($fee_groups_feetype_id);
         //print_r($array_fee_groups_feetype_id);
        $array_fee_master_id = explode(',', $fee_master_id);
        $array_fee_session_group_id = explode(',', $fee_session_group_id);
        $array_fee_group_count = explode(',', $fee_group_count);
        //print_r($array_fee_group_count);
         $array_thf = explode(',', $thf);
         $array_fee_receipt_no = explode(',', $fee_receipt_no);
         //fee_receipt_no
        //thf
        //fee_groups_feetype_id
        //echo count($array_fee_groups_feetype_id);
          
        for($i=0;$i<count($array_fee_groups_feetype_id);$i++){
            $values = explode("-", $array_fee_groups_feetype_id[$i]);
                    //   $js_array = json_encode($values); // Convert PHP array to JS array
    // echo "<script> 
    //     let values = $js_array;
    //     console.log('Index $i:', values);
    // </script>";
            //print_r($values);
            //echo $array_fee_session_group_id[$i].'-'.$array_fee_master_id[$i].'-'.$array_fee_groups_feetype_id[$i]."<br>";
             $feeList               = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($values[0], $values[1], $values[2]);
             //print_r($feeList);
             
    $feeList_js = json_encode($feeList); 
//   echo "<script> 
//           let feeList = $feeList_js;
//         console.log('Index $i feeList:', feeList);
//     </script>";
             
//              foreach ($feeList as &$feeItem) {
//     $feeItem['fee_group_count'] = $fee_group_count;
// }
    // Add 'fee_group_count' to each element in $feeList
    //return print_r($fee_group_count);
//       print_r($feeList);
// exit();
//echo $array_fee_group_count[$i];
$feeList->fee_group_count = $array_fee_group_count[$i];
$feeList->thf = $array_thf[$i];
$feeList->fee_receipt_no =$array_fee_receipt_no[$i];
// $feeList['fee_group_count'] = $array_fee_group_count[$i];
// $feeList['thf'] = $array_thf[$i];
//print_r($feeList);
// echo "<br>new<br>";
//     return print_r($feeList);



// Print the modified $feeList for debugging
//print_r($feeList);
             $fees_array[]          = $feeList;
     
         }
       
       //$New_student_session_id = explode(',', $student_session_id);
$miscellaneousfees    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_session_id));   //$New_student_session_id[0]
//$newArray    = $this->studentfeemaster_model->getdate_transport_hostel(intval($student_session_id));//$routefees
  $newArray    = $this->studentfeemaster_model->getdate_transport_fee(intval($student_session_id));//$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet(intval($student_session_id));
        //print_r($route_fees);
       // $newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel(intval($student_session_id));// $hostelfees
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee(intval($student_session_id));// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet(intval($student_session_id));
$data['miscellaneousfees'] = $miscellaneousfees;
$data['newArray'] = $newArray;
$data['route_fees'] = $route_fees;
$data['newArray_hostel'] = $newArray_hostel;
$data['hostel_fees'] = $hostel_fees;
        $data['feearray'] = $fees_array;
        if($lv==1){
        $data['loop_value'] = $loop_value;
        }
        if($lv==0){
        $data['loop_value_n']=$loop_value_n;
        }
        
// }else{
//     $record              = $this->input->post('data');
//     $fees_array          = array();
//       foreach ($record_array[0] as $key => $value) {
//             $fee_groups_feetype_id = $value;
//         }
       
//             $array_fee_groups_feetype_id = explode('=', $fee_groups_feetype_id);
//                     for($i=0;$i<count($array_fee_groups_feetype_id);$i++){
//             $values = explode("-", $array_fee_groups_feetype_id[$i]);
//             //echo $array_fee_session_group_id[$i].'-'.$array_fee_master_id[$i].'-'.$array_fee_groups_feetype_id[$i]."<br>";
//              $feeList               = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($values[0], $values[1], $values[2]);



// $feeList->fee_group_count = $array_fee_group_count[$i];

// // echo "<br>new<br>";
// //     return print_r($feeList);


// // Print the modified $feeList for debugging
// //print_r($feeList);
//              $fees_array[]          = $feeList;
     
//          }
        

//         $data['feearray'] = $fees_array;
// }
    // clear_logs();
    //  log_debug("print/printFeesByGroupArray",$data);

$this->load->view('print/printFeesByGroupArray', $data);
        
    }

    public function searchpayment()
    {
        if (!$this->rbac->hasPrivilege('search_fees_payment', 'can_view')) {
            access_denied();
        }
        $this->session->set_userdata('top_menu', 'Search Fees');
        $this->session->set_userdata('sub_menu', 'studentfee/searchpayment');
        $data['title'] = 'Edit studentfees';

        $this->form_validation->set_rules('paymentid', $this->lang->line('payment_id'), 'trim|required|xss_clean');
        if ($this->form_validation->run() == false) {

        } else {
            $paymentid = $this->input->post('paymentid');
            $invoice   = explode("/", $paymentid);
            // print_r($invoice);
             //echo count($invoice);
      if(count($invoice)==2){
            if (array_key_exists(0, $invoice) && array_key_exists(1, $invoice)) {
                $invoice_id             = $invoice[0];
                $sub_invoice_id         = $invoice[1];
                $feeList                = $this->studentfeemaster_model->getFeeByInvoice($invoice_id, $sub_invoice_id);
                $data['feeList']        = $feeList;
                $data['sub_invoice_id'] = $sub_invoice_id;
            } else {
                $data['feeList'] = array();
            }
        }
        else{
            $invoice   = explode("-", $paymentid);
            if(count($invoice)==2){
                  if (array_key_exists(0, $invoice) && array_key_exists(1, $invoice)) {
                $invoice_id             = $invoice[0];
                $sub_invoice_id         = $invoice[1];
                $feeList                = $this->studentfeemaster_model->getFeeByInvoice($invoice_id, $sub_invoice_id,1);
                $student_session_id=0;
                foreach ($feeList as $object) {
                    $student_session_id=$object->student_session_id;
                }
                $student_due_fee      = $this->studentfeemaster_model->getStudentFees($student_session_id);
                $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student_session_id);
        $data['miscellaneousfees'] = $miscellaneousfees;

                $data['student_due_fee']      = $student_due_fee;
                $data['feeList']        = $feeList;
                //print_r($feeList);
               // $data['sub_invoice_id'] = $sub_invoice_id;
            } else {
                $data['feeList'] = array();
            }
                
            }else{
            $fee_receipt_no_id             = $invoice[0];
                //$sub_invoice_id         = $invoice[1];
                $payment_id              = $this->studentfeemaster_model->getStudentFee_Receipt_payment_id($fee_receipt_no_id);
               //print_r($payment_id);
                $array_payment_id   = explode("-", $payment_id);
                $feeList=array();
                $sub_invoice_id_new=array();
                for($i=0;$i<count($array_payment_id);$i++){
                    $invoice_new   = explode("/", $array_payment_id[$i]);
                    if (array_key_exists(0, $invoice_new) && array_key_exists(1, $invoice_new)) {
                $invoice_id             = $invoice_new[0];
                $sub_invoice_id         = $invoice_new[1];
                $feeList[]                = $this->studentfeemaster_model->getFeeByInvoice($invoice_id, $sub_invoice_id);
                $sub_invoice_id_new[]=$invoice_new[1];
            } 
            // else {
            //     $data['feeList'] = array();
            // }
            if($i==0){
                $student_session_id=0;
                foreach ($feeList as $object) {
                    $student_session_id=$object->student_session_id;
                }
                $student_due_fee      = $this->studentfeemaster_model->getStudentFees($student_session_id);
                $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student_session_id);
        $data['miscellaneousfees'] = $miscellaneousfees;

                $data['student_due_fee']      = $student_due_fee;
            }
                }
                $data['feeList']        = $feeList;
                $data['sub_invoice_id'] = $sub_invoice_id_new;
                $data['receipt_no_id']=1;
                // $feeList                = $this->studentfeemaster_model->getFeeByInvoice($fee_receipt_no_id);
                // $student_session_id=0;
                // foreach ($feeList as $object) {
                //     $student_session_id=$object->student_session_id;
                // }
                // $student_due_fee      = $this->studentfeemaster_model->getStudentFees($student_session_id);
                // $data['student_due_fee']      = $student_due_fee;
                // $data['feeList']        = $feeList;
                //print_r($feeList);
            }
            
        }
        }
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/searchpayment', $data);
        $this->load->view('layout/footer', $data);
    }
    
    
    //add miscellaneous 

    public function addmiscellaneousfee()
    {
        $this->form_validation->set_rules('fee_session_groups', $this->lang->line('fee_group'), 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'fee_session_groups' => form_error('fee_session_groups'),
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $fee_groups_id          = $this->input->post('fee_groups_id');//fee_groups_id
            $student_session_id     = $this->input->post('student_session_id');
            $fee_session_groups     = $this->input->post('fee_session_groups');
            $fee_month              = $this->input->post('fee_month');

            $miscellaneous_id          = $this->input->post('miscellaneous_id');//miscellaneous_id
            //$route_fees     = $this->input->post('route_fees');
            //$vehroute_id     = $this->input->post('vehroute_id');

            //$transport_fees     = $this->input->post('transport_fees');
            $student_sesssion_array = isset($student_session_id)  ? $student_session_id : array();
           
// $student_sesssion_array_new=isset($result_array)  ? $result_array : array();
            $student_ids            = $this->input->post('student_ids');
            //$student_sesssion_array
             if(isset($student_session_id) && !empty($student_session_id)){
            $delete_student         = array_diff($student_ids, $student_sesssion_array);
             }else{
                 $delete_student=$student_ids;
             }
            // Combining both arrays
            if(isset($student_session_id) && !empty($student_session_id)){
 $result_array = array_merge($delete_student , $student_session_id);
            }else{
                $result_array = $delete_student;
            }

$set=0;
$result_array = array_diff($result_array, $student_sesssion_array);
    $fee_months = explode(",", $fee_month);
 foreach($delete_student as $ds){
     
      $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
      $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($ds);
        //  print_r($miscellaneousfees);
        // exit();
        // Extract the concatenated_miscellaneous_ids string
$concatenated_ids = $miscellaneousfees[0]['concatenated_miscellaneous_ids'];
// Convert the string to an array
$ids_array = explode('=', $concatenated_ids);
// Check if the value exists in the array
if (in_array($miscellaneous_id, $ids_array)) {
                    // print_r($student_due_fee);
                    // exit();
                    foreach ($student_due_fee as $key => $fee) {
                        foreach ($fee->fees as $fee_key => $fee_value) {
                            if(count($fee->fees)>=3){
                                for($z=0;$z<count($fee_months);$z++){
                                if (in_array($fee_months[$z], explode(" ", $fee_value->code)) || in_array($fee_months[$z], explode(" ", $fee_value->typ))) {
                                    if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
                                        //amount_detail
                                        $set=1;
                                        $key = array_search($ds, $result_array);
                    // echo $ds."<br>";
                    //echo "if<br>";
                     unset($result_array[$key]);
                //echo "2 if";
        //         $student              = $this->student_model->getByStudentSession($ds);
        // break;
                                    }
                                }
                                }
                            }
                        }
                    }
 }
                    unset($student_due_fee);
                   


 }
 
 foreach($delete_student as $ds){
     
      $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
                    // print_r($student_due_fee);
                    // exit();
                     $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($ds);
        //  print_r($miscellaneousfees);
        // exit();
        // Extract the concatenated_miscellaneous_ids string
$concatenated_ids = $miscellaneousfees[0]['concatenated_miscellaneous_ids'];
// Convert the string to an array
$ids_array = explode('=', $concatenated_ids);
// Check if the value exists in the array
if (in_array($miscellaneous_id, $ids_array)) {
                    foreach ($student_due_fee as $key => $fee) {
                        foreach ($fee->fees as $fee_key => $fee_value) {
                            if(count($fee->fees)>=3){
                                for($z=0;$z<count($fee_months);$z++){
                                if (in_array($fee_months[$z], explode(" ", $fee_value->code)) || in_array($fee_months[$z], explode(" ", $fee_value->typ))) {
                                    if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
                                        //amount_detail
                                        $set=1;
                //echo "2 if";
                $student              = $this->student_model->getByStudentSession($ds);
        break;
                                    }
                                }
                                }
                            }
                        }
                    }
 }
                    unset($student_due_fee);
                   


 }



        if($set==0)
        {
// }
            //$preserve_record = array();
            if (!empty($student_sesssion_array)) {
                foreach ($student_sesssion_array as $key => $value) {
                    
                    $insert_array = array(
                        'student_session_id'   => $value,
                        'fee_miscellaneous_id' =>$miscellaneous_id,
                        'session_id' => $this->setting_model->getCurrentSession(),
                        //'route_fees'=>$route_fees,
                       // 'vehroute_id'=>$vehroute_id,
                        // 'fee_session_group_id' => $fee_session_groups,
                    );
                    $this->studentfeemaster_model->addmiscellaneous($insert_array);//addroute($insert_array);
                    //$inserted_id = $this->studentfeemaster_model->add($insert_array);
                    //print_r($inserted_id);
                    //$preserve_record[] = $inserted_id;
               
            }
            }
            if (!empty($result_array)) { //$delete_student
                //$this->studentfeemaster_model->delete($fee_session_groups, $delete_student);
                
                $this->studentfeemaster_model->delete_miscellaneous_id($result_array,$miscellaneous_id,$this->setting_model->getCurrentSession());//delete_route_id($result_array);
            }
            //print_r($result_array);
           // echo "<br>".$miscellaneous_id."<br>";
            $array = array('status' => 'success', 'error' => '', 'message' => $this->lang->line('success_message'));
            echo json_encode($array);
        }else{
            // $array = array('status' => 'fail', 'error' => '', 'message' => $this->lang->line('not_success_message'));//$this->lang->line('not_success_message'));
            // echo json_encode($array);
            
            $array = array('status' => 'fail', 'message' => "Revert The payment ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
            echo json_encode($array);
        }
        if ($set_r==1) {
            # code...
            // $array = array('status' => 'fail', 'message' => "First unchecked for other Route ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
            // echo json_encode($array);
        }
    //}
        }
    }


    //end miscellaneous



    //add routes 

    public function addroutefee()
    {
        $this->form_validation->set_rules('fee_session_groups', $this->lang->line('fee_group'), 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'fee_session_groups' => form_error('fee_session_groups'),
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $fee_groups_id          = $this->input->post('fee_groups_id');//fee_groups_id
            $student_session_id     = $this->input->post('student_session_id');
            $fee_session_groups     = $this->input->post('fee_session_groups');

            $route_id          = $this->input->post('route_id');//route_id
            //$route_fees     = $this->input->post('route_fees');
            $vehroute_id     = $this->input->post('vehroute_id');

            //$transport_fees     = $this->input->post('transport_fees');
            $student_sesssion_array = isset($student_session_id)  ? $student_session_id : array();
           
// $student_sesssion_array_new=isset($result_array)  ? $result_array : array();
            $student_ids            = $this->input->post('student_ids');
            //$student_sesssion_array
             if(isset($student_session_id) && !empty($student_session_id)){
            $delete_student         = array_diff($student_ids, $student_sesssion_array);
             }else{
                 $delete_student=$student_ids;
             }
            // Combining both arrays
            if(isset($student_session_id) && !empty($student_session_id)){
 $result_array = array_merge($delete_student , $student_session_id);
            }else{
                $result_array = $delete_student;
            }

$set=0;
$result_array = array_diff($result_array, $student_sesssion_array);
  //  $fee_months = explode(",", $fee_month);
//  foreach($delete_student as $ds){
     
//       $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
//       $getdate_transport_hostel=$this->studentfeemaster_model->getdate_transport_fee($ds);//getdate_transport_hostel($ds);
//                     //  print_r($getdate_transport_hostel);
//                     //  exit();
//                     foreach ($student_due_fee as $key => $fee) {
//                         foreach ($fee->fees as $fee_key => $fee_value) {
//                             if(count($fee->fees)>=3){
//                                 //for($z=0;$z<count($fee_months);$z++){
//                                 if (in_array(explode(" ", $fee_value->code)[0], $getdate_transport_hostel) || in_array(explode(" ", $fee_value->typ)[0], $getdate_transport_hostel)) {
//                                     if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
//                                         //amount_detail
//                                       // $set=1;
//                                         $key = array_search($ds, $result_array);
//                     // echo $ds."<br>";
//                     //echo "if<br>";
                    
//                     // unset($result_array[$key]);
                    
//                 //echo "2 if";
//         //         $student              = $this->student_model->getByStudentSession($ds);
//         // break;
//                                     }
//                                 }
//                                 //}
//                             }
//                         }
//                     }
//                     unset($student_due_fee);
//                     unset($getdate_transport_hostel);
                   


//  }
// print_r($student_sesssion_array);
// print_r($delete_student);
// print_r($result_array);
 foreach($delete_student as $ds){
     
      $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
      $getdate_transport_hostel=$this->studentfeemaster_model->getdate_transport_fee($ds);//getdate_transport_hostel($ds);
                    //  print_r($getdate_transport_hostel);
                    // exit();
                    foreach ($student_due_fee as $key => $fee) {
                        foreach ($fee->fees as $fee_key => $fee_value) {
                            if(count($fee->fees)>=3){
                               // for($z=0;$z<count($fee_months);$z++){
                                if (in_array(explode(" ", $fee_value->code)[0], $getdate_transport_hostel) || in_array(explode(" ", $fee_value->typ)[0], $getdate_transport_hostel)) {
                                  if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
                                        //amount_detail
                                       // $set=1;
                //echo "2 if";
                $student              = $this->student_model->getByStudentSession($ds);
                $set=1;
        break;
                                    }
                                }
                                //}
                            }
                        }
                    }
                    unset($student_due_fee);
                    unset($getdate_transport_hostel);
                   


 }



        if($set==0)
        {
// }
            $preserve_record = array();
            if (!empty($student_sesssion_array)) {
                foreach ($student_sesssion_array as $key => $value) {
//                     $this->db->select('student_id');
// $this->db->from('student_session');
// $this->db->where('student_session.id', $value);
// $query = $this->db->get();

// $students = $query->result();
     //print_r($students);
    //  foreach ($students as $result){
                    
    //                 $student_due_fee     = $this->student_model->getRecentRecord($result->student_id);//$value
    //                 //$student_due_fee['route_fees']
    //                 if($student_due_fee['route_id']==0 && $student_due_fee['route_fees']==0)
    //                 {
     $route_fees_month_array    = $this->studentfeemaster_model->getdate_transport_fee($value,'',1);//
    //  print_r($route_fees_month_array);
    //  exit();
     if($route_fees_month_array!=1){
                    $insert_array = array(
                        'student_session_id'   => $value,
                        'route_id' =>$route_id,
                        //'route_fees'=>$route_fees,
                        'vehroute_id'=>$vehroute_id,
                        'session_id' => $this->setting_model->getCurrentSession(),
                        'transport_route_created_at'=>date('Y-m-d'),//date('Y')."-04-01",
                        // 'fee_session_group_id' => $fee_session_groups,
                    );
                    $this->studentfeemaster_model->addroute($insert_array);
                    //$inserted_id = $this->studentfeemaster_model->add($insert_array);
                    //print_r($inserted_id);
                    $preserve_record[] = $inserted_id;
                // }
                 }
            }
            }
            //exit();
            if (!empty($result_array)) { //$delete_student
                //$this->studentfeemaster_model->delete($fee_session_groups, $delete_student);
                
                $this->studentfeemaster_model->delete_route_id($result_array,$this->setting_model->getCurrentSession(),$route_id,$vehroute_id);
            }
           // print_r($result_array);
            $array = array('status' => 'success', 'error' => '', 'message' => $this->lang->line('success_message'));
            echo json_encode($array);
        }else{
            // $array = array('status' => 'fail', 'error' => '', 'message' => $this->lang->line('not_success_message'));//$this->lang->line('not_success_message'));
            // echo json_encode($array);
            
            $array = array('status' => 'fail', 'message' => "Revert The payment ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
            echo json_encode($array);
        }
        if ($set_r==1) {
            # code...
            // $array = array('status' => 'fail', 'message' => "First unchecked for other Route ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
            // echo json_encode($array);
        }
    //}
        }
    }


    //end routes


     //add addhostelroomfee 

     public function addhostelroomfee()
     {
         $this->form_validation->set_rules('fee_session_groups', $this->lang->line('fee_group'), 'required|trim|xss_clean');
 
         if ($this->form_validation->run() == false) {
             $data = array(
                 'fee_session_groups' => form_error('fee_session_groups'),
             );
             $array = array('status' => 'fail', 'error' => $data);
             echo json_encode($array);
         } else {
             $fee_groups_id          = $this->input->post('fee_groups_id');//fee_groups_id
             $student_session_id     = $this->input->post('student_session_id');
             $fee_session_groups     = $this->input->post('fee_session_groups');
 
             $hostel_room_id          = $this->input->post('hostel_room_id');//route_id
             $no_of_bed     = $this->input->post('no_of_bed');
             $hostel_id     = $this->input->post('hostel_id');
 
            // $transport_fees     = $this->input->post('transport_fees');
             $student_sesssion_array = isset($student_session_id)  ? $student_session_id : array();
             // $student_sesssion_array = isset($transport_fees)  ? $transport_fees : array();
             // $student_session_array = isset($student_session_id) ? ['student_session_id' => $student_session_id] : [];
 //             $student_session_array = isset($student_session_id) ? ['student_session_id' => $student_session_id] : [];
 //             //student_session_id[]
 // $transport_fees_array = isset($transport_fees) ? ['transport_fees' => $transport_fees] : [];
 
 
 // $student_sesssion_array_new=isset($result_array)  ? $result_array : array();
             $student_ids            = $this->input->post('student_ids');
             if(isset($student_sesssion_array) && !empty($student_sesssion_array)){
             $delete_student         = array_diff($student_ids, $student_sesssion_array);
             }else{
                $delete_student=$student_ids;
             }
             // Combining both arrays
             if(isset($student_session_id) && !empty($student_session_id)){
  $result_array = array_merge($delete_student , $student_session_id);
             }else{
                $result_array=$delete_student;

             }
 //print_r($delete_student);
 //print_r($student_session_id);
 // echo $fee_session_groups;
 //print_r($student_sesssion_array);
 // $delete_student = array_merge($student_ids, $student_sesssion_array);
 // $delete_student = array_unique($delete_student);
 $set=0;
 $count_stu=0;
 $result_array = array_diff($result_array, $student_sesssion_array);
    $fee_months = explode(",", $fee_month);
 foreach($delete_student as $ds){
     
      $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
      $getdate_transport_hostel=$this->studentfeemaster_model->getdate_hostel_fee($ds);//getdate_transport_hostel($ds);
                    //  print_r($getdate_transport_hostel);
                    //  exit();
                    foreach ($student_due_fee as $key => $fee) {
                        foreach ($fee->fees as $fee_key => $fee_value) {
                            if(count($fee->fees)>=3){
                                //for($z=0;$z<count($fee_months);$z++){
                                if (in_array(explode(" ", $fee_value->code)[0], $getdate_transport_hostel) || in_array(explode(" ", $fee_value->typ)[0], $getdate_transport_hostel)) {
                                    if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
                                        //amount_detail
                                        
                                       // $set=1;
                                        $key = array_search($ds, $result_array);
                    // echo $ds."<br>";
                    //echo "if<br>";
                    
                     //unset($result_array[$key]);
                     
                     $count_stu=$count_stu+1;
                //echo "2 if";
        //         $student              = $this->student_model->getByStudentSession($ds);
        // break;
                                    }
                                }
                                //}
                            }
                        }
                    }
                    unset($student_due_fee);
                    unset($getdate_transport_hostel);
                   


 }
 
 foreach($delete_student as $ds){
     
      $student_due_fee=$this->studentfeemaster_model->getstudentfees($ds);
      $getdate_transport_hostel=$this->studentfeemaster_model->getdate_hostel_fee($ds);//getdate_transport_hostel($ds);
                    // print_r($student_due_fee);
                    // exit();
                    foreach ($student_due_fee as $key => $fee) {
                        foreach ($fee->fees as $fee_key => $fee_value) {
                            if(count($fee->fees)>=3){
                               // for($z=0;$z<count($fee_months);$z++){
                                if (in_array(explode(" ", $fee_value->code)[0], $getdate_transport_hostel) || in_array(explode(" ", $fee_value->typ)[0], $getdate_transport_hostel)) {
                                  if($fee_value->amount_detail!=0 && $fee_value->amount_detail>0){
                                        //amount_detail
                                       // $set=1;
                //echo "2 if";
                $student              = $this->student_model->getByStudentSession($ds);
        break;
                                    }
                                }
                                //}
                            }
                        }
                    }
                    unset($student_due_fee);
                    unset($getdate_transport_hostel);
                   


 }
 
 //print_r($result_array);
 // print_r($delete_student);
 // if (!empty($result_array)) {
 //     foreach ($result_array['student_session_id'] as $key => $student_session_id) {
 //         $transport_fees = $result_array['transport_fees'][$key];
 //     if($transport_fees!=0.00){
 
     
 //         $data = array(
 //             'student_session_id' => $student_session_id,
 //             'transport_fees' => $transport_fees,
 //             'fee_groups_id' => $fee_groups_id,
 //             // Add more columns and their new values as needed
 //         );
     
 //         $this->studentfeemaster_model->stud_update($data);
 //     }
 // }
     
 // }
 
         if($set==0)
         {
 // }
             $preserve_record = array();
             if (!empty($student_sesssion_array)) {
                
                 foreach ($student_sesssion_array as $key => $value) { 
//                      $this->db->select('student_id');
// $this->db->from('student_session');
// $this->db->where('student_session.id', $value);
// $query = $this->db->get();

// $students = $query->result();
//      //print_r($students);
//      foreach ($students as $result) {
//                      $student_due_fee     = $this->student_model->getRecentRecord($result->student_id); //$value
//                      //$student_due_fee['route_fees']
//                      //no_of_bed hostel_room_id

//                      if($student_due_fee['hostel_room_id']==0 && $student_due_fee['hostel_fees']==0 && $no_of_bed>$count_stu)
//                      {
if($no_of_bed>$count_stu){
    $hostel_fees_month_array    = $this->studentfeemaster_model->getdate_hostel_fee($value,'',1);//
     //print_r($route_fees_month_array);
    // echo "<br>".$hostel_fees_month_array!=1;
    // exit();
     if($hostel_fees_month_array!=1){
                        $count_stu=$count_stu+1;
                     $insert_array = array(
                         'student_session_id'   => $value,
                         'hostel_room_id' =>$hostel_room_id,
                         //'hostel_fees'=>$hostel_fees,
                         'hostel_id'=>$hostel_id,
                         'session_id' => $this->setting_model->getCurrentSession(),
                        'hostel_room_created_at'=>date('Y-m-d'),
                         // 'fee_session_group_id' => $fee_session_groups,
                     );
                     
                     $this->studentfeemaster_model->addroom($insert_array);

                     //$inserted_id = $this->studentfeemaster_model->add($insert_array);
                     //print_r($inserted_id);
                     $preserve_record[] = $inserted_id;
     }
                 }
                //  }else{
                //   // break;
                //  }
                //  }
             }
             }
             if (!empty($result_array)) { //$delete_student
                 //$this->studentfeemaster_model->delete($fee_session_groups, $delete_student);
                 $this->studentfeemaster_model->delete_room_id($result_array,$this->setting_model->getCurrentSession(),$hostel_id,$hostel_room_id); //$this->setting_model->getCurrentSession(),$route_id,$vehroute_id
             }
 
             $array = array('status' => 'success', 'error' => '', 'message' => $this->lang->line('success_message'));
             echo json_encode($array);
         }else{
             // $array = array('status' => 'fail', 'error' => '', 'message' => $this->lang->line('not_success_message'));//$this->lang->line('not_success_message'));
             // echo json_encode($array);
             
             $array = array('status' => 'fail', 'message' => "Revert The payment ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
             echo json_encode($array);
         }
         if ($set_r==1) {
             # code...
             // $array = array('status' => 'fail', 'message' => "First unchecked for other Route ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
             // echo json_encode($array);
         }
     //}
         }
     }
 
 
     //end addhostelroomfee




    public function addfeegroup()
    {
        $this->form_validation->set_rules('fee_session_groups', $this->lang->line('fee_group'), 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'fee_session_groups' => form_error('fee_session_groups'),
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $fee_groups_id          = $this->input->post('fee_groups_id');//fee_groups_id
            $student_session_id     = $this->input->post('student_session_id');
            $fee_session_groups     = $this->input->post('fee_session_groups');
            //$transport_fees     = $this->input->post('transport_fees');
            $student_sesssion_array = isset($student_session_id)  ? $student_session_id : array();
            // $student_sesssion_array = isset($transport_fees)  ? $transport_fees : array();
            // $student_session_array = isset($student_session_id) ? ['student_session_id' => $student_session_id] : [];
            //$student_session_array = isset($student_session_id) ? ['student_session_id' => $student_session_id] : [];
            //student_session_id[]
// $transport_fees_array = isset($transport_fees) ? ['transport_fees' => $transport_fees] : [];

// Combining both arrays
//$result_array = array_merge($student_session_array , $transport_fees_array);
// $student_sesssion_array_new=isset($result_array)  ? $result_array : array();
            $student_ids            = $this->input->post('student_ids');
            if(!empty($student_sesssion_array)){
                $delete_student         = array_diff($student_ids, $student_sesssion_array);

            }else{
                $delete_student         = $student_ids;
            }
            
//print_r($delete_student);
//print_r($student_session_id);
// echo $fee_session_groups;
//print_r($student_sesssion_array);
// $delete_student = array_merge($student_ids, $student_sesssion_array);
// $delete_student = array_unique($delete_student);
$set=0;
if(count($student_sesssion_array)>0){
    foreach($student_session_id as $ds){
    $student_due_fee     = $this->studentfeemaster_model->getStudentFees($ds);
    //print_r($student_due_fee);
    //print_r($student_due_fee[0]->fees[0]->amount_detail); //0
    //print_r($student_due_fee);
    //print_r($student_due_fee);
    //print_r($student_due_fee);
 
    for($i=0;$i<count($student_due_fee);$i++){
        
        for($j=0;$j<count($student_due_fee[$i]->fees);$j++){
           
            if($student_due_fee[$i]->fees[$j]->amount_detail!=0){
                
                // echo count($student_due_fee[$i]->fees);
                // echo count($student_due_fee[$i]->fees)>=1 &&  in_array($student_due_fee[$i]->student_session_id, $student_session_id);
                // echo "new <br>";
                //fee_session_groups
                //fee_groups_id
                //echo $student_due_fee[$i]->fee_groups_id."<br>";&&  in_array($student_due_fee[$i]->student_session_id, $student_session_id)
                if(count($student_due_fee[$i]->fees)>=1){ //&& $fee_session_groups==$student_due_fee[$i]->fee_session_group_id
                   // $set=1;
                
                    $student              = $this->student_model->getByStudentSession($ds);
           // break;

                }
                
            }
            //print_r($student_due_fee[$i]['fees']);

        }
        //print_r($student_due_fee[$i]);
    } 
    //print_r($student_due_fee);  
}
}
//else{
foreach($delete_student as $ds){
    $student_due_fee     = $this->studentfeemaster_model->getStudentFees($ds);
    //print_r($student_due_fee[0]->fees[0]->amount_detail); //0
    //print_r($student_due_fee);
    //print_r($student_due_fee);
    //print_r($student_due_fee);
 
    for($i=0;$i<count($student_due_fee);$i++){
        
        for($j=0;$j<count($student_due_fee[$i]->fees);$j++){
           
            if($student_due_fee[$i]->fees[$j]->amount_detail!=0){
                
                // echo count($student_due_fee[$i]->fees);
                // echo count($student_due_fee[$i]->fees)>=1 &&  in_array($student_due_fee[$i]->student_session_id, $student_session_id);
                // echo "new <br>";
                //fee_session_groups
                //fee_groups_id
                // print_r($student_due_fee[$i]);
                // echo "new <br>";
                // echo $student_due_fee[$i]->fee_session_group_id;
                //  echo "new <br>";
                 
                //echo $student_due_fee[$i]->fee_groups_id."<br>";
                //echo $student_due_fee[$i]->fee_groups_id."<br>";&&  in_array($student_due_fee[$i]->student_session_id, $student_session_id)
                if(count($student_due_fee[$i]->fees)>=1 && $fee_session_groups==$student_due_fee[$i]->fee_session_group_id){ //&& $fee_session_groups==$student_due_fee[$i]->fee_groups_id
                    $set=1;
                
                    $student              = $this->student_model->getByStudentSession($ds);
            break;

                }
                
            }
            //print_r($student_due_fee[$i]['fees']);

        }
        //print_r($student_due_fee[$i]);
    } 
    //print_r($student_due_fee);  
}
//}
// echo $set;
//print_r($student_sesssion_array);
// foreach($delete_student as $ds){
//     $student_due_fee     = $this->studentfeemaster_model->getStudentFees($ds);
//     //print_r($student_due_fee[0]->fees[0]->amount_detail); //0
//     //print_r($student_due_fee);
//     for($i=0;$i<count($student_due_fee);$i++){
        
//         for($j=0;$j<count($student_due_fee[$i]->fees);$j++){
//             if($student_due_fee[$i]->fees[$j]->amount_detail!=0){
//                 // print_r($student_due_fee[$i]->fees);
//                 // echo count($student_due_fee[$i]->fees);
//                 // echo "new <br>";
//                 //fee_session_groups
//                 //fee_groups_id
//                 if(count($student_due_fee[$i]->fees)>1 && $fee_session_groups!=$student_due_fee[$i]->fee_groups_id){
//                     $set=1;
                
//                     $student              = $this->student_model->getByStudentSession($ds);
//             break;

//                 }
                
//             }
//             //print_r($student_due_fee[$i]['fees']);

//         }
//         //print_r($student_due_fee[$i]);
//     } 
//     //print_r($student_due_fee);  
// }
// for($i=0;$i<=count($delete_student);$i){
//     $student_due_fee     = $this->studentfeemaster_model->getStudentFees($delete_student[$i]);
//print_r($result_array);
// print_r($delete_student);
// if (!empty($result_array)) {
//     foreach ($result_array['student_session_id'] as $key => $student_session_id) {
//         $transport_fees = $result_array['transport_fees'][$key];
//     if($transport_fees!=0.00){

    
//         $data = array(
//             'student_session_id' => $student_session_id,
//             'transport_fees' => $transport_fees,
//             'fee_groups_id' => $fee_groups_id,
//             // Add more columns and their new values as needed
//         );
    
//         $this->studentfeemaster_model->stud_update($data);
//     }
// }
    
// }

        if($set==0)
        {
// }
            $preserve_record = array();
            if (!empty($student_sesssion_array)) {
                foreach ($student_sesssion_array as $key => $value) { 
                    $insert_array = array(
                        'student_session_id'   => $value,
                        'fee_session_group_id' => $fee_session_groups,
                    );
                    $inserted_id = $this->studentfeemaster_model->add($insert_array);
                    //print_r($inserted_id);
                    $preserve_record[] = $inserted_id;
                }
            }
            if (!empty($delete_student)) {
                $this->studentfeemaster_model->delete($fee_session_groups, $delete_student);
               // $this->studentfeemaster_model->delete_tFee_fee_id($delete_student);
            }

            $array = array('status' => 'success', 'error' => '', 'message' => $this->lang->line('success_message'));
            echo json_encode($array);
        }else{
            // $array = array('status' => 'fail', 'error' => '', 'message' => $this->lang->line('not_success_message'));//$this->lang->line('not_success_message'));
            // echo json_encode($array);
            
            $array = array('status' => 'fail', 'message' => "Revert The payment ". $this->customlib->getFullName($student['firstname'], $student['middlename'], $student['lastname'], $sch_setting->middlename, $sch_setting->lastname));
            echo json_encode($array);
        }
        }
    }

    public function geBalanceFee()
    {
        $this->form_validation->set_rules('fee_groups_feetype_id', $this->lang->line('fee_groups_feetype_id'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_fees_master_id', 'student_fees_master_id', 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_session_id', 'student_session_id', 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'fee_groups_feetype_id'  => form_error('fee_groups_feetype_id'),
                'student_fees_master_id' => form_error('student_fees_master_id'),
                'student_session_id' => form_error('student_session_id'),
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $data                   = array();
            $student_session_id     = $this->input->post('student_session_id');
            $fee_groups_feetype_id  = $this->input->post('fee_groups_feetype_id');
            $student_fees_master_id = $this->input->post('student_fees_master_id');
            $fee_group_count = $this->input->post('fee_group_count');
            $remain_amount_object   = $this->getStuFeetypeBalance($fee_groups_feetype_id, $student_fees_master_id,$student_session_id,$fee_group_count);
            $discount_not_applied   = $this->getNotAppliedDiscount($student_session_id);
            $remain_amount          = json_decode($remain_amount_object)->balance;
            $remain_amount_fine     = json_decode($remain_amount_object)->fine_amount;

            $array = array('status' => 'success', 'error' => '', 'balance' => $remain_amount, 'discount_not_applied' => $discount_not_applied, 'remain_amount_fine' => $remain_amount_fine);
            echo json_encode($array);
        }
    }

    public function getStuFeetypeBalance($fee_groups_feetype_id, $student_fees_master_id,$student_session_id=null,$fee_group_count=null)
    {
        $data                           = array();
        $data['fee_groups_feetype_id']  = $fee_groups_feetype_id;
        $data['student_fees_master_id'] = $student_fees_master_id;
        $data['student_session_id']     = $student_session_id;
        $result                         = $this->studentfeemaster_model->studentDeposit($data);
        $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student_session_id);
        //$newArray    = $this->studentfeemaster_model->getdate_transport_hostel($student_session_id);//$routefees
        $newArray    = $this->studentfeemaster_model->getdate_transport_fee($student_session_id);//$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student_session_id);
        //$newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel($student_session_id);// $hostelfees
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($student_session_id);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student_session_id);
        //return print_r($result);
        //return print_r($miscellaneousfees);
        $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'];
}
        $amount_balance                 = 0;
        $amount                         = 0;
        $amount_fine                    = 0;
        $amount_discount                = 0;
        $fine_amount                    = 0;
        $fee_fine_amount                = 0;
        $due_amt                        = $result->amount;
        //$transport_fees                 =$result->transport_fees;
        if (strtotime($result->due_date) < strtotime(date('Y-m-d'))) {
            $fee_fine_amount = $result->fine_amount;
        }

        if ($result->is_system) {
            $due_amt = $result->student_fees_master_amount;
        }

        $amount_detail = json_decode($result->amount_detail);
        if (is_object($amount_detail)) {

            foreach ($amount_detail as $amount_detail_key => $amount_detail_value) {
                $amount          = $amount + $amount_detail_value->amount;
                if(!empty($amount_detail_value->amount_discount)){
                $amount_discount = $amount_discount + $amount_detail_value->amount_discount;
                }
                $amount_fine     = $amount_fine + $amount_detail_value->amount_fine;
            }
        }
        // if (empty($result->amount_detail) && ($result->due_date != "0000-00-00" && $result->due_date != null) && (strtotime($result->due_date) < strtotime(date('Y-m-d')))) 
        // {
        //     $fee_fine_amount = $result->fine_amount;
        // }
        // if (!empty($result->amount_detail) && $fee_fine>=0 && ($result->due_date != "0000-00-00" && $result->due_date != null) && (strtotime($result->due_date) < strtotime(date('Y-m-d'))))
        // {
        //     $fee_fine_amount = $amount_fine;
        // }
        // if(!empty($result->amount_detail) && $amount_fine>=0){
        //     $fee_fine_amount=0;
        // }
// if($result->fee_group_name!="Balance Master" && isset($student_session_id) && $student_session_id!=null && $result->id==$result->fee_groups_id){
//     $amount_balance = ($due_amt+$result->transport_fees) - ($amount + $amount_discount);
// }else{
    // if($result->fee_group_name!="Balance Master" && !empty($result->transport_fees)){
    //     $amount_balance = ($due_amt+$result->transport_fees) - ($amount + $amount_discount);

    // }else{
        if($fee_group_count!=null && !empty($fee_group_count)){
            $result->amount=$result->amount-1;
            if($fee_group_count>=3){
                if($result->fee_group_name=="Balance Master"){
                    $amount_balance = $due_amt - ($amount + $amount_discount);
              
                
            }else{
                
                $f_months=0;
                if(!empty($cmm)){
        for($i=0;$i<count($cmm);$i++){
            
            $new_cmm=explode(",",$cmm[$i]);
            
            if(in_array(explode(' ', $result->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            }
            // echo explode(' ', $result->code)[0]."<br>";
            // print_r($new_cmm);
            // echo "<br>new =>".$f_months."<br>";
        }
            }
            if(!empty($newArray)){
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $result->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(' ', $result->code)[0], $newArray_hostel[$i])){
                 $f_months+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
        }

// if(in_array(explode(' ', $result->code)[0], $newArray) && in_array(explode(' ', $result->code)[0], $newArray_hostel)){
//     //             $total_amount          = $total_amount + $fee_value->amount+$fee_value->fare+$fee_value->cost_per_bed+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->fare+$fee_value->cost_per_bed+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed']+$f_months) - ($amount + $amount_discount);
//         }elseif(in_array(explode(' ', $result->code)[0], $newArray) && !(in_array(explode(' ', $result->code)[0], $newArray_hostel))){
//     //           $total_amount          = $total_amount + $fee_value->amount+$fee_value->fare+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->fare+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$route_fees[0]['fare']+$f_months) - ($amount + $amount_discount);
    
//         }elseif(!(in_array(explode(' ', $result->code)[0], $newArray)) && in_array(explode(' ', $result->code)[0], $newArray_hostel)){
//     //           $total_amount          = $total_amount + $fee_value->amount+$fee_value->cost_per_bed+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->cost_per_bed+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$hostel_fees[0]['cost_per_bed']+$f_months) - ($amount + $amount_discount);
//         }
//         else{
//     //             $total_amount          = $total_amount + $fee_value->amount+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$result->amount+$f_months) - ($amount + $amount_discount);
    
            
//         }
$amount_balance = ($due_amt+$result->amount+$f_months) - ($amount + $amount_discount);
        $amount_balance=intval($amount_balance)-1;
                //echo $result->amount+$result->cost_per_bed+$f_months+$result->fare."<br>";
                // $amount_balance = ($due_amt+$result->fare+$result->cost_per_bed+$MFfare) - ($amount + $amount_discount);
            }

            }else{
            $amount_balance = $due_amt - ($amount + $amount_discount);
                
            }
        }
        else{
            if($result->fee_group_name=="Balance Master"){
                $amount_balance = $due_amt - ($amount + $amount_discount);
              
                
            }
            else{
                            $f_months=0;
        for($i=0;$i<count($cmm);$i++){
            
            $new_cmm=explode(",",$cmm[$i]);
            
            if(in_array(explode(' ', $result->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            }
        }
        if(!empty($newArray)){
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $result->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(' ', $result->code)[0], $newArray_hostel[$i])){
                 $f_months+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
        }

// if(in_array(explode(' ', $result->code)[0], $newArray) && in_array(explode(' ', $result->code)[0], $newArray_hostel)){
//     //             $total_amount          = $total_amount + $fee_value->amount+$fee_value->fare+$fee_value->cost_per_bed+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->fare+$fee_value->cost_per_bed+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed']+$f_months) - ($amount + $amount_discount);
//         }elseif(in_array(explode(' ', $result->code)[0], $newArray) && !(in_array(explode(' ', $result->code)[0], $newArray_hostel))){
//     //           $total_amount          = $total_amount + $fee_value->amount+$fee_value->fare+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->fare+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$route_fees[0]['fare']+$f_months) - ($amount + $amount_discount);
    
//         }elseif(!(in_array(explode(' ', $result->code)[0], $newArray)) && in_array(explode(' ', $result->code)[0], $newArray_hostel)){
//     //           $total_amount          = $total_amount + $fee_value->amount+$fee_value->cost_per_bed+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$fee_value->cost_per_bed+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$hostel_fees[0]['cost_per_bed']+$f_months) - ($amount + $amount_discount);
//         }
//         else{
//     //             $total_amount          = $total_amount + $fee_value->amount+$f_months;//$MFfare
//     // $feetype_balance       = ($fee_value->amount+$f_months) - ($fee_paid + $fee_discount);//$MFfare
//     $amount_balance = ($due_amt+$result->amount+$f_months) - ($amount + $amount_discount);
    
            
//         }
$amount_balance = ($due_amt+$result->amount+$f_months) - ($amount + $amount_discount);
                $amount_balance=intval($amount_balance)-1;
       // $amount_balance = ($due_amt+$result->fare+$result->cost_per_bed+$MFfare) - ($amount + $amount_discount);
            }
}
    //}
    
//}
// if($amount_discount>0){
//     $amount_balance=$amount_balance+$amount_discount;
// }
        
        // $fine_amount    = abs($amount_fine - $fee_fine_amount);
        //echo (!empty($result->amount_detail) && $amount_fine>=0)."<br>";
        if(!empty($result->amount_detail) && $amount_fine>=0){
            $fine_amount=0;
        }else{
            $fine_amount    = abs($amount_fine - $fee_fine_amount);
        }
        
        
        $array          = array('status' => 'success', 'error' => '', 'balance' => $amount_balance, 'fine_amount' => $fine_amount);
        return json_encode($array);
    }

    public function check_deposit($amount)
    {
        if (is_numeric($this->input->post('amount')) && is_numeric($this->input->post('amount_discount'))) {
            if ($this->input->post('amount') != "" && $this->input->post('amount_discount') != "") {
                if ($this->input->post('amount') < 0) {
                    $this->form_validation->set_message('check_deposit', $this->lang->line('deposit_amount_can_not_be_less_than_zero'));
                    return false;
                } else {
                    $student_fees_master_id = $this->input->post('student_fees_master_id');
                    $fee_groups_feetype_id  = $this->input->post('fee_groups_feetype_id');
                    $student_session_id     = $this->input->post('student_session_id');
                    $deposit_amount         = $this->input->post('amount') + $this->input->post('amount_discount');
                    $remain_amount          = $this->getStuFeetypeBalance($fee_groups_feetype_id, $student_fees_master_id,$student_session_id);
                    $remain_amount          = json_decode($remain_amount)->balance;
                    if ($remain_amount < $deposit_amount) {
                        $this->form_validation->set_message('check_deposit', $this->lang->line('deposit_amount_can_not_be_greater_than_remaining'));
                        return false;
                    } else {
                        return true;
                    }
                }
                return true;
            }
        } elseif (!is_numeric($this->input->post('amount'))) {

            $this->form_validation->set_message('check_deposit', $this->lang->line('amount') . " " . $this->lang->line('field_must_contain_only_numbers'));

            return false;
        } elseif (!is_numeric($this->input->post('amount_discount'))) {

            return true;
        }

        return true;
    }

    public function getNotAppliedDiscount($student_session_id)
    {
        return $this->feediscount_model->getDiscountNotApplied($student_session_id);
    }

    public function addfeegrp()
    {
// //         // Retrieve the JSON string from the POST data
//  $tableDataJson = $_POST['tableData'];

// // // Decode the JSON string into a PHP associative array
//  $tableDataArray = json_decode($tableDataJson, true);



// foreach ($tableDataArray as $month => $details) {
    
//     $json_array = [
//         'amount' => intval($details['received']),
//         'date' => date('Y-m-d', strtotime($_POST['collected_date'] ?? 'now')),
//         'description' => ($_POST['fee_gupcollected_note'] ?? '') . ($_POST['collected_by'] ?? ''),
//         'amount_discount' => intval($details['discount']),
//         'amount_fine' => intval($details['fine']),
//         'payment_mode' => $_POST['payment_mode_fee'] ?? 'Cash',
//         'received_by' => $staff_record['id'],
//         'total' => intval($details['total'])
//     ];
            
//   //print_r($details);

//     // Main categories to be processed (like CLASS 9TH TO 10TH, DAY BOARDING FEE, etc.)
//     foreach ($details as $key => $value) {
       
//                 // print_r($value);
//               // echo $value['amount']."<br><br>";//total_amount
       
//     //   if ($temp==0 && is_numeric($value) && intval($value)>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
//     if (is_numeric($value['amount']) && is_numeric($value['total_amount']) && intval($value['amount'])>=0 && intval($value['total_amount'])>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
        
            
    
//             // Adding fee category details to json_array under respective category name
//             $json_array[$key] = [
//                 'total_amount' => $value['total_amount'],
//                 // 'amount_discount' => $amount_discount,
//                 'amount' => $value['amount']
//             ];

//             // Accumulate total amount
//           // $main_total_amount += $amount + $amount_discount;
            
            
//         }
       
        
            
    
// }
//      // $temp=0;
//     // Add processed data for each month into collected_array and collected_new_array
//     $collected_array[] = [
//         'student_fees_master_id' => $details['student_fees_master_id']['value'],
//         'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['value'],
//          //'month'=>$month,
//         'amount_detail' => $json_array
//     ];

//     $collected_new_array[] = [
//         'student_fees_master_id' => $details['student_fees_master_id']['value'],
//         'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['value'],
//         'fee_session_group_id' => $details['fee_session_groups_id']['value'],
//         'fee_group_count' => $details['fee_group_count']['value'],
//         'thf' => $details['thf']['value'],
//         'amount_detail' => $json_array
//     ];
//     // print_r($collected_array);
// }



//         exit();
        $staff_record = $this->session->userdata('admin');
        $this->form_validation->set_error_delimiters('', '');
        //$this->form_validation->set_rules('row_counter[]', $this->lang->line('fees_list'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('collected_date', $this->lang->line('date'), 'required|trim|xss_clean');
        //$this->form_validation->set_rules('receive_amount',$this->lang->line('total') . " " . $this->lang->line('pay'),'required|trim|xss_clean');
       $this->form_validation->set_rules('tableData','tableData','required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                //'row_counter'    => form_error('row_counter'),
                'collected_date' => form_error('collected_date'),
                'tableData' => form_error('tableData'),
                //'receive_amount'=> form_error('receive_amount'),
            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {
//             echo $this->input->post('collected_date')."<br>";
//             $date = $this->input->post('collected_date'); // Assuming '03/22/2024'
//             $date = str_replace('/', '-', $date);
//             echo $date."<br>";
// $timestamp = $this->customlib->datetostrtotime($date); // Convert date to timestamp
// $formattedDate = date('Y-m-d', $date); // Format timestamp to 'Y-m-d'

// echo $formattedDate."<br>"; // Output: '2024-03-22'
//             echo date('Y-m-d', $this->input->post('collected_date'));
//             exit();

 //$this->input->post('collected_date') = str_replace('/', '-', $this->input->post('collected_date'));
  // Retrieve the JSON string from the POST data
$tableDataJson = $_POST['tableData'];

// Decode the JSON string into a PHP associative array
$tableDataArray = json_decode($tableDataJson, true);


            $collected_array = array();
            $collected_new_array = array();
            $collected_by    = " Collected By: " . $this->customlib->getAdminSessionUserName();

            $send_to            = $this->input->post('guardian_phone');
            $email              = $this->input->post('guardian_email');
            $parent_app_key     = $this->input->post('parent_app_key');
            $student_session_id = $this->input->post('student_session_id');
            $student_session_id = $this->input->post('student_session_id');
            
            
            $mobileno = $this->input->post('mobileno');
            
            
            
//             $admission_no = $this->input->post('admission_no');
//             $mobileno = $this->input->post('mobileno');
//             function generateSecretKey($admission_no, $salt, $iterations = 10000, $length = 32, $algorithm = 'sha256')
// {
//     // Use PBKDF2 to derive a key from the username and salt
//     $key = hash_pbkdf2($algorithm, $admission_no, $salt, $iterations, $length, true);

//     // Encode the derived key as a base64 string
//     return base64_encode($key);
// }

// // Example usage:
// //$username = 'abc';
// $salt = 'random_salt';

// $secretKey = generateSecretKey($admission_no, $salt);
// function encryptUserID($admission_no, $key) {
//     $cipher_method = 'AES-256-CBC';
//     $iv_length = openssl_cipher_iv_length($cipher_method);
//     $iv = openssl_random_pseudo_bytes($iv_length);

//     $encrypted = openssl_encrypt($admission_no, $cipher_method, $key, 0, $iv);

//     return base64_encode($iv . $encrypted);
// }

// // Replace 'your_secret_key' with a strong secret key for encryption
// //$secretKey = 'your_secret_key';
// //$userID = 10;//$_GET['userid'];
// if (isset($admission_no)) {
    
//     $encryptedUserID = encryptUserID($admission_no, $secretKey);
//     //echo $encryptedUserID;
// } else {
//     $encryptedUserID =0;//'Invalid Request';
// }
            
            
            // if($frn==1){
            // //add fee_receipt_no table id and get that id
            //  $fee_receipt_no_get_id = $this->studentfeemaster_model->fee_receipt_no_get_id();
            // }
            //  print_r($fee_receipt_no_get_id);
            // exit();
            
                $temp_error=0;
                    $main_total_amount = 0;
            foreach ($tableDataArray as $month => $details) {
    if(intval($details['received'])>=0 || intval($details['discount'])>0)
    {
     $json_array = [
        'amount' => intval($details['received']),
        'date' => date('Y-m-d', strtotime($_POST['collected_date'] ?? 'now')),
        'description' => ($_POST['fee_gupcollected_note'] ?? '') . ($_POST['collected_by'] ?? ''),
        'amount_discount' => intval($details['discount']),
        'amount_fine' => intval($details['fine']),
        'payment_mode' => $_POST['payment_mode_fee'] ?? 'Cash',
        'received_by' => $staff_record['id'],
        'total' => intval($details['total'])
    ];
    //         $main_discount = intval($details['discount']);
    //         $main_received = intval($details['received']);
    //         $categories_discount=0;
    //         $categories_received=0;
    //   $temp=0;
   

    // // Main categories to be processed (like CLASS 9TH TO 10TH, DAY BOARDING FEE, etc.)
    // foreach ($details as $key => $value) {
    // //   if ($temp==0 && is_numeric($value) && intval($value)>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
    // if (is_numeric($value) && intval($value)>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
        
    //         //  $category_amount = $value;
            
    //         // $amount_discount = 0;
    //         // $amount = 0;

    //         // // Applying conditions for amount and amount_discount based on the 3 cases
    //         // if ((($main_discount-$categories_discount) - $category_amount) >= 0) {
    //         //     $amount_discount = $category_amount;
    //         //     $amount = 0;
    //         //     $categories_discount+=$category_amount;
    //         // } elseif ((($main_received-$categories_received) - $category_amount) >= 0) {
    //         //     $amount_discount = 0;
    //         //     $amount = $category_amount;
    //         //     $categories_received+=$category_amount;
    //         // } elseif (((($main_received + $main_discount)-($categories_discount+$categories_received)) - $category_amount) >= 0) {
    //         //     $amount_discount = $main_discount;
    //         //     $amount = $main_received;
    //         //     $categories_discount+=$category_amount;
    //         //     $categories_received+=$category_amount;
    //         // } else {
    //         //     $amount_discount = $main_discount-$categories_discount;
    //         //     $amount = $main_received-$categories_received;
    //         //     $categories_discount+=$main_discount-$categories_discount;
    //         //     $categories_received+=$main_received-$categories_received;
    //         //     $temp=1;
                
                
    //         // }
    
    //         // Adding fee category details to json_array under respective category name
    //         $json_array[$key] = [
    //             'total_amount' => $category_amount,
    //             // 'amount_discount' => $amount_discount,
    //             'amount' => $value
    //         ];

    //         // Accumulate total amount
    //       // $main_total_amount += $amount + $amount_discount;
            
            
    //     }
    //     // if($temp==1){
    //     //     break; // Stop loop  
    //     // }
        
            
    // }
    
     // Main categories to be processed (like CLASS 9TH TO 10TH, DAY BOARDING FEE, etc.)
    foreach ($details as $key => $value) {
       
                // print_r($value);
               // echo $value['amount']."<br><br>";//total_amount
       
    //   if ($temp==0 && is_numeric($value) && intval($value)>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
    if (is_numeric($value['amount']) && is_numeric($value['total_amount']) && intval($value['amount'])>=0 && intval($value['total_amount'])>0 && !in_array($key, ["received", "discount", "fine", "total", "balance"])) { // Process only numeric values for fee categories
        
            
    
            // Adding fee category details to json_array under respective category name
            $json_array[$key] = [
                'total_amount' => $value['total_amount'],
                // 'amount_discount' => $amount_discount,
                'amount' => $value['amount']
            ];

            // Accumulate total amount
           // $main_total_amount += $amount + $amount_discount;
            
            
        }
       
        
            
    
}
     // $temp=0;
    // Add processed data for each month into collected_array and collected_new_array
     if(intval($details['received'])>0 || intval($details['discount'])>0 ){
    $collected_array[] = [
        'student_fees_master_id' => $details['student_fees_master_id']['value'],
        'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['value'],
        // 'month'=>$month,
        'amount_detail' => $json_array
    ];

    $collected_new_array[] = [
        'student_fees_master_id' => $details['student_fees_master_id']['value'],
        'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['value'],
        'fee_session_group_id' => $details['fee_session_groups_id']['value'],
        'fee_group_count' => $details['fee_group_count']['value'],
        'thf' => $details['thf']['value'],
        'amount_detail' => $json_array
    ];
     }
}
   else{
                    
                     $array = array('status' => 0,'message'=>"Enter Greater Than Zero Receive Amount and Discount");
             echo json_encode($array);
             $temp_error=1;
             break;
                }

    // echo "<h3>Month: " . htmlspecialchars($month) . "</h3>";
    // echo "Total Amount for Month ($month): " . $main_total_amount . "<br><br>";
    // echo "received: " . intval($details['received']) . "<br>";
    // echo "discount: " . intval($details['discount']) . "<br>";
    // echo "fine: " . intval($details['fine']) . "<br>";
    // // echo "<pre>" . json_encode($json_array, JSON_PRETTY_PRINT) . "</pre><br><br>";
    // echo "<pre>" . json_encode($collected_array, JSON_PRETTY_PRINT) . "</pre><br>";
}

            
// Call the function
list($deposited_fees, $fee_receipt_no_id,$p_id) = $this->studentfeemaster_model->fee_deposit_collections($collected_array);

            //$deposited_fees = $this->studentfeemaster_model->fee_deposit_collections($collected_array);
            $fees_record    = json_decode($deposited_fees);
            
            //echo "<pre>" . print_r($deposited_fees) . "</pre><br>";
            //echo "<pre>" . print_r($fees_record) . "</pre><br>";
            //exit();

          // foreach ($tableDataArray as $month => $details) {
             $keys = array_values($tableDataArray);

for ($i = 0; $i < count($keys); $i++) {
    //$key = $keys[$i]; 
    // print_r($keys[$i]);
    // echo $i.'=='.$keys[$i]['fee_groups_feetype_id']['value']."<br>";
                $mailsms_array                 = $this->feegrouptype_model->getFeeGroupByID($keys[$i]['fee_groups_feetype_id']['value']);//$details['fee_groups_feetype_id']['value']
                $mailsms_array->invoice        = json_encode($fees_record[$i]);//->invoice_id
                $mailsms_array->contact_no     = $mobileno;//$send_to;
                $mailsms_array->email          = $email;
                $mailsms_array->parent_app_key = $parent_app_key;
                $this->mailsmsconf->mailsms('fee_submission', $mailsms_array);
                //exit();
            
           }
          // exit();
          // $array = array('status' => 1,'encryptedUserID'=>$encryptedUserID,'mobileno'=>$mobileno,'all_amount'=>$all_amount,'receive_amount'=>$receive_amount, 'error' => '','collected_new_array'=>$collected_new_array);
             if($temp_error==0){
              $array = array('status' => 1,'mobileno'=>$mobileno,'all_amount'=>$all_amount,'receive_amount'=>$receive_amount, 'error' => '','collected_new_array'=>$collected_new_array,'fee_receipt_no_id'=>$fee_receipt_no_id,'p_id'=>$p_id);
             echo json_encode($array);
}
            //echo json_encode($collected_new_array);
            // if(!empty($collected_new_array)){
            //    $this->printFeesByGroupArray(1,$collected_new_array);
            // }
                
            
            
            
        }
    }

    public function reportdailycollection()
    {
        if (!$this->rbac->hasPrivilege('fees_statement', '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/reportdailycollection');
        $data          = array();
        $data['title'] = 'Daily Collection Report';
        $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 = [];
//$fees_code = [];
$feetype = $this->feetype_model->get();
        $data['feetypeList'] = $feetype;

// Loop through each sub-array and add the 'name' to the $fees_head array
foreach ($feemasterList as $feegroup) {
    //print_r($feegroup->feetypes);
                                                
    if($feegroup->group_name!="TUITION FEE"){
    $fees_head[] = $feegroup->group_name;
    }
    // foreach ($feegroup->feetypes as $feetype_key => $feetype_value) {
    //                                                 //echo $feetype_value->code."<br>";
    //                                                 $fees_code[] = $feetype_value->code;
    //                                             }
     
}
$fees_head[]="Transport Fee";
$fees_head[]="Hostel Fee";
foreach ($miscellaneous as $item) {
    $fees_head[] = $item["miscellaneous_title"];
}
$data['fees_head'] = $fees_head;
//$data['fees_code'] = $fees_code;
        $this->form_validation->set_rules('date_from', $this->lang->line('date_from'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('date_to', $this->lang->line('date_to'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('fees_head_name', "Fees Head", 'trim|xss_clean'); //|required
        $this->form_validation->set_rules('fees_code_name', "Fees Code", 'trim|xss_clean'); //|required



        if ($this->form_validation->run() == true) {

            $date_from          = $this->input->post('date_from');
            $date_to            = $this->input->post('date_to');
            $fees_head_value = $this->input->post('fees_head_name');
            $fees_code_value = $this->input->post('fees_code_name');
            $data['fees_head_value'] = $fees_head_value;
            $data['fees_code_value'] = $fees_code_value;
            $formated_date_from = strtotime($this->customlib->dateFormatToYYYYMMDD($date_from));
            $formated_date_to   = strtotime($this->customlib->dateFormatToYYYYMMDD($date_to));
            $st_fees            = $this->studentfeemaster_model->getCurrentSessionStudentFees();
            $feegroup = $this->feegroup_model->get();
            $studnet_all   = $this->student_model->getStudents();
            
            // foreach ($feegroup as $item) {
            //     echo $item['name']."<br>";
            //   // echo "<br>";
            // }
            //print_r($feegroup);
            
        
            $fees_data=array();
            $fees_head_data=array();
            $fee_amount_count=array();
            $m_fee=0;
            $r_fee=0;
            $h_fee=0;

for ($i=$formated_date_from; $i <= $formated_date_to ; $i+=86400) {
   $fees_data[$i]['amt']=0;
   $fees_data[$i]['count']=0;
   $fees_data[$i]['student_fees_deposite_ids']=array();

}
if(empty($fees_head_value)){
if (!empty($studnet_all)) {
     //foreach ($studnet_all as $fee_key_1 => $fee_value_1) {
     foreach ($studnet_all as $student) {
                            $student_due_fee      = $this->studentfeemaster_model->getStudentFees($student['student_session_id']);
      
        $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees($student['student_session_id']);
        $miscellaneousfees_2    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student['student_session_id']));   //$New_student_session_id[0]

         //$newArray    = $this->studentfeemaster_model->getdate_transport_hostel($student['student_session_id']);//$routefees
         $newArray    = $this->studentfeemaster_model->getdate_transport_fee($student['student_session_id']);//$routefees
         $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student['student_session_id']);
       // $newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel($student['student_session_id']);// $hostelfees
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($student['student_session_id']);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student['student_session_id']);
// print_r($route_fees);
// print_r($hostel_fees);
//$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'];
}
unset($miscellaneousfees);

    foreach ($student_due_fee as $key => $fee) {
        
   

    foreach ($fee->fees as $fee_key => $fee_value) {
      
 //$result = 1;//(count($fee->fees) >= 12) ? in_array(explode(' ', $fee_value->code)[0], $newArray) : 1;

        // if($result)//( count($fee->fees) >= 12 ) ? ( $fee_key + 1 >= $mNumber ) : (1 )//$fee_key+1>=$mNumber)
        // { 
        // foreach ($newArray as $fee_key => $fee_value) { //$fee->fees
        

if(count($fee->fees)>=3 && !empty($fee_value->amount_detail)){
    
    //print_r($fee_value);
    // $total_amount          = $total_amount + $fee_value->amount;
    //echo $fee_paid+$fee_discount.'=='.$fee_value->amount."<br>";
    // if($fee_paid+$fee_discount==$fee_value->amount){
       
    // }else{

        $f_months=0;
        if(!empty($cmm)){
        for($i=0;$i<count($cmm);$i++){
            
            $new_cmm=explode(",",$cmm[$i]);
            
            if(in_array(explode(' ', $fee_value->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            }
        }
        }
        if (($fee_value->due_date != "0000-00-00" && $fee_value->due_date != null) && (strtotime($fee_value->due_date) < strtotime(date('Y-m-d')))) {
          
        //$f_months+=$fee_value->fine_amount;
}
        // if(in_array(explode(' ', $fee_value->code)[0], $newArray) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel)){
               
        // }elseif(in_array(explode(' ', $fee_value->code)[0], $newArray) && !(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel))){
              
        // }elseif(!(in_array(explode(' ', $fee_value->code)[0], $newArray)) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel)){
             
        // }
        // else{
        //     //$f_months
        // }

                                            //print_r($fee_value->fee_receipt_no_id);
                                            // if (!empty($fee_value->amount_detail)) {
   

                                                $fee_deposits = json_decode(($fee_value->amount_detail));
                                    
                                     //print_r($fee_deposits);
                                     $perv_fee=0;
                                     //$fine_set=0;
                                                foreach ($fee_deposits as $fee_deposits_key => $fee_deposits_value) {
                                                    
                                                                                       
                                    
                                                                                   
                                                                                       $date= strtotime(date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($fee_deposits_value->date))); 
                                                                                      // echo strtotime(date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($fee_deposits_value->date)))."<br>";
                                                                                      // $date = strtotime($this->customlib->dateFormatToYYYYMMDD($fee_deposits_value->date));
                                                                                       // $date = strtotime($fee_deposits_value->date);
        // echo $date .">=". $formated_date_from ."&&". $date ."<=". $formated_date_to."<br>";
                                                                                           // $paid_amount=0;
                                                                                           
                                                                                        //   if (($fee_deposits_value->date != "0000-00-00" && $fee_deposits_value->date != null) && (strtotime($fee_deposits_value->date) < strtotime(date('Y-m-d')))) {
                                                                                        //       $fine_set=1;
                                                                                        //   }
          
                                                                                        if ($date >= $formated_date_from && $date <= $formated_date_to) {

//$paid_amount= ((number_format($fee_deposits_value->amount, 2, '.', ''))+(number_format(intval($fee_deposits_value->amount_fine), 2, '.', ''))+(number_format(intval($fee_deposits_value->amount_discount), 2, '.', ''))); //amount_discount
 $perv_fee+= ((number_format($fee_deposits_value->amount, 2, '.', ''))+(number_format(intval($fee_deposits_value->amount_fine), 2, '.', ''))); //amount_discount
//echo $perv_fee."<br>";
                               $f_months+=intval($fee_deposits_value->amount_fine);                                                                
                                                                                           
                                                                                    
                                    }
                                            }
                                            unset($fee_deposits);
                                            // if($fine_set==1){
                                            //     $f_months+=$fee_value->fine_amount;
                                            // }
                                            if($perv_fee>0){
                                            //echo $perv_fee-$f_months.'==>'.$perv_fee.'=='.$f_months."<br>";
                                            $demo_route_fees=0;
                                            $demo_hostel_fees=0;
                                            if(!empty($newArray)){
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $fee_value->code)[0], $newArray[$i])){
                 $demo_route_fees+=$route_fees[$i]['fare'];
             }
         }
        }
        if(!empty($newArray_hostel)){
         for($i=0;$i<count($newArray_hostel);$i++){
             if(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel[$i])){
                 $demo_hostel_fees+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
        }
                                            if($perv_fee-$f_months>=0){
                                                           $m_fee+=$f_months;
                                                           if($perv_fee-$f_months>0){
                                                //               if(in_array(explode(' ', $fee_value->code)[0], $newArray) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel))
                                                //   {
                                                //               if($perv_fee-($f_months+$route_fees[0]['fare'])>=0)
                                                //               {
                                                //                   $r_fee+=$route_fees[0]['fare'];
                                                //                   if($perv_fee-($f_months+$route_fees[0]['fare'])>0)
                                                //                   {
                                                //                       if($perv_fee-($f_months+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed'])>=0)
                                                //                       {
                                                //                           $h_fee+=$hostel_fees[0]['cost_per_bed'];
                                                                           
                                                //                       }else{
                                                //                           $h_fee+=($perv_fee-($f_months+$route_fees[0]['fare']));//$hostel_fees[0]['cost_per_bed'];
                                                //                       }
                                                                       
                                                //                   }
                                                //               }
                                                //               else{
                                                //                   $r_fee+=($perv_fee-$f_months);//$route_fees[0]['fare'];
                                                //               }
                                                //           }
                                                //           else{
                                                               
                                                //               if((in_array(explode(' ', $fee_value->code)[0], $newArray) && !(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel))))
                                                //         {
                                                //             if($perv_fee-($f_months+$route_fees[0]['fare'])>=0){
                                                //             $r_fee+=$route_fees[0]['fare'];//($perv_fee-($f_months+$route_fees[0]['fare']));
                                                //             }else{
                                                //                 $r_fee+=($perv_fee-$f_months);
                                                //                  //$r_fee+=(($f_months+$route_fees[0]['fare'])-$perv_fee);
                                                //             }
                                                            
                                                //         }
                                                               
                                                //               if((!(in_array(explode(' ', $fee_value->code)[0], $newArray)) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel)))
                                                //         {
                                                //             if($perv_fee-($f_months+$hostel_fees[0]['cost_per_bed'])>=0){
                                                //             $h_fee+=$hostel_fees[0]['cost_per_bed'];//($perv_fee-($f_months+$hostel_fees[0]['cost_per_bed']));
                                                //             }else{
                                                //                 $h_fee+=($perv_fee-($f_months+$route_fees[0]['fare']));
                                                //                  //$h_fee+=(($f_months+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed'])-$perv_fee);
                                                                    
                                                //             }
                                                //         }
                                                //           }
                                                
                                                    if($demo_route_fees>0 && $demo_hostel_fees>0)
                                                   {
                                                               if($perv_fee-($f_months+$demo_route_fees)>=0)
                                                               {
                                                                   $r_fee+=$demo_route_fees;
                                                                   if($perv_fee-($f_months+$demo_route_fees)>0)
                                                                   {
                                                                       if($perv_fee-($f_months+$demo_route_fees+$demo_hostel_fees)>=0)
                                                                       {
                                                                           $h_fee+=$demo_hostel_fees;
                                                                           
                                                                       }else{
                                                                           $h_fee+=($perv_fee-($f_months+$demo_route_fees));//$hostel_fees[0]['cost_per_bed'];
                                                                       }
                                                                       
                                                                   }
                                                               }
                                                               else{
                                                                   $r_fee+=($perv_fee-$f_months);//$route_fees[0]['fare'];
                                                               }
                                                           }
                                                           else{
                                                               
                                                               if((($demo_route_fees>0) && ($demo_hostel_fees<=0)))
                                                        {
                                                            if($perv_fee-($f_months+$demo_route_fees)>=0){
                                                            $r_fee+=$demo_route_fees;//($perv_fee-($f_months+$route_fees[0]['fare']));
                                                            }else{
                                                                $r_fee+=($perv_fee-$f_months);
                                                                 //$r_fee+=(($f_months+$route_fees[0]['fare'])-$perv_fee);
                                                            }
                                                            
                                                        }
                                                               
                                                               if((($demo_route_fees<=0) && ($demo_hostel_fees>0)))
                                                        {
                                                            if($perv_fee-($f_months+$demo_hostel_fees)>=0){
                                                            $h_fee+=$demo_hostel_fees;//($perv_fee-($f_months+$hostel_fees[0]['cost_per_bed']));
                                                            }else{
                                                                $h_fee+=($perv_fee-($f_months+$demo_route_fees));
                                                                 //$h_fee+=(($f_months+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed'])-$perv_fee);
                                                                    
                                                            }
                                                        }
                                                           }
                                            }
                                                       }
                                                       else{
                                                           $m_fee+=$perv_fee;//($f_months-$perv_fee);
                                                       }
                                            }
                                           // echo $perv_fee."<br>";

        //}
        
            
   
    //}

}


        
   // }

    }
}

                    
                    unset($demo_route_fees);
                    unset($demo_hostel_fees);
                    unset($newArray);
                    unset($route_fees);
                    unset($newArray_hostel);
                    unset($hostel_fees);
                    unset($student_due_fee);
                    unset($studnet_all);
    }
}


             if (!empty($st_fees)) {
                //echo count($st_fees)."<br>";
                foreach ($st_fees as $fee_key_1 => $fee_value_1) {
                    // print_r($fee_value);
                     //echo "<br><br>new<br><br>";
                    

                    
                    
                    if (isJSON($fee_value_1->amount_detail)) {
                        // print_r($fee_value);
                        // echo "<br><br>";
                        $name = $fee_value_1->name;
                        // Check if the key exists in the array, if not, initialize it
if (!isset($fee_amount_count[$name])) {
    $fee_amount_count[$name] = array(
        'sum' => 0, // Initialize sum to 0
        'count' => 0 // Initialize count to 0
    );
}

                        $fees_details = (json_decode($fee_value_1->amount_detail));
                        if (!empty($fees_details)) {
                            
            foreach ($fees_details as $fees_detail_key => $fees_detail_value) {
                // print_r($fees_detail_value);
                // exit();
        $date = strtotime($fees_detail_value->date);
    if ($date >= $formated_date_from && $date <= $formated_date_to) {
if (array_key_exists($date,$fees_data)){
    foreach ($fees_detail_value as $innerKey => $innerValue) {
                                                    if (is_object($innerValue) || is_array($innerValue)) {
                                                        if(array_key_exists($innerKey,$fees_head_data)){
    $fees_head_data[$innerKey]['amt']+=$innerValue->amount;
                                                        }else{
                                                            $fees_head_data[$innerKey]['amt']=$innerValue->amount;
                                                        }
                                                    }
    }
    if($fees_detail_value->amount_fine>0){
        if(array_key_exists("Fine Amount",$fees_head_data)){
    $fees_head_data["Fine Amount"]['amt']+=$fees_detail_value->amount_fine;
                                                        }else{
                                                            $fees_head_data["Fine Amount"]['amt']=$fees_detail_value->amount_fine;
                                                        }
    }
    if($fees_detail_value->amount_discount>0){
        if(array_key_exists("Discount Amount",$fees_head_data)){
    $fees_head_data["Discount Amount"]['amt']+=$fees_detail_value->amount_discount;
                                                        }else{
                                                            $fees_head_data["Discount Amount"]['amt']=$fees_detail_value->amount_discount;
                                                        }
    }
    
 $fees_data[$date]['amt']+=$fees_detail_value->amount+$fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount); 
 //${$name}+=$fees_detail_value->amount+$fees_detail_value->amount_fine;
 //${$name . '_count'}+=1;
  //$fees_data[$date]['count']+=1;
 // Increment the sum by the current amount and amount fine
$fee_amount_count[$name]['sum'] += $fees_detail_value->amount + $fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount);

// Increment the count by 1
$fee_amount_count[$name]['count'] += 1;

   $fees_data[$date]['count']+=1;
  $fees_data[$date]['student_fees_deposite_ids'][]=$fee_value_1->student_fees_deposite_id; 
}else{
     foreach ($fees_detail_value as $innerKey => $innerValue) {
                                                    if (is_object($innerValue) || is_array($innerValue)) {
                                                        if(array_key_exists($innerKey,$fees_head_data)){
    $fees_head_data[$innerKey]['amt']+=$innerValue->amount;
                                                        }else{
                                                            $fees_head_data[$innerKey]['amt']=$innerValue->amount;
                                                        }
                                                    }
    }
    if($fees_detail_value->amount_fine>0){
        if(array_key_exists("Fine Amount",$fees_head_data)){
    $fees_head_data["Fine Amount"]['amt']+=$fees_detail_value->amount_fine;
                                                        }else{
                                                            $fees_head_data["Fine Amount"]['amt']=$fees_detail_value->amount_fine;
                                                        }
    }
    if($fees_detail_value->amount_discount>0){
        if(array_key_exists("Discount Amount",$fees_head_data)){
    $fees_head_data["Discount Amount"]['amt']+=$fees_detail_value->amount_discount;
                                                        }else{
                                                            $fees_head_data["Discount Amount"]['amt']=$fees_detail_value->amount_discount;
                                                        }
    }
 $fees_data[$date]['amt']=$fees_detail_value->amount+$fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount); 
//  ${$name}=$fees_detail_value->amount+$fees_detail_value->amount_fine;
//  ${$name . '_count'}=1;
// Increment the sum by the current amount and amount fine
$fee_amount_count[$name]['sum'] = $fees_detail_value->amount + $fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount);

// Increment the count by 1
$fee_amount_count[$name]['count'] = 1;

   $fees_data[$date]['count']=1; 
  $fees_data[$date]['student_fees_deposite_ids'][]=$fee_value_1->student_fees_deposite_id; 
}                                 
                               }                            
                            }
                            // Extract the name from $fee_value->name
//
                // Create associative array keys dynamically
//                 echo ''.$name . '_count'.''.''.'=>'.''.$name.''.'=='. ${$name . '_count'}."=>".${$name}."<br>";
// $data[''.$name . '_count'.''] = ${$name . '_count'};
// $data[''.$name.''] = ${$name};


                        }
                    }
                }
                

            }
            $data['fees_head_data']=$fees_head_data;
            $data['fees_data']=$fees_data;
            $data['fee_amount_count']=$fee_amount_count;
            
            $data['feegroupList'] = $feegroup;
            
            $data['m_fee']=$m_fee;
            $data['r_fee']=$r_fee;
            $data['h_fee']=$h_fee;
        }
        else{
             if (!empty($st_fees)) {
                //echo count($st_fees)."<br>";
                //print_r($st_fees);
                foreach ($st_fees as $fee_key_1 => $fee_value_1) {
                    // print_r($fee_value);
                     //echo "<br><br>new<br><br>";
                    
//echo $fee_value_1->code."==".$fees_code_value."<br>";
                    $result=(isset($fees_code_value) && !empty($fees_code_value))?$fee_value_1->code==$fees_code_value:1;
                    //$result=(isset())
                    if($result){
                    if (isJSON($fee_value_1->amount_detail)) {
                        // print_r($fee_value);
                        // echo "<br><br>";
                        $name = $fee_value_1->name;
                        // Check if the key exists in the array, if not, initialize it
if (!isset($fee_amount_count[$name])) {
    $fee_amount_count[$name] = array(
        'sum' => 0, // Initialize sum to 0
        'count' => 0 // Initialize count to 0
    );
}

                        $fees_details = (json_decode($fee_value_1->amount_detail));
                        if (!empty($fees_details)) {
                            
            foreach ($fees_details as $fees_detail_key => $fees_detail_value) {
                // print_r($fees_detail_value);
                // exit();
                foreach ($fees_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){
                                                        if(in_array($innerKey, (array)$fees_head_value)){
                                                        // echo $innerValue->amount."<br>";
                                                        //stdClass Object ( [total_amount] => 500 [amount] => 500 )
                                                        // print_r($innerValue)."<br><br>";
                                                        // exit();
                                                        // foreach ($innerValue as $innerKey_new => $innerValue_new) {
                
        $date = strtotime($fees_detail_value->date);
    if ($date >= $formated_date_from && $date <= $formated_date_to) {
       
if (array_key_exists($date,$fees_data)){
     
 $fees_data[$date]['amt']+=$innerValue->amount;//$fees_detail_value->amount+$fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount); 
 //${$name}+=$fees_detail_value->amount+$fees_detail_value->amount_fine;
 //${$name . '_count'}+=1;
  //$fees_data[$date]['count']+=1;
 // Increment the sum by the current amount and amount fine
$fee_amount_count[$name]['sum'] += $innerValue->amount;//$fees_detail_value->amount + $fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount);

// Increment the count by 1
$fee_amount_count[$name]['count'] += 1;

   $fees_data[$date]['count']+=1;
  $fees_data[$date]['student_fees_deposite_ids'][]=$fee_value_1->student_fees_deposite_id; 
}else{
     
 $fees_data[$date]['amt']=$innerValue->amount;//$fees_detail_value->amount+$fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount); 
//  ${$name}=$fees_detail_value->amount+$fees_detail_value->amount_fine;
//  ${$name . '_count'}=1;
// Increment the sum by the current amount and amount fine
$fee_amount_count[$name]['sum'] =$innerValue->amount; //$fees_detail_value->amount + $fees_detail_value->amount_fine;//+intval($fees_detail_value->amount_discount);

// Increment the count by 1
$fee_amount_count[$name]['count'] = 1;

   $fees_data[$date]['count']=1; 
  $fees_data[$date]['student_fees_deposite_ids'][]=$fee_value_1->student_fees_deposite_id; 
}                                 
            //                   }    
                               
            // }
            //             }
            //         }
                }
                                                    }
                                                    }
                }
                
                            }
                            // Extract the name from $fee_value->name
//
                // Create associative array keys dynamically
//                 echo ''.$name . '_count'.''.''.'=>'.''.$name.''.'=='. ${$name . '_count'}."=>".${$name}."<br>";
// $data[''.$name . '_count'.''] = ${$name . '_count'};
// $data[''.$name.''] = ${$name};


                        }
                    }
                }
                }
                

            }
            $data['fees_data']=$fees_data;
            $data['fee_amount_count']=$fee_amount_count;
            
            $data['feegroupList'] = $feegroup;
            
            // $data['m_fee']=$m_fee;
            // $data['r_fee']=$r_fee;
            // $data['h_fee']=$h_fee;
            
        }
            

        }

        $this->load->view('layout/header', $data);
        $this->load->view('reports/reportdailycollection', $data);
        $this->load->view('layout/footer', $data);
    }


                                                                                                                                                 
public function sendfeesremindersms()
    {
        
        if ($this->input->server('REQUEST_METHOD') == "POST") {
            $date               = date('d-m-Y');
            $studnet_data = json_decode(file_get_contents('php://input'), true);
            //$studnet_data           = json_decode($this->input->post('studnet_data'));
            //print_r($studnet_data);
            foreach ($studnet_data['studnet_data'] as $student_id => $student_info) {
                // $mailsms_array=array();
                // $mailsms_array->contact_no     = $student_info['mobileno'] ;
                // $mailsms_array->fee_type     = $student_info['type'] ;
                // $mailsms_array->student_name     = $student_info['name'] ;
                // $mailsms_array->due_date     = $date;
                // $mailsms_array->due_amount     = $student_info['due_amount'] ;
                $mailsms_array = array(
        'contact_no' => $student_info['mobileno'],
        'fee_type' => $student_info['type'],
        'student_name' => $student_info['name'],
        'due_date' => $date,
        'due_amount' => $student_info['due_amount']
    );
               $this->mailsmsconf->mailsms('fees_reminder', $mailsms_array);
            }
            echo json_encode(array('status' => 1));
            
        }
        
        
    }
                                                                                                                                                         
   public function reportduefees()
    {
        if (!$this->rbac->hasPrivilege('fees_statement', '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/reportduefees');
        $data                = array();
        $data['title']       = 'student fees';
        $class               = $this->class_model->get();
        $data['classlist']   = $class;
        $data['sch_setting'] = $this->sch_setting_detail;
        $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'] = '';
            
        }
       $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');
    
        //$dates               = $this->customlib->get_betweendate('this_year');
        $data['dates'] = $dates;
 
       // $this->form_validation->set_rules('search_type', $this->lang->line('search') . " " . $this->lang->line('type'), 'trim|required|xss_clean');
if ($this->form_validation->run() == false) {
           // $data['student_due_fee'] = array();
            //$data['resultarray'] = array();
            
            $data['class_id'] = "";
            $data['section_id'] = "";
            // $data['feetype'] = "";
            // $data['feetype_arr'] = array();
        }
        //if ($this->input->server('REQUEST_METHOD') == "POST") {
        else{
            // echo $end_date;
            // exit();
            //$date               = date('Y-m-d');
            $class_id           = $this->input->post('class_id');
            $section_id         = $this->input->post('section_id');
            $data['class_id']   = $class_id;
            $data['section_id'] = $section_id;
            $data['start_date']=$start_date;
            $data['end_date']=$end_date;
            $fees_dues          = $this->studentfeemaster_model->getStudentDueFeeTypesByDate($end_date, $class_id, $section_id);//$date
           
           // $fees_dues2          = $this->studentfeemaster_model->getStudentDueFeeTypesByDate2($date, $class_id, $section_id);
            //$data['fees_dues2']=$fees_dues2;
            $students_list      = array();
            $students_list2      = array();
            $student_list      = array();
            $students_list5      = array();

            if (!empty($fees_dues)) {
                $i=1;
                
                //echo count($fees_dues->fees)."<br>";
                //return print_r($fees_dues);
                //print_r($fees_dues)."<br><br>";
                //$months_count=1;
                
                foreach ($fees_dues as $fee_due_key => $fee_due_value) {
                    
                    //  print_r($fee_due_value);
                    //  echo "<br><br>new<br><br>";
                    
                    $amount_paid = 0;
                     if (isJSON($fee_due_value->amount_detail)) {
                        $student_fees_array = json_decode($fee_due_value->amount_detail);
                        foreach ($student_fees_array as $fee_paid_key => $fee_paid_value) {
                            $amount_paid += (intval($fee_paid_value->amount) + intval($fee_paid_value->amount_discount));
                        }
                    }
                    
                    
                        // echo $start_date.'=='.$end_date.'==>'.(strtotime($start_date) === strtotime($end_date));
                      // echo $start_date.'=='.$end_date.'=due_date='.$fee_due_value->due_date.'==>'.(!(strtotime($fee_due_value->due_date) === strtotime($start_date)) && (strtotime($fee_due_value->due_date) <= strtotime($end_date)))."<br>";
                       
                        //exit();
                        
                    if(!(strtotime($start_date) === strtotime($end_date))){
                    $student_due_fee_2      = $this->studentfeemaster_model->getStudentFees(intval($fee_due_value->student_session_id),$start_date, $end_date);
                    }
                    else{
                        $student_due_fee_2      = $this->studentfeemaster_model->getStudentFees(intval($fee_due_value->student_session_id));
                    
                    }
                    
                    //exit();
                     $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees(intval($fee_due_value->student_session_id));
                     
                      // $newArray    = $this->studentfeemaster_model->getdate_transport_hostel(intval($fee_due_value->student_session_id));//$routefees
                     
                      $newArray    = $this->studentfeemaster_model->getdate_transport_fee(intval($fee_due_value->student_session_id));//$routefees
      
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet(intval($fee_due_value->student_session_id));
        //$newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel(intval($fee_due_value->student_session_id));// $hostelfees
       
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee(intval($fee_due_value->student_session_id));// $hostelfees
        
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet(intval($fee_due_value->student_session_id));
        
    //print_r($student_due_fee_2);
    // print_r($miscellaneousfees);
    //exit();
    foreach ($miscellaneousfees as $mf_key => $mf_value) {
        
    //echo $mf_key."=>".$mf_value."<br>";
    //echo $mf_value['concatenated_miscellaneous_months']."<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'];
}
                    foreach ($student_due_fee_2 as $key => $fee) {
                        //echo count($fee->fees)."=>".$fee->name."<br>";
                       // $d=$fee->name."_count";
                        //$students_list[$fee_due_value->student_session_id][$d]=count($fee->fees);
                       //   print_r($miscellaneousfees);
    //   exit();
//         $MFfare=0;
// foreach ($miscellaneousfees as $mf_key => $mf_value) {
//     //echo $mf_key."=>".$mf_value."<br>";
//      $MFfare=$mf_value['MFfare'];
// }



//echo $MFfare."<br>";
//echo $fee->name."<br>";
                        //$students_list5[$fee_due_value->student_session_id][$fee->name]=$fee->thf;//count($fee->fees);
                        //$students_list5[$fee_due_value->student_session_id]["MFfare"]=$MFfare;
                     //   $months_count=1;

    foreach ($fee->fees as $fee_key => $fee_value) {
                            //echo $fee_value->thf."<br>";
                           
                            if(intval($fee_value->thf)==1)
                            {
                                $students_list5[$fee_due_value->student_session_id][$fee->name]=intval($fee_value->thf);//count($fee->fees);
                                            
                            }
                           
                           // echo ($students_list5[$fee_due_value->student_session_id][$fee->name]==1)."<br>";
                            
                            if($fee_value->name!="Balance Master" && $students_list5[$fee_due_value->student_session_id][$fee->name]==1){//>=3
                                //&& !empty($miscellaneousfees)
                         
                         $f_months=0;
                         //echo $months_count."<br>";
                         if(!empty($cmm)){
                            for($i=0;$i<count($cmm);$i++){
                                
                                $new_cmm=explode(",",$cmm[$i]);
                                if(in_array(explode(' ', $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(' ', $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(' ', $fee_value->code)[0], $newArray_hostel[$i])){
                                     $f_months+=$hostel_fees[$i]['cost_per_bed'];
                                 }
                             }
                            }
                        
                    $total_amount=0;
                    
                    // if(in_array(explode(' ', $fee_value->code)[0], $newArray) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel)){
                    //                 $total_amount          = $total_amount + $fee_value->amount+$route_fees[0]['fare']+$hostel_fees[0]['cost_per_bed']+$f_months;//$MFfare
                        
                    //         }elseif(in_array(explode(' ', $fee_value->code)[0], $newArray) && !(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel))){
                    //               $total_amount          = $total_amount + $fee_value->amount+$route_fees[0]['fare']+$f_months;//$MFfare
                       
                    //         }elseif(!(in_array(explode(' ', $fee_value->code)[0], $newArray)) && in_array(explode(' ', $fee_value->code)[0], $newArray_hostel)){
                    //               $total_amount          = $total_amount + $fee_value->amount+$hostel_fees[0]['cost_per_bed']+$f_months;//$MFfare
                    
                    //         }
                    //         else{
                    //                 $total_amount          = $total_amount + $fee_value->amount+$f_months;//$MFfare
                       
                                
                    //         }
                            $total_amount          = $total_amount + $fee_value->amount+$f_months;
                            $total_amount=$total_amount-1;
                            // print_r($newArray);
                            
                            // echo "<br>".$fee_value->code.'=>'.$total_amount."<br>";
                            $students_list5[$fee_due_value->student_session_id][$fee_value->code]=$total_amount;
                    
                    }else{
                        //$months_count=1;
                    }
                    
               //$months_count=$months_count+1;
                            
         }
                       
                    }
                   // $MFfare=0;


if(((strtotime($fee_due_value->due_date) >= strtotime($start_date)) && (strtotime($fee_due_value->due_date) <=  strtotime($end_date)))){
                
if($fee_due_value->name!="Balance Master"){
      $student_feediscount      = $this->feediscount_model->getStudentFeesDiscount(intval($fee_due_value->student_session_id));
    
     if ($amount_paid < ((($students_list5[$fee_due_value->student_session_id][$fee_due_value->name]==1)?$students_list5[$fee_due_value->student_session_id][$fee_due_value->code]:$fee_due_value->fee_amount)) || $amount_paid < ((($students_list5[$fee_due_value->student_session_id][$fee_due_value->name]==1)?$students_list5[$fee_due_value->student_session_id][$fee_due_value->code]:$fee_due_value->fee_amount))) { //$amount_paid < ($fee_due_value->fee_amount+$fee_due_value->fare+$fee_due_value->cost_per_bed) || 
                        //Partial or Unpaid
                        //>=3
                        
                        $students_list[$fee_due_value->student_session_id]['student_feediscount']             = $student_feediscount;
                        
                        // $students_list[$fee_due_value->student_session_id]['MFfare']             = $fee_due_value->MFfare;
                        // $students_list[$fee_due_value->student_session_id]['miscellaneous_type']             = $fee_due_value->miscellaneous_type;
                        //miscellaneousfees
                        //$students_list[$fee_due_value->student_session_id]['miscellaneousfees']             = $MFfare;
                        $students_list[$fee_due_value->student_session_id]['admission_no']             = $fee_due_value->admission_no;
                        $students_list[$fee_due_value->student_session_id]['roll_no']                  = $fee_due_value->roll_no;
                        $students_list[$fee_due_value->student_session_id]['admission_date']           = $fee_due_value->admission_date;
                        $students_list[$fee_due_value->student_session_id]['firstname']                = $fee_due_value->firstname;
                        $students_list[$fee_due_value->student_session_id]['middlename']               = $fee_due_value->middlename;
                        $students_list[$fee_due_value->student_session_id]['lastname']                 = $fee_due_value->lastname;
                        $students_list[$fee_due_value->student_session_id]['father_name']              = $fee_due_value->father_name;
                        $students_list[$fee_due_value->student_session_id]['image']                    = $fee_due_value->image;
                        $students_list[$fee_due_value->student_session_id]['mobileno']                 = $fee_due_value->mobileno;
                        $students_list[$fee_due_value->student_session_id]['email']                    = $fee_due_value->email;
                        $students_list[$fee_due_value->student_session_id]['state']                    = $fee_due_value->state;
                        $students_list[$fee_due_value->student_session_id]['city']                     = $fee_due_value->city;
                        $students_list[$fee_due_value->student_session_id]['pincode']                  = $fee_due_value->pincode;
                        $students_list[$fee_due_value->student_session_id]['class']                    = $fee_due_value->class;
                        $students_list[$fee_due_value->student_session_id]['section']                  = $fee_due_value->section;
                        $students_list[$fee_due_value->student_session_id]['fee_groups_feetype_ids'][] = $fee_due_value->fee_groups_feetype_id;
                
                    }
                   
                    
                   
}
else{
   // echo  $amount_paid ."=>".$fee_due_value->student_fees_master_bal_amount."<br>";
     if ($amount_paid < ($fee_due_value->student_fees_master_bal_amount)) {
         //$students_list[$fee_due_value->student_session_id]['miscellaneousfees']             = $MFfare;
                        
                        $students_list[$fee_due_value->student_session_id]['admission_no']             = $fee_due_value->admission_no;
                        $students_list[$fee_due_value->student_session_id]['roll_no']                  = $fee_due_value->roll_no;
                        $students_list[$fee_due_value->student_session_id]['admission_date']           = $fee_due_value->admission_date;
                        $students_list[$fee_due_value->student_session_id]['firstname']                = $fee_due_value->firstname;
                        $students_list[$fee_due_value->student_session_id]['middlename']               = $fee_due_value->middlename;
                        $students_list[$fee_due_value->student_session_id]['lastname']                 = $fee_due_value->lastname;
                        $students_list[$fee_due_value->student_session_id]['father_name']              = $fee_due_value->father_name;
                        $students_list[$fee_due_value->student_session_id]['image']                    = $fee_due_value->image;
                        $students_list[$fee_due_value->student_session_id]['mobileno']                 = $fee_due_value->mobileno;
                        $students_list[$fee_due_value->student_session_id]['email']                    = $fee_due_value->email;
                        $students_list[$fee_due_value->student_session_id]['state']                    = $fee_due_value->state;
                        $students_list[$fee_due_value->student_session_id]['city']                     = $fee_due_value->city;
                        $students_list[$fee_due_value->student_session_id]['pincode']                  = $fee_due_value->pincode;
                        $students_list[$fee_due_value->student_session_id]['class']                    = $fee_due_value->class;
                        $students_list[$fee_due_value->student_session_id]['section']                  = $fee_due_value->section;
                        $students_list[$fee_due_value->student_session_id]['fee_groups_feetype_ids'][] = $fee_due_value->fee_groups_feetype_id;
                    }
     
}
}
                   
                    

                 
                    
                }
            }
//$data['students_list2']=$students_list2;
            if (!empty($students_list)) {
                foreach ($students_list as $student_key => $student_value) {
                    $students_list[$student_key]['fees_list'] = $this->studentfeemaster_model->studentDepositByFeeGroupFeeTypeArray($student_key, $student_value['fee_groups_feetype_ids']);
//$students_list[$student_key]['fees_list']['miscellaneousfees']    = $this->studentfeemaster_model->getStudentMiscellaneousFees(intval($student_value['student_session_id']));
    
                }
            }
            //$data['fees_dues']=$fees_dues;

            $data['student_due_fee'] = $students_list;
          
            $data['students_list5'] = $students_list5;
        }
        

        $this->load->view('layout/header', $data);
        $this->load->view('reports/reportduefees', $data);
        $this->load->view('layout/footer', $data);
    }


    public function printreportduefees()
    {

// // yuvi
//  $this->load->helper('debug');
//  clear_logs();
        
        //$date               = date('Y-m-d');
            $class_id           = $this->input->post('class_id');
            $section_id         = $this->input->post('section_id');
            $data['class_id']   = $class_id;
            
         $start_date          = $this->input->post('start_date');
        $end_date            = $this->input->post('end_date');
         $admission_nos = $this->input->post('admission_nos');
       // echo $start_date.'=='.$end_date;
//exit();

            
            $fees_dues          = $this->studentfeemaster_model->getStudentDueFeeTypesByDateTest($end_date, $class_id, $section_id,$admission_nos); //$date
    
          // $fees_dues2          = $this->studentfeemaster_model->getStudentDueFeeTypesByDate2($date, $class_id, $section_id);
            //$data['fees_dues2']=$fees_dues2;
            
            $students_list      = array();
            $students_list2      = array();
            $student_list      = array();
             $students_list5      = array();
            //  yuvi
            
            $students_fee_structure=array();
            
            if (!empty($fees_dues)) {
                $i=1;
                
            
                    $data['test']= $fees_dues;
                foreach ($fees_dues as $fee_due_key => $fee_due_value) {
                    $amount_paid = 0;
                    
   
              
                    if (isJSON($fee_due_value->amount_detail)) {
                        
                        $student_fees_array = json_decode($fee_due_value->amount_detail);

                        
                        foreach ($student_fees_array as $fee_paid_key => $fee_paid_value) {
                            $amount_paid += (intval($fee_paid_value->amount) + intval($fee_paid_value->amount_discount));
                        }
                    }
                   
                    //$student_due_fee_2      = $this->studentfeemaster_model->getStudentFees(intval($fee_due_value->student_session_id));
                    if(!(strtotime($start_date) === strtotime($end_date))){
                    $student_due_fee_2      = $this->studentfeemaster_model->getStudentFees(intval($fee_due_value->student_session_id),$start_date, $end_date);
                    
              
                         
                    }
                    else{
                        $student_due_fee_2      = $this->studentfeemaster_model->getStudentFees(intval($fee_due_value->student_session_id));
              
                    
                        
                    }
                    
                    $miscellaneousfees    = $this->studentfeemaster_model->getStudentMiscellaneousFees(intval($fee_due_value->student_session_id));
                     
    
                     //$newArray    = $this->studentfeemaster_model->getdate_transport_hostel(intval($fee_due_value->student_session_id));//$routefees
                    
            
           
             $newArray    = $this->studentfeemaster_model->getdate_transport_fee(intval($fee_due_value->student_session_id));//$routefees
  
  
      
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet(intval($fee_due_value->student_session_id));
       // $newArray_hostel    = $this->studentfeemaster_model->getdate_transport_hostel(intval($fee_due_value->student_session_id));// $hostelfees
     
   
      
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee(intval($fee_due_value->student_session_id));// $hostelfees
      
   
      
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet(intval($fee_due_value->student_session_id));
        
 
                    
    //print_r($miscellaneousfees);
    
    // $misc_fees_map = [];
    
    $map_valid_month=[];
    foreach ($miscellaneousfees as $mf_key => $mf_value) {
    
    $cmm=explode("=",$mf_value['concatenated_miscellaneous_months']);
    $cmf=explode("=",$mf_value['concatenated_miscellaneous_fees']);
    $cmp=explode("=",$mf_value['concatenated_miscellaneous_miscellaneous_print_name']);
     //$MFfare=$mf_value['MFfare'];
     

}


  
   foreach ($student_due_fee_2 as $key => $fee) {
               
                        //$students_list5[$fee_due_value->student_session_id][$fee->name]=count($fee->fees);
                        
         // MAIN FIX: Move $misc_fees_map initialization inside the fee processing loop

foreach ($fee->fees as $fee_key => $fee_value) {
    
    // ✅ RESET the misc_fees_map for each fee/month - THIS IS THE KEY FIX!
    $misc_fees_map = []; 
    
    if(intval($fee_value->thf)==1) {
        $students_list5[$fee_due_value->student_session_id][$fee->name]=intval($fee_value->thf);
    }
    
    if($fee_value->name!="Balance Master" && $students_list5[$fee_due_value->student_session_id][$fee->name]==1) {
        $f_months=0;
        
        // Process miscellaneous fees based on month matching
        if (!empty($cmm)) {
            $selected_month = strtoupper(trim(explode(' ', $fee_value->code)[0])); // e.g., "APRIL"

            for ($i = 0; $i < count($cmm); $i++) {
                $new_cmm = explode(",", $cmm[$i]);
                $normalized_cmm = array_map('strtoupper', array_map('trim', $new_cmm));

                if (in_array($selected_month, $normalized_cmm)) {
                    // Add the fee only if month matches
                    $misc_fees_map[$cmp[$i]] = $cmf[$i];
                    $f_months += $cmf[$i];
                }
            }
        }

        // Process transport fees
        if(!empty($newArray)) {
            for($i=0;$i<count($newArray);$i++) {
                if(in_array(explode(' ', $fee_value->code)[0], $newArray[$i])) {
                    $misc_fees_map['Transport Fee ('.$route_fees[$i]['route_title'].')'] = $route_fees[$i]['fare'];
                    $f_months+=$route_fees[$i]['fare'];
                }
            }
        }
        
        // Process hostel fees  
        if(!empty($newArray_hostel)) {
            for($i=0;$i<count($newArray_hostel);$i++) {
                if(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel[$i])) {
                    $misc_fees_map['Hostel Fee ('.$hostel_fees[$i]['hostel_name'].')'] = $hostel_fees[$i]['cost_per_bed'];
                    $f_months+=$hostel_fees[$i]['cost_per_bed'];
                }
            }
        }

        $total_amount = $fee_value->amount + $f_months - 1;
        $students_list5[$fee_due_value->student_session_id][$fee_value->code] = $total_amount;
        
        // ✅ Now each month will have only its relevant fees
        $students_fee_structure[$fee_due_value->student_session_id][$fee_value->code] = $misc_fees_map;     
        
    
        
    } else {
        // Handle other cases
    }
}
    
    }
                    
                    
                    unset($cmm);
    unset($cmf);
                unset($miscellaneousfees);
                  unset($student_due_fee_2);
                  if(((strtotime($fee_due_value->due_date) >= strtotime($start_date)) && (strtotime($fee_due_value->due_date) <=  strtotime($end_date)))){
       
                    if($fee_due_value->name!="Balance Master"){
                        $student_feediscount      = $this->feediscount_model->getStudentFeesDiscount(intval($fee_due_value->student_session_id));
     //>=3
     //if ($amount_paid < ($fee_due_value->fee_amount+$fee_due_value->fare+$fee_due_value->cost_per_bed) || $amount_paid < ($fee_due_value->amount+$fee_due_value->fare+$fee_due_value->cost_per_bed)) {
      if ($amount_paid < ((($students_list5[$fee_due_value->student_session_id][$fee_due_value->name]==1)?$students_list5[$fee_due_value->student_session_id][$fee_due_value->code]:$fee_due_value->fee_amount)) || $amount_paid < ((($students_list5[$fee_due_value->student_session_id][$fee_due_value->name]==1)?$students_list5[$fee_due_value->student_session_id][$fee_due_value->code]:$fee_due_value->fee_amount))) { //$amount_paid < ($fee_due_value->fee_amount+$fee_due_value->fare+$fee_due_value->cost_per_bed) || 
                        //Partial or Unpaid
      $students_list[$fee_due_value->student_session_id]['student_feediscount']             = $student_feediscount;
                        
                        $students_list[$fee_due_value->student_session_id]['admission_no']             = $fee_due_value->admission_no;
                        $students_list[$fee_due_value->student_session_id]['roll_no']                  = $fee_due_value->roll_no;
                        $students_list[$fee_due_value->student_session_id]['admission_date']           = $fee_due_value->admission_date;
                        $students_list[$fee_due_value->student_session_id]['firstname']                = $fee_due_value->firstname;
                        $students_list[$fee_due_value->student_session_id]['middlename']               = $fee_due_value->middlename;
                        $students_list[$fee_due_value->student_session_id]['lastname']                 = $fee_due_value->lastname;
                        $students_list[$fee_due_value->student_session_id]['father_name']              = $fee_due_value->father_name;
                        $students_list[$fee_due_value->student_session_id]['image']                    = $fee_due_value->image;
                        $students_list[$fee_due_value->student_session_id]['mobileno']                 = $fee_due_value->mobileno;
                        $students_list[$fee_due_value->student_session_id]['email']                    = $fee_due_value->email;
                        $students_list[$fee_due_value->student_session_id]['state']                    = $fee_due_value->state;
                        $students_list[$fee_due_value->student_session_id]['city']                     = $fee_due_value->city;
                        $students_list[$fee_due_value->student_session_id]['pincode']                  = $fee_due_value->pincode;
                        $students_list[$fee_due_value->student_session_id]['class']                    = $fee_due_value->class;
                        $students_list[$fee_due_value->student_session_id]['section']                  = $fee_due_value->section;
                        $students_list[$fee_due_value->student_session_id]['fee_groups_feetype_ids'][] = $fee_due_value->fee_groups_feetype_id;
                    }
                    
                   
}else{
   
     if ($amount_paid < ($fee_due_value->student_fees_master_bal_amount)) {
                        $students_list[$fee_due_value->student_session_id]['admission_no']             = $fee_due_value->admission_no;
                        $students_list[$fee_due_value->student_session_id]['roll_no']                  = $fee_due_value->roll_no;
                        $students_list[$fee_due_value->student_session_id]['admission_date']           = $fee_due_value->admission_date;
                        $students_list[$fee_due_value->student_session_id]['firstname']                = $fee_due_value->firstname;
                        $students_list[$fee_due_value->student_session_id]['middlename']               = $fee_due_value->middlename;
                        $students_list[$fee_due_value->student_session_id]['lastname']                 = $fee_due_value->lastname;
                        $students_list[$fee_due_value->student_session_id]['father_name']              = $fee_due_value->father_name;
                        $students_list[$fee_due_value->student_session_id]['image']                    = $fee_due_value->image;
                        $students_list[$fee_due_value->student_session_id]['mobileno']                 = $fee_due_value->mobileno;
                        $students_list[$fee_due_value->student_session_id]['email']                    = $fee_due_value->email;
                        $students_list[$fee_due_value->student_session_id]['state']                    = $fee_due_value->state;
                        $students_list[$fee_due_value->student_session_id]['city']                     = $fee_due_value->city;
                        $students_list[$fee_due_value->student_session_id]['pincode']                  = $fee_due_value->pincode;
                        $students_list[$fee_due_value->student_session_id]['class']                    = $fee_due_value->class;
                        $students_list[$fee_due_value->student_session_id]['section']                  = $fee_due_value->section;
                        $students_list[$fee_due_value->student_session_id]['fee_groups_feetype_ids'][] = $fee_due_value->fee_groups_feetype_id;
                    }
     
}
}
                    

                }
            }
            
$data['students_list2']=$students_list2;


            if (!empty($students_list)) {
                foreach ($students_list as $student_key => $student_value) {
                    $students_list[$student_key]['fees_list'] = $this->studentfeemaster_model->studentDepositByFeeGroupFeeTypeArray($student_key, $student_value['fee_groups_feetype_ids']);

                }
            }
            
            $data['students_fee_structure']=$students_fee_structure;
            $data['student_due_fee'] = $students_list;
            $data['students_list5'] = $students_list5;
            unset($students_list);
            unset($students_list2);
            unset($students_list5);
            unset($student_list);
        $page                    = $this->load->view('reports/_printreportduefees', $data, true);
        echo json_encode(array('status' => 1, 'page' => $page));
    }



	public function feeCollectionStudentDeposit()
    {

      $data=array();
      $date=$this->input->post('date');
      $fees_id=$this->input->post('fees_id');
      //$fees_head_value=$this->input->post('fees_head_value');
      $fees_head_value = !empty($this->input->post('fees_head_value')) ? $this->input->post('fees_head_value') : '';
      $fees_id_array=explode(',', $fees_id);    
      $fees_list=$this->studentfeemaster_model->getFeesDepositeByIdArray($fees_id_array);
      $data['student_list']=$fees_list;
      $data['date']=$date;
        $data['sch_setting']  = $this->sch_setting_detail;
        $data['fees_head_value']= !empty($fees_head_value)?explode(",",$fees_head_value):''; //explode(",",$fees_head_value);//$fees_head_value
        //print_r($fees_list);
      $page = $this->load->view('reports/_feeCollectionStudentDeposit', $data, true);
      echo json_encode(array('status' => 1, 'page' => $page));
    }
    public function deletedfees()
    {
        // Check user permissions (optional)
        if (!$this->rbac->hasPrivilege('deleted_fees', 'can_view')) {
            access_denied();
        }
    
        $data = [];
    
        // Handle date filter
        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'] = '';
        }
        $data['searchlist']  = $this->customlib->get_searchtype();
        $data['date_type']   = $this->customlib->date_type();
        $data['date_typeid'] = '';
        $data['headlist']    = $this->expensehead_model->get();
    
        $start_date = date('Y-m-d', strtotime($dates['from_date']));
        $end_date   = date('Y-m-d', strtotime($dates['to_date']));
        // echo $start_date;
        // echo $end_date;
        // exit();
        // Get the current session ID
        $current_session = $this->setting_model->getCurrentSession(); // Assuming this method retrieves the current session ID
    
        // Fetch deleted fees with all necessary joins
        $this->db->select('
            df.*, 
            s.firstname, s.lastname, s.admission_no, 
            c.class AS class_name, 
            sec.section AS section_name,
            
        ');
        $this->db->from('deleted_fees df');
        $this->db->join('student_session ss', 'ss.id = df.student_session_id', 'left');
        $this->db->join('students s', 's.id = ss.student_id', 'left');
        $this->db->join('classes c', 'c.id = ss.class_id', 'left');
        $this->db->join('sections sec', 'sec.id = ss.section_id', 'left');
        $this->db->where('ss.session_id', $current_session);
        $this->db->where('DATE(df.deleted_at) >=', $start_date);
        $this->db->where('DATE(df.deleted_at) <=', $end_date);
        $this->db->order_by('df.deleted_at', 'DESC');
    
        $query = $this->db->get();
        $data['deleted_fees'] = $query->result();
    
        // Load view with data
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/deleted_fee_report', $data);
        
        $this->load->view('layout/footer', $data);
    }

}