Changeset 424 for trunk/admin/modules/Elezioni/query.sql
- Timestamp:
- Jun 13, 2024, 7:18:22 PM (4 weeks ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/query.sql
r406 r424 1 1 <?php 2 2 3 3 if (!defined('ADMIN_FILE')) { … … 96 96 function elenco_cons() 97 97 { 98 global $perms,$dbi,$prefix,$currentlang,$aid,$id_comune ;98 global $perms,$dbi,$prefix,$currentlang,$aid,$id_comune,$giorniaut; 99 99 100 100 if ($perms<64) { 101 $sql="select t2.id_cons,t1.descrizione,t4.genere,t1.id_cons_gen,t2.chiusa from ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2, ".$prefix."_ele_tipo as t4 where t1.id_cons_gen=t2.id_cons_gen and t2.id_comune=$id_comune and t1.tipo_cons=t4.tipo_cons and date_add(t1.data_fine, interval 3day)>CURDATE() and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and permessi>0)";101 $sql="select t2.id_cons,t1.descrizione,t4.genere,t1.id_cons_gen,t2.chiusa from ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2, ".$prefix."_ele_tipo as t4 where t1.id_cons_gen=t2.id_cons_gen and t2.id_comune=$id_comune and t1.tipo_cons=t4.tipo_cons and date_add(t1.data_fine, interval $giorniaut day)>CURDATE() and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and permessi>0)"; 102 102 } 103 103 elseif ($perms<128) {
Note:
See TracChangeset
for help on using the changeset viewer.