@extends('backend.layouts.pdf')
<style type="text/css">
.last_page{
    /*page-break-after: always;*/
    page-break-inside: avoid;
}
</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>
            <u>
                <h5 style="text-align: center"><strong>Income Statement</strong></h5>
                <h5 style="text-align: center"><strong>INCOME & EXPENDITURE - {{ date("F,", strtotime($first_date)) }} Periodic</strong></h5>
                <h5 style="text-align: center;margin-left:82px;"><strong>AGC FUND</strong></h5>
            </u>
            <!--<h5 style="text-align: center; margin: 0px;">Swimming Report</h5> -->
            <!-- <p style="text-align: center;">{{ App\Model\Account\Department::find($department_id)->name }}</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-xs-4">
            <p><strong>Credit</strong></p>
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <thead>
                    <tr>
                        <th>Sl</th>
                        <th>Description</th>
                        <th>BDT</th>
                    </tr>
                </thead>
                <tbody>
                    @if(sizeof($creditModel) > 0)
                    @foreach($creditModel as $m)
                    <tr>
                        <td>{{ ++$crsl }}</td>
                        <td>{{ $m->income_source_name }}</td>
                        <td>{{ $m->amount }}</td>
                    </tr>
                    @endforeach
                    @endif
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="2" style="text-align: left;"> <strong>Total Receipts:</strong></td>
                        <td> <strong>{{ $sumTotalCredit }}</strong></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="text-align: left;">Opening Balance From {{ date("jS F, Y", strtotime($first_date)) }}</td>
                        <td>{{ $openingBalance }}</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="text-align: left;">Capital Expenditure</td>
                        <td>{{ $debitCapitalExpenditureSum }}</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="text-align: left;">Revenue Expenditure</td>
                        <td>{{ $debitRevenueExpenditureSum }}</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="text-align: left;"><strong>Total Expenditure</strong></td>
                        <td><strong>{{ $debitCapitalExpenditureSum + $debitRevenueExpenditureSum }}</strong></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="text-align: left;"><strong>Closing Balance (As on {{ date("jS F, Y", strtotime($last_date)) }})</strong></td>
                        <td><strong>{{ ($sumTotalCredit+$openingBalance)-($debitCapitalExpenditureSum + $debitRevenueExpenditureSum) }}</strong></td>
                    </tr>
                </tfoot>
            </table>	
        </div>
        <div class="col-xs-8">
            <p style="text-align: center"><strong>Debit</strong></p>
            <table class="table table-striped table-bordered" id="" style="width: 100%;">
                <thead>
                    <tr>
                        <th>Sl</th>
                        <th>Capital Expenditure</th>
                        <th>BDT</th>
                        <th>Sl</th>
                        <th>Revenue Expenditure</th>
                        <th>BDT</th>
                    </tr>
                </thead>
                <tbody>
                    @if(sizeof($debitCapitalExpenditure)>0 || sizeof($debitRevenueExpenditure)>0)
                        @if(sizeof($debitCapitalExpenditure) >= sizeof($debitRevenueExpenditure))
                        @foreach($debitCapitalExpenditure as $key=>$value)
                        <tr>

                        </tr>
                        <tr>
                            <td>{{ ++$drcapsl }}</td>
                            <td>{{ $value->expenditure_name }}</td>
                            <td>{{ $value->amount }}</td>
                            <td>{{ ++$drRevsl }}</td>
                            <td>
                                @if(array_key_exists($key,$debitRevenueExpenditure)) 
                                    {{ ++$drRevsl }}
                                @else
                                    -
                                @endif
                            </td>
                            <td>
                                @if(array_key_exists($key,$debitRevenueExpenditure)) 
                                    {{ $debitRevenueExpenditure[$key]->expenditure_name }} 
                                @else
                                    -
                                @endif
                            </td>
                            <td>
                                @if(array_key_exists($key,$debitRevenueExpenditure)) 
                                    {{ $debitRevenueExpenditure[$key]->amount }} 
                                @else
                                    -
                                @endif
                            </td>
                        </tr>
                        @endforeach
                        @else
                        @foreach($debitRevenueExpenditure as $key=>$value)
                        <tr>
                            <td>
                                @if(array_key_exists($key,$debitCapitalExpenditure)) 
                                    {{ ++$drcapsl }}
                                @else
                                    -
                                @endif
                            </td>
                            <td>
                                @if(array_key_exists($key,$debitCapitalExpenditure)) 
                                    {{ $debitCapitalExpenditure[$key]->expenditure_name }} 
                                @else
                                    -
                                @endif
                            </td>
                            <td>
                                @if(array_key_exists($key,$debitCapitalExpenditure)) 
                                    {{ $debitCapitalExpenditure[$key]->amount }} 
                                @else
                                    -
                                @endif
                            </td>
                            <td>{{ ++$drRevsl }}</td>
                            <td>{{ $value->expenditure_name }}</td>
                            <td>{{ $value->amount }}</td>
                        </tr>
                        @endforeach
                        @endif
                    @endif
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="2" style="text-align: left;"><strong>Total:</strong></td>
                        <td><strong>{{ $debitCapitalExpenditureSum }}</strong></td>
                        <td colspan="2" style="text-align: left;"><strong>Total:</strong></td>
                        <td><strong>{{ $debitRevenueExpenditureSum }}</strong></td>
                    </tr>
                </tfoot>
            </table>	
        </div>
    </div>	
</div>
@include('backend.account.pdf.signature')
<style type="text/css">
	table th, table td {
		font-size: 12px;
	}
    table tfoot td{
        text-align:center;
    }
</style>
@endsection