@extends('layouts.app')

@section('content')
    @include('pages.mrp.partials.menu')
    <div class="row">
        <div class="card">
            <div class="card-header">
                <div class="d-flex justify-content-between align-items-center">
                    <div class="">
                        <h4>Material Requirement Planning (PO General)</h4>
                        <p class="f-m-light mt-1">
                            This feature will calculate all of you materials needed for consumable based on your Stock, Purchase Request,
                            and PO General start from <b>Your Required Start Date below</b> to <b>Required End Date below.
                            </b>
                        </p>
                        <p>If not set, it will automatically set from <b>Today</b> to <b>a Month</b></p>
                    </div>
                </div>
            </div>
            <div class="card-body">
                <div class="d-flex justify-content-start">
                    <form action="{{ route('mrp-po-general.index') }}" method="GET">
                        <div class="d-flex justify-content-between align-items-end gap-3">
                            <div class="">
                                <label for="start_date" class="start_date">Required Start Date</label>
                                <input type="date" class="form-control @error('start_date') is-invalid @enderror"
                                    name="start_date" value="{{ old('start_date', request('start_date')) }}" required>
                            </div>
                            <div class="">
                                <label for="end_date" class="start_date">Required End Date</label>
                                <input type="date" class="form-control @error('end_date') is-invalid @enderror"
                                    name="end_date" value="{{ old('end_date', request('end_date')) }}" required>
                            </div>
                            <div class="">
                                <a href="{{ route('mrp-po-general.index') }}">
                                    <button type="button" class="btn btn-light">
                                        Reset
                                    </button>
                                </a>
                            </div>
                            <div class="">
                                <button type="submit" class="btn btn-success">
                                    Filter
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
                <div class="d-flex justify-content-end mb-3">
                    <span id="confirm-button"></span>
                </div>
                <div class="table-responsive theme-scrollbar">
                    <table class="display" id="basic-1">
                        <thead>
                            <tr>
                                <th class="bg-light-primary text-dark">Material Fullname</th>
                                <th class="bg-light-primary text-dark">Material Code</th>
                                <th class="bg-light-primary text-dark">UoM</th>
                                <th class="bg-light-primary text-dark">Required Date</th>
                                <th class="bg-light-primary text-dark">Lot Size</th>
                                <th class="bg-light-primary text-dark">Gross Requirement</th>
                                <th class="bg-light-primary text-dark">Sch. Receipts</th>
                                <th class="bg-light-primary text-dark">Y. Stock Card</th>
                                <th class="bg-light-primary text-dark">P. On Hand</th>
                                <th class="bg-light-primary text-dark">Net Requirement</th>
                                <th class="bg-light-primary text-dark">Pl. Order Receipt</th>
                                <th class="bg-light-primary text-dark">Pl. Order Release</th>
                                <th class="bg-light-primary text-dark">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $pohArray = [];
                            @endphp
                            @foreach ($mrpData as $key => $result)
                                @php
                                    if (!isset($pohArray[$result['material_code']])) {
                                        $projectedOnHand = $result['stock_card'];
                                    } else {
                                        $projectedOnHand = $pohArray[$result['material_code']];
                                    }

                                @endphp

                                @php
                                    // Stock Card
                                    $stockCard = $result['stock_card'];
                                @endphp
                                @php
                                    // Gross Requirement
                                    $grossRequirement = $result['requirement'];
                                @endphp

                                @php
                                    // Sch. Receipts
                                    $scheduledReceipt = $result['scheduled_receipt'];
                                @endphp

                                @php
                                    // Net Requirement
                                    $netRequirement =
                                        $result['requirement'] -
                                        ($scheduledReceipt + $projectedOnHand) +
                                        $result['safety_stock'];

                                    if ($netRequirement < 0) {
                                        $netRequirement = 0;
                                    }
                                @endphp

                                @php
                                    // Planned Order Receipt
                                    if ($netRequirement > 0) {
                                        $plannedOrderReceipt =
                                            ceil(abs($netRequirement) / $result['lot_size']) * $result['lot_size'];
                                    } else {
                                        $plannedOrderReceipt = 0;
                                    }
                                @endphp

                                @php
                                    // Planned Order Releases
                                    $plannedOrderReleases = $plannedOrderReceipt;

                                @endphp

                                @php
                                    // Projected On Hand
                                    $projectedOnHand += $plannedOrderReceipt; // Tambah Planned Order Receipt
                                    $projectedOnHand += $scheduledReceipt; // Tambah Scheduled Receipts
                                    if (isset($pohArray['material_code'])) {
                                        $projectedOnHand += $pohArray[$result['material_code']];
                                    }
                                    $projectedOnHand -= $grossRequirement; // Kurangi Gross Requirement

                                    // Cek jika hasil kurang dari 0, maka set jadi 0
                                    if ($projectedOnHand < 0) {
                                        $projectedOnHand = 0;
                                    }

                                    // Simpan nilai projectedOnHand ke dalam array pohArray untuk material_code dan date
                                    $pohArray[$result['material_code']] = $projectedOnHand;
                                @endphp
                                <tr>
                                    <td>{{ $result['material_fullname'] }}</td>
                                    <td>{{ $result['material_code'] }}</td>
                                    <td>{{ $result['material_uom'] }}</td>
                                    <td>{{ $result['required_date'] }}</td>
                                    <td>{{ $result['lot_size'] }}</td>
                                    <td>{{ $grossRequirement }}</td>
                                    <td>{{ $scheduledReceipt }}</td>
                                    <td>{{ $stockCard }}</td>
                                    <td>{{ $projectedOnHand }}</td>
                                    <td>{{ $netRequirement }}</td>
                                    <td>{{ $plannedOrderReceipt }}</td>
                                    <td>
                                        @if ($plannedOrderReleases === 0)
                                            -
                                        @else
                                            <div class="d-flex justify-content-between gap-3">
                                                <div class="">
                                                    <p>Best buy at :
                                                        <strong>{{ \Carbon\Carbon::parse($result['required_date'])->subDays($result['lead_time'])->format('Y-m-d') }}</strong>
                                                    </p>
                                                </div>
                                                <div class="">
                                                    <p>Qty Order : <strong>{{ $plannedOrderReleases }}</strong></p>
                                                </div>
                                            </div>
                                        @endif
                                    </td>
                                    <td class="text-center">
                                        @if ($plannedOrderReceipt > 0)
                                            <input type="checkbox" id="check-{{ $key }}"
                                                onclick="onChecked({{ $key }}, '{{ $result['required_date'] }}', '{{ $result['material_code'] }}', {{ $plannedOrderReleases }}, '{{ json_encode($result['purchase_request_id']) }}')">
                                        @endif
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script>
        let countChecked = 0;
        let selectedData = [];

        $("#basic-1").DataTable({
            order: [2, 'asc']
        });

        function onChecked(id, requiredDate, materialCode, qty, purchaseRequest) {
            const checkbox = document.getElementById(`check-${id}`);
            const row = checkbox.closest('tr');

            const purchaseRequestIdArray = JSON.parse(purchaseRequest);

            if (checkbox.checked) {
                countChecked++;
                selectedData.push({
                    id: id,
                    required_date: requiredDate,
                    material_code: materialCode,
                    qty: qty,
                    purchase_request_id: purchaseRequestIdArray
                });

                row.classList.add('bg-light-success');
                row.classList.add('text-dark');

            } else {
                countChecked--;
                selectedData = selectedData.filter(data => data.id !== id);
                row.classList.remove('bg-light-success');
                row.classList.remove('text-dark');
            }

            if (countChecked > 0) {
                let formContent = `
                    <form action="{{ route('mrp-po-general.store') }}" method="POST">
                        @csrf
                        <input type="hidden" name="selected_data" value='${JSON.stringify(selectedData)}'>
                        <button class="btn btn-success" id="confirm-action">
                            Create PO (${countChecked} selected)
                        </button>
                    </form>
                    `;

                $('#confirm-button').html(formContent);
            } else {
                $('#confirm-button').empty();
            }
        }
    </script>
@endsection