<?php

class AdminEventsHandler extends kDBEventHandler {

	function mapPermissions()
	{
		parent::mapPermissions();
		$permissions = Array(
			'OnSaveColumns'		=>	array('self' => true),
			'OnClosePopup'		=>	array('self' => true),
		);
		$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	function OnResetModRwCache(&$event)
	{
		$this->Conn->Query('DELETE FROM '.TABLE_PREFIX.'Cache WHERE VarName LIKE "mod_rw%"');
	}

	function OnResetCMSMenuCache(&$event)
	{
		$this->Conn->Query('DELETE FROM '.TABLE_PREFIX.'Cache WHERE VarName = "cms_menu"');
	}

	function OnResetSections(&$event)
	{
		$this->Conn->Query('DELETE FROM '.TABLE_PREFIX.'Cache WHERE VarName = "sections_parsed"');
	}

	function OnResetConfigsCache(&$event)
	{
		$this->Conn->Query('DELETE FROM '.TABLE_PREFIX.'Cache WHERE VarName = "config_files" OR VarName = "configs_parsed" OR VarName = "sections_parsed"');
	}

	/**
	 * Generates sturcture for specified table
	 *
	 * @param kEvent $event
	 * @author Alex
	 */
	function OnGenerateTableStructure(&$event)
	{
		$types_hash = Array(
			'string'	=>	'varchar|text|mediumtext|longtext|date|datetime|time|timestamp|char|year|enum|set',
			'int'		=>	'smallint|mediumint|int|bigint|tinyint',
			'float'		=>	'float',
			'double'	=>	'double',
			'numeric'	=>	'decimal',
		);
	
		$table_name = $this->Application->GetVar('table_name');
		if (!$table_name) {
			echo 'error: no table name specified';
			return ;
		}
	
		if (!preg_match('/^'.preg_quote(TABLE_PREFIX, '/').'(.*)/', $table_name)) {
			$table_name = TABLE_PREFIX.$table_name;
		}
	
		$table_info = $this->Conn->Query('DESCRIBE '.$table_name);
	
		// 1. prepare config keys
		$fields = Array();
		$float_types = Array ('float', 'double', 'numeric');
		foreach ($table_info as $field_info) {
			$field_options = Array ();
			
			// 1. get php field type by mysql field type
			foreach ($types_hash as $php_type => $db_types) {
				if (preg_match('/'.$db_types.'/', $field_info['Type'])) {
					$field_options['type'] = $php_type;
					break;
				}
			}
	
			$default_value = $field_info['Default'];
			if (in_array($php_type, $float_types)) {
				// this is float number, add formatter
				if (preg_match('/'.$db_types.'\([\d]+,([\d]+)\)/i', $field_info['Type'], $regs)) {
					$field_options['formatter'] = 'kFormatter';
					$field_options['format'] = '%01.'.$regs[1].'f';
					$default_value = 0;
				}
			}
			
			if ($field_info['Null'] != 'YES') {
				$field_options['not_null'] = 1;
			}
			
			if ($field_info['Key'] == 'PRI') {
				$default_value = 0;
				$config['IDField'] = "'".$field_info['Field']."'";
			}
			
			$field_options['default'] = $default_value;
	
			// format config keys
			$ret = '';
			foreach ($field_options as $key_name => $key_value) {
				if (!preg_match('/^[-\d]+$/', $key_value)) {
					// if not only digits are present, then treat as string
					$key_value = "'".$key_value."'";
				}
				
				$ret .= "'".$key_name."' => ".$key_value.', ';
			}
	
			$fields[ $field_info['Field'] ] = 'Array('.rtrim($ret,',').')';
		}
	
		$config['Fields'] = $fields;
	
		echo '<a href="javascript:window.close();">Close Window</a><br />';
		$ret = print_r($config, true);
		$ret = preg_replace( Array('/\[(.*)\]/',"/(.*)\)/"), Array("'\\1'",'\\1),'), $ret);
		print_pre($ret, '', true);
		
		$event->status = erSTOP;
	}
	
	/**
	 * Refreshes ThemeFiles & Theme tables by actual content on HDD
	 *
	 * @param kEvent $event
	 */
	function OnRebuildThemes(&$event)
	{
		$themes_helper =& $this->Application->recallObject('ThemesHelper');
		/* @var $themes_helper kThemesHelper */

		$themes_helper->refreshThemes();
	}

	function OnSaveColumns(&$event) {
		$picker_helper =& $this->Application->RecallObject('ColumnPickerHelper');
		$picker_helper->SetGridName($this->Application->GetLinkedVar('grid_name'));
		/* @var $picker_helper kColumnPickerHelper */

		$picked = trim($this->Application->GetVar('picked_str'), '|');
		$hidden = trim($this->Application->GetVar('hidden_str'), '|');

		$main_prefix = $this->Application->GetVar('main_prefix');

		$picker_helper->SaveColumns($main_prefix, $picked, $hidden);
		$this->finalizePopup($event);
	}

	/**
	 * Just closes popup & deletes last_template & opener_stack if popup, that is closing
	 *
	 * @param kEvent $event
	 */
	function OnClosePopup(&$event)
	{
		$event->SetRedirectParam('opener', 'u');
	}

	/**
	 * Occurs right after initialization of the kernel, used mainly as hook-to event
	 *
	 * @param kEvent $event
	 */
	function OnStartup(&$event)
	{
		
	}

	/**
	 * Is called after tree was build (when not from cache)
	 *
	 * @param kEvent $event
	 */
	function OnAfterBuildTree(&$event)
	{

	}

}