index.xhs

jvcl driver development envionment

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

Welcome to the medical supply store for hospital XYZ.

<p />Les bo顃es suivantes <b>doivent</b> rentrer le plus rapidemment possible:

<div class="Data">
<table class="Data">
<tr>
  <th>Items</th>
  <th>Date of stock</th>
  <th>Date de p閞emption</th>
  <th>Emprunteur</th>
</tr>
<%
  Request("SELECT * FROM boxes.xml, loans_box.xml, loans.xml, clients.xml WHERE (BoxId = LBBox)
     AND (ClientId = LoanClient) AND (LoanId = LBLoan) AND (LoanReturn IS NULL) AND (DAYSBETWEENNOW(BoxPeremption) < 10)");
  Display("templates/boxtocome.tpl");
  DisplayEmpty("templates/boxtocomeempty.tpl");
%>
</table>
</div>


<p />Les bo顃es suivantes devront bient魌 阾re <b>rest閞ilis閑s</b>:

<div class="Data">
<table class="Data">
<tr>
  <th>Bo顃e</th>
  <th>Date de p閞emption</th>
  <th>Status</th>
</tr>
<%
  Request("SELECT * FROM boxes.xml, box_status.xml WHERE (BoxStatus = StatId) AND (DAYSBETWEENNOW(BoxPeremption) < 10)");
  Display("templates/boxtosterilize.tpl");
  DisplayEmpty("templates/boxtosterilizeempty.tpl");
%>
</table>
</div>

<p />

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