/*

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

* All rights reserved.

*

* This program is free software: you can redistribute it and/or modify

* it under the terms of the GNU Lesser General Public License as published by

* the Free Software Foundation, version 2.1 of the License.

* 

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

* GNU Lesser General Public License for more details.

*

* You should have received a copy of the GNU Lesser General Public License

* along with this program.  If not, 

* see "http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html/".

*

* Description:

*

*/

#include<QString>

#include<browsercontentdll.h>

#include<QSqlDatabase>

#include<QSqlQuery>

#include<QSqlError>

#include<QDebug>

const QString dbLocation="browserContent.db";

class BrowserContentPrivate {

BOOKMARKSCLIENT_PUBLIC(BrowserContent)

public:

    ~BrowserContentPrivate();

    QString m_connectionName;

};

/**==============================================================

 * Description: Constructor of BrowserContentPrivate

 ================================================================*/

BrowserContentPrivate::~BrowserContentPrivate()

{

}

/**==============================================================

 * Description: Constructor of BrowserContent

 ================================================================*/

BrowserContent::BrowserContent(QString aClientName)

{

    BOOKMARKSCLIENT_INITIALIZE(BrowserContent);

    priv->m_connectionName=aClientName;

    createDatabase();

}

/**==============================================================

 * Description: creates the database

 ================================================================*/

int BrowserContent::createDatabase()

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase sqlDB = QSqlDatabase::addDatabase("QSQLITE", priv->m_connectionName);

    sqlDB.setHostName("Simulator");

    sqlDB.setDatabaseName(dbLocation);

    if (!sqlDB.open())

        return -1;

    QSqlError error;

    //Check if the table exists, create table only when it's empty 

    QStringList tablelist = sqlDB.tables(QSql::Tables);

    if (tablelist.count() == 0) {

        QSqlQuery query(sqlDB);

        query.exec(

           "CREATE TABLE BookMarkTable (title VARCHAR NOT NULL,url VARCHAR,adate VARCHAR,tags VARCHAR,rowindex INTEGER, domain VARCHAR,CONSTRAINT pk_BookMarkTable PRIMARY KEY(title))");

           error=query.lastError();

        if (error.type() == QSqlError::NoError) {

            query.exec("CREATE TABLE HistoryTable (rowindex INTEGER  PRIMARY KEY, pageTitle VARCHAR NOT NULL,url VARCHAR,domain VARCHAR, timestamp int)");

          error=query.lastError();

        }                        

    }

    if (error.type() == QSqlError::NoError) {

          return ErrNone;

     } else {

          return ErrGeneral;

    }

}

/**==============================================================

 * Description: Destrcutor of the BookmarksClientSide

 ================================================================*/

BrowserContent::~BrowserContent()

    {

    }

/**==============================================================

 * Description: adds the bookmark to the database

 ================================================================*/

int BrowserContent::addBookmark(

        BookmarkLeaf* BookmarkContent)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QString title =BookmarkContent->getTitle();

    QString url = BookmarkContent->getUrl();

    QString adate =BookmarkContent->getDate().toString("dd.MM.yyyy"); 

    QString tags = BookmarkContent->getTag();

    int aIndex=BookmarkContent->getIndex();

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    if (db.isOpen()) {

        QSqlQuery query(db);

        query.prepare("UPDATE BookMarkTable SET rowindex=rowindex+1 WHERE rowindex>=:aIndex");

        query.bindValue(":aIndex", aIndex);

        query.exec();

        error = query.lastError();

        query.prepare("INSERT INTO BookMarkTable (title, url, adate, tags, rowindex, domain) "

            "VALUES (:title, :url, :adate, :tags, :aIndex, :domain)");

        query.bindValue(":title",   QVariant(title));

        query.bindValue(":url",     QVariant(url));

        query.bindValue(":adate",   QVariant(adate));

        query.bindValue(":tags",    QVariant(tags));

        query.bindValue(":rowindex",QVariant(aIndex));

        query.bindValue(":domain",  QVariant(filterUrl(url)));

        query.exec();

        error = query.lastError();

    }

    if (error.type() == QSqlError::NoError) {

        return ErrNone;

    } else {

        return ErrGeneral;

    }

}

/**==============================================================

 * Description: deletes the requested bookmark

 ================================================================*/

