</td>
             <td align="center">
                 <?php 
     $diff_total = (int) ($totalBudget * $factor - $totalCost);
     echo $diff_total < 0 ? '<span style="color: red;">' : '';
     echo $w2Pconfig['currency_symbol'] . $diff_total;
     echo $diff_total < 0 ? '</span>' : '';
     ?>
             </td>
         </tr><?php 
     $pdfdata[] = array(sprintf('%.1f%%', $project->project_percent_complete), '  ' . $projectName, $contactName, $AppUI->formatTZAwareTime($project->project_start_date, $df), $AppUI->formatTZAwareTime($criticalTasks[0]['task_end_date'], $df), $targetBudget, $actualCost, $w2Pconfig['currency_symbol'] . $diff_total);
 }
 if ($log_pdf) {
     // make the PDF file
     $temp_dir = W2P_BASE_DIR . '/files/temp';
     $output = new w2p_Output_PDFRenderer('A4', 'landscape');
     $output->addTitle($AppUI->_('Costs By Project'));
     $output->addDate($df);
     $output->addSubtitle($companies[$company_id]);
     $pdfheaders = array($AppUI->_('Work', UI_OUTPUT_JS), '  ' . $AppUI->_('Project Name', UI_OUTPUT_JS), $AppUI->_('Project Owner', UI_OUTPUT_JS), $AppUI->_('Start Date', UI_OUTPUT_JS), $AppUI->_('Finish Date', UI_OUTPUT_JS), $AppUI->_('Target Budget', UI_OUTPUT_JS), $AppUI->_('Actual Cost', UI_OUTPUT_JS), $AppUI->_('Difference', UI_OUTPUT_JS));
     $options = array('showLines' => 1, 'fontSize' => 9, 'rowGap' => 1, 'colGap' => 1, 'xPos' => 50, 'xOrientation' => 'right', 'width' => '500', 'cols' => array(0 => array('justification' => 'center', 'width' => 45), 1 => array('justification' => 'left', 'width' => 175), 2 => array('justification' => 'center', 'width' => 75), 3 => array('justification' => 'center', 'width' => 65), 4 => array('justification' => 'center', 'width' => 65), 5 => array('justification' => 'center', 'width' => 65), 6 => array('justification' => 'center', 'width' => 65), 7 => array('justification' => 'center', 'width' => 65)));
     $output->addTable($title, $pdfheaders, $pdfdata, $options);
     $w2pReport = new CReport();
     if ($output->writeFile($w2pReport->getFilename())) {
         echo '<tr><td colspan="13">';
         echo '<a href="' . W2P_BASE_URL . '/files/temp/' . $w2pReport->getFilename() . '.pdf" target="pdf">';
         echo $AppUI->_('View PDF File');
         echo '</a>';
         echo '</td></tr>';
     } else {
         echo '<tr><td colspan="13">';
Exemple #2
0
}
$forum = new CForum();
$forum->load($forum_id);
$project = new CProject();
$project->load($forum->forum_project);
$messages = $forum->getMessages(null, $forum_id, $message_id, $sort);
// get the prefered date format
$df = $AppUI->getPref('SHDATEFORMAT');
$df .= ' ' . $AppUI->getPref('TIMEFORMAT');
$pdfdata = array();
$pdfhead = array('Date', 'User', 'Message');
foreach ($messages as $row) {
    // Find the parent message - the topic.
    if ($row['message_id'] == $message_id) {
        $topic = $row['message_title'];
    }
    $date = new w2p_Utilities_Date($AppUI->formatTZAwareTime($row['message_date'], '%Y-%m-%d %T'));
    $pdfdata[] = array($date->format($df), $row['contact_display_name'], '<b>' . $row['message_title'] . '</b>' . "\n" . $row['message_body']);
}
$font_dir = W2P_BASE_DIR . '/lib/ezpdf/fonts';
$temp_dir = W2P_BASE_DIR . '/files/temp';
$output = new w2p_Output_PDFRenderer();
$pdf = $output->getPDF();
$pdf->selectFont($font_dir . '/Helvetica.afm');
$pdf->ezText('Project: ' . $project->project_name);
$pdf->ezText('Forum: ' . $forum->forum_name);
$pdf->ezText('Topic: ' . $topic);
$pdf->ezText('');
$options = array('showLines' => 1, 'showHeadings' => 1, 'fontSize' => 8, 'rowGap' => 2, 'colGap' => 5, 'xPos' => 35, 'xOrientation' => 'right', 'width' => '400', 'cols' => array(0 => array('justification' => 'left', 'width' => 75), 1 => array('justification' => 'left', 'width' => 100), 2 => array('justification' => 'left', 'width' => 350)));
$pdf->ezTable($pdfdata, $pdfhead, null, $options);
$pdf->ezStream(array('Content-Disposition' => 'forum-thread-' . $forum_id . '.pdf'));
Exemple #3
0
     }
 } else {
     $q->addTable('companies');
     $q->addQuery('company_id');
     foreach ($q->loadColumn() as $company) {
         $total += showcompany($company, true);
     }
 }
 echo '<h2>' . $AppUI->_('Total Hours') . ': ';
 printf("%.2f", $total);
 echo '</h2>';
 $pdfdata[] = array($AppUI->_('Total Hours'), round($total, 2));
 if ($log_pdf) {
     // make the PDF file
     $temp_dir = W2P_BASE_DIR . '/files/temp';
     $output = new w2p_Output_PDFRenderer();
     $output->addTitle($AppUI->_('Overall Report'));
     $output->addDate($df);
     if ($log_all) {
         $date = new w2p_Utilities_Date();
         $title = "All hours as of " . $date->format($df);
     } else {
         $sdate = new w2p_Utilities_Date($log_start_date);
         $edate = new w2p_Utilities_Date($log_end_date);
         $title = "Hours from " . $sdate->format($df) . ' to ' . $edate->format($df);
     }
     foreach ($allpdfdata as $company => $data) {
         $title = $company;
         $options = array('showLines' => 1, 'showHeadings' => 0, 'fontSize' => 8, 'rowGap' => 2, 'colGap' => 5, 'xPos' => 50, 'xOrientation' => 'right', 'width' => '500', 'cols' => array(0 => array('justification' => 'left', 'width' => 250), 1 => array('justification' => 'right', 'width' => 120)));
         $output->addTable($title, null, $data, $options);
     }
Exemple #4
0
         } else {
             $start_date = new w2p_Utilities_Date($task['task_start_date']);
             $end_date = new w2p_Utilities_Date($task['task_end_date']);
             $spacer = str_repeat('  ', $task['depth']);
             $pdfdata[] = array($spacer . $task['task_name'], $task['task_description'], implode($users, ', '), $start_date != ' ' ? $start_date->format($df) : ' ', $end_date != ' ' ? $end_date->format($df) : ' ', $task['task_percent_complete'] . '%');
         }
     }
 }
 echo '</table>';
 if ($log_pdf) {
     // make the PDF file
     $project = new CProject();
     $project->load((int) $project_id);
     $pname = $project->project_name;
     $temp_dir = W2P_BASE_DIR . '/files/temp';
     $output = new w2p_Output_PDFRenderer('A4', 'landscape');
     $output->addTitle($AppUI->_('Project Task Report'));
     $output->addDate($df);
     $output->addSubtitle(w2PgetConfig('company_name'));
     if ($project_id != 0) {
         $output->addSubtitle($pname);
     }
     $subhead = '';
     if ($log_all) {
         $title = $AppUI->_('All task entries');
     } else {
         if ($end_date != ' ') {
             $title = $AppUI->_('Task entries from') . ' ' . $start_date->format($df) . $AppUI->_('to') . ' ' . $end_date->format($df);
         } else {
             $title = $AppUI->_('Task entries from') . ' ' . $start_date->format($df);
         }
Exemple #5
0
     $company->load($company_id);
     $cname = 'Company: ' . $company->company_name;
 } else {
     $cname = 'All Companies and All Projects';
 }
 if ($log_userfilter) {
     $q = new w2p_Database_Query();
     $q->addTable('contacts');
     $q->addQuery('contact_display_name');
     $q->addJoin('users', '', 'user_contact = contact_id', 'inner');
     $q->addWhere('user_id =' . (int) $log_userfilter);
     $uname = 'User: '******'All Users';
 }
 $output = new w2p_Output_PDFRenderer();
 $output->addTitle($AppUI->_('Task Log Report'));
 $output->addDate($df);
 $subtitle = $company_id ? $cname : $pname;
 $output->addSubtitle($subtitle);
 $output->addSubtitle($uname);
 if ($log_all) {
     $title = 'All Task Log entries';
 } else {
     $title = 'Task Log entries from ' . $start_date->format($df) . ' to ' . $end_date->format($df);
 }
 $pdfheaders = array($AppUI->_('Creator', UI_OUTPUT_JS), $AppUI->_('Company', UI_OUTPUT_JS), $AppUI->_('Project', UI_OUTPUT_JS), $AppUI->_('Task', UI_OUTPUT_JS), $AppUI->_('Date', UI_OUTPUT_JS), $AppUI->_('Description', UI_OUTPUT_JS), $AppUI->_('Billing Code', UI_OUTPUT_JS), $AppUI->_('Hours', UI_OUTPUT_JS));
 $options = array('showLines' => 1, 'fontSize' => 7, 'rowGap' => 1, 'colGap' => 1, 'xPos' => 50, 'xOrientation' => 'right', 'width' => '500', 'cols' => array(0 => array('justification' => 'left', 'width' => 50), 1 => array('justification' => 'left', 'width' => 60), 2 => array('justification' => 'left', 'width' => 60), 3 => array('justification' => 'left', 'width' => 60), 4 => array('justification' => 'center', 'width' => 40), 5 => array('justification' => 'left', 'width' => 170), 6 => array('justification' => 'left', 'width' => 30), 7 => array('justification' => 'right', 'width' => 30)));
 $output->addTable($title, $pdfheaders, $pdfdata, $options);
 $w2pReport = new CReport();
 if ($output->writeFile($w2pReport->getFilename())) {
    }
    $q->clear();
    $q->addQuery('a.*, b.resource_name');
    $q->addTable('resource_tasks', 'a');
    $q->addJoin('resources', 'b', 'a.resource_id = b.resource_id', 'inner');
    $q->addWhere('a.task_id IN (' . implode(',', $task_list) . ')');
    $rows = $q->loadHashList('resource_id');
    foreach ($rows as $row) {
        $resources[$row['task_id']][$row['resource_id']] = $row['resource_name'] . ' [' . $row['percent_allocated'] . '%]';
    }
    $q->clear();
}
// Build the data columns
foreach ($tasks as $task_id => $detail) {
    $row =& $pdfdata[];
    $row[] = $detail['task_name'];
    $row[] = $detail['user_username'];
    $row[] = implode("\n", $assigned_users[$task_id]);
    if ($hasResources) {
        $row[] = implode("\n", $resources[$task_id]);
    }
    $end_date = new w2p_Utilities_Date($detail['task_end_date']);
    $row[] = $end_date->format($df);
}
$output = new w2p_Output_PDFRenderer('A4', 'landscape');
$output->addTitle($AppUI->_('Project Completed Task Report'));
$output->addDate($df);
$output->addSubtitle(w2PgetConfig('company_name'));
$output->addSubtitle($pname);
$output->addTable($title, $columns, $pdfdata, $options);
$output->getStream();
             </td>
             <td align="center">
                 <?php 
     $diff_total = (int) ($task->task_target_budget * $factor - $costs['totalCosts']);
     echo $diff_total < 0 ? '<span style="color: red;">' : '';
     echo $w2Pconfig['currency_symbol'] . $diff_total;
     echo $diff_total < 0 ? '</span>' : '';
     ?>
             </td>
         </tr><?php 
     $pdfdata[] = array(sprintf('%.1f%%', $task->task_percent_complete), '  ' . $taskName, $contactName, $AppUI->formatTZAwareTime($task->task_start_date, $df), $AppUI->formatTZAwareTime($task->task_end_date, $df), $targetBudget, $actualCost, $w2Pconfig['currency_symbol'] . $diff_total);
 }
 if ($log_pdf) {
     // make the PDF file
     $temp_dir = W2P_BASE_DIR . '/files/temp';
     $output = new w2p_Output_PDFRenderer('A4', 'landscape');
     $output->addTitle($AppUI->_('Costs By Task'));
     $output->addDate($df);
     $output->addSubtitle($projectList[$project_id]['project_name']);
     $pdfheaders = array($AppUI->_('Work', UI_OUTPUT_JS), '  ' . $AppUI->_('Project Name', UI_OUTPUT_JS), $AppUI->_('Project Owner', UI_OUTPUT_JS), $AppUI->_('Start Date', UI_OUTPUT_JS), $AppUI->_('Finish Date', UI_OUTPUT_JS), $AppUI->_('Target Budget', UI_OUTPUT_JS), $AppUI->_('Actual Cost', UI_OUTPUT_JS), $AppUI->_('Difference', UI_OUTPUT_JS));
     $options = array('showLines' => 1, 'fontSize' => 9, 'rowGap' => 1, 'colGap' => 1, 'xPos' => 50, 'xOrientation' => 'right', 'width' => '500', 'cols' => array(0 => array('justification' => 'center', 'width' => 45), 1 => array('justification' => 'left', 'width' => 175), 2 => array('justification' => 'center', 'width' => 75), 3 => array('justification' => 'center', 'width' => 65), 4 => array('justification' => 'center', 'width' => 65), 5 => array('justification' => 'center', 'width' => 65), 6 => array('justification' => 'center', 'width' => 65), 7 => array('justification' => 'center', 'width' => 65)));
     $output->addTable($title, $pdfheaders, $pdfdata, $options);
     $w2pReport = new CReport();
     if ($output->writeFile($w2pReport->getFilename())) {
         echo '<tr><td colspan="13">';
         echo '<a href="' . W2P_BASE_URL . '/files/temp/' . $w2pReport->getFilename() . '.pdf" target="pdf">';
         echo $AppUI->_('View PDF File');
         echo '</a>';
         echo '</td></tr>';
     } else {
         echo '<tr><td colspan="13">';