HGSSystem/control/admin_program.py

import abc
import tkinter as tk
import tkinter.ttk as ttk
from tkinter.filedialog import askdirectory, askopenfilename

from tool.type_ import *
from tool.tk import make_font, set_tk_disable_from_list
from tool.login import create_uid

import conf
import admin
import admin_event as tk_event

from sql.user import find_user_by_name
from core.garbage import GarbageType


class AdminProgram(metaclass=abc.ABCMeta):
    def __init__(self, station: admin.AdminStation, win: Union[tk.Frame, tk.Toplevel, tk.Tk], color: str, title: str):
        self.station = station
        self.win = win
        self.color = color
        self.frame = tk.Frame(self.win)
        self.frame['bg'] = color
        self.program_title = title

    @abc.abstractmethod
    def set_disable(self):
        ...

    @abc.abstractmethod
    def reset_disable(self):
        ...

    @abc.abstractmethod
    def conf_gui(self, n: int = 1):
        ...

    def get_program_frame(self) -> Tuple[str, tk.Frame]:
        return self.program_title, self.frame


class WelcomeProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "Welcome")

        self.title = tk.Label(self.frame)
        self.info = tk.Label(self.frame)
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(25 * n)
        self.info_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size, weight="bold")
        info_font = make_font(size=self.info_font_size)

        self.title['font'] = title_font
        self.title['bg'] = self.color
        self.title['text'] = 'Welcome to HGSSystem Manager\n[Help Page]'

        self.info['bg'] = self.color
        self.info['font'] = info_font
        self.info['anchor'] = 'nw'
        self.info['justify'] = 'left'
        self.info['text'] = (f'''
HGSSystem 管理者界面:
  1) 点击菜单按钮进入子菜单或程序
  2) Creat 菜单包含创建类的程序
  3) Delete 菜单包含删除类的程序
  4) Search 菜单包含数据分析类的程序
  5) Update 菜单包含数据更新类的程序
  6）当离开操作系统时请退出登录以确保安全
  7）只能使用具有管理员权限的账号登陆系统
  8）只有admin用户可以完成危险操作(例如删除所有垃圾袋数据)

程序的运行:
  1) 在菜单中选中程序后，根据程序界面提示完成操作
  2) 操作过程通常会显示进度条，除非任务执行迅速
  3) 结果通常会被反馈, 且不会自动消失

系统登录:
  1) 仅Manager用户可以登录

关于彩蛋: 存在
                '''.strip())

        self.title.place(relx=0.1, rely=0.0, relwidth=0.8, relheight=0.2)
        self.info.place(relx=0.05, rely=0.21, relwidth=0.90, relheight=0.75)

    def set_disable(self):
        pass

    def reset_disable(self):
        pass


class AboutProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "About")

        self.title = tk.Label(self.frame)
        self.info = tk.Label(self.frame)
        self.btn: List[tk.Button] = [tk.Button(self.frame) for _ in range(2)]
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(25 * n)
        self.info_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size, weight="bold")
        info_font = make_font(size=self.info_font_size)

        self.title['font'] = title_font
        self.title['bg'] = self.color
        self.title['text'] = 'About HGSSystem Manager\n[About Page]'

        self.info['bg'] = self.color
        self.info['font'] = info_font
        self.info['anchor'] = 'nw'
        self.info['justify'] = 'left'
        self.info['text'] = conf.about_info

        self.title.place(relx=0.1, rely=0.0, relwidth=0.8, relheight=0.2)
        self.info.place(relx=0.05, rely=0.21, relwidth=0.90, relheight=0.75)

    def test_progress(self):
        event = tk_event.TestProgressEvent(self.station)
        self.station.push_event(event)

    def test_msg(self):
        self.station.show_msg("Test Msg", "test msg")

    def set_disable(self):
        set_tk_disable_from_list(self.btn)

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')


class CreateUserProgramBase(AdminProgram):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)

        self.enter_frame = tk.Frame(self.frame)
        self.title: List[tk.Label] = [tk.Label(self.enter_frame) for _ in range(3)]
        self.enter: List[tk.Entry] = [tk.Entry(self.enter_frame) for _ in range(3)]
        self.var: List[tk.Variable] = [tk.StringVar() for _ in range(3)]
        self.btn: List[tk.Button] = [tk.Button(self.frame) for _ in range(2)]  # create(生成用户) try(计算uid)

        self._conf("#FA8072", False)  # 默认颜色
        self.__conf_font()

    def _conf(self, bg_color, is_manager: bool):
        self.bg_color = bg_color
        self.is_manager = is_manager
        return self

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = self.bg_color
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.3, relwidth=0.6, relheight=0.30)

        height = 0.1
        for lb, text, enter, var in zip(self.title, ["UserName:", "PassWord:", "Phone:"], self.enter, self.var):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = self.bg_color
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.17)
            enter.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.17)
            height += 0.30

        for btn, text, x, func in zip(self.btn,
                                      ["Create", "GetUID"],
                                      [0.2, 0.6],
                                      [lambda: self.create_by_name(), lambda: self.get_uid()]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func
            btn.place(relx=x, rely=0.7, relwidth=0.2, relheight=0.08)

    def __get_info(self) -> Optional[Tuple[uname_t, passwd_t, str]]:
        name: uname_t = self.var[0].get()
        passwd: passwd_t = self.var[1].get()
        phone: str = self.var[2].get()

        if len(name) == 0 or len(passwd) == 0 or len(phone) != 11:
            self.station.show_msg("UserInfoError", "Please, enter UserName/Passwd/Phone(11)")
            return None

        return name, passwd, phone

    def create_by_name(self):
        res = self.__get_info()
        if res is None:
            return
        name, passwd, phone = res
        event = tk_event.CreateUserEvent(self.station).start(name, passwd, phone, self.is_manager)
        self.station.push_event(event)

    def get_uid(self):
        res = self.__get_info()
        if res is None:
            return
        name, passwd, phone = res
        uid = create_uid(name, passwd, phone)
        self.station.show_msg("UserID", f"UserName: {name}\nUserID: {uid}")

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        set_tk_disable_from_list(self.enter)

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        set_tk_disable_from_list(self.enter, flat='normal')


class CreateNormalUserProgram(CreateUserProgramBase):
    def __init__(self, station, win, color):
        super(CreateNormalUserProgram, self).__init__(station, win, color, "CreateNormalUser")


class CreateManagerUserProgram(CreateUserProgramBase):
    def __init__(self, station, win, color):
        super(CreateManagerUserProgram, self).__init__(station, win, color, "CreateManagerUser")
        self._conf("#4b5cc4", True)


class CreateAutoNormalUserProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "CreateAutoNormalUser")

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.var: tk.Variable = tk.StringVar()
        self.btn: tk.Button = tk.Button(self.frame)  # create(生成用户) try(计算uid)

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#bce672"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.3, relwidth=0.6, relheight=0.12)

        self.title['font'] = title_font
        self.title['text'] = "Phone:"
        self.title['bg'] = "#bce672"
        self.title['anchor'] = 'e'

        self.enter['font'] = title_font
        self.enter['textvariable'] = self.var

        self.title.place(relx=0.02, rely=0.25, relwidth=0.25, relheight=0.50)
        self.enter.place(relx=0.30, rely=0.25, relwidth=0.60, relheight=0.50)

        self.btn['font'] = btn_font
        self.btn['text'] = "Create"
        self.btn['bg'] = conf.tk_btn_bg
        self.btn['command'] = lambda: self.create_user()
        self.btn.place(relx=0.4, rely=0.7, relwidth=0.2, relheight=0.08)

    def create_user(self):
        phone = self.var.get()
        if len(phone) != 11:
            self.station.show_msg("UserInfoError", "Please, enter Phone(11)")
        event = tk_event.CreateUserEvent(self.station).start(None, None, phone, False)
        self.station.push_event(event)

    def set_disable(self):
        self.btn['state'] = 'disable'
        self.enter['state'] = 'disable'

    def reset_disable(self):
        self.btn['state'] = 'normal'
        self.enter['state'] = 'normal'


class CreateGarbageProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "CreateGarbage")

        self.enter_frame = tk.Frame(self.frame)
        self.title: List[tk.Label] = [tk.Label(self.enter_frame), tk.Label(self.enter_frame)]
        self.enter: List[tk.Entry] = [tk.Entry(self.enter_frame), tk.Entry(self.enter_frame)]
        self.var: List[tk.Variable] = [tk.StringVar(), tk.StringVar()]
        self.create_btn: tk.Button = tk.Button(self.frame)
        self.file_btn: tk.Button = tk.Button(self.frame)

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#b69968"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.3, relwidth=0.6, relheight=0.17)

        height = 0.1
        for lb, text, enter, var in zip(self.title, ["Count:", "Export:"], self.enter, self.var):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#b69968"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.35)
            enter.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.35)
            height += 0.43

        for btn, text, x, func in zip([self.create_btn, self.file_btn],
                                      ["Create", "ChoosePath"],
                                      [0.2, 0.6],
                                      [lambda: self.create_garbage(), lambda: self.choose_file()]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func
            btn.place(relx=x, rely=0.7, relwidth=0.2, relheight=0.08)

    def choose_file(self):
        path = askdirectory(title='path to save qr code')
        self.var[1].set(path)

    def create_garbage(self):
        try:
            count = int(self.var[0].get())
            if count <= 0:
                raise ValueError
        except (ValueError, TypeError):
            self.station.show_msg("TypeError", "Count must be number > 1")
        else:
            path = self.var[1].get()
            if len(path) == 0:
                path = None
            event = tk_event.CreateGarbageEvent(self.station).start(path, count)
            self.station.push_event(event)

    def set_disable(self):
        self.create_btn['state'] = 'disable'
        self.file_btn['state'] = 'disable'
        set_tk_disable_from_list(self.enter)

    def reset_disable(self):
        self.create_btn['state'] = 'normal'
        self.file_btn['state'] = 'normal'
        set_tk_disable_from_list(self.enter, flat='normal')


class ExportProgramBase(AdminProgram):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)

        self.gid_frame = tk.Frame(self.frame)
        self.gid_title: List[tk.Label] = [tk.Label(self.gid_frame), tk.Label(self.gid_frame)]
        self.gid_enter: List[tk.Entry] = [tk.Entry(self.gid_frame), tk.Entry(self.gid_frame)]
        self.gid_var: List[tk.Variable] = [tk.StringVar(), tk.StringVar()]

        self.where_frame = tk.Frame(self.frame)
        self.where_title: List[tk.Label] = [tk.Label(self.where_frame), tk.Label(self.where_frame)]
        self.where_enter: List[tk.Entry] = [tk.Entry(self.where_frame), tk.Entry(self.where_frame)]
        self.where_var: List[tk.Variable] = [tk.StringVar(), tk.StringVar()]

        self.create_btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]
        self.file_btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]

        self._conf("", [], [], [])
        self.__conf_font()

    def _conf(self, bg_color: str, title_id, title_where, title_command):
        self.bg_color = bg_color
        self.title_id = title_id
        self.title_where = title_where
        self.title_command = title_command

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.where_frame['bg'] = self.bg_color
        self.where_frame['bd'] = 5
        self.where_frame['relief'] = "ridge"
        self.where_frame.place(relx=0.2, rely=0.2, relwidth=0.6, relheight=0.17)

        self.gid_frame['bg'] = self.bg_color
        self.gid_frame['bd'] = 5
        self.gid_frame['relief'] = "ridge"
        self.gid_frame.place(relx=0.2, rely=0.6, relwidth=0.6, relheight=0.17)

        height = 0.1
        for lb, text, enter, var, lb_w, text_w, enter_w, var_w in zip(
                self.gid_title, self.title_id, self.gid_enter, self.gid_var,
                self.where_title, self.title_where, self.where_enter, self.where_var):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = self.bg_color
            lb['anchor'] = 'e'

            lb_w['font'] = title_font
            lb_w['text'] = text_w
            lb_w['bg'] = self.bg_color
            lb_w['anchor'] = 'e'

            enter['textvariable'] = var
            enter['font'] = title_font

            enter_w['textvariable'] = var_w
            enter_w['font'] = title_font

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.35)
            enter.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.35)

            lb_w.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.35)
            enter_w.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.35)

            height += 0.43

        for btn, text in zip(self.create_btn + self.file_btn, self.title_command):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg

        self.create_btn[1]['command'] = self.export_where
        self.create_btn[0]['command'] = self.export_id
        self.create_btn[1].place(relx=0.2, rely=0.39, relwidth=0.25, relheight=0.08)
        self.create_btn[0].place(relx=0.2, rely=0.79, relwidth=0.25, relheight=0.08)

        self.file_btn[1]['command'] = self.choose_file_where
        self.file_btn[0]['command'] = self.choose_file_id
        self.file_btn[1].place(relx=0.6, rely=0.39, relwidth=0.2, relheight=0.08)
        self.file_btn[0].place(relx=0.6, rely=0.79, relwidth=0.2, relheight=0.08)

    def choose_file_id(self):
        path = askdirectory(title='path to save qr code')
        self.gid_var[1].set(path)

    def choose_file_where(self):
        path = askdirectory(title='path to save qr code')
        self.where_var[1].set(path)

    def export_id(self):
        ...

    def export_where(self):
        ...

    def set_disable(self):
        set_tk_disable_from_list(self.gid_enter)
        set_tk_disable_from_list(self.create_btn)
        set_tk_disable_from_list(self.file_btn)

    def reset_disable(self):
        set_tk_disable_from_list(self.gid_enter, flat='normal')
        set_tk_disable_from_list(self.create_btn, flat='normal')
        set_tk_disable_from_list(self.file_btn, flat='normal')


