export / export_prices_oms_new_neuanlagen_delta

#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: iwm_articles_prices  #sql from

Joins:
  - Join:
    Datapool: iwm_articles_new
    Join_Condition: iwm_articles_new.attr1 = iwm_articles_prices.firma AND iwm_articles_new.ordernumber = iwm_articles_prices.ordernumber


Read_Condition_Vars:
  - date = date("Y-m-dTh:m", strtotime('-2 day'))


Read_Conditions:  #sql where - Read-Filter
  - (iwm_articles_prices.firma = 3 or iwm_articles_prices.firma = 1) AND (iwm_articles_prices.verkaufshaus = 86 or iwm_articles_prices.verkaufshaus = 87 or iwm_articles_prices.verkaufshaus = 0) and iwm_articles_new.added >= CURDATE() - INTERVAL 10 DAY
  - iwm_articles_prices.last_update_timestamp >= %date%


#Assures that e.g. verkaufshaus 96 has higher priority than verkaufshaus 0. If both exist for an ordernumber, verkaufshaus 0 is filtered by File_Field_Adapter price_EK
Order_By: firma ASC, verkaufshaus DESC

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 firma:
   Source: iwm_articles_prices.firma
 hwg:
   Source: iwm_articles_prices.hwg
   In_Export: no
 supplier:
   Source: iwm_articles_new.supplier_ost
   Cross_Field_Adapter:
     Config: enhanceEngine
     Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
     Cross_Field: supplier_ost #field to select value from in cross datapool
     Local_Key: ordernumber #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
 lieferant:
   Source: iwm_articles_prices.lieferant
   Cross_Field_Adapter:
     Config: unitizeEngine
     Cross_Datapool: iwm_articles_new #name of cross datapool
     Cross_Field: suppliernumber_original #field to select value from in cross datapool
     Local_Key: ordernumber #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
   In_Export: no
 abholpreis:
   Source: iwm_articles_prices.abholpreis
   In_Export: no
 lieferpreis:
   Source: iwm_articles_prices.lieferpreis
   In_Export: no
 vollservicepreis:
   Source: iwm_articles_prices.vollservicepreis
   In_Export: no
 etikettenart:
   Source: iwm_articles_prices.etikettenart
   In_Export: no
 ordernumber:
   Source: iwm_articles_prices.ordernumber
 mainnumber:
  Source: iwm_articles_prices.mainnumber
  File_Field_Adapter:
    File: export_iwm_articles_prices_oms_neuanlagen.mainnumber
 attr13:
   Source: iwm_articles_prices.ordernumber
   Cross_Field_Adapter:
     Config: unitizeEngine
     Engine: unitizeEngine
     Cross_Datapool: iwm_articles_new #name of cross datapool
     Cross_Field: attr13 #field to select value from in cross datapool
     Local_Key: ordernumber #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
   File_Field_Adapter:
     File: export_iwm_articles_prices_oms_neuanlagen.attr13
 firma: iwm_articles_prices.firma
 price_EK:
  Source: iwm_articles_prices.abholpreis
  File_Field_Adapter:
    File: export_iwm_articles_prices.price_EK
 pseudoprice_EK:
   Source: iwm_articles_prices.pseudoprice
   File_Field_Adapter:
     File: export_iwm_articles_prices_oms_neuanlagen.pseudoprice_EK
   Field_Adapter:
     - replace: ['.', ',']
 baseprice_EK: (0)
 shippingcosts:
   Source: iwm_articles_prices.abholpreis
   File_Field_Adapter:
     File: export_iwm_articles_prices_oms_neuanlagen.shippingcosts
 attr18:
   Source: iwm_articles_prices.attr18
   File_Field_Adapter:
     File: export_iwm_articles_prices_oms_neuanlagen.attr18
   In_Export: no
# montage:
#   Source: iwm_articles_prices.montage
#   File_Field_Adapter:
#     File: export_iwm_articles_prices_oms_neuanlagen.montage

#Target
Datapool: export_iwm_articles_prices_delta #sql table
Primary_Key: [ordernumber, firma]


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Verkaufshaus  #there must always be a space between the key and the comparision operator and between the parentheses
    condition:
      Cross_Dataset_Filter_Adapter: export_prices_oms_new__filterByVerkaufshaus
    reason: 'There is a price with a verkaufshaus with higher priority'
 - Filter:
    name: 'Preis ungueltig'
    condition: (price_EK == '0') or (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0'