XLJK-api/app/Models/Order.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Order extends Model
{
    protected $table = 'order';
    protected $primaryKey = 'user_id';
//    protected function serializeDate(\DateTimeImmutable $date)
//    {
//        return $date->format('Y-m-d H:i:s');
//    }
    const CREATED_AT = 'creation_date';

    public static function getList(int $page,int $limit)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()->offset($offset)->limit($limit)->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }

    public static function insertData(array $data)
    {
        return self::query()->insert($data);
    }

    public static function del(int $id)
    {
        return self::query()->where('id', $id)->delete();
    }

    public static function getOrderInfoByOutTradeNo($outTradeNo)
    {
        $data = self::query()->where(["out_trade_no" => $outTradeNo])->first();
        if ($data) {
            return $data->toArray();
        } else {
            return false;
        }
    }

    public static function updateOrder($where, $updateData)
    {
        return self::query()->where($where)->update($updateData);
    }
}