qimall/addons/Agent/common/models/AgentSupplierCommission.php

<?php

namespace addons\Agent\common\models;

use addons\Agent\common\logic\reward\RewardSort;
use common\models\order\Order;
use common\models\user\User;
use Yii;

/**
 * This is the model class for table "qimall_addons_agent_supplier_commission".
 *
 * @property int    $id
 * @property int    $mall_id
 * @property int    $buy_user_id                 买家id
 * @property int    $buy_level                   买家身份
 * @property int    $seller_user_id              卖家id
 * @property int    $seller_level                卖家身份
 * @property string $order_no                    会员订单号
 * @property string $supplier_order_no           供应商订单号
 * @property int    $goods_nums                  商品数量
 * @property int    $stock_nums                  库存加减
 * @property float  $payment_amount              货款金额
 * @property float  $profit                      利润
 * @property int    $pay_time                    订单支付时间
 * @property int    $created_at                  添加时间戳
 * @property int    $updated_at                  更新时间戳
 * @property string $capital_type                奖励类型
 * @property string $sort_sort_capital_type      奖励类型
 */
class AgentSupplierCommission extends \common\models\base\BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return 'qimall_addons_agent_supplier_commission';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'buy_user_id', 'buy_level', 'seller_user_id', 'seller_level', 'goods_nums', 'stock_nums', 'pay_time', 'created_at', 'updated_at', 'source_table_id', 'status'], 'integer'],
            [['payment_amount', 'profit'], 'number'],
            [['order_no', 'supplier_order_no', 'source_table'], 'string', 'max' => 100],
            [['capital_type'], 'string', 'max' => 50],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id'                => 'ID',
            'mall_id'           => 'Mall ID',
            'buy_user_id'       => 'Buy User ID',
            'buy_level'         => 'Buy Level',
            'seller_user_id'    => 'Seller User ID',
            'seller_level'      => 'Seller Level',
            'order_no'          => 'Order No',
            'supplier_order_no' => 'Supplier Order No',
            'goods_nums'        => 'Goods Nums',
            'stock_nums'        => 'Stock Nums',
            'payment_amount'    => 'Payment Amount',
            'profit'            => 'Profit',
            'pay_time'          => 'Pay Time',
            'order_id'          => 'Order ID',
            'order_detail_id'   => 'Order Details ID',
            'created_at'        => 'Created At',
            'updated_at'        => 'Updated At',
            'capital_type'      => 'Capital Type',
            'sort_capital_type' => 'Sort Capital Type',
        ];
    }

    /**
     * 添加分佣记录数据
     */
    public static function insertData($params)
    {
        if (empty($params)) {
            return;
        }

        $insertData = [];

        $params = RewardSort::insertWalletSort($params);

        foreach ($params as $item) {
            $insertData[] = [
                'mall_id'           => $item['mall_id'],
                'buy_user_id'       => $item['buy_user_id'],
                'buy_level'         => $item['buy_level'],
                'seller_user_id'    => $item['seller_user_id'],
                'seller_level'      => $item['seller_level'],
                'order_no'          => $item['order_no'],
                'supplier_order_no' => $item['supplier_order_no'],
                'goods_nums'        => $item['goods_nums'],
                'stock_nums'        => $item['stock_nums'],
                'payment_amount'    => $item['payment_amount'],
                'profit'            => $item['profit'],
                'pay_time'          => $item['pay_time'],
                'source_table'      => $item['source_table'],
                'source_table_id'   => $item['source_table_id'],
                'capital_type'      => $item['capital_type'],
                'created_at'        => time(),
                'updated_at'        => time(),
            ];
        }

        Yii::$app->db->createCommand()->batchInsert(self::tableName(), array_keys($insertData[0]), $insertData)->execute();
    }

    public function getOrder()
    {
        return $this->hasOne(Order::class, ['order_no' => 'order_no']);
    }

    public function getBuyUser()
    {
        return $this->hasOne(User::class, ['id' => 'buy_user_id']);
    }

    public function getSellerUser()
    {
        return $this->hasOne(User::class, ['id' => 'seller_user_id']);
    }
}