codice:
//DETTAGLIO FATTURA
var cn = new ActiveXObject("ADODB.Connection");
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/Inetpub/wwwroot/mipson/public/mdb-database/db.mdb;Persist Security Info=False";
cn.Open(strConn);
var rs = new ActiveXObject("ADODB.Recordset");
var SQL = "SELECT DETT_FATTURE.cod_art, DETT_FATTURE.articolo, DETT_FATTURE.qnt, DETT_FATTURE.prezzo_listino, DETT_FATTURE.prezzo, DETT_FATTURE.tot, FATTURE.sconto FROM FATTURE, DETT_FATTURE WHERE (DETT_FATTURE.n_fatt=161) AND FATTURE.id_fattura = DETT_FATTURE.n_fatt;";
rs.Open(SQL, cn);
x=pdf.GetX();
y=pdf.GetY();
pdf.SetFont('Arial','',10);
while(!rs.eof) {
cod_art=(rs(0));
articolo=(rs(1));
qnt=(rs(2));
prezzo_listino=(rs(3));
prezzo=(rs(4));
tot=(rs(5));
sconto=(rs(6));
pdf.SetY(y);
pdf.SetX(10);
//x=pdf.GetX()+35;
y=pdf.GetY();
pdf.MultiCell(35,5,'','L,T,R',0,'L',0);
pdf.SetY(y);
pdf.SetX(45);
//x=pdf.GetX()+70;
pdf.MultiCell(70,5,articolo,'B,L,T,R',0,'L',0);
y2=pdf.GetY();
y_old=y;
diff_y=y2-y_old;
pdf.SetY(y);
pdf.SetX(115);
//x=pdf.GetX()+20;
pdf.Cell(20,diff_y,prezzo_listino,'B,L,T,R',0,'L',0);
y2=pdf.GetY();
y_old=y;
if (y2>y_old)
{
diff_y=y2-y_old;
}
pdf.SetY(y);
pdf.SetX(135);
//x=pdf.GetX()+15;
pdf.MultiCell(15,diff_y,sconto,'B,L,T,R',0,'L',0);
y2=pdf.GetY();
y_old=y;
if (y2>y_old)
{
diff_y=y2-y_old;
}
pdf.SetY(y);
pdf.SetX(150);
//x=pdf.GetX()+20;
pdf.MultiCell(20,diff_y,prezzo,'B,L,T,R',0,'L',0);
y2=pdf.GetY();
y_old=y;
if (y2>y_old)
{
diff_y=y2-y_old;
}
pdf.SetY(y);
pdf.SetX(170);
//x=pdf.GetX()+10;
pdf.MultiCell(10,diff_y,qnt,'B,L,T,R',0,'L',0);
y2=pdf.GetY();
y_old=y;
if (y2>y_old)
{
diff_y=y2-y_old;
}
pdf.SetY(y);
pdf.SetX(180);
//x=pdf.GetX()+20;
pdf.MultiCell(20,diff_y,tot,'B,L,T,R',0,'L',0);
pdf.SetY(y);
pdf.SetX(10);
pdf.MultiCell(35,diff_y,cod_art,'B,L,R',0,'L',0);
y=y+diff_y;
x=10;
rs.MoveNext()
}
rs.Close();
cn.Close();