public function insert() { $this->set('created', Gpf_DbEngine_Database::getDateString()); $this->set('downloads', 0); $this->set('referenced', 0); return parent::insert(); }
public static function expireOldRequest() { $sql = new Gpf_SqlBuilder_UpdateBuilder(); $sql->set->add(self::STATUS, self::STATUS_EXPIRED); $sql->from->add(self::getName()); $sql->where->add(self::STATUS, '=', self::STATUS_PENDING); $sql->where->add(self::CREATED, '<', Gpf_DbEngine_Database::getDateString(time() - self::VALID_SECONDS)); $sql->execute(); }
protected function initDate(Pap_Stats_Params $statsParams, $timeOffset) { $clientTime = $this->createCurrentTime() + $timeOffset; $lastStartDay = $this->getLastStartDay($clientTime); $this->dateFrom = Gpf_DbEngine_Database::getDateString( mktime(0,0,0,date("m",$clientTime), date("d",$clientTime) - $lastStartDay, date("Y",$clientTime)) - $timeOffset); $this->dateTo = Gpf_DbEngine_Database::getDateString( mktime(23,59,59,date("m",$clientTime), date("d",$clientTime) - $lastStartDay + 6, date("Y",$clientTime)) - $timeOffset); $statsParams->setDateRange($this->dateFrom, $this->dateTo); }
public function saveLanguageMetadata(Gpf_Db_Language $lang) { $lang->setName($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_NAME)); $lang->setEnglishName($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_ENG_NAME)); $lang->setActive(true); $lang->setAuthor($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_AUTHOR)); $lang->setVersion($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_VERSION)); $lang->setImported(Gpf_DbEngine_Database::getDateString()); $lang->setDateFormat($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_DATE_FORMAT)); $lang->setTimeFormat($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_TIME_FORMAT)); $lang->setThousandsSeparator($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_THOUSANDS_SEPARATOR)); $lang->setDecimalSeparator($this->language->getMetaValue(Gpf_Lang_CsvLanguage::LANG_DECIMAL_SEPARATOR)); $lang->setTranslatedPercentage($this->language->getTranslationPercentage()); $lang->setIsDefault(false); $lang->save(); }
/** * * @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 addSessionInfoToCache() { $sessionInfo = new Gpf_Rpc_Data(); $sessionInfo->setValue(Gpf_Rpc_Params::SESSION_ID, Gpf_Session::getInstance()->getId()); $sessionInfo->setValue('loggedUser', Gpf_Session::getAuthUser()->getFirstName() . ' ' . Gpf_Session::getAuthUser()->getLastName()); $sessionInfo->setValue('loggedUserEmail', Gpf_Session::getAuthUser()->getUsername()); $sessionInfo->setValue('serverTime', Gpf_DbEngine_Database::getDateString()); $sessionInfo->setValue('baseUrl', rtrim(Gpf_Paths::getInstance()->getBaseServerUrl(), '/')); $this->setSessionInfo($sessionInfo); Gpf_Rpc_CachedResponse::addById($sessionInfo, self::SESSION); }
public function insert() { $this->set('created', Gpf_DbEngine_Database::getDateString()); parent::insert(); }
function insert() { $this->set(Gpf_Db_Table_PasswordRequests::CREATED, Gpf_DbEngine_Database::getDateString()); $this->setStatus(Gpf_Db_Table_PasswordRequests::STATUS_PENDING); parent::insert(); }
public function insert() { $this->set('imported', Gpf_DbEngine_Database::getDateString()); $this->setId($this->generateId()); $this->checkIsDefaultStatus(); return parent::insert(); }
protected function setTimeVariableValues($timeOffset = 0) { parent::setTimeVariableValues($timeOffset); $this->setVariable('validUntil', Gpf_DbEngine_Database::getDateString(time() + Gpf_Db_Table_PasswordRequests::VALID_SECONDS + $timeOffset)); }
protected function getWeek($year, $month, $day, $dayFrom, $dayTo) { $w = date('w', mktime(0, 0, 0, $month, $day, $year)); $dateRange['from'] = Gpf_DbEngine_Database::getDateString($this->getServerTime(mktime(0, 0, 0, $month, $day - $w + $dayFrom, $year))); $dateRange['to'] = Gpf_DbEngine_Database::getDateString($this->getServerTime(mktime(23, 59, 59, $month, $day - $w + $dayTo, $year))); return $dateRange; }