@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') }}">
    
    <link rel="stylesheet" href="{{ asset('plugins/jquery-ui/jquery-ui.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/jquery-ui/jquery-ui.theme.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('accpl.summary') }}">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-sm-2">
                                    <div class="form-group">
                                        
                                        <label for="product_id">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-2">
                                    <div class="form-group">
                                        <label for="product_id">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-2">
                                    <div class="form-group">
                                        <label>Branch</label>

                                        <select id="branch_id" name="branch_id" class="form-control form-control-sm" style="width: 100%;">
                                            <option value="">Select Branch</option>

                                            @foreach($branchs as $v)
                                            <option value="{{ $v->id }}" {{ $branch_id == $v->id?'selected':''}} >{{ $v->outlet_name }}</option>
                                            @endforeach

                                        </select>

                                    </div>
                                </div>


                                <div class="col-sm-2">
                                    <label>Account Head Name</label>
                                    <input type="text" id="account_head" class="form-control form-control-sm" value="">
                                    <input type="hidden" name="accountId" id="accountId" value="">
                                    <input type="hidden" id="accountType" value="">

                                </div>


                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label>Report Type</label>
                                        <select id="report_type" name="report_type" class="form-control form-control-sm" style="width: 100%;">
                                            <option value="details" {{ $report_type == 'details'?'selected':''}} >Details</option>
                                            <option value="summary" {{ $report_type == 'summary'?'selected':''}} >Summary</option>
                                        </select>

                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('accpl.summary') }}" style="margin-top: 30px;"
                                        class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                                </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">
                            <div class="row">
                            <div class="col-sm-6"> <h3 class="card-title">Account Ledger Report</h3> </div>
                            <div class="col-sm-6 text-right"> 
                                <button id="excelExport" type="button" class="btn btn-success btn-sm pro_excel float-right">Excel</button> 
                            </div>
                                
                            </div>
                            
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <div class="row">
                                <div class="col-sm-12">
                                    <div id="table2excel">
                                        @php
                                            $debitTotal = $totals['debit'] ?? 0;
                                            $creditTotal = $totals['credit'] ?? 0;
                                            $grossProfit = $grossProfit ?? 0;
                                        @endphp

                                        <table class="table table-bordered table-sm table-striped">
                                            <thead class="thead-dark">
                                                @if($report_type == 'details')
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Branch</th>
                                                    <th>Voucher No</th>
                                                    <th>Particular</th>
                                                    <th class="text-right">Expense </th>
                                                    <th class="text-right">Income </th>
                                                    <th class="text-right">Balance (Income - Expense)</th>
                                                </tr>
                                                @endif
                                                @if($report_type == 'summary')
                                                <tr>
                                                    <th>Particular</th>
                                                    <th class="text-right">Expense </th>
                                                    <th class="text-right">Income </th>
                                                    <th class="text-right">Balance (Income - Expense)</th>
                                                </tr>
                                                @endif
                                            </thead>
                                                <tbody>
                                                    @php
                                                        $balance = 0;
                                                        $totalDebit = 0;
                                                        $totalCredit = 0;
                                                    @endphp

                                                    @foreach($ledgerData as $entry)
                                                        @php
                                                            $date = $entry->entry_date ?? '-';
                                                            $voucher = $entry->voucher_no ?? '-';
                                                            $outlet_name = $entry->outlet_name ?? '-';
                                                            $accountName = $entry->account_name ?? '-';
                                                            $debit = (float) ($entry->debit_amount ?? 0);
                                                            $credit = (float) ($entry->credit_amount ?? 0);

                                                            $balance += ($credit - $debit);
                                                            $totalDebit += $debit;
                                                            $totalCredit += $credit;
                                                        @endphp

                                                         @if($report_type == 'details')

                                                        <tr>
                                                            <td>{{ ($date!='-')?Helper::dateFormate($date):'-' }}</td>
                                                            <td>{{ $outlet_name }}</td>
                                                            <td>{{ $voucher }}</td>
                                                            <td>{{ $accountName }}</td>
                                                            <td style="text-align:right;">{{ number_format($debit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($credit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($balance, 2) }}</td>
                                                        </tr>

                                                        @endif

                                                         @if($report_type == 'summary')

                                                            <tr>
                                                                <td>{{ $accountName }}</td>
                                                                <td style="text-align:right;">{{ number_format($debit, 2) }}</td>
                                                                <td style="text-align:right;">{{ number_format($credit, 2) }}</td>
                                                                <td style="text-align:right;">{{ number_format($balance, 2) }}</td>
                                                            </tr>

                                                          @endif

                                                    @endforeach

                                                     @if($report_type == 'details')
                                                        <!-- Grand Total Row -->
                                                        <tr style="font-weight: bold; background-color: #f0f0f0;">
                                                            <td colspan="4" style="text-align:right;">Grand Total</td>
                                                            <td style="text-align:right;">{{ number_format($totalDebit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($totalCredit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($balance, 2) }}</td>
                                                        </tr>

                                                     @endif

                                                     @if($report_type == 'summary')
                                                        <!-- Grand Total Row -->
                                                        <tr style="font-weight: bold; background-color: #f0f0f0;">
                                                            <td style="text-align:right;">Grand Total</td>
                                                            <td style="text-align:right;">{{ number_format($totalDebit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($totalCredit, 2) }}</td>
                                                            <td style="text-align:right;">{{ number_format($balance, 2) }}</td>
                                                        </tr>

                                                     @endif

                                                </tbody>
                                        </table>

                                    </div>
                                    
                                </div>
                            </div>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!--/.col (left) -->
                <!-- right column -->
                <div class="col-md-6">

                </div>
                <!--/.col (right) -->
            </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: "Suplier_Ledgure_Report",
                filename: "Suplier_Ledgure_Report",
                fileext: ".xls"
            });
        });

        $(function() {

            $("#account_head").val('');
            $("#accountId").val('');
            $("#accountType").val('');

            $("#account_head").autocomplete({
                source: function(request, response) {
                    $.ajax({
                        url: "{{ route('acchead.search') }}", // your route URL, example: /search-product
                        dataType: "json",
                        data: {
                            account_name: request.term
                        },
                        success: function(data) {
                            response($.map(data, function(item) {
                                return {
                                    label: item.account_name,
                                    value: item.account_name,
                                    id: item.id,
                                    account_type: item.account_type,
                                };
                            }));
                        }
                    });
                },
                minLength: 2,
                select: function(event, ui) {

                    $('#accountId').val(ui.item.id);
                    $('#accountType').val(ui.item.account_type);

                    $("#amount").select();
                    $("#amount").focus();

                    let crdr_txt = '';

                    let cr_or_dr = $("#cr_or_dr").val();

                    if (cr_or_dr === 'Cr') {

                       crdr_txt = 'Cr. ';
                     
                    } else if (cr_or_dr === 'Dr') {

                       crdr_txt = 'Dr. ';
                      
                    }else{
                        return false;
                    }

                    $("span#crdr_txt").html(crdr_txt);


                }
            });


            $(document).on('keydown', 'input', function(event) {

              if (event.key === "Enter" || event.keyCode === 13) {

                event.preventDefault();

              }

            });








            $('#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