/**
* 根据管理员ID去查询城市ID集合
*
* @param id
* @return
*/
public static String getCityByAdmin(String id) {
String result = "";
String SQL = "";
if ("admin".equals(id)) {
SQL = "select id from ab_cityarea where id != 'ROOT'";
} else {
List<AbCityarea> tempList =
AbCityarea.dao.find("select * from ab_cityarea where user_id= '" + id + "' order by ccm");
if (null != tempList && !tempList.isEmpty()) {
for (AbCityarea temp : tempList) {
if (SQL.length() > 0) {
SQL += " union ";
}
SQL += "select id from ab_cityarea where id like '" + temp.getStr("id") + "%'";
}
} else {
SQL = "select id from ab_cityarea where id ='111111111111111111'";
}
}
List<String> resultList = Db.query(SQL);
if (null != resultList && !resultList.isEmpty()) {
for (String str : resultList) {
result += str + ",";
}
result = result.substring(0, result.length() - 1);
} else {
result = "1234567890";
}
return result;
}
// 获取员工管辖的商家类型
public static String getAuthSubjectIdsByUserId(String userid) {
String result = "";
String sql = "select subject_id from ab_cityarea_subject where user_id='" + userid + "'";
List<String> subjectIds = Db.query(sql);
if (null != subjectIds && !subjectIds.isEmpty()) {
for (String str : subjectIds) {
result += str + ",";
}
result = result.substring(0, result.length() - 1);
} else {
result = "1234567890";
}
return result;
}