How to add laravel array value and update if there is a change

To handle the operations you described (adding, updating, and deleting subtotals) in a Laravel application, you can use a combination of PHP array functions and Laravel's collection methods. Here's a step-by-step solution:

1. Calculate the Total Subtotal: You can sum up the sub_total values using the array_sum function or Laravel's Collection methods.

2. Update Subtotal: If you need to update a specific entry, you can iterate over the array, find the entry by inventory_in_store_id, and update its values.

3. Delete an Entry: You can remove an entry by filtering the array based on inventory_in_store_id.

Here's a code example demonstrating these operations:

<?php

// Initial array
$inventory = [
    [
        "inventory_in_store_id" => "1",
        "quantity" => "10",
        "unit_price" => "12",
        "sub_total" => 120
    ],
    [
        "inventory_in_store_id" => "2",
        "quantity" => "5",
        "unit_price" => "12",
        "sub_total" => 60
    ]
];

// Function to calculate total subtotal
function calculateTotalSubtotal($inventory) {
    return array_sum(array_column($inventory, 'sub_total'));
}

// Function to update an entry
function updateEntry(&$inventory, $id, $newQuantity, $newUnitPrice) {
    foreach ($inventory as &$item) {
        if ($item['inventory_in_store_id'] == $id) {
            $item['quantity'] = $newQuantity;
            $item['unit_price'] = $newUnitPrice;
            $item['sub_total'] = $newQuantity * $newUnitPrice;
            break;
        }
    }
}

// Function to delete an entry
function deleteEntry(&$inventory, $id) {
    $inventory = array_filter($inventory, function($item) use ($id) {
        return $item['inventory_in_store_id'] != $id;
    });
    // Re-index the array
    $inventory = array_values($inventory);
}

// Calculate total subtotal
$totalSubtotal = calculateTotalSubtotal($inventory);
echo "Total Subtotal: $totalSubtotal\n";

// Update an entry
updateEntry($inventory, "1", 15, 12);
$totalSubtotal = calculateTotalSubtotal($inventory);
echo "Total Subtotal after update: $totalSubtotal\n";

// Delete an entry
deleteEntry($inventory, "2");
$totalSubtotal = calculateTotalSubtotal($inventory);
echo "Total Subtotal after deletion: $totalSubtotal\n";

Explanation:

• calculateTotalSubtotal: This function calculates the total of all sub_total values in the array.
• updateEntry: This function updates the quantity, unit_price, and recalculates the sub_total for a specific inventory_in_store_id.
• deleteEntry: This function removes an entry from the array based on inventory_in_store_id and re-indexes the array to maintain sequential keys.

You can adapt these functions to fit into your Laravel application, possibly integrating them into a service class or a controller method depending on your architecture.