質問編集履歴

質問内容を更新しました。

2021/10/29 11:43

投稿

hinata_0123

スコア1

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -2,361 +2,365 @@
 コード
+import tkinter as tk
+# tkinterモジュールをtkとしてインポート
+import tkinter.ttk as ttk
+# tkinterのttkをttkとしてインポート
+import matplotlib.pyplot as plt
+# matplotlibモジュールのpyplotをpltとしてインポート
+from matplotlib.backends.backend_tkagg import (
+    FigureCanvasTkAgg, NavigationToolbar2Tk)
+# FigureCanvasTkAggとNavigationToolbar2Tkのインポート
+from random import random
+# randomモジュールからrandom関数をインポート
+from datetime import datetime
+               # datetimeモジュールからdatetime関数のインポート
+from functools import partial
+# functoolsモジュールからpartialのインポート
+import pymysql.cursors
+# pymysqlモジュールのcursorsをインポート
+#--------------------------------------------------------------------
+def select(yyyy,MM,dd,lid):  # select関数
+  connection = pymysql.connect(
+    host='localhost',
+    user='hit',
+    password='hit',
+    db='THT',
+    charset='utf8',
+    cursorclass=pymysql.cursors.DictCursor)
+  with connection.cursor() as cursor:
+    FROM = yyyy+"-"+MM+"-"+dd+" 00:00:00"
+    TO   = yyyy+"-"+MM+"-"+dd+" 23:00:00"
+    sql = "select * from thData where lid="+str(lid)
+    sql += " and date>='"+FROM+"' and date<='"+TO+"'"
+    print("sql=",sql)
+    cursor.execute(sql)
+    results = cursor.fetchall()
+    #for r in results:  print(r)
+  return results
+#--------------------------------------------------------------------
+def make_graph():    # make_graph関数
+  #print("<< make_graph start >>")
+  x  = [0]*24
+  y1 = [None]*24
+  y2 = [0]*24
+  yyyy = cb1.get()
+  m = int(cb2.get())
+  d = int(cb3.get())
+  MM = "{:02d}".format(m)
+  dd = "{:02d}".format(d)
+  lid = 1
+  #print("yyyy=",yyyy," ",type(yyyy))
+  #print("MM=",MM," ",type(MM))
+  #print("dd=",dd," ",type(dd))
+  #--------------------------------
+  results = select(yyyy,MM,dd,lid)
+  #--------------------------------
+  for i in range(0,24): x[i]=i
+  num = len(results)
+  print("num=",num)
+  if num == 0:  y1 = [None]*24
+  for i in range(num):
+    if i > 23: break
+    temp = results[i].get('temp')
+    hcount = results[i].get('hcount')
+    print(i," ",temp," ",hcount)
+    y1[i] = temp
+    y2[i] = hcount
+  ax1.cla()
+  ax1.set_xlabel('Hour (H)')
+  ax1.set_ylabel('Temperature (deg)')
+  ax1.set_ylim(-5,25)
+  ax1.plot(x,y1,color="blue",marker="o")
+  ax2.cla()
+  ax2.set_ylabel('Human detected (number)',color="red")
+  ax2.set_ylim(0,65)
+  ax2.bar(x,y2,color="red")
+  canvas.draw()
+  #print("<< make_graph end >>")
+#-----------------------------------------------------------------
+x  = [0]*24
+y1 = [None]*24
+y2 = [0]*24
+root = tk.Tk()
+root.title("TEST")
+root.geometry("650x580")
+frame1 = tk.LabelFrame(
+root,labelanchor="nw",
+text="Temperture & Human Sensor",foreground="green")
+# フレーム１
+frame1.grid(rowspan=2,column=0)
+frame2=tk.LabelFrame(root,text="Control", foreground="red")
+frame2.grid(row=2,column=0,sticky="nwse")
+fig = plt.Figure()
+ax1 = fig.add_subplot(111)
+ax1.plot(x,y1)
+ax1.set_xlabel('Hour (H)')
+ax1.set_ylabel('Temperature (deg)')
+ax1.set_ylim(-5,25)
+ax2 = ax1.twinx()
+ax2.bar(x,y2,color="red")
+ax2.set_ylabel('Human detected (number)',color="red")
+ax2.set_ylim(0,65)
+canvas = FigureCanvasTkAgg(fig, master=frame1)
+# キャンバスのインスタンス化
+canvas.get_tk_widget().pack(side=tk.TOP, fill=tk.BOTH, expand=1)
+now = datetime.now()
+date = "{:%Y-%m-%d}".format(now)
+month = now.month
+day = now.day
+years = ["2020","2021","2022","2023","2024","2025"]
+# 年（コンボボックス）
+months = [1]*12
+for i in range(12) : months[i]=i+1
+days = [1]*31
+for i in range(31) : days[i]=i+1
+devices = ["810C3B31","790A2D12"]
+lb1 = tk.Label(frame2, text="year:",bg="cyan")
+cb1 = ttk.Combobox(frame2, values=years,width=6,justify=tk.CENTER)
+cb1.current(0)
+lb2 = tk.Label(frame2, text="month:",bg="cyan")
+cb2 = ttk.Combobox(frame2, values = months,width=6,justify=tk.CENTER)
+cb2.current(month-1)
+lb3 = tk.Label(frame2, text="day:",bg="cyan")  # ラベル３（lb3）
+cb3 = ttk.Combobox(frame2, values = days,width=6,justify=tk.CENTER)
+cb3.current(day-1)
+lb4 = tk.Label(frame2, text="Device ID :",bg="cyan")
+cb4 = ttk.Combobox(frame2, values= devices,width=6,justify=tk.CENTER)
+cb4.current(0)
+y = cb1.current()
+m = cb2.current()
+d = cb3.current()
+selected_date = str(years[y])+"-"+str(months[m])+"-"+str(days[d])
+print("selected_date=",selected_date)
+print("cb1=",cb1.get()," ",end="")
+print("cb2=",cb2.get()," ",end="")
+print("cb3=",cb3.get())
+bt1 = tk.Button(frame2, text="Display", bg="yellow",command=make_graph)
+lb1.grid(row=1, column=0 ,padx=5, pady=5)
+cb1.grid(row=1, column=1 ,padx=5, pady=5)
+lb2.grid(row=1, column=2 ,padx=5, pady=5)
+cb2.grid(row=1, column=3 ,padx=5, pady=5)
+lb3.grid(row=1, column=4 ,padx=5, pady=5)
+cb3.grid(row=1, column=5 ,padx=5, pady=5)
+lb4.grid(row=1, column=6 ,padx=5, pady=5)
+cb4.grid(row=1, column=7 ,padx=5, pady=5)
+bt1.grid(row=1, column=8 ,padx=5, pady=5)
+make_graph()
+root.mainloop()
 ```
-import tkinter as tk
-# tkinterモジュールをtkとしてインポート
-import tkinter.ttk as ttk
-# tkinterのttkをttkとしてインポート
-import matplotlib.pyplot as plt
-# matplotlibモジュールのpyplotをpltとしてインポート
-from matplotlib.backends.backend_tkagg import (
-    FigureCanvasTkAgg, NavigationToolbar2Tk)
-# FigureCanvasTkAggとNavigationToolbar2Tkのインポート
-from random import random
-# randomモジュールからrandom関数をインポート
-from datetime import datetime
-               # datetimeモジュールからdatetime関数のインポート
-from functools import partial
-# functoolsモジュールからpartialのインポート
-import pymysql.cursors
-# pymysqlモジュールのcursorsをインポート
-#--------------------------------------------------------------------
-def select(yyyy,MM,dd,lid):  # select関数
-  connection = pymysql.connect(
-    host='localhost',
-    user='hit',
-    password='hit',
-    db='THT',
-    charset='utf8',
-    cursorclass=pymysql.cursors.DictCursor)
-  with connection.cursor() as cursor:
-    FROM = yyyy+"-"+MM+"-"+dd+" 00:00:00"
-    TO   = yyyy+"-"+MM+"-"+dd+" 23:00:00"
-    sql = "select * from thData where lid="+str(lid)
-    sql += " and date>='"+FROM+"' and date<='"+TO+"'"
-    print("sql=",sql)
-    cursor.execute(sql)
-    results = cursor.fetchall()
-    #for r in results:  print(r)
-  return results
-#--------------------------------------------------------------------
-def make_graph():    # make_graph関数
-  #print("<< make_graph start >>")
-  x  = [0]*24
-  y1 = [None]*24
-  y2 = [0]*24
-  yyyy = cb1.get()
-  m = int(cb2.get())
-  d = int(cb3.get())
-  MM = "{:02d}".format(m)
-  dd = "{:02d}".format(d)
-  lid = 1
-  #print("yyyy=",yyyy," ",type(yyyy))
-  #print("MM=",MM," ",type(MM))
-  #print("dd=",dd," ",type(dd))
-  #--------------------------------
-  results = select(yyyy,MM,dd,lid)
-  #--------------------------------
-  for i in range(0,24): x[i]=i
-  num = len(results)
-  print("num=",num)
-  if num == 0:  y1 = [None]*24
-  for i in range(num):
-    if i > 23: break
-    temp = results[i].get('temp')
-    hcount = results[i].get('hcount')
-    print(i," ",temp," ",hcount)
-    y1[i] = temp
-    y2[i] = hcount
-  ax1.cla()
-  ax1.set_xlabel('Hour (H)')
-  ax1.set_ylabel('Temperature (deg)')
-  ax1.set_ylim(-5,25)
-  ax1.plot(x,y1,color="blue",marker="o")
-  ax2.cla()
-  ax2.set_ylabel('Human detected (number)',color="red")
-  ax2.set_ylim(0,65)
-  ax2.bar(x,y2,color="red")
-  canvas.draw()
-  #print("<< make_graph end >>")
-#-----------------------------------------------------------------
-x  = [0]*24
-y1 = [None]*24
-y2 = [0]*24
-root = tk.Tk()
-root.title("TEST")
-root.geometry("650x580")
-frame1 = tk.LabelFrame(
-root,labelanchor="nw",
-text="Temperture & Human Sensor",foreground="green")
-# フレーム１
-frame1.grid(rowspan=2,column=0)
-frame2=tk.LabelFrame(root,text="Control", foreground="red")
-frame2.grid(row=2,column=0,sticky="nwse")
-fig = plt.Figure()
-ax1 = fig.add_subplot(111)
-ax1.plot(x,y1)
-ax1.set_xlabel('Hour (H)')
-ax1.set_ylabel('Temperature (deg)')
-ax1.set_ylim(-5,25)
-ax2 = ax1.twinx()
-ax2.bar(x,y2,color="red")
-ax2.set_ylabel('Human detected (number)',color="red")
-ax2.set_ylim(0,65)
-canvas = FigureCanvasTkAgg(fig, master=frame1)
-# キャンバスのインスタンス化
-canvas.get_tk_widget().pack(side=tk.TOP, fill=tk.BOTH, expand=1)
-now = datetime.now()
-date = "{:%Y-%m-%d}".format(now)
-month = now.month
-day = now.day
-years = ["2020","2021","2022","2023","2024","2025"]
-# 年（コンボボックス）
-months = [1]*12
-for i in range(12) : months[i]=i+1
-days = [1]*31
-for i in range(31) : days[i]=i+1
-devices = ["810C3B31","790A2D12"]
-lb1 = tk.Label(frame2, text="year:",bg="cyan")
-cb1 = ttk.Combobox(frame2, values=years,width=6,justify=tk.CENTER)
-cb1.current(0)
-lb2 = tk.Label(frame2, text="month:",bg="cyan")
-cb2 = ttk.Combobox(frame2, values = months,width=6,justify=tk.CENTER)
-cb2.current(month-1)
-lb3 = tk.Label(frame2, text="day:",bg="cyan")  # ラベル３（lb3）
-cb3 = ttk.Combobox(frame2, values = days,width=6,justify=tk.CENTER)
-cb3.current(day-1)
-lb4 = tk.Label(frame2, text="Device ID :",bg="cyan")
-cb4 = ttk.Combobox(frame2, values= devices,width=6,justify=tk.CENTER)
-cb4.current(0)
-y = cb1.current()
-m = cb2.current()
-d = cb3.current()
-selected_date = str(years[y])+"-"+str(months[m])+"-"+str(days[d])
-print("selected_date=",selected_date)
-print("cb1=",cb1.get()," ",end="")
-print("cb2=",cb2.get()," ",end="")
-print("cb3=",cb3.get())
-bt1 = tk.Button(frame2, text="Display", bg="yellow",command=make_graph)
-lb1.grid(row=1, column=0 ,padx=5, pady=5)
-cb1.grid(row=1, column=1 ,padx=5, pady=5)
-lb2.grid(row=1, column=2 ,padx=5, pady=5)
-cb2.grid(row=1, column=3 ,padx=5, pady=5)
-lb3.grid(row=1, column=4 ,padx=5, pady=5)
-cb3.grid(row=1, column=5 ,padx=5, pady=5)
-lb4.grid(row=1, column=6 ,padx=5, pady=5)
-cb4.grid(row=1, column=7 ,padx=5, pady=5)
-bt1.grid(row=1, column=8 ,padx=5, pady=5)
-make_graph()
-root.mainloop()