ball/app/api/logic/GoodsReviewsLogic.php

<?php
namespace app\api\logic;

use app\common\logic\BaseLogic;
use app\common\model\goods\Goods;
use app\common\model\orders\RechargeOrder;
use app\common\model\recharge\OrderGoods;
use app\common\model\reviews\GoodsReviews;
use app\common\model\works\ServiceWork;
use think\facade\Db;

/**
 * 服务商品评论逻辑处理
 * Class GoodsReviewsLogic
 * @package app\api\logic
 */
class GoodsReviewsLogic extends BaseLogic
{
    /**
     * @param $params
     * @return bool
     */
    public function add($params)
    {
        Db::startTrans();
        try {
            $work = ServiceWork::findOrEmpty($params['work_id'])->toArray();
            $goods_id = OrderGoods::whereIn('sn', RechargeOrder::where('work_id')->column('sn'))->value('goods_id');
            GoodsReviews::create([
                'goods_id'=>$goods_id,
                'goods_category_id'=>$work['goods_category_id'],
                'user_id'=>$params['user_id'],
                'nickname'=>$params['user_info']['nickname'],
                'avatar'=>$params['user_info']['avatar'],
                'rating'=>$params['rating'],
                'comment'=>$params['comment'],
                'review_image'=>$params['review_image']
            ]);
            Db::commit();
            return true;
        } catch (\Exception $e) {
            Db::rollback();
            self::setError($e->getMessage());
            return false;
        }
    }
}