/** * get received_items. * * @return Response */ public function receivItems() { $dispatch = ArrivalItem::where('recipient_destination_id', Auth::user()->recipient_id)->select('vaccine_id', DB::raw('sum(number_received) as total'))->groupBy('vaccine_id')->get(); // $dispatch = RecipientPackageItem::where('recipient_id',Auth::user()->recipient_id)->select('vaccine_id', DB::raw('sum(amount) as total'),DB::raw('month(created_at) as month')) // ->groupBy('month') // ->get(); return $dispatch; }
public function arrivals1() { return ArrivalItem::where('recipient_destination_id', Auth::user()->recipient_id)->get()->load('vaccine', 'packaging', 'arrival'); }