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



                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
        

                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
            

                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
    

                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
        

                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:

                        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

Subversion Repositories SmartDukaan

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

Rev 8771		Rev 8772
Line 425...		Line 425...
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.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	`except:`	433	`except:`
434	`pass`	434	`pass`
435		435
Line 457...		Line 457...
457	`for track_update in track_list:`	457	`for track_update in track_list:`
458	`if track_update['TrackingCode'] == 'PRO' :`	458	`if track_update['TrackingCode'] == 'PRO' :`
459	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	459	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
460	`datestring = date_obj.strftime("%Y-%m-%d")`	460	`datestring = date_obj.strftime("%Y-%m-%d")`
461	`timestring = track_update['ExecutionTime']+':00'`	461	`timestring = track_update['ExecutionTime']+':00'`
462	`delivery_date = datestring + timestring`	462	`delivery_date = datestring +' '+ timestring`
463	`local_connected_orders[airwaybill_no] = delivery_date`	463	`local_connected_orders[airwaybill_no] = delivery_date`
464	`break`	464	`break`
465	`except:`	465	`except:`
466	`pass`	466	`pass`
467		467
Line 490...		Line 490...
490	`for track_update in track_list:`	490	`for track_update in track_list:`
491	`if track_update['TrackingCode'] == 'RDB' :`	491	`if track_update['TrackingCode'] == 'RDB' :`
492	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	492	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
493	`datestring = date_obj.strftime("%Y-%m-%d")`	493	`datestring = date_obj.strftime("%Y-%m-%d")`
494	`timestring = track_update['ExecutionTime']+':00'`	494	`timestring = track_update['ExecutionTime']+':00'`
495	`delivery_date = datestring + timestring`	495	`delivery_date = datestring +' '+ timestring`
496	`destination_city_reached_orders[airwaybill_no] = delivery_date`	496	`destination_city_reached_orders[airwaybill_no] = delivery_date`
497	`break`	497	`break`
498	`except:`	498	`except:`
499	`pass`	499	`pass`
500		500
Line 523...		Line 523...
523	`for track_update in track_list:`	523	`for track_update in track_list:`
524	`if track_update['TrackingCode'] == 'OFD' :`	524	`if track_update['TrackingCode'] == 'OFD' :`
525	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	525	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
526	`datestring = date_obj.strftime("%Y-%m-%d")`	526	`datestring = date_obj.strftime("%Y-%m-%d")`
527	`timestring = track_update['ExecutionTime']+':00'`	527	`timestring = track_update['ExecutionTime']+':00'`
528	`delivery_date = datestring + timestring`	528	`delivery_date = datestring +' '+ timestring`
529	`first_atdl_orders[airwaybill_no] = delivery_date`	529	`first_atdl_orders[airwaybill_no] = delivery_date`
530	`break`	530	`break`
531	`except:`	531	`except:`
532	`pass`	532	`pass`
533		533
Line 568...		Line 568...
568	`for track_update in track_list:`	568	`for track_update in track_list:`
569	`if track_update['TrackingCode'] == 'DLVD' :`	569	`if track_update['TrackingCode'] == 'DLVD' :`
570	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	570	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
571	`datestring = date_obj.strftime("%Y-%m-%d")`	571	`datestring = date_obj.strftime("%Y-%m-%d")`
572	`timestring = track_update['ExecutionTime']+':00'`	572	`timestring = track_update['ExecutionTime']+':00'`
573	`del_date = datestring + timestring`	573	`del_date = datestring +' '+ timestring`
574	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	574	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
575	`receiver = track_update['ServiceEvent'].split("[ ")[1].split(" ]")[0]`	575	`receiver = track_update['ServiceEvent'].split("[ ")[1].split(" ]")[0]`
576	`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:`
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))`	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))`
578	`else:`	578	`else:`
Line 580...		Line 580...
580	`break`	580	`break`
581	`elif track_update['TrackingCode'] == 'RTO' :`	581	`elif track_update['TrackingCode'] == 'RTO' :`
582	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	582	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
583	`datestring = date_obj.strftime("%Y-%m-%d")`	583	`datestring = date_obj.strftime("%Y-%m-%d")`
584	`timestring = track_update['ExecutionTime']+':00'`	584	`timestring = track_update['ExecutionTime']+':00'`
585	`del_date = datestring + timestring`	585	`del_date = datestring +' '+ timestring`
586	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	586	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
587	`if reason_for_return == None:`	587	`if reason_for_return == None:`
588	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + " Order Booked for Return"`	588	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + " Order Booked for Return"`
589	`else:`	589	`else:`
590	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`	590	`returned_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`
591	`break`	591	`break`
592	`elif track_update['TrackingCode'] == 'UDLD' :`	592	`elif track_update['TrackingCode'] == 'UDLD' :`
593	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`	593	`date_obj = datetime.datetime.strptime(track_update['ExecutionDate'].split(' ')[0],"%m/%d/%Y")`
594	`datestring = date_obj.strftime("%Y-%m-%d")`	594	`datestring = date_obj.strftime("%Y-%m-%d")`
595	`timestring = track_update['ExecutionTime']+':00'`	595	`timestring = track_update['ExecutionTime']+':00'`
596	`del_date = datestring + timestring`	596	`del_date = datestring +' '+ timestring`
597	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`	597	`delivery_date = datetime.datetime.strptime(del_date,"%Y-%m-%d %H:%M:%S")`
598	`if reason_for_return == None:`	598	`if reason_for_return == None:`
599	`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]`
600	`else:`	600	`else:`
601	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`	601	`undelivered_orders[airwaybill_no] = str(delivery_date) + "\|" + reason_for_return`