<?php

namespace app\shop\model\product;

use app\common\model\product\Comment as CommentModel;
use app\shop\model\supplier\Supplier as SupplierModel;
class Comment extends CommentModel
{
    /**
     * 软删除
     */
    public function setDelete($comment_id)
    {
        return $this->where('comment_id', '=', $comment_id)->save(['is_delete' => 1]);
    }

    /**
     * 获取评价总数量
     */
    public function getCommentTotal()
    {
        return $this->where(['is_delete' => 0])->count();
    }

    /**
     * 获取待审核商品评价总数量
     */
    public function getReviewCommentTotal()
    {
        return $this->where(['is_delete' => 0, 'status' => 0])->count();
    }


    /**
     * 更新记录
     */
    public function edit($data)
    {   
        //$this->updateScore($this['shop_supplier_id']);
        return $this->where('comment_id', '=', $data['comment_id'])->save([
            'status' => $data['status'],
            'sort' => $data['sort']
        ]);
    }
    //更新店铺评分
    public function updateScore($shop_supplier_id){
        $SupplierModel = new SupplierModel;
        $express = $this->where(['shop_supplier_id' => $shop_supplier_id, 'status'=>1,'is_delete'=>0])
            ->field('round(avg(express_score),1) as score')->find();
        $server = $this->where(['shop_supplier_id' => $shop_supplier_id, 'status'=>1,'is_delete'=>0])
            ->field('round(avg(server_score),1) as score')->find();
        $describe = $this->where(['shop_supplier_id'=> $shop_supplier_id,'status'=>1,'is_delete'=>0])
            ->field('round(avg(describe_score),1) as score')->find();
        //更新店铺分数
        $SupplierModel->where('shop_supplier_id','=', $shop_supplier_id)
            ->update([
                'express_score' => $express['score'],
                'server_score' => $server['score'],
                'describe_score' => $describe['score']
            ]);

    }

}