GUI_̀̀5g.py

# from tkinter import *
from tkinter import Frame, Text, Button, Menu, Label, W, E, END, Tk
from tkinter.filedialog import askopenfilename, askdirectory, Toplevel, CENTER, askopenfilenames, DISABLED, NORMAL
from tkinter.messagebox import *
from tkinter.scrolledtext import ScrolledText

import os

from log_parser_Hoang import *
from qcat_exp import *
from UpLinkAnalysis import *

from variable import *


# from variable import log_file_PATH, config_file_PATH, csv_folder_PATH, raw_log_file_PATH
# IMPORTAN PATH
# config_file_PATH = r''
# log_file_PATH = r''
# csv_folder_PATH = r''
# csv_dict = {}

class Window(Frame):
    def __init__(self, master):
        Frame.__init__(self, master)
        self.master = master
        self.master.title("LOG ANALYSIS TOOLS")

        self.QCAT_func_button = Button(self.master, text='QCAT Automation', command=self.Call_Open_QCAT)
        self.QCAT_func_button.config(width=25, heigh=2, padx=5, pady=5)
        # self.QCAT_func_button.grid(row = 0, column = 0, columnspan=2)
        self.QCAT_func_button.place(relx=0.5, rely=0.2, anchor=CENTER)

        self.Table_func_button = Button(self.master, text='Convert Table Automation',
                                        command=self.Call_Convert_Table_Auto)
        self.Table_func_button.config(width=25, heigh=2, padx=5, pady=5)
        self.Table_func_button.place(relx=0.5, rely=0.4, anchor=CENTER)

        self.Table_func_button = Button(self.master, text='Uplink Table Merge',
                                        command=self.Call_Uplink_Analysis)
        self.Table_func_button.config(width=25, heigh=2, padx=5, pady=5)
        self.Table_func_button.place(relx=0.5, rely=0.6, anchor=CENTER)

    def Call_Open_QCAT(self):
        self.newWindow = Toplevel(self.master)
        self.app = QCAT_Auto(self.newWindow)

    def Call_Convert_Table_Auto(self):
        self.newWindow = Toplevel(self.master)
        self.app = Convert_Table_Auto(self.newWindow)

    def Call_Uplink_Analysis(self):
        self.newWindow = Toplevel(self.master)
        self.app = Uplink_Analysis(self.newWindow)


