package cn.ksource.web.facade.impl;

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.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.JsonUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.TreeNode;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.facade.BmglFacade;
import cn.ksource.web.service.ZzjgService;

@Service("bmglFacade")
public class BmglFacadeImpl implements BmglFacade {

	@Autowired
	private BaseDao baseDao;
	
	@Autowired
	private ZzjgService zzjgService;

	@Override
	public TreeNode getBmTree() {
		return zzjgService.getZzjgTree();
	}
	/**
	 * 根据id得到某些部门
	 * @param ids
	 * @return
	 */
	public List getDeptList(String ids){
		return zzjgService.getDeptList(ids);
	}
	
	@Override
	public List<Map> queryBmYjList(HttpServletRequest request) {
		
		Map paramMap = new HashMap();
		String selectSubSql = "SELECT * FROM GG_ZZJG WHERE ZT=1 ORDER BY CENGJ,SXH ";
		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>();
		Map<String, Map> ejgnCache = new HashMap<String, Map>();
		Map<String, Map> sjgnCache = new HashMap<String, Map>();
		
		for (Map map : cates) {
			String level = map.get("CENGJ").toString();
			String id = map.get("ID").toString();
			
			//一级树
			if (level.equalsIgnoreCase("1")) {
				yjgnCache.put(id, map);
				List<Map> ejgnList = new LinkedList<Map>();
				map.put("ejTree", ejgnList);
				resultList.add(map);
				continue;
			}
			//二级树
			if (level.equalsIgnoreCase("2")) {
				String pId = map.get("SJBH").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);
					
					ejgnCache.put(id, map);
				}
				continue;
			}
			//三级树
			if (level.equalsIgnoreCase("3")) {
				if(null!=map.get("SJBH")){
					String pId = map.get("SJBH").toString();
					if(ejgnCache.containsKey(pId)) {
						Map ejgnMap = ejgnCache.get(map.get("SJBH").toString());
						List<Map> list = (List<Map>)ejgnMap.get("sjTree");
						map.put("fjTree", new LinkedList<Map>());
						list.add(map);
						sjgnCache.put(id, map);
					}
				}
			}
		}
		System.out.println(JsonUtil.list2Json(resultList));
		return resultList;
	}
	
	@Override
	public List<Map> bmData(HttpServletRequest request) {
		Map paramMap = new HashMap();
		String pId = request.getParameter("pId");
		StringBuilder builder = new StringBuilder(" SELECT * FROM GG_ZZJG WHERE 1=1 ");
		if(StringUtil.notEmpty(pId)) {
			builder.append(" AND SJBH = :pId ");
			paramMap.put("pId", pId);
		} else {
			builder.append(" AND SJBH IS NULL ");
		}
		
		builder.append(" ORDER BY SXH");
		
		List<Map> bms = baseDao.queryForList(builder.toString(),paramMap);
		return bms;
	}
	
	@Override
	public TreeNode getBmTree(HttpServletRequest request) {
        TreeNode root = new TreeNode("0","部门管理");
		
		String sql = "select * from gg_zzjg where ZT=1 order by CENGJ asc,sxh asc";
		List<Map> xtgnList = baseDao.queryForList(sql);
		Map<String, TreeNode> yjgnCache = new HashMap<String, TreeNode>();
		Map<String, TreeNode> ejgnCache = new HashMap<String, TreeNode>();
		Map<String, TreeNode> sjgnCache = new HashMap<String, TreeNode>();
		
		for (Map map : xtgnList) {
			//一级功能
			if (map.get("CENGJ").toString().equalsIgnoreCase("1")) {
				TreeNode yjTree = new TreeNode(map.get("ID").toString(),map.get("JGMC").toString());
				root.addChild(yjTree);
				yjgnCache.put(ConvertUtil.obj2Str(map.get("ID")), yjTree);
				continue;
			}
			
			
		}
		return root;
	}
	@Override
	public String getBmNameById(String bmId) {
		String sql = new String("SELECT JGMC FROM GG_ZZJG WHERE ID = :bmId");
		return baseDao.queryForString(sql,new SqlParameter("bmId",bmId));
	}
	
	public List<Map> getBmtree() {
		String sql="SELECT * FROM GG_ZZJG WHERE ZT=1 ORDER BY CENGJ,SXH";
		
		List<Map> categoryList = baseDao.queryForList(sql);
		
		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) {
			String level = map.get("CENGJ").toString();
			
			//一级树
			if (level.equalsIgnoreCase("1")) {
				yjgnCache.put(map.get("ID").toString(), map);
				List<Map> ejgnList = new LinkedList<Map>();
				map.put("ejTree", ejgnList);
				resultList.add(map);
				continue;
			}
			//二级树
			if (level.equalsIgnoreCase("2")) {
				Map yjgnMap = yjgnCache.get(map.get("SJBH").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 (level.equalsIgnoreCase("3")) {
				if(null!=map.get("SJBH")){
					Map ejgnMap = ejgnCache.get(map.get("SJBH").toString());
					List<Map> list = (List<Map>)ejgnMap.get("sjTree");
					list.add(map);
				}
			}
		}
		return resultList;
	}
	
}