iljaGolubev

namespace App\Http\Middleware;
use Closure;
use Symfony\Component\HttpKernel\Exception\BadRequestHttpException;
class AjaxOnly
{
public function handle($request, Closure $next)
    {
        if(!$request->ajax()){
            throw new BadRequestHttpException('This resource only accepts an ajax requests');
        }
        return $next($request);
    }
}

// Если созданы модели
$sales = Sales::find(1);
$purchases = Purchases:find(1);
$sales_column = $sales->any_column;
$purchases_column =  = $purchases->any_column; 

manipulation($sales_column , purchases_column );

$sales->update();
$purchases->update();

DB::statement(DB::raw('set @row:=0'));
City::where('people', '>', 100000)
    ->orderBy('people')
    ->select(['*',DB::raw('@row:=@row+1 as row')])
    ->find($chelyabinsk_id);

Route::get('/x/{user?}', 'HomeController@index');
Route::get('/xxxxxxx', 'HomeController@index');

@dd(
    action('HomeController@index'),
    action('HomeController@index',['im_a_guest']),
    )
/*
"http://laravel.local/xxxxxxx"
"http://laravel.local/xxxxxxx/im_a_guest"
*/