Subversion Repositories SmartDukaan

def getSubCategoryForFilter(category_id):

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

        print "Populating subcategory data for category_id %d" %(category_id)

        tabData, mobData, accData = [], [], []

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

                                                                      {"$match":{"category_id":6,"showDeal":1,"totalPoints":{"$gt":-100}}

                                                                    },

                                                                 {"$group" : 

                                                                  {'_id':{'subCategoryId':'$subCategoryId','subCategory':'$subCategory'},'count':{'$sum':1}}

                                                                  }

                                                                ])

        for accessoryDeal in accessoriesDeals['result']:

            if accessoryDeal.get('_id').get('subCategoryId') != 0:

                tempMap = {}

                tempMap['subCategory'] = accessoryDeal.get('_id').get('subCategory')

                tempMap['subCategoryId'] = accessoryDeal.get('_id').get('subCategoryId')

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

                accData.append(tempMap)

        mc.set("subCategoryFilter",{3:mobData, 5:tabData, 6:accData}, 600)  

    return sorted(mc.get("subCategoryFilter").get(category_id), key = lambda x: (-x['count'], x['subCategory']))