def Insert(self,MenuName,MenuDesc,MenuUrl,MenuPid,MenuIcon,by,ip,RequestedOperation=SYSTEM_PERMISSION_INSERT):
try:
details = {
'MenuName':MenuName,
'MenuDesc':MenuDesc,
'MenuUrl':MenuUrl,
'MenuPid':MenuPid,
'MenuIcon':MenuIcon,
'RequestedOperation':RequestedOperation,
'by':by,
'ip':ip,
}
result = DBMenuInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (1,'SUCESS. Menu has been sucessfully added to database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Delete(self,MenuIDList,by,ip,RequestedOperation=SYSTEM_PERMISSION_DELETE):
MenuIDStr = self.getStringFromList(self.getUniqueIntegersList(MenuIDList)[1])
if MenuIDStr[0] != 1:
return (-1,MenuIDStr[1])
try:
details = {
'MenuIDStr':MenuIDStr[1],
'RequestedOperation':RequestedOperation,
'by':by,
'ip':ip,
}
result = DBGroupMenuDelete(details)
if (result['result'] == 1):
from tx2.Users.BusinessFunctions.GroupFunctions import GroupFnx
# get a list of groups, and delete cache for each
GroupFnxObj = GroupFnx()
GroupList = GroupFnxObj.ListAllGroups()
if GroupList[0] == 1:
for x in GroupList[1]:
deleteCacheKey(self.getKey(x.id))
return (1,'SUCESS. Group Menus has been sucessfully deleted from database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Insert(self,MenuList,GroupID,PermissionList,extrainfo,by,ip,RequestedOperation=SYSTEM_PERMISSION_INSERT):
MenuStr = self.getStringFromList((MenuList))
if MenuStr[0] != 1:
return (-1,MenuStr[1])
PermissionStr = self.getStringFromList((PermissionList))
if PermissionStr[0] != 1:
return (-1,PermissionStr[1])
ExtraInfo = self.getStringFromList((extrainfo))
if ExtraInfo[0] != 1:
return (-1,ExtraInfo[1])
try:
details = {
'MenuStr':MenuStr[1],
'GroupID':GroupID,
'PermissionStr':PermissionStr[1],
'extrainfo':ExtraInfo[1],
'RequestedOperation':RequestedOperation,
'by':by,
'ip':ip,
}
result = DBGroupMenuInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.getKey(GroupID))
return (1,'SUCESS. Group Menus has been sucessfully added to database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def insertCommunicationTemplate(self, CommTypeName, CommTempName, CommTempDesc, CommTempFormat, paramList, by, ip, RequestedOperation=SYSTEM_PERMISSION_INSERT):
CACHE_COMMUNICATION_TYPES = 'CACHE_COMMUNICATION_TEMPLATE'
try:
CommunicationTypeObj = CommunicationTypeFnx()
CommunicationTypeID = CommunicationTypeObj.getCommunicationTypeIDbyName(CommTypeName)
print "here"
CommTempFormat= dumps(CommTempFormat).encode("zip").encode("base64").strip()
paramList= dumps(paramList).encode("zip").encode("base64").strip()
print "her1"
details = {
'CommunicationType':CommunicationTypeID,
'TemplateName': CommTempName,
'TemplateDisc':CommTempDesc,
'TemplateFormat':CommTempFormat,
'paramList':paramList,
'op':RequestedOperation,
'by':by,
'ip':ip,
}
print "till here"
res = DBInsertCommunicationTemplate(details)
deleteCacheKey(CACHE_COMMUNICATION_TYPES)
return res
except:
error_msg = 'Error @ InsertCommunicationTemplate in Business Functions'
self.CommunicationLogger.exception('[%s] == Exception =='%('InsertCommunicationTemplate'))
return (-5,error_msg)
def PostNews(self,
Title,
Content,
tstamp,
by,
ip,
RequestedOperation=SYSTEM_PERMISSION_INSERT,
_AppLabel='Communication',
_Model='messages',
Record=-1,
UsersReg=0):
try:
deleteCacheKey("NEWSCache")
ctid = getContentTypesByAppNameAndModel(_AppLabel, _Model)
if (ctid != -1):
return self.InsertCommunication(Title, Content,
KEY_NEWS_COMMUNICATION_TYPE,
'Default', tstamp, -1, -1, by,
ip)
else:
return -1
except:
error_msg = 'Error @ PostNews in Business Functions'
self.CommunicationLogger.exception('[%s] == Exception ==' %
('PostNews'))
return (-5, error_msg)
def CreateGroup(self,gname,gdesc,gtype,entity,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
eid = entity
if entity == -1:
eid = getSystemEntity()
try:
details = {
'ip':ip,
'by':by,
'RequestedOperation':req_op,
'GroupEntity':eid,
'GroupType':gtype,
'GroupName':gname,
'GroupDescription':gdesc,
}
result = DBGroupInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHE_KEY_ALL_GROUPS)
return (1,'SUCESS. Group has been sucessfully added to database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def CreateGroupType(self,
gname,
gdesc,
by,
ip,
req_op=SYSTEM_PERMISSION_INSERT):
try:
details = {
'ip': ip,
'by': by,
'name': gname,
'desc': gdesc,
'req_op': req_op,
}
result = DBGroupTypeInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (
1,
'SUCESS. GroupType has been sucessfully added to database.'
)
else:
return (-1, decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i, values[i])
self.UserLogger.exception('%s : %s' %
(inspect.getframeinfo(frame)[2], msg))
return (-2, str(ex))
def PostNews(self,Title,Content,tstamp,by,ip,RequestedOperation=SYSTEM_PERMISSION_INSERT,_AppLabel='Communication',_Model='messages',Record=-1,UsersReg=0):
try:
deleteCacheKey("NEWSCache")
ctid = getContentTypesByAppNameAndModel(_AppLabel,_Model)
if(ctid!=-1):
return self.InsertCommunication(Title, Content, KEY_NEWS_COMMUNICATION_TYPE, 'Default',tstamp, -1, -1, by, ip)
else:
return -1
except:
error_msg = 'Error @ PostNews in Business Functions'
self.CommunicationLogger.exception('[%s] == Exception =='%('PostNews'))
return (-5,error_msg)
def Update(self,
MenuId,
MenuName,
MenuDesc,
MenuUrl,
MenuPid,
MenuIcon,
by,
ip,
LogDesc,
RequestedOperation=SYSTEM_PERMISSION_UPDATE):
MenuObj = ''
try:
MenuObj = Menu.objects.get(id=MenuId)
except ObjectDoesNotExist:
return (-1, 'Menu does not exist.')
PreviousState = str(MenuObj)
#TODO store based on comparisons
try:
details = {
'MenuId': MenuId,
'MenuName': MenuName,
'MenuDesc': MenuDesc,
'MenuUrl': MenuUrl,
'MenuPid': MenuPid,
'MenuIcon': MenuIcon,
'RequestedOperation': RequestedOperation,
'LogDesc': LogDesc,
'LogPreviousState': PreviousState,
'by': by,
'ip': ip,
}
result = DBMenuUpdate(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (
1,
'SUCESS. Menu has been sucessfully updated in database.')
else:
return (-1, decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i, values[i])
self.UserLogger.exception('%s : %s' %
(inspect.getframeinfo(frame)[2], msg))
return (-2, str(ex))
def setCommunicationCache(self,commType):
try:
M= GetCommunicationFnx().getCommunicationByType(commType).order_by("Timestamp")
M=M.reverse()
P=Paginator(M,10)
cache_name=commType+"Cache"
print cache_name
deleteCacheKey(cache_name)
setCache(cache_name, P)
except:
error_msg = 'Error @ setCommunicationCache in Business Functions| Error fetching data from database'
self.CommunicationLogger.exception('[%s] == Exception =='%('setCommunicationCache'))
return (-5,error_msg)
#print "done cache"
return 1
def setCommunicationCache(self, commType):
try:
M = GetCommunicationFnx().getCommunicationByType(
commType).order_by("Timestamp")
M = M.reverse()
P = Paginator(M, 10)
cache_name = commType + "Cache"
print cache_name
deleteCacheKey(cache_name)
setCache(cache_name, P)
except:
error_msg = 'Error @ setCommunicationCache in Business Functions| Error fetching data from database'
self.CommunicationLogger.exception('[%s] == Exception ==' %
('setCommunicationCache'))
return (-5, error_msg)
#print "done cache"
return 1
def insertCommunicationTemplate(
self,
CommTypeName,
CommTempName,
CommTempDesc,
CommTempFormat,
paramList,
by,
ip,
RequestedOperation=SYSTEM_PERMISSION_INSERT):
CACHE_COMMUNICATION_TYPES = 'CACHE_COMMUNICATION_TEMPLATE'
try:
CommunicationTypeObj = CommunicationTypeFnx()
CommunicationTypeID = CommunicationTypeObj.getCommunicationTypeIDbyName(
CommTypeName)
print "here"
CommTempFormat = dumps(CommTempFormat).encode("zip").encode(
"base64").strip()
paramList = dumps(paramList).encode("zip").encode("base64").strip()
print "her1"
details = {
'CommunicationType': CommunicationTypeID,
'TemplateName': CommTempName,
'TemplateDisc': CommTempDesc,
'TemplateFormat': CommTempFormat,
'paramList': paramList,
'op': RequestedOperation,
'by': by,
'ip': ip,
}
print "till here"
res = DBInsertCommunicationTemplate(details)
deleteCacheKey(CACHE_COMMUNICATION_TYPES)
return res
except:
error_msg = 'Error @ InsertCommunicationTemplate in Business Functions'
self.CommunicationLogger.exception('[%s] == Exception ==' %
('InsertCommunicationTemplate'))
return (-5, error_msg)
def InsertCommunicationType(self,
CommTypeName,
CommTypeDesc,
by,
ip,
RequestedOperation=SYSTEM_PERMISSION_INSERT):
CACHE_COMMUNICATION_TYPES = 'CACHE_COMMUNICATION_TYPES'
try:
details = {
'CommTypeName': CommTypeName,
'CommTypeDesc': CommTypeDesc,
'op': RequestedOperation,
'by': by,
'ip': ip,
}
res = DBInsertCommunicationType(details)
deleteCacheKey(CACHE_COMMUNICATION_TYPES)
return res
except:
error_msg = 'Error @ InsertCommunicationType in Business Functions'
self.CommunicationLogger.exception('[%s] == Exception ==' %
('InsertCommunicationType'))
return (-5, error_msg)
def CreateGroupType(self,gname,gdesc,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
try:
details = {
'ip':ip,
'by':by,
'name':gname,
'desc':gdesc,
'req_op':req_op,
}
result = DBGroupTypeInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (1,'SUCESS. GroupType has been sucessfully added to database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Update(self,MenuId,MenuName,MenuDesc,MenuUrl,MenuPid,MenuIcon,by,ip,LogDesc,RequestedOperation=SYSTEM_PERMISSION_UPDATE):
MenuObj = ''
try:
MenuObj = Menu.objects.get(id=MenuId)
except ObjectDoesNotExist:
return (-1,'Menu does not exist.')
PreviousState = str(MenuObj)
#TODO store based on comparisons
try:
details = {
'MenuId':MenuId,
'MenuName':MenuName,
'MenuDesc':MenuDesc,
'MenuUrl':MenuUrl,
'MenuPid':MenuPid,
'MenuIcon':MenuIcon,
'RequestedOperation':RequestedOperation,
'LogDesc':LogDesc,
'LogPreviousState':PreviousState,
'by':by,
'ip':ip,
}
result = DBMenuUpdate(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (1,'SUCESS. Menu has been sucessfully updated in database.')
else:
return (-1,decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.UserLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Insert(self,
MenuName,
MenuDesc,
MenuUrl,
MenuPid,
MenuIcon,
by,
ip,
RequestedOperation=SYSTEM_PERMISSION_INSERT):
try:
details = {
'MenuName': MenuName,
'MenuDesc': MenuDesc,
'MenuUrl': MenuUrl,
'MenuPid': MenuPid,
'MenuIcon': MenuIcon,
'RequestedOperation': RequestedOperation,
'by': by,
'ip': ip,
}
result = DBMenuInsert(details)
if (result['result'] == 1):
deleteCacheKey(self.CACHEKEY)
return (1,
'SUCESS. Menu has been sucessfully added to database.')
else:
return (-1, decode(result))
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i, values[i])
self.UserLogger.exception('%s : %s' %
(inspect.getframeinfo(frame)[2], msg))
return (-2, str(ex))
