export / export_prices_ost_new

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

#Keys
Primary_Key_Filtered: [ordernumber, verkaufshaus]

#Source
Source_Datapool: iwm_articles_prices  #sql from

Joins:
  - Join:
    Datapool: articles_new
    Join_Condition: articles_new.attr1 = iwm_articles_prices.firma AND 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 = 1 AND (iwm_articles_prices.verkaufshaus = 96 or iwm_articles_prices.verkaufshaus = 0)
 # - 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: verkaufshaus DESC

Mapping_Vars:
  shop: 'ost'
  test: ''

Mapping:
  Include_Mapping_export_articles: prices


#Mapping -> Mappings source fields are detected by Mapping
#Mapping:
# firma:
#   Source: iwm_articles_prices.firma
#   In_Export: no
# hwg:
#   Source: iwm_articles_prices.hwg
#   In_Export: no
# supplier:
#   Source: articles_new.supplier_ost
#   In_Export: no
# attr55:
#   Source: articles_new.attr55
#   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
# verkaufshaus:
#   Source: iwm_articles_prices.verkaufshaus
# attr13:
#   Source: iwm_articles_prices.ordernumber
#   Cross_Field_Adapter:
#     Config: enhanceEngine
#     Engine: enhanceEngine
#     Cross_Datapool: 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
# price_EK:
#  Source: iwm_articles_prices.abholpreis
#  File_Field_Adapter:
#    File: export_iwm_articles_prices_ost.price_EK
# pseudoprice_EK:
#  Source: iwm_articles_prices.pseudoprice
#  Field_Adapter:
#    - replace: ['.', ',']
#  File_Field_Adapter:
#    File: export_iwm_articles_prices_ost.pseudoprice_EK
# baseprice_EK: (0)
# shippingcosts:
#   Source: iwm_articles_prices.abholpreis
#   File_Field_Adapter:
#     File: export_iwm_articles_prices_ost.shippingcosts
# attr18:
#   Source: iwm_articles_prices.attr18
#   In_Export: no
# montage:
#   Source: iwm_articles_prices.montage
#   File_Field_Adapter:
#     File: export_iwm_articles_prices_ost.montage

#Target
Datapool: export_iwm_articles_prices_ost #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_ost_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'