예제 #1
0
<?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();
예제 #2
0
<?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";
예제 #3
0
    <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;
예제 #4
0
//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>";
//========================
예제 #5
0
    $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        &nbsp;" . $_SESSION['lang']['tanggal'] . ":<input type=text class=myinputtext id=tgl_cari onmousemove=setCalendar(this.id) onkeypress=return false;  size=10 maxlength=10 />\n        &nbsp;" . $_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());
예제 #6
0
        $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>";
}
예제 #7
0
<?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>";
예제 #8
0
<?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";
예제 #10
0
<?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);
예제 #11
0
<?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();
예제 #12
0
<?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();
예제 #13
0
<?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>";
}
예제 #14
0
$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);
예제 #15
0
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 " &nbsp &nbsp &nbsp &nbsp &nbsp \r\n\t\t        <a href='?limit=" . ($_GET['limit'] - 500 > -1 ? $_GET['limit'] - 500 : 0) . "'>" . $_SESSION['lang']['pref'] . "</a> &nbsp <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 ";
예제 #16
0
}
$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>&nbsp;</td>";
    }
예제 #17
0
<?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();
예제 #18
0
<?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>";
}
예제 #19
0
#$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();
예제 #20
0
    $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;
예제 #21
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>";
예제 #22
0
<?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();
예제 #23
0
<?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();
예제 #24
0
<?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();
예제 #25
0
}
$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();
예제 #26
0
$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'  />&nbsp;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;>&nbsp;</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    &nbsp;" . $_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";
예제 #27
0
<?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);
예제 #28
0
<?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();
예제 #29
0
<?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();
예제 #30
0
<?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();