jiankangyijia/application/index/controller/Plantask.php

<?php

namespace app\index\controller;

use think\Controller;
use think\Db;
use think\Cache;

class Plantask extends Controller
{
    //未支付订单，下单N分钟后，自动取消
    public function auto_cancel_nopay_order(){
        $nowtime  = time();
        $second   = config('site.nopay_order_autocancel_minute') * 60;
        $lasttime = $nowtime - $second;

        //dump(datetime($lasttime));exit;
        $rs = Db::name('wenzhen_order')->where('status',0)->where('createtime','lt',$lasttime)->update([
            'status'        => 3,
            'cancel_time'   => $nowtime,
            'cancel_reason' => '超时未支付',
            'finish_time'   => $nowtime,
        ]);
        echo $rs;

    }

    //待接诊订单，医生不操作，支付N分钟后，自动退诊
    public function auto_tuizhen_noaccept_order(){
        $nowtime  = time();
        $second   = config('site.payorder_noaccept_autotuizhen_minute') * 60;
        $lasttime = $nowtime - $second;

        //dump(datetime($lasttime));exit;
        Db::startTrans();

        $wenzhen_order = Db::name('wenzhen_order')->where('status',10)->where('pay_time','lt',$lasttime)->order('id asc')->lock(true)->find();
        if(empty($order_list)){
            Db::rollback();
            echo 'empty';
            exit;
        }

        $order_id = $wenzhen_order['id'];

        //修改订单
        $update = [
            'status'        => 16,
            'cancel_time'   => $nowtime,
            'cancel_reason' => '超时未接诊',
            'finish_time'   => $nowtime,
        ];

        //余额支付的直接退款
        if($wenzhen_order['pay_type'] == 'wallet'){

            //用户加钱
            $logtype = $wenzhen_order['ordertype'] == 1 ? 13 : 14;
            $rs_wallet = model('wallet')->lockChangeAccountRemain($wenzhen_order['user_id'],'money',$wenzhen_order['total_fee'],$logtype,$remark='超时未接诊','wenzhen_order',$order_id);
            if($rs_wallet['status'] === false){
                Db::rollback();
                echo $rs_wallet['msg'];
                exit;
            }

            //订单退款参数
            $update['refund_price']  = $wenzhen_order['total_fee'];
            $update['refund_status'] = 3;
        }else{
            $update['refund_status'] = 1; //待退款

            //发起退款
            $Wenzhenorder_model = new Wenzhenorder;
            $refund_rs = $Wenzhenorder_model->old_refund($wenzhen_order,$wenzhen_order['total_fee']);
            if($refund_rs === true){
                $update['refund_status'] = 3; //退款完成
            }
        }

        $update_rs = Db::name('wenzhen_order')->where('id',$order_id)->update($update);
        if(!$update_rs){
            Db::rollback();
            echo '退诊失败';
            exit;
        }


        Db::commit();
        echo '退诊成功'.$order_id.'结束';
        exit;


    }

    //视频订单，已拨打，通话N分钟后，自动结束
    public function auto_finish_firstvideo_videoorder(){
        $nowtime  = time();
        $second   = config('site.firstvideo_videoorder_autofinish_minute') * 60;
        $lasttime = $nowtime - $second;

        $rs = Db::name('wenzhen_order')->where('status',25)->where('ordertype',2)->where('video_time','lt',$lasttime)->update([
            'status'        => 30,
            'finish_time'   => $nowtime,
        ]);

        echo $rs;
    }

    //图文订单，已接诊，接诊N分钟后，自动结束
    public function auto_finish_accept_textorder(){
        $nowtime  = time();
        $second   = config('site.accept_textorder_autofinish_minute') * 60;
        $lasttime = $nowtime - $second;

        $rs = Db::name('wenzhen_order')->where('status',20)->where('ordertype',1)->where('accept_time','lt',$lasttime)->update([
            'status'        => 30,
            'finish_time'   => $nowtime,
        ]);

        echo $rs;
    }

/////////////////////////////////////////////////////////////////////////

    //定时跑用户活跃，改成离线
    public function auto_user_active(){
        $actitime = time() - 7200;

        $sql = 'update `mt_user` set is_active = 0 where is_active = 1 and id in (select user_id from mt_user_active where requesttime < '.$actitime.')';
        db()->query($sql);
    }

    //vip过期的，三个隐私设置改成0
    //vip过期的，更新用户表is_vip
    public function auto_vipend(){
//        $sql = 'update `mt_user_power` set yinsi = 0,yinshen = 0,wuhen = 0 where user_id in (select user_id from mt_user_wallet where vip_endtime > 0 and vip_endtime < '.time().')';
//        db()->query($sql);

        /*$sql2 = 'update `mt_user` set is_vip = 0 where is_vip = 1 and user_id in (select user_id from mt_user_wallet where vip_endtime > 0 and vip_endtime < '.time().')';
        db()->query($sql2);*/
    }




}