/sysfo/prjdwluas.php
PHP | 476 lines | 457 code | 19 blank | 0 comment | 18 complexity | 966ec0aab78f32d9bb698c2ca95575ad MD5 | raw file
- <?php
- $level=$_SESSION ['level'];
- $form=$_GET['syxec'];
- $unip = $_SESSION['unip'];
-
- if($level=='Karyawan Jurusan'){
- $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM karyawan_jurusan a , jurusan b where a.Kode=b.Kode AND a.ID=$unip");
- }
- else if($level=='Mahasiswa'){
- $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM mhsw a , jurusan b where a.KodeJurusan=b.Kode AND a.nim=$unip");
- }
- else if($level=='Dosen'){
- $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM dosen a , jurusan b where a.KodeJurusan=b.Kode AND a.id=$unip");
- }
- else if($level=='Dekan'){
- $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM dekan a , jurusan b where a.KodeJurusan=b.Kode AND a.id=$unip");
- }
- else if($level=='Karyawan Fakultas'){
- $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM karyawan_fakultas a , jurusan b where a.Kode=b.Kode AND a.ID=$unip");
- }
- else if($level=='Kajur'){
- $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM kajur a , jurusan b where a.Kode=b.Kode AND a.ID=$unip");
- }
- $jureks=mysql_fetch_array($jur);
- $kode=$jureks['Kode'];
- $jurusan=$jureks['Nama_Indonesia'];
-
- $fak=mysql_query("SELECT a.KodeFakultas , b.Nama_Indonesia FROM mhsw a , fakultas b where a.KodeFakultas=b.Kode AND a.KodeJurusan=$kode limit 1");
- $fakeks=mysql_fetch_array($fak);
- $fakultas=$fakeks[1];
-
- echo "$level - $unip<br /> $kode - $jurusan<br />";
-
- switch($_GET['aksi']){
- default:
- if($level=="Kajur"){
- echo " <input type='button' onclick=window.location.href='?syxec=$form&aksi=tambah' value='Tambah Jadwal' />
- <title>Jadwal Ujian Akhir Semester</title>
- <form name='prjdwluas' method='post'>
- <table align='center' width='400' border='1'>
- <tr align='center'>
- <td colspan='4'>Jadwal UAS</td>
- </tr><tr>
- <td>Thn Akademik</td>
- <td>:</td>
- <td><input type='text' name='txtthn_akdmik' size='40'></td>
- </tr><tr>
- <td>Fakultas</td>
- <td >:</td>
- <td><input type='text' name='txtnama' size='40' value='$fakultas' readonly></td>
- </tr><tr>
- <td>Jurusan</td>
- <td>:</td>
- <td><input type='text' name='txtnama' size='40' value='$jurusan' readonly></td>
- </tr>
- </table><br>
-
- <form name='editprjdwluas' method='post'>
- <table align='center' width='1200' border='1'>
- <tr align='center'>
- <td colspan='12'>Tabel Jadwal UAS</td>
- </tr><tr align='center'>
- <td align='center'>No</td>
- <td align='center'>Hari</td>
- <td align='center'>Tanggal</td>
- <td align='center'>Jam</td>
- <td align='center'>Kelas</td>
- <td align='center'>Mata Kuliah</td>
- <td align='center'>Dosen Pengampu</td>
- <td align='center'>Ruang</td>
- <td align='center'>Aksi</td>
- </tr>";
- $Nomor=0;
- $perintah = "SELECT ID,Hari,UASTanggal,UASMulai,Kelas,KodeMK,IDDosen,UASRuang FROM jadwal";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- $Nomor++;
- echo"<tr>
- <td>$Nomor</td>";
- $qwe=mysql_query("SELECT Nama FROM hari where ID='$hasil[Hari]'");
- $qwer=mysql_fetch_array($qwe);
- echo "
- <td>$qwer[Nama]</td>
- <td>$hasil[UASTanggal]</td>
- <td>$hasil[UASMulai]</td>";
- $qwe=mysql_query("SELECT Kelas FROM kelas WHERE ID='$hasil[Kelas]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Kelas]</td>";
- $qwe=mysql_query("SELECT Nama_Indonesia FROM matakuliah WHERE Kode='$hasil[KodeMK]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Nama_Indonesia]</td>";
-
- $qwe=mysql_query("SELECT Name FROM dosen WHERE ID='$hasil[IDDosen]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Name]</td>
- <td>$hasil[UASRuang]</td>
- <td><a href='?syxec=$form&aksi=edit&Nomor=$hasil[ID]'>Edit</a> | <a href='?syxec=$form&aksi=hapus&id=$hasil[ID]'>Hapus</a></td>
- </tr>";
- }
- echo"
- </table>
- </form>";
-
- }
- else{
- echo "
- <title>Jadwal Ujian Akhir Semester</title>
- <form name='prjdwluas' method='post'>
- <table align='center' width='400' border='1'>
- <tr align='center'>
- <td colspan='4'>Jadwal UAS</td>
- </tr><tr>
- <td>Thn Akademik</td>
- <td>:</td>
- <td><input type='text' name='txtthn_akdmik' size='40'></td>
- </tr><tr>
- <td>Fakultas</td>
- <td >:</td>
- <td><input type='text' name='txtnama' size='40' value='$fakultas' readonly></td>
- </tr><tr>
- <td>Jurusan</td>
- <td>:</td>
- <td><input type='text' name='txtnama' size='40' value='$jurusan' readonly></td>
- </tr>
- </table><br>
-
- <form name='editprjdwluas' method='post'>
- <table align='center' width='1200' border='1'>
- <tr align='center'>
- <td colspan='12'>Tabel Jadwal UAS</td>
- </tr><tr align='center'>
- <td align='center'>No</td>
- <td align='center'>Hari</td>
- <td align='center'>Tanggal</td>
- <td align='center'>Jam</td>
- <td align='center'>Kelas</td>
- <td align='center'>Mata Kuliah</td>
- <td align='center'>Dosen Pengampu</td>
- <td align='center'>Ruang</td>
- </tr>";
- $Nomor=0;
- $perintah = "SELECT ID,Hari,UASTanggal,UASMulai,Kelas,KodeMK,IDDosen,UASRuang FROM jadwal";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- $Nomor++;
- echo"<tr>
- <td>$Nomor</td>";
- $qwe=mysql_query("SELECT Nama FROM hari where ID='$hasil[Hari]'");
- $qwer=mysql_fetch_array($qwe);
- echo "
- <td>$qwer[Nama]</td>
- <td>$hasil[UASTanggal]</td>
- <td>$hasil[UASMulai]</td>";
- $qwe=mysql_query("SELECT Kelas FROM kelas WHERE ID='$hasil[Kelas]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Kelas]</td>";
- $qwe=mysql_query("SELECT Nama_Indonesia FROM matakuliah WHERE Kode='$hasil[KodeMK]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Nama_Indonesia]</td>";
-
- $qwe=mysql_query("SELECT Name FROM dosen WHERE ID='$hasil[IDDosen]'");
- $qwer=mysql_fetch_array($qwe);
- echo"
- <td>$qwer[Name]</td>
- <td>$hasil[UASRuang]</td>
- </tr>";
- }
- echo"
- </table>
- </form>";
-
- }
- break;
- case ('tambah') :
- echo "
- <form method='post' name='formjdwl' action='?syxec=$form&aksi=simpan&id=$Nomor_e'>
- <title>Jadwal Ujian Akhir Semester</title>
- <table align='center'>
- <tr>
-
- <td>
- <input type='hidden' name='nomor' value='$hasil_cari[ID]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Hari</label>
- </td>
- <td>
- :
- <select name='Hari'>
- <option name='hari' value='0'>-- Pilih hari --</option>";
- $perintah = "SELECT * FROM hari";
- $jalan_kel = mysql_query($perintah);
- while($hasil_kel = mysql_fetch_array($jalan_kel)){
- echo"
- <option value='$hasil_kel[0]'>$hasil_kel[1]</option>
- ";
- }
- echo "
- </select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Tanggal</label>
- </td>
- <td>
- : <input type='text' name='Tanggal' value='$hasil_cari[UASTanggal]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Jam</label>
- </td>
- <td>
- : <input type='text' name='Jam' value='$hasil_cari[UASMulai]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Kelas</label>
- </td>
- <td>
- :
- <select name='Kelas'>
- ";
- $perintah = "SELECT ID,Kelas FROM kelas";
- $jalan_kel = mysql_query($perintah);
- while($hasil_kel = mysql_fetch_array($jalan_kel)){
- echo"
- <option value='$hasil_kel[0]'>$hasil_kel[1]</option>
- ";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Mata Kuliah</label>
- </td>
- <td>
- :
- <select name='Mata_Kuliah'>
- <option value='0'>Pilih Matkul</option>";
- $perintah = "SELECT Kode,Nama_Indonesia FROM matakuliah";
- $jalan_matkul = mysql_query($perintah);
- while($hasil_matkul = mysql_fetch_array($jalan_matkul)){
- echo"
- <option value='$hasil_matkul[0]'>$hasil_matkul[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Pengampu</label>
- </td>
- <td>
- :
- <select name='Dosen_Pengampu'>";
- $perintah = "SELECT ID,Name FROM dosen";
- $jalan_dosen = mysql_query($perintah);
- while ($hasil_dosen = mysql_fetch_array($jalan_dosen)){
- echo"
- <option value='$hasil_dosen[0]'";
- if($hasil_dosen[1]==$hasil_cari[7]) echo "selected";
- echo">$hasil_dosen[1]</option>";
- }
-
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Ruang</label>
- </td>
- <td>
- :
- <select name='Ruang'>";
- $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option value=$hasil[0]
- ";
- if($hasil[1]==$hasil_cari[8]) echo "selected";
- echo"
- >$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td colspan='2' align='center'>
- <input type='reset' name='submit2' value='Reset' />
- <input type='submit' name='submit' value='Simpan' />
- </td>
- </tr>
- </table>
- </form>
- ";
- break;
-
- case ('edit'):
- $Nomor_e=$_GET['Nomor'];
- $perintah = "SELECT * from jadwal where ID='$Nomor_e'";
- $jalankan = mysql_query($perintah);
- $hasil_cari = mysql_fetch_array($jalankan);
- echo "
- <form method='post' name='formjdwl' action='?syxec=$form&aksi=update&id=$Nomor_e'>
- <title>Jadwal Ujian Akhir Semester</title>
- <table align='center'>
- <tr>
-
- <td>
- <input type='hidden' name='nomor' value='$hasil_cari[ID]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Hari</label>
- </td>
- <td>
- :
- <select name='Hari'>
- <option name='hari' value='0'>-- Pilih hari --</option>";
- $perintah = "SELECT * FROM hari";
- $jalan_kel = mysql_query($perintah);
- while($hasil_kel = mysql_fetch_array($jalan_kel)){
- echo"
- <option value='$hasil_kel[0]'>$hasil_kel[1]</option>
- ";
- }
- echo "
- </select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Tanggal</label>
- </td>
- <td>
- : <input type='text' name='Tanggal' value='$hasil_cari[UASTanggal]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Jam</label>
- </td>
- <td>
- : <input type='text' name='Jam' value='$hasil_cari[UASMulai]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Kelas</label>
- </td>
- <td>
- :
- <select name='Kelas'>
- ";
- $perintah = "SELECT ID,Kelas FROM kelas";
- $jalan_kel = mysql_query($perintah);
- while($hasil_kel = mysql_fetch_array($jalan_kel)){
- echo"
- <option value='$hasil_kel[0]'>$hasil_kel[1]</option>
- ";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Mata Kuliah</label>
- </td>
- <td>
- :
- <select name='Mata_Kuliah'>
- <option value='0'>Pilih Matkul</option>";
- $perintah = "SELECT Kode,Nama_Indonesia FROM matakuliah";
- $jalan_matkul = mysql_query($perintah);
- while($hasil_matkul = mysql_fetch_array($jalan_matkul)){
- echo"
- <option value='$hasil_matkul[0]'>$hasil_matkul[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Pengampu</label>
- </td>
- <td>
- :
- <select name='Dosen_Pengampu'>";
- $perintah = "SELECT ID,Name FROM dosen";
- $jalan_dosen = mysql_query($perintah);
- while ($hasil_dosen = mysql_fetch_array($jalan_dosen)){
- echo"
- <option value='$hasil_dosen[0]'";
- if($hasil_dosen[1]==$hasil_cari[7]) echo "selected";
- echo">$hasil_dosen[1]</option>";
- }
-
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Ruang</label>
- </td>
- <td>
- :
- <select name='Ruang'>";
- $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option value=$hasil[0]
- ";
- if($hasil[1]==$hasil_cari[8]) echo "selected";
- echo"
- >$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td colspan='2' align='center'>
- <input type='reset' name='submit2' value='Reset' />
- <input type='submit' name='submit' value='Ubah' />
- </td>
- </tr>
- </table>
- </form>
- ";
- break;
- case('simpan'):
- $Hari = $_POST['Hari'];
- $UASTanggal = $_POST['UASTanggal'];
- $UASMulai = $_POST['UASMulai'];
- $Kelas = $_POST['Kelas'];
- $KodeMK = $_POST['Mata_Kuliah'];
- $IDDosen = $_POST['Dosen_Pengampu'];
- $UASRuang = $_POST['Ruang'];
-
- $que_upd = "INSERT INTO jadwal (Hari,UASTanggal,UASMulai,Kelas,KodeMK,IDDosen,UASRuang) VALUES ('$Hari','$UASTanggal','$UASMulai','$Kelas','$KodeMK','$IDDosen','$UASRuang')";
- $jal_upd = mysql_query($que_upd);
-
- echo"<br /><a href='?syxec=$form'> << Kembali Ke Daftar</a><br />";
- break;
- case('update'):
- $Hari = $_POST['Hari'];
- $UASTanggal = $_POST['UASTanggal'];
- $UASMulai = $_POST['UASMulai'];
- $Kelas = $_POST['Kelas'];
- $KodeMK = $_POST['Mata_Kuliah'];
- $IDDosen = $_POST['Dosen_Pengampu'];
- $UASRuang = $_POST['Ruang'];
-
- $que_upd = "UPDATE jadwal SET Hari='$Hari',UASTanggal='$UASTanggal',UASMulai='$UASMulai',Kelas='$Kelas',KodeMK='$KodeMK',IDDosen='$IDDosen',UASRuang='$UASRuang' where ID=$_POST[nomor]";
- mysql_query($que_upd);
- echo"<br /><a href='?syxec=$form'> << Kembali Ke Daftar</a><br />";
- break;
- case('hapus'):
- $id=$_GET['id'];
- mysql_query("DELETE FROM jadwal WHERE ID=$id") or die("Gagal");
-
- echo"<br /><a href='?syxec=$form'> << Kembali Ke Daftar</a><br />";
- break;
- }
- ?>