huahuibao/common/services/xhStatIncomeMonthService.php

<?php

namespace common\services;

use common\components\stringUtil;
use Yii;
use common\models\xhStatIncomeMonth;
use common\components\configDict;

class xhStatIncomeMonthService
{

    /**
     * 添加与更新
     */
    public static function replace($merchantId, $totalFee, $payWay)
    {
        $year = date("Y");
        $month = date("n");
        $time = date("Ym");
        $income = self::getByTime($merchantId, $time);
        $weixin = 0;
        $alipay = 0;
        $balancePay = 0;
        $cash = 0;
        $addTime = time();

        $payList = configDict::getConfig('payWay');
        if ($payList['weixinPay'] == $payWay) {
            $weixin = $totalFee;
        } elseif ($payWay == $payList['alipay']) {
            $alipay = $totalFee;
        } elseif ($payWay == $payList['balancePay']) {
            $balancePay = $totalFee;
        } elseif ($payWay == $payList['cashPay']) {
            $cash = $totalFee;
        } elseif ($payWay == $payList['mini']) {
            $weixin = $totalFee;
        }

        if (empty($income)) {
            $data = ['year' => $year,
                'month' => $month,
                'time' => $time,
                'amount' => $totalFee,
                'merchantId' => $merchantId,
                'addTime' => $addTime,
                'weixin' => $weixin,
                'alipay' => $alipay,
                'balancePay' => $balancePay,
                'cash' => $cash,
            ];
            self::add($data);
        } else {
            $amount = stringUtil::calcAdd($income['amount'], $totalFee);
            $weixin = stringUtil::calcAdd($income['weixin'], $weixin);
            $cash = stringUtil::calcAdd($income['cash'], $cash);
            $balancePay = stringUtil::calcAdd($income['balancePay'], $balancePay);
            $alipay = stringUtil::calcAdd($income['alipay'], $alipay);
            $data = [
                'amount' => $amount,
                'weixin' => $weixin,
                'alipay' => $alipay,
                'balancePay' => $balancePay,
                'cash' => $cash,
            ];
            self::updateByIds($merchantId, $year, $month, $data);
        }
    }

    public static function updateByIds($merchantId, $year, $month, $data)
    {
        xhStatIncomeMonth::updateByCondition(['year' => $year, 'month' => $month, 'merchantId' => $merchantId], $data);
        self::getByIds($merchantId, $year, $month);
        $cacheKey = configDict::getCacheKey('xhStatIncomeMonth') . '_' . $merchantId . '_' . $year . '_' . $month;
        $params = [$cacheKey];
        if (!empty($data)) {
            foreach ($data as $key => $val) {
                $params[] = $key;
                $params[] = $val;
            }
        }
        Yii::$app->redis->executeCommand('HMSET', $params);
        return self::getByIds($merchantId, $year, $month);
    }

    public static function add($data)
    {
        $return = xhStatIncomeMonth::add($data);
        return $return;
    }

    public static function getByIds($merchantId, $year, $month)
    {
        $income = xhStatIncomeMonth::find()->where(['merchantId' => $merchantId, 'year' => $year, 'month' => $month])->asArray()->one();
        return $income;
    }

    public static function getByTime($merchantId, $time)
    {
        $income = xhStatIncomeMonth::find()->where(['merchantId' => $merchantId, 'time' => $time])->asArray()->one();
        return $income;
    }

    /**
     * 获取本月收入
     */
    public static function getMonthIncome($merchantId, $year, $month)
    {
        $income = self::getByIds($merchantId, $year, $month);
        $amount = 0;
        if (!empty($income)) {
            $amount = $income['amount'];
        }
        return $amount;
    }

}