NN2025112501/app/Models/OrderGoodsModel.php

<?php

namespace App\Models;

/**
 * 订单商品-模型
 */
class OrderGoodsModel extends BaseModel
{
    // 设置数据表
    protected $table = 'orders_goods';

    // 封面图
    public function getThumbAttribute($value)
    {
        $thumb = $value ? get_image_url($value) : get_image_url('/images/goods/goods.jpeg');
        return $thumb;
    }

    /**
     * 关联商品分类
     */
    public function category()
    {
        return $this->hasOne(GoodsCategoryModel::class, 'id', 'category_id')
            ->select(['id', 'name', 'icon', 'status']);
    }

    /**
     * SKU
     */
    public function sku()
    {
        return $this->hasOne(GoodsSkuModel::class, 'id', 'sku_id')
            ->leftJoin('goods_skus as b','b.id','=','orders_goods.sku_id')
            ->select(['orders_goods.*','b.sku_name','b.price']);
    }
}