query($sql);
echo "Insert Success!!";
}
if($_REQUEST["action"] == "deleteTmc"){
$sql = "DELETE FROM rg_TermConfig WHERE tmcAcY = '" . $_REQUEST["tmcAcY"] . "' AND tmcTmId = '" . $_REQUEST["tmcTmId"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getTmcById"){
$sql = "SELECT * FROM rg_TermConfig WHERE tmcAcY = '".$_REQUEST["tmcAcY"]."' AND tmcTmId = '".$_REQUEST["tmcTmId"]."'";
$link->query($sql);
echo json_encode($link->getnext());
}
if($_REQUEST["action"] == "getTmcAll"){
$sql = "SELECT * FROM rg_TermConfig rtmc
LEFT JOIN rg_Term rtm ON rtm.tmId = rtmc.tmcTmId
ORDER BY rtmc.tmcAcY Desc, rtmc.tmcTmId ASC";
$link->query($sql);
while($data = $link->getnext()){
$opt = "";
$opt .= " ";
$json["data"][] = array("tmcAcY"=>$data->tmcAcY,"tmName"=>$data->tmName,"tmcFrDate"=>thai_date_fullmonth(strtotime($data->tmcFrDate)),"tmcToDate"=>thai_date_fullmonth(strtotime($data->tmcToDate)), "opt"=>$opt);
}
echo json_encode($json);
}
if($_REQUEST["action"] == "updateTmc"){
$sql = "UPDATE rg_TermConfig SET tmcFrDate='" . $_REQUEST["tmcFrDate"] . "', tmcToDate='" . $_REQUEST["tmcToDate"] . "' WHERE tmcAcY = '".$_REQUEST["tmcAcY"]."' AND tmcTmId = '".$_REQUEST["tmcTmId"]."'";
$link->query($sql);
echo "Update Success!!";
}
?>