1#@!#!123s

: / home / schoolcampuserp / adarshdav.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();

        $miscellaneous = $this->miscellaneous_model->get();
        $miscellaneous_lookup = array();
        $fees_group_code_lookup = array();
        // 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);

            $group_name = trim((string)($feegroup->group_name ?? ''));
            $group_key = $this->normalize_miscellaneous_lookup_key($group_name);
            if ($group_key !== '') {
                $fees_group_code_lookup[$group_key] = $group_name;
            }

            if (isset($feegroup->feetypes) && is_array($feegroup->feetypes)) {
                foreach ($feegroup->feetypes as $feetype_value) {
                    $fee_code = trim((string)($feetype_value->code ?? ''));
                    if ($fee_code === '') {
                        continue;
                    }

                    if ($group_key !== '') {
                        $fees_group_code_lookup[$group_key] = $fee_code;
                    }

                    $code_key = $this->normalize_miscellaneous_lookup_key($fee_code);
                    if ($code_key !== '') {
                        $fees_group_code_lookup[$code_key] = $fee_code;
                    }
                }
            }

            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) {
            $miscellaneous_title = trim((string)($item["miscellaneous_title"] ?? ''));
            $miscellaneous_print_name = trim((string)($item["miscellaneous_print_name"] ?? ''));

            if ($miscellaneous_title !== '' && $miscellaneous_print_name !== '') {
                $miscellaneous_lookup[$this->normalize_miscellaneous_lookup_key($miscellaneous_title)] = $miscellaneous_print_name;
            }

            if ($miscellaneous_print_name !== '') {
                $miscellaneous_lookup[$this->normalize_miscellaneous_lookup_key($miscellaneous_print_name)] = $miscellaneous_print_name;
                $fees_head[] = $miscellaneous_print_name;
            } elseif ($miscellaneous_title !== '') {
                $miscellaneous_lookup[$this->normalize_miscellaneous_lookup_key($miscellaneous_title)] = $miscellaneous_title;
                $fees_head[] = $miscellaneous_title;
            }
        }
        $data['fees_head'] = $fees_head;
        $data['miscellaneous_lookup'] = $miscellaneous_lookup;
        $data['fees_group_code_lookup'] = $fees_group_code_lookup;


        $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['in_short'])) {
            $data['in_short'] = $_POST['in_short'];
        } else {
            $data['in_short'] = "yes";
        }

        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);
                        $this->ensure_fee_head_breakdown($value);
                        $value['type'] = $this->resolve_collection_fee_type_from_receipt(
                            $value['fee_receipt_no_data'] ?? array(),
                            $miscellaneous_lookup,
                            $value['type'] ?? ''
                        );
                    }

                    $collection[$value[$group_by]][] = $value;
                }
            } else {

                $s = 0;
                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);
                        $this->ensure_fee_head_breakdown($value);
                        $value['type'] = $this->resolve_collection_fee_type_from_receipt(
                            $value['fee_receipt_no_data'] ?? array(),
                            $miscellaneous_lookup,
                            $value['type'] ?? ''
                        );
                    }

                    $collection[$s++] = array($value);
                }
            }

            $data['results'] = $collection;

            if ($data['in_short'] == 'yes') {
                $data['results'] = $this->aggregate_collection_short($data['results'], $group);
            }
        }
        $data['subtotal'] = $subtotal;
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        // echo "<pre>";print_r(['Hello data' => $data ]);die();

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

    private function normalize_miscellaneous_lookup_key($value)
    {
        $value = strtolower(trim((string)$value));
        $value = preg_replace('/[^a-z0-9]+/', '', $value);
        return $value;
    }

    private function normalize_collection_fee_label($value)
    {
        $value = trim((string)$value);
        $value = preg_replace('/\s+MONTH\s+FEE\b/i', '', $value);
        $value = preg_replace('/\s+FEE\b/i', '', $value);
        $value = preg_replace('/\s+/', ' ', $value);
        $value = trim($value, " \t\n\r\0\x0B,");
        if ($value !== '' && !preg_match('/\bfee\b/i', $value)) {
            $value .= ' Fee';
        }
        return trim($value);
    }

    private function resolve_collection_fee_type_from_receipt($fee_receipt_no_data, $miscellaneous_lookup = array(), $fallback_type = '')
    {
        $value_items = array();
        if (is_array($fee_receipt_no_data) && isset($fee_receipt_no_data['value'])) {
            $value_items = $fee_receipt_no_data['value'];
        } elseif (is_object($fee_receipt_no_data) && isset($fee_receipt_no_data->value)) {
            $value_items = $fee_receipt_no_data->value;
        }

        if (is_object($value_items)) {
            $value_items = (array)$value_items;
        }

        if (!is_array($value_items) || empty($value_items)) {
            return $fallback_type;
        }

        $resolved_labels = array();
        foreach ($value_items as $key => $item) {
            if (!is_object($item) || !isset($item->amount)) {
                continue;
            }

            $raw_key = trim((string)$key);
            if ($raw_key === '') {
                continue;
            }

            $base_label = trim((string)preg_replace('/\s*\([^)]*\)/', '', $raw_key));
            $print_hint = '';
            if (preg_match('/\(([^)]*)\)/', $raw_key, $matches)) {
                $print_hint = trim((string)$matches[1]);
            }

            $candidates = array();
            if ($base_label !== '') {
                $candidates[] = $base_label;
            }
            if ($print_hint !== '') {
                $candidates[] = $print_hint;
            }

            $label = '';
            foreach ($candidates as $candidate) {
                $lookup_key = $this->normalize_miscellaneous_lookup_key($candidate);
                if ($lookup_key !== '' && isset($miscellaneous_lookup[$lookup_key])) {
                    $label = trim((string)$miscellaneous_lookup[$lookup_key]);
                    break;
                }
            }

            if ($label === '') {
                $label = $base_label !== '' ? $base_label : $raw_key;
            }

            $label = $this->normalize_collection_fee_label($label);
            if ($label !== '') {
                $resolved_labels[$this->normalize_miscellaneous_lookup_key($label)] = $label;
            }
        }

        if (!empty($resolved_labels)) {
            return implode(', ', array_values($resolved_labels));
        }

        return $fallback_type;
    }

    private function ensure_fee_head_breakdown(&$value)
    {
        if (isset($value['fee_receipt_no_data']['value'])) {
            $val_obj = $value['fee_receipt_no_data']['value'];
            $val_arr = is_object($val_obj) ? (array)$val_obj : $val_obj;
            if (is_array($val_arr)) {
                $has_child_objects = false;
                foreach ($val_arr as $k => $v) {
                    if (is_object($v)) {
                        $has_child_objects = true;
                        break;
                    }
                }
                if (!$has_child_objects && isset($value['type']) && trim($value['type']) !== '') {
                    $fee_type_key = $value['type'];
                    $child_obj = new stdClass();
                    $child_obj->amount = $value['amount'];
                    $child_obj->total_amount = $value['amount'];
                    
                    if (is_object($val_obj)) {
                        $val_obj->$fee_type_key = $child_obj;
                    } else {
                        $val_obj[$fee_type_key] = $child_obj;
                    }
                    $value['fee_receipt_no_data']['value'] = $val_obj;
                }
            }
        }
    }

    private function aggregate_collection_short($collection, $group = '')
    {
        $short_collection = array();

        // Keep mode, collection, and class groups separate so report can render grouped sections.
        if ($group !== 'mode' && $group !== 'collection' && $group !== 'class') {
            $flat_rows = array();
            foreach ($collection as $rows) {
                if (!is_array($rows)) {
                    continue;
                }
                foreach ($rows as $row) {
                    $flat_rows[] = $row;
                }
            }
            $collection = array(0 => $flat_rows);
        }

        foreach ($collection as $group_key => $rows) {
            $grouped_rows = array();

            foreach ($rows as $row) {
                $receipt_no = trim((string)($row['fee_receipt_no'] ?? ''));
                $payment_key = $row['id'] . '/' . $row['inv_no'];
                // In short mode keep one row per receipt so partial payments stay accurate.
                $row_key = ($receipt_no !== '' ? 'r_' . $receipt_no : 'p_' . $payment_key);

                if (!isset($grouped_rows[$row_key])) {
                    $row['_payment_ids'] = array($row['id'] . '/' . $row['inv_no']);
                    $row['_receipt_nos'] = array($row['fee_receipt_no']);
                    $row['_fee_types'] = array($row['type']);
                    $row['_payment_modes'] = array($row['payment_mode']);
                    $grouped_rows[$row_key] = $row;
                    continue;
                }

                $grouped_rows[$row_key]['amount'] = (float)$grouped_rows[$row_key]['amount'] + (float)$row['amount'];
                $grouped_rows[$row_key]['amount_discount'] = (float)$grouped_rows[$row_key]['amount_discount'] + (float)$row['amount_discount'];
                $grouped_rows[$row_key]['amount_fine'] = (float)$grouped_rows[$row_key]['amount_fine'] + (float)$row['amount_fine'];

                $grouped_rows[$row_key]['_payment_ids'][] = $row['id'] . '/' . $row['inv_no'];
                $grouped_rows[$row_key]['_receipt_nos'][] = $row['fee_receipt_no'];
                $grouped_rows[$row_key]['_fee_types'][] = $row['type'];
                $grouped_rows[$row_key]['_payment_modes'][] = $row['payment_mode'];

                if (!empty($row['date']) && (empty($grouped_rows[$row_key]['date']) || strtotime($row['date']) > strtotime($grouped_rows[$row_key]['date']))) {
                    $grouped_rows[$row_key]['date'] = $row['date'];
                }

                if (empty(trim((string)$grouped_rows[$row_key]['description'])) && !empty(trim((string)$row['description']))) {
                    $grouped_rows[$row_key]['description'] = $row['description'];
                }

                $existing_fee_data = $grouped_rows[$row_key]['fee_receipt_no_data']['value'] ?? array();
                $current_fee_data = $row['fee_receipt_no_data']['value'] ?? array();

                if (is_object($existing_fee_data)) {
                    $existing_fee_data = (array)$existing_fee_data;
                }
                if (is_object($current_fee_data)) {
                    $current_fee_data = (array)$current_fee_data;
                }

                if (!is_array($existing_fee_data)) {
                    $existing_fee_data = array();
                }

                if (is_array($current_fee_data) && !empty($current_fee_data)) {
                    foreach ($current_fee_data as $fee_key => $fee_item) {
                        if (!array_key_exists($fee_key, $existing_fee_data)) {
                            $existing_fee_data[$fee_key] = $fee_item;
                            continue;
                        }

                        $existing_item = $existing_fee_data[$fee_key];

                        if (is_object($existing_item) && is_object($fee_item) && isset($existing_item->amount) && isset($fee_item->amount)) {
                            $existing_item->amount = (float)$existing_item->amount + (float)$fee_item->amount;
                            $existing_fee_data[$fee_key] = $existing_item;
                        } elseif (is_numeric($existing_item) && is_numeric($fee_item)) {
                            $existing_fee_data[$fee_key] = (float)$existing_item + (float)$fee_item;
                        }
                    }
                }

                $grouped_rows[$row_key]['fee_receipt_no_data']['value'] = $existing_fee_data;
            }

            $short_collection[$group_key] = array();
            foreach ($grouped_rows as $item) {
                $payment_ids = array_values(array_unique($item['_payment_ids']));
                $receipt_nos = array_values(array_unique($item['_receipt_nos']));
                $fee_types = array_values(array_unique($item['_fee_types']));
                $payment_modes = array_values(array_unique($item['_payment_modes']));

                $item['payment_id_display'] = implode(', ', $payment_ids);
                $item['fee_receipt_no'] = implode(', ', $receipt_nos);
                $item['type'] = implode(', ', $fee_types);
                $item['payment_mode'] = implode(', ', $payment_modes);

                unset($item['_payment_ids'], $item['_receipt_nos'], $item['_fee_types'], $item['_payment_modes']);
                $short_collection[$group_key][] = $item;
            }
        }

        return $short_collection;
    }

    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'];

            $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);


                if (!empty($student_due_fee[$i])) {

                    foreach ($student_due_fee[$i] as $student_due_fee_key => $student_due_fee_value) {


                        $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_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) {

                                $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]['amount_discount'] = 0;
                        $student_due_fee[$i][$student_due_fee_key]['amount_fine']     = 0;


                        $a                                                        = json_decode($student_due_fee_value['amount_detail']);

                        //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) {

                                $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; //$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'];



                            }
                            // 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;
                        } else {

                            $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;

            $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');
            // Exact match inside dash-separated payment_id
            $this->db->where(
                "FIND_IN_SET(" . $this->db->escape($id_new) . ", REPLACE(payment_id, '-', ',')) !=",
                0,
                false
            );

            $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()
    {


        $setting_result      = $this->setting_model->get();
        $data['settinglist'] = $setting_result;
        $record              = $this->input->post('data');
        $record_array        = json_decode($record);

        $fees_array = array();
        $students_data = array();
        $miscellaneousfees = array();
        $miscellaneousfees_2 = array();
        $newArray = array();
        $route_fees = array();
        $newArray_hostel = array();
        $hostel_fees = array();
        $discount_not_applied = array();
        $all_student_ids = 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;
            //echo $fee_groups_feetype_id;
            $student_session_ids   = $value->student_session_id;
            $fee_group_count       = $value->fee_group_count;
            $sibling_session_ids   = $value->siblling_session_id;

            if (!is_array($sibling_session_ids)) {
                $sibling_session_ids = !empty($sibling_session_ids) ? (array) $sibling_session_ids : array();
            }

            if (!empty($sibling_session_ids)) {
                $all_student_ids = array_merge(array($student_session_ids), $sibling_session_ids);
            } else {
                $all_student_ids = array($student_session_ids); // If no siblings, use only the main student ID
            }

            $all_student_ids = array_values(array_unique(array_filter($all_student_ids, 'strlen')));


            foreach ($all_student_ids as $student_session_id) {
                $thf = $value->thf;

                // Fetch fee details
                $feeList = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetypeByUsingStudentSessionId($fee_session_group_id, $student_session_id, $fee_groups_feetype_id);



                // print_r($feeList);
                if ($feeList) {
                    $feeList->fee_group_count = $fee_group_count;
                    $feeList->thf = $thf;
                } else {
                    $feeList = (object) ['fee_group_count' => $fee_group_count, 'thf' => $thf, 'amount' => 0]; // Default if empty
                }

                // Check if student data exists, otherwise initialize
                if (!isset($students_data[$student_session_id])) {
                    $students_data[$student_session_id] = array(
                        'fees' => array(),
                        'student' => $this->student_model->getByStudentSession($student_session_id),
                        'miscellaneous_fees' => $this->studentfeemaster_model->getStudentMiscellaneousFees($student_session_id),
                        'miscellaneous_fees_2' => $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_session_id)),
                        'transport_fees' => $this->studentfeemaster_model->getdate_transport_fee($student_session_id),
                        'route_fees' => $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student_session_id),
                        'hostel_fees_details' => $this->studentfeemaster_model->getdate_hostel_fee($student_session_id),
                        'hostel_fees' => $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student_session_id),
                        'discount_not_applied' => $this->getNotAppliedDiscount($student_session_id),

                    );

                    $miscellaneousfees = array_merge($miscellaneousfees, (array) $students_data[$student_session_id]['miscellaneous_fees']);
                    $miscellaneousfees_2 = array_merge($miscellaneousfees_2, (array) $students_data[$student_session_id]['miscellaneous_fees_2']);
                    $newArray = array_merge($newArray, (array) $students_data[$student_session_id]['transport_fees']);
                    $route_fees = array_merge($route_fees, (array) $students_data[$student_session_id]['route_fees']);
                    $newArray_hostel = array_merge($newArray_hostel, (array) $students_data[$student_session_id]['hostel_fees_details']);
                    $hostel_fees = array_merge($hostel_fees, (array) $students_data[$student_session_id]['hostel_fees']);
                    $discount_not_applied = array_merge($discount_not_applied, (array) $students_data[$student_session_id]['discount_not_applied']);
                }

                // Append the new fee data instead of overwriting
                $students_data[$student_session_id]['fees'][] = $feeList;
            }
        }


        $data = array(
            'miscellaneousfees' => $miscellaneousfees,
            'miscellaneousfees_2' => $miscellaneousfees_2,
            'newArray' => $newArray,
            'route_fees' => $route_fees,
            'newArray_hostel' => $newArray_hostel,
            'hostel_fees' => $hostel_fees,
            'feearray' => $fees_array,
            'discount_not_applied' => $discount_not_applied,
            'fee_master_id' => $fee_master_id,
            'all_student_ids' => $all_student_ids,
            'students_data' => $students_data
        );

        // clear_logs();
        // log_debug("IN GETCOLLECT FEE: 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';

        // Fetch the main student
        $student = $this->student_model->getByStudentSession($id);
        $data['student'] = $student;

        $student_session_id = $id; // Now accessible from URL
        // $sibling_session_ids = $this->input->post('sibling_session_ids');
        $sibling_session_ids = [];
        $siblings = $this->student_model->getMySiblings($student['parent_id'], $student['id']);


        if (!empty($siblings)) {
            $current_session_id = $this->setting_model->getCurrentSession();
            foreach ($siblings as $sibling) {
                $sibling_session = $this->db->select('id')
                    ->from('student_session')
                    ->where('student_id', $sibling->id)
                    ->where('session_id', $current_session_id)
                    ->get()
                    ->row();
                if ($sibling_session) {
                    $sibling_session_ids[] = $sibling_session->id;
                }
            }
        }
        $data['sibling_session_ids'] = $sibling_session_ids;

        // Ensure $sibling_session_ids is an array, else default to an empty array
        if (!empty($sibling_session_ids) && is_array($sibling_session_ids)) {
            $all_student_ids = array_merge([$id], $sibling_session_ids);
        } else {
            $all_student_ids = [$id]; // If no siblings are selected, use only the main student ID
        }

        // Initialize arrays
        $student_due_fee = [];
        $miscellaneousfees = [];
        $newArray = [];
        $route_fees = [];
        $newArray_hostel = [];
        $hostel_fees = [];
        $student_feediscount = [];
        $miscellaneousfees_2 = [];
        $discount_not_applied = [];

        // Loop through each student ID (main + siblings)
        foreach ($all_student_ids as $student_id) {


            $student_due_fee = array_merge($student_due_fee, (array)$this->studentfeemaster_model->getStudentFees($student_id));

            $student_miscellaneousfees = (array)$this->studentfeemaster_model->getStudentMiscellaneousFees($student_id);
            $miscellaneousfees = array_merge($miscellaneousfees, $student_miscellaneousfees);
            $student_miscellaneousfees_2 = (array)$this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_id));
            $miscellaneousfees_2 = array_merge($miscellaneousfees_2, $student_miscellaneousfees_2);

            $student_transport_fees = (array)$this->studentfeemaster_model->getdate_transport_fee($student_id);
            $newArray = array_merge($newArray, $student_transport_fees);



            $student_route_fees = (array)$this->studentfeemaster_model->getAssignFeeRouteBystudnet($student_id);
            $route_fees = array_merge($route_fees, $student_route_fees);


            $student_hostel_fees_details = (array)$this->studentfeemaster_model->getdate_hostel_fee($student_id);
            $newArray_hostel = array_merge($newArray_hostel, $student_hostel_fees_details);


            $student_hostel_fees = (array)$this->studentfeemaster_model->getAssignFeeHostelBystudnet($student_id);
            $hostel_fees = array_merge($hostel_fees, $student_hostel_fees);

            $student_discount_not_applied = (array)$this->getNotAppliedDiscount($student_id);
            $discount_not_applied = array_merge($discount_not_applied, $student_discount_not_applied);


            $student_feediscount = array_merge($student_feediscount, (array)$this->feediscount_model->getStudentFeesDiscount($student_id));
        }



        // Store everything in $data
        $data['student_due_fee'] = $student_due_fee;
        $data['miscellaneousfees'] = $miscellaneousfees;
        $data['newArray'] = $newArray;
        $data['route_fees'] = $route_fees;
        $data['newArray_hostel'] = $newArray_hostel;
        $data['hostel_fees'] = $hostel_fees;
        $data['student_feediscount_fee'] = $student_feediscount;
        $data['miscellaneousfees_2'] = $miscellaneousfees_2;
        $data['discount_not_applied'] = $discount_not_applied;


        // Fetch class-related data

        $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);
        $data["studentlistbysection"] = $studentlistbysection;



        // Load the view
        $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);




        for ($i = 0; $i < count($array_fee_groups_feetype_id); $i++) {
            $values = explode("-", $array_fee_groups_feetype_id[$i]);

            $feeList               = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($values[0], $values[1], $values[2]);

            $feeList_js = json_encode($feeList);



            $feeList->fee_group_count = $array_fee_group_count[$i];
            $feeList->thf = $array_thf[$i];
            $feeList->fee_receipt_no = $array_fee_receipt_no[$i];



            $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));



        $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;
        }


        $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);

            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;
                    } 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];
                        }

                        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;
                }
            }
        }
        $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


            $student_sesssion_array = isset($student_session_id)  ? $student_session_id : 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);

                // 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(),

                        );
                        $this->studentfeemaster_model->addmiscellaneous($insert_array); //addroute($insert_array);


                    }
                }
                if (!empty($result_array)) { //$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);

                $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);

            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) {



                        $route_fees_month_array    = $this->studentfeemaster_model->getdate_transport_fee($value, '', 1); //

                        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_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;
            }



            $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);
            }


            if ($set == 0) {
                // }
                $preserve_record = array();
                if (!empty($student_sesssion_array)) {

                    foreach ($student_sesssion_array as $key => $value) {


                        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_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;
            }


            $set = 0;
            if (count($student_sesssion_array) > 0) {
                foreach ($student_session_id as $ds) {
                    $student_due_fee     = $this->studentfeemaster_model->getStudentFees($ds);


                    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) {


                                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);



                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) {



                            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);  
            }



            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;
        $paid_before_due = false;
        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 (isset($amount_detail_value->date) && $result->due_date != "0000-00-00" && $result->due_date != null) {
                    if (strtotime($amount_detail_value->date) <= strtotime($result->due_date)) {
                        $paid_before_due = true;
                    }
                }
            }
        }

        if (!$paid_before_due && empty($result->amount_detail) && strtotime($result->due_date) < strtotime(date('Y-m-d'))) {
            $fee_fine_amount = $result->fine_amount;
        }


        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];
                            }
                        }
                    }
                    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'];
                            }
                        }
                    }


                    $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'];
                        }
                    }
                }


                $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);
            }
        }






        $fine_amount = max($fee_fine_amount - $amount_fine, 0);


        $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()
    {

        $staff_record = $this->session->userdata('admin');
        $this->form_validation->set_error_delimiters('', '');

        $this->form_validation->set_rules('collected_date', $this->lang->line('date'), 'required|trim|xss_clean');

        $this->form_validation->set_rules('tableData', 'tableData', 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'collected_date' => form_error('collected_date'),
                'tableData' => form_error('tableData'),

            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {


            // Retrieve the JSON string from the POST data
            $tableDataJson = $_POST['tableData'];
            $decodedData = json_decode($tableDataJson, true);

            // Extract both
            $tableDataArrays = $decodedData['tableData'];
            $frontend_pending_amount = $decodedData['pending_amount'];
            $partial_receipt_mode = !empty($decodedData['partial_receipt_mode']);


            $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');


            $temp_error = 0;
            $main_total_amount = 0;

            $pending_months = [];

            foreach ($tableDataArrays as $tableDataArray) {
                foreach ($tableDataArray as $month => $details) {
                    $include_in_receipt = !empty($details['include_in_receipt']);

                    if ($partial_receipt_mode && !$include_in_receipt) {
                        $details['received'] = 0;
                        $details['discount'] = 0;
                        $details['display_discount'] = 0;
                        $details['fine'] = 0;
                        $details['display_fine'] = 0;
                        $details['cash_received'] = 0;
                    }

                    //calculates the pending months
                    if ((intval($details['discount']) + intval($details['received'])) < intval($details['total'])) {

                        $pending_months[] = $month;
                    }


                    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']),
                            'display_discount' => intval($details['display_discount'] ?? $details['discount']),
                            'amount_fine' => intval($details['fine']),
                            'display_fine' => intval($details['display_fine'] ?? $details['fine']),
                            'cash_received' => intval($details['cash_received'] ?? (intval($details['received']) + intval($details['fine']))),
                            'payment_mode' => $_POST['payment_mode_fee'] ?? 'Cash',
                            'received_by' => $staff_record['id'],
                            'total' => intval($details['total'])
                        ];

                        foreach ($details as $key => $value) {
                            if (is_array($value) && isset($value['amount'], $value['total_amount']) && is_numeric($value['amount']) && is_numeric($value['total_amount']) && intval($value['amount']) >= 0 && intval($value['total_amount']) > 0) {
                                $json_array[$key] = [
                                    'total_amount' => $value['total_amount'],
                                    'amount' => $value['amount']
                                ];
                            }
                        }

                        $should_store_for_receipt = (intval($details['received']) > 0 || intval($details['discount']) > 0 || intval($details['fine']) > 0);

                        if ($partial_receipt_mode) {
                            $should_store_for_receipt = $include_in_receipt && $should_store_for_receipt;
                        }

                        if ($should_store_for_receipt) {
                            $collected_array[] = [
                                'student_fees_master_id' => $details['student_fees_master_id']['amount'],
                                'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['amount'],
                                'amount_detail' => $json_array
                            ];

                            $collected_new_array[] = [
                                'student_fees_master_id' => $details['student_fees_master_id']['amount'],
                                'fee_groups_feetype_id' => $details['fee_groups_feetype_id']['amount'],
                                'fee_session_group_id' => $details['fee_session_groups_id']['amount'],
                                'fee_group_count' => $details['fee_group_count']['amount'],
                                'thf' => $details['thf']['amount'],
                                '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;
                    }
                }
            }


            // Remove duplicate pending months before saving
            $pending_months = array_values(array_unique(array_map('trim', $pending_months)));

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

            //this is used to store the pending months and pending amountes 
            $this->studentfeemaster_model->updatePendingMonthAndAmount($fee_receipt_no_id, $pending_months, $frontend_pending_amount);

            $fees_record    = json_decode($deposited_fees);
            $keys = array_values($tableDataArray);

            // for ($i = 0; $i < count($keys); $i++) {
            //                 $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();
            //           }



            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);
            }
        }
    }

    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();

        // 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();




            $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) {




                                if (count($fee->fees) >= 3 && !empty($fee_value->amount_detail)) {



                                    $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;
                                    }



                                    $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)));




                                        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 ($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');
        $sibling_student_session_ids = $this->student_model->getAllSiblingStudentSessionIds();
        //$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) {

                    if (in_array($fee_due_value->student_session_id, $sibling_student_session_ids)) {
                        continue;
                    }


                    //  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);





                        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()
    {



        //$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


        $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) {
                        //calculate the paid amounts
                        $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_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_hostel_fee(intval($fee_due_value->student_session_id)); // $hostelfees



                $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet(intval($fee_due_value->student_session_id));


                $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']);
                }



                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)) {
                                        // Same print names should be shown as one head with the combined amount.
                                        $misc_print_name = trim((string)$cmp[$i]);
                                        $misc_amount = floatval($cmf[$i]);
                                        if ($misc_print_name === '') {
                                            continue;
                                        }
                                        if (!isset($misc_fees_map[$misc_print_name])) {
                                            $misc_fees_map[$misc_print_name] = 0;
                                        }
                                        $misc_fees_map[$misc_print_name] += $misc_amount;
                                        $f_months += $misc_amount;
                                    }
                                }
                            }

                            // 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;     
                            $total_amount = $fee_value->amount + $f_months - 1;

                            $students_list5[$fee_due_value->student_session_id][$fee_value->code] = $total_amount;
                            $fee_breakdown = [];
                            $fee_breakdown['Tuition Fee'] = $fee_value->amount - 1; // Base tuition fee
                            $fee_breakdown = array_merge($fee_breakdown, $misc_fees_map); // Add all misc fees
                            $students_fee_structure[$fee_due_value->student_session_id][$fee_value->code] = $fee_breakdown;
                        } 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);

        // echo "All data :<pre>";print_r($data);echo "</pre>";exit();



        $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);
    }

    public function apply_transport_or_hostel_fee()
    {
        error_reporting(E_ALL);
        ini_set('display_errors', 1);

        $this->session->set_userdata('top_menu', 'Fees Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/apply_transport_or_hostel_fee');

        $data = array();
        $data['classlist'] = $this->class_model->get();

        // Load System Settings
        $sch_setting = $this->sch_setting_detail; // Adjusted model name based on standard CI structure

        $current_session_id = $sch_setting->session_id;

        // echo "<pre>";
        //     print_r($sch_setting);
        //     echo "</pre>";
        //     exit();

        $data['sch_setting'] = $sch_setting;

        // Load Dropdown Data
        $data['vehroutelist'] = $this->route_model->listroute();
        $data['hostelList']   = $this->hostel_model->get();

        // Initialize variables
        $class_id     = $this->input->post('class_id') ? $this->input->post('class_id') : null;
        $section_id   = $this->input->post('section_id') ? $this->input->post('section_id') : null;
        $is_transport = $this->input->post('is_transport') ? $this->input->post('is_transport') : 'yes';

        $data['students'] = [];

        // ==========================================
        // 1. CHECK IF SAVE BUTTON WAS CLICKED
        // ==========================================
        if ($this->input->post('action_type') == 'save_data') {

            $posted_data = $this->input->post();

            foreach ($posted_data['student_session_ids'] as $student_session_id) {

                if ($posted_data["is_transport"] == "yes") {

                    // ========= PROCESS THE TRANSPORT SERVICES ============

                    $transport_service_applied_or_cancel_month = $posted_data['month'][$student_session_id];

                    if (!empty($transport_service_applied_or_cancel_month)) {
                        $month =  $transport_service_applied_or_cancel_month;
                        $currentyear = date('Y');
                        $transport_service_applied_or_cancel_date = date('Y-m-d', mktime(0, 0, 0, $month, 1, $currentyear));
                    } else {
                        // fallback to today’s date
                        $transport_service_applied_or_cancel_date = date('Y-m-d');
                    }

                    $route_id = empty($posted_data['route_id'][$student_session_id]) ? 0 : $posted_data['route_id'][$student_session_id];
                    $old_route_id = $posted_data['old_route_id'][$student_session_id];
                    $old_vehroute_id = $posted_data['old_vehroute_id'][$student_session_id];
                    $old_transport_route_created_at = $posted_data['old_transport_route_created_at'][$student_session_id];

                    if (!empty($route_id)) {

                        $route_data = $this->route_model->get($route_id);

                        if ($old_route_id == $route_data['route_id']) {
                            if ($transport_service_applied_or_cancel_date != $old_transport_route_created_at) {
                                $this->studentfeemaster_model->update_transport_route_created_at($student_session_id, $old_route_id, $old_vehroute_id, $current_session_id, $transport_service_applied_or_cancel_date);
                            }
                        } else {

                            // disabled previous service 
                            if (!empty($old_route_id)) {
                                $this->studentfeemaster_model->disabled_transport_service($student_session_id, $old_route_id, $old_vehroute_id, $current_session_id, $transport_service_applied_or_cancel_date);
                            }

                            // enable new service
                            $insert_array = array(
                                'student_session_id'   => $student_session_id,
                                'route_id' => $route_data['route_id'],
                                //'route_fees'=>$route_fees,
                                'vehroute_id' => $route_data['vehicle_id'],
                                'session_id' => $current_session_id,
                                'transport_route_created_at' => $transport_service_applied_or_cancel_date,
                                'transport_route_deleted_at' => null,
                            );
                            $this->studentfeemaster_model->addroute($insert_array);
                        }
                    } else {

                        if (!empty($old_route_id)) {
                            // Disable transport services 
                            $this->studentfeemaster_model->disabled_transport_service($student_session_id, $old_route_id, $old_vehroute_id, $current_session_id, $transport_service_applied_or_cancel_date);
                        }
                    }
                    // ================== TRANSPORTS SERVICES ENDS HERE ====================

                } else {
                    // =========== PROCESS THE HOSTEL SERVICES ===========

                    $hostel_room_assign_or_cancel_month  = $posted_data["month"][$student_session_id];

                    if (!empty($hostel_room_assign_or_cancel_month)) {
                        $month =  $hostel_room_assign_or_cancel_month;
                        $currentyear = date('y');
                        $hostel_room_assign_or_cancel_date = date('Y-m-d', mktime(0, 0, 0, $month, 1, $currentyear));
                    } else {
                        // fallback to today’s date
                        $hostel_room_assign_or_cancel_date = date('Y-m-d');
                    }

                    $hostel_id = $posted_data["hostel_id"][$student_session_id];
                    $hostel_room_id = empty($posted_data["hostel_room_id"][$student_session_id]) ? 0 : $posted_data["hostel_room_id"][$student_session_id];

                    //   old ids
                    $old_hostel_room_created_at  = $posted_data["old_hostel_room_created_at"][$student_session_id];
                    $old_hostel_id = $posted_data["old_hostel_id"][$student_session_id];
                    $old_hostel_room_id = empty($posted_data["old_hostel_room_id"][$student_session_id]) ? 0 : $posted_data["old_hostel_room_id"][$student_session_id];

                    if (!empty($hostel_id) && !empty($hostel_room_id)) {

                        $hostelroom_data = $this->hostelroom_model->get($hostel_room_id);

                        if (($hostel_id == $old_hostel_id) && ($hostel_room_id == $old_hostel_room_id)) {

                            if ($hostel_room_assign_or_cancel_date != $old_hostel_room_created_at) {

                                $this->studentfeemaster_model->update_hostel_room_created_at($student_session_id, $old_hostel_id, $old_hostel_room_id, $current_session_id, $hostel_room_assign_or_cancel_date);
                            }
                        } else {

                            // hogic for hostel changed
                            if (!empty($old_hostel_id)) {
                                $this->studentfeemaster_model->disabled_hostel_service($student_session_id, $old_hostel_id, $old_hostel_room_id, $current_session_id, $hostel_room_assign_or_cancel_date);
                            }

                            // if changed insert new 
                            $insert_array = array(
                                'student_session_id'   => $student_session_id,
                                'hostel_room_id' => $hostelroom_data['id'],
                                'hostel_id' => $hostel_id,
                                'session_id' => $current_session_id,
                                'hostel_room_created_at' => $hostel_room_assign_or_cancel_date,
                                // 'fee_session_group_id' => $fee_session_groups,
                            );

                            $this->studentfeemaster_model->addroom($insert_array);
                        }
                    } else {
                        // wnats to remove the transports service 
                        $this->studentfeemaster_model->disabled_hostel_service($student_session_id, $old_hostel_id, $old_hostel_room_id, $current_session_id, $hostel_room_assign_or_cancel_date);
                    }

                    // ================ HOstel services ends here ==============
                }
            }
        }

        // ==========================================
        // 2. CHECK IF SEARCH FILTER WAS CLICKED
        // ==========================================
        if ($this->input->post('search') == 'search_filter') {

            $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
            $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');

            if ($this->form_validation->run() == false) {
                // Form validation failed, reload view with errors
            } else {
                // Get Students
                $data['students'] = $this->student_model->getStudentDataByClassIdSectionId($class_id, $section_id);
            }
        }

        // Pass preserved variables back to view
        $data['class_id']     = $class_id;
        $data['section_id']   = $section_id;
        $data['is_transport'] = $is_transport;

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

    // =========================== sibling demand billl ===============
    public  function siblingdemandbill()
    {
        //       error_reporting(E_ALL);
        // ini_set('display_errors', 1);


        $this->session->set_userdata('top_menu', 'Reports');
        $this->session->set_userdata('sub_menu', 'Reports/finance');
        $this->session->set_userdata('subsub_menu', 'Reports/finance/siblingdemandbill');
        $data = [];
        $errors = [];
        $sch_setting = $this->sch_setting_detail;
        /* ---------------- DEFAULT DATES ---------------- */
        $start_month = (int) $sch_setting->start_month;

        // Academic year handling (professional touch)
        $current_month = (int) date('n');
        $year = ($current_month < $start_month) ? date('Y') - 1 : date('Y');


        if ($this->input->server('REQUEST_METHOD') === 'POST' && $this->input->post('search') === 'search_filter') {
            // run when form is submited
            $from_date = trim($this->input->post('from_date'));
            $to_date   = trim($this->input->post('to_date'));

            // validation starts 
            if (!$from_date) {
                $errors['from_date'] = 'From Date is required';
            }

            if (!$to_date) {
                $errors['to_date'] = 'To Date is required';
            }

            if ($start_date > $end_date) {
                $errors['from_date'] = 'From Date cannot be greater than To Date';
            }

            // validation ends 

            if (empty($errors)) {
                $start_date = date('Y-m-d', strtotime($from_date));
                $end_date   = date('Y-m-d', strtotime($to_date));
                //========================== Main Logic starts here ===================================
                // STEP 1 : Get sibling student session ids
                $sibling_student_session_ids =
                    $this->student_model->getAllSiblingStudentSessionIds();



                // STEP 2 : Get parents with siblings
                $parentsWithSiblings =
                    $this->student_model->getParentsWithSiblingStudents();

                $final_demand_bill_data = $this->processAllFeesByStudentSessionId($sibling_student_session_ids, $start_date, $end_date);




                // echo "<pre>";
                // print_r($final_demand_bill_data);
                // echo "<pre>";
                // echo "ends of process demand bills<hr>";


                foreach ($parentsWithSiblings as &$parent) {

                    foreach ($parent['siblings'] as &$child) {

                        $sessionId = $child['student_session_id'];

                        // Attach fee structure if exists
                        $child['fee_structure'] = $final_demand_bill_data[$sessionId] ?? [
                            'fees_descriptions' => [],
                            'fees_final_calculations' => 0
                        ];
                    }
                }



                // echo "<pre>";
                // print_r($parentsWithSiblings);
                // echo "<pre>"; 
                // exit;

                // ========================================  Main logic ends here ==================================

            }





            // $start_date = $from_date; 
            // $end_date= $to_date; 
        } else {
            //handel while without submit the form

            $start_date = date($year . '-' . $start_month . '-01');
            $end_date = date('Y-m-d');
        }


        $data['start_date'] = $start_date;
        $data['end_date'] = $end_date;
        $data['sch_setting'] = $sch_setting;
        $data['parentsWithSiblings'] = $parentsWithSiblings;
        $data['errors'] = $errors;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/siblingDemandBill', $data);

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

    public function printsiblingdemandbill()
    {
        try {

            $ids = $this->input->post('parent_ids');

            if (empty($ids)) {
                throw new Exception("Parent IDs missing");
            }

            $parents_ids = explode(',', $ids);
            $start_date = $this->input->post('start_date');
            $end_date   = $this->input->post('end_date');

            if (!$start_date || !$end_date) {
                throw new Exception("Start date or End date missing");
            }

            $sibling_details = $this->student_model->getSiblingStudentByUsingParentIds($parents_ids);

            if (empty($sibling_details)) {
                throw new Exception("No sibling data found");
            }

            $parentsWithSiblings = $sibling_details['parentsWithSiblings'];
            $sibling_student_session_ids = $sibling_details['sibling_student_session_ids'];

            $final_sibling_demand_bill_data = $this->processAllFeesByStudentSessionId(
                $sibling_student_session_ids,
                $start_date,
                $end_date
            );

            $parentsSiblingsWIthFeeStructure = $this->attachFeeStructureToSiblings(
                $parentsWithSiblings,
                $final_sibling_demand_bill_data
            );

            $mergefee = $this->mergeSiblingFees($parentsSiblingsWIthFeeStructure);

            $data['parentsWithSiblings'] = $mergefee;

            $page = $this->load->view('reports/_print_sibling_demand_bill', $data, true);

            echo json_encode([
                'status' => 1,
                'page'   => $page
            ]);
        } catch (Exception $e) {

            // ✅ RETURN ERROR TO FRONTEND
            echo json_encode([
                'status' => 0,
                'message' => $e->getMessage()
            ]);
        }
    }




    function attachFeeStructureToSiblings(array $parents, array $feesData): array
    {
        foreach ($parents as &$parent) {

            if (empty($parent['siblings'])) {
                continue;
            }

            foreach ($parent['siblings'] as &$child) {

                $sessionId = $child['student_session_id'] ?? null;

                // attach safely
                $child['fee_structure'] = $feesData[$sessionId] ?? [
                    'fees_descriptions' => [],
                    'fees_final_calculations' => 0,
                    'total_fine_amount' => 0,
                    'outstanding_fine_amount' => 0,
                    'balance_amount' => 0
                ];
            }
        }

        return $parents;
    }


    function mergeSiblingFees($parents)
    {
        $mergedResult = [];

        foreach ($parents as $parent) {

            $parentId = $parent['parent_id'];

            // 1. Initialize the Parent AND Children at the top level
            $mergedResult[$parentId] = [
                'parent_info' => [
                    'father_name' => $parent['father_name'],
                    'mother_name' => $parent['mother_name'],
                    'phone'       => $parent['father_phone']
                ],
                'children_info' => [], // <-- Store children here, safely
                'merged_fees'   => []
            ];

            foreach ($parent['siblings'] as $sibling) {

                // 2. Add each child to the children_info array ONCE
                $studentName = trim($sibling['firstname'] . ' ' . $sibling['middlename'] . ' ' . $sibling['lastname']);

                // Check to prevent duplicates if data is messy
                $is_already_added = false;
                foreach ($mergedResult[$parentId]['children_info'] as $existing_child) {
                    if ($existing_child['admission_no'] === $sibling['admission_no']) {
                        $is_already_added = true;
                        break;
                    }
                }

                if (!$is_already_added) {
                    $mergedResult[$parentId]['children_info'][] = [
                        'name'          => $studentName,
                        'admission_no'  => $sibling['admission_no'],
                        'class_section' => $sibling['class'] . '/' . $sibling['section'],
                        'roll_no' => $sibling['roll_no'],
                    ];
                }

                // 3. Process the Fees
                $feeDescriptions = $sibling['fee_structure']['fees_descriptions'];

                foreach ($feeDescriptions as $key => $feeData) {
                    if (
                        (($feeData['status'] ?? '') === 'paid') ||
                        (float)($feeData['unpaid_amount'] ?? 0) <= 0
                    ) {
                        continue;
                    }

                    $monthKey = $this->normalizeFeeKey($key);

                    $fineAmount = isset($feeData['fine Amount']) ? (float)$feeData['fine Amount'] : 0;

                    if (!isset($mergedResult[$parentId]['merged_fees'][$monthKey])) {
                        $mergedResult[$parentId]['merged_fees'][$monthKey] = [
                            'total_original' => 0,
                            'total_discount' => 0,
                            'total_paid'     => 0,
                            'total_unpaid'   => 0,
                            'total_fine'     => 0,
                            'total_outstanding_fine' => 0,
                            'total_unapplied_discount' => 0,
                            'fee_breakdown'  => [] // Stores the L-arrow breakdowns
                        ];
                    }

                    // Aggregate totals
                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_original'] += (float)$feeData['original_amount'];


                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_discount'] += $feeData['discount_amount'];

                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_paid']     += (float)$feeData['paid_amount'];
                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_unpaid']   += (float)$feeData['unpaid_amount'];
                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_fine']     += $fineAmount;
                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_outstanding_fine'] += (float)($feeData['outstanding_fine_amount'] ?? 0);

                    $pending_discount = 0;
                    if (($feeData['status'] ?? '') === 'unpaid') {
                        $pending_discount = (float)($feeData['discount_amount'] ?? 0);
                    } elseif (($feeData['status'] ?? '') === 'partially paid') {
                        $pending_discount = (float)($feeData['unapplied_discount'] ?? 0);
                    }
                    $mergedResult[$parentId]['merged_fees'][$monthKey]['total_unapplied_discount'] += $pending_discount;

                    // Merge expandable fee structure (L-arrows)
                    if (!empty($feeData['expandable_fee_structure'])) {
                        foreach ($feeData['expandable_fee_structure'] as $k => $amount) {
                            $feeName = $this->normalizeBreakdownKey($k);

                            if (!isset($mergedResult[$parentId]['merged_fees'][$monthKey]['fee_breakdown'][$feeName])) {
                                $mergedResult[$parentId]['merged_fees'][$monthKey]['fee_breakdown'][$feeName] = 0;
                            }
                            $mergedResult[$parentId]['merged_fees'][$monthKey]['fee_breakdown'][$feeName] += (float)$amount;
                        }
                    }
                }
            }
        }

        return array_values($mergedResult);
    }


    private function normalizeFeeKey($key)
    {
        // Monthly Fee → extract month only
        if (strpos($key, 'MONTH FEE') !== false) {
            return trim(explode('(', $key)[0]);
            // "JUNE MONTH FEE"
        }

        // ne-time Fee → take last bracket
        if (preg_match('/\(([^()]*)\)$/', $key, $matches)) {
            return trim($matches[1]);
            // "Saraswati Puja"
        }

        return $key;
    }

    private function normalizeBreakdownKey($key)
    {
        // remove bracket part completely
        $cleanKey = preg_replace('/\s*\(.*?\)\s*/', '', $key);

        return trim($cleanKey);
    }


    public function processAllFeesByStudentSessionId($student_session_ids, $start_date, $end_date)
    {


        $student_raw_fee = $this->studentfeemaster_model->getStudentFeesBySessionIds($student_session_ids, $start_date, $end_date);

        $miscellaneousfees  = $this->studentfeemaster_model->getStudentMiscellaneousFeesBatchCached($student_session_ids);


        $transports_data_for_sibling = $this->studentfeemaster_model->getTransportRouteBatch($student_session_ids);

        $students_discounts = $this->feediscount_model->getStudentFeesDiscountBatch($student_session_ids);

        $hostels_data_for_sibling = $this->studentfeemaster_model->getHostelBatch($student_session_ids);

        // echo "Discounts<pre>";
        // print_r($students_discounts);
        // echo "</pre>";

        // echo "<hr> process fee data";
        // exit;

        // handel the date filtered 

        $selectedMonths = [];

        // $period = new DatePeriod(
        //     new DateTime($start_date),
        //     new DateInterval('P1M'),
        //     (new DateTime($end_date))->modify('+1 month')
        // );


        $period = new DatePeriod(
            new DateTime($start_date),
            new DateInterval('P1M'),
            (new DateTime($end_date))
        );

        //   echo "period starts <pre>";
        //             print_r($period);
        //             echo "</pre>";

        $monthMapping = [
            1 => 'JAN',
            2 => 'FEB',
            3 => 'MARCH',
            4 => 'APRIL',
            5 => 'MAY',
            6 => 'JUNE',
            7 => 'JULY',
            8 => 'AUG',
            9 => 'SEP',
            10 => 'OCT',
            11 => 'NOV',
            12 => 'DEC'
        ];

        foreach ($period as $dt) {
            $month_num = (int)$dt->format('n'); // Gets the month number (1-12)
            if (isset($monthMapping[$month_num])) {
                $selectedMonths[] = $monthMapping[$month_num];
            }
        }

        //   echo "selectedMonths starts <pre>";
        //         print_r($selectedMonths);
        //         echo "</pre>";
        // exit;

        $final_structured_fee = [];

        foreach ($student_raw_fee as $student_session_id => $student_fee) {


            $total_demand_bill_per_student = 0;
            $total_fine_amount = 0;
            $total_outstanding_fine_amount = 0;

            $transportMonths = isset($transports_data_for_sibling[$student_session_id]) ? $transports_data_for_sibling[$student_session_id]['months'][0] : [];

            $hostelMonths = isset($hostels_data_for_sibling[$student_session_id]) ? $hostels_data_for_sibling[$student_session_id]['months'][0] : [];

            //  STEP : 1 process the miscellaneousfees

            foreach ($miscellaneousfees[$student_session_id] 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']);
            }



            $structured_monthly_fee = [];

            foreach ($student_fee as $fee_value) {

                // echo "<pre>";
                // print_r($fee_value);
                // echo "</pre>";



                if ($fee_value->name === "TUITION FEE") {
                    // $count3 = 0;
                    foreach ($fee_value->fees as $monthly_fees) {

                        // DATE RANGE FILTER (MUST BE FIRST)
                        if (!empty($monthly_fees->due_date)) {

                            $today     = date('Y-m-d');
                            $due_date = date('Y-m-d', strtotime($monthly_fees->due_date));

                            if (
                                strtotime($due_date) < strtotime($start_date) ||
                                strtotime($due_date) > strtotime($end_date)
                            ) {
                                continue;
                            }
                        }

                        $current_month = explode(' ', $monthly_fees->code)[0];

                        $expandable_fee_structure = [];

                        $original_amount = 0;

                        $discount_amount = 0;

                        $paid_amount = 0;
                        $paid_fee_amount = 0;
                        $paid_fine_amount = 0;
                        $unpaid_amount = 0;
                        $fine_amount = 0;
                        $outstanding_fine_amount = 0;
                        $status = "unpaid";



                        //  STEP : 2 process the miscellaneousfees

                        if (!empty($cmm)) {

                            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($current_month, $normalized_cmm)) {

                                    $expandable_fee_structure[$cmp[$i]] = $cmf[$i];

                                    $original_amount += $cmf[$i];
                                }
                            }
                        }


                        //  FIX 1: Clean the current month string to remove hidden spaces
                        $clean_current_month = trim($current_month);

                        //  FIX 2: REMOVE the 'true' strict check from in_array!

                        // Process transport for students
                        if ((!empty($transportMonths)) && in_array($clean_current_month, $transportMonths) && in_array($clean_current_month, $selectedMonths)) {
                            $original_amount += $transports_data_for_sibling[$student_session_id]['route'][0]['fare'];
                            $expandable_fee_structure["Transport Fee (" . $transports_data_for_sibling[$student_session_id]['route'][0]['route_title'] . " )"] = $transports_data_for_sibling[$student_session_id]['route'][0]['fare'];
                        }

                        // Process hostel data 
                        if ((!empty($hostelMonths)) && in_array($clean_current_month, $hostelMonths) && in_array($clean_current_month, $selectedMonths)) {
                            $original_amount += $hostels_data_for_sibling[$student_session_id]['hostel'][0]['cost_per_bed'];
                            $expandable_fee_structure["Hostel Fee ( " . $hostels_data_for_sibling[$student_session_id]['hostel'][0]['hostel_name'] . " )"] = $hostels_data_for_sibling[$student_session_id]['hostel'][0]['cost_per_bed'];
                        }

                        //process the amount paid 
                        if (!empty($monthly_fees->amount_detail)) {

                            $paid_amount_details = json_decode($monthly_fees->amount_detail);

                            foreach ($paid_amount_details as $paid_amount_detail) {
                                $paid_fee_amount += (float) ($paid_amount_detail->amount ?? 0);
                                $discount_amount += (float) ($paid_amount_detail->amount_discount ?? 0);
                                $paid_fine_amount += (float) ($paid_amount_detail->amount_fine ?? 0);
                            }
                            $paid_amount = $paid_fee_amount + $paid_fine_amount;
                            // NEW: Calculate unapplied discount
                            $calculate_discount = 0;
                            foreach ($students_discounts[$student_session_id] as $discount_key => $discount_value) {
                                $calculate_discount += $discount_value['amount'];
                            }
                            $unapplied_discount = max(0, $calculate_discount - $discount_amount);
                        } else {
                            //applied automatic discounts 
                            $calculate_discount = 0;
                            foreach ($students_discounts[$student_session_id] as $discount_key => $discount_value) {
                                $calculate_discount += $discount_value['amount'];
                            }

                            $discount_amount = $calculate_discount;
                            $unapplied_discount = 0;
                            //if no original amount then discounts also 0
                            if ($original_amount == 0) {
                                $discount_amount = 0;
                                $unapplied_discount = 0;
                            }
                        }

                        $unpaid_amount = max(0, $original_amount - $paid_fee_amount - $discount_amount - $unapplied_discount);

                        $total_demand_bill_per_student += $unpaid_amount;

                        // CORRECT STATUS
                        if ($paid_amount <= 0) {
                            $status = 'unpaid';
                        } elseif ($unpaid_amount > 0) {
                            $status = 'partially paid';
                        } else {
                            $status = 'paid';
                        }

                        if ($unpaid_amount <= 0) {
                            continue;
                        }

                        if (strtotime($today) > strtotime($due_date)) {
                            if ($status == 'unpaid' || $status == 'partially paid') {
                                $fine_amount = $monthly_fees->fine_amount;
                            } else {
                                $fine_amount = $paid_fine_amount;
                            }

                            $outstanding_fine_amount = max(0, $fine_amount - $paid_fine_amount);
                            $total_fine_amount += $fine_amount;
                            $total_outstanding_fine_amount += $outstanding_fine_amount;
                            if ($fine_amount > 0) {
                                $expandable_fee_structure["Fine Amount"] = $fine_amount;
                            }
                        }

                        $structured_monthly_fee[$monthly_fees->code . "( " . $fee_value->name . " )"] = [
                            "original_amount" => $original_amount,
                            "discount_amount" => $discount_amount,
                            "paid_amount"     => $paid_amount,
                            "unpaid_amount"   => $unpaid_amount,
                            "fine Amount"    => $fine_amount,
                            "outstanding_fine_amount" => $outstanding_fine_amount,
                            "status"          => $status,
                            "unapplied_discount" => $unapplied_discount,
                            "expandable_fee_structure" => $expandable_fee_structure
                        ];

                        //   $count3 ++; 
                    }
                } else {

                    // Process one-time fee safely
                    $oneTimeFee = $fee_value->fees[0] ?? null;

                    if ($oneTimeFee) {

                        $original_amount = (float) $oneTimeFee->amount;
                        $discount_amount = 0;
                        $paid_amount     = 0.0;
                        $paid_fee_amount = 0.0;
                        $paid_fine_amount = 0.0;
                        $unpaid_amount   = 0.0;
                        $fine_amount = 0;
                        $outstanding_fine_amount = 0;
                        $status          = 'unpaid';

                        if (!empty($oneTimeFee->amount_detail)) {

                            $paid_amount_details = json_decode($oneTimeFee->amount_detail);

                            if (json_last_error() === JSON_ERROR_NONE && (is_object($paid_amount_details) || is_array($paid_amount_details))) {

                                foreach ($paid_amount_details as $paid) {
                                    $paid_fee_amount += (float) ($paid->amount ?? 0);
                                    $discount_amount += (float) ($paid->amount_discount ?? 0);
                                    $paid_fine_amount += (float) ($paid->amount_fine ?? 0);
                                }
                                $paid_amount = $paid_fee_amount + $paid_fine_amount;
                            }
                        } else {
                            //applied automatic discounts 
                            $discount_amount = 0;
                        }

                        $unpaid_amount = max(0, $original_amount - $paid_fee_amount - $discount_amount);

                        $total_demand_bill_per_student += $unpaid_amount;

                        // CORRECT STATUS
                        if ($paid_amount <= 0) {
                            $status = 'unpaid';
                        } elseif ($unpaid_amount > 0) {
                            $status = 'partially paid';
                        } else {
                            $status = 'paid';
                        }

                        if ($unpaid_amount <= 0) {
                            continue;
                        }

                        if (!empty($oneTimeFee->due_date)) {

                            $today     = date('Y-m-d');
                            $due_date = date('Y-m-d', strtotime($oneTimeFee->due_date));

                            if (strtotime($today) > strtotime($due_date)) {
                                if ($status == 'unpaid' || $status == 'partially paid') {
                                    $fine_amount = $oneTimeFee->fine_amount;
                                } else {
                                    $fine_amount = $paid_fine_amount;
                                }

                                $outstanding_fine_amount = max(0, $fine_amount - $paid_fine_amount);
                                $total_fine_amount +=  $fine_amount;
                                $total_outstanding_fine_amount += $outstanding_fine_amount;
                            }
                        }

                        $structured_monthly_fee[$fee_value->name . " (" . $oneTimeFee->code . ")"] = [
                            "original_amount" => $original_amount,
                            "discount_amount" => $discount_amount,
                            "paid_amount"     => $paid_amount,
                            "unpaid_amount"   => $unpaid_amount,
                            "fine Amount"    => $fine_amount,
                            "outstanding_fine_amount" => $outstanding_fine_amount,
                            "status"          => $status,
                            "unapplied_discount" => 0,
                            "expandable_fee_structure" => [
                                $fee_value->name => $original_amount,
                                "Fine Amount" => $fine_amount
                            ]
                        ];
                    }
                }
            }

            //   exit();

            $final_structured_fee[$student_session_id]['fees_descriptions'] = $structured_monthly_fee;
            $final_structured_fee[$student_session_id]['fees_final_calculations'] = $total_demand_bill_per_student;
            $final_structured_fee[$student_session_id]['total_fine_amount'] = $total_fine_amount;
            $final_structured_fee[$student_session_id]['outstanding_fine_amount'] = $total_outstanding_fine_amount;
            $final_structured_fee[$student_session_id]['balance_amount'] = $total_demand_bill_per_student + $total_outstanding_fine_amount;
        }

        //   echo "final_structured_fee<pre>";
        //      print_r($final_structured_fee);
        //     echo "</pre>";


        return $final_structured_fee;
    }

    //=========================== ends hers ===========================


}