| Line 1330... |
Line 1330... |
| 1330 |
resp.body = json.dumps("{}")
|
1330 |
resp.body = json.dumps("{}")
|
| 1331 |
else:
|
1331 |
else:
|
| 1332 |
resp.body = json.dumps(todict(userBatchCashback), encoding='utf-8')
|
1332 |
resp.body = json.dumps(todict(userBatchCashback), encoding='utf-8')
|
| 1333 |
|
1333 |
|
| 1334 |
class AppUserBatchDrillDown():
|
1334 |
class AppUserBatchDrillDown():
|
| 1335 |
def on_get(self, req, resp, batchId, userId):
|
1335 |
def on_get(self, req, resp, fortNightOfYear, userId, yearVal):
|
| 1336 |
batchId = long(batchId)
|
1336 |
fortNightOfYear = long(fortNightOfYear)
|
| 1337 |
userId = long(userId)
|
1337 |
userId = long(userId)
|
| - |
|
1338 |
yearVal = long(yearVal)
|
| 1338 |
appUserBatchDrillDown = session.query(user_app_installs.transaction_date, func.sum(user_app_installs.installCount).label('downloads'), func.sum(user_app_installs.payoutAmount).label('amount')).join((user_app_cashbacks,user_app_cashbacks.user_id==user_app_installs.user_id)).filter(user_app_cashbacks.fortnightOfYear==user_app_installs.fortnightOfYear).filter(user_app_cashbacks.user_id==userId).filter(user_app_cashbacks.batchCreditId==batchId).group_by(user_app_installs.transaction_date).all()
|
1339 |
appUserBatchDrillDown = session.query(user_app_installs.transaction_date, func.sum(user_app_installs.installCount).label('downloads'), func.sum(user_app_installs.payoutAmount).label('amount')).join((user_app_cashbacks,user_app_cashbacks.user_id==user_app_installs.user_id)).filter(user_app_cashbacks.fortnightOfYear==user_app_installs.fortnightOfYear).filter(user_app_cashbacks.user_id==userId).filter(user_app_cashbacks.yearVal==yearVal).filter(user_app_cashbacks.fortnightOfYear==fortNightOfYear).group_by(user_app_installs.transaction_date).all()
|
| 1339 |
cashbackArray = []
|
1340 |
cashbackArray = []
|
| 1340 |
if session.is_active:
|
1341 |
if session.is_active:
|
| 1341 |
print "session is active. closing it."
|
1342 |
print "session is active. closing it."
|
| 1342 |
session.close()
|
1343 |
session.close()
|
| 1343 |
if appUserBatchDrillDown is None or len(appUserBatchDrillDown)==0:
|
1344 |
if appUserBatchDrillDown is None or len(appUserBatchDrillDown)==0:
|