|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* TechDivision\Import\Product\Media\Ee\Repositories\ProductMediaGalleryValueToEntityRepository |
|
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-product-media-ee |
|
18
|
|
|
* @link http://www.techdivision.com |
|
19
|
|
|
*/ |
|
20
|
|
|
|
|
21
|
|
|
namespace TechDivision\Import\Product\Media\Ee\Repositories; |
|
22
|
|
|
|
|
23
|
|
|
use TechDivision\Import\Product\Media\Ee\Utils\MemberNames; |
|
24
|
|
|
use TechDivision\Import\Product\Media\Ee\Utils\SqlStatementKeys; |
|
25
|
|
|
|
|
26
|
|
|
/** |
|
27
|
|
|
* Interface for repository implementations to load product media gallery value to entity data. |
|
28
|
|
|
* |
|
29
|
|
|
* @author Tim Wagner <[email protected]> |
|
30
|
|
|
* @copyright 2016 TechDivision GmbH <[email protected]> |
|
31
|
|
|
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) |
|
32
|
|
|
* @link https://github.com/techdivision/import-product-media-ee |
|
33
|
|
|
* @link http://www.techdivision.com |
|
34
|
|
|
*/ |
|
35
|
|
View Code Duplication |
class ProductMediaGalleryValueToEntityRepository extends \TechDivision\Import\Product\Media\Repositories\ProductMediaGalleryValueToEntityRepository implements ProductMediaGalleryValueToEntityRepositoryInterface |
|
|
|
|
|
|
36
|
|
|
{ |
|
37
|
|
|
|
|
38
|
|
|
/** |
|
39
|
|
|
* The prepared statement to load an existing product media gallery value to entity entity. |
|
40
|
|
|
* |
|
41
|
|
|
* @var \PDOStatement |
|
42
|
|
|
*/ |
|
43
|
|
|
protected $productMediaGalleryValueToEntityStmt; |
|
44
|
|
|
|
|
45
|
|
|
/** |
|
46
|
|
|
* Initializes the repository's prepared statements. |
|
47
|
|
|
* |
|
48
|
|
|
* @return void |
|
49
|
|
|
*/ |
|
50
|
|
|
public function init() |
|
51
|
|
|
{ |
|
52
|
|
|
|
|
53
|
|
|
// initialize the prepared statements |
|
54
|
|
|
$this->productMediaGalleryValueToEntityStmt = |
|
55
|
|
|
$this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::PRODUCT_MEDIA_GALLERY_VALUE_TO_ENTITY)); |
|
56
|
|
|
} |
|
57
|
|
|
|
|
58
|
|
|
/** |
|
59
|
|
|
* Load's the product media gallery with the passed value/row ID. |
|
60
|
|
|
* |
|
61
|
|
|
* @param integer $valueId The value ID of the product media gallery value to entity to load |
|
62
|
|
|
* @param integer $rowId The row ID of the product media gallery value to entity to load |
|
63
|
|
|
* |
|
64
|
|
|
* @return array The product media gallery |
|
65
|
|
|
*/ |
|
66
|
|
|
public function findOneByValueIdAndRowId($valueId, $rowId) |
|
67
|
|
|
{ |
|
68
|
|
|
|
|
69
|
|
|
// initialize the params |
|
70
|
|
|
$params = array( |
|
71
|
|
|
MemberNames::VALUE_ID => $valueId, |
|
72
|
|
|
MemberNames::ROW_ID => $rowId |
|
73
|
|
|
); |
|
74
|
|
|
|
|
75
|
|
|
// load and return the prodcut media gallery value to entity with the passed value/entity ID |
|
76
|
|
|
$this->productMediaGalleryValueToEntityStmt->execute($params); |
|
77
|
|
|
return $this->productMediaGalleryValueToEntityStmt->fetch(\PDO::FETCH_ASSOC); |
|
78
|
|
|
} |
|
79
|
|
|
} |
|
80
|
|
|
|
techdivision /
import-product-media-ee
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.