huahuibao/biz/stat/classes/StatPdSubClass.php

<?php

namespace biz\stat\classes;

use biz\base\classes\BaseClass;
use biz\stat\models\StatPdSub;

class StatPdSubClass extends BaseClass
{

    public static $baseFile = '\biz\stat\models\StatPdSub';

    //获取总和 shish 20210829
    public static function getSum($where)
    {
        $amount = self::sum($where,'amount');
        return empty($amount) ? 0 : $amount;
    }

    //盘亏统计 shish 20210827
    public static function replace($shop, $amount, $date = null)
    {
        $sjId = $shop->sjId ?? 0;
        $shopId = $shop->id ?? 0;
        if ($date == null) {
            $time = date('Ymd');
        } else {
            $time = $date;
        }
        $stat = self::getByCondition(['sjId' => $sjId, 'shopId' => $shopId, 'time' => $time], true);
        if (empty($stat)) {
            $stat = self::add(['shopId' => $shopId, 'sjId' => $sjId, 'time' => $time, 'num' => 0], true);
        }
        $id = $stat->id;
        $unique = self::getLockById($id);
        $currentAmount = bcadd($unique->amount, $amount, 2);
        $unique->amount = $currentAmount;
        $unique->totalAmount = $shop->totalPdSub;
        $unique->num += 1;
        $unique->save();
        StatPdSubMonthClass::replace($shop, $amount, $time);
    }

}