index.php

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

PHP
265
字号
<?
  include_once 'inc/auth.php';
  echo '<s';
  echo 'cript Language="JavaScript">
function query()
{
  location="detail.php?TRANS_FLAG="+document.form1.TRANS_FLAG.value+"&PRO_ID="+document.form1.PRO_ID.value+"&FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_NAME="+document.form1.PRO_NAME.value+"&BORROWER="+document.form1.TO_ID.value+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.value;
}
function Lo';
  echo 'adWindow1()
{
  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 clear_dept1()
{
';
  echo '  document.form1.TO_ID.value="";
	document.form1.TO_NAME.value="";
}
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>
<html>
<head>
<titl';
  echo 'e>办公用品登记查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
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';
  echo ' sel_change()
{
	   document.form1.TO_ID.value="";
	   document.form1.TO_NAME.value="";
  	 if(form1.TRANS_FLAG.value=="-1")
      {
      	if(document.all("BORROWER").style.display=="")
      	  document.all("BORROWER").style.display="none";
      }
      if(form1.TRANS_FLAG.value=="0")
      {
      	if(document.all("BORROWER").style.display=="")
      	  document.all("BORROWER").sty';
  echo 'le.display="none";
      }
      if(form1.TRANS_FLAG.value=="1")
      {
        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")
      {
        document.all("BORROWER").style.display="";
  	    document.all.t2.s';
  echo 'tyle.display=\'\';
  	    document.all.t1.style.display=\'none\';
  	    document.all.t3.style.display=\'none\';
      }
      if(form1.TRANS_FLAG.value=="3")
      {
        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=="';
  echo '4")
      {
        if(document.all("BORROWER").style.display=="")
      	  document.all("BORROWER").style.display="none";
      	document.all.t3.style.display=\'none\';
  	    document.all.t1.style.display=\'none\';
  	    document.all.t2.style.display=\'none\';
      }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'SELECT count(*) from SCORE_FLOW where END_DATE<=\'').$CUR_DATE).'\' and  END_DATE <> \'0000-00-00\' order by SEND_TIME desc');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $HISTORY_COUNT = $ROW[0];
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="25" HEIGHT="25"  align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 办公用品登记查询</span>
    </td>
  </tr>
</table>
<br>
<div align="center">
<table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form   method="post" name="form1" >
  <tr>
      <td nowrap class="TableContent">登记类型:</td>
      <td class="TableData">
         ';
  echo '<s';
  echo 'elect name="TRANS_FLAG" class="BigSelect" onchange="sel_change()">
           <option value="-1"></option>
           <option value="0">采购入库</option>
           <option value="1">领用</option>
           <option value="2">借用</option>
           <option value="3">归还</option>
           <option value="4">报废</option>
        </select>
      </td>
   </tr>
   <tr id="BORROWER" style=display:none';
  echo '>
      <td nowrap id="t1" class="TableContent" style=display:none>领用人:</td>
      <td nowrap id="t2" class="TableContent" style=display:none>借用人:</td>
      <td nowrap id="t3" class="TableContent" style=display:none>归还人:</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID" value="">
        <input type="text" name="TO_NAME" size="20" class="BigStatic" maxlength="20';
  echo '"  value="" 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>
      <td nowrap class="TableContent">办公用品类别:</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="OFFICE_PROTYPE" class="BigSelect" onChange="getProduct()">
              <option value=""></option>
';
  $query = 'SELECT CODE_NO,CODE_NAME 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))
  {
    ++$VOTE_COUNT;
    $CODENAME = $ROW['CODE_NAME'];
    $CODENO = $ROW['CODE_NO'];
    echo '               <option value="';
    echo $CODENO;
    echo '">';
    echo $CODENAME;
    echo '</option>
';
  }
  echo '         </select>
       </td>
      </tr>
  	<tr>
      <td nowrap class="TableContent">办公用品:</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="PRO_ID" class="BigSelect">
           <option value=""></option>
            ';
  $query = (((((''.'SELECT * from OFFICE_PRODUCTS where PRO_MANAGER=\'').$LOGIN_USER_ID).'\' or PRO_MANAGER=\'\' or PRO_DEPT=\'\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',PRO_DEPT)');
  $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'];
    echo '               <option value="';
    echo $PROID;
    echo '">';
    echo $PRONAME;
    echo '/库存';
    echo $PROSTOCK;
    echo '</option>
             ';
  }
  echo '         </select>
       </td>
      </tr>
    <tr>
    <td nowrap class="TableContent">办公用品名称(模糊):</td>
    <td nowrap class="TableData">
      <input type="text" name="PRO_NAME" class="BigInput" size="15" maxlength="10">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableContent">日期: </td>
    <td nowrap class="TableData">
        <input type="text" name="FROM_DATE" class="BigInpu';
  echo 't" size="15" maxlength="10" value="';
  echo $DATE;
  echo '">&nbsp;
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.FROM_DATE\');">
    &nbsp;至&nbsp;
       <input type="text" name="TO_DATE" class="BigInput" size="15" maxlength="10" value="';
  echo $DATE;
  echo '">&nbsp;
       <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.TO_DATE\');">
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input  value="查询"  class="BigButton" title="模糊查询"  type="button"  onclick="query();">
    </td>
   </tr>
  </form>
</table>
</div>
</body>
</html>';
?>

⌨️ 快捷键说明

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