class ExportGarbageProgram(ExportProgramBase):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "ExportGarbage")
        self._conf("#afdfe4", ["GarbageID:", "Export:"], ["Where:", "Export:"],
                   ["Export By GarbageID", "Export Advanced", "ChoosePath", "ChoosePath"])

    def export_id(self):
        gid = self.gid_var[0].get()
        path = self.gid_var[1].get()
        event = tk_event.ExportGarbageByIDEvent(self.station).start(path, gid)
        self.station.push_event(event)

    def export_where(self):
        where = self.where_var[0].get()
        path = self.where_var[1].get()
        event = tk_event.ExportGarbageAdvancedEvent(self.station).start(path, where)
        self.station.push_event(event)


class ExportUserProgram(ExportProgramBase):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "ExportUser")
        self._conf("#f69c9f", ["UserID:", "Export:"], ["Where:", "Export:"],
                   ["Export By UserID", "Export Advanced", "ChoosePath", "ChoosePath"])

    def export_id(self):
        uid = self.gid_var[0].get()
        path = self.gid_var[1].get()
        event = tk_event.ExportUserByIDEvent(self.station).start(path, uid)
        self.station.push_event(event)

    def export_where(self):
        where = self.where_var[0].get()
        path = self.where_var[1].get()
        event = tk_event.ExportUserAdvancedEvent(self.station).start(path, where)
        self.station.push_event(event)


class CreateUserFromCSVProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "CreateUserFromCSV")

        self.auto_frame = tk.Frame(self.frame)
        self.auto_title: tk.Label = tk.Label(self.auto_frame)
        self.auto_enter: tk.Entry = tk.Entry(self.auto_frame)
        self.auto_var: tk.Variable = tk.StringVar()

        self.enter_frame = tk.Frame(self.frame)
        self.path_title: tk.Label = tk.Label(self.enter_frame)
        self.path_enter: tk.Entry = tk.Entry(self.enter_frame)
        self.path_var: tk.Variable = tk.StringVar()

        self.create_btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]
        self.file_btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#EEE8AA"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.2, relwidth=0.6, relheight=0.12)

        self.auto_frame['bg'] = "#EEE8AA"
        self.auto_frame['bd'] = 5
        self.auto_frame['relief'] = "ridge"
        self.auto_frame.place(relx=0.2, rely=0.6, relwidth=0.6, relheight=0.12)

        self.auto_title['font'] = title_font
        self.auto_title['text'] = "Path:"
        self.auto_title['bg'] = "#EEE8AA"
        self.auto_title['anchor'] = 'e'

        self.path_title['font'] = title_font
        self.path_title['text'] = "Path:"
        self.path_title['bg'] = "#EEE8AA"
        self.path_title['anchor'] = 'e'

        self.auto_enter['textvariable'] = self.auto_var
        self.auto_enter['font'] = title_font

        self.path_enter['textvariable'] = self.path_var
        self.path_enter['font'] = title_font

        self.auto_title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.auto_enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        self.path_title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.path_enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        for btn, text in zip(self.create_btn + self.file_btn,
                             ["Create User", "Create Auto User", "Choose CSV", "Choose CSV"]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg

        self.create_btn[0]['command'] = self.create
        self.create_btn[1]['command'] = self.create_auto
        self.create_btn[0].place(relx=0.2, rely=0.34, relwidth=0.25, relheight=0.08)
        self.create_btn[1].place(relx=0.2, rely=0.74, relwidth=0.25, relheight=0.08)

        self.file_btn[0]['command'] = self.choose_file
        self.file_btn[1]['command'] = self.choose_file_auto
        self.file_btn[0].place(relx=0.6, rely=0.34, relwidth=0.2, relheight=0.08)
        self.file_btn[1].place(relx=0.6, rely=0.74, relwidth=0.2, relheight=0.08)

    def choose_file_auto(self):
        path = askopenfilename(title='path of csv', filetypes=[("CSV", ".csv")])
        self.auto_var.set(path)

    def choose_file(self):
        path = askopenfilename(title='path of csv', filetypes=[("CSV", ".csv")])
        self.path_var.set(path)

    def create_auto(self):
        path = self.auto_var.get()
        event = tk_event.CreateAutoUserFromCSVEvent(self.station).start(path)
        self.station.push_event(event)

    def create(self):
        path = self.path_var.get()
        event = tk_event.CreateUserFromCSVEvent(self.station).start(path)
        self.station.push_event(event)

    def set_disable(self):
        self.auto_enter['state'] = 'disable'
        self.path_enter['state'] = 'disable'
        set_tk_disable_from_list(self.create_btn)
        set_tk_disable_from_list(self.file_btn)

    def reset_disable(self):
        self.auto_enter['state'] = 'normal'
        self.path_enter['state'] = 'normal'
        set_tk_disable_from_list(self.create_btn, flat='normal')
        set_tk_disable_from_list(self.file_btn, flat='normal')


class DeleteUserProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "DeleteUser")

        self.uid_frame = tk.Frame(self.frame)
        self.uid_title: tk.Label = tk.Label(self.uid_frame)
        self.uid_enter: tk.Entry = tk.Entry(self.uid_frame)
        self.uid_var: tk.Variable = tk.StringVar()

        self.name_frame = tk.Frame(self.frame)
        self.name_title: List[tk.Label] = [tk.Label(self.name_frame) for _ in range(2)]
        self.name_enter: List[tk.Entry] = [tk.Entry(self.name_frame) for _ in range(2)]
        self.name_var: List[tk.Variable] = [tk.StringVar() for _ in range(2)]

        self.btn: List[tk.Button] = [tk.Button(self.frame) for _ in range(2)]  # uid-del, name-passwd-del

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.uid_frame['bg'] = "#FA8072"
        self.uid_frame['bd'] = 5
        self.uid_frame['relief'] = "ridge"
        self.uid_frame.place(relx=0.2, rely=0.20, relwidth=0.6, relheight=0.10)

        self.name_frame['bg'] = "#FA8072"
        self.name_frame['bd'] = 5
        self.name_frame['relief'] = "ridge"
        self.name_frame.place(relx=0.2, rely=0.48, relwidth=0.6, relheight=0.25)

        height = 0.17
        for lb, text, enter, var in zip(self.name_title, ["UserName:", "PassWord:"], self.name_enter, self.name_var):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#FA8072"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.20)
            enter.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.20)
            height += 0.45

        self.uid_title['font'] = title_font
        self.uid_title['text'] = "UserID:"
        self.uid_title['bg'] = "#FA8072"
        self.uid_title['anchor'] = 'e'

        self.uid_enter['font'] = title_font
        self.uid_enter['textvariable'] = self.uid_var

        self.uid_title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.uid_enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        for btn, text, func in zip(self.btn,
                                   ["Delete By Uid", "Delete By Name"],
                                   [lambda: self.del_by_uid(), lambda: self.del_by_name()]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func

        self.btn[0].place(relx=0.6, rely=0.32, relwidth=0.2, relheight=0.08)
        self.btn[1].place(relx=0.6, rely=0.75, relwidth=0.2, relheight=0.08)

    def del_by_uid(self):
        uid = self.uid_var.get()
        if len(uid) != 32:
            self.station.show_msg("UserID Error", "Len of UserID must be 32", "Error")
            return
        event = tk_event.DelUserEvent(self.station).start(uid)
        self.station.push_event(event)

    def del_by_name(self):
        name = self.name_var[0].get()
        passwd = self.name_var[1].get()
        if len(name) == 0 or len(passwd) == 0:
            self.station.show_msg("UserName/Password Error", "You should enter UserName and Password", "Error")
            return
        uid = create_uid(name, passwd)
        event = tk_event.DelUserEvent(self.station).start(uid)
        self.station.push_event(event)

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        set_tk_disable_from_list(self.name_enter)
        self.uid_enter['state'] = 'disable'

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        set_tk_disable_from_list(self.name_enter, flat='normal')
        self.uid_enter['state'] = 'normal'


class DeleteUsersProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "DeleteUsers")

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.var: tk.Variable = tk.StringVar()

        self.btn: List[tk.Button] = [tk.Button(self.frame) for _ in range(2)]  # del, scan

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#48c0a3"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.30, relwidth=0.6, relheight=0.10)

        self.title['font'] = title_font
        self.title['text'] = "Where:"
        self.title['anchor'] = 'e'
        self.title['bg'] = "#48c0a3"

        self.enter['font'] = title_font
        self.enter['textvariable'] = self.var

        self.title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        for btn, text, x, func in zip(self.btn,
                                      ["Delete", "Scan"],
                                      [0.2, 0.6],
                                      [lambda: self.delete_user(), lambda: self.scan_user()]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func
            btn.place(relx=x, rely=0.6, relwidth=0.2, relheight=0.08)

    def delete_user(self):
        where = self.var.get()
        if len(where) == 0:
            self.station.show_msg("`Where`Error", "`Where` must be SQL", "Warning")
            return
        event = tk_event.DelUserFromWhereEvent(self.station).start(where)
        self.station.push_event(event)

    def scan_user(self):
        where = self.var.get()
        if len(where) == 0:
            self.station.show_msg("`Where`Error", "`Where` must be SQL", "Warning")
            return
        event = tk_event.DelUserFromWhereScanEvent(self.station).start(where)
        self.station.push_event(event)

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        self.enter['state'] = 'disable'

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        self.enter['state'] = 'normal'


class DeleteGarbageProgramBase(AdminProgram):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.var: tk.Variable = tk.StringVar()

        self.int_var: tk.Variable = tk.IntVar()
        self.int_var.set(0)
        self.radio: List[tk.Radiobutton] = [tk.Radiobutton(self.frame) for _ in range(4)]
        self.btn: tk.Button = tk.Button(self.frame)

        self.__conf_font()
        self._conf()

    def _conf(self, title: str = "GarbageID:", color: str = "#b69968", support_del_all: bool = True):
        self.frame_title = title
        self.frame_color = color
        self.support_del_all = support_del_all

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = self.frame_color
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.30, relwidth=0.6, relheight=0.10)

        self.title['font'] = title_font
        self.title['text'] = self.frame_title
        self.title['bg'] = self.frame_color
        self.title['anchor'] = 'e'

        self.enter['font'] = title_font
        self.enter['textvariable'] = self.var

        self.title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        for i in range(4):
            radio = self.radio[i]
            radio['font'] = btn_font
            radio['text'] = ['From-All', 'From-NotUse', 'From-Waiting', 'From-Used'][i]
            radio['bg'] = self.color
            radio['value'] = i
            radio['variable'] = self.int_var
            radio['anchor'] = 'w'

        if not self.support_del_all:
            self.int_var.set(1)
            self.radio[0]['state'] = 'disable'

        self.radio[0].place(relx=0.20, rely=0.43, relwidth=0.20, relheight=0.1)
        self.radio[1].place(relx=0.60, rely=0.43, relwidth=0.20, relheight=0.1)
        self.radio[2].place(relx=0.20, rely=0.55, relwidth=0.20, relheight=0.1)
        self.radio[3].place(relx=0.60, rely=0.55, relwidth=0.20, relheight=0.1)

        self.btn['font'] = btn_font
        self.btn['text'] = 'Delete'
        self.btn['bg'] = conf.tk_btn_bg
        self.btn['command'] = lambda: self.delete_garbage()
        self.btn.place(relx=0.4, rely=0.68, relwidth=0.2, relheight=0.08)

    def delete_garbage(self):
        ...

    def set_disable(self):
        self.enter['state'] = 'disable'
        self.btn['state'] = 'disable'

    def reset_disable(self):
        self.enter['state'] = 'normal'
        self.btn['state'] = 'normal'


class DeleteGarbageProgram(DeleteGarbageProgramBase):
    def __init__(self, station, win, color):
        super(DeleteGarbageProgram, self).__init__(station, win, color, "DeleteGarbage")

    def delete_garbage(self):
        where = self.int_var.get()
        assert where in [0, 1, 2, 3]

        gid = self.var.get()
        if len(gid) == 0:
            self.station.show_msg("GarbageID Error", "You should enter the garbage id", "Warning")
            return

        event = tk_event.DelGarbageEvent(self.station).start(gid, where)
        self.station.push_event(event)


