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>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
<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 '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.FROM_DATE\');">
至
<input type="text" name="TO_DATE" class="BigInput" size="15" maxlength="10" value="';
echo $DATE;
echo '">
<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 + -
显示快捷键?