query($sql2); $nt2 = $result2->fetch_assoc(); if ("" == $nt2['openimmoanid']) { $micro = microtime(get_as_float); preg_match('/(?P\d+).(?P\d+)/', $micro, $zeit); $openimmoanid = "RIST".date('YmdHis', $zeit['time']).substr($zeit['micro'], 0, 3).substr(md5($micro), 3, 10); $sqls1 = 'UPDATE '.$_POST['table'].' SET openimmoanid = "'.$openimmoanid.'" WHERE WID = "'.$_POST['WID'].'";'; $stmts1 = $db->prepare($sqls1); if (!$stmts1) { die ('Datensatz konnte nicht gespeichert werden: '.$db->error); } if (!$stmts1->execute()) { die ('Datensatz konnte nicht gespeichert werden: '.$stmts1->error); } } else { $openimmoanid = $nt2['openimmoanid']; } if ("importieren" == $_POST['Modus']) { $Importmodus = "NEW"; } elseif ("aktualisieren" == $_POST['Modus']) { $Importmodus = "CHANGE"; } elseif ("loeschen" == $_POST['Modus']) { $Importmodus = "DELETE"; } preg_match('/(?\D+) (?P\d+)/', $nt2['Adresse'], $teil); if ('wkauf' == $_POST['table']) { $Vermarktungsart = "KAUF=\"1\" MIETE_PACHT=\"0\""; $Preis = " ".$nt2['Mkalt']."\n"; $Preis .= " ".$nt2['NebenK']."\n"; if ("0" != $nt2['GaraK']) { $Preis .= " \n"; } elseif ("0" != $nt2['StellK']) { $Preis .= " \n"; } $picpath = "../img/wkauf/".$_POST['WID']."/"; } elseif ('wmiete' == $_POST['table']) { $Vermarktungsart = "KAUF = \"0\" MIETE_PACHT=\"1\""; $Preis = " ".$nt2['Mkalt']."\n"; $Preis .= " ".$nt2['NebenK']."\n"; $Preis .= " ".$nt2['Kaution']."\n"; if ("0" != $nt2['GaraK']) { $Preis .= " \n"; } elseif ("0" != $nt2['StellK']) { $Preis .= " \n"; } $picpath = "../img/wmiete/".$_POST['WID']."/"; } if ('Wohnung' == $nt2['Art']) { $Objektart = ""; } elseif ('Haus' == $nt2['Art']) { $Objektart = ""; } for ($i=0; $i<10; $i++) { if ((file_exists($picpath.$i.".jpg"))){ if ('' == $nt2['FotoB'.$i.'']) { $MmATitel = 'Foto'.$i; } else { $MmATitel = $nt2['FotoB'.$i.'']; } $Anhang .= " \n"; $Anhang .= " ".$MmATitel."\n"; $Anhang .= " image/jpeg\n"; $Anhang .= " \n"; $Anhang .= " ".$_POST['WID']."_".$i.".jpg\n"; $Anhang .= " \n"; $Anhang .= " \n"; $source = $picpath.$i.".jpg"; $dest = "temp/".$_POST['WID']."_".$i.".jpg"; copy($source, $dest); } } $path = "temp/".$_POST['WID']."_st_Z9B_imt.xml"; $datei = fopen($path, "a+"); $text = ''."\n"; $text .= "\n"; $text .= " \n"; $text .= " \n"; $text .= " ".IMMOP_KD."\n"; $text .= " ".KONT_FIRMA."\n"; $text .= " ".$openimmoanid."\n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= " ".$Objektart."\n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= " ".$nt2['PLZ']."\n"; $text .= " ".$nt2['Ort']."\n"; $text .= " ".$teil['Strasse']."\n"; $text .= " ".$teil['Nr']."\n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= " ".KONT_TEL."\n"; $text .= " ".KONT_NACH."\n"; $text .= " ".KONT_VOR."\n"; $text .= " ".KONT_ANR."\n"; $text .= " ".KONT_FIRMA."\n"; $text .= " ".KONT_STR."\n"; $text .= " ".KONT_NR."\n"; $text .= " ".KONT_PLZ."\n"; $text .= " ".KONT_ORT."\n"; $text .= " \n"; $text .= " ".KONT_HOME."\n"; $text .= " \n"; $text .= " \n"; $text .= $Preis; $text .= " \n"; $text .= " \n"; $text .= " ".$nt2['WohnF']."\n"; if ("Wohnung" != $nt2['Art']) { $text .= " ".$nt2['GrundF']."\n"; } $text .= " ".$nt2['Zimmer']."\n"; $text .= " \n"; $text .= " \n"; $text .= " ".$nt2['Baujahr']."\n"; $text .= " \n"; $text .= " \n"; $text .= " ".$nt2['Kurz']."\n"; $text .= " ".$nt2['Ausstatt']."\n"; $text .= " ".$nt2['Beschreibung']."\n"; $text .= " ".$nt2['Sonst']."\n"; $text .= " \n"; if ("" != $Anhang) { $text .= " \n"; $text .= $Anhang; $text .= " \n"; } $text .= " \n"; $text .= " 0\n"; $text .= " ".$nt2['Bezug']."\n"; if ("0" != $nt2['EZahl']) { $pers = $nt2['EZahl'] + $nt2['KZahl']; $text .= " ".$pers."\n"; } if ("0" == $nt2['Raucher']) { $text .= " 1\n"; } if ("1" == $nt2['Tiere']) { $text .= " 1\n"; } $text .= " \n"; $text .= " \n"; $text .= " ".$nt2['WID']."\n"; $text .= " ".$nt2['WID']."\n"; $text .= " \n"; $text .= " ".$openimmoanid."\n"; $text .= " ".date('Y-m-d')."\n"; $text .= " \n"; $text .= " \n"; $text .= " \n"; $text .= "\n"; fwrite($datei, $text); fclose($datei); ?>