userListExcel.php
1.95 KB
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
<? include $_SERVER["DOCUMENT_ROOT"] . "/common/classes/AdminUser.php" ?>
<?
$_REQUEST["page"] = "-1";
$obj = new AdminUser($_REQUEST, "") ;
$list = $obj->getListOfUserForExcel() ;
header('Content-Disposition: attachment; filename=userList_'.$date.'.xls');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ko">
<META HTTP-EQUIV="imagetoolbar" CONTENT="no"/>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
<title>Application Back Office</title>
<table width="800" border="1" cellpadding="0" cellspacing="0">
<tr>
<td align="center">No</td>
<td align="center">이메일</td>
<td align="center">이름</td>
<td align="center">전화번호</td>
<th width="10%">신청그룹</th>
<th width="5%">VIP<br>회원여부</th>
<th width="5%">멤버쉽<br>회원여부</th>
<td align="center">가입 날짜</td>
</tr>
<? for($i = 0 ; $i < sizeof($list) ; $i++){?>
<tr>
<td align="center" style='mso-number-format:"\@"'><?=sizeof($list)-$i?></td>
<td align="center" style='mso-number-format:"\@"'>
<?
if($list[$i]["regi_type"] == "E")
echo $list[$i]["id"];
else if($list[$i]["regi_type"] == "K")
echo "카카오톡 가입";
else if($list[$i]["regi_type"] == "F")
echo "페이스북 가입";
?>
</td>
<td align="center" style='mso-number-format:"\@"'><?=$list[$i]["name"]?></td>
<td align="center" style='mso-number-format:"\@"'><?=$list[$i]["tel"]?></td>
<td class="center">
<?=$list[$i]["group_name"]?>
</td>
<td class="center">
<?=($list[$i]["member_type"] == "V") ? "O" : "X"?>
</td>
<td class="center">
<?=($list[$i]["member_type"] == "M") ? "O" : "X"?>
</td>
<td align="center" style='mso-number-format:"\@"'><?=$list[$i]["reg_dt"]?></td>
</tr>
<?}?>
</table>