테스트 사이트 - 개발 중인 베타 버전입니다

shop_admin/orderlist.php에서 결제수단

곽선혜 3년 전 조회 2,704

주문내역에서 검색으로 볼때 결제수단 필터가 라디오 박스로 되어있어서,

결제수단 별로 한가씩만 볼 수 있는데요. 

이 부분을 멀티체크가 가능한 체크박스로 변경하여 복수의 결제수단으로 보고싶습니다.

(ex가상계좌, 계좌이체 같이 보기)

 

</p>

<p><?php

$sub_menu = '600001';

include_once('./_common.php');</p>

<p>auth_check($auth[$sub_menu], "r");</p>

<p>$g5['title'] = '주문내역';

include_once (G5_ADMIN_PATH.'/admin.head.php');

include_once(G5_PLUGIN_PATH.'/jquery-ui/datepicker.php');</p>

<p>$where = array();</p>

<p>$doc = strip_tags($doc);

$sort1 = in_array($sort1, array('od_id', 'od_cart_price', 'od_receipt_price', 'od_cancel_price', 'od_misu', 'od_cash', 'od_status', 'od_settle_case')) ? $sort1 : '';

$sort2 = in_array($sort2, array('desc', 'asc')) ? $sort2 : 'desc';

$sel_field = get_search_string($sel_field);

if( !in_array($sel_field, array('od_id', 'mb_id', 'od_name', 'od_tel', 'od_hp', 'od_b_name', 'od_b_tel', 'od_b_hp', 'od_deposit_name', 'od_invoice')) ){   //검색할 필드 대상이 아니면 값을 제거

    $sel_field = '';

}

$od_status = get_search_string($od_status);

$search = get_search_string($search);

