Subversion Repositories SmartDukaan

Rev

Rev 15657 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15657 Rev 15658
Line 45... Line 45...
45 
 
 45 
 
46 
def process_store_orders_mismatch_data():
 46 
def process_store_orders_mismatch_data():
47 
    DataService.initialize('transaction','192.168.190.114')
 47 
    DataService.initialize('transaction','192.168.190.114')
48 
    logistics_client = LogisticsClient().get_client()
 48 
    logistics_client = LogisticsClient().get_client()
49 
    current_time = datetime.datetime.now()
 49 
    current_time = datetime.datetime.now()
50 
    previous_time= current_time - datetime.timedelta(days=365)
 50 
    previous_time= current_time - datetime.timedelta(days=600)
51 
    store_orders =  Order.query.filter(Order.pickupStoreId> 0).filter(Order.cod==True).filter((Order.status == OrderStatus.DELIVERY_SUCCESS)).filter(Order.delivery_timestamp.between (previous_time,current_time))
 51 
    store_orders =  Order.query.filter(Order.pickupStoreId> 0).filter(Order.cod==True).filter((Order.status == OrderStatus.DELIVERY_SUCCESS)).filter(Order.delivery_timestamp.between (previous_time,current_time))
52 
    wbk = xlwt.Workbook()
 52 
    wbk = xlwt.Workbook()
53 
    sheet = wbk.add_sheet('main')
 53 
    sheet = wbk.add_sheet('main')
54
54
55 
    all_pickup_stores= logistics_client.getAllPickupStores()
 55 
    all_pickup_stores= logistics_client.getAllPickupStores()