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

Timestamp:

Apr 5, 2019, 9:26:39 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/ele_colora_sez.php (modified) (3 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;
+global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere;
 
-$sql="select status from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'";
+$sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
 $resc = $dbi->prepare("$sql");
-$resc->execute(); 
-list($stato)=$resc->fetch(PDO::FETCH_NUM);
+$resc->execute();
+$perr=$resc->rowCount();
+#list($saff,$stato)=$resc->fetch(PDO::FETCH_NUM);
 $sezstat=0;
-if($stato) {
+if($perr) {
         $sezstat=1;
         $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #FF3300;' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
         $res = $dbi->prepare("$sql");
         $res->execute();        
-        }
-        
-elseif(!$sezstat){ #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 +35 @@
                 if($res->rowCount()>0){
                         $sezstat=3;
-                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #99CC33;' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
+                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #48D1CC;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
                         $res = $dbi->prepare("$sql");
                         $res->execute();
                 }elseif(!$sezstat){ #gruppi
-                        $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
+                        if($genere)
+                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
+                        else
+                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez'";
                         $res = $dbi->prepare("$sql");
                         $res->execute();
@@ -46 +48 @@
                         if($righe){ 
                                 $sezstat=4;
-                                $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #F5F5F5;' where id_cons='$id_cons' and id_sez='$id_sez'"; #whitesmoke
+                                $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #B0C4DE;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
                                 $res = $dbi->prepare("$sql");
                                 $res->execute();