<?php 
/*
 *	Time dimension with daily grain
 */
class DimensionTime extends AppModel {
	var $name = 'DimensionTime';
	var $useTable = 'dimension_time';
	//var $cacheQueries = true;
	var $dim_cache; // lesson learned: Do your own caching.

	function getDimensionFor($one) {
		if ( empty($one['created']) ) {
			$one['created'] = '2000-01-01 00:00:00';			
			$one['day_of_week'] = '1';
			$one['day_of_month'] = '1';
			$one['day_of_year'] = '1';
			$one['month'] = '1';
			$one['quarter'] = '1';
			$one['year'] = '2000';
		}

		$dim_time = null;
		//-> add cache search here
		if ( !empty( $this->dim_cache[ $one['year'].$one['day_of_year'] ] ) ) {
			$dim_time = $this->dim_cache[ $one['year'].$one['day_of_year'] ];
		}

		if ( empty($dim_time) ) {
			$dim_time = $this->find('first',array(
				'conditions' => array(
					'DimensionTime.day_of_year' => $one['day_of_year'],
					'DimensionTime.year' => $one['year']
				)
			));
		}
		if ( empty($dim_time) ) {
			$dim_time['DimensionTime'] = array(
				'day_of_week'=> $one['day_of_week'],
				'day_of_month'=> $one['day_of_month'],
				'day_of_year'=> $one['day_of_year'],
				'month'=> $one['month'],
				'quarter'=> $one['quarter'],
				'year'=> $one['year'],
				'holiday'=> -1,
				'weekend'=> ($one['day_of_week']>5) ? 1: 0,
			);
			$this->create($dim_time);
			$this->save($dim_time);
			$dim_time = $this->read();
		}
		//-> save to cache here		
		$this->dim_cache[ $one['year'].$one['day_of_year'] ] = $dim_time;

		return $dim_time['DimensionTime']['id'];
	}
	
}
?>