@extends('backend.partials.master')
@section('title')
Customer Sale Price {{ !empty($old) ? 'Edit' : 'Create' }}
@endsection

@section('maincontent')

@php
    $groupedProducts = !empty($old) ? $old->groupBy('product_id') : collect();
@endphp
<main class="content">
   <div class="container-fluid p-0">
      <h1 class="h3 mb-3">{{ !empty($old) ? 'Edit' : 'Create' }} Customer Sale Price</h1>
      <div class="card">
         <div class="card-body">
            <form
               action="{{ !empty($old) ? route('CustomerSellingPrice.update') : route('CustomerSellingPrice.store') }}"
               method="POST"
               enctype="multipart/form-data"
            >
               @csrf
               @if(!empty($old))
                  @method('PUT')
               @endif

               <div class="row">
                  <div class="col-md-4 mb-3">
                    <label>Lot No <span class="text-danger">*</span></label>

                    <select name="lot_no" id="lot_no" class="form-control choices-single">
                        <option value="">Select Lot No</option>

                        @foreach($productlot as $lot)
                             <option value="{{ $lot }}"
                                {{ old('lot_no', $old[0]->lot_no ?? '') == $lot ? 'selected' : '' }}>
                                {{ $lot }}
                            </option>
                        @endforeach
                    </select>

                    @error('lot_no')
                        <small class="text-danger">{{ $message }}</small>
                    @enderror
                </div>

               </div>

<div class="container ">


<table class="table table-bordered table-striped" id="poTable">
                   <thead>
                       <tr id="table_head">
                           <th>Sr No</th>
                           <th>Lot No</th>
                           <th>Product</th>
                           <th>Purchase Price</th>
                            <th>Expense</th>
                           <th>Commission %</th>
                           @foreach($customers as $customer)
    <th>
        {{ $customer->fname }}
        <input type="hidden" name="customer_id[]" value="{{ $customer->id }}">
    </th>
@endforeach
                       </tr>
                   </thead>
                <tbody id="product_table">
@if(!empty($old))
    @foreach($groupedProducts as $pIndex => $items)

        @php
            $first = $items->first(); // product common data
        @endphp

        <tr>
            <td>{{ $loop->iteration }}</td>

            <td>
                {{ $first->lot_no }}
                <input type="hidden" name="lot_no" value="{{ $first->lot_no }}">
            </td>

            <td>
                {{ $first->product_name }}
                <input type="hidden" name="product_id[]" value="{{ $first->product_id }}">
                <input type="hidden" name="product_name[]" value="{{ $first->product_name }}">
            </td>

            <td>
                {{ number_format($first->rate, 2) }}
                <input type="hidden" class="rate" name="rate[]" value="{{ number_format($first->rate, 2) }}">
            </td>

            <td>
                <input type="hidden" name="lotExpense[]" value="{{ number_format($first->expense, 2) }}">
                <input type="text" class="form-control qtyexpense"
                       value="{{ number_format($first->expense, 2) }}" readonly>
            </td>

            <td>
                <input type="number" name="commission[]" class="form-control commission"
                       value="{{ number_format($first->commission_percent, 2) }}" readonly >
            </td>

            {{-- Customer-wise prices --}}
            @foreach($customers as $cIndex => $customer)
                   @php
                            $row = DB::table('customer_selling_prices')
                                    ->where('product_id',$first->product_id)
                                    ->where('customer_id', $customer->id)
                                   ->first();

                        @endphp

                        <td>
                            <input type="hidden"
                                   name="commissionAmount[{{ $loop->parent->index }}][{{ $cIndex }}]"
                                   value="{{ isset($row->commission_amount) ? number_format($row->commission_amount, 2) : '0.00' }}">

                            <input type="text"
                                   class="form-control saleprice" id="saleprice[{{ $loop->parent->index }}][{{ $cIndex }}]"
                                   name="saleprice[{{ $loop->parent->index }}][{{ $cIndex }}]"
                                   value="{{ isset($row->sale_price) ? number_format($row->sale_price, 2) : '' }}">

                            <input type="hidden"
                                   class="form-control purchase_price " id="purchase_price[{{ $loop->parent->index }}][{{ $cIndex }}]"
                                   name="purchase_price[{{ $loop->parent->index }}][{{ $cIndex }}]"
                                   value="{{ isset($row->purchase_price) ? number_format($row->purchase_price, 2) : '' }}">
                                    <small class="text-danger commissionDisplay"></small>

                        </td>
            @endforeach

        </tr>
    @endforeach

