public function run() { $time1 = microtime(); Pap3Compatibility_Migration_OutputWriter::logOnce("Deleting migrated data from existing PAP4 tables<br/>"); try { $this->deleteTable(Pap_Db_Table_Campaigns::getName()); $this->deleteTable(Pap_Db_Table_CommissionGroups::getName()); $this->deleteTable(Pap_Db_Table_CommissionTypes::getName()); $this->deleteTable(Pap_Db_Table_Commissions::getName()); $this->deleteTable(Pap_Db_Table_UserInCommissionGroup::getName()); $this->deleteTable(Gpf_Db_Table_FormFields::getName()); $this->deleteTable(Gpf_Db_Table_FieldGroups::getName()); $this->deleteTable(Pap_Db_Table_Transactions::getName()); $this->deleteTable(Pap_Db_Table_Clicks::getName()); $this->deleteTable(Pap_Db_Table_RawClicks::getName()); $this->deleteTable(Pap_Db_Table_Impressions::getName()); $this->deleteTable(Pap_Db_Table_Banners::getName()); $this->deleteTable(Gpf_Db_Table_FieldGroups::getName()); $this->deleteTable(Pap_Db_Table_PayoutsHistory::getName()); $this->deleteTable(Pap_Db_Table_Payouts::getName()); $this->deleteTable(Gpf_Db_Table_Currencies::getName()); $this->deleteTable(Gpf_Db_Table_MailAccounts::getName()); } catch(Exception $e) { Pap3Compatibility_Migration_OutputWriter::log(" Errror: ".$e->getMessage()."<br/>"); } $time2 = microtime(); Pap3Compatibility_Migration_OutputWriter::logDone($time1, $time2); }
/** * @return Pap_Db_Table_Impressions */ public static function getInstance() { if (self::$instance === null) { self::$instance = new self(); } return self::$instance; }
protected function init() { $this->setTable(Pap_Db_Table_Impressions::getInstance()); parent::init(); }
public function __construct(Pap_Stats_Params $params) { parent::__construct(Pap_Db_Table_Impressions::getInstance(), $params); }
protected function buildStatsFrom() { $statParams = $this->getStatsParameters(); if ($this->areColumnsRequiredOrInFilter(array(self::CLICKS_RAW, self::CLICKS_UNIQUE, self::CTR_RAW, self::CTR_UNIQUE, self::SCR_RAW, self::SCR_UNIQUE, self::AVG_COMMISSION_PER_CLICK))) { $clickSelect = Pap_Db_Table_Clicks::getInstance()->getStatsSelect($statParams, $this->groupColumn, self::GROUP_COLUMN_ALIAS); $this->_selectBuilder->from->addLeftJoin('('.$clickSelect->toString().')', 'cl', 'cl.'.self::GROUP_COLUMN_ALIAS.'='.$this->mainTablePreffix. '.'. $this->mainTableColumn); } if ($this->areColumnsRequiredOrInFilter(array(self::IMPRESSIONS_RAW, self::IMPRESSIONS_UNIQUE, self::CTR_RAW, self::CTR_UNIQUE, self::AVG_COMMISSION_PER_IMP))) { $impSelect = Pap_Db_Table_Impressions::getInstance()->getStatsSelect($statParams, $this->groupColumn, self::GROUP_COLUMN_ALIAS); $this->_selectBuilder->from->addLeftJoin('('.$impSelect->toString().')', 'im', 'im.'.self::GROUP_COLUMN_ALIAS.'='.$this->mainTablePreffix. '.'. $this->mainTableColumn); } if ($this->areColumnsRequiredOrInFilter(array(self::SALES_COUNT, self::SALES_TOTAL, self::COMMISSIONS, self::SCR_RAW, self::SCR_UNIQUE, self::AVG_COMMISSION_PER_CLICK, self::AVG_COMMISSION_PER_IMP, self::AVG_AMOUNT_OF_ORDER))) { $transSelect = $this->getTransactionStatsSelect($statParams); $this->addJoinSelectToSelectBuilder($transSelect, 'tr'); } Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Pap_Common_StatsGrid.buildStatsFrom', new Pap_Common_StatsGridParamsContext($this->_selectBuilder, $this, $statParams)); }