WFM general 7.1.0.24 resolved issues

WFM-37256

Refactor SoScheduleGroupDao.getParentTeamIds(List wbtIds) to boost performance

The SQL observed in the schedule cost calculation was used to find job team associations when employee jobs are set to the teams above store levels for sharing jobs across stores. As the SQL would be triggered for every employee assigned to a shared job when a schedule was loaded or upon shift editing which triggered cost recalculation, this can cause serious performance issue if the accumulative execution costs of the SQL are high.

Outcome

Fixed. Removed the usage of SQL from the underlying DAO/service and schedule cost calculation and refactored code with cached approach which should save 99+% execution time running the SQL and help relieve the stress on database from running this query.