ngds/common/models/PerfOrder.php

<?php

namespace common\models;

use common\helpers\snowflake\SnowFake;
use common\helpers\Tool;
use Yii;
use yii\base\Exception;

/**
 * This is the model class for table "{{%PERF_ORDER}}".
 *
 * @property string $ID
 * @property string $SN 业绩单编号
 * @property string $PERF_TYPE 业绩单类型
 * @property string $USER_ID 产生业绩会员ID
 * @property string $PV 业绩单PV
 * @property string $DEC_USER_ID 报单者ID
 * @property string $ORDER_AMOUNT 支付金额
 * @property int $PERIOD_NUM 所在期数
 * @property int $CALC_MONTH 结算月
 * @property int $CREATED_AT 创建时间
 * 
 */
class PerfOrder extends \common\components\ActiveRecord
{
    //业绩单状态
    const STATUS_NORMAL = 1; //正常
    const STATUS_CLOSED = 2; //置废
    const ZC_TYPE = "ZC";
    const FX_TYPE = "FX";
    const STATUS_NAME = [
      self::STATUS_NORMAL=>'Audited',//已审核
      self::STATUS_CLOSED=>'置废',
    ];
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%PERF_ORDER}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['SN', 'PERF_TYPE', 'USER_ID', 'PERIOD_NUM', 'CALC_MONTH', 'CREATED_AT'], 'required'],
            [['PERIOD_NUM', 'CALC_MONTH', 'CREATED_AT'], 'integer'],
            [['PV', 'ORDER_AMOUNT'], 'number'],
            [['SN'], 'unique'],
            [['ID'], 'unique'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'SN' => '业绩单编号',
            'PERF_TYPE' => '业绩单类型',
            'USER_ID' => '产生业绩会员ID',
            'PV' => '业绩单BV',
            'ORDER_AMOUNT' => '报单金额',
            'DEC_USER_ID' => '报单主体ID',
            'PERIOD_NUM' => '所在期数',
            'CALC_MONTH' => '结算月',
            'CREATED_AT' => '创建时间',
        ];
    }

    /**
     * 获取当前最大的订单编号
     * @return mixed
     */
    public static function getMaxSn(){
        return static::find()->where('1=1')->max('SN');
    }

    /**
     * 生成sn
     * @return string
     */
    public static function generateSN() {
        return  SnowFake::instance()->generateId();
    }
}