Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $variant = \App\ProductVariant::select('id', 'option_ids', 'price')->whereJsonContains('option_ids', $request->input('options'))->with([
- 'stock' => function($query) {
- $query->select('id', 'variant_id', 'quantity');
- },
- 'discount' => function($query) {
- /** @var \Illuminate\Database\Query\Builder $query */
- $query->select('variant_id', 'percents')
- ->selectRaw('ROUND(product_variants.price * percents / 100, 2) AS price_row')
- ->leftJoin('product_variants', 'product_variants.id', '=', 'discounts.variant_id')
- ->where('expiration', '>', Carbon::now());
- }
- ])->first();
Advertisement
Add Comment
Please, Sign In to add comment