@extends('admin.layout.app')
@section('title','Account Payable Aging Report')
@push('headerscript')
    <link href="{{asset('theme/plugins/select2/css/select2.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}" rel="stylesheet">
    <link href="{{asset('theme/plugins/datatables/responsive.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/datatables/dataTables.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/css/custom.css')}}" rel="stylesheet" type="text/css"/>
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Account Payable Aging Report</h4>
                        <div class="pull-right">
                            <a href="{{url()->previous()}}"
                               class="btn btn-custom btn-rounded waves-effect waves-light m-b-2 m-r-15"><i
                                    class=" mdi mdi-keyboard-backspace"></i> Back</a>
                            {{--<button type="button" onclick="exportsExcel()"
                                    class="btn btn-success btn-sm pull-right"
                                    title="Export in Excel">
                                <i class="fa fa-file-excel-o"></i>
                            </button>--}}
                            <button type="button" onclick="exportsPdf()"
                                    class="btn btn-danger btn-sm pull-right m-r-10"
                                    title="Export in Pdf">
                                <i class="fa fa-file-pdf-o"></i>
                            </button>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card-box">
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="row">
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="supplier_id">Supplier</label>
                                        {!! Form::select("supplier_id", [''=>'Select Supplier']+$supplier, old("supplier_id"), ['class'=>'form-control select2', 'required', 'id'=>'supplier_id'] ) !!}
                                    </div>
                                    {{--<div class="form-group col-sm-3 col-12">
                                        <label for="account_id">Account</label>
                                        {!! Form::select("account_id", [''=>'Select']+$accounts, old("account_id"), ['class'=>'form-control', 'required', 'id'=>'account_id'] ) !!}
                                    </div>--}}
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="period">Period Filter</label>
                                        {!! Form::select("period", [''=>'Select','1'=>'1-30','2'=>'31-60','3'=>'61-90','4'=>'91-120','5'=>'120 and Above'], old("period"), ['class'=>'form-control', 'required', 'id'=>'period'] ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="current_date">Date</label>
                                        <input type="text" name="current_date" id="current_date"
                                               value="{{date('d-m-Y')}}"
                                               class="form-control datepicker" autocomplete="off">
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-sm-12 col-12">
                                        <div class="table-responsive">
                                            <table class="table table-bordered " id="datatables">
                                                <thead>
                                                <tr>
                                                    <th>S.No.</th>
                                                    <th>Supplier Name</th>
                                                    <th>Account Ledger</th>
                                                    <th>Ledger Code</th>
                                                    <th>1-30</th>
                                                    <th>31-60</th>
                                                    <th>61-90</th>
                                                    <th>91-120</th>
                                                    <th>120 and Above</th>
                                                </tr>
                                                </thead>
                                                <tbody>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>
@endsection
@push('footerscript')
    <script src="{{asset('theme/plugins/moment/moment.js')}}"></script>
    <script src="{{asset('theme/plugins/select2/js/select2.full.js')}}"></script>
    <script src="{{asset('theme/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/dataTables.bootstrap.js')}}"></script>
    {{--    <script src="{{asset('theme/plugins/datatables/responsive.bootstrap.min.js')}}"></script>--}}
    <script>
        $('.select2').select2();

        $(".datepicker").datepicker({
            format: 'dd-mm-yyyy',
            autoclose: true,
            endDate: "today"
        });

        $('#supplier_id, #period, #current_date').on('change', function () {
            $('#datatables').DataTable().draw(false);
        });

        $(function () {
            $('#datatables').DataTable({
                processing: true,
                serverSide: true,
                stateSave: true,
                responsive: true,
                oLanguage: {"sSearch": "master search"},
                ajax: {
                    url: '{{route('accountPayableAging.getData') }}',
                    data: function (d) {
                        d.supplier_id = $('#supplier_id').val();
                        d.period = $('#period').val();
                        d.current_date = $('#current_date').val();
                    },
                },
                columns: [
                    {data: 'DT_RowIndex', name: 'DT_RowIndex', searchable: false},
                    {data: 'supplier_name', name: 'supplier_name'},
                    {data: 'account_ledger', name: 'account_ledger'},
                    {data: 'ledger_code', name: 'ledger_code'},
                    {data: 'period1', name: 'period1'},
                    {data: 'period2', name: 'period2'},
                    {data: 'period3', name: 'period3'},
                    {data: 'period4', name: 'period4'},
                    {data: 'period5', name: 'period5'},
                ]
            });
        });

        function exportsExcel() {
            var supplier_id = $('#supplier_id').val();
            var period = $('#period').val();
            var current_date = $('#current_date').val();
            window.location.href = "{{route('accountPayableAging.exportExcel')}}?supplier_id=" + supplier_id + "&period=" + period + "&current_date=" + current_date;
        }

        function exportsPdf() {
            var supplier_id = $('#supplier_id').val();
            var period = $('#period').val();
            var current_date = $('#current_date').val();
            window.location.href = "{{route('accountPayableAging.exportPdf')}}?supplier_id=" + supplier_id + "&period=" + period + "&current_date=" + current_date;
        }
    </script>
@endpush