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 ''; }