akinputnilai.php | searchcode

/sysfo/akinputnilai.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 276 lines | 246 code | 17 blank | 13 comment | 8 complexity | 17d9c849eea713f865a99df78b61a479 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:

		echo"

			<center>

				<form name='formnilai' method='post' action='?syxec=$form&aksi=cari'>

					<table>

						<tr>

							<td>NIP Dosen</td>

							<td> : </td>

							<td><input type='text' name='nip_dosen' value='$unip' readonly/></td>

						</tr>";

						$sel_mk = mysql_query("SELECT namamk from jadwal where iddosen='$unip'");

						$jal_mk = mysql_fetch_array($sel_mk);

						

						$sel_kd_mk = mysql_query("SELECT kode FROM matakuliah WHERE nama_indonesia='$jal_mk[0]'");

						$jal_kd_mk = mysql_fetch_array($sel_kd_mk);

						echo"

						<tr>

							<td>Matakuliah</td>

							<td> : </td>

							<td><input type='hidden' name='kd_mk' value='$jal_kd_mk[0]'/><input type='text' name='nama_mk' value='$jal_mk[0]' readonly/></td>

						</tr>";

						$sel_kls = mysql_query("SELECT id,kelas FROM kelas ORDER BY id");

						echo"

						<tr>

							<td>Kelas</td>

							<td> : </td>

							<td>

							<select name='kelas'>

								<option value='0'>.:: Pilih ::.</option>";

								while($jal_kls = mysql_fetch_array($sel_kls)){

									echo"

										<option value='$jal_kls[0]'>$jal_kls[1]</option>";

								}

								echo"

							</selected></td>

						</tr>

						<tr>

							<td><input type='submit' name='Submit' value='Cari'/></td>

						</tr>

					</table>

				</form>

			</center>

		";

	break;

	

	case 'cari':

		$nip = $_POST['nip_dosen'];

		$matkul = $_POST['kd_mk'];

		$kelas = $_POST['kelas'];

		

		$qwe = mysql_query("SELECT id FROM jadwal WHERE iddosen='$nip' and kodemk='$matkul' and kelas='$kelas'");

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"SELECT id FROM jadwal WHERE iddosen='$nip' and kodemk='$matkul' and kelas='$kelas' <br>";

		$jal = mysql_fetch_array($qwe);

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"id = $jal[0] <br>";

		$qwe2 = mysql_query("SELECT id,nim,namamk,sks,hadir,tugas1,tugas2,tugas3,tugas4,tugas5,nilaimid,nilaiujian,nilai,gradenilai,bobot FROM krs WHERE idjadwal='$jal[0]' ORDER BY id ASC");

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"SELECT id,nim,namamk,sks,hadir,tugas1,tugas2,tugas3,tugas4,tugas5,nilaimid,nilaiujian,nilai,gradenilai,bobot FROM krs WHERE idjadwal='$jal[0]'";

		if($jal[0]==0){

			echo"

			<center>

				<table border='1'>

				<tr>

					<th>ID</th>

					<th>NIM</th>

					<th>Nama MK</th>

					<th>SKS</th>

					<th>Hadir</th>

					<th>Tugas 1</th>

					<th>Tugas 2</th>

					<th>Tugas 3</th>

					<th>Tugas 4</th>

					<th>Tugas 5</th>

					<th>Nilai Mid</th>

					<th>Nilai Ujian</th>

					<th>Nilai</th>

					<th>Grade Nilai</th>

					<th>Bobot</th>

					<th>Aksi</th>

				</tr>

			<center>";

		}

		else{

			while($jal2 = mysql_fetch_array($qwe2)){

				echo"

				<center>

				<table border='1'>

				<tr>

					<th>ID</th>

					<th>NIM</th>

					<th>Nama MK</th>

					<th>SKS</th>

					<th>Hadir</th>

					<th>Tugas 1</th>

					<th>Tugas 2</th>

					<th>Tugas 3</th>

					<th>Tugas 4</th>

					<th>Tugas 5</th>

					<th>Nilai Mid</th>

					<th>Nilai Ujian</th>

					<th>Nilai</th>

					<th>Grade Nilai</th>

					<th>Bobot</th>

					<th>Aksi</th>

				</tr>

				<tr>

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

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

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

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

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

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

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

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

					<td>$jal2[8]</td>

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

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

					<td>$jal2[11]</td>

					<td>$jal2[12]</td>

					<td>$jal2[13]</td>

					<td>$jal2[14]</td>

					<td><a href=?syxec=$form&aksi=edit&id=$jal2[0]>Edit</a></td>

				</tr>

				";

			}

		}

					echo"

				</table>

			</center>

		";

	break;

	

	case'edit';

		$idne = $_GET['id'];

		$kode = $_GET['$jal[0]'];

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"$idne";



		$qwe3 = mysql_query("SELECT id,nim,namamk,sks,hadir,tugas1,tugas2,tugas3,tugas4,tugas5,nilaimid,nilaiujian,nilai,gradenilai,bobot FROM krs WHERE id='$idne'");

		$jal3 = mysql_fetch_array($qwe3);

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"SELECT id,nim,namamk,sks,hadir,tugas1,tugas2,tugas3,tugas4,tugas5,nilaimid,nilaiujian,nilai,gradenilai,bobot FROM krskonv WHERE idjadwal='$jal[0]' and id='$idne'";

		

		echo"

			<center>

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

					<table>

						<tr>

							<td>ID</td>

							<td><input type='text' name='id' value='$jal3[0]' readonly/></td>

						</tr>

						<tr>

							<td>NIM</td>

							<td><input type='text' name='nim' value='$jal3[1]' readonly/></td>

						</tr>

						<tr>

							<td>Nama MK</td>

							<td><input type='text' name='nama_mk' value='$jal3[2]' readonly/></td>

						</tr>

						<tr>

							<td>SKS</td>

							<td><input type='text' name='sks' value='$jal3[3]' readonly/></td>

						</tr>

						<tr>

							<td>Hadir</td>

							<td><input type='text' name='hadir' value='$jal3[4]'/></td>

						</tr>

						<tr>

							<td>Tugas 1</td>

							<td><input type='text' name='tugas1' value='$jal3[5]'/></td>

						</tr>

						<tr>

							<td>Tugas 2</td>

							<td><input type='text' name='tugas2'value='$jal3[6]'/></td>

						</tr>

						<tr>

							<td>Tugas 3</td>

							<td><input type='text' name='tugas3' value='$jal3[7]'/></td>

						</tr>

						<tr>

							<td>Tugas 4</td>

							<td><input type='text' name='tugas4' value='$jal3[8]'/></td>

						</tr>

						<tr>

							<td>Tugas 5</td>

							<td><input type='text' name='tugas5' value='$jal3[9]'/></td>

						</tr>

						<tr>

							<td>Nilai MID</td>

							<td><input type='text' name='nilai_mid' value='$jal3[10]'/></td>

						</tr>

						<tr>

							<td>Nilai Ujian</td>

							<td><input type='text' name='nilai_ujian' value='$jal3[11]'/>

						</tr>

						<tr>

							<td><input type='button' onclick=window.location.href='?syxec=$form' name='kembali' value='Kembali'/></td>

							<td><input type='submit' name='Submit' value='Simpan'/></td>

						</tr>

					</table>

				</form>

			</center>

		";

	break;

	

	case'update';

		$id = $_POST['id'];

		$nim = $_POST['nim'];

		$nama_mk = $_POST['nama_mk'];

		$sks = $_POST['sks'];

		$hadir = $_POST['hadir'];

		$tugas1 = $_POST['tugas1'];

		$tugas2 = $_POST['tugas2'];

		$tugas3 = $_POST['tugas3'];

		$tugas4 = $_POST['tugas4'];

		$tugas5 = $_POST['tugas5'];

		$nilai_mid = $_POST['nilai_mid'];

		$nilai_ujian = $_POST['nilai_ujian'];

		$rata2 = ($hadir+$tugas1+$tugas2+$tugas3+$tugas4+$tugas5+$nilai_mid+$nilai_ujian)/8;

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"$rata2 <br>";

		$tes = mysql_query("SELECT nilai,bobot FROM nilai WHERE kode='s2' and $rata2<=batasatas and $rata2>=batasbawah");

		$jal_test = mysql_fetch_array($tes);

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"SELECT nilai,bobot FROM nilai WHERE kode='umum' and $rata2<=batasatas and $rata2>=batasbawah <br> $jal_test[0] || $jal_test[1]";

		

		$upd = mysql_query("UPDATE krs SET hadir='$hadir', tugas1='$tugas1', tugas2='$tugas2', tugas3='$tugas3',  tugas4='$tugas4', tugas5='$tugas5',  nilaimid='$nilai_mid', nilaiujian='$nilai_ujian', nilai='$rata2', gradenilai='$jal_test[0]', bobot='$jal_test[1]' WHERE id='$id'");

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"<br>UPDATE krs SET hadir='$hadir', tugas1='$tugas1', tugas2='$tugas2', tugas3='$tugas3',  tugas4='$tugas4', tugas5='$tugas5',  nilaimid='$nilai_mid', nilaiujian='$nilai_ujian', nilai='$rata2', gradenilai='$jal_test[0]', bobot='$jal_test[1]' WHERE id='$id'";

		

		$qwe=mysql_query("SELECT Tahun FROM krs Where ID=$id");

		$qw=mysql_fetch_array($qwe);

		

		$sks=0;

		$nilai=0;

		$qwe2=mysql_query("SELECT SKS , Nilai FROM KRS WHERE nim=$nim and Tahun=$qw[Tahun]");

		//echo "SELECT SKS , Nilai FROM KRS WHERE nim=$nim and Tahun=$qw[Tahun]";

		while($row=mysql_fetch_array($qwe2)){

			$sks+=$row['SKS'];

			$nilai+=($row['Nilai']*$row['SKS']);

		}

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"NILAI DAN SKS == $nilai || $sks <br>";

		

		$nilaiAkhir=$nilai/$sks;

		$test1 = mysql_query("SELECT nilai,bobot FROM nilai WHERE kode='umum' and $nilaiAkhir<=batasatas and $nilaiAkhir>=batasbawah");

		$jal_test1 = mysql_fetch_array($test1);

		

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"KONVERSI NILAI AKHIR == nilai akhir = $nilaiAkhir || grade = $jal_test1[0] || bobot = $jal_test1[1]";

		

		$upd_khs = mysql_query("UPDATE khs SET nilai='$nilaiAkhir',gradenilai='$jal_test1[0]',bobot='$jal_test1[1]' WHERE nim='$nim' AND Tahun='$qw[Tahun]'");

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"<br>UPDATE khs SET nilai='$nilaiAkhir',gradenilai='$jal_test1[0]',bobot='$jal_test1[1]' WHERE nim='$nim' AND Tahun='$qw[Tahun]";

		//>>>>>>>>>>>>>>>>>>>>>>>>>>>echo"Data berhasil diupdate<br>Kembali ke <a href='?syxec=$form'>INDEX";

	break;

}

?>