📄 bookno_info.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>选择客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<? include_once("inc/menu_button.js");?>
<script Language="JavaScript">
var parent_window = parent.dialogArguments;
function add_bookno(BOOK_NO,BOOK_NAME)
{
parent_window.form1.BOOK_NO.value="";
parent_window.form1.BOOK_NO.value=BOOK_NO;
parent.close();
}
</script>
</head>
<body class="bodycolor" onMouseover="borderize_on(event)" onMouseout="borderize_off(event)" onclick="borderize_on1(event)" topmargin="5">
<?
//============================ 显示客户信息 =======================================
$query1 = "SELECT * from USER where USER_ID='$USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$DEPT_ID=$ROW1["DEPT_ID"];
$query = "SELECT * from BOOK_INFO where (BOOK_NO like '%$BOOK_NO%') or (BOOK_NAME like '%$BOOK_NO%') order by BOOK_NO";
$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($LEND_FLAG==1 && $OPEN==0 && $DEPT!=$DEPT_ID && $USER_ID!="")
continue;
$BOOK_COUNT++;
if($BOOK_COUNT==1)
{
?>
<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<?
}
?>
<tr class="TableControl">
<td class="menulines" align="center" onclick="javascript:add_bookno('<?=$BOOK_NO?>','<?=$BOOK_NAME?>')" style="cursor:hand"><?=$BOOK_NO?>(<?=$BOOK_NAME?>)</a></td>
</tr>
<?
$BOOK_COUNT++;
if($BOOK_COUNT>=50)
break;
}
if($BOOK_COUNT==0)
Message("提示","没有图书信息");
else
{
?>
<thead class="TableControl">
<th bgcolor="#d6e7ef" align="center"><b>选择图书编号（最多显示50条）</b></th>
</thead>
</table>
<?
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -