ngds/common/models/ApproachReconsumeOrder.php

<?php

namespace common\models;

use Yii;

/**
 * This is the model class for table "{{%ORDER}}".
 *
 * @property string $ID
 * @property string $SN 订单号
 * @property string $DEC_SN 报单编号
 * @property string $USER_ID 用户ID
 * @property string $USER_NAME 会员编号
 * @property string $ORDER_TYPE 订货类型
 * @property string $ORDER_AMOUNT 订单总价格
 * @property string $PV 订货PV
 * @property string $PAY_AMOUNT 支付价格
 * @property string $PAY_PV 实付PV
 * @property int $PAY_AT 支付时间
 * @property string $PAY_TYPE 支付方式
 * @property string $FREIGHT 运费
 * @property string $PAY_FREIGHT 实付运费金额
 * @property int $DELIVERY_STATUS 发货状态
 * @property int $DELIVERY_PERIOD 发货期数
 * @property int $DELIVERY_AT 发货时间
 * @property string $EXPRESS_COMPANY 快递公司
 * @property string $ORDER_TRACK_NO 快递单号
 * @property int $EXPRESS_TYPE 发货方式
 * @property string $FRONT_REMARK 前台备注
 * @property string $REMARK 后台备注
 * @property int $PERIOD_NUM 期数
 * @property int $STATUS 订单状态
 * @property string $CONSIGNEE 收货人
 * @property string $MOBILE 收货人手机
 * @property string $TEL 固定电话
 * @property int $PROVINCE 省份名称
 * @property int $CITY 城市名称
 * @property int $COUNTY 县区
 * @property string $ADDRESS 详细地址
 * @property string $P_CALC_MONTH 分区日期
 * @property int $CREATED_AT 订单创建时间
 * @property string $CREATE_USER 订单创建人
 * @property int $UPDATED_AT 修改时间
 * @property string $UPDATER 修改人
 * @property int $IS_DELETE 是否删除
 * @property int $DELETED_AT 删除时间
 * @property int $WAREHOUSE 发货仓
 * @property string $EMAIL 邮箱
 * @property string $NOTE 备注说明
 * @property string $LGA_NAME LGA_NAME
 * @property string $CITY_NAME 城市
 * @property string $PAY_AMOUNT_STANDARD 支付价格
 * @property string $ORDER_AMOUNT_STANDARD 订单总价格($)
 * @property string $EXCHANGE_RATE 汇率
 * @property string $COUNTRY_ID 国家ID
 * @property int $CURRENCY_ID 币种ID
 * @property int $AUTO_MAINTENANCE AMP订单
 * @property string $DEC_USER_ID  会员编号
 */
class ApproachReconsumeOrder extends \common\components\ActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%APPROACH_ORDER}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['USER_ID', 'USER_NAME', 'ORDER_TYPE', 'CREATE_USER'], 'required'],
            [['ORDER_AMOUNT', 'PV', 'PAY_AMOUNT', 'PAY_PV', 'FREIGHT', 'PAY_FREIGHT'], 'number'],
            [['PAY_AT', 'DELIVERY_STATUS', 'DELIVERY_PERIOD', 'DELIVERY_AT', 'EXPRESS_TYPE', 'PERIOD_NUM', 'STATUS', 'PROVINCE', 'CITY', 'COUNTY', 'CREATED_AT', 'UPDATED_AT', 'IS_DELETE', 'DELETED_AT'], 'integer'],
            [['ID','SN', 'DEC_SN', 'USER_ID', 'ORDER_TRACK_NO','PAY_TYPE'], 'string', 'max' => 32],
            [['USER_NAME', 'TEL', 'CREATE_USER', 'UPDATER', 'WAREHOUSE'], 'string', 'max' => 16],
            [['ORDER_TYPE'], 'string', 'max' => 12],
            [['EXPRESS_COMPANY'], 'string', 'max' => 128],
            [['FRONT_REMARK'], 'string', 'max' => 1000],
            [['REMARK', 'NOTE'], 'string', 'max' => 4000],
            [['CONSIGNEE'], 'string', 'max' => 120],
            [['MOBILE'], 'string', 'max' => 15],
            [['ADDRESS'], 'string', 'max' => 255],
            [['SN'], 'unique'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'SN' => '订单号',
            'DEC_SN' => '报单编号',
            'USER_ID' => '用户ID',
            'USER_NAME' => '会员编号',
            'ORDER_TYPE' => '订货类型',
            'ORDER_AMOUNT' => '订单总价格',
            'PV' => '订货BV',
            'PAY_AMOUNT' => '支付价格',
            'PAY_PV' => '实付BV',
            'PAY_AT' => '支付时间',
            'PAY_TYPE' => '支付方式',
            'FREIGHT' => '运费',
            'PAY_FREIGHT' => '实付运费金额',
            'DELIVERY_STATUS' => '发货状态',
            'DELIVERY_PERIOD' => '发货期数',
            'DELIVERY_AT' => '发货时间',
            'EXPRESS_COMPANY' => '快递公司',
            'ORDER_TRACK_NO' => '快递单号',
            'EXPRESS_TYPE' => '发货方式',
            'FRONT_REMARK' => '前台备注',
            'REMARK' => '后台备注',
            'PERIOD_NUM' => '期数',
            'STATUS' => '订单状态',
            'CONSIGNEE' => '收货人',
            'MOBILE' => '收货人手机',
            'TEL' => '固定电话',
            'PROVINCE' => '省份名称',
            'CITY' => '城市名称',
            'COUNTY' => '县区',
            'LGA_NAME' => 'lga name',
            'CITY_NAME' => 'City name',
            'ADDRESS' => '详细地址',
            'P_CALC_MONTH' => '分区日期',
            'CREATED_AT' => '订单创建时间',
            'CREATE_USER' => '订单创建人',
            'UPDATED_AT' => '修改时间',
            'UPDATER' => '修改人',
            'IS_DELETE' => '是否删除',
            'DELETED_AT' => '删除时间',
            'WAREHOUSE' => '发货仓',
            'EMAIL' => 'Email',
            'AUTO_MAINTENANCE' => 'AMP',
        ];
    }

    public function getUserByUserId()
    {
        return $this->hasOne(User::class, ['ID' => 'USER_ID']);
    }
}