@extends('layouts.admin')

@section('title', 'Voucher Report')
@section('content-header', '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">{{$title}} || Printed on {{$today}} by {{$by}}</h3>
                            </td>
                        </tr>
                        <tr>
                            <th>Voucher Code</th>
                            <th>Remark</th>
                            <th>Receipt Number</th>
                            <th>Amount (RM)</th>
                            <th>Expiry Date</th>
                            @if($type == 'used')
                                <th>Used Date</th>
                                <th>Used Outlet</th>
                                <th>Counter No</th>
                                <th>Receipt Status</th>
                            @endif
                        </tr>
                        </thead>
                        <tbody>

                        @foreach($data as $vou)
                            <tr>
                                <td>{{ (string)$vou->voucher_code }}</td>
                                <td>{{ $vou->Remark }}</td>
                                <td></td>
                                <td>{{ $vou->voucher_amt }}</td>
                                <td>{{ $vou->exp_date }}</td>
                                @if($type == 'used')
                                    <td>{{ $vou->tran_date }}</td>
                                    <td>{{ $vou->oid }}</td>
                                    <td>{{ $vou->reg }}</td>
                                @endif
                            </tr>
                            @if($type == 'used')
                                @foreach($data3[$i] as $key)
                                    @if($key->sku_id != '')
                                        <tr>
                                            <td></td>
                                            <td></td>
                                            <td>{{ $data2[$i] }}</td>
                                            <td colspan="5">{{ $key->sku_id }} || {{ $key->sku_desc }}</td>
                                            <td>
                                                @if ($key->cancel_flag == 0)
                                                    Success
                                                @elseif ($key->cancel_flag == 1)
                                                    Cancelled
                                                @endif
                                            </td>
                                        </tr>
                                    @else
                                        @if($key->cancel_flag == '0')
                                            @php
                                                $total_success += $vou->voucher_amt;
                                            @endphp
                                        @else
                                            @php
                                                $total_failed += $vou->voucher_amt;
                                            @endphp
                                        @endif
                                    @endif
                                   
                                @endforeach
                                <tr>
                                    <td colspan="11" style="background: black"></td>
                                </tr>
                            @endif
                            @php
                                $total_overall += $vou->voucher_amt;
                                $i++;
                            @endphp
                        @endforeach
                        </tbody>
                        <tfoot>
                        <tr>
                        </tr>
                        <tr>
                            @if($type == 'used')
                                <th>TOTAL USED VOUCHER</th>
                            @else
                                <th>TOTAL AVAILABLE VOUCHER</th>
                            @endif
                            <th></th>
                            <th>{{$i}}</th>
                            <th colspan="12"></th>
                        </tr>  
                        @if($type == 'used')
                        <tr>
                          
                                <th>TOTAL WITH SUCCEED RECEIPT(RM)</th>
                                <th></th>
                                <th>{{ $total_success }}</th>
                            
                            <th colspan="12"></th>
                        </tr>
                        <tr>
                       
                            <th>TOTAL WITH CANCELLED RECEIPT(RM)</th>
                            <th></th>
                            <th>{{$total_failed}}</th>
                            <th colspan="12"></th>
                        </tr>
                        @endif
                        <tr>
                            <th>TOTAL USED AMOUNT (RM)</th>
                                <th></th>
                                <th>{{ $total_overall }}</th>
                                <th colspan="12"></th>
                        </tr>
                        </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 = "{{$title}}.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection