Admin Panel

Admin panel for tracking and managing user, project and task.

1. Analytics

• Admin can view total number of users and their activities.
• Admin can view total number of projects and their progress.

1.1 User

• User snapshot (Total Projects, Active Task, User Efficiency)
• Chart for user activities (tasks vs time)
• List of users (Completed, Project Filters)

1.2 Task

• Task snapshot (TODO...)
• Chart for task
• List of Tasks

1.3 Project

• Project snapshot (total users count, total tasks, total time spent, percentage of completion)
• Chart for project activities
• List of projects

2. User Module

Only admin can add a new user.

2.1 Adding a user (required inputs):

• First name
• Last name
• Email address
• Phone number (Optional)
• Password

User will be notified by email after successful addition to Database.

2.2 Actions

• Delete a user. (Tasks are unassigned)
• Remove a user from project.
• Disable a user.

3. Project Module

Only admin has the access to add new project.

3.1 Adding a project (required inputs):

• Name of the project
• Logo of the project
• Color of the project
• Start date
• End date

4. Task Module

Admin can assign new task to a particular user.

4.1 Adding a task (required inputs):

• Name of the task.
• Description (optional)
• Project name
• Assign to a user

4.2 Actions (Specific page):

Admin can see the complete status of the task at different time intervals.

5. Admin Profile

5.1 Profile Details:

Admin can change profile picture and his details in this section.

• Upload profile picture (Dependency: TODO...)

5.1 Change Password:

Admin can change the password from this section. Required fields:

• old password
• new password
• confirm password

5.2 Logout

Admin can logout from system by clicking on logout.

6. Email templates:

• New user created.
• Password reset
• New task assigned (to the user).
• User blocked (User disabled case)

7. Design and Implementation

7.1 Core data design

Entities

Task Details (Table Name: time_details)

• id - Integer (Auto Increment)
• ref_id - Integer (refers to )
• type - Enum('login', 'task')
• project_id - Integer (refers to)
• task_name - Varchar
• description - Varchar
• t_date - Date
• start_time - Time
• end_time - Time
• created_on - Datetime
• modified_on - Datetime

Projects Assigning (Table name: project_assignee)

• id - Integer (Auto Increment)
• project_id - Integer(refers to )
• user_id - Integer (refers to )
• created_on - Datetime
• modified_on - Datetime

Project Details(Table name: project)

• id - Integer (Auto Increment)
• name - Varchar
• meta_data - Varchar
• created_on - Datetime
• modified_on - Datetime

Login Details (Table name: login)

• id - Integer (Auto Increment)
• email - Varchar
• password - Varchar
• reset_token - Varchar
• type - Enum('user', 'admin')
• ref_id - Integer
• created_on - Datetime
• modified_on - Datetime
• logout_time - Time

User Details (Table name: user)

• id - Integer (Auto Increment)
• name - Varchar
• email - Varchar
• phone - Bigint
• type - Enum('user', 'admin')
• created_on - Datetime
• modified_on - Datetime
• profile - varchar

8. Dataflow diagram


9. Sequence diagram