package com.action;
import java.sql.Connection;
import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.interceptor.ServletRequestAware;

import com.opensymphony.xwork2.ActionSupport;
import com.dao.GoodsDao;
import com.dao.GoodsTypeDao;
import com.model.PageBean;
import com.model.GoodsType;
import com.util.DbUtil;
import com.util.ExcelUtil;
import com.util.JsonUtil;
import com.util.ResponseUtil;
import com.util.StringUtil;

public class GoodsTypeAction extends ActionSupport implements ServletRequestAware {
	private static final long serialVersionUID = 1L;

	private GoodsType sm;
	private String error;

	private String page;
	private String rows;
	private String delIds;
	// 查询条件的变量
	private String name;
	private String id;


	public GoodsType getSm() {
		return sm;
	}

	public void setSm(GoodsType sm) {
		this.sm = sm;
	}

	public String getError() {
		return error;
	}

	public void setError(String error) {
		this.error = error;
	}

	@Override
	public void setServletRequest(HttpServletRequest request) {

		this.request = request;
	}

	public String getPage() {
		return page;
	}

	public void setPage(String page) {
		this.page = page;
	}

	public String getRows() {
		return rows;
	}

	public void setRows(String rows) {
		this.rows = rows;
	}

	public String getDelIds() {
		return delIds;
	}

	public void setDelIds(String delIds) {
		this.delIds = delIds;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}


	DbUtil dbutil = new DbUtil();
	HttpServletRequest request;
	GoodsTypeDao smd = new GoodsTypeDao();

	public String execute() throws Exception {

		PageBean pageBean = new PageBean(Integer.parseInt(page),
				Integer.parseInt(rows));// 分页pageBean
		Connection con = null;

		try {
			if (sm == null) {
				sm = new GoodsType();
			}

			sm.setTypename(name);
	
			con = dbutil.getCon();
			JSONObject result = new JSONObject();
			JSONArray jsonArray = JsonUtil.formatRsToJsonArray(smd.list(con,
					pageBean, sm));
			int total = smd.Count(con, sm);
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(ServletActionContext.getResponse(), result);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				dbutil.closeCon(con);
			} catch (Exception e) {

				e.printStackTrace();
			}
		}
		return null;
	}
GoodsDao goodsdao=new GoodsDao();
	public String delete() throws Exception {
		Connection con = null;
		try {
			con = dbutil.getCon();
			JSONObject result = new JSONObject();
			String str[]=delIds.split(",");
			for(int i=0; i<str.length;i++){
				boolean f=goodsdao.getGoodsTypeByGoodsId(con, str[i]);
				if(f){
					result.put("errorIndex", i);
					result.put("errorMsg","下面有货物，不能删除");
					ResponseUtil.write(ServletActionContext.getResponse(), result);
					return null;
				}
			}
			
			int delNums = smd.delete(con, delIds);
			if (delNums > 0) {
				result.put("success", "true");
				result.put("delNums", delNums);
			} else {
				result.put("errorMsg", "删除失败");
			}
			ResponseUtil.write(ServletActionContext.getResponse(), result);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				dbutil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}

	public String save() throws Exception {
		if (StringUtil.isNotEmpty(id)) {
			sm.setTid(Integer.parseInt(id));
		}
		Connection con = null;
		try {
			con = dbutil.getCon();
			int saveNums = 0;
			JSONObject result = new JSONObject();
			if (StringUtil.isNotEmpty(id)) {
				if(smd.UniqueTypeid(con,sm)){
					result.put("success", "true");
					result.put("errorMsg", "类型名不能重复保存失败");
					ResponseUtil.write(ServletActionContext.getResponse(), result);
					return null;
				}
				saveNums = smd.modify(con, sm);
			} else {
				if(smd.UniqueType(con,sm)){
					result.put("success", "true");
					result.put("errorMsg", "类型名不能重复保存失败");
					ResponseUtil.write(ServletActionContext.getResponse(), result);
					return null;
				}
				saveNums = smd.add(con, sm);
			}
			if (saveNums > 0) {
				result.put("success", "true");
			} else {
				result.put("success", "true");
				result.put("errorMsg", "保存失败");
			}
			ResponseUtil.write(ServletActionContext.getResponse(), result);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				dbutil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}

	public String export() throws Exception {
		Connection con = null;
if(sm==null){
	sm=new GoodsType();
}
		try {
			con = dbutil.getCon();
			ResultSet rs = smd.list(con, null, sm);
			Workbook wb = ExcelUtil.fillExcelDataWithTemplate(rs,
					"goodstype.xls");
			ResponseUtil.export(ServletActionContext.getResponse(), wb,
					"利用模版导出excel.xls");
		} catch (Exception e) {
	
			e.printStackTrace();
		} finally {
			try {
				dbutil.closeCon(con);
			} catch (Exception e) {
	
				e.printStackTrace();
			}
		}
		return null;

	}
	public String goodsComboList(){
		Connection con=null;
		try{
			con=dbutil.getCon();
			JSONArray jsonArray =new JSONArray();
			JSONObject jsonObject=new JSONObject();
			jsonObject.put("tid", "");
			jsonObject.put("typename","请选择...");
			jsonArray.add(jsonObject);
			jsonArray.addAll(JsonUtil.formatRsToJsonArray(smd.list(con, null,null)));
			ResponseUtil.write(ServletActionContext.getResponse(), jsonArray);
			
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try {
				dbutil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}
}