private function formatAttachments(Gpf_DbEngine_Row_Collection $attachements)
{
if ($attachements->getSize() > 0) {
$output = '';
foreach ($attachements as $attachement) {
$output .= "<a href=\"" . $attachement->getUrl() . "\" target=\"_blank\">" . $attachement->getFileName() . '</a>, ';
}
return substr($output, 0, strlen($output) - 2);
} else {
return "No attachments";
}
}
/**
* @param array $transactionIds
* @return Gpf_DbEngine_Row_Collection
*/
private function getCollectionFromIds($transactionIds) {
$collection = new Gpf_DbEngine_Row_Collection();
foreach ($transactionIds as $transactionId) {
$row = new Pap_Db_Transaction();
$row->setId($transactionId);
$row->load();
$collection->add($row);
}
return $collection;
}
protected function getCommissionsCollection(Pap_Contexts_Tracking $context) {
$tier = 1;
$currentUser = $context->getUserObject();
$collection = new Gpf_DbEngine_Row_Collection();
while($currentUser != null && $tier < 100) {
$tierCommissions = $this->getTierCommissionCollection($context, $currentUser->getId(), $tier);
foreach ($tierCommissions as $dbCommission) {
$context->debug('Adding commission commissiontypeid: '.$dbCommission->get(Pap_Db_Table_Commissions::TYPE_ID).
', commissiongroupid: '.$dbCommission->get(Pap_Db_Table_Commissions::GROUP_ID).
', tier: '.$dbCommission->get(Pap_Db_Table_Commissions::TIER).
', subtype: '.$dbCommission->get(Pap_Db_Table_Commissions::SUBTYPE));
$collection->add($dbCommission);
}
$tier++;
$currentUser = $this->userTree->getParent($currentUser);
}
return $collection;
}
/**
* @return Gpf_DbEngine_Row_Collection
*/
protected function fillCollectionFromRecordset(Gpf_DbEngine_Row_Collection $collection, Gpf_Data_RecordSet $rowsRecordSet)
{
foreach ($rowsRecordSet as $rowRecord) {
$dbRow = clone $this;
$dbRow->fillFromRecord($rowRecord);
$dbRow->isPersistent = true;
$collection->add($dbRow);
}
return $collection;
}
/**
* @param $clicks array<Pap_Db_ClickImpression>
* @return Pap_Db_ClickImpression
*/
private function fixTooManyRows(Gpf_DbEngine_Row_Collection $clicks) {
if ($clicks->getSize() <= 0) {
return null;
}
$first = true;
foreach ($clicks as $click) {
if ($first) {
$firstClick = $click;
$first = false;
continue;
}
$firstClick->mergeWith($click);
$click->delete();
}
$firstClick->save();
return $firstClick;
}
protected function getTotalCost(Gpf_DbEngine_Row_Collection $transactions) {
if ($transactions->getSize() == 0) {
return $this->_('unknown');
}
return $transactions->get(0)->getTotalCostAsText();
}
private function addSaleToVisitorAffiliates(Pap_Db_VisitorAffiliate $saleVisitorAffiliate, Gpf_DbEngine_Row_Collection $visitorAffiliates) {
$iterator = $visitorAffiliates->getIterator();
while ($iterator->valid()) {
$visitorAffiliate = $iterator->current();
if ($this->isSameVisitorAffiliates($saleVisitorAffiliate, $visitorAffiliate)) {
$visitorAffiliate->setActual(Pap_Db_VisitorAffiliate::TYPE_ACTUAL);
return;
}
$iterator->next();
}
if ($visitorAffiliates->getSize() == 1 && $this->firstClickCookie != null) {
$visitorAffiliates->add($saleVisitorAffiliate);
return;
}
$visitorAffiliates->insert($visitorAffiliates->getSize() - 1, $saleVisitorAffiliate);
}
/**
* @param $transactionId
* @param Gpf_DbEngine_Row_Collection $affectedTransactions
*/
public function removeByTransactionId($transactionId, Gpf_DbEngine_Row_Collection $affectedTransactions) {
foreach ($affectedTransactions as $key => $transaction) {
if ($transaction->getId() == $transactionId) {
$affectedTransactions->remove($key);
}
}
}
