isPluginEnabled('cf')) {
require_once('plugins/CustomFields.class.php');
$custom_fields = new CustomFields($user->team_id);
}
// Report settings are stored in session bean before we get here.
$bean = new ActionForm('reportBean', new Form('reportForm'), $request);
// There are 2 variations of report: totals only, or normal. Totals only means that the report
// 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.
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.
// Assign variables that are used to print subtotals.
if ($items && 'no_grouping' != $group_by) {
$print_subtotals = true;
$first_pass = true;
$prev_grouped_by = '';
$cur_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'];
// Start preparing HTML to build PDF from.
$styleHeader = 'style="background-color:#a6ccf7;"';
$styleSubtotal = 'style="background-color:#e0e0e0;"';
$styleCentered = 'style="text-align:center;"';
$styleRightAligned = 'style="text-align:right;"';
$title = $i18n->getKey('title.report').": ".$totals['start_date']." - ".$totals['end_date'];
$html = ''.$title.'
';
$html .= '';
if ($totals_only) {
// We are building a "totals only" report with only subtotals and total.
$colspan = 1; // Column span for an empty row.
// Table header.
$html .= '';
$html .= "";
$html .= '| '.htmlspecialchars($group_by_header).' | ';
if ($bean->getAttribute('chduration')) { $colspan++; $html .= "".$i18n->getKey('label.duration').' | '; }
if ($bean->getAttribute('chcost')) { $colspan++; $html .= "".$i18n->getKey('label.cost').' | '; }
$html .= '
';
$html .= '';
// Print subtotals.
foreach ($subtotals as $subtotal) {
$html .= '';
$html .= '| '.htmlspecialchars($subtotal['name']).' | ';
if ($bean->getAttribute('chduration')) $html .= "".$subtotal['time'].' | ';
if ($bean->getAttribute('chcost')) {
$html .= "";
if ($user->canManageTeam() || $user->isClient())
$html .= $subtotal['cost'];
else
$html .= $subtotal['expenses'];
$html .= ' | ';
}
$html .= '
';
}
// Print totals.
$html .= '| |
';
$html .= "";
$html .= '| '.$i18n->getKey('label.total').' | ';
if ($bean->getAttribute('chduration')) $html .= "".$totals['time'].' | ';
if ($bean->getAttribute('chcost')) {
$html .= "";
$html .= htmlspecialchars($user->currency).' ';
if ($user->canManageTeam() || $user->isClient())
$html .= $totals['cost'];
else
$html .= $totals['expenses'];
$html .= ' | ';
}
$html .= '
';
$html .= '
';
} else {
// We are building a normal report with items, optionally grouped with subtotals, and total.
$colspan = 1; // Column span for an empty row.
// Table header.
$html .= '';
$html .= "";
$html .= '| '.$i18n->getKey('label.date').' | ';
if ($user->canManageTeam() || $user->isClient()) { $colspan++; $html .= ''.$i18n->getKey('label.user').' | '; }
if ($bean->getAttribute('chclient')) { $colspan++; $html .= ''.$i18n->getKey('label.client').' | '; }
if ($bean->getAttribute('chproject')) { $colspan++; $html .= ''.$i18n->getKey('label.project').' | '; }
if ($bean->getAttribute('chtask')) { $colspan++; $html .= ''.$i18n->getKey('label.task').' | '; }
if ($bean->getAttribute('chcf_1')) { $colspan++; $html .= ''.htmlspecialchars($custom_fields->fields[0]['label']).' | '; }
if ($bean->getAttribute('chstart')) { $colspan++; $html .= "".$i18n->getKey('label.start').' | '; }
if ($bean->getAttribute('chfinish')) { $colspan++; $html .= "".$i18n->getKey('label.finish').' | '; }
if ($bean->getAttribute('chduration')) { $colspan++; $html .= "".$i18n->getKey('label.duration').' | '; }
if ($bean->getAttribute('chnote')) { $colspan++; $html .= ''.$i18n->getKey('label.note').' | '; }
if ($bean->getAttribute('chcost')) { $colspan++; $html .= "".$i18n->getKey('label.cost').' | '; }
if ($bean->getAttribute('chinvoice')) { $colspan++; $html .= ''.$i18n->getKey('label.invoice').' | '; }
$html .= '
';
$html .= '';
foreach ($items as $item) {
// Print a subtotal for a block of grouped values.
$cur_date = $item['date'];
if ($print_subtotals) {
$cur_grouped_by = $item['grouped_by'];
if ($cur_grouped_by != $prev_grouped_by && !$first_pass) {
$html .= '';
$html .= '| '.$i18n->getKey('label.subtotal').' | ';
if ($user->canManageTeam() || $user->isClient()) {
$html .= '';
if ($group_by == 'user') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chclient')) {
$html .= '';
if ($group_by == 'client') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chproject')) {
$html .= '';
if ($group_by == 'project') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chtask')) {
$html .= '';
if ($group_by == 'task') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chcf_1')) {
$html .= '';
if ($group_by == 'cf_1') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chstart')) $html .= ' | ';
if ($bean->getAttribute('chfinish')) $html .= ' | ';
if ($bean->getAttribute('chduration')) $html .= "".$subtotals[$prev_grouped_by]['time'].' | ';
if ($bean->getAttribute('chnote')) $html .= ' | ';
if ($bean->getAttribute('chcost')) {
$html .= "";
if ($user->canManageTeam() || $user->isClient())
$html .= $subtotals[$prev_grouped_by]['cost'];
else
$html .= $subtotals[$prev_grouped_by]['expenses'];
$html .= ' | ';
}
if ($bean->getAttribute('chinvoice')) $html .= ' | ';
$html .= '
';
$html .= '| |
';
}
$first_pass = false;
}
// Print a regular row.
$html .= '';
$html .= '| '.$item['date'].' | ';
if ($user->canManageTeam() || $user->isClient()) $html .= ''.htmlspecialchars($item['user']).' | ';
if ($bean->getAttribute('chclient')) $html .= ''.htmlspecialchars($item['client']).' | ';
if ($bean->getAttribute('chproject')) $html .= ''.htmlspecialchars($item['project']).' | ';
if ($bean->getAttribute('chtask')) $html .= ''.htmlspecialchars($item['task']).' | ';
if ($bean->getAttribute('chcf_1')) $html .= ''.htmlspecialchars($item['cf_1']).' | ';
if ($bean->getAttribute('chstart')) $html .= "".$item['start'].' | ';
if ($bean->getAttribute('chfinish')) $html .= "".$item['finish'].' | ';
if ($bean->getAttribute('chduration')) $html .= "".$item['duration'].' | ';
if ($bean->getAttribute('chnote')) $html .= ''.htmlspecialchars($item['note']).' | ';
if ($bean->getAttribute('chcost')) {
$html .= "";
if ($user->canManageTeam() || $user->isClient())
$html .= $item['cost'];
else
$html .= $item['expense'];
$html .= ' | ';
}
if ($bean->getAttribute('chinvoice')) $html .= ''.htmlspecialchars($item['invoice']).' | ';
$html .= '
';
$prev_date = $item['date'];
if ($print_subtotals) $prev_grouped_by = $item['grouped_by'];
}
// Print a terminating subtotal.
if ($print_subtotals) {
$html .= '';
$html .= '| '.$i18n->getKey('label.subtotal').' | ';
if ($user->canManageTeam() || $user->isClient()) {
$html .= '';
if ($group_by == 'user') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chclient')) {
$html .= '';
if ($group_by == 'client') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chproject')) {
$html .= '';
if ($group_by == 'project') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chtask')) {
$html .= '';
if ($group_by == 'task') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chcf_1')) {
$html .= '';
if ($group_by == 'cf_1') $html .= htmlspecialchars($subtotals[$prev_grouped_by]['name']);
$html .= ' | ';
}
if ($bean->getAttribute('chstart')) $html .= ' | ';
if ($bean->getAttribute('chfinish')) $html .= ' | ';
if ($bean->getAttribute('chduration')) $html .= "".$subtotals[$prev_grouped_by]['time'].' | ';
if ($bean->getAttribute('chnote')) $html .= ' | ';
if ($bean->getAttribute('chcost')) {
$html .= "";
if ($user->canManageTeam() || $user->isClient())
$html .= $subtotals[$prev_grouped_by]['cost'];
else
$html .= $subtotals[$prev_grouped_by]['expenses'];
$html .= ' | ';
}
if ($bean->getAttribute('chinvoice')) $html .= ' | ';
$html .= '
';
}
// Print totals.
$html .= '| |
';
$html .= '';
$html .= '| '.$i18n->getKey('label.total').' | ';
if ($user->canManageTeam() || $user->isClient()) $html .= ' | ';
if ($bean->getAttribute('chclient')) $html .= ' | ';
if ($bean->getAttribute('chproject')) $html .= ' | ';
if ($bean->getAttribute('chtask')) $html .= ' | ';
if ($bean->getAttribute('chcf_1')) $html .= ' | ';
if ($bean->getAttribute('chstart')) $html .= ' | ';
if ($bean->getAttribute('chfinish')) $html .= ' | ';
if ($bean->getAttribute('chduration')) $html .= "".$totals['time'].' | ';
if ($bean->getAttribute('chnote')) $html .= ' | ';
if ($bean->getAttribute('chcost')) {
$html .= "".htmlspecialchars($user->currency).' ';
if ($user->canManageTeam() || $user->isClient())
$html .= $totals['cost'];
else
$html .= $totals['expenses'];
$html .= ' | ';
}
if ($bean->getAttribute('chinvoice')) $html .= ' | ';
$html .= '
';
$html .= '';
}
// Output footer.
if (!defined('REPORT_FOOTER') || !(REPORT_FOOTER == false)) // By default we print it unless explicitely defined as false.
$html .= ''.$i18n->getKey('form.mail.footer').'
';
// By this time we have html ready.
// Determine title for report.
$title = $i18n->getKey('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');
header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', false);
header('Cache-Control: private', false);
header('Content-Type: application/pdf');
header('Content-Disposition: attachment; filename="'.$filename.'.pdf"');
// Beginning of TCPDF code here.
// Extend TCPDF class so that we can use custom header and footer.
class ttPDF extends TCPDF {
public $image_file = 'images/tt_logo.png'; // Image file for the logo in header.
public $page_word = 'Page'; // Localized "Page" word in footer, ex: Page 1/2.
// SetImageFile - sets image file name.
public function SetImageFile($imgFile) {
$this->image_file = $imgFile;
}
// SetPageWord - sets page word for footer.
public function SetPageWord($pageWord) {
$this->page_word = $pageWord;
}
// Page header.
public function Header() {
// Print logo, which is the only element of our custom header.
$this->Image($this->image_file, 10, 10, '', '', '', '', 'T', false, 300, 'C', false, false, 0, false, false, false);
}
// Page footer.
public function Footer() {
// Position at 15 mm from bottom.
$this->SetY(-15);
// Set font.
$this->SetFont('freeserif', 'I', 8);
// Print localized page number.
$this->Cell(0, 10, $this->page_word.' '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}
// Create new PDF document.
$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');
// Set page word for the footer.
$pdf->SetPageWord($i18n->getKey('label.page'));
// Set document information.
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Anuko Time Tracker');
$pdf->SetTitle('Anuko Time Tracker Report');
$pdf->SetSubject('Anuko Time Tracker Report');
$pdf->SetKeywords('Anuko, time, tracker, report');
// Set margins.
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// Set auto page breaks.
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// Set image scale factor.
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// Add a page.
$pdf->AddPage();
// Set font (freeserif seems to work for all languages).
$pdf->SetFont('freeserif', '', 10); // helvetica here does not work for Russian.
// Write HTML.
$pdf->writeHTML($html, true, false, false, false, '');
// Close and output PDF document.
// $pdf->Output('timesheet.pdf', 'I'); // This will display inline in browser.
$pdf->Output($filename.'.pdf', 'D'); // D is for downloads.
// End of of TCPDF code.