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