Filter
value="1" id="bkr">
class="custom-control-input" id="4g">
fetchAll('SELECT waarde FROM `Toe_eig_plus` ' . 'WHERE toestel_nr = :id AND eigenschap_nr = 58 AND naam = "Opslaggeheugen" ' . 'ORDER BY LENGTH(waarde), waarde', 'i', array('id' => $product['toestel_nr']), PDO::FETCH_COLUMN); if ($storages) { ?>
fetchAll('SELECT img_nr, filename, (width * height) AS dimensions FROM Album_afbeelding ' . 'INNER JOIN Toestel_album USING (album_nr) INNER JOIN Album USING (album_nr) INNER JOIN Afbeelding USING (img_nr) ' . 'WHERE toestel_nr = :id AND soort = 2', 'i', array('id' => $product['toestel_nr'])); // Looking for available colored editions $editions = $db->fetchAll('SELECT uitvoering_nr, fStrReplaceEdition(kleurnaam) AS `kleur`, ' . 'fStrReplaceEdition(weergavenaam) AS `naam`, weergavenaam, kleurcode1 FROM Toestel_uitvoering_cache ' . 'INNER JOIN Uitvoering USING (uitvoering_nr) ' . 'WHERE toestel_nr = :id', 'i', array('id' => $product['toestel_nr']), PDO::FETCH_GROUP|PDO::FETCH_UNIQUE|PDO::FETCH_ASSOC); $colors = array(); if ($editions) { foreach ($editions as $colorId => $row) { if ($row['kleur'] <> '') { $color = $row['kleur']; $name = $row['naam']; $hex = $row['kleurcode1']; // Remove sizes from name $name = trim(str_replace(array('Large', 'Medium', 'Small'), '', $name)); // Store longest name if (!isset($colors[$color])) $colors[$color] = array('naam' => $name, 'id' => $colorId, 'hex' => $hex); else { $tmpColor = $colors[$color]; if (strlen($name) > strlen($tmpColor['naam'])) $colors[$color] = array('naam' => $name, 'id' => $colorId, 'hex' => $hex); unset($tmpColor); } // Clear memory unset($color, $name, $colorId, $hex); } } // Sort on key ksort($colors); } if (!empty($colors)) { ?>
$edition) { $colorSearch = ''; $colorIndex = null; $colorMaxSize = 0; // Translate color to English switch (strtolower($color)) { case 'blauw'; $colorSearch = 'blue'; break; case 'brons'; $colorSearch = 'bronze'; break; case 'bruin'; $colorSearch = 'brown'; break; case 'geel'; $colorSearch = 'yellow'; break; case 'goud'; $colorSearch = 'gold'; break; case 'grijs'; $colorSearch = 'grey'; break; case 'groen'; $colorSearch = 'green'; break; case 'oranje'; $colorSearch = 'orange'; break; case 'paars': $colorSearch = 'purple'; break; case 'pink'; case 'roze': $colorSearch = 'pink'; break; case 'rood'; $colorSearch = 'red'; break; case 'wit'; $colorSearch = 'white'; break; case 'zilver'; $colorSearch = 'silver'; break; case 'zwart'; $colorSearch = 'black'; break; } // Look for color in album foreach ($album as $index => $img) { if (stripos(str_replace(array('_', '-'), ' ', $img['filename']), ' ' . $colorSearch) !== false && (stripos($img['filename'], 'rear') !== false && stripos($img['filename'], 'bottom') === false && stripos($img['filename'], 'angle') === false)) { if ($img['dimensions'] > $colorMaxSize) { $colorIndex = $index; $colorMaxSize = $img['dimensions']; } } } if (isset($colorIndex)) $colors[$color]['img_nr'] = $album[$colorIndex]['img_nr']; ?>
Geld lenen kost geld
RugGear RG160 abonnementen
Abonnement Jaar Bellen Internet Prijs