/**
* 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']);
}
