Changeset 394 for trunk/admin/modules/Elezioni/ele_colora_sez.php
- Timestamp:
- May 21, 2023, 1:46:40 AM (12 months ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/ele_colora_sez.php
r342 r394 20 20 $res->execute(); 21 21 }else{ #candidati 22 $sql="SELECT t 2.id_listaFROM ".$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 $sql="SELECT t1.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' group by t2.id_lista"; 23 23 $res = $dbi->prepare("$sql"); 24 24 $res->execute(); 25 25 $liste=$res->rowCount(); 26 26 list($listescru)=$res->fetch(PDO::FETCH_NUM); 27 if($res->rowCount() and $listescru==0) {$listescru=1;$liste=0;} 27 28 $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 28 29 $res = $dbi->prepare("$sql"); 29 30 $res->execute(); 30 31 list($ltot)=$res->fetch(PDO::FETCH_NUM); 31 if( $liste && $liste==$ltot){32 if(($liste && $liste==$ltot) or $listescru){ 32 33 $sezstat=2; 33 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; #VERDE34 $sql="UPDATE ".$prefix."_ele_sezioni set colore='#99CC33' where id_cons='$id_cons' and id_sez='$id_sez'"; ;#VERDE 34 35 $res = $dbi->prepare("$sql"); 35 36 $res->execute();
Note:
See TracChangeset
for help on using the changeset viewer.