3 # Copyright (C) 2008 Jason Woofenden
5 # This program is free software: you can redistribute it and/or modify
6 # it under the terms of the GNU Affero General Public License as published by
7 # the Free Software Foundation, either version 3 of the License, or
8 # (at your option) any later version.
10 # This program is distributed in the hope that it will be useful,
11 # but WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU Affero General Public License for more details.
15 # You should have received a copy of the GNU Affero General Public License
16 # along with this program. If not, see <http://www.gnu.org/licenses/>.
18 require_once('code/tasks.php');
20 $GLOBALS['tasks_form_recipient'] = "fixme@example.com";
24 require_once('code/wfpl/template.php');
25 require_once('code/wfpl/format.php');
26 require_once('code/wfpl/messages.php');
27 require_once('code/wfpl/email.php');
28 require_once('code/db_connect.php');
30 function description_has_fixmes($description) {
31 return (strpos($description, 'FIXME') !== false);
34 function tasks_get_fields() {
35 $title = format_oneline($_REQUEST['title']);
36 $url = format_oneline($_REQUEST['url']);
37 $description = format_unix($_REQUEST['description']);
38 $price = format_decimal($_REQUEST['price']);
40 tasks_tem_sets($title, $url, $description, $price);
42 return array($title, $url, $description, $price);
45 function tasks_tem_sets($title, $url, $description, $price) {
46 tem_set('title', $title);
48 tem_set('description', $description);
49 tem_set('price', $price);
52 function tasks_main() {
54 $GLOBALS['url'] = this_url();
58 if(isset($_REQUEST['tasks_id'])) {
59 $ret = tasks_display_main();
63 tem_show('display_body');
65 $ret = tasks_edit_main();
69 tem_show('edit_body');
73 function tasks_display_main() {
74 $task_id = format_int($_REQUEST['tasks_id']);;
75 $client_id = logged_in();
76 if(logged_in_as_contractor()) {
77 $row = db_get_row('tasks', 'title,url,description,state,price,client_id,paid,finished_at,tested_at', 'where id=%i', $task_id);
79 $row = db_get_row('tasks', 'title,url,description,state,price,client_id,paid,finished_at,tested_at', 'where id=%i && client_id=%i', $task_id, $client_id);
82 list($title, $url, $description, $state, $price, $owner_id, $paid, $finished_at, $tested_at) = $row;
83 tem_set('task_id', $task_id);
84 tem_set('title', $title);
86 tem_set('description', $description);
87 tem_set('state', task_state_pretty($state));
88 tem_set('price', $price);
90 tem_set('finished_at', $finished_at);
91 tem_show('finished_at_section');
94 tem_set('tested_at', $tested_at);
95 tem_show('tested_at_section');
97 if($state == TASK_BUG) {
98 tem_show('bug_title');
100 tem_show('normal_title');
102 if(logged_in_as_contractor()) {
105 case TASK_NEEDS_CLARIFICATION:
106 case TASK_NEEDS_QUOTE:
108 tem_show('normal_edit_link');
110 case TASK_NEEDS_GO_AHEAD:
111 tem_show('approve_price_link');
112 tem_show('normal_edit_link');
113 tem_show('price_row');
116 tem_show('normal_edit_link');
117 tem_show('working_link');
118 tem_show('price_row');
121 tem_show('price_row');
122 tem_show('needs_testing_link');
124 case TASK_NEEDS_TESTING:
125 if($owner_id == logged_in()) {
126 tem_show('finished_link');
131 tem_show('marked_paid');
133 tem_show('mark_paid_link');
135 tem_show('price_row');
141 case TASK_NEEDS_CLARIFICATION:
144 tem_show('normal_edit_link');
146 case TASK_NEEDS_QUOTE:
147 tem_show('hold_link');
148 tem_show('normal_edit_link');
150 case TASK_NEEDS_GO_AHEAD:
151 tem_show('price_row');
152 tem_show('approve_price_link');
153 tem_show('normal_edit_link');
156 tem_show('price_row');
157 tem_show('warning_edit_link');
158 tem_show('hold_link');
161 tem_show('price_row');
163 case TASK_NEEDS_TESTING:
164 tem_show('price_row');
165 tem_show('finished_link');
168 tem_show('price_row');
173 message("Task #$task_id not found");
178 define('MAX_PRIORITY', 2000000000);
179 define('MIN_PRIORITY', 0);
180 define('MID_PRIORITY', floor((MAX_PRIORITY - MIN_PRIORITY) / 2));
182 function new_lowest_priority($client_id) {
183 $lowest_ord = db_get_value('tasks', 'ord', 'where client_id=%i && state=%i order by ord asc limit 1', $client_id, TASK_QUEUED);
184 if($lowest_ord === false) {
187 if($lowest_ord == MIN_PRIORITY) {
188 reprioritize_tasks($client_id); # make room
189 $lowest_ord = db_get_value('tasks', 'ord', 'where client_id=%i && state=%i order by ord asc limit 1', $client_id, TASK_QUEUED);
191 return MIN_PRIORITY + floor(($lowest_ord - MIN_PRIORITY) / 2);
194 # keep everything in the same order, but space them out so there's room to squeeze things in anywhere
195 function reprioritize_tasks($client_id) {
196 $ids = db_get_column('tasks', 'id', 'where client_id=%i && state=%i order by ord desc, id desc', $client_id, TASK_QUEUED);
197 $step = floor((MAX_PRIORITY - MIN_PRIORITY) / (count($ids) + 1));
199 foreach($ids as $id) {
201 db_update('tasks', 'ord', $cur, 'where id=%i', $id);
206 # pass the task id and one of (up,down,top,bottom)
207 function prioritize_task($id, $change) {
208 $row = db_get_row('tasks', 'client_id,ord', 'where id=%i', $id);
210 message('Database error #2242');
213 list($client_id, $ord) = $row;
216 list($highest_id, $highest_ord) = db_get_row('tasks', 'id,ord', 'where client_id=%i && state=%i order by ord desc limit 1', $client_id, TASK_QUEUED);
217 if($highest_id == $id) {
218 message('Already highest priority');
222 if($highest_ord == MAX_PRIORITY) {
223 reprioritize_tasks($client_id); # make room
224 $highest_ord = db_get_value('tasks', 'ord', 'where client_id=%i && state=%i order by ord desc limit 1', $client_id, TASK_QUEUED);
227 $new_ord = MAX_PRIORITY - floor((MAX_PRIORITY - $highest_ord) / 2);
228 db_update('tasks', 'ord', $new_ord, 'where id=%i', $id);
231 list($lowest_id, $lowest_ord) = db_get_row('tasks', 'id,ord', 'where client_id=%i && state=%i order by ord asc limit 1', $client_id, TASK_QUEUED);
232 if($lowest_id == $id) {
233 message('Already lowest priority');
237 if($lowest_ord == MIN_PRIORITY) {
238 reprioritize_tasks($client_id); # make room
239 $lowest_ord = db_get_value('tasks', 'ord', 'where client_id=%i && state=%i order by ord asc limit 1', $client_id, TASK_QUEUED);
242 $new_ord = MIN_PRIORITY + floor(($lowest_ord - MIN_PRIORITY) / 2);
243 db_update('tasks', 'ord', $new_ord, 'where id=%i', $id);
247 if($change == 'up') {
248 $rows = db_get_rows('tasks', 'id,ord', 'where client_id=%i && state=%i order by ord desc, id desc', $client_id, TASK_QUEUED);
249 if($rows[0][0] == $id) {
250 message('Already highest priority');
253 if($rows[1][0] == $id) {
254 prioritize_task($id, 'top');
258 $rows = db_get_rows('tasks', 'id,ord', 'where client_id=%i && state=%i order by ord asc, id asc', $client_id, TASK_QUEUED);
259 if($rows[0][0] == $id) {
260 message('Already lowest priority');
263 if($rows[1][0] == $id) {
264 prioritize_task($id, 'bottom');
268 # find the one we're moving
270 $done = count($rows);
271 for($i = 2; $i < $done ; ++$i) {
272 if($rows[$i][0] == $id) {
277 $before_ord = $rows[$cur_index - 1][1];
278 $before_before_ord = $rows[$cur_index - 2][1];
279 if(abs($before_before_ord - $before_ord) < 2) {
280 reprioritize_tasks($client_id);
281 $before_ord = db_get_value('tasks', 'ord', 'where id=%i', $rows[$cur_index - 1][0]);
282 $before_before_ord = db_get_value('tasks', 'ord', 'where id=%i', $rows[$cur_index - 2][0]);
283 if($before_before_ord == $before_ord) {
284 message('Programmer error #8592');
288 $new_ord = $before_ord + floor(($before_before_ord - $before_ord) / 2);
289 db_update('tasks', 'ord', $new_ord, 'where id=%i', $id);
292 message('invalid change');
298 function tasks_edit_main() {
299 $state = TASK_DRAFT; # will be overwritten
300 $client_id = logged_in(); # fixed shortly if we're contractor, unless it's a new task by the contractor
301 $edit_id = format_int($_REQUEST['tasks_edit_id']);
302 unset($_REQUEST['tasks_edit_id']);
304 $owner = db_get_value('tasks', 'client_id', 'where id=%i', $edit_id);
305 if(logged_in_as_contractor()) {
307 } elseif($owner != $client_id) {
308 message('Sorry, that task was entered by/for another client.');
312 # add hidden field for database id of row we're editing
313 tem_set('tasks_edit_id', $edit_id);
316 $state = db_get_value('tasks', 'state', 'where id=%i', $edit_id);
319 if(isset($_REQUEST['bump'])) {
320 switch($_REQUEST['bump']) {
325 prioritize_task($edit_id, $_REQUEST['bump']);
330 if(isset($_REQUEST['tasks_new_bug'])) {
334 if(isset($_REQUEST['tasks_hold_id'])) {
335 $id = $_REQUEST['tasks_hold_id'];
336 db_update('tasks', 'state', TASK_ON_HOLD, 'where id=%i', $id);
337 message("Task removed from Jason's to-do list.");
341 if(isset($_REQUEST['tasks_mark_paid_id'])) {
342 if(!logged_in_as_contractor()) {
343 message("Error: only Jason can mark tasks as paid.");
346 $id = $_REQUEST['tasks_mark_paid_id'];
347 db_update('tasks', 'paid', 1, 'where id=%i', $id);
348 message('Marked as paid.');
352 if(isset($_REQUEST['tasks_approve_price_id'])) {
353 $id = $_REQUEST['tasks_approve_price_id'];
354 $owner = db_get_value('tasks', 'client_id', 'where id=%i', $id);
355 if(logged_in() != $owner) {
356 message("Error: can't approve a task entered by/for another client.");
359 $ord = new_lowest_priority($owner);
360 db_update('tasks', 'state,ord', TASK_QUEUED, $ord, 'where id=%i', $id);
361 message('Price approved.');
365 if(isset($_REQUEST['tasks_working_id'])) {
366 $id = $_REQUEST['tasks_working_id'];
367 if(!logged_in_as_contractor()) {
368 message("Error: only Jason can say what he's working on.");
371 db_update('tasks', 'state', TASK_WORKING, 'where id=%i', $id);
372 message('Task marked as "in progress".');
373 return './tasks?tasks_id=' . $id;
376 if(isset($_REQUEST['tasks_needs_testing_id'])) {
377 $id = $_REQUEST['tasks_needs_testing_id'];
378 if(!logged_in_as_contractor()) {
379 message("Error: only Jason can say when he's done.");
382 db_update('tasks', 'state,finished_at', TASK_NEEDS_TESTING, date('Y-m-d'), 'where id=%i', $id);
383 message('Task awaits testing.');
387 if(isset($_REQUEST['tasks_finished_id'])) {
388 $id = $_REQUEST['tasks_finished_id'];
389 $owner = db_get_value('tasks', 'client_id', 'where id=%i', $id);;
390 if(logged_in() != $owner) {
391 message("Error: can't test a task entered by/for another client.");
394 db_update('tasks', 'state,tested_at', TASK_FINISHED, date('Y-m-d'), 'where id=%i', $id);
395 message('Task marked as finished.');
396 # FIXME also mark it as paid if client's balance can cover it
400 $delete_id = format_int($_REQUEST['tasks_delete_id']);
401 unset($_REQUEST['tasks_delete_id']);
403 db_delete('tasks', 'where id=%i', $delete_id);
404 message('Task deleted.');
406 return './tasks.html';
409 if(isset($_REQUEST['title'])) {
410 list($title, $url, $description, $price) = tasks_get_fields();
412 if(logged_in_as_contractor() && $_REQUEST['client_id']) {
413 $client_id = format_int($_REQUEST['client_id']);
417 if(isset($_REQUEST['save_draft'])) {
419 } elseif(isset($_REQUEST['save_bug'])) {
421 } elseif(isset($_REQUEST['save_price_no_tiny']) && logged_in_as_contractor()) {
422 $state = TASK_NEEDS_GO_AHEAD;
423 } elseif(isset($_REQUEST['save_price']) && logged_in_as_contractor()) {
424 $tiny_agreement = db_get_value('people', 'tiny_agreement', 'where id=%i', $client_id);
425 if($price <= $tiny_agreement) {
426 $state = TASK_QUEUED;
429 $state = TASK_NEEDS_GO_AHEAD;
431 } elseif(isset($_REQUEST['needs_clarification'])) {
432 $state = TASK_NEEDS_CLARIFICATION;
433 } else { # better be "request_price"
434 if(description_has_fixmes($description)) {
435 $state = TASK_NEEDS_CLARIFICATION;
436 message("Error: Not requesting price. To get this task priced, you'll need to edit the description so it no longer contains \"FIXME\".");
438 $state = TASK_NEEDS_QUOTE;
442 if(!logged_in_as_contractor() || $edit_id || $_REQUEST['client_id']) {
444 $tables = 'title,url,description,state';
445 $values = array($title, $url, $description, $state);
446 if(isset($_REQUEST['price']) && logged_in_as_contractor()) {
448 array_push($values, $price);
451 $client_id = db_get_value('tasks', 'client_id', 'where id=%i', $edit_id);
453 array_push($values, new_lowest_priority($client_id));
455 db_update('tasks', $tables, $values, 'where id=%i', $edit_id);
456 message('Changes saved.');
460 $client_id = logged_in();
461 if(logged_in_as_contractor() && $_REQUEST['client_id']) {
462 $client_id = format_int($_REQUEST['client_id']);
463 $client_name = db_get_value('people', 'name', 'where id=%i', $client_id);
465 # if client entered the task, no price is set
468 if($state == TASK_QUEUED) {
469 $ord = new_lowest_priority($client_id);
473 db_insert('tasks', 'client_id,title,url,description,state,paid,price,ord', $client_id, $title, $url, $description, $state, $paid, $price, $ord);
474 if(logged_in_as_contractor()) {
475 message("Task saved for $client_name.");
477 message('Task saved.');
480 if($GLOBALS['tasks_form_recipient'] != "fixme@example.com") {
481 $to = $GLOBALS['tasks_form_recipient'];
484 if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
485 $reply_to = $_REQUEST['email'];
486 if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
487 $reply_to = "$_REQUEST[name] <$reply_to>";
490 $subject = 'tasks form submitted';
491 $message = tem_run('tasks.email.txt');
494 if(email($from, $to, $subject, $message, $reply_to, $cc, $bcc)) {
495 message('Due to an internal error, your message could not be sent. Please try again later.');
499 if($error !== true) {
503 message('Error: you must select a client for the task');
505 # otherwise, we display the form again. tasks_get_fields() has
506 # already put the posted values back into the template engine, so they will
507 # show up in the form fields. You should add some message asking people to
508 # fix their entry in whatever way you require.
510 # we've recieved an edit id, but no data. So we grab the values to be edited from the database
511 list($title, $url, $description, $state, $price) = db_get_row('tasks', 'title,url,description,state,price', 'where id=%i', $edit_id);
512 tasks_tem_sets($title, $url, $description, $price);
514 # form not submitted, you can set default values like so:
515 #tem_set('client_id', 'Yes');
520 tem_show('edit_msg');
521 } elseif($state == TASK_BUG) {
525 if(logged_in_as_contractor()) {
526 pulldown('client_id', db_get_rows('people', 'id,name', 'where id > 1 order by name'), PULLDOWN_2D);
527 tem_set('client_id', format_int($_REQUEST['client_id']));
528 tem_show('client_row');
532 # display instructions
533 if($state == TASK_BUG) {
534 tem_show('bug_instructions');
535 if(logged_in_as_contractor()) {
536 tem_show('price_field');
537 tem_show('contractor_submits');
539 tem_show('bug_submit');
541 } elseif($state == TASK_NEEDS_QUOTE && logged_in_as_contractor()) {
542 tem_show('set_price_instructions');
543 tem_show('price_field');
544 tem_show('contractor_submits');
546 if(description_has_fixmes($description)) {
547 tem_show('fixme_instructions');
549 tem_show('normal_instructions');
551 if(logged_in_as_contractor()) {
552 tem_show('contractor_submits');
555 case TASK_NEEDS_CLARIFICATION:
556 case TASK_NEEDS_QUOTE:
557 case TASK_NEEDS_GO_AHEAD:
560 tem_show('price_field');
563 tem_show('normal_submits');