📄 add.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.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">
<?
if($BORROW_DATE!="")
{
$TIME_OK=is_date($BORROW_DATE);
if(!$TIME_OK)
{
Message("错误","借书日期格式不对，应形如 1999-1-2");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='new.php?TO_ID=<?=$TO_ID?>&BOOK_NO=<?=$BOOK_NO?>&BORROW_DATE=<?=$BORROW_DATE?>&RETURN_DATE=<?=$RETURN_DATE?>&BORROW_REMARK=<?=$BORROW_REMARK?>'">
</div>
<?
exit;
}
}
if($RETURN_DATE!="")
{
$TIME_OK=is_date($RETURN_DATE);
if(!$TIME_OK)
{
Message("错误","还书日期格式不对，应形如 1999-1-2");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='new.php?TO_ID=<?=$TO_ID?>&BOOK_NO=<?=$BOOK_NO?>&BORROW_DATE=<?=$BORROW_DATE?>&RETURN_DATE=<?=$RETURN_DATE?>&BORROW_REMARK=<?=$BORROW_REMARK?>'">
</div>
<?
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("提示","所借阅的图书不存在");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='new.php?TO_ID=<?=$TO_ID?>&BOOK_NO=<?=$BOOK_NO?>&BORROW_DATE=<?=$BORROW_DATE?>&RETURN_DATE=<?=$RETURN_DATE?>&BORROW_REMARK=<?=$BORROW_REMARK?>'">
</div>
<?
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) or ($OPEN!="ALL_DEPT" && !strpos($OPEN,",")) or (!find_id($OPEN,$DEPT_ID) && $OPEN!="ALL_DEPT"))
{
Message("提示","你无权借阅本书");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='new.php?TO_ID=<?=$TO_ID?>&BOOK_NO=<?=$BOOK_NO?>&BORROW_DATE=<?=$BORROW_DATE?>&RETURN_DATE=<?=$RETURN_DATE?>&BORROW_REMARK=<?=$BORROW_REMARK?>'">
</div>
<?
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 || $LEND_COUNT>=$AMT)
{
Message("提示","该图书已经借出");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='new.php?TO_ID=<?=$TO_ID?>&BOOK_NO=<?=$BOOK_NO?>&BORROW_DATE=<?=$BORROW_DATE?>&RETURN_DATE=<?=$RETURN_DATE?>&BORROW_REMARK=<?=$BORROW_REMARK?>'">
</div>
<?
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);
//$ROW_ID=mysql_insert_id();
Message("提示","保存成功");
Button_Back();
exit;
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -