WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/api/Service.py



        resp.body = str(result)
    
class AppOffers():
    def on_get(self, req, resp, retailerId):
        retailerId = int(retailerId)
        #offset = req.get_param_as_int("offset")
        #limit = req.get_param_as_int("limit")
        nullCheckList = ['','0']
        offers = session.query(app_offers.id,app_offers.appmaster_id, app_offers.app_name, app_offers.affiliate_offer_id, app_offers.image_url, app_offers.downloads, app_offers.link, app_offers.offer_price, app_offers.offerCategory, app_offers.package_name, app_offers.promoImage, app_offers.ratings, case([(app_offers.override_payout == True, app_offers.overriden_payout)], else_=app_offers.user_payout).label('user_payout'), case([(appmasters.shortDescription != None, appmasters.shortDescription)], else_=None).label('shortDescription'), case([(appmasters.longDescription != None, appmasters.longDescription)], else_=None).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority, app_offers.offerCondition, app_offers.location).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.affiliate_id==retailerId).filter(appmasters.showApp==True).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(case([(app_offers.priority.in_(tuple(nullCheckList)), 1)], else_=0), asc(app_offers.priority),desc('user_payout')).all()
        #offers = session.query(app_offers.id,app_offers.appmaster_id, app_offers.app_name, app_offers.affiliate_offer_id, app_offers.image_url, app_offers.downloads, app_offers.link, app_offers.offer_price, app_offers.offerCategory, app_offers.package_name, app_offers.promoImage, app_offers.ratings, case([(app_offers.override_payout == True, app_offers.overriden_payout)], else_=app_offers.user_payout).label('user_payout'), case([(appmasters.shortDescription != None, appmasters.shortDescription)], else_=None).label('shortDescription'), case([(appmasters.longDescription != None, appmasters.longDescription)], else_=None).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority, app_offers.offerCondition, app_offers.location).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.affiliate_id==retailerId).filter(appmasters.showApp==True).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(case([(app_offers.priority.in_(tuple(nullCheckList)), 1)], else_=0), asc(app_offers.priority),desc('user_payout')).offset(offset).limit(limit).all()
        offersJsonArray = []
        if offers is None or len(offers)==0:
            resp.body = json.dumps("{}")
        else:
            for offer in offers:

            
class AppUserCashBack():
    def on_get(self, req, resp, userId, status):
        userId = long(userId)
        status = str(status)
        appUserApprovedCashBacks = user_app_cashbacks.query.filter(user_app_cashbacks.user_id==userId).filter(user_app_cashbacks.status==status).all()
        cashbackArray = []
        if session.is_active:
            print "session is active. closing it."
            session.close()
        if appUserApprovedCashBacks is None or len(appUserApprovedCashBacks)==0:

