LCFS - Implement Audit Log View for IDIR Administrators

[AlexZorkin]

Description:
Create a new feature in the IDIR administration tab that displays a table view of the audit log. This view will be accessible only to administrators and will utilize the AG Grid read-only table to display data from the audit_log table.

Purpose and benefit to user:
This feature will allow administrators to view, sort, filter, and search the audit log, providing insights into system changes, user actions, and potential security issues.

Acceptance Criteria:

• Given I am an administrator, When I navigate to the administration tab, Then I see an "Audit Log" option
• Given I am an administrator, When I click on "Audit Log", Then I see a table view populated with data from the audit_log table
• Given I am a non-administrator user, When I access the administration tab, Then I do not see or have access to the "Audit Log" view
• Given I am an administrator viewing the audit log, When I interact with the table, Then I can sort, filter, and search the data
• Given I am an administrator, When I view the audit log table, Then I see columns for timestamp, user_id, table_name, operation, row_id, and a summarized view of the delta
• Given I am an administrator, When I click on a row in the audit log, Then I see a detailed view of the JSON delta

Development Checklist:

• Implement backend API endpoint to fetch audit log data with pagination and filtering
• Create frontend component for the Audit Log view using AG Grid
• Implement role-based access control to restrict view to administrators only
• Integrate the new component into the administration tab
• Implement sorting, filtering, and search functionality for the table
• Create a detailed view component for displaying the full JSON delta
• Add appropriate error handling and loading states
• Implement date range filtering for the audit log
• Add export functionality for audit log data
• Write unit and integration tests for both frontend and backend
• Update documentation to include information about the new feature

Notes:

• Ensure that the JSON delta is displayed in a user-friendly format, possibly using a JSON viewer component
• Implement proper security measures to prevent unauthorized access to the audit log data