!Updates.txt

15 may 2022
Task Management System

1. Create Task (Add main task)::store this in task table.
Details: Add
T1, -> these are sub-tasks::store each sub-tasks T1, T2 ... in seperate table - task detail table,
with task ID each
T2,
T3 ...
--> First, searched for how to split a string - delimiter and found a function split_string which works
only in SQL (P.S. found this out later after exploring and trying it out for 2-3 days).
Finally, found a Substring_Index function that works in MySQL to seperate the word/sentence using a delimiter.
Tried hands-on, now it works!
Check this link out for more info: https://coderwall.com/p/zzgo-w/splitting-strings-with-mysql

--> To implement this in php simply use explode function. https://www.php.net/explode

2. Assign Tasks
a. Create a View where admin can see task and sub-tasks.
-->Inner join both task and taskdetail(delimiter seperated table) and insert data into table accordingly.
-->For trows, no need to inner join with task table. Inside the table using tid fetch the task-name via function.
b. A checkbox beside every sub-task.
-->Add in table: <input type="checkbox"/>
c. User option beside every sub-task to select.
-->Display user option using select and option tags.
d. After any subtask is checked a assign button where user will be assigned a task.
1st version:
-->Add all table inside a form to take the values via _POST and update log along with tdetail table. First tried with all
sub-task assigning at once.
-->Take uid, retrieve username, and display if task is assigned.
2nd version:
-->Segregate each sub-task as a row and fill in trows table. Using stid as sub-task id unique column give the option of assigning
a task to the user.

3. View My Tasks
User Dashboard::store user info in user tabel and assigned task in task detail table
a. View Task then Subtask
-->Fetch from trows table where id=uid
-->Give option for complete,need clarification and Submit
-->Also, store it in log
b. An option button - Completed, Require Clarification
c. Add note (text area) to send this as note.
d. Submit button which send this data to admin.

4. Clarification
Admin dashboard::store admin info in admin table
a. View Clarification tab - user, task, taskdetail, note sent by user, note by you(admin).
-->Created a tab for clarification only tasks with note like chat option where prev note is appended to it and so on.
b. Checkbox button add.
c. Select same user auto and other User options too and reassign button.
-->Gave option for new user if to assign it to him.

5. Quality Check
Manager dashboard::store in admin as manager
If usertype==manager then open extra tab in dashboard.
a. User ,task, sub-task, report of task assigned to user
-->Took Clarification tab template and added reassign+completed option.
-->Take only those task which are marked completed by the user.
b. Add an option to add note column if reassign is selected else completed.
-->chat as before.

6. Report
a. Create a table my tasks, not assigned, pending, clarification, reassign, completed
b. Add count on all of these with a hyperlink that shows the table of all matching tasks from the taskdetail table.