查询各种状态的限购码总数接口

接口名： /limitCode/getLimitCodeCountByStatus

方法

POST JSONRAW

入参

无

对应SQL的操作库表

<select id="getLimitCodeCountGroupByStatus" resultType="java.util.Map" parameterType="com.yohobuy.platform.dal.promotion.model.LimitCodeReq" >
    select status,count(1) count from limit_code 
    where 1=1

    <if test="batchNo != null and batchNo != ''" >
      and batchno like '%' #{batchNo,jdbcType=VARCHAR} '%'
    </if>

    <if test="name != null and name != ''" >
      and name like '%' #{name,jdbcType=VARCHAR} '%'
    </if>

    <if test="reqDepartment != null and reqDepartment != ''" >
      and req_department like '%' #{reqDepartment,jdbcType=VARCHAR} '%'
    </if>
    group by status
  </select>

响应码

---

响应码code	消息	说明
200	getLimitCodeCountByStatus success.

返回

{
    "code": 200,
    "message": "",
    "data": {
        "code": 200,
        "data": {
            "0": "4",
            "1": "47",
            "3": "355",
            "4": "160",
            "all": "566"
        },
        "md5": "8b638040da9314d16a20facaf1ec3713",
        "message": "getLimitCodeCountByStatus success."
    }
}