?? delete.php
字號:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
echo "<html>\r\n<head>\r\n<title>工作流日志刪除</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body>\r\n";
if ( $BEGIN_DATE != "" )
{
$TIME_OK = is_date_time( $BEGIN_TIME );
if ( !$TIME_OK )
{
message( "錯誤", "起始時間格式不對，應形如 1999-1-2 14:55:20" );
button_back( );
exit( );
}
}
if ( $END_DATE != "" )
{
$TIME_OK = is_date_time( $END_TIME );
if ( !$TIME_OK )
{
message( "錯誤", "截止時間格式不對，應形如 1999-1-2 14:55:20" );
button_back( );
exit( );
}
}
if ( $RUN_ID_STR == "" )
{
$query = "delete from FLOW_RUN_LOG WHERE 1=1";
if ( $RUN_ID )
{
$query .= " and RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME )
{
$query .= " and RUN_NAME LIKE '%".$RUN_NAME."%'";
}
if ( $FLOW_ID != "ALL" )
{
$query .= " and FLOW_ID='".$FLOW_ID."'";
}
if ( $BEGIN_TIME )
{
$query .= " and TIME>='".$BEGIN_TIME." 00:00:00'";
}
if ( $END_TIME )
{
$query .= " and TIME<='".$END_TIME." 23:59:59'";
}
if ( $IP )
{
$query .= " and IP='".$IP."'";
}
if ( $USER_ID )
{
$query .= " and USER_ID='".$USER_ID."'";
}
if ( $LOG_TYPE )
{
$query .= " and TYPE='".$LOG_TYPE."'";
}
$cursor = exequery( $connection, $query );
$COUNT = mysql_affected_rows( );
message( "", "操作已成功，工刪除流程日志<font color=red>".$COUNT."</font>條" );
button_back( );
}
else
{
$query = "delete from FLOW_RUN_LOG WHERE FIND_IN_SET(LOG_ID,'".$RUN_ID_STR."')";
$cursor = exequery( $connection, $query );
echo 1;
exit( );
}
echo "</body>\r\n</html>\r\n";
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -