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);

        // return the cached result if available

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

            return $this->fromCache($cacheKey);

        }

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

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

        // query whether or not the EAV attribute option value is available in the database

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

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

            $this->toCache(

                $eavAttributeOptionValue[MemberNames::VALUE_ID],

                $eavAttributeOptionValue,

                array($cacheKey => $eavAttributeOptionValue[MemberNames::VALUE_ID])

            );

            // finally, return it

            return $eavAttributeOptionValue;

        }

    }

    /**

     * 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);

        // return the cached result if available

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

            return $this->fromCache($cacheKey);

        }

        // load and return 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)) {

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

            $this->toCache(

                $eavAttributeOptionValue[MemberNames::VALUE_ID],

                $eavAttributeOptionValue,

                array($cacheKey => $eavAttributeOptionValue[MemberNames::VALUE_ID])

            );

            // finally, return it

            return $eavAttributeOptionValue;

        }

    }

}