@extends('layouts.dashboard.superadminapp')

@section('title', 'Edit Sales Order')

@section('styles')
<link rel="stylesheet" href="{{ asset('css/modern-form-pattern.css') }}">
@endsection

@section('content')
<div class="container-fluid theme-purple">
    <!-- Modern Page Header -->
    <div class="modern-page-header">
        <div class="header-left">
            <div class="icon-wrapper">
                <i class="fas fa-shopping-cart"></i>
            </div>
            <div class="header-title">
                <h1>Edit Sales Order</h1>
                <div class="header-subtitle">{{ $order->sales_order_no }}</div>
            </div>
        </div>
        <div class="datetime-display">
            <div class="date-box">
                <i class="far fa-calendar-alt"></i>
                <span id="day">{{ now()->format('l') }}</span>,
                <span id="daynum">{{ now()->format('d') }}</span>
                <span id="month">{{ now()->format('F') }}</span>
                <span id="year">{{ now()->format('Y') }}</span>
            </div>
            <div class="time-box">
                <i class="far fa-clock"></i>
                <span class="display-time"></span>
            </div>
        </div>
    </div>

    <!-- Alerts -->
    @if (session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fas fa-check-circle mr-2"></i>{{ session('success') }}
            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                <span aria-hidden="true">&times;</span>
            </button>
        </div>
    @endif
    @if (session('error'))
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fas fa-exclamation-circle mr-2"></i>{{ session('error') }}
            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                <span aria-hidden="true">&times;</span>
            </button>
        </div>
    @endif

    <!-- Main Form -->
    <form id="soForm" action="{{ route('superadmin.sales.order.update', $order->id) }}" method="POST">
        @csrf
        @method('PUT')

        <!-- Sales Order Details Section -->
        <div class="section-card">
            <div class="section-header">
                <i class="fas fa-file-invoice"></i>
                <h2>Sales Order Details</h2>
            </div>
            <div class="section-body">
                <div class="row form-row">
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Sales Order No <span class="required-star">*</span></label>
                        <input type="text" class="form-control" id="sOrderNo" name="sales_order_no" value="{{ $order->sales_order_no }}" readonly required>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Sales Order Date <span class="required-star">*</span></label>
                        <input type="date" class="form-control" id="sOrderDate" name="sales_order_date" value="{{ $order->sales_order_date }}" required>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Quotation</label>
                        <input type="text" class="form-control" value="{{ $order->quotation->quotation_no ?? 'N/A' }}" readonly>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">GRN No</label>
                        <input type="text" class="form-control" id="grnNo" name="grn_no" value="{{ $order->grn_no }}" placeholder="GRN Number">
                    </div>
                </div>
                <div class="row form-row">
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Customer Reference No</label>
                        <input type="text" class="form-control" id="custRefNo" name="cust_ref_so_no" value="{{ $order->cust_ref_so_no }}" placeholder="Customer Ref No">
                    </div>
                </div>
            </div>
        </div>

        <!-- Customer Information Section -->
        <div class="section-card">
            <div class="section-header info">
                <i class="fas fa-user"></i>
                <h2>Customer Information</h2>
            </div>
            <div class="section-body">
                <div class="row form-row">
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Company Name</label>
                        <input type="text" class="form-control" value="{{ $order->customer->company ?? 'N/A' }}" readonly>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Address</label>
                        <input type="text" class="form-control" id="soCompanyAddress" name="company_address" value="{{ $order->company_address }}" placeholder="Company Address">
                    </div>
                </div>
                <div class="row form-row">
                    <div class="col-md-4 mb-3">
                        <label class="form-label">GST No</label>
                        <input type="text" class="form-control" id="soCompanyGSTN" name="company_gstn" value="{{ $order->company_gstn }}" placeholder="GSTIN">
                    </div>
                    <div class="col-md-4 mb-3">
                        <label class="form-label">Phone</label>
                        <input type="tel" class="form-control" id="soCompanyPhone" name="company_phone" value="{{ $order->company_phone }}" placeholder="Contact Number">
                    </div>
                    <div class="col-md-4 mb-3">
                        <label class="form-label">Email</label>
                        <input type="email" class="form-control" id="soCompanyEmail" name="company_email" value="{{ $order->company_email }}" placeholder="Email Address">
                    </div>
                </div>
            </div>
        </div>

        <!-- RFQ & Product Information Section -->
        <div class="section-card">
            <div class="section-header success">
                <i class="fas fa-box"></i>
                <h2>RFQ & Product Information</h2>
            </div>
            <div class="section-body">
                <div class="row form-row">
                    <div class="col-md-3 mb-3">
                        <label class="form-label">RFQ No</label>
                        <input type="text" class="form-control" value="{{ $order->rfq_no }}" readonly>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">RFQ Date</label>
                        <input type="date" class="form-control" value="{{ $order->rfq_date }}" readonly>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Part No</label>
                        <input type="text" class="form-control" value="{{ $order->part_no }}" readonly>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Project/Material No</label>
                        <input type="text" class="form-control" value="{{ $order->project_material_no }}" readonly>
                    </div>
                </div>
                <div class="row form-row">
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Drawing No</label>
                        <input type="text" class="form-control" value="{{ $order->drawing_no }}" readonly>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label class="form-label">Drawing Revision</label>
                        <input type="text" class="form-control" value="{{ $order->drawing_revision }}" readonly>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Product Type</label>
                        <input type="text" class="form-control" value="{{ $order->product_type }}" readonly>
                    </div>
                </div>
                <div class="row form-row">
                    <div class="col-md-12 mb-3">
                        <label class="form-label">Description / Notes</label>
                        <textarea class="form-control" rows="2" readonly>{{ $order->project_description }}</textarea>
                    </div>
                </div>
            </div>
        </div>

        <!-- Billing & Shipping Section -->
        <div class="section-card">
            <div class="section-header warning">
                <i class="fas fa-shipping-fast"></i>
                <h2>Billing & Shipping</h2>
            </div>
            <div class="section-body">
                <div class="row form-row">
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Bill To</label>
                        <textarea class="form-control" id="billAddress" name="bill_address" rows="2" placeholder="Billing Address">{{ $order->bill_address }}</textarea>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Ship To</label>
                        <textarea class="form-control" id="shipAddress" name="ship_address" rows="2" placeholder="Shipping Address">{{ $order->ship_address }}</textarea>
                    </div>
                </div>
            </div>
        </div>

        @php
            $products = is_array($order->table_products) ? $order->table_products : json_decode($order->table_products, true) ?? [];
        @endphp

        <!-- Product Items Section -->
        <div class="section-card">
            <div class="section-header secondary">
                <i class="fas fa-list"></i>
                <h2>Product Items</h2>
            </div>
            <div class="section-body">
                <div class="table-responsive">
                    <table id="productTable" class="table table-modern table-bordered">
                        <thead>
                            <tr>
                                <th width="40">#</th>
                                <th width="90">Material Code</th>
                                <th width="80">HSN Code</th>
                                <th>Description</th>
                                <th>Additional Details</th>
                                <th width="100">Req By Date</th>
                                <th width="60">Qty</th>
                                <th width="60">UOM</th>
                                <th width="80">Unit Rate</th>
                                <th width="60">Disc %</th>
                                <th width="80">Value</th>
                                <th width="60">SGST %</th>
                                <th width="60">CGST %</th>
                                <th width="60">IGST %</th>
                                <th width="90">Amount</th>
                                <th width="40"></th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($products as $index => $product)
                            <tr>
                                <td class="text-center">{{ $index + 1 }}</td>
                                <td><input type="text" class="form-control material-code" name="products[{{ $index }}][material_code]" value="{{ $product['materialCode'] ?? '' }}"></td>
                                <td><input type="text" class="form-control hsn-code" name="products[{{ $index }}][hsn_code]" value="{{ $product['hsnCode'] ?? '' }}"></td>
                                <td><textarea class="form-control description" name="products[{{ $index }}][description]" rows="1">{{ $product['description'] ?? '' }}</textarea></td>
                                <td><textarea class="form-control additional-details" name="products[{{ $index }}][additional_details]" rows="1">{{ $product['additionalDetails'] ?? '' }}</textarea></td>
                                <td><input type="date" class="form-control req-by-date" name="products[{{ $index }}][req_by_date]" value="{{ $product['reqByDate'] ?? '' }}"></td>
                                <td><input type="number" class="form-control quantity" name="products[{{ $index }}][quantity]" value="{{ $product['quantity'] ?? 0 }}" min="0"></td>
                                <td><input type="text" class="form-control uom" name="products[{{ $index }}][uom]" value="{{ $product['uom'] ?? '' }}"></td>
                                <td><input type="number" class="form-control rate" name="products[{{ $index }}][unit_rate]" value="{{ $product['unitRate'] ?? 0 }}" step="0.01" min="0"></td>
                                <td><input type="number" class="form-control discount" name="products[{{ $index }}][discount]" value="{{ $product['discount'] ?? 0 }}" step="0.01" min="0" max="100"></td>
                                <td><input type="number" class="form-control value" name="products[{{ $index }}][value]" value="{{ $product['value'] ?? 0 }}" readonly></td>
                                <td><input type="number" class="form-control sgst" name="products[{{ $index }}][sgst]" value="{{ $product['sgst'] ?? 0 }}" step="0.01" min="0"></td>
                                <td><input type="number" class="form-control cgst" name="products[{{ $index }}][cgst]" value="{{ $product['cgst'] ?? 0 }}" step="0.01" min="0"></td>
                                <td><input type="number" class="form-control igst" name="products[{{ $index }}][igst]" value="{{ $product['igst'] ?? 0 }}" step="0.01" min="0"></td>
                                <td><input type="number" class="form-control amount" name="products[{{ $index }}][amount]" value="{{ $product['amount'] ?? 0 }}" readonly></td>
                                <td class="text-center">
                                    <button type="button" class="btn btn-danger btn-sm" onclick="deleteRow(this)">
                                        <i class="fa fa-trash"></i>
                                    </button>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
                <div class="mt-3">
                    <button type="button" class="btn btn-primary btn-sm" id="addRowBtn">
                        <i class="fas fa-plus mr-1"></i> Add Row
                    </button>
                </div>
            </div>
        </div>

        <!-- Summary Section -->
        <div class="section-card">
            <div class="section-header success">
                <i class="fas fa-calculator"></i>
                <h2>Summary</h2>
            </div>
            <div class="section-body">
                <div class="row form-row">
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Grand Total in Words (INR)</label>
                        <input type="text" class="form-control" id="GT-in-letters" name="gt_in_letters" value="{{ $order->gt_in_letters }}" readonly>
                    </div>
                    <div class="col-md-6">
                        <div class="summary-table">
                            <table class="table table-sm table-borderless mb-0">
                                <tr>
                                    <td class="text-right">Sub Total:</td>
                                    <td width="150"><input type="text" id="totalAmount" name="total_amount" value="{{ $order->total_amount }}" readonly class="form-control form-control-sm text-right"></td>
                                </tr>
                                <tr>
                                    <td class="text-right">SGST Amount:</td>
                                    <td><input type="text" id="sgstA" name="sgst_amount" value="{{ $order->sgst_amount }}" readonly class="form-control form-control-sm text-right"></td>
                                </tr>
                                <tr>
                                    <td class="text-right">CGST Amount:</td>
                                    <td><input type="text" id="cgstA" name="cgst_amount" value="{{ $order->cgst_amount }}" readonly class="form-control form-control-sm text-right"></td>
                                </tr>
                                <tr>
                                    <td class="text-right">IGST Amount:</td>
                                    <td><input type="text" id="IgstA" name="igst_amount" value="{{ $order->igst_amount }}" readonly class="form-control form-control-sm text-right"></td>
                                </tr>
                                <tr>
                                    <td class="text-right">Round Up:</td>
                                    <td><input type="text" id="roundUp" name="round_up" value="{{ $order->round_up }}" readonly class="form-control form-control-sm text-right"></td>
                                </tr>
                                <tr class="border-top">
                                    <td class="text-right font-weight-bold">Grand Total:</td>
                                    <td><input type="text" id="grandTotal" name="grand_total" value="{{ $order->grand_total }}" readonly class="form-control form-control-sm text-right font-weight-bold"></td>
                                </tr>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Footer Actions -->
        <div class="footer-actions">
            <a href="{{ route('superadmin.sales.salesdetails') }}" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Back to List
            </a>
            <div>
                <button type="submit" class="btn btn-success" id="submitBtn">
                    <span class="spinner-border spinner-border-sm d-none" role="status"></span>
                    <i class="fas fa-save" id="submitIcon"></i>
                    <span id="submitText">Update Sales Order</span>
                </button>
            </div>
        </div>
    </form>
</div>
@endsection

@section('scripts')
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
// Dynamic Date/Time Update
function updateDateTime() {
    const now = new Date();
    const days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];
    const months = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];

    document.getElementById('day').textContent = days[now.getDay()];
    document.getElementById('daynum').textContent = now.getDate();
    document.getElementById('month').textContent = months[now.getMonth()];
    document.getElementById('year').textContent = now.getFullYear();

    const timeStr = now.toLocaleTimeString('en-US', { hour: '2-digit', minute: '2-digit', second: '2-digit' });
    document.querySelector('.display-time').textContent = timeStr;
}
updateDateTime();
setInterval(updateDateTime, 1000);

