protected function initDate(Pap_Stats_Params $statsParams, $timeOffset) {
$filter = new Gpf_SqlBuilder_Filter(array("month", "DP", "LM"));
$filter->setTimeOffset($timeOffset);
$datePreset = $filter->addDateValueToArray(array());
$statsParams->setDateRange($datePreset["dateFrom"], $datePreset["dateTo"]);
$this->dateFrom = $datePreset["dateFrom"];
$this->dateTo = $datePreset["dateTo"];
}
/**
*
* @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;
}
private function getDateArray($datePreset) {
$filter = new Gpf_SqlBuilder_Filter(array('', 'DP', $datePreset));
return $filter->addDateValueToArray(array());
}
private function getDateArray(Gpf_SqlBuilder_Filter $filter) {
return $filter->addDateValueToArray(array());
}
private function getStatsParametersFromFilter() {
$this->statsChannel = $this->getChannel();
$filters = $this->getParam("filters");
if (!is_array($filters)) {
return;
}
$arrParams = array();
foreach ($filters as $filterArray) {
$filter = new Gpf_SqlBuilder_Filter($filterArray);
if($filter->getCode() == "statsdate") {
$arrParams = $filter->addDateValueToArray($arrParams);
}
}
if(count($arrParams) > 0) {
$this->statsDateFrom = $arrParams['dateFrom'];
$this->statsDateTo = $arrParams['dateTo'];
} else {
$this->statsDateFrom = date("Y-m-d H:i:s", Gpf_DateTime::MIN_TIMESTAMP);
$this->statsDateTo = date("Y-m-d H:i:s", time());
}
return '';
}
