📄 getdata.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
while ( list( $k, $v ) = each( &$GLOBALS['_GET'] ) )
{
$$k = iconv( "UTF-8", "GBK", $v );
}
while ( list( $k, $v ) = each( &$GLOBALS['_POST'] ) )
{
$$k = iconv( "UTF-8", "GBK", $v );
}
ob_end_clean( );
if ( $act == "count" )
{
$query = "SELECT count(*) FROM FLOW_RUN WHERE DEL_FLAG=1";
}
else
{
$query = "SELECT * FROM FLOW_RUN WHERE DEL_FLAG=1";
}
if ( $FLOW_ID != "" )
{
$query .= " and FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
$query .= " and RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
$query .= " and RUN_NAME like '%".$RUN_NAME."%'";
}
if ( $PRCS_DATE1 != "" )
{
$query .= " and BEGIN_TIME>='".$PRCS_DATE1." 00:00:00'";
}
if ( $PRCS_DATE2 != "" )
{
$query .= " and BEGIN_TIME<='".$PRCS_DATE2." 23:59:59'";
}
if ( $TO_ID != "" )
{
$query .= " and FIND_IN_SET(BEGIN_USER,'".$TO_ID."')";
}
if ( $act == "count" )
{
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_COUNT = $ROW[0];
}
echo $RUN_COUNT;
exit( );
}
$query .= " order by RUN_ID desc";
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW['RUN_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
$BEGIN_TIME = $ROW['BEGIN_TIME'];
$FLOW_ID = $ROW['FLOW_ID'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
++$FLOW_COUNT;
$RUN_ID_STR_ALL .= $RUN_ID.",";
if ( $FLOW_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr id=\"";
echo $RUN_ID;
echo "\" class=\"";
echo $TableLine;
echo "\">\r\n \t<td nowrap align=\"center\">\r\n \t\t<input type=\"checkbox\" name=\"run_select\" value=\"";
echo $RUN_ID;
echo "\" onClick=\"check_one(self);\">\r\n \t</td>\r\n <td nowrap align=\"center\" class=\"TableContent\"><b>";
echo $RUN_ID;
echo "</b></td>\r\n <td>\r\n <a href=\"javascript:form_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ");\">";
echo $RUN_NAME;
echo "</a>\r\n </td>\r\n <td align=\"center\">";
echo $BEGIN_TIME;
echo "</td>\r\n <td>\r\n";
if ( $ATTACHMENT_ID == "" )
{
echo "无";
}
else
{
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, "" );
}
echo " </td>\r\n <td nowrap>\r\n <a href=\"javascript:flow_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ")\">流程图</a> \r\n <a href=\"javascript:recover_run('";
echo $RUN_ID;
echo "');\">还原</a> \r\n <a href=\"javascript:destroy_run('";
echo $RUN_ID;
echo "');\">销毁</a> \r\n </td>\r\n </tr>\r\n";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -