@extends('layouts.admin')

@section('title', 'Transaction Detail Report')
@section('content-header', 'Transaction Detail Report')

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">

                    </div>


                    <div class="card-body" style="overflow: auto">
                        <button onclick="exportToExcel()">Export to Excel</button>

                        <table class="table table-bordered table-striped" id="TABLE1">
                            <thead>
                            <tr>
                                <td colspan="13">
                                    @if($toDate)
                                        <h3 class="card-title">POS Transactions {{ $title }} || {{ $fromDate }}
                                            to {{ $toDate }}</h3>
                                    @else
                                        <h3 class="card-title">POS Transactions {{ $title }} 
                                            || {{ $fromDate }}</h3>
                                    @endif
                                </td>
                            </tr>
                            <tr>
                                <th>Type</th>
                                <th>Counter Register No.</th>
                                <th>Date || Time</th>
                                <th>SKU Code || Description</th>
                                <th>Sub Total</th>
                                <th>Total Voucher</th>
                                <th>Overall Receipt Price</th>
                                <th>Overall Item Price</th>
                                <th>Sell Price</th>
                                <th>Tax Amount</th>
                                <th>Quantity</th>
                                <th>Amount</th>
                                <th>Rounding Amount</th>
                                <th>Pay Amount</th>
                                <th>Discount Amount</th>
                                <th>Media Type</th>
                                <th>Status</th>

                            </tr>
                            </thead>
                            <tbody>
                            @php
                                $cancel_count= 0;
                                $count = 0;
                            @endphp
                            @foreach($receipt_data as $receipt)
                            @php
                                
                                if($receipt[0]->extra4 == 'DI'){
                                  $order = 'Dine In';
                                }else if($receipt[0]->extra4 == 'DL'){
                                    if($receipt[0]->extra6 != ''){
                                        $order = 'Delivery by ' . $receipt[0]->extra6;
                                    } else {
                                        $order = 'Default Delivery';
                                    }
                                    
                                }else{
                                  $order = 'Take Away';
                                }
                                $count ++;
                            @endphp
                               
                                <tr>
                                    <td colspan="16">{{$receipt[0]->receipt_no}} || {{$order}}</td>
                                    @if($receipt[0]->cancel_flag == 1)                               
                                        <td >CANCELLED</td>                              
                                    @php
                                        $cancel_count++;
                                    @endphp
                                    @else  
                                        <td >SUCCESS</td>
                                    @endif
                                </tr>
                                
                                @foreach($receipt as $detail)
                                    @php
                                        if($detail->tx_type == 'ST'){
                                          $type = 'Sub Total';
                                          $tax_amount = $detail->total_tax_amt;
                                        }else if($detail->tx_type == 'P'){
                                          $type = 'Item';
                                          $tax_amount = $detail->tax_amt;
                                        }else if($detail->tx_type == 'T'){
                                          $type = 'Tissue';
                                          $tax_amount = $detail->tax_amt;
                                        }else if($detail->tx_type == 'CR'){
                                          $type = 'Cutlery';
                                          $tax_amount = $detail->tax_amt;
                                        }else if($detail->tx_type == 'PS'){
                                          $type = 'Plastic';
                                          $tax_amount = $detail->tax_amt;
                                        }else if($detail->tx_type == 'OF'){
                                          $type = 'Open Float';
                                        }else if($detail->tx_type == 'VC'){
                                          $type = 'Voucher';
                                        }

                                     
                                    @endphp

                                    <td>{{ $type }}</td>
                                    <td>{{ $detail->reg }}</td>
                                    <td>{{ $detail->c_dd }}</td>
                                    <td>{{ $detail->sku_id }} {{$detail->sku_desc}}</td>
                                    <td>{{ $detail->sub_total }}</td>
                                    <td>{{ $detail->voucheramt ?? 0}} </td>
                                    <td>{{ $detail->sub_total +  $detail->voucheramt}}</td>
                                    <td>{{ number_format($detail->sell_price,2)}}</td>
                                    <td>{{ number_format($detail->sell_price - $detail->tax_amt,2)}}</td>
                                    <td>{{ number_format($detail->tax_amt,2) }}</td>
                                    <td>{{ $detail->quantity }}</td>
                                    <td>{{ $detail->amt }}</td>
                                    <td>{{ $detail->rounding }}</td>
                                    <td>{{ $detail->pay_amt }}</td>
                                    <td>{{ $detail->disc_amt }}</td>
                                    <td>{{ $detail->media_type }}</td>
                                    </tr>
                                @endforeach
                            @endforeach
                            </tbody>
                            <tfoot>

                            <tr>
                              <td colspan="13"></td>
                            </tr>
                            <tr>
                                <th></th>
                                <th></th>

                            </tr>
                            <tr>
                                <th>Branch Net Sale (RM)</th>
                                <th></th>
                                <th>{{ number_format( $net_sales, 2) }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Discount (RM)</th>
                                <th></th>
                                <th>{{ $receipt_data2->disc }}</th>
                                <th colspan="12"></th>
                            </tr>

                            <tr>
                                <th>Total Tissue (RM)</th>
                                <th></th>
                                <th>{{ number_format( $tissue, 2) }}</th>
                                <th colspan="12"></th>
                            </tr>

                            <tr>
                                <th>Total Cutlery (RM)</th>
                                <th></th>
                                <th>{{ number_format( $cutlery, 2) }}</th>
                                <th colspan="12"></th>
                            </tr>

                            <tr>
                                <th>Total Plastic (RM)</th>
                                <th></th>
                                <th>{{ number_format( $plastic, 2) }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Tax (RM)</th>
                                <th></th>
                                <th>{{ number_format( $taxdata->tax, 2) }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Grand Total (RM)</th>
                                <th></th>
                                <th>{{ number_format( $net_sales + $taxdata->tax + $plastic + $cutlery +  $tissue,2) }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                              <td colspan="13"></td>
                            </tr>
                            <tr>
                                <th>Total Item Quantity</th>
                                <th></th>
                                <th>{{ $receipt_data2->quantity}}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Tissue (Quantity)</th>
                                <th></th>
                                <th>{{ $receipt_data2->tissue ?? 0 }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Cutlery (Quantity)</th>
                                <th></th>
                                <th>{{ $receipt_data2->cutlery ?? 0 }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Plastic (Quantity)</th>
                                <th></th>
                                <th>{{ $receipt_data2->plastic ?? 0 }}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Receipt</th>
                                <th></th>
                                <th>{{ $count}}</th>
                                <th colspan="12"></th>
                            </tr>
                            <tr>
                                <th>Total Cancelled Receipt</th>
                                <th></th>
                                <th>{{ $cancel_count }}</th>
                                <th colspan="12"></th>
                            </tr>
                            </tfoot>
                        </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 = "TransactionDetailReport.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection