--
-- 테이블 구조 `language`
--

CREATE TABLE `language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `nation` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

class MY_Lang extends MX_Lang {

	var $language    = array();
	var $is_loaded    = array();
	var $idiom;
	var $set;

	var $line;
	var $CI;

	function __construct() {
		parent::__construct();
		log_message('debug', "HMVC Language");
	}
	
	public function load($langfile = array(), $lang = '', $return = FALSE, $add_suffix = TRUE, $alt_path = '', $_module = '')   {
		
		if (is_array($langfile)) {
			foreach($langfile as $_lang) $this->load($_lang);
			return $this->language;
		}
			
		$deft_lang = CI::$APP->config->item('language');
		$idiom = ($lang == '') ? $deft_lang : $lang;

		//앱폴더 검색.
		if (in_array($langfile.'_lang'.EXT, $this->is_loaded, TRUE)) {
			return $this->language;
		}
		
		//시스템폴더 검색.
		if (file_exists(BASEPATH."language/".$idiom.'/'.$langfile.'_lang'.EXT)) {
			
			include(BASEPATH."language/".$idiom.'/'.$langfile.'_lang'.EXT);
			$this->is_loaded[] = BASEPATH."language/".$idiom.'/'.$langfile.'_lang'.EXT;
			$this->language = array_merge($this->language, $lang);
			unset($lang);

			log_message('debug', 'Language file loaded: language/'.$idiom.'/'.$langfile);
			return $this->language;
		}

		//모듈폴더 검색.
		$_module OR $_module = CI::$APP->router->fetch_module();
		list($path, $_langfile) = Modules::find($langfile.'_lang', $_module, 'language/'.$idiom.'/');

		if ($path === FALSE) {
			
			//모듈 폴더까지 파일이 없고 디비까지 체크해주자.
			$database_lang =  $this->_get_from_db($langfile, $idiom);
			if (!empty($database_lang)) {
				$lang = $database_lang;
				$this->language = array_merge($this->language, $lang);
				$this->is_loaded[] = $langfile.'_lang'.EXT;
				return $lang;
			}

			//재귀 호출.
			if ($lang = parent::load($langfile, $lang, $return, $add_suffix, $alt_path)) return $lang;
		
		} else {

			if($lang = Modules::load_file($_langfile, $path, 'lang')) {
				if ($return) return $lang;
				$this->language = array_merge($this->language, $lang);
				$this->is_loaded[] = $langfile.'_lang'.EXT;
				unset($lang);
			}
		}
		
		return $this->language;
	}

	/**
	 * Load a language from database
	 *
	 * @access    private
	 * @return    array
	 */
	private function _get_from_db($langfile, $idiom)
	{
		$return = array();
		$CI =& get_instance();
		log_message('debug', "이거슨 디비에...".$langfile.'/'.$idiom);
		$CI->db->select   ('*');
		$CI->db->from     ('language');
		$CI->db->where    ('nation', $idiom);
		$CI->db->where    ('filename', $langfile);

		$query = $CI->db->get()->result();

		foreach ( $query as $row )
		{
			$return[$row->code] = $row->value;
			log_message('debug', "주입중...");
		}

		unset($CI, $query);
		return $return;
	}
}