# -*- coding: utf-8 -*-
"""
/***************************************************************************
 DsgTools
                                 A QGIS plugin
 Brazilian Army Cartographic Production Tools
                              -------------------
        begin                : 2016-12-07
        git sha              : $Format:%H$
        copyright            : (C) 2016 by Philipe Borba - Cartographic Engineer @ Brazilian Army
        email                : borba.philipe@eb.mil.br
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   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.                                   *
 *                                                                         *
 ***************************************************************************/
"""
from builtins import str
from builtins import range
import os

# Qt imports
from qgis.PyQt import QtWidgets, uic, QtCore
from qgis.PyQt.QtCore import pyqtSlot, Qt, pyqtSignal
from qgis.PyQt.QtWidgets import QMessageBox, QApplication, QFileDialog
from qgis.PyQt.QtGui import QCursor

from qgis.core import QgsMessageLog, Qgis

# DSGTools imports
from DsgTools.gui.DatabaseTools.UserTools.createProfileWithProfileManager import (
    CreateProfileWithProfileManager,
)
from DsgTools.gui.CustomWidgets.DatabasePropertiesWidgets.BasicPropertyWidgets.genericParameterSetter import (
    GenericParameterSetter,
)

import json

FORM_CLASS, _ = uic.loadUiType(
    os.path.join(os.path.dirname(__file__), "serverProfilesManager.ui")
)


