query.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 476 行 · 第 1/2 页

PHP
476 行
字号
12
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  include_once 'inc/utility_html.php';
  $YEAR_DATE = (date ('Y', time ()).'-01-01');
  $CUR_DATE = date ('Y-m-d', time ());
  $query = ((''.'SELECT * from FLOW_TYPE where FLOW_ID=').$FLOW_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $FLOW_ID = $ROW['FLOW_ID'];
    $FLOW_NAME = $ROW['FLOW_NAME'];
    $FORM_ID = $ROW['FORM_ID'];
    $QUERY_ITEM = $ROW['QUERY_ITEM'];
  }
  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-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 ' my_submit1()
{
   document.form1.action="search.php";
   document.form1.target="_self";
   document.form1.submit();
}
function today()
{
   document.form1.PRCS_DATE1.value="';
  echo $CUR_DATE;
  echo '";
   document.form1.PRCS_DATE2.value="';
  echo $CUR_DATE;
  echo '";
}
function empty_date()
{
   document.form1.PRCS_DATE1.value="";
   document.form1.PRCS_DATE2.value="";
}
function my_submit2(OP)
{
  document.form1.SUM_FLD.value="";
  for (i=0; i<document.form1.SUM_FLD_LIST.options.length; i++)
  {
    if(document.form1.SUM_FLD_LIST.options(i).selected)
    {
      option_value=document.form1.SUM_FLD_LIST.options(i).value;
      document.for';
  echo 'm1.SUM_FLD.value+=option_value+",";
    }
  }//for
  document.form1.OP.value=OP;
  document.form1.action="flow_report.php";
  document.form1.target="_blank";
  document.form1.submit();
}
function select_all(flag)
{
  for (i=0; i<document.form1.SUM_FLD_LIST.options.length; i++)
  {
    document.form1.SUM_FLD_LIST.options(i).selected=flag;
  }//for
}
';
  if (($QUERY_ITEM == ''))
  {
    echo 'data_hide=1;
';
  }
  else
  {
    echo 'data_hide=0;
';
  }
  echo '
function data_show_hide()
{
	data_hide=1-data_hide;
	for (step_i=0; step_i<document.all.length; step_i++)
  {
    if(document.all(step_i).className=="TableLine1"||document.all(step_i).className=="TableLine2")
    {
       if(data_hide)
          document.all(step_i).style.display="none";
       else
       	  document.all(step_i).style.display="";
    }
  }
}
function LoadWindow()';
  echo '
{
  URL="/module/user_select_single";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-80;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+220;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function set_user()
{
	if(document.form1.FLOW_QUE';
  echo 'RY_TYPE.value=="1")
	{
	   document.form1.TO_ID.value="';
  echo $LOGIN_USER_ID;
  echo '";
	   document.form1.TO_NAME.value="';
  echo $LOGIN_USER_NAME;
  echo '";
	}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/green_arrow.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 工作流高级查询 - 请指定查询条件</span><br>
    </td>
  </tr>
</table>
<br>
<table border="0" width="90%" cellpadding="3" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form action="search.php" method="post" name="form1">
    <tr>
      <td nowrap class="TableHeader" colspan="3"><img src="/images/green_arrow.gif" align="absmiddle"><b> 工作流程基本属性</b></td>
   ';
  echo ' </tr>
    <tr>
      <td nowrap class="TableContent"><b>流程名称：</b></td>
      <td class="TableData" colspan="2">
        ';
  echo '<s';
  echo 'elect name="FLOW_ID" class="SmallStatic">
          <option value="';
  echo $FLOW_ID;
  echo '">';
  echo $FLOW_NAME;
  echo '</option>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>工作流状态：</b></td>
      <td class="TableData" colspan="2">
        ';
  echo '<s';
  echo 'elect name="FLOW_STATUS" class="SmallSelect">
          <option value="ALL">所有</option>
          <option value="1">已结束</option>
          <option value="0">执行中</option>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>查询范围：</b></td>
      <td class="TableData" colspan="2">
        ';
  echo '<s';
  echo 'elect name="FLOW_QUERY_TYPE" class="SmallSelect" onchange="set_user();">
          <option value="ALL">所有</option>
          <option value="1">我发起的</option>
          <option value="2">我经办的</option>
          <option value="3" >我管理的</option>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>流程发起人：</b></td>
      <td class="TableData" colspan="2"';
  echo '>
         <input type="text" name="TO_NAME" size="10" class="SmallInput" readonly>&nbsp;
         <input type="button" value="指 定" class="SmallButton" onClick="LoadWindow()" title="指定代办人" name="button">
         <input type="hidden" name="TO_ID" value="">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>名称/文号：</b></td>
      <td nowrap class="TableData">
       ';
  echo '<s';
  echo 'elect name="RUN_NAME_RELATION" class="SmallSelect">
        <option value="1">等于</option>
        <option value="2">大于</option>
        <option value="3">小于</option>
        <option value="4">大于等于</option>
        <option value="5">小于等于</option>
        <option value="6">不等于</option>
        <option value="7">开始为</option>
        <option value="8" selected>包含</option>
        <option';
  echo ' value="9">结束为</option>
       </select>
      </td>
      <td class="TableData">
        <input type="text" name="RUN_NAME" size="30" maxlength="100" class="SmallInput">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>流程开始日期：</b></td>
      <td class="TableData" colspan="2">
        从 <input type="text" name="PRCS_DATE1" size="10" class="SmallInput" value="';
  echo $YEAR_DATE;
  echo '"><img src="/images/menu/calendar.gif" align=absmiddle 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=absmiddle border="0" style="cursor:hand" onclick="td_calendar(\'form1.PRCS_DATE2\');">
        <input type="button" value="清空" class="SmallButton" name=';
  echo '"back1" onClick="empty_date()">
        <input type="button" value="今日" class="SmallButton" name="back1" onClick="today()">
        可只填一项
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"><b>公共附件名称：</b></td>
      <td nowrap class="TableData">
       包含
      </td>
      <td class="TableData">
        <input type="text" name="ATTACHMENT_NAME" size="30" class="Smal';
  echo 'lInput">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableHeader" colspan="3">
      	<img src="/images/green_arrow.gif" align="absmiddle"><b> 表单数据条件</b> <a href="javascript:data_show_hide()">显示/隐藏条件</a>
      </td>
    </tr>
';
12

query.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 query.php 源码文件，采用 PHP 编程语言编写，共 476 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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