Code Duplication - techdivision/import-product - Measure and Improve Code Quality continuously with Scrutinizer


 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class CategoryProductRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing category product relations.
     *
     * @var \PDOStatement
     */
    protected $productCategoryStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productCategoryStmt = $this->getConnection()->prepare($utilityClassName::CATEGORY_PRODUCT);
    }

    /**
     * Return's the category product relation with the passed category/product ID.
     *
     * @param integer $categoryId The category ID of the category product relation to return
     * @param integer $productId  The product ID of the category product relation to return
     *
     * @return array The category product relation
     */
    public function findOneByCategoryIdAndProductId($categoryId, $productId)
    {

        // prepare the params
        $params = array(
            MemberNames::CATEGORY_ID => $categoryId,
            MemberNames::PRODUCT_ID  => $productId
        );

        // load and return the product category relation with the passed category/product ID
        $this->productCategoryStmt->execute($params);
        return $this->productCategoryStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductDatetimeRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product datetime attribute.
     *
     * @var \PDOStatement
     */
    protected $productDatetimeStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productDatetimeStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_DATETIME);
    }

    /**
     * Load's and return's the datetime attribute with the passed entity/attribute/store ID.
     *
     * @param integer $entityId    The entity ID of the attribute
     * @param integer $attributeId The attribute ID of the attribute
     * @param integer $storeId     The store ID of the attribute
     *
     * @return array|null The datetime attribute
     */
    public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
    {

        // prepare the params
        $params = array(
            MemberNames::STORE_ID      => $storeId,
            MemberNames::ENTITY_ID     => $entityId,
            MemberNames::ATTRIBUTE_ID  => $attributeId
        );

        // load and return the product datetime attribute with the passed store/entity/attribute ID
        $this->productDatetimeStmt->execute($params);
        return $this->productDatetimeStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductDecimalRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product decimal attribute.
     *
     * @var \PDOStatement
     */
    protected $productDecimalStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productDecimalStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_DECIMAL);
    }

    /**
     * Load's and return's the decimal attribute with the passed entity/attribute/store ID.
     *
     * @param integer $entityId    The entity ID of the attribute
     * @param integer $attributeId The attribute ID of the attribute
     * @param integer $storeId     The store ID of the attribute
     *
     * @return array|null The decimal attribute
     */
    public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
    {

        // prepare the params
        $params = array(
            MemberNames::STORE_ID      => $storeId,
            MemberNames::ENTITY_ID     => $entityId,
            MemberNames::ATTRIBUTE_ID  => $attributeId
        );

        // load and return the product decimal attribute with the passed store/entity/attribute ID
        $this->productDecimalStmt->execute($params);
        return $this->productDecimalStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductIntRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product integer attribute.
     *
     * @var \PDOStatement
     */
    protected $productIntStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productIntStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_INT);
    }

    /**
     * Load's and return's the integer attribute with the passed entity/attribute/store ID.
     *
     * @param integer $entityId    The entity ID of the attribute
     * @param integer $attributeId The attribute ID of the attribute
     * @param integer $storeId     The store ID of the attribute
     *
     * @return array|null The integer attribute
     */
    public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
    {

        // prepare the params
        $params = array(
            MemberNames::STORE_ID      => $storeId,
            MemberNames::ENTITY_ID     => $entityId,
            MemberNames::ATTRIBUTE_ID  => $attributeId
        );

        // load and return the product integer attribute with the passed store/entity/attribute ID
        $this->productIntStmt->execute($params);
        return $this->productIntStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductTextRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product text attribute.
     *
     * @var \PDOStatement
     */
    protected $productTextStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productTextStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_TEXT);
    }

    /**
     * Load's and return's the text attribute with the passed entity/attribute/store ID.
     *
     * @param integer $entityId    The entity ID of the attribute
     * @param integer $attributeId The attribute ID of the attribute
     * @param integer $storeId     The store ID of the attribute
     *
     * @return array|null The text attribute
     */
    public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
    {

        // prepare the params
        $params = array(
            MemberNames::STORE_ID      => $storeId,
            MemberNames::ENTITY_ID     => $entityId,
            MemberNames::ATTRIBUTE_ID  => $attributeId
        );

        // load and return the product text attribute with the passed store/entity/attribute ID
        $this->productTextStmt->execute($params);
        return $this->productTextStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductVarcharRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product varchar attribute.
     *
     * @var \PDOStatement
     */
    protected $productVarcharStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productVarcharStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_VARCHAR);
    }

    /**
     * Load's and return's the varchar attribute with the passed entity/attribute/store ID.
     *
     * @param integer $entityId    The entity ID of the attribute
     * @param integer $attributeId The attribute ID of the attribute
     * @param integer $storeId     The store ID of the attribute
     *
     * @return array|null The varchar attribute
     */
    public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
    {

        // prepare the params
        $params = array(
            MemberNames::STORE_ID      => $storeId,
            MemberNames::ENTITY_ID     => $entityId,
            MemberNames::ATTRIBUTE_ID  => $attributeId
        );

        // load and return the product varchar attribute with the passed store/entity/attribute ID
        $this->productVarcharStmt->execute($params);
        return $this->productVarcharStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ProductWebsiteRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing product website relations.
     *
     * @var \PDOStatement
     */
    protected $productWebsiteStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productWebsiteStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_WEBSITE);
    }

    /**
     * Load's and return's the product website relation with the passed product and website ID.
     *
     * @param string $productId The product ID of the relation
     * @param string $websiteId The website ID of the relation
     *
     * @return array The product website
     */
    public function findOneByProductIdAndWebsite($productId, $websiteId)
    {

        // prepare the params
        $params = array(
            MemberNames::PRODUCT_ID => $productId,
            MemberNames::WEBSITE_ID => $websiteId
        );

        // load and return the product with the passed product/website ID
        $this->productWebsiteStmt->execute($params);
        return $this->productWebsiteStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class StockItemRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing stock items.
     *
     * @var \PDOStatement
     */
    protected $stockItemStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->stockItemStmt = $this->getConnection()->prepare($utilityClassName::STOCK_ITEM);
    }

    /**
     * Load's and return's the stock item with the passed product/website/stock ID.
     *
     * @param integer $productId The product ID of the stock item to load
     * @param integer $websiteId The website ID of the stock item to load
     * @param integer $stockId   The stock ID of the stock item to load
     *
     * @return array The stock item
     */
    public function findOneByProductIdAndWebsiteIdAndStockId($productId, $websiteId, $stockId)
    {

        // prepare the params
        $params = array(
            MemberNames::PRODUCT_ID => $productId,
            MemberNames::WEBSITE_ID => $websiteId,
            MemberNames::STOCK_ID   => $stockId
        );

        // load and return the stock status with the passed product/website/stock ID
        $this->stockItemStmt->execute($params);
        return $this->stockItemStmt->fetch(\PDO::FETCH_ASSOC);
    }
}



 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class StockStatusRepository extends AbstractRepository
{

    /**
     * The prepared statement to load the existing stock status.
     *
     * @var \PDOStatement
     */
    protected $stockStatusStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->stockStatusStmt = $this->getConnection()->prepare($utilityClassName::STOCK_STATUS);
    }

    /**
     * Load's and return's the stock status with the passed product/website/stock ID.
     *
     * @param integer $productId The product ID of the stock status to load
     * @param integer $websiteId The website ID of the stock status to load
     * @param integer $stockId   The stock ID of the stock status to load
     *
     * @return array The stock status
     */
    public function findOneByProductIdAndWebsiteIdAndStockId($productId, $websiteId, $stockId)
    {

        // prepare the params
        $params = array(
            MemberNames::PRODUCT_ID => $productId,
            MemberNames::WEBSITE_ID => $websiteId,
            MemberNames::STOCK_ID   => $stockId
        );

        // load and return the stock status with the passed product/website/stock ID
        $this->stockStatusStmt->execute($params);
        return $this->stockStatusStmt->fetch(\PDO::FETCH_ASSOC);
    }
}


		@@ 35-81 (lines=47) @@
