2 // +----------------------------------------------------------------------+
3 // | Anuko Time Tracker
4 // +----------------------------------------------------------------------+
5 // | Copyright (c) Anuko International Ltd. (https://www.anuko.com)
6 // +----------------------------------------------------------------------+
7 // | LIBERAL FREEWARE LICENSE: This source code document may be used
8 // | by anyone for any purpose, and freely redistributed alone or in
9 // | combination with other software, provided that the license is obeyed.
11 // | There are only two ways to violate the license:
13 // | 1. To redistribute this code in source form, with the copyright
14 // | notice or license removed or altered. (Distributing in compiled
15 // | forms without embedded copyright notices is permitted).
17 // | 2. To redistribute modified versions of this code in *any* form
18 // | that bears insufficient indications that the modifications are
19 // | not the work of the original author(s).
21 // | This license applies to this document only, not any other software
22 // | that it may be combined with.
24 // +----------------------------------------------------------------------+
26 // | https://www.anuko.com/time_tracker/credits.htm
27 // +----------------------------------------------------------------------+
29 import('ttUserHelper');
30 import('DateAndTime');
31 import('ttInvoiceHelper');
33 // Class ttTeamHelper - contains helper functions that operate with teams.
36 // The getUserCount function returns number of people in team.
37 static function getUserCount($team_id) {
38 $mdb2 = getConnection();
40 $sql = "select count(id) as cnt from tt_users where team_id = $team_id and status = 1";
41 $res = $mdb2->query($sql);
43 if (!is_a($res, 'PEAR_Error')) {
44 $val = $res->fetchRow();
50 // The getUsersForClient obtains all active and inactive users in a team that are relevant to a client.
51 static function getUsersForClient() {
53 $mdb2 = getConnection();
55 $sql = "select u.id, u.name from tt_user_project_binds upb
56 inner join tt_client_project_binds cpb on (upb.project_id = cpb.project_id and cpb.client_id = $user->client_id)
57 inner join tt_users u on (u.id = upb.user_id)
58 where (u.status = 1 or u.status = 0)
60 order by upper(u.name)";
61 $res = $mdb2->query($sql);
63 if (is_a($res, 'PEAR_Error'))
65 while ($val = $res->fetchRow()) {
71 // The getActiveUsers obtains all active users in a given team.
72 static function getActiveUsers($options = null) {
74 $mdb2 = getConnection();
76 if (isset($options['getAllFields']))
77 $sql = "select * from tt_users where team_id = $user->team_id and status = 1 order by upper(name)";
79 $sql = "select id, name from tt_users where team_id = $user->team_id and status = 1 order by upper(name)";
80 $res = $mdb2->query($sql);
82 if (is_a($res, 'PEAR_Error'))
84 while ($val = $res->fetchRow()) {
88 if (isset($options['putSelfFirst'])) {
89 // Put own entry at the front.
90 $cnt = count($user_list);
91 for($i = 0; $i < $cnt; $i++) {
92 if ($user_list[$i]['id'] == $user->id) {
93 $self = $user_list[$i]; // Found self.
94 array_unshift($user_list, $self); // Put own entry at the front.
95 array_splice($user_list, $i+1, 1); // Remove duplicate.
102 // The getUsers obtains all active and inactive (but not deleted) users in a given team.
103 static function getUsers() {
105 $mdb2 = getConnection();
107 $sql = "select id, name from tt_users where team_id = $user->team_id and (status = 1 or status = 0) order by upper(name)";
108 $res = $mdb2->query($sql);
109 $user_list = array();
110 if (is_a($res, 'PEAR_Error'))
112 while ($val = $res->fetchRow()) {
119 // The getInactiveUsers obtains all inactive users in a given team.
120 static function getInactiveUsers($team_id, $all_fields = false) {
121 $mdb2 = getConnection();
124 $sql = "select * from tt_users where team_id = $team_id and status = 0 order by upper(name)";
126 $sql = "select id, name from tt_users where team_id = $team_id and status = 0 order by upper(name)";
127 $res = $mdb2->query($sql);
129 if (!is_a($res, 'PEAR_Error')) {
130 while ($val = $res->fetchRow()) {
138 // The getAllUsers obtains all users in a given team.
139 static function getAllUsers($team_id, $all_fields = false) {
140 $mdb2 = getConnection();
143 $sql = "select * from tt_users where team_id = $team_id order by upper(name)";
145 $sql = "select id, name from tt_users where team_id = $team_id order by upper(name)";
146 $res = $mdb2->query($sql);
148 if (!is_a($res, 'PEAR_Error')) {
149 while ($val = $res->fetchRow()) {
157 // getActiveProjects - returns an array of active projects for team.
158 static function getActiveProjects($team_id)
161 $mdb2 = getConnection();
163 $sql = "select id, name, description, tasks from tt_projects
164 where team_id = $team_id and status = 1 order by upper(name)";
165 $res = $mdb2->query($sql);
167 if (!is_a($res, 'PEAR_Error')) {
168 while ($val = $res->fetchRow()) {
175 // getInactiveProjects - returns an array of inactive projects for team.
176 static function getInactiveProjects($team_id)
179 $mdb2 = getConnection();
181 $sql = "select id, name, description, tasks from tt_projects
182 where team_id = $team_id and status = 0 order by upper(name)";
183 $res = $mdb2->query($sql);
185 if (!is_a($res, 'PEAR_Error')) {
186 while ($val = $res->fetchRow()) {
193 // The getAllProjects obtains all projects in a given team.
194 static function getAllProjects($team_id, $all_fields = false) {
195 $mdb2 = getConnection();
198 $sql = "select * from tt_projects where team_id = $team_id order by status, upper(name)";
200 $sql = "select id, name from tt_projects where team_id = $team_id order by status, upper(name)";
201 $res = $mdb2->query($sql);
203 if (!is_a($res, 'PEAR_Error')) {
204 while ($val = $res->fetchRow()) {
212 // getActiveTasks - returns an array of active tasks for team.
213 static function getActiveTasks($team_id)
216 $mdb2 = getConnection();
218 $sql = "select id, name, description from tt_tasks where team_id = $team_id and status = 1 order by upper(name)";
219 $res = $mdb2->query($sql);
221 if (!is_a($res, 'PEAR_Error')) {
222 while ($val = $res->fetchRow()) {
229 // getInactiveTasks - returns an array of inactive tasks for team.
230 static function getInactiveTasks($team_id)
233 $mdb2 = getConnection();
235 $sql = "select id, name, description from tt_tasks
236 where team_id = $team_id and status = 0 order by upper(name)";
237 $res = $mdb2->query($sql);
239 if (!is_a($res, 'PEAR_Error')) {
240 while ($val = $res->fetchRow()) {
247 // The getAllTasks obtains all tasks in a given team.
248 static function getAllTasks($team_id, $all_fields = false) {
249 $mdb2 = getConnection();
252 $sql = "select * from tt_tasks where team_id = $team_id order by status, upper(name)";
254 $sql = "select id, name from tt_tasks where team_id = $team_id order by status, upper(name)";
255 $res = $mdb2->query($sql);
257 if (!is_a($res, 'PEAR_Error')) {
258 while ($val = $res->fetchRow()) {
266 // The getActiveClients returns an array of active clients for team.
267 static function getActiveClients($team_id, $all_fields = false)
270 $mdb2 = getConnection();
273 $sql = "select * from tt_clients where team_id = $team_id and status = 1 order by upper(name)";
275 $sql = "select id, name from tt_clients where team_id = $team_id and status = 1 order by upper(name)";
277 $res = $mdb2->query($sql);
279 if (!is_a($res, 'PEAR_Error')) {
280 while ($val = $res->fetchRow()) {
287 // The getInactiveClients returns an array of inactive clients for team.
288 static function getInactiveClients($team_id, $all_fields = false)
291 $mdb2 = getConnection();
294 $sql = "select * from tt_clients where team_id = $team_id and status = 0 order by upper(name)";
296 $sql = "select id, name from tt_clients where team_id = $team_id and status = 0 order by upper(name)";
298 $res = $mdb2->query($sql);
300 if (!is_a($res, 'PEAR_Error')) {
301 while ($val = $res->fetchRow()) {
308 // The getAllClients obtains all clients in a given team.
309 static function getAllClients($team_id, $all_fields = false) {
310 $mdb2 = getConnection();
313 $sql = "select * from tt_clients where team_id = $team_id order by status, upper(name)";
315 $sql = "select id, name from tt_clients where team_id = $team_id order by status, upper(name)";
317 $res = $mdb2->query($sql);
319 if (!is_a($res, 'PEAR_Error')) {
320 while ($val = $res->fetchRow()) {
328 // The getActiveInvoices returns an array of active invoices for team.
329 static function getActiveInvoices($localizeDates = true)
332 $addPaidStatus = $user->isPluginEnabled('ps');
335 $mdb2 = getConnection();
337 if (ROLE_CLIENT == $user->role && $user->client_id)
338 $client_part = " and i.client_id = $user->client_id";
340 $sql = "select i.id, i.name, i.date, i.client_id, i.status, c.name as client_name from tt_invoices i
341 left join tt_clients c on (c.id = i.client_id)
342 where i.status = 1 and i.team_id = $user->team_id $client_part order by i.name";
343 $res = $mdb2->query($sql);
345 if (!is_a($res, 'PEAR_Error')) {
346 $dt = new DateAndTime(DB_DATEFORMAT);
347 while ($val = $res->fetchRow()) {
348 if ($localizeDates) {
349 $dt->parseVal($val['date']);
350 $val['date'] = $dt->toString($user->date_format);
353 $val['paid'] = ttInvoiceHelper::isPaid($val['id']);
360 // The getAllInvoices returns an array of all invoices for team.
361 static function getAllInvoices()
366 $mdb2 = getConnection();
368 $sql = "select * from tt_invoices where team_id = $user->team_id";
369 $res = $mdb2->query($sql);
371 if (!is_a($res, 'PEAR_Error')) {
372 $dt = new DateAndTime(DB_DATEFORMAT);
373 while ($val = $res->fetchRow()) {
380 // The getRecentInvoices returns an array of recent invoices (max 3) for a client.
381 static function getRecentInvoices($team_id, $client_id)
386 $mdb2 = getConnection();
388 $sql = "select i.id, i.name from tt_invoices i
389 left join tt_clients c on (c.id = i.client_id)
390 where i.team_id = $team_id and i.status = 1 and c.id = $client_id
391 order by i.id desc limit 3";
392 $res = $mdb2->query($sql);
394 if (!is_a($res, 'PEAR_Error')) {
395 $dt = new DateAndTime(DB_DATEFORMAT);
396 while ($val = $res->fetchRow()) {
403 // getUserToProjectBinds - obtains all user to project binds for a team.
404 static function getUserToProjectBinds($team_id) {
405 $mdb2 = getConnection();
408 $sql = "select * from tt_user_project_binds where user_id in (select id from tt_users where team_id = $team_id) order by user_id, status, project_id";
409 $res = $mdb2->query($sql);
411 if (!is_a($res, 'PEAR_Error')) {
412 while ($val = $res->fetchRow()) {
420 // The getAllCustomFields obtains all custom fields in a given team.
421 static function getAllCustomFields($team_id) {
422 $mdb2 = getConnection();
424 $sql = "select * from tt_custom_fields where team_id = $team_id order by status";
426 $res = $mdb2->query($sql);
428 if (!is_a($res, 'PEAR_Error')) {
429 while ($val = $res->fetchRow()) {
437 // The getAllCustomFieldOptions obtains all custom field options in a given team.
438 static function getAllCustomFieldOptions($team_id) {
439 $mdb2 = getConnection();
441 $sql = "select * from tt_custom_field_options where field_id in (select id from tt_custom_fields where team_id = $team_id) order by id";
443 $res = $mdb2->query($sql);
445 if (!is_a($res, 'PEAR_Error')) {
446 while ($val = $res->fetchRow()) {
454 // The getCustomFieldLog obtains all custom field log entries for a given team.
455 static function getCustomFieldLog($team_id) {
456 $mdb2 = getConnection();
458 $sql = "select * from tt_custom_field_log where field_id in (select id from tt_custom_fields where team_id = $team_id) order by id";
460 $res = $mdb2->query($sql);
462 if (!is_a($res, 'PEAR_Error')) {
463 while ($val = $res->fetchRow()) {
471 // getFavReports - obtains all favorite reports for all users in team.
472 static function getFavReports($team_id) {
473 $mdb2 = getConnection();
476 $sql = "select * from tt_fav_reports where user_id in (select id from tt_users where team_id = $team_id)";
477 $res = $mdb2->query($sql);
479 if (!is_a($res, 'PEAR_Error')) {
480 while ($val = $res->fetchRow()) {
488 // getRoles - obtains all roles defined for team.
489 static function getRoles($team_id) {
490 $mdb2 = getConnection();
493 $sql = "select * from tt_roles where team_id = $team_id";
494 $res = $mdb2->query($sql);
496 if (!is_a($res, 'PEAR_Error')) {
497 while ($val = $res->fetchRow()) {
505 // getExpenseItems - obtains all expense items for all users in team.
506 static function getExpenseItems($team_id) {
507 $mdb2 = getConnection();
510 $sql = "select * from tt_expense_items where user_id in (select id from tt_users where team_id = $team_id)";
511 $res = $mdb2->query($sql);
513 if (!is_a($res, 'PEAR_Error')) {
514 while ($val = $res->fetchRow()) {
522 // getPredefinedExpenses - obtains predefined expenses for team.
523 static function getPredefinedExpenses($team_id) {
525 $replaceDecimalMark = ('.' != $user->decimal_mark);
527 $mdb2 = getConnection();
530 $sql = "select id, name, cost from tt_predefined_expenses where team_id = $team_id";
531 $res = $mdb2->query($sql);
533 if (!is_a($res, 'PEAR_Error')) {
534 while ($val = $res->fetchRow()) {
535 if ($replaceDecimalMark)
536 $val['cost'] = str_replace('.', $user->decimal_mark, $val['cost']);
544 // getNotifications - obtains notification descriptions for team.
545 static function getNotifications($team_id) {
546 $mdb2 = getConnection();
549 $sql = "select c.id, c.cron_spec, c.email, c.report_condition, fr.name from tt_cron c
550 left join tt_fav_reports fr on (fr.id = c.report_id)
551 where c.team_id = $team_id and c.status = 1 and fr.status = 1";
552 $res = $mdb2->query($sql);
554 if (!is_a($res, 'PEAR_Error')) {
555 while ($val = $res->fetchRow()) {
563 // getMonthlyQuotas - obtains monthly quotas for team.
564 static function getMonthlyQuotas($team_id) {
565 $mdb2 = getConnection();
568 $sql = "select year, month, minutes from tt_monthly_quotas where team_id = $team_id";
569 $res = $mdb2->query($sql);
571 if (!is_a($res, 'PEAR_Error')) {
572 while ($val = $res->fetchRow()) {
580 // The getTeams function returns an array of all active teams on the server.
581 static function getTeams() {
583 $mdb2 = getConnection();
585 $sql = "select id, name, lang, timestamp from tt_teams where status = 1 order by id desc";
586 $res = $mdb2->query($sql);
588 if (!is_a($res, 'PEAR_Error')) {
589 while ($val = $res->fetchRow()) {
590 $val['date'] = substr($val['timestamp'], 0, 10); // Strip the time.
598 // The markDeleted function marks the team and everything in it as deleted.
599 static function markDeleted($team_id) {
601 // Iterate through team users and mark them as deleted.
602 $users = ttTeamHelper::getAllUsers($team_id);
603 foreach ($users as $one_user) {
604 if (!ttUserHelper::markDeleted($one_user['id'])) return false;
607 // Mark tasks deleted.
608 if (!ttTeamHelper::markTasksDeleted($team_id)) return false;
610 $mdb2 = getConnection();
612 // Mark projects deleted.
613 $sql = "update tt_projects set status = NULL where team_id = $team_id";
614 $affected = $mdb2->exec($sql);
615 if (is_a($affected, 'PEAR_Error')) return false;
617 // Mark clients deleted.
618 $sql = "update tt_clients set status = NULL where team_id = $team_id";
619 $affected = $mdb2->exec($sql);
620 if (is_a($affected, 'PEAR_Error')) return false;
622 // Mark custom fields deleted.
623 $sql = "update tt_custom_fields set status = NULL where team_id = $team_id";
624 $affected = $mdb2->exec($sql);
625 if (is_a($affected, 'PEAR_Error')) return false;
627 // Mark team deleted.
628 $sql = "update tt_teams set status = NULL where id = $team_id";
629 $affected = $mdb2->exec($sql);
630 if (is_a($affected, 'PEAR_Error')) return false;
635 // The getTeamDetails function returns team details.
636 static function getTeamDetails($team_id) {
638 $mdb2 = getConnection();
640 $role_manager = ROLE_MANAGER;
641 $sql = "select t.name as team_name, u.id as manager_id, u.name as manager_name, u.login as manager_login, u.email as manager_email
643 inner join tt_users u on (u.team_id = t.id and u.role = $role_manager)
644 where t.id = $team_id";
646 $res = $mdb2->query($sql);
647 if (!is_a($res, 'PEAR_Error')) {
648 $val = $res->fetchRow();
655 // The insert function creates a new team.
656 static function insert($fields) {
658 $mdb2 = getConnection();
660 // Start with team name and currency.
661 $columns = 'name, currency';
662 $values = $mdb2->quote(trim($fields['name'])).', '.$mdb2->quote(trim($fields['currency']));
664 if ($fields['decimal_mark']) {
665 $columns .= ', decimal_mark';
666 $values .= ', '.$mdb2->quote($fields['decimal_mark']);
669 $lang = $fields['lang'];
674 $columns .= ', lang';
675 $values .= ', '.$mdb2->quote($lang);
677 if ($fields['date_format'] || defined('DATE_FORMAT_DEFAULT')) {
678 $date_format = $fields['date_format'] ? $fields['date_format'] : DATE_FORMAT_DEFAULT;
679 $columns .= ', date_format';
680 $values .= ', '.$mdb2->quote($date_format);
683 if ($fields['time_format'] || defined('TIME_FORMAT_DEFAULT')) {
684 $time_format = $fields['time_format'] ? $fields['time_format'] : TIME_FORMAT_DEFAULT;
685 $columns .= ', time_format';
686 $values .= ', '.$mdb2->quote($time_format);
689 if ($fields['week_start'] || defined('WEEK_START_DEFAULT')) {
690 $week_start = $fields['week_start'] ? $fields['week_start'] : WEEK_START_DEFAULT;
691 $columns .= ', week_start';
692 $values .= ', '.(int)$week_start;
695 if ($fields['tracking_mode']) {
696 $columns .= ', tracking_mode';
697 $values .= ', '.(int)$fields['tracking_mode'];
700 if ($fields['project_required']) {
701 $columns .= ', project_required';
702 $values .= ', '.(int)$fields['project_required'];
705 if ($fields['task_required']) {
706 $columns .= ', task_required';
707 $values .= ', '.(int)$fields['task_required'];
710 if ($fields['record_type']) {
711 $columns .= ', record_type';
712 $values .= ', '.(int)$fields['record_type'];
715 if ($fields['bcc_email']) {
716 $columns .= ', bcc_email';
717 $values .= ', '.$mdb2->quote($fields['bcc_email']);
720 if ($fields['plugins']) {
721 $columns .= ', plugins';
722 $values .= ', '.$mdb2->quote($fields['plugins']);
725 if ($fields['lock_spec']) {
726 $columns .= ', lock_spec';
727 $values .= ', '.$mdb2->quote($fields['lock_spec']);
730 if ($fields['workday_minutes']) {
731 $columns .= ', workday_minutes';
732 $values .= ', '.(int)$fields['workday_minutes'];
735 if ($fields['config']) {
736 $columns .= ', config';
737 $values .= ', '.$mdb2->quote($fields['config']);
740 $sql = "insert into tt_teams ($columns) values($values)";
741 $affected = $mdb2->exec($sql);
743 if (!is_a($affected, 'PEAR_Error')) {
744 $team_id = $mdb2->lastInsertID('tt_teams', 'id');
751 // The update function updates team information.
752 static function update($team_id, $fields)
754 $mdb2 = getConnection();
755 $name_part = 'name = '.$mdb2->quote($fields['name']);
758 $decimal_mark_part = '';
759 $date_format_part = '';
760 $time_format_part = '';
761 $week_start_part = '';
762 $tracking_mode_part = '';
763 $task_required_part = ' , task_required = '.(int) $fields['task_required'];
764 $record_type_part = '';
765 $bcc_email_part = '';
768 $lock_spec_part = '';
769 $workday_minutes_part = '';
771 if (isset($fields['currency'])) $currency_part = ', currency = '.$mdb2->quote($fields['currency']);
772 if (isset($fields['lang'])) $lang_part = ', lang = '.$mdb2->quote($fields['lang']);
773 if (isset($fields['decimal_mark'])) $decimal_mark_part = ', decimal_mark = '.$mdb2->quote($fields['decimal_mark']);
774 if (isset($fields['date_format'])) $date_format_part = ', date_format = '.$mdb2->quote($fields['date_format']);
775 if (isset($fields['time_format'])) $time_format_part = ', time_format = '.$mdb2->quote($fields['time_format']);
776 if (isset($fields['week_start'])) $week_start_part = ', week_start = '.(int) $fields['week_start'];
777 if (isset($fields['tracking_mode'])) $tracking_mode_part = ', tracking_mode = '.(int) $fields['tracking_mode'];
778 if (isset($fields['record_type'])) $record_type_part = ', record_type = '.(int) $fields['record_type'];
779 if (isset($fields['bcc_email'])) $bcc_email_part = ', bcc_email = '.$mdb2->quote($fields['bcc_email']);
780 if (isset($fields['plugins'])) $plugins_part = ', plugins = '.$mdb2->quote($fields['plugins']);
781 if (isset($fields['config'])) $config_part = ', config = '.$mdb2->quote($fields['config']);
782 if (isset($fields['lock_spec'])) $lock_spec_part = ', lock_spec = '.$mdb2->quote($fields['lock_spec']);
783 if (isset($fields['workday_minutes'])) $workday_minutes_part = ', workday_minutes = '.$mdb2->quote($fields['workday_minutes']);
785 $sql = "update tt_teams set $name_part $currency_part $lang_part $decimal_mark_part
786 $date_format_part $time_format_part $week_start_part $tracking_mode_part $task_required_part $record_type_part
787 $bcc_email_part $plugins_part $config_part $lock_spec_part $workday_minutes_part where id = $team_id";
788 $affected = $mdb2->exec($sql);
789 if (is_a($affected, 'PEAR_Error')) return false;
794 // The getInactiveTeams is a maintenance function that returns an array of inactive team ids (max 100).
795 static function getInactiveTeams() {
796 $inactive_teams = array();
797 $mdb2 = getConnection();
799 // Get all team ids for teams created or modified more than 6 months ago.
800 // $ts = date('Y-m-d', strtotime('-1 year'));
801 $ts = date('Y-m-d', strtotime('-6 month'));
802 $sql = "select id from tt_teams where timestamp < '$ts' order by id";
803 $res = $mdb2->query($sql);
806 if (!is_a($res, 'PEAR_Error')) {
807 while ($val = $res->fetchRow()) {
808 $team_id = $val['id'];
809 if (ttTeamHelper::isTeamActive($team_id) == false) {
811 $inactive_teams[] = $team_id;
812 // Limit the array size for perfomance by allowing this operation on small chunks only.
813 if ($count >= 100) break;
816 return $inactive_teams;
821 // The isTeamActive determines if a team is using Time Tracker or abandoned it.
822 static function isTeamActive($team_id) {
825 $mdb2 = getConnection();
826 $sql = "select id from tt_users where team_id = $team_id";
827 $res = $mdb2->query($sql);
828 if (is_a($res, 'PEAR_Error')) die($res->getMessage());
829 while ($val = $res->fetchRow()) {
830 $users[] = $val['id'];
832 $user_list = implode(',', $users); // This is a comma-separated list of user ids.
834 return false; // No users in team.
837 $ts = date('Y-m-d', strtotime('-2 years'));
838 $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and timestamp > '$ts'";
839 $res = $mdb2->query($sql);
840 if (!is_a($res, 'PEAR_Error')) {
841 if ($val = $res->fetchRow()) {
842 $count = $val['cnt'];
847 return false; // No time entries for the last 2 years.
850 // We will consider a team inactive if it has 5 or less time entries made more than 1 year ago.
851 $count_last_year = 0;
852 $ts = date('Y-m-d', strtotime('-1 year'));
853 $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and timestamp > '$ts'";
854 $res = $mdb2->query($sql);
855 if (!is_a($res, 'PEAR_Error')) {
856 if ($val = $res->fetchRow()) {
857 $count_last_year = $val['cnt'];
859 if ($count_last_year == 0)
860 return false; // No time entries for the last year and only a few entries before that.
866 // The delete function permanently deletes all data for a team.
867 static function delete($team_id) {
868 $mdb2 = getConnection();
871 $sql = "select id from tt_users where team_id = $team_id";
872 $res = $mdb2->query($sql);
873 if (is_a($res, 'PEAR_Error')) return false;
874 while ($val = $res->fetchRow()) {
875 $user_id = $val['id'];
876 if (!ttUserHelper::delete($user_id)) return false;
880 if (!ttTeamHelper::deleteTasks($team_id)) return false;
882 // Delete client to project binds.
883 $sql = "delete from tt_client_project_binds where client_id in (select id from tt_clients where team_id = $team_id)";
884 $affected = $mdb2->exec($sql);
885 if (is_a($affected, 'PEAR_Error')) return false;
888 $sql = "delete from tt_projects where team_id = $team_id";
889 $affected = $mdb2->exec($sql);
890 if (is_a($affected, 'PEAR_Error')) return false;
893 $sql = "delete from tt_clients where team_id = $team_id";
894 $affected = $mdb2->exec($sql);
895 if (is_a($affected, 'PEAR_Error')) return false;
898 $sql = "delete from tt_invoices where team_id = $team_id";
899 $affected = $mdb2->exec($sql);
900 if (is_a($affected, 'PEAR_Error')) return false;
902 // Delete custom fields.
903 if (!ttTeamHelper::deleteCustomFields($team_id)) return false;
906 $sql = "delete from tt_roles where team_id = $team_id";
907 $affected = $mdb2->exec($sql);
908 if (is_a($affected, 'PEAR_Error')) return false;
911 $sql = "delete from tt_teams where id = $team_id";
912 $affected = $mdb2->exec($sql);
913 if (is_a($affected, 'PEAR_Error')) return false;
918 // The markTasksDeleted deletes task binds and marks the tasks as deleted for a team.
919 static function markTasksDeleted($team_id) {
920 $mdb2 = getConnection();
921 $sql = "select id from tt_tasks where team_id = $team_id";
922 $res = $mdb2->query($sql);
923 if (is_a($res, 'PEAR_Error')) return false;
925 while ($val = $res->fetchRow()) {
927 // Delete task binds.
928 $task_id = $val['id'];
929 $sql = "delete from tt_project_task_binds where task_id = $task_id";
930 $affected = $mdb2->exec($sql);
931 if (is_a($affected, 'PEAR_Error')) return false;
933 // Mark task as deleted.
934 $sql = "update tt_tasks set status = NULL where id = $task_id";
935 $affected = $mdb2->exec($sql);
936 if (is_a($affected, 'PEAR_Error')) return false;
942 // The deleteTasks deletes all tasks and task binds for an inactive team.
943 static function deleteTasks($team_id) {
944 $mdb2 = getConnection();
945 $sql = "select id from tt_tasks where team_id = $team_id";
946 $res = $mdb2->query($sql);
947 if (is_a($res, 'PEAR_Error')) return false;
949 while ($val = $res->fetchRow()) {
951 // Delete task binds.
952 $task_id = $val['id'];
953 $sql = "delete from tt_project_task_binds where task_id = $task_id";
954 $affected = $mdb2->exec($sql);
955 if (is_a($affected, 'PEAR_Error')) return false;
958 $sql = "delete from tt_tasks where id = $task_id";
959 $affected = $mdb2->exec($sql);
960 if (is_a($affected, 'PEAR_Error')) return false;
966 // The deleteCustomFields cleans up tt_custom_field_log, tt_custom_field_options and tt_custom_fields tables for an inactive team.
967 static function deleteCustomFields($team_id) {
968 $mdb2 = getConnection();
969 $sql = "select id from tt_custom_fields where team_id = $team_id";
970 $res = $mdb2->query($sql);
971 if (is_a($res, 'PEAR_Error')) return false;
973 while ($val = $res->fetchRow()) {
974 $field_id = $val['id'];
976 // Clean up tt_custom_field_log.
977 $sql = "delete from tt_custom_field_log where field_id = $field_id";
978 $affected = $mdb2->exec($sql);
979 if (is_a($affected, 'PEAR_Error')) return false;
981 // Clean up tt_custom_field_options.
982 $sql = "delete from tt_custom_field_options where field_id = $field_id";
983 $affected = $mdb2->exec($sql);
984 if (is_a($affected, 'PEAR_Error')) return false;
986 // Delete custom field.
987 $sql = "delete from tt_custom_fields where id = $field_id";
988 $affected = $mdb2->exec($sql);
989 if (is_a($affected, 'PEAR_Error')) return false;
995 // enablePlugin either enables or disables a specific plugin for team.
996 static function enablePlugin($plugin, $enable = true)
999 if (!$user->canManageTeam())
1002 $plugin_array = explode(',', $user->plugins);
1003 if ($enable && !in_array($plugin, $plugin_array))
1004 $plugin_array[] = $plugin; // Add plugin to array.
1006 if (!$enable && in_array($plugin, $plugin_array)) {
1007 $key = array_search($plugin, $plugin_array);
1009 unset($plugin_array[$key]); // Remove plugin from array.
1012 $plugins = implode(',', $plugin_array);
1013 if ($plugins != $user->plugins) {
1014 if (!ttTeamHelper::update($user->team_id, array('name' => $user->team,'plugins' => $plugins)))
1016 $user->plugins = $plugins;