Ignore:
Timestamp:
Feb 9, 2019, 8:45:24 PM (5 years ago)
Author:
roby
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/admin/modules/Elezioni/ele_riepilogo.php

    r254 r257  
    1414    die ("You can't access this file directly...");
    1515}
    16 
     16global $dbi;
    1717$aid=$_SESSION['aid'];
    18 $dbi=$_SESSION['dbi'];
    1918$prefix=$_SESSION['prefix'];
    2019$currentlang=$_SESSION['lang'];
    … …  
    2625$perms=ChiSei($id_cons_gen);
    2726if ($perms<16 or !$id_cons_gen) die("$perms Non hai i permessi per inserire dati, o non hai scelto la consultazione!");
    28 $res = mysql_query("SELECT t1.tipo_cons,t2.id_cons,t2.solo_gruppo,t2.disgiunto FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune'" , $dbi);
    29 list($tipo_cons,$id_cons,$dettnulli,$disgiunto) = mysql_fetch_row($res);
    30 $res = mysql_query("SELECT genere,voto_g,voto_l FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' " , $dbi);
    31         list($genere,$votog,$votol) = mysql_fetch_row($res);
     27$sql="SELECT t1.tipo_cons,t2.id_cons,t2.solo_gruppo,t2.disgiunto FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune'";
     28$res = $dbi->prepare("$sql");
     29$res->execute();       
     30list($tipo_cons,$id_cons,$dettnulli,$disgiunto) = $res->fetch(PDO::FETCH_NUM);
     31$sql="SELECT genere,voto_g,voto_l FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' ";
     32$res = $dbi->prepare("$sql");
     33$res->execute();       
     34list($genere,$votog,$votol) = $res->fetch(PDO::FETCH_NUM);
    3235
    3336include("modules/Elezioni/funzionidata.php");
    … …  
    4346//**************************************************************************
    4447 
    45     global $prefix, $dbi,$fascia,$limite,$genere,$votog;
    46         $res = mysql_query("SELECT sum(maschi),sum(femmine) FROM ".$prefix."_ele_sezioni where id_cons='$id_cons'", $dbi);
    47         list($totm,$totf) = mysql_fetch_row($res);
    48         $totel=$totm+$totf;
    49         $res = mysql_query("SELECT data,orario FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data desc, orario desc limit 0,1", $dbi);
    50         list($giorno,$ora)=mysql_fetch_row($res);
    51         $res = mysql_query("SELECT sum(voti_donne),sum(voti_uomini),sum(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and data='$giorno' and orario='$ora'", $dbi);
    52         list($votf,$votm,$votc) = mysql_fetch_row($res);
     48global $prefix, $dbi,$fascia,$limite,$genere,$votog;
     49$sql="SELECT sum(maschi),sum(femmine) FROM ".$prefix."_ele_sezioni where id_cons='$id_cons'";
     50$res = $dbi->prepare("$sql");
     51$res->execute();       
     52list($totm,$totf) = $res->fetch(PDO::FETCH_NUM);
     53$totel=$totm+$totf;
     54$sql="SELECT data,orario FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data desc, orario desc limit 0,1";
     55$res = $dbi->prepare("$sql");
     56$res->execute();       
     57list($giorno,$ora)=$res->fetch(PDO::FETCH_NUM);
     58$sql="SELECT sum(voti_donne),sum(voti_uomini),sum(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and data='$giorno' and orario='$ora'";
     59$res = $dbi->prepare("$sql");
     60$res->execute();       
     61list($votf,$votm,$votc) = $res->fetch(PDO::FETCH_NUM);
    5362if($genere!=0){
    54 $res = mysql_query("SELECT sum(solo_gruppo),sum(validi),sum(nulli),sum(bianchi),sum(contestati), sum(voti_nulli),sum(validi_lista),sum(voti_nulli_lista),sum(contestati_lista),sum(solo_lista) FROM ".$prefix."_ele_sezioni where id_cons=$id_cons", $dbi);
    55         list($sg,$validi,$nulli,$bianchi,$contestati,$votinulli,$validilista,$nullilista,$contestatilista,$sl)=mysql_fetch_row($res);
     63        $sql="SELECT sum(solo_gruppo),sum(validi),sum(nulli),sum(bianchi),sum(contestati), sum(voti_nulli),sum(validi_lista),sum(voti_nulli_lista),sum(contestati_lista),sum(solo_lista) FROM ".$prefix."_ele_sezioni where id_cons=$id_cons";
     64        $res = $dbi->prepare("$sql");
     65        $res->execute();       
     66        list($sg,$validi,$nulli,$bianchi,$contestati,$votinulli,$validilista,$nullilista,$contestatilista,$sl)=$res->fetch(PDO::FETCH_NUM);
    5667        echo "<center>";
    5768        echo "<fieldset><legend>"._VOTANTI."</legend>";
    5869        echo "<table border=\"1\" width=\"100%\"><tr><th>"._ISCRITTI."</TH><TH>"._UOMINI."</TH><TH>"._DONNE."</TH><TH>"._VOTIU."</TH><TH>"._VOTID."</TH><TH>"._VOTIE."</TH></TR>";
    5970        ECHO "<TR><TH>".number_format($totel,0,',','.')."</TH><TH>".number_format($totm,0,',','.')."</TH><TH>".number_format($totf,0,',','.')."</TH><TH>".number_format($votm,0,',','.')."</TH><TH>".number_format($votf,0,',','.')."</TH><TH>".number_format($votc,0,',','.')."</TH></TR></table><br/>";
    60         ECHO "</fieldset><br/><br/><br/>";
    61        
    62        
     71        ECHO "</fieldset><br/><br/><br/>";     
    6372        $totnulli=$nulli+$bianchi+$contestati+$votinulli;
    6473        if ($votog) echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
    65         else echo "<fieldset><legend>"._GRUPPO."</legend>";
    66        
     74        else echo "<fieldset><legend>"._GRUPPO."</legend>";     
    6775        echo "<table border=\"1\" width=\"100%\"><tr><th><b>"._VALIDI."</b></th><th>"._NULLI."</th><th>"._BIANCHI."</th><th>"._CONTESTATI."</th><th>"._VOTINULLI."</th><th>"._TOTNON."</th></TR>";
    6876        ECHO "<TR><TH>".number_format($validi,0,',','.')."</TH><TH>".number_format($nulli,0,',','.')."</TH><TH>".number_format($bianchi,0,',','.')."</TH><TH>".number_format($contestati,0,',','.')."</TH><TH>".number_format($votinulli,0,',','.')."</TH><TH>".number_format($totnulli,0,',','.')."</TH></TR></table><br/>";
     77        ECHO "</fieldset><br/><br/><br/>";
     78}else{
     79        $sql="SELECT sum(si),sum(no),sum(validi),sum(nulli),sum(bianchi),sum(contestati),id_gruppo FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' group by id_gruppo";
     80        $res = $dbi->prepare("$sql");
     81        $res->execute();       
     82        while (list($si,$no,$validi,$nulli,$bianchi,$contestati,$idg) = $res->fetch(PDO::FETCH_NUM)){   
     83                $sql="SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo='$idg'", $dbi);
     84                $resref = $dbi->prepare("$sql");
     85                $resref->execute();     
     86                list($numgruppo,$descrizione) = mysql_fetch_row($resref);
     87                echo "<fieldset><legend>"._GRUPPO."N. $numgruppo - $descrizione</legend>";
     88                echo "<table border=\"1\" width=\"100%\"><tr><th><b> "._SI." </b></th><th><b>"._NO."</b></th><th><b>"._VALIDI."</b></th><th>"._NULLI."</th><th>"._BIANCHI."</th><th>"._CONTESTATI."</th><th>"._TOTNON."</th></TR>";
     89                ECHO "<TR><TH>".number_format($si,0,',','.')."</TH><TH>".number_format($no,0,',','.')."</TH><TH>".number_format($validi,0,',','.')."</TH><TH>".number_format($nulli,0,',','.')."</TH><TH>".number_format($bianchi,0,',','.')."</TH><TH>".number_format($contestati,0,',','.')."</TH><TH>".number_format($nulli+$bianchi+$contestati,0,',','.')."</TH></TR></table><br/>";
     90        # votanti-------------- <th><b>"._GRUPPO."</b></th><th><b>"._DESCR."</b></th> --- <TH>".$numgruppo."</TH><TH>".$descrizione."</TH>
     91                $sql="SELECT sum(voti_donne),sum(voti_uomini),sum(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and data='$giorno' and orario='$ora' and id_gruppo='$idg'";
     92$resv = $dbi->prepare("$sql");
     93$resv->execute();       
     94                list($votf,$votm,$votc) = $resv->fetch(PDO::FETCH_NUM);
     95
     96                echo "<fieldset><legend>"._VOTANTI."</legend>";
     97                echo "<table border=\"1\" width=\"100%\"><tr><th>"._ISCRITTI."</TH><TH>"._UOMINI."</TH><TH>"._DONNE."</TH><TH>"._VOTIU."</TH><TH>"._VOTID."</TH><TH>"._VOTIE."</TH></TR>";
     98                ECHO "<TR><TH>".number_format($totel,0,',','.')."</TH><TH>".number_format($totm,0,',','.')."</TH><TH>".number_format($totf,0,',','.')."</TH><TH>".number_format($votm,0,',','.')."</TH><TH>".number_format($votf,0,',','.')."</TH><TH>".number_format($votc,0,',','.')."</TH></TR></table>";
     99                ECHO "</fieldset><br/>";
    69100                ECHO "</fieldset><br/><br/><br/>";
    70         }else{
    71         $res = mysql_query("SELECT sum(si),sum(no),sum(validi),sum(nulli),sum(bianchi),sum(contestati),id_gruppo FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' group by id_gruppo", $dbi);
    72                 while (list($si,$no,$validi,$nulli,$bianchi,$contestati,$idg) = mysql_fetch_row($res)){
    73                         $resref = mysql_query("SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo='$idg'", $dbi);
    74                         list($numgruppo,$descrizione) = mysql_fetch_row($resref);
    75                         echo "<fieldset><legend>"._GRUPPO."N. $numgruppo - $descrizione</legend>";
    76                         echo "<table border=\"1\" width=\"100%\"><tr><th><b> "._SI." </b></th><th><b>"._NO."</b></th><th><b>"._VALIDI."</b></th><th>"._NULLI."</th><th>"._BIANCHI."</th><th>"._CONTESTATI."</th><th>"._TOTNON."</th></TR>";
    77                         ECHO "<TR><TH>".number_format($si,0,',','.')."</TH><TH>".number_format($no,0,',','.')."</TH><TH>".number_format($validi,0,',','.')."</TH><TH>".number_format($nulli,0,',','.')."</TH><TH>".number_format($bianchi,0,',','.')."</TH><TH>".number_format($contestati,0,',','.')."</TH><TH>".number_format($nulli+$bianchi+$contestati,0,',','.')."</TH></TR></table><br/>";
    78                 # votanti-------------- <th><b>"._GRUPPO."</b></th><th><b>"._DESCR."</b></th> --- <TH>".$numgruppo."</TH><TH>".$descrizione."</TH>
    79                         $resv = mysql_query("SELECT sum(voti_donne),sum(voti_uomini),sum(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and data='$giorno' and orario='$ora' and id_gruppo='$idg'", $dbi);
    80                         list($votf,$votm,$votc) = mysql_fetch_row($resv);
    81101
    82                         echo "<fieldset><legend>"._VOTANTI."</legend>";
    83                         echo "<table border=\"1\" width=\"100%\"><tr><th>"._ISCRITTI."</TH><TH>"._UOMINI."</TH><TH>"._DONNE."</TH><TH>"._VOTIU."</TH><TH>"._VOTID."</TH><TH>"._VOTIE."</TH></TR>";
    84                         ECHO "<TR><TH>".number_format($totel,0,',','.')."</TH><TH>".number_format($totm,0,',','.')."</TH><TH>".number_format($totf,0,',','.')."</TH><TH>".number_format($votm,0,',','.')."</TH><TH>".number_format($votf,0,',','.')."</TH><TH>".number_format($votc,0,',','.')."</TH></TR></table>";
    85                         ECHO "</fieldset><br/>";
    86                         ECHO "</fieldset><br/><br/><br/>";
    87 
    88                 #-----------                   
    89                 }
     102        #-----------                   
    90103        }
     104}
    91105       
    92         if ($genere==5 and !$votog) {
    93         $totnullil=$nullilista+$contestatilista;
    94         $id_conf=0;
    95         $res = mysql_query("SELECT t1.id_conf,t1.id_fascia, t2.limite, t1.solo_gruppo from ".$prefix."_ele_cons_comune as t1 left join ".$prefix."_ele_conf as t2 on t1.id_conf=t2.id_conf where t1.id_cons='$id_cons'", $dbi);
    96         if($res) list($id_conf,$fascia,$limite,$dettnulli) = mysql_fetch_row($res);
    97         if ($id_conf and $fascia<=$limite) {
     106if ($genere==5 and !$votog) {
     107$totnullil=$nullilista+$contestatilista;
     108$id_conf=0;
     109$sql="SELECT t1.id_conf,t1.id_fascia, t2.limite, t1.solo_gruppo from ".$prefix."_ele_cons_comune as t1 left join ".$prefix."_ele_conf as t2 on t1.id_conf=t2.id_conf where t1.id_cons='$id_cons'";
     110$res = $dbi->prepare("$sql");
     111$res->execute();       
     112if($res->rowCount()) list($id_conf,$fascia,$limite,$dettnulli) = $res->fetch(PDO::FETCH_NUM);
     113if ($id_conf and $fascia<=$limite) {
    98114        echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
    99115        echo "<table border=\"1\" width=\"100%\"><tr><th><b>"._VALIDI."</b></th><th>"._NULLI."</th><th>"._BIANCHI."</th><th>"._CONTESTATI."</th><th>"._VOTINULLI."</th><th>"._TOTNON."</th></TR>";
    … …  
    101117        ECHO "</fieldset><br/><br/><br/>";
    102118       
    103         }else{
     119}else{
    104120        if ($dettnulli or $disgiunto){
    105                         $res = mysql_query("SELECT id_gruppo,num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_cons='$id_cons' order by num_gruppo", $dbi);
    106 
    107         echo "<fieldset><legend>"._GRUPPO."</legend>";
    108         echo "<table border=\"1\" width=\"100%\"><tr><th colspan=\"2\" rowspan=\"2\" ALIGN=\"CENTER\"><b>Candidato</b></th><th rowspan=\"2\" ALIGN=\"CENTER\">"._VALIDI."</th><th colspan=\"2\" ALIGN=\"CENTER\">"._SOLO_GRUPPO."</th></tr><tr><th ALIGN=\"CENTER\">Senza indicazione di lista</th>";
    109         if ($disgiunto) echo "<th>"._SOLOLIS."</th>"; else echo "<th>"._VOTINULLI." di Lista</th>";
    110         echo "</TR>";
    111         $t_voti=0;$t_solo_gruppo=0;$t_nulli_lista=0;
    112         while(list($id_gruppo,$num_gruppo,$desc) = mysql_fetch_row($res)){
    113                 $resv = mysql_query("SELECT sum(voti),sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_gruppo='$id_gruppo'", $dbi);
    114                 list($voti,$solo_gruppo)=mysql_fetch_row($resv);
    115                 if($disgiunto){
    116                         $resv = mysql_query("SELECT sum(t1.solo_lista) from ".$prefix."_ele_voti_lista as t1 left join ".$prefix."_ele_lista as t2 on t1.id_lista=t2.id_lista where t2.id_gruppo='$id_gruppo'", $dbi);         
    117                 }else{
    118                         $resv = mysql_query("SELECT sum(t1.nulli_lista) from ".$prefix."_ele_voti_lista as t1 left join ".$prefix."_ele_lista as t2 on t1.id_lista=t2.id_lista where t2.id_gruppo='$id_gruppo'", $dbi);
     121                $sql="SELECT id_gruppo,num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_cons='$id_cons' order by num_gruppo";
     122                $res = $dbi->prepare("$sql");
     123                $res->execute();       
     124                echo "<fieldset><legend>"._GRUPPO."</legend>";
     125                echo "<table border=\"1\" width=\"100%\"><tr><th colspan=\"2\" rowspan=\"2\" ALIGN=\"CENTER\"><b>Candidato</b></th><th rowspan=\"2\" ALIGN=\"CENTER\">"._VALIDI."</th><th colspan=\"2\" ALIGN=\"CENTER\">"._SOLO_GRUPPO."</th></tr><tr><th ALIGN=\"CENTER\">Senza indicazione di lista</th>";
     126                if ($disgiunto) echo "<th>"._SOLOLIS."</th>"; else echo "<th>"._VOTINULLI." di Lista</th>";
     127                echo "</TR>";
     128                $t_voti=0;$t_solo_gruppo=0;$t_nulli_lista=0;
     129                while(list($id_gruppo,$num_gruppo,$desc) = $res->fetch(PDO::FETCH_NUM)){
     130                        $sql="SELECT sum(voti),sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_gruppo='$id_gruppo'";
     131                        $resv = $dbi->prepare("$sql");
     132                        $resv->execute();       
     133                        list($voti,$solo_gruppo)=$resv->fetch(PDO::FETCH_NUM);
     134                        if($disgiunto){
     135                                $sql="SELECT sum(t1.solo_lista) from ".$prefix."_ele_voti_lista as t1 left join ".$prefix."_ele_lista as t2 on t1.id_lista=t2.id_lista where t2.id_gruppo='$id_gruppo'";                               
     136                        }else{
     137                                $sql="SELECT sum(t1.nulli_lista) from ".$prefix."_ele_voti_lista as t1 left join ".$prefix."_ele_lista as t2 on t1.id_lista=t2.id_lista where t2.id_gruppo='$id_gruppo'";
     138                        }
     139                        $resv = $dbi->prepare("$sql");
     140                        $resv->execute();       
     141                        list($perlista)=$resv->fetch(PDO::FETCH_NUM);
     142                        $t_voti+=$voti;$t_solo_gruppo+=$solo_gruppo;$t_perlista+=$perlista;     
     143                        ECHO "<TR><TD>".$num_gruppo."</TD><TD>".$desc."</TD><TD ALIGN=\"RIGHT\">".number_format($voti,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($solo_gruppo,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($perlista,0,',','.')."</TD></TD></TR>";
    119144                }
    120                 list($perlista)=mysql_fetch_row($resv);
    121                 $t_voti+=$voti;$t_solo_gruppo+=$solo_gruppo;$t_perlista+=$perlista;     
    122                 ECHO "<TR><TD>".$num_gruppo."</TD><TD>".$desc."</TD><TD ALIGN=\"RIGHT\">".number_format($voti,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($solo_gruppo,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($perlista,0,',','.')."</TD></TD></TR>";
    123         }
    124         echo "<tr><th colspan=\"2\" rowspan=\"2\" ALIGN=\"CENTER\"><b>Totale</b></th><th rowspan=\"2\"  ALIGN=\"RIGHT\">$t_voti</th><th ALIGN=\"RIGHT\">$t_solo_gruppo</th><th ALIGN=\"RIGHT\">$t_perlista</th></tr>";
    125         ECHO "</table><br/></fieldset><br/><br/><br/>";
    126 
     145                echo "<tr><th colspan=\"2\" rowspan=\"2\" ALIGN=\"CENTER\"><b>Totale</b></th><th rowspan=\"2\"  ALIGN=\"RIGHT\">$t_voti</th><th ALIGN=\"RIGHT\">$t_solo_gruppo</th><th ALIGN=\"RIGHT\">$t_perlista</th></tr>";
     146                ECHO "</table><br/></fieldset><br/><br/><br/>";
    127147        }
    128148        echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
    129149        echo "<table border=\"1\" width=\"100%\"><tr><th>"._VALIDI."</th><th>"._VOTINULLI."</th><th>"._CONTESTATI."</th>";
    130150        // if ($genere==5 and !$votog)
    131                 echo "<th>"._SOLO_GRUPPO."</th>";
     151        echo "<th>"._SOLO_GRUPPO."</th>";
    132152        echo "<th>"._TOTNON."</th></TR>";
    133 
    134                 ECHO "<TR><TH>".number_format($validilista,0,',','.')."</TH><TH>".number_format($nullilista,0,',','.')."</TH><TH>".number_format($contestatilista,0,',','.')."</TH>";
     153        ECHO "<TR><TH>".number_format($validilista,0,',','.')."</TH><TH>".number_format($nullilista,0,',','.')."</TH><TH>".number_format($contestatilista,0,',','.')."</TH>";
    135154        if($genere==5 and !$votog)
    136155                echo "<TH>".number_format($sg,0,',','.')."</TH>";
    … …  
    138157        ECHO "</fieldset>";
    139158        }
    140         }
    141         echo "</center>";
    142        
    143        
    144        
     159}
     160echo "</center>";
    145161echo "</table>\n</td></tr></table>\n";
    146 
    147    include ("footer.php");
     162include ("footer.php");
    148163
    149164?>
Note: See TracChangeset for help on using the changeset viewer.