######################
class Convert_Table_Auto(Frame):

    def __init__(self, master=None):
        self.cur_dir  = os.getcwd()
        Frame.__init__(self, master)

        self.master = master
        window_width = 460
        window_heigh = 510
        x_pos = (screen_width / 2) - (window_width / 2)
        y_pos = (screen_heigh / 2) - (window_heigh / 2)
        # self.master.geometry("420x200")
        self.master.geometry('%dx%d+%d+%d' % (window_width, window_heigh, x_pos, y_pos))
        self.master.title("Conver Table Automation")


        ######################################################################################################
        self.config_file_PATH_label = Label(self.master, text="4G Config file path")
        self.config_file_PATH_label.grid(row=0, column=0, sticky=W, pady=2)
        self.config_file_PATH_txt = Text(self.master, heigh=1, width=35)
        self.config_file_PATH_txt.grid(row=0, column=1, pady=2)

        self.config_file_PATH_label_5g = Label(self.master, text="5G Config file path")
        self.config_file_PATH_label_5g.grid(row=1, column=0, sticky=W, pady=2)
        self.config_file_5g_PATH_txt = Text(self.master, heigh=1, width=35)
        self.config_file_5g_PATH_txt.grid(row=1, column=1, pady=2)

        self.log_file_PATH_label = Label(self.master, text="Log files dir")
        self.log_file_PATH_label.grid(row=2, column=0, sticky=W, pady=2)
        self.log_file_PATH_txt = Text(self.master, heigh=1, width=35)
        self.log_file_PATH_txt.grid(row=2, column=1, pady=2)

        self.qcat_input_label = Label(self.master, text='')

        self.log_type_label = Label(self.master, text="Information")
        self.log_type_label.grid(row=3, column=0, sticky=W)
        self.log_type_txt = ScrolledText(self.master, undo=True, width=55)
        self.log_type_txt.grid(row=3, rowspan=4, column=0, columnspan=3, sticky=W)

        self.csv_dir_label = Label(self.master, text="CSV directory")
        self.csv_dir_label.grid(row=9, column=0, sticky=W)
        self.csv_dir_txt = Text(self.master, heigh=1, width=35)
        self.csv_dir_txt.grid(row=9, column=0, columnspan=3, padx=80, sticky=W)

        ######################################################################################################

        self.convert_csv_button = Button(self.master, text='Convert to csv', command=self.call_convert_csv)
        self.convert_csv_button.grid(row=9, column=1, columnspan=2, sticky=E, pady=2, padx=3)
        self.convert_csv_button.config(width=11, heigh=2)
        self.extract_config_button = Button(self.master, text="Extract", command=self.call_extract)
        self.extract_config_button.grid(row=0, column=2, sticky=E, padx=4)
        # self.view_log_button = Button(self.master, text = "View")
        # self.view_log_button.grid(row=1, column=2, sticky=E, padx=4)

        ###############################################################################
        # creating a menu instance
        self.menu = Menu(self.master)
        self.master.config(menu=self.menu)

        # create the file object)
        self.file = Menu(self.menu)

        # adds a command to the menu option, calling it exit, and the
        # command it runs on event is client_exit
        # self.file.add_command(label="QCAT Automation", command = self.openQCAT)
        self.file.add_command(label="Open Config 4G", command=self.open_config)
        self.file.add_command(label="Open Config 5G", command=self.open_config_5g)
        self.file.add_command(label="Choose Log Files", command=self.open_log)
        self.file.add_command(label="Set CSV Directory", command=self.set_csv_directory)
        self.file.add_command(label="Exit", command=self.client_exit)
        self.menu.add_cascade(label="File", menu=self.file)
        # menu.add_cascade(label="Open config", menu=file)

        self.edit = Menu(self.menu)
        self.menu.add_cascade(label="Edit", menu=self.edit)

        self.help = Menu(self.menu)
        self.help.add_command(label="About", command=self.show_about)
        self.help.add_command(label="Instruction", command=self.show_instruction)
        self.menu.add_cascade(label="Help", menu=self.help)

    ####################################################################################

    def client_exit(self):
        exit()

    def is_uniconfig(self):
        if self.config_file_PATH_txt.get('1.0', END) != '\n' and self.config_file_5g_PATH_txt.get('1.0', END) != '\n':
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            return False
        else:
            return True

    def open_config(self):
        ###Test
        # global config_file_PATH
        # config_file_PATH = r'G:\PycharmProjects\Log_Extractor\parser.cfg'
        if self.cur_dir == None:
            self.cur_dir = os.getcwd()
        filename = askopenfilename(initialdir=self.cur_dir, title="Select file",
                                   filetypes=(("config file", "*.cfg"), ("all files", "*.*")))
        if filename:
            global config_file_PATH
            config_file_PATH = filename
            print(config_file_PATH)
            # self.update_text()
            self.config_file_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            self.config_file_PATH_txt.insert(END, config_file_PATH)
        else:
            showerror("Error", "No file selected")

        if self.is_uniconfig() == False:
            showerror("Error", "Cannot choose more than two config files!!!")

    def open_config_5g(self):
        ###Test
        # global config_file_PATH
        # config_file_PATH = r'G:\PycharmProjects\Log_Extractor\parser.cfg'
        if self.cur_dir == None:
            self.cur_dir = os.getcwd()
        filename = askopenfilename(initialdir=self.cur_dir, title="Select file",
                                   filetypes=(("config file", "*.cfg"), ("all files", "*.*")))
        if filename:
            global config_file_PATH
            config_file_PATH = filename
            print(config_file_PATH)
            # self.update_text()
            self.config_file_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.insert(END, config_file_PATH)
        else:
            showerror("Error", "No file selected")

        if self.is_uniconfig() == False:
            showerror("Error", "Cannot choose more than one config file!!!")

    def open_log(self):
        # Test
        # global log_file_PATH
        # log_file_PATH = r'G:\PycharmProjects\Log_Extractor\Test\log_test.txt'
        if self.cur_dir == None:
            self.cur_dir = os.getcwd()
        log_paths = askopenfilenames(initialdir=self.cur_dir, title="Select file",
                                    filetypes=(("log file", "*.log *txt"), ("text file", "*.txt"), ("all files", "*.*")))
        # log_path = askdirectory()
        if log_paths:
            global log_file_PATH
            for path in log_paths:
                log_file_PATH.append(path)

            # log_file_PATH = log_paths
            print(log_paths)
            self.log_file_PATH_txt.delete("1.0", "end")
            self.log_file_PATH_txt.insert(END, log_file_PATH)
        else:
            showerror("Error", "No file selected")

    def set_csv_directory(self):
        csv_dir = askdirectory()
        if csv_dir:
            global csv_folder_PATH
            csv_folder_PATH = csv_dir
            self.csv_dir_txt.delete("1.0", "end")
            self.csv_dir_txt.insert(END, csv_dir)
        else:
            showerror("Error", "No directory selected")
        ##Test'
        # global csv_folder_PATH
        # csv_folder_PATH = r'C:\Users\Admin\Desktop\test'

    def call_extract(self):
        global config_file_PATH
        global log_type_list_brief, log_type_list_full
        # if config_file_PATH == '':
        #     self.log_type_txt.insert("Error, No file selected")
        #     # showerror("Error", "No file selected")
        #     return
        try:
            self.log_type_txt.delete("1.0", "end")
            self.log_type_txt.insert(END, "Extracting...\n")
            lines = read_file(config_file_PATH)
            log_type_list_brief, log_type_list_full, grids = read_config_log_types(lines)
            if len(log_type_list_brief) != 0:
                # self.log_type_txt.delete("1.0", "end")
                self.log_type_txt.insert(END, '\n#Packets\n')
                for log in log_type_list_brief:
                    self.log_type_txt.insert(END, log + '\n')

                if len(grids) != 0:
                    self.log_type_txt.insert(END, '\n#Grids\n')
                    for grid in grids.keys():
                        self.log_type_txt.insert(END, grid + '\n')

                self.log_type_txt.insert(END, "\nExtract successfully!!!\n")
                # showinfo("Respond", "Extract successfully")
            else:
                showwarning("Config Empty", "No log type found in config file. Try again!")
        except:
            # self.log_type_txt.delete("1.0", "end")
            self.log_type_txt.insert(END, "Error extracting\n")

    def call_convert_csv(self):
        global csv_dict, csv_folder_PATH, log_file_PATH, log_type_list_brief, config_file_PATH
        print(log_type_list_brief)
        if csv_folder_PATH == '':
            self.log_type_txt.insert(END, "You need to select csv directory before convert\n")
            return
        try:
            #TODO: Fix error: No grid name 'LTE Serving Cell Meas vs .TIme)

            # Filter signaling message
            from tool_summary import concat_signaling
            self.log_type_txt.insert(END, "Filtering signal packets...\n")
            for log in log_file_PATH:
                concat_signaling(config_file_PATH, log, csv_folder_PATH)
            self.log_type_txt.insert(END, "Exported signal packets!\n")

            # Convert CSV
            self.log_type_txt.insert(END, "Converting! Please wait...\n")
            for t in log_type_list_brief:  # init dict of log data list for csv
                csv_dict[t] = [0, []]
            for path in log_file_PATH:
                parse_log(path, log_type_list_brief, csv_dict)
            write_csv(csv_folder_PATH, csv_dict)


            self.log_type_txt.insert(END, "Converting successful\n")
        except:
            self.log_type_txt.insert(END, "Fail converting!\n")
            # showerror("Error", "Error Converting")

    # def openQCAT(self):
    #     self.newWindow = Toplevel(self.master)
    #     self.app = QCAT_Auto(self.newWindow)

    def show_instruction(self):
        pass

    def show_about(self):
        pass


