WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/script/RedExpressLogisticsReconciliation.py



                airwaybill_no = update['ReferenceNo'] 
                track_list = update['TrackingList']['TrackingList']
                track_list.reverse()
                for track_update in track_list:
                    if track_update['TrackingCode'] == 'BKD' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        delivery_date = datestring + timestring
                        picked_up_orders[airwaybill_no] = delivery_date
                        break
 
            except:
                pass
        
    print "Picked up Orders:"
    print picked_up_orders

                airwaybill_no = update['ReferenceNo'] 
                track_list = update['TrackingList']['TrackingList']
                track_list.reverse()
                for track_update in track_list:
                    if track_update['TrackingCode'] == 'PRO' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        delivery_date = datestring + timestring
                        local_connected_orders[airwaybill_no] = delivery_date
                        break
 
            except:
                pass
            
    print "Local Connected Orders"
    print local_connected_orders

                airwaybill_no = update['ReferenceNo'] 
                track_list = update['TrackingList']['TrackingList']
                track_list.reverse()
                for track_update in track_list:
                    if track_update['TrackingCode'] == 'RDB' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        delivery_date = datestring + timestring
                        destination_city_reached_orders[airwaybill_no] = delivery_date
                        break
 
            except:
                pass
    
    print "Destination City Reached Orders"
    print destination_city_reached_orders

                airwaybill_no = update['ReferenceNo'] 
                track_list = update['TrackingList']['TrackingList']
                track_list.reverse()
                for track_update in track_list:
                    if track_update['TrackingCode'] == 'OFD' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        delivery_date = datestring + timestring
                        first_atdl_orders[airwaybill_no] = delivery_date
                        break
 
            except:
                pass
        
    
    print "FIRST DELIVERY ATTEMPT MADE Orders"

                        reason_for_return = record['ServiceEvent'].split(" -")[1]
                        break
                    
                for track_update in track_list:
                    if track_update['TrackingCode'] == 'DLVD' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        del_date = datestring + timestring
                        delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")
                        receiver = track_update['ServiceEvent'].split("[ ")[1].split(" ]")[0]
                        if to_py_date(awb_order_map.get(airwaybill_no)[1]) > delivery_date:
                            mail(from_user, from_pwd, to, "Delivery Problem for Red Express", "Order id " + str(awb_order_map.get(airwaybill_no)[0]) + " has shipping date " + str(awb_order_map.get(airwaybill_no)[1]) + " larger than delivery date " + str(delivery_date))
                        else:
                            delivered_orders[airwaybill_no] = str(delivery_date) + "|" +  receiver
                        break
                    elif track_update['TrackingCode'] == 'RTO' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        del_date = datestring + timestring
                        delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")
                        if reason_for_return == None:
                            returned_orders[airwaybill_no] = str(delivery_date) + "|"  + " Order Booked for Return"
                        else:
                            returned_orders[airwaybill_no] = str(delivery_date) + "|"  + reason_for_return
                        break
                    elif track_update['TrackingCode'] == 'UDLD' :
                        date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")
                        datestring  = date_obj.strftime("%Y-%m-%d")
                        timestring = track_update['ExecutionTime']+':00'
                        del_date = datestring + timestring
                        delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")
                        if reason_for_return == None:
                            undelivered_orders[airwaybill_no] = str(delivery_date) + "|" + track_update['ServiceEvent'].split(" -")[1]
                        else:
                            undelivered_orders[airwaybill_no] = str(delivery_date) + "|" + reason_for_return
                        break
 
            except:
                pass
    
    print "Delivered Orders:"
    print delivered_orders

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/RedExpressLogisticsReconciliation.py – Rev 8714 → 8771

