@extends('layouts.admin')

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

<style>
    .btn-hidden {
        display: none !important;
    }
    /*table.dataTable tfoot td {
        border-top: 2px solid #d8dbe0;
    }*/
    table.dataTable thead td {
        border-bottom: 1px solid #d8dbe0;
    }
    table.dataTable.no-footer {
        border-bottom: 1px solid #d8dbe0;
    }
    table.dataTable tfoot td {
        border-top: 1px solid #d8dbe0;
        background-color: white;
    }
    table.dataTable tfoot th {
        border-top: 2px solid #d8dbe0;
    }
    .table-responsive>.table-bordered {
        border: 1px solid #d8dbe0;
    }
</style>

<div class="card no-print">
    <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="row">
                    <!-- Date Filter -->
                    <div class="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>
                    </div>
                    <div class="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>
                    </div>
                    <div class="col-md-3">
                        <button type="button" id="filterDates" class="btn btn-primary mt-4">Filter Dates</button>
                    </div>
                </div>

                <!-- Promoter Selection -->
                <div class="row mt-4">
                    <div class="col-md-4">
                        <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>
                    </div>
                    <div class="col-md-4">
                        <button class="btn btn-success mt-4" type="submit">Generate Report</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 data currently.</p>
    </div>
</div>
@endif

