@SuppressWarnings("unchecked") @Transactional(propagation = Propagation.REQUIRED) public ArrayList<VColumn> getColumn(String type, String selfId) throws ChecksException { SqlExcuterImpl sqlMager = (SqlExcuterImpl) SpringContextUtil.getBean("SqlExcuter"); VUser loginuser = WebContextMaker.getLoginer(WebContextMaker.getRequest()); StringBuffer sqlBuffer = new StringBuffer(); if (loginuser.getId().equals(SystemParms.ROOTID)) { sqlBuffer.append( " select distinct a.* from v_column a where a.leveler = '" + type + "' and a.state = 1 and backHidden = 0 "); } else { sqlBuffer.append( "select distinct a.* from v_column a left join v_power b on (b.dataId=a.id) where a.leveler = '" + type + "' and a.state = 1 and backHidden = 0 "); String aa = getPowerSql(loginuser, 1, 0, 0, 0); if (!Checks.empty(aa)) { sqlBuffer.append(" and ").append(aa); } } if (selfId != null) { sqlBuffer.append(" and a.selfId ='" + selfId + "'"); } sqlBuffer.append(" order by a.backSorter asc"); String theSql = sqlBuffer.toString(); return (ArrayList<VColumn>) sqlMager.sqlQuery(theSql, null, null, "com.fangshuoit.basic.entity", "VColumn", null, 0); }
@SuppressWarnings("unchecked") public void laodPower() throws ChecksException { // TODO Auto-generated method stub SqlExcuterImpl sqlMager = (SqlExcuterImpl) SpringContextUtil.getBean("SqlExcuter"); VUser loginuser = WebContextMaker.getLoginer(WebContextMaker.getRequest()); StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append( "select b.* from v_column a left join v_power b on (b.dataId=a.id) where a.state = 1 and backHidden = 0 "); String aa = getPowerSql(loginuser, 0, 0, 0, 0); if (!Checks.empty(aa)) { sqlBuffer.append(" and ").append(aa); } List<VPower> alist = sqlMager.sqlQuery( sqlBuffer.toString(), null, null, "com.fangshuoit.basic.entity", "VPower", null, 0); // if (alist != null && alist.size() > 0) { if (PowerMap.powerMap.containsKey(loginuser.getId())) { PowerMap.powerMap.remove(loginuser.getId()); } Map<String, Object> userMap = new HashMap<String, Object>(); for (int i = 0; i < alist.size(); i++) { if (!Checks.empty(alist.get(i).getReservation())) { if (alist.get(i).getIfAdd() == 1 && alist.get(i).getIfNotAdd() != 1) { if (!userMap.containsKey(alist.get(i).getReservation() + "add")) { userMap.put(alist.get(i).getReservation() + "add", true); } } if (alist.get(i).getIfEdit() == 1 && alist.get(i).getIfNotEdit() != 1) { if (!userMap.containsKey(alist.get(i).getReservation() + "edit")) { userMap.put(alist.get(i).getReservation() + "edit", true); } } if (alist.get(i).getIfDel() == 1 && alist.get(i).getIfNotDel() != 1) { if (!userMap.containsKey(alist.get(i).getReservation() + "del")) { userMap.put(alist.get(i).getReservation() + "del", true); } } if (alist.get(i).getIfView() == 1 && alist.get(i).getIfNotView() != 1) { if (!userMap.containsKey(alist.get(i).getReservation() + "view")) { userMap.put(alist.get(i).getReservation() + "view", true); } } } } PowerMap.powerMap.put(loginuser.getId(), userMap); } }
public boolean fixGetPower(Object thId, String simpleName) throws ChecksException { StringBuffer sqlBuffer = new StringBuffer(); VUser loginuser = WebContextMaker.getLoginer(WebContextMaker.getRequest()); if (!loginuser.getId().equals(SystemParms.ROOTID)) { sqlBuffer.append( "select b.id from v_power b where power_types = '" + simpleName + "' and data_id ='" + thId + "'"); String aa = getPowerSql(loginuser, 1, 0, 0, 0); if (!Checks.empty(aa)) { sqlBuffer.append(" and").append(aa); } } else { return true; } String theSql = sqlBuffer.toString(); SqlExcuterImpl sqlMager = (SqlExcuterImpl) SpringContextUtil.getBean("SqlExcuter"); if (sqlMager.sqlQueryString(theSql, null, null, 0) == null) return false; return true; }
private void editPower(String[] aa, VPower tempVo, int types, String vo) throws ChecksException { String id = null; if (aa != null && aa.length > 0) { String str = ""; if (types == 1) { str = "ifView"; } else if (types == 2) { str = "ifEdit"; } else if (types == 3) { str = "ifAdd"; } else if (types == 4) { str = "ifDel"; } else if (types == 5) { str = "ifNotView"; } else if (types == 6) { str = "ifNotEdit"; } else if (types == 7) { str = "ifNotAdd"; } else if (types == 8) { str = "ifNotDel"; } for (int i = 0; i < aa.length; i++) { if (!Checks.empty(aa[i])) { id = tempVo.hqlQueryString( "select id from VPower where opId='" + aa[i] + "' and dataId='" + tempVo.getDataId() + "' and powerTypes ='" + tempVo.getPowerTypes() + "'", null, null, 0); if (id != null) { tempVo.hqlDelUpdate( "update VPower set " + str + " = 1 where id='" + id + "' ", null, null, 1); } else { VPower power = new VPower(); power.setOpId(aa[i]); power.setDataId(tempVo.getDataId()); power.setPowerTypes(tempVo.getPowerTypes()); power.setSafeLeveler(tempVo.getSafeLeveler()); if (str.equals("ifView")) { power.setIfView(1); } else { power.setIfView(0); } if (str.equals("ifEdit")) { power.setIfEdit(1); } else { power.setIfEdit(0); } if (str.equals("ifAdd")) { power.setIfAdd(1); } else { power.setIfAdd(0); } if (str.equals("ifDel")) { power.setIfDel(1); } else { power.setIfDel(0); } if (str.equals("ifNotView")) { power.setIfNotView(1); } else { power.setIfNotView(0); } if (str.equals("ifNotEdit")) { power.setIfNotEdit(1); } else { power.setIfNotEdit(0); } if (str.equals("ifNotAdd")) { power.setIfNotAdd(1); } else { power.setIfNotAdd(0); } if (str.equals("ifNotDel")) { power.setIfNotDel(1); } else { power.setIfNotDel(0); } power.setCreater(WebContextMaker.getLoginer(WebContextMaker.getRequest()).getId()); power.setCreatTime(new Timestamp(System.currentTimeMillis())); power.setMemo(vo); power.setReservation(tempVo.getReservation()); tempVo.save(power); } } } } }
public void fixPowerMap() throws ChecksException { VUser loginuser = WebContextMaker.getLoginer(WebContextMaker.getRequest()); getPowerSql(loginuser, 1, 0, 0, 0); }