Attached you will find an XML file, w4Ex1.xml. The XML file was created by middleware which you will be using next week, and is essentially a dump of all invoices and invoice lines (and other associated detail) from the database where the Ship-to State was ‘NSW'. As you can see in the attached file, the XML is rather messy.

In this exercise, produce the XSL file needed to associate with the attached XML file to display the XML data in a format similar to the data shown in an unrelated invoice in attachment photo (see sample_invoice.jpg in attachment).

Looking at the attached XML file, you will see multiple structures for the same invoice number. This is because there is one per line item. Your XSL file will need to collect these together and format all the data associated with one invoice in the manner shown above. Note that some of the tags in the XML file do not correspond to the column names in the database. This is because they were changed in the translation, and others added.

This exercise is quite difficult, so the minimum acceptable solution would be similar to that shown in the Lecture Notes (see attachment) and reproduced here. (Note: This is from orders.xml, not the attached file whose contents are quite different.)

Order for - Customer : 123
Status: pending
Item: LEGO Box of Bricks
Order Quantity: 2
Item: Model Railway
Order Quantity: 1
Order for - Customer : 127
Status: dispatch
Item: Smartphone IIa
Order Quantity: 1
Item: Tablet 7
Order Quantity: 3

Attachment:- ASSIGNMENT.rar