Standard Energy Efficiency Data (SEED) Platform™ is a web-based application that helps organizations easily manage data on the energy performance of large groups of buildings.
Better Buildings has requested the ability to attach specific notes and flags to each goal property
A dropdown list of questions an admin can ask to clarify building data
A resolution text input for a leaf user to answer
A historical note that is visible to all like properties regardless of goal, cycle, or view
A passed check boolean admin dropdown
A new or acquired boolean admin dropdown
These are based on columns BV, BX, BW, BZ, and CA in 2022_DataReviewReport_Sample.xlsb
What's this PR do?
Adds 2 new tables (GoalNotes and HistoricalNotes) and adds the ability to accept input at the ui-grid level
GoalNote: Each property in a goal will have a goal note, consisting of the following fields
Question: a preset list of questions with admin write permissions
Resolution: a text input with all user write permissions
Passed Checks: a boolean dropdown with admin write permissions
New or Acquired: a boolean dropdown with admin write permissions
Goal notes are auto-generated or destroyed upon goal create, update, or delete.
HistoricalNote: each property will have a historical note that spans cycles and goals. Meaning edits made to a property's historical note will be visible to all goals. Historical notes have all user write permissions. Historical notes are auto-created upon property create.
Each new table only has an update endpoint as create, read, and delete are handled through property or goal db relationships.
The Portfolio Summary leverages the same property/filter endpoint that the inventory list uses to serialize property data for the ui-grid. To accommodate the goal note data an optional argument (goal_id) has been added to the request to add serialized note data.
How should this be manually tested?
Make a few goals at the leaf level.
Admin should be able to edit all note fields
leaf users will only have the ability to make changes to 'resolution' and 'historical notes'
historical notes should be available to matching properties in different goals, while goal notes are specific to a goal-property combo
What are the relevant tickets?
Screenshots (if appropriate)
Admin user has ability to change all fields, question options are hardcoded
Historical notes follow properties across goals
Leaf user only has ability to change resolution and historical notes. note the lack of dropdown arrows
Any background context you want to provide?
Better Buildings has requested the ability to attach specific notes and flags to each goal property
These are based on columns BV, BX, BW, BZ, and CA in 2022_DataReviewReport_Sample.xlsb
What's this PR do?
Adds 2 new tables (GoalNotes and HistoricalNotes) and adds the ability to accept input at the ui-grid level
GoalNote: Each property in a goal will have a goal note, consisting of the following fields
New or Acquired: a boolean dropdown with admin write permissions Goal notes are auto-generated or destroyed upon goal create, update, or delete.
HistoricalNote: each property will have a historical note that spans cycles and goals. Meaning edits made to a property's historical note will be visible to all goals. Historical notes have all user write permissions. Historical notes are auto-created upon property create.
Each new table only has an update endpoint as create, read, and delete are handled through property or goal db relationships.
The Portfolio Summary leverages the same property/filter endpoint that the inventory list uses to serialize property data for the ui-grid. To accommodate the goal note data an optional argument (
goal_id
) has been added to the request to add serialized note data.How should this be manually tested?
Make a few goals at the leaf level. Admin should be able to edit all note fields leaf users will only have the ability to make changes to 'resolution' and 'historical notes' historical notes should be available to matching properties in different goals, while goal notes are specific to a goal-property combo
What are the relevant tickets?
Screenshots (if appropriate)
Admin user has ability to change all fields, question options are hardcoded![Screenshot 2024-02-16 at 2 44 15 PM](https://github.com/SEED-platform/seed/assets/58446472/74c51bf0-6bf6-45a3-b680-fa0ccaea6205)
Historical notes follow properties across goals![Screenshot 2024-02-16 at 2 44 35 PM](https://github.com/SEED-platform/seed/assets/58446472/02f56387-af8e-4498-9e7b-0fea6a088130)
Leaf user only has ability to change resolution and historical notes. note the lack of dropdown arrows![Screenshot 2024-02-16 at 2 46 08 PM](https://github.com/SEED-platform/seed/assets/58446472/5e5a287b-88ce-48a8-be18-b14aaf5aeaba)