crm/app/model/TrainSumup.php

<?php

namespace app\model;

use think\Model;

class TrainSumup extends Model
{

    public function user()
    {
        return $this->belongsTo(User::class, 'user_id')->bind(['nickname','headimg'=>'headimgurl']);
    }

    public function employee(){
        return $this->belongsTo(Employee::class, 'employee_id')->bind(['name']);
    }

	/*
	 * 评论列表计算触发关键词个数
	 */
	public static function sumup_score_num($sumup_keyword , $sumup_score , $content)
    {
    	$count = 0;
    	$score = '';
        $sumup_keyword = empty($sumup_keyword) ? [] : json_decode($sumup_keyword,true);
        $sumup_score = json_decode($sumup_score,true);
        //循环设置的关键词匹配观后感中出现的次数
		foreach($sumup_keyword as $val)
		{
			if(!empty($val) && strpos($content,$val) !== false)
			{
				$count += 1;
			}
		}
    	if(isset($sumup_score['score_one']) && !empty($sumup_score['score_one']) && $count >= $sumup_score['score_one']) $score = 'S';
    	if(isset($sumup_score['score_two']) && !empty($sumup_score['score_two']) && $count >= $sumup_score['score_two']) $score = 'SS';
    	if(isset($sumup_score['score_three']) && !empty($sumup_score['score_three']) && $count >= $sumup_score['score_three']) $score = 'SSS';
    	return empty($content) ? $score : $score;
    }

    public function trainThumbLog(){
        return $this->belongsTo(TrainThumbLog::class,'id','sumup_id');
    }
}