Skip to content

junsan24/inventory_system

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7,264 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🍴 Restaurant Inventory Management System

A modern Laravel-based inventory management system designed specifically for food restaurants to efficiently track inventory items, manage stock levels, monitor expiry dates, and streamline supplier relationships.

📋 Features

Core Inventory Management

  • Inventory Items: Create and manage food items with SKU, categories, unit costs, and pricing
  • Stock Tracking: Monitor stock quantities with batch numbers and storage locations
  • Expiry Management: Track expiry dates and get alerts for soon-to-expire items
  • Low Stock Alerts: Automatic warnings when items fall below reorder levels

Financial Management

  • Purchase Pricing: Track cost price for each item
  • Selling Pricing: Manage customer-facing prices
  • Stock Value: Calculate total inventory value at cost
  • Supplier Management: Track supplier information and payment terms

Reporting & Analytics

  • Dashboard: Real-time overview of inventory status
  • Low Stock Report: Items below reorder level
  • Expiry Report: Items expiring soon or already expired
  • Stock Movement History: Complete audit trail of all inventory changes
  • Supplier Performance: Track supplier information and payment terms

Data Organization

  • Categories: Organize items (Vegetables, Meat, Dairy, Spices, etc.)
  • Suppliers: Manage multiple suppliers with contact information
  • Stock Movements: Record all stock in/out and adjustments with reasons
  • Batch Tracking: Monitor product batches and expiry dates

🛠️ Technology Stack

  • Framework: Laravel 11
  • Database: MySQL
  • Frontend: Bootstrap 5
  • PHP: 8.2+

📦 Project Structure

inventory_system/
├── app/Models/
│   ├── InventoryItem.php
│   ├── Stock.php
│   ├── StockMovement.php
│   ├── Category.php
│   └── Supplier.php
├── app/Http/Controllers/
│   ├── DashboardController.php
│   ├── InventoryItemController.php
│   ├── StockController.php
│   ├── CategoryController.php
│   └── SupplierController.php
├── database/migrations/
├── database/seeders/
├── resources/views/
└── routes/web.php

🚀 Installation & Setup

Prerequisites

  • PHP 8.2 or higher
  • Composer
  • MySQL/MariaDB
  • Laragon

Installation Steps

  1. Navigate to project directory

    cd c:\laragon\www\inventory_system
  2. Install dependencies

    composer install
  3. Generate app key

    php artisan key:generate
  4. Configure database (.env)

    DB_DATABASE=inventory_system
    DB_USERNAME=root
    DB_PASSWORD=
    
  5. Run migrations

    php artisan migrate
  6. Seed sample data

    php artisan db:seed
  7. Start server

    php artisan serve
  8. Access application

📊 Key Database Models

  • InventoryItem: Food items with pricing and supplier info
  • Stock: Physical inventory quantities with batch tracking
  • StockMovement: Audit trail of all inventory transactions
  • Category: Item categorization
  • Supplier: Supplier contact and payment information

🔑 Core Operations

  1. Add Inventory Item: 📦 → Add Item
  2. Manage Stock: 📋 → Add/Record Stock
  3. View Reports: ⚠️ Low Stock, ⏰ Expiry Report
  4. Manage Suppliers: 🤝 Suppliers

📈 Dashboard Metrics

  • Total inventory items count
  • Active categories
  • Total suppliers
  • Total stock value at cost
  • Low stock alerts
  • Soon-to-expire items
  • Recent stock movements

🔐 Features

  • User authentication
  • Role-based access control foundation
  • Complete audit trail
  • Data validation
  • CSRF protection

📝 Sample Data Included

  • 7 food categories
  • 4 suppliers
  • 9 sample inventory items
  • Pre-loaded stock with batch numbers
  • Sample stock movements

📞 Quick Start Commands

# Create new category
php artisan make:seeder CategorySeeder

# Generate model with migration
php artisan make:model Category -m

# Create controller resource
php artisan make:controller CategoryController --resource

📄 License

Laravel Framework © Taylor Otwell - Licensed under the MIT license.

Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as:

Laravel is accessible, powerful, and provides tools required for large, robust applications.

Learning Laravel

Laravel has the most extensive and thorough documentation and video tutorial library of all modern web application frameworks, making it a breeze to get started with the framework.

In addition, Laracasts contains thousands of video tutorials on a range of topics including Laravel, modern PHP, unit testing, and JavaScript. Boost your skills by digging into our comprehensive video library.

You can also watch bite-sized lessons with real-world projects on Laravel Learn, where you will be guided through building a Laravel application from scratch while learning PHP fundamentals.

Agentic Development

Laravel's predictable structure and conventions make it ideal for AI coding agents like Claude Code, Cursor, and GitHub Copilot. Install Laravel Boost to supercharge your AI workflow:

composer require laravel/boost --dev

php artisan boost:install

Boost provides your agent 15+ tools and skills that help agents build Laravel applications while following best practices.

Contributing

Thank you for considering contributing to the Laravel framework! The contribution guide can be found in the Laravel documentation.

Code of Conduct

In order to ensure that the Laravel community is welcoming to all, please review and abide by the Code of Conduct.

Security Vulnerabilities

If you discover a security vulnerability within Laravel, please send an e-mail to Taylor Otwell via taylor@laravel.com. All security vulnerabilities will be promptly addressed.

License

The Laravel framework is open-sourced software licensed under the MIT license.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages