X-Git-Url: https://jasonwoof.com/gitweb/?p=contractor-progress.git;a=blobdiff_plain;f=index.php;h=d5e020598fff10ea8d69623e2cc37a9f7a4d1d1b;hp=73bc2a5ddf0b1a9a7c5da02d4561e56c13f5c0ea;hb=5cbc553fa7adf352e63aaff4fe99600e476e6c59;hpb=9f423711f09068df37d0ac666e68eaa2a110ec41 diff --git a/index.php b/index.php index 73bc2a5..d5e0205 100644 --- a/index.php +++ b/index.php @@ -76,14 +76,14 @@ function _index_main() { task_summary('needs_fixing', 'where (state=%i || state=%i) || (client_id=%i && (state<%i || state=%i)) order by id desc', TASK_NEEDS_QUOTE, TASK_BUG, $client_id, TASK_DRAFT, TASK_NEEDS_CLARIFICATION); task_summary('finished_unpaid', 'where state=%i && paid = 0 order by finished_at desc', TASK_FINISHED); task_summary('finished_paid', 'where state=%i && paid = 1 order by finished_at desc limit 20', TASK_FINISHED); - task_summary('queue', 'where state=%i order by client_id, ord', TASK_QUEUED); + task_summary('queue', 'where state=%i order by client_id, ord desc', TASK_QUEUED); } else { if(db_count('tasks', 'where client_id=%i && (state=%i || state=%i || state=%i || state=%i)', $client_id, TASK_DRAFT, TASK_NEEDS_CLARIFICATION, TASK_NEEDS_GO_AHEAD, TASK_NEEDS_TESTING)) { tem_show('needs_attention_header'); task_summary('needs_approval', 'where client_id=%i && (state=%i || state=%i) order by id', $client_id, TASK_NEEDS_GO_AHEAD, TASK_NEEDS_TESTING); task_summary('needs_fixing', 'where client_id=%i && (state=%i || state=%i) order by id', $client_id, TASK_DRAFT, TASK_NEEDS_CLARIFICATION); } - task_summary('queue', 'where client_id=%i && state=%i order by ord', $client_id, TASK_QUEUED); + task_summary('queue', 'where client_id=%i && state=%i order by ord desc', $client_id, TASK_QUEUED); task_summary('jason', 'where client_id=%i && (state=%i || state=%i) order by id desc', $client_id, TASK_NEEDS_QUOTE, TASK_BUG); task_summary('jason_working', 'where client_id=%i && state=%i order by id desc', $client_id, TASK_WORKING); task_summary('finished_unpaid', 'where client_id=%i && state=%i && paid=0 order by finished_at desc', $client_id, TASK_FINISHED);