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);
   }
 
 }