<?php
|
|
namespace app\common\model\branch;
|
|
use app\common\model\BaseModel;
|
|
/**
|
* 活动评论模型
|
*/
|
class ActivityComment extends BaseModel
|
{
|
protected $name = 'branch_activity_comment';
|
protected $pk = 'comment_id';
|
|
/**
|
* 追加字段
|
* @var string[]
|
*/
|
protected $append = [
|
'create_time_text',
|
];
|
|
/**
|
* 关联用户表
|
*/
|
public function user()
|
{
|
return $this->belongsTo('app\\common\\model\\user\\User', 'user_id', 'user_id')
|
->field(['user_id', 'nickName', 'avatarUrl', 'real_name']);
|
}
|
|
/**
|
* 关联活动表
|
*/
|
public function activity()
|
{
|
return $this->belongsTo('app\\common\\model\\branch\\Activity', 'activity_id', 'activity_id');
|
}
|
|
/**
|
* 关联活动报名表
|
*/
|
public function activityUser()
|
{
|
return $this->belongsTo('app\\common\\model\\branch\\ActivityUser', 'order_id', 'order_id');
|
}
|
|
/**
|
* 关联评论图片表
|
*/
|
public function images()
|
{
|
return $this->hasMany('app\\common\\model\\branch\\ActivityCommentImage', 'comment_id', 'comment_id');
|
}
|
|
/**
|
* 关联图片文件
|
*/
|
|
/**
|
* 创建时间文本
|
*/
|
public function getCreateTimeTextAttr($value, $data)
|
{
|
return isset($data['create_time']) ? date('Y-m-d H:i:s', $data['create_time']) : '';
|
}
|
|
/**
|
* 检查报名记录是否允许评论
|
|
/**
|
* 获取活动评论列表
|
*/
|
public function getActivityCommentList($activity_id, $params = [])
|
{
|
$model = $this->with(['user', 'images.file'])
|
->where('activity_id', '=', $activity_id)
|
->where('is_delete', '=', 0)
|
->where('status', '=', 1);
|
|
// 按评分筛选
|
if (isset($params['score']) && $params['score'] > 0) {
|
$model = $model->where('score', '=', $params['score']);
|
}
|
|
return $model->order(['sort' => 'asc', 'create_time' => 'desc'])
|
->paginate($params);
|
}
|
|
/**
|
* 获取活动评论统计
|
*/
|
public function getCommentStatistics($activity_id)
|
{
|
return $this->field([
|
'count(comment_id) AS `all`',
|
'count(score >= 4 OR NULL) AS `good`',
|
'count(score >= 2 AND score <= 3 OR NULL) AS `medium`',
|
'count(score = 1 OR NULL) AS `bad`',
|
])->where([
|
'activity_id' => $activity_id,
|
'is_delete' => 0,
|
'status' => 1
|
])->find();
|
}
|
|
/**
|
* 获取企业的差评数量
|
* @param int $supplier_id 企业ID
|
* @return int 差评数量
|
*/
|
public function getSupplierNegativeCommentCount($supplier_id,$visit_supplier_name,$exclude_activity_id=0)
|
{
|
$model=$this;
|
if ($exclude_activity_id){
|
$model = $model->where('activity_id', '<>', $exclude_activity_id);
|
}
|
$count = $model->where(function ($query) use ($supplier_id,$visit_supplier_name) {
|
$query->where('supplier_id', '=', $supplier_id)
|
->whereOr('supplier_name', '=', $visit_supplier_name);
|
})->where([
|
'score' => 1, // 1分为差评
|
'is_delete' => 0,
|
'status' => 1
|
])->count();
|
|
return $count;
|
}
|
|
/**
|
* 验证报名记录是否允许评论
|
* @param object $activityUser 报名记录
|
* @return bool
|
*/
|
public function checkAllowComment($activityUser)
|
{
|
// 验证是否已签到
|
if ($activityUser['is_verify'] != 1) {
|
$this->error = '请先签到后再评价';
|
return false;
|
}
|
|
// 验证活动是否已结束
|
$activity = $activityUser['activity'];
|
if ($activity['status_text']['status'] != 2) {
|
$this->error = '活动结束后才能评价';
|
return false;
|
}
|
|
// 验证是否已评价
|
$hasComment = $this->where(['order_id' => $activityUser['order_id']])->find();
|
if ($hasComment) {
|
$this->error = '您已经评价过该活动';
|
return false;
|
}
|
|
return true;
|
}
|
|
/**
|
* 添加评论
|
*/
|
public function addComment($activityUser, $data)
|
{
|
// 验证是否允许评论
|
if (!$this->checkAllowComment($activityUser)) {
|
return false;
|
}
|
|
$commentData = [
|
'activity_id' => $activityUser['activity_id'],
|
'order_id' => $activityUser['order_id'],
|
'user_id' => $activityUser['user_id'],
|
'supplier_id' => $activityUser['activity']['visit_supplier_id'] ?: 0,
|
'supplier_name' => $activityUser['activity']['visit_supplier_name'] ?: '',
|
'content' => $data['content'] ?: '',
|
'score' => $data['score'] ?: 5,
|
'is_picture' => !empty($data['image_list']) ? 1 : 0,
|
'sort' => 100,
|
'status' => 0, // 待审核
|
'app_id' => self::$app_id,
|
];
|
|
return $this->save($commentData);
|
}
|
|
/**
|
* 保存评论图片
|
*/
|
public function saveCommentImages($comment_id, $image_list)
|
{
|
$this->images()->delete();
|
if (empty($image_list)) {
|
return true;
|
}
|
|
$imageData = [];
|
foreach ($image_list as $image) {
|
$imageData[] = [
|
'comment_id' => $comment_id,
|
'image_id' => $image['file_id'],
|
'app_id' => self::$app_id,
|
'create_time' => time(),
|
];
|
}
|
|
$commentImageModel = new ActivityCommentImage();
|
return $commentImageModel->saveAll($imageData);
|
}
|
|
/**
|
* 详情
|
*/
|
public static function detail($comment_id, $with = [])
|
{
|
return (new static())->with($with)->find($comment_id);
|
}
|
}
|
