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];
}
