yuan/application/api/controller/Community.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\model\AcitivityOrder;
use app\common\model\CommunityModel;
use app\common\model\MeetingModel;
use app\common\model\MeetingOrder;
use app\common\model\OfficeModel;
use app\common\model\Park;
use app\common\model\SheActivityModel;
use think\Db;

/**
 * 社群社区
 */
class Community extends Api
{
    protected $noNeedLogin = ['acvitityLists', 'Info', 'listInfo', 'qustion', 'qustionInfo', 'buildInfo', 'protable', 'trueTime', 'chooseTime', 'GgInfo'];
    protected $noNeedRight = ['*'];


    /**
     * 发布信息
     * @ApiMethod (POST)
     * @param string $notice 简介
     * @param string $images 多图
     */
    public function add()
    {
        $data = $this->request->post();

        if (empty($data['notice']) && empty($data['images'])) return $this->error('图片和文字至少输入一类');

        $user = $this->auth->getUser();


        $data['uid'] = $user['id'];

        $data['switch'] = 1;

        $data['create_time'] = date('Y-m-d H:i:s', time());

        $communityModel = new CommunityModel();

        $save = $communityModel->allowField(true)->save($data);

        if ($save) {
            return $this->success('发布成功');
        } else {
            return $this->error('发布失败');
        }
    }

    /**
     * 社区信息列表
     */
    public function lists()
    {
        $page = $this->request->get('page');

        $limit = $this->request->get('limit');
        if (!$page) {
            $pages = '0,10';
        } else {
            $page = $page - 1;
            if ($page < 0) $page = 0;
            $pages = $page . ',' . $limit;
        }

        $user = $this->auth->getUser();

        $where = [];

        if ($user) $where['u.p_id'] = $user['p_id'];

        $communityModel = new CommunityModel();

        $data = $communityModel->alias('c')
            ->join('user u', 'c.uid=u.id', "left")
            ->where($where)
            ->limit($pages)
            ->order('create_time desc')
            ->field('c.*,u.username,u.avatar')
            ->select();

        foreach ($data as $k => $v) {

            $data[$k]['time'] = self::mdate(strtotime($v['create_time']));

            $data[$k]['zan_count'] = Db::name('community_zan')->where('c_id', $v['id'])->count();

            $data[$k]['is_zan'] = 0;

            $isZan = Db::name('community_zan')->where('c_id', $v['id'])->find();

            if ($isZan) $data[$k]['is_zan'] = 1;

            $data[$k]['coment_count'] = Db::name('community_comment')->where('c_id', $v['id'])->count();
        }

        return $this->success('', $data);
    }

    /**
     * 点赞
     *
     * @param string $id 活动id
     *
     */
    public function zan()
    {
        $id = $this->request->get('id');

        if (!$id) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $data = [
            'c_id'        => $id,
            'uid'         => $user['id'],
            'create_time' => date('Y-m-d H:i:s', time()),
        ];

        $add = Db::name('community_zan')->insert($data);

        if ($add) {
            return $this->success('成功');
        } else {
            return $this->error('失败');
        }
    }

    /**
     * 取消点赞
     *
     * @param string $id 活动id
     *
     */
    public function zanFalse()
    {
        $id = $this->request->get('id');

        if (!$id) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $where['c_id'] = $id;

        $where['uid'] = $user['id'];

        $del = Db::name('community_zan')->where($where)->delete();

        if ($del) {
            return $this->success('成功');
        } else {
            return $this->error('失败');
        }
    }

    /**
     * 详情
     *
     * @param string $id 活动id
     *
     */
    public function info()
    {
        $id = $this->request->get('id');

        if (!$id) return $this->error('参数错误');

        $communityModel = new CommunityModel();

        $data = $communityModel->alias('c')
            ->join('user u','c.uid=u.id','left')
            ->where('c.id', $id)
            ->field('c.*,u.username,u.avatar')
            ->find();

        $data['time'] = self::mdate(strtotime($data['create_time']));

        $data['zan_count'] = Db::name('community_zan')->where('c_id', $data['id'])->count();

        $data['coment_count'] = Db::name('community_comment')->where('c_id', $data['id'])->count();

        $data['is_zan'] = 0;

        $isZan = Db::name('community_zan')->where('c_id', $data['id'])->find();

        if ($isZan) $data['is_zan'] = 1;

        $data['comment'] = Db::name('community_comment c')
            ->join('user u', 'c.uid=u.id', 'left')
            ->where('c_id', $id)
            ->field('c.*,u.avatar,u.nickname,u.username')
            ->order('create_time desc')
            ->select();

        return $this->success('', $data);
    }

    /**
     * 评论
     *
     * @param string $id id
     * @param string $notice 评论内容
     *
     */
    public function comment()
    {

        $id = $this->request->get('id');

        if (!$id) return $this->error('参数错误');

        $notice = $this->request->get('notice');

        if (empty($notice)) return $this->error('评论内容不能为空');

        $user = $this->auth->getUser();

        $data = [
            'c_id'        => $id,
            'uid'         => $user['id'],
            'notice'      => $notice,
            'create_time' => date('Y-m-d H:i:s', time()),
        ];

        $add = Db::name('community_comment')->insert($data);

        if ($add) {
            return $this->success('品论成功');
        } else {
            return $this->error('评论失败');
        }
    }

    /**
     * 用户信息详情
     *
     * @param string $uid 用户id
     */
    public function userInfo()
    {
        $our = $this->auth->getUser();

        $uid = $this->request->get('uid');

        if (empty($uid)) return $this->error('参数错误');

        $user = Db::name('user')->where('id', $uid)->field('id,avatar,username,company')->find();

        $user['fensi_count'] = Db::name('follow')->where('be_uid', $user['id'])->count();

        $user['guanzhu_count'] = Db::name('follow')->where('uid', $user['id'])->count();

        $user['is_guanzhu'] = 0;

        $isGuanzhu = Db::name('follow')->where('uid', $our['id'])->where('be_uid', $user['id'])->find();

        if ($isGuanzhu) $user['is_guanzhu'] = 1;

        if (!empty($user['company'])) {

            $qiye = Db::name('user')
                ->where('company', $user['company'])
                ->where('group_id', '>',0)
                ->where('shenhe_status', 'in', '1,2,3')
                ->find();
            if ($qiye && $qiye['group_id'] == 1) {
                $company = Db::name('user_shangjia')->where('uid',$qiye['id'])->find();

                if ($company) {
                    $user['company_notice'] = $company['str'];
                } else {
                    $user['company_notice'] = '';
                }
            } else if($qiye && $qiye['group_id'] == 2) {
                $qiye_nocice = Db::name('user_qiye')->where('uid', $qiye['id'])->find();
                if ($qiye_nocice) {
                    $user['company_notice'] = $qiye_nocice['notice'];
                } else {
                    $user['company_notice'] = '';
                }
            } else {
                $user['company_notice'] = '';
            }
//            if ($qiye) {
//                $qiye_nocice = Db::name('user_qiye')->where('uid', $qiye['id'])->find();
//
//                $user['company_notice'] = $qiye_nocice['notice'];
//            } else {
//                $user['company_notice'] = '';
//            }

        } else {
            $user['company_notice'] = '';
        }

        $communityModel = new CommunityModel();

        $data = $communityModel->alias('c')
            ->join('user u', 'c.uid=u.id', "left")
            ->where('uid', $user['id'])
            ->order('create_time desc')
            ->field('c.*')
            ->select();

        foreach ($data as $k => $v) {

            $data[$k]['is_zan'] = 0;

            $isZan = Db::name('community_zan')->where('c_id', $v['id'])->find();

            if ($isZan) $data[$k]['is_zan'] = 1;

            $data[$k]['time'] = self::mdate(strtotime($v['create_time']));

            $data[$k]['zan_count'] = Db::name('community_zan')->where('c_id', $v['id'])->count();

            $data[$k]['coment_count'] = Db::name('community_comment')->where('c_id', $v['id'])->count();
        }

        $user['commeny'] = $data;


        return $this->success('', $user);
    }
    /**
     * 用户举报
     * @param string $uid 用户id
     */
    public function jubao()
    {
        $uid = $this->request->get('uid');

        if (!$uid) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $data = [
            'uid' => $user['id'],
            'be_uid' => $uid,
            'create_time' => date('Y-m-d H:i',time())
        ];

        $add = Db::name('jubao')->insert($data);

        if ($add) {
            return $this->success('举报成功，后台审核中');
        } else {
            return $this->error('操作失败');
        }
    }
    /**
     * 关注用户
     *
     * @param string $uid 用户id
     */
    public function guanzhu()
    {
        $uid = $this->request->get('uid');

        if (!$uid) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $data = [
            'be_uid'      => $uid,
            'uid'         => $user['id'],
            'create_time' => date('Y-m-d H:i:s', time()),
        ];

        $add = Db::name('follow')->insert($data);

        if ($add) {
            return $this->success('成功');
        } else {
            return $this->error('失败');
        }
    }

    /**
     * 取消关注
     *
     * @param string $uid 用户id
     */
    public function guanzhuFalse()
    {
        $uid = $this->request->get('uid');

        if (!$uid) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $where['uid'] = $user['id'];

        $where['be_uid'] = $uid;

        $del = Db::name('follow')->where($where)->delete();

        if ($del) {
            return $this->success('成功');
        } else {
            return $this->error('失败');
        }
    }

