<?php
require_once("config/config.php");
get_header();

wp_reset_query();
$iPageID = $GLOBALS['page_id'];
$ancestor_id=get_main_page_id();

$db = new mysql();
$sAddressId = get_query_var('address_id');
$sAddressCity = get_query_var('address_city');
$db->where('address_id', $sAddressId);
$aAddresses = $db->get('sucht_addresses');

if(!$sAddressId || empty($aAddresses)) {
    status_header(404);
}
?>

	<div class="container content-container">
		<div class="col-md-9 col-content">
			
			<div class="content no-margin" itemscope itemtype="http://schema.org/Organization">
<?php
                //echo "<pre>";
                //print_r($aAddresses);
                //echo "</pre>";
?>
				<h1><span itemprop="name"><?php echo $aAddresses[0]['address_name']; ?></span></h1>
                <div class="row">
                    <div class="col-md-6">
                        <div class="col-xs-4 no-padding">
                            <strong>Anschrift</strong>
                        </div>
                        <div class="col-xs-8 no-padding" itemprop="address" itemscope itemtype="http://schema.org/PostalAddress">
							<meta itemprop="name" content="<?php echo $aAddresses[0]['address_name']; ?>" />
							<meta itemprop="addressCountry" content="de" />
                            <span itemprop="streetAddress"><?php echo $aAddresses[0]['address_street']; ?></span><br />
                            <span itemprop="postalCode"><?php echo $aAddresses[0]['address_zip']; ?></span> <span itemprop="addressLocality"><?php echo $aAddresses[0]['address_city']; ?></span><br />
                            <span itemprop="addressRegion"><?php echo $aAddresses[0]['address_state']; ?></span>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="col-xs-4 no-padding">
                            <strong>Kontakt</strong>
                        </div>
                        <div class="col-xs-8 no-padding">
                            <?php echo !empty($aAddresses[0]['address_phone']) ? '<span itemprop="telephone">' . $aAddresses[0]['address_phone'] . "</span><br />" : FALSE; ?>
                            <?php echo !empty($aAddresses[0]['address_web']) ? '<span itemprop="sameAs" content="' . $aAddresses[0]['address_web'] . '">' . '<a href="' . $aAddresses[0]['address_web'] . '" target="_blank">' . mb_substr(str_replace(array('http://', 'https://'), '', $aAddresses[0]['address_web']), 0, 32) . '</a></span><br />' : FALSE; ?>
                            <?php echo !empty($aAddresses[0]['address_mail']) ? $aAddresses[0]['address_mail'] : FALSE; ?>
                        </div>
                    </div>
					<div class="col-md-12 ad-bar">
						<?php echo get_adsense_bar(); ?>
					</div>
                    <div class="col-md-12 address-info-additional">
                        <p>Das Beratungsangebot der verschiedenen Suchtberatungsstellen kann unterschiedlich ausfallen und ist nicht immer der richtige Ansprechpartner für jede Abhängigkeit. Informieren Sie sich deshalb bitte über die Webseite oder die angegebene Telefonnummer, ob <?php echo $aAddresses[0]['address_name']; ?> entsprechende Leistungen bietet und suchen Sie ggf. nach anderen <a href="<?php echo get_site_url(); ?>/suchtberatung/<?php echo $aAddresses[0]['address_rewrite_city']; ?>/" title="Suchtberatungen in <?php echo $aAddresses[0]['address_city']; ?>">Beratungsstellen in <?php echo $aAddresses[0]['address_city']; ?></a>.</p>
                        <p><em>Bitte beachten Sie auch, dass die Beratungsstellen Ihnen keine Fragen zu den hier angebotenen <a href="<?php echo get_site_url(); ?>" title="Drogentester für zu Hause">Drogentestern</a> beantworten können.</em></p>
                    </div>
                    <div class="col-md-12 address-map">
                        <?php
                            echo '
                        <script type="text/javascript">
                          
                            function initMap() {
                              var myLatLng = {lat: ' . $aAddresses[0]['address_lat'] . ', lng: ' . $aAddresses[0]['address_lon'] . '};
                      
                              var map = new google.maps.Map(document.getElementById(\'contact_map\'), {
                                zoom: 14,
                                center: myLatLng,
                                scrollwheel: false
                              });
                      
                              var marker = new google.maps.Marker({
                                position: myLatLng,
                                map: map
                              });
                            }

                         
                        </script>
                        <script async defer src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&key=AIzaSyCom6slhLQE6aFOEJNOfQLK-ETqo-qKTL4&callback=initMap"></script>
                            <div class="contact_map" id="contact_map">
                            </div>';
                            
                            $db->where('address_rewrite_city', $sAddressCity);
                            $db->where('address_id', array($sAddressId), 'NOT IN');
                            $aRelated = $db->get('sucht_addresses');
                        ?>
                    
                        <?php if(count($aRelated) > 0) { ?>
                        <div style="margin-top:25px;">
                            <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                            <ins class="adsbygoogle"
                                 style="display:block"
                                 data-ad-client="ca-pub-1943906092680535"
                                 data-ad-slot="6754732471"
                                 data-ad-format="auto"></ins>
                            <script>
                            (adsbygoogle = window.adsbygoogle || []).push({});
                            </script>
                        </div>
                        <?php } ?>
                    </div>
                    <?php
                    mb_internal_encoding("UTF-8");
                    if(!empty($aRelated)) {
                        
                        echo '
                        <div class="col-md-12">
                            <h2>Suchtberatungsstellen in ' . $aAddresses[0]['address_city']  . '</h2>
                            <a href="' . get_site_url() . '/suchtberatung/' . $aAddresses[0]['address_rewrite_city']  . '/" title="Suchtberatung in ' . $aAddresses[0]['address_city']  . '" class="get-all-addresses">alle Beratungsstellen in ' . $aAddresses[0]['address_city']  . '</a>
                        </div>
                        ';
                        
                         foreach($aRelated as $key => $value) {
                              echo '
                                  <div class="col-md-6 address-item">
                                      <h3><a href="' . get_site_url() . '/suchtberatung/' . $value['address_rewrite_city'] . '/' . $value['address_id'] . '_' . $value['address_rewrite_name'] . '/" title="' . $value['address_name'] . ' in ' . $value['address_city'] . '">' . mb_substr($value['address_name'],0,32) . (strlen($value['address_name']) > 32 ? '...' : FALSE) . '</a></h3>
                                      ' . $value['address_street'] . '<br />
                                      ' . $value['address_zip'] . ' ' . $value['address_city'] . '
                                  </div>
                              ';
                         }
                    }
               
                    
                    //echo "<pre>";
                    //print_r($aRelated);
                    //echo "</pre>";
                    
                    
                    ?>
                </div>
			</div>
			
			<?php
			// FAQs ausgeben
			if($iPageID == 129) { echo get_faq_list(); } else { ?>
				<div class="content">
					<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
					<ins class="adsbygoogle"
						 style="display:block"
						 data-ad-client="ca-pub-1943906092680535"
						 data-ad-slot="6754732471"
						 data-ad-format="auto"></ins>
					<script>
					(adsbygoogle = window.adsbygoogle || []).push({});
					</script>
				</div>
			<?php } ?>
			
		</div>
		<div class="col-md-3 sidebar">
			<?php echo get_sidebar_stats(); ?>
			<?php echo get_sidebar_shop(); ?>
		</div>
	</div>
	
	<?php get_footer(); ?>
	</body>
</html>