@extends('backend.layouts.app')
<style>
    table thead tr th{
        font-size:11px;
    }
</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">Income Statement</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">Income Statement</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('summaryOfCreditDebitReportPrint',$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>INCOME & EXPENDITURE - {{ date("F,", strtotime($first_date)) }} Periodic</h5>
                        <h5>AGC FUND</h5></u>
                    </div>
                    <div class="col-md-4">
                        <h3>Credit</h3>
                        <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"> <strong>Total Receipts:</strong></td>
                                    <td> <strong>{{ $sumTotalCredit }}</strong></td>
                                </tr>
                                <tr>
                                    <td colspan="3"></td>
                                </tr>
                                <tr>
                                    <td colspan="2">Opening Balance From {{ date("jS F, Y", strtotime($first_date)) }}</td>
                                    <td>{{ $openingBalance }}</td>
                                </tr>
                                <tr>
                                    <td colspan="2">Capital Expenditure</td>
                                    <td>{{ $debitCapitalExpenditureSum }}</td>
                                </tr>
                                <tr>
                                    <td colspan="2">Revenue Expenditure</td>
                                    <td>{{ $debitRevenueExpenditureSum }}</td>
                                </tr>
                                <tr>
                                    <td colspan="2"><strong>Total Expenditure</strong></td>
                                    <td><strong>{{ $debitCapitalExpenditureSum + $debitRevenueExpenditureSum }}</strong></td>
                                </tr>
                                <tr>
                                    <td colspan="3"></td>
                                </tr>
                                <tr>
                                    <td colspan="2"><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-md-8">
                        <h3 style="text-align: center">Debit</h3>
                        <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>
                                        <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"><strong>Total:</strong></td>
                                    <td><strong>{{ $debitCapitalExpenditureSum }}</strong></td>
                                    <td colspan="2"><strong>Total:</strong></td>
                                    <td><strong>{{ $debitRevenueExpenditureSum }}</strong></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').daterangepicker({
			singleDatePicker: true,
			showDropdowns: true,
			autoUpdateInput: false,
			locale: {
		      format: 'YYYY-MM-DD'
		    }
		});
        $('.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