Project Introduction

The Stock Market Prediction System is an advanced analytical tool designed to forecast stock prices and market trends using historical data and machine learning algorithms. This system aims to assist investors and traders in making informed decisions by providing accurate predictions and insights into market behavior. With the increasing complexity of financial markets and the need for data-driven strategies, the Stock Market Prediction System addresses these challenges by leveraging technology to analyze vast amounts of data efficiently.

The platform features data collection from various sources, including historical stock prices, trading volumes, and economic indicators. It employs machine learning models to identify patterns and trends, generating predictions for future stock performance. Additionally, the system includes visualization tools to present data and predictions in an easily understandable format. By automating the prediction process, the Stock Market Prediction System aims to enhance investment strategies and improve overall financial outcomes for users.

Project Objectives

• To develop an intuitive interface for users to input data and view predictions easily.
• To implement data collection mechanisms for gathering historical stock market data.
• To utilize machine learning algorithms for accurate stock price predictions.
• To provide visualization tools for users to analyze trends and predictions effectively.
• To enable users to customize prediction parameters based on their investment strategies.
• To generate reports on prediction accuracy and market trends for user analysis.
• To ensure data security and privacy for all user information and financial data.
• To enhance user engagement through features like alerts for significant market changes and updates.

Project Modules

Data Collection Module

• Market Data Acquisition: Collect historical stock prices, trading volumes, and other relevant market data from various sources (e.g., stock exchanges, financial news APIs).
• News and Sentiment Analysis: Gather news articles, social media posts, and other textual data to analyze market sentiment and its impact on stock prices.
• Economic Indicators: Integrate data on economic indicators (e.g., interest rates, inflation rates) that may influence stock market trends.

Data Preprocessing Module

• Data Cleaning: Remove inconsistencies, missing values, and outliers from the collected data to ensure accuracy.
• Data Transformation: Normalize or standardize data as needed for analysis and modeling.
• Feature Engineering: Create new features from existing data that may improve the predictive power of the models (e.g., moving averages, volatility measures).

Exploratory Data Analysis (EDA) Module

• Visualization Tools: Provide tools for visualizing historical stock prices, trends, and correlations between different stocks or indicators.
• Statistical Analysis: Conduct statistical tests and analyses to understand the relationships between variables and identify patterns.

Model Development Module

• Machine Learning Algorithms: Implement various machine learning algorithms (e.g., linear regression, decision trees, neural networks) for stock price prediction.
• Model Training: Train models using historical data and validate their performance using techniques like cross-validation.
• Hyperparameter Tuning: Optimize model parameters to improve prediction accuracy.

Prediction Module

• Real-Time Predictions: Provide real-time stock price predictions based on the latest available data.
• Forecasting: Generate forecasts for different time horizons (e.g., short-term, medium-term, long-term).
• Confidence Intervals: Offer confidence intervals for predictions to indicate the level of uncertainty.

Backtesting Module

• Strategy Testing: Allow users to test trading strategies based on historical data to evaluate their effectiveness.
• Performance Metrics: Calculate performance metrics (e.g., Sharpe ratio, maximum drawdown) to assess the viability of strategies.

User Interface Module

• Dashboard: Provide a user-friendly dashboard for users to view predictions, historical data, and analysis results.
• Interactive Charts: Enable users to interact with charts and graphs to explore data and predictions.
• Alerts and Notifications: Allow users to set alerts for specific stock price movements or market conditions.

Portfolio Management Module

• Portfolio Tracking: Enable users to track their stock portfolios and monitor performance.
• Risk Assessment: Provide tools for assessing the risk associated with different stocks or portfolios.
• Rebalancing Recommendations: Suggest portfolio rebalancing based on market predictions and user-defined criteria.

Reporting and Analytics Module

• Performance Reports: Generate reports on the performance of predictions and trading strategies.
• Market Analysis: Provide insights into market trends, sector performance, and stock correlations.

Project Tables Queries

