String idSql = DataFilterMemory.getQuerySql(tablesList, queryFieldSet, whereStr, orderFieldMap, isCurrent,templateId, queryConList);
List<Map<String , String>> allIdMap = DbPoolConnection.getInstance().getResultSetListBySql(idSql);
StringBuffer idBuffer = new StringBuffer();
Template bugTemplate = null; //任务对应缺陷bugId,目前默认任务与bug一对一关系
for (Map<String, String> map : allIdMap) {
for (String value : map.values()) {
if (value == null)
continue;
if (bugTemplate == null) {
String[] valueArr = value.split(",");
if (valueArr != null && valueArr.length > 0) {
try {
Data data = das.queryData(DataAccessFactory.getInstance().createUUID(valueArr[0]));
if (data != null) {
bugTemplate = das.queryTemplate(data.getTemplateId());
}
} catch (Exception e) {
}
}
}
idBuffer.append( idBuffer.length() > 0 ? ",":"").append(value);
}
}
if (bugTemplate == null || idBuffer.equals("")) {
return resultMap;
}
//数据库名
String dataLogTable = TableRuleManager.getInstance().getDataLogTableName(bugTemplate.getId());
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT dataId, ").append(fieldStaticColName).append(", date_format(logcreateTime,'%Y-%m-%d') as logcreateTime from ")
.append(dataLogTable).append(" where is_valid = 1 and templateId=").append(bugTemplate.getId().getValue()).append(" and dataId in (").append(idBuffer.toString()).append(")").append(" and logcreateTime >= '").append(startTimestamp.toString().split(" ")[0])
.append("' and logcreateTime <= '").append(endTimestamp.toString().split(" ")[0]).append("' order by dataid,logActionIndex");
resultMap = BugTrendManager.getStatStaticMap(sqlBuffer.toString(), statMap , resultMap);
String whereString = " id in (" + idBuffer.toString() + ")" ;