Category Archives: PHP

取得route中設定的網址參數

Route

Route::get('/products/{category}/{pid}-{name}', 'ProductC@product');

1	Route::get('/products/{category}/{pid}-{name}', 'ProductC@product');

Controller

$pid = $request->route('pid');

1	$pid = $request->route('pid');

Escape Like

Helper

function escape_like(string $value, string $char = '\\'): string
{
    return str_replace(
        [$char, '%', '_'],
        [$char.$char, $char.'%', $char.'_'],
        $value
    );
}

function escape_like(string $value, string $char = '\\'): string

{

return str_replace(

[$char, '%', '_'],

[$char.$char, $char.'%', $char.'_'],

$value

);

}

Reference:

https://stackoverflow.com/questions/22749182/laravel-escape-like-clause/42028380#42028380

laravel-permission

Official

https://github.com/spatie/laravel-permission

Doc

https://docs.spatie.be/laravel-permission/v3/basic-usage/role-permissions/

Model User

use Spatie\Permission\Traits\HasRoles;
use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;

class User extends Authenticatable
{
    use Notifiable;
    use HasRoles;
}

use Spatie\Permission\Traits\HasRoles;

use Spatie\Permission\Models\Role;

use Spatie\Permission\Models\Permission;

class User extends Authenticatable

{

use Notifiable;

use HasRoles;

}

Config “Super Admin” in AuthServiceProvider.php

public function boot()
    {
        $this->registerPolicies();

        //Implicitly grant "Super Admin" role all permissions
        // This works in the app by using gate-related functions like auth()->user->can() and @can()
        Gate::before(function ($user, $ability) {
            return $user->hasRole('Super Admin') ? true : null;
        });
    }

public function boot()

{

$this->registerPolicies();

//Implicitly grant "Super Admin" role all permissions

// This works in the app by using gate-related functions like auth()->user->can() and @can()

Gate::before(function ($user, $ability) {

return $user->hasRole('Super Admin') ? true : null;

});

}

Controller and related functions

        //$role = Role::create(['name' => 'Super Admin']);
        //$permission = Permission::create(['name' => 'view admins']);
        //$role->givePermissionTo($permission);
        $role = Role::find(2);
        $user = $this->guard()->user();
        $user->assignRole($role);
        logg($user->can('view admins'));
        logg($user);

//Sync permissions
$role->syncPermissions($permissions);

//Delete all permissions of this role
$role->syncPermissions();

//$role = Role::create(['name' => 'Super Admin']);

//$permission = Permission::create(['name' => 'view admins']);

//$role->givePermissionTo($permission);

$role = Role::find(2);

$user = $this->guard()->user();

$user->assignRole($role);

logg($user->can('view admins'));

logg($user);

//Sync permissions

$role->syncPermissions($permissions);

//Delete all permissions of this role

$role->syncPermissions();

Add useful function in model User

    //Check user count of a role before deleting a role
    static function role_user_count($role_id){
        $result = DB::table('model_has_roles')
            ->where('role_id', $role_id)
            ->count();
        return $result;
    }

//Check user count of a role before deleting a role

static function role_user_count($role_id){

$result = DB::table('model_has_roles')

->where('role_id', $role_id)

->count();

return $result;

}

Disable CSRF check for some route (page)

namespace App\Http\Middleware;

use Illuminate\Foundation\Http\Middleware\VerifyCsrfToken as BaseVerifier;

class VerifyCsrfToken extends BaseVerifier
{
  protected $except = [
    'payment/*',
  ];
}

namespace App\Http\Middleware;

use Illuminate\Foundation\Http\Middleware\VerifyCsrfToken as BaseVerifier;

class VerifyCsrfToken extends BaseVerifier

{

protected $except = [

'payment/*',

];

}

Reference:

https://stackoverflow.com/questions/31729415/disable-csrf-in-laravel-for-specific-route

Filter and Redirect Middleware

Middleware

    public function handle($request, Closure $next)
    {
        $user = Auth::guard('store')->user();
        $store_id = $user->store_id();
        //logg($request->path());
        if($store_id == false){
            if($request->is('store/info/create*') == false){
                return redirect()->route('store.create');
            }
        }

        return $next($request);
    }

public function handle($request, Closure $next)

