Include("intro.inc");
%>
D閠ail d'une boite:
Request("SELECT * FROM boxes.xml, box_status.xml
WHERE (BoxId = $id) AND (StatId = BoxStatus)");
Display("templates/boxdetails.tpl");
%>
Content:
Name
Category
Serial
Request("SELECT * FROM box_items.xml, items.xml, categories.xml
WHERE (CatId = ItemCat) AND (BIBox = $id) AND (ItemId = BIItem)");
Display("templates/boxitems.tpl");
DisplayEmpty("templates/boxitemsempty.tpl");
%>
Ajouter:
Request("SELECT * FROM items.xml WHERE (ItemStatus = 1)");
Display("templates/items_add.tpl");
echo("");
echo("");
DisplayEmpty("templates/items_add_empty.tpl");
%>
Loans: (Tous les emprunts)
D閜art
Retour
Emprunteur
Request("SELECT * FROM loans_box.xml, loans.xml, clients.xml
WHERE (LBBox = $id) AND (LBLoan = LoanId) AND (LoanClient = ClientId)
ORDER BY Date(LoanDeparture) DESC
LIMIT 10");
Display("templates/boxloans.tpl");
DisplayEmpty("templates/boxloansempty.tpl");
%>
Include("outro.inc");
%>
