Does not save in database

My Store Function

public function store(Request $request) { $data = $request->all(); if(isset($request->reference_no)) { $this->validate($request, [ 'reference_no' => [ 'max:191', 'required', 'unique:sales' ], ]); }

    else {
        // Fetch the last reference number
        $lastSale = Sale::orderBy('id', 'desc')->first();
        if ($lastSale) {
            // Extract the numeric part from the reference number
            $lastRefNo = $lastSale->reference_no;
            $lastRefNum = intval(substr($lastRefNo, 3));
        } else {
            $lastRefNum = 0; // Start from 0 if there are no sales yet
        }
        $newRefNum = $lastRefNum + 1;
        $data['reference_no'] = 'INV' . str_pad($newRefNum, 4, '0', STR_PAD_LEFT);
    }

    $data['user_id'] = Auth::id();
    $cash_register_data = CashRegister::where([
        ['user_id', $data['user_id']],
        ['warehouse_id', $data['warehouse_id']],
        ['status', true]
    ])->first();

    if ($cash_register_data) {
        $data['cash_register_id'] = $cash_register_data->id;
    }

    if (isset($data['created_at'])) {
        $data['created_at'] = date("Y-m-d H:i:s", strtotime($data['created_at']));
    } else {
        $data['created_at'] = date("Y-m-d H:i:s");
    }

    if ($data['pos']) {
        if (!isset($data['reference_no'])) {
            $data['reference_no'] = 'INV' . str_pad("0002", 4, "0", STR_PAD_LEFT);
        }

        $balance = $data['grand_total'] - $data['paid_amount'];
        if ($balance > 0 || $balance < 0) {
            $data['payment_status'] = 2;
        } else {
            $data['payment_status'] = 4;
        }

        if ($data['draft']) {
            $lims_sale_data = Sale::find($data['sale_id']);
            $lims_product_sale_data = Product_Sale::where('sale_id', $data['sale_id'])->get();
            foreach ($lims_product_sale_data as $product_sale_data) {
                $product_sale_data->delete();
            }
            $lims_sale_data->delete();
        }
    } else {
        if (!isset($data['reference_no'])) {
            $data['reference_no'] = 'sr-' . date("Ymd") . '-' . date("his");
        }
    }

    $document = $request->document;
    if ($document) {
        $v = Validator::make(
            [
                'extension' => strtolower($request->document->getClientOriginalExtension()),
            ],
            [
                'extension' => 'in:jpg,jpeg,png,gif,pdf,csv,docx,xlsx,txt',
            ]
        );
        if ($v->fails())
            return redirect()->back()->withErrors($v->errors());

        $documentName = $document->getClientOriginalName();
        $document->move('public/sale/documents', $documentName);
        $data['document'] = $documentName;
    }
    if($data['coupon_active']) {
        $lims_coupon_data = Coupon::find($data['coupon_id']);
        $lims_coupon_data->used += 1;
        $lims_coupon_data->save();
    }

    $lims_sale_data = Sale::create($data);
    $lims_customer_data = Customer::find($data['customer_id']);
    $lims_reward_point_setting_data = RewardPointSetting::latest()->first();
    //checking if customer gets some points or not
    if($lims_reward_point_setting_data->is_active &&  $data['grand_total'] >= $lims_reward_point_setting_data->minimum_amount) {
        $point = (int)($data['grand_total'] / $lims_reward_point_setting_data->per_point_amount);
        $lims_customer_data->points += $point;
        $lims_customer_data->save();
    }

    //collecting male data
    $mail_data['email'] = $lims_customer_data->email;
    $mail_data['reference_no'] = $lims_sale_data->reference_no;
    $mail_data['sale_status'] = $lims_sale_data->sale_status;
    $mail_data['payment_status'] = $lims_sale_data->payment_status;
    $mail_data['total_qty'] = $lims_sale_data->total_qty;
    $mail_data['total_price'] = $lims_sale_data->total_price;
    $mail_data['order_tax'] = $lims_sale_data->order_tax;
    $mail_data['order_tax_rate'] = $lims_sale_data->order_tax_rate;
    $mail_data['order_discount'] = $lims_sale_data->order_discount;
    $mail_data['shipping_cost'] = $lims_sale_data->shipping_cost;
    $mail_data['grand_total'] = $lims_sale_data->grand_total;
    $mail_data['paid_amount'] = $lims_sale_data->paid_amount;

    $product_id = $data['product_id'];
    // $product_batch_id = $data['product_batch_id'];
    $imei_number = $data['imei_number'];
    $product_code = $data['product_code'];
    $qty = $data['qty'];
    $sale_unit = $data['sale_unit'];
    $net_unit_price = $data['net_unit_price'];
    $discount = $data['discount'];
    $tax_rate = $data['tax_rate'];
    $tax = $data['tax'];
    $edit_warranty = $data['edit_warranty'];
    $total = $data['subtotal'];
    $product_sale = [];

    foreach ($product_id as $i => $id) {
        $lims_product_data = Product::where('id', $id)->first();
        $product_sale['variant_id'] = null;
        $product_sale['product_batch_id'] = null;
        if($lims_product_data->type == 'combo' && $data['sale_status'] == 1){
            $product_list = explode(",", $lims_product_data->product_list);
            $variant_list = explode(",", $lims_product_data->variant_list);
            if($lims_product_data->variant_list)
                $variant_list = explode(",", $lims_product_data->variant_list);
            else
                $variant_list = [];
            $qty_list = explode(",", $lims_product_data->qty_list);
            $price_list = explode(",", $lims_product_data->price_list);

            foreach ($product_list as $key=>$child_id) {
                $child_data = Product::find($child_id);
                if(count($variant_list) && $variant_list[$key]) {
                    $child_product_variant_data = ProductVariant::where([
                        ['product_id', $child_id],
                        ['variant_id', $variant_list[$key]]
                    ])->first();

                    $child_warehouse_data = Product_Warehouse::where([
                        ['product_id', $child_id],
                        ['variant_id', $variant_list[$key]],
                        ['warehouse_id', $data['warehouse_id'] ],
                    ])->first();

                    $child_product_variant_data->qty -= $qty[$i] * $qty_list[$key];
                    $child_product_variant_data->save();
                }
                else {
                    $child_warehouse_data = Product_Warehouse::where([
                        ['product_id', $child_id],
                        ['warehouse_id', $data['warehouse_id'] ],
                    ])->first();
                }

                $child_data->qty -= $qty[$i] * $qty_list[$key];
                $child_warehouse_data->qty -= $qty[$i] * $qty_list[$key];

                $child_data->save();
                $child_warehouse_data->save();
            }
        }

        if($sale_unit[$i] != 'n/a') {
            $lims_sale_unit_data  = Unit::where('unit_name', $sale_unit[$i])->first();
            $sale_unit_id = $lims_sale_unit_data->id;
            if($lims_product_data->is_variant) {
                $lims_product_variant_data = ProductVariant::select('id', 'variant_id', 'qty')->FindExactProductWithCode($id, $product_code[$i])->first();
                $product_sale['variant_id'] = $lims_product_variant_data->variant_id;
            }
            // if($lims_product_data->is_batch && $product_batch_id[$i]) {
            //     $product_sale['product_batch_id'] = $product_batch_id[$i];
            // }

            if($data['sale_status'] == 1) {
                if($lims_sale_unit_data->operator == '*')
                    $quantity = $qty[$i] * $lims_sale_unit_data->operation_value;
                elseif($lims_sale_unit_data->operator == '/')
                    $quantity = $qty[$i] / $lims_sale_unit_data->operation_value;
                //deduct quantity
                $lims_product_data->qty = $lims_product_data->qty - $quantity;
                $lims_product_data->save();
                //deduct product variant quantity if exist
                if($lims_product_data->is_variant) {
                    $lims_product_variant_data->qty -= $quantity;
                    $lims_product_variant_data->save();
                    $lims_product_warehouse_data = Product_Warehouse::FindProductWithVariant($id, $lims_product_variant_data->variant_id, $data['warehouse_id'])->first();
                }
                // elseif($product_batch_id[$i]) {
                //     $lims_product_warehouse_data = Product_Warehouse::where([
                //         ['product_batch_id', $product_batch_id[$i] ],
                //         ['warehouse_id', $data['warehouse_id'] ]
                //     ])->first();
                //     $lims_product_batch_data = ProductBatch::find($product_batch_id[$i]);
                //     //deduct product batch quantity
                //     $lims_product_batch_data->qty -= $quantity;
                //     $lims_product_batch_data->save();
                // }
                else {
                    $lims_product_warehouse_data = Product_Warehouse::FindProductWithoutVariant($id, $data['warehouse_id'])->first();
                }
                //deduct quantity from warehouse
                $lims_product_warehouse_data->qty -= $quantity;
                $lims_product_warehouse_data->save();
            }
        }
        else
            $sale_unit_id = 0;

        if($product_sale['variant_id']) {
            $variant_data = Variant::select('name')->find($product_sale['variant_id']);
            $mail_data['products'][$i] = $lims_product_data->name . ' ['. $variant_data->name .']';
        }
        else
            $mail_data['products'][$i] = $lims_product_data->name;
        //deduct imei number if available
        if($imei_number[$i]) {
            $imei_numbers = explode(",", $imei_number[$i]);
            $all_imei_numbers = explode(",", $lims_product_warehouse_data->imei_number);
            foreach ($imei_numbers as $number) {
                if (($j = array_search($number, $all_imei_numbers)) !== false) {
                    unset($all_imei_numbers[$j]);
                }
            }
            $lims_product_warehouse_data->imei_number = implode(",", $all_imei_numbers);
            $lims_product_warehouse_data->save();
        }
        if($lims_product_data->type == 'digital')
            $mail_data['file'][$i] = url('/public/product/files').'/'.$lims_product_data->file;
        else
            $mail_data['file'][$i] = '';
        if($sale_unit_id)
            $mail_data['unit'][$i] = $lims_sale_unit_data->unit_code;
        else
            $mail_data['unit'][$i] = '';

        $product_sale['sale_id'] = $lims_sale_data->id ;
        $product_sale['product_id'] = $id;
        $product_sale['imei_number'] = $imei_number[$i];
        $product_sale['qty'] = $mail_data['qty'][$i] = $qty[$i];
        $product_sale['sale_unit_id'] = $sale_unit_id;
        $product_sale['net_unit_price'] = $net_unit_price[$i];
        $product_sale['discount'] = $discount[$i];
        $product_sale['tax_rate'] = $tax_rate[$i];
        $product_sale['tax'] = $tax[$i];
        $product_sale['edit_warranty'] = $data['edit_warranty'][$i];
        $product_sale['total'] = $mail_data['total'][$i] = $total[$i];
        Product_Sale::create($product_sale);
    }
    if($data['sale_status'] == 3)
        $message = 'Sale successfully added to draft';
    else
        $message = ' Sale created successfully';
    if($mail_data['email'] && $data['sale_status'] == 1) {
        try {
            Mail::to($mail_data['email'])->send(new SaleDetails($mail_data));
        }
        catch(\Exception $e){
            $message = ' Sale created successfully. Please setup your <a href="setting/mail_setting">mail setting</a> to send mail.';
        }
    }

    if($data['payment_status'] == 3 || $data['payment_status'] == 4 || ($data['payment_status'] == 2 && $data['pos'] && $data['paid_amount'] > 0)) {

        $lims_payment_data = new Payment();
        $lims_payment_data->user_id = Auth::id();

        if($data['paid_by_id'] == 1)
            $paying_method = 'Cash';
        elseif ($data['paid_by_id'] == 2) {
            $paying_method = 'Gift Card';
        }
        elseif ($data['paid_by_id'] == 3)
            $paying_method = 'Credit Card';
        elseif ($data['paid_by_id'] == 4)
            $paying_method = 'Cheque';
        elseif ($data['paid_by_id'] == 5)
            $paying_method = 'Paypal';
        elseif($data['paid_by_id'] == 6)
            $paying_method = 'Deposit';
        elseif($data['paid_by_id'] == 7) {
            $paying_method = 'Points';
            $lims_payment_data->used_points = $data['used_points'];
        }

        if($cash_register_data)
            $lims_payment_data->cash_register_id = $cash_register_data->id;
        $lims_account_data = Account::where('is_default', true)->first();
        $lims_payment_data->account_id = $lims_account_data->id;
        $lims_payment_data->sale_id = $lims_sale_data->id;
        $data['payment_reference'] = 'spr-'.date("Ymd").'-'.date("his");
        $lims_payment_data->payment_reference = $data['payment_reference'];
        $lims_payment_data->amount = $data['paid_amount'];
        $lims_payment_data->change = $data['paying_amount'] - $data['paid_amount'];
        $lims_payment_data->paying_method = $paying_method;
        $lims_payment_data->payment_note = $data['payment_note'];
        $lims_payment_data->save();

        $lims_payment_data = Payment::latest()->first();
        $data['payment_id'] = $lims_payment_data->id;
        $lims_pos_setting_data = PosSetting::latest()->first();
        if($paying_method == 'Credit Card' && (strlen($lims_pos_setting_data->stripe_public_key)>0) && (strlen($lims_pos_setting_data->stripe_secret_key )>0)){

        //     Stripe::setApiKey($lims_pos_setting_data->stripe_secret_key);
        //     $token = $data['stripeToken'];
        //     $grand_total = $data['grand_total'];

        //     $lims_payment_with_credit_card_data = PaymentWithCreditCard::where('customer_id', $data['customer_id'])->first();

        //     if(!$lims_payment_with_credit_card_data) {
        //         // Create a Customer:
        //         $customer = \Stripe\Customer::create([
        //             'source' => $token
        //         ]);

        //         // Charge the Customer instead of the card:
        //         $charge = \Stripe\Charge::create([
        //             'amount' => $grand_total * 100,
        //             'currency' => 'usd',
        //             'customer' => $customer->id
        //         ]);
        //         $data['customer_stripe_id'] = $customer->id;
        //     }
        //     else {
        //         $customer_id =
        //         $lims_payment_with_credit_card_data->customer_stripe_id;

        //         $charge = \Stripe\Charge::create([
        //             'amount' => $grand_total * 100,
        //             'currency' => 'usd',
        //             'customer' => $customer_id, // Previously stored, then retrieved
        //         ]);
        //         $data['customer_stripe_id'] = $customer_id;
        //     }
        //     $data['charge_id'] = $charge->id;
        //     PaymentWithCreditCard::create($data);
         }
        elseif ($paying_method == 'Gift Card') {
            $lims_gift_card_data = GiftCard::find($data['gift_card_id']);
            $lims_gift_card_data->expense += $data['paid_amount'];
            $lims_gift_card_data->save();
            PaymentWithGiftCard::create($data);
        }
        elseif ($paying_method == 'Cheque') {
            PaymentWithCheque::create($data);
        }
        elseif ($paying_method == 'Paypal') {
            $provider = new ExpressCheckout;
            $paypal_data = [];
            $paypal_data['items'] = [];
            foreach ($data['product_id'] as $key => $product_id) {
                $lims_product_data = Product::find($product_id);
                $paypal_data['items'][] = [
                    'name' => $lims_product_data->name,
                    'price' => ($data['subtotal'][$key]/$data['qty'][$key]),
                    'qty' => $data['qty'][$key]
                ];
            }
            $paypal_data['items'][] = [
                'name' => 'Order Tax',
                'price' => $data['order_tax'],
                'qty' => 1
            ];
            $paypal_data['items'][] = [
                'name' => 'Order Discount',
                'price' => $data['order_discount'] * (-1),
                'qty' => 1
            ];
            $paypal_data['items'][] = [
                'name' => 'Shipping Cost',
                'price' => $data['shipping_cost'],
                'qty' => 1
            ];
            if($data['grand_total'] != $data['paid_amount']){
                $paypal_data['items'][] = [
                    'name' => 'Due',
                    'price' => ($data['grand_total'] - $data['paid_amount']) * (-1),
                    'qty' => 1
                ];
            }
            //return $paypal_data;
            $paypal_data['invoice_id'] = $lims_sale_data->reference_no;
            $paypal_data['invoice_description'] = "Reference # {$paypal_data['invoice_id']} Invoice";
            $paypal_data['return_url'] = url('/sale/paypalSuccess');
            $paypal_data['cancel_url'] = url('/sale/create');

            $total = 0;
            foreach($paypal_data['items'] as $item) {
                $total += $item['price']*$item['qty'];
            }

            $paypal_data['total'] = $total;
            $response = $provider->setExpressCheckout($paypal_data);
             // This will redirect user to PayPal
            return redirect($response['paypal_link']);
        }
        elseif($paying_method == 'Deposit'){
            $lims_customer_data->expense += $data['paid_amount'];
            $lims_customer_data->save();
        }
        elseif($paying_method == 'Points'){
            $lims_customer_data->points -= $data['used_points'];
            $lims_customer_data->save();
        }
    }
    $imei_number = $request->input('imei_number');

    if ($lims_customer_data->phone_number) {
        $due_amount = $lims_sale_data->grand_total - $lims_sale_data->paid_amount;
        $sms_message = 'Your sale invoice number ' . $data['reference_no'] . '. Total: Rs.' . $lims_sale_data->grand_total . '. Paid Amount: Rs.' . $lims_sale_data->paid_amount . ' . Due: Rs.' . $due_amount . '. Thanks for choosing us. www.cworldvision.lk';
        $sms_status = $this->sendSms($lims_customer_data->phone_number, $sms_message);
    }

    if($lims_sale_data->sale_status == '1')
        return redirect('sales/gen_invoice/' . $lims_sale_data->id)->with('message', $message);
    elseif($data['pos'])
        return redirect('pos')->with('message', $message);
    else
        return redirect('sales')->with('message', $message);
}

