Create reports in PHPRunner for webTareas system

!!!Skill and experience in using PHPRunner is obligatory!!!

!!!We want to have not only the output, but the whole PHPRunner’s project!!!

Please read complete job description in attachment!

Our company use webTareas([url removed, login to view]) task management system. webTareas saves tasks with all their details in MySQL database.

We need someone to create report system for webTareas in PHPRunner. Report system must connect to database and present tasks:

• Tasks due to today

• Tasks due next 7 days

• Tasks start today

• Tasks start next 7 days

In a report tasks must be presented with:

• Task ID

• Task name

• Task status

• Task priority

• Task completion

• Project Name

• Assigned To

• Assigned By

• Due Date

• Urgency

• Difficulty

• Importance

Fields Urgency, Difficulty and Importance were added by us to webTareas, so we will provide required part of database.

We also want to filter tasks using all above fields and all fields must be searchable. Fields like Assigned To, Task Status must be searchable with drop-down list(screenshot in attachment).

Second thing is a Dashboard created with PHPRunner with a chart(see attached job description).

On the chart tasks must be presented with dots. Color of a dot must correspond with Task Difficulty. Difficulty is stored in database, where 1 is low difficulty(green color), 2 medium(yellow) and 3 high(red). Position on a chart must be set also from database, where Importance and Urgency is saved (1- Low, 2-Medium, 3-High).

After click on a dot, detailed information about the task must appear.

After clicking task ID in a report or any other place, there must be hyperlink to this task in webTareas system.

Required skills:

• PHP Runner

• PHP programming

• MySQL

Screenshot of a sample report we have created in an attachment.

MySQL PHP Software Architecture

Project ID: #6589636

About the project