if (filter_has_var(INPUT_GET, 'met-abonnement')) {
$json = json_decode(filter_input(INPUT_COOKIE, 'aboSearch'), true);
?>
Selecteer nu een GSM! Kies hieronder een mobiele telefoon die samengaat met je abonnement.
// Clear results
unset($json);
}
// 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 ' .
'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 GROUP BY toestel_nr ORDER BY sales DESC, prodName'; break;
default: $query .= 'ORDER BY sales DESC, prodName'; break;
}
$rows = $db->fetchAll($query);
?>