1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
With DataModule1 do
begin
// récupération des informations du client.
With AdoQMySQL do
begin
Close;
SQL.Clear;
SQL.Add('Select *');
SQL.Add('From client as c inner join clientinfo as ci on c.nclient=ci.nclient');
SQL.ADd('Where MemberId = ' + Data.Total.MemberId);
Open;
MemoMessage('Document pour : ' + FieldByName('NomClient').AsString);
Application.ProcessMessages;
Data.Email := FieldByName('Email').asString;
With RvProject1,Data.Total do
begin
ProjectFile := GAPPPATH + 'Files\ListingPv.rav';
// Ouverture du projet pour mettre les paramètres
Open;
SetParam('PADRNOM',FieldByName('NomClient').AsString);
SetParam('PADRADR1',FieldByName('Adresse1').AsString);
SetParam('PADRADR2',FieldByName('Adresse2').AsString);
SetParam('PADRCP',FieldByName('CodePostal').AsString);
SetParam('PADRVILLE',FieldByName('Ville').AsString);
SetParam('PDATEDOCS',FormatDateTime('DD/MM/YYYY',CreateDate));
SetParam('PMONTANTENCAISSE',FormatFloat('0.00',TotalAmount));
SetParam('PDEVISE',CurrencyType);
SetParam('PFRAIS',FormatFloat('0.00',DiscountFee));
SetParam('PFRAISAUTRES',FormatFloat('0.00',OtherFees));
SetParam('PPAIEMENT',FormatFloat('0.00',Payment));
// Fermeture du projet
Close;
end;
// Configuration pour la génération du PDF
With RvSystem1 do
begin
SystemSetups := RvSystem1.SystemSetups - [ssAllowSetup];
DefaultDest := rdFile;
RenderObject := RvRenderPDF1;
DoNativeOutput := False;
OutputFileName := GAPPPATH +
FormatDateTime('RPV-YYMMDD-',Data.Total.CreateDate) +
FormatDateTime('YYMMDDhhmmsszzz-',Now) +
FieldByName('Login').AsString + '.pdf';
MemoMessage('Nom du document : ' + OutputFileName);
Data.PDFName := OutputFileName;
Application.ProcessMessages;
end; // With
RvProject1.ExecuteReport('Report1');
end; // With
end; // with |
Partager