";
echo "";
echo "| ";
echo "Template > Alarm Configuration";
echo " | ";
echo "";
//showHelp($helpId);
echo " | ";
echo "
";
echo "";
adjust_title_tail();
adjust_content_head();
echo "
";
$DEBUG = 0;
$mode = $_REQUEST['mode'];
if($DEBUG) echo "
mode=$mode";
$sysTypeNo = $_REQUEST['sysTypeNo'];
$compCode = $_REQUEST['compCode'];
$alarmCode = $_REQUEST['alarmCode'];
$alarmDesc_1 = $_REQUEST['alarmDesc_1'];
$alarmDesc_2 = $_REQUEST['alarmDesc_2'];
$alarmType = $_REQUEST['alarmType'];
$alarmLevel = $_REQUEST['alarmLevel'];
$alarmNote_1 = $_REQUEST['alarmNote_1'];
$alarmNote_2 = $_REQUEST['alarmNote_2'];
$level_1 = $_REQUEST['level_1'];
$level_2 = $_REQUEST['level_2'];
$instanceNo = $_REQUEST['instanceNo'];
$EventCode = $_REQUEST['EventCode'];
$SendAlert = $_REQUEST['SendAlert'];
$sysConfTable = 'OMC_PUB.sysConf';
$alarmDefTable = 'OMC_PUB.sysAlarmConf';
$pubDb ='OMC_PUB';
if(isset($_POST['save']) && $_POST['save'] != '-1'){
if($mode=='add'){
$saveSql = "REPLACE INTO $alarmDefTable
(sysTypeNo,compCode,alarmCode,alarmDesc_1,alarmDesc_2,alarmType,alarmLevel,
alarmNote_1,alarmNote_2,level_1 ,level_2,instanceNo,EventCode,SendAlert )
VALUES
('$sysTypeNo','$compCode','$alarmCode','$alarmDesc_1','$alarmDesc_2','$alarmType','$alarmLevel',
'$alarmNote_1','$alarmNote_2','$level_1','$level_2','$instanceNo' ,'$EventCode', '$SendAlert')
";
}else{// $mode=='edit'
$saveSql = "REPLACE INTO $alarmDefTable
(sysTypeNo,compCode,alarmCode,alarmDesc_1,alarmDesc_2,alarmType,alarmLevel,
alarmNote_1,alarmNote_2,level_1 ,level_2,instanceNo,EventCode, SendAlert )
VALUES
('$sysTypeNo','$compCode','$alarmCode','$alarmDesc_1','$alarmDesc_2','$alarmType','$alarmLevel',
'$alarmNote_1','$alarmNote_2','$level_1','$level_2','$instanceNo' ,'$EventCode', '$SendAlert')
";
}
if($DEBUG) echo "
saveSql = $saveSql";
$result = mysqli_query($pubConn,$saveSql);
echo mysqli_error($pubConn);
$mode = 'edit';
if($result > 0){
echo "
OK!";
}else{
echo "
Error!";
}
echo " ";
exit();
}elseif($mode =='delete'){
if($_POST['sureDel'] == 'Yes'){
$delSql = "DELETE FROM $alarmDefTable
WHERE sysTypeNo='$sysTypeNo' AND compCode = '$compCode'
AND alarmCode = '$alarmCode'
";
if($DEBUG) echo "
delSql = $delSql";
mysqli_query($pubConn,$delSql);
echo "
Delete ok";
echo " ";
exit();
}elseif($_POST['sureDel'] == 'No'){
echo "
Delete Canceled";
$mode='edit';
}else{
echo "Are you sure to delete this alarm?";
echo "
compCode =$compCode";
echo "
alarmCode =$alarmCode";
echo "";
exit();
}
}
if($mode == 'edit'){
$listSql = "SELECT sysTypeName,$alarmDefTable.sysTypeNo,compCode,alarmCode,alarmDesc_1,alarmDesc_2,
alarmType,alarmLevel,alarmNote_1,alarmNote_2 ,level_1 ,level_2,instanceNo,EventCode, SendAlert
FROM $sysConfTable,$alarmDefTable
WHERE $sysConfTable.sysTypeNo = $alarmDefTable.sysTypeNo
AND $alarmDefTable.sysTypeNo = '$sysTypeNo'
AND $alarmDefTable.compCode = '$compCode'
AND $alarmDefTable.alarmCode = '$alarmCode'
";
if($DEBUG) echo "
listSql = $listSql";
$listResult = mysqli_query($pubConn,$listSql);
echo mysqli_error($pubConn);
$listRows= @mysqli_fetch_array($listResult);
}
?>