jianxun/application/api/controller/Topicdongtai.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
use app\common\library\Keyworld;
use think\Exception;

/**
 * 圈子动态
 */
class Topicdongtai extends Api
{
    protected $noNeedLogin = ['poi','poi2'];
    protected $noNeedRight = ['*'];

    //发布动态
    public function addone(){
        $content = input('content','');
        $images = input('images','');
        $audio_file = input('audio_file','');
        $aite = input('aite','','htmlspecialchars_decode');
        $type = input('type',1);
        $audio_second = input('audio_second',0);

        if(!$content && !$images && !$audio_file){
            $this->error(__('Invalid parameters'));
        }

        if(!$this->user_auth_limit()){
            $this->error('请先完成实名认证');
        }

        //关键字替换
        $content = Keyworld::sensitive($content);

        //只保留一个
        if($type == 1){
            $audio_file = '';
            $audio_second = 0;
        }else{
            $images = '';
        }

        $data = [
            'user_id' => $this->auth->id,
            'content' => $content,
            'images' => $images,
            'audio_file' => $audio_file,
            'type'  => $type,
            'cityname'  => input('cityname',''),
            'provincename'  => input('provincename',''),
            'aite'  => $aite,
            'is_public'  => input('is_public',1),
            'audio_second'  => $audio_second,
            'longitude'  => input('longitude',0),
            'latitude'  => input('latitude',0),
            'address'  => input('address',''),
            'createtime' => time(),
            'updatetime' => time(),

            'auditstatus' => 1, //默认通过
        ];

        //如果强制审核，默认不通过
        $dongtai_audit_switch = config('site.dongtai_audit_switch');
        if($dongtai_audit_switch == 1){
            $data['auditstatus'] = 0;
        }

        Db::startTrans();
        $id = Db::name('topic_dongtai')->insertGetId($data);

        //task任务
        //发第一条动态
        $task_count = Db::name('topic_dongtai')->where('user_id',$this->auth->id)->count();
        if($task_count == 1){
            $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,16);
            if($task_rs === false){
                Db::rollback();
                $this->error('完成任务失败');
            }
        }

        //通知艾特的人
        if(!empty($aite)){
            $aite = json_decode($aite,true);
            if(!empty($aite) && is_array($aite)){
                foreach($aite as $key => $uid){
                    //系统消息
                    if(is_array($uid) && isset($uid['id'])){
                        $msg_id = \app\common\model\Message::addMessage($uid['id'],'动态通知',$this->auth->nickname.'发布动态并@了你,快去看看吧','dongtai_aite',$id);
                    }
                }
            }
        }

        Db::commit();

