1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

<?php
include("./_common.php");
include_once($j3_path."/header.sub.php");
?>
<link href="<?php echo $j3_adm_url;?>/css/admin.css" rel="stylesheet" />

 <style>
    .cust_modal1, 
    .cust_modal2 { border:0px solid #e1e1e1; width:790px; padding:10px; font-size:13px }
    .cust_modal1 h4, 
    .cust_modal2 h4 { position:relative; top:-5px; font-size:14px; font-weight:bold; }
    .cust_modal2 { margin-top:0px; }
    .table-top-border tbody { border-top:1px solid #e1e1e1;}
    .cust_modal1 table tbody td,
    .cust_modal2 table tbody td { text-align:left; padding-left:5px;  }
    .cust_modal1 table tbody td input,
    .cust_modal2 table tbody td input{ border:1px solid #e9e9e9;  }
    .input_readonly {background:#E9E9E9; }
    .width_500 { width:500px !important; }
    .width_80 { width:80px !important; }
    .width_120 { width:120px !important; }
</style>
<form name="fitemexcel" method="post" action="./order_deli_xls_process.php" enctype="MULTIPART/FORM-DATA" autocomplete="off">
<div class='cust_modal1'>
    <h4>운송장 엑셀업로드</h4>
    <table class="order-sheet table-top-border">
        <caption class="screen_out">운송장 엑셀업로드</caption>
        <colgroup>
            <col style="width:100px;"><col style="width:500px;">
        </colgroup>

        <tbody>
        <tr>
            <td colspan=3>
                엑셀파일을 이용하여 운송장번호를 일괄갱신할 수 있습니다.<br>
                항목은 엑셀에 주문번호, 배송업체, 운송장번호 3개의 라인으로 입력하시면 됩니다.<br>
                엑셀입력시 주문번호는 서식설정에 따라서 끝자리 짤릴수 있으므로 셀서식을 텍스트로 변경하고 사용하셔야 합니다.<br>
                주문번호는 주문의 상태값과 상관없이 업데이트 되므로(<strong>배송중이나 배송완료주문 갱신가능을 위해서</strong>) 정확히 등록하시기 바랍니다.<br>
                엑셀파일을 저장하실 때는 <strong>Excel 97 - 2003 통합문서 (*.xls)</strong> 로 저장하셔야 합니다.<br>
                배송안내 메일과 배송안내 SMS는 <strong>배송중체크</strong>할때만 동작합니다.<br>
                <strong class='ready_down'>[전체배송준비]</strong> 다운로드
            </td>
        </tr>
        <tr>
            <th>옵션</th>
            <td colspan=3>
                <input type='checkbox' name='ordstate' value='2'> 배송중으로 변경&nbsp;
                <input type='checkbox' name='s_mail' value='Y'> 배송안내 메일&nbsp;
                <input type='checkbox' name='s_sms' value='Y'> 배송안내 SMS&nbsp;
            </td>
        </tr>
        <tr>
            <th>파일선택</th>
            <td colspan=3><input type="file" name="excelfile" id="excelfile"></td>
        </tr>
    </table>
</div>

    <div id="sub-contents-area" style='padding-left:270px;padding-top:20px;'>
        <div class="sub-btn-area">
            <div class="sub-btn">
                <a class="lignt-blue-btn" id='btn_product_save'>업로드</a>
                <a class="gray-btn" id='btn_cancel_open'><?php if($code==''){?>취소<?php } else {?>목록<?php }?></a>
            </div>
        </div>
    </div>
</form>
</div>
<script>
$(function(){
    $("#btn_product_save").click(function(){
        $("form[name='fitemexcel']").submit();
    });
    $("#btn_cancel_open").click(function(){ // 닫기
        window.close();
    });

    $(".ready_down").css("cursor","pointer").click(function(){
        $url = "order_deli_xls.php";
        document.location.href=$url;
    });
});
</script>