jiankangtv/application/api/controller/Index.php

<?php

namespace app\api\controller;

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

/**
 * 首页接口
 */
class Index extends Api
{
    protected $noNeedLogin = ['banner', 'activelist', 'personaltype', 'personalactivetype', 'car', 'leader', 'personaldirection', 'activeinfo'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        $this->success('请求成功');
    }

    //轮播图
    public function banner()
    {
        $list = Db::name('banner')->field('id, title, image, url')->order('weigh', 'desc')->select();
        $list = list_domain_image($list, ['image']);

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

    //活动列表
    public function activelist() {
        $type = input('type', 0, 'intval'); //分类:1=休闲,2=中度
        $keyword = input('keyword', '', 'trim'); //关键字

        $where['signupendtime'] = ['gt', time()];
        $where['status'] = 0;
        if ($type) {
            $where['type'] = $type;
        }
        if ($keyword !== '') {
            $where['title|desc|remark|collectionplace|leader'] = ['like', '%'.$keyword.'%'];
        }

        $list = Db::name('active')->field('id, type, title, desc, remark, image, price, maxperson, currentperson, status')
            ->where($where)->page($this->page, $this->pagenum)->order('createtime', 'desc')->select();

        $list = list_domain_image($list, ['image']);
        foreach ($list as &$v) {
            if ($v['maxperson'] <= $v['currentperson']) {
                $v['is_full'] = 1;
            } else {
                $v['is_full'] = 0;
            }
        }

        $this->success('活动列表', $list);
    }

    //活动详情
    public function activeinfo() {
        $id = input('id', 0, 'intval');
        if (!$id) {
            $this->error('参数缺失');
        }

        $info = Db::name('active')->find($id);
        if (!$info) {
            $this->error('数据不存在');
        }

        $info = info_domain_image($info, ['image']);
        $info['starttime'] = date('Y-m-d H:i', $info['starttime']);
        $info['endtime'] = date('Y-m-d H:i', $info['endtime']);
        $info['collectiontime'] = date('Y-m-d H:i', $info['collectiontime']);
        $info['signupendtime'] = date('Y-m-d H:i', $info['signupendtime']);
        $info['refundendtime'] = date('Y-m-d H:i', $info['refundendtime']);
        //查询已报名列表
        $active_people = Db::name('active_people')->where(['active_id' => $id, 'status' => ['neq', 3]])->field('user_id, name, createtime')->select();
        $user = Db::name('user');
        foreach ($active_people as &$v) {
            $v['avatar'] = $user->where(['id' => $v['user_id']])->value('avatar');
            $v['createtime'] = date('Y-m-d H:i:s', $v['createtime']);
        }

        $info['active_people'] = $active_people;
        $info['customer_service'] = config('site.customer_service') ? config('site.customer_service') : ''; //客服电话

        $this->success('活动详情', $info);
    }

    //报名活动之前检查
    public function beforesignup() {
        $id = input('id', 0, 'intval'); //活动id
        if (!$id) {
            $this->error('请选择要报名的活动');
        }
        $info = Db::name('active')->find($id);
        if (!$info) {
            $this->error('活动不存在');
        }
        if ($info['status'] == 2) {
            $this->error('活动已经结束');
        }
        if ($info['status'] == 3) {
            $this->error('活动已经取消');
        }
        if ($info['signupendtime'] < time()) {
            $this->error('活动报名已经截止');
        }
        if ($info['currentperson'] >= $info['maxperson']) {
            $this->error('活动名额已满');
        }
        //检查自己信息是否完善
        if (!$this->auth->realname) {
            $this->success('请在个人资料中完善真实姓名', ['code' => 3]);
        }
        if (!$this->auth->idcard) {
            $this->success('请在个人资料中完善身份证号', ['code' => 3]);
        }
        if (!$this->auth->emergencycontact) {
            $this->success('请在个人资料中完善紧急联系人', ['code' => 3]);
        }
        if (!$this->auth->contactmobile) {
            $this->success('请在个人资料中完善紧急联系方式', ['code' => 3]);
        }

        $this->success('检查通过');
    }

    //查询可用优惠券
    public function canusercoupon() {
        $price = input('price', '', 'trim'); //价格
        if (!preg_match('/^[0-9]+(.[0-9]{1,2})?$/', $price) || $price < 0) {
            $this->error('价格错误');
        }

        $where['user_id'] = $this->auth->id;
        $where['endtime'] = ['egt', time()];
        $where['status'] = 0;
        $map = 'type = 1 or (type = 2 and minmoney <= '.$price.')';

        $list = Db::name('user_coupon')->field('id, title, desc, type, money, minmoney')->where($where)->where($map)->select();
//        p(\db()->getLastSql());

        $this->success('查询可用优惠券', $list);
    }
    
    //报名活动
    public function signupactive() {
        //检查自己信息是否完善
        if (!$this->auth->realname || !$this->auth->idcard || !$this->auth->emergencycontact || !$this->auth->contactmobile) {
            $this->success('请在个人资料中完善资料', ['code' => 3]);
        }

        $id = input('id', 0, 'intval'); //活动id
        //人员信息json串:
        // name姓名 credtype证件类型 idcard身份证号 mobile手机号 emergencycontact紧急联系人 contactmobile紧急联系方式
        // insurance保险 originalprice原价  vipprice会员价 coupon_id用户优惠券ID is_free是否使用免费次数:0=否,1=是
        // price小计  is_self是否本人:0=否,1=是
        $active_people = input('active_people', '', 'trim');
        $paytype = input('paytype', 0, 'intval'); //支付方式:0=余额,1=微信
        $total_price = input('total_price', 0, 'trim'); //总价格

        if (!preg_match('/^[0-9]+(.[0-9]{1,2})?$/', $total_price) || $total_price < 0) {
            $this->error('合计价格错误');
        }
        if (!in_array($paytype, [0, 1])) {
            $this->error('支付错误');
        }
        if ($total_price == 0 && $paytype != 0) {
            $this->error('请选择余额支付');
        }
        //检查活动信息
        if (!$id) {
            $this->error('请选择要报名的活动');
        }
        $info = Db::name('active')->find($id);
        if (!$info) {
            $this->error('活动不存在');
        }
        if ($info['status'] == 2) {
            $this->error('活动已经结束');
        }
        if ($info['status'] == 3) {
            $this->error('活动已经取消');
        }
        if ($info['signupendtime'] < time()) {
            $this->error('活动报名已经截止');
        }
        if ($info['currentperson'] >= $info['maxperson']) {
            $this->error('活动名额已满');
        }
        //检查人员信息
        if (!$active_people) {
            $this->error('请添加报名人员信息');
        }
        $active_people_arr = json_decode($active_people, true);
        if (!$active_people_arr) {
            $this->error('请添加报名人员信息');
        }
        if ($info['currentperson'] + count($active_people_arr) > $info['maxperson']) {
            $this->error('活动名额不足');
        }
        //会员信息
        $vip_info = Db::name('vip')->find($this->auth->maxlevel);
        if (!$vip_info) {
            $this->error('会员信息缺失，请联系管理员');
        }
        $_data = [];
        $total_amount = 0; //总价格验证
        $active_people = Db::name('active_people'); //报名人员表
        $active_people_modify = Db::name('active_people_modify'); //报名修改信息表
        $user_coupon = Db::name('user_coupon');
        foreach ($active_people_arr as $k => &$v) {
            $data = [];
            //检查信息
            if (!$v['name'] || iconv_strlen($v['name'], 'utf-8') > 50) {
                $this->error('请输入正确姓名');
                break;
            }
            if (iconv_strlen($v['idcard'], 'utf-8') != 18) {
                $this->error('请输入正确身份证号');
                break;
            }
            if (!is_mobile($v['mobile'])) {
                $this->error('请输入正确手机号');
                break;
            }
            if (!$v['emergencycontact'] || iconv_strlen($v['emergencycontact'], 'utf-8') > 50) {
                $this->error('请输入紧急联系人');
                break;
            }
            if (!is_mobile($v['contactmobile'])) {
                $this->error('请输入正确紧急联系人方式');
                break;
            }
            //判断是否报名过
            $count = $active_people->where(['active_id' => $id, 'idcard' => $v['idcard'], 'status' => ['neq', 3]])->count('id');
            if ($count) {
                $this->error($v['name'] . $v['idcard'] . '已报名过该活动');
                break;
            }
            $count2 = $active_people_modify->where(['active_id' => $id, 'idcard' => $v['idcard'], 'status' => 0])->count('id');
            if ($count2) {
                $this->error($v['name'] . $v['idcard'] . '已提交过修改，请等待审核');
                break;
            }
            //判断证件类型和保险
            if (!$v['credtype'] || iconv_strlen($v['credtype'], 'utf-8') > 50) {
                $this->error('证件类型错误');
                break;
            }
            if (!$v['insurance'] || iconv_strlen($v['insurance'], 'utf-8') > 50) {
                $this->error('保险信息错误');
                break;
            }
            //判断用户信息
            if ($v['is_self'] && $k == 0) {
                //判断用户信息
                if ($v['name'] != $this->auth->realname || $v['idcard'] != $this->auth->idcard || $v['mobile'] != $this->auth->mobile || $v['emergencycontact'] != $this->auth->emergencycontact || $v['contactmobile'] != $this->auth->contactmobile) {
                    $this->error('本人信息错误');
                    break;
                }
                //本人判断年龄 价格
                if ($info['maxage'] > 0) {
                    $age = $this->idcardage($this->auth->idcard);
                    if ($age < $info['minage'] || $age > $info['maxage']) {
                        $this->error('活动年龄限制为' . $info['minage'] . '-' . $info['maxage']);
                        break;
                    }
                }
                if ($v['is_free'] == 1) { //使用免费次数
                    if ($info['is_free'] != 1) {
                        $this->error('活动暂不支持免费体验');
                        break;
                    }
                    if ($this->auth->freenumber <= 0) {
                        $this->error('您的免费次数不足');
                        break;
                    }
                    //检查当月是否用过免费次数
                    $month_time = strtotime(date('Y-m-1', time()));
                    $count = $active_people->where(['user_id' => $this->auth->id, 'is_free' => 1, 'createtime' => ['egt', $month_time]])->count('id');
                    if ($count) {
                        $this->error('您当月已使用过免费次数');
                        break;
                    }
                    if ($v['vipprice'] != 0 || $v['price'] != 0) {
                        $this->error($this->auth->realname . '价格错误');
                        break;
                    }
                    if ($v['coupon_id']) {
                        $this->error('使用免费体验，无法使用优惠券');
                        break;
                    }
                } else { //不使用免费次数
                    //会员价和优惠券是否可以叠加使用:0=否,1=是
                    if ($info['is_overlying'] == 0 && $v['vipprice'] != $info['price'] && $v['coupon_id']) {
                        $this->error('该活动不支持会员价和优惠券同时使用');
                        break;
                    }
                    //计算会员价, 会员价优先顺序: 生日 > 女生特权日 > 会员价格
                    $birthday = date('md', strtotime($this->auth->birthday));
                    $now_day = date('md', time());
                    if ($birthday == $now_day) {
                        //生日折扣
                        if ($vip_info['birthdiscount'] > 100 || $vip_info['birthdiscount'] < 0) {
                            $this->error('会员生日折扣错误，请联系管理员');
                            break;
                        }
                        $discount = $vip_info['birthdiscount'];
                    } elseif ($info['girldiscount'] < 100 && $info['girldiscount'] > 0 && $this->auth->gender == 2) {
                        //女生特权日折扣
                        $discount = $info['girldiscount'];
                    } else {
                        //会员折扣
                        if ($vip_info['vipdiscount'] > 100 || $vip_info['vipdiscount'] < 0) {
                            $this->error('会员折扣错误，请联系管理员');
                            break;
                        }
                        $discount = $vip_info['vipdiscount'];
                    }
                    $vipprice = number_format($info['price'] * $discount / 100, 2, '.', ''); //会员价
                    //查询优惠券
                    if ($v['coupon_id']) {
                        $user_coupon_info = $user_coupon->where(['id' => $v['coupon_id'], 'user_id' => $this->auth->id])->find();
                        if (!$user_coupon_info) {
                            $this->error('优惠券不存在');
                        }
                        if ($user_coupon_info['status'] != 0) {
                            $this->error('优惠券已使用');
                        }
                        if ($user_coupon_info['endtime'] < time()) {
                            $this->error('优惠券已过期');
                        }
                        if ($user_coupon_info['type'] == 1) {
                            //打折券
                            if ($user_coupon_info['money'] < 0 || $user_coupon_info['money'] > 100) {
                                $this->error('优惠券折扣错误，请联系管理员');
                                break;
                            }
                        } else {
                            //抵扣券
                            //会员价和优惠券是否可以叠加使用:0=否,1=是
                            if ($info['is_overlying'] == 0) {
                                if ($info['price'] < $user_coupon_info['minmoney']) {
                                    $this->error('优惠券使用条件不满足');
                                    break;
                                }
                            } else {
                                if ($vipprice < $user_coupon_info['minmoney']) {
                                    $this->error('优惠券使用条件不满足');
                                    break;
                                }
                            }
                        }
                    }
                    //判断价格
                    //会员价和优惠券是否可以叠加使用:0=否,1=是
                    if ($info['is_overlying'] == 0) {
                        if ($v['coupon_id']) { //使用优惠券
                            if ($v['vipprice'] != $info['price']) {
                                $this->error('会员价显示错误');
                                break;
                            }
                            if ($user_coupon_info['type'] == 1) {
                                //打折券
                                $coupon_price = number_format($info['price'] * (100 - $user_coupon_info['money']) / 100, 2, '.', '');
                                $price = number_format($info['price'] - $coupon_price, 2, '.', '');
                            } else {
                                //抵扣券
                                $price = number_format($info['price'] - $user_coupon_info['money'], 2, '.', '');
                            }
                        } else {
                            $price = $vipprice;
                        }
                    } else {
                        if ($vipprice != $v['vipprice']) {
                            $this->error('会员价显示错误');
                            break;
                        }
                        if ($v['coupon_id']) { //使用优惠券
                            if ($user_coupon_info['type'] == 1) {
                                //打折券
                                $coupon_price = number_format($vipprice * (100 - $user_coupon_info['money']) / 100, 2, '.', '');
                                $price = number_format($vipprice - $coupon_price, 2, '.', '');
                            } else {
                                //抵扣券
                                $price = number_format($vipprice - $user_coupon_info['money'], 2, '.', '');
                            }
                        } else {
                            $price = $vipprice;
                        }
                    }

                    //判断小计
                    if ($price != $v['price']) {
                        $this->error('小计显示错误');
                        break;
                    }

                    $data['vipprice'] = $v['vipprice']; //会员价
                    $data['coupon_id'] = $v['coupon_id']; //优惠券id
                    if ($v['coupon_id']) {
                        $data['coupontype'] = $user_coupon_info['type'];
                        $data['couponprice'] = $user_coupon_info['money'];
                    }
                }

                $data['name'] = $this->auth->realname;
                $data['idcard'] = $this->auth->idcard;
                $data['mobile'] = $this->auth->mobile;
                $data['emergencycontact'] = $this->auth->emergencycontact;
                $data['contactmobile'] = $this->auth->contactmobile;
            } else {
                //帮人报名判断年龄 报名信息
                if ($info['maxage'] > 0) {
                    $age = $this->idcardage($v['idcard']);
                    if ($age < $info['minage'] || $age > $info['maxage']) {
                        $this->error('活动年龄限制为' . $info['minage'] . '-' . $info['maxage']);
                        break;
                    }
                }
                //判断是否符合满几人减免一人费用
                //会员权限
                if ($vip_info['manypeople'] > 1 && $k == $vip_info['manypeople'] - 1) {
                    if ($v['price'] != 0) {
                        $this->error('小计显示错误');
                        break;
                    }
                } else {
                    if ($v['price'] != $info['price']) {
                        $this->error('小计显示错误');
                        break;
                    }
                }

                $data['name'] = $v['name'];
                $data['idcard'] = $v['idcard'];
                $data['mobile'] = $v['mobile'];
                $data['emergencycontact'] = $v['emergencycontact'];
                $data['contactmobile'] = $v['contactmobile'];
                $data['vipprice'] = $v['price']; //会员价
            }

            $data['active_id'] = $id;
            $data['user_id'] = $this->auth->id;
            $data['credtype'] = $v['credtype'];
            $data['insurance'] = $v['insurance'];
            $data['originalprice'] = $info['price'];
            $data['is_free'] = $v['is_free'];
            $data['price'] = $v['price']; //小计
            $data['is_self'] = $v['is_self'];
            $data['createtime'] = time();

            array_push($_data, $data);
            $total_amount += $v['price'];
        }

        if ($total_amount != $total_price) {
            $this->error('合计价格错误');
        }
        if ($paytype == 0) { //余额支付
            if ($this->auth->money < $total_amount) {
                $this->success('您的余额不足，请先去充值', ['code' => 2]);
            }
        }

        //构建订单信息
        $order_data['order_sn'] = date('YmdHis', time()) . rand(10000000, 99999999);
        $order_data['active_id'] = $id;
        $order_data['user_id'] = $this->auth->id;
        $order_data['paytype'] = $paytype;
        $order_data['price'] = $total_amount;
        $order_data['number'] = count($active_people_arr);
        $order_data['status'] = $paytype == 1 ? 0 : 1;
        $order_data['createtime'] = time();
        //构建活动信息
        $active_data['currentperson'] = $info['currentperson'] + count($active_people_arr);
        if ($info['currentperson'] + count($active_people_arr) >= $info['minperson'] && $info['status'] == 0) {
            $active_data['status'] = 1;
        }

        //开始事务
        Db::startTrans();
        //修改活动表数据
        $active_rs = Db::name('active')->where(['id' => $id, 'status' => $info['status'],'currentperson' => $info['currentperson']])->setField($active_data);
        if (!$active_rs) {
            Db::rollback();
            $this->error('网络延迟，请稍后再试');
        }
        //添加订单
        $rs = Db::name('active_order')->insertGetId($order_data);
        if (!$rs) {
            Db::rollback();
            $this->error('网络延迟，请稍后再试');
        }
        //添加人员信息
        foreach ($_data as &$v) {
            $v['order_id'] = $rs;
            $v['status'] = $order_data['status'];
            $rt = $active_people->insertGetId($v);
            if (!$rt) {
                Db::rollback();
                $this->error('网络延迟，请稍后再试');
            }
        }
        //扣除免费次数
        if ($info['is_free'] == 1 && $active_people_arr[0]['is_self'] == 1 && $active_people_arr[0]['is_free'] == 1) {
            $freenumber = $this->auth->freenumber - 1;
            $user_rs = Db::name('user')->where(['id' => $this->auth->id, 'freenumber' => $this->auth->freenumber])->setField('freenumber', $freenumber);
            if (!$user_rs) {
                Db::rollback();
                $this->error('网络延迟，请稍后再试');
            }
        }
        //扣除优惠券
        if ($active_people_arr[0]['is_self'] == 1 && $active_people_arr[0]['coupon_id']) {
            $user_coupon_rs = Db::name('user_coupon')->where(['id' => $active_people_arr[0]['coupon_id'], 'user_id' => $this->auth->id, 'status' => 0])->setField(['active_id' => $id, 'order_id' => $rs, 'status' => 1]);
            if (!$user_coupon_rs) {
                Db::rollback();
                $this->error('网络延迟，请稍后再试');
            }
        }
        //扣款 支付方式:0=余额,1=微信
        if ($paytype == 0) {
            $res = create_log(-$total_amount, '支付活动订单', $this->auth->id, 2, $rs);
            if ($res != 1) {
                Db::rollback();
                $this->error('余额资金异常，请联系管理员');
            }
            //给上级发送优惠券
            if ($this->auth->pre_user_id) {
                //查询报名活动优惠券
                $invite_coupon = Db::name('coupon')->where(['purpose' => 5, 'status' => 1])->order('weigh desc, id desc')->find();
                if ($invite_coupon) {
                    $invite_coupon_data = [
                        'user_id' => $this->auth->pre_user_id,
                        'coupon_id' => $invite_coupon['id'],
                        'title' => $invite_coupon['title'],
                        'desc' => $invite_coupon['desc'],
                        'type' => $invite_coupon['type'],
                        'money' => $invite_coupon['money'],
                        'minmoney' => $invite_coupon['minmoney'],
                        'purpose' => $invite_coupon['purpose'],
                        'starttime' => time(),
                        'endtime' => time() + $invite_coupon['effectiveday'] * 86400,
                        'active_id' => $id,
                        'order_id' => $rs,
                        'createtime' => time()
                    ];

                    $invite_coupon_rs = Db::name('user_coupon')->insertGetId($invite_coupon_data);
                    if (!$invite_coupon_rs) {
                        Db::rollback();
                        $this->error('发放优惠券失败');
                    }
                }
            }

            //发送消息
            $data = [
                'user_id' => $this->auth->id,
                'type' => 1,
                'title' => '活动通知',
                'content' => '您已成功报名' . $info['title'] . '活动',
                'createtime' => time()
            ];
            $sys_rs = Db::name('sys_msg')->insertGetId($data);
            if (!$sys_rs) {
                Db::rollback();
                $this->error('网络延迟，请稍后再试');
            }

            Db::commit();
            $this->success('报名成功');
        } else {
            //生成支付订单记录
            $rechar_order['user_id'] = $this->auth->id;
            $rechar_order['order_no'] = date('YmdHis', time()) . rand(10000000, 99999999); //微信订单编号
            $rechar_order['money'] = $total_amount;
            $rechar_order['purpose'] = 1; //充值用途:1=支付订单,2=充值,3=开通会员
            $rechar_order['pay_type'] = 'wechat';
            $rechar_order['relation_id'] = $rs;
            $rechar_order['createtime'] = time();

            $result = Db::name('rechar_order')->insertGetId($rechar_order);
            if (!$result) {
                Db::rollback();
                $this->error('网络延迟，请稍后再试');
            }

            Db::commit();

            //构建支付链接数据
            $wxData['body'] = '报名活动支付';
            $wxData['out_trade_no'] = $rechar_order['order_no'];
            $wxData['total_fee'] = $total_amount;
//            $wxData['total_fee'] = 0.01;
            $wxData['openid'] = $this->auth->openid;

//            require_once($_SERVER['DOCUMENT_ROOT'] . '/Plugins/Weixin/WxPay/WxPay.php');
            $wxPay = new wxpay\WxPay(config('wxchatpay'));
            $doResult = $wxPay->WxPayJs($wxData);

            $this->success('微信支付参数返回成功', $doResult);
        }
    }

    //根据身份证号获取年龄
    public function idcardage($idcard = '') {
        //截取身份证里的出生日期
        $year = substr($idcard, 6, 4);
        $month = substr($idcard, 10, 2);
        $day = substr($idcard, 12, 2);
        //获取当前日期
        $current_year = date('Y');
        $current_month = date('m');
        $current_day = date('d');
        //计算年龄
        $age = $current_year - $year;//今年减去生日年
        if ($month > $current_month || ($month == $current_month && $day > $current_day)) {
            //如果出生月大于当前月或出生月等于当前月但出生日大于当前日则减一岁
            $age--;
        }

        return $age;
    }

    //私人订制类型
    public function personaltype() {
        $list = Db::name('personal_type')->field('id, name')->order('weigh', 'desc')->select();

        $this->success('私人订制类型', $list);
    }

    //私人订制活动类型
    public function personalactivetype() {
        $list = Db::name('personal_active_type')->field('id, name')->where(['pid' => 0])->order('weigh', 'desc')->select();

        $list = $this->getchildtype($list);
        $this->success('私人订制活动类型', $list);
    }

    //无限级私人订制活动类型
    public function getchildtype($list = [])
    {
        $complaint_type = Db::name('personal_active_type');
        foreach ($list as &$v) {
            $child = $complaint_type->field('id, name')->where(['pid' => $v['id']])->order('weigh', 'desc')->select();
            if ($child) {
                $child = $this->getchildtype($child);
            }

            $v['child'] = $child;
        }

        return $list;
    }

    //车辆类型
    public function car() {
        $list = Db::name('car')->field('id, name, desc')->order('weigh', 'desc')->select();

        $this->success('车辆类型', $list);
    }

    //领队
    public function leader() {
        $list = Db::name('leader')->field('id, name')->order('weigh', 'desc')->select();

        $this->success('领队', $list);
    }
    
    //私人订制出行方向
    public function personaldirection() {
        $list = Db::name('personal_direction')->field('id, name')->order('weigh', 'desc')->select();

        $this->success('私人订制出行方向', $list);
    }

    //私人订制
    public function personalactive() {
        $type = input('type', '', 'trim'); //类型
        $number = input('number', 0, 'intval'); //出行人数
        $traveltime = input('traveltime', '', 'strtotime'); //出行时间
        $traveday = input('traveday', 0, 'intval'); //出行天数
        $activetype = input('activetype', '', 'trim'); //活动类型
        $car = input('car', '', 'trim'); //车辆
        $leader = input('leader', '', 'trim'); //领队
        $travedirection = input('travedirection', '', 'trim'); //出行方向
        $freerange = input('freerange', '', 'trim'); //空闲时段
        $remark = input('remark', '', 'trim'); //留言

        if (!$type || iconv_strlen($type, 'utf-8') > 50) {
            $this->error('请选择类型');
        }
        if ($number <= 0) {
            $this->error('请填写出行人数');
        }
        if ($traveltime < time()) {
            $this->error('请选择正确出行时间');
        }
        if ($traveday <= 0) {
            $this->error('请填写正确出行天数');
        }
        if (!$activetype || iconv_strlen($activetype, 'utf-8') > 50) {
            $this->error('请选择活动类型');
        }
        if ($car && iconv_strlen($car, 'utf-8') > 50) {
            $this->error('请选择车辆');
        }
        if ($leader && iconv_strlen($leader, 'utf-8') > 50) {
            $this->error('请选择领队');
        }
        if (!$travedirection || iconv_strlen($travedirection, 'utf-8') > 50) {
            $this->error('请选择出行方向');
        }
        if (!$freerange || iconv_strlen($freerange, 'utf-8') > 50) {
            $this->error('请选择空闲时段');
        }
        if (iconv_strlen($remark, 'utf-8') > 500) {
            $this->error('留言最多500字');
        }

        $data['user_id'] = $this->auth->id;
        $data['type'] = $type;
        $data['number'] = $number;
        $data['traveltime'] = $traveltime;
        $data['traveday'] = $traveday;
        $data['activetype'] = $activetype;
        $data['car'] = $car;
        $data['leader'] = $leader;
        $data['travedirection'] = $travedirection;
        $data['freerange'] = $freerange;
        $data['remark'] = $remark;
        $data['createtime'] = time();

        $rs = Db::name('personal_order')->insertGetId($data);
        if (!$rs) {
            $this->error('提交失败');
        }

        $this->success('提交成功');
    }

    //查询轮播图优惠券列表
    public function bannercoupon() {
        $list = Db::name('coupon')->field('id, title, desc, type, money')
            ->where(['purpose' => 4, 'status' => 1])->page($this->page, $this->pagenum)->order('weigh desc, id desc')->select();

        $user_coupon = Db::name('user_coupon');
        foreach ($list as &$v) {
            $v['is_receive'] = $user_coupon->where(['user_id' => $this->auth->id, 'coupon_id' => $v['id']])->count('id');
        }

        $this->success('查询轮播图优惠券列表', $list);
    }

    //领取轮播图优惠券
    public function receivebannercoupon() {
        $id = input('id', 0, 'intval'); //优惠券id

        if (!$id) {
            $this->error('参数缺失');
        }

        $info = Db::name('coupon')->where(['id' => $id, 'purpose' => 4])->find();
        if (!$info) {
            $this->error('优惠券不存在');
        }
        if ($info['status'] != 1) {
            $this->error('优惠券已下架');
        }

        //查询是否已领取
        $count = Db::name('user_coupon')->where(['user_id' => $this->auth->id, 'coupon_id' => $id])->count('id');
        if ($count) {
            $this->error('您已经领取过了');
        }

        $data['user_id'] = $this->auth->id;
        $data['coupon_id'] = $id;
        $data['title'] = $info['title'];
        $data['desc'] = $info['desc'];
        $data['type'] = $info['type'];
        $data['money'] = $info['money'];
        $data['minmoney'] = $info['minmoney'];
        $data['purpose'] = $info['purpose'];
        $data['starttime'] = time();
        $data['endtime'] = time() + $info['effectiveday'] * 86400;
        $data['createtime'] = time();

        //开启事务
        Db::startTrans();

        //添加领取记录
        $rs = Db::name('user_coupon')->insertGetId($data);
        if (!$rs) {
            Db::rollback();
            $this->error('领取失败');
        }

        $rt = Db::name('user_coupon')->where(['user_id' => $this->auth->id, 'coupon_id' => $id])->count('id');
        if ($rt != 1) {
            Db::rollback();
            $this->error('领取失败');
        }

        Db::commit();
        $this->success('领取成功');
    }
    
    //体验会员列表
    public function experiencevip() {
        $list = Db::name('vip')->where(['id' => ['gt', $this->auth->maxlevel], 'status' => 1])->select();

        $vip_privilege = Db::name('vip_privilege');
        foreach ($list as &$v) {
            $v['vip_privilege'] = $vip_privilege->field('id, title, desc')
                ->where(['vip_id' => $v['id']])->order('weigh desc')->select();
        }

        $this->success('体验会员列表', $list);
    }

    //购买体验会员
    public function buyexperiencevip() {
        //检查是否已经开通体验会员
        if ($this->auth->experiencetime >= time()) {
            $this->error('您已开通体验会员，不能重复开通');
        }

        $id = input('id', 0, 'intval');
        if (!$id) {
            $this->error('参数缺失');
        }

        $info = Db::name('vip')->where(['id' => $id])->find();
        if (!$info) {
            $this->error('会员不存在');
        }
        if ($info['status'] != 1) {
            $this->error('体验会员已下架');
        }
        if ($info['price'] <= 0) {
            $this->error('会员价格异常');
        }
        //体验会员等级必须大于成长值会员
        if ($id <= $this->auth->maxlevel) {
            $this->error('请开通更高等级体验会员');
        }
        //判断余额
        if ($this->auth->money < $info['price']) {
            $this->success('您的余额不足，请先去充值', ['code' => 2]);
        }

        $data['user_id'] = $this->auth->id;
        $data['vip_id'] = $id;
        $data['title'] = $info['title'];
        $data['level'] = $info['level'];
        $data['growthvalue'] = $info['growthvalue'];
        $data['free'] = $info['free'];
        $data['price'] = $info['price'];
        $data['endtime'] = time() + $info['day'] * 86400;
        $data['vipdiscount'] = $info['vipdiscount'];
        $data['birthdiscount'] = $info['birthdiscount'];
        $data['manypeople'] = $info['manypeople'];
        $data['createtime'] = time();

        //开启事务
        Db::startTrans();

        //添加开通记录
        $rs = Db::name('vip_log')->insertGetId($data);
        if (!$rs) {
            Db::rollback();
            $this->error('开通失败');
        }
        //扣除余额
        $result = create_log(-$info['price'], '开通会员', $this->auth->id, 4, $rs);
        if ($result != 1) {
            Db::rollback();
            $this->error('资金异常，请联系管理员');
        }
        //成长值会员信息
        $growth_vip_info = Db::name('vip')->find($this->auth->growthlevel);
        //修改用户表信息
        $user_data['experiencelevel'] = $id;
        $user_data['experiencetime'] = $data['endtime'];
        $user_data['maxlevel'] = $id;
        $freenumber = $this->auth->freenumber + $info['free'] - $growth_vip_info['free'];
        $user_data['freenumber'] = $freenumber > 0 ? $freenumber : 0;

        $rt = Db::name('user')->where([
                'id' => $this->auth->id,
                'experiencelevel' => $this->auth->experiencelevel,
                'maxlevel' => $this->auth->maxlevel,
                'freenumber' => $this->auth->freenumber])->setField($user_data);
        if (!$rt) {
            Db::rollback();
            $this->error('开通失败');
        }

        Db::commit();
        $this->success('开通成功');
    }

}