📄 manage.php
字号:
<?php
function gettime( $d )
{
if ( is_numeric( $d ) )
{
return $d;
}
if ( !is_string( $d ) )
{
return 0;
}
if ( ereg( ":", $d ) )
{
$buf = split( " +", $d );
$year = split( "[-/]", $buf[0] );
$hour = split( ":", $buf[1] );
if ( eregi( "pm", $buf[2] ) )
{
$hour[0] += 12;
}
return mktime( $hour[0], $hour[1], $hour[2], $year[1], $year[2], $year[0] );
}
$year = split( "[-/]", $d );
return mktime( 0, 0, 0, $year[1], $year[2], $year[0] );
}
function dateadd( $interval, $number, $date )
{
$date = gettime( $date );
$date_time_array = getdate( $date );
$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];
switch ( $interval )
{
case "yyyy" :
$year += $number;
break;
case "q" :
$month += $number * 3;
break;
case "m" :
$month += $number;
break;
case "y" :
case "d" :
case "w" :
$day += $number;
break;
case "ww" :
$day += $number * 7;
break;
case "h" :
$hours += $number;
break;
case "n" :
$minutes += $number;
break;
case "s" :
$seconds += $number;
}
$timestamp = mktime( $hours, $minutes, $seconds, $month, $day, $year );
return $timestamp;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<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 class=\"bodycolor\" topmargin=\"5\">\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $OP_FLAG == 11 )
{
$query = "update BOOK_MANAGE set BOOK_STATUS='1',STATUS='1',REAL_RETURN_TIME='".$CUR_DATE."' where BORROW_ID='{$BORROW_ID}'";
exequery( $connection, $query );
$query = "update BOOK_INFO set LEND='0' where BOOK_NO='".$BOOK_NO."'";
exequery( $connection, $query );
}
if ( $OP_FLAG == 21 )
{
$query = "SELECT * from BOOK_MANAGE where BORROW_ID='".$BORROW_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RETURN_DATE = $ROW['RETURN_DATE'];
$BUSER_ID = $ROW['BUSER_ID'];
}
$REMIND_DATE = date( "Y-m-d", dateadd( "d", -2, $RETURN_DATE ) )." 08:30:00";
$query = "SELECT AMT from BOOK_INFO where BOOK_NO='".$BOOK_NO."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$AMT = $ROW['AMT'];
}
$query = "update BOOK_MANAGE set BOOK_STATUS='0',STATUS='1' where BORROW_ID='".$BORROW_ID."'";
exequery( $connection, $query );
$query = "SELECT count(*) from BOOK_MANAGE where BOOK_NO='".$BOOK_NO."' and ((BOOK_STATUS='1' and STATUS='0') or (BOOK_STATUS='0' and STATUS='1'))";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LEND_COUNT = $ROW[0];
}
if ( $AMT <= $LEND_COUNT )
{
$query = "update BOOK_INFO set LEND='1' where BOOK_NO='".$BOOK_NO."'";
exequery( $connection, $query );
}
send_sms( $REMIND_DATE, $LOGIN_USER_ID, $BUSER_ID, 0, "您借的图书(编号：".$BOOK_NO.")于".$RETURN_DATE."到期,请按时归还。", $REMIND_URL );
}
if ( $OP_FLAG == 22 )
{
$query = "update BOOK_MANAGE set STATUS='2' where BORROW_ID='".$BORROW_ID."'";
exequery( $connection, $query );
}
if ( $OP_FLAG == 31 )
{
$query = "update BOOK_MANAGE set BOOK_STATUS='1',STATUS='1',REAL_RETURN_TIME='".$CUR_DATE."' where BORROW_ID='{$BORROW_ID}'";
exequery( $connection, $query );
$query = "update BOOK_INFO set LEND='0' where BOOK_NO='".$BOOK_NO."'";
exequery( $connection, $query );
}
if ( $OP_FLAG == 32 )
{
$query = "update BOOK_MANAGE set STATUS='2' where BORROW_ID='".$BORROW_ID."'";
exequery( $connection, $query );
}
header( "location: index.php" );
echo "</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -