ZZCX_yii/common/models/BaseSupplierPurchase.php

<?php

namespace common\models;

use yii\db\ActiveRecord;

/**
 * This is the model class for table "base_supplier_purchase".
 *
 * @property integer $ID
 * @property integer $CREATE_USER_ID
 * @property string $CREATE_TIME
 * @property integer $UPDATE_USER_ID
 * @property string $UPDATE_TIME
 * @property integer $CANCEL_FLAG
 * @property integer $SUPPLIER_ID
 * @property integer $PRODUCT_TYPE
 * @property string $PURCHASER_NAME
 */
class BaseSupplierPurchase extends ActiveRecord
{
    const HOTEL = 25;           //酒店
    const MOTORCADE = 259;      //车队

    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'base_supplier_purchase';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['CREATE_USER_ID', 'UPDATE_USER_ID', 'CANCEL_FLAG', 'SUPPLIER_ID', 'PRODUCT_TYPE'], 'integer'],
            [['CREATE_TIME'], 'required'],
            [['UPDATE_TIME'], 'safe'],
            [['CREATE_TIME', 'PURCHASER_NAME'], 'string', 'max' => 20],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'CREATE_USER_ID' => '记录创建用户ID',
            'CREATE_TIME' => '记录创建时间',
            'UPDATE_USER_ID' => '记录最后更新用户ID',
            'UPDATE_TIME' => '记录最后更新时间',
            'CANCEL_FLAG' => '记录有效性标记，CANCEL_FLAG=0记录有效；CANCEL_FLAG=1，记录已删除',
            'SUPPLIER_ID' => '供应商或渠道商ID，对应BASE_SUPPLIER.ID',
            'PRODUCT_TYPE' => '采购产品类别',
            'PURCHASER_NAME' => '采购人',
        ];
    }

    /**
     * @return \yii\db\ActiveQuery 酒店
     */
    public function getUserName()
    {
        return $this->hasOne(User::className(), ['ID' => 'PURCHASER_NAME'])->from('base_user as User');
    }
}