export / export_prices_tre_new

#Connections
Source_Config: enhanceEngine #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: 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 = 3 AND (iwm_articles_prices.verkaufshaus = 97 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: 'tre'
  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
# price_EK:
#  Source: iwm_articles_prices.abholpreis
#  File_Field_Adapter:
#    File: export_iwm_articles_prices_tre.price_EK
# pseudoprice_EK:
#   Source: iwm_articles_prices.pseudoprice
#   Field_Adapter:
#     - replace: ['.', ',']
#   File_Field_Adapter:
#     File: export_iwm_articles_prices_tre.pseudoprice_EK
# baseprice_EK: (0)
# shippingcosts:
#   Source: iwm_articles_prices.abholpreis
#   File_Field_Adapter:
#     File: export_iwm_articles_prices_tre.shippingcosts
# montage: ()




#Target
Datapool: export_iwm_articles_prices_tre #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_tre_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'