public static function getAllCommodityStockin() { return CommodityStockin::leftjoin('commodities AS c', 'c.id', '=', 'commodity_stockin.commodityID')->select('commodity_stockin.*', 'c.commodity')->get(); }
public static function getStockinSum($commodity_id) { return CommodityStockin::where('commodityID', $commodity_id)->sum("quantity"); }