record.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 474 行

PHP
474 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>办公用品登记管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript 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 C';
  echo 'heckForm()
{
  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( "领用人不';
  echo '能空！！");
   	   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==';
  echo '"")
   { 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(';
  echo '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=d';
  echo 'ocument.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;
';
  echo '  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.';
  echo '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=="")
      	  ';
  echo '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\';
 ';
  echo ' 	    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\';
     ';
  echo ' }
      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")
      {';
  echo '
        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(TRAN';
  echo 'S_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_ID1 = $ROW['PRO_ID'];
      $BORROWER1 = $ROW['BORROWER'];
      $TRANS_FLAG1 = $ROW['TRANS_FLAG'];
      $TRANS_QTY = $ROW['TRANS_QTY'];
      $PRICE = $ROW['PRICE'];
      $TRANS_DATE = $ROW['TRANS_DATE'];
      $OPERATOR = $ROW['OPERATOR'];
      $REMARK = $ROW['REMARK'];
      if (($TRANS_FLAG1 == '0'))
      {
        $TRANS_NAME = '采购入库';
        $BORROWER_NAME = '';
      }
      if (($TRANS_FLAG1 == '1'))
      {
        $TRANS_QTY = ($TRANS_QTY * -1);
        $TRANS_NAME = '领用';
        $TOK = strtok ($BORROWER1, ',');
        $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_FLAG1 == '2'))
      {
        $TRANS_QTY = ($TRANS_QTY * -1);
        $TRANS_NAME = '借用';
        $TOK = strtok ($BORROWER1, ',');
        $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_FLAG1 == '3'))
      {
        $TRANS_NAME = '归还';
        $TOK = strtok ($BORROWER1, ',');
        $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_FLAG1 == '4'))
      {
        $TRANS_QTY = ($TRANS_QTY * -1);
        $TRANS_NAME = '报废';
        $BORROWER_NAME = '';
      }
    }
  }
  echo '<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
  <tr>
';
  if (($TRANS_ID == ''))
  {
    echo '    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
    echo '<s';
    echo 'pan class="big3">&nbsp;新建办公用品登记</span>
    </td>
';
  }
  else
  {
    echo '    <td class="Big"><img src="/images/edit.gif" align="absmiddle" width="20" height="20">';
    echo '<s';
    echo 'pan class="big3">&nbsp;修改办公用品登记</span>
    </td>
';
  }
  echo '  </tr>
</table>
<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="add.php"  method="post" name="form1">
    <tr>
      <td nowrap class="TableData">登记类型：</td>
      <td class="TableData">
         ';
  echo '<s';
  echo 'elect name="TRANS_FLAG" class="BigSelect" onchange="sel_change()">
           <option value="-1">---请选择---</option>
           <option value="0" ';
  if (($TRANS_FLAG1 == '0'))
  {
    echo 'selected';
  }
  echo '>采购入库</option>
           <option value="1" ';
  if (($TRANS_FLAG1 == '1'))
  {
    echo 'selected';
  }
  echo '>领用</option>
           <option value="2" ';
  if (($TRANS_FLAG1 == '2'))
  {
    echo 'selected';
  }
  echo '>借用</option>
           <option value="3" ';
  if (($TRANS_FLAG1 == '3'))
  {
    echo 'selected';
  }
  echo '>归还</option>
           <option value="4" ';
  if (($TRANS_FLAG1 == '4'))
  {
    echo 'selected';
  }
  echo '>报废</option>
        </select>
      </td>
    </tr>
    <tr id="BORROWER" style=';
  if (((($TRANS_FLAG1 == '1') OR ($TRANS_FLAG1 == '2')) OR ($TRANS_FLAG1 == '3')))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>
      <td nowrap id="t1" class="TableData" style=';
  if (($TRANS_FLAG1 == '1'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>领用人：</td>
      <td nowrap id="t2" class="TableData" style=';
  if (($TRANS_FLAG1 == '2'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>借用人：</td>
      <td nowrap id="t3" class="TableData" style=';
  if (($TRANS_FLAG1 == '3'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>归还人：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID" value="';
  echo $BORROWER1;
  echo '">
        <input type="text" name="TO_NAME" size="20" class="BigStatic" maxlength="20"  value="';
  echo $BORROWER_NAME;
  echo '" readonly>
        &nbsp;<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
        &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_dept1()" title="清空" name="button">
      </td>
    </tr>
   <tr id="COST" style=';
  if (($TRANS_FLAG1 == '0'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
';
  if (($PRICE == ''))
  {
    echo '      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
';
  }
  else
  {
    echo '        <input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="';
    echo $PRICE;
    echo '">
';
  }
  echo '      </td>
   </tr>
  	<tr>
      <td nowrap class="TableData">办公用品：</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="PRO_ID" class="BigSelect">
           <option value="-1">---请选择---</option>
';
  $query = 'SELECT * from OFFICE_PRODUCTS';
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $PROID = $ROW['PRO_ID'];
    $PRONAME = $ROW['PRO_NAME'];
    $PROSTOCK = $ROW['PRO_STOCK'];
    $PROUNIT = $ROW['PRO_UNIT'];
    echo '               <option value="';
    echo $PROID;
    echo '" ';
    if (($PROID == $PRO_ID1))
    {
      echo 'selected';
    }
    echo '>';
    echo $PRONAME;
    echo '/库存';
    echo $PROSTOCK;
    echo $PROUNIT;
    echo '</option>
';
  }
  echo '         </select>
          <input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择办公用品" name="button">
       </td>
      </tr>
   <tr>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="';
  echo $TRANS_QTY;
  echo '">
      </td>
    </tr>
     <tr>
      <td nowrap class="TableData">备注：</td>
      <td class="TableData">
        <textarea name="REMARK" cols="45" rows="5" class="BigInput">';
  echo $REMARK;
  echo '</textarea>
      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" name="TRANS_ID" value="';
  echo $TRANS_ID;
  echo '">
        <input type="hidden" value="TRANS_FLAG=';
  echo $TRANS_FLAG;
  echo '&PRO_ID=';
  echo $PRO_ID;
  echo '&PRO_NAME=';
  echo $PRO_NAME;
  echo '&FROM_DATE=';
  echo $FROM_DATE;
  echo '&TO_DATE=';
  echo $TO_DATE;
  echo '&BORROWER=';
  echo $BORROWER;
  echo '" name="QUERY_LIST">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
        <input type="button" value="返回" class="BigButton" onclick="location=\'detail.php?TRANS_FLAG=';
  echo $TRANS_FLAG;
  echo '&PRO_ID=';
  echo $PRO_ID;
  echo '&PRO_NAME=';
  echo $PRO_NAME;
  echo '&FROM_DATE=';
  echo $FROM_DATE;
  echo '&TO_DATE=';
  echo $TO_DATE;
  echo '&BORROWER=';
  echo $BORROWER;
  echo '\'">
      </td>
    </tr>
  </table>
</form>
</body>
</html>';
?>

record.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 record.php 源码文件，采用 PHP 编程语言编写，共 474 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?