[258] | 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;
|
---|
| 4 |
|
---|
| 5 | $sql="select status from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
| 6 | $resc = $dbi->prepare("$sql");
|
---|
| 7 | $resc->execute();
|
---|
| 8 | list($stato)=$resc->fetch(PDO::FETCH_NUM);
|
---|
| 9 | $sezstat=0;
|
---|
| 10 | if($stato) {
|
---|
| 11 | $sezstat=1;
|
---|
| 12 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #FF3300;' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO
|
---|
| 13 | $res = $dbi->prepare("$sql");
|
---|
| 14 | $res->execute();
|
---|
| 15 | }
|
---|
| 16 |
|
---|
| 17 | elseif(!$sezstat){ #candidati
|
---|
| 18 | $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";
|
---|
| 19 | $res = $dbi->prepare("$sql");
|
---|
| 20 | $res->execute();
|
---|
| 21 | $liste=$res->rowCount();
|
---|
| 22 |
|
---|
| 23 | $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";
|
---|
| 24 | $res = $dbi->prepare("$sql");
|
---|
| 25 | $res->execute();
|
---|
| 26 | if($liste && $liste==$res->rowCount()){
|
---|
| 27 | $sezstat=2;
|
---|
| 28 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #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='style=\" background: #99CC33;' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE
|
---|
| 39 | $res = $dbi->prepare("$sql");
|
---|
| 40 | $res->execute();
|
---|
| 41 | }elseif(!$sezstat){ #gruppi
|
---|
| 42 | $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
| 43 | $res = $dbi->prepare("$sql");
|
---|
| 44 | $res->execute();
|
---|
| 45 | $righe=$res->rowCount();
|
---|
| 46 | if($righe){
|
---|
| 47 | $sezstat=4;
|
---|
| 48 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #F5F5F5;' where id_cons='$id_cons' and id_sez='$id_sez'"; #whitesmoke
|
---|
| 49 | $res = $dbi->prepare("$sql");
|
---|
| 50 | $res->execute();
|
---|
| 51 | }elseif(!$sezstat){ #voti
|
---|
| 52 | $sql="SELECT validi+nulli+bianchi+contestati as voti FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
| 53 | $res = $dbi->prepare("$sql");
|
---|
| 54 | $res->execute();
|
---|
| 55 | list($voti)=$res->fetch(PDO::FETCH_NUM);
|
---|
| 56 | if($voti) {
|
---|
| 57 | $sezstat=5;
|
---|
| 58 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #F5F5F5;' where id_cons='$id_cons' and id_sez'=$id_sez'"; #whitesmoke
|
---|
| 59 | $res = $dbi->prepare("$sql");
|
---|
| 60 | $res->execute();
|
---|
| 61 | }elseif(!$sezstat) {
|
---|
| 62 | $sql="SELECT count(0) FROM ".$prefix."_ele_voti_parziale where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
| 63 | $res = $dbi->prepare("$sql");
|
---|
| 64 | $res->execute();
|
---|
| 65 | list($righe)=$res->fetch(PDO::FETCH_NUM);
|
---|
| 66 | $num_ril=$righe % 4;
|
---|
| 67 |
|
---|
| 68 | if($num_ril==0) {$cursez="style=\" background: #7FFFD4;";}#aquamarine
|
---|
| 69 | elseif($num_ril==1) {$cursez="style=\" background: #ADD8E6;";}#lightblue
|
---|
| 70 | elseif($num_ril==2) {$cursez="style=\" background: #DCDCDC;";}#gainsboro
|
---|
| 71 | elseif($num_ril==3) {$cursez="style=\" background: #E0FFFF;";}#lightcyan
|
---|
| 72 | $sql="UPDATE ".$prefix."_ele_sezioni set colore='$cursez' where id_cons='$id_cons' and id_sez='$id_sez'";
|
---|
| 73 | $res = $dbi->prepare("$sql");
|
---|
| 74 | $res->execute();
|
---|
| 75 |
|
---|
| 76 |
|
---|
| 77 |
|
---|
| 78 | }
|
---|
| 79 | }
|
---|
| 80 | }
|
---|
| 81 | }
|
---|
| 82 | }
|
---|
| 83 |
|
---|
| 84 |
|
---|
| 85 | ?> |
---|