32		* @link https://github.com/techdivision/import
33		* @link http://www.techdivision.com
34		*/
35		class CategoryProductRepository extends AbstractRepository
36		{
37
38		/**
39		* The prepared statement to load the existing category product relations.
40		*
41		* @var \PDOStatement
42		*/
43		protected $productCategoryStmt;
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->productCategoryStmt = $this->getConnection()->prepare($utilityClassName::CATEGORY_PRODUCT);
58		}
59
60		/**
61		* Return's the category product relation with the passed category/product ID.
62		*
63		* @param integer $categoryId The category ID of the category product relation to return
64		* @param integer $productId The product ID of the category product relation to return
65		*
66		* @return array The category product relation
67		*/
68		public function findOneByCategoryIdAndProductId($categoryId, $productId)
69		{
70
71		// prepare the params
72		$params = array(
73		MemberNames::CATEGORY_ID => $categoryId,
74		MemberNames::PRODUCT_ID => $productId
75		);
76
77		// load and return the product category relation with the passed category/product ID
78		$this->productCategoryStmt->execute($params);
79		return $this->productCategoryStmt->fetch(\PDO::FETCH_ASSOC);
80		}
81		}
82

		@@ 35-83 (lines=49) @@
32		* @link https://github.com/techdivision/import
33		* @link http://www.techdivision.com
34		*/
35		class ProductDatetimeRepository extends AbstractRepository
36		{
37
38		/**
39		* The prepared statement to load the existing product datetime attribute.
40		*
41		* @var \PDOStatement
42		*/
43		protected $productDatetimeStmt;
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->productDatetimeStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_DATETIME);
58		}
59
60		/**
61		* Load's and return's the datetime attribute with the passed entity/attribute/store ID.
62		*
63		* @param integer $entityId The entity ID of the attribute
64		* @param integer $attributeId The attribute ID of the attribute
65		* @param integer $storeId The store ID of the attribute
66		*
67		* @return array\|null The datetime attribute
68		*/
69		public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
70		{
71
72		// prepare the params
73		$params = array(
74		MemberNames::STORE_ID => $storeId,
75		MemberNames::ENTITY_ID => $entityId,
76		MemberNames::ATTRIBUTE_ID => $attributeId
77		);
78
79		// load and return the product datetime attribute with the passed store/entity/attribute ID
80		$this->productDatetimeStmt->execute($params);
81		return $this->productDatetimeStmt->fetch(\PDO::FETCH_ASSOC);
82		}
83		}
84

		@@ 35-83 (lines=49) @@
