def toggleCardLockStatus(self, cardId, consumerId):
millis = SSUtil.getMillis()
cacheService = CacheService()
statusFlag = 0
try:
consumer = Consumer.objects.get(id=consumerId)
consumerCard = ConsumerCard.objects.get(id=cardId)
if SSUtil.isIdinList(consumer.blockedCards, cardId):
consumer.blockedCards = SSUtil.removeIdFromList(
consumer.blockedCards, cardId)
statusFlag = 1
consumerCard.status = 1
else:
consumer.blockedCards = SSUtil.addIdToList(
consumer.blockedCards, cardId)
statusFlag = 0
consumerCard.status = 0
consumer.updated = millis
consumerCard.updated = millis
consumer.save()
cacheService.setConsumer(consumer.id)
consumerCard.save()
cacheService.setCard(consumerCard.id)
return statusFlag
except:
raise Exception(SSException.PROCESSING_FAILED)
def unlockTxTypeStatus(self, cardId, txType):
millis = SSUtil.getMillis()
statusFlag = 1
cacheService = CacheService()
try:
consumerCard = ConsumerCard.objects.get(id=cardId)
if SSUtil.isIdinList(consumerCard.blockedTxTypes,txType):
consumerCard.blockedTxTypes = SSUtil.removeIdFromList(consumerCard.blockedTxTypes,txType)
statusFlag = 1
consumerCard.updated = millis
consumerCard.save()
cacheService.setCard(cardId)
return statusFlag
except:
raise Exception(SSException.PROCESSING_FAILED)
def recalculateAgg(self, consumerId, recentAmount, recentTxn):
currTimeMillis = SSUtil.getMillis()
ssConst = SSConst()
cacheService = CacheService()
prefs = cacheService.getConsumerPrefs(consumerId)
name_map = {'total': 'total', 'pk': 'id'}
periodKeysJson = ssConst.getJson(ssConst.PERIOD_KEYS)
approvalTypeJson = ssConst.getJson(ssConst.APPROVAL_TYPES)
if prefs:
for pref in prefs:
consumerAgg = ConsumerAgg()
querySt = "select sum(amtSpentSS) as total, 1 as id from ss_consumer_txn where consumerId =" + str(
consumerId)
querySt += " and ssApproval='" + ssConst.APPROVAL_TYPES[0][
0] + "'"
if pref.periodKey != 'Any':
print "period key is " + pref.periodKey
print " value is " + periodKeysJson[pref.periodKey]
querySt += " and FROM_UNIXTIME(created/1000) >= DATE_SUB(FROM_UNIXTIME(" + str(
currTimeMillis / 1000
) + "), INTERVAL " + periodKeysJson[pref.periodKey] + ")"
if pref.categoryKey != 'Any':
category = TxnCategory.objects.get(name=pref.categoryKey)
querySt += " and category_id = " + str(category.id)
if pref.txType != 'Any':
querySt += " and txType = '" + pref.txType + "'"
if pref.cardId != -1:
querySt += " and cardId = " + str(pref.cardId)
if pref.merchantId != -1:
querySt += " and merchant_id = " + str(pref.merchantId)
print querySt
res = ConsumerTxn.objects.raw(querySt, translations=name_map)
total = 0
for x in res:
total = x.total
if total == None:
total = 0
print total
# check if aggregate exists for this pref
print str(consumerId) + str(
pref.cardId
) + pref.periodKey + " " + pref.categoryKey + " " + pref.txType + " " + str(
pref.merchantId)
try:
consumerAgg = ConsumerAgg.objects.get(
consumerId=consumerId,
cardId=pref.cardId,
periodKey=pref.periodKey,
categoryKey=pref.categoryKey,
txType=pref.txType,
merchantId=pref.merchantId)
print "Got consumer agg " + str(total)
except ConsumerAgg.DoesNotExist:
consumerAgg.periodKey = pref.periodKey
consumerAgg.categoryKey = pref.categoryKey
consumerAgg.txType = pref.txType
consumerAgg.cardId = pref.cardId
consumerAgg.merchantId = pref.merchantId
consumerAgg.consumerId = pref.consumerId
consumerAgg.created = currTimeMillis
consumerAgg.amtSpentSS = total
consumerAgg.updated = currTimeMillis
consumerAgg.save()
cacheService.setConsumerAggs(consumerId)
#fix balance now
if not recentTxn is None:
if recentTxn.ssApproval == ssConst.APPROVAL_TYPES[0][0]:
card = ConsumerCard.objects.get(id=recentTxn.cardId)
card.amtSpentSS = card.amtSpentSS + recentAmount
card.currOS = card.currOS + recentAmount
card.avaialbleLimit = card.limit - card.currOS
card.updated = currTimeMillis
card.save()
cacheService.setCard(card.id)