gaoyixia/application/api/controller/Supplier.php

<?php
namespace app\api\controller;
use app\common\model\Company;
use app\common\model\PlatformLike;
use app\common\model\PlatformSwitch;
use app\common\model\PressComment;
use app\common\model\SupplierCate;
use app\common\model\UserCollect;
use app\common\model\UserSearch;
use app\common\model\SupplierGoods;
use app\common\model\UserTrack;
use app\common\service\CheckPower;
use library\tools\Data;
use think\Db;

/**
 * @title 供应商
 * @controller Supplier
 * @group base
 */
class Supplier extends Base
{
    // 需要登录的
    protected $need_login = [
        'supplierGoodsTags',
        'supplierGoodsCollect',
        'supplierTransmit',
        'supplierGoodsTransmit',
        'getSupplierGoodsTrack',
        'getTagsSupplierGoods',
        'getCollectSupplierGoods',
        'getFollowUpList',
        ];
    public function initialize()
    {
        parent::initialize();
        parent::setUid();
    }

    /**
     * @title 供应商接口说明
     * @desc  供应商接口说明
     * @author  qc
     * @url /api/Supplier/classIntro
     * @method GET
     * @return name:1 type:string default:-- desc:--
     */
     public function classIntro(){}

    /**
     * @title 获取供应商分类
     * @desc  两级分类
     * @author  qc
     * @url /api/Supplier/getSupplierCate
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:id type:int default:-- desc:分类id
     * @return name:title type:string default:0 desc:分类名称
     * @return name:children type:array default:0 desc:下级分类
     */
     public function getSupplierCate()
     {
         $list = SupplierCate::where(['is_deleted'=>0])->field('id,title,pid')->order('sort desc,id asc')->select()->toArray();
         $list =  make_tree($list);
         $this->success('ok',['list'=>$list]);
     }

    /**
     * @title 联系我们(详情内部)【两个二维码】
     * @desc 联系我们
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierContact
     * @header name:Authorization require:1 desc:Token
     * @param  name:supplier_id type:int default:-- desc:供应商id
     * @return name:phone type:string default:-- desc:供应商电话
     * @return name:email type:string default:-- desc:供应商email
     * @return name:qr_code type:int default:-- desc:供应商二维码
     * @return name:contact_qrcode type:string default:-- desc:平台二维码
     * @return name:contact_phone type:string default:-- desc:平台电话
     * @return name:contact_email type:string default:-- desc:平台邮箱
     */
    public function getSupplierContact()
    {
        $sel_where[]  = ['id','=',input('get.supplier_id')];
        $detail = \app\common\model\Supplier::field('id,phone,email,qr_code')->where($sel_where)->find()->toArray();
        $contact = Db::name('contact')->where('tag','supplier')->field('qrcode contact_qrcode,phone contact_phone,email contact_email')->find();
        $contact['phone'] = $detail['phone'];
        $contact['email'] = $detail['email'];
        $contact['qr_code'] = $detail['qr_code'];
        $this->success('ok',$contact);

    }

