import os

from App.Config.GeneralConfig import GeneralConfig
from App.Config.GeneralConfig import ConfigFTP
from App.Utils.db_utils import DatabaseManager
from App.Utils.ftp_utils import FTPManager
from App.Utils.sftp_utils import SFTPManager



class FeduroConfig:

    def __init__(self):
        #Inicializando la base de datos
        self.databaseCode = 'IS001'
        self.databaseID = '00010007'

        self.database = DatabaseManager(self.databaseCode, self.databaseID)

        #Inicialzando el FTP
        self.ftpdatabase = FTPManager(ConfigFTP.ftp_server, ConfigFTP.ftp_user, ConfigFTP.ftp_password, ConfigFTP.ftp_port)

        #Inicializando el SFTP
        self.sftp_host = 'c6a3nxpth6mf4.eastus2.azurecontainer.io'
        self.sftp_port = 22
        self.sftp_username = 'eLeader01'
        self.sftp_password = 'c8gNBhJE@zt$ZkT&'
        
        self.sftpdatabase = SFTPManager(self.sftp_host, self.sftp_port, self.sftp_username, self.sftp_password)


        #Inicializando SharePoint

        self.userSharepoint = 'feddatadeployment.im@pg.com' #os.getenv('sharepointPG_user')
        self.passwordSharepoint = 'Feduro_PG_2025$' #= os.getenv('sharepointPG_password')
        self.siteSharepoint = 'https://pgone.sharepoint.com/sites/feduroinfinitystores' #os.getenv('sharepointPG_site')
      

        #General configuration feduro
        self.areaID = '0007'
        self.project_name = 'FEDURO'
        self.classID = '0003'


        self.reports = self.database.get_execute_query(f"select * from TransferData where active = 1")




        self.reports_sftp = {'Cobertura':'/upload/FEDURO/DataCollection/Cobertura/CoberturaCheckIn-Out/',
                'NegociadasIS001':'/upload/FEDURO/DataCollection/Negociadas/AC Ejecutado/',
                'Promociones':'/upload/FEDURO/DataCollection/Promociones/PROMO EJECUTADA/',
                'Precios':'',
                'Fmot':'/upload/FEDURO/DataCollection/Fmot/fmot Data/',
                'QualityDisplay':'/upload/FEDURO/DataCollection/Quality Display/',
                'Checkout':'/upload/FEDURO/DataCollection/CheckOut/Data/',
                'QualityShelf':'/upload/FEDURO/DataCollection/QualityShelf/QualityShelf_Data/',
                'SOSFeduro':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'OsaTorre':'',
                'OsaPsmt':'',
                'OsaFarmacia':'',
                'OsaFotografico':'/upload/FEDURO/DataCollection/OSA/OSA_Fotos_Categoria/',
                'DataAvailability':'',
                'OsaAnalogo': '/upload/FEDURO/DataCollection/OSA/Data/',
                'ModuloTareas': '/upload/FEDURO/DataCollection/ModuloTareas/Data/',
                'SOSAPDO_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSBabyCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSFabricCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSFamilyCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSFemCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSHairCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSHomeCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSOralCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
                'SOSPHC_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/'
                }
        

        
        self.reportsID = {'Cobertura':'0001',
                'NegociadasIS001':'0002',
                'Promociones':'0003',
                #'Precios':'0004',
                'Fmot':'0005',
                'QualityDisplay':'0006',
                'Checkout':'0007',
                'QualityShelf':'0008',
                'SOSFeduro':'0009',
                #'OsaTorre':'0010',
                #'OsaPsmt':'0011',
                #'OsaFarmacia':'0012',
                'OsaFotografico':'0013',
                #'DataAvailability':'0014',
                'OsaAnalogo':'0015',
                'ModuloTareas':'0016',
                #'SOSAPDO_IS001':'0017',
                #'SOSBabyCare_IS001':'0018',
                #'SOSFabricCare_IS001':'0019',
                #'SOSFamilyCare_IS001':'0020',
                #'SOSFemCare_IS001':'0012',
                #'SOSHairCare_IS001':'0022',
                #'SOSHomeCare_IS001':'0023',
                #'SOSOralCare_IS001':'0024',
                #'SOSPHC_IS001':'0025'
                    }
        
        self.steps = {
            "sftp": True,
            "ftp": True,
            "sharepoint_python": True,
            "sharepoint_N8N": False,
        }