Example #1
0
<?php

//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
OPEN_BOX();
/* Get Value Enum Status Internal/Eksternal */
$optStatusIntEks = '';
$arrStatusIntEks = getEnum($dbname, 'pmn_4customer', 'statusinteks');
foreach ($arrStatusIntEks as $kei => $fal) {
    $optStatusIntEks .= "<option value='" . $kei . "'>" . ucfirst(strtolower($fal)) . "</option>";
}
?>
<script language="javascript" src="js/pmn_5customer.js"></script>
<fieldset>
<legend><b><?php 
echo $_SESSION['lang']['customerlist'];
?>
</b></legend>
<table cellpadding="2" cellspacing="2" border="0">
        <tr>
                <td width="120px"><?php 
echo $_SESSION['lang']['kodecustomer'];
?>
</td>
                <td>:</td>
                <td><input type="text" class="myinputtext" id="kode_cus" onkeypress="return tanpa_kutip(event);" /></td>
        </tr>
Example #2
0
function formHeader($mode, $data)
{
    global $dbname;
    # Default Value
    if (empty($data)) {
        $data['notransaksi'] = '';
        $data['kodeorg'] = $_SESSION['empl']['lokasitugas'];
        $data['noakun'] = '';
        $data['tanggal'] = '';
        $data['tipetransaksi'] = '';
        $data['jumlah'] = '0';
        $data['matauang'] = 'IDR';
        $data['kurs'] = '1';
        $data['cgttu'] = '';
        $data['keterangan'] = '';
        $data['yn'] = '0';
        $data['oldNoakun'] = '';
        $data['hutangunit'] = 0;
        $data['pemilikhutang'] = '';
        $data['nocek'] = '';
        $data['noakunhutang'] = '';
    } else {
        $data['jumlah'] = number_format($data['jumlah'], 2);
    }
    # Disabled Primary
    if ($mode == 'edit') {
        $disabled = 'disabled';
    } else {
        $disabled = '';
    }
    # Options
    $whereJam = " kasbank=1 and detail=1 and (pemilik='" . $_SESSION['empl']['tipelokasitugas'] . "' or pemilik='GLOBAL' or pemilik='" . $_SESSION['empl']['lokasitugas'] . "')";
    $optMataUang = makeOption($dbname, 'setup_matauang', 'kode,matauang');
    $optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'");
    if ($_SESSION['language'] == 'EN') {
        $optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun1', $whereJam);
    } else {
        $optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', $whereJam);
    }
    $optTipe = array('M' => $_SESSION['lang']['masuk'], 'K' => $_SESSION['lang']['keluar']);
    $optCgt = getEnum($dbname, 'keu_kasbankht', 'cgttu');
    $optYn = array(0 => $_SESSION['lang']['belumposting'], 1 => $_SESSION['lang']['posting']);
    $wheredz = " kodeorganisasi != '" . $_SESSION['empl']['lokasitugas'] . "' and length(kodeorganisasi)=4";
    $wheredx = " (noakun like '211%' or noakun like '213%' or noakun like '212%') and length(noakun)=7";
    $optPemilikHutang = makeOption($dbname, 'organisasi', 'kodeorganisasi,kodeorganisasi', $wheredz);
    $optNoakunHutang = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', $wheredx, '2');
    $optPemilikHutang[''] = '';
    ksort($optPemilikHutang);
    $optNoakunHutang[''] = '';
    ksort($optNoakunHutang);
    $optHutangUnit = array('0' => $_SESSION['lang']['ya'], '1' => $_SESSION['lang']['tidak']);
    //    echo "Warning: <pre>".print_r($optNoakunHutang).'</pre>';
    //    exit;
    $els = array();
    $els[] = array(makeElement('notransaksi', 'label', $_SESSION['lang']['notransaksi']), makeElement('notransaksi', 'text', $data['notransaksi'], array('style' => 'width:150px', 'maxlength' => '25', 'disabled' => 'disabled')));
    $els[] = array(makeElement('kodeorg', 'label', $_SESSION['lang']['unitkerja']), makeElement('kodeorg', 'select', $data['kodeorg'], array('style' => 'width:150px', $disabled => $disabled), $optOrg));
    $els[] = array(makeElement('noakun2a', 'label', $_SESSION['lang']['noakun']), makeElement('noakun2a', 'select', $data['noakun'], array('style' => 'width:150px'), $optAkun));
    //    $els[] = array(
    //	makeElement('noakun2a','label',$_SESSION['lang']['noakun']),
    //	makeElement('noakun2a','select',$data['noakun'],
    //	    array('style'=>'width:150px',$disabled=>$disabled),$optAkun)
    //    );
    //
    $els[] = array(makeElement('tanggal', 'label', $_SESSION['lang']['tanggal']), makeElement('tanggal', 'text', $data['tanggal'], array('style' => 'width:150px', 'readonly' => 'readonly', 'onchange' => "getKurs()", 'onmousemove' => 'setCalendar(this.id)')));
    $els[] = array(makeElement('matauang', 'label', $_SESSION['lang']['matauang']), makeElement('matauang', 'select', $data['matauang'], array('style' => 'width:150px', 'onchange' => "getKurs()"), $optMataUang));
    $els[] = array(makeElement('kurs', 'label', $_SESSION['lang']['kurs']), makeElement('kurs', 'textnum', $data['kurs'], array('style' => 'width:150px', 'disabled' => 'disabled', 'onkeyup' => 'cekKurs()')));
    $els[] = array(makeElement('tipetransaksi', 'label', $_SESSION['lang']['tipetransaksi']), makeElement('tipetransaksi', 'select', $data['tipetransaksi'], array('style' => 'width:150px', $disabled => $disabled), $optTipe));
    $els[] = array(makeElement('nocek', 'label', 'No. Bukti Bayar'), makeElement('nocek', 'text', $data['nocek'], array('style' => 'width:150px')));
    $els[] = array(makeElement('oldNoakun', 'hid', $data['noakun']));
    $els[] = array(makeElement('jumlah', 'label', $_SESSION['lang']['jumlah']), makeElement('jumlah', 'textnum', $data['jumlah'], array('style' => 'width:150px', 'onchange' => 'this.value=remove_comma(this);this.value = _formatted(this)')));
    $els[] = array(makeElement('cgttu', 'label', $_SESSION['lang']['cgttu']), makeElement('cgttu', 'select', $data['cgttu'], array('style' => 'width:150px'), $optCgt));
    $els[] = array(makeElement('keterangan', 'label', $_SESSION['lang']['keterangan']), makeElement('keterangan', 'text', $data['keterangan'], array('style' => 'width:150px', 'maxlength' => '85')));
    $els[] = array(makeElement('yn', 'label', $_SESSION['lang']['yn']), makeElement('yn', 'select', $data['yn'], array('style' => 'width:150px', 'disabled' => 'disabled'), $optYn));
    if ($data['hutangunit'] == 0) {
        $dis = 'disabled';
    } else {
        $dis = '';
    }
    //    $els[] = array(
    //	makeElement('hutangunit','label',$_SESSION['lang']['hutangunit']),
    //        makeElement('hutangunit','checkbox',$data['hutangunit'],
    //                array('onclick'=>"pilihhutang()")),
    //        makeElement('pemilikhutang','select',$data['pemilikhutang'],
    //	    array('style'=>'width:100px',$dis=>$dis),$optPemilikHutang),
    //        makeElement('noakunhutang','select',$data['noakunhutang'],
    //	    array('style'=>'width:100px',$dis=>$dis),$optNoakunHutang),
    //    );
    $els[] = array(makeElement('hutangunit', 'label', $_SESSION['lang']['hutangunit']), makeElement('hutangunit', 'checkbox', $data['hutangunit'], array('onclick' => "pilihhutang()")));
    $els[] = array(makeElement('pemilikhutang', 'label', $_SESSION['lang']['pemilikhutang']), makeElement('pemilikhutang', 'select', $data['pemilikhutang'], array('style' => 'width:150px', $dis => $dis), $optPemilikHutang));
    $els[] = array(makeElement('noakunhutang', 'label', $_SESSION['lang']['noakunhutang']), makeElement('noakunhutang', 'select', $data['noakunhutang'], array('style' => 'width:150px', $dis => $dis), $optNoakunHutang));
    if ($mode == 'add') {
        $els['btn'] = array(makeElement('addHead', 'btn', $_SESSION['lang']['save'], array('onclick' => "addDataTable()")));
    } elseif ($mode == 'edit') {
        $els['btn'] = array(makeElement('editHead', 'btn', $_SESSION['lang']['save'], array('onclick' => "editDataTable()")));
    }
    if ($mode == 'add') {
        return genElementMultiDim($_SESSION['lang']['addheader'], $els, 2);
    } elseif ($mode == 'edit') {
        return genElementMultiDim($_SESSION['lang']['editheader'], $els, 2);
    }
}
Example #3
0
// get tipe pta enum
$optTipe = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arrTipe = getEnum($dbname, 'pta_dt', 'tipepta');
foreach ($arrTipe as $tipe => $pta) {
    $optTipe .= "<option value='" . $tipe . "'>" . $pta . "</option>";
}
#=========================================
#untuk mengaktifkan semua pilihan silahkan buka ini
#saat ini kebijakan PTA hanya untuk kapital saja
$optTipe = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optTipe .= "<option value='KAPITAL'>CAPITAL</option>";
#=========================================
$frm[0] .= "<td width=150><select id='tipe_pta' style='width:150px;'>{$optTipe}</select>\r\n            </td>\r\n            <td width=150>" . $_SESSION['lang']['volume'] . " " . $_SESSION['lang']['pekerjaan'] . "</td><td>:</td>\r\n            <td><input type='text' class='myinputtext' id='vol_pekerjaan' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;' value=0></td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['kelompok'] . " PTA</td><td>:</td>";
// get jenis pta enum
$optJn = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arrJn = getEnum($dbname, 'pta_dt', 'jenispta');
foreach ($arrJn as $jenis => $pta) {
    $optJn .= "<option value='" . $jenis . "'>" . $pta . "</option>";
}
#=========================================
#untuk mengaktifkan semua pilihan silahkan buka ini
#saat ini kebijakan PTA hanya untuk MATERIAL saja
$optJn = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optJn .= "<option value='MATERIAL'>MATERIAL</option>";
#=========================================
$frm[0] .= "<td><select id='jenis_pta' onchange='kunciForm()' style='width:150px;'>{$optJn}</select>\r\n            </td>\r\n            <td width=150>" . $_SESSION['lang']['satuan'] . " Volume</td><td>:</td>\r\n            <td><input type='text' class='myinputtext' id='satuan_vol' size=10 maxlength=10 style='width:150px;' /></td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['noakun'] . "</td><td>:</td>\r\n            <td><select id=noakunData style='width:150px;' onchange=getKegiatan()>{$optAkun}</select></td>\r\n            <td width=150>" . $_SESSION['lang']['jumlah'] . "</td><td>:</td>\r\n            <td><input type='text' class='myinputtext' id='jml' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;' value=0></td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['kegiatan'] . "</td><td>:</td>\r\n            <td><select id=kegId onchange='createNew()' style='width:150px;'>{$optKeg}</select></td>\r\n            <td width=150>" . $_SESSION['lang']['satuan'] . " Amount</td><td>:</td>\r\n            <td><input type='text' class='myinputtext' id='satuan_jml' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;'></td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['alokasi'] . "</td><td>:</td>\r\n            <td><select id=alokasi style='width:150px;'>{$optAlokasi}</select></td>\r\n            <td width=150>" . $_SESSION['lang']['total'] . "(Rp)</td><td>:</td>\r\n            <td><input type='text' class='myinputtext' id='jml_rp' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;'  value=0></td>\r\n        </tr>\r\n        <tr>\r\n            <td hidden width=150>" . $_SESSION['lang']['kodevhc'] . "</td><td hidden>:</td>\r\n            <td hidden><select id='kode_vhc' style='width:150px;'>{$optVhc}</select></td>\r\n            <td colspan=3 hidden></td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['kodebarang'] . "</td><td>:</td>\r\n            <td><input readonly type='text' class='myinputtext' id='kdbrng' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;'></td>\r\n            <td colspan=3>\r\n            <img src=images/search.png class=dellicon title=" . $_SESSION['lang']['find'] . " onclick=\"searchBrg('" . $_SESSION['lang']['findBrg'] . "','<fieldset><legend>" . $_SESSION['lang']['findnoBrg'] . "</legend>Find<input type=text class=myinputtext id=no_brg><button class=mybutton onclick=findBrg()>Find</button></fieldset><div id=container></div><input type=hidden id=nomor name=nomor value=" . $key . ">',event)\";>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width=150>" . $_SESSION['lang']['namabarang'] . "</td><td>:</td>\r\n            <td><input readonly type='text' class='myinputtext' id='nmbrng' onkeypress='return tanpa_kutip();' size=10 maxlength=10 style='width:150px;' /></td>\r\n        </tr>\r\n        <tr>\r\n        <td colspan=6 id='tmbl' align=center>\r\n            <button class=mybutton id=saveForm onclick=saveForm()>" . $_SESSION['lang']['save'] . "</button>\r\n            <button class=mybutton id=cancelForm onclick=cancelForm()>" . $_SESSION['lang']['cancel'] . "</button>\r\n            <button class=mybutton id=ajukanForm onclick=showAjukan()>Ajukan</button>\r\n        </td>\r\n        </tr>\r\n    </table>\r\n</fieldset>\r\n</div>";
$sLoad = "select * from " . $dbname . ".pta_dt \r\n        where unit='" . $_SESSION['empl']['lokasitugas'] . "'";
$qLoad = mysql_query($sLoad) or die(mysql_error());
$frm[0] .= "<div>\r\n  <fieldset>    \r\n    <table cellspacing=1 border=0 class='sortable'>\r\n      <thead><tr class=rowcontent>\r\n            <td align=center>" . $_SESSION['lang']['action'] . "</td>\r\n            <td align=center>No.</td>\r\n            <td align=center>" . $_SESSION['lang']['tipe'] . " PTA</td>\r\n            <td align=center>" . $_SESSION['lang']['kelompok'] . " PTA</td>\r\n            <td align=center>" . $_SESSION['lang']['namaakun'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['kegiatan'] . "</td>\r\n            <td align=center>Total (Rp)</td>\r\n            <td align=center>" . $_SESSION['lang']['alokasi'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['kodevhc'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['namabarang'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['volume'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['satuan'] . " volume</td>\r\n            <td align=center>" . $_SESSION['lang']['jumlah'] . "</td>\r\n            <td align=center>" . $_SESSION['lang']['satuan'] . " Amount</td>\r\n            <td align=center>" . $_SESSION['lang']['dibuatoleh'] . "</td>\r\n         </tr></thead><tbody id=contain>";
$frm[0] .= "<script>loaddata()</script></tbody>\r\n        </table>\r\n    \r\n</fieldset>\r\n</div><input type=hidden id=method value=add />";
$frm[1] .= "<fieldset><legend>Daftar PTA</legend><div id=daftarData>";
Example #4
0
if (trim($_SESSION['empl']['tipelokasitugas']) == 'HOLDING') {
    //jika user holding dapat memunculkan pilihan Permanen(staff))
    $str = "select * from " . $dbname . ".sdm_5tipekaryawan order by tipe";
} else {
    //pilihan staff dihilangkan, input data staff hanya dari pusat
    $str = "select * from " . $dbname . ".sdm_5tipekaryawan where id<>0 order by tipe";
}
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
    $opttipekaryawan .= "<option value='" . $bar->id . "'>" . $bar->tipe . "</option>";
}
$opttipekaryawan .= "<option value=100>Kecuali BHL/KHL</option>";
//===========get jeniskeamin enum
//get Golongan darah from enum
$optJK = "<option value=''>" . $_SESSION['lang']['all'] . "</option>";
$arrenum = getEnum($dbname, 'datakaryawan', 'jeniskelamin');
foreach ($arrenum as $key => $val) {
    $optJK .= "<option value='" . $key . "'>" . $val . "</option>";
}
echo "<table>\r\n     <tr valign=middle>\r\n         <td><fieldset><legend>" . $_SESSION['lang']['find'] . "</legend>";
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') {
    echo $_SESSION['lang']['perusahaan'] . " : <select id=schpt style='width:150px' onchange='filterlokasitugas()'><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $optpt . "</select><p />";
} else {
    echo "<select id=schpt style='width:150px;display:none' onchange='filterlokasitugas()'><option value=''>" . $_SESSION['lang']['all'] . "</option></select>";
}
echo " " . $_SESSION['lang']['caripadanama'] . " : <input type=text id=txtsearch  style='width:120px' size=25 maxlength=30 class=myinputtext> &nbsp";
echo $_SESSION['lang']['lokasitugas'] . " : <select id=schorg  style='width:150px' onchange=changeCaption(this.options[this.selectedIndex].text);><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $optlokasitugas . "</select> &nbsp ";
echo $_SESSION['lang']['tipekaryawan'] . " : <select id=schtipe  onchange=changeCaption1(this.options[this.selectedIndex].text);><option value=''>" . $_SESSION['lang']['all'] . "</option>" . $opttipekaryawan . "</select> &nbsp ";
echo $_SESSION['lang']['status'] . " : <select id=schstatus  style='width:75px' onchange=changeCaption(this.options[this.selectedIndex].text);><option value=''>" . $_SESSION['lang']['all'] . "</option><option value='0000-00-00'>" . $_SESSION['lang']['aktif'] . "</option><option value='*'>" . $_SESSION['lang']['tidakaktif'] . "</select> &nbsp ";
echo $_SESSION['lang']['jeniskelamin'] . " : <select id=schjk  style='width:150px' onchange=changeCaption(this.options[this.selectedIndex].text);>" . $optJK . "</select> &nbsp ";
//echo "<td align=right>".$_SESSION['lang']['jeniskelamin']."</td><td><select id=jeniskelamin  style='width:150px;'>".$optJK."</select></td>";
Example #5
0
//@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>";
}
echo "<fieldset style='width:500px;'><table>\r\n<tr><td>" . $_SESSION['lang']['kodekelompok'] . "</td><td><select id=kelompokvhc>" . $optklvhc . "</select></td></tr>     \r\n         <tr><td>" . $_SESSION['lang']['tipe'] . "</td><td><input type=text id=jenisvhc size=5 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext maxlength=5></td></tr>\r\n         <tr><td>" . $_SESSION['lang']['namajenisvhc'] . "</td><td><input type=text id=namajenisvhc size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext maxlength=45></td></tr>\r\n         <tr><td>" . $_SESSION['lang']['akunservice'] . "</td><td><input type=text id=noakun size=16 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext maxlength=16></td></tr>\r\n     </table>\r\n         <input type=hidden id=method value='insert'>\r\n         <button class=mybutton onclick=simpanVhc()>" . $_SESSION['lang']['save'] . "</button>\r\n         <button class=mybutton onclick=cancelVhc()>" . $_SESSION['lang']['cancel'] . "</button>\r\n         </fieldset>";
Example #6
0
<?php

//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
OPEN_BOX();
?>
<script language=javascript src=js/zMaster.js></script>
<link rel=stylesheet type=text/css href=style/zTable.css>
<?php 
#======Select Prep======
# Get Data
$optApp = getEnum($dbname, 'setup_posting', 'kodeaplikasi');
$optJab = makeOption($dbname, 'sdm_5jabatan', 'kodejabatan,namajabatan');
#======End Select Prep======
#=======Form============
echo "<div style='margin-bottom:30px'>";
$els = array();
# Fields
$els[] = array(makeElement('kodeaplikasi', 'label', $_SESSION['lang']['kodeaplikasi']), makeElement('kodeaplikasi', 'select', '', array('style' => 'width:150px'), $optApp));
$els[] = array(makeElement('jabatan', 'label', $_SESSION['lang']['jabatan']), makeElement('jabatan', 'select', '', array('style' => 'width:150px'), $optJab));
# Fields
$fieldStr = '##kodeaplikasi##jabatan';
$fieldArr = explode("##", substr($fieldStr, 2, strlen($fieldStr) - 2));
# Button
$opt = array('jabatan' => $optJab);
$btnConfig = array('freeze' => 'kodeaplikasi', 'empty' => true, 'opt' => json_encode($opt));
$els['btn'] = array(genFormBtnConfig($fieldStr, 'setup_posting', "##kodeaplikasi##jabatan", $btnConfig));
} else {
    if ($_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
        $add = " and induk = '" . $_SESSION['empl']['kodeorganisasi'] . "'";
    } else {
        $add = "and kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'";
    }
}
//inisialisasi unit
//$optUnit="<option value=''>".$_SESSION['lang']['all']."</option>";
$sUnit = "select distinct kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi where tipe='KEBUN' " . $add . " order by namaorganisasi asc";
$qUnit = mysql_query($sUnit) or die(mysql_error($conn));
$optUnit = "";
while ($rUnit = mysql_fetch_assoc($qUnit)) {
    $optUnit .= "<option value='" . $rUnit['kodeorganisasi'] . "'>" . $rUnit['namaorganisasi'] . "</option>";
}
$arrOptIP = getEnum($dbname, 'setup_blok', 'intiplasma');
$optIP = '';
$optIP .= "<option value=''>" . $_SESSION['lang']['all'] . "</option>";
foreach ($arrOptIP as $val) {
    if ($val == "I") {
        $optIP .= "<option value='" . $val . "'>Inti</option>";
    } else {
        $optIP .= "<option value='" . $val . "'>Plasma</option>";
    }
}
$arr = "##periode##unit##intiplasma";
?>
<div>
	<fieldset style="float: left;">
		<legend><b>Laporan Biaya Per Blok</b></legend>
		<table cellspacing="1" border="0">
Example #8
0
$tanggalDt = tanggalsystem($_POST['tanggalDt']);
$tglAwal = explode("-", $_POST['tglAwal']);
$tgl1 = $tglAwal[2] . "-" . $tglAwal[1] . "-" . $tglAwal[0];
$tglEnd = explode("-", $_POST['tglEnd']);
$tgl2 = $tglEnd[2] . "-" . $tglEnd[1] . "-" . $tglEnd[0];
$jamDr = $_POST['jam1'] . ":" . $_POST['mnt1'];
$jamSmp = $_POST['jam2'] . ":" . $_POST['mnt2'];
$jamDr1 = $tgl1 . " " . $jamDr;
$jamSmp1 = $tgl2 . " " . $jamSmp;
$agenda = $_POST['agenda'];
$room = $_POST['room'];
$pic = $_POST['pic'];
$idData = $_POST['idData'];
$er = " lokasitugas='" . $_SESSION['empl']['lokasitugas'] . "'";
$optNm = makeOption($dbname, 'datakaryawan', 'karyawanid,namakaryawan', $er);
$arrenum = getEnum($dbname, 'qc_5final', 'color');
foreach ($arrenum as $key => $val) {
    $optJK[$key] = $val;
}
$idData = $_POST['idData'];
#validasi
if ($tgl1 > $tgl2) {
    exit('Error: Tanggal Salah');
} else {
    if ($tgl1 == $tgl2 and $_POST['jam1'] > $_POST['jam2']) {
        exit("Error: Tanggal atau Jam Salah");
    }
}
#validasi jika waktu sudah digunakan orang lain
if ($method == 'insert' or $method == 'updateData') {
    $str = "select * from " . $dbname . ".sdm_ruangrapat where roomname='" . $room . "' and tanggal='" . $tanggalDt . "' and status='Reserved'";
Example #9
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=javascript src='js/zTools.js'></script>
<script language=javascript1.2 src='js/it_slave_5porsiNilai.js'></script>
<?php 
include 'master_mainMenu.php';
OPEN_BOX('', "Standard Kepuasan");
$arr = "##kode##jmlhPorsi##method";
$optagama = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optank = $optagama;
$arragama = getEnum($dbname, 'it_presentasenilai', 'kode');
foreach ($arragama as $kei => $fal) {
    $optagama .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
echo "<fieldset style='width:500px;'><table>\r\n<tr><td>" . $_SESSION['lang']['kodeabs'] . "</td><td><select id=kode style=width:105px>" . $optagama . "</select></td></tr>\r\n<tr><td>" . $_SESSION['lang']['jumlah'] . "</td><td><input type=text id=jmlhPorsi size=45  maxlength=45 onkeypress=\"return angka_doang(event);\" class=myinputtext></td></tr>\r\n           \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_5porsiNilai','" . $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();
Example #10
0
        $optAkun .= "<option value='" . $bar->noakun . "'>[" . $bar->noakun . "]-" . $bar->namaakun . "</option>";
    }
}
if ($_SESSION['language'] == 'EN') {
    $zz = "namaakun1 as namaakun";
} else {
    $zz = "namaakun";
}
$stru = "select noakun," . $zz . " from " . $dbname . ".keu_5akun where length(noakun) = 7";
$res = mysql_query($stru);
$optAkunak = '';
while ($bar = mysql_fetch_object($res)) {
    $namaakun[$bar->noakun] = $bar->namaakun;
    $optAkunak .= "<option value='" . $bar->noakun . "'>[" . $bar->noakun . "]-" . $bar->namaakun . "</option>";
}
$optTipeDep = getEnum($dbname, 'sdm_5tipeasset', 'metodepenyusutan');
$tipeDep = "";
foreach ($optTipeDep as $key => $val) {
    $tipeDep .= "<option value='" . $val . "'>" . ucfirst($val) . "</option>";
}
OPEN_BOX('', $_SESSION['lang']['tipeasset']);
echo "<fieldset style='width:600px;'><table>\r\n     <tr><td>" . $_SESSION['lang']['kode'] . "</td><td><input type=text id=kodetipe size=4 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['namakelompok'] . "</td><td><input type=text id=namatipe size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n\t <tr><td>" . $_SESSION['lang']['namakelompok'] . "(EN)</td><td><input type=text id=namatipe1 size=40 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>             \r\n\t <tr><td>" . $_SESSION['lang']['namaakun'] . "</td><td><select id=noakun>" . $optAkun . "</select></td></tr>\r\n     <tr><td>" . $_SESSION['lang']['aktivadalam'] . "</td><td><select id=noakunak>" . $optAkunak . "</select></td></tr>\r\n\t <tr><td>Metode Penyusutan</td><td><select id=tppenyusutan>" . $tipeDep . "</select></td></tr>\r\n     </table>\r\n\r\n\t <input type=hidden id=method value='insert'>\r\n\t <button class=mybutton onclick=simpanTipeAset()>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelTipeAsset()>" . $_SESSION['lang']['cancel'] . "</button>\r\n\t </fieldset>";
echo open_theme($_SESSION['lang']['availvhc']);
echo "<div>";
$str1 = "select * from " . $dbname . ".sdm_5tipeasset \r\n\t\t   order by namatipe";
$res1 = mysql_query($str1);
echo "<table class=sortable cellspacing=1 border=0 style='width:1000px;'>\r\n\t     <thead>\r\n\t\t <tr class=rowheader>\r\n\t\t <td style='width:150px;'>" . $_SESSION['lang']['kode'] . "</td>\r\n\t\t <td>" . $_SESSION['lang']['namakelompok'] . "</td>\r\n         <td>" . $_SESSION['lang']['namakelompok'] . "(EN)</td>\r\n\t\t <td>" . $_SESSION['lang']['namaakun'] . "</td>\r\n         <td>" . $_SESSION['lang']['aktivadalam'] . "</td>\r\n\t\t <td>Metode Penyusutan</td>\r\n\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->kodetipe . "</td>\r\n\t\t\t <td>" . $bar1->namatipe . "</td>\r\n             <td>" . $bar1->namatipe1 . "</td>\r\n\t\t\t <td>" . $namaakun[$bar1->noakun] . "</td>\r\n             <td>" . $namaakun[$bar1->akunak] . "</td>\r\n\t\t\t <td>" . ucfirst($bar1->metodepenyusutan) . "</td>\r\n\t\t\t <td><img src=images/application/application_edit.png class=resicon  caption='Edit' onclick=\"fillField('" . $bar1->kodetipe . "','" . $bar1->namatipe . "','" . $bar1->namatipe1 . "','" . $bar1->noakun . "','" . $bar1->akunak . "','" . $bar1->metodepenyusutan . "');\"></td></tr>";
}
echo "\t \r\n\t\t </tbody>\r\n\t\t <tfoot>\r\n\t\t </tfoot>\r\n\t\t </table>";
Example #11
0
//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include 'lib/zMysql.php';
include 'lib/zFunction.php';
echo open_body();
?>
<script language=javascript src='js/zTools.js'></script>
<script language=javascript1.2 src='js/it_5stKepuasan.js'></script>
<?php 
include 'master_mainMenu.php';
OPEN_BOX('', "Standard Kepuasan");
$arr = "##kode##nilKode##ket##method";
$optagama = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optank = $optagama;
$arragama = getEnum($dbname, 'it_stkepuasan', 'kode');
foreach ($arragama as $kei => $fal) {
    $optagama .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
$arrankg = array("1" => "Sangat Memuaskan", "2" => "Memuaskan", "3" => "Cukup", "4" => "Kurang");
foreach ($arrankg as $kei => $fal) {
    $optank .= "<option value='" . $kei . "'>" . $kei . "</option>";
}
echo "<fieldset style='width:500px;'><table>\r\n<tr><td>" . $_SESSION['lang']['kode'] . "</td><td><select id=kode style=width:105px>" . $optagama . "</select></td></tr>\r\n<tr><td>Nilai</td><td><select id=nilKode style=width:105px>" . $optank . "</select></td></tr>\r\n<tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td><input type=text id=ket size=45  maxlength=45 onkeypress=\"return tanpa_kutip(event);\" class=myinputtext></td></tr>\r\n           \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_5stKepuasan','" . $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();
Example #12
0
<link rel=stylesheet type=text/css href=style/zTable.css>
<?php 
//Get Data Kebun
$optKebun = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optNmOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') {
    $sKebun = "select kodeorganisasi from " . $dbname . ".organisasi where tipe = 'KEBUN' ";
} else {
    $sKebun = "select kodeorganisasi from " . $dbname . ".organisasi where tipe = 'KEBUN' and kodeorganisasi = '" . $_SESSION['empl']['lokasitugas'] . "'";
}
$qBlok = mysql_query($sKebun) or die(mysql_error());
while ($rBlok = mysql_fetch_assoc($qBlok)) {
    $optKebun .= "<option value='" . $rBlok['kodeorganisasi'] . "'>" . $optNmOrg[$rBlok['kodeorganisasi']] . "</option>";
}
//Get Data Jenis Denda
$arrayJenDenda = getEnum($dbname, 'kebun_5dendapanen', 'jenisdenda');
foreach ($arrayJenDenda as $value) {
    $optJenDenda .= "<option value=" . $value . ">" . $value . "</option>";
}
//Get Data Kode Denda
$optKdDenda = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$sKdDenda = "select * from " . $dbname . ".kebun_5kodedendapanen";
$qKdDenda = mysql_query($sKdDenda) or die(mysql_error());
while ($rKdDenda = mysql_fetch_assoc($qKdDenda)) {
    $optKdDenda .= "<option value='" . $rKdDenda['kodedenda'] . "'>" . $rKdDenda['kodedenda'] . " - " . $rKdDenda['deskripsi'] . "</option>";
}
?>
<fieldset>
	<legend><?php 
