xref: /aoo41x/main/connectivity/source/drivers/file/FDateFunctions.cxx (revision 9b5730f6)

/**************************************************************
 *
 * 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 <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());
}
//------------------------------------------------------------------