Stored Item Movement Thingy

[KirinZero0]

Migrations

stored_item_movements

• add stored_item_audit_delta_id
• add stored_item_audit_id
• add pallet_delivery_id
• add pallet_return_id
• add pallet_id
• add pallet_return_item_id

stored_items

• add total_quantity

Mechanism

like a typical audit function

Whenever theres an audit delta or adding new pallet with stored items or returning stored items, a stored item movement should be created. In stored item movement quantity should reflect on the parent eg: audit could be -/+ , delivery should be + and return should be -. Total quantity of the all movement history should be the same to the stored item total quantity (current_quantity). And if its returning a few stored item , i should also update the pivot pallet_stored_items table.

Actions

StoreStoredItemMovement
CalculateStoredItemTotalQuantity