@extends('layouts/acc_layout')
@section('title', '|')
@section('content')
@include('successMsg')




@php
 function printOpeningBalance($data)
    {


        $startDate = $data['startDate'];
        $endDate = $data['endDate'];

        $currectFiscalYearId = DB::table('gnr_fiscal_year')->where('fyStartDate','<=',$startDate)->where('fyEndDate','>=',$startDate)->value('id');

        //previous fiscal year id
        $currentFiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$currectFiscalYearId)->value('fyStartDate');
        $dateToCompare = date('Y-m-d', strtotime('-1 day', strtotime($currentFiscalYearStartDate)));
        $previousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompare)->value('id');



        //previous previous fiscal year id
        $previousfiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$previousfiscalYearId)->value('fyStartDate');
        $dateToCompareTwo = date('Y-m-d', strtotime('-1 day', strtotime($previousfiscalYearStartDate)));
        $previousPreviousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompareTwo)->value('id');

        //Cash Type Ledgers
        $cashTypeLedgers = DB::table('acc_account_ledger')->where('accountTypeId',4)->pluck('id')->toArray();

        //Bank Type Ledgers
        $bankTypeLedgers = DB::table('acc_account_ledger')->where('accountTypeId',5)->pluck('id')->toArray();




        // IF Search By Fiscal Year
        if ($data['searchMethodSelected']==1) {

            if ($previousfiscalYearId!=null) {

                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');


                if ($previousPreviousfiscalYearId!=null) {
                    $cashInHandForPreviousFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousPreviousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
                }
                else{
                    $cashInHandForPreviousFiscalYear = 0;
                }

            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
                $cashInHandForPreviousFiscalYear = 0;
            }


            if ($previousfiscalYearId!=null) {

                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');

                if ($previousPreviousfiscalYearId!=null) {
                     $cashInBankForPreviousFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousPreviousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
                }
                else{
                    $cashInBankForPreviousFiscalYear = 0;
                }

            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
                $cashInBankForPreviousFiscalYear = 0;
            }

            if ($data['roundUpSelected']==1) {
               echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td id='obPreviousFiscalYear' amount='".($cashInHandForPreviousFiscalYear+$cashInBankForPreviousFiscalYear)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForPreviousFiscalYear+$cashInBankForPreviousFiscalYear,2)."</td>
                <td id='obCurrentFiscalYear' amount='".($cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForPreviousFiscalYear,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForPreviousFiscalYear,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear,2)."</td>
            </tr>"
            ;
            }
            else{

                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td id='obPreviousFiscalYear' amount='".($cashInHandForPreviousFiscalYear+$cashInBankForPreviousFiscalYear)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForPreviousFiscalYear+$cashInBankForPreviousFiscalYear,2,'.','')."</td>
                <td id='obCurrentFiscalYear' amount='".($cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForPreviousFiscalYear,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForPreviousFiscalYear,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear,2,'.','')."</td>
            </tr>"
            ;

            }


        }


        // IF Search By Current Year
        elseif ($data['searchMethodSelected']==2) {

             if ($previousfiscalYearId!=null) {
                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
            }

            if ($previousfiscalYearId!=null) {
                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
            }

            $obThisMonth = $cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'];
            $obThisYear = $cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear;


            if ($data['roundUpSelected']==1) {
                 echo
            "<tr>
                <td style='text-align: left;font-weight: bold;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td  id='obThisMonth' amount='".$obThisMonth."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisMonth,2)."</td>
                <td id='obThisYear' amount='".$obThisYear."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisYear,2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'],2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear,2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'],2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear,2)."</td>
                <td></td>
            </tr>"
            ;
            }
            else{
                 echo
            "<tr>
                <td style='text-align: left;font-weight: bold;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td  id='obThisMonth' amount='".$obThisMonth."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisMonth,2,'.','')."</td>
                <td id='obThisYear' amount='".$obThisYear."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisYear,2,'.','')."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear,2,'.','')."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear,2,'.','')."</td>
                <td></td>
            </tr>"
            ;
            }


        }


        // IF Search By Date Range
        elseif ($data['searchMethodSelected']==3) {


             if ($previousfiscalYearId!=null) {
                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
            }

            if ($previousfiscalYearId!=null) {
                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
            }

            $obThisPeriod = $cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'];

            if ($data['roundUpSelected']==1) {
                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td id='obThisPeriod' amount='".$obThisPeriod."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisPeriod,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit'],2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'],2)."</td>
            </tr>"
            ;
            }
            else{
                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."OPENING BALANCE</td>
                <td></td>
                <td id='obThisPeriod' amount='".$obThisPeriod."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisPeriod,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit'],2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'],2,'.','')."</td>
            </tr>"
            ;
            }


        }
    }






    function printClosingBalance($data)
    {
        $startDate = $data['startDate'];
        $endDate = $data['endDate'];

        $currectFiscalYearId = DB::table('gnr_fiscal_year')->where('fyStartDate','<=',$startDate)->where('fyEndDate','>=',$startDate)->value('id');

        //previous fiscal year id
        $currentFiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$currectFiscalYearId)->value('fyStartDate');
        $dateToCompare = date('Y-m-d', strtotime('-1 day', strtotime($currentFiscalYearStartDate)));
        $previousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompare)->value('id');



        //previous previous fiscal year id
        $previousfiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$previousfiscalYearId)->value('fyStartDate');
        $dateToCompareTwo = date('Y-m-d', strtotime('-1 day', strtotime($previousfiscalYearStartDate)));
        $previousPreviousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompareTwo)->value('id');

        //Cash Type Ledgers
        $cashTypeLedgers = DB::table('acc_account_ledger')->where('accountTypeId',4)->pluck('id')->toArray();

        //Bank Type Ledgers
        $bankTypeLedgers = DB::table('acc_account_ledger')->where('accountTypeId',5)->pluck('id')->toArray();




        // IF Search By Fiscal Year
        if ($data['searchMethodSelected']==1) {

            if ($previousfiscalYearId!=null) {

                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');


                if ($previousPreviousfiscalYearId!=null) {
                    $cashInHandForPreviousFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousPreviousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
                }
                else{
                    $cashInHandForPreviousFiscalYear = 0;
                }

            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
                $cashInHandForPreviousFiscalYear = 0;
            }


            if ($previousfiscalYearId!=null) {

                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');

                if ($previousPreviousfiscalYearId!=null) {
                     $cashInBankForPreviousFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousPreviousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
                }
                else{
                    $cashInBankForPreviousFiscalYear = 0;
                }

            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
                $cashInBankForPreviousFiscalYear = 0;
            }

            //Transaction
            $previousFiscalYearCashDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['previousfiscalYearVouchers'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');
          $previousFiscalYearCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['previousfiscalYearVouchers'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');
          $previousFiscalYearCash = $previousFiscalYearCashDebit - $previousFiscalYearCashCredit;

           $previousFiscalYearBankDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['previousfiscalYearVouchers'])->whereIn('debitAcc',$bankTypeLedgers)->sum('amount');
          $previousFiscalYearBankCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['previousfiscalYearVouchers'])->whereIn('creditAcc',$bankTypeLedgers)->sum('amount');
          $previousFiscalYearBank = $previousFiscalYearBankDebit - $previousFiscalYearBankCredit;


          $currentFiscalYearCahDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');

          $currentFiscalYearCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');

          $currentFiscalYearCash = $currentFiscalYearCahDebit - $currentFiscalYearCashCredit;

           $currentFiscalYearBankDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('debitAcc',$bankTypeLedgers)->sum('amount');

          $currentFiscalYearBankCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('creditAcc',$bankTypeLedgers)->sum('amount');

          $currentFiscalYearBank = $currentFiscalYearBankDebit - $currentFiscalYearBankCredit;
          //End Transaction


          if ($data['roundUpSelected']==1) {
              echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td id='cbPreviousFiscalYear' amount='".($cashInHandForPreviousFiscalYear+$previousFiscalYearCash+$cashInBankForPreviousFiscalYear+$previousFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForPreviousFiscalYear+$previousFiscalYearCash+$cashInBankForPreviousFiscalYear+$previousFiscalYearBank,2)."</td>

                <td id='cbCurrentFiscalYear' amount='".($cashInHandForCurrentFiscalYear+$currentFiscalYearCash+$cashInBankForCurrentFiscalYear+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash+$cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForPreviousFiscalYear+$previousFiscalYearCash,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForPreviousFiscalYear+$previousFiscalYearBank,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2)."</td>
            </tr>"
            ;
          }
          else{
            echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td id='cbPreviousFiscalYear' amount='".($cashInHandForPreviousFiscalYear+$previousFiscalYearCash+$cashInBankForPreviousFiscalYear+$previousFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForPreviousFiscalYear+$previousFiscalYearCash+$cashInBankForPreviousFiscalYear+$previousFiscalYearBank,2,'.','')."</td>

                <td id='cbCurrentFiscalYear' amount='".($cashInHandForCurrentFiscalYear+$currentFiscalYearCash+$cashInBankForCurrentFiscalYear+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash+$cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForPreviousFiscalYear+$previousFiscalYearCash,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForPreviousFiscalYear+$previousFiscalYearBank,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2,'.','')."</td>
            </tr>"
            ;
          }



            //var_dump();
        }


        // IF Search By Current Year
        elseif ($data['searchMethodSelected']==2) {

             if ($previousfiscalYearId!=null) {
                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
            }

            if ($previousfiscalYearId!=null) {
                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
            }

            $obThisMonth = $cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit'];
            $obThisYear = $cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear;




             //Transaction
            $thisMonthCashDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisMonthVoucherIds'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');
          $thisMonthCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisMonthVoucherIds'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');
          $thisMonthCash = $thisMonthCashDebit - $thisMonthCashCredit;

           $thisMonthBankDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisMonthVoucherIds'])->whereIn('debitAcc',$bankTypeLedgers)->sum('amount');
          $thisMonthBankCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisMonthVoucherIds'])->whereIn('creditAcc',$bankTypeLedgers)->sum('amount');
          $thisMonthBank = $thisMonthBankDebit - $thisMonthBankCredit;


          $currentFiscalYearCahDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');

          $currentFiscalYearCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');

          $currentFiscalYearCash = $currentFiscalYearCahDebit - $currentFiscalYearCashCredit;

           $currentFiscalYearBankDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('debitAcc',$bankTypeLedgers)->sum('amount');

          $currentFiscalYearBankCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('creditAcc',$bankTypeLedgers)->sum('amount');

          $currentFiscalYearBank = $currentFiscalYearBankDebit - $currentFiscalYearBankCredit;
          //End Transaction



          if ($data['roundUpSelected']==1) {
              echo
            "<tr>
                <td style='text-align: left;font-weight: bold;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td  id='cbThisMonth' amount='".($obThisMonth+$thisMonthCash+$thisMonthBank)."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisMonth+$thisMonthCash+$thisMonthBank,2)."</td>
                <td id='cbThisYear' amount='".($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank,2)."</td>
                <td id='cbCumulative' amount='".($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$thisMonthCash,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2)."</td>

            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$thisMonthBank,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2)."</td>

            </tr>"
            ;
          }
          else{
            echo
            "<tr>
                <td style='text-align: left;font-weight: bold;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td  id='cbThisMonth' amount='".($obThisMonth+$thisMonthCash+$thisMonthBank)."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisMonth+$thisMonthCash+$thisMonthBank,2,'.','')."</td>
                <td id='cbThisYear' amount='".($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank,2)."</td>
                <td id='cbCumulative' amount='".($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisYear+$currentFiscalYearCash+$currentFiscalYearBank,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$thisMonthCash,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$currentFiscalYearCash,2,'.','')."</td>

            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisMonthTransactionOfBankTypeDebit']-$data['thisMonthTransactionOfBankTypeCredit']+$thisMonthBank,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$currentFiscalYearBank,2,'.','')."</td>

            </tr>"
            ;
          }


        }


        // IF Search By Date Range
        elseif ($data['searchMethodSelected']==3) {


             if ($previousfiscalYearId!=null) {
                $cashInHandForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$cashTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInHandForCurrentFiscalYear = 0;
            }

            if ($previousfiscalYearId!=null) {
                $cashInBankForCurrentFiscalYear = DB::table('acc_opening_balance')->whereIn('ledgerId',$bankTypeLedgers)->where('fiscalYearId',$previousfiscalYearId)->where('projectId',$data['projectSelected'])->whereIn('projectTypeId',$data['projectTypeId'])->whereIn('branchId',$data['branchId'])->sum('balanceAmount');
            }
            else{
                $cashInBankForCurrentFiscalYear = 0;
            }

            $obThisPeriod = $cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'];




             //Transaction
            $thisPeriodCashDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisPeriodVoucherIds'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');
          $thisPeriodCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisPeriodVoucherIds'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');
          $thisPeriodCash = $thisPeriodCashDebit - $thisPeriodCashCredit;

           $thisPeriodBankDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisPeriodVoucherIds'])->whereIn('debitAcc',$bankTypeLedgers)->sum('amount');
          $thisPeriodBankCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['thisPeriodVoucherIds'])->whereIn('creditAcc',$bankTypeLedgers)->sum('amount');
          $thisPeriodBank = $thisPeriodBankDebit - $thisPeriodBankCredit;

          //End Transaction


          if ($data['roundUpSelected']==1) {
               echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td id='cbThisPeriod' amount='".($obThisPeriod+$thisPeriodCash+$thisPeriodBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisPeriod+$thisPeriodCash+$thisPeriodBank,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$thisPeriodCash,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit']+$thisPeriodBank,2)."</td>
            </tr>"
            ;
          }
          else{
             echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4))."CLOSING BALANCE</td>
                <td></td>
                <td id='cbThisPeriod' amount='".($obThisPeriod+$thisPeriodCash+$thisPeriodBank)."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obThisPeriod+$thisPeriodCash+$thisPeriodBank,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$thisPeriodCash,2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>".str_repeat('&nbsp;',  (4*2))."CASH IN BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit']+$thisPeriodBank,2,'.','')."</td>
            </tr>"
            ;
          }




        }
    }


