pekrsmhs.php | searchcode

/sysfo/pekrsmhs.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 376 lines | 311 code | 42 blank | 23 comment | 27 complexity | 436ac9ad12d5104f18b8a2312f8bccdd MD5 | raw file

<?php

$level = $_SESSION['level'];

$unim = $_SESSION['unim'];

$nim = $_SESSION['unip'];





function getTahun ($jur) {

	//tahun disamain sama nama di table tahun

	$sql_get_tahun = "SELECT * FROM tahun WHERE NotActive = 'N' AND KodeJurusan = '".$jur."'";

	//echo $sql_get_tahun;

	$query = mysql_query($sql_get_tahun);

	$kodeTahun = mysql_fetch_array($query);

	return $kodeTahun['Kode'];

	

}



function getNamaDosen($id) {

	$sql = "SELECT * FROM dosen WHERE ID = '$id'";

	$query = mysql_query($sql);

	$res = mysql_fetch_array($query);

	return $res['Name'];

}

// Check Uda input krs apa belum

function checkKrs($nim,$tahun) {

	$uda = FALSE;

	$sql_check_uda_krs = "SELECT * FROM khs WHERE Tahun = '".$tahun."' AND NIM = '".$nim."'";

	//echo $sql_check_uda_krs;

	//echo $tahun;

	$query = mysql_query($sql_check_uda_krs);

	$row = mysql_num_rows($query);

	//echo $row;

	if ($row == 0) {

    	$uda = FALSE;

	} else {

    	$uda = TRUE;

	}

	return $uda;

}

function getMaxSKS($nim) {

	return 22;

}



function classIsNotFull($jadwal) {

	//$r = FALSE;

	$sql = "SELECT KapasitasKelas FROM jadwal WHERE ID = ".$jadwal;

	$query = mysql_query($sql);

	$res = mysql_fetch_array($query);

	//echo $sql."<br/>";

	//echo $res['KapasitasKelas']."<br/>";

	return $res['KapasitasKelas'];

	

}



function prasyaratTerpenuhi($nim,$jadwal) {

	return TRUE;

}



function belumAmbilAtoLulus($nim,$jadwal) {

	return TRUE;

}



function kelasBelumDiambil($nim,$jadwal) {

	$sql = "SELECT * FROM _krs WHERE NIM = '$nim' AND IDJadwal = '$jadwal'";

	//echo $sql;

	

	$query = mysql_query($sql);

	$row = mysql_num_rows($query);

	//echo $row;

	

	if ($row == 0) {

		$kembali = TRUE;

	} else {

		$kembali = FALSE;

	}

	//var_dump($kembali);

	return $kembali;

}



function sksCukup($nim,$jadwal) {

	$sql_getJadwal = "SELECT * FROM jadwal WHERE ID = '".$jadwal."'";

	$query = mysql_query($sql_getJadwal);

	$getJadwal = mysql_fetch_array($query);

	$sql_khs = "SELECT * FROM khs WHERE NIM = '$nim' AND Tahun = '".getTahun($getJadwal['KodeJurusan'])."'";

	//echo $sql_khs;

	$query = mysql_query($sql_khs);

	$res = mysql_fetch_array($query);

	$kembali = TRUE;

	if (($res['SKS'] + $getJadwal['SKS'] ) > $res['MaxSKS']) {

		$kembali = FALSE;

	}

	return $kembali;

}



function insertKrs($nim,$jadwal) {

	$sql_getJadwal = "SELECT * FROM jadwal WHERE ID = '".$jadwal."'";

	$query = mysql_query($sql_getJadwal);

	$getJadwal = mysql_fetch_array($query);

	$sql = "INSERT INTO _krs (NIM,Tahun,IDJadwal,KodeMK,NamaMK,IDDosen,SKS) 

	VALUES ('$nim','".getTahun($getJadwal['KodeJurusan'])."','".$jadwal."','".$getJadwal['KodeMK']."','".$getJadwal['NamaMK']."','".$getJadwal['IDDosen']."','".$getJadwal['SKS']."')";

	mysql_query($sql);	

}



function kurangiKapasitas($jadwal) {

	$sql = "UPDATE jadwal SET KapasitasKelas = KapasitasKelas - 1 WHERE ID = '".$jadwal."'";

	mysql_query($sql);

}



function tambahKapasitas($jadwal) {

	$sql = "UPDATE jadwal SET KapasitasKelas = KapasitasKelas + 1 WHERE ID = '".$jadwal."'";

	mysql_query($sql);

}



