[% concat( '

', ' ', ' User zuletzt bearbeitet', ' ', '

', ' ', "user_bearbeitet", ' ', '

', '

' ) %] [% concat( '

', ' ', ' Datum zuletzt bearbeitet', ' ', '

', ' ', format_date( "datum_bearbeitet", 'dd.MM.yy HH:mm:ss' ), ' ', '

', '

' ) %] [% concat( '

', ' ', ' Name', ' ', '

', ' ', "geometrie_name", ' ', '

', '

' ) %]

[% concat( '

', ' ', ' Name', ' ', '

', ' ', "a_name", ' ', '

', '

' ) %]

Betriebsart

[% concat( '

', ' ', ' mit Bedienung', ' ', '

', ' ', CASE WHEN "a_mit_bedienung" IS NOT NULL OR trim("a_mit_bedienung") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Selbstbedienung', ' ', '

', ' ', CASE WHEN "a_selbstbedienung" IS NOT NULL OR trim("a_selbstbedienung") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Automat', ' ', '

', ' ', CASE WHEN "a_automat" IS NOT NULL OR trim("a_automat") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

Ursprung Produkte

[% concat( '

', ' ', ' eigene Produktion', ' ', '

', ' ', CASE WHEN "a_eigene_produktion" IS NOT NULL OR trim("a_eigene_produktion") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Produkte aus der Region', ' ', '

', ' ', CASE WHEN "a_produkte_aus_der_region" IS NOT NULL OR trim("a_produkte_aus_der_region") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

[% concat( '

', ' ', ' Obst und Gemüse', ' ', '

', ' ', CASE WHEN "b_obst_und_gemuese" IS NOT NULL OR trim("b_obst_und_gemuese") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Eier', ' ', '

', ' ', CASE WHEN "b_eier" IS NOT NULL OR trim("b_eier") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Milchprodukte', ' ', '

', ' ', CASE WHEN "b_milchprodukte" IS NOT NULL OR trim("b_milchprodukte") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Fleisch', ' ', '

', ' ', CASE WHEN "b_fleisch" IS NOT NULL OR trim("b_fleisch") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Brot und Backwaren', ' ', '

', ' ', CASE WHEN "b_brot_und_backwaren" IS NOT NULL OR trim("b_brot_und_backwaren") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Honig', ' ', '

', ' ', CASE WHEN "b_honig" IS NOT NULL OR trim("b_honig") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Getränke', ' ', '

', ' ', CASE WHEN "b_getraenke" IS NOT NULL OR trim("b_getraenke") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' weitere Produkte', ' ', '

', ' ', "b_weitere_produkte", ' ', '

', '

' ) %]

Bezahloptionen

[% concat( '

', ' ', ' bar', ' ', '

', ' ', CASE WHEN "c_bar" IS NOT NULL OR trim("c_bar") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Twint', ' ', '

', ' ', CASE WHEN "c_twint" IS NOT NULL OR trim("c_twint") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %] [% concat( '

', ' ', ' Karte', ' ', '

', ' ', CASE WHEN "c_karte" IS NOT NULL OR trim("c_karte") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

[% concat( '

', ' ', ' Preise', ' ', '

', ' ', map_get( hstore_to_map('"1"=>"-","2"=>"Sehr teuer","3"=>"Teuer","4"=>"Normal","5"=>"Günstig","6"=>"Sehr günstig"'), replace("c_preise", '\'', '’') ), ' ', '

', '

' ) %]

[% concat( '

', ' ', ' Öffnungszeiten', ' ', '

', ' ', map_get( hstore_to_map('"7"=>"-","8"=>"Immer offen (Selbstbedienung)","9"=>"Geregelte Öffnungszeiten"'), replace("d_oeffnungszeiten", '\'', '’') ), ' ', '

', '

' ) %]

Geregelte Öffnungszeiten

[% concat( '

', ' ', ' wochentags', ' ', '

', ' ', CASE WHEN "d_wochentags" IS NOT NULL OR trim("d_wochentags") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

Wochentags

[% concat( '

', ' ', ' wochentags ab', ' ', '

', ' ', format_date( "d_wochentags_ab", 'HH:mm' ), ' ', '

', '

' ) %] [% concat( '

', ' ', ' wochentags bis', ' ', '

', ' ', format_date( "d_wochentags_bis", 'HH:mm' ), ' ', '

', '

' ) %]

[% concat( '

', ' ', ' samstags', ' ', '

', ' ', CASE WHEN "d_samstags" IS NOT NULL OR trim("d_samstags") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

Samstags

[% concat( '

', ' ', ' samstags ab', ' ', '

', ' ', format_date( "d_samstags_ab", 'HH:mm' ), ' ', '

', '

' ) %] [% concat( '

', ' ', ' samstags bis', ' ', '

', ' ', format_date( "d_samstags_bis", 'HH:mm' ), ' ', '

', '

' ) %]

[% concat( '

', ' ', ' sonn- und feiertags', ' ', '

', ' ', CASE WHEN "d_sonn_und_feiertags" IS NOT NULL OR trim("d_sonn_und_feiertags") != '' THEN concat('' ) ELSE '' END, ' ', '

', '

' ) %]

Sonntags

[% concat( '

', ' ', ' sonn- und feiertags ab', ' ', '

', ' ', format_date( "d_sonn_und_feiertags_ab", 'HH:mm' ), ' ', '

', '

' ) %] [% concat( '

', ' ', ' sonn- und feiertags bis', ' ', '

', ' ', format_date( "d_sonn_und_feiertags_bis", 'HH:mm' ), ' ', '

', '

' ) %]

[% concat( '

', ' ', ' Bewertung', ' ', '

', ' ', map_get( hstore_to_map('"10"=>"-","11"=>"★","12"=>"★★","13"=>"★★★","14"=>"★★★★","15"=>"★★★★★"'), replace("e_bewertung", '\'', '’') ), ' ', '

', '

' ) %] [% concat( '

', ' ', ' Kommentar', ' ', '

', ' ', "e_kommentar", ' ', '

', '

' ) %]