/sysfo/prjdwluts.php

<?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=='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 Tengah Semester</title>

						<form name='prjdwluts' method='post'>

						<table align='center' width='400' border='1'>

						<tr align='center'>

						<td colspan='4'>Jadwal UTS</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='editprjdwluts' method='post'>

						<table align='center' width='1200' border='1'>

						<tr align='center'>

						<td colspan='12'>Tabel Jadwal UTS</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,UTSTanggal,UTSMulai,Kelas,KodeMK,IDDosen,UTSRuang 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[UTSTanggal]</td>

									<td>$hasil[UTSMulai]</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[UTSRuang]</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 Tengah Semester</title>

						<form name='prjdwluts' method='post'>

						<table align='center' width='400' border='1'>

						<tr align='center'>

						<td colspan='4'>Jadwal UTS</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='editprjdwluts' method='post'>

						<table align='center' width='1200' border='1'>

						<tr align='center'>

						<td colspan='12'>Tabel Jadwal UTS</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,UTSTanggal,UTSMulai,Kelas,KodeMK,IDDosen,UTSRuang 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[UTSTanggal]</td>

									<td>$hasil[UTSMulai]</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[UTSRuang]</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 Tengah 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[UTSTanggal]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='Jam' value='$hasil_cari[UTSMulai]'/>

							</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 Tengah 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[UTSTanggal]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='Jam' value='$hasil_cari[UTSMulai]'/>

							</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'];

			$UTSTanggal = $_POST['UTSTanggal'];

			$UTSMulai = $_POST['UTSMulai'];

			$Kelas = $_POST['Kelas'];

			$KodeMK = $_POST['Mata_Kuliah'];

			$IDDosen = $_POST['Dosen_Pengampu'];

			$UTSRuang = $_POST['Ruang'];

			

			$que_upd = "INSERT INTO jadwal (Hari,UTSTanggal,UTSMulai,Kelas,KodeMK,IDDosen,UTSRuang) VALUES ('$Hari','$UTSTanggal','$UTSMulai','$Kelas','$KodeMK','$IDDosen','$UTSRuang')";

			$jal_upd = mysql_query($que_upd);

			

			echo"<br /><a href='?syxec=$form'> << Kembali Ke Daftar</a><br />";

		break;

		case('update'):

			$Hari = $_POST['Hari'];

			$UTSTanggal = $_POST['UTSTanggal'];

			$UTSMulai = $_POST['UTSMulai'];

			$Kelas = $_POST['Kelas'];

			$KodeMK = $_POST['Mata_Kuliah'];

			$IDDosen = $_POST['Dosen_Pengampu'];

			$UTSRuang = $_POST['Ruang'];

			

			$que_upd = "UPDATE jadwal SET Hari='$Hari',UTSTanggal='$UTSTanggal',UTSMulai='$UTSMulai',Kelas='$Kelas',KodeMK='$KodeMK',IDDosen='$IDDosen',UTSRuang='$UTSRuang' 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;

}

?>