package org.paneris.bibliomania.shopping;

 import java.util.Enumeration;

 import org.melati.Melati;

 import org.paneris.bibliomania.BibliomaniaDatabase;

 import org.paneris.bibliomania.Book;

 import org.paneris.bibliomania.DeliveryCharge;

 import org.paneris.bibliomania.DeliveryChargeBand;

 import org.paneris.bibliomania.Product;

 import org.paneris.bibliomania.ShopOrder;

 import org.paneris.bibliomania.ShopOrderItem;

 import org.paneris.melati.shopping.ShoppingTrolley;

 import org.paneris.melati.shopping.ShoppingTrolleyItem;

 public class BibliomaniaShoppingTrolleyItem extends ShoppingTrolleyItem {

   private Product product;

   private DeliveryCharge charge = null;

   private boolean gotCharge = false;

   //private boolean download = false; // when we sell downloads

   private BibliomaniaShoppingTrolley bibShoppingTrolley;

   public void initialise(ShoppingTrolley trolleyP, Melati melatiP,

                          Integer idP, String descriptionP, Double priceP) {

     super.initialise(trolleyP, melatiP, idP, descriptionP, priceP);

     bibShoppingTrolley = (BibliomaniaShoppingTrolley)trolley;

   }  

  /**

   * Load in information about this product given an id.  

   * Perhaps this id represents a poem troid?

   */

   protected void load(Integer idP){

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

     product = (Product)db.getProductTable().getIdColumn().firstWhereEq(idP);

     description = product.getName();

     if ((description == null || description.equals("")) && product.getBook() != null)

       description = product.getBook().getTitle();

     price = 0;

     if (product.getPrice() != null) price = product.getPrice().doubleValue();

     //if (product.getDownload() != null) download = true;

   }

   protected void save(BibliomaniaDatabase db, ShopOrder order){

     ShopOrderItem item = (ShopOrderItem)db.getShopOrderItemTable().newPersistent();

     item.setUser(order.getUser());

     item.setOrder(order);

     item.setProduct(product);

     item.setQuantity((new Double(getQuantity())).intValue());

     item.setAmount(bibShoppingTrolley.convertFromUK(price * quantity));

     item.setDelivery(bibShoppingTrolley.convertFromUK(getDeliveryValue()));

     item.setAmountUK(price * quantity);

     item.setDeliveryUK(getDeliveryValue());

     item.setStatus(db.getOrderStatusTable().getNotAuthorised());

     item.setSupplierTroid(new Integer(0));

     db.getShopOrderItemTable().create(item);

   }

  /**

   * Work out the cost of delivery.

   * Returns null if a charge cannot be calculated - an error should be displayed.

   */

   public double getDeliveryValue() {

     getDeliveryCharge();

     double cost = 0;

     // can't get a charge - indicate error by returning null

     if (charge != null) {

       cost = charge.getCharge().doubleValue();

     }

     return cost * quantity;

   }

  /**

   * Work out the cost of delivery.

   * Returns null if a charge cannot be calculated - an error should be displayed.

   */

   public DeliveryCharge getDeliveryCharge() {

     if (gotCharge) return charge;

     charge = null;

     if (bibShoppingTrolley.countryCode != null) {

       DeliveryChargeBand band = bibShoppingTrolley.countryCode.getDeliverycharge();

       if (band != null) {

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

         String whereClause = "band = " + band.getTroid() + " and supplier in " +

         " (select supplier from supplierproduct where product = " + product.getTroid() + ")";

         String orderClause = "charge";

         Enumeration them = db.getDeliveryChargeTable().selection

                  (whereClause, orderClause, false);

         if (them.hasMoreElements()) charge = (DeliveryCharge)them.nextElement();

       }

     }

     gotCharge = true;

     return charge;

   }

   public void setGotCharge(boolean c) {

     gotCharge = c;

   }

   public Book getBook() {

     return product.getBook();

   }

   public Product getProduct() {

     return product;

   }

   public String displayCurrency(double value) {

     return bibShoppingTrolley.convertFromUKandFormat(value);

   }

 }