/*

* Copyright (c) 2007-2008 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:   SUPL Settings class

*

*/

#include <f32file.h>

#include <badesca.h>    // CDesCArrayFlat

#include <bautils.h>    // file helpers

#include <eikenv.h>

#include <e32cmn.h>

#include <centralrepository.h> //for central repository

//#define PRINT_MESSAGE           //for logging 

#define ENABLE_DEBUG

#include "epos_csuplsettings.h"

#include "epos_csettingsdatabasehandler.h"

#include "epos_csuplsettingparams.h"

#include "epos_csuplsettingextensionparams.h"

#include "epos_csuplsettingsconstants.h"

#include "epos_csuplsettingsinternalconstants.h"

#include "epos_csuplserverprivatecrkeys.h" //for keys of default setting values stored in cen rep

#include "epos_csuplsettingsinternalcrkeys.h"     //for keys of setting change events used for notification

// Implementation specific constants

//some string length contants

const int KDateStringLen = 64;         

const int KGenericStringLen = 255;

const int KShortStringLen = 32;

const TInt KMaxLenSLPAddress = 64;

const TInt KMaxLenIAPName = 16;

//integer values used to set or reset a boolen flag corresponding to slp properties

const TInt KEmergencySupport = 1;

const TInt KTlsEnabled = 2;

const TInt KPskTlsUsed = 4;

const TInt KServerEnabled = 8;

const TInt KSimChangeRemove = 32;

const TInt KUsageInHomeNw = 64;

const TInt KEditable = 128;

//values used to set and retrieve major and minor version numbers from a single int

const TInt KVersionMinorMask = 255;

const TInt KVersionMajorMask = 8;

//values used to set and retrieve mcc,mnc values from a single int

const TInt KMccShift = 20;

const TInt KMncMask = 1023;

const TInt KMncShift= 10;

const TInt KMinPriorityValue = 1; //The minimum value for the priority field

//all strings related to SQL Statements used to form valid SQL statements

_LIT(KSecureDBDrive,"c:");

_LIT(KSecureDBName,"settings.db");

_LIT(KCreateTable, "CREATE TABLE");

_LIT(KCreateTableName," SUPLSETTINGS ");

_LIT(KInsertIntoTable," INSERT INTO ");

_LIT(KValues," VALUES");

_LIT(KDeleteRecord,"DELETE FROM ");

_LIT(KUpdateRecord,"UPDATE ");

_LIT(KWhere," WHERE ");

_LIT(KSET," SET ");

_LIT(KSelect,"SELECT ");

_LIT(KFrom," FROM ");

_LIT(KMax," MAX ");

_LIT(KOrderBy," ORDER BY ");

_LIT(KOpeningBracket,"(");

_LIT(KClosingBracket,")");

_LIT(KCommaSeparator,",");

_LIT(KQuotes,"'");

_LIT(KEquals," = ");

_LIT(KGreaterOrEquals," >= ");

_LIT(KGreaterThan," > ");

_LIT(KStar," * ");

_LIT(KCount," Count ");

_LIT(KColSLPId,"SlpID");

_LIT(KColSLPAddress,"SLPName");

_LIT(KColManuName, "ManuName");

_LIT(KColProtocolVersionMajor,"MajorVersion");

_LIT(KColIap,"IAP");      

_LIT(KColTimeLastUse,"LastTimeUsed");

_LIT(KColTimeLastTried,"LastTimeTried");

_LIT(KColNetInfoLastUse,"NetInfoLastUse");

_LIT(KColNetLastUseCId,"NwInfoLastUseCId");

_LIT(KColNetLastUseParams,"NwInfoLastUseParams");

_LIT(KColNetInfoLastSucess,"NetInfoLastSucess");

_LIT(KColNetLastSuccParams,"NwInfoLastSuccParams");

_LIT(KColNetLastSuccCId,"NwInfoLastSuccCId");

//EEmergencySupport,ETlsEnabled,EPskTlsUsed,EServerEnabled,ESimChangeRemove,EUsageInHomeNw,EEditable

_LIT(KColOtherProperties,"OtherProperties");

