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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
<?php
include_once("./_common.php");
$cuscode = $id_ccode;
$sacode = $configshop["office_code"];
if($txtdate==''){ $txtdate = date("Y-m-d",time()-(60*60*24*7)); }
if($txtdate2==''){ $txtdate2 = date("Y-m-d",time()); }
$optionqry = "SELECT optname, optvalue FROM options";
$optresult = mysql_query($optionqry,$connect_j3);
while( $optrow = mysql_fetch_array($optresult)){
//$optrow['optname'] = iconv_utf8($optrow['optname']);
if($optrow['optname'] == "ON라인신규고객등록") $optnew = $optrow['optvalue'];
if($optrow['optname'] == "ON주문시금액숨김") $optmhide = $optrow['optvalue'];
if($optrow['optname'] == "주문한도숨김") $optlimit = $optrow['optvalue'];
if($optrow['optname'] == "선수금주문방식") $optsmoney = $optrow['optvalue']; // <선수금> 만큼만 주문허용
if($optrow['optname'] == "ON지정상품분류") $optcate = $optrow['optvalue'];
if($optrow['optname'] == "ON지정상품") $optpro = $optrow['optvalue'];
if($optrow['optname'] == "ON특별단가적용") $optonspe = $optrow['optvalue'];
if($optrow['optname'] == ("특별단가적용방식". $sacode)) $optspemode = $optrow['optvalue'];
if($optrow['optname'] == "상품매출가숨김") $optpophide = $optrow['optvalue'];
//$optpophide = 1; $optmhide = '1'; // 임시로 온 표시
//$optinvnqnt = 1; // 임시로 온 표시
if($optrow['optname'] == "온주상품비고숨김") $optproductbigo = $optrow['optvalue'];
if($optrow['optname'] == "금액소수점수") $pricepoint = $optrow['optvalue'];
if($optrow['optname'] == "단가소수점수") $unitpoint = $optrow['optvalue'];
if($optrow['optname'] == "수량소수점수") $amountpoint = $optrow['optvalue'];
if($optrow['optname'] == "ON거래처별할인적용") $sp_danga_sale = $optrow['optvalue'];
if($optrow['optname'] == "특별단가거래처할인") $sp_danga_cate_sale = $optrow['optvalue']; // 특별단가 옵션에 거래처별/소분류 할인 적용
if($optrow['optname'] == "온주세트상품조회") $sp_set_view = $optrow['optvalue'];
//if($optrow['optname'] == "선수금주문방식") $sp_allow_overincome = $optrow['optvalue']; // <선수금> 만큼만 주문허용
// 정상 옵션
if($optrow['optname'] == "특별단가사용") $optspe = $optrow['optvalue'];
if($optrow['optname'] == "다중단가계산기준Sale") $optdac = $optrow['optvalue']; //0 매입단가 1매출단가 2기준단가
if($optrow['optname'] == "원단위자리수") $optwon = $optrow['optvalue'];
if($optrow['optname'] == "원단위처리") $optwoncut = $optrow['optvalue'];
if($optrow['optname'] == "특별DC사용") $sp_dc_use = $optrow['optvalue'];
if($optrow['optname'] == "ON주문시박스관리") $optbox = $optrow['optvalue'];
if($optrow['optname'] == "ON현재고표시") $optinvnqnt = $optrow['optvalue'];
}
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=buylist_".date("YmdHis",time()).".xls" );
header( "Content-Description: PHP4 Generated Data" );
?>
<!DOCTYPE html>
<html lang="ko">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>천년경영 온라인 수발주</title>
<link href="http://ord.mjsoft.co/onlinecs3/css/reset.css" rel="stylesheet" />
<link href="http://ord.mjsoft.co/onlinecs3/css/layout.css" rel="stylesheet" />
<link href="http://ord.mjsoft.co/onlinecs3/css/base.css" rel="stylesheet" />
<link href="http://ord.mjsoft.co/onlinecs3/css/top.css" rel="stylesheet" />
<style>
/* Sub : 테이블 */
.order-sheet-area {margin-top:10px; width:960px; border-top:0px solid #000}
.order-sheet {width:100%}
.order-sheet th {height:36px; line-height:36px; text-align:center; font-weight:600; border-bottom:1px solid #E1E1E1; background:#f7f7f7}
.order-sheet td {height:32px; line-height:32px; text-align:center; border-bottom:1px solid #E1E1E1}
.order-sheet td input[type=text] {padding:0 5px; width:170px; height:24px; line-height:24px}
.order-sheet td input.long-text {width:810px}
.order-sheet .step span {font-weight:600}
.order-sheet td.dark-border {border-bottom:1px solid #888}
.order-sheet td.total-bgcolor {color:#333; font-weight:600; background:#9ac4eb}
.order-sheet td.cost {padding-right:3px; text-align:right}
.order-sheet td.linetxt {padding-right:3px; text-align:center}
.order-sheet td.beginning-balance {color:#2f6ba9; font-size:14px; font-weight:600; background:#FFC}
.order-sheet tfoot th, .order-sheet tfoot td {height:36px; line-height:36px; text-align:center; font-weight:600; border-bottom:1px solid #000; background:#E8E8E8}
.order-sheet tfoot th {background:#E1E1E1}
.order-sheet tfoot td {font-size:15px;}
.step-contents {margin:0 auto; width:700px}
.step-contents a {display:block; float:left; margin-left:-9px; width:140px; height:27px; line-height:27px; color:#FFF; background:url('../images/common/step-contents.png') no-repeat}
.step-contents a.step-finish {background-position:center 0}
.step-contents a.step-ongoing {background-position:center -30px}
.step-contents a.step-prearrange {background-position:center -60px}
#head_login_btn {cursor:pointer;}
#head_logout_btn {cursor:pointer;}
#pop_login_btn {cursor:pointer;}
.content_hidden {display:none;}
.msg_sound_only, .sound_only {display:inline-block !important;position:absolute;top:0;left:0;margin:0 !important;padding:0 !important;font-size:0;line-height:0;border:0 !important;overflow:hidden !important}
/* 페이징 */
.pg_wrap {clear:both;margin:0 0 20px;padding:20px 0 0;text-align:center}
.pg {}
.pg_page, .pg_current {display:inline-block;padding:0 8px;height:25px;color:#000;letter-spacing:0;line-height:2.2em;vertical-align:middle;padding-left:8px !important;padding-right:8px !important;}
.pg a:focus, .pg a:hover {text-decoration:none}
.pg_page {background:#e4eaec;text-decoration:none}
.pg_start, .pg_prev {/* 이전 */}
.pg_end, .pg_next {/* 다음 */}
.pg_current {display:inline-block;margin:0 4px 0 0;background:#333;color:#fff;font-weight:normal}
</style>
</head>
<body>
<?php
if($uid!=''){
include("buy_list_detail_inc.php");
} else {
include("buy_list_inc.php");
}
?>
</body>
</html>
|