Release Assembly - Output Builder Output Fixes 3

Project Overview

The CPQ application has been developed to provide sales users at a outdoor advertising media company the ability to create advertising campaigns plans and generate dynamic proposals for their customers. The solution has been built on the Salesforce platform leveraging multiple integrations to obtain availability data, OOH ratings and inventory maps as well as leverages Heroku to create the proposal outputs - which is referred to as the "Output Builder".

Competition Task Overview

This is a 48 hours contest! Review phase is 24 hours!

Note: Client could only grant salesforce access to limited number of users. Please don't register the contest if you didn't get salesforce login in previous contests.

Please use contact manager if you want to be added to the waiting list.

The Output Builder will receive a JSON request, fetch data from SalesForce and generate PDF/Excel file.

1. Update the xls Template for Flight Summary Fields. 
   • The Flight Summary renders the same set of cols that are rendered for the Flight detail (i.e. the flightlines). From what I can make out is that we do have the java code that has the Summary fieldset and the methods that would return the set of cols to substitute in the template, however, our template needs to be updated to reference the summary fields.  
2. For PDF Outputs, when rendering the Appendix section for Maps, we need to show Maps only once, currently if the plan has more then 1 Map, all our entries in the TOC show the same text for each of these Maps (i.e. Maps..........Pg#).
3. In our xls output, we now have all Text values aligned left and all number values aligned as right, however, all number values are still of the format (text), we need these to be of format number preserving all the other formatting that we already have (i.e. $, decimals, comma separators).
4. In PDF outputs, certain flightlines break across pages, and we would like to have the entire flightline on the same page
   so, there are instances where a flight line in the detail has a long description, and we would render part of it on 1 page, and the remaining text on the new page...
   we need to be able to manage not having these lines split across pages

Environment Set Up

1. Request SalesForce Test Environment Login in Contest Forum
2. Login to SalesForce Test Site and find the session id in cookie.
3. Download the Modified Code for developers from this page.
4. Update the Hard Code session id, JSON Request and salesforceURL for testing.
5. Run the project and verify the generated XLS file.

Final Submission Guidelines

• Source Code
• Deployment Guide