public static function Update_DB() { $method = Request::input('method'); if ($method == "add") { $office_salary = new office_salary(); $pay_status = 0; $redirct_link = "add_officepayment"; } else { if ($method == "edit") { $id = Request::input('id'); $office_salary = office_salary::where('id', '=', $id)->first(); $redirct_link = "edit_officepayment/" . $id; if (count($office_salary) > 0) { $pay_status = $office_salary->pay_status; } else { $office_salary = new office_salary(); $pay_status = 0; } } } $pay_name = Request::input('pay_name'); $pay_amt = Request::input('pay_amt'); $note = Request::input('note'); $splite_user_id = explode(" ", Request::input('user_id')); $user_id = str_replace("]", "", str_replace("[", "", $splite_user_id[0])); if (!is_numeric($user_id)) { return redirect::to($redirct_link)->withInput(Request::all())->withErrors("กรุณาเลือกชื่อผู้จ่ายเงินจากรายการที่แสดง"); } $office_salary->pay_name = $pay_name; $office_salary->pay_amt = $pay_amt; $office_salary->pay_status = $pay_status; $office_salary->note = $note; $office_salary->user_id = $user_id; if ($office_salary->save()) { return redirect::to('officepayment_report/null')->with('status', "บันทึกสำเร็จ"); } else { return redirect::to($redirct_link)->with('status', "เกิดข้อผิดพลาดไม่สามารถบันทึกได้"); } }