Subversion Repositories SmartDukaan

Rev

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

Rev 18719 Rev 18764
Line 44... Line 44...
44 
import math
 44 
import math
45 
import sys
 45 
import sys
46 
import threading
 46 
import threading
47 
import urllib2
 47 
import urllib2
48 
from shop2020.clients.UserClient import UserClient
 48 
from shop2020.clients.UserClient import UserClient
- 
 
 49 
import operator
49 
 
 50 
 
50 
sourceId = int(ConfigClient().get_property("sourceid"))
 51 
sourceId = int(ConfigClient().get_property("sourceid"))
51 
to_addresses = ["khushal.bhatia@shop2020.in", "chandan.kumar@shop2020.in",  "chaitnaya.vats@shop2020.in",'manoj.kumar@shop2020.in']
 52 
to_addresses = ["khushal.bhatia@shop2020.in", "chandan.kumar@shop2020.in",  "chaitnaya.vats@shop2020.in",'manoj.kumar@shop2020.in']
52 
to_store_addresses = ["rajveer.singh@shop2020.in"]
 53 
to_store_addresses = ["rajveer.singh@shop2020.in"]
53 
mail_user = "cnc.center@shop2020.in"
 54 
mail_user = "cnc.center@shop2020.in"
Line 3334... Line 3335...
3334 
        d_bulkItem.id = bulkItem.id
 3335 
        d_bulkItem.id = bulkItem.id
3335 
        d_bulkItem.price = bulkItem.price
 3336 
        d_bulkItem.price = bulkItem.price
3336 
        d_bulkItem.quantity = bulkItem.quantity
 3337 
        d_bulkItem.quantity = bulkItem.quantity
3337 
        d_bulkItem.item_id = bulkItem.item_id
 3338 
        d_bulkItem.item_id = bulkItem.item_id
3338 
    session.commit()
 3339 
    session.commit()
3339 
    return True
3340 
    return True
3340
3341 
 
- 
 
 3342 
def get_cart_by_value(cartIds):
- 
 
 3343 
    itemList = []
- 
 
 3344 
    uc = UserClient().get_client()
- 
 
 3345 
    returnMap = uc.getCartByValue(cartIds)
- 
 
 3346 
    cartMap = {}
- 
 
 3347 
    for lines in returnMap.itervalues():
- 
 
 3348 
        for line in lines:
- 
 
 3349 
            if not line.itemId in itemList:
- 
 
 3350 
                itemList.append(line.itemId)
- 
 
 3351 
    items = session.query(Category.parent_category_id,Item.id).join((Item,Category.id==Item.category)).filter(Item.id.in_(itemList)).all()
- 
 
 3352 
    for item in items:
- 
 
 3353 
        if item[1] in (10001, 10009, 10049, 11001):
- 
 
 3354 
            itemList.remove(item[0])
- 
 
 3355 
    for cart_id, lines in returnMap.iteritems():
- 
 
 3356 
        actual_price = 0
- 
 
 3357 
        for line in lines:
- 
 
 3358 
            if line.itemId in itemList:
- 
 
 3359 
                actual_price = actual_price + line.actualPrice
- 
 
 3360 
        cartMap[cart_id] = actual_price
- 
 
 3361 
    sorted_x = sorted(cartMap.items(), key=operator.itemgetter(0))
- 
 
 3362 
    return sorted_x
3341 
 
 3363 
 
3342 
if __name__=='__main__':
 3364 
if __name__=='__main__':
3343 
    DataService.initialize()
 3365 
    DataService.initialize()
3344 
    #update_bulk_prices_on_production(21053,[])
 3366 
    #update_bulk_prices_on_production(21053,[])
3345 
    print get_bulk_pricing_for_items([])
 3367 
    get_cart_by_value([1005394,46868158])
3346
3368
3347 

            3369