Backend Team Backlog

# Backend Team Backlog > Update Date: 2023-07-10 [TOC] ## Check Plus ### Development #### Feature: Notifications Lib - **Refactor notifications lib to support multiple provider** - status: `New` - Assigned To: `None` - Tags: `Libs`, `Refactor` - **Implement New Firebase API as a new default notification provider** - status: `New` - Assigned To: `None` - Tags: `Libs`, `Refactor` #### Feature: Jitsi Integration - **Jitsi Dev Certificate** - status: `Inprogress` - Assigned To: `Eslam Kotb` - Tags: `Jitsi` - Description: Generate private key and certificate for Jitsi domain on dev environment - **Deploy Jitsi** - status: `OnHold` (Pending Access, Certificate) - Assigned To: `Mohamed Seada`, `Eslam Kotb` - Tags: `Jitsi` - Description: Deploy Jitsi on dev environment - **Jitsi Access Token** - status: `Inprogress` - Assigned To: `Mohamed Seada` - Tags: `Jitsi`, `API` - Description: configure jitsi access token and modify conference access token endpoint using jitsi - **Jitsi Notifications** - status: `New` - Assigned To: `Mohamed Seada` - Tags: `Jitsi`, `API` - Description: Implement call notifications using firebase and modify device registration endpoint - **Jitsi Video Recording** - status: `OnHold` (Pending Dev Deployment) - Assigned To: `Mohamed Seada` - Tags: `Jitsi`, `API` - Description: TBD #### Feature: Dispatching - **Automatic Dispatching** - status: `OnHold` (Pending Aluia Feedback) - Assigned To: `Mohamed Seada`, `Ahmed Etabee` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - Description: Every Day run a dispatching job to schedule visits on the inspectors based on the configured criteria and reschedule the missing visits on the available inspectors. - Comments: This change is requested by a client (Aluia) but added to the product as a new feature - **More User Filters** - status: `New` - Assigned To: `None` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - **More Location Filters** - status: `New` - Assigned To: `None` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - **Take location distance in consideration** - status: `New` - Assigned To: `None` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - **Store Configuration on Database Table** - status: `New` - Assigned To: `None` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - **Build APIs/UI to manage dispatching configurations** - status: `New` - Assigned To: `None` - Tags: `Dispatching`, `Background Job`, `Schedules`, `Aluia` - Comment: this task could be new UI on admin portal or just web APIs and UI will be built in the user portal by front-end team. #### Feature: User Location Tracking - **Document User Tracking Registration Endpoint for Mobile** - status: `New` - Assigned To: `Ahmed Etabee` - Tags: `User-Tracking`, `API` - Description: Share the endpoint specs with the mobile team. - **Retrieve the inspectors last locations** - status: `New` - Assigned To: `None` - Tags: `User-Tracking`, `API` - Description: get list of all inspectors last location. - Inputs: paging options, unit-filter, role-filter, location-filter - Output: user Id, User Name, last track date, coordinates - **Track the inspector location with events** - status: `New` - Assigned To: `None` - Tags: `User-Tracking`, `API` - Description: get list of events and tracking data for specific user. - Inputs: User Id, Interval - Outputs: - userId, user name - list of coordinates with dates - list of events submitted with same time interval (event Id , event date, coordinates , type, submission date) #### Feature: Violations - **View Violations In Portal Advanced Settings** - status: `Review` - Assigned To: `Ahmed Etabee` - Tags: `Violations`, `Portal` - Description: add a view table with filter and paging to display the configured violations - **Import Violations using Excel** - status: `Review` - Assigned To: `Ahmed Etabee` - Tags: `Violations`, `Portal` - Description: use excel sheet to import (Add or Update) violations information and configurations to the system - **Export Violations using Excel** - status: `Review` - Assigned To: `Ahmed Etabee` - Tags: `Violations`, `Portal` - Description: export the violation configuration in excel sheet - **Delete Violations using Excel** - status: `Review` - Assigned To: `Ahmed Etabee` - Tags: `Violations`, `Portal` - Description: use excel sheet to delete (soft delete) some violations from the system - **Add Violations to form builder** - status: `Inprogress` - Assigned To: `Haitham` - Tags: `Violations`, `Portal`, `Form Builder` - Description: add option for the user to build form based on the configured violations based on the location types - **Violations Workflow/Event Integration** - status: `TBD` - Assigned To: `None` - Tags: `Violations`, `Portal`, `Event`, `Workflow` - Description: TBD ### Support #### MCIT - **License Renewal** - status: `OnHold` (Pending Client) - Assigned To: `Mohamed Seada` - Tags: `License`, `Operation` - Priority: `High` - **Release 2 Production Deployment** - status: `OnHold` (Pending Client) - Assigned To: `Mohamed Seada` - Tags: `Operation` - **Power BI Changes Production Deployment** - status: `OnHold` (Pending Client) - Assigned To: `Mohamed Seada` - Tags: `Operation`, `SSIS` - Comments: to apply this change before `release 2` we need to modify the production SSIS Package #### Saib - **Delete Event is not working for the user Issue** - status: `OnHold` (Not Important) - Assigned To: `Mohamed Seada` - Tags: `Bug`, `API` - Priority: `Low` - Actual: Only the specific assigned user could delete the event which is not configured. - Expected: We need to enable the admin(supervisor) user to delete events. #### Aluia - **Reports SQL Views and Samples** - status: `Inprogress` (6/15) - Assigned To: `All BE Team` - Tags: `SQL`, `Data warehouse`, `Excel` - Description: We need to prepare a set of reports to the client from their recent database and export them as Excel sheets. - **Reports SSIS Updates** - status: `OnHold` - Assigned To: `None` - Tags: `SQL`, `Data warehouse`, `SSIS` - Description: We need to add the all tables we used on the task above to the SSIS Package. - Comments: Not sure if this change will be required or It will be canceled. #### Qiwa - **Visits and Inspectors Dashboard** - status: `OnHold` (Pending Client Review) - Assigned To: `Haitham` - Tags: `PowerBI`, `Data warehouse`, `SSIS` #### AlRiyadh - **Reqabaa Data Migrations** - status: `Onhold` (Pending Reqabaa Retirement) - Assigned To: `Mohamed Seada` - Tags: `Integration` - Comment: This task is almost ready there is a bug on the status to workflow actions lookup mapping which should be fixed and tested. - **Qlik Sense Reports** - status: `Onhold` - Assigned To: `None` - Tags: `Integration`, `SQL`, `QlikSense` --- ## Ideas Bank ### Development > - There is no development actions required, The development is handed to a different team. ### Support #### MOT - **Validate Production Deployment** - status: `OnHold` (Pending Client) - Assigned To: `Mohamed Seada` - Tags: `Operation` - Comments: verify the server configuration and the app is running with no issue. - **License Production Confirmation** - status: `OnHold` (Pending Signing) - Assigned To: `Mohamed Seada` - Tags: `Operation` - Comments: send the license key document after being signed. --- ## Check Now --- ## Check Survey