package org.paneris.jammyjoes.controller;

 import java.util.Date;

 import java.util.Vector;

 import org.melati.Melati;

 import org.melati.MelatiConfig;

 import org.melati.poem.AccessPoemException;

 import org.melati.poem.AccessToken;

 import org.melati.poem.Capability;

 import org.melati.poem.PoemThread;

 import org.melati.servlet.Form;

 import org.melati.template.ServletTemplateContext;

 import org.melati.util.ContextUtil;

 import org.paneris.jammyjoes.model.JammyjoesDatabase;

 import org.paneris.jammyjoes.model.Product;

 import org.paneris.jammyjoes.model.StockTransaction;

 import org.paneris.jammyjoes.servlet.JammyJoesMelatiServlet;

 public class StockEntry extends JammyJoesMelatiServlet {

   private static final long serialVersionUID = 1L;

   protected String jammyjoesRequest(Melati melati, ServletTemplateContext context)

             throws Exception {

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

     ServletTemplateContext tc = melati.getServletTemplateContext();

     Capability admin = db.getCanAdminister();

     AccessToken token = PoemThread.accessToken();

     if (!token.givesCapability(admin)) 

       throw new AccessPoemException(token,admin);

     String template = "view/StockEntry.wm";

     String submit = Form.getFormNulled(tc,"submit");

     int itemsperpage = Form.getIntegerField(tc,"itemsperpage",new Integer(10)).intValue();

     Vector items = new Vector();

     boolean allgood = true;

     if (submit == null) { 

       allgood = false;

       for (int i=0; i<itemsperpage; i++) {

         items.add(new Item());

       }

     } else {

       if (submit.equals("Check")) {      

         for (int i=0; i<itemsperpage; i++) {

           Integer id = Form.getIntegerField(tc,i+"");

           if (id == null) {

             items.add(new Item());

           } else {

             Product p = (Product)db.getProductTable().getIdColumn().firstWhereEq(id);

             if (p == null) {

               allgood = false;

               items.add(new Item(id));

             } else {

               items.add(new Item(p));

             }

           }

         }

       }

       if (submit.equals("Confirm")) {

         allgood = false;

         for (int i=0; i<itemsperpage; i++) {

           items.add(new Item());

           Integer id = Form.getIntegerField(tc,i+"");

           if (id != null) {

             Product p = (Product)db.getProductTable().getIdColumn().firstWhereEq(id);

             Integer quantity = Form.getIntegerField(tc,"q"+id);

             java.sql.Date date = (java.sql.Date)MelatiConfig.getSimpleDateAdaptor().rawFrom(melati.getServletTemplateContext(),"field_date");

             StockTransaction st = p.newStockTransaction(date, db.getStockTransactionTypeTable().getShopSale(),quantity);

             db.getStockTransactionTable().create(st);

           }

         }

       }

     }

     context.put("allgood",new Boolean(allgood));

     context.put("items",items);

     context.put("util", new ContextUtil());

     StockTransaction dummyst = (StockTransaction)db.getStockTransactionTable().newPersistent();

     if (Form.getFormNulled(tc,"field_date") == null) {

       dummyst.setDate(new java.sql.Date(new Date().getTime()));

     } else {

       dummyst.setDate((java.sql.Date)MelatiConfig.getSimpleDateAdaptor().rawFrom(melati.getServletTemplateContext(),"field_date"));

     }      

     context.put("st", dummyst);

     return template;

   }

   public class Item {

       private Integer id;

       private Product product;

       private Item() {

           id = null;

           product = null;

       }

       private Item(Integer id) {

           this.id = id;

           product = null;

       }

       private Item(Product p) {

           product = p;

           id = p.getTroid();

       }

       public Integer getId() {

           return id;

       }

       public Product getProduct() {

           return product;

       }

   }

 }