|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* TechDivision\Import\Product\Bundle\Repositories\ProductLinkAttributeVarcharRepository |
|
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 2019 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-product-link |
|
18
|
|
|
* @link http://www.techdivision.com |
|
19
|
|
|
*/ |
|
20
|
|
|
|
|
21
|
|
|
namespace TechDivision\Import\Product\Link\Repositories; |
|
22
|
|
|
|
|
23
|
|
|
use TechDivision\Import\Product\Link\Utils\MemberNames; |
|
24
|
|
|
use TechDivision\Import\Product\Link\Utils\SqlStatementKeys; |
|
25
|
|
|
use TechDivision\Import\Repositories\AbstractRepository; |
|
26
|
|
|
|
|
27
|
|
|
/** |
|
28
|
|
|
* Repository implementation to load product link attribute varchar data. |
|
29
|
|
|
* |
|
30
|
|
|
* @author Tim Wagner <[email protected]> |
|
31
|
|
|
* @copyright 2019 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-product-link |
|
34
|
|
|
* @link http://www.techdivision.com |
|
35
|
|
|
*/ |
|
36
|
|
View Code Duplication |
class ProductLinkAttributeVarcharRepository extends AbstractRepository implements ProductLinkAttributeVarcharRepositoryInterface |
|
|
|
|
|
|
37
|
|
|
{ |
|
38
|
|
|
|
|
39
|
|
|
/** |
|
40
|
|
|
* The prepared statement to load a existing product link attribute varchar attribute. |
|
41
|
|
|
* |
|
42
|
|
|
* @var \PDOStatement |
|
43
|
|
|
*/ |
|
44
|
|
|
protected $productLinkAttributeVarcharStmt; |
|
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->productLinkAttributeVarcharStmt = |
|
56
|
|
|
$this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::PRODUCT_LINK_ATTRIBUTE_VARCHAR)); |
|
57
|
|
|
} |
|
58
|
|
|
|
|
59
|
|
|
/** |
|
60
|
|
|
* Return's the product link attribute varchar value with the passed product link attribute/link ID. |
|
61
|
|
|
* |
|
62
|
|
|
* @param integer $productLinkAttributeId The product link attribute ID of the attributes |
|
63
|
|
|
* @param integer $linkId The link ID of the attribute |
|
64
|
|
|
* |
|
65
|
|
|
* @return array The product link attribute varchar value |
|
66
|
|
|
*/ |
|
67
|
|
|
public function findOneByProductLinkAttributeIdAndLinkId($productLinkAttributeId, $linkId) |
|
68
|
|
|
{ |
|
69
|
|
|
|
|
70
|
|
|
// initialize the params |
|
71
|
|
|
$params = array( |
|
72
|
|
|
MemberNames::PRODUCT_LINK_ATTRIBUTE_ID => $productLinkAttributeId, |
|
73
|
|
|
MemberNames::LINK_ID => $linkId |
|
74
|
|
|
); |
|
75
|
|
|
|
|
76
|
|
|
// load and return the prodcut link attribute varchar attribute with the passed product link attribute/link ID |
|
77
|
|
|
$this->productLinkAttributeVarcharStmt->execute($params); |
|
78
|
|
|
return $this->productLinkAttributeVarcharStmt->fetch(\PDO::FETCH_ASSOC); |
|
79
|
|
|
} |
|
80
|
|
|
} |
|
81
|
|
|
|
techdivision /
import-product-link
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.