import('form.ActionForm');
import('ttReportHelper');
-// Access check.
-if (!ttAccessAllowed('view_own_reports')) {
+// Access checks.
+if (!(ttAccessAllowed('view_own_reports') || ttAccessAllowed('view_reports') || ttAccessAllowed('view_all_reports') || ttAccessAllowed('view_client_reports'))) {
header('Location: access_denied.php');
exit();
}
+// End of access checks.
// Check whether TCPDF library is available.
if (!file_exists('WEB-INF/lib/tcpdf/'))
// Use custom fields plugin if it is enabled.
if ($user->isPluginEnabled('cf')) {
require_once('plugins/CustomFields.class.php');
- $custom_fields = new CustomFields($user->team_id);
+ $custom_fields = new CustomFields();
}
// Report settings are stored in session bean before we get here.
// is grouped by either date, user, client, project, task or cf_1 and user only needs to see subtotals by group.
$totals_only = ($bean->getAttribute('chtotalsonly') == '1');
-// Determine group by header.
-$group_by = $bean->getAttribute('group_by');
-if ('no_grouping' != $group_by) {
- if ('cf_1' == $group_by)
- $group_by_header = $custom_fields->fields[0]['label'];
- else {
- $key = 'label.'.$group_by;
- $group_by_header = $i18n->getKey($key);
- }
-}
-
// Obtain items for report.
+$options = ttReportHelper::getReportOptions($bean);
+$grouping = ttReportHelper::grouping($options);
if (!$totals_only)
- $items = ttReportHelper::getItems($bean); // Individual entries.
-if ($totals_only || 'no_grouping' != $group_by)
- $subtotals = ttReportHelper::getSubtotals($bean); // Subtotals for groups of items.
-$totals = ttReportHelper::getTotals($bean); // Totals for the entire report.
+ $items = ttReportHelper::getItems($options); // Individual entries.
+if ($totals_only || $grouping)
+ $subtotals = ttReportHelper::getSubtotals($options); // Subtotals for groups of items.
+$totals = ttReportHelper::getTotals($options); // Totals for the entire report.
// Assign variables that are used to print subtotals.
-if ($items && 'no_grouping' != $group_by) {
+if ($items && $grouping) {
$print_subtotals = true;
$first_pass = true;
$prev_grouped_by = '';
}
// Build a string to use as filename for the files being downloaded.
-$filename = strtolower($i18n->getKey('title.report')).'_'.$bean->mValues['start_date'].'_'.$bean->mValues['end_date'];
+$filename = strtolower($i18n->get('title.report')).'_'.$bean->mValues['start_date'].'_'.$bean->mValues['end_date'];
// Start preparing HTML to build PDF from.
$styleHeader = 'style="background-color:#a6ccf7;"';
$styleCentered = 'style="text-align:center;"';
$styleRightAligned = 'style="text-align:right;"';
-$title = $i18n->getKey('title.report').": ".$totals['start_date']." - ".$totals['end_date'];
+$title = $i18n->get('title.report').": ".$totals['start_date']." - ".$totals['end_date'];
$html = '<h1 style="text-align:center;">'.$title.'</h1>';
$html .= '<table border="1" cellpadding="3" cellspacing="0" width="100%">';
if ($totals_only) {
// We are building a "totals only" report with only subtotals and total.
+ $group_by_header = ttReportHelper::makeGroupByHeader($options);
$colspan = 1; // Column span for an empty row.
// Table header.
$html .= '<thead>';
$html .= "<tr $styleHeader>";
$html .= '<td>'.htmlspecialchars($group_by_header).'</td>';
- if ($bean->getAttribute('chduration')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.duration').'</td>'; }
- if ($bean->getAttribute('chcost')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.cost').'</td>'; }
+ if ($bean->getAttribute('chduration')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.duration').'</td>'; }
+ if ($bean->getAttribute('chunits')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.work_units_short').'</td>'; }
+ if ($bean->getAttribute('chcost')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.cost').'</td>'; }
$html .= '</tr>';
$html .= '</thead>';
// Print subtotals.
$html .= '<tr>';
$html .= '<td>'.htmlspecialchars($subtotal['name']).'</td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$subtotal['time'].'</td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$subtotal['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>";
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $subtotal['cost'];
else
$html .= $subtotal['expenses'];
// Print totals.
$html .= '<tr><td colspan="'.$colspan.'"> </td></tr>';
$html .= "<tr $styleSubtotal>";
- $html .= '<td>'.$i18n->getKey('label.total').'</td>';
+ $html .= '<td>'.$i18n->get('label.total').'</td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$totals['time'].'</td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$totals['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>";
$html .= htmlspecialchars($user->currency).' ';
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $totals['cost'];
else
$html .= $totals['expenses'];
// Table header.
$html .= '<thead>';
$html .= "<tr $styleHeader>";
- $html .= '<td>'.$i18n->getKey('label.date').'</td>';
- if ($user->canManageTeam() || $user->isClient()) { $colspan++; $html .= '<td>'.$i18n->getKey('label.user').'</td>'; }
- if ($bean->getAttribute('chclient')) { $colspan++; $html .= '<td>'.$i18n->getKey('label.client').'</td>'; }
- if ($bean->getAttribute('chproject')) { $colspan++; $html .= '<td>'.$i18n->getKey('label.project').'</td>'; }
- if ($bean->getAttribute('chtask')) { $colspan++; $html .= '<td>'.$i18n->getKey('label.task').'</td>'; }
+ $html .= '<td>'.$i18n->get('label.date').'</td>';
+ if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) { $colspan++; $html .= '<td>'.$i18n->get('label.user').'</td>'; }
+ if ($bean->getAttribute('chclient')) { $colspan++; $html .= '<td>'.$i18n->get('label.client').'</td>'; }
+ if ($bean->getAttribute('chproject')) { $colspan++; $html .= '<td>'.$i18n->get('label.project').'</td>'; }
+ if ($bean->getAttribute('chtask')) { $colspan++; $html .= '<td>'.$i18n->get('label.task').'</td>'; }
if ($bean->getAttribute('chcf_1')) { $colspan++; $html .= '<td>'.htmlspecialchars($custom_fields->fields[0]['label']).'</td>'; }
- if ($bean->getAttribute('chstart')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.start').'</td>'; }
- if ($bean->getAttribute('chfinish')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.finish').'</td>'; }
- if ($bean->getAttribute('chduration')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.duration').'</td>'; }
- if ($bean->getAttribute('chnote')) { $colspan++; $html .= '<td>'.$i18n->getKey('label.note').'</td>'; }
- if ($bean->getAttribute('chcost')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.cost').'</td>'; }
- if ($bean->getAttribute('chpaid')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.paid').'</td>'; }
- if ($bean->getAttribute('chip')) { $colspan++; $html .= "<td $styleCentered>".$i18n->getKey('label.ip').'</td>'; }
- if ($bean->getAttribute('chinvoice')) { $colspan++; $html .= '<td>'.$i18n->getKey('label.invoice').'</td>'; }
+ if ($bean->getAttribute('chstart')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.start').'</td>'; }
+ if ($bean->getAttribute('chfinish')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.finish').'</td>'; }
+ if ($bean->getAttribute('chduration')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.duration').'</td>'; }
+ if ($bean->getAttribute('chunits')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.work_units_short').'</td>'; }
+ if ($bean->getAttribute('chcost')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.cost').'</td>'; }
+ if ($bean->getAttribute('chapproved')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.approved').'</td>'; }
+ if ($bean->getAttribute('chpaid')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.paid').'</td>'; }
+ if ($bean->getAttribute('chip')) { $colspan++; $html .= "<td $styleCentered>".$i18n->get('label.ip').'</td>'; }
+ if ($bean->getAttribute('chinvoice')) { $colspan++; $html .= '<td>'.$i18n->get('label.invoice').'</td>'; }
+ if ($bean->getAttribute('chtimesheet')) { $colspan++; $html .= '<td>'.$i18n->get('label.timesheet').'</td>'; }
$html .= '</tr>';
$html .= '</thead>';
$cur_grouped_by = $item['grouped_by'];
if ($cur_grouped_by != $prev_grouped_by && !$first_pass) {
$html .= '<tr style="background-color:#e0e0e0;">';
- $html .= '<td>'.$i18n->getKey('label.subtotal').'</td>';
- if ($user->canManageTeam() || $user->isClient()) {
+ $html .= '<td>'.$i18n->get('label.subtotal').'</td>';
+ if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) {
$html .= '<td>';
- if ($group_by == 'user') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['user']);
$html .= '</td>';
}
if ($bean->getAttribute('chclient')) {
$html .= '<td>';
- if ($group_by == 'client') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['client']);
$html .= '</td>';
}
if ($bean->getAttribute('chproject')) {
$html .= '<td>';
- if ($group_by == 'project') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['project']);
$html .= '</td>';
}
if ($bean->getAttribute('chtask')) {
$html .= '<td>';
- if ($group_by == 'task') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['task']);
$html .= '</td>';
}
if ($bean->getAttribute('chcf_1')) {
$html .= '<td>';
- if ($group_by == 'cf_1') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['cf_1']);
$html .= '</td>';
}
if ($bean->getAttribute('chstart')) $html .= '<td></td>';
if ($bean->getAttribute('chfinish')) $html .= '<td></td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$subtotals[$prev_grouped_by]['time'].'</td>';
- if ($bean->getAttribute('chnote')) $html .= '<td></td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$subtotals[$prev_grouped_by]['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>";
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $subtotals[$prev_grouped_by]['cost'];
else
$html .= $subtotals[$prev_grouped_by]['expenses'];
$html .= '</td>';
}
+ if ($bean->getAttribute('chapproved')) $html .= '<td></td>';
if ($bean->getAttribute('chpaid')) $html .= '<td></td>';
if ($bean->getAttribute('chip')) $html .= '<td></td>';
if ($bean->getAttribute('chinvoice')) $html .= '<td></td>';
+ if ($bean->getAttribute('chtimesheet')) $html .= '<td></td>';
$html .= '</tr>';
$html .= '<tr><td colspan="'.$colspan.'"> </td></tr>';
+ // TODO: page breaks on PDF reports is a rarely used feature.
+ // Currently without configuration capability.
+ // Consider adding an option to user profile instead.
+ if (isTrue('PDF_REPORT_PAGE_BREAKS')) {
+ import('ttUserConfig');
+ $uc = new ttUserConfig();
+ $use_breaks = $uc->getValue(SYSC_PDF_REPORT_PAGE_BREAKS);
+ if ($use_breaks) $html .= '<br pagebreak="true"/>';
+ }
}
- $first_pass = false;
+ $first_pass = false;
}
// Print a regular row.
$html .= '<tr>';
$html .= '<td>'.$item['date'].'</td>';
- if ($user->canManageTeam() || $user->isClient()) $html .= '<td>'.htmlspecialchars($item['user']).'</td>';
+ if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) $html .= '<td>'.htmlspecialchars($item['user']).'</td>';
if ($bean->getAttribute('chclient')) $html .= '<td>'.htmlspecialchars($item['client']).'</td>';
if ($bean->getAttribute('chproject')) $html .= '<td>'.htmlspecialchars($item['project']).'</td>';
if ($bean->getAttribute('chtask')) $html .= '<td>'.htmlspecialchars($item['task']).'</td>';
if ($bean->getAttribute('chstart')) $html .= "<td $styleRightAligned>".$item['start'].'</td>';
if ($bean->getAttribute('chfinish')) $html .= "<td $styleRightAligned>".$item['finish'].'</td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$item['duration'].'</td>';
- if ($bean->getAttribute('chnote')) $html .= '<td>'.htmlspecialchars($item['note']).'</td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$item['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>";
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $item['cost'];
else
$html .= $item['expense'];
$html .= '</td>';
}
+ if ($bean->getAttribute('chapproved')) {
+ $html .= '<td>';
+ $html .= $item['approved'] == 1 ? $i18n->get('label.yes') : $i18n->get('label.no');
+ $html .= '</td>';
+ }
if ($bean->getAttribute('chpaid')) {
$html .= '<td>';
- $html .= $item['paid'] == 1 ? $i18n->getKey('label.yes') : $i18n->getKey('label.no');
+ $html .= $item['paid'] == 1 ? $i18n->get('label.yes') : $i18n->get('label.no');
$html .= '</td>';
}
if ($bean->getAttribute('chip')) {
$html .= '</td>';
}
if ($bean->getAttribute('chinvoice')) $html .= '<td>'.htmlspecialchars($item['invoice']).'</td>';
+ if ($bean->getAttribute('chtimesheet')) $html .= '<td>'.htmlspecialchars($item['timesheet_name']).'</td>';
$html .= '</tr>';
+ if ($bean->getAttribute('chnote') && $item['note']) {
+ $html .= '<tr>';
+ $html .= "<td $styleRightAligned>".$i18n->get('label.note').'</td>';
+ $noteSpan = $colspan-1;
+ $html .= '<td colspan="'.$noteSpan.'">'.htmlspecialchars($item['note']).'</td>';
+ $html .= '</tr>';
+ }
+
$prev_date = $item['date'];
if ($print_subtotals) $prev_grouped_by = $item['grouped_by'];
}
// Print a terminating subtotal.
if ($print_subtotals) {
$html .= '<tr style="background-color:#e0e0e0;">';
- $html .= '<td>'.$i18n->getKey('label.subtotal').'</td>';
- if ($user->canManageTeam() || $user->isClient()) {
+ $html .= '<td>'.$i18n->get('label.subtotal').'</td>';
+ if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) {
$html .= '<td>';
- if ($group_by == 'user') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['user']);
$html .= '</td>';
}
if ($bean->getAttribute('chclient')) {
$html .= '<td>';
- if ($group_by == 'client') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['client']);
$html .= '</td>';
}
if ($bean->getAttribute('chproject')) {
$html .= '<td>';
- if ($group_by == 'project') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['project']);
$html .= '</td>';
}
if ($bean->getAttribute('chtask')) {
$html .= '<td>';
- if ($group_by == 'task') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['task']);
$html .= '</td>';
}
if ($bean->getAttribute('chcf_1')) {
$html .= '<td>';
- if ($group_by == 'cf_1') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
+ $html .= htmlspecialchars($subtotals[$prev_grouped_by]['cf_1']);
$html .= '</td>';
}
if ($bean->getAttribute('chstart')) $html .= '<td></td>';
if ($bean->getAttribute('chfinish')) $html .= '<td></td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$subtotals[$prev_grouped_by]['time'].'</td>';
- if ($bean->getAttribute('chnote')) $html .= '<td></td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$subtotals[$prev_grouped_by]['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>";
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $subtotals[$prev_grouped_by]['cost'];
else
$html .= $subtotals[$prev_grouped_by]['expenses'];
$html .= '</td>';
}
+ if ($bean->getAttribute('chapproved')) $html .= '<td></td>';
if ($bean->getAttribute('chpaid')) $html .= '<td></td>';
if ($bean->getAttribute('chip')) $html .= '<td></td>';
if ($bean->getAttribute('chinvoice')) $html .= '<td></td>';
+ if ($bean->getAttribute('chtimesheet')) $html .= '<td></td>';
$html .= '</tr>';
}
// Print totals.
$html .= '<tr><td colspan="'.$colspan.'"> </td></tr>';
$html .= '<tr style="background-color:#e0e0e0;">';
- $html .= '<td>'.$i18n->getKey('label.total').'</td>';
- if ($user->canManageTeam() || $user->isClient()) $html .= '<td></td>';
+ $html .= '<td>'.$i18n->get('label.total').'</td>';
+ if ($user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()) $html .= '<td></td>';
if ($bean->getAttribute('chclient')) $html .= '<td></td>';
if ($bean->getAttribute('chproject')) $html .= '<td></td>';
if ($bean->getAttribute('chtask')) $html .= '<td></td>';
if ($bean->getAttribute('chstart')) $html .= '<td></td>';
if ($bean->getAttribute('chfinish')) $html .= '<td></td>';
if ($bean->getAttribute('chduration')) $html .= "<td $styleRightAligned>".$totals['time'].'</td>';
- if ($bean->getAttribute('chnote')) $html .= '<td></td>';
+ if ($bean->getAttribute('chunits')) $html .= "<td $styleRightAligned>".$totals['units'].'</td>';
if ($bean->getAttribute('chcost')) {
$html .= "<td $styleRightAligned>".htmlspecialchars($user->currency).' ';
- if ($user->canManageTeam() || $user->isClient())
+ if ($user->can('manage_invoices') || $user->isClient())
$html .= $totals['cost'];
else
$html .= $totals['expenses'];
$html .= '</td>';
}
+ if ($bean->getAttribute('chapproved')) $html .= '<td></td>';
if ($bean->getAttribute('chpaid')) $html .= '<td></td>';
if ($bean->getAttribute('chip')) $html .= '<td></td>';
if ($bean->getAttribute('chinvoice')) $html .= '<td></td>';
+ if ($bean->getAttribute('chtimesheet')) $html .= '<td></td>';
$html .= '</tr>';
$html .= '</table>';
}
// Output footer.
if (!defined('REPORT_FOOTER') || !(REPORT_FOOTER == false)) // By default we print it unless explicitely defined as false.
- $html .= '<p style="text-align: center;">'.$i18n->getKey('form.mail.footer').'</p>';
+ $html .= '<p style="text-align: center;">'.$i18n->get('form.mail.footer').'</p>';
// By this time we have html ready.
// Determine title for report.
-$title = $i18n->getKey('title.report').": ".$totals['start_date']." - ".$totals['end_date'];
+$title = $i18n->get('title.report').": ".$totals['start_date']." - ".$totals['end_date'];
header('Pragma: public'); // This is needed for IE8 to download files over https.
header('Content-Type: text/html; charset=utf-8');
$pdf = new ttPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// If custom logo file exists - set it.
-if (file_exists('images/'.$user->team_id.'.png'))
- $pdf->SetImageFile('images/'.$user->team_id.'.png');
+if (file_exists('images/'.$user->group_id.'.png'))
+ $pdf->SetImageFile('images/'.$user->group_id.'.png');
// Set page word for the footer.
-$pdf->SetPageWord($i18n->getKey('label.page'));
+$pdf->SetPageWord($i18n->get('label.page'));
// Set document information.
$pdf->SetCreator(PDF_CREATOR);