python基於Tkinter實現人員管理系統

from tkinter import *
from tkinter.messagebox import *
from tkinter import ttk
import pymongo
import tkinter as tk
import re
import time
import datetime

import pandas as pd
from tkinter import filedialog
from PIL import ImageTk,Image
import tkinter

#連接數據庫
client = pymongo.MongoClient(host="localhost", port=27017)
db = client.sys
col = db.user
#創建窗口
root = Tk()
root.geometry('900x700')
root.title('人員管理系統')
#表頭
img =Image.open(r'C:\Users\apple\Desktop\image.jpg')
img = img.resize((900,68),Image.ANTIALIAS)
img = ImageTk.PhotoImage(img)
top=Label(root, text='人員管理系統',image=img,fg='black',font=('楷體', 20),compound='center', bitmap='error')
top.pack(ipady=0,side=TOP, fill='x')
#變量
sid = StringVar()
name = StringVar()
age = StringVar()
salary = StringVar()
phone = StringVar()
birthday = StringVar()


#控制函數

def add():
    global info
    info=Toplevel()
    info.title("添加信息")
    info.geometry('400x400') 
    button1=Button(info, text="確認",command=appendInfo,font=("黑體", 12)).place(relx=0.4, rely=0.8, width=100)
    Label(info, text="工號：").place(relx=0.2, rely=0.1, relwidth=0.1)
    Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
    Label(info, text="年齡：").place(relx=0.2, rely=0.3, relwidth=0.1)
    Label(info, text="薪資：").place(relx=0.2, rely=0.4, relwidth=0.1)
    Label(info, text="電話：").place(relx=0.2, rely=0.5, relwidth=0.1)
    Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
    text1=Entry(info, textvariable=sid).place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
    sid.set("")
    text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
    name.set("")
    text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
    age.set("")
    text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
    salary.set("")
    text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
    phone.set("")
    text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
    birthday.set("")
    info.bind('<Return>',pas8)
#     info.bind_all('<KeyPress-Up>',movetriangle)
#     info.bind_all('<KeyPress-Down>',movetriangle)
#     info.bind_all('<KeyPress-Left>',movetriangle)
#     .bind_all('<KeyPress-Right>',movetriangle)
    
    
def pitch_on():
    global info
    info=Toplevel()
    info.title("刪除信息")
    info.geometry('400x400')
    Label(info, text="是否確定刪除以下信息",font=('楷體', 15)).place(relx=0.2, rely=0.01, relwidth=0.6)
    Label(info, text="工號：").place(relx=0.2, rely=0.1, relwidth=0.1)
    Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
    Label(info, text="年齡：").place(relx=0.2, rely=0.3, relwidth=0.1)
    Label(info, text="薪資：").place(relx=0.2, rely=0.4, relwidth=0.1)
    Label(info, text="電話：").place(relx=0.2, rely=0.5, relwidth=0.1)
    Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
    text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
    sid.set(sf[0])
    text2=Entry(info, textvariable=name,state='disable').place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
    name.set(sf[1])
    text3=Entry(info, textvariable=age,state='disable').place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
    age.set(sf[2])
    text4=Entry(info, textvariable=salary,state='disable').place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
    salary.set(sf[3])
    text5=Entry(info, textvariable=phone,state='disable').place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
    phone.set(sf[4])
    text6=Entry(info, textvariable=birthday,state='disable').place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
    birthday.set(sf[5])
    button1=Button(info, text="確認",command=deleteInfo).place(relx=0.2, rely=0.8, width=100)
    button2=Button(info, text="關閉",command=des).place(relx=0.6, rely=0.8, width=100)
    info.bind('<Return>',pas33)
    
def information2():
    global info
    info=Toplevel()
    info.title("詳細信息")
    info.geometry('400x400') 
    button1=Button(info, text="更新信息",command=updateInfo).place(relx=0.4, rely=0.8, width=100)
    Label(info, text="工號：").place(relx=0.2, rely=0.1, relwidth=0.1)
    Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
    Label(info, text="年齡：").place(relx=0.2, rely=0.3, relwidth=0.1)
    Label(info, text="薪資：").place(relx=0.2, rely=0.4, relwidth=0.1)
    Label(info, text="電話：").place(relx=0.2, rely=0.5, relwidth=0.1)
    Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
    text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
    sid.set(sf[0])
    text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
    name.set(sf[1])
    text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
    age.set(sf[2])
    text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
    salary.set(sf[3])
    text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
    phone.set(sf[4])
    text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
    birthday.set(sf[5])
    info.bind('<Return>',pas11)
    
    

def des():
    info.destroy()
    
