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);
}
protected function init() {
$this->setTable(Pap_Db_Table_Clicks::getInstance());
parent::init();
}
public function __construct(Pap_Stats_Params $params) {
parent::__construct(Pap_Db_Table_Clicks::getInstance(), $params);
}
public function __construct(Pap_Stats_Params $params, $timeGroupBy, $type = Pap_Db_Table_Clicks::RAW) {
parent::__construct(Pap_Db_Table_Clicks::getInstance(), $params, $timeGroupBy);
$this->type = $type;
}
/**
* @return Pap_Db_Table_Clicks
*/
public static function getInstance() {
if(self::$instance === null) {
self::$instance = new self;
}
return self::$instance;
}
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));
}
