- // Prepare sql query part for where.
- if ($bean->getAttribute('period'))
- $period = new Period($bean->getAttribute('period'), new DateAndTime($user->date_format));
- else {
- $period = new Period();
- $period->setPeriod(
- new DateAndTime($user->date_format, $bean->getAttribute('start_date')),
- new DateAndTime($user->date_format, $bean->getAttribute('end_date')));
- }
- $where = " where l.status = 1 and l.date >= '".$period->getStartDate(DB_DATEFORMAT)."' and l.date <= '".$period->getEndDate(DB_DATEFORMAT)."'".
- " $user_list_part $dropdown_parts";
- return $where;
- }
-
- // getFavWhere prepares a WHERE clause for a favorite report query.
- static function getFavWhere($report) {
- global $user;
-
- // Prepare dropdown parts.
- $dropdown_parts = '';
- if ($report['client_id'])
- $dropdown_parts .= ' and l.client_id = '.$report['client_id'];
- elseif ($user->isClient() && $user->client_id)
- $dropdown_parts .= ' and l.client_id = '.$user->client_id;
- if ($report['cf_1_option_id']) $dropdown_parts .= ' and l.id in(select log_id from tt_custom_field_log where status = 1 and option_id = '.$report['cf_1_option_id'].')';
- if ($report['project_id']) $dropdown_parts .= ' and l.project_id = '.$report['project_id'];
- if ($report['task_id']) $dropdown_parts .= ' and l.task_id = '.$report['task_id'];
- if ($report['billable']=='1') $dropdown_parts .= ' and l.billable = 1';
- if ($report['billable']=='2') $dropdown_parts .= ' and l.billable = 0';
- if ($report['invoice']=='1') $dropdown_parts .= ' and l.invoice_id is not NULL';
- if ($report['invoice']=='2') $dropdown_parts .= ' and l.invoice_id is NULL';
- if ($report['paid_status']=='1') $dropdown_parts .= ' and l.paid = 1';
- if ($report['paid_status']=='2') $dropdown_parts .= ' and l.paid = 0';
-
- // Prepare user list part.
- $userlist = -1;
- if (($user->can('view_reports') || $user->isClient())) {
- if ($report['users'])
- $userlist = $report['users'];
- else {
- $active_users = ttTeamHelper::getActiveUsers();
- foreach ($active_users as $single_user)
- $users[] = $single_user['id'];
- $userlist = join(',', $users);
- }
- }