<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<link href="style.css" type="text/css" rel="stylesheet">
<!--#include file="conn.asp"-->
<%'
'從u表中取數據
dim uid
uid=request("id")
if uid<>"" then
sql="select * from u where id="&uid
set rs=db.execute(sql)
'從loans表中取數據
sql1="select  distinct * from loans,book where uid="&uid&" and loans.bid=book.id"
set rs1=server.CreateObject("adodb.recordset")
rs1.open sql1,db,1,3
%><title><%=rs("name")%>借書情況</title>

<div>用戶<%=rs("name")%>,已借書<%=rs("loan_num")%>本,還可以借<%=8-rs("loan_num")%>本.詳細情況如下:</div><br>

<table width="88%" border="0" align="center" cellspacing="0">
  <tr align="center" valign="middle" >
    <td >圖書名</td>
    <td >分類</td>
    <td>出版社</td>
    <td>價格</td>
    <td>日期</td>
	    <td>已借時間</td><td>操作</td>
  </tr>
  <%do while not rs1.eof%>
  <tr align="center"> 
    <td height="26"><%=rs1("bookname")%></td>
    <td height="26"><a href="book.asp?query=books_of_type&booktype=<%=rs1("booktype")%>" target="right" ><%=rs1("booktype")%></a></td>
    <td height="26"><a href="publishing.asp?p=<%=rs1("publishing")%>" target="right"><%=rs1("publishing")%></a></td>
    <td height="26"><%=rs1("bookmoney")%>元</td>
    <td height="26"><%=rs1("time")%></td>   
	 <td height="26"><%=DateDiff("d",rs1("time"),date())%>天&nbsp;&nbsp; 
	 <%if DateDiff("d",rs1("time"),date())>=30 then 
	 response.Write("<b>超期</b>")%>
	 <%=DateDiff("d",rs1("time"),date())-30 %>天
	 <%end if%></td>
<td height="26">
<%if session("usertype")="admin" then %><a href="restore_book.asp?id=<%=rs1("id")%>&uid=<%=rs1("uid")%>" target="right">還書</a><%end if%>
<%if session("usertype")="user" then
set qq=db.execute("select * from loans  where uid="&rs1("uid")&" and bid="&rs1("bid")&"")
if not qq("loan_") and DateDiff("d",rs1("time"),date())<30 then '沒有繼借并且沒超期
%>
<a href="jijie.asp?bid=<%=rs1("id")%>&uid=<%=rs1("uid")%>" target="right">繼借</a>
<%
else 
response.Write("..")
end if 
end if
%>
</td>
  </tr>
  <%
  rs1.movenext
  loop
  %>
</table>

<br><br><br>
<div><a href="index.asp" target="right">首頁</a>
&nbsp;&nbsp;&nbsp;<a href="javascript:history.go(-1)" target="right">返回</a>
</div>
<%end if%>