search.php

通达OA2007SE源代码 非常好的

            }
            else
            {
              ($WHERE_STR .= (('>\''.$FIELDVALUE).'\''));
              break;
            }
            break;
          }
          case 3:
          {
            if (is_numeric ($FIELDVALUE))
            {
              ($WHERE_STR .= (('<'.$FIELDVALUE).''));
              break;
            }
            else
            {
              ($WHERE_STR .= (('<\''.$FIELDVALUE).'\''));
              break;
            }
            break;
          }
          case 4:
          {
            if (is_numeric ($FIELDVALUE))
            {
              ($WHERE_STR .= (('>='.$FIELDVALUE).''));
              break;
            }
            else
            {
              ($WHERE_STR .= (('>=\''.$FIELDVALUE).'\''));
              break;
            }
            break;
          }
          case 5:
          {
            if (is_numeric ($FIELDVALUE))
            {
              ($WHERE_STR .= (('<='.$FIELDVALUE).''));
              break;
            }
            else
            {
              ($WHERE_STR .= (('<=\''.$FIELDVALUE).'\''));
              break;
            }
            break;
          }
          case 6:
          {
            ($WHERE_STR .= (('!=\''.$FIELDVALUE).'\''));
            break;
          }
          case 7:
          {
            ($WHERE_STR .= ((' like \''.$FIELDVALUE).'%\''));
            break;
          }
          case 8:
          {
            ($WHERE_STR .= ((' like \'%'.$FIELDVALUE).'%\''));
            break;
          }
          case 9:
          {
            ($WHERE_STR .= ((' like \'%'.$FIELDVALUE).'\''));
            break;
          }
        }
        $query1 = (('select 1 from FLOW_RUN_DATA'.$WHERE_STR).' limit 1');
        $cursor1 = exequery ($connection, $query1);
        if (!$ROW = mysql_fetch_array ($cursor1))
        {
          $NOT_FOUND = 1;
          break;
        }
        continue;
      }
    }
    if (($NOT_FOUND == 1))
    {
      continue;
    }
    else
    {
      if (($FLOW_STATUS == 'ALL'))
      {
        if (find_id ($STATUS_RUN, $RUN_ID))
        {
          $STATUS = '<font color=red>执行中</font>';
        }
        else
        {
          $STATUS = '已结束';
        }
      }
      else
      {
        if (($FLOW_STATUS == '0'))
        {
          $STATUS = '<font color=red>执行中</font>';
        }
        else
        {
          $STATUS = '已结束';
        }
      }
      if (($STATUS == '已结束'))
      {
        $PRCS_OVER = 1;
      }
      else
      {
        $PRCS_OVER = 0;
      }
      $query1 = (((((''.'SELECT PRCS_ID,PRCS_FLAG,FLOW_PRCS,OP_FLAG from FLOW_RUN_PRCS WHERE RUN_ID=\'').$RUN_ID).'\' AND USER_ID=\'').$LOGIN_USER_ID).'\' and PRCS_FLAG<>\'4\' order by PRCS_FLAG limit 1');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $PRCS_ID = $ROW['PRCS_ID'];
        $PRCS_FLAG = $ROW['PRCS_FLAG'];
        $FLOW_PRCS = $ROW['FLOW_PRCS'];
        $OP_FLAG = $ROW['OP_FLAG'];
      }
      else
      {
        $PRCS_FLAG = '';
      }
      ++$FLOW_COUNT;
      ($RUN_ID_STR .= ($RUN_ID.','));
      if (($FLOW_COUNT == 1))
      {
        if ($FLOW_ID_GLOBAL)
        {
          echo '   <input type="button" class="SmallButton" value="生成Excel报表" onclick="excel_data()">&nbsp;
   <input type="button" class="SmallButton" value="返回" onclick="history.back()">
';
        }
        echo '  <table id="flow_table" border="1" bordercolor="#000000" style="border-collapse:collapse" cellspacing="0" width="100%" class="small" cellpadding="3" align="center">
    <tr class="TableHeader">
';
        if (($FLOW_ID_GLOBAL OR ($LOGIN_USER_PRIV == '1')))
        {
          echo '    	<td nowrap align="center">选择</td>
';
        }
        echo '      <td nowrap align="center"><a href="#">流水号</a></td>
      <td nowrap align="center"><a href="#">工作名称/文号</a></td>
      <td nowrap align="center"><a href="#">开始时间</a></td>
      <td nowrap align="center"><a href="#">公共附件</a></td>
      <td nowrap align="center"><a href="#">状态</a></td>
      <td nowrap align="center">操作</td>
    </tr>
';
      }
      if ((($FLOW_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '">
';
      if (($FLOW_ID_GLOBAL OR ($LOGIN_USER_PRIV == '1')))
      {
        echo '    	<td nowrap align="center">
    		<input type="checkbox" name="run_select" value="';
        echo $RUN_ID;
        echo '" onClick="check_one(self);">
    	</td>
';
      }
      echo '      <td nowrap align="center" class="TableContent"><b>';
      echo $RUN_ID;
      echo '</b></td>
      <td>
        <a href="javascript:form_view(';
      echo $RUN_ID;
      echo ',';
      echo $FLOW_ID;
      echo ');">';
      echo $RUN_NAME;
      echo '</a>
      </td>
      <td align="center">';
      echo $PRCS_TIME;
      echo '</td>
      <td>
';
      if (($ATTACHMENT_ID == ''))
      {
        echo '无';
      }
      else
      {
        echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, '');
      }
      echo '      </td>
      <td align="center" nowrap>';
      echo $STATUS;
      echo '</td>
      <td nowrap>
          <a href="javascript:flow_view(';
      echo $RUN_ID;
      echo ',';
      echo $FLOW_ID;
      echo ')">流程图</a>&nbsp;
';
      if ((($PRCS_FLAG == '1') OR ($PRCS_FLAG == '2')))
      {
        echo '          <a href="../list/input_form?MENU_FLAG=';
        echo $MENU_FLAG;
        echo '&RUN_ID=';
        echo $RUN_ID;
        echo '&FLOW_ID=';
        echo $FLOW_ID;
        echo '&PRCS_ID=';
        echo $PRCS_ID;
        echo '&FLOW_PRCS=';
        echo $FLOW_PRCS;
        echo '" ';
        if (($MENU_FLAG != '1'))
        {
          echo 'target=_parent';
        }
        echo '>办理</a>&nbsp;
          <a href="../list/others/';
        if (($FLOW_TYPE == '1'))
        {
          echo 'others';
        }
        else
        {
          echo 'others_free';
        }
        echo '.php?MENU_FLAG=';
        echo $MENU_FLAG;
        echo '&RUN_ID=';
        echo $RUN_ID;
        echo '&FLOW_ID=';
        echo $FLOW_ID;
        echo '&PRCS_ID=';
        echo $PRCS_ID;
        echo '&OP_FLAG=';
        echo $OP_FLAG;
        echo '"  ';
        if (($MENU_FLAG != '1'))
        {
          echo 'target=_parent';
        }
        echo '>委托</a>&nbsp;
';
      }
      else
      {
        if ((($PRCS_FLAG == '3') AND ($OP_FLAG == '1')))
        {
          echo '          <a href="javascript:call_back(';
          echo $RUN_ID;
          echo ',';
          echo $PRCS_ID;
          echo ');">收回</a>
';
        }
      }
      if ((($LOGIN_USER_PRIV == '1') AND $PRCS_OVER))
      {
        echo '          <a href="javascript:restore_run(';
        echo $RUN_ID;
        echo ',';
        echo $FLOW_ID;
        echo ');">恢复执行</a>&nbsp;
          <a href="javascript:edit_run(';
        echo $RUN_ID;
        echo ',';
        echo $FLOW_ID;
        echo ');">编辑</a>&nbsp;
';
      }
      echo '
      </td>
    </tr>
';
      if ((($QUERY_LIMIT != '') AND ($QUERY_LIMIT <= $FLOW_COUNT)))
      {
        break;
      }
      continue;
    }
  }
  if ((0 < $FLOW_COUNT))
  {
    echo '</table>';
    if (($FLOW_ID_GLOBAL OR ($LOGIN_USER_PRIV == '1')))
    {
      echo '  <table border="0" cellspacing="0" width="100%" class="small" cellpadding="3" align="center">
  <tr class="TableControl">
  <td colspan="10">
  	&nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
    <label for="allbox_for" style="cursor:hand;color:blue"><u><b>全选</b></u></label> &nbsp;
';
      if ($FLOW_ID_GLOBAL)
      {
        echo '    <input type="button"  value="导出Excel" class="SmallButton" onClick="export_run_sel();" title="导出所选工作到Excel"> &nbsp;
';
      }
      if (($LOGIN_USER_PRIV == '1'))
      {
        echo '    <input type="button"  value="管理员删除" class="SmallButton" onClick="delete_run_sel();" title="删除所选工作"> &nbsp;
';
      }
      if ((($LIST_VIEW != '') AND $FLOW_ID_GLOBAL))
      {
        echo '   ';
        echo '<s';
        echo 'elect name="LIST_VIEW" class="SmallSelect">
';
        $MY_ARRAY = explode ('^', $LIST_VIEW);
        $ARRAY_COUNT = sizeof ($MY_ARRAY);
        if (($MY_ARRAY[($ARRAY_COUNT - 1)] == ''))
        {
          --$ARRAY_COUNT;
        }
        for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
        {
          $ITEM_NAME = strtok ($MY_ARRAY[$I], '~');
          echo '   	   <option value="';
          echo urlencode ($MY_ARRAY[$I]);
          echo '">';
          echo $ITEM_NAME;
          echo '</option>
';
        }
        echo '  </select>
  <input type="button"  value="列表项导出" class="SmallButton" onClick="export_list_view();" title="导出所选工作中的列表项到Excel"> &nbsp;
';
      }
      echo '  </td></tr>
  </table>
';
    }
    message ('', (('共 '.$FLOW_COUNT).' 条'));
    echo '<s';
    echo 'cript>
function excel_data()
{
 	document.form1.RUN_ID_STR.value=document.form1.RUN_ID_STR_ALL.value;
 	document.form1.action="excel_data.php";
  document.form1.submit();
}
</script>
';
  }
  else
  {
    message ('', '无符合条件的工作');
  }
  if (!$QUERY_SMALL)
  {
    button_back ();
  }
  else
  {
    echo '    <div align=center><input type="button"  value="返回" class="BigButton" onClick="location=\'blank.php\';"></div>
';
  }
  echo '
<form action="" method="post" name="form1">
  <input type="hidden" value="';
  echo $FLOW_ID;
  echo '" name="FLOW_ID">
  <input type="hidden" value="" name="RUN_ID_STR">
  <input type="hidden" value="';
  echo $RUN_ID_STR;
  echo '" name="RUN_ID_STR_ALL">
  <input type="hidden" value="" name="QUERY_FLAG">
  <input type="hidden" value="" name="LIST_VIEW_STR">
</form>
</body>
</html>';
?>