---
# System prepended metadata

title: Backend Team Backlog
tags: ['2023-07-10']

---

# 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
