주문내역에서 상품분류코드가 보였으면합니다
본문
<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>
답변 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>
................
위와 같이 하면 될것 같은데요....
짧은지식이나마 도움이 되셨으면 좋겠네요??
감사합니다.