G01_0350/inquire.py

from tkinter import *
from tkinter import filedialog
from tkinter.ttk import Treeview
from tkcalendar import Calendar, DateEntry
import app
import time
import param
import tkinter.messagebox
import sql
import output_file
import datetime
import _thread

class my_inquire(Frame):
    def __init__(self, init_window_name):
        self.init_window_name = init_window_name
        self.user_var = app.user_var
        self.screen_width = self.user_var.screen_width
        self.screen_height = self.user_var.screen_height
        self.font_size_title = app.font_size_title
        self.font_size_text = app.font_size_text
        self.sqlclient = sql.sqlclient
        self.main_gui_init()
        self.title_canvas_init()
        self.button_canvas_init()
        self.user_frame_init()
        self.view_timeout = 180
        self.user_var.windows_idx = 'inquire'
        self.fun_timer()

    def main_button_event(self):
        self.user_var.last_windows_idx = 'inquire'
        self.init_window_name.after_cancel(self.task_user)
        self.main_frame.destroy()
        app.my_gui(self.init_window_name)

    def param_button_event(self):
        print("Enter Param Set!")
        self.user_var.last_windows_idx = 'inquire'
        self.init_window_name.after_cancel(self.task_user)
        self.main_frame.destroy()
        param.my_param(self.init_window_name)

    def authstatlabel_value(self):
        if self.user_var.auth_stat == False:
            self.param_button.configure(state="disabled")
        else:
            self.param_button.configure(state="normal")

    def auth_exit(self):
        if self.user_var.auth_timeout > 0:
            self.user_var.auth_timeout = self.user_var.auth_timeout - 1
        else:
            self.user_var.auth_stat = False

    def view_exit(self):
        if self.view_timeout > 0:
            self.view_timeout = self.view_timeout - 1
        else:
            self.user_var.last_windows_idx = 'param'
            self.init_window_name.after_cancel(self.task_user)
            self.main_frame.destroy()
            app.my_gui(self.init_window_name)

    def listview_update(self):
        if self.user_var.listview_stat == True:
            self.user_var.listview_stat = False
            if self.user_var.listview_content == "DATA":
                self.set_data_listview()
            elif self.user_var.listview_content == "PARAM":
                self.set_param_listview()
            self.user_var.listview_lock = False
            self.read_data_delay_label("数据已生成。。。", 'green')

    def windows_update(self):
        currentTime = time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(time.time()))
        self.timelabel.config(text=currentTime)
        self.auth_exit()
        self.init_window_name.update()
        self.fun_timer()
        self.authstatlabel_value()
        self.view_exit()
        self.listview_update()

    def fun_timer(self):
        self.task_user=self.init_window_name.after(1000, self.windows_update)

    def main_gui_init(self):
        self.main_frame = Frame(self.init_window_name, width=self.screen_width, height=self.screen_height)
        self.main_frame.pack()

    # 标题栏
    def title_canvas_init(self):
        self.title_canvas = Canvas(self.main_frame, width=self.screen_width - 20, height=35, bg='SeaGreen')
        self.mainlabel = Label(self.title_canvas, text="气密检查记录查询", fg='SkyBlue', font=("宋体", self.font_size_title),
                               bg='SeaGreen', anchor='c')
        self.mainlabel.place(x=self.title_canvas.winfo_reqwidth()/2-self.mainlabel.winfo_reqwidth()/2, y=5)
        self.timelabel = Label(self.title_canvas, text=time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(time.time())),
                               fg='yellow', font=("宋体", self.font_size_title), bg='SeaGreen', anchor='e')
        self.timelabel.place(x=self.title_canvas.winfo_reqwidth() - self.timelabel.winfo_reqwidth() - 20, y=5)
        self.title_canvas.create_line(self.mainlabel.winfo_reqwidth() / 2 + 20, 32, self.title_canvas.winfo_reqwidth() -
                                      self.timelabel.winfo_reqwidth() / 2 - 20, 32, fill='white')
        self.title_canvas.place(x=10, y=10)

    # 控制栏
    def button_canvas_init(self):
        self.button_canvas = Canvas(self.main_frame, width=self.screen_width - 20, height=40)
        self.main_button = Button(self.button_canvas, text="主界面", fg='white', bg='DeepSkyBlue', width=8,
                                  activebackground='white', activeforeground='DeepSkyBlue',
                                  font=("宋体", self.font_size_title, "bold"), command=self.main_button_event)
        self.main_button.place(x=1, y=0)
        self.param_button = Button(self.button_canvas, text="参数设定", fg='white', bg='DeepSkyBlue', width=8,
                                   activebackground='white', activeforeground='DeepSkyBlue', state="disabled",
                                   font=("宋体", self.font_size_title, "bold"), command=self.param_button_event)
        self.param_button.place(x=110, y=0)

        self.delaylabel = Label(self.button_canvas, fg='green', font=("宋体", self.font_size_title, "bold"),
                                text="无数据。。。", anchor='w', )
        self.delaylabel.place(x=self.button_canvas.winfo_reqwidth() - 200, y=10)

        self.button_canvas.place(x=10, y=self.screen_height - 60)

    def return_button_event(self):
        if self.user_var.last_windows_idx == 'param':
            self.user_var.last_windows_idx = 'production'
            self.init_window_name.after_cancel(self.task_user)
            self.main_frame.destroy()
            param.my_param(self.init_window_name)
        else:
            self.user_var.last_windows_idx = 'production'
            self.init_window_name.after_cancel(self.task_user)
            self.main_frame.destroy()
            app.my_gui(self.init_window_name)

    def get_begin_data_event(self, event):
        if self.cal_begin.get_date() <= self.cal_end.get_date():
            self.user_var.inquire_begin_data = self.cal_begin.get_date()
            print(self.user_var.inquire_begin_data)
        else:
            tkinter.messagebox.showwarning(title='提示', message='开始日期大于结束日子！')
            self.cal_begin.set_date(self.user_var.inquire_begin_data)

    def get_end_data_event(self, event):
        if self.cal_begin.get_date() <= self.cal_end.get_date():
            self.user_var.inquire_end_data = self.cal_end.get_date()
            print(self.user_var.inquire_end_data)
        else:
            tkinter.messagebox.showwarning(title='提示', message='开始日期大于结束日子！')
            self.cal_end.set_date(self.user_var.inquire_end_data)

    def airparam_button_event(self):
        print("气密参数查询！")
        if self.user_var.listview_lock == False:
            self.user_var.file_name = "气密参数"
            self.user_var.listview_content = "PARAM"
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.clear_listview()

            thread_savefile = output_file.output_file(10, "Thread-output", 3, 'inquire_param')
            thread_savefile.start()
            self.read_data_delay_label("数据生成中。。。", 'red')
            self.user_var.listview_lock = True
        else:
            tkinter.messagebox.showwarning(title='提示', message='数据查询中。。。')

        
    def thatday_button_event(self):
        print("当天数据查询！")
        if self.user_var.listview_lock == False:
            self.user_var.file_name = "当天数据{0}".format(datetime.datetime.now().strftime('%Y%m%d%H%M%S'))
            self.user_var.listview_content = "DATA"
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.clear_listview()
            now_time = int(time.time())
            day_time = now_time - now_time % 86400

            wherestr = "WHERE end_time >= {0} and end_time <= {1}".format(day_time, day_time + 86400)
            thread_savefile = output_file.output_file(10, "Thread-output", 3, 'inquire_data', datastr=wherestr)
            thread_savefile.start()
            self.read_data_delay_label("数据生成中。。。", 'red')
            self.user_var.listview_lock = True
        else:
            tkinter.messagebox.showwarning(title='提示', message='数据查询中。。。')


    def excel_button_event(self):
        print("导出excel！")
        if self.user_var.file_save_stat == True:
            fn = filedialog.asksaveasfilename(title='另存为', initialfile=self.user_var.file_name, defaultextension=".xls",
                                              filetypes=[('xls文件', '.xls')])
            if fn:
                content = self.user_var.product_data.copy()
                if self.user_var.listview_content == "DATA":
                    content.insert(0, self.user_var.data_headers)
                elif self.user_var.listview_content == "PARAM":
                    content.insert(0, self.user_var.param_headers)

                self.user_var.file_save_stat = False
                thread_savefile = output_file.output_file(10, "Thread-output", 3, 'save_excel', filepath=fn,
                                                          content=content)
                thread_savefile.start()
        else:
            tkinter.messagebox.showwarning(title='提示', message='文件生成中！')


    def clear_button_event(self):
        print("清除显示！")
        if self.user_var.listview_lock == False:
            self.user_var.listview_content = "NULL"
            self.clear_listview()
            self.excel_button.configure(state="disable")
            self.pdf_button.configure(state="disable")
            self.read_data_delay_label("无数据。。。", 'green')

    def days_button_event(self):
        print("多天数据！")
        if self.user_var.listview_lock == False:
            self.user_var.listview_content = "DATA"
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.clear_listview()
            begintime = int(time.mktime(time.strptime("{0} 00:00:00".format(
                self.user_var.inquire_begin_data), "%Y-%m-%d %H:%M:%S")))

            endtime = int(time.mktime(time.strptime("{0} 23:59:59".format(
                self.user_var.inquire_end_data), "%Y-%m-%d %H:%M:%S")))

            self.user_var.file_name = "多天数据{0}-{1}".format(time.strftime("%Y%m%d", time.localtime(begintime)),
                                                           time.strftime("%Y%m%d", time.localtime(endtime)))
            wherestr = "WHERE end_time >= {0} and end_time <= {1}".format(begintime, endtime)
            thread_savefile = output_file.output_file(10, "Thread-output", 3, 'inquire_data', datastr=wherestr)
            thread_savefile.start()
            self.read_data_delay_label("数据生成中。。。", 'red')
            self.user_var.listview_lock = True
        else:
            tkinter.messagebox.showwarning(title='提示', message='数据查询中。。。')


    def all_button_event(self):
        print("全部数据！")
        if self.user_var.listview_lock == False:
            self.user_var.file_name = "全部数据{0}".format(datetime.datetime.now().strftime('%Y%m%d%H%M%S'))
            self.user_var.listview_content = "DATA"
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.clear_listview()
            thread_savefile = output_file.output_file(10, "Thread-output", 3, 'inquire_data')
            thread_savefile.start()
            self.read_data_delay_label("数据生成中。。。", 'red')
            self.user_var.listview_lock = True
        else:
            tkinter.messagebox.showwarning(title='提示', message='数据查询中。。。')


    def pdf_button_event(self):
        print("导出pdf！")
        if self.user_var.file_save_stat == True:
            fn = filedialog.asksaveasfilename(title='另存为', initialfile=self.user_var.file_name, defaultextension=".pdf",
                                              filetypes=[('pdf文件', '.pdf')])
            if fn:
                content = self.user_var.product_data.copy()
                if self.user_var.listview_content == "DATA":
                    content.insert(0, self.user_var.data_headers)
                elif self.user_var.listview_content == "PARAM":
                    content.insert(0, self.user_var.param_headers)
                self.user_var.file_save_stat = False
                thread_savefile = output_file.output_file(10, "Thread-output", 3, 'save_pdf', filepath=fn,
                                                          content=content)
                thread_savefile.start()
        else:
            tkinter.messagebox.showwarning(title='提示', message='文件生成中！')

    def label_button_event(self):
        print("标签查询！")
        if self.user_var.listview_lock == False:
            self.user_var.listview_content = "DATA"
            txt = self.labeltext.get().strip()
            self.labeltext.config(text=txt)
            if txt != '' and len(txt) == 12:
                self.excel_button.configure(state="normal")
                self.pdf_button.configure(state="normal")
                self.clear_listview()
                wherestr = "WHERE batch = '{0}'".format(txt)
                thread_savefile = output_file.output_file(10, "Thread-output", 3, 'inquire_data', datastr=wherestr)
                thread_savefile.start()
                self.user_var.listview_lock = True
                self.user_var.file_name = "标签数据txt"
            else:
                tkinter.messagebox.showwarning(title='提示', message='请输入12位标签号！')
        else:
            tkinter.messagebox.showwarning(title='提示', message='数据查询中。。。')

    def read_data_delay_label(self, txt, color):
            self.delaylabel.configure(text=txt)
            self.delaylabel.configure(fg=color)

    def clear_listview(self):
        for widget in self.treeview_frame.winfo_children():
            widget.destroy()

    def set_param_listview(self):
        widths = (100, 130, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80)

        # 构建控件
        data_listview = Treeview(self.treeview_frame, columns=self.user_var.param_columns, show='headings')

        data_listview.column("#0", width=2, minwidth=1, stretch=YES)
        idx =1
        for column in self.user_var.param_columns:
            data_listview.column('#{0}'.format(idx), width=widths[idx - 1], minwidth=widths[idx - 1],
                                      stretch=YES, anchor=CENTER)
            idx = idx + 1

        idx = 1
        for header in self.user_var.param_headers:
            data_listview.heading('#{0}'.format(idx), text='{0}'.format(header), anchor=CENTER)
            idx = idx + 1

        for i, person in enumerate(self.user_var.product_data):
            data_listview.insert('', i, values=person)

        # 构建垂直Scrollbar
        scroll_y = Scrollbar(self.treeview_frame, orient=VERTICAL, command=data_listview.yview)
        # 设定控件布局
        scroll_y.pack(side='right', fill='y', padx=1, pady=1, ipadx=1, ipady=1)
        # 绑定滚动动作
        data_listview.configure(yscrollcommand=scroll_y.set)

        # 构建水平Scrollbar
        scroll_x = Scrollbar(self.treeview_frame, orient=HORIZONTAL, command=data_listview.xview)
        # 设定控件布局
        scroll_x.pack(side='bottom', fill='x', padx=1, pady=1, ipadx=1, ipady=1)
        # 绑定滚动动作
        data_listview.configure(xscrollcommand=scroll_x.set)

        # 设定控件布局
        data_listview.pack(side='left', fill='both', padx=1, pady=1, ipadx=1, ipady=1)


    def set_data_listview(self):
        widths = (80, 60, 100, 100, 60, 250, 50, 130, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80)

        # 构建控件
        data_listview = Treeview(self.treeview_frame, columns=self.user_var.data_columns, show='headings')

        data_listview.column("#0", width=2, minwidth=1, stretch=YES)
        idx =1
        for column in self.user_var.data_columns:
            data_listview.column('#{0}'.format(idx), width=widths[idx - 1], minwidth=widths[idx - 1],
                                      stretch=YES, anchor=CENTER)
            idx = idx + 1

        idx = 1
        for header in self.user_var.data_headers:
            data_listview.heading('#{0}'.format(idx), text='{0}'.format(header), anchor=CENTER)
            idx = idx + 1

        for i, person in enumerate(self.user_var.product_data):
            data_listview.insert('', i, values=person)

        # 构建垂直Scrollbar
        scroll_y = Scrollbar(self.treeview_frame, orient=VERTICAL, command=data_listview.yview)
        # 设定控件布局
        scroll_y.pack(side='right', fill='y', padx=1, pady=1, ipadx=1, ipady=1)
        # 绑定滚动动作
        data_listview.configure(yscrollcommand=scroll_y.set)

        # 构建水平Scrollbar
        scroll_x = Scrollbar(self.treeview_frame, orient=HORIZONTAL, command=data_listview.xview)
        # 设定控件布局
        scroll_x.pack(side='bottom', fill='x', padx=1, pady=1, ipadx=1, ipady=1)
        # 绑定滚动动作
        data_listview.configure(xscrollcommand=scroll_x.set)

        # 设定控件布局
        data_listview.pack(side='left', fill='both', padx=1, pady=1, ipadx=1, ipady=1)

    # 输入栏
    def user_frame_init(self):
        self.order_frame = Frame(
            self.main_frame, width=self.screen_width - 20, relief=SUNKEN, borderwidth=2,
            height=self.screen_height - self.title_canvas.winfo_reqheight() - self.button_canvas.winfo_reqheight() - 35)

        # 工单栏展示
        self.order_frame.place(x=12, y=self.title_canvas.winfo_reqheight() + 15)

        self.operate_frame = Frame(
            self.order_frame, width=990, borderwidth=0,
            height=110)

        self.operate_frame.pack(side='top', padx=1, pady=1, ipadx=2, ipady=2)

        self.return_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                      width=117, height=33)
        self.return_button = Button(self.return_button_canvas, text="返回", fg='black', bg='white', width=11,
                                  activebackground='black', activeforeground='white',
                                  font=("宋体", self.font_size_text, "bold"), command=self.return_button_event)
        self.return_button.place(x=7, y=7)
        self.return_button_canvas.place(x=50, y=5)

        self.airparam_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                           width=117, height=33)
        self.airparam_button = Button(self.airparam_button_canvas, text="气密参数查询", fg='black', bg='white', width=11,
                                    activebackground='black', activeforeground='white',
                                    font=("宋体", self.font_size_text, "bold"), command=self.airparam_button_event)
        self.airparam_button.place(x=7, y=7)
        self.airparam_button_canvas.place(x=170, y=5)

        self.thatday_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                           width=117, height=33)
        self.thatday_button = Button(self.thatday_button_canvas, text="当天数据", fg='black', bg='white', width=11,
                                    activebackground='black', activeforeground='white',
                                    font=("宋体", self.font_size_text, "bold"), command=self.thatday_button_event)
        self.thatday_button.place(x=7, y=7)
        self.thatday_button_canvas.place(x=290, y=5)

        self.excel_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                           width=117, height=33)
        self.excel_button = Button(self.excel_button_canvas, text="导出数据", fg='black', bg='white', width=11,
                                    activebackground='black', activeforeground='white', state="disabled",
                                    font=("宋体", self.font_size_text, "bold"), command=self.excel_button_event)
        self.excel_button.place(x=7, y=7)
        self.excel_button_canvas.place(x=410, y=5)

        self.clear_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                           width=117, height=33)
        self.clear_button = Button(self.clear_button_canvas, text="清除显示", fg='black', bg='white', width=11,
                                    activebackground='black', activeforeground='white',
                                    font=("宋体", self.font_size_text, "bold"), command=self.clear_button_event)
        self.clear_button.place(x=7, y=7)
        self.clear_button_canvas.place(x=50, y=40)

        self.days_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                          width=117, height=33)
        self.days_button = Button(self.days_button_canvas, text="多天数据", fg='black', bg='white', width=11,
                                   activebackground='black', activeforeground='white',
                                   font=("宋体", self.font_size_text, "bold"), command=self.days_button_event)
        self.days_button.place(x=7, y=7)
        self.days_button_canvas.place(x=170, y=40)

        self.all_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                            width=117, height=33)
        self.all_button = Button(self.all_button_canvas, text="全部数据", fg='black', bg='white', width=11,
                                     activebackground='black', activeforeground='white',
                                     font=("宋体", self.font_size_text, "bold"), command=self.all_button_event)
        self.all_button.place(x=7, y=7)
        self.all_button_canvas.place(x=290, y=40)

        self.pdf_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                          width=117, height=33)
        self.pdf_button = Button(self.pdf_button_canvas, text="导出pdf", fg='black', bg='white', width=11,
                                   activebackground='black', activeforeground='white', state="disabled",
                                   font=("宋体", self.font_size_text, "bold"), command=self.pdf_button_event)
        self.pdf_button.place(x=7, y=7)
        self.pdf_button_canvas.place(x=410, y=40)

        self.labeltitle = Label(self.operate_frame, text="输入查询的标签", font=("宋体", self.font_size_text), anchor='e')
        self.labeltitle.place(x=self.operate_frame.winfo_reqwidth() - self.labeltitle.winfo_reqwidth() - 50, y=5)

        self.labeltext = Entry(self.operate_frame, font=("宋体", self.font_size_text), fg="darkgoldenrod", bg="SkyBlue",
                               width=20, justify='center')

        self.labeltext.place(x=self.operate_frame.winfo_reqwidth() - self.labeltext.winfo_reqwidth() - 28, y=30)

        self.label_button_canvas = Canvas(self.operate_frame, bg='DarkGray', relief=SOLID, borderwidth=1,
                                        width=117, height=33)
        self.label_button = Button(self.label_button_canvas, text="查看label", fg='black', bg='white', width=11,
                                 activebackground='black', activeforeground='white',
                                 font=("宋体", self.font_size_text, "bold"), command=self.label_button_event)
        self.label_button.place(x=7, y=7)
        self.label_button_canvas.place(
            x=self.operate_frame.winfo_reqwidth() - self.label_button_canvas.winfo_reqwidth() - 40, y=55)

        self.datatitlelabel = Label(self.operate_frame, text="气密数据查询列表", fg='dodgerblue',
                                    font=("宋体", self.font_size_text),
                                    anchor='w')
        self.datatitlelabel.place(x=self.operate_frame.winfo_reqwidth() / 2 - self.datatitlelabel.winfo_reqwidth() / 2,
                                  y=80)

        self.calbegin_canvas = Canvas(self.operate_frame, bg='white', relief=SOLID, borderwidth=1,
                                          width=180, height=33)
        self.calbegintitlelabel = Label(self.calbegin_canvas, text="起始：", fg='dodgerblue', bg='white',
                                    font=("宋体", self.font_size_text),
                                    anchor='w')
        self.calbegintitlelabel.place(x=10, y=10)
        self.cal_begin = DateEntry(self.calbegin_canvas, locale='zh_CN', width=12, background='darkblue',
                        foreground='white', borderwidth=2)
        self.cal_begin.place(x=65, y=8)
        self.cal_begin.bind("<<DateEntrySelected>>", self.get_begin_data_event)
        self.calbegin_canvas.place(
            x=550, y=5)

        self.calend_canvas = Canvas(self.operate_frame, bg='white', relief=SOLID, borderwidth=1,
                                      width=180, height=33)
        self.calendtitlelabel = Label(self.calend_canvas, text="结束：", fg='dodgerblue', bg='white',
                                        font=("宋体", self.font_size_text),
                                        anchor='w')
        self.calendtitlelabel.place(x=10, y=10)
        self.cal_end = DateEntry(self.calend_canvas, locale='zh_CN', width=12, background='darkblue',
                                   foreground='white', borderwidth=2)
        self.cal_end.place(x=65, y=8)
        self.cal_end.bind("<<DateEntrySelected>>", self.get_end_data_event)
        self.calend_canvas.place(
            x=550, y=40)

        self.treeview_frame = Frame(self.order_frame, bg='white', relief=SOLID, borderwidth=1,
                                    width=990, height=350)
        self.treeview_frame.pack(side='bottom', padx=2, pady=2, ipadx=2, ipady=2)
        self.treeview_frame.pack_propagate(0)

        if self.user_var.listview_content == "DATA":
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.set_data_listview()
            self.read_data_delay_label("数据已生成。。。", 'green')

        elif self.user_var.listview_content == "PARAM":
            self.excel_button.configure(state="normal")
            self.pdf_button.configure(state="normal")
            self.set_param_listview()
            self.read_data_delay_label("数据已生成。。。", 'green')


# t = time.time()
#
# print (t)                       #原始时间数据
# print (int(t))                  #秒级时间戳
# print (int(round(t * 1000)))    #毫秒级时间戳
# print (int(round(t * 1000000))) #微秒级时间戳

# dt = '2018-01-01 10:40:30'
# ts = int(time.mktime(time.strptime(dt, "%Y-%m-%d %H:%M:%S")))
# print (ts)
# ts = 1515774430
# dt = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(ts))
# print(dt)