U 4hQ@s dZdddgdegegegegdegegegegdegegegegdddddd d d d d dddddddddgdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdddddddgdegegegegdegegegegdegegegegdddddddddddd d!d"d#d$d%d&d'd(gd)d*gd+gegegdd,gd+gegegdd-gd+gegegdd.gd+gegegdd/gd+gegegdd0gd+gegegdd1gd+gegegdd2gd+gegegdd3gd+gegegdd4gd+gegegdd5gd+gegegdd6gd+gegegdd7gd+gegegdd8gd+gegegdd9gd+gegegdd:gd+gegegdd;gd+gegegdd<ddddd d=d>d?d@gdAegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegddBddddd>dCgdDegegegegdegegegegdegegegegdegegegegdegegegegddEddFdddgdegegegegdegegegegdegegegegddddddGdHdddd d!d"d#dIddJdKdLdMdNdOgdPegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegddQddd dRdSgdTegegegegdegegegegdegegegegdegegegegddUddVdddgdegegegegdegegegegdegegegegddddWdXd dYdZd[d\d]d^d_g d`egegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdda ddbdddgdegegegegdegegegegdegegegegdddddddcdddedfgdgegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegddhddddd d=d>d?digdjegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegdegegegegddkddldddgdegegegegdegegegegdegegegegdddddmd>d dngdoegegegegdegegegegdegegegegdegegegegdegegegegddpddqdddgdegegegegdegegegegdegegegegddddWd^drgdsegegegegdegegegegdegegegegddtddudvZdS)wNRECORD_INDICATORCLIENT STREAM_IDz9{data[RECORD_INDICATOR]}|{data[CLIENT]}|{data[STREAM_ID]}) ProcessingLoops Loop_Len1 Loop_Len2)rrr)zCol ListtemplatemappingACTION_INDICATORPRODUCT DESCRIPTIONEXTRA_DESCRIPTIONBRAND/PRODUCT GROUPMOQBARCODE_1 ( Unit)BARCODE_2 ( Inner )BARCODE_3 ( Outer )INNER CARTON QTYOUTER CARTON QTY UNIT LENGTH UNIT WIDTH UNIT HEIGHT UNIT WEIGHTak{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[PRODUCT]}|{data[DESCRIPTION]}|{data[EXTRA_DESCRIPTION]}|{data[BRAND/PRODUCT GROUP]}|{data[MOQ]}|{data[BARCODE_1 ( Unit)]}|{data[BARCODE_2 ( Inner )]}|{data[BARCODE_3 ( Outer )]}|{data[INNER CARTON QTY]}|{data[OUTER CARTON QTY]}|{data[UNIT LENGTH]}|{data[UNIT WIDTH ]}|{data[UNIT HEIGHT]}|{data[UNIT WEIGHT]})rr r r r rrrrrrrrrrr)HDITCUST_ORDER_NUMBER ORDER_DATEE_T_D VENDOR_ORD_NO SHIP_TO_NAMESHIP_TO_ADDRESS_1_1SHIP_TO_ADDRESS_1_2AREASTATEPOSTCODECOUNTRY ORDER_TYPE CARRIER_CODEPHONE_NO EMAIL_ADDRESSaZ{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[ORDER_DATE]}|{data[E_T_D]}|{data[VENDOR_ORD_NO]}|{data[SHIP_TO_NAME]}|{data[SHIP_TO_ADDRESS_1_1]}|{data[SHIP_TO_ADDRESS_1_2]}|{data[AREA]}|{data[STATE]}|{data[POSTCODE]}|{data[COUNTRY]}|{data[ORDER_TYPE]}|{data[CARRIER_CODE]}|{data[PHONE_NO]}|{data[EMAIL_ADDRESS]}zdata[ci]="OR1"gz data[ci]="A"zdata[ci]={var}['id']zdata[ci]=str(datetime.strptime({var}['date'],'%Y-%m-%dT%H:%M:%S.%fZ').replace(tzinfo=from_zone).astimezone(to_zone).strftime("%Y%m%d"))z data[ci]=""zdata[ci]={var}['order_number']zif {var}['order_source']=='shopify': if {var}['contact_name']: data[ci]={var}['contact_name'] else: data[ci]={var}['customer_name'] else: data[ci]={var}['customer_name']z#data[ci]={var}['address']['line_1']a>line2 = {var}['address']['line_2'] line3 = {var}['address']['line_3'] if bool(line2) and (line3): data[ci]=" ".join([{var}['address']['line_2'],{var}['address']['line_3']]) elif bool(line2): data[ci]={var}['address']['line_2'] elif bool(line3): data[ci]={var}['address']['line_3'] else: data[ci]=""aEaddress_error = checkAddressForError({var}) if 'City Error' in address_error.keys(): data[ci] = 'Error' error['OR']= 'Error in Address' error['send_to_CD'] = False error['address_error'] = address_error error['City data received']={var}['address']['city'] else: data[ci]={var}['address']['city']aWaddress_error = checkAddressForError({var}) if 'Aust State Error' in address_error.keys() : data[ci] = 'Error' error['OR']= 'Error in Address' error['send_to_CD'] = False error['address_error'] = address_error error['State data received']={var}['address']['state'] else: data[ci]={var}['address']['state'].upper()aVaddress_error = checkAddressForError({var}) if 'Aust Postcode Error' in address_error.keys(): data[ci] = 'Error' error['OR']= 'Error in Address' error['send_to_CD'] = False error['address_error'] = address_error error['Postcode data received'] ={var}['address']['postcode'] else: data[ci]={var}['address']['postcode']zif {var}['address']['country'] in cc_codes_pd['Alpha-2 code'].to_list() : data[ci]=cc_codes_pd.index[cc_codes_pd['Alpha-2 code'] == {var}['address']['country']].to_list()[0] else: data[ci]= {var}['address']['country']aif {var}['warehouse'] == 'eCommerce Warehouse' : if 'eCommerce' in {var}['channel']: data[ci] = 'eCommerce - online' elif 'Wholesale' in {var}['channel']: data[ci] = 'eCommerce - reorder' else: data[ci] = 'Error' error['OR'] = 'Error in determining ORDER_TYPE 1' error['send_to_CD'] = False error['extra_info'] = {var}['channel'] + ', ' + {var}['warehouse'] elif {var}['warehouse'] == 'Wholesale Warehouse': data[ci] = {var}['channel'] else: data[ci] = 'Error' error['OR'] = 'Order not for Cross Docks - Australia' error['send_to_CD'] = False error['extra_info'] = {var}['channel'] + ', ' + {var}['warehouse'] amethod = {var}['shipping_method'] if ('DHL' in method): #the latter to cater for errors seen from Shopify / shipping app data[ci]='EM001' elif 'Standard' in method: if 'signature' in {var}['customer_note'].lower(): data[ci]='CD004' else: data[ci]='CD003' elif 'Express' in method: data[ci] = 'CD020' elif len(method) == 0: data[ci] = 'CD001' elif method == 'Shipping' : #this is error case from Shopify or "Shipping App" data[ci]='EM001' error['OR']= 'Error in Carrier Coding' error['send_to_CD'] = True else: data[ci] = 'Error' error['OR']= 'Error in Carrier Coding' error['send_to_CD'] = False zdata[ci]={var}['contact_phone']zdata[ci]={var}['contact_email'])rr rrrrrr r!r"r#r$r%r&r'r(r)QUANTITY_ORDERED LINE_NUMBER BATCH NUMBER STOCK STATUSz{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[PRODUCT]}|{data[QUANTITY_ORDERED]}|{data[LINE_NUMBER]}|{data[BATCH NUMBER]}|{data[STOCK STATUS]})rr rr r*r+r,r- ORDER_NOTEzr{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[LINE_NUMBER]}|{data[ORDER_NOTE]})rr rr+r.)rOR1OR2OR4IFAC_CUSTOMER_NOETDDELIVERY_DESC1 SERVICE_LEVELASNINVOICE_NUMBER TOTAL ITEMSFREIGHT_CHARGECONSIGNMENT_NUMBERa{data[RECORD_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[IFAC_CUSTOMER_NO]}|{data[ETD]}|{data[ORDER_DATE]}|{data[SHIP_TO_NAME]}|{data[SHIP_TO_ADDRESS_1_1]}|{data[SHIP_TO_ADDRESS_1_2]}|{data[AREA]}|{data[STATE]}|{data[POSTCODE]}|{data[DELIVERY_DESC1]}|{data[VENDOR_ORD_NO]}|{data[SERVICE_LEVEL]}|{data[ASN]}|{data[INVOICE_NUMBER]}|{data[TOTAL ITEMS]}|{data[FREIGHT_CHARGE]}|{data[CONSIGNMENT_NUMBER]})rrr2r3rrr r!r"r#r$r4rr5r6r7r8r9r:QUANTITY_SHIPPEDPACK_IDzQ{data[RECORD_INDICATOR]}|{data[PRODUCT]}|{data[QUANTITY_SHIPPED]}|{data[PACK_ID]})rr r;r<)rOS1OS2CONST DATE_RECEIVEDQUANTITY REASON_CODE SA_COMMENTCONSIGNMENT NO.TRANSACTION_TYPEORDER_NO STOCK_STATUSz{data[CONST]}|{data[DATE_RECEIVED]}|{data[PRODUCT]}|{data[QUANTITY]}|{data[REASON_CODE]}|{data[SA_COMMENT]}|{data[CONSIGNMENT NO.]}|{data[TRANSACTION_TYPE]}|{data[ORDER_NO]}|{data[STOCK_STATUS]}) r?r@r rArBrCrDrErFrG)rSACONTAINER_NUMBER ARRIVAL_DATECONTAINER_TYPE TOTAL_CARTONSz{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[CONTAINER_NUMBER]}|{data[ARRIVAL_DATE]}|{data[CONTAINER_TYPE]}|{data[TOTAL_CARTONS]})rr rrIrJrKrLCARTON PACK_IDz{data[RECORD_INDICATOR]}|{data[ACTION_INDICATOR]}|{data[CUST_ORDER_NUMBER]}|{data[PRODUCT]}|{data[QUANTITY_ORDERED]}|{data[LINE_NUMBER]}|{data[BATCH NUMBER]}|{data[CARTON PACK_ID]})rr rr r*r+r,rM)rPT1PT2PURCHASE_ORD_NUMBERTOTAL_QUANTITY_RECzs{data[RECORD_INDICATOR]}|{data[PURCHASE_ORD_NUMBER]}|{data[LINE_NUMBER]}|{data[PRODUCT]}|{data[TOTAL_QUANTITY_REC]})rrPr+r rQ)rTPACKNOWLEDGEMENT_FLAGz;{data[CONST]}|{data[ORDER_NO]}|{data[ACKNOWLEDGEMENT_FLAG]})r?rFrS)rMO)rORPCrHPTrRrT)nanCD_file_formatrZrZ4/var/www/FlaskApp/FlaskApp/app/file_format_aemery.pys