Beispiel #1
0
 /**
  * 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;
 }
Beispiel #2
0
 public function arrivals1()
 {
     return ArrivalItem::where('recipient_destination_id', Auth::user()->recipient_id)->get()->load('vaccine', 'packaging', 'arrival');
 }