function getDevices() { global $device_db; //Open MySQL Connection inorder to get last data point for a device. $database = sql_dmca(); $device_info['statement'] = "SELECT * FROM {$device_db}"; $device_info['info'] = $database->query($device_info['statement']); $device_info['error'] = $database->error; if ($device_info['error']) { $device_info['results'] = "Error for all devices"; } else { $device_info['results'] = "All Device Information"; } $database->close(); return $device_info; }
function getData($climate) { global $climate_db; global $device_db; //Open MySQL Connection inorder to get last data point for a device. $database = sql_dmca(); $climate = arrayEscape($climate, $database); $climate_results['building'] = $climate['building']; $climate_results['room'] = $climate['room']; $climate_results['error'] = ""; // Statement Where there's a stop and start time if ($climate['startTime'] && $climate['stopTime']) { $climate_results['results'] .= "Climate Data for {$climate['building']} {$climate['room']} {$climate['startTime']} between {$climate['stopTime']}"; $climate_results['statement'] = "SELECT time, temp AS tempC, (temp*9/5 + 32) AS tempF\n\t\t\t\t\t\t\t\t\t\tFROM {$climate_db}\n\t\t\t\t\t\t\t\t\t\tJOIN {$device_db}\n\t\t\t\t\t\t\t\t\t\t\tON {$climate_db}.location_id={$device_db}.id\n\t\t\t\t\t\t\t\t\t\tWHERE {$device_db}.building= '{$climate['building']}' \n\t\t\t\t\t\t\t\t\t\t\tAND {$device_db}.room= '{$climate['room']}'\n\t\t\t\t\t\t\t\t\t\t\tAND time >= '{$climate['startTime']}'\n\t\t\t\t\t\t\t\t\t\t\tAND time <= '{$climate['stopTime']}'"; } elseif ($climate['startTime'] && !$climate['stopTime']) { $climate_results['results'] .= "Climate Data for {$climate['building']} {$climate['room']} after {$climate['startTime']}"; $climate_results['statement'] = "SELECT time, temp AS tempC, (temp*9/5 + 32) AS tempF\n\t\t\t\t\t\t\t\t\t\tFROM {$climate_db}\n\t\t\t\t\t\t\t\t\t\tJOIN {$device_db}\n\t\t\t\t\t\t\t\t\t\t\tON {$climate_db}.location_id={$device_db}.id\n\t\t\t\t\t\t\t\t\t\tWHERE {$device_db}.building= '{$climate['building']}' \n\t\t\t\t\t\t\t\t\t\t\tAND {$device_db}.room= '{$climate['room']}'\n\t\t\t\t\t\t\t\t\t\t\tAND time >= '{$climate['startTime']}'"; } elseif (!$climate['startTime'] && $climate['stopTime']) { $climate_results['results'] .= "Climate Data for {$climate['building']} {$climate['room']} before {$climate['stopTime']}"; $climate_results['statement'] = "SELECT time, temp AS tempC, (temp*9/5 + 32) AS tempF\n\t\t\t\t\t\t\t\t\t\tFROM {$climate_db}\n\t\t\t\t\t\t\t\t\t\tJOIN {$device_db}\n\t\t\t\t\t\t\t\t\t\t\tON {$climate_db}.location_id={$device_db}.id\n\t\t\t\t\t\t\t\t\t\tWHERE {$device_db}.building= '{$climate['building']}' \n\t\t\t\t\t\t\t\t\t\t\tAND {$device_db}.room= '{$climate['room']}'\n\t \t\t\t\t\t\t\t\t\t\tAND time <= '{$climate['stopTime']}'"; } else { $climate_results['results'] .= "Climate Data for {$climate['building']} {$climate['room']}"; $climate_results['statement'] = "SELECT time, temp AS tempC, (temp*9/5 + 32) AS tempF\n\t\t\t\t\t\t\t\t\t\tFROM {$climate_db}\n\t\t\t\t\t\t\t\t\t\tJOIN {$device_db}\n\t\t\t\t\t\t\t\t\t\t\tON {$climate_db}.location_id={$device_db}.id\n\t\t\t\t\t\t\t\t\t\tWHERE {$device_db}.building= '{$climate['building']}' \n\t\t\t\t\t\t\t\t\t\t\tAND {$device_db}.room= '{$climate['room']}'"; } $climate_results['info'] = $database->query($climate_results['statement']); $climate_results['error'] .= $database->error; if ($climate_results['error']) { $climate_results['results'] = "Climate Insertion Error {$climate['building']} {$climate['room']}"; } $database->close(); return $climate_results; }