/****************************************************************************

**

** All rights reserved.

** Contact: Nokia Corporation (qt-info@nokia.com)

**

** This file is part of the QtCore module of the Qt Toolkit.

**

** $QT_BEGIN_LICENSE:LGPL$

** No Commercial Usage

** This file contains pre-release code and may not be distributed.

** You may use this file in accordance with the terms and conditions

** contained in the Technology Preview License Agreement accompanying

** this package.

**

** GNU Lesser General Public License Usage

** Alternatively, this file may be used under the terms of the GNU Lesser

** General Public License version 2.1 as published by the Free Software

** Foundation and appearing in the file LICENSE.LGPL included in the

** packaging of this file.  Please review the following information to

** ensure the GNU Lesser General Public License version 2.1 requirements

** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.

**

** In addition, as a special exception, Nokia gives you certain additional

** rights.  These rights are described in the Nokia Qt LGPL Exception

** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.

**

** If you have questions regarding the use of this file, please contact

** Nokia at qt-info@nokia.com.

**

**

**

**

**

**

**

**

** $QT_END_LICENSE$

**

****************************************************************************/

#include "cntfilterrelationship.h"

#include "cnttransformcontact.h"

QTM_USE_NAMESPACE

CntFilterRelationship::CntFilterRelationship(CContactDatabase& contactDatabase,CntSymbianSrvConnection &cntServer,CntDbInfo& dbInfo) 

                                        : m_contactdatabase(contactDatabase),

                                          m_srvConnection(cntServer),

                                          m_dbInfo(dbInfo)

{

}

CntFilterRelationship::~CntFilterRelationship()

{

}

QList<QContactLocalId> CntFilterRelationship::contacts(

        const QContactFilter &filter,

        const QList<QContactSortOrder> &sortOrders,

        bool &filterSupportedflag,

        QContactManager::Error *error)

{

    Q_UNUSED(sortOrders);

    Q_UNUSED(filterSupportedflag);

    //Check if any invalid filter is passed 

    if(!filterSupported(filter) )

        {

        *error =  QContactManager::NotSupportedError;

        return QList<QContactLocalId>();

        }

    QList<QContactLocalId> idList;

    QString sqlQuery;

    createSelectQuery(filter,sqlQuery,error);

    //fetch the contacts

    if(*error == QContactManager::NoError )

        {

        idList =  m_srvConnection.searchContacts(sqlQuery, error);

        }

    return idList;

}

bool CntFilterRelationship::filterSupported(const QContactFilter& filter) 

{

    bool result = false;

    if(QContactFilter::RelationshipFilter == filter.type())

    {

        QContactRelationshipFilter relationfilter(filter);

        if(relationfilter.relationshipType() == QContactRelationship::HasMember)

        {

            result = true;

        }

    }

    return result;

}

void CntFilterRelationship::createSelectQuery(const QContactFilter& filter,

                              QString& sqlQuery,

                              QContactManager::Error* error)

{

    if(!filterSupported(filter))

    {

      *error = QContactManager::NotSupportedError;

      return;

    }

    QContactRelationshipFilter relationfilter(filter);

    QContactId  id_to_search = relationfilter.relatedContactId();

    if(relationfilter.relatedContactRole() == QContactRelationship::First )

    {

        sqlQuery = QString("SELECT DISTINCT contact_group_member_id FROM  groups WHERE contact_group_id = %1").arg(id_to_search.localId());

    }

    else if(relationfilter.relatedContactRole() == QContactRelationship::Second )

    {

        sqlQuery = QString("SELECT DISTINCT contact_group_id FROM  groups WHERE contact_group_member_id = %1").arg(id_to_search.localId());

    }

    else if(relationfilter.relatedContactRole() == QContactRelationship::Either )

    {

        sqlQuery = QString("SELECT contact_group_member_id FROM  groups WHERE contact_group_id = %1").arg(id_to_search.localId());

               + " union " + 

               QString("SELECT DISTINCT  contact_group_id FROM  groups WHERE contact_group_id = %1").arg(id_to_search.localId());

    }

}

void CntFilterRelationship::getSqlquery( const QContactRelationshipFilter& relationfilter,

                                               QString& sqlquery ,

                                               QContactManager::Error* error) const

{

    Q_UNUSED(relationfilter);

    Q_UNUSED(sqlquery);

    Q_UNUSED(error);

}