$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); } } }