$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 5;
$tinggi = 275;
$w1 = array(10, 45, 40, 0, 0, 0, 15, 15);
$pdf->SetFont($font, '', $size - 2);
$no = 0;
$sql = "SELECT * FROM mst_potongan WHERE left(kdunitkerja,2) = '{$kdunit}' and tahun = '{$th}' and bulan = '{$kdbulan}' ORDER BY kdunitkerja,grade desc, kdgol desc";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunit) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, nm_unitkerja($row['kdunitkerja']));
    }
    if ($row['kdunitkerja'] == $kdunit) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    $arrNama = $pdf->SplitToArray($w1[2], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib'])));
    $nilpot_10 = $row['kdpot_10'] * persen_pot('10');
    $nilpot_11 = $row['kdpot_11'] * persen_pot('11');
    $nilpot_12 = $row['kdpot_12'] * persen_pot('12');
    $nilpot_13 = $row['kdpot_13'] * persen_pot('13');
    $nilpot_14 = $row['kdpot_14'] * persen_pot('14');
    $nilpot_15 = $row['kdpot_15'] * persen_pot('15');
    $nilpot_16 = $row['kdpot_16'] * persen_pot('16');
    $nilpot_01 = $row['kdpot_01'] * persen_pot('01');
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'A. DATA UMUM', '', 1, 'L');
$w1 = array(10, 30, 47, 15, 30, 50);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1] + $w1[2], $ln, 'I. PEJABAT PENILAI', $border, 0, 'L');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$pdf->Cell($w1[3], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$pdf->Cell($w1[4] + $w1[5], $ln, 'II. PEGAWAI NEGERI SIPIL YANG DINILAI', $border, 1, 'L');
$pdf->SetFont($font, '', $size);
$max = 0;
$arrNo_1 = $pdf->SplitToArray($w1[0], $ln, '1');
$arrLabel_1 = $pdf->SplitToArray($w1[1], $ln, 'Nama');
$arrField_1 = $pdf->SplitToArray($w1[2], $ln, trim(nama_peg($nib_penilai)));
$arrNo_2 = $pdf->SplitToArray($w1[3], $ln, '1');
$arrLabel_2 = $pdf->SplitToArray($w1[4], $ln, 'Nama');
$arrField_2 = $pdf->SplitToArray($w1[5], $ln, trim(nama_peg($row['nib'])));
if ($max < count($arrField_1)) {
    $max = count($arrField_1);
}
if ($max < count($arrField_2)) {
    $max = count($arrField_2);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w1[0], $ln, $arrNo_1[$i], 'LR', 0, 'C');
    $pdf->SetX($margin + $w1[0]);
Exemple #3
0
$th = $_REQUEST['th'];
$renstra = th_renstra($th);
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 5;
$margin = 25;
$tinggi = 275;
$w = array(5, 150);
$pdf->Ln();
$pdf->SetFont($font, 'B', $size + 2);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'INDIKATOR KINERJA UTAMA', '', 1, 'C');
$max = 0;
$arrUnit = $pdf->SplitToArray($w[1], $ln, trim(strtoupper(nm_unit('480000'))));
if ($max < count($arrUnit)) {
    $max = count($arrUnit);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUnit[$i], '', 1, 'C');
}
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'Periode Renstra ' . $renstra, '', 1, 'C');
$pdf->Ln() * 2;
$w1 = array(0, 65, 95);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln * 2, 'Sasaran Strategis Utama', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1]);
Exemple #4
0
$w = array(50, 5, 80);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln * 10, '', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln, 'SURAT KETERANGAN', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln, 'MENEMUKAN SESUATU YANG BARU (KREATIVITAS)', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln * 2, '', '', 1, 'C');
$sql = "SELECT * FROM mst_skp WHERE id = '{$id_skp}'";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
$pdf->SetFont($font, '', $size);
$w = array(7, 100);
$max = 0;
$arrNomor = $pdf->SplitToArray($w[0], $ln, '1.');
$arrUraian = $pdf->SplitToArray($w[1], $ln, 'Yang bertanda tangan di bawah ini :');
if ($max < count($arrUraian)) {
    $max = count($arrUraian);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w[0], $ln, $arrNomor[$i], '', 0, 'L');
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUraian[$i], '', 1, 'L');
}
$w = array(7, 5, 45, 5, 100);
$max = 0;
$arrNomor = $pdf->SplitToArray($w[1], $ln, 'a.');
$arrLabel = $pdf->SplitToArray($w[2], $ln, 'Nama');
$arrTitik = $pdf->SplitToArray($w[3], $ln, ':');
Exemple #5
0
	$pdf->SetXY($margin+$w1[0]*2+$w1[1]+$w1[2]+$w1[3]+$w1[4]+$w1[5]+$w1[6]+$w1[7],$y+5);
	$pdf->Cell($w1[8],$ln,'Fungsional',$border,0,'C');
	$pdf->SetXY($margin+$w1[0]*2+$w1[1]+$w1[2]+$w1[3]+$w1[4]+$w1[5]+$w1[6]+$w1[7]+$w1[8],$y+5);
	$pdf->Cell($w1[9],$ln,'Umum',$border,0,'C');
	$pdf->SetXY($margin+$w1[0]*2+$w1[1]+$w1[2]+$w1[3]+$w1[4]+$w1[5]+$w1[6]+$w1[7]+$w1[8]+$w1[9],$y);
	$pdf->Cell($w1[10],$ln*2,'Grade',$border,1,'C');