int BrowserContent::deleteBookmark(QString atitle)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QString title = atitle;

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    bool ok;

    if (db.isOpen()) {

        QSqlQuery query(db);

        if(atitle.contains("'", Qt::CaseInsensitive))

            atitle.replace(QString("'"), QString("''"));

        query.prepare("SELECT title,url,adate,tags,rowindex FROM BookMarkTable WHERE title=:title");

        query.bindValue(":title", title);

        query.exec();

        error = query.lastError();

        query.next();

        int aIndex=query.value(4).toInt(&ok);

        query.prepare("DELETE FROM BookMarkTable WHERE title=:title");

        query.bindValue(":title", title);

        query.exec();

        error = query.lastError();

        if (error.type() == QSqlError::NoError) {

            query.prepare("UPDATE BookMarkTable set rowindex=rowindex-1 WHERE rowindex>:aIndex");

            query.bindValue(":aIndex", aIndex);

            query.exec();

            error = query.lastError();

        }

    }

    if (error.type() == QSqlError::NoError) {

        return ErrNone;

    } else {

        return ErrGeneral;

    }

}

/**==============================================================

 * Description: fetches Allbookmarks From database

 ================================================================*/

QList<BookmarkLeaf*> BrowserContent::fetchAllBookmarks()

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    QList<BookmarkLeaf*> nodeslist;

    bool dbopen = db.isOpen();

    bool ok;

    if (dbopen) {

        QSqlQuery query(db);

        query.prepare("SELECT title,url,adate,tags,rowindex FROM BookMarkTable ORDER BY rowindex");

        query.exec();

        QSqlError error = query.lastError();

        while (query.next()) {

            QString title = query.value(0).toString();

            if(title.contains("'", Qt::CaseInsensitive))

                title.replace(QString("'"), QString("&#39"));

            if(title.contains("\"", Qt::CaseInsensitive))

                title.replace(QString("\""), QString("&#34"));

            QString url = query.value(1).toString();

            if(url.contains("'", Qt::CaseInsensitive))

                url.replace(QString("'"), QString("&#39"));

            if(url.contains("\"", Qt::CaseInsensitive))

                url.replace(QString("\""), QString("&#34"));

            QString date = query.value(2).toString();

            QString tag = query.value(3).toString();

            int aIndex=query.value(4).toInt(&ok);

            BookmarkLeaf* node = new BookmarkLeaf();

            QDate adate = QDate::fromString(date, "dd.MM.yyyy");

            node->setTitle(title);

            node->setUrl(url);

            node->setDate(adate);

            node->setTag(tag);

            node->setIndex(aIndex);

            nodeslist.append(node);         

        }

    }

    return nodeslist;

}

/**==============================================================

 * Description: fetches suggested bookmarks from database

 ================================================================*/

QList<BookmarkLeaf*> BrowserContent::suggestBookMarks(QString atitle)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    QList<BookmarkLeaf*> nodeslist;

    if (db.isOpen()) {

        QSqlQuery query(db);

        QString queryStatement = "SELECT title,url FROM BookMarkTable WHERE title LIKE '%" + atitle + "%' OR url LIKE '%" + atitle + "%' LIMIT 3";

        query.prepare(queryStatement);

        query.exec();

        QSqlError error = query.lastError();

        while (query.next()) {

            QString title = query.value(0).toString();

            QString url = query.value(1).toString();

            BookmarkLeaf* node = new BookmarkLeaf();

            node->setTitle(title);

            node->setUrl(url);

            nodeslist.append(node);         

        }

    }

    return nodeslist;

}

/**==============================================================

 * Description: Reoders the Bokmarks based on index

 ================================================================*/

int BrowserContent::reorderBokmarks(QString title,int new_index)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    QSqlQuery query(db);

    QSqlError error;

    bool ok;

    if(title.contains("'", Qt::CaseInsensitive))

      title.replace(QString("'"), QString("''"));

    query.prepare("SELECT title,url,adate,tags,rowindex FROM BookMarkTable WHERE title=:title");

    query.bindValue(":title", title);

    query.exec();

    error = query.lastError();

    query.next();

    int old_index=query.value(4).toInt(&ok);

    if(old_index>new_index) {

          //Moving the item UP

          query.prepare("UPDATE BookMarkTable set rowindex=rowindex+1 WHERE rowindex BETWEEN :new_index AND :old_index-1");

    } else if(old_index<new_index) {

         //Moving items Down

         query.prepare("UPDATE BookMarkTable set rowindex=rowindex-1 WHERE rowindex BETWEEN :old_index+1 AND :new_index");

    }

    query.bindValue(":old_index", old_index);

    query.bindValue(":new_index", new_index);

    //Moving items Down

     query.exec();

     error= query.lastError();

    if (error.type() == QSqlError::NoError) {

        query.prepare("UPDATE BookMarkTable set rowindex=:new_index WHERE title=:title");

        query.bindValue(":title", title);

        query.bindValue(":new_index", new_index);

        query.exec();

        error = query.lastError();

    }

    if (error.type() == QSqlError::NoError) {

        //No error

        return ErrNone;

    }  else {

        return ErrGeneral;

    }

}

/**==============================================================

 * Description: modify the requested bookmark

 ================================================================*/

