<?php

/**
 * Subclass for representing a row from the 'reading_cyle' table.
 *
 * 
 *
 * @package lib.model
 */ 
class ReadingCycle extends BaseReadingCycle
{
	public function __toString()
	{
		return $this->getName();
	}
	
	public function ggetStartdate($format = 'Y-m-d')
	{
		$c = new Criteria();
		$c->clearSelectColumns()->addSelectColumn('MIN('.ReadingPeer::NEWDATE.')');
		$c->addJoin(ReadingPeer::READING_CYCLE_ID,ReadingCyclePeer::ID);
		$c->add(ReadingCyclePeer::ID,$this->getId());
	
		$rs = ReadingCyclePeer::doSelectRS($c);
		$rs->next();
		$startdate = $rs->getString(1);
		if ($startdate == null || $startdate == '') {
			return null;
		} elseif (!is_int($startdate)) {
			$startdate = strtotime($startdate);
			if ($startdate === -1 || $startdate === false) { throw new PropelException("Unable to parse value of [startdate] as date/time value: " . var_export($startdate, true)); }
		}
		if ($format == null)	{
			return $startdate;
		} elseif (strpos($format, '%') !== false) {
			return strftime($format, $startdate);
		} else {
			return date($format, $startdate);
		}
	}
	
	public function ggetEnddate($format = 'Y-m-d')
	{
		$c = new Criteria();
		$c->clearSelectColumns()->addSelectColumn('MAX('.ReadingPeer::NEWDATE.')');
		$c->addJoin(ReadingPeer::READING_CYCLE_ID,ReadingCyclePeer::ID);
		$c->add(ReadingCyclePeer::ID,$this->getId());
	
		$rs = ReadingCyclePeer::doSelectRS($c);
		$rs->next();
		$enddate = $rs->getString(1);
		if ($enddate == null || $enddate == '') {
			return null;
		} elseif (!is_int($enddate)) {
			$enddate = strtotime($enddate);
			if ($enddate === -1 || $enddate === false) { throw new PropelException("Unable to parse value of [startdate] as date/time value: " . var_export($enddate, true)); }
		}
		if ($format == null)	{
			return $enddate;
		} elseif (strpos($format, '%') !== false) {
			return strftime($format, $enddate);
		} else {
			return date($format, $enddate);
		}		
	}
}