/**
* @param FieldConfigId $field
* @param array $columnOptions
*/
protected function prepareColumnOptions(FieldConfigId $field, array &$columnOptions)
{
$fieldName = $field->getFieldName();
// if field is visible as mandatory it is required in grid settings and rendered
// and not required and hidden by default otherwise.
$isMandatory = $this->getFieldConfig('datagrid', $field)->get('is_visible') === DatagridScope::IS_VISIBLE_MANDATORY;
$columnOptions = [DatagridGuesser::FORMATTER => ['label' => $this->getFieldConfig('entity', $field)->get('label') ?: $fieldName, 'renderable' => $isMandatory, 'required' => $isMandatory], DatagridGuesser::SORTER => ['data_name' => $fieldName], DatagridGuesser::FILTER => ['data_name' => $fieldName, 'enabled' => false]];
$this->datagridGuesser->applyColumnGuesses($field->getClassName(), $fieldName, $field->getFieldType(), $columnOptions);
}
/**
* @param FieldConfigId $field
* @param array $columnOptions
*/
protected function prepareColumnOptions(FieldConfigId $field, array &$columnOptions)
{
$fieldName = $field->getFieldName();
// if field is "visible as mandatory" it is required in grid settings and rendered
// if field is just "visible" it's rendered by default and manageable in grid settings
// otherwise - not required and hidden by default.
$gridVisibilityValue = $this->getFieldConfig('datagrid', $field)->get('is_visible');
$isRequired = $gridVisibilityValue === DatagridScope::IS_VISIBLE_MANDATORY;
$isRenderable = $isRequired ?: $gridVisibilityValue === DatagridScope::IS_VISIBLE_TRUE;
$columnOptions = [DatagridGuesser::FORMATTER => ['label' => $this->getFieldConfig('entity', $field)->get('label') ?: $fieldName, 'renderable' => $isRenderable, 'required' => $isRequired], DatagridGuesser::SORTER => ['data_name' => $fieldName], DatagridGuesser::FILTER => ['data_name' => $fieldName, 'enabled' => false]];
$this->datagridGuesser->applyColumnGuesses($field->getClassName(), $fieldName, $field->getFieldType(), $columnOptions);
}
/**
* {@inheritdoc}
*/
protected function addSelectColumn($entityClassName, $tableAlias, $fieldName, $columnExpr, $columnAlias, $columnLabel, $functionExpr, $functionReturnType, $isDistinct = false)
{
if ($isDistinct) {
$columnExpr = 'DISTINCT ' . $columnExpr;
}
if ($functionExpr !== null) {
$functionExpr = $this->prepareFunctionExpression($functionExpr, $tableAlias, $fieldName, $columnExpr, $columnAlias);
}
$this->selectColumns[] = sprintf('%s as %s', $functionExpr !== null ? $functionExpr : $columnExpr, $columnAlias);
$fieldType = $functionReturnType;
if ($fieldType === null) {
$fieldType = $this->getFieldType($entityClassName, $fieldName);
}
$columnOptions = [DatagridGuesser::FORMATTER => ['label' => $columnLabel, 'translatable' => false], DatagridGuesser::SORTER => ['data_name' => $columnAlias], DatagridGuesser::FILTER => ['data_name' => $this->getFilterByExpr($entityClassName, $tableAlias, $fieldName, $columnAlias), 'translatable' => false]];
if ($functionExpr !== null) {
$columnOptions[DatagridGuesser::FILTER][FilterUtility::BY_HAVING_KEY] = true;
}
$this->datagridGuesser->applyColumnGuesses($entityClassName, $fieldName, $fieldType, $columnOptions);
$this->datagridGuesser->setColumnOptions($this->config, $columnAlias, $columnOptions);
}
public function testApplyColumnGuesses()
{
$class = 'TestClass';
$property = 'testProp';
$type = 'integer';
$guesser1 = $this->getMock('Oro\\Bundle\\DataGridBundle\\Datagrid\\ColumnOptionsGuesserInterface');
$guesser2 = $this->getMock('Oro\\Bundle\\DataGridBundle\\Datagrid\\ColumnOptionsGuesserInterface');
$formatterGuess = new ColumnGuess(['formatter_prop1' => 'prop1', 'formatter_prop2' => 'prop2'], ColumnGuess::LOW_CONFIDENCE);
$sorterGuess = new ColumnGuess(['sorter_prop1' => 'prop1', 'sorter_prop2' => 'prop2'], ColumnGuess::LOW_CONFIDENCE);
$filterGuess = new ColumnGuess(['filter_prop1' => 'prop1', 'filter_prop2' => 'prop2'], ColumnGuess::LOW_CONFIDENCE);
$container = new ContainerBuilder();
$container->set('guesser1', $guesser1);
$container->set('guesser2', $guesser2);
$guesser1->expects($this->once())->method('guessFormatter')->with($class, $property, $type)->will($this->returnValue(null));
$guesser2->expects($this->once())->method('guessFormatter')->with($class, $property, $type)->will($this->returnValue($formatterGuess));
$guesser1->expects($this->once())->method('guessSorter')->with($class, $property, $type)->will($this->returnValue(null));
$guesser2->expects($this->once())->method('guessSorter')->with($class, $property, $type)->will($this->returnValue($sorterGuess));
$guesser1->expects($this->once())->method('guessFilter')->with($class, $property, $type)->will($this->returnValue(null));
$guesser2->expects($this->once())->method('guessFilter')->with($class, $property, $type)->will($this->returnValue($filterGuess));
$datagridGuesser = new DatagridGuesser($container, ['guesser1', 'guesser2']);
$columnOptions = [DatagridGuesser::FORMATTER => ['formatter_prop1' => 'prop1_initial', 'formatter_prop3' => 'prop3_initial'], DatagridGuesser::SORTER => ['sorter_prop1' => 'prop1_initial', 'sorter_prop3' => 'prop1_initial'], DatagridGuesser::FILTER => ['filter_prop1' => 'prop1_initial', 'filter_prop3' => 'prop3_initial']];
$datagridGuesser->applyColumnGuesses($class, $property, $type, $columnOptions);
$this->assertEquals([DatagridGuesser::FORMATTER => ['formatter_prop1' => 'prop1_initial', 'formatter_prop2' => 'prop2', 'formatter_prop3' => 'prop3_initial'], DatagridGuesser::SORTER => ['sorter_prop1' => 'prop1_initial', 'sorter_prop2' => 'prop2', 'sorter_prop3' => 'prop1_initial'], DatagridGuesser::FILTER => ['filter_prop1' => 'prop1_initial', 'filter_prop2' => 'prop2', 'filter_prop3' => 'prop3_initial']], $columnOptions);
}
/**
* @param FieldConfigId $field
* @param array $columnOptions
*/
protected function prepareColumnOptions(FieldConfigId $field, array &$columnOptions)
{
$fieldName = $field->getFieldName();
$columnOptions = [DatagridGuesser::FORMATTER => ['label' => $this->getFieldConfig('entity', $field)->get('label') ?: $fieldName], DatagridGuesser::SORTER => ['data_name' => $fieldName], DatagridGuesser::FILTER => ['data_name' => $fieldName, 'enabled' => false]];
$this->datagridGuesser->applyColumnGuesses($field->getClassName(), $fieldName, $field->getFieldType(), $columnOptions);
}