This is a simple Customer Management System built using Python and the flet library for creating graphical user interfaces. It allows users to register new customers, manage existing customer data, and export statements.
- New Customer Registration: Easily register new customers by providing their name and ID.
- Existing Customer Management: Add invoices for existing customers, including details like liters purchased and invoice date.
- Export Statements: Generate statements for a selected month and year, exporting data to an Excel file.
- Python 3.x
- flet library
- pandas
- mysql-connector-python
- openpyxl
- Clone the repository:
git clone https://github.com/kyprosantreou/customer-management.git
- Install dependencies:
pip install -r requirements.txt
- Configure MySQL database connection details in the main function of
main.py.
- Run the application:
flet run main.py
- Use the graphical interface to perform various tasks such as registering new customers, managing existing customer data, and exporting statements.
Created by Kypros Andreou.