¦
 £Oµ
€  8µ
 Oô·
€   ¸
 ð±jÇžj–Ïo| mç¹lAbN	bI	b;j	`l?g@fI—1{*byw=}k%s¿ÿrFr¤åq¨êwPwÒ–vâ§Kœä JŠó!HÙ¢#B—æ)D‰þ/[_70XY23_u4^5Q B:PÑ²;V$A=+,4@+Ž–@.E-š„F,ÉÖG!ËÙJ& M&¥°M&íøM9¢¨R3¶¶X2ihY6âç]6üù]Dþÿÿ:4ƒ„_mU`
?a
¢›a	7b	Z`b_dcÜáeMrg¯ŸhYhirEo³˜scOtzZx&y¤…yµ”yˆ«{éÈ‚é*ð‚îSŽ…ìeº‡ãc³ˆâE”‰ç5áŒæe°å²dŽä–Aúg®‘øWœ“ø.å“ÿz¶”þ]•÷1õœõKžË.Ö Ê•l¡ÊZ£¡Éé¢É÷¢È‹p£Ïx„¤ÌqŽ§Ã‘a¨ÃY©¨Âmœ©ÁÀ2ªÁ|ŽªÁþªÅà®Ûß7°Újƒ±Þ’µÓõ¸Óƒc¸Òq¹ÒY¸¹Ðn»×?Û¼Ö—r½ÕÊ,¾`–À¾ªìuÁ¨‹Ã¨XÃÃ¦ôaÍ¦‘Í»–Ð¿!­Ô½¸6Ö³˜Ø·íiÜ¶ÐUÝ´LËß‹®àŠâ[áŽºå©æ€äWë™ÄnòŸ¶ô  »
 rÀÛ˜¨ÛOgÑ¹˜ ýñ ÌÅ
 àÅ
 ôÅ
€ Æ
Ðßð$~LQ4Æ
€œÆ
€xŽ`àþ
 9RNKôþ
 ¢p7HÜA’1Ë¶XÝñ,ÿ
 ÿ
 0ÿ
 Dÿ
€m·ÚmaË@t„ÿ
 ˜ÿ
 >bÈ!IÜ<¬ÿ
 Àÿ
 &tW&ÇÔ<š%(òÚ  Ôÿ
 òÆ-R+>¶#[aÊ®q™Â´´    ðÌ›{I  `ý”¸l×”‹AÈ\C‚ƒSØ` €  Œ  ñ	Ü €´€ &"?ZþOÏDrÖØ”¶ó8  0 D€p€Õ™Æ*ÔzÔ° Ä ÅóÏ±½€ÌØ ì ÆÂ
 ³Ö‚Zxk÷2Ë1     €þð!d€tV&tg{Çí ¤ k¡0y¸ âîEkÞ%sÌ à ØÞ^Hˆ$ ,ÿ  ô òsD0 Ì€L ÜÞq(­…(a-=©Ñ  D À”€÷Á)ÍÆ+àôó®«#Zv ‰\é¬©m¢k½ “¯ôÀ Ô è€  È ô	©9h10
71`‘³©8•­6Š±\ß.Ü  ,	 óO-+Z‡‹+ÍO‰n„]ltNÙÒ  ¤	 ðkjúñÐ
 
 ˆÈMÿVØ›0
 D
 >8\ˆYÌ³©QðEAX
   l
€,ÿÿÿÿÿÿÿÿÿÿÿ3 =9  FB @F“•ÄÂ‹Œ%%DD>?jkíìÙÛ03•–•™	OB		š—		ÝÐ	

