📄 sal_data.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "<s";
echo "cript language=\"javascript\">\r\n var FormulData=new Array();\r\n var TargetData=new Array();\r\n var flag=0;\r\nfunction calculate(FORMULA,TARGET,SIGN)\r\n{\r\n\t var s1=document.all(FORMULA).value;\r\n var re;\r\n //------所得税计算---------\r\n if(s1.indexOf(\"<\")!=-1 && s1.indexOf(\">\")!=-1)\r\n {\r\n re=/\\<|\\>/gi;\r\n var r=s1.replace(re, \"\");\r\n re=/\\[|\\]/gi;\r\n r=r.replace(re, \"\");\r\n re=/\\\$/gi;\r\n r=r.repl";
echo "ace(re, \"S\");\r\n\r\n for(var i=document.form1.ITEM_COUNT.value; i>0; i--)\r\n {\r\n\t re=\"S\"+i;\r\n\t if (document.all(re).value==\"\" && r.indexOf(re)!=-1)\r\n\t {\r\n\t \t if(SIGN==0)\r\n\t \t {\r\n\t \t if(Number(document.all(re+\"index\").value) > Number(document.all(TARGET+\"index\").value))\r\n\t \t {\r\n\t \t alert(document.all(re+\"_NAME\").value+\"的值尚未填写或计算!!\");\r\n\t \t document.all(re).value=\"0.00\";\r\n\t \t }\r\n\t";
echo " }\r\n\r\n\t \tr=r.replace(re,\"0\");\r\n\t }\r\n\telse\r\n\t r=r.replace(re,document.all(re).value);\r\n\r\n }\r\n cha=eval(r);\r\n if (cha<=0) {document.all(TARGET).value=0;}\r\n if (cha>0&&cha<=500) {document.all(TARGET).value=(cha*0.05).toFixed(2);}\r\n if (cha>500&&cha<=2000) {document.all(TARGET).value=(cha*0.1-25).toFixed(2);}\r\n if (cha>2000&&cha<=5000) {document.all(TARGET).value=(cha*0.15-125).toFixed(2);}\r";
echo "\n if (cha>5000&&cha<=20000) {document.all(TARGET).value=(cha*0.2-375).toFixed(2);}\r\n if (cha>20000&&cha<=40000) {document.all(TARGET).value=(cha*0.25-1375).toFixed(2);}\r\n if (cha>40000&&cha<=60000) {document.all(TARGET).value=(cha*0.30-3375).toFixed(2);}\r\n if (cha>60000&&cha<=80000) {document.all(TARGET).value=(cha*0.35-6375).toFixed(2);}\r\n if (cha>80000&&cha<=100000) {document.all(TARGET).va";
echo "lue=(cha*0.4-10375).toFixed(2);}\r\n if (cha>100000&&cha>100000) {document.all(TARGET).value=(cha*0.45-15375).toFixed(2);}\r\n return;\r\n }\r\n\r\n\tre=/\\[|\\]/gi;\r\n\tvar r=s1.replace(re, \"\");\r\n\tre=/\\\$/gi;\r\n\tvar r=r.replace(re, \"S\");\r\n\r\n for(var i=document.form1.ITEM_COUNT.value; i>0; i--)\r\n {\r\n\t re=\"S\"+i;\r\n\t if (document.all(re).value==\"\" && r.indexOf(re)!=-1)\r\n\t {\r\n\t \t if(SIGN==0)\r\n\t \t {\r\n\r\n\t \t if(N";
echo "umber(document.all(re+\"index\").value) > Number(document.all(TARGET+\"index\").value))\r\n\t \t {\r\n\r\n\t \t \talert(document.all(re+\"_NAME\").value+\"的值尚未填写或计算!!\");\r\n\t \t \tdocument.all(re).value=\"0.00\";\r\n\t \t }\r\n\r\n\t \t }\r\n\t \tr=r.replace(re,\"0\");\r\n\t }\r\n\telse\r\n\t r=r.replace(re,document.all(re).value);\r\n\r\n }\r\n document.all(TARGET).value=eval(r).toFixed(2);\r\n}\r\n\r\n\r\nfunction funcal(FORMULA,TARGET)\r\n{\r";
echo "\n calculate(FORMULA,TARGET,0);\r\n for (var key=0;key<TargetData.length;key++)\r\n {\r\n \t if (TARGET!=TargetData[key] && (document.all(TargetData[key]).value>1))\r\n {\r\n calculate(FormulData[key],TargetData[key],1);\r\n }\r\n }\r\n\r\n}\r\n\r\n\r\nfunction calculate_all()\r\n{\r\n\r\n for(var i=0;i<2;i++)\r\n {\r\n \tfor (var key=0;key<TargetData.length;key++)\r\n {\r\n calculate(FormulData[key],TargetData[key],";
echo "1);\r\n }\r\n }\r\n}\r\n\r\n\r\n function SetDefault(S_ID,S_NAME,input)\r\n {\r\n if(input.checked==true)\r\n {\r\n if (document.all(S_ID).value==\"\" )\r\n {\r\n \talert(document.all(S_NAME).value+\"的值不能空！！\");\r\n \tinput.checked=false;\r\n \treturn;\r\n }\r\n document.cookie = S_NAME + \"=\" + document.all(S_ID).value + \"; \";\r\n }\r\n else\r\n \t{\r\n \tdocument.cookie = S_NAME + \"=\" + document.all(S_ID).valu";
echo "e + \"; expires=Fri, 31 Dec 1999 23:59:59 GMT;\";\r\n\r\n \t}\r\n\r\n }\r\n\r\nfunction view(FORMULANAME)\r\n{\r\n\talert(FORMULANAME);\r\n}\r\n\r\nfunction clear_all(TARGET)\r\n{\r\n\r\n\tdocument.all(TARGET).value=\"0.00\";\r\n\tfor (var key=0;key<TargetData.length;key++)\r\n {\r\n \t if (TARGET!=TargetData[key] && (document.all(TargetData[key]).value>1))\r\n {\r\n calculate(FormulData[key],TargetData[key],1);\r\n }\r\n }\r\n}\r\n\r";
echo "\nfunction createstr(FORMULA,TARGET)\r\n{\r\n FormulData[flag]=FORMULA;\r\n TargetData[flag]=TARGET;\r\n flag=flag+1;\r\n\t//formustr+=FORMULA+\",\";\r\n\t//targetstr+=TARGET+\",\";\r\n}\r\n</script>\r\n\r\n<html>\r\n<head>\r\n<title>工资数据录入</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_NAME = $ROW['USER_NAME'];
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/salary.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 工资数据录入（";
echo $USER_NAME;
echo "）</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<div align=\"center\">\r\n\r\n<form name=form1 method=\"post\" action=\"submit.php\">\r\n\r\n";
$connection = openconnection( );
$TOTAL = 0;
$TOTAL1 = 0;
if ( $RECALL == "" )
{
$query = "select * from SAL_DATA where FLOW_ID={$FLOW_ID} and USER_ID='{$USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$I = 1;
for ( ; $I <= 50; ++$I )
{
$STR = "S".$I;
$$STR = format_money( $ROW["{$STR}"] );
$TOTAL = $TOTAL + $$STR;
}
$OPERATION = 2;
}
else
{
$OPERATION = 1;
}
}
$ITEM_COUNT = 0;
$wherestr[0] = "ISREPORT='1'";
$wherestr[1] = "ISREPORT='0' and ISCOMPUTER='0'";
$wherestr[2] = "ISCOMPUTER='1'";
$I = 0;
for ( ; $I < 3; ++$I )
{
$query = "select * from SAL_ITEM where ".$wherestr[$I]." order by item_id";
$cursor = exequery( $connection, $query );
$ITEM_COUNT1 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ITEM_COUNT;
++$ITEM_COUNT1;
$ITEM_ID = $ROW['ITEM_ID'];
$ISREPORT = $ROW['ISREPORT'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$ISCOMPUTER = $ROW['ISCOMPUTER'];
$FORMULA = $ROW['FORMULA'];
$FORMULANAME = $ROW['FORMULANAME'];
$FORMULAFLAG = $ITEM_ID."FORNULA";
$FORMULAFLAGNAME = $ITEM_ID."FORNULANAME";
$S_ID = "S".$ITEM_ID;
$S_NAME = $S_ID."_NAME";
$CHECK_NAME = "C".$S_ID;
if ( $I == 0 )
{
$TOTAL1 = $TOTAL1 + $$S_ID;
}
if ( $ITEM_COUNT == 1 )
{
echo "\r\n <table border=\"0\" cellspacing=\"1\" width=\"450\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n\r\n";
}
if ( $I == 0 && $ITEM_COUNT1 == 1 )
{
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">工资项目(上报项)</td>\r\n <td nowrap align=\"center\">金额</td>\r\n </tr>\r\n\r\n";
}
if ( $I == 1 && $ITEM_COUNT1 == 1 )
{
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">工资项目(输入项)</td>\r\n <td nowrap align=\"center\">金额\r\n </td>\r\n </tr>\r\n\r\n";
}
if ( $I == 2 && $ITEM_COUNT1 == 1 )
{
echo "\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">工资项目(计算项)</td>\r\n <td nowrap align=\"center\" style=\"cursor:hand\" onclick=\"calculate_all();\" title=\"单击计算所有项目\">金额</td>\r\n </tr>\r\n\r\n\r\n";
}
echo "\r\n <tr class=\"TableData\">\r\n <td nowrap align=\"center\" width=\"110\">";
echo $ITEM_NAME;
echo "</td>\r\n <td nowrap align=\"center\">\r\n\r\n <input type=\"hidden\" name=\"";
echo $S_NAME;
echo "\" value=\"";
echo $ITEM_NAME;
echo "\">\r\n";
if ( $ISCOMPUTER == "1" )
{
echo " ";
echo " <input type=\"hidden\" name=\"";
echo $FORMULAFLAG;
echo "\" value=\"";
echo $FORMULA;
echo "\">\r\n <input type=\"hidden\" name=\"";
echo $FORMULAFLAGNAME;
echo "\" value=\"";
echo $FORMULANAME;
echo "\">\r\n ";
echo "<s";
echo "cript language=\"javascript\">createstr('";
echo $FORMULAFLAG;
echo "','";
echo $S_ID;
echo "')</script>\r\n";
}
if ( $TOTAL1 != $TOTAL || $I == 0 )
{
echo " <input type=\"text\" name=\"";
echo $S_ID;
echo "\" size=\"17\" maxlength=\"14\" ";
if ( $ISCOMPUTER == "1" || $ISREPORT == "1" )
{
echo "readonly";
echo " class=BigStatic";
}
else
{
echo " class=BigInputMoney";
}
echo " value=\"";
echo $$S_ID;
echo "\">\r\n <input type=\"hidden\" name=\"";
echo $S_ID;
echo "index\" value=\"";
echo $ITEM_COUNT;
echo "\">\r\n";
}
else
{
echo " <input type=\"text\" name=\"";
echo $S_ID;
echo "\" size=\"17\" maxlength=\"14\" ";
if ( $ISCOMPUTER == "1" || $ISREPORT == "1" )
{
echo "readonly";
echo " class=BigStatic";
}
else
{
echo " class=BigInputMoney";
}
echo " value=\"";
echo $_COOKIE[$S_NAME];
echo "\">\r\n <input type=\"hidden\" name=\"";
echo $S_ID;
echo "index\" value=\"";
echo $ITEM_COUNT;
echo "\">\r\n";
}
if ( $ISCOMPUTER == "1" )
{
echo " <input type=\"button\" value=\"计算\" class=\"SmallButton\" onClick=\"funcal('";
echo $FORMULAFLAG;
echo "','";
echo $S_ID;
echo "');\" title=\"计算\" name=\"button\">\r\n <input type=\"button\" value=\"清空\" class=\"SmallButton\" onClick=\"clear_all('";
echo $S_ID;
echo "');\" title=\"清空\" name=\"button\">\r\n <a href=\"javascript:view('";
echo $FORMULANAME;
echo "');\">计算公式</a>\r\n\r\n";
}
else if ( $ISREPORT == "0" )
{
echo " ";
echo " <input type=\"checkbox\" name=\"";
echo $CHECK_NAME;
echo "\" id=\"";
echo $CHECK_NAME;
echo "\" ";
if ( $ISREPORT == "1" )
{
echo " disabled";
}
echo " onclick=\"SetDefault('";
echo $S_ID;
echo "','";
echo $S_NAME;
echo "',this);\"><label for=\"";
echo $CHECK_NAME;
echo "\">设为默认值</label>\r\n";
}
echo " </td>\r\n </tr>\r\n";
}
}
if ( 0 < $ITEM_COUNT )
{
echo " <tr class=\"TableControl\">\r\n <td nowrap colspan=\"2\" align=\"center\">\r\n <input type=\"hidden\" value=\"";
echo $OPERATION;
echo "\" name=\"OPERATION\">\r\n <input type=\"hidden\" value=\"";
echo $USER_ID;
echo "\" name=\"USER_ID\">\r\n <input type=\"hidden\" value=\"";
echo $USER_NAME;
echo "\" name=\"USER_NAME\">\r\n <input type=\"hidden\" value=\"";
echo $FLOW_ID;
echo "\" name=\"FLOW_ID\">\r\n <input type=\"hidden\" value=\"";
echo $ITEM_COUNT;
echo "\" name=\"ITEM_COUNT\">\r\n <input type=\"submit\" value=\"上报\" class=\"BigButton\"> \r\n <input type=\"button\" value=\"取消\" class=\"BigButton\" onclick=\"location='blank.php'\">\r\n </td>\r\n </tr>\r\n </table>\r\n";
}
else
{
message( "", "尚未定义工资项目，请与财务主管联系！" );
}
echo "\r\n</form>\r\n</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -