skdatapeserta.php | searchcode

/sysfo/skdatapeserta.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 244 lines | 231 code | 13 blank | 0 comment | 16 complexity | 5d1ef46b7977ce180f025bfe826f9271 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=='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=='Karyawan Jurusan'){

			echo"

				<form method='post' name='formskdatapeserta' action=''>

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

						<tr>

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

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

							</td>

						</tr>

						<tr>

							<th>No Reg</th>

							<th>NIM</th>

							<th>Judul</th>

							<th>Pembimbing</th>

							<th>Aksi</th>

						</tr>

						<tr>";

						$que_sel = mysql_query("SELECT * FROM skr_peserta");

						while($has_sel = mysql_fetch_array($que_sel)){

							echo"

								<td>$has_sel[no_reg]</td>

								<td>$has_sel[nim]</td>

								<td>$has_sel[judul]</td>

								<td>$has_sel[pembimbing]</td>

								<td><a href='?syxec=$form&aksi=edit&id=$has_sel[0]'>Edit</a> | <a href='?syxec=$form$aksi=hapus&id=$has_sel[0]'>Delete</a></td>

							";

						}

						echo"

						</tr>

					</table>

				</form>

			";

		}

		else{

			echo "

				<form method='post' name='formskdatapeserta' action=''>

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

						<tr>

							<th>No Reg</th>

							<th>NIM</th>

							<th>Judul</th>

							<th>Pembimbing</th>

						</tr>

						<tr>";

						$que_sel = mysql_query("SELECT * FROM skr_peserta");

						while($has_sel = mysql_fetch_array($que_sel)){

							echo"

								<td>$has_sel[no_reg]</td>

								<td>$has_sel[nim]</td>

								<td>$has_sel[judul]</td>

								<td>$has_sel[pembimbing]</td>

							";

						}

						echo"

						</tr>

					</table>

				</form>

			";

		}	

		break;

		

		case 'tambah':

		if($_POST['cari']=='cari'){

			$a = $_POST['nim'];

			$b = $_POST['judul_skripsi'];

			$c = $_POST['dosen_pembimbing'];

			if($a=="0"){

				echo"<center>Silahkan Pilih NIM</center>";

			}

			else{

				$qwe1 = mysql_query("SELECT nim FROM uj_beritaacara WHERE nim='$a' and terima_tidak='Y'");

				$has_cari1 = mysql_fetch_array($qwe1);

				

				$qwe3 = mysql_query("SELECT nim FROM skr_peserta WHERE nim='$has_cari1[0]'");

				if(mysql_num_rows($qwe3)){

					echo"<center>NIM sudah terdaftar</center>";

				}

				else{

					$qwe2 = mysql_query("SELECT nim,judul,acc_pembimbing FROM uj_peserta WHERE nim='$has_cari1[0]'");

					$has_cari2 = mysql_fetch_array($qwe2);	

				}

			}			

		}

		else if($_POST['submit']=='Simpan'){

			$ins_a = $_POST['no_reg'];

			$ins_b = $_POST['nim'];

			$ins_c = $_POST['judul_skripsi'];

			$ins_d = $_POST['dosen_pembimbing'];

			if($ins_a=="" ||$ins_b=="0" ||$ins_c=="" ||$ins_d==""){

				echo"Ada field kosong";

			}

			else{

				$que_ins = mysql_query("INSERT INTO skr_peserta VALUES ('$ins_a','$ins_b','$ins_c','$ins_d','0','0','0','0','0','N')");

			}

		}

		

			echo "

				<form method='post' name='formskpendaftaran' action='#'>

					<table align='center'>";

					

					$que = mysql_query("SELECT MAX(no_reg) FROM skr_peserta");

					$has = mysql_fetch_array($que);

					$auto = $has[0]+1;

					

					echo"

						<tr>

							<td><label> No Reg </label></td>

							<td> : <input type='text' name='no_reg' value='$auto' readonly/></td>

						</tr>

						<tr>

							<td><label> NIM </label></td>

							<td> : 

								<select name='nim'>

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

										$que = mysql_query("SELECT nim FROM uj_beritaacara");

										while($has = mysql_fetch_array($que)){

											echo "<option name='nim' value=$has[0] ";

												if($has[0]==$has_cari2[0]){

													echo"selected";

												}

											echo " >$has[0]</option>";

										}

								echo "</select>

								<td><input type='submit' name='cari' value='cari'/></td>

							</td>

						</tr>

						<tr>

							<td><label> Judul Skripsi </label></td>

							<td> : <input type='text' name='judul_skripsi' value='$has_cari2[1]' readonly/></td>

						</tr>

						<tr>

							<td><label> Dosen Pembimbing </label></td>

							<td> : <input type='text' name='dosen_pembimbing' value='$has_cari2[2]' readonly /></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'):

			$idne=$_GET['id'];

			echo"$idne";

			$que = mysql_query("SELECT * FROM skr_peserta WHERE no_reg='$idne'");

			$has = mysql_fetch_array($que);

			echo"

				<form name='fedit' method='post' action='?syxec=$form&aksi=update'>

					<table align='center'>

						<tr>

							<td><label> No Reg </label></td>

							<td> : <input type='text' name='no_reg' value='$has[no_reg]' readonly/></td>

						</tr>

						<tr>

							<td><label> NIM </label></td>

							<td> : 

								<select name='nim'>

									<option value='$has[nim]'>$has[nim]</option>";

										$que2 = mysql_query("SELECT nim FROM uj_beritaacara");

										while($has2 = mysql_fetch_array($que2)){

											echo "<option name='nim' value=$has2[0] ";

												if($has2[0]==$has[nim]){

													echo"selected";

												}

											echo " >$has2[0]</option>";

										}

								echo "</select>

								<td><input type='submit' name='cari' value='cari'/></td>

							</td>

						</tr>

						<tr>

							<td><label> Judul Skripsi </label></td>

							<td> : <input type='text' name='judul_skripsi' value='$has[judul]' readonly/></td>

						</tr>

						<tr>

							<td><label> Dosen Pembimbing </label></td>

							<td> : <input type='text' name='dosen_pembimbing' value='$has[pembimbing]' readonly /></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('hapus'):

			$idne=$_GET['id'];

			$qwe = mysql_query("DELETE FROM skr_peserta WHERE no_reg='$idne'");

			$jal = mysql_fetch_array($qwe);

			echo"<center>Data berhasil dihapus<br>kembali ke <a href='?syxec=$form'><b>INDEX</b></a></center>";

		break;

		

		case('update'):

			$upd_a = $_POST['no_reg'];

			$upd_b = $_POST['nim'];

			$upd_c = $_POST['judul_skripsi'];

			$upd_d = $_POST['dosen_pembimbing'];

			$idne=$_GET['id'];

			

			$qwe = mysql_query("UPDATE skr_peserta SET nim=$upd_b, judul=$upd_c,pembimbing=$upd_d WHERE no_reg=$upd_a");

			$jal = mysql_fetch_array($qwe);

			echo"<center>Data berhasil diubah<br>kembali ke <a href='?syxec=$form'><b>INDEX</b></a></center>";

		break;

	}	

?>