How do i change the Ecommerce Statistics information to a specific user?

Hi everyone!
I wonder how i can change the Ecommerce Statistics widget so it only shows the information that the seller is responsible for.

We have Magento integrated with OROcrm.
In Magento on the “Order” page we have a column that says “Sellers”. Our sellers use the dropdown menu to select themself as the seller and we can then filter it so the seller can see how much he/she has sold for.

I want the seller to be able to see this info on the Ecommerce Statistics widget.

Does anyone have an ide on how to fix this?
At the moment we only get all the orders but i would like to sort it up so the seller can view their own orders in Ecommerce Statistics widget.

Thank you and have a nice day!

Topic

[Yurii MuratovParticipant]

Hello, oliver3.

To do this, you can create your own widget based on the Ecommerce Statistics widget and modify queries that select data.

For example, if MagentoOrder entity have one-to-many relation to user and this relation called sellers, the code you have to implement may be the next:

– create own class MagentoSellerBigNumberProvider that extends MagentoBigNumberProvider in your bundle (in my example i use Acme\DemoBundle):

PHP

<?php namespace Acme\DemoBundle\Provider; use Doctrine\ORM\QueryBuilder; use Oro\Bundle\MagentoBundle\Provider\MagentoBigNumberProvider; use Oro\Bundle\SecurityBundle\Authentication\TokenAccessorInterface; class MagentoSellerBigNumberProvider extends MagentoBigNumberProvider { /** @var TokenAccessorInterface */ protected $tokenAccessor; /** * @param TokenAccessorInterface $tokenAccessor */ public function setTokenAccessor(TokenAccessorInterface $tokenAccessor) { $this->tokenAccessor = $tokenAccessor; } /** * {@inheritdoc */ public function getRevenueValues($dateRange) { list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt'); $qb = $this->getOrderRepository()->getRevenueValueQB(); $this->applyDateFiltering($qb, 'orders.createdAt', $start, $end); $this->addSellerLimitationToQuery($qb); $value = $this->aclHelper->apply($qb)->getOneOrNullResult(); return $value['val'] ? : 0; } /** * {@inheritdoc */ public function getOrdersNumberValues($dateRange) { list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt'); $qb = $this->getOrderRepository()->getOrdersNumberValueQB(); $this->applyDateFiltering($qb, 'o.createdAt', $start, $end); $this->addSellerLimitationToQuery($qb); $value = $this->aclHelper->apply($qb)->getOneOrNullResult(); return $value['val'] ? : 0; } /** * {@inheritdoc */ public function getAOVValues($dateRange) { list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt'); $qb = $this->getOrderRepository()->getAOVValueQB(); $this->applyDateFiltering($qb, 'o.createdAt', $start, $end); $this->addSellerLimitationToQuery($qb); $value = $this->aclHelper->apply($qb)->getOneOrNullResult(); return $value['ordersCount'] ? $value['revenue'] / $value['ordersCount'] : 0; } /** * {@inheritdoc */ public function getDiscountedOrdersPercentValues($dateRange) { list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt'); $qb = $this->getOrderRepository()->getDiscountedOrdersPercentQB(); $this->applyDateFiltering($qb, 'o.createdAt', $start, $end); $this->addSellerLimitationToQuery($qb); $value = $this->aclHelper->apply($qb)->getOneOrNullResult(); return $value['allOrders'] ? $value['discounted'] / $value['allOrders'] : 0; } /** * @param QueryBuilder $qb */ protected function addSellerLimitationToQuery(QueryBuilder $qb) { $qb->andWhere($qb->expr()->in('o.sellers', ':sellers')) ->setParameter('sellers', [$this->tokenAccessor->getUser()]); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89

<?php   namespace Acme\DemoBundle\Provider;   use Doctrine\ORM\QueryBuilder; use Oro\Bundle\MagentoBundle\Provider\MagentoBigNumberProvider; use Oro\Bundle\SecurityBundle\Authentication\TokenAccessorInterface;   class MagentoSellerBigNumberProvider extends MagentoBigNumberProvider {       /** @var TokenAccessorInterface */     protected $tokenAccessor;       /**      * @param TokenAccessorInterface $tokenAccessor      */     public function setTokenAccessor(TokenAccessorInterface $tokenAccessor)     {         $this->tokenAccessor = $tokenAccessor;     }       /**      * {@inheritdoc      */     public function getRevenueValues($dateRange)     {         list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt');           $qb = $this->getOrderRepository()->getRevenueValueQB();         $this->applyDateFiltering($qb, 'orders.createdAt', $start, $end);         $this->addSellerLimitationToQuery($qb);         $value = $this->aclHelper->apply($qb)->getOneOrNullResult();           return $value['val'] ? : 0;     }       /**      * {@inheritdoc      */     public function getOrdersNumberValues($dateRange)     {         list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt');         $qb = $this->getOrderRepository()->getOrdersNumberValueQB();         $this->applyDateFiltering($qb, 'o.createdAt', $start, $end);         $this->addSellerLimitationToQuery($qb);         $value = $this->aclHelper->apply($qb)->getOneOrNullResult();           return $value['val'] ? : 0;     }       /**      * {@inheritdoc      */     public function getAOVValues($dateRange)     {         list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt');           $qb = $this->getOrderRepository()->getAOVValueQB();         $this->applyDateFiltering($qb, 'o.createdAt', $start, $end);         $this->addSellerLimitationToQuery($qb);         $value = $this->aclHelper->apply($qb)->getOneOrNullResult();           return $value['ordersCount'] ? $value['revenue'] / $value['ordersCount'] : 0;     }       /**      * {@inheritdoc      */     public function getDiscountedOrdersPercentValues($dateRange)     {         list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroMagentoBundle:Order', 'createdAt');         $qb = $this->getOrderRepository()->getDiscountedOrdersPercentQB();         $this->applyDateFiltering($qb, 'o.createdAt', $start, $end);         $this->addSellerLimitationToQuery($qb);         $value = $this->aclHelper->apply($qb)->getOneOrNullResult();           return $value['allOrders'] ? $value['discounted'] / $value['allOrders'] : 0;     }       /**      * @param QueryBuilder $qb      */     protected function addSellerLimitationToQuery(QueryBuilder $qb)     {         $qb->andWhere($qb->expr()->in('o.sellers', ':sellers'))             ->setParameter('sellers', [$this->tokenAccessor->getUser()]);     } }