32		* @link https://github.com/techdivision/import
33		* @link http://www.techdivision.com
34		*/
35		class ProductDecimalRepository extends AbstractRepository
36		{
37
38		/**
39		* The prepared statement to load the existing product decimal attribute.
40		*
41		* @var \PDOStatement
42		*/
43		protected $productDecimalStmt;
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->productDecimalStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_DECIMAL);
58		}
59
60		/**
61		* Load's and return's the decimal attribute with the passed entity/attribute/store ID.
62		*
63		* @param integer $entityId The entity ID of the attribute
64		* @param integer $attributeId The attribute ID of the attribute
65		* @param integer $storeId The store ID of the attribute
66		*
67		* @return array\|null The decimal attribute
68		*/
69		public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
70		{
71
72		// prepare the params
73		$params = array(
74		MemberNames::STORE_ID => $storeId,
75		MemberNames::ENTITY_ID => $entityId,
76		MemberNames::ATTRIBUTE_ID => $attributeId
77		);
78
79		// load and return the product decimal attribute with the passed store/entity/attribute ID
80		$this->productDecimalStmt->execute($params);
81		return $this->productDecimalStmt->fetch(\PDO::FETCH_ASSOC);
82		}
83		}
84

		@@ 35-83 (lines=49) @@
32		* @link https://github.com/techdivision/import
33		* @link http://www.techdivision.com
34		*/
35		class ProductIntRepository extends AbstractRepository
36		{
37
38		/**
39		* The prepared statement to load the existing product integer attribute.
40		*
41		* @var \PDOStatement
42		*/
43		protected $productIntStmt;
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->productIntStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_INT);
58		}
59
60		/**
61		* Load's and return's the integer attribute with the passed entity/attribute/store ID.
62		*
63		* @param integer $entityId The entity ID of the attribute
64		* @param integer $attributeId The attribute ID of the attribute
65		* @param integer $storeId The store ID of the attribute
66		*
67		* @return array\|null The integer attribute
68		*/
69		public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
70		{
71
72		// prepare the params
73		$params = array(
74		MemberNames::STORE_ID => $storeId,
75		MemberNames::ENTITY_ID => $entityId,
76		MemberNames::ATTRIBUTE_ID => $attributeId
77		);
78
79		// load and return the product integer attribute with the passed store/entity/attribute ID
80		$this->productIntStmt->execute($params);
81		return $this->productIntStmt->fetch(\PDO::FETCH_ASSOC);
82		}
83		}
84

		@@ 35-83 (lines=49) @@
