Develop Complete Billing Software In Python, Pyqt5 & Sqlite

We will develop a complete Billing Software with Python, PyQt5 and SQLite3 using QT Designer step by step from scratch

What you'll learn

PYQT5 Library and its tools and how to install python, pyqt5 and SQlite browser

SQLite connectivity with python GUI - Create database, tables and how to add default data in tables

How to create GUI forms in QT designer

Create python code to communicate with .ui files created using Qt Designer

Communicating between controls in GUI

Classes, methods, events in python programming

Requirements

Basic programming is enough

Need a laptop or desktop computer with internet connection

Description

Hello StudentWelcome to the course Develop Complete Billing Software in Python, PyQt5 & SQLiteDo you want to become a master in PYTHON GUI Programming?  Do You want to develop a real time billing software for sales business for a real time client? Do you want to add a best python project in your resume?  Do you want to understand and create the SQL quires using sqlite3 database?By learning this course you can achieve all the things.After completing this courseYou will be able to create a complete billing software for any kind of business.You can create a new software yourself for your client requirement using PYTHON - PYQT LIBRARY.You can create SQL queries yourself according to the software requirement.In this course,You will learn how to start the project by installing the required software and libraries from internet and till printing the bill after completing the sales using our software.All basic requirements to complete this project are explained step by step process in this course.First you will learn how to install python, then how to install pyqt5, and pyqt5-tools using pip and you will learn how to install SQLite browser.After that you will learn how to design professional looking graphical user interface for login form, product list form, billing form. then you will learn how to create a settings form using qt designer.Then you will learn how to create a sqlite3 database and tables and how to set default data in the table through python programming.Then you will learn how to create code to interact with user interface file from python code and how to write click event, select event codes to the controls in the GUI.After that you will learn how to interact with SQLite database from the python code and show it in the Graphical user interface.You will learn how to use images in Pyqt5 and dynamically change the images through the python code.Learning Steps in this CourseInstalling required softwarePythonPyqt5Pyqt5-ToolsSQLite BrowserVisual studio code (Optional)Configure vs codeConfigure QT Designer to desktopCreating user interface fileCreate login formUsernamePasswordLogin buttonError message labelLogin image displayCreate products list formProducts containerPrice detailsImage detailsProduct name detailsCreate billing tableGenerate bill numberGenerate current dateCreate settings pageProducts list combo boxProducts name QLineEditProducts price QLineEditProducts image QLineEditModify QPushButtonBack QPushButtonCreating python file to connect with user interfaceCreate database, tables and add default product detailsCreate databaseCreate tables for storing bill details and product detailsCreate login function to make login processLogin functionLogout function Create add to bill function to add items to listAdd selected product in the database Add selected product in the billing tableCreate update function to update existing itemsModify selected product count in the database Modify selected product count in the billing tableCalculate tax, total price and grand totalDisplay total price of all productsCalculating 5% tax for all productsCalculating the grand total pricePrint receipt and go next billPrint the form and open next bill functionNo print and open the next bill functionSettings page setupOpen settings page functionAdd products to setting pageAdd all products from database to the combo boxWhen a product is selected, display its name, price and image in the required controlUpdate products in settings pageUpdate product name, price and image in the databaseUpdate changes in the products list formDisplay updated image, price and name in the products pageSo why are you waiting. Join the course immediately.I will see you in the course.Thank you..

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Installing the required software

Lecture 2 Install Python

Lecture 3 Install Pyqt5 and pyqt5-tools

Lecture 4 Install visual studio code ( Optional ) - You can use any editor

Lecture 5 Create Desktop shortcut to Qt Designer

Section 3: Designing forms - Login form design

Lecture 6 Creating Login form

Section 4: Billing page design

Lecture 7 In this lecture we are going to create products list

Lecture 8 We are going to create billing table. All added items are listed in this table.

Section 5: Settings Page Design

Lecture 9 Design settings page

Section 6: Resources for developing the project

Lecture 10 Images required to develop this project

Lecture 11 The source code for the ui file

Section 7: Linking Qt Designer ui file with python file

Lecture 12 Create python file and link with ui file

Section 8: Connecting Qt Designer UI file with Python File

Lecture 13 Connecting ui file with python file

Section 9: Install sqlite browser

Lecture 14 Installing the SQLite browser

Section 10: Creating and setting up the sqlite3 database, tables and default data

Lecture 15 Create database, tables in sqlite3 database

Lecture 16 Insert food details table with food name, food image and food price

Section 11: Login process

Lecture 17 Collect user data from input controls and login to the next page

Section 12: Billing Page

Lecture 18 Generate bill number and display current date automatically in the billing form

Lecture 19 Collecting current product name, price and image from the database

Lecture 20 Add or update products to billing database table when the user select a product

Lecture 21 Display the products when it is added or updated in the database table to GUI

Lecture 22 Calculating the total price, tax and grand total for the billing products

Lecture 23 Print receipts and generate the next bill number after completing one bill

Section 13: Setting Page

Lecture 24 Collect all products from the database table and show in the list

Lecture 25 Display and modify the selected product like name, image and price in database

Lecture 26 Display the modified product in the products list page with name, image & price

Section 14: Python project source code file

Lecture 27 Download pos.py file

If you are a student or a developer want to develop a complete software from the beginning to end,If you know basics of python programming and want to improve your skills by developing a best software,If you are want to convert the python program output into a GUI to present nicely,College students who want to develop their projects themselves in python,To show your IOT programming output through GUI in the Computer,Software programmer want to grow as a python developer