package cn.ksource.web.facade.satis;

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

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.beans.CUSTOMER_SATIS_TEMPLATE;
import cn.ksource.beans.KPI_SATIS_TEMPLATE;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.EqualUtil;
import cn.ksource.core.util.NumberUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.TreeNode;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.Constants;

@Service("satisfationConfigFacade")
public class SatisfationConfigFacadeImpl implements SatisfationConfigFacade {
	
	@Autowired
	private BaseDao baseDao;

	@Override
	public PageInfo querysatisfactionData(PageInfo pageInfo,
			HttpServletRequest request) {
		StringBuffer sql = new StringBuffer("SELECT * FROM CUSTOMER_SATIS_TEMPLATE WHERE 1=1");
		 Map param = new HashMap();
		String template_name = request.getParameter("template_name");
		if(!StringUtil.isEmpty(template_name)){
			sql.append(" AND TEMPLATE_NAME LIKE :template_name ");
			param.put("template_name", "%"+template_name+"%");
		}
		String template_type = request.getParameter("template_type");
		if(!StringUtil.isEmpty(template_type)){
			sql.append(" AND TEMPLATE_TYPE = :template_type ");
			param.put("template_type", template_type);
		}
		String state = request.getParameter("state");
		if(!StringUtil.isEmpty(state)){
			sql.append(" AND STATE = :state ");
			param.put("state", state);
		}
		sql.append(" ORDER BY STATE,TEMPLATE_TYPE DESC,UPLOAD_TIME DESC");
		return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), param);
	}

	@Override
	public int satisfationCount(HttpServletRequest request) {
		StringBuffer sql = new StringBuffer("SELECT COUNT(ID) FROM CUSTOMER_SATIS_TEMPLATE WHERE 1=1");
		Map param = new HashMap();
		String template_name = request.getParameter("template_name");
		if(!StringUtil.isEmpty(template_name)){
			sql.append(" AND TEMPLATE_NAME LIKE :template_name ");
			param.put("template_name", "%"+template_name+"%");
		}
		String template_type = request.getParameter("template_type");
		if(!StringUtil.isEmpty(template_type)){
			sql.append(" AND TEMPLATE_TYPE = :template_type ");
			param.put("template_type", template_type);
		}
		String state = request.getParameter("state");
		if(!StringUtil.isEmpty(state)){
			sql.append(" AND STATE = :state ");
			param.put("state", state);
		}
		return baseDao.queryForInteger(sql.toString(), param);
	}

	@Override
	public String checkVersion(HttpServletRequest request) {
		String version = request.getParameter("version");
		String type = request.getParameter("type");
		String id = request.getParameter("id");
		String sql = "SELECT COUNT(ID) FROM CUSTOMER_SATIS_TEMPLATE WHERE VERSION = :version AND TEMPLATE_TYPE = :template_type ";
		if(!StringUtil.isEmpty(id)){
			sql += " AND ID <> :id";
		}
		Map param = new HashMap();
		param.put("version", version);
		param.put("template_type", type);
		param.put("id", id);
		int count = baseDao.queryForInteger(sql, param);
		if(count > 0){
			return "1";
		}else{
			return "0";
		}
	}

	@Override
	public void updateState(CUSTOMER_SATIS_TEMPLATE template) {
		
		String sql = "UPDATE CUSTOMER_SATIS_TEMPLATE SET STATE = :index  WHERE STATE = :state AND TEMPLATE_TYPE = :template_type ";
		Map param = new HashMap();
		param.put("index", Constants.CUSTOMER_SATIS_TEMPLATE_STATE_TWO);
		param.put("state", Constants.CUSTOMER_SATIS_TEMPLATE_STATE_ONE);
		param.put("template_type", template.getTemplate_type());
		baseDao.execute(sql, param);
		template.update();
		
	}

	@Override
	public Map getOrderTemplate(HttpServletRequest request) {
		String id = request.getParameter("id");
		StringBuffer sqlYj = new StringBuffer("SELECT C.* FROM CUSTOMER_SATIS_TEMPLATE_ITEM C");
		sqlYj.append(" WHERE  C.STATE = 1 AND C.ITEM_LEVEL = 1 AND C.TEMPLATE_ID = :id ORDER BY C.ORDERNUM ");
		StringBuffer sqlEj = new StringBuffer("SELECT C.* FROM CUSTOMER_SATIS_TEMPLATE_ITEM C");
		sqlEj.append(" WHERE  C.STATE = 1 AND C.ITEM_LEVEL = 2 AND C.TEMPLATE_ID = :id ORDER BY C.ORDERNUM ");
		StringBuffer sqlEva = new StringBuffer("SELECT A.* FROM SATIS_EVA_ITEM A  ");
		sqlEva.append(" WHERE  A.ITEM_ID IN (SELECT C.ID FROM CUSTOMER_SATIS_TEMPLATE_ITEM C,CUSTOMER_SATIS_TEMPLATE B,CUSTOMER_SATIS_TEMPLATE_ITEM D ");
		sqlEva.append(" WHERE  C.STATE = 1 AND C.ITEM_LEVEL = 2 AND C.TEMPLATE_ID = B.ID  AND C.FATHER_ID = D.ID AND B.ID = :id ) ORDER BY A.ORDERNUM  ");
		List<Map> itemYjList = baseDao.queryForList(sqlYj.toString(),new SqlParameter("id",id));
		List<Map> itemList = baseDao.queryForList(sqlEj.toString(),new SqlParameter("id",id));
		List<Map> evaList = baseDao.queryForList(sqlEva.toString(),new SqlParameter("id",id));
		if(itemList != null && itemList.size()>0){
			for(Map item:itemList){
				
				List<Map> evaluList = new ArrayList<Map>();
				for(Map eva:evaList){
					if(eva.get("ITEM_ID").equals(item.get("ID"))){
						evaluList.add(eva);
					}
				}
					
					item.put("EVALUATION", evaluList);
					item.put("ROWSPAN", evaluList.size());
			}
		}
		
		Map cardMap = new HashMap();
		cardMap.put("itemYjList", itemYjList);
		cardMap.put("itemList", itemList);
		return cardMap;
	}

	@Override
	public int queryQzCount(HttpServletRequest request) {
		StringBuffer sql = new StringBuffer("SELECT COUNT(ID) FROM KPI_SATIS_TEMPLATE WHERE 1=1 ");
	    Map param = new HashMap();
		String template_name = request.getParameter("template_name");
		if(!StringUtil.isEmpty(template_name)){
			sql.append(" AND TEMPLATE_NAME LIKE :template_name ");
			param.put("template_name", "%"+template_name+"%");
		}
		return baseDao.queryForInteger(sql.toString(), param);
	}

	@Override
	public PageInfo queryQzdata(HttpServletRequest request, PageInfo pageInfo) {
		StringBuffer sql = new StringBuffer("SELECT * FROM KPI_SATIS_TEMPLATE WHERE 1=1 ");
	    Map param = new HashMap();
		String template_name = request.getParameter("template_name");
		if(!StringUtil.isEmpty(template_name)){
			sql.append(" AND TEMPLATE_NAME LIKE :template_name ");
			param.put("template_name", "%"+template_name+"%");
		}
		sql.append(" ORDER BY STATE ");
		return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), param);
	}

	@Override
	public String checkkpiVersion(HttpServletRequest request) {
		String version = request.getParameter("version");
		String id = request.getParameter("id");
		String sql = "SELECT COUNT(ID) FROM KPI_SATIS_TEMPLATE WHERE VERSION = :version";
		if(!StringUtil.isEmpty(id)){
			sql += " AND ID <> :id";
		}
		Map param = new HashMap();
		param.put("version", version);
		param.put("id", id);
		int count = baseDao.queryForInteger(sql, param);
		if(count > 0){
			return "1";
		}else{
			return "0";
		}
	}

	@Override
	public void updatekpiState(KPI_SATIS_TEMPLATE template) {
		String sql = "UPDATE KPI_SATIS_TEMPLATE SET STATE = :index  WHERE STATE = :state ";
		Map param = new HashMap();
		param.put("index", Constants.CUSTOMER_SATIS_TEMPLATE_STATE_TWO);
		param.put("state", Constants.CUSTOMER_SATIS_TEMPLATE_STATE_ONE);
		baseDao.execute(sql, param);
		template.update();
		
	}

	@Override
	public List<Map> checkisadd(HttpServletRequest request) {
		String sjbh = request.getParameter("cateId");
		String templateId = request.getParameter("templateId");
		String sql = "SELECT A.* FROM CUSTOMER_SATIS_TEMPLATE_ITEM A WHERE A.TEMPLATE_ID = :templateId ";
		SqlParameter param = new SqlParameter();
		param.addValue("templateId", templateId);
		if(StringUtils.isBlank(sjbh)||"0".equals(sjbh)){
			sql = sql + " AND A.ITEM_LEVEL=1 AND (A.FATHER_ID is null OR A.FATHER_ID = '' OR A.FATHER_ID = 0 )";
		}else{
			sql = sql + " AND A.FATHER_ID = :p_id  ";
			param.addValue("p_id",sjbh);
		}
		sql = sql + " ORDER BY A.ORDERNUM ";
		List<Map> count = baseDao.queryForList(sql, param);
		return count;
	}

	@Override
	public List<Map> getsatisQuotatreeList(HttpServletRequest request) {
		String templateId = request.getParameter("templateId");
		Map paramMap = new HashMap();
		String selectSubSql = "SELECT * from CUSTOMER_SATIS_TEMPLATE_ITEM  WHERE STATE = 1 AND  TEMPLATE_ID = :templateId  ORDER BY ITEM_LEVEL,ORDERNUM ";
		paramMap.put("templateId", templateId);
		List<Map> cates = baseDao.queryForList(selectSubSql,paramMap);
        Map result = new HashMap();
		
		List<Map> resultList = new LinkedList<Map>();
		
		Map<String, Map> yjgnCache = new HashMap<String, Map>();
		
		for (Map map : cates) {
			
			//一级树
			if (map.get("ITEM_LEVEL").toString().equalsIgnoreCase("1")) {
				yjgnCache.put(map.get("ID").toString(), map);
				List<Map> ejgnList = new LinkedList<Map>();
				map.put("ejTree", ejgnList);
				resultList.add(map);
				continue;
			}
			//二级树
			if (map.get("ITEM_LEVEL").toString().equalsIgnoreCase("2")) {
				String pId = map.get("FATHER_ID").toString();
				if(yjgnCache.containsKey(pId)) {
					Map yjgnMap = yjgnCache.get(pId);
					List<Map> list = (List<Map>)yjgnMap.get("ejTree");
					map.put("sjTree", new LinkedList<Map>());
					list.add(map);
				}
			}
		}
		return resultList;
	}

	@Override
	public int partnerquotaCount(HttpServletRequest request) {
		String sjbh = request.getParameter("categoryid");
		String templateId = request.getParameter("templateId");
		String sql = "SELECT COUNT(A.ID) FROM CUSTOMER_SATIS_TEMPLATE_ITEM A  WHERE A.TEMPLATE_ID = :templateId ";
		SqlParameter param = new SqlParameter();
		param.addValue("templateId", templateId);
		if(StringUtils.isBlank(sjbh)||"0".equals(sjbh)){
			sql = sql + " AND A.ITEM_LEVEL=1 AND (A.FATHER_ID is null OR A.FATHER_ID = '' OR A.FATHER_ID = 0 )";
		}else{
			sql = sql + " AND A.FATHER_ID = :p_id  ";
			param.addValue("p_id",sjbh);
		}
		int count = baseDao.queryForInteger(sql, param);
		return count;
	}

	@Override
	public PageInfo queryPartnerquotaData(HttpServletRequest request,
			PageInfo pageInfo) {
		String sjbh = request.getParameter("cateId");
		String templateId = request.getParameter("templateId");
		String sql = "SELECT A.*,B.ITEM_NAME AS QUOTANAME FROM CUSTOMER_SATIS_TEMPLATE_ITEM A LEFT JOIN CUSTOMER_SATIS_TEMPLATE_ITEM B ON B.ID = A.FATHER_ID WHERE A.TEMPLATE_ID = :templateId ";
		SqlParameter param = new SqlParameter();
		param.addValue("templateId", templateId);
		if(StringUtils.isBlank(sjbh)||"0".equals(sjbh)){
			sql = sql + " AND A.ITEM_LEVEL=1 AND (A.FATHER_ID is null OR A.FATHER_ID = '' OR A.FATHER_ID = 0 )";
		}else{
			sql = sql + " AND A.FATHER_ID = :p_id  ";
			param.addValue("p_id",sjbh);
		}
		sql = sql + " ORDER BY A.ORDERNUM ";
		return baseDao.queryforSplitPageInfo(pageInfo, sql, param);
	}

	@Override
	public Map saveSatisquota(HttpServletRequest request) {
		String categoryid = request.getParameter("categoryid");
		String templateId = request.getParameter("templateId");
		String item_level = request.getParameter("item_level");
		String zhs[] = request.getParameterValues("zh");
		
		Map result = new HashMap();
		String firstCate = "";
		
		if("1".equals(item_level)) {
			firstCate = categoryid;
		}
		
		List<SqlParameter> param = new ArrayList<SqlParameter>();
		List<SqlParameter> paramEva = new ArrayList<SqlParameter>();
		for(int i=0;i < zhs.length;i++){
			if(!StringUtil.isEmpty(zhs[i])){
				String[] zhvalue = zhs[i].split("&");
				String id = StringUtil.getUUID();
				SqlParameter paraMap = new SqlParameter();
				paraMap.put("id", id);
				paraMap.put("template_id", templateId);
				paraMap.put("item_name", zhvalue[0]);
				if(zhvalue.length==4){
				paraMap.put("item_note", zhvalue[3]);
				}
				else {
					paraMap.put("item_note","");
				}
				paraMap.put("ordernum", zhvalue[2]);
				paraMap.put("evaluation", "[{name:'非常满意',score:100},{name:'满意',score:80},{name:'一般',score:60},{name:'不满意',score:0}]");
				paraMap.put("state", 1);
				paraMap.put("item_level", ConvertUtil.obj2Int(item_level)+1);
				paraMap.put("father_id", categoryid);
				paraMap.put("template_weight", zhvalue[1]);
				param.add(paraMap);
				SqlParameter paramMap1 = new SqlParameter();
				SqlParameter paramMap2 = new SqlParameter();
				SqlParameter paramMap3 = new SqlParameter();
				SqlParameter paramMap4 = new SqlParameter();
				if("1".equals(item_level)){
					
					paramMap1.put("id", StringUtil.getUUID());
					paramMap1.put("item_id", id);
					paramMap1.put("eva_name", "非常满意");
					paramMap1.put("score", 100);
					paramMap1.put("is_default", 2);
					paramMap1.put("ordernum", 1);
					paramMap2.put("id", StringUtil.getUUID());
					paramMap2.put("item_id", id);
					paramMap2.put("eva_name", "满意");
					paramMap2.put("score", 80);
					paramMap2.put("is_default", 2);
					paramMap2.put("ordernum", 2);
					paramMap3.put("id", StringUtil.getUUID());
					paramMap3.put("item_id", id);
					paramMap3.put("eva_name", "一般");
					paramMap3.put("score", 60);
					paramMap3.put("is_default", 2);
					paramMap3.put("ordernum", 3);
					paramMap4.put("id", StringUtil.getUUID());
					paramMap4.put("item_id", id);
					paramMap4.put("eva_name", "不满意");
					paramMap4.put("score", 0);
					paramMap4.put("is_default", 2);
					paramMap4.put("ordernum", 4);
					paramEva.add(paramMap1);
					paramEva.add(paramMap2);
					paramEva.add(paramMap3);
					paramEva.add(paramMap4);
				}
			}
		}
		StringBuffer sql = new StringBuffer("INSERT INTO CUSTOMER_SATIS_TEMPLATE_ITEM(ID,TEMPLATE_ID,ITEM_NAME,ITEM_NOTE,ORDERNUM,EVALUATION,STATE,ITEM_LEVEL,FATHER_ID,TEMPLATE_WEIGHT) ");
		sql.append(	"VALUES(:id,:template_id,:item_name,:item_note,:ordernum,:evaluation,:state,:item_level,:father_id,:template_weight)");
		baseDao.executeBatch(sql.toString(), param);
		if("1".equals(item_level)){
			StringBuffer sqlEva = new StringBuffer("INSERT INTO SATIS_EVA_ITEM(ID,ITEM_ID,EVA_NAME,SCORE,IS_DEFAULT,ORDERNUM) ");
			sqlEva.append(	"VALUES(:id,:item_id,:eva_name,:score,:is_default,:ordernum)");
			baseDao.executeBatch(sqlEva.toString(), paramEva);
		}
		result.put("firstCate", firstCate);
		return result;
	}

	@Override
	public Map updateSatisquota(HttpServletRequest request) {
		String categoryid = request.getParameter("cateId");
		String templateId = request.getParameter("templateId");
		String item_level = request.getParameter("item_level");
		String zhs[] = request.getParameterValues("zh");
		String ids[] = request.getParameterValues("id");
		String delids[] = request.getParameterValues("delid");
		
		Map result = new HashMap();
		String firstCate = "";
		
		if("1".equals(item_level)) {
			firstCate = categoryid;
		}
		
		List<SqlParameter> param = new ArrayList<SqlParameter>();
		List<SqlParameter> updparam = new ArrayList<SqlParameter>();
		List<SqlParameter> delparam = new ArrayList<SqlParameter>();
		List<SqlParameter> paramEva = new ArrayList<SqlParameter>();
		if(delids != null){
			if(delids.length > 0){
				for(int i=0;i < delids.length;i++){
					SqlParameter paraMap = new SqlParameter();
					if(!StringUtil.isEmpty(delids[i])){
						paraMap.put("id", delids[i]);
						delparam.add(paraMap);
					}
				}
			}
		}
		for(int i=0;i < zhs.length;i++){
			if(!StringUtil.isEmpty(zhs[i])){
				if(StringUtil.isEmpty(ids[i])){
				
					String[] zhvalue = zhs[i].split("-");
					String id = StringUtil.getUUID();
					SqlParameter paraMap = new SqlParameter();
					paraMap.put("id", id);
					paraMap.put("template_id", templateId);
					paraMap.put("item_name", zhvalue[0]);
					if(zhvalue.length==4){
						paraMap.put("item_note", zhvalue[3]);
					}else{
						paraMap.put("item_note", "");
					}
					paraMap.put("ordernum", zhvalue[2]);
					paraMap.put("state", 1);
					paraMap.put("item_level", ConvertUtil.obj2Int(item_level)+1);
					paraMap.put("father_id", categoryid);
					paraMap.put("template_weight", zhvalue[1]);
					param.add(paraMap);
					SqlParameter paramMap1 = new SqlParameter();
					SqlParameter paramMap2 = new SqlParameter();
					SqlParameter paramMap3 = new SqlParameter();
					SqlParameter paramMap4 = new SqlParameter();
					if("1".equals(item_level)){
						
						paramMap1.put("id", StringUtil.getUUID());
						paramMap1.put("item_id", id);
						paramMap1.put("eva_name", "非常满意");
						paramMap1.put("score", 100);
						paramMap1.put("is_default", 2);
						paramMap1.put("ordernum", 1);
						paramMap2.put("id", StringUtil.getUUID());
						paramMap2.put("item_id", id);
						paramMap2.put("eva_name", "满意");
						paramMap2.put("score", 80);
						paramMap2.put("is_default", 2);
						paramMap2.put("ordernum", 2);
						paramMap3.put("id", StringUtil.getUUID());
						paramMap3.put("item_id", id);
						paramMap3.put("eva_name", "一般");
						paramMap3.put("score", 60);
						paramMap3.put("is_default", 2);
						paramMap3.put("ordernum", 3);
						paramMap4.put("id", StringUtil.getUUID());
						paramMap4.put("item_id", id);
						paramMap4.put("eva_name", "不满意");
						paramMap4.put("score", 0);
						paramMap4.put("is_default", 2);
						paramMap4.put("ordernum", 4);
						paramEva.add(paramMap1);
						paramEva.add(paramMap2);
						paramEva.add(paramMap3);
						paramEva.add(paramMap4);
					}
			    }else{
			    	String[] zhvalue = zhs[i].split("-");
					SqlParameter paraMap = new SqlParameter();
					paraMap.put("id", ids[i]);
					paraMap.put("item_name", zhvalue[0]);
					if(zhvalue.length==4){
					paraMap.put("item_note", zhvalue[3]);
					}
					else {
						paraMap.put("item_note","");
					}
					paraMap.put("ordernum", zhvalue[2]);
					paraMap.put("template_weight", zhvalue[1]);
					updparam.add(paraMap);
			    }
			}
		}
		if("1".equals(item_level)){
			baseDao.executeBatch("DELETE FROM SATIS_EVA_ITEM WHERE ITEM_ID = :id ", delparam);
			baseDao.executeBatch("DELETE FROM CUSTOMER_SATIS_TEMPLATE_ITEM WHERE ID = :id ", delparam);
		}else{
			baseDao.executeBatch("DELETE FROM SATIS_EVA_ITEM WHERE ITEM_ID IN (SELECT ID FROM CUSTOMER_SATIS_TEMPLATE_ITEM WHERE FATHER_ID = :id) ", delparam);
			baseDao.executeBatch("DELETE FROM CUSTOMER_SATIS_TEMPLATE_ITEM WHERE FATHER_ID = :id ", delparam);
			baseDao.executeBatch("DELETE FROM CUSTOMER_SATIS_TEMPLATE_ITEM WHERE ID = :id ", delparam);
		}
		StringBuffer sqlupd = new StringBuffer("UPDATE CUSTOMER_SATIS_TEMPLATE_ITEM ");
		sqlupd.append(	" SET ITEM_NAME = :item_name,ITEM_NOTE = :item_note,ORDERNUM = :ordernum,TEMPLATE_WEIGHT = :template_weight WHERE ID = :id ");
		baseDao.executeBatch(sqlupd.toString(), updparam);
		StringBuffer sql = new StringBuffer("INSERT INTO CUSTOMER_SATIS_TEMPLATE_ITEM(ID,TEMPLATE_ID,ITEM_NAME,ITEM_NOTE,ORDERNUM,STATE,ITEM_LEVEL,FATHER_ID,TEMPLATE_WEIGHT) ");
		sql.append(	"VALUES(:id,:template_id,:item_name,:item_note,:ordernum,:state,:item_level,:father_id,:template_weight)");
		baseDao.executeBatch(sql.toString(), param);
		if("1".equals(item_level)){
			StringBuffer sqlEva = new StringBuffer("INSERT INTO SATIS_EVA_ITEM(ID,ITEM_ID,EVA_NAME,SCORE,IS_DEFAULT,ORDERNUM) ");
			sqlEva.append(	"VALUES(:id,:item_id,:eva_name,:score,:is_default,:ordernum)");
			baseDao.executeBatch(sqlEva.toString(), paramEva);
		}
		result.put("firstCate", firstCate);
		return result;
		
	}

	@Override
	public List getEvaList(HttpServletRequest request) {
		String id = request.getParameter("id");
		String sql = "SELECT * FROM SATIS_EVA_ITEM WHERE ITEM_ID = :item_id ORDER BY ORDERNUM ";
		
		return baseDao.queryForList(sql, new SqlParameter("item_id",id));
	}

	@Override
	public boolean updateQuota(HttpServletRequest request) {
		String id = request.getParameter("id");
		String[] evaluations = request.getParameterValues("evaluation");
		String[] scores = request.getParameterValues("score");
		String[] ordernums = request.getParameterValues("ordernum");
		String is_default = request.getParameter("is_default");
		
		List<SqlParameter> list = new ArrayList<SqlParameter>();
		if(null != evaluations && evaluations.length!=0) {
			for(int i=0; i<evaluations.length; i++) {
				if(!StringUtil.isEmpty(evaluations[i])){
					String is_d = "2";
					if(!StringUtil.isEmpty(is_default)&&ConvertUtil.obj2Integer(is_default) == (i+1)){
						is_d = "1";
					}
					SqlParameter map = new SqlParameter();
					map.put("id", StringUtil.getUUID());
					map.put("item_id", id);
					map.put("eva_name", evaluations[i]);
					map.put("score", scores[i]);
					map.put("is_default", is_d);
					map.put("ordernum", ordernums[i]);
					list.add(map);
				}
			}
			baseDao.execute("DELETE FROM SATIS_EVA_ITEM WHERE ITEM_ID = :item_id ", new SqlParameter("item_id",id));
			StringBuffer sqlEva = new StringBuffer("INSERT INTO SATIS_EVA_ITEM(ID,ITEM_ID,EVA_NAME,SCORE,IS_DEFAULT,ORDERNUM) ");
			sqlEva.append(	"VALUES(:id,:item_id,:eva_name,:score,:is_default,:ordernum)");
			baseDao.executeBatch(sqlEva.toString(), list);
		} 
		return true;
		
	}
	
	@Override
	public void saveQz(HttpServletRequest request) {
		String templateId = request.getParameter("templateId");
		String type[] = request.getParameterValues("qz_type");
		String bigqz[] = request.getParameterValues("bigqz");
		String fg_rate[] = request.getParameterValues("fg_rate");
		String score[] = request.getParameterValues("score");
		String defaultscore[] = request.getParameterValues("defaultscore");
		String satis_bustype[] = request.getParameterValues("satis_bustype");
		String allvalues[] = request.getParameterValues("allvalues");
		double bigscore = 0 ;
		StringBuffer satis_bustype1 = new StringBuffer();
		if(satis_bustype != null && satis_bustype.length > 0){
			for(int i = 0;i<satis_bustype.length;i++){
				String bustype = "'"+satis_bustype[i]+"',";
				satis_bustype1.append(bustype);
			}
			satis_bustype1.deleteCharAt(satis_bustype1.lastIndexOf(","));
		}
		List<SqlParameter> paramList = new ArrayList<SqlParameter>();
		for(int i=0;i<type.length;i++){
			String id = StringUtil.getUUID();
			SqlParameter paraMap = new SqlParameter();
			paraMap.put("id", id);
			paraMap.put("satis_type", type[i]);
			paraMap.put("satis_qz", bigqz[i]);
			paraMap.put("fg_rate", fg_rate[i]);
			paraMap.put("satis_score", score[i]);
			paraMap.put("default_score", defaultscore[i]);
			paraMap.put("template_id", templateId);
			paraMap.put("father_id", null);
			paraMap.put("satis_bustype", null);
			double itemscore = NumberUtil.div(NumberUtil.mul(ConvertUtil.obj2Double(bigqz[i]), ConvertUtil.obj2Double(score[i])),100.00,0);
			bigscore = NumberUtil.add(bigscore ,itemscore);
			if("2".equals(type[i])){
				paraMap.put("satis_bustype", satis_bustype1);
				if(allvalues.length > 0){
					for(int j=0;j<allvalues.length;j++){
						if(!StringUtil.isEmpty(allvalues[j])){
						    String[] allvalue = allvalues[j].split("-");
							SqlParameter para = new SqlParameter();
							para.put("id", StringUtil.getUUID());
							para.put("satis_type", allvalue[0]);
							para.put("satis_qz", allvalue[2]);
							para.put("fg_rate", allvalue[1]);
							para.put("satis_score", allvalue[3]);
							para.put("default_score", allvalue[4]);
							para.put("template_id", templateId);
							para.put("father_id", id);
							para.put("satis_bustype", null);
							paramList.add(para);
						}
					}
				}
			}
			paramList.add(paraMap);
		}
		
		baseDao.execute("DELETE FROM KPI_CONFIG WHERE TEMPLATE_ID = :template_id ", new SqlParameter("template_id",templateId));
		String sql = "INSERT INTO KPI_CONFIG(ID,TEMPLATE_ID,SATIS_TYPE,FG_RATE,SATIS_QZ,SATIS_SCORE,FATHER_ID,SATIS_BUSTYPE,DEFAULT_SCORE) VALUES(:id,:template_id,:satis_type,:fg_rate,:satis_qz,:satis_score,:father_id,:satis_bustype,:default_score)";
		baseDao.executeBatch(sql, paramList);
		KPI_SATIS_TEMPLATE template = new KPI_SATIS_TEMPLATE(templateId);
		template.setAll_score(ConvertUtil.obj2Str(bigscore)).update();
		
	}
	
	@Override
	public Map getKpiConfig(HttpServletRequest request) {
		String templateId = request.getParameter("templateId");
		List<Map> kpiList = baseDao.queryForList("SELECT * FROM KPI_CONFIG WHERE TEMPLATE_ID = :template_id ", new SqlParameter("template_id",templateId));
		Map result = new HashMap();
		for(Map map:kpiList){
			if(ConvertUtil.obj2Integer(map.get("SATIS_TYPE")) == 1){
				result.put("xyMap", map);
			}else if(ConvertUtil.obj2Integer(map.get("SATIS_TYPE")) == 3){
				result.put("zcMap", map);
			}
		}
		
		return result;
	}
	

}