function Simpan($md, $prd, $id)
{
TutupScript();
$Urutan = $_REQUEST['Urutan'] + 0;
$PMBUSMID = sqling($_REQUEST['PMBUSMID']);
$Tanggal = "{$_REQUEST['Tanggal_y']}-{$_REQUEST['Tanggal_m']}-{$_REQUEST['Tanggal_d']}";
$JamMulai = "{$_REQUEST['JamMulai_h']}:{$_REQUEST['JamMulai_n']}";
$JamSelesai = "{$_REQUEST['JamSelesai_h']}:{$_REQUEST['JamSelesai_n']}";
$PanjangWaktu = $_REQUEST['PanjangWaktu'] + 0;
$Ruang = $_REQUEST['Ruang'];
$Kapasitas = $_REQUEST['Kapasitas'] + 0;
// Simpan
$gelombang = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
$oke = '';
$w['TanggalUjian'] = $Tanggal;
$w['JamMulai'] = $JamMulai;
$w['JamSelesai'] = $JamSelesai;
$w['RuangID'] = $Ruang;
$w['PMBPeriodID'] = $gelombang;
$cekada = GetFields('pmbperiod', "KodeID='" . KodeID . "' and \r\n left(WawancaraMulai,10)<= '{$Tanggal}' and \r\n left(WawancaraSelesai,10)>= '{$Tanggal}' and NA", "N", "*");
$cek = GetFields('pmbperiod', "KodeID='" . KodeID . "' and NA", "N", "date_format(WawancaraMulai,'%d %M %Y') as Mulai, \r\n date_format(WawancaraSelesai,'%d %M %Y') as Selesai");
if (empty($cekada)) {
die(ErrorMsg('Kesalahan Tanggal', "Tanggal yang anda setting tidak sesuai dengan Tanggal Wawancara,<br/>\r\n yaitu dari Tanggal : <b>{$cek['Mulai']}</b> sampai dengan <b>{$cek['Selesai']}</b>.\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
}
//$oke .= CekTanggal($w, $id, $prd);
if (!empty($w['RuangID'])) {
$oke .= CekRuang($w, $id, $prd, $md);
}
if (empty($oke)) {
if ($md == 0) {
$s = "update wawancarausm\r\n\t\t set Tanggal = '{$Tanggal}',\r\n\t\t\t JamMulai = '{$JamMulai}', JamSelesai = '{$JamSelesai}', PanjangWaktu = '{$PanjangWaktu}',\r\n\t\t\t RuangID = '{$Ruang}', Kapasitas = '{$Kapasitas}',\r\n\t\t\t LoginEdit = '{$_SESSION['_Login']}', TanggalEdit = now()\r\n\t\t where KodeID = '" . KodeID . "' and WawancaraUSMID = '{$id}' ";
$r = _query($s);
echo "<script>ttutup()</script>";
} elseif ($md == 1) {
$smax = "select MAX(Urutan) as _maxurutan from `wawancarausm` where PMBPeriodID='{$gelombang}' and KodeID='" . KodeID . "'\r\n\t\t\t\t\tgroup by PMBPeriodID";
$rmax = _query($smax);
$wmax = _fetch_array($rmax);
$maxurutan = $wmax['_maxurutan'] + 1;
$s = "insert into wawancarausm\r\n\t\t\t (KodeID, ProdiID, PMBPeriodID, Kapasitas, Urutan, \r\n\t\t\t Tanggal, JamMulai, JamSelesai, RuangID, PanjangWaktu,\r\n\t\t\t LoginBuat, TanggalBuat)\r\n\t\t\t values\r\n\t\t\t ('" . KodeID . "', '{$prd}', '{$gelombang}', '{$Kapasitas}', '{$maxurutan}',\r\n\t\t\t '{$Tanggal}', '{$JamMulai}', '{$JamSelesai}', '{$Ruang}', '{$PanjangWaktu}', \r\n\t\t\t '{$_SESSION['_Login']}', now())";
$r = _query($s);
echo "<script>ttutup()</script>";
} else {
}
} else {
die(ErrorMsg('Jadwal Bentrok', "Berikut adalah list jadwal yang bentrok: \r\n <ol>{$oke}</ol>\r\n <div align=center><input type=button name='Tutup' value='Tutup' onClick=\"window.close();\"></div>\r\n\t </p>"));
}
}
function Simpan($md, $id, $jutsid)
{
$w['UTSTanggal'] = "{$_REQUEST['UTSTanggal_y']}-{$_REQUEST['UTSTanggal_m']}-{$_REQUEST['UTSTanggal_d']}";
$w['UTSJamMulai'] = "{$_REQUEST['UTSJamMulai_h']}:{$_REQUEST['UTSJamMulai_n']}";
$w['UTSJamSelesai'] = "{$_REQUEST['UTSJamSelesai_h']}:{$_REQUEST['UTSJamSelesai_n']}";
$w['UTSRuangID'] = $_REQUEST['UTSRuangID'];
$w['UTSKapasitas'] = $_REQUEST['UTSKapasitas'];
$w['UTSKolomUjian'] = $_REQUEST['UTSKolomUjian'];
$w['UTSDosenID'] = $_REQUEST['UTSDosenID'];
$w['JadwalID'] = $id;
$w['TahunID'] = $_REQUEST['TahunID'];
$w['ProdiID'] = $_REQUEST['ProdiID'];
$w['ProgramID'] = $_REQUEST['ProgramID'];
// *** Cek semuanya dulu ***
$cekada = GetFields('tahun', "NA='N' and TahunID='{$w['TahunID']}' \r\n and ProdiID = '{$w['ProdiID']}' \r\n and left(TglUTSMulai,10)<= '{$w['UTSTanggal']}' and \r\n left(TglUTSSelesai,10)>= '{$w['UTSTanggal']}' and ProgramID", "{$w['ProgramID']}", "*");
$cek = GetFields('tahun', "NA='N' and TahunID='{$w['TahunID']}' \r\n and ProdiID = '{$w['ProdiID']}' and ProgramID", "{$w['ProgramID']}", "date_format(TglUTSMulai,'%d %M %Y') as Mulai, date_format(TglUTSSelesai,'%d %M %Y') as Selesai");
if (empty($cekada)) {
die(ErrorMsg('Kesalahan Tanggal', "Tanggal yang anda setting tidak sesuai dengan Tanggal penjadwalan UTS,<br/>\r\n yaitu dari Tanggal : <b>{$cek['Mulai']}</b> sampai dengan <b>{$cek['Selesai']}</b>.\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
}
$oke = '';
if (!empty($w['UTSRuangID'])) {
$oke .= CekRuang($w, $jutsid);
}
//$oke .= CekTanggal($w, $jutsid);
// Ambil data MK
$mk = GetFields('mk', "MKID", $w['MKID'], "Nama,MKKode,KurikulumID,SKS,Sesi");
// Jika semuanya baik2 saja
if (empty($oke)) {
// Jika mode=edit
if ($md == 0) {
$s = "update jadwaluts\r\n set RuangID = '{$w['UTSRuangID']}',\r\n\t\t\tDosenID = '{$w['UTSDosenID']}',\r\n Kapasitas = '{$w['UTSKapasitas']}',\r\n Tanggal = '{$w['UTSTanggal']}',\r\n JamMulai = '{$w['UTSJamMulai']}', JamSelesai = '{$w['UTSJamSelesai']}',\r\n\t\t\tKolomUjian = '{$w['UTSKolomUjian']}',\r\n\t\t\tTanggalEdit = now(),\r\n LoginEdit = '{$_SESSION['_Login']}'\r\n where JadwalUTSID = '{$jutsid}' ";
$r = _query($s);
DaftarkanMhswKeRuangUTS($w, $jutsid);
TutupScript();
} elseif ($md == 1) {
$s = "insert into jadwaluts\r\n (KodeID, TahunID, JadwalID, DosenID, \r\n Tanggal, JamMulai, JamSelesai,\r\n\t\tKapasitas, RuangID, KolomUjian, TanggalBuat, LoginBuat)\r\n values\r\n ('" . KodeID . "', '{$w['TahunID']}', '{$w['JadwalID']}', '{$w['UTSDosenID']}',\r\n '{$w['UTSTanggal']}', '{$w['UTSJamMulai']}', '{$w['UTSJamSelesai']}',\r\n\t\t'{$w['UTSKapasitas']}', '{$w['UTSRuangID']}', '{$w['UTSKolomUjian']}', now(), '{$_SESSION['_Login']}')";
$r = _query($s);
$JadwalUTSID = mysql_insert_id();
DaftarkanMhswKeRuangUTS($w, $JadwalUTSID);
TutupScript();
}
} else {
die(ErrorMsg('Ada Kesalahan', "Berikut adalah pesan kesalahannya: \r\n <ol>{$oke}</ol>\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n \r\n\t <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
}
}
function Simpan($md, $id, $resid, $Kembali)
{
$_Gabungkan = $_REQUEST['_Gabungkan'] + 0;
$w = GetFields('jadwal', "JadwalID", $id, '*');
$w['JenisJadwalID'] = $_REQUEST['JenisJadwalID'];
$w['HariID'] = $_REQUEST['HariID'];
//$w['JamMulai'] = "$_REQUEST[JamMulai_h]:$_REQUEST[JamMulai_n]";
//$w['JamSelesai'] = "$_REQUEST[JamSelesai_h]:$_REQUEST[JamSelesai_n]";
$w['RuangID'] = sqling($_REQUEST['RuangID']);
$w['Kapasitas'] = $_REQUEST['Kapasitas'] + 0;
//$w['KuliahTanggal'] = "$_REQUEST[KuliahTanggal]";
$w['_RencanaKehadiranRes'] = $_REQUEST['_RencanaKehadiranRes'];
$w['_MaxAbsenRes'] = $_REQUEST['_MaxAbsenRes'];
if ($_Gabungkan == 721222) {
//$w['TglMulai'] = sqling($_REQUEST['TglMulai']);
//$w['TglSelesai'] = sqling($_REQUEST['TglSelesai']);
$w['KuliahTanggal'] = sqling($_REQUEST['KuliahTanggal']);
$w['JamMulai'] = $_REQUEST['JamMulai'];
$w['JamSelesai'] = $_REQUEST['JamSelesai'];
} else {
$w['KuliahTanggal'] = sqling($_REQUEST['KuliahTanggal']);
//"$_REQUEST[KuliahTanggal_y]-$_REQUEST[KuliahTanggal_m]-$_REQUEST[KuliahTanggal_d]";
$w['JamMulai'] = "{$_REQUEST['JamMulai_h']}:{$_REQUEST['JamMulai_n']}";
$w['JamSelesai'] = "{$_REQUEST['JamSelesai_h']}:{$_REQUEST['JamSelesai_n']}";
//$w['TglMulai'] = "$_REQUEST[TglMulai_y]-$_REQUEST[TglMulai_m]-$_REQUEST[TglMulai_d]";
//$w['TglSelesai'] = "$_REQUEST[TglSelesai_y]-$_REQUEST[TglSelesai_m]-$_REQUEST[TglSelesai_d]";
}
// *** Cek semuanya dulu ***
$oke = '';
if (!empty($w['RuangID'])) {
$oke .= CekRuang($w, $id, $resid);
}
//if (!empty($w['RuangID'])) $oke .= CekJadwalLab($w, $id, $resid);
// Ambil data MK
$mk = GetFields('mk', "MKID", $w['MKID'], "Nama,MKKode,KurikulumID,SKS,Sesi");
// Jika semuanya baik2 saja
if (empty($oke) || $_Gabungkan == 721222) {
// Jika mode=edit
if ($md == 0) {
$s = "update jadwal\r\n set JenisJadwalID = '{$w['JenisJadwalID']}',\r\n\t\t\tHariID = '{$w['HariID']}',\r\n JamMulai = '{$w['JamMulai']}',\r\n JamSelesai = '{$w['JamSelesai']}',\r\n DosenID = '{$w['DosenID']}',\r\n RuangID = '{$w['RuangID']}',\r\n Kapasitas = '{$w['Kapasitas']}',\r\n KuliahTanggal = '{$w['KuliahTanggal']}',\r\n\t\t\tRencanaKehadiran = '{$w['_RencanaKehadiranRes']}',\r\n\t\t\tMaxAbsen = '{$w['_MaxAbsenRes']}',\r\n\t\t\tTglEdit = now(),\r\n LoginEdit = '{$_SESSION['_Login']}'\r\n\t\twhere JadwalID='{$resid}'";
//where JadwalResponsiID = '$resid' ";
$r = _query($s);
TutupScript();
} elseif ($md == 1) {
$s = "insert into jadwal\r\n\t\t(KodeID, TahunID, ProdiID, ProgramID, NamaKelas, MKID, MKKode, Nama, \r\n\t\tJadwalRefID, KuliahTanggal, HariID, JamMulai, JamSelesai, SKSAsli, SKS, JenisJadwalID,\r\n DosenID, Kapasitas, RuangID, RencanaKehadiran, KehadiranMin, MaxAbsen, TglBuat, LoginBuat)\r\n values\r\n ('" . KodeID . "', '{$w['TahunID']}', '{$w['ProdiID']}', '{$w['ProgramID']}', '{$w['NamaKelas']}', '{$w['MKID']}', '{$w['MKKode']}', '{$w['Nama']}',\r\n\t\t'{$id}', '{$w['KuliahTanggal']}', '{$w['HariID']}', '{$w['JamMulai']}', '{$w['JamSelesai']}', '{$w['SKSAsli']}', 0, '{$w['JenisJadwalID']}',\r\n '{$w['DosenID']}', '{$w['Kapasitas']}', '{$w['RuangID']}', '{$w['_RencanaKehadiranRes']}', '{$w['_RencanaKehadiranRes']}', '{$w['_MaxAbsenRes']}', now(), '{$_SESSION['_Login']}')";
$r = _query($s);
TutupScript();
}
} else {
//KembaliScript($md, $id, $resid, $w);
GabungkanScript($md, $id, $resid, $w);
die(ErrorMsg('Jadwal Bentrok', "Berikut adalah pesan kesalahannya: \r\n <ol>{$oke}</ol>\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n <input type=button name='Paksakan' value='Gabungkan Jadwal' onClick='javascript:Gabung()' />\r\n <input type=button name='Kembali' value='Kembali' onClick=\"javascript:Kembali()\" />\r\n\t\t\t<input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
}
}
function Simpan($md, $id, $Kembali)
{
$_Gabungkan = $_REQUEST['_Gabungkan'] + 0;
$w = array();
$w['TahunID'] = sqling($_REQUEST['TahunID']);
$w['ProgramID'] = sqling($_REQUEST['ProgramID']);
$w['ProdiID'] = sqling($_REQUEST['ProdiID']);
$w['HariID'] = $_REQUEST['HariID'];
$w['JamMulai'] = "{$_REQUEST['JamMulai_h']}:{$_REQUEST['JamMulai_n']}";
$w['JamSelesai'] = "{$_REQUEST['JamSelesai_h']}:{$_REQUEST['JamSelesai_n']}";
$w['RuangID'] = sqling($_REQUEST['RuangID']);
$w['Kapasitas'] = $_REQUEST['Kapasitas'] + 0;
$w['MKID'] = $_REQUEST['MKID'];
$w['MKKode'] = $_REQUEST['MKKode'];
$w['MKNama'] = $_REQUEST['MKNama'];
$w['SKS'] = $_REQUEST['SKS'] + 0;
$w['DosenID'] = $_REQUEST['DosenID'];
$w['NamaKelas'] = sqling($_REQUEST['NamaKelas']);
$w['RencanaKehadiran'] = $_REQUEST['RencanaKehadiran'] + 0;
$w['KehadiranMin'] = $_REQUEST['KehadiranMin'] + 0;
$w['MaxAbsen'] = $_REQUEST['MaxAbsen'] + 0;
if ($_Gabungkan == 721222) {
$w['TglMulai'] = sqling($_REQUEST['TglMulai']);
$w['TglSelesai'] = sqling($_REQUEST['TglSelesai']);
} else {
$w['TglMulai'] = "{$_REQUEST['TglMulai_y']}-{$_REQUEST['TglMulai_m']}-{$_REQUEST['TglMulai_d']}";
$w['TglSelesai'] = "{$_REQUEST['TglSelesai_y']}-{$_REQUEST['TglSelesai_m']}-{$_REQUEST['TglSelesai_d']}";
}
if ($_REQUEST['BiayaKhusus'] == 'Y') {
$w['BiayaKhusus'] = 'Y';
$w['Biaya'] = $_REQUEST['Biaya'] + 0;
$w['NamaBiaya'] = $_REQUEST['NamaBiaya'];
} else {
$w['BiayaKhusus'] = 'N';
$w['Biaya'] = 0;
$w['NamaBiaya'] = '';
}
$w['AdaResponsi'] = $_REQUEST['AdaResponsi'] == 'Y' ? 'Y' : 'N';
// Validasi
if (empty($w['MKID'])) {
die(ErrorMsg('Error', "Matakuliah belum dipilih.<br />\r\n Ambil matakuliah di fasiltas pencarian untuk melengkapi data matakuliah.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n Opsi: <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
}
// *** parameters ***
$DosenAda = GetaField('dosen', "KodeID='" . KodeID . "' and Login", $w['DosenID'], 'Nama');
if (empty($DosenAda)) {
die(ErrorMsg('Error', "Dosen dengan kode: <b>{$w['DosenID']}</b> tidak ditemukan.<br />\r\n Masukkan Dosen dengan fasilitas pencarian.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n Opsi: <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
}
// *** Cek semuanya dulu ***
$oke = '';
if (!empty($w['RuangID'])) {
$oke .= CekRuang($w, $id);
}
$oke .= CekDosen($w, $id);
// Ambil data MK
$mk = GetFields('mk', "MKID", $w['MKID'], "Nama,MKKode,KurikulumID,SKS,Sesi");
// Jika semuanya baik2 saja
if (empty($oke) || $_Gabungkan == 721222) {
// Jika mode=edit
if ($md == 0) {
$s = "update jadwal\r\n set ProgramID = '{$w['ProgramID']}',\r\n MKID = '{$w['MKID']}',\r\n MKKode = '{$mk['MKKode']}',\r\n Nama = upper('{$mk['Nama']}'),\r\n NamaKelas = upper('{$w['NamaKelas']}'),\r\n HariID = '{$w['HariID']}',\r\n JamMulai = '{$w['JamMulai']}',\r\n JamSelesai = '{$w['JamSelesai']}',\r\n SKS = '{$w['SKS']}',\r\n SKSAsli = '{$mk['SKS']}',\r\n DosenID = '{$w['DosenID']}',\r\n RencanaKehadiran = '{$w['RencanaKehadiran']}',\r\n KehadiranMin = '{$w['KehadiranMin']}',\r\n\t\t\tMaxAbsen = '{$w['MaxAbsen']}',\r\n RuangID = '{$w['RuangID']}',\r\n Kapasitas = '{$w['Kapasitas']}',\r\n TglMulai = '{$w['TglMulai']}',\r\n\t\t\tTglSelesai = '{$w['TglSelesai']}',\r\n\t\t\tAdaResponsi = '{$w['AdaResponsi']}',\r\n\t\t\tBiayaKhusus = '{$w['BiayaKhusus']}',\r\n Biaya = '{$w['Biaya']}',\r\n\t\t\tNamaBiaya = '{$w['NamaBiaya']}',\r\n TglEdit = now(),\r\n LoginEdit = '{$_SESSION['_Login']}'\r\n where JadwalID = '{$id}' ";
$r = _query($s);
// Tambahan untuk update kuliah tambahan lab/responsi/tutorial
$s = "update jadwal\r\n set ProgramID = '{$w['ProgramID']}',\r\n MKID = '{$w['MKID']}',\r\n MKKode = '{$mk['MKKode']}',\r\n Nama = upper('{$mk['Nama']}'),\r\n NamaKelas = upper('{$w['NamaKelas']}'),\r\n SKS = '{$w['SKS']}',\r\n SKSAsli = '{$mk['SKS']}',\r\n TglEdit = now(),\r\n LoginEdit = '{$_SESSION['_Login']}'\r\n where JadwalRefID = '{$id}' ";
$r = _query($s);
TutupScript();
} elseif ($md == 1) {
$s = "insert into jadwal\r\n (KodeID, TahunID, ProdiID, ProgramID,\r\n NamaKelas, MKID, MKKode, Nama, TglMulai, TglSelesai,\r\n HariID, JamMulai, JamSelesai, SKSAsli, SKS,\r\n DosenID, RencanaKehadiran, KehadiranMin, MaxAbsen, \r\n AdaResponsi, BiayaKhusus, Biaya, NamaBiaya, \r\n Kapasitas, RuangID, TglBuat, LoginBuat)\r\n values\r\n ('" . KodeID . "', '{$w['TahunID']}', '{$w['ProdiID']}', '{$w['ProgramID']}',\r\n upper('{$w['NamaKelas']}'), '{$w['MKID']}', '{$mk['MKKode']}', upper('{$mk['Nama']}'), '{$w['TglMulai']}', '{$w['TglSelesai']}',\r\n '{$w['HariID']}', '{$w['JamMulai']}', '{$w['JamSelesai']}', '{$mk['SKS']}', '{$w['SKS']}',\r\n '{$w['DosenID']}', '{$w['RencanaKehadiran']}', '{$w['KehadiranMin']}', '{$w['MaxAbsen']}',\r\n '{$w['AdaResponsi']}', '{$w['BiayaKhusus']}', '{$w['Biaya']}', '{$w['NamaBiaya']}',\r\n '{$w['Kapasitas']}', '{$w['RuangID']}', now(), '{$_SESSION['_Login']}')";
$r = _query($s);
TutupScript();
}
} else {
GabungkanScript($md, $id, $w);
die(ErrorMsg('Ada Kesalahan', "Berikut adalah pesan kesalahannya: \r\n <ol>{$oke}</ol>\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n <input type=button name='Kembali' value='Kembali' onClick=\"javascript:Kembali()\" />\r\n\t <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
// <input type=button name='Paksakan' value='Gabungkan Jadwal'
// onClick='javascript:Gabung()' />
}
}
function Simpan($md, $prd, $id)
{
TutupScript();
$w = array();
$w['Urutan'] = $_REQUEST['Urutan'] + 0;
$w['Gelombang'] = $_REQUEST['gelombang'];
$w['PMBUSMID'] = sqling($_REQUEST['PMBUSMID']);
$w['JumlahSoal'] = $_REQUEST['JumlahSoal'] + 0;
$w['TanggalUjian'] = "{$_REQUEST['TanggalUjian_y']}-{$_REQUEST['TanggalUjian_m']}-{$_REQUEST['TanggalUjian_d']}";
$w['JamMulai'] = "{$_REQUEST['JamMulai_h']}:{$_REQUEST['JamMulai_n']}";
$w['JamSelesai'] = "{$_REQUEST['JamSelesai_h']}:{$_REQUEST['JamSelesai_n']}";
$w['PMBPeriodID'] = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
$Ruang = $_REQUEST['Ruang'];
$cekada = GetFields('pmbperiod', "KodeID='" . KodeID . "' and \r\n left(UjianMulai,10)<= '{$w['TanggalUjian']}' and \r\n left(UjianSelesai,10)>= '{$w['TanggalUjian']}' and NA", "N", "*");
$cek = GetFields('pmbperiod', "KodeID='" . KodeID . "' and NA", "N", "date_format(UjianMulai,'%d %M %Y') as Mulai, \r\n date_format(UjianSelesai,'%d %M %Y') as Selesai");
if (empty($cekada)) {
die(ErrorMsg('Kesalahan Tanggal', "Tanggal yang anda setting tidak sesuai dengan Tanggal penjadwalan Ujian,<br/>\r\n yaitu dari Tanggal : <b>{$cek['Mulai']}</b> sampai dengan <b>{$cek['Selesai']}</b>.\r\n <hr size=1 color=silver />\r\n <p align=center>\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />\r\n </p>"));
}
foreach ($Ruang as $pilihruang) {
if (empty($ruangstring)) {
$ruangstring = $pilihruang;
} else {
$ruangstring .= "," . $pilihruang;
}
}
$w['RuangID'] = $ruangstring;
$oke = '';
$oke = CekMataUji($w, $id, $prd);
if (!empty($w['RuangID'])) {
$oke .= CekRuang($w, $id, $prd, $md);
}
if (empty($oke)) {
// Simpan
if ($md == 0) {
$s = "update prodiusm\r\n\t\t set Urutan = '{$w['Urutan']}', \r\n\t\t \t PMBPeriodID = '{$w['Gelombang']}',\r\n\t\t \t PMBUSMID = '{$w['PMBUSMID']}', \r\n\t\t\t JumlahSoal = '{$w['JumlahSoal']}', TanggalUjian = '{$w['TanggalUjian']}',\r\n\t\t\t JamMulai = '{$w['JamMulai']}', JamSelesai = '{$w['JamSelesai']}',\r\n\t\t\t RuangID = '{$w['RuangID']}',\r\n\t\t\t LoginEdit = '{$_SESSION['_Login']}', TanggalEdit = now()\r\n\t\t where KodeID = '" . KodeID . "' and ProdiUSMID = '{$id}' ";
$r = _query($s);
echo "<script>ttutup()</script>";
} elseif ($md == 1) {
$s = "insert into prodiusm\r\n\t\t (KodeID, PMBUSMID, ProdiID, Urutan, PMBPeriodID,\r\n\t\t TanggalUjian, JamMulai, JamSelesai, RuangID, JumlahSoal,\r\n\t\t LoginBuat, TanggalBuat)\r\n\t\t values\r\n\t\t ('" . KodeID . "', '{$w['PMBUSMID']}', '{$prd}', '{$w['Urutan']}', '{$w['Gelombang']}',\r\n\t\t '{$w['TanggalUjian']}', '{$w['JamMulai']}', '{$w['JamSelesai']}', '{$w['RuangID']}', '{$w['JumlahSoal']}',\r\n\t\t '{$_SESSION['_Login']}', now())";
$r = _query($s);
echo "<script>ttutup()</script>";
} else {
}
} else {
die(ErrorMsg('Jadwal Bentrok', "Berikut adalah list jadwal yang bentrok: \r\n <ol>{$oke}</ol>\r\n </p>"));
}
}
