Changeset 342 for trunk/admin/modules/Elezioni/ele_colora_sez.php

Timestamp:

Nov 18, 2020, 11:05:49 PM (3 years ago)

Author:

roby

Message:

Ulteriori adeguamenti per la rev 338

File:

• trunk/admin/modules/Elezioni/ele_colora_sez.php (modified) (2 diffs)

trunk/admin/modules/Elezioni/ele_colora_sez.php

@@ -1 +1 @@
 <?php
 if (!isset($_SESSION['aid'])) die ("You can't access this file directly..."); 
-global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere,$id_cons_gen,$circo;
+global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere,$id_cons_gen;
 
-if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco=''; 
-$sql="SELECT t1.voto_c FROM ".$prefix."_ele_tipo as t1 left join ".$prefix."_ele_consultazione as t2 on t1.tipo_cons=t2.tipo_cons where id_cons_gen='$id_cons_gen'";
+$sql="SELECT t1.voto_c,circo FROM ".$prefix."_ele_tipo as t1 left join ".$prefix."_ele_consultazione as t2 on t1.tipo_cons=t2.tipo_cons where id_cons_gen='$id_cons_gen'";
 $res = $dbi->prepare("$sql");
 $res->execute();
-list($votoc)=$res->fetch(PDO::FETCH_NUM);
+list($votoc,$circo)=$res->fetch(PDO::FETCH_NUM);
+if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco=''; 
 $sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
 $resc = $dbi->prepare("$sql");
@@ -33 +33 @@
                 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
                 $res = $dbi->prepare("$sql");
-                $res->execute();                
+                $res->execute();        
         }
         if(!$sezstat) { #liste
-                $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
+                if($genere==2)
+                        $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
+                else
+                        $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
                 $res = $dbi->prepare("$sql");
                 $res->execute();