1 | <?php
|
---|
2 | /************************************************************************/
|
---|
3 | /* Eleonline - Raccolta e diffusione dei dati elettorali */
|
---|
4 | /* by Luciano Apolito & Roberto Gigli */
|
---|
5 | /* http://www.eleonline.it */
|
---|
6 | /* info@eleonline.it rgigli@libero.it */
|
---|
7 | /************************************************************************/
|
---|
8 |
|
---|
9 | if (!defined('ADMIN_FILE')) {
|
---|
10 | die ("You can't access this file directly...");
|
---|
11 | }
|
---|
12 |
|
---|
13 | ########################################
|
---|
14 | # Affluenze
|
---|
15 | function votanti($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops,$ov,$mv,$gv,$msv,$av){
|
---|
16 |
|
---|
17 | global $aid, $prefix, $dbi,$tipo_cons,$genere,$id_cons_gen,$id_comune,$ops;
|
---|
18 | ##################
|
---|
19 | echo "<style>";
|
---|
20 | echo "DIV.table";
|
---|
21 | echo "{
|
---|
22 | display:table;
|
---|
23 | }
|
---|
24 | FORM.tr
|
---|
25 | {
|
---|
26 | display:table-row;
|
---|
27 | text-align: center;
|
---|
28 | }
|
---|
29 | DIV.tr
|
---|
30 | {
|
---|
31 | display:table-row;
|
---|
32 | background-color: #D3D3D3;
|
---|
33 | text-align: center;
|
---|
34 | }
|
---|
35 | SPAN.tdm
|
---|
36 | {
|
---|
37 | display:table-cell;
|
---|
38 | border: 1px solid black;
|
---|
39 | padding: 5px;
|
---|
40 | }
|
---|
41 | SPAN.td
|
---|
42 | {
|
---|
43 | display:table-cell;
|
---|
44 | }";
|
---|
45 | echo "</style>";
|
---|
46 |
|
---|
47 |
|
---|
48 | ##################
|
---|
49 | $bgcolor1="#7777ff";
|
---|
50 | $bgcolor2=$_SESSION['bgcolor2'];
|
---|
51 | $sql="SELECT vismf from ".$prefix."_ele_cons_comune where id_cons='$id_cons'";
|
---|
52 | $res = $dbi->prepare("$sql");
|
---|
53 | $res->execute();
|
---|
54 | if($res) list($vismf)= $res->fetch(PDO::FETCH_NUM); else $vismf=0;
|
---|
55 | $sql="SELECT orario,data FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data,orario ";
|
---|
56 | $res = $dbi->prepare("$sql");
|
---|
57 | $res->execute();
|
---|
58 | $num = $res->rowCount();
|
---|
59 | echo "<table><tr><td>";
|
---|
60 | $sql="SELECT maschi,femmine FROM ".$prefix."_ele_sezioni where id_sez=$id_sez";#echo $sql;
|
---|
61 | $ressez = $dbi->prepare("$sql");
|
---|
62 | $ressez->execute();
|
---|
63 | list($maschi,$femmine)=$ressez->fetch(PDO::FETCH_NUM);
|
---|
64 |
|
---|
65 | $afferr=0;
|
---|
66 | $sql="select tipo from ".$prefix."_ele_controlli where id_sez='$id_sez' and tipo='affluenze'";
|
---|
67 | $rese = $dbi->prepare("$sql");
|
---|
68 | $rese->execute();
|
---|
69 | if($rese->rowCount()) $afferr=1;
|
---|
70 |
|
---|
71 | $y=0;
|
---|
72 |
|
---|
73 | $riga=array();
|
---|
74 | $rigat=array();
|
---|
75 | $uscita=0;
|
---|
76 | while (list($ora,$giorno)= $res->fetch(PDO::FETCH_NUM)){
|
---|
77 | $y++;
|
---|
78 | $rigat[$y]='';
|
---|
79 | $riga[$y]='';
|
---|
80 | $rigat[$y]= "<div class=\"tr\">";
|
---|
81 | if ($genere==0){ //e' un referendum
|
---|
82 | $rigat[$y].= "<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\" width=\"32\"><b>"._NUM."</b></span>";
|
---|
83 | }
|
---|
84 | $rigat[$y].= "<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\" width=\"32\"><b>"._ORA."</b></span>"
|
---|
85 | ."<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\" width=\"32\"><b>"._DATA."</b></span>";
|
---|
86 | $rigat[$y].= "<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\"><b>"._VOTIU."</b></span>";
|
---|
87 | $rigat[$y].= "<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\"><b>"._VOTID."</b></span>"
|
---|
88 | ."<span class=\"tdm\" bgcolor=\"$bgcolor1\" align=\"center\"><b>"._VOTIT."</b></span>";
|
---|
89 | if ($genere==0){
|
---|
90 | $sql="SELECT * FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' ";
|
---|
91 | $res2 = $dbi->prepare("$sql");
|
---|
92 | $res2->execute();
|
---|
93 | $max = $res2->rowCount();
|
---|
94 | }else{ $max=1;}
|
---|
95 | $op="rec_add_votanti";
|
---|
96 | $rigat[$y].= "</div>";
|
---|
97 | $errvot1=0;
|
---|
98 | $numril=0;
|
---|
99 |
|
---|
100 | for ($i=1;$i<=$max;$i++){
|
---|
101 | $query="SELECT * FROM ".$prefix."_ele_voti_parziale as t1 left join ".$prefix."_ele_gruppo as t2
|
---|
102 | on (t1.id_gruppo=t2.id_gruppo) where t1.id_sez='$id_sez'
|
---|
103 | and t1.id_cons='$id_cons' and t1.orario='$ora' and t1.data='$giorno'";
|
---|
104 | if ($genere==0){
|
---|
105 | $query.=" and t2.num_gruppo=$i";
|
---|
106 | }
|
---|
107 | $sql=$query;
|
---|
108 | $result = $dbi->prepare("$sql");
|
---|
109 | $result->execute();
|
---|
110 | list($id_cons2,$id_sez2,$id_parz,$orario,$data, $voti_u, $voti_d, $voti_t,$id_gruppo) = $result->fetch(PDO::FETCH_NUM);
|
---|
111 | $sql="SELECT num_gruppo FROM ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo' ";
|
---|
112 | $res2 = $dbi->prepare("$sql");
|
---|
113 | $res2->execute();
|
---|
114 | $sql="select count(0) FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
115 | $resril = $dbi->prepare("$sql");
|
---|
116 | $resril->execute();
|
---|
117 | list($tmpril)=$resril->fetch(PDO::FETCH_NUM);
|
---|
118 | if($tmpril>$numril) $numril=$tmpril;
|
---|
119 | if ($res2)
|
---|
120 | list($gruppo)= $res2->fetch(PDO::FETCH_NUM);
|
---|
121 | else
|
---|
122 | $gruppo=0;
|
---|
123 | if (!$gruppo>0) {
|
---|
124 | $gruppo=$i;
|
---|
125 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where num_gruppo=$gruppo and id_cons=$id_cons";
|
---|
126 | $res3 = $dbi->prepare("$sql");
|
---|
127 | $res3->execute();
|
---|
128 | if ($res3)
|
---|
129 | list($id_gruppo)=$res3->fetch(PDO::FETCH_NUM);
|
---|
130 | }
|
---|
131 | if(!isset($precede[$id_gruppo])) $precede[$id_gruppo]=0; if(!isset($error)) $error=0;
|
---|
132 | if($precede[$id_gruppo]>($voti_t) and $voti_t!='') $error=1;
|
---|
133 | $precede[$id_gruppo]=$voti_t;
|
---|
134 | if (($voti_u+$voti_d and $voti_u+$voti_d!=$voti_t) or $error){
|
---|
135 | $riga[$y].= "<form class=\"tr\" data-ajax=\"false\" style=\"background-color: rgb(255, 0, 0); text-align: center\" name=\"votanti\" action=\"modules/Elezioni/salva_aff.php\">";
|
---|
136 | }else{
|
---|
137 | $riga[$y].= "<form class=\"tr\" data-ajax=\"false\" action=\"modules/Elezioni/salva_aff.php\">";
|
---|
138 | }
|
---|
139 | if ($genere==0){ // e' un referendum
|
---|
140 | $riga[$y].= "<span class=\"td\" align=\"center\">$gruppo</span>";
|
---|
141 | }
|
---|
142 | $riga[$y].= "<span class=\"td\"><input type=\"hidden\" name=\"op\" value=\"rec_add_votanti\"/>";
|
---|
143 | $riga[$y].= "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"/>"
|
---|
144 | ."<input type=\"hidden\" name=\"genere\" value=\"$genere\"/>"
|
---|
145 | ."<input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\"/>"
|
---|
146 | ."<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\"/>"
|
---|
147 | ."<input type=\"hidden\" name=\"id_sede\" value=\"$id_sede\"/>";
|
---|
148 | list ($anno,$mese,$di)=explode('-',$giorno);
|
---|
149 | $riga[$y].= "$ora</span><span class=\"td\" align=\"center\">$di-$mese-$anno</span>";
|
---|
150 | if ($voti_u > $maschi) {$riga[$y].= "<span class=\"td\" align=\"center\" bgcolor=\"red\">"; $errvot1=1;}
|
---|
151 | else $riga[$y].= "<span class=\"td\" align=\"center\">";
|
---|
152 | if ($y<$num and $vismf==0 and $voti_u==0) { $riga[$y].= "<input type=\"hidden\" id=\"voti_u$y$i\" name=\"voti_u\" value=\"'$voti_u'\"";}else $riga[$y].= "<input type=\"text\" style=\"text-align:right\" id=\"voti_u$y$i\" name=\"voti_u\" value=\"$voti_u\" onfocus=\"select();\"";
|
---|
153 | $riga[$y].= " size=\"5\"/></span>";
|
---|
154 | if ($voti_d > $femmine) {$riga[$y].= "<span class=\"td\" align=\"center\" bgcolor=\"red\">"; $errvot1=1;}
|
---|
155 | else $riga[$y].= "<span class=\"td\" align=\"center\">";
|
---|
156 | if ($y<$num and $vismf==0 and $voti_d==0) { $riga[$y].= "<input type=\"hidden\" id=\"voti_d$y$i\" name=\"voti_d\" value=\"'$voti_d'\"";}else $riga[$y].= "<input type=\"text\" style=\"text-align:right\" id=\"voti_d$y$i\" name=\"voti_d\" value=\"$voti_d\" onfocus=\"select();\"";
|
---|
157 | $riga[$y].= " size=\"5\"/></span>";
|
---|
158 | if ($voti_t > ($maschi+$femmine)) {$riga[$y].= "<span class=\"td\" align=\"center\" bgcolor=\"red\" ><input type=\"text\" id=\"voti_t$y$i\" name=\"voti_t\" value=\"$voti_t\" size=\"5\" style=\"text-align:right\" onfocus=\"select();\"/>"; $errvot1=1;}
|
---|
159 | else $riga[$y].= "<span class=\"td\" align=\"center\"><input id=\"voti_t$y$i\" name=\"voti_t\" value=\"$voti_t\" size=\"5\" style=\"text-align:right\" onfocus=\"select();\"/>";
|
---|
160 | $riga[$y].= "<input type=\"hidden\" name=\"id_parz\" value=\"$id_parz\"/>"
|
---|
161 | ."<input type=\"hidden\" name=\"data\" value=\"$giorno\"/>"
|
---|
162 | ."<input type=\"hidden\" name=\"orario\" value=\"$ora\"/>"
|
---|
163 | ."<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\"/>"
|
---|
164 | ."<input type=\"hidden\" name=\"id_gruppo\" value=\"$id_gruppo\"/>";
|
---|
165 | $riga[$y].= "</span>";
|
---|
166 | if (chisei($id_cons_gen)>=64 and $y==$numril) { $riga[$y].= "<span class=\"td\" style=\"text-align: right;\" rowspan=\"1\" colspan=\"6\">"._DELETE." <input type=\"checkbox\" name=\"delete\" value=\"true\"/></span>";}
|
---|
167 | else $riga[$y].= "<span class=\"td\" style=\"text-align: right;\" rowspan=\"1\" colspan=\"6\"><input type=\"hidden\" name=\"delete\" value=\"\"/></span>";
|
---|
168 | $riga[$y].= "<span class=\"td\" style=\"text-align: right;\" rowspan=\"1\" colspan=\"6\"><input type=\"submit\" name=\"update\" value=\""._OK."\"/></span>";
|
---|
169 | $riga[$y].= "</form>";
|
---|
170 | if($numril>$uscita) $uscita=$numril;
|
---|
171 | }
|
---|
172 | # echo "</div>";
|
---|
173 | $sql="select count(voti_complessivi) from ".$prefix."_ele_voti_parziale where data='$giorno' and orario='$ora' and id_sez=$id_sez";
|
---|
174 | $compl = $dbi->prepare("$sql");
|
---|
175 | $compl->execute();
|
---|
176 | list ($complessivi)= $compl->fetch(PDO::FETCH_NUM);
|
---|
177 | }
|
---|
178 | # echo "Errori:";
|
---|
179 | if($errvot1) echo "<table><tr><td align=\"center\" bgcolor=\"red\"> <h1 style=\"color:white;\">I votanti inseriti superano il numero di elettori</h1></td></tr></table></br>";
|
---|
180 | if($error) echo "<table><tr><td align=\"center\" bgcolor=\"red\"> <h1 style=\"color:white;\">Numero di votanti inferiore della rilevazione precedente</h1></td></tr></table></br>";
|
---|
181 | echo "<table border=\"1\"><tr><td><b>Iscritti nella sezione</b> Maschi: $maschi - Femmine: $femmine - Totale: ".($maschi+$femmine)."</td></tr></table></br>";
|
---|
182 | foreach($riga as $key=>$val){
|
---|
183 | echo $rigat[$key];
|
---|
184 | echo $riga[$key];
|
---|
185 | if($key>$uscita) { break;}
|
---|
186 | }
|
---|
187 | echo "</div></td></tr></table>";
|
---|
188 | }
|
---|
189 |
|
---|
190 |
|
---|
191 | //////////////////////////////////////////////////////////////////////
|
---|
192 | // da qui va la sezione per le preferenze candidati consiglieri
|
---|
193 | //////////////////////////////////////////////////////////////////////
|
---|
194 | function preferenze($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops){
|
---|
195 | global $aid, $prefix, $dbi, $id_lista,$genere,$id_cons_gen,$id_gruppo,$sezi,$circo,$votog,$votol,$votoc,$conscirc,$op;
|
---|
196 | global $tipo_cons,$limite,$dettnulli,$disgiunto,$votoc;
|
---|
197 | $bgcolor1="#7777ff";
|
---|
198 | $bgcolor2=$_SESSION['bgcolor2'];
|
---|
199 | echo "<SCRIPT type=\"text/javascript\">\n";
|
---|
200 | echo "function vai_lista(idrif){\n";
|
---|
201 | echo "var element=document.getElementById('pag')\n";
|
---|
202 | echo "var elista=document.getElementById(idrif)\n";
|
---|
203 | echo "var url=element.value+elista.value\n";
|
---|
204 | echo "window.document.location.href=url \n";
|
---|
205 | echo "}\n";
|
---|
206 | echo "</script>\n";
|
---|
207 | if ($genere==4){
|
---|
208 | $sql="SELECT voti_uomini,voti_donne, voti_complessivi FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_cons='$id_cons' order by data desc,orario desc limit 0,1";
|
---|
209 | $result = $dbi->prepare("$sql");
|
---|
210 | $result->execute();
|
---|
211 |
|
---|
212 |
|
---|
213 | list( $voti_u, $voti_d, $voti_t) = $result->fetch(PDO::FETCH_NUM);
|
---|
214 | echo "<table class=\"table-menu\" style=\"width: 50%; color: black;\">"
|
---|
215 | ."<tr><td></td><td align=\"center\"></td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTIU."</td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTID."</td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTIT."</td></tr>"
|
---|
216 | ."<tr><td></td><td bgcolor=\"$bgcolor1\" align=\"center\">"._TOT_ULT."</td><td bgcolor=\"$bgcolor2\" align=\"center\">$voti_u</td><td align=\"center\" bgcolor=\"$bgcolor2\">$voti_d</td><td bgcolor=\"$bgcolor2\" align=\"center\">$voti_t</td></tr>";
|
---|
217 | echo "</table>";
|
---|
218 | }
|
---|
219 | $sql="select validi,nulli,bianchi,contestati from ".$prefix."_ele_sezioni where id_sez='$id_sez' ";
|
---|
220 | $result = $dbi->prepare("$sql");
|
---|
221 | $result->execute();
|
---|
222 | list($v1,$v2,$v3,$v4)=$result->fetch(PDO::FETCH_NUM);
|
---|
223 | if($v1+$v2+$v3+$v4>0){
|
---|
224 | //controlla se sono stati inseriti i votanti
|
---|
225 | $sql="SELECT preferenze, id_fascia, id_conf,solo_gruppo, disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons'";
|
---|
226 | $result = $dbi->prepare("$sql");
|
---|
227 | $result->execute();
|
---|
228 |
|
---|
229 |
|
---|
230 | list($numprefs,$fascia,$id_conf,$flagsg,$disgiunto)=$result->fetch(PDO::FETCH_NUM);
|
---|
231 | $dettnulli=$flagsg;
|
---|
232 | ####### 06-11-2014 - circoscrizionali - nello spostamento ad altra sezione resta sullo stesso numero di lista anche se sono sezioni di diverse circoscrizioni
|
---|
233 | if ($circo and $id_lista){
|
---|
234 | $sql="SELECT id_circ from ".$prefix."_ele_lista where id_lista=$id_lista";
|
---|
235 | $result = $dbi->prepare("$sql");
|
---|
236 | $result->execute();
|
---|
237 | list($tmp_circ)=$result->fetch(PDO::FETCH_NUM);
|
---|
238 | if($tmp_circ==$id_circ){
|
---|
239 | $sql="SELECT num_lista from ".$prefix."_ele_lista where id_lista=$id_lista";
|
---|
240 | $res_lis = $dbi->prepare("$sql");
|
---|
241 | $res_lis->execute();
|
---|
242 | list($num_lista)=$res_lis->fetch(PDO::FETCH_NUM);
|
---|
243 | } else $id_lista=0;
|
---|
244 | }
|
---|
245 |
|
---|
246 | if(!$votog and ($genere==3 or $genere==5)){
|
---|
247 | $sql="select validi_lista,nulli,bianchi,contestati_lista,voti_nulli_lista from ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
248 | $result = $dbi->prepare("$sql");
|
---|
249 | $result->execute();
|
---|
250 |
|
---|
251 |
|
---|
252 | }else{
|
---|
253 | $sql="select validi,nulli,bianchi,contestati,voti_nulli from ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
254 | $result = $dbi->prepare("$sql");
|
---|
255 | $result->execute();
|
---|
256 | }
|
---|
257 |
|
---|
258 | list($validi,$nulli,$bianchi,$contestati,$votinulli) = $result->fetch(PDO::FETCH_NUM);
|
---|
259 | echo "<table class=\"table-menu\" style=\"width: 100%;\"><tr>";
|
---|
260 | $sql="SELECT id_lista, descrizione,num_lista from ".$prefix."_ele_lista where id_cons=$id_cons $circo order by num_lista";
|
---|
261 | $res_lis = $dbi->prepare("$sql");
|
---|
262 | $res_lis->execute();
|
---|
263 |
|
---|
264 |
|
---|
265 | $num_liste = $res_lis->rowCount();
|
---|
266 | $ele_lista='';
|
---|
267 | if (($genere==4 or $genere==5) and !$votoc) { //liste a piu' candidati
|
---|
268 | if(($genere==5 and $id_conf and $fascia<=$limite and !$disgiunto) and !$id_lista) { //esclude il voto di lista per le comunali nei comuni sotto fascia limite
|
---|
269 | $sql="SELECT id_lista from ".$prefix."_ele_lista where id_cons=$id_cons $circo order by num_lista limit 0,1";
|
---|
270 | $result = $dbi->prepare("$sql");
|
---|
271 | $result->execute();
|
---|
272 |
|
---|
273 |
|
---|
274 | list($id_lista)=$result->fetch(PDO::FETCH_NUM);
|
---|
275 | }
|
---|
276 | echo "<td colspan=\"2\">";
|
---|
277 | echo "<form name=\"liste\" data-ajax=\"false\" action=\"admin.php\">"; # data-ajax=\"false\"
|
---|
278 | echo "<input type=\"hidden\" id=\"pag\" name=\"pag\" value=\"admin.php?id_cons_gen=$id_cons_gen&op=$op&id_sez=$id_sez&id_circ=$id_circ&id_sede=$id_sede&do=spoglio&ops=3&id_lista=\">";
|
---|
279 | echo "<select id=\"id_lista\" name=\"id_lista\" onChange=\"vai_lista('id_lista');\">";
|
---|
280 | if ($id_lista){
|
---|
281 | echo "<option value=\"0\">"._VOTI_LISTA;
|
---|
282 | $ele_lista=" and t1.id_lista='$id_lista' ";
|
---|
283 | }else{
|
---|
284 | echo "<option value=\"0\" selected>"._VOTI_LISTA;
|
---|
285 | $ele_lista=" group by t1.id_lista ";
|
---|
286 | if(!isset($votolista)) $votolista=0;
|
---|
287 | }
|
---|
288 | $preflis[]=array();
|
---|
289 | while(list($id_rif,$descrizione,$num_lis) = $res_lis->fetch(PDO::FETCH_NUM)) {
|
---|
290 | $segna='';
|
---|
291 | $sql="SELECT t1.voti from ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on (t1.id_cand=t2.id_cand) where t1.id_sez=$id_sez and t2.id_lista=$id_rif limit 0,1";
|
---|
292 | $result = $dbi->prepare("$sql");
|
---|
293 | $result->execute();
|
---|
294 | if($result->rowCount()) $ctrvoticand=1; else $ctrvoticand=0;
|
---|
295 | $sql="SELECT sum(t1.voti),0,0 from ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on (t1.id_cand=t2.id_cand) where t1.id_sez=$id_sez and t2.id_lista=$id_rif";
|
---|
296 | $result = $dbi->prepare("$sql");
|
---|
297 | $result->execute();
|
---|
298 | list($votisezcand)=$result->fetch(PDO::FETCH_NUM);
|
---|
299 | if((($fascia>$limite or $disgiunto) or !$id_conf) or $genere==4){
|
---|
300 | $sql="SELECT voti,solo_lista from ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista='$id_rif'";
|
---|
301 | $result = $dbi->prepare("$sql");
|
---|
302 | $result->execute();
|
---|
303 | }else{
|
---|
304 | $sql="SELECT id_gruppo from ".$prefix."_ele_lista where id_lista='$id_rif'";
|
---|
305 | $result = $dbi->prepare("$sql");
|
---|
306 | $result->execute();
|
---|
307 | list($id_gruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
308 | $sql="SELECT sum(voti),0 from ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
309 | $result = $dbi->prepare("$sql");
|
---|
310 | $result->execute();
|
---|
311 | }
|
---|
312 | list($votisezlis,$sgpl)=$result->fetch(PDO::FETCH_NUM);
|
---|
313 | $preflis[$id_rif]=$votisezlis;
|
---|
314 | if($votisezcand>($votisezlis*$numprefs))
|
---|
315 | {$segna="style=\"background-color: #dd0000;\""; }#$segna2=$segna;
|
---|
316 | elseif($ctrvoticand)
|
---|
317 | $segna="style=\"background-color: #99CC33;\"";
|
---|
318 | $sql="SELECT t1.voti,t2.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' and t2.id_lista='$id_rif'";
|
---|
319 | $res4 = $dbi->prepare("$sql");
|
---|
320 | $res4->execute();
|
---|
321 | $errcand[$id_rif]=array();
|
---|
322 | while(list($testvotic,$numcand)=$res4->fetch(PDO::FETCH_NUM))
|
---|
323 | {if($votisezlis<$testvotic) { $segna="style=\"background-color: #dd0000;\"";$errcand[$id_rif][]=$numcand;}}
|
---|
324 | $sel = ($id_rif == $id_lista) ? "selected" : "";
|
---|
325 | echo "<option $segna value=\"$id_rif\" $sel>";
|
---|
326 | for ($j=strlen($num_lis);$j<2;$j++) { echo " ";}
|
---|
327 | echo $num_lis.") ".$descrizione;
|
---|
328 | # echo $num_lis.") ".substr($descrizione,0,30);
|
---|
329 | }
|
---|
330 | echo "</select></form></td></tr><tr><td style=\"vertical-align: top;\"> </td>\n";
|
---|
331 | }else {
|
---|
332 | $id_lista=0;
|
---|
333 | }
|
---|
334 | echo "<td style=\"vertical-align: top;\">";
|
---|
335 | if ((!$id_lista)){$tab="_ele_voti_lista";} else {$tab="_ele_voti_candidati";}
|
---|
336 | if(($genere==4 or ($genere==5 and $votog)) and !$id_lista) {
|
---|
337 | $sql="SELECT sum(t1.voti),t2.validi, t2.solo_gruppo,t2.contestati_lista,t2.voti_nulli,t2.bianchi,t2.nulli,t2.contestati,0,0 from ".$prefix."_ele_sezioni as t2 left join ".$prefix.$tab." as t1 on (t1.id_sez=t2.id_sez) where t2.id_sez=$id_sez group by t1.id_sez";
|
---|
338 | $result = $dbi->prepare("$sql");
|
---|
339 | $result->execute();
|
---|
340 | }else{
|
---|
341 | $sql="SELECT sum(t1.voti),t2.validi_lista, t2.solo_gruppo,t2.contestati_lista,t2.voti_nulli_lista,t2.bianchi,t2.nulli,t2.contestati,t2.voti_nulli,t2.solo_gruppo,t1.id_sez from ".$prefix."_ele_sezioni as t2 left join ".$prefix.$tab." as t1 on (t1.id_sez=t2.id_sez) where t2.id_sez='$id_sez' group by t1.id_sez,t2.validi_lista, t2.solo_gruppo,t2.contestati_lista,t2.voti_nulli_lista,t2.bianchi,t2.nulli,t2.contestati,t2.voti_nulli,t2.solo_gruppo";
|
---|
342 | $result = $dbi->prepare("$sql");
|
---|
343 | $result->execute();
|
---|
344 | }
|
---|
345 |
|
---|
346 | // aggiunte le variabili $sgpl e $vnulli2 per la gestione dei voti 1) al solo presidente per singola lista - 2) al solo presidente per singola lista perché nullo o contestato quello di lista
|
---|
347 | $isscr= $result->rowCount();
|
---|
348 | list( $voti_sez, $validi2, $sg,$cont2,$vnulli2,$bia2,$nul2,$con2,$vnul2,$sgpl) = $result->fetch(PDO::FETCH_NUM);
|
---|
349 | if(($genere==5 and !$disgiunto and $voti_sez and $flagsg and ($tipo_cons==18 or $tipo_cons==19))){
|
---|
350 | $sql="SELECT sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_cons=$id_cons and id_sez=$id_sez";
|
---|
351 | $resg = $dbi->prepare("$sql");
|
---|
352 | $resg->execute();
|
---|
353 | list($sgpl)=$resg->fetch(PDO::FETCH_NUM);
|
---|
354 | if ($sg != $sgpl) echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_UNI." ".$sgpl." "._ATT_TOT_UNI." ".$sg."</b><br></td></table>";
|
---|
355 | }
|
---|
356 | $valista=$validi2;
|
---|
357 | ####### controlli
|
---|
358 | $sql="select * from ".$prefix."_ele_controlli where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
359 | $resc = $dbi->prepare("$sql");
|
---|
360 | $resc->execute();
|
---|
361 | if($resc->rowCount()){
|
---|
362 | if(!$id_lista or $genere==3){ //controllo di congruenza
|
---|
363 | $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
364 | $res2 = $dbi->prepare("$sql");
|
---|
365 | $res2->execute();
|
---|
366 | list($tot) = $res2->fetch(PDO::FETCH_NUM);
|
---|
367 | if ($validi2+$vnulli2+$cont2+$sg+$bia2+$nul2+$con2+$vnul2!=$tot and $validi+$sg>0){
|
---|
368 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTANTI." ".$tot." "._NO_TOT_VOTI." ".($validi2+$vnulli2+$cont2+$sg+$bia2+$nul2+$con2+$vnul2)."</b><br></td></table>";
|
---|
369 | }
|
---|
370 | if((($voti_sez)!=$validi2) and ($voti_sez>0)){
|
---|
371 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTI." ".($voti_sez)." "._NO_VAL_VOTI." ".$validi2."</b><br></td></tr></table>";
|
---|
372 | }
|
---|
373 | }
|
---|
374 | if($genere==5 or $genere==4){
|
---|
375 | if($id_lista){
|
---|
376 | $sql="SELECT max(t1.voti),sum(t1.voti) from ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on (t1.id_cand=t2.id_cand) where t1.id_sez=$id_sez and t2.id_lista='$id_lista'";
|
---|
377 | $result = $dbi->prepare("$sql");
|
---|
378 | $result->execute();
|
---|
379 | list($votimaxcand,$votisezcand)=$result->fetch(PDO::FETCH_NUM);
|
---|
380 | if(($fascia>$limite or $disgiunto) or !$id_conf){
|
---|
381 | $sql="SELECT sum(t2.voti) from ".$prefix."_ele_voti_lista as t2 where t2.id_sez='$id_sez' and t2.id_lista='$id_lista'";
|
---|
382 | $result = $dbi->prepare("$sql");
|
---|
383 | $result->execute();
|
---|
384 | }else{
|
---|
385 | $sql="SELECT id_gruppo from ".$prefix."_ele_lista where id_lista='$id_lista'";
|
---|
386 | $result = $dbi->prepare("$sql");
|
---|
387 | $result->execute();
|
---|
388 | list($id_gruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
389 | $sql="SELECT sum(voti) from ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
390 | $result = $dbi->prepare("$sql");
|
---|
391 | $result->execute();
|
---|
392 | }
|
---|
393 | list($votisezlis)=$result->fetch(PDO::FETCH_NUM);
|
---|
394 | $errpres=0;
|
---|
395 | if($votisezcand>($votisezlis*$numprefs))
|
---|
396 | {
|
---|
397 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti di preferenza $votisezcand <br/>superano quelli ammessi ".$votisezlis*$numprefs."</b><br></td></tr></table>";
|
---|
398 | $segna2="style=\"background-color: #dd0000;\"";
|
---|
399 | $errpres=1;
|
---|
400 | }
|
---|
401 | if($votimaxcand>$votisezlis and !$errpres)
|
---|
402 | {
|
---|
403 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti di preferenza di un candidato $votimaxcand <br/>superano i voti di lista $votisezlis</b><br></td></tr></table>";
|
---|
404 | $segna2="style=\"background-color: #dd0000;\"";
|
---|
405 | }
|
---|
406 |
|
---|
407 | }#else{
|
---|
408 | $sql="select solo_gruppo from ".$prefix."_ele_sezioni where id_sez='$id_sez' ";
|
---|
409 | $resgs = $dbi->prepare("$sql");
|
---|
410 | $resgs->execute();
|
---|
411 | list($sgs3)=$resgs->fetch(PDO::FETCH_NUM);
|
---|
412 | $sql="select sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' ";
|
---|
413 | $resgs = $dbi->prepare("$sql");
|
---|
414 | $resgs->execute();
|
---|
415 | list($vsg3)=$resgs->fetch(PDO::FETCH_NUM);
|
---|
416 | if($sgs3!=$vsg3 and $flagsg)
|
---|
417 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti al solo gruppo: $sgs3 non corrispondono a quelli inseriti nella scheda dei gruppi $vsg3 </b><br></td></tr></table>";
|
---|
418 |
|
---|
419 | }
|
---|
420 | #die("TEST: if($sgs3!=$vsg3)");
|
---|
421 | #controllo voti a liste collegate <= voto di gruppo per voto non disgiunto
|
---|
422 | $errgrulis=array();
|
---|
423 | if($genere==5 and !$disgiunto and ($tipo_cons==18 or $tipo_cons==19)){
|
---|
424 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo";
|
---|
425 | $resref = $dbi->prepare("$sql");
|
---|
426 | $resref->execute();
|
---|
427 | # die("qui: $sql");
|
---|
428 | $sql="SELECT count(0) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez'";
|
---|
429 | $res4 = $dbi->prepare("$sql");
|
---|
430 | $res4->execute();
|
---|
431 | list($sezscrl)=$res4->fetch(PDO::FETCH_NUM);
|
---|
432 | if ($sezscrl)
|
---|
433 | while ( list($id_gruppo)=$resref->fetch(PDO::FETCH_NUM))
|
---|
434 | {
|
---|
435 | $sql="SELECT sum(voti),sum(solo_gruppo) FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
436 | $res3 = $dbi->prepare("$sql");
|
---|
437 | $res3->execute();
|
---|
438 | $sql="SELECT sum(voti+nulli_lista) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$id_gruppo')";
|
---|
439 | $res4 = $dbi->prepare("$sql");
|
---|
440 | $res4->execute();
|
---|
441 | list($vgruppo3,$vsl3)=$res3->fetch(PDO::FETCH_NUM);
|
---|
442 | $vgruppo=$vgruppo3-$vsl3;
|
---|
443 | list($vliste)=$res4->fetch(PDO::FETCH_NUM);
|
---|
444 | if($vliste>$vgruppo)
|
---|
445 | {
|
---|
446 | $sql="SELECT descrizione FROM ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo'";
|
---|
447 | $result = $dbi->prepare("$sql");
|
---|
448 | $result->execute();
|
---|
449 | list($dgruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
450 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti delle liste collegate<br/> superano i voti assegnati al gruppo $dgruppo </b><br></td></tr></table>";
|
---|
451 | $errgrulis[$id_gruppo]=1;
|
---|
452 | }
|
---|
453 | elseif($vliste<$vgruppo)
|
---|
454 | {
|
---|
455 | $sql="SELECT descrizione FROM ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo'";
|
---|
456 | $result = $dbi->prepare("$sql");
|
---|
457 | $result->execute();
|
---|
458 | list($dgruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
459 | echo "<table class=\"table-menu\" style=\"width: 50%;\"><tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti assegnati al gruppo $dgruppo<br/> superano i voti delle liste collegate </b><br></td></tr></table>";
|
---|
460 | $errgrulis[$id_gruppo]=1;
|
---|
461 | }
|
---|
462 | }
|
---|
463 | }
|
---|
464 | }
|
---|
465 |
|
---|
466 |
|
---|
467 | echo "\n<form name=\"sezioni\" data-ajax=\"false\" action=\"modules/Elezioni/salva_liste.php\">"
|
---|
468 | ."<input type=\"hidden\" name=\"op\" value=\"rec_voti\">"
|
---|
469 | ."<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">"
|
---|
470 | ."<input type=\"hidden\" name=\"id_cons\" value=\"$id_cons\">"
|
---|
471 | ."<input type=\"hidden\" name=\"genere\" value=\"$genere\">"
|
---|
472 | ."<input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\">"
|
---|
473 | ."<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\">"
|
---|
474 | ."<input type=\"hidden\" name=\"id_sede\" value=\"$id_sede\">"
|
---|
475 | ."<input type=\"hidden\" name=\"tabella\" value=\"$tab\">"
|
---|
476 | ."<input type=\"hidden\" name=\"id_lista\" value=\"$id_lista\">\n"
|
---|
477 | ."<input type=\"hidden\" name=\"do\" id=\"do\" value=\"0\">\n";
|
---|
478 | echo "<table class=\"table-menu\" style=\"width: 90%; color: black\">";
|
---|
479 | echo "<tr><td bgcolor=\"$bgcolor1\" align=\"left\" width=\"32\">";
|
---|
480 | if ($genere<4){
|
---|
481 | // echo "<td bgcolor=\"$bgcolor1\" align=\"center\" width=\"32\"><b>"._LISTA."</b></td>";
|
---|
482 | }
|
---|
483 | echo "<b>"._NUM."</b></td>";
|
---|
484 | if($id_lista){
|
---|
485 | echo "<td bgcolor=\"$bgcolor1\" align=\"left\"><b>"._CANDIDATO."</b></td>"
|
---|
486 | ."<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._VOTI."</b> (alla lista ".$preflis[$id_lista].")</td>";
|
---|
487 | }else{
|
---|
488 | echo "<td bgcolor=\"$bgcolor1\" align=\"left\"><b>"._DESCR."</b></td>"
|
---|
489 | ."<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._VOTI."</b></td>";
|
---|
490 | #funzione di inserimento del dettaglio di voti nulli sospesa, non ritenuta utile
|
---|
491 | # if($dettnulli && !$disgiunto && $tipo_cons!=18 && $tipo_cons!=19)
|
---|
492 | # echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._NULLI_LISTE."</b></td>";
|
---|
493 | if($disgiunto){
|
---|
494 | echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._SOLOLIS."</b></td>";
|
---|
495 | }
|
---|
496 | }
|
---|
497 | echo "</tr>\n";
|
---|
498 |
|
---|
499 |
|
---|
500 | if($id_lista) $sql="select t1.* from ".$prefix."_ele_candidati as t1 left join ".$prefix."_ele_lista as t2 on (t1.id_lista=t2.id_lista) WHERE t1.id_cons=$id_cons and t1.id_cons=t2.id_cons $ele_lista $circo ORDER BY t2.num_lista,t1.num_cand";
|
---|
501 | else $sql="select 0,'$id_cons',t1.id_lista,'','','','','',0 from ".$prefix."_ele_candidati as t1 left join ".$prefix."_ele_lista as t2 on (t1.id_lista=t2.id_lista) WHERE t1.id_cons=$id_cons and t1.id_cons=t2.id_cons $ele_lista $circo ORDER BY t2.num_lista";
|
---|
502 | $result = $dbi->prepare("$sql");
|
---|
503 | $result->execute();
|
---|
504 |
|
---|
505 |
|
---|
506 | $max = $result->rowCount();
|
---|
507 | $tot_pref=0;
|
---|
508 | $i=1;
|
---|
509 |
|
---|
510 | if($id_lista) {
|
---|
511 | while(list($id_cand,$id_cons2,$id_lista2,$nl, $cognome, $nome, $note, $simbolo, $num_cand) = $result->fetch(PDO::FETCH_NUM)){
|
---|
512 | // dati lista
|
---|
513 | $sql="select id_lista, descrizione,simbolo,num_lista from ".$prefix."_ele_lista where id_lista='$id_lista2'";
|
---|
514 | $result1 = $dbi->prepare("$sql");
|
---|
515 | $result1->execute();
|
---|
516 | list($id_lista3,$descr_lista,$simb_lista,$num_lista)=$result1->fetch(PDO::FETCH_NUM);
|
---|
517 | // dati gruppo
|
---|
518 | $sql="select descrizione,simbolo from ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo'";
|
---|
519 | $result2 = $dbi->prepare("$sql");
|
---|
520 | $result2->execute();
|
---|
521 | list($descr_gruppo,$simb_gruppo)=$result2->fetch(PDO::FETCH_NUM);
|
---|
522 | echo "<tr bgcolor=\"$bgcolor2\">";
|
---|
523 | if ($genere<4){
|
---|
524 | echo "<td align=\"left\"><b><img src=\"images/lista/$simb_lista \" width=\"32\" heigth=\"32\" align=\"center\" ALT=\"$descr_lista\" > </b></td>";
|
---|
525 | }
|
---|
526 | echo "<td align=\"center\"><b> $num_cand </b></td>"
|
---|
527 | ."<td align=\"left\"><b>$cognome $nome</b></td>";
|
---|
528 | $cond_sele="and id_cand=$id_cand";
|
---|
529 | $sql="SELECT voti FROM ".$prefix."$tab where id_cons='$id_cons' and id_sez='$id_sez' $cond_sele";
|
---|
530 | $res = $dbi->prepare("$sql");
|
---|
531 | $res->execute();
|
---|
532 | list($voti)= $res->fetch(PDO::FETCH_NUM); #if(!$voti) $voti2=''; else $voti2=$voti;
|
---|
533 | if(in_array($num_cand,$errcand[$id_lista2])) $errcolor="style=\"background-color: rgb(255, 0, 0);\""; else $errcolor='';
|
---|
534 | echo "<td align=\"right\" $errcolor><input name=\"voti$num_cand\" value=\"".$voti."\" size=\"7\" style=\"text-align:right\" onfocus=\"select();\">";
|
---|
535 | echo "<input type=\"hidden\" name=\"id_cand$num_cand\" value=\"$id_cand\"></td></tr>\n";
|
---|
536 | $i++;
|
---|
537 | $tot_pref+=$voti;
|
---|
538 | }
|
---|
539 | }else {
|
---|
540 | if($circo) $circot1=" and t1.id_circ=$id_circ"; else $circot1='';
|
---|
541 | $sql="select t2.voti,t1.id_lista, descrizione,simbolo,t1.num_lista,t2.nulli_lista,t2.solo_lista,t1.id_gruppo
|
---|
542 | from ".$prefix."_ele_lista as t1, ".$prefix."_ele_voti_lista as t2
|
---|
543 | where t1.id_cons='$id_cons'
|
---|
544 | and t1.id_lista=t2.id_lista
|
---|
545 | and t2.id_sez=$id_sez
|
---|
546 | $circot1
|
---|
547 | order by t1.num_lista";
|
---|
548 |
|
---|
549 | try {
|
---|
550 | $result1 = $dbi->prepare("$sql");
|
---|
551 | $result1->execute();
|
---|
552 | }
|
---|
553 | catch(PDOException $e)
|
---|
554 | {
|
---|
555 | echo $sql . "<br>" . $e->getMessage();
|
---|
556 | }
|
---|
557 | $scruliste=$result1->rowCount();
|
---|
558 | if (!$scruliste){
|
---|
559 | $sql="select null,id_lista, descrizione,simbolo,num_lista,'','',id_gruppo
|
---|
560 | from ".$prefix."_ele_lista where id_cons='$id_cons' $circo
|
---|
561 | order by num_lista";
|
---|
562 | $result1 = $dbi->prepare("$sql");
|
---|
563 | $result1->execute();
|
---|
564 | }
|
---|
565 | $tvnpl=0;
|
---|
566 | $tslpl=0;
|
---|
567 | # $segna2='';
|
---|
568 | $sezscru=0;
|
---|
569 | while (list($voti,$id_lista3,$descr_lista,$simb_lista,$num_lista,$vnpl,$slpl,$rifgruppo)=$result1->fetch(PDO::FETCH_NUM)){
|
---|
570 | echo "<tr bgcolor=\"$bgcolor2\">";
|
---|
571 | // if ($genere<4 or $votoc){
|
---|
572 | // }
|
---|
573 | $sql="select max(t1.voti),sum(t1.voti), count(t1.voti) from ".$prefix."_ele_voti_candidati as t1, ".$prefix."_ele_candidati as t2 where t1.id_cand=t2.id_cand and t1.id_sez='$id_sez' and t2.id_lista='$id_lista3'";
|
---|
574 | $rese = $dbi->prepare("$sql");
|
---|
575 | $rese->execute();
|
---|
576 | list($maxvotic,$sumvotic,$numrec)=$rese->fetch(PDO::FETCH_NUM);#die("TEST: $numrec");
|
---|
577 | if($numrec>0 or ($votoc and $scruliste)) {$sezscru=1; $statuscol="#99CC33;";} else $statuscol='';
|
---|
578 | if($maxvotic>$voti or $sumvotic>$voti*$numprefs) $statuscol='#dd0000;'; #$segna="style=\"background-color: #dd0000;\"";
|
---|
579 | $sql="select * from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' and id='$id_lista3'";
|
---|
580 | $rese = $dbi->prepare("$sql");
|
---|
581 | $rese->execute();
|
---|
582 | if($rese->rowCount()) $statuscol='#dd0000;'; #$segna="style=\"background-color: #dd0000;\"";
|
---|
583 | list($sezcol)=$rese->fetch(PDO::FETCH_NUM);
|
---|
584 | $segna="style=\"background-color: $statuscol\"";
|
---|
585 | if ($statuscol) $errcolor=$segna; else $errcolor='';
|
---|
586 | if ($statuscol=='#dd0000;')
|
---|
587 | $bordcolor="border-color:red;";
|
---|
588 | else $bordcolor='';
|
---|
589 | if(isset($errgrulis[$rifgruppo])) {
|
---|
590 | $errcolor="style=\"background-color: rgb(255, 0, 0);\"";
|
---|
591 | $bordcolor="border-color:red;";
|
---|
592 | }elseif(!$errcolor && $numrec) $errcolor="style=\"background-color: #99CC33;\"";
|
---|
593 | if($genere>=4 and !$votoc) $stilcur="style=\"cursor: pointer;\""; else $stilcur='';
|
---|
594 | echo "<td align=\"center\" $errcolor><b> $num_lista </b></td>"
|
---|
595 | ."<td align=\"left\" $stilcur onClick=\"vai_lista('id_rif$i');\"><b>$descr_lista</b></td>";
|
---|
596 | ## $cond_sele="and id_lista=$id_lista3";
|
---|
597 | echo "<td align=\"right\"><input name=\"voti$i\" value=\"".$voti."\" size=\"7\" onfocus=\"select();\" style=\"text-align:right; $bordcolor;\"><input id=\"id_rif$i\" type=\"hidden\" name=\"id_lista$i\" value=\"$id_lista3\">";
|
---|
598 | #funzione non ritenuta utile
|
---|
599 | # if($dettnulli && !$disgiunto && $tipo_cons!=18 && $tipo_cons!=19) { echo "</td><td align=\"right\"><input name=\"vnpl$i\" value=\"".$vnpl."\" size=\"7\" style=\"text-align:right\">"; $tvnpl+=$vnpl;}
|
---|
600 | if($disgiunto) {echo "</td><td align=\"right\"><input name=\"slpl$i\" value=\"".$slpl."\" size=\"7\" style=\"text-align:right\" onfocus=\"select();\">"; $tslpl+=intval($slpl);}
|
---|
601 | echo "</td>";
|
---|
602 | // echo "<td align=\"right\">$sgpl";
|
---|
603 | echo "</tr>\n";
|
---|
604 | $i++;
|
---|
605 | $tot_pref+=$voti;
|
---|
606 | }
|
---|
607 | }
|
---|
608 | if(!isset($segna2)) $segna2='';
|
---|
609 | if(!$id_lista) {
|
---|
610 | if ($tot_pref!=$validi2 and $sezscru) $segna2="style=\"background-color: #dd0000;\"";
|
---|
611 | echo "<tr bgcolor=\"$bgcolor1\"><td></td><td><font size=\"3\">"._TOT._VOTI_LISTA."</font></td><td align=\"center\" $segna2><font size=\"3\">$tot_pref</font></td>";
|
---|
612 | # if($dettnulli && !$disgiunto && $tipo_cons!=18 && $tipo_cons!=19)
|
---|
613 | # echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><font size=\"3\">".$tvnpl."</font></td>";
|
---|
614 | if($disgiunto)
|
---|
615 | echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><font size=\"3\">".$tslpl."</font></td>";
|
---|
616 | echo "</tr>";
|
---|
617 | }
|
---|
618 | else echo "<tr bgcolor=\"$bgcolor1\"><td></td><td>"._TOTPREF."</td><td align=\"center\" $segna2>$tot_pref</td></tr>";
|
---|
619 | // toglie ai candidati la visual... del solo_gruppo
|
---|
620 | if(!$votog) {
|
---|
621 | if (($genere==3 OR $genere==5) and (!$id_lista) and (($disgiunto or $fascia>$limite) or !$id_conf)) { //gruppo e liste
|
---|
622 | echo "<tr bgcolor=\"$bgcolor2\"><td></td><td><b>"._VALIDI_LISTA."</b></td><td align=\"center\"><input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\"><input name=\"valista\" value=\"$valista\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\"></td></tr>";
|
---|
623 | echo "<tr bgcolor=\"$bgcolor2\"><td></td><td><b>"._SOLO_GRUPPO."</b></td><td align=\"center\"><input name=\"sg\" value=\"$sg\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\">";
|
---|
624 | if(defined('_NULLISTA'))
|
---|
625 | echo "<input type=\"hidden\" name=\"votinulli\" value=\"$votinulli\"><input type=\"hidden\" name=\"contestati\" value=\"$contestati\"></td></tr>";
|
---|
626 | else
|
---|
627 | echo "</td></tr><tr bgcolor=\"$bgcolor2\"><td></td><td><b>"._NULLI_LISTE."</b></td><td align=\"center\"><input name=\"votinulli\" value=\"$votinulli\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\">"
|
---|
628 | ."</td></tr><tr bgcolor=\"$bgcolor2\"><td></td><td><b>"._CONTESTATI_LISTE."</b></td><td align=\"center\"><input name=\"contestati\" value=\"$contestati\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\"></td></tr>";
|
---|
629 |
|
---|
630 | }elseif (($genere==3 OR $genere==5) and !$votoc and (($disgiunto or $fascia>$limite) or !$id_conf)){ //}elseif ($tipo_cons!=10 and $tipo_cons!=11){
|
---|
631 | echo "<tr bgcolor=\"$bgcolor1\"><td></td><td><b>"._SOLO_GRUPPO."</b></td><td align=\"center\">$sg</td></tr>";
|
---|
632 | }
|
---|
633 | /* visualizzazione tolta perché inappropriata 04/03/2022
|
---|
634 | ######modifica del 16-04-2009 per visualizzare i voti al solo sindaco nei comuni con meno di 15000 abitanti
|
---|
635 | elseif(($genere==3 OR $genere==5) and ($id_lista) and ($fascia<=$limite or !$id_conf) and $numprefs==1) {
|
---|
636 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_lista where id_lista='$id_lista'";
|
---|
637 | $resvg = $dbi->prepare("$sql");
|
---|
638 | $resvg->execute();
|
---|
639 |
|
---|
640 |
|
---|
641 | list($id_gruppo) = $resvg->fetch(PDO::FETCH_NUM);
|
---|
642 | $sql="SELECT sum(voti) FROM ".$prefix."_ele_voti_gruppo where id_gruppo='$id_gruppo' and id_sez='$id_sez'";
|
---|
643 | $resvg = $dbi->prepare("$sql");
|
---|
644 | $resvg->execute();
|
---|
645 |
|
---|
646 |
|
---|
647 | list($voti_sind) = $resvg->fetch(PDO::FETCH_NUM);
|
---|
648 |
|
---|
649 | echo "<tr bgcolor=\"$bgcolor1\"><td></td><td><b>"._SOLO_GRUPPO."</b></td><td align=\"center\">".($voti_sind - $tot_pref)."</td></tr>";
|
---|
650 | } */
|
---|
651 | ###### fine modifica del 16-04-2009
|
---|
652 |
|
---|
653 | }
|
---|
654 | echo "<tr>";
|
---|
655 | echo "<td></td><td></td>";
|
---|
656 | echo "<td align=\"center\"><input type=\"submit\" id=\"update\" name=\"update\" value=\""._OK."\"></td>";
|
---|
657 | echo "</tr></table>";
|
---|
658 | if(chisei($id_cons_gen)>=64){
|
---|
659 | echo "<td></td><td> <input type=\"checkbox\" id=\"pwd3\" name=\"pwd3\" value=\"1\">"._DELETE."</td>";
|
---|
660 | } # onclick=\"javascript:del_dati()\"
|
---|
661 | echo "</form></tr></table>";
|
---|
662 |
|
---|
663 |
|
---|
664 |
|
---|
665 | }
|
---|
666 | #if (!((!$votog) and ($genere==3 OR $genere==5) and ($fascia>$limite)))
|
---|
667 | finale($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops);
|
---|
668 | }
|
---|
669 |
|
---|
670 |
|
---|
671 | function finale($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops){
|
---|
672 | global $aid, $prefix, $dbi,$id_cons_gen,$genere,$votog,$fascia,$limite,$scrtest;
|
---|
673 | ////////////////////////////////////////////
|
---|
674 | // da qua va la sezione per i voti finali
|
---|
675 | ///////////////////////////////////////////
|
---|
676 | $bgcolor1="#7777ff";
|
---|
677 | $bgcolor2=$_SESSION['bgcolor2'];
|
---|
678 | echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n"
|
---|
679 | ."//-->\n";
|
---|
680 | echo "function setsez() {\n";
|
---|
681 | echo "document.getElementById('spogliovoti').submit(); }\n";
|
---|
682 | echo "</script>\n";
|
---|
683 |
|
---|
684 | $sql="select * from ".$prefix."_ele_voti_lista where id_cons=$id_cons and id_sez=$id_sez and id_lista=0";
|
---|
685 | $res = $dbi->prepare("$sql");
|
---|
686 | $res->execute();
|
---|
687 | $stato=$res->rowCount();
|
---|
688 | if($stato) $stato='checked'; else $stato='';
|
---|
689 | echo "<form name=\"spogliovoti\" id=\"spogliovoti\" data-ajax=\"false\" action=\"modules/Elezioni/salva_voti.php\">"
|
---|
690 | ."<input type=\"hidden\" name=\"op\" value=\"rec_finale\">";
|
---|
691 | echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">"
|
---|
692 | ."<input type=\"hidden\" name=\"id_cons\" value=\"$id_cons\">"
|
---|
693 | ."<input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\">"
|
---|
694 | ."<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\">"
|
---|
695 | ."<input type=\"hidden\" name=\"id_sede\" value=\"$id_sede\">";
|
---|
696 | if($scrtest)
|
---|
697 | echo "<div style=\"text-align:right;\">Considerare la sezione come scrutinata? <input type=\"checkbox\" name=\"scrutinata\" id=\"scrutinata\" value=\"true\" $stato onclick=\"setsez()\";> <br></div>";
|
---|
698 |
|
---|
699 | echo "<table border=\"0\" width=\"100%\" align=\"center\"><tr bgcolor=\"$bgcolor1\" align=\"center\">";
|
---|
700 | /* if($ops==3 and ($genere==3 or ($genere==5 and $fascia>$limite)) )
|
---|
701 | echo "<td width=\"32\"><b>"._VOTI_LISTA."</b></td>";
|
---|
702 | else */
|
---|
703 | echo "<td width=\"15%\"><b>"._VALIDI."</b></td>";
|
---|
704 | echo "<td width=\"82\"><b>"._NULLI."</b></td>"
|
---|
705 | ."<td><b>"._BIANCHI."</b></td>"
|
---|
706 | ."<td width=\"82\"><b>"._VOTINULLI."</b></td>"
|
---|
707 | ."<td><b>"._CONTESTATI."</b></td>"
|
---|
708 | ."<td><b>"._TOTNON."</b></td>"
|
---|
709 | ."<td><b>"._TOTALEVOTI."</b></td>"
|
---|
710 | ."<td bgcolor=\"#ffffff\"></td> </tr>";
|
---|
711 | /*if($ops==3 and ($genere==3 or ($genere==5 and $fascia>$limite)) )
|
---|
712 | $result = mysql_query("select id_cons,id_sez,validi_lista,nulli,bianchi,contestati_lista,voti_nulli_lista,solo_gruppo,contestati,voti_nulli from ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
713 | $res = $dbi->prepare("$sql");
|
---|
714 | $res->execute();
|
---|
715 |
|
---|
716 |
|
---|
717 | else */
|
---|
718 | $sql = "select id_cons,id_sez,validi,nulli,bianchi,contestati,voti_nulli,'0','0','0',solo_lista from ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
719 | $result = $dbi->prepare("$sql");
|
---|
720 | $result->execute();
|
---|
721 |
|
---|
722 |
|
---|
723 | list($id_cons2,$id_sez2,$validi, $nulli, $bianchi, $contestati,$votinulli,$sg,$conts,$nullis,$sololista) = $result->fetch(PDO::FETCH_NUM);
|
---|
724 | $tot_nulli=$nulli+$bianchi+$contestati+$votinulli;
|
---|
725 | $tot_voti=$validi+$tot_nulli+$conts+$nullis;
|
---|
726 | // ."</td><td><input name=\"sololista\" value=\"$sololista\" size=\"5\" style=\"text-align:right\">" --- ."<td><b>"._SOLOLIS."</b></td>"
|
---|
727 |
|
---|
728 |
|
---|
729 | echo "<tr bgcolor=\"$bgcolor2\" align=\"center\"><td align=\"left\"><input name=\"validi\" value=\"$validi\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\">";
|
---|
730 | /* if(($genere==3 or $genere==5) and !$votog and $ops==3){
|
---|
731 | echo "</td><td>$nulli"
|
---|
732 | ."</td><td>$bianchi";
|
---|
733 | echo "<input type=\"hidden\" name=\"nulli\" value=\"$nulli\"><input type=\"hidden\" name=\"bianchi\" value=\"$bianchi\">";
|
---|
734 | }else{ */
|
---|
735 | echo "</td><td><input name=\"nulli\" value=\"$nulli\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\">"
|
---|
736 | ."</td><td><input name=\"bianchi\" value=\"$bianchi\" size=\"5\" style=\"text-align:right;\" onfocus=\"select();\">";
|
---|
737 | // }
|
---|
738 | echo "</td><td><input name=\"votinulli\" value=\"$votinulli\" style=\"text-align:right;\" onfocus=\"select();\">"
|
---|
739 | ."</td><td><input name=\"contestati\" value=\"$contestati\" size=\"5\" style=\"text-align:right\" onfocus=\"select();\">"
|
---|
740 | ."</td><td>$tot_nulli"
|
---|
741 | ."</td><td>$tot_voti</td><td>"
|
---|
742 | ."<input type=\"hidden\" name=\"genere\" value=\"$genere\">"
|
---|
743 | ."<input type=\"hidden\" name=\"ops\" value=\"$ops\">"
|
---|
744 | ."<input type=\"submit\" name=\"update\" value=\""._OK."\">"
|
---|
745 | ."</td></tr></table></form>"; //</td></tr>";
|
---|
746 |
|
---|
747 |
|
---|
748 | // echo "</table>";
|
---|
749 | /* echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n";
|
---|
750 | if (!$validi) {
|
---|
751 | echo "document.spogliovoti.validi.focus()\n";
|
---|
752 | echo "document.spogliovoti.validi.select()\n";
|
---|
753 | }
|
---|
754 | echo "//-->\n"
|
---|
755 | ."</script>\n"; */
|
---|
756 |
|
---|
757 |
|
---|
758 | }
|
---|
759 |
|
---|
760 |
|
---|
761 | function preferenze_gruppi($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops){
|
---|
762 | global $aid, $prefix, $dbi, $tipo_cons, $genere,$id_cons_gen,$sezi,$circo,$dettnulli,$scrtest;
|
---|
763 | ////////////////////////////////////////////
|
---|
764 | // da qua va la sezione per le preferenze ai gruppi
|
---|
765 | ///////////////////////////////////////////
|
---|
766 | // Controllo immmissioni
|
---|
767 |
|
---|
768 | $bgcolor1="#7777ff";
|
---|
769 | $bgcolor2=$_SESSION['bgcolor2'];
|
---|
770 | $sql="SELECT * FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo ";
|
---|
771 | $res = $dbi->prepare("$sql");
|
---|
772 | $res->execute();
|
---|
773 |
|
---|
774 |
|
---|
775 | $max = $res->rowCount();
|
---|
776 | $max = $max-1;
|
---|
777 | /* echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n";
|
---|
778 | if ($genere==0) {
|
---|
779 | echo "document.sezioni.si1.focus()\n";
|
---|
780 | echo "document.sezioni.si1.select()\n";
|
---|
781 | } else {
|
---|
782 | echo "document.sezioni.voti1.focus()\n"
|
---|
783 | ."document.sezioni.voti1.select()\n";
|
---|
784 | }
|
---|
785 | echo "//-->\n"
|
---|
786 | ."</script>\n"; */
|
---|
787 | // tabella votanti
|
---|
788 | echo "<center>";
|
---|
789 | if ($genere!=0){
|
---|
790 | $sql="SELECT voti_uomini,voti_donne, voti_complessivi FROM ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_cons='$id_cons' order by data desc,orario desc limit 0,1";
|
---|
791 | $result = $dbi->prepare("$sql");
|
---|
792 | $result->execute();
|
---|
793 |
|
---|
794 |
|
---|
795 | list( $voti_u, $voti_d, $voti_t) = $result->fetch(PDO::FETCH_NUM);
|
---|
796 | echo "<table class=\"table-menu\" style=\"width: 50%; color: black;\">"
|
---|
797 | ."<tr><td></td><td align=\"center\"></td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTIU."</td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTID."</td><td bgcolor=\"$bgcolor1\" align=\"center\">"._VOTIT."</td></tr>"
|
---|
798 | ."<tr><td></td><td bgcolor=\"$bgcolor1\" align=\"center\">"._TOT_ULT."</td><td bgcolor=\"$bgcolor2\" align=\"center\">$voti_u</td><td align=\"center\" bgcolor=\"$bgcolor2\">$voti_d</td><td bgcolor=\"$bgcolor2\" align=\"center\">$voti_t</td></tr>";
|
---|
799 | echo "</table>";
|
---|
800 | }
|
---|
801 | echo "<table class=\"table-menu\" style=\"width: 50%; color: black\">";
|
---|
802 | if ($genere==0){
|
---|
803 | $sql="SELECT id_gruppo,si+no,validi,nulli,bianchi,contestati FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez' ";
|
---|
804 | $res = $dbi->prepare("$sql");
|
---|
805 | $res->execute();
|
---|
806 | while (list($id_gruppo,$voti_parz,$validi,$nulli,$bianchi,$contestati) = $res->fetch(PDO::FETCH_NUM)){
|
---|
807 | if ($voti_parz!=$validi){
|
---|
808 | $sql="SELECT num_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' and id_gruppo='$id_gruppo' ";
|
---|
809 | $res2 = $dbi->prepare("$sql");
|
---|
810 | $res2->execute();
|
---|
811 | list($num_gruppo) = $res2->fetch(PDO::FETCH_NUM);
|
---|
812 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); text-align:center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTI_REF." $num_gruppo: ".$voti_parz." "._NO_VAL_VOTI.": ".$validi."</b><br></td></tr>";
|
---|
813 | }
|
---|
814 | $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez' and id_gruppo='$id_gruppo' ";
|
---|
815 | $res2 = $dbi->prepare("$sql");
|
---|
816 | $res2->execute();
|
---|
817 | list($tot) = $res2->fetch(PDO::FETCH_NUM);
|
---|
818 | if (($validi+$nulli+$bianchi+$contestati)!= $tot ){
|
---|
819 | $sql="SELECT num_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' and id_gruppo='$id_gruppo'";
|
---|
820 | $res2 = $dbi->prepare("$sql");
|
---|
821 | $res2->execute();
|
---|
822 | list($num_gruppo) = $res2->fetch(PDO::FETCH_NUM);
|
---|
823 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); text-align:center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTANTI_REF." $num_gruppo: ".$tot." "._NO_SOMMA." ".($validi+$nulli+$bianchi+$contestati)."</b><br></td></tr>";
|
---|
824 | }
|
---|
825 | }
|
---|
826 | }else{
|
---|
827 | $sql="select solo_gruppo,disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons' ";
|
---|
828 | $result = $dbi->prepare("$sql");
|
---|
829 | $result->execute();
|
---|
830 | list($flagsg,$disgiunto)=$result->fetch(PDO::FETCH_NUM);
|
---|
831 | $dettnulli=$flagsg;
|
---|
832 | $sql="SELECT sum(voti) FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
833 | $res = $dbi->prepare("$sql");
|
---|
834 | $res->execute();
|
---|
835 | list($voti_parz) = $res->fetch(PDO::FETCH_NUM);
|
---|
836 | $sql="SELECT validi,nulli,bianchi,contestati,solo_lista,voti_nulli FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
837 | $res = $dbi->prepare("$sql");
|
---|
838 | $res->execute();
|
---|
839 | list($validi,$nulli,$bianchi,$contestati,$solo_lista,$votinulli) = $res->fetch(PDO::FETCH_NUM);
|
---|
840 | if ($voti_parz!=($validi-$solo_lista) and $voti_parz>0){
|
---|
841 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); text-align:center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTI." ".$voti_parz." "._NO_VAL_VOTI." ".($validi-$solo_lista)."</b><br></td><tr>";
|
---|
842 | }
|
---|
843 | $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
844 | $res2 = $dbi->prepare("$sql");
|
---|
845 | $res2->execute();
|
---|
846 | list($tot) = $res2->fetch(PDO::FETCH_NUM);
|
---|
847 | if ($validi+$nulli+$bianchi+$contestati+$votinulli!=$tot and $validi+$nulli+$bianchi+$contestati+$votinulli>0){
|
---|
848 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); text-align:center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_VOTANTI." ".$tot." "._NO_TOT_VOTI." ".($validi+$nulli+$bianchi+$contestati+$votinulli)."</b><br></td></tr>";
|
---|
849 | }
|
---|
850 | $sql="SELECT sum(voti) from ".$prefix."_ele_voti_lista where id_cons=$id_cons and id_sez=$id_sez";
|
---|
851 | $resg = $dbi->prepare("$sql");
|
---|
852 | $resg->execute();
|
---|
853 | list($voti_sez)=$resg->fetch(PDO::FETCH_NUM);
|
---|
854 | if(($genere==5 and !$disgiunto and $voti_sez and $flagsg and ($tipo_cons==18 or $tipo_cons==19))){
|
---|
855 | $sql="SELECT sum(solo_gruppo) from ".$prefix."_ele_voti_gruppo where id_cons=$id_cons and id_sez=$id_sez";
|
---|
856 | $resg = $dbi->prepare("$sql");
|
---|
857 | $resg->execute();
|
---|
858 | list($sgpl)=$resg->fetch(PDO::FETCH_NUM);
|
---|
859 | $sql="SELECT solo_gruppo from ".$prefix."_ele_sezioni where id_cons=$id_cons and id_sez=$id_sez";
|
---|
860 | $resg = $dbi->prepare("$sql");
|
---|
861 | $resg->execute();
|
---|
862 | list($sg)=$resg->fetch(PDO::FETCH_NUM);
|
---|
863 | if ($sg != $sgpl) echo "<tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br><b> "._ATT_UNI." ".$sgpl." "._ATT_TOT_UNI." ".$sg."</b><br></td></tr>";
|
---|
864 | }
|
---|
865 | #controllo voti a liste collegate <= voto di gruppo per voto non disgiunto
|
---|
866 | if($genere==5 and !$disgiunto and $flagsg and ($tipo_cons==18 or $tipo_cons==19)){
|
---|
867 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo";
|
---|
868 | $resref = $dbi->prepare("$sql");
|
---|
869 | $resref->execute();
|
---|
870 | $errgrulis=array();
|
---|
871 | $sql="SELECT count(0) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez'";
|
---|
872 | $res4 = $dbi->prepare("$sql");
|
---|
873 | $res4->execute();
|
---|
874 | list($sezscrl)=$res4->fetch(PDO::FETCH_NUM);
|
---|
875 | if ($sezscrl)
|
---|
876 | while ( list($id_gruppo)=$resref->fetch(PDO::FETCH_NUM))
|
---|
877 | {
|
---|
878 | if($disgiunto || $flagsg){
|
---|
879 | $sql="SELECT sum(voti-solo_gruppo) FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
880 | $res3 = $dbi->prepare("$sql");
|
---|
881 | $res3->execute();
|
---|
882 | if($flagsg){
|
---|
883 | $sql="SELECT sum(voti+nulli_lista) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$id_gruppo')";
|
---|
884 | $res4 = $dbi->prepare("$sql");
|
---|
885 | $res4->execute();
|
---|
886 | }else{
|
---|
887 | $sql="SELECT sum(voti) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$id_gruppo')";
|
---|
888 | $res4 = $dbi->prepare("$sql");
|
---|
889 | $res4->execute();
|
---|
890 | }
|
---|
891 | }else{
|
---|
892 | $sql="SELECT sum(voti) FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez' and id_gruppo='$id_gruppo'";
|
---|
893 | $res3 = $dbi->prepare("$sql");
|
---|
894 | $res3->execute();
|
---|
895 | $sql="SELECT sum(voti) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$id_gruppo')";
|
---|
896 | $res4 = $dbi->prepare("$sql");
|
---|
897 | $res4->execute();
|
---|
898 | }
|
---|
899 | list($vgruppo)=$res3->fetch(PDO::FETCH_NUM);
|
---|
900 | list($vliste)=$res4->fetch(PDO::FETCH_NUM);
|
---|
901 | if($vliste>$vgruppo and !$disgiunto )
|
---|
902 | {
|
---|
903 | $sql="SELECT descrizione FROM ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo'";
|
---|
904 | $result = $dbi->prepare("$sql");
|
---|
905 | $result->execute();
|
---|
906 | list($dgruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
907 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti delle liste collegate $vliste<br/> superano i voti assegnati al gruppo $dgruppo $vgruppo</b><br></td></tr>";
|
---|
908 | $errgrulis[$id_gruppo]=1;
|
---|
909 | }
|
---|
910 | elseif($vliste<$vgruppo and !$disgiunto )
|
---|
911 | {
|
---|
912 | $sql="SELECT descrizione FROM ".$prefix."_ele_gruppo where id_gruppo='$id_gruppo'";
|
---|
913 | $result = $dbi->prepare("$sql");
|
---|
914 | $result->execute();
|
---|
915 | list($dgruppo)=$result->fetch(PDO::FETCH_NUM);
|
---|
916 | echo "<tr><td style=\"background-color: rgb(255, 0, 0); color: black; text-align: center\"><img src=\"modules/Elezioni/images/alert.gif\" align=\"middle\" alt=\"\"><br/><b> ATTENZIONE!<BR/>I voti assegnati al gruppo $dgruppo<br/> superano i voti delle liste collegate </b><br></td></tr>";
|
---|
917 | $errgrulis[$id_gruppo]=1;
|
---|
918 | }
|
---|
919 | }
|
---|
920 | }
|
---|
921 | }
|
---|
922 | if(!isset($votinulli)) $votinulli=0;
|
---|
923 | echo "<tr><td></td></tr></table>";
|
---|
924 | if ($validi+$nulli+$bianchi+$contestati+$votinulli>0 or $genere==0) {
|
---|
925 | if($genere==0) echo "<table class=\"table-menu\" style=\" width: 60%; color: black\"><tr><td colspan=\"3\"><form name=\"sezioni\" data-ajax=\"false\" action=\"modules/Elezioni/salva_ref.php\">";
|
---|
926 | else echo "<table class=\"table-menu\" style=\" width: 60%; color: black\"><tr><td colspan=\"3\"><form name=\"sezioni\" data-ajax=\"false\" action=\"modules/Elezioni/salva_gruppi.php\">";
|
---|
927 | echo "<input type=\"hidden\" name=\"op\" value=\"rec_voti_gruppiq\">"
|
---|
928 | ."<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">"
|
---|
929 | ."<input type=\"hidden\" name=\"id_cons\" value=\"$id_cons\">"
|
---|
930 | ."<input type=\"hidden\" name=\"id_sez\" value=\"$id_sez\">"
|
---|
931 | ."<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\">"
|
---|
932 | ."<input type=\"hidden\" name=\"id_sede\" value=\"$id_sede\">"
|
---|
933 | ."<input type=\"hidden\" name=\"circo\" value=\"$circo\">"
|
---|
934 | ."<input type=\"hidden\" name=\"genere\" value=\"$genere\">"
|
---|
935 | ."<input type=\"hidden\" name=\"do\" id=\"do\" value=\"0\">";
|
---|
936 | if ($genere==0){
|
---|
937 | echo "<br><br> <table class=\"table-menu\" style=\"width: 100%; color: black\"><tr align=\"center\" bgcolor=\"$bgcolor1\">"
|
---|
938 | ."<td colspan=\"6\"><b>"._GRUPPO."</b></td></tr>";
|
---|
939 | $campitesta= "<tr align=\"center\" bgcolor=\"$bgcolor1\"><td><b>Votanti "._SI."</b></td>"
|
---|
940 | ."<td><b>Votanti "._NO."</b></td>"
|
---|
941 | ."<td><b>"._VALIDI."</b></td>"
|
---|
942 | ."<td><b>"._BIANCHI."</b></td>"
|
---|
943 | ."<td><b>"._CONTESTATI."</b></td>"
|
---|
944 | ."<td><b>"._NULLI."</b></td></tr>";
|
---|
945 |
|
---|
946 | $campiriep="<tr style=\"background-color: $bgcolor1; text-align:center\"><td colspan=\"2\"><b>"._TOTNON."</b></td>"
|
---|
947 | ."<td colspan=\"2\"><b>"._TOTALEVOTI."</b></td>"
|
---|
948 | ."<td colspan=\"2\"><b>"._VOTANTI."</b></td></tr>";
|
---|
949 | }else{
|
---|
950 | echo "<br><br><table class=\"table-menu\" style=\"width: 100%; color: black\"><tr align=\"center\" bgcolor=\"$bgcolor1\">"
|
---|
951 | ."<td width=\"3%\"><b>"._NUM."</b></td>"
|
---|
952 | ."<td width=\"50%\"><b>"._GRUPPO."</b></td>";
|
---|
953 | echo "<td width=\"5%\"><b>"._VOTI."</b></td>";
|
---|
954 | if($dettnulli) echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._SOLO_GRUPPO."</b></td>";
|
---|
955 | echo "</tr>";
|
---|
956 | }
|
---|
957 | $sql="SELECT * FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo ORDER BY num_gruppo ";
|
---|
958 | $res = $dbi->prepare("$sql");
|
---|
959 | $res->execute();
|
---|
960 | $max = $res->rowCount();
|
---|
961 | //echo "Massimo:$max - id=$id_cons - circo: $circo";
|
---|
962 | $sql="select * from ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo ORDER BY num_gruppo ";
|
---|
963 | $result = $dbi->prepare("$sql");
|
---|
964 | $result->execute();
|
---|
965 | $i=1;
|
---|
966 | $tot_pref=0;
|
---|
967 | $totsg=0;
|
---|
968 | while(list($id_cons2,$id_gruppo,$num_gruppo, $descr_gruppo, $simbolo) = $result->fetch(PDO::FETCH_NUM)){
|
---|
969 | echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n"
|
---|
970 | ."//-->\n";
|
---|
971 | echo "function controlloref$i() {\n";
|
---|
972 | echo "var a=Number(window.document.sezioni.si$i.value); var b=Number(window.document.sezioni.no$i.value); if(a=='NaN') {a=0} if(b=='NaN') {b=0} var c=a + b; window.document.sezioni.val$i.value=c\n";
|
---|
973 | echo "}\n";
|
---|
974 | echo "</script>\n";
|
---|
975 | if ($num_gruppo != ''){
|
---|
976 | if ($genere==0){
|
---|
977 | $sql="SELECT max(voti_complessivi) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez' and id_gruppo='$id_gruppo' ";
|
---|
978 | $res = $dbi->prepare("$sql");
|
---|
979 | $res->execute();
|
---|
980 | list($tot) = $res->fetch(PDO::FETCH_NUM);
|
---|
981 | $sql="SELECT * FROM ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez' and id_gruppo='$id_gruppo' ";
|
---|
982 | $res = $dbi->prepare("$sql");
|
---|
983 | $res->execute();
|
---|
984 | $numpro=$res->rowCount();
|
---|
985 | $pro= $res->fetch(PDO::FETCH_BOTH);
|
---|
986 | echo "<tr><td colspan=\"6\"> </td></tr>";
|
---|
987 | if ($numpro and ($pro['si']+$pro['no']!=$pro['validi'] or ($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=$tot and $pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0))){
|
---|
988 | echo "<tr style=\"background-color: rgb(255, 0, 0); text-align:center\">";
|
---|
989 | }elseif($numpro and ($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0))
|
---|
990 | echo "<tr style=\"background-color:#99CC33; text-align:center\">";
|
---|
991 | else
|
---|
992 | echo "<tr style=\"background-color:$bgcolor2; text-align:center\">";
|
---|
993 | # $descr = explode('.',$descr_gruppo, 100);
|
---|
994 | echo "<td colspan=\"6\" align=\"center\"><input type=\"hidden\" name=\"id_gruppo$i\" value=\"$id_gruppo\"><b>$num_gruppo) </b>"
|
---|
995 | ."<b> $descr_gruppo </b></td></tr>";
|
---|
996 | $pro['si']=(isset($pro['si']) and $pro['si']>=0) ? $pro['si']:'';
|
---|
997 | $pro['no']=(isset($pro['no']) and $pro['no']>=0) ? $pro['no']:'';
|
---|
998 | $pro['validi']=(isset($pro['validi']) and $pro['validi']>=0) ? $pro['validi']:'';
|
---|
999 | $pro['bianchi']=(isset($pro['bianchi']) and $pro['bianchi']>=0) ? $pro['bianchi']:'';
|
---|
1000 | $pro['contestati']=(isset($pro['contestati']) and $pro['contestati']>=0) ? $pro['contestati']:'';
|
---|
1001 | $pro['nulli']=(isset($pro['nulli']) and $pro['nulli']>=0) ? $pro['nulli']:'';
|
---|
1002 | $tot_nulli=intval($pro['nulli'])+intval($pro['bianchi'])+intval($pro['contestati']);
|
---|
1003 | $tot_voti=intval($pro['validi'])+$tot_nulli;
|
---|
1004 | echo $campiriep; # style=\"text-align: center; border: 1px; border-color: black; border-collaps:collaps;\"
|
---|
1005 | echo "<tr style=\"background-color: $bgcolor2; text-align:center\"><td colspan=\"2\" >$tot_nulli</td>";
|
---|
1006 | echo "<td colspan=\"2\">$tot_voti</td>";
|
---|
1007 | echo "<td colspan=\"2\">$tot</td></tr>";
|
---|
1008 | echo $campitesta;
|
---|
1009 | echo "<tr><td align=\"right\" width=\"3%\"><input name=\"si$i\" value=\"".$pro['si']."\" size=\"7\" style=\"text-align:right\" onchange=controlloref$i() onfocus=\"select();\"></td>";
|
---|
1010 | echo "</td><td align=\"right\" width=\"3%\"><input name=\"no$i\" value=\"".$pro['no']."\" size=\"7\" style=\"text-align:right\" onchange=controlloref$i() onfocus=\"select();\"></td>";
|
---|
1011 | echo "</td><td align=\"right\" width=\"3%\"><input name=\"val$i\" value=\"".$pro['validi']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>";
|
---|
1012 | echo "</td><td align=\"right\"><input name=\"bia$i\" value=\"".$pro['bianchi']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>";
|
---|
1013 | echo "</td><td align=\"right\"><input name=\"con$i\" value=\"".$pro['contestati']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>";
|
---|
1014 | echo "</td><td align=\"right\"><input name=\"nul$i\" value=\"".$pro['nulli']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>";
|
---|
1015 | }else{
|
---|
1016 | echo "<tr style=\"background-color: $bgcolor2; text-align:center\"><td align=\"center\"><input type=\"hidden\" name=\"num_gruppo$i\" value=\"$num_gruppo\"><b>$num_gruppo</b>"
|
---|
1017 | ."</td><td align=\"left\"><b> $descr_gruppo </b>";
|
---|
1018 | $sql="SELECT * FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez' and id_gruppo='$id_gruppo' ";
|
---|
1019 | $res = $dbi->prepare("$sql");
|
---|
1020 | $res->execute();
|
---|
1021 | $pro= $res->fetch(PDO::FETCH_BOTH);
|
---|
1022 | if(!$res->rowCount()) {$pro['voti']=''; $pro['solo_gruppo']='';}
|
---|
1023 | $errcolor='';
|
---|
1024 | if(isset($errgrulis[$id_gruppo])) {$errcolor="style=\"background-color: rgb(255, 0, 0);\"";}
|
---|
1025 | echo "</td><td align=\"right\" $errcolor><input name=\"voti$i\" value=\"".$pro['voti']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>";
|
---|
1026 | if($dettnulli) {echo "<td align=\"right\"><input name=\"solog$i\" value=\"".$pro['solo_gruppo']."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td>"; $totsg+=intval($pro['solo_gruppo']);}
|
---|
1027 | $tot_pref += intval($pro['voti']);
|
---|
1028 | echo "</tr>";
|
---|
1029 | }
|
---|
1030 | $i++;
|
---|
1031 | }
|
---|
1032 | }
|
---|
1033 | if ($genere!=0) {
|
---|
1034 | $sql="SELECT disgiunto FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons' ";
|
---|
1035 | $res = $dbi->prepare("$sql");
|
---|
1036 | $res->execute();
|
---|
1037 | list($disgiunto)=$res->fetch(PDO::FETCH_NUM);
|
---|
1038 | $sql="SELECT solo_lista FROM ".$prefix."_ele_sezioni where id_sez='$id_sez' ";
|
---|
1039 | $res = $dbi->prepare("$sql");
|
---|
1040 | $res->execute();
|
---|
1041 | if ($tot_pref!=$validi and ($tot_pref>0 and $validi>0)) $segna2="style=\"background-color: #dd0000;\""; else $segna2='';
|
---|
1042 | list($sololis)=$res->fetch(PDO::FETCH_NUM);
|
---|
1043 | echo "<tr style=\"background-color: $bgcolor1; text-align:center\"><td></td><td>"._TOTPREF."</td><td $segna2>$tot_pref</td>";
|
---|
1044 | if($dettnulli) echo "<td>$totsg</td>";
|
---|
1045 | echo "</tr>";
|
---|
1046 | if($disgiunto)
|
---|
1047 | echo "<tr style=\"background-color: $bgcolor1; text-align:center\"><td></td><td>"._SOLOLIS."</td><td><input name=\"sololista\" value=\"".$sololis."\" size=\"7\" style=\"text-align:right;\" onfocus=\"select();\"></td></tr>";
|
---|
1048 | }
|
---|
1049 | echo "<tr><td></td><td></td><td align=\"center\"><input type=\"submit\" name=\"update\" id=\"update\" value=\" "._OK. "\"></td>";
|
---|
1050 | echo "</tr></table></form></td></tr>";
|
---|
1051 | if(chisei($id_cons_gen)>=64){
|
---|
1052 | echo "<tr><td><input type=\"checkbox\" id=\"pwd3\" name=\"pwd3\" value=\"\" onclick=\"javascript:del_dati()\">"._DELETE."";
|
---|
1053 | }
|
---|
1054 | echo "</td></tr></table></center>";
|
---|
1055 | $scrtest=0;
|
---|
1056 | }else{$scrtest=1;}
|
---|
1057 | if ($genere!=0){
|
---|
1058 | finale($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops);
|
---|
1059 | }
|
---|
1060 | }
|
---|
1061 |
|
---|
1062 |
|
---|
1063 |
|
---|
1064 |
|
---|
1065 | ?>
|
---|