public static function getActiveSessionPlans($sessions)
{
$plans = [];
if (!is_null($sessions)) {
foreach ($sessions as $user) {
switch ($user->plan_type) {
case FREE_PLAN:
$plan = Freebalance::select('expiration')->where('user_id', $user->id)->first();
$plan->plan_name = 'FRiNTERNET';
break;
case PREPAID_PLAN:
$plan = DB::table('user_recharges as r')->where('r.user_id', $user->id)->join('prepaid_vouchers as v', 'v.id', '=', 'r.voucher_id')->select('r.expiration', 'v.plan_name')->first();
break;
case ADVANCEPAID_PLAN:
$plan = DB::table("ap_active_plans as p")->join('billing_cycles as b', 'b.user_id', '=', 'p.user_id')->where('b.user_id', $user->id)->select('b.expiration', 'p.plan_name')->first();
break;
}
$plans[$user->session_id] = $plan;
}
}
return $plans;
}