At this class i rewrite some of metrics methods from the parent class and add the limitation on seller relation with addSellerLimitationToQuery function.

– register this class as new big number (the type of widget) provider. In my example, the alias of this provider will be magento_seller:

YAML

oro_magento.provider.big_number_seller: class: Acme\DemoBundle\Provider\MagentoSellerBigNumberProvider arguments: - "@doctrine" - "@oro_security.acl_helper" - "@oro_dashboard.provider.big_number.date_helper" - "@oro_magento.provider.website_visit" calls: - ['setTokenAccessor', ['@oro_security.token_accessor']] tags: - { name: oro_dashboard.big_number.provider, alias: magento_seller }

1 2 3 4 5 6 7 8 9 10 11

oro_magento.provider.big_number_seller:         class: Acme\DemoBundle\Provider\MagentoSellerBigNumberProvider         arguments:             - "@doctrine"             - "@oro_security.acl_helper"             - "@oro_dashboard.provider.big_number.date_helper"             - "@oro_magento.provider.website_visit"         calls:             - ['setTokenAccessor', ['@oro_security.token_accessor']]         tags:             - { name: oro_dashboard.big_number.provider, alias: magento_seller }

– Add new widget declaration in dashboards.yml file. This widget is a copy of big_numbers_widget widget but with another label and data_provider parameters in items:

YAML

big_numbers_widget_seller: label: Ecommerce Seller statistics route: oro_dashboard_itemized_data_widget route_parameters: { bundle: OroDashboardBundle, name: bigNumbers } acl: oro_magento_cart_view description: oro.magento.dashboard.e_commerce_statistic.description icon: bundles/oromagento/img/icon-big_numbers.png applicable: "@oro_magento.provider.enitity_state->isEntityCartEnabled()" data_items: revenue: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getRevenueValues, currency)" label: oro.magento.dashboard.e_commerce_statistic.revenue.label acl: oro_magento_order_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig orders_number: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getOrdersNumberValues, integer)" label: oro.magento.dashboard.e_commerce_statistic.orders_number.label acl: oro_magento_order_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig discounted_orders_percent: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getDiscountedOrdersPercentValues, percent)" label: oro.magento.dashboard.e_commerce_statistic.discounted_orders_percent.label acl: oro_magento_order_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig new_customers_count: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getNewCustomersCountValues, integer)" label: oro.magento.dashboard.e_commerce_statistic.new_customers_count.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig returning_customers_count: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getReturningCustomersCountValues, integer)" label: oro.magento.dashboard.e_commerce_statistic.returning_customers_count.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig average_order_value: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAOVValues, currency)" label: oro.magento.dashboard.e_commerce_statistic.average_order_value.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig abandoned_revenue: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonedRevenueValues, currency, true)" label: oro.magento.dashboard.e_commerce_statistic.abandoned_revenue.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig abandoned_count: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonedCountValues, integer, true)" label: oro.magento.dashboard.e_commerce_statistic.abandoned_count.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig abandon_rate: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonRateValues, percent, true)" label: oro.magento.dashboard.e_commerce_statistic.abandon_rate.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig site_visits: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getSiteVisitsValues, integer)" label: oro.magento.dashboard.e_commerce_statistic.site_visits.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig order_conversion: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getOrderConversionValues, percent)" label: oro.magento.dashboard.e_commerce_statistic.order_conversion.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig customer_conversion: data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getCustomerConversionValues, percent)" label: oro.magento.dashboard.e_commerce_statistic.customer_conversion.label acl: oro_magento_customer_view template: OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig configuration: dateRange: type: Oro\Bundle\DashboardBundle\Form\Type\WidgetDateRangeType options: label: oro.dashboard.date_range.label value_types: true show_on_widget: true usePreviousInterval: type: Oro\Bundle\DashboardBundle\Form\Type\WidgetPreviousDateRangeType options: label: oro.dashboard.previous_date_range.label required: false converter_attributes: dateRangeField: dateRange default_checked: true subWidgets: type: Oro\Bundle\DashboardBundle\Form\Type\WidgetItemsType options: label: oro.dashboard.widget.big_number.metrics attr: placeholder: oro.dashboard.widget.big_number.choose_metrics_placeholder item_label: oro.dashboard.widget.big_number.metricName required: false widget_name: big_numbers_widget

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

