public static function OtherCharges($id, $account_id, $amount, $bill_no, $for_month, $planchange_id, $topup_id) { $othercharges = OtherCharges::where('id', $id)->first(); if (count($othercharges) != 0) { $othercharges->account_id = $account_id; $othercharges->amount = $amount; $othercharges->for_month = $for_month; $othercharges->date = date("Y-m-d"); $othercharges->save(); return $othercharges; } else { $OtherCharges = new OtherCharges(); $OtherCharges->account_id = $account_id; $OtherCharges->amount = $amount; $OtherCharges->for_month = $for_month; $OtherCharges->date = date("Y-m-d"); $OtherCharges->is_considered = 1; $OtherCharges->save(); $bill_info_new = new Billinformation(); $bill_info_new->bill_no = $bill_no; $bill_info_new->other_charges_id = $OtherCharges->id; $bill_info_new->save(); if ($planchange_id) { $plaChange = PlanChangeDetail::where('id', $planchange_id)->first(); $plaChange->other_charges_id = $OtherCharges->id; $plaChange->save(); } else { $topup = TopupDetail::where('id', $topup_id)->first(); $topup->other_charges_id = $OtherCharges->id; $topup->save(); } return $OtherCharges; } }
public static function adjustments($id, $account_id, $for_month) { $bill_no = Bill::where('account_id', '=', $account_id)->where('for_month', '=', $for_month)->get()->first(); if (!is_null($bill_no)) { $bill_info = new Billinformation(); $bill_info->adjustment_id = $id; $bill_info->bill_no = $bill_no->bill_no; $bill_info->save(); } }
function billInfo($bill_no, $account_id, $for_month) { $discount = Discount::where('account_id', '=', $account_id)->where('for_month', '=', $for_month)->get(); foreach ($discount as $key => $value) { $discount_id[] = $value->id; } $adjustment = Adjustment::where('account_id', '=', $account_id)->where('for_month', '=', $for_month)->get(); foreach ($adjustment as $key => $value) { $adjustment_id[] = $value->id; } $othercharges = OtherCharges::where('account_id', '=', $account_id)->where('for_month', '=', $for_month)->get(); foreach ($othercharges as $key => $value) { $othercharges_id[] = $value->id; } $devicecost = DeviceCost::where('account_id', '=', $account_id)->where('for_month', '=', $for_month)->get(); foreach ($devicecost as $key => $value) { $devicecost_id[] = $value->id; //var_dump($devicecost[]);die; } $discount = count($discount); $adjustment = count($adjustment); $othercharges = count($othercharges); $devicecost = count($devicecost); $maximum = max($discount, $adjustment, $othercharges, $devicecost); for ($i = 0; $i < $maximum; $i++) { $bill_info = new Billinformation(); $bill_info->bill_no = $bill_no; if (!empty($adjustment_id[$i])) { $bill_info->adjustment_id = $adjustment_id[$i]; $considered = Adjustment::where('id', '=', $adjustment_id[$i])->get()->first(); $considered->is_considered = '1'; $considered->save(); //var_dump($considered);die; } else { $bill_info->adjustment_id = 0; } if (!empty($discount_id[$i])) { $bill_info->discount_id = $discount_id[$i]; $considered = Discount::where('id', '=', $discount_id[$i])->get()->first(); $considered->is_considered = 1; $considered->save(); } else { $bill_info->discount_id = 0; } if (!empty($othercharges_id[$i])) { $bill_info->other_charges_id = $othercharges_id[$i]; $considered = OtherCharges::where('id', '=', $othercharges_id[$i])->get()->first(); $considered->is_considered = 1; $considered->save(); } else { $bill_info->other_charges_id = 0; } if (!empty($devicecost_id[$i])) { $bill_info->device_cost_id = $devicecost_id[$i]; $considered = DeviceCost::where('id', '=', $devicecost_id[$i])->get()->first(); $considered->is_considered = 1; $considered->save(); } else { $bill_info->device_cost_id = 0; } $bill_info->save(); } }