function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
# Bulan
$optBulan = $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
$orgData = fetchData($query);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 12;
$path = 'images/logo.jpg';
$this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(255, 255, 255);
$this->SetX(100);
$this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
$this->SetX(100);
$this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
$this->SetX(100);
$this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
$this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->SetFont('Arial', '', 8);
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['kodeorg'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(45 / 100 * $width, $height, $_SESSION['empl']['lokasitugas'], '', 0, 'L');
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['periode'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(15 / 100 * $width, $height, numToMonth($_SESSION['org']['period']['bulan'], 'I', 'long') . " " . $_SESSION['org']['period']['tahun'], 0, 0, 'L');
$this->Ln();
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['user'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(45 / 100 * $width, $height, $_SESSION['standard']['username'], '', 0, 'L');
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['tanggal'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(15 / 100 * $width, $height, date('d-m-Y H:i:s'), '', 1, 'L');
$this->Ln();
$this->SetFont('Arial', 'U', 12);
$this->Cell($width, $height, $title, 0, 1, 'C');
$this->Ln();
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(220, 220, 220);
foreach ($colArr as $key => $head) {
$this->Cell($length[$key] / 100 * $width, $height, $_SESSION['lang'][$head], 1, 0, 'C', 1);
}
$this->Ln();
}
//$t=mktime(0,0,0,substr($periodesaldo,4,2)+1,15,substr($periodesaldo,0,4));
//$periodCUR=date('Ym',$t);#periode saldoakhir bulan berjalan
//$kolomCUR="awal".date('m',$t);
#captionsekarang============================
//$t=mktime(0,0,0,substr($periodesaldo,4,2),15,$periode);
//$captionCUR=date('M-Y',$t);
#ambil format mesinlaporan==========
$str = "select * from " . $dbname . ".keu_5mesinlaporandt where namalaporan='" . $kodelaporan . "' order by nourut";
$res = mysql_query($str);
#query+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
if ($unit == '') {
$where = " kodeorg in(select kodeorganisasi from " . $dbname . ".organisasi where induk='" . $pt . "')";
} else {
$where = " kodeorg='" . $unit . "'";
}
$stream = "<table class=sortable border=0 cellspacing=1>\r\n <thead>\r\n <tr class=rowheader>\r\n <td colspan=3>" . $_SESSION['lang']['keterangan'] . "</td>\r\n <td align=center>" . numToMonth(1, 'E') . "</td>\r\n <td align=center>" . numToMonth(2, 'E') . "</td>\r\n <td align=center>" . numToMonth(3, 'E') . "</td>\r\n <td align=center>" . numToMonth(4, 'E') . "</td>\r\n <td align=center>" . numToMonth(5, 'E') . "</td>\r\n <td align=center>" . numToMonth(6, 'E') . "</td>\r\n <td align=center>" . numToMonth(7, 'E') . "</td>\r\n <td align=center>" . numToMonth(8, 'E') . "</td>\r\n <td align=center>" . numToMonth(9, 'E') . "</td>\r\n <td align=center>" . numToMonth(10, 'E') . "</td>\r\n <td align=center>" . numToMonth(11, 'E') . "</td>\r\n <td align=center>" . numToMonth(12, 'E') . "</td>\r\n <td align=center>YTD</td> \r\n </tr>\r\n </thead><tbody>";
$tnow2[] = 0;
$ttill2 = 0;
$tnow3[] = 0;
$ttill3 = 0;
while ($bar = mysql_fetch_object($res)) {
if ($bar->tipe == 'Header') {
if ($_SESSION['language'] == 'ID') {
$stream .= "<tr class=rowcontent><td colspan=16><b>" . $bar->keterangandisplay . "</b></td></tr>";
} else {
$stream .= "<tr class=rowcontent><td colspan=16><b>" . $bar->keterangandisplay1 . "</b></td></tr>";
}
} else {
#mutasi bulan berjalan
$akum = 0;
for ($i = 1; $i <= 12; $i++) {
function masterTableBlok($dbname, $table, $tot, $column = "*", $headerSetting = array(), $dataSetting = array(), $cond = array(), $fForm = array(), $printTo = null, $freezeField = null, $printShow = true, $postTo = null, $opt = array(), $listName = null)
{
#====================== Prep
if ($postTo == null) {
$postTo = 'null';
}
if ($printTo == null) {
$printTo = 'null';
}
#====================== Select Query
$query = "select ";
# Column
$colStr = "";
if (is_array($column) and $column != array()) {
for ($i = 0; $i < count($column); $i++) {
if ($i == 0) {
$query .= $column[$i];
$colStr .= $column[$i];
} else {
$query .= "," . $column[$i];
$colStr .= "," . $column[$i];
}
}
} else {
$query .= "*";
}
# From Table
$query .= " from " . $dbname . "." . $table;
# Condition
if ($cond != null) {
$condStr = "";
if (is_array($cond)) {
$condPdf = $cond['sep'] . "^^";
unset($cond['sep']);
foreach ($cond as $row) {
foreach ($row as $attr => $val) {
if ($row == end($cond)) {
$condPdf .= $attr . "**" . $val;
if (is_string($val)) {
$condStr .= $attr . "='" . $val . "'";
} else {
$condStr .= $attr . "=" . $val;
}
} else {
$condPdf .= $attr . "**" . $val . "~~";
if (is_string($val)) {
$condStr .= $attr . "='" . $val . "' OR ";
} else {
$condStr .= $attr . "=" . $val . " OR ";
}
}
}
}
} else {
$condPdf = $cond;
$condStr = $cond;
}
$query .= " where " . $condStr;
} else {
$condPdf = null;
}
#exit;
#======================= Execute Query
$res = mysql_query($query);
#======================= Extract Field Related
$j = mysql_num_fields($res);
$i = 0;
$field = array();
$fieldStr = "";
$primary = array();
$primaryStr = "";
# Get Names
while ($i < $j) {
$meta = mysql_fetch_field($res, $i);
# Get Field Name
$field[] = strtolower($meta->name);
$fieldStr .= "##" . strtolower($meta->name);
# Get Primary Key and Value
if ($meta->primary_key == '1') {
$primary[] = strtolower($meta->name);
$primaryStr .= "##" . strtolower($meta->name);
}
$i++;
}
if ($fForm == array()) {
$fForm = $field;
}
#======================= Rearrange Result and Extract Values
$result = array();
while ($bar = mysql_fetch_assoc($res)) {
$result[] = $bar;
}
#======================= Create Print
$tables = "<fieldset><legend><b>" . $_SESSION['lang']['list'] . " : ";
if (is_null($listName)) {
$tables .= $table;
} else {
$tables .= $listName;
}
$tables .= "</b></legend>";
$tables .= "<img src='images/pdf.jpg' title='PDF Format'\r\n\t style='width:20px;height:20px;cursor:pointer' onclick=\"masterPDF('" . $table . "','" . $colStr . "','" . $condPdf . "','" . $printTo . "',event)\"> ";
$tables .= "<img src='images/printer.png' title='Print Page'\r\n\t style='width:20px;height:20px;cursor:pointer' onclick='javascript:print()'>";
#======================= Create Table
# Start Table
if ($printShow) {
$tables .= "<div style='height:170px;overflow:auto'>";
}
$tables .= "<table id='masterTable' class='sortable' cellspacing='1' border='0'>";
# Create Header
$tables .= "<thead><tr class='rowheader'>";
if ($headerSetting == null) {
foreach ($field as $hName) {
$tables .= "<td>" . $_SESSION['lang'][$hName] . "</td>";
}
} else {
foreach ($headerSetting as $hSet) {
if (!isset($hSet['span'])) {
$hSet['span'] = '0';
}
if (!isset($hSet['align'])) {
$hSet['align'] = 'left';
}
$tables .= "<td colspan='" . $hSet['span'] . "' align='" . $hSet['align'] . "'>" . $hSet['name'] . "</td>";
}
}
$tables .= "<td colspan='2'>" . $_SESSION['lang']['action'] . "</td>";
$tables .= "</tr></thead>";
# Iterate Content
$tables .= "<tbody id='mTabBody'>";
$i = 0;
foreach ($result as $row) {
$tables .= "<tr id='tr_" . $i . "' class='rowcontent'>";
$tmpVal = "";
$tmpKey = "";
$j = 0;
foreach ($row as $b => $c) {
# For Tipe Tanggal
$tmpC = explode("-", $c);
if (count($tmpC) == 3) {
$c = $tmpC[2] . "-" . $tmpC[1] . "-" . $tmpC[0];
}
if (!isset($dataSetting[$b]['type'])) {
$dataSetting[$b]['type'] = 'default';
}
if (isset($opt[$fForm[$j]])) {
$theVal = $opt[$fForm[$j]][$c];
} else {
$theVal = $c;
}
$total = array();
switch ($dataSetting[$b]['type']) {
case 'numeric':
$tables .= "<td id='" . $fForm[$j] . "_" . $i . "' align='right' value='" . $c . "'>" . number_format($theVal, 0) . "</td>";
if (!isset($total[$b])) {
$total[$b] = 0;
}
$total[$b] += $theVal;
break;
case 'currency':
$tables .= "<td id='" . $fForm[$j] . "_" . $i . "' align='right' value='" . $c . "'>" . number_format($theVal, 2) . "</td>";
if (!isset($total[$b])) {
$total[$b] = 0;
}
$total[$b] += $theVal;
break;
case 'string':
$tables .= "<td id='" . $fForm[$j] . "_" . $i . "' align='left' value='" . $c . "'>" . $theVal . "</td>";
break;
case 'month':
$tables .= "<td id='" . $fForm[$j] . "_" . $i . "' align='left' value='" . $c . "'>" . numToMonth($theVal) . "</td>";
break;
default:
$tables .= "<td id='" . $fForm[$j] . "_" . $i . "' value='" . $c . "'>" . $theVal . "</td>";
break;
}
$tmpVal .= "##" . $c;
if (in_array($fForm[$j], $primary)) {
$tmpKey .= "##" . $c;
}
$j++;
}
# Edit, Delete Row
if ($freezeField != null) {
$tables .= "<td><img id='editRow" . $i . "' title='Edit' onclick=\"editRow(" . $i . ",'" . $fieldStr . "','" . $tmpVal . "','" . $freezeField . "')\"\r\n\t\t class='zImgBtn' src='images/001_45.png' /></td>";
} else {
$tables .= "<td><img id='editRow" . $i . "' title='Edit' onclick=\"editRow(" . $i . ",'" . $fieldStr . "','" . $tmpVal . "')\"\r\n\t\t class='zImgBtn' src='images/001_45.png' /></td>";
}
if ($postTo == 'null') {
$tables .= "<td><img id='delRow" . $i . "' title='Hapus' onclick=\"delRow(" . $i . ",'" . $primaryStr . "','" . $tmpKey . "',null,'" . $table . "')\"\r\n\t\t\t class='zImgBtn' src='images/delete_32.png' /></td>";
} else {
$tables .= "<td><img id='delRow" . $i . "' title='Hapus' onclick=\"delRow(" . $i . ",'" . $primaryStr . "','" . $tmpKey . "','" . $postTo . "','" . $table . "')\"\r\n\t\t\t class='zImgBtn' src='images/delete_32.png' /></td>";
}
$tables .= "</tr>";
$i++;
}
if ($tot == 1) {
$rt = count($column);
// echo"<pre>";
// print_r($column);
// echo $rt;
// echo"</pre>";
//exit();
$tables .= "<thead><tr class=rowheader>";
foreach ($column as $brsDt) {
if (empty($total[$brsDt])) {
$tables .= "<td> </td>";
} else {
$tables .= "<td align=right>" . number_format($total[$brsDt], 2) . "</td>";
}
}
$tables .= "<td colspan=2> </td>";
$tables .= "</tr></thead>";
}
$tables .= "</tbody>";
# Create Footer
$tables .= "<tfoot>";
#foreach($footer as $fName) {
# $tables .= "<td>".$hName."</td>";
#}
$tables .= "</tfoot>";
# End Table
$tables .= "</table>";
if ($printShow) {
$tables .= "</div>";
}
$tables .= "</fieldset>";
return $tables;
}
$jumlahOrg = count($dzOrg);
// echo $str;
// echo "<pre>";
// print_r($dzArr);
// echo "</pre>";
$border = 0;
if ($proses == 'excel') {
$border = 1;
$stream = "<table>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=16 style='text-align:left; font-weight:bold'>" . $_SESSION['lang']['laporanRotasiPemeliharaan'] . "</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td> </td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>";
} else {
$border = 0;
$stream = "";
}
$stream .= "<table cellspacing='1' border='" . $border . "' class='sortable'>\r\n <thead>\r\n <tr class=rowheader>\r\n <td rowspan=2 align=center>" . $_SESSION['lang']['kodekegiatan'] . "</td>\r\n <td rowspan=2 align=center>" . $_SESSION['lang']['namakegiatan'] . "</td>\r\n <td rowspan=2 align=center>" . $_SESSION['lang']['satuan'] . "</td>\r\n <td colspan=3 align=center>" . $_SESSION['lang']['blok'] . "</td>";
for ($i = 1; $i <= 12; $i++) {
$stream .= "<td colspan=3 align=center>" . numToMonth($i) . "</td>";
}
$stream .= "<td colspan=3 align=center>" . $_SESSION['lang']['semester'] . " I</td>\r\n <td colspan=3 align=center>" . $_SESSION['lang']['semester'] . " II</td>\r\n <td colspan=3 align=center>" . $_SESSION['lang']['total'] . "</td>\r\n </tr>\r\n <tr class=rowheader>\r\n <td align=center>" . $_SESSION['lang']['kode'] . "</td> \r\n <td align=center>" . $_SESSION['lang']['luas'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['tahuntanam'] . "</td>";
// tiap bulan
for ($i = 1; $i <= 12; $i++) {
$stream .= "<td align=center>" . $_SESSION['lang']['jhk'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['hasilkerjad'] . "</td>\r\n <td align=center>Output (Hasil/JHK)</td>";
}
$stream .= "<td align=center>" . $_SESSION['lang']['jhk'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['hasilkerjad'] . "</td>\r\n <td align=center>Output (Hasil/JHK)</td>\r\n <td align=center>" . $_SESSION['lang']['jhk'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['hasilkerjad'] . "</td>\r\n <td align=center>Output (Hasil/JHK)</td>\r\n <td align=center>" . $_SESSION['lang']['jhk'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['hasilkerjad'] . "</td>\r\n <td align=center>Output (Hasil/JHK)</td>\r\n </tr></thead>\r\n <tbody>";
// tiap kegiatan
if (!empty($dzKeg)) {
foreach ($dzKeg as $rKeg) {
$bariskegiatan = true;
$stream .= "<tr class=rowcontent>\r\n <td rowspan=" . $barizKeg[$rKeg] . ">" . $rKeg . "</td>\r\n <td rowspan=" . $barizKeg[$rKeg] . ">" . $kamusKeg[$rKeg]['nama'] . "</td>\r\n <td rowspan=" . $barizKeg[$rKeg] . ">" . $kamusKeg[$rKeg]['satu'] . "</td>";
// tiap blok
if (!empty($dzOrg)) {
foreach ($dzOrg as $rOrg) {
}
}
$pdf = new PDF('P', 'mm', 'A4');
$width = $pdf->w - $pdf->lMargin - $pdf->rMargin;
$height = 5;
$pdf->AddPage();
$i = "select * from " . $dbname . ".log_packinght where notransaksi='" . $notran . "' ";
$n = mysql_query($i) or die(mysql_error($conn));
$d = mysql_fetch_assoc($n);
$pdf->SetFont('Arial', '', 9);
$pdf->SetFillColor(255, 255, 255);
$pdf->Cell(200, 5, $nmOrg[$d['kodept']], 0, 1, 'C');
$pdf->Cell(200, 5, 'PACKING LIST', 0, 1, 'C');
$pdf->ln();
$thn = substr($d['tanggal'], 0, 4);
$bln = numToMonth(substr($d['tanggal'], 5, 2), 'I', 'long');
$hari = substr($d['tanggal'], 8, 2);
//echo $hari;
$isiTgl = $hari . ' ' . $bln . ' ' . $thn;
//$pdf->Ln();
$pdf->SetFont('Arial', '', 7);
$pdf->SetFillColor(255, 255, 255);
$pdf->SetX(155);
$pdf->Cell(10, $height, 'PL NO', 0, 0, 'L');
$pdf->Cell(5, $height, ':', 0, 0, 'L');
$pdf->Cell(20, $height, $d['notransaksi'], 0, 1, 'L');
$pdf->Cell(20, $height, 'NO. PETI / KOLI', 0, 0, 'L');
$pdf->Cell(5, $height, ':', 0, 0, 'L');
$pdf->Cell(20, $height, $d['keterangan'], 0, 0, 'L');
$pdf->SetX(155);
$pdf->Cell(10, $height, 'DATE', 0, 0, 'L');
$nRb= mysql_query($iRb) or die (mysql_error($conn));
while($dRb= mysql_fetch_assoc($nRb))
{
}*/
if ($proses == 'excel') {
$stream = "<table class=sortable cellspacing=1 border=1>";
} else {
$stream = "<table class=sortable cellspacing=1 >";
}
$stream .= "<thead>\r\n <tr class=rowheader>\r\n <td rowspan=2 bgcolor=#CCCCCC align=center>No</td>\r\n <td rowspan=2 bgcolor=#CCCCCC align=center>URAIAN</td>";
for ($u = 1; $u <= 12; $u++) {
if (strlen($u) < 2) {
$u = '0' . $u;
}
$stream .= "<td colspan=3 bgcolor=#CCCCCC align=center>" . strtoupper(numToMonth($u, 'I', 'short')) . "</td>";
}
$stream .= "<td colspan=4 bgcolor=#CCCCCC align=center>" . strtoupper($_SESSION['lang']['total']) . "</td>";
$stream .= "</tr>";
$stream .= "<tr>";
for ($u = 1; $u <= 13; $u++) {
$stream .= " <td align=center bgcolor=#CCCCCC>Budget</td>\r\n <td align=center bgcolor=#CCCCCC>Realisasi</td>\r\n <td align=center bgcolor=#CCCCCC>Selisih</td>";
}
$stream .= "<td align=center>%</td>";
$stream .= "</tr>";
$stream .= "</tr>";
$stream .= "</thead>";
$stream .= "<tr class=rowcontent>";
$stream .= "<td colspan=42><b>PRODUKSI</b></td>";
$stream .= "</tr>";
$stream .= "<tr class=rowcontent>";
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
require_once 'lib/fpdf.php';
$_POST['proses'] != '' ? $proses = $_POST['proses'] : ($proses = $_GET['proses']);
$_POST['jenislayanan'] != '' ? $jenislayanan = $_POST['jenislayanan'] : ($jenislayanan = $_GET['jenislayanan']);
$_POST['deskripsi'] != '' ? $deskripsi = $_POST['deskripsi'] : ($deskripsi = $_GET['deskripsi']);
$_POST['atasan'] != '' ? $atasan = $_POST['atasan'] : ($atasan = $_GET['atasan']);
$_POST['managerit'] != '' ? $managerit = $_POST['managerit'] : ($managerit = $_GET['managerit']);
$date = date('Y-m-d');
$d = substr($date, 8, 2);
$m = numToMonth(substr($date, 6, 2), $lang = 'I', $format = 'long');
$y = substr($date, 0, 4);
$tanggal = $d . " " . $m . " " . $y;
$lokasitugas = $_SESSION['empl']['lokasitugas'];
$karyawanid = $_SESSION['standard']['userid'];
$_POST['kepuasanuser'] == '' ? $kepuasanuser = $_GET['kepuasanuser'] : ($kepuasanuser = $_POST['kepuasanuser']);
$_POST['nilaikomunikasi'] == '' ? $nilaikomunikasi = $_GET['nilaikomunikasi'] : ($nilaikomunikasi = $_POST['nilaikomunikasi']);
$_POST['notransaksi'] != '' ? $notransaksi = $_POST['notransaksi'] : ($notransaksi = $_GET['notransaksi']);
$_POST['saranuser'] != '' ? $saranuser = $_POST['saranuser'] : ($saranuser = $_GET['saranuser']);
$_POST['tolak'] != '' ? $tolak = $_POST['tolak'] : ($tolak = $_GET['tolak']);
$_POST['transaksi'] != '' ? $transaksi = $_POST['transaksi'] : ($transaksi = $_GET['transaksi']);
switch ($proses) {
case 'insert':
$notransaksi = 0;
$insert = "insert into " . $dbname . ".it_request\r\n (notransaksi,kodekegiatan,deskripsi,tanggal,lokasitugas,karyawanid,atasan,managerit)\r\n values('" . $notransaksi . "','" . $jenislayanan . "','" . $deskripsi . "','" . $date . "','" . $lokasitugas . "',\r\n '" . $karyawanid . "','" . $atasan . "','" . $managerit . "')";
if (mysql_query($insert)) {
$s_ket = "select a.keterangan as ket from " . $dbname . ".it_standard a left join " . $dbname . ".it_request b\r\n on a.kodekegiatan=b.kodekegiatan where a.kodekegiatan=" . $jenislayanan . "";
$pdf->Cell(239, $height, 'Dasar Pengenaan Pajak', TBLR, 0, 'L', 1);
$pdf->Cell(150, $height, '', TBLR, 0, 'R', 1);
$pdf->Cell(150, $height, number_format($pajak, 0), TBLR, 0, 'R', 1);
$pdf->Ln();
$pdf->Cell(239, $height, 'PPN=10%xDasar Pengenaan Pajak', TBLR, 0, 'L', 1);
$pdf->Cell(150, $height, '', TBLR, 0, 'R', 1);
$pdf->Cell(150, $height, number_format($ppn, 0), TBLR, 0, 'R', 1);
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Cell(239, $height, '', 0, 0, 'L', 1);
$pdf->Cell(150, $height, '', 0, 0, 'R', 1);
$date = date('Ymd');
$pdf->Cell(150, $height, $kotattd . ", " . substr($date, 6, 2) . " " . numToMonth(substr($date, 4, 2), $lang = 'I', $format = 'long') . " " . substr($date, 0, 4), 0, 0, 'C', 1);
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Cell(239, $height, '', 0, 0, 'L', 1);
$pdf->Cell(150, $height, '', 0, 0, 'R', 1);
$pdf->Cell(150, $height, $ttd, B, 0, 'C', 1);
$pdf->Ln();
$pdf->Cell(239, $height, '', 0, 0, 'L', 1);
$pdf->Cell(150, $height, '', 0, 0, 'R', 1);
$pdf->Cell(150, $height, $jabatan, T, 0, 'C', 1);
$pdf->Output();
break;
default:
function Header()
{
global $namapt;
global $pt;
global $periode;
global $tampilunit;
global $lebarkiri;
global $lebarisi;
global $lebarkanan;
// global $captionCUR;
// $this->Cell(20,3,$namapt,'',1,'L');
// $this->Cell(20,3,"UNIT:".$tampilunit,'',1,'L');
$this->SetFont('Arial', 'B', 8);
$this->Cell(280, 10, $namapt, 0, 1, 'R');
$this->SetFont('Arial', 'B', 12);
$this->Cell(300, 3, strtoupper($_SESSION['lang']['laporanrugilabaperiodik']), 0, 1, 'C');
$this->SetFont('Arial', '', 8);
$this->Ln();
$this->Cell(230, 3, $namapt, '', 0, 'L');
// $this->Cell(150,3,' ','',0,'R');
$this->Cell(15, 3, $_SESSION['lang']['tanggal'], '', 0, 'L');
$this->Cell(2, 3, ':', '', 0, 'L');
$this->Cell(35, 3, date('d-m-Y H:i'), 0, 1, 'L');
$this->Cell(230, 3, "UNIT:" . $tampilunit, '', 0, 'L');
// $this->Cell(150,3,' ','',0,'R');
$this->Cell(15, 3, $_SESSION['lang']['page'], '', 0, 'L');
$this->Cell(2, 3, ':', '', 0, 'L');
$this->Cell(35, 3, $this->PageNo(), '', 1, 'L');
$this->Cell(230, 3, "Periode:" . $periode, '', 0, 'L');
// $this->Cell(150,3,' ','',0,'R');
$this->Cell(15, 3, 'User', '', 0, 'L');
$this->Cell(2, 3, ':', '', 0, 'L');
$this->Cell(35, 3, $_SESSION['standard']['username'], '', 1, 'L');
$this->SetFont('Arial', '', 8);
// $this->Line(10,36,200,36);
$this->Ln();
$this->Cell($lebarkiri, 5, '', 'B', 0, 'L');
$this->Cell($lebarisi, 5, numToMonth(1, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(2, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(3, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(4, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(5, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(6, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(7, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(8, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(9, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(10, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(11, 'E'), 'B', 0, 'R');
$this->Cell($lebarisi, 5, numToMonth(12, 'E'), 'B', 0, 'R');
$this->Cell($lebarkanan, 5, 'YTD', 'B', 1, 'R');
$this->Ln();
}
echo"</pre>";*/
if ($proses == 'excel') {
$stream = "<table cellspacing='1' border='1' class='sortable'>";
} else {
$stream .= "<table cellspacing='1' border='0' class='sortable'>";
}
$stream .= "<thead class=rowheader>\r\n <tr>\r\n <td align=center rowspan=3>No</td>\r\n <td align=center rowspan=3>Nama</td>\r\n <td align=center rowspan=3>Nik</td>\r\n <td align=center rowspan=3>lok</td>\r\n <td align=center rowspan=3>sub bag</td>\r\n <td align=center rowspan=3>gapok</td>\r\n <td colspan=2 align=center>Tanggal</td>\r\n <td align=center colspan=24>2014</td>\r\n </tr>";
$stream .= "<tr>\r\n <td rowspan=2>Masuk</td>\r\n <td rowspan=2>Keluar</td>\r\n ";
// $stream.="<tr>";
for ($bulan = 1; $bulan <= 12; $bulan++) {
if (strlen($bulan) == 1) {
$bulan = '0' . $bulan;
} else {
$bulan = $bulan;
}
$nmbulan = numToMonth($bulan, 'I', 'long');
$stream .= "\r\n <td align=center colspan=2>" . $nmbulan . "</td>\r\n ";
}
$stream .= "</tr>";
$stream .= "<tr>";
for ($bpjs = 1; $bpjs <= 12; $bpjs++) {
$stream .= "\r\n <td align=center>Ketenagakerjaan</td>\r\n <td align=center>Kesehatan</td>";
}
$stream .= " \r\n </tr>\r\n </thead>\r\n <tbody>";
if (is_array($karyawan)) {
foreach ($karyawan as $karyawanid) {
if ($tglkeluar[$karyawanid] == '0000-00-00') {
$tglkeluar[$karyawanid] = '';
$tglkeluarv2 = tanggalnormal($tglkeluar[$karyawanid]);
}
if ($tglkeluarv2 == '--') {
$pdf->Ln($height2);
$pdf->Cell(110, $height, 'Dasar Pengenaan Pajak', 1, 0, 'LT');
$pdf->Cell(35, $height, '', 1, 0, 'C');
$pdf->Cell(35, $height, number_format($jumlahRp - $uangMuka - $potongan, 2), 1, 0, 'R');
$pdf->Ln($height2);
//$jumlahPpn=$ppnInv[$dHt['noinvoice']]/100*$jumlahRp;
$jumlahPpn = ($jumlahRp - $uangMuka - $potongan) * 10 / 100;
$pdf->Cell(110, $height, "PPN = 10% Dasar Pengenaan Pajak", 1, 0, 'LT');
$pdf->Cell(35, $height, '', 1, 0, 'C');
$pdf->Cell(35, $height, number_format($jumlahPpn, 2), 1, 0, 'R');
$tglInv = explode('-', $dInv['tanggal']);
$tanggalHr = $tglInv[2];
$bulanHr = $tglInv[1];
$tahunHr = $tglInv[0];
//($int,$lang='E',$format='short')
$nmBulan = numToMonth($bulanHr, 'I', 'long');
$untukTtd = " Jakarta " . $tanggalHr . " " . $nmBulan . " " . $tahunHr . " ";
$pdf->Ln($height2);
$pdf->Cell(180, $height, '', RLT, 1, 'L');
$pdf->Cell(10, $height, '', RL, 0, 'L');
$pdf->Cell(20, $height, 'TARIF', 1, 0, 'C');
$pdf->Cell(40, $height, 'DPP', 1, 0, 'C');
$pdf->Cell(40, $height, 'PPn BM', 1, 0, 'C');
$pdf->Cell(70, $height, $untukTtd, R, 1, 'C');
for ($i = 1; $i <= 3; $i++) {
$pdf->Cell(10, $height, '', RL, 0, 'L');
$pdf->Cell(20, $height, '....%', 1, 0, 'L');
$pdf->Cell(40, $height, 'Rp..........', 1, 0, 'L');
$pdf->Cell(40, $height, 'Rp..........', 1, 0, 'L');
$pdf->Cell(70, $height, '', R, 1, 'C');
}
$query .= " where " . $where;
try {
# Update to DB
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error($conn);
exit;
}
# Update to Table
echo "var currRow = document.getElementById('currRow').value;";
foreach ($data as $key => $row) {
if ($key == 'luasareanonproduktif') {
echo "document.getElementById('" . $key . "_'+currRow).innerHTML = '" . number_format($row, 2) . "';";
echo "document.getElementById('" . $key . "_'+currRow).setAttribute('value','" . $row . "');";
} else {
if ($key == 'jumlahpokok') {
echo "document.getElementById('" . $key . "_'+currRow).innerHTML = '" . number_format($row, 0) . "';";
echo "document.getElementById('" . $key . "_'+currRow).setAttribute('value','" . $row . "');";
} else {
if ($key == 'bulanmulaipanen') {
echo "document.getElementById('" . $key . "_'+currRow).innerHTML = '" . numToMonth($row, $lang = 'E', $format = 'short') . "';";
echo "document.getElementById('" . $key . "_'+currRow).setAttribute('value','" . $row . "');";
} else {
echo "document.getElementById('" . $key . "_'+currRow).innerHTML = '" . $row . "';";
echo "document.getElementById('" . $key . "_'+currRow).setAttribute('value','" . $row . "');";
}
}
}
}
} catch (Exception $e) {
echo $e->getMessage();
}
//$periodCUR=date('Ym',$t);#periode saldoakhir bulan berjalan
//$kolomCUR="awal".date('m',$t);
//
//#captionsekarang============================
//$t=mktime(0,0,0,substr($periodesaldo,4,2),15,substr($periodesaldo,0,4));
//$captionCUR=date('M-Y',$t);
#ambil format mesinlaporan==========
$str = "select * from " . $dbname . ".keu_5mesinlaporandt where namalaporan='" . $kodelaporan . "' order by nourut";
$res = mysql_query($str);
#query+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
if ($unit == '') {
$where = " kodeorg in(select kodeorganisasi from " . $dbname . ".organisasi where induk='" . $pt . "')";
} else {
$where = " kodeorg='" . $unit . "'";
}
$stream = $_SESSION['lang']['laporanrugilabaperiodik'] . "<br>" . $pt . "-" . $unit . "-" . $periode . "<br>\r\n <table class=sortable border=1 cellspacing=1>\r\n <thead>\r\n <tr class=rowheader>\r\n <td colspan=3>" . $_SESSION['lang']['keterangan'] . "</td>\r\n <td align=center>" . numToMonth(1, 'E') . "</td>\r\n <td align=center>" . numToMonth(2, 'E') . "</td>\r\n <td align=center>" . numToMonth(3, 'E') . "</td>\r\n <td align=center>" . numToMonth(4, 'E') . "</td>\r\n <td align=center>" . numToMonth(5, 'E') . "</td>\r\n <td align=center>" . numToMonth(6, 'E') . "</td>\r\n <td align=center>" . numToMonth(7, 'E') . "</td>\r\n <td align=center>" . numToMonth(8, 'E') . "</td>\r\n <td align=center>" . numToMonth(9, 'E') . "</td>\r\n <td align=center>" . numToMonth(10, 'E') . "</td>\r\n <td align=center>" . numToMonth(11, 'E') . "</td>\r\n <td align=center>" . numToMonth(12, 'E') . "</td>\r\n <td align=center>YTD</td> \r\n </tr>\r\n </thead><tbody>";
$tnow2[] = 0;
$ttill2 = 0;
$tnow3[] = 0;
$ttill3 = 0;
while ($bar = mysql_fetch_object($res)) {
if ($bar->tipe == 'Header') {
if ($_SESSION['language'] == 'ID') {
$stream .= "<tr class=rowcontent><td colspan=16><b>" . $bar->keterangandisplay . "</b></td></tr>";
} else {
$stream .= "<tr class=rowcontent><td colspan=16><b>" . $bar->keterangandisplay1 . "</b></td></tr>";
}
} else {
// #ambil saldo akhir periode barjalan sebagai akumulasi
// $st12="select sum(".$kolomCUR.") as akumilasi
// from ".$dbname.".keu_saldobulanan where noakun between '".$bar->noakundari."'
$pdf->SetFillColor(255, 255, 255);
$pdf->Cell(50, $height, $_SESSION['lang']['others'], 0, 'J');
$pdf->SetX(65);
$pdf->Cell(2, $height, ':', 0, 'J');
$pdf->SetX(68);
$pdf->MultiCell(98, $height, $data['keterangan'], 0, 'J');
$pdf->Ln();
$pdf->Ln();
$pdf->SetX(30);
$pdf->SetFont('Arial', '', 9);
$pdf->SetFillColor(255, 255, 255);
$pdf->MultiCell(150, $height, 'Demikian surat ini, atas perhatiannya kami ucapkan terima kasih.', 0, 'J');
$pdf->Ln();
$pdf->Ln();
$bulan = substr($data['tanggaldo'], 5, 2);
$tanggalSurat = substr($data['tanggaldo'], 8, 2) . " " . numToMonth($bulan, 'I', 'long') . " " . substr($data['tanggaldo'], 0, 4);
$pdf->SetX(30);
$pdf->SetFont('Arial', '', 9);
$pdf->SetFillColor(255, 255, 255);
$pdf->MultiCell(150, $height, 'Jakarta, ' . $tanggalSurat, 0, 'J');
$pdf->SetX(30);
$pdf->SetFont('Arial', '', 9);
$pdf->SetFillColor(255, 255, 255);
$pdf->MultiCell(150, $height, 'Hormat Kami,', 0, 'J');
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->SetX(30);
$pdf->SetFont('Arial', 'U', 9);
while ($bar3 = mysql_fetch_object($res3)) {
for ($g = 0; $g < count($arrPlusId); $g++) {
if ($bar3->component == $arrPlusId[$g]) {
$arrValPlus[$g] = $bar3->value;
}
if ($bar3->component == $arrMinusId[$g]) {
$arrValMinus[$g] = $bar3->value;
}
}
}
$pdf->Image('images/logo.jpg', $pdf->GetX(), $pdf->GetY(), 10);
$pdf->SetX($pdf->getX() + 8);
$pdf->SetFont('Arial', 'B', 8);
$pdf->Cell(70, 5, 'PT.PERKEBUNAN MINANGA OGAN', 0, 1, 'L');
$pdf->SetFont('Arial', '', 5);
$pdf->Cell(60, 3, 'PAY SLYP/SLIP GAJI : ' . numToMonth(substr($periode, 5, 2), 'I', 'short') . " " . substr($periode, 0, 4), 'T', 0, 'L');
$pdf->SetFont('Arial', '', 4);
$pdf->Cell(20, 3, 'Printed on: ' . date('d-m-Y: H:i:s'), "T", 1, 'R');
$pdf->SetFont('Arial', '', 5);
$pdf->Cell(10, 3, 'NIP/TMK', 0, 0, 'L');
$pdf->Cell(30, 3, ": " . $bar1->karyawanid . " / " . $tglmasuk, 0, 0, 'L');
$pdf->Cell(15, 3, 'UNIT/BAGIAN', 0, 0, 'L');
$pdf->Cell(25, 3, ': ' . $dept, 0, 1, 'L');
$pdf->Cell(10, 3, 'NAMA', 0, 0, 'L');
$pdf->Cell(30, 3, ': ' . $bar1->name, 0, 0, 'L');
$pdf->Cell(15, 3, 'JABATAN', 0, 0, 'L');
$pdf->Cell(25, 3, ':' . $title, 0, 1, 'L');
$pdf->Cell(40, 3, 'PENAMBAH', 'TB', 0, 'C');
$pdf->Cell(40, 3, 'PENGURANG', 'TB', 1, 'C');
for ($mn = 0; $mn < count($arrPlusId); $mn++) {
$pdf->Cell(20, 3, $arrPlusName[$mn], 0, 0, 'L');
$pdf->Ln(150);
$toleransi = $bar['toleransi'] . "\n";
$pdf->SetFont('Arial', 'B', '10');
$pdf->Cell(39, 5, '', '', 1, '');
$pdf->Cell(39, 5, '', '', 1, '');
$pdf->Cell(39, 5, '', '', 1, '');
$pdf->Cell(39, 5, $_SESSION['lang']['catatanlain'], '', 0, 'L');
$pdf->Cell(5, 5, ':', '', 0, 'L');
$pdf->SetFont('Arial', '', '10');
//$bar['catatanlain'] = str_replace('≤',chr(163),$bar['catatanlain']);
$pdf->MultiCell(130, 5, $toleransi . $bar['catatanlain'], 0, 'L', 0);
$pdf->Ln(5);
$pdf->Cell(20, 5, '', 0, 'L');
$tglTtd = explode("-", $tlgKontrk);
$tglnya = $tglTtd[0];
$blnnya = numToMonth($tglTtd[1], $lang = 'I', $format = 'long');
$thnnya = $tglTtd[2];
$tglbenernya = $tglnya . ' ' . $blnnya . ' ' . $thnnya;
$pdf->Cell(39, 5, ucwords(strtolower('Jakarta')) . ", " . $tglbenernya, '', 0, 'L');
$pdf->Ln();
$pdf->Cell(20, 5, '', 0, 'L');
$pdf->Cell(12, 5, $_SESSION['lang']['penjual'] . ',', '', 0, 'L');
$pdf->Cell(80, 5, '', '', 0, 'L');
$pdf->Cell(18, 5, $_SESSION['lang']['Pembeli'] . ',', '', 1, 'L');
$pdf->SetFont('Arial', 'B', '10');
$pdf->Cell(20, 5, '', 0, 'L');
$nmPt = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$nmPtS = explode(".", $nmPt[$bar['kodept']]);
setIt($nmPtS[1], '');
$pdf->Cell(80, 5, $nmPtS[0] . "." . ucwords(strtolower($nmPtS[1])), '', 0, 'C');
//$pdf->Cell(80,5,$nmdt2[0].".".ucwords(strtolower($nmdt2[1])),'',1,'C');
function optionMonth($langcode = 'E', $format = 'short')
{
# Init
$month = array();
# Iterate
for ($i = 1; $i <= 12; $i++) {
$month[$i] = numToMonth($i, $langcode, $format);
}
return $month;
}
