$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))); }