export / export_quick_delivery_tre

#Connections
Source_Config: exportEngine
Target_Config: exportEngine

#Source
Source_Datapool: export_iwm_tracking_tre

Joins:
  - Left_Join:
    Datapool: export_iwm_orders_tre
    Join_Condition: export_iwm_tracking_tre.auftragsnummer = export_iwm_orders_tre.Auftragsnummer
  - Join:
    Datapool: mail_addresses_all
    Join_Condition: export_iwm_orders_tre.Kundennummer = mail_addresses_all.Kundennummer



Read_Condition_Vars:
  - date = date("d.m.Y", strtotime('-0 days'))

Read_Conditions:
  - export_iwm_tracking_tre.verkaufshaus = 97
  - export_iwm_tracking_tre.versanddatum = %date%


Mapping_Vars:
  shop: 'tre'

Mapping:
  Include_Mapping_quick_delivery: quick_delivery



Filters:
 - Filter:
    name: Delivery not within 3 days
    condition:
      Cross_Dataset_Filter_Adapter: export_orders_quick_delivery__filterSlowDelivery
    reason: 'Delivery not within 3 days'
 - Filter:
     name: DuplicateIdentifierBestellnummer  #there must always be a space between the key and the comparision operator and between the parentheses
     condition:
       Cross_Dataset_Filter_Adapter: filterByDuplicateIdentifierBestellnummer
     reason: 'There is another dataset'
 - Filter:
     name: 'Name empty'
     condition: (Name == '')
     reason: 'Name empty'
# - Filter:
#     name: 'Bestelldatum empty'
#     condition: (Bestelldatum == '')
#     reason: 'Bestelldatum empty'

#Target
Datapool: 'export_orders_quick_delivery_tre'
Primary_Key: [Bestellnummer]



#  Bestelljahr:
#    Source: export_iwm_tracking_tre.ordernumber
#    Cross_Field_Adapters:
#      - Cross_Field_Adapter:
#        Config: exportEngine
#        Cross_Datapool: export_iwm_orders_tre #name of cross datapool
#        Cross_Field: Bestelljahr #field to select value from in cross datapool
#        Mapping: #cross field adapter with more than one key
#          ordernumber: Auftragsnummer
#  Bestellmonat:
#    Source: export_iwm_tracking_tre.ordernumber
#    Cross_Field_Adapters:
#      - Cross_Field_Adapter:
#        Config: exportEngine
#        Cross_Datapool: export_iwm_orders_tre #name of cross datapool
#        Cross_Field: Bestellmonat #field to select value from in cross datapool
#        Mapping: #cross field adapter with more than one key
#          ordernumber: Auftragsnummer
#  Bestelltag:
#    Source: export_iwm_tracking_tre.ordernumber
#    Cross_Field_Adapters:
#      - Cross_Field_Adapter:
#        Config: exportEngine
#        Cross_Datapool: export_iwm_orders_tre #name of cross datapool
#        Cross_Field: Bestelltag #field to select value from in cross datapool
#        Mapping: #cross field adapter with more than one key
#          ordernumber: Auftragsnummer