package org.paneris.jammyjoes.model;

 import java.util.Enumeration;

 import org.melati.poem.CachedCount;

 import org.melati.poem.CachedSelection;

 import org.paneris.jammyjoes.model.generated.AffiliateBase;

 public class Affiliate extends AffiliateBase {

   public Affiliate() {}

   public String ordersSQL(boolean paidonly) {

     JammyjoesDatabase db = (JammyjoesDatabase)getDatabase();

     String paid = (paidonly) ? " AND affiliatepaid IS TRUE" : "";

     return "affiliate = " + getTroid() + " AND status = " + 

            db.getOrderStatusTable().getFufilled().getTroid() + paid;

   }

   public CachedSelection getOrders(boolean paidonly) {

     return getJammyjoesDatabaseTables().getShopOrderTable().cachedSelection(

            ordersSQL(paidonly), null);

   }

   public CachedSelection getOrders() {

     return getOrders(false);

   }

   public CachedCount cachedOrdersCount() {

     return getJammyjoesDatabaseTables().getShopOrderTable().cachedCount(ordersSQL(false));

   }

   public double totalOrders() {

     double total = 0;

     Enumeration en =  getOrders(false).objects();

     while (en.hasMoreElements()) {

       ShopOrder order = (ShopOrder)en.nextElement();

       total += order.getAmount().doubleValue();

     }

     return total;

   }

   public double money(boolean paid) {

     double total = 0;

     Enumeration en = getOrders(paid).objects();

     while (en.hasMoreElements()) {

       ShopOrder order = (ShopOrder)en.nextElement();

       total += order.getComission().doubleValue() * order.getAmount().doubleValue() / 100;

     }

     return total;

   }

   public double moneyEarnt() {

     return money(false);

   }

   public double moneyPaid() {

     return money(true);

   }

   public double moneyOwed() {

     return moneyEarnt() - moneyPaid();

   }

 }