client.xhs

来自「jvcl driver development envionment」· XHS 代码 · 共 67 行

<%
  Include("intro.inc");
%>

D閠ail d'un emprunteur:
<p />

<div class="Data">
<table class="Data">
<tr><td align="left">
<%
  Request("SELECT * FROM clients.xml
    WHERE (ClientId = $id)");
  Display("templates/clientdetails.tpl");
%>
</td></tr>
</table>
</div>

<p />Bo顃es emprunt閑s non encore ramen閑s:

<div class="Data">
<table class="Data">
<tr>
  <th>Bo顃e</th>
  <th>Date d'emprunt</th>
  <th>Date de p閞emption</th>
</tr>
<%
  Request("SELECT * FROM boxes.xml, loans.xml, loans_box.xml
    WHERE (LoanId = LBLoan) AND (LBBox = BoxId) AND (LoanClient = $id) AND (LoanReturn IS NULL)
    ORDER BY Date(LoanDeparture) DESC ");
  Display("templates/clientnonreturn.tpl");
  DisplayEmpty("templates/clientnonreturnempty.tpl");
%>
</table>
</div>


<p />Derni鑢es bo顃es emprunt閑s: (<a href="client_loans.xhs?id=<%echo("$id")%>">Tous ses emprunts</a>)


<div class="Data">
<table class="Data">
<tr>
  <th>Bo顃e</th>
  <th>Date d'emprunt</th>
  <th>Date de p閞emption</th>
</tr>
<%
  Request("SELECT * FROM boxes.xml, loans.xml, loans_box.xml
    WHERE (LoanId = LBLoan) AND (LBBox = BoxId) AND (LoanClient = $id)
    ORDER BY Date(LoanDeparture) DESC
    LIMIT 10");
  Display("templates/clientnonreturn.tpl");
  DisplayEmpty("templates/clientnonreturnempty.tpl");
%>
</table>
</div>


<p />

<%
  Include("outro.inc");
%>