@@ 35-81 (lines=47) @@ | ||
32 | * @link https://github.com/techdivision/import-product-media-ee |
|
33 | * @link http://www.techdivision.com |
|
34 | */ |
|
35 | class ProductMediaGalleryValueRepository extends \TechDivision\Import\Product\Media\Repositories\ProductMediaGalleryValueRepository implements ProductMediaGalleryValueRepositoryInterface |
|
36 | { |
|
37 | ||
38 | /** |
|
39 | * The prepared statement to load an existing product media gallery value entity. |
|
40 | * |
|
41 | * @var \PDOStatement |
|
42 | */ |
|
43 | protected $productMediaGalleryStmt; |
|
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->productMediaGalleryValueStmt = |
|
55 | $this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::PRODUCT_MEDIA_GALLERY_VALUE)); |
|
56 | } |
|
57 | ||
58 | /** |
|
59 | * Load's the product media gallery value with the passed value/store/row ID. |
|
60 | * |
|
61 | * @param integer $valueId The value ID of the product media gallery value to load |
|
62 | * @param string $storeId The store ID of the product media gallery value to load |
|
63 | * @param string $rowId The row ID of the parent product of the product media gallery value to load |
|
64 | * |
|
65 | * @return array The product media gallery value |
|
66 | */ |
|
67 | public function findOneByValueIdAndStoreIdAndRowId($valueId, $storeId, $rowId) |
|
68 | { |
|
69 | ||
70 | // initialize the params |
|
71 | $params = array( |
|
72 | MemberNames::VALUE_ID => $valueId, |
|
73 | MemberNames::STORE_ID => $storeId, |
|
74 | MemberNames::ROW_ID => $rowId |
|
75 | ); |
|
76 | ||
77 | // load and return the prodcut media gallery value with the passed value/store/parent ID |
|
78 | $this->productMediaGalleryValueStmt->execute($params); |
|
79 | return $this->productMediaGalleryValueStmt->fetch(\PDO::FETCH_ASSOC); |
|
80 | } |
|
81 | } |
|
82 |
@@ 35-79 (lines=45) @@ | ||
32 | * @link https://github.com/techdivision/import-product-media-ee |
|
33 | * @link http://www.techdivision.com |
|
34 | */ |
|
35 | 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 |