@extends('backend.partials.master')
@section('title')
Customer Purchase 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 Purchase Price</h1>
      <div class="card">
         <div class="card-body">
            <form
               action="{{ !empty($old) ? route('CustomerSalePrice.update') : route('CustomerSalePrice.store') }}"
               method="POST"
               enctype="multipart/form-data"
            >
               @csrf
               @if(!empty($old))
                  @method('PUT')
               @endif
<input type="hidden" id="totalLotExpense" name="totalLotExpense">
               <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"
                        @if(!empty($old)) disabled @endif>
                        <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>

                     @if(!empty($old))
                        <input type="hidden" name="lot_no" value="{{ $old[0]->lot_no }}">
                     @endif

                     @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 id="expense_header">
Expense
<input type="hidden"
id="expense_header_value"
name="expense_header_value"
value="{{ old('expense_header_value', $old[0]->expense_header_value ?? $expense ?? 0) }}">
</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();
@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"
name="qtyexpense[]"
class="form-control qtyexpense"
value="{{ number_format($first->expense,2) }}">

</td>

<td>

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

</td>


{{-- CUSTOMER WISE SALE PRICE --}}

@foreach($customers as $cIndex => $customer)

@php
$row = DB::table('customer_sale_prices')
->where('product_id',$first->product_id)
->where('customer_id',$customer->id)
->first();
@endphp

<td>

<input type="hidden"
class="commissionAmount"
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"
name="saleprice[{{ $loop->parent->index }}][{{ $cIndex }}]"
value="{{ isset($row->sale_price) ? number_format($row->sale_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 id="submitBtn" class="btn btn-primary"> {{ !empty($old) ? 'Update' : 'Create' }}</button>
               <a href="{{ route('CustomerSalePrice') }}" 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.lot') }}",
                type: 'GET',
                data: { lot_no: lotNo },
                success: function (response) {

                      let lotExpense = response.products[0].expense || 0;
                    let totalExpenseRow = response.products[0].totalExpenserow || 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)`);

      // Update the total expense shown
    if($('#expense_show').length === 0) {
        // If not exist, create it dynamically
        $('#expense_header').append(`<span id="expense_show">${parseFloat(totalExpenseRow).toFixed(2)} Rs</span>`);
    } else {
        // If exists, just update
        $('#expense_show').text(parseFloat(totalExpenseRow).toFixed(2) + " Rs");
    }

    // Update hidden input for calculation
    if($('#expense_header_value').length === 0) {
        // If hidden input doesn't exist, append it
        $('#expense_header').append(`<input type="hidden" name="expense_header_value" id="expense_header_value" value="${totalExpenseRow}">`);
    } else {
        // If exists, just update the value
        $('#expense_header_value').val(totalExpenseRow);
    }

                    // 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)}">

    </td>
    <td>
        <input type="number" class="commission form-control" name="commission[]" value="25">
    </td>
`;

customers.forEach(c => {
    rowHtml += `
        <td>
            <input type="hidden" class="commissionAmount" name="commissionAmount[${index}][]" value="0">
            <input type="text" class="saleprice form-control" name="saleprice[${index}][]" value="0.00">
            <small class="text-danger commissionDisplay"></small>
        </td>
    `;
});

rowHtml += '</tr>';

                        rows += rowHtml;
                    });
                    $('#product_table').html(rows);
                    let rowCount = $('#product_table tr').length;
                     console.log("Total Rows: " + rowCount);
                    checkExpenseTotal();
                    // 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));
    });
});

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

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

//     // ✅ round नको, फक्त 2 decimal cut
//     let commissionFixed = Math.floor(commissionAmount * 100) / 100;
//     let salepriceFixed = Math.floor(saleprice * 100) / 100;

//     row.find('.commissionAmount')
//         .val(commissionFixed.toFixed(2)) // display 2 decimal
//         .attr('value', commissionFixed.toFixed(2));

//     row.find('.saleprice')
//         .val(salepriceFixed.toFixed(2)) // display 2 decimal
//         .attr('value', salepriceFixed.toFixed(2));
// }

function calculateRow(row) {

    let rate = parseFloat(row.find('.rate').val()) || 0;
    let expense = parseFloat(row.find('.qtyexpense').val()) || 0;
    let commission = parseFloat(row.find('.commission').val()) || 0;
    let saleprice = parseFloat(row.find('#saleprice').val()) || 0;
    //alert(saleprice);
    let baseAmount = rate + expense;

    row.find('.saleprice').each(function () {

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

        let commissionFixed = Math.floor(commissionAmount * 100) / 100;
        let salepriceFixed = Math.floor(saleprice * 100) / 100;

        $(this).closest('td').find('.commissionAmount')
            .val(commissionFixed.toFixed(2));
  if(saleprice != ''){
    // alert("hii");
            $(this).val(saleprice.toFixed(2));
        }else{
       //     alert("by");
            $(this).val(salepriceFixed.toFixed(2));
        }


    });
}

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

function calculateCommissionFromPrice(row,input){

    let rate = parseFloat(row.find('.rate').val()) || 0;
    let expense = parseFloat(row.find('.qtyexpense').val()) || 0;

    let baseAmount = rate + expense;

    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));

});

function checkExpenseTotal() {
    let totalExpense = 0;

    // Sum all qtyexpense inputs
    $('.qtyexpense').each(function () {
        let val = $(this).val().replace(/,/g, '');
        val = parseFloat(val) || 0;
        totalExpense += val;
    });

    // Get the total expense from the hidden input
    let targetExpense = parseFloat($('#expense_header_value').val()) || 0;

    // Difference between total and target
    let remaining = (targetExpense - totalExpense).toFixed(2);

    // Remove old remaining message
    $('.remainingError').remove();

    if (remaining != 0) {
        // Show remaining amount
        $('.qtyexpense').last().after(
            '<small class="text-danger remainingError">Remaining : ' + remaining + ' Rs</small>'
        );
        $('#submitBtn').prop('disabled', true); // disable save
    } else {
        $('#submitBtn').prop('disabled', false); // enable save
    }
}

// Trigger on keyup or change
$(document).on('keyup change', '.qtyexpense', function () {
    checkExpenseTotal();
});

// Initial check on page load
$(document).ready(function () {
    checkExpenseTotal();
});
// // Calculate sale price
// function calculateRow(row) {
//     let rate = parseFloat(row.find('.rate').val()) || 0;
//     let qtyexpense = parseFloat(row.find('.qtyexpense').val()) || 0;
//    alert(qtyexpense);
//     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'));
// });

// // 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