*/
$pdf->SetFont($font, '', $size - 2);
$w1 = array(10, 40, 45, 8, 8, 40, 10, 35, 35, 35, 12);
$no = 0;
$sql = "SELECT * FROM mst_skp WHERE left(kdunitkerja,2) = '{$kdunit}' and tahun = '{$th}' ORDER BY kdunitkerja,kdjabatan,kdgol";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja'])));
    }
    if ($row['kdunitkerja'] == $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    if ($row['kdunitkerja'] != $kdunitkerja and $row['kdjabatan'] != $kdjabatan) {
        $arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']));
    }
    if ($row['kdunitkerja'] == $kdunitkerja and $row['kdjabatan'] != $kdjabatan) {
        $arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']));
    }
    if ($row['kdunitkerja'] == $kdunitkerja and $row['kdjabatan'] == $kdjabatan) {
        $arrJabatan = $pdf->SplitToArray($w1[2], $ln, '');
    }
$pdf->Cell($w2[2], $ln, '(3)', $border, 0, 'C');
$pdf->SetX($margin + $w2[0] + $w2[1] + $w2[2]);
$pdf->Cell($w2[3], $ln, '(4)', $border, 0, 'C');
$pdf->SetX($margin + $w2[0] + $w2[1] + $w2[2] + $w2[3]);
$pdf->Cell($w2[4], $ln, '(5)', $border, 0, 'C');
$pdf->SetX($margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4]);
$pdf->Cell($w2[5], $ln, '(6)=(3)x(5)', $border, 0, 'C');
$pdf->SetX($margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5]);
$pdf->Cell($w2[6], $ln, '(7)', $border, 1, 'C');
$ln = 4;
$sql = "SELECT kdkelompok FROM t_bantu WHERE kdjab = '{$kdjab}' GROUP BY kdkelompok ORDER BY kdkelompok";
$qu = mysql_query($sql);
while ($Kelompok = mysql_fetch_array($qu)) {
    $pdf->SetFont($font, 'B', $size - 1);
    $max = 0;
    $arrNo = $pdf->SplitToArray($w2[0], $ln, nmromawi($Kelompok['kdkelompok']));
    $arrUraian = $pdf->SplitToArray($w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5] + $w2[6], $ln, trim(nm_kelompok_bantu($kdjab, $Kelompok['kdkelompok'])));
    if ($max < count($arrUraian)) {
        $max = count($arrUraian);
    }
    for ($i = 0; $i < $max; $i++) {
        $pdf->SetX($margin);
        $pdf->Cell($w2[0], $ln, $arrNo[$i], 'LR', 0, 'C');
        $pdf->SetX($margin + $w2[0]);
        $pdf->Cell($w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5] + $w2[6], $ln, $arrUraian[$i], 'LR', 1, 'L');
    }
    $pdf->Line($margin, $pdf->GetY(), $margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5] + $w2[6], $pdf->GetY());
    $pdf->SetFont($font, '', $size - 2);
    $sql_item = "SELECT * FROM t_bantu WHERE kdjab = '{$kdjab}' and kdkelompok = '{$Kelompok['kdkelompok']}' ORDER BY kditem";
    $qu_item = mysql_query($sql_item);
    while ($Item = mysql_fetch_array($qu_item)) {
$pdf->SetX($marginL + $w[0]);
$pdf->Cell($w[1], $hh * 2, 'Uraian', $border, 0, 'C');
$pdf->SetX($marginL + $w[0] + $w[1]);
$pdf->Cell($w[2], $hh * 2, 'Alasan', $border, 1, 'C');
$pdf->SetFont($font, '', $fsize2);
if ($kdunit == '420000') {
    $oList = mysql_query("select iku,alasan from m_iku_program order by concat(kdprogram,kddeputi,kdiku)");
} else {
    $oList_subprogram = mysql_query("select kdsubprogram from tb_subprogram where kddeputi='{$kdunit}'");
    $List_subprogram = mysql_fetch_array($oList_subprogram);
    $oList = mysql_query("select ikk,alasan from m_ikk_subprogram where kdsubprogram='{$List_subprogram['kdsubprogram']}' order by kdikk");
}
while ($List = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $arrNomor = $pdf->SplitToArray($w[0], $hhh, $no . '.');
    if ($kdunit == '420000') {
        $arrUraian = $pdf->SplitToArray($w[1], $hhh, trim($List['iku']));
    }
    if ($kdunit != '420000') {
        $arrUraian = $pdf->SplitToArray($w[1], $hhh, trim($List['ikk']));
    }
    $arrAlasan = $pdf->SplitToArray($w[2], $hhh, trim($List['alasan']));
    if ($max < count($arrUraian)) {
        $max = count($arrUraian);
    }
    if ($max < count($arrAlasan)) {
        $max = count($arrAlasan);
    }
    for ($i = 0; $i < $max; $i++) {
        $pdf->SetX($marginL);
 $sql_bank = "SELECT no_rek FROM mst_rekening WHERE nip = '{$nip}'";
 $oList_bank = mysql_query($sql_bank);
 $List_bank = mysql_fetch_array($oList_bank);
 $potongan_p = 0;
 $potongan_r = 0;
 if ($rdata_status['status_verifikasi_potongan'] == '1') {
     $bulan = $th . '-' . $kdbulan;
     $sql_pot = "SELECT TOT FROM potongan WHERE nip = '{$nip}' and bulan = '{$bulan}'";
     $oList_pot = mysql_query($sql_pot);
     $List_pot = mysql_fetch_array($oList_pot);
     $potongan_p = $List_pot['TOT'];
     $potongan_r = $potongan_p / 100 * $row['tunker'];
 }
 $max = 0;
 $no += 1;
 $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
 $arrNama = $pdf->SplitToArray($w1[1], $ln, nama_peg($row['nip']) . "\n" . 'NIP. ' . reformat_nipbaru($row['nip']));
 $arrGol = $pdf->SplitToArray($w1[2], $ln, nm_gol($row['kdgol']) . "\n" . nm_status_peg($row['kdstatuspeg']));
 $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']) . "\n" . reformat_tgl($row['tmtjabatan']));
 $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']);
 $arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'], "0", ",", "."));
 $arrPajak = $pdf->SplitToArray($w1[5], $ln, number_format($row['pajak_tunker'], "0", ",", "."));
 $arrBruto = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] + $row['pajak_tunker'], "0", ",", "."));
 $arrPPH = $pdf->SplitToArray($w1[6], $ln, number_format($row['pajak_tunker'], "0", ",", "."));
 $arrKurang = $pdf->SplitToArray($w1[7], $ln, number_format($potongan_p, "2", ",", ".") . '%');
 $arrBayar = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] - $potongan_r, "0", ",", "."));
 $arrPot = $pdf->SplitToArray($w1[6], $ln, number_format($potongan_r, "0", ",", "."));
 $arrJmlPot = $pdf->SplitToArray($w1[6], $ln, number_format($row['pajak_tunker'] + $potongan_r, "0", ",", "."));
 $arrNorec = $pdf->SplitToArray($w1[8], $ln, $List_bank['no_rek']);
 $total_tunker += $row['tunker'];
 $total_pajak += $row['pajak_tunker'];