"-•šºµéæU]wÌÅ$.†Œ29¨£ÙÒÀÔ™Œ‰œÅÐÙÉas“ÏÝéúa|ÏÒ)7É×¦¹?'[BØÁri Üø !/
!!mH!!\y!!¨!!—²!!öÓ!!Ðõ!"¤‚""æÀ"#cD##Âå#$qQ$%0%%¯Ž%%Ëê%&0&&4&&]&&ªˆ&&ßý&'lO''[x''Êé'(ùÕ((ôØ()ùÔ))Àí)*. **&**1**Ek**Q*+	&+,ÿ×,,ñÙ,-;--Éà--Çî-.hB..äÎ./2//¤//êÁ//õÞ/1!11
?11k^11ƒ¶12%23'34*44sC44Òâ44Ãó45Òã55Õä56966Ug66´†66µ‡66¬ž67=77¯œ77÷Ä78 88wK88êÖ89)99{F9:±::Ïñ:;(;;!;;3;;@;<'<<¹<<Íõ<>Jp>>º€>>”®>>€º>>×í>?>??7??¨“?@J@@é­@BÁ‡BB–ÐBB¬êBCŠÍCC¡æCD]DD3sDDªêDEd%EFAFF/mFGRGGð³GGÌGHþ²HHÜHI^IIo"IIí IJm#JK0KK)fKK²ýKLf.LLPLMYMM1xMNn$NNö¼NN”ÞNNµÿNO,gOO‹ÀOO´ÿOPp$PP'sPPþªPRn8RRÒ„RRÎ˜RRû­RRæ°RSk<SSNSS6aSS´ãST	YTTŠÚTT­ýTUVUUc2UUì½UUï¾UU„ÕUU»êUVCVVNVV9kVVì¾VV‚ÐVV°âVWx+WYÖ‹YYÄ™YYµèYZJZZ]Z[_ [[ý¢[[é¶[[ˆ×[\V\\u-\\c;\\F\\K\\È\\æ¾\]9`]^Äž^^õ¯^^–Ì^_g<__7l__Óˆ_`4P``Å¡`a}aa EaaÿšaaÈ­aaªÏaa·ÒabD"bcÏ¨cc•òcd-MddÿŸdd«Ëdemef˜úfg)JghvhhP<hhnhiL!ij¨Æjkukk0_kk×¸klnllqll­ÅlmummÌ¥mn{nnsnn²Ønn÷no~ooý–op–âpqpqq<Iqq¶Ãqrv rrmrrV rrursÐ§ssß¨ss“äst4DttàtuT%uuø‰uvdvwà“wxW+xx%Yxx¹Åxx›çxy{yyú‡yyï’yy¯ÒyzB<zzqzzäšz{P/{|“ë|}d}}X!}}k}}á˜}~}~~<F~~i~~µÏ~~‚ø~È³Â¹™¢'·2ös‚<º‚‚xþ‚ƒ…ƒƒ²5ƒƒÞYƒƒòuƒ„–„„4´„… ¡…†ác†‡‡‡MÎ‡ˆ'«ˆ‰·:‰‰ûv‰‰JÇ‰‹€‹ŒžŒŒ"ªŒŒ@ÈŒ<µŽ´>ŽŽyóŽœ« HÃÌXöbãw’
ž?«sçdð‘‘‘‘$±‘‘CÖ‘’ôb’’ýk’’)¿’”áq”•¯>••ßN•–êx––4¦–—’——›——‰——ÑB——ôg——€—˜±-˜˜ÐL˜˜ué˜™[Æ™™}à™™vë™š…ššómš›ž››–	››(·›´-â{‘Ÿ´/ŸŸ–Ÿ ¼  Ž*  Ëo  Ðt  Ù}  6’  Vò ¡’7¡¡þ[¡¡(¡¡pÕ¡¡}Ø¡¡yÜ¡¡Gâ¡¡Wò¡¢©¢¢¸¢¢}Û¢¢Zü¢£ˆ/££¼£¤·¤¤óS¤¤Èh¤¥–7¥¥*‹¥¥¹¥¦»¦¦‡%¦¦Æd¦§ ƒ§§hË§§vÕ§§Bá§§Gä§¨®¨¨‹'¨¨Hä¨© ©ª,‚ªª«ª«Ž!««”;««©««¶««_ð«¬Õ}¬¬&Ž¬­¯­­’;­­ûR­­Þw­­Ö­­¬­®áK®®óY®®ô^®¯Úq¯°c×°°Eñ°²°²²Üj²²rÄ²³*³´ÿO´´Õe´µXéµ¶ ¶¶àR¶¶}Ï¶·¿··bÑ·¸ýA¸¸ùE¸¸Õi¸¸yÅ¸¸cß¸¹ ¹¹Zç¹º–(ººjÔºº^àººDúº»·»½ïV½½Æ½½gÞ½¾¸¾¾Öl¾¾;¾¿› ¿¿2‰¿¿¸¿¿Zá¿¿^å¿À§cÀÀÂÀÀËÀÀ4ðÀÁÝÁÁHÁÁÎÁÁ)ìÁÁ:ÿÁÂÒÂÂØÂÂR”ÂÂu³ÂÂ<úÂÄÑÄÅÔÅÆŠHÆÇ`£ÇÇ&åÇÇ+èÇÉö;ÉÉˆEÉÉÅÉÉ8õÉÊÒÊÊX–ÊÊQŸÊÊÐÊÊ,âÊËæ)ËËÇËÌ™QÌÌœTÌÌ’ZÌÌk£ÌÌÐÌÌ1ùÌÍÍÍÍu¼ÍÎÌÎÎø2ÎÎý7ÎÎµÎÎh¢ÎÎÂÎÎËÎÑæ3ÑÑHÑÒØÒÒ…SÒÒÈÒÒ#õÒÓ“DÓÓ¨ÓÓk¼ÓÔÏÔÔð ÔÔû+ÔÔ½mÔÔ|¬ÔÔÖÔÔ0àÔÕé8ÕÕr£ÕÕ{ªÕÖn¼Ö×Ñ××¿l××C×ØLØØ’NØÙ¬qÙÙs®ÙÙc¾ÙÚÊÚÚ|¢ÚÛ@ŸÛÝÚÝÝÌÝÝ˜AÝÝœEÝÝ\…ÝÞý'ÞÞc¹ÞÞÀÞß—Lßß¿dßàÀ$àà‰màà0Ôàà>Úàà9ÝààþàáèááòááÃ&ááÚ?áá»^áá?Úáá:ßáâöâãÛ<ãã†aããI®ãã÷ãäûääW·äåÕ4åå¿^åæçæç˜{ççŸ|çèüèèn‚èèíèéÞ3éé«FééI¤éé#Îéé;ÖéêV¸êê/ÁêêàêëªEëë.ÁëëãëìóììJ¢ìíôííýíîóîïvïï4ßïð¨\ðð{ððY­ðñöñña”ññjŸññV£ññäññìññôñòŠ|òòkòò:Ìòó¦Qóóxóó>ÉóóøóôàôôÀ0ôôi™ôôM½ôô$ÔôõÖ'õõZ«õõE´õõ)Øõö½Oöö¯]ö÷ÿ÷÷ S÷÷E¶÷÷ì÷÷ÿ÷øìøøŠvøùß"ùùªWùù˜eùùpùùaœùúëúú¬Rúú:ÄúüY¡üÿ„ÿÿ_¤ÿÿO´ÿ  ¤ 5O€  H ÿœO¸2€  ä2 ‰ÿÿzqu¡¥ÎÊGQÒÄÅÒíúIQ4.$Bf$'Àç'+&++¾•+3Âñ36)66Pf66^h6;g\;Bà¢BDò¶DHYHH^HH—ßHIÚ“IKÛKM×šMNHNRÑƒRW1fW[W[_•Ê_aÃ¢af±×fhÌ¤hiò›ik`kk‡ìklmlp<Lpw‚õwxõxy—îyz«Ñz{ñŠ{|Q-|~½Ã~€÷w€…ád…‡%¢‡‹“‹ŽÏAŽ	™SÃpà‘†‘• ••—¡6——?¨—˜ók˜˜ã{˜›ƒ›œÞBœ]Àž6¨žžlue))
		{
			$varValue = explode(',',$varValue);
		}
		
		if(empty($varValue) || count($varValue) < 1)
		{
			return '';
		}
		
		$objDatabase = \Contao\Database::getInstance();
		
		// fetch the readable values
		$strSource = 'tl_pct_customelement_tags';
		$strValueField = 'title';
		$strKeyField = 'id';
		$strSortingField = 'sorting';
		$strTranslationField = 'translations';
		if($objAttribute->get('tag_custom'))
		{
			$strSource = $objAttribute->get('tag_table');
			$strValueField = $objAttribute->get('tag_value');
			$strKeyField = $objAttribute->get('tag_key');
			$strSortingField = $objAttribute->get('tag_sorting');
			$strTranslationField = $objAttribute->get('tag_translations');
		}
		
			
		// custom orderSRC
		$arrOptions = \Contao\StringUtil::deserialize( $objAttribute->get('options') );
		if(!is_array($arrOptions))
		{
			$arrOptions = explode(',', $arrOptions);
		}
		
		if(in_array('sortable', $arrOptions) && isset($objAttribute->getActiveRecord()->{'orderSRC_'.$strField}))
		{
			$arrOrderSRC = \Contao\StringUtil::deserialize( $objAttribute->getActiveRecord()->{'orderSRC_'.$strField} );
			if(!is_array($arrOrderSRC) && !empty($arrOrderSRC))
			{
				$arrOrderSRC = explode(',', $arrOrderSRC);
			}
			
			$arrOrderSRC = array_filter($arrOrderSRC);
			
			if(!empty($arrOrderSRC))
			{
				$strSortingField = 'FIELD ('.$strKeyField.','.implode(',', $arrOrderSRC).')';
			}
		}
				
		$objResult = $objDatabase->prepare("SELECT ".$strKeyField.','.$strValueField.($strTranslationField ? ','.$strTranslationField:'')." FROM ".$strSource." WHERE ".($objAttribute->get('tag_where') ? \Contao\Controller::replaceInsertTags($objAttribute->get('tag_where')) . " AND " : "")." ".$objDatabase->findInSet($strKeyField,$varValue).($strSortingField ? " ORDER BY ".$strSortingField:"") )->execute();
		if($objResult->numRows < 1)
		{
			return '';
		}
		
		$metaWizardKey = (version_compare(VERSION,'3.2','<=') ? 'title': 'label');
		
		// translate values
		$arrValues = array();
		
		if(strlen($strTranslationField) > 0)
		{
			while($objResult->next())
			{
				$strValue = $objResult->{$strValueField};
				
				// store the translations
				if(strlen($objResult->{$strTranslationField}) > 0)
				{
					$arrTranslations = \Contao\StringUtil::deserialize($objResult->{$strTranslationField});
					if(!empty($arrTranslations) && is_array($arrTranslations))
					{
						foreach($arrTranslations as $lang => $arrTranslation)
						{
							if(!array_key_exists($metaWizardKey, $arrTranslation))
							{
								continue;
							}
							
							$strLabel = $arrTranslation[$metaWizardKey];
							if(strlen($strLabel) < 1)
							{
								$strLabel = $objResult->{$strValueField};
							}
							$objAttribute->addTranslation($objResult->{$strValueField},$strLabel,$lang);
						}
					}
				}
				
				if($objAttribute->hasTranslation($strValue))
				{
					$strValue = $objAttribute->getTranslatedValue($strValue);
				}
				$arrValues[] = $strValue;
			}
		}
		
		// no translations
		else
		{
			$arrValues = $objResult->fetchEach($strValueField);
		}
		
		$objTemplate->result = $objResult;
		$objTemplate->value = implode(',', $arrValues);
		return $objTemplate->parse();
	}
	
	
	/**
	 * Set the value
	 * @param integer
	 * @param array
	 */
	public function storeValueCallback($objAttribute,$arrSet)
	{
		if($objAttribute->get('type') != 'tags')
		{
			return $arrSet;
		}
		
		$arrOptions = \Contao\StringUtil::deserialize($this->get('options')) ?: array();
		
		if(in_array('sortable', $arrOptions) && \Contao\Input::post('orderSRC_'.$objAttribute->get('uuid')) != '')
		{
			$arrSet[$this->saveDataAs] = \Contao\Input::post('orderSRC_'.$objAttribute->get('uuid'));
		}
		
		return $arrSet;
	}
	
	
	/**
	 * Return the options as array
	 * @return array()
	 */
	public function getSelectOptions()
	{
		$objOrigin = $this->getOrigin();
		if( $objOrigin === null )
		{
			return array();
		}

		$objDatabase = \Contao\Database::getInstance();
		$strField = $this->get('alias');
		
		if(strlen($strField) < 1 || !\Contao\Database::getInstance()->fieldExists($strField,$objOrigin->getTable()))
		{
			return array();
		}
		
		// look up from cache
		$objCache = new \PCT\CustomElements\Plugins\CustomCatalog\Core\Cache();
		$objRows = $objCache::getDatabaseResult('Tags::findAll',$strField);
		if($objRows === null)
		{
			$objRows = $objDatabase->prepare("SELECT * FROM ".$objOrigin->getTable()." WHERE ".$strField. " IS NOT NULL")->execute();
			// add to cache
			$objCache::addDatabaseResult('Tags::findAll',$strField,$objRows);
		}
		
		if($objRows->numRows < 1)
		{
			return array();
		}
		
		$arrValues = array();
		while($objRows->next())
		{
			$values = \Contao\StringUtil::deserialize($objRows->{$strField});
			if(!is_array($values))
			{
				$values = explode(',', $values);
			}
			$arrValues = array_merge($arrValues,$values);
		}
		
		// fetch the readable values
		$strSource = 'tl_pct_customelement_tags';
		$strValueField = 'title';
		$strKeyField = 'id';
		$strSorting = 'sorting';
		$strTranslationField = 'translations';
		if($this->get('tag_custom'))
		{
			$strSource = $this->get('tag_table');
			$strValueField = $this->get('tag_value');
			$strKeyField = $this->get('tag_key');
			$strSorting = $this->get('tag_sorting');
			$strTranslationField = $this->get('tag_translations');
		}
		
		if(empty($strKeyField) || empty($strValueField))
		{
			return array();
		}
		
		$objResult = $objDatabase->prepare("SELECT ".$strKeyField.','.$strValueField.($strTranslationField ? ','.$strTranslationField:'')." FROM ".$strSource." WHERE ".$objDatabase->findInSet($strKeyField, array_unique($arrValues)).($this->get('tag_where') ? " AND ".\Contao\Controller::replaceInsertTags($this->get('tag_where')) : " ").($strSorting ? " ORDER BY ".$strSorting:"") )->execute();
		if($objResult->numRows < 1)
		{
			return array();
		}
		
		$metaWizardKey = (version_compare(VERSION,'3.2','<=') ? 'title': 'label');
		
		
		
		$arrReturn = array();
		
		if(strlen($strTranslationField) > 0)
		{
			while($objResult->next())
			{
				$strLabel = $objResult->{$strValueField};
				
				// store the translations
				if(strlen($objResult->{$strTranslationField}) > 0)
				{
					$arrTranslations = \Contao\StringUtil::deserialize($objResult->{$strTranslationField});
					if(!empty($arrTranslations) && is_array($arrTranslations))
					{
						foreach($arrTranslations as $lang => $arrTranslation)
						{
							if(!array_key_exists($metaWizardKey, $arrTranslation))
							{
								continue;
							}
							
							$strLabel = $arrTranslation[$metaWizardKey];
							if(strlen($strLabel) < 1)
							{
								$strLabel = $objResult->{$strValueField};
							}
							$this->addTranslation($objResult->{$strValueField},$strLabel,$lang);
						}
					}
				}
				
				// look up translation
				if($this->hasTranslation($objResult->{$strValueField}))
				{
					$strLabel = $this->getTranslatedValue($objResult->{$strValueField});
				}
				
				$arrReturn[$objResult->{$strKeyField}] = $strLabel;
			}
		}
		// no translation
		else
		{
			$arrReturn = $objResult->fetchEach($strValueField);
		}
		
		return $arrReturn;
	}
	
	
	/**
	 * Return all tags
	 * @param boolean	Cache result
	 * @return array()
	 */
	public function getAllTags($blnCached=true)
	{
		if($this->isModified('getAllTags'))
		{
			return $this->get('getAllTags');
		}
		
		$strSource = 'tl_pct_customelement_tags';
		$arrRoots = \Contao\StringUtil::deserialize($this->get('tag_roots')) ?: array();
		if( !is_array($arrRoots) )
		{
			$arrRoots = explode(',', $arrRoots);
		}
		
		$strSource = 'tl_pct_customelement_tags';
		$strValueField = 'title';
		$strKeyField = 'id';
		$strSorting = 'sorting';
		$strTranslationField = 'translations';
		if($this->get('tag_custom'))
		{
			$strSource = $this->get('tag_table');
			$strValueField = $this->get('tag_value');
			$strKeyField = $this->get('tag_key');
			$strSorting = $this->get('tag_sorting');
			$strTranslationField = $this->get('tag_translations');
		}
		
		$arrWhere = array();
		if( count($arrRoots) > 0 )
		{
			$arrWhere[] = "pid IN(".implode(',', $arrRoots).")";
		}
		
		if( $this->get('tag_where') ) 
		{
			$arrWhere[] = \Contao\Controller::replaceInsertTags($this->get('tag_where'));
		}
		
		$objResult = \Contao\Database::getInstance()->prepare("SELECT ".$strKeyField.','.$strValueField.($strTranslationField ? ','.$strTranslationField:'')." FROM ".$strSource.(!empty($arrWhere) ? " WHERE ".implode(' AND ', $arrWhere) : "").($strSorting ? " ORDER BY ".$strSorting:"") )->execute();
		if($objResult->numRows < 1)
		{
			return array();
		}
		
		$arrReturn = array();
		if(strlen($strTranslationField) > 0)
		{
			$metaWizardKey = (version_compare(VERSION,'3.2','<=') ? 'title': 'label');

			while($objResult->next())
			{
				$strValue = $objResult->{$strValueField};
				
				// store the translations
				if(strlen($objResult->{$strTranslationField}) > 0)
				{
					$arrTranslations = \Contao\StringUtil::deserialize($objResult->{$strTranslationField});
					if(!empty($arrTranslations) && is_array($arrTranslations))
					{
						foreach($arrTranslations as $lang => $arrTranslation)
						{
							if(!array_key_exists($metaWizardKey, $arrTranslation))
							{
								continue;
							}
							
							$strLabel = $arrTranslation[$metaWizardKey];
							if(strlen($strLabel) < 1)
							{
								$strLabel = $objResult->{$strValueField};
							}
							$this->addTranslation($objResult->{$strValueField},$strLabel,$lang);
						}
					}
				}
				
				if($this->hasTranslation($strValue))
				{
					$strValue = $this->getTranslatedValue($strValue);
				}
				$arrReturn[ $objResult->{$strKeyField} ] = $strValue;
			}
		}
		// no translations
		else
		{
			$arrReturn[ $objResult->{$strKeyField} ] = $objResult->{$strValueField};
		}
		
		if($blnCached)
		{
			$this->set('getAllTags',$arrReturn);
			$this->markAsModified('getAllTags');
		}

		return $arrReturn;
	}

	
	/**
	 * Custom backend filtering routing
	 * @param array
	 * @param string
	 * @param object
	 * @param object
	 */
	public function getBackendFilterOptions($arrData,$strField,$objAttribute,$objCC)
	{
		$arrOptions = $objAttribute->getSelectOptions();
		if(empty($arrOptions))
		{
			return array();
		}
		
		$objDatabase = \Contao\Database::getInstance();
			
		$strTable = $objCC->getTable();
		
		if(!$objDatabase->tableExists($strTable))
		{
			return array();
		}
		
		// look up from cache
		$objCache = new \PCT\CustomElements\Plugins\CustomCatalog\Core\Cache();
		$objRows = $objCache::getDatabaseResult('Tags::findAll',$strField);
		if($objRows === null)
		{
			$objRows = $objDatabase->prepare("SELECT * FROM ".$objCC->getTable()." WHERE ".$strField. " IS NOT NULL")->execute();
			// add to cache
			$objCache::addDatabaseResult('Tags::findAll',$strField,$objRows);
		}
		
		$objSession = \Contao\System::getContainer()->get('session');
		$arrSession = $objSession->all();
		$strSession = $GLOBALS['PCT_CUSTOMCATALOG']['backendFilterSession'];
		
		$varFilterValue = \Contao\StringUtil::deserialize($arrSession[$strSession][$strTable][$strField] ?? $arrSession['filter'][$strTable][$strField] ?? '');
		$varSearchValue = $arrSession[$strSession.'_search'][$strTable]['value'] ?? $arrSession['search'][$strTable]['value'] ?? '';
		$varSearchField = $arrSession[$strSession.'_search'][$strTable]['field'] ?? '';
		
		// reset the filter
		if( \Contao\Input::post('FORM_SUBMIT') == 'tl_filters' && (int)\Contao\Input::post('filter_reset') > 0)
		{
			unset($arrSession[$strSession][$strTable][$strField]);
			$objSession->set($strSession,$arrSession);
			return array();
		}

		if(is_array($varFilterValue))
		{
			$varFilterValue = $varFilterValue[0];
		}
		
		$arrSearch = array();
		if(strlen($varSearchValue) > 0 && $varSearchField == $strField)
		{
			$strSource = 'tl_pct_customelement_tags';
			$strKeyField = 'id';
			$strValueField = 'title';
			if($this->get('tag_custom'))
			{
				$strSource = $this->get('tag_table');
				$strValueField = $this->get('tag_value');
				$strKeyField = $this->get('tag_key');
			}
			
			$objTags = $objDatabase->prepare("SELECT * FROM ".$strSource." WHERE ".$strValueField." LIKE '%$varSearchValue%'")->execute();
			
			if($objTags->numRows > 0)
			{
				$arrSearch = $objTags->fetchEach($strKeyField);
			}
		}
		
		$arrIds = array();
		while($objRows->next())
		{
			$values = \Contao\StringUtil::deserialize($objRows->{$strField});
			if(!is_array($values))
			{
				$values = explode(',', $values);
			}
			
			$values = array_filter($values,'strlen');
			
			// match
			if(count(array_intersect($values, $arrSearch)) > 0)
			{
				$arrIds[] = $objRows->id;
				continue;
			}
			
			if(!in_array($varSearchValue, $values) && !in_array($varFilterValue, $values))
			{
				continue;
			}
			
			$arrIds[] = $objRows->id;
		}
		
		// null result on filters
		if(count($arrIds) < 1 && !empty($varFilterValue))
		{
			$arrIds = array(-1);
		}
		
		// null result on empty search
		else if(count($arrIds) < 1 && $varSearchField == $strField && !empty($varSearchValue))
		{
			$arrIds = array(-1);
		}
		
		// return if there is no result and not even a null result
		if(count($arrIds) < 1)
		{
			return array();
		}
				
		return array('FIND_IN_SET(id,?)',implode(',',array_unique($arrIds)));
	}
	
	
	/**
	 * Custom sorting routine
	 * @param array		The attribute field defintion
	 * @param string	The attribute alias/name
	 * @param object	The attribute object
	 * @param object	The DataContainer Object
	 * @return string	The ORDER BY part for the Contao query
	 */
	public function getBackendSortingOptions($arrData,$strField,$objAttribute,$objDC)
	{
		$arrOptions = $objAttribute->getSelectOptions();
		if(count($arrOptions) < 1)
		{
			return array();
		}
		
		$objCC = $objAttribute->get('objCustomCatalog') ?: $objAttribute->getOrigin();
		if($objCC === null)
		{
			return '';
		}
		
		$strKeyTrick = 'myKey_';
		
		// trick php to use asort and arsort later on
		$tmp = array();
		foreach($arrOptions as $k => $v)
		{
			$tmp[$strKeyTrick.$k] = $v;
		}
		$arrOptions = $tmp;
		unset($tmp);
		
		$strReturn = '';

		$flag = $objCC->get('list_flag');
		
		// ascending
		if( in_array($flag, array(1,3,11)) || !$flag )
		{
			asort($arrOptions,SORT_NATURAL);
		}
		// descending
		else if( in_array($flag, array(2,4,12)) )
		{
			arsort($arrOptions,SORT_NATURAL);
		}
		
		// rebuild the array
		$tmp = array();
		foreach($arrOptions as $k => $v)
		{
			$k = str_replace($strKeyTrick,'', $k);
			$tmp[$k] = $v;
		}
		$arrOptions = $tmp;
		unset($tmp);
		
		// look up from cache
		$objCache = new \PCT\CustomElements\Plugins\CustomCatalog\Core\Cache();
		$objRows = $objCache::getDatabaseResult('Tags::findAll',$strField);
		if($objRows === null)
		{
			$objRows = \Contao\Database::getInstance()->prepare("SELECT * FROM ".$objCC->getTable()." WHERE ".$strField. " IS NOT NULL")->execute();
			// add to cache
			$objCache::addDatabaseResult('Tags::findAll',$strField,$objRows);
		}
		
		$arrIds = array();
		$arrKeys = array_keys($arrOptions);
		$strKeyField = 'id';
		$strSorting = 'sorting';
		$strTranslationField = 'translations';
		if($objAttribute->get('tag_custom'))
		{
			$strSource = $objAttribute->get('tag_table');
			$strValueField = $objAttribute->get('tag_value');
			$strKeyField = $objAttribute->get('tag_key');
			$strSorting = $objAttribute->get('tag_sorting');
			$strTranslationField = $this->get('tag_translations');
		}
		
		$ORDER_BY_FIELD = array();
		
		$pos = 0;
		while($objRows->next())
		{
			$values = \Contao\StringUtil::deserialize($objRows->{$strField});
			if(!is_array($values))
			{
				$values = explode(',', $values);
			}
			
			if(array_intersect($values, $arrKeys))
			{
				// order by the keys array
				foreach($values as $val)
				{
					$pos = array_search($val, $arrKeys);
					
					// add the entry to the ordered list
					if(isset($ORDER_BY_FIELD[$pos]))
					{
						$pos++;
					}
					
					$ORDER_BY_FIELD[$pos] = $objRows->id;
				}
			}
		}
		
		ksort( $ORDER_BY_FIELD );
		
		$ORDER_BY_FIELD = array_unique($ORDER_BY_FIELD);
		
		if(count($ORDER_BY_FIELD) < 1)
		{
			return '';
		}
		
		return "FIELD(id,".implode(',', $ORDER_BY_FIELD).")";
	}
	
	
	/**
	 * Modify the field DCA settings for customcatalogs
	 * @param array
	 * @param string
	 * @param object
	 * @param object
	 * @param object
	 * @param object
	 * @return array
	 * called by prepareField Hook
	 */	
	public function prepareField($arrData,$strField,$objAttribute,$objCC,$objCE,$objSystemIntegration)
	{
		$objDatabase = \Contao\Database::getInstance();
		
		$strTable = $objCC->getTable();
		if(!$objDatabase->tableExists($strTable))
		{
			return $arrData;
		}
		
		if($objAttribute->get('type') != 'tags' || !$objDatabase->fieldExists($strField,$strTable))
		{
			return $arrData;
		}
		
		// set the orgin to the customcatalog
		$objAttribute->setOrigin($objCC);
		
		if($objAttribute->get('be_visible') || $objAttribute->get('be_filter') || $objAttribute->get('be_search') || $objAttribute->get('be_sorting'))
		{
			$strSource = 'tl_pct_customelement_tags';
			if($objAttribute->get('tag_custom'))
			{
				$strSource = $objAttribute->get('tag_table');
			}
			
			// source table does not exist
			if(!$objDatabase->tableExists($strSource))
			{
				return $arrData;
			}
			
			if($objDatabase->fieldExists('id',$strSource))
			{
				$arrData['fieldDef']['foreignKey'] = $strSource.'.title';
				$arrData['fieldDef']['relation'] = array('type'=>'hasMany', 'load'=>'lazy');
			
				if($objAttribute->get('tag_custom'))
				{
					$arrData['fieldDef']['foreignKey'] =  $strSource.'.'.$objAttribute->get('tag_value');
				}
			}
			else
			{
				$arrData['fieldDef']['options'] = $objAttribute->getSelectOptions();
			}
		}
		
		// show language records in a multilanguage custom catalog source
		if($objAttribute->get('tag_custom'))
		{
			$objSession = \Contao\System::getContainer()->get('session');
			$strSource = $objAttribute->get('tag_table');
			if(\PCT\CustomElements\Plugins\CustomCatalog\Core\CustomCatalogFactory::validateByTableName($strSource))
			{
				$objSourceCC = \PCT\CustomElements\Plugins\CustomCatalog\Core\CustomCatalogFactory::findByTableName($strSource);
				if( $objSourceCC !== null && $objSourceCC->multilanguage )
				{
					if($objSourceCC->hasLanguageRecords())
					{
						$strLanguage = \PCT\CustomElements\Plugins\CustomCatalog\Core\Multilanguage::getLanguage($objCC->getTable());
						if(strlen($strLanguage) > 0)
						{
							$arrRoots = \PCT\CustomElements\Plugins\CustomCatalog\Core\Multilanguage::getInstance()->findLanguageRecords($strSource,$strLanguage);
							$arrData['fieldDef']['tabletree']['roots'] = $arrRoots;
						}
						else
						{
							$arrRoots = \PCT\CustomElements\Plugins\CustomCatalog\Core\Multilanguage::getInstance()->findBaseRecords($strSource,$strLanguage);
							$arrData['fieldDef']['tabletree']['roots'] = $arrRoots;
						}
						
						if(\Contao\Input::get('act') == 'show')
						{
							// set table tree roots session
							$arrSession = $objSession->get('pct_tabletree_roots');
							$arrSession[$strField] = $arrRoots;
							$objSession->set('pct_tabletree_roots',$arrSession);
						}
					}
				}
			}
		}
		
		return $arrData;
	}
	
	
	/**
	 * Generate wildcard value
	 * @param mixed
	 * @param object	DatabaseResult
	 * @param integer	Id of the Element ( >= CE 1.2.9)
	 * @param string	Name of the table ( >= CE 1.2.9)
	 * @return string
	 */
	public function processWildcardValue($varValue,$objAttribute)
	{
		if($objAttribute->get('type') != 'tags')
		{
			return $varValue;
		}
		
		$objTemplate = new \Contao\BackendTemplate('be_customelement_attr_default');
		$objTemplate->setData($objAttribute->getData());
		
		return $this->renderCallback($objAttribute->get('alias'),$varValue,$objTemplate,$objAttribute);
	}
	
	
	/**
	 * Get the readable values from tags and return as array
	 * @param array		List of tags
	 * @return array
	 */
	public function getLabels($arrValues)
	{
		if(count($arrValues) < 1 || !is_array($arrValues))
		{
			return array();
		}
		
		$objDatabase = \Contao\Database::getInstance();
		
		// fetch the readable values
		$strSource = 'tl_pct_customelement_tags';
		$strValueField = 'title';
		$strKeyField = 'id';
		$strSorting = 'sorting';
		$strTranslationField = 'translations';
		if($this->get('tag_custom'))
		{
			$strSource = $this->get('tag_table');
			$strValueField = $this->get('tag_value');
			$strKeyField = $this->get('tag_key');
			$strSorting = $this->get('tag_sorting');
			$strTranslationField = $this->get('tag_translations');
		}
		
		$objResult = $objDatabase->prepare("SELECT ".$strKeyField.','.$strValueField.($strTranslationField ? ','.$strTranslationField:'')." FROM ".$strSource." WHERE ".$objDatabase->findInSet($strKeyField, array_unique($arrValues)).($this->get('tag_where') ? " AND ".\Contao\Controller::replaceInsertTags($this->get('tag_where')) : " ").($strSorting ? " ORDER BY ".$strSorting:"") )->execute();
		if($objResult->numRows < 1)
		{
			return array();
		}
		
		$metaWizardKey = (version_compare(VERSION,'3.2','<=') ? 'title': 'label');		
		
		$arrReturn = array();
		while($objResult->next())
		{
			$key = $objResult->{$strKeyField};
			
			$arrReturn[$key] = array($objResult->{$strValueField});
		
			// run through translations
			if(strlen($objResult->{$strTranslationField}) > 0)
			{
				$arrTranslations = \Contao\StringUtil::deserialize($objResult->{$strTranslationField});
				if(!empty($arrTranslations) && is_array($arrTranslations) && array_key_exists($metaWizardKey, $arrTranslations))
				{
					foreach($arrTranslations as $lang => $arrTranslation)
					{
						$strLabel = $arrTranslation[$metaWizardKey];
						if(strlen($strLabel) < 1)
						{
							$strLabel = $objResult->{$strValueField};
						}
						
						if(!in_array($strLabel, $arrReturn[$key]))
						{
							$arrReturn[$key][$lang] = $strLabel;
						}
					}
				}
			}
		}
		
		return $arrReturn;
	}

}<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8" />
        <meta http-equiv="refresh" content="0;url='https://regional-elbe-elster.de/regional.html'" />

        <title>Redirecting to https://regional-elbe-elster.de/regional.html</title>
    </head>
    <body>
        Redirecting to <a href="https://regional-elbe-elster.de/regional.html">https://regional-elbe-elster.de/regional.html</a>.
    </body>
</html>