Challenge Overview
Project Overview
Currently the total cost in the project view doesn't include project level bug races, the purpose of this contest fix this.
Competition Task Overview
This needs to be fixed in multiple places.
The following pages must be updated to show the correct total cost:
- Metrics report shows one total cost (http://www.topcoder.com/direct/dashboardCostReport)
- Cost report shows one total cost (http://www.topcoder.com/direct/dashboardProjectMetricsReport)
- Project overview shows several total costs (http://www.topcoder.com/direct/projectOverview.action?formData.projectId=xxx)
At least the following queries need to be updated:
- query_dashboard_project_metrics_report
- query_dashboard_cost_report
- query_direct_project_overview_statistics
Take query_dashboard_project_metrics_report for example: it is contest centric, we find all contests under a project and then calculate the cost, but we need to add project level cost too, see query_dashboard_billing_cost_invoice_report_v4 (last union), so we need to update the query.
But we are not sure if the 3 queries cover all the places/pages mentioned above, as the competitor you must make sure all total costs shown on the above pages are corrected. For example: we're not sure if the total cost shown in the attached screenshot is covered by one of the query above.
SVN
Please email support@topcoder.com to request access to direct trunk, please include the contest title/link and your user name in the email.
Direct Trunk: https://coder.topcoder.com/tcs/clients/cronos/applications/direct/trunk/
DB Trunk: https://coder.topcoder.com/internal/database/scripts/trunk
Revision
Please make sure you work with this revision in trunk:
Revision: 228504
Node Kind: directory
Last Changed Rev: 228486
Last Changed Date: 2013-05-09 07:34:43 -0400 (Thu, 09 May 2013)
VM
VM specific information is found here: http://www.topcoder.com/wiki/display/docs/VM+Image+2.5.
Upon registration as a submitter or reviewer you will need to request a VM based on the new TopCoder Cockpit/Direct image. To request your image, please use the forum.
Before requesting your VM, you need to ensure that you have an SSH key created and in your member profile. Instructions to do so are here: http://www.topcoder.com/wiki/display/projects/Generate+SSH+Key, and instructions to connect afterwards are here: http://www.topcoder.com/wiki/display/projects/Connect+Using+SSH+Key.
There is a TC Site Resource page that contains documentation / instructions for the VM instance you will be issued upon request. It is located here: http://www.topcoder.com/wiki/display/projects/Cockpit%2CDirect+VM
Technology Overview
- Java 1.5
- JSP
- Struts 2
- Redhat Linux
- JBoss 4.0.2
- Informix 10.0
Final Submission Guidelines
Submission Deliverables
- Source code which are necessary to meet all the requirements stated above, including java class, jsp files, sql files etc.
- The competitor should provide a deployment document. This document should include a step-by-step guide on the deployment.
- The test data (as sql script) needed to test the fixes.
Final Submission
For each member, the final submission should be uploaded to the Online Review Tool.