Пример #1
0
 /**
  * {@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();
 }
Пример #3
0
 /**
  * {@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');
 }
Пример #4
0
 /**
  * {@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());
 }
Пример #5
0
 /**
  * {@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');
 }
Пример #8
0
 /**
  * {@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());
 }