Magento Extensions Rating 2024
EXTENSIONS BY CATEGORY
B2B (Business-To-Business)
Blog
Customer
ERP (Enterprise Resource Planning)
Mega Menu
One Step Checkout
Order
POS (Point Of Sale)
Search
Shopping Cart
Sitemap
SEO
Social
Stock & Inventory Management
EXTENSIONS BY DEVELOPER
aheadWorks
Amasty
Boost My Shop
BSS Commerce
Magestore
MageWorx
Mirasvit
Templates Master
Wyomind
XTENTO
Magento 2 Documentation
Magento 2 Documentation
2.3
Documentation for Magento 2 CMS v2.3 (December 2018)
vendor
magento
module-review
Model
ResourceModel
Review
Summary.php
Go to the documentation of this file.
1
<?php
6
namespace
Magento\Review\Model\ResourceModel\Review
;
7
8
use
Magento\Framework\Model\AbstractModel
;
9
15
class
Summary
extends
\Magento\Framework\Model\ResourceModel\Db\AbstractDb
16
{
22
protected
function
_construct
()
23
{
24
$this->
_init
(
'review_entity_summary'
,
'entity_pk_value'
);
25
}
26
35
protected
function
_getLoadSelect
($field,
$value
, $object)
36
{
37
$select
= parent::_getLoadSelect($field,
$value
, $object);
38
$select
->where(
'store_id = ?'
, (
int
)$object->getStoreId());
39
return
$select
;
40
}
41
48
public
function
reAggregate
($summary)
49
{
50
$connection
= $this->
getConnection
();
51
$select
=
$connection
->select()->from(
52
$this->
getMainTable
(),
53
[
'primary_id'
=>
new
\
Zend_Db_Expr
(
'MAX(primary_id)'
),
'store_id'
,
'entity_pk_value'
]
54
)->group(
55
[
'entity_pk_value'
,
'store_id'
]
56
);
57
foreach
(
$connection
->fetchAll(
$select
) as
$row
) {
58
if
(isset($summary[
$row
[
'store_id'
]]) && isset($summary[
$row
[
'store_id'
]][
$row
[
'entity_pk_value'
]])) {
59
$summaryItem = $summary[
$row
[
'store_id'
]][
$row
[
'entity_pk_value'
]];
60
if
($summaryItem->getCount()) {
61
$ratingSummary = round($summaryItem->getSum() / $summaryItem->getCount());
62
}
else
{
63
$ratingSummary = $summaryItem->getSum();
64
}
65
}
else
{
66
$ratingSummary = 0;
67
}
68
$connection
->update(
69
$this->
getMainTable
(),
70
[
'rating_summary'
=> $ratingSummary],
71
$connection
->quoteInto(
'primary_id = ?'
,
$row
[
'primary_id'
])
72
);
73
}
74
return
$this;
75
}
76
}
Magento\Review\Model\ResourceModel\Review\Summary\_getLoadSelect
_getLoadSelect($field, $value, $object)
Definition:
Summary.php:35
Magento\Framework\Model\ResourceModel\Db\AbstractDb\getMainTable
getMainTable()
Definition:
AbstractDb.php:264
Magento\Framework\Model\AbstractModel
Definition:
AbstractModel.php:19
Magento\Review\Model\ResourceModel\Review\Summary\reAggregate
reAggregate($summary)
Definition:
Summary.php:48
Magento\Review\Model\ResourceModel\Review
Magento\Framework\Model\ResourceModel\Db\AbstractDb\_init
_init($mainTable, $idFieldName)
Definition:
AbstractDb.php:186
Zend_Db_Expr
Definition:
Expr.php:49
$select
$select
Definition:
catalog_rule_10_off_not_logged_rollback.php:14
$value
$value
Definition:
gender.phtml:16
Magento\Review\Model\ResourceModel\Review\Summary
Definition:
Summary.php:15
Magento\Review\Model\ResourceModel\Review\Summary\_construct
_construct()
Definition:
Summary.php:22
Magento\Framework\Model\ResourceModel\Db\AbstractDb
Definition:
AbstractDb.php:24
$connection
$connection
Definition:
bulk.php:13
Magento\Framework\Model\ResourceModel\Db\AbstractDb\getConnection
getConnection()
Definition:
AbstractDb.php:325
$row
$row
Definition:
cart_rule_free_shipping.php:12