Пример #1
0
        <th scope="col"><a href="<?php 
echo title_sort("b.it_name") . "&amp;{$qstr1}";
?>
">상품명</a></th>
        <th scope="col">옵션항목</th>
        <th scope="col">옵션타입</th>
        <th scope="col"><a href="<?php 
echo title_sort("a.io_stock_qty") . "&amp;{$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") . "&amp;{$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 = '';
Пример #2
0
?>
">창고재고</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") . "&amp;{$qstr1}";
?>
">판매</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("it_soldout") . "&amp;{$qstr1}";
?>
">품절</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("it_stock_sms") . "&amp;{$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);
Пример #3
0
<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") . '&amp;' . $qstr1 . '&amp;ev_id=' . $ev_id;
?>
">상품코드</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("it_name") . '&&amp;' . $qstr1 . '&amp;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) {
Пример #5
0
?>
">완료</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("ct_status_7", 1) . "&amp;{$qstr1}";
?>
">취소</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("ct_status_8", 1) . "&amp;{$qstr1}";
?>
">반품</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("ct_status_9", 1) . "&amp;{$qstr1}";
?>
">품절</a></th>
        <th scope="col"><a href="<?php 
echo title_sort("ct_status_sum", 1) . "&amp;{$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;
    ?>
">
Пример #6
0
">주문번호</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") . "&amp;{$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>
Пример #7
0
    <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) . "&amp;{$qstr1}";
?>
">주문번호</a></th> -->
                    <th scope="col" id="th_odrnum" rowspan="2" colspan="2"><a href="<?php 
echo title_sort("od_id", 1) . "&amp;{$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>