i have a python fucntion to plot some data into a tk interface, but my data does not display properly into my graphs, for example when i select an item, and then it loads all the data, then i select a month such as november but some days for the previous month appear and then not all days for that month appear, i have added my code for the function and also my table from my database that includes some data points not all:

# Create a ttk Notebook for the Table of Contents

toc$\_$notebook $=$ ttk$.$Notebook$($window$)$

toc$\_$notebook.grid$($row$=0,$ column$=1,$ columnspan$=20,$ padx$=10,$ pady$=10,$ sticky$=$'nsew'$)$

# Create frames for each tab

daily$\_$frame $=$ ttk$.$Frame$($toc$\_$notebook$)$

weekly$\_$frame $=$ ttk$.$Frame$($toc$\_$notebook$)$

# monthly$\_$frame $=$ ttk$.$Frame$($toc$\_$notebook$)$

toc$\_$notebook.add$($daily$\_$frame, text$=$'Daily Usage'$)$

toc$\_$notebook.add$($weekly$\_$frame, text$=$'Weekly Usage'$)$

# toc$\_$notebook.add$($monthly$\_$frame, text$=$'Monthly Usage'$)$

# Dropdown for month selection

months $=[\text{'}$All Months'$]+[$datetime$(2000,$ m$,1).$strftime$(\text{'}\%$B$\text{'})$ for m in range$(1,13)]$ # List of months with 'All Months' as the first option

month$\_$var $=$ tk$.$StringVar$($window$)$

month$\_$combobox $=$ ttk$.$Combobox$($window$,$ textvariable$=$month$\_$var, values$=$months, state$=$"readonly"$)$

month$\_$combobox.current$(0)$ # Default to 'All Months'

month$\_$combobox.grid$($row$=1,$ column$=1,$ padx$=10,$ pady$=5,$ sticky$=\text{'}$w$\text{'})$

toc$\_$frames $=\{$

"Daily Usage": daily$\_$frame,

"Weekly Usage": weekly$\_$frame,

# "Monthly Usage": monthly$\_$frame

$\}$

def draw$\_$graph$($item$\_$name, time$\_$period, selected$\_$month $=$ None$)$:

global graph$\_$canvas

if not item$\_$name: # If no item is selected, do nothing

return

# Clear previous graph if it exists

if graph$\_$canvas:

graph$\_$canvas.get$\_$tk$\_$widget$().$destroy$()$

# Connect to the database

db $=$ mysql$.$connector.connect$($

host$=$'localhost',

user$=$'root',

password$=$'peter',

database$=$'shop$\_$inventory'

$)$

cursor $=$ db$.$cursor$()$

# Modify the SQL query to filter data based on the selected month

month$\_$condition $=""$

if selected$\_$month and selected$\_$month $!=$ 'All Months':

month$\_$number $=$ datetime.strptime$($selected$\_$month, $\text{'}\%$B$\text{'}).$month

month$\_$condition $="$ AND MONTH$($change$\_$date$)=\%$s$"\%$ month$\_$number

if time$\_$period $==$ "Daily Usage":

cursor.execute$("""$

SELECT DATE$($change$\_$date$)$ as date, SUM$($quantity$\_$change$)$ as total$\_$change

FROM changes$\_$log

WHERE item$\_$name $=\%$s$"""+$ month$\_$condition $+"""$

GROUP BY DATE$($change$\_$date$)$

ORDER BY DATE$($change$\_$date$)$ ASC

$""",($item$\_$name,$))$

elif time$\_$period $==$ "Weekly Usage":

cursor.execute$("""$

SELECT YEARWEEK$($change$\_$date$)$ as week, SUM$($quantity$\_$change$)$ as total$\_$change

FROM changes$\_$log

WHERE item$\_$name $=\%$s

GROUP BY YEARWEEK$($change$\_$date$)$

ORDER BY YEARWEEK$($change$\_$date$)$ ASC

$""",($item$\_$name,$))$

# Fetch the data

data $=$ cursor.fetchall$()$

dates $=[$x$[0]$ for x in data$]$

quantities $=[$x$[1]$ for x in data$]$

fig, ax $=$ plt$.$subplots$($figsize$=(10,4))$ # Adjust the size as needed

ax$.$plot$($dates$,$ quantities, marker$=\text{'}$o$\text{'})$ # Add markers for each data point

# Adjust the plot margins

plt$.$subplots$\_$adjust$($bottom$=0\mathrm{.}2)$ # Increase the bottom margin to allow for more space

# Format the graph based on the time$\_$period

if time$\_$period $==$ "Daily Usage":

ax$.$xaxis.set$\_$major$\_$formatter$($mdates$.$DateFormatter$(\text{'}\%$Y$-\%$m$-\%$d$\text{'}))$

ax$.$xaxis.set$\_$major$\_$locator$($mdates$.$DayLocator$($interval$=1))$ # Set interval to show every day

plt$.$xticks$($rotation $=90,$ fontsize $=6)$

elif time$\_$period $==$ "Weekly Usage":

# Convert week numbers to the starting date of the week for labeling

start$\_$dates $=[$datetime$.$strptime$($f$\text{'}\{$date$\}-1\text{'},"\%$Y$\%$W$-\%$w$")$ for date in dates$]$

ax$.$set$\_$xticks$($range$($len$($start$\_$dates$)))$ # Set x$-$ticks to be the start dates of weeks

ax$.$set$\_$xticklabels$([$date$.$strftime$(\text{'}\%$Y$-\%$m$-\%$d$\text{'})$ for date in start$\_$dates$],$ rotation$=45)$

# Embedding the figure in the Tkinter window

graph$\_$canvas $=$ FigureCanvasTkAgg$($fig$,$ master$=$toc$\_$frames$[$time$\_$period$])$

graph$\_$canvas.draw$()$

graph$\_$widget $=$ graph$\_$canvas.get$\_$tk$\_$widget$()$

graph$\_$widget.pack$($side$=$tk$.$TOP, fill$=$tk$.$BOTH, expand$=$True$)$

# Close the database connection

cursor.close$()$

db$.$close$()$

mysql$>$ SELECT $*$

$->$ FROM changes$\_$log

$->$ ORDER BY change$\_$date ASC;

$+------+----------------+-------------------+---+-----------------+-----------+$

$|$ id $|$ item$\_$name $|$ original$\_$quantity $|$ new$\_$quantity $|$ change$\_$time $|$ emp$\_$id $|$ change$\_$date $|$ quantity$\_$change $|$ rando