kojadwal.php | searchcode

/sysfo/kojadwal.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 425 lines | 423 code | 2 blank | 0 comment | 1 complexity | cd36db16e591bae15f2d95a795b3b41a MD5 | raw file

<style type="text/css">

th{

  background-color:#e6f0a3;

 -moz-border-radius-topleft:5px;

 -moz-border-radius-topright:5px;

 -webkit-border-top-right-radius:5px;

 -webkit-border-top-left-radius:5px;

 color:black;

 font-family:calibri;

 font-size:13px;

 padding:5px 0px 5px 0px;

}

.a td{

  font-family: calibri;

  font-size:13px;

  cursor:crosshair;

  background-color: #F1F5D7;

  padding-left: 5px;

  

}

td:hover{

    background-color:#ffffff;

}



</style>

<script type="text/javascript">

 function konfirmasi(x){

  if (confirm('Yakin ingin menghapus data dengan nim "'+x+"\"?")){

      return true;

  }

  else{

      return false;

  }

}

</script>

<?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:

				echo "

					<form method='post' action='' class='a'>

						<table width=960 align='center'>";

							

                                                      if($level=='Karyawan Jurusan'){ 

								echo "<tr><td colspan='13' align='left'>

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

								</td></tr>";}

							echo"</tr>

							<tr>

								<th>ID</th>

								<th>NIM</th>

								<th>Nama</th>

								<th>Tanggal</th>

								<th>Jam</th>

								<th>Ruang</th>

								<th>Dosen Penguji 1</th>

								<th>Dosen Penguji 2</th>

								<th>Dosen Penguji 3</th>";

                      if($level=='Karyawan Jurusan'){

								echo "<th>Aksi</th>";

                                                                

                                                                }

							echo "</tr>";

                $no=1;

                $perintah = mysql_query("SELECT d.id_jadwal, d.nim, a.Name, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3

                FROM mhsw a, ko_peserta b, ruang c , ko_penjadwalan d 

                WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$kode'

                ORDER BY d.id_jadwal ASC");

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

                        echo"

                                <tr>

                                        <td>$no</td>

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

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

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

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

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

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

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

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

                        if($level=='Karyawan Jurusan'){

                                        echo "<td><a href='?syxec=$form&aksi=ubah&id=$hasil[0]'>Edit</a> | 

                                    <a href='?syxec=$form&aksi=hapus&id=$hasil[0]' onclick=\"return konfirmasi('$hasil[1]')\">Hapus</a></td>";}

                                echo "<tr>";

                        $no++;

echo"</table></form>";

}

	

		break;



		case('tambah'):

			echo "

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

					<table align='center' class='a'>

                                                <tr><th colspan=2>Form Penjadwalan</th></tr>

                                                        <tr>

							<td>

								<label>Nama</label>

							</td>

							<td>

								: 

								<select name='nim'>

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

										$perintah_nama = "SELECT a.nim,b.Name FROM ko_peserta a,mhsw b WHERE a.nim=b.NIM AND b.KodeJurusan='$kode'";

										$jalan_nama = mysql_query($perintah_nama);

										while($hasil_nama = mysql_fetch_array($jalan_nama)){

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

										}

								echo "</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>Ruang</label>

							</td>

							<td>

								: 

								<select name='id_ruang'>

									<option value='0' selected>- 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>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='$kode' 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='$kode' 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='$kode' 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'):

                $nim = $_POST['nim'];

		$id_ruang = $_POST['id_ruang'];

		$tanggal = $_POST['tanggal'];

                $jam = $_POST['jam'];

		$dp1 = $_POST['dosen_penguji1'];

		$dp2 = $_POST['dosen_penguji2'];

		$dp3 = $_POST['dosen_penguji3'];		

		$Q=mysql_query("SELECT  nim FROM ko_penjadwalan");

		$nC = 0;

		while($R=mysql_fetch_array($Q)){

				if($R[0]==$nim){

					$nC = 1;

					break;

				}

		}

		$Q=mysql_query("SELECT  hari, tanggal, jam FROM skr_penjadwalan");

		$iC = 0;

		while($R=mysql_fetch_array($Q)){

				if($R[0]==$hari&&$R[1]==$tanggal&&$R[2]==$jam){

					$iC = 1;

					break;

				}

		}

		

		if($iC != 1 && $nC != 1 && $dp1 != $dp2 && $dp1 != $dp3  && $dp2 != $dp3){

				mysql_query("INSERT INTO ko_penjadwalan VALUES ('','$nim','$id_ruang','$tanggal','$jam','$dp1','$dp2','$dp3')");

				$q = mysql_query("SELECT id_jadwal FROM ko_penjadwalan WHERE nim=$nim");

				$h = mysql_fetch_array($q);

				mysql_query("INSERT INTO ko_beritaacara VALUES ('','$h[id_jadwal]','$nim',0,0,0,0,'null')");

				echo"<center>Data berhasil disimpan<br>Kembali ke <big><a href='?syxec=$form'><blink>List Data</blink></a></big></center>";

		}

		else{

			echo("<center>Jadwal <big>Bentrok</big> atau <big>Dosen Penguji ada yang sama</big><br>Kembali ke <big><a href='?syxec=$form&aksi=tambah'><blink>Form Tambah Jadwal</blink></a></big></center>");

		}

		break;

		

		case('edit'):

                    echo("mlaku");

		$id= $_GET['id'];

			$nim = $_POST['nim'];

			$id_ruang = $_POST['id_ruang'];

			$tanggal = $_POST['tanggal'];

			$jam = $_POST['jam'];

			$dp1 = $_POST['dosen_penguji1'];

			$dp2 = $_POST['dosen_penguji2'];

			$dp3 = $_POST['dosen_penguji3'];

			//echo"'$nim','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$dp4')";

		mysql_query("UPDATE ko_penjadwalan SET id_ruang='$id_ruang',tanggal='$tanggal',jam='$jam',penguji1='$dp1',penguji2='$dp2',penguji3='$dp3' WHERE id_jadwal='$id'");

				echo"<center>Data berhasil diubah<br>Kembali ke <big><a href='?syxec=$form'><blink>List Data</blink></a></big></center>";

		break;

            

		case "ubah";

			$id=$_GET['id'];

			echo "

				<form method='post' action='?syxec=$form&aksi=edit&id=$id' class='a'>

					<table align='center'>

						<tr><th colspan=2>Edit Jadwal</th></tr>

						<tr>

							<td>

								<label>Nama</label>

							</td>

							<td>

							";

							$query = "SELECT a.Name FROM mhsw a, ko_penjadwalan b WHERE a.NIM=b.nim AND b.id_jadwal=$id";

							$result=mysql_query($query);

							$hasil=mysql_fetch_array($result);

							echo(": ".$hasil[0]);

							

							echo "</td>

						</tr>

						<tr>

							<td>

								<label>Tanggal</label>

							</td>

							<td>

							";

							$query = "SELECT tanggal, jam FROM ko_penjadwalan WHERE id_jadwal=$id";

							$result=mysql_query($query);

							$hasil=mysql_fetch_array($result);

							echo"

								: <input type='text' name='tanggal' value='$hasil[0]'/>

							</td>

						</tr>

						<tr>

							<td>

								<label>Jam</label>

							</td>

							<td>

								: <input type='text' name='jam' value='$hasil[1]' />

							</td>

						</tr>

						<tr>

							<td>

								<label>Ruang</label>

							</td>

							<td>

								: 

								<select name='id_ruang'>

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

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

										$jalan = mysql_query($perintah);

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

											$query=mysql_query("SELECT id_ruang FROM ko_penjadwalan WHERE id_jadwal=$id");

											$shadow=mysql_fetch_array($query);

											if($shadow[0]==$hasil[0]){

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

											}

											else{

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

											}

										}

								echo "</select>

							</td>

						</tr>

						<tr>

							<td>

								<label>Dosen Penguji 1</label>

							</td>

							<td>: 

								<select name='dosen_penguji1'>

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

										$perintah = mysql_query("SELECT ID,Name FROM dosen WHERE kodejurusan='$kode' ORDER BY ID");

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

											$query=mysql_query("SELECT penguji1 FROM ko_penjadwalan WHERE id_jadwal=$id");

											$h=mysql_fetch_array($query);

											if($h[0]==$hasil[0]){

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

											}

											else{

												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 = mysql_query("SELECT ID,Name FROM dosen WHERE kodejurusan='$kode' ORDER BY ID");

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

											$query=mysql_query("SELECT penguji2 FROM ko_penjadwalan WHERE id_jadwal=$id");

											$h=mysql_fetch_array($query);

											if($h[0]==$hasil[0]){

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

											}

											else{

												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 = mysql_query("SELECT ID,Name FROM dosen WHERE kodejurusan='$kode' ORDER BY ID");

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

											$query=mysql_query("SELECT penguji3 FROM ko_penjadwalan WHERE id_jadwal=$id");

											$h=mysql_fetch_array($query);

											if($h[0]==$hasil[0]){

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

											}

											else{

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

											}

										}

								echo "</select>

							</td>

						</tr>

					

						<tr>

							<td colspan='2' align='center'>

								<input type='submit' name='submit' value='Ubah' />

							</td>

						</tr>

					</table>

				</form>

			";

		

		break;

		case('hapus'):

		$id = $_GET['id'];

		mysql_query("DELETE FROM ko_penjadwalan WHERE id_jadwal = '$id'");

		mysql_query("DELETE FROM ko_beritaacara WHERE id_jadwal = '$id'");

		echo"<center>Data berhasil dihapus<br>Kembali ke <big><a href='?syxec=$form'><blink>List Data</blink></a></big></center>";

		break;

	}

?>