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");
 }