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