/sysfo/balaporanstatus.php
PHP | 579 lines | 498 code | 69 blank | 12 comment | 12 complexity | 25155f96ca04ea806f8a0c4bafca3d96 MD5 | raw file
- <?php
-
- $level = $_SESSION['level'];
-
- function getJurusanIdFromKajur($kajur) {
- $sql = "SELECT Kode FROM kajur WHERE ID = ".$kajur;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- function getJurusanIdFromDekan($dekan) {
- $sql = "SELECT Kode FROM dekan WHERE ID = ".$dekan;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- function getJurusanIdFromRektor($rektor) {
- $sql = "SELECT Kode FROM rektor WHERE ID = ".$rektor;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- function getJurusanIdFromKarJur($karJur) {
- $sql = "SELECT Kode FROM karyawan_jurusan WHERE ID = ".$karJur;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- function getJurusanIdFromKarFak($karFak) {
- $sql = "SELECT Kode FROM karyawan_fakultas WHERE ID = ".$karFak;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- function getJurusanIdFromKarUniv($karUniv) {
- $sql = "SELECT Kode FROM karyawan_universitas WHERE ID = ".$karUniv;
- //echo $sql;
- $query = mysql_query($sql);
- $res = mysql_fetch_array($query);
- return $res['Kode'];
- }
-
- echo"<form method='post' name='formlaporanstatus' action=''>
-
- <table align='center' class=box cellpadding=4>
- <tr align=center>
-
- <td class=ttl>Status</td>
- <td class=ttl>Jumlah Mahasiswa</td>
-
- </tr>
- <tr>";
-
- if($level == 'Kajur'){
- $kode = getJurusanIdFromKajur($_SESSION[uid]);
- echo "Kode Jurusan = $kode";
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A' AND KodeJurusan=$kode");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C' AND KodeJurusan=$kode");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D' AND KodeJurusan=$kode");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K' AND KodeJurusan=$kode");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L' AND KodeJurusan=$kode");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N' AND KodeJurusan=$kode");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M' AND KodeJurusan=$kode");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P' AND KodeJurusan=$kode");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }else if($level == 'Dekan'){
- $kode = getJurusanIdFromDekan($_SESSION[uid]);
- echo "Kode Fakultas = $kode";
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A' AND KodeFakultas=$kode");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C' AND KodeFakultas=$kode");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D' AND KodeFakultas=$kode");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K' AND KodeFakultas=$kode");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L' AND KodeFakultas=$kode");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N' AND KodeFakultas=$kode");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M' AND KodeFakultas=$kode");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P' AND KodeFakultas=$kode");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }else if($level == 'Rektor'){
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A'");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C'");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D'");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K'");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L'");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N'");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M'");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P'");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }else if($level == 'Karyawan Jurusan'){
- $kode = getJurusanIdFromKarJur($_SESSION[uid]);
- echo "Kode Jurusan = $kode";
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A' AND KodeJurusan=$kode");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C' AND KodeJurusan=$kode");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D' AND KodeJurusan=$kode");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K' AND KodeJurusan=$kode");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L' AND KodeJurusan=$kode");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N' AND KodeJurusan=$kode");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M' AND KodeJurusan=$kode");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P' AND KodeJurusan=$kode");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }else if($level == 'Karyawan Fakultas'){
- $kode = getJurusanIdFromKarFak($_SESSION[uid]);
- echo "Kode Fakultas = $kode";
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A' AND KodeFakultas=$kode");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C' AND KodeFakultas=$kode");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D' AND KodeFakultas=$kode");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K' AND KodeFakultas=$kode");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L' AND KodeFakultas=$kode");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N' AND KodeFakultas=$kode");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M' AND KodeFakultas=$kode");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P' AND KodeFakultas=$kode");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }else if($level == 'Karyawan Universitas'){
- //$que_sel = mysql_query("SELECT * FROM mhsw");
- $que_sel1 = mysql_query("SELECT count(*) as jum FROM mhsw where Status='A'");
- $jumlah = mysql_fetch_array($que_sel1);
- $jum=$jumlah['jum'];
- echo"
-
- <td class=lst>Aktif</td>
- <td class=lst><center>$jum</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel2 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='C'");
- $jumlah2 = mysql_fetch_array($que_sel2);
- $jum1=$jumlah2['jum1'];
- echo"
-
- <td class=lst>Cuti</td>
- <td class=lst><center>$jum1</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel3 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='D'");
- $jumlah3 = mysql_fetch_array($que_sel3);
- $jum2=$jumlah3['jum1'];
- echo"
-
- <td class=lst>Drop-Out/Pts Studi</td>
- <td class=lst><center>$jum2</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel4 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='K'");
- $jumlah4 = mysql_fetch_array($que_sel4);
- $jum3=$jumlah4['jum1'];
- echo"
-
- <td class=lst>Keluar</td>
- <td class=lst><center>$jum3</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel5 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='L'");
- $jumlah5 = mysql_fetch_array($que_sel5);
- $jum4=$jumlah5['jum1'];
- echo"
-
- <td class=lst>Lulus</td>
- <td class=lst><center>$jum4</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel6 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='N'");
- $jumlah6 = mysql_fetch_array($que_sel6);
- $jum5=$jumlah6['jum1'];
- echo"
-
- <td class=lst>Non Aktif</td>
- <td class=lst><center>$jum5</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel7 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='M'");
- $jumlah7 = mysql_fetch_array($que_sel7);
- $jum6=$jumlah7['jum1'];
- echo"
-
- <td class=lst>Matrikulasi</td>
- <td class=lst><center>$jum6</center></td>
- </ br>
- <tr></tr>
- ";
- $que_sel8 = mysql_query("SELECT count(*) as jum1 FROM mhsw where Status='P'");
- $jumlah8 = mysql_fetch_array($que_sel8);
- $jum7=$jumlah8['jum1'];
- echo"
-
- <td class=lst>Pasif</td>
- <td class=lst><center>$jum7</center></td>
- </ br>
- <tr></tr>
- ";
-
- }
-
- echo"
- </tr>
- </table>
- </form>
- ";
- ?>
-
-