mall/models/ReportPoolLevel.php

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

use yii\db\ActiveRecord;
use yii\behaviors\TimestampBehavior;

use Yii;

/**
 * This is the model class for table "{{%bonus_pool_level}}".
 *
 * @property integer $id
 * @property integer $store_id
 * @property integer $pool_id
 * @property integer $money
 * @property integer $level_id
 * @property string $user_id
 * @property integer $is_send
 * @property integer $send_time
 * @property integer $created_at
 */
class ReportPoolLevel extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%report_pool_level}}';
    }

    public function behaviors()
    {
        return [
            [
                'class' => TimestampBehavior::class,
                'attributes' => [
                    ActiveRecord::EVENT_BEFORE_INSERT => ['created_at'],
                ]
            ]
        ];
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['store_id', 'pool_id', 'level', 'is_send', 'send_time','user_id','report_id','is_delete'], 'integer'],
            [['money'], 'number'],
            [['created_at'], 'safe']
        ];
    }

    public static function addProfitLog($store_id,$pool_id,$money,$user_id,$report_id,$remark,$level,$type)
    {

        if ($type == 1){
            $report_pool_level = new ReportPoolLevel();
            $report_pool_level->user_id = $user_id;
            $report_pool_level->store_id = $store_id;
            $report_pool_level->pool_id = $pool_id;
            $report_pool_level->money = $money;
            $report_pool_level->report_id = $report_id;
            $report_pool_level->remark = $remark;
            $report_pool_level->level = $level;
            $report_pool_level->created_at = time();
            $report_pool_level->is_send = 0;
            $report_pool_level->send_time = '';
            $report_pool_level->save();
        }else{

            //更新处理
            $report_pool_level = ReportPoolLevel::find()
                ->where(['report_id'=>$report_id,'store_id'=>$store_id,'pool_id'=>$pool_id,'user_id'=>$user_id,'level'=>$level,'is_send'=>0])
                ->one();

            if ($report_pool_level){

                $report_pool_level->money = $money;
                $report_pool_level->save();
            }else{
                return [
                    'code' => 1,
                    'msg' => '修改失败'
                ];
            }


        }

    }
}