Code Duplication    Length = 45-47 lines in 2 locations

src/Repositories/ProductMediaGalleryValueRepository.php 1 location

@@ 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

src/Repositories/ProductMediaGalleryValueToEntityRepository.php 1 location

@@ 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