spota-dev/service/servicespota.php

<?php
	include("koneksi.php");

	//--------------------------------------------------DOSEN-----------------------------------------------//

	$sqldosen = "select * from tbdosen join tbprodi on tbdosen.idProdi=tbprodi.idProdi";
	
	$resultdosen = mysql_query($sqldosen);
	while($row = mysql_fetch_array($resultdosen)){
		$nip = $row['nip'];
		$nama = $row['nmLengkap'];
		$email = $row['email'];
		$nohp = $row['nohp'];
		$jabatan = $row['jenis'];
		$statusdosen = $row['status'];
		$prodi = $row['nmProdi'];
		$password = $row['password'];
		$arr['dosen'][] = array('nip'=>$nip,'nmLengkap'=>$nama,'email'=>$email,'nohp'=>$nohp,'jenis'=>$jabatan,'status'=>$statusdosen,'nmProdi'=>$prodi,'password'=>$password);	
	}

	//--------------------------------------------------DOSEN-----------------------------------------------//

	//--------------------------------------------------MHS-------------------------------------------------//
	
	$nim = $_GET['nim'];
	
	$sqlmhs = "select * from tbmhs join tbprodi on tbmhs.idProdi=tbprodi.idProdi where tbmhs.nim = '".$nim."'";
	
	$resultmhs = mysql_query($sqlmhs);

		$nim =  '';
		$nama = '';
		$prodi = '';
		$email = '';
		$thnmasuk = '';
		$password = '';

	while($row = mysql_fetch_array($resultmhs)){
		$nim =  $row['nim'];
		$nama = $row['nmLengkap'];
		$prodi = $row['nmProdi'];
		$email = $row['email'];
		$thnmasuk = $row['thnmasuk'];
		$password = $row['password'];
	}
	
	$arr['mahasiswa'][] = array('nim'=>$nim,'nmLengkap'=>$nama,'nmProdi'=>$prodi,'email'=>$email,'thnmasuk'=>$thnmasuk,'password'=>$password);

	//--------------------------------------------------MHS-------------------------------------------------//

	//-----------------------------------------------PRAOUTLINE---------------------------------------------//

	//$nim = $_GET['nim'];

	$sqlpraoutline = "select * from tbpraoutline";
	 //where nim='".$nim."'";
	
	$resultpraoutline = mysql_query($sqlpraoutline);
	while($row = mysql_fetch_array($resultpraoutline)){
		$idpraoutline = $row['id'];
		$nim = $row['nim'];
		$judul = $row['judul'];
		$tgl_upload = $row['tgl_upload'];
		$wkt_upload = $row['wkt_upload'];
		$semester = $row['semester'];
		$thn_ajaran = $row['thn_ajaran'];
		$status_usulan = $row['status_usulan'];
		$arr['praoutline'][] = array('id'=>$idpraoutline,'nim'=>$nim,'judul'=>$judul,'tgl_upload'=>$tgl_upload,'wkt_upload'=>$wkt_upload,'semester'=>$semester,'thn_ajaran'=>$thn_ajaran,'status_usulan'=>$status_usulan);
	}

	//-----------------------------------------------PRAOUTLINE---------------------------------------------//
	
	//-----------------------------------------------REKAPHASIL---------------------------------------------//

	$sqlrekaphasil = "select * from tbrekaphasil";
	
	$resultrekaphasil = mysql_query($sqlrekaphasil);
	while($row = mysql_fetch_array($resultrekaphasil)){
		$idpraoutlinerh = $row['idpraoutline'];
		$nimrh = $row['nim'];
		$judulrh = $row['judul_final'];
		$kep = $row['kep_akhir'];
		$tgl_kep = $row['tgl_kep'];
		$wkt_kep = $row['wkt_kep'];
		$pemb1 = $row['pemb1'];
		$pemb2 = $row['pemb2'];
		$peng1 = $row['peng1'];
		$peng2 = $row['peng2'];
		$arr['rekaphasil'][] = array('idpraoutline'=>$idpraoutlinerh,'nim'=>$nimrh,'judul_final'=>$judulrh,'kep_akhir'=>$kep,'tgl_kep'=>$tgl_kep,'wkt_kep'=>$wkt_kep,'pemb1'=>$pemb1,'pemb2'=>$pemb2,'peng1'=>$peng1,'peng2'=>$peng2);
	}

	//-----------------------------------------------REKAPHASIL---------------------------------------------//
	
	//----------------------------------------------REVIEWSPOTA---------------------------------------------//
	$idpraoutline = $_GET['nim'];

	$sqlreviewspota = "select * from tbreview where idpraoutline='".$idpraoutline."'";
	$resultreviewspota = mysql_query($sqlreviewspota);
	$bykreview=mysql_num_rows($resultreviewspota);

	if($bykreview!=0){
		// $arr = array();
		$i = 0;
		// while($row = mysql_fetch_assoc($resultreviewspota)){
		while($row = mysql_fetch_array($resultreviewspota)){
			$reviewer = $row['reviewer'];
			$review = $row['review_text'];
			$putusan = $row['putusan'];
			$tgl = $row['tgl'];
			$wkt = $row['wkt'];
			$idprodi = $row['idProdi'];

			if(is_numeric($reviewer[0])){
				//kalau angka
				$sqlrv = "select * from tbdosen where nip='".$reviewer."' and idProdi='".$idprodi."'";
			}else{
				//kalau huruf
				$sqlrv = "select * from tbmhs where nim='".$reviewer."'";
			}
			
				$result1 = mysql_query($sqlrv);
				
				while($row1 = mysql_fetch_array($result1)){
				// while($row1 = mysql_fetch_assoc($result1)){
					$namareviewer = $row1['nmLengkap'];
					$arr['review'][] = array('idpra'=>$idpraoutline,'reviewer'.$i=>$namareviewer,'reviewnya'.$i=>$review,'putusan'.$i=>$putusan,'tgl'.$i=>$tgl,'wkt'.$i=>$wkt);
				}
		$i += 1;
		}
	}
	else{
		$arr['review'][]=array('idpra'=>'-');
	}

	//----------------------------------------------REVIEWSPOTA---------------------------------------------//

	echo json_encode($arr);
?>