_LIT(KColPriority,"Priority");

_LIT(KCaseInsensitive," COLLATE NOCASE ");

_LIT(KValuePriority,":Priority");

_LIT(KValueSlpId,":SlpId");

_LIT(KDataTypeInteger," INTEGER ");

_LIT(KDataTypeString," VARCHAR");

_LIT(KDataTypeTime," TIMESTAMP NULL");

_LIT(KPrimaryKey,"PRIMARY KEY AUTOINCREMENT");

_LIT(KDateTimeFormat,"%M%D%Y%/0%1%/1%2%/2%3%/3 %-B%:0%J%:1%T%:2%S%:3%+B");   // MM/DD/YYYY hh:mm:ss AM/PM

_LIT(KSessionTableName," SESSIONSETTINGS ");

_LIT(KColSessionId,"SessionID");

_LIT(KColSessionName,"SessionName");

_LIT(KColNotificationPresent,"NotificationPresent");

_LIT(KColTriggerNotificationStatus, "NotificationStatus");

_LIT(KColTriggerType,"TriggerType");

_LIT(KColRequestType,"RequestType");

_LIT(KColOutstandingTrigger,"OutstandingTrigger");      

_LIT(KColInterval,"Interval");

_LIT(KColServerId,"ServerId");

_LIT(KColIap1,"Iap1");

_LIT(KColIap2,"Iap2");

_LIT(KColServerAddress,"ServerAddress");

_LIT(KColServerAddType,"ServerAddType");

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

// CSettingsDatabaseHandler::NewL()

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

CSettingsDatabaseHandler* CSettingsDatabaseHandler::NewL() 

    {

    CSettingsDatabaseHandler* tmp = new (ELeave)CSettingsDatabaseHandler();

    CleanupStack::PushL(tmp);

    tmp->ConstructL();

    CleanupStack::Pop();

    return tmp;

    }

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

// CSettingsDatabaseHandler::~CSettingsDatabaseHandler()

//

// Destructor method

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

CSettingsDatabaseHandler::~CSettingsDatabaseHandler()

    {

    if(iSettingsRep)

        {

        delete iSettingsRep;

        iSettingsRep = NULL;

        }    

    if(iSettingsNotifierRep)

        {

        delete iSettingsNotifierRep;

        iSettingsNotifierRep = NULL;

        }

    iDb.Close();

    LogQuery(_L("Deleted Settings DB Handle CLosed"));

    }

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

// CSettingsDatabaseHandler::ConstructL()

//

// Second phase construction. Can Leave.

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

void CSettingsDatabaseHandler::ConstructL()

    {

    iSettingsRep = CRepository::NewL(KCRUidSuplConfiguration);

    iSettingsNotifierRep = CRepository::NewL(KCRUidSuplSettings);

    CreateOpenSecureDatabaseL();

    }

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

// CSettingsDatabaseHandler::CSettingsDatabaseHandler()

//

// Constructor

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

CSettingsDatabaseHandler::CSettingsDatabaseHandler()

    {

    }

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

// CSettingsDatabaseHandler::CreateOpenSecureDatabaseL()

//

// Create a new database and open. The database will be in exclusive access mode.

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

