1 | <?php
|
---|
2 | if (!isset($_SESSION['aid'])) die ("You can't access this file directly...");
|
---|
3 | global $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;
|
---|
11 | if($perr) {
|
---|
12 | $sezstat=1;
|
---|
13 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #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 | if($liste && $liste==$res->rowCount()){
|
---|
26 | $sezstat=2;
|
---|
27 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #99CC33;' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
|
---|
28 | $res = $dbi->prepare("$sql");
|
---|
29 | $res->execute();
|
---|
30 | }
|
---|
31 | if(!$sezstat) { #liste
|
---|
32 | $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
33 | $res = $dbi->prepare("$sql");
|
---|
34 | $res->execute();
|
---|
35 | if($res->rowCount()>0){
|
---|
36 | $sezstat=3;
|
---|
37 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #48D1CC;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
|
---|
38 | $res = $dbi->prepare("$sql");
|
---|
39 | $res->execute();
|
---|
40 | }elseif(!$sezstat){ #gruppi
|
---|
41 | if($genere)
|
---|
42 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
43 | else
|
---|
44 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
45 | $res = $dbi->prepare("$sql");
|
---|
46 | $res->execute();
|
---|
47 | $righe=$res->rowCount();
|
---|
48 | if($righe){
|
---|
49 | $sezstat=4;
|
---|
50 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #B0C4DE;' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
|
---|
51 | $res = $dbi->prepare("$sql");
|
---|
52 | $res->execute();
|
---|
53 | }elseif(!$sezstat){ #voti
|
---|
54 | $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
55 | $res = $dbi->prepare("$sql");
|
---|
56 | $res->execute();
|
---|
57 | list($voti)=$res->fetch(PDO::FETCH_NUM);
|
---|
58 | if($voti) {
|
---|
59 | $sezstat=5;
|
---|
60 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #F5F5F5;' where id_cons='$id_cons' and id_sez'=$id_sez'"; #whitesmoke
|
---|
61 | $res = $dbi->prepare("$sql");
|
---|
62 | $res->execute();
|
---|
63 | }elseif(!$sezstat) {
|
---|
64 | $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
65 | $res = $dbi->prepare("$sql");
|
---|
66 | $res->execute();
|
---|
67 | list($righe)=$res->fetch(PDO::FETCH_NUM);
|
---|
68 | $num_ril=$righe % 4;
|
---|
69 |
|
---|
70 | if($num_ril==0) {$cursez="style=\" background: #7FFFD4;";}#aquamarine
|
---|
71 | elseif($num_ril==1) {$cursez="style=\" background: #ADD8E6;";}#lightblue
|
---|
72 | elseif($num_ril==2) {$cursez="style=\" background: #DCDCDC;";}#gainsboro
|
---|
73 | elseif($num_ril==3) {$cursez="style=\" background: #E0FFFF;";}#lightcyan
|
---|
74 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
75 | $res = $dbi->prepare("$sql");
|
---|
76 | $res->execute();
|
---|
77 |
|
---|
78 |
|
---|
79 |
|
---|
80 | }
|
---|
81 | }
|
---|
82 | }
|
---|
83 | }
|
---|
84 | }
|
---|
85 |
|
---|
86 |
|
---|
87 | ?> |
---|