📄 add.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/check_type.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\r\n<body class=\"bodycolor\">\r\n";
if ( $BORROW_DATE != "" )
{
$TIME_OK = is_date( $BORROW_DATE );
if ( !$TIME_OK )
{
message( "错误", "借书日期格式不对，应形如 1999-1-2" );
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TO_ID=";
echo $TO_ID;
echo "&BOOK_NO=";
echo $BOOK_NO;
echo "&BORROW_DATE=";
echo $BORROW_DATE;
echo "&RETURN_DATE=";
echo $RETURN_DATE;
echo "&BORROW_REMARK=";
echo $BORROW_REMARK;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
if ( $RETURN_DATE != "" )
{
$TIME_OK = is_date( $RETURN_DATE );
if ( !$TIME_OK )
{
message( "错误", "还书日期格式不对，应形如 1999-1-2" );
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TO_ID=";
echo $TO_ID;
echo "&BOOK_NO=";
echo $BOOK_NO;
echo "&BORROW_DATE=";
echo $BORROW_DATE;
echo "&RETURN_DATE=";
echo $RETURN_DATE;
echo "&BORROW_REMARK=";
echo $BORROW_REMARK;
echo "'\">\r\n</div>\r\n";
exit( );
}
}
if ( $BORROW_DATE != "" && $RETURN_DATE != "" && compare_date( $RETURN_DATE, $BORROW_DATE ) <= 0 )
{
message( "错误", "归还日期不能小于借书日期！" );
button_back( );
exit( );
}
$query = "SELECT * from BOOK_INFO where BOOK_NO='".$BOOK_NO."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LEND = $ROW['LEND'];
$AMT = $ROW['AMT'];
$DEPT = $ROW['DEPT'];
$OPEN = $ROW['OPEN'];
}
else
{
message( "提示", "所借阅的图书不存在" );
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TO_ID=";
echo $TO_ID;
echo "&BOOK_NO=";
echo $BOOK_NO;
echo "&BORROW_DATE=";
echo $BORROW_DATE;
echo "&RETURN_DATE=";
echo $RETURN_DATE;
echo "&BORROW_REMARK=";
echo $BORROW_REMARK;
echo "'\">\r\n</div>\r\n";
exit( );
}
$query = "SELECT * from USER where USER_ID='".$TO_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
}
if ( $OPEN == "1" )
{
$OPEN = "ALL_DEPT";
}
if ( !( $OPEN == "0" ) && $DEPT != $DEPT_ID || !( $OPEN != "ALL_DEPT" ) && !strpos( $OPEN, "," ) && !find_id( $OPEN, $DEPT_ID ) || $OPEN != "ALL_DEPT" )
{
message( "提示", "借书人无权借阅本书" );
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TO_ID=";
echo $TO_ID;
echo "&BOOK_NO=";
echo $BOOK_NO;
echo "&BORROW_DATE=";
echo $BORROW_DATE;
echo "&RETURN_DATE=";
echo $RETURN_DATE;
echo "&BORROW_REMARK=";
echo $BORROW_REMARK;
echo "'\">\r\n</div>\r\n";
exit( );
}
$query = "SELECT count(*) from BOOK_MANAGE where BOOK_NO='".$BOOK_NO."' and ((BOOK_STATUS='0' and STATUS='1') or (BOOK_STATUS='1' and STATUS='0'))";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LEND_COUNT = $ROW[0];
}
if ( $LEND == 1 && $AMT <= $LEND_COUNT )
{
message( "提示", "该图书已经借出" );
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TO_ID=";
echo $TO_ID;
echo "&BOOK_NO=";
echo $BOOK_NO;
echo "&BORROW_DATE=";
echo $BORROW_DATE;
echo "&RETURN_DATE=";
echo $RETURN_DATE;
echo "&BORROW_REMARK=";
echo $BORROW_REMARK;
echo "'\">\r\n</div>\r\n";
exit( );
}
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $BORROW_DATE == "" )
{
$BORROW_DATE = $CUR_DATE;
}
if ( $RETURN_DATE == "" )
{
$RETURN_DATE = date( "Y-m-d", dateadd( "d", 30, $BORROW_DATE ) );
}
$REMIND_DATE = date( "Y-m-d", dateadd( "d", -2, $RETURN_DATE ) )." 08:30:00";
$query = "INSERT into BOOK_MANAGE(BUSER_ID,BOOK_NO,BORROW_DATE,BORROW_REMARK,RUSER_ID,RETURN_DATE,REG_FLAG,BOOK_STATUS,STATUS) values ('".$TO_ID."','{$BOOK_NO}','{$BORROW_DATE}','{$BORROW_REMARK}','{$LOGIN_USER_ID}','{$RETURN_DATE}','1','0','1')";
exequery( $connection, $query );
if ( $LEND_COUNT + 1 < $AMT )
{
$query = "update BOOK_INFO set LEND='0' where BOOK_NO='".$BOOK_NO."'";
}
else
{
$query = "update BOOK_INFO set LEND='1' where BOOK_NO='".$BOOK_NO."'";
}
exequery( $connection, $query );
send_sms( $REMIND_DATE, $LOGIN_USER_ID, $TO_ID, 0, "您借的图书(编号：".$BOOK_NO.")于".$RETURN_DATE."到期,请按时归还。", $REMIND_URL );
message( "提示", "保存成功" );
button_back( );
exit( );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -