package cn.ksource.web.facade.knowledge.knowledgeDeal;

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.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.beans.KM_LIBRARY;
import cn.ksource.beans.KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP;
import cn.ksource.beans.KM_LIBRARY_TEMP;
import cn.ksource.beans.SC_WORKFLOW_INCIDENT;
import cn.ksource.beans.SC_WORKFLOW_INCIDENT_LOCAL;
import cn.ksource.beans.SC_WORKFLOW_QUESTION;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.AjaxUtil;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.SysInfoMsg;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.service.file.FileService;


@Service("knowledgeDealFacade")
public class KnowledgeDealFacadeImpl implements KnowledgeDealFacade {
	
	@Autowired
	private BaseDao baseDao;
	
	@Autowired
	private FileService fileService;

	@Override
	public Map categoryListTree(HttpServletRequest request) {
		String company = request.getParameter("company");
		String dept = request.getParameter("dept");
		String sql="SELECT * FROM KM_LIBRARY_CATEGORY WHERE STATE = 1 ";
		sql +=" ORDER BY LEVEL,SERIAL ";
		Map slMap = new HashMap(); 
		String sl = request.getParameter("sl");
		if(StringUtil.notEmpty(sl)) {
			String[] sls = sl.split(",");
			for(String s : sls) {
				slMap.put(s, s);
			}
		}
		List<Map> categoryList = baseDao.queryForList(sql);
		
		Map result = new HashMap();
		
		List<Map> resultList = new LinkedList<Map>();
		
		Map<String, Map> yjgnCache = new HashMap<String, Map>();
		Map<String, Map> ejgnCache = new HashMap<String, Map>();
		Map<String, Map> sjgnCache = new HashMap<String, Map>();
		
		for (Map map : categoryList) {
			
			//一级树
			if (map.get("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("LEVEL").toString().equalsIgnoreCase("2")) {
				Map yjgnMap = yjgnCache.get(map.get("TAG").toString());
				List<Map> list = (List<Map>)yjgnMap.get("ejTree");
				map.put("sjTree", new LinkedList<Map>());
				list.add(map);
				
				ejgnCache.put(map.get("ID").toString(), map);
				continue;
			}
			//三级树
			if (map.get("LEVEL").toString().equalsIgnoreCase("3")) {
				if(null!=map.get("TAG")){
					if(slMap.containsKey(map.get("ID"))) {
						slMap.put(map.get("ID"), map.get("TITLE"));
						map.put("check", 1);
					} else {
						map.put("check", 2);
					}
					
					Map ejgnMap = ejgnCache.get(map.get("TAG").toString());
					List<Map> list = (List<Map>)ejgnMap.get("sjTree");
					list.add(map);
				}
			}
		}
		Map resultMap = new HashMap();
		resultMap.put("categoryList", resultList);
		resultMap.put("slMap", slMap);
		return resultMap;
	}

	@Override
	public Map thirdlevelListTree(HttpServletRequest request) {
		String sql="SELECT * FROM CMDB_CI_CATEGORY WHERE STATE = 1 ORDER BY LV,SERIAL,NAME ";
		
		Map slMap = new HashMap(); 
		String sl = request.getParameter("sl");
		if(StringUtil.notEmpty(sl)) {
			String[] sls = sl.split(",");
			for(String s : sls) {
				slMap.put(s, s);
			}
		}
		
		List<Map> categoryList = baseDao.queryForList(sql);
		
		Map result = new HashMap();
		
		List<Map> resultList = new LinkedList<Map>();
		
		Map<String, Map> yjgnCache = new HashMap<String, Map>();
		Map<String, Map> ejgnCache = new HashMap<String, Map>();
		Map<String, Map> sjgnCache = new HashMap<String, Map>();
		
		for (Map map : categoryList) {
			
			//一级树
			if (map.get("LV").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("LV").toString().equalsIgnoreCase("2")) {
				Map yjgnMap = yjgnCache.get(map.get("PID").toString());
				List<Map> list = (List<Map>)yjgnMap.get("ejTree");
				map.put("sjTree", new LinkedList<Map>());
				list.add(map);
				
				ejgnCache.put(map.get("ID").toString(), map);
				continue;
			}
			//三级树
			if (map.get("LV").toString().equalsIgnoreCase("3")) {
				if(null!=map.get("PID")){
					if(slMap.containsKey(map.get("ID"))) {
						slMap.put(map.get("ID"), map.get("NAME"));
						map.put("check", 1);
					} else {
						map.put("check", 2);
					}
					
					Map ejgnMap = ejgnCache.get(map.get("PID").toString());
					List<Map> list = (List<Map>)ejgnMap.get("sjTree");
					list.add(map);
				}
			}
		}
		Map resultMap = new HashMap();
		resultMap.put("categoryList", resultList);
		resultMap.put("slMap", slMap);
		return resultMap;
	}

	@Override
	public Map saveKnowledge(HttpServletRequest request,
			KM_LIBRARY_TEMP km_library_temp) {
		Map resultMap = new HashMap();
		resultMap.put("result", 2);
		Map user = WebUtil.getLoginUser(request).getLoginUser();
		String changeId = request.getParameter("changeId");
		String bustype = request.getParameter("bustype");
        String sh = request.getParameter("sh");
        String add = String.valueOf(request.getAttribute("add"));
        if(!"1".equals(sh)){
        	if(StringUtil.isEmpty(add)){
        		km_library_temp.setContent_state(1);
        	}else{
        		km_library_temp.setContent_state(2);
        		km_library_temp.setId(null);
        	}
        }
        String version = request.getParameter("version");
		
		String userId = ConvertUtil.obj2StrBlank(user.get("ID"));
		String userName = ConvertUtil.obj2StrBlank(user.get("ZSXM"));
		
		String serivceListId = request.getParameter("serivceListId");
		String serivceList = request.getParameter("serivceList");
		String category_id = request.getParameter("category_id");
		String categoryList = request.getParameter("categoryList");
		String thirdlevel_id = request.getParameter("thirdlevel_id");
		String thirdlevelList = request.getParameter("thirdlevelList");
		
		String first_category_id = new String();
		String first_category_name = new String();
		String second_category_id = new String();
		String second_category_name = new String();
		String third_category_id = new String();
		String third_category_name = new String();
		String categoryid = new String();
		String category_name = new String();
		String first_knowcategory_id = new String();
		String first_knowcategory_name = new String();
		String second_knowcategory_id = new String();
		String second_knowcategory_name = new String();
		String third_level_id = new String();
		String third_level_name = new String();
		String first_level_id = new String();
		String first_level_name = new String();
		String second_level_id = new String();
		String second_level_name = new String();
		if(StringUtil.notEmpty(serivceListId) && StringUtil.notEmpty(serivceList)) {
			String[] serivceListIds = serivceListId.split("-");
			String[] serivceLists = serivceList.split("-");
			if(serivceListIds.length>0){
			first_category_id = serivceListIds[0];
			first_category_name = serivceLists[0];
			second_category_id = serivceListIds[1];
			second_category_name = serivceLists[1];
			third_category_id = serivceListIds[2];
			third_category_name = serivceLists[2];
			}
		}
		if(StringUtil.notEmpty(category_id) && StringUtil.notEmpty(categoryList)) {
			String[] categoryListIds = category_id.split("-");
			String[] categoryLists = categoryList.split("-");
			if(categoryListIds.length>0){
				first_knowcategory_id = categoryListIds[0];
				first_knowcategory_name = categoryLists[0];
				second_knowcategory_id = categoryListIds[1];
				second_knowcategory_name = categoryLists[1];
				categoryid = categoryListIds[2];
				category_name = categoryLists[2];
				}
		}
		if(StringUtil.notEmpty(thirdlevel_id) && StringUtil.notEmpty(thirdlevelList)) {
			String[] thirdListIds = thirdlevel_id.split("-");
			String[] thirdLists = thirdlevelList.split("-");
			if(thirdListIds.length>0){
				first_level_id = thirdListIds[0];
				first_level_name = thirdLists[0];
				second_level_id = thirdListIds[1];
				second_level_name = thirdLists[1];
				third_level_id = thirdListIds[2];
				third_level_name = thirdLists[2];
				}
		}
		//待审核
		Integer auditState = Constants.KM_LIBRARY_TEMP_AUDIT_STATE_DSH;
		String shId = request.getParameter("shId");
		System.out.println(shId);
		String shName = request.getParameter("shName");
		if(!StringUtil.isEmpty(shId)){
			
			//是否用户可见
			Integer access_type = ConvertUtil.obj2Integer(request.getParameter("isKj"));
			
			long createTime = DateUtil.getCurrentDate14();
			km_library_temp.setFirst_knowcategory_id(first_knowcategory_id).setFirst_knowcategory_name(first_knowcategory_name)
			.setSecond_knowcategory_id(second_knowcategory_id).setSecond_knowcategory_name(second_knowcategory_name)
			.setCategory_id(categoryid).setCategory_name(category_name)
			.setFirstlevel_id(first_level_id).setFirstlevel_name(first_level_name)
			.setSecondlevel_id(second_level_id).setSecondlevel_name(second_level_name)
			.setThirdlevel_id(third_level_id).setThirdlevel_name(third_level_name)
			.setFirst_category_id(first_category_id).setFirst_category_name(first_category_name)
			.setSecond_category_id(second_category_id).setSecond_category_name(second_category_name)
			.setThird_category_id(third_category_id).setThird_category_name(third_category_name)
			.setUpdate_date(createTime).setUpdater_id(userId).setUpdate_name(userName).setHits(0).setIs_editor(ConvertUtil.obj2Integer(request.getParameter("is_editor")));
			if(StringUtil.isBlank(km_library_temp.getId())){
				km_library_temp.setCreate_user_id(userId).setCreate_user_name(userName).setCreate_time(createTime);
			}
			km_library_temp.setState(ConvertUtil.obj2Integer(1)).setAudit_state(auditState).setAudit_userid(shId).setAudit_username(shName).setAccess_type(access_type).insertOrUpdate();
			if(ConvertUtil.obj2Integer(km_library_temp.getContent_state()) == 1){
				km_library_temp.setBefore_version(null).setAfter_version(1).setVersion("1").update();
			}else{
				KM_LIBRARY kn = new KM_LIBRARY(request.getParameter("id")).getInstanceById();
				km_library_temp.setCreate_user_id(kn.getCreate_user_id()).setCreate_user_name(kn.getCreate_user_name()).setCreate_time(kn.getCreate_time());
				km_library_temp.setOriginal_id(request.getParameter("id")).setVersion((ConvertUtil.obj2Integer(version)+1)+"").setAfter_version(ConvertUtil.obj2Integer(version)+1).setBefore_version(ConvertUtil.obj2Integer(version)).update();
			}
			
			//修改的时候不更新这些消息
//			if(ConvertUtil.obj2Integer(km_library_temp.getContent_state()) == 1){
				//添加用户权限信息
				String cusId = request.getParameter("cusId");
				String cusList = request.getParameter("cusList");
				if(access_type == 1 ){  //需要设置权限
					KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP access_temp = new KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP();
					//每次重新存之前先删除先前的数据
					baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE_ACCESS WHERE KNOWLEDGE_ID = :knowId", new SqlParameter("knowId",km_library_temp.getId()));
					String[] cusIdArray = cusId.split(",");
					String[] cusListArray = cusList.split(",");
					for (int i = 0; i < cusIdArray.length; i++) {
						access_temp = new KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP();
						access_temp.setKnowledge_id(km_library_temp.getId()).setCustomer_id(cusIdArray[i]).setCustomer_name(cusListArray[i]).insert();
					}
				}
				
				
				//添加关联知识
				//删除已存在的关联知识
				baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE WHERE LIBRARY_ID = :business_id ", new SqlParameter("business_id",km_library_temp.getOriginal_id()));
				String[] knowId = request.getParameterValues("knowId");
				if(null!=knowId && knowId.length>0) {
					List<SqlParameter> paramList = new ArrayList<SqlParameter>();
					for(String str : knowId) {
						SqlParameter sqlParameter = new SqlParameter();
						sqlParameter.put("id", StringUtil.getUUID());
						if(km_library_temp.getOriginal_id()==null){
							sqlParameter.put("library_id", km_library_temp.getId());
						}else{
							sqlParameter.put("library_id", km_library_temp.getOriginal_id());
						}
						sqlParameter.put("knowledge_id", str);
						paramList.add(sqlParameter);
					}
					String insertSql = "INSERT INTO KM_LIBRARY_KNOWLEDGE(ID,LIBRARY_ID,KNOWLEDGE_ID) VALUES (:id,:library_id,:knowledge_id)";
					baseDao.executeBatch(insertSql, paramList);
				}
				
//			}
			
			//提交工单时上传文档附件
			fileService.uploadFile(request,km_library_temp.getId(),Constants.GG_FOLDERS_KNOWFOLDERS,Constants.FILE_STATE_SHTG,null);
			
			SysInfoMsg msg = new SysInfoMsg("2",shName,"知识审核");
			resultMap.put("msg", msg);
			resultMap.put("result", 1);
			//转知识
			if(!StringUtil.isEmpty(changeId)){
				if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT == ConvertUtil.obj2Int(bustype)){
					SC_WORKFLOW_INCIDENT incident = new SC_WORKFLOW_INCIDENT(changeId);
					incident.setKnowledgeid(km_library_temp.getId()).update();
				}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_QUESTION == ConvertUtil.obj2Int(bustype)){
					SC_WORKFLOW_QUESTION question = new SC_WORKFLOW_QUESTION(changeId);
					question.setKnowledgeid(km_library_temp.getId()).update();
				}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT_LOCAL == ConvertUtil.obj2Int(bustype)){
					SC_WORKFLOW_INCIDENT_LOCAL zcyw = new SC_WORKFLOW_INCIDENT_LOCAL(changeId);
					zcyw.setKnowledgeid(km_library_temp.getId()).update();
				}
			}
		}else{
			resultMap.put("nouser", 1);
		}
			
		return resultMap;
		
	}

	@Override
	public Map queryProjectSeviceList(HttpServletRequest request) {
		String sl = request.getParameter("sl");
		
		String dept = ConvertUtil.obj2StrBlank(WebUtil.getLoginUser(request).getLoginUser().get("YJBMBH")); 
		String sql="SELECT * FROM SC_SERVCE_CATEGORY WHERE STATE = 1 AND TYPE = 2 ORDER BY LEVEL,SERIAL ";
		
		List<Map> categoryList = baseDao.queryForList(sql,new SqlParameter().addValue("dept", dept));
		
		Map slMap = new HashMap(); 
		if(StringUtil.notEmpty(sl)) {
			String[] sls = sl.split(",");
			for(String s : sls) {
				slMap.put(s, s);
			}
		}
		
		Map result = new HashMap();
		
		List<Map> resultList = new LinkedList<Map>();
		
		Map<String, Map> yjgnCache = new HashMap<String, Map>();
		Map<String, Map> ejgnCache = new HashMap<String, Map>();
		Map<String, Map> sjgnCache = new HashMap<String, Map>();
		
		for (Map map : categoryList) {
			
			//一级树
			if (map.get("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("LEVEL").toString().equalsIgnoreCase("2")) {
				Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
				List<Map> list = (List<Map>)yjgnMap.get("ejTree");
				map.put("sjTree", new LinkedList<Map>());
				list.add(map);
				
				ejgnCache.put(map.get("ID").toString(), map);
				continue;
			}
			//三级树
			if (map.get("LEVEL").toString().equalsIgnoreCase("3")) {
				if(null!=map.get("P_ID")){
					
					if(slMap.containsKey(map.get("ID"))) {
						slMap.put(map.get("ID"), map.get("CATEGORY_NAME"));
						map.put("check", 1);
					} else {
						map.put("check", 2);
					}
					
					Map ejgnMap = ejgnCache.get(map.get("P_ID").toString());
					List<Map> list = (List<Map>)ejgnMap.get("sjTree");
					list.add(map);
				}
			}
		}
		Map resultMap = new HashMap();
		resultMap.put("categoryList", resultList);
		resultMap.put("slMap", slMap);
		return resultMap;
	}

	@Override
	public List queryLinkKnow(HttpServletRequest request) {
		String title = request.getParameter("title");
		String keyword = request.getParameter("keyword");
		String knowIds = request.getParameter("knowIds");
		String sql;
        SqlParameter parameter =new SqlParameter();
        sql = "SELECT A.*,B.TITLE AS NAME FROM KM_LIBRARY A,KM_LIBRARY_CATEGORY B WHERE A.CATEGORY_ID = B.ID AND A.STATE =1 ";
        parameter.addValue("userId", WebUtil.getLoginedUserId(request));
	        
	        
	        if (!StringUtil.isEmpty(knowIds)) {
	        	String knowid[] = knowIds.split("-");
	        	String para="";
	        	for(int i=0;i<knowid.length;i++){
			        if(i<knowid.length-1){
						para+=knowid[i]+"','";
					}else if(i==knowid.length-1){
						para+=knowid[i];
					}
	        	}
	        	sql += " and A.ID NOT IN ('"+para+"') ";
	        }
	        if (!StringUtil.isEmpty(title)) {
				sql+="and A.TITLE like :title  ";
				parameter.addValue("title", "%" + title + "%");
			}
	        
	        if (!StringUtil.isEmpty(keyword)) {
	        	sql += " and A.TAG LIKE :keyword ";
	        	parameter.addValue("keyword", "%"+keyword+"%");
	        }
	        
	        sql += " ORDER BY B.ID";
	        List<Map> knows = baseDao.queryForList(sql,parameter);
			
			return knows;
	}

	@Override
	public Integer queryChooseCusCount(Map<String, String> params) {
		StringBuilder sql = new StringBuilder("SELECT COUNT(ID) FROM SC_PARTNER_CUSTOMER_INFO ");
		queryChooseCusIf(params,sql);
		return baseDao.queryForInteger(sql.toString(), params);
	}
	@Override
	public Integer queryChoosePersonCount(Map<String, String> params) {
		String cusName=ConvertUtil.obj2StrBlank(params.get("cusName"));
		String customer_name=ConvertUtil.obj2StrBlank(params.get("customer_name"));
		StringBuilder sql = new StringBuilder("SELECT COUNT(A.ID) FROM customer_contacts A,SC_PARTNER_CUSTOMER_INFO B where A.STATE=1 and A.ALLOW_LOGIN=1 AND A.CUSTOMER_ID=B.ID ");
		if(StringUtil.notEmpty(cusName)){
			sql.append(" AND A.CONTACT_NAME like :cusName");
			params.put("cusName", "%"+cusName+"%");
		}
		if(StringUtil.notEmpty(customer_name)){
			sql.append(" AND B.CUSTOMER_NAME like :customer_name");
			params.put("customer_name", "%"+customer_name+"%");
		}
		return baseDao.queryForInteger(sql.toString(), params);
	}

	@Override
	public PageInfo queryChooseCusData(PageInfo pageInfo,
			Map<String, String> params) {
		StringBuilder sql = new StringBuilder("SELECT * FROM SC_PARTNER_CUSTOMER_INFO ");
		queryChooseCusIf(params, sql);
		sql.append(" ORDER BY CUSTOMER_STATE DESC,CREATE_TIME DESC");
		return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
	}
	@Override
	public PageInfo queryChoosePersonData(PageInfo pageInfo,
			Map<String, String> params) {
		String cusName=ConvertUtil.obj2StrBlank(params.get("cusName"));
		String customer_name=ConvertUtil.obj2StrBlank(params.get("customer_name"));
		StringBuilder sql = new StringBuilder("SELECT A.*,B.CUSTOMER_NAME FROM customer_contacts A,SC_PARTNER_CUSTOMER_INFO B where A.STATE=1 and A.ALLOW_LOGIN=1 AND A.CUSTOMER_ID=B.ID");
		if(StringUtil.notEmpty(cusName)){
			sql.append(" AND A.CONTACT_NAME like :cusName");
			params.put("cusName", "%"+cusName+"%");
		}
		if(StringUtil.notEmpty(customer_name)){
			sql.append(" AND B.CUSTOMER_NAME like :customer_name");
			params.put("customer_name", "%"+customer_name+"%");
		}
//		queryChooseCusIf(params, sql);
		return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
	}
	private void queryChooseCusIf(Map<String, String> params, StringBuilder sql) {
		sql.append(" WHERE 1=1 AND CUSTOMER_STATE=1 ");
		
		//客户名称
		if(StringUtil.notEmpty(String.valueOf(params.get("cusName")))){
			sql.append(" AND CUSTOMER_NAME LIKE :cusName");
			String cusName = AjaxUtil.decode(params.get("cusName"));
			params.put("cusName", "%"+cusName+"%");
		}
		//去掉已选择的用户
		/*if(StringUtil.notEmpty(params.get("ids"))){
        	String knowid[] = params.get("ids").split(",");
        	String para="";
        	for(int i=0;i<knowid.length;i++){
		        if(i<knowid.length-1){
					para+=knowid[i]+"','";
				}else if(i==knowid.length-1){
					para+=knowid[i];
				}
        	}
			sql.append(" AND ID NOT IN ('"+para+"')");
		}*/
		
	}
	@Override
	public List<Map> querySelectCus(String ids) {
		if(StringUtil.notEmpty(ids)){
			StringBuffer sql = new StringBuffer("SELECT * FROM CUSTOMER_CONTACTS");
        	String knowid[] = ids.split(",");
        	String para="";
        	for(int i=0;i<knowid.length;i++){
		        if(i<knowid.length-1){
					para+=knowid[i]+"','";
				}else if(i==knowid.length-1){
					para+=knowid[i];
				}
        	}
			sql.append(" WHERE ID IN ('"+para+"')");
			return baseDao.queryForList(sql.toString());
		
		}else{
			return null;
		}
	}
		
	

	@Override
	public Map getKnowMsgById(String id) {
		Map knowMap = new KM_LIBRARY(id).getBeanMapById();
		List<Map> knowList = baseDao.queryForList("SELECT B.* FROM KM_LIBRARY_KNOWLEDGE A,KM_LIBRARY B WHERE A.LIBRARY_ID = :business_id AND A.KNOWLEDGE_ID = B.ID", new SqlParameter("business_id",id));
		knowMap.put("knowList", knowList);
		//用户可见权限 用户
		List<Map> cusList = baseDao.queryForList("SELECT * FROM KM_LIBRARY_KNOWLEDGE_ACCESS WHERE KNOWLEDGE_ID = :id", new SqlParameter().addValue("id", knowMap.get("ID")));
		String cusIdStr = new String();
		String cusListStr = new String();
		if(cusList.size() > 0){
			for (Map map : cusList) {
				cusIdStr += map.get("CUSTOMER_ID") + ",";
				cusListStr += map.get("CUSTOMER_NAME") + ",";
			}
			knowMap.put("cusIdStr", cusIdStr.substring(0, cusIdStr.length()-1));
			knowMap.put("cusListStr", cusListStr.substring(0, cusListStr.length()-1));
		}else{
			knowMap.put("cusIdStr", cusIdStr);
			knowMap.put("cusListStr", cusListStr);
		}
		//文件
		List<Map> fileList = fileService.getFileList(ConvertUtil.obj2StrBlank(knowMap.get("FILE_ID")));
		knowMap.put("fileList", fileList);
		for(Map map:fileList){
			map.put("ID", "");
		}
		knowMap.put("fileList", fileList);
		return knowMap;
	}
	
	@Override
	public Map getKnowMsgByOrderId(HttpServletRequest request) {
		String orderId = request.getParameter("changeId");
		String bustype = request.getParameter("bustype");
		Map knowmsg = new HashMap();
		Map ordermsg = new HashMap();
		Map param = new HashMap();
		param.put("orderId", orderId);
		if(!StringUtil.isEmpty(bustype)&&!StringUtil.isEmpty(orderId)){
			if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT == ConvertUtil.obj2Int(bustype)){
				knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_INCIDENT A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
				knowmsg.put("CONTENT", "解决方案：</br>"+knowmsg.get("RESOLVE")+"</br>优化建议：</br>"+knowmsg.get("SUGGEST"));
			}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_QUESTION == ConvertUtil.obj2Int(bustype)){
				knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_QUESTION A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
				knowmsg.put("CONTENT", "根本原因：</br>"+knowmsg.get("TRUE_REASON")+"</br>解决方案：</br>"+knowmsg.get("RESOLVE")+"</br>优化建议：</br>"+knowmsg.get("SUGGEST"));
			}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT_LOCAL == ConvertUtil.obj2Int(bustype)){
				knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_INCIDENT_LOCAL A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
				knowmsg.put("CONTENT", "解决方案：</br>"+knowmsg.get("RESOLVE")+"</br>优化建议：</br>"+knowmsg.get("SUGGEST"));
			}
			List<Map> filelist = fileService.getFileList(ConvertUtil.obj2StrBlank(knowmsg.get("FILE_ID")));
			for(Map file:filelist){
				file.put("ID", "");
			}
			knowmsg.put("filelist", filelist);
		}
		return knowmsg;
	}

	@Override
	public Map getDefaultSpMap() {
		String sql = "SELECT AUDITOR_ID,AUDITOR_NAME,ROLE_ID FROM KM_AUDITOR_SET";
		return baseDao.queryForMap(sql);
	}

	@Override
	public Integer saveDefaultSp(Map<String, String> params) {
		String sql = new String("DELETE FROM KM_AUDITOR_SET");
		baseDao.execute(sql, params);
		params.put("id", StringUtil.getUUID());
		if(!StringUtil.isEmpty(params.get("checkbox"))){
			String[] user = params.get("checkbox").split("-");
			if(user.length == 2){
				params.put("role_id", user[0]);
				params.put("auditor_id", user[1]);
			}
		}
		
		sql = new String("INSERT INTO KM_AUDITOR_SET VALUES(:id,:auditor_id,:checkboxName,:role_id)");
		return baseDao.execute(sql, params);
	}

	@Override
	public Map getSpMap(String id) {
		String sql = "SELECT AUDITOR_ID,AUDITOR_NAME,ROLE_ID FROM KM_LIBRARY_CATEGORY WHERE ID = :id";
		return baseDao.queryForMap(sql,new SqlParameter("id",id));
	}

	@Override
	public Integer saveSp(Map<String, String> params) {
		if(!StringUtil.isEmpty(params.get("checkbox"))){
			String[] user = params.get("checkbox").split("-");
			if(user.length == 2){
				params.put("role_id", user[0]);
				params.put("auditor_id", user[1]);
			}
		}
		String sql = new String("UPDATE KM_LIBRARY_CATEGORY SET AUDITOR_ID = :auditor_id, AUDITOR_NAME = :checkboxName,ROLE_ID = :role_id WHERE ID = :id");
		return baseDao.execute(sql, params);
	}

	

}