Rev 16748	Rev 16775
Line 1298...	Line 1298...
1298	`resp.body = str(result)`	1298	`resp.body = str(result)`
1299		1299
1300	`class AppOffers():`	1300	`class AppOffers():`
1301	`def on_get(self, req, resp, retailerId):`	1301	`def on_get(self, req, resp, retailerId):`
1302	`retailerId = int(retailerId)`	1302	`retailerId = int(retailerId)`
-		1303	`#offset = req.get_param_as_int("offset")`
-		1304	`#limit = req.get_param_as_int("limit")`
1303	`nullCheckList = ['','0']`	1305	`nullCheckList = ['','0']`
1304	offers = session.query(app_offers.id,app_offers.appmaster_id, app_offers.app_name, app_offers.affiliate_offer_id, app_offers.image_url, app_offers.downloads, app_offers.link, app_offers.offer_price, app_offers.offerCategory, app_offers.package_name, app_offers.promoImage, app_offers.ratings, case([(app_offers.override_payout == True, app_offers.overriden_payout)], else_=app_offers.user_payout).label('user_payout'), case([(appmasters.shortDescription != None, appmasters.shortDescription)], else_=None).label('shortDescription'), case([(appmasters.longDescription != None, appmasters.longDescription)], else_=None).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority, app_offers.offerCondition, app_offers.location).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.affiliate_id==retailerId).filter(appmasters.showApp==True).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(case([(app_offers.priority.in_(tuple(nullCheckList)), 1)], else_=0), asc(app_offers.priority),desc('user_payout')).all()	1306	offers = session.query(app_offers.id,app_offers.appmaster_id, app_offers.app_name, app_offers.affiliate_offer_id, app_offers.image_url, app_offers.downloads, app_offers.link, app_offers.offer_price, app_offers.offerCategory, app_offers.package_name, app_offers.promoImage, app_offers.ratings, case([(app_offers.override_payout == True, app_offers.overriden_payout)], else_=app_offers.user_payout).label('user_payout'), case([(appmasters.shortDescription != None, appmasters.shortDescription)], else_=None).label('shortDescription'), case([(appmasters.longDescription != None, appmasters.longDescription)], else_=None).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority, app_offers.offerCondition, app_offers.location).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.affiliate_id==retailerId).filter(appmasters.showApp==True).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(case([(app_offers.priority.in_(tuple(nullCheckList)), 1)], else_=0), asc(app_offers.priority),desc('user_payout')).all()
-		1307	#offers = session.query(app_offers.id,app_offers.appmaster_id, app_offers.app_name, app_offers.affiliate_offer_id, app_offers.image_url, app_offers.downloads, app_offers.link, app_offers.offer_price, app_offers.offerCategory, app_offers.package_name, app_offers.promoImage, app_offers.ratings, case([(app_offers.override_payout == True, app_offers.overriden_payout)], else_=app_offers.user_payout).label('user_payout'), case([(appmasters.shortDescription != None, appmasters.shortDescription)], else_=None).label('shortDescription'), case([(appmasters.longDescription != None, appmasters.longDescription)], else_=None).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority, app_offers.offerCondition, app_offers.location).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.affiliate_id==retailerId).filter(appmasters.showApp==True).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(case([(app_offers.priority.in_(tuple(nullCheckList)), 1)], else_=0), asc(app_offers.priority),desc('user_payout')).offset(offset).limit(limit).all()
1305	`offersJsonArray = []`	1308	`offersJsonArray = []`
1306	`if offers is None or len(offers)==0:`	1309	`if offers is None or len(offers)==0:`
1307	`resp.body = json.dumps("{}")`	1310	`resp.body = json.dumps("{}")`
1308	`else:`	1311	`else:`
1309	`for offer in offers:`	1312	`for offer in offers:`
Line 1365...	Line 1368...
1365		1368
1366	`class AppUserCashBack():`	1369	`class AppUserCashBack():`
1367	`def on_get(self, req, resp, userId, status):`	1370	`def on_get(self, req, resp, userId, status):`
1368	`userId = long(userId)`	1371	`userId = long(userId)`
1369	`status = str(status)`	1372	`status = str(status)`
1370	`appUserApprovedCashBacks = user_app_cashbacks.query.filter(user_app_cashbacks.user_id==userId).filter(user_app_cashbacks.status=='status').all()`	1373	`appUserApprovedCashBacks = user_app_cashbacks.query.filter(user_app_cashbacks.user_id==userId).filter(user_app_cashbacks.status==status).all()`
1371	`cashbackArray = []`	1374	`cashbackArray = []`
1372	`if session.is_active:`	1375	`if session.is_active:`
1373	`print "session is active. closing it."`	1376	`print "session is active. closing it."`
1374	`session.close()`	1377	`session.close()`
1375	`if appUserApprovedCashBacks is None or len(appUserApprovedCashBacks)==0:`	1378	`if appUserApprovedCashBacks is None or len(appUserApprovedCashBacks)==0:`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/api/Service.py – Rev 16748 → 16775