index.php

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

<?
  include_once 'inc/auth.php';
  echo '<s';
  echo 'cript Language="JavaScript">
function Sum_Report(flag)
{
  if(flag==0)
  {
  	URL="report.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&TRANS_FLAG=0"+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"report","height=500,width=500,status=0,tool';
  echo 'bar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(flag==1)
  {
  	URL="dept_Sum.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"dept_Sum","height=500,width';
  echo '=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(flag==2)
  {
  	URL="borrow_sum.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&TRANS_FLAG=2"+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.value;
    myleft=(screen.availWidth-500)/2;
    window.o';
  echo 'pen(URL,"borrow_sum","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(flag==3)
  {
  	URL="borrow_sum.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&TRANS_FLAG=3"+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.value;
    myleft=(s';
  echo 'creen.availWidth-500)/2;
    window.open(URL,"return_sum","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(flag==4)
  {
  	URL="noreturn.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&OFFICE_PROTYPE="+document.form1.OFFICE_PROTYPE.v';
  echo 'alue;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"noreturn","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(flag==5)
  {
  	URL="report.php?FROM_DATE="+document.form1.FROM_DATE.value+"&TO_DATE="+document.form1.TO_DATE.value+"&PRO_ID="+document.form1.PRO_ID.value+"&TRANS_FLAG=4"+"&OFFICE_PROTYPE="';
  echo '+document.form1.OFFICE_PROTYPE.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"discard","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
}
function clear_dept1()
{
  document.form1.TO_ID.value="";
	document.form1.TO_NAME.value="";
}
function td_calendar(fieldname)
{
  myleft=document.body.scro';
  echo 'llLeft+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");
}
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>
<title>';
  echo '办公用品登记报表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/new_email.gif" WIDTH="18" HEIGHT="18"  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="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="FROM_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.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="TableHeader" colspan="2" align="left">
     报表类型
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Report(\'0\');">采购物品报表</a>
    </td>
   </tr>
   <t';
  echo 'r>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Report(\'1\');">部门、人员领用物品报表</a>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Report(\'2\');">借用物品报表</a>
    </td>
   </tr>
    <tr>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Re';
  echo 'port(\'3\');">归还物品报表</a>
    </td>
   </tr>
    <tr>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Report(\'4\');">未归还物品报表</a>
    </td>
   </tr>
    <tr>
    <td nowrap  class="TableData" colspan="2" align="left">
      <a href="javascript:Sum_Report(\'5\');">报废物品报表</a>
    </td>
   </tr>
</form>
</table>
</div>
</body>
</html>';
?>