/* return the DBSelect statement for the specified account/group */
protected static DBSelect _getUserListSelect(String acctId, String groupId) {
/* empty/null account */
if (StringTools.isBlank(acctId)) {
return null;
}
/* empty/null user */
if (StringTools.isBlank(groupId)) {
return null;
}
/* get select */
// DBSelect: SELECT * FROM GroupList WHERE ((accountID='acct') and (groupID='group')) ORDER BY
// userID
DBSelect<GroupList> dsel = new DBSelect<GroupList>(GroupList.getFactory());
dsel.setSelectedFields(GroupList.FLD_userID);
DBWhere dwh = dsel.createDBWhere();
dsel.setWhere(
dwh.WHERE_(
dwh.AND(
dwh.EQ(GroupList.FLD_accountID, acctId), dwh.EQ(GroupList.FLD_groupID, groupId))));
dsel.setOrderByFields(GroupList.FLD_userID);
return dsel;
}
/* validate the syntax of the specified list of multiple email addresses */
public static boolean validateAddresses(String addrs, boolean acceptSMS) {
if (StringTools.isBlank(addrs)) {
// blank is ok in this case
return true;
} else if (acceptSMS) {
// allow "sms:123456789" format
String addrArry[] = StringTools.parseStringArray(addrs, ',');
if (addrArry.length == 0) {
return false;
}
for (int i = 0; i < addrArry.length; i++) {
String em = addrArry[i].trim();
if (StringTools.isBlank(em)) {
// individual addresses not allowed
return false;
} else if (SMSOutboundGateway.StartsWithSMS(em)) {
// TODO: for now, accept as-is
} else if (!validateAddress(em)) {
return false;
}
}
return true;
} else {
// true email addresses only
try {
return SendMail.validateAddresses(addrs);
} catch (Throwable t) { // NoClassDefFoundException, ClassNotFoundException
// this will fail if JavaMail support for SendMail is not available.
Print.logError("*** SendMail error: " + t);
return false;
}
}
}
/* return status codes for account/device */
public static int[] getStatusCodes(String accountID, String deviceID) throws DBException {
/* account-id specified? */
if (StringTools.isBlank(accountID)) {
return new int[0];
}
/* device-id specified? */
if (StringTools.isBlank(deviceID)) {
deviceID = ALL_DEVICES;
}
/* select */
// DBSelect: SELECT statucCode FROM StatusCode WHERE (accountID='acct') AND (deviceID='*') ORDER
// BY statucCode
DBSelect<StatusCode> dsel = new DBSelect<StatusCode>(StatusCode.getFactory());
dsel.setSelectedFields(StatusCode.FLD_statusCode);
DBWhere dwh = dsel.createDBWhere();
dsel.setWhere(
dwh.WHERE_(
dwh.AND(
dwh.EQ(StatusCode.FLD_accountID, accountID),
dwh.EQ(StatusCode.FLD_deviceID, deviceID))));
dsel.setOrderByFields(StatusCode.FLD_statusCode);
/* get list */
java.util.List<Integer> codeList = new Vector<Integer>();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = DBConnection.getDefaultConnection().execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
int code = rs.getInt(StatusCode.FLD_statusCode);
codeList.add(new Integer(code));
}
} catch (SQLException sqe) {
throw new DBException("Getting StatusCode List", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
}
/* return array of status codes */
int codeListInt[] = new int[codeList.size()];
for (int i = 0; i < codeListInt.length; i++) {
codeListInt[i] = codeList.get(i).intValue();
}
return codeListInt;
}
/* return StatusCode */
public static StatusCode findStatusCode(String accountID, String deviceID, int statusCode) {
/* check account status codes */
if (!StringTools.isBlank(accountID)) {
// first, try account/device
if (!StringTools.isBlank(deviceID)) {
try {
StatusCode.Key codeKey = new StatusCode.Key(accountID, deviceID, statusCode);
if (codeKey.exists()) { // may throw DBException
StatusCode code = codeKey.getDBRecord(true);
if (code != null) { // should not be null
return code;
}
}
} catch (DBException dbe) {
// ignore error
}
}
// next, try just the account
try {
StatusCode.Key codeKey = new StatusCode.Key(accountID, statusCode);
if (codeKey.exists()) { // may throw DBException
StatusCode code = codeKey.getDBRecord(true);
if (code != null) { // should not be null
return code;
}
}
} catch (DBException dbe) {
// ignore error
}
}
/* check global status codes */
String sysAdmin = AccountRecord.getSystemAdminAccountID();
if (!StringTools.isBlank(sysAdmin)) {
try {
StatusCode.Key codeKey = new StatusCode.Key(sysAdmin, statusCode);
if (codeKey.exists()) { // may throw DBException
StatusCode code = codeKey.getDBRecord(true);
if (code != null) { // should not be null
return code;
}
}
} catch (DBException dbe) {
// ignore error
}
}
/* icon selector not found */
return null;
}
/* return list of all Devices within the specified DeviceGroup (NOT SCALABLE BEYOND A FEW HUNDRED GROUPS) */
public static java.util.List<String> getUsersForGroup(String acctId, String groupId)
throws DBException {
/* valid account/groupId? */
if (StringTools.isBlank(acctId)) {
return null;
} else if (StringTools.isBlank(groupId)) {
return null;
}
/* get db selector */
DBSelect dsel = GroupList._getUserListSelect(acctId, groupId);
if (dsel == null) {
return null;
}
/* read users for group */
java.util.List<String> usrList = new Vector<String>();
DBConnection dbc = null;
Statement stmt = null;
ResultSet rs = null;
try {
dbc = DBConnection.getDefaultConnection();
stmt = dbc.execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
String usrId = rs.getString(GroupList.FLD_userID);
usrList.add(usrId);
}
} catch (SQLException sqe) {
throw new DBException("Get Group GroupeList", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
DBConnection.release(dbc);
}
/* return list */
return usrList;
}
/* set Role access level */
public static void setAccessLevel(Role role, String aclId, AccessLevel level) throws DBException {
/* role specified? */
if (role == null) {
throw new DBException("Role not specified.");
}
String acctId = role.getAccountID();
String roleId = role.getRoleID();
/* acl-id specified? */
if (StringTools.isBlank(aclId)) {
throw new DBException("Acl-ID not specified.");
}
/* get/create role */
RoleAcl roleAcl = null;
RoleAcl.Key aclKey = new RoleAcl.Key(acctId, roleId, aclId);
if (aclKey.exists()) { // may throw DBException
roleAcl = RoleAcl.getRoleAcl(role, aclId); // may throw DBException
} else {
roleAcl = aclKey.getDBRecord();
roleAcl.setRole(role);
}
/* set access level */
int levelInt = (level != null) ? level.getIntValue() : AccessLevel.NONE.getIntValue();
roleAcl.setAccessLevel(levelInt);
/* save */
roleAcl.save(); // may throw DBException
}
public GoogleSig getSignature() {
if (!this.signature_init) {
this.signature_init = true;
String key = this.getAuthorization();
if (!StringTools.isBlank(key) && key.startsWith(CLIENT_ID_PREFIX)) {
String sigKey = this.getProperties().getString(PROP_signatureKey, "");
if (!StringTools.isBlank(sigKey)) {
Print.logWarn("Setting SignatureKey: " + sigKey);
this.signature = new GoogleSig(sigKey);
} else {
Print.logWarn("No signatureKey ...");
}
}
}
return this.signature;
}
public void setGeozoneID(String gzid) {
if (!StringTools.isBlank(gzid)) {
this.fieldValues.setString(EventData.FLD_geozoneID, gzid);
} else {
this.fieldValues.removeProperty(EventData.FLD_geozoneID);
}
}
/* set Role access level */
public static boolean deleteAccessLevel(Role role, String aclId) throws DBException {
/* role specified? */
if (role == null) {
return false; // quietly ignore
}
String acctId = role.getAccountID();
String roleId = role.getRoleID();
/* acl-id specified? */
if (StringTools.isBlank(aclId)) {
return false; // quietly ignore
}
/* already deleted? */
boolean aclExists = RoleAcl.exists(acctId, roleId, aclId);
if (!aclExists) {
return false;
}
/* delete */
RoleAcl.Key aclKey = new RoleAcl.Key(acctId, roleId, aclId);
aclKey.delete(true); // also delete dependencies
return true;
}
/* get/create device list entry */
public static GroupList getGroupList(User user, String groupID, boolean createOK)
throws DBException {
// does not return null, if 'createOK' is true
/* User specified? */
if (user == null) {
throw new DBException("User not specified.");
}
String accountID = user.getAccountID();
String userID = user.getUserID();
/* group exists? */
if (StringTools.isBlank(groupID)) {
throw new DBException("DeviceGroup ID not specified.");
} else if (!DeviceGroup.exists(accountID, groupID)) {
throw new DBException("DeviceGroup does not exist: " + accountID + "/" + groupID);
}
/* create/save record */
GroupList.Key grpListKey = new GroupList.Key(accountID, userID, groupID);
if (grpListKey.exists()) { // may throw DBException
// already exists
GroupList listItem = grpListKey.getDBRecord(true);
listItem.setUser(user);
return listItem;
} else if (createOK) {
GroupList listItem = grpListKey.getDBRecord();
listItem.setCreationDefaultValues();
listItem.setUser(user);
return listItem;
} else {
// record doesn't exist, and caller doesn't want us to create it
return null;
}
}
public void setFieldValue(String fldName, Object fldVal) {
if (!StringTools.isBlank(fldName) && (fldVal != null)) {
if (USE_ALTERNATE_FIELD_MAP) {
this.getAlternateFieldMap().put(fldName, fldVal);
} else {
this.fieldValues.setProperty(fldName, fldVal);
}
}
}
/* Return specified StatusCode, create if specified */
private static StatusCode _getStatusCode(
String accountID, Account account, String deviceID, int code, boolean createOK)
throws DBException {
// does not return null if 'createOK' is true
/* account-id specified? */
if (StringTools.isBlank(accountID)) {
if (account == null) {
throw new DBException("Account not specified.");
} else {
accountID = account.getAccountID();
}
} else if ((account != null) && !account.getAccountID().equals(accountID)) {
throw new DBException("Account does not match specified AccountID.");
}
/* device-id specified? */
if (StringTools.isBlank(deviceID)) {
// throw new DBException("Device-ID not specified.");
deviceID = ALL_DEVICES;
}
/* get/create entity */
StatusCode.Key scKey = new StatusCode.Key(accountID, deviceID, code);
if (scKey.exists()) { // may throw DBException
StatusCode sc = scKey.getDBRecord(true);
if (account != null) {
sc.setAccount(account);
}
return sc;
} else if (createOK) {
StatusCode sc = scKey.getDBRecord();
if (account != null) {
sc.setAccount(account);
}
sc.setCreationDefaultValues();
return sc; // not yet saved!
} else {
// record doesn't exist, and caller doesn't want us to create it
return null;
}
}
/* write JS to stream */
public void writeJavaScript(PrintWriter out, RequestProperties reqState) throws IOException {
/* prefetch map "Loading" image */
if (this.getProperties().getBoolean(PROP_MAP_LOADING, false)) {
String mapLoadingImageURI = this.getProperties().getString(PROP_MAP_LOADING_IMAGE, null);
if (!StringTools.isBlank(mapLoadingImageURI)) {
out.write("<link rel=\"prefetch\" href=\"" + mapLoadingImageURI + "\">\n");
}
}
/* JSMap variables */
JavaScriptTools.writeStartJavaScript(out);
this.writeJSVariables(out, reqState);
JavaScriptTools.writeEndJavaScript(out);
/* Subclass JavaScript includes */
// links to MapProvider support are written by the subclass here
this.writeJSIncludes(out, reqState);
/* JSMap Custom included JavaScript */
String jsMapURLs[] =
StringTools.parseStringArray(this.getProperties().getString(PROP_javascript_src, ""), '\n');
this.writeJSIncludes(out, reqState, jsMapURLs);
/* JSMap Custom inline JavaScript */
String jsMapInline =
StringTools.trim(this.getProperties().getString(PROP_javascript_inline, null));
if (!StringTools.isBlank(jsMapInline)) {
JavaScriptTools.writeStartJavaScript(out);
out.write("// --- Inline Javascript [" + this.getName() + "]\n");
out.write(jsMapInline);
out.write("\n");
JavaScriptTools.writeEndJavaScript(out);
}
/* event CSV parsing code */
JavaScriptTools.writeStartJavaScript(out);
out.write(EventUtil.getInstance().getParseMapEventJS(reqState.isFleet(), reqState.getLocale()));
JavaScriptTools.writeEndJavaScript(out);
}
/* validate the syntax of the specified single email address */
public static boolean validateAddress(String addr) {
if (StringTools.isBlank(addr)) {
// blanks not alowed here
return false; // fail quickly
} else {
try {
return SendMail.validateAddress(addr);
} catch (Throwable t) { // NoClassDefFoundException, ClassNotFoundException
// this will fail if JavaMail support for SendMail is not available.
Print.logWarn("SendMail error: " + t);
return false;
}
}
}
/* write mapping support JS to stream */
public static void writePushpinArray(PrintWriter out, RequestProperties reqState)
throws IOException {
MapProvider mapProv = reqState.getMapProvider();
out.write("// Icon URLs\n");
out.write("var jsvPushpinIcon = new Array(\n");
OrderedMap<String, PushpinIcon> iconMap = mapProv.getPushpinIconMap(reqState);
for (Iterator<String> k = iconMap.keyIterator(); k.hasNext(); ) {
String key = k.next();
PushpinIcon ppi = iconMap.get(key);
String I = ppi.getIconURL();
boolean iE = ppi.getIconEval();
int iW = ppi.getIconWidth();
int iH = ppi.getIconHeight();
int iX = ppi.getIconHotspotX();
int iY = ppi.getIconHotspotY();
String S = ppi.getShadowURL();
int sW = ppi.getShadowWidth();
int sH = ppi.getShadowHeight();
String B = ppi.getBackgroundURL();
int bW = ppi.getBackgroundWidth();
int bH = ppi.getBackgroundHeight();
int bX = ppi.getBackgroundOffsetX();
int bY = ppi.getBackgroundOffsetY();
out.write(" {");
out.write(" key:\"" + key + "\",");
if (iE) {
out.write(" iconEval:\"" + I + "\",");
} else {
out.write(" iconURL:\"" + I + "\",");
}
out.write(" iconSize:[" + iW + "," + iH + "],");
out.write(" iconOffset:[" + iX + "," + iY + "],");
out.write(" iconHotspot:[" + iX + "," + iY + "],");
out.write(" shadowURL:\"" + S + "\",");
out.write(" shadowSize:[" + sW + "," + sH + "]");
if (!StringTools.isBlank(B)) {
out.write(",");
out.write(" bgURL:\"" + B + "\",");
out.write(" bgSize:[" + bW + "," + bH + "],");
out.write(" bgOffset:[" + bX + "," + bY + "]");
}
out.write(" }");
if (k.hasNext()) {
out.write(",");
}
out.write("\n");
}
out.write(" );\n");
}
/* Return status code description (used by RuleInfo, RequestProperties) */
public static String getDescription(
String accountID, int statusCode, BasicPrivateLabel pl, String dftDesc) {
/* custom code (record) */
StatusCode code = StatusCode.findStatusCode(accountID, null, statusCode);
if (code != null) {
return code.getDescription();
}
/* default */
if (!StringTools.isBlank(dftDesc)) {
return dftDesc;
} else {
return StatusCodes.GetDescription(statusCode, pl);
}
}
/* Return status code description */
public static String getDescription(
Device device, int statusCode, BasicPrivateLabel bpl, String dftDesc) {
/* device code */
if (device != null) {
StatusCode code = device.getStatusCode(statusCode);
if (code != null) {
return code.getDescription();
}
}
/* default */
if (!StringTools.isBlank(dftDesc)) {
return dftDesc;
} else {
return StatusCodes.GetDescription(statusCode, bpl);
}
}
/* return Role access level */
public static AccessLevel getAccessLevel(Role role, String aclId, AccessLevel dftAccess) {
if (role == null) {
return dftAccess;
} else if (StringTools.isBlank(aclId)) {
return dftAccess;
} else {
try {
RoleAcl roleAcl = RoleAcl.getRoleAcl(role, aclId); // may throw DBException
if (roleAcl != null) {
return RoleAcl.getAccessLevel(roleAcl);
} else {
return dftAccess;
}
} catch (DBException dbe) {
// error occurred
return AccessLevel.NONE;
}
}
}
protected Device loadDevice(String acctID, String devID) {
if (StringTools.isBlank(acctID)) {
return this.loadDevice(devID); // load ad ModemID
} else {
try {
Account account = Account.getAccount(acctID);
if (account == null) {
Print.logError("Account-ID not found: " + acctID);
return null;
} else {
Device dev = Transport.loadDeviceByTransportID(account, devID);
return dev;
}
} catch (DBException dbe) {
Print.logError("Error getting Device: " + acctID + "/" + devID + " [" + dbe + "]");
return null;
}
}
}
/* Return specified role ACL, create if specified */
public static RoleAcl getRoleAcl(Role role, String aclId, boolean create) throws DBException {
// does not return null
/* role specified? */
if (role == null) {
throw new DBNotFoundException("Role not specified.");
}
String acctId = role.getAccountID();
String roleId = role.getRoleID();
/* acl-id specified? */
if (StringTools.isBlank(aclId)) {
throw new DBNotFoundException("Acl-ID not specified.");
}
/* get/create role */
RoleAcl roleAcl = null;
RoleAcl.Key aclKey = new RoleAcl.Key(acctId, roleId, aclId);
if (!aclKey.exists()) { // may throw DBException
if (create) {
roleAcl = aclKey.getDBRecord();
roleAcl.setRole(role);
roleAcl.setCreationDefaultValues();
return roleAcl; // not yet saved!
} else {
throw new DBNotFoundException("Acl-ID does not exists '" + aclKey + "'");
}
} else if (create) {
// we've been asked to create the Acl, and it already exists
throw new DBAlreadyExistsException("Acl-ID already exists '" + aclKey + "'");
} else {
roleAcl = RoleAcl.getRoleAcl(role, aclId); // may throw DBException
if (roleAcl == null) {
throw new DBException("Unable to read existing Role-ID '" + aclKey + "'");
}
return roleAcl;
}
}
/* create a new StatusCode */
public static StatusCode createNewStatusCode(Account account, String deviceID, int code)
throws DBException {
/* invalid account */
if (account == null) {
throw new DBException("Invalid/Null Account specified");
}
/* invalid code */
if ((code < 0) || (code > 0xFFFF)) {
throw new DBException("Invalid StatusCode specified");
}
/* default to 'ALL' devices */
if (StringTools.isBlank(deviceID)) {
deviceID = ALL_DEVICES;
}
/* create status code */
StatusCode sc = StatusCode.getStatusCode(account, deviceID, code, true); // does not return null
sc.save();
return sc;
}
public static void main(String argv[]) {
DBConfig.cmdLineInit(argv, true); // main
String accountID = RTConfig.getString(ARG_ACCOUNT, "");
String deviceID = RTConfig.getString(ARG_DEVICE, "");
int statusCode = RTConfig.getInt(ARG_CODE, 0);
boolean anyCode = true; // RTConfig.hasProperty(ARG_ECODE);
/* account-id specified? */
if (StringTools.isBlank(accountID)) {
Print.logError("Account-ID not specified.");
usage();
}
/* get account */
Account account = null;
try {
account = Account.getAccount(accountID); // may throw DBException
if (account == null) {
Print.logError("Account-ID does not exist: " + accountID);
usage();
}
} catch (DBException dbe) {
Print.logException("Error loading Account: " + accountID, dbe);
// dbe.printException();
System.exit(99);
}
/* device-id specified? */
if (StringTools.isBlank(deviceID) || deviceID.startsWith("/")) {
deviceID = ALL_DEVICES;
}
/* check device existance */
if (!deviceID.equals(ALL_DEVICES)) {
try {
Device device = Device.getDevice(account, deviceID); // may throw DBException
if (device == null) {
Print.logError("Device-ID does not exist: " + accountID + " / " + deviceID);
usage();
}
} catch (DBException dbe) {
Print.logException("Error loading Device: " + accountID + " / " + deviceID, dbe);
System.exit(99);
}
}
/* status-code specified? */
if ((statusCode > 0)
&& !anyCode
&& !StatusCodes.IsValid(statusCode, account.getPrivateLabel())) {
Print.logError("Invalid Status Code specified.");
usage();
}
/* statusCode specified? */
if (statusCode <= 0) {
Print.logError("StatusCode not specified.");
usage();
}
/* statusCode exists? */
boolean statusCodeExists = false;
try {
statusCodeExists = StatusCode.exists(accountID, deviceID, statusCode);
} catch (DBException dbe) {
Print.logError(
"Error determining if StatusCode exists: "
+ accountID
+ "/"
+ deviceID
+ "/"
+ statusCode);
System.exit(99);
}
/* option count */
int opts = 0;
/* delete */
if (RTConfig.getBoolean(ARG_DELETE, false)) {
opts++;
if (!statusCodeExists) {
Print.logWarn(
"StatusCode does not exist: " + accountID + "/" + deviceID + "/" + statusCode);
Print.logWarn("Continuing with delete process ...");
}
try {
StatusCode.Key scKey = new StatusCode.Key(accountID, deviceID, statusCode);
scKey.delete(true); // also delete dependencies (if any)
Print.logInfo("StatusCode deleted: " + accountID + "/" + deviceID + "/" + statusCode);
statusCodeExists = false;
} catch (DBException dbe) {
Print.logError(
"Error deleting StatusCode: " + accountID + "/" + deviceID + "/" + statusCode);
dbe.printException();
System.exit(99);
}
System.exit(0);
}
/* create */
if (RTConfig.getBoolean(ARG_CREATE, false)) {
opts++;
if (statusCodeExists) {
Print.logWarn(
"StatusCode already exists: " + accountID + "/" + deviceID + "/" + statusCode);
} else {
try {
StatusCode.createNewStatusCode(account, deviceID, statusCode);
Print.logInfo("Created StatusCode: " + accountID + "/" + deviceID + "/" + statusCode);
statusCodeExists = true;
} catch (DBException dbe) {
Print.logError(
"Error creating StatusCode: " + accountID + "/" + deviceID + "/" + statusCode);
dbe.printException();
System.exit(99);
}
}
}
/* edit */
if (RTConfig.getBoolean(ARG_EDIT, false)) {
opts++;
if (!statusCodeExists) {
Print.logError(
"StatusCode does not exist: " + accountID + "/" + deviceID + "/" + statusCode);
} else {
try {
StatusCode sc =
StatusCode.getStatusCode(account, deviceID, statusCode); // may throw DBException
DBEdit editor = new DBEdit(sc);
editor.edit(); // may throw IOException
} catch (IOException ioe) {
if (ioe instanceof EOFException) {
Print.logError("End of input");
} else {
Print.logError("IO Error");
}
} catch (DBException dbe) {
Print.logError(
"Error editing StatusCode: " + accountID + "/" + deviceID + "/" + statusCode);
dbe.printException();
}
}
System.exit(0);
}
/* list */
if (RTConfig.hasProperty(ARG_LIST)) {
opts++;
String listType = RTConfig.getString(ARG_LIST, null);
// TODO: complete ...
}
/* no options specified */
if (opts == 0) {
Print.logWarn("Missing options ...");
usage();
}
}
public static void main(String args[]) {
DBConfig.cmdLineInit(args, true); // main
String acctID = RTConfig.getString(ARG_ACCOUNT, "");
String strID = RTConfig.getString(ARG_STRING, "");
/* account-id specified? */
if (StringTools.isBlank(acctID)) {
Print.logError("Account-ID not specified.");
usage();
}
/* get account */
Account acct = null;
try {
acct = Account.getAccount(acctID); // may throw DBException
if (acct == null) {
Print.logError("Account-ID does not exist: " + acctID);
usage();
}
} catch (DBException dbe) {
Print.logException("Error loading Account: " + acctID, dbe);
// dbe.printException();
System.exit(99);
}
/* string-id specified? */
if ((strID == null) || strID.equals("")) {
Print.logError("String-ID not specified.");
usage();
}
/* string exists? */
boolean stringExists = false;
try {
stringExists = AccountString.exists(acctID, strID);
} catch (DBException dbe) {
Print.logError("Error determining if AccountString exists: " + _fmtStrID(acctID, strID));
System.exit(99);
}
/* option count */
int opts = 0;
/* delete */
if (RTConfig.getBoolean(ARG_DELETE, false) && !acctID.equals("") && !strID.equals("")) {
opts++;
if (!stringExists) {
Print.logWarn("AccountString does not exist: " + _fmtStrID(acctID, strID));
Print.logWarn("Continuing with delete process ...");
}
try {
AccountString.Key strKey = new AccountString.Key(acctID, strID);
strKey.delete(true); // also delete dependencies
Print.logInfo("AccountString deleted: " + _fmtStrID(acctID, strID));
stringExists = false;
} catch (DBException dbe) {
Print.logError("Error deleting AccountString: " + _fmtStrID(acctID, strID));
dbe.printException();
System.exit(99);
}
System.exit(0);
}
/* create */
if (RTConfig.getBoolean(ARG_CREATE, false)) {
opts++;
if (stringExists) {
Print.logWarn("AccountString already exists: " + _fmtStrID(acctID, strID));
} else {
try {
AccountString.createNewAccountString(acct, strID);
Print.logInfo("Created AccountString: " + _fmtStrID(acctID, strID));
stringExists = true;
} catch (DBException dbe) {
Print.logError("Error creating AccountString: " + _fmtStrID(acctID, strID));
dbe.printException();
System.exit(99);
}
}
}
/* edit */
if (RTConfig.getBoolean(ARG_EDIT, false)) {
opts++;
if (!stringExists) {
Print.logError("AccountString does not exist: " + _fmtStrID(acctID, strID));
} else {
try {
AccountString str =
AccountString.getAccountString(acct, strID, false); // may throw DBException
DBEdit editor = new DBEdit(str);
editor.edit(true); // may throw IOException
} catch (IOException ioe) {
if (ioe instanceof EOFException) {
Print.logError("End of input");
} else {
Print.logError("IO Error");
}
} catch (DBException dbe) {
Print.logError("Error editing AccountString: " + _fmtStrID(acctID, strID));
dbe.printException();
}
}
System.exit(0);
}
/* no options specified */
if (opts == 0) {
Print.logWarn("Missing options ...");
usage();
}
}
private int _writeHTML(PrintWriter out, int level, ReportData rd, int ndx)
throws ReportException {
RequestProperties reqState = rd.getRequestProperties();
boolean isEMail = reqState.getEncodeEMailHTML();
PrivateLabel privLabel = rd.getPrivateLabel();
I18N i18n = privLabel.getI18N(ReportTable.class);
out.print("<center>\n");
out.print("<table cellspacing='0' cellpadding='0' border='0'>\n");
/* report title row */
{
String rptTitle = rd.getReportTitle();
out.print(
"<tr><td colSpan='3'><H1 class=\"rptTitle\">"
+ FilterText(rptTitle)
+ "</H1></td></tr>\n");
}
/* report subtitle row */
{
out.print("<tr>\n");
// "Refresh"
out.print("<td>");
StringBuffer linkSB_L = new StringBuffer();
String refreshURL = (!isEMail && (ndx <= 0)) ? EncodeURL(reqState, rd.getRefreshURL()) : null;
if (!StringTools.isBlank(refreshURL)) {
String refreshDesc = i18n.getString("ReportTable.refreshReport", "Refresh");
if (linkSB_L.length() > 0) {
linkSB_L.append(" ");
} // add space between links
linkSB_L.append(
"<a href='" + refreshURL + "' target='_self'>" + refreshDesc + "</a>"); // target='_top'
}
// ...
if (linkSB_L.length() > 0) {
out.print(linkSB_L.toString());
} else {
out.print(" ");
}
out.print("</td>\n");
// Report subtitle
out.print("<td width='100%'>");
String rptSubtt = rd.getReportSubtitle();
if (!StringTools.isBlank(rptSubtt)) {
out.print("<H2 class=\"rptSubtitle\">" + FilterText(rptSubtt) + "</H2>");
} else {
out.print(" ");
}
out.print("</td>\n");
// "Graph", "Map" links
out.print("<td>");
StringBuffer linkSB_R = new StringBuffer();
String graphURL =
(!isEMail && (ndx < 0) && rd.getSupportsGraphDisplay())
? EncodeURL(reqState, rd.getGraphURL())
: null;
if (!StringTools.isBlank(graphURL)) {
MapDimension sz = rd.getGraphWindowSize();
String desc = rd.getGraphLinkDescription();
if (StringTools.isBlank(desc)) {
desc = i18n.getString("ReportTable.displayGraph", "Graph");
}
if (linkSB_R.length() > 0) {
linkSB_R.append(" ");
} // add space between links
linkSB_R.append(
"<span class='spanLink' onclick=\"javascript:openResizableWindow('"
+ graphURL
+ "','ReportGraph',"
+ sz.getWidth()
+ ","
+ sz.getHeight()
+ ");\">"
+ desc
+ "</span>");
}
String mapURL =
(!isEMail && (ndx < 0) && rd.getSupportsMapDisplay())
? EncodeURL(reqState, rd.getMapURL())
: null;
if (!StringTools.isBlank(mapURL)) {
MapDimension sz = rd.getMapWindowSize();
String desc = rd.getMapLinkDescription();
if (StringTools.isBlank(desc)) {
desc = i18n.getString("ReportTable.displayMap", "Map");
}
if (linkSB_R.length() > 0) {
linkSB_R.append(" ");
} // add space between links
linkSB_R.append(
"<span class='spanLink' onclick=\"javascript:openResizableWindow('"
+ mapURL
+ "','ReportMap',"
+ sz.getWidth()
+ ","
+ sz.getHeight()
+ ");\">"
+ desc
+ "</span>");
}
String kmlURL =
(!isEMail
&& (ndx < 0)
&& rd.getSupportsKmlDisplay()
&& privLabel.getBooleanProperty(
PrivateLabel.PROP_ReportDisplay_showGoogleKML, false))
? EncodeURL(reqState, rd.getKmlURL())
: null;
if (!StringTools.isBlank(kmlURL)) {
String desc = rd.getKmlLinkDescription();
if (StringTools.isBlank(desc)) {
desc = i18n.getString("ReportTable.displayKML", "KML");
}
if (linkSB_R.length() > 0) {
linkSB_R.append(" ");
} // add space between links
linkSB_R.append("<a href='" + kmlURL + "' target='_blank'>" + desc + "</a>");
}
// ...
if (linkSB_R.length() > 0) {
out.print(linkSB_R.toString());
} else {
out.print(" ");
}
out.print("</td>\n");
out.print("</tr>\n");
}
/* start report */
out.print("<tr>\n");
out.print("<td colSpan='3'>\n");
String tableClass =
rd.getReportFactory().isTableSortable() ? CSS_CLASS_TABLE_SORT : CSS_CLASS_TABLE;
out.print(
"<table class='"
+ tableClass
+ "' width='100%' cellspacing='0' cellpadding='0' border='0'>\n");
out.print("<!-- Report Header -->\n");
this.rptHeader.writeHTML(out, level + 1, rd);
out.print("<!-- Report Data -->\n");
this.rptBody.writeHTML(out, level + 1, rd);
out.print("</table>\n");
out.print("</td>\n");
out.print("</tr>\n");
/* no/partial data indication */
if (this.rptBody.getRecordCount() <= 0) {
out.print("<tr>\n");
out.print("<td colSpan='3'><H2 class=\"rptNoData\">");
String t = i18n.getString("ReportTable.noData", "This report contains no data");
out.print(FilterText(t));
out.print("</H2></td>\n");
out.print("</tr>\n");
} else if (this.rptBody.isPartial()) {
out.print("<tr>\n");
out.print("<td colSpan='3'><H2 class=\"rptPartial\">");
String t =
i18n.getString(
"ReportTable.partialData",
"This report has reached it's record display limit and may only contain a portion of the possible data");
out.print(FilterText(t));
out.print("</H2></td>\n");
out.print("</tr>\n");
}
out.print("</table>\n");
out.print("</center>\n");
return this.rptBody.getRecordCount();
}
/* write mapping support JS to stream */
protected void writeJSVariables(PrintWriter out, RequestProperties reqState) throws IOException {
// This var initilizations must not use any functions defined in 'jsmap.js'
PrivateLabel privLabel = reqState.getPrivateLabel();
I18N i18n = privLabel.getI18N(JSMap.class);
Locale locale = reqState.getLocale();
GeoPoint dftCenter = this.getDefaultCenter(null);
boolean isFleet = reqState.isFleet();
Account account = reqState.getCurrentAccount();
long maxPushpins = this.getMaxPushpins(reqState);
out.write("// --- Map support Javascript [" + this.getName() + "]\n");
JavaScriptTools.writeJSVar(out, "MAP_PROVIDER_NAME", this.getName());
/* properties */
boolean wrotePropHeader = false;
RTProperties rtp = this.getProperties();
for (Iterator<?> i = rtp.keyIterator(); i.hasNext(); ) {
Object key = i.next();
if (!this._skipPropKey(key)) {
if (!wrotePropHeader) {
// out.write("\n");
out.write("// Defined properties\n");
wrotePropHeader = true;
}
String val[] = StringTools.parseStringArray(rtp.getProperty(key, "").toString(), '\n');
String propVar = "PROP_" + key.toString().replace('.', '_').replace('-', '_');
if (val.length == 1) {
if (StringTools.isDouble(val[0], true)
|| StringTools.isLong(val[0], true)
|| StringTools.isBoolean(val[0], true)) {
JavaScriptTools.writeJSVar(out, propVar, val[0], false);
} else {
JavaScriptTools.writeJSVar(out, propVar, val[0]);
}
} else if (val.length > 1) {
JavaScriptTools.writeJSVar(out, propVar, StringTools.join(val, "\\n"));
}
}
}
/* speed units */
Account.SpeedUnits speedUnits = reqState.getSpeedUnits();
boolean speedIsKph = speedUnits.equals(Account.SpeedUnits.KPH);
double altUnitsMult = speedIsKph ? 1.0 : GeoPoint.FEET_PER_METER;
String altUnitsName =
speedIsKph
? i18n.getString("JSMap.altitude.meters", "Meters")
: i18n.getString("JSMap.altitude.feet", "Feet");
/* constants (these do not change during the user session) */
out.write("// Element IDs\n");
JavaScriptTools.writeJSVar(out, "MAP_ID", this.getMapID());
JavaScriptTools.writeJSVar(out, "ID_DETAIL_TABLE", ID_DETAIL_TABLE);
JavaScriptTools.writeJSVar(out, "ID_DETAIL_CONTROL", ID_DETAIL_CONTROL);
JavaScriptTools.writeJSVar(out, "ID_LAT_LON_DISPLAY", ID_LAT_LON_DISPLAY);
JavaScriptTools.writeJSVar(out, "ID_DISTANCE_DISPLAY", ID_DISTANCE_DISPLAY);
JavaScriptTools.writeJSVar(out, "ID_LATEST_EVENT_DATE", ID_LATEST_EVENT_DATE);
JavaScriptTools.writeJSVar(out, "ID_LATEST_EVENT_TIME", ID_LATEST_EVENT_TIME);
JavaScriptTools.writeJSVar(out, "ID_LATEST_EVENT_TMZ", ID_LATEST_EVENT_TMZ);
JavaScriptTools.writeJSVar(out, "ID_LATEST_BATTERY", ID_LATEST_BATTERY);
JavaScriptTools.writeJSVar(out, "ID_MESSAGE_TEXT", ID_MESSAGE_TEXT);
out.write("// Geozone IDs\n");
JavaScriptTools.writeJSVar(out, "ID_ZONE_LATITUDE_", ID_ZONE_LATITUDE_);
JavaScriptTools.writeJSVar(out, "ID_ZONE_LONGITUDE_", ID_ZONE_LONGITUDE_);
JavaScriptTools.writeJSVar(out, "ID_ZONE_RADIUS_M", ID_ZONE_RADIUS_M);
out.write("// Session constants\n");
JavaScriptTools.writeJSVar(out, "PUSHPINS_SHOW", rtp.getBoolean(PROP_map_pushpins, true));
JavaScriptTools.writeJSVar(out, "MAX_PUSH_PINS", maxPushpins);
JavaScriptTools.writeJSVar(out, "MAX_CREATION_AGE_SEC", rtp.getInt(PROP_map_maxCreationAge, 0));
JavaScriptTools.writeJSVar(out, "MAP_WIDTH", this.getDimension().getWidth());
JavaScriptTools.writeJSVar(out, "MAP_HEIGHT", this.getDimension().getHeight());
JavaScriptTools.writeJSVar(out, "IS_FLEET", isFleet);
JavaScriptTools.writeJSVar(
out, "SHOW_SAT_COUNT", rtp.getBoolean(PROP_detail_showSatCount, false));
JavaScriptTools.writeJSVar(out, "SHOW_SPEED", rtp.getBoolean(PROP_info_showSpeed, true));
JavaScriptTools.writeJSVar(
out, "COMBINE_SPEED_HEAD", rtp.getBoolean(PROP_combineSpeedHeading, true));
JavaScriptTools.writeJSVar(out, "SHOW_ALTITUDE", rtp.getBoolean(PROP_info_showAltitude, false));
JavaScriptTools.writeJSVar(out, "SHOW_ADDR", reqState.getShowAddress());
JavaScriptTools.writeJSVar(
out, "INCL_BLANK_ADDR", rtp.getBoolean(PROP_info_inclBlankAddress, true));
JavaScriptTools.writeJSVar(
out, "SHOW_OPT_FIELDS", rtp.getBoolean(PROP_info_showOptionalFields, true));
JavaScriptTools.writeJSVar(
out, "INCL_BLANK_OPT_FIELDS", rtp.getBoolean(PROP_info_inclBlankOptFields, true));
JavaScriptTools.writeJSVar(
out, "LATLON_FORMAT", Account.getLatLonFormat(account).getIntValue());
JavaScriptTools.writeJSVar(
out, "DISTANCE_KM_MULT", reqState.getDistanceUnits().getMultiplier());
JavaScriptTools.writeJSVar(out, "SPEED_KPH_MULT", speedUnits.getMultiplier());
JavaScriptTools.writeJSVar(out, "SPEED_UNITS", speedUnits.toString(locale));
JavaScriptTools.writeJSVar(out, "ALTITUDE_METERS_MULT", altUnitsMult);
JavaScriptTools.writeJSVar(out, "ALTITUDE_UNITS", altUnitsName);
JavaScriptTools.writeJSVar(out, "TIME_ZONE", reqState.getTimeZoneString(null)); // long
JavaScriptTools.writeJSVar(
out,
"DEFAULT_CENTER",
"{ lat:" + dftCenter.getLatitude() + ", lon:" + dftCenter.getLongitude() + " }",
false);
JavaScriptTools.writeJSVar(out, "DEFAULT_ZOOM", this.getDefaultZoom(JSMap.DEFAULT_ZOOM, false));
JavaScriptTools.writeJSVar(out, "PUSHPIN_ZOOM", this.getDefaultZoom(JSMap.PUSHPIN_ZOOM, true));
JavaScriptTools.writeJSVar(out, "MAP_AUTHORIZATION", this.getAuthorization());
JavaScriptTools.writeJSVar(
out, "SCROLL_WHEEL_ZOOM", rtp.getBoolean(PROP_scrollWheelZoom, false));
JavaScriptTools.writeJSVar(out, "DEFAULT_VIEW", rtp.getString(PROP_map_view, "").toLowerCase());
JavaScriptTools.writeJSVar(out, "ROUTE_LINE_SHOW", rtp.getBoolean(PROP_map_routeLine, true));
JavaScriptTools.writeJSVar(
out, "ROUTE_LINE_COLOR", rtp.getString(PROP_map_routeLine_color, "#FF2222"));
JavaScriptTools.writeJSVar(
out, "ROUTE_LINE_ARROWS", rtp.getBoolean(PROP_map_routeLine_arrows, false));
JavaScriptTools.writeJSVar(
out,
"ROUTE_SNAP_TO_ROAD",
rtp.getBoolean(PROP_map_routeLine_snapToRoad, false)); // Google V2 only
JavaScriptTools.writeJSVar(out, "REPLAY_INTERVAL", this.getReplayInterval());
JavaScriptTools.writeJSVar(out, "REPLAY_SINGLE", this.getReplaySinglePushpin());
/* address title */
String adrTitles[] = reqState.getAddressTitles();
String adrTitle = ListTools.itemAt(adrTitles, 0, null);
/* device title */
String devTitles[] = reqState.getDeviceTitles();
String devTitle = ListTools.itemAt(devTitles, 0, null);
/* labels */
out.write("// Localized Text/Labels\n");
JavaScriptTools.writeJSVar(
out,
"HEADING",
"new Array("
+ "\""
+ GeoPoint.CompassHeading.N.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.NE.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.E.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.SE.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.S.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.SW.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.W.toString(locale)
+ "\","
+ "\""
+ GeoPoint.CompassHeading.NW.toString(locale)
+ "\")",
false);
JavaScriptTools.writeJSVar(out, "TEXT_INFO_DATE", i18n.getString("JSMap.info.date", "Date"));
JavaScriptTools.writeJSVar(out, "TEXT_INFO_GPS", i18n.getString("JSMap.info.gps", "GPS"));
JavaScriptTools.writeJSVar(out, "TEXT_INFO_SATS", i18n.getString("JSMap.info.sats", "#Sats"));
JavaScriptTools.writeJSVar(out, "TEXT_INFO_SPEED", i18n.getString("JSMap.info.speed", "Speed"));
JavaScriptTools.writeJSVar(out, "TEXT_INFO_HEADING", GeoPoint.GetHeadingTitle(locale));
JavaScriptTools.writeJSVar(
out, "TEXT_INFO_ALTITUDE", i18n.getString("JSMap.info.altitude", "Altitude"));
JavaScriptTools.writeJSVar(
out, "TEXT_INFO_STOP_TIME", i18n.getString("JSMap.info.stopTime", "Stop Time"));
JavaScriptTools.writeJSVar(
out,
"TEXT_INFO_ADDR",
!StringTools.isBlank(adrTitle)
? adrTitle
: i18n.getString("JSMap.info.address", "Address"));
JavaScriptTools.writeJSVar(
out,
"TEXT_DEVICE",
!StringTools.isBlank(devTitle) ? devTitle : i18n.getString("JSMap.device", "Device"));
JavaScriptTools.writeJSVar(out, "TEXT_DATE", i18n.getString("JSMap.dateTime", "Date/Time"));
JavaScriptTools.writeJSVar(out, "TEXT_CODE", i18n.getString("JSMap.code", "Status"));
JavaScriptTools.writeJSVar(out, "TEXT_LATLON", i18n.getString("JSMap.latLon", "Lat/Lon"));
JavaScriptTools.writeJSVar(out, "TEXT_SATCOUNT", i18n.getString("JSMap.satCount", "#Sats"));
JavaScriptTools.writeJSVar(
out,
"TEXT_ADDR",
!StringTools.isBlank(adrTitle) ? adrTitle : i18n.getString("JSMap.address", "Address"));
JavaScriptTools.writeJSVar(out, "TEXT_SPEED", reqState.getSpeedUnits().toString(locale));
JavaScriptTools.writeJSVar(out, "TEXT_HEADING", i18n.getString("JSMap.heading", "Heading"));
JavaScriptTools.writeJSVar(out, "TEXT_DISTANCE", reqState.getDistanceUnits().toString(locale));
JavaScriptTools.writeJSVar(
out,
"TEXT_TIMEOUT",
i18n.getString("JSMap.sessionTimeout", "Your session has timed-out.\nPlease login ..."));
JavaScriptTools.writeJSVar(
out,
"TEXT_PING_OK",
i18n.getString(
"JSMap.pingDevice.ok",
"A command request has been sent.\nThe {0} should respond shortly ...",
devTitles));
JavaScriptTools.writeJSVar(
out,
"TEXT_PING_ERROR",
i18n.getString(
"JSMap.pingDevice.err",
"The command request failed.\nThe {0} may not support this feature ...",
devTitles));
JavaScriptTools.writeJSVar(
out,
"TEXT_MAXPUSHPINS_ALERT",
i18n.getString(
"JSMap.maxPushpins.err",
"The maximum number of allowed pushpins has been exceeded.\n"
+ " [max={0}] Not all pushpins may be displayed on this map.\n"
+ "Adjust the 'From' time to see remaining pushpins",
String.valueOf(maxPushpins)));
JavaScriptTools.writeJSVar(
out,
"TEXT_MAXPUSHPINS_MSG",
i18n.getString(
"JSMap.maxPushpins.msg",
"Only partial data displayed. The maximum allowed pushpins has been reached.<BR>"
+ "Adjust the Date/Time range accordingly to view the remaining pushpins."));
JavaScriptTools.writeJSVar(
out, "TEXT_UNAVAILABLE", i18n.getString("JSMap.unavailable", "unavailable"));
JavaScriptTools.writeJSVar(
out,
"TEXT_showLocationDetails",
i18n.getString("JSMap.showLocationDetails", "Show Location Details"));
JavaScriptTools.writeJSVar(
out,
"TEXT_hideLocationDetails",
i18n.getString("JSMap.hideLocationDetails", "Hide Location Details"));
/* map "Loading ..." */
JavaScriptTools.writeJSVar(
out,
"TEXT_LOADING_MAP_POINTS",
(rtp.getBoolean(PROP_MAP_LOADING, false)
? i18n.getString("JSMap.loadingMapPoints", "Loading Map Points ...")
: null));
JavaScriptTools.writeJSVar(
out, "MAP_LOADING_IMAGE_URI", rtp.getString(PROP_MAP_LOADING_IMAGE, null));
/* icons/shadows */
JSMap.writePushpinArray(out, reqState);
/* constants (these do not change during the user session) */
out.write("// Geozone support constants\n");
JavaScriptTools.writeJSVar(out, "jsvGeozoneMode", false);
JavaScriptTools.writeJSVar(out, "MAX_ZONE_RADIUS_M", Geozone.MAX_RADIUS_METERS);
JavaScriptTools.writeJSVar(out, "MIN_ZONE_RADIUS_M", Geozone.MIN_RADIUS_METERS);
JavaScriptTools.writeJSVar(
out, "DETAIL_REPORT", this.isFeatureSupported(FEATURE_DETAIL_REPORT));
JavaScriptTools.writeJSVar(
out, "DETAIL_INFO_BOX", this.isFeatureSupported(FEATURE_DETAIL_INFO_BOX));
JavaScriptTools.writeJSVar(out, "TEXT_METERS", GeoPoint.DistanceUnits.METERS.toString(locale));
/* variables */
out.write("// TrackMap Vars\n");
JavaScriptTools.writeJSVar(out, "jsvPoiPins", null);
JavaScriptTools.writeJSVar(out, "jsvDataSets", null);
JavaScriptTools.writeJSVar(out, "jsvDetailPoints", null);
JavaScriptTools.writeJSVar(out, "jsvDetailVisible", false);
JavaScriptTools.writeJSVar(
out,
"jsvDetailAscending",
privLabel.getBooleanProperty(PrivateLabel.PROP_TrackMap_detailAscending, true));
JavaScriptTools.writeJSVar(
out,
"jsvDetailCenterPushpin",
privLabel.getBooleanProperty(PrivateLabel.PROP_TrackMap_detailCenterPushpin, false));
/* last update time */
TimeZone tmz = reqState.getTimeZone();
String dateFmt =
(account != null) ? account.getDateFormat() : BasicPrivateLabel.getDefaultDateFormat();
String timeFmt =
(account != null) ? account.getTimeFormat() : BasicPrivateLabel.getDefaultTimeFormat();
DateTime today = new DateTime(tmz);
JavaScriptTools.writeJSVar(out, "jsvTodayEpoch", today.getTimeSec());
JavaScriptTools.writeJSVar(
out,
"jsvTodayYMD",
"{ YYYY:"
+ today.getYear(tmz)
+ ", MM:"
+ today.getMonth1(tmz)
+ ", DD:"
+ today.getDayOfMonth(tmz)
+ " }",
false);
JavaScriptTools.writeJSVar(out, "jsvTodayDateFmt", today.format(dateFmt, tmz));
JavaScriptTools.writeJSVar(out, "jsvTodayTimeFmt", today.format(timeFmt, tmz));
JavaScriptTools.writeJSVar(out, "jsvTodayTmzFmt", today.format("z", tmz));
/* last event time */
out.write("// Last event time\n");
DateTime lastEventTime = reqState.getLastEventTime();
if (lastEventTime != null) {
JavaScriptTools.writeJSVar(out, "jsvLastEventEpoch", lastEventTime.getTimeSec());
JavaScriptTools.writeJSVar(
out,
"jsvLastEventYMD",
"{ YYYY:"
+ lastEventTime.getYear(tmz)
+ ", MM:"
+ lastEventTime.getMonth1(tmz)
+ ", DD:"
+ lastEventTime.getDayOfMonth(tmz)
+ " }",
false);
JavaScriptTools.writeJSVar(out, "jsvLastEventDateFmt", lastEventTime.format(dateFmt, tmz));
JavaScriptTools.writeJSVar(out, "jsvLastEventTimeFmt", lastEventTime.format(timeFmt, tmz));
JavaScriptTools.writeJSVar(out, "jsvLastEventTmzFmt", lastEventTime.format("z", tmz));
JavaScriptTools.writeJSVar(out, "jsvLastBatteryLevel", 0L);
JavaScriptTools.writeJSVar(out, "jsvLastSignalStrength", 0L);
} else {
JavaScriptTools.writeJSVar(out, "jsvLastEventEpoch", 0L);
JavaScriptTools.writeJSVar(out, "jsvLastEventYMD", null);
JavaScriptTools.writeJSVar(out, "jsvLastEventDateFmt", null);
JavaScriptTools.writeJSVar(out, "jsvLastEventTimeFmt", null);
JavaScriptTools.writeJSVar(out, "jsvLastEventTmzFmt", null);
JavaScriptTools.writeJSVar(out, "jsvLastBatteryLevel", 0.0);
JavaScriptTools.writeJSVar(out, "jsvLastSignalStrength", 0.0);
}
/* map pointers */
out.write("// Map vars\n");
JavaScriptTools.writeJSVar(out, "jsmapElem", null);
JavaScriptTools.writeJSVar(out, "jsmap", null);
}
/* encode GeoPoint into nearest address URI */
protected String getAddressReverseGeocodeURL(GeoPoint gp, String localStr) {
StringBuffer sb = new StringBuffer();
GoogleSig sig = this.getSignature();
/* predefined URL */
String rgURL = this.getProperties().getString(PROP_reverseGeocodeURL, null);
if (!StringTools.isBlank(rgURL)) {
sb.append(rgURL);
sb.append("&ll=")
.append(gp.getLatitudeString(GeoPoint.SFORMAT_DEC_5, null))
.append(",")
.append(gp.getLongitudeString(GeoPoint.SFORMAT_DEC_5, null));
String defURL = sb.toString();
if (sig == null) {
return defURL;
} else {
String urlStr = sig.signURL(defURL);
return (urlStr != null) ? urlStr : defURL;
}
}
/* assemble URL */
sb.append(this.getAddressReverseGeocodeURI());
sb.append("output=xml");
sb.append("&oe=utf8");
/* latitude/longitude */
sb.append("&ll=")
.append(gp.getLatitudeString(GeoPoint.SFORMAT_DEC_5, null))
.append(",")
.append(gp.getLongitudeString(GeoPoint.SFORMAT_DEC_5, null));
/* sensor */
String sensor = this.getProperties().getString(PROP_sensor, null);
if (!StringTools.isBlank(sensor)) {
sb.append("&sensor=").append(sensor);
}
/* key */
String channel = this.getProperties().getString(PROP_channel, null);
String auth = this.getAuthorization();
if (StringTools.isBlank(auth) || auth.startsWith("*")) {
// invalid key
} else if (auth.startsWith(CLIENT_ID_PREFIX)) {
sb.append("&client=").append(auth);
if (StringTools.isBlank(channel)) {
channel = DBConfig.getServiceAccountID(null);
}
} else {
sb.append("&key=").append(auth);
}
/* channel */
if (!StringTools.isBlank(channel)) {
sb.append("&channel=").append(channel);
}
/* localization ("&hl=") */
if (!StringTools.isBlank(localStr)) {
sb.append("&hl=").append(localStr);
}
/* return url */
String defURL = sb.toString();
if (sig == null) {
return defURL;
} else {
String urlStr = sig.signURL(defURL);
return (urlStr != null) ? urlStr : defURL;
}
}
/* return reverse-geocode using nearest address */
public ReverseGeocode getAddressReverseGeocode(GeoPoint gp, String localeStr, boolean cache) {
/* check for failover mode */
if (this.isReverseGeocodeFailoverMode()) {
ReverseGeocodeProvider frgp = this.getFailoverReverseGeocodeProvider();
return frgp.getReverseGeocode(gp, localeStr, cache);
}
/* URL */
String url = this.getAddressReverseGeocodeURL(gp, localeStr);
Print.logDebug("Google RG URL: " + url);
// byte xmlBytes[] = HTMLTools.readPage(url);
/* create XML document */
Document xmlDoc = GetXMLDocument(url, this.getReverseGeocodeTimeout());
if (xmlDoc == null) {
return null;
}
/* vars */
String errCode = null;
String address = null;
/* parse "xml" */
Element kml = xmlDoc.getDocumentElement();
if (kml.getTagName().equalsIgnoreCase(TAG_kml)) {
NodeList ResponseList = XMLTools.getChildElements(kml, TAG_Response);
for (int g = 0; (g < ResponseList.getLength()); g++) {
Element response = (Element) ResponseList.item(g);
NodeList responseNodes = response.getChildNodes();
for (int n = 0; n < responseNodes.getLength(); n++) {
Node responseNode = responseNodes.item(n);
if (!(responseNode instanceof Element)) {
continue;
}
Element responseElem = (Element) responseNode;
String responseNodeName = responseElem.getNodeName();
if (responseNodeName.equalsIgnoreCase(TAG_name)) {
// <name>40.479581,-117.773438</name>
} else if (responseNodeName.equalsIgnoreCase(TAG_Status)) {
// <Status> ... </Status>
NodeList statusNodes = responseElem.getChildNodes();
for (int st = 0; st < statusNodes.getLength(); st++) {
Node statusNode = statusNodes.item(st);
if (!(statusNode instanceof Element)) {
continue;
}
Element statusElem = (Element) statusNode;
String statusNodeName = statusElem.getNodeName();
if (statusNodeName.equalsIgnoreCase(TAG_code)) {
errCode = StringTools.trim(GoogleGeocodeV2.GetNodeText(statusElem)); // expect "200"
break; // we only care about the 'code'
}
}
} else if (responseNodeName.equalsIgnoreCase(TAG_Placemark)) {
// <Placemark> ... </Placemark>
String id = responseElem.getAttribute(ATTR_id);
if ((id != null) && id.equals("p1")) {
NodeList placemarkNodes = responseElem.getChildNodes();
for (int pm = 0; pm < placemarkNodes.getLength(); pm++) {
Node placemarkNode = placemarkNodes.item(pm);
if (!(placemarkNode instanceof Element)) {
continue;
}
Element placemarkElem = (Element) placemarkNode;
String placemarkNodeName = placemarkElem.getNodeName();
if (placemarkNodeName.equalsIgnoreCase(TAG_address)) {
address = GoogleGeocodeV2.GetNodeText(placemarkElem);
break; // we only care about the 'address'
}
}
} else {
// Print.logInfo("Skipping Placemark ID = %s", id);
}
}
}
}
}
/* create address */
if (FAILOVER_DEBUG) {
errCode = "620";
} else if (!StringTools.isBlank(address)) {
// address found
ReverseGeocode rg = new ReverseGeocode();
rg.setFullAddress(address);
return rg;
}
/* check for Google reverse-geocode limit exceeded */
if ((errCode != null) && errCode.equals("620")) {
Print.logError("!!!! Google Reverse-Geocode Limit Exceeded [Error 620] !!!!");
if (this.hasFailoverReverseGeocodeProvider()) {
this.startReverseGeocodeFailoverMode();
ReverseGeocodeProvider frgp = this.getFailoverReverseGeocodeProvider();
Print.logWarn("Failing over to '" + frgp.getName() + "'");
return frgp.getReverseGeocode(gp, localeStr, cache);
}
}
/* no reverse-geocode available */
return null;
}
/* encode GeoPoint into nearest address URI */
protected String getGeoPointGeocodeURL(String address, String country) {
StringBuffer sb = new StringBuffer();
GoogleSig sig = this.getSignature();
/* country */
if (StringTools.isBlank(country)) {
country = this.getProperties().getString(PROP_countryCodeBias, DEFAULT_COUNTRY);
}
/* predefined URL */
String gcURL = this.getProperties().getString(PROP_geocodeURL, null);
if (!StringTools.isBlank(gcURL)) {
sb.append(gcURL);
sb.append("&q=").append(URIArg.encodeArg(address));
if (!StringTools.isBlank(country)) {
// country code bias: http://en.wikipedia.org/wiki/CcTLD
sb.append("&gl=").append(country);
}
return sb.toString();
}
/* assemble URL */
sb.append(this.getGeoPointGeocodeURI());
sb.append("output=xml");
sb.append("&oe=utf8");
/* address/country */
sb.append("&q=").append(URIArg.encodeArg(address));
if (!StringTools.isBlank(country)) {
sb.append("&gl=").append(country);
}
/* sensor */
String sensor = this.getProperties().getString(PROP_sensor, null);
if (!StringTools.isBlank(sensor)) {
sb.append("&sensor=").append(sensor);
}
/* channel */
String channel = this.getProperties().getString(PROP_channel, null);
if (!StringTools.isBlank(channel)) {
sb.append("&channel=").append(channel);
}
/* key */
String auth = this.getAuthorization();
if (StringTools.isBlank(auth) || auth.startsWith("*")) {
// invalid key
} else if (auth.startsWith(CLIENT_ID_PREFIX)) {
sb.append("&client=").append(auth);
} else {
sb.append("&key=").append(auth);
}
/* return url */
String defURL = sb.toString();
if (sig == null) {
return defURL;
} else {
String urlStr = sig.signURL(defURL);
return (urlStr != null) ? urlStr : defURL;
}
}
