...
h3. Scenario
By: Lachlan Aldred
A purchase order arrives from a trading partner. Two new documents need to be created using it:
# A billing document that contains the billing address and the total cost of the purchase.
# A shipping document that contains the ship-to address the list of items, and the address of the shipper.
To create the billing document we need to process the incoming purchase order and calculate the total cost by calculating the sum-total of each line item, and its quantity. We also need to include the bill-to address in the PO.
To create the shipping document we need to extract the ship-to address and each line item from the purchase order. Furthermore we need to merge this data with our own preferred shipper address.
XSLT is a powerful XML transformations language capable of performing this task, however most non-experts find it difficult to write correct XSLT scripts. XQuery is much more concise, and easier to learn, particularly for people familiar with SQL. In this case we use an XQuery Component to perform the transformations.
{info:title=About XQuery}
XSLT is the state-of-the-art technique for complex merges, extractions and transformations of XML, however, its XML syntax is highly verbose, and extremely difficult for non-experts to write. The Word Wide Web Consortium (the standards organization behind XSLT) recognized these challenges and decided to create a simpler XML merging/transformation language for the rest of us to use -- XQuery.
{info}
h3. The Process
A process that produces a shipping document and a billing document is shown below. It uses [PO1v80.xml| http://www.w3.org/People/cmsmcq/2004/po/tests/po1v80.xml], taken from the w3c website, as an input purchase order.
!Process.jpg!
There are two operations in the XQuery component. One can take as input an XML, XFA, String, or Document variable. It can then transform the XML contents into anything else. The other takes as input all of the XML, XFAForm, and XML-String variables in the process-instance data. This way it can easily merge the contents of two XML variables together.
To prepare the billing statement required us to multiply cost of each line item with its quantity; and to total the results. Below is the XQuery we used to do this:
{code:xml}
<avoka:billingStatement>
{//billTo}
<total>$ {
sum( for $i in //item
return ($i/quantity * $i/USPrice) )
}</total>
</avoka:billingStatement>
{code}
Without going into details of the XQuery language too deeply, we extracted the billTo section of the incoming PO, and wrapped the results of our calculations in 'total' tags. The parentheses indicate that the contents are executable XQuery instructions, and the surrounding markup outside these same parentheses is copied literally into the resulting XML document (below).
{code:xml}
<avoka:billingStatement xmlns:avoka="http://www.avoka.com">
<billTo xmlns:apo="http://www.example.com/PO1" country="US">
<name>Robert Smith</name>
<street>8 Oak Avenue</street>
<city>Old Town</city>
<state>PA</state>
<zip>95819</zip>
</billTo>
<total>$ 944.6500000000001</total>
</avoka:billingStatement>
Transforming XML Documents
