Exemplo n.º 1
0
 public function index($username)
 {
     $user = User::where('username', $username)->firstOrFail();
     $id = $user->id;
     $transactions = Transactions::where('user_id', '=', $id)->orderBy('created_at', 'desc')->take(5)->get();
     return view('user.profile', compact('user', '=', 'userCurrency', 'transactions'));
 }
Exemplo n.º 2
0
 private function getSalesInfo($month)
 {
     $result = array();
     $buyers = array();
     $buyers_total = array();
     $data = Transactions::where(DB::raw('MONTH(created_at)'), '=', $month)->get();
     foreach ($data as $t) {
         $buyers = array_add($buyers, $t->buyer->name, Transactions::where(DB::raw('MONTH(created_at)'), '=', $month)->where('buyer_id', $t->buyer->id)->count());
         $buyers_total = array_add($buyers_total, $t->buyer->name, Transactions::where(DB::raw('MONTH(created_at)'), '=', $month)->where('buyer_id', $t->buyer->id)->sum('sub_total'));
     }
     $result = array_add($result, 'buyers', $buyers);
     $result = array_add($result, 'buyers_total', $buyers_total);
     return $result;
 }