class ServerProfilesManager(QtWidgets.QDialog, FORM_CLASS):
    profilesChanged = pyqtSignal()

    def __init__(self, permissionManager, parent=None):
        """
        Constructor
        """
        super(ServerProfilesManager, self).__init__(parent)
        # Set up the user interface from Designer.
        # After setupUI you can access any designer object by doing
        # self.<objectname>, and you can use autoconnect slots - see
        # http://qt-project.org/doc/qt-4.8/designer-using-a-ui-file.html
        # #widgets-and-dialogs-with-auto-connect
        self.setupUi(self)
        self.permissionManager = permissionManager
        self.refreshProfileList()

    def createItem(self, parent, text):
        """
        Creates tree widget items
        """
        item = QtWidgets.QTreeWidgetItem(parent)
        item.setFlags(
            QtCore.Qt.ItemFlag.ItemIsEnabled
            | QtCore.Qt.ItemFlag.ItemIsTristate
            | QtCore.Qt.ItemFlag.ItemIsUserCheckable
        )
        item.setCheckState(1, QtCore.Qt.CheckState.Unchecked)
        item.setCheckState(2, QtCore.Qt.CheckState.Unchecked)
        item.setText(0, text)
        return item

    def makeProfileDict(self):
        """
        Makes a dictionary out of the tree widget items
        """
        profileDict = dict()

        # invisible root item
        rootItem = self.treeWidget.invisibleRootItem()
        # database item
        dbItem = rootItem.child(0)
        permissions = dict()

        schema_count = dbItem.childCount()
        for i in range(schema_count):
            schemaItem = dbItem.child(i)
            permissions[schemaItem.text(0)] = dict()
            category_count = schemaItem.childCount()
            for j in range(category_count):
                categoryItem = schemaItem.child(j)
                permissions[schemaItem.text(0)][categoryItem.text(0)] = dict()
                layer_count = categoryItem.childCount()
                for k in range(layer_count):
                    layerItem = categoryItem.child(k)
                    permissions[schemaItem.text(0)][categoryItem.text(0)][
                        layerItem.text(0)
                    ] = self.getItemCheckState(layerItem)

        profileDict[self.parent] = permissions
        return profileDict

    def readJsonFromDatabase(self, profileName, edgvVersion):
        """
        Reads the profile file, gets a dictionary of it and builds the tree widget
        """

        profileDict = self.permissionManager.getSetting(profileName, edgvVersion)
        self.parent = list(profileDict.keys())[0]
        # invisible root item
        rootItem = self.treeWidget.invisibleRootItem()
        # database item
        dbItem = self.createItem(rootItem, self.parent)

        permissions = profileDict[self.parent]
        self.createChildrenItems(dbItem, permissions)
        self.treeWidget.sortItems(0, Qt.SortOrder.AscendingOrder)

    def createChildrenItems(self, parent, mydict):
        """
        Creates children item in the tree widget
        """
        # permissions
        lista = ["read", "write"]
        for key in list(mydict.keys()):
            if key in lista:
                self.setItemCheckState(parent, mydict, key)
            else:
                itemText = key
                item = self.createItem(parent, itemText)
                self.createChildrenItems(item, mydict[key])

    def setItemCheckState(self, item, mydict, key):
        """
        Sets the item check state
        """
        if key == "read":
            item.setCheckState(1, int(mydict[key]))
        elif key == "write":
            item.setCheckState(2, int(mydict[key]))

    def getItemCheckState(self, item):
        """
        Gets the item check state for READ and WRITE columns
        """
        ret = dict()
        ret["read"] = str(item.checkState(1))
        ret["write"] = str(item.checkState(2))
        return ret

    @pyqtSlot(bool)
    def on_clearButton_clicked(self):
        """
        Clears the tree widget
        """
        # invisible root item
        rootItem = self.treeWidget.invisibleRootItem()
        # database item
        dbItem = rootItem.child(0)
        if dbItem:
            dbItem.setCheckState(1, 0)
            dbItem.setCheckState(2, 0)

    @pyqtSlot(bool)
    def on_closeButton_clicked(self):
        """
        Closes the dialog
        """
        self.close()

    def refreshProfileList(self):
        self.profilesListWidget.clear()
        self.treeWidget.clear()
        self.setEnabled(False)
        profilesDict = self.permissionManager.getSettings()
        for edgvVersion in list(profilesDict.keys()):
            self.profilesListWidget.addItems(
                [i + " ({0})".format(edgvVersion) for i in profilesDict[edgvVersion]]
            )
        self.profilesListWidget.sortItems(order=Qt.SortOrder.AscendingOrder)

    @pyqtSlot(bool)
    def on_createPermissionPushButton_clicked(self):
        """
        Slot that opens the create profile dialog
        """
        # use selector
        permissionDict = self.permissionManager.getSettings()
        parameterDlg = GenericParameterSetter(nameList=list(permissionDict.keys()))
        if not parameterDlg.exec():
            return
        templateDb, profileName, edgvVersion = parameterDlg.getParameters()
        if edgvVersion in list(permissionDict.keys()):
            if profileName in permissionDict[edgvVersion]:
                QMessageBox.warning(
                    self,
                    self.tr("Warning!"),
                    self.tr("Profile ")
                    + profileName
                    + self.tr(" for EDGV ")
                    + edgvVersion
                    + self.tr(" already exists!"),
                )
                return
        newItem = self.populateTreeDict(templateDb, edgvVersion)
        jsonDict = json.dumps(newItem, sort_keys=True, indent=4)
        self.permissionManager.createSetting(profileName, edgvVersion, jsonDict)
        self.updateInterface(profileName, edgvVersion)
        QMessageBox.warning(
            self,
            self.tr("Success!"),
            self.tr("Profile ") + profileName + self.tr(" created successfully!"),
        )

    def setEnabled(self, enabled):
        self.treeWidget.setEnabled(enabled)
        self.saveButton.setEnabled(enabled)
        self.clearButton.setEnabled(enabled)

    @pyqtSlot()
    def on_profilesListWidget_itemSelectionChanged(self):
        profileName, edgvVersion = (
            self.profilesListWidget.currentItem().text().split(" (")
        )
        edgvVersion = edgvVersion.replace(")", "")
        try:
            self.setEnabled(True)
            self.treeWidget.clear()
            self.readJsonFromDatabase(profileName, edgvVersion)
        except:
            pass

    def updateInterface(self, profileName, edgvVersion):
        self.refreshProfileList()
        profileItem = self.profilesListWidget.findItems(
            profileName + " ({0})".format(edgvVersion), Qt.MatchFlag.MatchExactly
        )[0]
        self.profilesListWidget.setCurrentItem(profileItem)

    @pyqtSlot(bool)
    def on_deletePermissionPushButton_clicked(self):
        if self.profilesListWidget.currentItem() is not None:
            profileName, edgvVersion = (
                self.profilesListWidget.currentItem().text().split(" (")
            )
            edgvVersion = edgvVersion.replace(")", "")
            if (
                QMessageBox.question(
                    self,
                    self.tr("Question"),
                    self.tr("Do you really want to delete profile ")
                    + profileName
                    + "?",
                    QMessageBox.StandardButton.Ok | QMessageBox.StandardButton.Cancel,
                )
                == QMessageBox.StandardButton.Cancel
            ):
                return
            try:
                QApplication.setOverrideCursor(QCursor(Qt.CursorShape.WaitCursor))
                self.permissionManager.deleteSetting(profileName, edgvVersion)
                QApplication.restoreOverrideCursor()
                QMessageBox.warning(
                    self,
                    self.tr("Success!"),
                    self.tr("Permission ")
                    + profileName
                    + self.tr(" successfully deleted."),
                )
                self.refreshProfileList()
            except Exception as e:
                QApplication.restoreOverrideCursor()
                QMessageBox.warning(
                    self,
                    self.tr("Warning!"),
                    self.tr("Error! Problem deleting permission: ") + ":".join(e.args),
                )

    @pyqtSlot(bool)
    def on_saveButton_clicked(self):
        profileName, edgvVersion = (
            self.profilesListWidget.currentItem().text().split(" (")
        )
        edgvVersion = edgvVersion.replace(")", "")
        newProfileDict = self.makeProfileDict()
        try:
            QApplication.setOverrideCursor(QCursor(Qt.CursorShape.WaitCursor))
            self.permissionManager.updateSetting(
                profileName, edgvVersion, newProfileDict
            )
            QApplication.restoreOverrideCursor()
            QMessageBox.warning(
                self,
                self.tr("Success!"),
                self.tr("Permission ")
                + profileName
                + self.tr(" successfully updated."),
            )
        except Exception as e:
            QApplication.restoreOverrideCursor()
            QMessageBox.warning(
                self,
                self.tr("Warning!"),
                self.tr("Error! Problem updating permission: ") + ":".join(e.args),
            )

    def populateTreeDict(self, abstractDb, version):
        """
        Makes a tree widget were the user can define profile properties
        """
        try:
            # get a dict with all tables from database
            geomList = abstractDb.getTablesJsonList()
        except Exception as e:
            QMessageBox.critical(
                self,
                self.tr("Critical!"),
                self.tr("A problem occurred! Check log for details."),
            )
            QgsMessageLog.logMessage(
                ":".join(e.args), "DSGTools Plugin", Qgis.MessageLevel.Critical
            )
            return
        profile = dict()
        categories = dict()
        for jsonItem in geomList:
            layerName = jsonItem["table_name"]
            schema = jsonItem["table_schema"]
            if version != "Non_EDGV":
                category = layerName.split("_")[0]
            else:
                category = schema
            if schema not in list(categories.keys()):
                categories[schema] = dict()
            if category not in list(categories[schema].keys()):
                categories[schema][category] = dict()
            if layerName not in categories[schema][category]:
                categories[schema][category][layerName] = dict()
                categories[schema][category][layerName]["read"] = "0"
                categories[schema][category][layerName]["write"] = "0"
        profile["database" + "_" + version] = categories
        return profile
