add.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 271 行
PHP
271 行
<?
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;
}
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_sms1.php';
include_once 'inc/utility_all.php';
echo '
<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');
echo '<br>
<div align="center">
<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 '\'">
</div>
';
exit ();
}
}
if (($RETURN_DATE != ''))
{
$TIME_OK = is_date ($RETURN_DATE);
if (!$TIME_OK)
{
message ('错误', '还书日期格式不对，应形如 1999-1-2');
echo '<br>
<div align="center">
<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 '\'">
</div>
';
exit ();
}
}
if (((($BORROW_DATE != '') AND ($RETURN_DATE != '')) AND (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>
<div align="center">
<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 '\'">
</div>
';
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 == 0) AND ($DEPT != $DEPT_ID)))
{
message ('提示', '你无权借阅本书');
echo '<br>
<div align="center">
<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 '\'">
</div>
';
exit ();
}
$query = (((''.'SELECT count(*) from BOOK_MANAGE where BOOK_NO=\'').$BOOK_NO).'\' and BOOK_STATUS=\'0\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$LEND_COUNT = $ROW[0];
}
if ((($LEND == 1) AND ($AMT <= $LEND_COUNT)))
{
message ('提示', '该图书已经借出');
echo '<br>
<div align="center">
<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 '\'">
</div>
';
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) values (\'').$TO_ID).'\',\'').$BOOK_NO).'\',\'').$BORROW_DATE).'\',\'').$BORROW_REMARK).'\',\'').$LOGIN_USER_ID).'\',\'').$RETURN_DATE).'\')');
exequery ($connection, $query);
$ROW_ID = mysql_insert_id ();
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 ();
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?