yueke/application/api/controller/Usercenter.php

<?php

namespace app\api\controller;

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

/**
 * 会员中心
 */
class Usercenter extends Api
{
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];

    //我的配套
    public function my_package(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 1,
            //'order.remain' => ['gt',0],
            'order.is_gift' => 0,
        ];
        $list = Db::name('package_order')->alias('order')
            ->field('order.id,order.starttime,order.endtime,order.is_gift,order.remain,p.name,p.name_en')
            ->join('lesson_package p','order.package_id = p.id','LEFT')
            ->where($map)->order('order.remain desc,order.endtime asc')
            ->autopage()->select();

        $list = $this->list_lang($list,['name']);

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

    //赠课记录
    public function package_gift(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 1,
            //'order.remain' => ['gt',0],
            'order.is_gift' => 1,
        ];
        $list = Db::name('package_order')->alias('order')
            ->field('order.id,order.order_no,order.starttime,order.endtime,order.is_gift,order.sessions,order.remain,
            p.name as package_name,p.name_en as package_name_en')
            ->join('lesson_package p','order.package_id = p.id','LEFT')
            ->where($map)->order('order.remain desc,order.endtime asc')
            ->autopage()->select();

        $list = $this->list_lang($list,['name','package_name']);

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

    //上课记录，预约点了名的
    public function lesson_order_finish(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 20,//已点名
            'order.usernumber_sign' => ['gt',0],
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytype,order.package_order_id,order.package_remark,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.address,slot.coach_ids')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)->order('order.finishtime desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        //准备教练数据
        $coach_list = Db::name('coach')->column('id,nickname');

        foreach($list as $key => &$order){
            //放入教练
            $coach_text = '';
            $coach_ids = explode(',',$order['coach_ids']);
            foreach($coach_ids as $coach_id){
                $coach_text .= $coach_list[$coach_id].',';
            }
            $order['coach_text'] = substr($coach_text,0,-1);

            //放入支付套餐
            if($order['paytype'] == 1){
                $package_order = Db::name('package_order')->alias('order')
                    ->field('p.name,p.name_en,order.starttime,order.endtime')
                    ->join('lesson_package p','order.package_id = p.id','LEFT')
                    ->where('order.id',$order['package_order_id'])->find();
                $order['package_name']      = $package_order['name'];
                $order['package_name_en']   = $package_order['name_en'];
                $order['package_starttime'] = $package_order['starttime'];
                $order['package_endtime']   = $package_order['endtime'];
            }

        }

        $list = $this->list_lang($list,['package_name']);

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

    //取消记录
    public function lesson_order_cancel(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 30,//已取消
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytype,order.package_order_id,order.package_remark,order.cancel_reason,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.address,slot.coach_ids')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)->order('order.cancel_time desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        //准备教练数据
        $coach_list = Db::name('coach')->column('id,nickname');

        foreach($list as $key => &$order){
            //放入教练
            $coach_text = '';
            $coach_ids = explode(',',$order['coach_ids']);
            foreach($coach_ids as $coach_id){
                $coach_text .= $coach_list[$coach_id].',';
            }
            $order['coach_text'] = substr($coach_text,0,-1);

            //放入支付套餐
            /*if($order['paytype'] == 1){
                $package_order = Db::name('package_order')->alias('order')
                    ->field('p.name,p.name_en,order.starttime,order.endtime')
                    ->join('lesson_package p','order.package_id = p.id','LEFT')
                    ->where('order.id',$order['package_order_id'])->find();
                $order['package_name']      = $package_order['name'];
                $order['package_name_en']   = $package_order['name_en'];
                $order['package_starttime'] = $package_order['starttime'];
                $order['package_endtime']   = $package_order['endtime'];
            }*/

        }

        //$list = $this->list_lang($list,['package_name']);

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

    //取消售课预约单
    public function cancel_lesson_order(){
        $order_id = input('order_id',0);

        $map = [
            'id' => $order_id,
            'user_id' => $this->auth->id,
        ];
        $lesson_order = Db::name('lesson_order')->where($map)->find();

        if($lesson_order['order_status'] != 10){
            $this->error('此订单已无法取消');
        }

        //还有24小时上课，不能取消
        $slot = Db::name('lesson_slot')->where('id',$lesson_order['slot_id'])->find();
        if($slot['starttime'] - time() <= 86400){
            $this->error('距离上课时间不足24小时，不能取消');
        }

        Db::startTrans();

        //套餐给加回去
        if($lesson_order['paytype'] == 1){
            $package_order = Db::name('package_order')->where('id',$lesson_order['package_order_id'])->lock(true)->find();
            $update = [
                'remain' => $package_order['remain'] + $lesson_order['usernumber'],
                'updatetime' => time(),
            ];
            $rs_remain = Db::name('package_order')->where('id',$lesson_order['package_order_id'])->update($update);
            if($rs_remain === false){
                Db::rollback();
                $this->error('取消失败');
            }
        }

        //现金支付不给退，线下处理

        //取消预约单
        $update = [
            'order_status' => 30,
            'cancel_time' => time(),
            'cancel_reason' => __('用户主动取消'),
        ];

        $rs = Db::name('lesson_order')->where($map)->update($update);
        if($rs === false){
            Db::rollback();
            $this->error('取消失败');
        }

        Db::commit();
        $this->success('取消完成');

    }

    //过期课程。就是过了上课时间，没签到的
    public function lesson_order_signout(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 20,//已点名
            'order.usernumber_sign' => 0,//没签到的
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytype,order.package_order_id,order.package_remark,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.address,slot.coach_ids')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)->order('order.finishtime desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        //准备教练数据
        $coach_list = Db::name('coach')->column('id,nickname');

        foreach($list as $key => &$order){
            //放入教练
            $coach_text = '';
            $coach_ids = explode(',',$order['coach_ids']);
            foreach($coach_ids as $coach_id){
                $coach_text .= $coach_list[$coach_id].',';
            }
            $order['coach_text'] = substr($coach_text,0,-1);

            //放入支付套餐
            /*if($order['paytype'] == 1){
                $package_order = Db::name('package_order')->alias('order')
                    ->field('p.name,p.name_en,order.starttime,order.endtime')
                    ->join('lesson_package p','order.package_id = p.id','LEFT')
                    ->where('order.id',$order['package_order_id'])->find();
                $order['package_name']      = $package_order['name'];
                $order['package_name_en']   = $package_order['name_en'];
                $order['package_starttime'] = $package_order['starttime'];
                $order['package_endtime']   = $package_order['endtime'];
            }*/

        }

//        $list = $this->list_lang($list,['package_name']);

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

    //课程预约，即将到来3天，售课
    public function lesson_order_near(){
        $starttime = strtotime(date('Y-m-d'));  //今天早上
        $todaytime = strtotime(date('Y-m-d')) + 86400*3 - 1; //后天晚上

        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 10,
            'slot.starttime' => ['BETWEEN',[$starttime,$todaytime]],
        ];

        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytype,order.package_order_id,order.package_remark,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.address,slot.coach_ids')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)->order('order.finishtime desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        //准备教练数据
        $coach_list = Db::name('coach')->column('id,nickname');

        foreach($list as $key => &$order){
            //放入教练
            $coach_text = '';
            $coach_ids = explode(',',$order['coach_ids']);
            foreach($coach_ids as $coach_id){
                $coach_text .= $coach_list[$coach_id].',';
            }
            $order['coach_text'] = substr($coach_text,0,-1);

            //24小时内可以申请取消
            if($order['starttime'] - time() > 86400){
                $order['can_cancel'] = 1;
            }else{
                $order['can_cancel'] = 0;
            }

            //放入支付套餐
            /*if($order['paytype'] == 1){
                $package_order = Db::name('package_order')->alias('order')
                    ->field('p.name,p.name_en,order.starttime,order.endtime')
                    ->join('lesson_package p','order.package_id = p.id','LEFT')
                    ->where('order.id',$order['package_order_id'])->find();
                $order['package_name']      = $package_order['name'];
                $order['package_name_en']   = $package_order['name_en'];
                $order['package_starttime'] = $package_order['starttime'];
                $order['package_endtime']   = $package_order['endtime'];
            }*/

        }

        //$list = $this->list_lang($list,['package_name']);

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

    //课程预约，预约记录，售课
    public function lesson_order(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 10
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytype,order.package_order_id,order.package_remark,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.address,slot.coach_ids')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)->order('order.finishtime desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        //准备教练数据
        $coach_list = Db::name('coach')->column('id,nickname');

        foreach($list as $key => &$order){
            //放入教练
            $coach_text = '';
            $coach_ids = explode(',',$order['coach_ids']);
            foreach($coach_ids as $coach_id){
                $coach_text .= $coach_list[$coach_id].',';
            }
            $order['coach_text'] = substr($coach_text,0,-1);

            //放入支付套餐
            /*if($order['paytype'] == 1){
                $package_order = Db::name('package_order')->alias('order')
                    ->field('p.name,p.name_en,order.starttime,order.endtime')
                    ->join('lesson_package p','order.package_id = p.id','LEFT')
                    ->where('order.id',$order['package_order_id'])->find();
                $order['package_name']      = $package_order['name'];
                $order['package_name_en']   = $package_order['name_en'];
                $order['package_starttime'] = $package_order['starttime'];
                $order['package_endtime']   = $package_order['endtime'];
            }*/

        }

        //$list = $this->list_lang($list,['package_name']);

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

    //课程预约，即将到来 or 预约记录，试课
    public function trylesson_order(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => ['neq',0]
        ];

        $list = Db::name('trylesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytime,order.order_status,
            trylesson.name,trylesson.name_en')
            ->join('trylesson','order.trylesson_id = trylesson.id','LEFT')
            ->where($map)->order('order.paytime desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

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

    //设置通知方式

    //可以转让的、延期的配套
    public function package_list(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 1,
            'order.remain' => ['gt',0],
        ];
        $list = Db::name('package_order')->alias('order')
            ->field('order.id,order.starttime,order.endtime,order.is_gift,order.remain,
            p.name,p.name_en')
            ->join('lesson_package p','order.package_id = p.id','LEFT')
            ->where($map)->order('order.remain desc,order.endtime asc')
            ->select();

        $list = $this->list_lang($list,['name']);

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

    //配套转让申请
    public function package_move(){
        $field = ['name','mobile','email','reason','reason_files','package_order_id','sessions','to_name','to_mobile','to_email','remark'];

        $data = request_post_hub($field);

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

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

        $this->success('申请成功,请等待审核');
    }

    //配套延期申请
    public function package_delay(){
        $field = ['name','mobile','email','package_order_id','delay_week','reason','remark','reason_files'];

        $data = request_post_hub($field);

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

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

        $this->success('申请成功,请等待审核');
    }

    //可以申请退课的
    public function refund_lesson_order(){
        //试课单
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 10
        ];

        $list = Db::name('trylesson_order')->alias('order')
            ->field('order.id,order.order_amount,order.paytime,
            trylesson.name,trylesson.name_en')
            ->join('trylesson','order.trylesson_id = trylesson.id','LEFT')
            ->where($map)->order('order.paytime desc')
            ->select();
        $trylist = $this->list_lang($list,['name']);


        //售课单（已支付开课24小时内不能取消的，已点名实到人不足的）,已取消只是个暂时状态，后台处理完会改成已退课
        $map = [
            'order.user_id' => $this->auth->id,
        ];
        $map2 = '( (order.order_status = 10 ) or (order.order_status = 20 and order.usernumber_sign != order.usernumber) )';

        $list = Db::name('lesson_order')->alias('order')
            ->field('order.id,order.order_amount,
            lesson.name,lesson.name_en,
            slot.starttime,slot.hours,slot.endtime')
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFt')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where($map)
            ->where($map2)
            ->order('order.createtime desc')
            ->select();
        $lesson = $this->list_lang($list,['name']);

        //
        $result = [
            'trylesson' => $trylist,
            'lesson'    => $lesson,
        ];

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

    //课时退课申请
    public function order_refund(){
        $field = ['name','mobile','email','order_table','order_id','remark','reason_files'];
        $require = ['order_table','order_id'];

        $data = request_post_hub($field,$require);

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

        //冗余订单号,售课=1,试课=2
        if($data['order_table'] == 1){
            $data['order_no'] = Db::name('lesson_order')->where('id',$data['order_id'])->value('order_no');
        }else{
            $data['order_no'] = Db::name('trylesson_order')->where('id',$data['order_id'])->value('order_no');
        }

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

        $this->success('申请成功,请等待审核');
    }

    //公司团建活动信息
    public function company_apply(){
        $field = ['name','mobile','email','company_name','company_type','remark'];

        $data = request_post_hub($field);

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

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

        $this->success('申请成功,请等待审核');
    }


}