()
| 49 | } |
| 50 | |
| 51 | @Override |
| 52 | public String getText() { |
| 53 | |
| 54 | Long before = new Date().getTime() - (24 * 3600 * 1000); |
| 55 | Long after = new Date().getTime(); |
| 56 | GenericRawResults<String[]> results = ORMManager |
| 57 | .get(Echomail.class) |
| 58 | .getRaw(String |
| 59 | .format("SELECT a.name,a.description,count(e.id) AS count FROM echomail e" |
| 60 | + " LEFT JOIN echoarea a ON (e.echoarea_id=a.id) WHERE e.date >= %d AND e.date <= %d" |
| 61 | + " GROUP BY a.name,a.description ORDER BY count DESC", |
| 62 | before, after)); |
| 63 | |
| 64 | ReportBuilder builder = new ReportBuilder(); |
| 65 | builder.setColumns(Arrays.asList("Area", "Count", "Description")); |
| 66 | builder.setColLength(Arrays.asList(35, 5, 35)); |
| 67 | |
| 68 | for (String[] res : results) { |
| 69 | |
| 70 | builder.printLine(res[0], res[2], res[1]); |
| 71 | |
| 72 | } |
| 73 | return builder.getText().toString(); |
| 74 | } |
| 75 | |
| 76 | @Override |
| 77 | public void handle(IEvent event) { |
nothing calls this directly
no test coverage detected