$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]);
$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]);
$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, ':');
$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'];
$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]);
$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); }
$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'];
$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');
$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));
$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]);