📄 search.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  echo '
<html>
<head>
<title>历史纪录查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_borrow(BORROW_ID,TO_ID,BOOK_NO,BOOK_STATUS)
{
  msg=\'确认要删除该记录么？\';
  if(window.confirm(msg))
  {
     URL="delete.php?BORROW_ID=" + BORROW_ID + "&TO_ID=" + TO_ID + "&BOOK_NO=" + BOOK_NO + "&BOOK_STATUS=" + BOOK_STATUS;
     window.location=URL;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($START_B != ''))
  {
    $TIME_OK = is_date ($START_B);
    if (!$TIME_OK)
    {
      message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($END_B != ''))
  {
    $TIME_OK = is_date ($END_B);
    if (!$TIME_OK)
    {
      message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($START_R != ''))
  {
    $TIME_OK = is_date ($START_R);
    if (!$TIME_OK)
    {
      message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($END_R != ''))
  {
    $TIME_OK = is_date ($END_R);
    if (!$TIME_OK)
    {
      message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($TO_ID != ''))
  {
    ($WHERE_STR .= (((''.' and BUSER_ID=\'').$TO_ID).'\''));
  }
  if (($BOOK_NO != ''))
  {
    ($WHERE_STR .= (((''.' and BOOK_NO=\'').$BOOK_NO).'\''));
  }
  if (($START_B != ''))
  {
    ($WHERE_STR .= (((''.' and BORROW_DATE>=\'').$START_B).'\''));
  }
  if (($END_B != ''))
  {
    ($WHERE_STR .= (((''.' and BORROW_DATE<=\'').$END_B).'\''));
  }
  if (($BOOK_STATUS != ''))
  {
    ($WHERE_STR .= (((''.' and BOOK_STATUS=\'').$BOOK_STATUS).'\''));
  }
  $query = (('SELECT count(*) from BOOK_MANAGE where 1=1'.$WHERE_STR).' order by RETURN_DATE desc');
  $cursor = exequery ($connection, $query);
  $BOOK_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $BOOK_COUNT = $ROW[0];
  }
  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/infofind.gif" width="22" height="18" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 历史纪录查询 </span><br>
   </td>
 </tr>
</table>
<table border="0" cellspacing="1" width="100%" 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>';
  echo '
    <td nowrap align="center">登记人</td>
    <td nowrap align="center">状  态</td>
    <td nowrap align="center">操  作</td>
 </tr>
';
  $query1 = str_replace ('count(*)', '*', $query);
  $cursor1 = exequery ($connection, $query1);
  $BOOK_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$BOOK_COUNT;
    $BORROW_ID = $ROW['BORROW_ID'];
    $BUSER_ID = $ROW['BUSER_ID'];
    $BOOK_NO1 = $ROW['BOOK_NO'];
    $BORROW_DATE = $ROW['BORROW_DATE'];
    $RUSER_ID = $ROW['RUSER_ID'];
    $RETURN_DATE = $ROW['RETURN_DATE'];
    $BOOK_STATUS1 = $ROW['BOOK_STATUS'];
    $REAL_RETURN_TIME = $ROW['REAL_RETURN_TIME'];
    if (($REAL_RETURN_TIME == '0000-00-00'))
    {
      $REAL_RETURN_TIME = '';
    }
    $query2 = (((''.'select * from USER where USER_ID=\'').$BUSER_ID).'\'');
    $cursor2 = exequery ($connection, $query2);
    while ($ROW = mysql_fetch_array ($cursor2))
    {
      $USER_NAME1 = $ROW['USER_NAME'];
    }
    $query2 = (((''.'select * from USER where USER_ID=\'').$RUSER_ID).'\'');
    $cursor2 = exequery ($connection, $query2);
    while ($ROW = mysql_fetch_array ($cursor2))
    {
      $USER_NAME2 = $ROW['USER_NAME'];
    }
    $query2 = (((''.'select * from BOOK_INFO where BOOK_NO=\'').$BOOK_NO1).'\'');
    $cursor2 = exequery ($connection, $query2);
    while ($ROW = mysql_fetch_array ($cursor2))
    {
      $BOOK_NAME = $ROW['BOOK_NAME'];
    }
    if (($BOOK_STATUS1 == '1'))
    {
      $BOOK_STATUS_DESC = '已还';
    }
    if (($BOOK_STATUS1 == '0'))
    {
      $BOOK_STATUS_DESC = '未还';
    }
    if ((($BOOK_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '
  <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $USER_NAME1;
    echo '</td>
      <td nowrap align="center">';
    echo $BOOK_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $BORROW_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $RETURN_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $REAL_RETURN_TIME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME2;
    echo '</td>
      <td nowrap align="center">';
    echo $BOOK_STATUS_DESC;
    echo '</td>
';
    if (($BOOK_STATUS1 == '0'))
    {
      echo '      <td nowrap align="center">&nbsp;</td>
';
    }
    if (($BOOK_STATUS1 == '1'))
    {
      echo '      <td nowrap align="center">
        <a href="javascript:delete_borrow(\'';
      echo $BORROW_ID;
      echo '\',\'';
      echo $TO_ID;
      echo '\',\'';
      echo $BOOK_NO;
      echo '\',\'';
      echo $BOOK_STATUS;
      echo '\');"> 彻底删除</a>
     	</td>
';
    }
    echo '  </tr>
';
  }
  echo '</table>
<br>
<div align="center">
<input type="button"  value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明

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