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