Tax Tracker Company is a web application built with Flask and SQLite for tracking and managing tax-related information for companies and customers.
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.
Employees can securely log in using a password to access the employee dashboard.
Customers can log in using their company category to access their specific information.
New users can sign up to create a new record with the company and amount details.
The application displays detailed information about a specific company, including payment status, due dates, and the ability to pay invoices.
Users can edit existing records, including updating the amount and due date.
The application allows users to delete records.
- 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.
- 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.
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.
Includes JavaScript functions in the templates for handling actions like editing records, confirming record deletions.
CSS styling is applied for front-end page aesthetics.