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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
|
<?php
$dir = "..";
include_once($dir."/../common.php");
include_once("./_common2.php");
if(isset($_GET["page"])){
$page = $_GET["page"];
}else{
$page = 1;
}
?>
<style>
#freebies {width:100%;padding:20px;box-sizing:border-box;margin-bottom: 30px;}
#freebies h1 {text-align:center;font-family:'gs',sans-serif;font-size:24px;font-weight:bold;margin-bottom:10px;padding-top:30px;border-top:1px dotted #707070;}
#freebies > ul > li {display:flex;justify-content: space-between;padding:10px;box-sizing:border-box;}
.freeb_cont {background-color:#F1F4FF;margin-bottom:2px;}
.freeb_cont:last-child {margin-bottom:0px;}
.freeb_item {font-size:12px;font-family:'맑은 고딕';text-align:center;}
.freeb_h .freeb_item {font-weight:bold;}
.fb_date {width:2.5em;}
.fb_id {width:3.5em;}
.fb_region {min-width:4em;}
.fb_name {text-align:left;width:3em;}
.freeb_h .fb_name {text-align:center;}
.fb_gift {min-width:67px;}
.fb_icon {width:24px;}
/*목록 페이징*/
#freebies nav {text-align:center;margin-top:20px;}
.pagingul {display:flex;justify-content:center;}
.pagingul li {min-width:36px;height:36px;border:1px solid #ccc;border-right:0px;text-align:center;padding:8px;box-sizing:border-box;}
.pagingul li:last-child{border-right:1px solid #ccc;}
.pagingul li a {display:block;font-size:14px;}
.pagingul li.on {background:#FD7921;}
.pagingul li.on a {color:#ffffff;}
</style>
<section id="freebies">
<h1>사은품 발송 리스트</h1>
<ul>
<!--항목헤더-->
<li class="freeb_h">
<div class="freeb_item fb_date">발송월</div>
<div class="freeb_item fb_id">ID</div>
<div class="freeb_item fb_name">업체명</div>
<div class="freeb_item fb_region">지역</div>
<div class="freeb_item fb_gift">사은품</div>
<div class="freeb_item fb_ship">결과</div>
<div class="freeb_item fb_icon">방식</div>
</li>
<!---->
<?php
//데이터 취득
mysql_query("set session character_set_connection=utf8;");
mysql_query("set session character_set_results=utf8;");
mysql_query("set session character_set_client=utf8;");
$sql = "select COUNT(*) as cnt from delBoard WHERE del_result = '1' order by reg_date DESC";
$res = mysql_query($sql,$connect_web);
$arr = mysql_fetch_array($res);
$total_record = $arr["cnt"];
$list = 30;
$block_cnt = 5;
$block_num = ceil($page/$block_cnt);
$block_start = (($block_num - 1) * $block_cnt) + 1;
$block_end = $block_start + $block_cnt - 1;
$total_page = ceil($total_record/$list);
if($block_end > $total_page){
$block_end = $total_page;
}
$total_block = ceil($total_page/$block_cnt);
$page_start = ($page - 1) * $list;
$sql = "select * from delBoard WHERE del_result = '1' order by reg_date DESC LIMIT $page_start, $list";
$res = mysql_query($sql,$connect_web);
if(!$res){die("error");}
while($row=mysql_fetch_array($res)){
$list_array[] = $row;
}
for($i=0;$i<count($list_array);$i++){
$info = $list_array[$i];
//날짜수정
$datetime = $info['reg_date'];
$rep = str_replace('-','/', $datetime);
$date = ((int)iconv_substr($rep, 5, 2))."월";
//id(최대 6글자표시)
$id = $info['user_id'];
$id_star = iconv_substr($id, 0, 3, "UTF-8").str_repeat('*',3);
//회사이름(최대 4글자표시)
$company = iconv("EUC-KR", "UTF-8", $info['company']);
$company_star = iconv_substr($company, 0, 2, "UTF-8").str_repeat('*',2);
//지역s
$area = iconv("EUC-KR", "UTF-8", $info['user_area']);
//사은품
$gift = $info['gift'];
if($gift == 0) {$gift_txt = "상품권 5만원";} else {$gift_txt = "스타벅스 2잔";}
//발송
$result = $info['del_result'];
if($result == 0) {$result_txt = "미발송"; } else {$result_txt = "발송";}
//배송방식
$method = $info['del_met'];
if($method == 0) {$img = "./images/freebies/kpost.png"; } else {$img = "./images/freebies/kakao.png";}
?>
<li class="freeb_cont">
<div class="freeb_item fb_date"><?php echo $date; ?></div>
<div class="freeb_item fb_id"><?php echo $id_star; ?></div>
<div class="freeb_item fb_name"><?php echo $company_star; ?></div>
<div class="freeb_item fb_region"><?php echo $area; ?></div>
<div class="freeb_item fb_gift"><?php echo $gift_txt; ?></div>
<div class="freeb_item fb_ship"><?php echo $result_txt; ?></div>
<div class="freeb_item fb_icon"><img src="<?php echo $img; ?>" alt="발송 아이콘"></div>
</li>
<?php } ?>
<!--
<li class="freeb_cont">
<div class="freeb_item fb_date">12/30</div>
<div class="freeb_item fb_id">abc***</div>
<div class="freeb_item fb_name">에이**</div>
<div class="freeb_item fb_region">대구</div>
<div class="freeb_item fb_gift">음료2잔</div>
<div class="freeb_item fb_ship">발송</div>
<div class="freeb_item fb_icon"><img src="./images/freebies/kakao.png" alt="카카오톡"></div>
</li>
<li class="freeb_cont">
<div class="freeb_item fb_date">1/19</div>
<div class="freeb_item fb_id">abc***</div>
<div class="freeb_item fb_name">에이**</div>
<div class="freeb_item fb_region">부산</div>
<div class="freeb_item fb_gift">상품권5만원</div>
<div class="freeb_item fb_ship">발송</div>
<div class="freeb_item fb_icon"><img src="./images/freebies/kpost.png" alt="우체국"></div>
</li>
-->
</ul>
<nav>
<ul class="pagingul">
<?php
if($page <= 1){
}else{
$pre = $page - 1;
if(isset($unum)){
echo "<li><a href='customer_satisfaction_test.php?page=$pre'>이전</a></li>";
}else{
echo "<li><a href='customer_satisfaction_test.php?page=$pre'>이전</a></li>";
}
}
for($i = $block_start; $i <= $block_end; $i++){
if($page == $i){
echo "<li><a disabled>$i</a></li>";
}else{
if(isset($unum)){
echo "<li><a href='customer_satisfaction_test.php?page=$i'>$i</a></li>";
}else{
echo "<li><a href='customer_satisfaction_test.php?page=$i'>$i</a></li>";
}
}
}
if($page >= $block_end){
}else{
$next = $page + 1;
if(isset($unum)){
echo "<li><a href='customer_satisfaction_test.php?page=$next'>다음</a></li>";
}else{
echo "<li><a href='customer_satisfaction_test.php?page=$next'>다음</a></li>";
}
}
?>
</ul>
</nav>
</section>
|