Class MProjectType

    • Constructor Detail

      • MProjectType

        public MProjectType​(Properties ctx,
                            int C_ProjectType_ID,
                            String trxName)
        Standrad Constructor
        Parameters:
        ctx - context
        C_ProjectType_ID - id
        trxName - trx
      • MProjectType

        public MProjectType​(Properties ctx,
                            ResultSet rs,
                            String trxName)
        Load Constructor
        Parameters:
        ctx - context
        rs - result set
        trxName - trx
      • MProjectType

        public MProjectType​(MProjectType copy)
        Parameters:
        copy -
    • Method Detail

      • get

        public static MProjectType get​(int C_ProjectType_ID)
        Get MProjectType from Cache (immutable)
        Parameters:
        C_ProjectType_ID - id
        Returns:
        MProjectType
      • get

        public static MProjectType get​(Properties ctx,
                                       int C_ProjectType_ID)
        Get MProjectType from Cache (immutable)
        Parameters:
        ctx - context
        C_ProjectType_ID - id
        Returns:
        MProjectType
      • getPhases

        public MProjectTypePhase[] getPhases()
        Get Project Type Phases
        Returns:
        Array of phases
      • getSqlPI

        public String getSqlPI​(MGoalRestriction[] restrictions,
                               String MeasureScope,
                               String MeasureDataType,
                               Timestamp reportDate,
                               MRole role)
        Get Sql to return single value for the Performance Indicator
        Parameters:
        restrictions - array of goal restrictions
        MeasureScope - scope of this value
        MeasureDataType - data type
        reportDate - optional report date
        role - role
        Returns:
        sql for performance indicator
      • getSqlBarChart

        public String getSqlBarChart​(MGoalRestriction[] restrictions,
                                     String MeasureDisplay,
                                     String MeasureDataType,
                                     Timestamp startDate,
                                     MRole role)
        Get Sql to value for the bar chart
        Parameters:
        restrictions - array of goal restrictions
        MeasureDisplay - scope of this value
        MeasureDataType - data type
        startDate - optional report start date
        role - role
        Returns:
        sql for Bar Chart
      • getQuery

        public MQuery getQuery​(MGoalRestriction[] restrictions,
                               String MeasureDisplay,
                               Timestamp date,
                               int C_Phase_ID,
                               MRole role)
        Get Zoom Query
        Parameters:
        restrictions - restrictions
        MeasureDisplay - display
        date - date
        C_Phase_ID - phase
        role - role
        Returns:
        query