" readonly /><br><?php
echo nm_unit($value[8]);
?>
</td>
</tr>
<tr>
<td width="104" class="key">Kegiatan</td>
<td width="608"><select name="<?php
echo $field[2];
?>
">
<option value="<?php
echo $value[2];
?>
"><?php
echo $value[2] . ' ' . substr(nm_giat($value[2]), 0, 70);
?>
</option>
<option value="">- Pilih Kegiatan -</option>
<?php
$query = mysql_query("select KdGiat, left(NmGiat,70) as namagiat from t_giat where KDDEPT='042' order by NmGiat");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['KdGiat'];
?>
"><?php
echo $row['KdGiat'] . ' ' . $row['namagiat'];
?>
</option>
<?php
echo $value[1];
?>
" disabled="disabled"/>
</label> </td>
</tr>
<tr>
<td class="key">Unit Kerja</td>
<td><textarea cols="70" rows="1" disabled="disabled"><?php
echo nm_unit($value[2]);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Kegiatan</td>
<td><textarea cols="70" rows="1" disabled="disabled"><?php
echo nm_giat($value[3]);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Program</td>
<td>
<textarea cols="70" rows="1" disabled="disabled"><?php
echo nm_program($value[1], $value[4] . $value[5] . $value[6]);
?>
</textarea></td></tr>
<tr>
<td class="key">Anggaran DIPA <?php
echo $value[1] - 1;
?>
echo $_GET['p'];
?>
" method="post" name="form">
<table width="721" cellspacing="1" class="admintable">
<tr>
<td width="104" class="key">Kegiatan</td>
<td width="608"><select name="<?php
echo $field[2];
?>
">
<option value="<?php
echo $value[2];
?>
"><?php
echo $value[2] . ' ' . nm_giat($value[2]);
?>
</option>
<option value="">- Pilih Kegiatan -</option>
<?php
$query = mysql_query("select kdgiat, left(nmgiat,60) as namagiat from tb_giat order by nmgiat");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kdgiat'];
?>
"><?php
echo $row['kdgiat'] . ' ' . $row['namagiat'];
?>
</option>
<?php
<tr>
<td class="key">UNIT ESELON</td>
<td><?php
echo nm_unit($Output_capaian['kdunitkerja']);
?>
</td>
</tr>
<tr>
<td class="key"> </td>
<td> </td>
</tr>
<tr>
<td class="key">KEGIATAN</td>
<td><?php
echo '[' . $Output_capaian['kdgiat'] . '] ' . nm_giat($Output_capaian['kdgiat']);
?>
</td>
</tr>
<tr>
<td class="key">OUTPUT</td>
<td><?php
echo '[' . $Output_capaian['kdoutput'] . '] ' . nm_output($Output_capaian['kdgiat'] . $Output_capaian['kdoutput']);
?>
</td>
</tr>
<tr>
<td class="key"> </td>
<td> </td>
</tr>
<?php
$class = "row1";
}
?>
<tr class="<?php
echo $class;
?>
">
<td align="left" valign="top"><?php
if ($col[10][$k] != $col[10][$k - 1]) {
echo nm_unit($col[10][$k]);
}
?>
</td>
<td align="left" valign="top"><?php
if ($col[10][$k] != $col[10][$k - 1] or $col[2][$k] != $col[2][$k - 1]) {
echo nm_giat($col[2][$k]);
}
?>
</td>
<td align="left" valign="top"><?php
if ($col[10][$k] != $col[10][$k - 1] or $col[16][$k] != $col[16][$k - 1]) {
echo nm_sasaran($renstra, $col[10][$k], $col[16][$k]);
}
?>
</td>
<td align="center" valign="top"><?php
echo $col[3][$k];
?>
</td>
<td align="left" valign="top"><?php
echo $col[4][$k];
if ($col[2][$k] != $col[2][$k - 1]) {
?>
<?php
echo ket_unit($col[2][$k]);
?>
<?php
}
?>
</td>
<td align="center"><?php
echo $col[3][$k];
?>
</td>
<td align="left"><?php
echo nm_giat($col[3][$k]);
?>
</td>
<td align="right"><?php
echo number_format($col[7][$k], "0", ",", ".");
?>
</td>
<td align="left"><?php
echo pjawaqb_giat($col[1][$k], $col[3][$k]);
?>
</td>
<td align="center"><a href="index.php?p=126&u=<?php
echo $col[2][$k];
?>
&g=<?php
echo $col[3][$k];
<td>
<?php
$sql = "SELECT iku FROM m_iku_program WHERE kddeputi = '" . substr($Kegiatan_bp[kdunitkerja], 0, 3) . '000' . "'";
$oIKU = mysql_query($sql);
$n = 0;
while ($IKU = mysql_fetch_array($oIKU)) {
$n += 1;
echo $n . ". " . $IKU['iku'] . "<br>";
}
?>
</td>
</tr>
<tr>
<td class="key">Kegiatan</td>
<td><strong><?php
echo nm_giat($Kegiatan_bp['kdgiat']);
?>
</strong></td>
</tr>
<tr>
<td class="key">IKK</td>
<td>
<?php
$sql = "SELECT ikk FROM m_ikk_kegiatan WHERE kdgiat = '" . $Kegiatan_bp[kdgiat] . "'";
$oIKK = mysql_query($sql);
$n = 0;
while ($IKK = mysql_fetch_array($oIKK)) {
$n += 1;
echo $n . ". " . $IKK['ikk'] . "<br>";
}
?>
$List_kak_output = mysql_fetch_array($oList_kak_output);
?>
<div class="button2-right">
<div class="prev"><a onclick="Back('index.php?p=<?php
echo $p_next;
?>
&pagess=<?php
echo $pagess;
?>
')">Kembali</a></div>
</div><br><br>
<?php
echo "<strong> Tahun Anggaran : " . $th . "</strong><br>";
echo "<strong> Unit Kerja : [" . $List_kak_output['kdunitkerja'] . '] ' . nm_unit($List_kak_output['kdunitkerja']) . "</strong><br>";
echo "<strong> Satker : [" . $kdsatker . '] ' . nm_satker($kdsatker) . "</strong><br>";
echo "<strong> Kegiatan : [" . $kdgiat . '] ' . nm_giat($kdgiat) . "</strong>";
?>
<br />
<table width="738" cellpadding="1" class="adminlist">
<thead>
<tr>
<th width="10%">Kode APBN</th>
<th colspan="4">Ooutput / Sub Output <br>
Komponen / Sub Komponen <br>
Akun / Uraian </th>
<th width="14%">Anggaran</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM thbp_kak_kegiatan WHERE th = '{$th}' and kdprogram = '{$kdprogram}' and kdunitkerja = '{$xkdunit}' ORDER BY kdgiat";
break;
case '6':
$sql = "SELECT * FROM thbp_kak_kegiatan WHERE th = '{$th}' and kdprogram = '{$kdprogram}' and kdunitkerja = '{$kdunitkerja}' ORDER BY kdgiat";
break;
default:
$sql = "SELECT * FROM thbp_kak_kegiatan WHERE th = '{$th}' and kdprogram = '{$kdprogram}' and kdunitkerja = '{$kdunitkerja}' ORDER BY kdgiat";
break;
}
$oGiat = mysql_query($sql);
while ($Giat = mysql_fetch_array($oGiat)) {
$kdgiat = $Giat['kdgiat'];
$pdf->SetFont($font, 'B', $size - 1);
$max = 0;
$arrKode = $pdf->SplitToArray($w[0], $ln, $kdgiat);
$arrUraian = $pdf->SplitToArray($w[1], $ln, trim(nm_giat($kdgiat)));
$arrPaguDipa = $pdf->SplitToArray($w[2], $ln, number_format($Giat['jml_anggaran_dipa'], "0", ",", "."));
$arrPaguIni = $pdf->SplitToArray($w[3], $ln, number_format($Giat['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');
}
<td width="458"><input type="text" size="10" value="<?php
echo $th;
?>
" disabled="disabled"/></td>
</tr>
<tr>
<td class="key">Unit Kerja </td>
<td><textarea name="" cols="70" rows="1" disabled="disabled"><?php
echo nm_unit($kdunitkerja);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Kegiatan</td>
<td><textarea name="" cols="70" rows="2" disabled="disabled"><?php
echo '[' . $kdgiat . '] ' . nm_giat($kdgiat);
?>
</textarea></td>
</tr>
<?php
$sql = "SELECT jml_anggaran_renstra,jml_anggaran_dipa,jml_anggaran_indikatif FROM thbp_kak_kegiatan WHERE th = '{$th}' and kdgiat = '" . $kdgiat . "' and kdunitkerja = '{$kdunitkerja}' ";
$qu = mysql_query($sql);
$row = mysql_fetch_array($qu);
?>
<tr>
<td class="key">Anggaran DIPA <?php
echo $th - 1;
?>
</td>
<td><input type="text" size="30" value="<?php
echo $id_o_bp;
?>
" method="post" name="form">
<table cellspacing="1" class="admintable">
<tr>
<td class="key">Tahun</td>
<td><input type="text" name="th" size="10" value="<?php
echo $Output_uk['th'];
?>
" readonly/></td>
</tr>
<tr>
<td class="key">Kegiatan</td>
<td><input name="kdgiat" type="text" value="<?php
echo nm_giat($Output_uk['kdgiat']);
?>
" size="70" readonly/></td>
</tr>
<tr>
<td class="key">Output</td>
<td><textarea name="kdoutput" cols="70" rows="3" readonly><?php
echo nm_output($Output_uk['kdgiat'] . $Output_uk['kdoutput']);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Kode Sub Output</td>
<td><input type="text" name="kdsuboutput" size="10" value="<?php
echo @$value['kdsuboutput'];
?>
break;
case 11:
$sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5, $real_6, $real_7, $real_8, $real_9, $real_10, $real_11);
break;
case 12:
$sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5, $real_6, $real_7, $real_8, $real_9, $real_10, $real_11, $real_12);
break;
}
$sbx_grafik_1 = array($pagu_1, $pagu_2, $pagu_3, $pagu_4, $pagu_5, $pagu_6, $pagu_7, $pagu_8, $pagu_9, $pagu_10, $pagu_11, $pagu_12);
$leg = array("Jan", "Peb", "Mar", "Apr", "Mei", "Jun", "Jul", "Agt", "Sep", "Okt", "Nop", "Des");
$graph = new Graph(1500, 800, "auto");
$graph->SetScale('textint');
$graph->img->SetMargin(50, 50, 50, 50);
$graph->SetShadow();
$graph->title->Set("Realisasi Anggaran Tahun " . $th);
$graph->subtitle->Set('SKegiatan : ' . trim(nm_giat($kdgiat)));
$graph->title->SetFont(FF_ARIAL, FS_BOLD, 20);
$graph->subtitle->SetFont(FF_ARIAL, FS_BOLD, 14);
$graph->xaxis->title->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->yaxis->title->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->SetTickLabels($leg);
$graph->legend->Pos(0.1, 0.09);
$graph->legend->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->title->Set("Bulan");
$graph->yaxis->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->legend->Pos(0.8, 0.13, "right", "center");
$bplot1 = new LinePlot($sbx_grafik_1);
$bplot1->mark->SetType(MARK_FILLEDCIRCLE);
$bplot1->mark->SetFillColor("red");
$bplot1->mark->SetWidth(8);
<tr class="<?php
echo $class;
?>
">
<td align="left" valign="top"><?php
echo ket_unit($Unitkerja['kdunitkerja']);
?>
</td>
<td align="center" valign="top"><?php
echo $Unitkerja['kdgiat'];
?>
</td>
<td align="left" valign="top"><?php
echo nm_giat($Unitkerja['kdgiat']);
?>
</td>
<td align="right" valign="top"><?php
echo number_format($Unitkerja['jml_anggaran_dipa'], "0", ",", ".");
?>
</td>
<td align="right" valign="top"><?php
echo number_format($Unitkerja['jml_anggaran_indikatif'], "0", ",", ".");
?>
</td>
<td align="center" valign="top"><a href="index.php?p=452&q=<?php
echo $Unitkerja['id'];
?>
" title="Edit Kegiatan">
<img src="css/images/edit_f2.png" border="0" width="16" height="16"><font size="1">Kegiatan>></font></a><br />
<?php
}
?>
</select> </td>
</tr>
<tr>
<td width="104" class="key">Kegiatan</td>
<td width="608"><select name="<?php
echo $field[3];
?>
">
<option value="<?php
echo $value[3];
?>
"><?php
echo $value[3] . ' ' . nm_giat($value[3]);
?>
</option>
<option value="">- Pilih Kegiatan -</option>
<?php
$query = mysql_query("select kdgiat, left(nmgiat,60) as namagiat from tb_giat order by nmgiat");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kdgiat'];
?>
"><?php
echo $row['kdgiat'] . ' ' . $row['namagiat'];
?>
</option>
<?php
}
$aGiat = mysql_query($sql);
while ($Giat = mysql_fetch_array($aGiat)) {
$kdgiat = $Giat['KDGIAT'];
$real_giat = realisasi_giat_tw($th, $kdsatker, $kdgiat, $kdtriwulan);
?>
<tr class="<?php
echo $class;
?>
">
<td align="center" valign="top"><span class="style1"><?php
echo $Giat['KDGIAT'];
?>
</span></td>
<td align="left" valign="top"><span class="style1"><?php
echo nm_giat($Giat['KDGIAT']);
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
echo number_format($Giat['pagu_giat'], "0", ",", ".");
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
echo number_format($Giat['rencana_giat'], "0", ",", ".");
?>
</span></td>
<td align="center" valign="top"><span class="style1"><?php
echo number_format($Giat['rencana_giat'] / $Giat['pagu_giat'] * 100, "2", ",", ".");
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
if ($col[0][$k] != $col[0][$k - 1]) {
?>
<?php
echo $col[0][$k];
?>
<?php
}
?>
</td>
<td align="left">
<?php
if ($col[0][$k] != $col[0][$k - 1]) {
?>
<?php
echo nm_giat($col[0][$k]);
?>
<?php
}
?>
</td>
<td align="center"><?php
echo $col[1][$k];
?>
</td>
<td align="left"><?php
echo $col[2][$k];
?>
</td>
<td align="left"><?php
<th>Kode APBN</th>
<th colspan="3"><font color="#0FA40B">Kegiatan</font> / <font color="#FF0000">Output</font> / Akun / <font color="#3333FF">SPM </font></th>
<th>Realisasi<br />Anggaran SPM</th>
</tr>
</thead>
<tbody>
<tr class="<?php
echo $class;
?>
">
<td width="6%" align="center"><font color="#0FA40B"><strong><?php
echo $kdgiat;
?>
</strong></font></td>
<td colspan="3" align="left"><font color="#0FA40B"><strong><?php
echo nm_giat($kdgiat);
?>
</strong></font></td>
<td width="12%" align="right"><font color="#0FA40B"><strong><?php
echo number_format(real_giat_spm($th, $kdsatker, $kdgiat), "0", ",", ".");
?>
</strong></font></td>
</tr>
<?php
if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $table_1 . "'")) == 1 and mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $table_2 . "'")) == 1) {
$sql = "select sum(totnilmak) as real_giat from {$table_1} WHERE thang='{$th}' AND kdsatker='{$kdsatker}' and kdgiat='{$kdgiat}' group by kdgiat";
$aGiat = mysql_query($sql);
$Giat = mysql_fetch_array($aGiat);
$sql = "select kdoutput, sum(totnilmak) as real_output from {$table_1} WHERE thang='{$th}' and kdsatker='{$kdsatker}' and kdgiat='{$kdgiat}' group by kdoutput order by kdoutput";
$aOutput = mysql_query($sql);
while ($Output = mysql_fetch_array($aOutput)) {
<tr>
<td class="key">UNIT ESELON</td>
<td><?php
echo nm_unit($Output_bp['kdunitkerja']);
?>
</td>
</tr>
<tr>
<td class="key"> </td>
<td> </td>
</tr>
<tr>
<td class="key">KEGIATAN</td>
<td><?php
echo '[' . $Output_bp['kdgiat'] . '] ' . nm_giat($Output_bp['kdgiat']);
?>
</td>
</tr>
<tr>
<td class="key">OUTPUT</td>
<td><?php
echo '[' . $Output_bp['kdoutput'] . '] ' . nm_output($Output_bp['kdgiat'] . $Output_bp['kdoutput']);
?>
</td>
</tr>
<tr>
<td class="key"> </td>
<td> </td>
</tr>
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$sql = "select sum(TOTNILMAK) as real_output from {$table} WHERE THANG='{$th}' AND KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT = '{$kdoutput}' group by KDOUTPUT";
$aGiat = mysql_query($sql);
$Giat = mysql_fetch_array($aGiat);
?>
<div class="button2-right">
<div class="prev"><a onclick="Back('index.php?p=<?php
echo $p_next;
?>
')">Kembali</a></div>
</div><br><br>
<?php
echo "<strong> Tahun Anggaran : " . $th . "</strong><br>";
echo "<strong> Satker : " . nm_satker($kdsatker) . "</strong><br>";
echo "<strong> Kegiatan : " . nm_giat($kdgiat) . "</strong>";
?>
<br />
<table width="738" cellpadding="1" class="adminlist">
<thead>
<tr>
<th width="6%">Kode APBN</th>
<th colspan="5"><font color="#FF0000">Output</font> / Akun / <font color="#3333FF">SPM & SP2D</font></th>
<th width="12%">Anggaran</th>
</tr>
</thead>
<tbody>
<?php
$sql = "select KDOUTPUT, sum(TOTNILMAK) as real_output from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT = '{$kdoutput}' group by KDOUTPUT order by KDOUTPUT";
$aOutput = mysql_query($sql);
$pdf->SetY($y);
$pdf->Cell(0, $ln, $Kegiatan_bp['th'] - 1, '', 1, 'C');
//------------------------------------------------------- akhir cover
$pdf->AddPage();
$margin = 10;
$ln = 5;
$w = array(10, 30, 5, 140);
$pdf->SetFont($font, 'B', $size + 3);
$y = $pdf->GetY() + 10;
$pdf->Ln();
$pdf->SetXY($margin + $w[0], $y);
$pdf->Cell($w[0] + $w[1] + $w[2] + $w[3], $ln, 'KERANGKA ACUAN KERJA KEGIATAN', '', 1, 'C');
$y = $pdf->GetY();
$pdf->Ln();
$max = 0;
$arrUraian = $pdf->SplitToArray($w[1] + $w[2] + $w[3], $ln, trim(nm_giat($Kegiatan_bp['kdgiat'])));
if ($max < count($arrUraian)) {
$max = count($arrUraian);
}
for ($i = 0; $i < $max; $i++) {
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1] + $w[2] + $w[3], $ln, $arrUraian[$i], '', 1, 'C');
}
$y = $pdf->GetY() + 5;
$pdf->SetXY($margin + $w[0], $y);
$pdf->Cell($w[0] + $w[1] + $w[2] + $w[3], $ln, '', '', 1, 'C');
$pdf->SetFont($font, 'B', $size + 2);
$pdf->SetX($margin);
$pdf->Cell($w[0], $ln, '', '', 0, 'C');
$pdf->SetX($margin + $w[0]);
$pdf->Cell($w[1], $ln, 'A. Keterangan Umum', '', 1, 'L');
<meta http-equiv="refresh" content="0;URL=index.php?p=<?php
echo $p_next;
?>
"><?php
exit;
} else {
$value = get_value($table, $field, "id='" . $_GET['q'] . "'");
}
?>
<table width="551" cellspacing="1" class="admintable">
<tr>
<td width="115" class="key">Kegiatan</td>
<td width="427"><input type="text" size="60" readonly="readonly" value="<?php
echo nm_giat($value[2]);
?>
" /></td>
</tr>
<tr>
<td class="key">Output</td>
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo nm_output($value[2] . $value[3]);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Indikator</td>
<td><textarea readonly="readonly" cols="60" rows="3"><?php
echo $value[4];
}
?>
</strong></td>
<td align="center"><strong><?php
echo $col[10][$k];
?>
</strong></td>
<td align="center"><strong><?php
echo $col[3][$k];
?>
</strong></td>
<td colspan="2" align="left"><strong><?php
echo nm_satker($col[10][$k]);
?>
<br /><?php
echo '(' . nm_giat($col[3][$k]) . ')';
?>
</strong></td>
<td align="right"><strong><?php
echo number_format(pagu_giat($col[1][$k], $col[2][$k], $col[3][$k]), "0", ",", ".");
?>
</strong></td>
<td width="11%" align="center"> </td>
</tr>
<?php
$th = $col[1][$k];
$kdunitkerja = $col[2][$k];
$kdsatker = $col[10][$k];
$kdgiat = $col[3][$k];
$oList_kak_output = mysql_query("SELECT * FROM thbp_kak_output WHERE th = '{$th}' AND kdgiat = '{$kdgiat}' and kdsatker = '{$kdsatker}' ORDER BY kdoutput");
while ($List_kak_output = mysql_fetch_array($oList_kak_output)) {
