⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("../prcs_role.php");
?>

<html>
<head>
<title>工作流查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script>
function form_view(RUN_ID,FLOW_ID)
{
  window.open("../list/print?RUN_ID="+RUN_ID+"&FLOW_ID="+FLOW_ID,"FLOW_PRINT","status=0,toolbar=no,menubar=no,width=800,height=600,location=no,scrollbars=yes,resizable=yes");
}

function flow_view(RUN_ID,FLOW_ID)
{
  myleft=(screen.availWidth-600)/2;
  window.open("../list/flow_view.php?RUN_ID="+RUN_ID+"&FLOW_ID="+FLOW_ID,"flow_view","status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=600,height=400,left="+myleft+",top=100");
}

function edit_run(RUN_ID)
{
  window.open("../list/input_form?RUN_ID="+RUN_ID+"&MENU_FLAG=<?=$MENU_FLAG?>&EDIT_MODE=1&FLOW_ID=<?=$FLOW_ID?>","edit_run","status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=600");
}

function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}

function check_all()
{
 for (i=0;i<document.all("run_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("run_select").item(i).checked=true;
   else
      document.all("run_select").item(i).checked=false;
 }

 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("run_select").checked=true;
   else
      document.all("run_select").checked=false;
 }
}

function delete_run_sel()
{
  delete_str="";
  for(i=0;i<document.all("run_select").length;i++)
  {

      el=document.all("run_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("run_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("要删除工作，请至少选择其中一项。");
     return;
  }

  msg='确认要删除所选工作么？';
  if(window.confirm(msg))
  {
    url="../list/delete.php?QUERY_FLAG=1&FLOW_ID=<?=$FLOW_ID?>&RUN_ID="+delete_str;
    location=url;
  }
}

function export_run_sel()
{
  export_str="";
  for(i=0;i<document.all("run_select").length;i++)
  {

      el=document.all("run_select").item(i);
      if(el.checked)
      {  val=el.value;
         export_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("run_select");
      if(el.checked)
      {  val=el.value;
         export_str+=val + ",";
      }
  }

  if(export_str=="")
  {
     alert("要导出工作，请至少选择其中一项。");
     return;
  }

  url="excel_data.php?FLOW_ID=<?=$FLOW_ID?>&RUN_ID_STR="+export_str;
  window.open(url);
}

function export_list_view()
{
  export_str="";
  for(i=0;i<document.all("run_select").length;i++)
  {

      el=document.all("run_select").item(i);
      if(el.checked)
      {  val=el.value;
         export_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("run_select");
      if(el.checked)
      {  val=el.value;
         export_str+=val + ",";
      }
  }

  if(export_str=="")
  {
     alert("要导出工作，请至少选择其中一项。");
     return;
  }

  LIST_VIEW_STR=LIST_VIEW.value;
  url="excel_list_view.php?FLOW_ID=<?=$FLOW_ID?>&LIST_VIEW_STR="+LIST_VIEW_STR+"&RUN_ID_STR="+export_str;
  window.open(url);
}

function call_back(RUN_ID,PRCS_ID)
{
  msg="下一步骤尚未接收时可收回至本步骤重新办理，确认要收回么？";
  if(window.confirm(msg))
  {
    url="../list/call_back.php?FLOW_ID=<?=$FLOW_ID?>&RUN_ID="+RUN_ID+"&PRCS_ID="+PRCS_ID;
    <?if($MENU_FLAG!="1")echo "parent.";?>location=url;
  }
}

function restore_run(RUN_ID)
{
  msg='确认要将该工作恢复到执行中么？';
  if(window.confirm(msg))
  {
    url="restore.php?FLOW_ID=<?=$FLOW_ID?>&RUN_ID="+RUN_ID;
    location=url;
  }
}
</script>
</head>

<body class="bodycolor" topmargin="5">

<?
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID=$FLOW_ID";
$cursor1= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
{
   $FLOW_NAME=$ROW["FLOW_NAME"];
   $FLOW_TYPE = $ROW["FLOW_TYPE"];
   $MANAGE_USER = $ROW["MANAGE_USER"];
   $QUERY_USER = $ROW["QUERY_USER"];
}
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 工作流查询 - <?=$FLOW_NAME?></span>
    </td>
  </tr>
</table>

<?
 $query = "SELECT * from FLOW_RUN WHERE FLOW_ID=$FLOW_ID";

 //--- 文号条件 ---
 if($RUN_NAME!="")
 {
   $FIELDVALUE=$RUN_NAME;
   $WHERE_STR=" and RUN_NAME";
   switch($RUN_NAME_RELATION)
   {
     case 1: $WHERE_STR.="='".$FIELDVALUE."'";
             break;
     case 2: $WHERE_STR.=">'".$FIELDVALUE."'";
             break;
     case 3: $WHERE_STR.="<'".$FIELDVALUE."'";
             break;
     case 4: $WHERE_STR.=">='".$FIELDVALUE."'";
             break;
     case 5: $WHERE_STR.="<='".$FIELDVALUE."'";
             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;
   }

   $query.=$WHERE_STR;
 }

 //--- 公共附件条件 ---
 if($ATTACHMENT_NAME!="")
    $query.=" and ATTACHMENT_NAME like '%$ATTACHMENT_NAME%'";

 $query.=" order by RUN_ID desc";
 $cursor = exequery($connection,$query);

 $FLOW_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $RUN_ID=$ROW["RUN_ID"];
    $RUN_NAME=$ROW["RUN_NAME"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

    //--- 排除不是自己经手的流程，OA管理员可以查询所有流程 ---
    if($LOGIN_USER_PRIV!="1" && !find_id($MANAGE_USER,$LOGIN_USER_ID) && !find_id($QUERY_USER,$LOGIN_USER_ID))
    {
      $query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID=$RUN_ID AND USER_ID='$LOGIN_USER_ID'";
      $cursor1= exequery($connection,$query1);
      if(!mysql_fetch_array($cursor1))
         continue;
    }

    //--- 开始时间条件检查 ---
    $PRCS_TIME="";
    $query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID=$RUN_ID AND PRCS_ID=1";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $PRCS_TIME=$ROW["PRCS_TIME"];
       $PRCS_DATE=strtok($PRCS_TIME," ");

       if($PRCS_DATE1!="" && compare_date($PRCS_DATE,$PRCS_DATE1)<0)
          continue;

       if($PRCS_DATE2!="" && compare_date($PRCS_DATE,$PRCS_DATE2)>0)
          continue;

       if($PRCS_TIME=="0000-00-00 00:00:00")
          $PRCS_TIME="";
    }

    //--- 流程状态条件检查 ---
    $query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID=$RUN_ID AND PRCS_FLAG<>'4'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $STATUS="<font color=red>执行中</font>";
       $PRCS_OVER=0;
       if($FLOW_STATUS=="1")
          continue;
    }
    else
    {
       $STATUS="已结束";
       $PRCS_OVER=1;
       if($FLOW_STATUS=="0")
          continue;
    }

    //--- 数据条件检查 ---
    $NOT_FOUND=0;
    for($I=1;$I<=$ITEM_ID_MAX;$I++)
    {
      $STR="DATA_".$I;
      $FIELDVALUE=$$STR;

      if($FIELDVALUE!="" && $FIELDVALUE!="SELECT_ALL_VALUE")
      {
      	$STR="RELATION_".$I;
      	$RELATION=$$STR;

      	if($FIELDVALUE=="CHECKBOX_ON")
      	   $FIELDVALUE="on";
      	else if($FIELDVALUE=="CHECKBOX_OFF")
      	   $FIELDVALUE="";

        $WHERE_STR=" where RUN_ID=$RUN_ID and ITEM_ID=$I and ITEM_DATA";
        switch($RELATION)
        {
          case 1: $WHERE_STR.="='".$FIELDVALUE."'";
                  break;
          case 2: $WHERE_STR.=">'".$FIELDVALUE."'";
                  break;
          case 3: $WHERE_STR.="<'".$FIELDVALUE."'";
                  break;
          case 4: $WHERE_STR.=">='".$FIELDVALUE."'";
                  break;
          case 5: $WHERE_STR.="<='".$FIELDVALUE."'";
                  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 * from FLOW_RUN_DATA".$WHERE_STR;
        $cursor1= exequery($connection,$query1);
        if(!$ROW=mysql_fetch_array($cursor1))
        {
           $NOT_FOUND=1;
           break;
        }

      }//if($FIELDVALUE!="")
    }//for

    if($NOT_FOUND==1) //数据部份未查询到
       continue;

    //--- 查询办理权限
    $query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID=$RUN_ID AND USER_ID='$LOGIN_USER_ID' and PRCS_FLAG<>'4' order by PRCS_FLAG";
    $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)
    {
?>
  <div align=right><input type="button" class="BigButton" value="生成Excel报表" onclick="excel_data()"></div>
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr class="TableHeader">
    	<td nowrap align="center">选择</td>
      <td nowrap align="center">名称/文号</td>
      <td nowrap align="center">开始时间</td>
      <td nowrap align="center">公共附件</td>
      <td nowrap align="center">状态</td>
      <td nowrap align="center">操作</td>
    </tr>
<?
    }

    if($FLOW_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
    	<td nowrap align="center">
    		<input type="checkbox" name="run_select" value="<?=$RUN_ID?>" onClick="check_one(self);">
    	</td>
      <td align="center">
        <a href="javascript:form_view(<?=$RUN_ID?>,<?=$FLOW_ID?>);"><?=$RUN_NAME?></a>
      </td>
      <td align="center"><?=$PRCS_TIME?></td>
      <td>
<?
      if($ATTACHMENT_ID=="")
         echo "无";
      else
      {
      	 $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
         $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

         $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
         for($I=0;$I<$ARRAY_COUNT;$I++)
         {
            if($ATTACHMENT_ID_ARRAY[$I]=="")
               continue;

            $ATTACH_IMAGE=image_mimetype($ATTACHMENT_NAME_ARRAY[$I]);
?>
            <img src="/general/netdisk/images/<?=$ATTACH_IMAGE?>" align="absmiddle">
<?
            if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
               $DOC_FLAG=1;
            else
               $DOC_FLAG=0;
?>
<a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
<?
            if($DOC_FLAG==1)
            {
?>
	     <input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5&PRINT=1','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<?
            }
           if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
           {
?>
	       <input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
           }
            echo "<br>";

         }//for
      }
?>
      </td>
      <td align="center" nowrap><?=$STATUS?></td>
      <td nowrap>
          <a href="javascript:flow_view(<?=$RUN_ID?>,<?=$FLOW_ID?>)">流程图</a>&nbsp;
<?
      if($PRCS_FLAG=="1" || $PRCS_FLAG=="2")
      {
?>
          <a href="../list/input_form?MENU_FLAG=<?=$MENU_FLAG?>&RUN_ID=<?=$RUN_ID?>&FLOW_ID=<?=$FLOW_ID?>&PRCS_ID=<?=$PRCS_ID?>&FLOW_PRCS=<?=$FLOW_PRCS?>" <?if($MENU_FLAG!="1")echo "target=_parent";?>>办理</a>&nbsp;
          <a href="../list/others/<?if($FLOW_TYPE=="1")echo "others";else echo"others_free";?>.php?MENU_FLAG=<?=$MENU_FLAG?>&RUN_ID=<?=$RUN_ID?>&FLOW_ID=<?=$FLOW_ID?>&PRCS_ID=<?=$PRCS_ID?>&OP_FLAG=<?=$OP_FLAG?>"  <?if($MENU_FLAG!="1")echo "target=_parent";?>>委托</a>&nbsp;
<?
      }
      else if($PRCS_FLAG=="3" && $OP_FLAG=="1")
      {
?>
          <a href="javascript:call_back(<?=$RUN_ID?>,<?=$PRCS_ID?>);">收回</a>
<?
      }

      if($LOGIN_USER_PRIV=="1"&&$PRCS_OVER)
      {
?>
          <a href="javascript:restore_run(<?=$RUN_ID?>);">恢复执行</a>&nbsp;
          <a href="javascript:edit_run(<?=$RUN_ID?>);">编辑</a>&nbsp;
<?
      }
?>
      </td>
    </tr>
<?
 }

 if($FLOW_COUNT>0)
 {
?>
  <tr class="TableControl">
  <td colspan="10">
  	&nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
    <label for="allbox_for">全选</label> &nbsp;
<?
      if($LOGIN_USER_PRIV=="1")
      {
?>
    <input type="button"  value="管理员删除" class="SmallButton" onClick="delete_run_sel();" title="删除所选工作"> &nbsp;
<?
      }
?>
    <input type="button"  value="导出Excel" class="SmallButton" onClick="export_run_sel();" title="导出所选工作到Excel"> &nbsp;
<?
   if($LIST_VIEW!="")
   {
?>
   <select 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],"%");
?>
   	   <option value="<?=urlencode($MY_ARRAY[$I])?>"><?=$ITEM_NAME?></option>
<?
     }
?>
  </select>
  <input type="button"  value="列表项导出" class="SmallButton" onClick="export_list_view();" title="导出所选工作中的列表项到Excel"> &nbsp;
<?
   }
?>
  </td>
  </tr>
</table>
<?
 	  Message("","共 ".$FLOW_COUNT." 条符合条件的工作");
?>
<script>
function excel_data()
{
 	window.open("excel_data.php?FLOW_ID=<?=$FLOW_ID?>&RUN_ID_STR=<?=$RUN_ID_STR?>");
}
</script>

<?
 }
 else
    Message("","无符合条件的工作");

 Button_Back();
?>

</body>
</html>

⌨️ 快捷键说明

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