public function convertGems(convertFormRequest $request)
 {
     // Get user id from form
     $id = $request->id;
     $user = User::find($id);
     // Get amount of gems to convert
     $gemsAmount = $request->gemsAmount;
     if ($user->gems >= $gemsAmount) {
         // Convert gems to money
         $converted = $gemsAmount / 100;
         // Saves new values in database
         $user->gems = $user->gems - $gemsAmount;
         $user->money = $user->money + $converted;
         $user->save();
         // Create transaction record
         $transaction = new Transactions();
         $transaction->user_id = $id;
         $transaction->username = $user->username;
         $transaction->status = 'CONVERT';
         $transaction->amount = $gemsAmount;
         $transaction->value = 'GEMS';
         $transaction->result = $converted;
         $transaction->result_value = 'POUNDS';
         $transaction->save();
         return Redirect::back()->with('convertSuccessMessage', 'You successfully converted ' . $gemsAmount . ' Gems to £' . number_format($converted, 2) . '!');
     } else {
         return Redirect::back()->with('convertErrorMessage', 'You do not have the required funds to make that conversion.');
     }
 }
 public function index()
 {
     if (Auth::check()) {
         $children = Child::where('user_group', '=', Auth::user()->user_group)->get();
     }
     $users = User::all();
     $transactions = Transactions::all()->sortByDesc('created_at')->take(20);
     return view('home', compact('users', 'transactions', 'children'));
 }
 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;
 }
 public function printTransaction(Request $request)
 {
     $transaction = Transactions::find($request->q);
     $pdf = App::make('dompdf.wrapper');
     $pdf->loadHtml(view('dompdf.wrapper', compact('transaction'))->render());
     return $pdf->stream();
     //return view('dompdf.wrapper', compact('transaction'));
 }