/*
 * 作者:劉云云
 * 時間:2007年11月28日
 * 功能:我的商業(yè)合作-＞關(guān)注中的商圈
 * 查看自已關(guān)注的商圈
 */
package com.mole.struts.dao;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;

import com.mole.struts.bean.MerchantBizGroupInfoBean;

public class MerchantBizGroupFavoriteDAO extends AbstractDAO {
	// 獲取關(guān)注的商圈的記錄集
	public MerchantBizGroupInfoBean[] getFavoriteBizGroup(String sql) {
		ArrayList<Object[]> arrayList = executeQuery(sql);
		MerchantBizGroupInfoBean[] records = new MerchantBizGroupInfoBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantBizGroupInfoBean record = new MerchantBizGroupInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setActivityDes(obj[2].toString());
			record.setStartDate(obj[3].toString().substring(0, 10));
			record.setEndDate(obj[4].toString().substring(0, 10));
			record.setState(Integer.valueOf(obj[5].toString()));
			record.setStoreName(obj[6].toString());
			record.setTypeName(obj[7].toString());
			record.setCityName(obj[8].toString());
			record.setAreaName(obj[9].toString());
			record.setTypeName2(obj[10].toString());
			record.setTypeName3(obj[11].toString());
			record.setTypeName4(obj[12].toString());

			Date currentDate = new Date();
			SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
			String dateString = formatter.format(currentDate);
			if (record.getState() == 3) {
				record.setTig("delete");
			} else if (record.getState() == 2
					|| (record.getState() == 1 && dateString.compareTo(record
							.getEndDate()) > 0)
					|| (record.getState() == 0 && dateString.compareTo(record
							.getEndDate()) > 0)) {
				record.setTig("end");
			} else if (record.getState() == 1
					|| (record.getState() == 0
							&& dateString.compareTo(record.getEndDate()) <= 0 && dateString
							.compareTo(record.getStartDate()) >= 0)) {
				record.setTig("start");
			} else {
				record.setTig("ready");
			}

			records[i++] = record;
		}
		return records;
	}
}