public void executeManualUT() throws Exception {
MistakeService mistakeService = (MistakeService) JndiFactory.lookup("mistakeService");
String uuid = request.getParameter("uuid");
Mistake mistake = mistakeService.selectMistakeByUuid(uuid);
mistake.setIfUsing(false);
ut.begin();
mistakeService.updateMistake(mistake, USER.getAccount());
ut.commit();
}
public void executeManualUT() throws Exception {
StatisticsService statisticsService =
(StatisticsService) JndiFactory.lookup("statisticsService");
MistakeService mistakeService = (MistakeService) JndiFactory.lookup("mistakeService");
String title = request.getParameter("title");
String beginDate = request.getParameter("beginDate");
String endDate = request.getParameter("endDate");
String offset = request.getParameter("offset");
String recnum = request.getParameter("recnum");
String sql = "select distinct M.* from Mistake M where M.ifUsing = true ";
Constraint c = new Constraint("Mistake");
c.addCondition("ifUsing", true);
if (title != null && title.length() > 0) {
sql += " and title like '%" + title + "%' ";
c.addCondition("title", "%" + title + "%");
}
if (beginDate != null && beginDate.length() > 0) {
sql += " and recordTime >= '" + beginDate + " 00:00:00'";
c.addCondition(
"recordTime", Constants.DATE_FORMAT.parse(beginDate + " 00:00:00' "), Constraint.RTE);
}
if (endDate != null && endDate.length() > 0) {
sql += " and recordTime <= '" + endDate + " 23:59:59' ";
c.addCondition(
"recordTime", Constants.DATE_FORMAT.parse(endDate + " 23:59:59'"), Constraint.LTE);
}
String sqlCount =
"select '"
+ statVirtualUuid++
+ "' as uuid, 1 as timeStamp, count from ("
+ sql.replace("distinct M.*", " count(*) as count ")
+ ") as JdoVirtual";
int count = 0;
Constraint jdoVirtualC = new Constraint("JdoVirtual");
jdoVirtualC.addSQLCondition(sqlCount, null);
JdoVirtual jdoVirtual = statisticsService.selectJdoVirtual(jdoVirtualC);
if (jdoVirtual.getCount() != null) {
count = jdoVirtual.getCount().intValue();
}
c.addOrderCondition("recordTime", "asc");
c.addLimitedCondition(Integer.parseInt(offset) - 1, Constraint.OFFSET);
c.addLimitedCondition(Integer.parseInt(recnum), Constraint.LIMIT);
List<Mistake> list = mistakeService.selectMistakes(c);
List<String[]> tempList = new ArrayList<String[]>();
for (int i = 0; i < list.size(); i++) {
Mistake mistake = list.get(i);
String[] str = new String[5];
str[0] = Integer.toString(Integer.parseInt(offset) + i);
str[1] = mistake.getTitle();
str[2] = mistake.getRecorder().getPerson().getName();
str[3] =
mistake.getRecordTime() != null
? Constants.DATE_FORMAT_YMD.format(mistake.getRecordTime())
: "";
str[4] = mistake.getUuid();
tempList.add(str);
}
List<Object> resultList = new ArrayList<Object>();
resultList.add(tempList);
resultList.add(count);
setResponseText(resultList);
}
