package com.mrzeng.action;

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.apache.struts2.convention.annotation.Results;
import org.huashui.authentication.AuthName;
import org.huashui.dto.PageBean;
import org.huashui.service.IPaginate;
import org.huashui.util.StringUtils;
import org.huashui.util.WebUtils;

import com.mrzeng.hibernate.Category;
import com.mrzeng.hibernate.Crawlrecord;
import com.mrzeng.hibernate.Saleinfo;
import com.mrzeng.hibernate.Shop;
import com.mrzeng.hibernate.Shopdetail;
import com.mrzeng.service.IAnalysisService;

/**
 * @fileName ShopdetailAction.java
 * @author  曾华水
 * @email zenghuashui@gmail.com
 * @date Jun 10, 2011
 * @time 9:07:13 AM
 * 代码类代码编写规约：add-增加，edit修改，remove删除，list列出全部，排除用ex，tree代表树
 */
@ParentPackage("huashui-default")
@Namespace("/admin")
@Results( {
		@Result(name = "saleinfo", location = "/WEB-INF/data/saleinfo.jsp"),
		@Result(name = "json", location = "/WEB-INF/view/json.jsp"),
		@Result(name = "jsonfilter", location = "/WEB-INF/view/jsonfilter.jsp"),
		@Result(name = "jsonfiltertype", location = "/WEB-INF/view/jsonfiltertype.jsp") })
public class SaleinfoAction {

	@Resource
	private IPaginate paginate;
	@Resource
	private IAnalysisService analysisService;
	private Integer rows;
	private Integer page;
	private Integer total;
	private String sort;
	private String order;

	public String getSort() {
		return sort;
	}
	public void setSort(String sort) {
		this.sort = sort;
	}
	public String getOrder() {
		return order;
	}
	public void setOrder(String order) {
		this.order = order;
	}
	public Integer getRows() {
		return rows;
	}
	public void setRows(Integer rows) {
		this.rows = rows;
	}
	public Integer getPage() {
		return page;
	}
	public void setPage(Integer page) {
		this.page = page;
	}
	public Integer getTotal() {
		return total;
	}
	public void setTotal(Integer total) {
		this.total = total;
	}
	@Action("data_saleinfo")
	@AuthName("DATA_SALEINFO")
	public String index(){
		List shops = analysisService.listShop();
		List crawls = analysisService.listCrawlrecord();
		StringBuilder sb = new StringBuilder();
		for (Shop shop : shops) {
			if (!StringUtils.isNull(sb.toString())) {
				sb.append(",\r\n");
			}
			sb.append("{").append("id:").append(shop.getId()).append(
					",name:\"").append(shop.getName()).append(
					"\"}\r\n");
		}
		WebUtils.getRequest().setAttribute("shops", sb.toString());

		StringBuilder sb2 = new StringBuilder();
		for (Crawlrecord crawlrecord : crawls) {
			if (!StringUtils.isNull(sb2.toString())) {
				sb2.append(",\r\n");
			}
			sb2.append("{").append("id:").append(crawlrecord.getId()).append(
					",name:\"").append(StringUtils.dateToString(crawlrecord.getCrawltime(), "yyyy-MM-dd hh:mm:ss")).append(
					"\"}\r\n");
		}
		WebUtils.getRequest().setAttribute("crawls", sb2.toString());
		return "saleinfo";
	}
	@Action("data_saleinfo_list")
	@AuthName("DATA_SALEINFO")
	public String list(){
		Map data = new HashMap();
		StringBuilder sql = new StringBuilder();
		sql.append("from ").append(Saleinfo.class.getSimpleName());
		sql.append(" where 1=1");

		if (!StringUtils.isNull(sort) && !StringUtils.isNull(order)) {
			if (order.trim().equalsIgnoreCase("desc")
					|| order.trim().equalsIgnoreCase("asc"))
				sql.append(" order by ").append(sort).append(" ").append(order);
		}
		PageBean pageBean = new PageBean();
		pageBean.setPage(page);
		pageBean.setPageSize(rows);

		pageBean.setListSQL(sql.toString());
		try {
			pageBean.setCount(paginate.getTotalCount(pageBean).intValue());
		} catch (Exception e) {
			e.printStackTrace();
		}

		List list = paginate.getList(pageBean);
		List rList = new ArrayList();
		for (Saleinfo saleinfo : list) {
			SaleinfoBean bean = new SaleinfoBean();
			bean.setBuyer(saleinfo.getBuyer());
			bean.setBuyerCode(saleinfo.getBuyerCode());
			bean.setBuyerLevel(saleinfo.getBuyerLevel());
			bean.setBuyNum(saleinfo.getBuyNum());
			bean.setBuyTime(saleinfo.getBuyTime());
			bean.setCrawlId(saleinfo.getCrawlrecord().getId());
			bean.setGoodDesc(saleinfo.getGoodDesc());
			bean.setGoodPrice(saleinfo.getGoodPrice());
			bean.setGoodTitle(saleinfo.getGoodTitle());
			bean.setGoodUrl(saleinfo.getGoodUrl());
			bean.setId(saleinfo.getId());
			bean.setShopId(saleinfo.getShop().getId());
			rList.add(bean);
		}
		data.put("rows", rList);
		data.put("total", pageBean.getCount());

		WebUtils.getRequest().setAttribute("data", data);
		WebUtils.getRequest().setAttribute("type", "Set");
		return "jsonfiltertype";

	}

	public class SaleinfoBean{
		private Long id;
		private Integer shopId;
		private Long  crawlId;
		private Date buyTime;
		private Integer buyNum;
		private String buyer;
		private String buyerCode;
		private Integer buyerLevel;
		private String goodTitle;
		private String goodDesc;
		private Double goodPrice;
		private String goodUrl;
		public Long getId() {
			return id;
		}
		public void setId(Long id) {
			this.id = id;
		}
		public Integer getShopId() {
			return shopId;
		}
		public void setShopId(Integer shopId) {
			this.shopId = shopId;
		}
		public Long getCrawlId() {
			return crawlId;
		}
		public void setCrawlId(Long crawlId) {
			this.crawlId = crawlId;
		}
		public Date getBuyTime() {
			return buyTime;
		}
		public void setBuyTime(Date buyTime) {
			this.buyTime = buyTime;
		}
		public Integer getBuyNum() {
			return buyNum;
		}
		public void setBuyNum(Integer buyNum) {
			this.buyNum = buyNum;
		}
		public String getBuyer() {
			return buyer;
		}
		public void setBuyer(String buyer) {
			this.buyer = buyer;
		}
		public String getBuyerCode() {
			return buyerCode;
		}
		public void setBuyerCode(String buyerCode) {
			this.buyerCode = buyerCode;
		}
		public Integer getBuyerLevel() {
			return buyerLevel;
		}
		public void setBuyerLevel(Integer buyerLevel) {
			this.buyerLevel = buyerLevel;
		}
		public String getGoodTitle() {
			return goodTitle;
		}
		public void setGoodTitle(String goodTitle) {
			this.goodTitle = goodTitle;
		}
		public String getGoodDesc() {
			return goodDesc;
		}
		public void setGoodDesc(String goodDesc) {
			this.goodDesc = goodDesc;
		}
		public Double getGoodPrice() {
			return goodPrice;
		}
		public void setGoodPrice(Double goodPrice) {
			this.goodPrice = goodPrice;
		}
		public String getGoodUrl() {
			return goodUrl;
		}
		public void setGoodUrl(String goodUrl) {
			this.goodUrl = goodUrl;
		}

	}
}