package cn.ksource.web.facade.cfgcate;
|
|
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.StringUtil;
|
import cn.ksource.core.util.TreeUtil;
|
import cn.ksource.web.Constants;
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.*;
|
|
@Service
|
@SuppressWarnings({"rawtypes","unchecked"})
|
public class CfgcateFacadeImpl implements CfgcateFacade{
|
@Resource
|
private BaseDao baseDao;
|
|
@Override
|
public List getCfgcateTree(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select id,type,lv,name,code,pid from cmdb_ci_category where state = 1 and cate_type=:cateType "
|
+ " order by lv asc,serial asc,name ");
|
List list = baseDao.queryForList(sql.toString(),params);
|
List<Map> tlist = TreeUtil.createTreeByList(list);
|
return tlist;
|
}
|
|
@Override
|
public PageInfo getCfgcateData(PageInfo pageInfo,Map<String, String> params) {
|
Map support = getCfgcateSupport(params);
|
String sql = support.get("sql").toString();
|
return baseDao.queryforSplitPageInfo(pageInfo, sql, params);
|
}
|
|
@Override
|
public Integer getCfgcateCount(Map<String, String> params) {
|
Map support = getCfgcateSupport(params);
|
String sql = "select count(*) from ( " + support.get("sql").toString() + " ) t ";
|
return baseDao.queryForInteger(sql, params);
|
}
|
|
private Map getCfgcateSupport(Map<String, String> params){
|
Map<String, Object> support = new HashMap<String, Object>();
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select a.* ");
|
sql.append(" from cmdb_ci_category a ");
|
sql.append(" where 1=1 ");
|
if(StringUtil.isNotBlank(params.get("pid"))){
|
sql.append(" and a.pid=:pid ");
|
}
|
if(StringUtil.isNotBlank(params.get("cateType"))){
|
sql.append(" and a.CATE_TYPE=:cateType ");
|
}
|
sql.append(" order by a.lv asc,a.serial asc ");
|
support.put("sql", sql.toString());
|
support.put("param", params);
|
return support;
|
}
|
|
@Override
|
public Map getCfgcateById(String id) {
|
return baseDao.queryForMap("select * from cmdb_ci_category where id=:id ",new SqlParameter("id",id));
|
}
|
|
@Override
|
public Map saveCfgcate(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder();
|
if(StringUtil.isBlank(params.get("id"))){//新增
|
params.put("id", StringUtil.getUUID());
|
String lv1_id = "";
|
String lv1_name = "";
|
String lv2_id = "";
|
String lv2_name = "";
|
String lv3_id = "";
|
String lv3_name = "";
|
String full_id = "";
|
String full_name = "";
|
if(params.get("lv").equals("1")){//一级
|
lv1_id = params.get("id");
|
lv1_name = params.get("name");
|
full_id = lv1_id;
|
full_name = lv1_name;
|
}else{
|
Map pcate = getCfgcateById(params.get("pid"));
|
lv1_id = pcate.get("lv1_id").toString();
|
lv1_name = pcate.get("lv1_name").toString();
|
if(params.get("lv").equals("2")){//二级
|
lv2_id = params.get("id");
|
lv2_name = params.get("name");
|
full_id = lv1_id + "-" + lv2_id;
|
full_name = lv1_name + "-" + lv2_name;
|
}else if(params.get("lv").equals("3")){//三级
|
lv2_id = pcate.get("lv2_id").toString();
|
lv2_name = pcate.get("lv2_name").toString();
|
lv3_id = params.get("id");
|
lv3_name = params.get("name");
|
full_id = lv1_id + "-" + lv2_id + "-" + lv3_id ;
|
full_name = lv1_name + "-" + lv2_name + "-" + lv3_name;
|
}
|
}
|
params.put("lv1_id", lv1_id);
|
params.put("lv1_name", lv1_name);
|
params.put("lv2_id", lv2_id);
|
params.put("lv2_name", lv2_name);
|
params.put("lv3_id", lv3_id);
|
params.put("lv3_name", lv3_name);
|
params.put("full_id", full_id);
|
params.put("full_name", full_name);
|
|
sql.append("insert into cmdb_ci_category "
|
+ " (id,pid,type,name,code,lv,serial,note,state,lv1_id,lv1_name,lv2_id,lv2_name,lv3_id,lv3_name,full_id,full_name,cate_type) values "
|
+ " (:id,:pid,1,:name,:code,:lv,:serial,:note,1,:lv1_id,:lv1_name,:lv2_id,:lv2_name,:lv3_id,:lv3_name,:full_id,:full_name,:cateType) ");
|
baseDao.execute(sql.toString(), params);
|
}else{//修改
|
String colId = "";
|
String colName = "";
|
if(params.get("lv").equals("1")){
|
colId = "lv1_id";
|
colName = "lv1_name";
|
}else if(params.get("lv").equals("2")){
|
colId = "lv2_id";
|
colName = "lv2_name";
|
}else if(params.get("lv").equals("3")){
|
colId = "lv3_id";
|
colName = "lv3_name";
|
}
|
//更新本记录
|
sql.append(" update cmdb_ci_category set name=:name,serial=:serial,note=:note,cate_type=:cateType "
|
+ " where id=:id ");
|
baseDao.execute(sql.toString(), params);
|
//更新子记录
|
sql.setLength(0);
|
sql.append(" update cmdb_ci_category set "+colName+"=:name "
|
+ " where "+colId+"=:id ");
|
baseDao.execute(sql.toString(), params);
|
|
//更新一级全名称
|
if(params.get("lv").equals("1")){
|
sql.setLength(0);
|
sql.append(" update cmdb_ci_category set full_name = lv1_name "
|
+ " where "+colId+"=:id and lv=1 ");
|
baseDao.execute(sql.toString(), params);
|
}
|
|
sql.setLength(0);
|
sql.append(" update cmdb_ci_category set full_name = concat(lv1_name,'-',lv2_name) "
|
+ " where "+colId+"=:id and lv=2 ");
|
baseDao.execute(sql.toString(), params);
|
|
//更新三级全名称
|
sql.setLength(0);
|
sql.append(" update cmdb_ci_category set full_name = concat(lv1_name,'-',lv2_name,'-',lv3_name) "
|
+ " where "+colId+"=:id and lv=3 ");
|
baseDao.execute(sql.toString(), params);
|
}
|
|
//树回显
|
Map echo = new HashMap();
|
String lv1Id = "";
|
String lv2Id = "";
|
if(!params.get("lv").equals("1")){
|
Map pMap = baseDao.queryForMap("select * from cmdb_ci_category where id=:pid ",params);
|
if(ConvertUtil.obj2StrBlank(pMap.get("pid")).equals("0")){//父节点为一级
|
lv1Id = pMap.get("id").toString();
|
lv2Id = params.get("id");
|
}else{//父节点为二级
|
lv1Id = pMap.get("pid").toString();
|
lv2Id = pMap.get("id").toString();
|
}
|
}
|
echo.put("lv1Id", lv1Id);
|
echo.put("lv2Id", lv2Id);
|
return echo;
|
}
|
|
@Override
|
public int checkCateName(String name, String id) {
|
StringBuffer sql=new StringBuffer(" select count(*) from cmdb_ci_category where name= :name ");
|
if (StringUtils.isNotBlank(id)) {
|
sql.append(" and id <> :id");
|
}
|
SqlParameter param = new SqlParameter();
|
param.addValue("name", name);
|
param.addValue("id", id);
|
int count=baseDao.queryForInteger(sql.toString(),param);
|
return count;
|
}
|
|
@Override
|
public int checkCateCode(String code, String id, String lv) {
|
StringBuffer sql=new StringBuffer(" select count(*) from cmdb_ci_category where code= :code and lv=:lv ");
|
if (StringUtils.isNotBlank(id)) {
|
sql.append(" and id <> :id");
|
}
|
SqlParameter param = new SqlParameter();
|
param.addValue("code", code);
|
param.addValue("id", id);
|
param.addValue("lv", lv);
|
int count=baseDao.queryForInteger(sql.toString(),param);
|
return count;
|
}
|
|
@Override
|
public PageInfo getCateGroupData(PageInfo pageInfo, Map<String, String> params) {
|
Map support = getCateGroupSupport(params);
|
String sql = support.get("sql").toString();
|
return baseDao.queryforSplitPageInfo(pageInfo, sql, params);
|
}
|
|
@Override
|
public Integer getCateGroupCount(Map<String, String> params) {
|
Map support = getCateGroupSupport(params);
|
String sql = "select count(*) from ( " + support.get("sql").toString() + " ) t ";
|
return baseDao.queryForInteger(sql, params);
|
}
|
|
private Map getCateGroupSupport(Map<String, String> params){
|
Map<String, Object> support = new HashMap<String, Object>();
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select a.* ");
|
sql.append(" from prop_group a ");
|
sql.append(" where link_id=:linkId ");
|
sql.append(" order by a.serial asc ");
|
support.put("sql", sql.toString());
|
support.put("param", params);
|
return support;
|
}
|
|
@Override
|
public Map getGroupById(String id) {
|
return baseDao.queryForMap("select * from prop_group where id=:id ",new SqlParameter("id",id));
|
}
|
|
@Override
|
public void saveGroup(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder();
|
if(StringUtil.isBlank(params.get("id"))){//新增
|
params.put("id", StringUtil.getUUID());
|
sql.append("insert into prop_group (id,group_name,serial,note,state,link_id) values "
|
+ " (:id,:group_name,:serial,:note,1,:linkId) ");
|
}else{//修改
|
sql.append(" update prop_group set group_name=:group_name,serial=:serial,note=:note "
|
+ " where id=:id ");
|
}
|
baseDao.execute(sql.toString(), params);
|
}
|
|
@Override
|
public int checkGroupName(String id, String group_name, String linkId) {
|
String sql = " select count(*) from prop_group "
|
+ " where group_name=:group_name and link_id=:linkId and id<>:id ";
|
SqlParameter param = new SqlParameter();
|
param.addValue("group_name", group_name);
|
param.addValue("linkId", linkId);
|
param.addValue("id", id);
|
return baseDao.queryForInteger(sql, param);
|
}
|
|
@Override
|
public void delGroup(Map params) {
|
baseDao.execute("update prop_group set state=:flag where id=:id ", params);
|
}
|
|
@Override
|
public List<Map> getGroupListByLinkId(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select * from prop_group where link_id = :linkId and state=1 ");
|
return baseDao.queryForList(sql.toString(),params);
|
}
|
|
@Override
|
public PageInfo getPropData(PageInfo pageInfo, Map<String, String> params) {
|
Map support = getPropSupport(params);
|
String sql = support.get("sql").toString();
|
return baseDao.queryforSplitPageInfo(pageInfo, sql, params);
|
}
|
|
@Override
|
public Integer getPropCount(Map<String, String> params) {
|
Map support = getPropSupport(params);
|
String sql = "select count(*) from ( " + support.get("sql").toString() + " ) t ";
|
return baseDao.queryForInteger(sql, params);
|
}
|
|
private Map getPropSupport(Map<String, String> params){
|
Map<String, Object> support = new HashMap<String, Object>();
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select a.* ");
|
sql.append(" from prop_column a ");
|
sql.append(" where 1=1 ");
|
if(StringUtil.isNotBlank(params.get("linkId"))){
|
sql.append(" and a.group_id in ( select id from prop_group where link_id=:linkId ) ");
|
}
|
if(StringUtil.isNotBlank(params.get("groupId"))){
|
sql.append(" and a.group_id =:groupId ");
|
}
|
sql.append(" order by a.serial asc ");
|
support.put("sql", sql.toString());
|
support.put("param", params);
|
return support;
|
}
|
|
@Override
|
public Map getPropById(String id) {
|
return baseDao.queryForMap("select * from prop_column where id=:id ",new SqlParameter("id",id));
|
}
|
|
@Override
|
public int checkPropCode(String id, String groupId, String columncode) {
|
StringBuffer sql=new StringBuffer(" select count(*) from prop_column where columncode= :columncode and group_id=:groupId ");
|
if (StringUtils.isNotBlank(id)) {
|
sql.append(" and id <> :id");
|
}
|
SqlParameter param = new SqlParameter();
|
param.addValue("columncode", columncode);
|
param.addValue("id", id);
|
param.addValue("groupId", groupId);
|
int count=baseDao.queryForInteger(sql.toString(),param);
|
return count;
|
}
|
|
@Override
|
public void saveProp(Map<String, String> params) {
|
if(StringUtil.isBlank(params.get("id"))){//新增
|
params.put("id", StringUtil.getUUID());
|
baseDao.execute(getPropInsertSql(params), params);
|
}else{//更新
|
baseDao.execute(getPropUpdateSql(params), params);
|
}
|
}
|
|
private String getPropInsertSql(Map<String, String> params){
|
StringBuilder sql = new StringBuilder();
|
StringBuilder frontsql = new StringBuilder();
|
StringBuilder endsql = new StringBuilder();
|
if(params.get("id")!=null){
|
frontsql.append("id,");
|
endsql.append(":id,");
|
}
|
if(params.get("group_id")!=null){
|
frontsql.append("group_id,");
|
endsql.append(":group_id,");
|
}
|
if(params.get("columnname")!=null){
|
frontsql.append("columnname,");
|
endsql.append(":columnname,");
|
}
|
if(params.get("columncode")!=null){
|
frontsql.append("columncode,");
|
endsql.append(":columncode,");
|
}
|
if(params.get("datatype")!=null){
|
frontsql.append("datatype,");
|
endsql.append(":datatype,");
|
}
|
if(params.get("allownull")!=null){
|
frontsql.append("allownull,");
|
endsql.append(":allownull,");
|
}
|
if(params.get("minvalues")!=null){
|
frontsql.append("minvalues,");
|
endsql.append(":minvalues,");
|
}
|
if(params.get("maxvalues")!=null){
|
frontsql.append("maxvalues,");
|
endsql.append(":maxvalues,");
|
}
|
if(params.get("default_ext")!=null){
|
frontsql.append("default_ext,");
|
endsql.append(":default_ext,");
|
}
|
if(params.get("default_val")!=null){
|
frontsql.append("default_val,");
|
endsql.append(":default_val,");
|
}
|
if(params.get("showinlist")!=null){
|
frontsql.append("showinlist,");
|
endsql.append(":showinlist,");
|
}
|
if(params.get("allowquery")!=null){
|
frontsql.append("allowquery,");
|
endsql.append(":allowquery,");
|
}
|
if(params.get("inputtype")!=null){
|
frontsql.append("inputtype,");
|
endsql.append(":inputtype,");
|
}
|
if(params.get("state")!=null){
|
frontsql.append("state,");
|
endsql.append(":state,");
|
}
|
if(params.get("createtime")!=null){
|
frontsql.append("createtime,");
|
endsql.append(":createtime,");
|
}
|
if(params.get("note")!=null){
|
frontsql.append("note,");
|
endsql.append(":note,");
|
}
|
if(params.get("serial")!=null){
|
frontsql.append("serial,");
|
endsql.append(":serial,");
|
}
|
if(params.get("alert")!=null){
|
frontsql.append("alert,");
|
endsql.append(":alert,");
|
}
|
sql.append(" insert into prop_column ( ");
|
sql.append(StringUtils.removeEnd(frontsql.toString(),","));
|
sql.append(" ) values ( ");
|
sql.append(StringUtils.removeEnd(endsql.toString(),","));
|
sql.append(" ) ");
|
return sql.toString();
|
}
|
|
private String getPropUpdateSql(Map<String, String> params){
|
StringBuilder sql = new StringBuilder();
|
StringBuilder frontsql = new StringBuilder();
|
if(params.get("id")!=null){
|
frontsql.append("id=:id,");
|
}
|
if(params.get("columnname")!=null){
|
frontsql.append("columnname=:columnname,");
|
}
|
if(params.get("columncode")!=null){
|
frontsql.append("columncode=:columncode,");
|
}
|
if(params.get("datatype")!=null){
|
frontsql.append("datatype=:datatype,");
|
}
|
if(params.get("allownull")!=null){
|
frontsql.append("allownull=:allownull,");
|
}
|
if(params.get("minvalues")!=null){
|
frontsql.append("minvalues=:minvalues,");
|
}
|
if(params.get("maxvalues")!=null){
|
frontsql.append("maxvalues=:maxvalues,");
|
}
|
if(params.get("default_ext")!=null){
|
frontsql.append("default_ext=:default_ext,");
|
}
|
if(params.get("default_val")!=null){
|
frontsql.append("default_val=:default_val,");
|
}
|
if(params.get("showinlist")!=null){
|
frontsql.append("showinlist=:showinlist,");
|
}
|
if(params.get("allowquery")!=null){
|
frontsql.append("allowquery=:allowquery,");
|
}
|
if(params.get("inputtype")!=null){
|
frontsql.append("inputtype=:inputtype,");
|
}
|
if(params.get("state")!=null){
|
frontsql.append("state=:state,");
|
}
|
if(params.get("note")!=null){
|
frontsql.append("note=:note,");
|
}
|
if(params.get("serial")!=null){
|
frontsql.append("serial=:serial,");
|
}
|
if(params.get("alert")!=null){
|
frontsql.append("alert=:alert,");
|
}
|
sql.append(" update prop_column set ");
|
sql.append(StringUtils.removeEnd(frontsql.toString(),","));
|
sql.append(" where id= :id ");
|
return sql.toString();
|
}
|
|
@Override
|
public void delProp(Map params) {
|
baseDao.execute("update prop_column set state=:flag where id=:id ", params);
|
}
|
|
@Override
|
public PageInfo getPropSelData(PageInfo pageInfo, Map<String, String> params) {
|
Map support = getPropSelSupport(params);
|
String sql = support.get("sql").toString();
|
return baseDao.queryforSplitPageInfo(pageInfo, sql, params);
|
}
|
|
@Override
|
public Integer getPropSelCount(Map<String, String> params) {
|
Map support = getPropSelSupport(params);
|
String sql = "select count(*) from ( " + support.get("sql").toString() + " ) t ";
|
return baseDao.queryForInteger(sql, params);
|
}
|
|
private Map getPropSelSupport(Map<String, String> params){
|
Map<String, Object> support = new HashMap<String, Object>();
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select a.* ");
|
sql.append(" from prop_sel a ");
|
sql.append(" where a.column_id=:colId ");
|
sql.append(" order by a.serial asc ");
|
support.put("sql", sql.toString());
|
support.put("param", params);
|
return support;
|
}
|
|
@Override
|
public Map getPropSelById(String id) {
|
return baseDao.queryForMap(" select * from prop_sel where id=:id ",new SqlParameter("id",id));
|
}
|
|
@Override
|
public void savePropSel(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder();
|
if(StringUtil.isBlank(params.get("id"))){//新增
|
params.put("id", StringUtil.getUUID());
|
sql.append("insert into prop_sel (id,column_id,itemvalue,serial,state) values "
|
+ " (:id,:column_id,:itemvalue,:serial,1) ");
|
}else{//修改
|
sql.append(" update prop_sel set itemvalue=:itemvalue,serial=:serial "
|
+ " where id=:id ");
|
}
|
baseDao.execute(sql.toString(), params);
|
}
|
|
@Override
|
public void delPropSel(Map params) {
|
baseDao.execute("update prop_sel set state=:flag where id=:id ", params);
|
}
|
|
@Override
|
public void setSelDef(String sid, String sval, String pid) {
|
StringBuilder sql = new StringBuilder();
|
sql.append(" update prop_column set default_ext=:sval,default_val=:sid where id=:pid ");
|
SqlParameter param = new SqlParameter().addValue("sid", sid)
|
.addValue("sval", sval)
|
.addValue("pid", pid);
|
baseDao.execute(sql.toString(), param);
|
sql.setLength(0);
|
sql.append("update prop_sel set is_default = 0 where column_id = :pid");
|
baseDao.execute(sql.toString(), param);
|
|
List<SqlParameter> params = new ArrayList<SqlParameter>();
|
String[] arr = sid.split(",");
|
for(int i=0;i<arr.length;i++){
|
SqlParameter p = new SqlParameter();
|
p.addValue("sid", arr[i]);
|
params.add(p);
|
}
|
baseDao.executeBatch(" update prop_sel set is_default=1 where id = :sid ", params);
|
}
|
|
@Override
|
public List<Map> getPropTemplate(String linkId ,String busId) {
|
StringBuilder sql = new StringBuilder();
|
Map propSet = new HashMap();
|
if(StringUtil.isNotBlank(busId)){
|
sql.append(" select * from prop_data where bus_id=:busId ");
|
List<Map> propList = baseDao.queryForList(sql.toString(),new SqlParameter("busId",busId));
|
if(propList!=null&&propList.size()>0){
|
for(Map p:propList){
|
propSet.put(p.get("column_id"), p);
|
}
|
}
|
sql.setLength(0);
|
}
|
|
SqlParameter param = new SqlParameter();
|
param.addValue("linkId", linkId);
|
Map cate = baseDao.queryForMap("select lv,pid from cmdb_ci_category where id = :linkId ",param);
|
String lv = ConvertUtil.obj2StrBlank(cate.get("lv"));
|
String pid = ConvertUtil.obj2StrBlank(cate.get("pid"));
|
param.addValue("pid", pid);
|
List<Map> list = new ArrayList<Map>();
|
|
sql.append(" select g.serial gserial,g.id gid,g.group_name,p.id pid,p.* from ( ");
|
sql.append(" select g.id,g.group_name,g.serial from prop_group g,cmdb_ci_category c where g.link_id=c.id and c.state=1 ");
|
if(lv.equals("3")){
|
sql.append(" and (c.id = :linkId or c.id = :pid||'') ");
|
}else{
|
sql.append(" and c.id = :linkId ");
|
}
|
sql.append(" union select '-1' as id,'通用属性' as group_name,0 as serial from prop_group g ");
|
sql.append(" ) g ,prop_column p ");
|
sql.append(" where g.id = p.group_id and p.state=1 order by gid,p.serial desc ");
|
//查出所有的通用属性和分组属性
|
List<Map> glist = baseDao.queryForList(sql.toString(),param);
|
sql.setLength(0);
|
sql.append(" select * from prop_sel where state=1 and column_id = :pid ");
|
if (glist != null && glist.size() > 0) {
|
Stack<Map> stack = new Stack<Map>();
|
for (int i = 0; i <= glist.size(); i++) {
|
if (i != glist.size()) {
|
int datatype = ConvertUtil.obj2Int(glist.get(i).get("DATATYPE"));
|
if (datatype == Constants.PROP_TYPE_SEL
|
|| datatype == Constants.YSY_TYPE_MULTI_SEL) {
|
List sList = baseDao.queryForList(sql.toString(), new SqlParameter("pid", glist.get(i).get("pid")));
|
//如果该通用属性 选项为空 然后又不允许为空
|
if (sList.size() == 0 && ConvertUtil.obj2Int(glist.get(i).get("ALLOWNULL")) == 2) {
|
//type等1的时候，该属性不显示
|
glist.get(i).put("notShow", 1);
|
} else {
|
glist.get(i).put("items", sList);
|
}
|
}
|
}
|
//如果stack为空
|
if(stack.isEmpty()){
|
//放入stack中
|
stack.push(glist.get(i));
|
//不为空
|
}else{
|
//最后一个或最上面的map的gid不等于当前属性的gid
|
if(i==glist.size()||!stack.peek().get("gid").toString().equals(glist.get(i).get("gid").toString())){
|
Map temp = stack.peek();
|
List plist = new ArrayList();
|
while(!stack.isEmpty()){
|
Map p = stack.pop();
|
if(!propSet.isEmpty()){
|
if(propSet.containsKey(p.get("pid").toString())){
|
Map prop = (Map)propSet.get(p.get("pid").toString());
|
String def_val = ConvertUtil.obj2StrBlank(prop.get("column_value"));
|
String def_text = ConvertUtil.obj2StrBlank(prop.get("column_text"));
|
p.put("default_val", def_val);
|
p.put("default_ext", def_text);
|
}
|
}
|
if (p.get("notShow")==null) {
|
plist.add(p);
|
}
|
}
|
temp.put("props", plist);
|
list.add(temp);
|
}
|
if(i!=glist.size()){
|
stack.push(glist.get(i));
|
}
|
}
|
}
|
}
|
|
// Collections.sort(list, new Comparator<Map>(){
|
// @Override
|
// public int compare(Map o1, Map o2) {
|
// return ConvertUtil.obj2Integer(o1.get("gserial")).compareTo(ConvertUtil.obj2Integer(o2.get("gserial")));
|
// }
|
// });
|
return list;
|
}
|
|
@Override
|
public void delCfgcate(Map params) {
|
baseDao.execute("update cmdb_ci_category set state=:flag where id=:id ", params);
|
}
|
|
@Override
|
public Integer checkDelGroup(Map<String, String> params) {
|
String flag = params.get("flag");
|
Integer res = 0;
|
//如果要禁用操作
|
if(!flag.equals("1")){
|
//判断该分组下的自定义属性是否都被禁用
|
Integer temp = baseDao.queryForInteger("select count(*) from prop_column where group_id=:id and state=1 ",params);
|
if(temp==0){
|
res = 1;
|
}
|
}else{//启用操作
|
//随时可以启动
|
res=1;
|
}
|
return res;
|
}
|
|
@Override
|
public Integer checkCateFlag(Map<String,String> params) {
|
String flag = params.get("flag");
|
String pid = params.get("pid");
|
Integer res = 0;
|
if(flag.equals("0")){//禁用
|
Integer temp = baseDao.queryForInteger("select count(*) from cmdb_ci_category where pid=:id and state=1 ",params);
|
if(temp==0){
|
res = 1;
|
}
|
}else{//启用
|
if(pid.equals("0")){
|
return 1;
|
}else{
|
Integer temp = baseDao.queryForInteger("select count(*) from cmdb_ci_category where id=:pid and state=1 ",params);
|
if(temp>0){
|
res = 1;
|
}
|
}
|
}
|
return res;
|
}
|
|
@Override
|
public List getCfgcateList(Map<String, String> params){
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select id,name from cmdb_ci_category where state=1 and cate_type=1 ");
|
if(StringUtil.isNotBlank(params.get("lv"))){
|
sql.append(" and lv = :lv ");
|
}
|
if(StringUtil.isNotBlank(params.get("pid"))){
|
sql.append(" and pid = :pid ");
|
}
|
return baseDao.queryForList(sql.toString(), params);
|
}
|
}
|