big_numbers_widget_seller:             label:       Ecommerce Seller statistics             route:       oro_dashboard_itemized_data_widget             route_parameters: { bundle: OroDashboardBundle, name: bigNumbers }             acl:         oro_magento_cart_view             description: oro.magento.dashboard.e_commerce_statistic.description             icon:        bundles/oromagento/img/icon-big_numbers.png             applicable:  "@oro_magento.provider.enitity_state->isEntityCartEnabled()"             data_items:                 revenue:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getRevenueValues, currency)"                     label:         oro.magento.dashboard.e_commerce_statistic.revenue.label                     acl:           oro_magento_order_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 orders_number:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getOrdersNumberValues, integer)"                     label:         oro.magento.dashboard.e_commerce_statistic.orders_number.label                     acl:           oro_magento_order_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 discounted_orders_percent:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getDiscountedOrdersPercentValues, percent)"                     label:         oro.magento.dashboard.e_commerce_statistic.discounted_orders_percent.label                     acl:           oro_magento_order_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 new_customers_count:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getNewCustomersCountValues, integer)"                     label:         oro.magento.dashboard.e_commerce_statistic.new_customers_count.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 returning_customers_count:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getReturningCustomersCountValues, integer)"                     label:         oro.magento.dashboard.e_commerce_statistic.returning_customers_count.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 average_order_value:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAOVValues, currency)"                     label:         oro.magento.dashboard.e_commerce_statistic.average_order_value.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 abandoned_revenue:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonedRevenueValues, currency, true)"                     label:         oro.magento.dashboard.e_commerce_statistic.abandoned_revenue.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 abandoned_count:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonedCountValues, integer, true)"                     label:         oro.magento.dashboard.e_commerce_statistic.abandoned_count.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 abandon_rate:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getAbandonRateValues, percent, true)"                     label:         oro.magento.dashboard.e_commerce_statistic.abandon_rate.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 site_visits:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getSiteVisitsValues, integer)"                     label:         oro.magento.dashboard.e_commerce_statistic.site_visits.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 order_conversion:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getOrderConversionValues, percent)"                     label:         oro.magento.dashboard.e_commerce_statistic.order_conversion.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig                 customer_conversion:                     data_provider: "@oro_dashboard.provider.big_number.processor->getBigNumberValues($widgetOptions$, magento_seller, getCustomerConversionValues, percent)"                     label:         oro.magento.dashboard.e_commerce_statistic.customer_conversion.label                     acl:           oro_magento_customer_view                     template:      OroDashboardBundle:Dashboard:bigNumberSubwidget.html.twig             configuration:                 dateRange:                     type: Oro\Bundle\DashboardBundle\Form\Type\WidgetDateRangeType                     options:                        label: oro.dashboard.date_range.label                        value_types: true                     show_on_widget: true                 usePreviousInterval:                     type: Oro\Bundle\DashboardBundle\Form\Type\WidgetPreviousDateRangeType                     options:                        label: oro.dashboard.previous_date_range.label                        required: false                     converter_attributes:                         dateRangeField: dateRange                         default_checked: true                 subWidgets:                     type: Oro\Bundle\DashboardBundle\Form\Type\WidgetItemsType                     options:                         label: oro.dashboard.widget.big_number.metrics                         attr:                             placeholder: oro.dashboard.widget.big_number.choose_metrics_placeholder                         item_label: oro.dashboard.widget.big_number.metricName                         required: false                         widget_name: big_numbers_widget

– Clear the cache.

After that, you will be able to add new widget with title Ecommerce Seller statistics at your dashboard as well as standart Ecommerce Statistics widget.

[sfcable4seoParticipant]

thanks

[Author]

Replies