</div>
<div class="clear"></div>
</div>
</div>
<?
require ('../inc_footer.php');
?>
<link rel="stylesheet" type="text/css" href="../../assets/font/ThaiSans-Neue/font.css" media="all" >
<link rel="stylesheet" type="text/css" href="../master/style.css" media="all" />
<script type="text/javascript" src="../master/script.js"></script>
<? logs_access('admin', 'hello'); ?>
<?php
if (isset($_POST["action"]) && $_POST["action"] == "submit") {
$txtNameLoc = $_POST['txtNameLoc'];
$txtNameEng = $_POST['txtNameEng'];
$txtDisplayName = $_POST['txtDisplayName'];
$txtAddress = $_POST['txtAddress'];
$province = $_POST['cmbProvince'];
$district = $_POST['cmbDistrict'];
$subDistrict = $_POST['cmbSubDistrict'];
$txtPostCode = $_POST['txtPostCode'];
$txtTelephone = $_POST['txtTelephone'];
$txtEmail = $_POST['txtEmail'];
$txtLat = $_POST['txtLat'];
$txtLon = $_POST['txtLon'];
}
if ($bannerID == '') {
$strSQL = "INSERT INTO trn_banner_pic_setting ";
$strSQL .= "(APP_MODULE_ID,DESKTOP_ICON_PATH , MOBILE_ICON_PATH,ICON_LINK ,USER_CREATE , CREATE_DATE , LAST_FUNCTION) ";
$strSQL .= " values ";
$strSQL .= "('" . $mid . "','" . $bigIconName . "','" . $smallIconName . "','" . $txtUrlLink . "' , 'Test' , now() , 'A')";
} else {
$strSQL = "update trn_banner_pic_setting ";
$strSQL .= "set DESKTOP_ICON_PATH = '" . $bigIconName . "'";
$strSQL .= " , MOBILE_ICON_PATH = '" . $smallIconName . "'";
$strSQL .= " , APP_MODULE_ID = '" . $mid . "'";
$strSQL .= " ,ICON_LINK = '" . $txtUrlLink . "'";
$strSQL .= " ,LAST_UPDATE_DATE = now() ";
$strSQL .= " ,LAST_UPDATE_USER = '******'";
$strSQL .= " ,LAST_FUNCTION = 'U'";
$strSQL .= " where BANNER_ID = '" . $bannerID . "'";
}
$objQueryBannerSetting = mysql_query($strSQL);
if ($objQueryAppModule and $objQueryBannerSetting) {
mysql_query("COMMIT");
echo "<script type='text/javascript'>window.location.href = '" . _FULL_SITE_PATH_ . $indexPage . "';</script>";
} else {
mysql_query("ROLLBACK");
echo "Error Save [" . $strSQL . "]";
}
logs_access($_SESSION['user_name'], 'Edit Module ID.' . $mid);
}
?>
</body>
</html>
<?php
require "../../assets/configs/config.inc.php";
require "../../assets/configs/connectdb.inc.php";
require "../../assets/configs/function.inc.php";
$indexPage = "/administrator/mod_module/index.php";
$moduleID = $_POST['id'];
$strSQL = "update sys_app_module set ACTIVE_FLAG = 2 , LAST_UPDATE_USER = '******' , LAST_UPDATE_DATE = now() , LAST_FUNCTION = 'U' where MODULE_ID = " . $moduleID;
logs_access($_SESSION['user_name'], 'delete Module ID.' . $moduleID);
$objQuery = mysql_query($strSQL);
if ($objQuery) {
echo "<script type='text/javascript'>window.location.href = '" . _FULL_SITE_PATH_ . $indexPage . "';</script>";
} else {
echo "Error Save [" . $strSQL . "]";
}
$insert['IMG_PATH'] = "'" . $filename . "'";
$insert['CAT_ID'] = "'" . $_POST['cmbCategory'] . "'";
$insert['ORDER_ID'] = $max++;
$sql = "INSERT INTO trn_content_picture (" . implode(",", array_keys($insert)) . ") VALUES (" . implode(",", array_values($insert)) . ")";
mysql_query($sql, $conn) or die($sql);
}
}
if (count($_POST['order_position']) > 0) {
foreach ($_POST['order_position'] as $k => $val) {
$update = "";
$update[] = "ORDER_ID = " . $val;
$sql = "UPDATE trn_content_picture SET " . implode(",", $update) . " WHERE PIC_ID =" . $k;
mysql_query($sql, $conn) or die($sql);
}
}
logs_access($_SESSION['user_name'], 'EDIT Content ID.' . $conid);
header('Location: ' . $returnPage);
}
if (isset($_POST['catID'])) {
$subCatSql = "select sc.SUB_CONTENT_CAT_ID , sc.SUB_CONTENT_CAT_DESC_LOC , sc.SUB_CONTENT_CAT_DESC_ENG\n\t\t\t\t\t\t\t\t\t\t\t from trn_content_sub_category sc\n\t\t\t\t\t\t\t\t\t\t\twhere sc.CONTENT_CAT_ID = '{$catID}' and sc.flag <> 2\n\t\t\t\t\t\t\t\t\t\t\tORDER BY sc.ORDER_DATA desc ";
// echo $subCatSql;
$subCatQuery = mysql_query($subCatSql, $conn);
$retStr = "<select id='cmbSubCategory' name = 'cmbSubCategory'>";
$retStr .= "<option value='-1'>กรุณาเลือกหมวดหมู่ย่อย</option>";
while ($rowSubCat = mysql_fetch_array($subCatQuery)) {
$retStr .= "<option value='" . $rowSubCat["SUB_CONTENT_CAT_ID"] . "' >" . $rowSubCat["SUB_CONTENT_CAT_DESC_LOC"] . "</option>";
}
mysql_free_result($subCatQuery);
$retStr .= "</select>";
echo $retStr;
//echo "Come In".$catID ;
}
mysql_query("BEGIN");
$sql_max = "SELECT MAX( ORDER_DATA ) AS MAX_ORDER FROM sys_app_module where ACTIVE_FLAG <> 2 AND IS_FOR_OTHER_LINK = 'N' ";
$query_max = mysql_query($sql_max, $conn);
$row_max = mysql_fetch_array($query_max);
$max = $row_max['MAX_ORDER'];
$max++;
$strSQL = "INSERT INTO sys_app_module ";
$strSQL .= "(MODULE_NAME_LOC,MODULE_NAME_ENG , USER_CREATE , CREATE_DATE , LAST_FUNCTION , IS_LAST_NODE , ORDER_DATA , RENDER_ON_FRONT , IS_FOR_OTHER_LINK , LINK_URL) ";
$strSQL .= "VALUES ";
$strSQL .= "('" . $txtNameLoc . "','" . $txtNameEng . "','Test' , now() , 'A' , '" . $isLastNode . "' , " . $max . " , '" . $showOnMenu . "' ,'N' , '" . $txtUrlLink . "') ";
$objQueryAppModule = mysql_query($strSQL);
$last_id = mysql_insert_id($conn);
$strSQL = "INSERT INTO trn_banner_pic_setting ";
$strSQL .= "(APP_MODULE_ID , DESKTOP_ICON_PATH , MOBILE_ICON_PATH ,ICON_LINK ,USER_CREATE , CREATE_DATE , LAST_FUNCTION) ";
$strSQL .= " values ";
$strSQL .= "('" . $last_id . "','" . $bigIconName . "','" . $smallIconName . "','" . $txtUrlLink . "' , 'Test' , now() , 'A')";
$objQueryBannerSetting = mysql_query($strSQL);
if ($objQueryAppModule and $objQueryBannerSetting) {
mysql_query("COMMIT");
echo "<script type='text/javascript'>window.location.href = '" . _FULL_SITE_PATH_ . $indexPage . "';</script>";
} else {
mysql_query("ROLLBACK");
echo "Error Save [" . $strSQL . "]";
}
logs_access($_SESSION['user_name'], 'Add Module');
}
?>
</body>
</html>
