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\ArticleCommentLike;
use app\common\model\ArticleIntro;
use app\common\model\ArticleItem;
use app\common\model\ArticleLike;
use app\common\model\DatumComment;
use app\common\model\DatumCommentLike;
use app\common\model\DatumLike;
use app\common\model\DatumUrl;
use app\common\model\DemandComment;
use app\common\model\ForumReply;
use app\common\model\ForumReplyComment;
use app\common\model\GoodsOrder;
use app\common\model\PlatformDemand;
use app\common\model\PlatformLike;
use app\common\model\PressComment;
use app\common\model\RecruitResume;
use app\common\model\ShoppingTrolley;
use app\common\model\StoreBanner;
use app\common\model\StoreGoods;
use app\common\model\StoreGoodsItem;
use app\common\model\SupplierComment;
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\UserLevelRank;
use app\common\model\UserMessage;
use app\common\model\UserSearch;
use app\common\model\VideoCommentLike;
use app\common\model\VideoUrl;
use app\common\service\CheckPower;
use app\common\service\Elastic;
use app\common\service\UserSynth;
use Dm\Request\V20151123 as Dm;
use library\tools\Data;
use think\cache\driver\Redis;
use think\Db;
use app\common\model\VideoComment;
/**
 * @title 其他接口（不需要登录状态）【多模块共用】
 * @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:num type:int  default:5 desc:查询数量
     * @param  name:is_pc type:int  default:0 desc:是否是pc端用（0否1是）
     * @return name:cover type:string default:-- desc:图片路径
     * @return name:place type:string default:-- desc:跳转模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城，service=>客服】
     * @return name:first_id type:int default:-- desc:详情id(视频、图文、资料为系列id)
     * @return name:second_id type:second_id default:-- desc:系列某详情id(视频、图文、资料)
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getBanner()
    {
        $num = input('get.num',100);
        $is_pc = input('get.is_pc',0);
        $list = StoreBanner::field('id,cover,place,first_id,second_id')
            ->where(['is_deleted'=>0,'is_pc'=>$is_pc])
            ->limit(0,$num)
            ->order('sort desc ,id desc')->select()->toArray();
        foreach ($list as &$v){
            $v['is_normal'] = CheckPower::checkModulesPower($v['first_id'],$v['second_id'],$v['place']);
        }
        $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:价格
     * @return name:price.renew type:int default:-- desc:续费价格
     * @return name:is_renew type:int default:-- desc:是否是续费会员【1是0否】
     */
    public function getUserLevelSet()
    {
        $list = UserLevel::field('id,logo,name,price')->where("price is not null and price != ''")->where('id',1)->select()->toArray();
        foreach ($list as &$v) {
            $v['price_arr']  = json_decode($v['price'],true);
        }
        $is_renew = \app\common\model\LevelOrder::where('user_id',$this->user_id)->where('status',1)->where('pay_state',1)->count();
        $this->success('ok',['list'=>$list,'is_renew'=>$is_renew ? 1:0]);
    }

    /**
     * @title 会员等级开关【IOS用】
     * @desc  会员等级开关
     * @author  qc
     * @url /api/Expedite/levelSwitch
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:value type:int default:-- desc:0关闭1开启
     */
    public function levelSwitch(){
        $this->success('ok',['value'=>sysconf('level_switch')]);
    }

    /**
     * @title 注销开关
     * @desc  注销开关
     * @author  qc
     * @url /api/Expedite/logoutSwitch
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:value type:int default:-- desc:0关闭1开启
     */
    public function logoutSwitch(){
        $this->success('ok',['value'=>sysconf('logout_switch')]);
    }

    /**
     * @title 获取热搜列表
     * @desc  获取热搜列表
     * @author  qc
     * @url /api/Expedite/getTopSearch
     * @method GET
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数量
     * @param name:module type:string default:-- desc:模块,不传查全部的[video=>视频，article=>图文，datum=>资料，goods=>商城商品，press=>新闻，supplier_goods=>供应商商品，demand=>需求，recruit=>招聘，forum=>问答,activity=>活动]
     * @return name:title type:string default:-- desc:标题
     * @return name:hot_num type:int default:-- desc:热搜量
     * @return name:rel_id type:int default:-- desc:相关详情id【不是系列id】
     * @return name:series_id type:int default:-- desc:系列id【图文、视频、资料用】
     * @return name:module type:string default:-- desc:[video=>视频，article=>图文，datum=>资料，goods=>商城商品，press=>新闻，supplier_goods=>供应商商品，demand=>需求，recruit=>招聘，forum=>问答,activity=>活动]
     */
    public function getTopSearch()
    {
        $module = input('module');
        $data = input();
        if(isset($data['module'])){
            $most_num = 30;
        }else{
            $most_num = 60;
        }
        if(!isset($data['page_num'])){
            $data['page_num'] = 20;
        }
        if(!isset($data['page'])){
            $data['page'] = 1;
        }
        $total_num = (int)$data['page_num'] * (int)$data['page'];
//        return $total_num.'-'.$most_num;
        $page_num = $this->page_num;
        if($total_num > $most_num){
            $t_num = $total_num - $most_num;
            $l_num = $data['page_num'] - $t_num;
            //$this->page_num = $l_num;
            $page_num = $l_num;
            //$this->off_set = $l_num;
//            return $l_num;
        }
        $sel = [];
        $sel['is_deleted'] = 0;
        $sel['status'] = 1;
        if($module)   $sel['module'] =$module;

        if($page_num <= 0){
            $list = [];
        }else{
//            if(){
//$video_list = VideoUrl::field('a.id url_id,a.create_at,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('release_time','< time',date('Y-m-d H:i:s'))->where('a.is_deleted',0)
//            ->where('b.status',1)->where('b.is_deleted',0)->limit($this->off_set,$this->page_num)->order($order)
//            ->select()->toArray();
//            }
            $list = TopSearch::field('id,title,rel_id,module,hot_num,series_id')
                ->where($sel)
                ->order('hot_num desc')
                ->limit($this->off_set,$page_num)
                ->select()->toArray();
        }
        $total_num =TopSearch::where($sel)->count();
        if($total_num > $most_num){
            $total_num = $most_num;
        }
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @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一年
     * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序  *
     * @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:video_list.create_at 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.desc type:int default:-- desc:简介【文本】
     * @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:article_list.create_at 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');
        $sort_type = input('get.sort_type');
        $app_name = sysconf('app_name');
        $app_logo = sysconf('app_logo');
        $user_id  = $this->user_id;
        switch ($sort_type) {
            case 1:
                $order =  ['a.sort'=>'desc','a.id'=>'asc'];
                break;
            case 2:
                $order =  ['a.id'=>'asc','a.sort'=>'desc'];
                break;
            case 3:
                $order =  ['a.id'=>'desc','a.sort'=>'desc'];
                break;
        }
        if($this->user_id && $search_name) UserSearch::saveSearchTitle($this->user_id,$search_name,0);
        // 视频
        $video_list = VideoUrl::field('a.id url_id,a.create_at,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('release_time','< time',date('Y-m-d H:i:s'))->where('a.is_deleted',0)
            ->where('b.status',1)->where('b.is_deleted',0)->limit($this->off_set,$this->page_num)->order($order)
            ->select()->toArray();
        array_walk($video_list,function (&$v,$k)use ($app_name,$app_logo){
            $v['label_name'] = $v['label']  ? explode(',',trim($v['label'],',')) : null;
            $video_auth = VideoUrl::getVideoAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $video_auth['app_name'];
            $v['app_logo'] = $video_auth['app_logo'];
        });
        $video_num = VideoUrl::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')));
        })->alias('a')->leftJoin('video_intro b','b.id = a.video_id')->where('release_time','< time',date('Y-m-d H:i:s'))
            ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0)->count();


        // 图文
        $article_list = ArticleItem::field('a.id item_id,a.user_id,a.create_at,a.article_id,a.cover,a.title,a.is_vip,a.images,a.read_num,a.desc')->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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        array_walk($article_list,function (&$v,$k)use ($app_name,$app_logo){
            $article_auth = VideoUrl::getVideoAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $article_auth['app_name'];
            $v['app_logo'] = $article_auth['app_logo'];
        });
        $article_num = ArticleItem::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')->alias('a')   ->where('release_time','< time',date('Y-m-d H:i:s'))
            ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0)->count();

        // 资料
        $datum_list = DatumUrl::field('a.id,a.url,a.datum_id,a.title,a.is_vip,a.create_at')->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('release_time','< time',date('Y-m-d H:i:s'))
            ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0) ->order($order)
            ->limit($this->off_set,$this->page_num)->select()->toArray();
        $datum_num  =  DatumUrl::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('release_time','< time',date('Y-m-d H:i:s'))->where('b.is_deleted',0)->count();

        //新闻
        $press_list = \app\common\model\Press::field('id,title,cover,images,read_num')->alias('a')
            ->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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
            ->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;
        });
        $press_num = \app\common\model\Press::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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->count();


        //招聘
        $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')
            ->alias('a')->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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
            ->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 : '';
            }
        });
        $recruit_num =  \app\common\model\Recruit::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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->count();

        // 商品
        $goods_list = StoreGoods::field('id,name,cover,low_price')->alias('a')->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)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
        $goods_num =StoreGoods::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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
        // 供应商
        $supplier_goods_list =SupplierGoods::field('a.id,a.supplier_id,a.name,a.read_num,a.label,a.cover,s.title supplier_name,a.create_at')
            ->alias('a')->when($search_name,function ($query)use($search_name,$search_time){
                if($search_name) $query->where('a.name','like','%'.$search_name.'%');
                if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
            })->leftJoin('Supplier s','a.supplier_id = s.id')->where('a.status','=',1)->where('a.is_deleted','=',0)->where('s.status','=',1)->where('s.is_deleted','=',0)
            ->where('release_time','< time',date('Y-m-d H:i:s'))->limit($this->off_set,$this->page_num) ->order($order)->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'],'|'));
        });
        $supplier_goods_num = SupplierGoods::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')));
            })->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->where('g.status','=',1)   ->where('g.release_time','< time',date('Y-m-d H:i:s'))
            ->where('g.is_deleted','=',0)->where('s.status','=',1)->where('s.is_deleted','=',0)->count();
        // 需求
        $demand_list = PlatformDemand::field('id,cover,money,user_id,label,title,cover,is_over,content,company,company_logo,a.create_at')->alias('a')
            ->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)   ->where('release_time','< time',date('Y-m-d H:i:s'))
            ->limit($this->off_set,$this->page_num)->order($order)->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'],'|'));
        });
        $demand_num = PlatformDemand::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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->count();

        // 问答
        $forum_list = UserForum::field('a.id,a.title,a.content,a.label,a.level,a.browse_num,a.sort,a.create_at,u.name,u.headimg, IFNULL( (SELECT count(DISTINCT r.user_id) FROM dd_forum_reply as r WHERE a.id=r.forum_id),0 ) as reply_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('store_member u','u.id = a.user_id') ->where('release_time','< time',date('Y-m-d H:i:s'))
            ->where('a.status',1)->where('a.is_deleted',0)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
        $forum_num = UserForum::field('a.id')->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('store_member u','u.id = a.user_id')
            ->where('a.status',1)   ->where('release_time','< time',date('Y-m-d H:i:s'))
            ->where('a.is_deleted',0)->count();
        // 活动
        $activity_list = \app\common\model\Activity::field('id,cover,title,address,label,start_time,end_time,ladder,price,a.create_at')->alias('a')
            ->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)->order($order)->limit($this->off_set,$this->page_num)   ->where('release_time','< time',date('Y-m-d H:i:s'))->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;
        });
        $activity_num = \app\common\model\Activity::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)   ->where('release_time','< time',date('Y-m-d H:i:s'))->count();

        if(!$type) {
            $total_count = $video_num+$article_num+$datum_num+$demand_num+$press_num+$goods_num+$supplier_goods_num + $activity_num + $forum_num+$recruit_num;
        }else{
            $total_count = compact($type.'_num')[$type.'_num'];
        }
        $this->success('ok',$type ? compact([$type.'_list','total_count']): compact(['video_list','article_list','datum_list','goods_list','press_list','supplier_goods_list','demand_list','recruit_list','forum_list','activity_list','total_count']));
    }





    /**
     * @title 发送短信验证码
     * @desc 发送短信验证码
     * @author qc
     * @url /api/Expedite/sendSms
     * @method POST
     * @tag 短信验证码
     * @param name:phone type:int require:1 default:-- desc:要获取验证码的手机号
     * @param name:phone_pre type:int require:1 default:86 desc:手机号前缀
     * @return name:code type:string default:-- desc:验证码
     */
    public function sendSms(){
        $phone_pre = input('post.phone_pre',86);
        $phone = input('post.phone');
        $user_info  = User::where('phone',$phone)
            ->where('phone_pre',$phone_pre)
            ->where('is_deleted',0)
            ->field('id,status,is_deleted')->find();
        if($user_info && (!$user_info->status  || $user_info->is_deleted))$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_pre == '86' ?  $phone :$phone_pre.$phone,
                        'SignName' => "搞一下汽车电子",
                        'TemplateCode' => $phone_pre == '86' ? "SMS_234397351" :'SMS_269485496',
                        'TemplateParam' => json_encode(array("code"=>$code)),
                    ],
                ])->request();
            $result = $result->toArray();
            if($result['Code'] != "OK") $this->exception('发送失败');
            $sms_data = [
                'phone'=>$phone,
                'code'=>$code,
                'phone_pre'=>$phone_pre,
                'result'=>$result['Message']
            ];
            Db::name('store_member_sms')->insert($sms_data);
        } catch (ClientException $e) {
            $this->error($e->getErrorMessage().PHP_EOL);
        } catch (ServerException $e) {
            $this->error($e->getErrorMessage().PHP_EOL);
        }catch (\Exception $e){
            $this->error($e->getMessage());
        }
        $this->success('发送成功');

    }


    /**
     * @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("验证码");
        $img= "http://gaoyixia.hdlkeji.com/code/33.png";
        $img ="<img src='$img'/>";
        $html_body = '您的验证码'.$code.'有效时间5分钟';
        $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('发送成功');
        } 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);
        //var_dump($res2);
        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
     * @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
     * @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:版本号
     * @param  name:version_name type:string default:-- desc:版本名
     * @param  name:version_title type:string default:-- desc:更新标题
     * @param  name:version_content type:string default:-- desc:更新内容
     * @param  name:version_url type:string default:-- desc:下载地址
     * @param  name:version_compel type:string default:-- desc:是否强制更新
     */
    public function changeVersion()
    {
        if(input('app_version'))Data::save('system_config',['value'=>input('app_version'),'name'=>'app_version'],'name',['name'=>'app_version']);
        if(input('version_name')) Data::save('system_config',['value'=>input('version_name'),'name'=>'version_name'],'name',['name'=>'version_name']);
        if(input('version_title')) Data::save('system_config',['value'=>input('version_title'),'name'=>'version_title'],'name',['name'=>'version_title']);
        if(input('version_content')) Data::save('system_config',['value'=>input('version_content'),'name'=>'version_content'],'name',['name'=>'version_content']);
        if(input('version_url')) Data::save('system_config',['value'=>input('version_url'),'name'=>'version_url'],'name',['name'=>'version_url']);
         Data::save('system_config',['value'=>input('version_compel'),'name'=>'version_compel'],'name',['name'=>'version_compel']);
        $this->success('修改成功');
    }


    /**
     * @title 获取版本信息【安卓】
     * @desc 获取版本信息
     * @author qc
     * @method GET
     * @url /api/Expedite/getVersionInfo
     * @header name:Authorization require:1 desc:Token
     * @return name:app_version type:string default:1 desc:版本号
     * @return name:version_name type:string default:-- desc:版本名
     * @return name:version_title type:string default:-- desc:更新标题
     * @return name:version_content type:string default:-- desc:更新内容
     * @return name:version_url type:string default:-- desc:下载地址
     * @return name:version_compel type:string default:-- desc:是否强制更新
     */
    public function getVersionInfo()
    {
        $version_sel =  ['app_version','version_name','version_title','version_content','version_url','version_compel'];
        $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
        $ret = [];
        foreach ($version_sel as $v) {
             $ret[$v] = isset($set[$v]) ? $set[$v] :null;
             if($v == 'app_version') $ret[$v] = intval($set[$v]);
        }
        $this->success('获取成功',$ret);
    }


    /**
     * @title 修改版本信息【IOS】
     * @desc 修改版本信息
     * @author qc
     * @method POST
     * @url /api/Expedite/changeIosVersion
     * @header name:Authorization require:1 desc:Token
     * @param name:app_version_ios type:string default:1 desc:版本号
     * @param name:version_name_ios type:string default:-- desc:版本名
     * @param name:version_compel_ios type:string default:-- desc:是否强制更新
     */
    public function changeIosVersion()
    {
        if(input('app_version_ios'))Data::save('system_config',['value'=>input('app_version_ios'),'name'=>'app_version_ios'],'name',['name'=>'app_version_ios']);
        if(input('version_name_ios')) Data::save('system_config',['value'=>input('version_name_ios'),'name'=>'version_name_ios'],'name',['name'=>'version_name_ios']);
        Data::save('system_config',['value'=>input('version_compel_ios'),'name'=>'version_compel_ios'],'name',['name'=>'version_compel_ios']);
        $this->success('修改成功');
    }


    /**
     * @title 获取版本信息【IOS】
     * @desc 获取版本信息
     * @author qc
     * @method GET
     * @url /api/Expedite/getIosVersionInfo
     * @header name:Authorization require:1 desc:Token
     * @return name:app_version_ios type:string default:1 desc:版本号
     * @return name:version_name_ios type:string default:-- desc:版本名
     * @return name:version_compel_ios type:string default:-- desc:是否强制更新
     */
    public function getIosVersionInfo()
    {
        $version_sel =  ['app_version_ios','version_name_ios','version_compel_ios'];
        $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
        $ret = [];
        foreach ($version_sel as $v) {
            $ret[$v] = isset($set[$v]) ? $set[$v] :null;
           // if($v == 'app_version_ios') $ret[$v] = intval($set[$v]);
        }
        $this->success('获取成功',$ret);
    }


    /**
     * @title 获取APP启动页信息
     * @desc 获取APP启动页信息
     * @author qc
     * @method GET
     * @url /api/Expedite/getAppBootConfig
     * @header name:Authorization require:1 desc:Token
     * @return name:app_image type:string default:1 desc:启动图
     * @return name:app_place type:string default:-- desc:跳转模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城】
     * @return name:first_id type:int default:-- desc:详情id(视频、图文、资料为系列id)
     * @return name:second_id type:second_id default:-- desc:系列某详情id(视频、图文、资料)
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getAppBootConfig()
    {
        $version_sel =  ['app_image','app_place','first_id','second_id'];
        $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
        $ret = [];
        foreach ($version_sel as $v) {
            $ret[$v] = isset($set[$v]) ? $set[$v] :null;
            $set[$v] = $ret[$v];
        }
        $ret['is_normal'] =  CheckPower::checkModulesPower($set['first_id'],$set['second_id'],$set['app_place']);
        $this->success('获取成功',$ret);
    }




    /**
     * @title IOS获取链接
     * @desc GET方式获取POST修改
     * @author qc
     * @method GET||POST
     * @url /api/Expedite/iosUrl
     * @header name:Authorization require:1 desc:Token
     * @param  name:ios_url type:string default:-- desc:链接地址
     * @return name:ios_url type:string default:-- desc:链接地址
     */
    public function iosUrl()
    {
        if($this->request->isPost())  Data::save('system_config',['value'=>input('ios_url'),'name'=>'ios_url'],'name',['name'=>'ios_url']);
        $url = Db::name('system_config')->where('name','ios_url')->value('value');
        $this->success('获取成功',['ios_url'=>$url ? $url :'']);
    }


    /**
     * @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=>商城,'search'=>热搜】
     * @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','search'];
        $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  = UserMessage::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?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:datum_num type:int default:-- desc:资料
     * @return name:supplier_num type:int default:-- desc:供应商
     * @return name:activity_num type:int default:-- desc:活动
     * @return name:mark_num type:int default:-- desc:商品
     * @return name:recruit_num type:int default:-- desc:招聘
     * @return name:total_num type:int default:-- desc:总计
     */
    public function getTotalMarkNum()
    {
        if(!$this->user_id)   $this->success('ok',['video_num'=>0,'article_num'=>0,'press_num'=>0,'demand_num'=>0,'forum_num'=>0,'sys_num'=>0,'datum_num'=>0,'total_num'=>0]);
        $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.to_deleted','=',0],['t.user_id','<>',$this->user_id],['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],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','=',0]])
            ->leftJoin('VideoUrl i','t.url_id = i.id')
            ->alias('t')->count();
        // 追更
        $video_follow_num = UserMessage::getUnreadNum($this->user_id,'video',5);
        // 点赞我的
        $all_video = VideoUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
        $video_praise_num = 0;//VideoCommentLike::where([['type','=',2],['is_read','=',0],['like_id','in',$all_video]])->count();
        $comment_praise_num = 0 ;// VideoCommentLike::where([['type','=',1],['is_read','=',0],['like_id','in',$video_all_comment]])->count();
        $video_num = $video_reply_num + $video_comment_num + $video_follow_num + $video_praise_num + $comment_praise_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.to_deleted','=',0],['t.user_id','<>',$this->user_id],['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],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','=',0]])
            ->leftJoin('ArticleItem i','t.item_id = i.id')
            ->alias('t')->count();
        // 追更
        $article_follow_num = UserMessage::getUnreadNum($this->user_id,'article',5);
        // 点赞我的
        $all_article = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
        $article_praise_num =  0;//ArticleCommentLike::where([['is_read','=',0],['like_id','in',$all_article]])->count();
        $comment_praise_num = 0;//ArticleLike::where([['is_read','=',0],['item_id','in',$article_all_comment]])->count();
        $article_num = $article_reply_num + $article_comment_num + $article_follow_num + $article_praise_num + $comment_praise_num;


        // 评论我的
        $datum_comment_num = DatumComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','=',0]])
            ->leftJoin('DatumUrl i','t.url_id = i.id')
            ->alias('t')->count();
        // 回复我的
        $datum_all_comment = DatumComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $datum_reply_num =  DatumComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.lev','>=',2],['t.is_read','=',0],['t.pid','in',implode(',',$datum_all_comment)]])->alias('t')->count();
        // 点赞我的
        $all_datum = DatumUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
        $datum_praise_num = DatumCommentLike::where([['is_read','=',0],['like_id','in',$all_datum]])->count();
        $comment_praise_num = DatumLike::where([['is_read','=',0],['url_id','in',$datum_all_comment]])->count();
        $follow_num = UserMessage::getUnreadNum($this->user_id,'datum',5);
        $datum_num =$datum_comment_num + $datum_reply_num +$datum_praise_num + $comment_praise_num +$follow_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],['t.user_id','<>',$this->user_id],['is_read','=',0],['t.pid','in',implode(',',$press_all_comment)]])->alias('t')->count();
        // 评论我的
        $press_comment_num = PressComment::where([['t.is_deleted','=',0],['t.pid','=',0],['i.user_id','=',$this->user_id],['t.is_read','=',0],['t.user_id','<>',$this->user_id]])
            ->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],['t.is_read','=',0],['t.user_id','<>',$this->user_id],['t.pid','=',0]])
            ->leftJoin('PlatformDemand i','t.first_id = i.id')
            ->alias('t')->count();
        $all_comment = DemandComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $reply_num =  DemandComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
        $demand_num = $demand_num + $reply_num;

        //回答我的
        $answer_num = ForumReply::where([['r.issue_user','=',$this->user_id],['r.is_deleted','=',0],['r.is_read','=',0]])
            ->alias('r')->leftJoin('user_forum a','r.forum_id = a.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.user_id', '<>', $this->user_id],['t.is_read','=',0],['t.pid','in',implode(',',$forum_all_comment)]])->alias('t')->count();


        // 评论我的问题
        $forum_comment =  ForumReplyComment::alias('c')
            ->where(['r.user_id' => $this->user_id, 'r.is_deleted' => 0, 'c.is_read' => 0,'c.reply_id'=>0,'c.pid'=>0,'c.to_deleted'=>0])
            ->where('c.user_id','<>',$this->user_id)
            ->leftJoin('UserForum r', 'c.forum_id = r.id')
            ->count();

        // 评论我的回答
        $reply_comment =  ForumReplyComment::alias('c')
            ->where(['r.user_id' => $this->user_id, 'r.is_deleted' => 0, 'c.is_read' => 0,'c.pid'=>0,])
            ->leftJoin('forum_reply r', 'c.reply_id = r.id')
            ->count();

        $forum_follow_num = UserMessage::getUnreadNum($this->user_id,'forum',6);
        $forum_num = $answer_num+$forum_reply_num+$forum_comment+$reply_comment+ $forum_follow_num;

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

        // 供应商
        $supplier_comment_num = SupplierComment::where([['g.user_id', '=', $this->user_id],['c.is_deleted', '=', 0],['c.to_deleted', '=', 0],['c.is_read','=',0],['c.pid','=',0]])
            ->alias('c') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')->count();
        //回复我的
        $supplier_all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $supplier_reply_num = $supplier_all_comment ?  SupplierComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','in',implode(',',$supplier_all_comment)]])->alias('t')->count() :0;
        //订阅
        $supplier_follow_num = UserMessage::getUnreadNum($this->user_id,'supplier',5);

        $supplier_num = $supplier_comment_num + $supplier_reply_num +  $supplier_follow_num;

        // 活动
        $activity_num  =  UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'is_read'=>0])->where('m.module','in','activity,apply')->alias('m')->count();
        // 商品
        $trolley_num = ShoppingTrolley::where(['user_id'=>$this->user_id])->sum('num');
        $no_pay_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>0,'cancel_state'=>0])->count();
        $no_express_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>0,'cancel_state'=>0])
            ->where('status',1)
            ->where('refund_state','in','0')
            ->count();
        $express_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>1,'cancel_state'=>0])
            ->where('refund_state','in','0,1,2')
            ->count();