Edit Function

function edit() { $(".imei-section").remove(); if (is_imei[rowindex]) { var imeiNumbers = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('.imei-number').val(); var productID = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('.product-id').val(); // Get the correct product ID

    var htmlText =
        '<div class="col-md-12 form-group imei-section">'+
            '<label>IMEI or Serial Numbers</label>'+
            '<select name="imei_numbers[]" class="form-control form-control-sm imei-dropdown" data-product-id="'+productID+'" multiple="multiple" style="background-color: transparent; border: none;">'+
                '<option value="">Select</option>'+
            '</select>'+
        '</div>';

    $("#editModal .modal-element").append(htmlText);

    // Populate IMEI dropdown based on product ID
    populateImeiDropdownForEdit(productID, imeiNumbers);
}

var row_product_name_code = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('td:nth-child(1)').text();
$('#modal_header').text(row_product_name_code);

var qty = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('.qty').val();
$('input[name="edit_qty"]').val(qty);

$('input[name="edit_discount"]').val(parseFloat(product_discount[rowindex]).toFixed({{ $general_setting->decimal }}));

var tax_name_all = <?php echo json_encode($tax_name_all); ?>;
pos = tax_name_all.indexOf(tax_name[rowindex]);
$('select[name="edit_tax_rate"]').val(pos);

var row_product_code = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('.product-code').val();
pos = product_code.indexOf(row_product_code);
if (product_type[pos] == 'standard') {
    unitConversion();
    temp_unit_name = (unit_name[rowindex]).split(',');
    temp_unit_name.pop();
    temp_unit_operator = (unit_operator[rowindex]).split(',');
    temp_unit_operator.pop();
    temp_unit_operation_value = (unit_operation_value[rowindex]).split(',');
    temp_unit_operation_value.pop();
    $('select[name="edit_unit"]').empty();
    $.each(temp_unit_name, function(key, value) {
        $('select[name="edit_unit"]').append('<option value="' + key + '">' + value + '</option>');
    });
    $("#edit_unit").show();
} else {
    row_product_price = product_price[rowindex];
    $("#edit_unit").hide();
}
$('input[name="edit_unit_price"]').val(row_product_price.toFixed({{ $general_setting->decimal }}));

// Add the warranty field handling
var row_warranty = $('table.order-list tbody tr:nth-child(' + (rowindex + 1) + ')').find('.warranty').val();
$('input[name="edit_warranty"]').val(row_warranty);

$('.selectpicker').selectpicker('refresh');

}

Imei_numbers does not save in Database