Kumar A. ADempiere 3.6 Cookbook
Подождите немного. Документ загружается.
JasperReports with ADempiere
228
6. Add the momId parameter to the main report, MOMDetail.
7. Add the #AD_Client_Name and the #AD_Org_Name as String type parameters
to the main report.
8. Add the momId as a parameter to the MOMParticipants as well as to the
MOMDiscussionDetail reports.
9. Right-click on the sub-report, MOMParticipants, select Properties, and add the
momId as the sub-report parameter on the Subreport(Other) tab.
Chapter 6
229
10. Similarly, add the momId as a sub-report parameter for the MOMDiscussionDetail
as well.
11. Copy the .jrxml les of the main report and the two sub-reports to the
<ADEMPIERE_HOME>\reports.
12. Create a new report on the Application Dictionary | Report & Process window and
specify MOMDetail.jrxml as the Jasper Report.
JasperReports with ADempiere
230
13. Click on the Parameter tab to add a report parameter, momId, so that a MOM ID can
be passed from the system to the reports.
Chapter 6
231
14. Add a new menu node under the MOM menu by name, say, MoM Detail.
15. Log out and log in as GardenAdmin/GardenAdmin with the GardenWorld
Admin role.
16. Click on the MoM Detail node under the MOM menu. This will prompt you to select
the MOM of your choice.
JasperReports with ADempiere
232
17. Select a MOM from the drop-down menu and click on the Start button to run the
report. Upon success, you shall see the well formatted MOM details presented to you
by the report.
Using custom report for printing
When a Print Format is not dened for a tab, or when we click on the Print Preview or Print
toolbar button, by default, ADempiere picks up the default layout and renders the report
using it. However, there may be situations where we may have to produce a nice looking
document, (for example, a quotation) which can be shared with the customers or suppliers.
To accomplish this, in this recipe, we will see what steps we have to go through to use the
report that we designed in the previous recipe for the Print Preview.
How to do it...
1. Go to the Menu | System Admin | General Rules | Printing | Print Format window
and create a new print format, c_mom_v_2 – MOM Print Format, with the Form
checked and MOM Detail Report selected as the Jasper Process.
Chapter 6
233
2. Open the Minutes Of Meeting window detail on the Application Dictionary |
Window, Tab, and Field window.
3. Go to the Tab tab, elect MOM Detail Report in the Process drop-down, and save
the record.
JasperReports with ADempiere
234
4. Log out and log in as GardenAdmin/GardenAdmin with the GardenWorld Admin role
and click on the Print Preview toolbar button. This will prompt you to select the MOM.
5. Select a MOM and click on the tick button. You shall see the output generated as per
the designed report.
7
PayPal Integration
In this chapter, we will cover:
f Preparing the ground
f Working with PayPal APIs
f Making payment to a PayPal account
f Receiving payment from a PayPal account
f Integrating PayPal Instant Payment Notication (IPN)
Introduction
PayPal is one of the most popular and convenient ways to make a payment to someone
who owns a PayPal account. PayPal provides the integration with the shopping cart (using
their different checkout mechanisms) as well as the integration with the back-ofce (using
their APIs and IPN). In Chapter 6, VirtueMart Integration, we looked at the integration of
ADempiere with the Joomla! VirtueMart shopping cart, which provides integration with the
PayPal checkout. In this chapter, we will focus on the back-ofce integration of PayPal with
ADempiere to process payments online.
As we all may know that, in order to transact with PayPal, one needs to have a PayPal account.
PayPal offers different types of accounts which serve a specic purpose like a buyer account
or a seller account, and so on. While we are building the integration layer, we will have to go
through many cycles of testing and verication. Doing this in the production environment is
next to impossible to imagine, as it involves real accounts and real transactions (and hence
charges). To overcome this stumbling block, we will be using PayPal's Sandbox infrastructure,
which is intended for developer use. This infrastructure facilitates the building and the testing
of the integration code and once it is tested, thoroughly, then all it requires is a couple of
changes, like, replacing the sandbox access detail with the production access detail, and the
same code will work in the production environment as well.
Down l o a d f r o m Wow ! e B o o k < www. w o w e b o o k . com>
PayPal Integration
236
In this chapter, we will start with setting up the PayPal accounts and its API SDKs so that it
can be used in the integration code and testing of the same. Later, we will build the PayPal
payment processor in ADempiere to post payments directly to the PayPal accounts.
Preparing the ground
This recipe describes the things required to prepare ourselves for the PayPal integration
including the PayPal account setup and preparing the environment for integration using
the PayPal APIs.
Getting ready
Install soapUI, which we will be using to test PayPal APIs.
How to do it...
1. Sign up for a PayPal Sandbox account on https://developer.paypal.com/.
2. Log in using the newly created account detail.
3. Follow the instructions mentioned in the PayPal Sandbox User Guide
(
https://developer.paypal.com/en_US/pdf/PP_Sandbox_UserGuide.
pdf
) and create the Precongured Test Accounts with PayPal providing the following
default types
f Buyer
f Seller
f Website Payments Pro
4. Select the Website Payments Pro account and click on Enter Sandbox Test Site.
Enter the login and password details for the selected account, when prompted.
5. Go to the Merchant Services tab.
6. Click on the Website Payments Pro link on the left-hand side of the page.
7. Click on the GET STARTED button.
8. Click on the View API Signature link under the Request API credentials to create
your own API username and password option and save the details for further use.
9. Now, select the seller account on the Test Accounts page and click on the Enter
Sandbox Test Site button.
10. Click on API Access link under the Account information section on the My Account
| Prole tab.
11. Click on the View API Certicate link in the Option 2 section and make note of
the credentials.
Chapter 7
237
12. Set up a project in soapUI using PayPal's WSDL: https://www.paypalobjects.
com/wsdl/PayPalSvc.wsdl.
13. From the WSDL le, note down the version value. At the time of writing this chapter,
the version was 64.
14. Run the following SOAP request in soapUI:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:urn="urn:ebay:api:PayPalAPI" xmlns:urn1="urn:ebay
:apis:eBLBaseComponents">
<soapenv:Header>
<urn:RequesterCredentials>
<urn1:Credentials>
<urn1:Username>ajitku_1282880134_biz_api1.gmail.com</
urn1:Username>
<urn1:Password>1282880141</urn1:Password>
<urn1:Signature>AXTsSMU3tr.t2l4lsPvBiX3G34zMAk2bw8FZpxAUBE
K2ymQHTMc-VZdS</urn1:Signature>
</urn1:Credentials>
</urn:RequesterCredentials>