Changeset 367 for trunk/admin/modules
- Timestamp:
- May 15, 2022, 10:58:07 PM (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/ele_permessi.php
r366 r367 200 200 if ($perms>32 and $permessi<$perms and $aid2) { 201 201 if ($do == "autorizza") { 202 $sql="select num_sez from ".$prefix."_ele_sezioni where id_sez='$id_sez'"; 203 $res = $dbi->prepare("$sql"); 204 $res->execute(); 205 list ($num_sez)=$res->fetch(PDO::FETCH_NUM); 202 if($id_sez) { 203 $sql="select num_sez from ".$prefix."_ele_sezioni where id_sez='$id_sez'"; 204 $res = $dbi->prepare("$sql"); 205 $res->execute(); 206 list ($num_sez)=$res->fetch(PDO::FETCH_NUM); 207 } 206 208 $sql="select data_inizio from ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'"; 207 209 $compl = $dbi->prepare("$sql"); … … 212 214 $compl->execute(); 213 215 while(list ($id_cons)= $compl->fetch(PDO::FETCH_NUM)){ 214 $sql="select id_sez, id_sede from ".$prefix."_ele_sezioni where id_cons='$id_cons' and num_sez='$num_sez'"; 215 $res = $dbi->prepare("$sql"); 216 $res->execute(); 217 if(!$res->rowCount()) continue; 218 list ($id_sez,$id_sede)=$res->fetch(PDO::FETCH_NUM); 216 if($id_sez) { 217 $sql="select id_sez, id_sede from ".$prefix."_ele_sezioni where id_cons='$id_cons' and num_sez='$num_sez'"; 218 $res = $dbi->prepare("$sql"); 219 $res->execute(); 220 if(!$res->rowCount()) continue; 221 list ($id_sez,$id_sede)=$res->fetch(PDO::FETCH_NUM); 222 } 219 223 $sql="select aid from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid2'"; 220 224 $res = $dbi->prepare("$sql");
Note:
See TracChangeset
for help on using the changeset viewer.