📄 manage.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>还书</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$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($LEND_COUNT >= $AMT)
{
$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");
?>
</body>
</html>
<?
/**
* 转换为unix时间戳
*/
function gettime($d)
{
if(is_numeric($d))
return $d;
else
{
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]);
}
else
{
$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; break;
}
$timestamp = mktime($hours ,$minutes, $seconds,$month ,$day, $year);
return $timestamp;
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -