export / export_articles_plenty-tre

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

#Source
#Source_Fields: [ordernumber, mainnumber, name_oms, tax, price_oms, pseudoprice_oms, baseprice, active_oms, description, description_long_oms, unitID, ean, categories, referenceUnit, purchaseUnit] #sql select
Source_Datapool: articles  #sql from

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join:
  Datapool: iwm_properties
  Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma

Read_Conditions:  #sql where - Read-Filter
  - articles.attr1 = 1 AND articles.active_tre = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
	 ordernumber: articles.ordernumber
	 mainnumber:
	  Source: articles.mainnumber
	  Field_Adapter:
	    - replace: ['-1', '']
	 name_ost:
	  Source: articles.name_ost
	  Field_Adapter:
	    - addslashes
	 name_tre:
	  Source: articles.name_tre
	  Field_Adapter:
	    - addslashes
	 name_oms:
	  Source: articles.name_oms
	  Field_Adapter:
	    - addslashes
	 name_bil:
	  Source: articles.name_bil
	  Field_Adapter:
	    - addslashes
	 supplier_ost:
	  Source: articles.name_bil
	  Field_Adapter:
	    - addslashes
	 supplier_tre:
	  Source: articles.name_bil
	  Field_Adapter:
	    - addslashes
	 supplier_oms:
	  Source: articles.name_bil
	  Field_Adapter:
	    - addslashes
	 supplier_bil:
	  Source: articles.name_bil
	  Field_Adapter:
	    - addslashes
	 tax: articles.tax
	 kind: articles.kind
	 price_ost: articles.price_ost
	 price_tre: articles.price_tre
	 price_oms: articles.price_oms
	 price_bil: articles.price_bil
	 pseudoprice_ost: articles.pseudoprice_ost
	 pseudoprice_tre: articles.pseudoprice_tre
	 pseudoprice_oms: articles.pseudoprice_oms
	 pseudoprice_bil: articles.pseudoprice_bil
	 active_ost: articles.active_ost
	 active_tre: articles.active_tre
	 active_oms: articles.active_oms
	 active_bil: articles.active_bil
	 categoryPath_ost:
	  Source: articles.categoryPath_ost
	  Field_Adapter:
	    - addslashes
	 categoryPath_tre:
	  Source: articles.categoryPath_tre
	  Field_Adapter:
	    - addslashes
	 categoryPath_oms:
	  Source: articles.categoryPath_oms
	  Field_Adapter:
	    - addslashes
	 categoryPath_bil:
	  Source: articles.categoryPath_bil
	  Field_Adapter:
	    - addslashes
	 configuratorOptions: articles.configuratorOptions
	 description_long_ost:
	  Source: articles.description_long_ost
	  Field_Adapter:
	    - addslashes
	 description_long_tre:
	  Source: articles.description_long_tre
	  Field_Adapter:
	    - addslashes
	 description_long_oms:
	  Source: articles.description_long_oms
	  Field_Adapter:
	    - addslashes
	 description_long_bil:
	  Source: articles.description_long_bil
	  Field_Adapter:
	    - addslashes
	 attr1: articles.attr1
	 attr2: articles.attr2
	 attr3: articles.attr3
	 attr4: articles.attr4
	 attr5: articles.attr5
	 attr6: articles.attr6
	 attr7: articles.attr7
	 attr8: articles.attr8
	 attr9: articles.attr9
	 attr10: articles.attr10
	 attr11: articles.attr11
	 attr12: articles.attr12
	 attr13: articles.attr13
	 attr14: articles.attr14
	 attr15: articles.attr15
	 attr16: articles.attr16
	 attr17: articles.attr17
	 attr18: articles.attr18
	 attr19: articles.attr19
	 attr20: articles.attr20
	 swag_attr21: articles.swag_attr21
	 swag_attr22: articles.swag_attr22
	  Source: articles.swag_attr22
	  Field_Adapter:
	    - addslashes
	 swag_attr23: articles.swag_attr23
	 swag_attr24: articles.swag_attr24
	 swag_attr25: articles.swag_attr25
	 swag_attr26: articles.swag_attr26
	 swag_attr27: articles.swag_attr27
	 swag_attr28: articles.swag_attr28
	 swag_attr29: articles.swag_attr29
	 swag_attr30: articles.swag_attr30
	 ean: articles.ean
	 imageUrl: articles.imageUrl
	 stock_witten: iwm_articles_stocks.witten
	 propertyValueName:
	  Cross_Field_Adapter: #cross field adapter leads to sub select -> iwm_properties is not in join
	  Cross_Datapool: iwm_properties
	  Cross_Field: propertyValueName
	  Cross_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma #not needed for refereced tables
	  Field_Adapter:
	    - replace: ['|',':de;']
	 weight:
	  Source: articles.weight
	  Field_Adapter:
	    - replace: ['.00', '']
        - replace: [',', '']
        - simple_division: 1000
	 listingID: articles.listingID
	  Source: articles.ordernumber
	  Field_Adapter:
	    - replace: ['-', '00']
	 ebay_active: (1)
	 plenty_cat_id:
	  Source: (0)
	  File_Field_Adapter:
	    Datapool: plenty_cat_ids #The data of this datapool is injected in the function to have access via stmt
	    Fields: [plenty_cat_id, Level1, Level2]



#Target
Target_Datapool: export_articles_plenty_tre #sql table


Filters:
 - Filter:
  name: filter_plenty_tre_suppliers
  condition: supplier_tre = PAIDI or supplier_tre = weber or supplier_tre = vito or supplier_tre = MONDO or supplier_tre = VALMONDO or supplier_tre = LIV´IN or supplier_tre = SELF or supplier_tre = KETTLER or supplier_tre = hülsta or supplier_tre = Kollektion-Wiedemann or supplier_tre = ROLF BENZ
  output: positive
  reason: 'excluded supplier'
 - Filter:
  name: filter_plenty_oms_kalkulation
  condition: LBKALK < 60
  output: positive
  reason: 'bad calculation'
 - Filter:
  name: filter_plenty_oms_kalkulation
  condition: LBKALK < 60
  output: positive
  reason: 'bad calculation'
 - Filter:
    name: 'Preis ungueltig'
    condition: (price_tre == '0') or (price_tre == '') or (price_tre == '0.00')  or (price_tre == '0,00')  or (price_tre == '0,0')
    reason: 'alle Preise = 0'