Subversion Repositories SmartDukaan

def getBrandsForFilter(category_id):

    if mc.get("brandFilter") is None:

        tabData, mobData = [], []

        mobileDeals = get_mongo_connection().Catalog.Deals.aggregate([

                                                                      {"$match":{"category_id":3,"showDeal":1}

                                                                    },

                                                                 {"$group" : 

                                                                  {'_id':{'brand_id':'$brand_id','brand':'$brand'},'count':{'$sum':1}}

                                                                  }

                                                                ])

        tabletDeals = get_mongo_connection().Catalog.Deals.aggregate([

                                                                      {"$match":{"category_id":5,"showDeal":1}

                                                                    },

                                                                 {"$group" : 

                                                                  {'_id':{'brand_id':'$brand_id','brand':'$brand'},'count':{'$sum':1}}

                                                                  }

                                                                ])

        allDeals = get_mongo_connection().Catalog.Deals.aggregate([

                                                                   {"$match":{"showDeal":1}

                                                                    },

                                                                 {"$group" : 

                                                                  {'_id':{'brand_id':'$brand_id','brand':'$brand'},'count':{'$sum':1}}

                                                                  }

                                                                ])

        #print mobileDeals

        #print "==========Mobile data ends=========="

        #print tabletDeals

        #print "==========Tablet data ends=========="

        #print allDeals

        #print "==========All deal data ends========="

        for mobileDeal in mobileDeals['result']:

            if mobileDeal.get('_id').get('brand_id') != 0:

                tempMap = {}

                tempMap['brand'] = mobileDeal.get('_id').get('brand')

                tempMap['brand_id'] = mobileDeal.get('_id').get('brand_id')

                tempMap['count'] = mobileDeal.get('count')

                mobData.append(tempMap)

        for tabletDeal in tabletDeals['result']:

            if tabletDeal.get('_id').get('brand_id') != 0:

                tempMap = {}

                tempMap['brand'] = tabletDeal.get('_id').get('brand')

                tempMap['brand_id'] = tabletDeal.get('_id').get('brand_id')

                tempMap['count'] = tabletDeal.get('count')

                tabData.append(tempMap)

        brandMap = {}

        for allDeal in allDeals['result']:

            if allDeal.get('_id').get('brand_id') != 0:

                if brandMap.has_key(allDeal.get('_id').get('brand')):

                    brand_ids = brandMap.get(allDeal.get('_id').get('brand'))

                    brand_ids.append(allDeal.get('_id').get('brand_id'))

                    brandMap[allDeal.get('_id').get('brand')] = brand_ids

                else:

                    temp = []

                    temp.append(allDeal.get('_id').get('brand_id'))

                    brandMap[allDeal.get('_id').get('brand')] = temp

        mc.set("brandFilter",{0:brandMap, 3:mobData, 5:tabData}, 600)  

    return mc.get("brandFilter").get(category_id)