<?php

namespace common\models;

use Yii;

/**
 * This is the model class for table "{{%CALC_BONUS_QY}}".
 *
 * @property string $ID
 * @property string $USER_ID 会员ID
 * @property string $LAST_DEC_LV 结算时会员级别
 * @property string $LAST_EMP_LV 结算时会员聘级
 * @property int $LAST_STATUS 结算时状态
 * @property string $AMOUNT 金额
 * @property int $PERIOD_NUM 结算期数
 * @property int $CALC_MONTH 所在结算月
 * @property int $CALCULATED_AT 结算时间
 * @property int $CREATED_AT 创建时间
 * @property string $LOGS 日志
 * @property $ORI_BONUS 原奖金
 * @property $RECONSUME_POINTS 重复消费积分
 * @property $MANAGE_TAX 管理费
 * @property int $IS_ACTIVE 是否活跃
 * @property string $HOPE_CROWN_LV 应有starCrown级别
 * @property string $HOPE_BONUS 应得奖金
 */
class CalcBonusQY extends \common\components\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%CALC_BONUS_QY}}';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['USER_ID', 'PERIOD_NUM', 'CALC_MONTH', 'CALCULATED_AT', 'CREATED_AT'], 'required'],
            [['AMOUNT', 'ORI_BONUS', 'RECONSUME_POINTS', 'MANAGE_TAX'], 'number'],
            [['LAST_STATUS', 'PERIOD_NUM', 'CALC_MONTH', 'CALCULATED_AT', 'CREATED_AT'], 'integer'],
            [['ID', 'USER_ID', 'LAST_DEC_LV', 'LAST_EMP_LV', 'LAST_CROWN_LV'], 'string', 'max' => 32],
            [['LOGS'], 'string', 'max' => 2000],
            [['ID'], 'unique'],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'USER_ID' => '会员ID',
            'LAST_DEC_LV' => '结算时会员级别',
            'LAST_EMP_LV' => '结算时会员聘级',
            'LAST_CROWN_LV' => '结算时会员星级',
            'LAST_STATUS' => '结算时状态',
            'AMOUNT' => '金额',
            'PERIOD_NUM' => '结算期数',
            'CALC_MONTH' => '所在结算月',
            'CALCULATED_AT' => '结算时间',
            'CREATED_AT' => '创建时间',
            'LOGS' => '日志',
            'ORI_BONUS' => '原奖金',
            'RECONSUME_POINTS' => '重复消费积分',
            'MANAGE_TAX' => '管理费',
        ];
    }

    public function getStarCrown()
    {
        return $this->hasOne(StarCrownLevel::class, ['ID' => 'LAST_CROWN_LV']);
    }
}