Changeset 328 for trunk/admin/modules/Elezioni/ele_colora_sez.php
- Timestamp:
- Feb 16, 2020, 11:20:46 PM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/ele_colora_sez.php
r264 r328 43 43 if($genere) 44 44 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'"; 45 else 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(); 46 50 $sql="SELECT id_gruppo FROM ".$prefix."_ele_voti_ref where id_sez='$id_sez'"; 47 51 } 48 52 $res = $dbi->prepare("$sql"); 49 53 $res->execute(); … … 52 56 if($righe){ 53 57 $sezstat=4; 54 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#B0C4DE' where id_cons='$id_cons' and id_sez='$id_sez'"; #"LIGHTSTEELBLUE" 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" 55 61 $res = $dbi->prepare("$sql"); 56 62 $res->execute();
Note:
See TracChangeset
for help on using the changeset viewer.