public function render(Varien_Object $row)
 {
     $queryItem = Mage::getModel('rocketweb_search/query')->load($row->getQueryId());
     $blogs = $queryItem->getBlogs();
     if (is_array($blogs) && count($blogs)) {
         $blogCol = Mage::getModel('blog/post')->getCollection();
         $blogCol->addFieldToFilter('post_id', array('in' => $blogs));
         $ret = '';
         foreach ($blogCol as $blog) {
             $ret .= $blog->getTitle() . ', ';
         }
         $ret = preg_replace('/, $/', '', $ret);
         return $ret;
     } else {
         return '-';
     }
 }
 public function render(Varien_Object $row)
 {
     $queryItem = Mage::getModel('rocketweb_search/query')->load($row->getQueryId());
     $cms = $queryItem->getCms();
     if (is_array($cms) && count($cms)) {
         $cmsCol = Mage::getModel('cms/page')->getCollection();
         $cmsCol->addFieldToFilter('page_id', array('in' => $cms));
         $ret = '';
         foreach ($cmsCol as $cmsPage) {
             $ret .= $cmsPage->getTitle() . ', ';
         }
         $ret = preg_replace('/, $/', '', $ret);
         return $ret;
     } else {
         return '-';
     }
 }
 public function render(Varien_Object $row)
 {
     $queryItem = Mage::getModel('rocketweb_search/query')->load($row->getQueryId());
     $products = $queryItem->getProducts();
     if (is_array($products) && count($products)) {
         $productCol = Mage::getModel('catalog/product')->getCollection();
         $productCol->addAttributeToSelect('sku');
         $productCol->addFieldToFilter('entity_id', array('in' => $products));
         $ret = '';
         foreach ($productCol as $product) {
             $ret .= $product->getSku() . ', ';
         }
         $ret = preg_replace('/, $/', '', $ret);
         return $ret;
     } else {
         return '-';
     }
 }
 public function render(Varien_Object $row)
 {
     $queryItem = Mage::getModel('rocketweb_search/query')->load($row->getQueryId());
     $categories = $queryItem->getCategories();
     if (is_array($categories) && count($categories)) {
         $categoryCol = Mage::getModel('catalog/category')->getCollection();
         $categoryCol->addNameToResult();
         $categoryCol->addFieldToFilter('entity_id', array('in' => $categories));
         $ret = '';
         foreach ($categoryCol as $category) {
             $ret .= $category->getName() . ', ';
         }
         $ret = preg_replace('/, $/', '', $ret);
         return $ret;
     } else {
         return '-';
     }
 }