let productRowCounter = {{ count($products) }};

$(document).ready(function() {
    // Setup event listeners for existing rows
    document.querySelectorAll("#productTable tbody tr").forEach(row => {
        setupRowEventListeners(row);
    });

    // Add Row button
    $('#addRowBtn').click(function() {
        addRow();
    });

    // Form submit
    $('#soForm').on('submit', function(e) {
        e.preventDefault();
        updateSO();
    });

    // Calculate totals initially
    calculateAllTotals();
});

// Add Row
function addRow() {
    const tbody = document.querySelector("#productTable tbody");
    const rowCount = tbody.querySelectorAll('tr').length;
    const newRow = document.createElement("tr");
    newRow.innerHTML = `
        <td class="text-center">${rowCount + 1}</td>
        <td><input type="text" class="form-control material-code" name="products[${productRowCounter}][material_code]"></td>
        <td><input type="text" class="form-control hsn-code" name="products[${productRowCounter}][hsn_code]"></td>
        <td><textarea class="form-control description" name="products[${productRowCounter}][description]" rows="1"></textarea></td>
        <td><textarea class="form-control additional-details" name="products[${productRowCounter}][additional_details]" rows="1"></textarea></td>
        <td><input type="date" class="form-control req-by-date" name="products[${productRowCounter}][req_by_date]"></td>
        <td><input type="number" class="form-control quantity" name="products[${productRowCounter}][quantity]" min="0"></td>
        <td><input type="text" class="form-control uom" name="products[${productRowCounter}][uom]"></td>
        <td><input type="number" class="form-control rate" name="products[${productRowCounter}][unit_rate]" step="0.01" min="0"></td>
        <td><input type="number" class="form-control discount" name="products[${productRowCounter}][discount]" step="0.01" min="0" max="100"></td>
        <td><input type="number" class="form-control value" name="products[${productRowCounter}][value]" readonly></td>
        <td><input type="number" class="form-control sgst" name="products[${productRowCounter}][sgst]" step="0.01" min="0"></td>
        <td><input type="number" class="form-control cgst" name="products[${productRowCounter}][cgst]" step="0.01" min="0"></td>
        <td><input type="number" class="form-control igst" name="products[${productRowCounter}][igst]" step="0.01" min="0"></td>
        <td><input type="number" class="form-control amount" name="products[${productRowCounter}][amount]" readonly></td>
        <td class="text-center">
            <button type="button" class="btn btn-danger btn-sm" onclick="deleteRow(this)">
                <i class="fa fa-trash"></i>
            </button>
        </td>
    `;
    tbody.appendChild(newRow);
    setupRowEventListeners(newRow);
    productRowCounter++;
}

