브랜드몰
    • 글라스락
    • 파커
  • 쿠션담요/무릎담요
  • 타올 전문몰
  • 글라스락세트
  • 키친아트
  • 보조밧데리
  • 한국도자기

MD'S CHOICE

Array
(
    [0] => Array
        (
            [seq] => 12
            [title] => 금융사은품
            [img] => pd_sp10_stt_1.gif
            [categoryA] => 0
            [categoryB] => 0
            [categoryC] => 0
        )

    [1] => Array
        (
            [seq] => 7
            [title] => 주방용품
            [img] => pd_sp05_stt.gif
            [categoryA] => 2
            [categoryB] => 0
            [categoryC] => 0
        )

    [2] => Array
        (
            [seq] => 8
            [title] => 상패/트로피
            [img] => pd_sp06_stt.gif
            [categoryA] => 6
            [categoryB] => 34
            [categoryC] => 0
        )

    [3] => Array
        (
            [seq] => 5
            [title] => 사무문구/디지털용품
            [img] => pd_sp03_stt.gif
            [categoryA] => 4
            [categoryB] => 0
            [categoryC] => 0
        )

)
<% i = 1 Do Until rs.eof k = i Mod 2 If k = 1 Then chk = 1 Else chk = 2 End If categoryA = "" categoryB = "" categoryC = "" categoryC_original = rs("categoryC") categoryB_original = rs("categoryB") categoryA_original = rs("categoryA") If categoryC_original = "0" Or IsNull(categoryC_original) Then categoryC_original = "" End If If categoryB_original = "0" Or IsNull(categoryB_original) Then categoryB_original = "" End If If categoryA_original = "0" Or IsNull(categoryA_original) Then categoryA_original = "" End If If categoryC_original <> "" Then sql = "select c.seq from t_categoryC_original o join t_categoryC c on o.seq = c.fk_category where c.shop_code = '" & global_shop_code & "' and c.useType='Y' and o.seq = " & categoryC_original rs1.open sql,oDBCon,1 If Not rs1.eof Then categoryC = rs1(0) End If rs1.close End If If categoryB_original <> "" Then sql = "select c.seq from t_categoryB_original o join t_categoryB c on o.seq = c.fk_category where c.shop_code = '" & global_shop_code & "' and c.useType='Y' and o.seq = " & categoryB_original rs1.open sql,oDBCon,1 If Not rs1.eof Then categoryB = rs1(0) End If rs1.close End If If categoryA_original <> "" Then sql = "select c.seq from t_categoryA_original o join t_categoryA c on o.seq = c.fk_category where c.shop_code = '" & global_shop_code & "' and c.useType='Y' and o.seq = " & categoryA_original rs1.open sql,oDBCon,1 If Not rs1.eof Then categoryA = rs1(0) End If rs1.close End If If k = 1 Then %>
<% End If %>
" alt="<%=rs("title")%>" />
<%If categoryA <> "" Or categoryB <> "" Or categoryC <> "" Then %>
더보기
<%End If %>
<% sql_categoryC = " p.categoryC in (select fk_category from t_categoryC c join t_categoryC_original o on c.fk_category = o.seq where c.useType = 'Y' and shop_code = '" & global_shop_code & "')" sql = "select distinct top 6 m.p_code,p.p_name,p.imgS1,p.price1,p.su_limit1,m.sort,p.showType from t_mainProduct m join t_product p on m.p_code = p.p_code where m.useType='Y' and m.mainCategory= " & rs("seq") & " and p.useType <> 'N' and " & sql_categoryC & " order by m.sort asc" rs1.open sql,oDBCon,1 If Not rs1.eof Then z = 1 Do Until rs1.eof If rs1("showType") = "Y" And global_shop_kind = "B" Then price = "****" su_limit = "***" Else price = FormatNumber(discount(rs1("price1")),0) If session("mro") <> "" Then 'price1= price1 * session("real_halin") price= FormatNumber(discount_mro(price),0) End if su_limit = FormatNumber(rs1("su_limit1"),0) End If size = imgAutoSize("/upload/product/" & rs1("imgS1"), 120 , 120) %> <%If z = 1 Then %>
<% If k = 0 Then %>
<% End If i = i + 1 rs.movenext Loop End If rs.close Set rs1 = Nothing %>
쇼핑 공지사항 <% if global_shop_code = "giftkor" then %> 더보기 <%else%> 더보기 <%End if%>
<% Set rs = server.CreateObject("ADODB.RecordSet") check_count=0 if global_shop_code = "arishop" then sql = "select top 3 seq,title from t_outer_notice where (shop_code = 'arishop') and check_num='Y' order by seq desc" Else sql = "select top 3 seq,title from t_outer_notice where (shop_code <> 'arishop') and check_num='Y' order by seq desc" End if rs.open sql,oDBCon,1 If Not (rs.eof Or rs.bof) Then Do Until rs.eof If LenB(rs("title")) > 40 Then title = LeftB(rs("title"),38) & ".." Else title = rs("title") End If If global_shop_code = "giftkor" then %>
<%=title%>
<% Else %> <% End if rs.movenext check_count=check_count+1 Loop End If rs.close Set rs = Nothing Set rs = server.CreateObject("ADODB.RecordSet") top_search=3-check_count If top_search > 0 then if global_shop_code = "arishop" then sql = "select top 3 seq,title from t_outer_notice where (shop_code = 'arishop') and (check_num is null or check_num='') order by seq desc" Else sql = "select top 3 seq,title from t_outer_notice where (shop_code <> 'arishop') and (check_num is null or check_num='') order by seq desc" End if rs.open sql,oDBCon,1 If Not (rs.eof Or rs.bof) Then Do Until rs.eof If LenB(rs("title")) > 40 Then title = LeftB(rs("title"),38) & ".." Else title = rs("title") End If if global_shop_code = "giftkor" then %>
<%=title%>
<% Else %> <% End if rs.movenext Loop End If rs.close Set rs = Nothing End If %>
입금안내 nh_bank074-01-185088
hana_bank109-910016-18004
입금확인은 1시간마다 이루어집니다.
쇼핑 고객센터
대표전화 02-883-6151
이용안내 평일오전9시~오후7시까지(점심시간 12시~1시)
대표이메일 giftmani@empal.com
왼쪽화살표
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
  • 배너
  • 배너라인
오른쪽화살표