?> </p> <p class="textbox-text-area"><span class="textbox-text">種類</span></p> <!-- <select name="kind"> --> <p class="textbox-area"><?php require_once "../../php/common/get_kind_list.php"; ?> </p> <p class="textbox-text-area"><span class="textbox-text">金額</span></p> <p class="textbox-area"><input type="text" name="price" value="" class="textbox"></p> <?php require_once "../../php/common/get_date.php"; ?> <p class="textbox-text-area"><span class="textbox-text">決済年</span></p> <p class="textbox-area"><input type="text" name="pay_date_year" value="<?php get_date_year(); ?> " class="textbox"></p> <p class="textbox-text-area"><span class="textbox-text">決済月</span></p> <p class="textbox-area"><input type="text" name="pay_date_mouth" value="<?php get_date_mouth(); ?> " class="textbox"></p> <p class="textbox-text-area"><span class="textbox-text">決済日</span></p> <p class="textbox-area"><input type="text" name="pay_date_day" value="<?php get_date_day(); ?> " class="textbox"></p> <p class="textbox-text-area"><span class="textbox-text">決済方法</span></p> <!-- <select name="pay_method_name"> --> <p class="textbox-area"><?php
function checkShowList_valid($validata, $dateCompare) { $ret = false; $today = new Date(); $arrmaxdate = explode('-', $validata); $max = $arrmaxdate[1]; $datecheck = new Date($dateCompare); //return $create_date->add('543 years')->format('j F Y'); if ($today > $datecheck) { $ret = true; } if (get_date_month($today) == get_date_month($datecheck) && get_date_year($today) == get_date_year($datecheck)) { if ((int) get_date_day($today) <= (int) $max) { $ret = false; } } return $ret; }
function getYearDrop($year) { $today = new Date(); $currentyear = get_date_year($today); $arrDropYear = array(); $count = 0; if ($year) { $ret = "<option value='' >เลือกปี</option>"; } else { $ret = "<option selected='selected' value='' >เลือกปี</option>"; } for ($i = (int) $currentyear - 5; $i <= $currentyear; $i++) { $arrDropYear[$count] = $i; if ($year) { if ($year == $i - 543) { $ret = $ret . "<option selected='selected' value=" . ($i - 543) . ">" . $i . "</option>"; } else { $ret = $ret . "<option value=" . ($i - 543) . ">" . $i . "</option>"; } } else { $ret = $ret . "<option value=" . ($i - 543) . ">" . $i . "</option>"; } $count = $count + 1; } return $ret; }
public function getIndexbysearch(Request $request) { $this->pageSetting(['menu_group_id' => 23, 'menu_id' => 1, 'title' => 'ข้อมูลอัตราสะสม MEA FUND']); $sqlchk = "SELECT * FROM TBL_CONTROL_CFG"; $dataCheck = DB::select(DB::raw($sqlchk))[0]; // saving_rate_change_period // var_dump(session()->get('user_data')->saving_rate_change_period); //access_status_flag $sql = "SELECT TOP 1 * 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())"; $CurrnentPlan = DB::select(DB::raw($sql)); $sql4 = "SELECT TOP 1 * FROM TBL_USER_SAVING_RATE WHERe EMP_ID = '" . get_userID() . "' ORDER BY EFFeCTIVE_DATE DESC"; $effective = DB::select(DB::raw($sql4)); $sql2 = "SELECT * FROM TBL_SAVING_RATE_INFO"; $Workcheck = DB::select(DB::raw($sql2))[0]; $sql3 = "SELECT TOP 1 * FROM TBL_MEMBER_BENEFITS WHERE EMP_ID = '" . get_userID() . "' ORDER BY RECORD_DATE DESC"; $Workhrs = DB::select(DB::raw($sql3)); $sql5 = "SELECT USER_PRIVILEGE_DESC FROM tbl_USER us\nINNER JOIN tbl_privilege pi ON pi.USER_PRIVILEGE_ID = us.USER_PRIVILEGE_ID\nWHERE us.EMP_ID = '" . get_userID() . "'"; $users = DB::select(DB::raw($sql5))[0]; $sqlhis = "SELECT * FROM TBL_EMPLOYEE_INFO emp\nINNER JOIN TBL_USER_SAVING_RATE sav ON sav.EMP_ID = emp.EMP_ID\nWHERe YEAR(sav.CHANGE_SAVING_RATE_DATE) = '" . $request->input('drop_year') . "' AND sav.EMP_ID = '" . get_userID() . "' ORDER BY sav.CHANGE_SAVING_RATE_DATE DESC"; $historyPlan = DB::select(DB::raw($sqlhis)); $ishowhis = true; $currentyear = ""; if ($CurrnentPlan) { $currentyear = get_date_year($CurrnentPlan[0]->CHANGE_SAVING_RATE_DATE); } else { $currentyear = get_date_year($effective[0]->CHANGE_SAVING_RATE_DATE); } $sqlhisall = "SELECT * FROM TBL_EMPLOYEE_INFO emp\nINNER JOIN TBL_USER_SAVING_RATE sav ON sav.EMP_ID = emp.EMP_ID\nWHERe sav.EMP_ID = '" . get_userID() . "' ORDER BY sav.CHANGE_SAVING_RATE_DATE DESC"; $historyPlanAll = DB::select(DB::raw($sqlhisall)); //Generate Drop $colObj = collect($historyPlanAll); $max = null; $min = null; $max = $colObj->max('CHANGE_SAVING_RATE_DATE'); $min = $colObj->min('CHANGE_SAVING_RATE_DATE'); $dateMin = new Date($min); $dateMax = new Date($max); $yearMin = date("Y", strtotime($dateMin)); $yearMax = date("Y", strtotime($dateMax)); $intYearhMin = intval($yearMin) + 543; $intYearhMax = intval($yearMax) + 543; $arrDropYear = array(); $count = 0; $ret = "<option value='1990'>เลือกปี</option>"; for ($i = $intYearhMin; $i <= $intYearhMax; $i++) { $arrDropYear[$count] = $i; if ($i - 543 == (int) $request->input('drop_year')) { $ret = $ret . "<option selected='selected' value=" . ($i - 543) . ">" . $i . "</option>"; } else { $ret = $ret . "<option value=" . ($i - 543) . ">" . $i . "</option>"; } $count = $count + 1; } $sql44 = "SELECT TOP 1 * FROM TBL_INFORMATION_FROM_ASSET WHERE EMP_ID = '" . get_userID() . "' ORDER BY CREATE_DATE DESC"; $infoaset = DB::select(DB::raw($sql44))[0]; $sql111 = "SELECT TOP 5 * FROM TBL_EMPLOYEE_INFO WHERE EMP_ID = '" . get_userID() . "'"; $empinfo = DB::select(DB::raw($sql111))[0]; $sql222 = "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 = DB::select(DB::raw($sql222))[0]; $Isaccess = true; $arrpages = explode("-", $dataCheck->SAVING_RATE_CHANGE_PERIOD); $Modify_count = 0; $today = new Date(); $datetoday = date("d", strtotime($today)); if ($datetoday < $arrpages[0] || $datetoday > $arrpages[1]) { $Isaccess = false; } return view('frontend.pages.23p1')->with(['CurrnentPlan' => $CurrnentPlan, 'dataCheck' => $dataCheck, 'effective' => $effective, 'Workcheck' => $Workcheck, 'users' => $users, 'historyPlan' => $historyPlan, 'ishowhis' => $ishowhis, 'ret' => $ret, 'infoaset' => $infoaset, 'empinfo' => $empinfo, 'planchoose' => $planchoose, 'Isaccess' => $Isaccess]); }
public function getIndex() { $this->pageSetting(['menu_group_id' => 22, 'menu_id' => 1, 'title' => 'แผนการลงทุน MEA FUND']); $numberofchange = $this->getNumofPlan()->TOTAL; $sql5 = "SELECT USER_PRIVILEGE_DESC FROM tbl_USER us\nINNER JOIN tbl_privilege pi ON pi.USER_PRIVILEGE_ID = us.USER_PRIVILEGE_ID\nWHERE us.EMP_ID = '" . get_userID() . "'"; $users = DB::select(DB::raw($sql5))[0]; $sqlchk = "SELECT * FROM TBL_CONTROL_CFG"; $dataCheck = DB::select(DB::raw($sqlchk))[0]; //history $sqlhis = "SELECT uc.MODIFY_COUNT,uc.MODIFY_DATE,uc.EMP_ID,enf.FULL_NAME ,uc.PLAN_ID , pl.PLAN_NAME ,uc.DEBT_RATE\n,uc.EQUITY_RATE,uc.EFFECTIVE_DATE, ROW_NUMBER() OVER (ORDER BY uc.MODIFY_DATE DESC) AS rownum\nFROM TBL_EMPLOYEE_INFO enf\nINNER JOIN TBL_USER_FUND_CHOOSE uc ON uc.EMP_ID = enf.EMP_ID\nINNER JOIN TBL_INVESTMENT_PLAN pl ON pl.PLAN_ID =uc.PLAN_ID\nWHERE GETDATE() > pl.PLAN_ACTIVE_DATE AND GETDATE() < pl.PLAN_EXPIRE_DATE AND enf.EMP_ID ='" . get_userID() . "' "; $historyPlan = DB::select(DB::raw($sqlhis)); $dropplan = DB::table('TBL_INVESTMENT_PLAN')->where('PLAN_ACTIVE_FLAG', '=', '0')->get(); $sql = "SELECT TOP 1 * FROM TBL_USER_FUND_CHOOSE pl\n INNER JOIN TBL_INVESTMENT_PLAN ip ON ip.plan_id = pl.plan_id\n wHERE pl.EMP_ID = '" . get_userID() . "' AND (MONTH(pl.MODIFY_DATE) = MONTH(GETDATe()) AND YEAR(pl.MODIFY_DATE) = YEAR(GETDATE()))\n ORDER BY pl.Modify_DATE DESC"; $CurrnentPlan = DB::select(DB::raw($sql)); $sql4 = "SELECT TOP 1 * FROM TBL_USER_FUND_CHOOSE pl\n INNER JOIN TBL_INVESTMENT_PLAN ip ON ip.plan_id = pl.plan_id\n wHERE pl.EMP_ID = '" . get_userID() . "'\n ORDER BY pl.Modify_DATE DESC"; $effective = DB::select(DB::raw($sql4)); $sql2 = "SELECT TOP 1 * FROM TBL_INFORMATION_FROM_ASSET WHERE EMP_ID = '" . get_userID() . "' ORDER BY Create_DATE DESC"; $Currnentasset = null; $ret = null; $infoaset = null; $empinfo = null; $planchoose = null; $Isaccess = null; $Currnentasset_db = DB::select(DB::raw($sql2)); $Currnentasset = null; if ($Currnentasset_db) { $Currnentasset = $Currnentasset_db[0]; } $currentyear = "2016"; if ($CurrnentPlan) { $currentyear = get_date_year($CurrnentPlan[0]->MODIFY_DATE); } else { if ($effective) { $currentyear = get_date_year($effective[0]->MODIFY_DATE); } } //Generate Drop $colObj = collect($historyPlan); $max = null; $min = null; $max = $colObj->max('MODIFY_DATE'); $min = $colObj->min('MODIFY_DATE'); $dateMin = new Date($min); $dateMax = new Date($max); $yearMin = date("Y", strtotime($dateMin)); $yearMax = date("Y", strtotime($dateMax)); $intYearhMin = intval($yearMin) + 543; $intYearhMax = intval($yearMax) + 543; $arrDropYear = array(); $count = 0; $ret = "<option selected='selected' value='1990'>เลือกปี</option>"; for ($i = $intYearhMin; $i <= $intYearhMax; $i++) { $arrDropYear[$count] = $i; $ret = $ret . "<option value=" . ($i - 543) . ">" . $i . "</option>"; $count = $count + 1; } $sql44 = "SELECT TOP 1 * FROM TBL_INFORMATION_FROM_ASSET WHERE EMP_ID = '" . get_userID() . "' ORDER BY CREATE_DATE DESC"; $infoaset = null; $infoaset_db = DB::select(DB::raw($sql44)); if ($infoaset_db) { $infoaset = $infoaset_db[0]; } $sql111 = "SELECT TOP 5 * FROM TBL_EMPLOYEE_INFO WHERE EMP_ID = '" . get_userID() . "'"; $empinfo = DB::select(DB::raw($sql111))[0]; $sql222 = "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_profile = DB::select(DB::raw($sql222)); $planchoose = null; if ($planchoose_profile) { $planchoose = $planchoose_profile[0]; } $Isaccess = true; $arrpages = explode("-", $dataCheck->FUND_PLAN_CHANGE_PERIOD); $Modify_count = 0; $today = new Date(); $datetoday = date("d", strtotime($today)); if ($datetoday < $arrpages[0] || $datetoday > $arrpages[1]) { $Isaccess = false; } $q = "SELECT * FROM TBL_RISK_QUIZ_RESULT WHERe EMP_ID = '" . get_userID() . "' AND YEAR(QUIZ_TEST_DATE) = YEAR(GETDATE())"; $quizdoit = DB::select(DB::raw($q)); return view('frontend.pages.22p1')->with(['dropplan' => $dropplan, 'CurrnentPlan' => $CurrnentPlan, 'Currnentasset' => $Currnentasset, 'historyPlan' => $historyPlan, 'dataCheck' => $dataCheck, 'effective' => $effective, 'users' => $users, 'ishowhis' => false, 'ret' => $ret, 'infoaset' => $infoaset, 'empinfo' => $empinfo, 'planchoose' => $planchoose, 'Isaccess' => $Isaccess, 'quizdoit' => $quizdoit, 'numberofchange' => $numberofchange]); }