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;

   }

 }