Exemplo n.º 1
0
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>");
        }
    }
}
Exemplo n.º 2
0
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>");
        }
    }
}