<?php
session_start();
	include("SpreadsheetAPI_pdo_siwes.php");
	function recordSetToJson($mysql_result,$jsonencode=false,$marker="") {
		$return_arr = array();
		while($datarow = mysql_fetch_assoc($mysql_result)){
			$return_arr[] = $datarow;
		}   		
		if (!$jsonencode)	
			return $return_arr;
		else{
			if ($marker != "")
				return json_encode(array($marker =>$return_arr));			
			else
				return json_encode($return_arr);
		}
	}
	//
	$filename = "extraction_siwes.xls";

		require('../../connect.php');
        $db=db_connect();
		if (isset($_REQUEST['VIEW']) && $_REQUEST['VIEW']=='TRUE'){
//            $Query="select * from admitted where course in (select dOption from dept where dSchool='$schID')";
		}else{

        }

		if (isset($_REQUEST['JSON'])){
            $result = $db->query($Query);
            if ($result->rowCount() == 0)
				echo "NOT_FOUND";
			else

				echo recordSetToJson($results,true);
		}else {
//            $_SESSION['ttype']='SIWES REGISTRATION REPORT';
//            $dept_ID=$_GET['dept_id'];
            $Query="select * from vw_siwes_report";
//              $Query="DROP TABLE IF EXISTS admitted_temp_sch;Create table admitted_temp_sch(select formNo,names,course,(select levelName from leveltb where id=admitted.levelID) as levelname, mode from admitted where course ='$dept_ID' order by levelname,formNo)";
//            die();
            $db->query($Query);

            xlsProcess($filename);
            exit;
        }
?>