@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('report.supledger') }}">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-sm-3">
                                <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-3">
                                <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-3">
                                <div class="form-group">
                                    <label for="product_id">Supplier</label>

                                    <select id="supplier_id" name="supplier_id"
                                        class="form-control form-control-sm select2" value="{{ old('supplier_id') }}"
                                        style="width: 100%;">
                                        <option value="">All</option>
                                        @foreach ($suppliers as $v)
                                        <option value="{{ $v->id }}">{{ $v->supplier_name }}</option>
                                        @endforeach

                                    </select>


                                </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('report.supledger') }}" 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">
                        <h3 class="card-title">Supplier Ledger</h3>
                    </div>




                    <!-- /.card-header -->
                    <div class="card-body">
                        <div class="row mb-2">
                            <div class="col-sm-12">
                                <button id="pdfExport" type="button" class="btn btn-danger btn-sm float-right mr-">PDF</button>
                                <button id="excelExport" type="button"
                                    class="btn btn-success btn-sm pro_excel float-right mr-3">Excel</button>
                            </div>
                        </div>

                        <div style="text-align: center; margin-bottom: 3;">
                            <h4>Shalimar Kitchen</h4>
                            <address>
                                <strong>Ramarbagh, Kutubpur, Fatullah, Narayanganj </strong><br>
                                Mobile No:01711-886946, 01711886947<br>

                            </address>
                            <h4><b>Supplier Name : {{ $supName }}</b></h4>

                        </div>
                        <div id="table2excel">
                            <table class="table table-bordered table-sm table-striped">
                                <thead>
                                    <!-- <tr>
                                        <th>Period</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>
                                    @php

                                    $g_total_debit_amt = 0;
                                    $g_total_cedit_amt = 0;

                                    @endphp

                                    @if (count($supLedgerData) > 0)
                                    @foreach ($supLedgerData as $sk => $sv)
                                    @php

                                    $supplier_id = $sk;

                                    $sup = Helper::findData('suppliersetup', ['id' => $supplier_id]);

                                    if ($sup) {
                                    $supplier_name = $sup->supplier_name;
                                    } else {
                                    $supplier_name = '';
                                    }

                                    @endphp


                                    <tr>
                                        <td>Supplier Name: </td>
                                        <td>{{ $supplier_name }}</td>
                                        <td></td>
                                        <td></td>
                                        <td></td>

                                        <td></td>
                                    </tr>


                                    @php

                                    $total_debit_amt = 0;
                                    $total_cedit_amt = 0;

                                    @endphp

                                    @foreach ($supLedgerData[$supplier_id] 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'];

                                    $total_debit_amt = $total_debit_amt + $debit_amt;
                                    $total_cedit_amt = $total_cedit_amt + $credit_amt;

                                    $g_total_debit_amt = $g_total_debit_amt + $debit_amt;
                                    $g_total_cedit_amt = $g_total_cedit_amt + $credit_amt;


                                    @endphp

                                    <tr>
                                        <td>{{ $sl }}</td>
                                        <td>{{ $date }}</td>
                                        <td>{{ $description }}</td>
                                        <td>{{ $debit_amt }}</td>
                                        <td>{{ $credit_amt }}</td>

                                        <td>{{ $clBal }}</td>
                                    </tr>
                                    @endforeach


                                    <tr>
                                        <td colspan="3" style="text-align:right;">Total</td>
                                        <td>{{ $total_debit_amt }}</td>
                                        <td>{{ $total_cedit_amt }}</td>

                                        <td></td>
                                    </tr>



                                    @endforeach



                                    <tr>
                                        <td colspan="3" style="text-align:right;">Grand Total</td>
                                        <td>{{ $total_debit_amt }}</td>
                                        <td>{{ $total_cedit_amt }}</td>

                                        <td></td>
                                    </tr>




                                    @endif

                                </tbody>
                            </table>
                        </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="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.28/jspdf.plugin.autotable.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"
        });
    });

    $("#pdfExport").click(function() {
        const {
            jsPDF
        } = window.jspdf;
        const doc = new jsPDF('p', 'pt', 'a4'); // portrait, A4 page

        const pageWidth = doc.internal.pageSize.getWidth();

        // === Header / Title Section ===
        doc.setFont("helvetica", "bold");
        doc.setFontSize(16);
        doc.text("Shalimar Kitchen", pageWidth / 2, 40, {
            align: "center"
        });

        doc.setFont("helvetica", "normal");
        doc.setFontSize(12);
        doc.text("Supplier Ledger Report", pageWidth / 2, 60, {
            align: "center"
        });

        // --- Supplier Name + Date Range ---
        const supplierName = "{{ $supplier_name ?? 'All Supplier' }}";
        const fromDate = "{{ $fromdate }}";
        const toDate = "{{ $todate }}";

        doc.setFontSize(10);
        doc.text(`Supplier: ${supplierName}`, pageWidth / 2, 75, {
            align: "center"
        });
        doc.text(`Period: ${fromDate} to ${toDate}`, pageWidth / 2, 90, {
            align: "center"
        });

        // === Table Content ===
        doc.autoTable({
            html: '#table2excel table',
            startY: 110,
            styles: {
                fontSize: 8
            },
            headStyles: {
                fillColor: [41, 128, 185]
            },
            margin: {
                left: 40,
                right: 40
            },
            theme: 'striped',
        });

        // === Footer (optional) ===
        const pageHeight = doc.internal.pageSize.getHeight();
        doc.setFontSize(8);
        doc.text("Generated by Shalimar Kitchen Accounting System", pageWidth / 2, pageHeight - 20, {
            align: "center"
        });

        // === Save PDF ===
        doc.save(`Supplier_Ledger_Report_${supplierName}.pdf`);
    });




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