/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->groupBy('shop.id');
}
/**
* {@inheritdoc}
*/
public function getDictionaryTranslations()
{
$qb = parent::getQueryBuilder()->leftJoin('WellCommerce\\Bundle\\DictionaryBundle\\Entity\\DictionaryTranslation', 'dictionary_translation', 'WITH', 'dictionary.id = dictionary_translation.translatable')->groupBy('dictionary.identifier, dictionary_translation.locale')->select('dictionary.identifier,dictionary_translation.locale,dictionary_translation.translation');
$query = $qb->getQuery();
return $query->getArrayResult();
}
/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->groupBy('producer.id')->leftJoin('WellCommerce\\Bundle\\ProducerBundle\\Entity\\ProducerTranslation', 'producer_translation', 'WITH', 'producer.id = producer_translation.translatable AND producer_translation.locale = :locale');
}
/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->groupBy('tax.id')->leftJoin('WellCommerce\\Bundle\\TaxBundle\\Entity\\TaxTranslation', 'tax_translation', 'WITH', 'tax.id = tax_translation.translatable AND tax_translation.locale = :locale')->setParameter('locale', $this->getCurrentLocale());
}
/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->groupBy('unit.id')->leftJoin('WellCommerce\\Bundle\\UnitBundle\\Entity\\UnitTranslation', 'unit_translation', 'WITH', 'unit.id = unit_translation.translatable AND unit_translation.locale = :locale');
}
/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->groupBy('availability.id')->leftJoin('WellCommerce\\Bundle\\AvailabilityBundle\\Entity\\AvailabilityTranslation', 'availability_translation', 'WITH', 'availability.id = availability_translation.translatable AND availability_translation.locale = :locale');
}
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->leftJoin('WellCommerce\\Bundle\\ClientBundle\\Entity\\ClientGroupTranslation', 'client_group_translation', 'WITH', 'client_group.id = client_group_translation.translatable AND client_group_translation.locale = :locale');
}
/**
* {@inheritdoc}
*/
public function getDataGridQueryBuilder()
{
return parent::getQueryBuilder()->leftJoin('WellCommerce\\Bundle\\ContactBundle\\Entity\\ContactTranslation', 'contact_translation', 'WITH', 'contact.id = contact_translation.translatable AND contact_translation.locale = :locale')->setParameter('locale', $this->getCurrentLocale());
}