@extends('layouts.admin')


@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }
    </style>
@endpush


@section('content')

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid pt-2">

            <div class="col-md-12">
                <!-- general form elements -->
                <div class="card card-info">

                    <!-- form start -->
                    <form method="GET" action="{{ route('adj.adjledger') }}">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="fromdate">From Date</label>

                                        <div class="input-group date" id="reservationdate2" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#reservationdate2" name="fromdate" id="fromdate"
                                                value="{{ $fromdate }}" placeholder="Form Date" required />
                                            <div class="input-group-append" data-target="#reservationdate2"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>


                                    </div>
                                </div>
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="todate">To Date</label>

                                        <div class="input-group date" id="reservationdate3" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#reservationdate3" name="todate" id="todate"
                                                value="{{ $todate }}" placeholder="To date" required />
                                            <div class="input-group-append" data-target="#reservationdate3"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>


                                    </div>
                                </div>

                                <div class="col-sm-3">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('adj.adjledger') }}" style="margin-top: 30px;"
                                        class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                                </div>

                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- /.card -->

            <div class="row">
                <!-- left column -->
                <div class="col-md-12">

                    <div class="card card-info">
                        <div class="card-header">
                            <h3 class="card-title">Accounts Adjustment Ledger</h3>
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <div class="row mb-2">
                                <div class="col-sm-12">
                                    <button id="excelExport" type="button"
                                        class="btn btn-success btn-sm pro_excel float-right">Excel</button>
                                </div>
                            </div>
                            <div id="table2excel">
                                <table class="table table-bordered table-sm table-striped">
                                    <thead>
                                        <tr>
                                            <th>Duration</th>
                                            <th colspan="5" style="text-align:center;">{{ $fromdate }} TO
                                                {{ $todate }} </th>
                                        </tr>
                                        <tr>
                                            <th>SL</th>
                                            <th>Date</th>
                                            <th>Description</th>
                                            <th>Debit</th>
                                            <th>Credit</th>
                                            <th>Closing Balance</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if (count($accountLedgerData) > 0)
                                            @foreach ($accountLedgerData as $sk => $sv)
                                                @php

                                                    $expId = $sk;

                                                    $expend = Helper::findData('expenditure', ['id' => $expId]);

                                                    if ($expend) {
                                                        $billNo = $expend->billNo;
                                                    } else {
                                                        $billNo = '';
                                                    }

                                                @endphp

                                                <tr>
                                                    <td><b>Bill No:</b> </td>
                                                    <td><b>{{ $billNo }}</b></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                </tr>


                                                @foreach ($accountLedgerData[$expId] as $k => $v)
                                                    @php

                                                        $sl = $v['sl'];
                                                        $date = $v['date'];
                                                        $description = $v['description'];
                                                        $debit_amt = $v['debit_amt'];
                                                        $credit_amt = $v['credit_amt'];
                                                        $clBal = $v['clBal'];

                                                    @endphp

                                                    <tr>
                                                        <td>{{ $sl }}</td>
                                                        <td>{{ $date }}</td>
                                                        <td>{{ $description }}</td>
                                                        <td>{{ $debit_amt }}</td>
                                                        <td>{{ $credit_amt }}</td>
                                                        <td>{{ $clBal }}</td>
                                                    </tr>
                                                @endforeach
                                            @endforeach
                                        @endif

                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
            </div>
            <!-- /.row -->
        </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->

@endsection

@push('scripts')
    <script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

    <script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>

    <script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>


    <script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
    <script src="{{ asset('js/jquery.table2excel.js') }}"></script>

    <script>
        $("#excelExport").click(function() {
            $("#table2excel").table2excel({
                exclude: ".noExl",
                name: "Accounts_Ledgure_Report",
                filename: "Accounts_Ledgure_Report",
                fileext: ".xls"
            });
        });

        $(function() {


            $('#reservationdate2').datetimepicker({
                format: 'DD-MM-YYYY'
            });

            $('#reservationdate3').datetimepicker({
                format: 'DD-MM-YYYY'
            });


            $('.select2').select2()

            $('.select2bs4').select2({
                theme: 'bootstrap4'
            })


            $("#example1").DataTable({
                "pageLength": 100,
                "responsive": true,
                "lengthChange": false,
                "autoWidth": false,
                "searching": false,
                "paging": false,
                buttons: [{
                        extend: 'excel',
                        title: 'Supplier Ledger  \n {{ $fromdate }} TO {{ $todate }}'
                    },
                    {
                        extend: 'pdf',
                        title: 'Supplier Ledger  \n {{ $fromdate }} TO {{ $todate }}'
                    },
                    {
                        extend: 'print',
                        title: 'Supplier Ledger \n {{ $fromdate }} TO {{ $todate }}'
                    },
                    'colvis'
                ]

            }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

            $('#example2').DataTable({
                "paging": true,
                "lengthChange": false,
                "searching": false,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true,
            });

        });
    </script>
@endpush