Mini E-commerce Project

Project Mind Map

Project Structure

1. User Management (laravel breeze authentication system)

   • Registration & Login
   • Profiles
   • Password Recoveries

2. Categories

   • Migration: CreateCategoriesTable
   • Validation: rules method

3. Brand

   • Migration: CreateBrandsTable
   • Validation: rules method

4. Products

   • Migration: CreateProductsTable
   • Validation: rules method

5. Product Images

   • Migration: CreateProductImagesTable
   • Validation: rules method

6. Reviews & Rating

   • Migration: CreateReviewsAndRatingsTable
   • Validation: rules method

7. Cart & Wishlist

   • Migration: CreateItemsTable
   • Validation: rules method

8. Order

   • Migration: CreateOrdersTable
   • Validation: rules method

9. Order Items

   • Migration: CreateOrderItemsTable
   • Validation: rules method

10. Checkout (Addresses)

    • Migration: CreateAddressesTable
    • Validation: rules method

11. Payment Integration

    • Payment Methods
      • Migration: CreatePaymentMethodsTable
      • Validation: rules method
    • Payment Transactions
      • Migration: CreatePaymentTransactionsTable
      • Validation: rules method

12. Notifications & Alerts

    • Setup: php artisan notifications:table & php artisan migrate

13. Customer Support & Feedback

    • FAQs
      • Migration: CreateFaqsTable
      • Validation: rules method
    • Chats
      • Migration: CreateChatsTable
      • Validation: rules method
    • Refund Policies
      • Migration: CreateRefundPoliciesTable
      • Validation: rules method

Project Database

1. User Management laravel breeze authentication system

   • Registration & Login
   • Profiles
   • PasswordRecoveries