// Delete Row
function deleteRow(button) {
    const row = button.closest("tr");
    row.parentNode.removeChild(row);
    updateRowNumbers();
    calculateAllTotals();
}

// Update Row Numbers
function updateRowNumbers() {
    const rows = document.querySelectorAll("#productTable tbody tr");
    rows.forEach((row, i) => row.cells[0].textContent = i + 1);
}

// Setup Row Event Listeners
function setupRowEventListeners(row) {
    const inputs = ['quantity', 'rate', 'discount', 'sgst', 'cgst', 'igst'];
    inputs.forEach(className => {
        const input = row.querySelector(`.${className}`);
        if (input) {
            input.addEventListener('input', function() {
                calculateRowValue(row);
            });
        }
    });
}

// Calculate Row Value
function calculateRowValue(row) {
    const quantity = parseFloat(row.querySelector('.quantity').value) || 0;
    const rate = parseFloat(row.querySelector('.rate').value) || 0;
    const discount = parseFloat(row.querySelector('.discount').value) || 0;
    const sgst = parseFloat(row.querySelector('.sgst').value) || 0;
    const cgst = parseFloat(row.querySelector('.cgst').value) || 0;
    const igst = parseFloat(row.querySelector('.igst').value) || 0;

    const baseValue = quantity * rate * (1 - discount / 100);
    row.querySelector('.value').value = baseValue.toFixed(2);

    const amount = baseValue * (1 + (sgst + cgst + igst) / 100);
    row.querySelector('.amount').value = amount.toFixed(2);

    calculateAllTotals();
}

