</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>