MySQL Connectivity based project. Contains various functions of a Store-Management-System

Overview

store-management-system

An Intermediate Level Python - MySQL Connectivity based project. Contains various functions of a Store-Management-System.

Help on module Main:

NAME Main

FUNCTIONS CustomerMenu() Function that shows the options for customers to select from.

Menu()
    Function that show options to Log In as a Customer or an Owner or to Exit the program.

OwnerMenu()
    Function that shows a Menu to select options from for the Owner of the Store.

Help on module Database_Connect:

NAME Database_Connect

FUNCTIONS create_tables() Function that creates the required tables in MySQL Database if not created already.

database_connector()
    Function that Returns an Connection Object that connects Python to MySQL.

Help on module Owner:

NAME Owner

CLASSES builtins.object Owner

class Owner(builtins.object)
 |  Owner(name)
 |
 |  Class for Object of type 'Owner'. Contains all the functions accessible by an Owner.
 |
 |  Methods defined here:
 |
 |  P_Invoice(self)
 |      Function to make Purchase for New Stock.
 |
 |  Show_Customers(self)
 |      Function that prints Customers table from Database.
 |
 |  Show_Owners(self)
 |      Function that prints Owners Table from Database.
 |
 |  __init__(self, name)
 |      Function to initiate an Owner and add it to the Owners table if it doesn't exist.
 |
 |  account(self)
 |      Function that prints the Amount in selected Owners Account.
 |
 |  addCustomer(self, name)
 |      Function to add a New Customer to Customers Table.
 |
 |  delete_item(self)
 |      Function to Delete Items from the Stock Table.
 |
 |  ----------------------------------------------------------------------
 |  Static methods defined here:
 |
 |  ItemIsThere(sr='', name='')
 |      Static Function to search for an Item using it's Sr. No. or Name. Return True/False.
 |
 |  Stock_Report()
 |      Static Funtion to print the Stock Report.

Help on module Customer:

NAME Customer

CLASSES builtins.object Customer

class Customer(builtins.object)
 |  Customer(name)
 |
 |  Class for an Object of type 'Customer'. Contains all the functions accessible by a Customer.
 |
 |  Methods defined here:
 |
 |  S_Invoice(self)
 |      Function to generate a Sales Invoice for a Customer. Asks for items to be purchased from Customer and Prints Invoice.        
 |
 |  __init__(self, name)
 |      Function to initiate a Customer and add it to Customers Table if it doesn't exist.
 |
 |  payBill(self)
 |      Function to settle accounts by paying the outstanding bill.
 |
 |  printInvoice(self)
 |      Function to print the Sales Ivoice.
 |
 |  ----------------------------------------------------------------------
 |  Static methods defined here:
 |
 |  search_item(name)
 |      Static Function to search if a given item is there in stock or not.

This project can be used for Class 12th Computer Science Project as it serves the purpose correctly.

Owner
Yash Wadhvani
Yash Wadhvani
Repo created for the purpose of adding any kind of programs and projects

Programs and Project Repository A repository for adding programs and projects of any kind starting from beginners level to expert ones Contributing to

Unicorn Dev Community 3 Nov 02, 2022
A dog facts python module

A dog facts python module

Fayas Noushad 3 Nov 28, 2021
OB_Template is a vault template reference for using Obsidian.

Obsidian Template OB_Template is a vault template reference for using Obsidian. If you've tested out Obsidian. and worked through the "Obsidian Help"

323 Dec 27, 2022
Very Simple Zoom Spam Pinger!

Very Simple Zoom Spam Pinger!

Syntax. 2 Mar 05, 2022
User management system (UMS), has the primary purpose of connecting to an Active Directory (AD)

💿 Sistema de Gerenciamento de Usuário (SGU) 📚 Sobre o projeto Sistema de gerenciamento de usuários (SGU), tem o objetivo primário de se conectar a u

Patrick Viegas 2 Feb 25, 2022
This program can calculate the Aerial Distance between two cities.

Aerial_Distance_Calculator This program can calculate the Aerial Distance between two cities. This repository include both Jupyter notebook and Python

InvisiblePro 1 Apr 08, 2022
Analisador de strings feito em Python // String parser made in Python

Este é um analisador feito em Python, neste programa, estou estudando funções e a sua junção com "if's" e dados colocados pelo usuário. Neste código,

Dev Nasser 1 Nov 03, 2021
🦋 hundun is a python library for the exploration of chaos.

hundun hundun is a python library for the exploration of chaos. Please note that this library is in beta phase. Example Import the package's equation

kosh 7 Nov 07, 2022
A pure-Python codified rant aspiring to a world where numbers and types can work together.

Copyright and other protections apply. Please see the accompanying LICENSE file for rights and restrictions governing use of this software. All rights

Matt Bogosian 28 Sep 04, 2022
Backend/API for the Mumble.dev, an open source social media application.

Welcome to the Mumble Api Repository Getting Started If you are trying to use this project for the first time, you can get up and running by following

Dennis Ivy 189 Dec 27, 2022
Org agenda in the console

This Python script reads an org agenda file (i.e. a regular org file with some active dates) and displays an interactive and colored year calendar with detailed information for each day when the mous

Nicolas P. Rougier 113 Jan 03, 2023
Iss-tracker - ISS tracking script in python using NASA's API

ISS Tracker Tracking International Space Station using NASA's API and plotting i

Partho 9 Nov 29, 2022
Vaksina - Vaksina COVID QR Validation Checker With Python

Vaksina COVID QR Validation Checker Vaksina is a general purpose library intende

Michael Casadevall 33 Aug 20, 2022
Astroquery is an astropy affiliated package that contains a collection of tools to access online Astronomical data.

Astroquery is an astropy affiliated package that contains a collection of tools to access online Astronomical data.

The Astropy Project 631 Jan 05, 2023
Platform Tree for Xiaomi Redmi Note 7/7S (lavender)

The Xiaomi Redmi Note 7 (codenamed "lavender") is a mid-range smartphone from Xiaomi announced in January 2019. Device specifications Device Xiaomi Re

MUHAMAD KHOIRON 2 Dec 20, 2021
PhD document for navlab

PhD_document_for_navlab The project contains the relative software documents which I developped or used during my PhD period. It includes: FLVIS. A st

ZOU YAJING 9 Feb 21, 2022
Um sistema de llogin feito em uma interface grafica.

Interface-para-login Um sistema de login feito com JSON. Utilizando a biblioteca Tkinter, eu criei um sistema de login, onde guarda a informações de l

Mobben 1 Nov 28, 2021
Run the Tianxunet software on the Xiaoyao Android simulator

Run the Tianxunet software on the Xiaoyao Android simulator, and automatically fill in the answers of English listening on the premise of having answers

1 Feb 13, 2022
Convert your Gyrosco.pe travels to GPX files

gyroscope2gpx This little python joint will do you a favor of taking your "Travel" export from Gyroscope (https://gyrosco.pe) and turn it into a bunch

nick g 4 Oct 02, 2022
OTP-Bomber - An otp from MPL ID app, which can be spammed

OTP-Bomber An otp from MPL ID app, which can be spammed Note: Only available on

5 Oct 29, 2022