Fundora - Your Personal Financial Record

A web application for managing personal income and expenses, built with Laravel. This application features a comprehensive dashboard, transaction tracking, and advanced SQL implementations including stored procedures, triggers, functions, and views.

Features

• User Authentication: Secure registration and login system (Laravel Breeze).
• Dashboard: Real-time overview of financial status with charts and summaries.
• Transaction Management: Record income and expenses with detailed descriptions and dates.
• Data Visualization: Interactive charts using Chart.js.

Preview

Dashboard with Financial Summary and Charts

Transaction Management Interface

Tech Stack

• Backend: Laravel 12, PHP 8.2
• Frontend: Blade Templates, Tailwind CSS, Alpine.js
• Database: MySQL / MariaDB
• Charts: Chart.js

SQL Features

This project demonstrates advanced database concepts:

• Views: v_transaction_details for simplified data retrieval.
• Stored Procedures: get_monthly_summary for generating monthly financial reports.
• Functions: get_total_income for calculating total user income.
• Triggers: before_transaction_insert for data validation (ensuring positive amounts).

Installation

1. Clone the repository

   git clone https://github.com/brianabdl/money-management-app.git
   cd money-management-app

2. Install Dependencies

   composer install
   npm install

3. Environment Setup Copy the .env.example file to .env and configure your database credentials.

   cp .env.example .env
   php artisan key:generate

4. Database Setup Create a database and run migrations.

   php artisan migrate

5. Seed Database (Optional) Populate the database with test data.

   php artisan db:seed

6. Build Assets

   npm run build

7. Run Application

   php artisan serve

Usage

1. Register a new account.
2. Create categories for your income and expenses (e.g., Salary, Food, Transport).
3. Start recording your transactions.
4. View the dashboard to see your financial summary and charts.

License

This project is open-sourced software licensed under the MIT license.