Exemple #9
0
$size = 10;
$ln = 5;
$margin = 10;
$tinggi = 275;
$w = array(0, 180);
$w1 = array(20, 70, 65, 15, 15);
$pdf->SetFont($font, '', $size);
$no = 0;
$xkdunit = substr($kdunit, 0, 5);
$sql = "SELECT * FROM mst_info_jabatan WHERE kdunitkerja LIKE '{$xkdunit}%' ORDER BY kdunitkerja,grade desc";
$qu = mysql_query($sql);
$row = array();
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja'])));
    }
    if ($row['kdunitkerja'] == $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    $arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']));
    $arrJumlah = $pdf->SplitToArray($w1[3], $ln, $row['jumlah']);
    $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']);
    if ($max < count($arrUnit)) {
        $max = count($arrUnit);
    }
    if ($max < count($arrJabatan)) {
        $max = count($arrJabatan);
    }
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'A. DATA UMUM', '', 1, 'L');
$w1 = array(10, 30, 45, 15, 30, 50);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1] + $w1[2], $ln, 'I. PEJABAT PENILAI', $border, 0, 'L');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$pdf->Cell($w1[3], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$pdf->Cell($w1[4] + $w1[5], $ln, 'II. PEGAWAI NEGERI SIPIL YANG DINILAI', $border, 1, 'L');
$pdf->SetFont($font, '', $size);
$max = 0;
$arrNo_1 = $pdf->SplitToArray($w1[0], $ln, '1');
$arrLabel_1 = $pdf->SplitToArray($w1[1], $ln, 'Nama');
$arrField_1 = $pdf->SplitToArray($w1[2], $ln, trim(nama_peg($row['nib_atasan'])));
$arrNo_2 = $pdf->SplitToArray($w1[3], $ln, '1');
$arrLabel_2 = $pdf->SplitToArray($w1[4], $ln, 'Nama');
$arrField_2 = $pdf->SplitToArray($w1[5], $ln, trim(nama_peg($row['nip'])));
if ($max < count($arrField_1)) {
    $max = count($arrField_1);
}
if ($max < count($arrField_2)) {
    $max = count($arrField_2);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w1[0], $ln, $arrNo_1[$i], 'LR', 0, 'C');
    $pdf->SetX($margin + $w1[0]);
Exemple #11
0
$border = 1;
$size = 10;
$ln = 5;
$margin = 10;
$tinggi = 275;
$w = array(0, 180);
$w1 = array(20, 60, 65, 15, 25);
$pdf->SetFont($font, '', $size);
$no = 0;
$xkdunit = substr($kdunit, 0, 5);
$sql = "SELECT * FROM kd_jabatan WHERE kdunitkerja LIKE '{$xkdunit}%' ORDER BY kdunitkerja,klsjabatan desc,kode";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja'])));
    }
    if ($row['kdunitkerja'] == $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    $arrJabatan = $pdf->SplitToArray($w1[2], $ln, $row['nmjabatan']);
    $arrKode = $pdf->SplitToArray($w1[4], $ln, substr($row['kode'], 0, 3) . '.' . substr($row['kode'], 3, 5));
    $arrGrade = $pdf->SplitToArray($w1[3], $ln, $row['klsjabatan']);
    if ($max < count($arrUnit)) {
        $max = count($arrUnit);
    }
    if ($max < count($arrJabatan)) {
        $max = count($arrJabatan);
    }
Exemple #12
0
$w1 = array(10, 30, 45, 15, 30, 60);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1] + $w1[2], $ln, 'I. PEJABAT PENILAI', $border, 0, 'L');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$pdf->Cell($w1[3], $ln, 'NO.', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$pdf->Cell($w1[4] + $w1[5], $ln, 'II. PEGAWAI NEGERI SIPIL YANG DINILAI', $border, 1, 'L');
$pdf->SetFont($font, '', $size);
$sql = "SELECT * FROM mst_skp WHERE id = '{$id_skp}'";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
$max = 0;
$arrNo_1 = $pdf->SplitToArray($w1[0], $ln, '1');
$arrLabel_1 = $pdf->SplitToArray($w1[1], $ln, 'Nama');
$arrField_1 = $pdf->SplitToArray($w1[2], $ln, trim(nama_peg($row['nib_atasan'])));
$arrNo_2 = $pdf->SplitToArray($w1[3], $ln, '1');
$arrLabel_2 = $pdf->SplitToArray($w1[4], $ln, 'Nama');
$arrField_2 = $pdf->SplitToArray($w1[5], $ln, trim(nama_peg($row['nib'])));
if ($max < count($arrField_1)) {
    $max = count($arrField_1);
}
if ($max < count($arrField_2)) {
    $max = count($arrField_2);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w1[0], $ln, $arrNo_1[$i], 'LR', 0, 'C');
    $pdf->SetX($margin + $w1[0]);
$pdf->SetFont($font, 'B', $size + 2);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'BUKU CATATAN HARIAN PELAKSANAAN TUGAS', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'Tanggal ' . reformat_tgl($tgl1) . ' s/d ' . reformat_tgl($tgl2), '', 1, 'C');
$pdf->Ln() * 2;
$w1 = array(0, 30, 5, 100);
$pdf->SetFont($font, 'B', $size);
$sql = "SELECT * FROM mst_skp WHERE id = '{$id_skp}'";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
//------------- data pegawai yang dinilai -------------------
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln, 'PEJABAT YANG DINILAI', '', 1, 'L');
$max = 0;
$arrLabel = $pdf->SplitToArray($w1[1], $ln, 'NAMA PEGAWAI');
$arrUraian = $pdf->SplitToArray($w1[3], $ln, trim(nama_peg($row['nip'])));
$arrTitik = $pdf->SplitToArray($w1[2], $ln, ':');
if ($max < count($arrUraian)) {
    $max = count($arrUraian);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin + $w1[0]);
    $pdf->Cell($w1[1], $ln, $arrLabel[$i], '', 0, 'L');
    $pdf->SetX($margin + $w1[0] + $w1[1]);
    $pdf->Cell($w1[2], $ln, $arrTitik[$i], '', 0, 'C');
    $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
    $pdf->Cell($w1[3], $ln, $arrUraian[$i], '', 1, 'L');
}
$max = 0;
$arrLabel = $pdf->SplitToArray($w1[1], $ln, 'NIP');
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 15;
$tinggi = 275;
$w1 = array(10, 50, 12, 40, 10, 30);
$pdf->SetFont($font, '', $size - 1);
$no = 0;
$sql = "SELECT * FROM mst_tk WHERE kdsatker = '{$kdsatker}' and tahun = '{$th}' and bulan = '{$kdbulan}' ORDER BY grade desc, kdgol desc, kdjabatan";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrNama = $pdf->SplitToArray($w1[1], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib'])));
    $arrGol = $pdf->SplitToArray($w1[2], $ln, nm_gol(substr($row['kdgol'], 0, 1) . hurufkeangka(substr($row['kdgol'], 1, 1))) . "\n" . status_peg($row['kdpeg']));
    if ($row['jml_hari'] == 0) {
        $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan']));
    }
    if ($row['jml_hari'] != 0) {
        $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan']) . "\n" . ' (' . $row['jml_hari'] . ' hari dari ' . hari_bulan($th, $kdbl) . ' hari kerja)');
    }
    $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']);
    $arrTGrade = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']), "0", ",", "."));
    $arrFPot = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']) - $row['tunker'], "0", ",", "."));
    $arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'], "0", ",", "."));
    $arrPajak = $pdf->SplitToArray($w1[5], $ln, number_format($row['pajak_tunker'], "0", ",", "."));
    $arrMinta = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] + $row['pajak_tunker'], "0", ",", "."));
    $total_tunker += $row['tunker'];
