private function saveField(Gpf_Data_Record $field) {
$dbRow = $this->createDbRowObject();
$dbRow->setPrimaryKeyValue($field->get('id'));
$dbRow->load();
$dbRow->set($field->get("name"), $field->get("value"));
$dbRow->save();
}
/**
* Returns banner object for given banner record
*
* @param string $record banner record loaded from other code
* @return Pap_Common_Banner
*/
public function getBannerFromRecord(Gpf_Data_Record $record) {
$banner = $this->getBannerObjectFromType($record->get('rtype'));
if($banner == null) {
throw new Pap_Common_Banner_NotFound($record->get('id'));
}
$banner->fillFromRecord($record);
return $banner;
}
/**
* @param Gpf_Data_Record $campaign
* @return boolean
*/
private function isAffiliateInCampaign(Gpf_Data_Record $campaign) {
try {
Pap_Db_Table_UserInCommissionGroup::getStatus($campaign->get($this->campaignIDColumnName), $this->affiliateID);
} catch (Gpf_DbEngine_NoRowException $e) {
if ($campaign->get(Pap_Db_Table_Campaigns::TYPE) == Pap_Db_Campaign::CAMPAIGN_TYPE_ON_INVITATION) {
return false;
}
}
return true;
}
private function addFilteredByHeader(Gpf_Data_Record $record)
{
$newRecord = new Gpf_Data_Record($this->header);
foreach ($this->header as $column) {
$newRecord->set($column, $record->get($column));
}
$this->encode($newRecord->toObject());
}
private function fillResultRecord(Gpf_Data_Record $record, Gpf_Data_Record $row) {
foreach ($this->dataColumns as $columnId => $column) {
try {
$record->set($columnId, $row->get($column->getName()));
} catch (Gpf_Exception $e) {
$record->set($columnId, '');
}
}
return $record;
}
/**
* @param String $field
* @return Pap_Db_AffiliateTrackingCode
*/
protected function loadAffTrackingCode(Gpf_Data_Record $field) {
$codeId = $field->get('id');
if (substr($codeId, 0, 4) == 'NEW_') {
return $this->loadAffTrackingCodeFrom(substr($codeId, 4), $this->getAffiliateId());
}
$dbRow = $this->createDbRowObject();
$dbRow->setPrimaryKeyValue($codeId);
$dbRow->load();
return $dbRow;
}
protected function loadAuthData(Gpf_Data_Record $data)
{
$this->username = $data->get("username");
$this->accountUserId = $data->get("accountuserid");
$this->authtoken = $data->get("authtoken");
$this->accountid = $data->get("accountid");
$this->roletypeid = $data->get("roletypeid");
$this->roleid = $data->get('roleid');
$this->authId = $data->get('authid');
$this->firstname = $data->get('firstname');
$this->lastname = $data->get('lastname');
$this->ip = $data->get('ip');
$attributes = Gpf_Db_Table_UserAttributes::getInstance();
$attributes->loadAttributes($this->accountUserId);
$this->setLanguage($attributes->getAttributeWithDefaultValue(self::LANGUAGE_ATTRIBUTE_NAME, Gpf_Lang_Dictionary::getDefaultLanguage()));
}
protected function processRow(Gpf_Data_Record $dataRow, $commissionTypeId = self::DEFAULT_COMMISSION_TYPEID) {
if (!array_key_exists($commissionTypeId, $this->resultCommissions)) {
$this->resultCommissions[$commissionTypeId] = new Pap_Stats_Data_Commission();
$this->resultTotalCost[$commissionTypeId] = new Pap_Stats_Data_Commission();
$this->resultCount[$commissionTypeId] = new Pap_Stats_Data_Commission();
}
$status = $dataRow->get("status");
$commission = $dataRow->get("commission");
$totalcost = $dataRow->get("totalcost");
$count = $dataRow->get("cnt");
if ($dataRow->get("payoutstatus") == Pap_Common_Constants::PSTATUS_PAID) {
if ($status == Pap_Common_Constants::STATUS_APPROVED) {
$this->resultCommissions[$commissionTypeId]->addPaid($commission);
$this->resultTotalCost[$commissionTypeId]->addPaid($totalcost);
$this->resultCount[$commissionTypeId]->addPaid($count);
}
return;
}
if ($status == Pap_Common_Constants::STATUS_APPROVED) {
$this->resultCommissions[$commissionTypeId]->addApproved($commission);
$this->resultTotalCost[$commissionTypeId]->addApproved($totalcost);
$this->resultCount[$commissionTypeId]->addApproved($count);
return;
}
if ($status == Pap_Common_Constants::STATUS_PENDING) {
$this->resultCommissions[$commissionTypeId]->addPending($commission);
$this->resultTotalCost[$commissionTypeId]->addPending($totalcost);
$this->resultCount[$commissionTypeId]->addPending($count);
return;
}
$this->resultCommissions[$commissionTypeId]->addDeclined($commission);
$this->resultTotalCost[$commissionTypeId]->addDeclined($totalcost);
$this->resultCount[$commissionTypeId]->addDeclined($count);
}
private function processRow(Gpf_Data_Record $dataRow) {
$time = $dataRow->get("datetime");
$value = $dataRow->get("value");
$this->result[$this->convertTimeColumn($time)] = $value;
}
public function getCountryCode(Gpf_Data_Record $context) {
if ($context->get(Pap_Db_Table_RawImpressions::IP) == '127.0.0.1') {
$context->set(Pap_Db_Table_Impressions::COUNTRYCODE, '');
return;
}
if (in_array($context->get(Pap_Db_Table_RawImpressions::IP), self::$recognizedIPs)) {
$context->set(Pap_Db_Table_Impressions::COUNTRYCODE, self::$recognizedIPs[array_search($context->get(Pap_Db_Table_RawImpressions::IP), self::$recognizedIPs)]);
return;
}
try {
$location = new GeoIp_Location();
$location->setIpString($context->get(Pap_Db_Table_RawImpressions::IP));
$location->load();
$context->set(Pap_Db_Table_Impressions::COUNTRYCODE, $location->getCountryCode());
} catch (Exception $e) {
}
self::$recognizedIPs[$context->get(Pap_Db_Table_RawImpressions::IP)] = $context->get(Pap_Db_Table_Impressions::COUNTRYCODE);
}
public function matches(Gpf_Data_Record $record)
{
try {
$value = $record->get($this->getCode());
} catch (Gpf_Exception $e) {
return true;
}
switch ($this->operator->getCode()) {
case 'E':
return $value == $this->getValue();
case 'NE':
return $value != $this->getValue();
case 'L':
return strpos($value, $this->getValue()) !== false;
case 'NL':
return strpos($value, $this->getValue()) === false;
case 'IN':
return array_search($value, $this->decodeArrayValue()) !== false;
case 'NOT IN':
return array_search($value, $this->decodeArrayValue()) !== false;
default:
throw new Gpf_Exception('Unimplemented');
break;
}
}
public function writeRecord(Gpf_Data_Record $record)
{
$row = array();
foreach ($this->headers as $header) {
$row[] = $record->get($header);
}
fputcsv($this->getFileHandler(), $row, $this->delimiter, $this->enclosure);
}
public function loadFromRecord(Gpf_Data_Record $record)
{
$this->setSourceMessage($record->get('source'));
$this->setDestinationMessage($record->get('translation'));
$this->setType($record->get('type'));
$this->setStatus($record->get('status'));
$this->addModule($record->get('module'));
$this->setCustomerSpecific($record->get('customer'));
}
private function replaceConstants(Gpf_Data_Record $row) {
$coupon = new Pap_Db_Coupon();
$coupon->setId($row->get('id'));
$coupon->setCode($row->get('code'));
$coupon->setStatus($row->get('status'));
$coupon->set(Pap_Db_Table_Coupons::MAX_USE_COUNT, $row->get('limit_use'));
$coupon->set(Pap_Db_Table_Coupons::VALID_FROM, $row->get('valid_from'));
$coupon->set(Pap_Db_Table_Coupons::VALID_TO, $row->get('valid_to'));
$row->add('coupon', $this->banner->getCouponText($coupon));
$row->add('validity', $coupon->isValid());
}
public function getCampaigns(Gpf_Data_Record $record) {
try {
Pap_Db_Table_UserInCommissionGroup::getStatus($record->get('id'), Gpf_Session::getAuthUser()->getPapUserId());
} catch (Gpf_DbEngine_NoRowException $e) {
if ($record->get('rtype') == Pap_Db_Campaign::CAMPAIGN_TYPE_ON_INVITATION) {
throw new Gpf_Exception($this->_('Private campaign'));
}
}
}
/**
* @param Gpf_Data_Record $record
* @return array
*/
private function createUserArrayFromRecord(Gpf_Data_Record $record) {
$userArray = array();
$userArray[Pap_Db_Table_Users::ID] = $record->get(Pap_Db_Table_Users::ID);
$userArray[Pap_Db_Table_Users::getDataColumnName(3)] = $record->get(Pap_Db_Table_Users::getDataColumnName(3));
$userArray[Pap_Db_Table_Users::getDataColumnName(4)] = $record->get(Pap_Db_Table_Users::getDataColumnName(4));
$userArray[Pap_Db_Table_Users::getDataColumnName(5)] = $record->get(Pap_Db_Table_Users::getDataColumnName(5));
$userArray[Pap_Db_Table_Users::getDataColumnName(6)] = $record->get(Pap_Db_Table_Users::getDataColumnName(6));
$userArray[Pap_Db_Table_Users::getDataColumnName(7)] = $record->get(Pap_Db_Table_Users::getDataColumnName(7));
$userArray[Pap_Db_Table_Users::getDataColumnName(8)] = $record->get(Pap_Db_Table_Users::getDataColumnName(8));
$userArray[Pap_Db_Table_Users::getDataColumnName(9)] = $record->get(Pap_Db_Table_Users::getDataColumnName(9));
$userArray[Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL] = $record->get(Gpf_Db_Table_AuthUsers::NOTIFICATION_EMAIL);
$userArray[Gpf_Db_Table_AuthUsers::USERNAME] = $record->get(Gpf_Db_Table_AuthUsers::USERNAME);
$userArray[Gpf_Db_Table_AuthUsers::FIRSTNAME] = $record->get(Gpf_Db_Table_AuthUsers::FIRSTNAME);
$userArray[Gpf_Db_Table_AuthUsers::LASTNAME] = $record->get(Gpf_Db_Table_AuthUsers::LASTNAME);
$userArray[Pap_Db_Table_Payouts::AMOUNT] = $record->get(Pap_Db_Table_Payouts::AMOUNT);
$userArray[Gpf_Db_Table_Currencies::SYMBOL] = $record->get(Gpf_Db_Table_Currencies::SYMBOL);
$userArray[Gpf_Db_Table_Currencies::WHEREDISPLAY] = $record->get(Gpf_Db_Table_Currencies::WHEREDISPLAY);
return $userArray;
}
/**
* Fills Db_Row from a record
* Fields that are not part of the Db_Row are ignored
*
* @param Gpf_Data_Record $record
*/
public function fillFromRecord(Gpf_Data_Record $record)
{
foreach ($this->tableColumns as $column) {
$name = $column->name;
try {
$this->set($name, $record->get($name));
} catch (Gpf_Exception $e) {
}
}
$this->afterLoad();
}
public function getLastId()
{
return $this->getName() . $this->lastRecord->get(self::WIDGET_ID);
}
/**
* Mark outbox entry as pending + store error message why it failed
*
* @param Gpf_Data_Record $mail
* @param string $error
*/
private function failedSending(Gpf_Data_Record $mail, $error)
{
//mark outbox entry with status pending
$outbox = new Gpf_Db_MailOutbox();
$outbox->set('outboxid', $mail->get('outboxid'));
$outbox->set('status', Gpf_Db_Table_MailOutbox::STATUS_PENDING);
$outbox->set('error_msg', $error);
$outbox->set('scheduled_at', $this->createDatabase()->getDateString(time() + self::RETRY_TIME));
$outbox->update(array('status', 'error_msg', 'scheduled_at'));
}
protected function insertTransaction($affiliateId, $type, $commissionValue, $status, Gpf_Data_Record $commission = null) {
if ($affiliateId == null) {
return;
}
$transaction = new Pap_Common_Transaction();
$transaction->setUserId($affiliateId);
$transaction->setType($type);
if ($commission != null) {
$transaction->setTier($commission->get(Pap_Db_Table_Commissions::TIER));
} else {
$transaction->setTier('1');
}
$transaction->setStatus($status);
$transaction->setPayoutStatus('U');
$transaction->setDateInserted(Gpf_Common_DateUtils::now());
$transaction->setCommission($commissionValue);
$transaction->setData5($this->user->getId());
$transaction->setIp(Gpf_Http::getRemoteIp());
$transaction->insert();
}
protected function loadRecordFromObject(Gpf_Data_Record $record)
{
$this->_array[$record->get($this->key)] = $record;
}
private function getCommissionText(Gpf_Data_Record $commission) {
$tier = $commission->get('tier');
if ($tier > 1) {
return $this->getTier($tier);
}
switch ($commission->get('rtype')) {
case Pap_Common_Constants::TYPE_CLICK:
return $this->_('per click').' :';
case Pap_Common_Constants::TYPE_SALE:
return $this->_('per sale') . ' :';
case Pap_Common_Constants::TYPE_CPM:
return $this->_('per CPM') . ' :';
case Pap_Common_Constants::TYPE_ACTION:
return $this->_($commission->get('commissionTypeName')).":";
}
return '';
}