@endif
</tbody>
</table>

</div>
<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<!-- Bootstrap 5 JS -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>

<!-- DataTables JS -->
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>

<script>
$(document).ready(function() {
    $('#poTable').DataTable({
        paging: true,
        searching: true,
        ordering: false, // input fields असल्यामुळे sorting बंद
        info: true,
        lengthChange: true,
        pageLength: 10
    });
});
</script>
               <button class="btn btn-primary">{{ !empty($old) ? 'Update' : 'Create' }}</button>
               <a href="{{ route('CustomerSellingPrice') }}" class="btn btn-secondary">Cancel</a>
            </form>
         </div>
      </div>
   </div>
</main>
@endsection

@push('scripts')

<script>
$(document).ready(function() {
    @if(empty($old))
        $('#lot_no').on('change', function () {
            let lotNo = $(this).val();
            if(!lotNo) return;

            $.ajax({
                url: "{{ route('get.products.by.lot') }}",
                type: 'GET',
                data: { lot_no: lotNo },
                success: function (response) {
//console.log(response);
                      let lotExpense = response.products[0].expense || 0;
              if(lotExpense == 0) {
                    alert("Expense for this lot is 0. Please add expense in Expense Master.");
                }
                    let customers = response.products[0].customers;
                      $('#expense_header').text(`Expense:(${lotExpense} Rs)`);
                    // Table header
                //     let headerHtml = `
                //         <th>Sr No</th>
                //         <th>Lot No</th>
                //         <th>Product</th>
                //         <th>Purchase Price</th>
                //         <th>Expense : ${response.products[0].expense}</th>
                //         <th>Commission %</th>
                //     `;

                //     customers.forEach(c => {
                //     headerHtml += `
                //         <th data-customer-id="${c.id}">
                //             ${c.fname}
                //             <input type="hidden" name="customer_id[]" value="${c.id}">
                //         </th>`;
                //    });

                //     $('#table_head').html(headerHtml);

                    // Table rows
                    let rows = '';
                    $.each(response.products, function (index, product) {
                        let rowHtml = `
                           <tr>
    <td>${index + 1}</td>
    <td>${product.lot_no}</td>
    <td>
        ${product.name}
        <input type="hidden" name="product_id[]" value="${product.product_id}">
        <input type="hidden" name="product_name[]" value="${product.name}">
    </td>
    <td>
        ${parseFloat(product.rate).toFixed(2)}
        <input type="hidden" class="rate" name="rate[]" value="${parseFloat(product.rate).toFixed(2)}">
    </td>
    <td>
        <input type="hidden" id="lotExpense" name="lotExpense[]" class="form-control expense" value="${parseFloat(product.lotExpense).toFixed(2)}" readonly>
        <input type="text" class="qtyexpense form-control" name="qtyexpense[]" value="${parseFloat(product.lotExpense).toFixed(2)}" readonly>
    </td>
    <td>
        <input type="number" class="commission form-control" name="commission[]" value="25" readonly>
    </td>
`;

product.customers.forEach(c => {
    rowHtml += `
        <td>
            <input type="hidden"
                class="commissionAmount"
                name="commissionAmount[${index}][]"
                value="${parseFloat(c.commission_amount || 0).toFixed(2)}">

            <input type="text"
                class="saleprice form-control" id="saleprice[${index}][]"
                name="saleprice[${index}][]"
                value="${parseFloat(c.sale_price || 0).toFixed(2)}">

                 <input type="hidden"
                class="purchase_price form-control" id="purchase_price[${index}][]"
                name="purchase_price[${index}][]"
                value="${parseFloat(c.purchase_price || 0).toFixed(2)}">
                <small class="text-danger commissionDisplay"></small>
        </td>
    `;
});

rowHtml += '</tr>';

                        rows += rowHtml;
                    });
                    $('#product_table').html(rows);

                    // calculate each row initially
                    $('#product_table tr').each(function () {
                        calculateRow($(this));
                     });
                },
                error: function () {
                    $('#product_table').html('<tr><td class="text-center" colspan="7">Error fetching data</td></tr>');
                }
            });
        });
    @endif

    // 🔹 EDIT MODE initial calculation
    $('#product_table tr').each(function () {
       //  calculateRow($(this));
    });
});