Exemple #15
0
$w = array(30, 1, 120, 1);
$pdf->SetFont($font, 'B', $size + 8);
$y = $pdf->GetY() + 25;
$pdf->SetY($y);
$pdf->Image('../../css/images/ristek.jpg', 90, 25, 30, 30, 'jpg');
$y = $pdf->GetY() + 30;
$pdf->SetY($y);
$pdf->Cell(0, 10, 'KERANGKA ACUAN KERJA', '', 1, 'C');
$pdf->Cell(0, 10, 'KEGIATAN', '', 1, 'C');
$pdf->SetFont($font, 'B', $size + 6);
$pdf->Cell(0, 10, 'Tahun Anggaran ' . $Kegiatan_bp['th'], '', 1, 'C');
$y = $pdf->GetY() + 10;
$pdf->SetXY($margin + $w[0], $y);
$pdf->Cell($w[1] + $w[2] + $w[3], $ln, '', '', 1, 'C');
$max = 0;
$arrNmGiat = $pdf->SplitToArray($w[2], $ln, trim(nm_giat($Kegiatan_bp['kdgiat'])));
if ($max < count($arrNmGiat)) {
    $max = count($arrNmGiat);
}
$pdf->Line($margin + $w[0], $pdf->GetY(), $margin + $w[0] + $w[1] + $w[2] + $w[3], $pdf->GetY());
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1] + $w[2] + $w[3], $ln - 2, '', 'LR', 1, 'L');
$pdf->SetFont($font, 'B', $size + 5);
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, '', 'L', 0, 'L');
    $pdf->SetX($margin + $w[0] + $w[1]);
    $pdf->Cell($w[2], $ln, $arrNmGiat[$i], '', 0, 'C');
    $pdf->SetX($margin + $w[0] + $w[1] + $w[2]);
    $pdf->Cell($w[3], $ln, '', 'R', 1, 'L');
}
$w = array(50, 5, 80);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln * 6, '', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln, 'SURAT KETERANGAN', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln, 'MELAKSANAKAN TUGAS TAMBAHAN', '', 1, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[2], $ln * 2, '', '', 1, 'C');
$sql = "SELECT * FROM mst_skp WHERE id = '{$id_skp}'";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
$pdf->SetFont($font, '', $size);
$w = array(7, 100);
$max = 0;
$arrNomor = $pdf->SplitToArray($w[0], $ln, '1.');
$arrUraian = $pdf->SplitToArray($w[1], $ln, 'Yang bertanda tangan di bawah ini :');
if ($max < count($arrUraian)) {
    $max = count($arrUraian);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w[0], $ln, $arrNomor[$i], '', 0, 'L');
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUraian[$i], '', 1, 'L');
}
$w = array(7, 5, 45, 5, 100);
$max = 0;
$arrNomor = $pdf->SplitToArray($w[1], $ln, 'a.');
$arrLabel = $pdf->SplitToArray($w[2], $ln, 'Nama');
$arrTitik = $pdf->SplitToArray($w[3], $ln, ':');
$pdf->Cell($w[1], $ln, 'Periode Renstra ' . $renstra, '', 1, 'C');
$pdf->Ln() * 2;
$w1 = array(50, 110);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln * 2, 'Sasaran Strategis', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln * 2, 'Indikator Kinerja Utama', $border, 1, 'C');
$pdf->SetFont($font, '', $size);
$no = 0;
$oList = mysql_query("select * from m_ikk_kegiatan WHERE ta = '{$renstra}' and kdunitkerja = '{$kdunit}' order by kdunitkerja,kdgiat,no_ikk");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    if ($kdsasaran != $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, nm_sasaran($renstra, $row['kdunitkerja'], $row['no_sasaran']));
    }
    if ($kdsasaran == $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, '');
    }
    $arrIndikator = $pdf->SplitToArray($w1[1], $ln, '[IKU ' . $row['nm_ikk'] . ']' . trim($row['nm_ikk']));
    if ($max < count($arrSasaran)) {
        $max = count($arrSasaran);
    }
    if ($max < count($arrIndikator)) {
        $max = count($arrIndikator);
    }
    if ($kdsasaran != $row['no_sasaran']) {
        $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1], $pdf->GetY());
    }
    if ($kdsasaran == $row['no_sasaran']) {
$margin = 15;
$tinggi = 275;
$w1 = array(10, 55, 15, 65, 20, 35);
$pdf->SetFont($font, '', $size - 1);
$no = 0;
$xkdunit = substr($kdunit, 0, 5);
if ($kdunit == '2320100') {
    $sql = "SELECT * FROM mst_tk WHERE tahun = '{$th}' and bulan = '{$kdbulan}' and ( kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ) ORDER BY grade desc,kdgol,kdjabatan";
} else {
    $sql = "SELECT * FROM mst_tk WHERE tahun = '{$th}' and bulan = '{$kdbulan}' and kdunitkerja LIKE '{$xkdunit}%' ORDER BY grade desc,kdgol,kdjabatan";
}
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrNama = $pdf->SplitToArray($w1[1], $ln, nama_peg($row['nip']) . "\n" . 'NIP. ' . reformat_nipbaru($row['nip']));
    $arrGol = $pdf->SplitToArray($w1[2], $ln, nm_gol($row['kdgol']) . "\n" . nm_status_peg($row['kdstatuspeg']));
    $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']) . "\n" . reformat_tgl($row['tmtjabatan']));
    $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']);
    $arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'], "0", ",", "."));
    $arrPajak = $pdf->SplitToArray($w1[5], $ln, number_format($row['pajak_tunker'], "0", ",", "."));
    $arrMinta = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] + $row['pajak_tunker'], "0", ",", "."));
    $total_tunker += $row['tunker'];
    $total_pajak += $row['pajak_tunker'];
    if ($max < count($arrNama)) {
        $max = count($arrNama);
    }
    if ($max < count($arrJabatan)) {
        $max = count($arrJabatan);
    }
