public function addFieldToFilter($field, $condition = null) { if ($field == 'meta_title_error') { if ($condition == 'missing') { $field = 'prepared_meta_title'; $condition = array('eq' => ''); } elseif ($condition == 'long') { $field = 'meta_title_len'; $condition = array('gt' => '70'); } elseif ($condition == 'duplicate') { $field = 'meta_title_dupl'; $condition = array('gt' => '1'); } } elseif ($field == 'name_error') { if ($condition == 'duplicate') { $field = 'name_dupl'; $condition = array('gt' => '1'); } } elseif ($field == 'meta_descr_error') { if ($condition == 'missing') { $field = 'meta_descr_len'; $condition = array('eq' => '0'); } elseif ($condition == 'long') { $field = 'meta_descr_len'; $condition = array('gt' => '150'); } } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($attribute, $condition = null) { if ($attribute == 'status') { $attribute = 'main_table.' . $attribute; } return parent::addFieldToFilter($attribute, $condition); }
/** * Redefine default filters * * @param string $field * @param mixed $condition * @return Varien_Data_Collection_Db */ public function addFieldToFilter($field, $condition = null) { if ($field == 'stores') { return $this->addStoresFilter($condition); } else { return parent::addFieldToFilter($field, $condition); } }
/** * Add field filter to collection * * @see self::_getConditionSql for $condition * @param string $field * @param null|string|array $condition * @return Magpleasure_Forms_Model_Mysql4_List_Collection */ public function addFieldToFilter($field, $condition = null) { if (strpos($field, "field") !== false) { parent::addFieldToFilter($this->_fieldLinks[$field], $condition); } else { parent::addFieldToFilter($field, $condition); } return $this; }
public function addFieldToFilter($field, $condition = null) { if ($field == 'name') { $conditionSql = $this->_getConditionSql('IFNULL(p.value, p_d.value)', $condition); $this->getSelect()->where($conditionSql, null, Varien_Db_Select::TYPE_CONDITION); } else { parent::addFieldToFilter($field, $condition); } }
public function addFieldToFilter($field, $condition = null) { if (in_array($field, array('subscribers_total', 'subscribers_sent'))) { $this->addFieldToFilter('main_table.queue_id', array('in' => $this->_getIdsFromLink($field, $condition))); return $this; } else { return parent::addFieldToFilter($field, $condition); } }
public function addFieldToFilter($attribute, $condition = null) { $customer = Mage::getModel('customer/customer')->getCollection(); $customer_table = $customer->getTable('customer/entity'); if ($attribute == 'customer_id') { $attribute = 'main_table.' . $attribute; } elseif ($attribute == 'referral_name') { $attribute = $customer_table . '.entity_id'; } elseif ($attribute == 'status') { $attribute = 'main_table.' . $attribute; } return parent::addFieldToFilter($attribute, $condition); // if($attribute=='customer_id'){ // //zend_debug::dump( $condition);die(); // //var_dump($condition);die(); // if(is_array($condition)) // { // if(isset($condition['like'])){ // $this->getSelect()->where('main_table.customer_id like "'.$condition['like'].'"'); // } // elseif(isset($condition['eq'])){ // $this->getSelect()->where('main_table.customer_id="'.$condition['eq'].'"'); // } // } // else // { // $this->getSelect()->where('main_table.customer_id="'.$condition.'"'); // } // // return $this; // } // elseif($attribute=='referral_name'){ // if(is_array($condition)) // { // if(isset($condition['eq'])) // $this->getSelect()->where('customer_entity.entity_id="'.$condition['eq'].'"'); // } // else // $this->getSelect()->where('customer_entity.entity_id="'.$condition.'"'); // return $this; // } // elseif($attribute=='status'){ // //zend_debug::dump( $condition);die(); // if(is_array($condition)) // { // if(isset($condition['eq'])) // $this->getSelect()->where('main_table.status="'.$condition['eq'].'"') ; // } // else // $this->getSelect()->where('main_table.status="'.$condition.'"') ; // return $this; // } // else // //return $this; // return parent::addFieldToFilter($attribute, $condition); // //return $this->addFieldToFilter($attribute, $condition); }
public function addFieldToFilter($field, $condition = null) { if ($field == 'name') { $conditionSql = $this->_getConditionSql('p.value', $condition); $this->getSelect()->where($conditionSql); } else { parent::addFieldToFilter($field, $condition); } }
public function addFieldToFilter($_54323be853e934686a9fca46e2f91c8ead26624e, $_55ad5c06b371f3f9d1e174f486987755fa902aae = null) { if ($this->inGrid) { $_0eb9b814d24c46aabdec08a2a96bba977ba72889 = array('cemail' => 'customer.email', 'email' => 'main_table.email', 'ccustomer_id' => 'customer_id_table.value'); if (isset($_0eb9b814d24c46aabdec08a2a96bba977ba72889[$_54323be853e934686a9fca46e2f91c8ead26624e])) { $_54323be853e934686a9fca46e2f91c8ead26624e = $_0eb9b814d24c46aabdec08a2a96bba977ba72889[$_54323be853e934686a9fca46e2f91c8ead26624e]; } } return parent::addFieldToFilter($_54323be853e934686a9fca46e2f91c8ead26624e, $_55ad5c06b371f3f9d1e174f486987755fa902aae); }
public function addFieldToFilter($field, $condition = null) { switch ($field) { case 'order_increment_id': $this->getSelect()->where('log_id IN (?)', new Zend_Db_Expr('SELECT DISTINCT log_id FROM ' . $this->getResource()->getMainTable() . '_order JOIN ' . $this->getTable('sales/order') . ' ON ' . $this->getTable('sales/order') . '.entity_id = ' . $this->getResource()->getMainTable() . '_order.order_id WHERE ' . $this->_getConditionSql($this->getTable('sales/order') . '.increment_id', $condition))); return $this; default: return parent::addFieldToFilter($field, $condition); } }
public function addFieldToFilter($field, $condition = null) { if ($storeId = $this->getStoreId()) { $model = Mage::getSingleton($this->getModelName()); $attributes = array_merge($model->getStoreAttributes(), $model->getBalanceAttributes()); if (in_array($field, $attributes)) { if (!in_array($field, $this->_addedTable)) { $this->getSelect()->joinLeft(array($field => $this->getTable('affiliateplus/account_value')), "main_table.account_id = {$field}.account_id" . " AND {$field}.store_id = {$storeId}" . " AND {$field}.attribute_code = '{$field}'", array()); $this->_addedTable[] = $field; } return parent::addFieldToFilter("IF({$field}.value_id IS NULL, main_table.{$field}, {$field}.value)", $condition); } } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($field, $condition = null) { $attributes = array('title', 'content', 'status'); $storeId = $this->getStoreId(); if (in_array($field, $attributes) && $storeId) { if (!in_array($field, $this->_addedTable)) { $this->getSelect()->joinLeft(array($field => $this->getTable('productfile/value')), "main_table.productfile_id = {$field}.productfile_id" . " AND {$field}.store_id = {$storeId}" . " AND {$field}.attribute_code = '{$field}'", array()); $this->_addedTable[] = $field; } return parent::addFieldToFilter("IF({$field}.value IS NULL, main_table.{$field}, {$field}.value)", $condition); } if ($field == 'productfile_id') { $field = 'main_table.productfile_id'; } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($attribute, $condition = null) { $affiliatecustomer = Mage::getModel('affiliate/affiliatecustomers')->getCollection(); $affiliatecustomer_table = $affiliatecustomer->getTable('affiliatecustomers'); if ($attribute == 'customer_email') { $attribute = $affiliatecustomer_table . '.customer_id'; } elseif ($attribute == 'payment_gateway') { $attribute = $affiliatecustomer_table . '.payment_gateway'; } elseif ($attribute == 'status') { $attribute = 'main_table.' . $attribute; } return parent::addFieldToFilter($attribute, $condition); // if($attribute=='customer_email'){ // if(is_array($condition)) // { // if(isset($condition['eq'])) // $this->getSelect()->where('mw_affiliate_customers.customer_id="'.$condition['eq'].'"'); // } // else // $this->getSelect()->where('mw_affiliate_customers.customer_id="'.$condition.'"'); // return $this; // } // elseif($attribute=='payment_gateway'){ // if(is_array($condition)) // { // if(isset($condition['eq'])) // $this->getSelect()->where('mw_affiliate_customers.payment_gateway="'.$condition['eq'].'"') ; // } // else // $this->getSelect()->where('mw_affiliate_customers.payment_gateway="'.$condition.'"') ; // return $this; // } // elseif($attribute=='status'){ // if(is_array($condition)) // { // if(isset($condition['eq'])) // $this->getSelect()->where('main_table.status="'.$condition['eq'].'"') ; // } // else // $this->getSelect()->where('main_table.status="'.$condition.'"') ; // return $this; // } // else // //return $this; // return parent::addFieldToFilter($attribute, $condition); // //return $this->addFieldToFilter($attribute, $condition); }
/** * Redefining of standart field to filter adding, for aviability of * bit operations for display state * * * @param string|array $attribute * @param null|string|array $condition * @return Enterprise_CatalogEvent_Model_Mysql4_Event_Collection */ public function addFieldToFilter($field, $condition = null) { if ($field == 'display_state') { $field = $this->_getMappedField($field); if (is_array($condition) && isset($condition['eq'])) { $condition = $condition['eq']; } $this->_select->where('(' . $field . ' & ' . (int) $condition . ') = ' . (int) $condition); return $this; } if ($field == 'status') { $this->getSelect()->where($this->_getConditionSql($this->_getStatusColumnExpr(), $condition)); return $this; } parent::addFieldToFilter($field, $condition); return $this; }
public function addFieldToFilter($field, $condition = null) { $attributes = array('name', 'status', 'click_url'); $storeId = $this->getStoreId(); if (in_array($field, $attributes) && $storeId) { if (!in_array($field, $this->_addedTable)) { $this->getSelect()->joinLeft(array($field => $this->getTable('bannerslider/value')), "main_table.banner_id = {$field}.banner_id" . " AND {$field}.store_id = {$storeId}" . " AND {$field}.attribute_code = '{$field}'", array()); $this->_addedTable[] = $field; } $this->getSelect()->where("IF({$field}.value IS NULL, main_table.{$field}, {$field}.value) = {$condition}"); return $this; // return parent::addFieldToFilter("IF(faq_value_$field.value IS NULL, main_table.$field, faq_value_$field.value)", $condition); } if ($field == 'store_id') { $field = 'main_table.banner_id'; } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($field, $condition = null) { $attributes = array('package_name', 'description', 'package_status'); $storeId = $this->getStoreId(); $newStoreId = Mage::app()->getStore($storeId)->getWebsite()->getDefaultStore()->getId(); if (in_array($field, $attributes) && $storeId) { if (!in_array($field, $this->_addedTable)) { if ($field == 'package_status') { $this->getSelect()->joinLeft(array($field => $this->getTable('membership/packagevalue')), "main_table.package_id = {$field}.package_id" . " AND {$field}.store_id = {$newStoreId}" . " AND {$field}.attribute_code = '{$field}'", array()); } else { $this->getSelect()->joinLeft(array($field => $this->getTable('membership/packagevalue')), "main_table.package_id = {$field}.package_id" . " AND {$field}.store_id = {$storeId}" . " AND {$field}.attribute_code = '{$field}'", array()); } $this->_addedTable[] = $field; } return parent::addFieldToFilter("IF({$field}.value IS NULL, main_table.{$field}, {$field}.value)", $condition); } if ($field == 'package_id') { $field = 'main_table.package_id'; } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($field, $condition = null) { $attributes = array('name', 'is_featured', 'page_title', 'meta_keywords', 'meta_description', 'short_description', 'description', 'status'); $storeId = $this->getStoreId(); if (in_array($field, $attributes) && $storeId) { if (!in_array('brand_' . $field, $this->_addedTable)) { $this->getSelect()->joinLeft(array('brand_' . $field => $this->getTable('shopbybrand/brandvalue')), "main_table.brand_id = brand_{$field}.brand_id" . " AND brand_{$field}.store_id = {$storeId}" . " AND brand_{$field}.attribute_code = '{$field}'", array()); $this->_addedTable[] = 'brand_' . $field; } return parent::addFieldToFilter("IF(brand_{$field}.value IS NULL, main_table.{$field}, brand_{$field}.value)", $condition); } if ($field == 'store_id') { $field = 'main_table.store_id'; } $field = $this->_getMappedField($field); if (strpos($field, 'SUM') === false && strpos($field, 'COUNT') === false) { $this->_select->where($this->_getConditionSql($field, $condition), null, null); // Varien_Db_Select::TYPE_CONDITION); } else { $this->_select->having($this->_getConditionSql($field, $condition), null, null); // Varien_Db_Select::TYPE_CONDITION); } return $this; }
public function addFieldToFilter($field, $condition = null) { if ($this->getJoinFlag('relation') && 'popularity' == $field) { // TOFIX $this->getSelect()->having($this->_getConditionSql('count(relation.tag_relation_id)', $condition)); } elseif ($this->getJoinFlag('summary') && in_array($field, array('customers', 'products', 'uses', 'historical_uses', 'popularity'))) { $this->getSelect()->where($this->_getConditionSql('summary.' . $field, $condition)); } else { parent::addFieldToFilter($field, $condition); } return $this; }
/** * Re-declared for support website id filter * * @param string $field * @param mixed $condition * * @return Bronto_Reminder_Model_Mysql4_Rule_Collection */ public function addFieldToFilter($field, $condition = null) { if ($field == 'website_ids') { return $this->addWebsiteFilter($condition); } return parent::addFieldToFilter($field, $condition); }
public function addFieldToFilter($field, $condition = null) { if (!is_null($condition)) { parent::addFieldToFilter($field, $condition); $this->_countFilterPart[] = $this->_getConditionSql($this->_getFieldTableAlias($field), $condition); } return $this; }
/** * Add field filter to collection * * If $attribute is an array will add OR condition with following format: * array( * array('attribute'=>'firstname', 'like'=>'test%'), * array('attribute'=>'lastname', 'like'=>'test%'), * ) * * @see self::_getConditionSql for $condition * @param string|array $attribute * @param null|string|array $condition * @return Mage_Eav_Model_Entity_Collection_Abstract */ public function addFieldToFilter($field, $condition = null) { if (isset($this->_fields[$field])) { $field = $this->_fields[$field]; } return parent::addFieldToFilter($field, $condition); }
/** * Redeclared for support website id filter * * @param string $field * @param mixed $condition * @return Enterprise_CustomerSegment_Model_Mysql4_Segment_Collection */ public function addFieldToFilter($field, $condition = null) { if ($field == 'website_ids') { return $this->addWebsiteFilter($condition); } else { if ($field == $this->getResource()->getIdFieldName()) { $field = 'main_table.' . $field; } } return parent::addFieldToFilter($field, $condition); }