package org.paneris.jammyjoes.controller;

 import java.util.Enumeration;

 import org.melati.Melati;

 import org.melati.poem.NoSuchRowPoemException;

 import org.melati.template.ServletTemplateContext;

 import org.melati.util.StringUtils;

 import org.paneris.jammyjoes.model.JammyjoesDatabase;

 import org.paneris.jammyjoes.model.Product;

 import org.paneris.jammyjoes.servlet.JammyJoesMelatiServlet;

 public class Toy extends JammyJoesMelatiServlet {

   private static final long serialVersionUID = 1L;

   protected String jammyjoesRequest(Melati melati, ServletTemplateContext context)

             throws Exception {

     JammyjoesDatabase db = (JammyjoesDatabase) melati.getDatabase();

     String template = "view/Product.wm";

     String[] pathInfo = melati.getPathInfoParts();

     String troidString = pathInfo[0];

     if (troidString.endsWith(".html")) troidString = troidString.substring(0,troidString.length()-5);

     Integer i = new Integer(troidString);

     try {

       Product p = (Product)db.getProductTable().getObject(i);

       if (pathInfo.length > 1) {

         String next = pathInfo[1];

         if (next.equals("Next.html")) {

           String basics = "stocklevel > 0 AND retailpriceincvat IS NOT NULL AND status = 0";

           Enumeration r = db.getProductTable().selection(basics + " AND name > " + q(p.getName()), null, false);

           if (r.hasMoreElements()) {

             p = (Product)r.nextElement();

           } else {

             Enumeration s = db.getProductTable().selection(basics, null, false);

             if (s.hasMoreElements()) p = (Product)s.nextElement();

           }

         }

       }

       context.put("product",p);

     } catch (NoSuchRowPoemException e) {

       template = "view/RedirectHome.wm";

     }

     return template;

   }

   public String q(String name) {

     StringBuffer b = new StringBuffer();

     StringUtils.appendQuoted(b, name, '\'');

     return b.toString();

   }

 }