/*

* Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of "Eclipse Public License v1.0"

* which accompanies this distribution, and is available

* at the URL "http://www.eclipse.org/legal/epl-v10.html".

*

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description: Database manager implementation 

*

*/

#include <EPos_CPosLandmarkCategory.h>

#include <EPos_CPosLmTextCriteria.h>

#include <EPos_CPosLandmarkSearch.h>

#include <EPos_CPosLmDatabaseManager.h>

#include <EPos_CPosLmNearestCriteria.h>

#include <EPos_CPosLandmarkDatabase.h>

#include <EPos_CPosLmCategoryManager.h>

#include <lbsposition.h>

#include <barsread.h>

#include <barsc.h>

#include <locationservicedefines.h>

#include "mylocationsdatabasemanager.h"

#include "mylocationlogger.h"

#include "mylocationsdefines.h"

#include <locationdatalookupdb.h>

#include <QString>

// separator

_LIT( KSeparator, ",");

// space

_LIT( KSpace, " ");

// QString separator

const QString KQStringSeparator = ",";

// QString space

const QString KQStringSpace = " ";

// Used to set nearest landmarks search distance criteria

const TUint32 KSearchCriteriaDistance = 100; 

// Maximum string length of landmark address.

const TUint32 KMaxAddressLength = 255; 

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::ConstructL()

// 2nd phase constructor.

// -----------------------------------------------------------------------------

//

EXPORT_C void CMyLocationsDatabaseManager::ConstructL()

