89 lines
2.5 KiB
PHP
89 lines
2.5 KiB
PHP
<?php
|
||
|
||
namespace addons\webman\model;
|
||
|
||
use addons\webman\traits\HasDateTimeFormatter;
|
||
use Illuminate\Database\Eloquent\Model;
|
||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||
use Illuminate\Database\Eloquent\SoftDeletes;
|
||
|
||
/**
|
||
* Class PlayerBank
|
||
* @property int id 主键
|
||
* @property int player_id 玩家id
|
||
* @property string bank_name 开户行
|
||
* @property string bank_code 银行代码
|
||
* @property string account 银行卡号
|
||
* @property string account_name 户名
|
||
* @property string wallet_address 钱包地址
|
||
* @property string qr_code 钱包二维码
|
||
* @property int status 状态
|
||
* @property int pay_type 支付渠道 1-espay，2-onepay，3-sklpay，4-usdt
|
||
* @property string created_at 创建时间
|
||
* @property string updated_at 最后一次修改时间
|
||
* @property string deleted_at 删除时间
|
||
* @property Player player 玩家信息
|
||
* @package addons\webman\model
|
||
*/
|
||
class PlayerBank extends Model
|
||
{
|
||
use SoftDeletes, HasDateTimeFormatter;
|
||
public function __construct(array $attributes = [])
|
||
{
|
||
parent::__construct($attributes);
|
||
$this->setTable(plugin()->webman->config('database.player_bank_table'));
|
||
}
|
||
|
||
/**
|
||
* 玩家信息
|
||
* @return BelongsTo
|
||
*/
|
||
public function player(): BelongsTo
|
||
{
|
||
return $this->belongsTo(plugin()->webman->config('database.player_model'), 'player_id')->withTrashed();
|
||
}
|
||
|
||
/**
|
||
* 模型事件 - 删除前
|
||
*/
|
||
protected static function boot()
|
||
{
|
||
parent::boot();
|
||
|
||
static::deleting(function (PlayerBank $playerBank) {
|
||
if (!empty($playerBank->qr_code)) {
|
||
$imagePath = self::extractImagePathFromUrl($playerBank->qr_code);
|
||
|
||
if ($imagePath) {
|
||
deleteToGCS($imagePath);
|
||
}
|
||
}
|
||
});
|
||
}
|
||
|
||
/**
|
||
* 从 URL 中提取图片路径
|
||
*/
|
||
private static function extractImagePathFromUrl($url): string
|
||
{
|
||
if (filter_var($url, FILTER_VALIDATE_URL)) {
|
||
$parsedUrl = parse_url($url);
|
||
if (isset($parsedUrl['path'])) {
|
||
$path = $parsedUrl['path'];
|
||
|
||
// 移除可能的存储桶名称
|
||
$bucketName = env('GOOGLE_CLOUD_STORAGE_BUCKET', 'yjbfile');
|
||
$bucketPrefix = '/' . $bucketName . '/';
|
||
|
||
if (str_starts_with($path, $bucketPrefix)) {
|
||
return substr($path, strlen($bucketPrefix));
|
||
}
|
||
|
||
return ltrim($path, '/');
|
||
}
|
||
}
|
||
|
||
return $url;
|
||
}
|
||
}
|