$ln = 4;
$margin = 5;
$tinggi = 275;
$w1 = array(10, 45, 45, 15, 15, 20, 10, 15);
$pdf->SetFont($font, '', $size - 2);
$no = 0;
if ($kdunit != '') {
    $sql = "SELECT * FROM mst_potongan WHERE left(kdunitkerja,2) = '{$kdunit}' and tahun = '{$th}' and bulan = '{$kdbulan}' ORDER BY kdunitkerja,grade desc, kdgol desc";
} else {
    $sql = "SELECT * FROM mst_potongan WHERE kdsatker = '{$kdsatker}' and tahun = '{$th}' and bulan = '{$kdbulan}' ORDER BY grade desc, kdgol desc, kdunitkerja";
}
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nmjabatan_mst_tk($row['nib'], $th, $kdbulan)));
    $arrNama = $pdf->SplitToArray($w1[2], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib'])));
    $arrGrade = $pdf->SplitToArray($w1[3], $ln, $row['grade']);
    $arrGol = $pdf->SplitToArray($w1[4], $ln, nm_gol(substr($row['kdgol'], 0, 1) . hurufkeangka(substr($row['kdgol'], 1, 1))));
    if ($row['kdpot_10'] != 0) {
        $arrPot_10 = $pdf->SplitToArray($w1[6], $ln, $row['kdpot_10']);
    }
    if ($row['kdpot_10'] == 0) {
        $arrPot_10 = $pdf->SplitToArray($w1[6], $ln, '');
    }
    if ($row['kdpot_11'] != 0) {
        $arrPot_11 = $pdf->SplitToArray($w1[6], $ln, $row['kdpot_11']);
    }
    if ($row['kdpot_11'] == 0) {
        $arrPot_11 = $pdf->SplitToArray($w1[6], $ln, '');
$ln = 6;
$margin = 10;
$tinggi = 275;
$w1 = array(10, 30, 20, 32, 22, 32);
$pdf->SetFont($font, '', $size - 1);
$xx = 0;
$no = 0;
$oList = mysql_query("SELECT grade, count(nib) as jumlah, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM mst_tk WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan = '{$kdbulan}' GROUP BY grade ORDER BY grade desc");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nilGrade = rp_grade($kdunit, $row['grade'], 1);
    $total_tunker += $row['jml_tunker'];
    $total_pajak += $row['jml_pajak'];
    $total_terima += $row['jml_terima'];
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'Kelas Jabatan ' . $row['grade']);
    if ($nilGrade * $row['jumlah'] != $row['jml_tunker']) {
        $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", ".") . ' (*)');
        $xx = 1;
    } else {
        $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", "."));
    }
    $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", "."));
    $arrJmlTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'], "0", ",", "."));
    $arrJmlPajak = $pdf->SplitToArray($w1[4], $ln, number_format($row['jml_pajak'], "0", ",", "."));
    $arrJumlah = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
    $arrTerima = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_terima'], "0", ",", "."));
    $arrPengurang = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] - $row['jml_terima'], "0", ",", "."));
    $arrPotong = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] - $row['jml_terima'] + $row['jml_pajak'], "0", ",", "."));
    if ($max < count($arrGrade)) {
	$pdf->Cell($w1[3],$ln*2,'Gol.',$border,0,'C');
	$pdf->SetX($margin+$w1[0]+$w1[1]+$w1[2]+$w1[3]);
	$pdf->Cell($w1[4],$ln*2,'Nama Jabatan',$border,0,'C');
	$pdf->SetX($margin+$w1[0]+$w1[1]+$w1[2]+$w1[3]+$w1[4]);
	$pdf->Cell($w1[5],$ln*2,'Grade',$border,1,'C');
	$pdf->SetFont($font,'',$size);
*/
$pdf->SetFont($font, '', $size);
$w1 = array(10, 50, 55, 10, 60, 12);
$no = 0;
$sql = "SELECT * FROM mst_skp WHERE left(kdunitkerja,2) = '{$kdunit}' ORDER BY kdunitkerja,kdjabatan,kdgol";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja'])));
    }
    if ($row['kdunitkerja'] == $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    $arrJabatan = $pdf->SplitToArray($w1[4], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']));
    $arrNama = $pdf->SplitToArray($w1[2], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib'])));
    $arrGol = $pdf->SplitToArray($w1[3], $ln, nm_gol($row['kdgol']));
    $arrGrade = $pdf->SplitToArray($w1[5], $ln, $row['grade']);
    $kdunitkerja = $row['kdunitkerja'];
    if ($max < count($arrUnit)) {
        $max = count($arrUnit);
    }
    if ($max < count($arrJabatan)) {
$no = 0;
$ln = 4;
$xkdunit = substr($kdunit, 0, 5);
if ($kdunit == '2320100') {
    $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and ( kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ) GROUP BY grade ORDER BY grade desc");
} else {
    $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and kdunitkerja LIKE '{$xkdunit}%' GROUP BY grade ORDER BY grade desc");
}
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nilGrade = rp_grade($row['grade']);
    $total_tunker += $row['jml_tunker'];
    $total_pajak += $row['jml_pajak'];
    $total += jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']);
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'GRADE ' . $row['grade']);
    $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format(jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']), "0", ",", "."));
    $arrUrut = $pdf->SplitToArray($w1[5], $ln, '1.' . "\n" . '2.' . "\n" . '3.');
    $arrUrut1 = $pdf->SplitToArray($w1[5], $ln, '' . "\n" . '1.' . "\n" . '2.');
    $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", "."));
    $arrJmlTunker = $pdf->SplitToArray($w1[4] - $w1[5], $ln, number_format($row['jml_tunker'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
    //	$arrJmlPajak  = $pdf->SplitToArray($w1[4],$ln,number_format($row['jml_pajak'],"0",",","."));
    $arrJumlah = $pdf->SplitToArray($w1[4], $ln, '' . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'], "0", ",", "."));
    if ($max < count($arrJmlTunker)) {
        $max = count($arrJmlTunker);
    }
    for ($i = 0; $i < $max; $i++) {
        $pdf->SetX($margin);
        if ($i == 1) {
            $pdf->Cell($w1[0], $ln, $arrNo[$i - 1], 'LR', 0, 'C');
$tinggi = 275;
$w = array(0, 180);
$pdf->SetFont($font, '', $size);
$w1 = array(15, 50, 53, 12, 60, 12);
$no = 0;
$xkdunit = substr($kdunit, 0, 5);
if ($kdunit == '2320100') {
    $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ORDER BY kdunitkerja, kdeselon desc,kdjabatan desc,kdgol";
} else {
    $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%' ORDER BY kdunitkerja, kdeselon desc,kdjabatan desc,kdgol";
}
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    if ($row['kdunitkerja'] != $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja'])));
    }
    if ($row['kdunitkerja'] == $kdunitkerja) {
        $arrUnit = $pdf->SplitToArray($w1[1], $ln, '');
    }
    $arrJabatan = $pdf->SplitToArray($w1[4], $ln, nm_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']) . "\n" . '[' . reformat_tgl($row['tmtjabatan']) . ']');
    $arrNama = $pdf->SplitToArray($w1[2], $ln, nama_peg($row['nip']) . "\n" . 'NIP. ' . reformat_nipbaru($row['nip']));
    $arrGol = $pdf->SplitToArray($w1[3], $ln, nm_gol($row['kdgol']) . "\n" . nm_status_peg($row['kdstatuspeg']));
    $arrGrade = $pdf->SplitToArray($w1[3], $ln, nil_grade($row['kdjabatan'], $row['kdunitkerja']));
    if ($max < count($arrUnit)) {
        $max = count($arrUnit);
    }
    if ($max < count($arrJabatan)) {
        $max = count($arrJabatan);
$pdf->Cell($w1[2], $ln * 2, 'Target', $border, 1, 'C');
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, '(1)', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln, '(2)', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1]);
$pdf->Cell($w1[2], $ln, '(3)', $border, 1, 'C');
$pdf->SetFont($font, '', $size);
$renstra = th_renstra($th);
$no = 0;
$oList = mysql_query("select * from th_pk WHERE th = '{$th}' and kdunitkerja = '820000' order by no_pk");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    if ($kdsasaran != $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, nm_sasaran($renstra, $row['kdunitkerja'], $row['no_sasaran']));
    }
    if ($kdsasaran == $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, '');
    }
    if ($row['sub_pk'] == '1') {
        $iku_sub = trim($row['nm_pk']) . "\n";
        $oList_sub = mysql_query("select * from th_pk_sub WHERE th = '{$th}' and kdunitkerja = '820000' and no_pk = '{$row['no_pk']}' order by no_pk_sub");
        while ($row_sub = mysql_fetch_array($oList_sub)) {
            $iku_sub = $iku_sub . nmalfa($row_sub['no_pk_sub']) . '. ' . $row_sub['nm_pk_sub'] . "\n";
        }
        $arrIndikator = $pdf->SplitToArray($w1[1], $ln, trim($iku_sub));
    } else {
        $arrIndikator = $pdf->SplitToArray($w1[1], $ln, trim($row['nm_pk']));
    }
    //	$arrIndikator   = $pdf->SplitToArray($w1[1],$ln,trim($row['nm_pk']));
$th = $_REQUEST['th'];
$renstra = th_renstra($th);
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 5;
$margin = 25;
$tinggi = 275;
$w = array(5, 150);
$pdf->Ln();
$pdf->SetFont($font, 'B', $size + 2);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'OUTCOME UTAMA', '', 1, 'C');
$max = 0;
$arrUnit = $pdf->SplitToArray($w[1], $ln, trim(strtoupper(nm_unit('480000'))));
if ($max < count($arrUnit)) {
    $max = count($arrUnit);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUnit[$i], '', 1, 'C');
}
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'Periode Renstra ' . $renstra, '', 1, 'C');
$pdf->Ln() * 2;
$w1 = array(0, 65, 95);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln * 2, 'Program', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1]);
 if ($j <= 9) {
     $kdbulan = '0' . $j;
 } else {
     $kdbulan = $j;
 }
 $oList = mysql_query("SELECT sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM mst_tk WHERE tahun = '{$th}' and bulan = '{$kdbulan}' and kdsatker = '{$kdsatker}' GROUP BY bulan");
 $row = mysql_fetch_array($oList);
 $max = 0;
 $no += 1;
 $total_tunker += $row['jml_tunker'];
 $total_pajak += $row['jml_pajak'];
 $total_terima += $row['jml_terima'];
 if (jmlpeg_bulan($th, $kdbulan, $kdsatker) > $jml_peg) {
     $jml_peg = jmlpeg_bulan($th, $kdbulan, $kdsatker);
 }
 $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
 $arrBulan = $pdf->SplitToArray($w1[1], $ln, strtoupper(nama_bulan($j)));
 $arrPenerima = $pdf->SplitToArray($w1[2], $ln, jmlpeg_bulan($th, $kdbulan, $kdsatker));
 $arrJmlTunker = $pdf->SplitToArray($w1[3], $ln, number_format($row['jml_tunker'], "0", ",", "."));
 $arrJmlPajak = $pdf->SplitToArray($w1[4], $ln, number_format($row['jml_pajak'], "0", ",", "."));
 $arrJumlah = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
 $arrJmlPajak = $pdf->SplitToArray($w1[6], $ln, number_format($row['jml_pajak'], "0", ",", "."));
 $arrJmlTerima = $pdf->SplitToArray($w1[9], $ln, number_format($row['jml_terima'], "0", ",", "."));
 $arrJmlKurang = $pdf->SplitToArray($w1[7], $ln, number_format($row['jml_tunker'] - $row['jml_terima'], "0", ",", "."));
 $arrJmlPotong = $pdf->SplitToArray($w1[8], $ln, number_format($row['jml_tunker'] - $row['jml_terima'] + $row['jml_pajak'], "0", ",", "."));
 if ($max < count($arrBulan)) {
     $max = count($arrBulan);
 }
 for ($i = 0; $i < $max; $i++) {
     $pdf->SetX($margin);
     $pdf->Cell($w1[0], $ln, $arrNo[$i], 'LR', 0, 'C');
Exemple #27
0
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 5;
$tinggi = 275;
$w1 = array(10, 27, 50, 15, 18, 18, 18, 18, 28);
$pdf->SetFont($font, '', $size - 2);
//----- while pegawai
$no = 0;
$oList = mysql_query("SELECT nib,nip,norec FROM mst_tk WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' GROUP BY nib");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nib = $row['nib'];
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no);
    $arrNama = $pdf->SplitToArray($w1[1], $ln, nama_peg($row['nib']));
    $arrNIP = $pdf->SplitToArray($w1[2], $ln, 'NIP. ' . reformat_nipbaru($row['nip']));
    $arrNorek = $pdf->SplitToArray($w1[7], $ln, $row['norec']);
    if ($max < count($arrNama)) {
        $max = count($arrNama);
    }
    if ($max < count($arrJabatan)) {
        $max = count($arrJabatan);
    }
    $pdf->SetFont($font, 'B', $size - 2);
    for ($i = 0; $i < $max; $i++) {
        $pdf->SetX($margin);
        $pdf->Cell($w1[0], $ln, $arrNo[$i], 'LR', 0, 'C');
        $pdf->SetX($margin + $w1[0]);
        $pdf->Cell($w1[1], $ln, $arrNama[$i], 'LR', 0, 'L');
$w = array(22, 93, 38, 38);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w[0], $ln * 2, 'KODE', $border, 0, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln * 2, 'PROGRAM / KEGIATAN', $border, 0, 'C');
$pdf->SetX($margin + $w[0] + $w[1]);
$pdf->Cell($w[2], $ln * 2, 'ANGGARAN ' . ($th - 1), $border, 0, 'C');
$pdf->SetX($margin + $w[0] + $w[1] + $w[2]);
$pdf->Cell($w[3], $ln * 2, 'ANGGARAN ' . $th, $border, 1, 'C');
$sql = "SELECT SUM(jml_anggaran_renstra) as jml_anggaran_renstra, SUM(jml_anggaran_dipa) as jml_anggaran_dipa,\r\n\t\t\t       SUM(jml_anggaran_indikatif) as jml_anggaran_indikatif FROM thbp_kak_kegiatan WHERE th = '{$th}'";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
$pdf->SetFont($font, 'B', $size + 1);
$max = 0;
$arrKode = $pdf->SplitToArray($w[0], $ln, '082');
$arrUraian = $pdf->SplitToArray($w[1], $ln, 'LEMBAGA PENERBANGAN DAN ANTARIKSA NASIONAL');
$arrPaguDipa = $pdf->SplitToArray($w[2], $ln, number_format($row['jml_anggaran_dipa'], "0", ",", "."));
$arrPaguIni = $pdf->SplitToArray($w[3], $ln, number_format($row['jml_anggaran_indikatif'], "0", ",", "."));
if ($max < count($arrUraian)) {
    $max = count($arrUraian);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin);
    $pdf->Cell($w[0], $ln, $arrKode[$i], 'LR', 0, 'C');
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUraian[$i], 'LR', 0, 'L');
    $pdf->SetX($margin + $w[0] + $w[1]);
    $pdf->Cell($w[2], $ln, $arrPaguDipa[$i], 'LR', 0, 'R');
    $pdf->SetX($margin + $w[0] + $w[1] + $w[2]);
    $pdf->Cell($w[3], $ln, $arrPaguIni[$i], 'LR', 1, 'R');
$pdf->Cell($w1[7], $ln, '(8)', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7]);
$pdf->Cell($w1[8], $ln, '(9)', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8]);
$pdf->Cell($w1[9], $ln, '(10)', $border, 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8] + $w1[9]);
$pdf->Cell($w1[10], $ln, '(11)', $border, 1, 'C');
$pdf->SetFont($font, '', $size);
$renstra = th_renstra($th);
$no = 0;
$oList = mysql_query("select * from th_pk WHERE th = '{$th}' and kdunitkerja = '{$kdunit}' order by no_pk");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    if ($kdsasaran != $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, nm_sasaran($renstra, $row['kdunitkerja'], $row['no_sasaran']));
    }
    if ($kdsasaran == $row['no_sasaran']) {
        $arrSasaran = $pdf->SplitToArray($w1[0], $ln, '');
    }
    if ($row['sub_pk'] == '1') {
        if ($row['no_ikk'] != 0) {
            $iku_sub = '[IKU ' . $row['no_ikk'] . '] ' . trim($row['nm_pk']) . "\n";
        } else {
            $iku_sub = trim($row['nm_pk']) . "\n";
        }
        $oList_sub = mysql_query("select * from th_pk_sub WHERE th = '{$th}' and kdunitkerja = '{$kdunit}' and no_pk = '{$row['no_pk']}' order by no_pk_sub");
        while ($row_sub = mysql_fetch_array($oList_sub)) {
            $iku_sub = $iku_sub . nmalfa($row_sub['no_pk_sub']) . '. ' . $row_sub['nm_pk_sub'] . "\n";
        }
        $arrIndikator = $pdf->SplitToArray($w1[1], $ln, trim($iku_sub));
Exemple #30
0
$th = $_REQUEST['th'];
$renstra = th_renstra($th);
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 11;
$ln = 7;
$margin = 25;
$tinggi = 275;
$w = array(5, 150);
$pdf->Ln();
$pdf->SetFont($font, 'B', $size + 2);
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'PROGRAM UTAMA', '', 1, 'C');
$max = 0;
$arrUnit = $pdf->SplitToArray($w[1], $ln, trim(strtoupper(nm_unit('480000'))));
if ($max < count($arrUnit)) {
    $max = count($arrUnit);
}
for ($i = 0; $i < $max; $i++) {
    $pdf->SetX($margin + $w[0]);
    $pdf->Cell($w[1], $ln, $arrUnit[$i], '', 1, 'C');
}
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'Periode Renstra ' . $renstra, '', 1, 'C');
$pdf->Ln() * 2;
$w1 = array(30, 140);
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln * 2, 'Kode', $border, 0, 'C');
$pdf->SetX($margin + $w1[0]);