📄 add.php
字号:
<?php
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 DEPT_ID 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='0') or (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( );
}
$query = "INSERT into BOOK_MANAGE(BUSER_ID,BOOK_NO,BORROW_DATE,BORROW_REMARK,RUSER_ID,RETURN_DATE,STATUS,REG_FLAG) values ('".$TO_ID."','{$BOOK_NO}','{$BORROW_DATE}','{$BORROW_REMARK}','{$LOGIN_USER_ID}','{$RETURN_DATE}','0','0')";
exequery( $connection, $query );
message( "提示", "保存成功" );
button_back( );
exit( );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -