Visualize Laravel App Data with Chartello

 Chartello is a package to visualize your Laravel app data in simple dashboards:

You can create multiple dashboards to break up charts; for example, you could have a Sales dashboard and a Support dashboard. On the dashboards, you can create two kinds of panels:

1. Trend Charts
2. Tables

You can populate a trend chart using the following query, which contains placeholders for start and end dates:

SELECT DATE(created_at) AS x, COUNT(*) AS y
FROM users
WHERE created_at BETWEEN @start AND @end
GROUP BY x
ORDER BY x ASC

The placeholders mean your dashboards will adjust based on the selected date ranges for providing trend-based charts.

Table charts are more flexible as they can virtually accept any select combination of data and list the columns in a table:

This package also comes with a middleware to limit access to dashboards. You can configure authorization for the Chartello dashboard based on any custom logic you'd like.

You can see this package in action with the Read-only demo dashboard. You can learn more about this package, get full installation instructions, and view the source code on GitHub.

Read More

Filter and Search Eloquent Models with the Model Filter Package

 Laravel Model Filter offers a simple way to filter and search eloquent models by array parameters and query strings.

Here's a simple example to illustrate exactly how this package works. Given the following filter, you can generate with the provided make:filter command:

namespace App\Models\Filters;
 
use Lacodix\LaravelModelFilter\Filters\DateFilter;
 
class CreatedAfterFilter extends DateFilter
{
    public FilterMode $mode = FilterMode::GREATER_OR_EQUAL;
 
    protected string $field = 'created_at';
}

You can apply the CreatedAfterFilter on a model like the following example:

namespace App\Models;
 
use App\Models\Filters\CreatedAfterFilter;
use Illuminate\Database\Eloquent\Model;
use Lacodix\LaravelModelFilter\Traits\HasFilters;
 
class Post extends Model
{
    use HasFilters;
 
    protected array $filters = [
        CreatedAfterFilter::class,
    ];
}

You can then trigger the filter either programmatically or via query string:

Post::filter(['created_after_filter' => '2023-01-01'])->get();
 
// Multiple filters
Post::filter([
    'created_after_filter' => '2023-01-01',
    'published_filter' => true,
])->get();
 
// Or by query string: /posts?created_after_filter=2023-01-01
Post::filterByQueryString()->get();

This package includes many features related to filtering models, such as:

• Group filtering
• Filter validation
• Sorting
• Searching
• Date filter type
• String filter type
• Select filter type
• Numeric filter type
• Boolean filter type
• Trashed filter type
• Filtering on relations
• And more

Read More