Ignore:
Timestamp:
Apr 13, 2019, 8:05:15 PM (5 years ago)
Author:
roby
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/client/modules/Elezioni/blocchi/01_votanti.php

    r177 r265  
    2323        if ($genere!=0) { // referendum
    2424
    25         $res = mysql_query("select sum(t1.maschi+t1.femmine)   from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' and validi>0 $circos",$dbi);
    26         list($tot_aventi)  = mysql_fetch_row($res);
     25        $sql="select sum(t1.maschi+t1.femmine)   from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' and validi>0 $circos";
     26        $res = $dbi->prepare("$sql");
     27        $res->execute();
    2728
    28         $res = mysql_query("select sum(t1.validi+t1.nulli+t1.bianchi+t1.contestati) as tot,
     29        list($tot_aventi)  = $res->fetch(PDO::FETCH_NUM);
     30
     31        $sql="select sum(t1.validi+t1.nulli+t1.bianchi+t1.contestati) as tot,
    2932                sum(t1.validi),sum(t1.nulli),sum(t1.bianchi),sum(t1.contestati), '0', '0', '0'
    30                 from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' and validi>0 $circos",$dbi);
     33                from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' and validi>0 $circos";
     34        $res = $dbi->prepare("$sql");
     35        $res->execute();
     36
    3137
    3238        }else{
    … …  
    3440
    3541
    36         $res = mysql_query("SELECT sum(maschi+femmine) FROM ".$prefix."_ele_sezioni where id_cons='$id_cons'",$dbi);
    37         list($tot_aventi)  = mysql_fetch_row($res);
    38                 $res = mysql_query("SELECT  sum(validi+nulli+bianchi+contestati) as tot,
     42        $sql="SELECT sum(maschi+femmine) FROM ".$prefix."_ele_sezioni where id_cons='$id_cons'";
     43        $res = $dbi->prepare("$sql");
     44        $res->execute();
     45
     46        list($tot_aventi)  = $res->fetch(PDO::FETCH_NUM);
     47                $sql?"SELECT  sum(validi+nulli+bianchi+contestati) as tot,
    3948                sum(validi),sum(nulli),sum(bianchi),sum(contestati), id_gruppo, sum(si), sum(no)
    40                 from ".$prefix."_ele_voti_ref  where id_cons=$id_cons group by id_gruppo having tot>'0'",$dbi);
     49                from ".$prefix."_ele_voti_ref  where id_cons=$id_cons group by id_gruppo having tot>'0'";
     50                $res = $dbi->prepare("$sql");
     51                $res->execute();
     52
    4153        }
    4254
    4355        $i=0;
    4456
    45         while (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id,$si,$no) = mysql_fetch_row($res)){
     57        while (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id,$si,$no) = $res->fetch(PDO::FETCH_NUM)){
    4658
    4759# calcolo sezioni
    48 if($genere==0) $res_sez = mysql_query("select count(0) from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons' and id_gruppo='$id'", $dbi);
    49 else $res_sez = mysql_query("select count(0) from ".$prefix."_ele_sezioni where id_cons='$id_cons' and validi+nulli+bianchi+contestati>0", $dbi);
     60if($genere==0) $sql="select count(0) from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons' and id_gruppo='$id'";
     61       
     62
     63else $sql="select count(0) from ".$prefix."_ele_sezioni where id_cons='$id_cons' and validi+nulli+bianchi+contestati>0";
     64$res = $dbi->prepare("$sql");
     65$res->execute();
     66
    5067if($res_sez)
    51         list($numero)=mysql_fetch_row($res_sez);
     68        list($numero)=$res_sez->fetch(PDO::FETCH_NUM);
    5269else
    5370        $numero=0;
    54 $res_sez = mysql_query("select t3.* from ".$prefix."_ele_voti_".$tab." as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join
    55 ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' $circos group by t3.id_sez ",$dbi);
    56 $res_sez = mysql_query("select t1.* from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos",$dbi);
    57 $sezioni=mysql_num_rows($res_sez);
     71$sql="select t3.* from ".$prefix."_ele_voti_".$tab." as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join
     72".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' $circos group by t3.id_sez ";
     73        $res_sez = $dbi->prepare("$sql");
     74        $res_sez->execute();
     75
     76$sql="select t1.* from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos";
     77        $res_sez = $dbi->prepare("$sql");
     78        $res_sez->execute();
     79 
     80$sezioni=$res_sez->rowCount();
    5881
    5982                $tot_votanti=$validi+$bianchi+$nulli+$contestati;
    … …  
    7598
    7699                if ($genere==0) {
    77                         $resg = mysql_query("SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id",$dbi);
    78                         list($num_gruppo,$descr_gruppo)  = mysql_fetch_row($resg);
     100                        $sql="SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id";
     101                        $resg = $dbi->prepare("$sql");
     102                        $resg->execute();
     103
     104                        list($num_gruppo,$descr_gruppo)  = $resg->fetch(PDO::FETCH_NUM);
    79105                }
    80106                 
Note: See TracChangeset for help on using the changeset viewer.