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

Timestamp:

Oct 15, 2020, 5:40:26 PM (4 years ago)

Author:

roby

Message:

admin: sistemazione colori di stato delle sezioni e di alcuni controlli di congruenza
admin e client: verifica compatibilità con php7.4

File:

• trunk/admin/modules/Elezioni/ele_colora_sez.php (modified) (4 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;
+global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere,$id_cons_gen;
 
+$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'";
+$res = $dbi->prepare("$sql");
+$res->execute();
+list($votoc)=$res->fetch(PDO::FETCH_NUM);
 $sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
 $resc = $dbi->prepare("$sql");
@@ -14 +18 @@
         $res = $dbi->prepare("$sql");
         $res->execute();        
-        }else{ #candidati
+}else{ #candidati
         $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");
@@ -36 +40 @@
                 if($res->rowCount()>0){
                         $sezstat=3;
-                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
+                        if($genere>3 and !$votoc)
+                                $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
+                        else
+                                $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();
@@ -56 +63 @@
                         if($righe){ 
                                 $sezstat=4;
-                                if($genere==0 and $righe==$righeref)
+                                if(($genere==0 and $righe==$righeref) or $genere==1)
                                         $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE                                        
                                 else $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"