<CFQUERY NAME="elenco" DATASOURCE="#session.dsn#">
    SELECT fa.*, odv.oda_cli, a.societa
    FROM (fatture_attivo fa
    INNER JOIN odv ON odv.IDOrdine = fa.IDOrdine)
    LEFT OUTER JOIN anagrafica a ON a.IDSocieta = fa.IDSocieta
    Where fa.Stato = 'Emessa' 
    and abs(fa.importo + fa.tot_iva - fa.anticipo - fa.acconto - fa.pagato - fa.RA_importo) > .99
	and fa.IDSocieta = #session.filtra_IDSocieta#
    ORDER BY a.societa, fa.data_emissione, fa.Numero_fattura
</CFQUERY>
<cfdocument format="pdf" pagetype="a4" margintop="2.5" marginbottom="2.5" marginleft="1" marginright="1" unit="cm" filename="D:\wwwroot\voxnet\intranet\temp\Scheda_contabile_#nomefile#.pdf">
<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</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 cliente </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">
<cfset salta_pagina = false>
<cfset riga = 0>
<cfoutput query="elenco" group="societa">
	<cfset fatturato = 0>
    <cfset incassato = 0>
    <cfset totale_iva = 0>
    <cfset ra = 0>
    <cfset r_a = 0>
    <!--- 
	<cfset riga = 0>
	<cfif salta_pagina>
        <cfdocumentitem type="pagebreak"></cfdocumentitem>
	<cfelse>
    	<cfset salta_pagina = true>
    </cfif>
     --->
	<cfset riga = riga + 6>
	<cfif riga gt 55>
		<cfset riga = 0>
        <cfdocumentitem type="pagebreak"></cfdocumentitem>
    </cfif>
	<span class="testob4">#societa#</span><br>
    <table width="650" border="0" cellspacing="1" cellpadding="2" align="center" class="testo1" bgcolor="##000000">
        <tr align="center" class="testob1" bgcolor="##cccccc">
            <td>data</td>
            <td colspan="2">N&deg;</td>
            <td>Imponibile</td>
            <td>IVA</td>
            <td>Tot fattura</td>
            <td>ODA</td>
            <td>Acconto</td>
            <td>Saldo</td>
            <td>RA</td>
            <td>Scad.</td>
            <td>Mod.</td>
            <td>Saldo a pagare</td>
            <td>Ri.Ba.</td>
        </tr>
		<cfoutput>
            <cfset saldo = (importo + tot_iva - anticipo - acconto - pagato)>
            <cfset r_a = 0>
            <cfif isnumeric(RA_importo)><cfset r_a = ra_importo></cfif>
			<cfset riga = riga + 1>
            <cfif riga gt 55>
				<cfset riga = 0>
                </table><cfdocumentitem type="pagebreak"></cfdocumentitem><table width="650" border="0" cellspacing="1" cellpadding="2" align="center" class="testo1" bgcolor="##000000">
                <tr align="center" class="testob1" bgcolor="##cccccc">
                    <td>data</td>
                    <td colspan="2">N&deg;</td>
                    <td>Imponibile</td>
                    <td>IVA</td>
                    <td>Tot fattura</td>
                    <td>ODA</td>
                    <td>Acconto</td>
                    <td>Saldo</td>
                    <td>RA</td>
                    <td>Scad.</td>
                    <td>Mod.</td>
                    <td>Saldo a pagare</td>
                    <td>Ri.Ba.</td>
                </tr>
            </cfif>
            <cfif datecompare(now(), Scadenza) ge 0><cfset sfondo = "ff9999"><cfelse><cfset sfondo = "ffffff"></cfif>
            <tr align="right" <cfif elenco.ndc eq "ndc">bgcolor="##ffff00"<cfelse>bgcolor="##ffffff"</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(tot_iva, "none")#</td>
                <td>#LSEuroCurrencyFormat(Importo+tot_iva, "none")#</td>
                <td align="left">#oda_cli#&nbsp;</td>
                <td>#LSEuroCurrencyFormat(anticipo + acconto + pagato, "none")#</td>
                <td><strong><cfif fix(saldo) neq 0>#LSEuroCurrencyFormat(saldo, "none")#<cfelse>PAGATA</cfif></strong></td>
                <td>#LSEuroCurrencyFormat(r_a, "none")#</td>
                <td bgcolor="###sfondo#">#dateformat(Scadenza, "dd/mm/yyyy")#</td>
                <td align="left"><cfif left(Mod_pagamento, 2) eq "IT">Bonifico<cfelseif left(Mod_pagamento, 5) eq "Cassa">Contanti<cfelseif Mod_pagamento eq "Ri.Ba.">Ri.Ba.<cfelse>&nbsp;</cfif></td>
                <td><strong><cfif fix(saldo) neq 0>#LSEuroCurrencyFormat(saldo-r_a, "none")#<cfelse>PAGATA</cfif></strong></td>
                <td><cfif isdate(riba_Scadenza)>#dateformat(riba_Scadenza, "dd/mm/yyyy")#<cfelse>-</cfif></td>
            </tr>
            <cfif elenco.ndc eq "ndc">
                <cfset impor = -importo>
                <cfset saldo = -saldo>
            <cfelse>
                <cfset impor = importo>
            </cfif>
            <cfif #valuta# eq "Lira">
                <cfset fatturato = fatturato + impor/1936.27>
                <cfset ra = ra + r_a/1936.27>
                <cfset incassato = incassato + saldo/1936.27>
                <cfset totale_iva = totale_iva + tot_iva/1936.27>
            <cfelse>
                <cfset fatturato = fatturato + impor>
                <cfset ra = ra + r_a>
                <cfset incassato = incassato + saldo>
                <cfset totale_iva = totale_iva + tot_iva>
            </cfif>
        </cfoutput>
		<tr class="testob1" align="right" bgcolor="##cccccc">
            <td colspan="12">Tot da incassare:</td>
          <td>#LSEuroCurrencyFormat(incassato-ra, "none")#</td>
          <td>&nbsp;</td>
		</tr>
    </TABLE>
    <br>&nbsp;<br>
</cfoutput>


</div></body>
</cfdocument>
