📄 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)
{
alert(document.all(re+"_NAME").value+"的值尚未填写或计算!!")
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)
alert(document.all(re+"_NAME").value+"的值尚未填写或计算!!");
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 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 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();
//-- 首先查询是否已录入过数据 --
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"]);
}
$OPERATION=2; //-- 将执行数据更新 --
}
else
$OPERATION=1; //-- 将执行数据插入 --
}
//-- 生成录入项目 --
$query="select * from SAL_ITEM where ISREPORT='1' order by ITEM_ID";
$cursor= exequery($connection,$query);
$ITEM_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$ITEM_COUNT++;
$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($ITEM_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3">
<?
}
?>
<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")
{
?>
<input type="hidden" name="<?=$FORMULAFLAG?>" value="<?=$FORMULA?>">
<input type="hidden" name="<?=$FORMULAFLAGNAME?>" value="<?=$FORMULANAME?>">
<script language="javascript">createstr('<?=$FORMULAFLAG?>','<?=$S_ID?>')</script>
<?
}
if($$S_ID!="")
{
?>
<input type="text" name="<?=$S_ID?>" size="17" maxlength="14" <? if($ISCOMPUTER=="1"){echo "readonly"; echo " class=BigStatic";} else {echo " class=BigInputMoney";}?> value="<?=$$S_ID?>">
<?
}
else
{
?>
<input type="text" name="<?=$S_ID?>" size="17" maxlength="14" <? if($ISCOMPUTER=="1"){echo "readonly"; echo " class=BigStatic";} else {echo " class=BigInputMoney";}?> value="<?=$_COOKIE[$S_NAME]?>">
<?
}
if($ISCOMPUTER=="1")
{
?>
<input type="button" value="计算" class="SmallButton" onClick="funcal('<?=$FORMULAFLAG?>','<?=$S_ID?>');" title="计算" name="button">
<a href="javascript:view('<?=$FORMULANAME?>');">计算公式</a>
<?
}
else
{echo " ";
?>
<input type="checkbox" name="<?=$CHECK_NAME?>" id="<?=$CHECK_NAME?>" 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>
<thead class="TableHeader">
<td nowrap align="center">工资项目</td>
<td nowrap align="center">金额</td>
</thead>
</table>
<?
}
else
message("","尚未定义工资项目，请与财务主管联系！");
?>
</form>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -