?>
</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]);
}