class QCAT_Auto(Frame):

    def __init__(self, master=None):

        self.cur_dir = os.getcwd()

        Frame.__init__(self, master)
        self.master = master
        window_width = 460
        window_heigh = 510
        x_pos = (screen_width / 2) - (window_width / 2)
        y_pos = (screen_heigh / 2) - (window_heigh / 2)
        # self.master.geometry("420x200")
        self.master.geometry('%dx%d+%d+%d' % (window_width, window_heigh, x_pos, y_pos))
        self.master.title("QCAT Automation")

        ######################################################################################################
        self.config_file_PATH_label = Label(self.master, text="4G Config file path")
        self.config_file_PATH_label.grid(row=0, column=0, sticky=W, pady=2)
        self.config_file_PATH_txt = Text(self.master, heigh=1, width=35)
        self.config_file_PATH_txt.grid(row=0, column=1, pady=2)

        self.config_file_PATH_label_5g = Label(self.master, text="5G Config file path")
        self.config_file_PATH_label_5g.grid(row=1, column=0, sticky=W, pady=2)
        self.config_file_5g_PATH_txt = Text(self.master, heigh=1, width=35)
        self.config_file_5g_PATH_txt.grid(row=1, column=1, pady=2)

        self.raw_log_file_PATH_label = Label(self.master, text="Raw Log file path")
        self.raw_log_file_PATH_label.grid(row=3, column=0, sticky=W, pady=2)
        self.raw_log_file_PATH_txt = Text(self.master, heigh=1, width=35)
        self.raw_log_file_PATH_txt.grid(row=3, column=1, pady=2)

        # self.qcat_input_label = Label(self.master, text = '')

        self.log_type_label = Label(self.master, text="Information")
        self.log_type_label.grid(row=3, column=0, sticky=W)
        self.log_type_txt = ScrolledText(self.master, undo=True, width=55)
        self.log_type_txt.grid(row=4, rowspan=4, column=0, columnspan=3, sticky=W)

        self.QCAT_txt_dir_label = Label(self.master, text="QCAT Output\nDirectory")
        self.QCAT_txt_dir_label.grid(row=9, column=0, sticky=W)
        self.QCAT_txt_dir_txt = Text(self.master, heigh=1, width=35)
        self.QCAT_txt_dir_txt.grid(row=9, rowspan=2, column=0, columnspan=3, padx=80, sticky=W)

        ######################################################################################################

        self.Import_txt_button = Button(self.master, text='Import to txt', command=self.call_import_txt)
        self.Import_txt_button.grid(row=9, column=1, columnspan=3, sticky=E, pady=2, padx=3)
        self.Import_txt_button.config(width=10, heigh=2)
        self.extract_config_button = Button(self.master, text="Extract", state=DISABLED, command=self.call_extract)
        self.extract_config_button.grid(row=0, column=2, sticky=E, padx=4)
        # self.view_log_button = Button(self.master, text = "View")
        # self.view_log_button.grid(row=1, column=2, sticky=E, padx=4)

        ###############################################################################
        # creating a menu instance
        self.menu = Menu(self.master)
        self.master.config(menu=self.menu)

        # create the file object)
        self.file = Menu(self.menu)

        # adds a command to the menu option, calling it exit, and the
        # command it runs on event is client_exit
        # self.file.add_command(label="QCAT Automation", command = self.openQCAT)
        self.file.add_command(label="Open 4G Config", command=self.open_config)
        self.file.add_command(label="Open 5G Config", command=self.open_config_5g)
        self.file.add_command(label="Open Raw Log", command=self.open_raw_log)
        self.file.add_command(label="Set Output Directory", command=self.set_output_directory)
        self.file.add_command(label="Exit", command=self.client_exit)
        self.menu.add_cascade(label="File", menu=self.file)
        # menu.add_cascade(label="Open config", menu=file)

        self.edit = Menu(self.menu)
        self.menu.add_cascade(label="Edit", menu=self.edit)

        self.help = Menu(self.menu)
        self.help.add_command(label="About", command=self.show_about)
        self.help.add_command(label="Instruction", command=self.show_instruction)
        self.menu.add_cascade(label="Help", menu=self.help)

    ####################################################################################

    def client_exit(self):
        exit()

    def is_uniconfig(self):
        if self.config_file_PATH_txt.get('1.0', END) != '\n' and self.config_file_5g_PATH_txt.get('1.0', END) != '\n':
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            return False
        else:
            return True

    def open_config(self):
        ###Test
        # global config_file_PATH
        # config_file_PATH = r'G:\PycharmProjects\Log_Extractor\parser.cfg'
        filename = askopenfilename(initialdir=self.cur_dir, title="Select file",
                                   filetypes=(("config file", "*.cfg"), ("all files", "*.*")))
        if filename:
            global QCAT_config_file_PATH
            QCAT_config_file_PATH = filename
            print(QCAT_config_file_PATH)
            # self.update_text()
            self.config_file_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            self.config_file_PATH_txt.insert(END, QCAT_config_file_PATH)
            self.extract_config_button.config(state=NORMAL)
        else:
            showerror("Error", "No file selected")

        if self.is_uniconfig() == False:
            showerror("Error", "Cannot choose more than one config file!!!")

    def open_config_5g(self):
        ###Test
        # global config_file_PATH
        # config_file_PATH = r'G:\PycharmProjects\Log_Extractor\parser.cfg'
        if self.cur_dir == None:
            self.cur_dir = os.getcwd()
        filename = askopenfilename(initialdir=self.cur_dir, title="Select file",
                                   filetypes=(("config file", "*.cfg"), ("all files", "*.*")))
        if filename:
            global config_file_PATH
            config_file_PATH = filename
            print(config_file_PATH)
            # self.update_text()
            self.config_file_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.delete("1.0", "end")
            self.config_file_5g_PATH_txt.insert(END, config_file_PATH)
            self.extract_config_button.config(state=NORMAL)
        else:
            showerror("Error", "No file selected")

        if self.is_uniconfig() == False:
            showerror("Error", "Cannot choose more than two config files!!!")

    def open_raw_log(self):
        # Test
        # global log_file_PATH
        # log_file_PATH = r'G:\PycharmProjects\Log_Extractor\Test\log_test.txt'
        log_path = askopenfilenames(initialdir=self.cur_dir, title="Select file",
                                   filetypes=(("raw log file", "*.qmdl *.dlf *.isf"), ("dlf file", "*.dlf"), ("all files", "*.*")))
        if log_path:
            global QCAT_raw_log_file_PATH
            # QCAT_raw_log_file_PATH = log_path
            for path in log_path:
                QCAT_raw_log_file_PATH.append(path)
            # print(log_path)
            self.raw_log_file_PATH_txt.delete("1.0", "end")
            self.raw_log_file_PATH_txt.insert(END, QCAT_raw_log_file_PATH)
        else:
            showerror("Error", "No file selected")

    def set_output_directory(self):
        csv_dir = askdirectory()
        if csv_dir:
            global QCAT_output_directory
            QCAT_output_directory = csv_dir
            self.QCAT_txt_dir_txt.delete("1.0", "end")
            self.QCAT_txt_dir_txt.insert(END, csv_dir)
        else:
            showerror("Error", "No directory selected")
        ##Test'
        # global csv_folder_PATH
        # csv_folder_PATH = r'C:\Users\Admin\Desktop\test'

    def change_file_name(self, log_path, exported_path):
        """Change exported file name from 'analyzer'.txt to 'log_analyser.txt'"""
        from tool_summary import is_file_exist

        if not is_file_exist(exported_path):
            return False

        if log_path.find('/'):
            split_log_path = log_path.split('/')
            log_name = split_log_path[-1].split('.')[0]  # remove file extension, Ex. '.txt'

        exported_path = exported_path.replace('\\', '/')
        if exported_path.find('/'):
            cur_dir = os.getcwd()
            short_dir = exported_path.split(cur_dir)   # Get short path from current directory
            split_exported_path = short_dir[1].split('/')
            exported_name = split_exported_path[-1]    # Get file name


        if log_name and exported_name:
            new_path = os.path.join(*split_exported_path[:-1], log_name + '_' + exported_name)
            if not is_file_exist(new_path):
                os.rename(exported_path, new_path)
            return True
        return False

    def call_extract(self):
        global QCAT_config_file_PATH
        global QCAT_log_list_brief, QCAT_log_list_full, grids

        try:
            self.log_type_txt.delete("1.0", "end")
            self.log_type_txt.insert(END, "Extracting...\n")
            lines = read_file(QCAT_config_file_PATH)
            QCAT_log_list_brief, QCAT_log_list_full, grids = read_config_log_types(lines)
            if len(QCAT_log_list_brief) != 0:
                # self.log_type_txt.delete("1.0", "end")
                self.log_type_txt.insert(END, '\n#Packets\n')
                for log in QCAT_log_list_brief:
                    self.log_type_txt.insert(END, log + '\n')

                if len(grids) != 0:
                    self.log_type_txt.insert(END, '\n#Grids\n')
                    for grid in grids.keys():
                        self.log_type_txt.insert(END, grid +'\n')
                self.log_type_txt.insert(END, "\nExtract successfully!!!\n")
                # showinfo("Respond", "Extract successfully")
            else:
                showwarning("Config Empty", "No log type found in config file. Try again!")
        except:
            # self.log_type_txt.delete("1.0", "end")
            self.log_type_txt.insert(END, "Error extracting\n")

    def call_import_txt(self):
        global QCAT_raw_log_file_PATH, QCAT_output_directory, QCAT_log_list_brief, grids
        self.log_type_txt.insert(END, "Importing! Please wait...\n")
        if QCAT_raw_log_file_PATH == '' or QCAT_output_directory == '' or len(QCAT_log_list_brief) == 0:
            self.log_type_txt.insert(END, "Error, Please check raw log path, output directory and config file\n")
        try:
            QCAT_Execute(QCAT_raw_log_file_PATH, QCAT_log_list_brief, QCAT_output_directory)

            # Export all grids according to analyzers in configuration file
            #TODO : Put import on the top
            from QCAT_Lib.QCAT_Basic import qcat_export_grids
            from tool_summary import path_to_outfile
            qcat_export_grids(QCAT_raw_log_file_PATH, grids.values(), QCAT_output_directory)
            # Change exported file name
            for grid in grids.keys():
                outfile_path = path_to_outfile(grid)
                self.change_file_name(QCAT_raw_log_file_PATH, outfile_path)

            self.log_type_txt.insert(END, "Import successful")

        except:
            self.log_type_txt.insert(END, "Error importing\n")

    # def openQCAT(self):
    #     self.newWindow = Toplevel(self.master)
    #     self.app = QCAT_Auto(self.newWindow)

    def show_instruction(self):
        pass

    def show_about(self):
        pass