def information(event):
    item=dataTreeview.selection()
    itemvalues=dataTreeview.item(item,'values')
    global info
    info=Toplevel()
    info.title("詳細信息")
    info.geometry('400x400') 
    button1=Button(info, text="更新信息",command=updateInfo).place(relx=0.4, rely=0.8, width=100)

    Label(info, text="工號：").place(relx=0.2, rely=0.1, relwidth=0.1)
    Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
    Label(info, text="年齡：").place(relx=0.2, rely=0.3, relwidth=0.1)
    Label(info, text="薪資：").place(relx=0.2, rely=0.4, relwidth=0.1)
    Label(info, text="電話：").place(relx=0.2, rely=0.5, relwidth=0.1)
    Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
    text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
    sid.set(itemvalues[0])
    text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
    name.set(itemvalues[1])
    text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
    age.set(itemvalues[2])
    text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
    salary.set(itemvalues[3])
    text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
    phone.set(itemvalues[4])
    text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
    birthday.set(itemvalues[5])
    
def isVaildDate(date):
        try:
            time.strptime(date, "%Y-%m-%d")
            return True
        except:
            return False 
        
def showAllInfo():
    x = dataTreeview.get_children()
    for item in x:
        dataTreeview.delete(item)
    lst=col.find({},{'_id':0})
    for item in lst:
        i=list(item.values())
        dataTreeview.insert("", 1, text="line1", values=i)
def pas1(self):
    showAllInfo()
    
def pas2(self):
    add()
    
def pas3(self):
    pitch_on()

def pas33(self):
    deleteInfo()
    
def pas4(self):
    information2()
    
def pas5(self):
    searchInfo()

def pas55(self):
    search()
    
def pas6(self):
    impInfo()
    
def pas7(self):
    exp()
    
def pas8(self):
    appendInfo()
    
def pas9(self):
    global sf
    sf=dataTreeview.selection()
    sf=dataTreeview.item(sf,'values')
    
def pas10(self):
    expInfo()
    
def pas11(self):
    updateInfo()
    
      
def appendInfo():
    flag=1
    if sid.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if sid.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        sid.set("")
        flag=0
        
    if name.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
        
    if age.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if age.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        age.set("")
        flag=0
    
    if salary.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if salary.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        salary.set("")
        flag=0
        
    if phone.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if phone.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        phone.set("")
        flag=0
    
    if birthday.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if isVaildDate(str(birthday.get())) == False:
        showerror(title='提示', message='格式錯誤')
        birthday.set("")
        flag=0
    if flag==1:
        x = dataTreeview.get_children()
        for item in x:
            dataTreeview.delete(item)
        list1 = {
                "work_number":sid.get(),
                "name":name.get(),
                "age":age.get(),
                "salary":salary.get(),
                "phone":phone.get(),
                "birthday":birthday.get()
            }
        col.insert_one(list1)
        lst=col.find({},{'_id':0})
        for item in lst:
            i=list(item.values())
            dataTreeview.insert("", 1, text="line1", values=i)
        info.destroy()


def deleteInfo():
    lst=list(col.find({},{'_id':0}))
    num = sid.get()
    flag = 0
    for i in range(len(lst)):
        if str(num)==str(lst[i].get("work_number")):
            flag = 1
            col.delete_one({'work_number':num})
            break
 
    x = dataTreeview.get_children()
    for item in x:
        dataTreeview.delete(item)
 
    lst=col.find({},{'_id':0})
    for item in lst:
        i=list(item.values())
        dataTreeview.insert("", 1, text="line1", values=i)
    info.destroy()
        
#更新操作
def updateInfo():
    sid_1 = sid.get()
    name_1 = name.get()
    age_1 = age.get()
    salary_1 = salary.get()
    phone_1 = phone.get()
    birthday_1 = birthday.get()
    flag=1
    if sid.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if sid.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        sid.set("")
        flag=0
        
    if name.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
        
    if age.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if age.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        age.set("")
        flag=0
    
    if salary.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if salary.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        salary.set("")
        flag=0
        
    if phone.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if phone.get().isdigit() == False:
        showerror(title='提示', message='格式錯誤')
        phone.set("")
        flag=0
    
    if birthday.get() == "":
        showerror(title='提示', message='輸入不能為空')
        flag=0
    if isVaildDate(str(birthday.get())) == False:
        showerror(title='提示', message='格式錯誤')
        birthday.set("")
        flag=0
    if flag==1:
        up={
            "work_number":sid_1,
            "name":name_1,
            "age":age_1,
            "salary":salary_1,
            "phone":phone_1,
            "birthday":birthday_1
        }

        old=col.find_one({'work_number': sid_1},{"_id": 0})
        col.update_one(old, {'$set':up})
        x = dataTreeview.get_children()
        for item in x:
            dataTreeview.delete(item)
        lst=col.find({},{'_id':0})
        for item in lst:
            i=list(item.values())
            dataTreeview.insert("", 1, text="line1", values=i)
        showinfo(title='提示', message='更新成功！')
        des()
    
    
