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

<style type="text/css">
    #CRPStable{
        font-family: arial !important;
    }

    #CRPStable td{
        padding-left: 10px;
        padding-right: 10px;
    }
</style>
@php
    // dd($openingBalanceInfo);
@endphp



@php
 function printOpeningBalance($obData)
    {
        if ($obData['voucherTypeSelected']==2) {

            if ($obData['searchMethodSelected']==1){
                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>OPENING BALANCE</td>
                <td></td>
                <td id='obPreviousFiscalYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
                <td id='obCurrentFiscalYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td id='cashInHandForCurrentFiscalYear' amount='0' style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td id='cashInBankForCurrentFiscalYear' amount='0' style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
            </tr>"
            ;
            }

            else if($obData['searchMethodSelected']==2){
                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;'>OPENING BALANCE</td>
                <td></td>
                <td  id='obThisMonth' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format(0,2)."</td>
                <td id='obThisYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format(0,2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td></td>
            </tr>"
            ;
            }
            else if ($obData['searchMethodSelected']==3) {
                 echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>OPENING BALANCE</td>
                <td></td>
                <td id='obThisPeriod' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
            </tr>"
            ;
            }

        }



        //If It is not only JV

        else{


        // $startDate = $data['startDate'];
        // $endDate = $data['endDate'];
        //
        // $currectFiscalYearId = DB::table('gnr_fiscal_year')->where('fyStartDate','<=',$startDate)->where('fyEndDate','>=',$startDate)->value('id');
        // // dd($startDate);
        //
        // //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');
        // // dd($cashTypeLedgers);
        // //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();

        // $openingbalanceInfo = DB::table('acc_opening_balance')
        //                     ->where('projectId',$data['projectSelected'])
        //                     ->whereIn('projectTypeId',$data['projectTypeId'])
        //                     ->whereIn('branchId',$data['branchId'])
        //                     ->select('ledgerId', 'fiscalYearId', 'balanceAmount')
        //                     ->get();

                            // dd($openingbalanceInfo);


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

            // if ($previousfiscalYearId!=null) {
            //
            //     $cashInHandForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->whereIn('ledgerId',$cashTypeLedgers)
            //                                     ->sum('balanceAmount');
            //
            //
            //     if ($previousPreviousfiscalYearId!=null) {
            //         $cashInHandForPreviousFiscalYear = $data['openingBalanceInfo']
            //                                     ->where('fiscalYearId',$previousPreviousfiscalYearId)
            //                                     ->whereIn('ledgerId',$cashTypeLedgers)
            //                                     ->sum('balanceAmount');
            //     }
            //     else{
            //         $cashInHandForPreviousFiscalYear = 0;
            //     }
            //
            // }
            // else{
            //     $cashInHandForCurrentFiscalYear = 0;
            //     $cashInHandForPreviousFiscalYear = 0;
            // }
            //
            //
            // if ($previousfiscalYearId!=null) {
            //
            //     $cashInBankForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->whereIn('ledgerId',$bankTypeLedgers)
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->sum('balanceAmount');
            //
            //     if ($previousPreviousfiscalYearId!=null) {
            //          $cashInBankForPreviousFiscalYear = $data['openingBalanceInfo']
            //                                          ->whereIn('ledgerId',$bankTypeLedgers)
            //                                          ->where('fiscalYearId',$previousPreviousfiscalYearId)
            //                                          ->sum('balanceAmount');
            //     }
            //     else{
            //         $cashInBankForPreviousFiscalYear = 0;
            //     }
            //
            // }
            // else{
            //     $cashInBankForCurrentFiscalYear = 0;
            //     $cashInBankForPreviousFiscalYear = 0;
            // }
            //
            //
            //
            // if ($data['voucherTypeSelected']==2) {
            //     $cashInHandForPreviousFiscalYear = 0;
            //     $cashInBankForPreviousFiscalYear = 0;
            //
            //
            //     $cashInHandForCurrentFiscalYear = 0;
            //
            //     $cashInBankForCurrentFiscalYear = 0;
            //
            // }

            if ($obData['roundUpSelected']==1) {
                echo
                "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>OPENING BALANCE</td>
                <td></td>
                <td id='obPreviousFiscalYear' amount='".($obData['obPreviousYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obPreviousYear'],2)."</td>
                <td id='obCurrentFiscalYear' amount='".($obData['obThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obThisYear'],2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obPreviousYearCash'],2)."</td>
                <td id='cashInHandForCurrentFiscalYear' amount='".$obData['obThisYearCash']."' style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearCash'],2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obPreviousYearBank'],2)."</td>
                <td id='cashInBankForCurrentFiscalYear' amount='".$obData['obThisYearBank']."' style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearBank'],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;'>OPENING BALANCE</td>
                <td></td>
                <td id='obPreviousFiscalYear' amount='".($obData['obPreviousYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obPreviousYear'],2,'.','')."</td>
                <td id='obCurrentFiscalYear' amount='".($obData['obThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obThisYear'],2,'.','')."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obPreviousYearCash'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearCash'],2,'.','')."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obPreviousYearBank'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearBank'],2,'.','')."</td>
                </tr>"
                ;

            }
            // dd($cashInHandForCurrentFiscalYear);

        }

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

            // if ($previousfiscalYearId!=null) {
            //     $cashInHandForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->whereIn('ledgerId',$cashTypeLedgers)
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->sum('balanceAmount');
            // }
            // else{
            //     $cashInHandForCurrentFiscalYear = 0;
            // }
            //
            // if ($previousfiscalYearId!=null) {
            //     $cashInBankForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->whereIn('ledgerId',$bankTypeLedgers)
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->sum('balanceAmount');
            // }
            // else{
            //     $cashInBankForCurrentFiscalYear = 0;
            // }
            //
            // $obThisMonth = $cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'];
            // $obThisYear = $cashInHandForCurrentFiscalYear+$cashInBankForCurrentFiscalYear;

            if ($obData['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;'>OPENING BALANCE</td>
                <td></td>
                <td  id='obThisMonth' amount='".$obData['obThisMonth']."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obData['obThisMonth'],2)."</td>
                <td id='obThisYear' amount='".$obData['obThisYear']."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obData['obThisYear'],2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisMonthCash'],2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearCash'],2)."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisMonthBank'],2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearBank'],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;'>OPENING BALANCE</td>
                <td></td>
                <td  id='obThisMonth' amount='".$obData['obThisMonth']."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obData['obThisMonth'],2,'.','')."</td>
                <td id='obThisYear' amount='".$obData['obThisYear']."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($obData['obThisYear'],2,'.','')."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisMonthCash'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearCash'],2,'.','')."</td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisMonthBank'],2,'.','')."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisYearBank'],2,'.','')."</td>
                <td></td>
            </tr>"
            ;
            }

            // dd($cashInBankForCurrentFiscalYear);
        }


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


            // if ($previousfiscalYearId!=null) {
            //     $cashInHandForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->whereIn('ledgerId',$cashTypeLedgers)
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->sum('balanceAmount');
            // }
            // else{
            //     $cashInHandForCurrentFiscalYear = 0;
            // }
            //
            // if ($previousfiscalYearId!=null) {
            //     $cashInBankForCurrentFiscalYear = $data['openingBalanceInfo']
            //                                     ->whereIn('ledgerId',$bankTypeLedgers)
            //                                     ->where('fiscalYearId',$previousfiscalYearId)
            //                                     ->sum('balanceAmount');
            // }
            // else{
            //     $cashInBankForCurrentFiscalYear = 0;
            // }
            //
            //
            //
            // $obThisPeriod = $cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'];

            if ($obData['roundUpSelected']==1) {
                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>OPENING BALANCE</td>
                <td></td>
                <td id='obThisPeriod' amount='".$obData['obThisPeriod']."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obThisPeriod'],2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisPeriodCash'],2)."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisPeriodBank'],2)."</td>
            </tr>"
            ;
            }
            else{
                echo
            "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>OPENING BALANCE</td>
                <td></td>
                <td id='obThisPeriod' amount='".$obData['obThisPeriod']."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($obData['obThisPeriod'],2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisPeriodCash'],2,'.','')."</td>
            </tr>".
            "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format($obData['obThisPeriodBank'],2,'.','')."</td>
            </tr>"
            ;
            }


        }

        }

    }






    function printClosingBalance($data)
    {

        if ($data['voucherTypeSelected']==2) {
            if ($data['searchMethodSelected']==1) {
                echo
                "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                <td></td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CLOSING BALANCE</td>
                <td></td>
                <td id='cbPreviousFiscalYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>

                <td id='cbCurrentFiscalYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td id='cashInHandForPreviousFiscalYear' amount='' style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td id='cashInBankForPreviousFiscalYear' amount='' style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                </tr>"
                ;
            }
            else if ($data['searchMethodSelected']==2) {
                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;'>CLOSING BALANCE</td>
                <td></td>
                <td  id='cbThisMonth' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format(0,2)."</td>
                <td id='cbThisYear' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format(0,2)."</td>
                <td id='cbCumulative' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>

                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>

                </tr>"
                ;
            }
            else if ($data['searchMethodSelected']==3) {
                echo
                "<tr>
                <td style='text-align: left;'>ASSET</td>
                <td></td>
                <td></td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CLOSING BALANCE</td>
                <td></td>
                <td id='cbThisPeriod' amount='0' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format(0,2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH IN HAND</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                </tr>".
                "<tr>
                <td style='text-align: left;'>CASH AT BANK</td>
                <td></td>
                <td style='text-align: right;padding-right:5px;'>".number_format(0,2)."</td>
                </tr>"
                ;
            }



        }



        //If not search by Only JV

        else{


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


// dd($previousPreviousfiscalYearId);

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

                // if ($previousfiscalYearId!=null) {
                //
                //     // $cashInHandForCurrentFiscalYear = $data['openingBalanceInfo']
                //     //                                 ->whereIn('ledgerId',$cashTypeLedgers)
                //     //                                 ->where('fiscalYearId',$previousfiscalYearId)
                //     //                                 ->sum('balanceAmount');
                //
                //
                //     if ($previousPreviousfiscalYearId!=null) {
                //         $cashInHandForPreviousFiscalYear = $data['openingBalanceInfo']
                //                                         ->whereIn('ledgerId',$cashTypeLedgers)
                //                                         ->where('fiscalYearId',$previousfiscalYearId)
                //                                         ->sum('balanceAmount');
                //     }
                //     else{
                //         $cashInHandForPreviousFiscalYear = 0;
                //     }
                //
                // }
                // else{
                //     $cashInHandForCurrentFiscalYear = 0;
                //     $cashInHandForPreviousFiscalYear = 0;
                // }
                //
                //
                // if ($previousfiscalYearId!=null) {
                //
                //     // $cashInBankForCurrentFiscalYear = $data['openingBalanceInfo']
                //     //                                 ->whereIn('ledgerId',$bankTypeLedgers)
                //     //                                 ->where('fiscalYearId',$previousfiscalYearId)
                //     //                                 ->sum('balanceAmount');
                //
                //     if ($previousPreviousfiscalYearId!=null) {
                //         $cashInBankForPreviousFiscalYear = $data['openingBalanceInfo']
                //                                         ->whereIn('ledgerId',$bankTypeLedgers)
                //                                         ->where('fiscalYearId',$previousfiscalYearId)
                //                                         ->sum('balanceAmount');
                //     }
                //     else{
                //         $cashInBankForPreviousFiscalYear = 0;
                //     }
                //
                // }
                // else{
                //     $cashInBankForCurrentFiscalYear = 0;
                //     $cashInBankForPreviousFiscalYear = 0;
                // }
                //
                // //Transaction
                // if ($data['branchSelected'] == Null || $data['branchSelected'] == 0) {
                //
                //     // previous
                //     // $previousFiscalYearCashDebit = $data['previousYearInfo']->sum('cashDebit');
                //     // $previousFiscalYearCashCredit = $data['previousYearInfo']->sum('cashCredit');
                //     //
                //     // $previousFiscalYearBankDebit = $data['previousYearInfo']->sum('bankDebit');
                //     // $previousFiscalYearBankCredit = $data['previousYearInfo']->sum('bankCredit');
                //
                //     // current
                //     $currentFiscalYearCahDebit = $data['thisYearTransactionOfCashTypeDebit'];
                //     $currentFiscalYearCashCredit = $data['thisYearTransactionOfCashTypeCredit'];
                //
                //     $currentFiscalYearBankDebit = $data['$thisYearTransactionOfBankTypeDebit'];
                //     $currentFiscalYearBankCredit = $data['$thisYearTransactionOfBankTypeCredit'];
                // }
                // else {
                //     // previous
                //     // $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');
                //     //
                //     //
                //     // $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');
                //
                //     $currentFiscalYearCahDebit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('debitAcc',$cashTypeLedgers)->sum('amount');
                //
                //     // current
                //     $currentFiscalYearCashCredit = DB::table('acc_voucher_details')->whereIn('voucherId',$data['vouchers'])->whereIn('creditAcc',$cashTypeLedgers)->sum('amount');
                //
                //
                //
                //     $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');
                // }
                //
                // // $previousFiscalYearCash = $previousFiscalYearCashDebit - $previousFiscalYearCashCredit;
                // // $previousFiscalYearBank = $previousFiscalYearBankDebit - $previousFiscalYearBankCredit;
                // $currentFiscalYearCash = $currentFiscalYearCahDebit - $currentFiscalYearCashCredit;
                // $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;'>CLOSING BALANCE</td>
                    <td></td>
                    <td id='cbPreviousFiscalYear' amount='".($data['cbPreviousYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbPreviousYear'],2)."</td>

                    <td id='cbCurrentFiscalYear' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisYear'],2)."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td id='cashInHandForPreviousFiscalYear' amount='' style='text-align: right;padding-right:5px;'>".number_format($data['cbPreviousYearCash'], 2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2)."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td id='cashInBankForPreviousFiscalYear' amount='' style='text-align: right;padding-right:5px;'>".number_format($data['cbPreviousYearBank'], 2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'], 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;'>CLOSING BALANCE</td>
                    <td></td>
                    <td id='cbPreviousFiscalYear' amount='".($data['cbPreviousYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbPreviousYear'],2,'.','')."</td>

                    <td id='cbCurrentFiscalYear' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisYear'],2,'.','')."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbPreviousYearCash'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2,'.','')."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbPreviousYearBank'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'],2,'.','')."</td>
                    </tr>"
                    ;
                }




            }

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

                // dd($previousfiscalYearId);
                // if ($previousfiscalYearId!=null) {
                //     $cashInHandForPreviousFiscalYear = $data['openingBalanceInfo']
                //                                     ->whereIn('ledgerId',$cashTypeLedgers)
                //                                     ->where('fiscalYearId',$previousfiscalYearId)
                //                                     ->sum('balanceAmount');
                //
                //     // echo $cashInHandForCurrentFiscalYear;
                //     // print_r($cashTypeLedgers);    //348, 412
                //     // $previousfiscalYearId = 2;
                //     // $data['projectSelected'] = 1;
                //     // print_r($data['projectTypeId']) = 1,2,3,7,8,9,10,11,12,13,14;
                //     // print_r($data['branchId'])=1;
                //     // $cashInHandForCurrentFiscalYear = 24849;
                // }
                // else{
                //     $cashInHandForPreviousFiscalYear = 0;
                // }
                //
                // if ($previousfiscalYearId!=null) {
                //     $cashInBankForPreviousFiscalYear = $data['openingBalanceInfo']
                //     ->whereIn('ledgerId',$bankTypeLedgers)
                //     ->where('fiscalYearId',$previousfiscalYearId)
                //     ->sum('balanceAmount');
                //
                //     // echo $data['projectSelected']."<br>";
                //     // echo "<br>";
                //     // print_r($data['projectTypeId']) ;
                //     // echo "<br>";
                //     // print_r($data['branchId']) ;
                //     // $cashInBankForCurrentFiscalYear=1334207.76 ;
                //     // $cashInHandForCurrentFiscalYear=24849 ;
                //     // print_r($bankTypeLedgers);
                //     // print_r($cashTypeLedgers); = 348,412;
                //     // $previousfiscalYearId=2;
                //     // projectId=15;
                //     //projectType = 1, 2,3 ,7,8,9,10,11,12,13,14
                // }
                // else{
                //     $cashInBankForPreviousFiscalYear = 0;
                // }
                //
                // $obThisMonth = $cashInHandForPreviousFiscalYear + $data['thisPeriodTransactionOfCashTypeDebit'] - $data['thisPeriodTransactionOfCashTypeCredit'] + $cashInBankForPreviousFiscalYear + $data['thisPeriodTransactionOfBankTypeDebit'] - $data['thisPeriodTransactionOfBankTypeCredit'];
                // $obThisYear = $cashInHandForPreviousFiscalYear + $cashInBankForPreviousFiscalYear;
                //
                // // echo $cashInHandForCurrentFiscalYear. "<br>";
                // // echo $data['thisMonthTransactionOfBankTypeDebit']. "<br>";
                // // echo $data['thisMonthTransactionOfBankTypeCredit']. "<br>";
                // // echo $data['thisMonthTransactionOfCashTypeDebit']. "<br>";
                // // echo $data['thisMonthTransactionOfCashTypeCredit']. "<br>";
                // // echo $cashInBankForCurrentFiscalYear. "<br>";
                //
                //
                //
                //
                // //Transaction
                // if ($data['branchSelected'] == Null || $data['branchSelected'] == 0) {
                //
                //     $thisMonthCashDebit = $data['thisMonthTransactionOfCashTypeDebit'];
                //     $thisMonthCashCredit = $data['thisMonthTransactionOfCashTypeCredit'];
                //     $thisMonthCash = $thisMonthCashDebit - $thisMonthCashCredit;
                //
                //     $thisMonthBankDebit = $data['thisMonthTransactionOfBankTypeDebit'];
                //     $thisMonthBankCredit = $data['thisMonthTransactionOfBankTypeCredit'];
                //     $thisMonthBank = $thisMonthBankDebit - $thisMonthBankCredit;
                //
                //     $currentFiscalYearCahDebit = $data['thisYearTransactionOfCashTypeDebit'];
                //     $currentFiscalYearCashCredit = $data['thisYearTransactionOfCashTypeCredit'];
                //     $currentFiscalYearCash = $currentFiscalYearCahDebit - $currentFiscalYearCashCredit;
                //
                //     $currentFiscalYearBankDebit = $data['thisYearTransactionOfBankTypeDebit'];
                //     $currentFiscalYearBankCredit = $data['thisYearTransactionOfBankTypeCredit'];
                //     $currentFiscalYearBank = $currentFiscalYearBankDebit - $currentFiscalYearBankCredit;
                //
                // }
                // else {
                //
                //     $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;'>CLOSING BALANCE</td>
                    <td></td>
                    <td  id='cbThisMonth' amount='".($data['cbThisMonth'])."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($data['cbThisMonth'],2)."</td>
                    <td id='cbThisYear' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($data['cbThisYear'],2)."</td>
                    <td id='cbCumulative' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisYear'],2)."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisMonthCash'], 2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2)."</td>

                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisMonthBank'],2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'],2)."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'],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;'>CLOSING BALANCE</td>
                    <td></td>
                    <td  id='cbThisMonth' amount='".($data['cbThisMonth'])."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($data['cbThisMonth'],2,'.','')."</td>
                    <td id='cbThisYear' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;font-weight:bold;'>".number_format($data['cbThisYear'],2)."</td>
                    <td id='cbCumulative' amount='".($data['cbThisYear'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisYear'],2,'.','')."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisMonthCash'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearCash'],2,'.','')."</td>

                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisMonthBank'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'],2,'.','')."</td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisYearBank'],2,'.','')."</td>

                    </tr>"
                    ;
                }


            }


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


                // if ($previousfiscalYearId!=null) {
                //     $cashInHandForCurrentFiscalYear = $data['openingBalanceInfo']
                //                                     ->whereIn('ledgerId',$cashTypeLedgers)
                //                                     ->where('fiscalYearId',$previousfiscalYearId)
                //                                     ->sum('balanceAmount');
                // }
                // else{
                //     $cashInHandForCurrentFiscalYear = 0;
                // }
                //
                // if ($previousfiscalYearId!=null) {
                //     $cashInBankForCurrentFiscalYear = $data['openingBalanceInfo']
                //                                     ->whereIn('ledgerId',$bankTypeLedgers)
                //                                     ->where('fiscalYearId',$previousfiscalYearId)
                //                                     ->sum('balanceAmount');
                // }
                // else{
                //     $cashInBankForCurrentFiscalYear = 0;
                // }
                //
                // $obThisPeriod = $cashInHandForCurrentFiscalYear+$data['thisPeriodTransactionOfCashTypeDebit']-$data['thisPeriodTransactionOfCashTypeCredit']+$cashInBankForCurrentFiscalYear+$data['thisPeriodTransactionOfBankTypeDebit']-$data['thisPeriodTransactionOfBankTypeCredit'];
                //
                //
                //
                //
                // //Transaction
                // if ($data['branchSelected'] == Null || $data['branchSelected'] == 0) {
                //
                //     $thisPeriodCashDebit = $data['dateRangeTransactionOfCashTypeDebit'];
                //     $thisPeriodCashCredit = $data['dateRangeTransactionOfCashTypeCredit'];
                //     $thisPeriodCash = $thisPeriodCashDebit - $thisPeriodCashCredit;
                //
                //     $thisPeriodBankDebit = $data['dateRangeTransactionOfBankTypeDebit'];
                //     $thisPeriodBankCredit = $data['dateRangeTransactionOfBankTypeCredit'];
                //     $thisPeriodBank = $thisPeriodBankDebit - $thisPeriodBankCredit;
                // }
                // else {
                //
                //     $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;'>CLOSING BALANCE</td>
                    <td></td>
                    <td id='cbThisPeriod' amount='".($data['cbThisPeriod'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisPeriod'],2)."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisPeriodCash'],2)."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisPeriodBank'],2)."</td>
                    </tr>"
                    ;
                }
                else{
                    echo
                    "<tr>
                    <td style='text-align: left;'>ASSET</td>
                    <td></td>
                    <td></td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CLOSING BALANCE</td>
                    <td></td>
                    <td id='cbThisPeriod' amount='".($data['cbThisPeriod'])."' style='text-align: right;padding-right:5px;font-weight:bold;'>".number_format($data['cbThisPeriod'],2,'.','')."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH IN HAND</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisPeriodCash'],2,'.','')."</td>
                    </tr>".
                    "<tr>
                    <td style='text-align: left;'>CASH AT BANK</td>
                    <td></td>
                    <td style='text-align: right;padding-right:5px;'>".number_format($data['cbThisPeriodBank'],2,'.','')."</td>
                    </tr>"
                    ;
                }

            }

        }

        // dd(1);

    }


@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> --}}
                <button id="printIcon" class="btn btn-info pull-right"  target="_blank" style="font-size: 14px; margin-top: 10px; border: 3px solid #525659; border-radius: 25px;">
                        <i class="fa fa-print fa-lg" aria-hidden="true"> Print</i>
                    </button>

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




            <!-- 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('', 'V. 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-s','style'=>'font-size:12px;']) !!}
                                            </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  class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold;">


                        <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/guk_bk/resources/views/accounting/reports/receiptPaymentStatement.blade.php:1691
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/reports/receiptPaymentStatement.blade.php</b> on line <b>1691</b><br />