mall/models/HangingOrder.php

<?php
/**
 * 厦门云联储网络科技有限公司
 * https://www.baokuaiyun.com
 * Copyright (c) 2023 爆块云 All rights reserved.
 */

namespace app\models;

/**
 * This is the model class for table "{{%hanging_order}}".
 *
 * @property integer $id
 * @property integer $store_id
 * @property integer $md_id
 * @property integer $user_id
 * @property string $order_no
 * @property integer $create_at
 * @property integer $is_delete
 * @property integer $status
 * @property double $total_price
 */
class HangingOrder extends \yii\db\ActiveRecord
{
    const ORDER_PREFIX = 'HO';

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

    public function rules()
    {
        return [
            [['store_id','user_id','order_no','create_at','is_delete','status','total_price'],'required'],
            [['store_id','user_id','create_at','is_delete','status', 'md_id'],'integer'],
            [['order_no'],'string'],
            [['total_price'],'number']
        ];
    }

    public function attributeLabels(){
        return [
            'store_id' => '商城ID',
            'md_id' => '门店id',
            'user_id' => '挂单用户ID',
            'order_no' => '挂单订单号',
            'create_at' => '挂单时间',
            'is_delete' => '删除标识',
            'status' => '挂单状态',
            'total_price' => '挂单订单总金额'
        ];
    }

    public function getOrderDetail(){
        return $this->hasMany(HangingOrderDetail::className(),['order_id'=>'id'])->where(['is_delete'=>0]);
    }

    public function getUser(){
        return $this->hasOne(User::className(),['id'=>'user_id'])->where(['is_delete'=>0])->select('id,nickname,binding');
    }
}