1#@!#!123s

: / home / schoolcampuserp / adarshdav.in / application / controllers /
Filename : Viewbill.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Viewbill extends CI_Controller
{

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

    public function view_bill($id, $student_session_id)
    {

        $array_fee_groups_feetype_id = explode('=', $id);
        foreach ($array_fee_groups_feetype_id as $key => $value) {
            $fee_groups_feetype_id = $value;
        }
        $loop_value_n = '';
        $loop_value = '';
        //$array_fee_groups_feetype_id = explode('-', $fee_groups_feetype_id);
        for ($i = 0; $i < count($array_fee_groups_feetype_id); $i++) {
            $values = explode("-", $array_fee_groups_feetype_id[$i]);
            //echo $array_fee_session_group_id[$i].'-'.$array_fee_master_id[$i].'-'.$array_fee_groups_feetype_id[$i]."<br>";
            $feeList               = $this->studentfeemaster_model->getDueFeeByFeeSessionGroupFeetype($values[0], $values[1], $values[2]);

            $feeList->fee_group_count = $values[3]; //$array_fee_group_count[$i];
            $feeList->thf = $values[4];
            $frn = '';
            //echo count($values)."<br>";
            if (count($values) > 8) {
                for ($j = 8; $j < count($values); $j++) {
                    if (empty($frn)) {
                        $frn = $values[7] . ',' . $values[$j];
                    } else {
                        $frn = $frn . ',' . $values[$j];
                    }
                }
                $feeList->fee_receipt_no = $frn;
            } else {
                $feeList->fee_receipt_no = $values[7];
            }
            //$values_new = explode("-", $values[5]); 
            if ($values[5] == 1 && $values[6] == $student_session_id) {
                if (empty($loop_value_n)) {
                    $loop_value_n = $values[5] . "-" . $values[6];
                } else {
                    $loop_value_n = $loop_value_n . ',' . $values[5] . "-" . $values[6];
                }
            } else {
                if ($values[6] != $student_session_id) {
                    if (empty($loop_value)) {
                        $loop_value = $values[5] . "-" . $values[6];
                    } else {
                        $loop_value = $loop_value . ',' . $values[5] . "-" . $values[6];
                    }
                }
            }

            $fees_array[]          = $feeList;
        }
        //          $miscellaneousfees    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees($student_session_id);   
        // $data['miscellaneousfees'] = $miscellaneousfees;
        $miscellaneousfees    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees(intval($student_session_id));   //$New_student_session_id[0]
        $newArray    = $this->studentfeemaster_model->getdate_transport_fee(intval($student_session_id)); //$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet(intval($student_session_id)); //getAssignFeeRouteBystudnet
        $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 (!empty($loop_value_n)) {
            $data['loop_value_n'] = $loop_value_n;
        }
        if (!empty($loop_value)) {
            $data['loop_value'] = $loop_value;
        }
        $this->load->view('print/view_bill_printFeesByGroupArray', $data);
    }


    public function view_bill_frn($fee_receipt_no_id)
    {

        if ($this->input->is_ajax_request()) {
            // Process the AJAX request
            $data['sch_setting']  = $this->sch_setting_detail;
            $data['temp'] = 1;
        }
        $payment_id = $this->studentfeemaster_model->getStudentFee_Receipt_payment_id($fee_receipt_no_id);

        if (empty($payment_id)) {
            show_error("Receipt not found or has no associated payments.", 404, "Receipt Not Found");
            return;
        }

        $array_payment_id   = array_values(array_unique(array_filter(explode("-", $payment_id))));

        if (empty($array_payment_id)) {
            show_error("No payment entries found for this receipt.", 404, "No Payments Found");
            return;
        }

        $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];
                $fee_record = $this->studentfeemaster_model->getFeeByInvoice($invoice_id, $sub_invoice_id, '', 1);
                if (!empty($fee_record)) {
                    $feeList[]   = $fee_record;
                    $sub_invoice_id_new[] = $invoice_new[1];
                }
            }
        }

        if (empty($feeList)) {
            show_error("No fee details associated with this receipt.", 404, "No Fee Details Found");
            return;
        }

        $sibling_info = $this->student_model->getSiblingsByStudentSessionId($feeList[0]["student_session_id"]);



        function yuviMergeData($data)
        {
            $new_fees = [];

            foreach ($data as $eachData) {
                $code = trim($eachData['code']);

                // Exclude codes starting with month names
                $exclude_prefixes = [
                    'APRIL',
                    'MAY',
                    'JUNE',
                    'JULY',
                    'AUG',
                    'SEP',
                    'OCT',
                    'NOV',
                    'DEC',
                    'JAN',
                    'FEB',
                    'MARCH'
                ];

                $exclude = false;
                foreach ($exclude_prefixes as $prefix) {
                    if (stripos($code, $prefix) === 0) {
                        $exclude = true;
                        break;
                    }
                }

                if (!$exclude) {
                    // Rename for display
                    $mapped_code = ($code === "Previous Session Balance") ? "Balance Master" : $code;

                    // Initialize or accumulate
                    if (!isset($new_fees[$mapped_code])) {
                        $new_fees[$mapped_code] = (object)[
                            'amount' => $eachData['value']->amount,
                            'amount_discount' => $eachData['value']->amount_discount,
                            'total_amount' => $eachData['value']->total
                        ];
                    } else {
                        $new_fees[$mapped_code]->amount += $eachData['value']->amount;
                        $new_fees[$mapped_code]->amount_discount += $eachData['value']->amount_discount;
                        $new_fees[$mapped_code]->total_amount += $eachData['value']->total;
                    }
                }
            }

            return $new_fees;
        }

        $yuviOutput = yuviMergeData($feeList);

        function mergeStudentData($data)
        {
            // Helper: normalize a fee key (remove brackets, trim, normalize case)
            function normalizeFeeKey($key)
            {
                $key = preg_replace('/\s*\(.*?\)\s*/', '', $key); // remove (anything)
                return trim($key); // keep original case/spacing except brackets
            }

            // Start with first array as the base
            $merged = $data[0];

            // Normalize base keys
            foreach ((array)$merged['value'] as $baseKey => $baseValue) {
                $normalizedKey = normalizeFeeKey($baseKey);
                if ($normalizedKey !== $baseKey) {
                    $merged['value']->$normalizedKey = $baseValue;
                    unset($merged['value']->$baseKey);
                }
            }

            for ($i = 1; $i < count($data); $i++) {
                $current = $data[$i];

                if (isset($current["code"])) {
                    if (!isset($merged["code"])) {
                        $merged["code"] = $current["code"];
                    } else {
                        $existing_codes = array_map('trim', explode(',', $merged["code"]));
                        if (!in_array(trim($current["code"]), $existing_codes)) {
                            $merged["code"] .= "," . $current["code"];
                        }
                    }
                }

                foreach ($current['value'] as $origKey => $value) {
                    $normalizedKey = normalizeFeeKey($origKey);

                    if (is_numeric($value)) {
                        // Merge numeric values directly
                        if (isset($merged['value']->$normalizedKey) && is_numeric($merged['value']->$normalizedKey)) {
                            $merged['value']->$normalizedKey += $value;
                        } else {
                            $merged['value']->$normalizedKey = $value;
                        }
                    } elseif (is_object($value)) {
                        // Add missing object
                        if (!isset($merged['value']->$normalizedKey)) {
                            $merged['value']->$normalizedKey = clone $value;
                        } else {
                            foreach ($value as $subKey => $subValue) {
                                if (is_numeric($subValue) && isset($merged['value']->$normalizedKey->$subKey)) {
                                    $merged['value']->$normalizedKey->$subKey += $subValue;
                                } elseif (is_numeric($subValue)) {
                                    $merged['value']->$normalizedKey->$subKey = $subValue;
                                }
                            }
                        }
                    } else {
                        // Non-numeric values, only add if missing
                        if (!isset($merged['value']->$normalizedKey)) {
                            $merged['value']->$normalizedKey = $value;
                        }
                    }
                }
            }

            return $merged;
        }

        // Merging data
        $mergedData = mergeStudentData($feeList);



        foreach ($yuviOutput as $label => $fee_obj) {
            $mergedData['value']->{$label} = $fee_obj;
        }

        // Sum discounts stored in DB (from receipts)
        $display_discount_amount = 0;
        foreach ($array_payment_id as $payment_entry) {
            $payment_parts = explode("/", $payment_entry);
            if (count($payment_parts) < 2) {
                continue;
            }

            $invoice_id = (int)$payment_parts[0];
            $sub_invoice_id = (string)$payment_parts[1];

            if ($invoice_id <= 0 || $sub_invoice_id === '') {
                continue;
            }

            $receipt_row = $this->db
                ->select('amount_detail')
                ->from('student_fees_deposite')
                ->where('id', $invoice_id)
                ->get()
                ->row();

            if (empty($receipt_row) || empty($receipt_row->amount_detail)) {
                continue;
            }

            $decoded_amount_detail = json_decode($receipt_row->amount_detail, true);
            if (!is_array($decoded_amount_detail) || !isset($decoded_amount_detail[$sub_invoice_id])) {
                continue;
            }

            $display_discount_amount += (float)($decoded_amount_detail[$sub_invoice_id]['display_discount'] ?? $decoded_amount_detail[$sub_invoice_id]['amount_discount'] ?? 0);
        }

        // Also compute the total discount present in feeList (original discounts)
        $feeList_discount_total = 0;
        foreach ($feeList as $fee_item) {
            if (!isset($fee_item['value']) || !is_object($fee_item['value'])) {
                continue;
            }
            $feeList_discount_total += (float)($fee_item['value']->display_discount ?? $fee_item['value']->amount_discount ?? 0);
        }

        if ($feeList_discount_total > 0) {
            $display_discount_amount = $feeList_discount_total;
        }

        $miscellaneousfees    = $this->studentfeemaster_model->getStudentPrintMiscellaneousFees($mergedData['student_session_id']);

        $pending_detail_yuvi = $this->studentfeemaster_model->getFeePendingDetails($fee_receipt_no_id);
        $data['pending_detail_yuvi_test'] = $pending_detail_yuvi;

        $data['sibling_info'] = $sibling_info;
        $data['miscellaneousfees'] = $miscellaneousfees;
        $data['mergedData'] = $mergedData;
        $data['display_discount_amount'] = $display_discount_amount;
        $data['fee_receipt_no_id'] = $fee_receipt_no_id;
        $this->load->view('print/view_bill_frn_printFeesByGroupArray', $data);
    }

}