import datetime
import json
import os
import random
import tkinter as tk
import openpyxl

# 花名冊文件名
excel_file_path = "花名冊.xlsx"#需在當前目錄創建對應花名冊.xlsx
# 工作表名
excel_sheet = "Sheet1"
# 記錄存儲文件名
file_path = "name_record.json"

#封裝業務邏輯
class Call_Name:
 # 私有化變量
 _namelist = None
 # 讀取花名冊
 def __init__(self):
  wb = openpyxl.load_workbook(excel_file_path)
  get_sheet = wb[excel_sheet]
  list_data = []
  first_row = True
  try:
   for row in get_sheet:
    # 忽略首行
    if first_row:
     first_row = False
     continue
    # 讀取第一個單元格數據
    for lab in row:
     list_data.append(lab.value)
     break
  except:
   list_data = ['空名單？']
  self._namelist = list_data

 # 初始化記錄
 def _re_reset(self):
  # 記錄使用日期
  dls = []
  dy = str(datetime.datetime.today().date())
  dls.append(dy)
  # 記錄點名
  record = {}
  for i in self._namelist:
   record[i] = 0
  name_record = {"date": dls, "last_use": dy, "record": record}
  return name_record

 # 創建記錄
 def mk_record(self):
  jf_dict = self._re_reset()
  with open(file=file_path, mode='w', encoding='utf-8') as jf:
   json.dump(jf_dict, jf, indent=2, sort_keys=True, ensure_ascii=False)

 # 讀取記錄
 def read_record(self):
  with open(file=file_path, mode='r', encoding='utf-8') as jf:
   jf_data = json.load(jf)
  return jf_data

 # 產生隨機姓名
 def call_name(self):
  ll = len(self._namelist)
  num = random.randint(1, ll)
  call_name = self._namelist[num - 1]
  return call_name

 # 修改記錄-----warning!!!
 def re_mod(self, name=None, re_date=None):
  jf_data = self.read_record()
  record = jf_data["record"]
  use_date = list(jf_data["date"])
  if name:
   v = record[name] + 1
   jf_data["record"][name] = v
  if re_date:
   use_date.append(re_date)
   jf_data["date"] = use_date
   jf_data["last_use"] = re_date
  with open(file=file_path, mode='w', encoding='utf-8') as jf:
   json.dump(jf_data, jf, indent=2, sort_keys=True, ensure_ascii=False)

 # 獲取記錄次數
 def re_times(self):
  times_list = []
  record = self.read_record()["record"]
  for k, v in record.items():
   times_list.append(v)
  return times_list # 返回記錄次數

 # 獲取被點到成員記錄次數
 def call_times(self, name):
  record = self.read_record()["record"]
  return record[name]

#封裝事件
class ForGUI:
 # 初始化
 re_date = None

 def __init__(self):
  try:
   cname = Call_Name()
  except:
   msg["text"] = "未找到：%s" % excel_file_path
   msg.update()
  else:
   try:
    record = cname.read_record() # 讀取記錄
   except:
    cname.mk_record() # 讀取異常則重新創建記錄
    record = cname.read_record()
   self.re_date = record["date"] # 獲取使用日期記錄
   # 每5天初始化一次記錄
   if len(self.re_date) > 5:
    cname.mk_record() # 重新創建記錄

 # 開始點名，輸出有效姓名：姓名對應記錄不為最大次數
 def start(self):
  cname = Call_Name()
  times = cname.re_times() # 獲取記錄次數
  max_times = max(times) # 獲取記錄最大次數
  min_times = min(times) # 獲取記錄最小次數
  td = str(datetime.datetime.today().date()) # 獲取當前日期
  if not td in self.re_date:
   cname.re_mod(re_date=td)
  while True:
   name = cname.call_name() # 產生隨機姓名
   times = cname.call_times(name) # 獲取被點到成員記錄次數
   if max_times != min_times:
    if times != max_times:
     cname.re_mod(name=name) # 修改記錄
     msg["text"] = name
     msg.update()
     break
    else:
     continue
   else:
    cname.re_mod(name=name) # 修改記錄
    msg["text"] = name
    msg.update()
    break

 # 查看花名冊
 def open_name_excel(self):
  try:
   os.system("start %s&exit" % excel_file_path)
  except:
   msg["text"] = '\n未找到花名冊╮(╯▽╰)╭\n'
   msg["font"] = ('', 18)
   msg.update()

 # 查看點名記錄
 def open_record(self):
  try:
   os.system("start %s&exit" % file_path)
  except:
   msg["text"] = '\n未找到點名記錄╮(╯▽╰)╭\n'
   msg["font"] = ('', 18)
   msg.update()

 # 獲取花名冊名單
 def get_name_list(self):
  try:
   wb = openpyxl.load_workbook(excel_file_path)
   get_sheet = wb[excel_sheet]
  except:
   msg["text"] = "未找到：%s" % excel_file_path
   msg.update()
  else:
   list_data = []
   first_row = True
   for row in get_sheet:
    # 忽略首行
    if first_row:
     first_row = False
     continue
    # 讀取第一個單元格數據
    for lab in row:
     list_data.append(lab.value)
     break
   return list_data

# 創建窗口
root = tk.Tk(className="點名工具")
# 設置窗口大小
setWidth = 300
setHeight = 180
# 獲取屏幕分辨率
screenWidth = root.winfo_screenwidth()
screenHeight = root.winfo_screenheight()

x = int((screenWidth - setWidth) / 2)
y = int((screenHeight - setHeight) / 2)
# 設置窗口初始位置屏幕居中
root.geometry("%sx%s+%s+%s" % (setWidth, setHeight, x, y))
# 設置窗口寬高固定
root.resizable(0, 0)
# 創建菜單欄
m1 = tk.Menu(root, tearoff=False)
# 創建子菜單，不顯示分窗
MenuBar = tk.Menu(m1, tearoff=False)
MenuBar.add_command(label='查看名單', command=ForGUI().open_name_excel)
MenuBar.add_command(label='查看記錄', command=ForGUI().open_record)
MenuBar.add_command(label='清空記錄', command=Call_Name().mk_record)

# 將子菜單加入菜單欄中
m1.add_cascade(label='選項', menu=MenuBar)
m1.add_command(label='Exit', command=root.quit)
# 將菜單欄添加到窗口
root.config(menu=m1)
# 創建文本顯示
f1 = tk.Frame(root, bd=1, height=150, width=200)
pass
f1.pack(pady=10)
msg = tk.Label(f1, text="\n別緊張(●ˇ∀ˇ●)\n", fg="green") # 創建文本控件
msg.pack(pady=10)
msg["font"] = ('', 18)
f2 = tk.Frame(root)
f2.pack(pady=10)

# 循環隨機顯示花名冊名單
name_list = ForGUI().get_name_list()
def info():
 t = random.randint(1, len(name_list))
 msg["font"] = ('', 44)
 msg["text"] = (name_list[t - 1])

def bt_listen():
 while bt["state"] == 'normal':
  bt['command'] = bt_start
  bt['text'] = "就決定是你了"
  root.after(500, info)
  bt.update()
  if bt['text'] == "開始":
   break
def bt_start():
 bt['command'] = bt_listen
 bt['text'] = "開始"
 fg = ForGUI()
 root.after(500, fg.start)
 bt.update()

# 創建開始按鈕
bt = tk.Button(f2, text='開始點名嘍', stat="normal", command=bt_listen, bd=4, width=20, font=18)
bt.pack()
root.mainloop()