def returnlistfileinfolder(self):
""" return list file in folder"""
pathtocopy = getpathfromtk(self.output1)
lfilecopy = listfileinfolder(pathtocopy)
lfileafterfilter = filterlistbylstr (criteria=[".gif",".jpg"],
liststr=lfilecopy)
return lfileafterfilter
def ft_tool(self):
lfuns = filterlistbylstr(liststr=list(self.__dictconf.keys()),
criteria_is_not=True,
criteria=["sub_"],
upper=False)
mydictfun = {
"transfertoparent": (lambda: self.__transfertoparent()),
"transfertoparents": (lambda: self.__transfertoparents())
}
if self.__fuction == "config":
for lfun in lfuns:
mydictfun[lfun]()
else:
mydictfun[self.__fuction]()
def ft_tool(self):
lfuns = filterlistbylstr(liststr=list(self.__dictconf.keys()),
criteria_is_not=True,
criteria=["sub_"],
upper=False)
mydictfun = {
"copy_from_tem": (lambda: self.__copy_from_tem()),
}
if self.__fuction == "config":
for lfun in lfuns:
mydictfun[lfun]()
else:
mydictfun[self.__fuction]()
def __init__(self,
lpath_excel=[],
pathconf=None,
fuction=None,
path_exell_tem=None):
self.__path_exell_tem = path_exell_tem
self.__lpath_excel = lpath_excel
self.__fuction = fuction.lower()
self.__pathconf = pathconf
self.__dictconf = dict_from_csv2col(pathconf)
self.lfuns = filterlistbylstr(liststr=list(self.__dictconf.keys()),
criteria_is_not=True,
criteria=["sub_"],
upper=False)
def mfolderopenchild(self):
""" open folder of child files"""
try:
closeallfileexcel(namek_ofpname="AZB")
except:
pass
self.output1.delete(0, 'end')
# ask directory
files = filedialog.askdirectory(title="Directory of child files",
initialdir=self.output1.get())
self.output1.insert(tk.END, files)
# get path from entry
self.pathin = getpathfromtk(self.output1)
try:
self.scf.destroy()
except:
pass
self.scf = scrollbarvn(parent=self.frameb, bg="white")
self.scframe = self.scf.frame
if self.pathin:
# return list in folder
fpexcel = listfileinfolder(self.pathin)
# filter file in folder
plist = filterlistbylstr(criteria=["AZB"], liststr=fpexcel)
# return list path excel sheeet
lpsheet = [
refullpath(dirpath=self.pathin, filename=fpname)
for fpname in plist
]
# return list sheet excel
lsexcel = listexcel(l_ex=lpsheet).returnlsheet()
# create check list box
self.cb = ChecklistBox(parent=self.scframe,
choices=plist,
listsheetname=lsexcel,
width=123)
def guiforgd(self):
"""Create interface for software"""
gui(tktk=self.root,
pathico=None,
width=700,
height=420,
widthx=420,
widthy=0,
resizable=[True, True],
title="FAPP").setcfbs()
self.sc = scbg(
parent=self.root,
cavheight=250,
cavwidth=365,
isonlyaframe=False,
bg="#e6ecf5",
bgpr="#5b9bd5",
framea=[0, 0, 365, 250, "#e6ecf5"],
)
large_font = ("times new roman", 12)
large_font_1 = ("times new roman", 17)
lb = tk.Label(self.root,
text="Mr.Nhuần - [email protected]",
font=large_font,
bg="#5b9bd5")
lb.place(relx=0.5, rely=0.87, anchor=tk.CENTER)
self.framea = self.sc.framea
lbt = tk.Label(
self.framea,
bg="#e6ecf5",
fg="black",
text="Input your information",
font=large_font_1,
)
lbt.grid(row=0, column=0, columnspan=6, sticky=tk.EW)
# path to folder child
repath = tk.Label(
self.framea,
text="Retrieve Path:",
width=10,
font=large_font,
bg="#e6ecf5",
)
repath.grid(row=1, column=0, sticky=tk.W, padx=(5, 0))
self.output1 = tk.Entry(
self.framea,
font=large_font,
justify=tk.CENTER,
width=20,
relief=tk.SOLID,
bg="yellow",
)
self.output1.grid(row=2, column=0, padx=(5, 0))
button = tk.Button(self.framea,
height=1,
width=2,
bd=1,
command=lambda: self.mfileopend(
outputtk=self.output1, combopc=self.combopc))
button.grid(row=2, column=1, sticky="we")
lsheets = None
self.pc = tk.StringVar()
self.combopc = ttk.Combobox(
self.framea,
textvariable=self.pc,
width=20,
values=["Active Sheet", "Select Sheet Name"],
state="readonly",
justify='center')
self.combopc.grid(column=2, row=2, padx=(10, 0))
self.combopc.bind("<<ComboboxSelected>>", self.selected_rev)
self.combopc.current(1)
# destination
repathdes = tk.Label(
self.framea,
text="Destination Path:",
font=large_font,
bg="#e6ecf5",
)
repathdes.grid(row=3, column=0, sticky=tk.W, pady=(5, 0), padx=(5, 0))
self.repathdes = tk.Entry(
self.framea,
font=large_font,
justify=tk.CENTER,
relief=tk.SOLID,
bg="yellow",
)
self.repathdes.grid(row=4, column=0, sticky=tk.EW, padx=(5, 0))
buttondes = tk.Button(
self.framea,
height=1,
width=4,
bd=1,
command=lambda: self.mfileopend(outputtk=self.repathdes,
combopc=self.combo_des))
buttondes.grid(row=4, column=1, sticky="we")
self.pc_des = tk.StringVar()
self.combo_des = ttk.Combobox(
self.framea,
textvariable=self.pc_des,
width=15,
values=["Active Sheet", "Select Sheet Name"],
state="readonly",
justify='center')
self.combo_des.grid(column=2, row=4, sticky=tk.EW, padx=(10, 0))
self.combo_des.current(1)
self.combo_des.bind("<<ComboboxSelected>>", self.selected_des)
func = tk.Label(
self.framea,
text="Function Excel:",
font=large_font,
bg="#e6ecf5",
)
func.grid(row=5, column=0, sticky=tk.W, padx=(5, 0))
self.pc_fun = tk.StringVar()
lfun = ["Select Function In Excel"] + filterlistbylstr(
liststr=list(returndictrowforcsv(self.pathconfig).keys()),
criteria_is_not=True,
criteria=["sub_"],
upper=True)
self.combo_fun = ttk.Combobox(self.framea,
textvariable=self.pc_fun,
width=15,
values=lfun,
state="readonly",
justify='center')
self.combo_fun.grid(column=0,
row=6,
columnspan=3,
sticky=tk.EW,
padx=(5, 0))
self.combo_fun.current(0)
self.combo_fun.bind("<<ComboboxSelected>>", self.selected_des)
button_open = tk.Button(
self.framea,
height=1,
width=8,
text="Open_Conf",
bd=1,
command=lambda: openexcelbyxl(self.pathconfigexell))
button_open.grid(row=7, column=0, sticky="w", padx=(5, 0))
button_conf = tk.Button(
self.framea,
height=1,
width=8,
text="Up_Conf",
bd=1,
command=lambda: hconfazb(pathconf=self.pathconfig,
pathexconf=self.pathconfigexell
).convertocsv())
button_conf.grid(row=7, column=2, sticky="e")
run = tk.Button(self.framea,
height=1,
width=4,
text="Run",
bd=1,
command=lambda: fformulas(
retr_path=getpathfromtk(
self.output1, Warning_path_existing=False),
des_path=getpathfromtk(
self.repathdes, Warning_path_existing=False),
retr_sheetname=self.pc.get(),
des_sheetname=self.pc_des.get(),
fuction=self.pc_fun.get(),
pathconf=self.pathconfig).filltoexcell())
run.grid(row=9, column=1, sticky="e")
run = tk.Button(self.framea,
height=1,
width=4,
text="Quit",
bd=1,
command=self.root.quit)
run.grid(row=10, column=1, sticky="e")
