profiler.admin.controller.php

<?php
/* Copyright (C) NAVER <http://www.navercorp.com> */

/**
 * @class  profilerAdminController
 * @author NAVER (developers@xpressengine.com)
 * @brief  Profiler module admin controller class.
 */

class profilerAdminController extends profiler
{
	function init()
	{
	}

	function procProfilerAdminInsertConfig()
	{
		$oModuleController = getController('module');
		$oProfilerModel = getModel('profiler');

		$vars = Context::getRequestVars();

		$config = $oProfilerModel->getConfig();
		if(!$config->slowlog)
		{
			$config->slowlog = new stdClass();
		}
		$config->slowlog->enabled = ($vars->slowlog_enabled === 'Y') ? 'Y' : 'N';
		$config->slowlog->time_trigger = ($vars->slowlog_time_trigger > 0) ? $vars->slowlog_time_trigger : NULL;
		$config->slowlog->time_addon = ($vars->slowlog_time_addon > 0) ? $vars->slowlog_time_addon : NULL;
		$config->slowlog->time_widget = ($vars->slowlog_time_widget > 0) ? $vars->slowlog_time_widget : NULL;

		$oModuleController->updateModuleConfig('profiler', $config);

		$this->setMessage('success_updated');
		$this->setRedirectUrl(Context::get('success_return_url') ? Context::get('success_return_url') : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminConfig'));
	}

	function procProfilerAdminTruncateSlowlog()
	{
		executeQuery('profiler.truncateSlowlog');

		$this->setMessage('msg_profiler_arranged');
		$this->setRedirectUrl(Context::get('success_return_url') ? Context::get('success_return_url') : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminSlowlog'));
	}

	function procProfilerAdminDeleteTrigger()
	{
		// 고급 삭제 옵션
		$advanced = Context::get('advanced') === 'Y';

		// 삭제할 트리거 목록 불러오기
		$oProfilerAdminModel = getAdminModel('profiler');
		$invalid_trigger_list = $oProfilerAdminModel->getTriggersToBeDeleted($advanced);

		// 트리거 삭제
		foreach($invalid_trigger_list as $trigger)
		{
			$output = $this->deleteTrigger($trigger->trigger_name, $trigger->module, $trigger->type, $trigger->called_method, $trigger->called_position);
			if(!$output->toBool())
			{
				return $output;
			}
		}

		$this->setMessage('msg_profiler_arranged');
		$this->setRedirectUrl(Context::get('success_return_url') ? Context::get('success_return_url') : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminTrigger', 'page', Context::get('page'), 'advanced', Context::get('advanced')));
	}

	function procProfilerAdminDeleteModuleConfig()
	{
		// 고급 삭제 옵션
		$advanced = Context::get('advanced') === 'Y';

		// 삭제할 모듈 설정 목록 불러오기
		$oProfilerAdminModel = getAdminModel('profiler');
		$invalid_module_config = $oProfilerAdminModel->getModuleConfigToBeDeleted($advanced);

		// 모듈 설정 삭제
		foreach($invalid_module_config as $module_config)
		{
			$output = executeQuery('profiler.deleteModuleConfig', $module_config);
			if(!$output->toBool())
			{
				return $output;
			}
		}

		$this->setMessage('msg_profiler_arranged');
		$success_return_url = Context::get('success_return_url');
		$this->setRedirectUrl( $success_return_url ? $success_return_url : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminModuleConfig', 'page', Context::get('page')));
	}

	function procProfilerAdminDeleteAddonConfig()
	{
		// 고급 삭제 옵션
		$advanced = Context::get('advanced') === 'Y';

		$oProfilerAdminModel = getAdminModel('profiler');
		$invalid_addon_config = $oProfilerAdminModel->getAddonConfigToBeDeleted($advanced);

		// 애드온 설정 삭제
		foreach($invalid_addon_config as $addon_config)
		{
			$addon_name->addon = $addon_config->addon;
			$output = executeQuery('profiler.deleteAddonConfig', $addon_name);
			if(!$output->toBool())
			{
				return $output;
			}
		}

		$this->setMessage('msg_profiler_arranged');
		$success_return_url = Context::get('success_return_url');
		$this->setRedirectUrl($success_return_url ? $success_return_url : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminAddonConfig', 'page', Context::get('page'), 'advanced', ($advanced ? 'Y' : 'N')));
	}

	function procProfilerAdminDeleteTable()
	{
		// 삭제할 테이블 목록 불러오기
		$oProfilerAdminModel = getAdminModel('profiler');
		$table_list = $oProfilerAdminModel->getTableToBeArranged();

		// DB 테이블 삭제
		$oDB = DB::getInstance();
		foreach($table_list as $table_info)
		{
			if($table_info->to_be_deleted === TRUE)
			{
				$oDB->dropTable(substr($table_info->name, strlen($oDB->prefix)));
			}
		}

		$this->setMessage('msg_profiler_arranged');
		$success_return_url = Context::get('success_return_url');
		$this->setRedirectUrl($success_return_url ? $success_return_url : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminTable', 'page', Context::get('page')));
	}

	function procProfilerAdminDeleteTablePiece()
	{
		$vars = Context::getRequestVars();
		$table_name = $vars->table_name;
		$oDB = DB::getInstance();
		$oDB->dropTable(substr($table_name, strlen($oDB->prefix)));

		$this->setMessage('msg_profiler_arranged');
		$success_return_url = Context::get('success_return_url');
		$this->setRedirectUrl($success_return_url ? $success_return_url : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminTable', 'page', Context::get('page')));
	}

	function procProfilerAdminDeleteLogFile()
	{
		$slowlog_files = array(
			_XE_PATH_.'files/_slowlog_addon.php',
			_XE_PATH_.'files/_slowlog_trigger.php',
			_XE_PATH_.'files/_slowlog_widget.php',
			_XE_PATH_.'files/_slowlog_query.php'
		);

		foreach($slowlog_files as $file)
		{
			$slowlog_file = FileHandler::exists($file);
			if($slowlog_file === false)
			{
				continue;
			}
			FileHandler::removeFile($file);
		}

		$this->setMessage('msg_profiler_slowlog_file_arranged');
		$this->setRedirectUrl(Context::get('success_return_url') ? Context::get('success_return_url') : getNotEncodedUrl('', 'module', 'admin', 'act', 'dispProfilerAdminConfig'));
	}

	/**
	 * @brief 테이블 복구
	 * @param string $table_name
	 * @return object
	 */
	function repairTable($table_name)
	{
		if(!is_string($table_name))
		{
			return new Object(-1, 'msg_invalid_request');
		}

		$oDB = DB::getInstance();
		switch($oDB->db_type)
		{
			case 'mysql':
			case 'mysql_innodb':
			case 'mysqli':
			case 'mysqli_innodb':
				// @TODO repair, analyze, optimize 상관관계 이해하기
				$query = 'repair table ' . $oDB->prefix . $table_name;
				$result = $oDB->_query($query);
				break;

			// MSSQL 작성 포기
			/*
			case 'mssql':
				break;
			*/

			// @TODO 쿼리문 작성
			/*
			case 'cubrid':
				break;
			*/
		}

		return new Object();
	}

	/**
	 * @brief 트리거 삭제명령
	 * @param string $table_name
	 * @return $output
	 */
	function deleteTrigger($trigger_name, $module, $type, $called_method, $called_position)
	{
		$args = new stdClass();
		$args->trigger_name = $trigger_name;
		$args->module = $module;
		$args->type = $type;
		$args->called_method = $called_method;
		$args->called_position = $called_position;
		$output = executeQuery('module.deleteTrigger', $args);
		//캐시파일도 함께 삭제.
		$oCacheHandler = CacheHandler::getInstance('object', NULL, TRUE);
		if($oCacheHandler->isSupport())
		{
			$oCacheHandler->invalidateGroupKey('triggers');
		}
		// 캐시파일 함께 삭제
		FileHandler::removeFilesInDir('./files/cache/triggers');

		return $output;
	}
}

/* End of file profiler.admin.controller.php */
/* Location: ./modules/profiler/profiler.admin.controller.php */