public static function undoRemoveBill($billId) { if (Auth::user()->id) { $user = userBills::find($billId); $user->flg = 1; $user->save(); } }
public static function upcomingBill($paid_status = null) { $data = \App\userBills::where('user_bills.flg', 1)->where('uid', Auth::user()->id); // ->where('user_bills.is_paid',0) if ($paid_status != null) { $data->where('user_bills.is_paid', $paid_status); } $data->join('category_core', 'user_bills.cate_id', '=', 'category_core.id')->where('category_core.flg', 1)->select('user_bills.id as id', 'user_bills.amount', 'user_bills.is_paid', 'user_bills.due_date', 'category_core.name')->orderBy('user_bills.due_date', 'asc'); return json_encode($data->get()); }
public static function undoRemoveBills(Request $request) { if (Auth::user()) { //Remove bill \App\userBills::undoRemoveBill($request->billId); //Update to users table \App\userBills::updateBillAmount(); return \App\userBills::get(); } }
public function billStatus(Request $request) { if (Auth::user()) { return \App\userBills::upcomingBill($request->bill_status); } }