KORAIL_STORE

[API] /near_mall_list

1.issue

• check why productShowYn condition is not applied
• should apply this condition

[MallMapper.xml - line 111]

<if test="params.productShowYn != null"> AND show_yn = #{params.productShowYn} </if>

2.server log

2024-08-28 20:23:37,164 DEBUG [com.stoneitgt.user.mapper.MallMapper.countNearMallList] ==>  Preparing: 

SELECT COUNT(A.mall_code)
FROM st_mall A
LEFT JOIN st_station B ON B.station_code = A.station_code
LEFT JOIN (
SELECT H.mall_code, GROUP_CONCAT(H.working_hour_yn) AS working_hour_yn, GROUP_CONCAT(H.hour) AS mall_hours
FROM (
SELECT h.*, CONCAT(h.start_hour, ' ~ ', h.end_hour) AS HOUR, CASE WHEN h.hour_type = 'HT01' THEN IF(DATE_FORMAT(NOW(), '%H:%i') > h.start_hour AND DATE_FORMAT(NOW(), '%H:%i') < h.end_hour, 'Y', 'N') ELSE 'N' END AS working_hour_yn
FROM st_mall_hour h
ORDER BY h.sort_no) AS H
GROUP BY H.mall_code) C ON C.mall_code = A.mall_code
WHERE A.mall_type = ? AND A.show_yn = ? 
    AND A.mall_code IN (
        SELECT mall_code
        FROM st_product
        WHERE krs_bar_cd = ?) 
AND B.longitude IS NOT NULL AND B.latitude IS NOT NULL AND (B.latitude >= -90 AND B.latitude <= 90) AND (B.longitude >= -180 AND B.longitude <= 180)

2024-08-28 20:23:37,164 DEBUG [com.stoneitgt.user.mapper.MallMapper.countNearMallList] ==> Parameters: store(String), Y(String), 77780539570(String)