if(logged_in_as_contractor()) {
tem_show('su_link');
tem_show('needs_attention_header');
- task_summary('needs_approval', 'where state=%i order by id desc', TASK_WORKING);
- task_summary('needs_fixing', 'where (state=%i || state=%i) || (client_id=1 && state<%i) order by id desc', TASK_NEEDS_QUOTE, TASK_BUG, TASK_QUEUED);
- task_summary('finished_unpaid', 'where state=%i && paid = 0 order by id desc', TASK_FINISHED);
- task_summary('finished_paid', 'where state=%i && paid = 1 order by id desc', TASK_FINISHED);
+
+ # things with a view link:
+ task_summary('needs_approval', 'where state=%i || (client_id=%i && (state=%i || state=%i || state=%i)) order by id desc', TASK_WORKING, $client_id, TASK_NEEDS_TESTING, TASK_NEEDS_GO_AHEAD, TASK_BUG);
+
+ # things with an edit link:
+ 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);
} 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)) {
task_summary('queue', 'where client_id=%i && state=%i order by ord', $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 id desc', $client_id, TASK_FINISHED);
- task_summary('finished_paid', 'where client_id=%i && state=%i && paid=1 order by id desc', $client_id, TASK_FINISHED);
+ task_summary('finished_unpaid', 'where client_id=%i && state=%i && paid=0 order by finished_at desc', $client_id, TASK_FINISHED);
+ task_summary('finished_paid', 'where client_id=%i && state=%i && paid=1 order by finished_at desc', $client_id, TASK_FINISHED);
}
return;
}
$task_id = format_int($_REQUEST['tasks_id']);;
$client_id = logged_in();
if(logged_in_as_contractor()) {
- $row = db_get_row('tasks', 'title,url,description,state,price', 'where id=%i', $task_id);
+ $row = db_get_row('tasks', 'title,url,description,state,price,client_id', 'where id=%i', $task_id);
} else {
- $row = db_get_row('tasks', 'title,url,description,state,price', 'where id=%i && client_id=%i', $task_id, $client_id);
+ $row = db_get_row('tasks', 'title,url,description,state,price,client_id', 'where id=%i && client_id=%i', $task_id, $client_id);
}
if($row) {
- list($title, $url, $description, $state, $price) = $row;
+ list($title, $url, $description, $state, $price, $owner_id) = $row;
tem_set('task_id', $task_id);
tem_set('title', $title);
tem_set('url', $url);
case TASK_NEEDS_CLARIFICATION:
case TASK_NEEDS_QUOTE:
case TASK_BUG:
+ tem_show('normal_edit_link');
+ break;
case TASK_NEEDS_GO_AHEAD:
+ tem_show('approve_price_link');
tem_show('normal_edit_link');
tem_show('price_row');
break;
tem_show('normal_edit_link');
tem_show('working_link');
tem_show('price_row');
+ break;
case TASK_WORKING:
tem_show('price_row');
tem_show('needs_testing_link');
break;
case TASK_NEEDS_TESTING:
+ if($owner_id == logged_in()) {
+ tem_show('finished_link');
+ }
+ # FALL THROUGH
case TASK_FINISHED:
tem_show('price_row');
tem_show('mark_paid_link'); # FIXME
message("Error: only Jason can say when he's done.");
return './';
}
- db_update('tasks', 'state', TASK_NEEDS_TESTING, 'where id=%i', $id);
+ db_update('tasks', 'state,finished_at', TASK_NEEDS_TESTING, date('Y-m-d'), 'where id=%i', $id);
message('Task awaits testing.');
return './';
}