package org.paneris.bibliomania;

 import org.melati.Melati;

 import org.melati.servlet.Form;

 import org.melati.poem.BaseFieldAttributes;

 import org.melati.poem.Field;

 import org.melati.poem.FieldAttributes;

 import org.webmacro.servlet.WebContext;

 public class DeliveryCharges extends BibliomaniaServlet {

   /**

    * 

    */

   private static final long serialVersionUID = 1L;

   protected String bibliomaniaHandle(Melati melati, WebContext context)

             throws Exception {

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

     db.setupContext(melati, context, null, null);

     String localeString = 

                  Form.getFieldNulled(melati.getServletTemplateContext(),"locale");

     Integer countryCodeId = 

          Form.getIntegerField(melati.getServletTemplateContext(),"field_country");

     context.put("countries", new Field(countryCodeId, 

                 new BaseFieldAttributes(

             (FieldAttributes)db.getShopOrderTable().getCountryColumn(),  true)));

     if (countryCodeId != null) {

       Country country = (Country)db.getCountryTable().getIdColumn().firstWhereEq(countryCodeId);

       context.put("country", country);

       DeliveryChargeBand band = country.getDeliverycharge();

       context.put("charges", db.getDeliveryChargeTable().getBandColumn().selectionWhereEq(band.getTroid()));

     }

     context.put("currency", db.getCurrencyTable().getCurrency(localeString));

     context.put("locale", localeString);

     return "DeliveryCharges.wm";

   }

 }