// Calculate All Totals
function calculateAllTotals() {
    let subtotal = 0, sgstTotal = 0, cgstTotal = 0, igstTotal = 0;

    document.querySelectorAll("#productTable tbody tr").forEach(row => {
        const val = parseFloat(row.querySelector('.value').value) || 0;
        const sgst = parseFloat(row.querySelector('.sgst').value) || 0;
        const cgst = parseFloat(row.querySelector('.cgst').value) || 0;
        const igst = parseFloat(row.querySelector('.igst').value) || 0;

        subtotal += val;
        sgstTotal += val * sgst / 100;
        cgstTotal += val * cgst / 100;
        igstTotal += val * igst / 100;
    });

    const grandTotalRaw = subtotal + sgstTotal + cgstTotal + igstTotal;
    const roundUp = Math.ceil(grandTotalRaw) - grandTotalRaw;
    const grandTotal = grandTotalRaw + roundUp;

    document.getElementById("totalAmount").value = subtotal.toFixed(2);
    document.getElementById("sgstA").value = sgstTotal.toFixed(2);
    document.getElementById("cgstA").value = cgstTotal.toFixed(2);
    document.getElementById("IgstA").value = igstTotal.toFixed(2);
    document.getElementById("roundUp").value = roundUp.toFixed(2);
    document.getElementById("grandTotal").value = grandTotal.toFixed(2);
    document.getElementById("GT-in-letters").value = numberToWords(Math.round(grandTotal)) + ' Rupees Only';
}

