# Configuration for the plugin "p123app_pi1" plugin.tx_p123app_pi1 { doNotCheckReferer = 1 hashFields = sid,key,date sql { fields = *,LPAD(Paechter,4,'0') AS Paechter,LPAD(OrtNr,8,'0') AS OrtNr defaultSort = Ortname ASC defaultSort.if.isTrue.data = GP:tx_p123search_pi3|filter } prices { professionalPoster = 273.10924369747899159663865546218 } disablePeriods = 0 city.displayFields { id.field = OrtNr id.intval = 1 name { setCurrent.field = PLZ setCurrent.trim = 1 field = Ortname trim = 1 noTrimWrap = | || dataWrap = {current:1}| } lat.field = UTMBA lng.field = UTMLA } date.displayFields { year.field = GJ year.intval = 1 num.field = ZR num.stdWrap.wrap = 00| num.substring = -2,2 days.field = Tage days.intval = 1 start.field = Beginn end.field = Ende deadline.field = bookable } locs.displayFields { id.field = StoID image { cObject = IMG_RESOURCE cObject { file.import { field = Paechter if.isTrue.field = FotoName intval = 1 dataWrap = fileadmin/photos/{field:OrtNr}/|/{field:FotoName}.jpg } #file.height = 360 #file.minW = 392 } required = 1 dataWrap = {TSFE:absRefPrefix // TSFE:baseUrl}| } city { setCurrent.field = PLZ setCurrent.trim = 1 field = Ortname trim = 1 noTrimWrap = | || dataWrap = {current:1}| } address.field = Standort address.trim = 1 price { field = Preis stdWrap.wrap = |* 100 prioriCalc = intval } pps.field = PpS pps.intval = 1 rating { field = Bewertung stdWrap.stdWrap.wrap = |*2 stdWrap.prioriCalc = 1 stdWrap.numberFormat { decimals = 0 dec_point = thousands_sep = } stdWrap.wrap = |/2 prioriCalc = 1 numberFormat = 1 numberFormat { decimals = 1 dec_point = - thousands_sep = } substring = -3,3 } net { override = 1 override.if.value = RN override.if.isInList.field = Typ intval = 1 } } map.sql.fields = StoID,Belegung,Typ,UTMBA,UTMLA,Textfeld map.displayFields { id.field = StoID block.field = Belegung type.field = Typ lat.field = UTMBA lng.field = UTMLA textfeld.field = Textfeld } single.displayFields { id.field = StoID num.field = StoNr area.field = StoV area.intval = 1 city { setCurrent.field = PLZ setCurrent.trim = 1 field = Ortname trim = 1 noTrimWrap = | || dataWrap = {current:1}| } address.field = Standort address.trim = 1 image { cObject = IMG_RESOURCE cObject { file.import { field = Paechter if.isTrue.field = FotoName intval = 1 dataWrap = fileadmin/photos/{field:OrtNr}/|/{field:FotoName}.jpg } } required = 1 dataWrap = {TSFE:absRefPrefix // TSFE:baseUrl}| } light.cObject = CASE light.cObject { B = TEXT B { lang.en = lighted lang.de = beleuchtet } H = TEXT H { lang.en = back lighted lang.de = hinterleuchtet } default = TEXT default { lang.en = unlighted lang.de = unbeleuchtet } key.field = Beleuchtung key.ifEmpty = U key.trim = 1 key.case = upper } price { field = Preis stdWrap.wrap = |* 100 prioriCalc = intval } type.field = Anschlagart type.trim = 1 poster { override.field = poster override.if { value = ZZ equals.field = Typ negate = 1 } } pps.field = PpS pps.intval = 1 rating { field = Bewertung stdWrap.stdWrap.wrap = |*2 stdWrap.prioriCalc = intval stdWrap.wrap = |/2 prioriCalc = 1 numberFormat = 1 numberFormat { decimals = 1 dec_point = - thousands_sep = } substring = -3,3 } market = array market { if.isTrue.field = VMNr if.isTrue.intval = 1 name.field = VMName number.field = VMNr number.intval = 1 chain.field = VMKette } net { override = 1 override.if.value = RN override.if.isInList.field = Typ intval = 1 } } singleDates.displayFields { year { field = GJ override = 0.0 override.if { value.field = remap // ZR value.intval = 1 value.wrap = {field:ZR|} value.insertData = 1 equals = -1 } intval = 1 } num.field = ZR num.stdWrap.wrap = 00| num.substring = -2,2 days.field = Tage days.override = 0.0 days.override.if { value.field = remap // ZR value.intval = 1 value.wrap = {field:ZR|} value.insertData = 1 equals = -1 } days.intval = 1 start.field = Beginn price { field = Preis override { setCurrent { field = ZR intval = 1 wrap = {field:PZR|} insertData = 1 } current = 1 if.value.current = 1 if.equals = 0.00 if.negate = 1 } stdWrap.override = 0.0 stdWrap.override.if { value.field = remap // ZR value.intval = 1 value.wrap = {field:ZR|} value.insertData = 1 equals = -1 } stdWrap.dataWrap = |* 100 * {field:BTage} prioriCalc = intval } disabled = 0 disabled { override = 1 override.if { value.field = remap // ZR value.intval = 1 value.wrap = {field:ZR|} value.insertData = 1 equals = -1 } intval = 1 } } block { defaultBlockOnlyDecade = 1 } block.displayFields { block.setCurrent { field = Belegung stdWrap.substring = 1, stdWrap.substring.if { value.field = Belegung value.case = upper value.substring = 0,1 equals = D } } block.current = 1 block.trim = 1 } coupons.displayFields { name.field = position price = 0 price.override.field = price price.override.if.value = var price.override.if.equals.field = coupon price.override.if.negate = 1 price.stdWrap.wrap = |*100 price.prioriCalc = intval percentage < .price percentage.override.if.negate > percentage.stdWrap.wrap > match { setCurrent.field = extension setCurrent.override.cObject = COA setCurrent.override.cObject { 10 = TEXT 10.value = p123search__ 10.if.value = p123search* 10.if.equals.field = extension 20 = TEXT 20.value = p123designer__ 20.if.value = p123designer* 20.if.equals.field = extension } cObject = CASE cObject { p123search = TEXT p123search.value = locations p123search__ = TEXT p123search__.value = locations p123designer = TEXT p123designer.value = print p123designer__ = TEXT p123designer__.value = print p123manualpos = TEXT p123manualpos.value = extras key.current = 1 stdWrap.required = 1 stdWrap.append = CASE stdWrap.append { if.isTrue.field = group # Plakatwerbung 3560x2520 = TEXT 3560x2520.value = posters 5260x3720 = TEXT 5260x3720.value = GFSP 1024x768 = TEXT 1024x768.value = 1189x2520 = TEXT 1189x2520.value = GZST 3540x2470 = TEXT 3540x2470.value = GVST 7120x2520 = TEXT 7120x2520.value = GF2ST # Format instead of Name default = TEXT default.field = group key.field = group stdWrap.wrap = :| } } ifEmpty = all } } allDecadesWeeks { sql.years { select = DISTINCT GJ from = 123_ZR where = (Belegung LIKE 'D A' OR Belegung = 'W02') AND IF({$plugin.tx_p123_pi.enableExpress} AND {$plugin.tx_p123_pi.firstPeriodExpress} > 1,Ende>NOW() + INTERVAL {$plugin.tx_p123_pi.firstPeriodExpress} DAY,Beginn>NOW() + INTERVAL {$plugin.tx_p123_pi.firstPeriod} DAY) order = GJ DESC } sql.decades { select = t1.ZR AS decade,CONCAT('{"a":{"begin":"',UNIX_TIMESTAMP(t1.Beginn),'","days":"',Tage,'"}',(SELECT CONCAT(',"b":{"begin":"',UNIX_TIMESTAMP(t3.Beginn),'","days":"',t3.Tage,'"}') FROM 123_ZR t3 WHERE t1.GJ=t3.GJ AND t1.ZR=t3.ZR AND Belegung='D B' LIMIT 1),(SELECT CONCAT(',"c":{"begin":"',UNIX_TIMESTAMP(t4.Beginn),'","days":"',t4.Tage,'"}') FROM 123_ZR t4 WHERE t1.GJ=t4.GJ AND t1.ZR=t4.ZR AND Belegung='D C' LIMIT 1),'}') AS _array,(SELECT t2.ZR FROM 123_ZR t2 WHERE t1.GJ=t2.GJ AND t1.ReferenzDekade>=t2.ReferenzDekade AND Belegung LIKE 'M%' ORDER BY t2.ReferenzDekade DESC LIMIT 1) - 1 AS month from = 123_ZR t1 where = Belegung LIKE 'D A' } sql.weeks { select = ZR as week,UNIX_TIMESTAMP(Beginn) AS begin,(SELECT t2.ZR FROM 123_ZR t2 WHERE t1.GJ=t2.GJ AND t1.ReferenzDekade>=t2.ReferenzDekade AND Belegung LIKE 'M%' ORDER BY t2.ReferenzDekade DESC LIMIT 1) - 1 AS month from = 123_ZR t1 where = Belegung LIKE 'W02' } } login.displayFields { title.field = title firstname.field = first_name lastname.field = name company.field = company address.field = address zip.field = zip city.field = city country.field = country telephone.field = telephone fax.field = fax email.field = email } } # Display Distance in radius search [globalVar = GP:perimeter > 0] plugin.tx_p123app_pi1 { locs.displayFields.distance.cObject = CASE locs.displayFields.distance.cObject { meter = TEXT meter { field = Distance stdWrap.wrap = |* 1000 prioriCalc = intval wrap = |m } default = TEXT default { field = Distance numberFormat.decimals = 1 numberFormat.dec_point = , numberFormat.thousands_sep = . wrap = |km } key = meter key.if.value = 1 key.if.isLessThan.field = Distance } } [global]