function DsnAddSav($gos = 'DsnEdt') { $md = $_REQUEST['md'] + 0; $Login = sqling($_REQUEST['dsnid']); if (empty($Login)) { $Login = GetDosenID(date('Y')); } $Homebase = $_REQUEST['Homebase']; $NIDN = sqling($_REQUEST['NIDN']); $Nama = sqling($_REQUEST['Nama']); $TempatLahir = sqling($_REQUEST['TempatLahir']); $TanggalLahir = "{$_REQUEST['TglLahir_y']}-{$_REQUEST['TglLahir_m']}-{$_REQUEST['TglLahir_d']}"; $Gelar = sqling($_REQUEST['Gelar']); $Telephone = sqling($_REQUEST['Telephone']); $Handphone = sqling($_REQUEST['Handphone']); $Email = sqling($_REQUEST['Email']); $KelaminID = $_REQUEST['Kelamin']; $AgamaID = $_REQUEST['AgamaID']; $ProdiID = $_REQUEST['ProdiID']; $_ProdiID = empty($ProdiID) ? '' : '.' . implode('.', $ProdiID) . '.'; $NA = empty($_REQUEST['NA']) ? 'N' : $_REQUEST['NA']; if ($md == 0) { $s = "update dosen set NIDN='{$NIDN}', Nama='{$Nama}',\r\n TempatLahir='{$TempatLahir}', TanggalLahir='{$TanggalLahir}', \r\n Gelar='{$Gelar}', Telephone='{$Telephone}', Handphone='{$Handphone}',\r\n KelaminID='{$KelaminID}', AgamaID='{$AgamaID}',\r\n Email='{$Email}', ProdiID='{$_ProdiID}', NA='{$NA}'\r\n where Login='******' "; $r = _query($s); BerhasilSimpan("?mnux={$_SESSION['mnux']}&gos={$gos}&dsnid={$Login}", 100); } else { $ada = GetFields('dosen', "Login", $Login, '*'); if (empty($ada)) { $pass = setPasswordDosen($TanggalLahir); $s = "insert into dosen (Login, NIDN, Nama, TempatLahir, TanggalLahir,\r\n AgamaID, KelaminID, Password, Homebase,\r\n KodeID, Gelar, Telephone, Handphone,\r\n Email, ProdiID, NA)\r\n values ('{$Login}', '{$NIDN}', '{$Nama}', '{$TempatLahir}', '{$TanggalLahir}',\r\n '{$AgamaID}', '{$KelaminID}', PASSWORD('{$pass}'), '{$Homebase}',\r\n '{$_SESSION['KodeID']}', '{$Gelar}', '{$Telephone}', '{$Handphone}',\r\n '{$Email}', '{$_ProdiID}', '{$NA}')"; $r = _query($s); $_SESSION['dsnid'] = $_REQUEST['dsnid']; $_SESSION['dsnsub'] = "DsnEdtPribadi"; $_SESSION['dsncr'] = $_REQUEST['dsnid']; $_SESSION['dsnkeycr'] = "Login"; BerhasilSimpan("?mnux={$_SESSION['mnux']}&gos={$gos}&dsnid={$Login}", 100); } else { echo ErrorMsg("Gagal", "Data dosen tidak dapat disimpan karena NIP: <b>{$Login}</b> sudah dipakai oleh:\r\n <b>{$ada['Nama']}</b>.<br>\r\n Gunakan NIP lain.<hr size=1 color=silver>\r\n Pilihan: <a href='?mnux={$_SESSION['mnux']}&gos=DsnAdd&md=1'>Tambah Dosen</a> |\r\n <a href='?mnux={$_SESSION['mnux']}&gos='>Kembali ke Daftar Dosen</a>"); } } }
function DsnAddSav($gos = 'DsnEdt') { $md = $_REQUEST['md'] + 0; $Login = sqling($_REQUEST['dsnid']); $Homebase = $_REQUEST['Homebase']; $NIDN = sqling($_REQUEST['NIDN']); $Nama = sqling($_REQUEST['Nama']); $TempatLahir = sqling($_REQUEST['TempatLahir']); $TanggalLahir = "{$_REQUEST['TglLahir_y']}-{$_REQUEST['TglLahir_m']}-{$_REQUEST['TglLahir_d']}"; $Gelar = sqling($_REQUEST['Gelar']); $Telephone = sqling($_REQUEST['Telephone']); $Handphone = sqling($_REQUEST['Handphone']); $Email = sqling($_REQUEST['Email']); $KelaminID = $_REQUEST['Kelamin']; $AgamaID = $_REQUEST['AgamaID']; $ProdiID = $_REQUEST['ProdiID']; $_ProdiID = empty($ProdiID) ? '' : '.' . implode('.', $ProdiID) . '.'; $NA = empty($_REQUEST['NA']) ? 'N' : $_REQUEST['NA']; if ($md == 0) { $s = "update dosen set NIDN='{$NIDN}', Nama='{$Nama}',\n TempatLahir='{$TempatLahir}', TanggalLahir='{$TanggalLahir}', \n Gelar='{$Gelar}', Telephone='{$Telephone}', Handphone='{$Handphone}',\n KelaminID='{$KelaminID}', AgamaID='{$AgamaID}',\n Email='{$Email}', ProdiID='{$_ProdiID}', NA='{$NA}'\n where Login='******' "; $r = _query($s); $gos(); } else { $ada = GetFields('dosen', "Login", $Login, '*'); if (empty($ada)) { $pass = setPasswordDosen($TanggalLahir); $s = "insert into dosen (Login, NIDN, Nama, TempatLahir, TanggalLahir,\n AgamaID, KelaminID, Password, Homebase,\n KodeID, Gelar, Telephone, Handphone,\n Email, ProdiID, NA)\n values ('{$Login}', '{$NIDN}', '{$Nama}', '{$TempatLahir}', '{$TanggalLahir}',\n '{$AgamaID}', '{$KelaminID}', PASSWORD('{$pass}'), '{$Homebase}',\n '{$_SESSION['KodeID']}', '{$Gelar}', '{$Telephone}', '{$Handphone}',\n '{$Email}', '{$_ProdiID}', '{$NA}')"; $r = _query($s); $_SESSION['dsnid'] = $_REQUEST['dsnid']; $_SESSION['dsnsub'] = "DsnEdtPribadi"; $_SESSION['dsncr'] = $_REQUEST['dsnid']; $_SESSION['dsnkeycr'] = "Login"; echo "<script>window.location = '?mnux=modules/dosen.editdata';</script>"; } else { echo ErrorMsg("Gagal", "Data dosen tidak dapat disimpan karena NIP: <b>{$Login}</b> sudah dipakai oleh:\n <b>{$ada['Nama']}</b>"); } } }