function tambahKrsYgDiambil($nim,$jadwal) {

	$sql_getJadwal = "SELECT * FROM jadwal WHERE ID = '".$jadwal."'";

	$query = mysql_query($sql_getJadwal);

	$getJadwal = mysql_fetch_array($query);

	$sql = "UPDATE khs SET SKS = SKS + ".$getJadwal['SKS']." WHERE NIM = '$nim' AND Tahun = '".getTahun($getJadwal['KodeJurusan'])."'";

	mysql_query($sql);

}



function kurangiKrsYgDiambil($nim,$jadwal) {

	$sql_getJadwal = "SELECT * FROM jadwal WHERE ID = '".$jadwal."'";

	$query = mysql_query($sql_getJadwal);

	$getJadwal = mysql_fetch_array($query);

	$sql = "UPDATE khs SET SKS = SKS - ".$getJadwal['SKS']." WHERE NIM = '$nim' AND Tahun = '".getTahun($getJadwal['KodeJurusan'])."'";

	mysql_query($sql);

}

$hari = array('Pilih Hari','Senin','Selasa','Rabu','Kamis','Jumat','Sabtu',);





	//select mahasiswa

	$per_mhs = "SELECT * FROM mhsw WHERE NIM = '$nim'";

	$jalankan = mysql_query($per_mhs);

	$hasil_mhs = mysql_fetch_array($jalankan);

		//nama jurusan

		$sql_bay_jurusan=mysql_query("SELECT * FROM jurusan WHERE Kode='$hasil_mhs[KodeJurusan]'");

		$tampil_bay_jurusan=mysql_fetch_array($sql_bay_jurusan);

		//nama dosen wali

		$sql_bay_dosen=mysql_query("SELECT Name FROM dosen WHERE ID='$hasil_mhs[DosenID]'");

		$tampil_bay_dosen=mysql_fetch_array($sql_bay_dosen);

		//tahun ajaran

		$sql_thajr=mysql_query("SELECT Nama From tahun WHERE NotActive='N' AND KodeJurusan='$hasil_mhs[KodeJurusan]' ");

		$tampil_thajr=mysql_fetch_array($sql_thajr);

	



?><html>

<head>	

	

</head>	





<body>

	<?php

	if (isset($_GET['act']) != '' AND $_GET['act'] == 'check') {

		if (!(checkKrs($_SESSION['unip'], getTahun($tampil_bay_jurusan['Kode'])))) {

			echo "belum";

			$sql_khs = "INSERT INTO khs (NIM,Tahun,MaxSKS) 

			VALUES ('".$_SESSION['unip']."','".getTahun($tampil_bay_jurusan['Kode'])."',".getMaxSKS($_SESSION['unip']).")";

			//echo $sql_khs;

			//echo $sql_khs;

			$query = mysql_query($sql_khs);			

		}

		//print_r($_POST['pilih']);

		//echo count($_POST['pilih']);

		foreach ($_POST['pilih'] as $item) {

			if (classIsNotFull($item) != '0') {

				if (prasyaratTerpenuhi($nim, $item)) {

					if (kelasBelumDiambil($nim, $item)) {

						if (sksCukup($nim, $item)) {

							insertKrs($nim, $item);

							kurangiKapasitas($item);

							tambahKrsYgDiambil($nim, $item);

						} else {

							echo "Maaf, SKS anda tidak mencukupi untuk mengambil mata kuliah ini<br/>";

						}

					} else {

						echo "Maaf, kelas dengan kode ".$item['ID']." sudah anda ambil<br/>";

					}

				} else {

					echo "Maaf, anda belum mengambil prasyarat matakuliah ini";

				}

			} else {

				echo "Maaf, kelas dengan kode ".$item['ID']." sudah penuh";

			}

		}

	} elseif (isset($_GET['act']) != '' AND $_GET['act'] == 'del') {

		$idkrs = $_GET['id'];

		$item = $_GET['item'];

		tambahKapasitas($item);

		kurangiKrsYgDiambil($nim, $item);

		$sql_del = "DELETE FROM _krs WHERE ID = '$idkrs'";

		mysql_query($sql_del);

	}

	?>

<fieldset>

	<legend>Pemrograman KRS</legend>

<div align="center"><strong>Pemrograman KRS (Kartu Rencana Studi) Mahasiswa </strong><br/>

  <center><strong> </center></strong>  <br/>

</div>



<br />



