JD4

from __future__ import print_function
import pandas as pd
from mailmerge import MailMerge
from datetime import date
import os
# importing everything from tkinter
from tkinter import *
from tkinter import scrolledtext
from docx import Document

# create gui window
Main_window = Tk()

# set the configuration
# of the window
w = 400 # width for the Tk root
h = 200 # height for the Tk root

# get screen width and height
ws = Main_window.winfo_screenwidth() # width of the screen
hs = Main_window.winfo_screenheight() # height of the screen

# calculate x and y coordinates for the Tk root window
x = (ws/2) - (w/2)
y = (hs/2) - (h/2)

# set the dimensions of the screen
# and where it is placed
Main_window.geometry('%dx%d+%d+%d' % (w, h, x, y))
Main_window.resizable(0, 0)
#my_label = Label(Main_window,
#                 text = "geeksforgeeks")

jd_out_path = './Finished JDs'
temp_jd_out_path = './Finished JDs/temp'

try:
    os.mkdir(jd_out_path) #create JD out directory
    os.mkdir(temp_jd_out_path) #create JD out directory
except:
    print("JD directory already exists")

template_1 = "jd_template.docx"
label_text="...."

textw = scrolledtext.ScrolledText(Main_window,width=47,height=12)
textw.grid(column=1, row=2,sticky=N+S+E+W)


Main_window.title("JD Maker 1.0 - MTO")

# Show a simple example
csv_path = 'jd.csv'


from docx import Document

def delete_bullet_points(file, text_to_delete):
    # Load the document
    doc = Document(temp_jd_out_path + "/" + file)

    for table in doc.tables:
        for row in table.rows:
            for cell in row.cells:
                for paragraph in cell.paragraphs:
                    if text_to_delete in paragraph.text:
                         paragraph.text = ''
                         p = paragraph._element
                         p.getparent().remove(p)
    # Save the document with the changes
    doc.save(jd_out_path + "/" + file)



def Fill_JD():
    Main_window.update_idletasks()
    try:
        # do something

        df= pd.read_csv(csv_path)
        data=df.to_dict('records')

        #convert to str

        list_delim, tuple_delim = '-', '^'
        for item in data:
            res = dict()
            for sub in item:
                # checking data types
                if isinstance(item[sub], list):
                    res[sub] = list_delim.join([str(ele) for ele in item[sub]])
                elif isinstance(item[sub], tuple):
                    res[sub] = tuple_delim.join(list([str(ele) for ele in item[sub]]))
                else:
                    res[sub] = str(item[sub])
            item = res
            # --- end convert to str ---
            document_1 = MailMerge(template_1)
            document_1.merge(**res)

        #for item in data:
            #print(item)
            #print("ITEM: ")
            #print(item['name_english'])
            label_text = "Now processing JD for: " + item['name_english']
            textw.insert(END, label_text)
            Main_window.update_idletasks()

            try:
                csv2_path =  item['name_english'] + '.csv'
                #df2=pd.read_csv(csv2_path)

                jd_tasks= pd.read_csv(csv2_path).to_dict('records')

                for k in jd_tasks:
                    k['job_task_marks'] = str(k['job_task_marks'])

                document_1.merge_rows('job_task_marks', jd_tasks)
                # Save the document as example 1
                document_1.write(temp_jd_out_path + "/" +  item['name_english'] + '_jd.docx')
                textw.insert(END, " -->(Done)\n")

                #Clean Up Document
                # Example usage
                file = item['name_english'] + '_jd.docx'
                line_to_delete = 'nan'
                delete_bullet_points(file, line_to_delete)

            except Exception as e:
                textw.insert(END, " -->(Error)\n")
    except Exception as e:
        # handle it
        raise Exception("Kommis kamah nibei vege. " + str(e))
        textw.insert(END, " -->(Error)\n")


Fill_JD()
Main_window.mainloop()