@if (isset($productRecords) && $productRecords->isNotEmpty())
<div class="card">
    <div class="card-header">
        Promoter Commission Reports
    </div>
    <div class="card-body">
        <div id="report-header">
            <p><strong>Outlet Location:</strong> {{ $provinceName }}</p>
            <p><strong>Promoter:</strong> {{ $currentPromoter }}</p>
            <p><strong>Bank Name:</strong> {{ $promoter_bank_name }}</p>
            <p><strong>Account Number:</strong> {{ $promoter_bank_acc }}</p>
        </div>
        @php
            $totalcolspan = $productRecords->unique('product_name')->count() + 4;
            $firstpart = floor($totalcolspan / 2);
            $firstpart = $firstpart - ($firstpart % 3);
            $eachthpart = $firstpart / 3;
            $secondpart = $totalcolspan - $firstpart;

            $groupedTimeEntries = $timeEntriesRecords->groupBy('ptl_id');
            $gtBasic = 0;
            $gtAllowance = 0;
            $gtOutstation = 0;
            $gtOt = 0;
            $gtOthers = 0;
            foreach ($groupedTimeEntries as $ptl_id => $entries) {
                $sumBasic = $entries->sum('basic');

                foreach ($entries as $e => $record) {
                    if ($e === 0) {
                        $sumAllowance = $record->allowance;
                        $sumOutstation = $record->outstation_allowance;
                        $sumOt = $record->ot_allowance;
                        $sumOthers = $record->others;

                        $gtBasic += $sumBasic;
                        $gtAllowance += $sumAllowance;
                        $gtOutstation += $sumOutstation;
                        $gtOt += $sumOt;
                        $gtOthers += $sumOthers;
                        break;
                    }
                }
                $groupedTotals[$ptl_id] = [
                    'allowance' => $sumAllowance,
                    'outstation_allowance' => $sumOutstation,
                    'ot_allowance' => $sumOt,
                    'others' => $sumOthers,
                ];
            }
        @endphp
        <div class="table-responsive">
        <table id="promoterTable" class="table table-bordered" >
            <thead>
                @if($timeEntriesRecords->isNotEmpty())
                    <tr>
                        <th colspan="{{ $totalcolspan }}">Working Hours and Outlet Details</th>
                    </tr>
                    <tr>
                        <th colspan="{{ $eachthpart }}">Dates</th>
                        <th colspan="{{ $eachthpart }}">Time Start</th>
                        <th colspan="{{ $eachthpart }}">Time End</th>
                        <th colspan="{{ $eachthpart }}">Outlet</th>
                        <th colspan="{{ $eachthpart }}">Basic</th>
                        <th colspan="{{ $eachthpart }}">Allowance</th>
                        <th colspan="{{ $eachthpart }}">Outstation Allowance</th>
                        <th colspan="{{ $eachthpart }}">OT Allowance</th>
                        <th>Others</th>
                    </tr>
                    @foreach($groupedTimeEntries as $ptl_id => $entries)
                        @foreach ($entries as $index => $timeEntriesRecord)
                            <tr class="working-hours-row">
                                <td colspan="{{ $eachthpart }}">{{ $timeEntriesRecord->date }}</td>
                                <td colspan="{{ $eachthpart }}">{{ $timeEntriesRecord->time_start }}</td>
                                <td colspan="{{ $eachthpart }}">{{ $timeEntriesRecord->time_end }}</td>
                                <td colspan="{{ $eachthpart }}">{{ $timeEntriesRecord->store_name }}</td>
                                <td colspan="{{ $eachthpart }}" style="vertical-align: middle;">{{ $timeEntriesRecord->basic ?? number_format(0,2) }}</td>

                                @if($index === 0)
                                    <td colspan="{{ $eachthpart }}" rowspan="{{ $entries->count() }}" style="vertical-align: middle;">{{ $timeEntriesRecord->allowance ?? number_format(0,2) }}</td>
                                    <td colspan="{{ $eachthpart }}" rowspan="{{ $entries->count() }}" style="vertical-align: middle;">{{ $timeEntriesRecord->outstation_allowance ?? number_format(0,2) }}</td>
                                    <td colspan="{{ $eachthpart }}" rowspan="{{ $entries->count() }}" style="vertical-align: middle;">{{ $timeEntriesRecord->ot_allowance ?? number_format(0,2) }}</td>
                                    <td rowspan="{{ $entries->count() }}" style="vertical-align: middle;">{{ $timeEntriesRecord->others ?? number_format(0,2) }}</td>
                                {{-- @else
                                    <td colspan="{{ $eachthpart }}" style="display:none;"></td>
                                    <td colspan="{{ $eachthpart }}" style="display:none;"></td>
                                    <td colspan="{{ $eachthpart }}" style="display:none;"></td>
                                    <td style="display:none;"></td> --}}
                                @endif
                            </tr>
                        @endforeach
                    @endforeach
                    <tr>
                        <th colspan="{{ $eachthpart + 3 }}" class="text-right">Total (RM)</th>
                        {{-- Total Basic --}}
                        <th colspan="{{ $eachthpart }}">{{ number_format($gtBasic, 2) }}</th>
                        {{-- Total Allowance --}}
                        <th colspan="{{ $eachthpart }}">{{ number_format($gtAllowance, 2) }}</th>
                        {{-- Total Outstation Allowance --}}
                        <th colspan="{{ $eachthpart }}">{{ number_format($gtOutstation, 2) }}</th>
                        {{-- Total OT Allowance --}}
                        <th colspan="{{ $eachthpart }}">{{ number_format($gtOt, 2) }}</th>
                        {{-- Others --}}
                        <th>{{ number_format($gtOthers, 2) }}</th>
                    </tr>
                @endif
                <tr>
                    <th colspan="{{ $totalcolspan }}">Commission Details</th>
                </tr>
                <tr>
                    <th colspan="{{ $eachthpart }}">No</th>
                    <th colspan="{{ $eachthpart }}">Date</th>
                    @foreach($productRecords->unique('product_name') as $productRecord)
                        <th colspan="{{ $eachthpart }}">{{ $productRecord->product_name }}</th>
                    @endforeach
                    <th colspan="{{ $eachthpart }}">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 colspan="{{ $eachthpart }}">{{ $rowIndex++ }}</td>
                        <td colspan="{{ $eachthpart }}">{{ $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) {
                                    $commissionQty = $record->commission_qty;
                                    $defaultCommission = $record->default_commission;
                                    $newCommission = $record->new_commission;
                                    $commissionStatus = $record->commission_status;
                                    $commissionRate = ($commissionStatus == 1 && $totalQtyPerDay >= $commissionQty) ? $newCommission : $defaultCommission;
                                    $commission = $qty * $commissionRate;
                                    $dailyCommission += $commission;
                                }
                            @endphp
                            <td colspan="{{ $eachthpart }}">{{ $qty > 0 ? $qty : 0 }}</td>
                        @endforeach
                        <td colspan="{{ $eachthpart }}">{{ $totalQtyPerDay }}</td>
                        <td>{{ number_format($dailyCommission, 2) }}</td>
                        @php $grandTotalCommission += $dailyCommission; @endphp
                    </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr>
                    <th colspan="{{ $productRecords->unique('product_name')->count() + 3 }}" class="text-right">Total Commission (RM)</th>
                    <th>{{ number_format($grandTotalCommission, 2) }}</th>
                </tr>
                <tr>
                    <th colspan="{{ $productRecords->unique('product_name')->count() + 3 }}" class="text-right">Total Pay (RM)</th>
                    @php
                        $grandTotalAllowance = $gtAllowance + $gtOutstation + $gtOt + $gtOthers;
                        $grandTotalBasic = $gtBasic;
                        $grandTotalAll = $grandTotalBasic + $grandTotalAllowance + $grandTotalCommission;
                    @endphp
                    <th>{{ number_format($grandTotalAll, 2) }}</th>
                </tr>
            </tfoot>
        </table>
        </div>
        <div class="form-group no-print">
            <br>
            <button class="btn btn-info" onclick="print_preview(); return false;">Print</button>
            <button id="exportExcel" class="btn btn-success">Excel</button>
        </div>
    </div>
</div>
@endif

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.print.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/xlsx-js-style@1.2.0/dist/xlsx.bundle.js"></script>

<script>
    document.addEventListener('DOMContentLoaded', function() {
        const exportBtn = document.getElementById('exportExcel');
        const table = document.getElementById('promoterTable');

        exportBtn.addEventListener('click', function() {
            if (!table) {
                alert("Table not found!");
                return;
            }

            // Get promoter name safely
            const promoterSelect = document.getElementById('promoter');
            const promoterName = promoterSelect && promoterSelect.value
                ? promoterSelect.options[promoterSelect.selectedIndex].text
                : 'unknown_promoter';

            const fileName = 'promoter_commission_reports_' + promoterName.replace(/\s+/g, '_') + '.xlsx';

            // Convert to workbook
            const workbook = XLSX.utils.table_to_book(table, { sheet: "Promoter Commission" });
            const ws = workbook.Sheets["Promoter Commission"];

            // Apply bold to all <th> (supports colspan/rowspan)
            (function boldAllThs(table, ws) {
                if (!table || !ws) return;

                const spans = [];
                const rows = Array.from(table.rows);

                for (let r = 0; r < rows.length; r++) {
                    const row = rows[r];
                    let col = 0;
                    const cells = Array.from(row.cells);

                    for (const cell of cells) {
                        while (spans[col] > 0) col++;

                        const colspan = parseInt(cell.getAttribute("colspan")) || 1;
                        const rowspan = parseInt(cell.getAttribute("rowspan")) || 1;

                        if (cell.tagName.toUpperCase() === "TH") {
                            const addr = XLSX.utils.encode_cell({ r: r, c: col });
                            if (ws[addr]) {
                                ws[addr].s = ws[addr].s || {};
                                ws[addr].s.font = ws[addr].s.font || {};
                                ws[addr].s.font.bold = true;
                            }
                        }

                        if (rowspan > 1) {
                            for (let k = 0; k < colspan; k++) {
                                spans[col + k] = (spans[col + k] || 0) + (rowspan - 1);
                            }
                        }

                        col += colspan;
                    }

                    for (let i = 0; i < spans.length; i++) {
                        if (spans[i] > 0) spans[i]--;
                    }
                }
            })(table, ws);

            // Get sheet range
            const range = XLSX.utils.decode_range(ws['!ref'] || "A1:A1");
          
            // Get the merges (if any)
            const merges = ws["!merges"] || [];

            // Apply borders to existing cells
            Object.keys(ws).forEach(cellAddr => {
                if (cellAddr[0] === "!") return;
                const cell = ws[cellAddr];
                if (!cell.s) cell.s = {};
                cell.s.border = {
                    top:    { style: "thin", color: { rgb: "FF000000" } },
                    bottom: { style: "thin", color: { rgb: "FF000000" } },
                    left:   { style: "thin", color: { rgb: "FF000000" } },
                    right:  { style: "thin", color: { rgb: "FF000000" } }
                };
            });

            // Expand merged cells and apply borders for all merged areas
            merges.forEach(merge => {
                for (let R = merge.s.r; R <= merge.e.r; ++R) {
                    for (let C = merge.s.c; C <= merge.e.c; ++C) {
                        const cellRef = XLSX.utils.encode_cell({ r: R, c: C });
                        if (!ws[cellRef]) ws[cellRef] = { t: "s", v: "" };
                        if (!ws[cellRef].s) ws[cellRef].s = {};
                        ws[cellRef].s.border = {
                            top:    { style: "thin", color: { rgb: "FF000000" } },
                            bottom: { style: "thin", color: { rgb: "FF000000" } },
                            left:   { style: "thin", color: { rgb: "FF000000" } },
                            right:  { style: "thin", color: { rgb: "FF000000" } }
                        };
                    }
                }
            });

            // Download Excel
            XLSX.writeFile(workbook, fileName);
        });
    });
</script>

<script>
    const promoterName = "{{ $currentPromoter ?? 'Unknown Promoter' }}";
    let dataTableInstance = null;

    $(document).ready(function () {
        dataTableInstance = $('#promoterTable').DataTable({
            dom: 'Bfrtip',
            // buttons: [
            //     {
            //         extend: 'excelHtml5',
            //         title: 'Promoter Commission Reports - ' + promoterName,
            //         filename: 'Promoter_Commission_Reports_' + promoterName.replace(/\s+/g, '_'),
            //         className: 'btn-hidden'
            //     }
            // ],
            responsive: true,
            paging: false,
            searching: false,
            ordering: false,
        });

        // // Bind click to custom Excel button
        // $('#exportExcel').click(function () {
        //     dataTableInstance.button('.buttons-excel').trigger();
        // });
    });
</script>
@endsection

@section('scripts')
@parent
<script type="text/javascript">
    function print_preview() {
        const originalTitle = document.title;
        const promoterName = "{{ $currentPromoter ?? 'Unknown Promoter' }}";
        document.title = 'Promoter Commission Report - ' + promoterName;

        window.print();

        // Reset title after print
        setTimeout(() => {
            document.title = originalTitle;
        }, 1000);
    }
</script>
<script>
$(document).ready(function () {
    // Fetch promoters after date filter
    $('#filterDates').click(function () {
        var date_from = $('#date_from').val();
        var date_to = $('#date_to').val();

        if (!date_from || !date_to) {
            alert("Please select both dates.");
            return;
        }

        $.ajax({
            url: "{{ route('admin.promoter-comm-reports.fetchPromoters') }}",
            method: "GET",
            data: { date_from: date_from, date_to: date_to },
            success: function (data) {
                $('#promoter').empty().append('<option value="">Select a Promoter</option>');
                $.each(data, function (key, value) {
                    $('#promoter').append('<option value="' + key + '">' + value + '</option>');
                });
            }
        });
    });
});
</script>
@endsection