Example #1
0
			<td>$logged[username]</td>
			</tr>";
        }
    }
    $htmltable .= "</table>";
    $pdf->writeHTML($htmltable, true, 0, true, 0);
    $pdf->lastPage();
    $pdf->Output("project-$id-log.pdf", "D");
} elseif ($action == "projectlogxls") {
    if (!$userpermissions["admin"]["add"]) {
        $template->assign("errortext", "Permission denied.");
        $template->display("error.tpl");
        die();
    }

    $excel = new xls(CL_ROOT . "/files/" . CL_CONFIG . "/ics/project-$id-log.xls");

    $headline = array(" ", $strtext, $straction, $strdate, $struser);
    $excel->writeHeadLine($headline, "128");

    $thelog = new mylog();
    $datlog = array();
    $tlog = $thelog->getProjectLog($id, 100000);
    $tlog = $thelog->formatdate($tlog, "d.m.y");
    if (!empty($tlog)) {
        foreach($tlog as $logged) {
            if ($logged["type"] == "datei") {
                $logged["type"] = "file";
            } elseif ($logged["type"] == "projekt") {
                $logged["type"] = "project";
            } elseif ($logged["type"] == "track") {
Example #2
0
<?php

require_once ABSPATH . "includes/excel-2.0/Writer.php";
require_once ABSPATH . "includes/xls.php";
$workbook = new xls();
$workbook->send('sample_report.xls');
$worksheet =& $workbook->addWorksheet("sample_report");
$format_title =& $workbook->addFormat(array('Align' => 'center', 'Bold' => '1', 'Size' => '10'));
$format_title_field =& $workbook->addFormat(array('Align' => 'center', 'Bold' => '1', 'Border' => '0', 'Size' => '8'));
$format_text =& $workbook->addFormat(array('Border' => '0', 'Size' => '8'));
$worksheet->setLandscape();
$worksheet->setPaper(1);
$workbook->writeMerge($worksheet, 1, 0, 5, 1, 'Sample Report', $format_title);
$col = 0;
$row = 2;
$cols = array(array('name' => 'Jenis', 'width' => 20), array('name' => 'Tanggal', 'width' => 20), array('name' => 'Perihal', 'width' => 70), array('name' => 'Kode', 'width' => 40), array('name' => 'Tahun', 'width' => 20));
foreach ($cols as $field) {
    $worksheet->writeString($row, $col, $field['name'], $format_title_field);
    //$worksheet->setColumn($row, $col,$field['width']+0);
    //$format_title_field->setTextWrap();
    $col++;
}
$row++;
$data = array();
while ($rowx = $rs->FetchNextObject()) {
    $data[] = array($rowx->JENIS, formatDate2($rowx->TANGGAL), $rowx->PERIHAL, $rowx->KODE, $rowx->TAHUN);
}
foreach ($data as $r) {
    $col = 0;
    foreach ($r as $c) {
        $worksheet->writeString($row, $col, $c, $format_text);
			<td width=\"130\" align=\"center\">$tra[daystring] / $tra[startstring] - $tra[endstring]</td>
			<td width=\"40\" align=\"right\">$hrs</td>
			</tr>";
        }

        $totaltime = $tracker->getTotalTrackTime($track);
        $totaltime = str_replace(".", ",", $totaltime);

        $htmltable .= "<tr style=\"font-weight:bold;\"><td colspan=\"5\" align=\"right\">$totaltime</td></tr></table>";

        $pdf->writeHTML($htmltable, true, 0, true, 0);
        $pdf->Output("project-$id-timetable.pdf", "D");
    }
} elseif ($action == "userxls")
{
    $excel = new xls(CL_ROOT . "/files/" . CL_CONFIG . "/ics/user-$id-timetrack.xls");

    $line = array($strproj, $strtask, $strcomment, $strday, $strstarted, $strended, $strhours);
    $excel->writeHeadLine($line, "128");
    if (!empty($start) and !empty($end))
    {
        $track = $tracker->getUserTrack($id, $fproject, $taski, $start, $end);
    }
    else
    {
        $track = $tracker->getUserTrack($id, $fproject, $taski, 0, 0 , 1000);
    }
    if (!empty($track))
    {
        foreach($track as $tra)
        {
Example #4
0
File: xls.php Project: rigidus/ea
 function create($filename)
 {
     self::$filename = $filename . '.xls';
     self::$file = self::__BOF();
     self::$row = 0;
 }