record.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 686 行 · 第 1/2 页

PHP
686 行
字号
12
<?
  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 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';
  echo '_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);
   }';
  echo '
   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';
  echo '; 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/use';
  echo 'r_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.sc';
  echo 'rollLeft+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.fo';
  echo 'rm1.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';
  echo '("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=\'\';
  	  ';
  echo '  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\';
  	    do';
  echo 'cument.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\';
      }
    ';
  echo '  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\'';
  echo ';
      }
}
function delete_vote(TRANS_ID)
{
 msg=\'确认放弃该操作？放弃该操作库存将回滚到操作前的状态！！\';
 if(window.confirm(msg))
 {
  URL="delete.php?TRANS_ID="+TRANS_ID;
  window.location=URL;
 }
}
var PRODUCT=[
';
  $query = 'SELECT CODE_NO from SYS_CODE where PARENT_NO=\'OFFICE_PROTYPE\' order by CODE_NAME';
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $CODE_NO = '';
    $STR_PRONAME1 = '';
    $STR_PROID1 = '';
    $CODE_NO = $ROW['CODE_NO'];
    $query = (((((((''.'SELECT * from OFFICE_PRODUCTS where OFFICE_PROTYPE=\'').$CODE_NO).'\' and (PRO_MANAGER=\'').$LOGIN_USER_ID).'\' or PRO_MANAGER=\'\' or PRO_DEPT=\'\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',PRO_DEPT))');
    $cursor1 = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      $PROSTOCK = $ROW['PRO_STOCK'];
      $PROUNIT = $ROW['PRO_UNIT'];
      $PRONAME = $ROW['PRO_NAME'];
      $STR_PRONAME1 = ((((((($STR_PRONAME1.'"').$PRONAME).'/库存').$PROSTOCK).$PROUNIT).'"').',');
      $STR_PROID1 = (((($STR_PROID1.'"').$ROW['PRO_ID']).'"').',');
    }
    $STR_PRONAME1 = substr ($STR_PRONAME1, 0, (strlen ($STR_PRONAME1) - 1));
    $STR_PROID1 = substr ($STR_PROID1, 0, (strlen ($STR_PROID1) - 1));
    $STR_TEMP = (((((($STR_TEMP.'[').$STR_PRONAME1).'],').'[').$STR_PROID1).'],');
  }
  $STR_TEMP = substr ($STR_TEMP, 0, (strlen ($STR_TEMP) - 1));
  echo $STR_TEMP;
  echo '];
function getProduct()
{
var OFFICE_PROTYPE=document.form1.OFFICE_PROTYPE;
var PRO_ID=document.form1.PRO_ID;
var PRODUCT_NAME=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2];
var PRODUCT_VALUE=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2+1];
PRO_ID.length=1;
for(var i=0;i<PRODUCT_NAME.length;i++)
{
PRO_ID[i+1]=new Option(PRODUCT_NAME[i],PRODUCT_VALUE[i]);
}
}
</script>
</head>
<body class="';
  echo '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 = '';
      }
      $query1 = (((''.'select OFFICE_PROTYPE from OFFICE_PRODUCTS  where PRO_ID=\'').$PRO_ID).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $OFFICE_PROTYPE = $ROW['OFFICE_PROTYPE'];
      }
    }
  }
  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_FLAG == '0'))
  {
    echo 'selected';
  }
  echo '>采购入库</option>
           <option value="1" ';
  if (($TRANS_FLAG == '1'))
  {
    echo 'selected';
  }
  echo '>领用</option>
           <option value="2" ';
  if (($TRANS_FLAG == '2'))
  {
    echo 'selected';
  }
  echo '>借用</option>
           <option value="3" ';
  if (($TRANS_FLAG == '3'))
  {
    echo 'selected';
  }
  echo '>归还</option>
           <option value="4" ';
  if (($TRANS_FLAG == '4'))
  {
    echo 'selected';
  }
  echo '>报废</option>
        </select>
      </td>
    </tr>
    <tr id="BORROWER" style=';
12

record.php - 源码说明

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

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

⌨️ 快捷键说明

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