";
echo "";
echo "| ";
echo "Template > Menu Configuration";
echo " | ";
echo "";
//showHelp($helpId);
echo " | ";
echo "
";
echo "";
adjust_title_tail();
adjust_content_head();
echo "
";
$DEBUG = 1;
$pubDb = 'OMC_PUB';
$menuTable = 'sysMenuConf';
$elementTable = 'elementExistConf';
$maxLevelNum = 5;
//选择语言版本
if($selectedLanguage == 'eng'){
$nameField="name_2"; //语种2
}elseif ($selectedLanguage == 'chn'){
$nameField="name_1"; //语种1(默认语种)
}
/**************************************删除一个菜单***********************************************/
if($_POST['delete']){
$delSql = "DELETE FROM $menuTable WHERE keyId = '$keyId'";
$delResult = mysqli_query($pubConn ,$delSql);
echo mysqli_error($pubConn);
if($delResult){
echo $strDeleteSuccess;
}else{
echo $strDeleteFailure;
}
} //end if($delete)
/*****************************添加,修改菜单*******************************************/
if($_POST['save']){
if($keyId == 'new'){//add
$addSql = "REPLACE INTO $menuTable
(menuTypeNo,level_1,level_2,level_3,level_4,level_5,
name_1,name_2,httpLink,privilege,remark_1,remark_2)
VALUES
('0','$_POST[level_1]','$_POST[level_2]','$_POST[level_3]','$_POST[level_4]','$_POST[level_5]',
'$_POST[name_1]','$_POST[name_2]','$_POST[httpLink]','$_POST[privilege]','$_POST[remark_1]','$_POST[remark_2]')
";
if($DEBUG) echo "
$addSql";
$result = mysqli_query($pubConn ,$addSql);
echo mysqli_error($pubConn);
if($result > 0){
$getKeyIdSql =" SELECT keyId FROM $menuTable
WHERE level_1='$_POST[level_1]' AND level_2='$_POST[level_2]'
AND level_3='$_POST[level_3]' AND level_4='$_POST[level_4]' AND level_5='$_POST[level_5]' AND privilege='$_POST[privilege]'
";
if($DEBUG) echo "
$getKeyIdSql";
$result = mysqli_query($pubConn,$getKeyIdSql);
echo mysqli_error($pubConn);
$rows = mysqli_fetch_array($result);
$keyId = $rows[$keyId];
echo "
ADD OK";
}else{
echo "
ADD Failed";
}
}else{//update
$updateSql = "UPDATE $menuTable SET menuTypeNo='0', level_1='$_POST[level_1]',
level_2='$_POST[level_2]', level_3='$_POST[level_3]', level_4='$_POST[level_4]',
level_5='$_POST[level_5]', privilege='$_POST[privilege]', httpLink='$_POST[httpLink]',
name_1='$_POST[name_1]', name_2 = '$_POST[name_2]',remark_1 = '$_POST[remark_1]', remark_2 = '$_POST[remark_2]'
WHERE keyId = '$_POST[keyId]'";
if($DEBUG)
echo "
updateSql = $updateSql";
$updateResult = mysqli_query($pubConn,$updateSql);
echo mysqli_error($pubConn);
if($updateResult){
echo "
UPDATE OK";
}else{
echo "
UPDATE Failed";
}
}
}
/*****************************显示一个菜单的定义*****************************/
?>