📄 bookno_info.php
字号:
<?php
include_once( "inc/auth.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";
include_once( "inc/menu_button.js" );
echo "\r\n<script Language=\"JavaScript\">\r\nvar parent_window = parent.dialogArguments;\r\n\r\nfunction add_bookno(BOOK_NO,BOOK_NAME)\r\n{\r\n\tparent_window.form1.BOOK_NO.value=\"\";\r\n parent_window.form1.BOOK_NO.value=BOOK_NO;\r\n parent.close();\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" onMouseover=\"borderize_on(event)\" onMouseout=\"borderize_off(event)\" onclick=\"borderize_on1(event)\" topmargin=\"5\">\r\n";
$query1 = "SELECT MANAGE_DEPT_ID from BOOK_MANAGER where find_in_set('".$LOGIN_USER_ID."',MANAGER_ID)";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$MANAGE_DEPT_ID .= $ROW1['MANAGE_DEPT_ID'];
}
$query = "SELECT BOOK_ID,BOOK_NO,DEPT,OPEN,BOOK_NAME from BOOK_INFO where ((BOOK_NO like '%".$BOOK_NO."%') or (BOOK_NAME like '%{$BOOK_NO}%')) and (OPEN='0' or OPEN='1' or find_in_set('{$DEPT_ID}',OPEN) or OPEN='ALL_DEPT') order by BOOK_NO limit 0,50";
$cursor = exequery( $connection, $query );
$BOOK_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$BOOK_ID = $ROW['BOOK_ID'];
$BOOK_NO = $ROW['BOOK_NO'];
$DEPT = $ROW['DEPT'];
$OPEN = $ROW['OPEN'];
$BOOK_NAME = $ROW['BOOK_NAME'];
if ( !find_id( $MANAGE_DEPT_ID, $DEPT ) || $MANAGE_DEPT_ID != "ALL_DEPT" )
{
++$BOOK_COUNT;
if ( $BOOK_COUNT == 1 )
{
echo "\r\n<table class=\"TableList\" width=\"95%\" align=\"center\">\r\n";
}
echo "<tr class=\"TableControl\">\r\n <td class=\"menulines\" align=\"center\" onclick=\"javascript:add_bookno('";
echo $BOOK_NO;
echo "','";
echo $BOOK_NAME;
echo "')\" style=\"cursor:hand\">";
echo $BOOK_NO;
echo "(";
echo $BOOK_NAME;
echo ")</a></td>\r\n</tr>\r\n";
++$BOOK_COUNT;
}
}
if ( $BOOK_COUNT == 0 )
{
message( "提示", "没有图书信息" );
}
else
{
echo "<thead class=\"TableControl\">\r\n <th bgcolor=\"#d6e7ef\" align=\"center\"><b>选择图书编号（最多显示50条）</b></th>\r\n</thead>\r\n</table>\r\n\r\n";
}
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -