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);
}
protected function initDate(Pap_Stats_Params $statsParams, $timeOffset) {
$filter = new Gpf_SqlBuilder_Filter(array("month", "DP", "LM"));
$filter->setTimeOffset($timeOffset);
$datePreset = $filter->addDateValueToArray(array());
$statsParams->setDateRange($datePreset["dateFrom"], $datePreset["dateTo"]);
$this->dateFrom = $datePreset["dateFrom"];
$this->dateTo = $datePreset["dateTo"];
}
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);
}
/**
*
* @service click delete
* @param ids, status
* @return Gpf_Rpc_Action
*/
public function deleteClicks(Gpf_Rpc_Params $params) {
$action = new Gpf_Rpc_Action($params);
$date = array();
switch ($action->getParam("status")) {
case self::DATE_ONE_WEEK:
$filter = new Gpf_SqlBuilder_Filter(array("", "DP", "L7D"));
$date = $filter->addDateValueToArray($date);
$olderThan = "one week";
break;
case self::DATE_TWO_WEEKS:
$dateFrom = Gpf_DbEngine_Database::getDateString(
Gpf_Common_DateUtils::getServerTime(
mktime(0,0,0,date("m"), date("d") - 14, date("Y"))));
$date = array("dateFrom" => $dateFrom);
$olderThan = "two weeks";
break;
case self::DATE_ONE_MONTH:
$filter = new Gpf_SqlBuilder_Filter(array("", "DP", "L30D"));
$date = $filter->addDateValueToArray($date);
$olderThan = "one month";
break;
}
$action->setInfoMessage($this->_("Raw clicks older than %s are deleted", $olderThan));
$action->setErrorMessage($this->_("Failed to delete raw clicks"));
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_RawClicks::getName());
$delete->where->add(Pap_Db_Table_RawClicks::DATETIME, "<", $date["dateFrom"]);
try {
$delete->delete();
$action->addOk();
} catch(Gpf_DbEngine_NoRowException $e) {
$action->addError();
}
return $action;
}
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);
}
/**
* @param array $userIds
* @param array $orderIds
* @return Gpf_DbEngine_Row_Collection
*/
public function getAffectedTransactionsList($userIds, $orderIds = array()) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Pap_Db_Table_Transactions::getInstance());
$select->from->add(Pap_Db_Table_Transactions::getName());
$dateRangeFilter = new Gpf_SqlBuilder_Filter();
$dateRange = $dateRangeFilter->decodeDatePreset(Pap_Features_CompressedCommissionPlacementModel_Processor::getRecurrencePreset());
$select->where->add(Pap_Db_Table_Transactions::DATE_INSERTED, '>', $dateRange['dateFrom']);
$select->where->add(Pap_Db_Table_Transactions::DATE_INSERTED, '<', $dateRange['dateTo']);
$select->where->add(Pap_Db_Table_Transactions::USER_ID, 'IN', $userIds);
if (!is_null($orderIds) && count($orderIds) > 0) {
$compoundCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
foreach ($orderIds as $orderId) {
$compoundCondition->add(Pap_Db_Table_Transactions::ORDER_ID, 'LIKE', '%'.$orderId.'%', 'OR');
}
$select->where->addCondition($compoundCondition);
}
$select->orderBy->add(Pap_Db_Table_Transactions::TIER);
$transaction = new Pap_Db_Transaction();
$transactionsRecordSet = $select->getAllRows();
$unpaidTransactions = new Gpf_Data_RecordSet();
$unpaidTransactions->setHeader($transactionsRecordSet->getHeader());
foreach ($transactionsRecordSet as $trans) {
if ($trans->get(Pap_Db_Table_Transactions::PAYOUT_STATUS) == Pap_Common_Constants::PSTATUS_UNPAID) {
$unpaidTransactions->add($trans);
} else {
$this->log('Removing paid transaction from affected transactions: ' . $trans->get(Pap_Db_Table_Transactions::TRANSACTION_ID));
}
}
return $transaction->loadCollectionFromRecordset($unpaidTransactions);
}
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 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);
}
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) {
$this->searchString = $filter->getValue();
}
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");
}
protected function buildFilter() {
if ($this->filterId && $this->filterId != 'custom') {
$sql = new Gpf_SqlBuilder_SelectBuilder();
$sql->select->addAll(Gpf_Db_Table_FilterConditions::getInstance());
$sql->from->add(Gpf_Db_Table_FilterConditions::getName());
$sql->where->add('filterid', '=', $this->filterId);
$conditions = $sql->getAllRows();
foreach ($conditions as $condition) {
$filterArray = array(
Gpf_SqlBuilder_Filter::FILTER_CODE => $condition->get('code'),
Gpf_SqlBuilder_Filter::FILTER_OPERATOR => $condition->get('operator'),
Gpf_SqlBuilder_Filter::FILTER_VALUE => $condition->get('value'));
$filter = new Gpf_SqlBuilder_Filter($filterArray);
if (array_key_exists($filter->getCode(), $this->dataColumns)) {
$dataColumn = $this->dataColumns[$filter->getCode()];
$filter->setCode($dataColumn->getName());
$filter->addTo($this->_selectBuilder->where);
} else {
$this->addFilter($filter);
}
}
}
if (!empty($this->recipients)) {
$condition = new Gpf_SqlBuilder_CompoundWhereCondition();
$condition->add('au.'.Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL, 'IN', $this->recipients, 'OR');
$condition->add('au.username', 'IN', $this->recipients, 'OR');
$this->_selectBuilder->where->addCondition($condition);
}
}
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 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);
}
private function isTimeFilter(Gpf_SqlBuilder_Filter $filter) {
$operator = $filter->getRawOperator();
if ($operator->getCode() == 'T>=' || $operator->getCode() == 'T<=' || $operator->getCode() == 'T<') {
return true;
}
return false;
}
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('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);
}
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);
}
/**
* @param Gpf_SqlBuilder_Filter $filter
*/
private function addTransactionDataFilter(Gpf_SqlBuilder_Filter $filter) {
$filter->addTo($this->subselect->where);
}
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 getDateArray(Gpf_SqlBuilder_Filter $filter) {
return $filter->addDateValueToArray(array());
}
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");
}
public function addNumberField($sqlCode, $name) {
$this->addField($sqlCode, $name,
Gpf_SqlBuilder_Filter::NUMBER,
$this->filter->getNumberOperators());
}
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');
}
/**
* @return Pap_Stats_Params
*/
protected function getStatsParameters() {
$params = new Pap_Stats_Params();
$dateRangeFilter = new Gpf_SqlBuilder_Filter();
$dateRange = $dateRangeFilter->decodeDatePreset(Pap_Features_CompressedCommissionPlacementModel_Processor::getRecurrencePreset());
$params->setDateRange($dateRange['dateFrom'], $dateRange['dateTo']);
$params->setStatus($this->getStatuses());
return $params;
}
protected function addFilter(Gpf_SqlBuilder_Filter $filter) {
switch ($filter->getCode()) {
case "countrycode":
$this->findCountryCode($filter);
break;
}
parent::addFilter($filter);
}
private function getDateArray($datePreset) {
$filter = new Gpf_SqlBuilder_Filter(array('', 'DP', $datePreset));
return $filter->addDateValueToArray(array());
}
/**
*
* @return Gpf_DateTime_Range
*/
public function getDateRange(Gpf_DateTime $now = null) {
if($now === null) {
$now = new Gpf_DateTime();
}
if ($this->getDate() == Pap_Features_PerformanceRewards_Rule::DATE_ALL_TIME
|| $this->getDate() == Pap_Features_PerformanceRewards_Rule::DATE_ALL_UNPAID_COMMISSIONS) {
$range = new Gpf_DateTime_Range();
return $range;
}
if ($this->getDate() == Pap_Features_PerformanceRewards_Rule::DATE_SINCE_DAY_OF_LAST_MONTH) {
$from = $now->getMonthStart();
$from->addMonth(-1);
$from->addDay($this->getSince() - 1);
$to = $now->getMonthStart();
$to->addDay(-1);
return new Gpf_DateTime_Range($from, $to);
}
$filter = new Gpf_SqlBuilder_Filter();
$result = $filter->decodeDatePreset($this->getDate());
return new Gpf_DateTime_Range(new Gpf_DateTime($result['dateFrom']), new Gpf_DateTime($result['dateTo']));
}
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("va.".Pap_Db_Table_VisitorAffiliates::IP, 'LIKE', '%' . $filter->getValue() .'%', "OR");
$this->_selectBuilder->where->add("va.".Pap_Db_Table_VisitorAffiliates::VISITORID, 'LIKE', '%' . $filter->getValue() .'%', "OR");
}
