package org.paneris.bibliomania;
   
   import java.util.Enumeration;
   import java.util.Vector;
   
   import org.melati.Melati;
   import org.melati.poem.Column;
   import org.melati.poem.FieldSet;
   import org.melati.poem.Table;
  import org.melati.poem.TailoredQuery;
  import org.melati.poem.util.EnumUtils;
  import org.webmacro.servlet.WebContext;
  
  
  public class DownloadList extends BibliomaniaServlet {
  
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
  
    protected String bibliomaniaHandle(Melati melati, WebContext context)
              throws Exception {
      BibliomaniaDatabase db = (BibliomaniaDatabase)melati.getDatabase();
      assertRegisteredUser(db);
      String template = "DownloadList.wm";
      User user = (User)melati.getUser();
      Column[] columns = {db.getProductTable().getIdColumn(),
                          db.getProductTable().getNameColumn(),
                          db.getProductTable().getBookColumn()};
      Table[] tables = { db.getProductTable(), 
                         db.getShopOrderItemTable() };
      Vector where = new Vector();
      where.add("shoporderitem.authorised = true"); 
      where.add("shoporderitem.\"user\" =" + user.getTroid()); 
      where.add("shoporderitem.product = product.id"); 
      where.add("product.download IS NOT NULL"); 
      String whereClause = EnumUtils.concatenated(" AND ", where.elements());
      TailoredQuery q = new TailoredQuery("DISTINCT", columns, tables, whereClause, "product.book, product.name");
      Vector purchases = new Vector();
      for (Enumeration e = q.selection(); e.hasMoreElements();) {
        FieldSet fs = (FieldSet)e.nextElement();
        purchases.add(db.getProductTable().getProductObject((Integer)fs.get("product_id").getCooked()));
      }
      context.put("purchases", purchases);
      return template;
    }
    
  }