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

Installing WordPress

 Installing WordPress

Installing WordPress is very easy and takes less than five minutes to complete. It is best known for its ease of installation. All web hosting companies allow WordPress installation within few clicks.

There are different methods to install WordPress on a system.

---

Methods to install WordPress

Using cPanel

This is the fastest and easiest way to install WordPress on your system using cPanel software. The most common tools available to automatically install WordPress are Softaculous, SimpleScripts, Fantastico and De Luxe. All the web hosts allow one-click installation through these tools.

You only have to choose one WordPress host and use installation script in cPanel. You will get your login details and URL link of cPanel via email after signing up for hosting plan.

Using MS Webmatrix

Read More