WebSVN - is - Rev 3 - /trunk/html/dum.php

is	Subversion Repositories:
[/] [trunk/] [html/] [dum.php] - Rev 3 Go to most recent revision
Compare with Previous - Blame - Download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css">
  @import "style.css" screen;
  @import "print.css" print;
</style>
<title>db.jablonka.cz - Dům </title>
</head>
<body>
<?
include ("header.htm");
require('grab_globals.lib.php');
include ("fce.php");
$spojeni = MySQL_Connect($db_host, $db_user, $db_pass);
MySQL_Select_DB($db_name);


if(!@$show) $show="all";
if(!@$order) $order="ulice,cp,byt";
if(!@$ulice) $ulice="vsechno";
if(!@$cp) $cp="vsechno";

#vybrani default trideni
if($ulice=="vsechno") {
  $condition = "";
} else {
  $condition = "AND ulice IN (\"$ulice\")";
}

switch ($cp) {
    case "vsechno":
    break;
    case "jablonecka":
        $condition = "AND cp IN (\"420/66\",\"419/64\",\"418/62\",\"417/60\",\"416/58\",\"415/56\",\"414/54\",\"413/52\",\"412/50\",\"411/48\",\"410/46\",\"409/44\",\"713/42\",\"714/40\")";
    break;
    case "sluknovska":
        $condition = "AND cp IN (\"321/2\",\"320/4\",\"319/6\",\"318/8\",\"317/10\",\"316/12\",\"315/14\",\"314/16\",\"313/18\",\"312/20\",\"311/22\")";
    break;
    case "mimonska622":
        $condition = "AND cp IN (\"622/1\",\"623/3\",\"624/5\",\"625/7\",\"626/9\",\"627/11\",\"628/13\",\"629/15\",\"630/17\",\"631/19\",\"632/21\")";
    break;
    case "mimonska633":
        $condition = "AND cp IN (\"633/24\",\"634/22\",\"635/20\",\"636/18\",\"637/16\",\"638/14\",\"639/12\",\"640/10\",\"641/8\",\"642/6\",\"643/4\")";
    break;
    case "mimonska644":
        $condition = "AND cp = \"644/2\"";
    break;
    case "martinicka":
        $condition = "AND cp IN (\"988/5A\",\"990/9\",\"988/5\",\"987/3\",\"989/7\",\"986/1\",\"990/9\")";
    break;
    default:
    $condition = "AND cp IN (\"$cp\")";
}

if(!@$show) $show="all";
if(!@$order) $order="prijmeni";
switch ($show) {
case "active":
  $where="WHERE active IN (1) $condition";
  echo '<b>Seznam aktivních uživatelů:</b> <a href="dum.php?show=inactive&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit pouze neaktivní</a> <a href="dum.php?show=all&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit vše</a>';
  break;
case "inactive":
  $where="WHERE active IN (0) $condition";
  echo '<b>Seznam neaktivních uživatelů:</b> <a href="dum.php?show=active&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit pouze aktivní</a> <a href="dum.php?show=all&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit vše</a>';
  break;
default:
  $where="WHERE active IN (0,1) $condition";
  echo '<b>Seznam všech uživatelů:</b> <a href="dum.php?show=active&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit pouze aktivní</a> <a href="dum.php?show=inactive&amp;order='.$order.'&amp;ulice='.$ulice.'&amp;cp='.$cp.'" class="odkaz">zobrazit pouze neaktivní</a>';
}

echo "\n<br><div id=\"ulice\">\n";
#tisk ulic
echo "Ulice : ";
$dotaz=MySQL_Query("SELECT DISTINCT ulice from adresy ORDER BY ulice,cp,byt");
$count=MySQL_Num_Rows($dotaz);
$count++;
for ($i=1;$i<$count;$i++)
{
  $radek=MySQL_Fetch_Array($dotaz);
  echo "<a href=\"dum.php?show=$show&amp;ulice=".$radek["ulice"]."&amp;order=$order\">".$radek["ulice"].'</a> * ';
  echo '
  ';
}
#dotisk posledni volby pro vsechny ulice
  echo "<a href=\"dum.php?show=$show&amp;ulice=vsechno&amp;order=$order\">všechno</a>";
  echo '
  ';

