/** * {@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()); }