// Get products
$query = 'SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr, ppm FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) INNER JOIN `Toestel_eigenschap` USING (toestel_nr) INNER JOIN `Toestel_link_cache` USING (toestel_nr) INNER JOIN `Abonnement_bundel` USING (abu_nr) ' .
'WHERE categorie_nr = 1 AND has_sublinks > 0 AND has_retlinks > 0 AND eigenschap_nr = 37 AND landencode = "NL" AND type_nr = 1 AND merk_nr = :id ' .
'GROUP BY toestel_nr ';
// Add sorting
switch ($sort) {
case 2: $query .= 'ORDER BY ppm, sales DESC, prodName'; break;
case 3: $query .= 'ORDER BY datum_verkrijgbaar DESC, sales DESC, prodName'; break;
case 4: $query .= 'ORDER BY prodName, sales DESC'; break;
case 5: $query = 'SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr, NULL AS ppm FROM `Toestel` INNER JOIN `Merk` USING (merk_nr) INNER JOIN `Toestel_eigenschap` USING (toestel_nr) WHERE categorie_nr = 1 AND verkrijgbaar_nr = 7 AND eigenschap_nr = 37 AND merk_nr = :id GROUP BY toestel_nr ORDER BY sales DESC, prodName'; break;
default: $query .= 'ORDER BY sales DESC, prodName'; break;
}
$rows = $db->fetchAll($query, 'i', array('id' => $brand['merk_nr']));
?>
Mobiele telefoons
Merken
$brands = $db->fetchAll('SELECT naam, COUNT(*) AS aantal, SUM(sales) AS verkopen FROM `Merk` ' .
'INNER JOIN `Toestel` USING (merk_nr) ' .
'INNER JOIN `Toestel_eigenschap` USING (toestel_nr) ' .
'WHERE Merk.omgeving_nr IN (1, 2) AND Toestel.omgeving_nr IN (1, 2) AND Toestel.categorie_nr = 1 ' .
'AND Toestel.has_sublinks > 0 AND Toestel.has_retlinks > 0 AND Toestel_eigenschap.eigenschap_nr = 37 ' .
'GROUP BY merk_nr ORDER BY verkopen DESC');
$countBrands = count($brands);
$breakPoint = ceil($countBrands / 3);
for ($i = 0; $i < $countBrands; $i++) {
// New column
if ($i > 0 && $i % $breakPoint === 0) {
?>
Top 5 populair
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY sales DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>
Top 5 nieuw
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY datum_verkrijgbaar DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>