📄 record.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>办公用品登记管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function LoadWindow2()
{
URL="product_select";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function CheckForm()
{
if(document.form1.TRANS_FLAG.value=="-1")
{ alert("请选择操作标示!!");
form1.TRANS_FLAG.focus();
return (false);
}
if(document.form1.TRANS_FLAG.value=="1" || document.form1.TRANS_FLAG.value=="2" || document.form1.TRANS_FLAG.value=="3")
{
if (document.form1.TO_ID.value=="")
{
if(document.form1.TRANS_FLAG.value=="1")
alert( "领用人不能空!!");
if(document.form1.TRANS_FLAG.value=="2")
alert( "借用人不能空!!");
if(document.form1.TRANS_FLAG.value=="3")
alert( "归还人不能空!!");
return (false);
}
}
if(document.form1.PRO_ID.value=="-1")
{ alert("请选择办公用品!!");
form1.PRO_ID.focus();
return (false);
}
if(document.form1.TRANS_QTY.value=="")
{ alert("数量不能空!!");
form1.TRANS_QTY.focus();
return (false);
}
if(checknum(document.form1.TRANS_QTY.value)=="0")
{ alert("数量必须是数字!!!");
form1.TRANS_QTY.focus();
return (false);
}
document.form1.submit();
}
function checknum(p)
{
var l = p.length;
var count=0;
for(var i=0; i<l; i++)
{
var digit = p.charAt(i);
if(digit == "." )
{
++count;
if(count>1)
{
return 0;
}
}
else if(digit < "0" || digit > "9")
{
return 0;
}
}
return 1;
}
function clear_dept1()
{
document.form1.TO_ID.value="";
document.form1.TO_NAME.value="";
}
function LoadWindow1()
{
URL="/module/user_select_single?MANAGE_FLAG=1";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:265px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function sel_change()
{
document.form1.TO_ID.value="";
document.form1.TO_NAME.value="";
document.form1.PRICE.value="";
if(form1.TRANS_FLAG.value=="-1")
{
if(document.all("BORROWER").style.display=="")
document.all("BORROWER").style.display="none";
if(document.all("COST").style.display=="")
document.all("COST").style.display="none";
}
if(form1.TRANS_FLAG.value=="0")
{
if(document.all("BORROWER").style.display=="")
document.all("BORROWER").style.display="none";
document.all("COST").style.display="";
}
if(form1.TRANS_FLAG.value=="1")
{
if(document.all("COST").style.display=="")
document.all("COST").style.display="none";
document.all("BORROWER").style.display="";
document.all.t1.style.display='';
document.all.t2.style.display='none';
document.all.t3.style.display='none';
}
if(form1.TRANS_FLAG.value=="2")
{
if(document.all("COST").style.display=="")
document.all("COST").style.display="none";
document.all("BORROWER").style.display="";
document.all.t2.style.display='';
document.all.t1.style.display='none';
document.all.t3.style.display='none';
}
if(form1.TRANS_FLAG.value=="3")
{
if(document.all("COST").style.display=="")
document.all("COST").style.display="none";
document.all("BORROWER").style.display="";
document.all.t3.style.display='';
document.all.t1.style.display='none';
document.all.t2.style.display='none';
}
if(form1.TRANS_FLAG.value=="4")
{
if(document.all("BORROWER").style.display=="")
document.all("BORROWER").style.display="none";
if(document.all("COST").style.display=="")
document.all("COST").style.display="none";
document.all.t3.style.display='none';
document.all.t1.style.display='none';
document.all.t2.style.display='none';
}
}
function delete_vote(TRANS_ID)
{
msg='确认放弃该操作?放弃该操作库存将回滚到操作前的状态!!';
if(window.confirm(msg))
{
URL="delete.php?TRANS_ID="+TRANS_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
if($TRANS_ID!="")
{
$query = "SELECT * from OFFICE_TRANSHISTORY where TRANS_ID=$TRANS_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$TRANS_ID=$ROW["TRANS_ID"];
$PRO_ID=$ROW["PRO_ID"];
$BORROWER=$ROW["BORROWER"];
$TRANS_FLAG=$ROW["TRANS_FLAG"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$PRICE =$ROW["PRICE"];
$TRANS_DATE=$ROW["TRANS_DATE"];
$OPERATOR=$ROW["OPERATOR"];
$REMARK=$ROW["REMARK"];
if ($TRANS_FLAG=="0")
{
$TRANS_NAME="采购入库";
$BORROWER_NAME="";
}
if ($TRANS_FLAG=="1")
{
$TRANS_QTY=$TRANS_QTY*(-1);
$TRANS_NAME="领用";
$TOK=strtok($BORROWER,",");
$query1="select USER_NAME from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$BORROWER_NAME=$ROW["USER_NAME"];
}
if ($TRANS_FLAG=="2")
{
$TRANS_QTY=$TRANS_QTY*(-1);
$TRANS_NAME="借用";
$TOK=strtok($BORROWER,",");
$query1="select USER_NAME from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$BORROWER_NAME=$ROW["USER_NAME"];
}
if ($TRANS_FLAG=="3")
{
$TRANS_NAME="归还";
$TOK=strtok($BORROWER,",");
$query1="select USER_NAME from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$BORROWER_NAME=$ROW["USER_NAME"];
}
if ($TRANS_FLAG=="4")
{
$TRANS_QTY=$TRANS_QTY*(-1);
$TRANS_NAME="报废";
$BORROWER_NAME="";
}
}
}
?>
<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
<tr>
<?
if($TRANS_ID=="")
{
?>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建办公用品登记</span>
</td>
<?
}
else
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -