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

Last change on this file since 328 was 328, checked in by roby, 4 years ago

rivisto l'inserimento dati in caso di più referendum, il controllo degli errori, la scheda di riepilogo e la funzione grafici-voti del client
File size: 3.8 KB
Line 
1<?php
2if (!isset($_SESSION['aid'])) die ("You can't access this file directly...");
3global $id_cons,$id_circ,$id_sez,$dbi,$prefix,$genere;
4
5$sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
6$resc = $dbi->prepare("$sql");
7$resc->execute();
8$perr=$resc->rowCount();
9#list($saff,$stato)=$resc->fetch(PDO::FETCH_NUM);
10$sezstat=0;
11if($perr) {
12 $sezstat=1;
13 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#FF3300' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
14 $res = $dbi->prepare("$sql");
15 $res->execute();
16 }else{ #candidati
17 $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";
18 $res = $dbi->prepare("$sql");
19 $res->execute();
20 $liste=$res->rowCount();
21
22 $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";
23 $res = $dbi->prepare("$sql");
24 $res->execute();
25 list($ltot)=$res->fetch(PDO::FETCH_NUM);
26 if($liste && $liste==$ltot){
27 $sezstat=2;
28 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
29 $res = $dbi->prepare("$sql");
30 $res->execute();
31 }
32 if(!$sezstat) { #liste
33 $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
34 $res = $dbi->prepare("$sql");
35 $res->execute();
36 if($res->rowCount()>0){
37 $sezstat=3;
38 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
39 $res = $dbi->prepare("$sql");
40 $res->execute();
41 }elseif(!$sezstat){ #gruppi
42 if($genere!=4){
43 if($genere)
44 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";
45 else{
46 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";
47 $res = $dbi->prepare("$sql");
48 $res->execute();
49 $righeref=$res->rowCount();
50 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'";
51 }
52 $res = $dbi->prepare("$sql");
53 $res->execute();
54 $righe=$res->rowCount();
55 }else $righe=0;
56 if($righe){
57 $sezstat=4;
58 if($genere==0 and $righe==$righeref)
59 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
60 else $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
61 $res = $dbi->prepare("$sql");
62 $res->execute();
63 }elseif(!$sezstat){ #voti
64 $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
65 $res = $dbi->prepare("$sql");
66 $res->execute();
67 list($voti)=$res->fetch(PDO::FETCH_NUM);
68 if($voti) {
69 $sezstat=5;
70 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#F5DEB3' where id_cons='$id_cons' and id_sez='$id_sez'"; #"WHEAT"
71 $res = $dbi->prepare("$sql");
72 $res->execute();
73 }elseif(!$sezstat) {
74 $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
75 $res = $dbi->prepare("$sql");
76 $res->execute();
77 list($righe)=$res->fetch(PDO::FETCH_NUM);
78 $num_ril=$righe % 4;
79
80 if($num_ril==0) {$cursez="#DCDCDC";}#gainsboro
81 elseif($num_ril==1) {$cursez="#ADD8E6";}#lightblue
82 elseif($num_ril==2) {$cursez="#7FFFD4";} #aquamarine
83 elseif($num_ril==3) {$cursez="#E0FFFF";}#lightcyan
84 $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
85 $res = $dbi->prepare("$sql");
86 $res->execute();
87
88
89
90 }
91 }
92 }
93 }
94}
95
96
97?>
Note: See TracBrowser for help on using the repository browser.