package org.paneris.jammyjoes.model;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

 import org.melati.poem.SQLPoemException;

 import org.melati.poem.util.PagedEnumeration;

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

 public class ProductTable extends ProductTableBase {

   public ProductTable(Database database, String name, DefinitionSource definitionSource)

     throws PoemException {

     super(database, name, definitionSource);

   }

   public PagedEnumeration selection(

     String whereClause,

     String orderByClause,

     boolean includeDeleted,

     int pageStart,

     int pageSize)

     throws SQLPoemException {

     if (whereClause == null)

       whereClause = "";

     if (whereClause.indexOf("\"status\"") < 0 && whereClause.indexOf("\"id\"") < 0) {

       if (!whereClause.equals(""))

         whereClause += " AND ";

       whereClause += "((\"status\" != "

         + getJammyjoesDatabaseTables().getProductStatusTable().getDiscontinued().getTroid();

       whereClause += " AND ";

       whereClause += "\"status\" != "

         + getJammyjoesDatabaseTables().getProductStatusTable().getNotStocked().getTroid();

       whereClause += ") OR \"stocklevel\" > 0)";

     }

     return super.selection(whereClause, orderByClause, includeDeleted, pageStart, pageSize);

   }

   public PagedEnumeration unFiltetredSelection(String whereClause, String orderByClause, boolean includeDeleted, int pageStart, int pageSize) {

     return super.selection(whereClause, orderByClause, includeDeleted, pageStart, pageSize);

   }

 }