protected function offsetLatestValue($latestQuarterValue, $offset) { // convering number of quarters to number of months $monthOffset = $offset * 3; $datetime = new DateTime($latestQuarterValue); $datetime->sub(new DateInterval("P{$monthOffset}M")); return $datetime->format(DateDataTypeHandler::getDateMask()); }
public static function adjustToFirstDayOfFiscalYear($date) { $proxy = new DateTimeProxy(new DateTime($date)); list($fiscalYear) = DateDimensionConfiguration::getFiscalMonth($proxy->getYear(), $proxy->getMonth()); // converting the date to the first day of corresponding year $adjustedDateTime = new DateTime(); $adjustedDateTime->setDate($fiscalYear, 1, 1); return $adjustedDateTime->format(DateDataTypeHandler::getDateMask()); }
public function selectCompatible($datatype) { return $datatype == DateDataTypeHandler::$DATA_TYPE ? DateDataTypeHandler::$DATA_TYPE : parent::selectCompatible($datatype); }
/** * @return DB */ private function getDataRecords() { DateDataTypeHandler::$MASK_CUSTOM = 'Y-m-d'; ini_set('max_execution_time', 0); $records = get_db_results(TRUE, $this->requestDataSet->name, $this->requestDataSet->columns, $this->requestDataSet->parameters, $this->requestDataSet->sortColumn, $this->requestDataSet->startWith, $this->requestDataSet->limit, NULL); return $records; }