Freelance Hours ⏰

📋 About

Freelance Hours is a project management platform that connects freelancers with projects. It allows project owners to post their projects with specific tech stack requirements and deadlines, while freelancers can submit proposals with their estimated working hours. The system streamlines the project bidding process and helps manage project timelines effectively.

✨ Features

🚀 Project Management

• Create and publish projects with detailed descriptions
• Specify required tech stack (e.g., Node.js, React, JavaScript)
• Set project deadlines and track status (open/closed)
• View and manage all project proposals

📝 Project Proposals

• Submit proposals for open projects
• Specify estimated hours for project completion
• Track proposal status
• Receive notifications about proposal updates

👥 User System

• User authentication and authorization
• Project creation and management for project owners
• Profile management with email verification
• Track created projects and submitted proposals

🔧 Technical Features

• Email notifications for proposal updates (currently in log mode)
• Database-backed job queue system
• Database-backed cache system
• JSON storage for tech stack data
• Localized for Brazilian Portuguese (pt_BR)

🗄️ Database Structure

Projects Table

• id: Unique identifier
• title: Project title
• description: Detailed project description
• ends_at: Project deadline
• status: Project status (open/closed)
• tech_stack: Required technologies (JSON)
• created_by: Project owner reference

Proposals Table

• id: Unique identifier
• email: Freelancer's email
• hours: Estimated completion hours
• project_id: Associated project
• position_status: Proposal status

🛠️ Installation

Prerequisites

• PHP >= 8.1
• Composer
• Node.js & NPM
• SQLite (default) or MySQL

Setup Steps

1. Clone the repository

git clone https://github.com/rinel-benjamim/freelance-hours.git
cd freelance-hours

2. Install PHP dependencies

composer install

3. Install Node dependencies

npm install

4. Environment Setup

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

5. Database Setup By default, the project uses SQLite. Create the database file:

touch database/database.sqlite

If you prefer MySQL, update these settings in your .env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_username
DB_PASSWORD=your_password

6. Run migrations

php artisan migrate

7. Start the development server

php artisan serve

8. Configure queue worker The project uses a database queue driver. Start the queue worker:

php artisan queue:work database

Visit http://localhost:8000 in your browser.

🔧 System Configuration

Core Settings

• Application Name: FreelanceHours
• Timezone: UTC
• Locale: pt_BR (Brazilian Portuguese)
• Debug Mode: Enabled in development

Storage Drivers

• Session: Database
• Cache: Database
• Queue: Database
• Filesystem: Local
• Mail: Log driver (for development)

Security

• Session Lifetime: 120 minutes
• Session Encryption: Disabled
• BCrypt Rounds: 12

🔧 Technologies Used

• Backend: Laravel 10.x, PHP 8.1
• Frontend: TailwindCSS, JavaScript
• Database: SQLite (default) / MySQL (optional)
• Queue System: Laravel Jobs with Database Driver
• Cache: Laravel Cache with Database Driver
• Development: Vite

👨‍💻 Developer

Rinel Benjamim

Full-stack developer specialized in Laravel and modern web development technologies. Creating efficient solutions for real-world freelancing challenges.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🤝 Contributing

Contributions are welcome! Feel free to submit a Pull Request.

1. Fork the project
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request