if ($product_valence) {
$data['product_valence'] = $product_valence;
}
}
// Wurde eine Postleitzahl eingegeben? Keine Pflicht
if (isset($_POST['distance_zip']) && !empty($_POST['distance_zip'])) {
$distance_zip = filterZip($_POST['distance_zip']);
if ($distance_zip) {
$data['distance_zip'] = $distance_zip;
$data['distance_lat'] = $_POST['zip_latitude'];
$data['distance_lon'] = $_POST['zip_longitude'];
}
}
// Wurde eine Entfernung angegeben? Keine Pflicht
if (isset($_POST['distance']) && !empty($_POST['distance'])) {
$distance = filterInt($_POST['distance']);
if ($distance) {
$data['distance'] = $distance;
}
}
// Wurde ein Mindestpreis angegeben? Keine Pflicht
if (isset($_POST['price_from']) && !empty($_POST['price_from'])) {
$price_from = filterString($_POST['price_from']);
if ($price_from) {
$data['price_from'] = $price_from;
}
}
// Wurde ein Maximalpreis angegeben? Keine Pflicht
if (isset($_POST['price_max']) && !empty($_POST['price_max'])) {
$price_max = filterString($_POST['price_max']);
if ($price_max) {
$zip = filter_input(INPUT_POST, 'zip');
$errors = [];
if (empty($mail) && empty($zip)) {
$errors[] = 'Bitte geben Sie Ihre E-Mail-Adresse und Postleitzahl ein.';
} else {
// collecting errors for mail
if (empty($mail)) {
$errors[] = 'Bitte geben Sie Ihre E-Mail-Adresse ein.';
}
if (!filterEmail($mail)) {
$errors[] = 'Dies ist keine gültige E-Mail-Adresse.';
}
if (!checkIfMailExists($mail, $db)) {
$errors[] = 'Diese E-Mail-Adresse wird bereits verwendet.';
}
// collecting errors for zip
if (empty($zip)) {
$errors[] = 'Bitte geben Sie Ihre Postleitzahl ein.';
}
if (!filterInt($zip)) {
$errors[] = 'Die Postleitzahl muss eine Zahl sein.';
} elseif (!filterZip($zip)) {
$errors[] = 'Diese Postleitzahl ist ungültig.';
}
}
if (empty($errors)) {
$subscribed = subscribe($mail, $zip, $db);
$sent = sendSuccessMail($mail);
$success = 'Sie haben sich erfolgreich für den Newsletter angemeldet.';
}
}
/**
* Funktion zum Laden von Sätzen mit mehrfach filter
*/
function getSentencesByMultipleSelection($db, $data)
{
foreach ($data as $key => $dataRaw) {
if (!empty($dataRaw)) {
if (is_numeric($dataRaw)) {
$data[$key] = filterInt($dataRaw);
} else {
$data[$key] = filterString($dataRaw);
}
}
}
$data['startLang'] = strtolower($data['startLang']);
$data['endLang'] = strtolower($data['endLang']);
//debug($data);
$stmt = 'SELECT ';
$stmt .= 'fr_' . $data['startLang'] . '_sentences.sentence_id,';
$stmt .= 'fr_' . $data['startLang'] . '_sentences.sentence_text,';
$stmt .= 'fr_' . $data['startLang'] . '_sentences.sentence_difficulty,';
$stmt .= 'fr_' . $data['startLang'] . '_sentences.sentence_lang, ';
if (isset($data['time']) && !empty($data['time'])) {
$stmt .= 'fr_languages.language_id, ';
$stmt .= 'fr_sentences_has_times.sentences_has_times_times_id, ';
$stmt .= 'fr_times.times_id, ';
}
$stmt .= 'fr_' . $data['endLang'] . '_sentences.sentence_id ';
$stmt .= 'FROM fr_' . $data['startLang'] . '_sentences ';
$stmt .= 'JOIN fr_' . $data['endLang'] . '_sentences ON fr_' . $data['endLang'] . '_sentences.sentence_id = fr_' . $data['startLang'] . '_sentences.sentence_id ';
if (isset($data['time']) && !empty($data['time'])) {
$stmt .= 'JOIN fr_languages ON fr_languages.language_shortcode = fr_' . $data['startLang'] . '_sentences.sentence_lang ';
$stmt .= 'JOIN fr_sentences_has_times ON fr_sentences_has_times.sentences_has_times_sentence_id = fr_' . $data['startLang'] . '_sentences.sentence_id ';
$stmt .= 'JOIN fr_times ON fr_times.times_id = fr_sentences_has_times.sentences_has_times_times_id ';
}
$stmt .= 'WHERE fr_' . $data['startLang'] . '_sentences.sentence_text_status = 1 ';
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_attributes_status = 1 ';
$stmt .= 'AND fr_' . $data['endLang'] . '_sentences.sentence_text_status = 1 ';
$stmt .= 'AND fr_' . $data['endLang'] . '_sentences.sentence_attributes_status = 1 ';
if (isset($data['level']) && !empty($data['level']) && $data['level'] !== 0) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_difficulty = "' . $data['level'] . '" ';
}
if (isset($data['searchWord']) && !empty($data['searchWord'])) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_text LIKE "%' . $data['searchWord'] . '%" ';
}
if (isset($data['mainCat']) && !empty($data['mainCat'])) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_category_no = "' . $data['mainCat'] . '" ';
}
if (isset($data['verbBasic']) && !empty($data['verbBasic'])) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_verb_basic = "' . $data['verbBasic'] . '" ';
}
if (isset($data['verbGrammar']) && !empty($data['verbGrammar'])) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_verb_grammar = "' . $data['verbGrammar'] . '" ';
}
if (isset($data['person']) && !empty($data['person'])) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_person = "' . $data['person'] . '" ';
}
if (isset($data['sipl']) && !empty($data['sipl'] && $data['sipl'] == 'singular')) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_singular = 1 ';
}
if (isset($data['sipl']) && !empty($data['sipl'] && $data['sipl'] == 'plural')) {
$stmt .= 'AND fr_' . $data['startLang'] . '_sentences.sentence_plural = 1 ';
}
if (isset($data['time']) && !empty($data['time'])) {
$stmt .= 'AND fr_times.times_id = "' . $data['time'] . '" ';
}
$stmt = $db->prepare($stmt);
if ($stmt !== false) {
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
if ($result) {
return $result;
} else {
return false;
}
}
