/**
* @return GroupInterface
*/
protected function getGroup()
{
$groupId = $this->request->get('id', null);
if (!$groupId) {
$groupId = $this->requestParams->get('currentGroup', null);
}
$group = $this->groupRepository->find($groupId);
return $group;
}
/**
* {@inheritdoc}
*/
public function apply(DatasourceInterface $datasource, $field, $direction)
{
$groupId = $this->requestParams->get('currentGroup', null);
if (!$groupId) {
throw new \LogicException('The current product group must be configured');
}
$field = 'in_group_' . $groupId;
$datasource->getProductQueryBuilder()->addSorter($field, $direction);
}
/**
* {@inheritdoc}
*/
protected function prepareQuery(QueryBuilder $query, $rootAlias, $alias, $itemsType)
{
$entityId = $this->requestParams->get(self::ENTITY_PARAM, 0);
$query->where($rootAlias . '.mode <> :mode');
$query->setParameter('mode', ConfigModelManager::MODE_HIDDEN);
$query->innerJoin($rootAlias . '.entity', 'ce', 'WITH', 'ce.id=' . $entityId);
$query->addSelect('ce.id as entity_id');
return parent::prepareQuery($query, $rootAlias, $alias, $itemsType);
}
/**
* Add locale parameter to the querybuilder
*
* @param BuildAfter $event
*/
public function onBuildAfter(BuildAfter $event)
{
$datagrid = $event->getDatagrid();
$datasource = $datagrid->getDatasource();
$config = $datagrid->getAcceptor()->getConfig();
$localeParameter = $config->offsetGetByPath(self::LOCALE_PARAMETER);
if ($localeParameter && $datasource instanceof Datasource) {
$queryBuilder = $datasource->getQueryBuilder();
$queryBuilder->setParameter($localeParameter, $this->requestParams->get($localeParameter, null));
}
}
/**
* Adjust query for tag-results-grid (tag search result grid)
* after datasource has been built
*
* @param BuildAfter $event
*/
public function onBuildAfter(BuildAfter $event)
{
$datasource = $event->getDatagrid()->getDatasource();
if ($datasource instanceof OrmDatasource) {
/** @var QueryBuilder $query */
$queryBuilder = $datasource->getQueryBuilder();
$queryBuilder->setParameter('tag', $this->requestParams->get('tag_id', 0));
$searchEntity = $this->requestParams->get('from', '*');
if ($searchEntity != '*' && !empty($searchEntity)) {
$queryBuilder->andWhere('tt.alias = :alias')->setParameter('alias', $searchEntity);
}
}
}
/**
* Adjust query for tag-results-grid (tag search result grid)
* after datasource has been built
*
* @param BuildAfter $event
*/
public function onBuildAfter(BuildAfter $event)
{
$datasource = $event->getDatagrid()->getDatasource();
if ($datasource instanceof SearchDatasource) {
/** @var $query Query */
$query = new IndexerQuery($this->indexer, $this->indexer->select());
$searchEntity = $this->requestParams->get('from', '*');
$searchEntity = empty($searchEntity) ? '*' : $searchEntity;
$searchString = $this->requestParams->get('search', '');
$query->from($searchEntity)->andWhere(Indexer::TEXT_ALL_DATA_FIELD, '~', $searchString, 'text');
$datasource->setQuery($query);
}
}
/**
* Get user configured datagrid columns
*
* @return null|string[]
*/
protected function getUserGridColumns()
{
$params = $this->requestParams->get(RequestParameters::ADDITIONAL_PARAMETERS);
if (isset($params['view']) && isset($params['view']['columns'])) {
return explode(',', $params['view']['columns']);
}
return null;
}
/**
* @param BuildAfter $event
*/
public function onBuildAfter(BuildAfter $event)
{
$datasource = $event->getDatagrid()->getDatasource();
if ($datasource instanceof OrmDatasource) {
/** @var QueryBuilder $query */
$queryBuilder = $datasource->getQueryBuilder();
$queryParameters = array('objectClass' => str_replace('_', '\\', $this->requestParams->get(self::GRID_PARAM_CLASS, '')));
if (in_array('objectId', $this->paramsToBind)) {
$queryParameters['objectId'] = $this->requestParams->get(self::GRID_PARAM_OBJECT_ID, 0);
}
$fieldName = $this->requestParams->get(self::GRID_PARAM_FIELD_NAME, false);
if (!empty($fieldName) && in_array('fieldName', $this->paramsToBind)) {
$queryParameters['fieldName'] = $fieldName;
}
$queryBuilder->setParameters($queryParameters);
}
}
/**
* @return array
*/
protected function prepareParameters()
{
$queryParameters = [];
foreach ($this->paramNames as $paramName) {
$queryParameters[$paramName] = $this->requestParams->get($paramName, null);
}
if ($this->isEditMode) {
$params = $this->requestParams->get(RequestParameters::ADDITIONAL_PARAMETERS);
$queryParameters[self::GRID_PARAM_DATA_IN] = isset($params[self::GRID_PARAM_DATA_IN]) ? $params[self::GRID_PARAM_DATA_IN] : [0];
$queryParameters[self::GRID_PARAM_DATA_NOT_IN] = isset($params[self::GRID_PARAM_DATA_NOT_IN]) ? $params[self::GRID_PARAM_DATA_NOT_IN] : [0];
foreach ($this->paramNames as $paramName) {
if (isset($params[$paramName])) {
$queryParameters[$paramName] = $params[$paramName];
}
}
}
return $queryParameters;
}
/**
* Trying to get request param
* - first from current request query
* - then from master request attributes
*
* @param $paramName
* @param bool $default
* @return mixed
*/
protected function getRequestParam($paramName, $default = false)
{
$paramValue = $this->requestParams->get($paramName, $default);
if ($paramValue === false) {
$paramNameCamelCase = str_replace(' ', '', lcfirst(ucwords(str_replace('_', ' ', $paramName))));
$paramValue = $this->request->attributes->get($paramNameCamelCase, $default);
}
return $paramValue;
}
public function onBuildAfter(BuildAfter $event)
{
$datasource = $event->getDatagrid()->getDatasource();
if ($datasource instanceof OrmDatasource) {
/** @var QueryBuilder $query */
$queryBuilder = $datasource->getQueryBuilder();
$this->queryFactory->prepareQuery($queryBuilder);
if ($id = $this->requestParams->get('userId')) {
$user = $this->em->getRepository('OroUserBundle:User')->find($id);
// TODO: select imap configuration by userId
$origin = $user->getImapConfiguration();
$originId = $origin !== null ? $origin->getId() : 0;
if (array_key_exists('refresh', $this->requestParams->get(RequestParameters::ADDITIONAL_PARAMETERS)) && $originId) {
$this->imapSync->syncOrigins(array($originId));
}
} else {
$originId = 0;
// to make sure param bind passed
}
$queryBuilder->setParameter('origin_id', $originId);
}
}
/**
* @param BuildBefore $event
*/
public function onBuildBefore(BuildBefore $event)
{
$config = $event->getConfig();
$repositoryParameters = array('objectClass' => str_replace('_', '\\', $this->requestParams->get(self::GRID_PARAM_CLASS, '')), 'objectId' => $this->requestParams->get(self::GRID_PARAM_OBJECT_ID, 0));
$config->offsetSetByPath(sprintf(ContextConfigurator::SOURCE_PATH, ContextConfigurator::REPOSITORY_PARAMETERS_KEY), $repositoryParameters);
}
/**
* {@inheritdoc}
*/
public function getDatagridParameter($key, $defaultValue = null)
{
return $this->requestParams->get($key, $defaultValue);
}
/**
* Get the object class parameter from the request.
* It can be an empty string, a entity type (eg product, group, attribute) or an FQCN
*
* @return string
*/
protected function getObjectClassParameter()
{
return $this->requestParams->get(self::GRID_PARAM_CLASS, '');
}
