Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

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: */