// Update SO
async function updateSO() {
    const $btn = $('#submitBtn');
    const $spinner = $btn.find('.spinner-border');

    // Validation
    if (!document.getElementById('sOrderNo').value || !document.getElementById('sOrderDate').value) {
        Swal.fire('Error', 'Sales Order No and Date are required!', 'error');
        return;
    }

    $btn.prop('disabled', true);
    $spinner.removeClass('d-none');
    $('#submitIcon').addClass('d-none');

    try {
        const response = await fetch($('#soForm').attr('action'), {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json',
                'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').getAttribute('content'),
                'X-HTTP-Method-Override': 'PUT'
            },
            body: JSON.stringify(new FormData($('#soForm')[0]))
        });

        // For now, just submit the form normally
        $('#soForm')[0].submit();
    } catch (err) {
        console.error("Update error:", err);
        // Submit normally as fallback
        $('#soForm')[0].submit();
    }
}

// Number to Words (Indian Format)
function numberToWords(num) {
    if (num === 0) return 'Zero';

    const ones = ['', 'One', 'Two', 'Three', 'Four', 'Five', 'Six', 'Seven', 'Eight', 'Nine',
                  'Ten', 'Eleven', 'Twelve', 'Thirteen', 'Fourteen', 'Fifteen', 'Sixteen',
                  'Seventeen', 'Eighteen', 'Nineteen'];
    const tens = ['', '', 'Twenty', 'Thirty', 'Forty', 'Fifty', 'Sixty', 'Seventy', 'Eighty', 'Ninety'];

    function convertLessThanHundred(n) {
        if (n < 20) return ones[n];
        return tens[Math.floor(n / 10)] + (n % 10 ? ' ' + ones[n % 10] : '');
    }

    function convertLessThanThousand(n) {
        if (n < 100) return convertLessThanHundred(n);
        return ones[Math.floor(n / 100)] + ' Hundred' + (n % 100 ? ' ' + convertLessThanHundred(n % 100) : '');
    }

    if (num < 0) return 'Negative ' + numberToWords(-num);
    if (num < 1000) return convertLessThanThousand(num);
    if (num < 100000) {
        return convertLessThanHundred(Math.floor(num / 1000)) + ' Thousand' +
               (num % 1000 ? ' ' + convertLessThanThousand(num % 1000) : '');
    }
    if (num < 10000000) {
        return convertLessThanHundred(Math.floor(num / 100000)) + ' Lakh' +
               (num % 100000 ? ' ' + numberToWords(num % 100000) : '');
    }
    return convertLessThanHundred(Math.floor(num / 10000000)) + ' Crore' +
           (num % 10000000 ? ' ' + numberToWords(num % 10000000) : '');
}
</script>
@endsection