?? 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 + -