class DeleteGarbageMoreProgram(DeleteGarbageProgramBase):
    def __init__(self, station, win, color):
        super(DeleteGarbageMoreProgram, self).__init__(station, win, color, "DeleteGarbageMore")
        self.scan_btn = tk.Button(self.frame)
        self._conf("Where:", "#f58f98", False)

    def conf_gui(self, n: int = 1):
        super(DeleteGarbageMoreProgram, self).conf_gui(n)
        self.btn.place_forget()
        self.btn.place(relx=0.2, rely=0.68, relwidth=0.2, relheight=0.08)

        self.scan_btn['font'] = make_font(size=self.btn_font_size)
        self.scan_btn['text'] = 'Scan'
        self.scan_btn['bg'] = conf.tk_btn_bg
        self.scan_btn['command'] = lambda: self.delete_garbage(True)
        self.scan_btn.place(relx=0.6, rely=0.68, relwidth=0.2, relheight=0.08)

    def set_disable(self):
        super(DeleteGarbageMoreProgram, self).set_disable()
        self.scan_btn['state'] = 'disable'

    def reset_disable(self):
        super(DeleteGarbageMoreProgram, self).reset_disable()
        self.scan_btn['state'] = 'normal'

    def delete_garbage(self, is_scan: bool = False):
        where = self.int_var.get()
        assert where in [1, 2, 3]

        where_sql = self.var.get()
        if len(where_sql) == 0:
            self.station.show_msg("`Where`Error", "`Where` must be SQL", "Warning")
            return

        if is_scan:
            event = tk_event.DelGarbageWhereScanEvent(self.station).start(where, where_sql)
        else:
            event = tk_event.DelGarbageWhereEvent(self.station).start(where, where_sql)
        self.station.push_event(event)


class DeleteAllGarbageProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "DeleteAllGarbage")

        self.dangerous: tk.Label = tk.Label(self.frame)

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.var: tk.Variable = tk.StringVar()

        self.btn: List[tk.Button] = [tk.Button(self.frame) for _ in range(2)]  # del, scan

        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.danger_font_size = int(20 * n)
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        danger_font = make_font(size=self.danger_font_size, weight="bold", underline=1)
        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)
        danger_btn_font = make_font(size=self.btn_font_size, weight="bold", overstrike=1)

        self.dangerous['bg'] = self.color
        self.dangerous['font'] = danger_font
        self.dangerous['fg'] = "#f20c00"
        self.dangerous['text'] = ("Delete all garbage from database?\n"
                                  "Please enter the admin-passwd to\n"
                                  "continue.\n"
                                  "Dangerous operation.\n"
                                  "The database may not be restored.\n"
                                  "SuperHuan is not responsible for\n"
                                  "the consequences.")
        self.dangerous.place(relx=0.05, rely=0.03, relwidth=0.9, relheight=0.43)

        self.enter_frame['bg'] = "#f20c00"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.50, relwidth=0.6, relheight=0.10)

        self.title['font'] = title_font
        self.title['text'] = "Password:"
        self.title['bg'] = "#f20c00"
        self.title['anchor'] = 'e'

        self.enter['font'] = title_font
        self.enter['textvariable'] = self.var

        self.title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        for btn, text, x in zip(self.btn, ["Delete", "Scan"], [0.2, 0.6]):
            btn['text'] = text
            btn.place(relx=x, rely=0.68, relwidth=0.2, relheight=0.08)

        self.btn[0]['font'] = danger_btn_font
        self.btn[0]['bg'] = "#f20c00"
        self.btn[0]['command'] = lambda: self.delete_garbage()

        self.btn[1]['font'] = btn_font
        self.btn[1]['bg'] = conf.tk_btn_bg
        self.btn[1]['command'] = lambda: self.scan_garbage()

    def scan_garbage(self):
        event = tk_event.DelAllGarbageScanEvent(self.station)  # 不需要start
        self.station.push_event(event)

    def delete_garbage(self):
        passwd = self.var.get()
        if len(passwd) == 0:
            self.station.show_msg("PassWordError", "Password error", "Warning")

        user = find_user_by_name('admin', passwd, self.station.get_db())
        if user is None or not user.is_manager():
            self.station.show_msg("PassWordError", "Password error", "Warning")
            return

        event = tk_event.DelAllGarbageEvent(self.station)  # 不需要start
        self.station.push_event(event)

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        self.enter['state'] = 'disable'

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        self.enter['state'] = 'normal'


class SearchBaseProgram(AdminProgram, metaclass=abc.ABCMeta):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)
        self.view_frame = tk.Frame(self.frame)
        self.view = ttk.Treeview(self.view_frame)
        self.y_scroll = tk.Scrollbar(self.view_frame)
        self.x_scroll = tk.Scrollbar(self.view_frame)

    def conf_view_gui(self, columns: list, relx, rely, relwidth, relheight,
                      x_scroll=0.05, y_scroll=0.02, color: str = "#FA8072"):
        self.view_frame['bg'] = color
        self.view_frame['bd'] = 2
        self.view_frame['relief'] = "ridge"
        self.view_frame.place(relx=relx, rely=rely, relwidth=relwidth, relheight=relheight)

        self.view['columns'] = columns
        self.view['show'] = 'headings'
        self.view['selectmode'] = 'none'

        for i in columns:
            self.view.column(i, anchor="c")
            self.view.heading(i, text=i)

        self.y_scroll['orient'] = 'vertical'
        self.y_scroll['command'] = self.view.yview
        self.view['yscrollcommand'] = self.y_scroll.set

        self.x_scroll['orient'] = 'horizontal'
        self.x_scroll['command'] = self.view.xview
        self.view['xscrollcommand'] = self.x_scroll.set

        self.view.place(relx=0.0, rely=0.0, relwidth=1 - y_scroll, relheight=1 - x_scroll)
        self.y_scroll.place(relx=0.98, rely=0.0, relwidth=y_scroll, relheight=1.0)
        self.x_scroll.place(relx=0.0, rely=1 - x_scroll, relwidth=1 - y_scroll, relheight=x_scroll)


class SearchUserProgram(SearchBaseProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "SearchUser")

        self.enter_frame = tk.Frame(self.frame)
        self.title: List[tk.Label] = [tk.Label(self.enter_frame) for _ in range(3)]
        self.enter: List[tk.Entry] = [tk.Entry(self.enter_frame) for _ in range(3)]
        self.var: List[tk.Variable] = [tk.StringVar() for _ in range(3)]
        self.check: List[Tuple[tk.Checkbutton, tk.Variable]] = [(tk.Checkbutton(self.enter_frame), tk.IntVar())
                                                                for _ in range(3)]
        self.btn: tk.Button = tk.Button(self.frame)
        self._columns = ["UserID", "Name", "Phone", "Score", "Reputation", "IsManager"]
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#FA8072"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.0, relwidth=0.6, relheight=0.30)

        height = 0.1
        for lb, text, enter, var, check in zip(self.title,
                                               ["UserID:", "UserName:", "Phone:"],
                                               self.enter, self.var, self.check):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#FA8072"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            check[0]['font'] = title_font
            check[0]['text'] = ''
            check[0]['bg'] = "#FA8072"
            check[0]['variable'] = check[1]
            check[1].set(1)

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.17)
            enter.place(relx=0.35, rely=height, relwidth=0.55, relheight=0.17)
            check[0].place(relx=0.92, rely=height, relwidth=0.04, relheight=0.17)
            height += 0.30

        self.btn['font'] = btn_font
        self.btn['text'] = "Search"
        self.btn['bg'] = conf.tk_btn_bg
        self.btn['command'] = self.search_user
        self.btn.place(relx=0.4, rely=0.9, relwidth=0.2, relheight=0.08)

        self.conf_view_gui(self._columns, relx=0.05, rely=0.32, relwidth=0.9, relheight=0.55)

    def search_user(self):
        use_uid = self.check[0][1].get()
        use_name = self.check[1][1].get()
        use_phone = self.check[2][1].get()
        uid = None
        name = None
        phone = None
        if use_uid:
            uid = self.var[0].get()
            if len(uid) == 0:
                uid = None

        if use_name:
            name = self.var[1].get()
            if len(name) == 0:
                name = None

        if use_phone:
            phone = self.var[2].get()
            if len(phone) == 0:
                phone = None

        event = tk_event.SearchUserEvent(self.station).start(self._columns, uid, name, phone, self)
        self.station.push_event(event)

    def set_disable(self):
        self.btn['state'] = 'disable'
        set_tk_disable_from_list(self.enter)

    def reset_disable(self):
        self.btn['state'] = 'normal'
        set_tk_disable_from_list(self.enter, flat='normal')


class SearchAdvancedProgramBase(SearchBaseProgram, metaclass=abc.ABCMeta):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.var: tk.Variable = tk.StringVar()

        self.btn: tk.Button = tk.Button(self.frame)
        self._conf([], "#FA8072")  # 默认颜色
        self.__conf_font()

    def _conf(self, columns: list, bg_color):
        self.bg_color = bg_color
        self._columns = columns
        return self

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = self.bg_color
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.00, relwidth=0.6, relheight=0.10)

        self.title['font'] = title_font
        self.title['bg'] = self.bg_color
        self.title['text'] = "Where:"
        self.title['anchor'] = 'e'

        self.enter['font'] = title_font
        self.enter['textvariable'] = self.var

        self.title.place(relx=0.01, rely=0.25, relwidth=0.30, relheight=0.50)
        self.enter.place(relx=0.35, rely=0.25, relwidth=0.60, relheight=0.50)

        self.btn['text'] = "Search"
        self.btn['font'] = btn_font
        self.btn['bg'] = conf.tk_btn_bg
        self.btn['command'] = self.search
        self.btn.place(relx=0.4, rely=0.9, relwidth=0.2, relheight=0.08)

        self.conf_view_gui(self._columns, relx=0.05, rely=0.12, relwidth=0.9, relheight=0.76)

    def search(self):
        ...

    def set_disable(self):
        self.btn['state'] = 'disable'
        self.enter['state'] = 'disable'

    def reset_disable(self):
        self.btn['state'] = 'normal'
        self.enter['state'] = 'normal'


class SearchUserAdvancedProgram(SearchAdvancedProgramBase):
    def __init__(self, station, win, color):
        super(SearchUserAdvancedProgram, self).__init__(station, win, color, "SearchUserAdvanced")
        columns = ["UserID", "Name", "Phone", "Score", "Reputation", "IsManager"]
        self._conf(columns, '#48c0a3')

    def search(self):
        where = self.var.get()
        event = tk_event.SearchUserAdvancedEvent(self.station).start(self._columns, where, self)
        self.station.push_event(event)


class SearchGarbageProgram(SearchBaseProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "SearchGarbage")

        self.enter_frame = tk.Frame(self.frame)
        self.title: List[tk.Label] = [tk.Label(self.enter_frame) for _ in range(8)]
        self.enter: List[tk.Entry] = [tk.Entry(self.enter_frame) for _ in range(8)]
        self.var: List[tk.Variable] = [tk.StringVar() for _ in range(8)]
        self.check: List[Tuple[tk.Checkbutton, tk.Variable]] = [(tk.Checkbutton(self.enter_frame), tk.IntVar())
                                                                for _ in range(8)]
        self._columns = ["GarbageID", "UserID", "CheckerID", "CreateTime", "UseTime", "Location", "GarbageType",
                         "CheckResult"]
        self.btn: tk.Button = tk.Button(self.frame)
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.enter_frame['bg'] = "#7bbfea"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.0, relwidth=0.6, relheight=0.47)

        height = 0.02
        for lb, text, enter, var, check in zip(self.title,
                                               ["GarbageID:", "UserID:", "CheckerID:", "CreateTime:", "UseTime:",
                                                "Location:", "GarbageType:", "CheckResult:"],
                                               self.enter, self.var, self.check):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#7bbfea"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            check[0]['font'] = title_font
            check[0]['bg'] = "#7bbfea"
            check[0]['text'] = ''
            check[0]['variable'] = check[1]
            check[1].set(1)

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.10)
            enter.place(relx=0.35, rely=height, relwidth=0.55, relheight=0.10)
            check[0].place(relx=0.92, rely=height, relwidth=0.04, relheight=0.10)
            height += 0.121

        self.btn['font'] = btn_font
        self.btn['bg'] = conf.tk_btn_bg
        self.btn['text'] = "Search"
        self.btn['command'] = self.search_user
        self.btn.place(relx=0.4, rely=0.9, relwidth=0.2, relheight=0.08)

        self.conf_view_gui(self._columns, relx=0.05, rely=0.49, relwidth=0.9, relheight=0.38, x_scroll=0.07)

    def search_user(self):
        keys = ["gid", "uid", "cuid", "create_time", "use_time", "loc", "type_", "check"]
        key_values = {}
        for i, key in enumerate(keys):
            ck = self.check[i][1].get()
            if ck:
                res = self.enter[i].get()
                if len(res) > 0:
                    key_values[key] = res
                    continue
            key_values[key] = None

        event = tk_event.SearchGarbageEvent(self.station).start(self._columns, key_values, self)
        self.station.push_event(event)

    def set_disable(self):
        self.btn['state'] = 'disable'
        set_tk_disable_from_list(self.enter)

    def reset_disable(self):
        self.btn['state'] = 'normal'
        set_tk_disable_from_list(self.enter, flat='normal')


class SearchGarbageAdvancedProgram(SearchAdvancedProgramBase):
    def __init__(self, station, win, color):
        super(SearchGarbageAdvancedProgram, self).__init__(station, win, color, "SearchGarbageAdvanced")
        columns = ["GarbageID", "UserID", "CheckerID", "CreateTime", "UseTime", "Location", "GarbageType",
                   "CheckResult"]
        self._conf(columns, '#d1923f')

    def search(self):
        where = self.var.get()
        event = tk_event.SearchGarbageAdvancedEvent(self.station).start(self._columns, where, self)
        self.station.push_event(event)


class SearchAdvancedProgram(SearchAdvancedProgramBase):
    def __init__(self, station, win, color):
        super(SearchAdvancedProgram, self).__init__(station, win, color, "SearchAdvanced")
        columns = ["GarbageID", "UserID", "UserName", "UserPhone", "UserScore",
                   "UserReputation", "CheckerID", "CheckerName", "CheckerPhone",
                   "CreateTime", "UseTime", "Location", "GarbageType", "CheckResult"]
        self._conf(columns, '#426ab3')

    def search(self):
        where = self.var.get()
        event = tk_event.SearchAdvancedEvent(self.station).start(self._columns, where, self)
        self.station.push_event(event)


class UpdateUserProgramBase(AdminProgram):
    def __init__(self, station, win, color, title: str):
        super().__init__(station, win, color, title)

        self.enter_frame = tk.Frame(self.frame)
        self.title: List[tk.Label] = [tk.Label(self.enter_frame) for _ in range(2)]
        self.enter: List[tk.Entry] = [tk.Entry(self.enter_frame) for _ in range(2)]
        self.var: List[tk.Variable] = [tk.StringVar() for _ in range(2)]

        self.where_frame = tk.Frame(self.frame)
        self.where_title: List[tk.Label] = [tk.Label(self.where_frame) for _ in range(2)]
        self.where_enter: List[tk.Entry] = [tk.Entry(self.where_frame) for _ in range(2)]
        self.where_var: List[tk.Variable] = [tk.StringVar() for _ in range(2)]

        self.btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]
        self._conf(["", ""], "#FA8072")
        self.__conf_font()

    def _conf(self, title: List[str], bg_color: str):
        self.bg_color = bg_color
        self.bg_color_where = bg_color
        self.enter_title = title

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.where_frame['bg'] = self.bg_color_where
        self.where_frame['bd'] = 5
        self.where_frame['relief'] = "ridge"
        self.where_frame.place(relx=0.2, rely=0.20, relwidth=0.6, relheight=0.17)

        self.enter_frame['bg'] = self.bg_color
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.58, relwidth=0.6, relheight=0.17)

        height = 0.1
        for lb, text, enter, var, lb_w, text_w, enter_w, var_w in (
                zip(self.title, self.enter_title, self.enter, self.var,
                    self.where_title, ["Where:", self.enter_title[1]], self.where_enter, self.where_var)):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = self.bg_color
            lb['anchor'] = 'e'

            lb_w['font'] = title_font
            lb_w['text'] = text_w
            lb_w['bg'] = self.bg_color_where
            lb_w['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var

            enter_w['font'] = title_font
            enter_w['textvariable'] = var_w

            lb.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.35)
            enter.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.35)

            lb_w.place(relx=0.01, rely=height, relwidth=0.30, relheight=0.35)
            enter_w.place(relx=0.35, rely=height, relwidth=0.60, relheight=0.35)
            height += 0.43

        for btn, text, func in zip(self.btn,
                                   ["Update Advanced", "Update By UserID"],
                                   [self.update_by_where, self.update_by_uid]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func

        self.btn[0].place(relx=0.55, rely=0.40, relwidth=0.25, relheight=0.08)
        self.btn[1].place(relx=0.55, rely=0.78, relwidth=0.25, relheight=0.08)

    def update_by_uid(self):
        ...

    def update_by_where(self):
        ...

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        set_tk_disable_from_list(self.enter)

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        set_tk_disable_from_list(self.enter, flat='normal')


class UpdateUserScoreBase(UpdateUserProgramBase):
    def __init__(self, station, win, color):
        super(UpdateUserScoreBase, self).__init__(station, win, color, "UpdateScore")
        self._conf(["UserID:", "Score:"], "#afdfe4")

    def update_by_uid(self):
        uid = self.enter[0].get()
        score = int(self.enter[1].get())
        event = tk_event.UpdateUserScoreEvent(self.station).start(score, f"UserID='{uid}'")
        self.station.push_event(event)

    def update_by_where(self):
        where = self.where_enter[0].get()
        score = int(self.where_enter[1].get())
        event = tk_event.UpdateUserScoreEvent(self.station).start(score, where)
        self.station.push_event(event)


class UpdateUserReputationBase(UpdateUserProgramBase):
    def __init__(self, station, win, color):
        super(UpdateUserReputationBase, self).__init__(station, win, color, "UpdateReputation")
        self._conf(["UserID:", "Reputation:"], "#f8aba6")

    def update_by_uid(self):
        uid = self.enter[0].get()
        reputation = int(self.enter[1].get())
        event = tk_event.UpdateUserReputationEvent(self.station).start(reputation, f"UserID='{uid}'")
        self.station.push_event(event)

    def update_by_where(self):
        where = self.where_enter[0].get()
        reputation = int(self.where_enter[1].get())
        event = tk_event.UpdateUserReputationEvent(self.station).start(reputation, where)
        self.station.push_event(event)


class UpdateGarbageTypeProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "UpdateGarbageType")

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.type: List[tk.Radiobutton] = [tk.Radiobutton(self.frame) for _ in range(4)]
        self.var: List[tk.Variable] = [tk.StringVar, tk.IntVar()]

        self.where_frame = tk.Frame(self.frame)
        self.where_title: tk.Label = tk.Label(self.where_frame)
        self.where_enter: tk.Entry = tk.Entry(self.where_frame)
        self.where_type: List[tk.Radiobutton] = [tk.Radiobutton(self.frame) for _ in range(4)]
        self.where_var: List[tk.Variable] = [tk.StringVar, tk.IntVar()]

        self.btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.where_frame['bg'] = "#fdb933"
        self.where_frame['bd'] = 5
        self.where_frame['relief'] = "ridge"
        self.where_frame.place(relx=0.2, rely=0.20, relwidth=0.6, relheight=0.10)

        self.enter_frame['bg'] = "#fdb933"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.60, relwidth=0.6, relheight=0.10)

        for lb, enter, radios, var, y, text in zip([self.title, self.where_title],
                                                   [self.enter, self.where_enter],
                                                   [self.type, self.where_type],
                                                   [self.var, self.where_var],
                                                   [0.32, 0.72],
                                                   ["GarbageID:", "Where:"]):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#fdb933"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var[0]

            for i, radio in enumerate(radios):
                radio['font'] = btn_font
                radio['bg'] = self.color
                radio['text'] = GarbageType.GarbageTypeStrList[i + 1]
                radio['value'] = i + 1
                radio['variable'] = var[1]
                radio['anchor'] = 'w'

            var[1].set(1)
            radios[0].place(relx=0.20, rely=y + 0.00, relwidth=0.20, relheight=0.04)
            radios[1].place(relx=0.60, rely=y + 0.00, relwidth=0.20, relheight=0.04)
            radios[2].place(relx=0.20, rely=y + 0.05, relwidth=0.20, relheight=0.04)
            radios[3].place(relx=0.60, rely=y + 0.05, relwidth=0.20, relheight=0.04)

            lb.place(relx=0.02, rely=0.2, relwidth=0.25, relheight=0.48)
            enter.place(relx=0.30, rely=0.2, relwidth=0.60, relheight=0.48)

        for btn, text, func in zip(self.btn,
                                   ["Update Advanced", "Update By GarbageID"],
                                   [self.update_by_where, self.update_by_gid]):
            btn['font'] = btn_font
            btn['text'] = text
            btn['bg'] = conf.tk_btn_bg
            btn['command'] = func

        self.btn[0].place(relx=0.55, rely=0.43, relwidth=0.25, relheight=0.08)
        self.btn[1].place(relx=0.55, rely=0.83, relwidth=0.25, relheight=0.08)

    def update_by_gid(self):
        gid = self.enter.get()
        type_ = self.var[1].get()
        event = tk_event.UpdateGarbageTypeEvent(self.station).start(type_, f"GarbageID={gid}")
        self.station.push_event(event)

    def update_by_where(self):
        where = self.where_enter.get()
        type_ = self.where_var[1].get()
        event = tk_event.UpdateGarbageTypeEvent(self.station).start(type_, where)
        self.station.push_event(event)

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        self.enter['state'] = 'disable'
        self.where_enter['state'] = 'normal'

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        self.enter['state'] = 'normal'
        self.where_enter['state'] = 'normal'


class UpdateGarbageCheckResultProgram(AdminProgram):
    def __init__(self, station, win, color):
        super().__init__(station, win, color, "UpdateGarbageCheckResult")

        self.enter_frame = tk.Frame(self.frame)
        self.title: tk.Label = tk.Label(self.enter_frame)
        self.enter: tk.Entry = tk.Entry(self.enter_frame)
        self.type: List[tk.Radiobutton] = [tk.Radiobutton(self.frame) for _ in range(2)]
        self.var: List[tk.Variable] = [tk.StringVar, tk.IntVar()]

        self.where_frame = tk.Frame(self.frame)
        self.where_title: tk.Label = tk.Label(self.where_frame)
        self.where_enter: tk.Entry = tk.Entry(self.where_frame)
        self.where_type: List[tk.Radiobutton] = [tk.Radiobutton(self.frame) for _ in range(2)]
        self.where_var: List[tk.Variable] = [tk.StringVar, tk.IntVar()]

        self.btn: List[tk.Button] = [tk.Button(self.frame), tk.Button(self.frame)]
        self.__conf_font()

    def __conf_font(self, n: int = 1):
        self.title_font_size = int(16 * n)
        self.btn_font_size = int(14 * n)

    def conf_gui(self, n: int = 1):
        self.__conf_font(n)

        title_font = make_font(size=self.title_font_size)
        btn_font = make_font(size=self.btn_font_size)

        self.where_frame['bg'] = "#abc88b"
        self.where_frame['bd'] = 5
        self.where_frame['relief'] = "ridge"
        self.where_frame.place(relx=0.2, rely=0.20, relwidth=0.6, relheight=0.10)

        self.enter_frame['bg'] = "#abc88b"
        self.enter_frame['bd'] = 5
        self.enter_frame['relief'] = "ridge"
        self.enter_frame.place(relx=0.2, rely=0.60, relwidth=0.6, relheight=0.10)

        for lb, enter, radios, var, y, text in zip([self.title, self.where_title],
                                                   [self.enter, self.where_enter],
                                                   [self.type, self.where_type],
                                                   [self.var, self.where_var],
                                                   [0.32, 0.72],
                                                   ["GarbageID:", "Where:"]):
            lb['font'] = title_font
            lb['text'] = text
            lb['bg'] = "#abc88b"
            lb['anchor'] = 'e'

            enter['font'] = title_font
            enter['textvariable'] = var[0]

            for i, radio in enumerate(radios):
                radio['font'] = btn_font
                radio['bg'] = self.color
                radio['text'] = ["Fail", "Pass"][i]
                radio['value'] = i
                radio['variable'] = var[1]
                radio['anchor'] = 'w'

            var[1].set(1)
            radios[0].place(relx=0.20, rely=y + 0.00, relwidth=0.20, relheight=0.04)
            radios[1].place(relx=0.60, rely=y + 0.00, relwidth=0.20, relheight=0.04)

            lb.place(relx=0.02, rely=0.2, relwidth=0.25, relheight=0.48)
            enter.place(relx=0.30, rely=0.2, relwidth=0.60, relheight=0.48)

        for btn, text, func in zip(self.btn,
                                   ["Update Advanced", "Update By GarbageID"],
                                   [self.update_by_where, self.update_by_gid]):
            btn['font'] = btn_font
            btn['bg'] = conf.tk_btn_bg
            btn['text'] = text
            btn['command'] = func

        self.btn[0].place(relx=0.55, rely=0.38, relwidth=0.25, relheight=0.08)
        self.btn[1].place(relx=0.55, rely=0.78, relwidth=0.25, relheight=0.08)

    def update_by_gid(self):
        gid = self.enter.get()
        check = (self.var[1].get() == 1)
        event = tk_event.UpdateGarbageCheckEvent(self.station).start(check, f"GarbageID={gid}")
        self.station.push_event(event)

    def update_by_where(self):
        where = self.where_enter.get()
        check = (self.where_var[1].get() == 1)
        event = tk_event.UpdateGarbageCheckEvent(self.station).start(check, where)
        self.station.push_event(event)

    def set_disable(self):
        set_tk_disable_from_list(self.btn)
        self.enter['state'] = 'disable'
        self.where_enter['state'] = 'normal'

    def reset_disable(self):
        set_tk_disable_from_list(self.btn, flat='normal')
        self.enter['state'] = 'normal'
        self.where_enter['state'] = 'normal'


all_program = [WelcomeProgram, CreateNormalUserProgram, CreateManagerUserProgram, CreateAutoNormalUserProgram,
               CreateGarbageProgram, DeleteUserProgram, DeleteUsersProgram, DeleteGarbageProgram,
               DeleteGarbageMoreProgram, DeleteAllGarbageProgram, SearchUserProgram, SearchUserAdvancedProgram,
               SearchGarbageProgram, SearchGarbageAdvancedProgram, SearchAdvancedProgram, UpdateUserScoreBase,
               UpdateUserReputationBase, UpdateGarbageTypeProgram, UpdateGarbageCheckResultProgram,
               ExportGarbageProgram, ExportUserProgram, CreateUserFromCSVProgram, AboutProgram]