        $this->success('发布成功',$id);
    }

    //自己看列表
    //某用户的帖子列表
    public function my_lists(){
        $page = input('page',1);
        if($page > 1){
            $this->success('success',[]);
        }

        $uid = input('uid',$this->auth->id);
        if (empty($uid)) {
            $uid = $this->auth->id;
        }

        $where = [
            'dt.user_id'=>$uid,

        ];
        if($uid != $this->auth->id){
            $where['dt.is_public'] = 1;  //不是自己的，就只能看公开的。公开:1=公开,2=私密
            $where['dt.auditstatus'] = 1;  //不是自己的，就只能看审核通过的
        }

        $list = Db::name('topic_dongtai')->alias('dt')
            ->join('user','dt.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime')
            ->where($where)
            ->order('dt.id desc')->select();
        $list = list_domain_image($list,['images','audio_file','avatar']);

        if(!empty($list)){
            foreach($list as $key => &$val){

                $val['aite'] = json_decode($val['aite'],true);

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);

                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);

                //追加点赞
                $val['isgood'] = $this->is_good($val['id'],$this->auth->id);

                //时间
                $val['createtime_text'] = get_last_time($val['createtime']);

                //关注
                $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);

                //收藏
                $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);

                //拉黑
                $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);

                //层主评论数量
                $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();

                //话题
                $val['topic_text'] = [];
            }
        }

        $this->success('success',$list);
    }

    //动态删除
    public function delete(){

        $id = input('id',0);
        $where['id'] = $id;
        $where['user_id'] = $this->auth->id;
        Db::startTrans();
        $delRes = Db::name('topic_dongtai')->where('id',$id)->where('user_id',$this->auth->id)->delete();
        if (!$delRes) {
            Db::rollback();
            $this->error('动态删除失败');
        }
        //删除对应的评论，
        Db::name('topic_dongtai_answer')->where('dt_id',$id)->delete();
        //点赞，
        Db::name('topic_dongtai_good')->where('dt_id',$id)->delete();
        //评论点赞
        Db::name('topic_answer_good')->where('dt_id',$id)->delete();

        Db::commit();
        $this->success('删除成功');

    }



    //某个圈子里的动态列表，关注，最新，附近
    public function topic_list(){
        $where = [
            'dt.is_public' => 1,
            'dt.auditstatus' => 1,
        ];

        //最新
        $order = input('orderby','new');
        $orderby  = 'dt.toptime desc,dt.id desc';
        //关注
        $where_follow = '';
        if($order == 'follow'){
            //关注的人
            $follow_user_ids = Db::name('user_follow')->where(['uid'=>$this->auth->id])->column('follow_uid');
            if(!empty($follow_user_ids)){
                $where_follow .= '(dt.user_id IN ('.implode(',',$follow_user_ids).'))';
            }

            //默认
            if($where_follow == ''){
                $where_follow = 'dt.id = 0';
            }
        }


        //附近，根据距离排序
        $having_dis = '';
        if($order == 'near'){
//            $where['dt.provincename'] = $this->auth->provincename;
            $having_dis = 'distance < ' . 100000; //100公里范围
            $orderby  = 'dt.toptime desc,distance asc';
        }

        //性别
        $gender = input('gender','all');
        if($gender != 'all'){
            $where['user.gender'] = $gender;
        }



        //排除黑名单的
        $where_black = [];
        $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid');
        if(!empty($black_ids)){
            $where_black['dt.user_id'] = ['NOTIN',$black_ids];
        }

        //列表
        $field = 'dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime';
        if($order == 'near'){
            $field .= ',(st_distance(point (' . $this->auth->longitude . ', ' . $this->auth->latitude . '),point(dt.longitude,dt.latitude))*111195) as distance';
        }
        $list = Db::name('topic_dongtai')->alias('dt')
            ->join('user','dt.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field($field)
            ->where($where)
            ->where($where_follow)
            ->where($where_black);
        if($order == 'near'){
            $list = $list->having($having_dis);
        }
        $list = $list->order($orderby)
            ->autopage()->select();
        $list = list_domain_image($list,['images','audio_file','avatar']);

        if(!empty($list)){
            foreach($list as $key => &$val){
                //艾特
                $val['aite'] = json_decode($val['aite'],true);

                //距离
                $val['distance'] = isset($val['distance']) ? $val['distance'] : 0;
                $val['distance'] = bcdiv(intval($val['distance']),1000,1).'km';
                if($this->auth->longitude == 0 || $val['longitude'] == 0){
                    $val['distance'] = '未知';
                }
                //vip如果开了隐私保护，需要隐藏距离
                $yinsi = $this->user_power($val['user_id'],'yinsi');
                if($yinsi == 1){
                    $val['distance'] = '';
                }

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);

                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);

                //追加点赞
                $val['isgood'] = $this->is_good($val['id'],$this->auth->id);

                //时间
                $val['createtime_text'] = get_last_time($val['createtime']);

                //关注
                $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);

                //收藏
                $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);

                //拉黑
                $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);

                //层主评论数量
                $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();

                //话题
                $val['topic_text'] = [];
                //艾特了谁