Rev 8714		Rev 8771
Line 422...		Line 422...
422	`airwaybill_no = update['ReferenceNo']`	422	`airwaybill_no = update['ReferenceNo']`
423	`track_list = update['TrackingList']['TrackingList']`	423	`track_list = update['TrackingList']['TrackingList']`
424	`track_list.reverse()`	424	`track_list.reverse()`
425	`for track_update in track_list:`	425	`for track_update in track_list:`
426	`if track_update['TrackingCode'] == 'BKD' :`	426	`if track_update['TrackingCode'] == 'BKD' :`
427	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	427	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
428	`datestring = date_obj.strftime("%Y-%m-%d")`	428	`datestring = date_obj.strftime("%Y-%m-%d")`
429	`timestring = track_update['ExecutionTime']+':00'`	429	`timestring = track_update['ExecutionTime']+':00'`
430	`delivery_date = datestring + timestring`	430	`delivery_date = datestring + timestring`
431	`picked_up_orders[airwaybill_no] = delivery_date`	431	`picked_up_orders[airwaybill_no] = delivery_date`
432	`break`	432	`break`
433	`break`	-
434	`except:`	433	`except:`
435	`pass`	434	`pass`
436		435
437	`print "Picked up Orders:"`	436	`print "Picked up Orders:"`
438	`print picked_up_orders`	437	`print picked_up_orders`
Line 455...		Line 454...
455	`airwaybill_no = update['ReferenceNo']`	454	`airwaybill_no = update['ReferenceNo']`
456	`track_list = update['TrackingList']['TrackingList']`	455	`track_list = update['TrackingList']['TrackingList']`
457	`track_list.reverse()`	456	`track_list.reverse()`
458	`for track_update in track_list:`	457	`for track_update in track_list:`
459	`if track_update['TrackingCode'] == 'PRO' :`	458	`if track_update['TrackingCode'] == 'PRO' :`
460	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	459	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
461	`datestring = date_obj.strftime("%Y-%m-%d")`	460	`datestring = date_obj.strftime("%Y-%m-%d")`
462	`timestring = track_update['ExecutionTime']+':00'`	461	`timestring = track_update['ExecutionTime']+':00'`
463	`delivery_date = datestring + timestring`	462	`delivery_date = datestring + timestring`
464	`local_connected_orders[airwaybill_no] = delivery_date`	463	`local_connected_orders[airwaybill_no] = delivery_date`
465	`break`	464	`break`
466	`break`	-
467	`except:`	465	`except:`
468	`pass`	466	`pass`
469		467
470	`print "Local Connected Orders"`	468	`print "Local Connected Orders"`
471	`print local_connected_orders`	469	`print local_connected_orders`
Line 489...		Line 487...
489	`airwaybill_no = update['ReferenceNo']`	487	`airwaybill_no = update['ReferenceNo']`
490	`track_list = update['TrackingList']['TrackingList']`	488	`track_list = update['TrackingList']['TrackingList']`
491	`track_list.reverse()`	489	`track_list.reverse()`
492	`for track_update in track_list:`	490	`for track_update in track_list:`
493	`if track_update['TrackingCode'] == 'RDB' :`	491	`if track_update['TrackingCode'] == 'RDB' :`
494	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	492	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
495	`datestring = date_obj.strftime("%Y-%m-%d")`	493	`datestring = date_obj.strftime("%Y-%m-%d")`
496	`timestring = track_update['ExecutionTime']+':00'`	494	`timestring = track_update['ExecutionTime']+':00'`
497	`delivery_date = datestring + timestring`	495	`delivery_date = datestring + timestring`
498	`destination_city_reached_orders[airwaybill_no] = delivery_date`	496	`destination_city_reached_orders[airwaybill_no] = delivery_date`
499	`break`	497	`break`
500	`break`	-
501	`except:`	498	`except:`
502	`pass`	499	`pass`
503		500
504	`print "Destination City Reached Orders"`	501	`print "Destination City Reached Orders"`
505	`print destination_city_reached_orders`	502	`print destination_city_reached_orders`
Line 523...		Line 520...
523	`airwaybill_no = update['ReferenceNo']`	520	`airwaybill_no = update['ReferenceNo']`
524	`track_list = update['TrackingList']['TrackingList']`	521	`track_list = update['TrackingList']['TrackingList']`
525	`track_list.reverse()`	522	`track_list.reverse()`
526	`for track_update in track_list:`	523	`for track_update in track_list:`
527	`if track_update['TrackingCode'] == 'OFD' :`	524	`if track_update['TrackingCode'] == 'OFD' :`
528	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	525	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
529	`datestring = date_obj.strftime("%Y-%m-%d")`	526	`datestring = date_obj.strftime("%Y-%m-%d")`
530	`timestring = track_update['ExecutionTime']+':00'`	527	`timestring = track_update['ExecutionTime']+':00'`
531	`delivery_date = datestring + timestring`	528	`delivery_date = datestring + timestring`
532	`first_atdl_orders[airwaybill_no] = delivery_date`	529	`first_atdl_orders[airwaybill_no] = delivery_date`
533	`break`	530	`break`
534	`break`	-
535	`except:`	531	`except:`
536	`pass`	532	`pass`
537		533
538		534
539	`print "FIRST DELIVERY ATTEMPT MADE Orders"`	535	`print "FIRST DELIVERY ATTEMPT MADE Orders"`
Line 569...		Line 565...
569	`reason_for_return = record['ServiceEvent'].split(" -")[1]`	565	`reason_for_return = record['ServiceEvent'].split(" -")[1]`
570	`break`	566	`break`
571		567
572	`for track_update in track_list:`	568	`for track_update in track_list:`
573	`if track_update['TrackingCode'] == 'DLVD' :`	569	`if track_update['TrackingCode'] == 'DLVD' :`
574	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	570	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
575	`datestring = date_obj.strftime("%Y-%m-%d")`	571	`datestring = date_obj.strftime("%Y-%m-%d")`
576	`timestring = track_update['ExecutionTime']+':00'`	572	`timestring = track_update['ExecutionTime']+':00'`
577	`del_date = datestring + timestring`	573	`del_date = datestring + timestring`
578	`delivery_date = datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	574	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
579	`receiver = track_update['ServiceEvent'].split("[ ")[1].split(" ]")[0]`	575	`receiver = track_update['ServiceEvent'].split("[ ")[1].split(" ]")[0]`
580	`if to_py_date(awb_order_map.get(airwaybill_no)[1]) > delivery_date:`	576	`if to_py_date(awb_order_map.get(airwaybill_no)[1]) > delivery_date:`
581	`mail(from_user, from_pwd, to, "Delivery Problem for Red Express", "Order id " + str(awb_order_map.get(airwaybill_no)[0]) + " has shipping date " + str(awb_order_map.get(airwaybill_no)[1]) + " larger than delivery date " + str(delivery_date))`	577	`mail(from_user, from_pwd, to, "Delivery Problem for Red Express", "Order id " + str(awb_order_map.get(airwaybill_no)[0]) + " has shipping date " + str(awb_order_map.get(airwaybill_no)[1]) + " larger than delivery date " + str(delivery_date))`
582	`else:`	578	`else:`
583	`delivered_orders[airwaybill_no] = str(delivery_date) + "\|" + receiver`	579	`delivered_orders[airwaybill_no] = str(delivery_date) + "\|" + receiver`
584	`break`	580	`break`
585	`elif track_update['TrackingCode'] == 'RTO' :`	581	`elif track_update['TrackingCode'] == 'RTO' :`
586	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	582	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
587	`datestring = date_obj.strftime("%Y-%m-%d")`	583	`datestring = date_obj.strftime("%Y-%m-%d")`
588	`timestring = track_update['ExecutionTime']+':00'`	584	`timestring = track_update['ExecutionTime']+':00'`
589	`del_date = datestring + timestring`	585	`del_date = datestring + timestring`
590	`delivery_date = datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	586	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
591	`if reason_for_return == None:`	587	`if reason_for_return == None:`
592	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + " Order Booked for Return"`	588	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + " Order Booked for Return"`
593	`else:`	589	`else:`
594	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`	590	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`
595	`break`	591	`break`
596	`elif track_update['TrackingCode'] == 'UDLD' :`	592	`elif track_update['TrackingCode'] == 'UDLD' :`
597	`date_obj = datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	593	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
598	`datestring = date_obj.strftime("%Y-%m-%d")`	594	`datestring = date_obj.strftime("%Y-%m-%d")`
599	`timestring = track_update['ExecutionTime']+':00'`	595	`timestring = track_update['ExecutionTime']+':00'`
600	`del_date = datestring + timestring`	596	`del_date = datestring + timestring`
601	`delivery_date = datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	597	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
602	`if reason_for_return == None:`	598	`if reason_for_return == None:`
603	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + track_update['ServiceEvent'].split(" -")[1]`	599	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + track_update['ServiceEvent'].split(" -")[1]`
604	`else:`	600	`else:`
605	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`	601	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`
606	`break`	602	`break`
607	`break`	-
608	`except:`	603	`except:`
609	`pass`	604	`pass`
610		605
611	`print "Delivered Orders:"`	606	`print "Delivered Orders:"`
612	`print delivered_orders`	607	`print delivered_orders`