admin/app/shop/model/order/Order.php
@@ -318,4 +318,16 @@ ->order(['order.create_time' => 'desc']) ->paginate($params); } public function getUserTotalConsumption($userId,$bonusData) { $model = $this; $model = $model->where('user_id', '=', $userId) ->where('pay_status', '=', 20) ->where('order_status', '=', 30) ->where('is_delete', '=', 0) ->where('create_time', '>=', strtotime($bonusData['start_time'])) ->where('create_time', '<=', strtotime($bonusData['end_time'])); return $model->sum('pay_price'); } }