';
// *******************************************************************************************
//
// UPDOK - Update Button gedrückt
//
// *******************************************************************************************
if ($_POST['action']=='UPDOK') {
//
// Fehlerprüfung der eingegebenen Daten
//
foreach($datenfelder_kunde as $index => $wert) {
$textclass[$index] = "text";
}
$fehler = array();
if ($_POST['kun_nachname'] == '') {
$fehler[] = "Missing LAST NAME";
$fehler_class .= "*kun_nachname";
}
if ($_POST['kun_vorname'] == '') {
$fehler[] = "Missing FIRST NAME";
$fehler_class .= "*kun_vorname";
}
if ($_POST['gmm'].$_POST['gdd'].$_POST['gyyyy'] != '00000000') {
if (!checkdate($_POST['gmm'],$_POST['gdd'],$_POST['gyyyy'])) {
$fehler[] = "Invalid DATE OF BIRTH";
$fehler_class .= "*kun_geburtsdatum";
}
} else {
$fehler[] = "Missing DATE OF BIRTH";
$fehler_class .= "*kun_geburtsdatum";
}
if ($_POST['kun_nationalitaet'] == '') {
$fehler[] = "Missing CITIZENSHIP";
$fehler_class .= "*kun_nationalitaet";
$textclass['kun_nationalitaet'] = "error";
}
if ($_POST['kun_reisepass_nr'] == '') {
$fehler[] = "Missing PASSPORT NO";
$fehler_class .= "*kun_reisepass_nr";
}
if ($_POST['rmm'].$_POST['rdd'].$_POST['ryyyy'] != '00000000') {
if (!checkdate($_POST['rmm'],$_POST['rdd'],$_POST['ryyyy'])) {
$fehler[] = "Invalid PASSPORT VALIDITY";
$fehler_class .= "*kun_reisepass_gueltig";
}
} else {
$fehler[] = "Missing PASSPORT VALIDITY";
$fehler_class .= "*kun_reisepass_gueltig";
}
if ($_POST['kun_reisepass_ausstellungsort'] == '') {
$fehler[] = "Missing PASSPORT PLACE OF ISSUE";
$fehler_class .= "*kun_reisepass_ausstellungsort";
}
if ($_POST['imm'].$_POST['idd'].$_POST['iyyyy'] != '00000000') {
if (!checkdate($_POST['imm'],$_POST['idd'],$_POST['iyyyy'])) {
$fehler[] = "Invalid PASSPORT DATE OF ISSUE";
$fehler_class .= "*kun_reisepass_ausstellungsdatum";
}
} else {
$fehler[] = "Missing PASSPORT DATE OF ISSUE";
$fehler_class .= "*kun_reisepass_ausstellungsdatum";
}
if ($_POST['kun_adresse'] == '') {
$fehler[] = "Missing HOME ADDRESS";
$fehler_class .= "*kun_adresse";
}
if ($_POST['kun_ort'] == '') {
$fehler[] = "Missing CITY";
$fehler_class .= "*kun_ort";
}
if ($_POST['kun_plz'] == '') {
$fehler[] = "Missing POSTAL CODE";
$fehler_class .= "*kun_plz";
}
if ($_POST['kun_land'] == '') {
$fehler[] = "Missing COUNTRY";
$fehler_class .= "*kun_land";
}
if ($_POST['kun_email'] == '') {
$fehler[] = "Missing E-MAIL";
$fehler_class .= "*kun_email";
}
if ($_POST['kun_geschlecht'] == '') {
$fehler[] = "Missing SEX";
$fehler_class .= "*kun_geschlecht";
}
// if ($_POST['kun_groesse'] == '') {
// $fehler[] = "Missing HEIGHT";
// $fehler_class .= "*kun_groesse";
// }
// if ($_POST['kun_gewicht'] == '') {
// $fehler[] = "Missing WEIGHT";
// $fehler_class .= "*kun_gewicht";
// }
if ($_POST['kun_notfall_name'] == '') {
$fehler[] = "Missing NAME EMERGENCY";
$fehler_class .= "*kun_notfall_name";
}
if ($_POST['kun_notfall_tel_1'] == '') {
$fehler[] = "Missing DAYTIME PHONE EMERGENCY";
$fehler_class .= "*kun_notfall_tel_1";
}
// if ($_POST['kun_notfall_tel_2'] == '') {
// $fehler[] = "Missing AFTER HOURS PHONE EMERGENCY";
// $fehler_class .= "*kun_notfall_tel_2";
// }
if ($_POST['kun_tauchen_level'] == '') {
$fehler[] = "Missing DIVE QUALIFICATION";
$fehler_class .= "*kun_tauchen_level";
}
if ($_POST['kun_tauchen_tauchgaenge'] == '') {
$fehler[] = "Missing NUMBER OF DIVES";
$fehler_class .= "*kun_tauchen_tauchgaenge";
}
if ($_POST['kun_tauchen_letzter_tauchgang'] == '') {
$fehler[] = "Missing DATE OF LAST DIVE";
$fehler_class .= "*kun_tauchen_letzter_tauchgang";
}
if ($_POST['kun_tauchen_zertifikat'] == '') {
$fehler[] = "Missing CERTIFICATION AGENCY";
$fehler_class .= "*kun_tauchen_zertifikat";
}
if ($_POST['kun_tauchen_zertifikat_jahr'] == '') {
$fehler[] = "Missing YEAR CERTIFIED";
$fehler_class .= "*kun_tauchen_zertifikat_jahr";
}
if ($_POST['kun_umfrage_wo_gehoert'] == '') {
$fehler[] = "Missing HOW DID YOU HEAR ABOUT NAI'A";
$fehler_class .= "*kun_umfrage_wo_gehoert";
}
if (count($fehler) > 0) {
//
// Fehler enthalten
//
//
// Styles aller Fehler-Felder auf Error-Style setzen
//
$fehler_felder = explode("*", $fehler_class);
foreach($fehler_felder as $fehler_feld) {
if ($fehler_feld != '') {
$textclass[$fehler_feld] = "error";
}
}
//
// Werte vom POST übernehmen
//
foreach($datenfelder_kunde as $datenfeld => $bezeichnung) {
$row[$datenfeld] = stripslashes($_POST[$datenfeld]);
}
$row['gdd'] = $_POST['gdd'];
$row['gmm'] = $_POST['gmm'];
$row['gyyyy'] = $_POST['gyyyy'];
$row['rdd'] = $_POST['rdd'];
$row['rmm'] = $_POST['rmm'];
$row['ryyyy'] = $_POST['ryyyy'];
$row['idd'] = $_POST['idd'];
$row['imm'] = $_POST['imm'];
$row['iyyyy'] = $_POST['iyyyy'];
} else {
//
// ohne Fehler, Satz updaten
//
include ("pax_naia/include/pax_naia_kunden_datenfelder.inc.php");
//
// Kunden-Key zur Booking ID ermitteln
//
$query = "SELECT
beld_kun_key,
beld_ter_key,
beld_platz_nr,
ter_schiff,
if (YEAR(ter_von)=YEAR(ter_bis),CONCAT(DATE_FORMAT(ter_von,'%d%b'),' - ',DATE_FORMAT(ter_bis,'%d%b '),DATE_FORMAT(ter_bis,'%Y')),CONCAT(DATE_FORMAT(ter_von,'%d%b '),DATE_FORMAT(ter_von,'%Y'),' - ',DATE_FORMAT(ter_bis,'%d%b '),DATE_FORMAT(ter_bis,'%Y'))) AS datum2,
roud_name,
mai_emp_email,
mai_emp_name
FROM
".$alias."_belegung_details,
".$alias."_termine,
".$alias."_routen_details
LEFT JOIN ".$alias."_mail on mai_obj_flag='Application Form - Request' and mai_obj_key=beld_id
WHERE
beld_id='".$id."'
and ter_key=beld_ter_key
and roud_key=ter_rou_key and roud_sprache='".$sprache."'
ORDER BY
mai_datum DESC
LIMIT 1";
$rs = mysql_query($query,$db_pax);
while ($row = mysql_fetch_array($rs)) {
$kunkey = $row['beld_kun_key'];
$schiff = $row['ter_schiff'];
$terkey = $row['beld_ter_key'];
$platz = $row['beld_platz_nr'];
$datum2 = $row['datum2'];
$route = $row['roud_name'];
$abs_email = $row['mai_emp_email'];
$abs_name = $row['mai_emp_name'];
}
$query = "SELECT
*
FROM
".$alias."_kunden
WHERE
kun_key='".$kunkey."'";
$rs = mysql_query($query,$db_pax);
while ($row = mysql_fetch_array($rs)) {
//
// Änderungsprotokoll / Logfile
//
$zaehler = 0;
foreach($datenfelder_kunde as $datenfeld => $bezeichnung) {
if (stripslashes($_POST[$datenfeld]) != $row[$datenfeld]) {
if ($zaehler == 0) {
$query = "SELECT MAX(log_key) FROM ".$alias."_logfile";
$rs2 = mysql_query($query,$db_pax);
$row2 = mysql_fetch_row($rs2);
$logkey = $row2[0]+1;
$aenderungsdatum = date("Y-m-d H:i:s");
}
$zaehler++;
$query = "INSERT ".$alias."_logfile SET
log_key='".$logkey."',
log_zaehler='".$zaehler."',
log_obj_flag='KUN',
log_obj_key='".$kunkey."',
log_datum='".$aenderungsdatum."',
log_datenfeld='".$datenfeld."',
log_datenfeld_bezeichnung='".$bezeichnung."',
log_wert_alt='".addslashes($row[$datenfeld])."',
log_wert_neu='".$_POST[$datenfeld]."',
log_geaendert_von='APPLICATION FORM - Booking ID ".$id."'";
if (!mysql_query($query,$db_pax)) {echo '
ERROR - No successful INSERT of new record !!! '.$query.'
';}
}
}
}
//
// Kunden-Daten updaten
//
$query = "UPDATE ".$alias."_kunden SET ".$daten." WHERE kun_key='".$kunkey."'";
if (!mysql_query($query,$db_pax)) {echo '
ERROR - No successful UPDATE of record !!! '.$query.'
';}
//
// Belegungssatz updaten
//
$query = "UPDATE ".$alias."_belegung_details SET
beld_paxdaten_status='1',
beld_paxdaten_datum_last_reply=now()
WHERE beld_id='".$id."'";
if (!mysql_query($query,$db_pax)) {echo '
ERROR - No successful UPDATE of record !!! '.$query.'
';}
//
// Mail an Office senden
//
$mail_betreff = "UPDATE Application Form » ".trim($_POST['kun_vorname'].' '.$_POST['kun_nachname'])." » ".$datum2." » ".$route;
$mail_text = 'The application form for this booking was just updated. ';
$mail_text .= 'Click the link below to check the booking data for this booking:
ERROR - No successful INSERT of record !!! '.$query.'
';}
}
include ("pax_naia/public_website/application_form_eingabefelder.inc.php");
} else {
// *******************************************************************************************
//
// Normaler Abruf der Form mit ID (z.B. Kunde)
//
// *******************************************************************************************
//
// Belegungssatz einlesen
//
$query = "SELECT
*,
DATE_FORMAT(kun_geburtsdatum,'%d') AS gdd,
DATE_FORMAT(kun_geburtsdatum,'%m') AS gmm,
DATE_FORMAT(kun_geburtsdatum,'%Y') AS gyyyy,
DATE_FORMAT(kun_reisepass_gueltig,'%d') AS rdd,
DATE_FORMAT(kun_reisepass_gueltig,'%m') AS rmm,
DATE_FORMAT(kun_reisepass_gueltig,'%Y') AS ryyyy,
DATE_FORMAT(kun_reisepass_ausstellungsdatum,'%d') AS idd,
DATE_FORMAT(kun_reisepass_ausstellungsdatum,'%m') AS imm,
DATE_FORMAT(kun_reisepass_ausstellungsdatum,'%Y') AS iyyyy,
DATE_FORMAT(ter_von,'%d %b %Y') AS datum_von,
DATE_FORMAT(ter_bis,'%d %b %Y') AS datum_bis,
if (YEAR(ter_von)=YEAR(ter_bis),CONCAT(DATE_FORMAT(ter_von,'%d%b'),' - ',DATE_FORMAT(ter_bis,'%d%b '),DATE_FORMAT(ter_bis,'%Y')),CONCAT(DATE_FORMAT(ter_von,'%d%b '),DATE_FORMAT(ter_von,'%Y'),' - ',DATE_FORMAT(ter_bis,'%d%b '),DATE_FORMAT(ter_bis,'%Y'))) AS datum2
FROM
".$alias."_termine,
".$alias."_termine_details,
".$alias."_routen,
".$alias."_routen_details,
".$alias."_belegung,
".$alias."_belegung_details
LEFT JOIN ".$alias."_kunden on kun_key=beld_kun_key
LEFT JOIN ".$alias."_agenten on agt_key=beld_agt_key
WHERE
beld_id='".$id."'
and bel_ter_key=beld_ter_key and bel_platz_nr=beld_platz_nr
and ter_key=bel_ter_key
and terd_key=ter_key and terd_sprache='".$sprache."'
and rou_key=ter_rou_key
and roud_key=rou_key and roud_sprache='".$sprache."'";
$rs = mysql_query($query,$db_pax);
if (mysql_num_rows($rs) == 1) {
while ($row = mysql_fetch_array($rs)) {
//
// Introtext einlesen
//
$query = "SELECT
*
FROM
".$alias."_textbausteine
WHERE
txt_typ='Application Form - Introtext Application Form - Customer'";
$rs2 = mysql_query($query,$db_pax);
while ($row2 = mysql_fetch_array($rs2)) {
if ($row['kun_vorname'] != '') {
$kun_name = $row['kun_vorname']." ";
}
if ($row['kun_nachname'] != '') {
$kun_name .= $row['kun_nachname'];
}
$mailtext = $row2['txt_text_'.$sprache];
$mailtext = str_replace('[FIRST NAME CUSTOMER]', $row['kun_vorname'], $mailtext);
$mailtext = str_replace('[FULL NAME CUSTOMER]', trim($kun_name), $mailtext);
$mailtext = str_replace('[NAME AGENT]', $row['agt_agent_name'], $mailtext);
$mailtext = str_replace('[TRIP NAME]', "´".$row['roud_name']."´", $mailtext);
$mailtext = str_replace('[TRIP DATE FROM]', $row['datum_von'], $mailtext);
$mailtext = str_replace('[TRIP DATE TO]', $row['datum_bis'], $mailtext);
$mailtext = str_replace('[TRIP DATE FROM - TO]', $row['datum2'], $mailtext);
}
foreach($datenfelder_kunde as $index => $wert) {
$textclass[$index] = "text";
}
include ("pax_naia/public_website/application_form_eingabefelder.inc.php");
}
} else {
echo '
Dear Nai´a customer, we cannot locate any customer data in our booking system for the booking ID used by you ('.$id.') !