def getList(self, baseKey):
if baseKey[-1:] != ".":
baseKey = baseKey + "."
valueMap = TreeMap()
metadata = self.metadata.getJsonObject()
for key in [k for k in metadata.keySet() if k.startswith(baseKey)]:
value = metadata.get(key)
## adding test below since UI is moving away from SOLR data storage, please add to detail scripts to prevent a "missing" output.
if value:
field = key[len(baseKey):]
index = field[:field.find(".")]
if index == "":
valueMapIndex = field[:key.rfind(".")]
dataIndex = "value"
else:
valueMapIndex = index
dataIndex = field[field.find(".") + 1:]
#print "%s. '%s'='%s' ('%s','%s')" % (index, key, value, valueMapIndex, dataIndex)
data = valueMap.get(valueMapIndex)
#print "**** ", data
if not data:
data = TreeMap()
valueMap.put(valueMapIndex, data)
if type(value).__name__ != 'unicode' and len(value) == 1:
value = value.get(0)
data.put(dataIndex, value)
return valueMap
def getList(self, baseKey):
if baseKey[-1:] != ".":
baseKey = baseKey + "."
valueMap = TreeMap()
metadata = self.metadata.getJsonObject()
for key in [k for k in metadata.keySet() if k.startswith(baseKey)]:
value = metadata.get(key)
## adding test below since UI is moving away from SOLR data storage, please add to detail scripts to prevent a "missing" output.
if value:
field = key[len(baseKey):]
index = field[:field.find(".")]
if index == "":
valueMapIndex = field[:key.rfind(".")]
dataIndex = "value"
else:
valueMapIndex = index
dataIndex = field[field.find(".")+1:]
#print "%s. '%s'='%s' ('%s','%s')" % (index, key, value, valueMapIndex, dataIndex)
data = valueMap.get(valueMapIndex)
#print "**** ", data
if not data:
data = TreeMap()
valueMap.put(valueMapIndex, data)
if len(value) == 1:
value = value.get(0)
data.put(dataIndex, value)
return valueMap
def withIcospheres(time_window=None):
with open(os.path.join(baseDir, csvFilename), 'r') as csvfile:
reader = csv.reader(csvfile, delimiter=',', quotechar='"')
header = reader.next()
peaks = [RealPoint.wrap(imap(float, peak.split('::'))) for peak in islice(header, 1, None)]
# Template icosahedron
ico = MeshMaker.createIcosahedron(2, radius)
# Share lists of Point3f across all timepoints
icos = [MeshMaker.copyTranslated(ico, peak.getFloatPosition(0), peak.getFloatPosition(1) , peak.getFloatPosition(2)) for peak in peaks]
#
univ = Image3DUniverse(512, 512)
instants = TreeMap()
#
rows = reader if time_window is None else islice(reader, time_window[0], time_window[1])
for row in rows:
# Values mapped to 0-1: Color3f takes 3 values in domain [0, 1].
# So: ensure the value is inside [minimum, maximum] range, then rezero by subtracting minimum, and divide by span (maximum - minimum)
values = ((min(max(float(v), minimum), maximum) - minimum) / span for v in islice(row, 1, None))
meshes = [CustomTriangleMesh(mesh, Color3f(v, v, v), 0)
for v, mesh in izip(values, icos)]
ci = ContentInstant(str(row[0]))
ci.display(CustomMultiMesh(meshes)) # each mesh has its color
ci.setLocked(True)
print row[0]
instants.put(int(row[0]), ci)
print "n instants:", instants.size()
univ.addContent(Content("deltaF/F", instants, False))
univ.show()
univ.updateStartAndEndTime(0, len(instants) -1)
def getList(self, baseKey):
if baseKey[-1:] != ".":
baseKey = baseKey + "."
valueMap = TreeMap()
metadata = self.metadata.getJsonObject()
for key in [k for k in metadata.keySet() if k.startswith(baseKey)]:
value = metadata.get(key)
field = key[len(baseKey):]
index = field[:field.find(".")]
if index == "":
valueMapIndex = field[:key.rfind(".")]
dataIndex = "value"
else:
valueMapIndex = index
dataIndex = field[field.find(".") + 1:]
#print "%s. '%s'='%s' ('%s','%s')" % (index, key, value, valueMapIndex, dataIndex)
data = valueMap.get(valueMapIndex)
#print "**** ", data
if not data:
data = TreeMap()
valueMap.put(valueMapIndex, data)
if len(value) == 1:
value = value.get(0)
data.put(dataIndex, value)
return valueMap
def getList(self, baseKey):
if baseKey[-1:] != ".":
baseKey = baseKey + "."
valueMap = TreeMap()
metadata = self.metadata.getJsonObject()
for key in [k for k in metadata.keySet() if k.startswith(baseKey)]:
value = metadata.get(key)
field = key[len(baseKey):]
index = field[:field.find(".")]
if index == "":
valueMapIndex = field[:key.rfind(".")]
dataIndex = "value"
else:
valueMapIndex = index
dataIndex = field[field.find(".")+1:]
#print "%s. '%s'='%s' ('%s','%s')" % (index, key, value, valueMapIndex, dataIndex)
data = valueMap.get(valueMapIndex)
#print "**** ", data
if not data:
data = TreeMap()
valueMap.put(valueMapIndex, data)
if len(value) == 1:
value = value.get(0)
data.put(dataIndex, value)
return valueMap
def calculateExceedance(values):
retval = TreeMap()
doubles = values.stream().mapToDouble(jdf(lambda v: v)).sorted().toArray()
empiricalDist = EmpiricalDist(EmpiricalDist.InterpType.LINEAR, doubles)
i = 0
while i < len(doubles):
retval.put(empiricalDist.getExceed(i), doubles[i])
i = i + 1
return retval
def handleTreasuryReport(core, owner, target, option): playerCity = core.playerCityService.getPlayerCity(owner) if not playerCity: return menuItems = TreeMap() menuItems.put(Long(1), '@city/city:treasury ' + str(playerCity.getCityTreasury())) window = core.suiService.createListBox(1, '@city/city:treasury_balance_t', '@city/city:treasury_balance_d', menuItems, owner, None, 0) core.suiService.openSUIWindow(window) return
def getAffiliation(self):
map = TreeMap()
authors = self.__workflowMetadata.getList("authors")
list = []
#sort base on the expired date
for author in authors:
map.put("%s %s %s" % (author.get("expiry"), author.get("author"), author.get("orgUnitId")), author)
return map
def getPlanVersions(self):
pdfs = TreeMap()
path = self._getObject().getPath()
allPDFs = glob.glob(path + "/Data*.pdf")
if len(allPDFs) > 2:
prog = re.compile('[a-zA-Z ]+\-(\d*)\.pdf')
for f in allPDFs:
bn = os.path.basename(f)
m = prog.match(bn)
if m:
pdfs.put(self.formatVersion(m.group(1)), bn)
return pdfs
def handleTreasuryReport(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
menuItems = TreeMap()
menuItems.put(Long(1),
'@city/city:treasury ' + str(playerCity.getCityTreasury()))
window = core.suiService.createListBox(1, '@city/city:treasury_balance_t',
'@city/city:treasury_balance_d',
menuItems, owner, None, 0)
core.suiService.openSUIWindow(window)
return
def getPlanVersions(self):
pdfs = TreeMap()
path = self._getObject().getPath()
allPDFs = glob.glob(path+"/Data*.pdf")
if len(allPDFs) > 2:
prog = re.compile('[a-zA-Z ]+\-(\d*)\.pdf')
for f in allPDFs:
bn = os.path.basename(f)
m = prog.match(bn)
if m:
pdfs.put(self.formatVersion(m.group(1)), bn)
return pdfs
def handleStructureReport(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
menuItems = TreeMap()
i = 0
for structureId in playerCity.getPlacedStructures():
structure = core.objectService.getObject(structureId)
if structure and structure.getAttachment('isCivicStructure') is not None and structure.getAttachment('isCivicStructure') == True:
i += 1
menuItems.put(Long(i), structure.getLookAtText() + ' - Condition : ' + str((structure.getMaximumCondition() - structure.getConditionDamage()) / structure.getMaximumCondition() * 100) + '%')
window = core.suiService.createListBox(1, '@city/city:structure_list_t', '@city/city:structure_list_d', menuItems, owner, None, 0)
core.suiService.openSUIWindow(window)
return
def getPlanVersions(self):
pdfs = TreeMap()
payloadList = self._getObject().getPayloadIdList()
allPDFs = ArrayList()
for payload in payloadList:
if String(payload).contains("pdf"):
allPDFs.add(payload)
if len(allPDFs) > 2:
prog = re.compile('[a-zA-Z _]+\-(\d*)\.pdf')
for f in allPDFs:
bn = os.path.basename(f)
m = prog.match(bn)
if m:
pdfs.put(self.formatVersion(m.group(1)), bn)
return pdfs
def getPlanVersions(self):
pdfs = TreeMap()
payloadList = self._getObject().getPayloadIdList()
allPDFs = ArrayList()
for payload in payloadList:
if String(payload).contains("pdf"):
allPDFs.add(payload)
if len(allPDFs) > 2:
prog = re.compile('[a-zA-Z _]+\-(\d*)\.pdf')
for f in allPDFs:
bn = os.path.basename(f)
m = prog.match(bn)
if m:
pdfs.put(self.formatVersion(m.group(1)), bn)
return pdfs
def handleManageMilitia(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
menuItems = TreeMap()
menuItems.put(Long(0), '@city/city:militia_new_t')
for militiaId in playerCity.getMilitiaList():
militia = core.objectService.getObject(militiaId)
if not militia:
militia = core.objectService.getCreatureFromDB(militiaId)
if militia:
menuItems.put(Long(militiaId), militia.getCustomName())
returnList = Vector()
returnList.add('List.lstList:SelectedRow')
window = core.suiService.createListBox(1, '@city/city:militia_t', '@city/city:militia_d', menuItems, owner, None, 0)
window.addHandler(0, '', Trigger.TRIGGER_OK, returnList, handleMilitiaListBox)
core.suiService.openSUIWindow(window)
return
def handleManageMilitia(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
menuItems = TreeMap()
menuItems.put(Long(0), '@city/city:militia_new_t')
for militiaId in playerCity.getMilitiaList():
militia = core.objectService.getObject(militiaId)
if not militia:
militia = core.objectService.getCreatureFromDB(militiaId)
if militia:
menuItems.put(Long(militiaId), militia.getCustomName())
returnList = Vector()
returnList.add('List.lstList:SelectedRow')
window = core.suiService.createListBox(1, '@city/city:militia_t',
'@city/city:militia_d', menuItems,
owner, None, 0)
window.addHandler(0, '', Trigger.TRIGGER_OK, returnList,
handleMilitiaListBox)
core.suiService.openSUIWindow(window)
return
def handleStructureReport(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
menuItems = TreeMap()
i = 0
for structureId in playerCity.getPlacedStructures():
structure = core.objectService.getObject(structureId)
if structure and structure.getAttachment(
'isCivicStructure') is not None and structure.getAttachment(
'isCivicStructure') == True:
i += 1
menuItems.put(
Long(i),
structure.getLookAtText() + ' - Condition : ' + str(
(structure.getMaximumCondition() -
structure.getConditionDamage()) /
structure.getMaximumCondition() * 100) + '%')
window = core.suiService.createListBox(1, '@city/city:structure_list_t',
'@city/city:structure_list_d',
menuItems, owner, None, 0)
core.suiService.openSUIWindow(window)
return
def handleMaintenanceReport(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
timeUntilUpdate = playerCity.getNextCityUpdate(
) - System.currentTimeMillis()
days = math.floor(timeUntilUpdate / 86400 * 1000)
timeUntilUpdate -= days * 86400 * 1000
hours = math.floor(timeUntilUpdate / 3600 * 1000)
timeUntilUpdate -= hours * 3600 * 1000
minutes = math.floor(timeUntilUpdate / 60 * 1000)
timeUntilUpdate -= minutes * 60 * 1000
timeStr = ''
if days > 0:
timeStr += str(days) + ' day'
if days > 1:
timeStr += 's'
if hours > 0 or minutes > 0 or timeUntilUpdate > 0:
timeStr += ', '
if hours > 0:
timeStr += str(hours) + ' hour'
if hours > 1:
timeStr += 's'
if minutes > 0 or timeUntilUpdate > 0:
timeStr += ', '
if minutes > 0:
timeStr += str(minutes) + ' minute'
if minutes > 1:
timeStr += 's'
if timeUntilUpdate > 0:
timeStr += ', '
if timeUntilUpdate > 0:
timeStr += str(timeUntilUpdate) + ' second'
if timeUntilUpdate > 1:
timeStr += 's'
totalMaintenance = 0
menuItems = TreeMap()
menuItems.put(Long(0), 'Next City Update: ' + timeStr)
for structureId in playerCity.getPlacedStructures():
structure = core.objectService.getObject(structureId)
if not structure or not structure.getAttachment('isCivicStructure'):
continue
maintenance = structure.getBMR()
if 'cityhall' in structure.getTemplate() and playerCity.isRegistered():
maintenance += 5000
totalMaintenance += maintenance
menuItems.put(Long(structureId),
structure.getLookAtText() + ' : ' + str(maintenance))
if playerCity.getSpecialisationStfValue() != '':
specMaintenance = playerCity.getSpecializationMaintenance()
totalMaintenance += specMaintenance
menuItems.put(
Long(2),
playerCity.getSpecialisationStfValue() + ' : ' +
str(specMaintenance))
menuItems.put(Long(3), 'Total: ' + str(totalMaintenance))
window = core.suiService.createListBox(1, '@city/city:maint_info_t',
'@city/city:maint_info_d',
menuItems, owner, None, 0)
core.suiService.openSUIWindow(window)
return
def export(fdmAPI, fdmContext):
#************************************************************************************
#Build query to get max custom dims
#************************************************************************************
def getMaxCustomDims(appID):
#return "SELECT COUNT(BALANCE_COLUMN_NAME) FROM AIF_TARGET_APPL_DIMENSIONS WHERE APPLICATION_ID = ? AND BALANCE_COLUMN_NAME IS NOT NULL AND BALANCE_COLUMN_NAME LIKE 'UD%' AND TARGET_DIMENSION_CLASS_NAME <> 'LOOKUP'"
return "SELECT COUNT(BALANCE_COLUMN_NAME) FROM AIF_TARGET_APPL_DIMENSIONS WHERE APPLICATION_ID = " + appID + " AND BALANCE_COLUMN_NAME IS NOT NULL AND BALANCE_COLUMN_NAME LIKE 'UD%' AND TARGET_DIMENSION_CLASS_NAME <> 'LOOKUP'"
def generateFXRatesLoadFile(loadID, strFile, hfmAPI, fdmAPI, fxEntity,
beginAccount, endAccount, averageAccount):
import codecs
import os
colName = ""
DELIM = ";"
objFile = codecs.open(strFile, "a", "UTF-16_LE")
if fxEntity == "IsEmpty":
objFile.write("!Entity = [None]" + os.linesep)
objFile.write("!Value = [None]" + os.linesep)
else:
objFile.write("!Entity = " + fxEntity + os.linesep)
#************************************************************************************
#Get the location's DataValue
#************************************************************************************
rs = fdmAPI.getLocationDetails(
BigDecimal(str(fdmContext["LOCKEY"])))
while (rs.next()):
strDataValue = rs.getString("PARTDATAVALUE")
#If data value is not set default to <entity currency>
if strDataValue == None:
strDataValue = "<entity currency>"
Position = strDataValue.find(DELIM)
if Position > 0:
strDataValue = strDataValue[:Position]
objFile.write("!Value = " + strDataValue + os.linesep)
#************************************************************************************
objFile.write("!ICP = [ICP None]" + os.linesep)
objFile.write("!VIEW = YTD" + os.linesep)
try:
rs = hfmAPI.getActiveTargetDims(False)
while (rs.next()):
colName = rs.getString("TDATASEG_COLUMN")
if colName.startswith("UD"):
if colName != "UD1" and colName != "UD2":
objFile.write("!" + rs.getString("DIMENSION_NAME"))
objFile.write(" = [None]")
objFile.write(os.linesep)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
objFile.close
return False
objFile.write(os.linesep)
objFile.write("!Data" + os.linesep)
try:
fxSQL = "SELECT (SELECT A.CATNAME FROM TPOVCATEGORY A INNER JOIN AIF_BAL_RULE_LOADS B ON A.CATKEY = B.CATKEY WHERE B.LOADID = " + loadID + ") as CATNAME, EPM_YEAR, EPM_PERIOD, FROM_CURRENCY, TO_CURRENCY, RATE_TYPE, CONVERSION_RATE FROM AIF_HS_EXCHANGE_RATES WHERE LOADID = " + loadID + " ORDER BY RATE_TYPE"
rs = fdmAPI.executeQuery(fxSQL, None)
while (rs.next()):
objFile.write(rs.getString("CATNAME") + DELIM)
objFile.write(rs.getString("EPM_YEAR") + DELIM)
objFile.write(rs.getString("EPM_PERIOD") + DELIM)
if rs.getString("RATE_TYPE") == "BEGIN":
objFile.write(beginAccount + DELIM)
elif rs.getString("RATE_TYPE") == "END":
objFile.write(endAccount + DELIM)
elif rs.getString("RATE_TYPE") == "AVERAGE":
objFile.write(averageAccount + DELIM)
objFile.write(rs.getString("FROM_CURRENCY") + DELIM)
objFile.write(rs.getString("TO_CURRENCY") + DELIM)
objFile.write(str(rs.getBigDecimal("CONVERSION_RATE", 38)))
objFile.write(os.linesep)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError(str(fxSQL).encode("utf-8"))
objFile.close
return False
objFile.close
return True
def exportICP(fileName, rs, fdmCustoms):
import codecs
import os
#CONSTANTS
DELIM = ";"
if rs == None:
return False
objFile = codecs.open(strFile, "a", "UTF-16_LE")
objFile.write("!InterCompany Detail" + os.linesep)
objFile.write("!Column_Order = ")
objFile.write("Entity" + DELIM)
objFile.write("Partner" + DELIM)
objFile.write("Account" + DELIM)
objFile.write("C1" + DELIM)
objFile.write("C2" + DELIM)
x = 1
while x <= fdmCustoms:
objFile.write("C" + str((x + 2)) + DELIM)
x += 1
objFile.write("TransID" + DELIM)
objFile.write("SubID" + DELIM)
objFile.write("RefID" + DELIM)
objFile.write("Date" + DELIM)
objFile.write("EntCurrAmt" + DELIM)
objFile.write("TransCurr" + DELIM)
objFile.write("Rate" + DELIM)
objFile.write("Comment1" + DELIM)
objFile.write("TransAmt" + os.linesep)
currentScenario = ""
scenario = ""
currentYear = ""
year = ""
currentPeriod = ""
period = ""
while (rs.next()):
currentScenario = rs.getString("SCENARIO")
if currentScenario != scenario:
objFile.write("!Scenario=" + currentScenario + os.linesep)
currentYear = rs.getString("YEAR")
if currentYear != year:
objFile.write("!Year=" + currentYear + os.linesep)
currentPeriod = rs.getString("PERIOD")
if currentPeriod != period:
objFile.write("!Period=" + currentPeriod + os.linesep)
objFile.write(rs.getString("ENTITY") + DELIM)
objFile.write(rs.getString("ICP") + DELIM)
objFile.write(rs.getString("ACCOUNT") + DELIM)
objFile.write(rs.getString("UD1") + DELIM)
objFile.write(rs.getString("UD2") + DELIM)
x = 1
while x <= fdmCustoms:
objFile.write(rs.getString("UD" + str((x + 2))) + DELIM)
x += 1
#TransID
if rs.getString("ATTR1") != None:
objFile.write(rs.getString("ATTR1") + DELIM)
else:
objFile.write(DELIM)
#SubID
if rs.getString("ATTR2") != None:
objFile.write(rs.getString("ATTR2") + DELIM)
else:
objFile.write(DELIM)
#RefID
if rs.getString("ATTR3") != None:
objFile.write(rs.getString("ATTR3") + DELIM)
else:
objFile.write(DELIM)
#Date
if rs.getString("ATTR4") != None:
objFile.write(rs.getString("ATTR4") + DELIM)
else:
#date is required
objFile.write('12/31/2014;')
#EntCurrAmt
if rs.getString("ATTR5") != None:
objFile.write(rs.getString("ATTR5") + DELIM)
else:
objFile.write(DELIM)
#TransCurr
if rs.getString("ATTR6") != None:
objFile.write(rs.getString("ATTR6") + DELIM)
else:
objFile.write(DELIM)
#Rate
if rs.getString("ATTR7") != None:
objFile.write(rs.getString("ATTR7") + DELIM)
else:
objFile.write(DELIM)
#Comment1
if rs.getString("ATTR11") != None:
objFile.write(rs.getString("ATTR11") + DELIM)
else:
objFile.write(DELIM)
#TransAmt
objFile.write(rs.getString("AMOUNT") + os.linesep)
scenario = currentScenario
year = currentYear
period = currentPeriod
objFile.close()
return True
#************************************************************************************
#End of Utility Methods
#************************************************************************************
#************************************************************************************
#EXPORT ACTION
#************************************************************************************
#************************************************************************************
#Import Required Libraries
#************************************************************************************
import sys
import os
import codecs
import java.math.BigDecimal as BigDecimal
import java.util.ArrayList as ArrayList
import java.util.TreeMap as TreeMap
import com.hyperion.aif.hfm.HfmAdapter as HfmAdapter
import com.hyperion.aif.hfm.ProtectionData as ProtectionData
#************************************************************************************
try: #instantiate adapter
hfmAdapter = HfmAdapter()
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError("Could not instantiate the HfmAdapter.")
return False
userName = unicode(fdmContext["USERNAME"])
locale = unicode(fdmContext["USERLOCALE"])
if locale == "None":
fdmAPI.logDebug("User Locale is not set. Defaulting to: en_US")
locale = "en_US"
else:
fdmAPI.logDebug("User Locale is: " + locale)
#************************************************************************************
#CONSTANTS
#************************************************************************************
PROCESS_EXPORT = "PROCESS_BAL_EXP_HFM"
PROCESS_RATES = "PROCESS_EXCHANGE_RATE_LOAD_HFM"
PROCESS_RUNNING = "RUNNING"
PROCESS_SUCCESS = "SUCCESS"
PROCESS_FAILED = "FAILED"
DELIM = ";"
#************************************************************************************
#************************************************************************************
#generate path for .dat file
#************************************************************************************
strFile = "%s\%s_%s.dat" % (fdmContext["OUTBOXDIR"], fdmContext["APPNAME"],
str(fdmContext["LOADID"]))
strFile = strFile.replace('\\', '/')
strFile = os.path.normpath(strFile)
#************************************************************************************
#************************************************************************************
#Initialize the adapter
#************************************************************************************
try:
hfmAdapter.init(fdmContext["LOADID"])
#Create an entry for the Process Details
fdmAPI.insertIntoProcessDetails(PROCESS_EXPORT, fdmContext["APPNAME"],
PROCESS_RUNNING)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
fdmAPI.insertIntoProcessDetails(PROCESS_EXPORT, fdmContext["APPNAME"],
PROCESS_FAILED)
return False
#************************************************************************************
#Get HFM Cluster
#************************************************************************************
try:
fmCluster = hfmAdapter.getHfmCluster(userName)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fmCluster = "HFMCluster"
#************************************************************************************
#************************************************************************************
#Get the Target System Options
#************************************************************************************
try:
#get adapter options
rs = hfmAdapter.getAdapterOptionsForLoadID()
TargetOptions = TreeMap()
while (rs.next()):
TargetOptions.put(
rs.getString("PARAMETER_NAME").upper(),
rs.getString("PROPERTY_VALUE"))
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
#************************************************************************************
#************************************************************************************
#Check for Global Login ID
#************************************************************************************
globalID = hfmAdapter.getGlobalUserID()
fdmAPI.logDebug("Global User ID: " + str(globalID).encode("utf-8"))
if globalID != "":
userName = globalID
#************************************************************************************
#************************************************************************************
#Connect to HFM
#************************************************************************************
isConnectedForLineItems = False
isConnectedForDataProtection = False
#try:
# isConnected = hfmAdapter.connect(userName, locale, fmCluster, unicode(fdmContext["TARGETAPPNAME"]))
# if isConnected == False:
# fdmAPI.logError("Failed to connect to:%s" % str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
# fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
# hfmAdapter.close()
# return False
# else:
# fdmAPI.logDebug("Connected to: %s" % str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
#except:
# fdmAPI.logError("Failed to connected to: %s" % str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
# hfmAdapter.close()
# return False
#************************************************************************************
#************************************************************************************
#Get Max Custom Dimensions
#************************************************************************************
try:
#Get Max custom dims being loaded to target
strSQL = getMaxCustomDims(str(fdmContext["APPID"]))
rs = fdmAPI.executeQuery(strSQL, None)
while (rs.next()):
fdmCustoms = int(rs.getString(1)) - 2
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError(str(strSQL).encode("utf-8"))
hfmAdapter.close()
return False
#************************************************************************************
#************************************************************************************
#Get the location's DataValue
#************************************************************************************
rs = fdmAPI.getLocationDetails(BigDecimal(str(fdmContext["LOCKEY"])))
while (rs.next()):
strDataValue = rs.getString("PARTDATAVALUE")
#If data value is not set default to <entity currency>
if strDataValue == None:
strDataValue = "<entity currency>"
#************************************************************************************
#************************************************************************************
#Check Journal Loading Options
#************************************************************************************
Position = strDataValue.find(DELIM)
if bool(int(TargetOptions.get("ENABLE_JOURNAL_LOAD"))) == True:
if Position > 0:
blnLoadAsJournals = True
else:
blnLoadAsJournals = False
else:
blnLoadAsJournals = False
if Position > 0:
strDataValue = strDataValue[:Position]
if strDataValue.lower() in ("<entity curr adjs>", "<parent curr adjs>",
"[contribution adjs]", "[parent adjs]"):
if blnLoadAsJournals == False:
#DataValue Requires Journal Loading, Set to false and load as entity currency
blnDataAsJournal = False
strDataValue = "<Entity Currency>"
else:
blnDataAsJournal = True
else:
blnDataAsJournal = False
#************************************************************************************
#Default to True
bolResult = True
datFileCreated = False
loadFXRates = False
#************************************************************************************
#Check for FX Rate Load Option
#************************************************************************************
try:
strSQL = "Select LOAD_EXCHANGE_RATE_FLAG From AIF_BAL_RULE_LOADS WHERE LOADID = %s AND LOAD_EXCHANGE_RATE_FLAG IS NOT NULL" % str(
fdmContext["LOADID"])
rs = fdmAPI.executeQuery(strSQL, None)
while (rs.next()):
loadFXRates = True
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError(str(strSQL).encode("utf-8"))
loadFXRates = False
if loadFXRates == True:
strFXRatesFile = "%s\%s_%s_FXRates.dat" % (fdmContext["OUTBOXDIR"],
fdmContext["APPNAME"],
str(fdmContext["LOADID"]))
strFXRatesFile = strFXRatesFile.replace('\\', '/')
strFXRatesFile = os.path.normpath(strFXRatesFile)
#Get the Global Adapter Options - Only these contain the currency rate account options
beginAccount = "[None]"
endAccount = "[None]"
averageAccount = "[None]"
fxEntity = "IsEmpty"
try:
rs = hfmAdapter.getAdapterOptions()
while (rs.next()):
if rs.getString("LOOKUP_CODE") == "CURR_RATE_ACCT_BEGIN_RATE":
if rs.getString("PROPERTY_VALUE") != None:
beginAccount = rs.getString("PROPERTY_VALUE")
elif rs.getString("LOOKUP_CODE") == "CURR_RATE_ACCT_END_RATE":
if rs.getString("PROPERTY_VALUE") != None:
endAccount = rs.getString("PROPERTY_VALUE")
elif rs.getString("LOOKUP_CODE") == "CURR_RATE_ACCT_AVG_RATE":
if rs.getString("PROPERTY_VALUE") != None:
averageAccount = rs.getString("PROPERTY_VALUE")
elif rs.getString("LOOKUP_CODE") == "CURR_RATE_ENTITY":
if rs.getString("PROPERTY_VALUE") != None:
fxEntity = rs.getString("PROPERTY_VALUE")
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
if (generateFXRatesLoadFile(str(fdmContext["LOADID"]), strFXRatesFile,
hfmAdapter, fdmAPI, fxEntity, beginAccount,
endAccount, averageAccount)) == False:
fdmAPI.insertIntoProcessDetails(PROCESS_RATES,
fdmContext["APPNAME"],
PROCESS_FAILED)
fdmAPI.logDebug("Export Exchange Rates failed.")
else:
fdmAPI.insertIntoProcessDetails(PROCESS_RATES,
fdmContext["APPNAME"],
PROCESS_RUNNING)
#************************************************************************************
#Are we loading data as journal? If so, exit the Export script and enter the Load script
#************************************************************************************
if blnDataAsJournal == True:
#Check the journal numbering switch
blnJournalIDPerEntity = bool(
int(TargetOptions.get("ENABLE_JOURNAL_JVID_ENTITY")))
#Set the journal ID based on the numbering type (Single ID or One Per Entity)
if blnJournalIDPerEntity == True:
try:
#Execute Journal Entry Number Per Entity
bolResult = hfmAdapter.setJournalNumberPerEntity()
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError(str(strSQL).encode("utf-8"))
hfmAdapter.close()
bolResult = False
else:
#Execute the single journal entry number update
try:
#rowsAffected = fdmAPI.executeDML(strSQL,None,True)
rowsAffected = hfmAdapter.setJournalNumberAll()
if rowsAffected > 0:
bolResult = True
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
fdmAPI.logError(str(strSQL).encode("utf-8"))
hfmAdapter.close()
bolResult = False
#Check the result of journal number setting
if bolResult == True:
#Create an empty file stating "Data Loaded as Journal"
objFile = codecs.open(strFile, "w", "UTF-16_LE")
strFile = "%s\%s_%s.jlf" % (fdmContext["OUTBOXDIR"],
fdmContext["APPNAME"],
str(fdmContext["LOADID"]))
strFile = strFile.replace('\\', '/')
objFile.write(
"All data loaded as a Journal. See the Journal Data file (" +
strFile + ") contents.")
objFile.close()
fdmAPI.updateProcessDetails(PROCESS_SUCCESS, PROCESS_EXPORT)
fdmAPI.logDebug(
"Data as Journal detected. Journal File will be created in the HFM_LOAD.py Action Script."
)
else:
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
fdmAPI.logDebug(
"Data as Journal detected, but there was an error updating the Journal number."
)
hfmAdapter.close()
return False
#Data As Journal - No errors: HFM_LOAD.py handles the rest.
hfmAdapter.close()
return True
#************************************************************************************
if hfmAdapter.doesLoadIDLoadICP() == True:
if hfmAdapter.importFormatLoadsIcp() == True:
strFile = "%s\%s_%s.trn" % (fdmContext["OUTBOXDIR"],
fdmContext["APPNAME"],
str(fdmContext["LOADID"]))
strFile = strFile.replace('\\', '/')
strFile = os.path.normpath(strFile)
rsICP = hfmAdapter.getTrialBalanceIcp()
if hfmAdapter.generateUnicodeFile(strFile) != True:
fdmAPI.logError("Failed to generate ICP Load file.")
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
hfmAdapter.close()
return False
else:
if (exportICP(strFile, rsICP, fdmCustoms) == True):
fdmAPI.updateProcessDetails(PROCESS_SUCCESS,
PROCESS_EXPORT)
fdmAPI.logDebug("IC Detail Export was successful. See %s" %
str(strFile).encode("utf-8"))
return True
else:
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
fdmAPI.logDebug("IC Detail Export failed.")
hfmAdapter.close()
return False
#*******************************************************************
#Line Item Detail Processing
#*******************************************************************
loadLineItems = bool(int(TargetOptions.get("LOAD_LINE_ITEM_DETAIL")))
lidLoadType = TargetOptions.get("LID_LOAD_TYPE")
try:
rsActiveDims = hfmAdapter.getActiveTargetDims(True)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
if blnLoadAsJournals == True:
fdmAPI.logDebug("***Export data as data and journals as journals***")
#exclude FDM Journals from DAT file
strSelect = "SELECT "
strFrom = " FROM AIF_HS_BALANCES"
strGroupBy = " GROUP BY SCENARIO, PERIOD, DATAVIEW, ENTITY, "
strWhere = " WHERE LOADID = " + str(fdmContext["LOADID"])
strWhere += " AND (" + fdmAPI.getDBProperties(
)["LENGTH_FUNCTION"] + "(JournalID) = 0 OR JournalID Is Null)"
while (rsActiveDims.next()):
strSelect += rsActiveDims.getString("TDATASEG_COLUMN") + ", "
if rsActiveDims.getString("TDATASEG_COLUMN") <> "ENTITY":
strGroupBy += rsActiveDims.getString("TDATASEG_COLUMN") + ", "
strSelect = strSelect + "YEAR as YEAR, PERIOD as PERIOD, SCENARIO AS SCENARIO, DATAVIEW AS DATAVIEW, DATAVALUE AS VALUE, SUM(AMOUNT) AS AMOUNT, JOURNALID as JOURNALID"
strGroupBy = strGroupBy + "YEAR,PERIOD,SCENARIO,DATAVIEW,DATAVALUE,JOURNALID"
else:
fdmAPI.logDebug("***Export data and Journals as data***")
#include both FDM Journals and standard data values
strSelect = "SELECT "
strFrom = " FROM AIF_HS_BALANCES"
strGroupBy = " GROUP BY SCENARIO, PERIOD, DATAVIEW, "
strWhere = " WHERE LOADID = " + str(fdmContext["LOADID"])
while (rsActiveDims.next()):
strSelect += rsActiveDims.getString("TDATASEG_COLUMN") + ", "
strGroupBy += rsActiveDims.getString("TDATASEG_COLUMN") + ", "
strSelect = strSelect + "YEAR as YEAR, PERIOD as PERIOD, SCENARIO AS SCENARIO, DATAVIEW AS DATAVIEW, DATAVALUE AS VALUE, SUM(AMOUNT) AS AMOUNT, JOURNALID as JOURNALID"
strGroupBy = strGroupBy + "YEAR,PERIOD,SCENARIO,DATAVIEW,DATAVALUE,JOURNALID"
rsExport = fdmAPI.executeQuery(
strSelect + strFrom + strWhere + strGroupBy +
" ORDER BY YEAR, PERIOD, SCENARIO, DATAVIEW, JOURNALID, ACCOUNT", None)
while (rsExport.next()):
if datFileCreated != True:
if hfmAdapter.generateUnicodeFile(strFile) != True:
fdmAPI.logError("Failed to generate data load file.")
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
hfmAdapter.close()
return False
else:
objFile = codecs.open(strFile, "a", "UTF-16_LE")
objFile.write("!Data" + os.linesep)
datFileCreated = True
lidLinesWritten = False
#Category
strLine = rsExport.getString("SCENARIO") + DELIM
#Year
strLine += rsExport.getString("YEAR") + DELIM
#Period
strLine += rsExport.getString("PERIOD") + DELIM
#View
strLine += rsExport.getString("DATAVIEW") + DELIM
#Entity
strLine += rsExport.getString("ENTITY") + DELIM
#DATAVALUE
strLine += strDataValue + DELIM
#ACCOUNT
strLine += rsExport.getString("ACCOUNT") + DELIM
#ICP
strLine += rsExport.getString("ICP") + DELIM
#C1
strLine += rsExport.getString("UD1") + DELIM
#C2
strLine += rsExport.getString("UD2") + DELIM
x = 1
while x <= fdmCustoms:
strLine += rsExport.getString("UD" + str((x + 2))) + DELIM
x += 1
#Line Item Detail
if loadLineItems == True:
#************************************************************************************
#Connect to HFM
#************************************************************************************
if isConnectedForLineItems == False:
try:
isConnectedForLineItems = hfmAdapter.connect(
userName, locale, fmCluster,
unicode(fdmContext["TARGETAPPNAME"]))
if isConnectedForLineItems == False:
fdmAPI.logError(
"Failed to connect to:%s" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
fdmAPI.updateProcessDetails(PROCESS_FAILED,
PROCESS_EXPORT)
hfmAdapter.close()
return False
else:
fdmAPI.logDebug(
"Connected to: %s for line items" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
except:
fdmAPI.logError(
"Failed to connected to: %s" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
hfmAdapter.close()
return False
if hfmAdapter.accountUsesLineItems(
unicode(rsExport.getString("ACCOUNT"))) == True:
if lidLoadType == "1":
#summary line items
objFile.write("!LINE_ITEM_DETAIL" + os.linesep)
#Amount, finish the line with normal length
strLine += '"' + rsExport.getString(
"ACCOUNT"
) + '"' + DELIM + hfmAdapter.setAmountToHFMUserPref(
rsExport.getString("AMOUNT"))
#Write the line
objFile.write(strLine + os.linesep)
objFile.write("!DATA" + os.linesep)
elif lidLoadType == "2":
#DETAIL LINE ITEMS
objFile.write("!LINE_ITEM_DETAIL" + os.linesep)
aCustoms = ArrayList()
x = 1
while x <= (fdmCustoms + 2):
aCustoms.add(rsExport.getString("UD" + str((x))))
x += 1
try:
rsDrill = hfmAdapter.getLineItemDetail(
unicode(rsExport.getString("SCENARIO")),
unicode(rsExport.getString("PERIOD")),
unicode(rsExport.getString("YEAR")),
unicode(rsExport.getString("DATAVIEW")),
unicode(rsExport.getString("ENTITY")),
unicode(rsExport.getString("ACCOUNT")),
unicode(rsExport.getString("ICP")), aCustoms)
while (rsDrill.next()):
#Write the DETAIL line to the file
try:
amt = hfmAdapter.setAmountToHFMUserPref(
rsDrill.getString("AMOUNTX"))
except:
amt = rsDrill.getString("AMOUNTX")
lidLinesWritten = True
objFile.write(
strLine + '"' +
unicode(rsDrill.getString("ACCOUNT")) + '-' +
unicode(rsDrill.getString("ENTITY")) + '-' +
unicode(rsDrill.getString("DESC1")) + '"' +
DELIM + amt + os.linesep)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
if lidLinesWritten == False:
try:
amt = hfmAdapter.setAmountToHFMUserPref(
rsExport.getString("AMOUNT"))
except:
amt = rsExport.getString("AMOUNT")
#finish line with normal length
strLine += ('"' + rsExport.getString("ACCOUNT") + '"' +
DELIM + amt)
objFile.write(strLine + os.linesep)
objFile.write("!DATA" + os.linesep)
else:
try:
strLine += hfmAdapter.setAmountToHFMUserPref(
rsExport.getString("AMOUNT"))
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
strLine += rsExport.getString("AMOUNT")
objFile.write(strLine + os.linesep)
else:
try:
#Check for Zero Suppression
if bool(int(
TargetOptions.get("HFM_ENABLE_MULTI_LOAD_LOADING"))):
strLine += hfmAdapter.setAmountToHFMUserPref(
rsExport.getString("AMOUNT"))
else:
if float(rsExport.getString("AMOUNT")) != 0:
strLine += hfmAdapter.setAmountToHFMUserPref(
rsExport.getString("AMOUNT"))
else:
strLine += ""
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
strLine += rsExport.getString("AMOUNT")
objFile.write(strLine + os.linesep)
rsExport.close()
#----------------------------------------------------------------------------
#Data Protection - Extract Protection Data & Append to DAT file
#----------------------------------------------------------------------------
if bool(int(TargetOptions.get("ENABLE_DATA_PROTECTION"))) == True:
fdmAPI.logDebug("Data Protection is on.")
#************************************************************************************
#Connect to HFM
#************************************************************************************
if isConnectedForDataProtection == False:
try:
isConnectedForDataProtection = hfmAdapter.connect(
userName, locale, fmCluster,
unicode(fdmContext["TARGETAPPNAME"]))
if isConnectedForDataProtection == False:
fdmAPI.logError(
"Failed to connect to:%s" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
hfmAdapter.close()
return False
else:
fdmAPI.logDebug(
"Connected to: %s for data protection" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
except:
fdmAPI.logError(
"Failed to connected to: %s" %
str(fdmContext["TARGETAPPNAME"]).encode("utf-8"))
hfmAdapter.close()
return False
try:
extractedProtectionData = hfmAdapter.extractDataProtection(
fdmContext["OUTBOXDIR"], DELIM,
TargetOptions.get("PROTECTION_OPERATOR"),
TargetOptions.get("PROTECTION_VALUE"), False, False)
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
fdmAPI.logDebug("ppodhiya - Before check")
if extractedProtectionData.size() > 0:
fdmAPI.logDebug("ppodhiya - After check. Size > 0")
objFile.write(os.linesep)
objFile.write(
"'The following data is added to this file as a result of Data Protection"
+ os.linesep)
blnCellText = False
for pData in extractedProtectionData:
if pData.find("!DESCRIPTIONS") != -1:
fdmAPI.logDebug(
"ppodhiya - *************** Found Cell Text Section ***************"
)
fdmAPI.logDebug(
"ppodhiya - Setting blnCellText to True to skip cell text data"
)
blnCellText = True
if blnCellText == False:
objFile.write(pData + os.linesep)
#END FOR
objFile.write(os.linesep)
#END IF - DATA PROTECTION
if datFileCreated == True:
objFile.close()
else:
if hfmAdapter.generateUnicodeFile(strFile) != True:
fdmAPI.logError("Failed to generate data load file.")
fdmAPI.updateProcessDetails(PROCESS_FAILED, PROCESS_EXPORT)
hfmAdapter.close()
return False
else:
objFile = codecs.open(strFile, "a", "UTF-16_LE")
objFile.write("!DATA" + os.linesep)
objFile.close()
try:
hfmAdapter.close()
except:
fdmAPI.logError(str(sys.exc_info()[1]).encode("utf-8"))
hfmAdapter.close()
return False
#Update Export Status
fdmAPI.updateProcessDetails(PROCESS_SUCCESS, PROCESS_EXPORT)
numberOfServersPerCG) / numberOfServersPerCG
if (numberOfCoreGroups > numberOfCGBasedOnServers):
numberOfCoreGroups = numberOfCGBasedOnServers
if (numberOfCoreGroups <= 0):
numberOfCoreGroups = 1
print "Desired number of coregroups: ", numberOfCoreGroups
coregroups = TreeMap()
for i in range(numberOfCoreGroups):
coregroupname = "BridgedCoreGroup" + str(i)
if (i == 0):
coregroupname = "DefaultCoreGroup"
if (proxyCoreGroup == 1 and i == 1):
coregroupname = "BridgedCoreGroupODR"
coregroups.put(coregroupname, CoreGroup(coregroupname))
#
# process all servers
#
servers = TreeMap()
clusters = TreeMap()
coregroupBridges = TreeSet()
print "Retrieving existing coregroups"
coregroupIds = convertToList(AdminConfig.list("CoreGroup"))
for coregroup in coregroupIds:
print "Existing coregroup: " + AdminConfig.showAttribute(coregroup, "name")
cgname = AdminConfig.showAttribute(coregroup, "name")
cg = coregroups.get(cgname)
#if full reconfigure is selected, existing coregroups will be deleted and not be added to the coregroups list
if (fullReconfigure == 0):
def handleMaintenanceReport(core, owner, target, option):
playerCity = core.playerCityService.getPlayerCity(owner)
if not playerCity:
return
timeUntilUpdate = playerCity.getNextCityUpdate() - System.currentTimeMillis()
days = math.floor(timeUntilUpdate / 86400 * 1000)
timeUntilUpdate -= days * 86400 * 1000
hours = math.floor(timeUntilUpdate / 3600 * 1000)
timeUntilUpdate -= hours * 3600 * 1000
minutes = math.floor(timeUntilUpdate / 60 * 1000)
timeUntilUpdate -= minutes * 60 * 1000
timeStr = ''
if days > 0:
timeStr += str(days) + ' day'
if days > 1:
timeStr += 's'
if hours > 0 or minutes > 0 or timeUntilUpdate > 0:
timeStr += ', '
if hours > 0:
timeStr += str(hours) + ' hour'
if hours > 1:
timeStr += 's'
if minutes > 0 or timeUntilUpdate > 0:
timeStr += ', '
if minutes > 0:
timeStr += str(minutes) + ' minute'
if minutes > 1:
timeStr += 's'
if timeUntilUpdate > 0:
timeStr += ', '
if timeUntilUpdate > 0:
timeStr += str(timeUntilUpdate) + ' second'
if timeUntilUpdate > 1:
timeStr += 's'
totalMaintenance = 0
menuItems = TreeMap()
menuItems.put(Long(0), 'Next City Update: ' + timeStr)
for structureId in playerCity.getPlacedStructures():
structure = core.objectService.getObject(structureId)
if not structure or not structure.getAttachment('isCivicStructure'):
continue
maintenance = structure.getBMR()
if 'cityhall' in structure.getTemplate() and playerCity.isRegistered():
maintenance += 5000
totalMaintenance += maintenance
menuItems.put(Long(structureId), structure.getLookAtText() + ' : ' + str(maintenance))
if playerCity.getSpecialisationStfValue() != '':
specMaintenance = playerCity.getSpecializationMaintenance()
totalMaintenance += specMaintenance
menuItems.put(Long(2), playerCity.getSpecialisationStfValue() + ' : ' + str(specMaintenance))
menuItems.put(Long(3), 'Total: ' + str(totalMaintenance))
window = core.suiService.createListBox(1, '@city/city:maint_info_t', '@city/city:maint_info_d', menuItems, owner, None, 0)
core.suiService.openSUIWindow(window)
return