1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* TechDivision\Import\Attribute\Repositories\AttributeLabelRepository |
5
|
|
|
* |
6
|
|
|
* NOTICE OF LICENSE |
7
|
|
|
* |
8
|
|
|
* This source file is subject to the Open Software License (OSL 3.0) |
9
|
|
|
* that is available through the world-wide-web at this URL: |
10
|
|
|
* http://opensource.org/licenses/osl-3.0.php |
11
|
|
|
* |
12
|
|
|
* PHP version 5 |
13
|
|
|
* |
14
|
|
|
* @author Tim Wagner <[email protected]> |
15
|
|
|
* @copyright 2016 TechDivision GmbH <[email protected]> |
16
|
|
|
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) |
17
|
|
|
* @link https://github.com/techdivision/import-attribute |
18
|
|
|
* @link http://www.techdivision.com |
19
|
|
|
*/ |
20
|
|
|
|
21
|
|
|
namespace TechDivision\Import\Attribute\Repositories; |
22
|
|
|
|
23
|
|
|
use TechDivision\Import\Attribute\Utils\MemberNames; |
24
|
|
|
use TechDivision\Import\Attribute\Utils\SqlStatementKeys; |
25
|
|
|
use TechDivision\Import\Repositories\AbstractRepository; |
26
|
|
|
|
27
|
|
|
/** |
28
|
|
|
* Repository implementation to load EAV attribute label data. |
29
|
|
|
* |
30
|
|
|
* @author Tim Wagner <[email protected]> |
31
|
|
|
* @copyright 2016 TechDivision GmbH <[email protected]> |
32
|
|
|
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) |
33
|
|
|
* @link https://github.com/techdivision/import-attribute |
34
|
|
|
* @link http://www.techdivision.com |
35
|
|
|
*/ |
36
|
|
View Code Duplication |
class AttributeLabelRepository extends AbstractRepository implements AttributeLabelRepositoryInterface |
|
|
|
|
37
|
|
|
{ |
38
|
|
|
|
39
|
|
|
/** |
40
|
|
|
* The prepared statement to load an existing EAV attribute label by its entity type ID, attribute code and store ID. |
41
|
|
|
* |
42
|
|
|
* @var \PDOStatement |
43
|
|
|
*/ |
44
|
|
|
protected $attributeLabelByEntityTypeIdAndAttributeCodeAndStoreIdStmt; |
45
|
|
|
|
46
|
|
|
/** |
47
|
|
|
* Initializes the repository's prepared statements. |
48
|
|
|
* |
49
|
|
|
* @return void |
50
|
|
|
*/ |
51
|
|
|
public function init() |
52
|
|
|
{ |
53
|
|
|
|
54
|
|
|
// initialize the prepared statements |
55
|
|
|
$this->attributeLabelByEntityTypeIdAndAttributeCodeAndStoreIdStmt = |
56
|
|
|
$this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::ATTRIBUTE_LABEL_BY_ENTITY_TYPE_ID_AND_ATTRIBUTE_CODE_AND_STORE_ID)); |
57
|
|
|
} |
58
|
|
|
|
59
|
|
|
/** |
60
|
|
|
* Return's the EAV attribute label with the passed attribute code and store ID. |
61
|
|
|
* |
62
|
|
|
* @param integer $entityTypeId The ID of the EAV entity attribute to return the label for |
63
|
|
|
* @param string $attributeCode The attribute code of the EAV attribute label to return |
64
|
|
|
* @param integer $storeId The store ID of the EAV attribute label to return |
65
|
|
|
* |
66
|
|
|
* @return array The EAV attribute label |
67
|
|
|
*/ |
68
|
|
|
public function findOneByEntityTypeIdAndAttributeCodeAndStoreId($entityTypeId, $attributeCode, $storeId) |
69
|
|
|
{ |
70
|
|
|
|
71
|
|
|
// initialize the params |
72
|
|
|
$params = array( |
73
|
|
|
MemberNames::ENTITY_TYPE_ID => $entityTypeId, |
74
|
|
|
MemberNames::ATTRIBUTE_CODE => $attributeCode, |
75
|
|
|
MemberNames::STORE_ID => $storeId |
76
|
|
|
); |
77
|
|
|
|
78
|
|
|
// load and return the EAV attribute label with the passed params |
79
|
|
|
$this->attributeLabelByEntityTypeIdAndAttributeCodeAndStoreIdStmt->execute($params); |
80
|
|
|
return $this->attributeLabelByEntityTypeIdAndAttributeCodeAndStoreIdStmt->fetch(\PDO::FETCH_ASSOC); |
81
|
|
|
} |
82
|
|
|
} |
83
|
|
|
|
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.