private function addSearch(Gpf_SqlBuilder_Filter $filter) { $whereCond = new Gpf_SqlBuilder_CompoundWhereCondition(); $whereCond->add('av.'.Gpf_Db_Table_ActiveViews::VIEWTYPE, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $whereCond->add('av.'.Gpf_Db_Table_ActiveViews::ACTIVEVIEWID, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $whereCond->add('v.'.Gpf_Db_Table_Views::NAME, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $this->_selectBuilder->where->addCondition($whereCond); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('atc.'.Pap_Db_Table_AffiliateTrackingCodes::AFFILIATEID, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('cam.'.Pap_Db_Table_Campaigns::NAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('com.'.Pap_Db_Table_CommissionTypes::NAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('atc.'.Pap_Db_Table_AffiliateTrackingCodes::CODE, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('au.username', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.firstname', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.lastname', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add(Pap_Db_Table_DirectLinkUrls::URL, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('b.name', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.name', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
protected function getFilterValue(Gpf_Rpc_Params $params, $code) { $filters = $params->get('filters'); if (is_array($filters)) { foreach ($filters as $filterArray) { $filter = new Gpf_SqlBuilder_Filter($filterArray); if ($filter->getCode() == $code) { return $filter->getValue(); } } } throw new Gpf_Exception($this->_('Can not create field')); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('ucg.userid', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.username', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.firstname', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.lastname', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $this->_selectBuilder->where->add(Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%' . $filter->getValue() .'%', "OR"); $this->_selectBuilder->where->add(Pap_Db_Table_Transactions::DATE_INSERTED, 'LIKE', '%' . $filter->getValue() .'%', "OR"); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('c.'.Pap_Db_Table_Coupons::CODE, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.'.Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Coupons::VALID_FROM, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Coupons::VALID_TO, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Coupons::MAX_USE_COUNT, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Coupons::USE_COUNT, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $this->searchString = $filter->getValue(); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('u.' . Pap_Db_Table_Users::ID, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('u.' . Pap_Db_Table_Users::REFID, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.' . Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.' . Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.' . Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('concat(au.' . Gpf_Db_Table_AuthUsers::FIRSTNAME . ', \' \', au.' . Gpf_Db_Table_AuthUsers::LASTNAME . ')', 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('concat(au.' . Gpf_Db_Table_AuthUsers::LASTNAME . ', \' \', au.' . Gpf_Db_Table_AuthUsers::FIRSTNAME . ')', 'LIKE', '%'.$filter->getValue().'%', 'OR'); for ($i=1; $i<=25; $i++) { $condition->add('u.data'.$i, 'LIKE', '%'.$filter->getValue().'%', 'OR'); } $condition->add('pau.' . Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('pau.' . Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('pau.' . Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('pay.' . Gpf_Db_Table_FieldGroups::NAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('au.' . Gpf_Db_Table_AuthUsers::IP, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('subrc.'.Pap_Db_Table_RawClicks::ID, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('subrc.'.Pap_Db_Table_RawClicks::DATA1, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('subrc.'.Pap_Db_Table_RawClicks::DATA2, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('subrc.'.Pap_Db_Table_RawClicks::IP, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->rawClicksSelect->where->addCondition($condition); }
/** * @param Gpf_SqlBuilder_Filter $filter * @return Gpf_SqlBuilder_CompoundWhereCondition */ private function getPayoutMethodsCondition(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $values = explode(',', $filter->getValue()); foreach ($values as $value) { if ($value === 'null') { $condition->add("pu.payoutoptionid", '=', null, 'OR', $filter->getOperator("IN")->getDoQuote()); $condition->add("pu.payoutoptionid", '=', '', 'OR', $filter->getOperator("IN")->getDoQuote()); continue; } $condition->add("pu.payoutoptionid", '=', $value, 'OR', $filter->getOperator("IN")->getDoQuote()); } return $condition; }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $compoundWhere = new Gpf_SqlBuilder_CompoundWhereCondition(); $compoundWhere->add('au.'.Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $compoundWhere->add('au.'.Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $compoundWhere->add('au.'.Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $compoundWhere->add('a.'.Gpf_Db_Table_Accounts::ID, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $compoundWhere->add('a.'.Gpf_Db_Table_Accounts::NAME, 'LIKE', '%' . $filter->getValue() .'%', 'OR'); $this->_selectBuilder->where->addCondition($compoundWhere); }
private function getChannel() { $filters = $this->getParam("filters"); if($filters != null && $filters != false) { if (is_array($filters)) { foreach ($filters as $filterArray) { $filter = new Gpf_SqlBuilder_Filter($filterArray); $filterCode = $filter->getCode(); if($filterCode == 'channel') { return $this->loadChannelFromId($filter->getValue()); } } } } return null; }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $this->_selectBuilder->where->add("va.".Pap_Db_Table_VisitorAffiliates::IP, 'LIKE', '%' . $filter->getValue() .'%', "OR"); $this->_selectBuilder->where->add("va.".Pap_Db_Table_VisitorAffiliates::VISITORID, 'LIKE', '%' . $filter->getValue() .'%', "OR"); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $cond = new Gpf_SqlBuilder_CompoundWhereCondition(); $cond->add(Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $cond->add(Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $cond->add(Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $cond->add(Gpf_Db_Table_Roles::NAME, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $cond->add('l.' . Gpf_Db_Table_LoginsHistory::IP, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $this->_selectBuilder->where->addCondition($cond); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add(Pap_Db_Table_Channels::NAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('r.'.$this->groupColumn, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
private function addTimeFilter(Gpf_SqlBuilder_Filter $filter, Gpf_SqlBuilder_CompoundWhereCondition $timeFilterCompoundWhere, $firtsTimeFilter = null) { $logicOperator = 'AND'; if (!is_null($firtsTimeFilter) && Gpf_Common_DateUtils::getServerHours($firtsTimeFilter->getValue()) > Gpf_Common_DateUtils::getServerHours($filter->getValue())) { $logicOperator = 'OR'; } $operator = $filter->getRawOperator(); $timeFilterCompoundWhere->add("HOUR(".$filter->getCode().")", $operator->getSqlCode(), Gpf_Common_DateUtils::getServerHours($filter->getValue()), $logicOperator, $operator->getDoQuote()); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $this->_selectBuilder->where->add('message', 'LIKE', '%' . $filter->getValue() . '%', "OR"); $this->_selectBuilder->where->add(Gpf_Db_Table_Logs::IP, 'LIKE', '%' . $filter->getValue() . '%', "OR"); $this->_selectBuilder->where->add(Gpf_Db_Table_Logs::GROUP_ID, 'LIKE', '%' . $filter->getValue() . '%', "OR"); }
private function addSearchFilter(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('m.' . Gpf_Db_Table_Mails::SUBJECT, 'LIKE', '%' . $filter->getValue() . '%'); $condition->add('m.' . Gpf_Db_Table_Mails::BODY_TEXT, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $condition->add('m.' . Gpf_Db_Table_Mails::BODY_HTML, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $condition->add('m.' . Gpf_Db_Table_Mails::TO_RECIPIENTS, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $condition->add('m.' . Gpf_Db_Table_Mails::CC_RECIPIENTS, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $condition->add('m.' . Gpf_Db_Table_Mails::BCC_RECIPIENTS, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $condition->add('m.' . Gpf_Db_Table_Mails::FROM_MAIL, 'LIKE', '%' . $filter->getValue() . '%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }
protected function initSearchAffiliateCondition(Gpf_SqlBuilder_Filter $filter) { $this->_affiliateCondition = new Gpf_SqlBuilder_CompoundWhereCondition(); $this->_affiliateCondition->add('au.'.Gpf_Db_Table_AuthUsers::USERNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_affiliateCondition->add('au.'.Gpf_Db_Table_AuthUsers::FIRSTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_affiliateCondition->add('au.'.Gpf_Db_Table_AuthUsers::LASTNAME, 'LIKE', '%'.$filter->getValue().'%', 'OR'); }
private function addSearch(Gpf_SqlBuilder_Filter $filter) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('c.'.Pap_Db_Table_Campaigns::NAME , 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Campaigns::ID , 'LIKE', '%'.$filter->getValue().'%', 'OR'); $condition->add('c.'.Pap_Db_Table_Campaigns::DESCRIPTION , 'LIKE', '%'.$filter->getValue().'%', 'OR'); $this->_selectBuilder->where->addCondition($condition); }