//                $val['aite_user'] = Db::name('user')->where('id','IN',$val['aite'])->column('nickname');
            }
        }

        $this->success('success',$list);
    }
    //详情
    public function info(){
        $id = input('id');

        $info = Db::name('topic_dongtai')->alias('dt')
            ->join('user','dt.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime')
            ->where('dt.id',$id)->find();
        $info = info_domain_image($info,['images','audio_file','avatar']);


        if($info){

            $info['aite'] = json_decode($info['aite'],true);

            //用户年龄
            $info['age'] = birthtime_to_age($info['birthday']);
            unset($info['birthday']);

            //用户vip
            $info['is_vip'] = $info['vip_endtime'] > time() ? 1 : 0;
            unset($info['vip_endtime']);

            //是否点赞过
            $info['isgood'] = $this->is_good($id,$this->auth->id);

            //时间
            $info['createtime_text'] = get_last_time($info['createtime']);

            //关注
            $info['is_follow'] = $this->is_follow($this->auth->id,$info['user_id']);

            //收藏
            $info['is_collect'] = $this->is_collect($id,$this->auth->id);

            //拉黑
            $info['is_black'] = $this->is_black($this->auth->id,$info['user_id']);

            //层主评论数量
            $info['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1])->count();

            //话题
            $info['topic_text'] = [];
        }else{
            $this->error('此动态已被删除');
        }

        $this->success('success',$info);
    }

    //点赞，取消点赞
    public function good(){
        $id = input('id');

        $where = [
            'dt_id' => $id,
            'user_id'  => $this->auth->id,
        ];
        $check = Db::name('topic_dongtai_good')->where($where)->find();
        $dt_user_id = Db::name('topic_dongtai')->where('id',$id)->value('user_id');

        if($check){
            Db::name('topic_dongtai_good')->where($where)->delete();
            $down = Db::name('topic_dongtai')->where('id',$id)->setDec('goodnum');
            $this->success('已取消点赞');
        }else{

            Db::startTrans();
            $where['createtime'] = time();
            $rs = Db::name('topic_dongtai_good')->insertGetId($where);
            if(!$rs){
                Db::rollback();
                $this->error('点赞失败');
            }

            $up = Db::name('topic_dongtai')->where('id',$id)->setInc('goodnum');
            if($up === false){
                Db::rollback();
                $this->error('点赞失败');
            }

            //系统消息
            if($dt_user_id != $this->auth->id){
                $msg_id = \app\common\model\Message::addMessage($dt_user_id,'动态点赞',$this->auth->nickname.'('.$this->auth->username.')赞了你的动态','dongtai_good',$id);
            }

            Db::commit();
            $this->success('点赞成功');
        }
    }

    //评论
    public function answer(){
        if($this->apiLimit(1,5000) == false){
            $this->error('抱歉，您在5秒内只能进行一次回复');
        }

        $id = input('id',0);
        $content = input('content','');
        $to_user_id = input('to_user_id',0);
        $level = input('level',1);  //回复类型:1=层主回复楼主,2=层中回复
        $floor = input('floor',0);

        if(empty($content) || empty($id)){
            $this->error();
        }

        //判断
        if($level == 2 && $floor == 0){
            $this->error('楼层错误');
        }

        //黑名单判断
        //是否被动态发布者拉黑
        $dongtai_user_id = Db::name('topic_dongtai')->where('id',$id)->value('user_id');
        $black_check = $this->is_black($dongtai_user_id,$this->auth->id);
        if($black_check){
            $this->error('您已被对方拉黑，禁止评论此动态');
        }
        //是否被层主拉黑
        if($level == 2){
            $answer_info = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1,'floor'=>$floor])->find();
            $black_check = $this->is_black($answer_info['user_id'],$this->auth->id);
            if($black_check){
                $this->error('您已被对方拉黑，禁止点评此评论');
            }
        }

        //关键字替换
        $content = Keyworld::sensitive($content);

        //回复楼主，最新楼层
        if($level == 1 || $floor == 0){
            $to_user_id = 0;
            $floor = 1;  //默认一楼

            $last_floor = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1])->order('floor desc')->value('floor');
            if($last_floor){
                $floor = $last_floor + 1;
            }
        }

        //判断user_id
        if($to_user_id){
            $to_user = Db::name('user')->where('id',$to_user_id)->value('id');
            if(empty($to_user)){
                $this->error('被回复的用户不存在');
            }
        }

        //data
        $data = [
            'dt_id' => $id,
            'floor' => $floor,
            'user_id' => $this->auth->id,
            'content' => $content,
            'to_user_id' => $to_user_id,
            'level' => $level,
            'createtime' => time(),
            'updatetime' => time(),
        ];

        Db::startTrans();
        $rs = Db::name('topic_dongtai_answer')->insertGetId($data);

        Db::name('topic_dongtai')->where('id',$id)->setInc('answernum');

        //系统消息
        if($level == 1){
            //发给动态用户
            $msg_user_id = Db::name('topic_dongtai')->where('id',$id)->value('user_id');
            $msg_title = '动态评论';
            $msg_content = $this->auth->nickname.'评论了你的动态';
            $infotype_id = $rs;
        }else{
            //发给层主
            $answer_info = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1,'floor'=>$floor])->find();
            $msg_user_id = $answer_info['user_id'];
            $msg_title = '动态评论点评';
            $msg_content = $this->auth->nickname.'点评了你的动态评论';
            $infotype_id = $answer_info['id'];
        }
        $msg_id = \app\common\model\Message::addMessage($msg_user_id,$msg_title,$msg_content,'dongtai_answer',$infotype_id);

        Db::commit();
        $this->success('评论成功');
    }

    //对评论点赞
    public function answer_good(){
        $dt_id = input('dt_id',0);
        $answer_id = input('answer_id',0);

        $where = [
            'dt_id'     => $dt_id,
            'answer_id' => $answer_id,
            'user_id'   => $this->auth->id,
        ];
        $check = Db::name('topic_answer_good')->where($where)->find();

        if($check){
            Db::name('topic_answer_good')->where($where)->delete();
            Db::name('topic_dongtai_answer')->where('id',$answer_id)->setDec('goodnum');
            $this->success('已取消点赞');
        }else{

            Db::startTrans();
            $where['createtime'] = time();
            $rs = Db::name('topic_answer_good')->insertGetId($where);
            $up = Db::name('topic_dongtai_answer')->where('id',$answer_id)->setInc('goodnum');

            if($rs && $up !== false){
                Db::commit();
                $this->success('点赞成功');
            }
            Db::rollback();
            $this->error('点赞失败');
        }
    }

    //举报枚举
    /*public function report_enum(){
        $arr = [
            '侮辱谩骂',
            '色情低俗',
            '政治敏感',
            '违法违规',
            '其他',
        ];
        $this->success(1,$arr);
    }*/

    //举报
    public function report(){
        $dt_id = input('dt_id',0);
        $data['dt_id'] = $dt_id;

        $check = Db::name('topic_dongtai')->where('id',$data['dt_id'])->find();
        if(empty($check)){
            $this->error('不存在的动态');
        }

        $data['user_id']    = $this->auth->id;
        $data['to_user_id'] = $check['user_id'];
        $data['createtime'] = time();

        Db::name('topic_dongtai_report')->insertGetId($data);
        $this->success('举报成功');
    }

    //收藏,取消收藏
    public function collect(){
        $where = [
            'user_id'  => $this->auth->id,
            'table'    => 'topic_dongtai',
            'table_id' => input('id',0),
        ];
        $check = Db::name('user_collect')->where($where)->find();
        if($check){
            Db::name('user_collect')->where($where)->delete();
            $this->success('已取消收藏');
        }else{
            Db::name('user_collect')->insertGetId($where);
            $this->success('收藏成功');
        }
    }

    //我的收藏
    public function my_collect(){

        $collect_id = Db::name('user_collect')->where(['table'=>'topic_dongtai','user_id'=>$this->auth->id])->column('table_id');

        $where = ['dt.id'=>['IN',$collect_id]];

        $list = Db::name('topic_dongtai')->alias('dt')
            ->join('user','dt.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime')
            ->where($where)
            ->order('dt.id desc')->autopage()->select();
        $list = list_domain_image($list,['images','audio_file','avatar']);

        if(!empty($list)){
            foreach($list as $key => &$val){

                $val['aite'] = json_decode($val['aite'],true);

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);

                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);

                //追加点赞
                $val['isgood'] = $this->is_good($val['id'],$this->auth->id);

                //时间
                $val['createtime_text'] = get_last_time($val['createtime']);

                //关注
                $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);

                //收藏
                $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);

                //拉黑
                $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);

                //层主评论数量
                $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();

                //话题
                $val['topic_text'] = [];
            }
        }

        $this->success('success',$list);
    }


    //不感兴趣，屏蔽某条
    /*public function screen(){
        $data = [
            'user_id' => $this->auth->id,
            'dt_id'   => input('dt_id',0),
        ];
        $check = Db::name('topic_dongtai_screen')->where($data)->find();
        if($check){
            $this->success('操作成功');
        }

        Db::name('topic_dongtai_screen')->insertGetId($data);

        $this->success('操作成功');
    }*/

    //评论列表
    public function answer_list(){
        $dt_id = input('dt_id',0);
        //楼
        $floor_list = Db::name('topic_dongtai_answer')
            ->alias('a')
            ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status')
            ->join('user','a.user_id = user.id','LEFT')
            ->where(['a.dt_id'=>$dt_id,'a.level'=>1])->order('a.id desc')->autopage()->select();
        $floor_list = list_domain_image($floor_list,['avatar']);

        //追加子评论
        if(!empty($floor_list)){
            foreach($floor_list as $key => &$val){
                //下面几条子回复，字符串
                $val['childremark'] = '';

                $map = [
                    'a.dt_id' => $dt_id,
                    'a.floor' => $val['floor'],
                    'a.level' => 2,
                ];
                $number = Db::name('topic_dongtai_answer')->alias('a')->where($map)->count();
                if($number > 0){
                    $answer_info = Db::name('topic_dongtai_answer')
                        ->alias('a')
                        ->field('user.nickname')
                        ->join('user','a.user_id = user.id','LEFT')
                        ->where($map)->order('a.id desc')->find();

                    $val['childremark'] = $answer_info['nickname'].'...等人,共'.$number.'条回复';
                }

                //时间处理
                $val['createtime_text'] = get_last_time($val['createtime']);

                //回复是否已赞
                $val['is_good'] = $this->answer_is_good($val['id'],$this->auth->id);

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);
            }
        }

        $this->success(1,$floor_list);
    }

    //单独某一层的详细
    public function answer_info(){
        $answer_id = input('answer_id');

        //楼
        $floor_info = Db::name('topic_dongtai_answer')
            ->alias('a')
            ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status')
            ->join('user','a.user_id = user.id','LEFT')
            ->where(['a.id'=>$answer_id])->find();
        if(empty($floor_info)){
            $this->success(1,[]);
        }
        $floor_info = info_domain_image($floor_info,['avatar']);
        $floor_info['createtime_text'] = get_last_time($floor_info['createtime']);
        //用户年龄
        $floor_info['age'] = birthtime_to_age($floor_info['birthday']);
        unset($floor_info['birthday']);
        //回复是否已赞
        $floor_info['is_good'] = $this->answer_is_good($answer_id,$this->auth->id);
        $floor_info['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$floor_info['dt_id'],'floor'=>$floor_info['floor'],'level'=>2])->count();

        //层
        $floors = $floor_info['floor'];
        $child_lists = Db::name('topic_dongtai_answer')->alias('a')
            ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status')
            ->join('user','a.user_id = user.id','LEFT')
            ->where(['a.dt_id'=>$floor_info['dt_id'],'a.floor'=>$floors,'a.level'=>2])->order('a.id desc')->autopage()->select();
        $child_lists = list_domain_image($child_lists,['avatar','to_avatar']);
        if(!empty($child_lists)){
            foreach($child_lists as $key => &$answer){
                //用户年龄
                $answer['age'] = birthtime_to_age($answer['birthday']);
                unset($answer['birthday']);

                $answer['is_good'] = $this->answer_is_good($answer['id'],$this->auth->id);
                $answer['createtime_text'] = get_last_time($answer['createtime']);
            }
        }

        //合并
        $floor_info['child'] = $child_lists;

        $this->success('success',$floor_info);

    }


    //是否点赞
    private function is_good($dt_id,$uid){
        $where = [
            'dt_id' => $dt_id,
            'user_id'  => $uid,
        ];
        $check = Db::name('topic_dongtai_good')->where($where)->find();
        if($check){
            return 1;
        }else{
            return 0;
        }
    }
    //回复是否点赞
    private function answer_is_good($answer_id,$uid){
        $where = [
            'answer_id' => $answer_id,
            'user_id'  => $uid,
        ];
        $check = Db::name('topic_answer_good')->where($where)->find();
        if($check){
            return 1;
        }else{
            return 0;
        }
    }

    //动态是否收藏
    private function is_collect($dt_id,$uid){
        $where = [
            'user_id'  => $uid,
            'table'    => 'topic_dongtai',
            'table_id' => $dt_id,
        ];
        $check = Db::name('user_collect')->where($where)->find();
        if($check){
            return 1;
        }else{
            return 0;
        }
    }

    //用户是否拉黑
    private function is_black($uid,$black_uid){
        $where = [
            'uid'       => $uid,
            'black_uid' => $black_uid,
        ];
        $check = Db::name('user_black')->where($where)->find();
        if($check){
            return 1;
        }else{
            return 0;
        }
    }


    //我的评论
    public function my_answer(){
        $map = [
            'a.user_id' => $this->auth->id,
            'a.level'    => 1,
        ];
        $list = Db::name('topic_dongtai_answer')->alias('a')
            ->field('a.id,a.createtime,a.content,a.dt_id,
            dt.images,dt.content as dt_content,dt.type as dt_type,dtuser.nickname as dtuser_nickname,dtuser.username as dtuser_username,user.username,
            user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime')
            ->join('topic_dongtai dt','a.dt_id = dt.id','LEFT')
            ->join('user dtuser','dt.user_id = dtuser.id','LEFT')
            ->join('user user','a.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->where($map)->order('a.id desc')->autopage()->select();
        $list = list_domain_image($list,['avatar']);
        if(!empty($list)){
            foreach($list as $key => &$val){

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);

                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);

            }
        }

        $this->success(1,$list);
    }

    //删除我的某个评论
    public function delete_answer(){
        $id = input('id',0);
        if(!$id){
            $this->error();
        }

        Db::startTrans();
        $info = Db::name('topic_dongtai_answer')->where('id',$id)->where('user_id',$this->auth->id)->find();
        if(!$info){
            $this->error('不存在的动态评论');
        }

        if($info['level'] == 1){


            //楼层内都删
            $louceng_id = Db::name('topic_dongtai_answer')->where('dt_id',$info['dt_id'])->where('level',2)->where('floor',$info['floor'])->column('id');
            if(!empty($louceng_id)){
                Db::name('topic_dongtai')->where('id',$info['dt_id'])->setDec('answernum',count($louceng_id));//回复数减1
                Db::name('topic_dongtai_answer')->where('id','IN',$louceng_id)->delete();//评论删掉
                Db::name('topic_answer_good')->where('answer_id','IN',$louceng_id)->delete();//评论点赞删掉
            }

        }

        Db::name('topic_dongtai')->where('id',$info['dt_id'])->setDec('answernum');//回复数减1
        Db::name('topic_dongtai_answer')->where('id',$id)->delete();  //评论删掉
        Db::name('topic_answer_good')->where('answer_id',$id)->delete();//评论点赞删掉

        Db::commit();

        $this->success();
    }


    //我点赞的动态
    public function my_good(){


        $where = ['good.user_id'=>$this->auth->id];


        $list = Db::name('topic_dongtai')->alias('dt')
            ->join('user','dt.user_id = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->join('topic_dongtai_good good','dt.id = good.dt_id','LEFT')
            ->field('dt.*,dt.id as dt_id,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.idcard_status,uw.vip_endtime')
            ->where($where)
            ->order('dt.id desc')->autopage()->select();
        $list = list_domain_image($list,['images','audio_file','avatar']);

        if(!empty($list)){
            foreach($list as $key => &$val){
                $val['aite'] = json_decode($val['aite'],true);

                //用户年龄
                $val['age'] = birthtime_to_age($val['birthday']);
                unset($val['birthday']);

                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);

                //追加点赞
                $val['isgood'] = $this->is_good($val['id'],$this->auth->id);

                //时间
                $val['createtime_text'] = get_last_time($val['createtime']);

                //关注
                $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);

                //收藏
                $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);

                //拉黑
                $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);

                //层主评论数量
                $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();

                //话题
                $val['topic_text'] = [];
            }
        }

        $this->success('success',$list);
    }

    //维智地图，POI搜索API
    /*public function poi(){
        $access_key = 'oLv7qgwJ5E4SdxSLvKLDRzdrkgQdLYV0';

        $keyword = '人民广场';
        $city_code = '';
        $city = '临沂';
        $page = input('page',1);

        $url = 'https://api.newayz.com/location/scenario/v1/placesearch?name='.$keyword.'&access_key='.$access_key.'&city='.$city.'&page_index='.$page.'&page_size=10';

        $header = ['Content-Type: application/json'];
        $rs = curl_get($url,$header);
        dump($rs);

    }*/
    //维智地图，POI搜索API
    public function poi2(){
        $access_key = 'oLv7qgwJ5E4SdxSLvKLDRzdrkgQdLYV0';

        $longitude = input('longitude','');
        $latitude  = input('latitude','');
        $location  = $longitude.','.$latitude;

        $keyword = input('keyword','');
        $radius  = 1000;//周边半径
        $page    = input('page',1);
        $page_size = input('listrow',10);


        $url = 'https://api.newayz.com/location/scenario/v1/nearbysearch?access_key='.$access_key.'&location='.$location.'&keywords='.$keyword.'&radius='.$radius.'&page_index='.$page.'&page_size='.$page_size;

        $header = ['Content-Type: application/json'];
        $rs = curl_get($url,$header);
        $rs = json_decode($rs,true);

        $result = [];
        if(!empty($rs)){
            foreach($rs as $key => $val){

                if(!isset($val['geoPoint']) || empty($val['geoPoint'])){ continue; }
                if(!isset($val['name']) || empty($val['name'])){ continue; }
                if(!isset($val['address']['name']) || empty($val['address']['name'])){ continue; }

                $location = explode(',',$val['geoPoint']);
                if( !isset($location[0]) || !isset($location[1]) ){ continue; }

                $result[] = [
                    'longitude' => $location[0],
                    'latitude'  => $location[1],
                    'name'      => $val['name'],
                    'address'   => $val['address']['name'],
                ];
            }
        }

//        $this->success(1,$rs);
        $this->success(1,$result);

    }


}