Changeset 278 for trunk/client


Ignore:
Timestamp:
Apr 20, 2019, 8:04:50 PM (6 years ago)
Author:
roby
Message:
 
Location:
trunk/client/modules/Elezioni
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/client/modules/Elezioni/blocchi/gom_affluenze.php

    r265 r278  
    3434
    3535                $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         $resl = $dbi->prepare("$sql");
    37         $resl->execute();
     36        $res1 = $dbi->prepare("$sql");
     37        $res1->execute();
    3838
    3939                $numero=$res1->rowCount();
  • trunk/client/modules/Elezioni/blocchi/off_Votanti.php

    r273 r278  
    2222#       $numero=mysql_num_rows($res);
    2323#       $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 ";
    2525        $res = $dbi->prepare("$sql");
    2626        $res->execute();
  • trunk/client/modules/Elezioni/index.php

    r275 r278  
    616616                }
    617617                 $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 ";
    619619        $res = $dbi->prepare("$sql");
    620620        $res->execute();
Note: See TracChangeset for help on using the changeset viewer.