$hkef .= $_SESSION['lang']['budgetyear'] . " : <select name=pilihtahun0 id=pilihtahun0 onchange=\"updateTab();\"><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $opttahunbudget . "</select>";
$hkef .= "<input type=hidden id=hidden0 name=hidden0 value=\"\">";
$hkef .= "<table id=container9 class=sortable cellspacing=1 border=0 width=100%>\r\n <thead>\r\n <tr>\r\n <td align=center>" . $_SESSION['lang']['index'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['budgetyear'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['tipeanggaran'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['kodeanggaran'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['noakun'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['namaakun'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['keterangan'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['totalbiaya'] . "</td>\r\n <td align=center>" . $_SESSION['lang']['action'] . "</td>\r\n </tr> \r\n </thead>\r\n <tbody>";
//kamus kodeakun
$str = "select noakun,namaakun from " . $dbname . ".keu_5akun\r\n where detail=1 and tipeakun = 'Biaya' order by noakun\r\n ";
$optakun = "";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$akun[$bar->noakun] = $bar->namaakun;
}
$str = "select * from " . $dbname . ".bgt_budget\r\n where kodebudget like 'UMUM%' and tipebudget = '" . $tipebudget . "' and kodeorg = '" . $kodeorg . "' and tahunbudget like '%" . $pilihtahun0 . "%'\r\n order by tahunbudget desc, noakun";
// $hkef.= $str;
$res = mysql_query($str);
$no = 1;
while ($bar = mysql_fetch_object($res)) {
$hkef .= "<tr class=rowcontent title=" . $isiDta . ">\r\n <td align=center>" . $bar->kunci . "</td>\r\n <td align=center>" . $bar->tahunbudget . "</td>\r\n <td align=center>" . $bar->kodeorg . "</td>\r\n <td align=center>" . $bar->tipebudget . "</td>\r\n <td align=center>" . $bar->kodebudget . "</td>\r\n <td align=center>" . $bar->noakun . "</td>\r\n <td align=left>" . $akun[$bar->noakun] . "</td>\r\n <td align=left>" . UCFIRST($bar->keterangan) . "</td>\r\n <td align=right>" . number_format($bar->rupiah) . "</td>";
if ($bar->tutup == 0) {
$hkef .= "<td align=center><img id=\"delRow\" class=\"zImgBtn\" src=\"images/application/application_delete.png\" onclick=\"deleteRow(" . $bar->kunci . ")\" title=\"Hapus\"></td>";
} else {
$hkef .= "<td align=center> </td>";
}
$hkef .= "\r\n </tr>";
$no += 1;
}
echo $hkef;
echo "</tbody>\r\n <tfoot>\r\n </tfoot>\t\t \r\n </table>";
}
//delete row, all tab berdasarkan kunci
if ($cekapa == 'delete') {
$kunci = $_POST['kunci'];
$str = "delete from " . $dbname . ".bgt_budget \r\n where kunci='" . $kunci . "'";
public static function TEXT($S)
{
$C = array(" ", "1", "2", "3", "4", "5", "6", "7", "8", "9", "0");
return UCFIRST(STRTOLOWER(STR_REPLACE($C, "", $S)));
}
