Subversion Repositories SmartDukaan

Rev

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

Rev 16631 Rev 16684
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
        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, func.IF("appmasters.shortDescription is not null", appmasters.shortDescription, app_offers.shortDescription).label('shortDescription'), func.IF("appmasters.longDescription is not null", appmasters.longDescription, app_offers.longDescription).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.show==True).order_by(asc(app_offers.priority),desc(app_offers.user_payout)).all()
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, func.IF("appmasters.shortDescription is not null", appmasters.shortDescription, app_offers.shortDescription).label('shortDescription'), func.IF("appmasters.longDescription is not null", appmasters.longDescription, app_offers.longDescription).label('longDescription'), appmasters.customerOneLiner, appmasters.retailerOneLiner,app_offers.priority).join((appmasters,appmasters.id==app_offers.appmaster_id)).filter(app_offers.show==True).filter(app_offers.offer_active==True).order_by(asc(app_offers.priority),desc(app_offers.user_payout)).all()
1304
        offersJsonArray = []
1304
        offersJsonArray = []
1305
        if offers is None or len(offers)==0:
1305
        if offers is None or len(offers)==0:
1306
            resp.body = json.dumps("{}")
1306
            resp.body = json.dumps("{}")
1307
        else:
1307
        else:
1308
            for offer in offers:
1308
            for offer in offers: