huahuibao/biz/stat/classes/StatOutMonthClass.php

<?php
/**
 * User: admin
 * Date Time: 2021/4/13 21:37
 */

namespace biz\stat\classes;

use biz\base\classes\BaseClass;
use common\components\dateUtil;

class StatOutMonthClass extends BaseClass
{
    public static $baseFile = '\biz\stat\models\StatOutMonth';

    public static function updateOrInsert($sjId,$shopId,$amount)
    {
        $time = date('Ym');
        $year = date('Y');
        $month = date('m');
        $where = [
            'merchantId'=>$sjId,
            'shopId'=>$shopId,
            'year'=>$year,
            'month'=>$month,
            'time'=>$time,
        ];
        $model = self::getByCondition($where);
        if($model){
            $id = $model['id'];
            //累加金额 amount
            $newAmount = bcadd($amount,$model['amount'],2);
            $totalAmount = bcadd($amount,$model['totalAmount'],2);
            self::updateById($id,['amount'=>$newAmount,'totalAmount'=>$totalAmount]);
        }else{
            //insert
            $data = $where;
            $data['amount'] = $amount;
            //totalAmount = 前一天的 totalAmount
            $totalAmount = 0;
            $lastTime =  date('Ym',strtotime("-1 month"));
            $lastWhere = [
                'merchantId'=>$sjId,
                'shopId'=>$shopId,
                'time'=>$lastTime,
            ];
            $lastModel = self::getByCondition($lastWhere);
            if($lastModel){
                $totalAmount = $lastModel['totalAmount'];
            }
            $data['totalAmount'] = bcadd($amount,$totalAmount,2);
            $data['createTime'] = date('Y-m-d H:i:s');
            self::add($data);
        }
    }
}