query($query) ;
while ($db->next_record())
$totordini = $db->f("totordini") ;
$dbt = new FC_SQL ;
$totfornitori = 0 ;
$query = "select * from $tfornitori order by Nome" ;
$db->query($query) ;
while ($db->next_record())
{
$totfornitori ++ ;
$totf = 0 ;
$id = $db->f("IdFornitori") ;
$dbt->query("select count(*) as totf from $tordini where idfornitore = $id") ;
while ($dbt->next_record())
{
$item[0][] = $db->f("Nome") ;
$item[1][] = $dbt->f("totf") ;
}
}
switch($colToSort)
{
case 0: // Nome Fornitore
array_multisort($item[0], $orderByDir, $item[1]) ;
break ;
case 1: // Numero Ordini
case 2: // %Ordini
array_multisort($item[1], $orderByDir, $item[0]) ;
break ;
default ;
}
$arrParGen = array() ;
$arrParGen = RecuperaParametriGenerali($arrParGen, $tparametri) ;
$nome = $arrParGen['NomeAgenzia'] ;
$sede = "Sede operativa: " . $arrParGen['IndirizzoAgenzia'] ;
$datisede = "Telefono: " . $arrParGen['TelefonoAgenzia'] .
" Fax: " . $arrParGen['FaxAgenzia'] .
" -- P.I. " . $arrParGen['PartitaIvaAgenzia'] ;
$emailsede = "Email: " . $arrParGen['MailAgenzia'] ;
?>
<? echo TITLE ?>
 |
|
|
|
| al |
| Nome |
Numero Ordini |
% Ordini |
|
|
|