query($sql);
$wma = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Wohnung\" AND V_TYP = \"Miete\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$wmi = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Wohnung\" AND V_TYP = \"Kauf\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$wka = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Wohnung\" AND V_TYP = \"Kauf\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$wki = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Haus\" AND V_TYP = \"Miete\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$hma = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Haus\" AND V_TYP = \"Miete\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$hmi = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Haus\" AND V_TYP = \"Kauf\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$hka = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Haus\" AND V_TYP = \"Kauf\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$hki = $result->fetch_assoc();
// Berechnungen zu Wohnimmobilien
// Wohnungen
$wmg['Anz'] = $wma['Anz'] + $wmi['Anz'];
$wkg['Anz'] = $wka['Anz'] + $wki['Anz'];
$wa['Anz'] = $wma['Anz'] + $wka['Anz'];
$wi['Anz'] = $wmi['Anz'] + $wki['Anz'];
$wg['Anz'] = $wa['Anz'] + $wi['Anz'];
$wmg['Zugriffe'] = $wma['Zugriffe'] + $wmi['Zugriffe'];
$wkg['Zugriffe'] = $wka['Zugriffe'] + $wki['Zugriffe'];
$wg['Zugriffe'] = $wmg['Zugriffe'] + $wkg['Zugriffe'];
// Häuser
$hmg['Anz'] = $hma['Anz'] + $hmi['Anz'];
$hkg['Anz'] = $hka['Anz'] + $hki['Anz'];
$ha['Anz'] = $hma['Anz'] + $hka['Anz'];
$hi['Anz'] = $hmi['Anz'] + $hki['Anz'];
$hg['Anz'] = $ha['Anz'] + $hi['Anz'];
$hmg['Zugriffe'] = $hma['Zugriffe'] + $hmi['Zugriffe'];
$hkg['Zugriffe'] = $hka['Zugriffe'] + $hki['Zugriffe'];
$hg['Zugriffe'] = $hmg['Zugriffe'] + $hkg['Zugriffe'];
// Miete
$wima['Anz'] = $wma['Anz'] + $hma['Anz'];
$wimi['Anz'] = $wmi['Anz'] + $hmi['Anz'];
$wimg['Anz'] = $wima['Anz'] + $wimi['Anz'];
$wimg['Zugriffe'] = $wmg['Zugriffe'] + $hmg['Zugriffe'];
// Kauf
$wika['Anz'] = $wka['Anz'] + $hka['Anz'];
$wiki['Anz'] = $wki['Anz'] + $hki['Anz'];
$wikg['Anz'] = $wika['Anz'] + $wiki['Anz'];
$wikg['Zugriffe'] = $wkg['Zugriffe'] + $hkg['Zugriffe'];
// Alle
$wia['Anz'] = $wa['Anz'] + $ha['Anz'];
$wii['Anz'] = $wi['Anz'] + $hi['Anz'];
$wig['Anz'] = $wia['Anz'] + $wii['Anz'];
$wig['Zugriffe'] = $wg['Zugriffe'] + $hg['Zugriffe'];
// Gewerbeimmobilien - Abfrage
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND Aktiv = \"1\";";
$result = $db->query($sql);
$bpa = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND Aktiv = \"0\";";
$result = $db->query($sql);
$bpi = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND Aktiv = \"1\";";
$result = $db->query($sql);
$eia = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND Aktiv = \"0\";";
$result = $db->query($sql);
$eii = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND Aktiv = \"1\";";
$result = $db->query($sql);
$gha = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND Aktiv = \"0\";";
$result = $db->query($sql);
$ghi = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Multifunktion\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$mfa = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"Multifunktion\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$mfi = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE KAT = \"gewerbe\" AND V_TYP = \"Miete\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$gma = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE KAT = \"gewerbe\" AND V_TYP = \"Miete\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$gmi = $result->fetch_assoc();
// Berechnungen zu Gewerbeimmobilien
$bpg['Anz'] = $bpa['Anz'] + $bpi['Anz'];
$eig['Anz'] = $eia['Anz'] + $eii['Anz'];
$ghg['Anz'] = $gha['Anz'] + $ghi['Anz'];
$mfg['Anz'] = $mfa['Anz'] + $mfi['Anz'];
$bpg['Zugriffe'] = $bpa['Zugriffe'] + $bpi['Zugriffe'];
$eig['Zugriffe'] = $eia['Zugriffe'] + $eii['Zugriffe'];
$ghg['Zugriffe'] = $gha['Zugriffe'] + $ghi['Zugriffe'];
$mfg['Zugriffe'] = $mfa['Zugriffe'] + $mfi['Zugriffe'];
// Alle
$gia['Anz'] = $bpa['Anz'] + $eia['Anz'] + $gha['Anz'] + $mfa['Anz'];
$gii['Anz'] = $bpi['Anz'] + $eii['Anz'] + $ghi['Anz'] + $mfi['Anz'];
$gig['Anz'] = $bpg['Anz'] + $eig['Anz'] + $ghg['Anz'] + $mfg['Anz'];
$gig['Zugriffe'] = $bpg['Zugriffe'] + $eig['Zugriffe'] + $ghg['Zugriffe'] + $mfg['Zugriffe'];
// Gewerbe Miete
$gmg['Anz'] = $gma['Anz'] + $gmi['Anz'];
$gmg['Zugriffe'] = $gma['Zugriffe'] + $gmi['Zugriffe'];
// Gewerbe Kauf
$gka['Anz'] = $gia['Anz'] - $gma['Anz'];
$gki['Anz'] = $gii['Anz'] - $gmi['Anz'];
$gkg['Anz'] = $gka['Anz'] + $gki['Anz'];
$gkg['Zugriffe'] = $gig['Zugriffe'] - $gmg['Zugriffe'];
// Abfragen zu sonstigen Immobilien
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE KAT = \"andere\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$sia = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE KAT = \"andere\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$sii = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"ausland\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$aia = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"ausland\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$aii = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"rendite\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$ria = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"rendite\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$rii = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"grund\" AND Aktiv = \"1\";";
$result = $db->query($sql);
$gsa = $result->fetch_assoc();
$sql = "SELECT Count(*) AS Anz, SUM(Count) AS Zugriffe FROM objekte WHERE O_TYP = \"grund\" AND Aktiv = \"0\";";
$result = $db->query($sql);
$gsi = $result->fetch_assoc();
// Berechnungen zu sonstigen Immobilien
$sig['Anz'] = $sia['Anz'] + $sii['Anz'];
$aig['Anz'] = $aia['Anz'] + $aii['Anz'];
$rig['Anz'] = $ria['Anz'] + $rii['Anz'];
$gsg['Anz'] = $gsa['Anz'] + $gsi['Anz'];
$sig['Zugriffe'] = $sia['Zugriffe'] + $sii['Zugriffe'];
$aig['Zugriffe'] = $aia['Zugriffe'] + $aii['Zugriffe'];
$rig['Zugriffe'] = $ria['Zugriffe'] + $rii['Zugriffe'];
$gsg['Zugriffe'] = $gsa['Zugriffe'] + $gsi['Zugriffe'];
// Berechnungen zu allen Immobilientypen
$aoa['Anz'] = $wia['Anz'] + $gia['Anz'] + $sia['Anz'];
$aoi['Anz'] = $wii['Anz'] + $gii['Anz'] + $sii['Anz'];
$aog['Anz'] = $wig['Anz'] + $gig['Anz'] + $sig['Anz'];
$aog['Zugriffe'] = $wig['Zugriffe'] + $gig['Zugriffe'] + $sig['Zugriffe'];
echo "Übersicht
\n";
echo "\n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " | alle Immobilien | \n";
echo "
\n";
echo " \n";
echo " | Typ | \n";
echo " Aktiv | \n";
echo " Inaktiv | \n";
echo " Gesamt | \n";
echo " Zugriffe | \n";
echo "
\n";
echo " \n";
echo " | Wohnimmobilien | \n";
echo " ".$wia['Anz']." | \n";
echo " ".$wii['Anz']." | \n";
echo " ".$wig['Anz']." | \n";
echo " ".$wig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Gewerbeimmobilien | \n";
echo " ".$gia['Anz']." | \n";
echo " ".$gii['Anz']." | \n";
echo " ".$gig['Anz']." | \n";
echo " ".$gig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Sonstige Immobilien | \n";
echo " ".$sia['Anz']." | \n";
echo " ".$sii['Anz']." | \n";
echo " ".$sig['Anz']." | \n";
echo " ".$sig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Alle Immobilien | \n";
echo " ".$aoa['Anz']." | \n";
echo " ".$aoi['Anz']." | \n";
echo " ".$aog['Anz']." | \n";
echo " ".$aog['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Wohnimmobilien | \n";
echo "
\n";
echo " \n";
echo " | Typ\n";
echo " | Aktiv\n";
echo " | Inaktiv\n";
echo " | Gesamt\n";
echo " | Zugriffe\n";
echo " |
\n";
echo " \n";
echo " | Wohnungen | \n";
echo " ".$wa['Anz']." | \n";
echo " ".$wi['Anz']." | \n";
echo " ".$wg['Anz']." | \n";
echo " ".$wg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Häuser | \n";
echo " ".$ha['Anz']." | \n";
echo " ".$hi['Anz']." | \n";
echo " ".$hg['Anz']." | \n";
echo " ".$hg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | alle Wohnimmobilien | \n";
echo " ".$wia['Anz']." | \n";
echo " ".$wii['Anz']." | \n";
echo " ".$wig['Anz']." | \n";
echo " ".$wig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Mietobjekte | \n";
echo " ".$wima['Anz']." | \n";
echo " ".$wimi['Anz']." | \n";
echo " ".$wimg['Anz']." | \n";
echo " ".$wimg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Kaufobjekte | \n";
echo " ".$wika['Anz']." | \n";
echo " ".$wiki['Anz']." | \n";
echo " ".$wikg['Anz']." | \n";
echo " ".$wikg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | alle Wohnimmobilien | \n";
echo " ".$wia['Anz']." | \n";
echo " ".$wii['Anz']." | \n";
echo " ".$wig['Anz']." | \n";
echo " ".$wig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Wohnungen - Miete | \n";
echo " ".$wma['Anz']." | \n";
echo " ".$wmi['Anz']." | \n";
echo " ".$wmg['Anz']." | \n";
echo " ".$wmg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Wohnungen - Kauf | \n";
echo " ".$wka['Anz']." | \n";
echo " ".$wki['Anz']." | \n";
echo " ".$wkg['Anz']." | \n";
echo " ".$wkg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | alle Wohnungen | \n";
echo " ".$wa['Anz']." | \n";
echo " ".$wi['Anz']." | \n";
echo " ".$wg['Anz']." | \n";
echo " ".$wg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Häuser - Miete | \n";
echo " ".$hma['Anz']." | \n";
echo " ".$hmi['Anz']." | \n";
echo " ".$hmg['Anz']." | \n";
echo " ".$hmg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Häuser - Kauf | \n";
echo " ".$hka['Anz']." | \n";
echo " ".$hki['Anz']." | \n";
echo " ".$hkg['Anz']." | \n";
echo " ".$hkg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | alle Häuser | \n";
echo " ".$ha['Anz']." | \n";
echo " ".$hi['Anz']." | \n";
echo " ".$hg['Anz']." | \n";
echo " ".$hg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Gewerbeimmobilien | \n";
echo "
\n";
echo " \n";
echo " | Typ\n";
echo " | Aktiv\n";
echo " | Inaktiv\n";
echo " | Gesamt\n";
echo " | Zugriffe\n";
echo " |
\n";
echo " \n";
echo " | Büros / Praxen | \n";
echo " ".$bpa['Anz']." | \n";
echo " ".$bpi['Anz']." | \n";
echo " ".$bpg['Anz']." | \n";
echo " ".$bpg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Einzelhandel / Industrie | \n";
echo " ".$eia['Anz']." | \n";
echo " ".$eii['Anz']." | \n";
echo " ".$eig['Anz']." | \n";
echo " ".$eig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Gastronomie / Hotels | \n";
echo " ".$gha['Anz']." | \n";
echo " ".$ghi['Anz']." | \n";
echo " ".$ghg['Anz']." | \n";
echo " ".$ghg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Multifunktionsobjekte | \n";
echo " ".$mfa['Anz']." | \n";
echo " ".$mfi['Anz']." | \n";
echo " ".$mfg['Anz']." | \n";
echo " ".$mfg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Alle Gewerbeimmobilien | \n";
echo " ".$gia['Anz']." | \n";
echo " ".$gii['Anz']." | \n";
echo " ".$gig['Anz']." | \n";
echo " ".$gig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Mietobjekte | \n";
echo " ".$gma['Anz']." | \n";
echo " ".$gmi['Anz']." | \n";
echo " ".$gmg['Anz']." | \n";
echo " ".$gmg['Zugriffe']." | \n";
echo "
\n";
echo "
\n";
echo " | Kaufobjekte | \n";
echo " ".$gka['Anz']." | \n";
echo " ".$gki['Anz']." | \n";
echo " ".$gkg['Anz']." | \n";
echo " ".$gkg['Zugriffe']." | \n";
echo "
\n";
echo "
\n";
echo " | Alle Gewerbeimmobilien | \n";
echo " ".$gia['Anz']." | \n";
echo " ".$gii['Anz']." | \n";
echo " ".$gig['Anz']." | \n";
echo " ".$gig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Sonstige Immobilien | \n";
echo "
\n";
echo " \n";
echo " | Typ | \n";
echo " Aktiv | \n";
echo " Inaktiv | \n";
echo " Gesamt | \n";
echo " Zugriffe | \n";
echo "
\n";
echo " \n";
echo " | Auslandsimmobilien | \n";
echo " ".$aia['Anz']." | \n";
echo " ".$aii['Anz']." | \n";
echo " ".$aig['Anz']." | \n";
echo " ".$aig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Renditeimmobilien | \n";
echo " ".$ria['Anz']." | \n";
echo " ".$rii['Anz']." | \n";
echo " ".$rig['Anz']." | \n";
echo " ".$rig['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Grundstücke | \n";
echo " ".$gsa['Anz']." | \n";
echo " ".$gsi['Anz']." | \n";
echo " ".$gsg['Anz']." | \n";
echo " ".$gsg['Zugriffe']." | \n";
echo "
\n";
echo " \n";
echo " | Alle Immobilien | \n";
echo " ".$sia['Anz']." | \n";
echo " ".$sii['Anz']." | \n";
echo " ".$sig['Anz']." | \n";
echo " ".$sig['Zugriffe']." | \n";
echo "
\n";
echo "
\n";
echo "
\n";
}
?>