Changeset 278 for trunk/client
- Timestamp:
- Apr 20, 2019, 8:04:50 PM (6 years ago)
- Location:
- trunk/client/modules/Elezioni
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/client/modules/Elezioni/blocchi/gom_affluenze.php
r265 r278 34 34 35 35 $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 "; 36 $res l= $dbi->prepare("$sql");37 $res l->execute();36 $res1 = $dbi->prepare("$sql"); 37 $res1->execute(); 38 38 39 39 $numero=$res1->rowCount(); -
trunk/client/modules/Elezioni/blocchi/off_Votanti.php
r273 r278 22 22 # $numero=mysql_num_rows($res); 23 23 # $res = mysql_query("select * from ".$prefix."_ele_sezioni where id_cons='$id_cons'",$dbi); 24 $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 ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' $circos group by t3.id_sez ";24 $sql="select t3.id_sez from ".$prefix."_ele_voti_".$tab." 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' $circos group by t3.id_sez "; 25 25 $res = $dbi->prepare("$sql"); 26 26 $res->execute(); -
trunk/client/modules/Elezioni/index.php
r275 r278 616 616 } 617 617 $sql="select t1.id_sez,sum(t1.voti) from ".$prefix."_ele_voti_$tab as t1, ".$prefix."_ele_$tab as t2 where t1.id_$tab=t2.id_$tab and t1.id_cons='$id_cons' and t2.id_circ='$id_circ' group by t1.id_sez"; 618 }else $sql="select *from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons' group by id_sez ";618 }else $sql="select id_cons from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons' group by id_sez "; 619 619 $res = $dbi->prepare("$sql"); 620 620 $res->execute();
Note:
See TracChangeset
for help on using the changeset viewer.