from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.mbo import SqlFormat
from psdi.server import MXServer
print "CLEANUPWORKORDER - START"
#Log for debugging
logger = MXLoggerFactory.getLogger("maximo.script")
logger.debug("ScriptName" + launchPoint)
#PMCHGIAASSESMENT
pmchgiaassesmentSet = mbo.getMboSet("PMCHGIAASSESMENT")
if (not pmchgiaassesmentSet.isEmpty()):
wonum = mbo.getString("WONUM")
mxServer = MXServer.getMXServer()
conKey = mxServer.getSystemUserInfo().getConnectionKey()
con = mxServer.getDBManager().getConnection(conKey)
try:
preparedstmt = con.prepareStatement(
"delete pmchgiaassesment where wonum=?")
preparedstmt.setString(1, wonum)
iresult = preparedstmt.executeUpdate()
if (iresult > 0):
print "Deleted PMCHGIAASSESMENT wonum = " + wonum
con.commit()
con.close()
except Exception, e:
print e
#WOACTIVITY
from psdi.mbo import MboSetRemote
from psdi.mbo import MboRemote
from ute.utils import Security
from psdi.mbo import MboConstants
from java.lang import String
from psdi.workflow import WorkFlowServiceRemote
from psdi.util import MXException
from psdi.util import MXApplicationException
from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from java.rmi import RemoteException
"""Script de validacion de datos en la Etapa 2 (Preparacion de Campo) del WF Preparacion de Tareas
@Autor F286635
@Version 1.0"""
logger = MXLoggerFactory.getLogger("maximo.gemalog")
def titulo_atributo(atributo, objeto):
""" Retorna el titulo del atributo pasado por parametro
Parametros
objeto: objeto en el que se encuentra el atributo
atributo: atributo al cual le queremos identificar el titulo
Retorna
El titulo del atributo
"""
try:
userInfo = mbo.getUserInfo()
maxAtribute = MXServer.getMXServer().getMboSet("maxattribute",
userInfo)
from psdi.util.logging import MXLoggerFactory
try:
commTemplateSet = mbo.getMboSet("$commtemp", "COMMTEMPLATE",
"TEMPLATEID ='NTAFGEVOERD'")
commTemplate = commTemplateSet.getMbo(0)
if commTemplate == None:
print(
"Automationscript NTAFGEVOERD kon communicatietemplate NTAFGEVOERD niet vinden"
)
else:
commTemplate.sendMessage(mbo)
except:
myLogger = MXLoggerFactory.getLogger("maximo.script.autoscript")
myLogger.error(
"Fout opgetreden bij uitvoeren automationscript NTAFGEVOERD")