?? search.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');">
<?
}
echo "<br>";
}//for
}
?>
</td>
<td align="center" nowrap><?=$STATUS?></td>
<td nowrap>
<a href="javascript:flow_view(<?=$RUN_ID?>,<?=$FLOW_ID?>)">流程圖</a>
<?
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>
<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>
<?
}
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>
<a href="javascript:edit_run(<?=$RUN_ID?>);">編輯</a>
<?
}
?>
</td>
</tr>
<?
}
if($FLOW_COUNT>0)
{
?>
<tr class="TableControl">
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
<label for="allbox_for">全選</label>
<?
if($LOGIN_USER_PRIV=="1")
{
?>
<input type="button" value="管理員刪除" class="SmallButton" onClick="delete_run_sel();" title="刪除所選工作">
<?
}
?>
<input type="button" value="導出Excel" class="SmallButton" onClick="export_run_sel();" title="導出所選工作到Excel">
<?
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">
<?
}
?>
</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 + -