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