int BrowserContent::modifyBookmark(QString aOrgTitle, QString aNewTitle, QString aNewUrl)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    if (db.isOpen()) {

        QSqlQuery query(db);

        query.prepare("UPDATE BookMarkTable set title=:aNewTitle, url=:aNewUrl, domain=:aNewDomain WHERE title=:aOrgTitle");

        query.bindValue(":aNewTitle", aNewTitle);

        query.bindValue(":aNewUrl", aNewUrl);

        query.bindValue(":aNewDomain", filterUrl(aNewUrl));

        query.bindValue(":aOrgTitle", aOrgTitle);

        query.exec();

        error = query.lastError();

    }

    if (error.type() == QSqlError::NoError) {

        return ErrNone;

    } else {

        return ErrGeneral;

    }

}

/**==============================================================

 * Description: adds the bookmark to the database

 ================================================================*/

int BrowserContent::addHistory(

        HistoryLeaf* HistoryContent)

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QString title =HistoryContent->getTitle();

    QString url = HistoryContent->getUrl();

    QDateTime dt  = QDateTime::currentDateTime();

    int timestamp = dt.toTime_t();

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    if (db.isOpen()) {

        QSqlQuery query(db);

		query.prepare("INSERT INTO HistoryTable (rowindex,pageTitle, url, domain, timestamp) "

                       "VALUES (NULL,:title, :url, :domain, :timestamp)");

        query.bindValue(":title",  QVariant(title));

        query.bindValue(":url",    QVariant(url));

        query.bindValue(":domain", QVariant(filterUrl(url)));

		query.bindValue(":timestamp",  QVariant(timestamp));

        query.exec();

        error = query.lastError();

    }

    if (error.type() == QSqlError::NoError) {

          return ErrNone;

    } else {

       return ErrGeneral;

    }

}

/**==============================================================

 * Description: fetches History From database

 ================================================================*/

QList<HistoryLeaf*> BrowserContent::fetchHistory()

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    QList<HistoryLeaf*> nodeslist;

    bool dbopen = db.isOpen();

    bool ok;

    if (dbopen) {

        QSqlQuery query(db);

		query.prepare("SELECT pagetitle,url,rowindex,timestamp FROM HistoryTable ORDER BY timestamp ASC");

        query.exec();

        QSqlError error = query.lastError();

        while (query.next()) {

            QString title = query.value(0).toString();

            if(title.contains("\"", Qt::CaseInsensitive))

                title.replace(QString("\""), QString("&#34"));

            QString url = query.value(1).toString();

			int aIndex=query.value(2).toInt(&ok);

            uint timest = query.value(3).toUInt();

            QDateTime dtime=QDateTime::fromTime_t ( timest );

            QDate adate=dtime.date();

            QTime atime =dtime.time(); 

			HistoryLeaf* node = new HistoryLeaf();

            node->setTitle(title);

            node->setUrl(url);

            node->setDate(adate);

            node->setLastVisited(atime);

            node->setIndex(aIndex);

            nodeslist.append(node);         

        }

    }

    return nodeslist;

}

/**==============================================================

 * Description: Clear all rows  From History database

 ================================================================*/

int BrowserContent::clearHistory()

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    if (db.isOpen()) {

        QSqlQuery query(db);

        query.prepare("DELETE  FROM  HistoryTable" );

    query.exec();

        error = query.lastError();

    if (error.type() == QSqlError::NoError) {

      return ErrNone;

    } else {

      return ErrGeneral;

    }

    }

    return ErrGeneral;

}

/**==============================================================

 * Description: Clear all rows  From Bookmarks database

 ================================================================*/

int BrowserContent::clearBookmarks()

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlError error;

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    if (db.isOpen()){

        QSqlQuery query(db);

        query.prepare("DELETE  FROM  BookMarkTable" );

    query.exec();

        error = query.lastError();

    if (error.type() == QSqlError::NoError) {

      return ErrNone;

    }

    else{

      return ErrGeneral;

    }

    }

    return ErrGeneral;

}

/**==============================================================

 * Description: fetches suggested History From database

 ================================================================*/

QList<HistoryLeaf*> BrowserContent::suggestHistory(QString atitle){

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

    QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);

    QList<HistoryLeaf*> nodeslist;

    bool dbopen = db.isOpen();

    if (dbopen){

        QSqlQuery query(db);

        QString queryStatement = "SELECT title,url FROM HistoryTable WHERE title LIKE '%" + atitle + "%' OR url LIKE '%" + atitle + "%'";

        query.prepare(queryStatement);

        query.exec();

        QSqlError error = query.lastError();

        while (query.next()){

            QString title = query.value(0).toString();

            QString url = query.value(1).toString();

            HistoryLeaf* node = new HistoryLeaf();

            node->setTitle(title);

            node->setUrl(url);

            nodeslist.append(node);         

        }