<table>
<tr>
<td><?php
echo getUebersetzung("Bitte wählen Sie die Gäste aus, an denen das E-Mail gesendet werden soll.");
?>
<br/>
<?php
echo getUebersetzung("Wenn Sie mehrere Gäste auswählen wollen müssen Sie die [Strg] Taste gedrückt halten.");
?>
</td>
</tr>
<tr>
<td><select name="mieter[]" size="10" multiple>
<?php
//alle gäste der unterkunft auslesen:
$res = getAllMieterFromVermieter($gastro_id);
while ($d = $res->FetchNextObject()) {
$mieter_id = $d->GAST_ID;
$vorname = $d->VORNAME;
$nachname = $d->NACHNAME;
$ort = $d->ORT;
$land = $d->LAND;
$gast = $nachname . " " . $vorname . ", " . $ort . ", " . $land;
?>
<option value="<?php
echo $mieter_id;
?>
" selected="selected"><?php
echo $gast;
?>
</option>
$root = "../../../..";
//datenbank öffnen:
include_once $root . "/conf/rdbmsConfig.inc.php";
//conf file öffnen:
include_once $root . "/conf/conf.inc.php";
include_once $root . "/include/sessionFunctions.inc.php";
//passwortpruefung durchfuehren:
include_once $root . "/webinterface/templates/checkPass.inc.php";
//globale variablen initialisieren:
$vermieter_id = getSessionWert(VERMIETER_ID);
$sprache = getSessionWert(SPRACHE);
header("Content-Disposition: attachment; filename=rezerviGenericMieterList.csv");
include_once $root . "/include/mieterFunctions.inc.php";
include_once $root . "/include/uebersetzer.inc.php";
//gästeliste ausgeben:
$res = getAllMieterFromVermieter($vermieter_id);
while ($d = mysqli_fetch_array($res)) {
$vorname = $d["VORNAME"];
$nachname = $d["NACHNAME"];
$firma = $d["FIRMA"];
$strasse = $d["STRASSE"];
$plz = $d["PLZ"];
$ort = $d["ORT"];
$land = $d["LAND"];
$email = $d["EMAIL"];
$tel = $d["TELEFON"];
$tel2 = $d["TELEFON2"];
$fax = $d["FAX"];
$anrede = $d["ANREDE"];
$speech_id = $d["SPRACHE_ID"];
$speech = getBezeichnungOfSpracheID($speech_id);
function initArray()
{
$root = "../../..";
global $db;
global $gastro_id;
include_once $root . "/include/rdbmsConfig.inc.php";
include_once $root . "/include/mieterFunctions.inc.php";
$res = getAllMieterFromVermieter(1);
$liste_a = array();
$liste_b = array();
$liste_c = array();
$liste_d = array();
$liste_e = array();
$liste_f = array();
$liste_g = array();
$liste_h = array();
$liste_i = array();
$liste_j = array();
$liste_k = array();
$liste_l = array();
$liste_m = array();
$liste_n = array();
$liste_o = array();
$liste_p = array();
$liste_q = array();
$liste_r = array();
$liste_s = array();
$liste_t = array();
$liste_u = array();
$liste_v = array();
$liste_w = array();
$liste_x = array();
$liste_y = array();
$liste_z = array();
array_push($liste_n, "neuerMieter\tneuerMieter");
while ($d = $res->FetchNextObject()) {
$firstChar = substr(strtolower($d->NACHNAME), 0, 1);
if ($firstChar == 'a') {
array_push($liste_a, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'b') {
array_push($liste_b, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'c') {
array_push($liste_c, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'd') {
array_push($liste_d, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'e') {
array_push($liste_e, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'f') {
array_push($liste_f, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'g') {
array_push($liste_g, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'h') {
array_push($liste_h, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'i') {
array_push($liste_i, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'j') {
array_push($liste_j, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'k') {
array_push($liste_k, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'l') {
array_push($liste_l, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'm') {
array_push($liste_m, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'n') {
array_push($liste_n, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'o') {
array_push($liste_o, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'p') {
array_push($liste_p, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'q') {
array_push($liste_q, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'r') {
array_push($liste_r, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 's') {
array_push($liste_s, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 't') {
array_push($liste_t, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'u') {
array_push($liste_u, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'v') {
array_push($liste_v, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'w') {
array_push($liste_w, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'x') {
array_push($liste_x, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'y') {
array_push($liste_y, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
} else {
if ($firstChar == 'z') {
array_push($liste_z, strtoupper($d->NACHNAME) . " " . ucfirst(strtolower($d->VORNAME)) . " ID:" . ucfirst(strtolower($d->GAST_ID)) . "\t" . ucfirst(strtolower($d->GAST_ID)));
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
return array('a' => $liste_a, 'b' => $liste_b, 'c' => $liste_c, 'd' => $liste_d, 'e' => $liste_e, 'f' => $liste_f, 'g' => $liste_g, 'h' => $liste_h, 'i' => $liste_i, 'j' => $liste_j, 'k' => $liste_k, 'l' => $liste_l, 'm' => $liste_m, 'n' => $liste_n, 'o' => $liste_o, 'p' => $liste_p, 'q' => $liste_q, 'r' => $liste_r, 's' => $liste_s, 't' => $liste_t, 'u' => $liste_u, 'v' => $liste_v, 'w' => $liste_w, 'x' => $liste_x, 'y' => $liste_y, 'z' => $liste_z);
}
