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);
}
private function deleteRawClicks() {
if (Gpf_Settings::get(Pap_Settings::AUTO_DELETE_RAWCLICKS) <= 0) {
return;
}
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_RawClicks::getName());
$delete->where->add(Pap_Db_Table_RawClicks::RSTATUS, '=', 'P');
$delete->where->add(Pap_Db_Table_RawClicks::DATETIME, '<', $this->getLastDate(Gpf_Settings::get(Pap_Settings::AUTO_DELETE_RAWCLICKS))->toDateTime());
$delete->delete();
}
/**
*
* @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;
}
/**
* returns latest undeclined click from the given IP address
*
* @param string $ip
* @param int $periodInSeconds
* @return unknown
*/
public function getLatestClickFromIP($ip, $periodInSeconds) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(Pap_Db_Table_RawClicks::USERID, "userid");
$select->select->add(Pap_Db_Table_RawClicks::CHANNEL, "channel");
$select->from->add(Pap_Db_Table_RawClicks::getName());
$select->where->add(Pap_Db_Table_RawClicks::IP, "=", $ip);
$select->where->add(Pap_Db_Table_RawClicks::RTYPE, "<>", Pap_Db_ClickImpression::STATUS_DECLINED);
$dateFrom = new Gpf_DateTime();
$dateFrom->addSecond(-1*$periodInSeconds);
$select->where->add(Pap_Db_Table_RawClicks::DATETIME, ">", $dateFrom->toDateTime());
$select->orderBy->add(Pap_Db_Table_RawClicks::DATETIME, false);
$select->limit->set(0, 1);
$recordSet = new Gpf_Data_RecordSet();
$recordSet->load($select);
foreach($recordSet as $record) {
return array('userid' => $record->get("userid"), 'channel' => $record->get("channel"));
}
return null;
}
protected function initRawClicksSelect() {
$this->rawClicksSelect = new Gpf_SqlBuilder_SelectBuilder();
$this->rawClicksSelect->select->add('subrc.*');
$this->rawClicksSelect->from->add(Pap_Db_Table_RawClicks::getName(), 'subrc');
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.ClicksGrid.initRawClicksSelect', $this->rawClicksSelect);
}
public static function getInstance() {
if(self::$instance === null) {
self::$instance = new self;
}
return self::$instance;
}
