sal_data.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 420 行
PHP
420 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<s';
echo 'cript language="javascript">
var FormulData=new Array();
var TargetData=new Array();
var flag=0;
function calculate(FORMULA,TARGET,SIGN)
{
var s1=document.all(FORMULA).value;
var re;
//------所得税计算---------
if(s1.indexOf("<")!=-1 && s1.indexOf(">")!=-1)
{
re=/\\<|\\>/gi;
var r=s1.replace(re, "");
re=/\\[|\\]/gi;
r=r.replace(re, "");
re=/\\$/gi;
r=r.repl';
echo 'ace(re, "S");
for(var i=document.form1.ITEM_COUNT.value; i>0; i--)
{
re="S"+i;
if (document.all(re).value=="" && r.indexOf(re)!=-1)
{
if(SIGN==0)
{
if(Number(document.all(re+"index").value) > Number(document.all(TARGET+"index").value))
{
alert(document.all(re+"_NAME").value+"的值尚未填写或计算!!");
document.all(re).value="0.00";
}
';
echo ' }
r=r.replace(re,"0");
}
else
r=r.replace(re,document.all(re).value);
}
cha=eval(r);
if (cha<=0) {document.all(TARGET).value=0;}
if (cha>0&&cha<=500) {document.all(TARGET).value=(cha*0.05).toFixed(2);}
if (cha>500&&cha<=2000) {document.all(TARGET).value=(cha*0.1-25).toFixed(2);}
if (cha>2000&&cha<=5000) {document.all(TARGET).value=(cha*0.15-125).toFixed(2);}
';
echo '
if (cha>5000&&cha<=20000) {document.all(TARGET).value=(cha*0.2-375).toFixed(2);}
if (cha>20000&&cha<=40000) {document.all(TARGET).value=(cha*0.25-1375).toFixed(2);}
if (cha>40000&&cha<=60000) {document.all(TARGET).value=(cha*0.30-3375).toFixed(2);}
if (cha>60000&&cha<=80000) {document.all(TARGET).value=(cha*0.35-6375).toFixed(2);}
if (cha>80000&&cha<=100000) {document.all(TARGET).va';
echo 'lue=(cha*0.4-10375).toFixed(2);}
if (cha>100000&&cha>100000) {document.all(TARGET).value=(cha*0.45-15375).toFixed(2);}
return;
}
re=/\\[|\\]/gi;
var r=s1.replace(re, "");
re=/\\$/gi;
var r=r.replace(re, "S");
for(var i=document.form1.ITEM_COUNT.value; i>0; i--)
{
re="S"+i;
if (document.all(re).value=="" && r.indexOf(re)!=-1)
{
if(SIGN==0)
{
if(N';
echo 'umber(document.all(re+"index").value) > Number(document.all(TARGET+"index").value))
{
alert(document.all(re+"_NAME").value+"的值尚未填写或计算!!");
document.all(re).value="0.00";
}
}
r=r.replace(re,"0");
}
else
r=r.replace(re,document.all(re).value);
}
document.all(TARGET).value=eval(r).toFixed(2);
}
function funcal(FORMULA,TARGET)
{
';
echo '
calculate(FORMULA,TARGET,0);
for (var key=0;key<TargetData.length;key++)
{
if (TARGET!=TargetData[key] && (document.all(TargetData[key]).value>1))
{
calculate(FormulData[key],TargetData[key],1);
}
}
}
function calculate_all()
{
for(var i=0;i<2;i++)
{
for (var key=0;key<TargetData.length;key++)
{
calculate(FormulData[key],TargetData[key],';
echo '1);
}
}
}
function SetDefault(S_ID,S_NAME,input)
{
if(input.checked==true)
{
if (document.all(S_ID).value=="" )
{
alert(document.all(S_NAME).value+"的值不能空！！");
input.checked=false;
return;
}
document.cookie = S_NAME + "=" + document.all(S_ID).value + "; ";
}
else
{
document.cookie = S_NAME + "=" + document.all(S_ID).valu';
echo 'e + "; expires=Fri, 31 Dec 1999 23:59:59 GMT;";
}
}
function view(FORMULANAME)
{
alert(FORMULANAME);
}
function clear_all(TARGET)
{
document.all(TARGET).value="0.00";
for (var key=0;key<TargetData.length;key++)
{
if (TARGET!=TargetData[key] && (document.all(TargetData[key]).value>1))
{
calculate(FormulData[key],TargetData[key],1);
}
}
}
';
echo '
function createstr(FORMULA,TARGET)
{
FormulData[flag]=FORMULA;
TargetData[flag]=TARGET;
flag=flag+1;
//formustr+=FORMULA+",";
//targetstr+=TARGET+",";
}
</script>
<html>
<head>
<title>工资数据录入</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$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">
<tr>
<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>
</td>
</tr>
</table>
<div align="center">
<form name=form1 method="post" action="submit.php">
';
$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))
{
for ($I = 1; ($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\'';
for ($I = 0; ($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 '
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3">
';
}
if ((($I == 0) AND ($ITEM_COUNT1 == 1)))
{
echo ' <tr class="TableHeader">
<td nowrap align="center">工资项目(上报项)</td>
<td nowrap align="center">金额</td>
</tr>
';
}
if ((($I == 1) AND ($ITEM_COUNT1 == 1)))
{
echo ' <tr class="TableHeader">
<td nowrap align="center">工资项目(输入项)</td>
<td nowrap align="center">金额
</td>
</tr>
';
}
if ((($I == 2) AND ($ITEM_COUNT1 == 1)))
{
echo '
<tr class="TableHeader">
<td nowrap align="center">工资项目(计算项)</td>
<td nowrap align="center" style="cursor:hand" onclick="calculate_all();" title="单击计算所有项目">金额 </td>
</tr>
';
}
echo '
<tr class="TableData">
<td nowrap align="center" width="110">';
echo $ITEM_NAME;
echo '</td>
<td nowrap align="center">
<input type="hidden" name="';
echo $S_NAME;
echo '" value="';
echo $ITEM_NAME;
echo '">
';
if (($ISCOMPUTER == '1'))
{
echo ' ';
echo ' <input type="hidden" name="';
echo $FORMULAFLAG;
echo '" value="';
echo $FORMULA;
echo '">
<input type="hidden" name="';
echo $FORMULAFLAGNAME;
echo '" value="';
echo $FORMULANAME;
echo '">
';
echo '<s';
echo 'cript language="javascript">createstr(\'';
echo $FORMULAFLAG;
echo '\',\'';
echo $S_ID;
echo '\')</script>
';
}
if ((($TOTAL1 != $TOTAL) OR ($I == 0)))
{
echo ' <input type="text" name="';
echo $S_ID;
echo '" size="17" maxlength="14" ';
if ((($ISCOMPUTER == '1') OR ($ISREPORT == '1')))
{
echo 'readonly';
echo ' class=BigStatic';
}
else
{
echo ' class=BigInputMoney';
}
echo ' value="';
echo $$S_ID;
echo '">
<input type="hidden" name="';
echo $S_ID;
echo 'index" value="';
echo $ITEM_COUNT;
echo '">
';
}
else
{
echo ' <input type="text" name="';
echo $S_ID;
echo '" size="17" maxlength="14" ';
if ((($ISCOMPUTER == '1') OR ($ISREPORT == '1')))
{
echo 'readonly';
echo ' class=BigStatic';
}
else
{
echo ' class=BigInputMoney';
}
echo ' value="';
echo $_COOKIE[$S_NAME];
echo '">
<input type="hidden" name="';
echo $S_ID;
echo 'index" value="';
echo $ITEM_COUNT;
echo '">
';
}
if (($ISCOMPUTER == '1'))
{
echo ' <input type="button" value="计算" class="SmallButton" onClick="funcal(\'';
echo $FORMULAFLAG;
echo '\',\'';
echo $S_ID;
echo '\');" title="计算" name="button">
<input type="button" value="清空" class="SmallButton" onClick="clear_all(\'';
echo $S_ID;
echo '\');" title="清空" name="button">
<a href="javascript:view(\'';
echo $FORMULANAME;
echo '\');">计算公式</a>
';
}
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>
';
}
}
echo ' </td>
</tr>
';
}
}
if ((0 < $ITEM_COUNT))
{
echo ' <tr class="TableControl">
<td nowrap colspan="2" align="center">
<input type="hidden" value="';
echo $OPERATION;
echo '" name="OPERATION">
<input type="hidden" value="';
echo $USER_ID;
echo '" name="USER_ID">
<input type="hidden" value="';
echo $USER_NAME;
echo '" name="USER_NAME">
<input type="hidden" value="';
echo $FLOW_ID;
echo '" name="FLOW_ID">
<input type="hidden" value="';
echo $ITEM_COUNT;
echo '" name="ITEM_COUNT">
<input type="submit" value="上报" class="BigButton">
<input type="button" value="取消" class="BigButton" onclick="location=\'blank.php\'">
</td>
</tr>
</table>
';
}
else
{
message ('', '尚未定义工资项目，请与财务主管联系！');
}
echo '
</form>
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?