@extends('backend.layouts.app')
<style>
    table thead tr th{
        font-size:14px;
        text-align:center;
    }
</style>
<link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0/css/bootstrap.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css" rel="stylesheet">
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script>
    $('document').ready(function(){
        var table = $('#example').DataTable({
            "bLengthChange": false,
            columnDefs: [
                // { width: 500, targets: 2 },
                // { width: 500, targets: 4 },
            ],
            // fixedColumns: false,
            // initComplete: function () {
            //     this.api().columns().every( function () {
            //         var column = this;
            //         var select = $('<select class="form-control select2" style="width: 100%;"><option value=""></option></select>')
            //             .appendTo( $(column.header()).empty() )
            //             .on( 'change', function () {
            //                 var val = $.fn.dataTable.util.escapeRegex(
            //                     $(this).val()
            //                 );
    
            //                 column
            //                     .search( val ? '^'+val+'$' : '', true, false )
            //                     .draw();
            //             } );
    
            //         column.data().unique().sort().each( function ( d, j ) {
            //             select.append( '<option value="'+d+'">'+d+'</option>' )
            //         } );
            //     } );
            // }
        });
        // $(".filterhead").each( function ( i ) {
        //     var select = $('<select class="select2" width="100%;"><option value="">Search</option></select>')
        //     .appendTo( $(this).empty() )
        //     .on( 'change', function () {
        //        var term = $(this).val();
        //         table.column( i ).search(term, false, false ).draw();
        //     } );
 	    //      table.column( i ).data().unique().sort().each( function ( d, j ) {
        //     	select.append( '<option value="'+d+'">'+d+'</option>' )
        //     } );
		// } );
        $('.select2').select2();
    });
</script>

@section('content')

<!-- <div class="col-xl-12">
    <div class="breadcrumb-holder">
		<h5 style="text-align: center"> Summary of Balance-Sheet</h5>
		    <a href="{{ route('accounts.mainPage') }}" style="color: #000000; border: 1px solid #eee; width: 60%; margin: 15px auto; box-shadow: 0px 0px 5px 5px #9e9c9c;">
                <i class="fa fa-home" aria-hidden="true" style="font-size: 20px; "></i>
                {{-- <img src="{{ route('accounts') }}" style="width: 20px"> --}}
                    Account Dashboard
            </a>
            <a href="{{ route('logout-submit') }}" class="pull-right" style="color: #000000; border: 1px solid #eee; -4px auto box-shadow: 0px 0px 5px 5px #9e9c9c;">
                <i class="fa fa-sign-out" aria-hidden="true" style="font-size: 20px; "></i>
                Logout
            </a>
		<ol class="breadcrumb float-right">
		</ol>
		<div class="clearfix"></div>
	</div>
</div> -->
@include('backend.account.headerMenu')
<div class="container-fluid">
	<div class="col-md-12">
		<div style="text-align: right; margin-bottom: 20px;">
            <u><h5 style="text-align: center"> Summary of Balance-Sheet</h5></u>
        </div>
        <div class="card">
            <div class="card-header" style="display: inherit;">
                <div class="col-md-6">
                    <div class="row">
                        <div class="col-md-6">
                            <h4>A/C: {{ App\Model\Account\Department::find($department_id)->name }}</h4>
                        </div>
                        <div class="col-md-6">
                        </div>
                    </div>
                </div>
                <div class="col-md-6">
                    <div>
                        <form action="" method="GET">
                            <div class="row">
                                <div class="col-sm-4">
                                    <div class="form-group">
                                        <label class="control-label">Date From</label>
                                        <input type="text" name="date_from" id="date_from" class="form-control single-date-picker-account" value="@if(request()->date_from){{ request()->date_from }}@else{{ $first_date }}@endif" autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-4">
                                    <div class="form-group">
                                        <label class="control-label">Date To</label>
                                        <input type="text" name="date_to" id="date_to" class="form-control single-date-picker-account" value="@if(request()->date_to){{ request()->date_to }}@else{{ $last_date }}@endif"  autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-4" style="padding-top: 30px;">
                                    <div class="form-group">
                                        <button type="submit" class="btn btn-info"><i class="fa fa-search"></i></button>								
                                        <button title="Report Print" type="button" id="printFullReport" class="btn btn-info" >
                                            <i class="fa fa-print"></i>
                                        </button>
                                    </div>
                                </div>	
                            </div>				
                        </form>
                    </div>
                    <div style="float: right;">
                        <form target="_blank" action="{{ route('reportBalanceSheetPrint',$department_id) }}" method="get" id="printFullReportForm">
                            <input type="hidden" name="date_from" id="date_form_2">
                            <input type="hidden" name="date_to" id="date_to_2">
                        </form>
                    </div>
                </div>
            </div>
            <div class="card-body">	
                <div class="row">
                    <div class="col-md-12" style="text-align: center">
                        <u><h5>RECEIPT AND PAYMENT ACCOUNT </h5>
                        <h5>AGC FUND</h5></u>
                    </div>
                    <div class="col-md-12">
                        <h3><u>Receipt:</u></h3>
                        <table class="table table-striped table-bordered" id="" style="width: 100%;">
                            <tbody>
                                <tr>
                                    <td>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">
                        <h3><u>Payment:</u></h3>
                        <table class="table table-striped table-bordered" id="" style="width: 100%;">
                            <tbody>
                                <tr>
                                    <td>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>
                                    <tr>
                                        <td colspan="2"> <strong>Total:</strong></td>
                                        <td>-</td>
                                        <td><strong>{{ $debitCapitalExpenditureSum + $debitRevenueExpenditureSum + $cashinHand + $fdr}}</strong></td>
                                    </tr>
                                </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>INCOME & EXPENDITURE ACCOUNT</h5>
                        </u>
                    </div>
                    <div class="col-md-12">
                        <table class="table table-striped table-bordered" id="" style="width: 100%;">
                            <tbody>
                                <tr>
                                    <td>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="row">
                    <div class="col-md-12" style="text-align: center">
                        <u><h5>BALANCE SHEET</h5>
                        </u>
                    </div>
                    <div class="col-md-12">
                        <table class="table table-striped table-bordered" id="" style="width: 100%;">
                            <thead>
                                <tr>
                                    <th align="center">Asset</th>
                                    <th 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%;margin-top: -19px;">
                                            <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>
        </div>			
	</div>
</div>

<input type="hidden" id="modalValue" value="{{ Session::get('modal') }}">

@endsection

@section('modal_content')

@endsection
@section('page_script')>
<script>
  $('document').ready(function(){
    var err = $('#modalValue').val();
    $('#create').modal({ 'show' : err =="create" ? true : false });
    $('#edit').modal({ 'show' : err =="edit" ? true : false });
  });
</script>
<script>
    $('document').ready(function(){
        $("#edit").on("show.bs.modal", function(e) { 
            var id = $(e.relatedTarget).data('target-id');
            var current_due = $(e.relatedTarget).data('current_due');
            $('#edit .modal-body #current_due').val(current_due);
            $('#editForm').attr('action',$('#mainUrlSwmiimg').val()+'/duePaid/'+id);
            if(current_due > 0){
                $('#edit .modal-footer #modalSubmit').prop('disabled', false);
            }else{
                $('#edit .modal-footer #modalSubmit').prop('disabled', true);
            }
        });
        $('.single-date-picker-account').daterangepicker({
			singleDatePicker: true,
			showDropdowns: true,
			autoUpdateInput: false,
			locale: {
		      format: 'DD/MM/YYYY'
		    }
		});
        $('.single-date-picker').on('apply.daterangepicker', function(ev, picker){
			$(this).val(picker.startDate.format('YYYY-MM-DD'));			
		});
        $('#printFullReport').click(function(){
            var date_from = $('#date_from').val();
            $('#date_form_2').val(date_from);
            var date_to = $('#date_to').val();
            $('#date_to_2').val(date_to);
            document.getElementById('printFullReportForm').submit();
            //$(this).attr('href',$('#mainUrlSwmiimg').val()+'/totalPrintView/'+'date_from='+date_from+'&date_to='+date_to);
        })
    })
</script>
@endsection