kknongchang_2506/app/Module/Ulogic/Models/UserAddress.php

<?php

namespace App\Module\Ulogic\Models;

use Dcat\Admin\Traits\HasDateTimeFormatter;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Database\Eloquent\Model;

/**
 * App\Module\Ulogic\Models\UserAddress
 *
 * field start 
 * field end
 */
class UserAddress extends Model
{
    use HasDateTimeFormatter;
    use SoftDeletes;

    protected $table = 'user_address';

    // attrlist start 
    protected $fillable = [
    ];
    // attrlist end

    /**
     * @param $userId
     * @return \Illuminate\Database\Eloquent\Collection
     * 用户保存地址列表
     */
    public static function list($userId, $type)
    {
        $query = self::query();
        $query->where('user_id', $userId);
        if ($type != 0) {
            $query->where('type', $type);
        }
        return $query->orderBy('id', 'desc')->get();
    }

    /**
     * @param $userId
     * @param $addressId
     * @return null
     * 查询用户地址
     */
    public static function getUserAddress($userId, $addressId)
    {
        $query = self::query();
        $query->where('user_id', $userId);
        $query->where('id', $addressId);
        return $query->first();
    }

    /**
     * @param $userId
     * @param $addressType
     * @param $addressName
     * @param $address
     * @return bool
     * 添加地址
     */
    public static function add($userId, $addressType, $addressName, $address)
    {
        $model = new self();
        $model->user_id = $userId;
        $model->nickname = $addressName;
        $model->type = $addressType;
        $model->address = $address;
        return $model->save();
    }

    /**
     * @param $addressId
     * @return mixed
     * 删除地址
     */
    public static function userDelete($addressId)
    {
        $model = self::find($addressId);
        $model->status = 2;
        $model->deleted_at = date('Y-m-d H:i:s');
        return $model->save();
    }

    /**
     * @param $addressId
     * @return null
     * 根据id获取地址
     */
    public static function getAddressById($addressId)
    {
        $query = self::query();
        $query->where('id', $addressId);
        return $query->first();
    }

    /**
     * @param $addressId
     * @return null
     * 根据地址获取信息
     */
    public static function getDataByAddress($address)
    {
        $query = self::query();
        $query->where('address', $address);
        return $query->first();
    }

    /**
     * @param $addressId
     * @return null
     * 根据地址获取信息
     */
    public static function getDataByUserId($userId)
    {
        $query = self::query();
        $query->where('user_id', $userId);
        return $query->first();
    }
}