Changeset 235 for trunk/admin/modules/Elezioni/ele_riepilogo.php

Timestamp:

May 31, 2015, 1:59:14 AM (9 years ago)

Author:

roby

Message:

admin: Gestione dei voti al solo gruppo (divisi per voti senza espressione del voto di lista e con voto di lista nullo) dettagliato per singolo gruppo

Location:

trunk/admin

Files:

• . (modified) (1 prop)
• modules/Elezioni/ele_riepilogo.php (modified) (3 diffs)

trunk/admin/modules/Elezioni/ele_riepilogo.php

@@ -58 +58 @@
         ECHO "<TR><TH>".number_format($totel,0,',','.')."</TH><TH>".number_format($totm,0,',','.')."</TH><TH>".number_format($totf,0,',','.')."</TH><TH>".number_format($votm,0,',','.')."</TH><TH>".number_format($votf,0,',','.')."</TH><TH>".number_format($votc,0,',','.')."</TH></TR></table><br/>";
         ECHO "</fieldset><br/><br/><br/>";
+        
+        
         $totnulli=$nulli+$bianchi+$contestati+$votinulli;
         if ($votog) echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
@@ -64 +66 @@
         ECHO "<TR><TH>".number_format($validi,0,',','.')."</TH><TH>".number_format($nulli,0,',','.')."</TH><TH>".number_format($bianchi,0,',','.')."</TH><TH>".number_format($contestati,0,',','.')."</TH><TH>".number_format($votinulli,0,',','.')."</TH><TH>".number_format($totnulli,0,',','.')."</TH></TR></table><br/>";
         ECHO "</fieldset><br/><br/><br/>";
+        
+        
         if ($genere==5 and !$votog) {
         $totnullil=$nullilista+$contestatilista;
         $id_conf=0;
-        $res = mysql_query("SELECT t1.id_conf,t1.id_fascia, t2.limite from ".$prefix."_ele_cons_comune as t1 left join ".$prefix."_ele_conf as t2 on t1.id_conf=t2.id_conf where t1.id_cons='$id_cons'", $dbi);
-        if($res) list($id_conf,$fascia,$limite) = mysql_fetch_row($res);
+        $res = mysql_query("SELECT t1.id_conf,t1.id_fascia, t2.limite, t1.solo_gruppo from ".$prefix."_ele_cons_comune as t1 left join ".$prefix."_ele_conf as t2 on t1.id_conf=t2.id_conf where t1.id_cons='$id_cons'", $dbi);
+        if($res) list($id_conf,$fascia,$limite,$dettnulli) = mysql_fetch_row($res);
         if ($id_conf and $fascia<=$limite) {
         echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
@@ -74 +78 @@
         ECHO "<TR><TH>".number_format($validi,0,',','.')."</TH><TH>".number_format($nulli,0,',','.')."</TH><TH>".number_format($bianchi,0,',','.')."</TH><TH>".number_format($contestati,0,',','.')."</TH><TH>".number_format($votinulli,0,',','.')."</TH><TH>".number_format($totnulli,0,',','.')."</TH></TR></table><br/>";
         ECHO "</fieldset><br/><br/><br/>";
+        
         }else{
-                echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
+        if ($dettnulli){ 
+                        $res = mysql_query("SELECT id_gruppo,num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_cons='$id_cons' order by num_gruppo", $dbi);
+
+        echo "<fieldset><legend>"._GRUPPO."</legend>";
+        echo "<table border=\"1\" width=\"100%\"><tr><th colspan=\"2\" rowspan=\"2\" ALIGN=\"CENTER\"><b>Candidato</b></th><th rowspan=\"2\" ALIGN=\"CENTER\">"._VALIDI."</th><th colspan=\"2\" ALIGN=\"CENTER\">"._SOLO_GRUPPO."</th></tr><tr><th ALIGN=\"CENTER\">Senza indicazione di lista</th><th>"._VOTINULLI." di Lista</th></TR>";
+        while(list($id_gruppo,$num_gruppo,$desc) = mysql_fetch_row($res)){
+                $resv = mysql_query("SELECT sum(voti),sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_gruppo='$id_gruppo'", $dbi);
+                list($voti,$solo_gruppo)=mysql_fetch_row($resv);
+                $resv = mysql_query("SELECT sum(t1.nulli_lista) from ".$prefix."_ele_voti_lista as t1 left join ".$prefix."_ele_lista as t2 on t1.id_lista=t2.id_lista where t2.id_gruppo='$id_gruppo'", $dbi);
+                list($nulli_lista)=mysql_fetch_row($resv);
+                        
+                ECHO "<TR><TD>".$num_gruppo."</TD><TD>".$desc."</TD><TD ALIGN=\"RIGHT\">".number_format($voti,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($solo_gruppo,0,',','.')."</TD><TD ALIGN=\"RIGHT\">".number_format($nulli_lista,0,',','.')."</TD></TD></TR>";
+        }
+        ECHO "</table><br/></fieldset><br/><br/><br/>";
+
+        }
+        echo "<fieldset><legend>"._VOTI_LISTA."</legend>";
         echo "<table border=\"1\" width=\"100%\"><tr><th>"._VALIDI."</th><th>"._VOTINULLI."</th><th>"._CONTESTATI."</th>";
         // if ($genere==5 and !$votog)