@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('saleres.pwvat') }}">
                        <div class="card-body">
                            <div class="row">

                                <div class="col-md-2 col-sm-4">
                                    <div class="form-group">
                                        <label for="formdate">From Date</label>
                                        <div class="input-group date" id="formdate" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#formdate" name="formdate" id="formdate"
                                                value="{{ $formdate }}" placeholder="Enter From Date" required />
                                            <div class="input-group-append" data-target="#formdate"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

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

                                    </div>
                                </div>

                                    {{-- Category --}}
                                    <div class="col-md-2 col-sm-4 d-none">
                                        <div class="form-group">
                                            <label for="cat_id">Category:</label>
                                            <select id="cat_id" name="cat_id" class="form-control form-control-sm select2">
                                                <option value="">Select Category</option>
                                                @foreach($categories as $v)
                                                    <option value="{{ $v->id }}" {{ old('cat_id', $cat_id ?? '') == $v->id ? 'selected' : '' }}>
                                                        {{ $v->cat_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                            @error('cat_id')
                                                <span class="error invalid-feedback">{{ $message }}</span>
                                            @enderror
                                        </div>
                                    </div>

                                <div class="col-md-2 col-sm-4">
                                    <div class="form-group">
                                        <label for="outlet_id">Outlet</label>
                                        <select id="outlet_id" name="outlet_id" class="form-control form-control-sm select2"
                                            style="width: 100%;">
                                            <option value="">Select Outlet</option>
                                            @foreach ($outlets as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($outlet_id) && $outlet_id == $v->id ? 'selected' : '' }}>
                                                    {{ $v->id }} - {{ $v->outlet_name }}</option>
                                            @endforeach

                                        </select>

                                    </div>
                                </div>

                                <div class="col-md-2 col-sm-4 d-none">
                                    <div class="form-group">
                                        <label for="client_id">Corporate Client</label>
                                        <select id="client_id" name="client_id" class="form-control form-control-sm select2"
                                            style="width: 100%;">
                                            <option value="">Select Outlet</option>
                                            @foreach ($corporateClients as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ $v->id == $client_id ? 'selected' : '' }}>
                                                    {{ $v->company_name }}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-2 col-sm-4 d-none">
                                    <div class="form-group">
                                        <label for="customer_id">Customer</label>
                                        <select id="customer_id" name="customer_id" class="form-control form-control-sm select2"
                                            style="width: 100%;">
                                            <option value="">Select Customer</option>
                                            @foreach ($customers as $v)

                                                @if(isset($v->customermobile) && strlen($v->customermobile) == 11)

                                                <option value="{{ $v->id }}" {{ $v->id == $customer_id ? 'selected' : '' }}>
                                                    {{ $v->customername }} ({{ $v->customermobile }})
                                                </option>

                                                @endif

                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div  class="col-md-2 col-sm-4 d-none">
                                    <div class="form-group">
                                        <label for="product_id">Invoice No</label>

                                        <input type="text" class="form-control form-control-sm" name="invoiceno"
                                            id="invoiceno" value="{{ $invoiceno }}" placeholder="Enter Invoiceno" />

                                    </div>
                                </div>

                                <div class="col-md-2 col-sm-4 d-none">
                                    <div class="form-group">
                                        <label for="trans_type"> Sale Type </label>
                                        <select id="trans_type" name="trans_type" value="{{ $trans_type }}"
                                            class="form-control form-control-sm" style="width: 100%;">
                                            <option value="1" selected>Normal</option>
                                            <option value="2">Complementary</option>
                                        </select>

                                    </div>
                                </div>


                                <div class="col-md-2 col-sm-4">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-primary btn-sm btn_mt">Search</button>
                                    <a href="{{ route('saleres.pwvat') }}" style="margin-top: 30px;"
                                        class="btn btn-secondary btn-sm 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">Category Wise Vat Report</h3>

                            <div>
                                <button id="download-excel" class="btn btn-sm btn-primary float-right m-1">Excel</button>
                                <button style="float: right;" class="btn btn-primary btn-sm m-1" id="print_div">Print</button>
                            </div>

                        </div>
                        <!-- /.card-header -->
                        <div class="card-body" id="print_ariea">
                            <div class="row">
                                <div class="col-md-12">
                                <div class="table-responsive" id="exportToExcel">


                                    <table class="table table-bordered table-striped d-print-table">
                                       <thead class="table-dark">

                                            <tr>
                                                <th colspan="9" class="text-center" style="background: #fff; color: #000;">
                                                    <h3>Category Wise Vat Report</h3>
                                                    <p style="margin-bottom:1px;"><b>Branch Name:</b> {{ $outlet_name }}</p>
                                                    <p style="margin-bottom:1px;"><b>VAT Registration No:</b> {{ $vat_reg_no_new }}</p>
                                                    <p style="margin-bottom:1px;"><b>Date Range:</b> {{ Helper::dateFormate($formdate) }} TO {{ Helper::dateFormate($todate) }}</p>
                                                    <p style="margin-bottom:1px;"><b>Print Date & Time:</b> {{ now()->setTimezone('Asia/Dhaka')->format('d-m-Y h:i:s A') }}</p>
                                                </th>
                                            </tr>

                                            <tr>
                                                <th>SL</th>
                                                <th>Date</th>
                                                <th>Catogory</th>
                                                <th style="text-align:center;">Vat Rate</th>
                                                <th style="text-align:center;">SD Rate</th>
                                                <th style="text-align:right;">Sale Amt.</th>
                                                <th style="text-align:right;">VAT Amt.</th>
                                                <th style="text-align:right;">SD Amt.</th>
                                                <th style="text-align:right;">Dis Amt.</th>

                                            </tr>
                                        </thead>
                                        <tbody>

                                            @php

                                                $sl = 1;

                                                $totalQty = 0;
                                                $totaAmt = 0;
                                                $totaDisAmt = 0;
                                                $totaSaleAftDisAmt = 0;

                                                $total_sd = 0;
                                                $total_vat = 0;

                                            @endphp

                                            @if (count($saleInfo) > 0)
                                                @foreach ($saleInfo as $k => $v)
                                                    @php

                                                        $totalQty = $totalQty + $v->quantity;
                                                        $totaAmt = $totaAmt + $v->amount;

                                                        $dis_amt = $v->dis_amt;

                                                        $aft_dis = $v->amount - $dis_amt;

                                                        $totaDisAmt = $totaDisAmt + $dis_amt;

                                                        $totaSaleAftDisAmt = $totaSaleAftDisAmt + $aft_dis;

                                                        $total_sd = $total_sd + $v->sd_amt;
                                                        $total_vat = $total_vat + $v->vat_amt;

                                                    @endphp

                                                    <tr>
                                                        <td>{{ $sl++ }}</td>
                                                        <td>{{ Helper::dateFormate($v->sale_date) }}</td>
                                                        <td>{{ $v->cat_name }}</td>
                                                        <td style="text-align:center;">{{ $v->vat_persent??0 }}</td>
                                                        <td style="text-align:center;">{{ $v->sd_persent??0 }}</td>
                                                        <td style="text-align:right;">{{ $v->amount }}</td>
                                                        <td style="text-align:right;">{{ $v->vat_amt }}</td>
                                                        <td style="text-align:right;">{{ $v->sd_amt }}</td>
                                                        <td style="text-align:right;">{{ $v->dis_amt }}</td>


                                                    </tr>
                                                @endforeach

                                                <tr>
                                                    <td colspan="5" style="text-align: right;"><b>Total</b></td>
                                                    <td style="text-align:right;"><b>{{ $totaAmt }}</b></td>
                                                    <td style="text-align:right;"><b>{{ $total_vat }}</b></td>
                                                    <td style="text-align:right;"><b>{{ $total_sd }}</b></td>
                                                    <td style="text-align:right;"><b>{{  $totaDisAmt }} </b></td>

                                                </tr>
                                                <tr>
                                                    <td colspan="8" style="text-align: right;"> <b>Summary</b></td>
                                                    <td>

                                                    </td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total Sale Trans.</b></td>
                                                    <td style="text-align:right;"><b>{{ $saleSummery->trans }}</b></td>
                                                </tr>


                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total Sale Amount.</b></td>
                                                    <td style="text-align:right;"><b>{{ $totaAmt }}</b></td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total Discount.</b></td>
                                                    <td style="text-align:right;"><b>{{ $totaDisAmt }}</b></td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>After Discount.</b></td>
                                                    <td style="text-align:right;"><b>{{ $totaAmt - $totaDisAmt }}</b></td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total SD.</b></td>
                                                    <td style="text-align:right;"><b>{{ $total_sd }}</b></td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total Vat.</b></td>
                                                    <td style="text-align:right;"><b>{{ $total_vat }}</b></td>
                                                </tr>

                                                <tr>
                                                    <td colspan="8" style="text-align:right;"><b>Total Sale Amount (After SD & VAT).</b></td>
                                                    <td style="text-align:right;"><b>{{ $totaAmt - ($total_sd + $total_vat) }}</b></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('plugins/select2/js/select2.full.min.js') }}"></script>


