@extends('backend.layouts.pdf')
<style type="text/css">
.last_page{
    /*page-break-after: always;*/
    page-break-inside: avoid;
}
.whatever { page-break-after: always; }
</style>
@section('content')
<div class="container" style="padding-right: 40px; padding-left: 35px;">
    <div class="row">
        <div class="col-xs-1 text-left">
            <img src="{{asset('public/backend/images/logo.png')}}" style="margin:0 auto; width:50px" class="img-rounded" alt="Cinque Terre">
        </div>
        <div style="text-align:center;">
            <h3 style="text-align: center; margin: 0px;">A/C: {{ App\Model\Account\Department::find($department_id)->name }}</h3> 
            <p style="text-align: center; margin: 0px;">{{ App\Model\Account\Department::find($department_id)->acc_no }}</p>
        </div>
        <div class="co-xs-1 text-right">
            
        </div>
    </div>			
		</div>
		<br>
<div class="container">
    <p> <strong>Date form: {{ date('d/m/Y',strtotime($request->date_from)) }} to: {{ date('d/m/Y',strtotime($request->date_to)) }} </strong></p>
    <div class="row">
        <div class="col-md-12" style="text-align: center">
            <u><h5><strong>RECEIPT AND PAYMENT ACCOUNT</strong></h5></u>
        </div>
        <div class="col-md-12">
            <p><u><strong>Receipt:</strong></u></p>
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <tbody>
                    <tr>
                        <td width="5%">a.</td>
                        <td>Opening Balance (As On {{ date("jS F, Y", strtotime($first_date)) }})</td>
                        <td>-</td>
                        <td>{{ $openingBalance }}</td>
                    </tr>
                    <tr>
                        <td>b.</td>
                        <td>Cash in Hand</td>
                        <td>-</td>
                        <td>{{ $cashinHand }}</td>
                    </tr>
                    <tr>
                        <td>c.</td>
                        <td>FDR</td>
                        <td>-</td>
                        <td>{{ $fdr }}</td>
                    </tr>
                    <tr>
                        <td>d.</td>
                        <td>Receipt (Income)</td>
                        <td>-</td>
                        <td>{{ $sumTotalCredit }}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="2"> <strong>Total Receipts (BDT):</strong></td>
                        <td>-</td>
                        <td><strong>{{ $openingBalance + $cashinHand  + $fdr + $sumTotalCredit }}</strong></td>
                    </tr>
                </tfoot>
            </table>	
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <p><u><strong>Payment:</strong></u></p>
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <tbody>
                    <tr>
                        <td width="5%">a.</td>
                        <td>Capital Expenditure</td>
                        <td>-</td>
                        <td>{{ $debitCapitalExpenditureSum }}</td>
                    </tr>
                    <tr>
                        <td>b.</td>
                        <td>Revenue Expenditure</td>
                        <td>-</td>
                        <td>{{ $debitRevenueExpenditureSum }}</td>
                    </tr>
                    <tr>
                        <td>c.</td>
                        <td>Cash in Hand</td>
                        <td>-</td>
                        <td>{{ $cashinHand }}</td>
                    </tr>
                    <tr>
                        <td>d.</td>
                        <td>FDR</td>
                        <td>-</td>
                        <td>{{ $fdr }}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="2"> <strong>Total:</strong></td>
                        <td>-</td>
                        <td><strong>{{ $debitCapitalExpenditureSum + $debitRevenueExpenditureSum + $cashinHand + $fdr}}</strong></td>
                    </tr>
                    <tr>
                        <td colspan="2"> <strong>Closing Balance (As On {{ date("jS F, Y", strtotime($last_date)) }}) (BDT):</strong></td>
                        <td>-</td>
                        <td><strong>{{ 
                            ($openingBalance + $cashinHand  + $fdr + $sumTotalCredit) 
                            -  ( $debitCapitalExpenditureSum + $debitRevenueExpenditureSum + $cashinHand + $fdr ) 
                            }}</strong></td>
                    </tr>
                </tfoot>
            </table>	
        </div>
    </div>
    <div class="row">
        <div class="col-md-12" style="text-align: center">
            <u><h5><strong>INCOME & EXPENDITURE ACCOUNT</strong></h5>
            </u>
        </div>
        <div class="col-md-12">
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <tbody>
                    <tr>
                        <td  width="5%">a.</td>
                        <td>Income Receipt</td>
                        <td>-</td>
                        <td>{{ $sumTotalCredit }}</td>
                    </tr>
                    <tr>
                        <td>b.</td>
                        <td>Expenditure/Revenue Expenditure</td>
                        <td>-</td>
                        <td>{{ $debitRevenueExpenditureSum }}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="2"> <strong>Surplus/(Deficit) of income Over Expenditure (BDT):</strong></td>
                        <td>-</td>
                        <td><strong>{{ $sumTotalCredit - $debitRevenueExpenditureSum }}</strong></td>
                    </tr>
                </tfoot>
            </table>	
        </div>
    </div>
    <div class="whatever"></div>
    <div class="row">
        <div class="col-md-12" style="text-align: center">
            <u><h5><strong>BALANCE SHEET</strong></h5>
            </u>
        </div>
        <div class="col-md-12">
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <thead>
                    <tr>
                        <th align="center" style=" text-align: center; ">Asset</th>
                        <th align="center" style=" text-align: center; ">Libilities </th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>
                            <table class="table " style="width: 100%;">
                                <tbody >
                                    <tr>
                                        <td>Cash In Hand</td>
                                        <td>-</td>
                                        <td>{{ $cashinHand }}</td>
                                    </tr>
                                    <tr>
                                        <td>Cash at Bank</td>
                                        <td>-</td>
                                        <td>{{ 
                                            ($openingBalance + $cashinHand  + $fdr + $sumTotalCredit) 
                                            -  ( $debitCapitalExpenditureSum + $debitRevenueExpenditureSum + $cashinHand + $fdr ) 
                                            }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>Equipment/Capital</td>
                                        <td>-</td>
                                        <td>{{ $debitCapitalExpenditureSum }}</td>
                                    </tr>
                                    <tr>
                                        <td>FDR</td>
                                        <td>-</td>
                                        <td>{{ $fdr }}</td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                        <td>
                            <table class="table" style="width: 100%;">
                                <tbody >
                                    <tr>
                                        <td>Capital Fund</td>
                                        <td>-</td>
                                        <td>{{ $openingBalance }}</td>
                                    </tr>
                                    <tr>
                                        <td>Surplus/Deficit (-)</td>
                                        <td>-</td>
                                        <td>{{ $sumTotalCredit - $debitRevenueExpenditureSum }}</td>
                                    </tr>
                                    <tr>
                                        <td>Cash In Hand</td>
                                        <td>-</td>
                                        <td>{{ $cashinHand }}</td>
                                    </tr>
                                    <tr>
                                        <td>FDR</td>
                                        <td>-</td>
                                        <td>{{ $fdr }}</td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td>
                            <table class="table " style="width: 100%;">
                                <tbody >
                                    <tr>
                                        <td><strong>Total (BDT):</strong></td>
                                        <td align="right"><strong>
                                            {{ $cashinHand + (($openingBalance + $cashinHand  + $fdr + $sumTotalCredit) 
                                            -  ( $debitCapitalExpenditureSum + $debitRevenueExpenditureSum + $cashinHand + $fdr ) 
                                            + $debitCapitalExpenditureSum + $fdr) }}
                                        </strong></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                        <td>
                            <table class="table " style="width: 100%;">
                                <tbody >
                                    <tr>
                                        <td><strong>Total (BDT):</strong></td>
                                        <td align="right"><strong>
                                        {{ $openingBalance + ($sumTotalCredit - $debitRevenueExpenditureSum) + $cashinHand + $fdr}}
                                        </strong></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                    </tr>
                </tfoot>
            </table>	
        </div>
    </div>
</div>
@include('backend.account.pdf.signature')
<style type="text/css">
	table th, table td {
		font-size: 12px;
	}
</style>
@endsection