Model 里面使用
public function scopeSubTotal ($query) { // $field = $this->fillable; $field = \DB::raw('ItemPrice+ShippingPrice+GiftWrapPrice+ItemTax+ShippingTax+GiftWrapTax+ShippingDiscount+PromotionDiscount as SubTotal'); return $query->addSelect($field); }
使用方法1:
$Model->select('aaa','bbb')->SubTotal(); #筛选结果是 aaa,bbb,SubTotal
关联使用方法2:
$model->with( ['item'=> function($qry) {
$qry->select('aaa','bbb')->SubTotal();
}]) -> .....