dineng/application/common/model/UserCollect.php

<?php
namespace app\common\model;
use library\tools\Data;
use think\Model;
// 收藏
class UserCollect extends Model
{
    //protected $resultSetType = 'collection';// 设置返回类型
    static $type_desc = [
        1=>'平台视频', 2=>'资料', 3=>'图文', 4=>'新闻', 5=>'论坛', 6=>'商品', 7=>'活动', 8=>'招聘',9=>'供应商商品',10=>'需求'
        ];
    public static function checkCollectByType($user_id,$type,$id,$children_id = 0)
    {
        $where = [];
        $where['user_id'] = $user_id;
        $where['coll_type'] = $type;
        $where['coll_id'] = $id;
        if($children_id) $where['children_id'] = $children_id;
        return self::where($where)->value('id') ? 1:0;
    }

    // 收藏数量
    public static function getCollectNum($type,$id,$children_id = 0)
    {
        $where = [];
        $where['coll_type'] = $type;
        $where['coll_id'] = $id;
        if($children_id) $where['children_id'] = $children_id;
        return self::where($where)->count() ;
    }


    /**
     * @param $user_id
     * @param $type 1平台视频，2资料,3图文4新闻5论坛6商品7活动
     * @param $id
     * @param int $children_id
     * @return int
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public static function plateCollect($user_id,$type,$id,$children_id = 0)
    {
        $check_collect = self::checkCollectByType($user_id,$type,$id,$children_id);
        $ret_val = 0;
        if($check_collect) {
            self::where(['user_id'=>$user_id,'coll_type'=>$type,'coll_id'=>$id,'children_id'=>$children_id])->delete();
        }else{
            Data::save('UserCollect', [
                'user_id'=>$user_id,
                'coll_type'=>$type,
                'coll_id'=>$id,
                'children_id'=>$children_id,
                'create_int'=>time()],'user_id',['user_id'=>$user_id,'coll_type'=>$type, 'coll_id'=>$id,'children_id'=>$children_id]);
            $ret_val =  1;
        }
        return  $ret_val;
    }



    public function videoItem()
    {
        return $this->belongsTo('VideoUrl','children_id')->field('id,video_id,cover,url,title,create_at');
    }

    public function datumItem()
    {
        return $this->belongsTo('DatumUrl','children_id')->field('id,datum_id,url,title,create_at');
    }

    public function articleItem()
    {
        return $this->belongsTo('DatumUrl','children_id')->field('id,article_id,cover,images,content,create_at');
    }





}