Changeset 364 for trunk/client/temi

Timestamp:

Mar 30, 2022, 2:56:01 PM (3 years ago)

Author:

roby

Message:

adeguamento di alcune query alla direttiva sql_mode=only_full_group_by di mysql, sistemazione di alcuni bug.

File:

• trunk/client/temi/Futura2/function_theme.php (modified) (9 diffs)

trunk/client/temi/Futura2/function_theme.php

@@ -39 +39 @@
 
 
-        $sql="select t1.*  from ".$prefix."_ele_voti_".$tab." as t1 left join ".$prefix."_ele_$tab as t2 on t1.id_$tab=t2.id_$tab where t1.id_cons='$id_cons' $circos group by t1.id_sez ";
-                $res = $dbi->prepare("$sql");
-                $res->execute();
+        $sql="select t1.id_sez from ".$prefix."_ele_voti_".$tab." as t1 left join ".$prefix."_ele_$tab as t2 on t1.id_$tab=t2.id_$tab where t1.id_cons='$id_cons' $circos group by t1.id_sez ";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
         if($res)
                 $numero=$res->rowCount();
@@ -47 +47 @@
         $numero=1;
         $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";
-                $res = $dbi->prepare("$sql");
-                $res->execute();
+        $res = $dbi->prepare("$sql");
+        $res->execute();
         $sezioni=$res->rowCount();
         if ($numero!=0){
@@ -187 +187 @@
         if ($genere==4 or $visgralista){$tab="ele_voti_lista";}
         if ($votog){$tab="ele_voti_lista";}
-        $sql="select *  from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
-                $res = $dbi->prepare("$sql");
-                $res->execute();
+        $sql="select id_sez from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
         if ($circo){
                 $sql="select t1.*  from ".$prefix."_ele_voti_gruppo as t1, ".$prefix."_ele_gruppo as t2 where t1.id_gruppo=t2.id_gruppo and t1.id_cons='$id_cons' and t2.id_circ=$id_circ group by t1.id_sez ";
@@ -248 +248 @@
                                 left join ".$prefix."_$tab as t2 on (t1.id_gruppo=t2.id_gruppo)
                                 where   t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1
-                                group by t2.id_gruppo
+                                group by t1.id_gruppo, t1.num_gruppo, t1.descrizione
                                 order by somma desc";
                                 $cosa='id_gruppo';
@@ -474 +474 @@
         if ($circo) $circos = "and id_circ=$id_circ" ; else $circos='';
         if ($genere==0) $tab="ref"; else $tab="gruppo";
-        $sql="select *  from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons'  $circos group by id_sez ";
-                                $res = $dbi->prepare("$sql");
-                                $res->execute();
+        $sql="select id_sez from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons'  $circos group by id_sez ";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
         $numero=$res->rowCount();
         $sql="select *  from ".$prefix."_ele_sezioni where id_cons='$id_cons' $circos ";
-                                $res = $dbi->prepare("$sql");
-                                $res->execute();
+        $res = $dbi->prepare("$sql");
+        $res->execute();
         $sezioni=$res->rowCount();
         //$res = mysql_query("select chiusa  from ".$prefix."_ele_cons_comuni where id_cons='$id_cons' $circos ",$dbi);
@@ -606 +606 @@
                                 left join ".$prefix.$scelta."
                                 where t1.id_cons='$id_cons'
-                                group by t2.id_cand
-                                 
-                                order by somma desc
-                                
-                                ";
+                                group by t1.id_lista, t1.id_cand, t1.nome, t1.cognome
+                                order by somma desc";
                         $res = $dbi->prepare("$sql");
                         $res->execute();
@@ -679 +676 @@
 
         // numero sezioni 
-        $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 ";
+        $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 ";
         $sez_num = $dbi->prepare("$sql");
         $sez_num->execute();
@@ -1135 +1132 @@
         
 
-                $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'   group by t3.id_sez ";
+                $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' group by t3.id_sez ";
                 $res1 = $dbi->prepare("$sql");
                 $res1->execute();
@@ -1215 +1212 @@
 if ($genere==0) $tab="ref";
 
-        $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 ";
+        $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 ";
         $res = $dbi->prepare("$sql");
         $res->execute();