small_query.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 112 行
PHP
112 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once '../prcs_role.php';
$YEAR_DATE = (date ('Y', time ()).'-01-01');
$CUR_DATE = date ('Y-m-d', time ());
echo '
<html>
<head>
<title>工作流查询</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-60;
mytop=document.body.scrollTop+event.clientY-event.offsetY+220;
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 ' set_limit(val)
{
document.form1.QUERY_LIMIT.value=val;
document.form1.submit();
}
function empty_date()
{
document.form1.PRCS_DATE1.value="";
document.form1.PRCS_DATE2.value="";
}
</script>
</head>
<body class="bodycolor" topmargin="0" leftmargin="0" onload="document.form1.RUN_ID.focus();">
<table border="0" width="100%" cellpadding="3" cellspacing="1" align="center" bgco';
echo 'lor="#000000">
<form action="search.php" method="post" name="form1" target="flow_query">
<tr class="TableHeader">
<td class="small" colspan=2>
流程';
echo '<s';
echo 'elect name="FLOW_ID" class="SmallSelect" style="width:200px">
<option value="">所有流程类型</option>
';
$query = 'SELECT * from FLOW_TYPE,FLOW_SORT where FLOW_TYPE.FLOW_SORT=FLOW_SORT.SORT_ID order by SORT_NO,FLOW_NO';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FLOW_ID = $ROW['FLOW_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$MANAGE_USER = $ROW['MANAGE_USER'];
$QUERY_USER = $ROW['QUERY_USER'];
if ((((($FLOW_TYPE == '1') AND ($LOGIN_USER_PRIV != '1')) AND !find_id ($MANAGE_USER, $LOGIN_USER_ID)) AND !find_id ($QUERY_USER, $LOGIN_USER_ID)))
{
if (!prcs_role ($FLOW_ID, 0))
{
continue;
}
}
echo ' <option value="';
echo $FLOW_ID;
echo '">';
echo $FLOW_NAME;
echo '</option>
';
}
echo ' </select>
状态';
echo '<s';
echo 'elect name="FLOW_STATUS" class="SmallSelect">
<option value="ALL">所有状态</option>
<option value="0">正在执行</option>
<option value="1">已经结束</option>
</select>
范围';
echo '<s';
echo 'elect name="FLOW_QUERY_TYPE" class="SmallSelect">
<option value="ALL">所有范围</option>
<option value="1">我发起的</option>
<option value="2" selected>我经办的</option>
<option value="3" >我管理的</option>
</select>
从<input type="text" name="PRCS_DATE1" size="10" class="SmallInput" value="';
echo $YEAR_DATE;
echo '"><img src="/images/menu/calendar.gif" align=absbottom border="0" style="cursor:hand" onclick="td_calendar(\'form1.PRCS_DATE1\');">至<input type="text" name="PRCS_DATE2" size="10" class="SmallInput"><img src="/images/menu/calendar.gif" align=absbottom border="0" style="cursor:hand" onclick="td_calendar(\'form1.PRCS_DATE2\');">
<a href="javascript:empty_date()">清空</a>
</td>
</tr>
<tr class="Ta';
echo 'bleHeader">
<td valign=center class="small">
流水号<input type="text" name="RUN_ID" size="6" class="SmallInput">
名称<input type="text" name="RUN_NAME" size="30" class="SmallInput">
<input type="text" name="QUERY_LIMIT" size="3" class="SmallInput" value="10">条<input type="hidden" name="QUERY_SMALL" value="1">
<a href="javascript:set_limit(\'50\')">50条</a>
<a href="';
echo 'javascript:set_limit(\'100\')">100条</a>
<a href="javascript:set_limit(\'\')">全部</a>
<button type="submit"><img src="/images/query.gif" align=absmiddle>开始查询</button>
</td>
<td align=center>
<input type="button" value="高级查询" class="BigButton" onClick="parent.location=\'flow_list.php\';" title="工作流高级查询,允许设定复杂查询条件">
</td>
</tr>
</form>
</table>
</body';
echo '>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?