<?php
|
|
namespace app\models;
|
|
use Yii;
|
|
/**
|
* This is the model class for table "{{%user_card}}".
|
*
|
* @property int $id
|
* @property int $mall_id
|
* @property int $user_id
|
* @property int $card_id
|
* @property string $name 名称
|
* @property string $pic_url 图片
|
* @property string $content 详情
|
* @property int $is_delete 删除
|
* @property string $created_at
|
* @property string $updated_at
|
* @property string $deleted_at
|
* @property int $is_use 是否使用 0--未使用 1--已使用
|
* @property int $clerk_id 核销人id
|
* @property int $store_id 门店ID
|
* @property string $clerked_at 核销时间
|
* @property int $order_id 发放卡券的订单id
|
* @property int $order_detail_id 订单详情ID
|
* @property string $data 额外信息字段
|
* @property string $start_time
|
* @property string $end_time
|
* @property int $number
|
* @property int $use_number
|
* @property int $receive_id 转赠领取的用户id
|
* @property int $parent_card_id 转赠的用户卡券id
|
* @property GoodsCards $card
|
* @property Order $order
|
* @property OrderDetail $detail
|
* @property Store $store
|
* @property User $user
|
* @property GoodsCardClerkLog $clerkLog
|
* @property GoodsCardClerkLog $lastClerkLog
|
* @property string $remark
|
* @property User $receive 领取的用户
|
* @property User $from 卡券来源的用户
|
*/
|
class UserCard extends ModelActiveRecord
|
{
|
/**
|
* {@inheritdoc}
|
*/
|
public static function tableName()
|
{
|
return '{{%user_card}}';
|
}
|
|
/**
|
* {@inheritdoc}
|
*/
|
public function rules()
|
{
|
return [
|
[['mall_id', 'user_id', 'card_id', 'name', 'pic_url', 'content', 'created_at', 'updated_at', 'deleted_at', 'clerked_at'], 'required'],
|
[['mall_id', 'user_id', 'card_id', 'is_delete', 'is_use', 'clerk_id', 'store_id', 'order_id', 'order_detail_id', 'use_number', 'number', 'receive_id', 'parent_card_id'], 'integer'],
|
[['content', 'data'], 'string'],
|
[['created_at', 'updated_at', 'deleted_at', 'clerked_at', 'start_time', 'end_time'], 'safe'],
|
[['name', 'pic_url', 'remark'], 'string', 'max' => 255],
|
];
|
}
|
|
/**
|
* {@inheritdoc}
|
*/
|
public function attributeLabels()
|
{
|
return [
|
'id' => 'ID',
|
'mall_id' => 'Mall ID',
|
'user_id' => 'User ID',
|
'card_id' => 'Card ID',
|
'name' => '名称',
|
'pic_url' => '图片',
|
'content' => '详情',
|
'is_delete' => '删除',
|
'created_at' => 'Created At',
|
'updated_at' => 'Updated At',
|
'deleted_at' => 'Deleted At',
|
'is_use' => '是否使用 0--未使用 1--已使用',
|
'clerk_id' => '核销人id',
|
'store_id' => '门店ID',
|
'clerked_at' => ' 核销时间',
|
'order_id' => '发放卡券的订单id',
|
'order_detail_id' => '订单详情ID',
|
'data' => '额外信息字段',
|
'start_time' => 'Start Time',
|
'end_time' => 'End Time',
|
'number' => '核销总次数',
|
'use_number' => '已核销次数',
|
'remark' => '备注',
|
'receive_id' => '转赠领取的用户id',
|
'parent_card_id' => '转赠的用户卡券id',
|
];
|
}
|
|
public function getClerk()
|
{
|
return $this->hasOne(User::className(), ['id' => 'clerk_id']);
|
}
|
|
public function getStore()
|
{
|
return $this->hasOne(Store::className(), ['id' => 'store_id']);
|
}
|
|
public function getCard()
|
{
|
return $this->hasOne(GoodsCards::className(), ['id' => 'card_id']);
|
}
|
|
public function getUser()
|
{
|
return $this->hasOne(User::className(), ['id' => 'user_id']);
|
}
|
|
public function getOrder()
|
{
|
return $this->hasOne(Order::className(), ['id' => 'order_id']);
|
}
|
|
public function getDetail()
|
{
|
return $this->hasOne(OrderDetail::className(), ['id' => 'order_detail_id']);
|
}
|
|
public function getClerkLog()
|
{
|
return $this->hasMany(GoodsCardClerkLog::className(), ['user_card_id' => 'id']);
|
}
|
|
public function getLastClerkLog()
|
{
|
return $this->hasOne(GoodsCardClerkLog::className(), ['user_card_id' => 'id'])->orderBy(['clerked_at' => SORT_DESC]);
|
}
|
|
/**
|
* 兼容旧卡券
|
* @param UserCard $userCard
|
* @return array;
|
*/
|
public function getNewItem($userCard)
|
{
|
$data = [];
|
if ($userCard->is_use == 1 && $userCard->number - $userCard->use_number > 0) {
|
$data['use_number'] = $userCard->number;
|
}
|
|
$data['is_show_history'] = 0;
|
if ($userCard->is_use || $userCard->lastClerkLog) {
|
$data['is_show_history'] = 1;
|
}
|
|
if ($userCard->lastClerkLog) {
|
$data['store_name'] = $userCard->lastClerkLog->store->name;
|
$data['clerked_at'] = new_date($userCard->lastClerkLog->clerked_at);
|
}
|
|
return $data;
|
}
|
|
public function getReceive()
|
{
|
return $this->hasOne(User::className(), ['id' => 'receive_id']);
|
}
|
|
public function getFrom()
|
{
|
return $this->hasOne(User::className(), ['id' => 'user_id'])
|
->viaTable(UserCard::tableName(), ['id' => 'parent_card_id']);
|
}
|
}
|
