Exemplo n.º 1
0
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;
}
Exemplo n.º 2
0
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;
}