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

         result = Mongo.addPayout(payout, transaction_id)
         resp.body = str(result)
 class AppOffers():
     def on_get(self, req, resp, retailerId):
-        try:
-            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()
+        try:
-            #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()
+            result = Mongo.getAppOffers(retailerId)
-            offersJsonArray = []
+            offerids = result.values()
-            if offers is None or len(offers)==0:
+            if offerids is None or len(offerids)==0:
                 resp.body = json.dumps("{}")
             else:
-                for offer in offers:
+                appOffers = 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.id.in_(tuple(offerids))).all()
+                appOffersMap = {}
-                    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], offer[19])
+                jsonOffersArray=[]
+                for offer in appOffers:
-                    offersJsonArray.append(todict(appOfferObj))
+                    appOffersMap[long(offer[0])]= 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], offer[19]).__dict__
+                for rank in sorted(result):
+                    print 'Rank', rank, 'Data', appOffersMap[result[rank]]
+                    jsonOffersArray.append(appOffersMap[result[rank]])
-            resp.body = json.dumps({"AppOffers":offersJsonArray}, encoding='latin1' )
+            resp.body = json.dumps({"AppOffers":jsonOffersArray}, encoding='latin1')
         finally:
             session.close()
 class AppUserBatchRefund():
     def on_get(self, req, resp, batchId, userId):
         try:
             batchId = long(batchId)
             userId = long(userId)
             userBatchCashback = user_app_cashbacks.get_by(user_id=userId, batchCreditId=batchId)
+            if userBatchCashback.creditedDate is not None:
+                userBatchCashback.creditedDate = str(userBatchCashback.creditedDate)
             if userBatchCashback is None:
                 resp.body = json.dumps("{}")
             else:
                 resp.body = json.dumps(todict(userBatchCashback), encoding='utf-8')
         finally:
                 resp.body = json.dumps("{}")
             else:
                 totalAmount = 0
                 for appUserApprovedCashBack in appUserApprovedCashBacks:
                     totalAmount = totalAmount + appUserApprovedCashBack.amount
                     cashbackArray.append(todict(appUserApprovedCashBack))
+                    if appUserApprovedCashBack.creditedDate is not None:
+                        appUserApprovedCashBack.creditedDate = str(appUserApprovedCashBack.creditedDate)
                 resp.body = json.dumps({"UserAppCashBack":cashbackArray,"TotalAmount":totalAmount}, encoding='utf-8')
         finally:
             session.close()

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/api/Service.py – Rev 16887 → 16895