@endphp


<div class="row">
<div class="col-md-12">
<div class="" style="">
    <div class="">
      <div class="panel panel-default" style="background-color:#708090;">
        <div class="panel-heading" style="padding-bottom:0px">
          <div class="panel-options">           <div class="panel-options">
                <a href="" class="btn btn-info pull-right addViewBtn" id="print"><i class="fa fa-print" aria-hidden="true"></i> Print</a>

            </div>
              {{-- <a href="{{url('addLedger/'.encrypt($grandParent))}}" class="btn btn-info pull-right addViewBtn" style=""><i class="glyphicon glyphicon-plus-sign addIcon"></i>Add Ledger</a> --}}
          </div>
          <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Receipt Payment Statement</h3>
        </div>
        {{-- <h5>kxghixd</h5> --}}

        <div class="panel-body panelBodyView">

        @php
            //echo var_dump($projectMatchedId);
            //echo var_dump($vouchers);
        // echo $projectSelected."<br>";
        // echo $projectTypeSelected."<br>";
        // echo $branchSelected."<br>";
         //echo $fiscalYearId."<br>";
        @endphp


            <!-- Filtering Start-->
           <div class="row" id="filtering-group">

                                <div class="form-horizontal form-groups" style="padding-right: 0px;">

                                    {!! Form::open(['url' => 'receiptPaymentStatement','method' => 'get']) !!}
                                    @php
                                        $userBranchId = Auth::user()->branchId;
                                    @endphp


                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Project:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchProject" class="form-control input-sm" id="searchProject">

                                                    @foreach($projects as $project)
                                                    <option value="{{$project->id}}" @if($project->id==$projectSelected){{"selected=selected"}}@endif>{{str_pad($project->projectCode,3,"0",STR_PAD_LEFT).'-'.$project->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Pro. Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchProjectType" class="form-control input-sm" id="searchProjectType">
                                                    <option value="">All</option>
                                                    @foreach($projectTypes as $projectType)
                                                    <option value="{{$projectType->id}}" @if($projectType->id==$projectTypeSelected){{"selected=selected"}}@endif>{{str_pad($projectType->projectTypeCode,3,"0",STR_PAD_LEFT).'-'.$projectType->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchBranch" class="form-control input-sm" id="searchBranch">
                                                    <option value="">All</option>
                                                    <option value="0" @if($branchSelected===0){{"selected=selected"}}@endif>All Branches</option>
                                                    @foreach($branches as $branch)
                                                    <option value="{{$branch->id}}" @if($branch->id==$branchSelected){{"selected=selected"}}@endif>{{str_pad($branch->branchCode,3,"0",STR_PAD_LEFT).'-'.$branch->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Voucher Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('voucherType',[''=>'Without JV',1=>'With JV',2=>'Only JV'],$voucherTypeSelected,['class'=>'form-control']) !!}

                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Round Up:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('roundUp',[1=>'Yes',0=>'No'],$roundUpSelected,['class'=>'form-control']) !!}

                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('depthLevel', 'Depth Level:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('depthLevel',[''=>'All',1=>'Level-1',2=>'Level-2',3=>'Level-3',4=>'Level-4'],$depthLevelSelected,['class'=>'form-control']) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('withZero', '\'0\' Balance:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('withZero',[''=>'Yes',1=>'No'],$withZeroSelected,['class'=>'form-control']) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Search By:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('searchMethod',['1'=>'Fiscal Year','2'=>'Current Year','3'=>'Date Range'],$searchMethodSelected,['id'=>'searchMethod','class'=>'form-control input-sm']) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-1" style="display: none;" id="fiscalYearDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            {!! Form::label('', ' ', ['class' => 'control-label col-sm-12']) !!}
                                            <div class="col-sm-12" style="padding-top: 18px;">

                                                {!! Form::select('fiscalYear', $fiscalYears, $fiscalYearSelected, array('class'=>'form-control input-sm', 'id' => 'fiscalYear')) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2" id="dateRangeDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', ' ', ['class' => 'control-label']) !!}
                                            </div>

                                            <div class="col-sm-12" style="padding-top: 7px;">
                                                <div class="form-group">
                                                    <div class="col-sm-6">
                                                        {!! Form::text('dateFrom',$dateFromSelected,['id'=>'dateFrom','placeholder'=>'From','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateFrome" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                    <div class="col-sm-6" id="dateToDiv">
                                                        {!! Form::text('dateTo',$dateToSelected,['id'=>'dateTo','placeholder'=>'To','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateToe" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                </div>

                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black">

                                            <div class="col-sm-12" style="padding-top: 25px;">

                                                {!! Form::submit('Search',['id'=>'search','class'=>'btn btn-primary btn-xs','style'=>'font-size:15px;']) !!}
                                            </div>
                                        </div>
                                        {!! Form::close() !!}
                                    </div>

                                </div>

                        </div> {{-- End Filtering Group --}}
            <!-- filtering end-->



            @if(!$firstRequest)

            @php
               if($branchSelected===0){
                    $selectedBranchName = "All Branches";
                   }
               else{
                $selectedBranchName = DB::table('gnr_branch')->where('id',$branchSelected)->value('name');
               }
                $selectedProjectName = DB::table('gnr_project')->where('id',$projectSelected)->value('name');
                $selectedProjectTypeName = DB::table('gnr_project_type')->where('id',$projectTypeSelected)->value('name');


            @endphp

            <div id="printingContent">

            <div style="display: none;text-align: center;" id="hiddenTitle">
                           <h3 style="text-align: center;padding: 0px;margin: 0px;">Ambala Foundation</h3>
                           <p style="text-align: center;padding: 0px;margin: 0px;font-size: 10px;">House # 62, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka-1207</p>
                           <h4 style="text-align: center;padding: 0px;margin: 0px;">Receipt Payment Statement</h4>
                            {{-- <h5 style="text-align: center;">{{$selectedBranchName}}</h5>  --}}
                           <h5 style="text-align: center;font-size: 14;padding: 0px;margin: 0px;">{{date('F d, Y',strtotime($endDate))}}</h5>
                        </div>
                        <div id="hiddenInfo" style="display: none;">

                       <p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Name : @php
                            if($selectedBranchName==null){
                                echo "All";
                            }
                            else{
                                echo $selectedBranchName;
                            }
                        @endphp
                         <span style='float: right;'>
                             Reporting Peroid : {{date('d-m-Y',strtotime($startDate))." to ".date('d-m-Y',strtotime($endDate))}}
                         </span>
                        </p>


                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Name : @php
                                        if($selectedProjectName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectName;
                                        }
                                    @endphp
                                    <span style='float: right;'>
                                    Print Date : {{date('F d,Y')}}
                                </span>

                                    </p>



                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Type :  @php
                                        if($selectedProjectTypeName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectTypeName;
                                        }
                                    @endphp


                                    </p>

                        </div>


<br>

          <table id="CRPStable" class="table table-striped table-bordered" style="color: black;font-size:11px;border-collapse: collapse;margin-bottom:50px;" border= "1px solid black;" width="100%" cellpadding="0" cellspacing="0">
            <thead>
              <tr style="vertical-align: top;">
                <th>Particulars</th>
                @if($searchMethodSelected==1)
                @php
                    $fiscalYearName = DB::table('gnr_fiscal_year')->where('id',$fiscalYearSelected)->value('name');

                    $curentFiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$fiscalYearSelected)->value('fyStartDate');
                    $previousfiscalYearDate = strtotime($curentFiscalYearStartDate.' -1 year');
                    $Fdate = date('Y-m-d',$previousfiscalYearDate);
                    $previousfiscalYear = DB::table('gnr_fiscal_year')->where('fyStartDate','=',$Fdate)->value('name');

                @endphp
                <th>Notes</th>
                <th>FI Year <br> ({{$previousfiscalYear}})</th>
                <th>FI Year <br> ({{$fiscalYearName}})</th>

                @elseif($searchMethodSelected==2)
                <th>Notes</th>
                <th>This Month</th>
                <th>This Year</th>
                <th>Cumulative</th>

                @elseif($searchMethodSelected==3)
                <th>Notes</th>
                <th>Time Period <br> {{date('d-m-Y',strtotime($startDate))." to ".date('d-m-Y',strtotime($endDate))}}</th>
                @endif
              </tr>


            </thead>
            <tbody>
            @php
            $data = array(
                'searchMethodSelected' => $searchMethodSelected,
                'fiscalYearSelected' => $fiscalYearSelected,
                'startDate' => $startDate,
                'endDate' => $endDate,
                'thisMonthTransactionOfCashTypeDebit' => $thisMonthTransactionOfCashTypeDebit,
                'thisMonthTransactionOfCashTypeCredit' => $thisMonthTransactionOfCashTypeCredit,
                'thisMonthTransactionOfBankTypeDebit' => $thisMonthTransactionOfBankTypeDebit,
                'thisMonthTransactionOfBankTypeCredit' => $thisMonthTransactionOfBankTypeCredit,

                'thisPeriodTransactionOfCashTypeDebit' => $thisPeriodTransactionOfCashTypeDebit,
                'thisPeriodTransactionOfCashTypeCredit' => $thisPeriodTransactionOfCashTypeCredit,
                'thisPeriodTransactionOfBankTypeDebit' => $thisPeriodTransactionOfBankTypeDebit,
                'thisPeriodTransactionOfBankTypeCredit' => $thisPeriodTransactionOfBankTypeCredit,
                'previousfiscalYearVouchers' => $previousfiscalYearVouchers,
                'vouchers' => $vouchers,
                'thisMonthVoucherIds' => $thisMonthVoucherIds,
                'thisPeriodVoucherIds' => $thisPeriodVoucherIds,
                'roundUpSelected' => $roundUpSelected,
                'projectSelected' => $projectSelected,
                'projectTypeId' => $projectTypeId,
                'branchId' => $branchId

                );
                printOpeningBalance($data);
            @endphp



              {{-- Receipt --}}

               @if($searchMethodSelected==1)
              <tr id="receiptBegin"><td colspan="4" style="text-align: left;font-weight: bold;font-size: 14px;">Receipt</td></tr>
              @elseif($searchMethodSelected==2)
              <tr id="receiptBegin"><td colspan="5" style="text-align: left;font-weight: bold;font-size: 14px;">Receipt</td></tr>
              @elseif($searchMethodSelected==3)
              <tr id="receiptBegin"><td colspan="3" style="text-align: left;font-weight: bold;font-size: 14px;">Receipt</td></tr>
              @endif

                            @php
               $info = array(
                'loopTrack' => $loopTrack,
                'vouchers' => $vouchers,
                'previousfiscalYearVouchers' => $previousfiscalYearVouchers,
                'openingVouchers' => $openingVouchers,
                'roundUpSelected' => $roundUpSelected,
                'fiscalYearId' => $fiscalYearId,
                'searchMethodSelected' => $searchMethodSelected,
                'thisMonthVoucherIds' => $thisMonthVoucherIds,
                'type' => $type,
                'startDate' => $startDate,
                'endDate' => $endDate
                );
              @endphp



              @foreach($ledgers as $ledger)

              @if(in_array($ledger->id,$debitLedgerMatchedId))

                  <br />
<b>Warning</b>:  Undefined variable $ledger in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1285</b><br />
<br />
<b>Warning</b>:  Undefined variable $info in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1285</b><br />

    <tr class="item{{$child->id}}" level="{{$info['loopTrack']}}" @if($info['loopTrack']<=3){{"style=font-weight:bold;"}}@endif>
        <td style="text-align: left;">

            <br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>14</b><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <br />
<b>Warning</b>:  Attempt to read property "isGroupHead" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>43</b><br />
<span class="fa fa-angle-double-right"></span>            @if($child->isGroupHead==1)
            {{strtoupper($child->name).' ['.$child->code.']'}}
            @else
            {{$child->name.' ['.$child->code.']'}}
            @endif

        </td>

         @php

         $childId = $child->id;

         $openingDebit = 0;
         $openingCredit = 0;

         $currentDebit = 0;
         $currentCredit = 0;

         $thisMonthDebit = 0;
         $thisMonthCredit = 0;

         $previousFiscalYearDebit = 0;
         $previousFiscalYearCredit = 0;

         $debitSum = 0;
         $creditSum = 0;

         $openingDebitForCumulative = 0;
         $currentDebitForCumulative = 0;
         $cumulativeDebit = 0;
         $cumulativeCredit = 0;

         $openingCreditForCumulative = 0;
         $currentCreditForCumulative = 0;

        $amount = 0;

            if ($child->isGroupHead==0) {

                /*Get Data for Fiscal Year*/
                if ($info['searchMethodSelected']==1) {

                }
                /*End Get Data for Fiscal Year*/


                //Curent Debit Credit
                $currentDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['vouchers'])
                                        ->sum('amount');

                $currentCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['vouchers'])
                                        ->sum('amount');


                //Previous Year Debit Credit
                $previousFiscalYearDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['previousfiscalYearVouchers'])
                                        ->sum('amount');

                $previousFiscalYearCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['previousfiscalYearVouchers'])
                                        ->sum('amount');

                //End Previous Year Debit Credit


                //This Month Debit Credit
                $thisMonthDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['thisMonthVoucherIds'])
                                        ->sum('amount');

                $thisMonthCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['thisMonthVoucherIds'])
                                        ->sum('amount');

                //End This Month Debit Credit

                //cumulative
                $startDate = $info['startDate'];
                $endDate = $info['endDate'];

                $currectFiscalYearId = DB::table('gnr_fiscal_year')->where('fyStartDate','<=',$startDate)->where('fyEndDate','>=',$startDate)->value('id');

                //previous fiscal year id
                $currentFiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$currectFiscalYearId)->value('fyStartDate');
                $dateToCompare = date('Y-m-d', strtotime('-1 day', strtotime($currentFiscalYearStartDate)));
                $previousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompare)->value('id');
                if ($previousfiscalYearId!=null) {
                    $openingDebitForCumulative = DB::table('acc_opening_balance')->where('ledgerId',$childId)->where('fiscalYearId',$previousfiscalYearId)->sum('debitAmount');
                    $openingCreditForCumulative = DB::table('acc_opening_balance')->where('ledgerId',$childId)->where('fiscalYearId',$previousfiscalYearId)->sum('creditAmount');
                }
                $currentDebitForCumulative = DB::table('acc_voucher_details')->where('debitAcc',$childId)->sum('amount');
                $currentCreditForCumulative = DB::table('acc_voucher_details')->where('creditAcc',$childId)->sum('amount');

                $cumulativeDebit = $openingDebitForCumulative + $currentDebitForCumulative;
                $cumulativeCredit = $openingCreditForCumulative + $currentCreditForCumulative;
                //End cumulative



            }



        @endphp

        {{-- If RoundUp Selected --}}



        @if($info['roundUpSelected']==1)

        {{-- Fiscal Year --}}
        @if($info['searchMethodSelected']==1)

        <td></td>
        <td class="previousFiscalYear" amount="@if($info['type']=='receipt'){{$previousFiscalYearDebit}}@else {{$previousFiscalYearCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($previousFiscalYearDebit,2)}}@else {{number_format($previousFiscalYearCredit,2)}} @endif</td>
        <td class="currentFiscalYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>

        {{-- Current Year --}}
        @elseif($info['searchMethodSelected']==2)
        <td></td>
        <td class="thisMonth" amount="@if($info['type']=='receipt'){{$thisMonthDebit}}@else {{$thisMonthCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($thisMonthDebit,2)}}@else {{number_format($thisMonthCredit,2)}} @endif</td>
        <td class="thisYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>
        <td class="cumulative" amount="@if($info['type']=='receipt'){{$cumulativeDebit}}@else {{$cumulativeCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($cumulativeDebit,2)}}@else {{number_format($cumulativeCredit,2)}} @endif</td>

        {{-- Date Range --}}
        @elseif($info['searchMethodSelected']==3)
        <td></td>
        <td class="currentPeriod" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>
        @endif





        @else
        {{-- If RoundUp Not Selected --}}

       {{-- Fiscal Year --}}
        @if($info['searchMethodSelected']==1)
        <td></td>
        <td class="previousFiscalYear" amount="@if($info['type']=='receipt'){{$previousFiscalYearDebit}}@else {{$previousFiscalYearCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($previousFiscalYearDebit,2,'.','')}}@else {{number_format($previousFiscalYearCredit,2,'.','')}} @endif</td>
        <td class="currentFiscalYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>

        {{-- Current Year --}}
        @elseif($info['searchMethodSelected']==2)
        <td></td>
        <td class="thisMonth" amount="@if($info['type']=='receipt'){{$thisMonthDebit}}@else {{$thisMonthCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($thisMonthDebit,2,'.','')}}@else {{number_format($thisMonthCredit,2,'.','')}} @endif</td>
        <td class="thisYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>
        <td class="cumulative" amount="@if($info['type']=='receipt'){{$cumulativeDebit}}@else {{$cumulativeCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($cumulativeDebit,2,'.','')}}@else {{number_format($cumulativeCredit,2,'.','')}} @endif</td>

        {{-- Date Range --}}
        @elseif($info['searchMethodSelected']==3)
        <td></td>
        <td class="currentPeriod" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>
        @endif

        @endif

    </tr>

    <br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>223</b><br />

                <br />
<b>Warning</b>:  Undefined variable $ledger in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1289</b><br />
<br />
<b>Warning</b>:  Attempt to read property "isGroupHead" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1289</b><br />
                @endif     {{-- End foreach loop for Child1 --}}
              @endforeach           {{-- End foreach loop for ledger --}}

              <tr id="totalReceipt" style="font-weight: bold;border-bottom-width: 0px;">
              @if($searchMethodSelected==1)
                  <td colspan="2" style="text-align: left;">Total Receipt</td>
                  <td class="tRpreviousFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tRcurrentFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @elseif($searchMethodSelected==2)
                  <td colspan="2" style="text-align: left;">Total Receipt</td>
                  <td class="tRthisMonth" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tRThisYear" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tRCumulative" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
             @elseif($searchMethodSelected==3)
                  <td colspan="2" style="text-align: left;">Total Receipt</td>
                  <td class="tRThisPeriod" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @endif
              </tr>

              <tr id="grandTotalReceipt" style="font-weight: bold; border-top-width: 0px;">
              @if($searchMethodSelected==1)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtRpreviousFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtRcurrentFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @elseif($searchMethodSelected==2)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtRthisMonth" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtRThisYear" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtRCumulative" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
             @elseif($searchMethodSelected==3)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtRThisPeriod" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @endif
              </tr>
              {{-- End Receipt --}}



               {{-- Payment --}}

             @if($searchMethodSelected==1)
              <tr id="startPayment"><td colspan="4" style="text-align: left;font-weight: bold;font-size: 14px;">Payment</td></tr>
              @elseif($searchMethodSelected==2)
              <tr id="startPayment"><td colspan="5" style="text-align: left;font-weight: bold;font-size: 14px;">Payment</td></tr>
              @elseif($searchMethodSelected==3)
              <tr id="startPayment"><td colspan="3" style="text-align: left;font-weight: bold;font-size: 14px;">Payment</td></tr>
              @endif

                            @foreach($ledgers as $ledger)

              @if(in_array($ledger->id,$creditLedgerMatchedId))

                  <br />
<b>Warning</b>:  Undefined variable $ledger in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1399</b><br />

    <tr class="item{{$child->id}}" level="{{$info['loopTrack']}}" @if($info['loopTrack']<=3){{"style=font-weight:bold;"}}@endif>
        <td style="text-align: left;">

            &nbsp;&nbsp;&nbsp;&nbsp;
            <br />
<b>Warning</b>:  Attempt to read property "isGroupHead" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>43</b><br />
<span class="fa fa-angle-double-right"></span>            @if($child->isGroupHead==1)
            {{strtoupper($child->name).' ['.$child->code.']'}}
            @else
            {{$child->name.' ['.$child->code.']'}}
            @endif

        </td>

         @php

         $childId = $child->id;

         $openingDebit = 0;
         $openingCredit = 0;

         $currentDebit = 0;
         $currentCredit = 0;

         $thisMonthDebit = 0;
         $thisMonthCredit = 0;

         $previousFiscalYearDebit = 0;
         $previousFiscalYearCredit = 0;

         $debitSum = 0;
         $creditSum = 0;

         $openingDebitForCumulative = 0;
         $currentDebitForCumulative = 0;
         $cumulativeDebit = 0;
         $cumulativeCredit = 0;

         $openingCreditForCumulative = 0;
         $currentCreditForCumulative = 0;

        $amount = 0;

            if ($child->isGroupHead==0) {

                /*Get Data for Fiscal Year*/
                if ($info['searchMethodSelected']==1) {

                }
                /*End Get Data for Fiscal Year*/


                //Curent Debit Credit
                $currentDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['vouchers'])
                                        ->sum('amount');

                $currentCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['vouchers'])
                                        ->sum('amount');


                //Previous Year Debit Credit
                $previousFiscalYearDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['previousfiscalYearVouchers'])
                                        ->sum('amount');

                $previousFiscalYearCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['previousfiscalYearVouchers'])
                                        ->sum('amount');

                //End Previous Year Debit Credit


                //This Month Debit Credit
                $thisMonthDebit = DB::table('acc_voucher_details')
                                        ->where('debitAcc', $childId)
                                        ->whereIn('voucherId',$info['thisMonthVoucherIds'])
                                        ->sum('amount');

                $thisMonthCredit = DB::table('acc_voucher_details')
                                        ->where('creditAcc', $childId)
                                        ->whereIn('voucherId',$info['thisMonthVoucherIds'])
                                        ->sum('amount');

                //End This Month Debit Credit

                //cumulative
                $startDate = $info['startDate'];
                $endDate = $info['endDate'];

                $currectFiscalYearId = DB::table('gnr_fiscal_year')->where('fyStartDate','<=',$startDate)->where('fyEndDate','>=',$startDate)->value('id');

                //previous fiscal year id
                $currentFiscalYearStartDate = DB::table('gnr_fiscal_year')->where('id',$currectFiscalYearId)->value('fyStartDate');
                $dateToCompare = date('Y-m-d', strtotime('-1 day', strtotime($currentFiscalYearStartDate)));
                $previousfiscalYearId = DB::table('gnr_fiscal_year')->where('fyEndDate',$dateToCompare)->value('id');
                if ($previousfiscalYearId!=null) {
                    $openingDebitForCumulative = DB::table('acc_opening_balance')->where('ledgerId',$childId)->where('fiscalYearId',$previousfiscalYearId)->sum('debitAmount');
                    $openingCreditForCumulative = DB::table('acc_opening_balance')->where('ledgerId',$childId)->where('fiscalYearId',$previousfiscalYearId)->sum('creditAmount');
                }
                $currentDebitForCumulative = DB::table('acc_voucher_details')->where('debitAcc',$childId)->sum('amount');
                $currentCreditForCumulative = DB::table('acc_voucher_details')->where('creditAcc',$childId)->sum('amount');

                $cumulativeDebit = $openingDebitForCumulative + $currentDebitForCumulative;
                $cumulativeCredit = $openingCreditForCumulative + $currentCreditForCumulative;
                //End cumulative



            }



        @endphp

        {{-- If RoundUp Selected --}}



        @if($info['roundUpSelected']==1)

        {{-- Fiscal Year --}}
        @if($info['searchMethodSelected']==1)

        <td></td>
        <td class="previousFiscalYear" amount="@if($info['type']=='receipt'){{$previousFiscalYearDebit}}@else {{$previousFiscalYearCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($previousFiscalYearDebit,2)}}@else {{number_format($previousFiscalYearCredit,2)}} @endif</td>
        <td class="currentFiscalYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>

        {{-- Current Year --}}
        @elseif($info['searchMethodSelected']==2)
        <td></td>
        <td class="thisMonth" amount="@if($info['type']=='receipt'){{$thisMonthDebit}}@else {{$thisMonthCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($thisMonthDebit,2)}}@else {{number_format($thisMonthCredit,2)}} @endif</td>
        <td class="thisYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>
        <td class="cumulative" amount="@if($info['type']=='receipt'){{$cumulativeDebit}}@else {{$cumulativeCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($cumulativeDebit,2)}}@else {{number_format($cumulativeCredit,2)}} @endif</td>

        {{-- Date Range --}}
        @elseif($info['searchMethodSelected']==3)
        <td></td>
        <td class="currentPeriod" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2)}}@else {{number_format($currentCredit,2)}} @endif</td>
        @endif





        @else
        {{-- If RoundUp Not Selected --}}

       {{-- Fiscal Year --}}
        @if($info['searchMethodSelected']==1)
        <td></td>
        <td class="previousFiscalYear" amount="@if($info['type']=='receipt'){{$previousFiscalYearDebit}}@else {{$previousFiscalYearCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($previousFiscalYearDebit,2,'.','')}}@else {{number_format($previousFiscalYearCredit,2,'.','')}} @endif</td>
        <td class="currentFiscalYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>

        {{-- Current Year --}}
        @elseif($info['searchMethodSelected']==2)
        <td></td>
        <td class="thisMonth" amount="@if($info['type']=='receipt'){{$thisMonthDebit}}@else {{$thisMonthCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($thisMonthDebit,2,'.','')}}@else {{number_format($thisMonthCredit,2,'.','')}} @endif</td>
        <td class="thisYear" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>
        <td class="cumulative" amount="@if($info['type']=='receipt'){{$cumulativeDebit}}@else {{$cumulativeCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($cumulativeDebit,2,'.','')}}@else {{number_format($cumulativeCredit,2,'.','')}} @endif</td>

        {{-- Date Range --}}
        @elseif($info['searchMethodSelected']==3)
        <td></td>
        <td class="currentPeriod" amount="@if($info['type']=='receipt'){{$currentDebit}}@else {{$currentCredit}} @endif" style="text-align: right; padding: 0 5px 0 10px;">@if($info['type']=='receipt'){{number_format($currentDebit,2,'.','')}}@else {{number_format($currentCredit,2,'.','')}} @endif</td>
        @endif

        @endif

    </tr>

    <br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>223</b><br />

                <br />
<b>Warning</b>:  Undefined variable $ledger in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1403</b><br />
<br />
<b>Warning</b>:  Attempt to read property "isGroupHead" on null in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1403</b><br />
                @endif     {{-- End foreach loop for Child1 --}}
              @endforeach           {{-- End foreach loop for ledger --}}

              <tr id="totalPayment" style="font-weight: bold;">
             @if($searchMethodSelected==1)
                  <td colspan="2" style="text-align: left;">Total Payment</td>
                  <td class="tPpreviousFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tPcurrentFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @elseif($searchMethodSelected==2)
                  <td colspan="2" style="text-align: left;">Total Payment</td>
                  <td class="tPthisMonth" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tPThisYear" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="tPCumulative" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
             @elseif($searchMethodSelected==3)
                  <td colspan="2" style="text-align: left;">Total Payment</td>
                  <td class="tPThisPeriod" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @endif

              </tr>



              {{-- End Payment --}}

              @php
                 printClosingBalance($data);
              @endphp

              <tr id="grandTotalPayment" style="font-weight: bold; border-top-width: 0px;">
              @if($searchMethodSelected==1)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtPpreviousFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtPcurrentFY" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @elseif($searchMethodSelected==2)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtPthisMonth" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtPThisYear" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
                  <td class="gtPCumulative" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>
             @elseif($searchMethodSelected==3)
                  <td colspan="2" style="text-align: left;">Total</td>
                  <td class="gtPThisPeriod" amount="0" style="text-align: right;padding: 0 5px 0 10px;"></td>

             @endif
              </tr>




            </tbody>
          </table>
          </div>
          @endif
        </div>
      </div>
  </div>
  </div>
