/*
 * 作者:劉云云
 * 時間:2007年11月28日
 * 功能:我的商業(yè)合作-＞我參與的商圈 
 * 查看自已參與的商圈
 */
package com.mole.struts.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mole.struts.bean.MerchantBizGroupInfoBean;
import com.mole.struts.dao.MerchantBizGroupAttendDAO;

/**
 * MyEclipse Struts Creation date: 11-25-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantBizGroupAttendAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		String storeId = (String) request.getSession().getAttribute("store");

		String action = request.getParameter("action");
		MerchantBizGroupAttendDAO dao = new MerchantBizGroupAttendDAO();
		String page = request.getParameter("page");
		if (page == null)
			page = "1";
		request.setAttribute("page", page);

		if (action == null || action.equals("new")) {// 獲取顯示自已參與的商圈頁面
			MerchantBizGroupInfoBean[] result = null;
			String sql = null;
			if (page.equals("1")) {// 查看已加入的商圈
				Date currentDate = new Date();
				SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
				String dateString = formatter.format(currentDate);

				sql = "SELECT ID,Name,activityDes,StartDate,EndDate,memberState,bgStoreID ,memberID,storeName,cityName,areaName,"
						+ "typeName,bizGroupState,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') FROM "
						+ "  v_bizGroupAttend WHERE memberState=1 AND bizGroupState<>3 AND bizGroupState<>4 AND '"
						+ dateString
						+ "'<=endDate AND StoreID='"
						+ storeId
						+ "' AND ID  in(select BizGroupID from BizGroupMember where state=1 AND StoreID='"
						+ storeId + "')";
			} else if (page.equals("0")) {// 查看已請求的商圈
				sql = "SELECT ID,Name,activityDes,StartDate,EndDate,memberState,bgStoreID ,memberID,storeName,cityName,areaName,"
						+ "typeName,bizGroupState,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') FROM "
						+ "  v_bizGroupAttend WHERE memberState=0 AND StoreID='"
						+ storeId
						+ "' AND ID  in(select BizGroupID from BizGroupMember where state=0 AND StoreID='"
						+ storeId + "')";
			} else if (page.equals("3")) {// 查看被拒絕的商圈
				sql = "SELECT ID,Name,activityDes,StartDate,EndDate,memberState,bgStoreID ,memberID,storeName,cityName,areaName,"
						+ "typeName,bizGroupState,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') FROM "
						+ "  v_bizGroupAttend WHERE memberState=3 AND StoreID='"
						+ storeId
						+ "' AND ID  in(select BizGroupID from BizGroupMember where state=3 AND StoreID='"
						+ storeId + "')";
			}

			result = dao.getAttendBizGroup(sql);
			request.setAttribute("result", result);
			return mapping.findForward("goMerchantBizGroupAttend");

		} else if (action.equals("exit")) {// 獲取顯示自已參與的商圈頁面
			String memberId = request.getParameter("memberId");
			String sql = "UPDATE bizGroupMember SET state=2 WHERE ID="
					+ memberId;
			dao.executeUpdate(sql);
			return new ActionForward("/merchantBizGroupAttend.do?action=new");

		} else if (action.equals("del")) {// 退出自已參與的商圈
			String memberId = request.getParameter("memberId");
			String sql = "DELETE FROM BizGroupMember WHERE ID=" + memberId;
			dao.executeUpdate(sql);
			return new ActionForward(
					"/merchantBizGroupAttend.do?action=new&page=" + page);
		} else if (action.equals("show")) {// 獲取顯示自已參與的商圈詳情頁面
			String sql = "SELECT Description FROM BizGroup WHERE ID="
					+ request.getParameter("id");
			request.setAttribute("placard", dao.getBizGroupPlacard(sql));
			sql = "SELECT ID,name,activityDes,startDate,endDate,activityId,state,StoreID,StoreName,"
					+ "typeName,cityName,areaName,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') FROM "
					+ "  v_bizGroupInfo WHERE ID=" + request.getParameter("id");
			MerchantBizGroupInfoBean result = dao.getPlacardInfo(sql);
			request.setAttribute("result", result);
			return mapping.findForward("goMerchantBizGroupPlacard");
		}
		return null;
	}
}