278 lines
6.6 KiB
C++
278 lines
6.6 KiB
C++
/* -*- 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: */
|