⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 bookno_info.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 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 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")
      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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -