Changeset 449 for trunk


Ignore:
Timestamp:
Apr 1, 2025, 6:12:23 PM (8 months ago)
Author:
roby
Message:
  • CLIENT

-- modifica ad una query per i grafici

Location:
trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • trunk/admin/versione.php

    r448 r449  
    11<?php
    22
    3 $versione = "3.0 rev 448";
     3$versione = "3.0 rev 449";
    44$version_number = $versione;
    55$datarel = "01 aprile 2025";

  • trunk/client/temi/bootstrap/query.php

    r441 r449  
    561561}
    562562
     563function scrutinio_affluenze()
     564{
     565        global $id_cons,$prefix,$dbi;
     566        $sql="select t3.data,t3.orario from ".$prefix."_ele_voti_parziale as t3 where t3.id_cons=$id_cons order by t3.data desc,t3.orario desc limit 0,1";
     567        $sth = $dbi->prepare("$sql");
     568        $sth->execute();
     569        $row = $sth->fetchAll();
     570        $data=$row[0][0];
     571        $orario=$row[0][1];
     572        $sql="select count(t3.orario) from ".$prefix."_ele_voti_parziale as t3 where t3.id_cons=$id_cons and t3.data='$data' and t3.orario='$orario'";
     573        $sth = $dbi->prepare("$sql");
     574        $sth->execute();
     575        $row = $sth->fetchAll();       
     576        return($row);   
     577       
     578}
     579
    563580function scrutinio_schede($tab)
    564581{
    … …  
    778795{
    779796        global $id_cons,$prefix,$dbi;
    780         $sql="select t3.voti_complessivi,t3.voti_uomini,t3.voti_donne from ".$prefix."_ele_voti_parziale as t3 where t3.id_sez='$id_sez'order by t3.data desc,t3.orario desc limit 0,1";
     797        if($id_sez) $id="and t3.id_sez='$id_sez'"; else $id='';
     798        $sql="select t3.voti_complessivi,t3.voti_uomini,t3.voti_donne from ".$prefix."_ele_voti_parziale as t3 where t3.id_cons=$id_cons $id order by t3.data desc,t3.orario desc limit 0,1";
    781799        $sth = $dbi->prepare("$sql");
    782800        $sth->execute();

  • trunk/client/temi/bootstrap/top_nav.php

    r443 r449  
    306306                                                                                        <li><a class="dropdown-item <?php echo $stato; ?> list-item left-icon" href="modules.php?op=52&id_comune=<?php echo $id_comune.$cirpar;?>&id_cons_gen=<?php echo $id_cons_gen;?>"><svg class="icon icon-sm icon-primary left"><use href="<?php echo $curdir?>/svg/sprites.svg#it-chart-line"></use></svg><span> Votanti</span></a></li>
    307307                                                                                        <?php $tmp=voti_tot_referendum();if($tmp and ($tmp[0][2]+$tmp[0][3])>0) $stato=''; else $stato='disabled'; ?>
    308                                                                                         <li><a class="dropdown-item <?php echo $stato; ?> list-item left-icon" href="modules.php?op=52&id_comune=<?php echo $id_comune.$cirpar;?>&id_cons_gen=<?php echo $id_cons_gen;?>"><svg class="icon icon-sm icon-primary left"><use href="<?php echo $curdir?>/svg/sprites.svg#it-chart-line"></use></svg><span> Voti</span></a></li>
     308                                                                                        <li><a class="dropdown-item <?php echo $stato; ?> list-item left-icon" href="modules.php?op=53&id_comune=<?php echo $id_comune.$cirpar;?>&id_cons_gen=<?php echo $id_cons_gen;?>"><svg class="icon icon-sm icon-primary left"><use href="<?php echo $curdir?>/svg/sprites.svg#it-chart-line"></use></svg><span> Voti</span></a></li>
    309309                                                                               
    310310                                                                                <?php }?>       

  • trunk/client/versione.php

    r448 r449  
    11<?php
    2 $versione = "3.0 rev 448";
     2$versione = "3.0 rev 449";
    33$version_number = $versione;
    44$datarel = "01 aprile 2025";
Note: See TracChangeset for help on using the changeset viewer.