# -*- coding: utf-8 -*-
"""
/***************************************************************************
 CampoMag
                                 A QGIS plugin
 Plugin para la administracion de datos segun modelo MAG de ANLA
 Generated by Plugin Builder: http://g-sherman.github.io/Qgis-Plugin-Builder/
                              -------------------
        begin                : 2023-10-24
        git sha              : $Format:%H$
        copyright            : (C) 2023 by WilliamHuertas-LindaMaldonado/UDistrital/Esp_SIG
        email                : wfhuertasg@gmail.com;lkmaldonadoo998@gmail.com
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   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.                                   *
 *                                                                         *
 ***************************************************************************/
"""
import os
import sys
"""
CampoMAG fue desarrollado por:

William Huertas – wfhuertasg@gmail.com
Linda Maldonado - lkmaldonadoo999@gmail.com
"""

from .src import createMagAnla, CargaGruposEmpaquetar, cargarDatosBD, CrearGPKG

from qgis.PyQt.QtCore import QSettings, QTranslator, QCoreApplication
from qgis.PyQt.QtGui import QIcon
from qgis.PyQt.QtWidgets import QAction, QMenu, QMessageBox
from qgis.utils import iface


# Initialize Qt resources from file resources.py
from .resources import *
# Import the code for the dialog
from .CampoMAG_dialog import CampoMagDialog, crear_cascaron, Cargar_Empaquetar, Conexion, ConexionPrin
import os.path

import psycopg2
from psycopg2 import OperationalError


