Stock

stock.php

<?php


$warehouses = Warehouse::where('companies_id', $companies->id)->get();

$stock_array = [];
foreach($warehouses as $warehouse) {
    $stockIn = Stock::where('warehouse_id', $warehouse->id)->where('status', 'stock_in')->sum('kolom table qty')
    $stockOut = Stock::where('warehouse_id', $warehouse->id)->where('status', 'stock_out')->sum('kolom table qty')

    $stock_array = $stockIn - $stockOut;

}