function neighboursInfo($building_id, $today, $lastweek, $quantity)
{
//option 1: -compare to numbers of surrounding buildings
// -set var: Quantity = 3 surrounding buildings
//return an 2d array including: building name(string) and energy consumption(float)
$neighbour_list = array();
$neighbour_info = array();
$result = mysql_query("SELECT * FROM building_neighbour WHERE building_id = '" . $building_id . "'");
if (!$result) {
die('Invalid query: ' . mysql_error() . '<br>');
}
while ($var = mysql_fetch_assoc($result)) {
$id = intval($var['neighbour_id']);
array_push($neighbour_list, $id);
}
$neighbour_list = rand_generator($neighbour_list, $quantity);
for ($z = 0; $z < count($neighbour_list); $z++) {
$bid_info = buildingInfo($neighbour_list[$z], $today, $lastweek);
$bid_info = array('name' => $bid_info[0], 'energy_usage' => $bid_info[1]);
array_push($neighbour_info, $bid_info);
}
return $neighbour_info;
/*
//option 2: compare to the same type buildings
else{}
*/
//return array($neighbour_name, $energy_usage_in_percentage);
}
echo "Please give a building name<br>";
exit;
}
//1.Get the url and building_name
$building_name = $_GET["building_name"];
//OUTPUT VALUE!!!
$building_id = buildingID($building_name);
$clock = date('H:i A');
//OUTPUT VALUE!!!
$today = get_today_lastweek()[0];
//$lastweek = get_today_lastweek()[1];
$lastweek = date('m/d/Y H:i:s', mktime(16, 45, 0, 1, 4, 2016));
$number_tips = constant('NUMBER_OF_TIPS');
if ($building_name == 'Totem') {
$number_neighboor = constant('NUMBER_OF_NEIGHBOUR_FOR_TOTEM');
$building_info = buildingInfo($building_id, $today, $lastweek);
$neighbour_info = neighboursInfo($building_id, $today, $lastweek, $number_neighboor);
} else {
$number_neighboor = constant('NUMBER_OF_NEIGHBOUR');
$building_info = buildingInfo($building_id, $today, $lastweek);
$neighbour_info = neighboursInfo($building_id, $today, $lastweek, $number_neighboor);
//OUTPUT VALUE!!!
}
$tips_info = tipsInfo($building_id, $number_tips);
array_push($building_info, $clock);
$building_info = array("building_name" => $building_info[0], "energy_usage" => $building_info[1], "time" => $building_info[2]);
$energy_info = array('building' => $building_info, 'neighbours' => $neighbour_info, 'tips' => $tips_info);
//echo "<pre>";
//echo json_encode($energy_info);
return json_encode($energy_info);
mysql_close($dbhandle);