<script src="https://cdn.jsdelivr.net/gh/rainabba/jquery-table2excel/dist/jquery.table2excel.min.js"></script>


    <script>



function printSlip() {
    let dataHtm = document.getElementById('print_ariea').innerHTML;

    var mywindow = window.open('', 'Invoice Print', 'height=600,width=400');
    mywindow.document.write(`<!DOCTYPE html>
<html>
<head>
    <title>Invoice Print</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">

    <style>
        /* Fix Bootstrap table border issues during print */
        table {
            width: 100%;
            border-collapse: collapse !important;
        }
        th, td {
            border: 1px solid #000 !important;
            padding: 3px !important;
            font-size: 11pt;
            color: #000 !important;
            background-color: #fff !important;
        }
        th {
            font-weight: bold;
            font-size: 12pt;
        }

        /* Optional: Hide border from header table wrapping only <th> */
        table thead tr th > div {
            border: none !important;
        }

        @media print {
            body {
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }

            .hide_print{
                display:none;
            }
        }
    </style>

</head>
<body>
    <div id="slip-content">
        ${dataHtm}
    </div>
</body>
</html>`);

    mywindow.document.close();
    mywindow.focus();

    setTimeout(function () {
        mywindow.print();

        setTimeout(function () {
            var content = mywindow.document.getElementById('slip-content').innerHTML;
            mywindow.document.getElementById('slip-content').innerHTML = content;

            setTimeout(function () {
                mywindow.close();
            }, 1000);
        }, 1000);
    }, 1000);
}


        $(function() {

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

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

            $('.select2').select2()

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


            $("#print_div").click(function(e) {
                e.preventDefault();

                printSlip();


            });

$("#download-excel").click(function () {
    // Get Bangladesh time
    const now = new Date().toLocaleString("en-GB", {
        timeZone: "Asia/Dhaka",
        hour12: true
    });

    // Parse date and time parts
    const [dateStr, timeStrRaw] = now.split(", ");
    const [day, month, year] = dateStr.split("/");
    const timeStr = timeStrRaw.replace(/:/g, "").replace(" ", "");

    // Dynamic parts
    const reportTitle = `Categories Wise Vat Report (${day}-${month}-${year})`;
    const fileName = `Categories_Wise_Vat_Report_${day}_${month}_${year}_${timeStr}.xls`;

    $("#exportToExcel").table2excel({
        exclude: ".noExl",
        name: reportTitle,   // Dynamic sheet name
        filename: fileName,  // Dynamic filename
        fileext: ".xls",
        exclude_img: true,
        exclude_links: true,
        exclude_inputs: true
    });
});



            $("#example1").DataTable({
                "responsive": true,
                "lengthChange": false,
                "autoWidth": false,
                "paging": false,
                buttons: [{
                        extend: 'excel',
                        title: 'Product List'
                    },
                    {
                        extend: 'pdf',
                        title: 'Product List'
                    },
                    {
                        extend: 'print',
                        title: 'Product List'
                    },
                    'colvis'
                ]

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

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

        });
    </script>
@endpush