void CSettingsDatabaseHandler::CreateOpenSecureDatabaseL(/*const TDesC& aDbFile*/)

    {

    //create a security policy for the database

    const TSecurityPolicy KPolicy1(ECapabilityReadUserData,ECapabilityWriteUserData);

    const TSecurityPolicy KPolicy2(ECapabilityReadUserData);

    TSecurityPolicy defaultPolicy(TSecurityPolicy::EAlwaysPass);

    RSqlSecurityPolicy securityPolicy;

    CleanupClosePushL(securityPolicy);

    TInt err = securityPolicy.Create(defaultPolicy);

    PrintErrorMessage(_L(""),err,4);

    User::LeaveIfError(err);

    securityPolicy.SetDbPolicy(RSqlSecurityPolicy::ESchemaPolicy, KPolicy1);

    securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy2);

    TBuf<KShortStringLen> dbPath;

    TBuf<KShortStringLen> pathBuf;

    err = GetDBPathFromCR(pathBuf);

    PrintErrorMessage(pathBuf,err,7);

    if(pathBuf.Length()) //if there is a DB path existing in the CenRep try to open that

        {

        dbPath.Copy(KSecureDBDrive);

        dbPath.Append(pathBuf);

        dbPath.Append(KSecureDBName);

        err = iDb.Open(dbPath); // Check if DB exists

        PrintErrorMessage(dbPath,err,3);       

        }       

    if( KErrNotFound == err || pathBuf.Length() <= 0) // if there is no DB Path in the cen rep or the Db does not exist

        {

        RProcess process;

        TBuf<KShortStringLen> uidname;

        TInt error = process.SecureId().iId;

        if(error < 0) // if there is no secure id associated with the app use the UID3 value

            {

            TUidType tempUidType = process.Type();

            const TUid& uid = tempUidType[2];

            uidname.Copy(uid.Name());

            }

        else // use the secure id value to create the DB

            {

            TSecureId secureID = process.SecureId();

            TUid uid = TUid::Uid(error);

            uidname.Copy(uid.Name());

            }

        dbPath.Zero();

        dbPath.Append(KSecureDBDrive);

        dbPath.Append(uidname);

        dbPath.Append(KSecureDBName);

        err = iDb.Create(dbPath, securityPolicy); // create the db with the path that was formed

        PrintErrorMessage(dbPath,err,0);

        User::LeaveIfError(err);

        //DB created successfully copy the DB path to CenRep

        StoreDBPathToCR(uidname);

        CreateTableL();

        CreateSessionTableL();

        }

    CleanupStack::PopAndDestroy();//securityPolicy;

    PrintErrorMessage(dbPath,err,3);

    User::LeaveIfError(err);

    }

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

// CSettingsDatabaseHandler::RemoveDb()

//

// 

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

TInt CSettingsDatabaseHandler::RemoveDb()

    {

    Close();

   // iDbs.DeleteDatabase(KWordDatabase,KSecureUid);

    return KErrNone;

    }

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

// CSettingsDatabaseHandler::Close()

//

// Close the database.

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

TInt CSettingsDatabaseHandler::Close()

    {

    iDb.Close();

    LogQuery(_L("CLOSED DB"));

    return KErrNone;

    }

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

// CSettingsDatabaseHandler::CreateTableL()

//

// Creates the SUPL Settings table. Leaves, if the table cannot be created.

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

void CSettingsDatabaseHandler::CreateTableL()

    {

    iSQLString.Copy(KCreateTable);

    iSQLString.Append(KCreateTableName);

    iSQLString.Append(KOpeningBracket);

    iSQLString.Append(KColSLPId);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KPrimaryKey);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColSLPAddress);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxLenSLPAddress);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColProtocolVersionMajor);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColPriority);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColManuName);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KGenericStringLen);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator); 

    iSQLString.Append(KColIap);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxLenIAPName);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColTimeLastUse);

    iSQLString.Append(KDataTypeTime);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColTimeLastTried);

    iSQLString.Append(KDataTypeTime);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetInfoLastUse);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetInfoLastSucess);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetLastUseCId);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetLastUseParams);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetLastSuccCId);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColNetLastSuccParams);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColOtherProperties);

    iSQLString.Append(KDataTypeInteger);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColServerId);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxServerIdLen);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColIap1);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxLenIAPName);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColIap2);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxLenIAPName);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColServerAddress);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxServerAddLen);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KCommaSeparator);

    iSQLString.Append(KColServerAddType);

    iSQLString.Append(KDataTypeString);

    iSQLString.Append(KOpeningBracket);

    iSQLString.AppendNum(KMaxServerAddTypeLen);

    iSQLString.Append(KClosingBracket);

    iSQLString.Append(KClosingBracket);

    TInt err = iDb.Exec(iSQLString);

    PrintErrorMessage(iSQLString,err,1);							

    User::LeaveIfError(err);

    }

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

// CSettingsDatabaseHandler::InsertSLPRecordL()

//

