<th scope="col"><a href="<?php echo title_sort("b.it_name") . "&{$qstr1}"; ?> ">상품명</a></th> <th scope="col">옵션항목</th> <th scope="col">옵션타입</th> <th scope="col"><a href="<?php echo title_sort("a.io_stock_qty") . "&{$qstr1}"; ?> ">창고재고</a></th> <th scope="col">주문대기</th> <th scope="col">가재고</th> <th scope="col">재고수정</th> <th scope="col">통보수량</th> <th scope="col"><a href="<?php echo title_sort("a.io_use") . "&{$qstr1}"; ?> ">판매</a></th> <th scope="col">관리</th> </tr> </thead> <tbody> <?php for ($i = 0; $row = sql_fetch_array($result); $i++) { $href = G5_SHOP_URL . "/item.php?it_id={$row['it_id']}"; $sql1 = " select SUM(ct_qty) as sum_qty\n from {$g5['g5_shop_cart_table']}\n where it_id = '{$row['it_id']}'\n and io_id = '{$row['io_id']}'\n and ct_stock_use = '0'\n and ct_status in ('쇼핑', '주문', '입금', '준비') "; $row1 = sql_fetch($sql1); $wait_qty = $row1['sum_qty']; // 가재고 (미래재고) $temporary_qty = $row['io_stock_qty'] - $wait_qty; $option = '';
?> ">창고재고</a></th> <th scope="col">주문대기</th> <th scope="col">가재고</th> <th scope="col">재고수정</th> <th scope="col">통보수량</th> <th scope="col"><a href="<?php echo title_sort("it_use") . "&{$qstr1}"; ?> ">판매</a></th> <th scope="col"><a href="<?php echo title_sort("it_soldout") . "&{$qstr1}"; ?> ">품절</a></th> <th scope="col"><a href="<?php echo title_sort("it_stock_sms") . "&{$qstr1}"; ?> ">재입고알림</a></th> <th scope="col">관리</th> </tr> </thead> <tbody> <?php for ($i = 0; $row = mysql_fetch_array($result); $i++) { $href = G5_SHOP_URL . "/item.php?it_id={$row['it_id']}"; // 선택옵션이 있을 경우 주문대기 수량 계산하지 않음 $sql2 = " select count(*) as cnt from {$g5['g5_shop_item_option_table']} where it_id = '{$row['it_id']}' and io_type = '0' and io_use = '1' "; $row2 = sql_fetch($sql2); if (!$row2['cnt']) { $sql1 = " select SUM(ct_qty) as sum_qty\n from {$g5['g5_shop_cart_table']}\n where it_id = '{$row['it_id']}'\n and ct_stock_use = '0'\n and ct_status in ('쇼핑', '주문', '입금', '준비') "; $row1 = sql_fetch($sql1);
<div class="tbl_head01 tbl_wrap"> <table> <caption><?php echo $g5['title']; ?> 목록</caption> <thead> <tr> <th scope="col">이벤트</th> <th scope="col"><a href="<?php echo title_sort("a.it_id") . '&' . $qstr1 . '&ev_id=' . $ev_id; ?> ">상품코드</a></th> <th scope="col"><a href="<?php echo title_sort("it_name") . '&&' . $qstr1 . '&ev_id=' . $ev_id; ?> ">상품명</a></th> </tr> </thead> <tbody> <?php for ($i = 0; $row = mysql_fetch_array($result); $i++) { $href = G5_SHOP_URL . '/item.php?it_id=' . $row['it_id']; $sql = " select ev_id from {$g5['g5_shop_event_item_table']}\n where it_id = '{$row['it_id']}'\n and ev_id = '{$ev_id}' "; $ev = sql_fetch($sql); $bg = 'bg' . $i % 2; ?> <tr class="<?php echo $bg;
return $posts; } function post_count_exceeds() { $postHandler =& wp_handler('Post'); $GLOBALS['current_posts_criteria']->setGroupBy(''); $postObjects =& $postHandler->getObjects($GLOBALS['current_posts_criteria'], false, 'count(DISTINCT ID) numposts', '', $GLOBALS['current_posts_join']); $numposts = $postObjects[0]->getExtraVar('numposts'); if ($GLOBALS['posts_per_page'] != -1 && $numposts > $GLOBALS['posts_per_page']) { echo '<p><b>' . sprintf(_LANG_NKA_EXCEEDS_COUNT, $GLOBALS['posts_per_page']) . '</b></p>'; } } $GLOBALS['show_cblock'] = 0; include 'header.php'; if (get_param('orderby') == 'title') { title_sort($posts); } $myurl = $siteurl . '/' . basename(__FILE__); ?> <div id="rap"> <h2 id="header"><a href="<?php bloginfo('url'); ?> "><?php bloginfo('name'); ?> </a></h2> <div id="wpMainContent"> <script language="javascript" type="text/javascript"> function Choose(whichSort) { if (whichSort.selectedIndex == 0) {
?> ">완료</a></th> <th scope="col"><a href="<?php echo title_sort("ct_status_7", 1) . "&{$qstr1}"; ?> ">취소</a></th> <th scope="col"><a href="<?php echo title_sort("ct_status_8", 1) . "&{$qstr1}"; ?> ">반품</a></th> <th scope="col"><a href="<?php echo title_sort("ct_status_9", 1) . "&{$qstr1}"; ?> ">품절</a></th> <th scope="col"><a href="<?php echo title_sort("ct_status_sum", 1) . "&{$qstr1}"; ?> ">합계</a></th> </tr> </thead> <tbody> <?php for ($i = 0; $row = sql_fetch_array($result); $i++) { $href = G5_SHOP_URL . "/item.php?it_id={$row['it_id']}"; $num = $rank + $i + 1; $bg = 'bg' . $i % 2; ?> <tr class="<?php echo $bg; ?> ">
">주문번호</a></th> <th scope="col" id="th_odrer">주문자</th> <th scope="col" id="th_odrertel">주문자전화</th> <th scope="col" id="th_recvr">받는분</th> <th scope="col" rowspan="3">주문합계<br>선불배송비포함</th> <th scope="col" rowspan="3">입금합계</th> <th scope="col" rowspan="3">주문취소</th> <th scope="col" rowspan="3">쿠폰</th> <th scope="col" rowspan="3">미수금</th> <th scope="col" rowspan="3">보기</th> </tr> <tr> <!-- <th scope="col" id="th_odrdate">주문일시</th> --> <!-- <th scope="col">결제수단</th> --> <!-- <th scope="col" id="th_odrid"><a href="<?php echo title_sort("mb_id") . "&{$qstr1}"; ?> ">회원ID</a></th> --> <th scope="col" id="th_odrid">회원ID</th> <th scope="col" id="th_odrcnt">주문상품수</th> <th scope="col" id="th_odrall">누적주문수</th> </tr> <tr> <!-- <th scope="col">배송일시</th> --> <th scope="col" id="odrstat">주문상태</th> <th scope="col" id="odrpay">결제수단</th> <th scope="col" id="delino">운송장번호</th> <th scope="col" id="delicom">배송회사</th> <th scope="col" id="delidate">배송일시</th> </tr> </thead>
<div class="tbl_head02 tbl_wrap"> <table id="sodr_list"> <caption>주문 내역 목록</caption> <thead> <tr> <th scope="col" rowspan="3"> <label for="chkall" class="sound_only">주문 전체</label> <input type="checkbox" name="chkall" value="1" id="chkall" onclick="check_all(this.form)"> </th> <!-- <th scope="col" id="th_odrnum"><a href="<?php echo title_sort("od_id", 1) . "&{$qstr1}"; ?> ">주문번호</a></th> --> <th scope="col" id="th_odrnum" rowspan="2" colspan="2"><a href="<?php echo title_sort("od_id", 1) . "&{$qstr1}"; ?> ">주문번호</a></th> <!--<th scope="col" id="th_odrer">주문자</th> <th scope="col" id="th_odrertel">주문자전화</th> <th scope="col" id="th_recvr">받는분</th>--> <th scope="col" id="th_odrid">회원ID</th> <th scope="col" id="delino">운송장번호</th> <th scope="col" rowspan="3" >주문자 정보</th> <th scope="col" rowspan="2">상품정보</th> <th scope="col" rowspan="3" >배송지정보</th> <th scope="col" rowspan="3">주문합계<br>선불배송비포함</th> <th scope="col" rowspan="3">입금합계</th> <th scope="col" rowspan="3">주문취소</th> <!--<th scope="col" rowspan="3">쿠폰</th>--> <th scope="col" rowspan="3">미수금</th>