list.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 431 行
PHP
431 行
<?
  include_once 'inc/auth.php';
  $PAGE_SIZE = 15;
  echo '
<html>
<head>
<title>图书管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function delete_book(BOOK_ID)
{
 msg=\'确认要删除该图书么？\';
 if(window.confirm(msg))
 {
  URL="delete.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '&BOOK_ID=" + BOOK_ID;
  window.location=URL;
 }
}
function set_page()
{
 PAGE_START=(PAGE_NUM.value-1)*';
  echo $PAGE_SIZE;
  echo '+1;
 location="list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START="+PAGE_START;
}
</script>
</head>
<body class="bodycolor" topmargin="5" >
';
  $query = (((''.'SELECT POST_PRIV from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $POST_PRIV = $ROW['POST_PRIV'];
  }
  if (($BOOK_NAME != ''))
  {
    ($WHERE_STR .= ((' and BOOK_NAME like \'%'.$BOOK_NAME).'%\''));
  }
  if (($BOOK_NO != ''))
  {
    ($WHERE_STR .= ((' and BOOK_NO like \'%'.$BOOK_NO).'%\''));
  }
  if (($LEND != ''))
  {
    ($WHERE_STR .= (((''.' and LEND=\'').$LEND).'\''));
  }
  if (($AUTHOR != ''))
  {
    ($WHERE_STR .= ((' and AUTHOR like \'%'.$AUTHOR).'%\''));
  }
  if (($ISBN != ''))
  {
    ($WHERE_STR .= ((' and ISBN like \'%'.$ISBN).'%\''));
  }
  if (($PUB_HOUSE != ''))
  {
    ($WHERE_STR .= ((' and PUB_HOUSE like \'%'.$PUB_HOUSE).'%\''));
  }
  if (($AREA != ''))
  {
    ($WHERE_STR .= ((' and AREA like \'%'.$AREA).'%\''));
  }
  if (($TYPE_ID != 'all'))
  {
    ($WHERE_STR .= ((''.' and TYPE_ID=').$TYPE_ID));
  }
  if (($DEPT_ID != 'all'))
  {
    ($WHERE_STR .= ((''.' and DEPT=').$DEPT_ID));
  }
  if (((($DEPT_ID != $LOGIN_DEPT_ID) AND ($LOGIN_USER_PRIV != '1')) AND ($POST_PRIV != '1')))
  {
    ($WHERE_STR .= ' and OPEN=\'1\'');
  }
  if (($WHERE_STR != ''))
  {
    $WHERE_STR = (' where '.substr ($WHERE_STR, 5));
  }
  $query = (('SELECT count(*) from BOOK_INFO '.$WHERE_STR).(((''.' order by \'').$ORDER_FIELD).'\''));
  $cursor = exequery ($connection, $query);
  $BOOK_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $BOOK_COUNT = $ROW[0];
  }
  $PAGE_TOTAL = ($BOOK_COUNT / $PAGE_SIZE);
  $PAGE_TOTAL = ceil ($PAGE_TOTAL);
  if (($BOOK_COUNT <= $PAGE_SIZE))
  {
    $LAST_PAGE_START = 1;
  }
  else
  {
    if ((($BOOK_COUNT % $PAGE_SIZE) == 0))
    {
      $LAST_PAGE_START = (($BOOK_COUNT - $PAGE_SIZE) + 1);
    }
    else
    {
      $LAST_PAGE_START = (($BOOK_COUNT - ($BOOK_COUNT % $PAGE_SIZE)) + 1);
    }
  }
  if (($PAGE_START == ''))
  {
    $PAGE_START = 1;
  }
  if (($BOOK_COUNT < $PAGE_START))
  {
    $PAGE_START = $LAST_PAGE_START;
  }
  if (($PAGE_START < 1))
  {
    $PAGE_START = 1;
  }
  $PAGE_END = (($PAGE_START + $PAGE_SIZE) - 1);
  if (($BOOK_COUNT < $PAGE_END))
  {
    $PAGE_END = $BOOK_COUNT;
  }
  $PAGE_NUM = ((($PAGE_START - 1) / $PAGE_SIZE) + 1);
  $query1 = str_replace ('count(*)', '*', $query);
  $cursor1 = exequery ($connection, $query1);
  if (($BOOK_COUNT == 0))
  {
    message ('<br>提示', '没有符合条件的图书');
    echo '<br>
<div align="center">
<input type="button"  value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
';
    exit ();
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
  <td class="Big"><img src="/images/menu/book.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 图书查询结果 </span><br>
  </td>
  <td valign="bottom">
  ';
  echo '<s';
  echo 'pan class="small1">当前为第<b>';
  echo $PAGE_START;
  echo '</b>至<b>';
  echo $PAGE_END;
  echo '</b>条 (第';
  echo $PAGE_NUM;
  echo '页，共';
  echo $PAGE_TOTAL;
  echo '页，每页最多';
  echo $PAGE_SIZE;
  echo '条)</small>
  </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
    <td nowrap align="center">部门</td>
    <td nowrap align="center">书名</td>
    <td nowrap align="center">编号</td>
    <td nowrap align="center">类别</td>
    <td nowrap align="center">作者</td>
    <td nowrap align="center">出版社</td>
    <t';
  echo 'd nowrap align="center">存放地点</td>
    <td nowrap align="center">借阅状态</td>
    <td nowrap align="center">操作</td>
</tr>
';
  $BOOK_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$BOOK_COUNT;
    if (($BOOK_COUNT < $PAGE_START))
    {
      continue;
    }
    if (($PAGE_END < $BOOK_COUNT))
    {
      break;
    }
    $BOOK_ID = $ROW['BOOK_ID'];
    $BOOK_NAME1 = $ROW['BOOK_NAME'];
    $TYPE_ID1 = $ROW['TYPE_ID'];
    $AUTHOR1 = $ROW['AUTHOR'];
    $ISBN1 = $ROW['ISBN'];
    $PUB_HOUSE1 = $ROW['PUB_HOUSE'];
    $PUB_DATE1 = $ROW['PUB_DATE'];
    $AREA1 = $ROW['AREA'];
    $AMT1 = $ROW['AMT'];
    $PRICE1 = $ROW['PRICE'];
    $BRIEF1 = $ROW['BRIEF'];
    $LEND1 = $ROW['LEND'];
    $BORR_PERSON1 = $ROW['BORR_PERSON'];
    $MEMO1 = $ROW['MEMO'];
    $DEPT1 = $ROW['DEPT'];
    $BOOK_NO = $ROW['BOOK_NO'];
    if (($LEND1 == '1'))
    {
      $LEND_DESC = '已借出';
    }
    else
    {
      $LEND_DESC = '未借出';
    }
    $query2 = ((''.'SELECT TYPE_NAME from BOOK_TYPE where TYPE_ID=').$TYPE_ID1);
    $cursor2 = exequery ($connection, $query2);
    if ($ROW = mysql_fetch_array ($cursor2))
    {
      $TYPE_NAME = $ROW['TYPE_NAME'];
    }
    $query3 = ((''.'SELECT DEPT_NAME from DEPARTMENT where DEPT_ID=').$DEPT1);
    $cursor3 = exequery ($connection, $query3);
    if ($ROW = mysql_fetch_array ($cursor3))
    {
      $DEPT_NAME = $ROW['DEPT_NAME'];
    }
    if ((($BOOK_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '
  <tr class="';
    echo $TableLine;
    echo '">
    <td nowrap align="center">';
    echo $DEPT_NAME;
    echo '</td>
    <td nowrap align="center">';
    echo $BOOK_NAME1;
    echo '</td>
    <td nowrap align="center">';
    echo $BOOK_NO;
    echo '</td>
    <td nowrap align="center">';
    echo $TYPE_NAME;
    echo '</td>
    <td nowrap align="center">';
    echo $AUTHOR1;
    echo '</td>
    <td nowrap align="center">';
    echo $PUB_HOUSE1;
    echo '</td>
    <td nowrap align="center">';
    echo $AREA1;
    echo '</td>
    <td nowrap align="center">';
    echo $LEND_DESC;
    echo '</td>
    <td nowrap align="center" width="80">
<a href="edit.php?TYPE_ID=';
    echo $TYPE_ID;
    echo '&BOOK_NAME=';
    echo $BOOK_NAME;
    echo '&AUTHOR=';
    echo $AUTHOR;
    echo '&ISBN=';
    echo $ISBN;
    echo '&PUB_HOUSE=';
    echo $PUB_HOUSE;
    echo '&AREA=';
    echo $AREA;
    echo '&DEPT_ID=';
    echo $DEPT_ID;
    echo '&ORDER_FIELD=';
    echo $ORDER_FIELD;
    echo '&PAGE_START=';
    echo $PAGE_START;
    echo '&BOOK_ID=';
    echo $BOOK_ID;
    echo '"> 编辑</a>&nbsp;&nbsp;
      <a href="javascript:delete_book(';
    echo $BOOK_ID;
    echo ');"> 删除 </a>
    </td>
  </tr>
';
  }
  echo '  <tr class="TableControl">
  <td colspan="9" align="right">
     <input type="button"  value="首页" class="SmallButton"  ';
  if (($PAGE_START == 1))
  {
    echo 'disabled';
  }
  echo ' onclick="location=\'list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" ';
  if (($PAGE_START == 1))
  {
    echo 'disabled';
  }
  echo ' onclick="location=\'list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo ($PAGE_START - $PAGE_SIZE);
  echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" ';
  if (($BOOK_COUNT <= $PAGE_END))
  {
    echo 'disabled';
  }
  echo ' onclick="location=\'list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo ($PAGE_END + 1);
  echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  ';
  if (($BOOK_COUNT <= $PAGE_END))
  {
    echo 'disabled';
  }
  echo ' onclick="location=\'list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo $LAST_PAGE_START;
  echo '\'"> &nbsp;&nbsp;
     页数
     <input type="text" name="PAGE_NUM" value="';
  echo $PAGE_NUM;
  echo '" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;&nbsp;
  </td>
  </tr>
</table>
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>';
?>
list.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 list.php 源码文件，采用 PHP 编程语言编写，共 431 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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