<cfif isdefined("url.vs") or isdefined("form.vs")>
	<cfif isdefined("url.vs")>
        <cfset vs_ = url.vs>
	<cfelseif isdefined("form.vs")>
        <cfset vs_ = form.vs>
	<cfelse>
        <cfset vs_ = "">
    </cfif>
	<cfset vs_ = replace(vs_, ";;", "; ;", "all")>
    <cfif listlen(vs_, ";") ge 6>
    	<cfif listlen(vs_, ";") lt 7>
            <cfset vs_ = listappend(vs_, 0 & "|" & year(now())  & "|" & year(now()) & "|" & 25, ";")>
        </cfif>
		<cfif listlen(vs_, ";") lt 8>
            <cfset vs_ = listappend(vs_, "0|0|0|25", ";")>
        </cfif>
		<cfif listlen(vs_, ";") lt 9>
            <cfset vs_ = listappend(vs_, "0|0|0|0|0|0|25", ";")>
        </cfif>
        <cfset IDsessione = listgetat(vs_, 1, ";")>
        <cfset IDutente = listgetat(vs_, 2, ";")>
        <cfset soc = listgetat(vs_, 3, ";")>
        <cfset lista_aziende = listgetat(vs_, 4, ";")>
        <cfset larghezza = listgetat(vs_, 5, ";")>
        <cfset altezza = listgetat(vs_, 6, ";")>
        <cfquery name="dati_az" datasource="intranet">
            select * from aziende where logo = '#soc#'
        </cfquery>


		<cfif isdefined("form.Societa")>
        	<cfif len(trim(form.Societa)) gt 0><cfset form_Societa = trim(form.Societa)><cfelse><cfset form_Societa = 0></cfif>
        	<cfif len(trim(form.iva_cf)) gt 0><cfset form_iva_cf = trim(form.iva_cf)><cfelse><cfset form_iva_cf = 0></cfif>
        	<cfif len(trim(form.tipo)) gt 0><cfset form_tipo = trim(form.tipo)><cfelse><cfset form_tipo = 0></cfif>
        	<cfif len(trim(form.num_aziende)) gt 0><cfset form_num_aziende = trim(form.num_aziende)><cfelse><cfset form_num_aziende = 0></cfif>
			<cfset vs_ = listsetat(vs_, 8, form_Societa & "|"  & form_iva_cf & "|"  & form_tipo & "|"  & form_num_aziende, ";")>
            <cflocation url="app_anagrafiche.cfm?vs=#vs_#" addtoken="no">
        </cfif>

		<cfset societa_via_cf_tipo_num_aziende = listgetat(vs_, 8, ";")>
        <cfset filtra_Societa = listgetat(societa_via_cf_tipo_num_aziende, 1, "|")>
        <cfset filtra_iva_cf = listgetat(societa_via_cf_tipo_num_aziende, 2, "|")>
        <cfset filtra_tipo = listgetat(societa_via_cf_tipo_num_aziende, 3, "|")>
        <cfset filtra_num_aziende = listgetat(societa_via_cf_tipo_num_aziende, 4, "|")>
		
		<cfif filtra_num_aziende gt 0>
        	<cfset limite = filtra_num_aziende>
        <cfelse>
        	<cfset limite = 1000>
        </cfif>
        <!--- 
        societa_via_cf_tipo_num_aziende <cfoutput>#societa_via_cf_tipo_num_aziende#</cfoutput>
         --->
        <CFQUERY NAME="elenco" DATASOURCE="#dati_az.dsn#" maxrows="#limite#">
            SELECT * FROM anagrafica 
            where IDSocieta > 1
            <cfif filtra_tipo eq 'cli'>
                and Cliente = 'si'
            <cfelseif filtra_tipo eq 'for'>
                and Fornitore = 'si'
            <cfelseif filtra_tipo eq 'nc'>
                and Cliente = 'no' and Fornitore = 'no'
            </cfif>
            <cfif filtra_Societa neq 0>
            	and Societa like '%#filtra_Societa#%'
            </cfif>
            <cfif filtra_iva_cf neq 0>
            	and (codice_fiscale like '%#filtra_iva_cf#%' or Partita_iva like '%#filtra_iva_cf#%')
            </cfif>
            ORDER BY Societa, eliminato
        </CFQUERY>

        <html>
            <head>
                <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
                <title>INTRANET</title>
                <link rel="stylesheet" type="text/css" href="../css/style.css">
                <link rel="stylesheet" type="text/css" href="../css/bordi.css" />
                <script language="javascript" src="../java/common.js"></script>
                <script language="javascript" src="../java/show_hide.js"></script>
            </head>
            
            <body bgcolor="#DDDDDD" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
                <form method="post" id="pulsantiera" action="">
                    <div style="display:table; width:100%;">
                    <div style="display:table-row; width:100%;">
                        <cfoutput>
                            <input type="hidden" name="vs" value="#vs_#">	
                            <div style="display:table-cell; text-align:left; background-color:##DDDDDD; padding:5px; width:100px;"><a href="javascript:void();" 
                                onClick="document.getElementById('pulsantiera').action='app_home.cfm?#cgi.QUERY_STRING#';document.getElementById('pulsantiera').submit();"><img src="http://app.autoroute.it/images/back_64.png" border="0"></a></div>
                            <div style="display:table-cell; text-align:center; vertical-align:middle; background-color:##DDDDDD; padding:5px;" class="testob4">INTRANET :: #dati_az.nome_az#</div>
                            <div style="display:table-cell; text-align:right; background-color:##DDDDDD; padding:5px; width:100px;"><a href="javascript:void();" 
                                onClick="document.getElementById('pulsantiera').action='app_anagrafiche.cfm?#cgi.QUERY_STRING#';document.getElementById('pulsantiera').submit();"><img src="http://app.autoroute.it/images/update64.png" border="0"></a></div>
                        </cfoutput>
                    </div>
                    </div>
                </form> 
                <div align="center" class="testob4">
                    <style type="text/css">
                        <!--
                        :focus:invalid {  background-color:#FF0000;}
                        :valid {  background-color:#00FF00;}
                        /*
                        :required { background-color:#FFFFFF;}
                        */
                        :optional { background-color:#FFFFFF;}
                        -->
                    </style>
                    

                    <form method="post" action="app_anagrafiche.cfm">
                        <cfoutput>
                        <input type="hidden" name="vs" value="#vs_#">	
                        <table border="0" cellpadding="5" cellspacing="0" bordercolor="##999999" background="../img/fondino2.jpg" class="testo4" width="100%">
                            <tr class="testobiancob4" align="center">
                                <td>Elenco aziende - 
                                    <select name="tipo" class="formb4">
                                        <option value="0" <cfif filtra_tipo eq "0">selected</cfif>> - Tutte le tipologie - </option>
                                        <option value="cli" <cfif filtra_tipo eq "all">selected</cfif>>Clienti</option>
                                        <option value="for" <cfif filtra_tipo eq "all">selected</cfif>>Fornitori</option>
                                        <option value="nc" <cfif filtra_tipo eq "all">selected</cfif>>Non classificate</option>
                                    </select>
                                </td>
                            </tr>
                            <tr class="testobiancob4" align="center">
                                <td>Ragione Sociale:<input type="text" name="societa" class="formb4" style="width:250px; height:30px;" value="<cfif filtra_societa neq 0>#filtra_societa#</cfif>"></td>
                            </tr>
                            <tr class="testobiancob4" align="center">
                                <td>C.F. / IVA:<input type="text" name="iva_cf" class="formb4" style="width:250px; height:30px;" value="<cfif filtra_iva_cf neq 0>#filtra_iva_cf#</cfif>"></td>
                            </tr>
                            <tr class="testobiancob4" align="center">
                                <td>Visualizza max: <input type="text" name="num_aziende" formnovalidate type="number" class="formb4" 
                                		style="width:50px; height:30px; text-align:right;" value="<cfif filtra_num_aziende gt 0>#filtra_num_aziende#</cfif>"> aziende 

                                        <input type="submit" value="   &raquo;&raquo;   " class="formb4" style="width:100px; height:30px;"></td>
                            <tr>
                        </table>
                        </cfoutput>
                    </form>
                                
                    <table class="testo2" width="100%" border="1" cellspacing="0" cellpadding="1" background="../img/fondino2.jpg">
                        <tr align="center" class="testobiancob3">
                            <td>#</td>
                            <td>Societa</td>
                            <td>Tipo</td>
                            <td>C.F. / IVA</td>
                            <td>Indirizzo</td>
                            <!--- 
                            <td>Recapiti</td>
                             --->
                        </tr>
                        <cfset sfondo = "cccccc">
                        <cfoutput query="elenco">
							<cfif eliminato><cfset sfondo = "ffaaaa"><cfelseif sfondo eq "ffffff"><cfset sfondo = "cccccc"><cfelse><cfset sfondo = "ffffff"></cfif>
                            <tr bgcolor="###sfondo#" onClick="location.href='app_anagrafica.cfm?vs=#vs_#&IDsocieta=#elenco.IDsocieta#'" align="left">
                                <td>#currentrow#</td>
                                <td>#Societa#<cfif eliminato><br>(<em>Non Attiva</em>)</cfif></td>
                                <td><cfif cliente eq "si" and fornitore eq "si">Cli/For<cfelseif cliente eq "si">Cliente<cfelseif Fornitore eq "si">Fornitore<cfelse>&nbsp;</cfif></td>
                                <td>
                                    <cfif len(trim(partita_iva)) gt 0 and len(trim(codice_fiscale)) gt 0 and partita_iva neq codice_fiscale>
                                        #codice_fiscale# #partita_iva#
                                    <cfelseif len(trim(partita_iva)) gt 0 and partita_iva eq codice_fiscale>
                                        #partita_iva#
                                    <cfelseif len(trim(partita_iva)) gt 0 and len(trim(codice_fiscale)) is 0>
                                        #partita_iva#
                                    <cfelseif len(trim(partita_iva)) is 0 and len(trim(codice_fiscale)) gt 0>
                                        #codice_fiscale#
                                    <cfelse>&nbsp;</cfif>
                                </td>
                                <td>#Indirizzo_fatturazione#<br>#CAP_fatturazione# #Citta_fatturazione# (#StatoOProvincia_fatturazione#)</td>
                                <!--- 
                                <td>
                                    <cfif len(trim(Telefono)) gt 0>Tel.#Telefono#</cfif>
                                    <cfif len(trim(Fax)) gt 0>Fax.#Fax#</cfif>
                                    <cfif len(trim(PostaElettronica)) gt 0><a href="mailto:#PostaElettronica#" class="testo2">#PostaElettronica#</a></cfif>
                                    <cfif len(trim(Telefono)) + len(trim(Fax)) + len(trim(PostaElettronica)) is 0>&nbsp;</cfif>
                                </td>
                                 --->
                            </tr>
                        </cfoutput>
                    </TABLE>
                </div>
            </body>
        </html>
	</cfif>
</cfif>



