Category Archives: Laravel

Deploy Laravel Project on Shared Host (Plesk)

Need to move core files to parent folder

Deploy Laravel 5 on shared hosting from Heart Internet

Where with Subquery

Laravel Example

        $relations = DB::table('tenten_pms_product as a')
            ->join('tenten_pms_product_category as b', 'b.product_id', '=', 'a.id')
            ->select('b.product_id')
            ->where('b.category_id', $cat_id)
            ->whereRaw('(select count(*) from tenten_pms_product_model as suba 
                where suba.product_id = a.id
                and suba.enabled = 1) > 0')
            ->orderBy('a.state_new', 'desc')
            ->orderBy('b.sort_order', 'asc')
            ->orderBy('a.created_at', 'desc')
            ->get();
        //logg($relations);

$relations = DB::table('tenten_pms_product as a')

->join('tenten_pms_product_category as b', 'b.product_id', '=', 'a.id')

->select('b.product_id')

->where('b.category_id', $cat_id)

->whereRaw('(select count(*) from tenten_pms_product_model as suba

where suba.product_id = a.id

and suba.enabled = 1) > 0')

->orderBy('a.state_new', 'desc')

->orderBy('b.sort_order', 'asc')

->orderBy('a.created_at', 'desc')

->get();

//logg($relations);

SQL

SELECT a.*, 
(select count(*) from tenten_pms_product_model as suba 
where suba.product_id = a.id
and suba.enabled = 1) as model_count
from tenten_pms_product as a
join `tenten_pms_product_category` as b on b.product_id = a.id
WHERE b.`category_id` = '41' 
and (select count(*) from tenten_pms_product_model as suba 
where suba.product_id = a.id
and suba.enabled = 1) > 0
ORDER BY a.state_new desc, b.`sort_order` asc
LIMIT 50

SELECT a.*,

(select count(*) from tenten_pms_product_model as suba

where suba.product_id = a.id

and suba.enabled = 1) as model_count

from tenten_pms_product as a

join `tenten_pms_product_category` as b on b.product_id = a.id

WHERE b.`category_id` = '41'

and (select count(*) from tenten_pms_product_model as suba

where suba.product_id = a.id

and suba.enabled = 1) > 0

ORDER BY a.state_new desc, b.`sort_order` asc

LIMIT 50

Reference:

Eloquent find() not work – always return null

Could be soft deleted.

https://stackoverflow.com/questions/37719932/laravel-eloquent-modelfind-doesnt-work

Order by Array

Sample

        $prods = $prods->orderBy(DB::raw('field(a.id, ' . implode(', ', $final_arr) . ')'))
            ->skip($skip)
            ->take($take)
            ->get();

$prods = $prods->orderBy(DB::raw('field(a.id, ' . implode(', ', $final_arr) . ')'))

->skip($skip)

->take($take)

->get();

Reference

https://stackoverflow.com/questions/8055138/mysql-sort-order-by-array-value
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_field
Could be replaced with orderRaw()
https://laravel.com/docs/8.x/queries

Get Daily Data using Laravel Query Builder

Query Builder

$result = DB::table('orders')
    ->select(DB::raw("sum(total) as total, DATE_FORMAT(created_at,'%Y-%m-%d') as date_label"))
    ->where('status', 1)
    ->get();

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

->select(DB::raw("sum(total) as total, DATE_FORMAT(created_at,'%Y-%m-%d') as date_label"))

->where('status', 1)

->get();

Hash Handlers in Laravel

Make password

use Illuminate\Support\Facades\Hash;

Hash::make('12345');

use Illuminate\Support\Facades\Hash;

Hash::make('12345');

Check password

$result = Hash::check($password, $user->password);

1	$result = Hash::check($password, $user->password);

Reference

https://stackoverflow.com/questions/25132507/how-to-match-input-password-and-database-hash-password-in-laravel-4/25136309

Laravel API

Add column “api_token” in table users

ALTER TABLE `users`
CHANGE `api_token` `api_token` varchar(80) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `remember_token`;

1 2	ALTER TABLE `users` CHANGE `api_token` `api_token` varchar(80) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `remember_token`;

Postman issues in local

Postman doesn’t apply settings in host file, so don’t use “example.test”, change to “localhost:8000”.

Token

//Origin Token, should be used to login
$token = \Str::random(60);

$admin->forceFill([
    'api_token' => hash('sha256', $token),
])->save();

//Origin Token, should be used to login

$token = \Str::random(60);

$admin->forceFill([

'api_token' => hash('sha256', $token),

])->save();

Reference:

https://laravel.com/docs/5.8/api-authentication

Reflection Exception: Class Log does not exist error

Could be invalid format in config files.

.env
constants.php (old laravel)
e.g. define(‘BASE_URL’, url(‘/’)); -> error
define(‘BASE_URL’, “http://localhost”); -> OK

Create Path with Laravel File Facade

use Illuminate\Support\Facades\File;
use Intervention\Image\Facades\Image;

    private function make_thumb($file){
        $file_path = storage_path('/app/media' . $file);
        //logg(file_exists($file_path));
        //logg($file_path);

        $img = Image::make($file_path);
        $img->resize(600, null, function ($constraint) {
            $constraint->aspectRatio();
        });

        $thumb_dir = storage_path('/app/pcat_thumb' . dirname($file));
        if(file_exists($thumb_dir) == false){
            File::makeDirectory($thumb_dir, 0777, true, true);
        }

        $thumb = storage_path('/app/pcat_thumb' . $file);
        $img->save($thumb);
    }

use Illuminate\Support\Facades\File;

use Intervention\Image\Facades\Image;

private function make_thumb($file){

$file_path = storage_path('/app/media' . $file);

//logg(file_exists($file_path));

//logg($file_path);

$img = Image::make($file_path);

$img->resize(600, null, function ($constraint) {

$constraint->aspectRatio();

});

$thumb_dir = storage_path('/app/pcat_thumb' . dirname($file));

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

File::makeDirectory($thumb_dir, 0777, true, true);

}

$thumb = storage_path('/app/pcat_thumb' . $file);

$img->save($thumb);

}

Sort by array values

    static function items_by_ids($ids){
        $result = self::whereIn('id', $ids)
            ->orderBy(DB::raw('field(id, ' . implode(',', $ids) . ')'))
            ->get();
        return $result;
    }

static function items_by_ids($ids){

$result = self::whereIn('id', $ids)

->orderBy(DB::raw('field(id, ' . implode(',', $ids) . ')'))

->get();

return $result;

}

Reference:

https://stackoverflow.com/questions/8055138/mysql-sort-order-by-array-value

M	T	W	T	F	S	S
			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

Rex's Personal Site

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

Category Archives: Laravel

Deploy Laravel Project on Shared Host (Plesk)

Where with Subquery

Eloquent find() not work – always return null

Order by Array

Get Daily Data using Laravel Query Builder

Hash Handlers in Laravel

Laravel API

Postman issues in local

Reflection Exception: Class Log does not exist error

Create Path with Laravel File Facade

Sort by array values