class CampoMag:
    """QGIS Plugin Implementation."""

    def __init__(self, iface):
        """Constructor.

        :param iface: An interface instance that will be passed to this class
            which provides the hook by which you can manipulate the QGIS
            application at run time.
        :type iface: QgsInterface
        """
        # Save reference to the QGIS interface
        self.iface = iface
        # initialize plugin directory
        self.plugin_dir = os.path.dirname(__file__)
        # initialize locale
        locale = QSettings().value('locale/userLocale')[0:2]
        locale_path = os.path.join(
            self.plugin_dir,
            'i18n',
            'CampoMag_{}.qm'.format(locale))

        if os.path.exists(locale_path):
            self.translator = QTranslator()
            self.translator.load(locale_path)
            QCoreApplication.installTranslator(self.translator)

        # Declare instance attributes
        self.actions = []
        self.menu = self.tr(u'&CampoMag')

        # Check if plugin was started the first time in current QGIS session
        # Must be set in initGui() to survive plugin reloads
        self.first_start = None

        self.dlg = None
        self.dlg2 = None
        self.dlg3 = None
        self.dlg4 = None

        self.hostt = None
        self.puerto = None
        self.usuario = None
        self.contra = None
        self.nombre_db = None

    # noinspection PyMethodMayBeStatic
    def tr(self, message):
        """Get the translation for a string using Qt translation API.

        We implement this ourselves since we do not inherit QObject.

        :param message: String for translation.
        :type message: str, QString

        :returns: Translated version of message.
        :rtype: QString
        """
        # noinspection PyTypeChecker,PyArgumentList,PyCallByClass
        return QCoreApplication.translate('CampoMag', message)


    def add_action(
        self,
        icon_path,
        text,
        callback,
        enabled_flag=True,
        add_to_menu=True,
        add_to_toolbar=True,
        status_tip=None,
        whats_this=None,
        parent=None):
        """Add a toolbar icon to the toolbar.

        :param icon_path: Path to the icon for this action. Can be a resource
            path (e.g. ':/plugins/foo/bar.png') or a normal file system path.
        :type icon_path: str

        :param text: Text that should be shown in menu items for this action.
        :type text: str

        :param callback: Function to be called when the action is triggered.
        :type callback: function

        :param enabled_flag: A flag indicating if the action should be enabled
            by default. Defaults to True.
        :type enabled_flag: bool

        :param add_to_menu: Flag indicating whether the action should also
            be added to the menu. Defaults to True.
        :type add_to_menu: bool

        :param add_to_toolbar: Flag indicating whether the action should also
            be added to the toolbar. Defaults to True.
        :type add_to_toolbar: bool

        :param status_tip: Optional text to show in a popup when mouse pointer
            hovers over the action.
        :type status_tip: str

        :param parent: Parent widget for the new action. Defaults None.
        :type parent: QWidget

        :param whats_this: Optional text to show in the status bar when the
            mouse pointer hovers over the action.

        :returns: The action that was created. Note that the action is also
            added to self.actions list.
        :rtype: QAction
        """

        icon = QIcon(icon_path)
        action = QAction(icon, text, parent)
        action.triggered.connect(callback)
        action.setEnabled(enabled_flag)

        if status_tip is not None:
            action.setStatusTip(status_tip)

        if whats_this is not None:
            action.setWhatsThis(whats_this)

        if add_to_toolbar:
            # Adds plugin icon to Plugins toolbar
            self.iface.addToolBarIcon(action)

        if add_to_menu:
            self.iface.addPluginToMenu(
                self.menu,
                action)

        self.actions.append(action)

        return action

    def initGui(self):
        """Create the menu entries and toolbar icons inside the QGIS GUI."""

        icon_path = ':/plugins/CampoMAG/icon.png'
        icon_path_casc = ':/plugins/CampoMAG/iconos/Crear_cascaron.png'
        icon_path_agreg = ':/plugins/CampoMAG/iconos/agregar.png'
        icon_path_sub = ':/plugins/CampoMAG/iconos/subir.png'
        icon_path_geopack = ':/plugins/CampoMAG/iconos/geopackage.png'
        icon_path_conect = ':/plugins/CampoMAG/iconos/sql1.png'

        self.add_action(
            icon_path_conect,
            text=self.tr(u'Conectar a BD Existente'),
            callback=self.run2,
            parent=self.iface.mainWindow())

        # will be set False in run()
        self.first_start = True

        #Boton para crear el modelo
        self.add_action(
            icon_path_casc,
            text=self.tr(u'&Crear modelo MAG dentro de Postgres'),
            callback=self.crearModeloMag,
            parent=self.iface.mainWindow())

        # will be set False in run()
        self.first_start = True

        # Boton para cargar y empaquetar datos
        self.add_action(
            icon_path_agreg,
            text=self.tr(u'&Cargar y empaquetar capas al proyecto'),
            callback=self.cargarEmpaquetar,
            parent=self.iface.mainWindow())

        # will be set False in run()
        self.first_start = True

        # Boton para cargar y empaquetar datos
        self.add_action(
            icon_path_sub,
            text=self.tr(u'&Cargar Datos a Postgres'),
            callback=self.cargarDatosBd,
            parent=self.iface.mainWindow())

        # will be set False in run()
        self.first_start = True

        # Boton para cargar y empaquetar datos
        self.add_action(
            icon_path_geopack,
            text=self.tr(u'&Exportar de Postgres a Geopackage'),
            callback=self.ExportGeoPack,
            parent=self.iface.mainWindow())

        # will be set False in run()
        self.first_start = True


    def unload(self):
        """Removes the plugin menu item and icon from QGIS GUI."""

        for action in self.actions:
            self.iface.removePluginMenu(
                self.tr(u'&CampoMag'),
                action)
            self.iface.removeToolBarIcon(action)


    def run2(self):
        """Run method that performs all the real work"""

        # Create the dialog with elements (after translation) and keep reference
        # Only create GUI ONCE in callback, so that it will only load when the plugin is started
        if self.dlg3 is None:
            self.dlg3 = ConexionPrin()

        # show the dialog
        self.dlg3.show()
        self.dlg3.btnConecP.disconnect()
        self.dlg3.btnConecP.clicked.connect(self.conectar)
        # Run the dialog event loop
        result = self.dlg3.exec_()
        # See if OK was pressed
        if result:
            # Do something useful here - delete the line containing pass and
            # substitute with your code.
            pass

    def crearModeloMag(self):
        """Run method that performs all the real work"""

        # Create the dialog with elements (after translation) and keep reference
        # Only create GUI ONCE in callback, so that it will only load when the plugin is started
        """if self.first_start == True:
            self.first_start = False
            self.dlg = crear_cascaron()"""
        if self.dlg is None:
            self.dlg = crear_cascaron()

        # show the dialog
        self.dlg.show()
        self.dlg.btn_crear.disconnect()
        self.dlg.btn_crear.clicked.connect(self.cascaron)
        # Run the dialog event loop
        result = self.dlg.exec_()
        # See if OK was pressed
        if result:
            # Do something useful here - delete the line containing pass and
            # substitute with your code.
            pass

    def cargarEmpaquetar(self):
        """Run method that performs all the real work"""

        # Create the dialog with elements (after translation) and keep reference
        # Only create GUI ONCE in callback, so that it will only load when the plugin is started
        """if self.first_start == True:
            self.first_start = False
            self.dlg2 = Cargar_Empaquetar()"""
        if self.dlg2 is None:
            self.dlg2 = Cargar_Empaquetar()

        # show the dialog
        self.dlg2.show()
        self.dlg2.btn_cargar.disconnect()
        self.dlg2.btn_cargar.clicked.connect(self.cargar)

        self.dlg2.btn_empaq.disconnect()
        self.dlg2.btn_empaq.clicked.connect(self.empaquetar_QField)


        #self.dlg.btn_empaq.clicked.connect()
        # Run the dialog event loop
        result = self.dlg2.exec_()
        # See if OK was pressed
        if result:
            # Do something useful here - delete the line containing pass and
            # substitute with your code.
            pass

    def cascaron(self):
        self.hostt = self.dlg.Ledit_host.text()
        self.puerto = self.dlg.Ledit_puerto.text()
        self.usuario = self.dlg.Ledit_user.text()
        self.contra = self.dlg.Ledit_contrasenia.text()
        self.nombre_db = self.dlg.Ledit_bd.text()

        createMagAnla.conexion(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)

    def cargar(self):
        if self.hostt == None or self.puerto == None or self.usuario == None or self.contra == None or self.nombre_db == None:

            QMessageBox.information(None, "Mensaje", "Debe conectarse a una base de datos")

            if self.dlg3 is None:
                self.dlg3 = ConexionPrin()

            self.dlg3.btnConecP.disconnect()
            self.dlg3.btnConecP.clicked.connect(self.conectar)

            result = self.dlg3.exec_()

            if result:
                CargaGruposEmpaquetar.carga(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)
                self.dlg3.close()

        else:
            print(f'Host: {self.hostt}\nPuerto: {self.puerto}\nUsuario: {self.usuario}\nContraseña: {self.contra}\nNombre BD: {self.nombre_db}')
            CargaGruposEmpaquetar.carga(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)

    def conectar(self):
        print('entro a conectar')

        self.hostt = None
        self.puerto = None
        self.usuario = None
        self.contra = None
        self.nombre_db = None

        self.hostt = self.dlg3.LEditHosttP.text()
        self.puerto = self.dlg3.LEditPuertoP.text()
        self.usuario = self.dlg3.LEditUserP.text()
        self.contra = self.dlg3.LEditContraP.text()
        self.nombre_db = self.dlg3.LEditBDP.text()

        try:
            if self.hostt == None or self.puerto == None or self.usuario == None or self.contra == None or self.nombre_db == None:
                QMessageBox.warning(None, "Mensaje", "Todos los campos son obligatorios")
            elif self.hostt == '' or self.puerto == '' or self.usuario == '' or self.contra == '' or self.nombre_db == '':
                QMessageBox.warning(None, "Mensaje", "Todos los campos son obligatorios")
            else:
                # Conecta a la base de datos
                conn = psycopg2.connect(
                    host=self.hostt,
                    port=self.puerto,
                    database=self.nombre_db,
                    user=self.usuario,
                    password=self.contra,
                )
                print(
                    f'host: {self.hostt}\nPuerto: {self.puerto}\nUsuario: {self.usuario}\nContras: {self.contra}\nBD: {self.nombre_db}')

                conn.close()

                QMessageBox.information(None, "Mensaje", "La conexión ha sido exitosa")
                self.dlg3.close()

        except OperationalError as e:
            # Maneja los errores específicos de psycopg2
            if not self.hostt or not self.puerto or not self.usuario or not self.contra or not self.nombre_db:
                print("Todos los campos son obligatorios")
                QMessageBox.warning(None, "Mensaje", "Todos los campos son obligatorios")
            else:
                print("Error al conectarse a PostgreSQL:", str(e))
                QMessageBox.warning(None, "Mensaje",
                                    f"Error al conectarse a PostgreSQL, revise las credenciales ingresadas\n{e}")
        except Exception as e:
            if e.pgcode == psycopg2.errorcodes.DUPLICATE_DATABASE:
                QMessageBox.warning(None, "Mensaje", f"{e}")
            else:
                QMessageBox.warning(None, "Mensaje", f"{e}")

    def empaquetar_QField(self):
        print('Entro a empaquetar')
        CargaGruposEmpaquetar.empaquetar()

    def cargarDatosBd(self):
        if self.hostt == None or self.puerto == None or self.usuario == None or self.contra == None or self.nombre_db == None:

            QMessageBox.information(None, "Mensaje", "Debe conectarse a una base de datos")

            if self.dlg3 is None:
                self.dlg3 = ConexionPrin()

            self.dlg3.btnConecP.disconnect()
            self.dlg3.btnConecP.clicked.connect(self.conectar)

            result = self.dlg3.exec_()

            if result:
                cargarDatosBD.cargar_a_BD(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)
                self.dlg3.close()

        else:
            cargarDatosBD.cargar_a_BD(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)

    def ExportGeoPack(self):
        if self.hostt == None or self.puerto == None or self.usuario == None or self.contra == None or self.nombre_db == None:

            QMessageBox.information(None, "Mensaje", "Debe conectarse a una base de datos")

            if self.dlg3 is None:
                self.dlg3 = ConexionPrin()

            self.dlg3.btnConecP.disconnect()
            self.dlg3.btnConecP.clicked.connect(self.conectar)

            result = self.dlg3.exec_()

            if result:
                CrearGPKG.gpkg(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)
                self.dlg3.close()

        else:
            print(
                f'Host: {self.hostt}\nPuerto: {self.puerto}\nUsuario: {self.usuario}\nContraseña: {self.contra}\nNombre BD: {self.nombre_db}')
            CrearGPKG.gpkg(self.hostt, self.puerto, self.usuario, self.contra, self.nombre_db)