prjdwlpengawasuas.php

/sysfo/prjdwlpengawasuas.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 309 lines | 269 code | 31 blank | 9 comment | 3 complexity | c37064177c7643e7ba491f0678263549 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>";



	//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 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>";



	switch($_GET['aksi']){

		default:

			if($a=="Kajur"){

				echo "

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

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



								<tr>



									<th>No</th>

									<th>Hari</th>

									<th>Tanggal</th>

									<th>Jam mulai</th>

									<th>Jam selesai</th>

									<th>Pengawas 1</th>

									<th>Pengawas 2</th>

									<th>Kelas</th>

									<th>Mata kuliah</th>

									<th>Semester</th>

									<th>Ruang</th>

									<th>Aksi</th>

								</tr>

								";

									//$perintah = "SELECT * FROM jadwal WHERE KodeJurusan='$hasil_id_jur[0]' order by Hari";

                                    $perintah="SELECT a.ID, b.Nama, a.UASTanggal,a.UASMulai, a.UASSelesai, a.pengawasuas1, a.pengawasuas2, a.Kelas, a.NamaMK, a.semester, a.UASRuang  FROM jadwal a, hari b WHERE a.KodeJurusan='$hasil_id_jur[0]' and a.Hari=b.ID";

									$jalan = mysql_query($perintah);

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

										echo"



											<tr>

											    <td>$hasil[0]</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>

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

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





												";



												echo"

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

											<tr>

										";

									}

								echo"

							</table>

						</form>

					";

			}

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

				echo "

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

						<tr>

							<th>No</th>

																<th>Hari</th>

																<th>Tanggal</th>

																<th>Jam mulai</th>

																<th>Jam selesai</th>

																<th>Pengawas 1</th>

																<th>Pengawas 2</th>

																<th>Kelas</th>

																<th>Mata kuliah</th>

																<th>Semester</th>

																<th>Ruang</th>





						</tr>";

                $perintah="SELECT a.ID, b.Nama, a.UASTanggal,a.UASMulai, a.UASSelesai, a.pengawasuas1, a.pengawasuas2, a.Kelas, a.NamaMK, a.semester, a.UASRuang  FROM jadwal a, hari b WHERE a.KodeJurusan='$hasil_id_jur[0]' and a.Hari=b.ID";



								$jalan = mysql_query($perintah);

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

                                    echo"



                                    <tr>

                                    									    <td>$hasil[0]</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>

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

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



                                    												";



                                    echo"



                                    <tr>

                                    ";

								}

						echo"

					</table>

					</form>

				";

			}



		break;







		case('edit'):

			$id_ne=$_GET['id'];

            $perintah="SELECT a.ID, b.Nama, a.UASTanggal,a.UASMulai, a.UASSelesai, a.pengawasuas1, a.pengawasuas2, a.Kelas, a.NamaMK, a.semester, a.UASRuang  FROM jadwal a, hari b WHERE a.ID='$id_ne' and a.Hari=b.ID";

			$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</label>

            					     </td>

            					     <td>

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

            					       </td>

            					   </tr>

            						<tr>

            						  <td>

            						<label>Hari</label>

            						   </td>

            						    <td>

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

            						            							</td>

            						            						</tr>



            						<tr>

            							<td>

            								<label>Tanggal</label>

            							</td>

            							<td>

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

            							</td>

            						</tr>

            						<tr>

            						            							<td>

            						 <label>Jam Mulai</label>

            						            							</td>

            						            							<td>

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

            						            							</td>

            						            						</tr>

            						  <tr>

            						  <td>

            						 <label>Jam Selesai</label>

            						   </td>

            						      <td>

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

            						     </td>

            						   </tr>

            						<tr>

            							<td>

            								<label>Pengawas 1</label>

            							</td>

            							<td>

            								:

            								<select name='pengawas1'>

            									<option value='0' selected>- Pilih Dosen Pengawas -</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='pengawas1' value=$hasil[0]>$hasil[1]</option>";

            										}

            								echo "</select>

            							</td>

            						</tr>

            						<tr>

            							<td>

            								<label>Pengawas 2</label>

            							</td>

            							<td>

            								:

            								<select name='pengawas2'>

            									<option value='0' selected>- Pilih Dosen Pengawas -</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='pengawas2' value=$hasil[0]>$hasil[1]</option>";

            										}

            								echo "</select>

            							</td>

            						</tr>

            						<tr>

            						<td>

            						<label>Kelas</label>

            						</td>

            								<td>

            								: <input type='text' name='kelas' value='$hasil_cari[7]'/>

            								</td>

            						</tr>

            						<tr>

            						            							<td>

            						  <label>Mata Kuliah</label>

            						            							</td>

            						            							<td>

            						: <input type='text' name='matakuliah' value='$hasil_cari[8]'/>

            						            							</td>

            						            						</tr>

                            <tr>

                                        <td>

                                  <label>Semester</label>

                                        						            							</td>

                                        						            							<td>

                                    : <input type='text' name='semester' value='$hasil_cari[9]'/>

                                        						            							</td>

                                        						            						</tr>

                                <tr>

                    			<td>

                    			<label>Ruang UAS</label>

                    			</td>

                						<td>

                    						:

                    						<select name='ruang'>

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

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



                    			$jalan = mysql_query($perintah);

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

                    			echo "<option name='ruang' 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('ubah'):

            $ID = $_POST['id'];

            $Tanggal = $_POST['tanggal'];

            			$jamMulai = $_POST['jammulai'];

            			$jamSelesai = $_POST['jamselesai'];

            			$pengawas1 = $_POST['pengawas1'];

            			$pengawas2 = $_POST['pengawas2'];

            		//	$semester = $_POST['semester'];

            		//	$Kelas = $_POST['kelas'];

            		//	$NamaMK = $_POST['matakuliah'];

            			$ruang = $_POST['ruang'];



			$perintah = "UPDATE jadwal SET UASTanggal='$Tanggal',UASMulai='$jamMulai',UASSelesai='$jamSelesai', pengawasuas1='$pengawas1',pengawasuas2='$pengawas2',UASRuang='$ruang' WHERE ID='$ID'";

			mysql_query($perintah);

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

		break;



		case('hapus'):

			$id_ne=$_GET['id'];

			$perintah = "DELETE FROM jadwal WHERE ID = '$id_ne'";

			mysql_query($perintah);

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

		break;

	}

?>