Changeset 318 for trunk/client/modules/Elezioni/consiglieri.php

Timestamp:

Jun 2, 2019, 10:04:20 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/consiglieri.php (modified) (2 diffs)

trunk/client/modules/Elezioni/consiglieri.php

@@ -637 +637 @@
                 $z=0;
                 $arvin[$x][$pos++]=$desliste[$lst]; 
-                $sql = "SELECT concat(substring(concat('0',t1.num_cand),-2),') ',t1.cognome,' ',substring(t1.nome from 1 for 1),'.') as descr,sum(t2.voti) as voti from ".$prefix."_ele_candidati as t1, ".$prefix."_ele_voti_candidati as t2 where t1.id_lista='$id_lista' and t1.id_cand=t2.id_cand GROUP BY descr order by voti desc,num_cand";
+                $sql = "SELECT concat(substring(concat('0',t1.num_cand),-2),') ',t1.cognome,' ',substring(t1.nome from 1 for 1),'.') as descr,sum(t2.voti) as voti from ".$prefix."_ele_candidati as t1, ".$prefix."_ele_voti_candidati as t2 where t1.id_lista='$id_lista' and t1.id_cand=t2.id_cand GROUP BY descr order by voti desc,t1.num_cand";
 $res_can = $dbi->prepare("$sql");
 $res_can->execute();
@@ -738 +738 @@
                 if(!$premio and $key==$gruppo) $arvin[$x][$pos++]=$desliste[$lst];
                 else $arper[$x][$pos++]=$desliste[$lst]; 
-                $sql = "SELECT concat(substring(concat('0',t1.num_cand),-2),') ',t1.cognome,' ',substring(t1.nome from 1 for 1),'.') as descr,sum(t2.voti) as voti from ".$prefix."_ele_candidati as t1, ".$prefix."_ele_voti_candidati as t2 where t1.id_lista='$id_lista' and t1.id_cand=t2.id_cand GROUP BY descr order by voti desc,num_cand";
+                $sql = "SELECT concat(substring(concat('0',t1.num_cand),-2),') ',t1.cognome,' ',substring(t1.nome from 1 for 1),'.') as descr,sum(t2.voti) as voti from ".$prefix."_ele_candidati as t1, ".$prefix."_ele_voti_candidati as t2 where t1.id_lista='$id_lista' and t1.id_cand=t2.id_cand GROUP BY descr order by voti desc,t1.num_cand";
 $res_can = $dbi->prepare("$sql");
 $res_can->execute();