Code Duplication    Length = 47-49 lines in 3 locations

src/Repositories/ProductMediaGalleryRepository.php 1 location

@@ 35-81 (lines=47) @@
32
 * @link      https://github.com/techdivision/import-product-media
33
 * @link      http://www.techdivision.com
34
 */
35
class ProductMediaGalleryRepository extends AbstractRepository
36
{
37
38
    /**
39
     * The prepared statement to load an existing product media gallery 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
        // load the utility class name
54
        $utilityClassName = $this->getUtilityClassName();
55
56
        // initialize the prepared statements
57
        $this->productMediaGalleryStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_MEDIA_GALLERY);
58
    }
59
60
    /**
61
     * Load's the product media gallery with the passed attribute ID + value.
62
     *
63
     * @param integer $attributeId The attribute ID of the product media gallery to load
64
     * @param string  $value       The value of the product media gallery to load
65
     *
66
     * @return array The product media gallery
67
     */
68
    public function findOneByAttributeIdAndValue($attributeId, $value)
69
    {
70
71
        // initialize the params
72
        $params = array(
73
            MemberNames::ATTRIBUTE_ID => $attributeId,
74
            MemberNames::VALUE        => $value
75
        );
76
77
        // load and return the prodcut media gallery with the passed attribute ID + value
78
        $this->productMediaGalleryStmt->execute($params);
79
        return $this->productMediaGalleryStmt->fetch(\PDO::FETCH_ASSOC);
80
    }
81
}
82

src/Repositories/ProductMediaGalleryValueRepository.php 1 location

@@ 35-83 (lines=49) @@
32
 * @link      https://github.com/techdivision/import-product-media
33
 * @link      http://www.techdivision.com
34
 */
35
class ProductMediaGalleryValueRepository extends AbstractRepository
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
        // load the utility class name
54
        $utilityClassName = $this->getUtilityClassName();
55
56
        // initialize the prepared statements
57
        $this->productMediaGalleryValueStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_MEDIA_GALLERY_VALUE);
58
    }
59
60
    /**
61
     * Load's the product media gallery value with the passed value/store/parent ID.
62
     *
63
     * @param integer $valueId  The value ID of the product media gallery value to load
64
     * @param string  $storeId  The store ID of the product media gallery value to load
65
     * @param string  $entityId The entity ID of the parent product of the product media gallery value to load
66
     *
67
     * @return array The product media gallery value
68
     */
69
    public function findOneByValueIdAndStoreIdAndEntityId($valueId, $storeId, $entityId)
70
    {
71
72
        // initialize the params
73
        $params = array(
74
            MemberNames::VALUE_ID  => $valueId,
75
            MemberNames::STORE_ID  => $storeId,
76
            MemberNames::ENTITY_ID => $entityId
77
        );
78
79
        // load and return the prodcut media gallery value with the passed value/store/parent ID
80
        $this->productMediaGalleryValueStmt->execute($params);
81
        return $this->productMediaGalleryValueStmt->fetch(\PDO::FETCH_ASSOC);
82
    }
83
}
84

src/Repositories/ProductMediaGalleryValueToEntityRepository.php 1 location

@@ 35-81 (lines=47) @@
32
 * @link      https://github.com/techdivision/import-product-media
33
 * @link      http://www.techdivision.com
34
 */
35
class ProductMediaGalleryValueToEntityRepository extends AbstractRepository
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
        // load the utility class name
54
        $utilityClassName = $this->getUtilityClassName();
55
56
        // initialize the prepared statements
57
        $this->productMediaGalleryValueToEntityStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_MEDIA_GALLERY_VALUE_TO_ENTITY);
58
    }
59
60
    /**
61
     * Load's the product media gallery with the passed value/entity ID.
62
     *
63
     * @param integer $valueId  The value ID of the product media gallery value to entity to load
64
     * @param integer $entityId The entity ID of the product media gallery value to entity to load
65
     *
66
     * @return array The product media gallery
67
     */
68
    public function findOneByValueIdAndEntityId($valueId, $entityId)
69
    {
70
71
        // initialize the params
72
        $params = array(
73
            MemberNames::VALUE_ID  => $valueId,
74
            MemberNames::ENTITY_ID => $entityId
75
        );
76
77
        // load and return the prodcut media gallery value to entity with the passed value/entity ID
78
        $this->productMediaGalleryValueToEntityStmt->execute($params);
79
        return $this->productMediaGalleryValueToEntityStmt->fetch(\PDO::FETCH_ASSOC);
80
    }
81
}
82