/************************************************************** * * 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 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_connectivity.hxx" #include "file/FDateFunctions.hxx" #include #include #include 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(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(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(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& 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(aDate.GetWeekOfYear(static_cast(nStartDay))); } // ----------------------------------------------------------------------------- ORowSetValue OOp_Year::operate(const ORowSetValue& lhs) const { if ( lhs.isNull() ) return lhs; ::com::sun::star::util::Date aD = lhs; return static_cast(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(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(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(aT.Seconds); } //------------------------------------------------------------------ ORowSetValue OOp_CurDate::operate(const ::std::vector& 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& 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& 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()); } //------------------------------------------------------------------