/** * Execute the console command. * * @return mixed */ public function handle() { //Scheduler work - which is set up by every 30 min in Kernel.php //Decreament balance of every user by 10 unit $users_having_money = DB::table('users')->join('payments', 'users.id', '=', 'payments.user_id')->select('users.id as user_id', DB::raw('sum(payments.money_amount) as total'))->groupBy('users.id')->get(); foreach ($users_having_money as $key => $value) { $balance = new Balance(); if ($value->total > 10) { $balance->money_amount = -10; } else { if ($value->total !== 0) { $balance->money_amount = -$value->total; } } $balance->transection_by = 'system'; $balance->user_id = $value->user_id; $balance->save(); } }
public function add_balance() { $requestData = Request::all(); $balance = new Balance(); $balance->user_id = Auth::user()->id; $balance->money_amount = $requestData['balance']; $balance->transection_by = 'user'; $balance->save(); return Redirect::back()->withErrors(['Balance Successfully Added']); }