yuan/application/api/controller/SheAvcitity.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\model\AcitivityOrder;
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 SheAvcitity extends Api
{
    protected $noNeedLogin = ['acvitityLists', 'Info', 'listInfo', 'qustion', 'qustionInfo', 'buildInfo', 'protable', 'trueTime', 'chooseTime', 'GgInfo'];
    protected $noNeedRight = ['*'];


    /**
     * 活动添加
     * @ApiMethod (POST)
     * @param string $title 标题
     * @param string $address 活动地址
     * @param string $start_time 开始时间
     * @param string $end_time 结束时间
     * @param string $num 活动人数
     * @param string $phone 手机号
     * @param string $mianfei 是否免费1是2不是
     * @param string $price 收费价格
     * @param string $image 活动封面
     * @param string $notice 活动详情
     * @param string $images 活动多图
     */
    public function add()
    {
        $data = $this->request->post();

        if (empty($data['title'])) return $this->error('请输入活动标题');
        if (empty($data['address'])) return $this->error('请输入活动地址');
        if (empty($data['start_time'])) return $this->error('请输入活动开始时间');
        if (empty($data['end_time'])) return $this->error('请输入活动结束时间');
        if (!strtotime($data['start_time'])) return $this->error('开始活动时间格式不正确');
        if (!strtotime($data['end_time'])) return $this->error('结束活动时间格式不正确');
        if (empty($data['num'])) return $this->error('请输入活动人数');
        if (empty($data['phone'])) return $this->error('请输入联系方式');
        if (!preg_match("/^[1-9][0-9]*$/", $data['num'])) return $this->error('活动人数为正整数');
        if (!preg_match("/^1[34578]\d{9}$/", $data['phone'])) return $this->error('手机号格式不正确');
        if (strtotime($data['end_time']) <= strtotime($data['start_time'])) return $this->error('结束时间不能小于开始时间');

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

        if ($user['level'] != 1) return $this->error('暂无权限发布活动');

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

        $data['switch'] = 1;

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

        $data['number'] = date('Y', time()) . date('m', time()) . date('d', time()) . 'NO' . rand(0, 10000);

        $sheActivityModel = new SheActivityModel();

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

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

    /**
     * 活动列表
     */
    public function acvitityLists()
    {
        $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;
        }

        $sheActivityModel = new SheActivityModel();

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

        $where = [];

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

        $data = $sheActivityModel->alias('a')
//            ->with(['user' => function ($query) use ($where) {
//                $query->where($where);
//                $query->field('id,p_id');
//            }])
                ->join('user u','a.uid=u.id',"left")
            ->where($where)
            ->limit($pages)
            ->order('create_time desc')
            ->field('a.*')
            ->select()->toArray();
//        dump($data);die;
        $time = date('Y-m-d H:i:s', time());

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

            if ($time < $v['start_time']) {
                $data[$k]['status'] = '0';
                $data[$k]['status_str'] = '未开始';
            }

            if ($time > $v['start_time'] && $time < $v['end_time']) {
                $data[$k]['status'] = '1';
                $data[$k]['status_str'] = '报名中';
            }

            if ($time > $v['end_time']) {
                $data[$k]['status'] = '3';
                $data[$k]['status_str'] = '报名结束';
            }
//            if (!$v['user']) {
//                unset($data[$k]);
//            } else {
                $order = AcitivityOrder::where('a_id',$v['id'])->column('uid');

                $str = implode(',',$order);

                $data[$k]['users'] = Db::name('user')->where('id','in',$str)->field('id,avatar')->select();

                unset($order);

//            }

        }

//        return $this->success('', $data);
        return json(['code'=>1,'data'=>$data]);
    }

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

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

        $sheActivityModel = new SheActivityModel();

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

        $data = $sheActivityModel
            ->where('id', $id)
            ->order('create_time desc')
            ->find();

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

        if ($time < $data['start_time']) {
            $data['status'] = '0';
            $data['status_str'] = '未开始';
        }

        if ($time > $data['start_time'] && $time < $data['end_time']) {
            $data['status'] = '1';
            $data['status_str'] = '报名中';
        }

        if ($time > $data['end_time']) {
            $data['status'] = '3';
            $data['status_str'] = '报名结束';
        }
//            if (!$v['user']) {
//                unset($data[$k]);
//            } else {
        $order = AcitivityOrder::where('a_id',$data['id'])->column('uid');

        $str = implode(',',$order);

        $data['users'] = Db::name('user')->where('id','in',$str)->field('id,avatar')->select();

        $data['baoming_status'] = 0;

        $isset = AcitivityOrder::where('uid',$user['id'])->where('a_id',$data['id'])->find();

        if ($isset) {
            $data['baoming_status'] = 1;
        }

        $data['collection'] = 0;

        $isset = Db::name('user_collection')->where('uid',$user['id'])->where('a_id',$data['id'])->find();

        if ($isset) {
            $data['collection'] = 1;
        }
        return $this->success('', $data);
    }

    /**
     * 判断是否需要完善资料
     *
     */
    public function isWanshan()
    {
        $user = $this->auth->getUser();

        $wanshan = 1;
        if ($user['group_id'] == 0) {
            if (empty($user['company']) || empty($user['position'])) {
                $wanshan = 0;
            }
        } else {
            if (empty($user['company'])) {
                $wanshan = 0;
            }

            if ($user['shenhe_status'] == 0 || $user['shenhe_status'] == 1 || $user['shenhe_status'] == 3) {
                $wanshan = 0;
            }
        }

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

    /**
     * 活动报名
     *
     * @param string $id 活动id
     */
    public function order()
    {
        $id = $this->request->get('id');

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

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

        $sheActivityModel = new SheActivityModel();

        $info = $sheActivityModel
            ->where('id', $id)
            ->order('create_time desc')
            ->find();

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

        if (time() >= strtotime($info['end_time'])) return $this->error('活动已过期');

        if (strtotime($info['start_time']) > time()) return $this->error('活动未开始');


        if ($info['num_count'] + 1 > $info['num']) return $this->error('报名人数已经满了');
        $data = [
            'uid'         => $user['id'],
            'a_id'        => $info['id'],
            'title'       => $info['title'],
            'address'     => $info['address'],
            'start_time'  => $info['start_time'],
            'end_time'    => $info['end_time'],
            'create_time' => $time,
            'number'      => date('Y', time()) . date('m', time()) . date('d', time()) . 'NO' . rand(0, 10000),
        ];

        $model = new AcitivityOrder();

        $add = $model->allowField(true)->save($data);

        if ($add) {
            $id = $model->getLastInsID();
            $sheActivityModel->where('id',$info['id'])->update(['num_count' => $info['num_count'] +1 ]);
            return $this->success('报名成功', ['id' => $id]);
        } else {
            return $this->error('报名失败');
        }
    }

    /**
     * 报名详情
     *
     * @param string $id 订单id
     *
     */
    public function orderInfo()
    {
        $id = $this->request->get('id');

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

        $model = new AcitivityOrder();

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

        $data = $model->where('id',$id)->where('uid',$user['id'])->find();

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

    }

    /**
     * 活动收藏
     *
     * @param string $id 活动id
     *
     */
    public function collection()
    {
        $id = $this->request->get('id');

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

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

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

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

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

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

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

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

        $where['a_id'] = $id;

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

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

        if ($del) {

            return $this->success('成功');

        } else {

            return $this->error('失败');
        }
    }

}