<!--- 
<!-------------- CONTROLLO ACCESSO --------------->
<cfset liv="k3"><cfinclude template="intranet/controllo.cfm">
<!-------------- CONTROLLO ACCESSO --------------->
 --->

<cfparam name="session.filtra_fornitore" default="0">
<cfparam name="session.importo_da" default="0">
<cfparam name="session.importo_a" default="50000">


<cfif isdefined("form.IDSocieta")>
		<cfset session.filtra_fornitore = form.IDSocieta>
	<cflocation addtoken="no" url="scheda_contabile_fornitore_pdf.cfm">
</cfif>

<cfif not isnumeric(session.importo_da)><cfset session.importo_da = 0></cfif>
<cfif not isnumeric(session.importo_a)><cfset session.importo_a = 0></cfif>

<CFQUERY NAME="elenco"
 DATASOURCE="#session.dsn#">
	SELECT *
	FROM fatture_passivo
	Where IDDocumento > 0
	<cfif session.filtra_fornitore gt 0> and IDSocieta = #session.filtra_fornitore#</cfif>
	ORDER BY data_emissione, Numero_fattura</CFQUERY>
<CFQUERY NAME="soc"
 DATASOURCE="#session.dsn#">
SELECT Societa
FROM anagrafica 
where IDSocieta = #session.filtra_fornitore#
</CFQUERY>

<cfcontent type="application/pdf">
<cfparam name="url.nomefile" default="Scheda_Contabile_Fornitore_#replace(replace(replace(replace(replace(soc.societa, "-", " ", "all"), " ", "_", "all"), ".", "", "all"), "__", "_", "all"), "__", "_", "all")#">
<cfparam name="url.or" default="landscape">
<cfheader name="Content-Disposition" value="attachment; filename=#url.nomefile#.pdf">


<!---------------------------------------------------------------------->
<!---------------------------------------------------------------------->
<!---------------------------------------------------------------------->
<cfdocument format="pdf" pagetype="a4" margintop="2.5" marginbottom="2.5" marginleft="1" marginright="1" unit="cm">
<cfdocumentitem type="header">
	<link href="file:///d:/wwwroot/voxnet/intranet/css/main.css" rel="stylesheet" type="text/css">
	<link href="file:///d:/wwwroot/voxnet/intranet/css/standard.css" rel="stylesheet" type="text/css">
    <table width="100%" border="0" cellspacing="3" cellpadding="3" align="center">
    <tr><td width="250" align="center"><img src="file:///d:/wwwroot/voxnet/intranet/img/Logo_sof_197.jpg" width="197" height="98"></td>
    <td align="left" valign="middle"><div align="center" class="testo4">Scheda contabile fornitore <cfoutput>#soc.societa#</cfoutput></div></td></tr>
    </table>
</cfdocumentitem>
<cfdocumentitem type="footer">
	<hr size="1" color="#000084">
    <table width="100%" border="0" cellspacing="0" cellpadding="3" align="center" 
    style="font-family:Verdana, Arial, Helvetica, sans-serif; color:#002863;">
    <tr><td style="font-size:16px;">Sofytech&nbsp;S.r.l.</td>
    <td style="font-size:9px;" valign="bottom">Sede legale e operativa:<br>Via Montenero 26 d/e - 00012 Guidonia Montecelio (RM) - Tel: 0774/1871145 - Fax: 06/62277358<br>Cap.Sociale Euro 30.000,00 Int.versato - P.I., Cod.Fiscale e Iscr.Reg.Imprese Roma 07811681001</td>
    <td rowspan="2" style="font-size:8px;" valign="bottom">&nbsp;&nbsp;pag.&nbsp;<cfoutput>#cfdocument.currentpagenumber#&nbsp;di&nbsp;#cfdocument.totalpagecount#</cfoutput>
    </div></td></tr>
    </table>
