qimall/addons/Store/common/models/StoreCouponStatistics.php

<?php

namespace addons\Store\common\models;

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

/**
 * This is the model class for table "qimall_addons_store_coupon_statistics".
 *
 * @property int $id
 * @property int $mall_id
 * @property int $store_id
 * @property int $coupon_id
 * @property int $received_number 已领取数量
 * @property int $used_number 已使用数量
 * @property int $giveing_times 优惠券被转赠的次数
 * @property float $use_probability 优惠券使用率，等于领取数量比使用数量
 * @property float $total_discount_amount 累计优惠金额
 * @property int $receive_user_number 领券会员总数量
 * @property int $use_user_number 用券会员总数量
 * @property int $giving_user_number 转赠优惠券的会员总数量
 * @property int $use_order_number 使用优惠券支付的订单总数量
 * @property float $total_use_coupon_payed_amount 使用优惠券后实际支付的总金额
 * @property float $total_payed_amount 使用优惠券支付的订单原价总金额
 * @property int $status 状态[-1:删除;0:禁用;1启用]
 * @property int $created_at 创建时间
 * @property int $updated_at
 */
class StoreCouponStatistics extends BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_store_coupon_statistics}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id','store_id', 'coupon_id'], 'required'],
            [['mall_id', 'coupon_id', 'received_number', 'used_number', 'giveing_times', 'receive_user_number', 'use_user_number', 'giving_user_number', 'use_order_number', 'status', 'created_at', 'updated_at'], 'integer'],
            [['use_probability', 'total_discount_amount', 'total_use_coupon_payed_amount', 'total_payed_amount'], 'number'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => 'Mall ID',
            'coupon_id' => 'Coupon ID',
            'received_number' => '已领取数量',


            'giveing_times' => '优惠券被转赠的次数',
            'use_probability' => '优惠券使用率，等于领取数量比使用数量',

            'used_number' => '已使用数量',
            'total_discount_amount' => '累计优惠金额',
            'use_user_number' => '用券会员总数量',

            'use_order_number' => '使用优惠券支付的订单总数量',
            'total_use_coupon_payed_amount' => '使用优惠券后实际支付的总金额',
            'total_payed_amount' => '使用优惠券支付的订单原价总金额',

            'status' => '状态[-1:删除;0:禁用;1启用]',
            'created_at' => '创建时间',
            'updated_at' => 'Updated At',

            'receive_user_number' => '领券会员总数量',
            'giving_user_number' => '转赠优惠券的会员总数量',
        ];
    }
    public static function setData($params)
    {
        try {
            if (empty($params['mall_id']))   return false;
            $model = self::findOne(['mall_id' => $params['mall_id'],'coupon_id' => $params['coupon_id'],'store_id' => $params['store_id'], 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]);
            if (empty($model)) {
                $model = new self();
                $model->mall_id = $params['mall_id'];
                $model->coupon_id = $params['coupon_id'];
                $model->store_id = $params['store_id'];
                $model->loadDefaultValues();
            }
            if (!empty($params['received_number'])) $model->received_number += $params['received_number'];
            if (!empty($params['used_number'])){
                $model->used_number += $params['used_number'];
                if($model->used_number<0) $model->used_number= 0;
                if(!empty($model->received_number)){
                    $model->use_probability =  bcdiv($model->used_number,$model->received_number,2);
                }
            }
            if (!empty($params['giveing_times'])) $model->giveing_times += $params['giveing_times'];
            if (!empty($params['total_discount_amount'])){
                $model->total_discount_amount += $params['total_discount_amount'];
                if($model->total_discount_amount<0) $model->total_discount_amount = 0;
            }
            if (!empty($params['receive_user_number'])) $model->receive_user_number += $params['receive_user_number'];
            if (!empty($params['use_user_number'])) {
                $model->use_user_number += $params['use_user_number'];
                if($model->use_user_number<0) $model->use_user_number = 0;
            }
            if (!empty($params['giving_user_number'])) $model->giving_user_number += $params['giving_user_number'];
            if (!empty($params['use_order_number'])) {
                $model->use_order_number += $params['use_order_number'];
                if($model->use_order_number<0) $model->use_order_number = 0;
            }
            if (!empty($params['total_use_coupon_payed_amount'])) {
                $model->total_use_coupon_payed_amount += $params['total_use_coupon_payed_amount'];
                if($model->total_use_coupon_payed_amount<0) $model->total_use_coupon_payed_amount = 0;
            }
            if (!empty($params['total_payed_amount'])){
                $model->total_payed_amount += $params['total_payed_amount'];
                if( $model->total_payed_amount<0)$model->total_payed_amount = 0;
            }

            if (!$model->save()) throw new \Exception($model->getErrorMessage());
            return $model;
        } catch (\Exception $e) {
            self::$static_error = $e->getMessage();
            return false;
        }
    }
}