pkjadwalujian.php | searchcode

/sysfo/pkjadwalujian.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 1044 lines | 966 code | 54 blank | 24 comment | 13 complexity | 09fbf18f3da990ad88b32cd7fa739e62 MD5 | raw file

<?php

	$a=$_SESSION['level'];

	$b=$_GET['syxec'];

	$c=$_SESSION ['uid'];

	

	//echo"level = $a<br>";

	//echo"id = $c<br>";

	

	//deskripsi kajur

	$que_jur ="SELECT description FROM kajur WHERE id='$c'";

	$jal_jur = mysql_query($que_jur);

	$hasil = mysql_fetch_array($jal_jur);

	//echo"$hasil[0]<br>";

	$potong = substr($hasil[0],6,30);

	//echo"desc kajur = $potong<br>";

	

	//deskripsi karyawan jurusan

	$que_jur2 ="SELECT description FROM karyawan_jurusan WHERE id='$c'";

	$jal_jur2 = mysql_query($que_jur2);

	$hasil2 = mysql_fetch_array($jal_jur2);

	//echo"$hasil2[0]<br>";

	$potong2 = substr($hasil2[0],9,30);

	//echo"desc karyawan jurusan = $potong2<br>";

	

	//kode jurusan

	$per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";

	$jalankan = mysql_query($per_id_jur);

	$hasil_id_jur = mysql_fetch_array($jalankan);

	//echo"kode kajur = $hasil_id_jur[0]<br>";

	

	//kode jurusan 2

	//kode jurusan

	$per_id_jur1 = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong2'";

	$jalankan1 = mysql_query($per_id_jur1);

	$hasil_id_jur1 = mysql_fetch_array($jalankan1);

	//echo"kode karyawan jurusan = $hasil_id_jur1[0]<br>";

	

	//kode dosen

	$que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$c'";

	$jal_dosen = mysql_query($que_dosen);

	$hasil_dosen = mysql_fetch_array($jal_dosen);

	//echo"kode dosen = $hasil_dosen[0]<br>";

	

	//kode mahasiswa

	$que_mhs ="SELECT kodejurusan FROM mhsw WHERE id='$c'";

	$jal_mhs = mysql_query($que_mhs);

	$hasil_mhs = mysql_fetch_array($jal_mhs);

	//echo"kode mhs = $hasil_mhs[0]<br>";

	

	//nim mhs

	$per_sel_mah = "SELECT nim FROM mhsw WHERE id='$c'";

	$jalan_sel_mah = mysql_query($per_sel_mah);

	$hasil_sel_mah = mysql_fetch_array($jalan_sel_mah);

	//echo"NIM mhs = $hasil_sel_mah[0]<br>";

	echo"<center><h1>Jadwal Ujian PKL<h1></center>";

	switch($_GET['aksi']){

		default:

			if($a=="Kajur"){

				echo "

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

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

								<tr>

									<td colspan='21' align='left'>

										<input type='button' name='tambah' onclick=window.location.href='?syxec=$b&aksi=tambah' name='tambah' value='Tambah'/>

									</td>

								</tr>

								<tr>

									<th>Id Jadwal</th>

									<th>Nama Kelompok</th>

									<th>Nama Ruang</th>

									<th>Hari</th>

									<th>Tanggal</th>

									<th>Jam</th>

									<th>Dosen Penguji 1</th>

									<th>Dosen Penguji 2</th>

									<th>Dosen Penguji 3</th>

									<th>Aksi</th>

								</tr>

								";

									$perintah = "SELECT * FROM pkl_penjadwalan WHERE jurusan='$hasil_id_jur[0]'";

									$jalan = mysql_query($perintah);

									while($hasil=mysql_fetch_array($jalan)){

										echo"

											<tr>

												<td>$hasil[0]</td>";

												$perintah = "SELECT nama_kelompok FROM pkl_kelompok WHERE id_kelompok='$hasil[1]'";

												$jalankan = mysql_query($perintah);

												$hasil_nama = mysql_fetch_array($jalankan);

												echo"

													<td>$hasil_nama[0]</td>

												";

												

												$perintah = "SELECT Nama FROM ruang WHERE Kode='$hasil[2]'";

												$jalankan = mysql_query($perintah);

												$hasil_nama_ruang = mysql_fetch_array($jalankan);

												echo"

													<td>$hasil_nama_ruang[0]</td>

												";

												echo"

													<td>$hasil[3]</td>

													<td>$hasil[4]</td>

													<td>$hasil[5]</td>

												";

												

												$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[6]'";

												$jalankan = mysql_query($perintah);

												$hasil_nama_dosen1 = mysql_fetch_array($jalankan);

												echo"

													<td>$hasil_nama_dosen1[0]</td>

												";

												

												$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[7]'";

												$jalankan = mysql_query($perintah);

												$hasil_nama_dosen2 = mysql_fetch_array($jalankan);

												echo"

													<td>$hasil_nama_dosen2[0]</td>

												";

												

												$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[8]'";

												$jalankan = mysql_query($perintah);

												$hasil_nama_dosen3 = mysql_fetch_array($jalankan);

												echo"

													<td>$hasil_nama_dosen3[0]</td>

												";

												echo"

												<td><a href='?syxec=$b&aksi=edit&id=$hasil[0]'>Edit</a> | <a href='?syxec=$b&aksi=hapus&id=$hasil[0]'>Hapus</a></td>

											<tr>

										";

									}

								echo"

							</table>

						</form>

					";

			}

			else if($a=="Dosen"){

				echo "

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

						<tr>

							<th>Id Jadwal</th>

							<th>Nama Kelompok</th>

							<th>Nama Ruang</th>

							<th>Hari</th>

							<th>Tanggal</th>

							<th>Jam</th>

							<th>Dosen Penguji 1</th>

							<th>Dosen Penguji 2</th>

							<th>Dosen Penguji 3</th>

							

						</tr>";

							$perintah = "SELECT * FROM pkl_penjadwalan WHERE penguji1='$c' OR penguji2='$c' OR penguji3='$c'";



								$jalan = mysql_query($perintah);

								while($hasil=mysql_fetch_array($jalan)){

									echo"

										<tr>

											<td>$hasil[0]</td>";

											$perintah = "SELECT nama_kelompok FROM pkl_kelompok WHERE id_kelompok='$hasil[1]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama[0]</td>

											";

											

											$perintah = "SELECT Nama FROM ruang WHERE Kode='$hasil[2]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_ruang = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_ruang[0]</td>

											";

											echo"

												<td>$hasil[3]</td>

												<td>$hasil[4]</td>

												<td>$hasil[5]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[6]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen1 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen1[0]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[7]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen2 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen2[0]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[8]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen3 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen3[0]</td>

										<tr>

									";

								}

						echo"

					</table>

					</form>

				";

			}

			else if($a=="Mahasiswa"){

				echo "

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

						<tr>

							<th>Id Jadwal</th>

							<th>Nama Kelompok</th>

							<th>Nama Ruang</th>

							<th>Hari</th>

							<th>Tanggal</th>

							<th>Jam</th>

							<th>Dosen Penguji 1</th>

							<th>Dosen Penguji 2</th>

							<th>Dosen Penguji 3</th>

							

						</tr>";

							$per_sel_kel = "SELECT id_kelompok FROM pkl_peserta WHERE nim='$hasil_sel_mah[0]'";

							$jalan_sel_kel = mysql_query($per_sel_kel);

							$hasil_sel_kel = mysql_fetch_array($jalan_sel_kel);

							echo"Kel mhs = $hasil_sel_kel[0]";

							

							$perintah = "SELECT * FROM pkl_penjadwalan WHERE id_kelompok='$hasil_sel_kel[0]'";

							$jalan = mysql_query($perintah);

								while($hasil=mysql_fetch_array($jalan)){

									echo"

										<tr>

											<td>$hasil[0]</td>";

											$perintah = "SELECT nama_kelompok FROM pkl_kelompok WHERE id_kelompok='$hasil[1]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama[0]</td>

											";

											

											$perintah = "SELECT Nama FROM ruang WHERE Kode='$hasil[2]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_ruang = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_ruang[0]</td>

											";

											echo"

												<td>$hasil[3]</td>

												<td>$hasil[4]</td>

												<td>$hasil[5]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[6]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen1 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen1[0]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[7]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen2 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen2[0]</td>

											";

											

											$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[8]'";

											$jalankan = mysql_query($perintah);

											$hasil_nama_dosen3 = mysql_fetch_array($jalankan);

											echo"

												<td>$hasil_nama_dosen3[0]</td>

										<tr>

									";

								}

						echo"

					</table>

				";

			}

			else if($a=="Karyawan Jurusan"){

				echo "

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

						<tr>

							<th>Id Jadwal</th>

							<th>Nama Kelompok</th>

							<th>Nama Ruang</th>

							<th>Hari</th>

							<th>Tanggal</th>

							<th>Jam</th>

							<th>Dosen Penguji 1</th>

							<th>Dosen Penguji 2</th>

							<th>Dosen Penguji 3</th>

						</tr>

				";

						$perintah = "SELECT * FROM pkl_penjadwalan WHERE jurusan='$hasil_id_jur1[0]'";

						$jalan = mysql_query($perintah);

						while($hasil=mysql_fetch_array($jalan)){

							echo"

								<tr>

									<td>$hasil[0]</td>";

									$perintah = "SELECT nama_kelompok FROM pkl_kelompok WHERE id_kelompok='$hasil[1]'";

									$jalankan = mysql_query($perintah);

									$hasil_nama = mysql_fetch_array($jalankan);

									echo"

										<td>$hasil_nama[0]</td>

									";

									

									$perintah = "SELECT Nama FROM ruang WHERE Kode='$hasil[2]'";

									$jalankan = mysql_query($perintah);

									$hasil_nama_ruang = mysql_fetch_array($jalankan);

									echo"

										<td>$hasil_nama_ruang[0]</td>

									";

									echo"

										<td>$hasil[3]</td>

										<td>$hasil[4]</td>

										<td>$hasil[5]</td>

									";

									

									$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[6]'";

									$jalankan = mysql_query($perintah);

									$hasil_nama_dosen1 = mysql_fetch_array($jalankan);

									echo"

										<td>$hasil_nama_dosen1[0]</td>

									";

									

									$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[7]'";

									$jalankan = mysql_query($perintah);

									$hasil_nama_dosen2 = mysql_fetch_array($jalankan);

									echo"

										<td>$hasil_nama_dosen2[0]</td>

									";

									

									$perintah = "SELECT Name FROM dosen WHERE ID='$hasil[8]'";

									$jalankan = mysql_query($perintah);

									$hasil_nama_dosen3 = mysql_fetch_array($jalankan);

									echo"

										<td>$hasil_nama_dosen3[0]</td>

								<tr>

							";

						}

					echo"

				</table>

			";

			}

		break;

		

		case('tambah'):

			$perintah = "SELECT max(id_jdwal) from pkl_penjadwalan";

			$jalankan = mysql_query($perintah);

			$hasil = mysql_fetch_array($jalankan);

			$id_sekarang = $hasil[0]+1;

			

			echo "

				<form method='post' name='formtambahjadwalpkl' action='?syxec=$b&aksi=insert'>

					<table align='center'>

						<tr>

							<td><label>Id Jadwal</label></td>

							<td> : <input type='text' name='id_jadwal' value='$id_sekarang'/></td>

						</tr>

						<tr>

							<td>

								<label>Nama Kelompok</label>

							</td>

							<td>

								:

								<select name='id_kelompok'>

									<option value='0'>- Pilih Kelompok -</option>";

										$perintah_kel = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok WHERE kode_jurusan='$hasil_id_jur[0]' ORDER BY id_kelompok";

										$jalan_kel = mysql_query($perintah_kel);

										while($hasil_kel = mysql_fetch_array($jalan_kel)){

											echo "<option name='id_kelompok' value=$hasil_kel[0]>$hasil_kel[1]</option>";

										}

							echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Ruang</label>

							</td>

							<td>

								:

								<select name='id_ruang'>

									<option value='0'>- Pilih Ruang -</option>";

										$perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Hari</label>

							</td>

							<td>

								: 

								<select name='hari'>

									<option value='0' selected>- Pilih Hari -</option>

									<option name='hari' value='senin'>senin</option>

									<option name='hari' value='selasa'>selasa</option>

									<option name='hari' value='rabu'>rabu</option>

									<option name='hari' value='kamis'>kamis</option>

									<option name='hari' value='jumat'>jumat</option>

									<option name='hari' value='sabtu'>sabtu</option>

								</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Tanggal</label>

							</td>

							<td>

								: <input type='text' name='tanggal'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='jam'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 1</label>

							</td>

							<td>

								:

								<select name='dosen_penguji1'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 2</label>

							</td>

							<td>

								:

								<select name='dosen_penguji2'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 3</label>

							</td>

							<td>

								:

								<select name='dosen_penguji3'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji3' value=$hasil[0]>$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'):

			$id_ne=$_GET['id'];

			$perintah = "SELECT * from pkl_penjadwalan where id_jdwal='$id_ne'";

			$jalankan = mysql_query($perintah);

			$hasil_cari = mysql_fetch_array($jalankan);

			

			echo "

				<form method='post' name='formtambahjadwalpkl' action='?syxec=$b&aksi=ubah'>

					<table align='center'>

						<tr>

							<td>

								<label>Id jadwal</label>

							</td>

							<td>

								: <input type='text' name='id_jadwal' value='$hasil_cari[0]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Kelompok</label>

							</td>

							<td>

								: 

								<select name='id_kelompok'>";

									$perintah = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok where id_kelompok='$hasil_cari[1]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok ORDER BY id_kelompok";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_kelompok' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Ruang</label>

							</td>

							<td>

								:

								<select name='id_ruang'>";

									$perintah = "SELECT Kode,Nama FROM ruang where Kode='$hasil_cari[2]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Hari</label>

							</td>

							<td>

								: <input type='text' name='hari' value='$hasil_cari[3]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Tanggal</label>

							</td>

							<td>

								: <input type='text' name='tanggal' value='$hasil_cari[4]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='jam' value='$hasil_cari[5]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 1</label>

							</td>

							<td>

								:

								<select name='dosen_penguji1'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[6]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 2</label>

							</td>

							<td>

								:

								<select name='dosen_penguji2'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[7]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 3</label>

							</td>

							<td>

								:

								<select name='dosen_penguji3'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[8]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji3' value=$hasil[0]>$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('tambah'):

			$perintah = "SELECT max(id_jdwal) from pkl_penjadwalan";

			$jalankan = mysql_query($perintah);

			$hasil = mysql_fetch_array($jalankan);

			$id_sekarang = $hasil[0]+1;

						

			$perintah_kel = "SELECT jurusan FROM pkl_kelompok ORDER BY id_kelompok";

			$jalan_kel = mysql_query($perintah_kel);

			while($hasil_kel = mysql_fetch_array($jalan_kel)){

				echo "<option name='id_kelompok' value=$hasil_kel[0]>$hasil_kel[1]</option>";

			}

			

			echo "

				<form method='post' name='formtambahjadwalpkl' action='?syxec=$b&aksi=insert'>

					<table align='center'>

						<tr>

							<td>

								<label>Nama Kelompok</label>

							</td>

							<td>

								: 

								<select name='id_kelompok'>

									<option value='0'>- Pilih Kelompok -</option>";

										$perintah_kel = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok ORDER BY id_kelompok";

										$jalan_kel = mysql_query($perintah_kel);

										while($hasil_kel = mysql_fetch_array($jalan_kel)){

											echo "<option name='id_kelompok' value=$hasil_kel[0]>$hasil_kel[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Ruang</label>

							</td>

							<td>

								:

								<select name='id_ruang'>

									<option value='0'>- Pilih Ruang -</option>";

										$perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Hari</label>

							</td>

							<td>

								: <input type='text' name='hari'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Tanggal</label>

							</td>

							<td>

								: <input type='text' name='tanggal'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='jam'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 1</label>

							</td>

							<td>

								:

								<select name='dosen_penguji1'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 2</label>

							</td>

							<td>

								:

								<select name='dosen_penguji2'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 3</label>

							</td>

							<td>

								:

								<select name='dosen_penguji3'>

									<option value='0' selected>- Pilih Dosen Penguji -</option>";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji3' value=$hasil[0]>$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'):

			$id_ne=$_GET['id'];

			$perintah = "SELECT * from pkl_penjadwalan where id_jdwal='$id_ne'";

			$jalankan = mysql_query($perintah);

			$hasil_cari = mysql_fetch_array($jalankan);

			

			echo "

				<form method='post' name='formtambahjadwalpkl' action='?syxec=$b&aksi=ubah'>

					<table align='center'>

						<tr>

							<td>

								<label>Id jadwal</label>

							</td>

							<td>

								: <input type='text' name='id_jadwal' value='$hasil_cari[0]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Kelompok</label>

							</td>

							<td>

								: 

								<select name='id_kelompok'>";

									$perintah = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok where id_kelompok='$hasil_cari[1]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT id_kelompok,nama_kelompok FROM pkl_kelompok ORDER BY id_kelompok";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_kelompok' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Nama Ruang</label>

							</td>

							<td>

								:

								<select name='id_ruang'>";

									$perintah = "SELECT Kode,Nama FROM ruang where Kode='$hasil_cari[2]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Hari</label>

							</td>

							<td>

								: <input type='text' name='hari' value='$hasil_cari[3]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Tanggal</label>

							</td>

							<td>

								: <input type='text' name='tanggal' value='$hasil_cari[4]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='jam' value='$hasil_cari[5]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 1</label>

							</td>

							<td>

								:

								<select name='dosen_penguji1'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[6]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 2</label>

							</td>

							<td>

								:

								<select name='dosen_penguji2'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[7]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 3</label>

							</td>

							<td>

								:

								<select name='dosen_penguji3'>";

									$perintah = "SELECT ID,Name FROM dosen where ID='$hasil_cari[8]'";

									$jalan_kel = mysql_query($perintah);

									$hasil_kel = mysql_fetch_array($jalan_kel);

									echo"

										<option value='$hasil_kel[0]'>$hasil_kel[1]</option>

									";

										$perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";

										$jalan = mysql_query($perintah);

										while($hasil = mysql_fetch_array($jalan)){

											echo "<option name='dosen_penguji3' value=$hasil[0]>$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('insert'):

			$id_jadwal = $_POST['id_jadwal'];

			$id_kelompok = $_POST['id_kelompok'];

			$id_ruang = $_POST['id_ruang'];

			$hari = $_POST['hari'];

			$tanggal = $_POST['tanggal'];

			$jam = $_POST['jam'];

			$dp1 = $_POST['dosen_penguji1'];

			$dp2 = $_POST['dosen_penguji2'];

			$dp3 = $_POST['dosen_penguji3'];

			//echo"$id_sekarang";

			//echo"'$id_kelompok','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$hasil_id_jur[0]')";

			$que1 = mysql_query("SELECT id_kelompok FROM pkl_penjadwalan WHERE id_kelompok='$id_kelompok'");

			$que2 = mysql_query("SELECT id_ruang,hari,tanggal,jam FROM pkl_penjadwalan WHERE id_ruang='$id_ruang'");

			if($has_que1 = mysql_fetch_array($que1)){

				echo"Kelompok sudah terdaftar";

			}

			else if($has_que2 = mysql_fetch_array($que2)){

				echo"jadwal bentrok";

			}

			else{

				$perintah = "INSERT INTO pkl_penjadwalan VALUES ('$id_jadwal','$id_kelompok','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$hasil_id_jur[0]')";

				mysql_query($perintah);

				

				$qwe=mysql_query("SELECT nim from pkl_peserta where id_kelompok=$id_kelompok");

				while($qw=mysql_fetch_array($qwe)){

					$perintah = "INSERT INTO pkl_beritaacra (id_jdwal,id_kelompok,nilai1,nilai2,nilai3,nilai_akhir,nim) VALUES ('$id_jadwal','$id_kelompok',0,0,0,0,'$qw[nim]')";

					mysql_query($perintah);

				}

				//cek dosen 1

				$perintah_cek_dp1 = "SELECT * FROM pkl_jmlmengujidsn WHERE nip='$dp1'";

				$jalankan_cek_dp1 = mysql_query($perintah_cek_dp1);

				

				if($hasil_cek_dp1 = mysql_fetch_array($jalankan_cek_dp1)){

					$akhir_jml_menguji = $hasil_cek_dp1[2]+1;

					$perintah_update_dp1 = "UPDATE pkl_jmlmengujidsn SET jumlahmenguji='$akhir_jml_menguji' WHERE nip='$dp1'";

					mysql_query($perintah_update_dp1);

				}

				else{

					$perintah_cek_inc = "SELECT max(id) FROM pkl_jmlmengujidsn";

					$jalankan_cek_inc = mysql_query($perintah_cek_inc);

					$hasil_cek_inc = mysql_fetch_array($jalankan_cek_inc);

					$auto_inc = $hasil_cek_inc[0]+1;

					

					echo"$auto_inc";

					$perintah_insert_dp1 = "INSERT INTO pkl_jmlmengujidsn VALUES ('$auto_inc','$dp1','1','$hasil_id_jur[0]')";

					mysql_query($perintah_insert_dp1);

				}

				

				//cek dosen 2

				$perintah_cek_dp2 = "SELECT * FROM pkl_jmlmengujidsn WHERE nip='$dp2'";

				$jalankan_cek_dp2 = mysql_query($perintah_cek_dp2);

				

				if($hasil_cek_dp2 = mysql_fetch_array($jalankan_cek_dp2)){

					$akhir_jml_menguji = $hasil_cek_dp2[2]+1;

					$perintah_update_dp2 = "UPDATE pkl_jmlmengujidsn SET jumlahmenguji='$akhir_jml_menguji' WHERE nip='$dp2'";

					mysql_query($perintah_update_dp2);

				}

				else{

					$perintah_cek_inc = "SELECT max(id) FROM pkl_jmlmengujidsn";

					$jalankan_cek_inc = mysql_query($perintah_cek_inc);

					$hasil_cek_inc = mysql_fetch_array($jalankan_cek_inc);

					$auto_inc = $hasil_cek_inc[0]+1;

					

					echo"$auto_inc";

					$perintah_insert_dp2 = "INSERT INTO pkl_jmlmengujidsn VALUES ('$auto_inc','$dp2','1','$hasil_id_jur[0]')";

					mysql_query($perintah_insert_dp2);

				}

				

				//cek dosen 3

				$perintah_cek_dp3 = "SELECT * FROM pkl_jmlmengujidsn WHERE nip='$dp3'";

				$jalankan_cek_dp3 = mysql_query($perintah_cek_dp3);

				

				if($hasil_cek_dp3 = mysql_fetch_array($jalankan_cek_dp3)){

					$akhir_jml_menguji = $hasil_cek_dp3[2]+1;

					$perintah_update_dp3 = "UPDATE pkl_jmlmengujidsn SET jumlahmenguji='$akhir_jml_menguji' WHERE nip='$dp3'";

					mysql_query($perintah_update_dp3);

				}

				else{

					$perintah_cek_inc = "SELECT max(id) FROM pkl_jmlmengujidsn";

					$jalankan_cek_inc = mysql_query($perintah_cek_inc);

					$hasil_cek_inc = mysql_fetch_array($jalankan_cek_inc);

					$auto_inc = $hasil_cek_inc[0]+1;

					

					echo"$auto_inc";

					$perintah_insert_dp3 = "INSERT INTO pkl_jmlmengujidsn VALUES ('$auto_inc','$dp3','1','$hasil_id_jur[0]')";

					mysql_query($perintah_insert_dp3);

				}

				

				echo"<center>Data berhasil disimpan<br>Kembali ke <big><a href='?syxec=pkjadwalujian'>INDEX</a></big></center>";

			}

		break;

		

		case('ubah'):

			$id_jadwal = $_POST['id_jadwal'];

			$id_kelompok = $_POST['id_kelompok'];

			$id_ruang = $_POST['id_ruang'];

			$hari = $_POST['hari'];

			$tanggal = $_POST['tanggal'];

			$jam = $_POST['jam'];

			$dp1 = $_POST['dosen_penguji1'];

			$dp2 = $_POST['dosen_penguji2'];

			$dp3 = $_POST['dosen_penguji3'];

			

			$perintah = "UPDATE pkl_penjadwalan SET id_jdwal='$id_jadwal', id_kelompok='$id_kelompok',id_ruang='$id_ruang',hari='$hari',tanggal='$tanggal',jam='$jam',penguji1='$dp1',penguji2='$dp2',penguji3='$dp3' WHERE id_jdwal='$id_jadwal'";

			mysql_query($perintah);

			echo"<center>Data berhasil diubah<br>Kembali ke <big><a href='?syxec=pkjadwalujian'>INDEX</a></big></center>";

		break;

		

		case('hapus'):

			$id_ne=$_GET['id'];

			$perintah = "DELETE FROM pkl_penjadwalan WHERE id_jdwal = '$id_ne'";

			$del_berita_acara = "DELETE FROM pkl_beritaacra WHERE id_jdwal = '$id_ne'";

			mysql_query($perintah);

			mysql_query($del_berita_acara);

			echo"<center>Data berhasil dihapus<br>Kembali ke <big><a href='?syxec=pkjadwalujian'>INDEX</a></big></center>";

		break;

	}

?>