function calculateRow(row){

    let commissionPercent = parseFloat(row.find('.commission').val()) || 0;

    row.find('[id^="saleprice"]').each(function(){

        let salePriceInput = $(this);
        // alert(salePriceInput);
        // current value (683.34 / 308.34 / 208.34)
        let value = parseFloat(salePriceInput.val()) || 0;

        if(value > 0){

            let commissionAmount = (value * commissionPercent) / 100;
            let finalPrice = value + commissionAmount;

            console.log(finalPrice);

            // commission hidden update
            row.find('[name^="commissionAmount"]').val(commissionAmount.toFixed(2));

            // saleprice update
            salePriceInput.val(finalPrice.toFixed(2));

            // commission show
            salePriceInput.closest('td')
            .find('.commissionDisplay')
           // .text("Commission: " + commissionAmount.toFixed(2));
        }

    });

}
// Recalculate on input change
$(document).on('input change', '.commission, .qtyexpense, .rate', function () {
    calculateRow($(this).closest('tr'));
});

function calculateCommissionFromPrice(row,input){

    let purchasePrice = parseFloat(input.closest('td').find('.purchase_price').val()) || 0;



    let baseAmount = purchasePrice;

    let saleprice = parseFloat(input.val()) || 0;

    if(baseAmount == 0) return;

    let commissionPercent = ((saleprice - baseAmount) / baseAmount) * 100;

    let commissionFixed = Math.floor(commissionPercent * 100) / 100;

    input.closest('td').find('.commissionDisplay')
        // .text("Commission Applied : " + commissionFixed.toFixed(2) + "%");
        .text("" + commissionFixed.toFixed(2) + "%");
}
$(document).on('input','.saleprice',function(){

    let row = $(this).closest('tr');

    calculateCommissionFromPrice(row,$(this));

});

// Calculate sale price
// function calculateRow(row) {
//     let rate = parseFloat(row.find('.rate').val()) || 0;
//     let qtyexpense = parseFloat(row.find('.qtyexpense').val()) || 0;
//     let commission = parseFloat(row.find('.commission').val()) || 0;

//     let baseAmount = rate + qtyexpense;
//     let commissionAmount = (baseAmount * commission) / 100;
//     let saleprice = baseAmount + commissionAmount;

//     row.find('.commissionAmount')
//         .val(commissionAmount.toFixed(4))
//         .attr('value', commissionAmount.toFixed(4));

//     row.find('.saleprice')
//         .val(saleprice.toFixed(4))
//         .attr('value', saleprice.toFixed(4));
// }

// // Recalculate on input change
// $(document).on('input change', '.commission, .qtyexpense, .rate', function () {
//     calculateRow($(this).closest('tr'));
// });
// // Calculate sale price
// function calculateRow(row) {
//     let rate = parseFloat(row.find('.rate').val()) || 0;
//     let qtyexpense = parseFloat(row.find('.qtyexpense').val()) || 0;
//     let commission = parseFloat(row.find('.commission').val()) || 0;

//     let baseAmount = rate + qtyexpense;
//     let commissionAmount = (baseAmount * commission) / 100;
//     let saleprice = baseAmount + commissionAmount;

//     row.find('.commissionAmount')
//         .val(commissionAmount.toFixed(4))
//         .attr('value', commissionAmount.toFixed(4));

//     row.find('.saleprice')
//         .val(saleprice.toFixed(2))
//         .attr('value', saleprice.toFixed(2));
// }
// // Recalculate on input change
// $(document).on('input change', '.commission, .qtyexpense, .rate', function () {
//     calculateRow($(this).closest('tr'));
// });

</script>
@endpush