diff options
Diffstat (limited to 'connectivity/source/drivers/file/FDateFunctions.cxx')
-rw-r--r-- | connectivity/source/drivers/file/FDateFunctions.cxx | 289 |
1 files changed, 289 insertions, 0 deletions
diff --git a/connectivity/source/drivers/file/FDateFunctions.cxx b/connectivity/source/drivers/file/FDateFunctions.cxx new file mode 100644 index 000000000000..69330bf0c168 --- /dev/null +++ b/connectivity/source/drivers/file/FDateFunctions.cxx @@ -0,0 +1,289 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +// MARKER(update_precomp.py): autogen include statement, do not remove +#include "precompiled_connectivity.hxx" + +#include "file/FDateFunctions.hxx" +#include <tools/date.hxx> +#include <tools/time.hxx> +#include <tools/datetime.hxx> + +using namespace connectivity; +using namespace connectivity::file; +//------------------------------------------------------------------ +ORowSetValue OOp_DayOfWeek::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + sal_Int32 nRet = 0; + ::com::sun::star::util::Date aD = lhs; + 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_ENSURE(0,"Error in enum values for date"); + } + return nRet; +} +//------------------------------------------------------------------ +ORowSetValue OOp_DayOfMonth::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Date aD = lhs; + return static_cast<sal_Int16>(aD.Day); +} +//------------------------------------------------------------------ +ORowSetValue OOp_DayOfYear::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Date aD = lhs; + 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; + + ::com::sun::star::util::Date aD = lhs; + return static_cast<sal_Int16>(aD.Month); +} +//------------------------------------------------------------------ +ORowSetValue OOp_DayName::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::rtl::OUString sRet; + ::com::sun::star::util::Date aD = lhs; + Date aDate(aD.Day,aD.Month,aD.Year); + DayOfWeek eDayOfWeek = aDate.GetDayOfWeek(); + switch(eDayOfWeek) + { + case MONDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Monday")); + break; + case TUESDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Tuesday")); + break; + case WEDNESDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Wednesday")); + break; + case THURSDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Thursday")); + break; + case FRIDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Friday")); + break; + case SATURDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Saturday")); + break; + case SUNDAY: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Sunday")); + break; + default: + OSL_ENSURE(0,"Error in enum values for date"); + } + return sRet; +} +//------------------------------------------------------------------ +ORowSetValue OOp_MonthName::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::rtl::OUString sRet; + ::com::sun::star::util::Date aD = lhs; + switch(aD.Month) + { + case 1: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("January")); + break; + case 2: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("February")); + break; + case 3: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("March")); + break; + case 4: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("April")); + break; + case 5: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("May")); + break; + case 6: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("June")); + break; + case 7: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("July")); + break; + case 8: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("August")); + break; + case 9: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("September")); + break; + case 10: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("October")); + break; + case 11: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("November")); + break; + case 12: + sRet = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("December")); + break; + } + return sRet; +} +//------------------------------------------------------------------ +ORowSetValue OOp_Quarter::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + sal_Int32 nRet = 1; + ::com::sun::star::util::Date aD = lhs; + Date aDate(aD.Day,aD.Month,aD.Year); + 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(); + + ::com::sun::star::util::Date aD = lhs[nSize-1]; + Date aDate(aD.Day,aD.Month,aD.Year); + + sal_Int16 nStartDay = SUNDAY; + if ( nSize == 2 && !lhs[0].isNull() ) + nStartDay = lhs[0]; + + return static_cast<sal_Int16>(aDate.GetWeekOfYear(static_cast<DayOfWeek>(nStartDay))); +} +// ----------------------------------------------------------------------------- +ORowSetValue OOp_Year::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Date aD = lhs; + return static_cast<sal_Int16>(aD.Year); +} +//------------------------------------------------------------------ +ORowSetValue OOp_Hour::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Time aT = lhs; + return static_cast<sal_Int16>(aT.Hours); +} +//------------------------------------------------------------------ +ORowSetValue OOp_Minute::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Time aT = lhs; + return static_cast<sal_Int16>(aT.Minutes); +} +//------------------------------------------------------------------ +ORowSetValue OOp_Second::operate(const ORowSetValue& lhs) const +{ + if ( lhs.isNull() ) + return lhs; + + ::com::sun::star::util::Time aT = lhs; + return static_cast<sal_Int16>(aT.Seconds); +} +//------------------------------------------------------------------ +ORowSetValue OOp_CurDate::operate(const ::std::vector<ORowSetValue>& lhs) const +{ + if ( !lhs.empty() ) + return ORowSetValue(); + + Date aCurDate; + return ::com::sun::star::util::Date(aCurDate.GetDay(),aCurDate.GetMonth(),aCurDate.GetYear()); +} +//------------------------------------------------------------------ +ORowSetValue OOp_CurTime::operate(const ::std::vector<ORowSetValue>& lhs) const +{ + if ( !lhs.empty() ) + return ORowSetValue(); + + Time aCurTime; + return ::com::sun::star::util::Time(aCurTime.Get100Sec(),aCurTime.GetSec(),aCurTime.GetMin(),aCurTime.GetHour()); +} +//------------------------------------------------------------------ +ORowSetValue OOp_Now::operate(const ::std::vector<ORowSetValue>& lhs) const +{ + if ( !lhs.empty() ) + return ORowSetValue(); + + DateTime aCurTime; + return ::com::sun::star::util::DateTime(aCurTime.Get100Sec(),aCurTime.GetSec(),aCurTime.GetMin(),aCurTime.GetHour(), + aCurTime.GetDay(),aCurTime.GetMonth(),aCurTime.GetYear()); +} +//------------------------------------------------------------------ |