<?php
//土壤水分
namespace Westdc\Visual\Reader;

use Westdc\Visual\Record;
use Westdc\Visual\RecordInterface;

abstract class SoilMoisture extends Record implements RecordInterface
{	
	function __construct()
	{
		parent::__construct(__CLASS__);
	}
	
	public $tablename;
	
	public $subset;
	
	public function switchDataset()
	{
		if(empty($this->subset))
		{
			$this->subset = "20cm";
			return;
		}
		
		switch($this->subset){
			case "10cm":
				$this->subset = "vwc_avg10";
				break;
			case "20cm" :
				$this->subset = "vwc_avg20";
				break;
			case "30cm" :
				$this->subset = "vwc_avg30";
				break;
			case "40cm" :
				$this->subset = "vwc_avg40";
				break;
			case "50cm" :
				$this->subset = "vwc_avg50";
				break;
		}
		
		return;
	}
	
	public function getData()
	{		
		$this->switchDataset();
		
		$sql = "SELECT * FROM {$this->tablename}
				WHERE
					$this->subset > 0
				ORDER BY
					extract(year from \"timestamp\") ASC,
					extract(month from \"timestamp\") ASC,
					extract(day from \"timestamp\") ASC,
					extract(hour from \"timestamp\") ASC
				";
		//exit($sql);
		$rs = $this->db->query($sql);
		return $rs;

	}
	
	public function outPut()
	{
		
		$rs = $this->getData();
		
		$data = array();
		
		while($row = $rs->fetch())
		{
			$row['utctime'] = $this->utcMsTime(strtotime($row['timestamp']));
			$data[] = array($row['utctime'],$row[$this->subset]);
		}
		
		return $data;
	}

}