1 2 3 4 5 6 7 8 9
| $models = static::where('user_id', $userId)->leftJoin('product_gift', function ($join) { $join->on('product_gift_exchange_order.prd_id', '=', 'product_gift.prd_id'); $join->on('product_gift_exchange_order.gift_code', '=', 'product_gift.gift_code'); })->orderBy('product_gift_exchange_order.autokid', 'DESC')->get([ 'product_gift_exchange_order.autokid', 'product_gift_exchange_order.ctime', 'product_gift_exchange_order.exchange_amount', 'product_gift.gift_name', ]);
|