
<?php

$con = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);

 $course_id = $request->getAttribute('course_id');
  $season_id=$request->getAttribute('season_id');
   $exams_id=$request->getAttribute('exams_id');
    $date_time=$request->getAttribute('date_time');
     $exam_name=$request->getAttribute('exam_name');
      $proctor_id=$request->getAttribute('proctor_id');
       $block=$request->getAttribute('block');
	    $floor=$request->getAttribute('floor');
	     $room=$request->getAttribute('room');
	      $papers=$request->getAttribute('papers');
	       $total_students=$request->getAttribute('total_students');
	        $students=$request->getAttribute('students');


$response=array();
if(isset($course_id)&&isset($season_id)&&isset($exams_id)&&isset($date_time)&&isset($proctor_id)){
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id) WHERE submit_answer_script.course_id='$course_id' AND submit_answer_script.season_id='$season_id' 
 AND submit_answer_script.exams_id='$exams_id' AND submit_answer_script.date_time='$date_time' AND submit_answer_script.proctor_id='$proctor_id'";
}
elseif(isset($course_id)&&isset($season_id)&&isset($exams_id)&&isset($date_time)){
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id) WHERE submit_answer_script.course_id='$course_id' AND submit_answer_script.season_id='$season_id' 
 AND submit_answer_script.exams_id='$exams_id' AND submit_answer_script.date_time='$date_time'";
}
elseif(isset($course_id)&&isset($season_id)&&isset($exams_id)){
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id) WHERE submit_answer_script.course_id='$course_id' AND submit_answer_script.season_id='$season_id' 
 AND submit_answer_script.exams_id='$exams_id'";
}
elseif(isset($course_id)&&isset($season_id)){
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id) WHERE submit_answer_script.course_id='$course_id' AND submit_answer_script.season_id='$season_id'";
}
elseif(isset($course_id)){
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id) 	WHERE submit_answer_script.course_id='$course_id'";
}
else{
	$sql="SELECT submit_answer_script.course_id, submit_answer_script.season_id, submit_answer_script.exams_id, submit_answer_script.date_time, 
	submit_answer_script.proctor_id, submit_answer_script.paper, submit_answer_script.roll_number, submit_answer_script.status,
	course.course_name, season.seasonname, Exams.examname, faculty.Faculty_name, faculty.Staff_number 
	from (submit_answer_script  INNER JOIN course ON course.course_id=submit_answer_script.course_id 
 INNER JOIN season ON season.id=submit_answer_script.season_id
 INNER JOIN Exams ON Exams.id=submit_answer_script.exams_id
 INNER JOIN faculty ON faculty.id=submit_answer_script.proctor_id)";
}


$result=mysqli_query($con,$sql);

    while ($row[]=mysqli_fetch_assoc($result)) {  

      $user=$row;

	}


echo json_encode($user);

?>