techdivision / import

     *

     * @return array The EAV attribute option value

     */

    public function findOneByOptionIdAndStoreId($optionId, $storeId)

    {

        // the parameters of the EAV attribute option to load

        $params = array(

            MemberNames::OPTION_ID => $optionId,

            MemberNames::STORE_ID  => $storeId,

        );

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // prepare the cache key

        $cacheKey = $this->cacheKey($utilityClassName::EAV_ATTRIBUTE_OPTION_VALUE_BY_OPTION_ID_AND_STORE_ID, $params);

        // query whether or not the result has been cached

        if ($this->notCached($cacheKey)) {

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

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

            $this->toCache($cacheKey, $this->eavAttributeOptionValueByOptionIdAndStoreIdStmt->fetch(\PDO::FETCH_ASSOC));

        }

        // return the value from the cache

        return $this->fromCache($cacheKey);

    }

    /**

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

     *

     * @return array The EAV attribute option value

     */

    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

        );

        // load the utility class name

        $utilityClassName = $this->getUtilityClassName();

        // prepare the cache key

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

        // query whether or not the result has been cached

        if ($this->notCached($cacheKey)) {

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

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

            $this->toCache($cacheKey, $this->eavAttributeOptionValueByAttributeCodeAndStoreIdAndValueStmt->fetch(\PDO::FETCH_ASSOC));

        }

        // return the value from the cache

        return $this->fromCache($cacheKey);

    }

}