📄 sal_data.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<script 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.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(Number(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);
}
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);}
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).value=(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(Number(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)
{
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],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).value + "; 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);
}
}
}
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"];
}
?>
<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"><span class="big3"> 工资数据录入（<?=$USER_NAME?>）</span>
</td>
</tr>
</table>
<div align="center">
<form name=form1 method="post" action="submit.php">
<?
$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))
{
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)
{
?>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3">
<?
}
if($I==0 and $ITEM_COUNT1==1)
{
?>
<tr class="TableHeader">
<td nowrap align="center">工资项目(上报项)</td>
<td nowrap align="center">金额</td>
</tr>
<?
}
if($I==1 and $ITEM_COUNT1==1)
{
?>
<tr class="TableHeader">
<td nowrap align="center">工资项目(输入项)</td>
<td nowrap align="center">金额
</td>
</tr>
<?
}
if($I==2 and $ITEM_COUNT1==1)
{
?>
<tr class="TableHeader">
<td nowrap align="center">工资项目(计算项)</td>
<td nowrap align="center" style="cursor:hand" onclick="calculate_all();" title="单击计算所有项目">金额 </td>
</tr>
<?
}
?>
<tr class="TableData">
<td nowrap align="center" width="110"><?=$ITEM_NAME?></td>
<td nowrap align="center">
<input type="hidden" name="<?=$S_NAME?>" value="<?=$ITEM_NAME?>">
<?
if($ISCOMPUTER=="1")
{ echo " ";
?>
<input type="hidden" name="<?=$FORMULAFLAG?>" value="<?=$FORMULA?>">
<input type="hidden" name="<?=$FORMULAFLAGNAME?>" value="<?=$FORMULANAME?>">
<script language="javascript">createstr('<?=$FORMULAFLAG?>','<?=$S_ID?>')</script>
<?
}
if(($TOTAL1!=$TOTAL) or $I==0)
{
?>
<input type="text" name="<?=$S_ID?>" size="17" maxlength="14" <? if($ISCOMPUTER=="1" or $ISREPORT=="1"){echo "readonly"; echo " class=BigStatic";} else {echo " class=BigInputMoney";}?> value="<?=$$S_ID?>">
<input type="hidden" name="<?=$S_ID?>index" value="<?=$ITEM_COUNT?>">
<?
}
else
{
?>
<input type="text" name="<?=$S_ID?>" size="17" maxlength="14" <? if($ISCOMPUTER=="1" or $ISREPORT=="1"){echo "readonly"; echo " class=BigStatic";} else {echo " class=BigInputMoney";}?> value="<?=$_COOKIE[$S_NAME]?>">
<input type="hidden" name="<?=$S_ID?>index" value="<?=$ITEM_COUNT?>">
<?
}
if($ISCOMPUTER=="1")
{
?>
<input type="button" value="计算" class="SmallButton" onClick="funcal('<?=$FORMULAFLAG?>','<?=$S_ID?>');" title="计算" name="button">
<input type="button" value="清空" class="SmallButton" onClick="clear_all('<?=$S_ID?>');" title="清空" name="button">
<a href="javascript:view('<?=$FORMULANAME?>');">计算公式</a>
<?
}
else
{
if ($ISREPORT=="0")
{
echo " ";
?>
<input type="checkbox" name="<?=$CHECK_NAME?>" id="<?=$CHECK_NAME?>" <? if($ISREPORT=="1") echo " disabled";?> onclick="SetDefault('<?=$S_ID?>','<?=$S_NAME?>',this);"><label for="<?=$CHECK_NAME?>">设为默认值</label>
<?
}
}
?>
</td>
</tr>
<?
}
}
if($ITEM_COUNT>0)
{
?>
<tr class="TableControl">
<td nowrap colspan="2" align="center">
<input type="hidden" value="<?=$OPERATION?>" name="OPERATION">
<input type="hidden" value="<?=$USER_ID?>" name="USER_ID">
<input type="hidden" value="<?=$USER_NAME?>" name="USER_NAME">
<input type="hidden" value="<?=$FLOW_ID?>" name="FLOW_ID">
<input type="hidden" value="<?=$ITEM_COUNT?>" name="ITEM_COUNT">
<input type="submit" value="上报" class="BigButton">
<input type="button" value="取消" class="BigButton" onclick="location='blank.php'">
</td>
</tr>
</table>
<?
}
else
message("","尚未定义工资项目，请与财务主管联系！");
?>
</form>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -