Skip to content

Added methods to the QuestionareHelper.java file to query the database for relevant user report files

Joshua Schwamb requested to merge isse_333_questionare_database_files into issue_329_reports_ui

License and Copyright Notice

By submitting this issue or commenting on this issue, or contributing any content to this issue, you certify under the Developer Certificate of Origin that the content you post may be licensed under GPLv3 (for code) or CC-BY-SA 4.0 International (for non-code content).

Branch Name

isse_333_questionare_database_files

Related Issues

Created the database methods necessary for the feature from issue #329 (closed)

Description

The public database methods necessary for issue #329 (closed) have been created, and can be called from any class.

Steps to Test

(List the steps needed to test this merge request here using bullets, for ex:)

  1. Use a QuestionareHelper object in your code somewhere.
  2. Call one of the 4 new methods to get an integer result of the desired value
  3. Use that result as needed in your code.

Relevant Screenshots

(Post any relevant screenshots here.)

Relevant Logs

(Paste any relevant logs here.)

Developer Notes

Added 4 methods to the QuestionareHelper.java class for pulling the neccessary information from the QuestionaireSubmissions database.

  1. getTotalVisitors counts the number of guests visits to the NEST in a given month
  2. getTotalServed counts the number of people served by those guest visits based on each guest's family size in a given month
  3. getTotalServedByAge filters the results of getTotalServed into specific age groups
    1. getTotalPersonVisits counts the number of times a specific guest has visited the NEST in a given month

Merge request reports