| 19 |
|
|
| 20 |
|
public CpuUserReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){ |
| 21 |
|
super (directory, stmt, machine_name, startDate, endDate); |
| 22 |
+ |
|
| 23 |
+ |
// Use this from the parameter table. |
| 24 |
+ |
_reportField = "packet.cpu.user"; |
| 25 |
+ |
|
| 26 |
+ |
// Use this select query. |
| 27 |
+ |
_sql = "SELECT receipt_date, value FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;"; |
| 28 |
+ |
|
| 29 |
|
} |
| 30 |
|
|
| 31 |
|
//---PUBLIC METHODS--- |
| 33 |
|
// Override the superclass here to obtain special functionality. |
| 34 |
|
public void createReport(){ |
| 35 |
|
|
| 36 |
< |
// Special funtionality. |
| 37 |
< |
setReportField("packet.cpu.user"); |
| 31 |
< |
_sql = "SELECT * FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+_machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"';"; |
| 36 |
> |
// Perform special functions here. |
| 37 |
> |
// ..... |
| 38 |
|
|
| 39 |
|
// Now carry on with the normal method for creating reports. |
| 40 |
|
super.createReport(); |
