package org.paneris.jammyjoes.controller;

 import java.util.Vector;

 import org.melati.poem.util.EnumUtils;

 import org.melati.poem.util.PagedEnumeration;

 import org.melati.util.StringUtils;

 import org.paneris.jammyjoes.model.JammyjoesDatabase;

 /**

  * @author Tim

  *

  * To change this generated comment edit the template variable "typecomment":

  * Window>Preferences>Java>Templates.

  * To enable and disable the creation of type comments go to

  * Window>Preferences>Java>Code Generation.

  */

 public class ProductSearch {

   private JammyjoesDatabase db;

   private int maxHits;

   private Logger logger;

   public ProductSearch(JammyjoesDatabase db, int maxHits, Logger logger) {

     this.db = db;

     this.maxHits = maxHits;

     this.logger = logger;

   }

   public PagedEnumeration doSearch(SearchCriteria criteria) {

     Vector where = new Vector();

     criteria.constrain(where);

     where.add(q("retailpriceincvat") + " IS NOT NULL");

     String whereClause = EnumUtils.concatenated(" AND ", where.elements());

     logger.logWhereClause(whereClause);

     PagedEnumeration results = db.getProductTable().unFiltetredSelection(whereClause, criteria.order(), false, 0, maxHits);

     logger.logHits(results.getTotalCount());

     return results;

   }

   public String q(String name) {

     StringBuffer b = new StringBuffer();

     StringUtils.appendQuoted(b, name, '"');

     return b.toString();

   }

 }