package cn.ksource.web.service.impl;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.web.TreeNode;
import cn.ksource.web.service.ZzjgService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service("zzjgService")
public class ZzjgServiceImpl implements ZzjgService {

	@Autowired
	private BaseDao baseDao;
	
	/**
	 * 根据id得到某些部门
	 * @param ids
	 * @return
	 */
	public List getDeptList(String ids){
		String sql="SELECT ID,JGMC FROM GG_ZZJG WHERE ID IN("+ids+")";
		return baseDao.queryForList(sql);
	}
	/**
	 * 根据id得到部门
	 * @param id
	 * @return
	 */
	public Map getById(String id){
		String sql="SELECT * FROM GG_ZZJG WHERE ID=:id";
		Map m=new HashMap();
		m.put("id", id);
		return baseDao.queryForMap(sql,m);
	}
	@Override
	public TreeNode getZzjgTree() {
		
		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, new SqlParameter());
		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;
			}
			if (map.get("CENGJ").toString().equalsIgnoreCase("2")) {
				TreeNode ejTree = new TreeNode(map.get("ID").toString(),map.get("JGMC").toString());
				   
				yjgnCache.get(ConvertUtil.obj2Str(map.get("SJBH"))).addChild(ejTree);
				ejgnCache.put(ConvertUtil.obj2Str(map.get("ID")), ejTree);
				continue;
			}
			if (map.get("CENGJ").toString().equalsIgnoreCase("3")) {
				TreeNode sjTree = new TreeNode(map.get("ID").toString(),map.get("JGMC").toString());
				ejgnCache.get(ConvertUtil.obj2Str(map.get("SJBH"))).addChild(sjTree);
				sjgnCache.put(map.get("ID").toString(), sjTree);
			}
			/*if (map.get("CENGJ").toString().equalsIgnoreCase("4")) {  
				TreeNode sijTree = new TreeNode(map.get("ID").toString(),map.get("JGMC").toString());
				sjgnCache.get(ConvertUtil.obj2Str(map.get("SJBH"))).addChild(sijTree);
			}*/
		}
		return root;
	}
}