$actstr = utf8_decode($langfile["opened"]); } elseif ($logged["action"] == 5) { $actstr = utf8_decode($langfile["closed"]); } elseif ($logged["action"] == 6) { $actstr = utf8_decode($langfile["assigned"]); } $obstr = $logged["name"]; $obstr = utf8_decode($obstr); $obstr = substr($obstr, 0, 75); $data = array($icon, $obstr, $actstr, $logged["datum"], $logged["username"]); $excel->writeLine($data); } } $excel->close(); $loc = $url . "files/" . CL_CONFIG . "/ics/project-$id-log.xls"; header("Location: $loc"); } elseif ($action == "showproject") { if (!chkproject($userid, $id)) { $errtxt = $langfile["notyourproject"]; $noperm = $langfile["accessdenied"]; $template->assign("errortext", "$errtxt<br>$noperm"); $template->assign("mode", "error"); $template->display("error.tpl"); die(); } if (getArrayVal($_COOKIE, "milehead")) { $milestyle = "display:" . $_COOKIE['milehead']; $template->assign("milestyle", $milestyle);
$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); $col++; } $row++; } $workbook->close(); if (set_magic_quotes_runtime(1) == false) { die("Set Magic Quote Runtime Failed."); } exit;