// ---------------------------------------------------------------------------- // Copyright 2007-2017, GeoTelematic Solutions, Inc. // All rights reserved // ---------------------------------------------------------------------------- // // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // http://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. // // ---------------------------------------------------------------------------- // Description: // Report definition based on EventData table // ---------------------------------------------------------------------------- // Change History: // 2007/03/11 Martin D. Flynn // -Initial release // 2007/01/10 Martin D. Flynn // -Added fields 'checkinDateTime', 'checkinAge' // 2008/02/04 Martin D. Flynn // -Added fields 'engineRpm', 'fuelUsed' // 2008/03/12 Martin D. Flynn // -Added additional decimal point options to various fields // 2008/04/11 Martin D. Flynn // -Added color indicator to lat/lon when gps age is over a given threshold // -Added field 'gpsAge' // 2008/05/14 Martin D. Flynn // -Added City/State/Country/Subdivision fields // 2008/10/16 Martin D. Flynn // -Added battery level field. // -Added input mask field. // 2009/01/01 Martin D. Flynn // -Added arguments to "heading" to allow displaying in degrees // 2010/09/09 Martin D. Flynn // -Added "ambientTemp", "barometer", "deviceBattery" // 2011/03/08 Martin D. Flynn // -Added "driverStatus" // 2011/06/16 Martin D. Flynn // -Added status code/description coloring option // -Added "mapLink" feature to "index" column to support displaying the map // with a specific pushpin info-balloon displayed. // 2011/07/15 Martin D. Flynn // -Added "analog#" fields. Fixed "batteryVolts" column to use "getBatteryVolts()". // 2011/08/21 Martin D. Flynn // -Added "tirePressure", "tireTemp" // 2011/10/03 Martin D. Flynn // -Added "turboPressure", "day*" // 2012/02/03 Martin D. Flynn // -Added "fuelRate" // 2012/04/03 Martin D. Flynn // -Added "formatElapsedTime" // -Added DATA_FAULT_CODES to display multiple DTC codes // 2012/08/01 Martin D. Flynn // -Added DATA_REPORT_DISTANCE // 2012/09/02 Martin D. Flynn // -Added DATA_CREATE_AGE, DATA_CREATE_MILLIS // -Modified DATA_STATUS_CODE to support displaying a decimal status code. // -Added support for decimal status code display (see DATA_STATUS_CODE) // -Changed Double value formatting to using "EventDataLayout.formatDouble" // instead of "StringTools.format". // -Added DATA_GPSFIX_TYPE and DATA_GPSFIX_STATUS // 2012/12/24 Martin D. Flynn // -Added proper sort ordering for temperature fields // 2013/04/08 Martin D. Flynn // -Added DATA_DEVICE_VIN // -Change massAirFlow units to grams/sec. // 2014/05/05 Martin D. Flynn // -Added DATA_BATTERY_TEMP, DATA_ATTACHMENT_PROP // 2014/06/29 Martin D. Flynn // -Added DATA_WORK_HOURS, DATA_WORK_DISTANCE, DATA_PTO_DISTANCE // 2014/11/30 Martin D. Flynn // -Modified DATA_CHECKIN_AGE to display "Future" if event is in the future. // -Added DATA_DEVICE_NAME // -Support device titles for DATA_DEVICE_DESC // 2015/05/03 Martin D. Flynn // -Added "googleLink" support to DATA_INDEX. // -Added DATA_MESSAGE_DATETIME, DATA_MESSAGE_TIMESTAMP // -Added DATA_MESSAGE_ID, DATA_MESSAGE_STATUS, DATA_MESSAGE_STATUS_DESC // -Added DATA_ACCEL_XYZ, DATA_ACCEL_MAGNITUDE // 2015/08/16 Martin D. Flynn // -Added OIL_COOLER_IN_TEMP, DATA_OIL_COOLER_OUT_TEMP, DATA_ENGINE_TEMP // -Added DATA_DEVICE_IMEI, DATA_DEVICE_MODEM_ID, DATA_DEVICE_LICENSE // -Added DATA_MULTI_FIELDS, DATA_RULE_SELECTOR // 2016/01/14 Martin D. Flynn // -Added "device" parameter to "index" column map link [2.6.1-B51] // 2016/04/06 Martin D. Flynn // -Added DATA_IGNITION_STATE, DATA_FREQUENCY // 2016/09/01 Martin D. Flynn // -Fixed "DATA_FUEL_LEVEL_VOL" [2.6.3-B19] // -Added DATA_DEVICE_PHONE [2.6.3-B60] // 2017/07/13 GTS Developent Team // -Added DATA_ENGINE_TORQUE, DATA_SERVICE_DISTANCE [2.6.5-B32] // ---------------------------------------------------------------------------- package org.opengts.war.report.event; import java.util.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import org.opengts.util.*; import org.opengts.dbtools.*; import org.opengts.dbtypes.*; import org.opengts.db.*; import org.opengts.db.tables.*; import org.opengts.war.tools.RequestProperties; import org.opengts.war.tools.WebPageAdaptor; import org.opengts.war.tools.ComboOption; import org.opengts.war.tools.MapDimension; import org.opengts.war.report.*; public class EventDataLayout extends ReportLayout { // ------------------------------------------------------------------------ // TODO: these colors/thresholds should be configurable at runtime //private static final long GPS_AGE_THRESHOLD_1 = DateTime.MinuteSeconds(60); //private static final String GPS_AGE_COLOR_1 = "#BB0000"; // lighter red //private static final long GPS_AGE_THRESHOLD_2 = DateTime.MinuteSeconds(20); //private static final String GPS_AGE_COLOR_2 = "#550000"; // darker red // ------------------------------------------------------------------------ private static final long MINIMUM_REASONABLE_TIMESTAMP = (new DateTime(null,2000,1,1)).getTimeSec(); // ------------------------------------------------------------------------ // Data keys // - These define what data is available (see 'EventDataRow') and what columns are // available for display in the report. // - Column names must contain only //'_' characters public static final String DATA_INDEX = "index"; public static final String DATA_MULTI_FIELDS = "multiFields"; // "arg" must contain field list public static final String DATA_ATTACHMENT_URL = "attachURL"; public static final String DATA_ATTACHMENT_PROP = "attachProp"; // ev.getAttachData() public static final String DATA_DATE = "date"; public static final String DATA_TIME = "time"; public static final String DATA_DATETIME = "dateTime"; public static final String DATA_TIMESTAMP = "timestamp"; public static final String DATA_GROUP_ID = "groupId"; public static final String DATA_STATUS_CODE = "statusCode"; public static final String DATA_STATUS_DESC = "statusDesc"; public static final String DATA_PUSHPIN = "pushpin"; public static final String DATA_GPS_AGE = "gpsAge"; public static final String DATA_LATITUDE = "latitude"; public static final String DATA_LONGITUDE = "longitude"; public static final String DATA_GEOPOINT = "geoPoint"; public static final String DATA_GPSFIX_TYPE = "gpsFixType"; public static final String DATA_GPSFIX_STATUS = "gpsFixStatus"; public static final String DATA_ACCURACY = "accuracy"; public static final String DATA_ALTITUDE = "altitude"; public static final String DATA_SATELLITES = "satellites"; public static final String DATA_SPEED_LIMIT = "speedLimit"; public static final String DATA_OVER_SPEED_LIMIT = "overSpeedLimit"; public static final String DATA_SPEED = "speed"; public static final String DATA_SPEED_HEADING = "speedH"; public static final String DATA_SPEED_UNITS = "speedU"; public static final String DATA_HEADING = "heading"; public static final String DATA_DISTANCE = "distance"; public static final String DATA_ODOMETER = "odometer"; public static final String DATA_REPORT_DISTANCE = "reportDistance"; //public static final String DATA_STOP_DATETIME = "stopDateTime"; //public static final String DATA_STOP_ELAPSED = "stopElapsed"; public static final String DATA_CELL_LATITUDE = "cellLatitude"; public static final String DATA_CELL_LONGITUDE = "cellLongitude"; public static final String DATA_CELL_GEOPOINT = "cellGeoPoint"; public static final String DATA_CELL_ACCURACY = "cellAccuracy"; public static final String DATA_BEST_LATITUDE = "bestLatitude"; public static final String DATA_BEST_LONGITUDE = "bestLongitude"; public static final String DATA_BEST_GEOPOINT = "bestGeoPoint"; public static final String DATA_BEST_ACCURACY = "bestAccuracy"; public static final String DATA_BATTERY = "battery"; public static final String DATA_BATTERY_PERCENT = "batteryPercent"; public static final String DATA_BATTERY_VOLTS = "batteryVolts"; public static final String DATA_BATTERY_TEMP = "batteryTemp"; public static final String DATA_INPUT_STATE = "inputState"; public static final String DATA_INPUT_BIT = "inputBit"; public static final String DATA_OUTPUT_STATE = "outputState"; public static final String DATA_OUTPUT_BIT = "outputBit"; public static final String DATA_SEATBELT_STATE = "seatbeltState"; public static final String DATA_SEATBELT_BIT = "seatbeltBit"; public static final String DATA_DOOR_STATE = "doorState"; public static final String DATA_DOOR_BIT = "doorBit"; public static final String DATA_LIGHTS_STATE = "lightsState"; public static final String DATA_LIGHTS_BIT = "lighsBit"; public static final String DATA_IGNITION_STATE = "ignitionState"; public static final String DATA_ANALOG_0 = "analog0"; public static final String DATA_ANALOG_1 = "analog1"; public static final String DATA_ANALOG_2 = "analog2"; public static final String DATA_ANALOG_3 = "analog3"; public static final String DATA_ANALOG[] = { DATA_ANALOG_0, DATA_ANALOG_1, DATA_ANALOG_2, DATA_ANALOG_3 }; public static final String DATA_PULSE_COUNT = "pulseCount"; public static final String DATA_FREQUENCY = "frequency"; public static final String DATA_ADDRESS = "address"; public static final String DATA_CITY = "city"; public static final String DATA_STATE = "state"; public static final String DATA_COUNTRY = "country"; public static final String DATA_SUBDIVISION = "subdivision"; public static final String DATA_GEOZONE_ID = "geozoneId"; public static final String DATA_GEOZONE_DESC = "geozoneDesc"; public static final String DATA_ENTITY_ID = "entityId"; public static final String DATA_ENTITY_DESC = "entityDesc"; public static final String DATA_DRIVER_ID = "driverId"; public static final String DATA_DRIVER_DESC = "driverDesc"; public static final String DATA_DRIVER_STATUS = "driverStatus"; public static final String DATA_DRIVER_MESSAGE = "driverMessage"; public static final String DATA_MESSAGE_DATETIME = "messageDateTime"; public static final String DATA_MESSAGE_TIMESTAMP = "messageTimestamp"; public static final String DATA_MESSAGE_ID = "messageId"; public static final String DATA_MESSAGE_STATUS = "messageStatus"; public static final String DATA_MESSAGE_STATUS_DESC = "messageStatusDesc"; public static final String DATA_JOB_NUMBER = "jobNumber"; public static final String DATA_RFID_TAG = "rfidTag"; public static final String DATA_SAMPLE_INDEX = "sampleIndex"; public static final String DATA_SAMPLE_ID = "sampleId"; //public static final String DATA_APPLIED_PRESSURE = "appliedPressure"; public static final String DATA_ETA_DATETIME = "etaDateTime"; public static final String DATA_ETA_TIMESTAMP = "etaTimestamp"; public static final String DATA_ETA_UNIQUE_ID = "etaUniqueID"; // ETA ID public static final String DATA_ETA_DISTANCE = "etaDistance"; // ETA distance public static final String DATA_ETA_LATITUDE = "etaLatitude"; // ETA latitude public static final String DATA_ETA_LONGITUDE = "etaLongitude"; // ETA longitude public static final String DATA_ETA_GEOPOINT = "etaGeoPoint"; // ETA lat/lon public static final String DATA_STOP_UNIQUE_ID = "stopUniqueID"; // STOP ID public static final String DATA_STOP_STATUS = "stopStatus"; // STOP Status public static final String DATA_STOP_STATUS_DESC = "stopStatusDesc"; // STOP Status Description public static final String DATA_STOP_INDEX = "stopIndex"; // STOP Index public static final String DATA_BAROMETER = "barometer"; public static final String DATA_AMBIENT_TEMP = "ambientTemp"; public static final String DATA_CABIN_TEMP = "cabinTemp"; public static final String DATA_CARGO_TEMP = "cargoTemp"; public static final String DATA_THERMO_1 = "thermo1"; public static final String DATA_THERMO_2 = "thermo2"; public static final String DATA_THERMO_3 = "thermo3"; public static final String DATA_THERMO_4 = "thermo4"; public static final String DATA_THERMO_5 = "thermo5"; public static final String DATA_THERMO_6 = "thermo6"; public static final String DATA_THERMO_7 = "thermo7"; public static final String DATA_THERMO_8 = "thermo8"; public static final String DATA_THERMO[] = { DATA_THERMO_1, DATA_THERMO_2, DATA_THERMO_3, DATA_THERMO_4, DATA_THERMO_5, DATA_THERMO_6, DATA_THERMO_7, DATA_THERMO_8, }; public static final String DATA_FUEL_LEVEL = "fuelLevel"; public static final String DATA_FUEL_LEVEL_1 = "fuelLevel1"; public static final String DATA_FUEL_LEVEL_2 = "fuelLevel2"; public static final String DATA_FUEL_LEVEL_VOL = "fuelLevelVolume"; public static final String DATA_FUEL_LEVEL_VOL_1 = "fuelLevelVolume1"; public static final String DATA_FUEL_LEVEL_VOL_2 = "fuelLevelVolume2"; public static final String DATA_FUEL_CAPACITY = "fuelCapacity"; // Device record public static final String DATA_FUEL_CAPACITY_1 = "fuelCapacity1"; // Device record public static final String DATA_FUEL_CAPACITY_2 = "fuelCapacity2"; // Device record public static final String DATA_FUEL_ECONOMY = "fuelEconomy"; public static final String DATA_FUEL_ECONOMY_TYPE = "fuelEconomyType"; public static final String DATA_FUEL_TOTAL = "fuelTotal"; public static final String DATA_FUEL_REMAIN = "fuelRemain"; public static final String DATA_FUEL_TRIP = "fuelTrip"; public static final String DATA_FUEL_IDLE = "fuelIdle"; public static final String DATA_FUEL_ENGINE_ON = "fuelEngineOn"; public static final String DATA_FUEL_PRESSURE = "fuelPressure"; public static final String DATA_FUEL_RATE = "fuelRate"; public static final String DATA_FAULT_CODES = "faultCodes"; public static final String DATA_FAULT_CODE = "faultCode"; public static final String DATA_MALFUNCTION_LAMP = "malfunctionLamp"; public static final String DATA_AIRBAG_LAMP = "airbagLamp"; public static final String DATA_ABS_LAMP = "absLamp"; public static final String DATA_BRAKE_LAMP = "brakeLamp"; public static final String DATA_OIL_LEVEL = "oilLevel"; public static final String DATA_OIL_PRESSURE = "oilPressure"; public static final String DATA_OIL_TEMP = "oilTemp"; public static final String DATA_ENGINE_RPM = "engineRpm"; public static final String DATA_ENGINE_TORQUE = "engineTorque"; public static final String DATA_ENGINE_HOURS = "engineHours"; public static final String DATA_ENGINE_ON_HOURS = "engineOnHours"; public static final String DATA_ENGINE_LOAD = "engineLoad"; // % public static final String DATA_IDLE_HOURS = "idleHours"; // hours public static final String DATA_TRANS_GEAR = "transGear"; // gear# public static final String DATA_TRANS_OIL_TEMP = "transOilTemp"; // C public static final String DATA_OIL_COOLER_IN_TEMP = "oilCoolerInTemp"; // C public static final String DATA_OIL_COOLER_OUT_TEMP = "oilCoolerOutTemp"; // C public static final String DATA_COOLANT_PRESSURE = "coolantPressure"; // kPa public static final String DATA_COOLANT_LEVEL = "coolantLevel"; // % public static final String DATA_COOLANT_TEMP = "coolantTemp"; // C public static final String DATA_ENGINE_TEMP = "engineTemp"; // C public static final String DATA_BRAKE_G_FORCE = "brakeGForce"; // G public static final String DATA_BRAKE_FORCE = "brakeForce"; public static final String DATA_BRAKE_PRESSURE = "brakePressure"; // kPa public static final String DATA_BRAKE_POSITION = "brakePos"; // % public static final String DATA_ACCELERATION = "acceleration"; // public static final String DATA_ACCEL_XYZ = "accelXYZ"; public static final String DATA_ACCEL_MAGNITUDE = "accelMagnitude"; public static final String DATA_PTO_ENGAGED = "ptoEngaged"; public static final String DATA_PTO_HOURS = "ptoHours"; public static final String DATA_PTO_DISTANCE = "ptoDistance"; public static final String DATA_WORK_HOURS = "workHours"; public static final String DATA_WORK_SHIFT = "workShift"; // calc public static final String DATA_WORK_DISTANCE = "workDistance"; public static final String DATA_SERVICE_DISTANCE = "serviceDistance"; public static final String DATA_VEH_BATTERY_VOLTS = "vBatteryVolts"; public static final String DATA_THROTTLE_POSITION = "throttlePos"; // % public static final String DATA_INTAKE_TEMP = "intakeTemp"; // C public static final String DATA_AIR_PRESSURE = "airPressure"; // kPa public static final String DATA_AIR_FILTER_PRESS = "airFilterPressure"; // kPa public static final String DATA_MASS_AIR_FLOW = "massAirFlow"; // g/sec public static final String DATA_TURBO_PRESS = "turboPressure"; // kPa public static final String DATA_TIRE_PRESSURE = "tirePressure"; // kPa public static final String DATA_TIRE_TEMPERATURE = "tireTemp"; // C public static final String DATA_TIRE_PRESSTEMP = "tirePressTemp"; // kPa/C public static final String DATA_TANK_LEVEL = "tankLevel"; // % public static final String DATA_IMPACT_MAGNITUDE = "impactMagnitude"; // Meters/Second/Second public static final String DATA_EVENT_FIELD = "eventField"; // arg public static final String DATA_RULE_SELECTOR = "ruleSelector"; // RuleFactory public static final String DATA_DATA_SOURCE = "dataSource"; public static final String DATA_RAW_DATA = "rawData"; public static final String DATA_CREATE_DATE = "createDate"; public static final String DATA_CREATE_TIME = "createTime"; public static final String DATA_CREATE_DATETIME = "createDateTime"; public static final String DATA_CREATE_TIMESTAMP = "createTimestamp"; public static final String DATA_CREATE_AGE = "createAge"; public static final String DATA_CREATE_MILLIS = "createMillis"; public static final String DATA_TRIP_START_DATETIME = "tripStartDateTime"; public static final String DATA_TRIP_STOP_DATETIME = "tripStopDateTime"; public static final String DATA_TRIP_DISTANCE = "tripDistance"; public static final String DATA_TRIP_IDLE_HOURS = "tripIdleHours"; public static final String DATA_TRIP_MAX_SPEED = "tripMaxSpeed"; public static final String DATA_TRIP_MAX_RPM = "tripMaxRPM"; public static final String DATA_TRIP_START_LAT = "tripStartLatitude"; public static final String DATA_TRIP_START_LON = "tripStartLongitude"; public static final String DATA_TRIP_ELAPSED = "tripElapsed"; public static final String DATA_DAY_ENGINE_STARTS = "dayEngineStarts"; public static final String DATA_DAY_IDLE_HOURS = "dayIdleHours"; public static final String DATA_DAY_FUEL_IDLE = "dayFuelIdle"; public static final String DATA_DAY_WORK_HOURS = "dayWorkHours"; public static final String DATA_DAY_FUEL_WORK = "dayFuelWork"; public static final String DATA_DAY_FUEL_PTO = "dayFuelPTO"; public static final String DATA_DAY_FUEL_TOTAL = "dayFuelTotal"; public static final String DATA_DAY_DISTANCE = "dayDistance"; public static final String DATA_DEVICE_ID = "deviceId"; public static final String DATA_DEVICE_IMEI = "deviceIMEI"; // Device record public static final String DATA_DEVICE_UNIQUE_ID = "deviceUniqueID"; // Device record public static final String DATA_DEVICE_MODEM_ID = "deviceModemID"; // Device record public static final String DATA_DEVICE_DESC = "deviceDesc"; // Device record public static final String DATA_DEVICE_NAME = "deviceName"; // Device record public static final String DATA_DEVICE_BATTERY_LEVEL = "deviceBatteryLevel"; // Device record public static final String DATA_DEVICE_BATTERY_VOLTS = "deviceBattery"; // Device record public static final String DATA_DEVICE_VIN = "deviceVehicleID"; // Device record public static final String DATA_DEVICE_LICENSE = "deviceLicensePlate"; // Device record public static final String DATA_DEVICE_PHONE = "devicePhoneNumber"; // Device record public static final String DATA_DEVICE_CREATION = "deviceCreateDateTime"; // Device record public static final String DATA_CHECKIN_DATETIME = "checkinDateTime"; // Device record public static final String DATA_CHECKIN_AGE = "checkinAge"; // Device record public static final String DATA_CUSTOM_FIELD = "customField"; // Device record public static final String DATA_LAST_BATTERY_PCT = "lastBatteryPercent"; // Device record public static final String DATA_LAST_FAULT_CODES = "lastFaultCodes"; // Device record // ------------------------------------------------------------------------ // EventDataLayout is a singleton private static EventDataLayout reportDef = null; /** *** Gets the EventDataLayout singleton instance *** @return The EventDataLayout singleton instance **/ public static ReportLayout getReportLayout() { if (reportDef == null) { reportDef = new EventDataLayout(); } return reportDef; } /** *** Standard singleton constructor **/ private EventDataLayout() { super(); this.setDataRowTemplate(new EventDataRow()); } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ /* get decimal format string */ protected static String getArgFormatString(String arg, String dftFmt) { String fmt = dftFmt; if (StringTools.isBlank(arg)) { // -- default format fmt = dftFmt; } else if (arg.startsWith("#")) { // -- explicit format (ie. "#0.0000") fmt = arg.substring(1); } else { // -- format alias, "arg" represents number of decimal points switch (arg.charAt(0)) { case '0': fmt = "0" ; break; case '1': fmt = "0.0" ; break; case '2': fmt = "0.00" ; break; case '3': fmt = "0.000" ; break; case '4': fmt = "0.0000" ; break; case '5': fmt = "0.00000" ; break; case '6': fmt = "0.000000" ; break; case '7': fmt = "0.0000000" ; break; case '8': fmt = "0.00000000" ; break; case '9': fmt = "0.000000000"; break; default : fmt = dftFmt ; break; } } return fmt; } /* format double value */ protected static String formatDouble(double value, String arg, String dftFmt) { String fmt = EventDataLayout.getArgFormatString(arg, dftFmt); return StringTools.format(value, fmt); } // ------------------------------------------------------------------------ /* format temperatures */ protected static String formatTemperature(double thermoC, String arg, ReportData rd, String dft) { if (EventData.isValidTemperature(thermoC)) { Account a = rd.getAccount(); double thermo = Account.getTemperatureUnits(a).convertFromC(thermoC); String unitAbbr = Account.getTemperatureUnits(a).toString(rd.getLocale()); return EventDataLayout.formatDouble(thermo, arg, "0.0") + unitAbbr; } else if (dft != null) { return dft; } else { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String na = i18n.getString("EventDataLayout.notAvailable","n/a"); return "--"; } } /* format kilometer distance */ protected static String formatKM(double km, String arg, ReportData rd) { if (km > 0.0) { double dist = Account.getDistanceUnits(rd.getAccount()).convertFromKM(km); return EventDataLayout.formatDouble(dist, arg, "0"); } else { return ""; } } protected static String formatSpeed(double kph, String arg, ReportData rd) { double speed = Account.getSpeedUnits(rd.getAccount()).convertFromKPH(kph); return EventDataLayout.formatDouble(speed, arg, "0"); } protected static String formatEconomy(double kpl, String arg, ReportData rd) { double econ = Account.getEconomyUnits(rd.getAccount()).convertFromKPL(kpl); return EventDataLayout.formatDouble(econ, arg, "0"); } protected static String formatVolume(double L, String arg, ReportData rd) { double vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(L); return EventDataLayout.formatDouble(vol, arg, "0"); } protected static String formatPressure(double kPa, String arg, ReportData rd) { double press = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); return EventDataLayout.formatDouble(press, arg, "0.0"); } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ /** *** Returns true if the specified Object contains a valid GeoPoint **/ protected static boolean HasValidGeoPoint(Object obj) { if (obj instanceof EventData) { return ((EventData)obj).isValidGeoPoint(); } else { return false; } } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ protected static class EventDataRow extends DataRowTemplate { public EventDataRow() { super(); // -- Index this.addColumnTemplate(new DataColumnTemplate(DATA_INDEX) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { if (rowNdx >= 0) { String arg = rc.getArg(); EventData ed = (EventData)obj; int ofs = 1; String ndxVal = String.valueOf(rowNdx + ofs); if (StringTools.isBlank(arg)) { return ndxVal; } else if (!HasValidGeoPoint(ed)) { return ndxVal; } else if (arg.equalsIgnoreCase("map") || arg.equalsIgnoreCase("mapLink") ) { URIArg mapURL = rd.getMapURL(); if (mapURL != null) { mapURL.addArg("device",ed.getDeviceID()); // [2.6.1-B51] mapURL.addArg("showpp",rowNdx+1); mapURL.addArg("zoompp",rowNdx+1); RequestProperties reqState = rd.getRequestProperties(); MapDimension sz = rd.getMapWindowSize(); int W = sz.getWidth(); int H = sz.getHeight(); String encMapURL = WebPageAdaptor.EncodeURL(reqState,mapURL); String target = null; boolean button = false; ColumnValue cv = new ColumnValue(); cv.setValue(" "+ndxVal+" "); cv.setLinkURL("javascript:openResizableWindow('"+encMapURL+"','ReportMap',"+W+","+H+");",target,button); return cv; } else { return ndxVal; } } else if (arg.equalsIgnoreCase("googleMap") || arg.equalsIgnoreCase("googleLink") ) { double lat = ed.getLatitude(); double lon = ed.getLongitude(); URIArg mapURL = new URIArg("https://www.google.com/maps/search/"+lat+","+lon); String target = "_blank"; boolean button = false; ColumnValue cv = new ColumnValue(); cv.setValue(" "+ndxVal+" "); cv.setLinkURL(mapURL.toString(),target,button); return cv; } else if (arg.charAt(0) == '0') { return String.valueOf(rowNdx); } else { return String.valueOf(rowNdx + ofs); } } else { return ""; } } public String getTitle(ReportData rd, ReportColumn rc) { return "#"; } }); // -- Multiple field combination this.addColumnTemplate(new DataColumnTemplate(DATA_MULTI_FIELDS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; StringBuffer sb = new StringBuffer(); String colKeys[] = StringTools.split(arg,','); for (String colKey : colKeys) { DataColumnTemplate dct = EventDataRow.this.getColumnTemplate(colKey); if (dct != null) { Object valObj = dct.getColumnValue(rowNdx, rd, rc, obj); String valStr = StringTools.trim(valObj); //Print.logInfo("Column key/value: " + colKey + " ==> " + valStr); if (sb.length() > 0) { sb.append("-"); } // separator sb.append(valStr); } else { Print.logWarn("Column key not found: " + colKey); } } return sb.toString(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.multiFields","Multi-Fields"); } }); // -- Attachment URL (pictures/images, etc) this.addColumnTemplate(new DataColumnTemplate(DATA_ATTACHMENT_URL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { RequestProperties reqState = rd.getRequestProperties(); String arg = rc.getArg(); EventData ed = (EventData)obj; if (ed.hasAttachData()) { PixelDimension dim = HTMLTools.getImageDimension(ed.getAttachData()); Print.logInfo("Image Dim: " + dim); String extn = HTMLTools.getExtensionFromMimeType(ed.getAttachType(), "txt"); String dftURI = "." + "/Attach"/*Constants.DEFAULT_ATTACH_URI*/ + "." + extn; URIArg attURL = new URIArg(dftURI, true); // EncodeURL attURL.addArg("d" , ed.getDeviceID()); attURL.addArg("ts", ed.getTimestamp()); attURL.addArg("sc", "0x" + StringTools.toHexString(ed.getStatusCode(),16)); int W = (dim != null)? dim.getWidth() : 600; int H = (dim != null)? dim.getHeight() : 400; if ((W > 1024) || (H > 1024)) { if ((W > 1024) && (W > H)) { double scale = (double)H/(double)W; W = 1024; H = (int)Math.round((double)W * scale); if (H <= 0) { H = 1; } } else { double scale = (double)W/(double)H; H = 1024; W = (int)Math.round((double)H * scale); if (W <= 0) { W = 1; } } } String encURL = WebPageAdaptor.EncodeURL(reqState,attURL); String target = null; boolean button = false; ColumnValue cv = new ColumnValue(); cv.setValue(" "+extn+" "); cv.setLinkURL("javascript:openResizableWindow('"+encURL+"','Attachment',"+W+","+H+");",target,button); return cv; } else { return ""; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.attachment","Attachment"); } }); // -- Attachment properties this.addColumnTemplate(new DataColumnTemplate(DATA_ATTACHMENT_PROP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); // "varName:fmt" int p = arg.indexOf(":"); String var = (p >= 0)? arg.substring(0,p).trim() : arg; String fmt = (p >= 0)? arg.substring(p+1).trim().toUpperCase() : ""; if (!StringTools.isBlank(var)) { Account acct = rd.getAccount(); EventData ed = (EventData)obj; RTProperties rtp = ed.getAttachRTProperties(); if (rtp != null) { // Supported data types: // $ = String // N = Generic Number (double/long) // K = Kilometers (km) // S = Speed (km/h) // E = Fuel Economy (km/L) // T = Temperature (C) // V = Volume (Liters) // P = Pressure (kPa) // L = Latitude/Longitude (GeoPoint) // A = Altitude (meters) // H - Hours/seconds (hh:mm:ss) // Unsupported data types: // M = Mass // F = Force // R = Area // C = Currency if (StringTools.isBlank(fmt) || fmt.startsWith("$")) { // -- String return rtp.getString(var,""); } else if (fmt.startsWith("N")) { // -- Generic number (Long/Double) String dec = fmt.substring(1); if (StringTools.isBlank(dec)) { // -- assume Integer/Long long val = rtp.getLong(var,0L); // parse as Long return String.valueOf(val); // back to a String } else { // -- assume Float/Double double val = rtp.getDouble(var,0.0); // parse as Double return EventDataLayout.formatDouble(val, dec, "0"); } } else if (fmt.startsWith("K")) { // -- Kilometers String dec = fmt.substring(1); double km = rtp.getDouble(var,0.0); // parse as Double // -- valid km (unlikely, but allow negative) return EventDataLayout.formatKM(km, dec, rd); } else if (fmt.startsWith("S")) { // -- SpeedKPH String dec = fmt.substring(1); double kph = rtp.getDouble(var,0.0); // parse as Double // -- valid km/h (unlikely, but allow negative) return EventDataLayout.formatSpeed(kph, dec, rd); } else if (fmt.startsWith("E")) { // -- Economy String dec = fmt.substring(1); double kpl = rtp.getDouble(var,0.0); // parse as Double // -- valid economy (unlikely, but allow negative) return EventDataLayout.formatEconomy(kpl, dec, rd); } else if (fmt.startsWith("T")) { // -- Temperature String dec = fmt.substring(1); double C = rtp.getDouble(var,0.0); // parse as Double if (EventData.isValidTemperature(C)) { // -- valid temperature String tempS = EventDataLayout.formatTemperature(C, dec, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { // -- invalid temperature return rc.getBlankFiller(); } } else if (fmt.startsWith("V")) { // -- Volume String dec = fmt.substring(1); double L = rtp.getDouble(var,0.0); // parse as Double // -- valid volume (unlikely, but allow negative) return EventDataLayout.formatVolume(L, dec, rd); } else if (fmt.startsWith("P")) { // -- Pressure String dec = fmt.substring(1); double kPa = rtp.getDouble(var,0.0); // parse as Double // -- valid pressure (can be negative) return EventDataLayout.formatPressure(kPa, dec, rd); } else if (fmt.startsWith("L")) { // -- GeoPoint (lat/lon) String dec = fmt.substring(1); GeoPoint gp = new GeoPoint(rtp.getString(var,"")); if (gp.isValid()) { // -- valid GeoPoint return gp.toString(dec, '/', rd.getLocale()); } else { // -- invalid GeoPoint return rc.getBlankFiller(); } } else if (fmt.startsWith("A")) { // -- Altitude (meters) String dec = fmt.substring(1); double M = rtp.getDouble(var,0.0); // parse as Double Account.AltitudeUnits altUnits = Account.getAltitudeUnits(acct); double alt = altUnits.convertFromMeters(M); return EventDataLayout.formatDouble(alt, dec, "0"); } else if (fmt.startsWith("H")) { // -- Hours/Seconds (hh:mm:ss) String dec = fmt.substring(1); int ef = EventDataLayout.getElapsedFormat(dec, StringTools.ELAPSED_FORMAT_HHMMSS); String valS = rtp.getString(var,""); long sec = (valS.indexOf(".") < 0)? StringTools.parseLong(valS,0L) : // assume seconds Math.round(StringTools.parseDouble(valS,0.0) * 3600.0); // assume hours return new ColumnValue(EventDataLayout.formatElapsedTime(sec,ef)).setSortKey(sec); } else if (fmt.startsWith("M") || // Mass fmt.startsWith("F") || // Force fmt.startsWith("R") || // Area fmt.startsWith("C") ) {// Currency // -- Generic Double String dec = fmt.substring(1); double val = rtp.getDouble(var,0.0); // parse as Double return EventDataLayout.formatDouble(val, dec, "0"); } else { // -- Unknown, assume String return rtp.getString(var,""); } } else { Print.logWarn("Not an RTProperties instance"); } } return ""; } public String getTitle(ReportData rd, ReportColumn rc) { String arg = StringTools.trim(rc.getArg()); // "varName:fmt" int p = arg.indexOf(":"); String var = (p >= 0)? arg.substring(0,p).trim() : arg; String fmt = (p >= 0)? arg.substring(p+1).trim() : ""; I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); if (!StringTools.isBlank(var)) { return var; } else { return i18n.getString("EventDataLayout.attachmentValue","Value"); } } }); // -- Device-ID this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String deviceID = ed.getDeviceID(); if (arg.startsWith("admin")) { // "admin", "adminView", "adminEdit" // wrap in link to Device Admin page //Print.logInfo("Found admin arg: '" + arg + "'"); ColumnValue cv = new ColumnValue(deviceID); RequestProperties reqState = rd.getRequestProperties(); URIArg devAdminURL = WebPageAdaptor.MakeURL(reqState.getBaseURI(),"dev.info"); // Constants.PAGE_DEVICE_INFO); String target = null; boolean button = false; devAdminURL.addArg("device" , deviceID); // Constants.PARM_DEVICE, devID); devAdminURL.addArg("page_cmd" , "selectDev"); // CommonServlet.PAGE_COMMAND, DeviceInfo.COMMAND_INFO_SEL_DEVICE); if (arg.equalsIgnoreCase("adminEdit")) { devAdminURL.addArg("d_subedit", "edit"); // DeviceInfo.PARM_SUBMIT_EDIT, "edit"); } else { devAdminURL.addArg("d_subview", "view"); // DeviceInfo.PARM_SUBMIT_VIEW, "view"); } cv.setLinkURL(devAdminURL.toString(),target,button); return cv; } else { return deviceID; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.deviceID","Device-ID"); } }); // -- Device IMEI this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_IMEI) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getImeiNumber(); // may be blank } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceIMEI","{0}\nIMEI/ESN/etc.",devTitles); } }); // -- Device UniqueID this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_UNIQUE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getUniqueID(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceUniqueID","{0}\nUniqueID",devTitles); } }); // -- Device Mobile ID (value following UniqueID prefix) this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_MODEM_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getModemID(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceMobileID","{0}\nModemID",devTitles); } }); // -- Device Description this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getDescription(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceDescription","{0}\nDescription",devTitles); } }); // -- Device Display Name this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_NAME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getDisplayName(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceDisplayName","{0}\nName",devTitles); } }); // -- Device Battery-Level/Volta this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_BATTERY_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { double level = dev.getLastBatteryLevel(); if (level <= 0.0) { // -- not specified return rc.getBlankFiller(); } else if (level <= 1.0) { // -- percent 0..1 return Math.round(level*100.0) + "%"; // percent } else { // -- >1.0 Assume volts? or integer percent? boolean assumeVolts = false; if (assumeVolts) { return EventDataLayout.formatDouble(level, arg, "0.0") + "v"; // volts } else { return Math.round(level) + "%"; // percent } } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.deviceBatteryLevel","Last\nBattery\nLevel"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_BATTERY_VOLTS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { double volts = dev.getLastBatteryVolts(); if (volts <= 0.0) { // -- not specified return rc.getBlankFiller(); } else { // -- volts return EventDataLayout.formatDouble(volts, arg, "0.0"); // volts } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.deviceBatteryVolts","Last\nBattery\nVolts"); } }); // -- Device VehicleID this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_VIN) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getVehicleID(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.deviceVehicleID","Vehicle ID"); } }); // -- Device License Plate this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_LICENSE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { return dev.getLicensePlate(); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.deviceLicense","{0}\nLicense",devTitles); } }); // -- Device Phone# this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_PHONE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev == null) { return rc.getBlankFiller(); } String ph = dev.getFixedContactPhone(); String phDig = StringTools.stripNonDigitChars(ph); if (StringTools.isBlank(phDig)) { ph = dev.getSimPhoneNumber(); phDig = StringTools.stripNonDigitChars(ph); if (StringTools.isBlank(phDig)) { return rc.getBlankFiller(); } } String target = null; boolean button = false; ColumnValue cv = new ColumnValue(); cv.setValue(ph); cv.setLinkURL("tel:"+phDig,target,button); // 555-1234 return cv; } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("EventDataLayout.devicePhone","{0}\nPhone#",devTitles); } }); // -- Device creation date/time this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_CREATION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); long ts = dev.getCreationTime(); if (ts > MINIMUM_REASONABLE_TIMESTAMP) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return cv; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.deviceCreationTime","Device Create\nTime"); } }); // -- (Preferred) Group-ID this.addColumnTemplate(new DataColumnTemplate(DATA_GROUP_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); if (dev != null) { String gid = dev.getGroupID(); return gid; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.groupID","Group-ID"); } }); // -- Event timestamp Date/Time this.addColumnTemplate(new DataColumnTemplate(DATA_DATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTimestamp(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); //Account a = rd.getAccount(); //TimeZone tz = (a != null)? TimeZone.getTimeZone(a.getTimeZone()) : null; TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getDateFormat(rd.getPrivateLabel()), tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.date","Date"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTimestamp(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); //Account a = rd.getAccount(); //TimeZone tz = (a != null)? TimeZone.getTimeZone(a.getTimeZone()) : null; TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); return dt.format(rl.getTimeFormat(rd.getPrivateLabel()), tz); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.time","Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTimestamp(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dateTime","Date/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTimestamp(); return String.valueOf(ts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.timestamp","Timestamp") + "\n(Epoch)"; } }); // -- Event creation Date/Time this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_DATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getCreationTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); //Account a = rd.getAccount(); //TimeZone tz = (a != null)? TimeZone.getTimeZone(a.getTimeZone()) : null; TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getDateFormat(rd.getPrivateLabel()), tz); long ca = ed.getCreationAge(); // (creationTime - timestamp) ReportLayout.AgeColorRange acr = rd.getCreationAgeColorRange(ca); ColumnValue ccv = (new ColumnValue(dtFmt)).setSortKey(ts); return ReportLayout.SetColumnValueAgeColor(ccv,acr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createDate","Insert\nDate"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_TIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getCreationTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); //Account a = rd.getAccount(); //TimeZone tz = (a != null)? TimeZone.getTimeZone(a.getTimeZone()) : null; TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getTimeFormat(rd.getPrivateLabel()), tz); long ca = ed.getCreationAge(); // (creationTime - timestamp) ReportLayout.AgeColorRange acr = rd.getCreationAgeColorRange(ca); ColumnValue ccv = (new ColumnValue(dtFmt)).setSortKey(ts); return ReportLayout.SetColumnValueAgeColor(ccv,acr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createTime","insert\nTime"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getCreationTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); long ca = ed.getCreationAge(); // (creationTime - timestamp) ReportLayout.AgeColorRange acr = rd.getCreationAgeColorRange(ca); ColumnValue ccv = (new ColumnValue(dtFmt)).setSortKey(ts); return ReportLayout.SetColumnValueAgeColor(ccv,acr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createDateTime","Insert\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getCreationTime(); long ca = ed.getCreationAge(); // (creationTime - timestamp) ReportLayout.AgeColorRange acr = rd.getCreationAgeColorRange(ca); ColumnValue ccv = (new ColumnValue(ts)).setSortKey(ts); return ReportLayout.SetColumnValueAgeColor(ccv,acr); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createTimestamp","Insert\nTimestamp") + "\n(Epoch)"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_AGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ca = ed.getCreationAge(); // (creationTime - timestamp) int fmt = EventDataLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); String caFmt = EventDataLayout.formatElapsedTime(ca,fmt); ReportLayout.AgeColorRange acr = rd.getCreationAgeColorRange(ca); ColumnValue ccv = (new ColumnValue(caFmt)).setSortKey(ca); return ReportLayout.SetColumnValueAgeColor(ccv,acr); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createAge","Creation Age"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_MILLIS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getCreationMillis(); if (StringTools.isBlank(arg)) { // default as-is } else if (arg.equalsIgnoreCase("frac") || arg.equalsIgnoreCase("fraction")) { ts = ts % 1000L; // milliseconds only } else if (arg.equalsIgnoreCase("sec") || arg.equalsIgnoreCase("seconds")) { ts = ts / 1000L; // seconds only } return String.valueOf(ts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.createMillis","Creation\nMillisecond"); } }); // -- Status Code/Description this.addColumnTemplate(new DataColumnTemplate(DATA_STATUS_CODE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()).toLowerCase(); EventData ed = (EventData)obj; int sc = ed.getStatusCode(); if (StringTools.isBlank(arg) || (arg.indexOf("color") >= 0) ) { // color, decColor, decimalColor String scCode = arg.startsWith("dec")? String.valueOf(sc) : // decColor, decimalColor ("0x" + StringTools.toHexString((long)sc,16)); // color, hexColor StatusCodeProvider scp = ed.getStatusCodeProvider(rd.getPrivateLabel()); if (scp == null) { return scCode; } else if (StringTools.isBlank(scp.getForegroundColor()) && StringTools.isBlank(scp.getBackgroundColor()) ) { return scCode; } else { ColumnValue cv = new ColumnValue(); cv.setValue(scCode); cv.setForegroundColor(scp.getForegroundColor()); cv.setBackgroundColor(scp.getBackgroundColor()); return cv; } } else if (arg.startsWith("dec")) { return String.valueOf(sc); } else { // arg.equalsIgnoreCase("noColor") return "0x" + StringTools.toHexString((long)sc,16); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.statusCode","Status#"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STATUS_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; if (StringTools.isBlank(arg) || arg.equalsIgnoreCase("color")) { StatusCodeProvider scp = ed.getStatusCodeProvider(rd.getPrivateLabel()); if (scp == null) { String scDesc = "0x" + StringTools.toHexString((long)ed.getStatusCode(),16); return scDesc; } else { String scDesc = scp.getDescription(rd.getLocale()); String scFG = scp.getForegroundColor(); String scBG = scp.getBackgroundColor(); if (StringTools.isBlank(scFG) && StringTools.isBlank(scBG) ) { return scDesc; } else { ColumnValue cv = new ColumnValue(); cv.setValue(scDesc); cv.setForegroundColor(scFG); cv.setBackgroundColor(scBG); return cv; } } } else { // arg.equalsIgnoreCase("noColor") String scDesc = ed.getStatusCodeDescription(rd.getPrivateLabel()); return scDesc; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.statusDescription","Status"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PUSHPIN) { // EXPERIMENTAL! (the icons produced by this code section may not exactly match // those produced on the actual map by the JavaScript functions. public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; RequestProperties reqState = rd.getRequestProperties(); BasicPrivateLabel bpl = rd.getPrivateLabel(); OrderedMap iconMap = reqState.getMapProviderIconMap(); int ppNdx = ed.getPushpinIconIndex(null/*iconSelector*/, iconMap, false/*isFleet*/, bpl); PushpinIcon ppi = reqState.getPushpinIcon(ppNdx); String iconURL = (ppi != null)? ppi.getIconEvalURL(ed,rowNdx) : ""; ColumnValue cv = new ColumnValue().setImageURL(iconURL); return cv; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.pushpin","Pushpin"); } }); // -- Entity ID this.addColumnTemplate(new DataColumnTemplate(DATA_ENTITY_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getEntityID(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.entityID","Entity-ID"); } }); // -- Entity Description this.addColumnTemplate(new DataColumnTemplate(DATA_ENTITY_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String aid = ed.getAccountID(); String eid = ed.getEntityID(); return Device.getEntityDescription(aid, eid, EntityManager.EntityType.TRAILER.getIntValue()); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.entityDescription","Entity\nDescription"); } }); // -- Driver this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getDriverID(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.driverID","Driver-ID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; // -- Event Driver ID String drvID = ed.getDriverID(); // -- default Driver ID //if (StringTools.isBlank(drvID)) { // <-- commented-out [2.5.8-B09] // Device dev = ed.getDevice(); // drvID = (dev != null)? dev.getDriverID() : null; //} // -- Driver Description String desc = drvID; if (!StringTools.isBlank(drvID)) { try { Driver driver = Driver.getDriver(ed.getAccount(),drvID); desc = (driver != null)? driver.getDescription() : drvID; } catch (DBException dbe) { desc = drvID; } } return desc; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.driverDescription","Driver\nDescription"); } }); // -- Driver Status this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_STATUS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; long drvStat = ed.getDriverStatus(); if (drvStat <= Driver.DutyStatus_UNKNOWN) { return rc.getBlankFiller(); } else if (StringTools.isBlank(arg) || arg.equalsIgnoreCase("desc")) { Driver.DutyStatus ds = Driver.getDutyStatus(drvStat); if (ds != null) { return ds.toString(rd.getLocale()); } else { return String.valueOf(drvStat); } } else { return String.valueOf(drvStat); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.driverStatus","Driver\nStatus"); } }); // -- Driver Message this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_MESSAGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getDriverMessage(); // may be blank } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.driverMessage","Driver\nMessage"); } }); // -- Message Date/Time this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getMessageTimestamp(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.messageDateTime","Message\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getMessageTimestamp(); return String.valueOf(ts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.messageTimestamp","Message\nTimestamp") + "\n(Epoch)"; } }); // -- Message ID this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long id = ed.getMessageID(); return String.valueOf(id); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.messageID","Message\nID"); } }); // -- Message Status this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_STATUS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long mst = ed.getMessageStatus(); return String.valueOf(mst); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.messageStatus","Message\nStatus"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_STATUS_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); int mst = ed.getMessageStatus(); return DCServerFactory.Garmin_getMessageStatusDescription(locale, mst); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.messageStatusDesc","Message\nStatus"); } }); // -- JobNumber this.addColumnTemplate(new DataColumnTemplate(DATA_JOB_NUMBER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getJobNumber(); // may be blank } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.jobNumber","Job\nNumber"); } }); // -- RFID Tag (Bar Code) this.addColumnTemplate(new DataColumnTemplate(DATA_RFID_TAG) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getRfidTag(); // may be blank } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.rfidTag","RFID/Bar\nCode"); } }); // -- Sample ID/Index this.addColumnTemplate(new DataColumnTemplate(DATA_SAMPLE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getSampleID(); // may be blank } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.sampleID","Sample\nID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SAMPLE_INDEX) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return String.valueOf(ed.getSampleIndex()); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.sampleIndex","Sample\nIndex"); } }); // -- ETA date/time this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getEtaTimestamp(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaDateTime","ETA\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getEtaTimestamp(); return String.valueOf(ts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaTimestamp","ETA\nTimestamp") + "\n(Epoch)"; } }); // -- ETA Unique ID this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_UNIQUE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getEtaUniqueID(); return String.valueOf(ts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaUniqueID","ETA\nUniqueID"); } }); // -- ETA Distance this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getEtaDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaDistance","ETA\nDistance") + "\n${distanceUnits}"; } }); // -- ETA Latitude this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getEtaLatitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLatitude(lat, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaLat","ETA\nLat"); } }); // -- ETA Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lon = ed.getEtaLongitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLongitude(lon, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaLon","ETA Lon"); } }); // -- ETA Latitude/Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_ETA_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getEtaLatitude(); double lon = ed.getEtaLongitude(); if (GeoPoint.isValid(lat,lon)) { arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DMS, locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DM , locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; String latStr = GeoPoint.formatLatitude( lat, fmt , locale); String lonStr = GeoPoint.formatLongitude(lon, fmt , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.etaLatLon","ETA Lat/Lon"); } }); // -- Stop Unique ID this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_UNIQUE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long id = ed.getStopID(); return String.valueOf(id); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopUniqueID","Stop\nUniqueID"); } }); // -- Stop Status this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_STATUS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long sst = ed.getStopStatus(); return String.valueOf(sst); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopStatus","Stop\nStatus"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_STATUS_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); int sst = ed.getStopStatus(); return DCServerFactory.Garmin_getStopStatusDescription(locale, sst); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopStatusDesc","Stop\nStatus"); } }); // -- Stop Index this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_INDEX) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; int ndx = ed.getStopIndex(); return String.valueOf(ndx); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopIndex","Stop\nIndex"); } }); // -- General applied pressure /* this.addColumnTemplate(new DataColumnTemplate(DATA_APPLIED_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getAppliedPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa > 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.applyPressure","Appled Press.") + "\n${pressureUnits}"; } }); */ // -- GPS Age this.addColumnTemplate(new DataColumnTemplate(DATA_GPS_AGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long gpsAge = ed.getGpsAge(); //if (gpsAge >= GPS_AGE_THRESHOLD_1) { // return (new ColumnValue(gpsAge)).setForegroundColor(GPS_AGE_COLOR_1); // .setFontStyleItalic(); //} else //if (gpsAge >= GPS_AGE_THRESHOLD_2) { // return (new ColumnValue(gpsAge)).setForegroundColor(GPS_AGE_COLOR_2); //} else { ReportLayout.AgeColorRange acr = rd.getGpsAgeColorRange(gpsAge); if (acr != null) { ColumnValue gcv = new ColumnValue(gpsAge); return ReportLayout.SetColumnValueAgeColor(gcv,acr); } else { return String.valueOf(gpsAge); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.gpsAge","GPS\nAge"); } }); // -- Latitude this.addColumnTemplate(new DataColumnTemplate(DATA_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getLatitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLatitude(lat, fmt , locale); } long gpsAge = ed.getGpsAge(); //if (gpsAge >= GPS_AGE_THRESHOLD_1) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_1); // .setFontStyleItalic(); //} else //if (gpsAge >= GPS_AGE_THRESHOLD_2) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_2); //} else ReportLayout.AgeColorRange acr = rd.getGpsAgeColorRange(gpsAge); if (acr != null) { ColumnValue gcv = new ColumnValue(valStr); return ReportLayout.SetColumnValueAgeColor(gcv,acr); } else if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.lat","Lat"); } }); // -- Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lon = ed.getLongitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLongitude(lon, fmt , locale); } long gpsAge = ed.getGpsAge(); //if (gpsAge >= GPS_AGE_THRESHOLD_1) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_1); // .setFontStyleItalic(); //} else //if (gpsAge >= GPS_AGE_THRESHOLD_2) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_2); //} else ReportLayout.AgeColorRange acr = rd.getGpsAgeColorRange(gpsAge); if (acr != null) { ColumnValue gcv = new ColumnValue(valStr); return ReportLayout.SetColumnValueAgeColor(gcv,acr); } else if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.lon","Lon"); } }); // -- Latitude/Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getLatitude(); double lon = ed.getLongitude(); if (GeoPoint.isValid(lat,lon)) { arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DMS, locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DM , locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; String latStr = GeoPoint.formatLatitude( lat, fmt , locale); String lonStr = GeoPoint.formatLongitude(lon, fmt , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } long gpsAge = ed.getGpsAge(); //if (gpsAge >= GPS_AGE_THRESHOLD_1) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_1); // .setFontStyleItalic(); //} else //if (gpsAge >= GPS_AGE_THRESHOLD_2) { // return (new ColumnValue(valStr)).setForegroundColor(GPS_AGE_COLOR_2); //} else ReportLayout.AgeColorRange acr = rd.getGpsAgeColorRange(gpsAge); if (acr != null) { ColumnValue gcv = new ColumnValue(valStr); return ReportLayout.SetColumnValueAgeColor(gcv,acr); } else if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.latLon","Lat/Lon"); } }); // -- GPS Fix Type ("Unknown", "None", "2D", "3D") this.addColumnTemplate(new DataColumnTemplate(DATA_GPSFIX_TYPE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); return ed.getGpsFixTypeDescription(locale); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.gpsFixType","Fix Type"); } }); // -- GPS Fix Status (bitmask defined by DCS) this.addColumnTemplate(new DataColumnTemplate(DATA_GPSFIX_STATUS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()).toLowerCase(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); long fixStat = ed.getGpsFixStatus(); if (arg.equalsIgnoreCase("dec")) { return String.valueOf(fixStat); } else if (arg.equalsIgnoreCase("hex")) { return "0x" + StringTools.toHexString(fixStat,16); } else if (arg.equalsIgnoreCase("bin")) { return "b" + StringTools.toBinaryString(fixStat,32,null).toString(); } else { return String.valueOf(fixStat); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.gpsFixStatus","Fix Status"); } }); // -- Accuracy this.addColumnTemplate(new DataColumnTemplate(DATA_ACCURACY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); if (ed.hasHorzAccuracy()) { double horzAcc = ed.getHorzAccuracy(); // meters Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); double horzAccU = altUnits.convertFromMeters(horzAcc); return EventDataLayout.formatDouble(horzAccU, arg, "0"); } else { double horzAcc = ed.getHorzAccuracy(true); // estimate fro HDOP if (horzAcc > 0.0) { Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); double horzAccU = altUnits.convertFromMeters(horzAcc); return "*" + EventDataLayout.formatDouble(horzAccU, arg, "0"); } } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.accuracy","Accuracy") + "\n${accuracyUnits}"; } }); // -- Altitude this.addColumnTemplate(new DataColumnTemplate(DATA_ALTITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); double alt = altUnits.convertFromMeters(ed.getAltitude()); return EventDataLayout.formatDouble(alt, arg, "0"); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.altitude","Altitude") + "\n${altitudeUnits}"; } }); // -- Speed Limit (posted speed) this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_LIMIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getSpeedLimitKPH(); // KPH if (kph > 0.0) { Account a = rd.getAccount(); double speed = Account.getSpeedUnits(a).convertFromKPH(kph); return EventDataLayout.formatDouble(speed, arg, "0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.speedLimit","Speed Limit") + "\n${speedUnits}"; } }); // -- Over Speed Limit (posted speed) this.addColumnTemplate(new DataColumnTemplate(DATA_OVER_SPEED_LIMIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double spdKPH = ed.getSpeedKPH(); // km/h double limKPH = ed.getSpeedLimitKPH(); // km/h if (limKPH > 0.0) { Account a = rd.getAccount(); double deltaKPH = spdKPH - limKPH; // negative if under speed limit double over = Account.getSpeedUnits(a).convertFromKPH(deltaKPH); return EventDataLayout.formatDouble(over, arg, "0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.overSpeedLimit","Over Limit") + "\n${speedUnits}"; } }); // -- Speed this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getSpeedKPH(); // KPH if (kph > 0.0) { Account a = rd.getAccount(); double speed = Account.getSpeedUnits(a).convertFromKPH(kph); return EventDataLayout.formatDouble(speed, arg, "0"); } else { return "0 "; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.speed","Speed") + "\n${speedUnits}"; } }); // -- Speed/Heading this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_HEADING) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getSpeedKPH(); // KPH if (kph > 0.0) { Account a = rd.getAccount(); double speed = Account.getSpeedUnits(a).convertFromKPH(kph); String speedStr = EventDataLayout.formatDouble(speed, arg, "0"); String headStr = GeoPoint.GetHeadingString(ed.getHeading(),rd.getLocale()).toUpperCase(); if (headStr.length() == 1) { headStr += " "; } return speedStr + " " + headStr; } else { return "0 "; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.speed","Speed") + "\n${speedUnits}"; } }); // -- Speed with units this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_UNITS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getSpeedKPH(); // KPH if (kph > 0.0) { Account a = rd.getAccount(); String unitAbbr = Account.getSpeedUnits(a).toString(rd.getLocale()); double speed = Account.getSpeedUnits(a).convertFromKPH(kph); String speedStr = EventDataLayout.formatDouble(speed, arg, "0"); String headStr = GeoPoint.GetHeadingString(ed.getHeading(),rd.getLocale()).toUpperCase(); if (headStr.length() == 1) { headStr += " "; } return speedStr + unitAbbr + " " + headStr; } else { return "0 "; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.speed","Speed"); } }); // -- Heading this.addColumnTemplate(new DataColumnTemplate(DATA_HEADING) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getSpeedKPH(); // KPH if (kph > 0.0) { double heading = ed.getHeading(); if (!StringTools.isBlank(arg)) { return EventDataLayout.formatDouble(heading, arg, "0"); } else { return GeoPoint.GetHeadingString(heading,rd.getLocale()).toUpperCase(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { return GeoPoint.GetHeadingTitle(rd.getLocale()); } }); // -- #Satellites this.addColumnTemplate(new DataColumnTemplate(DATA_SATELLITES) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; int satCount = ed.getSatelliteCount(); if (satCount > 0) { return String.valueOf(satCount); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.satelliteCount","Sat\nCount"); } }); // -- Distance this.addColumnTemplate(new DataColumnTemplate(DATA_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.distance","Distance") + "\n${distanceUnits}"; } }); // -- Odometer this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; //Device dev = ed.getDevice(); double odom = ed.getOdometerKM(); // kilometers if (odom > 0.0) { // -- has odometer value odom = ed.getOdometerWithOffsetKM(); } else { // -- use distance as odometer value odom = ed.getDistanceKM(); // may still be 0.0 odom += ed.getOdometerOffsetKM(null); } return EventDataLayout.formatKM(odom, arg, rd); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.odometer","Odometer") + "\n${distanceUnits}"; } }); // -- Report distance this.addColumnTemplate(new DataColumnTemplate(DATA_REPORT_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; //Device dev = ed.getDevice(); double dist = ed.getReportDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.reportDistance","Report\nDistance") + "\n${distanceUnits}"; } }); // -- Stopped time/elapsed /* this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; if (ed.isStopped()) { long ts = ed.getMotionChangeTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopDateTime","Stop\nDate/Time") + "\n${timezone}"; } }); */ /* this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; if (ed.isStopped()) { // -- stopped long ts = ed.getMotionChangeTime(); if (ts > 0L) { long ds = ed.getTimestamp() - ts; if (ds >= 0L) { int fmt = EventDataLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); return new ColumnValue(EventDataLayout.formatElapsedTime(ds,fmt)).setSortKey(ds); } } // -- last stopped time not initialized or invalid return rc.getBlankFiller(); } else { // -- moving return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stopElapsed","Stop Elapsed"); } }); */ // -- Cell Latitude this.addColumnTemplate(new DataColumnTemplate(DATA_CELL_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getCellLatitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLatitude(lat, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cellLat","Cell\nLat"); } }); // -- Cell Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_CELL_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lon = ed.getCellLongitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLongitude(lon, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cellLon","Cell\nLon"); } }); // -- Cell Latitude/Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_CELL_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getCellLatitude(); double lon = ed.getCellLongitude(); if (GeoPoint.isValid(lat,lon)) { arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DMS, locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DM , locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; String latStr = GeoPoint.formatLatitude( lat, fmt , locale); String lonStr = GeoPoint.formatLongitude(lon, fmt , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cellLatLon","Cell\nLat/Lon"); } }); // -- Cell Accuracy this.addColumnTemplate(new DataColumnTemplate(DATA_CELL_ACCURACY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double acc = ed.getCellAccuracy(); // meters if (acc > 0) { // -- convert to same units used for altitude Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); acc = altUnits.convertFromMeters(acc); return EventDataLayout.formatDouble(acc, arg, "0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cellAccuracy","Cell Accuracy") + "\n${accuracyUnits}"; } }); // -- Best Latitude this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getBestLatitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLatitude(lat, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.bestLat","Lat"); } }); // -- Best Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lon = ed.getBestLongitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLongitude(lon, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.bestLon","Lon"); } }); // -- Best Latitude/Longitude this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getBestLatitude(); double lon = ed.getBestLongitude(); if (GeoPoint.isValid(lat,lon)) { arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DMS, locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { String latStr = GeoPoint.formatLatitude( lat, GeoPoint.SFORMAT_DM , locale); String lonStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; String latStr = GeoPoint.formatLatitude( lat, fmt , locale); String lonStr = GeoPoint.formatLongitude(lon, fmt , locale); valStr = latStr + GeoPoint.PointSeparator + lonStr; } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.bestLatLon","Lat/Lon"); } }); // -- Best Accuracy this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_ACCURACY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double acc = ed.getBestAccuracy(); // meters if (acc > 0) { Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); acc = altUnits.convertFromMeters(acc); return EventDataLayout.formatDouble(acc, arg, "0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.bestAccuracy","Accuracy") + "\n${accuracyUnits}"; } }); // -- Input Mask/State this.addColumnTemplate(new DataColumnTemplate(DATA_INPUT_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()).toLowerCase(); EventData ed = (EventData)obj; long input = ed.getInputMask(); // bit mask if (arg.startsWith("hex")) { int blen = StringTools.parseInt(arg.substring("hex".length()),16); return "0x" + StringTools.toHexString(input,blen); } else { String s = StringTools.toBinaryString((int)input); // 32-bit int slen = s.length(); int blen = StringTools.parseInt(arg,16); int len = (slen >= blen)? (slen - blen) : 0; return s.substring(len, slen); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.inputBitMask","Inputs\n(BitMask)"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_INPUT_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { int argBit = StringTools.parseInt(rc.getArg(),0); EventData ed = (EventData)obj; int input = (int)ed.getInputMask(); // bit mask I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); if ((input & (1 << argBit)) != 0) { return i18n.getString("EventDataLayout.bitTrue" ,"On" ); } else { return i18n.getString("EventDataLayout.bitFalse","Off"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); String bitStr = String.valueOf(argBit); return i18n.getString("EventDataLayout.inputBitValue","Input\n#{0}", bitStr); } }); // -- Output Mask/State this.addColumnTemplate(new DataColumnTemplate(DATA_OUTPUT_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; int output = (int)ed.getOutputMask(); // bit mask String s = StringTools.toBinaryString(output); int slen = s.length(); int blen = StringTools.parseInt(arg,8); int len = (slen >= blen)? (slen - blen) : 0; return s.substring(len, slen); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.outputBitMask","Outputs\n(BitMask)"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_OUTPUT_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { int argBit = StringTools.parseInt(rc.getArg(),0); EventData ed = (EventData)obj; int output = (int)ed.getOutputMask(); // bit mask I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); if ((output & (1 << argBit)) != 0) { return i18n.getString("EventDataLayout.bitTrue" ,"On" ); } else { return i18n.getString("EventDataLayout.bitFalse","Off"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); String bitStr = String.valueOf(argBit); return i18n.getString("EventDataLayout.outputBitValue","Output\n#{0}", bitStr); } }); // -- Seatbelt Mask/State this.addColumnTemplate(new DataColumnTemplate(DATA_SEATBELT_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String s = StringTools.toBinaryString(ed.getSeatbeltMask()); int slen = s.length(); int blen = StringTools.parseInt(arg,4); int len = (slen >= blen)? (slen - blen) : 0; return s.substring(len, slen); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.seatbeltBitMask","Seatbelts\n(BitMask)"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SEATBELT_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; EventData ed = (EventData)obj; if ((ed.getSeatbeltMask() & argMask) != 0L) { return i18n.getString("EventDataLayout.bitTrue" ,"On" ); } else { return i18n.getString("EventDataLayout.bitFalse","Off"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; return i18n.getString("EventDataLayout.seatbeltBitValue","Seatbelt\n{0}", EventData.GetSeatbeltMaskDescription(argMask,rd.getLocale())); } }); // -- Door Mask/State this.addColumnTemplate(new DataColumnTemplate(DATA_DOOR_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String s = StringTools.toBinaryString(ed.getDoorStateMask()); int slen = s.length(); int blen = StringTools.parseInt(arg,5); int len = (slen >= blen)? (slen - blen) : 0; return s.substring(len, slen); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.doorStateBitMask","Door State\n(BitMask)"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DOOR_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; EventData ed = (EventData)obj; if ((ed.getDoorStateMask() & argMask) != 0L) { return i18n.getString("EventDataLayout.bitTrue" ,"On" ); } else { return i18n.getString("EventDataLayout.bitFalse","Off"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; return i18n.getString("EventDataLayout.doorStateBitValue","Door\n{0}", EventData.GetDoorMaskDescription(argMask,rd.getLocale())); } }); // -- Lights Mask/State this.addColumnTemplate(new DataColumnTemplate(DATA_LIGHTS_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String s = StringTools.toBinaryString(ed.getLightsStateMask()); int slen = s.length(); int blen = StringTools.parseInt(arg,5); int len = (slen >= blen)? (slen - blen) : 0; return s.substring(len, slen); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.lightsStateBitMask","Lights State\n(BitMask)"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_LIGHTS_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; EventData ed = (EventData)obj; if ((ed.getLightsStateMask() & argMask) != 0L) { return i18n.getString("EventDataLayout.bitTrue" ,"On" ); } else { return i18n.getString("EventDataLayout.bitFalse","Off"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); int argBit = StringTools.parseInt(rc.getArg(),0); long argMask = (argBit >= 0)? (1L << argBit) : 0L; return i18n.getString("EventDataLayout.lightsStateBitValue","Lights\n{0}", EventData.GetDoorMaskDescription(argMask,rd.getLocale())); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_IGNITION_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); EventData ed = (EventData)obj; Device dev = ed.getDevice(); String arg = StringTools.trim(rc.getArg()); boolean ckSC = arg.equalsIgnoreCase("sc")? true : false; int ign = (dev != null)? dev.getIgnitionStateAsOfEvent(ed,ckSC) : -1; switch (ign) { case 0: return i18n.getString("EventDataLayout.bitFalse","Off"); case 1: return i18n.getString("EventDataLayout.bitTrue" ,"On" ); default: //return i18n.getString("EventDataLayout.notAvailable","n/a"); return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.ignitionState","Ignition\nState"); } }); // -- Geozone-ID this.addColumnTemplate(new DataColumnTemplate(DATA_GEOZONE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getGeozoneID(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.geozoneID","Geozone-ID"); } }); // -- Geozone Description this.addColumnTemplate(new DataColumnTemplate(DATA_GEOZONE_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; if (arg.equalsIgnoreCase("id")) { return ed.getGeozoneID(); } else if (arg.equalsIgnoreCase("desc") || arg.equalsIgnoreCase("description")) { return ed.getGeozoneDescription(); } else { return ed.getGeozoneDescription(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.geozoneDescription","Geozone\nDescription"); } }); // -- Address this.addColumnTemplate(new DataColumnTemplate(DATA_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; String addr = ed.getAddress(); return addr; } public String getTitle(ReportData rd, ReportColumn rc) { RequestProperties reqState = rd.getRequestProperties(); String addrTitles[] = (reqState != null)? reqState.getAddressTitles() : null; String addrTitle = (ListTools.size(addrTitles) > 0)? addrTitles[0] : null; if (!StringTools.isBlank(addrTitle)) { return addrTitle; } else { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.address","Address"); } } }); // -- City this.addColumnTemplate(new DataColumnTemplate(DATA_CITY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getCity(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.city","City"); } }); // -- State/Province this.addColumnTemplate(new DataColumnTemplate(DATA_STATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getStateProvince(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.stateProvince","State\nProvince"); } }); // -- Country this.addColumnTemplate(new DataColumnTemplate(DATA_COUNTRY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getCountry(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.country","Country"); } }); // -- Subdivision this.addColumnTemplate(new DataColumnTemplate(DATA_SUBDIVISION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getSubdivision(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.subdivision","Subdivision"); } }); // -- Atmosphere this.addColumnTemplate(new DataColumnTemplate(DATA_BAROMETER) { // -- Barometric pressure public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getBarometer(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa > 0.0) { //double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); double pressure = Account.PressureUnits.MMHG.convertFromKPa(kPa); // always convert to mmHg //return StringTools.format(pressure, "#0.00"); return EventDataLayout.formatDouble(pressure, arg, "0.00"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.barometer","Barometer") + "\nmmHg"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_AMBIENT_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getAmbientTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.ambientTemp","Ambient\nTemp"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CABIN_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getCabinTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cabinTemp","Cabin\nTemp"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CARGO_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getCargoTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.cargoTemp","Cargo\nTemp"); } }); // -- Temperature (report index starts at '1') this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(0); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#1"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(1); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#2"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_3) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(2); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#3"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_4) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(3); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#4"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_5) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(4); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#5"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_6) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(5); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#6"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_7) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(6); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#7"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_THERMO_8) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tempC = ed.getThermoAverage(7); // degrees 'C' String tempS = EventDataLayout.formatTemperature(tempC, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(tempC * 100.0)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.temperature","Temp") + "\n#8"; } }); // -- Battery level (% or volts?) this.addColumnTemplate(new DataColumnTemplate(DATA_BATTERY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getBatteryLevel(); double volts = ed.getBatteryVolts(); if (level > 0.0) { if (level <= 1.0) { // -- assume range 0..1 return Math.round(level*100.0) + "%"; // percent } else { // -- assume range 0..100 return EventDataLayout.formatDouble(level, arg, "0.0") + "v"; // volts } } else if (volts > 0.0) { return EventDataLayout.formatDouble(volts, arg, "0.0") + "v"; // volts } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.BatteryLevel","Battery\nLevel"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BATTERY_VOLTS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getBatteryVolts(); if (level > 0.0) { return EventDataLayout.formatDouble(level, arg, "0.0"); // volts } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.BatteryVolts","Battery\nVolts"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BATTERY_PERCENT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getBatteryLevel(); if (level > 0.0) { // -- adjust to range 0..1 double pct100 = (level <= 1.0)? (level*100.0) : level; return Math.round(pct100) + "%"; // integer percent } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.BatteryPercent","Battery\n%"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_LAST_BATTERY_PCT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); double level = dev.getLastBatteryLevel(); if (level > 0.0) { double pct100 = (level <= 1.0)? (level*100.0) : level; return Math.round(pct100) + "%"; // integer percent } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.latestBatteryPercent","Latest\nBatt %"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BATTERY_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getBatteryTemp(); if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.batteryTemp","Battery\nTemp."); } }); // -- Analog this.addColumnTemplate(new DataColumnTemplate(DATA_ANALOG_0) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getAnalog0(); return EventDataLayout.formatDouble(level, arg, "0.0"); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.analog0","Analog 0"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ANALOG_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getAnalog1(); return EventDataLayout.formatDouble(level, arg, "0.0"); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.analog1","Analog 1"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ANALOG_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getAnalog2(); return EventDataLayout.formatDouble(level, arg, "0.0"); // volts } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.analog2","Analog 2"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ANALOG_3) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double level = ed.getAnalog3(); return EventDataLayout.formatDouble(level, arg, "0.0"); // volts } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.analog3","Analog 3"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PULSE_COUNT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double pc = ed.getPulseCount(); if (arg.startsWith("/")) { // TODO: move this into "formatDouble"? arg = arg.substring(1); if ((arg.length() == 1) && Character.isDigit(arg.charAt(0))) { int dec = StringTools.parseInt(arg.substring(0,1),0); double div = Math.pow(10.0,(double)dec); pc /= div; } } return EventDataLayout.formatDouble(pc, arg, "0.0"); // count * gain } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.pulseCount","Pulse\nCount"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FREQUENCY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); // "MHz,0.0" EventData ed = (EventData)obj; double hz = ed.getFrequencyHz(); double val = hz; int p = arg.indexOf(","); if (p >= 0) { String fmt = arg.substring(0,p); if (fmt.equalsIgnoreCase("Hz")) { val = hz; } else if (fmt.equalsIgnoreCase("kHz")) { val = hz / 1000.0; } else if (fmt.equalsIgnoreCase("MHz")) { val = hz / 1000000.0; } else if (fmt.equalsIgnoreCase("GHz")) { val = hz / 1000000000.0; } else if (fmt.equalsIgnoreCase("THz")) { val = hz / 1000000000000.0; } arg = arg.substring(p+1); } return EventDataLayout.formatDouble(val, arg, "0.0"); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String arg = rc.getArg(); int p = arg.indexOf(","); String units = "Hz"; if (p >= 0) { String fmt = arg.substring(0,p); if (fmt.equalsIgnoreCase("Hz")) { units = "Hz"; } else if (fmt.equalsIgnoreCase("kHz")) { units = "kHz"; } else if (fmt.equalsIgnoreCase("MHz")) { units = "MHz"; } else if (fmt.equalsIgnoreCase("GHz")) { units = "GHz"; } else if (fmt.equalsIgnoreCase("THz")) { units = "THz"; } else { units = "Hz"; } } return i18n.getString("EventDataLayout.frequency","Frequency\n{0}",units); } }); // -- Fuel Capacity (device record) this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_CAPACITY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); double vol_1 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_1); // liters [tank #1] double vol_2 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_2); // liters [tank #2] double vol = vol_1 + vol_2; if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelCapacity","Fuel Capacity") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_CAPACITY_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_1; double vol = dev.getFuelCapacity(tank); // liters [tank #1] if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelCapacity1","Fuel Capacity #1") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_CAPACITY_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_2; double vol = dev.getFuelCapacity(tank); // liters [tank #1] if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelCapacity2","Fuel Capacity #2") + "\n${volumeUnits}"; } }); // -- Fuel Level this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); double fuelLevel_1 = ed.getFuelLevel(Device.FuelTankIndex.TANK_1,true/*estimate*/); double fuelLevel_2 = ed.getFuelLevel(Device.FuelTankIndex.TANK_2,true/*estimate*/); double capacity_1 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_1); // liters [tank #1] double capacity_2 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_2); // liters [tank #2] if ((fuelLevel_2 <= 0.0) || (capacity_2 <= 0.0) || (capacity_1 <= 0.0)) { // -- assume that fuelLevel for tank #2 is not available if (fuelLevel_1 > 0.0) { String rtn = Math.round(fuelLevel_1*100.0) + "%"; if (fuelLevel_2 > 0.0) { // -- add an indicator that fuelLevel_2 was not used in the calculation rtn += "*"; } return rtn; } else if (fuelLevel_1 < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } else { return rc.getBlankFiller(); // "n/a" } } else { double volume = (fuelLevel_1 * capacity_1) + (fuelLevel_2 * capacity_2); double fuelLevel = volume / (capacity_1 + capacity_2); return Math.round(fuelLevel*100.0) + "%"; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelPercent","Fuel%"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_1; double fuelLevel = ed.getFuelLevel(tank,true/*estimate*/); if (fuelLevel > 0.0) { return Math.round(fuelLevel*100.0) + "%"; } else if (fuelLevel < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } else { return rc.getBlankFiller(); // "n/a" } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelPercent1","Fuel% #1"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_2; double fuelLevel = ed.getFuelLevel(tank); if (fuelLevel > 0.0) { return Math.round(fuelLevel*100.0) + "%"; } else if (fuelLevel < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelPercent2","Fuel2%"); } }); // -- Fuel Volume this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL_VOL) { // see also DATA_FUEL_CAPACITY public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); double fuelLevel_1 = ed.getFuelLevel(Device.FuelTankIndex.TANK_1,true/*estimate*/); double fuelLevel_2 = ed.getFuelLevel(Device.FuelTankIndex.TANK_2,true/*estimate*/); // [2.6.3-B19] double capacity_1 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_1); // liters [tank #1] double capacity_2 = dev.getFuelCapacity(Device.FuelTankIndex.TANK_2); // liters [tank #2] if ((fuelLevel_1 <= 0.0) && (fuelLevel_2 <= 0.0)) { return rc.getBlankFiller(); } else if ((capacity_1 <= 0.0) && (capacity_2 <= 0.0)) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } double litres = 0.0; if ((fuelLevel_1 > 0.0) && (capacity_1 > 0.0)) { litres += (fuelLevel_1 * capacity_1); } if ((fuelLevel_2 > 0.0) && (capacity_2 > 0.0)) { litres += (fuelLevel_2 * capacity_2); } double vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(litres); return EventDataLayout.formatDouble(vol, arg, "0.0"); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelLevelVolume","Fuel Vol") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL_VOL_1) { // see also DATA_FUEL_CAPACITY public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_1; double capacity = dev.getFuelCapacity(tank); // liters [tank #1] double percent = ed.getFuelLevel(tank,true/*estimate*/); // estimate if ((percent <= 0.0) && (capacity <= 0.0)) { return rc.getBlankFiller(); } else if (capacity <= 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } else { double liters = capacity * percent; // liters double vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(liters); return EventDataLayout.formatDouble(vol, arg, "0.0"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelLevelVolume1","Fuel Vol #1") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL_VOL_2) { // see also DATA_FUEL_CAPACITY public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); Device.FuelTankIndex tank = Device.FuelTankIndex.TANK_2; double capacity = dev.getFuelCapacity(tank); // liters [tank #2] double percent = ed.getFuelLevel(tank); // device.getActualFuelLevel(2,ed.getFuelLevel2()); if ((percent <= 0.0) && (capacity <= 0.0)) { return rc.getBlankFiller(); } else if (capacity <= 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.notAvailable","n/a"); } else { double liters = capacity * percent; // liters double vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(liters); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelLevelVolume2","Fuel Vol 2") + "\n${volumeUnits}"; } }); // -- Fuel Total this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TOTAL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getFuelTotal(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelTotal","Total Fuel") + "\n${volumeUnits}"; } }); // -- Fuel Remaining this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_REMAIN) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getFuelRemain(true/*estimate*/); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelRemain","Remaining Fuel") + "\n${volumeUnits}"; } }); // -- Fuel used on trip/idle/engineOn this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TRIP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getFuelTrip(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelTrip","Trip Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_IDLE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getFuelIdle(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelIdle","Idle Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_ENGINE_ON) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getFuelEngineOn(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelEngineOn","Engine On Fuel") + "\n${volumeUnits}"; } }); // -- Fuel Economy this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_ECONOMY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double econ = ed.getFuelEconomy(); // kilometers per liter if (econ > 0.0) { econ = Account.getEconomyUnits(rd.getAccount()).convertFromKPL(econ); return EventDataLayout.formatDouble(econ, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelEcon","Fuel Econ") + "\n${economyUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_ECONOMY_TYPE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; Device.FuelEconomyType econType = Device.FuelEconomyType.EVENT_ECONOMY; Locale locale = rd.getPrivateLabel().getLocale(); String typeStr = arg.equalsIgnoreCase("abbr")? econType.getAbbrev(locale) : econType.toString(locale); return typeStr; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelEconType","Fuel Econ\nType"); } }); // -- Fuel pressure this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getFuelPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa != 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); //return StringTools.format(pressure, "#0.0"); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelPressure","Fuel Press.") + "\n${pressureUnits}"; } }); // -- Fuel usage rate this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_RATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double lph = ed.getFuelUsage(); // Litre per Hour if (lph != 0.0) { double rate = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(lph); //return StringTools.format(rate, "#0.0"); return EventDataLayout.formatDouble(rate, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.fuelRate","Fuel Rate") + "\n${volumeUnits}/Hr"; } }); // -- PTO this.addColumnTemplate(new DataColumnTemplate(DATA_PTO_ENGAGED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; boolean pto = ed.getPtoEngaged(); return ComboOption.getYesNoText(rd.getLocale(), pto); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.ptoEngaged","PTO\nEngaged"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PTO_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getPtoHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.ptoHours","PTO\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PTO_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getPtoDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.ptoDistance","PTO Distance") + "\n${distanceUnits}"; } }); // -- Work hours/distance/shift this.addColumnTemplate(new DataColumnTemplate(DATA_WORK_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getWorkHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.workHours","Work\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_WORK_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getWorkDistanceKM(); // kilometers if (dist > 0.0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.workDistance","Work Distance") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_WORK_SHIFT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); // "0000:2,0800:1,1800:2" / "0000:2,0100:3,0900:1,1700:2" EventData ed = (EventData)obj; TimeZone tz = rd.getTimeZone(); long timestamp = ed.getTimestamp(); DateTime dt = new DateTime(timestamp, tz); int evTOD = (dt.getHour24() * 60) + dt.getMinute(); String shiftNum = null; String shifts[] = StringTools.split(arg,','); for (String S : shifts) { int p = S.indexOf(':'); if (p < 0) { continue; } int shTOD = DateTime.MinuteOfDay(S.substring(0,p),tz); String shftN = S.substring(p+1).trim(); if ((shTOD < 0) || (shftN == null)) { continue; } if (evTOD < shTOD) { break; } shiftNum = shftN; // my be updated on next pass } if (shiftNum != null) { return shiftNum; } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.workShift","Work\nShift"); } }); // -- Service this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getServiceDistanceKM(); // kilometers if (dist > 0.0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.serviceDistance","Service Distance") + "\n${distanceUnits}"; } }); // -- Vehicle Battery Volts this.addColumnTemplate(new DataColumnTemplate(DATA_VEH_BATTERY_VOLTS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double volts = ed.getVBatteryVolts(); if (volts > 0.0) { //return StringTools.format(volts,"#0.0"); return EventDataLayout.formatDouble(volts, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.vBatteryVolts","Veh Batt.\nVolts"); } }); // -- Throttle Position this.addColumnTemplate(new DataColumnTemplate(DATA_THROTTLE_POSITION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double throttlePos = ed.getThrottlePos(); if (throttlePos > 0.0) { return Math.round(throttlePos*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.throttlePosition","Throttle\nPosition"); } }); // -- Air (temp/pressure) this.addColumnTemplate(new DataColumnTemplate(DATA_INTAKE_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getIntakeTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.intakeTemp","Intake\nTemp."); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_AIR_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getAirPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa != 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); //return StringTools.format(pressure, "#0.0"); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.airPressure","Air Press.") + "\n${pressureUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_AIR_FILTER_PRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getAirFilterPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa != 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); //return StringTools.format(pressure, "#0.0"); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.airFilterPressure","Air Filt\nPress.") + "\n${pressureUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_MASS_AIR_FLOW) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double rate = ed.getMassAirFlowRate(); // Grams/Second if (rate != 0.0) { return EventDataLayout.formatDouble(rate, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.massAirFlow","Mass Air Flow") + "\ng/sec"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TURBO_PRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getTurboPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa != 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.turboPressure","Turbo\nPress.") + "\n${pressureUnits}"; } }); // -- Tire (pressure/temperature) this.addColumnTemplate(new DataColumnTemplate(DATA_TIRE_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); // tire index //int tireNdx = StringTools.parseInt(arg,-1); int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String fmt = "0"; Account.PressureUnits pu = Account.getPressureUnits(rd.getAccount()); EventData ed = (EventData)obj; if (tireNdx >= 0) { double P = ed.getTirePressure(tireNdx); if (TireState.IsValidPressure(P)) { return EventDataLayout.formatDouble(pu.convertFromKPa(P), fmt, "0"); } } else { Map TSM = ed.getTireState(); if (!ListTools.isEmpty(TSM)) { StringBuffer sb = new StringBuffer(); for (Integer tsKey : TSM.keySet()) { TireState TS = TSM.get(tsKey); if ((TS != null) && TS.hasActualPressure()) { if (sb.length() > 0) { sb.append(","); } double P = TS.getActualPressure(); sb.append(EventDataLayout.formatDouble(pu.convertFromKPa(P), fmt, "0")); } } if (sb.length() > 0) { return sb.toString(); } } } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { String arg = rc.getArg(); // index int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String tNdxS = (tireNdx >= 0)? TireState.ToAxleTireString(true,tireNdx) : ""; I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tirePressure","Tire Press {0}",tNdxS) + "\n${pressureUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TIRE_TEMPERATURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); // tire index int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String fmt = "0"; // tire temperatures don't need decimal granularity EventData ed = (EventData)obj; if (tireNdx >= 0) { double T = ed.getTireTemperature(tireNdx); if (TireState.IsValidTemperature(T)) { return EventDataLayout.formatTemperature(T, fmt, rd, "?"); } } else { Map TSM = ed.getTireState(); if (!ListTools.isEmpty(TSM)) { StringBuffer sb = new StringBuffer(); for (Integer tsKey : TSM.keySet()) { TireState TS = TSM.get(tsKey); if ((TS != null) && TS.hasActualTemperature()) { if (sb.length() > 0) { sb.append(","); } double T = TS.getActualTemperature(); sb.append(EventDataLayout.formatTemperature(T, fmt, rd, "?")); } } if (sb.length() > 0) { return sb.toString(); } } } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { String arg = rc.getArg(); // tire index int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String tNdxS = (tireNdx >= 0)? TireState.ToAxleTireString(true,tireNdx) : ""; I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tireTemperature","Tire Temp {0}",tNdxS); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TIRE_PRESSTEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); // tire index int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String fmt = "0"; Account.PressureUnits pu = Account.getPressureUnits(rd.getAccount()); EventData ed = (EventData)obj; if (tireNdx >= 0) { StringBuffer sb = new StringBuffer(); double P = ed.getTirePressure(tireNdx); double T = ed.getTireTemperature(tireNdx); if (TireState.IsValidPressure(P) || TireState.IsValidTemperature(T)) { if (TireState.IsValidPressure(P)) { sb.append(EventDataLayout.formatDouble(pu.convertFromKPa(P), fmt, "0")); } sb.append("/"); if (TireState.IsValidTemperature(T)) { sb.append(EventDataLayout.formatTemperature(T, fmt, rd, "?")); } return sb.toString(); } } else { Map TSM = ed.getTireState(); if (!ListTools.isEmpty(TSM)) { StringBuffer sb = new StringBuffer(); for (Integer tsKey : TSM.keySet()) { TireState TS = TSM.get(tsKey); if ((TS != null) && (TS.hasActualPressure() || TS.hasActualTemperature())) { if (sb.length() > 0) { sb.append(","); } double P = TS.getActualPressure(); if (TireState.IsValidPressure(P)) { sb.append(EventDataLayout.formatDouble(pu.convertFromKPa(P), fmt, "0")); } sb.append("/"); double T = TS.getActualTemperature(); if (TireState.IsValidTemperature(T)) { sb.append(EventDataLayout.formatTemperature(T, fmt, rd, "?")); } } } if (sb.length() > 0) { return sb.toString(); } } } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { String arg = rc.getArg(); // index int tireNdx = TireState.ParseTireIndex(arg); // returns "-1" if invalid String tNdxS = (tireNdx >= 0)? TireState.ToAxleTireString(true,tireNdx) : ""; I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tirePressure","Tire {0}",tNdxS) + "\n${pressureUnits}/${temperatureUnits}"; } }); // -- Tank level this.addColumnTemplate(new DataColumnTemplate(DATA_TANK_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double tankLevel = ed.getTankLevel(); if (tankLevel > 0.0) { return Math.round(tankLevel*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tankPercent","Tank%"); } }); // -- Fault Code(s) this.addColumnTemplate(new DataColumnTemplate(DATA_FAULT_CODES) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; String faultStr = ed.getFaultCode(); // RTProperties String if (StringTools.isBlank(faultStr)) { long fault = ed.getOBDFault(); // if (fault == 0L) { return rc.getBlankFiller(); } else { return DTOBDFault.GetFaultString(fault); } } else { return DTOBDFault.GetFaultString(new RTProperties(faultStr)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.j1708Faults","OBD Faults"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FAULT_CODE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; String faultS = ed.getFaultCode(); // RTProperties String long fault = !StringTools.isBlank(faultS)? DTOBDFault.EncodeFault(faultS) : ed.getOBDFault(); if (fault == 0L) { // -- not defined return rc.getBlankFiller(); } else if (DTOBDFault.IsJ1708(fault)) { // -- J1708/J1587 if (DTOBDFault.HasDescriptionProvider(fault)) { Locale locale = rd.getLocale(); if (arg.equalsIgnoreCase("link")) { ColumnValue cv = new ColumnValue(DTOBDFault.GetFaultString(fault)); RequestProperties reqState = rd.getRequestProperties(); URIArg j1587URL = WebPageAdaptor.MakeURL(reqState.getBaseURI(),"j1587.show"); // Constants.PAGE_J1587_SHOW); String target = null; boolean button = false; j1587URL.addArg("mid" , DTOBDFault.DecodeSystem(fault)); j1587URL.addArg("spid", DTOBDFault.DecodeSPID(fault)); j1587URL.addArg("fmi" , DTOBDFault.DecodeFMI(fault)); cv.setLinkURL("javascript:openResizableWindow('"+j1587URL+"','J1587Desc',320,100);",target,button); return cv; } else if (arg.equalsIgnoreCase("desc")) { String desc = DTOBDFault.GetFaultDescription(fault, locale); return desc; } else { return DTOBDFault.GetFaultString(fault); } } else { return DTOBDFault.GetFaultString(fault); } } else if (DTOBDFault.IsOBDII(fault)) { // -- OBDII DTC if (DTOBDFault.HasDescriptionProvider(fault)) { // -- TODO: get DTC description return DTOBDFault.GetFaultString(fault); } else { return DTOBDFault.GetFaultString(fault); } } else { return DTOBDFault.GetFaultString(fault); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.j1708Fault","OBD Fault"); // + "\nMID/PID/FMI"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_MALFUNCTION_LAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; boolean mil = ed.getMalfunctionLamp(); return ComboOption.getOnOffText(rd.getLocale(), mil); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.malfunctionLamp","Malfunction\nLamp"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_LAST_FAULT_CODES) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); return dev.getLastFaultCode().toUpperCase(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.latestFaultCodes","Fault Codes"); } }); // -- Airbag indicator lamp this.addColumnTemplate(new DataColumnTemplate(DATA_AIRBAG_LAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; boolean abl = ed.getAirbagLamp(); return ComboOption.getOnOffText(rd.getLocale(), abl); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.airbagLamp","Airbag\nLamp"); } }); // -- ABS indicator lamp this.addColumnTemplate(new DataColumnTemplate(DATA_ABS_LAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; boolean abl = ed.getAbsLamp(); return ComboOption.getOnOffText(rd.getLocale(), abl); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.absLamp","ABS\nLamp"); } }); // -- Brake lamps this.addColumnTemplate(new DataColumnTemplate(DATA_BRAKE_LAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; boolean bkl = ed.getBrakeLamp(); return ComboOption.getOnOffText(rd.getLocale(), bkl); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.brakeLamp","Brake\nLamps"); } }); // -- Engine oil level this.addColumnTemplate(new DataColumnTemplate(DATA_OIL_LEVEL) { // -- Oil pressure (http://en.wikipedia.org/wiki/KPa) public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double oilLvl = ed.getOilLevel(); // % if (oilLvl > 0.0) { return Math.round(oilLvl*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.oilLevel","Oil Level"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_OIL_PRESSURE) { // -- Oil pressure (http://en.wikipedia.org/wiki/KPa) public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getOilPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa > 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); //return StringTools.format(pressure, "#0.0"); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.oilPressure","Oil Press.") + "\n${pressureUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_OIL_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getOilTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.oilTemp","Oil\nTemp."); } }); // -- Engine this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_RPM) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long rpm = ed.getEngineRpm(); if (rpm >= 0L) { return String.valueOf(rpm); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineRpm","Engine\nRPM"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_TORQUE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double torq = ed.getEngineTorque(); if (torq <= 0.0) { // -- not specified return rc.getBlankFiller(); } else if (arg.equalsIgnoreCase("%") || arg.equalsIgnoreCase("pct") || arg.equalsIgnoreCase("percent") ) { // -- Explicit Percent return Math.round(torq*100.0) + "%"; } else if (arg.equalsIgnoreCase("nm")) { // -- Explicit Newton-Meters return EventDataLayout.formatDouble(torq,"","0.0") + " Nm"; } else if (torq < 1.0) { // -- Implied Percent return Math.round(torq*100.0) + "%"; } else { // -- Implied Newton-Meters return EventDataLayout.formatDouble(torq,"","0.0") + " Nm"; } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = rc.getArg(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineTorquePercent","Engine\nTorque"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); double hours = ed.getEngineHours(); hours += dev.getEngineHoursOffset(); if (hours > 0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineHours","Engine\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_ON_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getEngineOnHours(); if (hours > 0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineOnHours","Engine On\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_LOAD) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double engineLoad = ed.getEngineLoad(); if (engineLoad > 0.0) { return Math.round(engineLoad*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineLoad","Engine\nLoad %"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_IDLE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getIdleHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.idleHours","Idle\nHours"); } }); // -- Transmission temp/gear this.addColumnTemplate(new DataColumnTemplate(DATA_TRANS_GEAR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double gear = ed.getTransGear(); if (gear == 0.0) { return rc.getBlankFiller(); // neutral or unknown } else if ((gear % 1.0) != 0.0) { return EventDataLayout.formatDouble(gear, arg, "0.0"); } else { return EventDataLayout.formatDouble(gear, arg, "0"); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.transGear","Trans\nGear"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRANS_OIL_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getTransOilTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.transOilTemp","Trans Oil\nTemp."); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_OIL_COOLER_IN_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getOilCoolerInTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.oilCoolerInTemp","Oil Cooler\nInlet Temp"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_OIL_COOLER_OUT_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getOilCoolerOutTemp(); // degrees 'C' if (EventData.isValidTemperature(C)) { String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.oilCoolerOutTemp","Oil Cooler\nOutlet Temp"); } }); // -- Coolant this.addColumnTemplate(new DataColumnTemplate(DATA_COOLANT_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getCoolantPressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa > 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.coolantPressure","Coolant\nPressure"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_COOLANT_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double coolantLevel = ed.getCoolantLevel(); if (coolantLevel > 0.0) { return Math.round(coolantLevel*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.coolantLevel","Coolant\nLevel"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_COOLANT_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getCoolantTemp(); // degrees 'C' if (!EventData.isValidTemperature(C)) { // -- temperature is invalid return rc.getBlankFiller(); } else if (C == 0.0) { // -- consider 0 to be an invaild temperature return rc.getBlankFiller(); } else { // -- valid (and non zero) temperature String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.coolantTemp","Coolant\nTemp."); } }); // -- Engine Temp this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_TEMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double C = ed.getEngineTemp(); // degrees 'C' if (!EventData.isValidTemperature(C)) { // -- temperature is invalid return rc.getBlankFiller(); } else if (C == 0.0) { // -- consider 0 to be an invaild temperature return rc.getBlankFiller(); } else { // -- valid (and non zero) temperature String tempS = EventDataLayout.formatTemperature(C, arg, rd, null); return new ColumnValue(tempS).setSortKey((long)(C * 100.0)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.engineTemp","Engine\nTemp."); } }); // -- Brake this.addColumnTemplate(new DataColumnTemplate(DATA_BRAKE_G_FORCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double bgf = ed.getBrakeGForce(); if (bgf != 0.0) { return EventDataLayout.formatDouble(bgf, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.brakeGForce","Braking\nG-force"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BRAKE_FORCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double bgf = ed.getBrakeGForce(); double kphs = ((Account.MPSS_PER_G_FORCE * bgf) / 1000.0) * 3600.0; // km/hr/sec if (kphs != 0.0) { return EventDataLayout.formatKM(kphs, arg, rd); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.brakeForce","Braking\n${distanceUnits}/hr/sec"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BRAKE_PRESSURE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kPa = ed.getBrakePressure(); // kPa (kilopascals = 1000 Newtons per Square-Meter) if (kPa != 0.0) { double pressure = Account.getPressureUnits(rd.getAccount()).convertFromKPa(kPa); //return StringTools.format(pressure, "#0.0"); return EventDataLayout.formatDouble(pressure, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.brakePressure","Brake Press.") + "\n${pressureUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BRAKE_POSITION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double throttlePos = ed.getBrakePos(); if (throttlePos > 0.0) { return Math.round(throttlePos*100.0) + "%"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.brakePosition","Brake\nPosition"); } }); // -- Acceleration/Deceleration (meters per seconds-squared) this.addColumnTemplate(new DataColumnTemplate(DATA_ACCELERATION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; double A = ed.getAcceleration(); if (!Double.isNaN(A)) { if (arg.startsWith("G") || arg.startsWith("g")) { A *= Accelerometer.G_PER_MPSS_FORCE; // G = MSS * G/MSS arg = arg.substring(1).trim(); if (arg.startsWith(",")) { arg = arg.substring(1).trim(); } } return EventDataLayout.formatDouble(A, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = StringTools.trim(rc.getArg()); boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; } Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); Accelerometer.ForceUnits fUnits = Accelerometer.GetForceUnitsForName(G?"G":"MPSS"); // not null return i18n.getString("EventDataLayout.acceleration","Accel\n({0})",fUnits.toString(locale)); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ACCEL_XYZ) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; Accelerometer A = ed.getAccelerometer(); if ((A != null) && A.isValid()) { boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; arg = arg.substring(1).trim(); if (arg.startsWith(",")) { arg = arg.substring(1).trim(); } } String fmt = EventDataLayout.getArgFormatString(arg,null); return A.toString(null,G,fmt); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = StringTools.trim(rc.getArg()); boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; } Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); Accelerometer.ForceUnits fUnits = Accelerometer.GetForceUnitsForName(G?"G":"MPSS"); // not null return i18n.getString("EventDataLayout.accelerometerXYZ","Accelerometer\nXYZ ({0})",fUnits.toString(locale)); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ACCEL_MAGNITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; Accelerometer A = ed.getAccelerometer(); if ((A != null) && A.hasMagnitude()) { boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; arg = arg.substring(1).trim(); if (arg.startsWith(",")) { arg = arg.substring(1).trim(); } } double mag = A.getMagnitude(G); return EventDataLayout.formatDouble(mag, arg, "0.000"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = StringTools.trim(rc.getArg()); boolean G = arg.equalsIgnoreCase("G"); Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); Accelerometer.ForceUnits fUnits = Accelerometer.GetForceUnitsForName(G?"G":"MPSS"); // not null return i18n.getString("EventDataLayout.accelerometerMagnitude","Accelerometer\nMagnitude ({0})",fUnits.toString(locale)); } }); // -- Maximum Impact Magnitude this.addColumnTemplate(new DataColumnTemplate(DATA_IMPACT_MAGNITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); EventData ed = (EventData)obj; double maxMSS = ed.getImpactMagnitude(); // m/s/s if (maxMSS != 0.0) { boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; arg = arg.substring(1).trim(); if (arg.startsWith(",")) { arg = arg.substring(1).trim(); } } double mag = G? Accelerometer.Convert_MSS_to_G(maxMSS) : maxMSS; return EventDataLayout.formatDouble(mag, arg, "0.00000"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = StringTools.trim(rc.getArg()); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); boolean G = false; if (arg.startsWith("G") || arg.startsWith("g")) { G = true; } Locale locale = rd.getLocale(); Accelerometer.ForceUnits fUnits = Accelerometer.GetForceUnitsForName(G?"G":"MPSS"); // not null return i18n.getString("EventDataLayout.impactMagnitude","Impact\nMagnitude\n({0})",fUnits.toString(locale)); } }); // -- last connect/checkin date/time (Device record) this.addColumnTemplate(new DataColumnTemplate(DATA_CHECKIN_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { long nowSec = DateTime.getCurrentTimeSec(); String fmtArg = rc.getArg(); EventData ed = (EventData)obj; // -- last check-in time long ts = 0L; Device dev = ed.getDevice(); if (dev != null) { ts = dev.getLastTotalConnectTime(); // may be "0" if (ts <= 0L) { // -- no last check-in time, verify by looking for last event try { EventData lastEv = dev.getLastEvent(-1L, false); if (lastEv != null) { ts = lastEv.getTimestamp(); } } catch (DBException dbe) { // -- error retrieving event record } } } long ageSec = nowSec - ts; // may be <0 if event is in the future if (ts > MINIMUM_REASONABLE_TIMESTAMP) { // -- last check-in time ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); //if (ageSec >= DateTime.HourSeconds(24)) { cv.setForegroundColor("red"); } ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return cv; } else if (ts == 0L) { // -- never? I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String never = i18n.getString("EventDataLayout.never","never"); ColumnValue cv = new ColumnValue(never).setSortKey(ts); //cv.setForegroundColor("red"); ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return cv; } else { // -- unreasonable date? return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.lastCheckinTime","Last Check-In\nTime"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CHECKIN_AGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { long nowSec = DateTime.getCurrentTimeSec(); String arg = rc.getArg(); EventData ed = (EventData)obj; // -- last check-in time long ts = 0L; Device dev = ed.getDevice(); if (dev != null) { ts = dev.getLastTotalConnectTime(); if (ts <= 0L) { try { EventData lastEv = dev.getLastEvent(-1L, false); if (lastEv != null) { ts = lastEv.getTimestamp(); } } catch (DBException dbe) { // -- error retrieving event record } } } long ageSec = nowSec - ts; // may be <0 if event is in the future if (ts > nowSec) { // -- event is in the future (relative to current time) I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String future = i18n.getString("EventDataLayout.future","Future"); ColumnValue cv = new ColumnValue(future).setSortKey(ageSec); cv.setForegroundColor("orange"); return cv; } else if (ts > MINIMUM_REASONABLE_TIMESTAMP) { // -- event is in the past long days = (ageSec / DateTime.DaySeconds(1)); long hours = (ageSec % DateTime.DaySeconds(1)) / DateTime.HourSeconds(1); long min = (ageSec % DateTime.HourSeconds(1)) / DateTime.MinuteSeconds(1); StringBuffer sb = new StringBuffer(); sb.append(days ).append("d "); if (hours < 10) { sb.append("0"); } sb.append(hours).append("h "); if (min < 10) { sb.append("0"); } sb.append(min ).append("m"); ColumnValue cv = new ColumnValue(sb.toString()).setSortKey(ageSec); //if (ageSec >= DateTime.HourSeconds(24)) { cv.setForegroundColor("red"); } ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return cv; } else if (ts == 0L) { // -- never? I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String never = i18n.getString("EventDataLayout.never","never"); ColumnValue cv = new ColumnValue(never).setSortKey(ts); //cv.setForegroundColor("red"); ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return cv; } else { // -- unreasonable date? return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.lastCheckinAge","Since Last\nCheck-In"); } }); // -- custom field value (Device record) this.addColumnTemplate(new DataColumnTemplate(DATA_CUSTOM_FIELD) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Device dev = ed.getDevice(); String value = (dev != null)? dev.getCustomAttribute(arg) : ""; if (!StringTools.isBlank(value)) { return value; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { String arg = rc.getArg(); String desc = rd.getPrivateLabel().getStringProperty(BasicPrivateLabel.PROP_DeviceInfo_custom_ + arg, null); if (!StringTools.isBlank(desc)) { if (desc.length() > 12) { int p = desc.lastIndexOf(" "); if (p > 0) { desc = desc.substring(0,p) + "\n" + desc.substring(p+1); } } return desc; } else { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.customAttribute","Custom\nAttribute"); } } }); // -- DataSource/RawData (unparsed event packet) this.addColumnTemplate(new DataColumnTemplate(DATA_DATA_SOURCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getDataSource(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dataSource","Data Source"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_RAW_DATA) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; return ed.getRawData(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.rawData","Raw Data"); } }); // -- "Trip" values this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_START_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTripStartTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripStartDateTime","Trip Start\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_STOP_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String fmtArg = rc.getArg(); EventData ed = (EventData)obj; long ts = ed.getTripStopTime(); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String fmtStr = !StringTools.isBlank(fmtArg)? fmtArg : rl.getDateTimeFormat(rd.getPrivateLabel()); String dtFmt = dt.format(fmtStr, tz); return new ColumnValue(dtFmt).setSortKey(ts); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripStopDateTime","Trip Stop\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getTripDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripDistance","Trip\nDistance") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_IDLE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getTripIdleHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripIdleHours","Trip Idle\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_MAX_SPEED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double kph = ed.getTripMaxSpeedKPH(); // KPH if (kph > 0.0) { Account a = rd.getAccount(); double speed = Account.getSpeedUnits(a).convertFromKPH(kph); return EventDataLayout.formatDouble(speed, arg, "0"); } else { return "0 "; } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripMaxSpeed","Trip Max\nSpeed") + "\n${speedUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_MAX_RPM) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long rpm = ed.getTripMaxRpm(); if (rpm >= 0L) { return String.valueOf(rpm); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripMaxRpm","Trip Max\nRPM"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_START_LAT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lat = ed.getTripStartLatitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLatitude(lat, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLatitude(lat, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripStartLatitude","Trip Start\nLatitude"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_START_LON) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; Locale locale = rd.getLocale(); double lon = ed.getTripStartLongitude(); arg = StringTools.trim(arg); String valStr = ""; Account.LatLonFormat latlonFmt = Account.getLatLonFormat(rd.getAccount()); if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DMS) || (StringTools.isBlank(arg) && latlonFmt.isDegMinSec())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DMS, locale); } else if (arg.equalsIgnoreCase(GeoPoint.SFORMAT_DM) || (StringTools.isBlank(arg) && latlonFmt.isDegMin())) { valStr = GeoPoint.formatLongitude(lon, GeoPoint.SFORMAT_DM , locale); } else { String fmt = StringTools.isBlank(arg)? GeoPoint.SFORMAT_DEC_4 : arg; valStr = GeoPoint.formatLongitude(lon, fmt , locale); } if (!StringTools.isBlank(valStr)) { return valStr; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripStopLatitude","Trip Start\nLongitude"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TRIP_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; long tripSec = ed.getTripElapsedSeconds(); if (tripSec > 0L) { int fmt = EventDataLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); return new ColumnValue(EventDataLayout.formatElapsedTime(tripSec,fmt)).setSortKey(tripSec); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.tripElapsed","Trip Elapsed"); } }); // -- "Day" values this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_ENGINE_STARTS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; int engStarts = ed.getDayEngineStarts(); return String.valueOf(engStarts); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayEngineStarts","Day Engine\nStarts"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_IDLE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getDayIdleHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayIdleHours","Day Idle\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_FUEL_IDLE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getDayFuelIdle(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayFuelIdle","Day Idle\nFuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_WORK_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double hours = ed.getDayWorkHours(); if (hours > 0.0) { return EventDataLayout.formatDouble(hours, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayWorkHours","Day Work\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_FUEL_WORK) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getDayFuelWork(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayFuelWork","Day Work\nFuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_FUEL_PTO) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getDayFuelPTO(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayFuelPTO","Day PTO\nFuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_FUEL_TOTAL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double vol = ed.getDayFuelTotal(); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); //return StringTools.format(vol, "#0.0"); return EventDataLayout.formatDouble(vol, arg, "0.0"); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayFuelTotal","Day Total\nFuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DAY_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); EventData ed = (EventData)obj; double dist = ed.getDayDistanceKM(); // kilometers if (dist > 0) { return EventDataLayout.formatKM(dist, arg, rd); } else { return EventDataLayout.formatKM(dist, arg, rd); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); return i18n.getString("EventDataLayout.dayDistance","Day\nDistance") + "\n${distanceUnits}"; } }); // -- General Event field this.addColumnTemplate(new DataColumnTemplate(DATA_EVENT_FIELD) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { EventData ed = (EventData)obj; String fldName = rc.getArg(); DBField edFld = EventData.getFactory().getField(fldName); if (edFld != null) { Object val = ed.getFieldValue(fldName); return StringTools.trim(edFld.formatValue(val)); } else { return ""; } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); String fldName = rc.getArg(); DBField edFld = EventData.getFactory().getField(fldName); if (edFld != null) { String title = edFld.getTitle(locale); return rc.getTitle(locale, title); } else { I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String title = i18n.getString("EventDataLayout.eventField","Event\nField"); return rc.getTitle(locale, title); } } }); // -- Rule selector this.addColumnTemplate(new DataColumnTemplate(DATA_RULE_SELECTOR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { EventData ed = (EventData)obj; String ruleSel = rc.getArg(); // TODO: this should be a reference to a property value RuleFactory ruleFact = Device.getRuleFactory(); if ((ruleFact != null) && !StringTools.isBlank(ruleSel)) { try { Object result = ruleFact.evaluateSelector(ruleSel,ed); return StringTools.trim(result); } catch (RuleParseException rpe) { Print.logError("Invalid rule selector: " + ruleSel); return ""; } } else { return ""; } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); String ruleSel = rc.getArg(); I18N i18n = rd.getPrivateLabel().getI18N(EventDataLayout.class); String title = i18n.getString("EventDataLayout.ruleSelector","Rule\nSelector"); return rc.getTitle(locale, title); } }); } } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ protected static int getElapsedFormat(String arg, int dft) { /* blank */ if (StringTools.isBlank(arg)) { return dft; } /* numeric formats */ if (arg.startsWith("-1")) { return StringTools.ELAPSED_FORMAT_SS; // SSSSS } else if (arg.startsWith("0")) { return StringTools.ELAPSED_FORMAT_HHMMSS; // HH:MM:SS } else if (arg.startsWith("1")) { return StringTools.ELAPSED_FORMAT_HHMM ; // HH:MM } else if (arg.startsWith("2")) { return StringTools.ELAPSED_FORMAT_HHHhh ; // HHH.hh } else if (arg.startsWith("3")) { return StringTools.ELAPSED_FORMAT_HHHh; // HHH.h } /* String formats */ arg = arg.toLowerCase(); if (arg.equals("ss") || arg.equals("s") || arg.startsWith("sec" )) { return StringTools.ELAPSED_FORMAT_SS ; } else if (arg.equals("hhmmss") || arg.equals("hms" ) || arg.equals("hh:mm:ss")) { return StringTools.ELAPSED_FORMAT_HHMMSS; } else if (arg.equals("hhmm" ) || arg.equals("hm" ) || arg.equals("hh:mm" )) { return StringTools.ELAPSED_FORMAT_HHMM ; } else if (arg.equals("hhh.hh") || arg.equals("hh.hh") || arg.equals("h.hh" )) { return StringTools.ELAPSED_FORMAT_HHHhh ; } else if (arg.equals("hhh.h" ) || arg.equals("hh.h" ) || arg.equals("h.h" )) { return StringTools.ELAPSED_FORMAT_HHHh ; } /* else return default */ return dft; } protected static String formatElapsedTime(long elapsedSec, int fmt) { return StringTools.formatElapsedSeconds(elapsedSec, fmt); } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ }