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