PHP GetOptionsFromData Examples

Example #1

File: pmbsetup.gelombang.edit.php Project: anggadjava/sisfor

function Edit($md, $id, $bck)
{
    if ($md == 0) {
        $jdl = "Edit Gelombang";
        $w = GetFields('pmbperiod', "KodeID='" . KodeID . "' and PMBPeriodID", $id, "*");
        $_id = "<input type=hidden name='id' value='{$id}' /><b>{$id}</b>";
    } elseif ($md == 1) {
        $jdl = "Tambah Gelombang";
        $w = array();
        $w['Tahun'] = date('Y');
        $w['TglMulai'] = date('Y-m-d');
        $w['TglSelesai'] = date('Y-m-d');
        $w['UjianMulai'] = date('Y-m-d');
        $w['UjianSelesai'] = date('Y-m-d');
        $w['WawancaraMulai'] = date('Y-m-d');
        $w['WawancaraSelesai'] = date('Y-m-d');
        $w['BayarMulai'] = date('Y-m-d');
        $w['BayarSelesai'] = date('Y-m-d');
        $w['NA'] = 'N';
        $_id = "<input type=text name='id' value='{$id}' size=10 maxlength=50 />";
    } else {
        die(ErrorMsg('Error', "Mode edit tidak dikenali."));
    }
    TampilkanJudul($jdl);
    // Parameters
    $arrTahun = array();
    for ($i = date('Y') + 1; $i >= date('Y') - 5; $i--) {
        $arrTahun[] = $i;
    }
    $opttahun = GetOptionsFromData($arrTahun, $w['Tahun'], 1);
    $TglMulai = GetDateOption3($w['TglMulai'], 'TglMulai');
    $TglSelesai = GetDateOption3($w['TglSelesai'], 'TglSelesai');
    $UjianMulai = GetDateOption3($w['UjianMulai'], 'UjianMulai');
    $UjianSelesai = GetDateOption3($w['UjianSelesai'], 'UjianSelesai');
    $WawancaraMulai = GetDateOption3($w['WawancaraMulai'], 'WawancaraMulai');
    $WawancaraSelesai = GetDateOption3($w['WawancaraSelesai'], 'WawancaraSelesai');
    $BayarMulai = GetDateOption3($w['BayarMulai'], 'BayarMulai');
    $BayarSelesai = GetDateOption3($w['BayarSelesai'], 'BayarSelesai');
    CheckFormScript("id,Nama,Tahun,Urutan");
    $NA = $w['NA'] == 'Y' ? 'checked' : '';
    $arrDigitNoAplikan = array(3, 4, 5);
    $arrDigitNoPMB = array(3, 4, 5);
    $optdigitnoaplikan = GetDigitOption($arrDigitNoAplikan, $w['DigitNoAplikan']);
    $optdigitnopmb = GetDigitOption($arrDigitNoPMB, $w['DigitNoPMB']);
    // Tampilkan
    echo "<p><table class=bsc cellspacing=1 width=100%>\r\n  <form action='../{$_SESSION['mnux']}.gelombang.edit.php' method=POST onSubmit=\"return CheckForm(this)\">\r\n  <input type=hidden name='gos' value='Simpan' />\r\n  <input type=hidden name='md' value='{$md}' />\r\n  <input type=hidden name='bck' value='{$bck}' />\r\n  \r\n  <tr><td class=inp nowrap>Kode Gelombang:</td>\r\n      <td class=ul1>{$_id}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Nama Gelombang:</td>\r\n      <td class=ul1><input type=text name='Nama' value='{$w['Nama']}' size=30 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Tahun Gelombang:</td>\r\n      <td class=ul1><select name='Tahun'>{$opttahun}</select></td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Urutan Gelombang:</td>\r\n\t  <td class=ul1><input type=text name='Urutan' value='{$w['Urutan']}' size=3 maxlength=5 /></td>\r\n\t  </tr>\r\n  <tr><td class=inp nowrap>Format No. Aplikan:</td>\r\n\t  <td class=ul1><input type=text name='FormatNoAplikan' value='{$w['FormatNoAplikan']}' size=6>\r\n\t\t\t\t    <select name='DigitNoAplikan'>{$optdigitnoaplikan}</select></td></tr>\r\n  <tr><td class=inp nowrap>Format No. Pendaftaran:</td>\r\n\t  <td class=ul1><input type=text name='FormatNoPMB' value='{$w['FormatNoPMB']}' size=6>\r\n\t\t\t\t\t<select name='DigitNoPMB'>{$optdigitnopmb}</select></td></tr>\r\n  <tr><td class=inp nowrap>Mulai Tgl:</td>\r\n      <td class=ul1>{$TglMulai}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Selesai Tgl:</td>\r\n      <td class=ul1>{$TglSelesai}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Mulai USM:</td>\r\n      <td class=ul1>{$UjianMulai}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Selesai USM:</td>\r\n      <td class=ul1>{$UjianSelesai}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Mulai Wawancara:</td>\r\n\t  <td class=ul1>{$WawancaraMulai}</td>\r\n\t  </tr>\r\n  <tr><td class=inp nowrap>Selesai Wawancara:</td>\r\n\t  <td class=ul1>{$WawancaraSelesai}</td>\r\n\t  </tr>\r\n  <tr><td class=inp nowrap>Mulai Registrasi Ulang:</td>\r\n      <td class=ul1>{$BayarMulai}</td>\r\n      </tr>\r\n  <tr><td class=inp nowrap>Selesai Registrasi Ulang:</td>\r\n      <td class=ul1>{$BayarSelesai}</td>\r\n      </tr>\r\n  <tr><td class=inp>Tidak Aktif?</td>\r\n      <td class=ul1>\r\n        <input type=checkbox name='NA' value='Y' {$NA} /> *) Beri centang jika tidak aktif\r\n      </td></tr>\r\n  <tr><td class=ul1 colspan=2 align=center>\r\n      <input type=submit name='Simpan' value='Simpan' />\r\n      <input type=button name='Batal' value='Batal' onClick='window.close()' />\r\n      </td></tr>\r\n  </form>\r\n  </table></p>";
}

