supplyinfo.java

java阿里巴巴代码

package com.saas.biz.saleMgr;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.HashMap;
import java.util.StringTokenizer;
import com.saas.biz.dao.saleDAO.SaleExt;
import com.saas.biz.propertyuMgr.PropertyuInfo;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:供应信息
 * @2008-7-4
 */
public class SupplyInfo {
	
	
	Dbtable tradeQuery;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	@SuppressWarnings("unchecked")
	ArrayList queryResult = new ArrayList();
	
	
	SimpleDateFormat formate;
	
	
	
	public SupplyInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		formate = new SimpleDateFormat("yyyy-MM-dd");
	}
	
	
	public void setTradeQuery(Dbtable tradeQuery) {

		this.tradeQuery = tradeQuery;
	}
	
	
	public Dbtable getTradeQuery() {

		return this.tradeQuery;
	}
	
	
	public void setOutBuffer(Buffers outBuffer) {

		this.outBuffer = outBuffer;
	}
	
	
	public Buffers getOutBuffer() {

		return this.outBuffer;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getQueryResult() {

		return this.queryResult;
	}
	
	
	@SuppressWarnings("unchecked")
	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}
	
	
	
	/**
	 * 取出供应信息
	 * 
	 * @type0供应信息
	 * @type1最新供应信息
	 * @INFO_TYPE信息类型
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSupplyInfoList(int iStart, int size, String info_type) throws SaasApplicationException {

		ArrayList supplyList = new ArrayList();
		PropertyuInfo property = new PropertyuInfo();
		// 是否启用审核机制
		boolean validity = property.getValidityInfo("106", info_type);
		if (validity) {
			
		}
		else {
			supplyList = getSaleInfoList(iStart, size);
		}
		return supplyList;
	}
	
	
	
	/**
	 * 取出供应信息
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSaleInfoList(int iStart, int size) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * size;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		list = saleExt.selByList("SEL_BY_VIEW", iStart, size);
		return list;
	}
	
	
	
	/**
	 * @return取出供应信息总条
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public int getSaleInfoCount() throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		list = saleExt.selByList("SEL_VIEW_COUNT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * @return取出最新发布的信息
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getNewSaleInfoList(int iStart, int size) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * size;
		}
		else {
			iStart = 0;
		}
		Calendar date = Calendar.getInstance();
		String start_date = formate.format(date.getTime());
		date.add(Calendar.MONTH, 1);
		String end_date = formate.format(date.getTime());
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSTART_DATE", start_date);
		saleExt.setParam(":VEND_DATE", end_date);
		list = saleExt.selByList("SEL_NEW_BY_VIEW", iStart, size);
		return list;
	}
	
	
	
	/**
	 * @return取出最新发布的信息总数
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public int getNewSaleInfoCount() throws SaasApplicationException {

		Calendar date = Calendar.getInstance();
		String start_date = formate.format(date.getTime());
		date.add(Calendar.MONTH, 1);
		String end_date = formate.format(date.getTime());
		int size = 0;
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSTART_DATE", start_date);
		saleExt.setParam(":VEND_DATE", end_date);
		list = saleExt.selByList("SEL_NEW_VIEW_COUNT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * @param sale_id
	 * @return 取出单条信息
	 * @throws SaasApplicationException
	 */
	
	@SuppressWarnings("unchecked")
	public HashMap getSaleInfoById(String sale_id) throws SaasApplicationException {

		HashMap map = new HashMap();
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSALE_ID", sale_id);
		list = saleExt.selByList("SEL_VIEW_BY_ID");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
	
	
	
	/**
	 * 供应信息对比
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSupplyCompareById(String idx) throws SaasApplicationException {

		ArrayList saleList = new ArrayList();
		StringTokenizer st = new StringTokenizer(idx, "|");
		while (st.hasMoreTokens()) {
			String sale_id = st.nextToken();
			HashMap map = getSupplyInfoById(sale_id);
			saleList.add(map);
		}
		return saleList;
	}
	
	
	
	/**
	 * @param sale_id
	 * @return 取出单个供应信息
	 * @throws SaasApplicationException
	 */
	
	@SuppressWarnings("unchecked")
	public HashMap getSupplyInfoById(String sale_id) throws SaasApplicationException {

		HashMap map = new HashMap();
		ArrayList list = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSALE_ID", sale_id);
		list = saleExt.selByList("SEL_SALEINF_BY_ID");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
	
	
	
	// 模糊查询
	@SuppressWarnings("unchecked")
	public ArrayList getProductByLike(int iStart, String product_name, String pro, String city, String date_scope) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		Calendar cal = Calendar.getInstance();
		cal.add(Calendar.DATE, Integer.parseInt(date_scope));
		String date_scope1 = new SimpleDateFormat("yyyy-MM-dd").format(cal.getTime());
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPRODUCT_NAME", product_name + "%");
		saleExt.setParam(":VPRO", pro + "%");
		saleExt.setParam(":VCITY", city + "%");
		saleExt.setParam(":VDATE_SCOPE", date_scope1 + "%");
		saleList = saleExt.selByList("SEL_PRODUCT_BY_LIKE", iStart, 10);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getProductByLike(String product_name, String pro, String city, String date_scope) throws SaasApplicationException {

		int count = 0;
		Calendar cal = Calendar.getInstance();
		cal.add(Calendar.DATE, Integer.parseInt(date_scope));
		String date_scope1 = new SimpleDateFormat("yyyy-MM-dd").format(cal.getTime());
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPRODUCT_NAME", product_name + "%");
		saleExt.setParam(":VPRO", pro + "%");
		saleExt.setParam(":VCITY", city + "%");
		saleExt.setParam(":VDATE_SCOPE", date_scope1 + "%");
		saleList = saleExt.selByList("SEL_PRODUCT_BY_LIKE");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
	
	
	// 精确查询
	@SuppressWarnings("unchecked")
	public ArrayList getProductByEqual(int iStart, String product_name, String pro, String city, String date_scope) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		Calendar cal = Calendar.getInstance();
		cal.add(Calendar.DATE, Integer.parseInt(date_scope));
		String date_scope1 = new SimpleDateFormat("yyyy-MM-dd").format(cal.getTime());
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPRODUCT_NAME", product_name);
		saleExt.setParam(":VPRO", pro);
		saleExt.setParam(":VCITY", city);
		saleExt.setParam(":VDATE_SCOPE", date_scope1);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_EQUAL", iStart, 20);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getProductByEqual(String product_name, String pro, String city, String date_scope) throws SaasApplicationException {

		int count = 0;
		Calendar cal = Calendar.getInstance();
		cal.add(Calendar.DATE, Integer.parseInt(date_scope));
		String date_scope1 = new SimpleDateFormat("yyyy-MM-dd").format(cal.getTime());
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPRODUCT_NAME", product_name);
		saleExt.setParam(":VPRO", pro);
		saleExt.setParam(":VCITY", city);
		saleExt.setParam(":VDATE_SCOPE", date_scope1);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_EQUAL");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
	
	
	/**
	 * NO City Key
	 * 
	 * @param iStart
	 * @param prov
	 * @param part
	 * @return
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSelectProductByOne(int iStart, String prov, String part) throws SaasApplicationException {

		log.LOG_INFO("进入getSelectProductByOne方法...");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_ONE", iStart, 10);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getSelectProductByOne(String prov, String part) throws SaasApplicationException {

		log.LOG_INFO("Count进入getSelectProductByOne方法...");
		int count = 0;
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_ONE");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
	
	
	/**
	 * No City
	 * 
	 * @param iStart
	 * @param prov
	 * @param key
	 * @param part
	 * @return
	 * @throws SaasApplicationException
	 */
	
	@SuppressWarnings("unchecked")
	public ArrayList getSelectProductByTwo(int iStart, String prov, String key, String part) throws SaasApplicationException {

		log.LOG_INFO("进入getSelectProductByTwo方法...");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VKEY", "%" + key + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_TWO", iStart, 10);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getSelectProductByTwo(String prov, String key, String part) throws SaasApplicationException {

		log.LOG_INFO("Count进入getSelectProductByTwo方法...");
		int count = 0;
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VKEY", "%" + key + "%");
		saleExt.setParam(":VPART", part);
		log.LOG_INFO("part================="+part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_TWO");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
	
	
	/**
	 * No key
	 * 
	 * @param iStart
	 * @param prov
	 * @param city
	 * @param part
	 * @return
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSelectProductByThree(int iStart, String prov, String city, String part) throws SaasApplicationException {

		log.LOG_INFO("进入getSelectProductByThree方法...");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VCITY", "%" + city + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_THREE", iStart, 10);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getSelectProductByThree(String prov, String city, String part) throws SaasApplicationException {

		log.LOG_INFO("Count进入getSelectProductByThree方法...");
		int count = 0;
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov + "%");
		saleExt.setParam(":VCITY", "%" + city + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_BY_THREE");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
	
	
	/**
	 * all
	 * 
	 * @param iStart
	 * @param prov
	 * @param city
	 * @param key
	 * @param part
	 * @return
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getSelectProductNoFour(int iStart, String prov, String city, String key, String part) throws SaasApplicationException {

		log.LOG_INFO("进入getSelectProductNoFour方法...");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov.trim() + "%");
		saleExt.setParam(":VCITY", "%" + city.trim() + "%");
		saleExt.setParam(":VKEY", "%" + key.trim() + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_NO_FOUR", iStart, 10);
		return saleList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getSelectProductNoFour(String prov, String city, String key, String part) throws SaasApplicationException {

		log.LOG_INFO("count进入getSelectProductNoFour方法...");
		int count = 0;
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VPROV", "%" + prov.trim() + "%");
		saleExt.setParam(":VCITY", "%" + city.trim() + "%");
		saleExt.setParam(":VKEY", "%" + key.trim() + "%");
		saleExt.setParam(":VPART", part);
		saleList = saleExt.selByList("SEL_PRODUCT_NO_FOUR");
		if (saleList != null && saleList.size() > 0) {
			count = saleList.size();
		}
		return count;
	}
	
}