[[\
from spyceConfig import db

books = db.books.select()
users = db.users.select_by(admin=False)
]]

<spy:parent title="Spyce Demo" />

[[!
def new_user(self, api):
    api.redirect.external('user-new.spy')
    api.response.end()
]]

<f:form>
<spy:login_required />
[[ current_user = db.users.selectone_by(name=request.login_id()) ]]
<b>Welcome, [[= current_user.name ]]<br />
<spy:logout /><br />

<br />
<table>
<tr>
  <td></td>
  <th>Title</th>
  <th>Published</th>
  <th>Author(s)</th>
  <th>On loan to</th>
  <th>Borrower's email</th>
  <th>Loaned</th>
<tr>

[[\
# sqlite3 has a bug that prevents using the simpler join
# of (books, (users, loans))
book_loans = db.join(db.join(db.books, db.loans, isouter=True),
                     db.users, isouter=True) 
]]
[[ for book_loan in book_loans.select():{ ]]
  <tr>
    <td><f:checkbox name="books:list:int" value="=book_loan.id" /></td>
    <td>[[= book_loan.title ]]</td>
    <td>[[= book_loan.published_year ]]</td>
    <td>[[= book_loan.authors ]]</td>
    [[ if book_loan.user_name:{ # loaned out ]]
      <td>[[= book_loan.user_name ]]</td>
      [[ if current_user.admin or current_user.classname == book_loan.classname:{ ]]
      <td>[[= book_loan.email ]]</td>
      [[ } ]]
      <td>[[= book_loan.loan_date ]]</td>
    [[ }else:{ ]]
      <td></td>
      <td></td>
      <td></td>
    [[ } ]]
  </tr>
[[ } ]]
</table>

<br>
[[ if current_user.admin:{ ]]
<ul>
<li><f:select name="user_name" data="[(u.name, u.name) for u in users]" />
    <f:submit handler=actions.book_loan value="Borrow selected books" />
<li><f:submit handler=actions.book_return value="Return selected books" />
<li><f:submit handler=self.new_user value="Add a new user" />
</ul>
[[ } ]]

</table>

</f:form>