    /**
     * @title 获取供应商列表
     * @desc 获取供应商列表
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierList
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @param  name:first_classify type:int default:0 desc:一级分类id
     * @param  name:second_classify type:int default:0 desc:二级分类id
     *
     * @return name:title type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:公司logo
     * @return name:phone type:string default:-- desc:电话
     * @return name:email type:string default:-- desc:email
     * @return name:label_name type:array default:-- desc:标签
     * @return name:content type:string default:-- desc:供应商详情
     * @return name:create_at type:string default:-- desc:时间
     * @return name:build_time type:string default:-- desc:成立时间
     * @return name:work_place type:string default:-- desc:办公地点
     * @return name:business type:string default:-- desc:业务范围
     * @return name:total_num type:int default:-- desc:总评论数（仅一级）
     */
    public function getSupplierList(){
        $title = input('get.title');
        $sort_type = input('get.sort_type',1);
        $first_classify = input('get.first_classify');
        $second_classify = input('get.second_classify');
        switch ($sort_type) {
            case 1:
                $order =  ['sort'=>'desc','id'=>'asc'];
                break;
            case 2:
                $order =  ['id'=>'asc','sort'=>'desc'];
                break;
            case 3:
                $order =  ['id'=>'desc','sort'=>'desc'];
                break;
        }
        $sel_where = [];
        $sel_where[] = ['is_deleted','=',0];
        $sel_where[] = ['status','=',1];
        if($first_classify)  $sel_where[]  = ['first_classify','=',$first_classify];
        if($second_classify)  $sel_where[]  = ['second_classify','=',$second_classify];
        if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,9);
        $list = \app\common\model\Supplier::where($sel_where)
            ->when($title,function ($query)use($title){
                if($title) $query->where('title|label','like','%'.$title.'%');
            })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
        foreach ($list as &$v) {
            $v['cover'] =$v['logo'] ;
            $v['label_name'] =$v['label'] ?  explode(',',trim($v['label'],',')):null;
            $v['business_arr'] = $v['business'] ? explode(',',trim($v['business'],',')) : null;
        }
        $total_num  =\app\common\model\Supplier::where($sel_where)->when($title,function ($query)use($title){
            if($title) $query->where('title|label','like','%'.$title.'%');
        })->count();
        $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取供应商详情
     * @desc 获取供应商详情
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int default:-- desc:供应商记录id
     * @return name:title type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:公司logo
     * @return name:phone type:string default:-- desc:电话
     * @return name:email type:string default:-- desc:email
     * @return name:label_name type:array default:-- desc:标签
     * @return name:content type:string default:-- desc:供应商详情
     * @return name:create_at type:string default:-- desc:时间
     * @return name:build_time type:string default:-- desc:成立时间
     * @return name:work_place type:string default:-- desc:办公地点
     * @return name:business type:string default:-- desc:业务范围
     */
    public function getSupplierDetail()
    {
        $sel_where[]  = ['id','=',input('get.id')];
        $detail = \app\common\model\Supplier::where($sel_where)->find()->toArray();
        $detail['label_name'] =$detail['label'] ?  explode(',',trim($detail['label'],',')):null;
        $detail['business_arr'] = $detail['business'] ? explode(',',trim($detail['business'],',')) : null;
        UserTrack::crateTrack($this->user_id,9,input('get.id'),0);
        $this->success('ok',['detail'=>$detail]);
    }

