Subversion Repositories SmartDukaan

Rev

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

Rev 17139 Rev 17145
Line 73... Line 73...
73 
                left join (select user_id, count(*) as order_count from order_view where status in ('ORDER_CREATED','DETAIL_CREATED')  group by user_id)as crm1 on ow.user_id = crm1.user_id
 73 
                left join (select user_id, count(*) as order_count from order_view where status in ('ORDER_CREATED','DETAIL_CREATED')  group by user_id)as crm1 on ow.user_id = crm1.user_id
74 
                left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
74 
                left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
75 
                where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
75 
                where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
76 
                ''',)
 76 
                ''',)
77
77
- 
 
 78 
        query = """INSERT INTO allorder
78 
        query = """INSERT INTO allorder (user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode, merchant_suborder_id,cashback_status,cashback_amount) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"""
79 
                    (user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode, merchant_suborder_id,cashback_status,cashback_amount)
- 
 
 80 
                    VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
- 
 
 81 
                """
79 
        for result in results:
 82 
        for result in results:
80 
            morder = db.merchantOrder.find_one({"orderId":result[0]})
 83 
            morder = db.merchantOrder.find_one({"orderId":result[0]})
81 
            if morder is not None:
 84 
            if morder is not None:
82 
                subOrders = morder.get("subOrders")
 85 
                subOrders = morder.get("subOrders")
83 
                if subOrders is not None:
 86 
                if subOrders is not None:
Line 105... Line 108...
105 
                            model = skuData.get("model_name")
 108 
                            model = skuData.get("model_name")
106 
                            category = skuData.get("category")
 109 
                            category = skuData.get("category")
107 
                            deal_rank = subOrder.get("dealRank")
 110 
                            deal_rank = subOrder.get("dealRank")
108 
                            max_nlc = subOrder.get("maxNlc")
 111 
                            max_nlc = subOrder.get("maxNlc")
109 
                            min_nlc = subOrder.get("minNlc")
 112 
                            min_nlc = subOrder.get("minNlc")
110 
                            dp = utils.statusMap.get(subOrder.get("db"))
 113 
                            dp = subOrder.get("db")
111 
                            item_status = subOrder.get("itemStatus")
 114 
                            item_status = utils.statusMap.get(subOrder.get("itemStatus"))
112 
                        else:
 115 
                        else:
113 
                            catalog_id = 'None'
 116 
                            catalog_id = 'None'
114 
                            brand= 'None'
 117 
                            brand= 'None'
115 
                            model = 'None'
 118 
                            model = 'None'
116 
                            category = 'None'
 119 
                            category = 'None'