package org.paneris.jammyjoes.controller;

 import java.util.Enumeration;

 import java.util.LinkedList;

 import java.util.List;

 import java.util.Vector;

 import org.melati.Melati;

 import org.melati.poem.AccessPoemException;

 import org.melati.poem.AccessToken;

 import org.melati.poem.BaseFieldAttributes;

 import org.melati.poem.Capability;

 import org.melati.poem.Field;

 import org.melati.poem.PoemThread;

 import org.melati.servlet.Form;

 import org.melati.template.ServletTemplateContext;

 import org.melati.template.TemplateContext;

 import org.melati.template.TemplateEngine;

 import org.melati.util.Email;

 import org.melati.poem.util.EnumUtils;

 import org.melati.util.MelatiStringWriter;

 import org.paneris.jammyjoes.mail.HtmlMail;

 import org.paneris.jammyjoes.mail.MailFascade;

 import org.paneris.jammyjoes.model.JammyjoesDatabase;

 import org.paneris.jammyjoes.model.Product;

 import org.paneris.jammyjoes.model.Supplier;

 //import org.paneris.jammyjoes.model.User;

 import org.paneris.jammyjoes.servlet.JammyJoesMelatiServlet;

 public class PurchaseOrder extends JammyJoesMelatiServlet {

   private static final long serialVersionUID = 1L;

   private ProductSearch util;

   protected String jammyjoesRequest(Melati melati, ServletTemplateContext context) throws Exception {

     util = new ProductSearch(null, 0, new Logger(null));

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

     Capability admin = db.getCanAdminister();

     AccessToken token = PoemThread.accessToken();

     if (!token.givesCapability(admin))

       throw new AccessPoemException(token, admin);

     String template = "view/PurchaseOrder.wm";

     Integer type = Form.getIntegerField(context, "field_type");

     Integer supplier = Form.getIntegerField(context, "field_supplier");

     Integer manufacturer = Form.getIntegerField(context, "field_manufacturer");

     boolean sendit = Form.getBooleanField(context, "sendit").booleanValue();

     context.put("selectedType", type);

     context.put("selectedManufacturer", manufacturer);

     context.put(

       "type",

       new Field(

         type,

         new BaseFieldAttributes(db.getProductTable().getTypeColumn(), true)));

     context.put(

       "supplier",

       new Field(

         supplier,

         new BaseFieldAttributes(db.getProductTable().getSupplierColumn(), true)));

     context.put(

       "manufacturer",

       new Field(

         manufacturer,

         new BaseFieldAttributes(db.getProductTable().getManufacturerColumn(),

           true)));

     if (sendit || Form.getFormNulled(context, "submit") != null) {

       Vector where = new Vector();

       List results = new LinkedList();

       if (type != null)

         where.add(q("id") + " = producttype.product and producttype.type = " + type);

       if (supplier != null)

         where.add(q("supplier") + " = " + supplier);

       if (manufacturer != null) {

         where.add(q("manufacturer") + " = " + manufacturer);

       }

       where.add(q("stocklevel") + " <= " + q("reorderlevel"));

       where.add(q("reorderquantity") + " > 0");

       where.add(discontinued(db));

       String whereClause = EnumUtils.concatenated(" AND ", where.elements());

       Enumeration r = db.getProductTable().selection(whereClause, null, false);

       double totalCostPrice = 0;

       double totalCostPriceIncVat = 0;

       double count = 0;

       while (r.hasMoreElements()) {

         Product p = (Product) r.nextElement();

         results.add(p);

         count++;

         if (p.getReorderquantity() != null) {

           totalCostPrice += p.getReorderquantity().doubleValue() * p.getCostprice().doubleValue();

           totalCostPriceIncVat += p.getReorderquantity().doubleValue()

             * p.getCostpriceIncVat().doubleValue();

         }

       }

       context.put("totalCostPrice", new Double(totalCostPrice));

       context.put("totalCostPriceIncVat", new Double(totalCostPriceIncVat));

       context.put("vat", new Double(totalCostPriceIncVat - totalCostPrice));

       Supplier supplierRec = (Supplier) db.getSupplierTable().getObject(supplier);

       context.put("selectedSupplier", supplierRec);

       if (supplierRec.getMinimumamount() != null

         && supplierRec.getMinimumamount().doubleValue() > totalCostPriceIncVat)

         context.put("notenough", Boolean.TRUE);

       context.put("results", results);

       if (sendit) {

         sendJammyJoesEmail(db, melati.getTemplateEngine(), supplierRec.getEmail(), context);

         context.put("sent", Boolean.TRUE);

       }

     }

     return template;

   }

   private void sendJammyJoesEmail(JammyjoesDatabase db, TemplateEngine engine, String to, TemplateContext context) throws Exception {

     //User admin = (User)db.getUserTable().administratorUser();

     MelatiStringWriter writer = new MelatiStringWriter();

     engine.expandTemplate(writer,"view/PurchaseOrderEmail.wm",context);

     MailFascade facade = new MailFascade(db.getSettingTable().get(Email.SMTPSERVER));

     HtmlMail mail = facade.createHtmlMail(writer.toString());

 //    mail.setRecipient("timj@hoop.co.uk");

     mail.setRecipient("sales@jammyjoes.co.uk");

     facade.send(mail);

   }

   private String discontinued(JammyjoesDatabase db) {

     String discontinued =

       "(" + q("status") + " != " + db.getProductStatusTable().getDiscontinued().getTroid();

     discontinued += " AND "

       + q("status")

       + " != "

       + db.getProductStatusTable().getNotStocked().getTroid()

       + ")";

     return discontinued;

   }

   public String q(String name) {

     return util.q(name);

   }

 }