TASKS MODULE
AGENDA
• Introduction – What is tasks module
• Tasks list data
• Dashboard
• Database relations
2
Overview:
task management is the process of managing a
task through its life cycle.
Importance:
task management is crucial for productivity and
organization as it helps in tracking and managing
tasks efficiently.
Overview of "My Tasks "Task List and Status:
Displays a list of tasks with their completion status.
Tasks can be identified as overdue (highlighted in red with the number of days overdue).
Task Details:
Includes the task deadline, repetition frequency, reminders, and task description.
Example: Task is overdue by 86 days, repeats daily, with specific reminder settings.
Task Categories:
Tasks are categorized under different sections such as:
Pending Tasks: Tasks assigned to you or those you have assigned.
Completed Tasks: Tasks marked as done by you or others.
Other Categories: Includes "For Review" and "Deleted" tasks.
User Interface:
The interface allows for easy navigation and management of tasks.
Features include task filters, sorting options, and actionable buttons for task updates.
TASK STATUSES
بانتظار
قيد االجراء قادمة مكتملة محذوفة
الموافقة
• The default • An • If the • If a task is • If you
state of upcoming person 100% delete a
the task task, responsible complete, task, its
when it is meaning for the its status status will
created or that work task will change change to
reopened on it has completes to Deleted
not yet it, its complete
begun, and status will
the change to
completion awaiting
rate is 0%. approval
until it is
approved
by the
person to
whom it
5
was
OVERVIEW:
Status Explanation:
• Tasks can have different statuses such as ''متأخرة
(Delayed), '( 'تبقى أيامDays Remaining).
Deadline Management:
• The system shows deadlines to help manage task
timelines.
6
CREATE NEW TASK
[Link] to berry tasks module
2. Click to add new task
[Link] the data.
[Link] save.
MAIN FIELDS
Title العنوان Title
Assign to user مسندة إلى AssignedToUserId
Description الوصف Description
Deadline الموعد النهائي Deadline
Notes المالحظات Note “as html tags”
Is Done Task انجاز المهمة IsDone
Copy to صورة الى TaskCarbonCopys
“sent copy from the
tasks to several users
to see”
Task status حالة المهمة StatusId { from
8 TaskStatus table }
TaskClassifications
Id
NameAr
NameEn FK_TaskItems_TaskClassifications_TaskClassificationId
IsDeleted TaskItems
Id
AssignedToUserId
FK_TaskCheckListItems_TaskCheckListItems_ParentId TaskTypeId
FK_TaskCheckListItems_TaskItems_TaskId AssignedToIndividualId
TaskCheckListItems StatusId
Id
UpdatedBy
Title
ConnAppId
TaskId
ReassignedByUserId TaskTypes
FK_dbo.TaskItems_dbo.TaskTypes_TaskTypeId
ParentId
TaskClassificationId Id
IsDone
TaskImportanceId TextAr
IsDeleted
RestoredBy TextEn
CreatedDate
RecurringSettingId ShowPageNumber
UpdatedDate
CreatedBy
UpdatedBy
FK_TaskCarbonCopys_TaskItems_TaskId
TaskCarbonCopys
Id FK_TaskItems_TaskImportances_TaskImportanceId
TaskId
IsSeen
SeenDate
UserId FK_dbo.TaskItems_dbo.TaskStatus_StatusId
CreatedBy TaskImportances
CreatedDate Id
UpdatedDate NameAr
UpdatedBy NameEn
IsDeleted
TaskStatus
Id
NameAr
NameEn
[Order]
CssClass
IsInitial
IsFinal
IsDeleted
CreatedDate
UpdatedDate
CreatedBy
UpdatedBy
IsCompleted
RECURRING TASKS
• Create new tasks as recurring task for example for 3 das.
10
WE NOTICE THAT THE TASK SAVED INTO THE
BELOW TABLES :
11
TaskCheckListItems
TaskItems
Id
Id
Title
Title
TaskId
Description
ParentId
AssignedToUserId
IsDone
Note
IsDeleted
CHECK LIST ()قائمة التحقق
CreatedDate
CreatedDate
CreatedBy
UpdatedDate
Deadline
CreatedBy
ReminderDateTime
UpdatedBy
EmployeeReminderDateTime
ReminderHangfireJobId
EmployeeReminderHangfireJo...
• Creating DeadlineHangfireJobId
LateReminderHangfireJobId
IsDone
Checklists: DoneByUserId
DoneOn
IsRead
LateReminderProcessed
• Checklists can be
PagesNo
TaskTypeId
IsCanceled
created to break
AssignedToIndividualId
FollowUpDateTime
FollowUpHangfireJobId
down tasks into AssignationSourceEnum
IsDeleted
StatusId
smaller, CompletionPercentage
UpdatedDate
UpdatedBy
manageable parts. ConnAppId
ConnCreatedByAr
ConnCreatedByEn
ConnStatusId
• Managing ConnStatusTextAr
ConnStatusTextEn
NextSteps
Checklists: PrevSteps
LatenessReason
ConnAppTaskId
ConnStatusColor
• Items can be ConnForPresidentInfo
ReassignedByUserId
IsPersonal
added, edited, or ConfirmCompletionRequired
TaskClassificationId
TaskImportanceId
deleted from the RestoredBy
RestoredDate
checklist.
RecurringSettingId
StartDate
DeadlineType
CreatedOnBehalfOfUserId
UpdatedOnBehalfOfUserId
UseOriginalUserIdOnDelegation
12 UpdateCompletionPercentage...
TASK COMPLETION
PERCENTAGE
Percentage Calculation:
The task completion
percentage depends on the
number of checklist items
checked.
13
METHOD TO CALCULATE TASKS PROGRESS
14
COPY TO :
Send the task for users to
preview the task through
“”صورة الى
The task will add to user as a copy to see
16
TaskItems
Id
AssignedToUserId
If the user click in “تم االطالع TaskCarbonCopys
TaskTypeId
”عليهاthe column IsSeen will Id
AssignedToIndividualId
change to 1 then the task TaskId
StatusId
IsSeen
removed from “For seen” list UpdatedBy
SeenDate
ConnAppId
UserId
ReassignedByUserId
CreatedBy
TaskClassificationId
CreatedDate
TaskImportanceId
UpdatedDate
RestoredBy
UpdatedBy
RecurringSettingId
17
TASKS SENT TO USER AS CC QUERY
select* from TaskItems i
inner join
TaskCarbonCopys s on [Link] = [Link]
where [Link] = '27d75d38-d5e2-4c5e-b478-6a477ca305da'
and IsSeen = 0 and [Link] = 0
18
TO RESTORE TASK FROM REMOVED TASKS
LIST
API/TASKITEMS/RESTORE
19
CORRESPONDENCE TASKS
TaskItems
Id
AssignedToUserId CorrespondenceTasks
TaskTypeId Id
AssignedToIndividualId CorrespondenceId
StatusId ScheduleItemTopicId
UpdatedBy IsAutoAccomplished
ConnAppId FK_CorrespondenceTasks_TaskItems_Id
ReassignedByUserId
TaskClassificationId
TaskImportanceId
RestoredBy
RecurringSettingId
20
COMMITTEES TASKS
FK_dbo.Com
FK_CommitteeTasks_dbo.TaskItem
itteeTasks_TaskItems_Ids_Id
TaskItems CommitteeTasks
Id Id
AssignedToUserId EntityId
TaskTypeId
AssignedToIndividualId
StatusId
UpdatedBy
ConnAppId
ReassignedByUserId
TaskClassificationId
TaskImportanceId
RestoredBy
RecurringSettingId
21
SCHEDULE / INITIATIVES TASKS
TaskItems
Id
AssignedToUserId
TaskTypeId
AssignedToIndividualId
ScheduleItemTasks StatusId
Id UpdatedBy
ScheduleItemId ConnAppId
ReassignedByUserId
Tasks (Initiatives)
TaskClassificationId
Id
TaskImportanceId
InitiativeId
RestoredBy
RecurringSettingId
22
MAIN DASHBOARD
•Total Tasks: A pie chart displays the total number of tasks, with the majority being delayed and
a smaller portion marked as completed.
•Task States: A summary beside the pie chart shows the exact breakdown of delayed and
completed tasks.
•Task Overview: A section provides an overview of tasks, categorizing them into various types
such as those related to meetings, independent tasks, tasks tied to transactions, and one under
committee responsibility.
•Employee Task Overview: Another section gives an overview of employees involved in tasks,
including the number of teams, non-direct employees, and external resources.
23
DASHBOARD QUERY DATA
VAR QUERY = [Link]<TASKITEMVIEW>().WHERE(X => [Link] == FALSE &&
[Link] == FALSE);
IF (BASEQUERYFILTERDTO IS NOT NULL)
{
IF ([Link] IS NOT NULL)
{
QUERY = [Link](X =>
[Link]([Link])
);
}
IF ([Link])
{
QUERY = [Link](X => [Link] == FALSE &&
([Link] == FALSE || ([Link] &&
[Link] < 100)));
}
IF ([Link])
{
QUERY = [Link](X => [Link] != 0);
}
IF ([Link])
{
QUERY = [Link](X => [Link] == FALSE);
}
24
TASK STATUS CHART:
• This bar chart tracks the status of tasks over the months of a specific year.
• The legend indicates three categories: tasks in progress, delayed tasks, and
active tasks, though only delayed tasks are represented in the chart.
• The chart shows the distribution of delayed tasks throughout the year, with
noticeable spikes in certain months, particularly September.
• There are no tasks categorized as in progress or active for the entire year, and
no tasks are recorded for the last three months of the year.
25
THANK YOU
Shyma’a qadoom