TeamTasewa's Expense Tracker - Version 2

 Version 2

This is version 2 of our project, and we'll be diving deep into the working of our expense tracker.

In our application, we will be importing the SQLite3 module. To connect the application to the SQLite database from the application, we need to call the Database() function of the SQLite3 module. The sqlite3.Database() will return a Database object and will open the database connection automatically.


  • When a user opens the web app, the first thing that they will see is the Welcome Page. Here, users have an option to either login using an existing account or sign up. 


    • New users fill in the given form, click the “Sign-Up” button and are taken to the Dashboard. The details provided will be stored in the database using an insert statement.


    • Existing users enter their credentials which are read using the inbuilt getReadableDatabase() function and are verified with the data in the database using the string match() method. If correct, the user is redirected to the Dashboard.






  • In the Dashboard, the user has the option to access any of the following modules which deal with a specific function:

    • User Profile: This module will redirect the user to a separate page where he/she can view and update details such as account name or password. In case of any updation, the Update statement will be executed and the updated details will be displayed in the user interface.


    • Income: In this module, users can add and update their income. This income is added into the database using an insert statement and will be displayed in the UI using a retrieve function. With a simple update button, users can update their income when necessary. 


    • Expense List: With a simple pen icon, the user will be redirected to another page where the user can add the expense name and amount. The save button will allow the user to save the expense he/she entered while the delete button will help in deleting a particular expense. To edit an expense, the user can click on that particular expense, edit and save the changes made.


    • Balance: Here, the user can check his/her balance by clicking on the View Balance” button - after clicking, the income and expense values will be fetched from the database using the get() function. These values are stored in the income and expense variables respectively and are displayed. To get the balance, the income will be subtracted from the expense and the resulting value will be displayed. 


    • Graphs: This feature gives a better understanding of expenses spent by the user. For a particular time period, the user can view a graph representing their expenses of that specific time frame. The data is collected from the database and is represented in the form of a pie-chart for better understanding. 


Also, we plan on making our application mobile friendly using “Ionic”.

Ionic is a powerful HTML5 SDK that helps you build native-feeling mobile apps using web technologies like HTML, CSS, and Javascript. Ionic is focused mainly on the look and feel, and UI interaction of your app.


Stay tuned for future versions!






Comments

Post a Comment

Popular posts from this blog

TeamTasewa's Expense Tracker - Version 1

Image
Planning is a must if we want to succeed in life, and that is what our expense tracker aims for. Inspired by the words of Alexander Graham bell, we decided to plan out the details of our application.  The goal of this blog post is to give a detailed view of the features of the Expense tracker application.  In any application, a good interface can determine whether or not it will be great; after all the user needs to feel comfortable when using it. Hence our first objective was to develop a blueprint for the UI.  Here is a brief explanation of the flowchart: Welcome Page: When the user enters the application the first thing that they will notice is a stunning UI. It also has two options for login and signs up.  Login / Register: Here the user will log in using their credentials to access their account if they have already signed up, else they can fill the registration form, to create a new account. Dashboard: After logging in, the user will be able to view the dashbo...
Read more

TeamTasewa's Expense Tracker - Version 3

Image
This  is version 3 of Team TASEWA's Expense Tracker application. Overall diagram Click on image for a better view or ( Drive link ) Subsystems Login/Sign Up Subsystem : When the user first accesses the application, they will see the welcome page. This page has two buttons - sign up and log in. If the user already has an account, they can click on the ‘Login’ button; they will be redirected to the login page where they can enter their credentials. These details will be verified with the data in the database. If there is a match, the user will be redirected to the dashboard. If there isn’t a match, the user will be notified of the wrong entry and will be prompted to enter the details again. If the user doesn’t have an account, they can click on the ‘Sign Up’ button; they will be redirected to the sign-up page where they can enter the details required to create an account. These details will be stored as a new entry in the database Once the details have been stored, the user will be r...
Read more