pyxl.py

import openpyxl
import PySimpleGUI as sg
from collections import OrderedDict
from numpy import argsort
import re
import csv

def csvread():
    rows = []
    try:
        with open('data_config', 'r') as csvfile:
            csvreader = csv.reader(csvfile,delimiter=':')
        
            for row in csvreader:
                if row != []:                #<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
                    rows.append(row)                             #to fix windows adding blank lines in between
            if rows != []:                   #<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
                return rows
            else:
                return None
    except:
        return None
 

def csvwrite(set_list):
    # writing to csv file
    with open('data_config', 'w') as csvfile:
        csvwriter = csv.writer(csvfile,delimiter=':')

        csvwriter.writerows(set_list)

def validip(ip):
    valid = False
    try:
        ip = ipaddress.ip_address(ip)
        valid = True
    except:
        pass
    return valid

def testwindow():
    layout = [
        [[sg.Text('This Is a Test Window')]]
    ]

    window = sg.Window('Title', layout)

    while True:
        event, values = window.read()
        if event == sg.WIN_CLOSED:
            break

    window.close()


def find_teach(data):
    teachers = []
    for blocks in data:
        teachers.append(blocks[-1][0])
    return teachers


def pref_popup(scale_old = 2.3 , theme_old = 'SandyBeach'):
    scale_ = scale_old
    theme_ = theme_old
    layout = [
        [sg.Text('Scale :'),sg.Slider((5,50), orientation='h',default_value = scale_old*10,key = 'scale')],
        [sg.Text('Theme :'),sg.Combo(sg.theme_list(),default_value = theme_old,key = 'theme')],
        [sg.Button('Ok',border_width=0,font='_ 10'),sg.Push(),sg.Button('Preview themes',border_width=0,font='_ 10'),sg.Button('Defalt',border_width=0,font='_ 10')]
    ]

    window = sg.Window('Title', layout)

    while True:
        event, values = window.read()

        if event == sg.WIN_CLOSED:
            break
        
        if event == 'Defalt':
            window['scale'].update(23)
            window['theme'].update('SandyBeach')
            
            
        if event == 'Ok':
            scale_ = values['scale']/10
            theme_ = values['theme']
            f = open("ss.config", "w")
            f.write(f'{scale_},{theme_}')
            f.close()
            window.close()
            
        if event == 'Preview themes':
            sg.theme_previewer(4,scrollable = True)
            

            
    window.close()
    return(scale_,theme_)


def test_data(data,chunk=False):
    for i in data:
        if chunk == False:
            for j in i:
                    print(j)
            print('#####################')
        else:
            print(i)
    print('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$')



def remove_non_alphanumeric(text):
  return re.sub(r'[^A-Za-z0-9 ]+', '', text)

def read_data(exel_file_path):
    data = []
    error = None
    dataframe = openpyxl.load_workbook(exel_file_path)
    for sheet in dataframe.worksheets:
    #    print(str(sheet)[12:-2])
        array = []
        cell = sheet['B4':'F11']
        try:
            teacher = sheet["A2"].value
            department = sheet["A1"].value
            department = department.split(':')[-1].strip()
        
            for i in cell:
                x = []
                for j in i:
                    j = j.value
                    if j:
                        j = j.replace(" ", "").upper()
                    x.append(j)
                array.append(x)

            teacher = remove_non_alphanumeric(teacher).title()


            array.append([teacher,department])
            data.append(array)
        except:
            error = 'Error while reading: \n\n'+str(sheet)[12:-2]+'\n of file '+exel_file_path+'\n\nPlease check the format'+'\n\n The program will exit now.'
        
    return(data,error)




def format_list_out(name1,tclass=' ',freeprd = ' '):

    name1 = str(name1)
    tclass = str(tclass)

    if len(name1) < 30:
        name1 += ' '*(30-len(name1))   #If less than 5 fill

    name1 = name1[0:30]              #If more that 25 cut off


    if len(tclass) < 5:
        tclass += ' '*(5-len(tclass))  

    tclass = tclass[0:5]               #If more that 5 cut off

    return(f'{name1}: {tclass}: {freeprd}')      # 18:7:...          #27 char total (minimum size)       defalt
        

