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();
}