//        $finish_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>2,'cancel_state'=>0])
//            ->where('refund_state','in','0,1,2')
//            ->count();
        $finish_num = 0;
        $refund_num = GoodsOrder::where(['o.user_id'=>$this->user_id,'o.is_deleted'=>0,'o.pay_state'=>1,'o.cancel_state'=>0])->alias('o')
            ->leftJoin('StoreOrderRefund r','r.order_id = o.id')
            ->where('o.refund_state','in','1,2,3')
            ->where('r.status','in','0,1,2,4')
            ->count();
        $mark_num = $trolley_num + $no_pay_num +  $no_express_num + $express_num + $finish_num + $finish_num + $refund_num;
        //招聘
        $praise_num = PlatformLike::where([['p.type', '=', 5],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('Recruit f', 'f.id = p.like_id')->count();
        $follow_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'recruit','m.type_id'=>5,'is_read'=>0])->alias('m')->count();
        $recruits = \app\common\model\Recruit::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $resume_num  = RecruitResume::where('recruit_id','in',$recruits)->where('is_deleted',0)->where('to_deleted',0)->where('is_read',0)->count();
        $recruit_num = $praise_num + $follow_num + $resume_num;


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



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


    /**
     * @title 获取平台页面链接
     * @desc  参数自定义！参数自定义！！参数自定义！！！
     * @author  qc
     * @url /api/Expedite/getPlatformUrl
     * @method GET
     * @param name:module type:string default:-- desc:模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城商品】
     * @param name:tag type:string default:-- desc:页面标识【detail=>详情,list=>列表】
     * @param name:from type:string default:-- desc:请求接口来源1:h5,2:ios,3:android
     * @return name:url type:array default:-- desc:链接
     * @return name:desc type:string default:-- desc:页面描述
     * @return name:param type:string default:-- desc:页面参数拼接
     */
    public function getPlatformUrl()
    {
        $request_param = input('get.');
        $module = input('module','activity');
        $tag = input('tag','detail');
        unset($request_param[$module]);
        unset($request_param[$tag]);
        $url = config('platform_url.'.$module)[$tag];
        $this->success('ok',['url'=>$url,'params'=>http_build_query($request_param)]);
    }


    /**
     * @title 获取手机号前缀
     * @desc 获取手机号前缀
     * @author qc
     * @method GET
     * @url /api/Expedite/getPhonePrefix
     * @header name:Authorization require:1 desc:Token
     * @return name:name type:string default:-- desc:名称
     * @return name:code type:string default:-- desc:前缀
     */
    public function getPhonePrefix()
    {
        /*$prefix = [
            ['name' => '中国大陆','code'=>'86'],
            ['name' => '中国香港','code'=>'852'],
            ['name' => '中国澳门','code'=>'853'],
            ['name' => '中国台湾','code'=>'886'],
            ['name' => '韩国','code'=>'82'],
            ['name' => '日本','code'=>'81'],
            ['name' => '美国','code'=>'1'],
            ['name' => '加拿大','code'=>'1'],
            ['name' => '新加坡','code'=>'65'],
            ['name' => '马来西亚','code'=>'62'],
            ['name' => '俄罗斯','code'=>'7'],
            ['name' => '新西兰','code'=>'64'],
            ['name' => '法国','code'=>'33'],
            ['name' => '德国','code'=>'49'],
        ];*/
        $prefix = Db::name('phone_pre')->field('name,code')->where('is_deleted',0)->select();
        $this->success('ok',$prefix);
    }


    /**
     * @title ElasticSearch【登录状态需要header需要传Authorization】
     * @desc  ElasticSearch返回参数文档:https://www.elastic.co/guide/en/elasticsearch/reference/master/search-search.html
     * @author  qc
     * @url /api/Expedite/ElasticSearch
     * @method GET
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数量
     * @param name:search type:string default:-- desc:搜索关键词
     * @param name:sort_type type:int default:1 desc:1默认2发布时间正序3发布时间倒序
     * @param name:is_over type:int default:-1 desc:-1全部0未解决1已解决2开源【需求模块用】
     * @param name:city type:string default:-- desc:城市搜索【招聘模块用】
     * @param name:module type:string default:-- desc:搜索类型(不传查全部)[video=>视频，article=>图文，datum=>资料，goods=>商城商品，press=>新闻，supplier_goods=>供应商商品，demand=>需求，recruit=>招聘，forum=>问答,activity=>活动]
     * @return name:highlight type:array default:-- desc:高亮【目前设置三个字段:title、label、desc】
     *
     * @return name:module type:string default:-- desc:模块名
     * @return name:release_time type:string default:-- desc:上架时间
     * @return name:series_id type:int default:-- desc:系列id【视频、图文、资料用】
     * @return name:id type:int default:-- desc:某个模块的详情id【不是系列id】
     * @return name:title type:string default:-- desc:标题或名称
     * @return name:label type:string default:-- desc:标签
     * @return name:label_arr type:array default:-- desc:标签【数组】
     * @return name:desc type:string default:-- desc:描述
     * @return name:desc_text type:string default:-- desc:描述文本【搜索用的，页面展示忽略】
     * @return name:content type:string default:-- desc:内容【富文本】
     * @return name:detail type:string default:-- desc:详情【富文本】
     * @return name:create_at type:string default:-- desc:时间
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     * @return name:read_num type:int default:-- desc:阅读量||播放量【若模块用不到忽略】
     * @return name:comment_num type:int default:-- desc:评论量【若模块用不到忽略】
     * @return name:like_num type:int default:-- desc:点赞量【若模块用不到忽略】
     * @return name:transmit_num type:int default:-- desc:转发量【若模块用不到忽略】
     * @return name:collect_num type:int default:-- desc:收藏量【若模块用不到忽略】
     * @return name:down_num type:int default:-- desc:下载量【若模块用不到忽略】
     * @return name:cover type:string default:-- desc:封面【单张】
     * @return name:is_vip type:int default:-- desc:是否是vip
     *
     * @return name:duration type:string default:-- desc:时长【视频模块】
     * @return name:ali_vid type:int default:-- desc:云点播ID【视频模块】
     *
     * @return name:images_arr type:array default:-- desc:图片【图文】
     * @return name:content_type type:int default:1 desc:1富文本2pdf【图文】

     * @return name:content type:string default:-- desc:内容富文本【图文】
     *
     * @return name:url type:string default:-- desc:资料路径【资料】
     * @return name:is_down type:int default:-- desc:是否允许下载【资料】
     *
     * @return name:browse_num type:string default:-- desc:浏览量【问答】
     * @return name:reply_num type:string default:-- desc:回答量【问答】
     * @return name:level type:string default:-- desc:vip等级id【问答】
     *
     * @return name:start_time type:string default:-- desc:开始时间【活动】
     * @return name:end_time type:string default:-- desc:结束时间【活动】
     *
     * @return name:is_over type:int default:-- desc:0未解决1已解决2开源【需求模块用】
     * @return name:money type:string default:-- desc:金额【需求模块用】
     *
     * @return name:company type:string default:-- desc:公司名称【招聘】
     * @return name:company_intro type:string default:-- desc:公司简介【招聘】
     * @return name:is_ss type:string default:-- desc:是否上市，1上市【招聘】
     * @return name:scale type:string default:-- desc:公司规模（人数）【招聘】
     * @return name:principal type:string default:-- desc:联系人【招聘】
     * @return name:province type:string default:-- desc:省【招聘】
     * @return name:city type:string default:-- desc:市【招聘】
     * @return name:salary type:string default:-- desc:薪资【招聘】
     * @return name:hr_headimg type:string default:-- desc:联系人头像【招聘】
     *
     *
     * @return name:item_list type:array default:-- desc:商品规格详情【商城商品】
     * @return name:min_price type:float default:-- desc:最低价格【商城商品】
     * @return name:max_price type:float default:-- desc:最高价格【商城商品】
     * @return name:sale_num type:int default:-- desc:销量【商城商品】
     *
     */
    public function elasticSearch()
    {
        $index  = input('index',config('text.es_index'));
        $search = input('search','');
        $module = input('module','');
        $is_over = intval(input('is_over',-1));
        $sort_type = input('sort_type',1);
        $city = input('city');
        //"全部",1=>'视频',2=>'资料',3=>'图文',4=>'新闻',5=>'问答',6=>'商品',7=>'活动',8=>'招聘',9=>'供应商',10=>'供应商商品',11=>'需求'
        //  video=>视频，article=>图文，datum=>资料，goods=>商城商品，press=>新闻，supplier_goods=>供应商商品，demand=>需求，recruit=>招聘，forum=>问答,activity=>活动]
        $search_type = [
            'video'=>"1",
            'datum'=>"2",
            'article'=>"3",
            'press'=>"4",
            'forum'=>"5",
            'goods'=>"6",
            'activity'=>"7",
            'recruit'=>"8",
            'supplier'=>"9",
            'supplier_goods'=>"10",
            'demand'=>"11",
        ];
        if($search && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search,isset($search_type[$module]) ?$search_type[$module] :0 );
        switch ($sort_type) {
            case 1:
                $order = $module ? [['_score'=>['order'=>'desc']],['id'=>['order'=>'desc']]] : [['_score'=>['order'=>'desc']], ['create_at'=>['order'=>'desc']]];
                break;
            case 2:
               // $order =  $module ? [['id'=>['order'=>'asc']]] : ['create_at'=>['order'=>'asc']];
                $order =  $module ?  ['create_at'=>['order'=>'asc']] : ['create_at'=>['order'=>'asc']];
                break;
            case 3:
               // $order = $module ? [['id'=>['order'=>'desc']]] :  ['create_at'=>['order'=>'desc']];
                $order =  $module ?  ['create_at'=>['order'=>'desc']] : ['create_at'=>['order'=>'desc']];
                break;
        }
        $user_level = UserLevelRank::getUserVip($this->user_id);
        $sel_level = $user_level ? $user_level : 1;
        $where = [
            'index'=>$index,
            'from' => $this->off_set,
            'size' => $this->page_num,
            'body'=>[
                'sort' => $order,
                'query'=>[
                    'bool'=>[
                        'must'=>  [
                         //   ['match' =>  ['module'=> $module]],// module = module
                            ['match' =>  ['status'=>1]], // status !=0
                            ['match' =>  ['is_deleted'=> 0]],// is_deleted !=1
                            ['range' =>  ['release_time'=> ['lte'=>time()]]],//
                           // ['range' =>  ['level'=> ['lte'=>$sel_level]]],//
                          /*  ['bool'=>[
                                'should'=> [
                                    'multi_match' => [
                                        'fields'=> ['title','label','desc','content','detail'],
                                        'query'=> $search,
                                        "fuzziness"=>"AUTO",
                                        'type'=> 'best_fields',
                                    ]],
                            ]]*/
                        ],

                    ],
                ],
                'highlight'=>[
                    "fields"=>[
                        'title'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                        'label'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                        'desc'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                        'content'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                        'detail'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                        'desc_text'=>[
                            'pre_tags'=>["<span style='color:#FF6700'>"],
                            'post_tags'=>["</span>"]
                        ],
                    ]
                ]
            ]
        ];
        if($module)             $where['body']['query']['bool']['must'][] = ['match' =>['module'=> $module]];
        if($module == 'demand' && $is_over != -1 )  $where['body']['query']['bool']['must'][] = ['match' =>['is_over'=> $is_over]];
        if($module == 'recruit' && $city )          $where['body']['query']['bool']['must'][] = ['match' =>['city'=> $city]];
        if($search) $where['body']['query']['bool']['must'][] = ['bool' =>[
            'should'=> [
                'multi_match' => [
                    'fields'=> ['title','label','desc','content','detail'],
                    'query'=> $search,
                    "fuzziness"=>"AUTO",
                    'type'=> 'best_fields',
                ]]]];
//        if($search) $where['body']['query']['bool']['must'][] = [
//            'bool' =>[
//            'should'=> [
//                'match_phrase'=>[
//                    'title' => [
//                        'query' => $search,
//                        'slop' => 1
//                    ],
//                ],
//
//            ]
//        ]
//        ];

//        return json($where);
        $list = Elastic::select($index,$where);

        $speak_list= $list['hits']['hits'];
        foreach ($list['hits']['hits'] as &$v)
        {
            $v['_source']['label_arr'] =  $v['_source']['label'] ? explode(',',$v['_source']['label']):null;
            $v['_source']['create_at'] = date("Y-m-d",$v['_source']['create_at']);
            $v['_source']['release_time'] = date("Y-m-d",$v['_source']['release_time']);
            $v['_source']['is_over'] = isset($v['_source']['is_over']) ? intval($v['_source']['is_over']) : 0;
            switch ($v['_source']['module']) {
                case "video":
                    $info = VideoUrl::field('is_vip,cover,duration,ali_vid,read_num,video_id')->where('id',$v['_source']['id'])->find()->toArray();
                    $v['_source']['series_id'] = $info['video_id'];
                    $v['_source']['cover'] = $info['cover'];
                    $v['_source']['is_vip'] = $info['is_vip'];
                    $v['_source']['duration'] = $info['duration'];
                    $v['_source']['ali_vid'] = $info['ali_vid'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $info_auth = VideoUrl::getVideoAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name'] = $info_auth['app_name'];
                    $v['_source']['app_logo'] = $info_auth['app_logo'];
                    break;
                case "article":
                   //  var_dump($v['_source']['id']);
                   // var_dump($v);
                    $info = ArticleItem::field('images,is_vip,cover,read_num,article_id,pdf,content_type')
                        ->where('id',$v['_source']['id'])->find();
                    $info = $info->toArray();
                    $v['_source']['series_id'] = $info['article_id'];
                    $v['_source']['cover'] = $info['cover'];
                    $v['_source']['is_vip'] = $info['is_vip'];
                    $v['_source']['pdf'] = $info['pdf'];
                    $v['_source']['content_type'] = $info['content_type'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $v['_source']['images_arr'] = $info['images']?explode('|',$info['images']):null;
                    $info_auth = ArticleItem::getArticleAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name'] = $info_auth['app_name'];
                    $v['_source']['app_logo'] = $info_auth['app_logo'];
                    unset($v['_source']['content']);
                    break;
                case "datum":
                    $info = DatumUrl::field('is_vip,read_num,down_num,url,is_down,datum_id')->where('id',$v['_source']['id'])->find()->toArray();
                    $v['_source']['series_id'] = $info['datum_id'];
                    $v['_source']['is_vip'] = $info['is_vip'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $v['_source']['down_num'] = numTransform($info['down_num']);
                    $v['_source']['url'] = $info['url'];
                    $v['_source']['is_down'] = $info['is_down'];
                    $info_auth = DatumUrl::getDatumAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name'] = $info_auth['app_name'];
                    $v['_source']['app_logo'] = $info_auth['app_logo'];
                    break;
                case 'forum':
                    $info_auth = UserForum::getAuthInfo($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name'] = $info_auth['app_name'];
                    $v['_source']['app_logo'] = $info_auth['app_logo'];
                    $reply_num = ForumReply::where('forum_id', $v['_source']['id'])->where('is_deleted', 0)->count();
                    $v['_source']['reply_num'] = numTransform( $reply_num);
                    $forum_info = UserForum::where('id',$v['_source']['id'])->find()->toArray();
                    $v['_source']['browse_num']  = numTransform( $forum_info['browse_num']);
                    break;
                case 'activity':
                    $auth_info = \app\common\model\Activity::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $info = \app\common\model\Activity::where('id',$v['_source']['id'])->find()->toArray();
                    $v['_source']['start_time']  = $info['start_time'];
                    $v['_source']['end_time']  = $info['end_time'];
                    $v['_source']['cover'] = $info['cover'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    break;
                case 'supplier_goods':
                    $info = SupplierGoods::where('id',$v['_source']['id'])->find()->toArray();
                    $auth_info = SupplierGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $v['_source']['cover'] = $info['cover'];
                    unset($v['_source']['content']);
                    break;
                case 'press':
                    $info = \app\common\model\Press::where('id',$v['_source']['id'])->find()->toArray();
                    $auth_info = SupplierGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $images_arr = $info['images'] ? explode('|',$info['images']) : null;
                    $v['_source']['cover'] = $images_arr ? $images_arr[0] : null;
                    unset($v['_source']['content']);
                    break;
                case 'demand':
                    $info = PlatformDemand::where('id',$v['_source']['id'])->find()->toArray();
                    $auth_info = PlatformDemand::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $v['_source']['read_num'] = numTransform($info['read_num']);
                    $images_arr = $info['images'] ? explode('|',$info['images']) : null;
                    $v['_source']['cover'] = $info['cover'];
                    $v['_source']['money'] = $info['money'];
                    unset($v['_source']['content']);
                    break;
                case 'recruit':
                    $info = \app\common\model\Recruit::where('id',$v['_source']['id'])->find()->toArray();
                    $auth_info = \app\common\model\Recruit::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $v['_source']['scale']  = $info['scale'];
                    $v['_source']['is_ss']  = $info['is_ss'];
                    $v['_source']['company']  = $info['company'];
                    $v['_source']['company_intro']  = $info['company_intro'];
                    $v['_source']['province']  = $info['province'];
                    $v['_source']['salary']  = $info['salary'];
                    $v['_source']['city']  = $info['city'];
                    $v['_source']['principal']  = $info['principal'];
                    $v['_source']['hr_headimg']  = $info['hr_headimg'];
                    unset($v['_source']['content']);
                    break;
                case 'goods':
                    $info = \app\common\model\StoreGoods::where('id',$v['_source']['id'])->find()->toArray();
                    $auth_info = \app\common\model\StoreGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
                    $v['_source']['app_name']  = $auth_info['app_name'];
                    $v['_source']['app_logo']  = $auth_info['app_logo'];
                    $v['_source']['cover'] = $info['cover'];
                    $v['_source']['sale_num'] = $info['sale_num'];
                    $v['_source']['specs'] = json_decode($info['specs'],true);
                    $v['_source']['item_list'] = StoreGoodsItem::getGoodsSpec($info['id']);
                    $v['_source']['min_price'] =  empty($v['_source']['item_list']) ? 0 : min(array_column($v['_source']['item_list'],'sell_price'));
                    $v['_source']['max_price'] = empty($v['_source']['item_list']) ? 0 :  max(array_column($v['_source']['item_list'],'sell_price'));
                    unset($v['_source']['content']);
                    break;
            }
        }
        $this->success('ok',['list'=>$list,'total_count'=>$list['hits']['total']['value'],'page_num'=>$this->page_num]);
    }


    /**
     * @title 获取DRM无法播放机型
     * @desc  获取DRM无法播放机型
     * @author  qc
     * @url /api/Expedite/getBanPhoneModel
     * @method GET
     */
    public function getBanPhoneModel()
    {
        $list = Db::name('ban_phone_model')->where('is_deleted',0)->column('name');
        $this->success('ok',$list);
    }


    /**
     * @title 获取各个模分享图片
     * @desc  获取各个模分享图片
     * @author  qc
     * @url /api/Expedite/getModuleBgImages
     * @method GET
     * @return name:activity type:string default:-- desc:活动
     * @return name:video type:string default:-- desc:视频
     * @return name:datum type:string default:-- desc:资料
     * @return name:forum type:string default:-- desc:问答
     * @return name:article type:string default:-- desc:图文
     * @return name:supplier type:string default:-- desc:供应商
     * @return name:press type:string default:-- desc:新闻
     * @return name:demand type:string default:-- desc:需求
     * @return name:recruit type:string default:-- desc:招聘
     * @return name:goods type:string default:-- desc:商品
     */
    public function getModuleBgImages()
    {
        $list = [
            'activity' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/activity.png',// 活动
            'video' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/video.png',// 视频
            'datum' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/datum.png',//资料
            'forum' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/forum.png',// 问答
            'article' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/article.png',// 图文
            'supplier' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/supplier.png',// 供应商

            'press' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/press.png',//新闻
            'demand' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/demand.png',// 需求
            'recruit' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/recruit.png',// 招聘
            'goods' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/goods.png',// 商品
        ];
        $this->success('ok',$list);
    }


}