{

$user = Auth::guard('store')->user();

$store_id = $user->store_id();

//logg($request->path());

if($store_id == false){

if($request->is('store/info/create*') == false){

return redirect()->route('store.create');

}

return $next($request);

}

Kernel

    protected $routeMiddleware = [
        'auth' => \App\Http\Middleware\Authenticate::class,
        'auth.basic' => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,
        'bindings' => \Illuminate\Routing\Middleware\SubstituteBindings::class,
        'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,
        'can' => \Illuminate\Auth\Middleware\Authorize::class,
        'guest' => \App\Http\Middleware\RedirectIfAuthenticated::class,
        'signed' => \Illuminate\Routing\Middleware\ValidateSignature::class,
        'throttle' => \Illuminate\Routing\Middleware\ThrottleRequests::class,
        'verified' => \Illuminate\Auth\Middleware\EnsureEmailIsVerified::class,
        'localization' => \App\Http\Middleware\Localization::class,
        //For pages that require a store first
        'check_store' => \App\Http\Middleware\CheckStore::class,
    ];

protected $routeMiddleware = [

'auth' => \App\Http\Middleware\Authenticate::class,

'auth.basic' => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,

'bindings' => \Illuminate\Routing\Middleware\SubstituteBindings::class,

'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,

'can' => \Illuminate\Auth\Middleware\Authorize::class,

'guest' => \App\Http\Middleware\RedirectIfAuthenticated::class,

'signed' => \Illuminate\Routing\Middleware\ValidateSignature::class,

'throttle' => \Illuminate\Routing\Middleware\ThrottleRequests::class,

'verified' => \Illuminate\Auth\Middleware\EnsureEmailIsVerified::class,

'localization' => \App\Http\Middleware\Localization::class,

//For pages that require a store first

'check_store' => \App\Http\Middleware\CheckStore::class,

];

Route:

    Route::group(['prefix' => '/info', 'middleware'=>'check_store'], function(){
        Route::get('/', 'Store\InfoC@index');
        Route::get('/edit', 'Store\InfoC@edit');
        Route::post('/edit', 'Store\InfoC@edit_save');
        Route::get('/create', 'Store\InfoC@create')->name('store.create');
        Route::post('/create', 'Store\InfoC@create_save');
    });

Route::group(['prefix' => '/info', 'middleware'=>'check_store'], function(){

Route::get('/', 'Store\InfoC@index');

Route::get('/edit', 'Store\InfoC@edit');

Route::post('/edit', 'Store\InfoC@edit_save');

Route::get('/create', 'Store\InfoC@create')->name('store.create');

Route::post('/create', 'Store\InfoC@create_save');

});

logg

if(!function_exists('logg'))
{
	function logg($value, $stop=true)
	{
		if(is_array($value) == true)
		{
			print('Type: array<br/>');
			print('Count:' . count($value) . '<br/>');
			print('<pre>');
			print_r($value);
			print('</pre>');
		}else if(is_object($value) == true){
			if(method_exists($value, 'toArray') == true){
				$value = $value->toArray();
				print('Type: collection<br/>');
			}else{
				print('Type: object<br/>');
			}

			print('Count:' . count($value) . '<br/>');
			print('<pre>');
			print_r($value);
			print('</pre>');
		}else{
			echo var_dump($value);
		}

		if($stop == true)
		{
			exit();
		}
	}
}

if(!function_exists('logg'))

{

function logg($value, $stop=true)

{

if(is_array($value) == true)

{

print('Type: array ');

print('Count:' . count($value) . ' ');

print('<pre>');

print_r($value);

print('</pre>');

}else if(is_object($value) == true){

if(method_exists($value, 'toArray') == true){

$value = $value->toArray();

print('Type: collection ');

}else{

print('Type: object ');

}

print('Count:' . count($value) . ' ');

print('<pre>');

print_r($value);

print('</pre>');

}else{

echo var_dump($value);

}

if($stop == true)

{

exit();

}

Creating thumbs using Intervention\Image

Controller

use Intervention\Image\Facades\Image;

    public function make_thumbs(){
        $root = 'app/media/product';
        $thumb_root = 'app/thumbs/product';
        //logg(storage_path($root));
        $width = 122;
        $height = 91;

        $this->process_folder($root, $thumb_root, $width, $height);
        echo 'done';
    }

    private function process_folder($path, $thumb_root, $width, $height){
        $file_path = storage_path($path);
        $thumb_full_path = storage_path($thumb_root);
        if(file_exists($thumb_full_path) == false){
            mkdir($thumb_full_path, 0777);
        }

        $files = scandir($file_path);
        //logg($files);
        foreach ($files as $key => $file) {
            if($file == '.' || $file == '..'){
                continue;
            }

            if(is_dir($file_path . '/' . $file) == true){
                $this->process_folder(
                    $path . '/' . $file, 
                    $thumb_root . '/' . $file,
                    $width, 
                    $height
                );
            }else{
                if(file_exists($thumb_full_path . '/' . $file) == true){
                    continue;
                }

                $path_parts = pathinfo($file);
                if(isset($path_parts['extension'])){
                    $ext = strtolower($path_parts['extension']);
                    if(in_array($ext, ['jpg', 'png', 'gif']) == true){
                        $img = Image::make($file_path . '/' . $file)
                            ->fit($width, $height)
                            ->save($thumb_full_path . '/' . $file);
                    }
                }
            }
        }
    }

use Intervention\Image\Facades\Image;

public function make_thumbs(){

$root = 'app/media/product';

$thumb_root = 'app/thumbs/product';

//logg(storage_path($root));

$width = 122;

$height = 91;

$this->process_folder($root, $thumb_root, $width, $height);

echo 'done';

}

private function process_folder($path, $thumb_root, $width, $height){

$file_path = storage_path($path);

$thumb_full_path = storage_path($thumb_root);

if(file_exists($thumb_full_path) == false){

mkdir($thumb_full_path, 0777);

}

$files = scandir($file_path);

//logg($files);

foreach ($files as $key => $file) {

if($file == '.' || $file == '..'){

continue;

}

if(is_dir($file_path . '/' . $file) == true){

$this->process_folder(

$path . '/' . $file,

$thumb_root . '/' . $file,

$width,

$height

);

}else{

if(file_exists($thumb_full_path . '/' . $file) == true){

continue;

}

$path_parts = pathinfo($file);

if(isset($path_parts['extension'])){

$ext = strtolower($path_parts['extension']);

if(in_array($ext, ['jpg', 'png', 'gif']) == true){

$img = Image::make($file_path . '/' . $file)

->fit($width, $height)

->save($thumb_full_path . '/' . $file);

}

Using Storage

    public static function make_thumb($path){
        //$path = '/images/W3G2wXleWkKj9gJwbAdA60SNp5urp5emA2mulpAh.jpeg';
        $file_name = basename($path);
        $file_path = Storage::disk('public')->path($path);

        $thumb_dir = dirname($path) . '/thumbs';
        Storage::disk('public')->makeDirectory($thumb_dir);
        $thumb_path = Storage::disk('public')->path($thumb_dir . '/' . $file_name);

        $img = Image::make($file_path)
            ->fit(300, 150)
            ->save($thumb_path);
    }

    public static function get_thumb($path){
        $thumb_dir = dirname($path) . '/thumbs';
        $file_name = basename($path);
        $url = Storage::disk('public')->url($thumb_dir . '/' . $file_name);
        return $url;
    }

public static function make_thumb($path){

//$path = '/images/W3G2wXleWkKj9gJwbAdA60SNp5urp5emA2mulpAh.jpeg';

$file_name = basename($path);

$file_path = Storage::disk('public')->path($path);

$thumb_dir = dirname($path) . '/thumbs';

Storage::disk('public')->makeDirectory($thumb_dir);

$thumb_path = Storage::disk('public')->path($thumb_dir . '/' . $file_name);

$img = Image::make($file_path)

->fit(300, 150)

->save($thumb_path);

}

public static function get_thumb($path){

$thumb_dir = dirname($path) . '/thumbs';

$file_name = basename($path);

$url = Storage::disk('public')->url($thumb_dir . '/' . $file_name);

return $url;

}

Dynamic Model Name

$trans_model = \App::make('App\\Models\\Store\\StoreInfoTranslationM');

1	$trans_model = \App::make('App\\Models\\Store\\StoreInfoTranslationM');

Reference:

https://laravel.io/forum/03-17-2016-using-a-dynamic-variable-to-call-a-model

Laravel Eloquent Auto Delete problem

Model

class Category extends Model
{
    public $belongsToMany = [
        'products' => [
            'pms\Models\Product',
            'table' => 'pms_product_category'
        ],
    ];
}

class Category extends Model

{

public $belongsToMany = [

'products' => [

'pms\Models\Product',

'table' => 'pms_product_category'

];

}

Controller:

$category = Category::whereRaw("REPLACE(name,' ','-') = '{$categoryname}'")->first();

//This line will delete product relation table of this category
//Unknown reason.
$category->products = [];

$category = Category::whereRaw("REPLACE(name,' ','-') = '{$categoryname}'")->first();

//This line will delete product relation table of this category

//Unknown reason.

$category->products = [];

Change DB connection on the fly

Amazing solution:

config(['database.default' => 'mysql-tw']);

1	config(['database.default' => 'mysql-tw']);

Test function

static function test(){
	//config(['database.default' => 'mysql-tw']);
	
	//$data = ProductM::on('mysql-tw')->find(1218);
	//logg($data);

	$data = DB::connection('mysql-tw')
		->table(self::$stable)
		->where('id', 1218)
		->first();
	logg($data);

	logg(DB::connection()->getDatabaseName());
}

static function test(){

//config(['database.default' => 'mysql-tw']);

//$data = ProductM::on('mysql-tw')->find(1218);

//logg($data);

$data = DB::connection('mysql-tw')

->table(self::$stable)

->where('id', 1218)

->first();

logg($data);

logg(DB::connection()->getDatabaseName());

}

Global Middleware

namespace App\Http\Middleware;

use Illuminate\Support\Facades\Config;

use Closure;

class AdminDbSwitch
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        //logg($request->is('admin/*'));
        if($request->is('admin') || $request->is('admin/*')){
            $conn_config = Config::get('admin.site_connections');
            //logg($conn_config);
            $site = 'global';
            if(isset($_COOKIE['site']) == true && $_COOKIE['site'] != false){
                $site = $_COOKIE['site'];
            }
            //logg($site);
            $conn = $conn_config[$site];
            //logg($conn);
            config(['database.default' => $conn]);
        }

        return $next($request);
    }
}

namespace App\Http\Middleware;

use Illuminate\Support\Facades\Config;

use Closure;

class AdminDbSwitch

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure $next

* @return mixed

public function handle($request, Closure $next)

{

//logg($request->is('admin/*'));

if($request->is('admin') || $request->is('admin/*')){

$conn_config = Config::get('admin.site_connections');

//logg($conn_config);

$site = 'global';

if(isset($_COOKIE['site']) == true && $_COOKIE['site'] != false){

$site = $_COOKIE['site'];

}

//logg($site);

$conn = $conn_config[$site];

//logg($conn);

config(['database.default' => $conn]);

}

return $next($request);

}

app/Http/Kernel.php

The position you put the middleware in is critical. Since cookie is used in the middleware, you can’t put it in global middleware because cookie and session are not activated yet.

The correct position is in “web” group

    protected $middlewareGroups = [
        'web' => [
            \App\Http\Middleware\EncryptCookies::class,
            \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
            \Illuminate\Session\Middleware\StartSession::class,
            // \Illuminate\Session\Middleware\AuthenticateSession::class,
            \Illuminate\View\Middleware\ShareErrorsFromSession::class,
            \App\Http\Middleware\VerifyCsrfToken::class,
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
            \App\Http\Middleware\AdminDbSwitch::class,
        ],

        'api' => [
            'throttle:60,1',
            'bindings',
        ],
    ];

protected $middlewareGroups = [

'web' => [

\App\Http\Middleware\EncryptCookies::class,

\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,

\Illuminate\Session\Middleware\StartSession::class,

// \Illuminate\Session\Middleware\AuthenticateSession::class,

\Illuminate\View\Middleware\ShareErrorsFromSession::class,

\App\Http\Middleware\VerifyCsrfToken::class,

\Illuminate\Routing\Middleware\SubstituteBindings::class,

\App\Http\Middleware\AdminDbSwitch::class,

'api' => [

'throttle:60,1',

'bindings',

];

https://laracasts.com/discuss/channels/laravel/session-doesnt-work-in-middleware

Reference:

https://stackoverflow.com/questions/31041893/laravel-change-database-connection-run-time
Override DB facade
https://stackoverflow.com/questions/40614875/laravel-5-extend-a-facade/40615078#40615078
Extending DB facade
https://stackoverflow.com/questions/52944843/extending-db-facade-laravel
Change database configs
https://laracasts.com/discuss/channels/eloquent/how-to-modify-database-connection-string-in-laravel-5
Extend model (For eloquent)
https://stackoverflow.com/questions/28985472/change-database-connection-in-laravel-model

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Category Archives: PHP

取得route中設定的網址參數

Escape Like

laravel-permission

Disable CSRF check for some route (page)

Filter and Redirect Middleware

logg

Creating thumbs using Intervention\Image

Dynamic Model Name

Laravel Eloquent Auto Delete problem

Change DB connection on the fly

April 2020
M	T	W	T	F	S	S
« Mar
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30