32		* @link https://github.com/techdivision/import
33		* @link http://www.techdivision.com
34		*/
35		class ProductTextRepository extends AbstractRepository
36		{
37
38		/**
39		* The prepared statement to load the existing product text attribute.
40		*
41		* @var \PDOStatement
42		*/
43		protected $productTextStmt;
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->productTextStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_TEXT);
58		}
59
60		/**
61		* Load's and return's the text attribute with the passed entity/attribute/store ID.
62		*
63		* @param integer $entityId The entity ID of the attribute
64		* @param integer $attributeId The attribute ID of the attribute
65		* @param integer $storeId The store ID of the attribute
66		*
67		* @return array\|null The text attribute
68		*/
69		public function findOneByEntityIdAndAttributeIdAndStoreId($entityId, $attributeId, $storeId)
70		{
71
72		// prepare the params
73		$params = array(
74		MemberNames::STORE_ID => $storeId,
75		MemberNames::ENTITY_ID => $entityId,
76		MemberNames::ATTRIBUTE_ID => $attributeId
77		);
78
79		// load and return the product text attribute with the passed store/entity/attribute ID
80		$this->productTextStmt->execute($params);
81		return $this->productTextStmt->fetch(\PDO::FETCH_ASSOC);
82		}
83		}
84

Code Duplication Length = 47-49 lines in 9 locations

src/Repositories/CategoryProductRepository.php 1 location

src/Repositories/ProductDatetimeRepository.php 1 location

src/Repositories/ProductDecimalRepository.php 1 location

src/Repositories/ProductIntRepository.php 1 location

src/Repositories/ProductTextRepository.php 1 location

src/Repositories/ProductVarcharRepository.php 1 location

src/Repositories/ProductWebsiteRepository.php 1 location

src/Repositories/StockItemRepository.php 1 location

src/Repositories/StockStatusRepository.php 1 location

techdivision / import-product

Code Duplication Length = 47-49 lines in 9 locations

src/Repositories/CategoryProductRepository.php 1 location

src/Repositories/ProductDatetimeRepository.php 1 location

src/Repositories/ProductDecimalRepository.php 1 location

src/Repositories/ProductIntRepository.php 1 location

src/Repositories/ProductTextRepository.php 1 location

src/Repositories/ProductVarcharRepository.php 1 location

src/Repositories/ProductWebsiteRepository.php 1 location

src/Repositories/StockItemRepository.php 1 location

src/Repositories/StockStatusRepository.php 1 location