techdivision / import

     * @deprecated Since 2.0.2, because multiple attributes with the same attribute code, but differenct entity type code can be available

     * @see \TechDivision\Import\Repositories\EavAttributeOptionValueRepositoryInterface::findOneByEntityTypeIdAndAttributeCodeAndStoreIdAndValue()

     */

    public function findOneByAttributeCodeAndStoreIdAndValue($attributeCode, $storeId, $value)

    {

        // the parameters of the EAV attribute option to load

        $params = array(

            MemberNames::ATTRIBUTE_CODE => $attributeCode,

            MemberNames::STORE_ID       => $storeId,

            MemberNames::VALUE          => $value

        );

        // prepare the cache key

        $cacheKey = $this->cacheAdapter->cacheKey(SqlStatementKeys::EAV_ATTRIBUTE_OPTION_VALUE_BY_ATTRIBUTE_CODE_AND_STORE_ID_AND_VALUE, $params);

        // return the cached result if available

        if ($this->cacheAdapter->isCached($cacheKey)) {

            return $this->cacheAdapter->fromCache($cacheKey);

        }

        // load the EAV attribute option value with the passed parameters

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

        // query whether or not the result has been cached

        if ($eavAttributeOptionValue = $this->eavAttributeOptionValueByAttributeCodeAndStoreIdAndValueStmt->fetch(\PDO::FETCH_ASSOC)) {

            // prepare the unique cache key for the EAV attribute option value

            $uniqueKey = $this->cacheAdapter->cacheKey(

                EavAttributeOptionValueRepositoryInterface::class,

                array($eavAttributeOptionValue[$this->getPrimaryKeyName()])

                );

            // add the EAV attribute option value to the cache, register the cache key reference as well

            $this->cacheAdapter->toCache($cacheKey, $eavAttributeOptionValue, array($cacheKey => $uniqueKey));

        }

        // finally, return it

        return $eavAttributeOptionValue;

    }

    /**

     * Load's and return's the EAV attribute option value with the passed entity type ID, code, store ID and value.

     *

     * @return array The EAV attribute option value

     */

    public function findOneByEntityTypeIdAndAttributeCodeAndStoreIdAndValue($entityTypeId, $attributeCode, $storeId, $value)

    {

        // the parameters of the EAV attribute option to load

        $params = array(

            MemberNames::ENTITY_TYPE_ID => $entityTypeId,

            MemberNames::ATTRIBUTE_CODE => $attributeCode,

            MemberNames::STORE_ID       => $storeId,

            MemberNames::VALUE          => $value

        );

        // prepare the cache key

        $cacheKey = $this->cacheAdapter->cacheKey(SqlStatementKeys::EAV_ATTRIBUTE_OPTION_VALUE_BY_ENTITY_TYPE_ID_AND_ATTRIBUTE_CODE_AND_STORE_ID_AND_VALUE, $params);

        // return the cached result if available

        if ($this->cacheAdapter->isCached($cacheKey)) {

            return $this->cacheAdapter->fromCache($cacheKey);

        }

        // load the EAV attribute option value with the passed parameters

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

        // query whether or not the result has been cached

        if ($eavAttributeOptionValue = $this->eavAttributeOptionValueByEntityTypeIdAndAttributeCodeAndStoreIdAndValueStmt->fetch(\PDO::FETCH_ASSOC)) {

            // prepare the unique cache key for the EAV attribute option value

            $uniqueKey = $this->cacheAdapter->cacheKey(

                EavAttributeOptionValueRepositoryInterface::class,

                array($eavAttributeOptionValue[$this->getPrimaryKeyName()])

                );

            // add the EAV attribute option value to the cache, register the cache key reference as well

            $this->cacheAdapter->toCache($cacheKey, $eavAttributeOptionValue, array($cacheKey => $uniqueKey));

        }

        // finally, return it

        return $eavAttributeOptionValue;

    }

}