Code Monkey home page Code Monkey logo

dbms_project's Introduction

Tax Tracker Company

Tax Tracker Company is a web application built with Flask and SQLite for tracking and managing tax-related information for companies and customers.

Table of Contents

Introduction

Tax Tracker Company streamlines the process of managing and tracking tax-related data for different companies and customers. The application provides a secure login system for employees and customers, allowing them to interact with and manage relevant information.

Features

Employee Login

Employees can securely log in using a password to access the employee dashboard.

Customer Login

Customers can log in using their company category to access their specific information.

New User Signup

New users can sign up to create a new record with the company and amount details.

Company Information

The application displays detailed information about a specific company, including payment status, due dates, and the ability to pay invoices.

Edit Record

Users can edit existing records, including updating the amount and due date.

Delete Record

The application allows users to delete records.

Code Structure

db.py

  • Creates an SQLite database named 'my_database.db.'
  • Defines a table named 'my_table' with columns (id, category, amount, date_paid, status, due_date).
  • Inserts sample data into the table.

app.py

  • Initializes a Flask web application.
  • Connects to the SQLite database.
  • Defines routes for various functionalities, such as home, employee login, customer login, new user signup, displaying company information, paying invoices, editing records, deleting records, saving records, and fetching summary.
  • Uses Flask templates (Jinja2) for rendering HTML pages.
  • Implements functions for database connection, closing, and rendering HTML pages.
  • Handles login authentication based on a fixed password for employees.
  • Displays a list of companies for employees.
  • Allows customers to log in, redirecting them to their respective company information.
  • Enables new user sign-up, inserting data into the database.
  • Displays and edits company information, deletes records, saves record changes.

HTML Templates

Templates are provided for various pages, such as 'company_info.html,' 'customer_dashboard.html,' 'customer_login.html,' 'edit_record.html,' 'employee_dashboard.html,' 'employee_login.html,' 'index.html,' 'new_user_signup.html.' These templates use Jinja2 templating to embed dynamic data and logic within HTML.

JavaScript

Includes JavaScript functions in the templates for handling actions like editing records, confirming record deletions.

CSS Styling

CSS styling is applied for front-end page aesthetics.

dbms_project's People

Contributors

ro468 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.