本文整理汇总了PHP中Mage_Core_Model_Mysql4_Collection_Abstract::getSelect方法的典型用法代码示例。如果您正苦于以下问题:PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelect方法的具体用法?PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelect怎么用?PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelect使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Mage_Core_Model_Mysql4_Collection_Abstract
的用法示例。
在下文中一共展示了Mage_Core_Model_Mysql4_Collection_Abstract::getSelect方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _getMatchedIds
protected function _getMatchedIds($query)
{
if (!is_array($this->_attributes) || !count($this->_attributes)) {
Mage::throwException('Searchable attributes not defined');
}
$query = Mage::helper('core/string')->splitWords($query, true, 100);
$select = $this->_collection->getSelect();
$having = array();
foreach ($query as $word) {
$subhaving = array();
foreach ($this->_attributes as $attr => $weight) {
$subhaving[] = $this->_getCILike($attr, $word, array('position' => 'any'));
}
$having[] = '(' . implode(' OR ', $subhaving) . ')';
}
$havingCondition = implode(' AND ', $having);
if ($havingCondition != '') {
$select->having($havingCondition);
}
$read = Mage::getSingleton('core/resource')->getConnection('core_read');
$stmt = $read->query($select);
$result = array();
while ($row = $stmt->fetch(Zend_Db::FETCH_ASSOC)) {
$result[$row[$this->_primaryKey]] = 0;
}
return $result;
}