<table width="500" border="0"  bgcolor="#CCCCCC"align="center">

  <tr>

    <td bgcolor="#FFFFFF" width="179">Nama Mahasiswa </td>

    <td bgcolor="#FFFFFF" width="488">: <?php echo"$hasil_mhs[Name]";?></td>

  </tr>

  <tr>

    <td bgcolor="#FFFFFF">NIM</td>

    <td bgcolor="#FFFFFF">: <?php echo"$hasil_mhs[ID]";?> </td>

  </tr>

  <tr >

    <td bgcolor="#FFFFFF">Jurusan</td>

    <td bgcolor="#FFFFFF">: <?php echo"$tampil_bay_jurusan[Nama_Indonesia]";?></td>

  </tr>

  <tr>



    <td bgcolor="#FFFFFF">Dosen Wali </td>

    <td bgcolor="#FFFFFF">: <?php echo"$tampil_bay_dosen[Name]";?></td>

  </tr>

    <tr>

    <td bgcolor="#FFFFFF">Semester </td>

    <td bgcolor="#FFFFFF">: <?php echo"$hasil_mhs[Semester]";?></td>

  </tr>



  <tr>

    <td bgcolor="#FFFFFF">Tahun Ajaran</td>

    <td bgcolor="#FFFFFF">: <?php echo"$tampil_thajr[Nama]";?></td>

  </tr>

  

  <tr>

    <td bgcolor="#FFFFFF">SKS Maksimum</td>

    <td bgcolor="#FFFFFF">: <?php echo getMaxSKS($_SESSION['unip']) ?></td>

  </tr>

  </table>	



<br/>



<table align="center" width="1340" border="none" bgcolor="#FFFFFF" >



<form id="form1" name="form1" method="post" action="sysfo.php?syxec=pekrsmhs&act=check">

  <tr style="cursor: move">

  	<td bgcolor="FFCC00" width="45"> <div align="center" class="style3"><strong>Pilih</strong></div></td>

    <td bgcolor="#FFCC00" width="30" height="23" ><div align="center" class="style3"><strong>No</strong></div></td>

    <td bgcolor="#FFCC00" width="69"><div align="center" class="style3"><strong>Kode </strong></div></td>

    <td bgcolor="#FFCC00" width="229"><div align="center" class="style3"><strong>Matakuliah </strong></div></td>

    <td bgcolor="#FFCC00" width="30"><div align="center" class="style3"><strong>SKS </strong></div></td>

    <td bgcolor="#FFCC00" width="297"><div align="center" class="style3"><strong>Dosen </strong></div></td>    

    <td bgcolor="#FFCC00" width="60"><div align="center" class="style3"><strong>Hari</strong></div></td>

    <td bgcolor="#FFCC00" width="90"><div align="center" class="style3"><strong>Pukul</strong></div></td>

	<td bgcolor="#FFCC00" width="44"><div align="center" class="style3"><strong>Kelas</strong></div></td>

	<td bgcolor="#FFCC00" width="116"><div align="center" class="style3"><strong>Ruang</strong></div></td>

	<td bgcolor="#FFCC00" width="96"><strong><center>Jumlah Pertemuan</center></strong></td>

    <td bgcolor="#FFCC00" width="80"><strong><center>Mahasiswa Angkatan</center></strong></td>

    <td bgcolor="#FFCC00" width="82"><div align="center" class="style3"><strong><center>Kapasitas Kelas</center></strong></div></td>

	</tr>

	

	<?php

		$sql_jadwal=mysql_query("SELECT * FROM jadwal WHERE KodeJurusan='$hasil_mhs[KodeJurusan]'");

		while($tampil_jadwal = mysql_fetch_array($sql_jadwal)){	

			$sql_bay_dosen=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil_jadwal[IDDosen]'");

			$tampil_bay_dosen=mysql_fetch_array($sql_bay_dosen);

	?>

	<tr bgcolor=#F5F5F5 style="cursor: normal">

	<td align="center"><input name="pilih[]" type="checkbox" value="<?php echo"$tampil_jadwal[ID]";?>" /></td>

    <td align="center"> <?php echo"$tampil_jadwal[ID]";?> </td>

    <td ><center><?php echo"$tampil_jadwal[KodeMK]";?></center></td>

    <td><?php echo"$tampil_jadwal[NamaMK]";?></td>

	<td ><center><?php echo"$tampil_jadwal[SKS]";?></center></td>

	<td><?php echo"$tampil_bay_dosen[Name]";?></td> 

    <td><?php $a = $tampil_jadwal[Hari]; echo "$hari[$a]";?></td>

    <td ><center><?php echo"$tampil_jadwal[JamMulai]";?> - <?php echo"$tampil_jadwal[JamSelesai]";?></center></td>

	<td ><center><?php echo"$tampil_jadwal[Kelas]";?></center></td>

    <td ><center><?php echo"$tampil_jadwal[KodeRuang]";?></center></td>

	<td ><center>1X Pertemuan</center></td>

    <td ><center></center><?php echo"$hasil_mhs[TahunAkademik]";?></td>

    <td ><center><?php echo"$tampil_jadwal[KapasitasKelas]";?></center></td>

	</tr>

  	<?php } ?>

	</table>

