public function totalBonuses($users, $level) { \Log::info("in totalBonuses"); $commission = CommissionLevel::where('sales_level', $level)->first(); $total = 0; foreach ($users as $user) { \Log::info("userId={$user->id}"); $sales = SalesTransactions::where('purchased_by', $user->id)->get(); foreach ($sales as $sale) { $total += $sale->pay_bonus_on_amt * $commission->percentage * 0.01; } \Log::info("total={$total}"); } return number_format($total, 2); }
public function addBonus($purchaser_id, $transaction_id, $payee_user_id, $pay_amount, $level) { $commission = CommissionLevel::where('role_id', 1)->where('sales_level', $level)->first(); $percentage = $commission->percentage; $amount = $pay_amount * $percentage * 0.01; $bonus = new Bonuses(); $bonus->purchaser_id = $purchaser_id; $bonus->transaction_id = $transaction_id; $bonus->payee_user_id = $payee_user_id; $bonus->amount = $amount; $bonus->level = $level; $bonus->save(); }