bookno_info.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 84 行

PHP
84
字号
<?
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 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"];

$query1 = "SELECT DEPT_ID from USER where USER_ID='$USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
   $DEPT_ID=$ROW1["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")
      continue;
      
   $BOOK_COUNT++;
   
   if($BOOK_COUNT==1)
   {
?>

<table class="TableList"  width="95%" 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==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 + =
减小字号Ctrl + -
显示快捷键?