echo $_SESSION['lang']['dendapanen'];
?>
Example #13
0
$frm[3] .= "<fieldset ><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>\r\n    <table cellpadding=1 cellspacing=1 border=0>\r\n    <tr>\r\n        <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='tglCari3' onmousemove='setCalendar(this.id)' onkeypress='return false;'  size='10' maxlength='10' style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['batch'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='batchCari3'  style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['status'] . "</td>\r\n        <td><select id=statCari3  style=\"width:150px;\">" . $optStatPos . "</select></td>\r\n    </tr>\r\n    </table>\r\n    <button class=mybutton id=btlTmbl name=btlTmbl onclick=loadData2()  >" . $_SESSION['lang']['find'] . "</button>\r\n    <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']['kodetransaksi'] . "</td>\r\n            <td>" . $_SESSION['lang']['batch'] . "</td>\r\n            <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n            <td>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n            <td>" . $_SESSION['lang']['tujuan'] . "</td>\r\n            <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n            <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n            <td colspan=2>" . $_SESSION['lang']['action'] . "</td>\r\n            </tr>\r\n            </thead><tbody id=containData2>\r\n\t\t";
$frm[3] .= "</tbody></table></fieldset>";
############################################################################
$frm[2] .= "<input type='hidden' id='proses3' value='saveTab3' /><fieldset  style=width:650px;><legend>" . $_SESSION['lang']['afkirbibit'] . "</legend>\r\n<table cellspacing=1 border=0>\r\n\r\n<tr><td>" . $_SESSION['lang']['kodetransaksi'] . "</td><td>:</td><td><input type='text' class='myinputtext'  style='width:150px;' id='kdTransAfk' value='AFB'  disabled /></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['batch'] . "</td><td>:</td><td><select id='batchAfk' style='width:150px' onchange='getKodeorg2()'>" . $optbatch . "</select></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['tanggal'] . "</td><td>:</td><td><input type=text class=myinputtext id='tglAfkirBibit' style='width:150px;' onmousemove=setCalendar(this.id) onkeypress=return false;  size=10 maxlength=10 /></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['kodeorg'] . "</td><td>:</td><td><select id='kdOrgAfk' style=width:150px>" . $optKdorg . "</select></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['jumlah'] . "</td><td>:</td><td><input type='text' class='myinputtextnumber'  style='width:150px;' id='jmlhAfk' onkeypress='return angka_doang(event)' value='0' />&nbsp;Seed(Bibit)</td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td>:</td><td><input type='text' class='myinputtext'  style='width:150px;' id='ketAfk' onkeypress='return tanpa_kutip(event)' maxlength=45 /></td></tr>";
$frm[2] .= "<tr><td colspan=3><button class=mybutton   name=btlTmbl onclick=saveData(3)  >" . $_SESSION['lang']['save'] . "</button><button class=mybutton   name=canbtlTmbl onclick=cancelData3()  >" . $_SESSION['lang']['cancel'] . "</button></td></tr></table><br /></fieldset>\r\n";
$frm[2] .= "<fieldset><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>\r\n    <table cellpadding=1 cellspacing=1 border=0>\r\n    <tr>\r\n        <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='tglCari4' onmousemove='setCalendar(this.id)' onkeypress='return false;'  size='10' maxlength='10' style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['batch'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='batchCari4'  style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['status'] . "</td>\r\n        <td><select id=statCari4  style=\"width:150px;\">" . $optStatPos . "</select></td>\r\n    </tr>\r\n    </table>\r\n    <button class=mybutton id=btlTmbl name=btlTmbl onclick=loadData3()  >" . $_SESSION['lang']['find'] . "</button>\r\n    <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']['kodetransaksi'] . "</td>\r\n            <td>" . $_SESSION['lang']['batch'] . "</td>\r\n\t    <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n            <td>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n            <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n            <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n            <td colspan=2>" . $_SESSION['lang']['action'] . "</td>\r\n            </tr>\r\n            </thead><tbody id=containData3>\r\n\t\t";
$frm[2] .= "</tbody></table></fieldset>";
###############################################################################################
###################################################################################################
$frm[1] .= "<input type='hidden' id='proses5' value='saveTab5' /><fieldset  style=width:650px;><legend>" . $_SESSION['lang']['doubletoon'] . "</legend>\r\n<table cellspacing=1 border=0>\r\n\r\n<tr><td>" . $_SESSION['lang']['kodetransaksi'] . "</td><td>:</td><td><input type='text' class='myinputtext'  style='width:150px;' id='kdTransaksiDbt' value='DBT'  disabled /></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['batch'] . "</td><td>:</td><td><select id='batchDbt' style='width:150px' onchange='getKodeorg3()'>" . $optbatch . "</select></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['tanggal'] . "</td><td>:</td><td><input type=text class=myinputtext id='tglDbt' style='width:150px;' onmousemove=setCalendar(this.id) onkeypress=return false;  size=10 maxlength=10 /></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['kodeorg'] . "</td><td>:</td><td><select id='kdOrgDbt' style=width:150px>" . $optKdorg . "</select></td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['jumlah'] . "</td><td>:</td><td><input type='text' class='myinputtextnumber'  style='width:150px;' id='jmlhDbt' onkeypress='return angka_doang(event)' value='0' />&nbsp;Seed(Bibit)</td></tr>\r\n\r\n<tr><td>" . $_SESSION['lang']['keterangan'] . "</td><td>:</td><td><input type='text' class='myinputtext'  style='width:150px;' id='ketDbt' onkeypress='return tanpa_kutip(event)' maxlength=45 /></td></tr>";
$frm[1] .= "<tr><td colspan=3><button class=mybutton id=btlTmbl name=btlTmbl onclick=saveData(5)  >" . $_SESSION['lang']['save'] . "</button><button class=mybutton id='' name=canbtlTmbl onclick=cancelData5()  >" . $_SESSION['lang']['cancel'] . "</button></td></tr></table><br /></fieldset>\r\n";
$frm[1] .= "<fieldset><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend>\r\n    <table cellpadding=1 cellspacing=1 border=0>\r\n    <tr>\r\n        <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='tglCari5' onmousemove='setCalendar(this.id)' onkeypress='return false;'  size='10' maxlength='10' style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['batch'] . "</td>\r\n        <td><input type='text' class='myinputtext' id='batchCari5'  style=\"width:150px;\" /></td>\r\n        <td>" . $_SESSION['lang']['status'] . "</td>\r\n        <td><select id=statCari5  style=\"width:150px;\">" . $optStatPos . "</select></td>\r\n    </tr>\r\n    </table>\r\n    <button class=mybutton id=btlTmbl name=btlTmbl onclick=loadData5()  >" . $_SESSION['lang']['find'] . "</button>\r\n    <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']['kodetransaksi'] . "</td>\r\n            <td>" . $_SESSION['lang']['batch'] . "</td>\r\n\t\t\t<td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n            <td>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n            <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n            <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n            <td colspan=2>" . $_SESSION['lang']['action'] . "</td>\r\n            </tr>\r\n            </thead><tbody id=containData5>\r\n\t\t";
$frm[1] .= "</tbody></table></fieldset>";
###################################################################################################
$optKegiatan = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arragama = getEnum($dbname, 'bibitan_mutasi', 'jenistanam');
foreach ($arragama as $kei => $fal) {
    $optKegiatan .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
$arr = array("Ditanam(Internal)", "Disisipi(Internal)", "Dijual(External)", "Afiliasi");
$optintex = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
foreach ($arr as $isi => $eia) {
    $optintex .= "<option value=" . $isi . " >" . $eia . "</option>";
}
$optKode = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optAfd = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optKaryawan = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$sKaryawan = "select distinct karyawanid,namakaryawan from " . $dbname . ".datakaryawan a\r\n\tleft join " . $dbname . ".sdm_5jabatan b ON a.kodejabatan = b.kodejabatan\r\n\twhere tipekaryawan='0' and karyawanid!='" . $_SESSION['standard']['userid'] . "'\r\n\tAND substr(lokasitugas,3,2) != 'HO'\r\n\tAND namajabatan like '%assist%'";
$qKaryawan = mysql_query($sKaryawan) or die(mysql_error($sKaryawan));
while ($rKaryawan = mysql_fetch_assoc($qKaryawan)) {
    $optKaryawan .= "<option value='" . $rKaryawan['karyawanid'] . "'>" . $rKaryawan['namakaryawan'] . "</option>";
Example #14
0
    $optaset .= "<option value='" . $bar->kodetipe . "'>" . $bar->kodetipe . " - " . $bar->namatipe . "</option>";
}
$kamusjenis['AK'] = 'Aktiva Dalam Konstruksi/Activa Under Construction';
$kamusjenis['PB'] = 'Pabrikasi';
$optjenis = "";
$arrjenis = getEnum($dbname, 'project', 'tipe');
foreach ($arrjenis as $kei => $fal) {
    if ($fal == 'PB') {
        #Pabrikasi  belum aktif  karena akunnya belum ada, pastikan akunnya sudah ada dan didaftar  pada parameter jurnal dengan kode
        #PAB
    } else {
        $optjenis .= "<option value='" . $kei . "'>" . $fal . " " . $kamusjenis[$fal] . "</option>";
    }
}
$optKel = "";
$arrKel = getEnum($dbname, 'project', 'kelompok');
foreach ($arrKel as $kel) {
    $optKel .= "<option value='" . $kel . "'>" . $kel . "</option>";
}
$optSatuan = makeOption($dbname, 'setup_satuan', 'satuan,satuan');
echo "<fieldset style='width:500px;'>\r\n    <legend>Project</legend>\r\n    <table cellspacing=1 border=0>\r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['unit'] . "\r\n    </td><td>\r\n        <select id=unit style='width:200px;'>" . $optunit . "</select>\r\n    </td></tr>\r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['aset'] . "\r\n    </td><td>\r\n        <select id=aset onchange=getSub() style='width:200px;'>" . $optaset . "</select>\r\n    </td></tr>\r\n    \r\n    <tr><td align=right>\r\n        Sub Asset\r\n    </td><td>\r\n        <select id=sub style='width:200px;'>" . $optSub . "</select>\r\n    </td></tr>\r\n\r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['jenis'] . "\r\n    </td><td>\r\n        <select id=jenis style='width:200px;'>" . $optjenis . "</select>\r\n    </td></tr>\r\n    \r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['nama'] . "\r\n    </td><td>\r\n        <input type=text id=nama class=myinputtext maxlength=100 onkeypress=\"return tanpa_kutip(event);\" style='width:200px;'>\r\n    </td></tr>\r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['tanggalmulai'] . "\r\n    </td><td>\r\n        <input style='width:200px;' id=tanggalmulai class=myinputtext maxlength=10 onkeypress=\"return false;\" size=10 onmousemove=setCalendar(this.id) value=" . date('d-m-Y') . ">\r\n    </td></tr>\r\n    <tr><td align=right>\r\n        " . $_SESSION['lang']['tanggalsampai'] . "\r\n    </td><td>\r\n        <input style='width:200px;' id=tanggalselesai class=myinputtext maxlength=10 onkeypress=\"return false;\" size=10 onmousemove=setCalendar(this.id) value=" . date('d-m-Y') . ">\r\n    </td></tr>\r\n    \r\n    </table>\r\n    <input type=hidden value=insert id=method>\r\n    <input type=hidden value='' id=kode>\r\n    <button class=mybutton onclick=simpan()>" . $_SESSION['lang']['save'] . "</button>\r\n    <button class=mybutton onclick=batal()>" . $_SESSION['lang']['cancel'] . "</button>\t \r\n    </fieldset>";
//$qwe=addZero('qwe',5);
//echo "qwe:".$qwe;
echo "<div id=dataDisimpan><fieldset style=width:800px;><legend>" . $_SESSION['lang']['datatersimpan'] . "</legend><div style='height:350px;width:1200px;overflow:scroll;'>\r\n      <table class=sortable border=0 cellspacing=1>\r\n\t  <thead>\r\n\t  <tr>\r\n\t  <td align=center>" . $_SESSION['lang']['kode'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['unit'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['jenis'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['nama'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['tanggalmulai'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['tanggalsampai'] . "</td>\r\n          <td align=center>" . $_SESSION['lang']['updateby'] . "</td>\r\n\t  <td align=center>" . $_SESSION['lang']['action'] . "</td>\r\n          <td align=center>" . $_SESSION['lang']['print'] . "</td>\r\n\t  </tr>\r\n\t  </thead>\r\n\t  <tbody id=container>";
echo "<script>loadData()</script>";
echo "</tbody>\r\n    <tfoot>\r\n    </tfoot>\r\n    </table>\r\n    </div></fieldset></div>";
echo "<div id=detailInput style=display:none>";
$frmdt = "<fieldset style=width:800px;><legend>" . $_SESSION['lang']['detail'] . "</legend>";
$frmdt .= "<table cellpadding=1 cellspacing=1 border=0 class=sortable>";
$frmdt .= "<thead><tr><td>" . $_SESSION['lang']['kode'] . "</td>";
$frmdt .= "<td>" . $_SESSION['lang']['namakegiatan'] . "</td>";
Example #15
0
$thnTmn = checkPostGet('thnTmn', '');
$haNon = checkPostGet('haNon', '');
$jmlh = checkPostGet('jmlh', '');
$pkkProduktif = checkPostGet('pkkProduktif', '');
$pkkProdukBr = checkPostGet('pkkProdukBr', '');
$thnAngBr = checkPostGet('thnAngBr', '');
$afdIdBr = checkPostGet('afdIdBr', '');
$kdBlokBr = checkPostGet('kdBlokBr', '');
$haThnIniBr = checkPostGet('haThnIniBr', '');
$topoGrafiBr = checkPostGet('topoGrafiBr', '');
$thnTmnBr = checkPostGet('thnTmnBr', '');
$pokokThnIniBr = checkPostGet('pokokThnIniBr', '');
$haNonBr = checkPostGet('haNonBr', '');
$statBlokBr = checkPostGet('statBlokBr', '');
$sumber = checkPostGet('sumber', '');
$arrStatusBlok = getEnum($dbname, 'setup_blok', 'statusblok');
$optTopografi = makeOption($dbname, 'setup_topografi', 'topografi,keterangan');
$optTopografi2 = makeOption($dbname, 'setup_topografi', 'keterangan,topografi');
$sumber = checkPostGet('sumber', '');
$thnAngrnOld = checkPostGet('thnAngrnOld', '');
$oldBlok = checkPostGet('oldBlok', '');
$topoGrafOld = checkPostGet('topoGrafOld', '');
$lcThnini = checkPostGet('lcThnini', '');
$lcThnBr = checkPostGet('lcThnBr', '');
$a = 1;
$b = 1;
$totTpGrafot = 0;
foreach ($arrStatusBlok as $brs) {
    $dtBlok[$a] = $brs;
    $a++;
}
$optPeriode = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$lksiTugas = substr($_SESSION['empl']['lokasitugas'], 0, 4);
$sPeriode = "select distinct periode from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $lksiTugas . "'";
$qPeriode = mysql_query($sPeriode) or die(mysql_error());
while ($rPeriode = mysql_fetch_assoc($qPeriode)) {
    $optPeriode .= "<option value=" . $rPeriode['periode'] . ">" . substr(tanggalnormal($rPeriode['periode']), 1, 7) . "</option>";
}
$optTipe = "<option value=''>" . $_SESSION['lang']['all'] . "</option>";
$sTipe = "select id,tipe from " . $dbname . ".sdm_5tipekaryawan order by tipe asc";
$qTipe = mysql_query($sTipe) or die(mysql_error());
while ($rTipe = mysql_fetch_assoc($qTipe)) {
    $optTipe .= "<option value=" . $rTipe['id'] . ">" . $rTipe['tipe'] . "</option>";
}
$optGaji = "<option value='All'>" . $_SESSION['lang']['pilihdata'] . "</option>";
//		$optsisgaji='';
$arrsgaj = getEnum($dbname, 'datakaryawan', 'sistemgaji');
foreach ($arrsgaj as $kei => $fal) {
    $optGaji .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
$arr = "##kdOrg##periode##tgl1##tgl2##tipeKary##sistemGaji";
$arrThn = "##kdeOrg2##periodThn##periodThnSmp##sistemGaji3##tipeKary2";
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') {
    $arrThn = "";
    $arr = "";
    $arr = "##kdOrg##periode##tgl1##tgl2##tipeKary##sistemGaji##afdId";
    $arrThn = "##kdeOrg2##periodThn##periodThnSmp##sistemGaji3##tipeKary2##nilaiMax";
    $optOrg = "<select id=kdOrg name=kdOrg onchange=getPeriode() style=\"width:150px;\" ><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
    $optOrg2 = "<select id=kdeOrg name=kdeOrg onchange=getKry() style=\"width:150px;\" ><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
    $optOrg3 = "<select id=kdeOrg2 name=kdeOrg2 onchange=getPeriodeGaji5() style=\"width:150px;\" ><option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
    $sOrg = "select namaorganisasi,kodeorganisasi from " . $dbname . ".organisasi where tipe in ('KEBUN','PABRIK','KANWIL','TRAKSI') order by namaorganisasi asc ";
} elseif ($_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
Example #17
0
<?php

//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
?>
<script language=javascript src='js/zTools.js'></script>
<script language=javascript src='js/sdm_promosi.js'></script>
<?php 
OPEN_BOX('', $_SESSION['lang']['promosidemosi']);
$pos = getEnum($dbname, 'sdm_riwayatjabatan', 'tipesk');
$opts = "<option value=''></option>";
foreach ($pos as $key => $val) {
    if ($val == 'Promosi') {
        $caption = $_SESSION['lang']['Promosi'];
    } else {
        if ($val == 'Demosi') {
            $caption = $_SESSION['lang']['Demosi'];
        } else {
            if ($val == 'Mutasi') {
                $caption = $_SESSION['lang']['Mutasi1'];
            } else {
                $caption = $_SESSION['lang']['Penyesuaian'];
            }
        }
    }
    $opts .= "<option value='" . $val . "'>" . $caption . "</option>";
}
 }
 $optFranco = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
 $sFranco = "select distinct id_franco,franco_name from " . $dbname . ".setup_franco order by franco_name asc";
 $qFranco = mysql_query($sFranco) or die(mysql_error($conn));
 while ($rFranco = mysql_fetch_assoc($qFranco)) {
     if ($franco != '') {
         $optFranco .= "<option value='" . $rFranco['id_franco'] . "' " . ($franco == $rFranco['id_franco'] ? "selected" : "") . ">" . $rFranco['franco_name'] . "</option>";
     } else {
         $optFranco .= "<option value='" . $rFranco['id_franco'] . "'>" . $rFranco['franco_name'] . "</option>";
     }
 }
 $optpildt = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
 foreach ($arrd as $lstdt => $isiArrd) {
     $optpildt .= "<option value='" . $lstdt . "' " . ($lstdt == $piland ? "selected" : "") . ">" . $isiArrd . "</option>";
 }
 $arragama = getEnum($dbname, 'log_pengiriman_ht', 'moda_trans');
 foreach ($arragama as $kei => $fal) {
     $optmoda .= "<option value='" . $kei . "' " . ($kei == $moda_trams ? "selected" : "") . ">" . $fal . "</option>";
 }
 $tab .= "<fieldset style=width:850px;float:left;>\r\n                       <legend>INTERNAL DELIVERY</legend>\r\n                 <table>\r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['suratjalan'] . "</td>\r\n                   <td><input type=text class=myinputtext id=srtJalan name=srtJalan disabled style=\"width:150px;\" value='" . $notrans . "'  /></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['tgl_kirim'] . "</td>\r\n                   <td>\r\n                   <input type=text class=myinputtext id=tglKrm onmousemove=setCalendar(this.id) onkeypress='return false';  size=10 maxlength=10 style=\"width:150px;\" value='" . $tglharini . "' /></td>\r\n                 </tr>\r\n                  <tr>\r\n                   <td>Number of Package</td>\r\n                   <td><input type=text class=myinputtextnumber id=jlhKoli name=jlhKoli onkeypress=\"return angka_doang(event);\" style=\"width:150px;\" value='" . $jmlhkoli . "' /> </td>\r\n                 </tr>\r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['status'] . "</td>\r\n                   <td><select id=idPilihanExin  style='width:150px' onchange='ubahdata()'>" . $optpildt . "</select></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['expeditor'] . "</td>\r\n                   <td><select id=\"id_supplier\" name=\"id_supplier\" style=\"width:150px;\" " . $dissupplier . " >" . $optSupplier . "</select>&nbsp;\r\n                 <img src='images/search.png' class=dellicon title='" . $_SESSION['lang']['findRkn'] . "' onclick=\"searchSupplier('" . $_SESSION['lang']['findRkn'] . "','<fieldset><legend>" . $_SESSION['lang']['findRkn'] . "</legend>" . $_SESSION['lang']['namasupplier'] . "&nbsp;<input type=text class=myinputtext id=nmSupplier><button class=mybutton onclick=findSupplier()>" . $_SESSION['lang']['find'] . "</button></fieldset><div id=containerSupplier style=overflow=auto;height=380;width=485></div>',event);\"></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['internal'] . "</td>\r\n                   <td><select id=\"id_internal\" name=\"id_internal\" style=\"width:150px;\"  " . $diskaryawan . "  >" . $optKary2 . "</select>&nbsp;\r\n                   <img src='images/search.png' class=dellicon title='" . $_SESSION['lang']['find'] . "' onclick=\"searchInternal('" . $_SESSION['lang']['find'] . "','<fieldset><legend>" . $_SESSION['lang']['find'] . " " . $_SESSION['lang']['namakaryawan'] . "</legend>" . $_SESSION['lang']['namakaryawan'] . "&nbsp;<input type=text class=myinputtext id=nmKaryawan><button class=mybutton onclick=findKaryawan()>" . $_SESSION['lang']['find'] . "</button></fieldset><div id=containerKaryawan style=overflow=auto;height=380;width=485></div>',event);\" /></td>\r\n                 </tr> \r\n                  <tr>\r\n                   <td>" . $_SESSION['lang']['lokasipenerimaan'] . "</td>\r\n                   <td><select id=lokPenerimaan  style=width:150px>" . $optKary . "</select></td>\r\n                 </tr> \r\n                  <tr>\r\n                   <td>Franco</td>\r\n                   <td><select id=franco_id style=width:150px>" . $optFranco . "</select></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['modatransportasi'] . "</td>\r\n                   <td><select id=moda_trans style=width:150px>" . $optmoda . "</select></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['berat'] . "</td>\r\n                   <td><input type=text class=myinputtextnumber onkeypress='return angka_doang(event)' id=beratKg style=\"width:150px;\" onblur='kaliaja()' value='" . $berat . "' /> Kg</td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['biaya'] . " per Kg</td>\r\n                   <td><input type=text class=myinputtextnumber onkeypress='return angka_doang(event)' id=biayaPerkg style=\"width:150px;\" onblur='kaliaja()'  value='" . $biyperkg . "'   /></td>\r\n                 </tr> \r\n                  <tr>\r\n                   <td>" . $_SESSION['lang']['biaya'] . " Packing</td>\r\n                   <td><input type=text class=myinputtextnumber id=biayapckng name=biayapckng onkeypress=\"return angka_doang(event);\" style=\"width:150px;\"  value='" . $biyperpcking . "'  onblur='kaliaja()' /></td>\r\n                 </tr> \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['biaya'] . "</td>\r\n                   <td><input type=text class=myinputtextnumber id=biaya name=biaya onkeypress=\"return angka_doang(event);\" style=\"width:150px;\"  value='" . $biayakirim . "'  /></td>\r\n                 </tr> \r\n                \r\n                 <tr>\r\n                   <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n                   <td><input type=text class=myinputtext id=ket name=ket onkeypress=\"return tanpa_kutip(event);\" style=\"width:150px;\" value='" . $ketrngan . "'  /></td>\r\n                 </tr> \r\n                 </table>";
 $tab .= "<table cellpadding=1 cellspacing=1 border=0 class=sortable>";
 $tab .= "<thead><tr class=rowheader>";
 $tab .= "<td>" . $_SESSION['lang']['notransaksi'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['nopo'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['kodebarang'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['namabarang'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['satuan'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['jumlah'] . "</td>";
 $tab .= "<td>" . $_SESSION['lang']['jumlah'] . " " . $_SESSION['lang']['pengiriman'] . "</td>";
 $tab .= "<td>Action</td></tr><tbody id=detailDtBarang>";
 if ($statInputan == 0) {
}
$optKary = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$sOrg = "select karyawanid, namakaryawan from " . $dbname . ".datakaryawan where (tanggalkeluar = '0000-00-00' or tanggalkeluar > '" . date("Y-m-d") . "') and tipekaryawan in ('0','7','8') and karyawanid!='" . $_SESSION['standard']['userid'] . "' order by namakaryawan asc";
$qOrg = mysql_query($sOrg) or die(mysql_error());
while ($rOrg = mysql_fetch_assoc($qOrg)) {
    $optKary .= "<option value=" . $rOrg['karyawanid'] . ">" . $rOrg['namakaryawan'] . "</option>";
}
//Pengambilan karyawan HRD
$optHRD = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$sHRD = "select karyawanid, namakaryawan from " . $dbname . ".datakaryawan where (tanggalkeluar = '0000-00-00' or tanggalkeluar > '" . date("Y-m-d") . "') and tipekaryawan in ('0','7','8') and bagian in ('HRD','HHRD','HRA') and karyawanid!='" . $_SESSION['standard']['userid'] . "' order by namakaryawan asc";
$qHRD = mysql_query($sHRD) or die(mysql_error());
while ($rHRD = mysql_fetch_assoc($qHRD)) {
    $optHRD .= "<option value=" . $rHRD['karyawanid'] . ">" . $rHRD['namakaryawan'] . "</option>";
}
$optJenis = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arragama = getEnum($dbname, 'sdm_ijin', 'jenisijin');
foreach ($arragama as $kei => $fal) {
    if ($_SESSION['language'] == 'ID') {
        $optJenis .= "<option value='" . $kei . "'>" . $fal . "</option>";
    } else {
        switch ($fal) {
            case 'TERLAMBAT':
                $fal = 'Late for work';
                break;
            case 'KELUAR':
                $fal = 'Out of Office';
                break;
            case 'PULANGAWAL':
                $fal = 'Home early';
                break;
            case 'IJINLAIN':
Example #20
0
include 'lib/nangkoelib.php';
include 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
OPEN_BOX();
?>
<script type="text/javascript" src="js/sdm_5bpjs.js"></script>
<link rel=stylesheet type=text/css href=style/zTable.css>
<?php 
//Get Enum lokasi bpjs
$arrenum = getEnum($dbname, 'sdm_5bpjs', 'lokasibpjs');
foreach ($arrenum as $key => $val) {
    $optLokasi .= "<option value='" . $key . "'>" . $val . "</option>";
}
//Get Enum jeni bpjs
$arrenum = getEnum($dbname, 'sdm_5bpjs', 'jenisbpjs');
foreach ($arrenum as $key => $val) {
    $optJenis .= "<option value='" . $key . "'>" . $val . "</option>";
}
?>
<fieldset style='width:550px;float:left'>
	<legend><?php 
echo $_SESSION['lang']['list'] . " BPJS";
?>
</legend>
	<table class="sortable" cellspacing="1" cellpadding="3" border="0">
		<thead>
			<tr class=rowheader>
				<td style='text-align:center;'><?php 
echo $_SESSION['lang']['nourut'];
?>
Example #21
0
?>
<script language=javascript src=js/zTools.js></script>
<script language=javascript1.2 src='js/pmn_hargaTbs.js'></script>
<?php 
//$arr="##tglHarga##kdBarang##satuan##idPasar##idMatauang##hrgPasar##proses";
$arr = "##pabrik##tanggal##supplier##hargab##hargas##hargak##proses";
include 'master_mainMenu.php';
OPEN_BOX();
$optpabrik = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optsupplier = $optpabrik;
$spabrik = "select distinct kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi \r\n    where `tipe` = 'PABRIK' order by kodeorganisasi";
$qpabrik = mysql_query($spabrik) or die(mysql_error($conn));
while ($rpabrik = mysql_fetch_assoc($qpabrik)) {
    $optpabrik .= "<option value='" . $rpabrik['kodeorganisasi'] . "'>" . $rpabrik['namaorganisasi'] . "</option>";
}
$arrukuran = getEnum($dbname, 'pabrik_timbangan', 'kriteriabuah');
foreach ($arrukuran as $kei => $fal) {
    switch ($kei) {
        case 'S':
            $_SESSION['language'] != 'EN' ? $fal = 'Alat Berat' : ($fal = 'Heavy Equipment');
            break;
        case 'M':
            $_SESSION['language'] != 'EN' ? $fal = 'Kendaraan' : ($fal = 'Vehicle');
            break;
        case 'L':
            $_SESSION['language'] != 'EN' ? $fal = 'Mesin' : ($fal = 'Machinery');
            break;
    }
    $optukuran .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
$ssupplier = "select distinct kodetimbangan,namasupplier from " . $dbname . ".log_5supplier \r\n    where kodetimbangan IS NOT NULL and kodetimbangan like '1%' order by namasupplier";
Example #22
0
     <tr><td><?php 
echo $_SESSION['lang']['levelcode'];
?>
</td><td>
	 <?php 
while ($bar = mysql_fetch_object($res)) {
    $optGolongan .= "<option value='" . $bar->kodegolongan . "'>" . $bar->namagolongan . " - " . $bar->kodegolongan . "</option>";
}
$optjenis = '';
$str = "select * from " . $dbname . ".sdm_5jenisbiayapengobatan order by kode";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
    $optjenis .= "<option value='" . $bar->kode . "'>" . $bar->nama . "</option>";
}
$optjeniskelamin = "<option value=''></option>";
$arrenum = getEnum($dbname, 'sdm_pengobatanplafond', 'satuan');
foreach ($arrenum as $key => $val) {
    if ($val == 1) {
        $hVal = 'per tahun';
    } else {
        if ($val == 2) {
            $hVal = 'per hari';
        } else {
            if ($val == 3) {
                $hVal = '1 tahun sekali';
            } else {
                $hVal = '3 tahun sekali';
            }
        }
    }
    $optsatuan .= "<option value='" . $key . "'>" . $hVal . "</option>";
 $table .= "<td>" . $_SESSION['lang']['bulan'] . "</td>";
 $table .= "<td>" . $_SESSION['lang']['sumberHarga'] . "</td>";
 $table .= "<td>" . $_SESSION['lang']['hargaOpen'] . "</td>";
 $table .= "<td>" . $_SESSION['lang']['hargaHigh'] . "</td>";
 $table .= "<td>" . $_SESSION['lang']['hargaLow'] . "</td>";
 $table .= "<td>" . $_SESSION['lang']['hargaClose'] . "</td>";
 $table .= "<td>Action</td>";
 $table .= "</tr>";
 $table .= "</thead>";
 # Data
 $arrBln = array(1 => "Jan", 2 => "Feb", 3 => "Mar", 4 => "Apr", 5 => "Mei", 6 => "Jun", 7 => "Jul", 8 => "Agu", 9 => "Sep", 10 => "Okt", 11 => "Nov", 12 => "Des");
 foreach ($arrBln as $is => $dt) {
     $optBln .= "<option value=" . $dt . ">" . $dt . "</option>";
 }
 $optsmbrhargaEx = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
 $arrsstk = getEnum($dbname, 'pmn_hargapasardt', 'smbrHarga');
 foreach ($arrsstk as $kei => $fal) {
     $optsmbrhargaEx .= "<option value='" . $kei . "'>" . $fal . "</option>";
 }
 $table .= "<tbody id='detailBody'>";
 $table .= "<tr id='detail_tr' class='rowcontent'>";
 $table .= "<td><select id=bln name=bln style='width:150px'>" . $optBln . "</select></td>";
 $table .= "<td><select id=smbrHarga name=smbrHarga style='width:150px'>" . $optsmbrhargaEx . "</select></td>";
 $table .= "<td><input type=\"text\" class=\"myinputtextnumber\" id=\"hargaOp\"  name=\"hargaOp\" onkeypress=\"return angka_doang(event)\" size=\"10\" maxlength=\"10\" value=\"0\" style=\"width:150px;\" /></td>";
 $table .= "<td><input type=\"text\" class=\"myinputtextnumber\" id=\"hargaHig\"  name=\"hargaHig\" onkeypress=\"return angka_doang(event)\" size=\"10\" maxlength=\"10\" value=\"0\" style=\"width:150px;\" /></td>";
 $table .= "<td><input type=\"text\" class=\"myinputtextnumber\" id=\"hargaLo\"  name=\"hargaLo\" onkeypress=\"return angka_doang(event)\" size=\"10\" maxlength=\"10\" value=\"0\" style=\"width:150px;\" /></td>";
 $table .= "<td><input type=\"text\" class=\"myinputtextnumber\" id=\"harga\"  name=\"harga\" onkeypress=\"return angka_doang(event)\" size=\"10\" maxlength=\"10\" value=\"0\" style=\"width:150px;\" /></td>";
 # Add, Container Delete
 $table .= "<td><img id='detail_add' title='Simpan' class=zImgBtn onclick=\"addDetail()\" src='images/save.png'/>";
 $table .= "&nbsp;<img id='detail_delete' /></td>";
 $table .= "</tr>";
Example #24
0
include 'lib/zMysql.php';
echo open_body();
?>
<script language=javascript src=js/zTools.js></script>
<script language=javascript1.2 src='js/sdm_5harilibur.js'></script>

<?php 
$arr = "##kebun##tanggal##keterangan##catatan";
$optKebun = "";
$optKebun .= "<option value='GLOBAL'>GLOBAL</option>";
$strKebun = "select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi where tipe='KEBUN'";
$resKebun = mysql_query($strKebun) or die(mysql_error());
while ($barKebun = mysql_fetch_object($resKebun)) {
    $optKebun .= "<option value='" . $barKebun->kodeorganisasi . "'>" . $barKebun->kodeorganisasi . " - " . $barKebun->namaorganisasi . "</option>";
}
$arrketerangan = getEnum($dbname, 'sdm_5harilibur', 'keterangan');
$optketerangan = "";
foreach ($arrketerangan as $kei => $fal) {
    $optketerangan .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
include 'master_mainMenu.php';
OPEN_BOX();
echo "<fieldset>\r\n     <legend>" . $_SESSION['lang']['harilibur'] . "</legend>\r\n\t <table>\r\n\t <tr>\r\n\t   <td>" . $_SESSION['lang']['kebun'] . "</td>\r\n\t   <td><select id=\"kebun\" name=\"kebun\" style=\"width:150px\">" . $optKebun . "</select></td>\r\n\t </tr>\r\n\t <tr>\r\n\t   <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t   <td><input id=\"tanggal\" name=\"tanggal\" class=\"myinputtext\" onkeypress=\"return tanpa_kutip(event)\" style=\"width:150px\" readonly=\"readonly\" onmousemove=\"setCalendar(this.id)\" type=\"text\"></td>\r\n\t </tr>\r\n        <tr>\r\n            <td><label>" . $_SESSION['lang']['keterangan'] . "</label></td>\r\n            <td><select id=\"keterangan\" name=\"keterangan\" style=\"width:150px\">" . $optketerangan . "</select></td>\r\n            <td>&nbsp;</td>\r\n        </tr>         \r\n\t <tr>\r\n\t   <td>" . $_SESSION['lang']['catatan'] . "</td>\r\n\t   <td><input type=text class=myinputtext id=catatan name=catatan onkeypress=\"return tanpa_kutip(event);\" style=\"width:150px;\" /></td>\r\n\t </tr>\r\n\t </table>\r\n         <input type=hidden value=insert id=method>\r\n         <button class=mybutton onclick=savehk('sdm_slave_5harilibur','" . $arr . "')>" . $_SESSION['lang']['save'] . "</button>\r\n         <button class=mybutton onclick=cancelIsi()>" . $_SESSION['lang']['cancel'] . "</button>\r\n     </fieldset><input type='hidden' id=oldtanggal name=oldtanggal />";
CLOSE_BOX();
OPEN_BOX();
$str = "select * from " . $dbname . ".bgt_hk order by tahunbudget desc";
$res = mysql_query($str);
echo "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend><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   <td>" . $_SESSION['lang']['kebun'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['catatan'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['action'] . "</td>\r\n\t  </tr>\r\n\t </thead>\r\n\t <tbody id=container>";
echo "<script>loadData()</script>";
echo "</tbody>\r\n     <tfoot>\r\n     </tfoot>\r\n     </table></fieldset>";
CLOSE_BOX();
Example #25
0
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include 'lib/zMysql.php';
include 'lib/zFunction.php';
echo open_body();
?>
<script language=javascript src='js/zMaster.js'></script>
<script language=javascript src='js/zTools.js'></script>
<script language=javascript1.2 src='js/sdm_pesangon.js'></script>
<script>

</script>
<?php 
$sKary = "select * from " . $dbname . ".datakaryawan\r\n        where tipekaryawan not in(0,7,8) and (tanggalkeluar = '0000-00-00' or tanggalkeluar > '" . date("Y-m-d") . "')";
$qKary = mysql_query($sKary) or die(mysql_error($conn));
$optKary = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
while ($rKary = mysql_fetch_assoc($qKary)) {
    $optKary .= "<option value=" . $rKary['karyawanid'] . ">" . $rKary['namakaryawan'] . "</option>";
}
$jenis = getEnum($dbname, 'sdm_5pesangon', 'jenis');
$optjenis = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
foreach ($jenis as $jns => $jns2) {
    $optjenis .= "<option value='" . $jns . "'>" . $jns2 . "</option>";
}
include 'master_mainMenu.php';
OPEN_BOX();
echo "<fieldset style='width:600px;'>\r\n     <legend><b>" . $_SESSION['lang']['pesangon'] . "</b></legend>\r\n\t <table>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['nosurat'] . "</td>\r\n\t   <td><input type=text class=myinputtextnumber id=nosurat style=width:200px;></td>\r\n\t </tr>\r\n         <tr>\r\n            <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n            <td><input type=text class=myinputtext id=tanggal onmousemove=setCalendar(this.id) onkeypress=return false;  size=10 maxlength=10 /></td>\r\n         </tr>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n\t    <td><select id=karyawanid style=width:200px; onchange=getkodeunit(this.options[this.selectedIndex].value);>" . $optKary . "</select></td>\r\n\t </tr>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['kode'] . " " . $_SESSION['lang']['unitkerja'] . "</td>\r\n\t   <td><input type=text disabled class=myinputtextnumber id=kodeunit size=10 maxlength=10>\r\n               <input type=hidden  class=myinputtextnumber id=tglmasuk></td>\r\n\t </tr>\r\n          <tr>\r\n            <td>" . $_SESSION['lang']['tglberhenti'] . "</td>\r\n            <td><input type=text class=myinputtext id=tglberhenti onmousemove=setCalendar(this.id) onkeypress=return false; onchange=getmasakerja(); size=10 maxlength=10 /></td>\r\n         </tr>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['masakerja'] . "</td>\r\n\t   <td><input type=text disabled class=myinputtextnumber id=masakerjatahun style=width:30px; onkeypress='return angka_doang(event)' onblur=calculatePesangon(this);> " . $_SESSION['lang']['tahun'] . "\r\n               <input type=text disabled class=myinputtextnumber id=masakerjabulan style=width:30px; onkeypress='return angka_doang(event)' /> " . $_SESSION['lang']['bulan'] . "\r\n               <input type=text disabled class=myinputtextnumber id=masakerjahari style=width:30px; onkeypress='return angka_doang(event)' /> " . $_SESSION['lang']['hari'] . "</td>\r\n\t </tr>\t\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['gajipokok'] . "</td>\r\n\t   <td><input type=text class=myinputtextnumber id=gajipokok  value=0 style=width:200px; onkeypress='return angka_doang(event)' onchange='calculatePesangon()' onblur=\"change_number(this);\"></td>\r\n\t </tr>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['tjjabatan'] . "</td>\r\n\t   <td><input type=text class=myinputtextnumber id=tunjanganjabatan value=0 style=width:200px; onkeypress='return angka_doang(event)' onchange='calculatePesangon()' onblur=\"change_number(this);\"></td>\r\n\t </tr>\r\n         <tr>\r\n\t   <td>" . $_SESSION['lang']['jenis'] . " SK</td>\r\n\t    <td><select id=jenissk style=width:200px; onchange=getdetail('','','','','','','','','','',this.options[this.selectedIndex].value,'','','','','','','','');>" . $optjenis . "</select></td>\r\n\t </tr>\r\n\t </table>\r\n     </fieldset>";
echo "<br /><fieldset style='width:600px;'>\r\n        <legend><b>" . $_SESSION['lang']['detail'] . "</b></legend>\r\n            <div id=detailTable style=display:block;>\r\n            </div>\r\n    </fieldset>";
echo "<br /><fieldset style='width:1000px;'>\r\n        <legend><b>" . $_SESSION['lang']['list'] . "</b></legend>\r\n            <div id=isi><script>loadData()</script></div>\r\n    </fieldset>";
CLOSE_BOX();
echo close_body();
<?php

require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/zLib.php';
$thnbudget = $_POST['thnbudget'];
$kdpks = $_POST['kdpks'];
$jamo = $_POST['jamo'];
$jamb = $_POST['jamb'];
$arrEnum = getEnum($dbname, 'bgt_jam_operasioal_pks', 'jamolah,breakdown');
$method = $_POST['method'];
switch ($method) {
    case 'update':
        $str = "update " . $dbname . ".bgt_jam_operasioal_pks set jamolah='" . $jamo . "',breakdown='" . $jamb . "'\r\n\t       where tahunbudget='" . $thnbudget . "' and millcode='" . $kdpks . "'";
        if (mysql_query($str)) {
        } else {
            echo " Gagal," . addslashes(mysql_error($conn));
        }
        break;
    case 'insert':
        $str = "select * from " . $dbname . ".bgt_jam_operasioal_pks \r\n\t       where tahunbudget='" . $thnbudget . "' and millcode='" . $kdpks . "'\r\n            limit 0,1";
        $res = mysql_query($str);
        while ($bar = mysql_fetch_object($res)) {
            $sudahada = "1";
            $pesan = $bar->tahunbudget . "-" . $bar->millcode . "-" . $bar->jamolah . "-" . $bar->breakdown;
        }
        if ($sudahada == "1") {
            echo " Gagal, data sudah ada: " . $pesan;
            exit;
        }
        $str = "insert into " . $dbname . ".bgt_jam_operasioal_pks (`tahunbudget`,`millcode`,`jamolah`,`breakdown`)\r\n\t\tvalues ('" . $thnbudget . "','" . $kdpks . "','" . $jamo . "','" . $jamb . "')";
include 'master_mainMenu.php';
OPEN_BOX();
$sJenis = "select distinct jenis,nama from " . $dbname . ".sdm_5jenis_prasarana order by nama asc";
$qJenis = mysql_query($sJenis) or die(mysql_error());
while ($rJenis = mysql_fetch_assoc($qJenis)) {
    $nmaJenis[$rJenis['jenis']] = $rJenis['nama'];
}
$optKlmpk = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$optJns = $optKlmpk;
$sKlmpk = "select distinct kodeprasarana,jenisprasarana,lokasi from " . $dbname . ".sdm_prasarana where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' order by kodeprasarana asc";
$qKlmpk = mysql_query($sKlmpk) or die(mysql_error());
while ($rKlmpk = mysql_fetch_assoc($qKlmpk)) {
    $optKlmpk .= "<option value='" . $rKlmpk['kodeprasarana'] . "'>" . $rKlmpk['kodeprasarana'] . " - " . $nmaJenis[$rKlmpk['jenisprasarana']] . " - " . $rKlmpk['lokasi'] . "</option>";
}
$optsrana = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arragama = getEnum($dbname, 'sdm_kondisi_prasarana', 'kondisi');
foreach ($arragama as $kei => $fal) {
    $optsrana .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
$optprogres = "<option value='0'>" . $_SESSION['lang']['pilihdata'] . "</option>";
$arrProgrs = array("1" => $_SESSION['lang']['slsiPerbaikan'], "2" => $_SESSION['lang']['dlmPerbaikan']);
foreach ($arrProgrs as $kei => $fal) {
    $optprogres .= "<option value='" . $kei . "'>" . $fal . "</option>";
}
echo "<fieldset style=width:350px;float:left;>\r\n     <legend>" . $_SESSION['lang']['konPrasarana'] . "</legend>\r\n\t <table>\r\n\r\n\t <tr>\r\n\t   <td>" . $_SESSION['lang']['kodeabs'] . " " . $_SESSION['lang']['prasarana'] . "</td>\r\n\t   <td><select id=kdSarana style=\"width:150px;\" onchange=getSatuan(0)>" . $optKlmpk . "</select></td>\r\n\t </tr>\r\n\t <tr>\r\n\t   <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t   <td><input type=text class=myinputtext id=tglKonSarana onmousemove=setCalendar(this.id) onkeypress=return false;  size=10 maxlength=10 style=\"width:150px;\"  /></td>\r\n\t </tr> \r\n\t  <tr>\r\n\t   <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n\t   <td><input type=text class=myinputtext id=jmlhSarana name=jmlhSarana onkeypress=\"return angka_doang(event);\" style=\"width:150px;\" maxlength=20 /><span id=satuan></span></td>\r\n\t </tr>\r\n           <tr>\r\n\t   <td>" . $_SESSION['lang']['kondisi'] . " " . $_SESSION['lang']['prasarana'] . "</td>\r\n\t   <td><select id=kondId style=\"width:150px;\">" . $optsrana . "</select></td>\r\n\t </tr>\r\n          <tr>\r\n\t   <td>" . $_SESSION['lang']['progress'] . "</td>\r\n\t   <td><select id=idProgress style=\"width:150px;\">" . $optprogres . "</select></td>\r\n\t </tr>\r\n   \r\n\t </table>\r\n\t <input type=hidden value=insert id=method>\r\n\t <button class=mybutton onclick=saveFranco('sdm_slave_5kondisi_prasarana','" . $arr . "')>" . $_SESSION['lang']['save'] . "</button>\r\n\t <button class=mybutton onclick=cancelIsi()>" . $_SESSION['lang']['cancel'] . "</button><br /><br />B-BD = Baik, Bisa Dipakai. B-TD = Baik, Tidak Dipakai. R-BD = Rusak Bisa Dipakai. R-TD = Rusak, Tidak Dipakai. \r\n     </fieldset><input type=hidden id=idData />";
CLOSE_BOX();
OPEN_BOX();
$str = "select * from " . $dbname . ".sdm_prasarana order by tahunperolehan,bulanperolehan desc";
$res = mysql_query($str);
echo "<fieldset><legend>" . $_SESSION['lang']['list'] . "</legend><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   <td>" . $_SESSION['lang']['kodeabs'] . " " . $_SESSION['lang']['prasarana'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['jenis'] . " " . $_SESSION['lang']['prasarana'] . "</td>\r\n           <td>" . $_SESSION['lang']['lokasi'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t   <td>" . $_SESSION['lang']['kondisi'] . "</td>\r\n           <td>" . $_SESSION['lang']['progress'] . "</td>\r\n           <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n           <td>" . $_SESSION['lang']['satuan'] . "</td>\r\n\t   <td>Action</td>\r\n\t  </tr>\r\n\t </thead>\r\n\t <tbody id=container>";
echo "<script>loadData()</script>";
<?php

require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/zLib.php';
$kode = $_POST['kode'];
$nama = $_POST['nama'];
$method = $_POST['method'];
$arrEnum = getEnum($dbname, 'bgt_tipe', 'tipe,nama');
switch ($method) {
    case 'update':
        $str = "update " . $dbname . ".bgt_tipe set nama='" . $nama . "'\r\n\t       where tipe='" . $kode . "'";
        if (mysql_query($str)) {
        } else {
            echo " Gagal," . addslashes(mysql_error($conn));
        }
        break;
    case 'insert':
        $str = "select * from " . $dbname . ".bgt_tipe \r\n    where tipe='" . $kode . "' \r\n            limit 0,1";
        $res = mysql_query($str);
        while ($bar = mysql_fetch_object($res)) {
            $sudahada = "1";
            $pesan = $bar->tipe . " - " . $bar->nama;
        }
        if ($sudahada == "1") {
            echo " Gagal, data sudah ada: " . $pesan;
            exit;
        }
        $str = "insert into " . $dbname . ".bgt_tipe (tipe,nama)\r\n\t      values('" . $kode . "','" . $nama . "')";
        if (mysql_query($str)) {
        } else {
     }
     break;
 case 'addRow':
     # Get Field
     $tmpField = explode('##', $_POST['field']);
     $j = $_POST['numRow'];
     $primaryStr = $_POST['primary'];
     $fieldStr = $_POST['field'];
     foreach ($tmpField as $key => $row) {
         if ($key != 0) {
             $field[] = $row;
         }
     }
     # Setting drop down options
     $optTopografi = makeOption($dbname, 'setup_topografi', 'topografi,keterangan');
     $optTipeAng = getEnum($dbname, 'setup_kegiatannorma', 'tipeanggaran');
     #$optBarang = makeOption($dbname,'log_5masterbarang','kodebarang,namabarang');
     $content = "";
     foreach ($field as $row) {
         if ($row == 'topografi') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'select', '', array('style' => 'width:100px'), $optTopografi) . "</td>";
         } elseif ($row == 'tipeanggaran') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'select', '', array('style' => 'width:100px'), $optTipeAng) . "</td>";
         } elseif ($row == 'kodebarang') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'text', '', array('style' => 'width:70px', 'readonly' => 'readonly')) . makeElement('getInvBtn_' . $j, 'btn', 'Cari', array('onclick' => 'getInv(event,\'' . $j . '\')')) . "</td>";
         } elseif ($row == 'namabarang') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'txt', '', array('style' => 'width:120px', 'readonly' => 'readonly')) . "</td>";
         } elseif ($row == 'kuantitas1') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'textnum', '0', array('style' => 'width:40px', 'onkeypress' => 'return tanpa_kutip(event)')) . "&nbsp;<span id='uom1_" . $j . "'></span></td>";
         } elseif ($row == 'kuantitas2') {
             $content .= "<td>" . makeElement($row . "_" . $j, 'textnum', '0', array('style' => 'width:40px', 'onkeypress' => 'return tanpa_kutip(event)')) . "&nbsp;<span id='uom2_" . $j . "'></span></td>";
Example #30
0
// imports
require "database.php";
require "config.php";
// read incoming data
$request = json_decode(file_get_contents("php://input"));
if (!$request) {
    $request = (object) array("table" => $_GET['table'], "field" => $_GET['field']);
}
// check for 'action' property in request
if ($request && $request->table && $request->table) {
    $db = new Database($config);
    // restrict enum lists to those we want (don't let people
    // get information on any field in the database)
    // values allowed: gender
    if ($request->field == 'gender') {
        echo json_encode(getEnum($db, $request->table, $request->field));
    }
}
// if the above was false, echo nothing
// functions. these can be called by the script above or
// by other php files that import this file
/**
 * getEnum gets enum values for an attribute in a relation
 * in a MySQL database. returns an array of values in text form
 *
 * code source: 
 * http://stackoverflow.com/questions/2350052/how-can-i-get-enum-possible-values-in-a-mysql-database
 */
function getEnum($db, $table, $field)
{
    $type = $db->query("SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'");