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 function index_main() {
30 # pass multiple argumens for where-clause and printf-args just like db_get_rows()
31 function task_summary($tem_prefix, $where_clause/*, ... */) {
32 $args = func_get_args();
33 $args = array_slice($args, 1);
34 array_unshift($args, 'tasks', 'id,price,title,state,client_id,paid');
35 $rows = call_user_func_array('db_get_rows', $args);
38 $num_rows = count($rows);
40 tem_show($tem_prefix . '_plural');
42 tem_show($tem_prefix . '_singular');
45 foreach($rows as $row) {
46 list($id, $price, $title, $state, $client_id, $paid) = $row;
47 tem_set('task_id', $id);
48 tem_set('task_title', $title);
49 tem_set('task_price', $price);
50 tem_set('task_state', task_state_pretty($state));
51 if(logged_in_as_contractor()) {
52 tem_set('client', db_get_value('people', 'username', 'where id=%i', $client_id));
53 if($tem_prefix == 'queue') {
54 tem_show('queued_for');
57 if($num_rows > 1 && $tem_prefix == 'queue') {
58 tem_show('not_the_only_queued');
60 tem_show($tem_prefix . '_row');
61 if(!$paid && isset($GLOBALS['unpaid_totals'])) {
62 if(!isset($GLOBALS['unpaid_totals'][$client_id])) {
63 $GLOBALS['unpaid_totals'][$client_id] = array();
65 if(!isset($GLOBALS['unpaid_totals'][$client_id][$tem_prefix])) {
66 $GLOBALS['unpaid_totals'][$client_id][$tem_prefix] = 0;
68 $GLOBALS['unpaid_totals'][$client_id][$tem_prefix] += $price;
73 tem_set('task_total', $total);
75 tem_show($tem_prefix);
81 # pass multi-dimensional hash arr[client_id][status].
82 # status strings: 'finished_untested', 'finished_unpaid', 'queue'
83 function totals_summary($arr) {
85 $total_finished_untested = 0;
86 $total_finished_unpaid = 0;
89 foreach($arr as $client_id => $t) {
90 $finished_untested = 0;
94 if(isset($t['finished_untested'])) {
95 $finished_untested = $t['finished_untested'];
97 if(isset($t['finished_unpaid'])) {
98 $finished_unpaid = $t['finished_unpaid'];
100 if(isset($t['queue'])) {
101 $queue = $t['queue'];
103 if(isset($t['do_finish'])) {
104 $working = $t['do_finish'];
106 tem_set('tested_total', $finished_unpaid);
107 tem_set('done_total', $finished_unpaid + $finished_untested);
108 tem_set('not_tested_total', $finished_untested);
109 tem_set('queued_total', $queue + $working);
110 tem_set('client', db_get_value('people', 'username', 'where id=%i', $client_id));
111 tem_show('unpaid_totals_row');
112 $total_finished_untested += $finished_untested;
113 $total_finished_unpaid += $finished_unpaid;
114 $total_queue += $queue;
115 $total_working += $working;
118 tem_set('tested_total', $total_finished_unpaid);
119 tem_set('done_total', $total_finished_unpaid + $total_finished_untested);
120 tem_set('not_tested_total', $total_finished_untested);
121 tem_set('queued_total', $total_queue + $total_working);
122 tem_set('client', 'all');
123 tem_show('unpaid_totals_row');
125 tem_show('unpaid_totals');
129 function _index_main() {
130 $client_id = logged_in();
131 $ever_was_contractor = ever_was_contractor();
133 $contractor_full_name = db_get_value('people', 'name', 'where id=1');
134 if(!$contractor_full_name) {
135 die('To finish installing this site, make yourself an account in the people table with id=1');
137 list($contractor_name,) = explode(' ', $contractor_full_name, 2);
138 tem_set('contractor_name', $contractor_name);
139 tem_set('contractor_full_name', $contractor_full_name);
142 # make sure the client (not the contractor) has filled out the tiny agreement
143 if(!$ever_was_contractor) {
144 $tiny_agreement = db_get_value('people', 'tiny_agreement', 'where id=%i', $client_id);
145 if($tiny_agreement < 30 || $tiny_agreement > 999) {
146 return './tiny_agreement';
150 if($ever_was_contractor) {
154 if(logged_in_as_contractor()) {
155 tem_show('contractor_links');
156 tem_show('contractor_todo');
158 $GLOBALS['unpaid_totals'] = array();
159 task_summary('do_finish', 'where state=%i order by id desc', TASK_WORKING); # this affects queued_total
160 task_summary('do_fix', 'where state=%i order by client_id desc', TASK_BUG);
161 task_summary('do_price', 'where state=%i order by client_id desc', TASK_NEEDS_QUOTE);
163 task_summary('finished_untested', 'where state=%i order by client_id, finished_at desc', TASK_NEEDS_TESTING);
164 task_summary('finished_unpaid', 'where state=%i && paid=0 order by finished_at desc', TASK_FINISHED);
165 task_summary('queue', 'where state=%i order by client_id, ord desc', TASK_QUEUED);
166 totals_summary($GLOBALS['unpaid_totals']);
167 task_summary('finished_paid', 'where state=%i && paid = 1 order by finished_at desc limit 20', TASK_FINISHED);
169 tem_show('not_contractor_links');
171 $num_rows += task_summary('do_approve_price', 'where client_id=%i && state=%i order by id', $client_id, TASK_NEEDS_GO_AHEAD);
172 $num_rows += task_summary('do_clarify', 'where client_id=%i && state=%i order by id', $client_id, TASK_NEEDS_CLARIFICATION);
173 $num_rows += task_summary('do_test', 'where client_id=%i && state=%i order by id', $client_id, TASK_NEEDS_TESTING);
174 $num_rows += task_summary('do_draft', 'where client_id=%i && state=%i order by id', $client_id, TASK_DRAFT);
175 $num_rows += task_summary('do_on_hold', 'where client_id=%i && state=%i order by id', $client_id, TASK_ON_HOLD);
178 tem_show('nothing_needs_your_attention');
179 } elseif($num_rows == 1) {
180 tem_show('this_needs_your_attention');
182 tem_show('these_need_your_attention');
185 task_summary('queue', 'where client_id=%i && state=%i order by ord desc', $client_id, TASK_QUEUED);
187 task_summary('contractor_will', 'where client_id=%i && (state=%i || state=%i || state=%i) order by id desc', $client_id, TASK_NEEDS_QUOTE, TASK_BUG, TASK_WORKING);
189 task_summary('finished_unpaid', 'where client_id=%i && state=%i && paid=0 order by finished_at desc', $client_id, TASK_FINISHED);
190 task_summary('finished_paid', 'where client_id=%i && state=%i && paid=1 order by finished_at desc', $client_id, TASK_FINISHED);