<?php
header('Content-Type: text/html; charset=utf-8');
header('Content-Type: application/json');
//include ('../../sys_connect.php');
require("../../inc/config.inc.php");
require("../../inc/common.php");
//mysql_query("SET NAMES utf8");
//วิธีใช้ก็ api_con.php?data=student&app_name=rms
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
if ($_REQUEST[school_id] != null){
	$_SESSION[school_id] = $_REQUEST['school_id'];
}else{
	$_SESSION[school_id] = '01';
}

if ($_REQUEST[data] != null){
$data_to_get = $_REQUEST['data'];
$academicYear = $_REQUEST['academicYear'];
$semester = $_REQUEST['semester'];
	
}

function get_alldata() {		
	//GLOBAL $dbname;
	global $connect;
	global $data_to_get;
		if ($data_to_get == 'regis_payment'){
		//$sqlQuery = " WHERE academicYear='$academicYear'and school_id = '".$_SESSION[school_id]."' ";	
		//$sqlQuery = " WHERE academicYear='$academicYear' AND semester='$semester' ";
		//$sqlQuery = " WHERE confirm=1";
		//$alldataQuery = "SELECT *	FROM ".$data_to_get." ".$sqlQuery." ";			
		$alldataQuery = "SELECT *	FROM regis_payment_log WHERE 1";
		//$resultData = mysql_db_query($connect,$alldataQuery);	
		$resultData = mysqli_query($connect,$alldataQuery);	
		$alldataData = array();
		while( $alldataRecord = mysqli_fetch_array($resultData) ) {
			$alldataData[] = $alldataRecord;
		}
		
		echo json_encode($alldataData);	
			
		}
}
function get_data() {		
	//GLOBAL $dbname;
	global $connect;
	global $data_to_get;
		if ($data_to_get == 'regis_payment'){
		//$sqlQuery = " WHERE academicYear='$academicYear'and school_id = '".$_SESSION[school_id]."' ";	
		$sqlQuery = " WHERE academicYear=$_REQUEST[academicYear] AND semester=$_REQUEST[semester] ";
		//$sqlQuery = " WHERE 1";
		$alldataQuery = "SELECT *	FROM regis_payment_log ".$sqlQuery." ";		
		//$alldataQuery = "SELECT *	FROM $data_to_get  WHERE 1 ";	
		//$resultData = mysql_db_query($connect,$alldataQuery);	
		$resultData = mysqli_query($connect,$alldataQuery);	
		$alldataData = array();
		while( $alldataRecord = mysqli_fetch_array($resultData) ) {
			$alldataData[] = $alldataRecord;
		}
		
		echo json_encode($alldataData);	
			
		}
}

if ($_REQUEST[data] =='regis_payment'  && $_REQUEST[app_name] == 'rms'  && $_REQUEST[academicYear] !=''  && $_REQUEST[semester] !='' ){
	//echo "xx $academicYear $semester $data_to_get";
	get_data();
}elseif($_REQUEST[data] =='regis_payment' && $_REQUEST[app_name] == 'rms' && $_REQUEST[academicYear] =="" &&  $_REQUEST[semester] =="" ){
	get_alldata();
}else{
	$response["error"] = true;
	$response["error_msg"] = "invalid error";
	echo json_encode($response);		
}

//วิธีใช้ก็ url/api/GetRegisPayment/?data=regis_payment&app_name=rms&academicYear=2565&semester=2