public function ResetPassworduser(Request $request) { $netasset = DB::table('TBL_USER')->Where('EMP_ID', '=', get_userID())->first(); $agent = new MeaAgent(); $data = array("session_id" => Session::getId(), "username" => $netasset->USERNAME, "old_password" => $request->input('old_password'), "new_password" => $request->input('new_password')); // var_dump($data); $curl = new Curl('CHANGE_PASS', $data); $result_login = $curl->getResult(); if ($result_login->errCode != 0) { // login fail return redirect()->to('editprofile')->withErrors(['ไม่พบชื่อ login นี้', 'The email or password you entered is incorrect.']); } else { // logged in // session(['logged_in' => true, 'user_data' => $result_login->result[0], 'access_channel' => 'frontend']); Logprocess(7, $data); return redirect()->to('editprofile')->with('message', 'ท่านได้เปลี่ยนรหัสผ่านเรียบร้อยแล้ว'); } }
public function SendMail(Request $request) { /// var_dump($request);$name = $_POST['name']; $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['PHONE']; $DEP_LNG = $_POST['DEP_LNG']; $TYPE_TOPIC = $_POST['TYPE_TOPIC']; $detail = $_POST['DETAIL']; $create_date = new Date(); $sql = "INSERT INTO tbl_inform (INFM_NAME,INFM_EMAIL,INFM_PHONE,INFM_DEPT,INFM_TOPIC,INFM_DETAIL,INFM_FLAG) VALUES('" . $name . "','" . $email . "','" . $phone . "','" . $DEP_LNG . "','" . $TYPE_TOPIC . "','" . $detail . "',0)"; $ret = DB::insert(DB::raw($sql)); $val = array("emp_id" => get_userID(), "name" => $name, "email" => $email, "phone" => $phone, "DEP_LNG" => $DEP_LNG, "TYPE_TOPIC" => $TYPE_TOPIC, "detail" => $detail); if ($ret) { Logprocess(6, $val); } // return redirect()->to('/contact')->with('message', 'ok'); }
public function deleplan(Request $request) { $sql = "DELETE FROM TBL_USER_SAVING_RATE WHERE EMP_ID = '" . get_userID() . "' AND MONTH(CHANGE_SAVING_RATE_DATE) = MONTH(GETDATE())\nAND YEAR(CHANGE_SAVING_RATE_DATE) = YEAR(GETDATE())"; $ret = DB::delete(DB::raw($sql)); if ($ret) { Logprocess(3); } return redirect()->to('/cumulative')->with('del2', 'ok'); }
public function deleplan(Request $request) { $sql = "DELETE FROM TBL_USER_FUND_CHOOSE WHERE EMP_ID = '" . get_userID() . "' AND MONTH(MODIFY_DATE) = MONTH(GETDATE())\nAND YEAR(MODIFY_DATE) = YEAR(GETDATE())"; $ret = DB::delete(DB::raw($sql)); //log if ($ret) { Logprocess(1); } return redirect()->to('/changeplan')->with('del2', 'ok'); }