qimall/addons/LuckyGroup/common/models/LuckyGroupFrozenLog.php

<?php

namespace addons\LuckyGroup\common\models;

use common\models\base\BaseActiveRecord;
use Yii;

/**
 * This is the model class for table "qimall_addons_lucky_group_frozen_log".
 *
 * @property int $id
 * @property int $mall_id 商城ID
 * @property int $user_id 用户ID
 * @property int $level 拼团等级
 * @property int $source_id 来源ID
 * @property string $source_table 来源表
 * @property float $money 金额
 * @property int $is_send 是否发放  0未发放  1已发放  2部分发放
 * @property int $prize_type 奖励类型  1参团奖励  2拼中奖励  3奖金池奖励  4渠道奖佣金奖  5平级佣金奖  6越级佣金奖  7推荐奖
 * @property string $money_type 资金类型   余额balance  积分score  佣金commission
 * @property string $extra 额外信息
 * @property string $desc 描述
 * @property int $status 状态[-1:删除;0:禁用;1启用]
 * @property int $created_at
 * @property int $updated_at
 * @property float $has_money 已发放金额
 * @property int $settlement_interval 结算周期   1 每天  2 每周一  3 每月一号
 * @property float $bonus_pool_sum 奖金池总额
 * @property float $bonus_pool_ratio 奖金池比例
 * @property int $preliminary_win_num 初步拼中次数
 * @property float|null $bonus_pool_limit 奖金池上限
 * @property int $bonus_log_id 结算奖金池记录id
 */
class LuckyGroupFrozenLog extends BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_lucky_group_frozen_log}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'user_id', 'level', 'source_id', 'is_send', 'prize_type', 'status', 'created_at', 'updated_at', 'settlement_interval', 'preliminary_win_num','bonus_log_id'], 'integer'],
            [['money', 'has_money', 'bonus_pool_sum', 'bonus_pool_ratio', 'bonus_pool_limit'], 'number'],
            [['source_table'], 'string', 'max' => 45],
            [['money_type'], 'string', 'max' => 64],
            [['extra'], 'string', 'max' => 1000],
            [['desc'], 'string', 'max' => 255],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城ID',
            'user_id' => '用户ID',
            'level' => '拼团等级',
            'source_id' => '来源ID',
            'source_table' => '来源表',
            'money' => '金额',
            'is_send' => '是否发放  0未发放  1已发放  2部分发放',
            'prize_type' => '奖励类型  1参团奖励  2拼中奖励  3奖金池奖励  4渠道奖佣金奖  5平级佣金奖  6越级佣金奖  7推荐奖',
            'money_type' => '资金类型   余额balance  积分score  佣金commission',
            'extra' => '额外信息',
            'desc' => '描述',
            'status' => '状态[-1:删除;0:禁用;1启用]',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'has_money' => '已发放金额',
            'settlement_interval' => '结算周期   1 每天  2 每周一  3 每月一号',
            'bonus_pool_sum' => '奖金池总额',
            'bonus_pool_ratio' => '奖金池比例',
            'preliminary_win_num' => '初步拼中次数',
            'bonus_pool_limit' => '奖金池上限',
            'bonus_log_id' => '结算奖金池记录id',
        ];
    }

    public static function batchAdd($frozen_log_arr){
        $field = ['mall_id', 'user_id','level','source_id','source_table','money','is_send','prize_type','money_type',
            'extra','desc','status','created_at','updated_at','has_money','settlement_interval','bonus_pool_sum','bonus_pool_ratio',
            'preliminary_win_num','bonus_pool_limit','bonus_log_id'
        ];
        // 批量插入数据
        Yii::$app->db->createCommand()->batchInsert(self::tableName(), $field, $frozen_log_arr)->execute();
    }
}