You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
2.1 KiB
82 lines
2.1 KiB
<?php
|
|
|
|
namespace addons\shopro\model;
|
|
|
|
use think\Model;
|
|
use traits\model\SoftDelete;
|
|
/**
|
|
* 用户收藏模型
|
|
*/
|
|
class UserFavorite extends Model
|
|
{
|
|
use SoftDelete;
|
|
|
|
protected $name = 'shopro_user_favorite';
|
|
// 开启自动写入时间戳字段
|
|
protected $autoWriteTimestamp = 'int';
|
|
// 定义时间戳字段名
|
|
protected $createTime = 'createtime';
|
|
protected $updateTime = 'updatetime';
|
|
protected $deleteTime = 'deletetime';
|
|
protected $hidden = ['createtime', 'updatetime'];
|
|
|
|
// 追加属性
|
|
protected $append = [
|
|
];
|
|
|
|
public static function edit($params)
|
|
{
|
|
extract($params);
|
|
$user = User::info();
|
|
//批量删除模式
|
|
if (isset($goods_ids)) {
|
|
foreach ($goods_ids as $g) {
|
|
self::get(['goods_id' => $g, 'user_id' => $user->id])->delete();
|
|
}
|
|
return false;
|
|
}
|
|
//单商品默认反向增删
|
|
$favorite = self::get(['goods_id' => $goods_id, 'user_id' => $user->id]);
|
|
if ($favorite) {
|
|
$favorite->delete();
|
|
return false;
|
|
}else{
|
|
self::create([
|
|
'user_id' => $user->id,
|
|
'goods_id' => $goods_id
|
|
]);
|
|
return true;
|
|
}
|
|
}
|
|
|
|
public static function getGoodsList()
|
|
{
|
|
$user = User::info();
|
|
|
|
// 商品物理删除的，直接删掉
|
|
self::whereNotExists(function ($query) {
|
|
$goodsTableName = (new Goods())->getQuery()->getTable();
|
|
$tableName = (new self())->getQuery()->getTable();
|
|
$query = $query->table($goodsTableName)->where($goodsTableName . '.id=' . $tableName . '.goods_id');
|
|
|
|
return $query;
|
|
})->where([
|
|
'user_id' => $user->id
|
|
])->delete();
|
|
|
|
$favoriteData = self::with(['goods' => function ($query) {
|
|
$query->removeOption('soft_delete');
|
|
}])->where([
|
|
'user_id' => $user->id
|
|
])->order('createtime', 'DESC')->paginate(10);
|
|
|
|
return $favoriteData;
|
|
}
|
|
|
|
public function goods()
|
|
{
|
|
return $this->belongsTo(Goods::class, 'goods_id', 'id');
|
|
}
|
|
|
|
|
|
}
|
|
|