/**
  * @param Mana_Seo_Model_Context $context
  * @param Mana_Seo_Model_Url[] $activeParameterUrls
  * @param Mana_Seo_Model_Url[] $obsoleteParameterUrls
  * @return Mana_Seo_Helper_ParameterHandler
  */
 public function getParameterUrls($context, &$activeParameterUrls, &$obsoleteParameterUrls)
 {
     $activeParameterUrls = array();
     $obsoleteParameterUrls = array();
     /* @var $dbHelper Mana_Db_Helper_Data */
     $dbHelper = Mage::helper('mana_db');
     /* @var $res Mage_Core_Model_Resource */
     $res = Mage::getSingleton('core/resource');
     /* @var $collection Mana_Seo_Resource_Url_Collection */
     $collection = $dbHelper->getResourceModel('mana_seo/url_collection');
     $db = $collection->getResource()->getReadConnection();
     $collection->setStoreFilter($context->getStoreId())->addFieldToFilter('schema_id', $context->getSchema()->getId())->addFieldToFilter('url_key', array('in' => $context->getCandidates()))->addFieldToFilter('status', array('in' => array(Mana_Seo_Model_Url::STATUS_ACTIVE, Mana_Seo_Model_Url::STATUS_OBSOLETE)));
     $types = array();
     $internalParameterName = array();
     if (!$context->getExpectValue()) {
         $types[] = 'parameter';
         $internalParameterName[] = "`a`.`attribute_code`";
         $collection->getSelect()->joinLeft(array('a' => $res->getTableName('eav/attribute')), "`a`.`attribute_id` = `main_table`.`attribute_id`", null);
     }
     if ($context->getExpectValue() || $context->getSchema()->getIncludeFilterName() != Mana_Seo_Model_Schema::INCLUDE_ALWAYS) {
         $types[] = 'value';
         $collection->getSelect()->joinLeft(array('o' => $res->getTableName('eav/attribute_option')), "`o`.`option_id` = `main_table`.`option_id`", null)->joinLeft(array('oa' => $res->getTableName('eav/attribute')), "`oa`.`attribute_id` = `o`.`attribute_id`" . ($context->getExpectValue() ? $db->quoteInto(" AND `oa` . `code` = ?", $context->getCurrentParameter()) : ''), null);
         $internalParameterName[] = "`oa`.`attribute_code`";
     }
     $collection->addTypeFilter($types);
     if (count($internalParameterName)) {
         if (count($internalParameterName) > 1) {
             $internalParameterName = "COALESCE(" . implode(', ', $internalParameterName) . ")";
         } else {
             $internalParameterName = $internalParameterName[0];
         }
         $collection->getSelect()->columns(array('internal_parameter_name' => new Zend_Db_Expr($internalParameterName)));
     }
     foreach ($collection as $parameterUrl) {
         /* @var $parameterUrl Mana_Seo_Model_Url */
         if ($parameterUrl->getStatus() == Mana_Seo_Model_Url::STATUS_ACTIVE) {
             $activeParameterUrls[] = $parameterUrl;
         } else {
             $obsoleteParameterUrls[] = $parameterUrl;
         }
     }
 }
 /**
  * @param Mana_Seo_Model_Context $context
  * @param Mana_Seo_Model_Url[] $activeParameterUrls
  * @param Mana_Seo_Model_Url[] $obsoleteParameterUrls
  * @return Mana_Seo_Helper_ParameterHandler
  */
 public function getParameterUrls($context, &$activeParameterUrls, &$obsoleteParameterUrls)
 {
     $activeParameterUrls = array();
     $obsoleteParameterUrls = array();
     $vars = $context->getSchema()->getJson('toolbar_url_keys');
     foreach ($context->getCandidates() as $candidate) {
         foreach ($vars as $var) {
             if ($var['name'] == $candidate) {
                 /* @var $parameterUrl Mana_Seo_Model_Url */
                 $parameterUrl = Mage::getModel('mana_seo/url');
                 $parameterUrl->setUrlKey($var['name']);
                 $activeParameterUrls[] = $parameterUrl;
             }
         }
     }
 }