class Uplink_Analysis(Frame):
    def __init__(self, master):
        Frame.__init__(self, master)
        self.master = master
        window_width = 480
        window_heigh = 230
        x_pos = (screen_width/2) - (window_width/2)
        y_pos = (screen_heigh/2) - (window_heigh/2)
        # self.master.geometry("420x200")
        self.master.geometry('%dx%d+%d+%d'%(window_width, window_heigh, x_pos, y_pos))
        self.master.title("Uplink Analysis")

        self.Auto_detect_file_input_label = Label(self.master, text='Uplink Directory')
        self.Auto_detect_file_input_label.grid(row=0, column=0, sticky=W, pady=2)
        self.Auto_detect_file_input_txt = Text(self.master, heigh=1, width=35)
        self.Auto_detect_file_input_txt.grid(row=0, column=1, pady=2, padx=2)

        self.PwCtrl_file_PATH_label = Label(self.master, text="Power Control File Path")
        self.PwCtrl_file_PATH_label.grid(row=1, column=0, sticky=W, pady=2)
        self.PwCtrl_file_PATH_txt = Text(self.master, heigh=1, width=42)
        self.PwCtrl_file_PATH_txt.grid(row=1, column=1, columnspan=2, pady=2)

        self.DCI_file_PATH_label = Label(self.master, text="DCI File Path")
        self.DCI_file_PATH_label.grid(row=2, column=0, sticky=W, pady=2)
        self.DCI_file_PATH_txt = Text(self.master, heigh=1, width=42)
        self.DCI_file_PATH_txt.grid(row=2, column=1, columnspan=2, pady=2)

        self.TxReport_file_PATH_label = Label(self.master, text="Tx Report File Path")
        self.TxReport_file_PATH_label.grid(row=3, column=0, sticky=W, pady=2)
        self.TxReport_file_PATH_txt = Text(self.master, heigh=1, width=42)
        self.TxReport_file_PATH_txt.grid(row=3, column=1, columnspan=2, pady=2)

        self.PHICH_file_PATH_label = Label(self.master, text="PHICH File Path")
        self.PHICH_file_PATH_label.grid(row=4, column=0, sticky=W, pady=2)
        self.PHICH_file_PATH_txt = Text(self.master, heigh=1, width=42)
        self.PHICH_file_PATH_txt.grid(row=4, column=1, columnspan=2, pady=2)

        self.Output_dir_label = Label(self.master, text="Output directory")
        self.Output_dir_label.grid(row=5, column=0, sticky=W, pady=2)
        self.Output_dir_txt = Text(self.master, heigh=1, width=42)
        self.Output_dir_txt.grid(row=5, column=1, columnspan=2, pady=2)

        # Button config
        self.auto_button = Button(self.master, text='Auto find', command=self.find_files)
        self.auto_button.grid(row=0, column=2, columnspan=2, sticky=E)

        self.merge_button = Button(self.master, text='Merge Table', state= DISABLED, command=self.call_merge)
        self.merge_button.config(width=10, heigh=4)
        self.merge_button.grid(row=6, column=0, columnspan=3, sticky=E)
        #Merge condition in order to press merge button
        self.merge_condition_1 = False
        self.merge_condition_2 = False
        self.merge_condition_3 = False
        self.merge_condition_4 = False




        self.menu = Menu(self.master)
        self.master.config(menu=self.menu)

        # create the file object)
        self.file = Menu(self.menu)

        # adds a command to the menu option, calling it exit, and the
        # command it runs on event is client_exit

        self.file.add_command(label="Set input dir", command=self.set_input_dir)
        self.file.add_command(label="Open Power Control file", command=self.open_PwCtrl)
        self.file.add_command(label="Open DCI file", command=self.open_DCI)
        self.file.add_command(label="Open Tx Report file", command=self.open_TxReport)
        self.file.add_command(label="Open PHICH file", command=self.open_PHICH)
        self.file.add_command(label="Set oput directory", command=self.set_dir)
        self.file.add_command(label="Exit", command=self.client_exit)
        self.menu.add_cascade(label="File", menu=self.file)
        # menu.add_cascade(label="Open config", menu=file)

        self.edit = Menu(self.menu)
        self.menu.add_cascade(label="Edit", menu=self.edit)

        self.help = Menu(self.menu)
        self.help.add_command(label="About", command=self.show_about)
        self.help.add_command(label="Instruction", command=self.show_instruction)
        self.menu.add_cascade(label="Help", menu=self.help)

    def set_input_dir(self):
        dir = askdirectory()
        if dir:
            global input_dir
            input_dir = dir
            # print(input_dir)
            self.Auto_detect_file_input_txt.delete("1.0", "end")
            self.Auto_detect_file_input_txt.insert(END, input_dir)
        else:
            showerror("Error", "No directory selected")


    def check_merge_condition(self):
        #Check if merge conditions are met, then turn the button on/off
        if self.merge_condition_1 and (self.merge_condition_2 or self.merge_condition_3 or self.merge_condition_4):
            return True
        else:
            return False


    def find_files(self):
        global input_dir, pw_ctrl_path, dci_path, tx_report_path, phich_path
        for file in os.listdir(input_dir):
            if file.endswith(".csv"):
                if file == '0xB16C.csv':
                    dci_path = os.path.join(input_dir, file)
                    self.DCI_file_PATH_txt.delete("1.0", "end")
                    self.DCI_file_PATH_txt.insert(END, dci_path)
                    self.merge_condition_2 = True
                    if self.check_merge_condition():
                        self.merge_button.config(state=NORMAL)
                elif file == '0xB139.csv':
                    tx_report_path = os.path.join(input_dir, file)
                    self.TxReport_file_PATH_txt.delete("1.0", "end")
                    self.TxReport_file_PATH_txt.insert(END, tx_report_path)
                    self.merge_condition_3 = True
                    if self.check_merge_condition():
                        self.merge_button.config(state=NORMAL)
                elif file == '0xB16E.csv':
                    pw_ctrl_path = os.path.join(input_dir, file)
                    self.PwCtrl_file_PATH_txt.delete("1.0", "end")
                    self.PwCtrl_file_PATH_txt.insert(END, pw_ctrl_path)
                    self.merge_condition_1 = True
                    if self.check_merge_condition():
                        self.merge_button.config(state=NORMAL)
                elif file == '0xB12C.csv':
                    phich_path = os.path.join(input_dir, file)
                    self.PHICH_file_PATH_txt.delete("1.0", "end")
                    self.PHICH_file_PATH_txt.insert(END, phich_path)
                    self.merge_condition_4 = True
                    if self.check_merge_condition():
                        self.merge_button.config(state=NORMAL)

    def open_PwCtrl(self):
        filename = askopenfilename(initialdir='/', title="Select file",
                                   filetypes=(("csv file", "*.csv"), ("all files", "*.*")))
        if filename:
            global pw_ctrl_path
            pw_ctrl_path = filename
            print(pw_ctrl_path)
            # self.update_text()
            self.PwCtrl_file_PATH_txt.delete("1.0", "end")
            self.PwCtrl_file_PATH_txt.insert(END, pw_ctrl_path)
            self.merge_condition_1 = True
            if self.check_merge_condition():
                self.merge_button.config(state = NORMAL)
        else:
            showerror("Error", "No file selected")

    def open_DCI(self):
        filename = askopenfilename(initialdir='/', title="Select file",
                                   filetypes=(("csv file", "*.csv"), ("all files", "*.*")))
        if filename:
            global dci_path
            dci_path = filename
            print(dci_path)
            # self.update_text()
            self.DCI_file_PATH_txt.delete("1.0", "end")
            self.DCI_file_PATH_txt.insert(END, dci_path)
            self.merge_condition_2 = True
            if self.check_merge_condition():
                self.merge_button.config(state = NORMAL)
        else:
            showerror("Error", "No file selected")

    def open_TxReport(self):
        filename = askopenfilename(initialdir='/', title="Select file",
                                   filetypes=(("csv file", "*.csv"), ("all files", "*.*")))
        if filename:
            global tx_report_path
            tx_report_path = filename
            print(tx_report_path)
            # self.update_text()
            self.TxReport_file_PATH_txt.delete("1.0", "end")
            self.TxReport_file_PATH_txt.insert(END, tx_report_path)
            self.merge_condition_3 = True
            if self.check_merge_condition():
                self.merge_button.config(state = NORMAL)
        else:
            showerror("Error", "No file selected")
    def open_PHICH(self):
        filename = askopenfilename(initialdir='/', title="Select file",
                                   filetypes=(("csv file", "*.csv"), ("all files", "*.*")))
        if filename:
            global phich_path
            phich_path = filename
            print(phich_path)
            # self.update_text()
            self.PHICH_file_PATH_txt.delete("1.0", "end")
            self.PHICH_file_PATH_txt.insert(END, phich_path)
            self.merge_condition_4 = True
            if self.check_merge_condition():
                self.merge_button.config(state = NORMAL)
        else:
            showerror("Error", "No file selected")
    def set_dir(self):
        dir = askdirectory()
        if dir:
            global output_path
            output_path = dir
            print(output_path)
            self.Output_dir_txt.delete("1.0", "end")
            self.Output_dir_txt.insert(END, output_path)
        else:
            showerror("Error", "No directory selected")

    def call_merge(self):
        global pw_ctrl_path, dci_path, tx_report_path, phich_path, output_path
        try:
            Execute(pw_ctrl_path, dci_path, tx_report_path, phich_path, output_path)
        except:
            showerror("Error", "Check files or directory")



    def client_exit(self):
        exit()
    def show_about(self):
        pass
    def show_instruction(self):
        pass


# root window created. Here, that would be the only window, but
# you can later have windows within windows.
root = Tk()
# root.geometry("300x300")
app_width = 300
app_heigh = 300
screen_width = root.winfo_screenwidth()
screen_heigh = root.winfo_screenheight()
# x = (screen_width/3) - (app_width/2)
x = 0
y = (screen_heigh/2) - (app_heigh/2)
root.geometry('%dx%d+%d+%d'%(app_width, app_heigh, x, y))
root.resizable(width=False, height=False)

# creation of an instance
app = Window(root)

# mainloop
root.mainloop()