// This method is used to insert SLP record into the SUPL Settings DB

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

void CSettingsDatabaseHandler::InsertSLPRecordL(const CServerParams* aServParamValues,TInt64& aSlpId)

    {    

    HBufC* SLPAddress = HBufC::NewLC( KMaxHSLPAddrLen);

    HBufC* IAPName = HBufC::NewLC( KMaxIAPLen);      

    HBufC* manuName = HBufC::NewLC(KMaxHSLPAddrLen);

    TBuf<KMaxServerAddTypeLen> serverAddTypeDefault;

    serverAddTypeDefault.Copy(_L("FQDN"));

    TUint16* buf = NULL;

    TPtr nullDefault(buf,0);

    TBuf<KDateStringLen> lastUseDateTimeFormat;

    TBuf<KDateStringLen> lasttriedDateTimeFormat;

    TInt err = KErrNone;

    TInt64 slpId;

    TInt protocolVersion = 0; 

    TTime  timeLastUse;

    TTime  timeLastTried;

    TInt32  netInfoLastUse = 0;

    TInt32  netInfoLastSucess = 0;

    TBool   serverEnabled,simChangeRemove,usageInHomeNw,editable;

    TInt ret = 0;

    ret = aServParamValues->Get(slpId,SLPAddress->Des(),IAPName->Des(),serverEnabled,simChangeRemove,usageInHomeNw,editable);

    if(ret == KErrNotFound)

        {

        CleanupStack::PopAndDestroy(3); //SLPAddress,IAPName,manuName

        aSlpId = -1;

        PrintErrorMessage(_L(""),KErrNotFound,8);

        User::Leave(KErrGeneral);        

        }

    if(IsSlpExists(*SLPAddress))

        {

        PrintErrorMessage(_L(""),KErrAlreadyExists,8);

        User::Leave(KErrAlreadyExists);  

        }

    err = GetDefaultCRValues(KSuplProtoclVersion,protocolVersion); //get default values to be set from CR

    PrintErrorMessage(_L(""),err,8);

    User::LeaveIfError(err);

    TBool   emergencySupport;

    err = GetDefaultCRValues(KSuplEmergencySupport,emergencySupport); //get default values to be set from CR

    PrintErrorMessage(_L(""),err,8);

    User::LeaveIfError(err);

    TBool   tlsEnabled;

    err = GetDefaultCRValues(KSuplTlsEnable,tlsEnabled); //get default values to be set from CR

    PrintErrorMessage(_L(""),err,8);

    User::LeaveIfError(err);

    TBool   pskTlsUsed;

    err = GetDefaultCRValues(KSuplPskTlsEnable,pskTlsUsed); //get default values to be set from CR

    PrintErrorMessage(_L(""),err,8);

    User::LeaveIfError(err);

    timeLastUse.FormatL(lastUseDateTimeFormat,KDateTimeFormat); 

    timeLastTried.FormatL(lasttriedDateTimeFormat,KDateTimeFormat); 

    //form other properties int based on the returned TBool Values

    TInt OtherProperties = 0; //set to all false

    if(emergencySupport)

        {

        OtherProperties |= KEmergencySupport;

        }

    if(tlsEnabled)

        {

        OtherProperties |= KTlsEnabled;

        }

    if(pskTlsUsed)

        {

        OtherProperties |= KPskTlsUsed;

        }

    if(serverEnabled)

        {

        OtherProperties |= KServerEnabled;

        }

    if(simChangeRemove)

        {

        OtherProperties |= KSimChangeRemove;

        }

    if(usageInHomeNw)

        {

        OtherProperties |= KUsageInHomeNw;

        }

    if(editable)

        {

        OtherProperties |= KEditable;

        }

    TBuf<KGenericStringLen> tempBuf;

    tempBuf.Copy(*SLPAddress);

    tempBuf.Trim();

    iSQLString.Copy(KInsertIntoTable);

    iSQLString.Append(KCreateTableName);

    iSQLString.Append(KOpeningBracket);

    iSQLString.Append(KColSLPAddress);

    iSQLString.Append(KCommaSeparator);