@extends('layouts.admin')

@section('title', 'Unlimited Voucher Report')
@section('content-header', 'Unlimited Voucher Report')

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <button onclick="exportToExcel()">Export to Excel</button>
                    </div>


                   
                    <table class="table table-bordered table-striped" id="TABLE1">
                        @php
                            $i = 0;
                            $k = 0;
                            $total_success = 0;
                            $total_failed = 0;
                            $total_overall = 0;
                            $today = date('Y-m-d H:i:s');
                            $by = auth()->user()->getFullname();

                        @endphp
                       
                        <thead>
                        <tr>
                            <td colspan="13">
                                <h3 class="card-title">{{$vform[0]->vForm_no}} Usage Report || Printed on {{$today}} by {{$by}}</h3>
                            </td>
                        </tr>
                       
                        <tr>
                            <th>Voucher Code</th>
                            <th>Amount Used (Q)</th>
                            <th>Total Amount Usage(RM)</th>
                            <th>This Month Usage(RM)</th>

                        
                        </tr>
                        </thead>
                            @foreach($voucher_list as $vou)
                            <tr>
                                <td>
                                    {{$vou['voucher_code']}}
                                </td>
                                <td>
                                    {{$vou['usage'] ?? '-'}}
                                </td>
                                <td>
                                    {{$vou['total'] ?? '-'}}
                                </td>
                                <td>
                                    {{$vou['month_total'] ?? '-'}}
                                </td>

                            </tr>
                            @endforeach
                        <tbody>


                        </tbody>
                        <tfoot>
                       
                       
                    
                        </tfoot>
                        <small style="color:red;">*All Calculation is Based on Voucher Data, Not Receipt</small>
                    </table>
                </div>
                <br>

            </div>
        </div>
    </div>
    </div>
@endsection
@section('js')
    <!-- DataTables  & Plugins -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.1/xlsx.full.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="//cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.6.1/js/dataTables.buttons.min.js"></script>
    <script src="//cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.6.1/js/buttons.html5.min.js"></script>
    <link href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet"/>
    <script>
        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        function exportToExcel() {
            // Get the table element
            var table = document.getElementById("TABLE1");

            // Create a new workbook and sheet
            var wb = XLSX.utils.book_new();
            var ws = XLSX.utils.table_to_sheet(table);

            // Add the sheet to the workbook
            XLSX.utils.book_append_sheet(wb, ws, "Sheet1");

            // Save the workbook as an Excel file
            var fileName = "te.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection