mysql - 如何在 if 块中使用 taxItem 和 Uom

Question

如何使用taxItem和Uom在if块内？

Table: product
      product_items
      product_taxes
      vendors
      product_uoms

$results = Product::with('taxItem','uom')
$results = DB::table('products')

我应该如何添加with()查询生成器？

 public function search(Request $request)
        {
            $request->validate([
                'vendor_id' => 'sometimes|required|integer|exists:vendors,id'
            ]);
            if(request()->has('vendor_id')) {        
                $results = DB::table('products')        
                    ->select(
                      ......
                    )        
                    ->join('product_items', 'products.id', '=', 'product_items.product_id')
                    ->join('vendors', 'vendors.id', '=', 'product_items.vendor_id')
                    ->where('product_items.vendor_id', '=', request('vendor_id'))

                    ->where(function($query) {...
                    })

                    ->limit(6)
                    ->get();
            } 
            else {
                $results = Product::with('taxItem','uom')
                   ....          
            }
            return api([
                'results' => $results
            ]);
        }

标签： mysqllaravel