@extends('layouts.admin')

@section('content')
@if(Session::has('error_message'))
    <div class="alert alert-danger">
        {{ Session::get('error_message')}}
    </div>
@endif

<div class="card">
    <div class="card-header">
        Promoter Commission Reports
    </div>
    <div class="card-body">
        <div class="form-group no-print">
            <form action="{{ route('admin.promoter-comm-reports.filterCommReport') }}" method="GET">
                <div class="form-row d-flex">
                    <div class="col-12 col-md-3">
                        <label class="required" for="employee">Promoter :</label>
                        <select class="form-control select2" name="promoter" id="promoter">
                            <option value="0" hidden>Select a promoter</option>
                            @foreach($promoters as $id => $promoter_name)
                                <option value="{{ $id }}" {{ request()->input('promoter') == $id ? 'selected' : '' }}>{{ $promoter_name }}</option>
                            @endforeach
                        </select>
                        @if($errors->has('employee'))
                            <div class="invalid-feedback">
                                {{ $errors->first('employee') }}
                            </div>
                        @endif
                    </div>
                    <div class="col-12 col-md-3">
                        <label class="required" for="date_from">Date From</label>
                        <input class="form-control date {{ $errors->has('date_from') ? 'is-invalid' : '' }}" type="text" name="date_from" id="date_from" value="{{ old('date_from', request()->input('date_from')) }}" required>
                        @if($errors->has('date_from'))
                            <div class="invalid-feedback">
                                {{ $errors->first('date_from') }}
                            </div>
                        @endif
                    </div>
                    <div class="col-12 col-md-3">
                        <label class="required" for="date_to">Date To</label>
                        <input class="form-control date {{ $errors->has('date_to') ? 'is-invalid' : '' }}" type="text" name="date_to" id="date_to" value="{{ old('date_to', request()->input('date_to')) }}" required>
                        @if($errors->has('date_to'))
                            <div class="invalid-feedback">
                                {{ $errors->first('date_to') }}
                            </div>
                        @endif
                    </div>
                    {{-- <div class="col-12 col-md-3">
                        <label class="required" for="month">Month :</label>
                        <select class="form-control select2" name="month" id="month">
                            <option value="0" hidden>Select a month</option>
                            @foreach($getMonths as $mid => $month_value)
                                <option value="{{ $mid }}" {{ request()->input('month') == $mid ? 'selected' : '' }}>{{ $month_value }}</option>
                            @endforeach
                        </select>
                    </div> --}}
                    <div class="col-12 col-md-2" style="align-content: end;">
                        <button class="btn btn-success d-inline-block mt-2" type="submit">Filter</button>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>

@if ($productRecords->isEmpty())
<div class="card">
    <div class="card-body no-print">
        <p class="text-center">There is no any data currently.</p>
    </div>
</div>
@endif

@if (isset($productRecords) && $productRecords->isNotEmpty())
<div class="card">
    <div class="card-body">
        <div class="print-only">
            <div class="form-group">
                <div class="table-responsive">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Outlet Location</th>
                                <th>Promoter</th>
                                <th>Bank Name</th>
                                <th>Account Number</th>
                                <th>Total Basic</th>
                                <th>Allowance</th>
                                <th>Total Comm</th>
                            </tr>
                        </thread>
                        <tbody>
                            <tr>
                                <td>{{ $provinceName }}</td>
                                <td>{{ $currentPromoter }}</td>
                                <td>{{ $promoter_bank_name }}</td>
                                <td>{{ $promoter_bank_acc }}</td>
                                <td></td>
                                <td></td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-body">
        <div class="print-only">
            <div class="form-group">
                <div class="table-responsive">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th colspan="3" class="text-center">Working Hours</th>
                                <th rowspan="2" class="text-center table-cell align-middle">Outlet</th>
                            </tr>
                            <tr>
                                <th>Dates</th>
                                <th>Time Start</th>
                                <th>Time End</th>
                            </tr>
                        </thread>
                        <tbody>
                            @foreach ($timeEntriesRecords as $timeEntriesRecord)
                                <tr>
                                    <td>{{ $timeEntriesRecord->date }}</td>
                                    <td>{{ $timeEntriesRecord->time_start }}</td>
                                    <td>{{ $timeEntriesRecord->time_end }}</td>
                                    <td>{{ $timeEntriesRecord->store_name }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-body">
        <div class="print-only">
            <div class="form-group">
                <div class="table-responsive">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th colspan="2" class="text-center">{{ $currentPromoter }}</th>
                            </tr>
                            <tr>
                                <th colspan="2" class="text-center">{{ $provinceName }}</th>
                            </tr>
                            <tr>
                                <th>No</th>
                                <th>Date</th>
                                @foreach($productRecords->unique('product_name') as $productRecord)
                                    <th>{{ $productRecord->product_name }}</th>
                                @endforeach
                                <th>Daily Total Qty</th>
                                <th>Daily Commission (RM)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $rowIndex = 1;
                                $grandTotalCommission = 0;
                            @endphp
                            @foreach ($productRecords->groupBy('created_at') as $date => $recordsForDate)
                                @php
                                    $totalQtyPerDay = $recordsForDate->sum('total_s_qty');
                                    $dailyCommission = 0;
                                @endphp
                                <tr>
                                    <td>{{ $rowIndex++ }}</td>
                                    <td>{{ $date }}</td>
                                    @foreach ($productRecords->unique('product_name') as $productRecord)
                                        @php 
                                            $record = $recordsForDate->firstWhere('product_name', $productRecord->product_name);
                                            $qty = $record ? $record->total_s_qty : 0;

                                            if($record) {
                                                // Pull commission fields from the product master
                                                $commissionQty       = $record->commission_qty;       // e.g. 15
                                                $defaultCommission   = $record->default_commission;   // e.g. 1.00
                                                $newCommission       = $record->new_commission;       // e.g. 2.00
                                                $commissionStatus    = $record->commission_status;    // e.g. 1 (active) or 0 (inactive)

                                                // Determine commission rate
                                                if ($commissionStatus == 1 && $totalQtyPerDay >= $commissionQty) {
                                                    $commissionRate = $newCommission;
                                                } else {
                                                    $commissionRate = $defaultCommission;
                                                }

                                                // Calculate commission
                                                $commission = $qty * $commissionRate;
                                                $dailyCommission += $commission;
                                            }
                                        @endphp
                                        <td>{{ $qty > 0 ? $qty : '' }}</td>
                                    @endforeach
                                    <td>{{ $totalQtyPerDay }}</td>
                                    <td>{{ number_format($dailyCommission, 2) }}</td>
                                    @php $grandTotalCommission += $dailyCommission; @endphp
                                </tr>
                            @endforeach
                            <tr>
                                <td colspan="{{ $productRecords->unique('product_name')->count() + 3 }}" class="text-right"><strong>Total Commission (RM)</strong></td>
                                <td><strong>{{ number_format($grandTotalCommission, 2) }}</strong></td>
                            </tr>
                        </tbody>
                        <tfoot>
<!--                             <tr>
                                <th colspan="2" class="text-center">Comm</th>
                                <td></td>
                            </tr> -->
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>

        <div class="form-group no-print">
            <button class="btn btn-info" onclick="print_preview(); return false;">Print</button>
        </div>
    </div>
</div>
@endif

@endsection

@section('scripts')
@parent
<script type="text/javascript">
    function print_preview()
    {
        window.print();
    }
</script>
@endsection