Changeset 279 for trunk/client/modules/Elezioni/blocchi/pie_affluenze.php
- Timestamp:
- Apr 20, 2019, 8:32:48 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/client/modules/Elezioni/blocchi/pie_affluenze.php
r273 r279 39 39 40 40 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 ";41 $sql="select t3.id_sez 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 42 $res1 = $dbi->prepare("$sql"); 43 43 $res1->execute(); … … 54 54 #modifica del 26giugno 09 per gestione circoscrizionali 55 55 if($genere==0) { $sql="select sum(t1.voti_complessivi), t2.num_gruppo , t2.id_gruppo from ".$prefix."_ele_voti_parziale as t1 left join ".$prefix."_ele_gruppo as t2 on (t1.id_gruppo=t2.id_gruppo) where t1.id_cons='$id_cons' and t1.orario='$orario' and t1.data='$data' group by t2.num_gruppo,t2.id_gruppo order by t2.num_gruppo " ; 56 $res l= $dbi->prepare("$sql");57 $res l->execute();56 $res1 = $dbi->prepare("$sql"); 57 $res1->execute(); 58 58 59 59 }else{ 60 60 $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"; 61 $res l= $dbi->prepare("$sql");62 $res l->execute();61 $res1 = $dbi->prepare("$sql"); 62 $res1->execute(); 63 63 } 64 64 #fine modifica
Note:
See TracChangeset
for help on using the changeset viewer.