주문내역 쿼리 질문드립니다 ㅠ 채택완료
lacomparte
8년 전
조회 4,299
주문내역이
기본은
주문번호와 일시 금액 상태 정도만 출력을하는데..
상품 이미지, 상품명, 옵션명도 출력해야해서
cart table 에서 od_id 가 맞는걸 갖고와서 출력시켜줬습니다
출력은 다 되는데..
만약 한번에 주문으로 2개이상의 물건을 사게 될 경우;
제가 쿼리를 잘못 짜서 그런지.. 2번째 상품은 옵션이 출력이 안되어버리네요
소스와 링크 그리고 아이디 비밀번호를 적어 두겠습니다 ㅠ
힌트라도 주신다면..감사하겠습니다 ㅠ
사이트 들어가서 로그인해서 주문내역 보시면
주문내역 아래
1~8까지 숫자로 구성된 테이블이 있는데..
만약 주문번호1개에 2개 이상의 상품이 있다면
숫자로 구성된 테이블처럼 출력이 되야 해서요 ㅠㅠ
for문 전 쿼리에서 order_table의 od_id와 cart_table의 od_id 가 같은
자료만 갖고와서
for문 안에서 어떤 쿼리를 날려줘야 하는지 ㅠㅠ
링크
http://121.164.172.240:88/shop/">http://121.164.172.240:88/shop/
아이디
farmsismall
비번
1234
</p><p><?php</p><p>if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가</p><p> </p><p>if (!defined("_ORDERINQUIRY_")) exit; // 개별 페이지 접근 불가</p><p> </p><p>// 테마에 orderinquiry.sub.php 있으면 include</p><p>if(defined('G5_THEME_SHOP_PATH')) {</p><p> $theme_inquiry_file = G5_THEME_SHOP_PATH.'/orderinquiry.sub.php';</p><p> if(is_file($theme_inquiry_file)) {</p><p> include_once($theme_inquiry_file);</p><p> return;</p><p> unset($theme_inquiry_file);</p><p> }</p><p>}</p><p>$s_cart_id = get_session('ss_cart_id');</p><p>set_cart_id($sw_direct);</p><p> </p><p>// 선택필드 초기화</p><p>$sql = " UPDATE {$g5['g5_shop_cart_table']} SET ct_select = '0' WHERE od_id = '$s_cart_id' ";</p><p>sql_query($sql);</p><p> </p><p>// 주문내역 삭제</p><p>$orderinquiry_del_url = G5_SHOP_URL.'/orderinquiry.sub.del.php';</p><p> </p><p>?></p><p> </p><p><!-- 회원정보 개요 시작 { --></p><p><section id="smb_my_ov"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><h2>마이페이지 개요</h2></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><table></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><caption class="sound_only">마이페이지 하부 메뉴</caption></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><thead></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th>상품 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th>구매 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th>활동 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></thead></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tbody></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/wishlist.php" title="관심 상품">관심 상품</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/orderinquiry.php" title="주문 내역">주문내역</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/mypage_itemqalist.php" title="1:1문의">1:1문의</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/today_view.php" title="오늘 본 상품">오늘 본 상품</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/cart.php" title="장바구니">장바구니</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_SHOP_URL ?>/mypage_itemuselist.php" title="구매후기">구매후기</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><a href="<?php echo G5_BBS_URL ?>/board.php?bo_table=ShopAlliance&sca=&sop=and&sfl=mb_id%2C1&stx=<?php echo $member['mb_id'] ?>" title="제휴제안">제휴제안</a></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tbody></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></table></p><p></section></p><p><!-- } 회원정보 개요 끝 --></p><p> </p><p><!-- 주문 내역 목록 시작 { --></p><p><?php if (!$limit) { ?>총 <?php echo $cnt; ?> 건<?php } ?></p><p> </p><p><div class="tbl_head01 tbl_wrap"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><form name="frmoilist" id="orderinquiry_list" method="post" action="<?php echo $orderinquiry_del_url; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><table class="tbl_inquiry"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><colgroup></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="30px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="60px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="100px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="70px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="425px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="110px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="120px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><col width="80px"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></colgroup></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><thead></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><label for="ct_all" class="sound_only">상품 전체</label></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="checkbox" name="ct_all" value="1" id="ct_all"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">번호</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">주문번호</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">이미지</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">상품명</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">상품구매금액</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">주문일자</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th scope="col">상태</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></thead></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tbody></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php</p><p>/*</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " SELECT *</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM {$g5['g5_shop_order_table']}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE mb_id = '{$member['mb_id']}'</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>ORDER BY od_id desc</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$limit ";</p><p>*/</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " SELECT </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>*</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM {$g5['g5_shop_cart_table']} a</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>LEFT JOIN {$g5['g5_shop_order_table']} b</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>ON a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE b.mb_id = '{$member['mb_id']}' AND a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>GROUP BY a.it_name, a.od_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>ORDER BY a.od_id DESC</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$limit</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>";</p><p>print_r ($sql);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$num = 0;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$num = $total_count - ($page - 1) * $rows + $i;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($i=0; $row=sql_fetch_array($result); $i++)</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p>//<span class="Apple-tab-span" style="white-space:pre"> </span>$od_id = $row['od_id'];</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql2 = "SELECT </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.it_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.mb_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.it_name,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.io_price,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>b.od_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>b.mb_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM {$g5['g5_shop_cart_table']} a</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>LEFT JOIN {$g5['g5_shop_order_table']} b</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>ON a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE it_id = {$row['it_id']}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>";</p><p>/*</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql2 = "SELECT </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>od_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>it_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>mb_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>it_name,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>io_price</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM {$g5['g5_shop_cart_table']}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE it_id = {$row['it_id']}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>";</p><p>*/</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result2 = sql_fetch($sql2);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$image = get_it_image($result2['it_id'], 70, 70);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$uid = md5($row['od_id'].$row['od_time'].$row['od_ip']);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($it_options) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$it_options = print_item_options($row['it_id'], $s_cart_id);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$it_options = "<p class=\"opt_list\">".$row['it_name']." ".$row['ct_qty']."개 (+".number_format($row['ct_price'])."원)</p>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>switch($row['od_status']) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>case '주문':</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '입금확인중';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>case '입금':</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '완료';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>case '준비':</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '상품준비중';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>case '배송':</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '상품배송';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>case '완료':</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '완료';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>default:</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$od_status = '주문취소';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>break;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$num--;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for($j=0; $j < count($result2['it_name']); $j++) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><label for="ct_chk_<?php echo $i; ?>" class="sound_only">주문</label></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="checkbox" name="ct_chk[<?php echo $i; ?>]" value="1" id="ct_chk_<?php echo $i; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo $num; ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="it_id[<?php echo $i; ?>]" value="<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="od_id[<?php echo $i; ?>]" value="<?php echo $row['od_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&uid=<?php echo $uid; ?>"><?php echo $row['od_id']; ?></a></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class="td_image"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><a href="./item.php?it_id=<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo $image; ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></a></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><p></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><a href="./item.php?it_id=<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo $row['it_name']; ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></a></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php if($it_options) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo $it_options; ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php } ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="" class="td_numbig"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php //echo display_price($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']); ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo display_price(($row['ct_price'] * $row['ct_qty']) + $row['io_price']); ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan=""><?php echo substr($row['od_time'],2,14); ?> (<?php echo get_yoil($row['od_time']); ?>)</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan=""><?php echo $od_status; ?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} // 첫번째 for</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($i == 0)</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo '<tr><td colspan="8" class="empty_table">주문 내역이 없습니다.</td></tr>';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">1</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">2</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">3</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">6</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">7</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td rowspan="3">8</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tbody></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></table></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php if ($total_count != 0) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><div class="inquiry_btn"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="url" value="./orderinquiry.php"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="records" value="<?php echo $i; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="act" value=""></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><button type="button" onclick="return form_check('alldelete');" class="btn01">전체삭제</button></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><button type="button" onclick="return form_check('seldelete');" class="btn01">선택삭제</button></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></div></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php } ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></form></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo $row['od_id'];?></p><p></div></p><p> </p><p><script type="text/javascript"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$(function() {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 모두선택</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$("input[name=ct_all]").click(function() {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($(this).is(":checked"))</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$("input[name^=ct_chk]").attr("checked", true);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>else</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$("input[name^=ct_chk]").attr("checked", false);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>});</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>});</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function form_check(act) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var f = document.frmoilist;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var cnt = f.records.value;</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if (act == "alldelete")</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if(confirm("정말 삭제하시겠습니까?")) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>f.act.value = act;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>f.submit();</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>else if (act == "seldelete")</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($("input[name^=ct_chk]:checked").size() < 1) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>alert("삭제하실 주문내역을 하나 이상 선택해 주십시오.");</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return false;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if(confirm("정말 삭제하시겠습니까?")) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>f.act.value = act;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>f.submit();</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return true;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p></script></p><p><!-- } 주문 내역 목록 끝 --></p><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인
row 한줄씩 질의할때 마다
주문번호를 찍으라는 건가요?
한가지 더 궁금한건, (주문1건에 대해 2가지 이상 상품이 존재할경우)
상품명과 이미지는 가져오는데..
옵션명을
두번째 상품부터 못가져 옵니다 ㅠ