/********************************************************************** * ScegliAgenteFornitore * VERSIONE 3.0 READY **********************************************************************/ include ("../common/public.php") ; $gime = date("d/m") ; $query = " select F.* from fornitori F where F.Attivo = 1 or (F.Attivo = 0 and YEAR(F.DataDisattivazione >= $anno)) order by F.Nome " ; debug (0, $query) ; list($tot_for, $d) = $db->RecuperaDati($query) ; for($i=0; $i<$tot_for; $i++) { $fornid[] = $d['IdFornitori'][$i] ; $fornnome[] = $d['Nome'][$i] ; } if ($profilo < 3 ) $query = " select * from agenti order by nome " ; else $query = " select * from agenti where idagenti != 4 and idagenti != 5 and idagenti != 9 and idagenti != 10 order by nome " ; $db->query($query) ; while ($db->next_record()) { $ageid[] = $db->f("IdAgenti") ; $agenome[] = $db->f("Nome") ; } ?>
| Cliente: | Agente: | Fornitore: | |||
Nessun Fornitore presente in archivio |