public function DownloadFile($id) { $decodeid = base64_decode($id); $emp_id = get_userID(); if ($decodeid == $emp_id) { $pathURL = DB::table('tbl_control_cfg')->get()[0]->WEB_BENEFICIARY_ROOT_PATH; $pathbenefit = getenv('BENEFICIARY_PDF_PATH'); $path = public_path() . $pathbenefit; $arrfileName = $id . ".pdf"; $decodeidfilename = $decodeid . ".pdf"; $file = $path . $decodeidfilename; $headers = array('Content-Type: application/pdf'); //return redirect()->to($pathURL.$decodeidfilename); return \Response::download($file, $arrfileName, $headers); } }
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 getIndex() { $this->pageSetting(['menu_group_id' => 20, 'menu_id' => 1, 'title' => 'จัดการผู้ใช้']); $sql = "SELECT TOP 5 * FROM TBL_EMPLOYEE_INFO WHERE EMP_ID = '" . get_userID() . "'"; $empinfo = DB::select(DB::raw($sql))[0]; $sql2 = "SELECT TOP 1 * FROM TBL_USER_FUND_CHOOSE fm\nINNER JOIN TBL_INVESTMENT_PLAN pl ON pl.PlAN_ID = fm.PLAN_ID\nWHERE fm.EMP_ID = '" . get_userID() . "' ORDER BY fm.MODIFY_DATE DESC"; $planchoose = null; if (DB::select(DB::raw($sql2))) { $planchoose = DB::select(DB::raw($sql2))[0]; } $sql3 = "SELECT TOP 1 * FROM TBL_USER_SAVING_RATE WHERE EMP_ID = '" . get_userID() . "' ORDER BY CHANGE_SAVING_RATE_DATE DESC"; $savingrate = null; if (DB::select(DB::raw($sql3))) { $savingrate = DB::select(DB::raw($sql3))[0]; } $infoaset = null; $sql4 = "SELECT TOP 1 * FROM TBL_INFORMATION_FROM_ASSET WHERE EMP_ID = '" . get_userID() . "' ORDER BY CREATE_DATE DESC"; if (DB::select(DB::raw($sql4))) { $infoaset = DB::select(DB::raw($sql4))[0]; } return view('frontend.pages.overall')->with(['empinfo' => $empinfo, 'planchoose' => $planchoose, 'savingrate' => $savingrate, 'infoaset' => $infoaset]); }
function getPLanchoose() { $sql2 = "SELECT TOP 1 * FROM TBL_USER_FUND_CHOOSE fm\nINNER JOIN TBL_INVESTMENT_PLAN pl ON pl.PlAN_ID = fm.PLAN_ID\nWHERE fm.EMP_ID = '" . get_userID() . "' ORDER BY fm.MODIFY_DATE DESC"; $ret = DB::select(DB::raw($sql2)); if ($ret) { return $ret[0]; } else { return null; } }
public function postEditUser3(Request $request) { $user_id = $request->input('user_id'); $FULL_NAME = $request->input('FULL_NAME'); // $file = $request->file('pdfimport')->getClientOriginalName(); // $emp_id = explode('.',$file)[0]; // $extension = explode('.',$file)[1]; // $file_name = $emp_id . "." . $extension; $file_name = $user_id . ".pdf"; $filePath = ""; $qfileName = "SELECT WEB_BENEFICIARY_ROOT_PATH FROM TBL_CONTROL_CFG"; $datafile_name = DB::select(DB::raw($qfileName)); if ($datafile_name) { $filePath = $datafile_name[0]->WEB_BENEFICIARY_ROOT_PATH . $user_id . ".pdf"; } $TBL_USER_BENEFICIARY = DB::table('TBL_USER_BENEFICIARY')->where('EMP_ID', '=', $user_id)->get(); // var_dump($users[0]->USER_STATUS_ID); $date = new Date(); $data = array('EMP_ID' => $user_id, 'FULL_NAME' => $FULL_NAME, 'FILE_PATH' => $filePath, 'CREATE_DATE' => $date, 'CREATE_BY' => get_userID(), 'FILE_NAME' => $file_name); if ($TBL_USER_BENEFICIARY) { $ret = DB::table('TBL_USER_BENEFICIARY')->where('EMP_ID', '=', $user_id)->update($data); } else { $ret = DB::table('TBL_USER_BENEFICIARY')->insert($data); } $request->file('pdfimport')->move(public_path() . getenv('BENEFICIARY_PDF_PATH'), $file_name); return response()->json(array('success' => $ret, 'html' => "ok")); }
public function insertQuiz(Request $request) { // $sqlqtopic ="SELECT DISTINCT(QUESTION_NO),QUESTION_DESC FROM TBL_RISK_QUIZ_MANAGE"; $sqlqtopic = "SELECT DISTINCT(QUESTION_NO),QUESTION_DESC FROM TBL_RISK_QUIZ_MANAGE qm INNER JOIN TBL_RISK_QUIZ qq ON qq.QUIZ_ID = qm.QUIZ_ID WHERE qq.QUIZ_ACTIVE_FLAG = 0"; $dataqtopic = DB::select(DB::raw($sqlqtopic)); $counttopic = count($dataqtopic); $quizret = ""; $totalScore = 0; foreach ($dataqtopic as $index => $item) { // var_dump($request->input('radio_' . $item->QUESTION_NO)); $score = $request->input('radio_' . $item->QUESTION_NO); $f*g = ""; if ($score == "1") { $f*g = "A"; } if ($score == "2") { $f*g = "B"; } if ($score == "3") { $f*g = "C"; } if ($score == "4") { $f*g = "D"; } $quizret = $quizret . $item->QUESTION_NO . ":" . $f*g; if ($index + 1 < $counttopic) { $quizret = $quizret . "|"; } $totalScore = $totalScore + (int) $score; } //var_dump($quizret); $create_date = new Date(); $emp_id = get_userID(); $sql = "INSERT INTO TBL_RISK_QUIZ_RESULT (EMP_ID,QUIZ_RESULT,QUIZ_TEST_DATE,QUIZ_SCORE)\nVALUES( '" . $emp_id . "' ,'" . $quizret . "', '" . $create_date . "','" . $totalScore . "' )"; DB::insert(DB::raw($sql)); return redirect()->to('/quiz')->with('insertok', 'ok'); }
function log_in($username) { $_SESSION['ajx_org_user_id'] = get_userID($username); $_SESSION['ajx_org_username'] = $username; }
function set_userID($username) { $userID = get_userID($username); $_SESSION['userID'] = $userID; }
function Logprocess($logtype, $val = []) { $activity = ""; $value = ""; $remark = ""; switch ($logtype) { case 1: $activity = "FUND_PLAN_TERMINATE"; // [stamp ‘FUND_PLAN_TERMINATE’ ลงในฟิลด์ Activity] ยกเลกิ การเปลยี นแผนลงทนุ break; case 2: $activity = "FUND_PLAN_UPDATE"; $arr = []; $arr[0] = $val; $arrVal = array("function" => "FUND_PLAN_UPDATE", "parameters" => $arr); $remark = json_encode($arrVal); break; case 3: $activity = "SAVING_RATE_TERMINATE"; $arr = []; $arr[0] = $val; $arrVal = array("function" => "SAVING_RATE_TERMINATE", "parameters" => $arr); $remark = json_encode($arrVal); break; case 4: $activity = "SAVING_RATE_UPDATE"; $arr = []; $arr[0] = $val; $arrVal = array("function" => "SAVING_RATE_UPDATE", "parameters" => $arr); $remark = json_encode($arrVal); break; case 5: $activity = "CHANGE_USER_INFO"; $arr = []; $arr[0] = $val; $arrVal = array("function" => "CHANGE_USER_INFO", "parameters" => $arr); $remark = json_encode($arrVal); break; case 6: $activity = "INFORMER"; $arr = []; $arr[0] = $val; $arrVal = array("function" => "INFORMER", "parameters" => $arr); $remark = json_encode($arrVal); $value = ""; //(เมนตู ิดตอ่ กสช สอบถามแนะนําบริการ) [stamp ‘INFORMER’ ลง ในฟิลด์ Activityและ value (ข้อมลู ที user กรอก) ลงในฟิลด์ Remark] break; case 7: $activity = "CHANGE_PASSWORD"; break; case 8: $activity = "REQUEST_NEW_PASS"; break; } $today = new Date(); $sql = "INSERT INTO TBL_HISTORY_LOG (USERNAME,ACTIVITY, REMARK, DATETIME) VALUES ('" . get_userID() . "','" . $activity . "','" . $remark . "' , '" . $today . "')"; return DB::insert(DB::raw($sql)); }
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 getNumofPlan() { $count = "SELECT COUNT(*) AS TOTAL FROM TBL_USER_FUND_CHOOSE WHERE EMP_ID = '" . get_userID() . "' AND YEAR(MODIFY_DATE) = YEAR(GETDATE())"; return DB::select(DB::raw($count))[0]; }