yueke/application/api/controller/Usercenter.php

<?php

namespace app\api\controller;

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

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

    //我的配套
    //预存配套
    public function my_package(){
        $user_status = input('user_status',1); //默认已启用

        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 1,
            //'order.remain' => ['gt',0],
            'order.is_gift' => 0,
            'order.use_status' => $user_status,
        ];
        $list = Db::name('package_order')->alias('order')
            ->field('order.id,order.starttime,order.endtime,order.days,order.is_gift,order.remain,order.price,order.use_apply_status,order.createtime,order.pay_type,order.remark,order.paytime,
            p.name,p.name_en,p.image,p.activeremark,p.activeremark_en,p.validity,p.validity_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','activeremark','validity']);
        $list = list_domain_image($list,['image']);

        if(!empty($list)){
            foreach($list as $key => &$val){
                //转换remain
                $val['remain'] = floatval($val['remain']);
                //日期
                $val['time_text'] = $this->date_lang($val['starttime']).'-'.$this->date_lang($val['endtime']);
                $val['createtime_text'] = $this->date_lang($val['createtime']);
                //是否有延期按钮
                $val['expired'] = 0;
                if($val['endtime'] < time()){
                    $val['expired'] = 1;
                }
                //支付方式
                $pay_time_text = $this->date_lang($val['paytime']);
                $val['pay_type_text']    = ($val['pay_type'] == 1 ? '线上支付'     : '线下支付('.$val['remark'].')')        .' '. $pay_time_text;
                $val['pay_type_text_en'] = ($val['pay_type'] == 1 ? 'Paid Online' : 'Paid Offline ('.$val['remark'].')') .' '. $pay_time_text;
            }
            $list = $this->list_lang($list,['pay_type_text']);
        }

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

    //未激活配套，申请激活
    public function package_use_apply(){
        $id = input('id',0);

        $map = [
            'id' => $id,
            'user_id' => $this->auth->id,
            'order_status' => 1,
            'is_gift' => 0,
            'use_status' => 0,

        ];
        $info = Db::name('package_order')->where($map)->find();
        if(empty($info)){
            $this->error('未找到配套,请刷新重试');
        }

        if($info['use_apply_status'] == 1){
            $this->error('已经申请过了,无需重复操作');
        }
        if($info['use_apply_status'] == 2){
            $this->error('已经激活了,无需重复操作');
        }

        Db::name('package_order')->where('id',$id)->update(['use_apply_status'=>1]);
        $this->success('申请成功');
    }

    //赠课记录,已启用的赠送配套
    public function package_gift(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => 1,
            //'order.remain' => ['gt',0],
            'order.is_gift' => 1,
            'order.use_status' => 1,
        ];
        $list = Db::name('package_order')->alias('order')
            ->field('order.id,order.order_no,order.starttime,order.endtime,order.days,order.is_gift,order.sessions,order.remain,order.use_status,
            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,['package_name']);

        foreach($list as $key => &$order){
            //转换remain
            $order['remain'] = floatval($order['remain']);
            //日期
            $order['showtime_text'] = $this->date_lang($order['starttime']).'-'.$this->date_lang($order['endtime']);

            $order['remark'] = __('购买套餐赠送').' '.$order['remain'].'/'.$order['sessions'];
        }

        $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','order.trylesson_order_id','order.userremark','order.usernumber','order.jointype',
                'lesson.name','lesson.name_en',
                'slot.starttime','slot.hours','slot.address','slot.coach_ids',
                'coach.nickname as coach_text'
            ])
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->join('coach','slot.coach_ids = coach.id','LEFT')
            ->where($map)
            ->order('slot.starttime desc,order.id desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        foreach($list as $key => &$order){
            //hours转换
            $order['hours'] = floatval($order['hours']);

            //24小时内可以申请取消
            $order['can_cancel'] = 0;

            //显示时间
            $order['showtime_text'] = $this->weektime_lang($order['starttime']);

            //备注
            if(!empty($order['userremark'])){
                $order['userremark'] = __('备注:').$order['userremark'];
            }else{
                $order['userremark'] = '';
            }

            //预约情况
            $yuyue    = $order['usernumber'] . ($order['jointype'] == 1 ? ' 人预约'  : ' 人候补');
            $yuyue_en = $order['usernumber'] . ($order['jointype'] == 1 ? ' Booked' : ' Waitlisted');
            $yuyue = $this->lang == 'en' ? $yuyue_en : $yuyue;

            $order['coach_text'] = $yuyue.'  '.$order['coach_text'];

            //放入支付套餐
            $order['package_name']      = '';
            $order['package_name_en']   = '';
            $order['package_showtime_text'] = '';

            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();
                if(!empty($package_order)){
                $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'];*/
                $order['package_showtime_text'] = $this->date_lang($package_order['starttime']).'-'.$this->date_lang($package_order['endtime']);
                }
            }
            if($order['paytype'] == 4){
                $trylesson_order = Db::name('trylesson_order')->alias('order')
                    ->field('t.name,t.name_en,order.starttime,order.endtime')
                    ->join('trylesson t','order.trylesson_id = t.id','LEFT')
                    ->where('order.id',$order['trylesson_order_id'])->find();
                if(!empty($trylesson_order)){
                $order['package_name']      = $trylesson_order['name'];
                $order['package_name_en']   = $trylesson_order['name_en'];
                /*$order['package_starttime'] = $trylesson_order['starttime'];
                $order['package_endtime']   = $trylesson_order['endtime'];*/
                $order['package_showtime_text'] = $this->date_lang($trylesson_order['starttime']).'-'.$this->date_lang($trylesson_order['endtime']);
                }
            }
            if($order['paytype'] == 2){
                $order['package_name']      = '在线支付';
                $order['package_name_en']   = 'Pay online';
                $order['package_showtime_text'] = '';
            }

        }

        $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' => ['IN',[20,30,40]],
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field([
                'order.id','order.order_amount','order.paytype','order.package_order_id','order.package_remark','order.trylesson_order_id','order.userremark','order.usernumber','order.jointype','order.cancel_reason','order.order_status',
                'lesson.name','lesson.name_en',
                'slot.starttime','slot.hours','slot.address','slot.coach_ids',
                'coach.nickname as coach_text',
                'danceroom.name as danceroom_name','danceroom.name_en as danceroom_name_en',
            ])
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->join('coach','slot.coach_ids = coach.id','LEFT')
            ->join('danceroom','slot.danceroom_id = danceroom.id','LEFT')
            ->where($map)
            ->order('slot.starttime desc,order.id desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        foreach($list as $key => &$order){
            //hours转换
            $order['hours'] = floatval($order['hours']);

            //24小时内可以申请取消
            $order['can_cancel'] = 0;

            //显示时间
            $order['showtime_text'] = $this->weektime_lang($order['starttime']);

            //备注
            if(!empty($order['userremark'])){
                $order['userremark'] = __('备注:').$order['userremark'];
            }else{
                $order['userremark'] = '';
            }

            //预约情况
            $yuyue    = $order['usernumber'] . ($order['jointype'] == 1 ? ' 人预约'  : ' 人候补');
            $yuyue_en = $order['usernumber'] . ($order['jointype'] == 1 ? ' Booked' : ' Waitlisted');
            $yuyue = $this->lang == 'en' ? $yuyue_en : $yuyue;

            //舞蹈室
            $danceroom = $this->lang == 'en' ? $order['danceroom_name_en'] : $order['danceroom_name'];
            unset($order['danceroom_name']);
            unset($order['danceroom_name_en']);

            $order['coach_text'] = $yuyue."  ".$order['coach_text']."\n".$danceroom;

            //放入支付套餐
            $order['package_name']      = '';
            $order['package_name_en']   = '';
            $order['package_showtime_text'] = '';

            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();
                if(!empty($package_order)){
                $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'];*/
                $order['package_showtime_text'] = $this->date_lang($package_order['starttime']).'-'.$this->date_lang($package_order['endtime']);
                }
            }
            if($order['paytype'] == 4){
                $trylesson_order = Db::name('trylesson_order')->alias('order')
                    ->field('t.name,t.name_en,order.starttime,order.endtime')
                    ->join('trylesson t','order.trylesson_id = t.id','LEFT')
                    ->where('order.id',$order['trylesson_order_id'])->find();
                if(!empty($trylesson_order)){
                $order['package_name']      = $trylesson_order['name'];
                $order['package_name_en']   = $trylesson_order['name_en'];
                /*$order['package_starttime'] = $trylesson_order['starttime'];
                $order['package_endtime']   = $trylesson_order['endtime'];*/
                $order['package_showtime_text'] = $this->date_lang($trylesson_order['starttime']).'-'.$this->date_lang($trylesson_order['endtime']);
                }
            }
            if($order['paytype'] == 2){
                $order['package_name']      = '在线支付';
                $order['package_name_en']   = 'Pay online';
                $order['package_showtime_text'] = '';
            }

            //状态:0=待支付,10=已支付,20=已点名,30=已取消,40=已退课
            $status_arr    = [20=>'已完成',30=>'已取消',40=>'已取消'];
            $status_arr_en = [20=>'Finished',30=>'Canceled',40=>'Canceled'];
            $order['status_text']    = $status_arr[$order['order_status']];
            $order['status_text_en'] = $status_arr_en[$order['order_status']];

        }

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

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

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

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

        //取消候补单
        if($lesson_order['jointype'] == 2){

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

            $rs = Db::name('lesson_order')->where($map)->update($update);
            Db::commit();
            $this->success('取消完成');

        }

        //剩下的都是预约单
        if($lesson_order['order_status'] != 10){
            Db::rollback();
            $this->error('此订单已无法取消');
        }

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


        //套餐给加回去
        if($lesson_order['paytype'] == 1){
            $package_order = Db::name('package_order')->where('id',$lesson_order['package_order_id'])->lock(true)->find();
            $update = [
                'remain' => bcadd($package_order['remain'],$lesson_order['usernumber_hours'],1),
                '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('取消失败');
            }
        }
        //试课给改回去
        if($lesson_order['paytype'] == 4){
            $update = [
                'order_status' => 10,
                'updatetime' => time(),
                'lesson_order_id' => 0,
            ];
            $rs_remain = Db::name('trylesson_order')->where('id',$lesson_order['trylesson_order_id'])->update($update);
            if($rs_remain === false){
                Db::rollback();
                $this->error('取消失败');
            }
        }

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

        //取消预约单
        $update = [
            'order_status' => 30,
            'cancel_time' => time(),
            'cancel_reason' => __('用户主动取消'),
        ];
        if($lesson_order['paytype'] == 1 || $lesson_order['paytype'] == 4){
            $update['order_status'] = 40;
        }

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

        //候补上位
        $wait_rs = $this->lesson_order_wait($lesson_order,$slot);

        //更新已预约人数
        $pay_number = Db::name('lesson_order')->where('slot_id',$lesson_order['slot_id'])->where('order_status',10)->sum('usernumber');
        $rs_slot = Db::name('lesson_slot')->where('id',$lesson_order['slot_id'])->update(['bookednum' => $pay_number]);
        if($rs_slot === false){
            Db::rollback();
            $this->error('取消失败');
        }

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

    }

    //候补上位
    private function lesson_order_wait($lesson_order,$slot){
        //找到所有的候补单
        $houbu_list = Db::name('lesson_order')->alias('order')
            ->field('order.*,user.firstname,user.lastname,user.email,user.whatsapp,lesson.name_en')
            ->join('user','order.user_id = user.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->where('order.slot_id',$lesson_order['slot_id'])->where('order.jointype',2)->where('order.order_status',0)->order('order.id asc')->select();

        //有多少个空位
        $pay_number = Db::name('lesson_order')->where('slot_id',$lesson_order['slot_id'])->where('jointype',1)->where('order_status',10)->sum('usernumber');
        $num_remain = $slot['num_max'] - $pay_number;

        $coach_name = Db::name('coach')->where('id',$slot['coach_ids'])->value('nickname');

        if(!empty($houbu_list)){

            $up_usernumber = 0; //此次循环转正的人数

            foreach($houbu_list as $key => $order){
                if($order['usernumber'] + $up_usernumber <= $num_remain){
                    //此订单可以转正

                    //检查可用的套餐，找一个就可以
                    $map = [
                        'user_id' => $order['user_id'],

                        'endtime' => ['gt',time()],
                        'remain' => ['gt',$order['usernumber_hours']],
                        'order_status' => 1,
                        'use_status'   => 1, //已激活的
                        'id' => $order['package_order_id'],
                    ];
                    $package_order = Db::name('package_order')->where($map)->where('find_in_set(:lesson_ids,lesson_ids)', ['lesson_ids' => $slot['lesson_id']])->lock(true)->find();
                    if(!$package_order){
                        continue;
                    }

                    //扣除一节。
                    $update = [
                        'remain'     => bcsub($package_order['remain'],$order['usernumber_hours'],1),
                        'updatetime' => time(),
                    ];
                    $rs1 = Db::name('package_order')->where('id',$package_order['id'])->update($update);
                    if($rs1 === false){
                        Db::rollback();
//                        $this->error('扣除套餐余额失败');
                        $this->error('取消失败');
                    }

                    //修改预约单数据。延迟到转正的时候处理
                    $update_order['order_amount'] = 0;
                    $update_order['order_status'] = 10;
                    $update_order['paytime'] = time();
                    $update_order['package_order_id'] = $package_order['id'];

                    $update_order['package_remark'] = ($package_order['sessions'] - $package_order['remain']) . '-' . ($package_order['sessions'] - $package_order['remain'] + $order['usernumber_hours']) .'/'. $package_order['sessions'];
                    $update_order['paytype']  = 1; //修改支付方式为配套
                    $update_order['jointype'] = 1; //修改加入方式为预约

                    $rs2 = Db::name('lesson_order')->where('id',$order['id'])->update($update_order);
                    if($rs2 === false){
                        Db::rollback();
//                        $this->error('扣除套餐余额失败');
                        $this->error('取消失败');

                    }

                    //加上本次转正的人数
                    $up_usernumber += $order['usernumber'];

                    //额外的通知

                    try {
                        $message =
                            'Hi,'.$order['firstname']. ' ' .$order['lastname'].'!<br/>
                            We are excited to inform you that a spot has opened up for the following class. You are now booked into the class!<br/>
                            Class:'.$order['name_en'].'<br/>
                            Date: '.date('d F Y',$slot['starttime']).'<br/>
                            Time: '.date('H:i a',$slot['starttime']).'<br/>
                            We look forward to seeing you in the studio!❤<br/>
                            Best Regards,<br/>
                            Elin Dance Studio<br/>
                            <img src="'.config('website_url').'/assets/img/logo3.png" style="width:136px;height:115px">
                            ';

                        //给这些用户发邮件
                        $obj = new Email();
                        $result = $obj
                            ->to($order['email'])
                            ->subject('A spot for your waitlisted class is ready and you are now added in!')
                            ->message($message)
                            ->send();
                        $obj = '';
                        //发whatsapp
                        $parameters = [
                            [
                                'type' => 'text',
                                'text' => $order['firstname'].' '.$order['lastname'],
                            ],
                            [
                                'type' => 'text',
                                'text' => $order['name_en'],
                            ],
                            /*[
                                'type' => 'text',
                                'text' => $coach_name,
                            ],*/
                            [
                                'type' => 'text',
                                'text' => date('D l Y',$slot['starttime']) .' at '.date('H:i a',$slot['starttime']),
                            ],
                        ];
                        $this->whatapp($order['whatsapp'],'lessonorder_alternate_to_booking','en_US',$parameters);

                    } catch (Exception $e) {

                    }
                    //额外的通知
                }else{
                    continue;//跳出
                }
            }
        }
        return true;
    }

    //发送whatapp消息的方法
    private function whatapp($receive_mobile,$template,$code,$parameters){
        if(empty($receive_mobile)){return true;}

        $token = config('site.whatsapp_token');

        //发送者
        $mobile_id = '337736419413019'; //Elin Dance Stuido 2:+65 8015 4154  ,  WhatsApp Business Account ID: 336509229537586

        //发送
        $url = 'https://graph.facebook.com/v19.0/'.$mobile_id.'/messages';
        $header = [
            'Authorization: Bearer ' . $token,
            'Content-Type: application/json',
        ];
        $body = [
            'messaging_product' => 'whatsapp',
            'recipient_type' => 'individual',
            'to' => $receive_mobile,
            'type' => 'template',
            'template' => [
                'name' => $template,
                'language' => [
                    'code' => $code
                ],
                'components' => [
                    [
                        'type' => 'body',
                        'parameters' => $parameters
                    ]

                ],
            ],
        ];
        $body = json_encode($body);

        $rs = curl_post($url,$body,$header);
        return true;
    }

    //过期课程。就是过了上课时间，没签到的
    //前端用不到了
    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','order.trylesson_order_id','order.userremark','order.usernumber','order.jointype',
                'lesson.name','lesson.name_en',
                'slot.starttime','slot.hours','slot.address','slot.coach_ids',
                'coach.nickname as coach_text'
            ])
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->join('coach','slot.coach_ids = coach.id','LEFT')
            ->where($map)
            ->order('slot.starttime desc,order.id desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        foreach($list as $key => &$order){
            //hours转换
            $order['hours'] = floatval($order['hours']);

            //24小时内可以申请取消
            $order['can_cancel'] = 0;

            //显示时间
            $order['showtime_text'] = $this->weektime_lang($order['starttime']);

            //备注
            if(!empty($order['userremark'])){
                $order['userremark'] = __('备注:').$order['userremark'];
            }else{
                $order['userremark'] = '';
            }

            //预约情况
            $yuyue    = $order['usernumber'] . ($order['jointype'] == 1 ? ' 人预约'  : ' 人候补');
            $yuyue_en = $order['usernumber'] . ($order['jointype'] == 1 ? ' Booked' : ' Waitlisted');
            $yuyue = $this->lang == 'en' ? $yuyue_en : $yuyue;

            $order['coach_text'] = $yuyue.'  '.$order['coach_text'];

            //放入支付套餐
            $order['package_name']      = '';
            $order['package_name_en']   = '';
            $order['package_showtime_text'] = '';

            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();
                if(!empty($package_order)){
                $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'];*/
                $order['package_showtime_text'] = $this->date_lang($package_order['starttime']).'-'.$this->date_lang($package_order['endtime']);
                }
            }
            if($order['paytype'] == 4){
                $trylesson_order = Db::name('trylesson_order')->alias('order')
                    ->field('t.name,t.name_en,order.starttime,order.endtime')
                    ->join('trylesson t','order.trylesson_id = t.id','LEFT')
                    ->where('order.id',$order['trylesson_order_id'])->find();
                if(!empty($trylesson_order)){
                $order['package_name']      = $trylesson_order['name'];
                $order['package_name_en']   = $trylesson_order['name_en'];
                /*$order['package_starttime'] = $trylesson_order['starttime'];
                $order['package_endtime']   = $trylesson_order['endtime'];*/
                $order['package_showtime_text'] = $this->date_lang($trylesson_order['starttime']).'-'.$this->date_lang($trylesson_order['endtime']);
                }
            }
            if($order['paytype'] == 2){
                $order['package_name']      = '在线支付';
                $order['package_name_en']   = 'Pay online';
                $order['package_showtime_text'] = '';
            }

        }

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

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

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

        $map = [
            'order.user_id' => $this->auth->id,
            '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','order.trylesson_order_id','order.userremark','order.usernumber','order.jointype',
                'lesson.name','lesson.name_en',
                'slot.starttime','slot.hours','slot.address','slot.coach_ids',
                'coach.nickname as coach_text',
                'danceroom.name as danceroom_name','danceroom.name_en as danceroom_name_en',
            ])
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->join('coach','slot.coach_ids = coach.id','LEFT')
            ->join('danceroom','slot.danceroom_id = danceroom.id','LEFT')
            ->where($map)
            ->where('(order.jointype = 1 and order.order_status = 10) or (order.jointype = 2 and order.order_status = 0)') //已支付的 或 候补单
            ->order('slot.starttime desc,order.id desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        foreach($list as $key => &$order){
            //hours转换
            $order['hours'] = floatval($order['hours']);

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

            //显示时间
            $order['showtime_text'] = $this->weektime_lang($order['starttime']);

            //备注
            if(!empty($order['userremark'])){
                $order['userremark'] = __('备注:').$order['userremark'];
            }else{
                $order['userremark'] = '';
            }

            //预约情况
            $yuyue    = $order['usernumber'] . ($order['jointype'] == 1 ? ' 人预约'  : ' 人候补');
            $yuyue_en = $order['usernumber'] . ($order['jointype'] == 1 ? ' Booked' : ' Waitlisted');
            $yuyue = $this->lang == 'en' ? $yuyue_en : $yuyue;

            //舞蹈室
            $danceroom = $this->lang == 'en' ? $order['danceroom_name_en'] : $order['danceroom_name'];
            unset($order['danceroom_name']);
            unset($order['danceroom_name_en']);

            $order['coach_text'] = $yuyue."  ".$order['coach_text']."\n".$danceroom;

            //放入支付套餐
            $order['package_name']      = '';
            $order['package_name_en']   = '';
            $order['package_showtime_text'] = '';

            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();
                if(!empty($package_order)){
                $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'];*/
                $order['package_showtime_text'] = $this->date_lang($package_order['starttime']).'-'.$this->date_lang($package_order['endtime']);
                }
            }
            if($order['paytype'] == 4){
                $trylesson_order = Db::name('trylesson_order')->alias('order')
                    ->field('t.name,t.name_en,order.starttime,order.endtime')
                    ->join('trylesson t','order.trylesson_id = t.id','LEFT')
                    ->where('order.id',$order['trylesson_order_id'])->find();
                if(!empty($trylesson_order)){
                $order['package_name']      = $trylesson_order['name'];
                $order['package_name_en']   = $trylesson_order['name_en'];
                /*$order['package_starttime'] = $trylesson_order['starttime'];
                $order['package_endtime']   = $trylesson_order['endtime'];*/
                $order['package_showtime_text'] = $this->date_lang($trylesson_order['starttime']).'-'.$this->date_lang($trylesson_order['endtime']);
                }
            }
            if($order['paytype'] == 2){
                $order['package_name']      = '在线支付';
                $order['package_name_en']   = 'Pay online';
                $order['package_showtime_text'] = '';
            }

        }

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

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

    //课程预约，预约记录，售课
    public function lesson_order(){
        $map = [
            'order.user_id' => $this->auth->id,
        ];
        $list = Db::name('lesson_order')->alias('order')
            ->field([
                'order.id','order.order_amount','order.paytype','order.package_order_id','order.package_remark','order.trylesson_order_id','order.userremark','order.usernumber','order.jointype',
                'lesson.name','lesson.name_en',
                'slot.starttime','slot.hours','slot.address','slot.coach_ids',
                'coach.nickname as coach_text',
                'danceroom.name as danceroom_name','danceroom.name_en as danceroom_name_en',
            ])
            ->join('lesson_slot slot','order.slot_id = slot.id','LEFT')
            ->join('lesson','order.lesson_id = lesson.id','LEFT')
            ->join('coach','slot.coach_ids = coach.id','LEFT')
            ->join('danceroom','slot.danceroom_id = danceroom.id','LEFT')
            ->where($map)
            ->where('(order.jointype = 1 and order.order_status = 10) or (order.jointype = 2 and order.order_status = 0)') //已支付的 或 候补单
            ->order('slot.starttime desc,order.id desc')
            ->autopage()->select();
        $list = $this->list_lang($list,['name']);

        foreach($list as $key => &$order){
            //hours转换
            $order['hours'] = floatval($order['hours']);

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

            //显示时间
            $order['showtime_text'] = $this->weektime_lang($order['starttime']);

            //备注
            if(!empty($order['userremark'])){
                $order['userremark'] = __('备注:').$order['userremark'];
            }else{
                $order['userremark'] = '';
            }

            //预约情况
            $yuyue    = $order['usernumber'] . ($order['jointype'] == 1 ? ' 人预约'  : ' 人候补');
            $yuyue_en = $order['usernumber'] . ($order['jointype'] == 1 ? ' Booked' : ' Waitlisted');
            $yuyue = $this->lang == 'en' ? $yuyue_en : $yuyue;

            //舞蹈室
            $danceroom = $this->lang == 'en' ? $order['danceroom_name_en'] : $order['danceroom_name'];
            unset($order['danceroom_name']);
            unset($order['danceroom_name_en']);

            $order['coach_text'] = $yuyue."  ".$order['coach_text']."\n".$danceroom;

            //放入支付套餐
            $order['package_name']      = '';
            $order['package_name_en']   = '';
            $order['package_showtime_text'] = '';

            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();
                if(!empty($package_order)){
                $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'];*/
                $order['package_showtime_text'] = $this->date_lang($package_order['starttime']).'-'.$this->date_lang($package_order['endtime']);
                }
            }
            if($order['paytype'] == 4){
                $trylesson_order = Db::name('trylesson_order')->alias('order')
                    ->field('t.name,t.name_en,order.starttime,order.endtime')
                    ->join('trylesson t','order.trylesson_id = t.id','LEFT')
                    ->where('order.id',$order['trylesson_order_id'])->find();
                if(!empty($trylesson_order)){
                $order['package_name']      = $trylesson_order['name'];
                $order['package_name_en']   = $trylesson_order['name_en'];
                /*$order['package_starttime'] = $trylesson_order['starttime'];
                $order['package_endtime']   = $trylesson_order['endtime'];*/
                $order['package_showtime_text'] = $this->date_lang($trylesson_order['starttime']).'-'.$this->date_lang($trylesson_order['endtime']);
                }
            }
            if($order['paytype'] == 2){
                $order['package_name']      = '在线支付';
                $order['package_name_en']   = 'Pay online';
                $order['package_showtime_text'] = '';
            }


        }

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

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

    //我的试课订单
    public function trylesson_order(){
        $map = [
            'order.user_id' => $this->auth->id,
            'order.order_status' => ['in',[10,20]],
        ];

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

        foreach($list as $key => &$order){
            //显示时间
            $order['showtime_text'] = $this->date_lang($order['starttime']).'-'.$this->date_lang($order['endtime']);
        }

        $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']);

        if(!empty($list)){
            foreach($list as $key => &$val){
                //转换remain
                $val['remain'] = floatval($val['remain']);

                $val['time_text'] = $this->date_lang($val['starttime']).'-'.$this->date_lang($val['endtime']);
                //是否有延期按钮
                $val['expired'] = 0;
                if($val['endtime'] < time()){
                    $val['expired'] = 1;
                }
            }
        }

        $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);

        //检查被装让套餐
        $package = Db::name('package_order')->where('order_status',1)->where('user_id',$this->auth->id)->where('id',$data['package_order_id'])->find();
        if(empty($package)){
            $this->error('不存在的套餐订单');
        }
        if($package['remain'] < $data['sessions']){
            $this->error('套餐剩余课时不足');
        }
        if($package['endtime'] < time()){
            //$this->error('套餐已过期');
        }

        //检查被转让人
        $to_user = Db::name('user')->where('email',$data['to_email'])->find();
        if(empty($to_user)){
            $this->error('被转让人的邮箱没找到对应用户');
        }
        if($to_user['id'] == $this->auth->id){
            $this->error('不能转让给自己');
        }

        $data['to_user_id'] = $to_user['id'];

        //入库
        $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);

        //检查被装让套餐
        $package = Db::name('package_order')->where('order_status',1)->where('user_id',$this->auth->id)->where('id',$data['package_order_id'])->find();
        if(empty($package)){
            $this->error('不存在的套餐订单');
        }
        if($package['use_status'] != 1){
            $this->error('该配套还没有激活');
        }

        $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']);*/
        /*if(!empty($trylist)){
            foreach($trylist as $key2 => $val2){
                //日期
                $trylist[$key2]['showtime_text'] = date('Y-m-d H:i',$val2['paytime']);
            }
        }*/


        //售课单（已支付开课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.id desc')
            ->select();
        $lesson = $this->list_lang($list,['name']);
        if(!empty($list)){
            foreach($lesson as $key => &$val){
                //hours转换
                $val['hours'] = floatval($val['hours']);
                //日期
                $val['showtime_text'] = $this->weektime_lang($val['starttime']);
            }
        }

        //
        $result = [
            'trylesson' => [],
            '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
        $data['order_table'] = 1;
        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('申请成功,请等待审核');
    }


}