/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'producer.id', 'name' => 'producer_translation.name', 'route' => 'IDENTITY(producer_translation.route)', 'products' => 'COUNT(producer_products.id)']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'cart_product.id', 'price' => 'IF_ELSE(cart_product.attribute IS NOT NULL, product_attribute.sellPrice.grossAmount, product.sellPrice.grossAmount)', 'discountedPrice' => 'IF_ELSE(cart_product.attribute IS NOT NULL, product_attribute.sellPrice.discountedGrossAmount, product.sellPrice.discountedGrossAmount)', 'currency' => 'IF_ELSE(cart_product.attribute IS NOT NULL, product_attribute.sellPrice.currency, product.sellPrice.currency)', 'stock' => 'IF_ELSE(cart_product.attribute IS NOT NULL, product_attribute.stock, product.stock)', 'weight' => 'IF_ELSE(cart_product.attribute IS NOT NULL, product_attribute.weight, product.weight)', 'quantity' => 'cart_product.quantity', 'attribute' => 'IDENTITY(cart_product.attribute)', 'name' => 'product_translation.name', 'route' => 'IDENTITY(product_translation.route)', 'isDiscountValid' => 'IF_ELSE(:date BETWEEN product.sellPrice.validFrom AND product.sellPrice.validTo, 1, 0)', 'tax' => 'sell_tax.value', 'photo' => 'photos.path']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'client_group.id', 'name' => 'client_group_translation.name', 'totalClients' => 'COUNT(client)']);
}
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'order_product.id', 'price' => 'IF_ELSE(order_product.variant IS NOT NULL, product_variant.sellPrice.grossAmount, product.sellPrice.grossAmount)', 'discountedPrice' => 'IF_ELSE(order_product.variant IS NOT NULL, product_variant.sellPrice.discountedGrossAmount, product.sellPrice.discountedGrossAmount)', 'currency' => 'IF_ELSE(order_product.variant IS NOT NULL, product_variant.sellPrice.currency, product.sellPrice.currency)', 'stock' => 'IF_ELSE(order_product.variant IS NOT NULL, product_variant.stock, product.stock)', 'weight' => 'IF_ELSE(order_product.variant IS NOT NULL, product_variant.weight, product.weight)', 'quantity' => 'order_product.quantity', 'variant' => 'IDENTITY(order_product.variant)', 'options' => 'order_product.options', 'name' => 'product_translation.name', 'route' => 'IDENTITY(product_translation.route)', 'isDiscountValid' => 'IF_ELSE(:date BETWEEN product.sellPrice.validFrom AND product.sellPrice.validTo, 1, 0)', 'tax' => 'sell_tax.value', 'photo' => 'photos.path']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
$configurator->setCacheOptions(new CacheOptions(true, 3600, [Order::class, OrderProduct::class, Product::class, Variant::class, Tax::class]));
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'product_status.id', 'name' => 'product_status_translation.name', 'route' => 'IDENTITY(product_status_translation.route)', 'css_class' => 'product_status_translation.cssClass']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'tax.id', 'name' => 'tax_translation.name', 'value' => 'tax.value']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'package.id', 'name' => 'package.name', 'fullName' => 'package.fullName', 'vendor' => 'package.vendor', 'localVersion' => 'package.localVersion', 'remoteVersion' => 'package.remoteVersion', 'createdAt' => 'package.createdAt', 'updatedAt' => 'package.updatedAt']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s']), 'updatedAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s']), 'localVersion' => $this->getDataSetTransformer('package_version_reference'), 'remoteVersion' => $this->getDataSetTransformer('package_version_reference')]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'attribute.id', 'name' => 'attribute_translation.name', 'groups' => 'GROUP_CONCAT(DISTINCT attribute_groups_translation.name ORDER BY attribute_groups_translation.name ASC SEPARATOR \', \')']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'layout_box.id', 'name' => 'layout_box_translation.name', 'identifier' => 'layout_box.identifier', 'boxType' => 'layout_box.boxType']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'review.id', 'nick' => 'review.nick', 'rating' => 'review.rating', 'createdAt' => 'review.createdAt', 'product' => 'product_translation.name']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'user.id', 'username' => 'user.username', 'name' => 'CONCAT(user.firstName,\' \', user.lastName)', 'first_name' => 'user.firstName', 'last_name' => 'user.lastName', 'email' => 'user.email', 'enabled' => 'user.enabled']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'company.id', 'name' => 'company.name', 'shortName' => 'company.shortName', 'createdAt' => 'company.createdAt']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns([]);
}
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'category.id', 'hierarchy' => 'category.hierarchy', 'enabled' => 'category.enabled', 'parent' => 'IDENTITY(category.parent)', 'children_count' => 'category.childrenCount', 'products_count' => 'category.productsCount', 'name' => 'category_translation.name', 'slug' => 'category_translation.slug', 'shop' => 'category_shops.id', 'route' => 'IDENTITY(category_translation.route)']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
$configurator->setCacheOptions(new CacheOptions(true, 3600, [Category::class, CategoryInterface::class, CategoryTranslation::class]));
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'shipping_method.id', 'name' => 'shipping_method_translation.name', 'calculator' => 'shipping_method.calculator', 'hierarchy' => 'shipping_method.hierarchy']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'channel.id', 'name' => 'channel.name', 'url' => 'channel.url', 'createdAt' => 'channel.createdAt', 'updatedAt' => 'channel.updatedAt']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s']), 'updatedAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'category.id', 'hierarchy' => 'category.hierarchy', 'enabled' => 'category.enabled', 'parent' => 'IDENTITY(category.parent)', 'children' => 'COUNT(category_children.id)', 'products' => 'COUNT(category_products.id)', 'name' => 'category_translation.name', 'slug' => 'category_translation.slug', 'shop' => 'category_shops.id', 'route' => 'IDENTITY(category_translation.route)']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'shop.id', 'name' => 'shop.name', 'url' => 'shop.url', 'theme' => 'shop_theme.name', 'company' => 'shop_company.name', 'currency' => 'shop.defaultCurrency', 'country' => 'shop.defaultCountry']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'coupon.id', 'name' => 'coupon_translation.name', 'code' => 'coupon.code', 'createdAt' => 'coupon.createdAt', 'validFrom' => 'coupon.validFrom', 'validTo' => 'coupon.validTo', 'discount' => 'IF_ELSE(coupon.modifierType = \'%\', CONCAT_WS(\'\', coupon.modifierValue, coupon.modifierType), CONCAT_WS(\' \', coupon.modifierValue, coupon.currency))']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s']), 'validFrom' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d']), 'validTo' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'media.id', 'name' => 'media.name', 'mime' => 'media.mime', 'extension' => 'media.extension', 'size' => 'media.size', 'preview' => 'media.path']);
$configurator->setColumnTransformers(['preview' => $this->getDataSetTransformer('image_path', ['filter' => 'medium'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'product.id', 'name' => 'product_translation.name', 'shortDescription' => 'product_translation.shortDescription', 'description' => 'product_translation.description', 'route' => 'IDENTITY(product_translation.route)', 'weight' => 'product.weight', 'price' => 'product.sellPrice.grossAmount', 'discountedPrice' => 'product.sellPrice.discountedGrossAmount', 'isDiscountValid' => 'IF_ELSE(:date BETWEEN product.sellPrice.validFrom AND product.sellPrice.validTo, 1, 0)', 'finalPrice' => 'IF_ELSE(:date BETWEEN product.sellPrice.validFrom AND product.sellPrice.validTo, product.sellPrice.discountedGrossAmount, product.sellPrice.grossAmount) * currency_rate.exchangeRate', 'currency' => 'product.sellPrice.currency', 'tax' => 'sell_tax.value', 'stock' => 'product.stock', 'producerId' => 'IDENTITY(product.producer)', 'producerName' => 'producers_translation.name', 'category' => 'categories.id', 'shop' => 'product_shops.id', 'photo' => 'photos.path', 'status' => 'statuses.id', 'score' => 'FIELD(product.id, :scores)']);
$configurator->setColumnTransformers(['route' => $this->getDataSetTransformer('route')]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'currency.id', 'code' => 'currency.code']);
$this->setDefaultRequestOption('order_by', 'code');
}
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'currency.id', 'code' => 'currency.code']);
$this->setDefaultRequestOption('order_by', 'code');
$configurator->setCacheOptions(new CacheOptions(true, 3600, [Currency::class]));
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'deliverer.id', 'name' => 'deliverer_translation.name']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'dictionary.id', 'identifier' => 'dictionary.identifier', 'translation' => 'dictionary_translation.value', 'locale' => 'dictionary_translation.locale']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'page.id', 'parent' => 'IDENTITY(page.parent)', 'children' => 'page_translation.name', 'name' => 'page_translation.name', 'slug' => 'page_translation.slug', 'locale' => 'page_translation.locale', 'route' => 'IDENTITY(page_translation.route)', 'publish' => 'page.publish', 'shop' => 'page_shops.id', 'hierarchy' => 'page.hierarchy']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'availability.id', 'name' => 'availability_translation.name']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'client.id', 'firstName' => 'client.contactDetails.firstName', 'lastName' => 'client.contactDetails.lastName', 'email' => 'client.contactDetails.email', 'phone' => 'client.contactDetails.phone', 'groupName' => 'client_group_translation.name', 'createdAt' => 'client.createdAt']);
$configurator->setColumnTransformers(['createdAt' => $this->getDataSetTransformer('date', ['format' => 'Y-m-d H:i:s'])]);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'product.id', 'name' => 'product_translation.name', 'sku' => 'product.sku', 'weight' => 'product.weight', 'grossAmount' => 'product.sellPrice.grossAmount', 'stock' => 'product.stock', 'shop' => 'product_shops.id', 'tax' => 'sell_tax.value', 'category' => 'GROUP_CONCAT(DISTINCT categories_translation.name ORDER BY categories_translation.name ASC SEPARATOR \', \')']);
}
/**
* {@inheritdoc}
*/
public function configureOptions(DataSetConfiguratorInterface $configurator)
{
$configurator->setColumns(['id' => 'product_status.id', 'name' => 'product_status_translation.name']);
}
