<?php

class module_mods_scBootstrap_sgbdJsonIndex extends abstract_moduleBuilder {

	protected $sModule = 'mods_scBootstrap_sgbdJsonIndex';
	protected $sModuleView = 'mods/scBootstrap/sgbdJsonIndex';

	public function _index() {

		if (_root::getParam('config') == '') {
			return $this->xmlindexselect();
		}

		module_builder::getTools()->rootAddConf('conf/connexion.ini.php');
		$msg = '';
		$detail = '';
		$tTables = array();
		$tTableColumn = array();

		$sConfig = _root::getParam('config');
		$tTables = module_builder::getTools()->getListTablesFromConfig($sConfig);
		$tTableColumn = array();
		foreach ($tTables as $sTable) {
			$tTableColumn[$sTable] = module_builder::getTools()->getListColumnFromConfigAndTable($sConfig, $sTable);
		}

		$tFileIndex = array();
		if (_root::getParam('sTable') != '') {
			$oDir = new _dir(_root::getConfigVar('path.generation') . _root::getParam('id') . '/data/json/base/' . _root::getParam('sTable') . '/index');
			if (!$oDir->exist()) {
				$oDir->save();
			}
			$tFile = array();
			foreach ($oDir->getListDir() as $oFile) {
				if (preg_match('/.index/', $oFile->getName()))
					$tFileIndex[] = $oFile->getName();
			}
		}

		if (_root::getParam('regenerateIndexXml') != '') {
			$this->regenerateIndexXml($sConfig, _root::getParam('sTable'), _root::getParam('regenerateIndexXml'));
		}


		if (_root::getRequest()->isPost()) {
			$sTable = _root::getParam('sTable');
			$tField = _root::getParam('tField');

			module_builder::getTools()->projetmkdir('data/json/base/' . $sTable . '/index');

			module_builder::getTools()->projetmkdir('data/json/base/' . $sTable . '/index/' . implode('.', $tField) . '.index');

			$this->regenerateIndexXml($sConfig, $sTable, implode('.', $tField) . '.index');

			$msg = trR('indexGenereAvecSucces', array('#listField#' => implode('.', $tField), '#maTable#' => $sTable));
			$detail = trR('creationRepertoire', array('#REPERTOIRE#' => 'data/json/base/' . $sTable . '/index'));
			$detail .= '<br />' . trR('creationRepertoire', array('#REPERTOIRE#' => 'index data/json/base/' . $sTable . '/index/' . implode('.', $tField)));
		}

		$oTpl = $this->getView('index');
		$oTpl->msg = $msg;
		$oTpl->detail = $detail;
		$oTpl->tTables = $tTables;
		$oTpl->tTableColumn = $tTableColumn;

		$oTpl->tFileIndex = $tFileIndex;
		return $oTpl;
	}

	private function xmlindexselect() {
		module_builder::getTools()->rootAddConf('conf/connexion.ini.php');

		$oTpl = $this->getView('indexselect');
		$oTpl->tConnexion = _root::getConfigVar('db');

		return $oTpl;
	}

	public function regenerateIndexXml($sConfig, $sTable, $sIndex) {
		//$sConfig='xml';

		if (_root::getConfigVar('db.' . $sConfig . '.sgbd') == 'xml') {
			if (!file_exists(_root::getConfigVar('db.' . $sConfig . '.database'))) {
				$sBuilderDbPath = _root::getConfigVar('path.data') . 'genere/' . _root::getParam('id') . '/public/' . _root::getConfigVar('db.' . $sConfig . '.database');
				if (file_exists($sBuilderDbPath)) {
					_root::setConfigVar('db.' . $sConfig . '.database', $sBuilderDbPath);
				} else {
					throw new Exception('Base inexistante ' . _root::getConfigVar('db.' . $sConfig . '.database') . ' ni ' . $sBuilderDbPath);
				}
			}
		} else if (_root::getConfigVar('db.' . $sConfig . '.sgbd') == 'csv') {
			if (!file_exists(_root::getConfigVar('db.' . $sConfig . '.database'))) {
				$sBuilderDbPath = _root::getConfigVar('path.data') . 'genere/' . _root::getParam('id') . '/public/' . _root::getConfigVar('db.' . $sConfig . '.database');
				if (file_exists($sBuilderDbPath)) {
					_root::setConfigVar('db.' . $sConfig . '.database', $sBuilderDbPath);
				} else {
					throw new Exception('Base inexistante ' . _root::getConfigVar('db.' . $sConfig . '.database') . ' ni ' . $sBuilderDbPath);
				}
			}
		} else if (_root::getConfigVar('db.' . $sConfig . '.sgbd') == 'json') {
			if (!file_exists(_root::getConfigVar('db.' . $sConfig . '.database'))) {
				$sBuilderDbPath = _root::getConfigVar('path.data') . 'genere/' . _root::getParam('id') . '/public/' . _root::getConfigVar('db.' . $sConfig . '.database');
				if (file_exists($sBuilderDbPath)) {
					_root::setConfigVar('db.' . $sConfig . '.database', $sBuilderDbPath);
				} else {
					throw new Exception('Base inexistante ' . _root::getConfigVar('db.' . $sConfig . '.database') . ' ni ' . $sBuilderDbPath);
				}
			}
		}


		$oModelFactory = new model_mkfbuilderfactory();
		$oModelFactory->setConfig($sConfig);
		return $oModelFactory->getSgbd()->generateIndexForTable($sTable, $sIndex);
	}

}