/*

* 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

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

{

    BOOKMARKSCLIENT_INITIALIZE(BrowserContent);

    priv->m_connectionName=aClientName;

}

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

 * Description: creates the database

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

{

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

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

    sqlDB.setHostName("Simulator");

    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: 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: 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);

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

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

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

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

        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"));

            //--Encoding backslash used in title--

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

                title.replace(QString("\\"), QString(KBACKSLASH));

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

            //--Encoding doublequote used in title--

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

                url.replace(QString("\""), QString(KDOUBLEQUOTE));

			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);         

        }

    }

    return nodeslist;

}

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

 * Description: fetches suggested History and Bookmarks From database

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

QObjectList BrowserContent::suggestContent(QString atitle){

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

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

  while(!suggestedList.isEmpty()) {

        delete suggestedList.takeFirst();

    }

    bool dbopen = db.isOpen();

    if (dbopen){

        QSqlQuery query(db);

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

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

    QString queryStatement = "SELECT pageTitle,url,1 FROM HistoryTable WHERE pagetitle LIKE '%" + atitle + "%' OR url LIKE '%" + atitle + "%' "+

    						 " UNION "+

    						 "SELECT title,url,2 FROM BookMarkTable WHERE title LIKE '%"+atitle+"%' OR url LIKE '%" + atitle + "%'"+

    						 " ORDER BY 3";

        query.prepare(queryStatement);

        query.exec();

        QSqlError error = query.lastError();

        while (query.next()){

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

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

            SuggestData* node = new SuggestData(bookmarkTitle, bookmarkUrl);

            suggestedList.append(node);         

        }

    }

  return suggestedList;

}

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

 * Description: removes common strings from URLs

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

QString BrowserContent::filterUrl(QString atitle){

  QString https = "https://";

  QString http = "http://";

  QString www  = "www";

  QString com  = "com";

  QString org  = "org";

  QString htm  = "htm";

  QString html = "html";

  if(atitle.contains(https, Qt::CaseInsensitive))

    atitle = atitle.remove(https);

  if(atitle.contains(http, Qt::CaseInsensitive))

    atitle = atitle.remove(http);

  if(atitle.contains(www, Qt::CaseInsensitive))

    atitle = atitle.remove(www);

  if(atitle.contains(com, Qt::CaseInsensitive))

    atitle = atitle.remove(com);

  if(atitle.contains(org, Qt::CaseInsensitive))

    atitle = atitle.remove(org);

  if(atitle.contains(html, Qt::CaseInsensitive))

    atitle = atitle.remove(html);

  if(atitle.contains(htm, Qt::CaseInsensitive))

    atitle = atitle.remove(htm);

  return atitle;

}

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

 * Description: Retrieves the bookmarks and sends it in serialized fashion

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

QString BrowserContent::fetchSerializedBookmarks()

    {

    BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);

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

    bool dbopen = db.isOpen();

    bool ok;

    QString bookmakrData = "[";

    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);

    bookmakrData.append("{");

    bookmakrData.append("\"title\": \"");

    bookmakrData.append(title);

    bookmakrData.append("\", \"urlvalue\": \"");

    bookmakrData.append(url);

    bookmakrData.append("\"},");

        }

    bookmakrData.remove(bookmakrData.length(),1);

    bookmakrData.append("]");

        }