<?php

/**
 * Subclass for performing query and update operations on the 'tariff_detail' table.
 *
 * 
 *
 * @package lib.model
 */ 
class TariffDetailPeer extends BaseTariffDetailPeer
{
	public static function getApplicableTariffForReading($tariff, $reading)
	{
		$c = new Criteria();
		$c->add(self::TARIFF_ID,$tariff->getId());
		$c->add(self::NAME,'Consumption');
		$c->add(self::STARTDATE,$reading->getNewdate(),Criteria::LESS_EQUAL);
		
		$c1 = $c->getNewCriterion(self::ENDDATE,$reading->getNewdate(),Criteria::GREATER_THAN);
		$c2 = $c->getNewCriterion(self::ENDDATE,null);
		$c1->addOr($c2);
		$c->add($c1);
		return self::doSelectOne($c);
	}
	
	public static function getTariffdetails($tariffid)
	{
		$c = new Criteria();
		$c->add(self::TARIFF_ID,$tariffid);
		$c->add(self::STARTDATE,date('Y-m-d'),Criteria::LESS_EQUAL);
		
		$c->add(self::ENDDATE,null);
		return self::doSelect($c);
	}
}