diff options
Diffstat (limited to 'connectivity/source/drivers/file/FDateFunctions.cxx')
| -rw-r--r-- | connectivity/source/drivers/file/FDateFunctions.cxx | 278 |
1 files changed, 278 insertions, 0 deletions
diff --git a/connectivity/source/drivers/file/FDateFunctions.cxx b/connectivity/source/drivers/file/FDateFunctions.cxx new file mode 100644 index 000000000..1be992d4b --- /dev/null +++ b/connectivity/source/drivers/file/FDateFunctions.cxx @@ -0,0 +1,278 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#include <file/FDateFunctions.hxx> +#include <tools/date.hxx> +#include <tools/time.hxx> +#include <tools/datetime.hxx> +#include <osl/diagnose.h> + +using namespace connectivity; +using namespace connectivity::file; + +ORowSetValue OOp_DayOfWeek::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + sal_Int32 nRet = 0; + css::util::Date aD = lhs.getDate(); + Date aDate(aD.Day, aD.Month, aD.Year); + DayOfWeek eDayOfWeek = aDate.GetDayOfWeek(); + switch (eDayOfWeek) + { + case MONDAY: + nRet = 2; + break; + case TUESDAY: + nRet = 3; + break; + case WEDNESDAY: + nRet = 4; + break; + case THURSDAY: + nRet = 5; + break; + case FRIDAY: + nRet = 6; + break; + case SATURDAY: + nRet = 7; + break; + case SUNDAY: + nRet = 1; + break; + default: + OSL_FAIL("Error in enum values for date"); + } + return nRet; +} + +ORowSetValue OOp_DayOfMonth::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Date aD = lhs.getDate(); + return static_cast<sal_Int16>(aD.Day); +} + +ORowSetValue OOp_DayOfYear::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Date aD = lhs.getDate(); + Date aDate(aD.Day, aD.Month, aD.Year); + return static_cast<sal_Int16>(aDate.GetDayOfYear()); +} + +ORowSetValue OOp_Month::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Date aD = lhs.getDate(); + return static_cast<sal_Int16>(aD.Month); +} + +ORowSetValue OOp_DayName::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + OUString sRet; + css::util::Date aD = lhs.getDate(); + Date aDate(aD.Day, aD.Month, aD.Year); + DayOfWeek eDayOfWeek = aDate.GetDayOfWeek(); + switch (eDayOfWeek) + { + case MONDAY: + sRet = "Monday"; + break; + case TUESDAY: + sRet = "Tuesday"; + break; + case WEDNESDAY: + sRet = "Wednesday"; + break; + case THURSDAY: + sRet = "Thursday"; + break; + case FRIDAY: + sRet = "Friday"; + break; + case SATURDAY: + sRet = "Saturday"; + break; + case SUNDAY: + sRet = "Sunday"; + break; + default: + OSL_FAIL("Error in enum values for date"); + } + return sRet; +} + +ORowSetValue OOp_MonthName::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + OUString sRet; + css::util::Date aD = lhs.getDate(); + switch (aD.Month) + { + case 1: + sRet = "January"; + break; + case 2: + sRet = "February"; + break; + case 3: + sRet = "March"; + break; + case 4: + sRet = "April"; + break; + case 5: + sRet = "May"; + break; + case 6: + sRet = "June"; + break; + case 7: + sRet = "July"; + break; + case 8: + sRet = "August"; + break; + case 9: + sRet = "September"; + break; + case 10: + sRet = "October"; + break; + case 11: + sRet = "November"; + break; + case 12: + sRet = "December"; + break; + } + return sRet; +} + +ORowSetValue OOp_Quarter::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + sal_Int32 nRet = 1; + css::util::Date aD = lhs.getDate(); + if (aD.Month >= 4 && aD.Month < 7) + nRet = 2; + else if (aD.Month >= 7 && aD.Month < 10) + nRet = 3; + else if (aD.Month >= 10 && aD.Month <= 12) + nRet = 4; + return nRet; +} + +ORowSetValue OOp_Week::operate(const std::vector<ORowSetValue>& lhs) const +{ + if (lhs.empty() || lhs.size() > 2) + return ORowSetValue(); + + size_t nSize = lhs.size(); + + css::util::Date aD = lhs[nSize - 1].getDate(); + Date aDate(aD.Day, aD.Month, aD.Year); + + sal_Int16 nStartDay = SUNDAY; + if (nSize == 2 && !lhs[0].isNull()) + nStartDay = lhs[0].getInt16(); + + return static_cast<sal_Int16>(aDate.GetWeekOfYear(static_cast<DayOfWeek>(nStartDay))); +} + +ORowSetValue OOp_Year::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Date aD = lhs.getDate(); + return aD.Year; +} + +ORowSetValue OOp_Hour::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Time aT = lhs.getTime(); + return static_cast<sal_Int16>(aT.Hours); +} + +ORowSetValue OOp_Minute::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Time aT = lhs.getTime(); + return static_cast<sal_Int16>(aT.Minutes); +} + +ORowSetValue OOp_Second::operate(const ORowSetValue& lhs) const +{ + if (lhs.isNull()) + return lhs; + + css::util::Time aT = lhs.getTime(); + return static_cast<sal_Int16>(aT.Seconds); +} + +ORowSetValue OOp_CurDate::operate(const std::vector<ORowSetValue>& lhs) const +{ + if (!lhs.empty()) + return ORowSetValue(); + + Date aCurDate(Date::SYSTEM); + return aCurDate.GetUNODate(); +} + +ORowSetValue OOp_CurTime::operate(const std::vector<ORowSetValue>& lhs) const +{ + if (!lhs.empty()) + return ORowSetValue(); + + tools::Time aCurTime(tools::Time::SYSTEM); + return aCurTime.GetUNOTime(); +} + +ORowSetValue OOp_Now::operate(const std::vector<ORowSetValue>& lhs) const +{ + if (!lhs.empty()) + return ORowSetValue(); + + DateTime aCurTime(DateTime::SYSTEM); + return aCurTime.GetUNODateTime(); +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |