Project description
I need a programmer. You need to write a program of tasks.
The essence is to automate the setting and execution of tasks of the entire enterprise through the database.
Create a website (buying a domain, hosting, etc.)
On the main page only the login form (you say enter the login and password)
When a person enters a login and password, he gets to the page where his task table is displayed.
We use Google tables now, but we have limited functionality.
The table has three levels of hierarchy.
1st is the Founder (he sets tasks and receives feedback)
2nd is a senior and middle manager (they get tasks, can redirect them to performers, add new tasks, and complete their own)
3rd is the Executor (they only receive and perform tasks, without the ability to forward, but with the ability to add tasks to themselves)
Table 1 of the level is as follows (for example, the Founder):
Task To Who is addressed Date of task End date (deadline) Color of the DECLAINER Color of the CONTRACTOR Note
Task 1 Tech. Director 1-05 15-05
How we work:
For example, the Task Manager (Director) sets the task, selects from the drop-down list “To whom is addressed” the Contractor, sets dates and selects the color of the Director.
We use three colors that have their own logical meaning:
Red task not accomplished
Blue task accomplished by the performer
The green task is verified as completed
The task manager in his graph chooses the color red. This color is seen by the artist, and he also has it marked in red. When the performer has completed the task, he marks his count in blue. The task manager sees the colors Red/Blue. He checks the task (whether it is done or not, he does it verbally) and notes from red to green and can delete the task.
Conditions: if the Director has marked the color Red in the cell of the Contractor, the color red appears. The artist can change the color from Red to Blue. And when the Director marks the color green, the Performer has the color green.
The note is filled by the Contractor as feedback.
Functions:
1. When the Director selects from the drop-down list of the Contractor, the task automatically falls into the Table of this Contractor.
2. Everyone should be able to sort their table by each of the columns (by date, by color of the DECLAINER, by color of the CONTRACTOR) – an analogue of filters Exel. But with the ties.
Table 2 of the level is as follows (e.g. Technical Director):
The task is addressed to Who the Date of the task End date (deadline) Color DECIDER.
The color is FULL. Note to whom the color of the President was forwarded
Color EXCLUSIVE NOTE
Task 1 Tech. Director 1-05 15-05 GL. Engineer.
Features. The second level performer cannot change the cells from 1st to 5th.
The level 3 table is as follows (e.g., Chief Engineer):
Task To Who is addressed Date of task End date (deadline) Color of the DECLAINER Color of the CONTRACTOR Note
Task 1 GL. Engineer 1-05 15-05
Features: The third-level artist can only change the color of the Contractor and add notes.
This is about the level of users.
As for the level of administrator of this system, it should be possible to:
- add/delete the user
Change the levels of hierarchy
Add/remove to the drop-down list of Contractors
You should not create a CMS for the administrator. If it is possible to do this through phpMyAdmin, then I think it is enough.
Now as for the implementation of frontend, backend and other things.
Frontend. We are not very careful about design in this case. Minimalism in everything. There are only two pages in this project: the entrance page and the table. The login page is just two usernames and a password (plus add the company logo). And the design of the Tables page -- we're completely tripled by the design of Google Tables. Plus buttons like add task and so on (offer from standard solutions).
Beckand. Everything will be done on MySQL. You will do it using third-party programs (such as workshop or others) or directly in phpMyAdmin – it is at your discretion. As for cleaning the database (when a critical mass of completed tasks accumulate) - we are ready to consider your offer. The number of people who will be in the system is about 50 people. The number of tasks per week is 20-30 for each user.
The only thing you're gonna need to do is set up Beckup.
The essence is to automate the setting and execution of tasks of the entire enterprise through the database.
Create a website (buying a domain, hosting, etc.)
On the main page only the login form (you say enter the login and password)
When a person enters a login and password, he gets to the page where his task table is displayed.
We use Google tables now, but we have limited functionality.
The table has three levels of hierarchy.
1st is the Founder (he sets tasks and receives feedback)
2nd is a senior and middle manager (they get tasks, can redirect them to performers, add new tasks, and complete their own)
3rd is the Executor (they only receive and perform tasks, without the ability to forward, but with the ability to add tasks to themselves)
Table 1 of the level is as follows (for example, the Founder):
Task To Who is addressed Date of task End date (deadline) Color of the DECLAINER Color of the CONTRACTOR Note
Task 1 Tech. Director 1-05 15-05
How we work:
For example, the Task Manager (Director) sets the task, selects from the drop-down list “To whom is addressed” the Contractor, sets dates and selects the color of the Director.
We use three colors that have their own logical meaning:
Red task not accomplished
Blue task accomplished by the performer
The green task is verified as completed
The task manager in his graph chooses the color red. This color is seen by the artist, and he also has it marked in red. When the performer has completed the task, he marks his count in blue. The task manager sees the colors Red/Blue. He checks the task (whether it is done or not, he does it verbally) and notes from red to green and can delete the task.
Conditions: if the Director has marked the color Red in the cell of the Contractor, the color red appears. The artist can change the color from Red to Blue. And when the Director marks the color green, the Performer has the color green.
The note is filled by the Contractor as feedback.
Functions:
1. When the Director selects from the drop-down list of the Contractor, the task automatically falls into the Table of this Contractor.
2. Everyone should be able to sort their table by each of the columns (by date, by color of the DECLAINER, by color of the CONTRACTOR) – an analogue of filters Exel. But with the ties.
Table 2 of the level is as follows (e.g. Technical Director):
The task is addressed to Who the Date of the task End date (deadline) Color DECIDER.
The color is FULL. Note to whom the color of the President was forwarded
Color EXCLUSIVE NOTE
Task 1 Tech. Director 1-05 15-05 GL. Engineer.
Features. The second level performer cannot change the cells from 1st to 5th.
The level 3 table is as follows (e.g., Chief Engineer):
Task To Who is addressed Date of task End date (deadline) Color of the DECLAINER Color of the CONTRACTOR Note
Task 1 GL. Engineer 1-05 15-05
Features: The third-level artist can only change the color of the Contractor and add notes.
This is about the level of users.
As for the level of administrator of this system, it should be possible to:
- add/delete the user
Change the levels of hierarchy
Add/remove to the drop-down list of Contractors
You should not create a CMS for the administrator. If it is possible to do this through phpMyAdmin, then I think it is enough.
Now as for the implementation of frontend, backend and other things.
Frontend. We are not very careful about design in this case. Minimalism in everything. There are only two pages in this project: the entrance page and the table. The login page is just two usernames and a password (plus add the company logo). And the design of the Tables page -- we're completely tripled by the design of Google Tables. Plus buttons like add task and so on (offer from standard solutions).
Beckand. Everything will be done on MySQL. You will do it using third-party programs (such as workshop or others) or directly in phpMyAdmin – it is at your discretion. As for cleaning the database (when a critical mass of completed tasks accumulate) - we are ready to consider your offer. The number of people who will be in the system is about 50 people. The number of tasks per week is 20-30 for each user.
The only thing you're gonna need to do is set up Beckup.
