<?php

	class kThemesHelper extends kHelper {

		/**
		 * Where all themes are located
		 *
		 * @var string
		 */
		var $themesFolder = '';

		/**
		 * Temporary array when all theme files from db are stored
		 *
		 * @var Array
		 */
		var $themeFiles = Array ();

		function kThemesHelper()
		{
			parent::kHelper();
			$this->themesFolder = FULL_PATH.'/themes';
		}

		/**
		 * Updates file system changes to database for selected theme
		 *
		 * @param string $theme_name
		 *
		 * @return mixed returns ID of created/used theme or false, if none created
		 */
		function refreshTheme($theme_name)
		{
			if (!file_exists($this->themesFolder.'/'.$theme_name)) {
				// requested theme was not found on hdd
				return false;
			}

			$id_field = $this->Application->getUnitOption('theme', 'IDField');
			$table_name = $this->Application->getUnitOption('theme', 'TableName');

			$sql = 'SELECT '.$id_field.'
					FROM '.$table_name.'
					WHERE Name = '.$this->Conn->qstr($theme_name);
			$theme_id = $this->Conn->GetOne($sql);

			$this->themeFiles = Array ();
			if ($theme_id) {
				// reset found mark for every themes file (if theme is not new)
				$sql = 'UPDATE '.TABLE_PREFIX.'ThemeFiles
						SET FileFound = 0
						WHERE ThemeId = '.$theme_id;
				$this->Conn->Query($sql);

				// get all theme files from db
				$sql = 'SELECT FileId, CONCAT(FilePath, "/", FileName) AS FullPath
						FROM '.TABLE_PREFIX.'ThemeFiles
						WHERE ThemeId = '.$theme_id;
				$this->themeFiles = $this->Conn->GetCol($sql, 'FullPath');
			}
			else {
				// theme was not found in db, but found on hdd -> create new
				$fields_hash = 	Array (
										 'Name'			=>	$theme_name,
										 'Enabled'		=>	0,
										 'Description'	=>	$theme_name,
										 'PrimaryTheme'	=>	0,
										 'CacheTimeout'	=>	3600, // not in use right now
										 'StylesheetId'	=>	0,	  // not in use right now
								);
				$this->Conn->doInsert($fields_hash, $table_name);
				$theme_id = $this->Conn->getInsertID();
			}

			$theme_path = $this->themesFolder.'/'.$theme_name;
			$this->FindThemeFiles('', $theme_path, $theme_id); // search from base theme directory

			// delete file records from db, that were not found on hdd
			$sql = 'DELETE FROM '.TABLE_PREFIX.'ThemeFiles
					WHERE ThemeId = '.$theme_id.' AND FileFound = 0';
			$this->Conn->Query($sql);

			return $theme_id;
		}

		/**
		 * Searches for new templates (missing in db) in spefied folder
		 *
		 * @param string $folder_path subfolder of searchable theme
		 * @param string $theme_path theme path from web server root
		 * @param int $theme_id id of theme we are scanning
		 */
		function FindThemeFiles($folder_path, $theme_path, $theme_id, $auto_structure_mode=1)
		{
			$fh = opendir($theme_path.$folder_path.'/');

			if (file_exists($theme_path.$folder_path.'/'.'.smsignore')) {
				$ignore = file($theme_path.$folder_path.'/'.'.smsignore');
			}
			else {
				$ignore = array();
			}

			while (($filename = readdir($fh))) {
				if ($filename == '.' || $filename == '..') continue;

				$auto_structure = $auto_structure_mode;
				foreach ($ignore as $pattern)
				{
					if (preg_match('/'.str_replace('/', '\\/', trim($pattern)).'/', $filename)) {
						$auto_structure = 2;
						break;
					}
				}

				$full_path = $theme_path.$folder_path.'/'.$filename;
				if (is_dir($full_path)) {
					$this->FindThemeFiles($folder_path.'/'.$filename, $theme_path, $theme_id, $auto_structure);
				}
				elseif (substr($filename, -4) == '.tpl') {
					$file_path = $folder_path.'/'.$filename;

					$file_id = isset($this->themeFiles[$file_path]) ? $this->themeFiles[$file_path] : false;
					if ($file_id) {
						// file was found in db & on hdd -> mark as existing
						$sql = 'UPDATE '.TABLE_PREFIX.'ThemeFiles
								SET FileFound = 1, FileType = '.$auto_structure.'
								WHERE FileId = '.$file_id;
						$this->Conn->Query($sql);
					}
					else {
						// file was found on hdd, but missing in db -> create new file record
						$fields_hash = 	Array (
												'ThemeId'		=>	$theme_id,
												'FileName'		=>	$filename,
												'FilePath'		=>	$folder_path,
												'Description'	=>	'',
												'FileType'		=>	$auto_structure, // 1 - built-in, 0 - custom (not in use right now), 2 - skipped in structure
												'FileFound'		=>	1,
										);
						$this->Conn->doInsert($fields_hash, TABLE_PREFIX.'ThemeFiles');
						$this->themeFiles[$file_path] = $this->Conn->getInsertID();
					}
//					echo 'FilePath: [<strong>'.$folder_path.'</strong>]; FileName: [<strong>'.$filename.'</strong>]; IsNew: [<strong>'.($file_id > 0 ? 'NO' : 'YES').'</strong>]<br />';
				}

			}
		}

		/**
		 * Updates file system changes to database for all themes (including new ones)
		 *
		 */
		function refreshThemes()
		{
			$themes_found = Array();

			$fh = opendir($this->themesFolder.'/');
			while (($filename = readdir($fh))) {
				if ($filename == '.' || $filename == '..' || $filename == 'CVS') continue;

				if (is_dir($this->themesFolder.'/'.$filename)) {
					$theme_id = $this->refreshTheme($filename);
					if ($theme_id) {
						$themes_found[] = $theme_id;
					}
				}
			}

			$id_field = $this->Application->getUnitOption('theme', 'IDField');
			$table_name = $this->Application->getUnitOption('theme', 'TableName');

			// if none themes found -> delete all from db OR delete all except of found themes
			$sql = 'SELECT '.$id_field.'
					FROM '.$table_name;
			if ($themes_found) {
				$sql .= ' WHERE '.$id_field.' NOT IN ('.implode(',', $themes_found).')';
			}
			$theme_ids = $this->Conn->GetCol($sql);
			$this->deleteThemes($theme_ids);

		}

		/**
		 * Deletes themes with ids passed from db
		 *
		 * @param Array $theme_ids
		 */
		function deleteThemes($theme_ids)
		{
			if (!$theme_ids) {
				return ;
			}

			$id_field = $this->Application->getUnitOption('theme', 'IDField');
			$table_name = $this->Application->getUnitOption('theme', 'TableName');

			$sql = 'DELETE FROM '.$table_name.'
					WHERE '.$id_field.' IN ('.implode(',', $theme_ids).')';
			$this->Conn->Query($sql);

			$sql = 'DELETE FROM '.TABLE_PREFIX.'ThemeFiles
					WHERE '.$id_field.' IN ('.implode(',', $theme_ids).')';
			$this->Conn->Query($sql);
		}
	}


?>