📄 search.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once '../prcs_role.php';
echo '
<html>
<head>
<title>工作流查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript src="/inc/sort_table.js"></script>
';
echo '<s';
echo 'cript>
function form_view(RUN_ID,FLOW_ID)
{
myleft=(screen.availWidth-800)/2;
window.open("../list/print?RUN_ID="+RUN_ID+"&FLOW_ID="+FLOW_ID,"","status=0,toolbar=no,menubar=no,width=800,height=600,location=no,scrollbars=yes,resizable=yes,left="+myleft+",top=50");
}
function flow_view(RUN_ID,FLOW_ID)
{
myleft=(screen.availWidth-600)/2;
window.open("../list/flow_view.php?RUN_ID="+';
echo '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,FLOW_ID)
{
myleft=(screen.availWidth-800)/2;
window.open("../list/input_form?RUN_ID="+RUN_ID+"&MENU_FLAG=';
echo $MENU_FLAG;
echo '&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,left="+myleft+",top=50");
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
if(document.all("allbox").checked)
check_flag=1;
else
check_flag=0;
for (i=0;i<document.a';
echo 'll("run_select").length;i++)
{
if(check_flag)
document.all("run_select").item(i).checked=true;
else
document.all("run_select").item(i).checked=false;
}
if(i==0)
{
if(check_flag)
document.all("run_select").checked=true;
else
document.all("run_select").checked=false;
}
}
function get_run_str()
{
var run_str="";
if(docume';
echo 'nt.all("allbox").checked)
{
document.form1.RUN_ID_STR.value=document.form1.RUN_ID_STR_ALL.value;
return true;
}
for(i=0;i<document.all("run_select").length;i++)
{
el=document.all("run_select").item(i);
if(el.checked)
{ val=el.value;
run_str+=val + ",";
}
}
if(i==0)
{
el=document.all("run_select");
if(el.checked)
';
echo ' { val=el.value;
run_str+=val + ",";
}
}
if(run_str=="")
return false;
else
{
document.form1.RUN_ID_STR.value=run_str;
return true;
}
}
function delete_run_sel()
{
msg="确认要删除所选工作么？";
if(window.confirm(msg))
{
if(!get_run_str())
{
alert("要删除工作，请至少选择其中一项。");
return;
}
';
echo ' document.form1.action="../list/delete.php";
document.form1.submit();
}
}
function export_run_sel()
{
if(!get_run_str())
{
alert("要导出工作，请至少选择其中一项。");
return;
}
document.form1.action="excel_data.php";
document.form1.submit();
}
function export_list_view()
{
if(!get_run_str())
{
alert("要导出工作，请至少选择其中一项。");
';
echo ' return;
}
document.form1.action="excel_list_view.php";
document.form1.LIST_VIEW_STR.value=LIST_VIEW.value;
document.form1.submit();
}
function call_back(RUN_ID,PRCS_ID)
{
msg="下一步骤尚未接收时可收回至本步骤重新办理，确认要收回么？";
if(window.confirm(msg))
{
url="../list/call_back.php?FLOW_ID=';
echo $FLOW_ID;
echo '&RUN_ID="+RUN_ID+"&PRCS_ID="+PRCS_ID;
';
if (($MENU_FLAG != '1'))
{
echo 'parent.';
}
echo 'location=url;
}
}
function restore_run(RUN_ID,FLOW_ID)
{
msg=\'确认要将该工作恢复到执行中么？\';
if(window.confirm(msg))
{
url="restore.php?FLOW_ID="+FLOW_ID+"&RUN_ID="+RUN_ID;
location=url;
}
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1";
loc_x=document.bod';
echo 'y.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="SortTable(\'flow_table\')">
';
if (($FLOW_ID != ''))
{
$query = (((''.'SELECT FLOW_NAME from FLOW_TYPE WHERE FLOW_ID=\'').$FLOW_ID).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FLOW_NAME = $ROW['FLOW_NAME'];
}
$FLOW_ID_GLOBAL = 1;
}
if (!$QUERY_SMALL)
{
echo '<img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 工作查询结果 ';
echo $FLOW_NAME;
echo '</span>
';
}
$query = 'SELECT FLOW_RUN.RUN_ID,RUN_NAME,PRCS_TIME,FLOW_TYPE.FLOW_ID,FLOW_NAME,FLOW_TYPE,MANAGE_USER,QUERY_USER,ATTACHMENT_ID,ATTACHMENT_NAME from FLOW_TYPE,FLOW_RUN,FLOW_RUN_PRCS WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID';
if ($FLOW_ID_GLOBAL)
{
($query .= (((''.' and FLOW_TYPE.FLOW_ID=\'').$FLOW_ID).'\''));
}
if (($RUN_ID != ''))
{
($query .= (((''.' and FLOW_RUN.RUN_ID=\'').$RUN_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;
}
default:
{
($WHERE_STR .= ((' like \'%'.$FIELDVALUE).'%\''));
break;
}
}
($query .= $WHERE_STR);
}
if (($ATTACHMENT_NAME != ''))
{
($query .= (((''.' and ATTACHMENT_NAME like \'%').$ATTACHMENT_NAME).'%\''));
}
if (((($FLOW_QUERY_TYPE == 'ALL') AND ($LOGIN_USER_PRIV != 1)) OR ($FLOW_QUERY_TYPE == '2')))
{
$query_my = ($query.(((''.' and USER_ID=\'').$LOGIN_USER_ID).'\''));
$cursor = exequery ($connection, $query_my);
while ($ROW = mysql_fetch_array ($cursor))
{
($MY_RUN_ID .= ($ROW['RUN_ID'].','));
}
if (($MY_RUN_ID != ''))
{
$MY_RUN_ID = substr ($MY_RUN_ID, 0, -1);
}
else
{
$MY_RUN_ID = '0';
}
}
if (($PRCS_DATE1 != ''))
{
($query .= (((''.' and PRCS_TIME>=\'').$PRCS_DATE1).' 00:00:00\''));
}
if (($PRCS_DATE2 != ''))
{
($query .= (((''.' and PRCS_TIME<=\'').$PRCS_DATE2).' 23:59:59\''));
}
$query_global = $query;
if ((($FLOW_QUERY_TYPE == 'ALL') AND ($LOGIN_USER_PRIV != 1)))
{
($query .= (((((((((((''.' and (FLOW_RUN.RUN_ID in (').$MY_RUN_ID).') or MANAGE_USER like \'%,').$LOGIN_USER_ID).',%\' or MANAGE_USER like \'').$LOGIN_USER_ID).',%\' or QUERY_USER like \'%,').$LOGIN_USER_ID).',%\' or QUERY_USER like \'').$LOGIN_USER_ID).',%\')'));
}
else
{
if (($FLOW_QUERY_TYPE == '1'))
{
$TO_ID = $LOGIN_USER_ID;
}
else
{
if (($FLOW_QUERY_TYPE == '2'))
{
($query .= (((''.' and FLOW_RUN.RUN_ID in (').$MY_RUN_ID).')'));
}
else
{
if ((($FLOW_QUERY_TYPE == '3') AND ($LOGIN_USER_PRIV != 1)))
{
($query .= (((((((((''.' and (MANAGE_USER like \'%,').$LOGIN_USER_ID).',%\' or MANAGE_USER like \'').$LOGIN_USER_ID).',%\' or QUERY_USER like \'%,').$LOGIN_USER_ID).',%\' or QUERY_USER like \'').$LOGIN_USER_ID).',%\')'));
}
}
}
}
$query_run = ($query_global.' and PRCS_FLAG<>\'4\'');
$cursor = exequery ($connection, $query_run);
while ($ROW = mysql_fetch_array ($cursor))
{
($STATUS_RUN .= ($ROW['RUN_ID'].','));
}
if (($STATUS_RUN != ''))
{
$STATUS_RUN = substr ($STATUS_RUN, 0, -1);
}
else
{
$STATUS_RUN = 0;
}
if (($FLOW_STATUS != 'ALL'))
{
if (($FLOW_STATUS == 0))
{
($query .= (((''.' and FLOW_RUN.RUN_ID in (').$STATUS_RUN).')'));
}
else
{
($query .= (((''.' and FLOW_RUN.RUN_ID not in (').$STATUS_RUN).')'));
}
}
if (($TO_ID != ''))
{
($query .= (((''.' and USER_ID=\'').$TO_ID).'\''));
}
($query .= ' and PRCS_ID=1 order by FLOW_RUN.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'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$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'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$NOT_FOUND = 0;
for ($I = 1; ($I <= $ITEM_ID_MAX); ++$I)
{
$STR = ('DATA_'.$I);
$FIELDVALUE = $$STR;
if ((($FIELDVALUE != '') AND ($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:
{
if (is_numeric ($FIELDVALUE))
{
($WHERE_STR .= (('>'.$FIELDVALUE).''));
break;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -