lachang/app/api/model/member/MemberCardOrder.php

<?php

declare (strict_types=1);

namespace app\api\model\member;

use app\api\model\Receipt;
use app\common\model\member\MemberCardOrder as MemberCardOrderModel;

/**
 * 会员卡
 * Class MemberCards
 * @package app\api\model
 */
class MemberCardOrder extends MemberCardOrderModel
{

    //创建订单
    public function createOrderEvent($order){
        return $this->transaction(function () use ($order) {
            $this->save($order);
            return $this->id;
        });
    }


    /**
     * 获取订单详情(待付款状态)
     * @param $orderNo
     * @return array|null|static
     */
    public static function getPayDetail(string $orderNo)
    {
        return self::detail(['order_no' => $orderNo, 'pay_status' => 0]);
    }


    public static function getList($userId){
        $ftime = date('Y-m-d H:i:s',strtotime('-1 year'));

        $valid =  self::where('user_id',$userId)->where('pay_status',1)
            ->where('order_status',30)
            ->where('pay_time','>',$ftime)
            ->field('id,order_no,pay_time,pay_price,left(from_member_time,16) as from_member_time,left(to_member_time,16) as to_member_time,0 as had_receipt')
            ->order('id desc')
            ->limit(3)
            ->select()->each(function (&$item){
                $item['had_receipt'] = Receipt::where(['order_id'=>$item['id'],'ftype'=>2])->find()?1:0;
            });

        $invalid = self::where('user_id',$userId)->where('pay_status',1)
            ->where('order_status',30)
            ->where('pay_time' ,'<',$ftime)
            ->field('id,order_no,pay_time,pay_price,from_member_time,to_member_time')
            ->order('id desc')
            ->limit(3)
            ->select();

        return ['valid'=>$valid,'invalid'=>$invalid];
    }
}