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