📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>工资项目</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.ITEM_NAME.value==\"\")\r\n { alert(\"工资项目名称不能为空！\");\r\n return (false);\r\n }\r\n}\r\n\r\n function sel_change(input)\r\n {\r\n\r\n \tif(form1.ITEM_TYPE.value==\"2\")\r\n {\r\n \tdocument.all(\"FORMU\").style.display=\"\";\r\n }\r\n else\r\n \t{\r\n \t\tdocument.all(\"FORMU\").style.display=\"none\";\r\n \t\tdocument.form1.FORMULA.value=\"\";\r\n \t\tdocument.form1.FORMULANAME.value=\"\";\r\n \t}\r\n\r\n }\r\n\r\nfunction LoadWindow2()\r\n{\r\n URL=\"formula_edit.php\";\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction delete_all()\r\n{\r\n msg='确认要删除全部工资项目吗？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_all.php\";\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction show_formul(ITEM_ID)\r\n{\r\n URL=\"formula_edit.php?ITEM_ID=\"+ITEM_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n</script>\r\n</head>\r\n\r\n";
$query = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_COUNT = $ROW[0];
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\" ";
if ( $ITEM_COUNT < 50 )
{
echo "onload='document.form1.ITEM_NAME.focus();'";
}
echo ">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 添加工资项目</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<div align=\"center\" class=\"big1\">\r\n<b>\r\n\t<table width=\"450\" class=\"TableBlock\" align=\"center\" >\r\n <form action=\"add.php\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n <tr>\r\n <td nowrap class=\"TableContent\">工资项目名称：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"ITEM_NAME\" class=\"BigInput\" size=\"30\" maxlength=\"100\" ";
if ( 50 <= $ITEM_COUNT )
{
echo disabled;
}
echo ">\r\n <input type=\"hidden\" name=\"ITEM_ID\" value=\"";
echo $ITEM_COUNT + 1;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">项目类型： </td>\r\n <td nowrap class=\"TableData\">\r\n \t <select name=\"ITEM_TYPE\" class=\"BigSelect\" onChange=\"sel_change()\">\r\n <option value=\"0\">财务录入项</option>\r\n <option value=\"1\">部门上报项</option>\r\n <option value=\"2\">计算项</option>\r\n </select>\r\n </td>\r\n </tr>\r\n\r\n <tr id=\"FORMU\" style=\"display:none\">\r\n <td nowrap class=\"TableContent\">计算公式：</td>\r\n <td nowrap class=\"TableData\">\r\n \t<input type=\"hidden\" name=\"FORMULA\">\r\n \t<textarea cols=37 name=\"FORMULANAME\" rows=\"4\" class=\"BigStatic\" readonly wrap=\"yes\"></textarea> \r\n \t<input type=\"button\" value=\"编辑公式\" class=\"SmallButton\" onClick=\"LoadWindow2()\" title=\"编辑公式\" name=\"button\">\r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" nowrap>\r\n \t<input type=\"submit\" value=\"添加\" class=\"BigButton\" title=\"添加工资项目\" ";
if ( 50 <= $ITEM_COUNT )
{
echo disabled;
}
echo " name=\"button\">\r\n </td>\r\n </tfoot>\r\n </form>\r\n </table>\r\n</b>\r\n</div>\r\n\r\n<br>\r\n<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" align=\"absmiddle\"><span class=\"big3\"> 已定义的工资项目（最多50条）</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n<div align=\"center\">\r\n\r\n";
$query = "SELECT * from SAL_ITEM order by ITEM_ID";
$cursor = exequery( $connection, $query );
$ITEM_COUNT1 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ITEM_COUNT1;
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$ISPRINT = $ROW['ISPRINT'];
$ISCOMPUTER = $ROW['ISCOMPUTER'];
$FORMULA = $ROW['FORMULA'];
$FORMULANAME = $ROW['FORMULANAME'];
$ISREPORT = $ROW['ISREPORT'];
if ( $ISREPORT == "1" )
{
$ITEMSET = "部门上报项";
}
else if ( $ISCOMPUTER == "1" )
{
$ITEMSET = "计算项";
}
else
{
$ITEMSET = "财务录入项";
}
if ( $ITEM_COUNT1 == 1 )
{
echo "\r\n <table width=\"450\" class=\"TableList\">\r\n\r\n";
}
echo " <tr class=\"TableData\">\r\n <td nowrap align=\"center\" width=\"50\">";
echo $ITEM_ID;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $ITEM_NAME;
echo "</td>\r\n <td nowrap align=\"center\">\r\n \t";
echo $ITEMSET;
echo " </td>\r\n <td nowrap align=\"center\">\r\n <a href=\"edit.php?ITEM_ID=";
echo $ITEM_ID;
echo "\"> 编辑</a>\r\n";
if ( $ITEM_COUNT1 == $ITEM_COUNT )
{
echo " <a href=\"delete.php?ITEM_ID=";
echo $ITEM_ID;
echo "\"> 删除</a>\r\n";
}
if ( $ISCOMPUTER == "1" )
{
echo " \t <a href=\"javascript:show_formul('";
echo $ITEM_ID;
echo "');\">公式编辑</a>\r\n ";
}
echo " </td>\r\n </tr>\r\n";
}
if ( 0 < $ITEM_COUNT )
{
echo " <tfoot class=\"TableFooter\">\r\n <td colspan=\"6\" align=\"center\">\r\n <input type=\"button\" value=\"全部删除\" class=\"SmallButton\" onClick=\"delete_all();\">\r\n </td>\r\n </tfoot>\r\n <thead class=\"TableHeader\">\r\n <td nowrap align=\"center\">编号</td>\r\n <td nowrap align=\"center\">名称</td>\r\n <td nowrap align=\"center\">项目类型</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </thead>\r\n </table>\r\n";
}
else
{
message( "", "尚未定义" );
}
echo "\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -