/sysfo/koberitaacara.php
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'> </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'> </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;
-
- }
- ?>