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

Last change on this file was 397, checked in by roby, 8 months ago
  • ADMIN

-- Sistema di aggiornamento: per gli aggiornamenti da versioni precedenti all'attivazione di questa funzione è stato inserito l'aggiornamento forzato del DB per semplificarne la gestione
-- funzione di attribuzione dei colori di stato alle sezioni: modificata una query.
File size: 4.5 KB
RevLine 
[258]1<?php
2if (!isset($_SESSION['aid'])) die ("You can't access this file directly...");
[342]3global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere,$id_cons_gen;
[258]4
[342]5$sql="SELECT t1.voto_c,circo 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'";
[337]6$res = $dbi->prepare("$sql");
7$res->execute();
[342]8list($votoc,$circo)=$res->fetch(PDO::FETCH_NUM);
9if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco='';
[259]10$sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
[258]11$resc = $dbi->prepare("$sql");
[259]12$resc->execute();
13$perr=$resc->rowCount();
14#list($saff,$stato)=$resc->fetch(PDO::FETCH_NUM);
[258]15$sezstat=0;
[259]16if($perr) {
[258]17 $sezstat=1;
[260]18 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#FF3300' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
[258]19 $res = $dbi->prepare("$sql");
20 $res->execute();
[337]21}else{ #candidati
[397]22 $sql="SELECT t1.num_cand 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'";
[258]23 $res = $dbi->prepare("$sql");
24 $res->execute();
[264]25 $liste=$res->rowCount();
[394]26 list($listescru)=$res->fetch(PDO::FETCH_NUM);
27 if($res->rowCount() and $listescru==0) {$listescru=1;$liste=0;}
[338]28 $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco";
[258]29 $res = $dbi->prepare("$sql");
30 $res->execute();
[262]31 list($ltot)=$res->fetch(PDO::FETCH_NUM);
[394]32 if(($liste && $liste==$ltot) or $listescru){
[258]33 $sezstat=2;
[394]34 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; ;#VERDE
[258]35 $res = $dbi->prepare("$sql");
[342]36 $res->execute();
[258]37 }
38 if(!$sezstat) { #liste
[342]39 if($genere==2)
40 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
41 else
42 $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
[258]43 $res = $dbi->prepare("$sql");
44 $res->execute();
45 if($res->rowCount()>0){
46 $sezstat=3;
[337]47 if($genere>3 and !$votoc)
48 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
49 else
50 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
[258]51 $res = $dbi->prepare("$sql");
52 $res->execute();
53 }elseif(!$sezstat){ #gruppi
[262]54 if($genere!=4){
55 if($genere)
56 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";
[328]57 else{
58 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";
59 $res = $dbi->prepare("$sql");
60 $res->execute();
61 $righeref=$res->rowCount();
[262]62 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'";
[328]63 }
[262]64 $res = $dbi->prepare("$sql");
65 $res->execute();
66 $righe=$res->rowCount();
67 }else $righe=0;
[258]68 if($righe){
69 $sezstat=4;
[337]70 if(($genere==0 and $righe==$righeref) or $genere==1)
[328]71 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
72 else $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
[258]73 $res = $dbi->prepare("$sql");
74 $res->execute();
75 }elseif(!$sezstat){ #voti
76 $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
77 $res = $dbi->prepare("$sql");
78 $res->execute();
79 list($voti)=$res->fetch(PDO::FETCH_NUM);
80 if($voti) {
81 $sezstat=5;
[262]82 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#F5DEB3' where id_cons='$id_cons' and id_sez='$id_sez'"; #"WHEAT"
[258]83 $res = $dbi->prepare("$sql");
84 $res->execute();
85 }elseif(!$sezstat) {
86 $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
87 $res = $dbi->prepare("$sql");
88 $res->execute();
89 list($righe)=$res->fetch(PDO::FETCH_NUM);
90 $num_ril=$righe % 4;
91
[260]92 if($num_ril==0) {$cursez="#DCDCDC";}#gainsboro
93 elseif($num_ril==1) {$cursez="#ADD8E6";}#lightblue
94 elseif($num_ril==2) {$cursez="#7FFFD4";} #aquamarine
95 elseif($num_ril==3) {$cursez="#E0FFFF";}#lightcyan
[258]96 $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
97 $res = $dbi->prepare("$sql");
98 $res->execute();
99
100
101
102 }
103 }
104 }
105 }
106}
107
108
109?>
Note: See TracBrowser for help on using the repository browser.