Subversion Repositories SmartDukaan

Rev

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

Rev 16684 Rev 16694
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).filter(app_offers.offer_active==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, 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
        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:
1309
                appOfferObj = AppOfferObj(offer[0], offer[1], offer[2], offer[3], offer[4], offer[5], offer[6], offer[7], offer[8], offer[9], offer[10], offer[11], offer[12], offer[13], offer[14], offer[15], offer[16], offer[17])
1309
                appOfferObj = AppOfferObj(offer[0], offer[1], offer[2], offer[3], offer[4], offer[5], offer[6], offer[7], offer[8], offer[9], offer[10], offer[11], offer[12], offer[13], offer[14], offer[15], offer[16], offer[17], offer[18])
1310
                offersJsonArray.append(todict(appOfferObj)) 
1310
                offersJsonArray.append(todict(appOfferObj)) 
1311
        resp.body = json.dumps({"AppOffers":offersJsonArray}, encoding='utf-8')
1311
        resp.body = json.dumps({"AppOffers":offersJsonArray}, encoding='utf-8')
1312
 
1312
 
1313
def main():
1313
def main():
1314
    #tagActivatedReatilers()
1314
    #tagActivatedReatilers()