Transportation Fuels Reporting System - v3.0.0

• refactor: ensure correct login redirection with environment-based callback URL (#2958)
• chore: version updates (#2961)

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 month ago

Transportation Fuels Reporting System - v2.22.0

tbd

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] 3 months ago

Transportation Fuels Reporting System - v2.21.0

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] 7 months ago

Transportation Fuels Reporting System - v2.20.0

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] 8 months ago

Transportation Fuels Reporting System - v2.19.0

• Updated summary balance logic to show correct new balance on supplemental when original report is submitted but not approved
• Hidden schedule b totals due to balance discrepancy with backend

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] 11 months ago

Transportation Fuels Reporting System - v2.18.0

Release Notes:

• fix: remove duplicate BCeID user account #1636

• fix: updated org service calculation for max credit offset to account for credit earning order over time (#2870)

• Fix: Supp report logic - 2867 (#2874)

• fix: updated org service calculation for max credit offset to account for credit earning order over time

• fix: pending deductions calc change

• Fix: Summary Null Check (#2875)

• fix: updated org service calculation for max credit offset to account for credit earning order over time

• fix: pending deductions calc change

• fix: None check on summary obj

• Fix: Credit Offset Exclude Reserved (#2876)

• fix: updated org service calculation for max credit offset to account for credit earning order over time

• fix: pending deductions calc change

• fix: None check on summary obj

• fix: added back exclude reserved

• Fix: supp report logic 2867 (#2877)

• fix: updated org service calculation for max credit offset to account for credit earning order over time

• fix: pending deductions calc change

• fix: None check on summary obj

• fix: added back exclude reserved

• fix: test for ignoring pending supplemental deductions

Consumption - Mobility and Transportation - Python
Published by kuanfandevops 12 months ago

Transportation Fuels Reporting System - v2.17.0

Release Notes:
fix: added type check for exclusion report on snapshot

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - v2.16.0

Release Notes:

• fix: 2023 option not available - #2838 (#2840)

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - v2.15.0

fix: resolve error saving on compliance report acceptance

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - v2.14.0 - Jan 2024 Release

Release Notes:

TBD

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - revert-2750-main-vjan-2024

Reverts bcgov/tfrs#2750

The release-2.14.0 has been deployed on prod at Jan 31 but this pr was merge instead of PR#2737. So revert it.

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - main-vjan-2024

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] about 1 year ago

Transportation Fuels Reporting System - v2.13.0

TFRS Release Notes v2.13.0

Enhancements and Bug Fixes

1. Revert Label Changes on 'Edit Organization' Page (TFRS#2704)

• Issue: Recent updates mistakenly applied label changes intended for a future release.
• Resolution: Restored the original labels on the 'Edit Organization' page accessible via IDIR. This reversion aligns the page with the intended design for the main release.

2. Visibility of Agreement Date and Categorization for BCeID Users (TFRS#2558)

• Enhancement: BCeID users, as parties to a credit transfer, can now view additional information in the Transaction History section.
• Details: The update includes the visibility of the date of the written agreement and both potential and final categorization categories.

3. Bug Fix: Roles Page Error for BCeID Users (TFRS#197)

• Issue: An error was encountered by BCeID users on the Roles page.
• Resolution: Fixed the error to ensure smooth access and functionality for BCeID users on the Roles page.

4. Simplifying Credit Transfer Declarations (TFRS#2599)

• Task: Streamlined the transfer proposal interface for BCeID users.
• Outcome: Removed two declaration statements from the Signing Authority process during the initiation of new transfers to alternative suppliers.

5. Migration for Compliance Report History (TFRS#2605)

• Purpose: Address the oversight where rescinded compliance reports lacked corresponding history records.
• Action: Implemented a migration to verify and ensure that each rescinded compliance report in the database has an associated compliance report history record. This change maintains the accuracy and transparency of transaction histories in compliance reports.

Notes

• These updates in v2.13.0 aim to enhance user experience, improve data visibility, and ensure system integrity. We appreciate your feedback and collaboration in continually improving TFRS.

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] over 1 year ago

Transportation Fuels Reporting System - v2.12.0

Release Notes for TFRS v2.12.0

Enhancements:

1. Prevention of 2023 Draft Compliance Reports Creation

   • To align with the new Act that applies compliance units to the 2023 compliance period, we've removed the ability for BCeID users to create draft compliance reports for 2023. This ensures that users don't create reports based on the old credits/debits system, providing more accurate and up-to-date reporting.
   • Ticket: #2553

2. Adjustments to Transactions Sheet Column Widths

   • We've made refinements to the default column widths in the (Credit) Transactions excel spreadsheet. This includes narrowing the 'Effective Date' column and widening the 'Comments' column for a better data viewing experience.
   • Ticket: #2684

3. Updated Credit Transfer Agreement Date Error Message

   • We've improved the error messaging for the agreement date field within a draft credit transfer. Users will now see a clearer and more descriptive message when the date format is incorrect.
   • Ticket: #2469

Bug Fixes:

4. Correction to Supplemental Report Line 26 Penalty

   • Resolved an issue where suppliers submitting multiple supplemental compliance reports for 2021 encountered erroneous penalties and an incorrect Line 26 value.
   • Ticket: #2679

5. Fixed Error Pop-up on Saving and Submitting Supplemental Reports

   • Addressed an intermittent issue in the dev environment where users received an "error saving" pop-up when trying to save or submit a supplemental report. Users should now experience a smoother workflow with appropriate success messages.
   • Ticket: #2680

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 1 year ago

Transportation Fuels Reporting System - v2.12.0

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] over 1 year ago

Transportation Fuels Reporting System - v2.11.0

Release Notes v2.11.0:

TFRS - New Input Field for Organization Details - IDIR only#2579

• Introducing a new input field for organization details.
• This enhancement provides IDIR users with the ability to input an organization's 'Company profile (EDRMS Record #)'.
• This feature is aimed at streamlining the compliance report review process, eliminating redundancies, and phasing out the use of external tracking sheets.

TFRS - Discrepancy in 'latest_report' & 'traversal' Fields in Compliance Reports#2667

• A discrepancy was discovered in the compliance_report tracking system following a migration.
• We fixed 'latest_report' not showing the latest report ID, and 'traversal' was updated to show correctly.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 1 year ago

Transportation Fuels Reporting System - v2.10.0

Release Notes:

tbd

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 1 year ago

Transportation Fuels Reporting System - release-2.10.0

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] over 1 year ago

Transportation Fuels Reporting System - v2.9.0

Version 2.9.0

Release Date: August 29th 2023

Bug Fixes

#2536 Credit Transaction Excel Effective Date

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 1 year ago

Transportation Fuels Reporting System - snyk-fix-a244f77d24db0dc7423bcbea2e1644c5

Changes included in this PR

• Changes to the following files to upgrade the vulnerable dependencies to a fixed version:
  • backend/requirements.txt

Vulnerabilities that will be fixed

By pinning:

Severity	Priority Score (*)	Issue	Upgrade	Breaking Change	Exploit Maturity
	661/1000 Why? Recently disclosed, Has a fix available, CVSS 7.5	Denial of Service (DoS) SNYK-PYTHON-DJANGO-5880505	django: 3.2.20 -> 3.2.21	No	No Known Exploit

(*) Note that the real score may have changed since the PR was raised.

Some vulnerabilities couldn't be fully fixed and so Snyk will still find them when the project is tested again. This may be because the vulnerability existed within more than one direct dependency, but not all of the affected dependencies could be upgraded.

Check the changes in this PR to ensure they won't cause issues with your project.

---

Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open fix PRs.

For more information:
🧐 View latest project report

🛠 Adjust project settings

📚 Read more about Snyk's upgrade and patch logic

---

Learn how to fix vulnerabilities with free interactive lessons:

🦉 Denial of Service (DoS)

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] over 1 year ago

Transportation Fuels Reporting System - release-2.9.0

Consumption - Mobility and Transportation - Python
Published by github-actions[bot] over 1 year ago

Transportation Fuels Reporting System - v2.8.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 2 years ago

Transportation Fuels Reporting System - v2.7.0

v2.7.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 2 years ago

Transportation Fuels Reporting System - v2.6.0

v2.6.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 2 years ago

Transportation Fuels Reporting System - v2.5.0

v2.5.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 2 years ago

Transportation Fuels Reporting System - v2.4.0

v2.4.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 2 years ago

Transportation Fuels Reporting System - v2.3.0

v2.3.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 2 years ago

Transportation Fuels Reporting System - v2.2.0

v2.2.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 2 years ago

Transportation Fuels Reporting System - v2.1.0

v2.1.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 2 years ago

Transportation Fuels Reporting System - v2.0.0

v2.0.0

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 2 years ago

Transportation Fuels Reporting System - v1.6.27

v1.6.27

What's Changed

• Tracking pull request to merge release-1.6.27 to master by @kuanfandevops in https://github.com/bcgov/tfrs/pull/1800

Full Changelog: https://github.com/bcgov/tfrs/compare/v1.6.26...v1.6.27

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 2 years ago

Transportation Fuels Reporting System - v1.6.26

PR #1789 Updated Email Address
PR #1797 File submission role should now show up even for inactive organizations

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 3 years ago

Transportation Fuels Reporting System - v1.6.24

v1.6.24

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 3 years ago

Transportation Fuels Reporting System - v1.6.25

PR #1778 Update Compliance Report Years
PR #1779 Added renewable naptha as a fuel code
PR #1780 Renewable requirements
PR #1781 Fixed Renewable Tooltip

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 3 years ago

Transportation Fuels Reporting System - v1.6.23.2

PR #1764 Updated text for the Compliance Report Intro.
This release was directly pushed to prod

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 4 years ago

Transportation Fuels Reporting System - v1.6.23.1

PR #1740 Fixed internal comments showing up for supplier spreadsheet.

This release was directly pushed to prod

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 4 years ago

Transportation Fuels Reporting System - v1.6.23

Notes: Still shows v1.6.22.3 on web page

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 4 years ago

Transportation Fuels Reporting System - v1.6.22.3-v4-migration

PR #1696 Openshift v4 migration

The following PRs have been deployed with v1.6.22.3

PR #1658 Fix file and folder permissions on nginx-runtime

PR #1672 Update patroni replicas in Nagios

PR #1673 add inline documentation

PR #1674 update logoff url to logon7 ad logontest7

PR #1675 Test migration to v4

PR #1676 Add version summary

PR #1681 v1.6.22 update backend url

PR #1682 Update backend template and keycloak configmap

PR #1683 Add patroni health check

PR #1685 V1.6.22 add fallback filename

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 4 years ago

Transportation Fuels Reporting System - v1.6.22.3

This release Includes the changes from branch v1.6.22-change-sso-service-name
The branch v1.6.22-change-sso-service-name is created from v1.6.22.2
The changes include package.json, Jeninsfile, Jenkinsfile-develop, Jenkinsfile-prod and template files.
This release v1.6.22.3 is created from branch v1.6.22-change-sso-service-name and has been deployed on dev on Oct 16 2020.
The release number at the bottom right on the home page stays v1.6.22.2 no change.
The manual update includes nagios keycloak setting, configmap keycloak setting and notification server readiness test
The changes have been merged to master through PR #1693
V1.6.22.3 Update sso service name

The sso service name has been updated on Nov 10 2020

Notes

• PR #1693 V1.6.22.3 Update sso service name
  update-sso-service-name -> master
  frontend/package.json
  functional-tests/src/test/groovy/pages/external/LoginPage.groovy
  openshift/pipelines/Jenkinsfile
  openshift/pipelines/Jenkinsfile-develop
  openshift/pipelines/Jenkinsfile-prod
  openshift/pipelines/scripts/prepareDCStages.groovy
  openshift/templates/components/backend/tfrs-dc.json
  openshift/templates/components/frontend/client-dc-others.json
  openshift/templates/components/nagios/create-nagios.sh
  openshift/templates/components/nagios/nagios-dc.json
  openshift/templates/components/notification/notification-server-dc.json

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 4 years ago

Transportation Fuels Reporting System - v1.6.22.2

PR 1684 Added a fallback filename for downloading

The changes also include the Nginx update and new header added

Technical information

This release has been deployed on dev, test, and prod on Oct 1, 2020.
The changes have been merged into master on the same day.

Notes

• PR #1684 Added a fallback filename for downloading
  amichard:fix-download -> v1.6.22-add-fallback-filename
  frontend/src/utils/functions.js

• PR #1685 V1.6.22 add fallback filename
  v1.6.22-add-fallback-filename -> master
  frontend/package.json
  frontend/src/utils/functions.js
  openshift/pipelines/Jenkinsfile
  openshift/pipelines/Jenkinsfile-develop
  openshift/pipelines/Jenkinsfile-prod
  openshift/templates/components/nginx-runtime/nginx.conf.template

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 4 years ago

Transportation Fuels Reporting System - v1.6.22.1

Included Pull Requests

PR 1680 Added new config for backend url

Technical Infomation

This release was created as an emergency release against http 504 error potentially caused by routes in Openshift.
This release was deployed on dev, test and prod on Sep 24 2020.
The changes in this release have been merged to master through PR 1681

Notes

• PR #1680 Added new config for backend url
  amichard:dedicated-backend-url -> v1.6.22-update-backend-url
  frontend/src/config.js
  frontend/src/constants/routes.js

• PR #1681 V1.6.22 update backend url
  1.6.22-update-backend-url -> master
  frontend/package.json
  frontend/src/config.js
  frontend/src/constants/routes.js
  openshift/pipelines/Jenkinsfile
  openshift/pipelines/Jenkinsfile-develop
  openshift/pipelines/Jenkinsfile-prod

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 4 years ago

Transportation Fuels Reporting System - v1.6.22

PR #1669 Disable Security Scan

System should no longer automatically set the status to "Pending Submission"

PR #1670 Updated manuals and mailto

Updated the manuals
Updated the email link for the bceid dashboard

Apply patroni #1668

Technical Information

This release was deployed on dev, test and prod at Jun 3 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 5 years ago

Transportation Fuels Reporting System - v1.6.21

PR #1666 Fixed value always resetting to 0 for Signing Authority

ReadOnly attribute is no longer a condition to reset the value to 0, the code now relies solely on whether the value is less than what it should be

Technical Information

This release was deployed on Dev April 28 2020.
This release was deployed on Test April 29 2020.
This release was deployed on Prod April 29 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 5 years ago

Transportation Fuels Reporting System - v1.6.20

Fuel code expiry date #1665

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.19

Fuel code expiry date adjustment #1664

Adjusted it so it no longer includes December 31 from the previous year

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.18

Follow-up fix for Fuel Code change #1663

change the one line so it takes into account the changes

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.17

PR #1662 Reworked how the extension of the expiry date for Fuel Codes

I rewrote how it works. Previous implementation had some serious flaws at its not exactly extending it the way you would normally extend it.
This one should now be the proper one, but it does loop through the objects.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.16

PR #1661 Fixed unit test failing

Fixed a unit test thats failing for an unaccounted gov user

Technical Information

This release was deployed on Dev Mar 24 2020
This release was deployed on Test Mar 24 2020

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.15

Pull Requests

PR #1660 Fixed wrong permissions being added to the wrong roles

Reverse the migration for Compliance Reporting
Added the permissions to Compliance Manager instead

Technical Information

This release was deployed on Dev March 23 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.14

Pull requests included

PR #1656 Permission Adjustments

Adds some more view permissions for guest
Removes add comment from managing users
Adds some view permissions for compliance manager
Fixed a typo for the toastr pop-up
Explicitly call a function to update the cell upon selecting in an autocomplete (dev wasn't auto-selecting the item)

PR #1654 Revert "Revert "Schedule Assessment updates""

Reverts #1650

PR #1655 Revert "Revert "Changelog Style Updates""

Reverts #1651

Other changes

Add a new business logic for Fuel code so that they can still be used in Schedule B one year past the expiry date
Improve guest and signing authority roles permission checks to

• they can view compliance report as read-only if they don't have any other roles
  Fixed dashboard filtering bugs
  Fixed pages crashing when switching from exclusion report to compliance report

Technical Information

This branch was deployed on Dev March 23 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.13

Pull Requests

PR #1649 Fixed an issue with effective and expiry date causing 500 errors in add fuel code

• Add a check to see if expiry date and effective dates are populated before doing the comparison so we don't run into key errors
• ZEVA-88 Error when saving a draft fuel code

PR #1652 Dashboard should now take into account supplemental report statuses

• Added new status column called "Current Status"
• Dashboard should now take into account the statuses of supplemental reports
• "Current Status" column is used as a filter from the dashboard. This allows us to get the actual status based on the original + supplemental report
• ZEVA-89 Error with counting and filtering in-progress compliance & exclusion reports
• ZEVA-90 Include Supplemental Reporting

Technical Information

This release has been deployed on Dev 20200303.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.12

Pull Requests

PR #1648 Updated the manuals to 1.4

Updates the manuals to the new ones provided

PR #1646 Schedule Assesment updates

Show compliance reporting assessment page if any previous compliance report has been reviewed by the director (and use the appropriate snapshot to display the assessment tab)

PR #1647 Changelog Style Updates

Updated styling for report changelogs
For now, only the summary is displayed with the new format. If other schedules have changes, a note is displayed.

PR #1650 Revert "Schedule Assesment updates"

Reverts #1646

PR #1651 Revert "Changelog Style Updates"

Reverts #1647

Technical Information

This release was deployed on Dev Feb 13 2020.
This release was deployed on Test Feb 13 2020.
This release was deployed on Prod Feb 13 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.11

Pull Requests

PR #1643 Label changes

ESLint fixes
Renamed Exclusion Report to Exclusion Agreements (Label)
Changed tab from Exclusion Agreement to Exclusion Agreements
Slightly changed logic for showing "Upon acceptance" message
Dropdown indicator for Exclusion Reports

PR #1642 Update django framework configuration

PR #1644 Update configmap

This PR has been applied on prod 2020-Jan-29

Technical Information

This release was deployed on Dev Jan 30, 2020
This release was deployed on Test Jan 31, 2020
This release was deployed on Prod Jan 31, 2020

Consumption - Mobility and Transportation - Python
Published by kuanfandevops about 5 years ago

Transportation Fuels Reporting System - v1.6.10

Pull Requests

PR #1640 Update coordinator template and build config

Update golang version from v1.11 to v1.12 and coordinator build config

Technical Information

This release was deployed on Dev Jan 16 2020.
This release was deployed on Test Jan 16 2020.
This release was deployed on Prod Jan 17 2020.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.0

Pull Requests

PR #1593 Compliance reporting copy paste

Copying and pasting is no longer case sensitive
Also, fixed an issue where you can paste in any value into the cells that have dropdowns

PR #1597 Updated manuals and links

Updated the pdf manuals to version 1.1
Updated the links so it no longer has 1.0 and it's more generic (so we can updated the manual in the future without making code changes)

PR #1595 Enable Request Supplemental even when the Report has been accepted

Request Supplemental for Compliance Report should be available even when the status is accepted

PR #1596 Validation for exclusion report should highlight fields that have errors

This enables highlighting of errors when validating in Exclusion report

PR #1600 Exclusion Report header no longer gets cleared after saving

Clicking on save no longer removes "Exclusion Report" and the Compliance Period

PR #1598 Updated resource usage for Openshift templates

Includes updated resource usage for application and a new health check for clamav

Implemented Trello Cards

PR #1593 Compliance reporting copy paste

• Trello-1647 Compliance Report | Copy Paste should not be case sensitive

PR #1595 Enable Request Supplemental even when the Report has been accepted

• Trello-2016 Supplemental Reporting | Request Supplemental Report button remains visible to analyst and manager throughout governments review process

Technical Information

This release was deployed on Dev Nov 7 2019.
This release was deployed on Test Nov 8 2019.
This release was deployed on Prod Nov 12 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.9

Pull Requests

PR #1639 Eslint fixes

Eslint fixes

Technical Information

This release was deployed on Dev Dec 4 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.8

Pull Requests

PR #1636 Load supplemental report on create

Load the new supplemental report edit page (for both compliance and exclusion reports) on successful report creation, instead of kicking back to the list view.

PR #1637 Report History should now add PST at the end

Added CreateTimestamp on serializer
Added timezone so it adds PST at the end of the timestamp

PR #1638 Reordered the buttons for download xls and creating supplemental report

Create Supplemental Report button should now be before save
Removed additional back button

Technical Information

This release was deployed on Dev Nov 29 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.7

Pull Requests

PR #1635 Removing ^ from version

Even just a build number difference seems to be causing the issue, so explicit version now

PR #1632 Prevent signing sell offers as the initiator based on credit balance and pending transfers

Added a validation to prevent the user from signing a sell offer if it would put them over their credit balance, after counting the pending transactions

Technical Information

This release was deployed on Dev Nov 27 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.6

Pull Requests

PR #1633 Ie 11 fix

react-hot-loader is causing the app to fail in ie-11. So removing it from PROD

PR #1634 Dashboard and Report History Revisions

Dashboard should show information bulletin labels now
Organization Name is no longer displayed for Directors and Deputy Directors
ESlint fixes

Implemented Trello Cards

PR #1634 Dashboard and Report History Revisions

• Trello-2099 Report History | Remove organization name from Director Deputy Director entry
• Trello-2088 Dashboard | Revise Information Bulletin labels

Technical Information

This release was deployed on Dev Nov 27 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.5

Pull Requests

PR #1629 Missing Create Supplemental Report Button Fix

Added a check when showing the create supplemental button to exclude deleted supplemental drafts

PR #1630 Create supplemental report copy values

Fixed previously retained and obligation not being copied when creating a supplemental report
Modal warning in summary page should stay up
It should no longer always clear values when switching schedules

Supplemental Report History Updates #1631

Update status history component to better show position of changelogs
Fix a defect in supplemental report acceptance reduction calculations
Update compliance assessment tab to show all transactions in a report's history
Remove report type, add Pacific timestamp to compliance report list
Adjust language for supplemental note
Fix tooltip z-index
Remove some vestiges of old snapshot-related code

Technical Information

This release was deployed on Dev 26 Nov 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.4

Pull Requests

PR #1624 Compliance Report History

The code won't win any beauty pageant, but it is working.
Added compliance reporting as part of the user activity
Added get_compliance_report_history to User model

PR #1626 Fuel code version autocomplete now ignores cancelled fuel codes

Should now ignore cancelled fuel codes when automatically generating the next fuel code version
New migration so unique constraint in the database takes into account the status
Updated the validator in the serializer so when it does the check it checks for Cancelled. Otherwise, you will be able to add one draft and one submitted using the same fuel code version

PR #1625 Rounding Line 4 and Line 15 in the Summary

Line 4 is now rounded to the whole number, so computing using a calculator should be more reflective of what's in the total
Line 15 is now rounded to the whole number, so computing using a calculator should be more reflective of what's in the total

PR #1627 Compliance Report History Unit Test Attempted Fix

Rearranged how the values are fetched in an attempt to fix the unit test error

PR #1628 Compliance report history unit test attempted fix

Disabled test user history as there's a difference between behaviours in local development vs openshift

Database Migrations

0196_auto_20191121_1607.py //PR #1626

Implemented Trello Card

PR #1624 Compliance Report History

• Trello-1706 Compliance Report | User Activity history for compliance and exclusion reporting

Technical Information

This release was deployed on Dev Nov 21 2019.
This release was deployed on Test Nov 21 2019.
This release was deployed on Prod Nov 26 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.3

Pull Requests

Audit more tables #1613

Capture auditing data for additional tables

Changelog Fixes #1615

Update the history/switching code to handle the case where no draft exists more gracefully
Sort by description when doing schedule D deltas to make result stable

Renamed Validation errors to Issues identified #1617

Changed "Validation errors" to "Issues identified" in the upper part of the report
Changed the text in the tooltip in the buttons as well

Added Mark all as Read action #1621

Mark all as read button should show up in the "dropdown"
Added condition in the viewset to select all unread for the user
Added condition to check and make sure its for the right user

Organization Autocomplete no longer includes own's organization #1619

Added reading of "request" in the autocomplete
Exclude the user's own organization for the autocomplete

Database Migration

0195_audit_additional_tables.py // PR #1613

Implemented Trello Card

Audit more tables #1613

• Trello-1735 Database | Revisit table audit triggers to capture any new tables we need to audit

Renamed Validation errors to Issues identified #1617

• Trello-2092 Reports | Change Validation Errors label to Issues for compliance and exclusion reporting

Added Mark all as Read action #1621

• Trello-1579 Notifications | Mark all as read

Organization Autocomplete no longer includes own's organization #1619

• Trello-2093 Reports | Prevent the selection of one's own organization when completing compliance and exclusion reports

Technical Information

This release was deployed on dev together with v1.6.4.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.2

Pull Requests

PR #1605 Request Supplemental Button - Analyst

Fixed an issue where request supplemental wasn't available for government analyst after it's been recommended by a compliance manager

PR #1611 Fixed tooltip making stuff unclickable

Fixed buttons not being clickable because of the tooltips

PR #1612 IE 11 fix

Reverted socket io client to older version. New version has some syntax that is not compatible with ie11
We might have to remove react-hot-loader. It's causing ie 11 to not load the page (syntax error)

PR #1614 Change Archive to Delete in Notifications

Renamed archive to delete
Changed the icon so it's the same as the other delete icons
Changed the delete icon in historical data entry
Also, coloured it red

Implemented Trello Cards

PR #1605 Request Supplemental Button - Analyst

• Trello-2016 Supplemental Reporting | Request Supplemental Report button remains visible to analyst and manager throughout governments review process

PR #1611 Fixed tooltip making stuff unclickable

• Trello-1290 Tooltip | Renamed TooltipWhenDisabled to something else

PR #1614 Change Archive to Delete in Notifications

• Trello-2096 Notifications | Change Archive label to Delete

Technical Information

This release was deployed on Dev Nov 14 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.6.1

Pull Requests

PR #1599 Delete Sheet functionality for Schedule D

Allow deletion of sheets in schedule D
Code cleanup

PR #1601 Changed the font so it uses BC Sans

Changed the font family to prioritize BC Sans
Not happy about the !important, but there are too many things that are overriding the font family

PR #1603 Change log UI updates

UI Updates

PR #1604 Prevent creation of a second supplemental report

Modify permissions checks to prevent creation of a second supplemental report when one already exists

PR #1607 Renamed TooltipWhenDisabled to Tooltip

Renamed TooltipWhenDisabled to Tooltip
Renamed the check from disabled to show

PR #1608 Fixed modal warning showing up for the other report type

Fixed the modal warning showing up for the other report type

PR #1609 Moved document milestone into document

When we initially created the document table, we assumed there will be more fields to add that are specific to certain document types. However, no other field other than milestone was ever needed. So it made the extra table completely unnecessary.

• Delete DocumentMilestone model
• Added milestone column into the Document model
• Adjusted tests, api and front as necessary
• Changed url secure_file_submissions to part_3_agreements

Database Migration

• 0194_auto_20191112_2114.py

Implemented Trello Cards

PR #1599 Delete Sheet functionality for Schedule D

• Trello-1997 Compliance Report D | Allow deleting of a Schedule D sheet

PR #1601 Changed the font so it uses BC Sans

• Trello-2082 Font | Change our font type to BC Sans Typefac

PR #1603 Change log UI updates

• Trello-2060 Reporting | Compliance and Exclusion Reporting Optimization

PR #1604 Prevent creation of a second supplemental report

• Trello-2034 Compliance Reporting | Restrict the creation of a supplemental report when one already exists in draft for that same report

PR #1607 Renamed TooltipWhenDisabled to Tooltip

• Trello-1290 Tooltip | Renamed TooltipWhenDisabled to something else

PR #1609 Moved document milestone into document

• Trello-1540 SFS | Move Milestone to Document
• Trello-1152 SFS | URL references Secure Document Upload

Techinical Information

This release was deployed on dev Nov 14 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.19

Pull Requests

PR #1586 XLS Downloads for Exclusion and Compliance Reports

PR #1588 Request Supplemental Button no longer hides after being recommended

Fixed some grammar issues
Fixed an issue where new schedules would not have any initial rows
Modal warning no longer shows up after saving
Request Supplemental button is now available to analyst and compliance manager throughout the review process

PR #1590 Updated the IE warning to something more prominent

Replaced old ie text to a modal pop-up

Implemented Trello Cards

PR #1588 Request Supplemental Button no longer hides after being recommended

• Trello-2016 Supplemental Reporting | Request Supplemental Report button remains visible to analyst and manager throughout governments review process

PR #1590 Updated the IE warning to something more prominent

• Trello-2074 Login | Revise IE browser not supported messaging

Technical Information

This release has been deployed on Dev

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.18

Operational Scripts

python manage.py load_ops_data api/fixtures/operational/0022_update_2013-2016_credit_calculation.py

Pull Requests

PR #1582 CI Limits for 2013-2016

New operational script to update the expiration dates for 2013-2016 so it shows up in the table

PR #1583 Functional test update

Fix the failed functional test cases.

PR #1585 Navbar changes

Moved name to the bottom navbar
Added help icon
Increased font size for Organization name
Added Credit Balance below the organization name
Improved mobile view

Implemented Trello Cards

PR #1582 CI Limits for 2013-2016

• Trello-2037 Credit Calculation | Show CI Limit values in the UI for 2013 14 2015 and 2016

PR #1585 Navbar changes

• Trello-2036 Compliance Reporting | Prevent submission of a compliance report when one has already been submitted or accepted

Technical Information

This release was deployed on Dev Oct 30 2019.
This release was deployed on Test Oct 31 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.17

Pull requests

Bug Fixes #1570

Fuel Code Feedstock Location, Feedstock Misc, Fuel Production Facility and Fuel Production Facility Nameplate no longer auto-selects
Inactive Fuel suppliers will lose visibility of the New Credit Transfer button if they have 0 credits
Changed ordering for expected uses
Updated Schedule Summary so it no longer shows ghost error messages
Added status description for organization
Clicking on a validation generated by a compliance report automatically redirects you to the assessment tab (instead of intro)
Fuel Code is now automatically cleared when the report is still in draft, and the code becomes invalid
Fuel Code description is now retained when the report is submitted and the code becomes invalid
Fixed unit of measure in schedule C not displaying
Removed the recompute call from Schedule B when displaying information from snapshot

PR #1580 Exclusion report validation

server and client side validation for exclusion reports

Implemented Trello Cards

Bug Fixes #1570

• Trello-2066 Organization | Add tooltip to active inactive status on organization details page
• Trello-1972 Compliance Report | Clicking on validation reduction entry takes you to the assessment page within the compliance report
• Trello-1762 Compliance Report | Clear selected fuel code in Schedule B when the codes effective date is updated and is no longer active during the compliance period

Technical Information

This release was deployed on dev Oct 29 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.16

Operational Scripts

python manage.py load_ops_data backend/api/fixtures/operational/0021_remove_compliance_materials.py

Pull Requests

PR #1562 Notification fixes

Fixed Scanning not running all the time
Notification changes

PR #1567 Compliance Reporting Modal Warning

When there's a penalty a warning shows up in the modal when submitting a compliance report
Fixed a bug where submit button is disabled on Supplemental Report

PR #1569 Moved Credit Market report link to Balance. Added feedback card

Changed Requested Supplemental to Supplemental Requested
Added Feedback card
Minor text changes

PR #1574 Added Organization Address to the Compliance Report

Added organization address to the compliance report
Added organization address to the exclusion report

PR #1577 Removed the 'spinner' from input type number

Added a general style to remove spinners from input[type="number"]

PR #1579 Changed the message of the modal for rescinding a credit transfer proposal

Updated the message of the modal pop-up for rescinding a credit transfer proposal

Implemented Trello Cards

PR #1562 Notification fixes

• Trello-2007 Notifications | Adjust UI messaging and fix duplicate notifications for SFS actions

PR #1567 Compliance Reporting Modal Warning

• Trello-2006 Compliance Report | Provide warning message when submitting a report in a net debit situation

PR #1569 Moved Credit Market report link to Balance. Added feedback card

• Trello-2065 Dashboard | Enhancements to the dashboard

PR #1574 Added Organization Address to the Compliance Report

• Trello-2053 Compliance Report | Display snapshot of organization address below company name within compliance and exclusion reports

PR #1577 Removed the 'spinner' from input type number

• Trello-2067 Credit Transfers | Remove up down arrow functionality from quantity and price fields

PR #1579 Changed the message of the modal for rescinding a credit transfer proposal

• Trello-2073 Credit Transfer | Revise rescind credit transfer messaging in modal window

Technical Information

This release has been applied on Dev Oct 29 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.15

Operational Notes

python manage.py load_ops_data api/fixtures/operational/0021_remove_compliance_materials.py

Pull Requests

PR #1552 Modal Warnings for Creating a Compliance Report

Modal Warning when creating a compliance report when one is already submitted for that compliance period
Modal Warning when going to the summary page and the values needed to be adjusted
Submit button disabled when a compliance report has been submitted for that compliance period
Fixed lag in Schedule A and C

PR #1556 Added credit balance on credit transfers. Added disclaimer in credit …

Changed the link in the Dashboard Container so Creating a Compliance Report
Added Credit Balances in the credit transaction detail page
Added disclaimer in the credit transaction detail page

PR #1565 Exclusion report supplemental reporting

Added exclusion report supplemental reporting including history and changelogs

PR #1558 Some message and label changes for PVR

Changed some labels
Changed modal messages
Moved new pvr button to secure file submissions
Removed Compliance Reporting Materials
Set Milestone Evidence as the default
Added Credit Balance for bceid

PR #1564 Automatically set email based on bceid email if left blank

Label changes
Automatically copy bceid email to the email field when email is left blank

Implemented Trello Cards

PR #1552 Modal Warnings for Creating a Compliance Report

• Trello-2051 Compliance Report | Provide a warning message on the summary page after clearing input values
• Trello-2036 Compliance Reporting | Prevent submission of a compliance report when one has already been submitted or accepted
• Trello-2035 Compliance Reporting | Provide warning message when creating a new compliance or exclusion report when one is already submitted or accepted

PR #1556 Added credit balance on credit transfers. Added disclaimer in credit …

• Trello-2033 Dashboard | Have the start a new compliance exclusion report links take the user to the main compliance reporting page
• Trello-2020 Credit Transfer | Display organizations credit balances on Submitted and Reviewed credit transfer proposals IDIR
• Trello-1446 Credit Transfer | Add disclaimers to the New Transfer screen

PR #1565 Exclusion report supplemental reporting

• Trello-1743 Exclusion Report | Create Supplemental Report
• Trello-1991 Exclusion Report | Provide Explanation when submitting supplemental report
• Trello-1760 Exclusion Report | Create changelog for supplemental reports
• Trello-1999 Exclusion Report | Snapshot for Supplemental Reporting
• Trello-1755 Exclusion Report | Prepopulate data from previous report when creating a supplemental report
• Trello-1993 Exclusion Report | Director Accepts Supplemental Report

PR #1558 Some message and label changes for PVR

• Trello-1642 Credit Transactions | Adjustments to the PVR feature
• Trello-1643 SFS | Adjustments to the SFS feature
• Trello-1447 Credit Transfer | Change all front end Sign Signed labels to Propose and Signed

PR #1564 Automatically set email based on bceid email if left blank

• Trello-2059 Notifications | Make email field a requirement in user profile and change language to reflect use of email (eg communication)

Technical Information

This release was deployed on Test Oct 24 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.14

Operational Notes

python manage.py load_ops_data api/fixtures/operational/0020_update_expected_uses.py

Pull Requests

PR #1544 Updated schedule c instructions. Disabled two options from expected use

Updated schedule c instructions as noted in the card
Set expiration dates to Aviation and National Defence to disable them

PR #1548 Summary additional lines

Changes to the summary page so that it no longer restricts itself with heating oil
Changes to the summary page to include Schedule C
Fixed a bug with the snapshot not displaying the description for Fuel Code, Provision and Unit of Measure
Fixed a bug where commas in the input fields in Summary causes the page to return blank
Fixed title vanishing after saving
Fixed flicker with the submit button in Compliance Report
Line 7, 9, 18 and 20 in the summary page now editable
Fixed state management issues when creating a supplemental report
Fixed fuel code not allowing negative values

Database Migrations

backend/api/migrations/0193_auto_20191017_1601.py

Implemented Trelo Card

PR #1544 Updated schedule c instructions. Disabled two options from expected use

• Trello-2030 Compliance Report | Adjustments to Schedule C

PR #1548 Summary additional lines

• Trello-2031 Compliance Report | Adjustments to the Part 2 calculation in the summary section
• Trello-2049 Compliance Reporting | Make Line 7 Line 9 Line 18 Line 20 editable

Technical Information

This release has not been deployed.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.5

Pull Requests

Request Supplemental Report #1471

Added migration to add "Request Supplemental" status
pylint/pep8 fixes
Added buttons for Compliance Report and Exclusion Report for "Request Supplemental"
Front-end change to show "Requested Supplemental status in the list
Front-end change for the history to show "Requested Supplemental"

PR Compliance Reporting Containers prefer snapshot values #1472

Compliance Report | Existing compliance report edit view displays snapshot values when they exist (after it is submitted)

Database Migration

backend/api/migrations/0184_add_request_supplemental_report_status.py //PR #1741

Implemented Trello Cards

PR #1471 Request Supplemental Report

• Trello-1748 Compliance Report | Request Supplemental Report
• Trell-1749 Exclusion Report | Request Supplemental Report

PR #1472 Compliance Reporting Containers prefer snapshot values

• Trello-1954 Compliance Report | Existing compliance report edit view displays snapshot values when they exist

Technical Information

This release was deployed on Dev Sep 11 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.13

Notes

v1.5.13 was deployed on test through branch tfrs-v1.5.13-branch. The pipeline jenkinsfile was updated in order to run unit test properly. The change is applied on v1.5.14 as well.

Pull Requests

PR #1541 Reporting Tab

Updated Report tab for Exclusion Reporting so it looks more similar to the one in Compliance Report
Updated the validation logic in the assessment
Moved instructions outside of the collapsible box

PR #1542 Fix the validation for the compliance reporting

Slight revert for the changes for compliance reporting to fix validation
Added more checks to make sure that it doesn't throw an error when loading an assessment

Technical Information

This release was deployed on Dev Oct 10 2019
This release was deployed on Test Oct 21 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.12

Pull Requests

PR #1540 Fixed summary page and exclusion report

Fixed issue with summary page
Temporary fix for broken exclusion report

Technical Information

This release was deployed on Dev Oct 9 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.11

PR #1537 Supplemental acceptance

Accept supplemental reports, and generate credit transactions appropriately to validate/reduce the net credit change
Turn off DJANGO_DEVELOPMENT mode by default (can still be turned on with environment)

PR #1539 Schedule D Instructions

Added schedule d instructions
Fixed schedule b instructions always showing up on all schedules

Implemented Trello Cards

PR #1539 Schedule D Instructions

• Trello-1347 Compliance Report D | Instructions for Schedule D

Technical Information

This release was deployed on Dev Oct 9 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.10

Pull Request

PR #1517 Added instructions and tooltips for Schedule B. Fixed an issue where …

Added instructions and tooltips for Schedule B
Fixed an issue where credit trade approved by is referring to the wrong person

PR #1534 Submit can only be clicked in the summary page

Submit button is disabled until you get to the Summary page
Added validation messages to the Summary page
Computation in Summary is disabled if there are validation issues

PR #1536 Bug Fixes

Hopefully fixed the caching issue with undeletable rows
Fixed schedule B not loading provisions and fuel codes properly
Fixed names in the notifications settings page
Fixed notifications crashing

Update to enable more unit test cases #1535

Implemented Trello Cards

PR #1517 Added instructions and tooltips for Schedule B. Fixed an issue where …

• Trello-1366 Compliance Report B | Instructions for Schedule B

PR #1534 Submit can only be clicked in the summary page

• Trello-2045 Compliance Report | Can only Submit from Summary page

PR #1536 Bug Fixes

• Trello-1730 Bug Tracker | Squash em

Technical Information

This release was deployed on Dev Oct 9 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.9

Pull Requests

PR #1518 Fix unit tests

Correct an issue with unit test fixtures for compliance reports
Add a new docker-compose-test.yml file as an example of how to run unit tests in a container
Remove dependency on Minio for tests

PR #1521 Assessment tab

Assessment Tab for Compliance Report
Assessment Tab for Exclusion Report
Migration to add auditable and effective dates for compliance report type
Assessment Tab is default for certain statuses

PR #1522 Supplemental view changes

Add submissions history tab for compliance reports
Clicking on any supplemental report brings you to the latest one

PR #1525 Organization status actions type

Added default role flag for roles to be marked as default when the user doesn't have any roles after automatically removing the file submission role
Migration to automatically set FSNoAccess as a default role
Automatically remove file submission role after setting organization status to inactive
Hide certain features when the organization is set to inactive
Actions Type is automatically set now based on the organization's credit balance

PR #1527 Supplemental require comment

Supplemental report submissions will require a 1-500 character
explanation
Fixed a unit test defect that arose as part of a previous PR
Fixed a frontend defect where readonly reports were calling
validation unnecessarily.

PR #1528 Compliance report list updates

Update compliance report list table to match desired specs (include supplemental status column, drop tree view)

PR #1530 Schedule Summary Restrictions

Only 1 field is enabled per section in the Summary Page
Values get automatically adjusted if the max value is lower than the inputted value
Fixed some bugs with how the state is managed, so there should be less issues when switching back and forth to the summary page

Database Migrations

backend/api/migrations/0189_auto_20190930_2245.py
backend/api/migrations/0190_compliancereport_supplemental_note.py
backend/api/migrations/0191_role_default_role.py
backend/api/migrations/0192_update_guest_role.py

PR #1521 Assessment tab

• Trello-1700 Compliance Report | Compliance Assessment Section
• Trello-1701 Exclusion Report | Compliance Assessment Section

PR #1525 Organization status actions type

• Trello-2021 Fuel Supplier | Organization Status Active Inactive
• Trello-2022 Fuel Supplier | Hide Part 3 Agreement SFS feature for inactive organizations

PR #1530 Schedule Summary Restrictions

• Trello-1727 Compliance Report B | Restrict the use of Lines 6 8 17 19

Technical Information

This release is deployed on Dev Oct 8 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.8

Operational Scripts

Run 'python manage.py load_ops_data api/fixtures/operational/0019_update_permission_labels_descriptions.py' on all three environment

Pull Requests

PR #1506 Operational script to update the names and descriptions of permissions

Updates the names and descriptions of the permissions based on the spreadsheet in the trello card

PR #1508 Permission fixes

new migration to fix the roles and permissions
added checks in the dashboard so it's a bit more graceful when the user lacks the permission from seeing certain components

PR #1509 Supplemental changelog

Added dynamic changelog for supplemental reports

PR #1511 Dashboard improvements

This also contains the changes in #1508. So when that gets merged in, this should contain less changes.

• Fixed broken link for creating new credit transaction
• Fixed broken links for creating new compliance report or exclusion report
• Fixed wrong link for New User in bceid dashboard
• Fixed notifications link not going to the notifications page
• Text changes

PR #1513 Sort Order for compliance reports

Default sort order for compliance reports is "compliance period, last activity" where last activity is the latest update date for any report in the chain of supplementals

PR #1515 Fixed filtering for compliance report

Fixed the filtering issue with compliance report by overriding the functionality in ReactTable
Changed company or organization

PR #1512 Fixes to supplemental report changelog

Fix the case where a schedule is added

Database Migration

backend/api/migrations/0188_update_roles_permissions.py //PR #1508

PR #1506 Operational script to update the names and descriptions of permissions

• Trello-2023 Permissions | Revise permission descriptions in the UI

PR #1508 Permission fixes

• Trello-2024 Permissions | Add and adjust permissions to all roles

PR #1509 Supplemental changelog

• Trello-1759 Compliance Report | Create changelog for supplemental reports

PR #1511 Dashboard improvements

• Trello-2026 Dashboard | Minor tweaks and adjustments

PR #1515 Fixed filtering for compliance report

• Trello-1730 Bug Tracker | Squash em
• Trello-1721 Details | Change company to organization on user details page

PR #1511 Dashboard improvements

• Trello-2026 Dashboard | Minor tweaks and adjustments

Technical Information

This release is deployed on Dev Oct 1 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.7

Operational Notes

• Run 'python manage.py load_ops_data api/fixtures/operational/0018_add_2013-2016_credit_calculation_values.py" on all three environment.
• Turn on "Revoke Refresh Token" in keycloak Realm Settings -> Token

PR #1499 Added Director Dashboard

Adds a dashboard for the director

PR #1500 Bug fixes for the summary page

Fixed the issue with the assertions not recognizing that all checkboxes were checked when signing a compliance report or exclusion report
Fixed summary page not loading Line 28 after switching
Fixed flashing tooltip for Line 12
Fixed terms not enabling Sign 1/2 even though all checkboxes have been marked

PR #1502 Notifications reupload

Migration to add a new column to the notification_message table
Backend code to send the messages
Frontend code to parse the notification message

PR #1504 Added credit calculation values for 2013-2016

Added a fixture to populate 2013-2016 credit calculation values

Database Migrations

backend/api/migrations/0187_auto_20190923_1556.py //PR #1502

Implemented Trello Cards

PR #1499 Added Director Dashboard

• Trello-1612 IDIR Dashboard Director and Deputy Director

PR #1500 Bug fixes for the summary page

• Trello-2001 Compliance Report | Summary page fixes and optimization

PR #1502 Notifications reupload

• Trello-1704 Notifications | Compliance and Exclusion Reporting

PR #1504 Added credit calculation values for 2013-2016

• Trello-2010 Compliance Reporting | Add credit calculation values for 2013-14 2015 2016

Technical Information

This release was deployed on Dev Sep 24 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.6

Notes

There are three environment variables for celery are added through PR #1473 . Three pipelines also opened celery dc in order to add them to celery.

PR #1482 IDIR Dashboard

IDIR users should now be redirected to the dashboard by default
bceid users will still be redirected to credit transactions
Nav Bar has been updated to match dashboard
Numbers in dashboard are dynamic (not hard-coded)

Bug fixes for Summary page and for Address autocomplete #1483

External function to build the address so it doesn't contain null values
Summary page smart labels shouldn't contain the decimals anymore

Create supplemental report #1485

Create a supplemental report button and action
Copies all schedule and summaries (but not snapshot or status) into new report
Also added nickname field (but the serializers don't write to it yet)
Modify list view to show tree structure for supplemental reports
Tests
Pending in next PR:

• Probably some style changes (I'll await feedback)
• Changelog for supplemental reports
• More obvious visual feedback when you're working on a report which has supplemental reports (or is itself a supplemental report)
• History records need to be adjusted
  *Edit the nickname

PR #1493 Dashboard for BCeID users

Dashboard for BCeID created
Redirects BCeID to dashboard instead of the credit transactions page
Updated Navbar for BCeID users as well

PR #1496 Fixed broken sqlite method for autocomplete

PR #1473 Devops nagios notification

Database Migrations

backend/api/migrations/0185_compliancereport_supplements.py //PR #1485
backend/api/migrations/0186_compliancereport_nickname.py //PR #1485

Implemented Trello Cards

PR #1493 Dashboard for BCeID users

• Trello-1973 Dashboard | Adjust nav bar to align with dashboard design
• Trello-1605 Dashboard | BCEID Dashboard
• Trello-1596 Dashboard | BCEID Dashboard metric panel Validated Credits
• Trello-1599 Dashboard | BCEID Dashboard panel Credit Transactions
• Trello-1600 Dashboard | BCEID Dashboard panel Part 3 Agreements
• Trello-1601 Dashboard | BCEID Dashboard panel Compliance and Exclusion Reports
• Trello-1602 Dashboard | BCEID Dashboard panel Organization Details

PR #1482 IDIR Dashboard

• Trello-1603 Dashboard | BCEID/IDIR Dashboard panel User Settings
• Trello-1594 Dashboard | IDIR Dashboard
• Trello-1604 Dashboard | IDIR Dashboard metric all org credit balance
• Trello-1607 Dashboard | IDIR Dashboard panel Credit Transactions
• Trello-1608 IDIR Dashboard panel Compliance & Exclusion Reports​
• Trello-1609 Dashboard | IDIR Dashboard panel Fuel Codes
• Trello-1611 IDIR Dashboard panel Administration

Bug fixes for Summary page and for Address autocomplete #1483

• Trello-1625 Compliance Report | Restrict Line 6 8 17 19 to whole numbers and adjust corresponding label accordingly
• Trello-1968 Exclusion Reports | Null values showing in the address of transaction partner

Technical Information

This release was deployed on Dev Sep 19 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.4

Pull Requests

PR #1450 Visual Fixes

Changed the wording in some of the validation messages
Left aligned status for Compliance Report
Fixed null values for the address autocomplete in Exclusion Report
Fixed the schedule totals blocking some parts of the spreadsheet
Fixed vanishing buttons in the Exclusion Report

PR #1460 Label adjustments

Removed Amount enclosed in the Summary section
Changed some labels in the Summary section
Changed Fuel Code label in Schedule B
Fixed some messages in the tooltip for submitting an Exclusion Report
Fixed an issue with the confirmation dialog when submitting an Exclusion Report
Fixed toastr messages for Exclusion Reports
Fixed capitalization for toastr messages
Fixed Add row button still showing up even after the exclusion report has been submitted
Fixed permission with Gov Analyst not seeing the compliance reporting navigation link
Schedule A totals are now whole numbers

PR #1466 Compliance Report for < 2017 periods fix

Since we don't have any credit calculation values for anything less than 2017 compliance period, we get an error since it's trying to fetch "density" from an object that doesn't exist.

• Added a check for Carbon Intensity Limit, EER, etc when retrieving the density and make sure the object exists

PR #1467 Fixed the migration conflicts

PR #1468 Reversed the order of 182 and 183

Database Migration

• backend/api/migrations/0183_add_gov_analyst_view_compliance_report_permission.py //PR #1467 1460

Implemented Trello Cards

PR #1450 Visual Fixes

• Trello-1981 Compliance Report | Left align Status column on main compliance reporting page
• Trello-1964 Validation | Revise validation messaging
• Trello-1968 Exclusion Reports | Null values showing in the address of transaction partner
• Trello-1969 Compliance Report | Floating windows block report data when viewing a submitted report

PR #1460 Label adjustments

• Trello-1644 Compliance Report | Minor UI adjustments to Summary section
• Trello-1658 Compliance Report B | Adjust fuel code label to account for Schedule D entries
• Trello-1986 Exclusion Report | Minor adjustments to UI language
• Trello-1987 Exclusion Report | Hide or Remove Add Row button for a Submitted Exclusion Report
• Trello-1988 Compliance Report | Government Analyst can't access main Compliance Reporting page in Nav bar
• Trello-1989 Exclusion Report | Minor adjustments to UI language Part 2
• Trello-1739 Compliance Report A | Do not show decimal values in totals floating window

PR #1466 Compliance Report for < 2017 periods fix

• Trello-1730 Bug Tracker | Squash em

Technical Information

This release was deployed on Dev Sep 10 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.3

Pull Requests

PR #1446 Summary Fixes

Fixed Line 28 not populating until a cell change
Fixed Line 26 causing a brief message
Fixed an issue in Schedule D, where it's not clearing the error highlights properly
Improved messaging about validation errors in other schedules
Improved validation message in Summary page when user is trying to put in more than the organization's credit
Validation in Schedule D will only check if the sheet is not empty

PR #1465 Create validation or reduction on director acceptance

Create approved validation or reduction transactions on director acceptance as detailed in card 1949
Notifications are sent appropriately
A one-to-one relationship between credit trades and compliance reports is established. Frontend credit trade list view redirects to the related compliance report where appropriate.

PR #1452 Minor update nagios3 and upgrade clamav

PR #1453 Update EMAIL_FROM_ADDRESS

PR #1367 Bump django from 1.11.22 to 1.11.23 in /backend

Database Migration

• backend/api/migrations/0182_compliancereport_credit_transaction.py //PR #1465

Implemented Trello Cards

PR #1446 Summary Fixes

• Trell-1730 Bug Tracker | Squash em
• Trell-1978 Compliance Report | Line 28 penalty not displaying in a net debit situation until after a value has been entered into Line 26
• Trell-1979 Compliance Report | Entering a value into Line 26 causes the summary page to briefly display a validation error message before the page reloads
• Trell-1966 Validation | Optimize Schedule D validation
• Trell-1967 Validation | Identify the specific schedule when there are validation errors in other schedules

PR #1465 Create validation or reduction on director acceptance

• Trello-1949 Compliance Report | Execute a credit transaction balance change when the Director Accepts a report

PR #1453 Update EMAIL_FROM_ADDRESS

• Trello-1736 Notifications | Update sender email address for notifications

Technical Information

This release was deployed on Dev Sep 9 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.2

Pull Requests

PR #1434 Exclusion Report Snapshot

Exclusion Report Snapshot should be generated after submitting
ESLint Fixes for Compliance Report Snapshot

PR #1443 Exclusion Report Recommendation and Acceptance

Confirmation and toastr for Government Analyst Recommendation
Confirmation and toastr for Compliance Manager Recommendation
Confirmation and toastr for Accept
Confirmation and toastr for Reject

PR #1434 Exclusion Report Snapshot

• Trello-1971 Exclusion Report | Create a submission snapshot

PR #1443 Exclusion Report Recommendation and Acceptance

• Trello-1686 Exclusion Report | Gov Analyst Recommend Acceptance
• Trello-1687 Exclusion Report | Gov Analyst Recommend Rejection
• Trello-1690 Exclusion Report | Compliance Manager Recommend Acceptance
• Trello-1691 Exclusion Report | Compliance Manager Recommend Rejection
• Trello-1696 Exclusion Report | Director Accept report
• Trello-1697 Exclusion Report | Director Reject

Technical Information

This release was deployed on Dev Sep 6 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.1

Operational scripts

Run 'python manage.py load_ops_data api/fixtures/operational/0017_add_exclusion_report_signing_assertions.py' on all three environment

Pull Request

PR #1429 Exclusion Report - Declarations

Migration to add the signing assertions for Exclusion Report
Add another type for Signing Assertions
Submit should change the status and redirect the user back to the list

PR #1430 Fixed toastr message for accepting and rejecting. Fixed refresh list …

Fixed Accept and Reject toastr message
Fixed the bug with refreshing the list after deleting a compliance report (in firefox)

Database Migrations

• 0181_auto_20190829_2036.py //PR #1429

Implemented Trello cards

PR #1429 Exclusion Report - Declarations

• Trello-1527 Exclusion Report | Declaration section
• Trello-1669 Exclusion Report | Submitting report changes data to read only
• Trello-1554 Exclusion Report | Submit an Exclusion Report

PR #1430 Fixed toastr message for accepting and rejecting. Fixed refresh list …

• Bug Tracker - 1730 Bug Tracker | Squash em

Technical Information

This release was deployed on Dev Sep 4 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.5.0 Compliance Report

Pull Requests

PR #1425 Delete function for exclusion report

Delete should now be working for exclusion report

• I added a destroy method to explicitly call the serializer, it was skipping it in some instances
• Notification alert is reused from compliance reporting

RP #1419 Schedule buttons

Adds the transaction history for recommending and not recommending (both for analyst and managers)

• Added History panel in the front-end
• Compliance Report serializer now checks whether it should include government statuses or not
• Schedule D Validation Fixes
• Added Accept/Reject functionality for Director
• Header of Validation Messages and Report History is now clickable (the whole header)

PR #1427 Save and Submit button changes

Changed the validation message for the save button
Submit button validates similarly to the save button

PR #1429 Exclusion Report - Declarations

Migration to add the signing assertions for Exclusion Report
Add another type for Signing Assertions
Submit should change the status and redirect the user back to the list

PR #1412 Minor DB schema updates

Add table comment for compliance_report_workflow_state
Mark status not nullable in compliance_report_status

Database Migrations

• 0179_db_column_adjustments_for_compliance_reporting.py //PR #1412
• 0180_add_director_compliance_report_permissions.py //PR #1419
• 0181_auto_20190829_2036.py //PR #1429

Implemented Trello Cards

Delete function for exclusion report #1425

• Trello-1565 Exclusion Report | Delete a draft
• Trelo-1566 Confirmation Alerts | Delete a Saved Draft Exclusion Report
• Trello-1567 System Alerts | Delete a Saved Draft Exclusion Report

Schedule buttons #1419

• Trello-1670 Compliance Report | Gov Analyst Recommend Acceptance
• Trello-1671 Compliance Report | Gov Analyst Recommend Rejection
• Trello-1674 Compliance Report | Compliance Manager Recommend Acceptance
• Trello-1675 Compliance Report | Compliance Manager Recommend Rejection
• Trello-1682 Compliance Report | Director Accept report
• Trello-1683 Compliance Report | Director Reject

PR #1427 Save and Submit button changes

• Trello-1965 Compliance Report | Optimize save submit when there are validation errors

Technical Information

This release was deployed on Dev Aug 30 2019
This release was deployed on Test Sep 4 2019
This release was deployed on Test Sep 6 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.31

Pull Requests

PR #1415 Integrated the actions and checks for the buttons

Added some checks for the compliance reporting buttons

• Added a check for the allowable actions provided by the backend
• Minor css fix with the buttons
• Status changes in the list

PR #1416 Resubmit failed security scans

Added a TTL column to DocumentFileAttachment
Added scheduled task to resubmit security scans that have not yet completed (provided their status hasn't changed in 30 minutes and their TTL is greater than 0)

Database Migration

• 0178_documentfileattachment_scan_resubmit_ttl.py //PR #1416

Implemented Trello Cards

PR #1415 Integrated the actions and checks for the buttons

• Trello-1670 Compliance Report | Gov Analyst Recommend Acceptance

PR #1416 Resubmit failed security scans

• Trello-1731 SFS | Dispatch CLAMAV scan handler after 15 minutes of non completion

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.30

Pull Requests

PR #1407 Bug fixes

Fixed some issues with Schedule D.

• Removed the hard cap at displaying 2 decimals
• Errors are properly cleared now for Schedule D Output section

PR #1408 Summary Page Fix

Fix an issue where Summary page is getting stuck after filling in the required information
Also fixed an issue with the debits in Part 3 is showing NaN. This was caused by a previous refactor from me.
Bug Tracker - 1730

PR #1410 compliance reporting actions

Add actions and actor to compliance reporting serializers to simplify frontend logic for updating state

PR #1411 Nagios Update

Regroup Nagios configuration.
Add database, Minio connection, Clamav connection, RabbitMQ connection and Email connection monitors.
Update Nagios image structure in Openshift.

Implemented Trello Cards

PR #1407 Bug fixes

• Trello-1737 Compliance Report D | Allow more than two decimals and negative values in schedule D output table
• Trello-1740 Compliance Report D | Output table not recognizing pasted number values from Excel

Technical Information

This release was deployed on Dev Aug 27 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.29

Notes

Before deployment, please verify database table compliance_report to make sure it has no records, otherwise 0174 migration could fail.

Pull Requests

PR #1390 Compliance report list

This enables the compliance reporting list for IDIR users

• Fixed an issue with the signing assertions not showing up for compliance report
• Minor changes to the labels
• Fuel Code Column in Schedule B now properly gets highlighted if it's left empty after selecting GH Genius for Provision of the Act

PR #1397 Exclusion Report - Quantity and Units

Front-end changes for quantity and units

• Quantity should now be number only input field
• Units should now auto-populate based on fuel type

PR #1393 Compliance report recommend acceptance

This adds the buttons, confirmations and permissions needed for Accepting and Rejecting a Compliance report (This is mostly a front-end change. Status won't change yet)

• Added migration to add the permissions to view the compliance report and added them to the roles that need them
• Added migration to add the permissions needed for recommending accept and reject for compliance report
• Added buttons for recommending accept and reject with permission checks
• Added the modal dialogs to update the statuses for compliance reporting

PR #1402 Exclusion Report

Added save functionality for the exclusion report

• Added Backend models for Exclusion Report
• Added Serializers to save the records
• Added a check in the viewset so it knows which serializer it should use
• Added toastr alert for saving an exclusion report draft
• Clicking on an exclusion report should show the proper details
• Fixed GH Genius not filtering by class

PR #1403 Compliance reporting status

Improve status and status history tracking for compliance reports
Includes permission checks and filters values from fuel supplier view where appropriate
Running the migration WILL RESET ALL COMPLIANCE REPORTS TO DRAFT

Database migrations

0169_add_view_compliance_report_permission.py //PR #1390
0170_auto_20190819_0126.py //PR #1391
0171_add_idir_compliance_report_permissions.py //PR #1393
0172_add_compliance_report_new_statuses.py //PR #1403
0173_auto_20190819_1941.py //PR #1403
0174_auto_20190819_1942.py //PR #1403
0175_auto_20190819_1942.py //PR #1403
0176_auto_20190823_0131.py //PR #1403
0177_auto_20190821_1837.py //PR #1402

Implemented Trello Cards

PR #1390 Compliance report list

• Trello-1951 Compliance Report | Grant permission to analyst to see submitted compliance reports

PR #1397 Exclusion Report - Quantity and Units

• Trello-1559 Exclusion Report | Quantity
• Trello-1560 Exclusion Report | Units
• Trello-1561 Exclusion Report | Quantity not sold or supplied within the Compliance Period

PR #1393 Compliance report recommend acceptance

• Trello-1670 Compliance Report | Gov Analyst Recommend Acceptance

PR #1402 Exclusion Report

• Trello-1563 Exclusion Report | Save a draft
• Trello-1568 System Alerts | Save a Draft Exclusion Report
• Trello-1564 Exclusion Report | Edit a draft

Technical Information

This release is deployed on Dev Aug 26 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.28

Pull Requests

PR #1387 Validation front end

Adds a validation message to Schedule D

• Validation message should now show up for Schedule D
• Highlights the fields like the other schedules

PR #1388 Fix notifications

Notifications dispatch in on_commit handler now works properly

PR #1385 Fix row deletion, FK on schedules

Implemented Trello Cards

PR #1387 Validation front end

• Trello-1715 Validation | Schedule D

PR #1388 Fix notifications

• Trello-1769 Notifications | Notifications not sending in app or via email

Technical Information

This release was deployed on Dev Aug 16 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.27

Pull Requests

PR #1382 Validation front end

Schedule A, B, C front-end validation

• Slightly changed the format of validation error from the backend, when displaying errors about duplicates
• Validation Message accordion at the top of the schedules
• Marks the cells as red, if they're invalid
• Changes the message accordion to green, when there are no errors
• Highlights duplicate rows
• Changes icons for row numbers depending on the row status

PR #1380 Numerous small bug fixes per tracking spreadsheet

Fixes lots of little issues identified in the bug tracking spreadsheet

PR #1384 Update pipeline timeout and move SchemaSpy to the end of dev pipeline

Implemented Trello Cards

PR #1382 Validation front end

• Trello-1713 Validation | Schedule B
• Trello-1712 Validation | Schedule A

Technical Information

This release was deployed on dev Aug 14 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.26

Pull Requests

PR #1366 Permission Check for Submitting Compliance Report

There should now be a permission check for submitting a compliance report

• Migration to add permission and attach it to Signing Authority
• Fixed the 0 being appended to Quantity column in Schedule C
• ES Lint Fixes
• Tooltip to let the user know that it needs Signing Authority for Compliance Report Submit
• Tooltip in Modal to let user know that everything needs to be checked before it can be submitted.

PR #1379 Compliance report history

Added status history for compliance report

• Added Compliance Report History model
• Added title to Signing Authority Confirmation model
• Record the title of the user when they check the signing authority
• User who created or updated for Compliance Report is now being saved
• Created serializer for Compliance Report History

Database Migrations

• 0166_add_sign_compliance_report_permission.py //PR #1379
• 0167_compliancereporthistory.py //PR #1379
• 0168_signingauthorityconfirmation_title.py //PR #1379

Implemented Trello Cards

PR #1366 Permission Check for Submitting Compliance Report

• Trello-1722 Compliance Report C | Quantity of fuel supplied column places zero in front of single digit value

PR #1379 Compliance report history

• Trello-1585 Compliance Report | Compliance Report History Records

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.25

Pull Requests

PR #1371 Summary Tooltip Instructions

Added tooltip instructions for the Summary Page.

• Moved new exclusion report into Compliance Reporting
• Confirmation alert after submitting, also redirecting to list after
• Added tooltips for the Summary Page

PR #1374 Add Compliance Manager role

Added Compliance Manager role

• Renamed Compliance Report Manager to Compliance Reporting
• Added Compliance Manager for government

PR #1375 Schedule B Validation (backend)

• Validation rules per Trello card 1713

PR #1376 Schedule validations

• Added validations (backend only) for schedules A, C, and D also

PR #1377 Readonly compliance report

Database Migrations

• 0165_compliance_reporting_manager_role.py //PR #1374

PR #1371 Summary Tooltip Instructions

• Trello-1351 Compliance Report | Instructions for Summary and Declaration section |2|
• Trello-1584 Compliance Report | System Alert for submitting a compliance report |1|
• Trello-1728 Exclusion Report | Integrate exclusion reporting with the compliance reporting feature page |1|

PR #1374 Add Compliance Manager role

• Trello-1676 Compliance Report | Create IDIR Compliance Manager Role |1|
• Trello-1677 Compliance Report | Rename BCeID role to Compliance Reporting |1|

PR #1375 Schedule B Validation (backend)

• Trello-1713 Validation | Schedule B |16|

PR #1376 Schedule validations

• Trello-1712 Validation | Schedule A |5|
• Trello-1714 Validation | Schedule C |5|
• Trello-1715 Validation | Schedule D |8|

PR #1377 Readonly compliance report

• Trello-1638 Compliance Report | Read only when submitting compliance report |5|

Technical Information

This release was deployed on Dev Aug 7 2019

Consumption - Mobility and Transportation - Python
Published by amichard over 5 years ago

Transportation Fuels Reporting System - v1.4.24

Pull Requests

PR #1363 Adjustments to schedule B GHGenius selection

PR #1364 Bugfix for spreadsheet line 10

Schedule summary now works if Schedule B is not supplied, fixing a crash recorded on line 10 of the bug spreadsheet

PR #1363 Adjustments to schedule B GHGenius selection

• Trello-1720 Compliance Report | Adjustments to selecting Schedule D entry in Schedule B when relying on GHGenius modelled provision

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.23

Included Pull Requests

PR #1360 Schedule recomputing

Credit computing logic duplicated within Django
Added compute_totals endpoint to viewset. Logically similar to a PATCH but the transaction is always rolled back.
Remove a lot of the heavy lifting from client side for summary computations
Recompute values on the fly when changing tabs
Also fixed delete compliance report not working

PR #1362 Add Dev and Test to Nagios monitoring.

PR #1361 Add browser stack badges and update existing icons as well

PR #1348 Bump django from 1.11.21 to 1.11.22 in /backend

Technical Information

This release was deployed on Dev Aug 1, 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.22

Operational notes

Run 'python manage.py load_ops_data api/fixtures/operational/0016_add_compliance_report_signing_assertions.py' on all three envrionment

Pull Requets

PR #1357 Signing assertions compliance report

This PR should accommodate the Signing Assertions for submitting a Compliance Report

• Updated model to allow classification of signing assertion
• Added Compliance Report for signing confirmation
• Added Submit button
• Added operational script to populate the signing assertions for compliance report
• Clicking on Submit shows the modal that contains the new assertions
• Status can now be set to submitted
• Allowed confirm button in modal to be disabled

PR #1359 Added indicators for the dropdowns in spreadsheets

Adds an indicator to make it clear that the cell contains a drop-down

• Created a class that can be used in spreadsheets
• Applied the class to anything with the Select component
• Automatically hides when using the actual drop-down to remove overlapping styles

Database Migrations

• backend/api/migrations/0164_auto_20190729_1810.py //PR #1357

Implemented Trello

PR #1357 Signing assertions compliance report

• Trello-1249 Compliance Report | Declaration confirmation alert when submitting a Compliance Report
• Trello-1617 Compliance Report | Save button does not save incomplete rows
• Trello-1234 Compliance Report | Submit a Compliance Report

PR #1359 Added indicators for the dropdowns in spreadsheets

• Trello-1444 Compliance Report | Add an indicator for cells with drop-down menu functionality

Technical Information

This release was deployed on Dev July 31 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.21

Included Pull Requests

PR #1352 Create Compliance Report

As discussed, now create a compliance report immediately from the compliance report list and switch to edit mode
Also addresses card 1589 (stay on the edit screen on save)
Removed related, now-superfluous backend code for simplicity

PR #1353 Preliminary validation of compliance reports

Add partial_validate viewset to do validation of compliance reports before submission
Add callback to manage disabled state of compliance report save button based on validation result

PR #1354 Add env variable EXCLUSION_REPORTS_API_ENABLED for backend

Implemented Trello Cards

PR #1352 Create Compliance Report

• Trello-1589 Compliance Report | Using the save button keeps the user on the same page

Technical Information

This release was deployed on Dev July 30 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.18

Operational Notes

• Add 'exclusion_reports.enabled' to configmap
  ** Dev: ture
  ** Test: false
  ** Prod: false
• Add EXCLUSION_REPORTS_API_ENABLED environment variable to backend config, this was NOT added in current release, it is added in release v1.4.21 //PR #1322
  ** Dev: true
  ** Test: false
  ** Prod: false

Included Pull Requests

PR #1293 Browserstack pipeline integration

BDDStack tests can now execute in Browserstack
Requires BROWERSTACK_USERNAME and BROWSERSTACK_TOKEN environment variables
Gradle test task names are now remoteChromeTest , remoteEdgeTest, and remoteFirefoxTest.
Builds and sessions are named appropriately via Browserstack REST API calls
Spock reporting disabled for the moment

PR #1314 Reverse migration that allows Schedule D to be saved with null fuel type and fuel class

Reversing the migration and fuel type and fuel class change.

PR #1315 Preliminary Schedule B and D integration

All schedule records are now returned in correct order
Added intensity to ScheduleBRecord for when provision is Alternative Method
Added schedule_d_sheet_index to ScheduleBRecord for when provision is GHGenius
Lots of testing and new validations on save
Trello card 1349

PR #1322 Exclusion Report Container

Added the Exclusion Report Nav link and Add button

• Added Exclusion Report Container
• Added Exclusion Report Spreadsheet
• Added routes to navigate to the Spreadsheet

PR #1323 include an omission from pr #1315

PR #1318 Add master pipeline fixes in order to deploy v1.4.17 to test and prod

PR #1319 Update Minio monitor after a new Minio image is adopted, also update value of fuel_codes.enabled

Database Migration

• 0161_auto_20190718_1421.py //PR #1314
• 0162_auto_20190718_0625.py //PR #1315

Implemented Trello Cards

PR #1315 Preliminary Schedule B and D integration

• Trello-1349 Compliance Report B | Carbon Intensity of Fuel when relying on the using GHGenius provision

PR #1322 Exclusion Report Container

• Trello-1522 Exclusion Report | Create new Exclusion Report button
• Trello-1528 Exclusion Report | Create Exclusion Agreements page

Technical Information

This release was deployed on Dev July 22 2019.

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.20

Pull Requests

PR #1317 Summary calculation fix

This should fix the calculation of values when loading a compliance report with user-input credits

• Broke down populateSchedules so it's not too massive
• Remove confusing parameter calculatePart3Payable
• Fix proper triggers for recalculating the Payable

PR #1349 Add build status plugin to Jenlinks

Update build status on readme page.

PR #1351 Reenable autosave

The timeout session does not reset when entering data into the compliance reporting spreadsheet plug-in, thus a user will receive a timeout warning notification despite continuously working within the compliance report spreadsheet plug-in.

PR #1350 Disable Browser Autocomplete

• The built-in autocomplete from the browser sometimes can add annoyances to our autocomplete fields. They sometimes clash and can overwrite some data.
• This PR is supposed to turn off the autocomplete from our Autocomplete fields in the spreadsheet, as well as the input fields with tooltips (Those are mostly for numeric values so they also don't need autocomplete)

Implemented Trello Cards

PR #1317 Summary calculation fix

• Trello-1641 Compliance Report | Summary section penalty payable updating when adjusting value in Line 26

PR #1349 Add build status plugin to Jenlinks

• Trello-1628 Status Update | Update project status icons on TFRS home page on Github

PR #1351 Reenable autosave

• Trello-1441 Timeout | Session timeout does not account for use of the Compliance Report spreadsheet plug-in

Consumption - Mobility and Transportation - Python
Published by kuanfandevops over 5 years ago

Transportation Fuels Reporting System - v1.4.19

Operational script

Run 'python manage.py load_ops_data api/fixtures/operational/0015_add_transaction_types.py' on all three environment

PR #1326 Fixed rounding in the schedule summary payable calculation. Also, all…

Fixed issue with the total payable showing decimal values

• Added rounding early for the lines so that the total doesn't have any decimals
• Allowed additional tooltip message
• Formatted the value in the tooltip to show commas

PR #1328 Fixed Missing Fuel Codes

Added another condition to take into account if the fuel code effective date and expiry date is greater than the compliance period dates

PR #1333 Schedule C Quantity Input changes

Quantity in Schedule C should now add commas as you're typing.

• Changed Input field in Quantity to whole numbers and adds commas as you're typing
• Changed Company to Organization

PR #1344 Enable transaction per request

Turn on transaction-per-request in database config

PR #1345 Compliance reporting state elevation

All schedule state now lives in ComplianceReportingEditContainer, and is propagated down to schedules in the form of props.
Schedule summary still needs some work and does not accurately reflect the current state of entries (computation is now taking place partly on the server-side, and should be moved to 100% client-side)
This paves the way for good autosave and validation support, coming soon

PR #1343 Devops browserstack integration

PR #1336 Schedule Summary Diesel Gasoline Rounded Input

Added automatic commas for input field in Diesel and Gasoline

• Summary Gasoline and Diesel Input fields no longer allow decimals
• Input fields should automatically add commas

PR #1342 Exclusion report intro

Added Intro page for Exclusion Report. Also, added drop-down for some columns

• Added Intro page
• Added new model Transaction Type
• Created operational script for Transaction Type
• Updated dockerized for new operational script
• Added EXCLUSION_REPORTS config for backend
• Moved some front-end components into the app side so it's much easier to be reused

Database Migrations

backend/api/migrations/0163_transactiontype.py //PR #1342

Implemented Trello Cards

PR #1326 Fixed rounding in the schedule summary payable calculation. Also, all…

• Trello-1640 Compliance Report | Adjust tooltip description for offsetting credits credit balance restriction
• Trello-1630 Compliance Report | Use of rounding within Schedule B and the penalty payable section

PR #1336 Schedule Summary Diesel Gasoline Rounded Input

• Trello-1625 Compliance Report | Restrict Line 6 8 17 19 to whole numbers and adjust corresponding label accordingly
• Trello-1624 Compliance Report | Restrict summary section tooltip for Line 6 8 17 19 to whole numbers

PR #1342 Exclusion report intro

• Trello-1556 Exclusion Report | Transaction Type
• Trello-1557 Exclusion Report | Fuel Type
• Trello-1558 Exclusion Report | Legal Name and Address of Transaction Partner

PR #1328 Fixed Missing Fuel Codes

• Trello-1618 Compliance Report B | Some active fuel codes are not selectable within Schedule B

PR #1345 Compliance reporting state elevation

• Trello-1537 Compliance Reporting | Refactor and clean up front end code

PR #1333 Schedule C Quantity Input changes

• Trello-1621 Compliance Report C | Adjustments to the quantity of fuel supplied column
• Trello-1591 Company Details | Rename Company Details to Organization Details

Technical Information

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 6 years ago

Transportation Fuels Reporting System - v1.4.17

Deploymeny Notes

Branch v1.4.17-master-pipeline-tag-fix was created and deployed based on tag v1.4.17 in order to add fix for master-pipeline. There are no TFRS application code included.

Included Pull Requests

PR #1312 Summary Updates

Fixed some issues I've found.
Schedule D - fixed issue with digits more than 3 digits not saving
Summary - should now be saving credits to be offset

PR #1313 Commentable abstract class

We noticed that some db comments weren't getting through.
After some investigation, I noticed that some of the Compliance Reporting models weren't using Auditable, and it was the Auditable abstract class that helped adding the comments. So I had to create a new one as Auditable automatically adds the timestamp and last updated fields.

Database Migrations

• 0158_auto_20190716_2018.py //PR #1312
• 0159_schedulesummary_credits_offset.py //PR #1312
• 0160_auto_20190717_1830.py //PR #1313

Technical Information

This release was deployed on Dev July 17 2019
This release was deployed on Test July 19 2019
This release was deployed on Prod July 24 2019

Consumption - Mobility and Transportation - Python
Published by kuanfandevops almost 6 years ago

Transportation Fuels Reporting System - v1.4.16

Pull Requests

PR #1308 Schedule D Frontend/Saving

Frontend modifications to enable saving/loading of Schedule D worksheets

PR #1307 Customize Autosave URLs

This is a prerequisite to getting autosave working correctly for compliance reporting, since we need to autosave based on a partial pathname.

Also fixed a URI-escaping issue.

PR #1306 Signing Performance

• Profiling showed that sending notifications was the slow aspect of signing credit transfers, since the number of interested people was very large (23 in dev). Specifically RabbitMQ channel acquisition was slow.
• Made sending notifications asynchronous (runs in Celery)
• Much faster now (though notifications might arrive slightly delayed as they are processed in the background)
• Further improvements would be possible by pooling Rabbit connections, batching notifications, or using NIO to dispatch them (but this code no longer occurs on the critical path so I think it's less urgent)

PR #1304 Schedule summary part3

Part 3 of the Schedule Summary should now fetch values properly

• Created some external functions to get the calculation of credits properly
• Values are now being fetched on load
• Input field will recalculate as needed
• Input field has a max value of organization balance or debit, whichever is lower
• Penalty Payable section should now show values

PR #1300 Prepopulate and Input Field Fix

Fixed the issue with the fuel code pre-populate always checking renewable percentage

• Pre-populating now checks renewable percentage only when the previous version was renewable
• Input field with tooltip fix: decimals are properly blocked again.
• Some refactoring
• Fixed caching issue with the labels

PR #1273 Schedule D Backend

• Added Schedule D models and serializers

PR #1311 Compliance Report Summary Saving

Backend and frontend components enabling saving of fuel retention and deferral items in compliance report summary

PR #1310 Users delete comment

Users can now delete their own comment from credit trades

• Added new column is_deleted
• Added new button to allow users to delete their own comment
• Modal confirmation before sending the delete request to the server
• ESLint Fixes
• pylint Fixes

Database Migrations

• 0155_schedule_d // PR #1273
• 0156_auto_20190716_0523.py //PR #1311
• 0157_credittradecomment_is_deleted.py //PR #1310

Implemented Trello Cards

PR #1308 Schedule D Frontend/Saving

• Trello-1496 Compliance Report D | Save schedule functionality

PR #1307 Customize Autosave URLs

PR #1306 Signing Performance

• Trello-1497 Credit Transfers | Improve performance for signing credit transfers

PR #1304 Schedule summary part3

• Trello-1484 Compliance Report | Part 3 Summary Line 27 and Line 28
• Trello-1483 Compliance Report | Part 3 Summary Line 26
• Trello-1482 Compliance Report | Part 3 Summary Line 23 Line 24 Line 25

PR #1300 Prepopulate and Input Field Fix

• Trello-1575 Compliance Report | Adjustments to Part 2 summary section labels Round 2
• Trello-1574 Compliance Report | Adjustments to Part 2 summary section labels
• Trello-1571 Fuel Codes | Prepopulating previous version data causes partially renewable box to always be checked

PR #1273 Schedule D Backend

• Trello-1496 Compliance Report D | Save schedule functionality

PR #1311 Compliance Report Summary Saving

• Trello-1535 Compliance Report | Save functionality for the summary and declaration section

PR #1310 Users delete comment

• Trello-1506 Credit Transfer | Users can delete their comment

Technical Information

This release was deployed on Dev July 16 2019

Consumption - Mobility and Transportation - Python
Published by amichard almost 6 years ago