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

Timestamp:

Apr 6, 2019, 6:32:47 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/ele_colora_sez.php (modified) (6 diffs)

trunk/admin/modules/Elezioni/ele_colora_sez.php

@@ -11 +11 @@
 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
+        $sql="UPDATE ".$prefix."_ele_sezioni set colore='#FF3300' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
         $res = $dbi->prepare("$sql");
         $res->execute();        
@@ -25 +25 @@
         if($liste && $liste==$res->rowCount()){
                 $sezstat=2;
-                $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='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
                 $res = $dbi->prepare("$sql");
                 $res->execute();                
@@ -35 +35 @@
                 if($res->rowCount()>0){
                         $sezstat=3;
-                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #48D1CC;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
+                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
                         $res = $dbi->prepare("$sql");
                         $res->execute();
                 }elseif(!$sezstat){ #gruppi
                         if($genere)
-                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
+                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";
                         else
-                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez'";
+                                $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'";
                         $res = $dbi->prepare("$sql");
                         $res->execute();
@@ -48 +48 @@
                         if($righe){ 
                                 $sezstat=4;
-                                $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #B0C4DE;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
+                                $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
                                 $res = $dbi->prepare("$sql");
                                 $res->execute();
@@ -58 +58 @@
                                 if($voti) {
                                         $sezstat=5;
-                                        $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='#F5F5F5' where id_cons='$id_cons' and id_sez='$id_sez'"; #whitesmoke
                                         $res = $dbi->prepare("$sql");
                                         $res->execute(); 
@@ -68 +68 @@
                                         $num_ril=$righe % 4;
                                         
-                                        if($num_ril==0) {$cursez="style=\" background: #7FFFD4;";}#aquamarine
-                                        elseif($num_ril==1) {$cursez="style=\" background: #ADD8E6;";}#lightblue
-                                        elseif($num_ril==2) {$cursez="style=\" background: #DCDCDC;";}#gainsboro 
-                                        elseif($num_ril==3) {$cursez="style=\" background: #E0FFFF;";}#lightcyan 
+                                        if($num_ril==0) {$cursez="#DCDCDC";}#gainsboro
+                                        elseif($num_ril==1) {$cursez="#ADD8E6";}#lightblue
+                                        elseif($num_ril==2) {$cursez="#7FFFD4";} #aquamarine
+                                        elseif($num_ril==3) {$cursez="#E0FFFF";}#lightcyan 
                                         $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
                                         $res = $dbi->prepare("$sql");