<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); include 'master_mainMenu.php'; ?> <script language=javascript src='js/keu_alokasiByLain.js'></script> <?php $optPeriode = ''; for ($x = 0; $x <= 12; $x++) { $dt = mktime(0, 0, 0, date('m') - $x, 15, date('Y')); $optPeriode .= "<option value='" . date('Y-m', $dt) . "'>" . date('m-Y', $dt) . "</option>"; } $str = "select * from " . $dbname . ".sdm_5tipekaryawan where id>0"; $res = mysql_query($str); $opttipe = ""; while ($bar = mysql_fetch_object($res)) { $opttipe .= "<option value='" . $bar->id . "'>" . $bar->tipe . "</option>"; } OPEN_BOX('', $_SESSION['lang']['alokasitambahan']); echo "<fieldset><table>\r\n <tr><td>" . $_SESSION['lang']['periode'] . "</td><td>:<select id=periode>" . $optPeriode . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['tipekaryawan'] . "</td><td>:<select id=tipekaryawan>" . $opttipe . "</select></td></tr>\r\n <tr><td colspan=2>\r\n <button class=mybutton onclick=displayForm()>" . $_SESSION['lang']['tampilkan'] . "</button>\r\n <button class=mybutton onclick=dataKeExcel()>Spreadsheet</button>\r\n </td></tr> \r\n </table>\r\n </fieldset> \r\n\t <div id=container style='height:400px; overflow:scroll'>\r\n\t </div>"; CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include_once 'lib/nangkoelib.php'; include_once 'lib/zLib.php'; echo open_body(); ?> <script language=javascript1.2 src='js/vhc_kegiatan.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['vhc_kegiatan']); // Akun dari Kelompok Kegiatan $optAkunKeg = makeOption($dbname, 'setup_klpkegiatan', "noakun,noakun"); $whereAkun = ""; //foreach($optAkunKeg as $akun) { // if(!empty($whereAkun)) $whereAkun .= " OR "; // $whereAkun .= "noakun LIKE '".$akun."%'"; //} if ($_SESSION['language'] == 'EN') { $dd = 'namaakun1'; } else { $dd = 'namaakun'; } $str = "select noakun," . $dd . " as namakegiatan from " . $dbname . ".keu_5akun where detail=1 "; if (!empty($whereAkun)) { $str .= " and (" . $whereAkun . ")"; } //echo $str; $str .= "order by noakun";
<td><select id=tahun style='width:200px;' onchange="getUnit2()"><?php echo $optthn; ?> </select></td> </tr> <tr><td><label><?php echo $_SESSION['lang']['kontraktor']; ?> </label></td> <td><select id=kontaktor style='width:200px;' ><?php echo $optUnit; ?> </select></td> </tr> <tr> <td colspan="3"> <?php echo " <button onclick=\"zPreview('summary_slave_progress_spk2','" . $arr2 . "','reportcontainer')\" class=\"mybutton\" name=\"preview\" id=\"preview\">" . $_SESSION['lang']['preview'] . "</button>\r\n <button onclick=\"zExcel(event,'summary_slave_progress_spk2.php','" . $arr2 . "','reportcontainer')\" class=\"mybutton\" name=\"excel\" id=\"excel\">" . $_SESSION['lang']['excel'] . "</button> \r\n <!--<button onclick=\"zPdf('summary_slave_progress_spk2','" . $arr2 . "','reportcontainer')\" class=\"mybutton\" name=\"pdf\" id=\"pdf\">" . $_SESSION['lang']['pdf'] . "</button>-->"; ?> </td> </tr> </table> </fieldset> <?php CLOSE_BOX(); OPEN_BOX('', 'Result:'); echo "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend>\r\n <div id='reportcontainer' style='width:100%;height:550px;overflow:scroll;background-color:#FFFFFF;'></div> \r\n </fieldset>"; CLOSE_BOX(); close_body(); exit;
//pilihan regional tab0 $str = "select regional, nama from " . $dbname . ".bgt_regional\r\n order by nama desc\r\n "; $optregional0 = ""; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optregional0 .= "<option value='" . $bar->regional . "'>" . $bar->nama . "</option>"; } //pilihan kelompok tab0 $str = "select kode, kelompok from " . $dbname . ".log_5klbarang\r\n order by kode \r\n "; $optkelompokbarang0 = ""; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optkelompokbarang0 .= "<option value='" . $bar->kode . "'>" . $bar->kode . " - " . $bar->kelompok . "</option>"; } //atas OPEN_BOX('', "<b>" . $_SESSION['lang']['hargabarang'] . "</b>"); //tab0 $frm[0] .= "<fieldset id=tab0><legend>per " . $_SESSION['lang']['kelompokbarang'] . "</legend>"; $frm[0] .= "<table cellspacing=1 border=0>\r\n <tr><td>" . $_SESSION['lang']['budgetyear'] . "</td><td>:</td><td>\r\n <select id=tahunbudget0 name=tahunbudget0 style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $opttahunbudget0 . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['regional'] . " </td><td>:</td><td>\r\n <select id=regional0 name=regional0 style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optregional0 . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['kelompokbarang'] . " </td><td>:</td><td>\r\n <select id=kelompokbarang0 name=kelompokbarang0 style='width:150px;'><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $optkelompokbarang0 . "</select></td></tr>\r\n <tr><td colspan=3>\r\n <button class=mybutton id=proses0 name=proses0 onclick=proses0()>" . $_SESSION['lang']['proses'] . "</button>\r\n <input type=hidden id=tersembunyi0 name=tersembunyi0 value=tersembunyi >\r\n </td></tr></table>"; $frm[0] .= "</fieldset>"; //box dalam tab0, daftar table $frm[0] .= "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend> \r\n<div id=container0></div>\r\n "; $frm[0] .= "</fieldset>"; //tab 1 $frm[1] .= "<fieldset id=tab1><legend>" . $_SESSION['lang']['caribarang'] . "</legend>"; $frm[1] .= "<table cellspacing=1 border=0>\r\n <tr><td>" . $_SESSION['lang']['budgetyear'] . "</td><td>:</td><td>\r\n <select id=tahunbudget1 name=tahunbudget1 style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $opttahunbudget0 . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['regional'] . " </td><td>:</td><td>\r\n <select id=regional1 name=regional1 style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optregional0 . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['namabarang'] . " </td><td>:</td><td>\r\n <input type=text class=myinputtext id=namabarang1 name=namabarang1 maxlength=10 style=width:150px;/>\r\n <tr><td colspan=3>\r\n <button class=mybutton id=proses1 name=proses1 onclick=proses1()>" . $_SESSION['lang']['proses'] . "</button>\r\n <input type=hidden id=tersembunyi1 name=tersembunyi1 value=tersembunyi >\r\n </td></tr></table>"; $frm[1] .= "</fieldset>"; //box dalam tab0, daftar table $frm[1] .= "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend> \r\n<div id=container1></div>\r\n "; $frm[1] .= "</fieldset>"; //========================
$dt = mktime(0, 0, 0, 0, 15, date('Y') + $x); $optper .= "<option value=" . date("Y", $dt) . ">" . date("Y", $dt) . "</option>"; } $optOrg2 = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $sOrg2 = "select kodeorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "' order by kodeorganisasi asc"; $qOrg2 = mysql_query($sOrg2) or die(mysql_error()); while ($rOrg2 = mysql_fetch_assoc($qOrg2)) { $optOrg2 .= "<option value=" . $rOrg2['kodeorganisasi'] . ">" . $rOrg2['kodeorganisasi'] . "</option>"; } $optStatusLst = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $arrStatus = array("0" => "Belum Posting", "1" => "Sudah diposting"); foreach ($arrStatus as $lstStatus => $vwStatus) { $optStatusLst .= "<option value='" . $lstStatus . "'>" . $vwStatus . "</option>"; } //<button class=mybutton id=create_new name=create_new onclick=createNew() >".$_SESSION['lang']['new']."</button> OPEN_BOX('', "<b>" . $_SESSION['lang']['vhc_pekerjaan'] . "</b>"); $frm[0] .= "<fieldset><legend>" . $_SESSION['lang']['header'] . "</legend>"; $frm[0] .= "<table cellspacing=1 border=0>\n<tr><td>" . $_SESSION['lang']['notransaksi'] . "</td><td>:</td><td><select id=KbnId name=KbnId onchange=\"createNew()\">" . $optOrg2 . "</select>\n<input type=text id=no_trans name=no_trans disabled=disabled class=myinputtext style=width:150px; /></td></tr>\n<!--<tr><td>" . $_SESSION['lang']['thnKontrak'] . " </td><td>:</td><td>\n<select id=thnKntrk name=thnKntrk style='width:150px;' onchange=\"getKntrk('','')\"><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optper . "</select> </td></tr>\n<tr><td>" . $_SESSION['lang']['NoKontrak'] . "</td><td>:</td><td>\n<select id=noKntrk name=noKntrk style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option></select></td></tr>\n<tr><td>" . $_SESSION['lang']['statPremi'] . "</td><td>:</td><td>\n<select id=premiStat name=premiStat style=width:150px;>" . $optStatPremi . "</select></td></tr>-->\n<tr><td>" . $_SESSION['lang']['jenisvch'] . "</td><td>:</td><td>\n<select id=jns_vhc name=jns_vhc style=width:150px; onchange=\"get_kd('')\"><option value=>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optJnsvhc . "</select></td></tr>\n<tr><td>" . $_SESSION['lang']['kodetraksi'] . "</td><td>:</td><td>\n<select id=kodetraksi name=kodetraksi style=width:150px; onchange=\"get_kd('')\"><option value=>" . $_SESSION['lang']['all'] . "</option>" . $optTraksi . "</select></td></tr>\n<tr><td>" . $_SESSION['lang']['kodevhc'] . "</td><td>:</td><td>\n<select id=kde_vhc name=kde_vhc style=width:150px;><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option></select></td></tr>\n<tr><td>" . $_SESSION['lang']['tanggal'] . "</td><td>:</td><td>\n<input type=text class=myinputtext id=tgl_pekerjaan name=tgl_pekerjaan onmousemove=\"setCalendar(this.id)\" onkeypress=\"return false\"; maxlength=10 style=width:150px; /></td></tr>\n<tr><td>" . $_SESSION['lang']['vhc_jenis_bbm'] . "</td><td>:</td><td>\n<select id=jns_bbm name=jns_bbm style=width:150px;>" . $optJnsBBMvhc . "</select></td></tr>\n<tr><td>" . $_SESSION['lang']['vhc_jumlah_bbm'] . "</td><td>:</td><td>\n<input type=text class=myinputtextnumber id=jmlh_bbm name=jmlh_bbm maxlength=60 onkeypress=\"return angka_doang(event);\" style=width:150px; /></td></tr>\n<tr><td colspan=3>\n<button class=mybutton id=save_kepala name=save_kepala onclick=save_header() disabled >" . $_SESSION['lang']['save'] . "</button><button class=mybutton id=cancel_kepala name=cancel_kepala onclick=cancel_kepala_form() disabled >" . $_SESSION['lang']['cancel'] . "</button><button class=mybutton id=done_entry name=done_entry onclick=doneEntry() disabled >" . $_SESSION['lang']['done'] . "</button>\n\n<input type=hidden id=proses name=proses value=insert_header >\n</td></tr></table>"; $frm[0] .= "</fieldset>"; $frm[0] .= "<fieldset><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>\n<fieldset style=\"float: left;\"><legend>" . $_SESSION['lang']['find'] . " Data</legend>\n <table cellspacing=\"1\" border=\"0\"><tr>\n <td>" . $_SESSION['lang']['notransaksi'] . "</td>\n <td><input type=\"text\" id='txtCari' name='txtCari' style='width:150px' class=myinputtext />\n " . $_SESSION['lang']['tanggal'] . ":<input type=text class=myinputtext id=tgl_cari onmousemove=setCalendar(this.id) onkeypress=return false; size=10 maxlength=10 />\n " . $_SESSION['lang']['status'] . ":<select id=statusInputan>" . $optStatusLst . "</select>\n <button class=mybutton id=cariTransaksi name=cariTransaksi onclick=cariDataTransaksi() >" . $_SESSION['lang']['find'] . "</button><button class=mybutton onclick=load_data() >" . $_SESSION['lang']['cancel'] . "</button>\n</td></tr></table></fieldset>\n<table cellspacing=1 border=0 class=sortable>\n\t\t<thead>\n\t\t<tr class=\"rowheader\">\n\t\t<td>No.</td>\n\t\t<td>" . $_SESSION['lang']['notransaksi'] . "</td>\n\t\t<td>" . $_SESSION['lang']['jenisvch'] . "</td>\n\t\t<td>" . $_SESSION['lang']['kodevhc'] . "</td>\n\t\t<td>" . $_SESSION['lang']['tanggal'] . "</td>\n\t\t<td>" . $_SESSION['lang']['vhc_jenis_bbm'] . "</td>\n\t\t<td>" . $_SESSION['lang']['vhc_jumlah_bbm'] . "</td>\n\t\t<td>Action</td>\n\t\t</tr></thead><tbody id=contain>\n\t\t<script>load_data()</script>\n\t\t"; $frm[0] .= "</tbody></table></fieldset>"; //Detail Pekerjaan $sjnskrj = "select * from " . $dbname . ".vhc_kegiatan order by noakun asc"; $qjnskrj = mysql_query($sjnskrj) or die(mysql_error()); $optJnsKerja = ''; while ($rjnskrj = mysql_fetch_assoc($qjnskrj)) { $optJnsKerja .= "<option value=" . $rjnskrj['kodekegiatan'] . ">" . $rjnskrj['noakun'] . " - " . $rjnskrj['namakegiatan'] . "</option>"; } $slokTgs = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi where `tipe` NOT\nIN ('PT', 'BLOK', 'STATION', 'STENGINE','AFDELING')"; //IN ('PT', 'BLOK', 'HOLDING', 'STATION', 'STENGINE','AFDELING')"; $qlokTgs = mysql_query($slokTgs) or die(mysql_error());
$optpt .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; } //=================ambil unit; $str = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi\r\n where (tipe='KEBUN' or tipe='PABRIK' or tipe='KANWIL'\r\n or tipe='HOLDING') and induk!=''\r\n "; $res = mysql_query($str); // $optgudang="<option value=''>".$_SESSION['lang']['all']."</option>"; while ($bar = mysql_fetch_object($res)) { $optgudang .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; } } else { $optpt = ""; $optpt .= "<option value='" . $_SESSION['empl']['kodeorganisasi'] . "'>" . $_SESSION['empl']['kodeorganisasi'] . "</option>"; $optgudang .= "<option value='" . $_SESSION['empl']['lokasitugas'] . "'>" . $_SESSION['empl']['lokasitugas'] . "</option>"; } //atas OPEN_BOX('', "<b>" . $_SESSION['lang']['upahharian'] . "</b>"); //box dalam tab 0 $frm[0] .= "<fieldset><legend>" . $_SESSION['lang']['upahkerja'] . "" . $thn_skrg . "</legend>"; $frm[0] .= "<table cellspacing=1 border=0>\r\n <tr><td>" . $_SESSION['lang']['budgetyear'] . " </td><td>:</td><td>\r\n <input type=text class=myinputtext onkeyup=\"resetcontainer();\" id=tahunbudget name=tahunbudget onkeypress=\"return angka_doang(event);\" maxlength=4 style=width:150px; /></td></tr>\r\n <tr><td>" . $_SESSION['lang']['kodeorg'] . "</td><td>:</td><td>\r\n <select id=kodeorg onchange=\"resetcontainer();\" name=kodeorg style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optgudang . "</select></td></tr>\r\n <tr><td colspan=3>\r\n <button class=mybutton id=proses name=proses onclick=prosesUpah()>" . $_SESSION['lang']['proses'] . "</button>\r\n <input type=hidden id=tersembunyi name=tersembunyi value=tersembunyi >\r\n </td></tr></table>"; $frm[0] .= "</fieldset>"; //box bawah di dalam tab 0 //box bawahnya di dalam tab 0 $frm[0] .= "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend> \r\n<div id=container></div>\r\n "; $frm[0] .= "</fieldset>"; //Ambil data yang sudah ada, buat list daftar tahun budget $str = "select tahunbudget from " . $dbname . ".bgt_upah\r\n where kodeorg = '" . substr($_SESSION['empl']['lokasitugas'], 0, 4) . "'\r\n group by tahunbudget order by tahunbudget"; $res = mysql_query($str); $opttahun = ""; while ($bar = mysql_fetch_object($res)) { $opttahun .= "<option value='" . $bar->tahunbudget . "'>" . $bar->tahunbudget . "</option>"; }
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); include 'master_mainMenu.php'; ?> <script language=javascript src='js/pmn_kontrakjual.js'></script> <script language="javascript" src="js/zMaster.js"></script> <?php OPEN_BOX('', $_SESSION['lang']['kontrakjual']); $sBrg = "select namabarang,kodebarang from " . $dbname . ".log_5masterbarang where `kelompokbarang`='400'"; $qBrg = mysql_query($sBrg) or die(mysql_error()); while ($rBrg = mysql_fetch_assoc($qBrg)) { $optBrg .= "<option value=" . $rBrg['kodebarang'] . ">" . $rBrg['namabarang'] . "</option>"; } $sCust = "select kodecustomer,namacustomer from " . $dbname . ".pmn_4customer order by namacustomer"; $qCust = mysql_query($sCust) or die(mysql_error($sCust)); while ($rCust = mysql_fetch_assoc($qCust)) { $optCust .= "<option value=" . $rCust['kodecustomer'] . ">" . $rCust['namacustomer'] . "</option>"; } $sOrg = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi where tipe='PT'"; //echo $sOrg; $qOrg = mysql_query($sOrg) or die(mysql_error()); while ($rOrg = mysql_fetch_assoc($qOrg)) { $optPt .= "<option value=" . $rOrg['kodeorganisasi'] . ">" . $rOrg['namaorganisasi'] . "</option>"; } $arrKurs = array("IDR", "USD"); foreach ($arrKurs as $dt) { $optKurs .= "<option value=" . $dt . ">" . $dt . "</option>";
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src='js/sdm_rapel_kebun.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['rapel']); $optPeriode = '<option value=""></option>'; $sGp = "select DISTINCT periode from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and `sudahproses`=0 order by periode desc limit 0,6"; $qGp = mysql_query($sGp) or die(mysql_error()); while ($rGp = mysql_fetch_assoc($qGp)) { $optPeriode .= "<option value=" . $rGp['periode'] . ">" . substr(tanggalnormal($rGp['periode']), 1, 7) . "</option>"; } if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') { $str1 = "select * from " . $dbname . ".datakaryawan\r\n where ((tanggalkeluar='0000-00-00') or tanggalkeluar >'" . date('Y') . "-01-01" . "')\r\n\t and tipekaryawan!=0 and lokasitugas='" . $_SESSION['empl']['lokasitugas'] . "'\r\n\t order by namakaryawan"; } else { $str1 = "select * from " . $dbname . ".datakaryawan\r\n where ((tanggalkeluar='0000-00-00') or tanggalkeluar >'" . date('Y') . "-01-01" . "')\r\n\t and tipekaryawan!=0 and LEFT(lokasitugas,4)='" . substr($_SESSION['empl']['lokasitugas'], 0, 4) . "'\r\n\t order by namakaryawan"; } //echo"$str1"; $res1 = mysql_query($str1, $conn); $optIdKaryawan = '<option value=""></option>'; while ($bar1 = mysql_fetch_object($res1)) { $optIdKaryawan .= "<option value=" . $bar1->karyawanid . ">" . $bar1->namakaryawan . "</option>"; $nama[$bar1->karyawanid] = $bar1->namakaryawan; } $strKom = "select * from " . $dbname . ".sdm_ho_component where id in('14','24')";
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_payrollHO.js></script> <link rel=stylesheet type=text/css href=style/payroll.css> <?php include 'master_mainMenu.php'; //+++++++++++++++++++++++++++++++++++++++++++++ //list employee OPEN_BOX('', '<b>PAYROLL ENTRY:</b>'); echo "<div id=EList>"; echo OPEN_THEME('Create monthly payroll: PERIOD <font color=red>' . substr($_SESSION['pyperiode'], 5, 2) . "/" . substr($_SESSION['pyperiode'], 0, 4)) . "</font>"; //cek if new employee exist $prestr = "select distinct karyawanid from " . $dbname . ".sdm_ho_employee order by karyawanid"; $preres = mysql_query($prestr, $conn); $arrid = ''; while ($prebar = mysql_fetch_object($preres)) { if ($arrid == '') { $arrid .= $prebar->karyawanid; } else { $arrid .= "," . $prebar->karyawanid; } } if ($arrid == '') { $arrid = "'null'"; } $str = "select karyawanid,namakaryawan,statuspajak,tanggalkeluar,npwp from " . $dbname . ".datakaryawan\r\n\t\t where karyawanid not in(" . $arrid . ") and alokasi=1";
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; include_once 'lib/zLib.php'; echo open_body(); ?> <script language=javascript1.2 src='js/budget_regional_assignment.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['input'] . ' ' . $_SESSION['lang']['regional'] . ' Assignment'); //ambil organisasi $optorg = ''; $str = "select kodeorganisasi, namaorganisasi from " . $dbname . ".organisasi \r\n where char_length(kodeorganisasi) = 4\r\n order by kodeorganisasi"; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optorg .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->kodeorganisasi . " - " . $bar->namaorganisasi . "</option>"; } //ambil regional $optreg = ''; $str = "select regional, nama from " . $dbname . ".bgt_regional \r\n order by regional"; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optreg .= "<option value='" . $bar->regional . "'>" . $bar->regional . " - " . $bar->nama . "</option>"; } echo "<fieldset style='width:500px;'><table>\r\n <tr><td>" . $_SESSION['lang']['kodeorganisasi'] . "</td><td><select onchange=\"resetcontainer();\" id=organisasi style='width:150px'><option value=''>" . $optorg . "</select></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['regional'] . "</td><td><select onchange=\"resetcontainer();\" id=regional style='width:150px'><option value=''>" . $optreg . "</select></td></tr>\r\n </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanDep()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelDep()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme($_SESSION['lang']['datatersimpan']); $str1 = "select * from " . $dbname . ".bgt_regional_assignment order by kodeunit"; $res1 = mysql_query($str1);
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript src='js/zTools.js'></script> <script language=javascript1.2 src='js/it_5stNilaiKegiatan.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', "Standard Nilai Kegiatan"); $arr = "##kdkegiatan##ket##satuan##nilsngtbaik##nilbaik##nilckp##nilkrg##method"; echo "<fieldset style='width:500px;'><table>\r\n <tr><td>" . $_SESSION['lang']['kodekegiatan'] . "</td><td><input type=text id=kdkegiatan size=8 maxlength=8 onkeypress=\"return tanpa_kutip_dan_sepasi(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td><input type=text id=ket size=40 maxlength=25 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['satuan'] . "</td><td><input type=text id=satuan size=8 maxlength=4 onkeypress=\"return tanpa_kutip_dan_sepasi(event);\" class=myinputtext></td></tr>\r\n <tr><td>Sangat Baik</td><td><input type=text id=nilsngtbaik size=9 maxlength=4 onkeypress=\"return angka_doang(event);\" class=myinputtextnumber ></td></tr>\r\n <tr><td>Baik</td><td><input type=text id=nilbaik size=9 maxlength=4 onkeypress=\"return angka_doang(event);\" class=myinputtextnumber ></td></tr>\r\n <tr><td>Cukup</td><td><input type=text id=nilckp size=9 maxlength=4 onkeypress=\"return angka_doang(event);\" class=myinputtextnumber ></td></tr>\r\n <tr><td>Kurang</td><td><input type=text id=nilkrg size=9 maxlength=12 onkeypress=\"return angka_doang(event);\" class=myinputtextnumber ></td></tr>\r\n </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <input type=hidden id=eduid value=''>\r\n\t <button class=mybutton onclick=simpanPendidikan('it_slave_5stNilaiKegiatan','" . $arr . "')>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelIsi()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme(); echo "<div id=container>"; echo "<script>loadData()</script>"; echo "</div>"; echo close_theme(); CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_rumahsakit.js></script> <link rel=stylesheet type=text/css href=style/payroll.css> <?php include 'master_mainMenu.php'; //+++++++++++++++++++++++++++++++++++++++++++++ OPEN_BOX(''); echo "<div id=EList>"; echo OPEN_THEME($_SESSION['lang']['rumahsakit'] . " Form: <a id=label style='color:#FFFFFF;'>New</a>"); echo "<fieldset><legend>Input Form</legend>\r\n\t\t <br>\r\n\t\t\t <table>\r\n\t\t\t <tr><td>" . $_SESSION['lang']['namars'] . "</td><td><input type=hidden id=hosid value=''>\r\n\t\t\t\t <input type=hidden id=update value=''><input type=text class=myinputtext id=hosname size=25 maxlength=45 onkeypress=\"return tanpa_kutip(event);\"></td></tr>\r\n\t\t\t\t <tr><td>" . $_SESSION['lang']['alamat'] . "</td><td><input type=text class=myinputtext id=hosadd size=45 maxlength=45 onkeypress=\"return tanpa_kutip(event);\"></td></tr>\r\n\t\t\t\t <tr><td>" . $_SESSION['lang']['kota'] . "</td><td><input type=text class=myinputtext id=hoscity size=25 maxlength=45 onkeypress=\"return tanpa_kutip(event);\"></td></tr>\r\n\t\t\t <tr><td>" . $_SESSION['lang']['telp'] . "</td><td><input type=text class=myinputtext id=hosphone size=25 maxlength=45 onkeypress=\"return tanpa_kutip(event);\"></td></tr>\r\n\t\t\t\t <tr><td>" . $_SESSION['lang']['email'] . "</td><td><input type=text class=myinputtext id=hosmail size=25 maxlength=45 onkeypress=\"return tanpa_kutip(event);\"></td></tr>\r\n\t\t\t <tr><td>" . $_SESSION['lang']['status'] . "</td><td><select id=status><option value=1>Active</option><option value=0>Black List</option></select></td></tr>\r\n\t\t\t </table>\r\n\t\t\t <br>\r\n\t\t\t <button class=mybutton onclick=saveHospital()>" . $_SESSION['lang']['save'] . "</button>\r\n\t\t\t <button class=mybutton onclick=cancelHospital()>" . $_SESSION['lang']['new'] . "</button>\r\n\t\t\t </fieldset>"; echo CLOSE_THEME(); echo "</div>"; CLOSE_BOX(); OPEN_BOX('', $_SESSION['lang']['list']); echo "<table class=sortable cellspacing=1 border=0 width=100%>\r\n\t <thead>\r\n\t <tr class=rowheader><td>No.</td>\r\n\t\t\t <td align=center>" . $_SESSION['lang']['namars'] . "</td>\r\n\t\t\t\t <td align=center>" . $_SESSION['lang']['alamat'] . "</td>\r\n\t\t\t\t <td align=center>" . $_SESSION['lang']['kota'] . "</td>\r\n\t\t\t\t <td align=center>" . $_SESSION['lang']['telp'] . "</td> \r\n\t\t\t\t <td align=center>" . $_SESSION['lang']['email'] . "</td>\r\n\t\t\t\t <td align=center>" . $_SESSION['lang']['status'] . "</td>\r\n\t\t\t\t <td align=center>Edit/Del</td>\r\n\t\t\t </tr>\r\n\t\t\t</thead><tbody id=tbody>"; $str = "select *,case status when 1 then 'Active' when 0 then\t 'Black List' end as xstatus from " . $dbname . ".sdm_5rs order by namars"; $res = mysql_query($str); $no = 0; while ($bar = mysql_fetch_object($res)) { $no += 1; echo "<tr class=rowcontent><td>" . $no . "</td>\r\n\t <td>" . $bar->namars . "</td>\r\n\t\t <td>" . $bar->alamat . "</td>\r\n\t\t <td>" . $bar->kota . "</td>\r\n\t\t <td>" . $bar->telp . "</td> \r\n\t\t <td>" . $bar->email . "</td>\r\n\t\t <td>" . $bar->xstatus . "</td>\r\n\t\t <td align=center>\r\n\t\t <img src=images/tool.png class=dellicon title=Edit height=11px onclick=\"editHospital('" . $bar->id . "','" . $bar->namars . "','" . $bar->kota . "','" . $bar->alamat . "','" . $bar->telp . "','" . $bar->email . "','" . $bar->status . "')\">\r\n\t\t <img src=images/close.png class=dellicon title=delete height=11px onclick=\"deleteHospital('" . $bar->id . "');\">\r\n </td>\r\n\t </tr>"; } echo "</tbody><tfoot></tfoot></table>"; CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; include 'lib/zMysql.php'; include 'lib/zFunction.php'; echo open_body(); ?> <script language=javascript1.2 src=js/vhc.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', "<b>" . $_SESSION['lang']['jenkendabmes'] . "</b>"); //get enum untuk kelompok vhc; $optklvhc = ""; $arrklvhc = getEnum($dbname, 'vhc_5master', 'kelompokvhc'); foreach ($arrklvhc as $kei => $fal) { switch ($kei) { case 'AB': $_SESSION['language'] != 'EN' ? $fal = 'Alat Berat' : ($fal = 'Heavy Equipment'); break; case 'KD': $_SESSION['language'] != 'EN' ? $fal = 'Kendaraan' : ($fal = 'Vehicle'); break; case 'MS': $_SESSION['language'] != 'EN' ? $fal = 'Mesin' : ($fal = 'Machinery'); break; } $optklvhc .= "<option value='" . $kei . "'>" . $fal . "</option>"; }
$qOrg2 = mysql_query($sOrg2) or die(mysql_error()); while ($rOrg2 = mysql_fetch_assoc($qOrg2)) { $optkegiatan .= "<option value=" . $rOrg2['id'] . ">" . $rOrg2['nama'] . "</option>"; } $arrjabatan = array('Manager', 'Askep', 'Asisten', 'Mandor'); $optjabatan = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; foreach ($arrjabatan as $asjab) { $optjabatan .= "<option value='" . $asjab . "'>" . $asjab . "</option>"; } $optqcid = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $sOrg2 = "select id, tipe, nama from " . $dbname . ".qc_5parameter\r\n order by tipe, nama\r\n "; $qOrg2 = mysql_query($sOrg2) or die(mysql_error()); while ($rOrg2 = mysql_fetch_assoc($qOrg2)) { $optqcid .= "<option value=" . $rOrg2['id'] . ">" . $rOrg2['tipe'] . " - " . $rOrg2['nama'] . "</option>"; } OPEN_BOX('', "<b>Cross Block</b>"); $frm[0] .= "<fieldset style='width:800px;float:left'><legend>" . $_SESSION['lang']['form'] . "</legend>"; $frm[0] .= "<table cellspacing=1 border=0>\r\n<tr>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td>:</td>\r\n <td><input type='hidden' id='proses0' value='savedata0'/><input type='hidden' id='id' value=''/><input type='text' class='myinputtext' id='tanggal' onmousemove='setCalendar(this.id)' onkeypress='return false;' \r\n size='10' maxlength='10' style=\"width:150px;\"/></td>\r\n</tr>\r\n<tr>\r\n <td>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n <td>:</td>\r\n <td><select id=kodeorg style=width:150px>" . $optkodeorg . "</select></td>\r\n</tr>\r\n<tr>\r\n <td>" . $_SESSION['lang']['jabatan'] . "</td>\r\n <td>:</td>\r\n <td><select id=jabatan style=width:150px>" . $optjabatan . "</select></td>\r\n</tr>\r\n<tr>\r\n <td>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n <td>:</td>\r\n <td><select id=karyawan style=width:150px>" . $optkaryawan . "</select></td>\r\n</tr>\r\n<tr>\r\n <td>Check/Re-Check</td>\r\n <td>:</td>\r\n <td><select id=cek style=width:150px>" . $optcek . "</select></td>\r\n</tr>\r\n<tr>\r\n <td style=width:200px;>" . $_SESSION['lang']['kelompok'] . "</td>\r\n <td>:</td>\r\n <td><select id=kelompok style=width:150px onchange=openkegiatan()>" . $optkelompok . "</select></td>\r\n</tr>\r\n<tr>\r\n <td colspan=3><input type='hidden' id='jumlahkegiatan' value='0'/><div id=container2></div></td>\r\n</tr>\r\n<tr>\r\n <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n <td>:</td>\r\n <td><input type='text' class='myinputtext' style='width:150px;' id='keterangan' onkeypress='return tanpa_kutip(event)' maxlength=100/></td>\r\n</tr>"; $frm[0] .= "<tr>\r\n <td colspan=3>\r\n <button class=mybutton id=save0 name=save0 onclick=savedata0()>" . $_SESSION['lang']['save'] . "</button>\r\n <button class=mybutton id=cancel0 name=cancel0 onclick=canceldata0()>" . $_SESSION['lang']['cancel'] . "</button>\r\n </td></tr>"; $frm[0] .= "</table></fieldset>"; $frm[0] .= "<fieldset style=width:800px;><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>"; $frm[0] .= "<table cellpadding=1 cellspacing=1 border=0 class=sortable>\r\n <thead>\r\n <tr class=rowheader>\r\n <td>" . $_SESSION['lang']['nomor'] . "</td>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td>" . $_SESSION['lang']['kodeblok'] . "</td>\r\n <td>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n <td>" . $_SESSION['lang']['jabatan'] . "</td>\r\n <td>Check/Re-Check</td>\r\n <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n <td colspan=2>" . $_SESSION['lang']['action'] . "</td>\r\n </tr>\r\n </thead>\r\n <tbody id=container0><script>loaddata0()</script>\r\n "; $frm[0] .= "</tbody></table></fieldset>"; $arr = "##kodeorg1##periode1"; $frm[1] .= "<fieldset style='width:800px;float:left'>\r\n<legend>List</legend>\r\n<table cellspacing=\"1\" border=\"0\" >\r\n<tr>\r\n <td><label>" . $_SESSION['lang']['kodeorg'] . "</label></td>\r\n <td>:</td>\r\n <td><select id=\"kodeorg1\" name=\"kodeorg1\" style=\"width:150px\" onchange=hideById('container1')>" . $optkodeorg1 . "</select></td>\r\n</tr>\r\n<tr>\r\n <td><label>" . $_SESSION['lang']['periode'] . "</label></td>\r\n <td>:</td>\r\n <td><select id=\"periode1\" name=\"periode1\" style=\"width:150px\" onchange=hideById('container1')>" . $optperiode1 . "</select></td>\r\n</tr>\r\n<tr>\r\n <td colspan=\"3\">\r\n <button onclick=\"zPreview('kebun_slave_crossblock','" . $arr . "','container1'); showById('container1')\" class=\"mybutton\" name=\"preview\" id=\"preview\">Preview</button>\r\n <button onclick=\"zExcel(event,'kebun_slave_crossblock.php','" . $arr . "'); \" class=\"mybutton\" name=\"excel\" id=\"excel\">Excel</button>\r\n </td>\r\n</tr>\r\n</table>\r\n</fieldset>"; $frm[1] .= "<fieldset style=width:800px;><legend>Print Area</legend>\r\n<div id='container1'>\r\n</div></fieldset>"; //======================== $hfrm[0] = "Form"; $hfrm[1] = "List"; //draw tab, jangan ganti parameter pertama, krn dipakai di javascript drawTab('FRM', $hfrm, $frm, 150, 1240);
include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_payrollHO.js></script> <link rel=stylesheet type=text/css href=style/payroll.css> <?php include 'master_mainMenu.php'; //+++++++++++++++++++++++++++++++++++++++++++++ //list employee $limit = 0; if (isset($_GET['limit'])) { $limit = $_GET['limit']; } else { $_GET['limit'] = 0; } OPEN_BOX('', '<b>' . strtoupper($_SESSION['lang']['sinkronisasidatapy']) . '</b>'); echo "<div>"; echo OPEN_THEME($_SESSION['lang']['pilihdata'] . ':'); echo "<table><tr><td>"; //get all registred employee $arrid = array(); $prestr = "select distinct karyawanid from " . $dbname . ".sdm_ho_employee order by karyawanid"; $preres = mysql_query($prestr, $conn); while ($prebar = mysql_fetch_object($preres)) { array_push($arrid, $prebar->karyawanid); } $str = "select karyawanid,namakaryawan,statuspajak,tanggalmasuk,tanggalkeluar,npwp from " . $dbname . ".datakaryawan where alokasi=1 limit " . $limit . ",500"; $res = mysql_query($str, $conn); echo "<input type=checkbox onclick=checkAll(this," . mysql_num_rows($res) . ")>" . $_SESSION['lang']['pilihsemua']; echo "           \r\n\t\t <a href='?limit=" . ($_GET['limit'] - 500 > -1 ? $_GET['limit'] - 500 : 0) . "'>" . $_SESSION['lang']['pref'] . "</a>   <a href='?limit=" . ($_GET['limit'] + 500) . "'>" . $_SESSION['lang']['lanjut'] . "</a>"; echo "<table class=sortable cellspacing=1 border=0>\r\n\t\t <thead>\r\n\t\t\t <tr class=rowheader>\r\n\t\t\t <td>" . $_SESSION['lang']['pilih'] . "</td>\r\n\t\t\t <td>No.</td>\r\n\t\t\t <td>" . $_SESSION['lang']['id'] . "</td>\r\n\t\t\t\t<td>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n\t\t\t\t<td>" . $_SESSION['lang']['statuspajak'] . "</td>\r\n\t\t\t\t<td>" . $_SESSION['lang']['npwp'] . "</td>\r\n\t\t\t\t<td>" . $_SESSION['lang']['tanggalmasuk'] . "</td>\r\n\t\t\t\t<td>" . $_SESSION['lang']['tanggalkeluar'] . "</td>\r\n\t\t\t\t</tr>\r\n\t\t\t </thead>\r\n\t\t\t <tbody id=tablebody>\r\n\t\t\t ";
} $str = "select noakun," . $dd . " from " . $dbname . ".keu_5akun\r\n where detail=1 and tipeakun = 'Biaya' and noakun like '7%' order by noakun\r\n "; $optakun = ""; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optakun .= "<option value='" . $bar->noakun . "'>" . $bar->noakun . " - " . $bar->namaakun . "</option>"; $akun[$bar->noakun] = $bar->namaakun; } $optVhc = ""; $str = "select kodevhc from " . $dbname . ".vhc_5master order by kodevhc"; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optVhc .= "<option value='" . $bar->kodevhc . "'>" . $bar->kodevhc . "</option>"; } //atas OPEN_BOX('', "<b>" . $_SESSION['lang']['biayaumum'] . "</b>"); echo "<table cellspacing=1 border=0>\r\n <tr><td>" . $_SESSION['lang']['tipeanggaran'] . " </td><td>:</td><td>\r\n <input type=text class=myinputtext id=tipebudget name=tipebudget onkeypress=\"return angka_doang(event);\" maxlength=2 disabled=true style=width:150px; value=\"" . $tipebudget . "\"/></td></tr>\r\n <tr><td>" . $_SESSION['lang']['budgetyear'] . "</td><td>:</td><td>\r\n <input type=text class=myinputtext id=tahunbudget name=tahunbudget onkeypress=\"return angka_doang(event);\" maxlength=4 style=width:150px; /></td></tr>\r\n <tr><td>" . $_SESSION['lang']['kodeanggaran'] . "</td><td>:</td><td>\r\n <select id=kodebudget onchange=\"updateTab();\" name=kodebudget style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optkodebudget . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['jenisbiaya'] . "</td><td>:</td><td>\r\n <select name=jenisbiaya id=jenisbiaya style='width:150px;'><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>" . $optakun . "</select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['abkend'] . "</td>\r\n <td>:</td>\r\n <td><select id=kodevhc style='width:150px;' onchange=\"kalikanRp()\" >\r\n <option value=''>" . $optVhc . "</option>\r\n </select>\r\n </td>\r\n </tr> \r\n\r\n <tr><td>" . $_SESSION['lang']['kmhmtahun'] . "</td><td>:</td><td>\r\n <input disabled type=text class=myinputtextnumber name=jamperthn id=jamperthn onkeypress=\"return angka_doang(event);\" onblur=kalikanRp()></td></tr>\r\n \r\n<tr><td>" . $_SESSION['lang']['jumlahpertahun'] . " </td><td>:</td><td>\r\n <input type=text class=myinputtext id=jumlahbiaya name=jumlahbiaya onkeypress=\"return angka_doang(event);\" maxlength=20 style=width:150px; /></td></tr>\r\n <tr><td>" . $_SESSION['lang']['keterangan'] . " </td><td>:</td><td>\r\n <input type=text class=myinputtext id=ketUmum name=ketUmum onkeypress=\"return tanpa_kutip(event);\" maxlength=45 style=width:150px; /></td></tr>\r\n <tr><td colspan=3>\r\n <button class=mybutton id=simpan name=simpan onclick=simpan()>" . $_SESSION['lang']['save'] . "</button>\r\n <input type=hidden id=tersembunyi name=tersembunyi value=tersembunyi >\r\n </td></tr></table>"; //tab0 $frm[0] .= "<fieldset id=tab0><legend>" . $_SESSION['lang']['list'] . "</legend> \r\n<div style=overflow:auto;width:100%;height:300px; id=container0>"; $frm[0] .= $_SESSION['lang']['budgetyear'] . " : <select name=pilihtahun0 id=pilihtahun0 onchange=\"updateTab();\"><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $opttahunbudget . "</select>"; $frm[0] .= "<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>"; $str = "select * from " . $dbname . ".bgt_budget\r\n where kodebudget like 'UMUM%' and tipebudget = '" . $tipebudget . "' and kodeorg = '" . $kodeorg . "'\r\n order by tahunbudget desc, noakun"; $res = mysql_query($str); $no = 1; while ($bar = mysql_fetch_object($res)) { $frm[0] .= "<tr class=rowcontent>\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) { $frm[0] .= "<td align=center><img id=\"delRow\" class=\"zImgBtn\" src=\"images/application/application_delete.png\" onclick=\"deleteRow(" . $bar->kunci . ")\" title=\"Hapus\"></td>"; } else { $frm[0] .= "<td align=center> </td>"; }
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/umum_laporanpenghuni.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['penghuni']); $str = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi \r\n where tipe not in('STENGINE','BLOK','PT','HOLDING','GUDANG','STATION')\r\n\t order by kodeorganisasi"; $res = mysql_query($str); $optorg .= ""; while ($bar = mysql_fetch_object($res)) { $optorg .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; } echo "<fieldset>"; echo $_SESSION['lang']['kodeorganisasi'] . "<select id=kodeorg>" . $optorg . "</select>\r\n <button class=mybutton onclick=showPenguhi()>" . $_SESSION['lang']['tampilkan'] . "</button>"; echo "</fieldset>"; echo "<fieldset>\r\n <legend>" . $_SESSION['lang']['list'] . "</legend>\r\n\t <table class=sortable border=0 cellspacing=1>\r\n\t \t\t<thead>\r\n\t \t\t <tr class=rowheader>\r\n\t\t\t <td>No</td>\r\n\t\t\t <td>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['komplek_rmh'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['blok'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['no_rmh'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['tipe'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['jumlahpenghuni'] . "</td>\r\n\t\t\t <td></td>\r\n\t\t\t </tr>\r\n\t\t\t</thead>\r\n\t\t\t<tbody id=container>\r\n\t\t\t</tbody>\r\n\t\t\t<tfoot>\r\n\t\t\t</tfoot>\r\n\t </table>\r\n\t "; echo "</fieldset>"; CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_jatahBBM.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['penggantiantransport']); $optthn = "<option value=''></option>"; for ($x = -1; $x < 10; $x++) { $mk = mktime(0, 0, 0, date('m') - $x, 15, date('Y')); $optthn .= "<option value='" . date('Y-m', $mk) . "'>" . date('m-Y', $mk) . "</option>"; } //===============ambil list karyawan $str = "select a.namakaryawan,a.karyawanid, b.namajabatan from " . $dbname . ".datakaryawan a\r\n left join " . $dbname . ".sdm_5jabatan b on a.kodejabatan=b.kodejabatan\r\n\t where a.alokasi=1\r\n\t and (a.tanggalkeluar='0000-00-00' or a.tanggalkeluar>'" . date('Y-m-d') . "')\r\n\t order by a.namakaryawan"; $res = mysql_query($str); $optKaryawan = ''; while ($bar = mysql_fetch_object($res)) { $optKaryawan .= "<option value='" . $bar->karyawanid . "'>" . $bar->namakaryawan . " [ " . $bar->namajabatan . " ]</option>"; } //pt================== $str = "select kodeorganisasi,namaorganisasi from \r\n " . $dbname . ".organisasi where tipe='pt'"; $res = mysql_query($str); $optPt = ''; while ($bar = mysql_fetch_object($res)) { $optPt .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; }
#$optper="<option value=''>".$_SESSION['lang']['sekarang']."</option>"; $optper = ""; while ($bar = mysql_fetch_object($res)) { $optper .= "<option value='" . $bar->periode . "'>" . substr($bar->periode, 5, 2) . "-" . substr($bar->periode, 0, 4) . "</option>"; } if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING' or $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') { //=================ambil PT; $str = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi\r\n where tipe='PT'\r\n order by namaorganisasi"; $res = mysql_query($str); $optpt = ""; while ($bar = mysql_fetch_object($res)) { $optpt .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; } //=================ambil gudang; $str = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi\r\n where tipe='KEBUN' and induk!=''\r\n "; $res = mysql_query($str); $optgudang = "<option value=''>" . $_SESSION['lang']['all'] . "</option>"; while ($bar = mysql_fetch_object($res)) { $optgudang .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; } } else { $optpt = ""; $optpt .= "<option value='" . $_SESSION['empl']['kodeorganisasi'] . "'>" . $_SESSION['empl']['kodeorganisasi'] . "</option>"; $optgudang = "<option value='" . $_SESSION['empl']['lokasitugas'] . "'>" . $_SESSION['empl']['lokasitugas'] . "</option>"; } echo "<fieldset>\r\n <legend>" . $_SESSION['lang']['neracasaldo'] . " PER UNIT</legend>\r\n\t " . $_SESSION['lang']['pt'] . " : " . "<select id=pt style='width:200px;' onchange=ambilAnak(this.options[this.selectedIndex].value)>" . $optpt . "</select>\r\n\t " . $_SESSION['lang']['periode'] . " : " . "<select id=periode onchange=hideById('printPanel')>" . $optper . "</select>\r\n " . $_SESSION['lang']['tglcutisampai'] . "\r\n " . $_SESSION['lang']['periode'] . " : " . "<select id=periode1 onchange=hideById('printPanel')>" . $optper . "</select>\r\n\t <button class=mybutton onclick=getLaporanBukuBesar()>" . $_SESSION['lang']['proses'] . "</button>\r\n\t </fieldset>"; CLOSE_BOX(); OPEN_BOX('', ''); echo "<span id=printPanel style='display:none;'>\r\n <img onclick=fisikKeExcel(event,'keu_2slave_neraca_per_unit.php') src=images/excel.jpg class=resicon title='MS.Excel'> \r\n\t </span> \r\n\t \r\n <fieldset><legend>Print Area</legend><div style='overflow:auto;height:480px;width:1200px' id=container>\r\n </div>\r\n </fieldset>"; CLOSE_BOX(); close_body();
$da = mktime(0, 0, 0, date('m') - $z, date('d'), date('Y')); $opt3 .= "<option value='" . date('Y-m', $da) . "'>" . date('m-Y', $da) . "</option>"; } $str = "select * from " . $dbname . ".sdm_ho_hr_jms_porsi"; $res = mysql_query($str, $conn); //default $karyawan = 0.02; $perusahaan = 4.54; while ($bar = mysql_fetch_object($res)) { if ($bar->id == 'karyawan') { $karyawan = $bar->value / 100; } else { $perusahaan = $bar->value / 100; } } OPEN_BOX('', '<b>JAMSOSTEK REPORT</b>'); echo "<div id=EList>"; echo OPEN_THEME('JAMSOSTEK:'); echo "<br>\r\n\t\t Periode:<select id=bln onchange=getJmsvalue(this.options[this.selectedIndex].value)><option value=''></option>" . $opt3 . "</select>\r\n\t\t\t "; $str = "select e.name,e.startdate,e.nojms,d.value,d.karyawanid,d.periode from \r\n\t\t " . $dbname . ".sdm_ho_employee e, " . $dbname . ".sdm_ho_detailmonthly d\r\n\t\t where e.karyawanid=d.karyawanid and e.operator='" . $_SESSION['standard']['username'] . "'\r\n\t\t\t and d.periode='" . date('Y-m') . "' and d.component=3 \r\n\t\t order by name"; echo "<hr><br>Laporan Jamsostek Bulan:<b><span id=caption>" . date('m-Y') . "</span></b>\r\n\t\t\t <img src=images/excel.jpg height=17px style='cursor:pointer;' onclick=convertJmsExcel()>\r\n\t\t\t <div style='display:none;'>\r\n\t\t\t <iframe id=ifrm></iframe>\r\n\t\t\t </div>\r\n\t\t\t "; echo "<table class=sortable width=900px border=0 cellspacing=1>\r\n\t\t <thead>\r\n\t\t\t <tr class=rowheader>\r\n\t\t\t <td align=center>No.</td>\r\n\t\t\t\t<td align=center>No.Karyawan</td>\r\n\t\t\t <td align=center>Nama.Karyawan</td>\r\n\t\t\t\t<td align=center>No.JMS</td>\r\n\t\t\t\t<td align=center>Tgl.Masuk</td>\r\n\t\t\t\t<td align=center>Periode</td>\r\n\t\t\t\t<td align=center>Beban.Karyawan<br>(Rp.)</td>\r\n\t\t\t\t<td align=center>Beban.Perusahaan<br>(Rp.)</td>\r\n\t\t\t\t<td align=center>Total</td>\r\n\t\t\t\t<td align=center>GJ.Kotor</td>\r\n\t\t\t </tr> \r\n\t\t\t </thead>\r\n\t\t\t <tbody id=tbody>"; $res = mysql_query($str, $conn); $no = 0; $ttl = 0; //grand total $tvp = 0; //total perusahaan $tkar = 0; //total karyawan $total = 0;
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src='js/sdm_premi_sudah_bayar.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['premisudahbayar']); $optPeriode = '<option value=""></option>'; $sGp = "select DISTINCT periode from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and `sudahproses`=0 order by periode desc limit 0,6"; $qGp = mysql_query($sGp) or die(mysql_error()); while ($rGp = mysql_fetch_assoc($qGp)) { $optPeriode .= "<option value=" . $rGp['periode'] . ">" . substr(tanggalnormal($rGp['periode']), 1, 7) . "</option>"; } $str1 = "select * from " . $dbname . ".datakaryawan\r\n where ((tanggalkeluar='0000-00-00') or tanggalkeluar >'" . date('Y') . "-01-01" . "')\r\n\t and tipekaryawan!=0 and LEFT(lokasitugas,4)='" . substr($_SESSION['empl']['lokasitugas'], 0, 4) . "'\r\n\t order by namakaryawan"; //echo"$str1"; $res1 = mysql_query($str1, $conn); $optIdKaryawan = '<option value=""></option>'; while ($bar1 = mysql_fetch_object($res1)) { $optIdKaryawan .= "<option value=" . $bar1->karyawanid . ">" . $bar1->namakaryawan . "</option>"; $nama[$bar1->karyawanid] = $bar1->namakaryawan; } $strKom = "select * from " . $dbname . ".sdm_ho_component where id in('36','37')"; $resKom = mysql_query($strKom, $conn); $optKomponen = ''; while ($bar1 = mysql_fetch_object($resKom)) { $optKomponen .= "<option value=" . $bar1->id . ">" . $bar1->name . "</option>";
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/golongan.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['pengaturangolongan']); echo "<fieldset style='width:500px;'><table>\r\n <tr><td>" . $_SESSION['lang']['levelcode'] . "</td><td><input type=text id=kodegolongan size=3 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['levelname'] . "</td><td><input type=text id=namagolongan size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanGolongan()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelGolongan()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme($_SESSION['lang']['availavel']); echo "<div id=container>"; $str1 = "select * from " . $dbname . ".sdm_5golongan order by kodegolongan"; $res1 = mysql_query($str1); echo "<table class=sortable cellspacing=1 border=0 style='width:500px;'>\r\n\t <thead>\r\n\t\t <tr class=rowheader><td style='width:150px;'>" . $_SESSION['lang']['levelcode'] . "</td><td>" . $_SESSION['lang']['levelname'] . "</td><td style='width:30px;'>*</td></tr>\r\n\t\t </thead>\r\n\t\t <tbody>"; while ($bar1 = mysql_fetch_object($res1)) { echo "<tr class=rowcontent><td align=center>" . $bar1->kodegolongan . "</td><td>" . $bar1->namagolongan . "</td><td><img src=images/application/application_edit.png class=resicon caption='Edit' onclick=\"fillField('" . $bar1->kodegolongan . "','" . $bar1->namagolongan . "');\"></td></tr>"; } echo "\t \r\n\t\t </tbody>\r\n\t\t <tfoot>\r\n\t\t </tfoot>\r\n\t\t </table>"; echo "</div>"; echo close_theme(); CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_5absensi.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['jenisabsensi']); echo "<fieldset style='width:500px;'><table>\r\n <tr><td>" . $_SESSION['lang']['kodeabs'] . "</td><td><input type=text id=kode size=3 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td><input type=text id=keterangan size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['grup'] . "</td><td><select id=grup><option value=0>" . $_SESSION['lang']['tidakdibayar'] . "</option><option value=1>" . $_SESSION['lang']['dibayar'] . "</option></select></td></tr>\r\n <tr><td>" . $_SESSION['lang']['jumlahhk'] . "</td><td><input type=text id=jumlahhk size=3 onkeypress=\"return angka_doang(event);\" class=myinputtextnumber maxlength=3 value=0 onblur=change_number(this)></td></tr>\r\n\t </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanJ()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelJ()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme($_SESSION['lang']['availvhc']); echo "<div>"; $str1 = "select *,\r\n\t case kelompok when 1 then '" . $_SESSION['lang']['dibayar'] . "'\r\n\t\t when 0 then '" . $_SESSION['lang']['tidakdibayar'] . "'\r\n\t\t end as ketgroup \r\n\t from " . $dbname . ".sdm_5absensi order by kodeabsen"; $res1 = mysql_query($str1); echo "<table class=sortable cellspacing=1 border=0 style='width:500px;'>\r\n\t <thead>\r\n\t\t <tr class=rowheader>\r\n\t\t <td style='width:150px;'>" . $_SESSION['lang']['kodeabs'] . "</td>\r\n\t\t\t<td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n\t\t\t<td>" . $_SESSION['lang']['grup'] . "</td>\r\n\t\t\t<td>" . $_SESSION['lang']['jumlahhk'] . "</td>\r\n\t\t\t<td style='width:30px;'>*</td></tr>\r\n\t\t </thead>\r\n\t\t <tbody id=container>"; while ($bar1 = mysql_fetch_object($res1)) { echo "<tr class=rowcontent>\r\n\t\t <td align=center>" . $bar1->kodeabsen . "</td>\r\n\t\t\t\t <td>" . $bar1->keterangan . "</td>\r\n\t\t\t\t <td>" . $bar1->ketgroup . "</td>\r\n\t\t\t\t <td>" . $bar1->nilaihk . "</td>\r\n\t\t\t\t <td><img src=images/application/application_edit.png class=resicon caption='Edit' onclick=\"fillField('" . $bar1->kodeabsen . "','" . $bar1->keterangan . "','" . $bar1->kelompok . "','" . $bar1->nilaihk . "');\"></td></tr>"; } echo "\t \r\n\t\t </tbody>\r\n\t\t <tfoot>\r\n\t\t </tfoot>\r\n\t\t </table>"; echo "</div>"; echo close_theme(); CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/sdm_jenibypjd.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', $_SESSION['lang']['perjalanandinas'] . " " . $_SESSION['lang']['jenisbiaya']); echo "<fieldset style='width:500px;'><table>\r\n <tr><td>" . $_SESSION['lang']['tipe'] . "</td><td><input type=text id=kodejabatan size=3 maxlength=4 onkeypress=\"return angka_doang(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td><input type=text id=namajabatan size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanJSP()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelJSP()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme($_SESSION['lang']['availvhc']); echo "<div id=container>"; $str1 = "select * from " . $dbname . ".sdm_5jenisbiayapjdinas order by keterangan"; $res1 = mysql_query($str1); echo "<table class=sortable cellspacing=1 border=0 style='width:500px;'>\r\n\t <thead>\r\n\t\t <tr class=rowheader><td style='width:150px;'>" . $_SESSION['lang']['tipe'] . "</td><td>" . $_SESSION['lang']['keterangan'] . "</td><td style='width:30px;'>*</td></tr>\r\n\t\t </thead>\r\n\t\t <tbody>"; while ($bar1 = mysql_fetch_object($res1)) { echo "<tr class=rowcontent><td align=center>" . $bar1->id . "</td><td>" . $bar1->keterangan . "</td><td><img src=images/application/application_edit.png class=resicon caption='Edit' onclick=\"fillField('" . $bar1->id . "','" . $bar1->keterangan . "');\"></td></tr>"; } echo "\t \r\n\t\t </tbody>\r\n\t\t <tfoot>\r\n\t\t </tfoot>\r\n\t\t </table>"; echo "</div>"; echo close_theme(); CLOSE_BOX(); echo close_body();
} $optTipe = "<option value=''>" . $_SESSION['lang']['all'] . "</option>"; $iTipe = "select * from " . $dbname . ".sdm_5tipekaryawan where id between 1 and 6 "; $nTipe = mysql_query($iTipe) or die(mysql_error($conn)); while ($dTipe = mysql_fetch_assoc($nTipe)) { $optTipe .= "<option value=" . $dTipe['id'] . ">" . $dTipe['tipe'] . "</option>"; } $optJab = "<option value=''>" . $_SESSION['lang']['all'] . "</option>"; $iJab = "select * from " . $dbname . ".sdm_5jabatan order by namajabatan asc"; $nJab = mysql_query($iJab) or die(mysql_error($conn)); while ($dJab = mysql_fetch_assoc($nJab)) { $optJab .= "<option value=" . $dJab['kodejabatan'] . ">" . $dJab['namajabatan'] . "</option>"; } $frm[0] = ''; $frm[1] = ''; OPEN_BOX('', "<b>Rekap Gaji</b><br /><br />"); $arr = "##kdorg##per1##per2##kom##tipekar"; $frm[0] .= "<fieldset style='float:left;'>\n <legend>Form</legend>\n <table border=0 cellpadding=1 cellspacing=1>\n <tr>\n <td>" . $_SESSION['lang']['unit'] . "</td>\n <td>:</td>\n <td><select id=kdorg style=\"width:150px;\">" . $optOrg . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['periode'] . "</td>\n <td>:</td>\n <td><select id=per1 style=\"width:150px;\">" . $optPer . "</select> S/D \n <select id=per2 style=\"width:150px;\">" . $optPer . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['komponenpayroll'] . "</td>\n <td>:</td>\n <td><select id=kom style=\"width:150px;\">" . $optTp . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['tipekaryawan'] . "</td>\n <td>:</td>\n <td><select id=tipekar style=\"width:150px;\">" . $optTipe . "</select></td>\n </tr>\n\n <tr>\n <td colspan=4>\n <button onclick=zPreview('sdm_slave_2totalkomponengaji','" . $arr . "','printContainer') class=mybutton name=preview id=preview>" . $_SESSION['lang']['preview'] . "</button>\n <button onclick=zExcel(event,'sdm_slave_2totalkomponengaji.php','" . $arr . "') class=mybutton name=preview id=preview>" . $_SESSION['lang']['excel'] . "</button>\n </td>\n </tr>\n </table>\n</fieldset>"; $frm[0] .= "\n<fieldset style='clear:both'><legend><b>" . $_SESSION['lang']['printArea'] . "</b></legend>\n<div id='printContainer' style='overflow:auto;height:400px;max-width:1220px'; >\n</div></fieldset>"; //<div id='printContainer' style='overflow:auto;height:350px;max-width:1220px'; > //<div id='printContainer'> $arrv = "##kdorgv##per1v##per2v##komv##tipekarv##jabv"; $frm[1] .= "<fieldset style='float:left;'>\n <legend>Form</legend>\n <table border=0 cellpadding=1 cellspacing=1>\n <tr>\n <td>" . $_SESSION['lang']['unit'] . "</td>\n <td>:</td>\n <td><select id=kdorgv style=\"width:150px;\">" . $optOrg . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['periode'] . "</td>\n <td>:</td>\n <td><select id=per1v style=\"width:150px;\">" . $optPer . "</select> S/D \n <select id=per2v style=\"width:150px;\">" . $optPer . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['komponenpayroll'] . "</td>\n <td>:</td>\n <td><select id=komv style=\"width:150px;\">" . $optTp . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['tipekaryawan'] . "</td>\n <td>:</td>\n <td><select id=tipekarv style=\"width:150px;\">" . $optTipe . "</select></td>\n </tr>\n <tr>\n <td>" . $_SESSION['lang']['jabatan'] . "</td>\n <td>:</td>\n <td><select id=jabv style=\"width:150px;\">" . $optJab . "</select></td>\n </tr>\n\n <tr>\n <td colspan=4>\n <button onclick=zPreview('sdm_slave_2totalkomponengajiv','" . $arrv . "','printContainerv') class=mybutton name=preview id=preview>" . $_SESSION['lang']['preview'] . "</button>\n <button onclick=zExcel(event,'sdm_slave_2totalkomponengajiv.php','" . $arrv . "') class=mybutton name=preview id=preview>" . $_SESSION['lang']['excel'] . "</button>\n </td>\n </tr>\n </table>\n</fieldset>"; $frm[1] .= "\n<fieldset style='clear:both'><legend><b>" . $_SESSION['lang']['printArea'] . "</b></legend>\n<div id='printContainerv' style='overflow:auto;height:400px;max-width:1220px'; >\n</div></fieldset>"; $hfrm[0] = 'Detail Perkaryawan'; $hfrm[1] = 'Rekap Jabatan'; //$hfrm[1]=$_SESSION['lang']['list']; //draw tab, jangan ganti parameter pertama, krn dipakai di javascript drawTab('FRM', $hfrm, $frm, 300, 1150); CLOSE_BOX(); echo close_body();
$sOrg2 = "select kodeorg from " . $dbname . ".setup_blok where statusblok='BBT' and kodeorg like '" . $_SESSION['empl']['lokasitugas'] . "%' order by kodeorg asc"; //echo $sOrg2; $qOrg2 = mysql_query($sOrg2) or die(mysql_error()); while ($rOrg2 = mysql_fetch_assoc($qOrg2)) { $optKdorg .= "<option value=" . $rOrg2['kodeorg'] . ">" . $optNmOrg[$rOrg2['kodeorg']] . "</option>"; } $optKdorg2 = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $sOrg3 = "select kodeorg from " . $dbname . ".setup_blok where kodeorg like '" . $_SESSION['empl']['lokasitugas'] . "%' order by kodeorg asc"; //echo $sOrg2; $qOrg3 = mysql_query($sOrg3) or die(mysql_error()); while ($rOrg3 = mysql_fetch_assoc($qOrg3)) { $optKdorg2 .= "<option value=" . $rOrg3['kodeorg'] . ">" . $optNmOrg[$rOrg3['kodeorg']] . "</option>"; } $tglHrini = date("Ymd"); echo "<div id='formIsian' style='display:block;'>"; OPEN_BOX('', "<b>Input Restan</b>"); $frm[0] .= "<input type='hidden' id='proses1' value='saveTab1' /><input type='hidden' id='oldJnsbibit' /><fieldset style='width:350px;float:left'><legend>" . $_SESSION['lang']['tnmbibit'] . "</legend>"; $frm[0] .= "<table cellspacing=1 border=0>\n<tr><td>" . $_SESSION['lang']['tanggal'] . "</td><td>:</td><td><input type='text' class='myinputtext' id='tglRestan' onmousemove='setCalendar(this.id)' onkeypress='return false;' size='10' maxlength='10' style=\"width:150px;\" /></td></tr>\n<tr><td>" . $_SESSION['lang']['blok'] . "</td><td>:</td><td><select id=kdBlokRestan style=width:150px>" . $optKdorg2 . "</select></td></tr>\n<tr><td>JJG Panen</td><td>:</td><td><input type='text' class='myinputtextnumber' style='width:150px;' id='jjgPanen' onkeypress='return angka_doang(event)' value='0' /></td></tr>\n<tr><td>JJG Kirim</td><td>:</td><td><input type='text' class='myinputtextnumber' style='width:150px;' id='jjgKrm' onkeypress='return angka_doang(event)' value='0' /></td></tr>\n<tr><td>Umur Restan</td><td>:</td><td><input type='text' class='myinputtextnumber' style='width:150px;' id='umrRestan' onkeypress='return angka_doang(event)' maxlength=45 value='0' /> Jam</td></tr>"; $frm[0] .= "<tr><td>Catatan</td><td>:</td><td><input type='text' class='myinputtext' style='width:150px;' id='cttn' onkeypress='return tanpa_kutip(event)' maxlength=45 /></td></tr></table>"; $frm[0] .= "<tr><td colspan=3 align=center><button class=mybutton id=btlTmbl name=btlTmbl onclick=saveData(1) >" . $_SESSION['lang']['save'] . "</button><button class=mybutton id=canbtlTmbl name=canbtlTmbl onclick=cancelData1() >" . $_SESSION['lang']['cancel'] . "</button></td></tr>"; $frm[0] .= "</fieldset>"; $optPeriode = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $sPeriode = "select distinct substr(tanggal,1,7) as periode from " . $dbname . ".kebun_restan where kodeorg like '" . $_SESSION['empl']['lokasitugas'] . "%'"; $qPeriode = mysql_query($sPeriode) or die(mysql_error($sPeriode)); while ($rPeriode = mysql_fetch_assoc($qPeriode)) { $optPeriode .= "<option value='" . $rPeriode['periode'] . "'>" . $rPeriode['periode'] . "</option>"; } $frm[0] .= "<div style=clear:both;> </div>"; $frm[0] .= "<fieldset style=width:550px;><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>"; $frm[0] .= "" . $_SESSION['lang']['periode'] . " : <select id=periodeCari onchange=getCari()>" . $optPeriode . "</select>\n " . $_SESSION['lang']['blok'] . " : <select id=kdBlokCari style=width:150px onchange=getCari()>" . $optKdorg2 . "</select><br />"; $frm[0] .= "<table cellpadding=1 cellspacing=1 border=0 class=sortable>\n <thead>\n <tr class=rowheader>\n <td rowspan=2>No</td>\n <td rowspan=2>" . $_SESSION['lang']['tanggal'] . "</td>\n <td rowspan=2>" . $_SESSION['lang']['blok'] . "</td>\n <td colspan=2 align=center>Panen</td>\n <td colspan=2 align=center>Kirim</td>\n <td rowspan=2 colspan=2>Action</td>\n </tr>\n <tr><td align=center>Janjang</td><td align=center>KG</td><td align=center>Janjang</td><td align=center>KG</td></tr>\n </thead><tbody id=containData1><script>loadData1()</script> \n\t\t";
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language='JavaScript1.2' src='js/supplier.js'></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', '<b>' . $_SESSION['lang']['find'] . ' ' . $_SESSION['lang']['supplier'] . '/' . $_SESSION['lang']['kontraktor'] . '</b>'); echo "<br>" . $_SESSION['lang']['nama'] . ":<input type=text class=myinputtext id=cari size=30 maxlength=30 onkeypress=\"return tanpa_kutip(event)\">\r\n\t <button class=mybutton onclick=findSupplier()>" . $_SESSION['lang']['find'] . "</button>"; echo "<fieldset>\r\n\t <legend>" . $_SESSION['lang']['pilih'] . "</legend>\r\n\t\t <div style='width=100%; height:200px;overflow:scroll'>\r\n\t <table class=sortable cellspacing=1 border=0>\r\n\t <thead>\r\n\t\t <tr class=header>\r\n\t <td>" . $_SESSION['lang']['kodekelompok'] . "</td>\r\n\t\t <td>Id." . $_SESSION['lang']['supplier'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['namasupplier'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['alamat'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['cperson'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['kota'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['telp'] . "</td>\t\t \r\n\t\t <td>" . $_SESSION['lang']['fax'] . "</td>\t\t \r\n\t\t <td>" . $_SESSION['lang']['email'] . "</td>\t\t \r\n\t\t <td>" . $_SESSION['lang']['npwp'] . "</td>\t \r\n\t\t <td>" . $_SESSION['lang']['plafon'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['noakun'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['akunpajak'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['noseripajak'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['namabank'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['norekeningbank'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['atasnama'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['nilaihutang'] . "</td>\r\n\t\t </tr>\r\n\t\t <tbody id=container>\r\n\t\t </tbody>\r\n\t\t <tfoot></tfoot>\r\n\t\t </table>\r\n\t\t </div>\r\n\t\t </fieldset>\r\n\t\t "; CLOSE_BOX(); OPEN_BOX('', 'SUPPLIER/CONTRACTOR BANK ACCOUNTs'); //akun ini hanya dibutuhkan jika setiap supplier memiliki akun sendiri-sendiri //jika akun hutang supplier digabungkan, akun ini tidak perlu if ($_SESSION['language'] == 'EN') { $zz = 'namaakun1 as namaakun'; } else { $zz = 'namaakun'; } $str = "select noakun," . $zz . " from " . $dbname . ".keu_5akun where detail=1 and (noakun like '211%')"; $res = mysql_query($str); $opt = "<option value=''></option>"; while ($bar = mysql_fetch_object($res)) { $opt .= "<option value='" . $bar->noakun . "'>" . $bar->namaakun . "</option>"; } //ambil no akun hutang pajak $str1 = "select noakun," . $zz . " from " . $dbname . ".keu_5akun where detail=1 and (noakun like '212%')"; $res1 = mysql_query($str1);
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src=js/kelompok_barang.js></script> <?php include 'master_mainMenu.php'; OPEN_BOX('', "<b>" . $_SESSION['lang']['daftargudang'] . "</b>"); echo "<table class=sortable cellspacing=1 border-0>\r\n <thead>\r\n\t <tr class=rowheader>\r\n\t <td>No.</td>\r\n\t\t <td>" . $_SESSION['lang']['orgcode'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['orgname'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['parent'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['alamat'] . "</td>\r\n\t </tr>\r\n\t </thead>\r\n\t <tbody>"; $str = "select * from " . $dbname . ".organisasi where tipe='GUDANG'"; $res = mysql_query($str); $no = 0; while ($bar = mysql_fetch_object($res)) { $no += 1; echo " <tr class=rowcontent>\r\n\t <td>" . $no . "</td>\r\n\t\t <td>" . $bar->kodeorganisasi . "</td>\r\n\t\t <td>" . $bar->kodeorganisasi . "</td>\r\n\t\t <td>" . $bar->induk . "</td>\r\n\t\t <td>" . $bar->alamat . ", " . $bar->wilayahkota . ", " . $bar->negara . ", " . $bar->kodepos . "</td>\r\n\t </tr>"; } echo "</tbody>\r\n\t <tfoot>\r\n\t </tfoot>\r\n\t </table>\r\n\t "; CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework //ind require_once 'master_validation.php'; include 'lib/nangkoelib.php'; include_once 'lib/zLib.php'; echo open_body(); include 'master_mainMenu.php'; ?> <script language=javascript1.2 src='js/log_2posisiBarang.js'></script> <script language="javascript" src="js/zMaster.js"></script> <!--<link rel=stylesheet type=text/css href="style/zTable.css">--> <script language=javascript src='js/zReport.js'></script> <script language=javascript src=js/zTools.js></script> <?php $arr = "##nopo"; OPEN_BOX('', "<b>Laporan Posisi Barang</b>"); //1 O echo "<table>\r\n <tr>\r\n\t\r\n\t <td><fieldset><legend>" . $_SESSION['lang']['find'] . "</legend>"; echo " " . $_SESSION['lang']['nopo'] . " :<input type=text id=nopo size=25 maxlength=30 disabled class=myinputtext>\r\n\t\t\t<img src=images/zoom.png title='" . $_SESSION['lang']['find'] . "' id=tmblCariNoPo class=resicon onclick=cariNoPo('" . $_SESSION['lang']['find'] . "',event)>\r\n\t\t\r\n\t\t\r\n\t\t<button onclick=zPreview('log_slave_2posisiBarang','" . $arr . "','printContainer') class=mybutton name=preview id=preview>Preview</button>\r\n <button onclick=zExcel(event,'log_slave_2posisiBarang.php','" . $arr . "') class=mybutton name=preview id=preview>" . $_SESSION['lang']['excel'] . "</button>\r\n\t\t<button onclick=batal() class=mybutton name=btnBatal id=btnBatal>" . $_SESSION['lang']['cancel'] . "</button>"; echo "</fieldset></td>\r\n </tr>\r\n\t </table> "; CLOSE_BOX(); OPEN_BOX(); echo "\r\n<fieldset style='clear:both'><legend><b>" . $_SESSION['lang']['printArea'] . "</b></legend>\r\n<div id='printContainer'>\r\n</div></fieldset>"; //style='overflow:auto;height:350px;max-width:1500px'; CLOSE_BOX(); echo close_body();
<?php //@Copy nangkoelframework require_once 'config/connection.php'; require_once 'master_validation.php'; include 'lib/nangkoelib.php'; echo open_body(); ?> <script language=javascript1.2 src='js/setup_fingerprint.js'></script> <?php $optKar = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>"; $sKar = "select karyawanid, namakaryawan from " . $dbname . ".datakaryawan where lokasitugas like '%HO' and ((tanggalkeluar = '0000-00-00') or (tanggalkeluar is NULL))\r\n order by namakaryawan"; $qKar = mysql_query($sKar) or die(mysql_error($conn)); while ($rKar = mysql_fetch_assoc($qKar)) { $optKar .= "<option value='" . $rKar['karyawanid'] . "'>" . $rKar['namakaryawan'] . "</option>"; } include 'master_mainMenu.php'; OPEN_BOX(''); echo "<fieldset style='width:300px;'><table>\r\n\t <tr><td>" . $_SESSION['lang']['namakaryawan'] . "</td><td><select id=karyawanid style=width:150px>" . $optKar . "</select></td></tr>\r\n <tr><td>PIN Fingerprint</td><td><input type=text id=pin maxlength=80 style=width:150px onkeypress='return angka_doang(event);' class=myinputtext></td></tr>\r\n\t </table>\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanJ()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelJ()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>"; echo open_theme(''); echo "<div>"; echo "<table class=sortable cellspacing=1 border=0 style='width:300px;'>\r\n <thead>\r\n <tr class=rowheader>\r\n <td style='width:150px;'>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n <td>PIN Fingerprint</td>\r\n <td style='width:30px;'>*</td></tr>\r\n </thead>\r\n <tbody id=container>"; echo "<script>loadData()</script>"; echo " </tbody>\r\n <tfoot>\r\n </tfoot>\r\n </table>"; echo "</div>"; echo close_theme(); CLOSE_BOX(); echo close_body();