vipUserExcelList.php
2.6 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
53
54
55
56
57
58
<? include $_SERVER["DOCUMENT_ROOT"] . "/common/classes/AdminUser.php" ?>
<?
$_REQUEST["page"] = "-1";
$obj = new AdminUser($_REQUEST, "") ;
$list = $obj->getListOfUserForExcel("V") ;
header('Content-Disposition: attachment; filename=vipUserList_'.$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>
<td align="center">소속그룹</td>
<th width="5%">VIP<br>회원여부</th>
<th width="10%">승인 상태</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 align="center" style='mso-number-format:"\@"'><?=$list[$i]["group_name"]?></td>
<td class="center">
<?=($list[$i]["member_type"] == "V") ? "O" : "X"?>
</td>
<td class="center">
<?if($list[$i]["group_fk"] > 0 && $list[$i]["member_type"] == "VH"){ ?>
<input type="button" class="button searchsmall white jBtnV" value="승인" no="<?=$list[$i]["no"]?>" member_type="V"/>
<input type="button" class="button searchsmall white jBtnV" value="거절" no="<?=$list[$i]["no"]?>" member_type="N" />
<?} elseif ($list[$i]["group_fk"] > 0 && $list[$i]["member_type"] == "V"){ ?>
승인
<?} elseif ($list[$i]["group_fk"] > 0 && $list[$i]["member_type"] == "N"){ ?>
거절
<?} else { ?>
-
<?} ?>
</td>
<td align="center" style='mso-number-format:"\@"'><?=$list[$i]["reg_dt"]?></td>
</tr>
<?}?>
</table>