mall/models/StoreDividendsCycleUserSub.php

<?php

namespace app\models;
use yii\behaviors\TimestampBehavior;/**
 * This is the model class for table "{{%store_dividends_cycle_user_sub}}".
 *
 * @property integer $id
 * @property integer $dividends_cycle_id
 * @property integer $dividends_user_id
 * @property float   $dividends_integral
 * @property string  $created_at
 * @property string  $updated_at

 */
class StoreDividendsCycleUserSub extends \yii\db\ActiveRecord
{


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

    public function rules()
    {
        return [
            [['id', 'dividends_cycle_id', 'dividends_user_id'], 'integer'],
            [['dividends_integral', 'created_at', 'updated_at'], 'number']
        ];
    }

    public function behaviors()
    {
        return [
            [
                'class' => TimestampBehavior::class
            ]
        ];
    }

    public function attributeLabels()
    {
        return [
            'id' => '',
            'dividends_cycle_id' => '分红期数ID ',
            'dividends_user_id' => '某店分红用户ID',
            'dividends_integral' => '积分数量',
            'created_at' => '创建时间',
            'updated_at' => '修改时间'
        ];
    }

    public static function addCycleUserSub($dividends_cycle_id) {

        $user_list = StoreDividendsUser::find()->where(['>', 'dividends_integral', 0])
            ->select('id, dividends_integral')->asArray()->all();
        foreach ($user_list as $item) {
            $storeDividendsCycleUserSub = StoreDividendsCycleUserSub::findOne([
                'dividends_cycle_id' => $dividends_cycle_id,
                'dividends_user_id' => $item['id']
            ]) ?: new StoreDividendsCycleUserSub();
            $storeDividendsCycleUserSub->dividends_cycle_id = $dividends_cycle_id;
            $storeDividendsCycleUserSub->dividends_user_id = $item['id'];
            $storeDividendsCycleUserSub->dividends_integral = $item['dividends_integral'];
            $storeDividendsCycleUserSub->save();
        }
    }


}