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

**

** 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 <cntdef.h>

#include "cntdbinfo.h"

#include "cntmodelextuids.h"

#include "cntfilterdetail.h"

#include "cnttransformcontact.h"

CntDbInfo::CntDbInfo()       

{

    contactsTableIdColumNameMapping.insert(KUidContactFieldGivenName.iUid,"first_name" );

    contactsTableIdColumNameMapping.insert(KUidContactFieldGivenNamePronunciation.iUid,"firstname_prn" );

    contactsTableIdColumNameMapping.insert(KUidContactFieldFamilyName.iUid,"last_name" );

    contactsTableIdColumNameMapping.insert(KUidContactFieldFamilyNamePronunciation.iUid,"lastname_prn" );

    contactsTableIdColumNameMapping.insert(KUidContactFieldCompanyName.iUid,"company_name" );

    contactsTableIdColumNameMapping.insert(KUidContactFieldCompanyNamePronunciation.iUid,"companyname_prn" );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldSIPID.iUid,ESipAddress );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldVCardMapVOIP.iUid,ESipAddress );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldVCardMapSWIS.iUid,ESipAddress );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldIMPP.iUid,ESipAddress );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldEMail.iUid,EEmailAddress );

    commAddrTableIdColumNameMapping.insert(KUidContactFieldPhoneNumber.iUid,EPhoneNumber );

}

CntDbInfo::~CntDbInfo()

{

    contactsTableIdColumNameMapping.clear();

    commAddrTableIdColumNameMapping.clear();

}

bool CntDbInfo::SupportsUid(int uid)

    {

    if(contactsTableIdColumNameMapping.contains(uid) )

        return true;

    else if (commAddrTableIdColumNameMapping.contains(uid))

        return true;

    else

        return false;

    }

/*!

 * Converts filed id to column name of the database table.

 * QContactManager::contacts function.

 *

 * \a fieldId field id representing the detail field name

 * \a sqlDbTableColumnName On return,contains the column name in the database

 */

void CntDbInfo::getDbTableAndColumnName( const quint32 fieldId ,

                                                  QString& tableName,

                                                  QString& columnName ) const

{

    //Uncomment later

    //check contacts table

    columnName = "";

    tableName = "";

    if (contactsTableIdColumNameMapping.contains(fieldId)){

         columnName = contactsTableIdColumNameMapping.value(fieldId);

         tableName = "contact";

     }

    if( (columnName.isEmpty())  || (tableName.isEmpty())){

        //Search comm Addr table

        if (commAddrTableIdColumNameMapping.contains(fieldId)){

                // communication address table has slightly differnt format, so we make the column name as

                //  "type = <type> and value "

                int typeval = commAddrTableIdColumNameMapping.value(fieldId) ;

                columnName =  QString(" TYPE = %1").arg(typeval);

                columnName += " and value " ;

                tableName = "comm_addr";

             }

    }

}

QString CntDbInfo::getSortQuery( const QList<QContactSortOrder> &sortOrders,

                                 const QString& selectQuery,

                                 QContactManager::Error* error)

{

    // Set to initial select query

    QString sortQuery =  selectQuery;

    if(*error == QContactManager::NoError)

        {

        QList<QString> list;

        foreach(const QContactSortOrder& s, sortOrders )

            {

            // Find uids for sortings

            // Get the field id for the detail field name

            bool isSubType;

            QString tableName;

            QString columnName;

            CntTransformContact transformContact;

            QContactDetailFilter filter;

            // Get column names for sort order

            filter.setDetailDefinitionName(s.detailDefinitionName(), s.detailFieldName());

            quint32 fieldId  = transformContact.GetIdForDetailL(filter, isSubType);

            getDbTableAndColumnName(fieldId,tableName,columnName);

            if (tableName.compare("contact") != 0

                || columnName.isEmpty())

                {

                // Skip invalid sort clause

                continue;

                }

            else

                {

                if( s.direction() == Qt::DescendingOrder )

                    {

                    QString col;

                    if(s.caseSensitivity() == Qt::CaseInsensitive)

                        col= ' ' + columnName + ' ' + "COLLATE NOCASE DESC";

                    else

                        col= ' ' + columnName + ' ' + "DESC";

                    list.append(col);

                    }

                else

                    {

                    // Default sort order

                    QString col;

                    if(s.caseSensitivity() == Qt::CaseInsensitive)

                        col= ' ' + columnName + ' ' + "COLLATE NOCASE ASC";

                    else

                        col= ' ' + columnName + ' ' + "ASC";

                    list.append(col);

                    }

                }

            }

        if(list.count() > 0)

            {

            // Recreate query

            // SELECT DISTINCT contact_id FROM contact WHERE contact_id in (

            //      SELECT ..

            // )  ORDER BY  <field> <order>

            sortQuery = " SELECT DISTINCT contact_id FROM contact WHERE contact_id in (";

            QString clause = " ORDER BY " + list.at(0);

            for (int i = 1; i < list.size(); ++i)

                {

                clause += " ," + list.at(i);

                }

            sortQuery += selectQuery + ')';

            sortQuery += clause;

            }

        }

    return sortQuery;

}