IdeaComment.php 2.3 KB
<?php


namespace app\api\model;


use think\Model;

class IdeaComment extends Model
{
    protected $append = [
//        'like_nicknames_text',
        'createtime_text',
        'images_text'
    ];

//    public function getLikeNicknamesTextAttr($value,$data)
//    {
//        $value = isset($data['like_nicknames']) ? explode(',',$data['like_nicknames']) : [];
//        return $value;
//    }

        public function getCommentNumberAttr($val,$data){
           $sum= $this->where("pid",$data['id'])->sum("comment_number");
            $count= $this->where("pid",$data['id'])->count();
           return $sum+$count;
        }

    public function getImagesTextAttr($value,$data)
    {
        $value = isset($data['images']) && !empty($data['images']) ? explode(',',$data['images']) : [];
        foreach ($value as $key => $val){
            $value[$key] = cdnurl($val,true);
        }
        return $value;
    }

    public function getCreatetimeTextAttr($value,$data)
    {
        if (!isset($data['createtime']) || empty($data['createtime']))
            return '';
        //sTime=源时间,cTime=当前时间,dTime=时间差
        $cTime      =   time();
        $dTime      =   $cTime - $data['createtime'];
        $dDay       =   intval(date("z",$cTime)) - intval(date("z",$data['createtime']));
        //$dDay     =   intval($dTime/3600/24);
        $dYear      =   intval(date("Y",$cTime)) - intval(date("Y",$data['createtime']));
        //normal:n秒前,n分钟前,n小时前,日期
        if( $dTime < 60 ){
            return $dTime."秒前";
        }elseif( $dTime < 3600 ){
            return intval($dTime/60)."分钟前";
        }elseif( $dTime >= 3600 && $dDay == 0  ){
            return intval($dTime/3600)."小时前";
        }elseif( $dDay > 0 && $dDay<=7 ){
            return intval($dDay)."天前";
        }elseif( $dDay > 7 &&  $dDay <= 30 ){
            return intval($dDay/7) . '周前';
        }elseif( $dDay > 30 &&  $dDay <= 365  ){
            return intval($dDay/30) . '月前';
        }else{
            return intval($dDay/365) . '年前';
        }
    }

    public function user()
    {
        return $this->belongsTo('User','user_id','id');
    }

    public function touser()
    {
        return $this->belongsTo('ToUser','touser_id','id');
    }
}