<?php
	$objConnect = mysql_connect("localhost","cmsmarthom_reg","55021744");
	$objDB = mysql_select_db("cmsmarthom_reg");
	mysql_query("SET NAMES UTF8");
	mysql_query("SET character_set_results=utf8");
	mysql_query("SET character_set_client=utf8");
	mysql_query("SET character_set_connection=utf8");

	$strDate = $_POST["sDate"];

	$strSQL = "SELECT * FROM statuscheck WHERE DATE(Date) = '".$strDate."' ORDER BY Date DESC ";

	$objQuery = mysql_query($strSQL);
	$obResult = mysql_fetch_array($objQuery);
	if($obResult)
	{
		$arr['StatusID'] = "0";
		$arr["SubjectID"] = $obResult["SubjectID"];
		$arr["Qr"] = $obResult["qrcode"];
		$arr["Sh"] = $obResult["shake"];
		$arr["Ba"] = $obResult["barcode"];
		$arr["Ch"] = $obResult["checklist"];
		$arr["Qi"] = $obResult["qiz"];
		$arr["Ph"] = $obResult["phase"];
	}
	else
	{
		$arr["SubjectID"] = "null";
	}

	mysql_close($objConnect);
	echo json_encode($arr);
?>