include ("../common/public.php") ;
$gime = date("d/m") ;
$arr_for = array() ;
$fornid = array() ;
$fornnome[] = array() ;
if ($anno < '2016')
{
?>
exit ;
}
$query = "
select
count(*) as tot_for
from
fornitori
" ;
$db->query($query) ;
while ($db->next_record())
$tot_for = $db->f("tot_for") ;
if ($tot_for > 0)
{
$qf = "
select
*
from
fornitori
where
(attivo = '1') or
(attivo = '0' and AnnoDisattivazione > $anno)
order by
Nome
" ;
debug (1, $qf) ;
$db->query($qf) ;
while ($db->next_record())
{
$fornid[] = $db->f("IdFornitori") ;
$fornnome[] = $db->f("Nome") ;
$idfor = $db->f("IdFornitori") ;
$arr_for[$idfor] = $db->f("Nome") ;
}
}
// print_r($fornnome) ; exit ;
?>
echo TITLE ?>
/****************************************************
* FAB 26.10.21
* PRIMA era cosė:
$q = "select distinct IdFornitori, Nome from (" ;
$an_f = $anno ;
for ($an = "2008"; $an <= $an_f; $an ++)
{
$tbl_for = "fornitori_$an" ;
if ($an < $an_f )
$q .= "select IdFornitori, Nome from $tbl_for as F_$an union " ;
else
$q .= "select IdFornitori, Nome from $tbl_for as F_$an) as PP order by Nome " ;
}
$db->query($q) ;
while ($db->next_record())
{
$idfor = $db->f("IdFornitori") ;
$arr_for[$idfor] = $db->f("Nome") ;
}
$tot_for = count($arr_for) ;
* adesso si controlla solo la tabella fornitori
************************************************
$q = "select * from fornitori order by Nome" ;
$db->query($q) ;
while ($db->next_record())
{
$idfor = $db->f("IdFornitori") ;
$arr_for[$idfor] = $db->f("Nome") ;
}
$tot_for = count($arr_for) ;
*/
?>
if ($tot_for > 0) : ?>
(N.B: attualmente ci sono echo $tot_for ?> fornitori presenti in archivio)