    /**
     * @title 供应商商品推荐
     * @desc 供应商商品推荐
     * @author qc
     * @method GET
     * @url /api/Supplier/getRecommendList
     * @header name:Authorization require:1 desc:Token
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:id type:int default:-- desc:供应商商品d
     * @return name:name type:string default:-- desc:商品名称
     * @return name:cover_arr type:array default:-- desc:封面
     * @return name:label_name type:array default:-- desc:标签
     * @return name:label type:string default:-- desc:标签
     * @return name:supplier_name type:float default:-- desc:供应商名称
     * @return name:supplier_logo type:string default:-- desc:供应商logo
     * @return name:company_name type:string default:-- desc:公司名称
     * @return name:company_logo type:string default:-- desc:公司logo
     * @return name:read_num type:int default:-- desc:阅读量
     *
     */
    public function getRecommendList()
    {
        $search_log =  UserSearch::getSearchTitle($this->user_id,10);
        $search_arr = [];
        $where_str = 'b.id > 0';
        foreach ($search_log as $t){
            $search_arr[] =  " b.name like '".'%'.$t."%'" .' ';
            $search_arr[] =  " b.label like '".'%'.$t."%'" .' ';
        }
        if(!empty($search_arr)) $where_str  =  implode(' OR ',$search_arr);
        $field = 'a.id,a.supplier_id,a.company_id,a.name,a.label,a.cover,a.read_num,IFNULL(is_recommend,0) is_recommend,y.title company_name,y.logo company_logo ,k.title supplier_name,k.logo supplier_logo';
        $table = 'dd_supplier_goods';
        $order_by_two = 'a.read_num';
        $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_supplier as k ON a.supplier_id = k.id LEFT JOIN dd_company as y ON a.company_id = y.id WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0  ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
        $list = Db::query($sql);
        $list = dispose_recommend($list);
        array_walk($list,function (&$v,$k){
            $v['read_num'] = numTransform($v['read_num']);
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
        });
        $sql2 = "SELECT  count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_supplier as k ON a.supplier_id = k.id  WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0 ";
        $total =  Db::query($sql2);
        $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取合集列表【不分页】
     * @desc
     * @author qc
     * @method GET
     * @url /api/Supplier/getCompilationsList
     * @header name:Authorization require:1 desc:Token
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:supplier_id type:int default:-- desc:供应商记录id
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @return name:title type:string default:-- desc:供应商名称
     * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
     * @return name:goods_num type:int default:-- desc:商品数量
     * @return name:goods_list type:array default:-- desc:商品合集
     * @return name:goods_list.id type:array default:-- desc:商品id
     * @return name:goods_list.name type:string default:-- desc:商品名
     * @return name:goods_list.cover type:string default:-- desc:图片【多张|隔开】
     * @return name:goods_list.cover_arr type:array default:-- desc:图片数组
     * @return name:goods_list.is_recently type:int default:-- desc:是否最近观看【0否1是】
     *
     */
    public function getCompilationsList()
    {
        $supplier_id = input('get.supplier_id');
        $sort_type = input('get.sort_type',1);
        $sel_where = [];
        $sel_where[] = ['id','=',$supplier_id];
        $detail = \app\common\model\Supplier::field('id,title,is_deleted,status')->where($sel_where)->with(['goodsList'=>function($query)use($sort_type){
            switch ($sort_type) {
                case 1:
                    $order =  ['sort'=>'desc','id'=>'asc'];
                    break;
                case 2:
                    $order =  ['id'=>'asc','sort'=>'desc'];
                    break;
                case 3:
                    $order =  ['id'=>'desc','sort'=>'desc'];
                    break;
            }
            return $query->order($order);
        }])->find()->toArray();
        $recently_id = UserTrack::getRecentlyTrack($this->user_id,10,$detail['id']);
        $detail['is_recently'] = $recently_id ? 1 : 0;
        if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该供应商信息有误');
        $detail['follow_switch'] =  PlatformSwitch::checkSwitch($this->user_id,$detail['id'],5);
        $detail['goods_num'] = count($detail['goods_list']);
        foreach ($detail['goods_list'] as &$dv) {
            $dv['create_at'] = substr($dv['create_at'],0,10);
            $dv['read_num'] = numTransform($dv['read_num']);
            $dv['cover_arr'] = $dv['cover'] ?  explode('|',trim($dv['cover'])):null;
        }
        $this->success('ok',['detail'=>$detail]);

    }

    /**
     * @title 合集列表--【按供应商id查询】
     * @desc 供应商商品列表
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierGoodsList
     * @header name:Authorization require:1 desc:Token
     * @param  name:supplier_id type:int default:-- desc:供应商记录id
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @return name:name type:string default:-- desc:名称
     * @return name:supplier_name type:string default:-- desc:供应商名称
     * @return name:supplier_logo type:string default:-- desc供应商logo
     * @return name:cover type:string default:-- desc:图片【多张|隔开】
     * @return name:cover_arr type:array default:-- desc:图片数组
     * @return name:label_name type:array default:-- desc:标签
     * @return name:company_name type:string default:-- desc:公司名称
     * @return name:company_logo type:string default:-- desc:公司logo
     * @return name:supplier type:array default:-- desc:供应商信息
     *
     */
    public function getSupplierGoodsList()
    {
        $supplier_id = input('get.supplier_id');
        $sort_type = input('get.sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['g.read_num'=>'desc','g.id'=>'asc'];
                break;
            case 2:
                $order =  ['g.id'=>'asc','g.sort'=>'desc'];
                break;
            case 3:
                $order =  ['g.id'=>'desc','g.sort'=>'desc'];
                break;
        }
        $sel_where = [];
        $sel_where[] = ['g.is_deleted','=',0];
        $sel_where[] = ['g.status','=',1];
        $sel_where[] = ['g.supplier_id','=',$supplier_id];
        $list = SupplierGoods::where($sel_where)
            ->field('g.id,g.name,g.cover,g.label,y.title company_name,y.logo company_logo')
            ->alias('g')
            ->leftJoin('Company y','y.id = g.company_id')
            ->order($order)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        $supplier_info = \app\common\model\Supplier::where('id',$supplier_id)->field('id,title,logo')->find()->toArray();
        foreach ($list as &$v) {
            $v['label_name'] =$v['label'] ?  explode(',',trim($v['label'],',')):null;
            $v['cover_arr'] =$v['cover'] ?  explode('|',trim($v['cover'])):null;
            $v['supplier_name'] = $supplier_info['title'];
            $v['supplier_logo'] = $supplier_info['logo'];
        }
        $total_num = SupplierGoods::where($sel_where)->alias('g')->count();
        $this->success('ok',['list'=>$list,'supplier'=>$supplier_info,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 合集列表--【按公司id查询】
     * @desc 供应商商品列表
     * @author qc
     * @method GET
     * @url /api/Supplier/getCompanyGoodsList
     * @header name:Authorization require:1 desc:Token
     * @param  name:company_id type:int default:-- desc:公司id
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @return name:name type:string default:-- desc:名称
     * @return name:supplier_name type:string default:-- desc:供应商名称
     * @return name:supplier_logo type:string default:-- desc供应商logo
     * @return name:cover type:string default:-- desc:图片【多张|隔开】
     * @return name:cover_arr type:array default:-- desc:图片数组
     * @return name:label_name type:array default:-- desc:标签
     * @return name:company_name type:string default:-- desc:公司名称
     * @return name:company_logo type:string default:-- desc:公司logo
     * @return name:company type:array default:-- desc:公司信息
     * @return name:company.title type:string default:-- desc:公司名
     * @return name:company.follow_switch type:string default:-- desc:是否订阅
     * @return name:total_num type:array default:-- desc:总数
     *
     */
    public function getCompanyGoodsList()
    {
        $company_id = input('get.company_id');
        $sort_type = input('get.sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['g.read_num'=>'desc','g.id'=>'asc'];
                break;
            case 2:
                $order =  ['g.id'=>'asc','g.sort'=>'desc'];
                break;
            case 3:
                $order =  ['g.id'=>'desc','g.sort'=>'desc'];
                break;
        }
        $sel_where = [];
        $sel_where[] = ['g.is_deleted','=',0];
        $sel_where[] = ['g.status','=',1];
        $sel_where[] = ['g.company_id','=',$company_id];
        $company_info = Company::where('id',$company_id)->field('title')->find()->toArray();
        $company_info['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$company_id,5);
        $list = SupplierGoods::where($sel_where)
            ->field('g.id,g.name,g.cover,g.label,g.create_at,y.title company_name,y.logo company_logo,g.read_num')
            ->alias('g')
            ->leftJoin('Company y','y.id = g.company_id')
            ->order($order)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        foreach ($list as &$v) {
            $v['label_name'] =$v['label'] ?  explode(',',trim($v['label'],',')):null;
            $v['cover_arr'] =$v['cover'] ?  explode('|',trim($v['cover'])):null;
            $v['read_num'] =numTransform($v['read_num']);
        }
        $total_num = SupplierGoods::where($sel_where)->alias('g')->count();
        $this->success('ok',['list'=>$list,'company'=>$company_info,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);

    }


    /**
     * @title 产品详情
     * @desc 产品详情
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierGoodsDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:goods_id type:int default:-- desc:供应商产品id
     * @return name:name type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
     * @return name:cover_arr type:array default:-- desc:图片数组
     * @return name:label_name type:array default:-- desc:标签
     * @return name:content type:string default:-- desc:详情
     * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
     * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
     * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
     * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
     * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
     * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:praise_num type:int default:-- desc:点赞量
     * @return name:is_praise type:int default:-- desc:是否点赞
     * @return name:transmit_num type:int default:-- desc:转发量
     *
     * @return name:supplier_info type:array default:-- desc:供应商详情
     * @return name:supplier_info.title type:string default:-- desc:名称
     * @return name:supplier_info.cover type:string default:-- desc:公司logo
     * @return name:supplier_info.phone type:string default:-- desc:电话
     * @return name:supplier_info.email type:string default:-- desc:email
     * @return name:supplier_info.label_name type:array default:-- desc:标签
     * @return name:supplier_info.content type:string default:-- desc:供应商详情
     * @return name:supplier_info.create_at type:string default:-- desc:时间
     * @return name:supplier_info.build_time type:string default:-- desc:成立时间
     * @return name:supplier_info.work_place type:string default:-- desc:办公地点
     * @return name:supplier_info.business type:string default:-- desc:业务范围
     */
    public function getSupplierGoodsDetail()
    {
        $goods_id = input('get.goods_id');
        $detail = SupplierGoods::where('id',$goods_id)->find()->toArray();
        $detail['label_name'] =$detail['label'] ?  explode(',',trim($detail['label'],',')):null;
        $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$detail['id']);
        $detail['collect_num'] = UserCollect::getCollectNum(9,$detail['id']);
        $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],7);
        $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],7);
        $detail['read_num'] = numTransform($detail['read_num']);
        $detail['transmit_num'] = numTransform($detail['transmit_num']);


        $supplier_info = \app\common\model\Supplier::where('id',$detail['supplier_id'])->find()->toArray();
        $supplier_info['label_name'] =$supplier_info['label'] ?  explode(',',trim($supplier_info['label'],',')):null;
        $supplier_info['business_arr'] = $supplier_info['business'] ? explode(',',trim($supplier_info['business'],',')) : null;
        $supplier_info['cover'] = $supplier_info['logo'] ;
        UserTrack::crateTrack($this->user_id,10,$goods_id,0);
        SupplierGoods::where('id',$goods_id)->setInc('read_num');
        $this->success('ok',['detail'=>$detail,'supplier_info'=>$supplier_info]);
    }

    /**
     * @title 供应商搜索列表
     * @desc 供应商搜索列表
     * @author qc
     * @method GET
     * @url /api/Supplier/searchGoods
     * @header name:Authorization require:1 desc:Token
     * @param  name:search_name type:int default:-- desc:搜索名称
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     *
     * @return name:name type:string default:-- desc:名称
     * @return name:supplier_name type:string default:-- desc:供应商名称
     * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
     * @return name:cover_arr type:array default:-- desc:图片数组
     * @return name:label_name type:array default:-- desc:标签
     * @return name:content type:string default:-- desc:详情
     * @return name:read_num type:int default:-- desc:浏览量
     * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
     * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
     * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
     * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
     * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
     * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
     * @return name:supplier_name type:string default:-- desc:供应商名称
     * @return name:supplier_logo type:string default:-- desc供应商logo
     * @return name:total_num type:array default:-- desc:总数
     *
     */
    public function searchGoods()
    {
        $search_name = input('get.search_name');
        $sort_type = input('get.sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['g.sort'=>'desc','read_num'=>'desc','g.id'=>'asc'];
                break;
            case 2:
                $order =  ['g.id'=>'asc','g.sort'=>'desc'];
                break;
            case 3:
                $order =  ['g.id'=>'desc','g.sort'=>'desc'];
                break;
        }
        $sel_where = [];
        $sel_where[] = ['g.is_deleted','=',0];
        $sel_where[] = ['s.is_deleted','=',0];
        $sel_where[] = ['g.status','=',1];
        $sel_where[] = ['s.status','=',1];
        if($search_name && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search_name,10);
        $list = SupplierGoods::where($sel_where)
            ->field('g.id,g.supplier_id,g.name,g.label,g.read_num,g.cover,s.title supplier_name,s.logo supplier_logo')
            ->when($search_name,function ($query)use($search_name){
                if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
            })->alias('g')
            ->leftJoin('Supplier s','g.supplier_id = s.id')
            ->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
        foreach ($list as &$v) {
            $v['label_name'] =$v['label'] ?  explode(',',trim($v['label'],',')):null;
            $v['cover_arr'] =$v['cover'] ?  explode('|',trim($v['cover'])):null;
            $v['read_num'] = numTransform($v['read_num']);
        }
        $total_num = SupplierGoods::where($sel_where)->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->when($search_name,function ($query)use($search_name){
            if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
        })->count();
        $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 以下接口调用验证登录【需要header传Authorization】
     * @desc 以下接口调用验证登录
     * @author qc
     * @method
     * @url /api/Supplier/needLogin()
     */
    public function needLogin(){}





    /**
     * @title 供应商商品点赞||取消点赞
     * @desc 点赞||取消点赞
     * @author qc
     * @method POST
     * @url /api/Supplier/supplierGoodsTags
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:供应商商品记录id
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function supplierGoodsTags()
    {
        $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),7);
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }


    /**
     * @title 供应商商品收藏||取消收藏
     * @desc 用户收藏
     * @author qc
     * @method POST
     * @url /api/Supplier/supplierGoodsCollect
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:1 default:-- desc:供应商商品记录id
     * @param name:status type:int default:0 desc:收藏状态（0取消收藏【未收藏】，1收藏）
     */
    public function supplierGoodsCollect(){
        $coll_status = UserCollect::plateCollect($this->user_id,9,input('post.id',0));
        $coll_status ?  $this->success('收藏成功',['status'=>1]) :    $this->success('取消收藏成功',['status'=>0]);
    }

    /**
     * @title 转发（转发数量统计【供应商】）
     * @desc 转发成功后调用
     * @author qc
     * @method POST
     * @url /api/Supplier/supplierTransmit
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:供应商记录id
     */
    public function supplierTransmit()
    {
        $id = input('post.id',0);
        \app\common\model\Supplier::where('id',$id)->setInc('transmit_num');
        $this->success('ok');
    }

    /**
     * @title 转发（转发数量统计【供应商商品】）
     * @desc 转发成功后调用
     * @author qc
     * @method POST
     * @url /api/Supplier/supplierGoodsTransmit
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:供应商商品记录id
     */
    public function supplierGoodsTransmit()
    {
        $id = input('post.id',0);
        SupplierGoods::where('id',$id)->setInc('transmit_num');
        $this->success('ok');
    }




    /**
     * @title 我的浏览历史【供应商商品】
     * @desc 我的浏览历史
     * @author qc
     * @method GET
     * @url /api/Supplier/getSupplierGoodsTrack
     * @header name:Authorization require:1 desc:Token
     * @param name:name type:string default:-- desc:商品名称
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     * @return name:id type:string default:-- desc:浏览记录id
     * @return name:goods_id type:string default:-- desc:商品id
     * @return name:name type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:封面(多张|隔开)
     * @return name:cover_arr type:array default:-- desc:封面
     * @return name:label_name type:array default:-- desc:标签
     * @return name:supplier_name type:array default:-- desc:供应商名称
     * @return name:time type:string default:-- desc:时间
     */
    public function getSupplierGoodsTrack()
    {
        $sel_where  = [];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.type','=',10];
        $name = input('get.name');
        if($name)  $sel_where[]  = ['i.name|i.label','like','%'.$name.'%'];
        $list = UserTrack::where($sel_where)
            ->alias('t')
            ->field('t.id,t.update_int,t.first_id goods_id,i.name,i.cover,i.label,supplier_id')
            ->leftJoin('SupplierGoods i','t.first_id = i.id')
            ->order('update_int desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
            $v['cover_arr'] = $v['cover']? explode('|',$v['cover']) : null;
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
            $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
        }
        $total_num =UserTrack::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.first_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 我的点赞【供应商商品点赞列表】
     * @desc 供应商商品点赞列表
     * @author qc
     * @method GET
     * @url /api/Supplier/getTagsSupplierGoods
     * @header name:Authorization require:1 desc:Token
     * @param name:name type:string default:-- desc:商品名称
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     * @return name:id type:string default:-- desc:浏览记录id
     * @return name:goods_id type:string default:-- desc:商品id
     * @return name:name type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:封面(多张|隔开)
     * @return name:cover_arr type:array default:-- desc:封面
     * @return name:label_name type:array default:-- desc:标签
     * @return name:supplier_name type:array default:-- desc:供应商名称
     * @return name:create_at type:string default:-- desc:时间
     */
    public function getTagsSupplierGoods()
    {
        $sel_where  = [];
        $name = input('get.name');
        if($name)  $sel_where[]  = ['i.name|i.label','like','%'.$name.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.type','=',7];
        $list = PlatformLike::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.like_id goods_id,i.name,i.cover,i.label,supplier_id')
            ->leftJoin('SupplierGoods i','t.like_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['cover_arr'] = explode('|',$v['cover']);
            $v['label_name'] = explode(',',$v['label']);
            $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
            $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
        }
        $total_num =  PlatformLike::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.like_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 我的收藏【供应商商品收藏列表】
     * @desc 供应商商品收藏列表
     * @author qc
     * @method GET
     * @url /api/Supplier/getCollectSupplierGoods
     * @header name:Authorization require:1 desc:Token
     * @param name:name type:string default:-- desc:商品名称
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:id type:string default:-- desc:浏览记录id
     * @return name:goods_id type:string default:-- desc:商品id
     * @return name:name type:string default:-- desc:名称
     * @return name:cover type:string default:-- desc:封面(多张|隔开)
     * @return name:cover_arr type:array default:-- desc:封面
     * @return name:label_name type:array default:-- desc:标签
     * @return name:supplier_name type:array default:-- desc:供应商名称
     * @return name:create_at type:string default:-- desc:时间
     */
    public function getCollectSupplierGoods()
    {
        $sel_where  = [];
        $name = input('get.name');
        if($name)  $sel_where[]  = ['i.name|i.label','like','%'.$name.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.coll_type','=',9];
        $list = UserCollect::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.coll_id goods_id,i.name,i.cover,i.label,supplier_id')
            ->leftJoin('SupplierGoods i','t.coll_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['cover_arr'] = explode('|',$v['cover']);
            $v['label_name'] = explode(',',$v['label']);
            $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
            $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
        }
        $total_num= UserCollect::where($sel_where)->alias('t') ->leftJoin('SupplierGoods i','t.coll_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 以下接口为二期需求
     * @desc  以下接口为二期需求
     * @author  qc
     * @url /api/Supplier/secondPhase
     * @method
     * @return name:1 type:string default:-- desc:以下接口为二期需求
     */
    public function secondPhase(){}



    /**
     * @title 我的追更列表
     * @desc 我的追更列表
     * @author qc
     * @method GET
     * @url /api/Datum/getFollowUpList
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:create_at type:string default:-- desc:追更设置时间
     * @return name:recruit_id type:int default:-- desc:资料id
     * @return name:title type:string default:-- desc:标题
     * @return name:label type:string default:-- desc:标签
     */
    public function getFollowUpList()
    {
        $sel_where  = [];
        $sel_where[] = ['p.user_id','=',$this->user_id];
        $sel_where[] = ['p.type','=',6];
        $sel_where[] = ['p.switch_value','=',1];
        $field = 'p.id,p.switch_id as article_id,p.create_at,a.title,a.label';
        $list  = PlatformSwitch::field($field)
            ->alias('p')
            ->leftJoin('Supplier a','p.switch_id = a.id')
            ->where($sel_where)
            ->limit($this->off_set,$this->page_num)
            ->order('p.id desc')
            ->select()->toArray();
        $total_num=  PlatformSwitch::where($sel_where)->alias('p')->leftJoin('Supplier a','p.switch_id = a.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


}