/*
  This program is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; either version
  2 of the License, or (at your option) any later version.
*/

#ifndef MAPPINGTREEMODEL_H
#define MAPPINGTREEMODEL_H

#include <QSqlDatabase>
#include <QSqlError>

#include "smtreemodel.h"

class QSqlQuery;
class SmTreeItem;
class MappingData;
class SmTreeItem;

class MappingTreeModel : public SmTreeModel {
    Q_OBJECT
    public:
        enum Roles { NameRole = Qt::UserRole + 1, ParentIdRole = Qt::UserRole + 2, AddedRole = Qt::UserRole + 3, MyIdRole = Qt::UserRole + 4 };
        enum Fields { Name = 0, ParentId = 1, Added = 2, MyId = 3 };
        enum { NumFields = 4 };
        MappingTreeModel(QStringList &headers, QObject *parent = 0);
        ~MappingTreeModel();

        //model type convenience functions
        QStringList mappingTypeNames() const;
        int mappingTypeIdFromName(const QVariant &name) const;

        //static convenience funcs
        //the caller is responsible for deleting the result!
        SmTreeItem *treeFromPaths(const QStringList &paths);

        //data
        QVariant data(const QModelIndex &index, int role) const;
        QList<QVariant> childList(const QVariant &value, int column = 0) const;
        QStringList path(QModelIndex &idx) const;
        QModelIndex indexFromPath(const QString &path, int column = 0) const;
        bool setData(const QModelIndex &index, const QVariant &value, int role);
        bool move(const QModelIndex &source, const QModelIndex &dest);
        bool addMappingType(const QString &type);
        bool deleteMappingType(int typeId);
        bool addChild(const QVariant &name, const QModelIndex &parent);
        bool deleteChild(const QModelIndex &idx);
        MappingData mappingDataFromIndex(QModelIndex &idx) const;
        QStringList paths() const;
        const QString &forbidden() const { return mForbidden; }
        const QSqlError &lastError() const { return mLastError; }

    public slots:
        void populate();
        void setType(int type);

    signals:
        void mappingTypesChanged();
        void needExpansion();

    private:
        struct mappingType {
            QVariant id;
            QVariant name;
        };
        void getMappings();
        int addChild(const QString &name, int type);
        void getMappingTypes();
        void getChildrenRecursive(SmTreeItem *item);
        QStringList getPathsRecursive(SmTreeItem *parent) const;
        QList<QVariant> getChildListRecursive(SmTreeItem *item, int column) const;
        QString basePath(SmTreeItem *item) const;
        int lowerBound(SmTreeItem *item, const QVariant &value, int column = 0) const;
        QSqlDatabase mDb;
        QSqlQuery *mTypesQ;
        QString mSParentsQ;
        QSqlQuery *mUpdateTypeQ;
        QSqlQuery *mUpdateChildQ;
        QSqlQuery *mAddMappingTypeQ;
        QSqlQuery *mDeleteMappingTypeQ;
        QSqlQuery *mAddChildQ;
        QSqlQuery *mSelectChildQ;
        QSqlQuery *mAddParentQ;
        QSqlQuery *mUpdateParentQ;
        QSqlQuery *mDeleteMappingParentQ;
        QSqlQuery *mMappingsQ;
        QList<mappingType> mMappingTypes;
        QMap<QString, int> mMappings;
        const QString mForbidden;
        int mType;
        QSqlError mLastError;
};

class MappingTreeResultModel : public SmTreeModel {
    Q_OBJECT
    public:
        enum Roles { NameRole = Qt::UserRole + 1, IdRole = Qt::UserRole + 2 };
        enum Fields { Name = 0, Id = 1 };
        enum { NumFields = 2 };
        explicit MappingTreeResultModel(const QStringList &headers, QObject *parent = 0);

        //data + flags
        Qt::ItemFlags flags(const QModelIndex &index) const;
        bool setData(const QModelIndex &index, const QVariant &value, int role);
        QModelIndex insertChild(const QVariant &data, int id, SmTreeItem *parent);
        QList<int> mappingsIds() const;
        void clearData();

    public slots:
        void addItem(const MappingData &data);

    private:
        int hasChild(SmTreeItem *item, const QVariant &name, int column = 0) const;
        QList<int> mappingIdsRecursive(SmTreeItem *parent) const;
};

struct MappingData {
    int id;
    QString name;
    QList<QStringList> path;
};

Q_DECLARE_METATYPE(QList<QStringList>)

#endif // MAPPINGTREEMODEL_H