Laravel SQL Help!!

[isurutmv]

$q = Product::leftJoin(
                'variations',
                'products.id',
                '=',
                'variations.product_id'
            )
                ->where(function ($query) use ($term) {
                    $query->where('products.name', 'like', '%' . $term .'%');
                    $query->orWhere('sku', 'like', '%' . $term .'%');
                    $query->orWhere('sub_sku', 'like', '%' . $term .'%');
                })
                ->where('business_id', $business_id)
                ->whereNull('variations.deleted_at')
                ->select(
                    'products.id as product_id',
                    'products.name',
                    'products.type',
                    // 'products.sku as sku',
                    'variations.id as variation_id',
                    'variations.name as variation',
                    'variations.sub_sku as sub_sku'
                )
                ->groupBy('variation_id');

mcn uda thiyena code eka balapanko mata one ekata thawa table ekak join karala eke datath ganna mekata kohomada thawa table ekak join karanne

 

[D_Mad]

up up bro

 

[isurutmv]

up up bro

 

[shruk khan]

up up bro

 

[FREEZZEER]

BUMP

 

[pramix2011]

Laravel Relationship use karanne machan mara lesi

https://laravel.com/docs/5.7/eloquent-relationships

 

[rooshan2008]

$q = Product::leftJoin(
                'variations',
                'products.id',
                '=',
                'variations.product_id'
            )
                ->where(function ($query) use ($term) {
                    $query->where('products.name', 'like', '%' . $term .'%');
                    $query->orWhere('sku', 'like', '%' . $term .'%');
                    $query->orWhere('sub_sku', 'like', '%' . $term .'%');
                })
                ->where('business_id', $business_id)
                ->whereNull('variations.deleted_at')
                ->select(
                    'products.id as product_id',
                    'products.name',
                    'products.type',
                    // 'products.sku as sku',
                    'variations.id as variation_id',
                    'variations.name as variation',
                    'variations.sub_sku as sub_sku'
                )
                ->groupBy('variation_id');

mcn uda thiyena code eka balapanko mata one ekata thawa table ekak join karala eke datath ganna mekata kohomada thawa table ekak join karanne

$q = Product::leftJoin(
                'variations',
                'products.id',
                '=',
                'variations.product_id'
            )[COLOR="Red"]->join("table", "blabla.id", "=", "bibili.id")[/COLOR]
                ->where(function ($query) use ($term) {
                    $query->where('products.name', 'like', '%' . $term .'%');
                    $query->orWhere('sku', 'like', '%' . $term .'%');
                    $query->orWhere('sub_sku', 'like', '%' . $term .'%');
                })
                ->where('business_id', $business_id)
                ->whereNull('variations.deleted_at')
                ->select(
                    'products.id as product_id',
                    'products.name',
                    'products.type',
                    // 'products.sku as sku',
                    'variations.id as variation_id',
                    'variations.name as variation',
                    'variations.sub_sku as sub_sku'
                )
                ->groupBy('variation_id');

 

[rooshan2008]

mata kiyapan ethatama wenda oni de