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">&nbsp;
    名称<input type="text" name="RUN_NAME" size="30" class="SmallInput">&nbsp;
    <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>&nbsp;
    <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 + -
显示快捷键?