";
echo "";
echo "| ";
echo "Template > Subscriber > Manage Define";
echo " | ";
echo "";
//showHelp($helpId);
echo " | ";
echo "
";
echo "";
adjust_title_tail();
adjust_content_head();
echo "
";
$DEBUG = 0;
$keyId = isset($keyId)?$keyId:1;
$dbName = 'OMC_PUB';
$tableName = 'sysSubsConf';
$maxLevelNum = 5;
//选择语言版本
if($language == 'eng'){
$nameField=name_2; //语种2
}else{
$nameField=name_1; //语种1(默认语种)
}
/**************************************删除一条记录***********************************************/
if($delete){
$delSql = "DELETE FROM $tableName WHERE keyId = '$keyId'";
$delResult = mysqli_query($pubConn ,$delSql);
echo mysqli_error($pubConn);
if($delResult){
echo $strDeleteSuccess;
}else{
echo $strDeleteFailure;
}
//插入日志
//缺！！
} //end if($delete)
/*****************************添加,修改记录*******************************************/
if($save){
if($keyId == 'new'){//add
$addSql = "REPLACE INTO $tableName
(keyId,sysTypeNo,dataTypeNo,isEnable,preObjId,indexObjId,indexFieldName,
maxSegmentNum,maxIndexNumPerSeg, subsDataTable,tmpDataTable,menuName,
ftpLoginName,ftpLoginPwd,ftpDir,impObjId,impFileName,logFileName)
VALUES
('$keyId','$sysTypeNo','$dataTypeNo','$isEnable','$preObjId','$indexObjId','$indexFieldName',
'$maxSegmentNum','$maxIndexNumPerSeg','$subsDataTable','$tmpDataTable','$menuName',
'$ftpLoginName','$ftpLoginPwd','$ftpDir','$impObjId','$impFileName','$logFileName')
";
if($DEBUG) echo "
$addSql";
$result = mysqli_query($pubConn ,$addSql);
echo mysqli_error($pubConn);
if($result > 0){
$getKeyIdSql =" SELECT keyId FROM $tableName
WHERE sysTypeNo = '$sysTypeNo'
AND dataTypeNo='$dataTypeNo'
AND isEnable='$isEnable'
";
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 $tableName SET
sysTypeNo='$sysTypeNo',dataTypeNo='$dataTypeNo',isEnable='$isEnable',preObjId='$preObjId',
indexObjId='$indexObjId',indexFieldName='$indexFieldName',maxSegmentNum='$maxSegmentNum',
maxIndexNumPerSeg='$maxIndexNumPerSeg',subsDataTable='$subsDataTable',
tmpDataTable='$tmpDataTable',menuName='$menuName',ftpLoginName='$ftpLoginName',
ftpLoginPwd='$ftpLoginPwd',ftpDir='$ftpDir',impObjId='$impObjId',impFileName='$impFileName',
logFileName='$logFileName'
WHERE keyId = '$keyId'";
if($DEBUG) echo "
updateSql = $updateSql";
$updateResult = mysqli_query($pubConn,$updateSql);
echo mysqli_error($pubConn);
if($updateResult){
echo "
UPDATE OK";
}else{
echo "
UPDATE Failed";
}
}
}
/*****************************显示一个菜单的定义*****************************/
?>