if(! preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/", $fr_date) ) $fr_date = '';

if(! preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/", $to_date) ) $to_date = '';</p>

<p>$od_misu = preg_replace('/[^0-9a-z]/i', '', $od_misu);

$od_cancel_price = preg_replace('/[^0-9a-z]/i', '', $od_cancel_price);

$od_refund_price = preg_replace('/[^0-9a-z]/i', '', $od_refund_price);

$od_receipt_point = preg_replace('/[^0-9a-z]/i', '', $od_receipt_point);

$od_coupon = preg_replace('/[^0-9a-z]/i', '', $od_coupon);</p>

<p>$sql_search = "";

if ($search != "") {

    if ($sel_field != "") {

        $where[] = " $sel_field like '%$search%' ";

    }</p>

<p>    if ($save_search != $search) {

        $page = 1;

    }

}</p>

<p>if ($od_status) {

    switch($od_status) {

        case '전체취소':

            $where[] = " od_status = '취소' ";

            break;

        case '부분취소':

            $where[] = " od_status IN('주문', '입금', '준비', '배송', '완료') and od_cancel_price > 0 ";

            break;

        default:

            $where[] = " od_status = '$od_status' ";

            break;

    }</p>

<p>    switch ($od_status) {

        case '주문' :

            $sort1 = "od_id";

            $sort2 = "desc";

            break;

        case '입금' :   // 결제완료

            $sort1 = "od_receipt_time";

            $sort2 = "desc";

            break;

        case '배송' :   // 배송중

            $sort1 = "od_invoice_time";

            $sort2 = "desc";

            break;

    }

}</p>

<p>if ($od_settle_case) {

    $where[] = " od_settle_case = '$od_settle_case' ";

}</p>

<p>if ($od_misu) {

    $where[] = " od_misu != 0 ";

}</p>

<p>if ($od_cancel_price) {

    $where[] = " od_cancel_price != 0 ";

}</p>

<p>if ($od_refund_price) {

    $where[] = " od_refund_price != 0 ";

}</p>

<p>if ($od_receipt_point) {

    $where[] = " od_receipt_point != 0 ";

}</p>

<p>if ($od_coupon) {

    $where[] = " ( od_cart_coupon > 0 or od_coupon > 0 or od_send_coupon > 0 ) ";

}</p>

<p>if ($od_escrow) {

    $where[] = " od_escrow = 1 ";

}</p>

<p>if ($fr_date && $to_date) {

    $where[] = " od_time between '$fr_date 00:00:00' and '$to_date 23:59:59' ";

}</p>

<p>if ($where) {

    $sql_search = ' where '.implode(' and ', $where);

}</p>

<p>if ($sel_field == "")  $sel_field = "od_id";

if ($sort1 == "") $sort1 = "od_id";

if ($sort2 == "") $sort2 = "desc";</p>

<p>$sql_common = " from {$g5['g5_shop_order_table']} $sql_search ";</p>

<p>$sql = " select count(od_id) as cnt " . $sql_common;

$row = sql_fetch($sql);

$total_count = $row['cnt'];</p>

<p>$rows = $config['cf_page_rows'];

$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산

if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)

$from_record = ($page - 1) * $rows; // 시작 열을 구함</p>

<p>$sql  = " select *,

            (od_cart_coupon + od_coupon + od_send_coupon) as couponprice

           $sql_common

           order by $sort1 $sort2

           limit $from_record, $rows ";

$result = sql_query($sql);</p>

<p>$qstr1 = "od_status=".urlencode($od_status)."&amp;od_settle_case=".urlencode($od_settle_case)."&amp;od_misu=$od_misu&amp;od_cancel_price=$od_cancel_price&amp;od_refund_price=$od_refund_price&amp;od_receipt_point=$od_receipt_point&amp;od_coupon=$od_coupon&amp;fr_date=$fr_date&amp;to_date=$to_date&amp;sel_field=$sel_field&amp;search=$search&amp;save_search=$search";

if($default['de_escrow_use'])

    $qstr1 .= "&amp;od_escrow=$od_escrow";

$qstr = "$qstr1&amp;sort1=$sort1&amp;sort2=$sort2&amp;page=$page";</p>

<p>$listall = '<a href="'.$_SERVER['SCRIPT_NAME'].'" class="ov_listall">전체목록</a>';</p>

<p>// 주문삭제 히스토리 테이블 필드 추가

if(!sql_query(" select mb_id from {$g5['g5_shop_order_delete_table']} limit 1 ", false)) {

    sql_query(" ALTER TABLE `{$g5['g5_shop_order_delete_table']}`

                    ADD `mb_id` varchar(20) NOT NULL DEFAULT '' AFTER `de_data`,

                    ADD `de_ip` varchar(255) NOT NULL DEFAULT '' AFTER `mb_id`,

                    ADD `de_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `de_ip` ", true);

}

?></p>

<p><div class="local_ov01 local_ov">

    <?php echo $listall; ?>

    <span class="btn_ov01"><span class="ov_txt">전체 주문내역</span><span class="ov_num"> <?php echo number_format($total_count); ?>건</span></span>

    <?php if($od_status == '준비' && $total_count > 0) { ?>

    <a href="./orderdelivery.php" id="order_delivery" class="ov_a">엑셀배송처리</a>

    <?php } ?>

</div></p>

<p><form name="frmorderlist" class="local_sch01 local_sch">

<input type="hidden" name="doc" value="<?php echo $doc; ?>">

<input type="hidden" name="sort1" value="<?php echo $sort1; ?>">

<input type="hidden" name="sort2" value="<?php echo $sort2; ?>">

<input type="hidden" name="page" value="<?php echo $page; ?>">

<input type="hidden" name="save_search" value="<?php echo $search; ?>"></p>

<p><label for="sel_field" class="sound_only">검색대상</label>

<select name="sel_field" id="sel_field">

    <option value="od_id" <?php echo get_selected($sel_field, 'od_id'); ?>>주문번호</option>

    <option value="mb_id" <?php echo get_selected($sel_field, 'mb_id'); ?>>회원 ID</option>

    <option value="od_name" <?php echo get_selected($sel_field, 'od_name'); ?>>주문자</option>

    <option value="od_tel" <?php echo get_selected($sel_field, 'od_tel'); ?>>주문자전화</option>

    <option value="od_hp" <?php echo get_selected($sel_field, 'od_hp'); ?>>주문자핸드폰</option>

    <option value="od_b_name" <?php echo get_selected($sel_field, 'od_b_name'); ?>>받는분</option>

    <option value="od_b_tel" <?php echo get_selected($sel_field, 'od_b_tel'); ?>>받는분전화</option>

    <option value="od_b_hp" <?php echo get_selected($sel_field, 'od_b_hp'); ?>>받는분핸드폰</option>

    <option value="od_deposit_name" <?php echo get_selected($sel_field, 'od_deposit_name'); ?>>입금자</option>

    <option value="od_invoice" <?php echo get_selected($sel_field, 'od_invoice'); ?>>운송장번호</option>

</select></p>

<p><label for="search" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>

<input type="text" name="search" value="<?php echo $search; ?>" id="search" required class="required frm_input" autocomplete="off">

<input type="submit" value="검색" class="btn_submit"></p>

<p></form></p>

<p><form class="local_sch03 local_sch">

<div>

    <strong>주문상태</strong>

    <input type="radio" name="od_status" value="" id="od_status_all"    <?php echo get_checked($od_status, '');     ?>>

    <label for="od_status_all">전체</label>

    <input type="radio" name="od_status" value="주문" id="od_status_odr" <?php echo get_checked($od_status, '주문'); ?>>

    <label for="od_status_odr">주문</label>

    <input type="radio" name="od_status" value="입금" id="od_status_income" <?php echo get_checked($od_status, '입금'); ?>>

    <label for="od_status_income">입금</label>

    <input type="radio" name="od_status" value="준비" id="od_status_rdy" <?php echo get_checked($od_status, '준비'); ?>>

    <label for="od_status_rdy">준비</label>

    <input type="radio" name="od_status" value="배송" id="od_status_dvr" <?php echo get_checked($od_status, '배송'); ?>>

    <label for="od_status_dvr">배송</label>

    <input type="radio" name="od_status" value="완료" id="od_status_done" <?php echo get_checked($od_status, '완료'); ?>>

    <label for="od_status_done">완료</label>

    <input type="radio" name="od_status" value="전체취소" id="od_status_cancel" <?php echo get_checked($od_status, '전체취소'); ?>>

    <label for="od_status_cancel">전체취소</label>

    <input type="radio" name="od_status" value="부분취소" id="od_status_pcancel" <?php echo get_checked($od_status, '부분취소'); ?>>

    <label for="od_status_pcancel">부분취소</label>

</div></p>

<p><div>

    <strong>결제수단</strong>

    <input type="radio" name="od_settle_case" value="" id="od_settle_case01"        <?php echo get_checked($od_settle_case, '');          ?>>

    <label for="od_settle_case01">전체</label>

    <input type="radio" name="od_settle_case" value="포인트" id="od_settle_case07"   <?php echo get_checked($od_settle_case, '포인트');    ?>>

    <label for="od_settle_case07">포인트</label>

    <input type="radio" name="od_settle_case" value="무통장" id="od_settle_case02"   <?php echo get_checked($od_settle_case, '무통장');    ?>>

    <label for="od_settle_case02">무통장</label>

    <input type="radio" name="od_settle_case" value="가상계좌" id="od_settle_case03" <?php echo get_checked($od_settle_case, '가상계좌');  ?>>

    <label for="od_settle_case03">가상계좌</label>

    <input type="radio" name="od_settle_case" value="계좌이체" id="od_settle_case04" <?php echo get_checked($od_settle_case, '계좌이체');  ?>>

    <label for="od_settle_case04">계좌이체</label>

    <input type="radio" name="od_settle_case" value="휴대폰" id="od_settle_case05"   <?php echo get_checked($od_settle_case, '휴대폰');    ?>>

    <label for="od_settle_case05">휴대폰</label>

    <input type="radio" name="od_settle_case" value="신용카드" id="od_settle_case06" <?php echo get_checked($od_settle_case, '신용카드');  ?>>

    <label for="od_settle_case06">신용카드</label>

    <input type="radio" name="od_settle_case" value="간편결제" id="od_settle_case07" <?php echo get_checked($od_settle_case, '간편결제');  ?>>

    <label for="od_settle_case07">PG간편결제</label>

    <input type="radio" name="od_settle_case" value="KAKAOPAY" id="od_settle_case08" <?php echo get_checked($od_settle_case, 'KAKAOPAY');  ?>>

    <label for="od_settle_case08">KAKAOPAY</label>

</div></p>

<p><div>

    <strong>기타선택</strong>

    <input type="checkbox" name="od_misu" value="Y" id="od_misu01" <?php echo get_checked($od_misu, 'Y'); ?>>

    <label for="od_misu01">미수금</label>

    

    <input type="checkbox" name="od_cancel_price" value="Y" id="od_misu02" <?php echo get_checked($od_cancel_price, 'Y'); ?>>

    <label for="od_misu02">반품,품절</label>

    

    <input type="checkbox" name="od_refund_price" value="Y" id="od_misu03" <?php echo get_checked($od_refund_price, 'Y'); ?>>

    <label for="od_misu03">환불</label>

    

    <input type="checkbox" name="od_receipt_point" value="Y" id="od_misu04" <?php echo get_checked($od_receipt_point, 'Y'); ?>>

    <label for="od_misu04">포인트주문</label>

    

    <input type="checkbox" name="od_coupon" value="Y" id="od_misu05" <?php echo get_checked($od_coupon, 'Y'); ?>>

    <label for="od_misu05">쿠폰</label>

    

    <?php if($default['de_escrow_use']) { ?>

    <input type="checkbox" name="od_escrow" value="Y" id="od_misu06" <?php echo get_checked($od_escrow, 'Y'); ?>>

    <label for="od_misu06">에스크로</label></p>

<p>    <?php } ?>

</div></p>

<p><div class="sch_last">

    <strong>주문일자</strong>

    <input type="text" id="fr_date"  name="fr_date" value="<?php echo $fr_date; ?>" class="frm_input" size="10" maxlength="10"> ~

    <input type="text" id="to_date"  name="to_date" value="<?php echo $to_date; ?>" class="frm_input" size="10" maxlength="10">

    <button type="button" onclick="javascript:set_date('오늘');">오늘</button>

    <button type="button" onclick="javascript:set_date('어제');">어제</button>

    <button type="button" onclick="javascript:set_date('이번주');">이번주</button>

    <button type="button" onclick="javascript:set_date('이번달');">이번달</button>

    <button type="button" onclick="javascript:set_date('지난주');">지난주</button>

    <button type="button" onclick="javascript:set_date('지난달');">지난달</button>

    <button type="button" onclick="javascript:set_date('전체');">전체</button>

    <input type="submit" value="검색" class="btn_submit">

</div>

</form></p>

<p><form name="forderlist" id="forderlist" onsubmit="return forderlist_submit(this);" method="post" autocomplete="off">

<input type="hidden" name="search_od_status" value="<?php echo $od_status; ?>"></p>

<p><div class="tbl_head01 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" rowspan="3">몰 구분</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" rowspan="2">판매액</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_odrid">회원ID</th>

        <th scope="col" id="th_odrcnt">주문상품수</th>

        <th scope="col" id="th_odrall">누적주문수</th>

    </tr>

    <tr>

        <th scope="col" id="odrstat"><a href="<?php echo title_sort("od_status", 1)."&amp;$qstr1"; ?>">주문상태</th>

        <th scope="col" id="odrpay"><a href="<?php echo title_sort("od_settle_case", 1)."&amp;$qstr1"; ?>">결제수단</th>

        <th scope="col" id="delino">운송장번호</th>

        <th scope="col" id="delicom">배송회사</th>

        <th scope="col" id="delidate">배송일시</th>

        <th scope="col">배송비</th>

    </tr>

    </thead>

    <tbody>

    <?php

    for ($i=0; $row=sql_fetch_array($result); $i++)

    {

        // 결제 수단

        $s_receipt_way = $s_br = "";

        if ($row['od_settle_case'])

        {

            $s_receipt_way = ($row['pt_case']) ? $row['pt_case'] : $row['od_settle_case']; // 페이팔 등 반영

            $s_br = '
';</p>

<p>            // 간편결제

            if($row['od_settle_case'] == '간편결제') {

                switch($row['od_pg']) {

                    case 'lg':

                        $s_receipt_way = 'PAYNOW';

                        break;

                    case 'inicis':

                        $s_receipt_way = 'KPAY';

                        break;

                    case 'kcp':

                        $s_receipt_way = 'PAYCO';

                        break;

                    default:

                        $s_receipt_way = $row['od_settle_case'];

                        break;

                }

            }

        }

        else

        {

            $s_receipt_way = '결제수단없음';

            $s_br = '
';

        }</p>

<p>        if ($row['od_receipt_point'] > 0)

            $s_receipt_way .= $s_br."포인트";</p>

<p>        $mb_nick = get_sideview($row['mb_id'], get_text($row['od_name']), $row['od_email'], '');</p>

<p>        $od_cnt = 0;

        if ($row['mb_id'])

        {

            $sql2 = " select count(*) as cnt from {$g5['g5_shop_order_table']} where mb_id = '{$row['mb_id']}' ";

            $row2 = sql_fetch($sql2);

            $od_cnt = $row2['cnt'];

        }</p>

<p>        // 주문 번호에 device 표시

        $od_mobile = '';

        if($row['od_mobile'])

            $od_mobile = '(M)';</p>

<p>        // 주문번호에 - 추가

        switch(strlen($row['od_id'])) {

            case 16:

                $disp_od_id = substr($row['od_id'],0,8).'-'.substr($row['od_id'],8);

                break;

            default:

                $disp_od_id = substr($row['od_id'],0,6).'-'.substr($row['od_id'],6);

                break;

        }</p>

<p>        // 주문 번호에 에스크로 표시

        $od_paytype = '';

        if($row['od_test'])

            $od_paytype .= '<span class="list_test">테스트</span>';</p>

<p>        if($default['de_escrow_use'] && $row['od_escrow'])

            $od_paytype .= '<span class="list_escrow">에스크로</span>';</p>

<p>        $uid = md5($row['od_id'].$row['od_time'].$row['od_ip']);</p>

<p>        $invoice_time = is_null_time($row['od_invoice_time']) ? G5_TIME_YMDHIS : $row['od_invoice_time'];

        $delivery_company = $row['od_delivery_company'] ? $row['od_delivery_company'] : $default['de_delivery_company'];</p>

<p>        $bg = 'bg'.($i%2);

        $td_color = 0;

        if($row['od_cancel_price'] > 0) {

            $bg .= 'cancel';

            $td_color = 1;

        }

    ?>

    <tr class="orderlist<?php echo ' '.$bg; ?>">

        <td rowspan="3" class="td_chk">

            <input type="hidden" name="od_id[<?php echo $i ?>]" value="<?php echo $row['od_id'] ?>" id="od_id_<?php echo $i ?>">

            <label for="chk_<?php echo $i; ?>" class="sound_only">주문번호 <?php echo $row['od_id']; ?></label>

            <input type="checkbox" name="chk[]" value="<?php echo $i ?>" id="chk_<?php echo $i ?>">

        </td>

        <td rowspan="3">

            <?php echo $row['is_b2b'] ? "B2B" : "B2BC"; ?>

        </td>

        <td headers="th_ordnum" class="td_odrnum2" rowspan="2" colspan="2">

            <a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&amp;uid=<?php echo $uid; ?>" class="orderitem"><?php echo $disp_od_id; ?></a>

            <?php echo $od_mobile; ?>

            <?php echo $od_paytype; ?>

        </td>

        <td headers="th_odrer" class="td_name"><?php echo $mb_nick; ?></td>

        <td headers="th_odrertel" class="td_tel"><?php echo get_text($row['od_tel']); ?></td>

        <td headers="th_recvr" class="td_name"><a href="<?php echo $_SERVER['SCRIPT_NAME']; ?>?sort1=<?php echo $sort1; ?>&amp;sort2=<?php echo $sort2; ?>&amp;sel_field=od_b_name&amp;search=<?php echo get_text($row['od_b_name']); ?>"><?php echo get_text($row['od_b_name']); ?></a></td>

        <td rowspan="2" class="td_num_right"><?php echo number_format($row['od_cart_price'])?></td>

        <td rowspan="3" class="td_num_right td_numsum">

            <?php echo number_format($row['od_receipt_price']); ?>

            <?php if($row['pt_price']) { //페이팔 등 결제금액 ?>

                
(<?php echo $row['pt_price'];?>)

            <?php } ?>

        </td>

        <td rowspan="3" class="td_numcancel<?php echo $td_color; ?> td_num"><?php echo number_format($row['od_cancel_price']); ?></td>

        <td rowspan="3" class="td_num_right"><?php echo number_format($row['couponprice']); ?></td>

        <td rowspan="3" class="td_num_right"><?php echo number_format($row['od_misu']); ?></td>

        <td rowspan="3" class="td_mng td_mng_s">

            <a href="./orderform.php?od_id=<?php echo $row['od_id']; ?>&amp;<?php echo $qstr; ?>" class="mng_mod btn btn_02"><span class="sound_only"><?php echo $row['od_id']; ?> </span>보기</a></p>

<p>            <?php if($row['wms_stock']=="Y"){ ?>

            <!--<div style="background-color:blue;color:white;font-weight:bold;padding:3px 5px;">출고완료</div>-->

      <?php }else if($row['od_status']=="입금" || $row['od_status']=="준비"){ ?>

            <div class="outorder" pidx="<?php echo $row['od_id'] ?>" style="background-color:red;color:white;padding:3px 5px;">출고하기</div>

            <?php }?></p>

<p>        </td>

    </tr>

    <tr class="<?php echo $bg; ?>">

        <td headers="th_odrid">

            <?php if ($row['mb_id']) { ?>

            <a href="<?php echo $_SERVER['SCRIPT_NAME']; ?>?sort1=<?php echo $sort1; ?>&amp;sort2=<?php echo $sort2; ?>&amp;sel_field=mb_id&amp;search=<?php echo $row['mb_id']; ?>"><?php echo $row['mb_id']; ?></a>

            <?php } else { ?>

            비회원

            <?php } ?>

        </td>

        <td headers="th_odrcnt"><?php echo $row['od_cart_count']; ?>건</td>

        <td headers="th_odrall"><?php echo $od_cnt; ?>건</td>

    </tr>

    <tr class="<?php echo $bg; ?>">

        <td headers="odrstat" class="odrstat">

            <input type="hidden" name="current_status[<?php echo $i ?>]" value="<?php echo $row['od_status'] ?>">

            <?php echo $row['od_status']; ?>

        </td>

        <td headers="odrpay" class="odrpay">

            <input type="hidden" name="current_settle_case[<?php echo $i ?>]" value="<?php echo $row['od_settle_case'] ?>">

            <?php echo $s_receipt_way; ?>

        </td>

        <td headers="delino" class="delino">

            <?php if ($od_status == '준비') { ?>

                <input type="text" name="od_invoice[<?php echo $i; ?>]" value="<?php echo $row['od_invoice']; ?>" class="frm_input" size="10">

            <?php } else {

                echo ($row['od_invoice'] ? $row['od_invoice'] : '-');

            } ?>

        </td>

        <td headers="delicom">

            <?php if ($od_status == '준비') { ?>

                <select name="od_delivery_company[<?php echo $i; ?>]">

                    <?php echo get_delivery_company($delivery_company); ?>

                </select>

            <?php } else {

                echo ($row['od_delivery_company'] ? $row['od_delivery_company'] : '-');

            } ?>

        </td>

        <td headers="delidate">

            <?php if ($od_status == '준비') { ?>

                <input type="text" name="od_invoice_time[<?php echo $i; ?>]" value="<?php echo $invoice_time; ?>" class="frm_input" size="10" maxlength="19">

            <?php } else {

                echo (is_null_time($row['od_invoice_time']) ? '-' : substr($row['od_invoice_time'],2,14));

            } ?>

        </td>

        <td class="td_num_right">

            <?php echo number_format($row['od_send_cost'] + $row['od_send_cost2']); ?>

        </td>

    </tr>

    <?php

        $tot_itemcount     += $row['od_cart_count'];

        $tot_orderprice    += ($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']);

        $tot_ordercancel   += $row['od_cancel_price'];

        $tot_receiptprice  += $row['od_receipt_price'];

        $tot_couponprice   += $row['couponprice'];

        $tot_misu          += $row['od_misu'];

    }

    sql_free_result($result);

    if ($i == 0)

        echo '<tr><td colspan="12" class="empty_table">자료가 없습니다.</td></tr>';

    ?>

    </tbody>

    <tfoot>

    <tr class="orderlist">

        <th scope="row" colspan="3"> </th>

        <td> </td>

        <td><?php echo number_format($tot_itemcount); ?>건</td>

        <th scope="row">합 계</th>

        <td><?php echo number_format($tot_orderprice); ?></td>

        <td><?php echo number_format($tot_receiptprice); ?></td>

        <td><?php echo number_format($tot_ordercancel); ?></td>

        <td><?php echo number_format($tot_couponprice); ?></td>

        <td><?php echo number_format($tot_misu); ?></td>

        <td></td>

    </tr>

    </tfoot>

    </table>

</div></p>

<p><div class="local_cmd01 local_cmd">

<?php if (($od_status == '' || $od_status == '완료' || $od_status == '전체취소' || $od_status == '부분취소') == false) {

    // 검색된 주문상태가 '전체', '완료', '전체취소', '부분취소' 가 아니라면

?>

    <label for="od_status" class="cmd_tit">주문상태 변경</label>

    <?php

    $change_status = "";

    if ($od_status == '주문') $change_status = "입금";

    if ($od_status == '입금') $change_status = "준비";

    if ($od_status == '준비') $change_status = "배송";

    if ($od_status == '배송') $change_status = "완료";

    ?>

    <label><input type="checkbox" name="od_status" value="<?php echo $change_status; ?>"> '<?php echo $od_status ?>'상태에서 '<strong><?php echo $change_status ?></strong>'상태로 변경합니다.</label>

    <?php if($od_status == '주문' || $od_status == '준비') { ?>

    <input type="checkbox" name="od_send_mail" value="1" id="od_send_mail" checked="checked">

    <label for="od_send_mail"><?php echo $change_status; ?>안내 메일</label>

    <input type="checkbox" name="send_sms" value="1" id="od_send_sms" checked="checked">

    <label for="od_send_sms"><?php echo $change_status; ?>안내 SMS</label>

    <?php } ?>

    <?php if($od_status == '준비') { ?>

    <input type="checkbox" name="send_escrow" value="1" id="od_send_escrow">

    <label for="od_send_escrow">에스크로배송등록</label>

    <?php } ?>

    <input type="submit" value="선택수정" class="btn_submit" onclick="document.pressed=this.value">

<?php } ?>

    <?php if ($od_status == '주문' || $od_status == '전체취소') { ?> <span>주문 또는 전체취소 상태에서만 삭제가 가능하며, 전체취소는 입금액이 없는 주문만 삭제됩니다.</span> <input type="submit" value="선택삭제" class="btn_submit" onclick="document.pressed=this.value"><?php } ?>

</div></p>

<p><div class="local_desc02 local_desc">

<p>

    &lt;무통장&gt;인 경우에만 &lt;주문&gt;에서 &lt;입금&gt;으로 변경됩니다. 가상계좌는 입금시 자동으로 &lt;입금&gt;처리됩니다.


    &lt;준비&gt;에서 &lt;배송&gt;으로 변경시 &lt;에스크로배송등록&gt;을 체크하시면 에스크로 주문에 한해 PG사에 배송정보가 자동 등록됩니다.


    <strong>주의!</strong> 주문번호를 클릭하여 나오는 주문상세내역의 주소를 외부에서 조회가 가능한곳에 올리지 마십시오.

</p>

</div></p>

<p></form></p>

<p><?php echo get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, "{$_SERVER['SCRIPT_NAME']}?$qstr&amp;page="); ?></p>

<p><script></p>

<p>

$(".outorder").click(function(){

    var clickComponent = $(this);</p>

<p>    $.post("./ajax.stockitem.php",

        { od_id: $(this).attr("pidx") },

        function(data) {

            if(data){

              alert("출고되었습니다.");

            }else{

              alert("이미 출고처리가 된 주문입니다.");

            }

            clickComponent.css('background-color','black');

            clickComponent.css('color','black');

        }

    );</p>

<p>});</p>

<p>

$(function(){

    $("#fr_date, #to_date").datepicker({ changeMonth: true, changeYear: true, dateFormat: "yy-mm-dd", showButtonPanel: true, yearRange: "c-99:c+99", maxDate: "+0d" });</p>

<p>    // 주문상품보기

    $(".orderitem").on("click", function() {

        var $this = $(this);

        var od_id = $this.text().replace(/[^0-9]/g, "");</p>

<p>        if($this.next("#orderitemlist").size())

            return false;</p>

<p>        $("#orderitemlist").remove();</p>

<p>        $.post(

            "./ajax.orderitem.php",

            { od_id: od_id },

            function(data) {

                $this.after("<div id=\"orderitemlist\"><div class=\"itemlist\"></div></div>");

                $("#orderitemlist .itemlist")

                    .html(data)

                    .append("<div id=\"orderitemlist_close\"><button type=\"button\" id=\"orderitemlist-x\" class=\"btn_frmline\">닫기</button></div>");

            }

        );</p>

<p>        return false;

    });</p>

<p>    // 상품리스트 닫기

    $(".orderitemlist-x").on("click", function() {

        $("#orderitemlist").remove();

    });</p>

<p>    $("body").on("click", function() {

        $("#orderitemlist").remove();

    });</p>

<p>    // 엑셀배송처리창

    $("#order_delivery").on("click", function() {

        var opt = "width=600,height=450,left=10,top=10";

        window.open(this.href, "win_excel", opt);

        return false;

    });

});</p>

<p>function set_date(today)

{

    <?php

    $date_term = date('w', G5_SERVER_TIME);

    $week_term = $date_term + 7;

    $last_term = strtotime(date('Y-m-01', G5_SERVER_TIME));

    ?>

    if (today == "오늘") {

        document.getElementById("fr_date").value = "<?php echo G5_TIME_YMD; ?>";

        document.getElementById("to_date").value = "<?php echo G5_TIME_YMD; ?>";

    } else if (today == "어제") {

        document.getElementById("fr_date").value = "<?php echo date('Y-m-d', G5_SERVER_TIME - 86400); ?>";

        document.getElementById("to_date").value = "<?php echo date('Y-m-d', G5_SERVER_TIME - 86400); ?>";

    } else if (today == "이번주") {

        document.getElementById("fr_date").value = "<?php echo date('Y-m-d', strtotime('-'.$date_term.' days', G5_SERVER_TIME)); ?>";

        document.getElementById("to_date").value = "<?php echo date('Y-m-d', G5_SERVER_TIME); ?>";

    } else if (today == "이번달") {

        document.getElementById("fr_date").value = "<?php echo date('Y-m-01', G5_SERVER_TIME); ?>";

        document.getElementById("to_date").value = "<?php echo date('Y-m-d', G5_SERVER_TIME); ?>";

    } else if (today == "지난주") {

        document.getElementById("fr_date").value = "<?php echo date('Y-m-d', strtotime('-'.$week_term.' days', G5_SERVER_TIME)); ?>";

        document.getElementById("to_date").value = "<?php echo date('Y-m-d', strtotime('-'.($week_term - 6).' days', G5_SERVER_TIME)); ?>";

    } else if (today == "지난달") {

        document.getElementById("fr_date").value = "<?php echo date('Y-m-01', strtotime('-1 Month', $last_term)); ?>";

        document.getElementById("to_date").value = "<?php echo date('Y-m-t', strtotime('-1 Month', $last_term)); ?>";

    } else if (today == "전체") {

        document.getElementById("fr_date").value = "";

        document.getElementById("to_date").value = "";

    }

}

</script></p>

<p><script>

function forderlist_submit(f)

{

    if (!is_checked("chk[]")) {

        alert(document.pressed+" 하실 항목을 하나 이상 선택하세요.");

        return false;

    }</p>

<p>    /*

    switch (f.od_status.value) {

        case "" :

            alert("변경하실 주문상태를 선택하세요.");

            return false;

        case '주문' :</p>

<p>        default :</p>

<p>    }

    */</p>

<p>    if(document.pressed == "선택삭제") {

        if(confirm("선택한 자료를 정말 삭제하시겠습니까?")) {

            f.action = "./orderlistdelete.php";

            return true;

        }

        return false;

    }</p>

<p>    var change_status = f.od_status.value;</p>

<p>    if (f.od_status.checked == false) {

        alert("주문상태 변경에 체크하세요.");

        return false;

    }</p>

<p>    var chk = document.getElementsByName("chk[]");</p>

<p>    for (var i=0; i<chk.length; i++)

    {

        if (chk[i].checked)

        {

            var k = chk[i].value;

            var current_settle_case = f.elements['current_settle_case['+k+']'].value;

            var current_status = f.elements['current_status['+k+']'].value;</p>

<p>            switch (change_status)

            {

                case "입금" :

                    if (!(current_status == "주문" && current_settle_case == "무통장")) {

                        alert("'주문' 상태의 '무통장'(결제수단)인 경우에만 '입금' 처리 가능합니다.");

                        return false;

                    }

                    break;</p>

<p>                case "준비" :

                    if (current_status != "입금") {

                        alert("'입금' 상태의 주문만 '준비'로 변경이 가능합니다.");

                        return false;

                    }

                    break;</p>

<p>                case "배송" :

                    if (current_status != "준비") {

                        alert("'준비' 상태의 주문만 '배송'으로 변경이 가능합니다.");

                        return false;

                    }</p>

<p>                    var invoice      = f.elements['od_invoice['+k+']'];

                    var invoice_time = f.elements['od_invoice_time['+k+']'];

                    var delivery_company = f.elements['od_delivery_company['+k+']'];</p>

<p>                    if ($.trim(invoice_time.value) == '') {

                        alert("배송일시를 입력하시기 바랍니다.");

                        invoice_time.focus();

                        return false;

                    }</p>

<p>                    if ($.trim(delivery_company.value) == '') {

                        alert("배송업체를 입력하시기 바랍니다.");

                        delivery_company.focus();

                        return false;

                    }</p>

<p>                    if ($.trim(invoice.value) == '') {

                        alert("운송장번호를 입력하시기 바랍니다.");

                        invoice.focus();

                        return false;

                    }</p>

<p>                    break;

            }

        }

    }</p>

<p>    if (!confirm("선택하신 주문서의 주문상태를 '"+change_status+"'상태로 변경하시겠습니까?"))

        return false;</p>

<p>    f.action = "./orderlistupdate.php";

    return true;

}

</script></p>

<p><?php

include_once (G5_ADMIN_PATH.'/admin.tail.php');

?></p>

<p>

 

위의 소스코드 값 중 아래 내용처럼

<input type="radio" 부분을 <input type="checkbox"로 변경하였습니다.

 

</p>

<p><div>

    <strong>결제수단</strong>

    <input type="radio" name="od_settle_case" value="" id="od_settle_case01"        <?php echo get_checked($od_settle_case, '');          ?>>

    <label for="od_settle_case01">전체</label>

    <input type="radio" name="od_settle_case" value="포인트" id="od_settle_case07"   <?php echo get_checked($od_settle_case, '포인트');    ?>>

    <label for="od_settle_case07">포인트</label>

    <input type="radio" name="od_settle_case" value="무통장" id="od_settle_case02"   <?php echo get_checked($od_settle_case, '무통장');    ?>>

    <label for="od_settle_case02">무통장</label>

    <input type="radio" name="od_settle_case" value="가상계좌" id="od_settle_case03" <?php echo get_checked($od_settle_case, '가상계좌');  ?>>

    <label for="od_settle_case03">가상계좌</label>

    <input type="radio" name="od_settle_case" value="계좌이체" id="od_settle_case04" <?php echo get_checked($od_settle_case, '계좌이체');  ?>>

    <label for="od_settle_case04">계좌이체</label>

    <input type="radio" name="od_settle_case" value="휴대폰" id="od_settle_case05"   <?php echo get_checked($od_settle_case, '휴대폰');    ?>>

    <label for="od_settle_case05">휴대폰</label>

    <input type="radio" name="od_settle_case" value="신용카드" id="od_settle_case06" <?php echo get_checked($od_settle_case, '신용카드');  ?>>

    <label for="od_settle_case06">신용카드</label>

    <input type="radio" name="od_settle_case" value="간편결제" id="od_settle_case07" <?php echo get_checked($od_settle_case, '간편결제');  ?>>

    <label for="od_settle_case07">PG간편결제</label>

    <input type="radio" name="od_settle_case" value="KAKAOPAY" id="od_settle_case08" <?php echo get_checked($od_settle_case, 'KAKAOPAY');  ?>>

    <label for="od_settle_case08">KAKAOPAY</label>

</div></p>

<p>

 

그런데 체크박스로 모양만 변경되었고, 기능자체는 라디오버튼처럼 

마지막에 선택한 항목만 확인이 됩니다.

(ex. 무통장, 가상계좌 체크 시 마지막에 체크한 가상계좌 항목만 검색)

멀티체크가 적용이 안되는 듯 합니다. 

전문가님들의 답변 부탁드립니다 ㅠㅠ

댓글을 작성하려면 로그인이 필요합니다.

답변 1개

멀티체크로 하셨으면

당연히 받와서 처리하는 쿼리도 수정을 해주셔야합니다.

 

생각보다 고쳐야될 부분이 있어서 상세하게 다 말씀드리긴 힘들지만

type만 radio에서 checkbox로 바꾸는것이 아닌 name값도 배열로 바꿔주셔야합니다.

배열로 받은 값을 적절히 처리하여 쿼리로 수정해주시면 됩니다.

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인