echo "<br>";
#tisk cisel popisnych
echo "č.p. : ";
if($ulice=="vsechno") {
$wherecp = "";
} else {
$wherecp="WHERE ulice = \"$ulice\"";
}
$dotaz=MySQL_Query("SELECT DISTINCT cp from adresy $wherecp ORDER BY cp");
$count=MySQL_Num_Rows($dotaz);
$count++;
for ($i=1;$i<$count;$i++)
{
  $radek=MySQL_Fetch_Array($dotaz);
  echo "<a href=\"dum.php?show=$show&amp;cp=".$radek["cp"]."&amp;order=$order&amp;ulice=$ulice\">".$radek["cp"].'</a> * ';
  echo '
  ';
}
#dotisk posledni volby pro vsechna cp
  echo "<a href=\"dum.php?show=$show&amp;cp=vsechno&amp;order=$order&amp;ulice=$ulice\">všechno</a>";
  echo '
  ';

echo "<br>";
echo "Domy : ";
echo "<a href=\"dum.php?show=$show&amp;cp=jablonecka&amp;order=$order&amp;ulice=Jablonecká\">Jablonecká</a> * ";
echo "<a href=\"dum.php?show=$show&amp;cp=sluknovska&amp;order=$order&amp;ulice=Šluknovská\">Šluknovská</a> * ";
echo "<a href=\"dum.php?show=$show&amp;cp=mimonska622&amp;order=$order&amp;ulice=Mimoňská\">Mimoňská 622</a> * ";
echo "<a href=\"dum.php?show=$show&amp;cp=mimonska633&amp;order=$order&amp;ulice=Mimoňská\">Mimoňská 633</a> * ";
echo "<a href=\"dum.php?show=$show&amp;cp=mimonska644&amp;order=$order&amp;ulice=Mimoňská\">Mimoňská 644</a> * ";
echo "<a href=\"dum.php?show=$show&amp;cp=martinicka&amp;order=$order&amp;ulice=Martinická\">Martinická</a> * ";