</div>
</div>


<style type="text/css">
    #CRPStable thead tr th{padding: 2px;}
</style>



<script type="text/javascript">
    $(document).ready(function() {

        function toDate(dateStr) {
    var parts = dateStr.split("-");
    return new Date(parts[2], parts[1] - 1, parts[0]);
}
         /* Date Range From */
    $("#dateFrom").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "2010:c",
            minDate: new Date('2010-07-01'),
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateFrome').hide();
                $("#dateTo").datepicker("option","minDate",new Date(toDate($(this).val())));
            }
        });
    /* Date Range From */

     /* Date Range To */
    $("#dateTo").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "2010:c",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateToe').hide();
                $("#dateFrom").datepicker("option","maxDate",new Date(toDate($(this).val())));
            }
        });

    /* End Date Range To */




    /*Validation*/
    $("#search").click(function(event) {
    if ($("#dateFrom").val()=="") {
            event.preventDefault();
            $("#dateFrome").show();
        }
    if ($("#dateTo").val()=="") {
        event.preventDefault();
        $("#dateToe").show();
    }
});
    /*End Validation*/





    });
</script>


{{-- Filtering --}}
<script type="text/javascript">
    jQuery(document).ready(function($) {

        function pad (str, max) {
              str = str.toString();
              return str.length < max ? pad("0" + str, max) : str;
            }

         /* Change Project*/
         $("#searchProject").change(function(){

            var projectId = $(this).val();

            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php:1598
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/accounting/reports/consolidatedReceiptPaymentStatement.blade.php</b> on line <b>1598</b><br />