{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["전송데이터-상품","CATE4SRCH조회","기획전이벤트쿼리","인기검색어","자동완성검색어외","카테고리","검색필터","상품리스트","기획전","이벤트"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"전송데이터-상품","index":0,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[[0,0,0,5],[60,0,60,5]]}
["전체 색인용 테이블 : TB_GOODS_SEARCH(일배치)"]
["컬럼명","#","Data Type","Not Null","Key","디폴트","Comment"]
["GOODS_CD",1,"varchar(20)",true,"PRI","[NULL]","상품코드"]
["OPT_CD1",2,"varchar(200)",true,"PRI","'XX'","자사-옵션코드1,입점-XX"]
["GOODS_NM",3,"varchar(200)",true,"[NULL]","[NULL]","상품명"]
["GOODS_TNM",4,"varchar(100)",false,"[NULL]","[NULL]","상품타이틀명"]
["GOODS_GB",5,"varchar(20)",false,"[NULL]","[NULL]","상품구분(공통코드 G073)"]
["FOREIGN_BUY_YN",6,"char(1)",true,"[NULL]","'N'","해외구매대행여부"]
["PARALLEL_IMPORT_YN",7,"char(1)",true,"[NULL]","'N'","병행수입여부"]
["ORDER_MADE_YN",8,"char(1)",true,"[NULL]","'N'","주문제작여부"]
["BRAND_CD",9,"varchar(5)",true,"[NULL]","[NULL]","브랜드코드"]
["ITEMKIND_CD",10,"varchar(10)",true,"[NULL]","[NULL]","품목코드"]
["FORMAL_GB",11,"varchar(20)",true,"[NULL]","[NULL]","정상이월구분(공통코드G009)"]
["LIST_PRICE",12,"int",true,"[NULL]","[NULL]","정상가(최초판매가)"]
["CURR_PRICE",13,"int",true,"[NULL]","[NULL]","현재판매가"]
["SELF_GOODS_YN",14,"char(1)",true,"[NULL]","[NULL]","자사상품여부"]
["GOODS_STAT",15,"varchar(20)",true,"[NULL]","[NULL]","상품상태(공통코드G008)"]
["SEX_GB",16,"varchar(20)",true,"[NULL]","[NULL]","성별구분(공통코드G007)"]
["MAIN_COLOR_CD",17,"varchar(2)",false,"[NULL]","[NULL]","대표색상코드"]
["SUPPLY_COMP_CD",18,"varchar(20)",true,"[NULL]","[NULL]","공급업체코드"]
["SELF_MALL_YN",19,"char(1)",true,"[NULL]","'Y'","자사몰노출여부"]
["AGE_GRP_CD",20,"varchar(20)",false,"[NULL]","[NULL]","상품연령대(공통코드 G023)"]
["SEASON_CD",21,"varchar(20)",false,"[NULL]","[NULL]","시즌코드(공통코드G006)"]
["GOODS_TYPE",22,"varchar(20)",true,"[NULL]","[NULL]","상품타입(공통코드G056)"]
["REG_DT",23,"timestamp",true,"[NULL]","[NULL]","등록일시"]
["BRAND_GROUP_KNM",24,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹국문명"]
["BRAND_GROUP_ENM",25,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹영문명"]
["BRAND_GROUP_NM",26,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹명(전시)"]
["BRAND_GROUP_NO",27,"int unsigned",true,"[NULL]","[NULL]","브랜드그룹번호"]
["DEFAULT_CATE_YN",28,"char(1)",true,"[NULL]","'Y'","기본전시카테고리여부(N:별도카테고리)"]
["BRAND_CATE_NO",29,"int unsigned",false,"[NULL]","[NULL]","브랜드카테고리번호"]
["ORDER_CNT",30,"int unsigned",true,"[NULL]",0,"주간판매수량"]
["REVIEW_CNT",31,"int unsigned",true,"[NULL]",0,"상품평등록건수"]
["SIZE_GB",32,"varchar(1)",false,"[NULL]","[NULL]","사이즈구분(T:상의,B:하의,S:신발)"]
["SIZE_GB_NM",33,"varchar(2)",false,"[NULL]","[NULL]","사이즈구분명(T:상의,B:하의,S:신발)"]
["SIZES",34,"mediumtext",false,"[NULL]","[NULL]","옵션2(자사는색상별,입점은상품별)"]
["COLOR_CD",35,"varchar(200)",false,"[NULL]","[NULL]","검색용 색상코드값(공통코드G072)-자사용"]
["COLOR_CHIP",36,"varchar(500)",false,"[NULL]","[NULL]","검색용 RGB값(공통코드)-자사용"]
["BENEFIT_GB",37,"varchar(100)",true,"[NULL]","[NULL]","혜택구분(,구분)(10:쿠폰할인,20:무료배송,30:사은품,40:신상,50:총알배송)"]
["PC_CURR_PRICE",38,"int",false,"[NULL]",0,"PC즉시할인판매가"]
["MO_CURR_PRICE",39,"int",false,"[NULL]",0,"MOBILE즉시할인판매가"]
["APP_CURR_PRICE",40,"int",false,"[NULL]",0,"APP즉시할인판매가"]
["AD_KEYWORD",41,"varchar(1000)",false,"[NULL]","[NULL]","키워드(,구분)"]
["VIDEO_GB_M",42,"varchar(1)",false,"[NULL]","[NULL]","첫번째동영상구분(Y:유투브,M:MP4)"]
["VIDEO_VAL_M",43,"varchar(50)",false,"[NULL]","[NULL]","첫번째동영상값(동영상구분이Y이면유투브ID,M이면동영상Kollus의media_content_key)"]
["VIDEO_GB_S",44,"varchar(1)",false,"[NULL]","[NULL]","두번째동영상구분(Y:유투브,M:MP4)"]
["VIDEO_VAL_S",45,"varchar(50)",false,"[NULL]","[NULL]","두번째동영상값(동영상구분이Y이면유투브ID,M이면동영상Kollus의media_content_key)"]
["BYITEM_CATE_NO",46,"varchar(500)",false,"[NULL]","[NULL]","BYITEM카테고리(,구분)"]
["BYBRAND_CATE_NO",47,"varchar(500)",false,"[NULL]","[NULL]","BYBRAND카테고리(,구분)"]
["SYS_IMG_NM",48,"varchar(241)",false,"[NULL]","[NULL]","대표이미지(도메인포함)"]
["SYS_IMG_NM2",49,"varchar(241)",false,"[NULL]","[NULL]","마우스오버이미지(도메인포함)"]
["SELL_STDT",50,"DATETIME",true,"[NULL]","NOW()","판매시작일시"]
["SELL_EDDT",51,"DATETIME",true,"[NULL]","NOW()","판매종료일시"]
["STOCK_QTY",52,"int",false,"[NULL]",0,"재고수량(전시)"]
["OPT_CD1_CHIP",53,"varchar(500)",true,"[NULL]","[NULL]","옵션1의 색상의 RGB값-자사용"]
["PROC_GB",54,"char(1)",true,"[NULL]","[NULL]","업무구분(C:등록,수정,D:삭제)"]
["DATA_REG_DT",55,"timestamp",true,"[NULL]","CURRENT_TIMESTAMP","데이터등록일시"]
["DATA_UPD_DT",56,"timestamp",true,"[NULL]","CURRENT_TIMESTAMP","데이터수정일시"]
[]
[]
["부분 색인용 테이블 : TB_GOODS_SEARCH_SECTION(시간배치)"]
["컬럼명","#","Data Type","Not Null","Key","디폴트","Comment"]
["GOODS_CD",1,"varchar(20)",true,"PRI","[NULL]","상품코드"]
["OPT_CD1",2,"varchar(200)",true,"PRI","'XX'","자사-옵션코드1,입점-XX"]
["GOODS_NM",3,"varchar(200)",true,"[NULL]","[NULL]","상품명"]
["GOODS_TNM",4,"varchar(100)",false,"[NULL]","[NULL]","상품타이틀명"]
["GOODS_GB",5,"varchar(20)",false,"[NULL]","[NULL]","상품구분(공통코드 G073)"]
["FOREIGN_BUY_YN",6,"char(1)",true,"[NULL]","'N'","해외구매대행여부"]
["PARALLEL_IMPORT_YN",7,"char(1)",true,"[NULL]","'N'","병행수입여부"]
["ORDER_MADE_YN",8,"char(1)",true,"[NULL]","'N'","주문제작여부"]
["BRAND_CD",9,"varchar(5)",true,"[NULL]","[NULL]","브랜드코드"]
["ITEMKIND_CD",10,"varchar(10)",true,"[NULL]","[NULL]","품목코드"]
["FORMAL_GB",11,"varchar(20)",true,"[NULL]","[NULL]","정상이월구분(공통코드G009)"]
["LIST_PRICE",12,"int",true,"[NULL]","[NULL]","정상가(최초판매가)"]
["CURR_PRICE",13,"int",true,"[NULL]","[NULL]","현재판매가"]
["SELF_GOODS_YN",14,"char(1)",true,"[NULL]","[NULL]","자사상품여부"]
["GOODS_STAT",15,"varchar(20)",true,"[NULL]","[NULL]","상품상태(공통코드G008)"]
["SEX_GB",16,"varchar(20)",true,"[NULL]","[NULL]","성별구분(공통코드G007)"]
["MAIN_COLOR_CD",17,"varchar(2)",false,"[NULL]","[NULL]","대표색상코드"]
["SUPPLY_COMP_CD",18,"varchar(20)",true,"[NULL]","[NULL]","공급업체코드"]
["SELF_MALL_YN",19,"char(1)",true,"[NULL]","'Y'","자사몰노출여부"]
["AGE_GRP_CD",20,"varchar(20)",false,"[NULL]","[NULL]","상품연령대(공통코드 G023)"]
["SEASON_CD",21,"varchar(20)",false,"[NULL]","[NULL]","시즌코드(공통코드G006)"]
["GOODS_TYPE",22,"varchar(20)",true,"[NULL]","[NULL]","상품타입(공통코드G056)"]
["REG_DT",23,"timestamp",true,"[NULL]","[NULL]","등록일시"]
["BRAND_GROUP_KNM",24,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹국문명"]
["BRAND_GROUP_ENM",25,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹영문명"]
["BRAND_GROUP_NM",26,"varchar(50)",true,"[NULL]","[NULL]","브랜드그룹명(전시)"]
["BRAND_GROUP_NO",27,"int unsigned",true,"[NULL]","[NULL]","브랜드그룹번호"]
["DEFAULT_CATE_YN",28,"char(1)",true,"[NULL]","'Y'","기본전시카테고리여부(N:별도카테고리)"]
["BRAND_CATE_NO",29,"int unsigned",false,"[NULL]","[NULL]","브랜드카테고리번호"]
["ORDER_CNT",30,"int unsigned",true,"[NULL]",0,"주간판매수량"]
["REVIEW_CNT",31,"int unsigned",true,"[NULL]",0,"상품평등록건수"]
["SIZE_GB",32,"varchar(1)",false,"[NULL]","[NULL]","사이즈구분(T:상의,B:하의,S:신발)"]
["SIZE_GB_NM",33,"varchar(2)",false,"[NULL]","[NULL]","사이즈구분명(T:상의,B:하의,S:신발)"]
["SIZES",34,"mediumtext",false,"[NULL]","[NULL]","옵션2(자사는색상별,입점은상품별)"]
["COLOR_CD",35,"varchar(200)",false,"[NULL]","[NULL]","검색용 색상코드값(공통코드G072)-자사용"]
["COLOR_CHIP",36,"varchar(500)",false,"[NULL]","[NULL]","검색용 RGB값(공통코드)-자사용"]
["BENEFIT_GB",37,"varchar(100)",true,"[NULL]","[NULL]","혜택구분(,구분)(10:쿠폰할인,20:무료배송,30:사은품,40:신상,50:총알배송)"]
["PC_CURR_PRICE",38,"int",false,"[NULL]",0,"PC즉시할인판매가"]
["MO_CURR_PRICE",39,"int",false,"[NULL]",0,"MOBILE즉시할인판매가"]
["APP_CURR_PRICE",40,"int",false,"[NULL]",0,"APP즉시할인판매가"]
["AD_KEYWORD",41,"varchar(1000)",false,"[NULL]","[NULL]","키워드(,구분)"]
["VIDEO_GB_M",42,"varchar(1)",false,"[NULL]","[NULL]","첫번째동영상구분(Y:유투브,M:MP4)"]
["VIDEO_VAL_M",43,"varchar(50)",false,"[NULL]","[NULL]","첫번째동영상값(동영상구분이Y이면유투브ID,M이면동영상Kollus의media_content_key)"]
["VIDEO_GB_S",44,"varchar(1)",false,"[NULL]","[NULL]","두번째동영상구분(Y:유투브,M:MP4)"]
["VIDEO_VAL_S",45,"varchar(50)",false,"[NULL]","[NULL]","두번째동영상값(동영상구분이Y이면유투브ID,M이면동영상Kollus의media_content_key)"]
["BYITEM_CATE_NO",46,"varchar(500)",false,"[NULL]","[NULL]","BYITEM카테고리(,구분)"]
["BYBRAND_CATE_NO",47,"varchar(500)",false,"[NULL]","[NULL]","BYBRAND카테고리(,구분)"]
["SYS_IMG_NM",48,"varchar(241)",false,"[NULL]","[NULL]","대표이미지(도메인포함)"]
["SYS_IMG_NM2",49,"varchar(241)",false,"[NULL]","[NULL]","마우스오버이미지(도메인포함)"]
["SELL_STDT",50,"DATETIME",true,"[NULL]","NOW()","판매시작일시"]
["SELL_EDDT",51,"DATETIME",true,"[NULL]","NOW()","판매종료일시"]
["STOCK_QTY",52,"int",false,"[NULL]",0,"재고수량(전시)"]
["PROC_GB",53,"char(1)",true,"[NULL]","[NULL]","업무구분(C:등록,수정,D:삭제)"]
["DATA_REG_DT",54,"timestamp",true,"[NULL]","CURRENT_TIMESTAMP","데이터등록일시"]
["DATA_UPD_DT",55,"timestamp",true,"[NULL]","CURRENT_TIMESTAMP","데이터수정일시"]

{"sheet":"CATE4SRCH조회","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["카테고리 조회"]
["SELECT SITE_CD"]
["    ,CATE_GB"]
["    ,LEAF_CATE_NO"]
["    ,CATE_TYPE"]
["    ,CATE1_NO"]
["    ,CATE1_NM"]
["    ,CATE2_NO"]
["    ,CATE2_NM"]
["    ,CATE3_NO"]
["    ,CATE3_NM"]
["    ,CATE4_NO"]
["    ,CATE4_NM"]
["    ,CATE5_NO"]
["    ,CATE5_NM"]
["    ,FULL_CATE_NO"]
["    ,FULL_CATE_NM"]
["    ,DISP_ORD"]
["    ,FORMAL_GB"]
["    ,CONTENTS_LOC"]
["FROM TB_CATE_4SRCH"]
["WHERE CATE_TYPE = 'G031_10'  -- 상품 카테고리"]
["AND SITE_CD = 'G000_10'  -- STYLE24"]
["AND LEAF_CATE_NO = 해당 카테코드"]
[]
[]
[]
[]
[]
[]
["공통코드 조회"]
["SELECT CD_NM"]
["FROM   TB_COMMON_CODE"]
["WHERE  CD_GB = 그룹코드"]
["AND    CD = 조회코드"]

{"sheet":"기획전이벤트쿼리","index":2,"n_rows":67,"n_cols":4,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["WITH TAB_PLAN AS ("]
[null,"SELECT PLAN_SQ "]
[null,", PLAN_NM "]
[null,", DTL_TITLE1 "]
[null,", PLAN_GB   -- P: 기획전/ 그외 이벤트 (E: 이벤트, S:총알배송, C:출석체크)"]
[null,", FRONT_GB "]
[null,", DISP_STDT "]
[null,", DISP_EDDT "]
[null,", MAIN_PIMG "]
[null,", MAIN_MIMG "]
[null,", OPEN_YN "]
[null,", (SELECT GROUP_CONCAT(CUST_GRADE) FROM TB_PLAN_CUST_GRADE WHERE PLAN_SQ  = A.PLAN_SQ) AS PLAN_CUST_GRADE"]
[null,", (SELECT GROUP_CONCAT(CUST_GB) FROM TB_PLAN_CUST_DIVISION WHERE PLAN_SQ  = A.PLAN_SQ) AS PLAN_CUST_DIVISION"]
[null,"FROM  TB_PLAN A"]
[null,"WHERE 1 = 1 "]
[null," AND NOW() < DISP_EDDT "]
[null,"AND SITE_CD = 'G000_10'"]
[null,"AND FRONT_GB IN ('A', 'P')  -- PC용 ( A:ALL, P:웹)"]
[null," -- AND FRONT_GB IN ('A', 'M')  -- 모바일용(A:ALL,M:모바일)"]
[null,"AND DEL_YN  = 'N'"]
[")"]
[", TAB_PLAN_DETAIL AS ("]
[null,"SELECT PLAN_SQ "]
[null,null,", PLAN_DTL_SQ "]
[null,null,", DISP_STDT "]
[null,null,", DISP_EDDT "]
[null,null,", DISP_YN"]
[null,"FROM ("]
[null,null,"SELECT B.PLAN_SQ "]
[null,null,", B.PLAN_DTL_SQ "]
[null,null,", B.DISP_STDT "]
[null,null,", B.DISP_EDDT "]
[null,null,", B.DISP_YN"]
[null,null,", RANK() OVER(PARTITION BY B.PLAN_SQ  ORDER BY B.DISP_ORD, B.PLAN_DTL_SQ DESC) ROWNUM"]
[null,null,"FROM TAB_PLAN A"]
[null,null,"INNER JOIN TB_PLAN_DETAIL B ON A.PLAN_SQ = B.PLAN_SQ "]
[null,null,"                            AND NOW() < B.DISP_EDDT "]
[null,null,") Z"]
[null,"WHERE ROWNUM = 1"]
[")"]
[", TAB_PLAN_GOODS AS ("]
[null,"SELECT PLAN_SQ  "]
[null,", PLAN_DTL_SQ"]
[null,", GROUP_CONCAT(GOODS_CD) AS GOODS_CD"]
[null,"FROM ("]
[null,null,"SELECT PLAN_SQ "]
[null,null,", GOODS_CD"]
[null,null,", PLAN_DTL_SQ"]
[null,null,"FROM ("]
[null,null,null,"SELECT A.PLAN_SQ"]
[null,null,null,", A.PLAN_DTL_SQ"]
[null,null,null,", B.GOODS_CD"]
[null,null,null,", RANK() OVER(PARTITION BY A.PLAN_SQ  ORDER BY B.DISP_ORD, B.GOODS_CD DESC) ROWNUM"]
[null,null,null,"FROM TAB_PLAN_DETAIL A"]
[null,null,null,"INNER JOIN TB_PLAN_GOODS B ON A.PLAN_DTL_SQ = B.PLAN_DTL_SQ"]
[null,null,null,"                           AND B.DEL_YN  ='N'"]
[null,null,") Z"]
[null,null,"WHERE ROWNUM <= 10"]
[null,") X"]
[null,"GROUP BY PLAN_SQ ,PLAN_DTL_SQ    "]
[")"]
["SELECT A.*"]
["     , B.PLAN_DTL_SQ"]
["     , B.GOODS_CD"]
["FROM TAB_PLAN A"]
["LEFT OUTER JOIN TAB_PLAN_GOODS B ON A.PLAN_SQ = B.PLAN_SQ"]
[";"]

{"sheet":"인기검색어","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,2,4,9],[16,0,16,15],[17,0,17,12],[17,13,17,15],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8],[3,0,3,15]]}
["기능명",{"$nulls":8},"인기검색어 리스트"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"검색 레이어 팝업에서 호출 (지난 1주일간 검색된 검색어 상위 30위까지 중 랜덤 10개)"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"trendList",{"$nulls":6},"인기검색어목록","String","N",null,"OUT"]
[3,null,null,"["]
[4,"•",null,null,"{"]
[5,{"$nulls":4},"keyword",{"$nulls":4},"인기검색어","String","Y",null,"OUT"]
[6,{"$nulls":4},"prevRank",{"$nulls":4},"이전랭킹","String","Y",null,"OUT"]
[7,{"$nulls":4},"ranking",{"$nulls":4},"랭킹","String","Y",null,"OUT"]
[8,null,null,null,"}"]
[9,null,null,"]"]
[10,null,"}"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
[{"$nulls":13},"{"]
[{"$nulls":13},"    \"trendList\":["]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"keyword:\"갤럭시\","]
[{"$nulls":13},"            \"prevRank\":1,"]
[{"$nulls":13},"            \"ranking\":1"]
[{"$nulls":13},"        },"]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"keyword:\"사고\","]
[{"$nulls":13},"            \"prevRank\":5,"]
[{"$nulls":13},"            \"ranking\":2"]
[{"$nulls":13},"        },"]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"keyword:\"문의\","]
[{"$nulls":13},"            \"prevRank\":2,"]
[{"$nulls":13},"            \"ranking\":3"]
[{"$nulls":13},"        }"]
[{"$nulls":13},"    ]"]
[{"$nulls":13},"}"]

{"sheet":"자동완성검색어외","index":4,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[[4,2,4,9],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8],[3,0,3,15],[8,0,8,15],[9,2,9,9],[47,0,47,15],[48,0,48,12],[48,13,48,15]]}
["기능명",{"$nulls":8},"자동완성 검색어, 브랜드, 카테고리, 관련상품 리스트"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"검색 레이어 팝업에서 호출"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"keyword",{"$nulls":6},"검색어","String","Y",null,"IN"]
[3,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"autoKeywords",{"$nulls":6},"자동완성검색어배열","String[]","N",null,"OUT","최대 10개 노출\n콤마(,)로 구분된 검색어 문자열"]
[3,null,null,"brand",{"$nulls":6},"브랜드 정보",{"$nulls":4},"1개 노출"]
[4,null,null,"{"]
[5,null,null,null,"brandGroupNo",{"$nulls":5},"브랜드그룹번호","Integer","N",null,"OUT"]
[6,null,null,null,"brandGroupNm",{"$nulls":5},"브랜드그룹명","String","N",null,"OUT"]
[7,null,null,"}"]
[8,null,null,"cateList",{"$nulls":6},"카테고리목록",{"$nulls":4},"최대 3개 노출"]
[9,null,null,"["]
[10,"•",null,null,"{"]
[11,{"$nulls":4},"cate1No",{"$nulls":4},"카테고리1번호","Integer","N",null,"OUT"]
[11,{"$nulls":4},"cate1Nm",{"$nulls":4},"카테고리1명","String","N",null,"OUT"]
[11,{"$nulls":4},"cate2No",{"$nulls":4},"카테고리2번호","Integer","N",null,"OUT"]
[11,{"$nulls":4},"cate2Nm",{"$nulls":4},"카테고리2명","String","N",null,"OUT"]
[11,{"$nulls":4},"cate3No",{"$nulls":4},"카테고리3번호","Integer","N",null,"OUT"]
[11,{"$nulls":4},"cate3Nm",{"$nulls":4},"카테고리3명","String","N",null,"OUT"]
[13,null,null,null,"}"]
[14,null,null,"]"]
[15,null,null,"goodsList",{"$nulls":6},"관련상품목록",{"$nulls":4},"최대 6개 노출"]
[16,null,null,"["]
[17,"•",null,null,"{"]
[18,{"$nulls":4},"brandGroupNm",{"$nulls":4},"브랜드그룹명","String","Y",null,"OUT"]
[19,{"$nulls":4},"goodsCd",{"$nulls":4},"상품코드","String","Y",null,"OUT"]
[20,{"$nulls":4},"goodsFullNm",{"$nulls":4},"상품FULL명","String","Y",null,"OUT"]
[21,{"$nulls":4},"goodsTnm",{"$nulls":4},"상품타이틀명","String","Y",null,"OUT"]
[22,{"$nulls":4},"listPrice",{"$nulls":4},"정상가","int","Y",null,"OUT","최초소비자가"]
[23,{"$nulls":4},"currPrice",{"$nulls":4},"현재판매가","int","Y",null,"OUT","즉시할인쿠폰이 적용된 판매가"]
[24,{"$nulls":4},"sysImgNm",{"$nulls":4},"상품시스템이미지명","String","N",null,"OUT","썸네일 기본 이미지"]
[25,{"$nulls":4},"sysImgNm2",{"$nulls":4},"상품시스템이미지명2","String","N",null,"OUT","썸네일 마우스오버 이미지"]
[26,{"$nulls":4},"videos",{"$nulls":4},"동영상들","String","N",null,"OUT","등록일자 순으로 2개만\n형식: 동영상구분(M:MP4, Y:유투브):미디어컨텐츠키,동영상구분(M:MP4, Y:유투브):미디어컨텐츠키...\n예) M:164MyIiv,M:164Mxkea"]
[27,{"$nulls":4},"colorChips",{"$nulls":4},"컬러칩들","String","N",null,"OUT","컬러칩 정렬순서 순으로\n형식: 색상코드:컬러칩,색상코드:컬러칩...\n예) LB:#00A1E9,BK:#000000"]
[28,{"$nulls":4},"sizes",{"$nulls":4},"사이즈들","String","N",null,"OUT","사이즈 정렬순서 순으로\n형식: 사이즈코드:품절여부,사이즈코드:품절여부...\n예) 64:N,67:N,70:N"]
[29,{"$nulls":4},"benefits",{"$nulls":4},"혜택들","String","N",null,"OUT","혜택구분 순으로\n형식: 혜택구분:혜택명,혜택구분:혜택명...\n예) 10:쿠폰할인,30:사은품"]
[30,null,null,null,"}"]
[31,null,null,"]"]
[32,null,"}"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
["{",{"$nulls":12},"{"]
["    \"keyword\" : \"니트\"",{"$nulls":12},"    \"autoKeywords\": [ \"티셔츠\",\"남성 티셔츠\",\"여성 티셔츠\",\"키즈 티셔츠\" ],"]
["}",{"$nulls":12},"    \"brand\":{"]
[{"$nulls":13},"        \"brandGroupNo\":14255,"]
[{"$nulls":13},"        \"brandGroupNm\":\"ANDEW\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    \"cateList\":["]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"cate1No\":1100,"]
[{"$nulls":13},"            \"cate1Nm\":\"여성\","]
[{"$nulls":13},"            \"cate2No\":1105,"]
[{"$nulls":13},"            \"cate2Nm\":\"데님\","]
[{"$nulls":13},"            \"cate3No\":1107,"]
[{"$nulls":13},"            \"cate3Nm\":\"쇼츠/반바지/9부\","]
[{"$nulls":13},"        },"]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"cate1No\":1100,"]
[{"$nulls":13},"            \"cate1Nm\":\"여성\","]
[{"$nulls":13},"            \"cate2No\":1101,"]
[{"$nulls":13},"            \"cate2Nm\":\"니트/가디건/베스트\","]
[{"$nulls":13},"            \"cate3No\":1103,"]
[{"$nulls":13},"            \"cate3Nm\":\"니트\","]
[{"$nulls":13},"        }"]
[{"$nulls":13},"    ],"]
[{"$nulls":13},"    \"goodsList\":["]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"brandGroupNm\":\"FRJ\","]
[{"$nulls":13},"            \"goodsCd\":\"A83F-DP568S\","]
[{"$nulls":13},"            \"goodsFullNm\":\"여성 M톤워싱세미부컷 청바지 (A83F-DP568S)\","]
[{"$nulls":13},"            \"goodsTnm\":\"\","]
[{"$nulls":13},"            \"listPrice\":69000,"]
[{"$nulls":13},"            \"listPrice\":13900,"]
[{"$nulls":13},"            \"sysImgNm\":\"0000004806/20200330/14019445_L.jpg\","]
[{"$nulls":13},"            \"sysImgNm\":\"0000004806/20200330/14019445_1_L.jpg\","]
[{"$nulls":13},"            \"videos\":\"Y:720o0rj0bco\","]
[{"$nulls":13},"            \"colorChips\":\"MB:#00A1E9\","]
[{"$nulls":13},"            \"sizes\":\"64:N,67:N,70:N\","]
[{"$nulls":13},"            \"benefits\":\"40:신상,50:총알배송\","]
[{"$nulls":13},"        },"]
[{"$nulls":13},"        {"]
[{"$nulls":13},"            \"brandGroupNm\":\"FRJ\","]
[{"$nulls":13},"            \"goodsCd\":\"A83F-DP645H\","]
[{"$nulls":13},"            \"goodsFullNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\","]
[{"$nulls":13},"            \"goodsTnm\":\"\","]
[{"$nulls":13},"            \"listPrice\":59000,"]
[{"$nulls":13},"            \"listPrice\":13900,"]
[{"$nulls":13},"            \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\","]
[{"$nulls":13},"            \"sysImgNm\":\"0000004806/20200330/11867577_1_L.jpg\","]
[{"$nulls":13},"            \"videos\":\"\","]
[{"$nulls":13},"            \"colorChips\":\"LB:#00A1E9\","]
[{"$nulls":13},"            \"sizes\":\"67:N,70:N,73:N\","]
[{"$nulls":13},"            \"benefits\":\"40:신상,50:총알배송\","]
[{"$nulls":13},"        }"]
[{"$nulls":13},"    ]"]
[{"$nulls":13},"}"]

{"sheet":"카테고리","index":5,"n_rows":125,"n_cols":17,"rows_kept":125,"cut":false,"hidden":false,"merged":[[52,0,52,16],[53,14,53,16],[53,0,53,13],[4,2,4,10],[13,2,13,10],[12,0,12,16],[0,0,0,9],[1,0,1,9],[2,0,2,9],[1,14,1,15],[3,0,3,16]]}
["기능명",{"$nulls":9},"카테고리 목록"]
["Class",{"$nulls":9},"SearchService",null,null,null,"메소드명",null,"getCategoryGoodsList"]
["설명",{"$nulls":9},"카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트, 상품검색 화면에서 호출"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":8},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"cate1No",{"$nulls":7},"카테고리1번호","Integer","N",null,"IN","대카테고리번호\n※ 카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트에서는 필수"]
[3,null,null,"keyword",{"$nulls":7},"검색어","String","N",null,"IN","검색 화면에서 사용됨\n※ 상품검색 화면에서 필수"]
[4,null,null,"brandGroupNo",{"$nulls":7},"브랜드그룹번호","Integer","N",null,"IN","브랜드 카테고리상품리스트 화면에서 사용"]
[5,null,null,"formalGb",{"$nulls":7},"정상이월구분","String","N",null,"IN","아울렛 상품리스트 화면에서 사용"]
[6,null,null,"defaultCateYn",{"$nulls":7},"기본카테고리사용여부","String","N",null,"IN","Y일 때는 품목카테고리, N일 때는 브랜드카테고리 정보 조회"]
[7,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":8},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"["]
[2,null,null,"{"]
[3,null,null,null,"cate1No",{"$nulls":6},"카테고리1번호","Integer","Y",null,"OUT","대카테고리번호"]
[4,null,null,null,"cate1Nm",{"$nulls":6},"카테고리1명","String","Y",null,"OUT"]
[5,null,null,null,"leafYn",{"$nulls":6},"단말여부","String","Y",null,"OUT"]
[6,null,null,null,"cate2List",{"$nulls":6},"카테고리2목록","String","N",null,"OUT","중카테고리 목록"]
[7,null,null,null,"["]
[8,"•",null,null,null,"{"]
[9,{"$nulls":5},"cate2No",{"$nulls":4},"카테고리2번호","Integer","Y",null,"OUT"]
[10,{"$nulls":5},"cate2Nm",{"$nulls":4},"카테고리2명","String","Y",null,"OUT"]
[11,{"$nulls":5},"cate1No",{"$nulls":4},"카테고리1번호","Integer","Y",null,"OUT"]
[12,{"$nulls":5},"leafYn",{"$nulls":4},"단말여부","String","Y",null,"OUT"]
[13,{"$nulls":5},"cate3List",{"$nulls":4},"카테고리3목록","String","N",null,"OUT","소카테고리 목록"]
[14,{"$nulls":5},"["]
[15,"•",{"$nulls":5},"{"]
[16,{"$nulls":7},"cate3No",null,null,"카테고리3번호","Integer","Y",null,"OUT"]
[17,{"$nulls":7},"cate3Nm",null,null,"카테고리3명","String","Y",null,"OUT"]
[18,{"$nulls":7},"cate1No",null,null,"카테고리1번호","Integer","Y",null,"OUT"]
[19,{"$nulls":7},"cate2No",null,null,"카테고리2번호","Integer","Y",null,"OUT"]
[20,{"$nulls":7},"leafYn",null,null,"단말여부","String","Y",null,"OUT"]
[21,{"$nulls":7},"cate4List",null,null,"카테고리4목록","String","N",null,"OUT","세카테고리 목록"]
[22,{"$nulls":7},"["]
[23,"•",{"$nulls":7},"{"]
[24,{"$nulls":9},"cate4No","카테고리4번호","Integer","Y",null,"OUT"]
[25,{"$nulls":9},"cate4Nm","카테고리4명","String","Y",null,"OUT"]
[26,{"$nulls":9},"cate1No","카테고리1번호","Integer","Y",null,"OUT"]
[27,{"$nulls":9},"cate2No","카테고리2번호","Integer","Y",null,"OUT"]
[28,{"$nulls":9},"cate3No","카테고리3번호","Integer","Y",null,"OUT"]
[29,{"$nulls":9},"leafYn","단말여부","String","Y",null,"OUT"]
[30,{"$nulls":8},"}"]
[31,{"$nulls":7},"]"]
[32,{"$nulls":6},"}"]
[33,{"$nulls":5},"]"]
[34,{"$nulls":4},"}"]
[35,null,null,null,"]"]
[36,null,null,"}"]
[37,null,"]"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":13},"Response"]
["{",{"$nulls":13},"["]
["    \"cate1No\" : 1300,",{"$nulls":13},"    {"]
["    \"keyword\" : \"\",",{"$nulls":13},"        \"cate1No\":1100,"]
["    \"brandGroupNo\" : 0,",{"$nulls":13},"        \"cate1Nm\":\"여성\","]
["    \"formalGb\" : \"\",",{"$nulls":13},"        \"leafYn\":\"N\","]
["    \"defaultCateYn\" : \"Y\",",{"$nulls":13},"        \"cate2List\":["]
["}",{"$nulls":13},"            {"]
[{"$nulls":14},"                \"cate2No\":1101,"]
[{"$nulls":14},"                \"cate2Nm\":\"니트/가디건/베스트\","]
[{"$nulls":14},"                \"cate1No\":1100,"]
[{"$nulls":14},"                \"leafYn\":\"N\","]
[{"$nulls":14},"                \"cate3List\":["]
[{"$nulls":14},"                    {"]
[{"$nulls":14},"                        \"cate3No\":1103,"]
[{"$nulls":14},"                        \"cate3Nm\":\"니트\","]
[{"$nulls":14},"                        \"cate1No\":1100,"]
[{"$nulls":14},"                        \"cate2No\":1101,"]
[{"$nulls":14},"                        \"leafYn\":\"Y\""]
[{"$nulls":14},"                    },"]
[{"$nulls":14},"                    {"]
[{"$nulls":14},"                        \"cate3No\":1104,"]
[{"$nulls":14},"                        \"cate3Nm\":\"베스트/조끼\","]
[{"$nulls":14},"                        \"cate1No\":1100,"]
[{"$nulls":14},"                        \"cate2No\":1101,"]
[{"$nulls":14},"                        \"leafYn\":\"Y\""]
[{"$nulls":14},"                    }"]
[{"$nulls":14},"                ]"]
[{"$nulls":14},"            },"]
[{"$nulls":14},"            {"]
[{"$nulls":14},"                \"cate2No\":1105,"]
[{"$nulls":14},"                \"cate2Nm\":\"데님\","]
[{"$nulls":14},"                \"cate1No\":1100,"]
[{"$nulls":14},"                \"leafYn\":\"N\","]
[{"$nulls":14},"                \"cate3List\":["]
[{"$nulls":14},"                    {"]
[{"$nulls":14},"                        \"cate3No\":1106,"]
[{"$nulls":14},"                        \"cate3Nm\":\"부츠컷/와이드\","]
[{"$nulls":14},"                        \"cate1No\":1100,"]
[{"$nulls":14},"                        \"cate2No\":1105,"]
[{"$nulls":14},"                        \"leafYn\":\"Y\""]
[{"$nulls":14},"                    },"]
[{"$nulls":14},"                    {"]
[{"$nulls":14},"                        \"cate3No\":1107,"]
[{"$nulls":14},"                        \"cate3Nm\":\"쇼츠/반바지/9부\","]
[{"$nulls":14},"                        \"cate1No\":1100,"]
[{"$nulls":14},"                        \"cate2No\":1105,"]
[{"$nulls":14},"                        \"leafYn\":\"N\","]
[{"$nulls":14},"                        \"cate4List\":["]
[{"$nulls":14},"                            {"]
[{"$nulls":14},"                                \"cate4No\":1134,"]
[{"$nulls":14},"                                \"cate4Nm\":\"가방/모자/잡화\","]
[{"$nulls":14},"                                \"cate1No\":1100,"]
[{"$nulls":14},"                                \"cate2No\":1130,"]
[{"$nulls":14},"                                \"cate3No\":1133,"]
[{"$nulls":14},"                                \"leafYn\":\"Y\""]
[{"$nulls":14},"                            },"]
[{"$nulls":14},"                            {"]
[{"$nulls":14},"                                \"cate4No\":1135,"]
[{"$nulls":14},"                                \"cate4Nm\":\"운동화/등산화\","]
[{"$nulls":14},"                                \"cate1No\":1100,"]
[{"$nulls":14},"                                \"cate2No\":1130,"]
[{"$nulls":14},"                                \"cate3No\":1133,"]
[{"$nulls":14},"                                \"leafYn\":\"Y\""]
[{"$nulls":14},"                            }"]
[{"$nulls":14},"                        ]"]
[{"$nulls":14},"                    }"]
[{"$nulls":14},"                ]"]
[{"$nulls":14},"            }"]
[{"$nulls":14},"        ]"]
[{"$nulls":14},"    }"]
[{"$nulls":14},"]"]

{"sheet":"검색필터","index":6,"n_rows":89,"n_cols":16,"rows_kept":89,"cut":false,"hidden":false,"merged":[[4,2,4,9],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8],[3,0,3,15],[15,0,15,15],[16,2,16,9],[25,0,25,15],[26,0,26,12],[26,13,26,15]]}
["기능명",{"$nulls":8},"검색필터"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트, 상품검색 화면에서 호출"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"cate1No",{"$nulls":6},"카테고리1번호","Integer","N",null,"IN","대카테고리번호\n※ 카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트에서는 필수"]
[3,null,null,"cate2No",{"$nulls":6},"카테고리2번호","Integer","N",null,"IN","중카테고리번호"]
[4,null,null,"cate3No",{"$nulls":6},"카테고리3번호","Integer","N",null,"IN","소카테고리번호"]
[5,null,null,"cate4No",{"$nulls":6},"카테고리4번호","Integer","N",null,"IN","세카테고리번호"]
[6,null,null,"cate5No",{"$nulls":6},"카테고리5번호","Integer","N",null,"IN"]
[7,null,null,"keyword",{"$nulls":6},"검색어","String","N",null,"IN","검색 화면에서 사용됨\n※ 상품검색 화면에서 필수"]
[8,null,null,"brandGroupNo",{"$nulls":6},"브랜드그룹번호","Integer","N",null,"IN","브랜드 카테고리상품리스트 화면에서 사용"]
[9,null,null,"formalGb",{"$nulls":6},"정상이월구분","String","N",null,"IN","아울렛 상품리스트 화면에서 사용"]
[10,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"["]
[2,"•",null,"{"]
[3,null,null,null,"filterGb",{"$nulls":5},"필터구분","String","Y",null,"OUT","BRAND:브랜드필터, SIZE:사이즈필터, PRICE:가격필터, AGE:연령필터, SEASON:시즌필터, COLOR:색상필터, BENEFIT:혜택필터"]
[4,null,null,null,"filterCd",{"$nulls":5},"필터코드","String","Y",null,"OUT"]
[5,null,null,null,"filterNm",{"$nulls":5},"필터명","String","Y",null,"OUT"]
[6,null,null,"}"]
[7,null,"]"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
["{",{"$nulls":12},"["]
["    \"cate1No\" : 1300,",{"$nulls":12},"    {"]
["    \"cate1No\" : 1300,",{"$nulls":12},"        \"filterGb\":\"BRAND\","]
["    \"cate2No\" : 1301,",{"$nulls":12},"        \"filterCd\":\"24501\","]
["    \"cate3No\" : 1302,",{"$nulls":12},"        \"filterNm\":\"BUCKAROO\""]
["    \"cate4No\" : ,",{"$nulls":12},"    },"]
["    \"cate5No\" : ,",{"$nulls":12},"    {"]
["    \"keyword\" : \"\",",{"$nulls":12},"        \"filterGb\":\"BRAND\","]
["    \"brandGroupNo\" : 0,",{"$nulls":12},"        \"filterCd\":\"24556\","]
["    \"formalGb\" : \"\",",{"$nulls":12},"        \"filterNm\":\"ANDEW\""]
["}",{"$nulls":12},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"SIZE\","]
[{"$nulls":13},"        \"filterCd\":\"T|M\","]
[{"$nulls":13},"        \"filterNm\":\"M\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"SIZE\","]
[{"$nulls":13},"        \"filterCd\":\"B|072\","]
[{"$nulls":13},"        \"filterNm\":\"072\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"PRICE\","]
[{"$nulls":13},"        \"filterCd\":\"4000\","]
[{"$nulls":13},"        \"filterNm\":\"4000\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"PRICE\","]
[{"$nulls":13},"        \"filterCd\":\"14300\","]
[{"$nulls":13},"        \"filterNm\":\"14300\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"SEASON\","]
[{"$nulls":13},"        \"filterCd\":\"G006_1\","]
[{"$nulls":13},"        \"filterNm\":\"봄\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"SEASON\","]
[{"$nulls":13},"        \"filterCd\":\"G006_2\","]
[{"$nulls":13},"        \"filterNm\":\"여름\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"COLOR\","]
[{"$nulls":13},"        \"filterCd\":\"BR\","]
[{"$nulls":13},"        \"filterNm\":\"#A9764E\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"COLOR\","]
[{"$nulls":13},"        \"filterCd\":\"GR\","]
[{"$nulls":13},"        \"filterNm\":\"#6A6C6E\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"BENEFIT\","]
[{"$nulls":13},"        \"filterCd\":\"10\","]
[{"$nulls":13},"        \"filterNm\":\"쿠폰할인\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"filterGb\":\"BENEFIT\","]
[{"$nulls":13},"        \"filterCd\":\"20\","]
[{"$nulls":13},"        \"filterNm\":\"무료배송\""]
[{"$nulls":13},"    }"]
[{"$nulls":13},"]"]

{"sheet":"상품리스트","index":7,"n_rows":91,"n_cols":16,"rows_kept":91,"cut":false,"hidden":false,"merged":[[4,2,4,9],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8],[3,0,3,15],[32,0,32,15],[33,2,33,9],[55,0,55,15],[56,0,56,12],[56,13,56,15]]}
["기능명",{"$nulls":8},"상품리스트"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트, 상품검색 화면에서 호출"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"cate1No",{"$nulls":6},"카테고리1번호","Integer","N",null,"IN","대카테고리번호\n※ 카테고리상품리스트, 아울렛상품리스트, 브랜드상품리스트에서는 필수"]
[3,null,null,"cate2No",{"$nulls":6},"카테고리2번호","Integer","N",null,"IN","중카테고리번호"]
[4,null,null,"cate3No",{"$nulls":6},"카테고리3번호","Integer","N",null,"IN","소카테고리번호"]
[5,null,null,"cate4No",{"$nulls":6},"카테고리4번호","Integer","N",null,"IN","세카테고리번호"]
[6,null,null,"cate5No",{"$nulls":6},"카테고리5번호","Integer","N",null,"IN"]
[7,null,null,"keyword",{"$nulls":6},"검색어","String","N",null,"IN","검색 화면에서 사용됨\n※ 상품검색 화면에서 필수"]
[8,null,null,"brandGroupNo",{"$nulls":6},"브랜드그룹번호","Integer","N",null,"IN","브랜드 카테고리상품리스트 화면에서 사용"]
[9,null,null,"formalGb",{"$nulls":6},"정상이월구분","String","N",null,"IN","값이 있으면 TB_GOODS.FORMAL_GB = 'G009_20' 조건으로 검색"]
[10,null,null,"frontGb",{"$nulls":6},"프론트구분","String","N",null,"IN","P: PC웹, M: 모바일웹, A:모바일앱"]
[11,null,null,"custGb",{"$nulls":6},"고객구분","String","N",null,"IN","G100_10: 일반회원, G100_20: 임직원\n- 프론트구분(frontGb) 파라미터가 P이고 고객구분(custGb) 값이 G100_20 => TB_GOODS_BENEFIT_PRICE.STAFF_PC_CURR_PRICE\n- 프론트구분(frontGb) 파라미터가 M이고 고객구분(custGb) 값이 G100_20 => TB_GOODS_BENEFIT_PRICE.STAFF_MO_CURR_PRICE\n- 프론트구분(frontGb) 파라미터가 A이고 고객구분(custGb) 값이 G100_20 => TB_GOODS_BENEFIT_PRICE.STAFF_APP_CURR_PRICE\n- 프론트구분(frontGb) 파라미터가 P이고 고객구분(custGb) 값이 G100_20이 아닐때 => TB_GOODS_BENEFIT_PRICE.PC_CURR_PRICE\n- 프론트구분(frontGb) 파라미터가 M이고 고객구분(custGb) 값이 G100_20이 아닐때 => TB_GOODS_BENEFIT_PRICE.MO_CURR_PRICE\n- 프론트구분(frontGb) 파라미터가 A이고 고객구분(custGb) 값이 G100_20이 아닐때 => TB_GOODS_BENEFIT_PRICE.APP_CURR_PRICE"]
[12,null,null,"brandGroupArr",{"$nulls":6},"브랜드그룹배열","String[]","N",null,"IN"]
[13,null,null,"sizeArr",{"$nulls":6},"사이즈배열","String[]","N",null,"IN"]
[14,null,null,"priceFrom",{"$nulls":6},"가격From","Integer","N",null,"IN"]
[15,null,null,"priceTo",{"$nulls":6},"가격To","Integer","N",null,"IN"]
[16,null,null,"dcRateFrom",{"$nulls":6},"할인율From","Integer","N",null,"IN"]
[17,null,null,"dcRateTo",{"$nulls":6},"할인율To","Integer","N",null,"IN"]
[18,null,null,"ageArr",{"$nulls":6},"연령배열","String[]","N",null,"IN","TB_GOODS.AGE_GRP_CD"]
[19,null,null,"seasonArr",{"$nulls":6},"시즌배열","String[]","N",null,"IN","TB_GOODS.SEASON_CD"]
[20,null,null,"colorArr",{"$nulls":6},"컬러배열","String[]","N",null,"IN"]
[21,null,null,"benefitArr",{"$nulls":6},"혜택배열","String[]","N",null,"IN","TB_GOODS_BENEFIT.BENEFIT_GB"]
[22,null,null,"unisex",{"$nulls":6},"남여공용만보기","String","N",null,"IN","TB_GOODS.SEX_GB = 'G007_Z'"]
[23,null,null,"newGoods",{"$nulls":6},"신상품만보기","String","N",null,"IN","TB_GOODS_BENEFIT.BENEFIT_GB = '40'"]
[24,null,null,"sortingType",{"$nulls":6},"정렬순서","String","N",null,"IN","BEST: 인기상품순, REVIEW: 리뷰많은순, NEW: 최신상품순 그외 광고키워드순\n- 인기상품순: TB_GOODS.SELL_WEEK_QTY DESC\n- 리뷰많은순: TB_GOODS.REVIEW_REG_CNT DESC\n- 최신상품순: ORDER BY TB_GOODS.FORMAL_GB, TB_GOODS.REG_DT DESC\n'- 광고키워드순 : adFlag ='Y'먼저, TB_GOODS.FORMAL_GB, TB_GOODS.REG_DT DESC"]
[25,null,null,"pageNo",{"$nulls":6},"페이지번호","int","Y",1,"IN"]
[26,null,null,"pageSize",{"$nulls":6},"페이지크기","int","Y",50,"IN","페이지당 조회될 건수"]
[27,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"["]
[2,null,null,"pageNo",{"$nulls":6},"페이지번호","int","Y",null,"OUT"]
[3,null,null,"pageSize",{"$nulls":6},"페이지크기","int","Y",null,"OUT","페이지당 조회될 건수"]
[4,"•",null,"{"]
[5,null,null,null,"brandGroupNm",{"$nulls":5},"브랜드그룹명","String","Y",null,"OUT"]
[6,null,null,null,"goodsCd",{"$nulls":5},"상품코드","String","Y",null,"OUT"]
[{"$nulls":4},"optCd1",{"$nulls":5},"옵션1","String","Y",null,"OUT"]
[7,null,null,null,"goodsFullNm",{"$nulls":5},"상품FULL명","String","Y",null,"OUT"]
[8,null,null,null,"goodsTnm",{"$nulls":5},"상품타이틀명","String","Y",null,"OUT"]
[9,null,null,null,"listPrice",{"$nulls":5},"정상가","int","Y",null,"OUT","최초소비자가"]
[10,null,null,null,"currPrice",{"$nulls":5},"현재판매가","int","Y",null,"OUT","즉시할인쿠폰이 적용된 판매가"]
[11,null,null,null,"sysImgNm",{"$nulls":5},"상품시스템이미지명","String","N",null,"OUT","썸네일 기본 이미지"]
[12,null,null,null,"sysImgNm2",{"$nulls":5},"상품시스템이미지명2","String","N",null,"OUT","썸네일 마우스오버 이미지"]
[13,null,null,null,"videos",{"$nulls":5},"동영상들","String","N",null,"OUT","등록일자 순으로 2개만\n형식: 동영상구분(M:MP4, Y:유투브):미디어컨텐츠키,동영상구분(M:MP4, Y:유투브):미디어컨텐츠키...\n예) M:164MyIiv,M:164Mxkea"]
[14,null,null,null,"colorChips",{"$nulls":5},"컬러칩들","String","N",null,"OUT","컬러칩 정렬순서 순으로\n형식: 색상코드:컬러칩,색상코드:컬러칩...\n예) LB:#00A1E9,BK:#000000\n\n=>\n자사상품 : 자사옵션1"]
[15,null,null,null,"sizes",{"$nulls":5},"사이즈들","String","N",null,"OUT","사이즈 정렬순서 순으로\n형식: 사이즈코드:품절여부,사이즈코드:품절여부...\n예) 64:N,67:N,70:N"]
[16,null,null,null,"benefits",{"$nulls":5},"혜택들","String","N",null,"OUT","혜택구분 순으로\n형식: 혜택구분:혜택명,혜택구분:혜택명...\n예) 10:쿠폰할인,30:사은품"]
[17,null,null,null,"adFlag",{"$nulls":5},"광고상품여부","String","Y",null,"OUT","광고상품여부(Y,N)"]
[18,null,null,"}"]
[19,null,"]"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
["{",{"$nulls":12},"["]
["    \"cate1No\" : 1300,",{"$nulls":12},"    \"pageNo\" : 1,"]
["    \"cate2No\" : 1301,",{"$nulls":12},"    \"pageSize\" : 50"]
["    \"cate3No\" : 1302,",{"$nulls":12},"    {"]
["    \"cate4No\" : ,",{"$nulls":12},"        \"brandGroupNm\":\"FRJ\","]
["    \"cate5No\" : ,",{"$nulls":12},"        \"goodsCd\":\"A83F-DP568S\","]
["    \"brandGroupNo\" : 0,",{"$nulls":12},"        \"goodsFullNm\":\"여성 M톤워싱세미부컷 청바지 (A83F-DP568S)\""]
["    \"formalGb\" : \"\",",{"$nulls":12},"        \"goodsTnm\":\"\","]
["    \"frontGb\" : \"P\",",{"$nulls":12},"        \"listPrice\":69000,"]
["    \"custGb\" : \"\",",{"$nulls":12},"        \"listPrice\":13900,"]
["    \"brandGroupNoArr\" : [ \"442\", \"24555\" ],",{"$nulls":12},"        \"sysImgNm\":\"0000004806/20200330/14019445_L.jpg\""]
["    \"sizeArr\" : [ \"095\", \"100\", \"Free\" ],",{"$nulls":12},"        \"sysImgNm\":\"0000004806/20200330/14019445_1_L.jpg\""]
["    \"priceFrom\" : ,",{"$nulls":12},"        \"videos\":\"Y:720o0rj0bco\""]
["    \"priceTo\" : ,",{"$nulls":12},"        \"colorChips\":\"MB:#00A1E9\","]
["    \"dcRateFrom\" : ,",{"$nulls":12},"        \"sizes\":\"64:N,67:N,70:N\","]
["    \"dcRateTo\" : ,",{"$nulls":12},"        \"benefits\":\"40:신상,50:총알배송\","]
["    \"ageArr\" : [],",{"$nulls":12},"        \"adFlag\":\"Y\""]
["    \"seasonArr\" : [],",{"$nulls":12},"    },"]
["    \"colorArr\" : [],",{"$nulls":12},"    {"]
["    \"benefitArr\" : [],",{"$nulls":12},"        \"brandGroupNm\":\"FRJ\","]
["    \"unisex\" : \"G007_Z\",",{"$nulls":12},"        \"goodsCd\":\"A83F-DP645H\","]
["    \"newGoods\" : \"40\",",{"$nulls":12},"        \"goodsFullNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\""]
["    \"sortingType\" : \"\"",{"$nulls":12},"        \"goodsTnm\":\"\","]
["    \"pageNo\" : 1,",{"$nulls":12},"        \"listPrice\":59000,"]
["    \"pageSize\" : 50",{"$nulls":12},"        \"listPrice\":13900,"]
["}",{"$nulls":12},"        \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\""]
[{"$nulls":13},"        \"sysImgNm\":\"0000004806/20200330/11867577_1_L.jpg\""]
[{"$nulls":13},"        \"videos\":\"\""]
[{"$nulls":13},"        \"colorChips\":\"LB:#00A1E9\","]
[{"$nulls":13},"        \"sizes\":\"67:N,70:N,73:N\","]
[{"$nulls":13},"        \"benefits\":\"40:신상,50:총알배송\","]
[{"$nulls":13},"        \"adFlag\":\"N\""]
[{"$nulls":13},"    }"]
[{"$nulls":13},"]"]

{"sheet":"기획전","index":8,"n_rows":80,"n_cols":16,"rows_kept":80,"cut":false,"hidden":false,"merged":[[8,0,8,15],[9,2,9,9],[30,0,30,15],[31,0,31,12],[31,13,31,15],[3,0,3,15],[4,2,4,9],[2,9,2,15],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8]]}
["기능명",{"$nulls":8},"기획전 목록"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"1. 검색화면에서 호출\n2. 키워드에 해당하는 기획전 목록 조회 (planGb = 'P')"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"keyword",{"$nulls":6},"검색어","String","Y",null,"IN"]
[3,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"["]
[2,"•",null,"{"]
[3,null,null,null,"planSq",{"$nulls":5},"기획전번호","Integer","Y",null,"OUT"]
[4,null,null,null,"planNm",{"$nulls":5},"기획전명","String","Y",null,"OUT"]
[5,null,null,null,"dtlTitle1",{"$nulls":5},"상세타이틀1","String","Y",null,"OUT"]
[6,null,null,null,"mainImg",{"$nulls":5},"메인이미지","String","Y",null,"OUT"]
[7,null,null,null,"newYn",{"$nulls":5},"NEW여부","String","Y",null,"OUT"]
[8,null,null,null,"planningGoodsList",{"$nulls":10},"최대 2개 노출"]
[9,null,null,null,"[",{"$nulls":5},"현재판매가","int","Y",null,"OUT","즉시할인쿠폰이 적용된 판매가"]
[10,"•",null,null,null,"{",{"$nulls":4},"현재판매가","int","Y",null,"OUT","즉시할인쿠폰이 적용된 판매가"]
[11,{"$nulls":5},"goodsCd",null,null,null,"상품코드","String","Y",null,"OUT"]
[12,{"$nulls":5},"goodsNm",null,null,null,"상품명","String","Y",null,"OUT"]
[13,{"$nulls":5},"listPrice",null,null,null,"정상가","int","Y",null,"OUT","최초소비자가"]
[14,{"$nulls":5},"currPrice",null,null,null,"현재판매가","int","Y",null,"OUT","즉시할인쿠폰이 적용된 판매가"]
[15,{"$nulls":5},"sysImgNm",null,null,null,"상품시스템이미지명","String","N",null,"OUT","썸네일 기본 이미지"]
[16,{"$nulls":4},"}"]
[17,null,null,null,"]"]
[18,null,null,"}"]
[19,null,"]"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
["{",{"$nulls":12},"["]
["    \"keyword\" : \"니트\"",{"$nulls":12},"    {"]
["}",{"$nulls":12},"        \"planSq\":120,"]
[{"$nulls":13},"        \"planNm\":\"기획전120\","]
[{"$nulls":13},"        \"dtlTitle1\":\"기획전상세타이틀120\","]
[{"$nulls":13},"        \"mainImg\":\"/planning/20210531/192839203.jpg\","]
[{"$nulls":13},"        \"newYn\":\"Y\","]
[{"$nulls":13},"        \"planningGoodsList\":["]
[{"$nulls":13},"            {"]
[{"$nulls":13},"                \"goodsCd\":\"A83F-DP645H\","]
[{"$nulls":13},"                \"goodsNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\""]
[{"$nulls":13},"                \"listPrice\":59000,"]
[{"$nulls":13},"                \"listPrice\":13900,"]
[{"$nulls":13},"                \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\""]
[{"$nulls":13},"            },"]
[{"$nulls":13},"            {"]
[{"$nulls":13},"                \"goodsCd\":\"A83F-DP645H\","]
[{"$nulls":13},"                \"goodsNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\""]
[{"$nulls":13},"                \"listPrice\":59000,"]
[{"$nulls":13},"                \"listPrice\":13900,"]
[{"$nulls":13},"                \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\""]
[{"$nulls":13},"            }"]
[{"$nulls":13},"        ]"]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"planSq\":121,"]
[{"$nulls":13},"        \"planNm\":\"기획전121\","]
[{"$nulls":13},"        \"dtlTitle1\":\"기획전상세타이틀121\","]
[{"$nulls":13},"        \"mainImg\":\"/planning/20210531/192839203.jpg\","]
[{"$nulls":13},"        \"newYn\":\"Y\","]
[{"$nulls":13},"        \"planningGoodsList\":["]
[{"$nulls":13},"            {"]
[{"$nulls":13},"                \"goodsCd\":\"A83F-DP645H\","]
[{"$nulls":13},"                \"goodsNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\""]
[{"$nulls":13},"                \"listPrice\":59000,"]
[{"$nulls":13},"                \"listPrice\":13900,"]
[{"$nulls":13},"                \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\""]
[{"$nulls":13},"            },"]
[{"$nulls":13},"            {"]
[{"$nulls":13},"                \"goodsCd\":\"A83F-DP645H\","]
[{"$nulls":13},"                \"goodsNm\":\"여성 이너밴드 로그핏 데님팬츠(A83F-DP645H)\""]
[{"$nulls":13},"                \"listPrice\":59000,"]
[{"$nulls":13},"                \"listPrice\":13900,"]
[{"$nulls":13},"                \"sysImgNm\":\"0000004806/20200330/11867577_L.jpg\""]
[{"$nulls":13},"            }"]
[{"$nulls":13},"        ]"]
[{"$nulls":13},"    }"]
[{"$nulls":13},"]"]

{"sheet":"이벤트","index":9,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,2,4,9],[8,0,8,15],[9,2,9,9],[21,0,21,15],[22,0,22,12],[22,13,22,15],[3,0,3,15],[0,0,0,8],[1,0,1,8],[1,13,1,14],[2,0,2,8],[2,9,2,15]]}
["기능명",{"$nulls":8},"이벤트 목록"]
["Class",{"$nulls":12},"메소드명"]
["설명",{"$nulls":8},"1. 검색화면에서 호출\n2. 키워드에 해당하는 이벤트 목록 조회 (planGb = 'E')"]
["Request Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"{"]
[2,null,null,"keyword",{"$nulls":6},"검색어","String","Y",null,"IN"]
[3,null,"}"]
["Response Data"]
["No","반복","컬럼ID",{"$nulls":7},"칼럼명","Data\nType","필수\n여부","Default","IN/OUT","설명"]
[1,null,"["]
[2,"•",null,"{"]
[3,null,null,null,"planSq",{"$nulls":5},"기획전번호","Integer","Y",null,"OUT"]
[4,null,null,null,"planNm",{"$nulls":5},"기획전명","String","Y",null,"OUT"]
[5,null,null,null,"mainImg",{"$nulls":5},"메인이미지","String","Y",null,"OUT"]
[6,null,null,null,"newYn",{"$nulls":5},"NEW여부","String","Y",null,"OUT"]
[7,null,null,null,"dispStdt",{"$nulls":5},"노출시작일시","String","Y",null,"OUT","YYYY.MM.DD 형식"]
[8,null,null,null,"dispEddt",{"$nulls":5},"노출종료일시","String","Y",null,"OUT","YYYY.MM.DD 형식"]
[9,null,null,"}"]
[10,null,"]"]
[]
["샘플 데이터"]
["Request Parameter",{"$nulls":12},"Response"]
["{",{"$nulls":12},"["]
["    \"keyword\" : \"니트\"",{"$nulls":12},"    {"]
["}",{"$nulls":12},"        \"planSq\":120,"]
[{"$nulls":13},"        \"planNm\":\"기획전120\","]
[{"$nulls":13},"        \"mainImg\":\"/planning/20210531/192839203.jpg\","]
[{"$nulls":13},"        \"newYn\":\"Y\","]
[{"$nulls":13},"        \"dispStdt\":\"2021.06.01\","]
[{"$nulls":13},"        \"dispEddt\":\"2021.06.04\""]
[{"$nulls":13},"    },"]
[{"$nulls":13},"    {"]
[{"$nulls":13},"        \"planSq\":121,"]
[{"$nulls":13},"        \"planNm\":\"기획전121\","]
[{"$nulls":13},"        \"mainImg\":\"/planning/20210531/192839203.jpg\","]
[{"$nulls":13},"        \"newYn\":\"Y\","]
[{"$nulls":13},"        \"dispStdt\":\"2021.06.04\","]
[{"$nulls":13},"        \"dispEddt\":\"2021.06.07\""]
[{"$nulls":13},"    }"]
[{"$nulls":13},"]"]