//$stationdatas = $station->buildStationdatas();
    $fleepdatas = fRecordSet::buildFromSQL('Fleepdata', array("SELECT * FROM `fukushimadatas` WHERE `station_id`=%i AND reading_date > ADDDATE(NOW(), INTERVAL -9 DAY) ORDER BY `reading_date` DESC LIMIT 0 , 6", $station->getStationId()));
    //$fleepdatas = fRecordSet::buildFromSQL('Fleepdata', array("SELECT * FROM `fukushimadatas` WHERE `station_id`=%i ORDER BY `reading_date` DESC LIMIT 0 , 6",$station->getStationId()));
    //$stationdatas->sort('getDatetimeString','desc');
    $datastreams .= '{"title": "' . $station->getStationNameEn() . '",' . '"title_jp": "' . $station->getStationNameJp() . '",' . '"description": "",' . '"creator": "fukushima_fleep",' . '"feed": "http://www.rdtn.org/feeds/station/' . $station->getStationId() . '.json",' . '"location": {"lon":' . $station->getLongitude() . ', "lat":' . $station->getLatitude() . ', "name": "' . $station->getPrefectureNameEn() . '"},' . '"id":' . $station->getStationId() . ',' . '"datastreams": [';
    $success = false;
    foreach ($fleepdatas as $fleepdata) {
        $sa = $fleepdata->getReadingValue();
        if ($sa != -888 && $sa != -999) {
            $unit = $fleepdata->createUnit();
            $datastreams .= '{"at": "' . $fleepdata->getReadingDate() . '",' . '"max_value": "0",' . '"min_value": "0",' . '"current_value": "' . $fleepdata->getReadingValue() . '",' . '"id": "' . $fleepdata->getReadingId() . '",' . '"unit": {"type": "basicSI","label": "' . $unit->getUnitLabel() . '","symbol": "' . $unit->getUnitSymbol() . '"}}';
            $success = true;
            break;
        }
    }
    if ($success) {
        //close and append
        $datastreams .= ']},';
        $jsonData .= $datastreams;
    }
    $datastreams = "";
}
$output .= rtrim($jsonData, ',');
$output .= '], "itemsPerPage": ' . $stations->count() . ', "startIndex": 0, "totalResults": ' . $stations->count(TRUE) . '}';
$file = new fFile(DOC_ROOT . '/feeds/fukushima_full_static.json');
$file->write($output);
echo $output;
?>


Esempio n. 2
0
$jsonOutput .= '], "itemsPerPage": ' . $totalRecords . ', "startIndex": 0, "totalResults": ' . $totalRecords . '}';
//dont write files unless there were rows returned
if ($jsonCount > 0) {
    echo DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.json';
    //write JSON
    try {
        $file = new fFile(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.json');
        $file->write($jsonOutput);
    } catch (fExpectedException $e) {
        $new_file = fFile::create(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.json', $jsonOutput);
    } catch (fEnvironmentException $e) {
    }
    //write KML
    try {
        $file = new fFile(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.kml');
        $file->write($kmlOutput);
    } catch (fExpectedException $e) {
        $new_file = fFile::create(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.kml', $kmlOutput);
    } catch (fEnvironmentException $e) {
    }
    //write CSV
    try {
        $file = new fFile(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.csv');
        $file->write($csvOutput);
    } catch (fExpectedException $e) {
        $new_file = fFile::create(DOC_ROOT . '/feeds/driveCache/drive' . $driveId . '.csv', $csvOutput);
    } catch (fEnvironmentException $e) {
    }
}
$db = null;
//echo $output;