Example #2

File: pmbisiform.php Project: anggadjava/mitra_siakad

function Edit($md, $gel, $id)
{
    $sisfo = GetFields('identitas', 'Kode', KodeID, '*');
    if ($md == 0) {
        $jdl = 'Edit Data PMB';
        $w = GetFields('pmb', 'PMBID', $id, '*');
        CekSudahProsesNIM($w);
        $JumlahPilihan = GetaField('pmbformulir', "PMBFormulirID = '{$w['PMBFormulirID']}' and KodeID", KodeID, 'JumlahPilihan');
        if (empty($JumlahPilihan)) {
            $JumlahPilihan = 3;
        }
        if ($JumlahPilihan == 1) {
            $da2 = "disabled";
            $da3 = "disabled";
        } else {
            if ($JumlahPilihan == 2) {
                $da2 = '';
                $da3 = "disabled";
            } else {
                $da2 = '';
                $da3 = '';
            }
        }
        $_PMBID = "<b>{$w['PMBID']}</b>";
    } elseif ($md == 1) {
        $jdl = 'Masukkan Data PMB';
        $w = array();
        $w['TanggalLahir'] = date('Y-m-d');
        $_PMBID = "<font color=red>Auto-generated</font>";
        $da2 = '';
        $da3 = '';
    } else {
        die(ErrorMsg('Error', "Mode edit <b>{$md}</b> tidak dikenali.<br />\r\n    Hubungi Sysadmin untuk informasi lebih lanjut.\r\n    <hr size=1 color=silver />\r\n    <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
    }
    // Parameters
    $TanggalLahir = GetDateOption($w['TanggalLahir'], 'TanggalLahir');
    $optfrm = GetOption2('pmbformulir', "concat(Nama, ' (', JumlahPilihan, ' pilihan)')", 'Nama', $w['PMBFormulirID'], "KodeID='" . KodeID . "'", 'PMBFormulirID');
    $optstawal = GetOption2('statusawal', "concat(StatusAwalID, ' - ', Nama)", 'StatusAwalID', $w['StatusAwalID'], '', 'StatusAwalID');
    $optkel = GetOption2('kelamin', "concat(Kelamin, ' - ', Nama)", 'Kelamin', $w['Kelamin'], '', 'Kelamin');
    $optagm = GetOption2('agama', "concat(Agama, ' - ', Nama)", 'Agama', $w['Agama'], '', 'Agama');
    $optagamaayah = GetOption2('agama', "concat(Agama, ' - ', Nama)", 'Agama', $w['AgamaAyah'], '', 'Agama');
    $optagamaibu = GetOption2('agama', "concat(Agama, ' - ', Nama)", 'Agama', $w['AgamaIbu'], '', 'Agama');
    $optsipil = GetOption2('statussipil', "concat(StatusSipil, ' - ', Nama)", 'StatusSipil', $w['StatusSipil'], '', 'StatusSipil');
    $optpendidikan = GetOption2('pendidikanterakhir', "PendidikanTerakhir", 'Urutan', $w['PendidikanTerakhir'], '', 'PendidikanTerakhir');
    $optpendidikanayah = GetOption2('jenjang', "concat(JenjangID, '. ', Nama)", 'JenjangID', $w['PendidikanAyah'], '', 'JenjangID');
    $optpendidikanibu = GetOption2('jenjang', "concat(JenjangID, '. ', Nama)", 'JenjangID', $w['PendidikanIbu'], '', 'JenjangID');
    $opthidupayah = GetOption2('hidup', 'Nama', 'Hidup', $w['HidupAyah'], '', 'Hidup');
    $opthidupibu = GetOption2('hidup', 'Nama', 'Hidup', $w['HidupIbu'], '', 'Hidup');
    $optprg = GetOption2('program', "concat(ProgramID, ' - ', Nama)", 'ProgramID', $w['ProgramID'], "KodeID='" . KodeID . "'", 'ProgramID');
    $optwarganegara = GetOption2('warganegara', "WargaNegara", 'WargaNegara', $w['WargaNegara'], '', 'WargaNegara');
    $Pilihan2 = GetPilihan2($w, $da2, $da3);
    $arraytinggal = array('Orang Tua', 'Wali', 'Sendiri');
    $opttinggaldengan = GetOptionsFromData($arraytinggal, $w['TinggalDengan']);
    $optpenghasilanayah = GetOption2('penghasilanortu', "Nama", 'PenghasilanOrtuID', $w['PenghasilanAyah'], '', 'Nama');
    $optpenghasilanibu = GetOption2('penghasilanortu', "Nama", 'PenghasilanOrtuID', $w['PenghasilanIbu'], '', 'Nama');
    $arrPrestasiTambahan = explode('~', $w['PrestasiTambahan']);
    $s1 = "select PMBFormulirID, JumlahPilihan from pmbformulir where KodeID='" . KodeID . "' and NA='N'";
    $r1 = _query($s1);
    while ($w1 = _fetch_array($r1)) {
        $hiddenformdata .= "<input type=hidden id='Form{$w1['PMBFormulirID']}' name='Form{$w1['PMBFormulirID']}' value='{$w1['JumlahPilihan']}' />";
    }
    // Tampilkan
    TampilkanJudul($jdl);
    CheckFormScript("Nama,TempatLahir,Kelamin,ProgramID,PMBFormulirID");
    JumlahPilihanScript();
    echo "<table class=bsc cellspacing=1 width=800>\r\n  <form name='frmisi' action='?mnux={$_SESSION['mnux']}' method=POST onSubmit=\"return CheckForm(this)\" />\r\n  <input type=hidden name='gel' value='{$gel}' />\r\n  <input type=hidden name='md' value='{$md}' />\r\n  <input type=hidden name='gos' value='Simpan' />\r\n  {$hiddenformdata}\r\n  \r\n  <tr>\r\n      <td class=inp>No. Peserta:</td>\r\n      <td class=ul1>{$_PMBID}</td>\r\n\t  <td class=inp>Status:</td>\r\n\t  <td class=ul1><select name='StatusAwalID' disabled>{$optstawal}</select></td>\r\n  </tr>\r\n  \r\n  <tr><th class=ttl colspan=4>Data Pribadi Cama</th></tr>\r\n  <tr><td class=inp>Nama Lengkap:</td>\r\n      <td class=ul1 colspan=3>\r\n      <input type=text name='Nama' value='{$w['Nama']}' size=30 maxlength=50 />\r\n      </td></tr>\r\n  <tr><td class=inp>Warga Negara:</td>\r\n      <td class=ul1><select name='WargaNegara'>{$optwarganegara}</select></td>\r\n      <td class=inp>Kebangsaan:</td>\r\n      <td class=ul1><input type=text name='Kebangsaan' value='{$w['Kebangsaan']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Tanggal Lahir:</td>\r\n      <td class=ul1>{$TanggalLahir}</td>\r\n\t  <td class=inp>Tempat Lahir:</td>\r\n      <td class=ul1><input type=text name='TempatLahir' value='{$w['TempatLahir']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Jenis Kelamin:</td>\r\n      <td class=ul1><select name='Kelamin'>{$optkel}</select></td>\r\n      <td class=inp>Golongan Darah:</td>\r\n      <td class=ul1><input style='text-transform: uppercase' type=text name='GolonganDarah' value='{$w['GolonganDarah']}' size=5 maxlength=10 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Agama:</td>\r\n      <td class=ul1><select name='Agama'>{$optagm}</select></td>\r\n      <td class=inp>Status Perkawinan:</td>\r\n      <td class=ul1><select name='StatusSipil'>{$optsipil}</select></td>\r\n      </tr>\r\n  <tr><td class=inp>Tinggi Badan:</td>\r\n      <td class=ul1><input type=text name='TinggiBadan' value='{$w['TinggiBadan']}' size=3 maxlength=5 /> cm</td>\r\n      <td class=inp>Berat Badan:</td>\r\n      <td class=ul1><input type=text name='BeratBadan' value='{$w['BeratBadan']}' size=3 maxlength=5 /> kg</td>\r\n      </tr>\r\n\t  \r\n  <tr><th class=ttl colspan=4>Pilihan Program Studi</th></tr>\r\n  <tr>\r\n      <td class=inp>Formulir:</td>\r\n      <td class=ul1 colspan=3>\r\n        <select name='PMBFormulirID' onChange=\"UbahJumlahPilihan()\">{$optfrm}</select > <br />\r\n        </td>\r\n      </tr>\r\n  <tr><td class=inp>Program Pendidikan:</td>\r\n      <td class=ul1 colspan=3>\r\n      <select name='ProgramID'>{$optprg}</select>\r\n      </td></tr>    \r\n  {$Pilihan2}\r\n  <tr><th class=ttl colspan=4>Pendidikan Terakhir dan Prestasi Lainnya:</th></tr>\r\n  <tr><td class=inp>Pendidikan Terakhir:</td>\r\n      <td class=ul1><select name='PendidikanTerakhir'>{$optpendidikan}</select></td>\r\n      <td class=inp>Asal Sekolah:</td>\r\n      <td class=ul1><input type=text name='AsalSekolah' value='{$w['AsalSekolah']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Tahun Lulus:</td>\r\n      <td class=ul1><input type=text name='TahunLulus' value='{$w['TahunLulus']}' size=10 maxlength=10 /></td>\r\n      <td class=inp>Nilai Ijazah:</td>\r\n      <td class=ul1><input type=text name='NilaiSekolah' value='{$w['NilaiSekolah']}' size=10 maxlength=10 />\r\n\t\t\t\t\t<br><font color=red>*) Masukkan dalam rentang 0.00-10.00</font></td>\r\n      </tr>\r\n  <tr><td class=inp>Prestasi Lainnya:</td>\r\n\t  <td class=ul1 colspan=3><input type=text name='PrestasiTambahan1' value='{$arrPrestasiTambahan['0']}' size=80 maxlength=100 ></td>\r\n  </tr>\r\n  <tr><td></td>\r\n\t  <td class=ul1 colspan=3><input type=text name='PrestasiTambahan2' value='{$arrPrestasiTambahan['1']}' size=80 maxlength=100></td>\r\n  </tr>\r\n  <tr><td></td>\r\n      <td class=ul1 colspan=3><input type=text name='PrestasiTambahan3' value='{$arrPrestasiTambahan['2']}' size=80 maxlength=100></br>\r\n\t  *) <i>Prestasi dapat berupa prestasi apa saja di bidang <b>seni</b>, <b>olahraga</b>, atau <b>akademik</b>. </i></br>\r\n\t  *) <i>Harap menuliskan <b>peringkat</b>, <b>nama lengkap kompetisi/event</b> dan <b>tahun</b> peraihan prestasi bila memungkinkan<i> \r\n\t  </td>\r\n  </tr>\r\n  \r\n  <tr><th class=ttl colspan=4>Alamat</th></tr>\r\n  <tr><td class=inp>Alamat lengkap:</td>\r\n      <td class=ul1 colspan=3>\r\n      <textarea name='Alamat' cols=70 rows=4>{$w['Alamat']}</textarea>\r\n      </td></tr>\r\n  <tr><td class=inp>RT/RW:</td>\r\n      <td class=ul1><input type=text name='RT' value='{$w['RT']}' size=10 maxlength=10 />\r\n      / <input type=text name='RW' value='{$w['RW']}' size=10 maxlength=10 /></td>\r\n      <td class=inp>Kode Pos:</td>\r\n      <td class=ul1><input type=text name='KodePos' value='{$w['KodePos']}' size=10 maxlength=10 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Kota/Kabupaten:</td>\r\n      <td class=ul1><input type=text name='Kota' value='{$w['Kota']}' size=20 maxlength=50 /></td>\r\n      <td class=inp>Propinsi:</td>\r\n      <td class=ul1><input type=text name='Propinsi' value='{$w['Propinsi']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Telpon/ponsel:</td>\r\n      <td class=ul1>\r\n        <input type=text name='Telepon' value='{$w['Telepon']}' size=10 maxlength=50 /> /\r\n        <input type=text name='Handphone' value='{$w['Handphone']}' size=10 maxlength=50 />\r\n      </td>\r\n      <td class=inp>E-mail:</td>\r\n      <td class=ul1>\r\n        <input type=text name='Email' value='{$w['Email']}' size=20 maxlength=50 />\r\n      </td></tr>\r\n  \r\n  <tr><th class=ttl colspan=4>Data Orangtua</th></tr>\r\n  <tr><td class=inp>Nama Ayah:</td>\r\n      <td class=ul1><input type=text name='NamaAyah' value='{$w['NamaAyah']}' size=20 maxlength=50 /></td>\r\n      <td class=inp>Nama Ibu:</td>\r\n      <td class=ul1><input type=text name='NamaIbu' value='{$w['NamaIbu']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Agama Ayah:</td>\r\n      <td class=ul1><select name='AgamaAyah' />{$optagamaayah}</td>\r\n      <td class=inp>Agama Ibu:</td>\r\n      <td class=ul1><select name='AgamaIbu' />{$optagamaibu}</td>\r\n      </tr>\r\n  <tr><td class=inp>Pendidikan Ayah:</td>\r\n      <td class=ul1><select name='PendidikanAyah'>{$optpendidikanayah}</select></td>\r\n      <td class=inp>Pendidikan Ibu:</td>\r\n      <td class=ul1><select name='PendidikanIbu'>{$optpendidikanibu}</select></td>\r\n      </tr>\r\n  <tr><td class=inp>Pekerjaan Ayah:</td>\r\n      <td class=ul1><input type=text name='PekerjaanAyah' value='{$w['PekerjaanAyah']}' size=20 maxlength=50 /></td>\r\n      <td class=inp>Pekerjaan Ibu:</td>\r\n      <td class=ul1><input type=text name='PekerjaanIbu' value='{$w['PekerjaanIbu']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Penghasilan/bulan:</td>\r\n      <td class=ul1><select name='PenghasilanAyah'>{$optpenghasilanayah}</select></td>\r\n      <td class=inp>Penghasilan/bulan:</td>\r\n      <td class=ul1><select name='PenghasilanIbu'>{$optpenghasilanibu}</select></td>\r\n      </tr>\r\n  <tr><td class=inp>Status Kehidupan:</td>\r\n      <td class=ul1><select name='HidupAyah'>{$opthidupayah}</select></td>\r\n      <td class=inp>Status kehidupan:</td>\r\n      <td class=ul1><select name='HidupIbu'>{$opthidupibu}</select></td>\r\n      </tr>\r\n  \r\n  <tr><th class=ttl colspan=4>Alamat Orangtua</th></tr>\r\n  <tr><td class=inp>Alamat lengkap:</td>\r\n      <td class=ul1 colspan=3>\r\n      <textarea name='AlamatOrtu' cols=70 rows=4>{$w['AlamatOrtu']}</textarea>\r\n      </td></tr>\r\n  <tr><td class=inp>RT/RW:</td>\r\n      <td class=ul1><input type=text name='RTOrtu' value='{$w['RTOrtu']}' size=10 maxlength=10 />\r\n      / <input type=text name='RWOrtu' value='{$w['RWOrtu']}' size=10 maxlength=10 /></td>\r\n      <td class=inp>Kode Pos:</td>\r\n      <td class=ul1><input type=text name='KodePosOrtu' value='{$w['KodePosOrtu']}' size=10 maxlength=10 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Kota:</td>\r\n      <td class=ul1><input type=text name='KotaOrtu' value='{$w['KotaOrtu']}' size=20 maxlength=50 /></td>\r\n      <td class=inp>Propinsi:</td>\r\n      <td class=ul1><input type=text name='PropinsiOrtu' value='{$w['PropinsiOrtu']}' size=20 maxlength=50 /></td>\r\n      </tr>\r\n  <tr><td class=inp>Telpon/ponsel:</td>\r\n      <td class=ul1>\r\n        <input type=text name='TeleponOrtu' value='{$w['TeleponOrtu']}' size=10 maxlength=50 /> /\r\n        <input type=text name='HandphoneOrtu' value='{$w['HandphoneOrtu']}' size=10 maxlength=50 />\r\n      </td>\r\n      <td class=inp>E-mail:</td>\r\n      <td class=ul1>\r\n        <input type=text name='EmailOrtu' value='{$w['EmailOrtu']}' size=20 maxlength=50 />\r\n      </td></tr>\r\n  \r\n  <tr><td class=ul1 colspan=4 align=center>\r\n      <input type=submit name='Simpan' value='Simpan' />\r\n      <input type=button name='Batal' value='Batal' onClick=\"window.close()\" />\r\n      </td></tr>\r\n  \r\n  </form>\r\n  </table>";
}

Example #3

File: konversipindahan.php Project: anggadjava/sisfor

function DftrMK($MhswID, $mhsw)
{
    $s = "select k.* from krs k left outer join khs h on h.KHSID = k.KHSID and h.KodeID = '" . KodeID . "' where k.MhswID = '{$MhswID}' order by k.TahunID, k.MKKode";
    $r = _query($s);
    $_tahun = 'alksdjfasdf-asdf';
    $n = _num_rows($r);
    echo <<<ESD
  <table class=box cellspacing=1 width=600 align=center>
\t\t<form action='?' method=POST>
\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}'>
\t\t<input type=hidden name='gos' value='SaveAll'>
ESD;
    //$arrSemuaTahun = array('2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009');
    $arrSemuaTahun = array('2008', '2009', '2010', '2011', '2012');
    $optSemuaTahun = GetOptionsFromData($arrSemuaTahun, '');
    echo "<tr><td class=ul1 colspan=2><input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$mhsw['MhswID']}', '', 0)\" /></td></tr>";
    /*echo "<tr>
            <td class=ul1 colspan=2>
              <input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '$mhsw[MhswID]', '', 0)\" />
            </td>
    		<td class=inp>Masukkan Tahun Bila Kode -1- adalah Tahun:
    		<td class=ul1><select name='InputTahun1'/>$optSemuaTahun</select><td>
    		<td class=ul1><input type=button name='InputSemuaTahun' value='Input Semua Tahun' 
    			onClick ='this.form.submit()' /></td>
    		</tr>";*/
    $hdr = "<tr><th class=ttl width=20>Nmr</th>\r\n    <th class=ttl width=90>Kode</th>\r\n    <th class=ttl>Matakuliah</th>\r\n    <th class=ttl width=30>SKS</th>\r\n    <th class=ttl width=30>Nilai</th>\r\n    <th class=ttl width=30>Tahun</th>\r\n    <th class=ttl width=30>Edit</th>\r\n    </tr>";
    $m = 0;
    while ($w = _fetch_array($r)) {
        if ($_tahun != $w['TahunID']) {
            $_tahun = $w['TahunID'];
            echo "<tr><td class=ul1 colspan=10>\r\n          <font size=+1>{$_tahun}</font>\r\n          <!--<input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$w['MhswID']}', '{$_tahun}', 0)\" />-->\r\n        </td></tr>";
            echo $hdr;
            $n = 0;
        }
        $n++;
        $m++;
        if ($w['Setara'] == 'Y') {
            $btnEdit = "<input type=button name='btnEdit' value='�' onClick=\"fnEditKonversi(0, '{$w['MhswID']}', '{$w['TahunID']}', {$w['KRSID']})\" />";
        } else {
            $btnEdit = "<abbr title='Bukan Konversi'><img src='img/flag2.gif' /></abbr>";
        }
        //$arrTahun = array('20031','20032','20041','20042','20051','20052','20061','20062', '20071', '20072', '20081', '20082', '20091', '20092', '20101', '20102');
        $arrTahun = array('20081', '20082', '20091', '20092', '20101', '20102', '20111', '20112', '20121', '20122');
        $optTahun = GetOptionsFromData($arrTahun, $w['TahunID']);
        //echo "Select: Select$m<br>";
        echo <<<ESD
    <tr>
      <td class=inp>{$n}</td>
      <td class=ul>{$w['MKKode']}</td>
      <td class=ul>{$w['Nama']}</td>
      <td class=ul align=right>{$w['SKS']}</td>
      <td class=ul align=center>{$w['GradeNilai']}
      <td class=ul align=center><select name='Select{$m}'>{$optTahun}</select><input type=hidden name='Hidden{$m}' value='{$w['KRSID']}'/></td>
      <td class=ul align=center>{$btnEdit}</td>
    </tr>
ESD;
    }
    RandomStringScript();
    echo "<tr>\r\n\t\t<td class=ul1 colspan=6>\r\n\t\t\t<input type=button name='SaveData' value='Save Data' onClick='this.form.submit()' /></td>\r\n\t</tr>";
    echo <<<ESD
  
\t
  </form>
  </table>
  
  <script>
  function fnEditKonversi(md, mhsw, thn, id) {
      var _rnd = randomString();
      lnk = "{$_SESSION['mnux']}.edit.php?mhsw="+mhsw+"&md="+md+"&id="+id+"&thn="+thn+"&_rnd="+_rnd+"&ProdiID={$mhsw['ProdiID']}";
      win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status");
      if (win2.opener == null) childWindow.opener = self;
  
  }

  </script>
ESD;
}

Example #4

File: wawancara.edt.php Project: anggadjava/mitra_siakad

function EditWawancara()
{
    $sisfo = GetFields('identitas', 'Kode', KodeID, '*');
    $wid = $_REQUEST['wPMB'];
    $md = $_REQUEST['md'] + 0;
    if ($md == 0) {
        $jdl = 'Edit Data Wawancara';
        $w = GetFields('wawancara w left outer join pmb p on w.PMBID=p.PMBID', 'WawancaraID', $_REQUEST['wPMB'], 'w.*, p.Nama, p.DetailNilai, p.NilaiUjian, p.TahunLulus, p.Pilihan1, p.Pilihan2, p.Pilihan3');
        $strwid = "\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Wawancara ID: </td>\r\n\t\t\t\t<td class=ul1><input type=hidden name='wid' value='{$wid}'><b>{$wid}</b></td>\r\n\t\t\t</tr>";
    } else {
        if ($md == 1) {
            $jdl = 'Masukkan Data Wawancara';
            $w = array();
            $w['PMBID'] = $_REQUEST['wPMB'];
            $s = "select * from `pmb` where PMBID='{$w['PMBID']}'";
            $r = _query($s);
            $n = _num_rows($r);
            $w = _fetch_array($r);
            if ($n == 1) {
                $w['Tanggal'] = date('Y-m-d');
                $w['JamMulaiWawancara'] = '08:00';
                $w['JamSelesaiWawancara'] = '09:00';
            } else {
                die(ErrorMsg('Error', "Ada Nomor PMB yang ganda. Harap dibenarkan dulu. o.0"));
            }
            $strwid = "";
            //"<input type=hidden name='wid' value='' size=40 maxlength=50>=<i> Akan diberikan secara otomatis</i> =";
        } else {
            die(ErrorMsg('Error', "Mode edit tidak dikenali. Hubungi Sysadmin untuk informasi lebih lanjut."));
        }
    }
    //** Tampilkan Form Parameters **
    $selecttanggalwawancara = GetDateOption($w['Tanggal'], 'Tanggal');
    $optjamwawancara = GetTimeOption(substr($w['JamMulaiWawancara'], 0, 5), 'JamMulai');
    $optakhirjamwawancara = GetTimeOption(substr($w['JamSelesaiWawancara'], 0, 5), 'JamSelesai');
    $optkelamin = GetOption2('kelamin', "concat(Kelamin, ' - ', Nama)", 'Kelamin', $w['Kelamin'], '', 'Kelamin');
    $radkel = GetRadio("select Nama, Kelamin from kelamin order by Nama", "Kelamin", "Nama", "Kelamin", $w['KelaminID'], ", ");
    $optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $w['Pilihan1'], '', 'ProdiID');
    $optprodi2 = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $w['Pilihan2'], '', 'ProdiID');
    $optprodi3 = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $w['Pilihan3'], '', 'ProdiID');
    $optsaranprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $w['SaranProdi'], '', 'ProdiID');
    $optpewawancara = GetOption2('presenter', "Nama", 'Nama', $w['Pewawancara'], '', 'PresenterID');
    $optpewawancara2 = GetOption2('presenter', "Nama", 'Nama', $w['Pewawancara2'], '', 'PresenterID');
    $arrayjpendamping = array('OrangTua', 'Wali', 'Sponsor');
    $optjenispendamping = GetOptionsFromData($arrayjpendamping, $w['JenisPendamping']);
    $arraycacat = array('Cacat', 'Tidak');
    $optcacat = GetOptionsFromData($arraycacat, $w['Cacat']);
    $arraykeuangan = array('Cash', 'Cicil');
    $optkeuangan = GetOptionsFromData($arraykeuangan, $w['Keuangan']);
    $arrayyatidak = array('Ya', 'Tidak');
    $opttatatertib = GetOptionsFromData($arrayyatidak, $w['PatuhTataTertib']);
    $optproporsional = GetOptionsFromData($arrayyatidak, $w['Proporsional']);
    $optmengganggu = GetOptionsFromData($arrayyatidak, $w['Mengganggu']);
    $optmembahayakan = GetOptionsFromData($arrayyatidak, $w['Membahayakan']);
    $optrasional1 = GetOptionsFromData($arrayyatidak, $w['Rasional1']);
    $optrasional2 = GetOptionsFromData($arrayyatidak, $w['Rasional2']);
    $optrasional3 = GetOptionsFromData($arrayyatidak, $w['Rasional3']);
    $optrasional4 = GetOptionsFromData($arrayyatidak, $w['Rasional4']);
    $arrayrekomendasi = array('Rekomendasi', 'Tidak Rekomendasi');
    $optrekomendasi = GetOptionsFromData($arrayrekomendasi, $w['HasilWawancara']);
    $rokokck = $w['CheckRokok'] == 'on' ? 'checked' : '';
    $mirasck = $w['CheckMiras'] == 'on' ? 'checked' : '';
    $narkoback = $w['CheckNarkoba'] == 'on' ? 'checked' : '';
    $judick = $w['CheckJudi'] == 'on' ? 'checked' : '';
    CheckFormScript("Pewawancara");
    TampilkanJudul($jdl);
    echo "<table class=box cellspacing=1 width=100%>\r\n\t\t\t<form name='editwawanform' action='?' method=POST onSubmit=\"return CheckForm(this)\">\r\n\t\t\t<input type=hidden name='md' value='{$md}'/>\r\n\t\t\t<input type=hidden name='gelombang' value='{$gelombang}'/>\r\n\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}'/>\r\n\t\t\t<input type=hidden name='gos' value='WawancaraSav'/>\r\n\t\t\t\r\n\t\t\t<tr><th class=ttl colspan=6>Data Wawancara</th></tr>\r\n\t\t\t{$strwid}\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Tanggal Wawancara</td>\r\n\t\t\t\t<td class=ul1>{$selecttanggalwawancara}</td>\r\n\t\t\t\t<td class=inp>Jam Wawancara</td>\r\n\t\t\t\t<td class=ul1 colspan=3>{$optjamwawancara} - {$optakhirjamwawancara}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Nama Pewawancara 1</td>\r\n\t\t\t\t<td class=ul1><select name='Pewawancara'>{$optpewawancara}</select></td>\r\n\t\t\t\t<td class=inp>Nama Pewawancara 2</td>\r\n\t\t\t\t<td class=ul1 colspan=3><select name='Pewawancara2'>{$optpewawancara2}</select></td>\t\t\r\n\t\t\t</tr>\r\n\t\t\t<tr><th class=ttl colspan=6>Data Pribadi</th></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>No. PMB:</td>\r\n\t\t\t\t<td class=ul1 colspan=5>\r\n\t\t\t\t\t<input type=text name='dNoPMB' value='{$w['PMBID']}' size=30 maxlength=50 disabled/>\r\n\t\t\t\t\t<input type=hidden name='NoPMB' value='{$w['PMBID']}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Nama: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<input type=text name='dWNama' value='{$w['Nama']}' size=30 maxlength=50 disabled/>\r\n\t\t\t\t\t<input type=hidden name='WNama' value='{$w['Nama']}'></td>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Prodi 1: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<select name='Prodi' onChange=\"javascript:editwawanform.label1.value=editwawanform.Prodi.value\" disabled>{$optprodi}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Prodi 2: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<select name='Prodi2' onChange=\"javascript:editwawanform.label2.value=editwawanform.Prodi2.value\" disabled>{$optprodi2}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Prodi 3: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<select name='Prodi3' onChange=\"javascript:editwawanform.label3.value=editwawanform.Prodi3.value\" disabled>{$optprodi3}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Datang bersama Ortu/Wali: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<select name='JenisPendamping'>{$optjenispendamping}</select></td>\r\n\t\t\t\t<td class=inp>Nama Pendamping: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<input type=text name='NamaPendamping' value='{$w['NamaPendamping']}' size=30 maxlength=50 /></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Anak ke: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<input type=text name='AnakKe' value='{$w['AnakKe']}' size=2 maxlength=2>\r\n\t\t\t\t\tdari&nbsp<input type=text name='DariKe' value='{$w['DariKe']}' size=2 maxlength=2></td>\r\n\t\t\t\t<td class=inp>Pekerjaan Pendamping: </td>\r\n\t\t\t\t<td class=ul1 = colspan=3>\r\n\t\t\t\t\t<input type=text name='PekerjaanPendamping' value='{$w['PekerjaanPendamping']}' size=30 maxlength=50></td>\t\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Catatan tentang Keluarga: </td>\r\n\t\t\t\t<td class=ul1 colspan=5>\r\n\t\t\t\t\t<textarea name='CatatanKeluarga' cols=70 row=2>{$w['CatatanKeluarga']}</textarea></td>\r\n\t\t\t</tr>\r\n\t\t\t\r\n\t\t\t<tr><th class=ttl colspan=6>Identifikasi Fisik Aplikan</th></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Berat Badan: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<input type=text name='BeratBadan' value='{$w['BeratBadan']}' size=3 maxlength=5/></td>\r\n\t\t\t\t<td class=inp>Tinggi Badan: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<input type=text name='TinggiBadan' value='{$w['TinggiBadan']}' size=3 maxlength=5 /></td>\r\n\t\t\t\t<td class=inp rowspan=2>Proporsional: </td>\r\n\t\t\t\t<td class=ul1 rowspan=2>\r\n\t\t\t\t\t<select name='Proporsional' >{$optproporsional}</select></td>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\t\t\t\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Kelamin: </td>\r\n\t\t\t\t<td class ul1 colspan=5><select name='Kelamin'>{$optkelamin}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Cacat: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<select name='Cacat'>{$optcacat}</select></td>\r\n\t\t\t\t<td class=inp>Keterangan: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<input type=text name='KeteranganCacat' value='{$w['KeteranganCacat']}' size=30 maxlength=50 /></td>\r\n\t\t\t\t<td class=inp>Mengganggu: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<select name='Mengganggu' >{$optmengganggu}</select></td>\r\n\t\t\t\t</td>\t\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Indikasi Kecanduan: </td>\r\n\t\t\t\t<td class=ul1 colspan=3> \r\n\t\t\t\t\t<input type=checkbox name='CheckRokok' {$rokokck}>Rokok &nbsp&nbsp&nbsp&nbsp     \r\n\t\t\t\t\t<input type=checkbox name='CheckMiras' {$mirasck}>Miras &nbsp&nbsp&nbsp&nbsp    \r\n\t\t\t\t\t<input type=checkbox name='CheckNarkoba' {$narkoback}>Narkoba\t\t\t\r\n\t\t\t\t</td>\r\n\t\t\t\t<td class=inp rowspan=2>Membahayakan</td>\r\n\t\t\t\t<td class=ul1 rowspan=2><select name='Membahayakan'>{$optmembahayakan}</select></td>\r\n\t\t\t</tr>\t\r\n\t\t\t<tr>\r\n\t\t\t\t<td></td>\r\n\t\t\t\t<td class=ul1 colspan=3><input type=checkbox name='CheckJudi' {$judick}>Judi&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp      \r\n\t\t\t\t\tLainnya: <input type=text name='KecanduanLainnya' value='{$w['KecanduanLainnya']}'>\r\n\t\t\t\t</tr>\r\n\t\t\t<tr><th class=ttl colspan=6>Motif</th></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Tahun Kelulusan SMU/SMK: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<input type=text name='dTahunLulus' value='{$w['TahunLulus']}' size=8 maxlength=10 disabled/>\r\n\t\t\t\t\t<input type=hidden name='TahunLulus' value='{$w['TahunLulus']}'></td>\r\n\t\t\t\t<td class=inp rowspan=2>Rasional: </td>\r\n\t\t\t\t<td class=ul1 rowspan=2><select name='Rasional1'>{$optrasional1}</select></td>\t\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Kegiatan Setelah Kelulusan: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<textarea name='KegiatanSetelahKelulusan' cols=70 rows=1>{$w['KegiatanSetelahKelulusan']}</textarea></td>\r\n\t\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Alasan Masuk {$sisfo['Kode']}: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<textarea name='AlasanMasuk' cols=70 rows=3>{$w['AlasanMasuk']}</textarea></td>\r\n\t\t\t\t<td class=inp>Rasional: </td>\r\n\t\t\t\t<td class=ul1><select name='Rasional2'>{$optrasional2}</select></td>\t\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Harapan Calon Mahasiswa: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<textarea name='Harapan' cols=70 rows=3>{$w['Harapan']}</textarea></td>\r\n\t\t\t\t<td class=inp>Rasional: </td>\r\n\t\t\t\t<td class=ul1><select name='Rasional3'>{$optrasional3}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Harapan Pendamping</td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<textarea name='HarapanPendamping' cols=70 rows=3>{$w['HarapanPendamping']}</textarea></td>\r\n\t\t\t\t<td class=inp>Rasional: </td>\r\n\t\t\t\t<td class=ul1><select name='Rasional4'>{$optrasional4}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><th class=ttl colspan=6>Kemampuan</th></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Pilihan Prodi 1:</td>\r\n\t\t\t\t<td class=ul1><input type=text name='label1' value='{$w['Pilihan1']}' disabled/></td>\r\n\t\t\t\t<td class=inp rowspan=2>Saran Program Studi: </td>\r\n\t\t\t\t<td class=ul1 rowspan=2>\r\n\t\t\t\t\t<select name='SaranProdi'>{$optsaranprodi}</select></td>\r\n\t\t\t\t<th class=ttl colspan=2 rowspan=2>Hasil Rekomendasi</th></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Pilihan Prodi 2:</td>\r\n\t\t\t\t<td class=ul1><input type=text name='label2' value='{$w['Pilihan2']}' disabled/></td>\r\n\t\t\t<tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Pilihan Prodi 3:</td>\r\n\t\t\t\t<td class=ul1><input type=text name='label3' value='{$w['Pilihan3']}' disabled/></td>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Pilihan Keuangan: </td>\r\n\t\t\t\t<td class=ul1><select name='Keuangan'>{$optkeuangan}</select></td>\r\n\t\t\t\t<td class=inp>Rencana Pembayaran: </td>\r\n\t\t\t\t<td class=ul1>\r\n\t\t\t\t\t<textarea name='RencanaPembayaran' cols=30 rows=2>{$w['RencanaPembayaran']}</textarea></td>\r\n\t\t\t\t<td colspan=2 rowspan=2 align=center><select name='Rekomendasi'>{$optrekomendasi}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Mematuhi Tata Tertib: </td>\r\n\t\t\t\t<td class=ul1 colspan=3>\r\n\t\t\t\t\t<select name='PatuhTataTertib'>{$opttatatertib}</select></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t<tr><th class=ttl colspan=6>Tambahan</th></td>\r\n\t\t\t\t<td colspan=4></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Catatan: </td>\r\n\t\t\t\t<td class=ul1 colspan=5>\r\n\t\t\t\t\t<textarea name='CatatanAkhir' cols=100 rows=4>{$w['CatatanAkhir']}</textarea></td>\r\n\t\t\t<tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=ul1 colspan=6 align=center>\r\n\t\t\t\t\t<input type=submit name='Simpan' value='Simpan' />\r\n\t\t\t\t\t<input type=reset name='Reset' value='Reset'>\r\n\t\t\t\t\t<input type=button name='Batal' value='Batal' \r\n\t\t\t\t\t\tonClick=\"window.close()\" />\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t\t</form></table>\r\n\t\t\t";
}