#finalni dotaz do databaze pred vypisem zvolene sestavy
$adresy=MySQL_Query("SELECT  c.id as cid, c.komentar as ckomentar, c.*, a.id as aid, a.*, i.id as iid, i.*
                        FROM (adresy a LEFT JOIN cleni c ON a.clen = c.id)
                        LEFT JOIN ipecka i ON a.id = i.adresa AND c.id = a.clen 
                        $where AND a.clen > 0 GROUP BY a.id
                        ORDER BY $order");

echo"</div><br>Ulice <b>$ulice</b>";

#tohle zapne vykresleni panelaku pro cp z panelaku
if (($ulice="Jabloneck%E1") && (1)) {
  switch ($cp) {
  case "420/66" : $cp=jablonecka; break;
  case "419/64" : $cp=jablonecka; break;
  case "418/62" : $cp=jablonecka; break;
  case "417/60" : $cp=jablonecka; break;
  case "416/58" : $cp=jablonecka; break;
  case "415/56" : $cp=jablonecka; break;
  case "414/54" : $cp=jablonecka; break;
  case "413/52" : $cp=jablonecka; break;
  case "412/50" : $cp=jablonecka; break;
  case "411/48" : $cp=jablonecka; break;
  case "410/46" : $cp=jablonecka; break;
  case "409/44" : $cp=jablonecka; break;
  case "713/42" : $cp=jablonecka; break;
  case "714/40" : $cp=jablonecka; break;
  default:
  }
}

#nastaveni parametru baraku
switch ($cp) {
    case "jablonecka":
        $bytu=3;
        $pater=10;
        $bytuvprizemi=2;
        $vchody = array(14,"420/66","419/64","418/62","417/60","416/58","415/56","414/54","413/52","412/50","411/48","410/46","409/44","713/42","714/40");
        $sizex=19;
        $sizey=10;
        $flip=false;
    break;
    case "sluknovska":
        $bytu=3;
        $pater=7;
        $bytuvprizemi=2;
        $vchody = array(11,"311/22","312/20","313/18","314/16","315/14","316/12","317/10","318/8","319/6","320/4","321/2");
        $sizex=19;
        $sizey=10;
        $flip=true;
    break;
    case "mimonska622":
        $bytu=2;
        $pater=7;
        $bytuvprizemi=2;
        $vchody = array(11,"622/1","623/3","624/5","625/7","626/9","627/11","628/13","629/15","630/17","631/19","632/21");
        $sizex=28;
        $sizey=10;
        $flip=false;
    break;
    case "mimonska633":
        $bytu=2;
        $pater=7;
        $bytuvprizemi=2;
        $vchody = array(11,"633/24","634/22","635/20","636/18","637/16","638/14","639/12","640/10","641/8","642/6","643/4");
        $sizex=28;
        $sizey=10;
        $flip=true;
    break;
    case "mimonska644":
        $bytu=7;
        $pater=3;
        $bytuvprizemi=0;
        $vchody = array(1,"644/2");
        $sizex=28;
        $sizey=10;
        $flip=false;
    break;
    case "martinicka":
        $bytu=8;
        $pater=4;
        $bytuvprizemi=8;
        $vchody = array(5,"988/5","987/3","989/7","986/1","990/9");
        $sizex=18;
        $sizey=10;
        $flip=false;
    break;
    default:
        $bytu=0;
        $pater=0;
        $bytuvprizemi=0;
        $vchody = array(0);
        $sizex=1;
        $sizey=1;
        $flip=false;
}
$bytucelkem=$bytu*($pater+1)*$vchody[0];
$bytunapatro=$bytu*$vchody[0];

#vytvoreni mapy domu z databaze
$mapa_bytu = array();
for($grid=1; $grid<=$bytucelkem; $grid++) $mapa_bytu[$grid]=false;

echo "<br>";

$pocet_vsech=0;
$pocet_pripojenych=0;
#projit vsechny nalezene adresy a predpripravit pole mapa_bytu pro snadne sekvencni vykresleni domu
if($bytucelkem) {
  while($adresa=MySQL_Fetch_Array($adresy)) {
    #zjistit jestli mame spravny cp a byt
    $cspp=$adresa["cp"];
    $byt=$adresa["byt"];
    #toto v pripade martinicke vynuti zvlastni zachazeni i pro jednotlive vchody
    if($ulice=="Martinická") {
      $cp="martinicka";
        }

    switch ($cp) {
      case "martinicka":
        $bloky = " ABCDE";
        $blok = $bloky{(round($byt/100))};
#       $cspp=$cspp.$blok;
        $vchod = cp_to_vchod($vchody,$cspp);
        $patro = round(($byt - 100*$vchod - 4.9)/10);
        $pozice = ($byt - 100*$vchod - 10*$patro);
        $grid = ($pater-$patro)*$bytunapatro+($vchod-1)*$bytu+$pozice;
        #ulozit tuto adresu s $i do pole
        $mapa_bytu[$grid]=$adresa; 
        $pocet_vsech++;
        break;
      case "mimonska644":
        $patro = substr($byt,1,1); 
        $tmp = strtr($byt,"ABCD","0123");
        $a = (int)substr($tmp,0,1)*3;
        $b = (int)substr($tmp,2,1);
        $grid = ($pater-$patro)*$bytunapatro+$a+$b+1;
        #ulozit tuto adresu s $i do pole
        $mapa_bytu[$grid]=$adresa; 
        $pocet_vsech++;
        break;
      default:
        $vchod=cp_to_vchod($vchody,$cspp);
        if( ($vchod>0) && ($byt>0) && ($byt<=($bytuvprizemi+$pater*$bytu))) { 
          $patro = round(($byt+$bytu-$bytuvprizemi)/$bytu-0.51);
          if($byt<=$bytuvprizemi) {
              $pozice=$byt-1;
              if(($bytu==3) && ($byt==2)) $pozice=2;
              if(($bytu==3) && ($byt==0)) $pozice=1;
          } else {
              $pozice = (($byt-$bytuvprizemi-1)%$bytu);
          }
          if ($flip) $pozice = ($bytu-1) - $pozice;
          #vypocitat pro tuto adresu $i neboli grid
          $grid = ($pater-$patro)*$bytunapatro+($vchod-1)*$bytu+$pozice+1;
          #echo "$cp byt $byt tam je v $vchod. vchode v $patro.patre na $pozice. pozici na gridu $grid<br>";
          #ulozit tuto adresu s $i do pole
          $mapa_bytu[$grid]=$adresa; 
          $pocet_vsech++;
        } else {
          if($byt == "obchod") {
            $byt = 0;
            $patro = round(($byt+$bytu-$bytuvprizemi)/$bytu-0.51);
            $pozice = 1;
            #vypocitat pro tuto adresu $i neboli grid
            $grid = ($pater-$patro)*$bytunapatro+($vchod-1)*$bytu+$pozice+1;
            #echo "$cp byt $byt tam je v $vchod. vchode v $patro.patre na $pozice. pozici na gridu $grid<br>";
            #ulozit tuto adresu s $i do pole
            $mapa_bytu[$grid]=$adresa; 
            #echo "byt $byt na $cspp tam je na $grid <br>";
          } else {
            echo $adresa["jmeno"]." ".$adresa["prijmeni"]." byt $byt na $cspp má adresu mimo tento dům nebo neúplnou<br>";
          }
        }
    }

}
}

#projde vchody a zkontroluje jestli dane cp je v dome a vrati poradi vchodu
#pokud nenajde vrati nulu
function cp_to_vchod($vchody,$cp) {
for($i=1; $i<=$vchody[0]; $i++):
    $cisla = explode("/",$vchody[$i]);
    if(("$cisla[0]/$cisla[1]" == $cp) || ("$cisla[1]/$cisla[0]" == $cp) || ($cisla[0] == $cp) || ($cisla[1] == $cp)) {
        return $i;
    }
endfor;
return 0;
}

if($pocet_vsech>0) mysql_data_seek($adresy,0);

#tisk domu
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
#tisk popisnych cisel
echo "<tr>";
for($i=1; $i<=$vchody[0]; $i++):
  echo "<td class=\"text\" colspan=$bytu align=\"center\"><a href=\"dum.php?show=$show&amp;cp=".$vchody["$i"]."&amp;order=$order&amp;ulice=$ulice\">$vchody[$i]</a></td>";
endfor;
echo "</tr>";


$j=0;
for($i=1; $i<=$bytucelkem; $i++) {
    $vchod=round(0.51+(($i-1)%$bytunapatro)/$bytu);
    $patro=$pater-round(($i/$bytunapatro)-0.51);
    $pozice=($i-1)%$bytu;    
    if ($flip) $pozice = ($bytu-1) - $pozice;
    if($patro==0) {
        $byt=1+$pozice;
        if($bytu==3) {
            if($pozice==1) $byt=0;
            if($pozice==2) $byt=2;
        }
    } else {
        $byt=$bytuvprizemi+($patro-1)*$bytu+$pozice+1;
    }

    #nove patro
    if ((($i-1)/$bytunapatro)*$bytunapatro == ((($i-1)/$bytunapatro)-(($i-1)%$bytunapatro))*$bytunapatro) {
        echo "<tr>\n";
    };//if

    if ($mapa_bytu[$i]) {
        $jmeno=$mapa_bytu[$i]["prijmeni"];
        $title= $mapa_bytu[$i]["prijmeni"]." ".$mapa_bytu[$i]["jmeno"]." byt ".$mapa_bytu[$i]["byt"]." IP ".$mapa_bytu[$i]["ip"];
        $active_position= 0;
        $mygrid= 11;
        if ($mapa_bytu[$i]["ip"]) {
            echo "<td><a class=\"odkaz\" target=\"_self\" href=\"clen.php?clen=".$mapa_bytu[$i]["cid"]."\">";
            echo "<img src=\"./images/green.jpg\" alt=\" $title \" title=\" $title \" border=\"0\" width=\"$sizex\" height=\"$sizey\">"; //set green cell
            echo "</a></td>";
            $pocet_pripojenych++;
        } else {
            echo "<td><a class=\"odkaz\" target=\"_self\" href=\"clen.php?clen=".$mapa_bytu[$i]["cid"]."\">";
            echo "<img src=\"./images/blue.jpg\" alt=\" $title \" title=\" $title \" border=\"0\" width=\"$sizex\" height=\"$sizey\">"; //set blue cell
            echo "</a></td>";
        };
        $j++;

    } else { //not a registered cell
        if ($vchod%2 == 0) { //alternate grey color per 3 columns
            echo "<td> <img src=\"./images/blank_light.jpg\" alt=\"nepřipojeno\" title=\"$patro.patro byt $byt\" border=\"0\" width=\"$sizex\" height=\"$sizey\"></td>";
        } else {
            echo "<td> <img src=\"./images/blank_dark.jpg\" alt=\"nepřipojeno\" title=\"$patro.patro byt $byt\" border=\"0\" width=\"$sizex\" height=\"$sizey\"></td>";
        };//if
    };//if - else

    if (($i/$bytunapatro)*$bytunapatro == (($i/$bytunapatro)-($i%$bytunapatro))*$bytunapatro) { //end of line each 42 cells
        echo "</tr>\n";
    };//if
}

echo "</table>";

if($pocet_vsech>0) {
    $celkembytu = (($bytu*$pater)+$bytuvprizemi)*$vchody[0];
    $procent_vsech=round(100*$pocet_vsech/$celkembytu,2);
    $procent_pripojenych=round(100*$pocet_pripojenych/$pocet_vsech,2);
    echo "<br>Počet všech je $pocet_vsech z $celkembytu ($procent_vsech%)<br>";
    echo "Počet připojených je $pocet_pripojenych ($procent_pripojenych%)<br>";
}

echo '

<table width="100%" class="list">
<tr bgcolor="#FFFFFF">
  <td class="text">
  <a title="seřadit podle ulice" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=ulice,cp,byt">Ulice</a>
  </td>
  <td class="text">
  <a title="seřadit podle č.p." class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=cp">č.p.</a>
  </td>
  <td class="text">
  <a title="seřadit podle bytů" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=byt">Byt</a>
  </td>
  <td >&nbsp;</td>
  <td class="text">
  <a title="seřadit podle ID" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=cid">ID</a>&nbsp;
  </td>
  <td bgcolor=#FFFFFF class=text width=80>
  <a title="se.adit podle aktivity" class=odkaz href="seznam.php?show='.$show.'&order=active">A</a>
  <a title="se.adit podle financ." class=odkaz href="seznam.php?show='.$show.'&order=finance">F</a>
  <a title="se.adit podle internetu" class=odkaz href="seznam.php?show='.$show.'&order=internet">I</a>
  <a title="se.adit podle elekt.iny" class=odkaz href="seznam.php?show='.$show.'&order=energy">E</a>
  </td>
  <td class="text">
  <a title="seřadit podle jména" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=jmeno">Jméno</a>&nbsp;
  </td>
  <td class="text">
  <a title="seřadit podle příjmení" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=prijmeni">Příjmení:</a>
  </td>
  <td class="text">
  <a title="seřadit podle mailu" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=email">email:</a>
  </td>
  <td class="text">
  <a title="seřadit podle telefonu" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=domu">Domů:</a>
  </td>
  <td class="text">
  <a title="seřadit podle mobilu" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=mobil">Mobil:</a>
  </td>
  <td class="text">
  <a title="seřadit podle pokladny" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=ip">IP</a>
  </td>
  <td class="text">
  <a title="seřadit podle komentářů" class=odkaz href="dum.php?cp='.$cp.'&amp;show='.$show.'&amp;ulice='.$ulice.'&amp;order=c.komentar">komentář</a>
  </td>
</tr>
';

#######################################################################################
#######################################################################################

$row=1;
$celkem=0;
$castkacelkem=0;
$prijmy=0;
$vydaje=0;

while($vysledek=MySQL_Fetch_Array($adresy))
{
$celkem++;

if($vysledek["id"]<1000)
{
$dot="lan.bmp";
$alt="LAN Jablonka";
}
else
{
if($vysledek["id"]==1000)
{
$dot="apy.bmp";
$alt="AP Yenik";
}
if($vysledek["id"]==1001)
{
$dot="apj.bmp";
$alt="AP Jablonecká";
}
}

$icons="";
if($show=="all" && $vysledek["active"]==2) $icons=$icons.'<img title="Čekatel" src="images/actv.gif">&nbsp;';
if($show=="all" && $vysledek["active"]==1) $icons=$icons.'<img title="Člen" src="images/actv.gif">&nbsp;';
if($show=="all" && $vysledek["active"]==0) $icons=$icons.'<img title="Pasivní" src="images/passv.gif">&nbsp;';
if($vysledek["finance"]==1) $icons=$icons.'<img title="Finance" src="images/dolar.gif">&nbsp;';
if($vysledek["internet"]==1) $icons=$icons.'<img title="Internet" src="images/net.gif">&nbsp;';
if($vysledek["energy"]==1) $icons=$icons.'<img title="Elektřina sleva" src="images/energysleva.gif">&nbsp;';
if($vysledek["energy"]==2) $icons=$icons.'<img title="Elektřina" src="images/energy.gif">&nbsp;';
echo '
<tr class="row'.$row.'">
  <td class="text">
  <a class="odkaz" target="_self" href="edit_adres.php?id='.$vysledek["aid"].'">'.$vysledek["ulice"].'</a>
  </td>
  <td class="text">'.$vysledek["cp"].'</td>
  <td class="text">'.$vysledek["byt"].'</td>
  <td class="text">&nbsp;<a class="odkaz"
  target="_self" href="clen.php?clen='.$vysledek["cid"].'"><img src="images/'.$dot.'" title="'.$alt.'" alt="'.$alt.'" border="0"></a>
  </td>
  <td class="text"><a class="odkaz" target="_self" href="edit_user.php?id='.$vysledek["cid"].'">'.$vysledek["cid"].'</a></td>
  <td class="text">'.$icons.'</td>
  <td class="text">'.$vysledek["jmeno"].'</td>
  <td class="text">'.$vysledek["prijmeni"].'</td>
  <td class="text">'.$vysledek["email"].'</td>
  <td class="text">'.$vysledek["domu"].'</td>
  <td class="text">'.$vysledek["mobil"].'</td>

  <td class="text">'.$vysledek["ip"].'</td>
  <td class="text">'.$vysledek["ckomentar"].'</td>
</tr>
';

Next($vysledek);
$row = 3-$row;
}

echo '
</table>
<br>
Celkem zobrazeno '.$celkem.' záznamů.<br>
</center>
';
?>
</body>
</html>