@Override
public Map<String, Object> findFuzzy(
String column, String objectType, String condition, int page, int pageSize)
throws ClassNotFoundException, JSONException {
String[] columnArray = column.split(",");
StringBuffer sbColumn = new StringBuffer();
StringBuffer sbEntity = new StringBuffer();
Map<String, String> aliasMap = new HashMap<String, String>();
for (int i = 0; i < columnArray.length; i++) {
if (columnArray[i].indexOf(".") != -1) {
String columnHead = columnArray[i].substring(0, columnArray[i].lastIndexOf("."));
String columnBody = columnArray[i].substring(columnArray[i].lastIndexOf(".") + 1);
String columnAlias = "";
// Field f = ReflectionUtils.findField(this.getType(objectType), columnHead);
Field f = BeanFieldUtil.findField(this.getType(objectType), columnHead);
if (null == f) {
continue;
}
if (!aliasMap.containsKey(columnHead)) {
columnAlias = "t_" + i;
aliasMap.put(columnHead, "t_" + i);
sbEntity.append(" left join " + "t_." + columnHead + " as " + "t_" + i);
} else {
columnAlias = aliasMap.get(columnHead);
}
sbColumn.append(
columnAlias
+ "."
+ columnBody
+ " as "
+ columnArray[i].replace(".", "_alias_point_")
+ ",");
} else {
Field f = ReflectionUtils.findField(this.getType(objectType), columnArray[i]);
if (null == f) {
continue;
}
sbColumn.append("t_." + columnArray[i] + " as " + columnArray[i] + ",");
}
}
String sbColumnString = sbColumn.toString();
String hql =
"select new map("
+ sbColumnString.substring(0, sbColumnString.lastIndexOf(","))
+ ") from "
+ objectType
+ " as t_ "
+ sbEntity.toString()
+ "";
if (condition != null && !condition.equals("")) {
String conditionString = "";
JSONObject conditionObject = new JSONObject(condition);
System.out.println(conditionObject.keys());
Iterator<String> it = conditionObject.keys();
while (it.hasNext()) { // 遍历
String key = it.next();
String value = conditionObject.getString(key);
if (value != null && !value.equals("")) {
conditionString += " AND t_." + key + " like '%" + value + "%'";
}
}
/*String[] conditionArray = condition.split(";");
for (int i = 0; i < conditionArray.length; i++) {
String[] cds = conditionArray[i].split("=");
if (cds.length > 1 && cds[1] != null && !cds[1].equals("")) {
conditionString += "t_."+cds[0] + " like '%" + cds[1] +"%'";
}
}*/
if (!conditionString.equals("")) {
hql += " where " + conditionString.substring(4);
}
}
System.out.println(hql);
return this.commDao.findPageList(page, pageSize, hql);
// return this.commDao.findFuzzy(hql, conditionString, page, pageSize);
}
@Override
public List<Map<String, String>> getColumnsProperty(HttpServletRequest request) throws Exception {
// 返回数组
List<Map<String, String>> returnList = new ArrayList<Map<String, String>>();
// 判断传递的是类名称还是json字符串名称
String objectType = request.getParameter("objectType");
String fileName = request.getParameter("fileName");
if (objectType != null && objectType != "") { // 类名
returnList = this.commDao.getColumnsProperty(this.commDao.getType(objectType));
} else if (fileName != null) { // json字符串
String path = ResourceUtil.getTablesDataSourceDirectoryPath();
String fileString = this.readFile(path + fileName);
ObjectMapper mapper = new ObjectMapper();
Map<String, Map<String, String>> temMap = new LinkedHashMap<String, Map<String, String>>();
Map<String, Map<String, String>> _temMap = new LinkedHashMap<String, Map<String, String>>();
Map<String, Map<String, String>> treeMap =
new java.util.TreeMap<String, Map<String, String>>();
Map<String, Object> map = mapper.readValue(fileString, Map.class);
System.out.println(map);
Map<String, String> attrMap = (Map<String, String>) map.get("attribute");
// 通过json字符串中的attribute属性获取保存的类名，取得基础类
List<String> sortFieldList = new ArrayList<String>();
if (attrMap != null && attrMap.get("objectType") != null) {
returnList =
this.commDao.getColumnsProperty(this.commDao.getType(attrMap.get("objectType")));
// 将
for (Map<String, String> column : returnList) {
// temMap.put(column.get("fieldName"), column);
sortFieldList.add(column.get("fieldName"));
}
}
// json字符串中保存的grid
List gridList = (ArrayList) map.get("grid");
// 搜素字段
List searchList = (ArrayList) map.get("search");
// 表单字段
List formList = (ArrayList) map.get("form");
// Map attrMap = map.get("attribute");
// 将表单字段排序
// 归并将form和grid合并name字段
List<String> sortGridList = new ArrayList<String>();
Set<String> linkSet = new LinkedHashSet<String>();
for (int i = 0; i < gridList.size(); i++) {
Map<String, Object> gridField = (Map<String, Object>) gridList.get(i);
String name = gridField.get("name").toString();
if (name.contains(".")) {
name = name.substring(0, name.indexOf("."));
}
linkSet.add(name);
}
sortGridList.addAll(linkSet);
List<String> sortFormList = new ArrayList<String>();
for (int i = 0; i < formList.size(); i++) {
Map<String, Object> fromField = (Map<String, Object>) formList.get(i);
sortFormList.add(fromField.get("name").toString());
}
List<String> sortGridAndForm = SortUtil.mergeArray(sortGridList, sortFormList);
List<String> sortList = SortUtil.mergeArray(sortFieldList, sortGridAndForm);
for (int i = 0; i < sortList.size(); i++) {
temMap.put(sortList.get(i), null);
}
if (attrMap != null && attrMap.get("objectType") != null) {
returnList =
this.commDao.getColumnsProperty(this.commDao.getType(attrMap.get("objectType")));
// 将
for (Map<String, String> column : returnList) {
temMap.put(column.get("fieldName"), column);
// sortFieldList.add(column.get("fieldName"));
}
}
if (!gridList.isEmpty()) {
for (int i = 0; i < gridList.size(); i++) {
Map<String, Object> gridField = (Map<String, Object>) gridList.get(i);
Field f =
BeanFieldUtil.findField(
this.commDao.getType(attrMap.get("objectType")),
gridField.get("name").toString());
if (f != null) {}
Map<String, String> columnMap = temMap.get(gridField.get("name"));
if (null == columnMap) {
columnMap = new HashMap<String, String>();
}
Set<String> keys = gridField.keySet();
for (String keyString : keys) {
String value = gridField.get(keyString).toString();
columnMap.put("inlist", "true");
// 将保存的jsonString转成页面的字段
if (keyString.equals("name")) {
columnMap.put("fieldName", value);
} else if (keyString.equals("display")) {
columnMap.put("showName", value);
} else if (keyString.equals("width")) {
columnMap.put("listwidth", value);
} else if (keyString.equals("hide")) {
if (value == "true") {
columnMap.put("render", "hide");
}
} else {
columnMap.put(keyString, value);
}
}
temMap.put((String) gridField.get("name"), columnMap);
_temMap.put((String) gridField.get("name"), columnMap);
}
;
}
if (!searchList.isEmpty()) {
for (int i = 0; i < searchList.size(); i++) {
Map<String, Object> gridField = (Map<String, Object>) searchList.get(i);
Map<String, String> columnMap = temMap.get(gridField.get("name"));
if (null == columnMap) {
columnMap = new HashMap<String, String>();
}
Set<String> keys = gridField.keySet();
for (String keyString : keys) {
String value = gridField.get(keyString).toString();
columnMap.put("insearch", "true");
if (keyString.equals("name")) {
columnMap.put("fieldName", value);
} else if (keyString.equals("display")) {
columnMap.put("showName", value);
} else {
columnMap.put(keyString, value);
}
}
temMap.put((String) gridField.get("name"), columnMap);
_temMap.put((String) gridField.get("name"), columnMap);
}
;
}
if (!formList.isEmpty()) {
for (int i = 0; i < formList.size(); i++) {
Map<String, Object> gridField = (Map<String, Object>) formList.get(i);
Map<String, String> columnMap = temMap.get(gridField.get("name"));
if (null == columnMap) {
columnMap = new HashMap<String, String>();
}
Set<String> keys = gridField.keySet();
for (String keyString : keys) {
String value = gridField.get(keyString).toString();
columnMap.put("inform", "true");
if (keyString.equals("name")) {
columnMap.put("fieldName", value);
} else if (keyString.equals("display")) {
columnMap.put("showName", value);
} else {
columnMap.put(keyString, value);
}
}
temMap.put((String) gridField.get("name"), columnMap);
_temMap.put((String) gridField.get("name"), columnMap);
}
;
}
returnList.clear();
for (String k : temMap.keySet()) {
returnList.add(temMap.get(k));
}
returnList.add(attrMap);
}
return returnList;
}