#6 Improved Stuff to do view

[Soeren Staun Biangslev]

The "Stuff to do" view needs improvements to facilitate the new due_on fields in the database.

Even though the task has a deadline which is later than the other tasks, it's still at the top. The sort order needs to be changed into due_on.

(index.php)

$tasks = $sql->getAll("SELECT T.id,T.name,T.project_id,T.due_on,P.name as project_name "
. " FROM Task As T INNER JOIN Project AS P on project_id=P.id "
. " WHERE T.type='Immediately' AND P.user_id=$_SESSION[user] ORDER BY T.due_on,T.sort_order, T.created_on DESC");

It would be nice to see the due dates next to the task name as well, and perhaps today for all tasks which hasn't got a specified date.

With the due_on push functionality in place, all the tasks with default due_date will have their due date set to today which is perfect, and therefore it makes sense they are first in the task list.