-- Create Users Table
CREATE TABLE Users (
    UserId INT PRIMARY KEY IDENTITY(1,1),
    Username NVARCHAR(50) NOT NULL UNIQUE,
    PasswordHash NVARCHAR(256) NOT NULL,
    Email NVARCHAR(100) NOT NULL UNIQUE,
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create StockData Table
CREATE TABLE StockData (
    StockDataId INT PRIMARY KEY IDENTITY(1,1),
    StockSymbol NVARCHAR(10) NOT NULL,
    Date DATE NOT NULL,
    OpenPrice DECIMAL(18, 2) NOT NULL,
    ClosePrice DECIMAL(18, 2) NOT NULL,
    HighPrice DECIMAL(18, 2) NOT NULL,
    LowPrice DECIMAL(18, 2) NOT NULL,
    Volume BIGINT NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create EconomicIndicators Table
CREATE TABLE EconomicIndicators (
    IndicatorId INT PRIMARY KEY IDENTITY(1,1),
    IndicatorName NVARCHAR(100) NOT NULL,
    Value DECIMAL(18, 2) NOT NULL,
    Date DATE NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create Predictions Table
CREATE TABLE Predictions (
    PredictionId INT PRIMARY KEY IDENTITY(1,1),
    StockSymbol NVARCHAR(10) NOT NULL,
    PredictedPrice DECIMAL(18, 2) NOT NULL,
    PredictionDate DATE NOT NULL,
    ModelUsed NVARCHAR(100),
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create TradingStrategies Table
CREATE TABLE TradingStrategies (
    StrategyId INT PRIMARY KEY IDENTITY(1,1),
    StrategyName NVARCHAR(100) NOT NULL,
    Description NVARCHAR(MAX),
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create Portfolios Table
CREATE TABLE Portfolios (
    PortfolioId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    PortfolioName NVARCHAR(100) NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create PortfolioStocks Table (Many-to-Many relationship between Portfolios and StockData)
CREATE TABLE PortfolioStocks (
    PortfolioStockId INT PRIMARY KEY IDENTITY(1,1),
    PortfolioId INT,
    StockSymbol NVARCHAR(10) NOT NULL,
    Quantity INT NOT NULL,
    PurchasePrice DECIMAL(18, 2) NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (PortfolioId) REFERENCES Portfolios(PortfolioId)
);
-- Create PerformanceReports Table
CREATE TABLE PerformanceReports (
    ReportId INT PRIMARY KEY IDENTITY(1,1),
    PortfolioId INT,
    ReportDate DATE NOT NULL,
    TotalValue DECIMAL(18, 2) NOT NULL,
    TotalReturn DECIMAL(18, 2) NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (PortfolioId) REFERENCES Portfolios(PortfolioId)
);
-- Create Alerts Table
CREATE TABLE Alerts (
    AlertId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    StockSymbol NVARCHAR(10) NOT NULL,
    AlertType NVARCHAR(50) NOT NULL, -- e.g., Price Alert, Volume Alert
    Threshold DECIMAL(18, 2) NOT NULL,
    IsActive BIT DEFAULT 1,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);

Explanation of the Tables

Users: Stores user information, including username, password hash, email, and creation date.

StockData: Contains historical stock data, including stock symbol, date, open price, close price, high price, low price, and volume.

EconomicIndicators: Stores economic indicators that may affect stock prices, including the indicator name, value, and date.

Predictions: Contains predictions made by the system, including the stock symbol, predicted price, prediction date, and model used.

TradingStrategies: Stores different trading strategies that can be applied, including strategy name and description.

Portfolios: Manages user portfolios, linking them to users and storing portfolio names.

PortfolioStocks: A junction table to manage the many-to-many relationship between portfolios and stock data, including quantity and purchase price.

PerformanceReports: Stores performance reports for portfolios, including total value and total return.

Alerts: Manages alerts set by users for specific stocks, including alert type, threshold, and status.

To create the models and migrations for the provided SQL schema in Laravel 11, you can follow these steps.

Below, I will provide the migration files and the corresponding Eloquent models for each table.

Step 1: Create Migrations

You can create migrations using the Artisan command. For example, to create a migration for the Users table, you would run:

php artisan make:migration create_users_table

Repeat this for each table. Below are the migration files based on your SQL schema.

Migration for Users Table

// database/migrations/2025_02_01_000001_create_users_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateUsersTable extends Migration
{
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id('User Id');
            $table->string('Username', 50)->unique();
            $table->string('PasswordHash', 256);
            $table->string('Email', 100)->unique();
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

Migration for StockData Table

// database/migrations/2025_02_01_000002_create_stock_data_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateStockDataTable extends Migration
{
    public function up()
    {
        Schema::create('stock_data', function (Blueprint $table) {
            $table->id('StockDataId');
            $table->string('StockSymbol', 10);
            $table->date('Date');
            $table->decimal('OpenPrice', 18, 2);
            $table->decimal('ClosePrice', 18, 2);
            $table->decimal('HighPrice', 18, 2);
            $table->decimal('LowPrice', 18, 2);
            $table->bigInteger('Volume');
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('stock_data');
    }
}

Migration for EconomicIndicators Table

// database/migrations/2025_02_01_000003_create_economic_indicators_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateEconomicIndicatorsTable extends Migration
{
    public function up()
    {
        Schema::create('economic_indicators', function (Blueprint $table) {
            $table->id('IndicatorId');
            $table->string('IndicatorName', 100);
            $table->decimal('Value', 18, 2);
            $table->date('Date');
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('economic_indicators');
    }
}

Migration for Predictions Table

// database/migrations/2025_02_01_000004_create_predictions_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePredictionsTable extends Migration
{
    public function up()
    {
        Schema::create('predictions', function (Blueprint $table) {
            $table->id('PredictionId');
            $table->string('StockSymbol', 10);
            $table->decimal('PredictedPrice', 18, 2);
            $table->date('PredictionDate');
            $table->string('ModelUsed', 100)->nullable();
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('predictions');
    }
}

Migration for TradingStrategies Table

// database/migrations/2025_02_01_000005_create_trading_strategies_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateTradingStrategiesTable extends Migration
{
    public function up()
    {
        Schema::create('trading_strategies', function (Blueprint $table) {
            $table->id('StrategyId');
            $table->string('StrategyName', 100);
            $table->text('Description')->nullable();
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('trading_strategies');
    }
}

Migration for Portfolios Table

// database/migrations/2025_02_01_000006_create_portfolios_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePortfoliosTable extends Migration
{
    public function up()
    {
        Schema::create('portfolios ', function (Blueprint $table) {
            $table->id('PortfolioId');
            $table->foreignId('User Id')->constrained('users');
            $table->string('PortfolioName', 100);
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('portfolios');
    }
}

Migration for PortfolioStocks Table

// database/migrations/2025_02_01_000007_create_portfolio_stocks_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePortfolioStocksTable extends Migration
{
    public function up()
    {
        Schema::create('portfolio_stocks', function (Blueprint $table) {
            $table->id('PortfolioStockId');
            $table->foreignId('PortfolioId')->constrained('portfolios');
            $table->string('StockSymbol', 10);
            $table->integer('Quantity');
            $table->decimal('PurchasePrice', 18, 2);
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('portfolio_stocks');
    }
}

Migration for PerformanceReports Table

// database/migrations/2025_02_01_000008_create_performance_reports_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePerformanceReportsTable extends Migration
{
    public function up()
    {
        Schema::create('performance_reports', function (Blueprint $table) {
            $table->id('ReportId');
            $table->foreignId('PortfolioId')->constrained('portfolios');
            $table->date('ReportDate');
            $table->decimal('TotalValue', 18, 2);
            $table->decimal('TotalReturn', 18, 2);
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('performance_reports');
    }
}

Migration for Alerts Table

// database/migrations/2025_02_01_000009_create_alerts_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateAlertsTable extends Migration
{
    public function up()
    {
        Schema::create('alerts', function (Blueprint $table) {
            $table->id('AlertId');
            $table->foreignId('User Id')->constrained('users');
            $table->string('StockSymbol', 10);
            $table->string('AlertType', 50);
            $table->decimal('Threshold', 18, 2);
            $table->boolean('IsActive')->default(true);
            $table->timestamps(0);
        });
    }
    public function down()
    {
        Schema::dropIfExists('alerts');
    }
}

Step 2: Create Eloquent Models

Next, create Eloquent models for each table. You can use the Artisan command to generate models. For example, to create a model for the User table, you would run:

php artisan make:model User

Repeat this for each table. Below are the model files based on your SQL schema.

User Model

// app/Models/User.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class User extends Model
{
    use HasFactory;
    protected $table = 'users';
    protected $fillable = [
        'Username',
        'PasswordHash',
        'Email',
    ];
}

StockData Model

// app/Models/StockData.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class StockData extends Model
{
    use HasFactory;
    protected $table = 'stock_data';
    protected $fillable = [
        'StockSymbol',
        'Date',
        'OpenPrice',
        'ClosePrice',
        'HighPrice',
        'LowPrice',
        'Volume',
    ];
}

EconomicIndicators Model

// app/Models/EconomicIndicators.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class EconomicIndicators extends Model
{
    use HasFactory;
    protected $table = 'economic_indicators';
    protected $fillable = [
        'IndicatorName',
        'Value',
        'Date',
    ];
}

Predictions Model

// app/Models/Predictions.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Predictions extends Model
{
    use HasFactory;
    protected $table = 'predictions';
    protected $fillable = [
        'StockSymbol',
        'PredictedPrice',
        'PredictionDate',
        'ModelUsed',
 ];
}

TradingStrategies Model

// app/Models/TradingStrategies.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class TradingStrategies extends Model
{
    use HasFactory;
    protected $table = 'trading_strategies';
    protected $fillable = [
        'StrategyName',
        'Description',
    ];
}

Portfolios Model

// app/Models/Portfolios.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Portfolios extends Model
{
    use HasFactory;
    protected $table = 'portfolios';
    protected $fillable = [
        'User  Id',
        'PortfolioName',
    ];
}

PortfolioStocks Model

// app/Models/PortfolioStocks.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class PortfolioStocks extends Model
{
    use HasFactory;
    protected $table = 'portfolio_stocks';
    protected $fillable = [
        'PortfolioId',
        'StockSymbol',
        'Quantity',
        'PurchasePrice',
    ];
}

PerformanceReports Model

// app/Models/PerformanceReports.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class PerformanceReports extends Model
{
    use HasFactory;
    protected $table = 'performance_reports';
    protected $fillable = [
        'PortfolioId',
        'ReportDate',
        'TotalValue',
        'TotalReturn',
    ];
}

Alerts Model

// app/Models/Alerts.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Alerts extends Model
{
    use HasFactory;
    protected $table = 'alerts';
    protected $fillable = [
        'User  Id',
        'StockSymbol',
        'AlertType',
        'Threshold',
        'IsActive',
    ];
}

Step 3: Run Migrations

After creating the migration files and models, you can run the migrations to create the tables in your database:

php artisan migrate

This will set up your database schema according to the provided SQL structure, and you will have the corresponding Eloquent models ready for use in your Laravel application.

To create controllers for each model with complete CRUD operations in Laravel

You can use the Artisan command to generate resource controllers. Each controller will handle the basic CRUD operations: Create, Read, Update, and Delete. Below, I will provide the commands to create the controllers and the basic structure for each controller.

Step 1: Create Resource Controllers

You can create a resource controller for each model using the following command:

php artisan make:controller UserController --resource
php artisan make:controller StockDataController --resource
php artisan make:controller EconomicIndicatorsController --resource
php artisan make:controller PredictionsController --resource
php artisan make:controller TradingStrategiesController --resource
php artisan make:controller PortfoliosController --resource
php artisan make:controller PortfolioStocksController --resource
php artisan make:controller PerformanceReportsController --resource
php artisan make:controller AlertsController --resource

Step 2: Implement CRUD Operations

Below are the basic implementations for each controller. You will need to adjust the views and routes accordingly.

UserController

// app/Http/Controllers/UserController.php
namespace App\Http\Controllers;
use App\Models\User;
use Illuminate\Http\Request;
class UserController extends Controller
{
    public function index()
    {
        $users = User::all();
        return view('users.index', compact('users'));
    }
    public function create()
    {
        return view('users.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'Username' => 'required|unique:users|max:50',
            'PasswordHash' => 'required',
            'Email' => 'required|email|unique:users|max:100',
        ]);
        User::create($request->all());
        return redirect()->route('users.index')->with('success', 'User  created successfully.');
    }
    public function show(User $user)
    {
        return view('users.show', compact('user'));
    }
    public function edit(User $user)
    {
        return view('users.edit', compact('user'));
    }
    public function update(Request $request, User $user)
    {
        $request->validate([
            'Username' => 'required|max:50|unique:users,Username,' . $user->id,
            'PasswordHash' => 'required',
            'Email' => 'required|email|max:100|unique:users,Email,' . $user->id,
        ]);
        $user->update($request->all());
        return redirect()->route('users.index')->with('success', 'User  updated successfully.');
    }
    public function destroy(User $user)
    {
        $user->delete();
        return redirect()->route('users.index')->with('success', 'User  deleted successfully.');
    }
}

StockDataController

// app/Http/Controllers/StockDataController.php
namespace App\Http\Controllers;
use App\Models\StockData;
use Illuminate\Http\Request;
class StockDataController extends Controller
{
    public function index()
    {
        $stockData = StockData::all();
        return view('stock_data.index', compact('stockData'));
    }
    public function create()
    {
        return view('stock_data.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'StockSymbol' => 'required|max:10',
            'Date' => 'required|date',
            'OpenPrice' => 'required|numeric',
            'ClosePrice' => 'required|numeric',
            'HighPrice' => 'required|numeric',
            'LowPrice' => 'required|numeric',
            'Volume' => 'required|integer',
        ]);
        StockData::create($request->all());
        return redirect()->route('stock_data.index')->with('success', 'Stock data created successfully.');
    }
    public function show(StockData $stockData)
    {
        return view('stock_data.show', compact('stockData'));
    }
    public function edit(StockData $stockData)
    {
        return view('stock_data.edit', compact('stockData'));
    }
    public function update(Request $request, StockData $stockData)
    {
        $request->validate([
            'StockSymbol' => 'required|max:10',
            'Date' => 'required|date',
            'OpenPrice' => 'required|numeric',
            'ClosePrice' => 'required|numeric',
            'HighPrice' => 'required|numeric',
            'LowPrice' => 'required|numeric',
            'Volume' => 'required|integer',
        ]);
        $stockData->update($request->all());
        return redirect()->route('stock_data.index')->with('success', 'Stock data updated successfully.');
    }
    public function destroy(StockData $stockData)
    {
        $stockData->delete();
        return redirect()->route('stock_data.index')->with('success', 'Stock data deleted successfully.');
    }
}

EconomicIndicatorsController

// app/Http/Controllers/EconomicIndicatorsController.php
namespace App\Http\Controllers;
use App\Models\EconomicIndicators;
use Illuminate\Http\Request;
class EconomicIndicatorsController extends Controller
{
    public function index()
    {
        $indicators = EconomicIndicators::all();
        return view('economic_indicators.index', compact('indicators'));
    }
    public function create()
    {
        return view('economic_indicators.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'IndicatorName' => 'required|max:100',
            'Value' => 'required|numeric',
            'Date' => 'required|date',
        ]);
        EconomicIndicators::create($request->all());
        return redirect()->route('economic_indicators.index')->with('success', 'Economic indicator created successfully.');
    }
    public function show(EconomicIndicators $indicator)
    {
        return view('economic_indicators.show', compact('indicator'));
    }
    public function edit(EconomicIndicators $indicator)
    {
        return view('economic_indicators.edit', compact('indicator'));
    }
    public function update(Request $request, EconomicIndicators $indicator)
    {
        $request->validate([
            'IndicatorName' => 'required|max:100',
            'Value' => 'required|numeric',
            'Date' => 'required|date',
        ]);
        $indicator->update($request->all());
        return redirect()->route('economic_indicators.index')->with('success', 'Economic indicator updated successfully.');
    }
    public function destroy(EconomicIndicators $indicator)
    {
        $indicator->delete();
        return redirect()->route('economic_indicators.index')->with('success', 'Economic indicator deleted successfully.');
    }
}

PredictionsController

// app/Http/Controllers/PredictionsController.php
namespace App\Http\Controllers;
use App\Models\Predictions;
use Illuminate\Http\Request;
class PredictionsController extends Controller
{
    public function index()
    {
        $predictions = Predictions::all();
        return view('predictions.index', compact('predictions'));
    }
    public function create()
    {
        return view('predictions.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'StockSymbol' => 'required|max:10',
            'PredictedPrice' => 'required|numeric',
            'PredictionDate' => 'required|date',
            'ModelUsed' => 'nullable|max:100',
        ]);
        Predictions::create($request->all());
        return redirect()->route('predictions.index')->with('success', 'Prediction created successfully.');
    }
    public function show(Predictions $prediction)
    {
        return view('predictions.show', compact('prediction'));
    }
    public function edit(Predictions $prediction)
    {
        return view('predictions.edit', compact('prediction'));
    }
    public function update(Request $request, Predictions $prediction)
    {
        $request->validate([
            'StockSymbol' => 'required|max:10',
            'PredictedPrice' => 'required|numeric',
            'PredictionDate' => 'required|date',
            'ModelUsed' => 'nullable|max:100',
        ]);
        $prediction->update($request->all());
        return redirect()->route('predictions.index')->with('success', 'Prediction updated successfully.');
    }
    public function destroy(Predictions $prediction)
    {
        $prediction->delete();
        return redirect()->route('predictions.index')->with('success', 'Prediction deleted successfully.');
    }
}

TradingStrategiesController

// app/Http/Controllers/TradingStrategiesController.php
namespace App\Http\Controllers;
use App\Models\TradingStrategies;
use Illuminate\Http\Request;
class TradingStrategiesController extends Controller
{
    public function index()
    {
        $strategies = TradingStrategies::all();
        return view('trading_strategies.index', compact('strategies'));
    }
    public function create()
    {
        return view('trading_strategies.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'StrategyName' => 'required|max:100',
            'Description' => 'nullable',
        ]);
        TradingStrategies::create($request->all());
        return redirect()->route('trading_strategies.index')->with('success', 'Trading strategy created successfully.');
    }
    public function show(TradingStrategies $strategy)
    {
        return view('trading_strategies.show', compact('strategy'));
    }
    public function edit(TradingStrategies $strategy)
    {
        return view('trading_strategies.edit', compact('strategy'));
    }
    public function update(Request $request, TradingStrategies $strategy)
    {
        $request->validate([
            'StrategyName' => 'required|max:100',
            'Description' => ' nullable',
        ]);
        $strategy->update($request->all());
        return redirect()->route('trading_strategies.index')->with('success', 'Trading strategy updated successfully.');
    }
    public function destroy(TradingStrategies $strategy)
    {
        $strategy->delete();
        return redirect()->route('trading_strategies.index')->with('success', 'Trading strategy deleted successfully.');
    }
}

PortfoliosController

// app/Http/Controllers/PortfoliosController.php
namespace App\Http\Controllers;
use App\Models\Portfolios;
use Illuminate\Http\Request;
class PortfoliosController extends Controller
{
    public function index()
    {
        $portfolios = Portfolios::all();
        return view('portfolios.index', compact('portfolios'));
    }
    public function create()
    {
        return view('portfolios.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'User  Id' => 'required|exists:users,id',
            'PortfolioName' => 'required|max:100',
        ]);
        Portfolios::create($request->all());
        return redirect()->route('portfolios.index')->with('success', 'Portfolio created successfully.');
    }
    public function show(Portfolios $portfolio)
    {
        return view('portfolios.show', compact('portfolio'));
    }
    public function edit(Portfolios $portfolio)
    {
        return view('portfolios.edit', compact('portfolio'));
    }
    public function update(Request $request, Portfolios $portfolio)
    {
        $request->validate([
            'User  Id' => 'required|exists:users,id',
            'PortfolioName' => 'required|max:100',
        ]);
        $portfolio->update($request->all());
        return redirect()->route('portfolios.index')->with('success', 'Portfolio updated successfully.');
    }
    public function destroy(Portfolios $portfolio)
    {
        $portfolio->delete();
        return redirect()->route('portfolios.index')->with('success', 'Portfolio deleted successfully.');
    }
}

PortfolioStocksController

// app/Http/Controllers/PortfolioStocksController.php
namespace App\Http\Controllers;
use App\Models\PortfolioStocks;
use Illuminate\Http\Request;
class PortfolioStocksController extends Controller
{
    public function index()
    {
        $portfolioStocks = PortfolioStocks::all();
        return view('portfolio_stocks.index', compact('portfolioStocks'));
    }
    public function create()
    {
        return view('portfolio_stocks.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'PortfolioId' => 'required|exists:portfolios,id',
            'StockSymbol' => 'required|max:10',
            'Quantity' => 'required|integer',
            'PurchasePrice' => 'required|numeric',
        ]);
        PortfolioStocks::create($request->all());
        return redirect()->route('portfolio_stocks.index')->with('success', 'Portfolio stock created successfully.');
    }
    public function show(PortfolioStocks $portfolioStock)
    {
        return view('portfolio_stocks.show', compact('portfolioStock'));
    }
    public function edit(PortfolioStocks $portfolioStock)
    {
        return view('portfolio_stocks.edit', compact('portfolioStock'));
    }
    public function update(Request $request, PortfolioStocks $portfolioStock)
    {
        $request->validate([
            'PortfolioId' => 'required|exists:portfolios,id',
            'StockSymbol' => 'required|max:10',
            'Quantity' => 'required|integer',
            'PurchasePrice' => 'required|numeric',
        ]);
        $portfolioStock->update($request->all());
        return redirect()->route('portfolio_stocks.index')->with('success', 'Portfolio stock updated successfully.');
    }
    public function destroy(PortfolioStocks $portfolioStock)
    {
        $portfolioStock->delete();
        return redirect()->route('portfolio_stocks.index')->with('success', 'Portfolio stock deleted successfully.');
    }
}

PerformanceReportsController

// app/Http/Controllers/PerformanceReportsController.php
namespace App\Http\Controllers;
use App\Models\PerformanceReports;
use Illuminate\Http\Request;
class PerformanceReportsController extends Controller
{
    public function index()
    {
        $reports = PerformanceReports::all();
        return view('performance_reports.index', compact('reports'));
    }
    public function create()
    {
        return view('performance_reports.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'PortfolioId' => 'required|exists:portfolios,id',
            'ReportDate' => 'required|date',
            'TotalValue' => 'required|numeric',
            'TotalReturn' => 'required|numeric',
        ]);
        PerformanceReports::create($request->all());
        return redirect()->route('performance_reports.index')->with('success', 'Performance report created successfully.');
    }
    
    public function show(PerformanceReports $report)
    {
        return view('performance_reports.show', compact('report'));
    }
    public function edit(PerformanceReports $report)
    {
        return view('performance_reports.edit', compact('report'));
    }
    public function update(Request $request, PerformanceReports $report)
    {
        $request->validate([
            'PortfolioId' => 'required|exists:portfolios,id',
            'ReportDate' => 'required|date',
            'TotalValue' => 'required|numeric',
            'TotalReturn' => 'required|numeric',
        ]);
        $report->update($request->all());
        return redirect()->route('performance_reports.index')->with('success', 'Performance report updated successfully.');
    }
    public function destroy(PerformanceReports $report)
    {
        $report->delete();
        return redirect()->route('performance_reports.index')->with('success', 'Performance report deleted successfully.');
    }
}

AlertsController

// app/Http/Controllers/AlertsController.php
namespace App\Http\Controllers;
use App\Models\Alerts;
use Illuminate\Http\Request;
class AlertsController extends Controller
{
    public function index()
    {
        $alerts = Alerts::all();
        return view('alerts.index', compact('alerts'));
    }
    public function create()
    {
        return view('alerts.create');
    }
    public function store(Request $request)
    {
        $request->validate([
            'User   Id' => 'required|exists:users,id',
            'StockSymbol' => 'required|max:10',
            'AlertType' => 'required|max:50',
            'Threshold' => 'required|numeric',
            'IsActive' => 'boolean',
        ]);
        Alerts::create($request->all());
        return redirect()->route('alerts.index')->with('success', 'Alert created successfully.');
    }
    public function show(Alerts $alert)
    {
        return view('alerts.show', compact('alert'));
    }
    public function edit(Alerts $alert)
    {
        return view('alerts.edit', compact('alert'));
    }
    public function update(Request $request, Alerts $alert)
    {
        $request->validate([
            'User   Id' => 'required|exists:users,id',
            'StockSymbol' => 'required|max:10',
            'AlertType' => 'required|max:50',
            'Threshold' => 'required|numeric',
            'IsActive' => 'boolean',
        ]);
        $alert->update($request->all());
        return redirect()->route('alerts.index')->with('success', 'Alert updated successfully.');
    }
    public function destroy(Alerts $alert)
    {
        $alert->delete();
        return redirect()->route('alerts.index')->with('success', 'Alert deleted successfully.');
    }
}

Step 3: Define Routes

You will need to define routes for each controller in your routes/web.php file. Here's an example of how to set up the routes for the User Controller:

use App\Http\Controllers\UserController;
use App\Http\Controllers\StockDataController;
use App\Http\Controllers\EconomicIndicatorsController;
use App\Http\Controllers\PredictionsController;
use App\Http\Controllers\TradingStrategiesController;
use App\Http\Controllers\PortfoliosController;
use App\Http\Controllers\PortfolioStocksController;
use App\Http\Controllers\PerformanceReportsController;
use App\Http\Controllers\AlertsController;
Route::resource('users', UserController::class);
Route::resource('stock_data', StockDataController::class);
Route::resource('economic_indicators', EconomicIndicatorsController::class);
Route::resource('predictions', PredictionsController::class);
Route::resource('trading_strategies', TradingStrategiesController::class);
Route::resource('portfolios', PortfoliosController::class);
Route::resource('portfolio_stocks', PortfolioStocksController::class);
Route::resource('performance_reports', PerformanceReportsController::class);
Route::resource('alerts', AlertsController::class);

Step 4: Create Views

You will also need to create the corresponding views for each of the CRUD operations. The views should be placed in the resources/views directory, organized by model name (e.g., users, stock_data, etc.). Each view will typically include forms for creating and editing records, as well as tables for displaying lists of records.

This setup will provide a complete CRUD interface for each model in your Laravel application.

Step 5: Create Views for Each Model

Below are examples of how to create basic views for each model. You can customize these views according to your design preferences.

Users Views

Index View (resources/views/users/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Users</h1>
    <a href="{{ route('users.create') }}">Create User</a>
    <table>
        <thead>
            <tr>
                <th>Username</th>
                <th>Email</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($users as $user)
                <tr>
                    <td>{{ $user->Username }}</td>
                    <td>{{ $user->Email }}</td>
                    <td>
                        <a href="{{ route('users.edit', $user) }}">Edit</a>
                        <form action="{{ route('users.destroy', $user) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/users/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create User</h1>
    <form action="{{ route('users.store') }}" method="POST">
        @csrf
        <label for="Username">Username:</label>
        <input type="text" name="Username" required>
        <label for="PasswordHash">Password:</label>
        <input type="password" name="PasswordHash" required>
        <label for="Email">Email:</label>
        <input type="email" name="Email" required>
        <button type="submit">Create</button>
    </form>
@endsection

Edit View (resources/views/users/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit User</h1>
    <form action="{{ route('users.update', $user) }}" method="POST">
        @csrf
        @method('PUT')
        <label for="Username">Username:</label>
        <input type="text" name="Username" value="{{ $user->Username }}" required>
        <label for="PasswordHash">Password:</label>
        <input type="password" name="PasswordHash" required>
        <label for="Email">Email:</label>
        <input type="email" name="Email" value="{{ $user->Email }}" required>
        <button type="submit">Update</button>
    </form>
@endsection

StockData Views

Index View (resources/views/stock_data/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Stock Data</h1>
    <a href="{{ route('stock_data.create') }}">Create Stock Data</a>
    <table>
        <thead>
            <tr>
                <th>Stock Symbol</th>
                <th>Date</th>
                <th>Open Price</th>
                <th>Close Price</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($stockData as $data)
                <tr>
                    <td>{{ $data->StockSymbol }}</td>
                    <td>{{ $data->Date }}</td>
                    <td>{{ $data->OpenPrice }}</td>
                    <td>{{ $data->ClosePrice }}</td>
                    <td>
                        <a href="{{ route('stock_data.edit', $data) }}">Edit</a>
                        <form action="{{ route('stock_data.destroy', $data) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/stock_data/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Stock Data</h1>
    <form action="{{ route('stock_data.store') }}" method="POST">
        @csrf
        <label for="StockSymbol">Stock Symbol:</label>
        <input type="text" name="StockSymbol" required>
        <label for="Date">Date:</label>
        <input type="date" name="Date" required>
        <label for="OpenPrice">Open Price:</label>
        <input type="number" step="0.01" name="OpenPrice" required>
 <label for="ClosePrice">Close Price:</label>
        <input type="number" step="0.01" name="ClosePrice" required>
        <label for="HighPrice">High Price:</label>
        <input type="number" step="0.01" name="HighPrice" required>
        <label for="LowPrice">Low Price:</label>
        <input type="number" step="0.01" name="LowPrice" required>
        <label for="Volume">Volume:</label>
        <input type="number" name="Volume" required>
        <button type="submit">Create</button>
    </form>
@endsection

Edit View (resources/views/stock_data/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Stock Data</h1>
    <form action="{{ route('stock_data.update', $stockData) }}" method="POST">
        @csrf
        @method('PUT')
        <label for="StockSymbol">Stock Symbol:</label>
        <input type="text" name="StockSymbol" value="{{ $stockData->StockSymbol }}" required>
        <label for="Date">Date:</label>
        <input type="date" name="Date" value="{{ $stockData->Date }}" required>
        <label for="OpenPrice">Open Price:</label>
        <input type="number" step="0.01" name="OpenPrice" value="{{ $stockData->OpenPrice }}" required>
        <label for="ClosePrice">Close Price:</label>
        <input type="number" step="0.01" name="ClosePrice" value="{{ $stockData->ClosePrice }}" required>
        <label for="HighPrice">High Price:</label>
        <input type="number" step="0.01" name="HighPrice" value="{{ $stockData->HighPrice }}" required>
        <label for="LowPrice">Low Price:</label>
        <input type="number" step="0.01" name="LowPrice" value="{{ $stockData->LowPrice }}" required>
        <label for="Volume">Volume:</label>
        <input type="number" name="Volume" value="{{ $stockData->Volume }}" required>
        <button type="submit">Update</button>
    </form>
@endsection

EconomicIndicators Views

Index View (resources/views/economic_indicators/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Economic Indicators</h1>
    <a href="{{ route('economic_indicators.create') }}">Create Economic Indicator</a>
    <table>
        <thead>
            <tr>
                <th>Indicator Name</th>
                <th>Value</th>
                <th>Date</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($indicators as $indicator)
                <tr>
                    <td>{{ $indicator->IndicatorName }}</td>
                    <td>{{ $indicator->Value }}</td>
                    <td>{{ $indicator->Date }}</td>
                    <td>
                        <a href="{{ route('economic_indicators.edit', $indicator) }}">Edit</a>
                        <form action="{{ route('economic_indicators.destroy', $indicator) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/economic_indicators/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Economic Indicator</h1>
    <form action="{{ route('economic_indicators.store') }}" method="POST">
        @csrf
        <label for="IndicatorName">Indicator Name:</label>
        <input type="text" name="IndicatorName" required>
        <label for="Value">Value:</label>
        <input type="number" step="0.01" name="Value" required>
        <label for="Date">Date:</label>
        <input type="date" name="Date" required>
        <button type="submit">Create</button>
    </form>
@endsection

Edit View (resources/views/economic_indicators/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Economic Indicator</h1>
    <form action="{{ route('economic_indicators.update', $indicator) }}" method="POST">
        @csrf
        @method('PUT')
        <label for="IndicatorName">Indicator Name:</label>
        <input type="text" name="IndicatorName" value="{{ $indicator->IndicatorName }}" required>
        <label for="Value">Value:</label>
        <input type="number" step="0.01" name="Value" value="{{ $indicator->Value }}" required>
        <label for="Date">Date:</label>
        <input type="date" name="Date" value="{{ $indicator->Date }}" required>
        <button type="submit">Update</button>
    </form>
@endsection

Predictions Views

Index View (resources/views/predictions/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Predictions</h1>
    <a href="{{ route('predictions.create') }}">Create Prediction</a>
    <table>
        <thead>
            <tr>
                <th>Stock Symbol</th>
                <th>Predicted Price</th>
                <th>Prediction Date</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($predictions as $prediction)
                <tr>
                    <td>{{ $prediction->StockSymbol }}</td>
                    <td>{{ $prediction->PredictedPrice }}</td>
                    <td>{{ $prediction->PredictionDate }}</td>
                    <td>
                        <a href="{{ route('predictions.edit', $prediction) }}">Edit</a>
                        <form action="{{ route('predictions.destroy', $prediction) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/predictions/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Prediction</h1>
    <form action="{{ route('predictions.store') }}" method="POST">
        @csrf
        <label for="StockSymbol">Stock Symbol:</label>
        <input type="text" name="StockSymbol" required>
        <label for="PredictedPrice">Predicted Price:</label>
        <input type="number" step="0.01" name="PredictedPrice" required>
        <label for="PredictionDate">Prediction Date:</label>
        <input type="date" name="PredictionDate" required>
        <label for="ModelUsed">Model Used:</label>
        <input type="text" name="ModelUsed">
        <button type="submit">Create</button>
    </form>
@endsection

Edit View (resources/views/predictions/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Prediction</h1>
    <form action="{{ route('predictions.update', $prediction) }}" method="POST">
        @csrf
        @method('PUT')
        <label for="StockSymbol">Stock Symbol:</label>
        <input type="text" name="StockSymbol" value="{{ $prediction->StockSymbol }}" required>
        <label for="PredictedPrice">Predicted Price:</label>
        <input type="number" step="0.01" name="PredictedPrice" value="{{ $prediction->PredictedPrice }}" required>
        <label for="PredictionDate">Prediction Date:</label>
        <input type="date" name="PredictionDate" value="{{ $prediction->PredictionDate }}" required>
        <label for="ModelUsed">Model Used:</label>
        <input type="text" name="ModelUsed" value="{{ $prediction->ModelUsed }}">
        <button type="submit">Update</button>
    </form>
@endsection

Portfolios Views

Index View (resources/views/portfolios/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Portfolios</h1>
    <a href="{{ route('portfolios.create') }}" class="btn btn-primary mb-3">Create Portfolio</a>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Portfolio Name</th>
                <th>User ID</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($portfolios as $portfolio)
                <tr>
                    <td>{{ $portfolio->PortfolioName }}</td>
                    <td>{{ $portfolio->User Id }}</td>
                    <td>
                        <a href="{{ route('portfolios.edit', $portfolio) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('portfolios.destroy', $portfolio) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/portfolios/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Portfolio</h1>
    <form action="{{ route('portfolios.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="User Id" class="form-label">User  ID:</label>
            <input type="number" name="User Id" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="PortfolioName" class="form-label">Portfolio Name:</label>
            <input type="text" name="PortfolioName" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
    </form>
@endsection

Edit View (resources/views/portfolios/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Portfolio</h1>
    <form action="{{ route('portfolios.update', $portfolio) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="User Id" class="form-label">User  ID:</label>
            <input type="number" name="User Id" class="form-control" value="{{ $portfolio->User Id }}" required>
        </div>
        <div class="mb-3">
            <label for="PortfolioName" class="form-label">Portfolio Name:</label>
            <input type="text" name="PortfolioName" class="form-control" value="{{ $portfolio->PortfolioName }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
    </form>
@endsection

PortfolioStocks Views

Index View (resources/views/portfolio_stocks/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Portfolio Stocks</h1>
    <a href="{{ route('portfolio_stocks.create') }}" class="btn btn-primary mb-3">Create Portfolio Stock</a>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Portfolio ID</th>
                <th>Stock Symbol</th>
                <th>Quantity</th>
                <th>Purchase Price</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($portfolioStocks as $portfolioStock)
                <tr>
                    <td>{{ $portfolioStock->PortfolioId }}</td>
                    <td>{{ $portfolioStock->StockSymbol }}</td>
                    <td>{{ $portfolioStock->Quantity }}</td>
                    <td>{{ $portfolioStock->PurchasePrice }}</td>
                    <td>
                        <a href="{{ route('portfolio_stocks.edit', $portfolioStock) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('portfolio_stocks.destroy', $portfolioStock) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/portfolio_stocks/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Portfolio Stock</h1>
    <form action="{{ route('portfolio_stocks.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="PortfolioId" class="form-label">Portfolio ID:</label>
            <input type="number" name="PortfolioId" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="StockSymbol" class="form-label">Stock Symbol:</label>
            <input type="text" name="StockSymbol" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Quantity" class="form-label">Quantity:</label>
            <input type="number" name="Quantity" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="PurchasePrice" class="form-label">Purchase Price:</label>
            <input type="number" step="0.01" name="PurchasePrice" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
    </form>
@endsection

Edit View (resources/views/portfolio_stocks/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Portfolio Stock</h1>
    <form action="{{ route('portfolio_stocks.update', $portfolioStock) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="PortfolioId" class="form-label">Portfolio ID:</label>
            <input type="number" name="PortfolioId" class="form-control" value="{{ $portfolioStock->PortfolioId }}" required>
        </div>
        <div class="mb-3">
            <label for="StockSymbol" class="form-label">Stock Symbol:</label>
            <input type="text" name="StockSymbol" class="form-control" value="{{ $portfolioStock->StockSymbol }}" required>
        </div>
        <div class="mb-3">
            <label for="Quantity" class="form-label">Quantity:</label>
            <input type="number" name="Quantity" class="form-control" value="{{ $portfolioStock->Quantity }}" required>
        </div>
        <div class="mb-3">
            <label for="PurchasePrice" class="form-label">Purchase Price:</label>
            <input type="number" step="0.01" name="PurchasePrice" class="form-control" value="{{ $portfolioStock->PurchasePrice }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
    </form>
@endsection

PerformanceReports Views

Index View (resources/views/performance_reports/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Performance Reports</h1>
    <a href="{{ route('performance_reports.create') }}" class="btn btn-primary mb-3">Create Performance Report</a>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Portfolio ID</th>
                <th>Report Date</th>
                <th>Total Value</th>
                <th>Total Return</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($reports as $report)
                <tr>
                    <td>{{ $report->PortfolioId }}</td>
                    <td>{{ $report->ReportDate }}</td>
                    <td>{{ $report->TotalValue }}</td>
                    <td>{{ $report->TotalReturn }}</td>
                    <td>
                        <a href="{{ route('performance_reports.edit', $report) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('performance_reports.destroy', $report) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/performance_reports/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Performance Report</h1>
    <form action="{{ route('performance_reports.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="PortfolioId" class=" form-label">Portfolio ID:</label>
            <input type="number" name="PortfolioId" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="ReportDate" class="form-label">Report Date:</label>
            <input type="date" name="ReportDate" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="TotalValue" class="form-label">Total Value:</label>
            <input type="number" step="0.01" name="TotalValue" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="TotalReturn" class="form-label">Total Return:</label>
            <input type="number" step="0.01" name="TotalReturn" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
    </form>
@endsection

Edit View (resources/views/performance_reports/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Performance Report</h1>
    <form action="{{ route('performance_reports.update', $report) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="PortfolioId" class="form-label">Portfolio ID:</label>
            <input type="number" name="PortfolioId" class="form-control" value="{{ $report->PortfolioId }}" required>
        </div>
        <div class="mb-3">
            <label for="ReportDate" class="form-label">Report Date:</label>
            <input type="date" name="ReportDate" class="form-control" value="{{ $report->ReportDate }}" required>
        </div>
        <div class="mb-3">
            <label for="TotalValue" class="form-label">Total Value:</label>
            <input type="number" step="0.01" name="TotalValue" class="form-control" value="{{ $report->TotalValue }}" required>
        </div>
        <div class="mb-3">
            <label for="TotalReturn" class="form-label">Total Return:</label>
            <input type="number" step="0.01" name="TotalReturn" class="form-control" value="{{ $report->TotalReturn }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
    </form>
@endsection

Alerts Views

Index View (resources/views/alerts/index.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Alerts</h1>
    <a href="{{ route('alerts.create') }}" class="btn btn-primary mb-3">Create Alert</a>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>User ID</th>
                <th>Stock Symbol</th>
                <th>Alert Type</th>
                <th>Threshold</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($alerts as $alert)
                <tr>
                    <td>{{ $alert->User  Id }}</td>
                    <td>{{ $alert->StockSymbol }}</td>
                    <td>{{ $alert->AlertType }}</td>
                    <td>{{ $alert->Threshold }}</td>
                    <td>
                        <a href="{{ route('alerts.edit', $alert) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('alerts.destroy', $alert) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Create View (resources/views/alerts/create.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Create Alert</h1>
    <form action="{{ route('alerts.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="User  Id" class="form-label">User  ID:</label>
            <input type="number" name="User  Id" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="StockSymbol" class="form-label">Stock Symbol:</label>
            <input type="text" name="StockSymbol" class="form-control" required>
        </div>
 <div class="mb-3">
            <label for="AlertType" class="form-label">Alert Type:</label>
            <input type="text" name="AlertType" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Threshold" class="form-label">Threshold:</label>
            <input type="number" step="0.01" name="Threshold" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="IsActive" class="form-label">Is Active:</label>
            <select name="IsActive" class="form-select">
                <option value="1">Yes</option>
                <option value="0">No</option>
            </select>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
    </form>
@endsection

Edit View (resources/views/alerts/edit.blade.php)

@extends('layouts.app')
@section('content')
    <h1>Edit Alert</h1>
    <form action="{{ route('alerts.update', $alert) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="User   Id" class="form-label">User   ID:</label>
            <input type="number" name="User   Id" class="form-control" value="{{ $alert->User   Id }}" required>
        </div>
        <div class="mb-3">
            <label for="StockSymbol" class="form-label">Stock Symbol:</label>
            <input type="text" name="StockSymbol" class="form-control" value="{{ $alert->StockSymbol }}" required>
        </div>
        <div class="mb-3">
            <label for="AlertType" class="form-label">Alert Type:</label>
            <input type="text" name="AlertType" class="form-control" value="{{ $alert->AlertType }}" required>
        </div>
        <div class="mb-3">
            <label for="Threshold" class="form-label">Threshold:</label>
            <input type="number" step="0.01" name="Threshold" class="form-control" value="{{ $alert->Threshold }}" required>
        </div>
        <div class="mb-3">
            <label for="IsActive" class="form-label">Is Active:</label>
            <select name="IsActive" class="form-select">
                <option value="1" {{ $alert->IsActive ? 'selected' : '' }}>Yes</option>
                <option value="0" {{ !$alert->IsActive ? 'selected' : '' }}>No</option>
            </select>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
    </form>
@endsection

This completes the view files for all controllers, styled using Bootstrap 5. Each view is designed to provide a user-friendly interface for managing the respective models in your Laravel application.

Layout File

Below is a complete layout view file for your Laravel application, which uses Bootstrap 5 for styling. This layout file will serve as a base for all your views, providing a consistent look and feel across your application.

Layout File (resources/views/layouts/app.blade.php)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>@yield('title', 'Laravel CRUD')</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="{{ asset('css/app.css') }}"> <!-- Optional custom CSS -->
</head>
<body>
    <nav class="navbar navbar-expand-lg navbar-light bg-light">
        <div class="container-fluid">
            <a class="navbar-brand" href="#">Laravel CRUD</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav">
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('users.index') }}">Users</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('stock_data.index') }}">Stock Data</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('economic_indicators.index') }}">Economic Indicators</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('predictions.index') }}">Predictions</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('trading_strategies.index') }}">Trading Strategies</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('portfolios.index') }}">Portfolios</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('portfolio_stocks.index') }}">Portfolio Stocks</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('performance_reports.index') }}">Performance Reports</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ route('alerts.index') }}">Alerts</a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>
    <div class="container mt-4">
        @if(session('success'))
            <div class="alert alert-success">{{ session('success') }}</div>
        @endif
        @if(session('error'))
            <div class="alert alert-danger">{{ session('error') }}</div>
        @endif
        @yield('content')
    </div>
    <footer class="bg-light text-center text-lg-start mt-4">
        <div class="text-center p-3">
            © {{ date('Y') }} Your Company Name
        </div>
    </footer>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

Explanation of the Layout File

HTML Structure: The layout file starts with the standard HTML5 doctype and includes the necessary <head> and <body> sections.

Bootstrap CSS: The Bootstrap 5 CSS is included via a CDN link, which allows you to use Bootstrap's styling features.

Navigation Bar: A responsive navigation bar is created using Bootstrap's navbar component. It includes links to all the main sections of your application (Users, Stock Data, Economic Indicators, etc.).

Content Section: The @yield('content') directive is used to define a section where the content of individual views will be injected.

Success/Error Messages: The layout includes a section to display success and error messages using Bootstrap's alert component.

Footer: A simple footer is added at the bottom of the page.

Bootstrap JS: The Bootstrap 5 JavaScript bundle is included at the end of the body to ensure that the page loads quickly.

Usage

To use this layout in your views, simply extend it at the top of your view files. For example:

@extends('layouts.app')
@section('content')
    <h1>Your Content Here</h1>
    <p>This is where your specific content will go.</p>
@endsection

How To Build Different Dashboards For Different Roles In Laravel

To create a dashboard page in Laravel for displaying consolidated project data, you should start by setting up a route and a controller method to handle the data retrieval. Then, create a view that will present the data in a user-friendly format. Consider using a layout file for consistency and Bootstrap for styling. You can also explore using packages like Filament for a more advanced dashboard setup.

Step 1: Define the Route

In your routes/web.php, add a route for the dashboard:

Route::get('/dashboard', [DashboardController::class, 'index'])->name('dashboard');

Step 2: Create the Controller

Generate a controller if you haven't already:

php artisan make:controller DashboardController

In app/Http/Controllers/DashboardController.php, implement the index method to fetch the consolidated data:

namespace App\Http\Controllers;
use App\Models\User;
use App\Models\Project;
use App\Models\Task;
use Illuminate\Http\Request;
class DashboardController extends Controller
{
    public function index()
    {
        $totalUsers = User::count();
        $totalProjects = Project::count();
        $totalTasks = Task::count();
        $completedTasks = Task::where('status', 'completed')->count();
        return view('dashboard.index', compact('totalUsers', 'totalProjects', 'totalTasks', 'completedTasks'));
    }
}

Step 3: Create the Dashboard View

Create a new view file at resources/views/dashboard/index.blade.php:

@extends('layouts.app')
@section('title', 'Dashboard')
@section('content')
    <h1 class="mb-4">Dashboard</h1>
    <div class="row">
        <div class="col-md-3">
            <div class="card text-white bg-primary mb-3">
                <div class="card-header">Total Users</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $totalUsers }}</h5>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Total Projects</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $totalProjects }}</h5>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-warning mb-3">
                <div class="card-header">Total Tasks</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $totalTasks }}</h5>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-info mb-3">
                <div class="card-header">Completed Tasks</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $completedTasks }}</h5>
                </div>
            </div>
        </div>
    </div>
@endsection

Step 4: Explanation of the Dashboard View

Card Layout: Each card represents a different metric (Total Users, Total Projects, Total Tasks, Completed Tasks) and uses Bootstrap's card component for styling.

Dynamic Data: The data displayed in each card is dynamically pulled from the controller and passed to the view.

Step 5: Accessing the Dashboard

You can now access your dashboard by navigating to /dashboard in your web browser. This will display the consolidated data related to your project in a visually appealing format.

Optional: Using Filament for Advanced Features

If you want to enhance your dashboard with more features, consider using Filament, a Laravel package that provides a beautiful admin panel and dashboard capabilities. You can install it via Composer and follow the documentation to set it up for your project.