</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 = 'Test'";
        $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 = 'Test' , 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>