def unformat_list(mylist):
    out = []
    for i in mylist:
        out.append(i.split(":")[0].strip())
    return(out)

def strike(text):
    return ''.join([u'\u0336{}'.format(c) for c in text])

def is_free(data,prd,day,dep_req,exec_class = [],exec_teach_raw = {}):    #exec_teach format = {abc:[0,0,1,0,0],xzy:[1,1,0,0,0] ...}
    out = {}
    out_busy = {}
    
    exec_teach = []

    for i in exec_teach_raw:
        if exec_teach_raw[i][day] == 1:
            exec_teach.append(i)

    print(exec_teach)
            
    for array in data:
        class_sel = array[prd-1][day]
        if class_sel:
            class_sel = class_sel.upper()
        teacher = array[-1][0]
        department = array[-1][1]
        z = find_free_periods_num(data,day,teacher,exec_class)[0]
        if array[prd-1][day] == None:
            if dep_req == department or dep_req == 'All':
                if teacher not in exec_teach:
                    out.update({format_list_out(teacher,"Free",z):z})
                else:
                    out_busy.update({format_list_out(teacher+"(✘)","Free",z):z})
        else: 

            if dep_req == department or dep_req == 'All':

                if class_sel not in exec_class:
                    
                    if teacher not in exec_teach:
                        out_busy.update({format_list_out(teacher,class_sel,z):z})
                    else:
                        out_busy.update({format_list_out(teacher+"(✘)",class_sel,z):z})

                else:

                    if teacher not in exec_teach:
                        out.update({format_list_out(teacher,class_sel+"(✘)",z):z})
                    else:
                        out_busy.update({format_list_out(teacher+"(✘)",class_sel+"(✘)",z):z})
                    



    keys = list(out.keys())
    values = list(out.values())
    sorted_value_index = argsort(values)[::-1]
    sorted_dict_free = {keys[i]: values[i] for i in sorted_value_index}

    keys1 = list(out_busy.keys())
    values1 = list(out_busy.values())
    sorted_value_index1 = argsort(values1)[::-1]
    sorted_dict_busy = {keys1[i]: values1[i] for i in sorted_value_index1}   

    return(sorted_dict_free,sorted_dict_busy)



def find_departments(data,withteach=False):
    out = set()
    for array in data:
        if withteach:
            out.add(tuple(array[-1]))
        else:
            out.add(array[-1][1])
    return(list(out))
    
    
    
def find_free_periods_num(data,day,teacher,exec_class=[]):
    tt = []
    counter = 0
    for i in data:
        if i[-1][0] == teacher:        #last row of data , first coulm (name)
            for j in i[0:-1]:           #to remove name from the timetable while looking for free prd
                if j[day] not in exec_class:
                    tt.append(j[day])
                else:
                    tt.append(strike(f'{j[day]} '))
            break
    for i in tt:
        if i == None or i in exec_class:
            counter += 1
    return(counter,tt)
            


import re                                                                           #
def natural_sort(l):                                                                 #
    convert = lambda text: int(text) if text.isdigit() else text.lower()             # Natural sort function
    alphanum_key = lambda key: [convert(c) for c in re.split('([0-9]+)', key)]       # idk how but it just works
    return sorted(l, key=alphanum_key)                                               # https://t.ly/JLUU stackoverflow copied code
                                                                                    #

def find_classes(data):
    cls_found = []              # to look at output not error
    for i in data:
        for j in i[0:-1]:
            for k in j:      #to remove name from the timetable
                if k != None:
                    if k not in cls_found:               # to add only if not already present
                        cls_found.append(k)

    return(natural_sort(cls_found))

def rotate(l):
    out = []
    for i in range(len(l[0])) :
        temp = []
        for j in range(len(l)):
            temp.append(l[j][i])
        out.append(temp)

    return(out)