-
mentioned in commit 9d80f8b1
Showing
1 changed file
fw-valhalla-dao/src/main/resources/mapper/CustomerMapper.xml
... | ... | @@ -359,8 +359,8 @@ |
359 | 359 | <select id="queryShopCusCnt" |
360 | 360 | parameterType="cn.fw.valhalla.sdk.param.CusCntReq" |
361 | 361 | resultType="cn.fw.valhalla.sdk.result.CusCntResult"> |
362 | - select t1.shop_id,COUNT(t1.id) | |
363 | - from customer t1 | |
362 | + select t1.shop_id as id,COUNT(t1.id) as cnt | |
363 | + from customer t1 | |
364 | 364 | where t1.yn = 1 |
365 | 365 | <if test="req.shopIds !=null and req.shopIds.size() != 0"> |
366 | 366 | and t1.shop_id in |
... | ... | @@ -374,7 +374,7 @@ |
374 | 374 | <select id="queryAdviserCusCnt" |
375 | 375 | parameterType="cn.fw.valhalla.sdk.param.CusCntReq" |
376 | 376 | resultType="cn.fw.valhalla.sdk.result.CusCntResult"> |
377 | - select t1.adviser_id,COUNT(t1.id) | |
377 | + select t1.adviser_id as id,COUNT(t1.id) as cnt | |
378 | 378 | from customer t1 |
379 | 379 | where t1.yn = 1 |
380 | 380 | <if test="req.adviserIds !=null and req.adviserIds.size() != 0"> | ... | ... |