/** * Funkce pro export pole s informacemi z DataDictionary a TransformationDictionary * @param Datasource $datasource * @param Metasource|null $metasource * @return array */ public function exportDictionariesArr(Datasource $datasource, Metasource $metasource = null) { $this->databasesFacade->openDatabase($datasource->getDbConnection()); $output = array('dataDictionary' => array(), 'transformationDictionary' => array(), 'recordCount' => $this->databasesFacade->getRowsCount($datasource->dbTable)); #region datafields foreach ($datasource->datasourceColumns as $datasourceColumn) { $output['dataDictionary'][$datasourceColumn->name] = $datasourceColumn->type == DatasourceColumn::TYPE_STRING ? 'string' : 'integer'; //TODO kontrola, jaké má smysl vracet datové typy.... } #endregion datafields #region atributy if (!empty($metasource) && !empty($metasource->attributes)) { $this->databasesFacade->openDatabase($metasource->getDbConnection()); foreach ($metasource->attributes as $attribute) { $valuesArr = array(); try { $valuesStatistics = $this->databasesFacade->getColumnValuesStatistic($metasource->attributesTable, $attribute->name, true); if (!empty($valuesStatistics->valuesArr)) { foreach ($valuesStatistics->valuesArr as $value => $count) { $valuesArr[] = $value; } } } catch (\Exception $e) { } $output['transformationDictionary'][$attribute->name] = array('choices' => $valuesArr); } } #endregion atributy return $output; }
/** * Formulář pro vytvoření nového formátu * @return Form */ protected function createComponentNewFormatForm() { $form = new Form(); $form->addHidden('datasource'); $form->addHidden('column'); $metaAttribute = $form->addHidden('metaAttribute'); $form->addText('metaAttributeName', 'Meta-attribute:')->setAttribute('readonly', 'readonly')->setAttribute('class', 'normalWidth'); $formatName = $form->addText('formatName', 'Format name:')->setRequired()->setAttribute('class', 'normalWidth'); $formatName->addRule(Form::MIN_LENGTH, 'Min length of format name is %s characters!', 3); $formatName->addRule(function (TextInput $control) use($metaAttribute) { try { $format = $this->metaAttributesFacade->findFormatByName($metaAttribute->value, $control->value); ///XXX if ($format instanceof Format) { return false; } } catch (\Exception $e) { /*chybu ignorujeme (nenalezený metaatribut je OK)*/ } return true; }, 'Format with this name already exists!'); $form->addCheckbox('formatShared', 'Create shared (standard) format'); $form->addSelect('formatType', 'Values range:', array('interval' => 'Continuous values (interval)', 'values' => 'Distinct values (enumeration)'))->setAttribute('class', 'normalWidth')->setDefaultValue('values'); $submit = $form->addSubmit('create', 'Create format'); $submit->setValidationScope(array($formatName)); $submit->onClick[] = function (SubmitButton $button) { $values = $button->form->values; try { $datasourceColumn = $this->datasourcesFacade->findDatasourceColumn($values->datasource, $values->column); $metaAttribute = $this->metaAttributesFacade->findMetaAttribute($values->metaAttribute); $datasource = $this->datasourcesFacade->findDatasource($values->datasource); $this->databasesFacade->openDatabase($datasource->getDbConnection()); $datasourceColumnValuesStatistic = $this->databasesFacade->getColumnValuesStatistic($datasource->dbTable, $datasourceColumn->name); $format = $this->metaAttributesFacade->createFormatFromDatasourceColumn($metaAttribute, $values->formatName, $datasourceColumn, $datasourceColumnValuesStatistic, @$values->formatType, @$values->formatShared); $datasourceColumn->format = $format; $this->datasourcesFacade->saveDatasourceColumn($datasourceColumn); } catch (\Exception $e) { $this->flashMessage($this->translator->translate('Format creation failed.')); } $this->redirect('Close'); }; $storno = $form->addSubmit('storno', 'Storno'); $storno->setValidationScope(array()); $storno->onClick[] = function (SubmitButton $button) { $values = $button->form->values; $this->redirect('SelectFormat', array('datasource' => $values->datasource, 'column' => $values->column, 'metaAttribute' => $values->metaAttribute)); }; $form->onError[] = function (Form $form) { $values = $form->values; $this->handleNewFormat($values->datasource, $values->column, $values->metaAttribute); }; return $form; }
/** * Akce pro vykreslení histogramu z hodnot konkrétního sloupce v DB * @param int $datasource = null * @param int $miner = null * @param string $columnName * @param string $mode = 'default'|'component'|'iframe' * @throws BadRequestException * @throws \Nette\Application\ApplicationException * @throws \Nette\Application\ForbiddenRequestException */ public function renderColumnHistogram($datasource = null, $miner = null, $columnName, $mode = 'default') { if ($miner) { $miner = $this->findMinerWithCheckAccess($miner); $datasource = $miner->datasource; } elseif ($datasource) { $datasource = $this->datasourcesFacade->findDatasource($datasource); $this->checkDatasourceAccess($datasource); } if (!$datasource) { throw new BadRequestException('Requested data not specified!'); } $this->databasesFacade->openDatabase($datasource->getDbConnection()); $this->template->dbColumnValuesStatistic = $this->databasesFacade->getColumnValuesStatistic($datasource->dbTable, $columnName); if ($this->isAjax() || $mode == 'component' || $mode == 'iframe') { $this->layout = 'iframe'; $this->template->layout = $this->layout; } }