gonghuixiangqin/application/api/controller/Forum.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;

class Forum extends Api
{
    /**
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 论坛推荐1
     */
    public function index(){
        $mid = $this->check_login();
        $page = input('page',1);
        $page_num = input('page_num',10);
        $list = Db::name('store_forum')
            ->where(array('status'=>2,'is_deleted'=>0))
            ->order('id','DESC')
            ->paginate($page_num,'',['page'=>$page]);
        $list= $list->items();
        foreach ($list as $k=>$v){
            $list[$k]['show_images'] = explode(',', $list[$k]['show_images']);
            $list[$k]['guanzhu'] = is_follow($mid,$list[$k]['m_id']);
            $list[$k]['is_give'] = is_give($mid,$list[$k]['id']);
            $list[$k]['give'] = Db::name('store_forum_give')->where('f_id',$list[$k]['id'])->count();
            $list[$k]['comment'] =  Db::name('store_forum_comment')->where('f_id',$list[$k]['id'])->count();
            $user = Db::name('store_member')->where('id',$list[$k]['m_id'])->field('nickname,sex,province_id,headimg,age')->find();
            $list[$k]['nickame'] = $user['nickname'];
            $list[$k]['headimg'] = $user['headimg'];

            $list[$k]['sex'] = $user['sex'];
            $list[$k]['city'] = areaname($user['province_id']);
            $list[$k]['age']=$user['age'];
        }
        $this->success('论坛推荐',$list);
    }

    /**
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 详情
     */
    public function forumdetails(){
        $mid = $this->check_login();
        $data = input();
        $id = $data['id'];
        $info = Db::name('store_forum')
            ->where(array('status'=>2,'is_deleted'=>0))
            ->where('id',$id)
            ->find();
        $info['show_images'] = explode(',', $info['show_images']);

        $user = Db::name('store_member')->where('id',$info['m_id'])->field('nickname,province_id,headimg,age')->find();
        $info['nickame'] = $user['nickname'];
        $info['headimg']=$user['headimg'];
        $info['age'] = $user['age'];
        $info['city'] = areaname($user['province_id']);
        $info['give'] = Db::name('store_forum_give')->alias('f')->join('store_member m','m.id=f.m_id')->join('store_area a','m.province_id=a.id')->where('f_id',$info['id'])->field('m.id,nickname,headimg,age,shortname')->select();
        foreach ($info['give'] as $k=>$v){
            $info['give'][$k]['guanzhu'] =  is_follow($mid,$info['give'][$k]['id']);
        }
        $info['comment'] = Db::name('store_forum_comment')->alias('f')->join('store_member m','m.id=f.m_id')->join('store_area a','m.province_id=a.id')->where('f_id',$info['id'])->field('m.id,nickname,headimg,age,shortname,f.comment,f.create_at')->select();
        foreach ($info['comment'] as $k1=>$v1){
            $info['comment'][$k1]['guanzhu'] =  is_follow($mid,$info['comment'][$k1]['id']);
        }
        $this->success('查看详情',$info);

    }

    /**
     * @return void
     *发布动态
     */
    public function releaseforum(){
        $mid = $this->check_login();
        $data = input();
        if(empty($data['image'])){
            $this->error('图片/视频不能为空');
        }
        $file = explode('.',$data['image']);
        $suffix = end($file);
        $data= [
            'content'=>$data['content'],
            'show_images'=>$data['image'],
            'suffix' =>$suffix,
            'm_id' =>$mid,
            'create_at'=>date('Y-m-d H:i:s'),
        ];
        Db::name('store_forum')->insert($data);
        $this->success('发布成功等待审核');
    }

    /**
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     * 动态点赞
     */
    public function forum_give(){
        $mid = $this->check_login();
        $fid = input('fid');
        $give = is_give($mid,$fid);
        if($give){
            Db::name('store_forum_give')->where(array('m_id' => $mid, 'f_id' => $fid))->delete();
            $this->success('取消点赞');

        }
        else{
            Db::name('store_forum_give')->insert(['m_id'=>$mid,'f_id'=>$fid,'create_at'=>date('Y-m-d H:i:s')]);
            $this->success('感谢你的点赞');
        }


    }

    /**
     * @return void
     * 论坛评论
     */
    public function forum_comment(){
        $mid = $this->check_login();
        $data = input();
        $insert = [
            'f_id'=>$data['fid'],
            'm_id'=>$mid,
            'comment'=>$data['comment'],
            'create_at'=>date('Y-m-d H:i:s')
        ];
        Db::name('store_forum_comment')->insert($insert);
        $this->success('评论成功');
    }



}