source: trunk/admin/modules/Elezioni/ele_colora_sez.php@ 259

<?php
if (!isset($_SESSION['aid'])) die ("You can't access this file directly..."); 
global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere;

$sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
$resc = $dbi->prepare("$sql");
$resc->execute();
$perr=$resc->rowCount();
#list($saff,$stato)=$resc->fetch(PDO::FETCH_NUM);
$sezstat=0;
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();        
        }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");
        $res->execute();
        $liste=$res->rowCount();
        
        $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";
        $res = $dbi->prepare("$sql");
        $res->execute();
        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
                $res = $dbi->prepare("$sql");
                $res->execute();                
        }
        if(!$sezstat) { #liste
                $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
                $res = $dbi->prepare("$sql");
                $res->execute();
                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"
                        $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'";
                        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();
                        $righe=$res->rowCount();
                        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"
                                $res = $dbi->prepare("$sql");
                                $res->execute();
                        }elseif(!$sezstat){ #voti
                                $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
                                $res = $dbi->prepare("$sql");
                                $res->execute();
                                list($voti)=$res->fetch(PDO::FETCH_NUM);
                                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
                                        $res = $dbi->prepare("$sql");
                                        $res->execute(); 
                                }elseif(!$sezstat) {
                                        $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
                                        $res = $dbi->prepare("$sql");
                                        $res->execute();
                                        list($righe)=$res->fetch(PDO::FETCH_NUM);
                                        $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 
                                        $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
                                        $res = $dbi->prepare("$sql");
                                        $res->execute(); 
                                                        
                                                
                                        
                                }
                        }
                }
        }
}


?>