FROM SQL query and Automated graph with filter and search

Is there any framework in laravel pho where u can just put the sql query and graph would be created automatically

Yes, there are Laravel-compatible solutions that can create automated graphs from SQL queries with filtering and search capabilities. Here are the best frameworks and tools to achieve this functionality:

1. Metabase (External Tool for Integration)

• What it is: Metabase is an open-source data visualization and analytics tool that integrates seamlessly with Laravel databases.
• How it works:
  • Connect Metabase to your Laravel database.
  • Write SQL queries or use the Metabase query builder.
  • It automatically generates graphs, charts, and dashboards.
  • Provides built-in filters and search options.
• Setup:
  • Install Metabase.
  • Connect it to your database (e.g., MySQL, PostgreSQL).
  • Use Metabase's UI to create visualizations.
• Website: Metabase

2. Laravel Nova with Nova Dashboards

• What it is: Laravel Nova is a powerful admin panel that supports customizable dashboards and integrates with SQL queries.
• How it works:
  • Use Nova Dashboards to create graphs by fetching data from SQL queries or Eloquent models.
  • Add filtering and search options directly in the Nova interface.
• Setup:
  • Install Laravel Nova.
  • Define SQL queries or use Nova's resource model.
  • Use Nova's chart components to render graphs.
• Website: Laravel Nova

3. Laravel Charts

• What it is: A Laravel package designed for creating graphs and charts using SQL queries or Eloquent models.
• How it works:
  • Pass SQL query results or Eloquent model data to Laravel Charts.
  • Supports multiple charting libraries like Chart.js, Highcharts, and Google Charts.
  • Filtering and search features can be added via UI controls or query parameters.
• Setup:
  • Install the package:

        composer require consoletvs/charts

  • Example:

        use ConsoleTVs\Charts\Facades\Charts;
    
        public function index()
        {
            $chart = Charts::database(DB::table('sales'), 'bar', 'highcharts')
                ->title('Sales Data')
                ->elementLabel('Total Sales')
                ->dimensions(1000, 500)
                ->responsive(true)
                ->groupBy('month');
    
            return view('chart', compact('chart'));
        }

• Website: Laravel Charts

4. Chartisan

• What it is: Chartisan is a Laravel-compatible charting library that works with SQL queries and integrates seamlessly with Chart.js and ApexCharts.

• How it works:

  • Define data in a Laravel route/controller.
  • Chartisan renders the graph with filters and search options.

• Setup:

  • Install Chartisan:

        composer require php-chartisan/chartisan

  • Example:

        // ChartController.php
        use Chartisan\PHP\Chartisan;
    
        public function graph()
        {
            return Chartisan::build()
                ->labels(['Jan', 'Feb', 'Mar'])
                ->dataset('Sales', [100, 200, 300]);
        }

  • Render the chart in your front end using Chart.js or ApexCharts.

• Website: Chartisan

5. Grafana (External Tool for Advanced Visualization)

• What it is: Grafana is a powerful open-source platform for visualizing SQL-based metrics and data with advanced filtering.
• How it works:
  • Connect Grafana to your Laravel database.
  • Write SQL queries to fetch data.
  • Use Grafana’s built-in UI to add filtering and search capabilities.
• Website: Grafana

6. Custom Solution with JavaScript Chart Libraries

If you prefer more control:

1. Fetch Data:
   • Use Laravel's query builder or raw SQL queries to fetch data.
   • Pass the data to the front end via an API or Blade view.
2. Integrate JavaScript Libraries:
   • Use libraries like Chart.js, Highcharts, or ApexCharts for rendering.
3. Add Filters and Search:
   • Use front-end libraries like DataTables or custom JavaScript for filter/search functionality.

Example with Chart.js:

$data = DB::table('sales')
    ->selectRaw('month, sum(amount) as total')
    ->groupBy('month')
    ->get();

return view('chart', ['data' => $data]);

// chart.blade.php
const ctx = document.getElementById('myChart').getContext('2d');
const data = @json($data);

new Chart(ctx, {
    type: 'bar',
    data: {
        labels: data.map(d => d.month),
        datasets: [{
            label: 'Total Sales',
            data: data.map(d => d.total),
        }]
    }
});

Recommendation

If you're looking for a Laravel-native solution, Laravel Nova or Laravel Charts is your best choice. For more advanced visualizations, consider Metabase or Grafana for integration. Both offer robust filtering and search capabilities with minimal setup.