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;
|
}
|
}
|