{

    __TRACE_CALLSTACK;//Open and intialize Landmark DB

    iLandmarkDb = CPosLandmarkDatabase::OpenL();

    ExecuteAndDeleteLD(iLandmarkDb->InitializeL());

    iLocationAppLookupDb = new LocationDataLookupDb();

    if( !iLocationAppLookupDb->open() )

    {

        User::Leave( KErrUnknown );

    }

    // Create category manager for landmarks

    iLandmarksCatManager = CPosLmCategoryManager::NewL(*iLandmarkDb);

    // open file session

    User::LeaveIfError(iFsSession.Connect());

    // Add contacts and calendar  categories

    iLmContactsCatId = AddMylocationsCategoryL(KContactsCategory);

    iLmCalendarCatId = AddMylocationsCategoryL( KCalendarCategory );

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::CMyLocationsDatabaseManager()

// Default constructor.

// -----------------------------------------------------------------------------

//

EXPORT_C  CMyLocationsDatabaseManager::CMyLocationsDatabaseManager() : iLandmarkDb( NULL ),

                iLmContactsCatId( 0 ), //iLandmarksLookupDb( NULL ), 

                iLocationAppLookupDb( NULL ),

                iLandmarksCatManager( NULL )

{

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::_CMyLocationsDatabaseManager()

// Destructor.

// -----------------------------------------------------------------------------

//

CMyLocationsDatabaseManager::~CMyLocationsDatabaseManager()

{

    __TRACE_CALLSTACK;// delete member variables.

    if (iLocationAppLookupDb)

    {

        iLocationAppLookupDb->close();

        delete iLocationAppLookupDb;

    }

    delete iLandmarksCatManager;

    delete iLandmarkDb;

    // close the file session

    iFsSession.Close();

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::AddMylocationsCategoryL()

// Adds the category to the mylocations and landmarks database..

// -----------------------------------------------------------------------------

//

TUint32 CMyLocationsDatabaseManager::AddMylocationsCategoryL( const TDesC&  aCategoryName )

{

    __TRACE_CALLSTACK;//Open the resource file

    TPosLmItemId catId = 0;

    //create category

    CPosLandmarkCategory *category = CPosLandmarkCategory::NewL();

    CleanupStack::PushL(category);

    category->SetCategoryNameL( aCategoryName );

    // Add category to landmarks database

    TRAPD ( error, ( catId = iLandmarksCatManager->AddCategoryL( *category ) ) );

    if (error == KErrNone || error == KErrAlreadyExists)

    {

        catId = iLandmarksCatManager->GetCategoryL( aCategoryName );

    }

    CleanupStack::PopAndDestroy(category);

    return catId;

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::UpdateDatabaseL()

// Updates the location into the landmark database and lookup table. Based on 

// the entry source type and the entry change type the updation can be 

// addition/modification/deletion.

// -----------------------------------------------------------------------------

//

EXPORT_C void CMyLocationsDatabaseManager::UpdateDatabaseL(CPosLandmark* aLandmark,

        const TUint32 aUid, const TUint32 aSourceType, const TUint32 aChangeType)

{

    __TRACE_CALLSTACK;//open the lookup database

    switch (aChangeType)

    {

    // if the entry is added

    case EEntryAdded:

    {

        // Handle this entry in the lookup table and update landmarks db.

        HandleEntryAdditionL(aLandmark, aUid, aSourceType);

        break;

    }

        // if the entry is modified

    case EEntryModified:

    {

        // Handle this entry in the lookup table and update landmarks db.

        HandleEntryModificationL(aLandmark, aUid, aSourceType);

        break;

    }

        // if the entry is deleted

    case EEntryDeleted:

    {

        // Handle this entry in the lookup table and update landmarks db.

        HandleEntryDeletionL(aUid, aSourceType);

        break;

    }

    }

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::CheckIfDuplicateExistsL()

// Checks if this landmark is already present in database. If present returns the landmark id, else 0

// -----------------------------------------------------------------------------

//

TPosLmItemId CMyLocationsDatabaseManager::CheckIfDuplicateExistsL(

                                    const CPosLandmark* aLandmark)

{

    __TRACE_CALLSTACK;// Stores the found duplicate landmark's id. 

    TPosLmItemId retId = 0;

    // Initially filter only the landmarks which are nearer to the current landmark.

    // Then we can make a duplicate check on each of the found landmarks.

    // create a search object.

    CPosLandmarkSearch* search = CPosLandmarkSearch::NewL(

            *iLandmarkDb);

    CleanupStack::PushL(search);

    TBuf<KMaxAddressLength> lmAddress1;

    GetLandmarkFullAddress( lmAddress1, aLandmark );

    QString str1 = QString( (QChar*)lmAddress1.Ptr(), lmAddress1.Length());

    // create nearest search criteria object

    TLocality position( TCoordinate( 0, 0), 0 );

    aLandmark->GetPosition( position );

    CPosLmNearestCriteria* nearestCriteria = 

                CPosLmNearestCriteria::NewLC( 

                        TCoordinate( position.Latitude(), position.Longitude() ) );

    nearestCriteria->SetMaxDistance( KSearchCriteriaDistance );

    // Start the search and execute it at once.

    ExecuteAndDeleteLD( search->StartLandmarkSearchL( *nearestCriteria ) );

    CleanupStack::PopAndDestroy( nearestCriteria );

    // Retrieve an iterator to access the matching landmarks.

    CPosLmItemIterator* iter = search->MatchIteratorL();

    CleanupStack::PushL(iter);

    // Iterate the search matches.

    TPosLmItemId lmId;

    while( ( lmId = iter->NextL() ) != KPosLmNullItemId )

    {

        CPosLandmark* lm = iLandmarkDb->ReadLandmarkLC( lmId );

        TBuf<KMaxAddressLength> lmAddress2;

        GetLandmarkFullAddress( lmAddress2, lm );

        QString str2 = QString( (QChar*)lmAddress2.Ptr(), lmAddress2.Length());

        CleanupStack::PopAndDestroy( lm );

        if( str1 == str2 )

        {

            retId = lmId;

            break;

        }

    }

    CleanupStack::PopAndDestroy(iter);

    CleanupStack::PopAndDestroy(search);

    return retId;

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::CompareLandmarks()

// Compares two landmarks. Only the text fields, landmark name, street, city, state country and 

// postal code are compared.

// -----------------------------------------------------------------------------

//

TBool CMyLocationsDatabaseManager::CompareLandmarks(

        const CPosLandmark* aLandmark1, const CPosLandmark* aLandmark2 )

{

    __TRACE_CALLSTACK;

    TBuf<KMaxAddressLength> lmAddress1;

    GetLandmarkFullAddress( lmAddress1, aLandmark1 );

    QString str1 = QString( (QChar*)lmAddress1.Ptr(), lmAddress1.Length());

    TBuf<KMaxAddressLength> lmAddress2;

    GetLandmarkFullAddress( lmAddress2, aLandmark2 );

    QString str2 = QString( (QChar*)lmAddress2.Ptr(), lmAddress2.Length());

    if( str1 == str2 )

        return ETrue;

    else

        return EFalse;

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::HandleEntryAdditionL()

// Handles the entry addition in lookup table and landmarks db

// -----------------------------------------------------------------------------

//

void CMyLocationsDatabaseManager::HandleEntryAdditionL(CPosLandmark* aLandmark,

        const TUint32 aUid, const TUint32 aSourceType)

{

    __TRACE_CALLSTACK;

    // Create a lookup item

    QLookupItem lookupItem;

    lookupItem.mSourceUid = aUid;

    lookupItem.mSourceType = aSourceType;

    lookupItem.mDestId = 0;

    lookupItem.mIconType = QLookupItem::EIconTypeDefault;

    lookupItem.mIsDuplicate = 0;

    lookupItem.mIconPath = "";

    lookupItem.mMapTilePath = "";

    lookupItem.mSingleLineAddress="";

    TPtrC16 dataPtr;

    aLandmark->GetPositionField(EPositionFieldComment ,dataPtr);

    lookupItem.mSingleLineAddress=QString::fromUtf16(dataPtr.Ptr(),

            dataPtr.Length());

    //fill address into lookup item.

    FillLookupItemAddressDetails( aLandmark, lookupItem );

    if ( aSourceType == ESourceLandmarks )

    {

        // Logic: check if the entry is already present in lookupdb. 

        // If present, it means the landmark corresponds to a contact/calendar. So ignore it.

        // If not present, it means the landmark is created directly into the landmarks db. So add

        // it in lookupdb as well.

        // check if the entry is already present in lookup db.

        QList<QLookupItem> itemArray;

        iLocationAppLookupDb->findEntriesByLandmarkId( aUid, itemArray );

        if( itemArray.count() )

        {

            return;

        }

        else

        {

            lookupItem.mDestId = aUid;

            iLocationAppLookupDb->createEntry( lookupItem );

            return;

        }

    }

    TPosLmItemId catId;

    if( aSourceType == ESourceCalendar )

    {

        // category id to calendar

        catId = iLmCalendarCatId;

    }

    else 

    {

        // remove landmark name, which is basically contact's name.

        aLandmark->SetLandmarkNameL( KNullDesC );

        // category id to contacts

        catId = iLmContactsCatId;

    }

    // check if this landmark is already present in database

    TPosLmItemId dupLmId = CheckIfDuplicateExistsL( aLandmark );

    if ( dupLmId )

    {

        // landmark already present in db. get the details

        CPosLandmark* dupLandmark = iLandmarkDb->ReadLandmarkLC(dupLmId);

        if( dupLandmark )

        {

            // add category.

            dupLandmark->AddCategoryL( catId );

            // update the landmark object in the db

            iLandmarkDb->UpdateLandmarkL( *dupLandmark );

            CleanupStack::PopAndDestroy( dupLandmark );

        }

        // point the lookup item's landmark uid to the existing landmark.

        lookupItem.mDestId = dupLmId;

        if( aSourceType == ESourceCalendar )

        {

            // set duplicate flag to true. only if it is calendar entry.

            // for contacts duplicate doesnot hold good as the location name is the contact name.

            // set duplicate only if there are calendar entries already pointing to this landmark. 

            if( IsDuplicateEntry( dupLmId ) )

            {

                lookupItem.mIsDuplicate = 1;

            }

        }

    }

    else // it is a new entry, so add into the database

    {

        // add category.

        aLandmark->AddCategoryL( catId );

        // add the landmark into the db. 

        // point the lookup item's landmark uid to the newly created landmark in the db.

        lookupItem.mDestId = iLandmarkDb->AddLandmarkL( *aLandmark );

    }

    // create the entry in the lookup table.

    iLocationAppLookupDb->createEntry( lookupItem );

}

// -----------------------------------------------------------------------------

// CMyLocationsDatabaseManager::HandleEntryModificationL()

// Handles the entry modification in the lookup table and landmarks db.

// -----------------------------------------------------------------------------

//

void CMyLocationsDatabaseManager::HandleEntryModificationL(

        CPosLandmark* aLandmark, const TUint32 aUid, const TUint32 aSourceType )

{

    __TRACE_CALLSTACK;

    if ( aSourceType == ESourceLandmarks )

    {

        HandleLandmarkModificationL( aLandmark, aUid );

        return;

    }

    QLookupItem lookupItem;

    lookupItem.mSourceUid = aUid;

    lookupItem.mSourceType = aSourceType;

    lookupItem.mIconType = QLookupItem::EIconTypeDefault;

    TPtrC16 dataPtr;

    aLandmark->GetPositionField(EPositionFieldComment ,dataPtr);

    lookupItem.mSingleLineAddress=QString::fromUtf16(dataPtr.Ptr(),

            dataPtr.Length());

    // Behavior: If an entry is modified, 

    // If this entry is not present in lookup table. add the entry and update the landmarks db.

    // If this entry is already present in lookup table, check if the location info is modified or not.

    // If the location info is modified, delete the landmark from db and add the new landmark

    // into the db. 

    // Before deletion make sure that the landmark is not being refered by other lookup entries.

    // find the entry in the lookup table.

    if ( iLocationAppLookupDb->findEntryBySourceIdAndType( lookupItem ) )

    {

        //fill address into lookup item.

        FillLookupItemAddressDetails( aLandmark, lookupItem );

        QString locationName = lookupItem.mName;

        TPosLmItemId catId;

        if( aSourceType == ESourceCalendar )

        {

            catId = iLmCalendarCatId;

        }

        else

        {

            // remove landmark name, which is basically contact's name.

            aLandmark->SetLandmarkNameL( KNullDesC );

            // category id to contacts

            catId = iLmContactsCatId;

        }

        // check if the location info is modified by comparing the new landmark with the existing landmark

        CPosLandmark* existingLandmark = NULL;

        TRAPD( error, ( existingLandmark = 

               CheckAndReadLandmarkL( iLandmarkDb, lookupItem.mDestId ) ) );

        CleanupStack::PushL( existingLandmark );

        if ( error == KErrNotFound )

        {

            // Landmarks item deleted. So delete corresponding lookup entries.

            QList<QLookupItem> itemArray;

            iLocationAppLookupDb->findEntriesByLandmarkId( lookupItem.mDestId, itemArray );

            for ( int i = 0; i < itemArray.count(); i++)

            {

                iLocationAppLookupDb->deleteEntryBySourceIdAndType( itemArray[i] );

            }

            // Add the entry into the lookup table and update landmarks db.

            HandleEntryAdditionL( aLandmark, aUid, aSourceType );

            CleanupStack::PopAndDestroy( existingLandmark );

            return;

        }

        if ( !CompareLandmarks( existingLandmark, aLandmark ) )

        {

            // landmarks are not same, means location information is modified.

            // Check if the new landmark is already in db.

            TPosLmItemId dupLmId = CheckIfDuplicateExistsL( aLandmark );

            if ( dupLmId )

            {

                // landmark already present in db. get the details

                CPosLandmark* dupLandmark = iLandmarkDb->ReadLandmarkLC( dupLmId );

                if ( dupLandmark )

                {

                    // add category.

                    dupLandmark->AddCategoryL( catId );

                    // update the landmark object in the db

                    iLandmarkDb->UpdateLandmarkL( *dupLandmark );

                }

                CleanupStack::PopAndDestroy( dupLandmark );

                // update the lookup item to refer to the newly created landmark.

                lookupItem.mDestId = dupLmId;

                if( aSourceType == ESourceCalendar )

                {

                    // for contacts duplicate doesnot hold good as the location name is the contact name.

                    if( !lookupItem.mIsDuplicate )

                    {

                        // if current lookup item duplicate property is 0, then remove next corresponding

                        // calendar lookup entry duplicate property.

                        // this is required because the current entry will be pointing to a new landmark.

                        UnsetDuplicateNextCalEntry( aUid, existingLandmark->LandmarkId() );

                    } 

                    // set duplicate only if there are calendar entries already pointing to this landmark. 

                    if( IsDuplicateEntry( dupLmId ) )

                    {

                        lookupItem.mIsDuplicate = 1;

                    }

                }

                iLocationAppLookupDb->updateEntryBySourceIdAndType( lookupItem );

            }

            else

            {

                // landmark not already present in db.

                // Create a new entry in the db

                aLandmark->AddCategoryL( catId );

                lookupItem.mDestId = iLandmarkDb->AddLandmarkL( *aLandmark );

                if( aSourceType == ESourceCalendar )

                {

                    // for contacts duplicate doesnot hold good as the location name is the contact name.

                    if( !lookupItem.mIsDuplicate )

                    {

                        // if current lookup item duplicate property is 0, then remove next corresponding

                        // calendar lookup entry duplicate property.

                        // this is required because the current entry will be pointing to a new landmark.

                        UnsetDuplicateNextCalEntry( aUid, existingLandmark->LandmarkId() );

                    } 

                }

                lookupItem.mIsDuplicate = 0;

                // update the lookup table

                iLocationAppLookupDb->updateEntryBySourceIdAndType( lookupItem );

            }

        }

        else

        {

            // landmarks are same, means location not modified. So return.

            if( aSourceType == ESourceContactsPref

                                    || aSourceType == ESourceContactsWork

                                    || aSourceType == ESourceContactsHome

                                    )

            {

                // in case of contacts, there is a chance that contact name is modified. 

                // so update the lookup database entry with that name.

                lookupItem.mName = locationName;