Changeset 273 for trunk/client
- Timestamp:
- Apr 20, 2019, 12:28:24 AM (6 years ago)
- Location:
- trunk/client/modules/Elezioni/blocchi
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/client/modules/Elezioni/blocchi/01_votanti.php
r265 r273 45 45 46 46 list($tot_aventi) = $res->fetch(PDO::FETCH_NUM); 47 $sql ?"SELECT sum(validi+nulli+bianchi+contestati) as tot,47 $sql="SELECT sum(validi+nulli+bianchi+contestati) as tot, 48 48 sum(validi),sum(nulli),sum(bianchi),sum(contestati), id_gruppo, sum(si), sum(no) 49 49 from ".$prefix."_ele_voti_ref where id_cons=$id_cons group by id_gruppo having tot>'0'"; … … 62 62 63 63 else $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();64 $res_sez = $dbi->prepare("$sql"); 65 $res_sez->execute(); 66 66 67 if($res_sez )67 if($res_sez->rowCount()) 68 68 list($numero)=$res_sez->fetch(PDO::FETCH_NUM); 69 69 else -
trunk/client/modules/Elezioni/blocchi/bar_affluenze.php
r265 r273 21 21 $sezioni=$res2->fetch(PDO::FETCH_NUM); 22 22 23 $sql="select orario,data from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' order by data desc,orario desc limit 1" , $dbi);23 $sql="select orario,data from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' order by data desc,orario desc limit 1"; 24 24 $res = $dbi->prepare("$sql"); 25 25 $res->execute(); 26 if($res ){26 if($res->rowCount()){ 27 27 28 28 while(list($orario,$data) = $res->fetch(PDO::FETCH_NUM)) { … … 50 50 else 51 51 $sql="select sum(t3.voti_complessivi),0,0 from ".$prefix."_ele_voti_parziale as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' and t3.data='$data' and t3.orario='$orario' $circos"; 52 $res l= $dbi->prepare("$sql");53 $res l->execute();52 $res1 = $dbi->prepare("$sql"); 53 $res1->execute(); 54 54 55 55 #fine modifica -
trunk/client/modules/Elezioni/blocchi/myrss.php
r130 r273 38 38 fputs($fp, "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7\r\n"); 39 39 fputs($fp, "Keep-Alive: 300\r\n"); 40 40 $cont=0; 41 41 $string = ""; 42 42 while(!feof($fp)) { -
trunk/client/modules/Elezioni/blocchi/off_Votanti.php
r265 r273 43 43 44 44 $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' $circos"; 45 $res l= $dbi->prepare("$sql");46 $res l->execute();45 $res1 = $dbi->prepare("$sql"); 46 $res1->execute(); 47 47 48 48 list($tot_aventi) = $res1->fetch(PDO::FETCH_NUM); … … 52 52 sum(t1.validi),sum(t1.nulli),sum(t1.bianchi),sum(t1.contestati), '0' 53 53 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 having tot>0"; 54 $res l= $dbi->prepare("$sql");55 $res l->execute();54 $res1 = $dbi->prepare("$sql"); 55 $res1->execute(); 56 56 57 57 }else{ … … 59 59 sum(validi),sum(nulli),sum(bianchi),sum(contestati), id_gruppo 60 60 from ".$prefix."_ele_voti_ref where id_cons=$id_cons group by id_gruppo having tot>0"; 61 $res l= $dbi->prepare("$sql");62 $res l->execute();61 $res1 = $dbi->prepare("$sql"); 62 $res1->execute(); 63 63 64 64 } -
trunk/client/modules/Elezioni/blocchi/pie_affluenze.php
r265 r273 40 40 41 41 $sql="select t3.* from ".$prefix."_ele_voti_parziale as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' and t3.data='$data' and t3.orario='$orario' $circos group by t3.id_sez "; 42 $res l= $dbi->prepare("$sql");43 $res l->execute();42 $res1 = $dbi->prepare("$sql"); 43 $res1->execute(); 44 44 45 45 $numero=$res1->rowCount();
Note:
See TracChangeset
for help on using the changeset viewer.