@Select({
"<script>",
"select",
"count(1)",
"from `order`",
"where TO_DAYS( NOW( ) ) - TO_DAYS( gmt_create) <= 1 <if test=\"status != null \"> and status = #{status} </if> and adcode in",
"<foreach collection='adcode' item='id' open='(' separator=',' close=')'>",
"#{id}",
"</foreach>",
"</script>"
})
Long countYesterdayOrderStatus(@Param("status") Integer status, @Param("adcode") List<String> adcode);
@Select传集合参数
于 2022-08-15 17:23:27 首次发布