#搜索頁面
def search():
    global info
    info=Toplevel()
    info.title("搜索信息")
    info.geometry('400x400')
    button1=Button(info, text="確認搜索",command=searchInfo).place(relx=0.4, rely=0.8, width=100)
    Label(info, text="工號：").place(relx=0.2, rely=0.1, relwidth=0.1)
    Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
    Label(info, text="年齡：").place(relx=0.2, rely=0.3, relwidth=0.1)
    Label(info, text="薪資：").place(relx=0.2, rely=0.4, relwidth=0.1)
    Label(info, text="電話：").place(relx=0.2, rely=0.5, relwidth=0.1)
    Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
    text1=Entry(info, textvariable=sid).place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
    sid.set("")
    text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
    name.set("")
    text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
    age.set("")
    text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
    salary.set("")
    text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
    phone.set("")
    text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
    birthday.set("")
    info.bind('<Return>',pas5)
#搜索操作    
def searchInfo():
    lst=list(col.find({},{'_id':0}))
    sid_1 = sid.get()
    name_1 = name.get()
    age_1 = age.get()
    salary_1 = salary.get()
    phone_1 = phone.get()
    birthday_1 = birthday.get()
    flag=1
#     if sid.get().isdigit() == False:
# #         showerror(title='提示', message='格式錯誤')
#         sid.set("")
#         flag=0
#     if age.get().isdigit() == False:
# #         showerror(title='提示', message='格式錯誤')
#         age.set("")
#         flag=0
#     if salary.get().isdigit() == False:
# #         showerror(title='提示', message='格式錯誤')
#         salary.set("")
#         flag=0
        
#     if phone.get().isdigit() == False:
# #         showerror(title='提示', message='格式錯誤')
#         phone.set("")
#         flag=0
#     if isVaildDate(str(birthday.get())) == False:
# #         showerror(title='提示', message='格式錯誤')
#         birthday.set("")
#         flag=0
#     if flag==0:
#         showerror(title='提示', message='格式錯誤')
    if flag==1:
        fla = 0
        v=[]
        for i in range(len(lst)):
            if sid_1==str(lst[i].get("work_number")):
                fla = 1
                v.append(lst[i].values())
                continue
            elif name_1==lst[i].get("name"):
                fla = 1
                v.append(lst[i].values())
                continue
            elif age_1==lst[i].get("age"):
                fla = 1
                v.append(lst[i].values())
                continue
            elif salary_1==lst[i].get("salary"):
                fla= 1
                v.append(lst[i].values())
                continue
            elif phone_1==lst[i].get("phone"):
                fla = 1
                v.append(lst[i].values())
                continue
            elif birthday_1==lst[i].get("birthday"):
                fla= 1
                v.append(lst[i].values())
                continue
        if fla == 0:
            showerror(title='提示', message='無此信息，搜索失敗！')
        x = dataTreeview.get_children()
        for item in x:
            dataTreeview.delete(item)
        for i in v:
            dataTreeview.insert("", 1, text="line1", values=list(i))
        des()
        
def impInfo():
    root1 = Tk()
    root1.withdraw()
    Folderpath = filedialog.askdirectory() #獲得選擇好的文件夾
    Filepath = filedialog.askopenfilename() #獲得選擇好的文件
    data=pd.read_csv(Filepath)
    
    for i in range(len(data.values)):
        j=list(data.values[i])
        lst=col.find({},{'_id':0})
        flag=0
        for item in lst:
            i=list(item.values())
            if str(j[0])== str(i[0]):
                flag=1
                break
        if flag==0:
            list1 = {
                    "work_number":str(j[0]),
                    "name":j[1],
                    "age":j[2],
                    "salary":j[3],
                    "phone":j[4],
                    "birthday":j[5]
                }
            col.insert_one(list1)
    showinfo(title='提示', message='導入成功，可刷新！')
    
    x = dataTreeview.get_children()
    for item in x:
        dataTreeview.delete(item)
    lst=col.find({},{'_id':0})
    for item in lst:
        i=list(item.values())
        dataTreeview.insert("", 1, text="line1", values=i)

def xFunc(event):
    a=xVariable.get()  
    
