주문내역에서 상품분류코드가 보였으면합니다

매출이 오르면 내리는 수수료! 지금 수수료센터에서 전자결제(PG)수수료 비교견적 신청해 보세요!
주문내역에서 상품분류코드가 보였으면합니다

QA

주문내역에서 상품분류코드가 보였으면합니다

본문

<section id="anc_sodr_pay">
 <h2 class="h2_frm">주문결제 내역</h2>
 <?php echo $pg_anchor; ?>

 <?php
 // 주문금액 = 상품구입금액 + 배송비 + 추가배송비
 $amount['order'] = $od['od_cart_price'] + $od['od_send_cost'] + $od['od_send_cost2'];

 // 입금액 = 결제금액 + 포인트
 $amount['receipt'] = $od['od_receipt_price'] + $od['od_receipt_point'];

 // 쿠폰금액
 $amount['coupon'] = $od['od_cart_coupon'] + $od['od_coupon'] + $od['od_send_coupon'];

 // 취소금액
 $amount['cancel'] = $od['od_cancel_price'];

 // 미수금 = 주문금액 - 취소금액 - 입금금액 - 쿠폰금액
 //$amount['미수'] = $amount['order'] - $amount['receipt'] - $amount['coupon'];

 // 결제방법
 $s_receipt_way = $od['od_settle_case'];

 if ($od['od_receipt_point'] > 0)
  $s_receipt_way .= "+포인트";
 ?>

 
 
 <div class="tbl_head01 tbl_wrap">
  <strong class="sodr_nonpay">미수금 <?php echo display_price($od['od_misu']); ?></strong>

  <table>
  <caption>주문결제 내역</caption>
  <thead>
  <tr>
   <th scope="col">주문번호</th>
   <th scope="col">상품분류코드</th>
   <th scope="col">결제방법</th>
   <th scope="col">주문총액</th>
   <th scope="col">배송비</th>
   <th scope="col">포인트결제</th>
   <th scope="col">총결제액</th>
   <th scope="col">쿠폰</th>
   <th scope="col">주문취소</th>
  </tr>
  </thead>
  <tbody>
  <tr>
   <td><?php echo $od['od_id']; ?></td>
  --------------이부분입니다.---------
   <td><?php echo $ca_id; ?></td>
   ----------------------------------
   <td class="td_paybybig"><?php echo $s_receipt_way; ?></td>
   <td class="td_numbig td_numsum"><?php echo display_price($amount['order']); ?></td>
   <td class="td_numbig"><?php echo display_price($od['od_send_cost'] + $od['od_send_cost2']); ?></td>
   <td class="td_numbig"><?php echo display_point($od['od_receipt_point']); ?></td>
   <td class="td_numbig td_numincome"><?php echo number_format($amount['receipt']); ?>원</td>
   <td class="td_numbig td_numcoupon"><?php echo display_price($amount['coupon']); ?></td>
   <td class="td_numbig td_numcancel"><?php echo number_format($amount['cancel']); ?>원</td>
  </tr>
  </tbody>
  </table>
 </div>
</section>​ ​0b031c8ba455ba61c0151f05b1723236_1429151485_7504.jpg 

 

이 질문에 댓글 쓰기 :

답변 2

/adm/shop_admin/orderform.php

 

...............

// 상품목록
$sql = " select it_id,
                it_name,
                cp_price,
                ct_notax,
                ct_send_cost,
                it_sc_type

           from {$g5['g5_shop_cart_table']} a

          where a.od_id = '{$od['od_id']}' 

          group by a.it_id
          order by a.ct_id ";
$result = sql_query($sql);​

 

 

44번째 라인을 아래와 같이 변경

// 상품목록
$sql = " select a.it_id,
                a.it_name,
                a.cp_price,
                a.ct_notax,
                a.ct_send_cost,
                a.it_sc_type,
                b.ca_id,
                c.ca_name
           from {$g5['g5_shop_cart_table']} a, {$g5['g5_shop_item_table']} b, {$g5['g5_shop_category_table']} c
          where a.od_id = '{$od['od_id']}' and a.it_id = b.it_id and b.ca_id = c.ca_id
          group by a.it_id
          order by a.ct_id ";
$result = sql_query($sql);​

..............................

.......

<?php
        $chk_cnt = 0;
        for($i=0; $row=sql_fetch_array($result); $i++) {
            // 상품이미지
            $image = get_it_image($row['it_id'], 50, 50);
            $item_caid = $row['ca_id'];
            $item_caname = $row['ca_name'];
​​​​

            // 상품의 옵션정보
            $sql = " select ct_id, it_id, ct_price, ct_point, ct_qty, ct_option, ct_status, cp_price, ct_stock_use, ct_point_use, ct_send_cost, io_type, io_price
                        from {$g5['g5_shop_cart_table']}
                        where od_id = '{$od['od_id']}'
                          and it_id = '{$row['it_id']}'
                        order by io_type asc, ct_id asc ";
            $res = sql_query($sql);
            $rowspan = mysql_num_rows($res);

.........

 

149번 라인 밑에 추가

           $item_caid = $row['ca_id'];
           $item_caname = $row['ca_name'];
​​​​​ 

 

 

..........

        <table>
        <caption>주문결제 내역</caption>
        <thead>
        <tr>
            <th scope="col">주문번호</th>
            <th scope="col">상품분류코드/명</th>
            <th scope="col">결제방법</th>
            <th scope="col">주문총액</th>
            <th scope="col">배송비</th>
            <th scope="col">포인트결제</th>
            <th scope="col">총결제액</th>
            <th scope="col">쿠폰</th>
            <th scope="col">주문취소</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td align="center"><?php echo $od['od_id']; ?></td>
            <td align="center"><?php echo $item_caid; ?></br>(<?php echo $item_caname; ?>)</td>               <td class="td_paybybig"><?php echo $s_receipt_way; ?></td>
            <td class="td_numbig td_numsum"><?php echo display_price($amount['order']); ?></td>
            <td class="td_numbig"><?php echo display_price($od['od_send_cost'] + $od['od_send_cost2']); ?></td>
            <td class="td_numbig"><?php echo display_point($od['od_receipt_point']); ?></td>
            <td class="td_numbig td_numincome"><?php echo number_format($amount['receipt']); ?>원</td>
            <td class="td_numbig td_numcoupon"><?php echo display_price($amount['coupon']); ?></td>
            <td class="td_numbig td_numcancel"><?php echo number_format($amount['cancel']); ?>원</td>
        </tr>
        </tbody>
        </table>​

................

 

위와 같이 하면 될것 같은데요....

짧은지식이나마 도움이 되셨으면 좋겠네요??

답변을 작성하시기 전에 로그인 해주세요.
전체 124,153 | RSS
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT