public Map countOrder(@Param("orderIds") List<Long> orderIds,@Param("map") Map map);

<select id="countOrder" resultType="java.util.HashMap" >
        select count(id) as orders,IFNULL(count(DISTINCT user_id),0) as buyers,IFNULL(sum(order_price),0) as price
        from wp_order
        <where>
        id in
        <foreach item="id"
                 collection="orderIds"
                 open="("
                 separator=","
                 close=")">
            #{id}
        </foreach>
            <if test="map.addTime != null and map.addTime != ''">
                AND date_format( add_time,'%y%m%d')= date_format(#{map.addTime},'%y%m%d')
            </if>
            <if test="map.beginTime != null and map.beginTime != ''"><!-- 开始时间检索 -->
                AND date_format( add_time,'%y%m%d') >= date_format(#{map.beginTime},'%y%m%d')
            </if>
            <if test="map.endTime != null and map.endTime != ''"><!-- 结束时间检索 -->
                AND date_format( add_time,'%y%m%d') <= date_format(#{map.endTime},'%y%m%d')
            </if>
        </where>
</select>