2. Categories

   class CreateCategoriesTable extends Migration
   {
       public function up()
       {
           Schema::create('categories', function (Blueprint $table) {
               $table->id();
               $table->foreignId('parent_id')->nullable()->constrained('categories')->onDelete('set null'); // Self-referential foreign key
               $table->string('name')->unique();
               $table->string('slug')->unique();
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       $categoryId = $this->category; // Assuming the route parameter is named 'category'
   
       return [
           'parent_id' => 'nullable|exists:categories,id',
           'name' => "required|string|max:255|unique:categories,name,{$categoryId}",
           'slug' => "required|string|max:255|unique:categories,slug,{$categoryId}",
       ];
   
       <!-- return [
           'parent_id' => [
               'nullable',
               Rule::exists('categories', 'id'),
           ],
           'name' => [
               'required',
               'string',
               'max:255',
               Rule::unique('categories', 'name')->ignore($this->category),
           ],
           'slug' => [
               'required',
               'string',
               'max:255',
               Rule::unique('categories', 'slug')->ignore($this->category),
           ],
       ]; -->
   }

3. Brand

   class CreateBrandsTable extends Migration
   {
       public function up()
       {
           Schema::create('brands', function (Blueprint $table) {
               $table->id();
               $table->string('name')->unique();  // Ensure brand names are unique
               $table->string('slug')->unique();
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       $brandId = $this->brand; // Assuming the route parameter is named 'brand'
   
       return [
           'name' => "required|string|max:255|unique:brands,name,{$brandId}",
           'slug' => "required|string|max:255|unique:brands,slug,{$brandId}",
       ];
   }

4. Products

   class CreateProductsTable extends Migration
   {
       public function up()
       {
           Schema::create('products', function (Blueprint $table) {
               $table->id();
               $table->foreignId('category_id')->constrained()->cascadeOnDelete();
               $table->foreignId('brand_id')->constrained()->cascadeOnDelete();
               $table->string('name');
               $table->string('slug')->unique();
               $table->string('image');
               $table->string('sku')->unique()->nullable();  // Unique Stock Keeping Unit
               $table->text('description');
               $table->unsignedDecimal('price', 8, 2);
               $table->unsignedInteger('quantity')->default(0);  // Quantity in stock
               $table->enum('status', ['active', 'inactive']);  // Enum column for status 
               $table->foreignId('created_by')->nullable()->constrained('users')->onDelete('set null');  // Who created this product?
               $table->foreignId('updated_by')->nullable()->constrained('users')->onDelete('set null');  // Who last updated this product?
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       $productId = $this->product;
   
       return [
           'category_id' => 'required|exists:categories,id',
           'sub_category_id' => 'required|exists:sub_categories,id',
           'name' => 'required|string|max:255',
           'slug' => "required|string|max:255|unique:products,slug,{$productId}",
           'image' => 'required|image|mimes:jpeg,png,jpg|max:2048', // Image validation
           'sku' => "nullable|string|max:255|unique:products,sku,{$productId}",
           'description' => 'required|string',
           'price' => 'required|numeric|between:0,999999.99',
           'quantity' => 'required|integer|min:0',
           'status' => 'required|enum:products,status',
           'created_by' => 'nullable|exists:users,id',
           'updated_by' => 'nullable|exists:users,id',
       ];
   }

5. ProductImages

       class CreateProductImagesTable extends Migration
   {
       public function up()
       {
           Schema::create('product_images', function (Blueprint $table) {
               $table->id();
               $table->foreignId('product_id')->constrained()->cascadeOnDelete(); 
               $table->string('images');
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       return [
           'product_id' => 'required|exists:products,id',
           'images' => 'required|image|mimes:jpeg,png,jpg|max:2048',
       ];
   }

6. Reviews & Rating -

   class CreateReviewsAndRatingsTable extends Migration
   {
       public function up()
       {
           Schema::create('reviews_and_ratings', function (Blueprint $table) {
               $table->id();
               $table->foreignId('product_id')->constrained()->cascadeOnDelete();  
               $table->foreignId('user_id')->constrained()->cascadeOnDelete();  
               $table->text('review_text')->nullable();  // Nullable as it may not be required always
               $table->unsignedTinyInteger('rating_value')->nullable();  // Nullable as it may not be required always
               $table->enum('is_verified', ['yes', 'no'])->default('no');
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       return [
           'product_id' => 'required|exists:products,id',
           'user_id' => 'required|exists:users,id',
           'review_text' => 'nullable|string',
           'rating_value' => 'nullable|integer|min:1|max:5',  // Assuming a rating scale of 1-5
           'is_verified' => 'required|in:true,false',
       ];
   }

7. Cart & Wishlist

   class CreateItemsTable extends Migration
   {
       public function up()
       {
           Schema::create('items', function (Blueprint $table) {
               $table->id();
               $table->enum('type', ['cart', 'wishlist']);
               $table->foreignId('user_id')->constrained()->cascadeOnDelete();
               $table->foreignId('product_id')->constrained()->cascadeOnDelete();
               $table->unsignedInteger('quantity')->nullable()->default(0);  // Nullable if not applicable to wishlist items
               $table->unsignedDecimal('price', 8, 2)->nullable(); // Nullable if not applicable to wishlist items
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       return [
           'type' => 'required|in:cart,wishlist',
           'user_id' => 'required|exists:users,id',
           'product_id' => 'required|exists:products,id',
           'quantity' => 'nullable|integer|min:0',
           'price' => 'nullable|numeric|between:0,999999.99',
       ];
   }

8. Order

   class CreateOrdersTable extends Migration
   {
       public function up()
       {
           Schema::create('orders', function (Blueprint $table) {
               $table->id();
               $table->foreignId('user_id')->constrained()->cascadeOnDelete();
               $table->foreignId('shipping_address_id')->constrained('addresses')->cascadeOnDelete();
               $table->foreignId('billing_address_id')->constrained('addresses')->cascadeOnDelete();
               $table->timestamp('order_date')->useCurrent();
               $table->timestamp('shipped_date')->nullable();
               $table->enum('status', ['pending', 'processing', 'shipped', 'delivered', 'cancelled', 'return'])->default('pending');
               $table->unsignedDecimal('subtotal', 8, 2)->default(0.00);
               $table->unsignedDecimal('tax', 8, 2)->default(0.00);
               $table->unsignedDecimal('shipping_cost', 8, 2)->default(0.00);
               $table->unsignedDecimal('total_price', 8, 2)->default(0.00);
               $table->date('return_date')->nullable();
               $table->text('return_reason')->nullable();
               $table->double('return_amount', 10, 2)->nullable();
               $table->text('notes')->nullable();
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       return [
           'user_id' => 'required|exists:users,id',
           'address_id' => 'required|exists:addresses,id',
           'order_date' => 'required|date',
           'shipped_date' => 'nullable|date|after_or_equal:order_date',
           'status' => 'required|in:pending,processing,shipped,delivered,cancelled,return',
           'subtotal' => 'required|numeric|between:0,999999.99',
           'tax' => 'required|numeric|between:0,999999.99',
           'shipping_cost' => 'required|numeric|between:0,999999.99',
           'total_price' => 'required|numeric|between:0,999999.99',
           'return_date' => 'nullable|date|after:order_date',
           'return_reason' => 'nullable|string',
           'return_amount' => 'nullable|numeric|between:0,9999999999.99',
           'notes' => 'nullable|string',
       ];
   }

9. OrderItems

   class CreateOrderItemsTable extends Migration
   {
       public function up()
       {
           Schema::create('order_items', function (Blueprint $table) {
               $table->id();
               $table->foreignId('order_id')->constrained()->cascadeOnDelete();
               $table->foreignId('product_id')->constrained()->cascadeOnDelete();
               $table->unsignedInteger('quantity')->nullable()->default(0);
               $table->unsignedDecimal('unit_price', 8, 2);
               $table->unsignedDecimal('total_price', 8, 2);
               $table->timestamps();
           });
       }
       // ... rest of the code
   }

   public function rules()
   {
       return [
           'order_id' => 'required|exists:orders,id',
           'product_id' => 'required|exists:products,id',
           'product_name' => 'required|string|max:255',
           'product_sku' => 'required|string|max:255',
           'quantity' => 'nullable|integer|min:0',
           'unit_price' => 'required|numeric|between:0,999999.99',
           'total_price' => 'required|numeric|between:0,999999.99',
           'special_instructions' => 'nullable|string',
       ];
   }

10. Checkout (Addresses)

    class CreateAddressesTable extends Migration
    {
        public function up()
        {
            Schema::create('addresses', function (Blueprint $table) {
                $table->id();
                $table->foreignId('user_id')->constrained()->cascadeOnDelete();
                $table->enum('address_type', ['shipping', 'billing']);  // Enum column for address type
                $table->string('street_address');
                $table->string('city');
                $table->string('state');
                $table->string('country');
                $table->string('postal_code', 10);
                $table->timestamps();
            });
        }
        // ... rest of the code
    }

    public function rules()
    {
        return [
            'user_id' => 'required|exists:users,id',
            'address_type' => 'required|in:shipping,billing',
            'street_address' => 'required|string|max:255',
            'city' => 'required|string|max:255',
            'state' => 'required|string|max:255',
            'country' => 'required|string|max:255',
            'postal_code' => 'required|string|max:10',
        ];
    }

11. Payment Integration (PaymentMethods)

    class CreatePaymentMethodsTable extends Migration
    {
        public function up()
        {
            Schema::create('payment_methods', function (Blueprint $table) {
                $table->id();
                $table->string('name');
                $table->string('slug')->unique();
                $table->timestamps();
            });
        }
        // ... rest of the code
    }

    public function rules()
    {
        $paymentMethodId = $this->payment_method; // Assuming the route parameter is named 'payment_method'
    
        return [
            'name' => 'required|string|max:255',
            'slug' => "required|string|max:255|unique:payment_methods,slug,{$paymentMethodId}",
        ];
    }

12. Payment Integration (PaymentTransactions)

    class CreatePaymentTransactionsTable extends Migration
    {
        public function up()
        {
            Schema::create('payment_transactions', function (Blueprint $table) {
                $table->id();
                $table->foreignId('order_id')->constrained()->cascadeOnDelete();  // Reference to Orders table, cascade deletes
                $table->foreignId('payment_method_id')->constrained('payment_methods')->cascadeOnDelete();  // Reference to PaymentMethods table, cascade deletes
                $table->unsignedDecimal('amount', 8, 2);  // Transaction amount
                $table->string('transaction_id')->unique();  // Unique transaction identifier
                $table->enum('status', ['pending', 'completed', 'failed', 'refunded']);  // Transaction status
                $table->timestamps();
            });
        }
        // ... rest of the code
    }

    public function rules()
    {
        return [
            'order_id' => 'required|exists:orders,id',
            'payment_method_id' => 'required|exists:payment_methods,id',
            'amount' => 'required|numeric|between:0,999999.99',
            'transaction_id' => 'required|string|max:255|unique:payment_transactions,transaction_id',
            'status' => 'required|in:pending,completed,failed,refunded',
        ];
    }

13. Notifications & Alerts

    • Notifications php artisan notifications:table command generates a new database migration file that includes the schema for a notifications table. This table will hold information about the notifications, including type, JSON data, and other meta-information. After running this command, you will find the new migration file in your database/migrations directory.

    Once the migration file is generated, you can run php artisan migrate to apply the changes to your database. This will create the notifications table based on the schema defined in the migration file.

    Here's a brief overview of the steps:

    1. Generate the migration file for the notifications table:

    php artisan notifications:table
    

    2. You'll find the migration file in the database/migrations directory. You can review or modify this file if needed.

    3. Apply the migration to create the table in your database:

    php artisan migrate
    

    After completing these steps, your database should now have a new table named notifications where you can store and query notifications for your application.

14. Customer Support & Feedback

• FAQs

class CreateFaqsTable extends Migration
{
    public function up()
    {
        Schema::create('faqs', function (Blueprint $table) {
            $table->id();
            $table->string('question');
            $table->unsignedInteger('order')->nullable();
            $table->enum('status', ['active', 'inactive'])->default('active');
            $table->text('answer');
            $table->timestamps();
        });
    }
    // ... rest of the code
}

public function rules()
{
    return [
        'question' => 'required|string|max:255',
        'order' => 'nullable|integer|min:1',
        'status' => 'required|in:active,inactive',
        'answer' => 'required|string',
    ];
}

• Chats

class CreateChatsTable extends Migration
{
    public function up()
    {
        Schema::create('chats', function (Blueprint $table) {
            $table->id();
            $table->foreignId('user_id')
                ->constrained()
                ->cascadeOnDelete();
            $table->foreignId('support_agent_id')
                ->constrained('users')
                ->cascadeOnDelete();
            $table->text('chat_message');
            $table->timestamps();
        });
    }
    // ... rest of the code
}

public function rules()
{
    return [
        'user_id' => 'required|exists:users,id',
        'support_agent_id' => 'required|exists:users,id|different:user_id',
        'chat_message' => 'required|string',
    ];
}

• RefundPolicies

class CreateRefundPoliciesTable extends Migration
{
    public function up()
    {
        Schema::create('refund_policies', function (Blueprint $table) {
            $table->id();
            $table->text('policy_text');
            $table->timestamp('last_updated');
            $table->timestamps();
        });
    }
    // ... rest of the code
}

public function rules()
{
    return [
        'policy_text' => 'required|string',
        'last_updated' => 'required|date',
    ];
}