import win32com.client
import time
try:
    from threading import Thread
    from queue import Queue, Empty
except ImportError:
    from Queue import Queue, Empty

def click_items(*arr_item, click_type = 0):

    for item in arr_item:
        item.Click(click_type)    

def select_items(*arr_item, mt, value):
    for item in arr_item:
        item.Select(SearchKey=mt, Index=value)
        # if mt in [0, 1]:
        #     item.Select(SearchKey=mt, Index=value)
        # else:
        #     item.Select(SearchKey=mt, Index=value)


class SAP_B1:
    def __init__(self):
        self.sbo_gui_api = win32com.client.Dispatch("SAPbouiCOM.SboGuiApi") 
        self.connection_string = "0030002C0030002C00530041005000420044005F00440061007400650076002C0050004C006F006D0056004900490056"
        self.sbo_application = None            

    def connect_app(self):
        self.sbo_gui_api.Connect(self.connection_string)
        self.sbo_application = self.sbo_gui_api.GetApplication(-1)

    def wait_form(self, id_form, timeout=30, poll_seconds=0.2):
        end_time = time.time() + float(timeout)
        while time.time() <= end_time:
            try:
                return self.get_form(id_form)
            except Exception:
                time.sleep(poll_seconds)
        raise Exception("Timeout waiting for SAP form '{0}'".format(id_form))

    def login_1(self, user, pwd, society=None, timeout=8):
        # Wait until login window is available before sending credentials.
        form = self.wait_form("821", timeout=timeout)
        form.Items.Item("4").Click(0)
        self.sbo_application.SendKeys(user)
        form.Items.Item("5").Click(0)
        self.sbo_application.SendKeys(pwd)
        if society:
            print("society_1")
            q = Queue()
            t = Thread(target=click_items, args=([form.Items.Item("10000103")]), daemon=False)
            t.start()
            form = self.wait_form("820", timeout=timeout)
            form.Items.Item("1470000132").Click(0)
            self.sbo_application.SendKeys(society)
            form.Items.Item("19").Click(0)
            self.sbo_application.SendKeys(user)
            form.Items.Item("20").Click(0)
            self.sbo_application.SendKeys(pwd)

        # for form_ in self.sbo_application.Forms:
        #     print(form_.Title)
        #     print(form_.UniqueID)
        #     if form_.Title == 'Mensaje sistema':
        #         break
        # for item in form_.Items:
        #     print(f'Type {item.Type}')
        #     print(f'UID {item.UniqueID}')
        #     try:
        #         print(f'Static {item.Specific.Caption}')
        #     except:
        #         pass
        #     try:
        #         print(f'EditText {item.Specific.String}')
        #     except:
        #         pass
        #     try:
        #         print(f'CB {item.Specific.ValidValues}')
        #     except:
        #         pass

        form.Items.Item("1").Click(0)

    def login_2(self, society=None):
        # This is for the case in which there is not necessary to login
        print("society_2")
        form_ = self.get_form("1570000001")
        matrix = form_.Items.Item('1570000003').Specific
        target = matrix.Columns.Item(str('1570000001')).Cells.Item(int(society))
        target.Click()
        q = Queue()
        t = Thread(target=click_items, args=([form_.Items.Item('1570000006')]), daemon=False)
        t.start()
    
    """Lines kept for future tests"""
        # for form_ in self.sbo_application.Forms:
        #     print(form_.Title)
        #     print(form_.UniqueID)
        #     if form_.Title == 'Mensaje sistema':
        #         break
        # for item in form_.Items:
        #     print(f'Type {item.Type}')
        #     print(f'UID {item.UniqueID}')
        #     try:
        #         print(f'Static {item.Specific.Caption}')
        #     except:
        #         pass
        #     try:
        #         print(f'EditText {item.Specific.String}')
        #     except:
        #         pass
        #     try:
        #         print(f'CB {item.Specific.ValidValues}')
        #     except:
        #         pass
        #     item.Click()

    def get_form(self, id_form):
        return self.sbo_application.Forms.GetForm(str(id_form), 0)
    
    def get_specific_item(self, form, item_id):
        return form.Items.Item(str(item_id)).Specific

    def get_item(self, form, item_id):
        return form.Items.Item(str(item_id))

    def do_click_grid_item(self, item, row, column, click_type):
        # item.Columns.Item(str(row)).Cells.Item(int(column)).Click(click_type)
        q = Queue()
        t = Thread(target=click_items, args=(item.Columns.Item(str(column)).Cells.Item(int(row)), click_type), daemon=False)
        t.start()
    
    def do_click_item(self, item, click_type):
        q = Queue()
        t = Thread(target=click_items, args=(item, click_type), daemon=False)
        t.start()
    
    def do_select_grid_item(self, item, row, column, method, val):
        q = Queue()
        t = Thread(target=select_items, args=(item.Columns.Item(str(column)).Cells.Item(int(row)).Specific, ), kwargs={'mt': method, 'value': val}, daemon=False)
        t.start()
    
    def do_select_item(self, item, method, val):
        q = Queue()
        t = Thread(target=select_items, args=(item, ), kwargs={'mt': method, 'value': val}, daemon=False)
        t.start()

    def activate_menu(self, id_menu):
        self.sbo_application.ActivateMenuItem(str(id_menu))
    
    def get_value(self, item, row, column):
        return item.Columns.Item(str(row)).Cells.Item(int(column)).Specific.Value


if __name__ == '__main__':
    import time
    sap_b1 = SAP_B1()
    sap_b1.connect_app()
    form = sap_b1.get_form("133")
    #data_source = form.DataSources
    data_string = sap_b1.get_item(form, "1")
    id_ = data_string.UniqueID
    print(id_)
    form.ActiveItem = id_
    #sap_b1.sbo_application.Click(0)
    #' Check a specific item ID is in focus
    item = form.Items.Item(id_)
    #item.Click(0)
    item_spec = item.Specific

    #Dim bActiveItem As Boolean = oComboBox.Active
    sap_b1.sbo_application.SendKeys("{ENTER}")
    #item_valor = data_string.Columns.Item(str("V_2")).Cells.Item(int(1))
    


