Interface IProjektZaehlerDatenDao

    • Method Detail

      • getAllByDateInterval

        List<ProjektZaehlerDaten> getAllByDateInterval​(IEntityContext ec,
                                                       Date start,
                                                       Date end)
        Loads project statistics for the system scope (all Mandants) for a certain date interval.
        Parameters:
        ec - the entity context to use
        start - start date of the desired interval (inclusive), must not be null
        end - end date of the desired interval (also inclusive), must not be null
        Returns:
        the queried project statistics
        Since:
        8.5.5
      • getAllByMandant

        List<ProjektZaehlerDaten> getAllByMandant​(IEntityContext ec,
                                                  Date startDate,
                                                  Date endDate,
                                                  Mandant mandant)
        Loads project statistics for the projects of a certain Mandant for a certain date interval.
        Parameters:
        ec - the entity context to use
        startDate - start date of the desired interval (inclusive), must not be null
        endDate - end date of the desired interval (also inclusive), must not be null
        mandant - the Mandant to get the statistics for
        Returns:
        the queried project statistics
      • getAllByMandant

        List<ProjektZaehlerDaten> getAllByMandant​(IEntityContext ec,
                                                  Date startDate,
                                                  Date endDate,
                                                  Long mandantId)
        Loads project statistics for the projects of a certain Mandant for a certain date interval.
        Parameters:
        ec - the entity context to use
        startDate - start date of the desired interval (inclusive), must not be null
        endDate - end date of the desired interval (also inclusive), must not be null
        mandantId - ID of the Mandant to get the statistics for
        Returns:
        the queried project statistics
        Since:
        8.5.5
      • getAllByProjekt

        List<ProjektZaehlerDaten> getAllByProjekt​(IEntityContext ec,
                                                  Date startDate,
                                                  Date endDate,
                                                  Projekt projekt)
        Loads project statistics for a certain project and a certain date interval.
        Parameters:
        ec - the entity context to use
        startDate - start date of the desired interval (inclusive), must not be null
        endDate - end date of the desired interval (also inclusive), must not be null
        projekt - the project to get the statistics for
        Returns:
        the queried project statistics
        Since:
        8.5.5
      • getAllByProjekt

        List<ProjektZaehlerDaten> getAllByProjekt​(IEntityContext ec,
                                                  Date startDate,
                                                  Date endDate,
                                                  Long projektId)
        Loads project statistics for a certain project and a certain date interval.
        Parameters:
        ec - the entity context to use
        startDate - start date of the desired interval (inclusive), must not be null
        endDate - end date of the desired interval (also inclusive), must not be null
        projektId - ID of the project to get the statistics for
        Returns:
        the queried project statistics
        Since:
        8.5.5
      • findActivityDateRange

        org.apache.commons.lang3.tuple.Pair<Date,​Date> findActivityDateRange​(IEntityContext ec,
                                                                                   String toOneAttribute,
                                                                                   Long toOneId)
        Does a look-up for the date of the first and the date of the last 'ProjektZaehlerDaten' record, optionally filtered by Mandant or project. If the 'toOneAttribute' parameter is null, no filtering will be applied.
        Parameters:
        ec - the entity context to use
        toOneAttribute - the name of the attribute to filter by (e.g. IProjektDependent.ATTR_PROJEKT)
        toOneId - the ID belonging to the related 'toOneAttribute' parameter (e.g. the project's ID)
        Returns:
        the requested date pair or null, if there're no related records
        Since:
        8.5.5
      • deleteByProject

        int deleteByProject​(IEntityContext ec,
                            Date start,
                            Date end,
                            Long projectId)
        Deletes the statistics of the project with the provided ID, optionally filtered by the provided date range.
        Parameters:
        ec - the entity context to use
        start - start date of the desired interval (inclusive), may be null
        end - end date of the desired interval (also inclusive), may be null
        projectId - ID of the project whose statistics are to be deleted, must not be null
        Returns:
        the number of deleted statistics records
        Since:
        8.5.5