def exp():
    global info
    info=Toplevel()
    info.title("保存信息")
    info.geometry('500x200')
    button1=Button(info, text="確認備份",command=expInfo).place(relx=0.4, rely=0.8, width=100)
    Label(info, text="路徑：",font=("黑體", 10)).place(relx=0.05, rely=0.2, relwidth=0.2)
    button2=Button(info, text="選擇本地",command=selection).place(relx=0.8, rely=0.2, width=70)
    Label(info, text="文件名：",font=("黑體", 10)).place(relx=0.05, rely=0.4, relwidth=0.2)
    com = ttk.Combobox(info, textvariable=xVariable)
    com.place(relx=0.8, rely=0.4, width=70)
    com["value"] = (".csv", ".html", ".xlsx",".xls")    # #給下拉菜單設定值
    com.current(2)
    com.bind("<<ComboboxSelected>>", xFunc)     # #給下拉菜單綁定事件
    text1=Entry(info, textvariable=path).place(relx=0.25, rely=0.2, relwidth=0.5, height=25)
    text2=Entry(info, textvariable=file_name).place(relx=0.25, rely=0.4, relwidth=0.5, height=25)
    info.bind('<Return>',pas10)
    

def selection():
    root2 = Tk()
    root2.withdraw()
    Folderpath = filedialog.askdirectory() #獲得選擇好的文件夾
    path.set(str(Folderpath))
    
def expInfo():
    lst=col.find({},{'_id':0})
    df =  pd.DataFrame(list(lst))
    ftp=xVariable.get() 
    file = path.get()+'/'+file_name.get()+xVariable.get()  
    print(file)
    if ftp=='.csv':
        df.to_csv(file,index=False,header=True)
    elif ftp=='.xlsx':
        df.to_excel(file,index=False,header=True)
    elif ftp=='.xls':
        df.to_excel(file,index=False,header=True)
    elif ftp=='.html':
        df.to_html(file,index=False,header=True)
    showinfo(title='提示', message='備份成功！')
    des()
    

path = StringVar()
file_name = StringVar()
xVariable = tkinter.StringVar()
#頁面佈局             
Button(root, text="刷新信息",command=showAllInfo,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.15, width=120,height=50)
root.bind('<F3>',pas1)
Button(root, text="添加信息",command=add,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.25, width=120,height=50)
root.bind('<F4>',pas2)
Button(root, text="刪除信息",command=pitch_on,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.35, width=120,height=50)
root.bind('<BackSpace>',pas3)
Button(root, text="更新信息",command=information2,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.45, width=120,height=50)
root.bind('<Control-A>',pas4)
Button(root, text="搜索信息",command=search,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.55, width=120,height=50)
root.bind('<Control-S>',pas55)
Button(root, text="導入數據",command=impInfo,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.65, width=120,height=50)
root.bind('<Control-D>',pas6)
Button(root, text="導出數據",command=exp,font=("黑體", 12),relief="raised", bd=7).place(relx=0.03, rely=0.75, width=120,height=50)
root.bind('<Control-W>',pas7)
 
dataTreeview = ttk.Treeview(root, show='headings',height=20, column=('sid', 'name', 'age','salary','phone','birthday'))
dataTreeview.column('sid', width=10, anchor="center")
dataTreeview.column('name', width=10, anchor="center")
dataTreeview.column('age', width=10, anchor="center")
dataTreeview.column('salary', width=10, anchor="center")
dataTreeview.column('phone', width=10, anchor="center")
dataTreeview.column('birthday', width=10, anchor="center")
style_value = ttk.Style()
style_value.configure("dataTreeview", rowheight=20, font=("微軟雅黑", 30))
dataTreeview.tag_configure('tag_odd',background="red",foreground="blue")
dataTreeview.tag_configure('tag_even',background="black",foreground="orange")
scrollBar=Scrollbar(width=20)
scrollBar.pack(side=RIGHT,fill=Y)
scrollBar.config(command=dataTreeview.yview)

 
dataTreeview.heading('sid', text='工號')
dataTreeview.heading('name', text='姓名')
dataTreeview.heading('age', text='年齡')
dataTreeview.heading('salary', text='薪水')
dataTreeview.heading('phone', text='電話')
dataTreeview.heading('birthday', text='生日')
dataTreeview.bind('<Double-Button-1>',information)
dataTreeview.bind('<ButtonRelease-1>',pas9)
x = dataTreeview.get_children()
for item in x:
    dataTreeview.delete(item)
lst=col.find({},{'_id':0})
for item in lst:
    i=list(item.values())
    dataTreeview.insert("", 1, text="line1", values=i)
dataTreeview.place(relx=0.2,rely=0.1, relwidth=0.78,relheight=20)

root.mainloop()