8" ;
}
$str = "" ;
$query = "
SELECT
C.IdClienti as IdCliente,
C.Nome as NomeCliente,
count(*) as TotParApe
FROM
clienti C
inner join ordini O on C.IdClienti = O.IdCliente
inner join fornitori F on O.idfornitore = F.idfornitori
WHERE
O.SaldoFattura = 0 and
O.Anno <= $anno
$whereBon
group by
C.Nome
ORDER BY
C.Nome ASC
" ;
list($n, $d) = $db->RecuperaDati($query) ;
// print_r($d) ; exit ;
$totclienti = $n ;
for ($i = 0; $i < $n ; $i++ )
{
$id = $d['IdCliente'][$i] ;
$parape = $d['TotParApe'][$i] ;
$cliente = htmlspecialchars($d['NomeCliente'][$i]) ;
$str .= "| $cliente | $parape |
" ;
}
$str .= "" ;
$header = "NOME CLIENTE,PARTITE APERTE" ;
$strSort = "str,int" ;
$iniWP = "40,20" ;
$setColType = "ro,ro" ;
$setColAlign = "left,center" ;
$attHeaderStyle = "background-color:#ffffaa;border-bottom:1px solid silver;padding:2px 2px 0px 2px" ;
$attH = ", " ;
$attHS = "$attHeaderStyle,$attHeaderStyle" ;
?>
<? echo TITLE ?>
Numero Cienti: ; Attualmente filtrati:
> Considera i Bonifici