In the previous article, I have created an application with python to record sales for various items. In this article, I have slightly modified the previous program to remove some errors in the code as well as included a button that will plot the graph for all the item sales during the month of January.
Below is the manual to use this application.
Submit the sale amount:
- Select the item in either the shoe or the shirt category under the Shoe Sale or Shirt Sale section.
- Select the earning and location.
- Press either the Shirt Sale or the Shoe Sale’s submit button to submit the sale amount to the database.
Plotting the sale amount:
- Press any of the three buttons under the Plotting Graph section to plot the graph for shoe, shirt or all those items.
These are the line of codes for the application user interface.
import tkinter as tk from tkinter import ttk from Input import Input win = tk.Tk() win.title("Earn Great") def submit(cc): # commit the data into earning table if(cc=="Shoe"): sub_mit.submit(shoe_type.get(), earning.get(), location.get(), cc) elif(cc=='Shirt'): sub_mit.submit(shirt_type.get(), earning.get(), location.get(), cc) else: print("You need to enter a value!") #create label frame for the shoe ui shoe_frame= ttk.Labelframe(win, text ="Shoe Sale") shoe_frame.grid(column=0, row=0, padx=4, pady=4, sticky='w') # create combo box for the shoe type shoe_type = tk.StringVar() shoe_combo = ttk.Combobox(shoe_frame, width=9, textvariable = shoe_type) shoe_combo['values'] = ('Baby Girl', 'Baby Boy', 'Boy', 'Girl', 'Man', 'Woman') shoe_combo.current(0) shoe_combo.grid(column=0, row=0) # create the submit button for shoe type action_shoe = ttk.Button(shoe_frame, text="submit", command= lambda: submit("Shoe")) action_shoe.grid(column=1, row=0) #create label frame for the shirt ui shirt_frame= ttk.Labelframe(win, text ="Shirt Sale") shirt_frame.grid(column=0, row=1, padx=4, pady=4, sticky='w') # create combo box for the shirt type shirt_type = tk.StringVar() shirt_combo = ttk.Combobox(shirt_frame, width=16, textvariable = shirt_type) shirt_combo['values'] = ('T-Shirt', 'School Uniform', 'Baby Cloth', 'Jacket', 'Blouse', 'Pajamas') shirt_combo.current(0) shirt_combo.grid(column=0, row=0) # create the submit button for shirt type action_shirt = ttk.Button(shirt_frame, text="submit", command= lambda: submit("Shirt")) action_shirt.grid(column=1, row=0) #create label frame for the earning ui earning_frame= ttk.Labelframe(win, text ="Earning") earning_frame.grid(column=1, row=0, padx=4, pady=4, sticky='w') # create combo box for the shoe earning earning = tk.StringVar() earn_combo = ttk.Combobox(earning_frame, width=9, textvariable = earning) earn_combo['values'] = ('1.00', '2.00', '3.00', '4.00', '5.00', '6.00', '7.00', '8.00', '9.00', '10.00') earn_combo.current(0) earn_combo.grid(column=0, row=0) #create label frame for the location ui location_frame= ttk.Labelframe(win, text ="Location") location_frame.grid(column=1, row=1, padx=4, pady=4, sticky='w') # create combo box for the sale location location = tk.StringVar() location_combo = ttk.Combobox(location_frame, width=13, textvariable = location) location_combo['values'] = ('Down Town', 'Market', 'Bus Station', 'Beach', 'Tea House') location_combo.current(0) location_combo.grid(column=0, row=0) def plot(cc): # plotting the bar chart of total sales sub_mit.plot(location.get(), cc) #create label frame for the plot graph ui plot_frame= ttk.Labelframe(win, text ="Plotting Graph") plot_frame.grid(column=0, row=2, padx=4, pady=4, sticky='w') # create the plot button for shoe type action_pshoe = ttk.Button(plot_frame, text="Shoe", command= lambda: plot("Shoe")) action_pshoe.grid(column=1, row=0) # create the plot button for shirt type action_pshirt = ttk.Button(plot_frame, text="Shirt", command= lambda: plot("Shirt")) action_pshirt.grid(column=2, row=0) # create the plot button for all items action_p_loc = ttk.Button(plot_frame, text="All Items", command= lambda: plot("All Items")) action_p_loc.grid(column=3, row=0) win.resizable(0,0) sub_mit = Input() sub_mit.setting() win.mainloop()
Here are the codes for the database part.
import sqlite3 import pandas as pd import matplotlib.pyplot as plt class Input: def __init__(self): pass def setting(self): conn = sqlite3.connect('daily_earning.db') print("Opened database successfully") try: conn.execute('''CREATE TABLE DAILY_EARNING_CHART (ID INTEGER PRIMARY KEY AUTOINCREMENT, DESCRIPTION TEXT (50) NOT NULL, EARNING TEXT NOT NULL, TYPE TEXT NOT NULL, LOCATION TEXT NOT NULL, TIME TEXT NOT NULL);''') except: pass conn.close() def submit(self,description, earning, location, cc): # Insert values into earning table self.description = description self.earning = earning self.location = location self.cc = cc try: sqliteConnection = sqlite3.connect('daily_earning.db') cursor = sqliteConnection.cursor() print("Successfully Connected to SQLite") sqlite_insert_query = "INSERT INTO DAILY_EARNING_CHART (DESCRIPTION,EARNING,TYPE, LOCATION, TIME) VALUES ('" + self.description + "','"+ self.earning + "','" + self.cc + "','" + self.location + "',datetime('now', 'localtime'))" count = cursor.execute(sqlite_insert_query) sqliteConnection.commit() print("Record inserted successfully into DAILY_EARNING_CHART table", cursor.rowcount) cursor.close() except sqlite3.Error as error: print("Failed to insert earning data into sqlite table", error) finally: if (sqliteConnection): sqliteConnection.close() def plot(self, location, cc): # plotting the bar chart try: shoe_dict = {'Baby Girl' : 0.00, 'Baby Boy' : 0.00, 'Boy':0.00, 'Girl':0.00, 'Man':0.00, 'Woman':0.00} shirt_dict = {'T-Shirt':0.00, 'School Uniform':0.00, 'Baby Cloth':0.00, 'Jacket':0.00, 'Blouse':0.00, 'Pajamas':0.00} sqliteConnection = sqlite3.connect('daily_earning.db') cursor = sqliteConnection.cursor() print("Successfully Connected to SQLite") if cc=='All Items': cursor.execute("SELECT * FROM DAILY_EARNING_CHART WHERE LOCATION=?", (location,)) else: cursor.execute("SELECT * FROM DAILY_EARNING_CHART WHERE TYPE=? AND LOCATION=?", (cc, location)) rows = cursor.fetchall() for row in rows: if cc=="Shoe": shoe_dict[row[1]] += float(row[2]) elif cc=="Shirt": shirt_dict[row[1]] += float(row[2]) elif cc=="All Items": if row[1] in shoe_dict: shoe_dict[row[1]] += float(row[2]) else: shirt_dict[row[1]] += float(row[2]) # dictionary for the graph axis label_x = [] label_y = [] if cc=="Shoe": for key, value in shoe_dict.items(): label_x.append(key) label_y.append(value) elif cc=="Shirt": for key, value in shirt_dict.items(): label_x.append(key) label_y.append(value) else: for key, value in shirt_dict.items(): label_x.append(key) label_y.append(value) for key, value in shoe_dict.items(): label_x.append(key) label_y.append(value) # begin plotting the bar chart s = pd.Series(index=label_x, data=label_y) s.plot(color="green", kind="bar", title = cc + " Sales for January at " + location) plt.show() except sqlite3.Error as error: print("Failed to plot earning data", error) finally: if (sqliteConnection): sqliteConnection.close()
You can also read the entire program on this Github page.
In the next article, we will create a combo box for the date selection or perhaps we don’t even need to do that because we can directly use the date which has already existed in the earning table, we will see.
from Planet Python
via read more
No comments:
Post a Comment