    /**
     * 举报用户
     * @param string $uid 被举报用户id
     */
    public function report()
    {
        $uid = $this->request->get('uid');

        if (!$uid) return $this->error('参数错误');

        $user = $this->auth->getUser();

        $data = [
            'be_uid'      => $uid,
            'uid'         => $user['id'],
            'create_time' => date('Y-m-d H:i:s', time()),
        ];

        $where['uid'] = $user['id'];

        $where['be_uid'] = $uid;

        $isset = Db::name('follow')->where($where)->find();

        if ($isset) return $this->error('您已经举报过该用户了,请勿重复举报');

        $add = Db::name('report')->insert($data);

        if ($add) {
            return $this->success('成功');
        } else {
            return $this->error('失败');
        }


    }
    /**
     * 我的帖子
     */
    public function myCommunity()
    {
        $page = $this->request->get('page');

        $limit = $this->request->get('limit');
        if (!$page) {
            $pages = '0,10';
        } else {
            $page = $page - 1;
            if ($page < 0) $page = 0;
            $pages = $page . ',' . $limit;
        }

        $user = $this->auth->getUser();

        $communityModel = new CommunityModel();

        $data = $communityModel->alias('c')
            ->join('user u','c.uid=u.id')
            ->where('c.uid',$user['id'])
            ->order('c.create_time desc')
            ->limit($pages)
            ->field('c.*,u.avatar,u.username')
            ->select();

        if (empty($data)) return $this->success('',$data);
        foreach ($data as $k=>$v) {
            $data[$k]['is_zan'] = 0;

            $isZan = Db::name('community_zan')->where('c_id', $v['id'])->find();

            if ($isZan) $data[$k]['is_zan'] = 1;

            $data[$k]['time'] = self::mdate(strtotime($v['create_time']));

            $data[$k]['zan_count'] = Db::name('community_zan')->where('c_id', $v['id'])->count();

            $data[$k]['coment_count'] = Db::name('community_comment')->where('c_id', $v['id'])->count();
        }
        return $this->success('',$data);
    }

    /**
     * 我的评论
     */
    public function ourComment()
    {
        $page = $this->request->get('page');

        $limit = $this->request->get('limit');
        if (!$page) {
            $pages = '0,10';
        } else {
            $page = $page - 1;
            if ($page < 0) $page = 0;
            $pages = $page . ',' . $limit;
        }
        $user = $this->auth->getUser();

        $data = Db::name('community_comment cc')
            ->join('community c','cc.c_id=c.id')
            ->where('cc.uid',$user['id'])
            ->where('switch',1)
            ->order('cc.create_time desc')
            ->field('c.id,c.uid uuid,c.notice content,c.images,c.create_time time,cc.uid,cc.notice,cc.create_time  ')
            ->limit($pages)
            ->select();

        if (empty($data)) return $this->success('',$data);

        foreach ($data as $k=>$v) {

            $res[$k]['our'] = Db::name('user')->where('id',$user['id'])->field('id,username,avatar')->find();
            $res[$k]['our']['create_time'] = self::mdate(strtotime($data[$k]['create_time']));
            $res[$k]['our']['notice'] = $data[$k]['notice'];


            $res[$k]['community'] = Db::name('user')->field('id,username,avatar')->where('id',$v['uid'])->find();
            $res[$k]['community']['id'] = $data[$k]['id'];
            $res[$k]['community']['uid'] = $data[$k]['uid'];
            $res[$k]['community']['content'] = $data[$k]['content'];
            $res[$k]['community']['images'] = explode(',',$data[$k]['images']);
            $res[$k]['community']['time'] = self::mdate(strtotime($data[$k]['time']));
        }

        return $this->success('',$res);
    }
    /**
     *
     * 判断时分秒
     * @param null $time
     * @return false|string
     */

    function mdate($time = NULL)
    {
        $text = '';
        $time = $time === NULL || $time > time() ? time() : intval($time);
        $t = time() - $time;                      //时间差 （秒）
        $y = date('Y', $time) - date('Y', time());//是否跨年
        switch ($t) {
            case $t == 0:
                $text = '刚刚';
                break;
            case $t < 60:
                $text = $t . '秒前'; // 一分钟内
                break;
            case $t < 60 * 60:
                $text = floor($t / 60) . '分钟前'; //一小时内
                break;
            case $t < 60 * 60 * 24:
                $text = floor($t / (60 * 60)) . '小时前'; // 一天内
                break;
            case $t < 60 * 60 * 24 * 3:
                $text = floor($time / (60 * 60 * 24)) == 1 ? '昨天 ' . date('H:i', $time) : '前天 ' . date('H:i', $time); //昨天和前天
                break;
            case $t < 60 * 60 * 24 * 30:
                $text = date('m月d日 H:i', $time); //一个月内
                break;
            case $t < 60 * 60 * 24 * 365 && $y == 0:
                $text = date('m月d日', $time); //一年内
                break;
            default:
                $text = date('Y年m月d日', $time); //一年以前
                break;
        }

        return $text;
    }
}