query("select * from agenti where idagenti = $agente") ;
while ($db->next_record())
$nome = $db->f("Nome") ;
$titolo = "Lista dei clienti assegnati all'Agente $nome" ;
}
/*************************
* filtro Categoria
**************************/
if (isset($categoria) and ($categoria != 'tutti'))
$where .= " and T.IdTipologie = $categoria" ;
/*************************
* filtro Totale Ordini
**************************/
if (isset($tot) and ($tot != 'tutti'))
if ($tot == 'zero')
$where .= " and O.idordini is null" ;
else
$where .= " and O.idordini > 0" ;
/*************************
* filtro Partita Iva
**************************/
if (isset($piva) and ($piva != ''))
$where .= " and C.piva like '%$piva%'" ;
/*************************
* filtro Codice Fiscale
**************************/
if (isset($codfis) and ($codfis != ''))
$where .= " and C.codfisc like '%$codfis%'" ;
/*****************************************
* filtro Indirizzo
*****************************************/
if (isset($ind) and ($ind != ''))
$where .= " and C.indirizzo like '%$ind%'" ;
/*****************************************
* filtro Cap
*****************************************/
if (isset($cap) and ($cap != ''))
$where .= " and C.cap like '%$cap%'" ;
/*****************************************
* filtro Citta'
*****************************************/
if (isset($citta) and ($citta != ''))
$where .= " and C.citta like '%$citta%'" ;
/*************************
* filtro Zona
**************************/
if (isset($zona) and ($zona != 'tutti'))
{
$where .= " and Z.IdZone = $zona" ;
$db->query("select * from zone where IdZone = $zona") ;
while ($db->next_record())
$nomeZona = $db->f("NomeZona") ;
$titolo = "Lista dei clienti con Zona '$nomeZona'" ;
}
/*****************************************
* filtro Provincia
*****************************************/
if (isset($prov) and ($prov != ''))
$where .= " and C.provincia like '%$prov%'" ;
/*****************************************
* filtro Telefono
*****************************************/
if (isset($tel) and ($tel != ''))
$where .= " and C.telefono like '%$tel%'" ;
/*****************************************
* filtro Fax
*****************************************/
if (isset($fax) and ($fax != ''))
$where .= " and C.fax like '%$fax%'" ;
/*****************************************
* filtro Email
*****************************************/
if (isset($email) and ($email != ''))
$where .= " and C.email like '%$email%'" ;
/*****************************************
* filtro Consegna
*****************************************/
if (isset($consegna) and ($consegna != ''))
$where .= " and C.consegna like '%$consegna%'" ;
/*****************************************
* filtro Note
*****************************************/
if (isset($note) and ($note != ''))
$where .= " and C.note like '%$note%'" ;
$query = "
select
count(O.idordini) as num_ordini,
C.idclienti as IdClienti,
C.cap as CapCliente,
C.citta as CittaCliente,
C.provincia as ProvinciaCliente,
C.telefono as TelefonoCliente,
C.fax as FaxCliente,
C.indirizzo as IndirizzoCliente,
C.piva as PivaCliente,
C.codfisc as CodFiscCliente,
C.nome as NomeCliente,
C.Email as Email,
A.Nome as NomeAgente,
C.Note as NoteCliente,
T.Descrizione as Categoria
from
clienti C
left join ordini O on O.idcliente = C.idclienti and O.Anno = $anno
inner join agenti A on A.IdAgenti = C.IdAgente
inner join tipologie T on T.idtipologie = C.idtipologia
left join zone Z on Z.IdZone = C.IdZona
where
$where
group by
C.idclienti,
C.cap,
C.citta,
C.provincia,
C.telefono,
C.fax,
C.indirizzo,
C.piva,
C.codfisc,
C.nome,
C.Email,
A.Nome,
C.Note,
T.Descrizione
order by
C.Nome" ;
debug (0, $query) ;
$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
Ragione Sociale
Indirizzo
Partita Iva
Telefono
RecuperaDati($query) ;
for ($i=0; $i<$n; $i++)
{
?>
