Projects:Project Scheduling Capabilities Enhancement/Technical Documentation
Contents |
Project Scheduling Capabilities Enhancement - Technical Documentation
Overview
This article will explain how to proceed in order to enhance the project scheduling capabilities within Openbravo ERP.
Current status
At present, Openbravo ERP has some scheduling capabilities that need to be improved.
Technical design
Service and Multiphase Project windows
In order to add Starting Date field to Service and Multiphase Project windows:
- Create a new non mandatory column StartDate to C_Project table.
- Log in as System Administrator, add StartDate to C_Project table in Application Dictionary || Tables and Columns || Table.
- Add Starting Date field to Service Project and Multiphase Project tabs in Application Dictionary || Windows, Tabs, and Fields || Window >> Tab.
- Run Synchronize Terminology process to fill Description and Help/Comment fields (Application Dictionary || Synchronize Terminology).
Project Profitability and Service Project reports
In order to modify Project Profitability and Service Project Report reports to include From Project Starting Date and To Project Starting Date fields:
Project Profitability report
- Add From Project Starting Date and To Project Starting Date filters to src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.html file.
- Add a SQL filter to src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSite_data.xsql file.
Service Project Report
- Replace From Date and To Date labels by From Project Starting Date and To Project Starting Date ones in src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.html file.
- Replace in src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSite_data.xsql:
<Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.CREATED >= to_date(?)]]></Parameter> <Parameter name="dateTo" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.CREATED < to_date(?)]]></Parameter>
by
<Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.STARTDATE >= to_date(?)]]></Parameter> <Parameter name="dateTo" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.STARTDATE < to_date(?)]]></Parameter>
Project Phase and Task tabs
In order to add Contract Date field to Project Phase and Project Task tabs inside Multiphase Project window:
- Create a new non mandatory column DateContract to C_ProjectPhase and C_ProjectTask tables.
- Log in as System Administrator, add DateContract to C_ProjectPhase and C_ProjectTask tables in Application Dictionary || Tables and Columns || Table.
- Add Contract Date field to Project Phase and Project Task tabs in Application Dictionary || Windows, Tabs, and Fields || Window >> Tab.
- Run Synchronize Terminology process to fill Description and Help/Comment fields (Application Dictionary || Synchronize Terminology).
Standard Phase and Task tab
In order to add Standard Duration in Days field to Standard Phase and Standard Task tabs inside Project Type window:
- Create a new non mandatory column StdDuration to C_Phase and C_Task tables.
- Ensure using, a trigger, that this column is an integer value.
- Log in as System Administrator, add StdDuration to C_Phase and C_Task tables in Application Dictionary || Tables and Columns || Table.
- Add Standard Duration in Days field to Standard Phase and Standard Task tabs in Application Dictionary || Windows, Tabs, and Fields || Window >> Tab.
- Run Synchronize Terminology process to fill Description and Help/Comment fields (Application Dictionary || Synchronize Terminology).
Set Project Type process
In order to modify Set Project Type process and add Starting Date field review:
- src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.html
- src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.xml
- src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType_data.xsql
- src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.java