// ---------------------------------------------------------------------------- // Copyright 2007-2013, 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 generic field definitions // ---------------------------------------------------------------------------- // Change History: // 2007/03/25 Martin D. Flynn // -Initial release // 2007/11/28 Martin D. Flynn // -Added additional 'stop' fields for motion reporting // 2007/01/10 Martin D. Flynn // -Added several new fields. // 2008/03/12 Martin D. Flynn // -Added additional decimal point options to various fields // 2008/03/28 Martin D. Flynn // -Added property/diagnostic fields // 2008/05/14 Martin D. Flynn // -Integrated Device DataTransport interface // -Added City/State/Country/Subdivision fields // 2008/06/20 Martin D. Flynn // -Added DATA_ACCOUNT_ID // 2008/10/16 Martin D. Flynn // -Added DATA_LAST_EVENT // 2009/08/23 Martin D. Flynn // -Fixed StatusCode description lookup (now first looks up account custom // status codes). // 2009/09/23 Martin D. Flynn // -Added 'startOdometer' column // 2010/04/11 Martin D. Flynn // -Added columns "serviceNotes"/"serviceRemaining"/"accountDesc"/... // 2010/06/17 Martin D. Flynn // -Added columns "stopCount", "engineHours", "ptoHours", "idleHours", etc. // 2010/09/09 Martin D. Flynn // -Added "deviceBattery" // 2011/05/13 Martin D. Flynn // -Added DATA_EVENT_INDEX // 2011/06/16 Martin D. Flynn // -Added status code/description coloring option // 2011/10/03 Martin D. Flynn // -Added DATA_STOP_FUEL, DATA_START_FUEL, DATA_FUEL_DELTA // 2011/12/06 Martin D. Flynn // -Added DATA_PLAN_DISTANCE // 2012/02/03 Martin D. Flynn // -Added DATA_ODOMETER_DELTA_AH, DATA_DRIVING_ELAPSED_AH, DATA_FUEL_TRIP_AH // 2012/04/03 Martin D. Flynn // -Changed "formatElapsedTime" to call "StringTools.formatElapsedSeconds" // -Added DATA_SERVICE_LAST_HR, DATA_SERVICE_INTERVAL_HR, DATA_SERVICE_NEXT_HR, // DATA_SERVICE_REMAINING_HR, DATA_FAULT_CODES // 2012/06/29 Martin D. Flynn // -Added DATA_STATUS_COUNT // -Initial support for DATA_GEOCORRIDOR_ID // 2012/12/24 Martin D. Flynn // -Added DATA_ENTITY_TYPE // 2013/05/28 Martin D. Flynn // -Added DATA_SPEED_DURATION // 2013/08/06 Martin D. Flynn // -Added DATA_ODOMETER_DELTA_BIT, DATA_START_ADDRESS // -Added DATA_START_GEOPOINT, DATA_START_LATITUDE, DATA_START_LONGITUDE // -Added DATA_START_FUEL_LEVEL, DATA_STOP_FUEL_LEVEL, DATA_DELTA_FUEL_LEVEL // -Added DATA_DISPLAY_NAME, DATA_DRIVER_NICKNAME, DATA_DRIVER_LICENSE_TYPE // -Added DATA_DRIVER_DEVICE_ID, DATA_DRIVER_DEVICE_DESC // -Added ability to format the driver's licenses expiration in number-of-days // ---------------------------------------------------------------------------- package org.opengts.war.report.field; 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.PushpinIcon; import org.opengts.war.tools.WebPageAdaptor; import org.opengts.war.report.*; import org.opengts.db.dmtp.PropertyKey; public class FieldLayout extends ReportLayout { // ------------------------------------------------------------------------ private static final long MIN_REASONABLE_TIMESTAMP = (new DateTime(null,2000,1,1)).getTimeSec(); // ------------------------------------------------------------------------ // Data keys // - These define what data is available (see 'FieldDataRow') and what columns will be // displayed in the table. // - Column names must only contain //'_' characters public static final String DATA_INDEX = "index"; public static final String DATA_DISPLAY_NAME = "displayName"; // field (general) public static final String DATA_ACCOUNT_ID = "accountId"; // field public static final String DATA_ACCOUNT_DESC = "accountDesc"; public static final String DATA_USER_ID = "userId"; // field public static final String DATA_USER_DESC = "userDesc"; public static final String DATA_DEVICE_ID = "deviceId"; // field public static final String DATA_DEVICE_DESC = "deviceDesc"; public static final String DATA_DEVICE_BATTERY = "deviceBattery"; public static final String DATA_VEHICLE_ID = "vehicleId"; // field public static final String DATA_LICENSE_PLATE = "licensePlate"; // field public static final String DATA_EQUIPMENT_TYPE = "equipmentType"; // field public static final String DATA_UNIQUE_ID = "uniqueId"; // field public static final String DATA_GROUP_ID = "groupId"; // field public static final String DATA_STATUS_CODE = "statusCode"; // field public static final String DATA_STATUS_DESC = "statusDesc"; public static final String DATA_STATUS_COUNT = "statusCount"; // field public static final String DATA_PUSHPIN = "pushpin"; public static final String DATA_ENTITY_ID = "entityId"; // field public static final String DATA_ENTITY_TYPE = "entityType"; // field public static final String DATA_ENTITY_DESC = "entityDesc"; // field public static final String DATA_DRIVER_ID = "driverId"; // field public static final String DATA_DRIVER_DESC = "driverDesc"; // field public static final String DATA_DRIVER_NICKNAME = "driverNickname"; // field public static final String DATA_DRIVER_STATUS = "driverStatus"; // field public static final String DATA_DRIVER_BADGEID = "driverBadge"; // field public static final String DATA_DRIVER_LICENSE = "driverLicense"; // field public static final String DATA_DRIVER_LICENSE_TYPE = "driverLicenseType"; // field public static final String DATA_DRIVER_LICENSE_EXP = "driverLicenseExp"; // field public static final String DATA_DRIVER_BIRTHDATE = "driverBirthdate"; // field public static final String DATA_DRIVER_DEVICE_ID = "driverDeviceID"; // field public static final String DATA_DRIVER_DEVICE_DESC = "driverDeviceDesc"; // field public static final String DATA_LATITUDE = "latitude"; // field public static final String DATA_LONGITUDE = "longitude"; // field public static final String DATA_GEOPOINT = "geoPoint"; // field public static final String DATA_ALTITUDE = "altitude"; // field public static final String DATA_SPEED_LIMIT = "speedLimit"; // field public static final String DATA_SPEED = "speed"; // field public static final String DATA_SPEED_HEADING = "speedH"; public static final String DATA_SPEED_UNITS = "speedU"; public static final String DATA_SPEED_DURATION = "speedDuration"; // field public static final String DATA_HEADING = "heading"; // field public static final String DATA_DISTANCE = "distance"; // field public static final String DATA_PLAN_DISTANCE = "plannedDistance"; // field public static final String DATA_ODOMETER = "odometer"; // field public static final String DATA_ODOMETER_DELTA = "odomDelta"; // field public static final String DATA_ODOMETER_DELTA_WH = "odomDeltaWH"; // field (during WorkHours) public static final String DATA_ODOMETER_DELTA_AH = "odomDeltaAH"; // field (during AfterHours) public static final String DATA_ODOMETER_DELTA_BIT = "odomDeltaBit"; // field (while bit is on) public static final String DATA_ODOMETER_OFFSET = "odomOffset"; // field public static final String DATA_EVENT_INDEX = "eventIndex"; // public static final String DATA_LAST_EVENT = "lastEvent"; public static final String DATA_SERVER_ID = "serverId"; // field (deviceCode) public static final String DATA_JOB_NUMBER = "jobNumber"; // field public static final String DATA_BEST_LATITUDE = "bestLatitude"; // field public static final String DATA_BEST_LONGITUDE = "bestLongitude"; // field public static final String DATA_BEST_GEOPOINT = "bestGeoPoint"; // field public static final String DATA_DATE = "date"; // field public static final String DATA_TIME = "time"; public static final String DATA_DATETIME = "dateTime"; public static final String DATA_TIMESTAMP = "timestamp"; // field 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_PING_DATETIME = "commandDateTime"; public static final String DATA_PING_TIMESTAMP = "commandTimestamp"; public static final String DATA_ACK_DATETIME = "ackDateTime"; public static final String DATA_ACK_TIMESTAMP = "ackTimestamp"; public static final String DATA_ADDRESS = "address"; // field public static final String DATA_CITY = "city"; // field public static final String DATA_STATE = "state"; // field public static final String DATA_COUNTRY = "country"; // field public static final String DATA_SUBDIVISION = "subdivision"; // field public static final String DATA_GEOZONE_ID = "geozoneId"; // field public static final String DATA_GEOZONE_DESC = "geozoneDesc"; public static final String DATA_GEOCORRIDOR_ID = "corridorID"; public static final String DATA_PROPERTY_KEY = "propertyKey"; // field public static final String DATA_PROPERTY_DESC = "propertyDesc"; public static final String DATA_PROPERTY_VALUE = "propertyValue"; // field public static final String DATA_DIAGNOSTIC_ERROR = "diagError"; // field public static final String DATA_DIAGNOSTIC_KEY = "diagKey"; // field public static final String DATA_DIAGNOSTIC_DESC = "diagDesc"; // field public static final String DATA_DIAGNOSTIC_VALUE = "diagValue"; // field public static final String DATA_UTILIZATION = "utilization"; // field public static final String DATA_COUNT = "count"; // field public static final String DATA_START_DATETIME = "startDateTime"; public static final String DATA_START_TIMESTAMP = "startTimestamp"; // field public static final String DATA_START_LATITUDE = "startLatitude"; // field public static final String DATA_START_LONGITUDE = "startLongitude"; // field public static final String DATA_START_GEOPOINT = "startGeoPoint"; // field public static final String DATA_START_HOURS = "startEngineHours"; // field public static final String DATA_START_ODOMETER = "startOdometer"; // field public static final String DATA_START_FUEL = "startFuel"; // field public static final String DATA_START_FUEL_LEVEL = "startFuelLevel"; // field public static final String DATA_START_ADDRESS = "startAddress"; // field public static final String DATA_STOP_DATETIME = "stopDateTime"; public static final String DATA_STOP_TIMESTAMP = "stopTimestamp"; // field public static final String DATA_STOP_LATITUDE = "stopLatitude"; // field public static final String DATA_STOP_LONGITUDE = "stopLongitude"; // field public static final String DATA_STOP_GEOPOINT = "stopGeoPoint"; // field public static final String DATA_STOP_HOURS = "stopEngineHours"; // field public static final String DATA_STOP_ODOMETER = "stopOdometer"; // field public static final String DATA_STOP_FUEL = "stopFuel"; // field public static final String DATA_STOP_FUEL_LEVEL = "stopFuelLevel"; // field public static final String DATA_STOP_ADDRESS = "stopAddress"; // field public static final String DATA_STOP_ELAPSED = "stopElapse"; // field public static final String DATA_STOP_COUNT = "stopCount"; // field public static final String DATA_STOP_COUNT_WH = "stopCountWH"; // field public static final String DATA_FUEL_DELTA = "fuelDelta"; // field public static final String DATA_DELTA_FUEL_LEVEL = "deltaFuelLevel"; // field public static final String DATA_ENTER_DATETIME = "enterDateTime"; // field public static final String DATA_ENTER_TIMESTAMP = "enterTimestamp"; // field public static final String DATA_ENTER_GEOZONE_ID = "enterGeozoneId"; // field public static final String DATA_ENTER_ADDRESS = "enterAddress"; // field public static final String DATA_EXIT_DATETIME = "exitDateTime"; // field public static final String DATA_EXIT_TIMESTAMP = "exitTimestamp"; // field public static final String DATA_EXIT_GEOZONE_ID = "exitGeozoneId"; // field public static final String DATA_EXIT_ADDRESS = "exitAddress"; // field public static final String DATA_ELAPSE_SEC = "elapseSec"; // field public static final String DATA_INSIDE_ELAPSED = "insideElapse"; // field public static final String DATA_OUTSIDE_ELAPSED = "outsideElapse"; // field public static final String DATA_DRIVING_ELAPSED = "drivingElapse"; // field public static final String DATA_DRIVING_ELAPSED_WH = "drivingElapseWH"; // field (during WorkHours) public static final String DATA_DRIVING_ELAPSED_AH = "drivingElapseAH"; // field (during AfterHours) public static final String DATA_IDLE_ELAPSED = "idleElapse"; // field public static final String DATA_AVERAGE_IDLE_HOURS = "avgIdleHours"; // field public static final String DATA_ATTACHED = "attached"; // field public static final String DATA_RULE_ID = "ruleId"; // field public static final String DATA_MESSAGE_ID = "messageId"; // field public static final String DATA_TCP_CONNECTIONS = "tcpConnections"; // field public static final String DATA_UDP_CONNECTIONS = "udpConnections"; // field public static final String DATA_CONNECTIONS = "connections"; // field public static final String DATA_IPADDRESS = "ipAddress"; // field public static final String DATA_ISDUPLEX = "isDuplex"; // field public static final String DATA_BYTES_READ = "bytesRead"; // field public static final String DATA_BYTES_WRITTEN = "bytesWritten"; // field public static final String DATA_BYTES_OVERHEAD = "bytesOverhead"; // field public static final String DATA_BYTES_TOTAL = "bytesTotal"; // field public static final String DATA_BYTES_ROUNDED = "bytesRounded"; // field public static final String DATA_EVENTS_RECEIVED = "eventsReceived"; // field public static final String DATA_ENGINE_HOURS = "engineHours"; // field getEngineHoursOffset public static final String DATA_IDLE_HOURS = "idleHours"; // field public static final String DATA_WORK_HOURS = "workHours"; // field public static final String DATA_PTO_HOURS = "ptoHours"; // field public static final String DATA_FUEL_CAPACITY = "fuelCapacity"; // field public static final String DATA_FUEL_LEVEL = "fuelLevel"; // field public static final String DATA_FUEL_TOTAL = "fuelTotal"; // field public static final String DATA_FUEL_REMAIN = "fuelRemain"; // field public static final String DATA_FUEL_TRIP = "fuelTrip"; // field public static final String DATA_FUEL_TRIP_WH = "fuelTripWH"; // field (during WorkHours) public static final String DATA_FUEL_TRIP_AH = "fuelTripAH"; // field (during AfterHours) public static final String DATA_FUEL_IDLE = "fuelIdle"; // field public static final String DATA_FUEL_IDLE_WH = "fuelIdleWH"; // field (during WorkHours) public static final String DATA_FUEL_IDLE_AH = "fuelIdleAH"; // field (during AfterHours) public static final String DATA_FUEL_WORK = "fuelWork"; // field public static final String DATA_FUEL_PTO = "fuelPTO"; // field public static final String DATA_FUEL_ECONOMY = "fuelEconomy"; // field public static final String DATA_FUEL_ECONOMY_TYPE = "fuelEconomyType"; // field public static final String DATA_ENGINE_RPM = "engineRpm"; // field 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_LAST_IPADDRESS = "lastIPAddress"; // Device record public static final String DATA_CODE_VERSION = "codeVersion"; // Device record public static final String DATA_CUSTOM_FIELD = "customField"; // Device record public static final String DATA_FAULT_CODES = "faultCodes"; // Device record public static final String DATA_COMMAND_STATE_MASK = "commandStateMask"; // Device record public static final String DATA_COMMAND_STATE_BIT = "commandStateBit"; // Device record public static final String DATA_SERVICE_LAST_HR = "serviceLastHR"; // Device record getEngineHoursOffset public static final String DATA_SERVICE_INTERVAL_HR = "serviceIntervalHR"; // Device record public static final String DATA_SERVICE_NEXT_HR = "serviceNextHR"; // Device record getEngineHoursOffset public static final String DATA_SERVICE_REMAINING_HR = "serviceRemainingHR"; // Device record public static final String DATA_SERVICE_LAST = "serviceLast"; // Device record public static final String DATA_SERVICE_INTERVAL = "serviceInterval"; // Device record public static final String DATA_SERVICE_NEXT = "serviceNext"; // Device record public static final String DATA_SERVICE_REMAINING = "serviceRemaining"; // Device record public static final String DATA_SERVICE_NOTES = "serviceNotes"; // Device record public static final String DATA_LOGIN_DATETIME = "loginDateTime"; // Account record public static final String DATA_LOGIN_AGE = "loginAge"; // Account record public static final String DATA_ACCOUNT_ACTIVE = "accountActive"; // Account record public static final String DATA_DEVICE_COUNT = "deviceCount"; // Account record public static final String DATA_PRIVATE_LABEL = "privateLabelName"; // Account record public static final String DATA_LEFT_ALIGN_1 = "leftAlign_1"; // left aligned string public static final String DATA_LEFT_ALIGN_2 = "leftAlign_2"; // left aligned string public static final String DATA_RIGHT_ALIGN_1 = "rightAlign_1"; // right aligned string public static final String DATA_RIGHT_ALIGN_2 = "rightAlign_2"; // right aligned string public static final String DATA_BLANK_SPACE = "blankSpace"; // nothing displayed // ------------------------------------------------------------------------ public static String GetLocalStringValue(String v, I18N i18n) { /* blank */ if (StringTools.isBlank(v)) { return v; } /* No/Yes */ if (v.equalsIgnoreCase("no")) { return i18n.getString("FieldLayout.no","No"); } else if (v.equalsIgnoreCase("yes")) { return i18n.getString("FieldLayout.yes","Yes"); } /* False/True */ if (v.equalsIgnoreCase("false")) { return i18n.getString("FieldLayout.false","False"); } else if (v.equalsIgnoreCase("true")) { return i18n.getString("FieldLayout.true","True"); } /* Off/On */ if (v.equalsIgnoreCase("off")) { return i18n.getString("FieldLayout.off","Off"); } else if (v.equalsIgnoreCase("on")) { return i18n.getString("FieldLayout.true","True"); } /* Disabled/Enabled */ if (v.equalsIgnoreCase("disabled")) { return i18n.getString("FieldLayout.disabled","Disabled"); } else if (v.equalsIgnoreCase("enabled")) { return i18n.getString("FieldLayout.enabled","Enabled"); } /* default */ return v; } // ------------------------------------------------------------------------ // FieldLayout is a singleton private static FieldLayout reportDef = null; public static ReportLayout getReportLayout() { if (reportDef == null) { reportDef = new FieldLayout(); } return reportDef; } private FieldLayout() { super(); this.setDataRowTemplate(new FieldDataRow()); } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ /* format double value */ protected static String formatDouble(double value, String arg, String dftArg) { String fmt = dftArg; if ((arg != null) && (arg.length() > 0)) { 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; } } return StringTools.format(value, fmt); } // ------------------------------------------------------------------------ protected static class FieldDataRow extends DataRowTemplate { public DBDataRow.RowType getRowType(Object obj) { return (obj instanceof FieldData)? ((FieldData)obj).getRowType() : DBDataRow.RowType.DETAIL; } public FieldDataRow() { 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(); int ofs = 1; if ((arg != null) && (arg.length() > 0) && (arg.charAt(0) == '0')) { ofs = 0; } return String.valueOf(rowNdx + ofs); } else { return ""; } } public String getTitle(ReportData rd, ReportColumn rc) { return "#"; } }); // Display name this.addColumnTemplate(new DataColumnTemplate(DATA_DISPLAY_NAME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String name = fd.getString(DATA_DISPLAY_NAME,null); return fd.filterReturnedValue(DATA_DISPLAY_NAME,name); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.displayName","Display Name"); } }); // Account-ID this.addColumnTemplate(new DataColumnTemplate(DATA_ACCOUNT_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String acctID = fd.getAccountID(); return fd.filterReturnedValue(DATA_ACCOUNT_ID,acctID); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.accountID","Account-ID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ACCOUNT_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_ACCOUNT_DESC,null); if (desc == null) { Account acct = fd.getAccount(); if (acct != null) { desc = acct.getDescription(); if (StringTools.isBlank(desc) && acct.isSystemAdmin()) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); desc = i18n.getString("FieldLayout.accountAdmin","Administrator"); } } } return fd.filterReturnedValue(DATA_ACCOUNT_DESC,desc); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.accountDescription","Account\nDescription"); } }); // User-ID/Description this.addColumnTemplate(new DataColumnTemplate(DATA_USER_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String userID = fd.getString(FieldLayout.DATA_USER_ID, ""); if (StringTools.isBlank(userID)) { Device dev = fd.getDevice(); userID = (dev != null)? dev.getAssignedUserID() : ""; } return fd.filterReturnedValue(DATA_USER_ID,userID); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.userID","User-ID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_USER_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String userID = fd.getString(FieldLayout.DATA_USER_ID, ""); if (StringTools.isBlank(userID)) { Device dev = fd.getDevice(); userID = (dev != null)? dev.getAssignedUserID() : ""; } String desc = fd.getString(FieldLayout.DATA_USER_DESC, ""); if (StringTools.isBlank(desc) && !StringTools.isBlank(userID)) { if (User.isAdminUser(userID)) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); desc = i18n.getString("FieldLayout.userAdmin","Account Administrator"); } else { try { User user = User.getUser(fd.getAccount(),userID); desc = (user != null)? user.getDescription() : userID; } catch (DBException dbe) { desc = userID; } } } return fd.filterReturnedValue(DATA_USER_DESC,desc); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.userDescription","User\nDescription"); } }); // Device-ID/Description this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String deviceID = fd.getDeviceID(); if (arg.startsWith("admin")) { // "admin", "adminView", "adminEdit" // wrap in link to Device Admin page ColumnValue cv = new ColumnValue(deviceID); RequestProperties reqState = rd.getRequestProperties(); URIArg devAdminURL = WebPageAdaptor.MakeURL(reqState.getBaseURI(),"dev.info"); // Constants.PAGE_DEVICE_INFO); 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(),null/*target*/); return cv; } else { return fd.filterReturnedValue(DATA_DEVICE_ID,deviceID); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("FieldLayout.deviceID","{0} ID",devTitles); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_DEVICE_DESC,null); if (desc == null) { Device dev = fd.getDevice(); if (dev != null) { desc = dev.getDescription(); } } return fd.filterReturnedValue(DATA_DEVICE_DESC,desc); } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("FieldLayout.deviceDescription","{0}\nDescription",devTitles); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_BATTERY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); if (dev != null) { double level = dev.getLastBatteryLevel(); if (level <= 0.0) { return rc.getBlankFiller(); } else if (level <= 1.0) { String p = Math.round(level*100.0) + "%"; return fd.filterReturnedValue(DATA_DEVICE_BATTERY, p); // percent } else { String v = formatDouble(level, arg, "0.0") + "v"; return fd.filterReturnedValue(DATA_DEVICE_BATTERY, v); // volts } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.deviceBattery","Last\nBattery"); } }); // Vehicle-ID this.addColumnTemplate(new DataColumnTemplate(DATA_VEHICLE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String vid = fd.getString(DATA_VEHICLE_ID,null); if (vid == null) { Device dev = fd.getDevice(); if (dev != null) { vid = dev.getVehicleID(); } } return fd.filterReturnedValue(DATA_VEHICLE_ID,vid); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.vehicleID","Vehicle-ID"); } }); // License Plate this.addColumnTemplate(new DataColumnTemplate(DATA_LICENSE_PLATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String lic = fd.getString(DATA_LICENSE_PLATE,null); if (lic == null) { Device dev = fd.getDevice(); if (dev != null) { lic = dev.getLicensePlate(); } } return fd.filterReturnedValue(DATA_LICENSE_PLATE,lic); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.licensePlate","License\nPlate"); } }); // Equipment Type this.addColumnTemplate(new DataColumnTemplate(DATA_EQUIPMENT_TYPE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String eqType = fd.getString(DATA_EQUIPMENT_TYPE,null); if (eqType == null) { Device dev = fd.getDevice(); if (dev != null) { eqType = dev.getEquipmentType(); } } return fd.filterReturnedValue(DATA_EQUIPMENT_TYPE,eqType); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.equipmentType","Equipment\nType"); } }); // Unique-ID this.addColumnTemplate(new DataColumnTemplate(DATA_UNIQUE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String uid = fd.getString(DATA_UNIQUE_ID,null); if (uid == null) { Device dev = fd.getDevice(); if (dev != null) { uid = dev.getUniqueID(); } } return fd.filterReturnedValue(DATA_UNIQUE_ID,uid); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.uniqueID","Unique-ID"); } }); // Server-ID this.addColumnTemplate(new DataColumnTemplate(DATA_SERVER_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String sid = fd.getString(DATA_SERVER_ID,null); if (sid == null) { Device dev = fd.getDevice(); if (dev != null) { sid = dev.getDeviceCode(); } } return fd.filterReturnedValue(DATA_SERVER_ID,sid); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.serverID","Server-ID"); } }); // JobNumber this.addColumnTemplate(new DataColumnTemplate(DATA_JOB_NUMBER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String job = fd.getString(DATA_JOB_NUMBER,""); return fd.filterReturnedValue(DATA_JOB_NUMBER,job); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.jobNumber","Job#"); } }); // Group-ID this.addColumnTemplate(new DataColumnTemplate(DATA_GROUP_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String gid = fd.getString(DATA_GROUP_ID,null); if (gid == null) { Device dev = fd.getDevice(); if (dev != null) { gid = dev.getGroupID(); } } return fd.filterReturnedValue(DATA_GROUP_ID,gid); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.groupID","Group-ID"); } }); // Date/Time this.addColumnTemplate(new DataColumnTemplate(DATA_DATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DATE)) { // DayNumber long ds = fd.getLong(DATA_DATE); if (ds > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DayNumber dn = new DayNumber(ds); String dnFmt = dn.format(rl.getDateFormat(rd.getPrivateLabel())); ColumnValue cv = new ColumnValue(dnFmt).setSortKey(ds); return fd.filterReturnedValue(DATA_DATE, cv); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_TIMESTAMP)) { // Epoch timestamp long ts = fd.getLong(DATA_TIMESTAMP); 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); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_DATE, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.date","Date"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_TIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_TIMESTAMP)) { long ts = fd.getLong(DATA_TIMESTAMP); 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 tmFmt = dt.format(rl.getTimeFormat(rd.getPrivateLabel()),tz); return fd.filterReturnedValue(DATA_TIME, tmFmt); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.time","Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_TIMESTAMP)) { long ts = fd.getLong(DATA_TIMESTAMP); 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.getDateTimeFormat(rd.getPrivateLabel()),tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_DATETIME, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_TIMESTAMP)) { long ts = fd.getLong(DATA_TIMESTAMP); if (ts > 0L) { return fd.filterReturnedValue(DATA_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.timestamp","Timestamp") + "\n(Epoch)"; } }); // 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(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_CREATE_TIMESTAMP)) { long ts = fd.getLong(DATA_CREATE_TIMESTAMP); 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); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_CREATE_DATE, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_CREATE_TIMESTAMP)) { long ts = fd.getLong(DATA_CREATE_TIMESTAMP); 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 fd.filterReturnedValue(DATA_CREATE_TIME,dt.format(rl.getTimeFormat(rd.getPrivateLabel()),tz)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.createTime","Insert\nTime"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CREATE_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_CREATE_TIMESTAMP)) { long ts = fd.getLong(DATA_CREATE_TIMESTAMP); 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.getDateTimeFormat(rd.getPrivateLabel()),tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_CREATE_DATETIME,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_CREATE_TIMESTAMP)) { long ts = fd.getLong(DATA_CREATE_TIMESTAMP); if (ts > 0L) { return fd.filterReturnedValue(DATA_CREATE_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.createTimestamp","Insert\nTimestamp") + "\n(Epoch)"; } }); // Ping/Command time this.addColumnTemplate(new DataColumnTemplate(DATA_PING_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); long ts = fd.hasValue(DATA_PING_TIMESTAMP)? fd.getLong(DATA_PING_TIMESTAMP) : ((dev != null)? dev.getLastPingTime() : -1L); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getDateTimeFormat(rd.getPrivateLabel()),tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_PING_DATETIME,cv); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.commandDateTime","Command\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PING_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); long ts = fd.hasValue(DATA_PING_TIMESTAMP)? fd.getLong(DATA_PING_TIMESTAMP) : ((dev != null)? dev.getLastPingTime() : -1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_PING_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.commandTimestamp","Command\nTimestamp") + "\n(Epoch)"; } }); // ACK time this.addColumnTemplate(new DataColumnTemplate(DATA_ACK_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); long ts = fd.hasValue(DATA_ACK_TIMESTAMP)? fd.getLong(DATA_ACK_TIMESTAMP) : ((dev != null)? dev.getLastAckTime() : -1L); if (ts > 0L) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getDateTimeFormat(rd.getPrivateLabel()),tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_ACK_DATETIME,cv); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.ackDateTime","ACK\nDate/Time") + "\n${timezone}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ACK_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); long ts = fd.hasValue(DATA_ACK_TIMESTAMP)? fd.getLong(DATA_ACK_TIMESTAMP) : ((dev != null)? dev.getLastAckTime() : -1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_ACK_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.ackTimestamp","ACK\nTimestamp") + "\n(Epoch)"; } }); // Status Code/Description this.addColumnTemplate(new DataColumnTemplate(DATA_STATUS_CODE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STATUS_CODE)) { String arg = rc.getArg(); int code = (int)fd.getLong(DATA_STATUS_CODE); String scCode = "0x" + StringTools.toHexString(code,16); if (StringTools.isBlank(arg) || arg.equalsIgnoreCase("color")) { Device dev = fd.getDevice(); BasicPrivateLabel bpl = rd.getPrivateLabel(); StatusCodeProvider scp = StatusCode.getStatusCodeProvider(dev,code,bpl,null/*dftSCP*/); if (scp == null) { return fd.filterReturnedValue(DATA_STATUS_CODE,scCode); } else { ColumnValue cv = new ColumnValue(); cv.setValue(scCode); cv.setForegroundColor(scp.getForegroundColor()); cv.setBackgroundColor(scp.getBackgroundColor()); return fd.filterReturnedValue(DATA_STATUS_CODE,cv); } } else { return fd.filterReturnedValue(DATA_STATUS_CODE,scCode); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.statusCode","Status#"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STATUS_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String scDesc = fd.getString(DATA_STATUS_DESC); Device dev = fd.getDevice(); BasicPrivateLabel bpl = rd.getPrivateLabel(); int code = (int)fd.getLong(DATA_STATUS_CODE, StatusCodes.STATUS_NONE); if (StringTools.isBlank(scDesc) && (code != StatusCodes.STATUS_NONE)) { scDesc = StatusCode.getDescription(dev,code,bpl,null); } if (!StringTools.isBlank(scDesc)) { if (code == StatusCodes.STATUS_NONE) { // no code specified to provide coloring return fd.filterReturnedValue(DATA_STATUS_DESC,scDesc); } else if (StringTools.isBlank(arg) || arg.equalsIgnoreCase("color")) { // check for status code coloring StatusCodeProvider scp = StatusCode.getStatusCodeProvider(dev,code,bpl,null/*dftSCP*/); if (scp == null) { return fd.filterReturnedValue(DATA_STATUS_DESC,scDesc); } else { ColumnValue cv = new ColumnValue(); cv.setValue(scDesc); cv.setForegroundColor(scp.getForegroundColor()); cv.setBackgroundColor(scp.getBackgroundColor()); return fd.filterReturnedValue(DATA_STATUS_DESC,cv); } } else { // coloring not wanted return fd.filterReturnedValue(DATA_STATUS_DESC,scDesc); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.statusDescription","Status"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STATUS_COUNT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { FieldData fd = (FieldData)obj; int code = StringTools.parseInt(rc.getArg(),StatusCodes.STATUS_NONE); String cKey = DATA_STATUS_COUNT + "_" + StringTools.toHexString(code,16); if (fd.hasValue(cKey)) { int count = (int)fd.getLong(cKey); return fd.filterReturnedValue(DATA_STATUS_COUNT,String.valueOf(count)); } else if (fd.hasValue(DATA_STATUS_COUNT)) { int count = (int)fd.getLong(DATA_STATUS_COUNT); return fd.filterReturnedValue(DATA_STATUS_COUNT,String.valueOf(count)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { int code = StringTools.parseInt(rc.getArg(),StatusCodes.STATUS_NONE); Device dev = null; try { dev = rd.getDevice(rd.getFirstDeviceID()); } catch (Throwable th) {/*ignore*/} String scDesc = StatusCode.getDescription(dev,code,rd.getPrivateLabel(),null); if (StringTools.isBlank(scDesc)) { // no description found for this statusCode, use hex value scDesc = "0x" + StringTools.toHexString(code,16); } else { // replace " " and "_" with "\n" StringBuffer sb = new StringBuffer(); int C = 0; for (int i = 0; i < scDesc.length(); i++) { char ch = scDesc.charAt(i); if ((ch == '_') || (ch == ' ')) { if (C >= 3) { sb.append("\n"); C = 0; } else { sb.append(ch); C++; } } else { sb.append(ch); C++; } } scDesc = sb.toString(); } return scDesc; } }); /* Pushpins */ 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) { RequestProperties reqState = rd.getRequestProperties(); FieldData fd = (FieldData)obj; String iconURL = fd.getString(DATA_PUSHPIN); if (StringTools.isBlank(iconURL)) { return rc.getBlankFiller(); } else if (StringTools.isInt(iconURL,true)) { int ppNdx = StringTools.parseInt(iconURL, 0); PushpinIcon ppi = reqState.getPushpinIcon(ppNdx); iconURL = (ppi != null)? ppi.getIconEvalURL(null/*EventData*/,rowNdx) : ""; ColumnValue cv = new ColumnValue().setImageURL(iconURL); return fd.filterReturnedValue(DATA_PUSHPIN, cv); } else { ColumnValue cv = new ColumnValue().setImageURL(iconURL); return fd.filterReturnedValue(DATA_PUSHPIN, cv); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.pushpin","Pushpin"); } }); // Property Key/Description/Value this.addColumnTemplate(new DataColumnTemplate(DATA_PROPERTY_KEY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_PROPERTY_KEY)) { long propKey = fd.getLong(DATA_PROPERTY_KEY); return fd.filterReturnedValue(DATA_PROPERTY_KEY,"0x"+StringTools.toHexString(propKey,16)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.propertyKey","Property\nKey"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PROPERTY_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_PROPERTY_DESC); if (!StringTools.isBlank(desc)) { return fd.filterReturnedValue(DATA_PROPERTY_DESC,desc); } else if (fd.hasValue(DATA_PROPERTY_KEY)) { int propKey = (int)fd.getLong(DATA_PROPERTY_KEY); //return PropertyKey.GetKeyDescription(propKey); return fd.filterReturnedValue(DATA_PROPERTY_DESC,"0x"+StringTools.toHexString((long)propKey,16)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.propertyDescription","Property\nDescription"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PROPERTY_VALUE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String value = fd.getString(DATA_PROPERTY_VALUE); return fd.filterReturnedValue(DATA_PROPERTY_VALUE,(value!=null)?value:""); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.propertyValue","Property\nValue"); } }); // Diagnostic Key/Description/Value this.addColumnTemplate(new DataColumnTemplate(DATA_DIAGNOSTIC_ERROR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String isErr = fd.getString(DATA_DIAGNOSTIC_ERROR); if (!StringTools.isBlank(isErr)) { return fd.filterReturnedValue(DATA_DIAGNOSTIC_ERROR,isErr); // "true" : "false"; } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.diagnosticError","Is Error?"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DIAGNOSTIC_KEY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DIAGNOSTIC_ERROR) || fd.hasValue(DATA_DIAGNOSTIC_KEY)) { boolean isError = fd.getBoolean(DATA_DIAGNOSTIC_ERROR); long diagKey = fd.getLong(DATA_DIAGNOSTIC_KEY); return fd.filterReturnedValue(DATA_DIAGNOSTIC_KEY,(isError?"[E]":"[D]")+"0x"+StringTools.toHexString(diagKey,16)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.diagnosticKey","Diagnostic\nKey"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DIAGNOSTIC_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_DIAGNOSTIC_DESC); if (!StringTools.isBlank(desc)) { return fd.filterReturnedValue(DATA_DIAGNOSTIC_DESC,desc); } else if (fd.hasValue(DATA_DIAGNOSTIC_KEY)) { int diagKey = (int)fd.getLong(DATA_DIAGNOSTIC_KEY); //return ClientDiagnostic.GetKeyDescription(diagKey); return fd.filterReturnedValue(DATA_DIAGNOSTIC_DESC,"0x"+StringTools.toHexString((long)diagKey,16)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.diagnosticDescription","Diagnostic\nDescription"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DIAGNOSTIC_VALUE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String value = fd.getString(DATA_DIAGNOSTIC_VALUE); return (value != null)? fd.filterReturnedValue(DATA_DIAGNOSTIC_VALUE,value) : ""; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.diagnosticValue","Diagnostic\nValue"); } }); // Entity-ID/Description this.addColumnTemplate(new DataColumnTemplate(DATA_ENTITY_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_ENTITY_ID); if (!StringTools.isBlank(desc)) { return fd.filterReturnedValue(DATA_ENTITY_ID,desc); } else { return fd.filterReturnedValue(DATA_ENTITY_ID,fd.getString(DATA_ENTITY_DESC)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.entityID","Entity-ID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENTITY_TYPE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long type = fd.getLong(DATA_ENTITY_TYPE); EntityManager.EntityType et = EntityManager.getEntityTypeFromCode(type,null); if (et != null) { Locale locale = rd.getLocale(); return fd.filterReturnedValue(DATA_ENTITY_TYPE,et.toString(locale)); } else { return fd.filterReturnedValue(DATA_ENTITY_TYPE,String.valueOf(type)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.entityType","Entity-Type"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENTITY_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = fd.getString(DATA_ENTITY_DESC); if (!StringTools.isBlank(desc)) { return fd.filterReturnedValue(DATA_ENTITY_DESC,desc); } else { return fd.filterReturnedValue(DATA_ENTITY_DESC,fd.getString(DATA_ENTITY_ID)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; String driverID = fd.getDriverID(); // DATA_DRIVER_ID or fd.getDevice().getDriverID() if (driverID != null) { return fd.filterReturnedValue(DATA_DRIVER_ID,driverID); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; String desc = null; if (fd.hasValue(DATA_DRIVER_DESC)) { desc = fd.getString(DATA_DRIVER_DESC); } else { Driver driver = fd.getDriver(); desc = (driver != null)? driver.getDescription() : fd.getDriverID(); } if (desc != null) { return fd.filterReturnedValue(DATA_DRIVER_DESC,desc); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverDescription","Driver\nDescription"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_NICKNAME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String name = null; if (fd.hasValue(DATA_DRIVER_NICKNAME)) { name = fd.getString(DATA_DRIVER_NICKNAME,null); } else if (fd.hasValue(DATA_DISPLAY_NAME)) { name = fd.getString(DATA_DISPLAY_NAME,null); } else { Driver driver = fd.getDriver(); name = (driver != null)? driver.getDisplayName() : null; } if (name != null) { return fd.filterReturnedValue(DATA_DRIVER_NICKNAME,name); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverNickname","Driver\nNickname"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_STATUS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); FieldData fd = (FieldData)obj; long drvStat = Driver.DutyStatus_INVALID; if (fd.hasValue(DATA_DRIVER_STATUS)) { drvStat = fd.getLong(DATA_DRIVER_STATUS); } else { Driver driver = fd.getDriver(); drvStat = (driver != null)? driver.getDriverStatus() : Driver.DutyStatus_INVALID; if ((drvStat < 0L) || (drvStat == Driver.DutyStatus_INVALID)) { // Default to Device Driver Status Device device = fd.getDevice(); if ((device != null) && device.hasDriverStatus()) { drvStat = device.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) { Locale locale = rd.getLocale(); return fd.filterReturnedValue(DATA_DRIVER_STATUS,ds.toString(locale)); } else { return fd.filterReturnedValue(DATA_DRIVER_STATUS,String.valueOf(drvStat)); } } else { return fd.filterReturnedValue(DATA_DRIVER_STATUS,String.valueOf(drvStat)); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverStatus","Driver\nStatus"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_BADGEID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String badge = null; if (fd.hasValue(DATA_DRIVER_BADGEID)) { badge = fd.getString(DATA_DRIVER_BADGEID); } else { Driver driver = fd.getDriver(); badge = (driver != null)? driver.getBadgeID() : null; } if (badge != null) { return fd.filterReturnedValue(DATA_DRIVER_BADGEID,badge); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverBadge","Driver\nBadge-ID"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_LICENSE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String lic = null; if (fd.hasValue(DATA_DRIVER_LICENSE)) { lic = fd.getString(DATA_DRIVER_LICENSE); } else { Driver driver = fd.getDriver(); lic = (driver != null)? driver.getLicenseNumber() : null; } if (lic != null) { return fd.filterReturnedValue(DATA_DRIVER_LICENSE,lic); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverLicense","Driver\nLicense"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_LICENSE_TYPE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String type = null; if (fd.hasValue(DATA_DRIVER_LICENSE_TYPE)) { type = fd.getString(DATA_DRIVER_LICENSE_TYPE); } else { Driver driver = fd.getDriver(); type = (driver != null)? driver.getLicenseType() : null; } if (type != null) { return fd.filterReturnedValue(DATA_DRIVER_LICENSE_TYPE,type); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverLicenseType","Driver\nLicense Type"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_LICENSE_EXP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long licExp = 0L; if (fd.hasValue(DATA_DRIVER_LICENSE_EXP)) { licExp = fd.getLong(DATA_DRIVER_LICENSE_EXP); } else { Driver driver = fd.getDriver(); licExp = (driver != null)? driver.getLicenseExpire() : 0L; } if (licExp > 0L) { TimeZone tz = rd.getTimeZone(); long currdn = DateTime.getCurrentDayNumber(tz); long days = licExp - currdn; boolean expired = (days <= 0L)? true : false; if (arg.equalsIgnoreCase("days")) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); String expStr = ""; ColorTools.RGB fgColor = null; if (days < 0L) { // Red: Expired expStr = i18n.getString("FieldLayout.expired", "Expired"); fgColor = ColorTools.RED; } else if (days == 0L) { // Red: Today expStr = i18n.getString("FieldLayout.today", "Today"); fgColor = ColorTools.RED; } else if (days == 1L) { // Yellow: Tomorrow //expStr = i18n.getString("FieldLayout.nday", "{0} day", String.valueOf(days)); expStr = i18n.getString("FieldLayout.tomorrow", "Tomorrow"); fgColor = ColorTools.DARK_YELLOW; } else if (days <= 30L) { // Yellow: N days from now expStr = i18n.getString("FieldLayout.ndays", "{0} days", String.valueOf(days)); fgColor = ColorTools.DARK_YELLOW; } else { // Green/Black: N days from now expStr = i18n.getString("FieldLayout.ndays", "{0} days", String.valueOf(days)); //fgColor = ColorTools.GREEN; } ColumnValue cv = new ColumnValue(expStr).setSortKey(licExp); if (fgColor != null) { cv.setForegroundColor(fgColor); } return fd.filterReturnedValue(DATA_DRIVER_LICENSE_EXP, cv); } else { ReportLayout rl = rd.getReportLayout(); DayNumber dn = new DayNumber(licExp); String dnFmt = dn.format(rl.getDateFormat(rd.getPrivateLabel())); ColumnValue cv = new ColumnValue(dnFmt).setSortKey(licExp); if (days <= 0L) { cv.setForegroundColor(ColorTools.RED); } else if (days <= 30L) { cv.setForegroundColor(ColorTools.DARK_YELLOW); } return fd.filterReturnedValue(DATA_DRIVER_LICENSE_EXP, cv); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverLicenseExpire","Driver\nLicense Exp"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_BIRTHDATE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long bDay = 0L; if (fd.hasValue(DATA_DRIVER_BIRTHDATE)) { // explicitly specified bDay = fd.getLong(DATA_DRIVER_BIRTHDATE); } else { Driver driver = fd.getDriver(); bDay = (driver != null)? driver.getBirthdate() : 0L; } if (bDay > 0L) { ReportLayout rl = rd.getReportLayout(); DayNumber dn = new DayNumber(bDay); String dnFmt = dn.format(rl.getDateFormat(rd.getPrivateLabel())); ColumnValue cv = new ColumnValue(dnFmt).setSortKey(bDay); return fd.filterReturnedValue(DATA_DRIVER_BIRTHDATE, cv); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driverBirthday","Driver\nBirthday"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_DEVICE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String deviceID = null; if (fd.hasValue(DATA_DRIVER_DEVICE_ID)) { deviceID = fd.getString(DATA_DRIVER_DEVICE_ID); } else if (fd.hasValue(DATA_DEVICE_ID)) { deviceID = fd.getString(DATA_DEVICE_ID); } else { Driver driver = fd.getDriver(); deviceID = (driver != null)? driver.getDeviceID() : null; } if (deviceID != null) { return fd.filterReturnedValue(DATA_DRIVER_DEVICE_ID,deviceID); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("FieldLayout.driverDeviceID","Driver\n{0} ID",devTitles); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVER_DEVICE_DESC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String desc = null; if (fd.hasValue(DATA_DRIVER_DEVICE_DESC)) { desc = fd.getString(DATA_DRIVER_DEVICE_DESC,null); } else { Driver driver = fd.getDriver(); Device device = (driver != null)? driver.getDevice() : null; desc = (device != null)? device.getDescription() : null; } if (desc != null) { return fd.filterReturnedValue(DATA_DRIVER_DEVICE_DESC,desc); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { Locale locale = rd.getLocale(); I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); RequestProperties reqState = rd.getRequestProperties(); String devTitles[] = (reqState != null)? reqState.getDeviceTitles() : Device.GetTitles(locale); return i18n.getString("FieldLayout.driverDeviceDesc","Driver\n{0}",devTitles); } }); // Latitude/Longitude/GeoPoint this.addColumnTemplate(new DataColumnTemplate(DATA_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_GEOPOINT) || fd.hasValue(DATA_LATITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_LATITUDE); if (GeoPoint.isValid(lat,1.0)) { 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); } return fd.filterReturnedValue(DATA_LATITUDE,valStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lat","Lat"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_GEOPOINT) || fd.hasValue(DATA_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_GEOPOINT); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_LONGITUDE); if (GeoPoint.isValid(1.0,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())) { 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); } return fd.filterReturnedValue(DATA_LONGITUDE,valStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lon","Lon"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_GEOPOINT) || fd.hasValue(DATA_LATITUDE) || fd.hasValue(DATA_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_LATITUDE); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_LONGITUDE); 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; } return fd.filterReturnedValue(DATA_GEOPOINT,valStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.latLon","Lat/Lon"); } }); // Best Latitude/Longitude/GeoPoint this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; double lat = 999.0; if (fd.hasValue(DATA_BEST_GEOPOINT)) { lat = GeoPoint.getLatitude(fd.getGeoPoint(DATA_BEST_GEOPOINT),999.0); } else if (fd.hasValue(DATA_BEST_LATITUDE)) { lat = fd.getDouble(DATA_BEST_LATITUDE); } else if (fd.hasValue(DATA_GEOPOINT)) { lat = GeoPoint.getLatitude(fd.getGeoPoint(DATA_GEOPOINT),999.0); } else if (fd.hasValue(DATA_LATITUDE)) { lat = fd.getDouble(DATA_LATITUDE); } if (GeoPoint.isValid(lat,1.0)) { Locale locale = rd.getLocale(); 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); } return fd.filterReturnedValue(DATA_BEST_LATITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bestLat","Lat"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; double lon = 999.0; if (fd.hasValue(DATA_BEST_GEOPOINT)) { lon = GeoPoint.getLongitude(fd.getGeoPoint(DATA_BEST_GEOPOINT),999.0); } else if (fd.hasValue(DATA_BEST_LONGITUDE)) { lon = fd.getDouble(DATA_BEST_LONGITUDE); } else if (fd.hasValue(DATA_GEOPOINT)) { lon = GeoPoint.getLongitude(fd.getGeoPoint(DATA_GEOPOINT),999.0); } else if (fd.hasValue(DATA_LONGITUDE)) { lon = fd.getDouble(DATA_LONGITUDE); } if (GeoPoint.isValid(1.0,lon)) { Locale locale = rd.getLocale(); 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); } return fd.filterReturnedValue(DATA_BEST_LONGITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bestLon","Lon"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_BEST_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; double lat = 999.0; double lon = 999.0; if (fd.hasValue(DATA_BEST_GEOPOINT)) { GeoPoint gp = fd.getGeoPoint(DATA_BEST_GEOPOINT); lat = GeoPoint.getLatitude( gp,999.0); lon = GeoPoint.getLongitude(gp,999.0); } else if (fd.hasValue(DATA_BEST_LATITUDE) && fd.hasValue(DATA_BEST_LONGITUDE)) { lat = fd.getDouble(DATA_BEST_LATITUDE ); lon = fd.getDouble(DATA_BEST_LONGITUDE); } else if (fd.hasValue(DATA_GEOPOINT)) { GeoPoint gp = fd.getGeoPoint(DATA_GEOPOINT); lat = GeoPoint.getLatitude( gp,999.0); lon = GeoPoint.getLongitude(gp,999.0); } else if (fd.hasValue(DATA_LATITUDE) && fd.hasValue(DATA_LONGITUDE)) { lat = fd.getDouble(DATA_LATITUDE ); lon = fd.getDouble(DATA_LONGITUDE); } if (GeoPoint.isValid(lat,lon)) { Locale locale = rd.getLocale(); 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; } return fd.filterReturnedValue(DATA_BEST_GEOPOINT,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bestLatLon","Lat/Lon"); } }); // Altitude this.addColumnTemplate(new DataColumnTemplate(DATA_ALTITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ALTITUDE)) { Account.AltitudeUnits altUnits = Account.getAltitudeUnits(rd.getAccount()); double alt = altUnits.convertFromMeters(fd.getDouble(DATA_ALTITUDE)); return fd.filterReturnedValue(DATA_ALTITUDE,formatDouble(alt,arg,"#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.altitude","Altitude") + "\n${altitudeUnits}"; } }); // Speed this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_LIMIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED_LIMIT)) { double kph = fd.getDouble(DATA_SPEED_LIMIT); // KPH if (kph > 0.0) { Account a = rd.getAccount(); return fd.filterReturnedValue(DATA_SPEED_LIMIT,formatDouble(Account.getSpeedUnits(a).convertFromKPH(kph),arg,"0")); } else { return "n/a "; } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.speedLimit","Speed Limit") + "\n${speedUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED)) { double kph = fd.getDouble(DATA_SPEED); // KPH if (kph > 0.0) { Account a = rd.getAccount(); return fd.filterReturnedValue(DATA_SPEED,formatDouble(Account.getSpeedUnits(a).convertFromKPH(kph),arg,"0")); } else { return fd.filterReturnedValue(DATA_SPEED,"0 "); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.speed","Speed") + "\n${speedUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_HEADING) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED)) { double kph = fd.getDouble(DATA_SPEED); // KPH if (kph > 0.0) { Account a = rd.getAccount(); String speedStr = formatDouble(Account.getSpeedUnits(a).convertFromKPH(kph), arg, "0"); String headStr = GeoPoint.GetHeadingString(fd.getDouble(DATA_HEADING),rd.getLocale()).toUpperCase(); if (headStr.length() == 1) { headStr += " "; } return fd.filterReturnedValue(DATA_SPEED_HEADING,speedStr+" "+headStr); } else { return "0 "; } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.speed","Speed") + "\n${speedUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_UNITS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED)) { double kph = fd.getDouble(DATA_SPEED); // KPH if (kph > 0.0) { Account a = rd.getAccount(); String unitAbbr = Account.getSpeedUnits(a).toString(rd.getLocale()); String speedStr = formatDouble(Account.getSpeedUnits(a).convertFromKPH(kph), arg, "0"); String headStr = GeoPoint.GetHeadingString(fd.getDouble(DATA_HEADING),rd.getLocale()).toUpperCase(); if (headStr.length() == 1) { headStr += " "; } return fd.filterReturnedValue(DATA_SPEED_UNITS,speedStr+unitAbbr+" "+headStr); } else { return "0 "; } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.speed","Speed"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_SPEED_DURATION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = StringTools.trim(rc.getArg()); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED_DURATION)) { long duraSec = fd.getLong(DATA_SPEED_DURATION); // seconds if (duraSec >= 0L) { String ds; if (arg.equalsIgnoreCase("sec")) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); ds = i18n.getString("FieldLayout.durationSeconds","{0} sec",String.valueOf(duraSec)); } else { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ds = FieldLayout.formatElapsedTime(duraSec, fmt); } ColumnValue cv = new ColumnValue(ds).setSortKey(duraSec); return fd.filterReturnedValue(DATA_SPEED_DURATION, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.speedingDuration","Speeding\nDuration"); } }); // Heading this.addColumnTemplate(new DataColumnTemplate(DATA_HEADING) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_SPEED)) { double speed = fd.getDouble(DATA_SPEED); // KPH if (speed > 0.0) { double heading = fd.getDouble(DATA_HEADING); if (!StringTools.isBlank(arg)) { return fd.filterReturnedValue(DATA_HEADING,formatDouble(heading, arg, "0")); } else { return fd.filterReturnedValue(DATA_HEADING,GeoPoint.GetHeadingString(heading,rd.getLocale()).toUpperCase()); } } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { return GeoPoint.GetHeadingTitle(rd.getLocale()); } }); // Distance/Odometer this.addColumnTemplate(new DataColumnTemplate(DATA_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DISTANCE)) { double dist = fd.getDouble(DATA_DISTANCE); // kilometers if (dist > 0.0) { dist = Account.getDistanceUnits(rd.getAccount()).convertFromKM(dist); return fd.filterReturnedValue(DATA_DISTANCE,formatDouble(dist, arg, "#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.distance","Distance") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PLAN_DISTANCE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double distKM = fd.hasValue(DATA_PLAN_DISTANCE)? fd.getDouble(DATA_PLAN_DISTANCE) : ((dev != null)? dev.getPlanDistanceKM() : -1.0); if (distKM > 0.0) { double dist = Account.getDistanceUnits(rd.getAccount()).convertFromKM(distKM); return fd.filterReturnedValue(DATA_PLAN_DISTANCE,formatDouble(dist, arg, "#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.plannedDistance","Planned\nDistance") + "\n${distanceUnits}"; } }); // Odometer this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double odom = 0.0; if (fd.hasValue(DATA_ODOMETER)) { odom = fd.getDouble(DATA_ODOMETER); // kilometers } else if (fd.hasValue(DATA_DISTANCE)) { odom = fd.getDouble(DATA_DISTANCE); // kilometers } else if (dev != null) { odom = dev.getLastOdometerKM(); } if (odom > 0.0) { if (fd.hasValue(DATA_ODOMETER_OFFSET)) { odom += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { odom += dev.getOdometerOffsetKM(); // ok } odom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(odom); return fd.filterReturnedValue(DATA_ODOMETER,formatDouble(odom,arg,"#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.odometer","Odometer") + "\n${distanceUnits}"; } }); // Start Odometer this.addColumnTemplate(new DataColumnTemplate(DATA_START_ODOMETER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_ODOMETER)) { double odom = fd.getDouble(DATA_START_ODOMETER); // kilometers if (odom > 0.0) { Device dev = fd.getDevice(); if (fd.hasValue(DATA_ODOMETER_OFFSET)) { odom += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { odom += dev.getOdometerOffsetKM(); } odom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(odom); return fd.filterReturnedValue(DATA_START_ODOMETER,formatDouble(odom, arg, "#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startOdometer","Start\nOdometer") + "\n${distanceUnits}"; } }); // Odometer Delta (ie. "Miles Driven") this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER_DELTA) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ODOMETER_DELTA)) { double deltaOdom = fd.getDouble(DATA_ODOMETER_DELTA); // kilometers if (deltaOdom >= 0.0) { deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_START_ODOMETER) && fd.hasValue(DATA_STOP_ODOMETER)) { double startOdom = fd.getDouble(DATA_START_ODOMETER); // kilometers double stopOdom = fd.getDouble(DATA_STOP_ODOMETER); // kilometers double deltaOdom = stopOdom - startOdom; if (deltaOdom >= 0.0) { deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.driven","Driven") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER_DELTA_WH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ODOMETER_DELTA_WH)) { double deltaOdom = fd.getDouble(DATA_ODOMETER_DELTA_WH); // kilometers if (deltaOdom >= 0.0) { deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA_WH,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivenWorkHours","Work Hour") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER_DELTA_AH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ODOMETER_DELTA_AH)) { double deltaOdom = fd.getDouble(DATA_ODOMETER_DELTA_AH); // kilometers if (deltaOdom >= 0.0) { deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA_AH,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_ODOMETER_DELTA) && fd.hasValue(DATA_ODOMETER_DELTA_WH)) { double deltaOdomTot = fd.getDouble(DATA_ODOMETER_DELTA); // kilometers double deltaOdomWH = fd.getDouble(DATA_ODOMETER_DELTA_WH); // kilometers if ((deltaOdomWH >= 0.0) && (deltaOdomTot >= deltaOdomWH)) { double deltaOdom = deltaOdomTot - deltaOdomWH; deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA_AH,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivenAfterHours","After Hour") + "\n${distanceUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ODOMETER_DELTA_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ODOMETER_DELTA_BIT)) { double deltaOdom = fd.getDouble(DATA_ODOMETER_DELTA_BIT); // kilometers if (deltaOdom >= 0.0) { deltaOdom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(deltaOdom); return fd.filterReturnedValue(DATA_ODOMETER_DELTA_BIT,formatDouble(deltaOdom,arg,"#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivenInputBit","Odometer(bit)") + "\n${distanceUnits}"; } }); // Last Service Hours this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_LAST_HR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double hours = 0.0; if (fd.hasValue(DATA_SERVICE_LAST_HR)) { hours = fd.getDouble(DATA_SERVICE_LAST_HR); // hours } else if (dev != null) { hours = dev.getMaintEngHoursHR0(); // hours } else { // not available } if (hours > 0.0) { if (dev != null) { hours += dev.getEngineHoursOffset(); } return fd.filterReturnedValue(DATA_SERVICE_LAST_HR,formatDouble(hours,arg,"#0.0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintLastServiceHR","Last Service\nHours"); } }); // Service Interval Hours this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_INTERVAL_HR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; double hours = 0.0; if (fd.hasValue(DATA_SERVICE_INTERVAL_HR)) { hours = fd.getDouble(DATA_SERVICE_INTERVAL_HR); // hours } else { Device dev = fd.getDevice(); if (dev != null) { hours = dev.getMaintIntervalHR0(); // hours } } if (hours > 0.0) { return fd.filterReturnedValue(DATA_SERVICE_INTERVAL_HR,formatDouble(hours,arg,"#0.0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintIntervalHR","Service\nInterval\nHours"); } }); // Next Service Hours this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_NEXT_HR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double hours = 0.0; if (fd.hasValue(DATA_SERVICE_NEXT_HR)) { hours = fd.getDouble(DATA_SERVICE_NEXT_HR); // hours } else if (dev != null) { hours = dev.getMaintEngHoursHR0() + dev.getMaintIntervalHR0(); // hours } if (hours > 0.0) { if (dev != null) { hours += dev.getEngineHoursOffset(); } String hoursS = formatDouble(hours, arg, "#0.0"); double engHrs = dev.getLastEngineHours(); if (dev != null) { engHrs += dev.getEngineHoursOffset(); // ok } if ((engHrs > 0.0) && (engHrs >= hours)) { // beyond service time return (new ColumnValue(hoursS)).setForegroundColor(ColorTools.RED); } else { // have not reached service time yet return fd.filterReturnedValue(DATA_SERVICE_NEXT_HR,hoursS); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintNextServiceHR","Next Service\nHours"); } }); // Remaining hours until next Service (next - engHours) this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_REMAINING_HR) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double remaining = 0.0; if (fd.hasValue(DATA_SERVICE_REMAINING_HR)) { remaining = fd.getDouble(DATA_SERVICE_REMAINING_HR); // hours } else { // next double next = 0.0; if (fd.hasValue(DATA_SERVICE_NEXT_HR)) { next = fd.getDouble(DATA_SERVICE_NEXT_HR); // hours } else if (dev != null) { next = dev.getMaintEngHoursHR0() + dev.getMaintIntervalHR0(); // hours } // hours double hours = 0.0; if (fd.hasValue(DATA_ENGINE_HOURS)) { hours = fd.getDouble(DATA_ENGINE_HOURS); // hours } else if (dev != null) { hours = dev.getLastEngineHours(); } remaining = ((next > 0.0) && (hours > 0.0))? (next - hours) : 0.0; } if (remaining != 0.0) { // may be < 0.0 String hoursS = formatDouble(remaining, arg, "#0.0"); if (remaining >= 0.0) { return fd.filterReturnedValue(DATA_SERVICE_REMAINING_HR,hoursS); } else { return (new ColumnValue(hoursS)).setForegroundColor(ColorTools.RED); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintRemainingHR","Remaining\nHours"); } }); // Last Service Odometer km this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_LAST) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double dist = 0.0; if (fd.hasValue(DATA_SERVICE_LAST)) { dist = fd.getDouble(DATA_SERVICE_LAST); // kilometers } else if (dev != null) { dist = dev.getMaintOdometerKM0(); // kilometers } else { // not available } if (dist > 0.0) { if (fd.hasValue(DATA_ODOMETER_OFFSET)) { dist += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { dist += dev.getOdometerOffsetKM(); // ok } dist = Account.getDistanceUnits(rd.getAccount()).convertFromKM(dist); return fd.filterReturnedValue(DATA_SERVICE_LAST,formatDouble(dist,arg,"#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintLastService","Last Service") + "\n${distanceUnits}"; } }); // Service Interval km this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_INTERVAL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; double dist = 0.0; if (fd.hasValue(DATA_SERVICE_INTERVAL)) { dist = fd.getDouble(DATA_SERVICE_INTERVAL); // kilometers } else { Device dev = fd.getDevice(); if (dev != null) { dist = dev.getMaintIntervalKM0(); // kilometers } } if (dist > 0.0) { dist = Account.getDistanceUnits(rd.getAccount()).convertFromKM(dist); return fd.filterReturnedValue(DATA_SERVICE_INTERVAL,formatDouble(dist,arg,"#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintInterval","Service\nInterval"); } }); // Next Service Odometer km this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_NEXT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double dist = 0.0; if (fd.hasValue(DATA_SERVICE_NEXT)) { dist = fd.getDouble(DATA_SERVICE_NEXT); // kilometers } else if (dev != null) { dist = dev.getMaintOdometerKM0() + dev.getMaintIntervalKM0(); // km } if (dist > 0.0) { // a "Next Service Interval" has been specified if (fd.hasValue(DATA_ODOMETER_OFFSET)) { dist += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { dist += dev.getOdometerOffsetKM(); // ok } double distU = Account.getDistanceUnits(rd.getAccount()).convertFromKM(dist); String distS = formatDouble(distU, arg, "#0"); // get last odometer value double odom = dev.getLastOdometerKM(); // DATA_ODOMETER? if (fd.hasValue(DATA_ODOMETER_OFFSET)) { odom += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { odom += dev.getOdometerOffsetKM(); // ok } // check for elapsed interval if ((odom > 0.0) && (odom >= dist)) { // beyond service time return (new ColumnValue(distS)).setForegroundColor(ColorTools.RED); } else { // have not reached service time yet return fd.filterReturnedValue(DATA_SERVICE_NEXT,distS); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintNextService","Next Service") + "\n${distanceUnits}"; } }); // Remaining Km until next Service (next - odometer) this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_REMAINING) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double remaining = 0.0; if (fd.hasValue(DATA_SERVICE_REMAINING)) { remaining = fd.getDouble(DATA_SERVICE_REMAINING); // kilometers } else { // next double next = 0.0; if (fd.hasValue(DATA_SERVICE_NEXT)) { next = fd.getDouble(DATA_SERVICE_NEXT); // kilometers } else if (dev != null) { next = dev.getMaintOdometerKM0() + dev.getMaintIntervalKM0(); // km } // odometer double odom = 0.0; if (fd.hasValue(DATA_ODOMETER)) { odom = fd.getDouble(DATA_ODOMETER); // kilometers } else if (fd.hasValue(DATA_DISTANCE)) { odom = fd.getDouble(DATA_DISTANCE); // kilometers } else if (dev != null) { odom = dev.getLastOdometerKM(); } remaining = ((next > 0.0) && (odom > 0.0))? (next - odom) : 0.0; } if (remaining != 0.0) { // may be < 0.0 double distU = Account.getDistanceUnits(rd.getAccount()).convertFromKM(remaining); String distS = formatDouble(distU, arg, "#0"); if (remaining >= 0.0) { return fd.filterReturnedValue(DATA_SERVICE_REMAINING,distS); } else { return (new ColumnValue(distS)).setForegroundColor(ColorTools.RED); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintRemaining","Remaining") + "\n${distanceUnits}"; } }); // Service Notes this.addColumnTemplate(new DataColumnTemplate(DATA_SERVICE_NOTES) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); String notes = (dev != null)? dev.getMaintNotes() : ""; return fd.filterReturnedValue(DATA_SERVICE_NOTES,notes); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.maintServiceNotes","Service Notes"); } }); // Address this.addColumnTemplate(new DataColumnTemplate(DATA_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_ADDRESS,fd.getString(DATA_ADDRESS)); } 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(FieldLayout.class); return i18n.getString("FieldLayout.address","Address"); } } }); // City this.addColumnTemplate(new DataColumnTemplate(DATA_CITY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_CITY,fd.getString(DATA_CITY)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_STATE,fd.getString(DATA_STATE)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_COUNTRY,fd.getString(DATA_COUNTRY)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.country","Country"); } }); // Subdivision this.addColumnTemplate(new DataColumnTemplate(DATA_SUBDIVISION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_SUBDIVISION,fd.getString(DATA_SUBDIVISION)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.subdivision","Subdivision"); } }); // Geozone ID this.addColumnTemplate(new DataColumnTemplate(DATA_GEOZONE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_GEOZONE_ID,fd.getString(DATA_GEOZONE_ID)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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 = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_GEOZONE_DESC)) { return fd.filterReturnedValue(DATA_GEOZONE_DESC,fd.getString(DATA_GEOZONE_DESC)); } else if (fd.hasValue(DATA_GEOZONE_ID)) { String geozoneID = fd.getString(DATA_GEOZONE_ID); try { Geozone gz[] = Geozone.getGeozone(rd.getAccount(), geozoneID); return !ListTools.isEmpty(gz)? gz[0].getDescription() : ""; } catch (DBException dbe) { // error } } return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.geozoneDescription","Geozone\nDescription"); } }); // GeoCorridor ID this.addColumnTemplate(new DataColumnTemplate(DATA_GEOCORRIDOR_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; String corrID = fd.getString(DATA_GEOCORRIDOR_ID); if (StringTools.isBlank(corrID)) { // lookup corridor by geozoneID if (fd.hasValue(DATA_GEOZONE_ID)) { String geozoneID = fd.getString(DATA_GEOZONE_ID); try { Geozone gz[] = Geozone.getGeozone(rd.getAccount(), geozoneID); corrID = !ListTools.isEmpty(gz)? gz[0].getCorridorID() : ""; } catch (DBException dbe) { // error } } } if (StringTools.isBlank(corrID)) { // lookup corridor by lat/lon double lat = 0.0, lon = 0.0; if (fd.hasValue(DATA_GEOPOINT)) { GeoPoint gp = fd.getGeoPoint(DATA_GEOPOINT); lat = GeoPoint.getLatitude(gp,999.0); lon = GeoPoint.getLongitude(gp,999.0); } else if (fd.hasValue(DATA_LATITUDE) && fd.hasValue(DATA_LONGITUDE)) { lat = fd.getDouble(DATA_BEST_LATITUDE ); lon = fd.getDouble(DATA_BEST_LONGITUDE); } if (GeoPoint.isValid(lat,lon)) { // TODO: Need to find a corridor that this point is in } } // return corridor-id if (!StringTools.isBlank(corrID)) { return fd.filterReturnedValue(DATA_GEOCORRIDOR_ID,corrID); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.corridorID","Corridor-ID"); } }); // %Utilization this.addColumnTemplate(new DataColumnTemplate(DATA_UTILIZATION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_UTILIZATION)) { double util = fd.getDouble(DATA_UTILIZATION) * 100.0; return fd.filterReturnedValue(DATA_UTILIZATION,formatDouble(util,arg,"#0")); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.utilization","%Util"); } }); // Count this.addColumnTemplate(new DataColumnTemplate(DATA_COUNT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_COUNT)) { long count = fd.getLong(DATA_COUNT); if (count >= 0L) { return fd.filterReturnedValue(DATA_COUNT,String.valueOf(count)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.count","Count"); } }); // Start time this.addColumnTemplate(new DataColumnTemplate(DATA_START_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_TIMESTAMP)) { long ts = fd.getLong(DATA_START_TIMESTAMP,-1L); 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.getDateTimeFormat(rd.getPrivateLabel()), tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_START_DATETIME, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startDateTime","Start\nDate/Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_START_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_TIMESTAMP)) { long ts = fd.getLong(DATA_START_TIMESTAMP,-1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_START_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startTimestamp","Start\nTimestamp"); } }); // Start Latitude/Longitude/GeoPoint this.addColumnTemplate(new DataColumnTemplate(DATA_START_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_GEOPOINT) || fd.hasValue(DATA_START_LATITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_START_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_START_LATITUDE); 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); } return fd.filterReturnedValue(DATA_START_LATITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lat","Lat"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_START_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_GEOPOINT) || fd.hasValue(DATA_START_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_START_GEOPOINT); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_START_LONGITUDE); 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); } return fd.filterReturnedValue(DATA_START_LONGITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lon","Lon"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_START_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_GEOPOINT) || fd.hasValue(DATA_START_LATITUDE) || fd.hasValue(DATA_START_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_START_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_START_LATITUDE); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_START_LONGITUDE); 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; } return fd.filterReturnedValue(DATA_START_GEOPOINT,valStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.latLon","Lat/Lon"); } }); // Enter Geozone ID this.addColumnTemplate(new DataColumnTemplate(DATA_ENTER_GEOZONE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_ENTER_GEOZONE_ID,fd.getString(DATA_ENTER_GEOZONE_ID)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.enterGeozoneID","Arrive\nGeozone-ID"); } }); // Enter Address this.addColumnTemplate(new DataColumnTemplate(DATA_ENTER_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_ENTER_ADDRESS,fd.getString(DATA_ENTER_ADDRESS)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.enterAddress","Arrive\nAddress"); } }); // Enter time this.addColumnTemplate(new DataColumnTemplate(DATA_ENTER_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ENTER_TIMESTAMP)) { long ts = fd.getLong(DATA_ENTER_TIMESTAMP,-1L); 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.getDateTimeFormat(rd.getPrivateLabel()), tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_ENTER_DATETIME, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.enterDateTime","Arrive\nDate/Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_ENTER_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ENTER_TIMESTAMP)) { long ts = fd.getLong(DATA_ENTER_TIMESTAMP,-1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_ENTER_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.enterTimestamp","Arrive\nTimestamp"); } }); // Stop time this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_TIMESTAMP)) { long ts = fd.getLong(DATA_STOP_TIMESTAMP,-1L); 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.getDateTimeFormat(rd.getPrivateLabel()), tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_STOP_DATETIME, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stopDateTime","Stop\nDate/Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_TIMESTAMP)) { long ts = fd.getLong(DATA_STOP_TIMESTAMP,-1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_STOP_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stopTimestamp","Stop\nTimestamp"); } }); // Exit Geozone ID this.addColumnTemplate(new DataColumnTemplate(DATA_EXIT_GEOZONE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_EXIT_GEOZONE_ID,fd.getString(DATA_EXIT_GEOZONE_ID)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.exitGeozoneID","Departure\nGeozone-ID"); } }); // Exit Address this.addColumnTemplate(new DataColumnTemplate(DATA_EXIT_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_EXIT_ADDRESS,fd.getString(DATA_EXIT_ADDRESS)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.exitAddress","Departure\nAddress"); } }); // Exit time this.addColumnTemplate(new DataColumnTemplate(DATA_EXIT_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_EXIT_TIMESTAMP)) { long ts = fd.getLong(DATA_EXIT_TIMESTAMP,-1L); 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.getDateTimeFormat(rd.getPrivateLabel()),tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); return fd.filterReturnedValue(DATA_EXIT_DATETIME, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.exitDateTime","Departure\nDate/Time"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_EXIT_TIMESTAMP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_EXIT_TIMESTAMP)) { long ts = fd.getLong(DATA_EXIT_TIMESTAMP,-1L); if (ts > 0L) { return fd.filterReturnedValue(DATA_EXIT_TIMESTAMP,String.valueOf(ts)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.exitTimestamp","Departure\nTimestamp"); } }); // Stop Latitude/Longitude/GeoPoint this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_LATITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_GEOPOINT) || fd.hasValue(DATA_STOP_LATITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_STOP_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_STOP_LATITUDE); 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); } return fd.filterReturnedValue(DATA_STOP_LATITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lat","Lat"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_LONGITUDE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_GEOPOINT) || fd.hasValue(DATA_STOP_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_STOP_GEOPOINT); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_STOP_LONGITUDE); 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); } return fd.filterReturnedValue(DATA_STOP_LONGITUDE,valStr); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lon","Lon"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_GEOPOINT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_GEOPOINT) || fd.hasValue(DATA_STOP_LATITUDE) || fd.hasValue(DATA_STOP_LONGITUDE)) { Locale locale = rd.getLocale(); GeoPoint gp = fd.getGeoPoint(DATA_STOP_GEOPOINT); double lat = (gp != null)? gp.getLatitude() : fd.getDouble(DATA_STOP_LATITUDE); double lon = (gp != null)? gp.getLongitude() : fd.getDouble(DATA_STOP_LONGITUDE); 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; } return fd.filterReturnedValue(DATA_STOP_GEOPOINT,valStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.latLon","Lat/Lon"); } }); // Stop Odometer this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_ODOMETER) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_ODOMETER)) { double odom = fd.getDouble(DATA_STOP_ODOMETER); // kilometers if (odom > 0.0) { Device dev = fd.getDevice(); if (fd.hasValue(DATA_ODOMETER_OFFSET)) { odom += fd.getDouble(DATA_ODOMETER_OFFSET); // kilometers } else if (dev != null) { odom += dev.getOdometerOffsetKM(); } odom = Account.getDistanceUnits(rd.getAccount()).convertFromKM(odom); return fd.filterReturnedValue(DATA_STOP_ODOMETER,formatDouble(odom, arg, "#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.odometer","Odometer") + "\n${distanceUnits}"; } }); // Start/Stop Address this.addColumnTemplate(new DataColumnTemplate(DATA_START_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_START_ADDRESS,fd.getString(DATA_START_ADDRESS)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startAddress","Starting Address"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_ADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_STOP_ADDRESS,fd.getString(DATA_STOP_ADDRESS)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.address","Address"); } }); // (Generic) Elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_ELAPSE_SEC) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ELAPSE_SEC)) { long elapsedSec = fd.getLong(DATA_ELAPSE_SEC,-1L); if (elapsedSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(elapsedSec,fmt)).setSortKey(elapsedSec); return fd.filterReturnedValue(DATA_ELAPSE_SEC, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.elapsedTime","Elapsed\nTime"); } }); // Inside Elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_INSIDE_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_INSIDE_ELAPSED)) { long elapsedSec = fd.getLong(DATA_INSIDE_ELAPSED,-1L); if (elapsedSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(elapsedSec,fmt)).setSortKey(elapsedSec); return fd.filterReturnedValue(DATA_INSIDE_ELAPSED, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.insideElapsed","Inside\nElapsed"); } }); // Outside Elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_OUTSIDE_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_OUTSIDE_ELAPSED)) { long elapsedSec = fd.getLong(DATA_OUTSIDE_ELAPSED,-1L); if (elapsedSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(elapsedSec,fmt)).setSortKey(elapsedSec); return fd.filterReturnedValue(DATA_OUTSIDE_ELAPSED, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.outsideElapsed","Outside\nElapsed"); } }); // Driving/Moving elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVING_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DRIVING_ELAPSED)) { long driveSec = fd.getLong(DATA_DRIVING_ELAPSED,-1L); if (driveSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(driveSec,fmt)).setSortKey(driveSec); return fd.filterReturnedValue(DATA_DRIVING_ELAPSED, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivingElapsed","Driving\nElapsed"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVING_ELAPSED_WH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DRIVING_ELAPSED_WH)) { long driveSec = fd.getLong(DATA_DRIVING_ELAPSED_WH,-1L); if (driveSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(driveSec,fmt)).setSortKey(driveSec); return fd.filterReturnedValue(DATA_DRIVING_ELAPSED_WH, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivingElapsedWorkHours","Work Hour\nElapsed"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_DRIVING_ELAPSED_AH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DRIVING_ELAPSED_AH)) { long driveSec = fd.getLong(DATA_DRIVING_ELAPSED_AH,-1L); if (driveSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(driveSec,fmt)).setSortKey(driveSec); return fd.filterReturnedValue(DATA_DRIVING_ELAPSED_AH, cv); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_DRIVING_ELAPSED) && fd.hasValue(DATA_DRIVING_ELAPSED_WH)) { long driveSecTot = fd.getLong(DATA_DRIVING_ELAPSED,-1L); long driveSecWH = fd.getLong(DATA_DRIVING_ELAPSED_WH,-1L); if ((driveSecWH >= 0L) && (driveSecTot >= driveSecWH)) { long driveSec = driveSecTot - driveSecWH; int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(driveSec,fmt)).setSortKey(driveSec); return fd.filterReturnedValue(DATA_DRIVING_ELAPSED_AH, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.drivingElapsedAfterHours","After Hour\nElapsed"); } }); // Stopped elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_ELAPSED)) { long stopSec = fd.getLong(DATA_STOP_ELAPSED,-1L); if (stopSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(stopSec,fmt)).setSortKey(stopSec); return fd.filterReturnedValue(DATA_STOP_ELAPSED, cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stoppedElapsed","Stopped\nElapsed"); } }); // Stop count (number of stops) this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_COUNT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_COUNT)) { double stopCount = fd.getDouble(DATA_STOP_COUNT,-1.0); if (stopCount >= 0.0) { if ((double)Math.round(stopCount) == stopCount) { // Long value return fd.filterReturnedValue(DATA_STOP_COUNT, String.valueOf((long)stopCount)); } else { // Double value (1 decimal place) return fd.filterReturnedValue(DATA_STOP_COUNT,formatDouble(stopCount,"1","#0")); } } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stopCount","Num. of\nStops"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_COUNT_WH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_COUNT_WH)) { long stopCount = fd.getLong(DATA_STOP_COUNT_WH,-1L); if (stopCount >= 0L) { return fd.filterReturnedValue(DATA_STOP_COUNT_WH, String.valueOf(stopCount)); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stopCountWH","Num. of\nStops\nWork Hours"); } }); // Idle elapsed time this.addColumnTemplate(new DataColumnTemplate(DATA_IDLE_ELAPSED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_IDLE_ELAPSED)) { long idleSec = fd.getLong(DATA_IDLE_ELAPSED,-1L); if (idleSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(idleSec,fmt)).setSortKey(idleSec); if (idleSec >= DateTime.HourSeconds(2)) { //cv.setForegroundColor(ColorTools.RED); } return fd.filterReturnedValue(DATA_IDLE_ELAPSED,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.idleElapsed","Idle\nElapsed"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_AVERAGE_IDLE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_AVERAGE_IDLE_HOURS)) { long idleSec = fd.getLong(DATA_AVERAGE_IDLE_HOURS,-1L); if (idleSec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHMMSS); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(idleSec,fmt)).setSortKey(idleSec); if (idleSec >= DateTime.HourSeconds(2)) { //cv.setForegroundColor(ColorTools.RED); } return fd.filterReturnedValue(DATA_AVERAGE_IDLE_HOURS,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.averageIdleHours","Average\nIdle Hours"); } }); // Attached this.addColumnTemplate(new DataColumnTemplate(DATA_ATTACHED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ATTACHED)) { return fd.filterReturnedValue(DATA_ATTACHED,String.valueOf(fd.getBoolean(DATA_ATTACHED))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.attached","Attached"); } }); // Rule ID this.addColumnTemplate(new DataColumnTemplate(DATA_RULE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_RULE_ID,fd.getString(DATA_RULE_ID)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.ruleID","Rule-ID"); } }); // Message ID this.addColumnTemplate(new DataColumnTemplate(DATA_MESSAGE_ID) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_MESSAGE_ID,fd.getString(DATA_MESSAGE_ID)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.messageID","Message-ID"); } }); // IP address (field) this.addColumnTemplate(new DataColumnTemplate(DATA_IPADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_IPADDRESS,fd.getString(DATA_IPADDRESS)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.ipAddress","IP Address"); } }); // Is Duplex (field) this.addColumnTemplate(new DataColumnTemplate(DATA_ISDUPLEX) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ISDUPLEX)) { return fd.filterReturnedValue(DATA_ISDUPLEX,String.valueOf(fd.getBoolean(DATA_ISDUPLEX))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.isDuplex","Is Duplex?"); } }); // TCP Connections (field) this.addColumnTemplate(new DataColumnTemplate(DATA_TCP_CONNECTIONS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_TCP_CONNECTIONS)) { return fd.filterReturnedValue(DATA_TCP_CONNECTIONS,String.valueOf(fd.getLong(DATA_TCP_CONNECTIONS,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.tcpConnections","TCP\nConnects"); } }); // UDP Connections (field) this.addColumnTemplate(new DataColumnTemplate(DATA_UDP_CONNECTIONS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_UDP_CONNECTIONS)) { return fd.filterReturnedValue(DATA_UDP_CONNECTIONS,String.valueOf(fd.getLong(DATA_UDP_CONNECTIONS,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.udpConnections","UDP\nConnects"); } }); // TCP/UDP Connections (field) this.addColumnTemplate(new DataColumnTemplate(DATA_CONNECTIONS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_CONNECTIONS)) { return fd.filterReturnedValue(DATA_CONNECTIONS,String.valueOf(fd.getLong(DATA_CONNECTIONS,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.connections","Connections"); } }); // Bytes Read (field) this.addColumnTemplate(new DataColumnTemplate(DATA_BYTES_READ) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_BYTES_READ)) { return fd.filterReturnedValue(DATA_BYTES_READ,String.valueOf(fd.getLong(DATA_BYTES_READ,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bytesRead","Bytes\nRead"); } }); // Bytes Overhead (field) this.addColumnTemplate(new DataColumnTemplate(DATA_BYTES_OVERHEAD) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_BYTES_OVERHEAD)) { return fd.filterReturnedValue(DATA_BYTES_OVERHEAD,String.valueOf(fd.getLong(DATA_BYTES_OVERHEAD,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bytesOverhead","Bytes\nOverhead"); } }); // Bytes Written (field) this.addColumnTemplate(new DataColumnTemplate(DATA_BYTES_WRITTEN) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_BYTES_WRITTEN)) { return fd.filterReturnedValue(DATA_BYTES_WRITTEN,String.valueOf(fd.getLong(DATA_BYTES_WRITTEN,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bytesWritten","Bytes\nWritten"); } }); // Bytes Total (field) this.addColumnTemplate(new DataColumnTemplate(DATA_BYTES_TOTAL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_BYTES_TOTAL)) { return fd.filterReturnedValue(DATA_BYTES_TOTAL,String.valueOf(fd.getLong(DATA_BYTES_TOTAL,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bytesTotal","Bytes\nTotal"); } }); // Bytes Rounded (field) this.addColumnTemplate(new DataColumnTemplate(DATA_BYTES_ROUNDED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_BYTES_ROUNDED)) { return fd.filterReturnedValue(DATA_BYTES_ROUNDED,String.valueOf(fd.getLong(DATA_BYTES_ROUNDED,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.bytesRounded","Bytes\nRounded"); } }); // Events Received (field) this.addColumnTemplate(new DataColumnTemplate(DATA_EVENTS_RECEIVED) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_EVENTS_RECEIVED)) { return fd.filterReturnedValue(DATA_EVENTS_RECEIVED,String.valueOf(fd.getLong(DATA_EVENTS_RECEIVED,-1L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.eventsReceived","Events\nReceived"); } }); // Engine RPM (field) this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_RPM) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_ENGINE_RPM)) { return fd.filterReturnedValue(DATA_ENGINE_RPM,String.valueOf(fd.getLong(DATA_ENGINE_RPM,0L))); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.engineRpm","Engine\nRPM"); } }); // Hours (field) this.addColumnTemplate(new DataColumnTemplate(DATA_ENGINE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); double hours = 0.0; if (fd.hasValue(DATA_ENGINE_HOURS)) { hours = fd.getDouble(DATA_ENGINE_HOURS,0.0); } else if (dev != null) { hours = dev.getLastEngineHours(); } if (hours > 0.0) { if (dev != null) { hours += dev.getEngineHoursOffset(); // ok } long sec = Math.round(hours * 3600.0); if (sec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHHh); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(sec,fmt)).setSortKey(sec); return fd.filterReturnedValue(DATA_ENGINE_HOURS,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.engineHours","Engine\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_IDLE_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_IDLE_HOURS)) { double hours = fd.getDouble(DATA_IDLE_HOURS,0.0); long sec = Math.round(hours * 3600.0); if (sec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHHh); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(sec,fmt)).setSortKey(sec); return fd.filterReturnedValue(DATA_IDLE_HOURS,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.idleHours","Idle\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_WORK_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_WORK_HOURS)) { double hours = fd.getDouble(DATA_WORK_HOURS,0.0); long sec = Math.round(hours * 3600.0); if (sec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHHh); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(sec,fmt)).setSortKey(sec); return fd.filterReturnedValue(DATA_WORK_HOURS,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.workHours","Work\nHours"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_PTO_HOURS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_PTO_HOURS)) { double hours = fd.getDouble(DATA_PTO_HOURS,0.0); long sec = Math.round(hours * 3600.0); if (sec >= 0L) { int fmt = FieldLayout.getElapsedFormat(arg, StringTools.ELAPSED_FORMAT_HHHh); ColumnValue cv = new ColumnValue(FieldLayout.formatElapsedTime(sec,fmt)).setSortKey(sec); return fd.filterReturnedValue(DATA_PTO_HOURS,cv); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.ptoHours","PTO\nHours"); } }); // Fuel (field) this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_CAPACITY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_CAPACITY)) { double vol = fd.getDouble(DATA_FUEL_CAPACITY); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_CAPACITY,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelCapacity","Fuel Capacity") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_LEVEL)) { double level = fd.getDouble(DATA_FUEL_LEVEL); // percent if (level < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.notAvailable","n/a"); } else if (level <= 0.0) { return rc.getBlankFiller(); // "0%" } else if (level <= 1.0) { String p = Math.round(level*100.0) + "%"; return fd.filterReturnedValue(DATA_FUEL_LEVEL, p); // percent } else { String p = "100%"; return fd.filterReturnedValue(DATA_FUEL_LEVEL, p); // percent } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelLevel","Fuel Level") + "\n%"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TOTAL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_TOTAL)) { double vol = fd.getDouble(DATA_FUEL_TOTAL); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_TOTAL,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelTotal","Total Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_REMAIN) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_REMAIN)) { double vol = fd.getDouble(DATA_FUEL_REMAIN); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_REMAIN,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelRemain","Remaining Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TRIP) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_TRIP)) { double vol = fd.getDouble(DATA_FUEL_TRIP); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_TRIP,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelTrip","Trip Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TRIP_WH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_TRIP_WH)) { double vol = fd.getDouble(DATA_FUEL_TRIP_WH); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_TRIP_WH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelTripWorkHours","Trip Fuel\nWork Hours") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_TRIP_AH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_TRIP_AH)) { double vol = fd.getDouble(DATA_FUEL_TRIP_AH); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_TRIP_AH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_FUEL_TRIP) && fd.hasValue(DATA_FUEL_TRIP_WH)) { double ft = fd.getDouble(DATA_FUEL_TRIP); // liters double ftwh = fd.getDouble(DATA_FUEL_TRIP_WH); // liters if ((ft >= 0.0) && (ft > ftwh)) { double vol = ft - ftwh; vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_TRIP_AH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelTripAfterHours","Trip Fuel\nAfter Hours") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_IDLE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_IDLE)) { double vol = fd.getDouble(DATA_FUEL_IDLE); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_IDLE,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelIdle","Idle Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_IDLE_WH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_IDLE_WH)) { double vol = fd.getDouble(DATA_FUEL_IDLE_WH); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_IDLE_WH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelIdleWorkHours","Idle Fuel\nWork Hours") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_IDLE_AH) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_IDLE_AH)) { double vol = fd.getDouble(DATA_FUEL_IDLE_AH); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_IDLE_AH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_FUEL_IDLE) && fd.hasValue(DATA_FUEL_IDLE_WH)) { double fi = fd.getDouble(DATA_FUEL_IDLE); // liters double fiwh = fd.getDouble(DATA_FUEL_IDLE_WH); // liters if ((fi >= 0.0) && (fi > fiwh)) { double vol = fi - fiwh; vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_IDLE_AH,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelIdleWorkHours","Idle Fuel\nWork Hours") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_WORK) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_WORK)) { double vol = fd.getDouble(DATA_FUEL_WORK); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_WORK,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_FUEL_TOTAL) && fd.hasValue(DATA_FUEL_IDLE)) { double vol = fd.getDouble(DATA_FUEL_TOTAL) - fd.getDouble(DATA_FUEL_IDLE); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_WORK,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelWork","Work Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_PTO) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_PTO)) { double vol = fd.getDouble(DATA_FUEL_PTO); // liters if (vol > 0.0) { vol = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(vol); return fd.filterReturnedValue(DATA_FUEL_PTO,formatDouble(vol, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelPTO","PTO Fuel") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_ECONOMY) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_ECONOMY)) { double econ = fd.getDouble(DATA_FUEL_ECONOMY); // kilometers per liter if (econ > 0.0) { econ = Account.getEconomyUnits(rd.getAccount()).convertFromKPL(econ); return fd.filterReturnedValue(DATA_FUEL_ECONOMY,formatDouble(econ, arg, "#0.0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.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()); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_ECONOMY_TYPE)) { Object type = fd.getValue(DATA_FUEL_ECONOMY_TYPE); // Device.FuelEconomyType enum if (type instanceof Device.FuelEconomyType) { Locale locale = rd.getPrivateLabel().getLocale(); String typeStr = arg.equalsIgnoreCase("abbr")? ((Device.FuelEconomyType)type).getAbbrev(locale) : ((Device.FuelEconomyType)type).toString(locale); return fd.filterReturnedValue(DATA_FUEL_ECONOMY_TYPE,typeStr); } else if (type != null) { String typeStr = StringTools.trim(type); // convert to string return fd.filterReturnedValue(DATA_FUEL_ECONOMY_TYPE,typeStr); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelEconType","Fuel Econ\nType"); } }); // Start Fuel/Level this.addColumnTemplate(new DataColumnTemplate(DATA_START_FUEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_FUEL)) { double fuel = fd.getDouble(DATA_START_FUEL); // Liters if (fuel > 0.0) { Device dev = fd.getDevice(); fuel = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(fuel); return fd.filterReturnedValue(DATA_START_FUEL,formatDouble(fuel, arg, "#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startFuel","Start\nFuel Total") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_START_FUEL_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_START_FUEL_LEVEL)) { double level = fd.getDouble(DATA_START_FUEL_LEVEL); // percent if (level < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.notAvailable","n/a"); } else if (level <= 0.0) { return rc.getBlankFiller(); // "0%" } else if (level <= 1.0) { String p = Math.round(level*100.0) + "%"; return fd.filterReturnedValue(DATA_START_FUEL_LEVEL, p); // percent } else { String p = "100%"; return fd.filterReturnedValue(DATA_START_FUEL_LEVEL, p); // percent } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startFuelLevel","Start\nFuel Level") + "\n%"; } }); // Stop Fuel/Level this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_FUEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_FUEL)) { double fuel = fd.getDouble(DATA_STOP_FUEL); // Liters if (fuel > 0.0) { Device dev = fd.getDevice(); fuel = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(fuel); return fd.filterReturnedValue(DATA_STOP_FUEL,formatDouble(fuel, arg, "#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.startFuel","Start\nFuel Total") + "\n${volumeUnits}"; } }); this.addColumnTemplate(new DataColumnTemplate(DATA_STOP_FUEL_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_STOP_FUEL_LEVEL)) { double level = fd.getDouble(DATA_STOP_FUEL_LEVEL); // percent if (level < 0.0) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.notAvailable","n/a"); } else if (level <= 0.0) { return rc.getBlankFiller(); // "0%" } else if (level <= 1.0) { String p = Math.round(level*100.0) + "%"; return fd.filterReturnedValue(DATA_STOP_FUEL_LEVEL, p); // percent } else { String p = "100%"; return fd.filterReturnedValue(DATA_STOP_FUEL_LEVEL, p); // percent } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.stopFuelLevel","Stop\nFuel Level") + "\n%"; } }); // Fuel Delta (ie. "Gallons Consumed") this.addColumnTemplate(new DataColumnTemplate(DATA_FUEL_DELTA) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_FUEL_DELTA)) { double deltaFuel = fd.getDouble(DATA_FUEL_DELTA); // Liters if (deltaFuel >= 0.0) { deltaFuel = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(deltaFuel); return fd.filterReturnedValue(DATA_FUEL_DELTA,formatDouble(deltaFuel,arg,"#0")); } else { return rc.getBlankFiller(); } } else if (fd.hasValue(DATA_START_FUEL) && fd.hasValue(DATA_STOP_FUEL)) { double startFuel = fd.getDouble(DATA_START_FUEL); // Liters double stopFuel = fd.getDouble(DATA_STOP_FUEL); // Liters double deltaFuel = stopFuel - startFuel; if (deltaFuel >= 0.0) { deltaFuel = Account.getVolumeUnits(rd.getAccount()).convertFromLiters(deltaFuel); return fd.filterReturnedValue(DATA_FUEL_DELTA,formatDouble(deltaFuel,arg,"#0")); } else { return rc.getBlankFiller(); } } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.fuelUsed","Fuel Used") + "\n${volumeUnits}"; } }); // Delta Fuel Level this.addColumnTemplate(new DataColumnTemplate(DATA_DELTA_FUEL_LEVEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; if (fd.hasValue(DATA_DELTA_FUEL_LEVEL)) { double deltaLevel = fd.getDouble(DATA_DELTA_FUEL_LEVEL); // delta percent String p = Math.round(deltaLevel*100.0) + "%"; return fd.filterReturnedValue(DATA_DELTA_FUEL_LEVEL, p); // percent } else if (fd.hasValue(DATA_START_FUEL_LEVEL) && fd.hasValue(DATA_STOP_FUEL_LEVEL)) { double startLevel = fd.getDouble(DATA_START_FUEL_LEVEL); double stopLevel = fd.getDouble(DATA_STOP_FUEL_LEVEL); double deltaLevel = stopLevel - startLevel; String p = Math.round(deltaLevel*100.0) + "%"; return fd.filterReturnedValue(DATA_DELTA_FUEL_LEVEL, p); // percent } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.deltaFuelLevel","Delta\nFuel Level") + "\n%"; } }); // 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) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long ts = 0L; Device dev = fd.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 } } } if (ts > MIN_REASONABLE_TIMESTAMP) { 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.getDateTimeFormat(rd.getPrivateLabel()), tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); long ageSec = DateTime.getCurrentTimeSec() - ts; ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return fd.filterReturnedValue(DATA_CHECKIN_DATETIME, cv); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lastCheckinTime","Last Check-In\nTime"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_CHECKIN_AGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long ts = 0L; Device dev = fd.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 } } } if (ts > MIN_REASONABLE_TIMESTAMP) { long ageSec = DateTime.getCurrentTimeSec() - ts; 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); ReportLayout.AgeColorRange acr = rd.getCheckinAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return fd.filterReturnedValue(DATA_CHECKIN_AGE,cv); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lastCheckinAge","Since Last\nCheck-In"); } }); // last IP address (DataTransport record) this.addColumnTemplate(new DataColumnTemplate(DATA_LAST_IPADDRESS) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); DTIPAddress ipAddr = (dev != null)? dev.getDataTransport().getIpAddressCurrent() : null; return (ipAddr != null)? fd.filterReturnedValue(DATA_LAST_IPADDRESS,ipAddr.toString()) : ""; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lastIPAddress","Last IP\nAddress"); } }); // Code Version (DataTransport record) this.addColumnTemplate(new DataColumnTemplate(DATA_CODE_VERSION) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); String cv = (dev != null)? dev.getDataTransport().getCodeVersion() : null; return (cv != null)? fd.filterReturnedValue(DATA_CODE_VERSION,cv) : ""; } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.codeVersion","Code\nVersion"); } }); // 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(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); String value = dev.getCustomAttribute(arg); return !StringTools.isBlank(value)? value : ""; } 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(FieldLayout.class); return i18n.getString("FieldLayout.customAttribute","Custom\nAttribute"); } } }); // Fault Codes this.addColumnTemplate(new DataColumnTemplate(DATA_FAULT_CODES) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); String faultStr = (dev != null)? dev.getLastFaultCode() : null; if (StringTools.isBlank(faultStr)) { return rc.getBlankFiller(); } else { String fc = DTOBDFault.GetFaultString(new RTProperties(faultStr)); return fd.filterReturnedValue(DATA_FAULT_CODES,fc); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.faultCodes","OBD Faults"); } }); // Command state mask this.addColumnTemplate(new DataColumnTemplate(DATA_COMMAND_STATE_MASK) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); long csm = (dev != null)? dev.getCommandStateMask() : 0L; String v = ""; if (StringTools.isBlank(arg) || arg.equalsIgnoreCase("dec")) { v = String.valueOf(csm); } else if (arg.equalsIgnoreCase("hex")) { v = "0x" + StringTools.toHexString(csm,16); } else if (arg.equalsIgnoreCase("bin")) { v = StringTools.toBinaryString(csm,16,null).toString(); } else { v = String.valueOf(csm); } return fd.filterReturnedValue(DATA_COMMAND_STATE_MASK,v); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.commandState","Command\nState"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_COMMAND_STATE_BIT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg[] = StringTools.split(rc.getArg(),','); // "0,no,yes" int bitNdx = (arg.length > 0)? StringTools.parseInt(arg[0],0) : 0; FieldData fd = (FieldData)obj; Device dev = fd.getDevice(); boolean state = (dev != null)? dev.getCommandStateMaskBit(bitNdx) : false; Locale locale = rd.getPrivateLabel().getLocale(); String v = state? AccountRecord.GetSimpleLocalString((arg.length>2)?arg[2]:"1",locale) : AccountRecord.GetSimpleLocalString((arg.length>1)?arg[1]:"0",locale); return fd.filterReturnedValue(DATA_COMMAND_STATE_BIT,v); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); String arg[] = StringTools.split(rc.getArg(),','); // "0,no,yes" int bitNdx = (arg.length > 0)? StringTools.parseInt(arg[0],0) : 0; String bitNdxS = String.valueOf(bitNdx); return i18n.getString("FieldLayout.commandStateBit","Command\nState\n#{0}", bitNdxS); } }); // last login date/time (Account record) this.addColumnTemplate(new DataColumnTemplate(DATA_LOGIN_DATETIME) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long ts = 0L; if (fd.hasValue(DATA_LOGIN_DATETIME)) { ts = fd.getLong(DATA_LOGIN_DATETIME); } else { Account acct = fd.getAccount(); ts = (acct != null)? acct.getLastLoginTime() : 0L; } if (ts > MIN_REASONABLE_TIMESTAMP) { ReportLayout rl = rd.getReportLayout(); TimeZone tz = rd.getTimeZone(); DateTime dt = new DateTime(ts); String dtFmt = dt.format(rl.getDateTimeFormat(rd.getPrivateLabel()), tz); ColumnValue cv = new ColumnValue(dtFmt).setSortKey(ts); long ageSec = DateTime.getCurrentTimeSec() - ts; ReportLayout.AgeColorRange acr = rd.getLoginAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return fd.filterReturnedValue(DATA_LOGIN_DATETIME, cv); } else { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); String never = i18n.getString("FieldLayout.loginNever","never"); ColumnValue cv = new ColumnValue(never).setSortKey(0); cv.setForegroundColor(ColorTools.RED); return fd.filterReturnedValue(DATA_LOGIN_DATETIME, cv); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lastLoginTime","Last Login\nTime"); } }); this.addColumnTemplate(new DataColumnTemplate(DATA_LOGIN_AGE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; long ts = 0L; if (fd.hasValue(DATA_LOGIN_DATETIME)) { ts = fd.getLong(DATA_LOGIN_DATETIME); } else { Account acct = fd.getAccount(); ts = (acct != null)? acct.getLastLoginTime() : 0L; } if (ts > MIN_REASONABLE_TIMESTAMP) { long ageSec = DateTime.getCurrentTimeSec() - ts; 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); ReportLayout.AgeColorRange acr = rd.getLoginAgeColorRange(ageSec); ReportLayout.SetColumnValueAgeColor(cv,acr); return fd.filterReturnedValue(DATA_LOGIN_AGE,cv); } else { ColumnValue cv = new ColumnValue(rc.getBlankFiller()).setSortKey(999999999L); cv.setForegroundColor(ColorTools.RED); return fd.filterReturnedValue(DATA_LOGIN_AGE,cv); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.lastLoginAge","Since Last\nLogin"); } }); // Account active this.addColumnTemplate(new DataColumnTemplate(DATA_ACCOUNT_ACTIVE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Account acct = fd.getAccount(); if (acct != null) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); boolean isActive = acct.isActive(); String value = isActive? i18n.getString("FieldLayout.activeYes","Yes") : i18n.getString("FieldLayout.activeNo" ,"No" ); return fd.filterReturnedValue(DATA_ACCOUNT_ACTIVE,value); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.accountActive","Account\nActive"); } }); // Account device Count this.addColumnTemplate(new DataColumnTemplate(DATA_DEVICE_COUNT) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Account acct = fd.getAccount(); if (acct != null) { long devCount = acct.getDeviceCount(); return fd.filterReturnedValue(DATA_DEVICE_COUNT,String.valueOf(devCount)); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.deviceCount","Device\nCount"); } }); // Account PrivateLabel name this.addColumnTemplate(new DataColumnTemplate(DATA_PRIVATE_LABEL) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; Account acct = fd.getAccount(); if (acct != null) { String privLabel = acct.getPrivateLabelName(); return fd.filterReturnedValue(DATA_PRIVATE_LABEL,privLabel); } else { return rc.getBlankFiller(); } } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.privateLabelName","PrivateLabel\nName"); } }); // Left-align string #1 this.addColumnTemplate(new DataColumnTemplate(DATA_LEFT_ALIGN_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_LEFT_ALIGN_1,fd.getString(DATA_LEFT_ALIGN_1)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.leftAlign1","String 1"); } }); // Left-align string #2 this.addColumnTemplate(new DataColumnTemplate(DATA_LEFT_ALIGN_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_LEFT_ALIGN_2,fd.getString(DATA_LEFT_ALIGN_2)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.leftAlign1","String 1"); } }); // Right-align string #1 this.addColumnTemplate(new DataColumnTemplate(DATA_RIGHT_ALIGN_1) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_RIGHT_ALIGN_1,fd.getString(DATA_RIGHT_ALIGN_1)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.rightAlign1","String 1"); } }); // Right-align string #2 this.addColumnTemplate(new DataColumnTemplate(DATA_RIGHT_ALIGN_2) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); FieldData fd = (FieldData)obj; return fd.filterReturnedValue(DATA_RIGHT_ALIGN_2,fd.getString(DATA_RIGHT_ALIGN_2)); } public String getTitle(ReportData rd, ReportColumn rc) { I18N i18n = rd.getPrivateLabel().getI18N(FieldLayout.class); return i18n.getString("FieldLayout.rightAlign2","String 2"); } }); // Blank space (this was included per a users request) this.addColumnTemplate(new DataColumnTemplate(DATA_BLANK_SPACE) { public Object getColumnValue(int rowNdx, ReportData rd, ReportColumn rc, Object obj) { String arg = rc.getArg(); return rc.getBlankFiller(); } public String getTitle(ReportData rd, ReportColumn rc) { return ""; } }); } } // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ protected static int getElapsedFormat(char fmt, int dft) { switch (fmt) { case '-': return StringTools.ELAPSED_FORMAT_SS ; case '0': return StringTools.ELAPSED_FORMAT_HHMMSS; case '1': return StringTools.ELAPSED_FORMAT_HHMM ; case '2': return StringTools.ELAPSED_FORMAT_HHHhh ; case '3': return StringTools.ELAPSED_FORMAT_HHHh ; case '4': return StringTools.ELAPSED_FORMAT_MMMSS ; default : return dft; } } protected static int getElapsedFormat(String arg, int dft) { if ((arg != null) && (arg.length() > 0)) { return FieldLayout.getElapsedFormat(arg.charAt(0), dft); } else { return dft; } } protected static String formatElapsedTime(long elapsedSec, int fmt) { return StringTools.formatElapsedSeconds(elapsedSec, fmt); } }