📄 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";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/checkform_function.js\"></script>\r\n";
echo "<s";
echo "cript Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n\tvar strFname\t= document.form1.ITEM_NAME.value;\r\n\tif(Trim(strFname) == \"\")\r\n\t{ \r\n\t\talert(\"工资项目名称不能为空！\");\r\n\t\tdocument.form1.ITEM_NAME.focus();\r\n\t\treturn (false);\r\n\t}\r\n \r\n\tvar specialStr = NormativeStr(Trim(strFname));\r\n\tif (specialStr != false){\r\n\t\r\n\t alert(\"工资项目名称含有特殊字符 \"+specialStr+\" ！\");\r\n\t document.form1.ITEM_NAM";
echo "E.focus();\r\n\t return false;\r\n\t}\r\n\tdocument.form1.submit();\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</script>\r\n</head>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_COUNT = $ROW[0];
}
$sql = "SELECT MAX(ITEM_ID) AS cnt FROM SAL_ITEM";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$max_item_id = $row['cnt'];
$add_item_id = $max_item_id + 1;
if ( 50 < $add_item_id && $ITEM_COUNT < 50 )
{
$sql = "SELECT ITEM_ID FROM SAL_ITEM";
$rs = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $rs ) )
{
$arhaveitemid[] = $row['ITEM_ID'];
}
$idi = 1;
for ( ; $idi < 50; ++$idi )
{
if ( in_array( $idi, $arhaveitemid ) == false )
{
$add_item_id = $idi;
break;
}
}
}
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=\"1\" cellpadding=\"0\">\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/manage/hrms.gif\" align=\"absmiddle\">添加工资项目</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td >\r\n <img src=\"../../../../images/button/add.gif\" border=\"0\" ";
if ( 50 <= $ITEM_COUNT )
{
echo disabled;
}
echo " onClick=\"CheckForm();\" style=\"cursor:hand\">\r\n \r\n <input name=\"image2\" type=\"image\" src=\"../../../../images/button/return.gif\" width=\"105\" height=\"20\" border=\"0\" onClick=\"location='../index.php';\"></td></tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"5\">\r\n <form action=\"add.php\" method=\"post\" name=\"form1\">\r\n <tr class=\"tableline2\">\r\n <td width=\"20%\"><b>\r\n \r\n ";
echo "工资项目名称：\r\n \r\n </b></td>\r\n <td class=\"tableline1\"><b>\r\n <input type=\"text\" name=\"ITEM_NAME\" class=\"BigInput\" size=\"30\" maxlength=\"100\" ";
if ( 50 <= $ITEM_COUNT )
{
echo disabled;
}
echo " >\r\n </b></td>\r\n </tr>\r\n <tr class=\"tableline2\">\r\n <td ><b> 预设：\r\n </b></td>\r\n <td class=\"tableline1\"><b>\r\n <input name=\"ITEM_MONEY\" type=\"text\" class=\"BigInput\" id=\"ITEM_MONEY\" size=\"10\" maxlength=\"6\" ";
if ( 50 <= $ITEM_COUNT )
{
echo disabled;
}
echo " >\r\nRMB\r\n<input type=\"hidden\" name=\"ITEM_ID\" value=\"";
echo $add_item_id;
echo "\">\r\n </b></td>\r\n </tr>\r\n </form>\r\n</table>\r\n<div class=\"big1\">\r\n<b> </b> </div>\r\n\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<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td >已定义的工资项目（最多50条)</td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" width=\"100%\" ";
echo "cellspacing=\"1\" cellpadding=\"1\">\r\n <tr class=\"tablehead2\">\r\n <td><input name=\"image\" type=\"image\" src=\"../../../../images/button/alldel.gif\" width=\"105\" height=\"20\" border=\"0\" onClick=\"delete_all();\"> </td>\r\n </tr>\r\n</table>\r\n";
$query = "SELECT MAX(ITEM_ID) AS max_id FROM sal_item ";
$rs = exequery( $connection, $query );
while ( $rows = mysql_fetch_array( $rs ) )
{
$MAX_ID = $rows['max_id'];
}
$query = "SELECT * from SAL_ITEM order by item_id";
$cursor = exequery( $connection, $query );
$ITEM_COUNT1 = 0;
$LINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ITEM_COUNT1;
++$LINE_COUNT;
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$ITEM_MONEY = $ROW['ITEM_MONEY'];
if ( $ITEM_COUNT1 == 1 )
{
echo "<div >\r\n <table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"3\">\r\n\r\n";
}
if ( $LINE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo "\r\n <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap width=\"50\">";
echo $ITEM_ID;
echo "</td>\r\n <td nowrap >";
echo $ITEM_NAME;
echo "</td>\r\n\t <td nowrap >";
echo $ITEM_MONEY;
echo "</td>\r\n <td nowrap width=\"80\">\r\n <a href=\"edit.php?ITEM_ID=";
echo $ITEM_ID;
echo "\"> 编辑</a>\r\n\r\n ";
if ( $ITEM_ID == $MAX_ID )
{
echo "<a onClick=\"return confirm('如果该工资项已上报工资，也将一并被删除，您确定删除吗?');\" href='delete.php?ITEM_ID={$ITEM_ID}'> 删除</a>";
}
echo "\r\n </td>\r\n </tr>\r\n";
}
if ( 0 < $ITEM_COUNT )
{
echo " <thead class=\"TableHeader\">\r\n <td nowrap >编号</td>\r\n <td nowrap >名称</td>\r\n\t <td nowrap >预设</td>\r\n <td nowrap >操作</td>\r\n </thead>\r\n </table>\r\n";
}
else
{
message( "", "尚未定义" );
}
echo "</div>\r\n<br>\r\n <table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"3\">\r\n \t<tr class=\"TableLine1\">\r\n\t\t<td>\r\n\t\t\t<font color=\"#FF0000\" >注：</font>\r\n\t\t</td>\r\n\t</tr>\r\n \t<tr class=\"TableLine2\">\r\n\t\t<td>\r\n\t\t\t 删除工资项需从编号大的开始依次删除，删除以后，所有人员将不存在此项工资，并且已上报的工资表该项工资也一并删除。\r\n\t\t</td>\r\n\t</tr>\r\n </table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -