Skip to content

Instantly share code, notes, and snippets.

@saaiful
saaiful / SearchBuilder.php
Last active May 9, 2024 00:29
Depth 1 SearchBuilder for DataTable
<?php
namespace App;
use Illuminate\Http\Request;
/**
* Depth 1 SearchBuilder for DataTable
* Supports Query Builder and Eloquent ORM
* To prevent unauthorized access to the database, the code uses two security measures.
@peterjaap
peterjaap / varnish6.vcl
Last active February 18, 2026 05:28
Updated Magento 2 Varnish 6 VCL, in cooperation with Varnish Software, see Xkey soft purge version here; https://gist.github.com/peterjaap/7f7bf11aa7d089792e8fcc2fb34760fa
# A number of these changes come form the following PR's; , combines changes in https://github.com/magento/magento2/pull/29360, https://github.com/magento/magento2/pull/28944 and https://github.com/magento/magento2/pull/28894, https://github.com/magento/magento2/pull/35228, https://github.com/magento/magento2/pull/36524, https://github.com/magento/magento2/pull/34323
# VCL version 5.0 is not supported so it should be 4.0 even though actually used Varnish version is 6
# See the Xkey version here: https://gist.github.com/peterjaap/7f7bf11aa7d089792e8fcc2fb34760fa
vcl 4.1;
import std;
# The minimal Varnish version is 6.0
# For SSL offloading, pass the following header in your proxy server or load balancer: '/* {{ ssl_offloaded_header }} */: https'
@armadeas
armadeas / SearchBuilderScope.php
Last active May 9, 2024 00:30
Yajra\DataTables\Contracts\DataTableScope for SearchBuilder
<?php
namespace App\DataTables\Scopes;
//use Debugbar;
use Yajra\DataTables\Contracts\DataTableScope;
//use App\Models\Concerns\SearchBuilder;
class SearchBuilderScope implements DataTableScope
<?php
namespace App\Models\Concerns;
trait SearchBuilder
{
public function scopeSearchBuilder($query)
{
if (request()->filled('searchBuilder') && request()->query('searchBuilder') !== 'false') {
$query->where(function ($query) {