?? search.php
字號:
}
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()">
<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>
';
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>
<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>
';
}
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>
<a href="javascript:edit_run(';
echo $RUN_ID;
echo ',';
echo $FLOW_ID;
echo ');">編輯</a>
';
}
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">
<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>
';
if ($FLOW_ID_GLOBAL)
{
echo ' <input type="button" value="導出Excel" class="SmallButton" onClick="export_run_sel();" title="導出所選工作到Excel">
';
}
if (($LOGIN_USER_PRIV == '1'))
{
echo ' <input type="button" value="管理員刪除" class="SmallButton" onClick="delete_run_sel();" title="刪除所選工作">
';
}
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">
';
}
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>';
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -