@extends('layouts.admin')

@section('title', 'Item Report')
@section('content-header', 'Item Report')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">{{$title}}</h3>
                    <br>
                    <h3 class="card-title">{{$datetitle}}</h3>
                </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>
                            <th rowspan=2>Method</th>
                            <th colspan=11>Item Detail</th>
                            <th rowspan=2>Gross Sale (RM)</th>
                            <th rowspan=2>Total Percent by Method (%)</th>
                            <th rowspan=2>Branch Gross Sale (RM)</th>


                        </tr>
                        <tr>
                            <th>Name</th>
                            <th>SKUID</th>
                            <th>Category</th>
                            <th>Price (RM)</th>
                            <th>Tax (RM)</th>
                            <th>Quantity</th>
                            <th>Total Item (RM)</th>
                            <!-- <th>Percent (%)</th> -->
                            <th>Total Tax (RM)</th>
                            <!-- <th>Tax Percent (%)</th> -->
                            <th>Total Misc (RM)</th>
                            <!-- <th>Misc Percent (%)</th> -->
                            <th>Overall Total Item (RM)</th>
                            <th>Category Total</th>
                            




                        </tr> 
                        </thead>
                        <tbody>

                        
                        @php
                            $i = 0;
                            $totaloverall = 0;
                            $totaloverallquantity = 0;
                            $totaloveralltax = 0;
                            $totaloverallmisc = 0;
                            $totaloverallbranch = 0;

                        @endphp
                        @foreach ($oid as $branch)
                       
                        <tr>
                            <td colspan="15" style="text-align: center; vertical-align: middle;">
                                <em><strong>{{$branch['BID']}}</strong></em>
                            </td>
                        </tr>
                        
                            @php
                                $k = 0;
                                $b = 0;
                                $totalmethod = 0 ;
                                $totalcategory = 0;
                                $totalmisc = 0;
                                $totaltax = 0;
                                $totaloverallitem = 0;
                                $totalitemwithouttax = 0;
                                $totalquantity = 0;

                            @endphp
                        
                            @foreach ($method as $category)
                                @php
                                    $rows = max($items[$i][$k]->count(), 1);
                                    $previousCno = null;
                                    $l = 0;
                                    $j = 0;
                                    $color = 'white';
                                    

                                @endphp
                                
                            
                                @if (isset($items[$i][$k]) && count($items[$i][$k]) > 0) 
                                    @foreach ($items[$i][$k] as $item)
                                   
                                        <tr>   
                                            @if ($item['cno'] != $previousCno)
                                                <!-- @php
                                                    if ($color == 'lightblue') {
                                                        $color = '#FFCCCC';
                                                    } elseif ($color == '#FFCCCC') {
                                                        $color = 'lightblue';
                                                    }  
                                                @endphp
                                                     -->
                                            @endif
                                            @if ($j == 0)                          
                                                <td rowspan="{{ $rows }}">{{ $category }}</td>
                                            @endif
                                            <td style="background-color: {{$color}};">{{ $item['sku_desc'] ?? 0 }}</td>
                                            <td style="background-color: {{$color}};">{{ $item['sku_id'] ?? 0 }}</td>
                                            <td style="background-color: {{$color}};">{{ $item['cno'] ?? 0 }}</td>
                                            <td style="background-color: {{$color}};">
                                                @if ($item['quantity'] != 0)
                                                    {{number_format(($item['sell_price'] - $item['misctotal'] - $item['tax_amt']) / $item['quantity'],2) }}
                                                @else
                                                    0
                                                @endif
                                            </td>
                                            <td style="background-color: {{$color}};">
                                                @if ($item['quantity'] != 0)
                                                    {{number_format(($item['tax_amt']) / $item['quantity'],2) }}
                                                @else
                                                    0
                                                @endif
                                            </td>
                                            <td style="background-color: {{$color}};">{{ $item['quantity'] ?? 0 }}</td>
                                            <td style="background-color: {{$color}};">{{ number_format($item['sell_price'] - $item['misctotal'] - $item['tax_amt'] ?? 0,2) }}</td>
                                            <!-- <td style="background-color: {{$color}};">
                                                @if ($overallbranch[$i] != 0)
                                                    {{ number_format(100 * (($item['sell_price']- $item['misctotal'] - ($item['tax_amt'] ?? 0)) / $overallbranch[$i]), 2) }}
                                                @else
                                                    0
                                                @endif  
                                            </td> -->
                                            <td style="background-color: {{$color}};">{{ number_format($item['tax_amt'] ?? 0,2) }}</td>
                                            <!-- <td style="background-color: {{$color}};">
                                                @if ($overallbranch[$i] != 0)
                                                    {{ number_format(100 * (($item['tax_amt'] ?? 0) / $overallbranch[$i]), 2) }}
                                                @else
                                                    0
                                                @endif  
                                            </td> -->
                                            
                                            <td style="background-color: {{$color}};">{{ number_format($item['misctotal'] ?? 0,2) }}</td>
                                            <!-- <td style="background-color: {{$color}};">
                                                @if ($overallbranch[$i] != 0)
                                                    {{ $overallbranch[$i] != 0 ? number_format(100 * (($item['misctotal']  ?? 0) / $overallbranch[$i]), 2)  : '0' }}
                                                @else
                                                    0
                                                @endif  
                                            </td> -->
                                            <td style="background-color: {{$color}};">{{ number_format($item['sell_price'] ?? 0,2) }}</td>

                                            @if ($item['cno'] != $previousCno)
                                                <td style="background-color: {{$color}};" rowspan="{{ $categorycount[$i][$k][$l]['item_count'] }}">{{number_format($categorycount[$i][$k][$l]['total'], 2)}}</td>
                                                @php
                                                $totalcategory += $categorycount[$i][$k][$l]['total'];

                                                    $l++;
                                                @endphp
                                            
                                            @endif
                                            @if ($j == 0)
                                                <td rowspan="{{ $rows }}">{{number_format($overallmethod[$i][$k]['sold'],2)}}</td>
                                                <td rowspan="{{ $rows }}">
                                                    @if ($overallbranch[$i] != 0)
                                                        {{ number_format(100 * ($overallmethod[$i][$k]['sold'] / $overallbranch[$i]), 0) }}
                                                    @else
                                                        0%
                                                    @endif
                                                </td>
                                                @php
                                                    $totalmethod += $overallmethod[$i][$k]['sold'];
                                                    $j = 1;
                                                @endphp
                                            @endif
                                            @if ($b == 0)
                                                <td rowspan = {{$totalrow[$i]+1}}>{{number_format($overallbranch[$i],2)}}</td>
                                                @php
                                                    $totaloverallbranch += $overallbranch[$i];
                                                    $b = 1;
                                                @endphp
                                            @endif
                                        </tr>
                                        @php
                                        
                                            $previousCno = $item['cno'];
                                            $totalmisc += $item['misctotal'];
                                            $totaloverallitem += $item['sell_price'];
                                            $totaltax += $item['tax_amt'];
                                            $totalitemwithouttax += $item['sell_price'] - $item['misctotal'] - $item['tax_amt'];
                                            $totalquantity += $item['quantity'];
                                        @endphp
                                    @endforeach
                                  
                                @else
                                    <tr>
                                        <td rowspan="{{ $rows }}">{{ $category }}</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>
                                        <td>-</td>

                                    </tr>
                                    
                                @endif

                                
                                @php
                                    $k++;
                                   

                                @endphp
                               
                            @endforeach
                        @php
                            $i++;
                            $totaloverall += $totalitemwithouttax;

                        @endphp
                        <tr>
                            <td>Overall</td>
                            <td>-</td>
                            <td>-</td>
                            <td>-</td>
                            <td>-</td>
                            <td>-</td>
                            <td>{{$totalquantity}}</td>
                            <td>{{number_format($totalitemwithouttax,2)}}</td>
                            <td>{{number_format($totaltax,2)}}</td>
                            <td>{{number_format($totalmisc,2)}}</td>
                            <td>{{number_format($totaloverallitem,2)}}</td>
                            <td>{{number_format($totalcategory,2)}}</td>
                            <td>{{number_format($totalmethod,2)}}</td>
                            <td>-</td>
                        </tr>
                        <tr>
                            <td colspan="15" style="background-color: black;"></td>
                        </tr>
                            @php
                            $totaloverallquantity += $totalquantity;
                            $totaloveralltax += $totaltax;
                            $totaloverallmisc += $totalmisc;

                            @endphp
                        @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td colspan="15"></td>

                            </tr>

                            <tr>
                                <td>Overal Item (RM)</td>
                                <td>{{number_format($totaloverall,2)}}</td>
                            </tr>
                            <tr>
                                <td>Overall Quantity </td>
                                <td>{{$totaloverallquantity}}</td>
                            </tr>
                            <tr>
                                <td>Overall Tax (RM)</td>
                                <td>{{number_format($totaloveralltax,2)}}</td>
                            </tr>
                            <tr>
                                <td>Overall Misc (RM)</td>
                                <td>{{number_format($totaloverallmisc,2)}}</td>
                            </tr>
                            <tr>
                                <td>Overall Gross Sale (RM)</td>
                                <td>{{number_format($totaloverallbranch,2)}}</td>
                            </tr>
                            

                        </tfoot>

                    </table>


                </div>
            </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 = "ItemReport" + {!! json_encode($datetitle) !!} + ".xlsx";
        XLSX.writeFile(wb, fileName);
    }


</script>
@endsection