Restaurant Management script using Tkinter with product table from MySQL database for backend

This is part two of the total script. In part 3 we will work on the report generation to display data in various forms.
All product with its attributes like price , item name etc are taken from the MySQL table by using query and Label is displayed inside a grid. Spinboxes are added dynamically to select number of items for billing. Here we keep one dictionary to store the product id and the spinbox values . Only when we click the generate bill the final amount is calculated by adding tax and total amount is show.
On click of the Reset button the system will return to normal state where next bill can be generated.

Restaurant management with database integration using Tkinter Version -2
The Part -2 of the script should have these features
Connect to MySQL database and retrieve data based one of the selected category of products.
The products which are available ( available column in table should have value =1 ) only , should be displayed.
While displaying the product, the price of the product should be shown.
Price has to be managed from database table.
On selection of one of the category option ( by radio buttons ) the product ( menu items ) list should change to reflect the selected category.
Based on the number of products returned by database table the rows and columns should adjust itself.
Number of columns in rows should be easily managed at a central place.

Download the source code for all parts from here

All parts of Restaurant Management is here

Part I is here

Part II : database integration

Part III : Generating Invoice

Part IV Installation of product table

Part V Installation of sale and bill tables

Part VI Generating date wise reports

In part 3 of this we will add the report generation part
#restaurantManagement #DatabaseIntegration #MySQL #ProjectInPython #DatabaseInPython #plus2net #tkinter #python #ProjectUsingTkinter

[maneeshreddy]

Requirement: If we choose one from the drop-down and for that element can we add particular frame and other elements in it like textbox?

[hrmndep]

can we make editable tree view in tkinter ?