bookno_info.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 92 行

PHP
92
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>选择客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  include_once 'inc/menu_button.js';
  echo '
';
  echo '<s';
  echo 'cript 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) AND ($OPEN == 0)) AND ($DEPT != $DEPT_ID)) AND ($USER_ID != '')))
    {
      continue;
    }
    else
    {
      ++$BOOK_COUNT;
      if (($BOOK_COUNT == 1))
      {
        echo '
<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3"  bordercolorlight="#000000" bordercolordark="#FFFFFF"  align="center">
';
      }
      echo '<tr class="TableControl">
  <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>
</tr>
';
      ++$BOOK_COUNT;
      if ((50 <= $BOOK_COUNT))
      {
        break;
      }
      continue;
    }
  }
  if (($BOOK_COUNT == 0))
  {
    message ('提示', '没有图书信息');
  }
  else
  {
    echo '<thead class="TableControl">
  <th bgcolor="#d6e7ef" align="center"><b>选择图书编号(最多显示50条)</b></th>
</thead>
</table>
';
  }
  echo '
</body>
</html>
';
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?