$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]);
$pdf->Cell($w1[2], $ln * 2, 'Outcome', $border, 1, 'C');
$pdf->SetFont($font, '', $size);
$no = 0;
$oList = mysql_query("select * from m_program_outcome WHERE ta = '{$th}' order by concat(kdprogram,kdoutcome)");
while ($row = mysql_fetch_array($oList)) {
$max = 0;
$no += 1;
if ($kdprogram != $row['kdprogram']) {
$arrSasaran = $pdf->SplitToArray($w1[1], $ln, nm_program($th, '04801' . $row['kdprogram']));
}
if ($kdprogram == $row['kdprogram']) {
$arrSasaran = $pdf->SplitToArray($w1[1], $ln, '');
}
$arrIku = $pdf->SplitToArray($w1[2], $ln, $row['nmoutcome']);
if ($max < count($arrSasaran)) {
$max = count($arrSasaran);
}
if ($max < count($arrIku)) {
$max = count($arrIku);
}
if ($kdprogram != $row['kdprogram']) {
$pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2], $pdf->GetY());
}
if ($kdprogram == $row['kdprogram']) {
if ($col[6][$k] != $col[6][$k - 1]) {
echo outcome_deputi($col[6][$k]);
}
?>
</td>
<td align="left"><?php
echo $col[4][$k];
?>
</td>
<td align="left"><?php
echo $col[5][$k];
?>
</td>
<td align="left"><?php
if (nm_program(kdprogram_subprogram($col[6][$k])) != nm_program(kdprogram_subprogram($col[6][$k - 1]))) {
echo nm_program(kdprogram_subprogram($col[6][$k]));
}
?>
</td>
</tr><?php
}
}
?>
</tbody>
<tfoot>
<tr>
<td colspan="4"><?php
echo '<strong> Jumlah Anggaran Tahun ' . $th . ' Rp. ' . number_format($Dept['pagu_dept'], "0", ",", ".") . ',- </strong>';
?>
</td>
</tr>
" cols="70" rows="2"><?php
echo $value[3];
?>
</textarea></td>
</tr>
<tr>
<td class="key">Program</td>
<td><select name="kodeprogram">
<?php
$kodeprogram = $value[4] . $value[5] . $value[6];
?>
<option value="<?php
echo $kodeprogram;
?>
"><?php
echo $value[4] . '.' . $value[5] . '.' . $value[6] . ' ' . nm_program($value[4] . $value[5] . $value[6]);
?>
</option>
<option value="">- Pilih Program -</option>
<?php
$query = mysql_query("select kddept,kdunit,kdprogram,left(nmprogram,50) as namaprogram from tb_program ");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kddept'] . $row['kdunit'] . $row['kdprogram'];
?>
"><?php
echo $row['kddept'] . '.' . $row['kdunit'] . '.' . $row['kdprogram'] . ' ' . $row['namaprogram'];
?>
</option>
<?php
<td><input type="text" size="40" readonly="readonly" value="<?php
echo $value[1];
?>
" /></td>
</tr>
<tr>
<td class="key">Kegiatan</td>
<td><input type="text" size="40" readonly="readonly" value="<?php
echo $value[2];
?>
" /></td>
</tr>
<tr>
<td class="key">Program</td>
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo nm_program($value[3] . $value[4] . $value[5]);
?>
</textarea></td>
</tr>
<tr>
<td> </td>
<td>
<form name="form" method="post" action="index.php?p=<?php
echo $_GET['p'];
?>
">
<div class="button2-right">
<div class="prev">
<a onclick="Back('index.php?p=<?php
echo $p_next;
?>
$class = "row0";
} else {
$class = "row1";
}
?>
<tr class="<?php
echo $class;
?>
">
<td align="center"><?php
echo $k + 1;
?>
</td>
<td align="left"><?php
if ($col[2][$k] != $col[2][$k - 1]) {
echo nm_program('04201' . $col[2][$k]);
?>
<br />
<strong>Outcome : </strong><br /><?php
echo outcome_program('04201' . $col[2][$k]);
?>
<?php
}
?>
</td>
<td align="center"><?php
echo $col[3][$k];
?>
</td>
<td align="left"><?php
if ($col[6][$k] != $col[6][$k - 1]) {
<tr>
<td height="21" class="key">Fungsi</td>
<td>
<?php
$sql = "SELECT * FROM tb_unitkerja_fungsi WHERE kdunit = '" . $Kegiatan_bp[kdunitkerja] . "'";
$oFungsi = mysql_query($sql);
while ($Fungsi = mysql_fetch_array($oFungsi)) {
echo $Fungsi['kdfungsi'] . ". " . $Fungsi['nmfungsi'] . "<br>";
}
?>
</td>
</tr>
<tr>
<td class="key">Program</td>
<td><?php
echo nm_program($Kegiatan_bp['kddept'] . $Kegiatan_bp['kdunit'] . $Kegiatan_bp['kdprogram']);
?>
</td>
</tr>
<tr>
<td class="key">Outcome</td>
<td><?php
echo outcome_program($Kegiatan_bp['kddept'] . $Kegiatan_bp['kdunit'] . $Kegiatan_bp['kdprogram']);
?>
</td>
</tr>
<tr>
<td class="key">Tujuan</td>
<td>
<?php
$sql = "SELECT alasan FROM m_iku_program WHERE kddeputi = '" . substr($Kegiatan_bp[kdunitkerja], 0, 3) . '000' . "'";
if ($kdsasaran != $row['no_sasaran']) {
$pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2], $pdf->GetY());
}
if ($kdsasaran == $row['no_sasaran']) {
$pdf->Line($margin + $w1[0], $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2], $pdf->GetY());
}
$kdsasaran = $row['no_sasaran'];
for ($i = 0; $i < $max; $i++) {
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, $arrSasaran[$i], 'LR', 0, 'L');
$pdf->SetX($margin + $w1[0]);
$pdf->Cell($w1[1], $ln, $arrIndikator[$i], 'LR', 0, 'L');
$pdf->SetX($margin + $w1[0] + $w1[1]);
$pdf->Cell($w1[2], $ln, $arrTarget[$i], 'LR', 1, 'C');
}
}
$pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2], $pdf->GetY());
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln * 2, '', '', 1, 'L');
$pdf->SetX($margin);
$pdf->Cell($w1[0], $ln, 'Jumlah Pagu Anggaran ' . $th . ' :', '', 1, 'L');
if (substr($kdunit, 0, 3) == '821') {
$nmprogram = nm_program('0820101');
} else {
$nmprogram = nm_program('0820101');
}
$pdf->SetX($margin);
$pdf->Cell(170, $ln, trim($nmprogram) . ' Rp. ' . number_format(pagudipa_deputi($th, $kdunit), "0", ",", ".") . ',-', '', 1, 'L');
$pdf->SetDisplayMode('real');
$pdf->Output('doc.pdf', 'I');
if ($col[7][$k] != $col[7][$k - 1]) {
echo nm_unit($col[7][$k]);
}
?>
</td>
<td align="center"><?php
echo $col[2][$k];
?>
</td>
<td align="left"><?php
echo $col[3][$k];
?>
</td>
<td align="left"><?php
if ($col[4][$k] . $col[5][$k] . $col[6][$k] != $col[4][$k - 1] . $col[5][$k - 1] . $col[6][$k - 1]) {
echo nm_program($col[4][$k] . $col[5][$k] . $col[6][$k]);
}
?>
</td>
<td width="3%" align="center">
<a href="<?php
echo $ed[$k];
?>
" title="Edit">
<img src="css/images/edit_f2.png" border="0" width="16" height="16"> </a> </td>
<td width="5%" align="center">
<a href="<?php
echo $del[$k];
?>
" title="Delete">
<img src="css/images/stop_f2.png" border="0" width="16" height="16"> </a> </td>
" method="post" name="form"> <table width="663" cellspacing="1" class="admintable"> <tr> <td width="123" class="key">Kode Program</td> <td width="531"> <input type="text" size="10" value="<?php echo @$value['kddept'] . '.' . @$value['kdunit'] . '.' . @$value['kdprogram']; ?> " disabled="disabled"> </td> </tr> <tr> <td class="key">Program</td> <td> <textarea disabled="disabled" cols="70" rows="2"><?php echo nm_program(@$value['th'], @$value['kddept'] . @$value['kdunit'] . @$value['kdprogram']); ?> </textarea> </td> </tr> <tr> <td class="key">Kode Kegiatan</td> <td><input type="text" name="kdgiat" size="8" value="<?php echo @$value['kdgiat']; ?> " disabled="disabled"/></td> </tr> <tr> <td class="key">Nama Kegiatan</td> <td><textarea disabled="disabled" name="nmgiat" cols="70" rows="2"><?php
</tr>
<tr>
<td class="key">Program</td>
<td>
<?php
if ($kdgiat != '') {
?>
<textarea disabled="disabled" cols="70" rows="2"><?php
echo nm_program($th, $Giat['kddept'] . $Giat['kdunit'] . $Giat['kdprogram']);
?>
</textarea>
<?php
} else {
?>
<textarea disabled="disabled" cols="70" rows="2"><?php
echo nm_program($th, $Prog['kddept'] . $Prog['kdunit'] . $Prog['kdprogram']);
?>
</textarea>
<?php
}
?>
</td>
</tr>
<tr>
<td class="key">Kode Kegiatan</td>
<td>
<?php
if ($kdgiat != '') {
?>
<input type="text" name="kdgiat" size="8" value="<?php
$sql = "SELECT kddept,kdunit,kdprogram, SUM(jml_anggaran_renstra) as jml_anggaran_renstra, SUM(jml_anggaran_dipa) as jml_anggaran_dipa, SUM(jml_anggaran_indikatif) as jml_anggaran_indikatif FROM thbp_kak_kegiatan WHERE kdunitkerja = '{$xkdunit}' and th = '{$th}' GROUP BY concat(kddept,kdunit,kdprogram) ORDER BY concat(kddept,kdunit,kdprogram)";
break;
case '6':
$sql = "SELECT kddept,kdunit,kdprogram, SUM(jml_anggaran_renstra) as jml_anggaran_renstra, SUM(jml_anggaran_dipa) as jml_anggaran_dipa, SUM(jml_anggaran_indikatif) as jml_anggaran_indikatif FROM thbp_kak_kegiatan WHERE left(kdunitkerja,3) = '{$kddeputi_i}' and th = '{$th}' GROUP BY concat(kddept,kdunit,kdprogram) ORDER BY concat(kddept,kdunit,kdprogram)";
break;
default:
$sql = "SELECT kddept,kdunit,kdprogram, SUM(jml_anggaran_renstra) as jml_anggaran_renstra, SUM(jml_anggaran_dipa) as jml_anggaran_dipa, SUM(jml_anggaran_indikatif) as jml_anggaran_indikatif FROM thbp_kak_kegiatan WHERE th = '{$th}' GROUP BY concat(kddept,kdunit,kdprogram) ORDER BY concat(kddept,kdunit,kdprogram)";
break;
}
$oProgram = mysql_query($sql);
while ($Program = mysql_fetch_array($oProgram)) {
$pdf->SetFont($font, 'B', $size);
$kdprogram = $Program['kdprogram'];
$max = 0;
$arrKode = $pdf->SplitToArray($w[0], $ln, $Program['kddept'] . '.' . $Program['kdunit'] . '.' . $Program['kdprogram']);
$arrUraian = $pdf->SplitToArray($w[1], $ln, trim(nm_program($Program['kddept'] . $Program['kdunit'] . $Program['kdprogram'])));
$arrPaguDipa = $pdf->SplitToArray($w[2], $ln, number_format($Program['jml_anggaran_dipa'], "0", ",", "."));
$arrPaguIni = $pdf->SplitToArray($w[3], $ln, number_format($Program['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');
}
$kdprogram = $Program['KDPROGRAM'];
$pagu_51 = pagudipa_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 51);
$pagu_52 = pagudipa_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 52);
$pagu_53 = pagudipa_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 53);
$real_51 = realisasi_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 51);
$real_52 = realisasi_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 52);
$real_53 = realisasi_program_jnsbel($th, $kddept, $kdunit_dipa, $kdprogram, 53);
$real_tot = $real_51 + $real_52 + $real_53;
?>
<tr>
<td align="center"><?php
echo $kddept . '.' . $kdunit_dipa . '.' . $kdprogram;
?>
</td>
<td align="left"><?php
echo nm_program($kddept . $kdunit_dipa . $kdprogram);
?>
</td>
<td align="right" class="row6"><?php
echo number_format($Program['pagu_program'] / 1000, "0", ",", ".");
?>
</td>
<td align="right" class="row6"><?php
echo number_format($pagu_51 / 1000, "0", ",", ".");
?>
</td>
<td align="right" class="row6"><?php
echo number_format($real_51 / 1000, "0", ",", ".");
?>
</td>
<td align="right" class="row6"><?php
<tr>
<th width="11%">2010</th>
<th width="12%">2011</th>
<th width="11%">2012</th>
<th width="10%">2013</th>
<th width="10%">2014</th>
</tr>
</thead>
<tbody>
<?php
$oList = mysql_query("select b.kddept as kd_dept, b.kdunit as kd_unit, b.kdprogram as kd_program from {$table} a JOIN tb_giat b ON a.kdgiat=b.kdgiat GROUP BY CONCAT(b.kddept,b.kdunit,b.kdprogram) ORDER BY CONCAT(b.kddept,b.kdunit,b.kdprogram) desc");
while ($List = mysql_fetch_array($oList)) {
?>
<tr>
<td align="left" colspan="8"><?php
echo strtoupper(nm_program($List['kd_dept'] . $List['kd_unit'] . $List['kd_program']));
?>
</td>
</tr>
<?php
$oList_deputi = mysql_query("select b.kdunitkerja as kd_unitkerja,sum(dana_2010) as jmldana_2010, sum(dana_2011) as jmldana_2011, sum(dana_2012) as jmldana_2012,\r\n\t\t\tsum(dana_2013) as jmldana_2013, sum(dana_2014) as jmldana_2014 from {$table} a JOIN tb_giat b ON a.kdgiat=b.kdgiat\r\n\t\t\tWHERE b.kddept='{$List['kd_dept']}' AND b.kdunit='{$List['kd_unit']}' AND b.kdprogram='{$List['kd_program']}'\r\n\t\t\tGROUP BY left(b.kdunitkerja,4) ORDER BY left(b.kdunitkerja,4)");
while ($List_deputi = mysql_fetch_array($oList_deputi)) {
$kddeputi = substr($List_deputi['kd_unitkerja'], 0, 3);
?>
<tr>
<td align="left"> </td>
<td align="left"><strong><?php
echo pilar_deputi(substr($List_deputi['kd_unitkerja'], 0, 3) . '000');
?>
</strong></td>
<td align="left"><?php
<td width="446"><input type="text" size="5" readonly="readonly" value="<?php
echo $value[0];
?>
" /></td>
</tr>
<tr>
<td class="key">Kode Program </td>
<td><input type="text" size="15" readonly="readonly" value="<?php
echo $value[2] . '.' . $value[3] . '.' . $value[4];
?>
" /></td>
</tr>
<tr>
<td class="key">Nama Program </td>
<td><textarea readonly="readonly" cols="70" rows="2"><?php
echo nm_program($value[1], $value[2] . $value[3] . $value[4]);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Kode Kegiatan</td>
<td><input type="text" size="10" readonly="readonly" value="<?php
echo $value[5];
?>
" /></td>
</tr>
<tr>
<td class="key">Nama Kegiatan</td>
<td><textarea readonly="readonly" cols="70" rows="2"><?php
echo $value[6];
" rows="3" cols="50"><?php
echo $value[7];
?>
</textarea></td>
</tr>
<tr>
<td class="key">Program</td>
<td><select name="<?php
echo $field[2];
?>
">
<option value="<?php
echo $value[2];
?>
"><?php
echo nm_program('04201' . $value[2]);
?>
</option>
<option value="">- Pilih Program -</option>
<?php
$query = mysql_query("select kddept,kdunit,kdprogram,left(nmprogram,60) as namaprogram from tb_program ");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kdprogram'];
?>
"><?php
echo $row['kddept'] . '.' . $row['kdunit'] . '.' . $row['kdprogram'] . ' ' . $row['namaprogram'];
?>
</option>
<?php
}
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, $arrLabel[$i], '', 0, 'L');
$pdf->SetX($margin + $w[0] + $w[1]);
$pdf->Cell($w[2], $ln, $arrTitik[$i], '', 0, 'L');
$pdf->SetX($margin + $w[0] + $w[1] + $w[2]);
$pdf->Cell($w[3], $ln, $arrUraian[$i], '', 1, 'L');
}
$max = 0;
$arrNomor = $pdf->SplitToArray($w[0], $ln, '');
$arrLabel = $pdf->SplitToArray($w[1], $ln, 'Program');
$arrTitik = $pdf->SplitToArray($w[2], $ln, ':');
$arrUraian = $pdf->SplitToArray($w[3], $ln, trim(nm_program($Kegiatan_bp['kddept'] . $Kegiatan_bp['kdunit'] . $Kegiatan_bp['kdprogram'])));
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, $arrLabel[$i], '', 0, 'L');
$pdf->SetX($margin + $w[0] + $w[1]);
$pdf->Cell($w[2], $ln, $arrTitik[$i], '', 0, 'L');
$pdf->SetX($margin + $w[0] + $w[1] + $w[2]);
$pdf->Cell($w[3], $ln, $arrUraian[$i], '', 1, 'L');
}
$max = 0;
$arrNomor = $pdf->SplitToArray($w[0], $ln, '');
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo $value[2];
?>
</textarea></td>
</tr>
<tr>
<td class="key">Outcome</td>
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo $value[3];
?>
</textarea></td>
</tr>
<tr>
<td class="key">Program</td>
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo nm_program($value[4] . $value[5] . $value[6]);
?>
</textarea></td>
</tr>
<tr>
<td> </td>
<td>
<form name="form" method="post" action="index.php?p=<?php
echo $_GET['p'];
?>
">
<div class="button2-right">
<div class="prev">
<a onclick="Back('index.php?p=<?php
echo $p_next;
?>
}
?>
<tr class="<?php
echo $class;
?>
">
<td align="center"><?php
echo $limit * ($pagess - 1) + ($k + 1);
?>
</td>
<td align="left">
<?php
if ($col[2][$k] . $col[3][$k] . $col[4][$k] != $col[2][$k - 1] . $col[3][$k - 1] . $col[4][$k - 1]) {
?>
<?php
echo nm_program($col[2][$k] . $col[3][$k] . $col[4][$k]);
?>
<?php
}
?>
</td>
<td align="center"><?php
echo $col[0][$k];
?>
</td>
<td align="left"><?php
echo $col[1][$k];
?>
</td>
</tr>
}
$aProgram = mysql_query($sql);
while ($Program = mysql_fetch_array($aProgram)) {
$kdprogram = $Program['KDPROGRAM'];
$real_program = realisasi_program_tw($th, $kdprogram, $kdtriwulan);
?>
<tr bordercolor="#999999" class="<?php
echo $class;
?>
">
<td width="6%" align="center"><font color="#FF0000"><?php
echo $kddept . '.' . $kdunit . '.' . $kdprogram;
?>
</font></td>
<td width="24%" align="left"><font color="#FF0000"><?php
echo nm_program($kddept . $kdunit . $kdprogram);
?>
</font></td>
<td align="right" valign="top"><font color="#FF0000"><?php
echo number_format($Program['pagu_program'], "0", ",", ".");
?>
</font></td>
<td align="right" valign="top"><font color="#FF0000"><?php
echo number_format($Program['rencana_program'], "0", ",", ".");
?>
</font></td>
<td align="center" valign="top"><font color="#FF0000"><?php
echo number_format($Program['rencana_program'] / $Program['pagu_program'] * 100, "2", ",", ".");
?>
</font></td>
<td align="right" valign="top"><font color="#FF0000"><?php
?>
" /></td>
</tr>
<tr>
<td class="key">Kode Program </td>
<td><input name="text2" type="text" value="<?php
echo $value[3];
?>
" size="10" readonly="readonly" /></td>
</tr>
<tr>
<td class="key">Program</td>
<td><textarea readonly="readonly" cols="70" rows="2"><?php
echo nm_program($th, $Outcome['kddept'] . $Outcome['kdunit'] . $Outcome['kdprogram']);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Outcome</td>
<td><textarea readonly="readonly" cols="70" rows="2"><?php
echo $Outcome['nmoutcome'];
?>
</textarea></td>
</tr>
<tr>
<td class="key">Nomor Urut Indikator </td>
<td><input name="text" type="text" value="<?php
echo $value[4];
?>