likeshop.project/app/common/model/Goods.php

<?php
// +----------------------------------------------------------------------
// | likeshop100%开源免费商用商城系统
// +----------------------------------------------------------------------
// | 欢迎阅读学习系统程序代码，建议反馈是我们前进的动力
// | 开源版本可自由商用，可去除界面版权logo
// | 商业版本务必购买商业授权，以免引起法律纠纷
// | 禁止对系统程序代码以任何目的，任何形式的再发布
// | gitee下载：https://gitee.com/likeshop_gitee
// | github下载：https://github.com/likeshop-github
// | 访问官网：https://www.likeshop.cn
// | 访问社区：https://home.likeshop.cn
// | 访问手册：http://doc.likeshop.cn
// | 微信公众号：likeshop技术社区
// | likeshop团队 版权所有 拥有最终解释权
// +----------------------------------------------------------------------
// | author: likeshopTeam
// +----------------------------------------------------------------------
namespace app\common\model;

use app\common\logic\GoodsActivityLogic;
use app\common\model\search\SearchGoods;
use app\common\service\FileService;
use think\model\concern\SoftDelete;
use app\common\enum\{DistributionOrderGoodsEnum, GoodsCommentEnum, GoodsEnum, YesNoEnum};

/**
 * 商品模型
 * Class Goods
 * @package app\common\model
 */
class Goods extends BaseModel
{
    use SoftDelete;
    use SearchGoods;
    
    protected $deleteTime = 'delete_time';

    public function unit()
    {
        return $this->hasOne(GoodsUnit::class, 'id', 'unit_id');
    }


    /**
     * @notes 去除分享海报域名
     * @param $value
     * @return mixed|string
     * @author 张无忌
     * @date 2021/9/10 11:04
     */
    public function setPosterAttr($value)
    {
        return trim($value) ? FileService::setFileUrl($value) : '';
    }

    /**
     * @notes 去掉视频域名
     * @param $value
     * @return mixed|string
     * @author 张无忌
     * @date 2021/9/10 11:04
     */
    public function setVideoAttr($value)
    {
        return trim($value) ? FileService::setFileUrl($value) : '';
    }

    /**
     * @notes 获取视频域名
     * @param $value
     * @return mixed|string
     * @author cjhao
     * @date 2022/3/28 14:35
     */
    public function getVideoAttr($value)
    {
        return trim($value) ? FileService::getFileUrl($value) : '';
    }

    /**
     * @notes 去掉视频封面域名
     * @param $value
     * @return mixed|string
     * @author 张无忌
     * @date 2021/9/10 11:04
     */
    public function setVideoCoverAttr($value)
    {
        return trim($value) ? FileService::setFileUrl($value) : '';
    }


    /**
     * @notes 获取视频封面域名
     * @param $value
     * @return string
     * @author cjhao
     * @date 2022/3/28 14:38
     */
    public function getVideoCoverAttr($value)
    {
        return trim($value) ? FileService::getFileUrl($value) : '';
    }

    /**
     * @notes 获取海报图片
     * @param $value
     * @param $data
     * @return string
     * @author cjhao
     * @date 2022/3/28 14:27
     */
    public function getPosterAttr($value, $data)
    {
        return trim($value) ? FileService::getFileUrl($value) : '';
    }

    /**
     * @notes 关联轮播图模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 17:59
     */
    public function imageList()
    {
        return $this->hasMany(GoodsImage::class, 'goods_id');
    }

    /**
     * @notes 关联商品分类模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 17:59
     */
    public function goodsCategoryIndex()
    {
        return $this->hasMany(GoodsCategoryIndex::class, 'goods_id');
    }
    
    /**
     * @notes 关联商品分类模型 使用as goods_id的情况
     * @return \think\model\relation\HasMany
     * @author lbzy
     * @datetime 2023-11-06 15:44:37
     */
    public function goodsCategoryIndex2()
    {
        return $this->hasMany(GoodsCategoryIndex::class, 'goods_id', 'goods_id');
    }
    
    function deliveryTemplate()
    {
        return $this->hasOne(GoodsDeliveryTemplate::class, 'id', 'delivery_template_id')
            ->field([ 'id', 'name', 'type', 'content', 'content1' ]);
    }


    /**
     * @notes 关联规格项模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 18:00
     */
    public function specValue()
    {
        return $this->hasMany(GoodsSpec::class, 'goods_id');
    }


    /**
     * @notes 关联规格值模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 18:00
     */
    public function specValueSpec()
    {
        return $this->hasMany(GoodsSpecValue::class, 'goods_id');
    }


    /**
     * @notes 关联规格信息模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 18:00
     */
    public function specValueList()
    {
        return $this->hasMany(GoodsItem::class, 'goods_id');
    }


    /**
     * @notes 关联评论模型
     * @return \think\model\relation\HasMany
     * @author cjhao
     * @date 2021/8/16 18:00
     */
    public function goodsComment()
    {
        return $this->hasMany(GoodsComment::class, 'goods_id');
    }

