82 lines
1.7 KiB
PHP
82 lines
1.7 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Support\Facades\Redis;
|
|
|
|
class ExchangeGoods extends Base
|
|
{
|
|
protected $fillable = [];
|
|
protected $guarded = [];
|
|
|
|
protected $hidden = ['updated_at','deleted_at'];
|
|
|
|
public const STOCKKEY = 'exchange_goods_stock';
|
|
|
|
public function getCacheStockAttribute()
|
|
{
|
|
return Redis::get(self::STOCKKEY.$this->id);
|
|
}
|
|
|
|
public function updateCacheStock()
|
|
{
|
|
Redis::set(self::STOCKKEY.$this->id, $this->stock);
|
|
}
|
|
|
|
public function scopeOrder($query)
|
|
{
|
|
$order = request()->order;
|
|
$order_type = request()->order_type;
|
|
return $query->orderBy($order, $order_type);
|
|
}
|
|
|
|
public function scopeIsSale($query)
|
|
{
|
|
return $query->where('is_sale', 1);
|
|
}
|
|
|
|
public function scopeIsntSale($query)
|
|
{
|
|
return $query->where('is_sale', 0);
|
|
}
|
|
|
|
public function scopeStock($query)
|
|
{
|
|
return $query->where('stock', '>', 0);
|
|
}
|
|
|
|
public function scopeShow($query)
|
|
{
|
|
return $query->isSale()->stock();
|
|
}
|
|
|
|
public function scopeSale($query)
|
|
{
|
|
$is_sale = request()->is_sale;
|
|
if ($is_sale) {
|
|
return $query->isSale();
|
|
}else {
|
|
return $query->isntSale();
|
|
}
|
|
}
|
|
|
|
public function scopeKeywords()
|
|
{ $keyword = request()->keyword;
|
|
return $this->where(function ($sql) use($keyword) {
|
|
$sql->where('title', 'like', '%'.$keyword.'%');
|
|
});
|
|
}
|
|
|
|
public function exchangeLogs()
|
|
{
|
|
return $this->hasMany(CoinExchange::class, 'goods_id', 'id');
|
|
}
|
|
|
|
public static function hasSaleGoods()
|
|
{
|
|
return self::isSale()->exists();
|
|
}
|
|
|
|
}
|