koberitaacara.php | searchcode

/sysfo/koberitaacara.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 206 lines | 189 code | 16 blank | 1 comment | 19 complexity | 0bcbf7517e68b713fed294c1d44b3f90 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>

<?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'){

	$query=mysql_query("select b.*,a.id_ba,a.*,(select name from mhsw where nim=a.nim) as nama,

            (select nama from ruang where kode=b.id_ruang) as ruang,

            (select pembimbing from skr_peserta where nim=a.nim) as nip_pembimbing,

            (select name from dosen where id=nip_pembimbing) as pembimbing from 

            ko_beritaacara a,ko_penjadwalan b where b.id_jadwal=a.id_jadwal

    

        ") or die(mysql_error());

       }

      else if($level=='Dosen'){

	$query=mysql_query("select b.*,a.id_ba,a.*,(select name from mhsw where nim=a.nim) as nama,

            (select nama from ruang where kode=b.id_ruang) as ruang,

            (select pembimbing from skr_peserta where nim=a.nim) as nip_pembimbing,

            (select name from dosen where id=nip_pembimbing) as pembimbing from 

            ko_beritaacara a,ko_penjadwalan b where b.id_jadwal=a.id_jadwal

        and (b.penguji1=$unip OR b.penguji2=$unip OR b.penguji3=$unip)    

        ") or die(mysql_error());

       }

	echo"	

	<center><h1>Berita Acara</h1></center>

	<table align='center' width='95%' class='a'>

		<tr>

			<th align='center'>No</th>

			<th align='center'>Tanggal</th>

			<th align='center'>Jam</th>

			<th align='center'>Tempat</th>

			<th align='center'>NIM</th>

			<th align='center'>Nama Mahasiswa</th>

			<th align='center'>Nilai 1</th>

			<th align='center'>Nilai 2</th>

			<th align='center'>Nilai 3</th>

			<th align='center'>Nilai Akhir</th>";

        if($level=='Dosen'){

			echo"<th align='center'>Aksi</th>";}

		echo"</tr>";

		$no=1;

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

			echo"

				<tr>

					<td align='center'>$no</td>

					<td align='center'>$b[tanggal]</td>

					<td align='center'>$b[jam]</td>

					<td align='center'>$b[ruang]</td>

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

					<td>$b[nama]</td>

					<td align='center'>$b[nilai1]</td>

					<td align='center'>$b[nilai2]</td>

					<td align='center'>$b[nilai3]</td>

					<td align='center'>$b[nilai_akhir]</td>";

                        if($level=='Dosen'){

					echo"<td align='center'><a href='?syxec=$form&aksi=input&nim=$b[nim]'>Input Nilai</a></td>";}

				echo"</tr>

			";

			$no++;

		}

		echo"

	</table>";

break;



case "input" :

	$query="SELECT a.id_jadwal, a.tanggal , a.jam ,(SELECT Nama from ruang where Kode=a.id_ruang) as ruang,b.nim, 

		(select name from mhsw where NIM=b.nim) as nama, a.penguji1 , a.penguji2 , a.penguji3 , 

		(Select Name from dosen where id=a.penguji1) as Penguji1 ,

		(Select Name from dosen where id=a.penguji2) as Penguji2,

		(Select Name from dosen where id=a.penguji3) as Penguji3, 

		c.nilai1 , c.nilai2 , c.nilai3 ,c.nilai_akhir , c.catatan , c.id_ba from ko_penjadwalan a,ko_peserta b ,ko_beritaacara c 

		where a.id_jadwal=c.id_jadwal and a.nim=b.nim AND c.nim=$_GET[nim]";

	$a=mysql_query($query);

	$b=mysql_fetch_array($a);

	echo"

		

		<form method='post'  action='?syxec=$form&aksi=insert&nim=$b[nim]'>

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

            <tr><th colspan=3>Form Input Berita Acara</th></tr>

			<tr><td></td><td></td><td><input type='hidden' value='$b[id_beritaacara]' name='id'></td></tr>

			<tr><td>Tanggal</td><td> : </td><td>$b[tanggal]</td></tr>

			<tr><td>Jam</td><td> : </td><td>$b[jam]</td></tr>

			<tr><td>Ruang</td><td> : </td><td>$b[ruang]</td></tr>

			<tr><td>NIM</td><td> : </td><td>$b[nim]</td></tr>

			<tr><td>Nama Mahasiswa</td><td> : </td><td>$b[nama]</td></tr>

			<tr><td colspan='3'>&nbsp;</td></tr>

			<tr><td>Penguji 1</td><td> : </td><td>$b[Penguji1]</td></tr>

			<tr><td>Penguji 2</td><td> : </td><td>$b[Penguji2]</td></tr>

			<tr><td>Penguji 3</td><td> : </td><td>$b[Penguji3]</td></tr>

			<tr><td colspan='3'>&nbsp;</td></tr>

			<tr><td>Nilai</td><td> : </td><td><input type='text' name='nilai' value='";

				if($unip==$b['penguji1'])echo"$b[nilai1]";

				else if($unip==$b['penguji2'])echo"$b[nilai2]";

				else if($unip==$b['penguji3'])echo"$b[nilai3]";



			echo "'/></td></tr>

			<tr><td>Catatan</td><td> : </td>

				<td>

					<textarea cols='40' rows='10' name='cat'>$b[catatan]</textarea>

				</td>

			</tr>

			

			<tr>

				<td></td>

				<td colspan='2'>

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

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

				</td>

			</tr>

			

		</table>

		</form>

	";

break;



case "insert":

	$nim=$_GET['nim'];

	$nilai=$_POST['nilai'];

	$cat=$_POST['cat'];

  echo($nim);

	$a=mysql_query("Select * from ko_penjadwalan where nim='$nim'") or die(mysql_error());

	$b=mysql_fetch_array($a);

	if($unip==$b[penguji1]){

            mysql_query("update ko_beritaacara set nilai1=$nilai , catatan='$cat' where nim=$nim")or die(mysql_error());

	}

	else if($unip==$b[penguji2]){

		mysql_query("update ko_beritaacara set nilai2=$nilai , catatan='$cat' where nim=$nim")or die(mysql_error());

	}

	else if($unip==$b[penguji3]){

		mysql_query("update ko_beritaacara set nilai3=$nilai , catatan='$cat' where nim=$nim")or die(mysql_error());

	}

   

	

	$query =mysql_query("select nilai1 , nilai2 , nilai3 From ko_beritaacara where nim='$nim'")or die(mysql_error());

	$b=mysql_fetch_array($query);

	$total=($b[0]+$b[1]+$b[2])/3;

        //echo($total);

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

        $huruf;

        $nl = mysql_query("SELECT * FROM nilai where ID>=1 AND ID<=5");

                while($hnl = mysql_fetch_array($nl)){

                 if($total<=$hnl[BatasAtas]&&$total>=$hnl[BatasBawah]){

                     $huruf=$hnl[Nilai];

                 }

             }

        if(mysql_num_rows($q)>0){

            mysql_query("UPDATE ko_penilaian set nilai_akhir=$total,nilai_huruf='$huruf' WHERE nim=$nim");

        }else{

            mysql_query("INSERT INTO ko_penilaian VALUES('$nim','$total','$huruf')");

        }

	mysql_query("update ko_beritaacara set nilai_akhir='$total' where nim='$nim'")or die(mysql_error());	

	echo"<br /><center><a href='?syxec=$form&aksi=detail&id=$kel'>| Daftar Peserta|</a></center>";

break;



}

 ?>