</cfdocumentitem>
<html>
<head>
	<title>Scheda contabile fornitore <cfoutput>#soc.societa#</cfoutput></title>
	<link href="file:///d:/wwwroot/voxnet/intranet/css/main.css" rel="stylesheet" type="text/css">
	<link href="file:///d:/wwwroot/voxnet/intranet/css/standard.css" rel="stylesheet" type="text/css">
	</head>
	<body topmargin="0" leftmargin="0">
<div align="center">
<table width="650" border="1" cellspacing="0" cellpadding="1" align="center" class="testo1" bordercolor="#aaaaaa">
<tr align="center" class="testob2">
	<td>data</td>
	<td colspan="2">N&deg;</td>
	<td>Imponibile</td>
	<td>IVA</td>
	<td>Tot fattura</td>
	<td>fornitore</td>
	<td>Acconto</td>
	<td>Saldo a pagare</td>
</tr>
<cfset fatturato = 0>
<cfset incassato = 0>
<cfset totale_iva = 0>
<cfset ra = 0>
<cfloop query="elenco">
	<cfif #valuta# eq "USD">
        <cfset saldo = (#importo# + #iva#) / #cambio# - #pagato#>
        <cfset imp_tot = (#importo# + #iva#) / #cambio#>	
    <cfelse>
        <cfset saldo = #importo# + #iva# - #pagato#>
        <cfset imp_tot = #importo# + #iva#>	
    </cfif>
	<cfif fix(saldo) neq 0>
		<CFQUERY NAME="Soc"
		 DATASOURCE="#session.dsn#">
			SELECT Societa
			FROM anagrafica
			Where IDSocieta = #elenco.IDSocieta#
		</CFQUERY>
		<cfoutput>
			<tr align="right" <cfif elenco.ndc eq "ndc">bgcolor="##ffff00"</cfif>>
			<td>#dateformat(data_emissione, "dd/mm/yyyy")#</td>
			<td><cfif elenco.ndc eq "ndc">NC<cfelse>FT</cfif></td>
			<td>#Numero_Fattura#</td>
			<td>#LSEuroCurrencyFormat(Importo, "none")#</td>
			<td>#LSEuroCurrencyFormat(iva, "none")#</td>
			<td>#LSEuroCurrencyFormat(Importo+iva, "none")#</td>
			<td align="left">#Soc.Societa#</td>
			<td>#LSEuroCurrencyFormat(pagato, "none")#</td>
			<td><strong><cfif fix(saldo) neq 0>#LSEuroCurrencyFormat(saldo, "none")#<cfelse>PAGATA</cfif></strong></td>
			</tr>
		</CFOUTPUT>
		<cfif elenco.ndc eq "ndc">
			<cfset impor = -imp_tot>
			<cfset saldo = -saldo>
		<cfelse>
			<cfset impor = imp_tot>
		</cfif>
		<cfif #valuta# eq "Lira">
			<cfset fatturato = fatturato + impor/1936.27>
			<cfset incassato = incassato + saldo/1936.27>
			<cfset totale_iva = totale_iva + iva/1936.27>
		<cfelse>
			<cfset fatturato = fatturato + impor>
			<cfset incassato = incassato + saldo>
			<cfset totale_iva = totale_iva + iva>
		</cfif>
	</cfif>
</cfloop>
<cfset fatturato_ = fatturato>
<cfset incassato_ = incassato>
<cfset totale_iva_ = totale_iva>
<cfoutput>
<!--- 
	<tr class="testo2">
	<td colspan="7" align="right">Tot da incassare (imponibile):</td>
	<td>#LSEuroCurrencyFormat(fatturato, "local")#<!--- <br>
	<span class="testo1">L.&nbsp;#LSNumberFormat(fatturato*1936.27)#</span> ---></td>
	</tr>
	 --->
	<tr class="testob2" align="right">
	<td colspan="8">Tot da pagare:</td>
	<td>#LSEuroCurrencyFormat(incassato, "none")#</td>
	</tr>
	</TABLE>
</cfoutput>

</div></body>
</cfdocument>


