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-swatches
Setup
Patch
Data
UpdateAdminTextSwatchValues.php
Go to the documentation of this file.
1
<?php
7
namespace
Magento\Swatches\Setup\Patch\Data
;
8
9
use
Magento\Store\Model\Store
;
10
use
Magento\Swatches\Model\Swatch
;
11
use
Zend_Db
;
12
use
Zend_Db_Expr
;
13
use
Magento\Framework\App\ResourceConnection
;
14
use
Magento\Framework\Setup\Patch\DataPatchInterface
;
15
use
Magento\Framework\Setup\Patch\PatchVersionInterface
;
16
21
class
UpdateAdminTextSwatchValues
implements
DataPatchInterface
,
PatchVersionInterface
22
{
26
private
$moduleDataSetup;
27
32
public
function
__construct
(
33
\
Magento
\Framework\Setup\ModuleDataSetupInterface $moduleDataSetup
34
) {
35
$this->moduleDataSetup = $moduleDataSetup;
36
}
37
41
public
function
apply
()
42
{
43
$this->moduleDataSetup->getConnection()->startSetup();
44
$this->updateAdminTextSwatchValues();
45
$this->moduleDataSetup->getConnection()->endSetup();
46
}
47
51
public
static
function
getDependencies
()
52
{
53
return
[
54
AddSwatchImageToDefaultAttribtueSet::class
55
];
56
}
57
61
public
static
function
getVersion
()
62
{
63
return
'2.0.2'
;
64
}
65
69
public
function
getAliases
()
70
{
71
return
[];
72
}
73
77
private
function
updateAdminTextSwatchValues()
78
{
79
$connection
= $this->moduleDataSetup->getConnection();
80
$storeData =
$connection
81
->select()
82
->from($this->moduleDataSetup->getTable(
'store'
))
83
->where(
Store::STORE_ID
.
"<> ? "
,
Store::DEFAULT_STORE_ID
)
84
->order(
"sort_order desc"
)
85
->limit(1)
86
->query(
Zend_Db::FETCH_ASSOC
)
87
->fetch();
88
89
if
(is_array($storeData)) {
90
101
$select
=
$connection
102
->select()
103
->joinLeft(
104
[
"ls"
=> $this->moduleDataSetup->getTable(
'eav_attribute_option_swatch'
)],
105
new
Zend_Db_Expr
(
"ls.option_id = s.option_id AND ls.store_id = "
. $storeData[
Store::STORE_ID
]),
106
[
"value"
]
107
)
108
->where(
"s.store_id = ? "
,
Store::DEFAULT_STORE_ID
)
109
->where(
"s.type = ? "
,
Swatch::SWATCH_TYPE_TEXTUAL
)
110
->where(
"s.value = ? or s.value is null"
,
""
);
111
112
$connection
->query(
113
$connection
->updateFromSelect(
114
$select
,
115
[
"s"
=> $this->moduleDataSetup->getTable(
'eav_attribute_option_swatch'
)]
116
)
117
);
118
}
119
}
120
}
Zend_Db
Magento\Swatches\Setup\Patch\Data
Definition:
AddSwatchImageAttribute.php:7
Magento\Framework\Setup\Patch\DataPatchInterface
Definition:
DataPatchInterface.php:12
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues
Definition:
UpdateAdminTextSwatchValues.php:21
Magento\Store\Model\Store\DEFAULT_STORE_ID
const DEFAULT_STORE_ID
Definition:
Store.php:124
Zend_Db\FETCH_ASSOC
const FETCH_ASSOC
Definition:
Db.php:142
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues\apply
apply()
Definition:
UpdateAdminTextSwatchValues.php:41
Magento\Swatches\Model\Swatch
Definition:
Swatch.php:12
Magento\Swatches\Model\Swatch\SWATCH_TYPE_TEXTUAL
const SWATCH_TYPE_TEXTUAL
Definition:
Swatch.php:33
Zend_Db_Expr
Definition:
Expr.php:49
Magento\Store\Model\Store\STORE_ID
const STORE_ID
Definition:
Store.php:47
$select
$select
Definition:
catalog_rule_10_off_not_logged_rollback.php:14
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues\getAliases
getAliases()
Definition:
UpdateAdminTextSwatchValues.php:69
Magento
Magento\Framework\Setup\Patch\PatchVersionInterface
Definition:
PatchVersionInterface.php:13
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues\getDependencies
static getDependencies()
Definition:
UpdateAdminTextSwatchValues.php:51
Magento\Store\Model\Store
Definition:
Store.php:38
$connection
$connection
Definition:
bulk.php:13
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues\__construct
__construct(\Magento\Framework\Setup\ModuleDataSetupInterface $moduleDataSetup)
Definition:
UpdateAdminTextSwatchValues.php:32
Magento\Framework\App\ResourceConnection
Magento\Swatches\Setup\Patch\Data\UpdateAdminTextSwatchValues\getVersion
static getVersion()
Definition:
UpdateAdminTextSwatchValues.php:61