    /**
     * @notes 处理商品图片
     * @param $value
     * @param $data
     * @return array
     * @author cjhao
     * @date 2021/8/16 18:01
     */
    public function getGoodsImageAttr($value, $data)
    {
        $goodsImage = array_column($this->imageList->toArray(), 'uri');
        array_unshift($goodsImage, FileService::getFileUrl($data['image']));
        return $goodsImage;
    }

    /**
     * @notes 处理分类
     * @param $value
     * @param $data
     * @return array
     * @author cjhao
     * @date 2021/8/16 18:01
     */
    public function getCategoryIdAttr($value, $data)
    {
        $goods_category_index = $this->goodsCategoryIndex->toArray();
        return array_column($goods_category_index, 'category_id');
    }

    /**
     * @notes 分销状态获取器
     * @param $value
     * @return int
     * @author Tab
     * @date 2021/7/23 16:23
     */
    public function getIsDistributionAttr($value,$data)
    {
        $distributionGoods = DistributionGoods::where('goods_id', $data['id'])->findOrEmpty();
        if ($distributionGoods->isEmpty()) {
            return YesNoEnum::NO;
        }
        return $distributionGoods->is_distribution;
    }

    /**
     * @notes 会员折扣状态获取器
     * @param $value
     * @return int
     * @author ljj
     * @date 2023/3/28 3:59 下午
     */
    public function getIsDiscountAttr($value,$data)
    {
        $discountGoods = DiscountGoods::where('goods_id', $data['id'])->findOrEmpty();
        if ($discountGoods->isEmpty()) {
            return YesNoEnum::NO;
        }
        return $discountGoods->is_discount;
    }

    /**
     * @notes 该商品累计已返佣金
     * @param $value
     * @return float
     * @author Tab
     * @date 2021/7/23 14:17
     */
    public function getCommissionAttr($value)
    {
        $where = [
            'status' => DistributionOrderGoodsEnum::RETURNED,
            'goods_id' => $value
        ];
        return DistributionOrderGoods::where($where)->sum('earnings');
    }

    /**
     * @notes 最小值获取器
     * @param $value
     * @return int|mixed|string
     * @author Tab
     * @date 2021/9/18 11:09
     */
    public function getMinPriceAttr($value)
    {
        return clearZero($value);
    }

    /**
     * @notes 最大值获取器
     * @param $value
     * @return int|mixed|string
     * @author Tab
     * @date 2021/9/18 11:10
     */
    public function getMaxPriceAttr($value)
    {
        return clearZero($value);
    }

    /**
     * @notes 价格获取器
     * @param $value
     * @param $data
     * @author Tab
     * @datetime 2022/1/17 17:14
     */
    public function getPriceTextAttr($value, $data)
    {
        if ($data['spec_type'] == 1) {
            // 单规格
            return '¥ ' . clear_zero($data['min_price']);
        } else {
            // 多规格
            return '¥ ' . clear_zero($data['min_price']) . ' ~ ' . clear_zero($data['max_price']);
        }
    }

    /**
     * @notes 状态获取器
     * @param $value
     * @param $data
     * @return array|mixed|string
     * @author Tab
     * @datetime 2022/1/17 17:24
     */
    public function getStatusTextAttr($value, $data)
    {
        return GoodsEnum::getStatusDesc($data['status']);
    }

    /**
     * @notes 分类获取器
     * @param $value
     * @param $data
     * @author Tab
     * @datetime 2022/1/17 17:25
     */
    public function getCategoryTextAttr($value, $data)
    {
        $field = ['gci.goods_id, gci.category_id, gc.name'];
        $lists = GoodsCategoryIndex::alias('gci')
            ->leftJoin('goods_category gc', 'gc.id = gci.category_id')
            ->field($field)
            ->where('gci.goods_id', $data['id'])
            ->select()
            ->toArray();

        $categoryText = '';
        foreach ($lists as $item) {
            $categoryText .= $item['name'] . '/';
        }
        return trim($categoryText, '/');
    }

    /**
     * @notes 评论条数获取器(审核通过的)
     * @param $value
     * @param $data
     * @author Tab
     * @datetime 2022/1/17 17:32
     */
    public function getCommentTextAttr($value, $data)
    {
        $count = GoodsComment::where([
            'goods_id' => $data['id'],
            'status' => GoodsCommentEnum::APPROVED
        ])->count();
        return $count;
    }
    
    /**
     * @notes service_guarantee_ids 服务保障id列表
     * @return array
     * @author lbzy
     * @datetime 2023-08-22 17:13:35
     */
    function getServiceGuaranteeIdsAttr($fieldValue, $data)
    {
        return $fieldValue ? (array) json_decode($fieldValue, true) : [];
    }
    
    /**
     * @notes service_guarantee_ids 服务保障id列表
     * @return string
     * @author lbzy
     * @datetime 2023-08-22 17:13:35
     */
    function setServiceGuaranteeIdsAttr($fieldValue, $data)
    {
        return json_encode(is_array($fieldValue) ? array_values($fieldValue) : [], JSON_UNESCAPED_UNICODE);
    }
}