qimall/addons/ScoreBonus/common/models/ScoreBonusCapitalModel.php

<?php

namespace addons\ScoreBonus\common\models;

use Yii;
use common\models\base\BaseActiveRecord;
use yii\behaviors\TimestampBehavior;
use yii\db\Exception;
/**
 * This is the model class for table "{{%addon_default}}".
 */
class ScoreBonusCapitalModel extends BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_score_bonus_capital}}';
    }

    public function rules()
    {
        return [
            [['mall_id','order_id', 'status', 'created_at', 'bonus_pre', 'updated_at', 'date_time'], 'integer'],
            [['goods_price', 'bonus_price'], 'number'],
        ];
    }

    /**
     * 保存数据
     * @Author: lun
     * @DateTime: 2023/6/2 0002 15:53
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $params
     * @return bool
     */
    public static function setData(array $params)
    {
        try {
            $model = new self();
            $model->loadDefaultValues();
            if (!$model->load($params, '') || !$model->save()) throw new Exception($model->getErrorMessage());
            return $model;
        } catch (Exception $e) {
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    public static function getAllData($params)
    {
        $res = self::find()->where($params)->asArray()->all();
        return $res;
    }

    public static function getFieldSum($params = [], $sum = '*')
    {
        return self::find()->where($params)->sum($sum);
    }
}