Subversion Repositories SmartDukaan

Rev

Rev 16715 | Rev 16719 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 16715 Rev 16716
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 
        nullCheckList = ['','0']
1303 
        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, app_offers.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).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.show==True).filter(app_offers.offer_active==True).filter(app_offers.offer_price>0).order_by(asc(-app_offers.priority),desc(app_offers.user_payout)).all()
 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, app_offers.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).join((appmasters,appmasters.id==app_offers.appmaster_id)).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(app_offers.user_payout)).all()
1304 
        offersJsonArray = []
 1305 
        offersJsonArray = []
1305 
        if offers is None or len(offers)==0:
 1306 
        if offers is None or len(offers)==0:
1306 
            resp.body = json.dumps("{}")
 1307 
            resp.body = json.dumps("{}")
1307 
        else:
 1308 
        else:
1308 
            for offer in offers:
 1309 
            for offer in offers: