summaryrefslogtreecommitdiffstats
path: root/connectivity/source/drivers/file/FDateFunctions.cxx
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--connectivity/source/drivers/file/FDateFunctions.cxx278
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: */