<?php

/* 
	Deense Kroon
	Blog
	
	Mike Ontwerpt 2012
	www.mikeontwerpt.nl
	
	initBlog(); 
	
	showLargeBanner();
	showPopular();
	showCollection();

*/
	
function initBrands(){
	$output = '';
	
	$output .= showBrands();
	
	return $output;
}

function showBrands(){
	/* get mysqli */
	global $mysqli;
	
	include './lang/'.$_SESSION['lang'].'.php';	

	$output = '';
	/* get info */
	$query = 'SELECT m.title, m.description, m.descriptionEn, m.descriptionDe, m.descriptionFr, m.image, m.logo, m.timest
			  FROM merken AS m, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = m.id
			  AND s.linkname = "merken"
			  AND m.published = 1 
			  ORDER BY m.itemOrder DESC';
	if( ! $result = $mysqli->query($query)) return $mysqli->error;

    $output .= '<h1>Onze merken</h1>';
    $output .= '<div class="brand-grid">';

    while($record = $result->fetch_assoc()){
        $name = fromDatabase($record['title']);
        $link = '/toont-haar-collectie/van-het-merk/'. linkname($name) .'/';

        // Fetch logo
        $shortcode = substr($record['logo'], 1, -1);
        $mediaResult = $mysqli->query('SELECT title, path FROM media_files WHERE shortcode = "' . $shortcode . '" LIMIT 1');
        $mediaRecord = $mediaResult->fetch_assoc();

        $logo = '';
        if($mediaRecord['path'] != null) $logo = '/images/uploads/'.$mediaRecord['path'];

        // Output
        $output .= '<div class="brand-cell">
                        <a class="brand-logo" href="' . $link . '">
                            <img src="' . $logo . '" alt="' . $name . '"/>
                        </a>
    
                    </div>';
    }
	$output .= '</div>';

	return $output;
}