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

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

admin: sistemazione colori di stato delle sezioni e di alcuni controlli di congruenza
admin e client: verifica compatibilità con php7.4
File size: 4.2 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,$id_cons_gen;
4
5$sql="SELECT t1.voto_c 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'";
6$res = $dbi->prepare("$sql");
7$res->execute();
8list($votoc)=$res->fetch(PDO::FETCH_NUM);
9$sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez'";
10$resc = $dbi->prepare("$sql");
11$resc->execute();
12$perr=$resc->rowCount();
13#list($saff,$stato)=$resc->fetch(PDO::FETCH_NUM);
14$sezstat=0;
15if($perr) {
16 $sezstat=1;
17 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#FF3300' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
18 $res = $dbi->prepare("$sql");
19 $res->execute();
20}else{ #candidati
21 $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";
22 $res = $dbi->prepare("$sql");
23 $res->execute();
24 $liste=$res->rowCount();
25
26 $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";
27 $res = $dbi->prepare("$sql");
28 $res->execute();
29 list($ltot)=$res->fetch(PDO::FETCH_NUM);
30 if($liste && $liste==$ltot){
31 $sezstat=2;
32 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
33 $res = $dbi->prepare("$sql");
34 $res->execute();
35 }
36 if(!$sezstat) { #liste
37 $sql="SELECT id_lista FROM ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'";
38 $res = $dbi->prepare("$sql");
39 $res->execute();
40 if($res->rowCount()>0){
41 $sezstat=3;
42 if($genere>3 and !$votoc)
43 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#48D1CC' where id_cons='$id_cons' and id_sez='$id_sez'"; #"MEDIUMTORQUOISE"
44 else
45 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
46 $res = $dbi->prepare("$sql");
47 $res->execute();
48 }elseif(!$sezstat){ #gruppi
49 if($genere!=4){
50 if($genere)
51 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";
52 else{
53 $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";
54 $res = $dbi->prepare("$sql");
55 $res->execute();
56 $righeref=$res->rowCount();
57 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'";
58 }
59 $res = $dbi->prepare("$sql");
60 $res->execute();
61 $righe=$res->rowCount();
62 }else $righe=0;
63 if($righe){
64 $sezstat=4;
65 if(($genere==0 and $righe==$righeref) or $genere==1)
66 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
67 else $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE"
68 $res = $dbi->prepare("$sql");
69 $res->execute();
70 }elseif(!$sezstat){ #voti
71 $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
72 $res = $dbi->prepare("$sql");
73 $res->execute();
74 list($voti)=$res->fetch(PDO::FETCH_NUM);
75 if($voti) {
76 $sezstat=5;
77 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#F5DEB3' where id_cons='$id_cons' and id_sez='$id_sez'"; #"WHEAT"
78 $res = $dbi->prepare("$sql");
79 $res->execute();
80 }elseif(!$sezstat) {
81 $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
82 $res = $dbi->prepare("$sql");
83 $res->execute();
84 list($righe)=$res->fetch(PDO::FETCH_NUM);
85 $num_ril=$righe % 4;
86
87 if($num_ril==0) {$cursez="#DCDCDC";}#gainsboro
88 elseif($num_ril==1) {$cursez="#ADD8E6";}#lightblue
89 elseif($num_ril==2) {$cursez="#7FFFD4";} #aquamarine
90 elseif($num_ril==3) {$cursez="#E0FFFF";}#lightcyan
91 $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
92 $res = $dbi->prepare("$sql");
93 $res->execute();
94
95
96
97 }
98 }
99 }
100 }
101}
102
103
104?>
Note: See TracBrowser for help on using the repository browser.