techdivision / import-product-variant

 * @link      https://github.com/techdivision/import-product-variant

 * @link      http://www.techdivision.com

 */

class ProductRelationRepository extends AbstractRepository

{

    /**

     * The prepared statement to load an existing product relation.

     *

     * @var \PDOStatement

     */

    protected $productRelationStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements

        $this->productRelationStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_RELATION);

    }

    /**

     * Load's the product relation with the passed parent/child ID.

     *

     * @param integer $parentId The entity ID of the product relation's parent product

     * @param integer $childId  The entity ID of the product relation's child product

     *

     * @return array The product relation

     */

    public function findOneByParentIdAndChildId($parentId, $childId)

    {

        // initialize the params

        $params = array(

            MemberNames::PARENT_ID => $parentId,

            MemberNames::CHILD_ID  => $childId

        );

        // load and return the product relation with the passed parent/child ID

        $this->productRelationStmt->execute($params);

        return $this->productRelationStmt->fetch(\PDO::FETCH_ASSOC);

    }

}

 * @link      https://github.com/techdivision/import-product-variant

 * @link      http://www.techdivision.com

 */

class ProductSuperAttributeLabelRepository extends AbstractRepository

{

    /**

     * The prepared statement to load an existing product super attribute label.

     *

     * @var \PDOStatement

     */

    protected $productSuperAttributeLabelStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements

        $this->productSuperAttributeLabelStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_SUPER_ATTRIBUTE_LABEL);

    }

    /**

     * Load's the product super attribute label with the passed product super attribute/store ID.

     *

     * @param integer $productSuperAttributeId The product super attribute ID of the product super attribute label

     * @param integer $storeId                 The store ID of the product super attribute label

     *

     * @return array The product super attribute label

     */

    public function findOneByProductSuperAttributeIdAndStoreId($productSuperAttributeId, $storeId)

    {

        // initialize the params

        $params = array(

            MemberNames::PRODUCT_SUPER_ATTRIBUTE_ID => $productSuperAttributeId,

            MemberNames::STORE_ID                   => $storeId

        );

        // load and return the product super attribute label with the passed product super attribute/store ID

        $this->productSuperAttributeLabelStmt->execute($params);

        return $this->productSuperAttributeLabelStmt->fetch(\PDO::FETCH_ASSOC);

    }

}

 * @link      https://github.com/techdivision/import-product-variant

 * @link      http://www.techdivision.com

 */

class ProductSuperAttributeRepository extends AbstractRepository

{

    /**

     * The prepared statement to load an existing product super attribute.

     *

     * @var \PDOStatement

     */

    protected $productSuperAttributeStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements

        $this->productSuperAttributeStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_SUPER_ATTRIBUTE);

    }

    /**

     * Load's the product super attribute with the passed product/attribute ID.

     *

     * @param integer $productId   The entity ID of the product super attribute's product

     * @param integer $attributeId The attribute ID of the product super attributes attribute

     *

     * @return array The product super attribute

     */

    public function findOneByProductIdAndAttributeId($productId, $attributeId)

    {

        // initialize the params

        $params = array(

            MemberNames::PRODUCT_ID    => $productId,

            MemberNames::ATTRIBUTE_ID  => $attributeId

        );

        // load and return the product super attribute with the passed product/attribute ID

        $this->productSuperAttributeStmt->execute($params);

        return $this->productSuperAttributeStmt->fetch(\PDO::FETCH_ASSOC);

    }

}

 * @link      https://github.com/techdivision/import-product-variant

 * @link      http://www.techdivision.com

 */

class ProductSuperLinkRepository extends AbstractRepository

{

    /**

     * The prepared statement to load an existing product super link.

     *

     * @var \PDOStatement

     */

    protected $productSuperLinkStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements

        $this->productSuperLinkStmt = $this->getConnection()->prepare($utilityClassName::PRODUCT_SUPER_LINK);

    }

    /**

     * Load's the product super link with the passed product/parent ID.

     *

     * @param integer $productId The entity ID of the product super link's product

     * @param integer $parentId  The entity ID of the product super link's parent product

     *

     * @return array The product super link

     */

    public function findOneByProductIdAndParentId($productId, $parentId)

    {

        // initialize the params

        $params = array(

            MemberNames::PRODUCT_ID => $productId,

            MemberNames::PARENT_ID  => $parentId,

        );

        // load and return the product super link with the passed product/parent ID

        $this->productSuperLinkStmt->execute($params);

        return $this->productSuperLinkStmt->fetch(\PDO::FETCH_ASSOC);

    }

}