소스좀 봐주세요~ 채택완료
lacomparte
8년 전
조회 4,668
아래 질문을 올리긴했는데
나름 해결해서요~
코드상 이상이 없는지 좀 봐주시면 감사하겠습니다 ㅠ
기능은
주문내역에서 주문내역 삭제하는 기능입니다
orderinquiry.sub.php
</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> </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><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="oi_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><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " SELECT DISTINCT </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.mb_id,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_name,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_cart_price,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_status,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_settle_case,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_test,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_time,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_cart_count,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_cart_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.it_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>b.it_name,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>c.it_option_subject,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>c.it_supply_subject,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>c.it_img1</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM {$g5['g5_shop_order_table']} a</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>INNER JOIN {$g5['g5_shop_cart_table']} b ON</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>a.od_id = b.od_id </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>LEFT JOIN {$g5['g5_shop_item_table']} c ON</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>b.it_id = c.it_id</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE b.mb_id = '{$member['mb_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>$result = sql_query($sql);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$num = $total_count - ($page - 1) * $rows + $i;</p><p> </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>$image = get_it_image($row['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>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> </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></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></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></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><?php echo $image; ?></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><?php echo $row['it_name']; ?></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($row['it_option_subject'] || $row['it_supply_subject']) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><span><?php echo "옵션 : ".$row['it_option_subject']." ".$row['it_supply_subject']; ?></span></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 class="td_numbig"><?php echo display_price($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']); ?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td><?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><?php echo $od_status; ?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p> </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><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="7" class="empty_table">주문 내역이 없습니다.</td></tr>';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></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><div></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></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>
orderinquiry.sub.del.php
</p><p><?php</p><p>include_once('./_common.php');</p><p>?></p><p> </p><p> </p><p><?php</p><p>//$tmp_cart_id = $_POST['od_id'];</p><p> </p><p>if (!$member['mb_id'])</p><p>{</p><p> alert('주문내역을 삭제 할 수 있는 권한이 없습니다.');</p><p>}</p><p> </p><p>if ($act == "alldelete") // 모두 삭제이면</p><p>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_cart_id = $_POST['od_id'][$i];</p><p> $sql = " DELETE FROM {$g5['g5_shop_cart_table']}</p><p> WHERE od_id = '$tmp_cart_id' ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sql_query($sql);</p><p>}</p><p>else if ($act == "seldelete") // 선택삭제</p><p>{</p><p> if(!count($_POST['ct_chk']))</p><p> alert("삭제하실 주문내역을 하나 이상 선택해 주십시오.");</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>$fldcnt = count($_POST['it_id']);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for($i=0; $i<$fldcnt; $i++) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$ct_chk = $_POST['ct_chk'][$i];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($ct_chk) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$it_id = $_POST['it_id'][$i];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_cart_id = $_POST['od_id'][$i];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " delete from {$g5['g5_shop_cart_table']} where it_id = '$it_id' and od_id = '$tmp_cart_id' ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sql_query($sql);</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>goto_url(G5_SHOP_URL.'/orderinquiry.php');</p><p>?></p><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인