Changeset 264 for trunk

Timestamp:

Apr 7, 2019, 7:10:40 PM (5 years ago)

Author:

roby

Message:

 

Location:

trunk/admin/modules/Elezioni

Files:

• ele_colora_sez.php (modified) (1 diff)
• ele_voti.php (modified) (1 diff)
• salva_liste.php (modified) (3 diffs)

trunk/admin/modules/Elezioni/ele_colora_sez.php

@@ -15 +15 @@
         $res->execute();        
         }else{ #candidati
-        $sql="SELECT count(t2.id_lista) FROM ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on t1.id_cand=t2.id_cand where t1.id_cons='$id_cons' and t1.id_sez='$id_sez' group by t2.id_lista";
+        $sql="SELECT t2.id_lista FROM ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on t1.id_cand=t2.id_cand where t1.id_cons='$id_cons' and t1.id_sez='$id_sez' group by t2.id_lista";
         $res = $dbi->prepare("$sql");
         $res->execute();
-        list($liste)=$res->fetch(PDO::FETCH_NUM);
+        $liste=$res->rowCount();
         
         $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";

trunk/admin/modules/Elezioni/ele_voti.php

@@ -687 +687 @@
 
                 if($id_lista) {
-                        while(list($id_cand,$id_cons2,$id_lista2, $cognome, $nome, $note, $simbolo, $num_cand) = $result->fetch(PDO::FETCH_NUM)){
+                        while(list($id_cand,$id_cons2,$id_lista2,$nl, $cognome, $nome, $note, $simbolo, $num_cand) = $result->fetch(PDO::FETCH_NUM)){
                                 // dati lista
                                 $sql="select id_lista, descrizione,simbolo,num_lista from ".$prefix."_ele_lista where id_lista='$id_lista2'";

trunk/admin/modules/Elezioni/salva_liste.php

@@ -51 +51 @@
 global $prefix,$id_parz,$fileout;
 if($id_lista){
-        $sql="select num_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista' ORDER BY num_cand  ";
+        $sql="select num_cand,id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista' ORDER BY num_cand  ";
         $result = $dbi->prepare("$sql");
         $result->execute();
-        while(list($i)=$result->fetch(PDO::FETCH_BOTH)) {
+        while(list($i,$y)=$result->fetch(PDO::FETCH_NUM)) {
                 $vot="voti$i";$cand="id_cand$i";
-                if (isset($_GET[$cand])) $idcand[$i]=intval($_GET[$cand]); else $idcand[$i]='0';
+                if (isset($_GET[$cand])) $idcand[$i]=intval($_GET[$cand]); else $idcand[$i]=$y;
                 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0';
         #       if (isset($_GET[$solo])) $solog[$i]=intval($_GET[$solo]); else $solog[$i]='0';
@@ -66 +66 @@
         $result->execute();
         $sololiste=0;
-        while(list($i)=$result->fetch(PDO::FETCH_BOTH)) {
+        while(list($i)=$result->fetch(PDO::FETCH_NUM)) {
                 $vot="voti$i";$vnp="vnpl$i";$slp="slpl$i";$idlist="id_lista$i";
                 if (isset($_GET[$vnp])) $vnpl[$i]=intval($_GET[$vnp]); else $vnpl[$i]='0';
@@ -101 +101 @@
                 
         }elseif($id_lista){
-                $sql="SELECT disgiunto FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons' ";
-                $res = $dbi->prepare("$sql");
-                $res->execute();
-                list($disgiunto)=$res->fetch(PDO::FETCH_NUM);
-                if($disgiunto){ 
-                }
-                foreach($idcand as $idkey=>$idc){
-                        
+                foreach($idcand as $idkey=>$idc){                       
                         $sql="select num_cand from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' and id_cand='$idc'";
                         $result = $dbi->prepare("$sql");