<br/>	 

	<label>

		<center>		

			<input type="submit" name="submit" value="Submit">

		</center>

	</label>

</form>

</fieldset>		

<?php

//echo getTahun($tampil_bay_jurusan['Kode']);

if (checkKrs($_SESSION['unip'], getTahun($tampil_bay_jurusan['Kode']))) {

	echo "uda";

	$sql = "SELECT *,a.ID as test FROM _krs a,jadwal b WHERE a.NIM = '$nim' AND a.IDJadwal = b.ID";

	//echo $sql;

	$query = mysql_query($sql);

	?>

	<table border="1">

		<?php

		while ($r = mysql_fetch_array($query)) {

			?>

			<tr>

				<td><?php echo $r['IDJadwal'] ?></td>

				<td><?php echo $r['KodeMK']?></td>

				<td><?php echo $r['NamaMK']?></td>

				<td><?php echo $r['SKS']?></td>

				<td><?php echo getNamaDosen($r['IDDosen'])?></td>

				<td><?php $a = $r['Hari']; echo "$hari[$a]";?></td>

				<td><?php echo"$r[JamMulai]";?> - <?php echo"$r[JamSelesai]";?></td>

				<td><?php echo"$r[Kelas]";?></td>

    			<td><?php echo"$r[KodeRuang]";?></td>

				<td>1X Pertemuan</td>

    			<td><?php echo"$hasil_mhs[TahunAkademik]";?></td>

    			<td><a href="sysfo.php?syxec=pekrsmhs&act=del&id=<?php echo $r['test'] ?>&item=<?php echo $r['IDJadwal'] ?>">Hapus</a></td>

			</tr>

			<?php

		}

		?>

	</table>

	<a href="sysfo/pecetakkps.php?nim=<?php echo $nim ?>" target="_blank">Cetak KPS</a>

	<?php

} else {

	echo "belum";

}



?>	



</body>





<?php

if ($level == 'Dosen') {



?>

<body>

<fieldset>

	<legend>Rancangan KPS</legend>

<br />

<table align="center" width="1340" border="none" bgcolor="#FFFFFF" >

<form id="form1" name="form1" method="post" action="jurusan/#">

  <tr style="cursor: move">

  	<td bgcolor="#FFCC00" width="45"> <div align="center" class="style3"><strong>Pilih</strong></div></td>

    <td bgcolor="#FFCC00" width="30" height="23" ><div align="center" class="style3"><strong>No</strong></div></td>

    <td bgcolor="#FFCC00" width="69"><div align="center" class="style3"><strong>Kode </strong></div></td>

    <td bgcolor="#FFCC00" width="229"><div align="center" class="style3"><strong>Matakuliah </strong></div></td>

    <td bgcolor="#FFCC00" width="30"><div align="center" class="style3"><strong>SKS </strong></div></td>

    <td bgcolor="#FFCC00" width="270"><div align="center" class="style3"><strong>Dosen </strong></div></td>    

    <td bgcolor="#FFCC00" width="60"><div align="center" class="style3"><strong>Hari</strong></div></td>

    <td bgcolor="#FFCC00" width="90"><div align="center" class="style3"><strong>Pukul</strong></div></td>

	<td bgcolor="#FFCC00" width="44"><div align="center" class="style3"><strong>Kelas</strong></div></td>

	<td bgcolor="#FFCC00" width="116"><div align="center" class="style3"><strong>Ruang</strong></div></td>

  </tr>



	<tr bgcolor=#F5F5F5 style="cursor: normal">

	  	<tr bgcolor=#F5F5F5 style="cursor: normal">

	<td align="center"><input name="Pilih" type="checkbox" value="<?php echo"$tampil_jadwal[ID]";?>" /></td>

    <td align="center"> <?php echo"$tampil_jadwal[ID]";?> </td>

    <td ><center><?php echo"$tampil_jadwal[KodeMK]";?></center></td>

    <td><?php echo"$tampil_jadwal[NamaMK]";?></td>

	<td ><center><?php echo"$tampil_jadwal[SKS]";?></center></td>

	<td><?php echo"$tampil_bay_dosen[Name]";?></td> 

    <td><?php $a = $tampil_jadwal[Hari]; echo "$hari[$a]";?></td>

    <td ><center><?php echo"$tampil_jadwal[JamMulai]";?> - <?php echo"$tampil_jadwal[JamSelesai]";?></center></td>

	<td ><center><?php echo"$tampil_jadwal[Kelas]";?></center></td>

    <td ><center><?php echo"$tampil_jadwal[KodeRuang]";?></center></td>

	</tr>



</table>

<br />





</fieldset>	

</body>

<?php

}

?>

</html>