gaoyixia/application/api/controller/Expedite.php

<?php


namespace app\api\controller;
use AlibabaCloud\Client\AlibabaCloud;
use AlibabaCloud\Client\Exception\ClientException;
use AlibabaCloud\Client\Exception\ServerException;
use app\common\model\ArticleComment;
use app\common\model\ArticleIntro;
use app\common\model\ArticleItem;
use app\common\model\DatumUrl;
use app\common\model\DemandComment;
use app\common\model\ForumReply;
use app\common\model\ForumReplyComment;
use app\common\model\PlatformDemand;
use app\common\model\PlatformLike;
use app\common\model\PressComment;
use app\common\model\StoreBanner;
use app\common\model\StoreGoods;
use app\common\model\SupplierGoods;
use app\common\model\TopSearch;
use app\common\model\User;
use app\common\model\UserCollect;
use app\common\model\UserForum;
use app\common\model\UserLevel;
use app\common\model\UserMessage;
use app\common\model\UserSearch;
use app\common\model\VideoUrl;
use Dm\Request\V20151123 as Dm;
use think\cache\driver\Redis;
use think\Db;
use app\common\model\VideoComment;
/**
 * @title 不需要验证token接口
 * @controller Expedite
 * @package app\api\controller
 */
class Expedite extends Base
{

    public function initialize(){
        parent::initialize();
        parent::setUid();
    }

    /**
     * @title 获取首页轮播图
     * @desc  获取首页轮播图
     * @author  qc
     * @url /api/Expedite/getBanner
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param  name:place type:int  default:1 desc:展示位置1视频首页
     * @param  name:num type:int  default:5 desc:查询数量
     * @return name:cover type:srting default:-- desc:图片路径
     * @return name:link type:srting default:-- desc:链接
     */
    public function getBanner()
    {
        $num = input('get.num',5);
        $place = input('get.place',1);
        $list = StoreBanner::field('id,cover,link')
            ->where(['is_deleted'=>0,'place'=>$place])->limit(0,$num)
            ->order('sort desc ,id desc')->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }

    /**
     * @title 获取会员等级设置
     * @desc  获取会员等级设置
     * @author  qc
     * @url /api/Expedite/getUserLevelSet
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:id type:int default:-- desc:等级id
     * @return name:name type:string default:-- desc:等级名称
     * @return name:logo type:string default:-- desc:图片
     * @return name:price type:array default:-- desc:价格设置【为空，，不能购买】
     * @return name:price.title type:string default:-- desc:标题
     * @return name:price.time type:string default:-- desc:时间（单位月）
     * @return name:price.price type:float default:-- desc:价格
     */
    public function getUserLevelSet()
    {
        $list = UserLevel::field('id,logo,name,price')->where("price is not null and price != ''")->where('id',1)->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }


    /**
     * @title 获取热搜设置标题
     * @desc  获取热搜设置
     * @author  qc
     * @url /api/Expedite/getTopSearch
     * @method GET
     * @param name:sort_type type:int default:1 desc:排序规则1默认2搜索量
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数量
     * @param name:type type:int default:-- desc:类型0=>"全部",1=>'视频',2=>'图文',3=>'资料',4=>'新闻',5=>'需求',6=>'问答',7=>'商品',8=>'招聘',9=>'供应商',10=>'供应商产品',11=>'活动',
     * @return name:title type:string default:-- desc:标题
     * @return name:num type:int default:-- desc:搜索量
     * @return name:type type:int default:-- desc:类型0=>"全部",1=>'视频',2=>'图文',3=>'资料',4=>'新闻',5=>'需求',6=>'问答',7=>'商品',8=>'招聘',9=>'供应商',10=>'供应商产品',11=>'活动',
     */
    public function getTopSearch()
    {
        $type = input('type');
        $sort_type= input('sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['sort'=>'desc','id'=>'asc'];
                break;
            case 2:
                $order =  ['num'=>'desc','id'=>'desc'];
                break;
            default:
                $order =  ['num'=>'desc','id'=>'desc'];
                break;
        }
        $sel = [];
        $sel['is_deleted'] = 0;
        $sel['status'] = 1;
        if($type)   $sel['type'] =$type;
        $list = TopSearch::field('id,title,type,num')
            ->where($sel)
            ->order($order)
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }


    /**
     * @title 全局搜索【登录状态需要header需要传Authorization】
     * @desc  全局搜索
     * @author  qc
     * @url /api/Expedite/globalSearch
     * @method GET
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数量
     * @param name:type type:string default:-- desc:搜索类型(不传查全部)[video=>视频，article=>图文，datum=>资料，goods=>商城商品，press=>新闻，supplier_goods=>供应商商品，demand=>需求，recruit=>招聘，forum=>问答,activity=>活动]
     * @param name:search_name type:string default:-- desc:搜索名称
     * @param name:search_time type:int default:-- desc:0不限，182半年，365一年
     * @return name:video_list type:array default:-- desc:视频列表【单个】
     * @return name:video_list.url_id type:int default:-- desc:url_id
     * @return name:video_list.video_id type:int default:-- desc:video_id
     * @return name:video_list.cover type:string default:-- desc:封面
     * @return name:video_list.title type:string default:-- desc:标题
     * @return name:video_list.is_vip type:int default:-- desc:是否是vip【0否1是】
     * @return name:video_list.ali_vid type:string default:-- desc:云点播视频id
     * @return name:video_list.read_num type:int default:-- desc:播放量
     * @return name:video_list.duration type:int default:-- desc:时长（单位：秒）
     * @return name:video_list.app_name type:string default:-- desc:平台名称
     * @return name:video_list.app_logo type:string default:-- desc:平台头像

     * @return name:article_list type:array default:-- desc:图文列表【单个】
     * @return name:article_list.title type:string default:-- desc:图文标题
     * @return name:article_list.is_vip type:int default:-- desc:是否是vip
     * @return name:article_list.cover type:string default:-- desc:封面
     * @return name:article_list.images type:int default:-- desc:图片【多张|隔开】
     * @return name:article_list.images_arr type:array default:-- desc:图片
     * @return name:article_list.read_num type:int default:-- desc:阅读量
     * @return name:article_list.app_name type:string default:-- desc:平台名称
     * @return name:article_list.app_logo type:string default:-- desc:平台头像
     *
     * @return name:datum_list type:array default:-- desc:资料列表【单个】
     * @return name:datum_list.id type:int default:-- desc:资料的url_id
     * @return name:datum_list.title type:string default:-- desc:标题
     * @return name:datum_list.is_vip type:int default:-- desc:是否是vip
     *
     * @return name:press_list type:array default:-- desc:新闻列表
     * @return name:press_list.id type:int default:-- desc:新闻id
     * @return name:press_list.title type:string default:-- desc:标题
     * @return name:press_list.cover type:string default:-- desc:封面
     * @return name:press_list.images_arr type:array default:-- desc:图片
     * @return name:press_list.read_num type:int default:-- desc:阅读量
     * @return name:press_list.is_collect type:int default:-- desc:是否收藏(0否1是)
     * @return name:press_list.transmit_num type:int default:-- desc:转发量
     * @return name:press_list.collect_num type:int default:-- desc:收藏量
     * @return name:press_list.praise_num type:int default:-- desc:点赞量
     * @return name:press_list.is_praise type:int default:-- desc:是否点赞(0否1是)
     * @return name:press_list.comment_num type:int default:-- desc:评论量
     *
     *
     *
     *
     * @return name:recruit_list type:array default:-- desc:招聘列表
     * @return name:recruit_list.title type:string default:-- desc:标题
     * @return name:recruit_list.company type:string default:-- desc:公司名
     * @return name:recruit_list.cover type:string default:-- desc:公司logo
     * @return name:recruit_list.label_name type:array default:-- desc:标签
     * @return name:recruit_list.welfare_arr type:array default:-- desc:岗位福利
     * @return name:recruit_list.education type:string default:-- desc:学历
     * @return name:recruit_list.experience_min type:int default:0 desc:最低工作年限
     * @return name:recruit_list.experience_max type:int default:0 desc:最高工作年限
     * @return name:recruit_list.price_min type:int default:-- desc:最低薪资
     * @return name:recruit_list.price_max type:int default:-- desc:最高薪资
     * @return name:recruit_list.province type:string default:-- desc:省名
     * @return name:recruit_list.city type:string default:-- desc:市名
     * @return name:recruit_list.address type:string default:-- desc:地址
     * @return name:recruit_list.app_name type:string default:-- desc:发布人名称
     * @return name:recruit_list.app_logo type:string default:-- desc:发布人头像
     *
     * @return name:goods_list type:array default:-- desc:商城商品
     * @return name:goods_list.id type:int default:-- desc:d
     * @return name:goods_list.name type:string default:-- desc:商品名称
     * @return name:goods_list.cover type:string default:-- desc:封面
     * @return name:goods_list.low_price type:float default:-- desc:价格
     *
     * @return name:supplier_goods_list type:array default:-- desc:供应商商品
     * @return name:supplier_goods_list.id type:int default:-- desc:供应商商品d
     * @return name:supplier_goods_list.name type:string default:-- desc:商品名称
     * @return name:supplier_goods_list.cover_arr type:array default:-- desc:封面
     * @return name:supplier_goods_list.label_name type:array default:-- desc:标签
     * @return name:supplier_goods_list.label type:string default:-- desc:标签
     * @return name:supplier_goods_list.read_num type:int default:-- desc:浏览量
     * @return name:supplier_goods_list.supplier_name type:float default:-- desc:供应商名称
     *
     * @return name:demand_list type:array default:-- desc:需求
     * @return name:demand_list.title type:string default:-- desc:标题
     * @return name:demand_list.content type:string default:-- desc:内容
     * @return name:demand_list.cover type:array default:-- desc:封面
     * @return name:demand_list.money type:float default:-- desc:价格
     * @return name:demand_list.app_name type:string default:-- desc:发布方名称
     * @return name:demand_list.app_logo type:string default:-- desc:发布方头像
     * @return name:demand_list.is_over type:int default:-- desc:是否解决或开源【0否，1是,2开源】
     * @return name:demand_list.company type:string default:-- desc:公司名
     * @return name:demand_list.company_logo type:string default:-- desc:公司logo
     *
     *
     * @return name:forum_list type:array default:-- desc:问答
     * @return name:forum_list.id type:int default:-- desc:id
     * @return name:forum_list.title type:string default:-- desc:标题
     * @return name:forum_list.content type:string default:0 desc:内容
     * @return name:forum_list.level type:int default:-- desc:vip等级id
     * @return name:forum_list.label type:string default:-- desc:标签
     * @return name:forum_list.name type:string default:-- desc:发布用户
     * @return name:forum_list.headimg type:string default:-- desc:发布用户头像
     * @return name:forum_list.browse_num type:int default:-- desc:浏览量
     * @return name:forum_list.reply_num type:int default:-- desc:回答量
     *
     * @return name:activity_list type:array default:-- desc:活动
     * @return name:activity_list.id type:int default:-- desc:id
     * @return name:activity_list.address type:string default:-- desc:地址
     * @return name:activity_list.cover type:string default:-- desc:封面
     * @return name:activity_list.label_name type:array default:-- desc:标签
     * @return name:activity_list.start_time type:string default:-- desc:开始时间
     * @return name:activity_list.end_time type:string default:-- desc:结束时候
     * @return name:activity_list.end_time type:string default:-- desc:结束时间
     * @return name:activity_list.price type:string default:-- desc:价格
     */
    public function globalSearch()
    {
        $type = input('get.type');
        $search_name = input('get.search_name');
        $search_time = input('get.search_time');
        $app_name = sysconf('app_name');
        $app_logo = sysconf('app_logo');
        $user_id  = $this->user_id;
        if($this->user_id && $search_name) UserSearch::saveSearchTitle($this->user_id,$search_name,0);
        // 视频
        $video_list = VideoUrl::field('a.id url_id,a.video_id,a.cover,a.title,a.is_vip,a.ali_vid,a.label,a.read_num,a.transmit_num,a.user_id,a.duration')->alias('a')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
                if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })->leftJoin('video_intro b','b.id = a.video_id')
            ->where('a.status',1)
            ->where('a.is_deleted',0)
            ->where('b.status',1)
            ->where('b.is_deleted',0)->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($video_list,function (&$v,$k)use ($app_name,$app_logo){
            if(!$v['user_id']){
                $v['app_name']  = $app_name;
                $v['app_logo']  = $app_logo;
            }else{
                $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
                $v['app_name']  = $user_info ? $user_info->name : '';
                $v['app_logo']  = $user_info ? $user_info->headimg : '';
            }
        });
        // 图文
        $article_list = ArticleItem::field('a.id item_id,a.user_id,a.article_id,a.cover,a.title,a.is_vip,a.images,a.read_num')->alias('a')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
                if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })->leftJoin('article_intro b','a.article_id = b.id')
            ->where('a.status',1)
            ->where('a.is_deleted',0)
            ->where('b.status',1)
            ->where('b.is_deleted',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($article_list,function (&$v,$k)use ($app_name,$app_logo){
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            if(!$v['user_id']){
                $v['app_name']  = $app_name;
                $v['app_logo']  = $app_logo;
            }else{
                $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
                $v['app_name']  = $user_info ? $user_info->name : '';
                $v['app_logo']  = $user_info ? $user_info->headimg : '';
            }
        });

        // 资料
        $datum_list = DatumUrl::field('a.id,a.url,a.datum_id,a.title,a.is_vip')->alias('a')
            ->when($search_name,function ($query)use ($search_name,$search_time){
            if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
            if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
        })->leftJoin('datum_intro b','b.id = a.datum_id')
            ->where('a.status',1)
            ->where('a.is_deleted',0)
            ->where('b.status',1)
            ->where('b.is_deleted',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();

        //新闻
        $press_list = \app\common\model\Press::field('id,title,cover,images,read_num')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('title|label','like','%'.$search_name.'%');
                if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })
            ->where('status',1)
            ->where('is_deleted',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($press_list,function (&$v,$k){
            $v['comment_num'] = PressComment::where(['first_id'=>$v['id'],'type'=>1,'is_deleted'=>0])->count();
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['id']);
            $v['collect_num'] = UserCollect::getCollectNum(4,$v['id']);
            $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['id'],1);
            $v['praise_num'] = PlatformLike::getPraiseNum($v['id'],1);
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
        });

        //招聘
        $recruit_list = \app\common\model\Recruit::field('id,title,label,address,price_min,price_max,company,education,experience_min,experience_max,welfare,province,city,salary,user_id')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('title|label','like','%'.$search_name.'%');
                if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })
            ->where('status',1)
            ->where('is_deleted',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($recruit_list,function (&$v,$k)use ($app_logo,$app_name){
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
            if(!$v['user_id']){
                $v['app_name']  = $app_name;
                $v['app_logo']  = $app_logo;
            }else{
                $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
                $v['app_name']  = $user_info ? $user_info->name : '';
                $v['app_logo']  = $user_info ? $user_info->headimg : '';
            }
        });


        // 商品
        $goods_list = StoreGoods::field('id,name,cover,low_price')->when($search_name,function ($query)use ($search_name,$search_time){
            if($search_name) $query->where('name','like','%'.$search_name.'%');
            if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
        })->where('is_deleted',0)->where('status',1)->limit($this->off_set,$this->page_num)->select()->toArray();

        // 供应商
        $supplier_goods_list =SupplierGoods::field('g.id,g.supplier_id,g.name,g.read_num,g.label,g.cover,s.title supplier_name')
            ->alias('g')
            ->when($search_name,function ($query)use($search_name,$search_time){
                if($search_name) $query->where('g.name','like','%'.$search_name.'%');
                if($search_time) $query->where('g.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })->leftJoin('Supplier s','g.supplier_id = s.id')
            ->where('g.status','=',1)
            ->where('g.is_deleted','=',0)
            ->where('s.status','=',1)
            ->where('s.is_deleted','=',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($supplier_goods_list,function (&$v,$k){
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['cover_arr'] = explode('|',trim($v['cover'],'|'));
        });

        // 需求
        $demand_list = PlatformDemand::field('id,cover,money,user_id,label,title,cover,is_over,content,company,company_logo')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                    if($search_name) $query->where('title|label','like','%'.$search_name.'%');
                    if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
                })
            ->where('status',1)
            ->where('is_deleted',0)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($demand_list,function (&$v,$k)use ($app_logo,$app_name){
            if(!$v['user_id']){
                $v['app_name']  = $app_name;
                $v['app_logo']  = $app_logo;
            }else{
                $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
                $v['app_name']  = $user_info ? $user_info->name : '';
                $v['app_logo']  = $user_info ? $user_info->headimg : '';
            }
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['cover_arr'] = explode('|',trim($v['cover'],'|'));
        });


        // 问答
        $forum_list = UserForum::alias('f')
            ->field('f.id,f.title,f.content,f.label,f.level,f.browse_num,f.sort,f.create_at,u.name,u.headimg, IFNULL( (SELECT count(DISTINCT r.user_id) FROM dd_forum_reply as r WHERE f.id=r.forum_id),0 ) as reply_num')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('f.title|f.label','like','%'.$search_name.'%');
                if($search_time) $query->where('f.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));

            })->leftJoin('store_member u','u.id = f.user_id')
            ->where('f.status',1)
            ->where('f.is_deleted',0)
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        // 活动
        $activity_list = \app\common\model\Activity::field('id,cover,title,address,label,start_time,end_time,ladder,price')
            ->when($search_name,function ($query)use ($search_name,$search_time){
                if($search_name) $query->where('title|label','like','%'.$search_name.'%');
                if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })
            ->where('status',1)
            ->where('is_deleted',0)
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($activity_list,function (&$v,$k){
            $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
            $v['ladder'] = $v['ladder'] ? json_decode($v['ladder'],true):null;
        });
        $this->success('ok',$type ? compact($type.'_list'): compact(['video_list','article_list','datum_list','goods_list','press_list','supplier_goods_list','demand_list','recruit_list','forum_list','activity_list']));
    }



    /**
     * @title 发送短信验证码
     * @desc 发送短信验证码
     * @author qc
     * @url /api/Expedite/sendSms
     * @method POST
     * @tag 短信验证码
     * @param name:phone type:int require:1 default:-- desc:要获取验证码的手机号
     * @return name:code type:string default:-- desc:验证码
     */
    public function sendSms(){
        $phone = input('post.phone');
        $user_info  = User::where('phone',$phone)->where('is_deleted',0)->field('id,status')->find();
        if($user_info && $user_info['status'] == 0)$this ->error('用户被禁用，请联系官方');
        if(empty($phone)) $this ->error('参数错误');
        $code = rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9);
        AlibabaCloud::accessKeyClient('LTAI5tJ5p12drZegeWVG33xZ', '82UWAiY5e5wH8tSkRvMtqVoGO0h8SB')
            ->regionId('cn-hangzhou')->asDefaultClient();
        try {
            $result = AlibabaCloud::rpc()
                ->product('Dysmsapi')
                ->version('2017-05-25')
                ->action('SendSms')
                ->method('POST')
                ->host('dysmsapi.aliyuncs.com')
                ->options([
                    'query' => [
                        'RegionId' => "cn-hangzhou",
                        'PhoneNumbers' => $phone,
                        'SignName' => "搞一下汽车电子",
                        'TemplateCode' => "SMS_234397351",
                        'TemplateParam' => json_encode(array("code"=>$code)),
                    ],
                ])->request();
            $result = $result->toArray();
            if($result['Code'] == "OK") {
                $sms_data = array(
                    'phone'=>$phone,
                    'code'=>$code,
                    'result'=>$result['Message']
                );
                Db::name('store_member_sms')->insert($sms_data);
                $this->success('发送成功',['code'=>$code]);
            }else{
                $this->error('发送失败');
            }
        } catch (ClientException $e) {
            echo $e->getErrorMessage() . PHP_EOL;
        } catch (ServerException $e) {
            echo $e->getErrorMessage() . PHP_EOL;
        }

    }

    /**
     * @title 发送邮箱验证码
     * @desc 发送邮箱验证码
     * @author qc
     * @url /api/Expedite/emailSms
     * @method POST
     * @tag 邮箱验证码
     * @param name:email type:int require:1 default:-- desc:邮箱
     * @return name:code type:string default:-- desc:验证码
     */
    function emailSms(){
        $email = input('post.email');
        $user_info  = User::where('email',$email)->where('is_deleted',0)->field('id,status')->find();
        if($user_info && $user_info['status'] == 0)$this ->error('用户被禁用，请联系官方');
        $code = rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9);
        require_once env('root_path').'/vendor/aliyunmail/aliyun-php-sdk-core/Config.php';
        $iClientProfile = \DefaultProfile::getProfile("cn-hangzhou", "LTAI5tJ5p12drZegeWVG33xZ", "82UWAiY5e5wH8tSkRvMtqVoGO0h8SB");
        $client = new \DefaultAcsClient($iClientProfile);
        $request = new Dm\SingleSendMailRequest();
        $request->setAccountName("gyx@yzm.gyxqcdz.com");
        $request->setFromAlias("[验证码]");
        $request->setAddressType(1);
        $request->setTagName("zonghuzhuche");
        $request->setReplyToAddress("true");
        $request->setToAddress($email);
        $request->setSubject("验证码");
        $html_body = '验证码：'.$code;
        $request->setHtmlBody($html_body);
        try {
            $send_res = $client->getAcsResponse($request);
            $sms_data = array(
                'phone'=>$email,
                'code'=>$code,
                'result'=>'OK'
            );
            Db::name('store_member_sms')->insert($sms_data);
            $this->success('发送成功',['code'=>$code]);
        } catch (ClientException  $e) {
            $this->error($e->getErrorMessage());
           // print_r($e->getErrorCode());
           // print_r($e->getErrorMessage());
        } catch (ServerException  $e) {
            $this->error($e->getErrorMessage());
           // print_r($e->getErrorCode());
           // print_r($e->getErrorMessage());

        }
    }

    /**
     * @title 获取签名
     * @desc 获取签名
     * @url /api/Expedite/getWeChatSign
     * @method POST
     * @param  name:url type:string default:-- desc:页面地址
     * @return name:appid type:string default:-- desc:appid
     * @return name:noncestr type:string default:-- desc:随机字符
     * @return name:timestamp type:string default:-- desc:时间戳
     * @return name:sign type:string default:-- desc:签名
     * @return name:ticket type:string default:-- desc:ticket
     **/
    public function getWeChatSign(){
        $urls = input('post.url');
        $appid = config('app.official_account')['appid'];
        $secret =  config('app.official_account')['secret'];
        $redis = new Redis();
        $access_token = $redis->get('access_token');
        if (!$access_token){
            $access_token = '';
            $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
            $res= http_curl($url);
            if (isset($res['access_token'])){
                $redis->set('access_token',$res['access_token'],'7000');
                $access_token = $res['access_token'];
            }
        }

        $url2 ="https://api.weixin.qq.com/cgi-bin/ticket/getticket?access_token=".$access_token."&type=jsapi";
        $res2=http_curl($url2);
        if (!isset($res2) || $res2['errcode']!=0) $this->error('获取ticket失败');
        $timestamp = time();
        $noncestr = get32Str(15);
        $string = "jsapi_ticket=".$res2['ticket']."&noncestr=$noncestr&timestamp=$timestamp&url=".$urls;
        $sign = sha1($string);
        $return = [
            'appid'=>$appid,
            'noncestr'=>$noncestr,
            'timestamp'=>$timestamp,
            'url'=>$urls,
            'sign'=>$sign,
            'ticket'=>$res2['ticket']
        ];
        $this->success('成功',$return);
    }



    /**
     * @title 获取分享链接
     * @desc 获取分享链接
     * @url /api/Expedite/getUrlScheme
     * @method POST
     * @param  name:url type:string default:-- desc:页面地址
     * @return name:url type:string default:-- desc:url
     **/
    public function getUrlScheme()
    {
        $appid = config('app.mini_program')['app_id'];
        $secret =  config('app.mini_program')['secret'];
        $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
        $res= http_curl($url);
        $access_token = $res['access_token'];
        $api_url = 'https://api.weixin.qq.com/wxa/generatescheme?access_token='.$access_token;

        $url_scheme = curl_post($api_url,[]);
        $this->success('ok',['url'=>$url_scheme['openlink']]);
    }


    /**
     * @title getUrlLink
     * @desc getUrlLink
     * @url /api/Expedite/getUrlLink
     * @method POST
     * @param  name:url type:string default:-- desc:页面地址
     * @return name:url type:string default:-- desc:url
     **/
    public function getUrlLink()
    {
        $appid = config('app.mini_program')['app_id'];
        $secret =  config('app.mini_program')['secret'];
        $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
        $res= http_curl($url);
        $access_token = $res['access_token'];
        $api_url = 'https://api.weixin.qq.com/wxa/generate_urllink?access_token='.$access_token;
        $url_link = curl_post($api_url,[]);
        $this->success('ok',['url'=>$url_link['url_link']]);
    }

    /**
     * @title 获取平台文案设置
     * @desc  获取平台文案设置
     * @author  qc
     * @url /api/Expedite/getSysConfig
     * @method GET
     * @param name:search_name type:string default:-- desc:根据下面名称查（不传查全部的）
     * @return name:agreement type:string default:-- desc:用户协议
     * @return name:about_us type:string default:-- desc:关于我们
     * @return name:privacy type:string default:-- desc:隐私政策
     * @return name:user_equity type:string default:-- desc:会员权益
     * @return name:customer_service type:string default:-- desc:客服设置
     * @return name:original_pact type:string default:-- desc:原创公约
     * @return name:app_name type:string default:-- desc:平台名称
     * @return name:app_logo type:string default:-- desc:平台logo
     * @return name:app_version type:string default:-- desc:版本号
     */
    public function getSysConfig(){
        $search_name = input('get.search_name');
        $con_name = $search_name? [$search_name] : ['agreement','about_us','privacy','user_equity','customer_service','original_pact','app_version'];
        $set = Db::name('system_config')->where('name','in',$con_name)->select();
        $ret = [];
        foreach ($set as $value) {
            $ret[$value['name']]=$value['value'];
        }
        $this->success('获取成功',$ret);
    }


    /**
     * @title 修改版本号
     * @desc 修改版本号
     * @author qc
     * @method POST
     * @url /api/Expedite/changeVersion
     * @header name:Authorization require:1 desc:Token
     * @param  name:app_version type:string default:1 desc:版本号
     */
    public function changeVersion()
    {
        Db::name('system_config')->where('name','app_version')->update(['value'=>input('app_version')]);
        $this->success('修改成功');
    }
    /**
     * @title 获取客服设置【平台的】
     * @desc  获取客服设置【平台的】
     * @author  qc
     * @url /api/Expedite/getServiceSet
     * @method GET
     * @return name:service_qr_code type:string default:-- desc:客服二维码
     * @return name:service_phone type:string default:-- desc:客服电话
     * @return name:service_email type:string default:-- desc:客服邮箱
     */
    public function getServiceSet(){
        $con_name =  ['service_qr_code','service_phone','service_email'];
        $set = Db::name('system_config')->where('name','in',$con_name)->select();
        $ret = [];
        foreach ($set as $value) {
            $ret[$value['name']]=$value['value'];
        }
        $this->success('获取成功',$ret);
    }


    /**
     * @title 获取联系客服设置【模块的】[所有模块的联系我们都用这个接口]
     * @desc  获取联系客服设置
     * @author  qc
     * @url /api/Expedite/getContact
     * @method GET
     * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商,recruit=>招聘,mall=>商城】
     * @return name:qrcode type:string default:-- desc:客服二维码
     * @return name:phone type:string default:-- desc:客服电话
     * @return name:email type:string default:-- desc:客服邮箱
     * @return name:place type:string default:-- desc:归属模块
     * @return name:tag type:string default:-- desc:归属标识【可以按照这个值查询或是区分所属模块】
     */
    public function getContact()
    {
        $tag = input('get.tag');
        $sel_tag = $tag ? [$tag] : ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall'];
        $list = Db::name('contact')->where('tag','in',$sel_tag)->column('tag,qrcode,phone,email,tag,place','tag');
        $this->success('ok',$list);
    }


    /**
     * @title 获取模块封面
     * @desc  获取模块封面
     * @author  qc
     * @url /api/Expedite/getModulesCover
     * @method GET
     * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商,recruit=>招聘,mall=>商城】
     * @return name:cover type:string default:-- desc:封面
     * @return name:place type:string default:-- desc:归属模块
     * @return name:tag type:string default:-- desc:归属标识【可以按照这个值查询或是区分所属模块】
     */
    public function getModulesCover()
    {
        $tag = input('get.tag');
        $sel_tag = $tag ? [$tag] : ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall'];
        $list = Db::name('cover')->where('tag','in',$sel_tag)->column('tag,cover,tag,place','tag');
        $this->success('ok',$list);
    }


    /**
     * @title 推送测试
     * @desc  推送测试
     * @author  qc
     * @url /api/Expedite/messagePush
     * @method GET
     * @param name:user_id type:int default:-- desc:会员id
     * @param name:content type:string default:-- desc:推送内容
     * @param name:module type:string default:-- desc:模块
     * @param name:type type:类型 default:-- desc:推送类型
     * @param name:rel_id type:类型 default:-- desc:关联id
     */
    public function messagePush()
    {
        $user_id= input('user_id');
        $content= input('content');
        $module= input('module');
        $type= input('type');
        $rel_id= input('rel_id');
        $res  = Jpush($user_id,$content,$module,$type,$rel_id);
        $this->success('',['result'=>$res]);

    }


    /**
     * @title 获取分享地址
     * @desc  获取分享地址
     * @author  qc
     * @url /api/Expedite/getShareUrl
     * @method GET
     * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城商品】
     * @param name:first_id type:int default:-- desc:【视频系列id,图文系列id,资料系列id,活动id,需求id,问答id,新闻id,供应商商品id,招聘记录id,商城商品id】
     * @param name:second_id type:string default:-- desc:【视频url_id,图文item_id,资料item_id,其他类型的不传】
     * @return name:url type:string default:-- desc:跳转地址
     */
    public function getShareUrl()
    {
        $tag = input('get.tag');
        if(!in_array($tag, ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall'])) $this->error('类型标识错误');
        $first_id = input('get.first_id');
        $second_id = input('get.second_id');
        $url_arr= [
            'video'     =>$this->request->root(true) ."/dist/#/video-details?id=$first_id&videoArrId=$second_id",
            'article'   =>$this->request->root(true) ."/dist/#/image-text-details?id=$first_id&item_id=$second_id",
            'datum'     =>$this->request->root(true) ."/dist/#/information-details?id=$first_id&url_id=$second_id",
            'activity'  =>$this->request->root(true) ."/dist/#/activity-sign-up?activity_id=$first_id",
            'demand'    =>$this->request->root(true) ."/dist/#/demand-details?demand_id=$first_id",
            'forum'     =>$this->request->root(true) ."/dist/#/forum-question-details?forum_id=$first_id",
            'press'     =>$this->request->root(true) ."/dist/#/news-details?press_id=$first_id",
            'supplier'  =>$this->request->root(true) ."/dist/#/supplier-details?goods_id=$first_id",
            'recruit'   =>$this->request->root(true) ."/dist/#/recruit-details?recruit_id=$first_id",
            'mall'      =>$this->request->root(true) ."/dist/#/product-details?product_id=$first_id",
        ];
       $this->success('ok',['url'=>$url_arr[$tag]]);
    }

    /**
     * @title 获取极光推送类型
     * @desc  module'=>[type=>['title'=>'视频投稿','is_push'=>0,'msg'=>['视频投稿成功请等待审核']]]
     * @author  qc
     * @url /api/Expedite/getJiGuangPushType
     * @method GET
     * @return name:is_push type:string default:-- desc:模块类型下的消息是否有极光推送（1推送0不推送）
     * @return name:exp type:string default:-- desc:module'=>[type=>['title'=>'视频投稿','is_push'=>0,'msg'=>['视频投稿成功请等待审核']]]
     *
     */
    public function getJiGuangPushType()
    {
        $type_desc = [
            'video'=>[
                3=>['title'=>'视频评论回复【回复我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
                4=>['title'=>'视频评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的视频']],
            ],// 视频
            'article'=>[
                3=>['title'=>'图文评论回复【回复我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
                4=>['title'=>'图文评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的图文']],
            ],//图文

            'forum'=>[
                3=>['title'=>'回复的评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
                4=>['title'=>'评论的回复【回复我的】','is_push'=>1,'msg'=>['有会员回复了您的评论']],
                5=>['title'=>'问答回复【回答我的】','is_push'=>1,'msg'=>['有会员回复了您的问题']],
            ],// 问答
            'press'=>[
                1=>['title'=>'评论回复【回复我的】','is_push'=>1,'msg'=>['有会员回复了您的评论']],
            ],// 新闻
            'feedback'=>[
                1=>['title'=>'反馈内容回复','is_push'=>1,'msg'=>['平台回复了您的反馈']],
            ],// 反馈
        ];
        $this->success('ok',$type_desc);
    }


    /**
     * @title 获取模块总角标数量
     * @desc 获取模块总角标数量
     * @author qc
     * @method GET
     * @url /api/Expedite/getTotalMarkNum
     * @header name:Authorization require:1 desc:Token
     * @return name:video_num type:int default:-- desc:视频
     * @return name:article_num type:int default:-- desc:图文
     * @return name:press_num type:int default:-- desc:新闻
     * @return name:demand_num type:int default:-- desc:需求
     * @return name:forum_num type:int default:-- desc:问答
     * @return name:sys_num type:int default:-- desc:系统消息
     * @return name:total_num type:int default:-- desc:总计
     */
    public function getTotalMarkNum()
    {
        $video_all_comment = VideoComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $video_reply_num =  VideoComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$video_all_comment)]])->alias('t')->count();
        // 评论我的
        $video_comment_num = VideoComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('VideoUrl i','t.url_id = i.id')
            ->alias('t')->count();
        $video_num = $video_reply_num + $video_comment_num;

        // 回复我的
        $article_all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $article_reply_num =  ArticleComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$article_all_comment)]])->alias('t')->count();
        // 评论我的
        $article_comment_num = ArticleComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('ArticleItem i','t.item_id = i.id')
            ->alias('t')->count();
        $article_num = $article_reply_num + $article_comment_num;


        // 回复我的
        $press_all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $press_reply_num =  PressComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$press_all_comment)]])->alias('t')->count();
        // 评论我的
        $press_comment_num = PressComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('Press i','t.first_id = i.id')
            ->alias('t')->count();
        $press_num = $press_reply_num + $press_comment_num;


        $demand_num = DemandComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('PlatformDemand i','t.first_id = i.id')
            ->alias('t')->count();


        //回答我的
        $answer_num = ForumReply::where([['r.issue_user','=',$this->user_id],['r.is_deleted','=',0],['r.is_read','=',0]])
            ->alias('r')->leftJoin('user_forum f','r.forum_id = f.id')->count();
        // 回复我的
        $forum_all_comment = ForumReplyComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $forum_reply_num =  ForumReplyComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['t.is_read','=',0],['t.pid','in',implode(',',$forum_all_comment)]])->alias('t')->count();
        // 评论我的
        $forum_comment_num = ForumReplyComment::alias('c')
            ->where(['r.user_id'=>$this->user_id,'r.is_deleted'=>0,'c.is_read'=>0])
            ->leftJoin('forum_reply r','c.reply_id = r.id')
            ->count();
        $forum_num = $answer_num+$forum_reply_num+$forum_comment_num;

        $sys_num =  UserMessage::where(['user_id'=>$this->user_id])->where('is_read',0)->count();

        $total_num = $video_num + $article_num + $press_num + $demand_num + $forum_num + $sys_num;
        $this->success('ok',compact(['video_num','article_num','press_num','demand_num','forum_num','sys_num','total_num']));
    }



}